1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110
|
function calcul_transport()
{
//Recuperation des variables de session
global $HTTP_SESSION_VARS;
$sid = session_id();
$artqty = $HTTP_SESSION_VARS['articles'];
//Requete sur les donnes a recuperer de la db
$query = "SELECT orders.sessionid, orders.ship_zip, orders.orderid, order_items.qte, order_items.orderid FROM orders, order_items WHERE orders.orderid = order_items.orderid AND orders.sessionid = '$sid' LIMIT 1";
$result = mysql_db_query("cave_cjd", $query);
//Recuperation des donnees code postal et categorie article
if ($voir = mysql_fetch_array($result)) {
$dep = $voir['ship_zip'];
//echo ' Code Postal :';
//echo $dep;
}
//Recuperation des deux premiers caracteres du code postal
$verif_dep = substr("$dep",0,2);
//echo ' Dep :';
//echo $verif_dep;
//Recuperation de la quantite d'articles pour chaque article et multiplier par le poids
$query = " SELECT SUM(poids) AS 'somme'
FROM order_items, orders
WHERE order_items.orderid = orders.orderid
AND orders.sessionid = '$sid'";
$result = mysql_query($query);
$total_poids = mysql_fetch_array($result);
$poids = $total_poids['somme'];
//echo ' Poids :';
//echo $poids;
//Definir dans quelle categorie de poids se trouve la commande en cours
if ($poids <=5.99) {
$idcategorie = 1;
}
else if ($poids >= 6 && $poids <= 10.99) {
$idcategorie = 2;
}
else if ($poids >= 11 && $poids <= 15.99) {
$idcategorie = 3;
}
else if ($poids >= 16 && $poids <= 20.99) {
$idcategorie = 4;
}
else if ($poids >= 21 && $poids <= 30) {
$idcategorie = 5;
}
else {
echo 'Nous contacter pour obtenir les frais de port pour cette quantité';
}
//echo ' Id cat :';
//echo $idcategorie;
//Traitement du prix du transport de chaque articles
if ($verif_dep == 86) {
$query = " SELECT *
FROM ship_price
WHERE id = $idcategorie";
$result_sql = mysql_db_query("cave_cjd", $query);
if ($voir = mysql_fetch_array($result_sql)) {
$shipping = $voir['zonevienne'];
//echo $result;
}
}
else if ($verif_dep == 20) {
$query = " SELECT *
FROM ship_price
WHERE id = $idcategorie";
$result_sql = mysql_db_query("cave_cjd", $query);
if ($voir = mysql_fetch_array($result_sql)) {
$shipping = $voir['zonecorse'];
//echo $result;
}
}
else if ($verif_dep == 16 || 17 || 18 || 19 || 23 || 24 || 33 || 36 || 37 || 41 || 44 || 49 || 53 || 72 || 79 || 85 || 87) {
$query = " SELECT *
FROM ship_price
WHERE id = $idcategorie";
$result_sql = mysql_db_query("cave_cjd", $query);
if ($voir = mysql_fetch_array($result_sql)) {
$shipping = $voir['zoneregion'];
//echo $result;
}
}
else {
$query = " SELECT *
FROM ship_price
WHERE id = $idcategorie";
$result_sql = mysql_db_query("cave_cjd", $query);
if ($voir = mysql_fetch_array($result_sql)) {
$shipping = $voir['zonenation'];
//echo $result;
}
}
return $shipping;
} |
Partager