testdata/index.php
<?php
/*
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.
*/
/**
* Module: wfdownloads
*
* @category Module
* @package Wfdownloads
* @author XOOPS Development Team <https://xoops.org>
* @copyright {@link https://xoops.org/ XOOPS Project}
* @license GPL 2.0 or later
* @link https://xoops.org/
* @since 1.0.0
*/
use Xmf\Database\TableLoad;
use \Xmf\Request;
use Xmf\Yaml;
use XoopsModules\Wfdownloads\{
Common,
Helper,
Utility
};
/** @var Helper $helper */
/** @var Utility $utility */
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 . '_' . 'ADD_SAMPLEDATA_OK')), constant('CO_' . $moduleDirNameUpper . '_' . 'CONFIRM'), true);
xoops_cp_footer();
}
break;
case 'save':
saveSampleData();
break;
}
// XMF TableLoad for SAMPLE data
function loadSampleData()
{
global $xoopsConfig;
$moduleDirName = basename(dirname(__DIR__));
$moduleDirNameUpper = mb_strtoupper($moduleDirName);
$utility = new Utility();
$configurator = new Common\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 . '_' . 'SAVE_SAMPLEDATA_SUCCESS'));
}
function saveSampleData()
{
global $xoopsConfig;
$moduleDirName = basename(dirname(__DIR__));
$moduleDirNameUpper = mb_strtoupper($moduleDirName);
$tables = \Xmf\Module\Helper::getHelper($moduleDirName)->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', \Xmf\Module\Helper::getHelper($moduleDirName)->getModule()->getVar('mid')));
$skipColumns[] = 'gperm_id';
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);
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;
}