<?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";
}

if($cedula=="10626622")
{

$select_perfil = "SELECT     pn.anocur,pn.codperi,pn.codnom,
           pn.codper, p.nomper, p.apeper, pn.sueper,r.monnetres,
           pn.anocur,u.desuniadm,hc.descar,hrac.denasicar,hp.fecdesper,hp.fechasper,tp.dentippersss,
           pn.fecingper as fecingnom, p.fecingper as fecinginst,p.cedper, pn.pagbanper,pn.pagefeper,hb.nomban,pn.codcueban,snp.obsrecper,pn.tipcuebanper,r.*
FROM sno_hpersonalnomina pn
INNER JOIN sno_personal p ON p.codemp=pn.codemp AND p.codper=pn.codper
INNER JOIN sno_tipopersonalsss tp ON  tp.codemp=p.codemp
                                 AND tp.codtippersss = p.codtippersss

INNER JOIN sno_personalnomina snp ON  snp.codnom=pn.codnom
                                AND   snp.codper=pn.codper

INNER JOIN sno_hresumen r ON r.codemp=pn.codemp
                                                   AND r.codnom=pn.codnom
                                                   AND r.anocur=pn.anocur
                                                   AND r.codperi=pn.codperi
                                                   AND r.codper=pn.codper
INNER JOIN sno_hunidadadmin u ON 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
INNER JOIN sno_hcargo hc ON pn.codemp = hc.codemp
                        AND pn.codnom = hc.codnom
                        AND pn.anocur = hc.anocur
                        AND pn.codcar = hc.codcar
                        AND pn.codperi = hc.codperi
INNER JOIN sno_hasignacioncargo hrac ON pn.codemp = hrac.codemp
                                         AND pn.codnom = hrac.codnom
                                         AND pn.anocur = hrac.anocur
                                         AND pn.codasicar = hrac.codasicar
                                         AND pn.codperi = hrac.codperi
INNER JOIN sno_hperiodo hp ON pn.codemp = hp.codemp
                           AND pn.codnom = hp.codnom
                           AND pn.anocur = hp.anocur
                           AND pn.codperi = hp.codperi
LEFT JOIN scb_banco hb ON hb.codemp = pn.codemp
                      AND hb.codban = pn.codban
WHERE r.codnom = '0001'
AND r.codperi = '".$periodo."'
AND p.cedper LIKE  '%".$cedula."%'
AND r.anocur='".$anio."' ";

} else {

$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 LIKE '%".$cedula."%' AND
                        pn.anocur='".$anio."' AND
                        pn.codperi= '".$periodo."' order by sueper asc;" ;

}




$con2=Yii::app()->$conex->createCommand($select_perfil);

$perfil=$con2->queryRow();


/*

echo "<pre>";
var_dump($periodo);die;
*/


$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();

/*
echo "<pre>";
var_dump($perfil);die;
*/

?>
<img  src="<?php echo Yii:: app() ->baseUrl.'/images/logorecibo.png' ?>">

<h1 style="text-align: center">Recibo de Pago</h1>
<table style="width:100%">
    <tr>
        <td>    
	<div>
		<strong>Trabajador:</strong> 
		<?php echo ($cedula=="10626622") ? $perfil['nomper'] ." ".$perfil['apeper'] : $perfil['nombre'] ." ".utf8_decode(utf8_decode($perfil['apellido'])) ?>
	</div>
    <div>
	<strong>Cédula:</strong> 
	<?php echo ($cedula=="10626622") ? $perfil['cedper'] : $perfil['cedula'] ?>
    </div>
    <div><strong>Cargo:</strong>
	<?php 
     		if($perfil['cargo_observacion']==""){
        		echo ($cedula=="10626622") ? $perfil['obsrecper'] : $perfil['cargo'];  
    		}else{
        		echo ($cedula=="10626622") ? $perfil['obsrecper'] : $perfil['cargo_observacion'];  
    		}
    	?>
    </div>
    <div><strong>Unidad Administrativa:</strong> <?php echo ($cedula=="10626622") ? $perfil['desuniadm']  : $perfil['unidad_administrativa'] ?></div>
    <div><strong>Fecha de Ingreso:</strong> <?php ($cedula=="10626622") ? $fechai=$perfil['fecingnom'] :$fechai=$perfil['fecha_ingreso'];
$fecha_m = explode("-", $fechai);
$dia_m =$fecha_m[2];
$mes_m =$fecha_m[1];
$anio_m=$fecha_m[0];
$fecha_inicio= $dia_m.'-'.$mes_m.'-'.$anio_m;   
 echo $fecha_inicio;?></div>
  <!--  <div><strong>Condicion:</strong> <?php // echo $perfil['condicion_trabajador'] ?></div> -->
    <div><strong>Cuenta Bancaria:</strong> <?php echo ($cedula=="10626622") ? $perfil['codcueban'] : $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>

<table style="width:100%">
    
    <thead style="background-color:  #000; color:  #fff">
  <tr style="background-color:  #000; color:  #fff">
        <td style="color:  #fff">CANTIDAD</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 $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">CANTIDAD</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 $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>