File: files/commonfiles/testdata/index.php

Recommend this page to a friend!
  Classes of Goffy G  >  XOOPS Modules Builder  >  files/commonfiles/testdata/index.php  >  Download  
File: files/commonfiles/testdata/index.php
Role: Example script
Content type: text/plain
Description: Example script
Class: XOOPS Modules Builder
Generate new modules for the XOOPS CMS
Author: By
Last change:
Date: 2 months ago
Size: 7,461 bytes
 

Contents

Class file image Download
<?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.
 *
 * @copyright The XOOPS Project http://sourceforge.net/projects/xoops/
 * @license GNU GPL 2 (http://www.gnu.org/licenses/old-licenses/gpl-2.0.html)
 * @package
 * @since 2.5.9
 * @author Michael Beck (aka Mamba)
 */

use XoopsModules\Modulebuilder;
use
XoopsModules\Modulebuilder\Common;
use
XoopsModules\Modulebuilder\Utility;

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

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

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

$helper = Modulebuilder\Helper::getInstance();
// Load language files
$helper->loadLanguage('common');

switch (
$op) {
    case
'load':
        if (\
Xmf\Request::hasVar('ok', 'REQUEST') && 1 == $_REQUEST['ok']) {
            if (!
$GLOBALS['xoopsSecurity']->check()) {
                \
redirect_header('../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 Modulebuilder\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 = \Xmf\Yaml::readWrapped($language . $table . '.yml');
        \
Xmf\Database\TableLoad::truncateTable($table);
        \
Xmf\Database\TableLoad::loadTableFromArray($table, $tabledata);
    }
   
   
// load permissions
   
$table = 'group_permission';
   
$tabledata = \Xmf\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 = __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 . '_' . 'SAMPLEDATA_SUCCESS'));
}

function
saveSampleData()
{
    global
$xoopsConfig;
   
   
$configurator = new Common\Configurator();

   
$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) {
        \
Xmf\Database\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';
    \
Xmf\Database\TableLoad::saveTableToYamlFile('group_permission', $exportFolder . 'group_permission.yml', $criteria, $skipColumns);
    unset(
$criteria);
   
   
// --- COPY test folder files ---------------
   
if (\is_array($configurator->copyTestFolders) && \count($configurator->copyTestFolders) > 0) {
        foreach (\
array_keys($configurator->copyTestFolders) as $i) {
           
$src = $configurator->copyTestFolders[$i][1];
           
$dest = $configurator->copyTestFolders[$i][0];
           
Utility::rcopy($src, $dest);
        }
    }
    \
redirect_header('../admin/index.php', 1, \constant('CO_' . $moduleDirNameUpper . '_' . 'SAMPLEDATA_SUCCESS'));
}

function
exportSchema()
{
   
$moduleDirName = \basename(\dirname(__DIR__));
   
$moduleDirNameUpper = \mb_strtoupper($moduleDirName);

    try {
       
// TODO set exportSchema
        // $migrate = new Modulebuilder\Migrate($moduleDirName);
        // $migrate->saveCurrentSchema();
        //
        // \redirect_header('../admin/index.php', 1, \constant('CO_' . $moduleDirNameUpper . '_' . 'EXPORT_SCHEMA_SUCCESS'));
   
} catch (\Exception $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 \XoopsDatabase */
   
$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;
}


For more information send a message to info at phpclasses dot org.