$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
//----------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------
