<?php
session_start();	
$ruta = '../';
require_once($ruta."shared/class_folder/class_mensajes.php");
$objmsj=new class_mensajes();
require_once("class_folder/covensol_scb_c_banco.php");
$objscb=new covensol_scb_c_banco('');
$objscb->cargar_seguridad("SCB","covensol_scb_p_txt_estadocta.php");

if($_GET['subir']){

    $param['codban'] = $_POST['txtcodban'];
	$param['ctaban'] = $_POST['txtcuenta'];
	$param['fecestcta'] = date("Y/m/d");
	$param['chkimpcre'] = $_POST['chkimpcre']?1:0;
	$param['chkimpdeb'] = $_POST['chkimpdeb']?1:0;
	$param['chkrefnc'] = $_POST['chkrefnc']?1:0;
	$param['chkrefnd'] = $_POST['chkrefnd']?1:0;
	$param['chkgennc'] = $_POST['chkgennc']?1:0;
	$param['chkgennd'] = $_POST['chkgennd']?1:0;
	$param['chkcontnc'] = $_POST['chkcontnc']?1:0;	
	$param['scg_cuenta_cre'] = $_POST['txtcuentascgcre'];
	$param['scg_cuenta_bco'] = $_POST['txtcuenta_scg'];	
	$param['tipo_archivo'] = $_POST['sel_tiparch'];
	
	$objscb->io_sql->begin_transaction();	
	$_SESSION['disable_trans']=1;
	$resp = $objscb->ProcEstadoCta($param);	
	$_SESSION['disable_trans']=0;	
	//$resp=false;
	if($resp===false){$objscb->io_sql->rollback();}
	else{$objscb->io_sql->commit();}
}

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>INTERFASE DE CARGA DE ESTADO DE CUENTA DE BANCO</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../shared/css/ventanas.css" rel="stylesheet" type="text/css">
<link href="../shared/css/general.css" rel="stylesheet" type="text/css">
<link href="../shared/css/tablas.css" rel="stylesheet" type="text/css">
<link href="../shared/css/catalogos.css" rel="stylesheet" type="text/css">
<link href="../shared/css/cabecera.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
a:link {
	color: #006699;
}
a:visited {
	color: #006699;
}
a:active {
	color: #006699;
}
.Estilo2 {color: #666666}
-->
</style>

</head>
<script type="text/javascript" language="JavaScript1.2" src="../shared/js/number_format.js"></script>
<script type="text/javascript" language="JavaScript1.2" src="../shared/js/valida_tecla.js"></script>
<script type="text/javascript" language="JavaScript1.2" src="js/funciones.js"></script>
<script type="text/javascript" language="JavaScript1.2" src="../shared/js/librerias_comunes_covensol.js"></script>
<script src="../base/librerias/js/jquery/jquery.js" type="text/javascript"></script>
<script src="../base/librerias/js/jquery/jquery.ui.draggable.js" type="text/javascript"></script>
<script src="../base/librerias/js/jquery/jquery.alerts.js" type="text/javascript"></script>
<link href="../base/librerias/js/jquery/jquery.alerts.css" rel="stylesheet" type="text/css" media="screen" />
<script language="JavaScript" type="text/JavaScript" src="../shared/js/js_ajax.js"></script>
<script language="JavaScript" src="../shared/js/sigesp_js.js"></script>
<script language="JavaScript" type="text/JavaScript" src="js/covensol_scb_p_txt_estadocta.js"></script>
<body>

<form action="" method="post" enctype="multipart/form-data" name="form1">
  <table width="778" border="0" align="center" cellpadding="0" cellspacing="0" class="contorno">
    <tr>
      <td height="30" colspan="12" class="cd-logo"><img src="../shared/imagebank/header.jpg" alt="cab" width="778" height="40"></td>
    </tr>
    <tr>
      <td height="20" colspan="12" bgcolor="#EAE8D9" ><table width="762" border="0" align="center" cellpadding="0" cellspacing="0">
            <td width="432" height="20" class="descripcion_sistema"> CARGAR ESTADO DE CUENTA DE BANCO</td>
            <td width="346" ><div align="right"><span class="letras-pequenas"><b><?PHP print date("j/n/Y")." - ".date("h:i a");?></b></span></div></td>
        <tr>
          <td height="20"  class="descripcion_sistema">CARGA A PARTIR DE TXT</td>
          <td  class="texto-azul"><div align="right" class="letras-pequenas" ><b><?PHP print $_SESSION['nombre_completo'];?></b></div></td>
          </table></td>
    </tr>
    <tr>
      <td height="20" width="25" class="toolbar"><div align="center"><a href="javascript: ObjForm.InitForm();"><img src="../shared/imagebank/tools20/nuevo.gif" alt="Nuevo registro" width="20" height="20" border="0" title="Nuevo registro"></a></div></td>
      <td height="20" width="25" class="toolbar"><div align="center"><a href="javascript: ObjForm.Procesar();"><img src="../shared/imagebank/tools20/grabar.gif" alt="Grabar" width="20" height="20" border="0" title="Guardar"></a></div></td>
      <td class="toolbar" width="25"><div align="center"><a href="javascript: ObjForm.Salir();"><img src="../shared/imagebank/tools20/salir.gif" alt="Salir" width="20" height="20" border="0" title="Salir"></a></div></td>
      <td class="toolbar" width="25"><div align="center" id="boton_eliminar"><a href="javascript: buscar('ayuda');"><img src="../shared/imagebank/tools20/ayuda.gif" alt="Ayuda" width="20" height="20"></a></div></td>
      <td class="toolbar" width="25">&nbsp;</td>
      <td class="toolbar" width="25">&nbsp;</td>
      <td class="toolbar" width="25">&nbsp;</td>
      <td class="toolbar" width="25">&nbsp;</td>
      <td class="toolbar" width="25">&nbsp;</td>
      <td class="toolbar" width="25">&nbsp;</td>
      <td class="toolbar" width="25">&nbsp;</td>
      <td class="toolbar" width="468">&nbsp;</td>
    </tr>
  </table>
  <br>
  <table width="746" border="0" align="center" cellpadding="1" cellspacing="1">
    <tr>
      <td width="742" height="20" colspan="2" class="titulo-ventana">ESTADOS DE CUENTA DE BANCO</td>
    </tr>
  </table>
  <br>
  <table width="744" border="0" align="center" cellpadding="1" cellspacing="0" class="formato-blanco">
    <tr>
      <td height="22" align="right">Banco:</td>
      <td height="22" align="left" div><span style="text-align:left">
        <input name="txtcodban" type="text" id="txtcodban"  style="text-align:center" value="<?php print $ls_codban;?>" size="10" readonly>
        <img src="../shared/imagebank/tools15/buscar.gif" width="15" height="15" border="0" alt="Cat&aacute;logo de Bancos" style="cursor:pointer" onClick="ObjForm.BuscarCatalogo('banco')">
        <input name="txtdenban" type="text" id="txtdenban" value="<?php print $ls_denban?>" size="51" class="sin-borde" readonly>
      </span></td>
    </tr>
    <tr>
      <td height="22" align="right">Cuenta:</td>
      <td height="22" align="left" div><span style="text-align:">
        <input name="txtcuenta" type="text" id="txtcuenta" style="text-align:center" value="<?php print $ls_cuenta_banco; ?>" size="30" maxlength="25" readonly>
        <img src="../shared/imagebank/tools15/buscar.gif" width="15" height="15" border="0" alt="Cat&aacute;logo de Cuentas de Banco" style="cursor:pointer" onClick="ObjForm.BuscarCatalogo('cuentabanco')">
        <input name="txtdenominacion" type="text" class="sin-borde" id="txtdenominacion" style="text-align:left" value="<?php print $ls_dencuenta_banco; ?>" size="35" maxlength="254" readonly>
        <input name="txttipocuenta" type="hidden" id="txttipocuenta">
        <input name="txtdentipocuenta" type="hidden" id="txtdentipocuenta">
        <input name="txtcuenta_scg" type="hidden" id="txtcuenta_scg">        
      </span></td>
    </tr>
    <tr>
      <td height="22" align="right">Tipo de Archivo:</td>
      <td height="22" align="left" div><label>
        <select name="sel_tiparch" id="sel_tiparch">
          <option value="DEFECTO" selected>Por Defecto</option>
          <option value="VENEZUELA">Banco de Venezuela</option>
        </select>
      </label></td>
    </tr>
    <tr>
      <td width="197" height="22" align="right">Archivo txt:</td>
      <td width="541" height="22" align="left" div><label>
        <input type="file" name="txt_menu" id="txt_menu">
      </label></td>
    </tr>
    <tr>
      <td height="22">&nbsp;</td>
      <td><span class="Estilo2">* Leer la ayuda para el formato del archivo. (icono de ayuda)</span></td>
    <tr>
      <td height="22" align="right">Inportar D&eacute;bitos:</td>
      <td><label>
        <input type="checkbox" name="chkimpdeb" id="chkimpdeb">
      </label></td>
    <tr>
      <td height="22" align="right">Validar Nro Referencia ND:</td>
      <td><input type="checkbox" name="chkrefnd" id="chkrefnd"></td>
    <tr>
      <td width="197" height="22" align="right">Importar Cr&eacute;ditos:</td>
      <td><label>
        <input type="checkbox" name="chkimpcre" id="chkimpcre" checked>
      </label></td>
    <tr>
      <td height="22" align="right">Validar Nro Referencia NC:</td>
      <td><input type="checkbox" name="chkrefnc" id="chkrefnc"  checked></td>
    <tr>
      <td height="22" align="right">Generar Notas de Cr&eacute;dito en Banco:</td>
      <td><label>
        <input type="checkbox" name="chkgennc" id="chkgennc"  checked>
      </label></td>
    <tr>
      <td height="22" align="right">Cuenta Contable Notas de Cr&eacute;dito:</td>
      <td><span style="text-align:">
        <input name="txtcuentascgcre" type="text" id="txtcuentascgcre" style="text-align:center" value="<?php print $ls_cuenta_banco; ?>" size="30" maxlength="25" readonly>
        <img src="../shared/imagebank/tools15/buscar.gif" width="15" height="15" border="0" alt="Cat&aacute;logo de Cuentas de Banco" style="cursor:pointer" onClick="ObjForm.BuscarCatalogo('cuentascgcre')">
        <input name="txtdenominacionscgcre" type="text" class="sin-borde" id="txtdenominacionscgcre" style="text-align:left" value="<?php print $ls_dencuenta_banco; ?>" size="35" maxlength="254" readonly>
      </span></td>
    <tr>
      <td height="22" align="right">Contabilizar NC y DEP.:</td>
      <td><label>
        <input type="checkbox" name="chkcontnc" id="chkcontnc"  checked>
      </label></td>
    <tr>
      <td height="22" colspan="2" align="center">
        <input type="button" name="button" id="button" value="PROCESAR ARCHIVO" onClick="ObjForm.Procesar()">
        </div></td>
  </table>
  <br>
  <p>
<?php 
if($_GET['subir']){$resp = $objscb->ImprimirResultadosEstCta();}
?>
<div id="resultados" align="center"></div>	
	</p>
<?php 
//////////////////////////////////////////////         SEGURIDAD               /////////////////////////////////////////////
	$objscb->imprimir_permisos($objscb->permisos,$objscb->la_permisos,$_SESSION["la_logusr"],"window.location='sigespwindow_blank.php'");
//////////////////////////////////////////////         SEGURIDAD               /////////////////////////////////////////////
?>	
<input type="hidden" name="procesar" id="procesar" value="<?php echo $_GET['subir'];  ?>" >
<input type="hidden" name="hestatus_subida" id="hestatus_subida" value="<?php echo $estatus_subida;  ?>" >
<input type="hidden" name="nombre_archivo" id="nombre_archivo" value="<?php echo $_FILES['txt_menu']['name'];  ?>" >
</form>       
</body>
</html>
