<?php

/**
 * This is the model class for table "pbb.dat_nir".
 *
 * The followings are the available columns in table 'pbb.dat_nir':
 * @property string $kd_propinsi
 * @property string $kd_dati2
 * @property string $kd_kecamatan
 * @property string $kd_kelurahan
 * @property string $kd_znt
 * @property string $thn_nir_znt
 * @property string $kd_kanwil
 * @property string $kd_kantor
 * @property string $jns_dokumen
 * @property string $no_dokumen
 * @property double $nir
 */
class DatNir extends CBhumieRecord
{
	public $tgl_pemeriksaan;
	public $no_pemeriksa;
	/**
	 * Returns the static model of the specified AR class.
	 * @param string $className active record class name.
	 * @return DatNir the static model class
	 */
	public static function model($className=__CLASS__)
	{
		return parent::model($className);
	}

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

	/**
	 * @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_znt, thn_nir_znt, kd_kanwil, kd_kantor, jns_dokumen, no_dokumen, nir', 'required'),
			array('nir', 'numerical'),
			array('kd_propinsi, kd_dati2, kd_znt, kd_kanwil, kd_kantor', 'length', 'max'=>2),
			array('kd_kecamatan, kd_kelurahan', 'length', 'max'=>3),
			array('thn_nir_znt', 'length', 'max'=>4),
			array('jns_dokumen', 'length', 'max'=>1),
			array('no_dokumen', 'length', 'max'=>11),
			// 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_znt, thn_nir_znt, kd_kanwil, kd_kantor, jns_dokumen, no_dokumen, nir', '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_znt' => 'Kd Znt',
			'thn_nir_znt' => 'Thn Nir Znt',
			'kd_kanwil' => 'Kd Kanwil',
			'kd_kantor' => 'Kd Kantor',
			'jns_dokumen' => 'Jns Dokumen',
			'no_dokumen' => 'No Dokumen',
			'nir' => 'Nir',
			'tgl_pemeriksaan' => 'Tanggal Pemeriksaan',
			'no_pemeriksa' => 'No Pemeriksa',
		);
	}

	/**
	 * 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.
		$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
		$kd_dati2 = Yii::app()->globalvar->getKodeDati2();	

		$criteria=new CDbCriteria;
		$criteria->select = 't.kd_propinsi, t.kd_dati2, t.kd_kecamatan, t.kd_kelurahan, t.thn_nir_znt, t.no_dokumen, t.kd_znt, t.nir, pbb.dokumen.tgl_pendataan_dok, pbb.dokumen.nip_pendata_dok, pbb.dokumen.tgl_pemeriksaan_dok, pbb.dokumen.nip_pemeriksa_dok';
		$criteria->condition='t.kd_propinsi=\''.$kd_propinsi.'\' AND t.kd_dati2=\''.$kd_dati2.'\'';
		$criteria->join = 'left join pbb.dokumen on t.no_dokumen=pbb.dokumen.no_dokumen';
		$criteria->order='t.thn_nir_znt DESC';

		$criteria->compare('t.kd_propinsi',$this->kd_propinsi,true);
		$criteria->compare('t.kd_dati2',$this->kd_dati2,true);
		$criteria->compare('t.kd_kecamatan',$this->kd_kecamatan,true);
		$criteria->compare('t.kd_kelurahan',$this->kd_kelurahan,true);
		$criteria->compare('t.kd_znt',$this->kd_znt,true);
		$criteria->compare('t.thn_nir_znt',$this->thn_nir_znt,true);
		$criteria->compare('t.kd_kanwil',$this->kd_kanwil,true);
		$criteria->compare('t.kd_kantor',$this->kd_kantor,true);
		$criteria->compare('t.jns_dokumen',$this->jns_dokumen,true);
		$criteria->compare('t.no_dokumen',$this->no_dokumen,true);
		$criteria->compare('t.nir',$this->nir);

		return new CActiveDataProvider($this, array(
			'criteria'=>$criteria,
			//'sort'=>array("defaultOrder"=>"t.thn_nir_znt DESC")
		));
	}
        	
}