<%-- Document : frm_inversiones Created on : 31/05/2013, 01:14:09 pm Author : Martha --%> <%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <%@page import = "mx.com.declaranet.conexion.*" import = "java.sql.*" import = "mx.com.declaranet.Config" import = "mx.com.declaranet.Permisos" import = "java.util.Date" import = "java.text.SimpleDateFormat" import = "mx.com.declaranet.Pojos.*" %> Inversiones <% /*********************************** Permite modificar los datos de un usuario existente ***********************************************/ /********************************************creado por: Ing Martha*******************************************************/ Bank_accounts bank_accounts = new Bank_accounts(); Investments investments = new Investments(); Establishment_investment establishment_investments = new Establishment_investment(); Domicilios domicilios = new Domicilios(); Custome_type custome_type = new Custome_type(); Observaciones observaciones = new Observaciones(); Owner owner = new Owner(); Config conf = new Config(); out.println(""); String nompag[] = request.getRequestURI().split("/"); Date hoy = new Date(); SimpleDateFormat formato = new SimpleDateFormat("yyyy-MM-dd"); String fecha_hoy = formato.format(hoy); String listado = ""; int cantidad = 0; int id_account = 0; int id_investment = 0; int id_investment_e = 0; String texto = ""; int id_domicilio = 0; int tipo = -1; String monto = ""; String precio = ""; int total = 0; String display = ""; String display1 = ""; String display2 = ""; if(Integer.parseInt(session.getAttribute("tipo_declaracion").toString())==2){ monto="Saldo (A DICIEMBRE 31)"; }else{ monto="Monto"; } /*Inicio. Cuentas Bancarias*/ if(request.getParameter("id_account") != null){ // if(request.getParameter("id_account") != null){ if(request.getParameter("editar") != null){ if(request.getParameter("editar").equals("1")){ texto= "EDITAR "; out.print(texto); id_account=Integer.parseInt(request.getParameter("id_account")); id_account=bank_accounts.select_bank_accounts(id_account); tipo=Integer.parseInt(request.getParameter("tipo")); if(!Double.toString(bank_accounts.getAmount()).equals("0.0")){ precio=Double.toString(bank_accounts.getAmount()); } display="style=\"display: none;\" "; } } /*}else{ texto = "AGREGAR"; bank_accounts.limpiacampos(); if(!Double.toString(bank_accounts.getAmount()).equals("0.0")){ precio=Double.toString(bank_accounts.getAmount()); } display = ""; }*/ }else{ texto = "AGREGAR"; if(!Double.toString(bank_accounts.getAmount()).equals("0.0")){ precio=Double.toString(bank_accounts.getAmount()); } display = ""; } /*Fin. Cuentas Bancarias*/ /*Inicio. Inversiones*/ if(request.getParameter("id_investment") != null){ // if(request.getParameter("id_investment") != null){ if(request.getParameter("editar") != null){ if(request.getParameter("editar").equals("1")){ texto= "EDITAR "; id_investment=Integer.parseInt(request.getParameter("id_investment")); id_investment=investments.select_investments(id_investment); tipo=Integer.parseInt(request.getParameter("tipo")); if(!Double.toString(investments.getAmount()).equals("0.0")){ precio=Double.toString(investments.getAmount()); } display1="style=\"display: none;\" "; } } /*}else{ texto = "AGREGAR"; investments.limpiacampos(); if(!Double.toString(investments.getAmount()).equals("0.0")){ precio=Double.toString(investments.getAmount()); } display2 = ""; } */ }else{ texto = "AGREGAR"; if(!Double.toString(investments.getAmount()).equals("0.0")){ precio=Double.toString(investments.getAmount()); } display1 = ""; } /*Fin. Inversiones*/ /*Inicio. Inversiones en establecimiento comerciales o industriales*/ if(request.getParameter("id_investment_e") != null){ //if(request.getParameter("id_investment_e") != null){ if(request.getParameter("editar") != null){ if(request.getParameter("editar").equals("1")){ texto= "EDITAR "; if(request.getParameter("id_domicilio") != null){ id_domicilio=Integer.parseInt(request.getParameter("id_domicilio")); } id_domicilio=domicilios.select_dom_funcionario(Integer.parseInt(session.getAttribute("id_user").toString()), 4, id_domicilio, Integer.parseInt(session.getAttribute("id_declaracion").toString())); id_investment_e=Integer.parseInt(request.getParameter("id_investment_e")); id_investment_e=establishment_investments.select_establishment_investments(id_investment_e); tipo=Integer.parseInt(request.getParameter("tipo")); if(!Double.toString(establishment_investments.getAmount()).equals("0.0")){ precio=Double.toString(establishment_investments.getAmount()); } display2="style=\"display: none;\" "; } }else{ texto = "AGREGAR"; id_domicilio=0; if(!Double.toString(establishment_investments.getAmount()).equals("0.0")){ precio=Double.toString(establishment_investments.getAmount()); } } /* }else{ texto = "AGREGAR"; id_domicilio=0; domicilios.limpiacampos(Integer.parseInt(session.getAttribute("id_user").toString())); establishment_investments.limpiacampos(); if(!Double.toString(establishment_investments.getAmount()).equals("0.0")){ precio=Double.toString(establishment_investments.getAmount()); } display="style=\"display: none;\" "; } */ }else{ texto = "AGREGAR"; if(!Double.toString(establishment_investments.getAmount()).equals("0.0")){ precio=Double.toString(establishment_investments.getAmount()); } display2 = ""; } /*Fin. Inversiones en establecimiento comerciales o industriales*/ %> .
<% total = bank_accounts.count_bank_accounts(Integer.parseInt(session.getAttribute("id_declaracion").toString())) + establishment_investments.count_establishment_investments(Integer.parseInt(session.getAttribute("id_declaracion").toString())) + establishment_investments.count_establishment_investments(Integer.parseInt(session.getAttribute("id_declaracion").toString())); int id_observacion=observaciones.select_observaciones(Integer.parseInt(session.getAttribute("id_declaracion").toString()), 146); if(id_observacion>0){ out.println("
"); out.println("
OBSERVACIONES DEL ADMINISTRADOR"); out.println(observaciones.getObservacion()); out.println("
"); out.println("

"); } %>
5. INVERSIONES EN CUENTAS BANCARIAS Y OTRO TIPO DE VALORES DEL DECLARANTE, C�NYUGE y/o DEPENDIENTES
<%=display1%> <%=display2%>>
SELECCIONE UN TIPO DE INVERSIÓN
TIPO DE INVERSIÓN
<% listado = custome_type.listarcustome_type(custome_type.getId_custom_type()); out.println(listado); %> " type="hidden"/> " type="hidden"/>

<%=texto%> INVERSIONES EN ESTABLECIMIENTOS
" type="hidden"/> " type="hidden"/>
Descripción y Razón Social
Titular
<% //owner titular = new owner(); listado = owner.listarowner(establishment_investments.getOwner_id()); out.println(listado); %>
<%=monto%>
<% //domicilios dom = new domicilios(); listado = domicilios.muestradomicilio(2, 4); out.println(listado); %>


<% /*Inicio. Cuentas Bancarias*/ if(Integer.parseInt(session.getAttribute("id_declaracion").toString())>0){ cantidad=bank_accounts.count_bank_accounts(Integer.parseInt(session.getAttribute("id_declaracion").toString())); out.println("

"); if(cantidad>=1){ listado=bank_accounts.enlistar_bank_accounts(Integer.parseInt(session.getAttribute("id_declaracion").toString())); if(!listado.equals("")){ out.println("
"); out.println(listado); out.println("
"); } } /*Fin. Cuentas Bancarias*/ /*Inicio. Inversiones */ cantidad=investments.count_investments(Integer.parseInt(session.getAttribute("id_declaracion").toString())); out.println("

"); if(cantidad>=1){ listado=investments.enlistar_investments(Integer.parseInt(session.getAttribute("id_declaracion").toString())); if(!listado.equals("")){ out.println("
"); out.println(listado); out.println("
"); } } /*Fin. Inversiones*/ /*Inicio. Inversiones en establecimiento comerciales o industriales*/ cantidad=establishment_investments.count_establishment_investments(Integer.parseInt(session.getAttribute("id_declaracion").toString())); out.println("

"); if(cantidad>=1){ listado=establishment_investments.enlistar_establishment_investments(Integer.parseInt(session.getAttribute("id_declaracion").toString())); if(!listado.equals("")){ out.println("
"); out.println(listado); out.println("
"); } } /*Fin. Inversiones en establecimiento comerciales o industriales*/ } %>