function zen_start_salemaker() { global $db; $date_range = time(); $zc_sale_date = date('Ymd', $date_range); $salemaker_query = "select sale_id\n from " . TABLE_SALEMAKER_SALES . "\n where sale_status = '0'\n and (((sale_date_start <= " . $zc_sale_date . " and sale_date_start != '0001-01-01') and (sale_date_end > " . $zc_sale_date . "))\n or ((sale_date_start <= " . $zc_sale_date . " and sale_date_start != '0001-01-01') and (sale_date_end = '0001-01-01'))\n or (sale_date_start = '0001-01-01' and sale_date_end > " . $zc_sale_date . "))\n "; $salemaker = $db->Execute($salemaker_query); if ($salemaker->RecordCount() > 0) { while (!$salemaker->EOF) { zen_set_salemaker_status($salemaker->fields['sale_id'], '1'); zen_update_salemaker_product_prices($salemaker->fields['sale_id']); $salemaker->MoveNext(); } } // turn off salemaker sales if not active yet $salemaker_query = "select sale_id\n from " . TABLE_SALEMAKER_SALES . "\n where sale_status = '1'\n and (" . $zc_sale_date . " < sale_date_start and sale_date_start != '0001-01-01')\n "; $salemaker = $db->Execute($salemaker_query); if ($salemaker->RecordCount() > 0) { while (!$salemaker->EOF) { zen_set_salemaker_status($salemaker->fields['sale_id'], '0'); zen_update_salemaker_product_prices($salemaker->fields['sale_id']); $salemaker->MoveNext(); } } }
function zen_start_salemaker() { global $gBitDb; $salemaker_query = "select `sale_id`\n from " . TABLE_SALEMAKER_SALES . "\n where `sale_status` = '0'\n and (((`sale_date_start` <= 'NOW' and `sale_date_start` != '0001-01-01') and (`sale_date_end` >= 'NOW'))\n or ((`sale_date_start` <= 'NOW' and `sale_date_start` != '0001-01-01') and (`sale_date_end` = '0001-01-01'))\n or (`sale_date_start` = '0001-01-01' and `sale_date_end` >= 'NOW'))\n "; if ($rs = $gBitDb->query($salemaker_query)) { while ($salemaker = $rs->fetchRow()) { zen_set_salemaker_status($salemaker['sale_id'], '1'); zen_update_salemaker_product_prices($salemaker['sale_id']); } } // turn off salemaker sales if not active yet $salemaker_query = "select `sale_id`\n from " . TABLE_SALEMAKER_SALES . "\n where `sale_status` = '1'\n and ('NOW' < `sale_date_start` and `sale_date_start` != '0001-01-01')\n "; if ($rs = $gBitDb->query($salemaker_query)) { while ($salemaker = $rs->fetchRow()) { zen_set_salemaker_status($salemaker['sale_id'], '0'); zen_update_salemaker_product_prices($salemaker['sale_id']); } } }
function zen_start_salemaker() { global $db; $salemaker_query = "select sale_id\r\n from " . TABLE_SALEMAKER_SALES . "\r\n where sale_status = '0'\r\n and (((sale_date_start <= now() and sale_date_start != '0001-01-01') and (sale_date_end >= now()))\r\n or ((sale_date_start <= now() and sale_date_start != '0001-01-01') and (sale_date_end = '0001-01-01'))\r\n or (sale_date_start = '0001-01-01' and sale_date_end >= now()))\r\n and CURDATE() > sale_date_status_change\r\n "; $salemaker = $db->Execute($salemaker_query); if ($salemaker->RecordCount() > 0) { while (!$salemaker->EOF) { zen_set_salemaker_status($salemaker->fields['sale_id'], '1'); zen_update_salemaker_product_prices($salemaker->fields['sale_id']); $salemaker->MoveNext(); } } // turn off salemaker sales if not active yet $salemaker_query = "select sale_id\r\n from " . TABLE_SALEMAKER_SALES . "\r\n where sale_status = '1'\r\n and (now() < sale_date_start and sale_date_start != '0001-01-01')\r\n "; $salemaker = $db->Execute($salemaker_query); if ($salemaker->RecordCount() > 0) { while (!$salemaker->EOF) { zen_set_salemaker_status($salemaker->fields['sale_id'], '0'); zen_update_salemaker_product_prices($salemaker->fields['sale_id']); $salemaker->MoveNext(); } } }