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();
}
}
}
if ($salemaker_sales->RecordCount() > 0) {
$sql_data_array = array('sale_id' => 'null', 'sale_status' => 0, 'sale_name' => $newname, 'sale_date_added' => 'now()', 'sale_date_last_modified' => '0001-01-01', 'sale_date_status_change' => '0001-01-01', 'sale_deduction_value' => (double) $salemaker_sales->fields['sale_deduction_value'], 'sale_deduction_type' => (double) $salemaker_sales->fields['sale_deduction_type'], 'sale_pricerange_from' => (double) $salemaker_sales->fields['sale_pricerange_from'], 'sale_pricerange_to' => (double) $salemaker_sales->fields['sale_pricerange_to'], 'sale_specials_condition' => (int) $salemaker_sales->fields['sale_specials_condition'], 'sale_categories_selected' => $salemaker_sales->fields['sale_categories_selected'], 'sale_categories_all' => $salemaker_sales->fields['sale_categories_all'], 'sale_date_start' => $salemaker_sales->fields['sale_date_start'], 'sale_date_end' => $salemaker_sales->fields['sale_date_end']);
zen_db_perform(TABLE_SALEMAKER_SALES, $sql_data_array, 'insert');
$sale_id = $db->Insert_ID();
// update prices for products in sale
zen_update_salemaker_product_prices($sale_id);
}
}
zen_redirect(zen_href_link(FILENAME_SALEMAKER, 'page=' . $_GET['page'] . '&sID=' . $db->Insert_ID()));
break;
case 'deleteconfirm':
$sale_id = zen_db_prepare_input($_GET['sID']);
// set sale off to update prices before removing
$db->Execute("update " . TABLE_SALEMAKER_SALES . " set sale_status=0 where sale_id='" . $sale_id . "'");
// update prices for products in sale
zen_update_salemaker_product_prices($sale_id);
$db->Execute("delete from " . TABLE_SALEMAKER_SALES . " where sale_id = '" . (int) $sale_id . "'");
zen_redirect(zen_href_link(FILENAME_SALEMAKER, 'page=' . $_GET['page']));
break;
}
}
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php
echo HTML_PARAMS;
?>
>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php
echo CHARSET;
?>
