XoopsModules25x / countdown

testdata/index.php

<?php


declare(strict_types=1);


/**

 * You may not change or alter any portion of this comment or credits

 * of supporting developers from this source code or any supporting source code

 * which is considered copyrighted (c) material of the original comment or credit authors.

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

 *

 * @copyright       XOOPS Project (https://xoops.org)

 * @license         GNU GPL 2 (https://www.gnu.org/licenses/old-licenses/gpl-2.0.html)

 * @package

 * @author          Michael Beck (aka Mamba)

 * @author          Goffy - Email:<webmaster@wedega.com>

 */


use Xmf\Database\TableLoad;

use Xmf\Request;

use Xmf\Yaml;

use XoopsModules\Countdown\{

    Helper,

    Common\Configurator,

    Utility

};

/** @var Helper $helper */

/** @var Utility $utility */

/** @var Configurator $configurator */


require_once dirname(__DIR__, 3) . '/include/cp_header.php';

require \dirname(__DIR__) . '/preloads/autoloader.php';


$op = Request::getCmd('op', '');


$moduleDirName = \basename(\dirname(__DIR__));

$moduleDirNameUpper = \mb_strtoupper($moduleDirName);


$helper = Helper::getInstance();

// Load language files

$helper->loadLanguage('common');


switch ($op) {

    case 'load':

        if (Request::hasVar('ok', 'REQUEST') && 1 === Request::getInt('ok', 0)) {

            if (!$GLOBALS['xoopsSecurity']->check()) {

                \redirect_header($helper->url('admin/index.php'), 3, implode(',', $GLOBALS['xoopsSecurity']->getErrors()));

            }

            loadSampleData();

        } else {

            xoops_cp_header();

            xoops_confirm(['ok' => 1, 'op' => 'load'], 'index.php', \sprintf(\constant('CO_' . $moduleDirNameUpper . '_' . 'LOAD_SAMPLEDATA_CONFIRM')), \constant('CO_' . $moduleDirNameUpper . '_' . 'CONFIRM'), true);

            xoops_cp_footer();

        }

        break;

    case 'save':

        saveSampleData();

        break;

    case 'clear':

        clearSampleData();

        break;

}


// XMF TableLoad for SAMPLE data


function loadSampleData()

{

    global $xoopsConfig;

    $moduleDirName      = \basename(\dirname(__DIR__));

    $moduleDirNameUpper = \mb_strtoupper($moduleDirName);


    $utility      = new Utility();

    $configurator = new Configurator();


    $tables = \Xmf\Module\Helper::getHelper($moduleDirName)->getModule()->getInfo('tables');


    $language = 'english/';

    if (\is_dir(__DIR__ . '/' . $xoopsConfig['language'])) {

        $language = $xoopsConfig['language'] . '/';

    }


    // load module tables

    foreach ($tables as $table) {

        $tabledata = Yaml::readWrapped($language . $table . '.yml');

        TableLoad::truncateTable($table);

        TableLoad::loadTableFromArray($table, $tabledata);

    }


    // load permissions

    $table     = 'group_permission';

    $tabledata = Yaml::readWrapped($language . $table . '.yml');

    $mid       = \Xmf\Module\Helper::getHelper($moduleDirName)->getModule()->getVar('mid');

    loadTableFromArrayWithReplace($table, $tabledata, 'gperm_modid', $mid);


    //  ---  COPY test folder files ---------------

    if (\is_array($configurator->copyTestFolders) && \count($configurator->copyTestFolders) > 0) {

        //        $file =  dirname(__DIR__) . '/testdata/images/';

        foreach (\array_keys($configurator->copyTestFolders) as $i) {

            $src  = $configurator->copyTestFolders[$i][0];

            $dest = $configurator->copyTestFolders[$i][1];

            $utility::rcopy($src, $dest);

        }

    }

    \redirect_header('../admin/index.php', 1, \constant('CO_' . $moduleDirNameUpper . '_' . 'LOAD_SAMPLEDATA_SUCCESS'));

}


function saveSampleData()

{

    global $xoopsConfig;

    $moduleDirName      = \basename(\dirname(__DIR__));

    $moduleDirNameUpper = \mb_strtoupper($moduleDirName);

    $helper             = Helper::getInstance();

    $tables             = $helper->getModule()->getInfo('tables');


    $languageFolder = __DIR__ . '/' . $xoopsConfig['language'];

    if (!\file_exists($languageFolder . '/')) {

        Utility::createFolder($languageFolder . '/');

    }

    $exportFolder = $languageFolder . '/Exports-' . date('Y-m-d-H-i-s') . '/';

    Utility::createFolder($exportFolder);


    // save module tables

    foreach ($tables as $table) {

        TableLoad::saveTableToYamlFile($table, $exportFolder . $table . '.yml');

    }


    // save permissions

    $criteria = new \CriteriaCompo();

    $criteria->add(new \Criteria('gperm_modid', $helper->getModule()->getVar('mid')));

    $skipColumns[] = 'gperm_id';

$skipColumns was never initialized. Although not strictly required by PHP, it is generally a good practice to add $skipColumns = array(); before regardless.

    TableLoad::saveTableToYamlFile('group_permission', $exportFolder . 'group_permission.yml', $criteria, $skipColumns);

    unset($criteria);


    \redirect_header('../admin/index.php', 1, \constant('CO_' . $moduleDirNameUpper . '_' . 'SAVE_SAMPLEDATA_SUCCESS'));

}


function exportSchema()

{

    $moduleDirName      = \basename(\dirname(__DIR__));

    $moduleDirNameUpper = \mb_strtoupper($moduleDirName);


    try {

        // TODO set exportSchema

        //        $migrate = new Migrate($moduleDirName);

        //        $migrate->saveCurrentSchema();

        //

        //        redirect_header('../admin/index.php', 1, constant('CO_' . $moduleDirNameUpper . '_' . 'EXPORT_SCHEMA_SUCCESS'));

    } catch (\Throwable $e) {

        exit(constant('CO_' . $moduleDirNameUpper . '_' . 'EXPORT_SCHEMA_ERROR'));

    }

}


/**

 * loadTableFromArrayWithReplace

 *

 * @param string $table  value with should be used insead of original value of $search

 *

 * @param array  $data   array of rows to insert

 *                       Each element of the outer array represents a single table row.

 *                       Each row is an associative array in 'column' => 'value' format.

 * @param string $search name of column for which the value should be replaced

 * @param        $replace

 * @return int number of rows inserted

 */

function loadTableFromArrayWithReplace($table, $data, $search, $replace)

{

    /** @var \XoopsMySQLDatabase $db */

    $db = \XoopsDatabaseFactory::getDatabaseConnection();


    $prefixedTable = $db->prefix($table);

    $count         = 0;


    $sql = 'DELETE FROM ' . $prefixedTable . ' WHERE `' . $search . '`=' . $db->quote($replace);


    $result = $db->queryF($sql);


    if ($result) {

        foreach ($data as $row) {

            $insertInto  = 'INSERT INTO ' . $prefixedTable . ' (';

            $valueClause = ' VALUES (';

            $first       = true;

            foreach ($row as $column => $value) {

                if ($first) {

                    $first = false;

                } else {

                    $insertInto  .= ', ';

                    $valueClause .= ', ';

                }


                $insertInto .= $column;

                if ($search === $column) {

                    $valueClause .= $db->quote($replace);

                } else {

                    $valueClause .= $db->quote($value);

                }

            }


            $sql = $insertInto . ') ' . $valueClause . ')';


            $result = $db->queryF($sql);

            if (false !== $result) {

                ++$count;

            }

        }

    }

    return $count;

}


function clearSampleData()

{

    $moduleDirName      = \basename(\dirname(__DIR__));

    $moduleDirNameUpper = \mb_strtoupper($moduleDirName);

    $helper             = Helper::getInstance();

    // Load language files

    $helper->loadLanguage('common');

    $tables = $helper->getModule()->getInfo('tables');

    // truncate module tables

    foreach ($tables as $table) {

        \Xmf\Database\TableLoad::truncateTable($table);

    }

    redirect_header($helper->url('admin/index.php'), 1, constant('CO_' . $moduleDirNameUpper . '_' . 'CLEAR_SAMPLEDATA_OK'));

}