Exemplos de zen_set_salemaker_status em PHP

Exemplo n.º 1

Arquivo: salemaker.php Projeto: wwxgitcat/zencart_v1.0

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();
        }
    }
}

Exemplo n.º 2

Arquivo: salemaker.php Projeto: bitweaver/commerce

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']);
        }
    }
}

Exemplo n.º 3

Arquivo: salemaker.php Projeto: homework-bazaar/zencart-sugu

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();
        }
    }
}