query($query_ordenes); $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"]; $referencia = $execu_ordenes["referencia"]; $filename = $execu_ordenes["anexo"]; $filenameDesp = $execu_ordenes["despiece"]; $filenameFact = $execu_ordenes["factura"]; $filenameLiquidacion = $execu_ordenes["liquidacion"]; $id_envio = $execu_ordenes["id_envio"]; $id_facturacion = $execu_ordenes["id_facturacion"]; $id_paqueteria = $execu_ordenes["id_paqueteria"]; $nguia = $execu_ordenes["guia"]; $estatus = $execu_ordenes["estatus"]; $id_estatus_pago = $execu_ordenes["id_estatus_pago"]; $id_tipo_orden = $execu_ordenes["id_tipo_orden"]; $filenamePlan=$execu_ordenes["planos"]; $filenameHerr=$execu_ordenes["herraje"]; $filenameParts=$execu_ordenes["partes"]; $filenameRender=$execu_ordenes["render"]; $filenameOptimizacion=$execu_ordenes["optimizacion"]; $filenamegarantiaCer=$execu_ordenes["garantiaCer"]; $filenamegarantiaSeg=$execu_ordenes["garantiaSeg"]; $filenamedetallesProyecto=$execu_ordenes["detallesProyecto"]; $IdCotizacionA = $execu_ordenes["id_cotizacion"]; $query_paqueteria = " SELECT * FROM paqueterias WHERE id = '$id_paqueteria'"; $consu_paqueteria = $conexion -> query($query_paqueteria); $execu_paqueteria = $consu_paqueteria->fetch_array(MYSQLI_BOTH); $nombre_paqueteria = $execu_paqueteria["descripcion"]; $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"]; $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"]; $fiscal = $execu_clientes["fiscal"]; $query_pago = " SELECT * FROM estatus_pago WHERE id = '$id_estatus_pago'"; $consu_pago = $conexion -> query($query_pago); $execu_pago = $consu_pago->fetch_array(MYSQLI_BOTH); $DescPago = $execu_pago["descripcion"]; $query_us = " SELECT * FROM usuarios WHERE id = '".$_SESSION["ad_id"]."'"; $consu_us = $conexion -> query($query_us); $execu_us = $consu_us->fetch_array(MYSQLI_BOTH); $AreaPrivilegios = explode(",",($execu_us['id_areas'])); $query_tipo_orden = " SELECT * FROM tipo_orden WHERE id = '$id_tipo_orden'"; $consu_tipo_orden = $conexion -> query($query_tipo_orden); $execu_tipo_orden = $consu_tipo_orden->fetch_array(MYSQLI_BOTH); $DescTipoOrden = $execu_tipo_orden["descripcion"]; ?>