");
out.println("
");
out.println("LOCALIDAD | ");
out.println("ORIGEN | ");
out.println("LOGISTICA | ");
out.println("CONSOLIDADO | ");
out.println("DESTINO | ");
out.println("
");
out.println("");
sql = "SELECT ciudad_o, count(ciudad_o) as num ";
sql = sql + " FROM solicitud ";
sql = sql + " where ciudad_o <>''";
sql = sql + " and estado='D'";
sql = sql + " group by ciudad_o";
sql = sql + " order by ciudad_o";
ResultSet rslocalidad = select.executeQuery (sql);
int i = 0;
out.println(" | ");
sql = "SELECT logistica, count(logistica) as num ";
sql = sql + " FROM solicitud ";
sql = sql + " where logistica <>''";
sql = sql + " and estado='D'";
sql = sql + " group by logistica";
sql = sql + " order by logistica";
rslocalidad = select.executeQuery (sql);
i = 0;
out.println(" | ");
rslocalidad.close();
/*------------------------------------------------------------------------------*/
rslocalidad.close();
out.println("");
sql = "SELECT consolidado, count(consolidado) as num ";
sql = sql + " FROM solicitud ";
sql = sql + " where consolidado <>''";
sql = sql + " and estado='D'";
sql = sql + " group by consolidado";
sql = sql + " order by consolidado";
rslocalidad = select.executeQuery (sql);
i = 0;
out.println(" | ");
rslocalidad.close();
/*------------------------------------------------------------------------------*/
sql = "SELECT ciudad_d, count(ciudad_d) as num ";
sql = sql + " FROM solicitud ";
sql = sql + " where ciudad_d <>''";
sql = sql + " and estado='D'";
sql = sql + " group by ciudad_d";
sql = sql + " order by ciudad_d";
rslocalidad = select.executeQuery (sql);
i = 0;
out.println(" | ");
rslocalidad.close();
out.println("
");
out.println("");
out.println("SOLICITUD | ");
out.println("CAMIONES | ");
out.println("CARGAS | ");
out.println("EMBARQUES | ");
out.println("AGENCIAS | ");
out.println("
");
out.println("");
out.println(""+cuentacamiones+" | ");
out.println(""+cuentacargas+" | ");
out.println(""+cuentaembarques+" | ");
out.println(""+cuentaagencias+" | ");
out.println("
");
out.println("");
out.println("CAMION | ");
out.println("VEHICULO | ");
out.println("CARROCERIA | ");
out.println("CAPACIDAD | ");
out.println("PROPIEDAD | ");
out.println("
");
out.println("");
sql = "SELECT vehiculo, count(vehiculo) as num ";
sql = sql + " FROM solicitud ";
sql = sql + " where vehiculo <>''";
sql = sql + " and estado='D'";
sql = sql + " AND SOLICITA ='CARGA'";
sql = sql + " group by vehiculo";
sql = sql + " order by vehiculo";
rslocalidad = select.executeQuery (sql);
i = 0;
out.println(" | ");
sql = "SELECT carroceria, count(carroceria) as num ";
sql = sql + " FROM solicitud ";
sql = sql + " where carroceria<>''";
sql = sql + " and estado='D'";
sql = sql + " AND SOLICITA ='CARGA'";
sql = sql + " group by carroceria";
sql = sql + " order by carroceria";
rslocalidad = select.executeQuery (sql);
i = 0;
out.println(" | ");
rslocalidad.close();
/*------------------------------------------------------------------------------*/
out.println("");
sql = "SELECT capacidad, count(capacidad) as num ";
sql = sql + " FROM solicitud ";
sql = sql + " where capacidad<>''";
sql = sql + " and estado='D'";
sql = sql + " AND SOLICITA ='CARGA'";
sql = sql + " group by capacidad";
sql = sql + " order by capacidad";
rslocalidad = select.executeQuery (sql);
i = 0;
out.println(" | ");
rslocalidad.close();
/*------------------------------------------------------------------------------*/
sql = "SELECT propiedad, count(propiedad) as num ";
sql = sql + " FROM solicitud ";
sql = sql + " where propiedad<>''";
sql = sql + " and estado='D'";
sql = sql + " AND SOLICITA ='CARGA'";
sql = sql + " group by propiedad";
sql = sql + " order by propiedad";
rslocalidad = select.executeQuery (sql);
i = 0;
out.println(" | ");
rslocalidad.close();
out.println("
");
out.println("");
out.println("CARGA | ");
out.println("EMBALAJE | ");
out.println("EMPAQUE | ");
out.println("PESO | ");
out.println("PROPIEDAD | ");
out.println("
");
out.println("");
sql = "SELECT embalaje, count(embalaje) as num ";
sql = sql + " FROM solicitud ";
sql = sql + " where embalaje <>''";
sql = sql + " and estado='D'";
sql = sql + " AND SOLICITA ='CAMION'";
sql = sql + " group by embalaje";
sql = sql + " order by embalaje";
rslocalidad = select.executeQuery (sql);
i = 0;
out.println(" | ");
sql = "SELECT empaque, count(empaque) as num ";
sql = sql + " FROM solicitud ";
sql = sql + " where empaque<>''";
sql = sql + " and estado='D'";
sql = sql + " AND SOLICITA ='CAMION'";
sql = sql + " group by empaque";
sql = sql + " order by empaque";
rslocalidad = select.executeQuery (sql);
i = 0;
out.println(" | ");
rslocalidad.close();
/*------------------------------------------------------------------------------*/
out.println("");
sql = "SELECT peso, count(peso) as num,tipo_peso ";
sql = sql + " FROM solicitud ";
sql = sql + " where peso<>''";
sql = sql + " and estado='D'";
sql = sql + " AND SOLICITA ='CAMION'";
sql = sql + " group by peso,tipo_peso";
sql = sql + " order by peso";
rslocalidad = select.executeQuery (sql);
i = 0;
out.println(" | ");
rslocalidad.close();
/*------------------------------------------------------------------------------*/
sql = "SELECT propiedad, count(propiedad) as num ";
sql = sql + " FROM solicitud ";
sql = sql + " where propiedad<>''";
sql = sql + " and estado='D'";
sql = sql + " AND SOLICITA ='CAMION'";
sql = sql + " group by propiedad";
sql = sql + " order by propiedad";
rslocalidad = select.executeQuery (sql);
i = 0;
out.println(" | ");
rslocalidad.close();
out.println("
");
/*------------------------------------------------------------------------------*/
/*------------------------------------------------------------------------------*/
/*------------------------------------------------------------------------------*/
/*------------------------------------------------------------------------------*/
/*
SELECT solicitud.embalaje, Count(solicitud.embalaje) AS CuentaDeembalaje
FROM solicitud INNER JOIN embarque ON solicitud.num = embarque.num
GROUP BY solicitud.embalaje;
*/
out.println("");
out.println("EMBARQUE | ");
out.println("EMBALAJE | ");
out.println("EMPAQUE | ");
out.println("DIMESION | ");
out.println("PROPIEDAD | ");
out.println("
");
out.println("");
sql = "SELECT solicitud.embalaje, Count(solicitud.embalaje) AS num1 ";
sql = sql + "FROM solicitud INNER JOIN embarque ON solicitud.num = embarque.num ";
sql = sql + " where solicitud.estado='D' ";
sql = sql + "GROUP BY solicitud.embalaje ";
rslocalidad = select.executeQuery (sql);
i = 0;
out.println(" | ");
sql = "SELECT solicitud.empaque, Count(solicitud.empaque) AS num1 ";
sql = sql + "FROM solicitud INNER JOIN embarque ON solicitud.num = embarque.num ";
sql = sql + " where solicitud.estado='D' ";
sql = sql + "GROUP BY solicitud.empaque ";
rslocalidad = select.executeQuery (sql);
i = 0;
out.println(" | ");
rslocalidad.close();
/*------------------------------------------------------------------------------*/
out.println("");
sql = "SELECT solicitud.dimension, Count(solicitud.dimension) AS num1, tipo_dim ";
sql = sql + "FROM solicitud INNER JOIN embarque ON solicitud.num = embarque.num ";
sql = sql + " where solicitud.estado='D' ";
sql = sql + "GROUP BY solicitud.dimension, tipo_dim";
rslocalidad = select.executeQuery (sql);
i = 0;
out.println(" | ");
rslocalidad.close();
/*------------------------------------------------------------------------------*/
sql = "SELECT solicitud.propiedad, Count(solicitud.propiedad) AS num1 ";
sql = sql + "FROM solicitud INNER JOIN embarque ON solicitud.num = embarque.num ";
sql = sql + " where solicitud.estado='D' ";
sql = sql + "GROUP BY solicitud.propiedad";
rslocalidad = select.executeQuery (sql);
i = 0;
out.println(" | ");
rslocalidad.close();
out.println("
");
out.println("
");
out.println("