Zen Cart 源代码 salemaker.php

下载文件

文件名: salemaker.php
文件类型: PHP文件
文件大小: 3.2 KiB
MD5: 36a1ba2ed2e193990210e8380f0a5bc4

salemaker.php - 打开高亮: <?php /** * salemaker functions * * @package functions * @copyright Copyright 2003-2010 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: salemaker.php 15974 2010-04-17 00:29:17Z ajeh $ */ //// // Set the status of a salemaker sale function zen_set_salemaker_status($sale_id, $status) { global $db; $sql = "update " . TABLE_SALEMAKER_SALES . " set sale_status = '" . (int)$status . "', sale_date_status_change = now() where sale_id = '" . (int)$sale_id . "'"; return $db->Execute($sql); } //// // Auto expire salemaker sales function zen_expire_salemaker() { global $db; $date_range = time(); $zc_sale_date = date('Ymd', $date_range); $salemaker_query = "select sale_id from " . TABLE_SALEMAKER_SALES . " where sale_status = '1' and ((" . $zc_sale_date . " >= sale_date_end and sale_date_end != '0001-01-01') or (" . $zc_sale_date . " < sale_date_start and sale_date_start != '0001-01-01'))"; $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(); } } } //// // Auto start salemaker sales function zen_start_salemaker() { global $db; $date_range = time(); $zc_sale_date = date('Ymd', $date_range); $salemaker_query = "select sale_id from " . TABLE_SALEMAKER_SALES . " where sale_status = '0' and (((sale_date_start <= " . $zc_sale_date . " and sale_date_start != '0001-01-01') and (sale_date_end > " . $zc_sale_date . ")) or ((sale_date_start <= " . $zc_sale_date . " and sale_date_start != '0001-01-01') and (sale_date_end = '0001-01-01')) or (sale_date_start = '0001-01-01' and sale_date_end > " . $zc_sale_date . ")) "; $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 from " . TABLE_SALEMAKER_SALES . " where sale_status = '1' and (" . $zc_sale_date . " < sale_date_start and sale_date_start != '0001-01-01') "; $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(); } } } ?>