/**
* Lists of delivery time
* @param bool $active
* @return array
*/
public static function getDeliveryTime($iIdLang = null)
{
if (is_null($iIdLang)) {
$iIdLang = (int) Context::getContext()->language->id;
}
$sSQL = '
SELECT dt.*, dtl.*, c.*
FROM `' . _DB_PREFIX_ . 'now_delivery_time` dt
' . Shop::addSqlAssociation('now_delivery_time', 'dt') . '
INNER JOIN `' . _DB_PREFIX_ . 'now_delivery_time_lang` dtl ON (dt.`id_now_delivery_time` = dtl.`id_now_delivery_time` AND dtl.`id_lang` = ' . (int) $iIdLang . ')
LEFT JOIN `' . _DB_PREFIX_ . 'carrier` c ON (c.`id_carrier` = dt.`id_carrier`)
WHERE dt.`deleted` = 0';
$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sSQL);
foreach ($result as &$row) {
if (file_exists(_PS_SHIP_IMG_DIR_ . $row['id_carrier'] . '.jpg')) {
$row['logo'] = _THEME_SHIP_DIR_ . $row['id_carrier'] . '.jpg';
} else {
$row['logo'] = false;
}
// Définition de la date de livraison minimum
$row['shipping_date_min'] = NowDeliveryTime::getDateMinDeliveryTime(new DateTime(), (int) $row['day_min'], (bool) $row['saturday_shipping'], (bool) $row['sunday_shipping'], (bool) $row['shipping_holidays'], (bool) $row['saturday_delivery'], (bool) $row['sunday_delivery'], (bool) $row['delivery_holidays']);
}
return $result;
}
/**
* hook: displayCarrierDeliveryTimeList
* @param $aParams
*/
public function hookDisplayCarrierDeliveryTimeList($aParams)
{
$this->context->smarty->assign(array('aDeliveryTimeList' => NowDeliveryTime::getDeliveryTime(), 'sDateFormat' => Configuration::get('NOW_DT_DATE_FORMAT')));
return $this->context->smarty->fetch($this->module_dir . 'views/templates/hook/product-delivery.tpl');
}
