Zen Cart 源代码 specials.php

下载文件

文件名: specials.php
文件类型: PHP文件
文件大小: 3.33 KiB
MD5: 647dd74a6514179fab07c45aaa282714

specials.php - 打开高亮: <?php /** * product-specials 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: specials.php 15974 2010-04-17 00:29:17Z ajeh $ */ //// // Set the status of a product on special function zen_set_specials_status($specials_id, $status) { global $db; $sql = "update " . TABLE_SPECIALS . " set status = '" . $status . "', date_status_change = now() where specials_id = '" . (int)$specials_id . "'"; return $db->Execute($sql); } //// // Auto expire products on special function zen_expire_specials() { global $db; $date_range = time(); $zc_specials_date = date('Ymd', $date_range); $specials_query = "select specials_id, products_id from " . TABLE_SPECIALS . " where status = '1' and ((" . $zc_specials_date . " >= expires_date and expires_date != '0001-01-01') or (" . $zc_specials_date . " < specials_date_available and specials_date_available != '0001-01-01'))"; $specials = $db->Execute($specials_query); if ($specials->RecordCount() > 0) { while (!$specials->EOF) { zen_set_specials_status($specials->fields['specials_id'], '0'); zen_update_products_price_sorter($specials->fields['products_id']); $specials->MoveNext(); } } } //// // Auto start products on special function zen_start_specials() { global $db; $date_range = time(); $zc_specials_date = date('Ymd', $date_range); // turn on special if active $specials_query = "select specials_id, products_id from " . TABLE_SPECIALS . " where status = '0' and (((specials_date_available <= " . $zc_specials_date . " and specials_date_available != '0001-01-01') and (expires_date > " . $zc_specials_date . ")) or ((specials_date_available <= " . $zc_specials_date . " and specials_date_available != '0001-01-01') and (expires_date = '0001-01-01')) or (specials_date_available = '0001-01-01' and expires_date > " . $zc_specials_date . ")) "; $specials = $db->Execute($specials_query); if ($specials->RecordCount() > 0) { while (!$specials->EOF) { zen_set_specials_status($specials->fields['specials_id'], '1'); zen_update_products_price_sorter($specials->fields['products_id']); $specials->MoveNext(); } } // turn off special if not active yet $specials_query = "select specials_id, products_id from " . TABLE_SPECIALS . " where status = '1' and (" . $zc_specials_date . " < specials_date_available and specials_date_available != '0001-01-01') "; $specials = $db->Execute($specials_query); if ($specials->RecordCount() > 0) { while (!$specials->EOF) { zen_set_specials_status($specials->fields['specials_id'], '0'); zen_update_products_price_sorter($specials->fields['products_id']); $specials->MoveNext(); } } } ?>