<script>
function verificaCampos(){
val = document.simulador.valor.value;
carencia = document.simulador.carencia.value;
amor = document.simulador.amortiza.value;
	if(val == ""){
		alert("O valor do financiamento não foi definido!");
		document.simulador.valor.focus();
		MM_showHideLayers('Layer1','','show');MM_showHideLayers('Layer2','','hide');MM_showHideLayers('Layer3','','hide');MM_showHideLayers('Layer4','','hide');MM_showHideLayers('Layer5','','hide');MM_showHideLayers('Layer6','','hide');
		return false;
		
	}else{
		if(carencia == ""){
			alert("O valor da carência não foi definida!");
			document.simulador.carencia.focus();
			MM_showHideLayers('Layer2','','show');MM_showHideLayers('Layer1','','hide');MM_showHideLayers('Layer3','','hide');MM_showHideLayers('Layer4','','hide');MM_showHideLayers('Layer5','','hide');MM_showHideLayers('Layer6','','hide');
			return false;

		}else{
			if(amor == ""){
				alert("O valor da amortização não foi definida!");
				document.simulador.amortiza.focus();
				MM_showHideLayers('Layer3','','show');MM_showHideLayers('Layer2','','hide');MM_showHideLayers('Layer1','','hide');MM_showHideLayers('Layer4','','hide');MM_showHideLayers('Layer5','','hide');MM_showHideLayers('Layer6','','hide');
				return false;

		    }		
		}	
	}
}
</script>
<%
dim cod, cod_tipo, tip, tipo

ban = replace(request.querystring("ban"), "'", "''")
cod = replace(request.querystring("cod"), "'", "''")

Set Conexao = Server.CreateObject("ADODB.Connection")


DSNName = "DRIVER=Microsoft Access Driver (*.mdb);DBQ="
DSNName = DSNName & Server.MapPath("simulador.mdb")
Conexao.Open DSNName

PESQBANCO = "SELECT * FROM bancos where cod_banco = " & ban & ""

Set Recset = Server.CreateObject("ADODB.RecordSet")

Recset.open pesqbanco, conexao

banco=recset("banco")

PESQLINHA = "SELECT * FROM simulacao where cod_simu = " & cod & ""

Set Recset = Server.CreateObject("ADODB.RecordSet")

Recset.open pesqlinha, conexao

linha=recset("linha")
tempo=recset("tempo")
juros=recset("juros")
referencial=recset("referencial")
fgpc=recset("fgpc")
valor_flag=recset("valor_flag")
carencia_flag=recset("carencia_flag")
juros_flag=recset("juros_flag")
referencial_flag=recset("referencial_flag")
amortiza_flag=recset("amortiza_flag")
fgpc_flag=recset("fgpc_flag")
tjlpjuros_flag=recset("tjlpjuros_flag")
totalamortiza_flag=recset("totalamortiza_flag")

select case(tempo)
case 3 selec1="selected"
case 6 selec2="selected"
case 12 selec3="selected"
end select
%>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Simulador de Financiamento :: <%=banco%> - <%=linha%></title>
<link rel="stylesheet" type="text/css" href="estilo.css">
<script language="JavaScript">
<!--

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_showHideLayers() { //v6.0
  var i,p,v,obj,args=MM_showHideLayers.arguments;
  for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2];
    if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; }
    obj.visibility=v; }
}
//-->
</script>
<style>
.Estilo1 {color: #FFFFFF}
.Estilo3 {font-size: 10px}
</style>
</head>

<!--#include virtual="/fferreira/bodyED.inc" --> 
<div id="Layer1" style="position:absolute; left:393px; top:70px; width:175px; height:250px; z-index:1; overflow: auto; visibility:visible" onMouseOver="MM_showHideLayers('Layer1','','show')">
<table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td><p align="center"><font face="Arial, Helvetica, sans-serif" class="Estilo4 Estilo1"><strong>Valor Financiamento</strong></font> </p>
      <p align="justify"><font color="#FFFFFF"  size="2" face="Arial, Helvetica, sans-serif"><%=replace(valor_flag, vbCrLf, "<br>")%></font></p></td>
</tr></table></div>
<div id="Layer2" style="position:absolute; left:393px; top:70px; width:175px; height:250px; z-index:1; overflow: auto;  border: 1px none #000000; visibility:hidden" onMouseOver="MM_showHideLayers('Layer2','','show')" >
<table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td><p align="center"><font face="Arial, Helvetica, sans-serif" class="Estilo4 Estilo1"><strong>Prazo Car&ecirc;ncia</strong></font></p>
      <p align="justify"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><%=replace(carencia_flag, vbCrLf, "<br>")%></font></p></td></tr>
</table></div>
<div id="Layer3" style="position:absolute; left:393px; top:70px; width:175px; height:250px; z-index:1; overflow: auto; visibility:hidden" onMouseOver="MM_showHideLayers('Layer3','','show')" >
<table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td><p align="center"><font face="Arial, Helvetica, sans-serif" class="Estilo4 Estilo1"><strong>Prazo Amortiza&ccedil;&atilde;o</strong></font> </p>
      <p align="justify"><font color="#FFFFFF"  size="2" face="Arial, Helvetica, sans-serif"><%=replace(amortiza_flag, vbCrLf, "<br>")%></font></p></td></tr>
</table></div>
<div id="Layer4" style="position:absolute; left:393px; top:70px; width:175px; height:380px; z-index:1; overflow: auto; visibility:hidden" onMouseOver="MM_showHideLayers('Layer4','','show')" >
<table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td><p align="center"><font face="Arial, Helvetica, sans-serif" class="Estilo4 Estilo1"><strong>Taxa de Juros</strong> </font></p>
      <p align="justify"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><%=replace(juros_flag, vbCrLf, "<br>")%></font></p></td>
</tr></table></div>
<script src="formatavalor.js"></script>
<p align="center"><font color="#2b3283"  size="2" face="Arial"><b><br>
<%=banco%> - <%=linha%></b></font></p>
<p align="center">
</p>
<form method="POST" action="fne_sac_SD.asp" onsubmit="return verificaCampos()" name="simulador">
  <table border="0" width="100%" height="337" onsubmit="return verificaCampos()" cellspacing="0" cellpadding="2">
    <tr valign="top">
      <td width="30%" height="39" class="fontebranca"><font size="2" face="Arial">Valor Financ.</font></td>
      <td width="19%" height="39" align="right"><font size="2" face="Arial">
        <input type="text" name="valor" size="20" onClick="MM_showHideLayers('Layer1','','show');MM_showHideLayers('Layer2','','hide');MM_showHideLayers('Layer3','','hide');MM_showHideLayers('Layer4','','hide');MM_showHideLayers('Layer5','','hide');MM_showHideLayers('Layer6','','hide');" onblur="this.className='selectBoxNormal';" onfocus="this.className='selectOver';" class="selectBoxNormal"; onKeyDown="formataValor(0,17,event)">
      </font> </td>
      <td width="6%" height="39" class="fontebranca"></td>
      <td width="45%" rowspan="5" class="fontebranca"><table width="95%" height="340"  border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td height="340" valign="top">&nbsp;</td>
          </tr>
      </table></td>
    </tr>
    <tr valign="top">
      <td width="30%" height="35" class="fontebranca"><font size="2" face="Arial">Prazo Car&ecirc;ncia</font></td>
      <td width="19%" height="35" align="right"><font size="2" face="Arial">
        <input type="text" name="carencia" size="20" onClick="MM_showHideLayers('Layer2','','show');MM_showHideLayers('Layer1','','hide');MM_showHideLayers('Layer3','','hide');MM_showHideLayers('Layer4','','hide');MM_showHideLayers('Layer5','','hide');MM_showHideLayers('Layer6','','hide');" onblur="this.className='selectBoxNormal';" onfocus="this.className='selectOver';" class="selectBoxNormal">
      </font> </td>
      <td width="6%" height="35" class="fontebranca"><font size="2" face="Arial">(Meses)</font> </td>
    </tr>
    <tr valign="top">
      <td width="30%" height="35" class="fontebranca"><font size="2" face="Arial">Prazo Amortiza&ccedil;&atilde;o</font></td>
      <td width="19%" height="35" align="right"><font size="2" face="Arial">
        <input type="text" name="amortiza" size="20" onClick="MM_showHideLayers('Layer3','','show');MM_showHideLayers('Layer2','','hide');MM_showHideLayers('Layer1','','hide');MM_showHideLayers('Layer4','','hide');MM_showHideLayers('Layer5','','hide');MM_showHideLayers('Layer6','','hide');" onblur="this.className='selectBoxNormal';" onfocus="this.className='selectOver';" class="selectBoxNormal">
      </font></td>
      <td width="6%" height="35" class="fontebranca"><font size="2" face="Arial">(Meses)</font></td>
    </tr>
    <tr valign="top">
      <td width="30%" height="17" class="fontebranca"><font size="2" face="Arial">Taxa Juros</font></td>
      <td width="19%" align="right">
        <p align="right"><font size="2" face="Arial">
          <input type="text" name="juros" size="12" value="<%=juros%>" onClick="MM_showHideLayers('Layer4','','show');MM_showHideLayers('Layer2','','hide');MM_showHideLayers('Layer3','','hide');MM_showHideLayers('Layer1','','hide');MM_showHideLayers('Layer5','','hide');MM_showHideLayers('Layer6','','hide');" onblur="this.className='selectBoxNormal';" onfocus="this.className='selectOver';" class="selectBoxNormal">
      </font></p></td>
      <td width="6%" height="17" class="fontebranca"><font size="2" face="Arial">%a.a.</font></td>
    </tr>
    <tr valign="top">
      <td width="30%" height="202" class="fontebranca">&nbsp;</td>
      <td width="19%" align="right"><font size="2" face="Arial"><br>
            <br>
              </font>
          <table width="100%"  border="0" cellspacing="0" cellpadding="4">
            <tr>
              <td width="62%"><div align="right"><font size="2" face="Arial">
                  <input type="submit" value="Calcular" name="Calcular" class=botao>
              </font></div></td>
              <td width="38%"><div align="right"><font size="2" face="Arial">
                  <input type="reset" value="Apagar" name="Apagar" class=botao>
              </font></div></td>
            </tr>
        </table>          <font size="2" face="Arial">&nbsp; </font></td>
      <td width="6%" class="fontebranca">&nbsp;</td>
    </tr>
  </table>
  <table width="100%"  border="0" cellspacing="0" cellpadding="4">
    <tr>
      <td height="73" valign="bottom"><div align="right"></div>
      <div align="center" class="fontebranca Estilo6 Estilo3">Os resultados apresentados aqui s&atilde;o apenas de refer&ecirc;ncia, pois considera-se a TJLP constante durante o prazo de financiamento e as condi&ccedil;&otilde;es operacionais poder&atilde;o ser alteradas pelo(a) <%=banco%></div></td>
    </tr>
  </table>
  <input type="hidden" name="banco" value="<%=banco%>">
  <input type="hidden" name="linha" value="<%=linha%>">
  <input type="hidden" name="tjlpjuros_flag" value="<%=tjlpjuros_flag%>">
  <input type="hidden" name="totalamortiza_flag" value="<%=totalamortiza_flag%>">
  <input type="hidden" name="tempo" value="<%=tempo%>">
  <font size="2" face="Arial">&nbsp; </font>
</form>
<p></p>

</html>
