<?php

class Recibo extends CFormModel {

         public function Obtener_db_actual()
	{
             $db_actual="db_tves".date('Y');
             return $db_actual;
        
         }
        
        public function Obtener_cedula()
	{
            
          $userid= Yii::app()->user->id;
          //$consulta=CrugeStoredUser::model()->findByPK($userid);
           $consulta= MUsuario::model()->findByPK($userid);
          $cedula=$consulta->usuario;
		
		return $cedula;
			
	}
        
        public function Obtener_periodo_actual()
	{
            $db_actual=Sigesp::Obtener_db_actual();
            
            
            $select="select to_char(to_number(max(s.codperi),'099'),'099') as codigo_periodo 
                 from 
                 public.sno_hpersonalnomina s, 
                 public.sno_personal t, 
                 public.sno_hperiodo per
                 where t.cedper='".Sigesp::Obtener_cedula()."' and  s.codper = t.codper
                 and per.codnom in('0001','0002','0003','0004','0005','0006','0007','0008','0009','0010')
                 and s.codnom= per.codnom
                 and (current_date - per.fecdesper) <=31
                 and s.staper='1' ;";
            
             $con=Yii::app()->$db_actual->createCommand($select);
             $datareader=$con->queryRow();
		
		return  $datareader['codigo_periodo'];
			
	}
        
         public function Obtener_perfil()
	{
             $db_actual=Sigesp::Obtener_db_actual();
             $select="SELECT  
                        pn.codper, 
                        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
                        hp.codnom in('0001','0002','0003','0004','0005','0006','0007','0008','0009','0010') and
                        p.cedper = '".$this->Obtener_cedula()."' AND 
                        pn.codperi= '".$this->Obtener_periodo_actual()."';" ;
                        $con=Yii::app()->$db_actual->createCommand($select);
                        $data=$con->queryRow();
                       
                        $ss="qw";
                                  $ar=  array(
                "cedula" =>$data['cedula'],
                "nombre" =>"sa",
//                "apellido" => $datareader['apellido'],
//                "cedula" => $datareader['cedula'],
//                "fecha_ingreso" => $datareader['fecha_ingreso'],
//                "fecha_egreso" => $datareader['fecha_ingreso'],
//                "fecha_jubilacion" => $datareader['fecha_jubilacion'],
//                "cargo" => $datareader['cargo'],
//                "unidad_administrativa" => $datareader['unidad_administrativa'],
//                "condicion_trabajador" => $datareader['condicion_trabajador'],
//                "cuenta_bancaria" =>$datareader['cuenta_bancaria'],
            );
                        return $ar;

        }
        
        
      
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
}