'.$this->l('General settings').'
'.$this->l('Category settings').'
'.$this->l('Slider settings').'
'.$this->l('Column settings').'
'.$this->l('Home and countdown page').'
'.$this->l('Documentation').'
'.$this->l('If you need to add countdown timer in product list, edit the product-list.tpl of your
theme and put this code where you need the timer:').'
{include file="$tpl_dir./../../modules/countdownspecials/views/templates/front/countdownspecials-list.tpl"}
'.$this->l('If you use layered navigation module, edit in modules/blocklayered/blocklayered.php,
and add at the beginning this code:').'
include(dirname(__FILE__).\'/../countdownspecials/countdownspecials.php\');
'.$this->l('and search this line:').'
\'nb_products\' => $nb_products,
'.$this->l('and put this code after it:').'
\'productlist\' => CountdownSpecials::productList(),
'.$this->l('To generate css3 shadows, you can use this site:').'
CSS3
'.$this->l('Ask your hosting provider to setup a "Cron task" to load the following URL at the time you would like to disable/enable the products automatically:').''._PS_BASE_URL_._MODULE_DIR_.'countdownspecials/cron.php?token='.Tools::substr(Tools::encrypt('countdownspecials/cron'), 0, 10).'&id_shop='.$this->context->shop->id.''.$this->l('You can use the free Prestashop module Cron tasks manager (cronjobs).Just install it and configure the url and time').'
README
TERMS
Quick help
Video:
'
.$this->l('Active and expired products').'
';
$output .= '
'.$this->l('Active prices drop list - Current time: ').date('Y-m-d H:i:s').'
| '.$this->l('ID').' |
'.$this->l('Reference').' |
'.$this->l('Name').' |
'.$this->l('From').' |
'.$this->l('To').' |
'.$this->l('Edit').' |
';
@mysql_connect(_DB_SERVER_, _DB_USER_, _DB_PASSWD_);
mysql_query('SET NAMES UTF8');//this is needed for UTF 8 characters - multilanguage
mysql_select_db(_DB_NAME_);
if (_PS_VERSION_ > '1.4.0.0' && _PS_VERSION_ < '1.5.0.0')
{
$sql = '
SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`, pl.`name`, sp.from AS reduction_from, sp.to
AS reduction_to,sp.`id_specific_price`,sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` && pl.`id_lang` = '.(int)$this->context->language->id.')
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
WHERE sp.from <= sp.to && sp.from <= \''.pSQL($current_date).'\' && sp.to >= \''.pSQL($current_date).'\'
';
}
if (_PS_VERSION_ > '1.5.0.0')
{
$current_date = date('Y-m-d H:i:s');
$sql = '
SELECT p.*, ps.*,pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`,
pl.`name`, p.`ean13`, p.`upc`, sp.`from` AS reduction_from, sp.`to` AS reduction_to, sp.`id_product`,sp.`id_specific_price`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.`id_product` = ps.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` && pl.`id_lang` = '.(int)$this->context->language->id.')
WHERE sp.from <= sp.to && sp.from <= \''.pSQL($current_date).'\' && sp.to >= \''.pSQL($current_date).'\' && ps.id_shop = '.(int)$this->context->shop->id.'
&& pl.id_shop = '.(int)$this->context->shop->id.'
';
}
if (_PS_VERSION_ < '1.4.0.0')
{
$sql = '
SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` && pl.`id_lang` = '.(int)$this->context->language->id.')
WHERE p.reduction_from < p.reduction_to && p.reduction_from < \''.pSQL($current_date).'\'
&& p.reduction_to > \''.pSQL($current_date).'\' GROUP BY p.`id_product`';
}
$resultt = mysql_query($sql);
$pricesDrop = Db::getInstance()->ExecuteS($sql);
$prices_drop = array();
/*paginate*/
$rpp = 10; // results per page
$adjacents = 2;
$page = (int)(@Tools::getValue('page'));
if ($page <= 0)
$page = 1;
$reload = $_SERVER['PHP_SELF'].'?'.$_SERVER['QUERY_STRING'];
// count total number of appropriate listings:
@$tcount = mysql_num_rows(@$resultt);
// count number of pages:
$tpages = ($tcount) ? ceil($tcount / $rpp) : 1; // total pages, last page number
$count = 0;
$i = ($page - 1) * $rpp;
while (($count < $rpp) && ($i < $tcount))
{
mysql_data_seek($resultt, $i);
$query = mysql_fetch_array($resultt);
$type = CountdownSpecials::getImages('products');
$imo = new Image;
$im = $imo->getCover((int)($query['id_product']));
$im2o = new Link;
$im2 = $im2o->getImageLink($query['link_rewrite'], $query['id_product'].'-'.$im['id_image'], $type[0]['name']);
// output each row:
if (_PS_VERSION_ > '1.5.0.0')
$im2 = str_replace($_SERVER['HTTP_HOST'], '../../', $im2);
else
$im2 = str_replace($_SERVER['HTTP_HOST'].__PS_BASE_URI__, '../../', $im2);
$output .= '
';
$i++;
$count++;
}
// call pagination function:
/*endpaginate*/
/* foreach ($pricesDrop AS $priceDrop){
';
}*/
$output .= '
';
$output .= CountdownSpecials::paginate_one($reload, $page, $tpages, $adjacents);
$output .= '
'.$this->l('Expired prices drop list').'
| '.$this->l('ID').' |
'.$this->l('Reference').' |
'.$this->l('Name').' |
'.$this->l('From').' |
'.$this->l('To').' |
'.$this->l('Edit').' |
';
@mysql_connect(_DB_SERVER_, _DB_USER_, _DB_PASSWD_);
mysql_query('SET NAMES UTF8');//this is needed for UTF 8 characters - multilanguage
mysql_select_db(_DB_NAME_);
if (_PS_VERSION_ > '1.4.0.0' && _PS_VERSION_ < '1.5.0.0')
{
$sql2 = '
SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`, pl.`name`, sp.from AS reduction_from, sp.to
AS reduction_to, sp.id_specific_price
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` &&
pl.`id_lang` = '.(int)$this->context->language->id.')
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
WHERE sp.from < sp.to && sp.from <= \''.pSQL($current_date).'\' && sp.to < \''.pSQL($current_date).'\'
GROUP BY p.`id_product`
';
}
if (_PS_VERSION_ > '1.5.0.0')
{
$current_date = date('Y-m-d H:i:s');
$current_date = date('Y-m-d H:i:s');
$sql2 = '
SELECT p.*,ps.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`,
pl.`name`, p.`ean13`, p.`upc`, sp.`from` AS reduction_from, sp.`to`
AS reduction_to, sp.`id_product` ,sp.`id_specific_price`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.`id_product` = ps.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` &&
pl.`id_lang` = '.(int)$this->context->language->id.')
WHERE sp.from < sp.to && sp.from <= \''.pSQL($current_date).'\' &&
sp.to < \''.pSQL($current_date).'\' && ps.id_shop = '.(int)$this->context->shop->id.'
&& pl.id_shop = '.(int)$this->context->shop->id.'
';
}
if (_PS_VERSION_ < '1.4.0.0')
{
$sql2 = '
SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`, pl.`name`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` &&
pl.`id_lang` = '.(int)$this->context->language->id.')
WHERE p.reduction_from < p.reduction_to && p.reduction_to < \''.pSQL($current_date).'\' GROUP BY p.`id_product`';
}
$pricesDrop2 = Db::getInstance()->ExecuteS($sql2);
$resulttt = mysql_query($sql2);
$prices_drop2 = array();
@$tcount = mysql_num_rows(@$resulttt);
// count number of pages:
$tpages = ($tcount) ? ceil($tcount / $rpp) : 1; // total pages, last page number
$count = 0;
$i = ($page - 1) * $rpp;
while (($count < $rpp) && ($i < $tcount))
{
mysql_data_seek($resulttt, $i);
$query = mysql_fetch_array($resulttt);
$type = CountdownSpecials::getImages('products');
$imo = new Image;
$im = $imo->getCover((int)($query['id_product']));
$im2o = new Link;
$im2 = $im2o->getImageLink($query['link_rewrite'], $query['id_product'].'-'.$im['id_image'], $type[0]['name']);
// output each row:
if (_PS_VERSION_ > '1.5.0.0')
$im2 = str_replace($_SERVER['HTTP_HOST'], '../../', $im2);
else
$im2 = str_replace($_SERVER['HTTP_HOST'].__PS_BASE_URI__, '../../', $im2);
$output .= '
';
$i++;
$count++;
}
$output .= '
';
$output .= CountdownSpecials::paginate_one($reload, $page, $tpages, $adjacents);
$output .= '
';
return $output;
}
public function getPricesDropsh($id_lang, $page_number = 0, $nbProducts, $count = false,
$orderBy = null,
$orderWay = null, $beginning = true, $ending = false)
{
$sort = Configuration::get('COUNTDOWNSPECIALS_SORT');
$psversion = _PS_VERSION_;
if (!Validate::isBool($count))
die(Tools::displayError());
if ($page_number < 0)
$page_number = 0;
if ($nbProducts < 1)
$nbProducts = 10;
if (empty($orderBy) || $orderBy == 'position')
$orderBy = 'myprice';
if (empty($orderWay))
$orderWay = 'DESC';
if ($orderBy == 'id_product' || $orderBy == 'price' || $orderBy == 'date_add')
$order_by_prefix = 'p';
elseif ($orderBy == 'name')
$order_by_prefix = 'pl';
if (!Validate::isOrderBy($orderBy) || !Validate::isOrderWay($orderWay))
die(Tools::displayError());
if ($count)
{
$sql = '
SELECT COUNT(DISTINCT p.`id_product`) AS nb
FROM `'._DB_PREFIX_.'product` p
WHERE p.`active` = 1
&& p.`id_product` IN (
SELECT cp.`id_product`
FROM `'._DB_PREFIX_.'category_group` cg
LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` '.(!(int)($this->context->customer->id) ? '= 1' : 'IN
(SELECT id_group FROM '._DB_PREFIX_.'customer_group WHERE id_customer = '.(int)($this->context->customer->id).')').'
)';
$result = Db::getInstance()->getRow($sql);
return (int)($result['nb']);
}
$current_date = date('Y-m-d H:i:s');
$sql = '
SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`, pl.`name`, p.`ean13`, i.`id_image`, il.`legend`, t.`rate`,
(p.`reduction_price` + (p.`reduction_percent` * p.`price`)) AS myprice, m.`name` AS manufacturer_name
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` && pl.`id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product` && i.`cover` = 1)
LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` && il.`id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'tax` t ON (t.`id_tax` = p.`id_tax`)
LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
WHERE (`reduction_price` >= 0 || `reduction_percent` >= 0)
'.((!$beginning && !$ending) ? '&& ((`reduction_from` <= \''.pSQL($current_date).'\' &&
`reduction_to` >= \''.pSQL($current_date).'\'))' : ($beginning ? '&& `reduction_from` <=
\''.pSQL($beginning).'\'' : '').($ending ? '&& `reduction_to` >= \''.pSQL($ending).'\'' : '')).'
&& p.`active` = 1 && p.`price` > 0
&& p.`id_product` IN (
SELECT cp.`id_product`
FROM `'._DB_PREFIX_.'category_group` cg
LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` '.(!(int)($this->context->customer->id) ? '= 1' : 'IN (SELECT id_group FROM
'._DB_PREFIX_.'customer_group WHERE id_customer = '.(int)($this->context->customer->id).')').'
)';
if ($sort != 'RAND()')
{
$sql .= '
GROUP BY p.`id_product`
ORDER BY `reduction_to` '.(string)$sort.'
LIMIT '.(int)$nbProducts;
}
else
{
$sql .= '
GROUP BY p.`id_product`
ORDER BY RAND()
LIMIT '.(int)$nbProducts;
}
$result = Db::getInstance()->ExecuteS($sql);
if ($orderBy == 'price')
Tools::orderbyPrice($result, $orderWay);
if (!$result)
return false;
return Product::getProductsProperties($id_lang, $result);
}
/**/
public function getPricesDropshea($id_lang, $page_number = 0, $nbProducts, $count = false,
$orderBy = null,
$orderWay = null, $beginning = true, $ending = false)
{
$sort = Configuration::get('COUNTDOWNSPECIALS_SORT');
$psversion = _PS_VERSION_;
if (!Validate::isBool($count))
die(Tools::displayError());
if ($page_number < 0)
$page_number = 0;
if ($nbProducts < 1)
$nbProducts = 10;
if (empty($orderBy) || $orderBy == 'position')
$orderBy = 'myprice';
if (empty($orderWay))
$orderWay = 'DESC';
if ($orderBy == 'id_product' || $orderBy == 'price' || $orderBy == 'date_add')
$order_by_prefix = 'p';
elseif ($orderBy == 'name')
$order_by_prefix = 'pl';
if (!Validate::isOrderBy($orderBy) || !Validate::isOrderWay($orderWay))
die(Tools::displayError());
if ($count)
{
$sql = '
SELECT COUNT(DISTINCT p.`id_product`) AS nb
FROM `'._DB_PREFIX_.'product` p
WHERE p.`active` = 1
&& p.`id_product` IN (
SELECT cp.`id_product`
FROM `'._DB_PREFIX_.'category_group` cg
LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` '.(!(int)($this->context->customer->id) ? '= 1' : 'IN (SELECT id_group
FROM '._DB_PREFIX_.'customer_group WHERE id_customer = '.(int)($this->context->customer->id).')').'
)';
$result = Db::getInstance()->getRow($sql);
return (int)($result['nb']);
}
$current_date = date('Y-m-d H:i:s');
$sql = '
SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`, pl.`name`, p.`ean13`, i.`id_image`, il.`legend`, t.`rate`,
(p.`reduction_price` + (p.`reduction_percent` * p.`price`)) AS myprice, m.`name` AS manufacturer_name
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` &&
pl.`id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product` && i.`cover` = 1) ¡
LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` && il.`id_lang`
= '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'tax` t ON (t.`id_tax` = p.`id_tax`)
LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
WHERE (`reduction_price` >= 0 || `reduction_percent` >= 0)
'.((!$beginning && !$ending) ? '&& ((`reduction_from` <= \''.pSQL($current_date).'\' &&
`reduction_to` >= \''.pSQL($current_date).'\'))' : ($beginning ? '&& `reduction_from` <=
\''.pSQL($beginning).'\'' : '').($ending ? '&& `reduction_to` >= \''.pSQL($ending).'\'' : '')).'
&& p.`active` = 1 && p.`price` > 0
&& p.`id_product` IN (
SELECT cp.`id_product`
FROM `'._DB_PREFIX_.'category_group` cg
LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` '.(!(int)($this->context->customer->id) ? '= 1' : 'IN (SELECT id_group
FROM '._DB_PREFIX_.'customer_group WHERE id_customer = '.(int)($this->context->customer->id).')').'
)';
if ($sort != 'RAND()')
{
$sql .= '
GROUP BY p.`id_product`
ORDER BY `reduction_to` '.(string)$sort.'
LIMIT '.(int)$nbProducts;
}
else
{
$sql .= '
GROUP BY p.`id_product`
ORDER BY RAND()
';
}
$result = Db::getInstance()->ExecuteS($sql);
if ($orderBy == 'price')
Tools::orderbyPrice($result, $orderWay);
if (!$result)
return false;
return Product::getProductsProperties($id_lang, $result);
}
/**/
public function getPricesDropT($id_lang, $page_number = 0, $nbProducts, $count = false,
$orderBy = null,
$orderWay = null, $beginning = true, $ending = false)
{
$sort = Configuration::get('COUNTDOWNSPECIALS_SORT');
$psversion = _PS_VERSION_;
if (!Validate::isBool($count))
die(Tools::displayError());
if ($page_number < 0)
$page_number = 0;
if ($nbProducts < 1)
$nbProducts = 10;
if (empty($orderBy) || $orderBy == 'position')
$orderBy = 'myprice';
if (empty($orderWay))
$orderWay = 'DESC';
if ($orderBy == 'id_product' || $orderBy == 'price' || $orderBy == 'date_add')
$order_by_prefix = 'p';
elseif ($orderBy == 'name')
$order_by_prefix = 'pl';
if (!Validate::isOrderBy($orderBy) || !Validate::isOrderWay($orderWay))
die(Tools::displayError());
if ($count)
{
$sql = '
SELECT COUNT(DISTINCT p.`id_product`) AS nb
FROM `'._DB_PREFIX_.'product` p
WHERE p.`active` = 1
&& p.`id_product` IN (
SELECT cp.`id_product`
FROM `'._DB_PREFIX_.'category_group` cg
LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` '.(!(int)($this->context->customer->id) ? '= 1' : 'IN (SELECT id_group FROM
'._DB_PREFIX_.'customer_group WHERE id_customer = '.(int)($this->context->customer->id).')').'
)';
$result = Db::getInstance()->getRow($sql);
return (int)($result['nb']);
}
$current_date = date('Y-m-d H:i:s');
$sql = '
SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`, pl.`name`, p.`ean13`, i.`id_image`, il.`legend`, t.`rate`,
(p.`reduction_price` + (p.`reduction_percent` * p.`price`)) AS myprice, m.`name` AS manufacturer_name
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` &&
pl.`id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product` && i.`cover` = 1)
LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` &&
il.`id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'tax` t ON (t.`id_tax` = p.`id_tax`)
LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
WHERE (`reduction_price` >= 0 || `reduction_percent` >= 0)
'.((!$beginning && !$ending) ? '&& ((`reduction_from` <= \''.pSQL($current_date).'\' &&
`reduction_to` >= \''.pSQL($current_date).'\'))' : ($beginning ? '&& `reduction_from` <=
\''.pSQL($beginning).'\'' : '').($ending ? '&& `reduction_to` >= \''.pSQL($ending).'\'' : '')).'
&& p.`active` = 1 && p.`price` > 0
&& p.`id_product` IN (
SELECT cp.`id_product`
FROM `'._DB_PREFIX_.'category_group` cg
LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` '.(!(int)($this->context->customer->id) ? '= 1' : 'IN (SELECT id_group FROM
'._DB_PREFIX_.'customer_group WHERE id_customer = '.(int)($this->context->customer->id).')').'
)';
if ($sort != 'RAND()')
{
$sql .= '
GROUP BY p.`id_product`
ORDER BY `reduction_to` '.(string)$sort.'
';
}
else
{
$sql .= '
GROUP BY p.`id_product`
ORDER BY RAND()
';
}
$result = Db::getInstance()->ExecuteS($sql);
if ($orderBy == 'price')
Tools::orderbyPrice($result, $orderWay);
if (!$result)
return false;
return Product::getProductsProperties($id_lang, $result);
}
public function getList($id_lang)
{
/*product list code*/
if (_PS_VERSION_ > '1.4.0.0')
{
$current_date = date('Y-m-d H:i:s');
$sql = mysql_query('
SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`,
pl.`name`, p.`ean13`, p.`upc`, i.`id_image`, il.`legend`, t.`rate`, m.`name` AS manufacturer_name,
sp.`from` AS reduction_from, sp.`to` AS reduction_to, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` &&
pl.`id_lang` = '.(int)$this->context->language->id.')
LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product` && i.`cover` = 1)
LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` &&
il.`id_lang` = '.(int)$this->context->language->id.')
LEFT JOIN `'._DB_PREFIX_.'tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`
&& tr.`id_country` = '.(int)Country::getDefaultCountryId().'
&& tr.`id_state` = 0)
LEFT JOIN `'._DB_PREFIX_.'tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
WHERE 1
&& sp.`from` < sp.`to`
&& p.`active` = 1 && p.`price` > 0
&& sp.`to` < "'.pSQL($current_date).'"');
}
/*end product list*/
$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($sql);
if (!$result)
return false;
return CountdownSpecials::getProductsProperties((int)$this->context->language->id, $result);
}
public function getPricesDrop2($id_lang, $page_number = 0, $nbProducts, $count = false,
$orderBy = null,
$orderWay = null, $beginning = false, $ending = false, Context $context = null)
{
$front = true;
$sort = Configuration::get('COUNTDOWNSPECIALS_SORT');
$psversion = _PS_VERSION_;
if (!Validate::isBool($count))
die(Tools::displayError());
$current_date = date('Y-m-d H:i:s');
$ids_product = $this->_getProductIdByDate((!$beginning ? $current_date : $beginning), (!$ending ? $current_date : $ending));
$groups = FrontController::getCurrentCustomerGroups();
$sqlGroups = (count($groups) ? 'IN ('.implode(',', $groups).')' : '= 1');
if (_PS_VERSION_ > '1.4.0.0' && _PS_VERSION_ < '1.5.0.0')
{
$sql = '
SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`,
pl.`name`, p.`ean13`, p.`upc`, i.`id_image`, il.`legend`, t.`rate`, m.`name` AS manufacturer_name,
sp.`from` AS reduction_from, sp.`to` AS reduction_to, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` && pl.`id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product` && i.`cover` = 1)
LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` && il.`id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`
&& tr.`id_country` = '.(int)Country::getDefaultCountryId().'
&& tr.`id_state` = 0)
LEFT JOIN `'._DB_PREFIX_.'tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
WHERE 1
&& sp.`from` < sp.`to`
&& sp.`to` >= "'.pSQL($current_date).'"
&& p.`active` = 1 && p.`price` > 0
&& p.`show_price` = 1
&& p.`id_product` IN (
SELECT cp.`id_product`
FROM `'._DB_PREFIX_.'category_group` cg
LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` '.(string)$sqlGroups.'
)
GROUP BY p.`id_product`
ORDER BY sp.`to` '.$sort.'
LIMIT '.(int)($page_number * $nbProducts).', '.(int)($nbProducts);
}
if (_PS_VERSION_ > '1.5.0.0')
{
$sql = '
SELECT p.*, ps.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`,
pl.`name`, p.`ean13`, p.`upc`, i.`id_image`, il.`legend`, t.`rate`, m.`name` AS manufacturer_name,
sp.`from` AS reduction_from, sp.`to` AS reduction_to, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.`id_product` = ps.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` && pl.`id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product` && i.`cover` = 1)
LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` && il.`id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`
&& tr.`id_country` = '.(int)Context::getContext()->country->id.'
&& tr.`id_state` = 0)
LEFT JOIN `'._DB_PREFIX_.'tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
WHERE 1
&& sp.`from` < sp.`to`
&& sp.`to` >= "'.pSQL($current_date).'"
&& p.`active` = 1 && p.`price` > 0
&& p.`show_price` = 1
&& p.`id_product` IN (
SELECT cp.`id_product`
FROM `'._DB_PREFIX_.'category_group` cg
LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` '.(string)$sqlGroups.'
)
&& ps.id_shop = '.(int)$this->context->shop->id.'
&& pl.id_shop = '.(int)$this->context->shop->id.'
GROUP BY p.`id_product`
ORDER BY sp.`to` '.$sort.'
LIMIT '.(int)($page_number * $nbProducts).', '.(int)($nbProducts);
}
$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($sql);
if ($orderBy == 'price')
Tools::orderbyPrice($result, $orderWay);
if (!$result)
return false;
return CountdownSpecials::getProductsProperties($id_lang, $result);
}
/*header*/
public function getPricesDrop2header($id_lang, $page_number = 0, $nbProducts,
$count = false, $orderBy = null,
$orderWay = null, $beginning = false, $ending = false, Context $context = null)
{
$front = true;
$sort = Configuration::get('COUNTDOWNSPECIALS_SORT');
$psversion = _PS_VERSION_;
if (!Validate::isBool($count))
die(Tools::displayError());
$current_date = date('Y-m-d H:i:s');
$ids_product = CountdownSpecials::_getProductIdByDate((!$beginning ? $current_date : $beginning),
(!$ending ? $current_date : $ending));
$groups = FrontController::getCurrentCustomerGroups();
$sqlGroups = (count($groups) ? 'IN ('.implode(',', $groups).')' : '= 1');
if (_PS_VERSION_ > '1.4.0.0' && _PS_VERSION_ < '1.5.0.0')
{
$sql = '
SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`,
pl.`name`, p.`ean13`, p.`upc`, i.`id_image`, il.`legend`, t.`rate`, m.`name` AS manufacturer_name,
sp.`from` AS reduction_from, sp.`to` AS reduction_to, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` && pl.`id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product` && i.`cover` = 1)
LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` && il.`id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`
&& tr.`id_country` = '.(int)Country::getDefaultCountryId().'
&& tr.`id_state` = 0)
LEFT JOIN `'._DB_PREFIX_.'tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
WHERE 1
&& sp.`from` < sp.`to`
&& sp.`to` >= "'.pSQL($current_date).'"
&& p.`active` = 1 && p.`price` > 0
&& p.`show_price` = 1
'.((!$beginning && !$ending) ? ' && p.`id_product` IN
('.((is_array($ids_product) && count($ids_product)) ? implode(', ', $ids_product) : 0).')' : '').'
&& p.`id_product` IN (
SELECT cp.`id_product`
FROM `'._DB_PREFIX_.'category_group` cg
LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` '.(string)$sqlGroups.'
)
GROUP BY p.`id_product`
ORDER BY sp.`to` '.(string)$sort;
}
if (_PS_VERSION_ > '1.5.0.0')
{
$sql = '
SELECT p.*, ps.*,pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`,
pl.`name`, p.`ean13`, p.`upc`, i.`id_image`, il.`legend`, t.`rate`, m.`name` AS manufacturer_name, sp.`from`
AS reduction_from, sp.`to` AS reduction_to, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.`id_product` = ps.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` && pl.`id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product` && i.`cover` = 1)
LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` && il.`id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`
&& tr.`id_country` = '.(int)Context::getContext()->country->id.'
&& tr.`id_state` = 0)
LEFT JOIN `'._DB_PREFIX_.'tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
WHERE 1
&& sp.`from` < sp.`to`
&& sp.`to` >= "'.pSQL($current_date).'"
&& p.`active` = 1 && p.`price` > 0
&& p.`show_price` = 1
'.((!$beginning && !$ending) ? ' && p.`id_product` IN
('.((is_array($ids_product) && count($ids_product)) ? implode(', ', $ids_product) : 0).')' : '').'
&& p.`id_product` IN (
SELECT cp.`id_product`
FROM `'._DB_PREFIX_.'category_group` cg
LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` '.(string)$sqlGroups.'
)
&& ps.id_shop = '.(int)$this->context->shop->id.'
&& pl.id_shop = '.(int)$this->context->shop->id.'
GROUP BY p.`id_product`
ORDER BY sp.`to` '.$sort;
}
$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($sql);
if ($orderBy == 'price')
Tools::orderbyPrice($result, $orderWay);
if (!$result)
return false;
return CountdownSpecials::getProductsProperties($id_lang, $result);
}
/**/
public function getPricesDrop2T($id_lang, $page_number = 0, $nbProducts, $count = false,
$orderBy = null,
$orderWay = null, $beginning = false, $ending = false)
{
$sort = Configuration::get('COUNTDOWNSPECIALS_SORT');
$psversion = _PS_VERSION_;
if (!Validate::isBool($count))
die(Tools::displayError());
$current_date = date('Y-m-d H:i:s');
$ids_product = CountdownSpecials::_getProductIdByDate((!$beginning ? $current_date : $beginning), (!$ending ? $current_date : $ending));
$groups = FrontController::getCurrentCustomerGroups();
$sqlGroups = (count($groups) ? 'IN ('.implode(',', $groups).')' : '= 1');
$sql = '
SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`,
pl.`name`, p.`ean13`, p.`upc`, i.`id_image`, il.`legend`, t.`rate`, m.`name`
AS manufacturer_name, sp.`from` AS reduction_from, sp.`to` AS reduction_to, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON
(p.`id_product` = pl.`id_product` && pl.`id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product` && i.`cover` = 1)
LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON
(i.`id_image` = il.`id_image` && il.`id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'tax_rule` tr ON
(p.`id_tax_rules_group` = tr.`id_tax_rules_group`
&& tr.`id_country` = '.(int)Country::getDefaultCountryId().'
&& tr.`id_state` = 0)
LEFT JOIN `'._DB_PREFIX_.'tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
WHERE 1
&& sp.`from` < sp.`to`
&& sp.`to` >= "'.pSQL($current_date).'"
&& p.`active` = 1 && p.`price` > 0
&& p.`show_price` = 1
'.((!$beginning && !$ending) ? ' && p.`id_product`
IN ('.((is_array($ids_product) && count($ids_product)) ? implode(', ', $ids_product) : 0).')' : '').'
&& p.`id_product` IN (
SELECT cp.`id_product`
FROM `'._DB_PREFIX_.'category_group` cg
LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` '.(string)$sqlGroups.'
)
GROUP BY p.`id_product`
LIMIT 2
';
$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($sql);
if ($orderBy == 'price')
Tools::orderbyPrice($result, $orderWay);
if (!$result)
return false;
return CountdownSpecials::getProductsProperties($id_lang, $result);
}
public function getProductProperties($id_lang, $row)
{
if (!$row['id_product'])
return false;
$specific_prices = '';
// Product::getDefaultAttribute is only called if id_product_attribute is missing from the SQL query at the origin of it: consider adding it in order to avoid unnecessary queries
$row['allow_oosp'] = Product::isAvailableWhenOutOfStock($row['out_of_stock']);
if ((!isset($row['id_product_attribute']) || !$row['id_product_attribute']) && ((isset($row['cache_default_attribute']) && ($ipa_default = $row['cache_default_attribute']) !== null) || ($ipa_default = Product::getDefaultAttribute($row['id_product'], !$row['allow_oosp']))))
$row['id_product_attribute'] = $ipa_default;
if (!isset($row['id_product_attribute']))
$row['id_product_attribute'] = 0;
// Tax
$usetax = Tax::excludeTaxeOption();
$cacheKey = $row['id_product'].'-'.$row['id_product_attribute'].'-'.$id_lang.'-'.(int)($usetax);
if (array_key_exists($cacheKey, $this->producPropertiesCache))
return $this->producPropertiesCache[$cacheKey];
// Datas
$link = new Link();
$row['category'] = Category::getLinkRewrite((int)$row['id_category_default'], (int)($id_lang));
$row['link'] = $link->getProductLink((int)$row['id_product'], $row['link_rewrite'], $row['category'], $row['ean13']);
$row['attribute_price'] = (isset($row['id_product_attribute']) && $row['id_product_attribute'])
? (float)(Product::getProductAttributePrice($row['id_product_attribute'])) : 0;
$row['price_tax_exc'] = Product::getPriceStatic((int)$row['id_product'], false, ((isset($row['id_product_attribute']) && !empty($row['id_product_attribute'])) ? (int)($row['id_product_attribute']) : null), ($this->_taxCalculationMethod == PS_TAX_EXC ? 2 : 6));
if ($this->_taxCalculationMethod == PS_TAX_EXC)
{
$row['price_tax_exc'] = Tools::ps_round($row['price_tax_exc'], 2);
$row['price'] = Product::getPriceStatic((int)$row['id_product'], true, ((isset($row['id_product_attribute']) && !empty($row['id_product_attribute'])) ? (int)($row['id_product_attribute']) : null), 6);
}
else
$row['price'] = Tools::ps_round(Product::getPriceStatic((int)$row['id_product'], true, ((isset($row['id_product_attribute']) && !empty($row['id_product_attribute'])) ? (int)($row['id_product_attribute']) : null), 6), 2);
$row['reduction'] = Product::getPriceStatic((int)($row['id_product']),
(bool)$usetax, (int)($row['id_product_attribute']), 6, null, true, true, 1, true, null, null, null, $specific_prices);
$row['specific_prices'] = $specific_prices;
$row['price_without_reduction'] = Product::getPriceStatic((int)$row['id_product'], true, ((isset($row['id_product_attribute']) && !empty($row['id_product_attribute'])) ? (int)($row['id_product_attribute']) : null), 6, null, false, false);
if ($row['id_product_attribute'])
$row['quantity'] = Product::getQuantity((int)$row['id_product'], $row['id_product_attribute'],
isset($row['cache_is_pack']) ? $row['cache_is_pack'] : null);
$row['id_image'] = Product::defineProductImage($row, $id_lang);
$row['features'] = Product::getFrontFeaturesStatic((int)$id_lang, $row['id_product']);
$row['attachments'] = ((!isset($row['cache_has_attachments']) || $row['cache_has_attachments']) ?
Product::getAttachmentsStatic((int)($id_lang), $row['id_product']) : array());
// Pack management
$row['pack'] = (!isset($row['cache_is_pack']) ? Pack::isPack($row['id_product']) : (int)$row['cache_is_pack']);
$row['packItems'] = $row['pack'] ? Pack::getItemTable($row['id_product'], $id_lang) : array();
$row['nopackprice'] = $row['pack'] ? Pack::noPackPrice($row['id_product']) : 0;
if ($row['pack'] && !Pack::isInStock($row['id_product']))
$row['quantity'] = 0;
$this->producPropertiesCache[$cacheKey] = $row;
return $this->producPropertiesCache[$cacheKey];
}
public function getProductsProperties($id_lang, $query_result)
{
$resultsArray = array();
foreach ($query_result as $row)
if ($row2 = $this->getProductProperties($id_lang, $row))
$resultsArray[] = $row2;
return $resultsArray;
}
public function getTaxCalculationMethod($id_customer = null)
{
if ($id_customer)
CountdownSpecials::initPricesComputation((int)($id_customer));
return (int)($this->_taxCalculationMethod);
}
public function _getProductIdByDate($beginning, $ending, Context $context = null)
{
$front = true;
$current_date = date('Y-m-d H:M:S');
$id_group = (int)($this->context->customer->id) ?
(int)(Customer::getDefaultGroupId((int)($this->context->customer->id))) : _PS_DEFAULT_CUSTOMER_GROUP_;
$id_address = $this->context->cart->{Configuration::get('PS_TAX_ADDRESS_TYPE')};
$ids = Address::getCountryAndState($id_address);
$id_country = (int)($ids['id_country'] ?
$ids['id_country'] : Configuration::get('PS_COUNTRY_DEFAULT'));
if (_PS_VERSION_ < '1.5.0.0')
return SpecificPrice::getProductIdByDate((int)(Shop::getCurrentShop()),
(int)($this->context->currency->id), $id_country, $id_group, $current_date, $current_date);
else
return SpecificPrice::getProductIdByDate(Context::getContext()->shop->id,
(int)($this->context->currency->id), $id_country, $id_group, $current_date, $current_date);
}
public function productpage()
{
$id_product = '';
$result = Db::getInstance()->ExecuteS('
SELECT *.p
FROM `'._DB_PREFIX_.'product` p
WHERE p.active = 1 && p.id_product = '.(int)$id_product);
}
public function hookTop($params)
{
$id_cat = (int)(Tools::getValue('id_category'));
$categ = $this->getPricesDropshPR($id_cat);
$beginning2 = '';
$ending2 = '';
$productsd2 = '';
$productsd = '';
$styletime = Configuration::get('COUNTDOWNSPECIALS_STYLETIME');
$nbrtop = Configuration::get('COUNTDOWNSPECIALS_NBRTOP');
$respo = Configuration::get('COUNTDOWNSPECIALS_RESPO');
$widtht = Configuration::get('COUNTDOWNSPECIALS_WIDTHT');
$heightt = Configuration::get('COUNTDOWNSPECIALS_HEIGHTT');
$margin = Configuration::get('COUNTDOWNSPECIALS_MARGIN');
$sort = Configuration::get('COUNTDOWNSPECIALS_SORT');
$widthlo3 = Configuration::get('COUNTDOWNSPECIALS_WIDTH3');
$color2 = Configuration::get('COUNTDOWNSPECIALS_COLOR2');
$color = Configuration::get('COUNTDOWNSPECIALS_COLOR');
$wt = Configuration::get('COUNTDOWNSPECIALS_WT');
$align = Configuration::get('COUNTDOWNSPECIALS_ALIGN');
$imagecs = Configuration::get('COUNTDOWNSPECIALS_IMAGECS');
$styletime = Configuration::get('COUNTDOWNSPECIALS_STYLETIME');
$delaycs = Configuration::get('COUNTDOWNSPECIALS_DELAYCS');
$slidercs = Configuration::get('COUNTDOWNSPECIALS_SLIDERCS');
$sort = Configuration::get('COUNTDOWNSPECIALS_SORT');
$but = Configuration::get('COUNTDOWNSPECIALS_BUT');
$home6 = Configuration::get('COUNTDOWNSPECIALS_HOME6');
$ht = $wt * 60 / 275;
$sa = $this->getImagesID($imagecs);
$imagecs = $sa[0]['name'];
if ($sort == 'ASC')
$sort = 'DESC';
else
$sort = 'ASC';
$psversion = _PS_VERSION_;
if ($psversion < '1.4.0.0')
$pricesDrop = CountdownSpecials::getPricesDropsh($this->context->language->id,
$page_number = 0, $nbrtop, $count = false, $orderBy = $sort, $orderWay = null, $beginning = $beginning2, $ending = $ending2);
else
$pricesDrop = CountdownSpecials::getPricesDrop2($this->context->language->id,
$page_number = 0, $nbrtop, $count = false, $orderBy = $sort, $orderWay = null, $beginning = $beginning2, $ending = $ending2);
$prices_drop = array();
if ($pricesDrop)
foreach ($pricesDrop as $priceDrop)
$productsd2[] = $priceDrop;
$ptypee = Page::getCurrentId();
$pety = $this->getPages($ptypee);
foreach ($pety as $pet)
{
$petid = $pet['id_page'];
$petnam = $pet['name'];
$pettyp = $pet['id_page_type'];
}
if (_PS_VERSION_ > '1.5.0.0' && _PS_VERSION_ < '1.6.0.0')
{
$styletime = Configuration::get('COUNTDOWNSPECIALS_STYLETIME');
$catw = Configuration::get('COUNTDOWNSPECIALS_CATW');
$wthcat = Configuration::get('COUNTDOWNSPECIALS_CATW');
$catcolor = Configuration::get('COUNTDOWNSPECIALS_CATCOLOR');
$catcolor2 = Configuration::get('COUNTDOWNSPECIALS_CATCOLOR2');
$hthcat = $wthcat * 60 / 275;
$this->context->smarty->assign(array(
'categs' => $categ,
'catcolor' => $catcolor,
'styletime' => $styletime,
'catw' => $catw,
'cathth' => $hthcat,
'catcolor2' => $catcolor2,
'psversion' => _PS_VERSION_,
));
}
if (_PS_VERSION_ < '1.5.0.0')
{
$ptypee1 = CountdownSpecials::getPageTypeByName('category');
$ptypee2 = CountdownSpecials::getPageTypeByName('category.php');
}
else
{
$ptypee1 = Page::getPageTypeByName('category');
$ptypee2 = Page::getPageTypeByName('category.php');
}
if (_PS_VERSION_ > '1.6.0.0')
{
if ($pettyp == $ptypee1 || $pettyp == $ptypee2)
$this->context->smarty->assign(array('productlist' => CountdownSpecials::productList()));
}
$this->context->smarty->assign(array(
'categs' => $categ,
'productsd2' => $productsd2,
'imagecs' => $imagecs,
'home6' => $home6,
'colort' => $color,
'wt' => $wt,
'ht' => $ht,
'respo' => $respo,
'widtht' => $widtht,
'heightt' => $heightt,
'slidercs' => $slidercs,
'styletime' => $styletime,
'lang' => 'text_'.(int)$this->context->language->id
));
return $this->display(__FILE__, 'views/templates/front/countdownspecials-top.tpl');
}
public function copy($source, $destination, $stream_context = null)
{
if (is_null($stream_context) && !preg_match('/^https?:\/\//', $source))
return @copy($source, $destination);
return @file_put_contents($destination, Tools::file_get_contents($source, false, $stream_context));
}
public function getPageTypeByName($name)
{
if ($value = Db::getInstance()->getValue('
SELECT id_page_type
FROM '._DB_PREFIX_.'page_type
WHERE name = \''.pSQL($name).'\''))
return $value;
// Db::getInstance()->insert('page_type', array('name' => pSQL($name)));
return Db::getInstance()->Insert_ID();
}
public function getPages($pety)
{
$result = Db::getInstance()->ExecuteS('
SELECT pt.`id_page_type`,pt.`name`,p.`id_page_type`,p.`id_page`,p.`id_object`
FROM `'._DB_PREFIX_.'page` p
LEFT JOIN `'._DB_PREFIX_.'page_type` pt ON p.`id_page_type` = pt.`id_page_type`
WHERE p.`id_page` = '.(int)$pety.' LIMIT 1');
return ($result);
}
public function hookHome($params)
{
$beginning2 = '';
$ending2 = '';
$productsd2 = '';
$productsd = '';
$styletime = Configuration::get('COUNTDOWNSPECIALS_STYLETIME');
$nbr = Configuration::get('COUNTDOWNSPECIALS_NBR');
$respo = Configuration::get('COUNTDOWNSPECIALS_RESPO');
$respop = Configuration::get('COUNTDOWNSPECIALS_RESPOP');
$width3 = Configuration::get('COUNTDOWNSPECIALS_WIDTH3');
$width3h = Configuration::get('COUNTDOWNSPECIALS_WIDTH3H');
$margin = Configuration::get('COUNTDOWNSPECIALS_MARGIN');
$widthlo3 = Configuration::get('COUNTDOWNSPECIALS_WIDTH3');
$hpcp = Configuration::get('COUNTDOWNSPECIALS_HP');
$color2 = Configuration::get('COUNTDOWNSPECIALS_COLOR2');
$colorbg = Configuration::get('COUNTDOWNSPECIALS_COLORBG');
$align = Configuration::get('COUNTDOWNSPECIALS_ALIGN');
$grid = Configuration::get('COUNTDOWNSPECIALS_GRID');
$delaycs = Configuration::get('COUNTDOWNSPECIALS_DELAYCS');
$rad = Configuration::get('COUNTDOWNSPECIALS_RAD');
$wth = Configuration::get('COUNTDOWNSPECIALS_WTH');
$home6 = Configuration::get('COUNTDOWNSPECIALS_HOME6');
$hth = $wth * 60 / 275;
$listw = Configuration::get('COUNTDOWNSPECIALS_LISTW');
$imagesizeh = Configuration::get('COUNTDOWNSPECIALS_IMAGESIZEH');
$imageh = Configuration::get('COUNTDOWNSPECIALS_IMAGEH');
$sort = Configuration::get('COUNTDOWNSPECIALS_SORT');
$sa = $this->getImagesID($imageh);
$imageh = $sa[0]['name'];
$psversion = _PS_VERSION_;
if ($psversion < '1.4.0.0')
$pricesDrop = CountdownSpecials::getPricesDropsh($this->context->language->id,
$page_number = 0, $nbr, $count = false, $orderBy = $sort, $orderWay = null, $beginning = $beginning2, $ending = $ending2);
else
$pricesDrop = CountdownSpecials::getPricesDrop2($this->context->language->id,
$page_number = 0, $nbr, $count = false, $orderBy = $sort, $orderWay = null, $beginning = $beginning2, $ending = $ending2);
$prices_drop = array();
if ($pricesDrop)
foreach ($pricesDrop as $priceDrop)
$productsd[] = $priceDrop;
$this->context->smarty->assign(array(
'productsd' => $productsd,
'color2' => $color2,
'hpcp' => $hpcp,
'widthlo3' => $widthlo3,
'margin' => $margin,
'styletime' => $styletime,
'psversion' => $psversion,
'align' => $align,
'width3' => $width3,
'wth' => $wth,
'hth' => $hth,
'respop' => $respop,
'width3h' => $width3h,
'delaycs' => $delaycs,
'grid' => $grid,
'rad' => $rad,
'colorbg' => $colorbg,
'listw' => $listw,
'imageh' => $imageh,
'imagesizeh' => $imagesizeh,
'nbrcs' => $nbr
));
if ($home6 != 'Tab')
return $this->display(__FILE__, 'views/templates/front/countdownspecials.tpl');
}
public function hookdisplayTopColumn($params)
{
$beginning2 = '';
$ending2 = '';
$productsd2 = '';
$productsd = '';
$styletime = Configuration::get('COUNTDOWNSPECIALS_STYLETIME');
$nbr = Configuration::get('COUNTDOWNSPECIALS_NBR');
$respo = Configuration::get('COUNTDOWNSPECIALS_RESPO');
$width3 = Configuration::get('COUNTDOWNSPECIALS_WIDTH3');
$width3h = Configuration::get('COUNTDOWNSPECIALS_WIDTH3H');
$margin = Configuration::get('COUNTDOWNSPECIALS_MARGIN');
$widthlo3 = Configuration::get('COUNTDOWNSPECIALS_WIDTH3');
$hpcp = Configuration::get('COUNTDOWNSPECIALS_HP');
$color2 = Configuration::get('COUNTDOWNSPECIALS_COLOR2');
$colorbg = Configuration::get('COUNTDOWNSPECIALS_COLORBG');
$align = Configuration::get('COUNTDOWNSPECIALS_ALIGN');
$grid = Configuration::get('COUNTDOWNSPECIALS_GRID');
$delaycs = Configuration::get('COUNTDOWNSPECIALS_DELAYCS');
$rad = Configuration::get('COUNTDOWNSPECIALS_RAD');
$wth = Configuration::get('COUNTDOWNSPECIALS_WT');
$home6 = Configuration::get('COUNTDOWNSPECIALS_HOME6');
$hth = $wth * 60 / 275;
$listw = Configuration::get('COUNTDOWNSPECIALS_LISTW');
$imagesizeh = Configuration::get('COUNTDOWNSPECIALS_IMAGESIZEH');
$imageh = Configuration::get('COUNTDOWNSPECIALS_IMAGEH');
$sort = Configuration::get('COUNTDOWNSPECIALS_SORT');
$sa = $this->getImagesID($imageh);
$imageh = $sa[0]['name'];
$psversion = _PS_VERSION_;
if ($psversion < '1.4.0.0')
$pricesDrop = CountdownSpecials::getPricesDropsh($this->context->language->id,
$page_number = 0, $nbr, $count = false, $orderBy = $sort, $orderWay = null, $beginning = $beginning2, $ending = $ending2);
else
$pricesDrop = CountdownSpecials::getPricesDrop2($this->context->language->id,
$page_number = 0, $nbr, $count = false, $orderBy = $sort, $orderWay = null, $beginning = $beginning2, $ending = $ending2);
$prices_drop = array();
if ($pricesDrop)
foreach ($pricesDrop as $priceDrop)
$productsd[] = $priceDrop;
$this->context->smarty->assign(array(
'productsd' => $productsd,
'color2' => $color2,
'hpcp' => $hpcp,
'widthlo3' => $widthlo3,
'margin' => $margin,
'styletime' => $styletime,
'psversion' => $psversion,
'align' => $align,
'width3' => $width3,
'wth' => $wth,
'hth' => $hth,
'respo' => $respo,
'width3h' => $width3h,
'delaycs' => $delaycs,
'grid' => $grid,
'rad' => $rad,
'colorbg' => $colorbg,
'listw' => $listw,
'imageh' => $imageh,
'imagesizeh' => $imagesizeh,
'nbrcs' => $nbr
));
if ($home6 == 'Tab')
return $this->display(__FILE__, 'views/templates/front/countdownspecials-tc.tpl');
}
public function hookLeftColumn($params)
{
$beginning2 = '';
$ending2 = '';
$productsd2 = '';
$productsd = '';
$countdowns = '';
$styletime = Configuration::get('COUNTDOWNSPECIALS_STYLETIME');
$nbr3 = Configuration::get('COUNTDOWNSPECIALS_NBR3');
$height = Configuration::get('COUNTDOWNSPECIALS_HEIGHT');
$nbr2 = Configuration::get('COUNTDOWNSPECIALS_NBR2');
$imagesizec = Configuration::get('COUNTDOWNSPECIALS_IMAGESIZEC');
$imagec = Configuration::get('COUNTDOWNSPECIALS_IMAGEC');
$sort = Configuration::get('COUNTDOWNSPECIALS_SORT');
$wtb = Configuration::get('COUNTDOWNSPECIALS_WTB');
$htb = $wtb * 60 / 275;
$sa = $this->getImagesID($imagec);
$imagec = $sa[0]['name'];
$psversion = _PS_VERSION_;
if ($psversion < '1.4.0.0')
$pricesDrop = CountdownSpecials::getPricesDropsh($this->context->language->id,
$page_number = 0, $nbr3, $count = false, $orderBy = $sort, $orderWay = null, $beginning = $beginning2, $ending = $ending2);
else
$pricesDrop = CountdownSpecials::getPricesDrop2($this->context->language->id,
$page_number = 0, $nbr3, $count = false, $orderBy = $sort, $orderWay = null, $beginning = $beginning2, $ending = $ending2);
$prices_drop = array();
if ($pricesDrop)
foreach ($pricesDrop as $priceDrop)
$countdowns[] = $priceDrop;
$this->context->smarty->assign(array(
'countdowns' => $countdowns,
'height' => $height,
'nbr2' => $nbr2,
'wtb' => $wtb,
'htb' => $htb,
'styletime' => $styletime,
'psversion' => $psversion,
'imagesizec' => $imagesizec,
'imagec' => $imagec
));
return $this->display(__FILE__, 'views/templates/front/countdownspecials-column.tpl');
}
public function hookRightColumn($params)
{
return $this->hookLeftColumn($params);
}
public function productList()
{
$productsdd = '';
$styletime = Configuration::get('COUNTDOWNSPECIALS_STYLETIME');
$this->context->smarty->assign(array(
'styletime' => $styletime
));
$front = true;
$styletime = Configuration::get('COUNTDOWNSPECIALS_STYLETIME');
$pagination = Configuration::get('COUNTDOWNSPECIALS_PAGINATION');
$colorp = Configuration::get('COUNTDOWNSPECIALS_COLORP');
$fsp = Configuration::get('COUNTDOWNSPECIALS_FSP');
$paginationn = Configuration::get('COUNTDOWNSPECIALS_PAGINATIONN');
$pagination2 = Configuration::get('COUNTDOWNSPECIALS_PAGINATION2');
$paginationn2 = Configuration::get('COUNTDOWNSPECIALS_PAGINATIONN2');
$widthlo = Configuration::get('COUNTDOWNSPECIALS_WIDTH');
$slidercs = Configuration::get('COUNTDOWNSPECIALS_SLIDERCS');
$delaycs = Configuration::get('COUNTDOWNSPECIALS_DELAYCS');
$psversion = _PS_VERSION_;
$enabledp = Configuration::get('COUNTDOWNSPECIALS_ENABLEDP');
$disabledp = Configuration::get('COUNTDOWNSPECIALS_DISABLEDP');
if ($psversion < '1.4.0.0')
$pricesDrop = CountdownSpecials::getPricesDropshea((int)((int)$this->context->language->id),
$page_number = 0, 10, $count = false, $orderBy = null, $orderWay = null, $beginning = 1, $ending = 10);
else
$pricesDrop = CountdownSpecials::getPricesDrop2header((int)((int)$this->context->language->id),
$page_number = 0, 10, $count = false, $orderBy = null, $orderWay = null, $beginning = 1, $ending = 10);
$prices_drop = array();
if ($pricesDrop)
foreach ($pricesDrop as $priceDrop)
$productsdd[] = $priceDrop;
return $productsdd;
}
public function hookHeader($params)
{
@mysql_connect(_DB_SERVER_, _DB_USER_, _DB_PASSWD_);
mysql_query('SET NAMES UTF8');//this is needed for UTF 8 characters - multilanguage
mysql_select_db(_DB_NAME_);
$productsdd = '';
/*timezone*/
/**/
$language = $this->context->language->iso_code;
if ($language == 'en')
$language = '';
else
$language = '-'.$language;
$front = true;
$styletime = Configuration::get('COUNTDOWNSPECIALS_STYLETIME');
$pagination = Configuration::get('COUNTDOWNSPECIALS_PAGINATION');
$colorp = Configuration::get('COUNTDOWNSPECIALS_COLORP');
$colort = Configuration::get('COUNTDOWNSPECIALS_COLOR');
$fsp = Configuration::get('COUNTDOWNSPECIALS_FSP');
$respo = Configuration::get('COUNTDOWNSPECIALS_RESPO');
$cront = Configuration::get('COUNTDOWNSPECIALS_CRONT');
$paginationn = Configuration::get('COUNTDOWNSPECIALS_PAGINATIONN');
$pagination2 = Configuration::get('COUNTDOWNSPECIALS_PAGINATION2');
$paginationn2 = Configuration::get('COUNTDOWNSPECIALS_PAGINATIONN2');
$widthlo = Configuration::get('COUNTDOWNSPECIALS_WIDTH');
$slidercs = Configuration::get('COUNTDOWNSPECIALS_SLIDERCS');
$delaycs = Configuration::get('COUNTDOWNSPECIALS_DELAYCS');
$but = Configuration::get('COUNTDOWNSPECIALS_BUT');
$cw = Configuration::get('COUNTDOWNSPECIALS_CW');
$pbs = Configuration::get('COUNTDOWNSPECIALS_PBS');
$cf = Configuration::get('COUNTDOWNSPECIALS_CF');
$respop = Configuration::get('COUNTDOWNSPECIALS_RESPOP');
$psversion = _PS_VERSION_;
$enabledp = Configuration::get('COUNTDOWNSPECIALS_ENABLEDP');
$disabledp = Configuration::get('COUNTDOWNSPECIALS_DISABLEDP');
if ($cront == null)
$cront = 0;
if ($enabledp == null)
$enabledp = 0;
if ($disabledp == null)
$disabledp = 0;
if ($psversion < '1.4.0.0')
$pricesDrop = CountdownSpecials::getPricesDropshea($this->context->language->id,
$page_number = 0, 10, $count = false, $orderBy = null, $orderWay = null, $beginning = 1, $ending = 10);
else
$pricesDrop = CountdownSpecials::getPricesDrop2header($this->context->language->id,
$page_number = 0, 10, $count = false, $orderBy = null, $orderWay = null, $beginning = 1, $ending = 10);
$prices_drop = array();
if ($pricesDrop)
foreach ($pricesDrop as $priceDrop)
$productsdd[] = $priceDrop;
/* $id_product = (int)(Tools::getValue('id_product'));
$product = new Product($id_product, true, (int)((int)$this->context->language->id));*/
/*disable products*/
if ($enabledp == 1 && $cront == 0)
{
if ($psversion > '1.4.0.0' && $psversion < '1.5.0.0')
{
$current_date = date('Y-m-d H:i:s');
$sorgudc = mysql_query('
SELECT p.*, sp.`from` AS `reduction_from`, sp.`to` AS `reduction_to`, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
WHERE 1
&& sp.`from` < sp.`to`
&& p.`active` = \'1\'
&& sp.`to` < "'.pSQL($current_date).'"');
}
if ($psversion > '1.5.0.0')
{
$current_date = date('Y-m-d H:i:s');
$sorgudc = mysql_query('
SELECT p.*,ps.*, sp.`from` AS `reduction_from`, sp.`to` AS `reduction_to`, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.`id_product` = ps.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
WHERE 1
&& sp.`from` < sp.`to`
&& p.`active` = \'1\'
&& ps.`id_shop` = \''.(int)$this->context->shop->id.'\'
&& sp.`to` < "'.pSQL($current_date).'"');
}
/*
print_r( '1-
SELECT p.*,ps.*, sp.`from` AS `reduction_from`, sp.`to` AS `reduction_to`, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.`id_product` = ps.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
WHERE 1
&& sp.`from` < sp.`to`
&& p.`active` = \'1\'
&& ps.`id_shop` = \''.$this->context->shop->id.'\'
&& sp.`to` < "'.pSQL($current_date).'"');
*/
if ($psversion < '1.4.0.0')
{
$current_date = date('Y-m-d H:i:s');
$sorgudc = mysql_query('SELECT p.*
FROM `'._DB_PREFIX_.'product` p
WHERE p.reduction_from < p.reduction_to && p.reduction_to < \''.pSQL($current_date).'\' && p.`active` = \'1\'');
}
$veridc = mysql_fetch_assoc($sorgudc);
do
{
$num_rows = mysql_num_rows($sorgudc);
if ($num_rows != null)
{
Db::getInstance()->Execute('UPDATE `'._DB_PREFIX_.'product` SET `active` = \'0\'
WHERE `'._DB_PREFIX_.'product`.`id_product` = \''.@(int)$veridc['id_product'].'\';');
if (_PS_VERSION_ > '1.5.0.0')
{
Db::getInstance()->Execute('UPDATE `'._DB_PREFIX_.'product_shop` SET `active` = \'0\'
WHERE `'._DB_PREFIX_.'product_shop`.`id_product` = \''.@(int)$veridc['id_product'].'\' &&
`'._DB_PREFIX_.'product_shop`.`id_shop` = \''.(int)$this->context->shop->id.'\';');
}
print_r('UPDATE `'._DB_PREFIX_.'product_shop` SET `active` = \'0\'
WHERE `'._DB_PREFIX_.'product_shop`.`id_product` = \''.@(int)$veridc['id_product'].'\' &&
`'._DB_PREFIX_.'product_shop`.`id_shop` = \''.(int)$this->context->shop->id.'\';');
}
} while (@$veridc = mysql_fetch_assoc($sorgudc));
}
/*enable them*/
if ($disabledp == '1' && $cront == 0)
{
if ($psversion > '1.4.0.0' && $psversion < '1.5.0.0')
{
$current_date = date('Y-m-d H:i:s');
$sorgudc = mysql_query('
SELECT p.*, sp.`from` AS `reduction_from`, sp.`to` AS `reduction_to`, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
WHERE 1
&& sp.`from` < sp.`to`
&& p.`active` = \'0\'
&& sp.`from` < "'.pSQL($current_date).'" && sp.`to` > "'.pSQL($current_date).'"');
}
if ($psversion > '1.5.0.0')
{
$current_date = date('Y-m-d H:i:s');
$sorgudc = mysql_query('
SELECT p.*, ps.*, sp.`from` AS `reduction_from`, sp.`to` AS `reduction_to`, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.`id_product` = ps.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
WHERE 1
&& sp.`from` < sp.`to`
&& p.`active` = \'0\'
&& ps.`id_shop` = \''.(int)$this->context->shop->id.'\'
&& sp.`from` < "'.pSQL($current_date).'" && sp.`to` > "'.pSQL($current_date).'"');
}
/*
print_r( '3-
SELECT p.*, ps.*, sp.`from` AS `reduction_from`, sp.`to` AS `reduction_to`, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.`id_product` = ps.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
WHERE 1
&& sp.`from` < sp.`to`
&& p.`active` = \'0\'
&& ps.`id_shop` = \''.$this->context->shop->id.'\'
&& sp.`from` < "'.pSQL($current_date).'"');
*/
if ($psversion < '1.4.0.0')
{
$current_date = date('Y-m-d H:i:s');
$sorgudc = mysql_query('SELECT p.*
FROM `'._DB_PREFIX_.'product` p
WHERE p.`reduction_from` < p.`reduction_to` && p.`reduction_from` < \''.pSQL($current_date).'\' && p.`reduction_to` > "'.pSQL($current_date).'" && p.`active` = \'0\'');
}
$veridc = mysql_fetch_assoc($sorgudc);
do
{
$num_rows = mysql_num_rows($sorgudc);
if ($num_rows != null)
{
Db::getInstance()->Execute('UPDATE `'._DB_PREFIX_.'product` SET `active` = \'1\'
WHERE `'._DB_PREFIX_.'product`.`id_product` = '.@(int)$veridc['id_product'].';');
if (_PS_VERSION_ > '1.5.0.0')
Db::getInstance()->Execute('UPDATE `'._DB_PREFIX_.'product_shop` SET `active` = \'1\'
WHERE `'._DB_PREFIX_.'product_shop`.`id_product` = '.@(int)$veridc['id_product'].' &&
`'._DB_PREFIX_.'product_shop`.`id_shop` = \''.(int)$this->context->shop->id.'\';');
}
} while ($veridc = mysql_fetch_assoc($sorgudc));
}
$special = Product::getRandomSpecial((int)($params['cookie']->id_lang)) && !Configuration::get('PS_BLOCK_SPECIALS_DISPLAY');
$timezone = new DateTimeZone(Configuration::get('PS_TIMEZONE'));
$offset = $timezone->getOffset(new DateTime('now'));
$timenow = date('d.m.Y H:i:s', time());
$this->context->smarty->assign(array(
'pagination' => $pagination,
'paginationn' => $paginationn,
'pagination2' => $pagination2,
'styletime' => $styletime,
'paginationn2' => $paginationn2,
'psversion' => $psversion,
'colorpcs' => $colorp,
'fsp' => $fsp,
'colort' => $colort,
'productlisthp' => CountdownSpecials::productList(),
'priceWithoutReduction_tax_excl' => Tools::ps_round($special['price_without_reduction'], 2),
'special' => $special,
'widthlo' => $widthlo,
'timenow' => $timenow,
'respop' => $respop,
'tzone' => ($offset < 0 ? '' : '+').$offset / 60 / 60,
'slidercs' => $slidercs,
'delaycs' => $delaycs,
'but' => $but,
'cf' => $cf,
'pbs' => $pbs,
'cw' => $cw,
));
if (_PS_VERSION_ > '1.4.0.0' && _PS_VERSION_ < '1.5.0.0')
{
Tools::addJS(__PS_BASE_URI__.'modules/countdownspecials/views/js/ticker.js');
if ($but == '10')
{
Tools::addJS(__PS_BASE_URI__.'modules/countdownspecials/views/js/countdown.js');
//Tools::addJS(__PS_BASE_URI__.'modules/countdownspecials/js/knob.js');
//Tools::addJS(__PS_BASE_URI__.'modules/countdownspecials/js/thro.js');
}
if ($but == '11')
Tools::addJS(__PS_BASE_URI__.'modules/countdownspecials/views/js/circcountdown.js');
if ($but > '0' && $but < '10')
{
Tools::addJS(__PS_BASE_URI__.'modules/countdownspecials/views/js/jquery.plugin.js');
Tools::addJS(__PS_BASE_URI__.'modules/countdownspecials/views/js/jquery.countdown.js');
Tools::addJS(__PS_BASE_URI__.'modules/countdownspecials/views/js/jquery.countdown'.$language.'.js');
}
Tools::addCSS(__PS_BASE_URI__.'modules/countdownspecials/views/css/jquery.countdown.css', 'all');
if ($respo == '1')
Tools::addJS(__PS_BASE_URI__.'modules/countdownspecials/views/js/slippry.js');
else
Tools::addJS(__PS_BASE_URI__.'modules/countdownspecials/views/js/fadeSlideShow.js');
}
if (_PS_VERSION_ > '1.5.0.0')
{
$this->context->controller->addJS(($this->_path).'views/js/ticker.js');
$this->context->controller->addJS(($this->_path).'views/js/jquery.simplyscroll.js');
if ($but == '10')
{
$this->context->controller->addJS(($this->_path).'views/js/countdown.js');
// $this->context->controller->addJS(($this->_path).'js/thro.js');
// $this->context->controller->addJS(($this->_path).'js/knob.js');
}
if ($but == '11')
$this->context->controller->addJS(($this->_path).'views/js/circcountdown.js');
if ($but > '0' && $but < '10')
{
$this->context->controller->addJS(($this->_path).'views/js/jquery.plugin.js');
$this->context->controller->addJS(($this->_path).'views/js/jquery.countdown.js');
$this->context->controller->addJS(($this->_path).'views/js/jquery.countdown'.$language.'.js');
}
$this->context->controller->addCSS(($this->_path).'views/css/'.((_PS_VERSION_ > '1.5.0.0') ?
$this->context->shop->id : '').'jquery.countdown.css', 'all');
if ($respo == '1')
$this->context->controller->addJS(($this->_path).'views/js/slippry.js');
else
$this->context->controller->addJS(($this->_path).'views/js/fadeSlideShow.js');
}
if ($pagination == 'yes' && _PS_VERSION_ > '1.4.0.0' && _PS_VERSION_ < '1.5.0.0')
{
Tools::addJS(__PS_BASE_URI__.'modules/countdownspecials/views/js/easypaginate.js');
//Tools::addJS(__PS_BASE_URI__.'modules/countdownspecials/js/jquery.simplePagination.js');
//Tools::addCSS(__PS_BASE_URI__.'modules/countdownspecials/css/simplePagination.css', 'all');
Tools::addCSS(__PS_BASE_URI__.'modules/countdownspecials/views/css/style.css', 'all');
}
if ($pagination == 'yes' && _PS_VERSION_ > '1.5.0.0')
{
$this->context->controller->addJS(($this->_path).'views/js/easypaginate.js');
//$this->context->controller->addJS(($this->_path).'js/jquery.easyPaginate.js');
//$this->context->controller->addJS(($this->_path).'js/jquery.simplePagination.js');
//$this->context->controller->addCSS(($this->_path).'css/simplePagination.css', 'all');
$this->context->controller->addCSS(($this->_path).'views/css/style.css', 'all');
}
return $this->display(__FILE__, 'views/templates/front/countdownspecials-header.tpl');
}
public function getProductscath($id_product)
{
$result = Db::getInstance()->getRow('
SELECT SUM(od.`product_quantity`) AS totalCount
FROM '._DB_PREFIX_.'order_detail od
WHERE od.product_id = '.(int)$id_product.'');
return $result['totalCount'];
}
public function hookextraLeft($params)
{
return $this->hookextraRight($params);
}
public function hookproductActions($params)
{
return $this->hookextraRight($params);
}
public function hookextraRight($params)
{
$current_date = date('Y-m-d H:i:s');
$styletime = Configuration::get('COUNTDOWNSPECIALS_STYLETIME');
$sales = Configuration::get('COUNTDOWNSPECIALS_SALES');
$id_product = (int)(Tools::getValue('id_product'));
if ($id_product == null)
$id_product = (int)(Tools::getValue('id'));
$result = '
SELECT COUNT(p.`id_product`) AS totalCount
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN '._DB_PREFIX_.'order_detail od ON od.product_id = p.id_product
LEFT JOIN '._DB_PREFIX_.'orders o ON od.id_order = o.id_order
WHERE p.active = 1 AND o.valid = 1 AND p.id_product = '.(int)$id_product.'';
$productsi = CountdownSpecials::getProductscath($id_product);
$psversion = _PS_VERSION_;
if ($psversion < '1.4.0.0')
{
$results = Db::getInstance()->ExecuteS('
SELECT p.*
FROM `'._DB_PREFIX_.'product` p
WHERE p.reduction_from < p.reduction_to && p.reduction_from < \''.pSQL($current_date).'\' &&
p.reduction_to > \''.pSQL($current_date).'\' && p.id_product = '.(int)$id_product.' LIMIT 1');
}
else
{
$results = Db::getInstance()->ExecuteS('
SELECT p.*, sp.from AS reduction_from, sp.to AS reduction_to
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
WHERE sp.from <= sp.to && sp.from <= \''.pSQL($current_date).'\' &&
sp.to >= \''.pSQL($current_date).'\' && p.id_product = '.(int)$id_product.' LIMIT 1');
}
$this->context->smarty->assign(array(
'results' => $results,
'sales' => $sales,
'id_product' => $id_product,
'styletime' => $styletime,
'psversion' => $psversion,
'productsi' => $productsi
));
return $this->display(__FILE__, 'views/templates/front/countdownspecials-product.tpl');
}
public function hookshoppingCart($params)
{
$push = Configuration::get('COUNTDOWNSPECIALS_PUSH');
$beginning2 = '';
$ending2 = '';
$productsd2 = '';
$productsd = '';
$styletime = Configuration::get('COUNTDOWNSPECIALS_STYLETIME');
$respo = Configuration::get('COUNTDOWNSPECIALS_RESPO');
$nbrtop = Configuration::get('COUNTDOWNSPECIALS_NBRTOP');
$widtht = Configuration::get('COUNTDOWNSPECIALS_WIDTHT');
$heightt = Configuration::get('COUNTDOWNSPECIALS_HEIGHTT');
$margin = Configuration::get('COUNTDOWNSPECIALS_MARGIN');
$sort = Configuration::get('COUNTDOWNSPECIALS_SORT');
$widthlo3 = Configuration::get('COUNTDOWNSPECIALS_WIDTH3');
$color2 = Configuration::get('COUNTDOWNSPECIALS_COLOR2');
$color = Configuration::get('COUNTDOWNSPECIALS_COLOR');
$wt = Configuration::get('COUNTDOWNSPECIALS_WT');
$align = Configuration::get('COUNTDOWNSPECIALS_ALIGN');
$imagecs = Configuration::get('COUNTDOWNSPECIALS_IMAGECS');
$styletime = Configuration::get('COUNTDOWNSPECIALS_STYLETIME');
$delaycs = Configuration::get('COUNTDOWNSPECIALS_DELAYCS');
$slidercs = Configuration::get('COUNTDOWNSPECIALS_SLIDERCS');
$sort = Configuration::get('COUNTDOWNSPECIALS_SORT');
$but = Configuration::get('COUNTDOWNSPECIALS_BUT');
$ht = $wt * 60 / 275;
$sa = $this->getImagesID($imagecs);
$imagecs = $sa[0]['name'];
if ($sort == 'ASC')
$sort = 'DESC';
else
$sort = 'ASC';
$psversion = _PS_VERSION_;
if ($psversion < '1.4.0.0')
$pricesDrop = CountdownSpecials::getPricesDropsh($this->context->language->id, $page_number = 0,
$nbrtop, $count = false, $orderBy = $sort, $orderWay = null, $beginning = $beginning2, $ending = $ending2);
else
$pricesDrop = CountdownSpecials::getPricesDrop2($this->context->language->id, $page_number = 0,
$nbrtop, $count = false, $orderBy = $sort, $orderWay = null, $beginning = $beginning2, $ending = $ending2);
$prices_drop = array();
if ($pricesDrop)
foreach ($pricesDrop as $priceDrop)
$productsd2[] = $priceDrop;
if ($push == 1)
{
$this->context->smarty->assign(array(
'productsd2' => $productsd2,
'imagecs' => $imagecs,
'colort' => $color,
'wt' => $wt,
'ht' => $ht,
'respo' => $respo,
'productlist' => CountdownSpecials::productList(),
'widtht' => $widtht,
'heightt' => $heightt,
'slidercs' => $slidercs,
'styletime' => $styletime,
'lang' => 'text_'.(int)$this->context->language->id
));
return $this->display(__FILE__, 'views/templates/front/countdownspecials-push.tpl');
}
}
public function displayFrontForm()
{
$beginning2 = '';
$ending2 = '';
$productsd = '';
$styletime = Configuration::get('COUNTDOWNSPECIALS_STYLETIME');
$nbrpage = Configuration::get('COUNTDOWNSPECIALS_NBRPAGE');
$width3 = Configuration::get('COUNTDOWNSPECIALS_WIDTH3');
$width3h = Configuration::get('COUNTDOWNSPECIALS_WIDTH3H');
$margin = Configuration::get('COUNTDOWNSPECIALS_MARGIN');
$widthlo3 = Configuration::get('COUNTDOWNSPECIALS_WIDTH3');
$color2 = Configuration::get('COUNTDOWNSPECIALS_COLOR2');
$colorbg = Configuration::get('COUNTDOWNSPECIALS_COLORBG');
$align = Configuration::get('COUNTDOWNSPECIALS_ALIGN');
$grid = Configuration::get('COUNTDOWNSPECIALS_GRID');
$delaycs = Configuration::get('COUNTDOWNSPECIALS_DELAYCS');
$rad = Configuration::get('COUNTDOWNSPECIALS_RAD');
$listw = Configuration::get('COUNTDOWNSPECIALS_LISTW');
$imagesizeh = Configuration::get('COUNTDOWNSPECIALS_IMAGESIZEH');
$imageh = Configuration::get('COUNTDOWNSPECIALS_IMAGEH');
$sort = Configuration::get('COUNTDOWNSPECIALS_SORT');
$wth = Configuration::get('COUNTDOWNSPECIALS_WTH');
$hth = $wth * 60 / 275;
$sa = $this->getImagesID($imageh);
$imageh = $sa[0]['name'];
$psversion = _PS_VERSION_;
if ($psversion < '1.4.0.0')
$pricesDrop = CountdownSpecials::getPricesDropsh((int)$this->context->language->id,
$page_number = 0, $nbrpage, $count = false, $orderBy = $sort, $orderWay = null, $beginning = $beginning2, $ending = $ending2);
else
$pricesDrop = CountdownSpecials::getPricesDrop2((int)$this->context->language->id,
$page_number = 0, $nbrpage, $count = false, $orderBy = $sort, $orderWay = null, $beginning = $beginning2, $ending = $ending2);
$prices_drop = array();
if ($pricesDrop)
foreach ($pricesDrop as $priceDrop)
$productsd[] = $priceDrop;
$this->context->smarty->assign(array(
'productsd' => $productsd,
'color2' => $color2,
'widthlo3' => $widthlo3,
'margin' => $margin,
'styletime' => $styletime,
'psversion' => $psversion,
'align' => $align,
'width3' => $width3,
'width3h' => $width3h,
'delaycs' => $delaycs,
'grid' => $grid,
'colorbg' => $colorbg,
'rad' => $rad,
'hth' => $hth,
'wth' => $wth,
'listw' => $listw,
'imagesizeh' => $imagesizeh,
'imageh' => $imageh
));
return $this->display(__FILE__, 'views/templates/front/countdownspecials-page.tpl');
}
public function deleteExp()
{
$orderBy = null;
$orderWay = null;
$beginning = true;
$ending = false;
$current_date = date('Y-m-d H:i:s');
@mysql_connect(_DB_SERVER_, _DB_USER_, _DB_PASSWD_);
mysql_query('SET NAMES UTF8');//this is needed for UTF 8 characters - multilanguage
mysql_select_db(_DB_NAME_);
if (_PS_VERSION_ > '1.4.0.0' && _PS_VERSION_ < '1.5.0.0')
{
$sql2 = '
SELECT * FROM `'._DB_PREFIX_.'specific_price`
WHERE sp.from < sp.to && sp.from <= \''.pSQL($current_date).'\' && sp.to < \''.pSQL($current_date).'\'
';
}
if (_PS_VERSION_ > '1.5.0.0')
{
$current_date = date('Y-m-d H:i:s');
$sql2 = '
SELECT * FROM
`'._DB_PREFIX_.'specific_price` sp
WHERE sp.from < sp.to && sp.from <= \''.pSQL($current_date).'\' &&
sp.to < \''.pSQL($current_date).'\' && sp.id_shop = '.(int)$this->context->shop->id.'
';
}
if (_PS_VERSION_ < '1.4.0.0')
{
$sql2 = '
SELECT p.*
FROM `'._DB_PREFIX_.'product` p
WHERE p.reduction_from < p.reduction_to && p.reduction_to < \''.pSQL($current_date).'\'
GROUP BY p.`id_product`';
}
$pricesDrop2 = Db::getInstance()->ExecuteS($sql2);
$resulttt = mysql_query($sql2);
$prices_drop2 = array();
if (_PS_VERSION_ > '1.5.0.0')
{
foreach ($prices_drop2 as $pr)
Db::getInstance()->Execute('DELETE FROM `'._DB_PREFIX_.'specific_price`
WHERE `id_specific_price` = '.(int)$pr['id_specific_price'].';');
}
$this->displayConfirmation($this->l('Expired time offers deleted').'
');
}
public function hookDisplayBanner($params)
{
return $this->hookDisplayNav($params);
}
public function hookDisplayNav($params)
{
$id_cat = (int)(Tools::getValue('id_category'));
$categ = $this->getPricesDropshPR($id_cat);
$styletime = Configuration::get('COUNTDOWNSPECIALS_STYLETIME');
$catw = Configuration::get('COUNTDOWNSPECIALS_CATW');
$wthcat = Configuration::get('COUNTDOWNSPECIALS_CATW');
$catcolor = Configuration::get('COUNTDOWNSPECIALS_CATCOLOR');
$catcolor2 = Configuration::get('COUNTDOWNSPECIALS_CATCOLOR2');
$hthcat = $wthcat * 60 / 275;
$this->context->smarty->assign(array(
'categs' => $categ,
'catcolor' => $catcolor,
'styletime' => $styletime,
'catw' => $catw,
'cathth' => $hthcat,
'catcolor2' => $catcolor2,
'psversion' => _PS_VERSION_,
));
return $this->display(__FILE__, 'views/templates/front/countdownspecials-nav.tpl');
}
public function getPricesDropshPR($id_cat)
{
$current_date = date('Y-m-d H:i:s');
$sql = '
SELECT spr.*, sprc.*, sprg.*,cat.*
FROM `'._DB_PREFIX_.'specific_price_rule` spr
LEFT JOIN `'._DB_PREFIX_.'specific_price_rule_condition_group` sprg ON (sprg.`id_specific_price_rule` = spr.`id_specific_price_rule`)
LEFT JOIN `'._DB_PREFIX_.'specific_price_rule_condition` sprc ON (sprc.`id_specific_price_rule_condition_group` = sprg.`id_specific_price_rule_condition_group`)
LEFT JOIN `'._DB_PREFIX_.'category` cat ON (sprc.`value` = cat.`id_parent`)
WHERE spr.`reduction` > 0 && spr.`from` <= \''.pSQL($current_date).'\' && spr.`to` >= \''.pSQL($current_date).'\' && spr.`from` < spr.`to` && sprc.`type` = \'category\' && sprc.`value` = \''.$id_cat.'\' OR spr.`reduction` > 0 && spr.`from` <= \''.pSQL($current_date).'\' && spr.`to` >= \''.pSQL($current_date).'\' && spr.`from` < spr.`to` && sprc.`type` = \'category\' && sprc.`value` = cat.`id_parent` && cat.`id_category` = \''.$id_cat.'\'
LIMIT 1';
$result = Db::getInstance()->ExecuteS($sql);
if (!$result)
return false;
return $result;
}
public function hookDisplayHomeTab($params)
{
$home6 = Configuration::get('COUNTDOWNSPECIALS_HOME6');
if ($home6 == 'Tab')
return $this->display(__FILE__, 'views/templates/front/tab.tpl');
}
public function hookDisplayHomeTabContent($params)
{
$beginning2 = '';
$ending2 = '';
$productsd2 = '';
$productsd = '';
$styletime = Configuration::get('COUNTDOWNSPECIALS_STYLETIME');
$nbr = Configuration::get('COUNTDOWNSPECIALS_NBR');
$home6 = Configuration::get('COUNTDOWNSPECIALS_HOME6');
$width3 = Configuration::get('COUNTDOWNSPECIALS_WIDTH3');
$width3h = Configuration::get('COUNTDOWNSPECIALS_WIDTH3H');
$margin = Configuration::get('COUNTDOWNSPECIALS_MARGIN');
$widthlo3 = Configuration::get('COUNTDOWNSPECIALS_WIDTH3');
$hpcp = Configuration::get('COUNTDOWNSPECIALS_HP');
$color2 = Configuration::get('COUNTDOWNSPECIALS_COLOR2');
$colorbg = Configuration::get('COUNTDOWNSPECIALS_COLORBG');
$align = Configuration::get('COUNTDOWNSPECIALS_ALIGN');
$grid = Configuration::get('COUNTDOWNSPECIALS_GRID');
$delaycs = Configuration::get('COUNTDOWNSPECIALS_DELAYCS');
$rad = Configuration::get('COUNTDOWNSPECIALS_RAD');
$wth = Configuration::get('COUNTDOWNSPECIALS_WTH');
$cw = Configuration::get('COUNTDOWNSPECIALS_CW');
$hth = $wth * 60 / 275;
$wth2 = 220;
$listw = Configuration::get('COUNTDOWNSPECIALS_LISTW');
$imagesizeh = Configuration::get('COUNTDOWNSPECIALS_IMAGESIZEH');
$imageh = Configuration::get('COUNTDOWNSPECIALS_IMAGEH');
$sort = Configuration::get('COUNTDOWNSPECIALS_SORT');
$sa = $this->getImagesID($imageh);
$imageh = $sa[0]['name'];
$psversion = _PS_VERSION_;
if ($psversion < '1.4.0.0')
$pricesDrop = CountdownSpecials::getPricesDropsh($this->context->language->id, $page_number = 0, $nbr,
$count = false, $orderBy = $sort, $orderWay = null, $beginning = $beginning2, $ending = $ending2);
else
$pricesDrop = CountdownSpecials::getPricesDrop2($this->context->language->id, $page_number = 0, $nbr,
$count = false, $orderBy = $sort, $orderWay = null, $beginning = $beginning2, $ending = $ending2);
$prices_drop = array();
if ($pricesDrop)
foreach ($pricesDrop as $priceDrop)
$productsd[] = $priceDrop;
$this->context->smarty->assign(array(
'productsd' => $productsd,
'color2' => $color2,
'hpcp' => $hpcp,
'widthlo3' => $widthlo3,
'margin' => $margin,
'styletime' => $styletime,
'psversion' => $psversion,
'align' => $align,
'width3' => $width3,
'wth' => $wth,
'wth2' => $wth2,
'hth' => $hth,
'width3h' => $width3h,
'delaycs' => $delaycs,
'grid' => $grid,
'rad' => $rad,
'colorbg' => $colorbg,
'listw' => $listw,
'imageh' => $imageh,
'imagesizeh' => $imagesizeh,
'nbrcs' => $nbr
));
if ($home6 == 'Tab')
return $this->display(__FILE__, 'views/templates/front/product-list.tpl');
}
public function hookFooter($params)
{
return $this->display(__FILE__, 'views/templates/front/countdownspecials-footer.tpl');
}
public function cron()
{
@mysql_connect(_DB_SERVER_, _DB_USER_, _DB_PASSWD_);
mysql_query('SET NAMES UTF8');//this is needed for UTF 8 characters - multilanguage
mysql_select_db(_DB_NAME_);
$productsdd = '';
$front = true;
$psversion = _PS_VERSION_;
$cront = Configuration::get('COUNTDOWNSPECIALS_CRONT');
$enabledp = Configuration::get('COUNTDOWNSPECIALS_ENABLEDP');
$disabledp = Configuration::get('COUNTDOWNSPECIALS_DISABLEDP');
/* $id_product = (int)(Tools::getValue('id_product'));
$product = new Product($id_product, true, (int)((int)$this->context->language->id));*/
/*disable products*/
if ($enabledp == 1 && $cront == 1)
{
if ($psversion > '1.4.0.0' && $psversion < '1.5.0.0')
{
$current_date = date('Y-m-d H:i:s');
$sorgudc = mysql_query('
SELECT p.*, sp.`from` AS `reduction_from`, sp.`to` AS `reduction_to`, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
WHERE 1
&& sp.`from` < sp.`to`
&& p.`active` = 1 && p.`price` > 0
&& sp.`to` < "'.pSQL($current_date).'"');
}
if ($psversion > '1.5.0.0')
{
$current_date = date('Y-m-d H:i:s');
$sorgudc = mysql_query('
SELECT p.*,ps.*, sp.`from` AS `reduction_from`, sp.`to` AS `reduction_to`, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.`id_product` = ps.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
WHERE 1
&& sp.`from` < sp.`to`
&& p.`active` = 1
&& ps.`active` = 1
&& p.`price` > 0
&& ps.`id_shop` = '.(int)$this->context->shop->id.'
&& sp.`to` < "'.pSQL($current_date).'"');
}
if ($psversion < '1.4.0.0')
{
$current_date = date('Y-m-d H:i:s');
$sorgudc = mysql_query('SELECT p.*
FROM `'._DB_PREFIX_.'product` p
WHERE p.reduction_from < p.reduction_to && p.reduction_to < \''.pSQL($current_date).'\' && p.`active` = 1 && p.`price` > 0 ');
}
$veridc = mysql_fetch_assoc($sorgudc);
do
{
$num_rows = mysql_num_rows($sorgudc);
if ($num_rows != null)
{
Db::getInstance()->Execute('UPDATE `'._DB_PREFIX_.'product` SET `active` = \'0\'
WHERE `'._DB_PREFIX_.'product`.`id_product` = '.@(int)$veridc['id_product'].';');
if (_PS_VERSION_ > '1.5.0.0')
Db::getInstance()->Execute('UPDATE `'._DB_PREFIX_.'product_shop` SET `active` = \'0\'
WHERE `'._DB_PREFIX_.'product_shop`.`id_product` = '.@(int)$veridc['id_product'].' &&
`'._DB_PREFIX_.'product_shop`.`id_shop` = '.(int)$this->context->shop->id.';');
}
} while (@$veridc = mysql_fetch_assoc($sorgudc));
}
/*enable them*/
if ($disabledp == 1 && $cront == 1)
{
if ($psversion > '1.4.0.0' && $psversion < '1.5.0.0')
{
$current_date = date('Y-m-d H:i:s');
$sorgudc = mysql_query('
SELECT p.*, sp.`from` AS `reduction_from`, sp.`to` AS `reduction_to`, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
WHERE 1
&& sp.`from` < sp.`to`
&& p.`active` = 0
&& sp.`from` < "'.pSQL($current_date).'" && sp.`to` > "'.pSQL($current_date).'"');
}
if ($psversion > '1.5.0.0')
{
$current_date = date('Y-m-d H:i:s');
$sorgudc = mysql_query('
SELECT p.*, ps.*, sp.`from` AS `reduction_from`, sp.`to` AS `reduction_to`, sp.`id_product`
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.`id_product` = ps.`id_product`)
LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (p.`id_product` = sp.`id_product`)
WHERE 1
&& sp.`from` < sp.`to`
&& p.`active` = 0
&& ps.`active` = 0
&& ps.`id_shop` = '.(int)$this->context->shop->id.'
&& sp.`from` < "'.pSQL($current_date).'" && sp.`to` > "'.pSQL($current_date).'"');
}
if ($psversion < '1.4.0.0')
{
$current_date = date('Y-m-d H:i:s');
$sorgudc = mysql_query('SELECT p.*
FROM `'._DB_PREFIX_.'product` p
WHERE p.`reduction_from` < p.`reduction_to` && p.`reduction_from` < \''.pSQL($current_date).'\' && p.`reduction_to` > "'.pSQL($current_date).'" && p.`active` = \'0\'');
}
$veridc = mysql_fetch_assoc($sorgudc);
do
{
$num_rows = mysql_num_rows($sorgudc);
if ($num_rows != null)
{
Db::getInstance()->Execute('UPDATE `'._DB_PREFIX_.'product` SET `active` = \'1\'
WHERE `'._DB_PREFIX_.'product`.`id_product` = '.@(int)$veridc['id_product'].';');
if (_PS_VERSION_ > '1.5.0.0')
Db::getInstance()->Execute('UPDATE `'._DB_PREFIX_.'product_shop` SET `active` = \'1\'
WHERE `'._DB_PREFIX_.'product_shop`.`id_product` = '.@(int)$veridc['id_product'].' &&
`'._DB_PREFIX_.'product_shop`.`id_shop` = '.(int)$this->context->shop->id.';');
}
} while ($veridc = mysql_fetch_assoc($sorgudc));
}
// $special = Product::getRandomSpecial((int)($params['cookie']->id_lang)) && !Configuration::get('PS_BLOCK_SPECIALS_DISPLAY');
}
}
}
?>