<?php
	session_start();
	//$ls_logusr=$_SESSION["la_logusr"];
	require_once("class_folder/class_funciones_apr.php");
	include("config_sybase.php");
	
	$io_fun_apr=new class_funciones_apr();
	$ls_ruta="resultado";
	@mkdir($ls_ruta,0755);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<script type="text/javascript" language="JavaScript1.2" src="../shared/js/disabled_keys.js"></script>
<script language="javascript">
	if(document.all)
	{ //ie 
		document.onkeydown = function(){ 
		if(window.event && (window.event.keyCode == 122 || window.event.keyCode == 116 || window.event.ctrlKey)){
		window.event.keyCode = 505; 
		}
		if(window.event.keyCode == 505){ 
		return false; 
		} 
		} 
	}
</script>
<title>Liberar Apertura</title>
<meta http-equiv="" content="text/html; charset=iso-8859-1">
<meta http-equiv="" content="text/html; charset=iso-8859-1">
<script type="text/javascript" language="JavaScript1.2" src="../spg/js/stm31.js"></script>
<meta http-equiv="" content="text/html; charset=iso-8859-1"><meta http-equiv="" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=">
<style type="text/css">
<!--
a:link {
	color: #006699;
}
a:visited {
	color: #006699;
}
a:hover {
	color: #006699;
}
a:active {
	color: #006699;
}
-->
</style>
<link href="../shared/css/cabecera.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/ventanas.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.Estilo1 {font-weight: bold}
-->
</style>
<link href="../shared/js/css_intra/datepickercontrol.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="780" border="0" align="center" cellpadding="0" cellspacing="0" class="contorno">
  <tr> 
    <td height="30" class="cd-logo"><img src="../shared/imagebank/header.jpg" width="778" height="40"></td>
  </tr>
   <tr> 
    <td height="20" bgcolor="#FFFFFF" class="toolbar"><a href="../apr/sigesp_apr_conexion.php"><img src="../shared/imagebank/tools20/salir.gif" alt="Salir" width="20" height="20" border="0"></a><a href="javascript: ue_descargar('<?PHP print $ls_ruta;?>');"><img src="../shared/imagebank/tools20/download.gif" alt="Salir" width="20" height="20" border="0"></a></td>
  </tr>
</table>  
<?php
require_once("covensol_copia_sno_hconsolidada_oracle.php");
$objapr=new covensol_copia_historico();
$objapr->anobd = $_POST["sel_year"];
$objapr->transf_cestaticket = $_POST["chkct"];	
$objapr->borrar_tabla = $_POST['chklimpiartrans'];
$objapr->act_empresa = $_POST['chkactemp'];
$objapr->borrardatos = $_POST['chk_Limpiar'];
$objapr->transperadi = $_POST['chkperadi'];

$nominas = $objapr->uf_select_nomina();

if($_POST["operacion"]=="EJECUTAR")
{	
	
	$valido=$objapr->ue_transferir_nomina();    
	
	if($valido){
	  $objapr->io_mensajes->message("El proceso se ejecuto satifactoriamente");
	  $msjejec = $objapr->msjejec;
	  $msjresultado = $objapr->msjresultado;
	  $objapr->io_sql_destino->commit();
	}

}
?>
</div> 
<p>&nbsp;</p>
<form name="form1" method="post" action="">
	  

  <table width="403" border="0" align="center" cellpadding="0" cellspacing="1" class="formato-blanco">
    <tr>
      <td colspan="2" class="titulo-ventana">TRANSFERIR HIST&Oacute;RICO DE N&Oacute;MINA (ORACLE) - SIREH</td>
    </tr>
    
    <tr>
      <td height="22" colspan="3" align="left"><strong>BD Actual:</strong> <span class="sin-borde2"><?php echo $_SESSION['SID_ORA']; ?> </span></td>
    </tr>
    <tr>
      <td height="22" colspan="3" align="left"><strong>BD Consolidadora:</strong> <span class="sin-borde2"><?php echo $historica["database"]; ?> </span></td>
    </tr>
    <tr>
      <td height="22" colspan="3" align="left"><strong>A&ntilde;o a Transferir:</strong>
      <label><?php echo $objapr->combo_year; ?></label></td>
    </tr>
    <tr>
      <td height="22" colspan="3" align="center">
       <table width="570" border="0" class="formato-blanco" align="center">
            
            <tr>
              <td><div align="right"><strong>Mostrar Resultados</strong></div></td>
              <td align="left"><input name="chkresult" type="checkbox" class="sin-borde" id="chkresult" value="1" checked <?php if($_POST['chkresult']){ echo 'checked';}?>></td>
            </tr>
             <tr>
              <td>
                
                <div align="right"><strong> Actualizar Empresa </strong></div></td>
                <td align="left"><input name="chkactemp" type="checkbox" class="sin-borde" id="chkactemp" <?php if($_POST['chkactemp']){ echo 'checked';}?> ></td>
            </tr>
             <tr>
               <td colspan="2" class="titulo-ventana">OPCIONES DE BORRADO</td>
             </tr>
            <tr>
               <td width="213">
                 <div align="right"><strong>Limpiar y Transferir       </strong></div></td>
              <td width="345" align="left"><input name="chklimpiartrans" type="checkbox" class="sin-borde" id="chklimpiartrans" value="1" <?php if($_POST['chklimpiartrans']){ echo 'checked';}?>></td>
            </tr>
            <tr>
              <td>
                
                <div align="right"><strong>Solo Limpiar </strong></div></td>
                <td align="left"><input name="chk_Limpiar" type="checkbox" class="sin-borde" id="chk_Limpiar" <?php if($_POST['chk_Limpiar']){ echo 'checked';}?> ></td>
            </tr>
    </table>      </td>
    </tr>
    <tr>
      <td height="22" colspan="3" align="center"><label>
        <input name="botaceptar" type="button" class="boton" id="botaceptar" value="EJECUTAR" onClick="uf_aceptar('EJECUTAR')">
      &nbsp;&nbsp;&nbsp;
      <input name="botaceptar2" type="button" class="boton" id="botaceptar2" value="MOSTRAR NOMINAS" onClick="uf_aceptar('MOSTRAR')">
      </label></td>
    </tr>
    <tr>
      <td height="22" colspan="3" align="center">
      		<?php
					require_once("../shared/class_folder/grid_param.php");
					$io_grid=new grid_param();
					$ls_titletable="Períodos";
					$li_widthtable=800;
					$ls_nametable="grid";
					$lo_title[1]="Empresa";
					$lo_title[2]="Código Actual";
					$lo_title[3]="Descripción";					
					$lo_title[4]="Periodo Des.";
					$lo_title[5]="Periodo Has.";
					$lo_title[6]="Tipo Nómina";
					$lo_title[7]="Código Nuevo";
					$lo_title[8]="Pasar";
					
					$io_grid->makegrid($nominas['total'],$lo_title,$nominas['filas'],$li_widthtable,$ls_titletable,$ls_nametable);
					unset($io_grid);

		     ?> 
      <input name="totrownomina" type="hidden" id="totrownomina" value="<?php print $nominas['total']; ?>">  
      </td>
    </tr>
    <tr>
      <td height="22" colspan="3" align="center"><div align="right"><span class="Estilo1">
        <input name="operacion"   type="hidden"   id="operacion"   value="<?php print $ls_operacion;?>">
      </span></a></div></td>
    </tr>
    <?php if(($msjejec or $msjresultado) and $_POST['chkresult']){ ?>
    
   
    <tr>
      <td align="center" class="formato-azul">Resultados del Proceso</td>
    </tr>
    <tr><td>
    <?php echo $msjejec.'<br /><br /><br />'.$msjresultado; ?>
    </td></tr>
    
    
    <?php } ?>
  </table>
  <div align="left"></div>

</form>    
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
<script language="JavaScript">

function uf_aceptar(ope)
{
	f=document.form1;
	//li_cambiar=f.cambiar.value;
	//li_incluir=f.incluir.value;
	if(f.sel_year.value==""){
		alert("Debe seleccionar un año a transferir !");
		return;
	}
	
	if(ope=='EJECUTAR'){			
			f.operacion.value="EJECUTAR";		
			f.submit();			
	}
	
	if(ope=='MOSTRAR'){			
			f.operacion.value="MOSTRAR";		
			f.submit();				
	}
}

function ue_descargar(ruta)
{
	window.open("sigesp_apr_cat_directorio.php?ruta="+ruta+"","catalogo","menubar=no,toolbar=no,scrollbars=yes,width=530,height=400,left=50,top=50,location=no,resizable=no");
}

</script>
</html>
