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.");