function preprocess()
{
$table = FormLib::get('tablename', '');
$othertable = FormLib::get('othertable', '');
if ($table === '' && $othertable !== '') {
$table = $othertable;
}
$sync = \COREPOS\Fannie\API\data\SyncLanes::pushTable($table);
$this->results = "<p>Syncing table {$table} <br />";
if ($sync['sending'] === true) {
$this->results .= $sync['messages'];
} else {
$this->errors .= $sync['messages'];
}
$this->results .= '</p>';
return true;
}
public function run()
{
global $FANNIE_COOP_ID, $FANNIE_COMPOSE_LONG_PRODUCT_DESCRIPTION;
set_time_limit(0);
foreach (array('valutecRequest', 'valutecRequestMod', 'valutecResponse') as $table) {
$result = SyncLanes::pullTable("{$table}", 'trans', SyncLanes::TRUNCATE_SOURCE);
/**
@severity: error message may indicate lane down or connectivity problem
*/
$severity = strstr($result['messages'], 'Error:') ? FannieTask::TASK_LARGE_ERROR : FannieTask::TASK_NO_ERROR;
$this->cronMsg($result['messages'], $severity);
}
$regularPushTables = array('products', 'custdata', 'memberCards', 'custReceiptMessage', 'CustomerNotifications', 'employees', 'departments', 'houseCoupons', 'houseVirtualCoupons');
foreach ($regularPushTables as $table) {
$result = SyncLanes::pushTable("{$table}", 'op', SyncLanes::TRUNCATE_DESTINATION);
/**
@severity: error message may indicate lane down or connectivity problem
*/
$severity = strstr($result['messages'], 'Error:') ? FannieTask::TASK_LARGE_ERROR : FannieTask::TASK_NO_ERROR;
$this->cronMsg($result['messages'], $severity);
}
if (isset($FANNIE_COMPOSE_LONG_PRODUCT_DESCRIPTION) && $FANNIE_COMPOSE_LONG_PRODUCT_DESCRIPTION == true) {
$result = SyncLanes::pushTable('productUser', 'op', SyncLanes::TRUNCATE_DESTINATION);
/**
@severity: error message may indicate lane down or connectivity problem
*/
$severity = strstr($result['messages'], 'Error:') ? FannieTask::TASK_LARGE_ERROR : FannieTask::TASK_NO_ERROR;
$this->cronMsg($result['messages'], $severity);
}
if (isset($FANNIE_COOP_ID) && $FANNIE_COOP_ID == 'WEFC_Toronto') {
$result = SyncLanes::pushTable('tenders', 'op', SyncLanes::TRUNCATE_DESTINATION);
/**
@severity: error message may indicate lane down or connectivity problem
*/
$severity = strstr($result['messages'], 'Error:') ? FannieTask::TASK_LARGE_ERROR : FannieTask::TASK_NO_ERROR;
$this->cronMsg($result['messages'], $severity);
}
}
public function run()
{
global $FANNIE_OP_DB;
$dbc = FannieDB::get($FANNIE_OP_DB);
$dbc->query('DELETE FROM QuickLookups WHERE lookupSet=708 AND sequence < 32766');
$r = $dbc->query('
SELECT 708, u.description, p.upc, TO_DAYS(expires)-(1970*365)
FROM products AS p
INNER JOIN productUser AS u ON p.upc=u.upc
LEFT JOIN productExpires AS e ON p.upc=e.upc
WHERE p.department=708 AND CURDATE() <= e.expires
ORDER BY u.description');
$insP = $dbc->prepare('
INSERT INTO QuickLookups
(lookupSet, label, action, sequence)
VALUES (?, ?, ?, ?)');
$seq = 0;
while ($w = $dbc->fetchRow($r)) {
$dbc->execute($insP, array(708, $w['description'], $w['upc'], $seq));
$seq++;
}
$success = \COREPOS\Fannie\API\data\SyncLanes::pushTable('QuickLookups');
}
function results_content()
{
\COREPOS\Fannie\API\data\SyncLanes::pushTable('products');
$ret = '<p>Import Complete</p>';
$ret .= '<div class="alert alert-success">Updated ' . $this->stats['done'] . ' likecodes</div>';
if (count($this->stats['error']) > 0) {
$ret .= '<div class="alert alert-danger"><ul>';
foreach ($this->stats['error'] as $error) {
$ret .= '<li>' . $error . '</li>';
}
$ret .= '</ul></div>';
}
return $ret;
}
*/
// set class alias so lines don't get too long
use COREPOS\Fannie\API\data\SyncLanes;
include dirname(__FILE__) . '/../config.php';
if (!class_exists('FannieAPI')) {
include $FANNIE_ROOT . 'classlib2.0/FannieAPI.php';
}
if (!function_exists('cron_msg')) {
include $FANNIE_ROOT . 'src/cron_msg.php';
}
set_time_limit(0);
foreach (array('valutecRequest', 'valutecRequestMod', 'valutecResponse') as $table) {
$result = SyncLanes::pull_table("{$table}", 'trans', SyncLanes::TRUNCATE_SOURCE);
echo cron_msg($result['messages']);
}
$regularPushTables = array('products', 'custdata', 'memberCards', 'custReceiptMessage', 'CustomerNotifications', 'employees', 'departments', 'houseCoupons', 'houseCouponItems', 'houseVirtualCoupons');
foreach ($regularPushTables as $table) {
$result = SyncLanes::push_table("{$table}", 'op', SyncLanes::TRUNCATE_DESTINATION);
echo cron_msg($result['messages']);
}
if (isset($FANNIE_COMPOSE_LONG_PRODUCT_DESCRIPTION) && $FANNIE_COMPOSE_LONG_PRODUCT_DESCRIPTION == True) {
$result = SyncLanes::push_table('productUser', 'op', SyncLanes::TRUNCATE_DESTINATION);
echo cron_msg($result['messages']);
}
if (isset($FANNIE_COOP_ID) && $FANNIE_COOP_ID == 'WEFC_Toronto') {
$result = SyncLanes::push_table('tenders', 'op', SyncLanes::TRUNCATE_DESTINATION);
echo cron_msg($result['messages']);
$result = SyncLanes::push_table('memtype', 'op', SyncLanes::TRUNCATE_DESTINATION);
echo cron_msg($result['messages']);
}
echo cron_msg(basename(__FILE__) . " done.");
