<?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
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('0001','0002','0003','0004','0005') and
                        pn.staper = '1' and
                      
                        pn.anocur='2016' and
                        pn.codperi= '002'
                        order  by cargo";
$con=Yii::app()->db_tves2016->createCommand($sentencia);
             $datareader=$con->queryAll();


?>

<h2>REPORTE DE PERFILES DE USUARIO SISTEMA RECIBOS</h2>
<table style="width:100%" >
  <tr>
    <td>Cedula</td>
    <td>Nombre</td> 
    <td>Departamento</td>
    <td>Twitter</td>
  </tr>
  <?php foreach($datareader as $perfil) { ?>
<tr>
    <td><?php echo $perfil['nombre']; ?></td>
     <td></td>
     <td></td>
      <td></td>
</tr>
  <?php } ?>
</table>
 





