public function hookAddColumnTenderModule()
{
CoreLocal::refresh();
CoreState::loadParams();
$current_map = CoreLocal::get('TenderMap');
$update = $this->connection->prepare('
UPDATE tenders
SET TenderModule=?
WHERE TenderCode=?
');
foreach ($current_map as $code => $module) {
$this->connection->execute($update, array($module, $code));
}
}
<?php
include realpath(dirname(__FILE__) . '/../lib/AutoLoader.php');
AutoLoader::loadMap();
include '../ini.php';
CoreState::loadParams();
include 'InstallUtilities.php';
?>
<html>
<head>
<title>Debug Settings</title>
<style type="text/css">
body {
line-height: 1.5em;
}
</style>
</head>
<body>
<?php
include 'tabs.php';
?>
<div id="wrapper">
<h2>IT CORE Lane Installation: Debug Settings</h2>
<b>Logs</b><br />
Default logs:
<ul>
<li><i>php-errors.log</i> contains PHP errors, warnings, notices, etc depending on error reporting settings for PHP installation.</li>
<li><i>queries.log</i> lists failed queries</li>
</ul>
<div class="alert"><?php
InstallUtilities::checkWritable('../log/php-errors.log');
/**
Create opdata tables and views
@param $db [SQLManager] database connection
@param $name [string] database name
@return [array] of error messages
*/
public static function createOpDBs($db, $name)
{
$errors = array();
if (CoreLocal::get('laneno') == 0) {
$errors[] = array('struct' => 'No structures created for lane #0', 'query' => 'None', 'details' => 'Zero is reserved for server');
return $errors;
}
$models = array('\\COREPOS\\pos\\lib\\models\\op\\AutoCouponsModel', '\\COREPOS\\pos\\lib\\models\\op\\CouponCodesModel', '\\COREPOS\\pos\\lib\\models\\op\\CustdataModel', '\\COREPOS\\pos\\lib\\models\\op\\CustomerNotificationsModel', '\\COREPOS\\pos\\lib\\models\\op\\CustPreferencesModel', '\\COREPOS\\pos\\lib\\models\\op\\CustReceiptMessageModel', '\\COREPOS\\pos\\lib\\models\\op\\CustomReceiptModel', '\\COREPOS\\pos\\lib\\models\\op\\DateRestrictModel', '\\COREPOS\\pos\\lib\\models\\op\\DepartmentsModel', '\\COREPOS\\pos\\lib\\models\\op\\DisableCouponModel', '\\COREPOS\\pos\\lib\\models\\op\\DrawerOwnerModel', '\\COREPOS\\pos\\lib\\models\\op\\EmployeesModel', '\\COREPOS\\pos\\lib\\models\\op\\GlobalValuesModel', '\\COREPOS\\pos\\lib\\models\\op\\HouseCouponsModel', '\\COREPOS\\pos\\lib\\models\\op\\HouseCouponItemsModel', '\\COREPOS\\pos\\lib\\models\\op\\HouseVirtualCouponsModel', '\\COREPOS\\pos\\lib\\models\\op\\IgnoredBarcodesModel', '\\COREPOS\\pos\\lib\\models\\op\\MasterSuperDeptsModel', '\\COREPOS\\pos\\lib\\models\\op\\MemberCardsModel', '\\COREPOS\\pos\\lib\\models\\op\\MemtypeModel', '\\COREPOS\\pos\\lib\\models\\op\\ParametersModel', '\\COREPOS\\pos\\lib\\models\\op\\ProductsModel', '\\COREPOS\\pos\\lib\\models\\op\\ShrinkReasonsModel', '\\COREPOS\\pos\\lib\\models\\op\\SpecialDeptMapModel', '\\COREPOS\\pos\\lib\\models\\op\\SubDeptsModel', '\\COREPOS\\pos\\lib\\models\\op\\TendersModel', '\\COREPOS\\pos\\lib\\models\\op\\UnpaidArTodayModel', '\\COREPOS\\pos\\lib\\models\\op\\MemberCardsViewModel');
foreach ($models as $class) {
$obj = new $class($db);
$errors[] = $obj->createIfNeeded($name);
}
$sample_data = array('couponcodes', 'globalvalues', 'parameters', 'tenders');
foreach ($sample_data as $table) {
$chk = $db->query('SELECT * FROM ' . $table, $name);
if (!$db->fetch_row($chk)) {
$loaded = self::loadSampleData($db, $table, true);
if (!$loaded) {
$errors[] = array('struct' => $table, 'query' => 'None', 'details' => 'Failed loading sample data');
}
} else {
$db->end_query($chk);
}
}
$chk = $db->query('SELECT drawer_no FROM drawerowner', $name);
if ($db->num_rows($chk) == 0) {
$db->query('INSERT INTO drawerowner (drawer_no) VALUES (1)', $name);
$db->query('INSERT INTO drawerowner (drawer_no) VALUES (2)', $name);
}
CoreState::loadParams();
return $errors;
}
