$letra_salida = $vec[1]; $cod_salida = $vec[0]; } else { $letra_salida = 'T'; } //echo $data; //die(); switch ($letra_salida) { case 'T': $letra = ''; break; default: $letra = "and(s.tipo_salida='" . $letra_salida . "')and(s.codigo = '" . $cod_salida . "')"; break; } $sql = "SELECT \n /* 0*/ v.fecha, \n /* 1*/ s.hora, \n /* 2*/ CASE s.tipo_salida WHEN 'D' THEN 'Diario' WHEN 'E' THEN 'Especial' END AS tipo, \n /* 3*/ s.destino, \n /* 4*/ s.estado, \n /* 5*/ concat(vh.patente,' - ',vh.nombre) AS nombre , \n /* 6*/ u.nombre , \n /* 7*/ u2.nombre, \n /* 8*/ COALESCE(vh.nro_asientos,0), \n /* 9*/ s.tipo_salida,\n /*10*/ COALESCE((select count(*) from pasajes AS ps where ps.ID_VIAJE=v.codigo and ps.pagado='V'),0) as cant_pasaje_ocupados,\n /*11*/ COALESCE((select count(*) from pasajes AS ps where ps.ID_VIAJE=v.codigo and ps.pagado='R'),0) as cant_pasaje_reservado,\n /*12*/ concat(vh.COLUMNA_PB_11,'-',vh.COLUMNA_PB_12,'-',vh.COLUMNA_PB_21,'-',vh.COLUMNA_PB_22,'-') as conf_asiento_pb,\n /*13*/ concat(vh.COLUMNA_PA_11,'-',vh.COLUMNA_PA_12,'-',vh.COLUMNA_PA_21,'-',vh.COLUMNA_PA_22,'-') as conf_asiento_pa,\n /*14*/ vh.COLUMNA_CENTRAL_PB, \n /*15*/ vh.COLUMNA_CENTRAL_PA,\n /*16*/ COALESCE(v.codigo,0) as codigo,\n /*17*/ COALESCE(v.id_vehiculo, 0) as id_vehiculo,\n /*18*/ COALESCE(v.id_chofer, 0) as id_chofer,\n /*19*/ COALESCE(v.id_guarda, 0) as id_guarda,\n /*20*/ COALESCE(v.codigo,0) as codigo,\n /*21*/ s.id_localidad_origen,\n /*22*/ s.id_localidad_destino,\n /*23*/ lo.localidad AS loc_ori,\n /*24*/ ld.localidad AS loc_des\n \n \n FROM viajes AS v\n INNER JOIN salidas AS s ON ( s.codigo = v.id_salida ) \n LEFT JOIN vehiculos vh ON ( vh.patente = v.id_vehiculo ) \n \n INNER JOIN localidades AS ld ON ld.codigo = s.id_localidad_destino\n INNER JOIN provincias AS pd ON pd.codigo = ld.id_provincia\n \n INNER JOIN localidades AS lo ON lo.codigo = s.id_localidad_origen \n INNER JOIN provincias AS po ON po.codigo = lo.id_provincia\n \n LEFT JOIN usuarios u ON ( u.id = v.id_chofer ) \n LEFT JOIN usuarios u2 ON ( u2.id = v.id_guarda ) \n WHERE (s.activa ='S') and ((v.fecha = '" . cambiaf_a_mysql($fecha) . "' and s.tipo_salida='D')or(v.fecha >='" . cambiaf_a_mysql($fecha) . "' and s.tipo_salida='E'))" . $letra . "\n ORDER BY s.fecha, s.hora, s.destino"; $res = ejecutar_sql($db, $sql); if (!$res) { mensaje('Error accediendo a las salidas...'); } else { $salidas = ''; while (!$res->EOF) { // tipo salida - destino - fecha - hora - $salidas = $salidas . $res->fields[2] . "|" . $res->fields[3] . "|" . cambiaf_a_normal($res->fields[0]) . "|" . cambiah_a_normal($res->fields[1]) . "|" . $res->fields[5] . "|" . $res->fields[6] . "|" . $res->fields[7] . "|" . $res->fields[8] . "|" . $res->fields[10] . "|" . $res->fields[11] . "|" . $res->fields[12] . "|" . $res->fields[13] . "|" . $res->fields[14] . "|" . $res->fields[15] . "|" . $res->fields[16] . "|" . $res->fields[9] . "|" . $res->fields[17] . "|" . $res->fields[18] . "|" . $res->fields[19] . "|" . $res->fields[20] . "|" . $res->fields[21] . "|" . $res->fields[22] . "|" . $res->fields[23] . "|" . $res->fields[24] . "|"; $res->MoveNext(); $salidas = $salidas . "@"; } } echo $salidas; desconectar($db); die;
//die(); } else { $t_salidas = ''; $color = ''; $i = 0; while (!$res2->EOF) { // Determinamos el color de los registro en la tabla if ($res2->fields[9] == 'E') { $color = COLOR_VIAJE_ESPECIAL_LISTADO; } else { $color = COLOR_VIAJE_DIARIO_LISTADO; } // conformamos la secuencia de parametros al concentrador de seleccionador de salida $parametro = '"' . $res2->fields[20] . '"' . ", " . $res2->fields[8] . ", " . '"' . $res2->fields[12] . '"' . ", " . '"' . $res2->fields[14] . '"' . ", " . '"' . $res2->fields[17] . '"' . ", " . $res2->fields[18] . ", " . $res2->fields[19] . ", " . $res2->fields[20] . ", " . $res2->fields[21] . ", " . $res2->fields[22] . ", " . '"' . $res2->fields[9] . '"' . ", " . '"' . $res2->fields[0] . '"' . ", " . '"' . $res2->fields[1] . '"' . ", " . $res2->fields[10] . ", " . $res2->fields[11] . ", " . $i . ", " . '"' . $res2->fields[3] . '"'; //echo $parametro; die(); $t_salidas = $t_salidas . "<tr style='font-size: 13' bgcolor='" . $color . "' onclick='consentrador_de_accion_al_seleccionar_el_viaje(" . $parametro . " );'>\n \t\t\t\t<td>\n <Input type='Radio' Name='selector_salidas' value='Salidas' id='rb_selector_salidas" . $i . "'\n onclick=' consentrador_de_accion_al_seleccionar_el_viaje(" . $parametro . " );' />\n </td> \t\t\n <td>" . $res2->fields[3] . "</td>\n <td>" . cambiaf_a_normal($res2->fields[0]) . "</td>\n <td>" . cambiah_a_normal($res2->fields[1]) . "</td> \t\t\t\n \t\t<td>" . $res2->fields[5] . "</td>\n \t\t<td>" . $res2->fields[8] . "</td>\n \t\t<td>" . $res2->fields[10] . "</td>\n <td align='Center'>" . $res2->fields[11] . "</td>\n <td style='display: none' >" . $res2->fields[12] . "</td> \n <td style='display: none' >" . $res2->fields[13] . "</td> \n <td style='display: none' >" . $res2->fields[14] . "</td>\n <td style='display: none' >" . $res2->fields[15] . "</td> \n <td align='Center'>" . $res2->fields[23] . "</td> \n <td align='Center'>" . $res2->fields[24] . "</td> \n </tr>"; // var_dump($t_salidas); die(); $res2->MoveNext(); $i++; } } set_var("v_salidas", $t_salidas); //---------------------------------------------------------------------------------------------------- //---------------------------------------------------------------------------------------------------- // Cargamos el comboBOX de Vehiculos //---------------------------------------------------------------------------------------------------- //---------------------------------------------------------------------------------------------------- //---------------------------------------------------------------------------------------------------- // Cargamos el comboBOX de Choferes //---------------------------------------------------------------------------------------------------- //----------------------------------------------------------------------------------------------------