90 lines
2.0 KiB
PHP
90 lines
2.0 KiB
PHP
<?php
|
|
$_SERVER['HTTP_HOST'] = 'www.bebeboutik.com';
|
|
include dirname(__FILE__).'/www/config/config.inc.php';
|
|
|
|
$longopts = array(
|
|
'verbose',
|
|
'dry-run',
|
|
'debug',
|
|
'category:',
|
|
);
|
|
$shortopts = "";
|
|
$options = getopt($shortopts, $longopts);
|
|
|
|
// Options
|
|
$optVerbose = false;
|
|
if (isset($options['verbose'])) {
|
|
$optVerbose = true;
|
|
}
|
|
|
|
$optTest = false;
|
|
if (isset($options['dry-run'])) {
|
|
$optTest = true;
|
|
}
|
|
|
|
$optDebug = false;
|
|
if (isset($options['debug'])) {
|
|
$optDebug = true;
|
|
}
|
|
|
|
$optAuto = false;
|
|
if (count($options) > 0) {
|
|
$category = false;
|
|
if (isset($options['category'])) {
|
|
$category = $options['category'];
|
|
}
|
|
if (empty($category)) {
|
|
echo "No category selected\n";
|
|
exit;
|
|
}
|
|
} else {
|
|
$optAuto = true;
|
|
}
|
|
|
|
if ($optAuto === true) {
|
|
$min_id_product = Db::getInstance()->getValue('
|
|
SELECT MIN(`id_product`) FROM `'._DB_PREFIX_.'product` WHERE `date_add` > DATE_SUB(NOW(), INTERVAL 10 DAY)
|
|
');
|
|
Db::getInstance()->ExecuteS('
|
|
DELETE FROM `'._DB_PREFIX_.'product_ps_cache`
|
|
WHERE `id_product` >= '.$min_id_product.'
|
|
');
|
|
|
|
Db::getInstance()->ExecuteS('
|
|
INSERT IGNORE INTO `'._DB_PREFIX_.'product_ps_cache` (
|
|
SELECT p.id_product, IFNULL(
|
|
(
|
|
SELECT s.id_sale
|
|
FROM `'._DB_PREFIX_.'privatesale_category` s
|
|
WHERE s.`id_category` = p.`id_category_default`
|
|
LIMIT 1)
|
|
, 0
|
|
)
|
|
FROM `'._DB_PREFIX_.'product` p
|
|
WHERE p.`id_product` >= '.$min_id_product.'
|
|
)
|
|
');
|
|
}
|
|
else {
|
|
Db::getInstance()->ExecuteS('
|
|
DELETE FROM `'._DB_PREFIX_.'product_ps_cache` WHERE `id_product` IN
|
|
(
|
|
SELECT `id_product` FROM `'._DB_PREFIX_.'product` WHERE `id_category_default` = '.$category.'
|
|
)
|
|
');
|
|
$sale = Db::getInstance()->getValue('
|
|
SELECT s.id_sale FROM `'._DB_PREFIX_.'privatesale_category` s
|
|
WHERE s.`id_category` = '.$category.'
|
|
');
|
|
if ($sale !== false) {
|
|
Db::getInstance()->executeS('
|
|
INSERT LOW_PRIORITY INTO `'._DB_PREFIX_.'product_ps_cache`
|
|
(
|
|
SELECT p.`id_product`, '.$sale.'
|
|
FROM `'._DB_PREFIX_.'product` p
|
|
WHERE p.`id_category_default` = '.$category.'
|
|
)
|
|
');
|
|
}
|
|
}
|