<?php
if($anio=='ise_2017'){
  $anio=2017;
$conex="enterprise_2017";
}
if($anio=='18'){
  $anio=2018;
$conex="rcm_2018";
}
if($anio=='2016'){
$conex="db_tves2016";
}
if($anio=='2015'){
$conex="db_tves2015";
}
if($anio=='2014'){
$conex="db_tves2014";
}

$select_perfil="SELECT  
                          pn.sueper,
                        pn.codper, 
                        pn.obsrecper as cargo_observacion,
                        p.cedper as usuario, 
                        p.nomper AS nombre, 
                         p.apeper AS apellido,
                        to_number( pn.codper, '99999999999') AS cedula,
                        p.sexper as sexo,
                        p.fecingper as fecha_ingreso,
                        p.fecegrper as fecha_egreso,
                        p.fecjubper as fecha_jubilacion,
                        hc.descar AS cargo,
                        u.desuniadm AS unidad_administrativa,
                        tp.dentippersss AS condicion_trabajador,
                        pn.codcueban AS cuenta_bancaria
FROM
                        public.sno_hpersonalnomina pn, 
                        public.sno_personal p, 
                        public.sno_tipopersonalsss tp, 
                        public.sno_hresumen r, 
                        public.sno_hunidadadmin u, 
                        public.sno_hcargo hc, 
                        public.sno_hasignacioncargo hrac, 
                        public.sno_hperiodo hp 

WHERE
                        pn.codemp = u.codemp  AND
                        pn.anocur = u.anocur AND
                        pn.codperi= u.codperi AND
                        pn.codnom = u.codnom AND
                        pn.minorguniadm = u.minorguniadm AND
                        pn.ofiuniadm = u.ofiuniadm AND
                        pn.uniuniadm = u.uniuniadm AND
                        pn.depuniadm = u.depuniadm AND
                        pn.prouniadm = u.prouniadm AND
                        pn.codemp = hc.codemp AND
                        pn.codnom = hc.codnom AND
                        pn.anocur = hc.anocur AND
                        pn.codcar = hc.codcar AND
                        pn.codperi = hc.codperi AND
                        pn.codnom = hrac.codnom AND
                        pn.anocur = hrac.anocur AND
                        pn.codasicar = hrac.codasicar AND
                        pn.codperi = hrac.codperi AND
                        pn.codemp = hrac.codemp AND
                        pn.codemp = hp.codemp AND
                        pn.codnom = hp.codnom AND
                        pn.anocur = hp.anocur AND
                        pn.codperi = hp.codperi AND
                        p.codemp= pn.codemp AND
                        p.codper= pn.codper AND
                        tp.codemp= p.codemp AND
                        tp.codtippersss = p.codtippersss AND
                        r.codemp = pn.codemp AND
                        r.codnom = pn.codnom AND
                        r.anocur = pn.anocur AND
                        r.codperi = pn.codperi AND
                        r.codper = pn.codper AND
                           pn.sueintper != '0' and
                        hp.codnom in('0001','0002','0003','0004','0005','0006','0007','0008','0009','0010','0014','0015','0016') and
                        p.cedper = '".$cedula."' AND 
                            pn.anocur='".$anio."' and
       pn.codperi= '".$periodo."' order by sueper asc;" ;
$con2=Yii::app()->$conex->createCommand($select_perfil);
$perfil=$con2->queryRow();






//AND pn.sueintper != '0'

$sentencia="select *
from sno_hsalida hs
inner join sno_hconcepto c
on 
c.codconc=hs.codconc
AND c.codemp=hs.codemp
AND c.codnom=hs.codnom 
AND c.anocur=hs.anocur 
AND c.codperi=hs.codperi
where hs.tipsal!='P2'
and hs.tipsal!='R'
and hs.valsal!='0'
and hs.codnom='".$codnom."'
and hs.codperi='".$periodo."'
and hs.codper like '%".$cedula."'
and   hs.anocur='".$anio."'
order by hs.codconc asc " ;

 $con1=Yii::app()->$conex->createCommand($sentencia);
 $datareader=$con1->queryAll();



$baseUrl = Yii::app()->baseUrl; 
$cs = Yii::app()->getClientScript();
$cs->registerScriptFile($baseUrl.'/js/stacktable.js');
$cs->registerCssFile($baseUrl.'/js/stacktable.css');
 
?>

 

<style type="text/css" media="print">
#imprime {display:none}
#mainmenu {display:none}
</style>
<input type="button" name="imprimir" id="imprime" value="Imprimir" onclick="window.print();" class="btn btn-primary">
<h1 style="text-align: center">Recibo de Pago</h1>
<table style="width:100%">
    <tr>
        <td>    <div><strong>Trabajador:</strong> <?php echo utf8_decode(utf8_decode($perfil['nombre']))." ".utf8_decode(utf8_decode($perfil['apellido'])) ?></div>
    <div><strong>Cédula:</strong> <?php echo $perfil['cedula'] ?></div>
    <div><strong>Cargo:</strong> <?php 
     if($perfil['cargo_observacion']==""){
        echo $perfil['cargo'];
    }else{
        echo $perfil['cargo_observacion'];  
    }
    ?></div>
    <div><strong>Unidad Administrativa:</strong> <?php echo $perfil['unidad_administrativa'] ?></div>
    <div><strong>
</div>
 <!--   <div><strong>Condicion:</strong> <?php // echo $perfil['condicion_trabajador'] ?></div> -->
    <div><strong>Cuenta Bancaria:</strong> <?php echo $perfil['cuenta_bancaria'] ?></div></td>
    
    
    <td>
        <div><strong>Sueldo:</strong> <?php   $nombre_format_francais = number_format($perfil['sueper'], 2, ',', '.');
					 echo $nombre_format_francais; ?></div>
         <div><strong>Fecha:</strong> <?php echo date("d-m-Y"); ?></div>
         <div><strong>Nomina:</strong> <?php 
         $sentencia_nomina="select * from sno_nomina where codnom = '".$codnom."' ";
         $con4=Yii::app()->$conex->createCommand($sentencia_nomina);
         $row5=$con4->queryRow();
         echo $anio." ".$row5['desnom']." ".$codnom?></div>
         <div><strong>Periodo:</strong> <?php 
         $sentencia_periodo="select * from sno_periodo where codperi = '".$periodo."' and
         codnom ='".$codnom."'";
         $con3=Yii::app()->$conex->createCommand($sentencia_periodo);
         $row4=$con3->queryRow();
         $fecha=$row4["fecdesper"];
         $fecha_m = explode("-", $fecha);
         $dia_m =$fecha_m[2];
         $mes_m =$fecha_m[1];
         $anio_m=$fecha_m[0];
         $desde= $dia_m.'-'.$mes_m.'-'.$anio_m;   

 
   $fecha2=$row4["fechasper"];
$fecha_m = explode("-", $fecha2);
$dia_m =$fecha_m[2];
$mes_m =$fecha_m[1];
$anio_m=$fecha_m[0];
$hasta= $dia_m.'-'.$mes_m.'-'.$anio_m;  
         echo $row4['codperi']. " fecha: ".$desde." / ".$hasta?></div>
    </td> 
    
  </tr>
</table>

<hr>





<script type=�text/javascript�>
$(document).ready(function() {
$('#tabla1').stacktable();
});
</script>


<div class="table-responsive">

<table    id="tabla1" class="table stacktable table-condensed">
    
    <thead style="background-color:  #000; color:  #fff">
  <tr style="background-color:  #000; color:  #fff">
        <td style="color:  #fff">N*</td>
      <td style="color:  #fff">ASIGNACIONES</td>
    <td style="color:  #fff">MONTO</td> 
    
  </tr>
  </thead>
  <tbody>
  <?php 
  $totalaportes = 0.00;
  $totaldeducciones = 0.00;
  foreach ($datareader as $asignacion) { ?>
   <?php if ($asignacion['valsal'] > 0){ ?>
  <tr>
       <td style="width: 50px"><?php 
      $codcons=$asignacion["consunicon"];
      $sentenciacant="select  * from sno_hconstantepersonal where codnom='".$codnom."' and codperi='".$periodo."'
and codper like '%".$cedula."'
and   anocur='".$anio."' and codcons='".$codcons."' ";
$con3=Yii::app()->$conex->createCommand($sentenciacant);
$datareader3=$con3->queryRow();
      if($datareader3){
         echo $datareader3["moncon"]; 
      }else{
           echo "0";
      }
       ?></td>
      
    <td><?php echo 
   
$nombress = strtolower($asignacion["nomcon"]);
   
    ?></td>
    <td><?php  echo number_format($asignacion["valsal"], 2, ',', '.'); ?></td> 
    <?php $totalaportes = $totalaportes + $asignacion['valsal'] ?>
  </tr>
  <?php }?>
  <?php } ?>
  
  <tr >
<td></td>
            <td style="text-align: right"><b>TOTAL ASIGNACIONES</b></td>
            <td><b><?php echo number_format($totalaportes, 2, ',', '.') ?></b> </td>
            
        </tr>
     
        </tbody>
         
         <thead style="background-color:  #000; color:  #fff">
             <tr style="background-color:  #000; color:  #fff">
                  <td style="color:  #fff">N*</td>
                 <td style="color:  #fff">DEDUCCIONES</td>
    <td style="color:  #fff">MONTO</td> 
    
  </tr>
  </thead>
  <tbody>
  <?php 
 
  foreach ($datareader as $deduccion) { ?>
   <?php if ($deduccion['valsal'] < 0){ ?>
  <tr>
       <td style="width: 50px"><?php 
          $codcons=$deduccion["consunicon"];
        $sentenciacant="select  * from sno_hconstantepersonal where codnom='".$codnom."' and codperi='".$periodo."'
and codper like '%".$cedula."'
and   anocur='".$anio."' and codcons='".$codcons."' ";
$con3=Yii::app()->$conex->createCommand($sentenciacant);
$datareader3=$con3->queryRow();
      if($datareader3){
         echo $datareader3["moncon"]; 
      }else{
          echo "0";
      }
       ?></td>
    <td><?php 
    echo 
   
$nombress2 = strtolower($deduccion["nomcon"]);
    
    ?></td>
    <td><?php  echo number_format((-1 * $deduccion['valsal']), 2, ',', '.'); ?></td> 
    <?php $totaldeducciones = $totaldeducciones + (-1 * $deduccion['valsal']) ?>
  </tr>
  <?php }?>
  <?php } ?>
   <tr >
<td></td>
       <td style="text-align: right"><b>TOTAL DEDUCCIONES</b></td>
            <td><b><?php echo number_format($totaldeducciones, 2, ',', '.') ?></b> </td>
            
        </tr>
         <tr  >
              <td></td>
            <td style="text-align: right"><b>NETO A COBRAR</b></td>
           
            <td ><b><?php echo number_format(($totalaportes - $totaldeducciones), 2, ',', '.') ?> </b></td>
        </tr>
        </tbody>
</table>



</div>