<?php
$sentencia="SELECT  
                        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,
                         pn.sueper AS sueldo,
                          hp.codnom AS codigo_nomina
                         
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
                        hp.codnom in('0003') and
                        pn.staper = '1' and
                      p.cedper='14972598' and
                        pn.anocur='2016' and
                        pn.codperi= '003'
                        order  by cargo
                        LIMIT 2";
$con=Yii::app()->db_tves2016->createCommand($sentencia);
             $datareader=$con->queryAll();


?>

<h2>REPORTE MINCI</h2>
<table style="width:100%" >
  <tr>
    <td>Cargo</td>
   <td>Fecha de Ingreso</td>
     <td>Sueldo basico mensual</td>
      <td>Prima por Jerarquia</td>
        <td>Prima por Responsabilidad</td>
          <td>Prima por Compromiso</td>
          <td>Bono Nocturno</td>
          <td>Horas extras diurnas</td>
          <td>Horas extras nocturnas</td>
          <td>Guardias</td>
          <td>Dscansos trabajados</td>
           <td>Feriados trabajados</td>
           <td>Sustituciones temporales</td>
           
            <td>Nacimiento</td>
             <td>Matrimonio</td>
              <td>Fallecimiento</td>
               <td>Alimentacion</td>
                <td>Vitaminas</td>
     
  </tr>
  <?php foreach($datareader as $perfil) { ?>
<tr>
    <td><?php echo $perfil['cargo']; ?></td>
    
      <td><?php echo $perfil['fecha_ingreso']; ?></td>
       <td><?php echo $perfil['sueldo']; ?></td>
       
       
      <?php
      $cedula=$perfil['cedula'];
      $nomina=$perfil['codigo_nomina'];
      $jerarquia=$this->obtenerconceptos('0000000003',$cedula,$nomina);
      ?>
   
<td><?php echo $jerarquia ?></td>


<?php $responsabilidad=$this->obtenerconceptos('0000000093',$cedula,$nomina);?>
<td><?php echo $responsabilidad?></td>

<?php $compromiso=$this->obtenerconceptos('0000000079',$cedula,$nomina);?>
<td><?php echo $compromiso?></td>

<?php $bn=$this->obtenerconceptos('0000000005',$cedula,$nomina);?>
<td><?php echo $bn?></td>

<?php 
// 0007 0009
$hora_extra_diurna=$this->obtenerconceptos('0000000033',$cedula,'0007');?>
<td><?php echo $hora_extra_diurna?></td>

<?php // 0007 0009
$hora_extra_nocturna=$this->obtenerconceptos('0000000034',$cedula,'0007');?>
<td><?php echo $hora_extra_nocturna?></td>

<?php // 0007 0009
$guardias=$this->obtenerconceptos('0000000035',$cedula,'0007');?>
<td><?php echo $guardias?></td>

<?php // 0007 0009
$descanso_trabajador=$this->obtenerconceptos('0000000067',$cedula,'0007');?>
<td><?php echo $descanso_trabajador?></td>

<?php // 0007 0009
$feriados_trabajados=$this->obtenerconceptos('0000000059',$cedula,'0007');?>
<td><?php echo $feriados_trabajados?></td>

<?php 
$sustituciones_temporales=$this->obtenerconceptos('0000000018',$cedula,$nomina);?>
<td><?php echo $sustituciones_temporales?></td>

<?php $nacimiento=$this->obtenerconceptos('0000000040',$cedula,$nomina);?>
<td><?php echo $nacimiento?></td>

<?php $matrimonio=$this->obtenerconceptos('0000000039',$cedula,$nomina);?>
<td><?php echo $matrimonio?></td>

<?php $fallecimiennto=$this->obtenerconceptos('0000000042',$cedula,$nomina);?>
<td><?php echo $fallecimiennto?></td>

<?php 
//0057 0058 0059
$alimentacion=$this->obtenerconceptos('0000000057',$cedula,'0013');?>
<td><?php echo $alimentacion?></td>

<?php 
//0057 0058 0059
$vitaminas=$this->obtenerconceptos('0000000057',$cedula,'0037');?>
<td><?php echo $vitaminas?></td>


</tr>
  <?php } ?>
</table>
 



