'Cancelada' AND id_area <> '4'"; if($_SESSION["ad_perfil"]=='Ventas'){ $query_ordenes .= " AND id_usuario IN (".$_SESSION["ad_id"].")"; } }else{ $area=$IdAreasUs; $query_ordenes = " SELECT * FROM ordenes WHERE id_subarea IN ($area) AND estatus <> 'Cancelada' AND id_area <> '4'"; if($_SESSION["ad_perfil"]=='Ventas'){ $query_ordenes .= " AND id_usuario IN (".$_SESSION["ad_id"].")"; } } /* $query_farea = " SELECT * FROM areas WHERE id IN ($area)"; $consu_farea = $conexion -> query($query_farea); $execu_farea = $consu_area->fetch_array(MYSQLI_BOTH); $nombre_area = $execu_farea["descripcion"]; */ ?>

Ordenes

query($query_ordenes); while($execu_ordenes = $consu_ordenes->fetch_array(MYSQLI_BOTH)){ $id_usuario = $execu_ordenes["id_usuario"]; $id_area = $execu_ordenes["id_area"]; $id_subarea = $execu_ordenes["id_subarea"]; $id_cliente = $execu_ordenes["id_cliente"]; if($execu_ordenes["id_tipo_orden"]!='' && $execu_ordenes["fecha_planeacion"]!=''){ $query_farea = " SELECT * FROM tipo_orden WHERE id IN (".$execu_ordenes["id_tipo_orden"].")"; $consu_farea = $conexion -> query($query_farea); $execu_farea = $consu_farea->fetch_array(MYSQLI_BOTH); if($_GET['dep']==1){ $diasAdicionales = $execu_farea["diseno"]; } if($_GET['dep']==7){ $diasAdicionales = $execu_farea["planeacion"]; } if($_GET['dep']==8){ $diasAdicionales = $execu_farea["compras"]; } if($_GET['dep']==2){ $diasAdicionales = $execu_farea["produccion"]; } if($_GET['dep']==5 || $_GET['dep']==3 ){ $diasAdicionales = $execu_farea["instalacion"]; } //echo $execu_ordenes["id_tipo_orden"]; //echo '
'; //echo $execu_farea["produccion"]; $FArea=sumasdiasemana($execu_ordenes["fecha_planeacion"],$diasAdicionales); $FProduccion=sumasdiasemana($execu_ordenes["fecha_planeacion"],$execu_farea["produccion"]); $FInstalacion=sumasdiasemana($execu_ordenes["fecha_planeacion"],$execu_farea["instalacion"]); }else{ $FArea=''; $FProduccion=''; $FInstalacion=''; } $query_creo = " SELECT * FROM usuarios WHERE id = '$id_usuario'"; $consu_creo = $conexion -> query($query_creo); $execu_creo = $consu_creo->fetch_array(MYSQLI_BOTH); $nombre_creo = $execu_creo["nombre"].' '.$execu_creo["a_paterno"]; $cve_creo = $execu_creo["clave"]; $query_area = " SELECT * FROM areas WHERE id = '$id_area'"; $consu_area = $conexion -> query($query_area); $execu_area = $consu_area->fetch_array(MYSQLI_BOTH); $nombre_area = $execu_area["descripcion"]; $query_subarea = " SELECT * FROM subarea WHERE id = '$id_subarea'"; $consu_subarea = $conexion -> query($query_subarea); $execu_subarea = $consu_subarea->fetch_array(MYSQLI_BOTH); $nombre_subarea = $execu_subarea["descripcion"]; $dias_subarea = $execu_subarea["dias"]; $query_clientes = " SELECT * FROM clientes WHERE id = '$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"]; $fechaArea= sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes['creacion'])),$dias_subarea); if( strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes['creacion'])),$dias_subarea) ) > strtotime(date("d-m-Y")) ){ $Color="#D5FFCC"; }elseif(strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes['creacion'])),$dias_subarea) ) == strtotime(date("d-m-Y"))){ $Color="#FEFFCC"; }else{ $Color="#FFCCCC"; } $query_lines = " SELECT SUM(cantidad) total FROM orden_lines WHERE id_orden = ".$execu_ordenes["id"]; $consu_lines = $conexion -> query($query_lines); $execu_lines = $consu_lines->fetch_array(MYSQLI_BOTH); ?>
#Orden Creó Cliente Referencia Piezas F.Creada F.Area F.Produccion F.Instalacion Total Estatus
$