} } catch (Exception $ex) { echomsg('Unable to retrieve currency conversion list', true); } } function echomsg($message, $alert = false) { $tnow = date('Y-m-d H:i:s'); echo "\n{$tnow} - {$message}"; if ($alert) { $event = 'Currency Conversion Rates Update Failed'; $templateVars = array(); $templateVars['{event}'] = $event; $templateVars['{description}'] = $message; $to_email = array('*****@*****.**', '*****@*****.**', '*****@*****.**'); @Mail::Send(1, 'alert', $event, $templateVars, $to_email, null, '*****@*****.**', 'Indusdiva.com', NULL, NULL, _PS_MAIL_DIR_, false); } } //deleteIndex($client); //deleteByIds($client); //$sql = "select id_product from ps_product where active = 0"; $sql = "select id_product from ps_category_product where id_category=141"; $product_ids = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($sql); $product_ids = array_map(function ($product) { return $product['id_product']; }, $product_ids); //$product_ids = array(72039, 72038); print_r(count($product_ids)); //addProducts($client); addProducts($client, $product_ids);
<?php session_start(); if (isset($_GET['reset'])) { $_SESSION["cart"] = array(); } if (!isset($_SESSION["cart"])) { $_SESSION["cart"] = array(); } // Nous ajoutons simplement un tableau contenant les informations sur le produit au niveau du panier function addProducts($name, $quantity, $unit_price) { $_SESSION["cart"][] = array('name' => $name, 'quantity' => $quantity, 'unit_price' => $unit_price, 'total_price' => $quantity * $unit_price); } if (isset($_POST['cartpush'])) { addProducts($_POST['name'], $_POST['quantity'], $_POST['price']); } ?> <html> <head> <title>La boutique de Sandra</title> <style type="text/css"> body{ background-color: #272727; font-family: Arial; font-size: 14px; } h1{ font-weight: 500; } .container{
$sql .= " END"; Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($sql); echomsg("All Currencies Conversions Updated Successfully"); //add USD to INR in history table $today = date("Y-m-d 00:00:00"); $sql = "insert into ps_currency_rates values('{$today}','{$inr_rate}')"; Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($sql); } else { echomsg("Base Currency not in US", true); } } catch (Exception $ex) { echomsg('Unable to retrieve currency conversion list', true); } } function echomsg($message, $alert = false) { $tnow = date('Y-m-d H:i:s'); echo "\n{$tnow} - {$message}"; if ($alert) { $event = 'Currency Conversion Rates Update Failed'; $templateVars = array(); $templateVars['{event}'] = $event; $templateVars['{description}'] = $message; $to_email = array('*****@*****.**', '*****@*****.**', '*****@*****.**'); @Mail::Send(1, 'alert', $event, $templateVars, $to_email, null, '*****@*****.**', 'Indusdiva.com', NULL, NULL, _PS_MAIL_DIR_, false); } } //deleteIndex($client); //deleteByIds($client); addProducts($client);