0) {//Carlos
tep_db_query("update ps_orders set id_carrier='".calculaCarrier(1)."',gift='".$_POST['gift']."' where id_order='".$_POST['nPedido']."'");
tep_db_query("update ps_order_carrier set id_carrier='".calculaCarrier(1)."' where id_order='".$_POST['nPedido']."'");
}
if (tep_db_num_rows($status_query1)>0) {
tep_db_query("update ps_orders1 set idRepartidor='".$_POST['idRepartidor']."',bultos='".$_POST['bultos']."',id_incidencia='".$_POST['id_incidencia']."',incidencia='".$_POST['incidencia']."' where id_order='".$_POST['nPedido']."'");
} else {
tep_db_query("insert into ps_orders1 (id_order,idRepartidor,bultos,id_incidencia,incidencia) values ('".$_POST['nPedido']."','".$_POST['idRepartidor']."','".$_POST['bultos']."','".$_POST['id_incidencia']."','".$_POST['incidencia']."')");
}
}
//ca.id_reference=2 es Seur
$texto_query = "select tramo_date,ca.id_reference,o.id_cart,CONCAT(firstname,' ',lastname) nombreCliente, ".
"CONCAT(a.address1,' ',a.address2) delivery_street_address,city,concat(tramo_from,'-',tramo_until) timeframe,bultos,ifnull(o1.idRepartidor,1) idRepartidor, o.id_customer, ".
"o1.id_incidencia,o1.incidencia,o.gift ".
"from ps_orders o join ps_cart dd on (dd.id_cart=o.id_cart) " .
"left join ps_carrier ca on (ca.id_carrier=o.id_carrier) ".
"join ps_address a on (a.id_address=o.id_address_delivery) " .
"left join ps_orders1 o1 on (o.id_order=o1.id_order) ".
"where o.id_order='".$_POST['nPedido']."' ";
//echo $texto_query;
$status_query = tep_db_query($texto_query);
$status_values = tep_db_fetch_array($status_query);
/* ************ no con GLS *********** */
/* $noGls = array(21523,22666,7845,24817,13383,18954,24970,19627,25430,17141,22411,26903,27769,27064,18109,13954,17665,22222,27362,17964,12815,25308,6306,20393,23267,26271,26554,14645,22979,25948,28495,28475,13928,16220,16501,16220,15115,14357,15874,29020,24679,16931,25208,3913,28715,13008,11157,22563,29272,23732);
*/
$arr = tep_db_fetch_array(tep_db_query("select noGLS from ps_repartoExcepciones where id=1"));
$noGLS = $arr['noGLS'];
if (strpos($noGLS,$status_values['customers_id'])) {
// if (in_array($status_values['id_customer'],$noGls)) {
echo '
CUIDADO, NO ENVIAR CON GLS
';
}
if ($status_values['id_reference']==19 or $status_values['id_reference']==32) {//SEVILLA
$idRepartidor = 100;
} elseif ($status_values['id_reference']==34) { //GLS
$idRepartidor = 200;
} elseif ($status_values['id_reference']==1) { //Cross Express
$idRepartidor = 1;
} elseif (/*$status_values['id_reference']==67 or */$status_values['id_reference']==89 or $status_values['id_reference']==44) { //Paack
$idRepartidor = 300;
} elseif ($status_values['id_reference']==22) { //Yefrat
$idRepartidor = 500;
} elseif ($status_values['id_reference']==49) { //Yefrat Barcelona
$idRepartidor = 700;
} elseif ($status_values['id_reference']==42) { //Sevilla propio
$idRepartidor = 600;
} elseif ($status_values['id_reference']==39) { //Málaga Cross Express
$idRepartidor = 39;
} elseif ($status_values['id_reference']==10) { //RECOGIDA EN COCINA
$idRepartidor = 9999;
} else {
$idRepartidor = 0;
}
}
$quien_array = array();
$quien_query = tep_db_query("select idRepartidor,concat(nombre,' - ',telefono) nombre from ps_zona_repartidor where disponible='1' order by 1");
$quien_array[] = array('id' => '1000', 'text' => 'Selecciona Repartidor');
while ($quien_values = tep_db_fetch_array($quien_query)) {
$quien_array[] = array('id' => $quien_values['idRepartidor'], 'text' => $quien_values['nombre']);
}
?>
NCM - Actualizar Pedido
>> PEDIDO ACTUALIZADO <<
';
}
?>