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