query($query_ordenes);
while($execu_ordenes = $consu_ordenes->fetch_array(MYSQLI_BOTH)){
$cont=0;
$email_cliente="N/A";
$nombre_cliente="N/A";
if($execu_ordenes["telefono"]!=''){
$telefono = $execu_ordenes["telefono"];
}else{
$telefono="N/A";
}
if($execu_ordenes["id_envio"]!=''){
$direccion = $execu_ordenes["id_envio"];
$query_clientesd = " SELECT *
FROM clientes_ship
WHERE id =".$direccion;
$consu_clientesd = $conexion -> query($query_clientesd);
$execu_clientesd = $consu_clientesd->fetch_array(MYSQLI_BOTH);
$direccion_cliente = $execu_clientesd["calle"].' '.$execu_clientesd["numero"];
//$email_cliente = $execu_clientes["correo"];
}else{
$direccion_cliente="N/A";
}
if($execu_ordenes["id_cliente"]!=null){
$cliente = $execu_ordenes["id_cliente"];
$query_clientes = " SELECT *
FROM clientes
WHERE id =".$cliente;
$consu_clientes = $conexion -> query($query_clientes);
$execu_clientes = $consu_clientes->fetch_array(MYSQLI_BOTH);
$nombre_cliente = $execu_clientes["nombre"].' '.$execu_clientes["a_paterno"].' '.$execu_clientes["a_materno"];
$email_cliente = $execu_clientes["correo"];
$cont++;
}else{
$cliente="N/A";
$nombre_cliente="Contacto: ".$execu_ordenes["contacto"]."
Telefono: ".$execu_ordenes["telefono"]."
Email: ".$execu_ordenes["email"];
}
if($execu_ordenes["total"]!='' && $execu_ordenes["total"]!=null){
$total = $execu_ordenes["total"];
}else{
$total="N/A";
}
if($execu_ordenes["fecha_creacion"]!=''){
$fecha_creacion = $execu_ordenes["fecha_creacion"];
}else{
$fecha_creacion="N/A";
}
if($execu_ordenes["referencia"]!=''){
$referencia = $execu_ordenes["referencia"];
}else{
$referencia="N/A";
}
$cont=0;
$query_ordenes1 = " SELECT *
FROM quote_lines
WHERE id_cotizacion='".$execu_ordenes["id_cotizacion"]."'";
$consu_ordenes1 = $conexion -> query($query_ordenes1);
$cont = mysqli_num_rows($consu_ordenes1);
if( $cont > 0 ){
$Color="#D5FFCC";
}else{
$Color="#FFCCCC";
}
?>
|
href="index.php?md=14&IdC="
href="index.php?md=14&IdC=&ED=SI"
>C
|
|
|
|
|
|
|
0 ){
?>
test
|