function WeberpToOpenCartDailySync($ShowMessages, $db, $db_oc, $oc_tableprefix, $EmailText = '')
{
$begintime = time_start();
DB_Txn_Begin($db);
// check last time we run this script, so we know which records need to update from OC to webERP
$LastTimeRun = CheckLastTimeRun('WeberpToOpenCartDaily', $db);
if ($ShowMessages) {
$TimeDifference = Get_SQL_to_PHP_time_difference($db);
prnMsg('This script was last run on: ' . $LastTimeRun . ' Server time difference: ' . $TimeDifference, 'success');
prnMsg('Server time now: ' . GetServerTimeNow($TimeDifference), 'success');
}
if ($EmailText != '') {
$EmailText = $EmailText . 'webERP to OpenCart Daily Sync was last run on: ' . $LastTimeRun . "\n" . PrintTimeInformation($db);
}
// maintain outlet category in webERP
// Not needed because now in weberp one item only belongs to 1 sales category, so no chance to have more than one to clean up
// $EmailText = MaintainWeberpOutletSalesCategories($ShowMessages, $LastTimeRun, $db, $db_oc, $oc_tableprefix, $EmailText);
// do all hourly maintenance as well...
$EmailText = WeberpToOpenCartHourlySync($ShowMessages, $db, $db_oc, $oc_tableprefix, FALSE, $EmailText);
// recreate the list of featured in OpenCart
$EmailText = SyncFeaturedList($ShowMessages, $LastTimeRun, $db, $db_oc, $oc_tableprefix, $EmailText);
// update sales categories
$EmailText = SyncSalesCategories($ShowMessages, $LastTimeRun, $db, $db_oc, $oc_tableprefix, $EmailText);
// activate / inactivate categories depending on items No items = inactive. Items = Active
$EmailText = ActivateCategoryDependingOnQOH($ShowMessages, $LastTimeRun, $db, $db_oc, $oc_tableprefix, $EmailText);
// maintain the outlet category in a special way (both webERP and OC)
// $EmailText = MaintainOpenCartOutletSalesCategories($ShowMessages, $LastTimeRun, $db, $db_oc, $oc_tableprefix, $EmailText);
// assign multiple images to products
$EmailText = SyncMultipleImages($ShowMessages, $LastTimeRun, $db, $db_oc, $oc_tableprefix, $EmailText);
// assign related items
$EmailText = SyncRelatedItems($ShowMessages, $LastTimeRun, $db, $db_oc, $oc_tableprefix, $EmailText);
// We are done!
SetLastTimeRun('WeberpToOpenCartDaily', $db);
DB_Txn_Commit($db);
if ($ShowMessages) {
time_finish($begintime);
}
return $EmailText;
}
<?php
define("VERSIONFILE", "1.10");
/* Session started in session.inc for password checking and authorisation level check
config.php is in turn included in session.inc*/
include 'includes/session.inc';
$Title = _('webERP to OpenCart Hourly Synchronizer ' . VERSIONFILE);
include 'includes/header.inc';
include 'includes/GetPrice.inc';
include 'includes/KLGeneralFunctions.php';
include 'includes/WeberpOpenCartDefines.php';
include 'includes/OpenCartGeneralFunctions.php';
include 'includes/WeberpToOpenCartSync.php';
include 'includes/OpenCartConnectDB.php';
WeberpToOpenCartHourlySync(TRUE, $db, $db_oc, $oc_tableprefix, TRUE, '');
include 'includes/footer.inc';
