<?php include dirname(__FILE__) . '/../../../config/config.inc.php'; include dirname(__FILE__) . '/../../../init.php'; include dirname(__FILE__) . '/../mondialrelay.php'; global $cookie; $cart = new Cart($cookie->id_cart); $result_MR = Db::getInstance()->ExecuteS("SELECT * FROM " . _DB_PREFIX_ . "mr_method WHERE id_carrier='" . (int) $cart->id_carrier . "' ;"); Db::getInstance()->delete(_DB_PREFIX_ . 'mr_selected', 'id_cart = "' . (int) $cart->id . '"'); $mrselected = new MondialRelayClass(); $mrselected->id_customer = $cart->id_customer; $mrselected->id_method = $result_MR[0]['id_mr_method']; $mrselected->id_cart = $cart->id; $mrselected->MR_Selected_Num = $_POST['Num']; $mrselected->MR_Selected_LgAdr1 = $_POST['LgAdr1']; $mrselected->MR_Selected_LgAdr2 = $_POST['LgAdr2']; $mrselected->MR_Selected_LgAdr3 = $_POST['LgAdr3']; $mrselected->MR_Selected_LgAdr4 = $_POST['LgAdr4']; $mrselected->MR_Selected_CP = $_POST['CP']; $mrselected->MR_Selected_Ville = $_POST['Ville']; $mrselected->MR_Selected_Pays = $_POST['Pays']; $mrselected->save();
public function hookProcessCarrier($params, $redirect = true) { $cart = $params['cart']; $result_MR = Db::getInstance()->ExecuteS('SELECT * FROM `' . _DB_PREFIX_ . 'mr_method` WHERE `id_carrier` = ' . (int) $cart->id_carrier); if (count($result_MR) > 0) { $mr_mode_liv = $result_MR[0]['mr_ModeLiv']; if ($mr_mode_liv == 'LDS' || $mr_mode_liv == 'LD1') { $deliveryAddressLDS = new Address((int) $cart->id_address_delivery); if (Validate::isLoadedObject($deliveryAddressLDS) and $deliveryAddressLDS->id_customer == $cart->id_customer) { Db::getInstance()->delete(_DB_PREFIX_ . 'mr_selected', 'id_cart = "' . (int) $cart->id . '"'); $mrselected = new MondialRelayClass(); $mrselected->id_customer = $cart->id_customer; $mrselected->id_method = $result_MR[0]['id_mr_method']; $mrselected->id_cart = $cart->id; $mrselected->MR_Selected_Num = $mr_mode_liv; $mrselected->save(); } } else { if (!Configuration::get('PS_ORDER_PROCESS_TYPE')) { // Redirect is set to false in Presta 1.3 for compatibility // when this method is called under an ajax process if (empty($_POST['MR_Selected_Num_' . $cart->id_carrier]) && $redirect) { // Case error : the customer didn't choose a 'relais' but selected Relais Colis TNT as a carrier Tools::redirect('order.php?step=2&mr_null'); } else { Db::getInstance()->delete(_DB_PREFIX_ . 'mr_selected', 'id_cart = "' . (int) $cart->id . '"'); $mrselected = new MondialRelayClass(); $mrselected->id_customer = $cart->id_customer; $mrselected->id_method = $result_MR[0]['id_mr_method']; $mrselected->id_cart = $cart->id; $mrselected->MR_Selected_Num = $_POST['MR_Selected_Num_' . $cart->id_carrier]; $mrselected->MR_Selected_LgAdr1 = $_POST['MR_Selected_LgAdr1_' . $cart->id_carrier]; $mrselected->MR_Selected_LgAdr2 = $_POST['MR_Selected_LgAdr2_' . $cart->id_carrier]; $mrselected->MR_Selected_LgAdr3 = $_POST['MR_Selected_LgAdr3_' . $cart->id_carrier]; $mrselected->MR_Selected_LgAdr4 = $_POST['MR_Selected_LgAdr4_' . $cart->id_carrier]; $mrselected->MR_Selected_CP = $_POST['MR_Selected_CP_' . $cart->id_carrier]; $mrselected->MR_Selected_Ville = $_POST['MR_Selected_Ville_' . $cart->id_carrier]; $mrselected->MR_Selected_Pays = $_POST['MR_Selected_Pays_' . $cart->id_carrier]; $mrselected->save(); } } } } }
private function displayOrdersTable() { global $cookie; include_once dirname(__FILE__) . '/mondialrelay.php'; $mondialrelay = new MondialRelay(); $order_state = new OrderState((int) Configuration::get('MONDIAL_RELAY_ORDER_STATE'), $cookie->id_lang); $mr_weight_coef = (int) Configuration::get('MR_WEIGHT_COEF'); $html = ' <script type="text/javascript"> function checked_all() { var checkbox = document.getElementsByTagName(\'input\'); for (var i=0; i<checkbox.length; i++) { if (checkbox[i].type == "checkbox" && checkbox[i].getAttribute("mask_mr")==1) {checkbox[i].checked = true;} } } function un_checked_all() { var checkbox = document.getElementsByTagName(\'input\'); for (var i=0; i<checkbox.length; i++) { if (checkbox[i].type == "checkbox" && checkbox[i].getAttribute("mask_mr")==1) {checkbox[i].checked = false;} } } function checked_all_h() { var checkbox = document.getElementsByTagName(\'input\'); for (var i=0; i<checkbox.length; i++) { if (checkbox[i].type == "checkbox" && checkbox[i].getAttribute("mask_mr_h")==1) {checkbox[i].checked = true;} } } function un_checked_all_h() { var checkbox = document.getElementsByTagName(\'input\'); for (var i=0; i<checkbox.length; i++) { if (checkbox[i].type == "checkbox" && checkbox[i].getAttribute("mask_mr_h")==1) {checkbox[i].checked = false;} } } </script> '; if (Tools::isSubmit('updatesuccess')) { $html .= '<div class="conf confirm"><img src="' . _PS_ADMIN_IMG_ . '/ok.gif" /> ' . $mondialrelay->getL('Settings updated succesfull') . '</div>'; } $html .= $mondialrelay->getL('To generate sticks, you must have register a correct address of your store on') . ' <a href="index.php?tab=AdminContact&token=' . Tools::getAdminToken('AdminContact' . (int) Tab::getIdFromClassName('AdminContact') . (int) $cookie->id_employee) . '" class="green">' . $mondialrelay->getL('The contact page') . '</a>'; $html .= '<p>' . $mondialrelay->getL('All orders which have the state') . ' "<b>' . $order_state->name . '</b>"'; $html .= '. <a href="index.php?tab=AdminModules&configure=mondialrelay&token=' . Tools::getAdminToken('AdminModules' . (int) Tab::getIdFromClassName('AdminModules') . (int) $cookie->id_employee) . '" class="green">' . $mondialrelay->getL('Change configuration') . '</a></p>'; $orders = MondialRelayClass::getOrders(); if (empty($orders)) { $html .= '<h3>' . $mondialrelay->getL('No orders with this state.') . '</h3>'; } else { $html .= '<form method="post" action="' . $_SERVER['REQUEST_URI'] . '">'; $html .= "\n<table class=\"table\">"; $html .= '<tr>'; $html .= '<th>' . $mondialrelay->getL('Order ID') . '</th>'; $html .= '<th>' . $mondialrelay->getL('Customer') . '</th>'; $html .= '<th>' . $mondialrelay->getL('Total price') . '</th>'; $html .= '<th>' . $mondialrelay->getL('Total shipping') . '</th>'; $html .= '<th>' . $mondialrelay->getL('Date') . '</th>'; $html .= '<th>' . $mondialrelay->getL('Put a Weight (grams)') . '</th>'; $html .= '<th>' . $mondialrelay->getL('Selected') . '<br><a href="#" onclick="checked_all(); return false;">' . $mondialrelay->getL('All') . '</a> | <a href="#" onclick="un_checked_all(); return false;">' . $mondialrelay->getL('None') . '</a></th>'; $html .= '<th>' . $mondialrelay->getL('MR_Selected_Num') . '</th>'; $html .= '<th>' . $mondialrelay->getL('MR_Selected_Pays') . '</th>'; $html .= '<th>' . $mondialrelay->getL('exp_number') . '</th>'; $html .= '<th>' . $mondialrelay->getL('Detail') . '</th>'; $html .= '</tr>'; foreach ($orders as $order) { if ($order['weight'] == 0) { $result_weight = Db::getInstance()->getRow(' SELECT SUM(product_weight*product_quantity) as weight FROM ' . _DB_PREFIX_ . 'order_detail WHERE id_order = ' . (int) $order['id_order']); $order['weight'] = round($mr_weight_coef * $result_weight['weight']); } $html .= "\n<tr>"; $html .= '<td>' . $order['id_order'] . ' <input type="hidden" name="order[' . $order['id_order'] . '][id]" id="id_order_' . $order['id_order'] . '" value="' . $order['id_order'] . '" /> <input type="hidden" name="order[' . $order['id_order'] . '][id_cart]" id="id_cart' . $order['id_order'] . '" value="' . $order['id_cart'] . '" /> <input type="hidden" name="order[' . $order['id_order'] . '][id_mr_selected]" id="id_mr_selected' . $order['id_order'] . '" value="' . $order['id_mr_selected'] . '" /> <input type="hidden" name="order[' . $order['id_order'] . '][id_address_delivery]" id="id_address_delivery' . $order['id_order'] . '" value="' . $order['id_address_delivery'] . '"/> <input type="hidden" name="order[' . $order['id_order'] . '][mr_ModeCol]" id="mr_ModeCol' . $order['id_order'] . '" value="' . $order['mr_ModeCol'] . '" /> <input type="hidden" name="order[' . $order['id_order'] . '][mr_ModeLiv]" id="mr_ModeLiv' . $order['id_order'] . '" value="' . $order['mr_ModeLiv'] . '" /> <input type="hidden" name="order[' . $order['id_order'] . '][mr_ModeAss]" id="mr_ModeAss' . $order['id_order'] . '" value="' . $order['mr_ModeAss'] . '" /> </td>'; $html .= '<td>' . $order['customer'] . ' <input type="hidden" name="order[' . $order['id_order'] . '][id_customer]" id="id_customer_' . $order['id_order'] . '" value="' . $order['id_customer'] . '" /></td>'; $html .= '<td>' . Tools::displayPrice($order['total'], new Currency($order['id_currency'])) . '</td>'; $html .= '<td>' . Tools::displayPrice($order['shipping'], new Currency($order['id_currency'])) . '</td>'; $html .= '<td>' . Tools::displayDate($order['date'], $order['id_lang']) . '</td>'; $html .= '<td><input type="text" name="order[' . $order['id_order'] . '][weight]" id="weight_' . $order['id_order'] . '" size="7" value="' . $order['weight'] . '" onchange="document.getElementById(\'selected_' . $order['id_order'] . '\').checked=true;" /></td>'; $html .= '<td><input type="checkbox" mask_mr=1 name="order[' . $order['id_order'] . '][selected]" id="selected_' . $order['id_order'] . '" value="1" /></td>'; $html .= '<td>' . $order['MR_Selected_Num'] . ' <input type="hidden" name="order[' . $order['id_order'] . '][MR_Selected_Num]" id="MR_Selected_Num' . $order['id_order'] . '" value="' . $order['MR_Selected_Num'] . '" /></td>'; $html .= '<td>' . $order['MR_Selected_Pays'] . ' <input type="hidden" name="order[' . $order['id_order'] . '][MR_Selected_Pays]" id="id_customer_' . $order['id_order'] . '" value="' . $order['MR_Selected_Pays'] . '" /></td>'; $html .= '<td>' . $order['exp_number'] . ' <input type="hidden" name="order[' . $order['id_order'] . '][exp_number]" id="id_customer_' . $order['id_order'] . '" value="' . $order['exp_number'] . '" /></td>'; $html .= '<td class="center"> <a href="index.php?tab=AdminOrders&id_order=' . $order['id_order'] . '&vieworder&token=' . Tools::getAdminToken('AdminOrders' . (int) Tab::getIdFromClassName('AdminOrders') . (int) $cookie->id_employee) . '"> <img border="0" title="' . $mondialrelay->getL('View') . '" alt="' . $mondialrelay->getL('View') . '" src="' . _PS_IMG_ . 'admin/details.gif"/></a> </td>'; $html .= '</tr>'; } $html .= '</table>'; $html .= '<input type="submit" name="generate" id="generate" value="' . $mondialrelay->getL('Generate') . '" class="button" />'; $html .= '</form>'; } return $html; }