<?php

/**
 * This is the model class for table "pbb.sppt".
 *
 * The followings are the available columns in table 'pbb.sppt':
 * @property string $kd_propinsi
 * @property string $kd_dati2
 * @property string $kd_kecamatan
 * @property string $kd_kelurahan
 * @property string $kd_blok
 * @property string $no_urut
 * @property string $kd_jns_op
 * @property string $thn_pajak_sppt
 * @property integer $siklus_sppt
 * @property string $kd_kanwil
 * @property string $kd_kantor
 * @property string $kd_tp
 * @property string $nm_wp_sppt
 * @property string $jln_wp_sppt
 * @property string $blok_kav_no_wp_sppt
 * @property string $rw_wp_sppt
 * @property string $rt_wp_sppt
 * @property string $kelurahan_wp_sppt
 * @property string $kota_wp_sppt
 * @property string $kd_pos_wp_sppt
 * @property string $npwp_sppt
 * @property string $no_persil_sppt
 * @property string $kd_kls_tanah
 * @property string $thn_awal_kls_tanah
 * @property string $kd_kls_bng
 * @property string $thn_awal_kls_bng
 * @property string $tgl_jatuh_tempo_sppt
 * @property string $luas_bumi_sppt
 * @property string $luas_bng_sppt
 * @property string $njop_bumi_sppt
 * @property string $njop_bng_sppt
 * @property string $njop_sppt
 * @property integer $njoptkp_sppt
 * @property string $pbb_terhutang_sppt
 * @property string $faktor_pengurang_sppt
 * @property string $pbb_yg_harus_dibayar_sppt
 * @property string $status_pembayaran_sppt
 * @property string $status_tagihan_sppt
 * @property string $status_cetak_sppt
 * @property string $tgl_terbit_sppt
 * @property string $tgl_cetak_sppt
 * @property string $nip_pencetak_sppt
 * @property integer $createdby
 * @property string $createdtime
 * @property integer $updatedby
 * @property string $updatedtime
 */
class Sppt extends CBhumieRecord {

    public $temp_nm_wp;
    public $temp_jalan_wp;
    public $temp_blok_kav_no_wp;
    public $temp_rw_wp;
    public $temp_rt_wp;
    public $temp_luas_bumi;
    public $temp_luas_bangunan;
    public $temp_njop_bumi;
    public $temp_njop_bangunan;
    public $temp_njop;
    public $temp_njoptkp;
    public $temp_njkp;
    public $temp_pbb_terhutang;
    public $temp_pbb_yg_harus_dibayar;
    public $jml_sppt_yg_dibayar;
	public $jumlah_bayar;
	public $tgl_bayar;
    
    //informasi sppt
    public $nop;
    public $nm_tp;
    public $nm_kecamatan;
    public $nm_kelurahan;
    public $pbb;
    public $tgl;
    
    //proses pengurangan
    public $total_siklus_sppt;
  //  public $temp_pbb_terhutang;
    public $temp_faktor_pengurang;
   // public $temp_pbb_yg_harus_dibayar;
    
    public static function model($className = __CLASS__) {
        return parent::model($className);
    }

    /**
     * @return string the associated database table name
     */
    public function tableName() {
        return 'pbb.sppt';
    }

    /**
     * @return array validation rules for model attributes.
     */
    public function rules() {
        // NOTE: you should only define rules for those attributes that
        // will receive user inputs.
        return array(
            array('kd_propinsi, kd_dati2, kd_kecamatan, kd_kelurahan, kd_blok, no_urut, kd_jns_op, thn_pajak_sppt, pbb_yg_harus_dibayar_sppt', 'required'),
            //array('siklus_sppt, njoptkp_sppt, createdby, updatedby', 'numerical', 'integerOnly' => true),
            array('kd_propinsi, kd_dati2, kd_kanwil, kd_kantor, kd_tp, rw_wp_sppt', 'length', 'max' => 2),
            array('kd_kecamatan, kd_kelurahan, kd_blok, rt_wp_sppt, kd_kls_tanah, kd_kls_bng', 'length', 'max' => 3),
            array('no_urut, thn_pajak_sppt, thn_awal_kls_tanah, thn_awal_kls_bng', 'length', 'max' => 4),
            array('kd_jns_op, status_pembayaran_sppt, status_tagihan_sppt, status_cetak_sppt', 'length', 'max' => 1),
            array('nm_wp_sppt, jln_wp_sppt, kelurahan_wp_sppt, kota_wp_sppt', 'length', 'max' => 30),
            array('blok_kav_no_wp_sppt, npwp_sppt', 'length', 'max' => 15),
            array('kd_pos_wp_sppt, no_persil_sppt', 'length', 'max' => 5),
            array('nip_pencetak_sppt', 'length', 'max' => 18),
            array('tgl_jatuh_tempo_sppt, luas_bumi_sppt, luas_bng_sppt, njop_bumi_sppt, njop_bng_sppt, njop_sppt, pbb_terhutang_sppt, faktor_pengurang_sppt, tgl_terbit_sppt, tgl_cetak_sppt', 'safe'),
            // The following rule is used by search().
            // Please remove those attributes that should not be searched.
            array('kd_propinsi, kd_dati2, kd_kecamatan, kd_kelurahan, kd_blok, no_urut, kd_jns_op, thn_pajak_sppt, siklus_sppt, kd_kanwil, kd_kantor, kd_tp, nm_wp_sppt, jln_wp_sppt, blok_kav_no_wp_sppt, rw_wp_sppt, rt_wp_sppt, kelurahan_wp_sppt, kota_wp_sppt, kd_pos_wp_sppt, npwp_sppt, no_persil_sppt, kd_kls_tanah, thn_awal_kls_tanah, kd_kls_bng, thn_awal_kls_bng, tgl_jatuh_tempo_sppt, luas_bumi_sppt, luas_bng_sppt, njop_bumi_sppt, njop_bng_sppt, njop_sppt, njoptkp_sppt, pbb_terhutang_sppt, faktor_pengurang_sppt, pbb_yg_harus_dibayar_sppt, status_pembayaran_sppt, status_tagihan_sppt, status_cetak_sppt, tgl_terbit_sppt, tgl_cetak_sppt, nip_pencetak_sppt, createdby, createdtime, updatedby, updatedtime', 'safe', 'on' => 'search'),
        );
    }

    /**
     * @return array relational rules.
     */
    public function relations() {
        // NOTE: you may need to adjust the relation name and the related
        // class name for the relations automatically generated below.
        return array(
        );
    }

    /**
     * @return array customized attribute labels (name=>label)
     */
    public function attributeLabels() {
        return array(
            'kd_propinsi' => 'Kd Propinsi',
            'kd_dati2' => 'Kd Dati2',
            'kd_kecamatan' => 'Kd Kecamatan',
            'kd_kelurahan' => 'Kd Kelurahan',
            'kd_blok' => 'Kd Blok',
            'no_urut' => 'No Urut',
            'kd_jns_op' => 'Kd Jns Op',
            'thn_pajak_sppt' => 'Thn Pajak Sppt',
            'siklus_sppt' => 'Siklus Sppt',
            'kd_kanwil' => 'Kd Kanwil',
            'kd_kantor' => 'Kd Kantor',
            'kd_tp' => 'Tempat Pembayaran',
            'nm_wp_sppt' => 'Nm Wp Sppt',
            'jln_wp_sppt' => 'Jln Wp Sppt',
            'blok_kav_no_wp_sppt' => 'Blok Kav No Wp Sppt',
            'rw_wp_sppt' => 'Rw Wp Sppt',
            'rt_wp_sppt' => 'Rt Wp Sppt',
            'kelurahan_wp_sppt' => 'Kelurahan Wp Sppt',
            'kota_wp_sppt' => 'Kota Wp Sppt',
            'kd_pos_wp_sppt' => 'Kd Pos Wp Sppt',
            'npwp_sppt' => 'Npwp Sppt',
            'no_persil_sppt' => 'No Persil Sppt',
            'kd_kls_tanah' => 'Kd Kls Tanah',
            'thn_awal_kls_tanah' => 'Thn Awal Kls Tanah',
            'kd_kls_bng' => 'Kd Kls Bng',
            'thn_awal_kls_bng' => 'Thn Awal Kls Bng',
            'tgl_jatuh_tempo_sppt' => 'Tgl Jatuh Tempo Sppt',
            'luas_bumi_sppt' => 'Luas Bumi Sppt',
            'luas_bng_sppt' => 'Luas Bng Sppt',
            'njop_bumi_sppt' => 'Njop Bumi Sppt',
            'njop_bng_sppt' => 'Njop Bng Sppt',
            'njop_sppt' => 'Njop Sppt',
            'njoptkp_sppt' => 'Njoptkp Sppt',
            'pbb_terhutang_sppt' => 'Pbb Terhutang Sppt',
            'faktor_pengurang_sppt' => 'Faktor Pengurang Sppt',
            'pbb_yg_harus_dibayar_sppt' => 'Pbb Yg Harus Dibayar Sppt',
            'status_pembayaran_sppt' => 'Status Pembayaran Sppt',
            'status_tagihan_sppt' => 'Status Tagihan Sppt',
            'status_cetak_sppt' => 'Status Cetak Sppt',
            'tgl_terbit_sppt' => 'Tgl Terbit Sppt',
            'tgl_cetak_sppt' => 'Tgl Cetak Sppt',
            'nip_pencetak_sppt' => 'Nip Pencetak Sppt',
            /*'createdby' => 'Createdby',
            'createdtime' => 'Createdtime',
            'updatedby' => 'Updatedby',
            'updatedtime' => 'Updatedtime',*/
        );
    }

    /**
     * Retrieves a list of models based on the current search/filter conditions.
     * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
     */
    public function search() {
        // Warning: Please modify the following code to remove attributes that
        // should not be searched.

        $criteria = new CDbCriteria;

        $criteria->compare('kd_propinsi', $this->kd_propinsi, true);
        $criteria->compare('kd_dati2', $this->kd_dati2, true);
        $criteria->compare('kd_kecamatan', $this->kd_kecamatan, true);
        $criteria->compare('kd_kelurahan', $this->kd_kelurahan, true);
        $criteria->compare('kd_blok', $this->kd_blok, true);
        $criteria->compare('no_urut', $this->no_urut, true);
        $criteria->compare('kd_jns_op', $this->kd_jns_op, true);
        $criteria->compare('thn_pajak_sppt', $this->thn_pajak_sppt, true);
        $criteria->compare('siklus_sppt', $this->siklus_sppt);
        $criteria->compare('kd_kanwil', $this->kd_kanwil, true);
        $criteria->compare('kd_kantor', $this->kd_kantor, true);
        $criteria->compare('kd_tp', $this->kd_tp, true);
        $criteria->compare('nm_wp_sppt', $this->nm_wp_sppt, true);
        $criteria->compare('jln_wp_sppt', $this->jln_wp_sppt, true);
        $criteria->compare('blok_kav_no_wp_sppt', $this->blok_kav_no_wp_sppt, true);
        $criteria->compare('rw_wp_sppt', $this->rw_wp_sppt, true);
        $criteria->compare('rt_wp_sppt', $this->rt_wp_sppt, true);
        $criteria->compare('kelurahan_wp_sppt', $this->kelurahan_wp_sppt, true);
        $criteria->compare('kota_wp_sppt', $this->kota_wp_sppt, true);
        $criteria->compare('kd_pos_wp_sppt', $this->kd_pos_wp_sppt, true);
        $criteria->compare('npwp_sppt', $this->npwp_sppt, true);
        $criteria->compare('no_persil_sppt', $this->no_persil_sppt, true);
        $criteria->compare('kd_kls_tanah', $this->kd_kls_tanah, true);
        $criteria->compare('thn_awal_kls_tanah', $this->thn_awal_kls_tanah, true);
        $criteria->compare('kd_kls_bng', $this->kd_kls_bng, true);
        $criteria->compare('thn_awal_kls_bng', $this->thn_awal_kls_bng, true);
        $criteria->compare('tgl_jatuh_tempo_sppt', $this->tgl_jatuh_tempo_sppt, true);
        $criteria->compare('luas_bumi_sppt', $this->luas_bumi_sppt, true);
        $criteria->compare('luas_bng_sppt', $this->luas_bng_sppt, true);
        $criteria->compare('njop_bumi_sppt', $this->njop_bumi_sppt, true);
        $criteria->compare('njop_bng_sppt', $this->njop_bng_sppt, true);
        $criteria->compare('njop_sppt', $this->njop_sppt, true);
        $criteria->compare('njoptkp_sppt', $this->njoptkp_sppt);
        $criteria->compare('pbb_terhutang_sppt', $this->pbb_terhutang_sppt, true);
        $criteria->compare('faktor_pengurang_sppt', $this->faktor_pengurang_sppt, true);
        $criteria->compare('pbb_yg_harus_dibayar_sppt', $this->pbb_yg_harus_dibayar_sppt, true);
        $criteria->compare('status_pembayaran_sppt', $this->status_pembayaran_sppt, true);
        $criteria->compare('status_tagihan_sppt', $this->status_tagihan_sppt, true);
        $criteria->compare('status_cetak_sppt', $this->status_cetak_sppt, true);
        $criteria->compare('tgl_terbit_sppt', $this->tgl_terbit_sppt, true);
        $criteria->compare('tgl_cetak_sppt', $this->tgl_cetak_sppt, true);
        $criteria->compare('nip_pencetak_sppt', $this->nip_pencetak_sppt, true);
        $criteria->compare('createdby', $this->createdby);
        $criteria->compare('createdtime', $this->createdtime, true);
        $criteria->compare('updatedby', $this->updatedby);
        $criteria->compare('updatedtime', $this->updatedtime, true);

        return new CActiveDataProvider($this, array(
                    'criteria' => $criteria,
                ));
    }

    public function infoSpptJoinTempData($kd_kanwil, $kd_kantor, $thn_pelayanan, $bundel_pelayanan,$no_urut_pelayanan,$kd_propinsi_pemohon,$kd_dati2_pemohon,$kd_kecamatan_pemohon,$kd_kelurahan_pemohon,$kd_blok_pemohon,$no_urut_pemohon,$kd_jns_op_pemohon,$thn_pajak_sppt) {
        $user = Yii::app()->db->createCommand()
    ->select("t.siklus_sppt, 
                             t.kd_kanwil, 
                             t.kd_kantor, 
                             t.kd_tp, 
                             b.temp_nm_wp, 
                             b.temp_jalan_wp, 
                             b.temp_blok_kav_no_wp, 
                             b.temp_rw_wp, 
                             b.temp_rt_wp, 
                             t.kelurahan_wp_sppt, 
                             t.kota_wp_sppt, 
                             t.kd_pos_wp_sppt, 
                             t.npwp_sppt,
                             t.no_persil_sppt, 
                             TO_CHAR(t.tgl_jatuh_tempo_sppt,'YYYY-MM-DD') as tgl_jatuh_tempo_sppt, 
                             b.kd_kls_tanah, 
                             b.thn_awal_kls_tanah, 
                             b.kd_kls_bng, 
                             b.thn_awal_kls_bng, 
                             b.temp_luas_bumi, 
                             b.temp_luas_bangunan, 
                             b.temp_njop_bumi, 
                             b.temp_njop_bangunan, 
                             b.temp_njop, 
                             b.temp_njoptkp,                              
                             b.temp_pbb_terhutang, 
                             b.temp_pbb_yg_harus_dibayar, 
                             t.status_pembayaran_sppt, 
                             t.faktor_pengurang_sppt, 
                             t.status_tagihan_sppt, 
			     TO_CHAR(t.tgl_terbit_sppt,'YYYY-MM-DD') as tgl_terbit_sppt, 
                             TO_CHAR(t.tgl_cetak_sppt,'YYYY-MM-DD') as tgl_cetak_sppt, 
                             t.nip_pencetak_sppt")
    ->from('pbb.sppt t')
    ->join('pbb.temp_data_op b', 'b.kd_propinsi_pemohon	= t.kd_propinsi
				  AND (b.kd_dati2_pemohon    	= t.kd_dati2)
				  AND (b.kd_kecamatan_pemohon	= t.kd_kecamatan)
				  AND (b.kd_kelurahan_pemohon	= t.kd_kelurahan)
				  AND (b.kd_blok_pemohon	= t.kd_blok)
				  AND (b.no_urut_pemohon	= t.no_urut)
				  AND (b.kd_jns_op_pemohon	= t.kd_jns_op)')
    ->where('
    b.kd_kanwil		= \''.$kd_kanwil .'\'
				  AND  b.kd_KANTOR		= \''.$kd_kantor.'\'
				  AND  b.thn_pelayanan		= \''.$thn_pelayanan.'\'
				  AND  b.bundel_pelayanan	= \''.$bundel_pelayanan.'\'
				  AND  b.no_urut_pelayanan 	= \''.$no_urut_pelayanan.'\'
				  AND  b.kd_propinsi_pemohon 	= \''.$kd_propinsi_pemohon.'\'
				  AND  b.kd_dati2_pemohon 	= \''.$kd_dati2_pemohon.'\'
				  AND  b.kd_kecamatan_pemohon   = \''.$kd_kecamatan_pemohon.'\'
				  AND  b.kd_kelurahan_pemohon   = \''.$kd_kelurahan_pemohon.'\'
				  AND  b.kd_blok_pemohon 	= \''.$kd_blok_pemohon.'\'
				  AND  b.no_urut_pemohon 	= \''.$no_urut_pemohon.'\'
				  AND  b.kd_jns_op_pemohon  	= \''.$kd_jns_op_pemohon.'\'
				  AND  t.thn_pajak_sppt 	= \''.$thn_pajak_sppt.'\'    
    ')
    ->queryRow();
        
        return $user;        
    }
    
    
}