<%@ page import="java.util.*,javax.sql.*,java.sql.*,javax.naming.*,java.text.*,m05bClasses.*" %>
<%
	// _______________________________XLNETs______________________________________
	// Evaluar variable de session que indica si esta conectado a XLNets
	if ((session.getAttribute("objetoSeguridad")) == null)  { 
		// Verificar que no ha transcurrido el tiempo de sesion (web.xml) %>
			<%@ include file="/m05bControlAcceso.inc"%> <%
	} 
%>	
<%@ include file="/m05bIdioma.inc"%>

<HTML>

<HEAD>
<link rel="stylesheet" href="<%=m05bConstantesPaginas.PATH_ESTILOS%>/m05bestilos.css" type="text/css">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
 <title><%= resTit.getString("titLstTarjPorDpto")%></title>
	
<SCRIPT language=JavaScript>
		function fncRetornar() {
				 document.formSolicitud.action="/m05bParqueMovilWar/m05bImpTar_TasDptoJsp.jsp?Tipo=0" ;
				 document.formSolicitud.submit();
		}
</SCRIPT>
</HEAD>	
<!-- Hojas de Estilo -->
<%	String sTarjetasDpto = m05bFicheroProperties.getInstance().getParameter("PDF.TarjetasDpto"); %>

<BODY style="cursor: wait" onload="document.body.style.cursor='default';document.all['general'].style.visibility='visible';document.all['general'].style.cursor='default';document.all['general'].style.cursor='wait';" onunload="document.body.style.cursor='wait';">
<div  id="general" style="POSITION: absolute;visibility:hidden;cursor: wait">	
<form NAME="formSolicitud" METHOD="POST">
<%
	String sDpto = request.getParameter("CodDpto");
	String sSituacion = request.getParameter("SituacionTexto");
    String sTipoLis=request.getParameter("TipoLis");
    if (sTipoLis==null){
		sTipoLis="0";}     	
	String srcPDF = sTarjetasDpto + "?CodDpto="+sDpto +"&Situacion="+sSituacion+"&TipoLis="+sTipoLis;
	String sWhere="";
	java.sql.Connection conn=null;
	PreparedStatement pstmt = null;
	ResultSet rs = null;
	
	m05bFileLog miLog = new m05bFileLog();			
      try
      {  //HttpSession session = request.getSession(true);
			m05bConexion miConex = new m05bConexion();
			
			conn = miConex.getConnection();
            String sSentencia = " SELECT  1 "+
				" FROM "+
				m05bConstantes.TAB_TARJETAS+","+ 
				m05bConstantes.TAB_CENTROS+","+
				m05bConstantes.TAB_VEHICULOS+","+
				m05bConstantes.TAB_MODELOS+","+	
				m05bConstantes.TAB_DESCRIPCIONES +" M ,"+
				m05bConstantes.TAB_DEPARTAMENTOS+ 
				" WHERE " + 
				m05bConstantes.COL_31_CENTRO +"="+ m05bConstantes.COL_05_CODIGO+ " AND " +
				m05bConstantes.COL_31_MATRICULA+" = "+m05bConstantes.COL_34_MATRICULA + " AND " +
				" ((( " + m05bConstantes.COL_31_TARJETA+ " ) Like '502%') " + " AND " +
				" ((" + m05bConstantes.COL_31_SITUACION+")='A')) and " +
				m05bConstantes.COL_34_MODELO+"="+m05bConstantes.COL_17_CODMOD +" AND M." + m05bConstantes.COL_99_CODTABLA+"(+) ='7' AND " + 		
				m05bConstantes.COL_34_MATRICULA+"= M."+m05bConstantes.COL_99_CODDESC + "(+) and "+
				" SUBSTR(" + m05bConstantes.COL_06_CODDPTO+",1,2)=SUBSTR(" + m05bConstantes.COL_05_CODIGO+",1,2)" +
				" AND COD_DPTO_06 = CODDPTO_34 ";

			if (!(sSituacion.equals(""))){
			    	sSentencia= sSentencia + " AND " + m05bConstantes.COL_34_SITUACION+ " in ('"+sSituacion+"')";}
			if (!(sDpto.equals(""))){
			    	sSentencia= sSentencia + " AND  SUBSTR(" + m05bConstantes.COL_31_CENTRO+",1,2)=SUBSTR('" + sDpto + "',1,2)";
			    	sSentencia= sSentencia + " AND " + m05bConstantes.COL_06_CODDPTO + " = '" + sDpto + "'";
					sSentencia= sSentencia + " AND " + m05bConstantes.COL_34_CODDPTO + " = '" + sDpto + "'";
			}
			if (!(sTipoLis.equals("0"))){
				sSentencia= sSentencia + " AND " + m05bConstantes.COL_31_TIPO+ " = '"+sTipoLis+"'";}    	
			sSentencia = sSentencia+  " ORDER BY " +
			" SUBSTR(" +m05bConstantes.COL_05_CODIGO+",1,2),DECODE(" +m05bConstantes.COL_31_CENTRO+",'039','1','0'),"+m05bConstantes.COL_06_DESCDPTO+","+m05bConstantes.COL_31_CENTRO+" asc";
			
			miLog.addTraza("Bego" , "m05bImpVehiculosRangoServletInicio :" , "sSentencia: "+sSentencia, m05bConstantes.LOG_NIVEL_BAJO);                
			
			pstmt = conn.prepareStatement(sSentencia);
			rs = pstmt.executeQuery();
%>
	
<TABLE class="general">
  <tr>
       <!--td width="90%" align="right"><INPUT TYPE="IMAGE" style="cursor:hand" VALUE="Retornar" ONCLICK="JavaScript:fncRetornar();" onMouseOver="top.status='Retornar'; return true" onMouseOut="top.status=''; return true" src="<%=m05bConstantesPaginas.PATH_IMAGENES%>/retornar.gif"></td-->
       <td width="90%" align="right"><input type="button" class="boton" name="<%= res.getString("etBOT_RETORNAR")%>" value="<%= res.getString("etBOT_RETORNAR")%>" ONCLICK="JavaScript:fncRetornar();return false;" onMouseOver="top.status='<%= res.getString("etBOT_STATUSRETORNAR")%>'; return false" onMouseOut="top.status=''; return false" /></td>				      					         
  </tr>
  <tr>
    <td colspan="2">
    <% if (rs.next() == true){ %>
      
		<embed name='pdfTarjetasDpto' src='<%=srcPDF%>' type="application/pdf" width='736' height='500'></embed>
    <%} else {%>
		<embed name='pdfTarjetasDpto' src='/parquemovil/SinDatos.pdf' type="application/pdf" width='736' height='500'></embed>
    <%}%>
	<%	} catch (Exception SQLException) {
			miLog.addTraza(SQLException);
		} 	finally{
				if (rs != null)
					rs.close();			
				if (pstmt != null)
					pstmt.close();
				if (conn != null)
					conn.close();}%>
  	</td>
  </tr>
</TABLE>
</form>
<script type="text/javascript" src="<%=m05bConstantesPaginas.PATH_SCRIPTS%>/m05bMsControl.js"></script>
 
</div>
</body>
</html>