|
Server IP : 127.0.0.1 / Your IP : 127.0.0.1 Web Server : Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.6.3 System : Windows NT WIN-R7LTCC7BPLI 6.3 build 9200 (Windows Server 2012 R2 Datacenter Edition) i586 User : GerbangSIPAD ( 0) PHP Version : 5.6.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF Directory (0777) : C:/xampp5/htdocs/bhumie/protected/models/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
/**
* This is the model class for table "pbb.fas_non_dep".
*
* The followings are the available columns in table 'pbb.fas_non_dep':
* @property string $kd_propinsi
* @property string $kd_dati2
* @property string $thn_non_dep
* @property string $kd_fasilitas
* @property double $nilai_non_dep
*/
class FasNonDep extends CBhumieRecord
{
/**
* Returns the static model of the specified AR class.
* @param string $className active record class name.
* @return FasNonDep the static model class
*/
public $nm_fasilitas;
public $satuan_fasilitas;
public $status_fasilitas;
public $ketergantungan;
public static function model($className=__CLASS__)
{
return parent::model($className);
}
/**
* @return string the associated database table name
*/
public function tableName()
{
return 'pbb.fas_non_dep';
}
/**
* @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, thn_non_dep, kd_fasilitas, nilai_non_dep', 'required'),
array('nilai_non_dep', 'numerical'),
array('kd_propinsi, kd_dati2, kd_fasilitas', 'length', 'max'=>2),
array('thn_non_dep', 'length', 'max'=>4),
// The following rule is used by search().
// Please remove those attributes that should not be searched.
array('kd_propinsi, kd_dati2, thn_non_dep, kd_fasilitas, nilai_non_dep', '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(
//'fasilitas' => array(self::HAS_MANY, 'Fasilitas', 'kd_fasilitas'),
);
}
/**
* @return array customized attribute labels (name=>label)
*/
public function attributeLabels()
{
return array(
'kd_propinsi' => 'Kd Propinsi',
'kd_dati2' => 'Kd Dati2',
'thn_non_dep' => 'Thn Non Dep',
'kd_fasilitas' => 'Kode',
'nilai_non_dep' => 'Nilai Baru',
);
}
/**
* 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 searchACSplit($previousYear)
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
if($previousYear == ""){
$previousYear = date('Y')-1;
}
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, a.thn_non_dep, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'01\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
/*$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);*/
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchACWindows($Year)
{
// 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->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, a.thn_non_dep, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan, a.kd_propinsi, a.kd_dati2';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'02\' AND a.thn_non_dep=\''.$Year.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchACBangunanLain($previousYear)
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
if($previousYear == ""){
$previousYear = date('Y');
}
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, a.thn_non_dep, b.satuan_fasilitas, b.status_fasilitas, b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'11\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
/*$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);*/
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchPerkerasan($previousYear)
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
if($previousYear == ""){
$previousYear = date('Y');
}
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, a.thn_non_dep, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND (a.kd_fasilitas=\'14\' OR a.kd_fasilitas=\'15\' OR a.kd_fasilitas=\'16\' OR a.kd_fasilitas=\'17\') AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria-> group = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, a.kd_fasilitas, a.thn_non_dep, b.nm_fasilitas, b.satuan_fasilitas, b.status_fasilitas, b.ketergantungan';
$criteria->order='a.kd_fasilitas, a.nilai_non_dep, a.kd_fasilitas, b.nm_fasilitas, b.satuan_fasilitas, b.status_fasilitas, b.ketergantungan';
/*$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);*/
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchLapTenis($previousYear)
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
if($previousYear == ""){
$previousYear = date('Y');
}
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, a.thn_non_dep, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND (a.kd_fasilitas=\'18\' OR a.kd_fasilitas=\'19\' OR a.kd_fasilitas=\'20\' OR a.kd_fasilitas=\'21\' OR a.kd_fasilitas=\'22\' OR a.kd_fasilitas=\'23\' OR a.kd_fasilitas=\'24\' OR a.kd_fasilitas=\'25\' OR a.kd_fasilitas=\'26\' OR a.kd_fasilitas=\'27\' OR a.kd_fasilitas=\'28\' OR a.kd_fasilitas=\'29\') AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria-> group = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, a.kd_fasilitas, a.thn_non_dep, b.nm_fasilitas, b.satuan_fasilitas, b.status_fasilitas, b.ketergantungan';
$criteria->order='a.kd_fasilitas';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'pagination'=>false,
'criteria'=>$criteria,
));
}
public function searchTanggaBerjalan($previousYear) {
// Warning: Please modify the following code to remove attributes that
// should not be searched.
if($previousYear == ""){
$previousYear = date('Y');
}
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, a.thn_non_dep, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND (a.kd_fasilitas=\'33\' OR a.kd_fasilitas=\'34\') AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria-> group = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, a.kd_fasilitas, a.thn_non_dep, b.nm_fasilitas, b.satuan_fasilitas, b.status_fasilitas, b.ketergantungan';
$criteria->order='a.kd_fasilitas';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchPagar($previousYear) {
// Warning: Please modify the following code to remove attributes that
// should not be searched.
if($previousYear == ""){
$previousYear = date('Y');
}
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, a.thn_non_dep, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND (a.kd_fasilitas=\'35\' OR a.kd_fasilitas=\'36\') AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria-> group = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, a.kd_fasilitas, a.thn_non_dep, b.nm_fasilitas, b.satuan_fasilitas, b.status_fasilitas, b.ketergantungan';
$criteria->order='a.kd_fasilitas';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchProteksiApi($previousYear) {
// Warning: Please modify the following code to remove attributes that
// should not be searched.
if($previousYear == ""){
$previousYear = date('Y');
}
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, a.thn_non_dep, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND (a.kd_fasilitas=\'37\' OR a.kd_fasilitas=\'38\' OR a.kd_fasilitas=\'39\') AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria-> group = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, a.kd_fasilitas, a.thn_non_dep, b.nm_fasilitas, b.satuan_fasilitas, b.status_fasilitas, b.ketergantungan';
$criteria->order='a.kd_fasilitas';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchSumurArtesis($previousYear) {
// Warning: Please modify the following code to remove attributes that
// should not be searched.
if($previousYear == ""){
$previousYear = date('Y');
}
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, a.thn_non_dep, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'42\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria-> group = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, a.kd_fasilitas, a.thn_non_dep, b.nm_fasilitas, b.satuan_fasilitas, b.status_fasilitas, b.ketergantungan';
$criteria->order='a.kd_fasilitas';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchListrik($previousYear) {
// Warning: Please modify the following code to remove attributes that
// should not be searched.
if($previousYear == ""){
$previousYear = date('Y');
}
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, a.thn_non_dep, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'44\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria-> group = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, a.kd_fasilitas, a.thn_non_dep, b.nm_fasilitas, b.satuan_fasilitas, b.status_fasilitas, b.ketergantungan';
$criteria->order='a.kd_fasilitas';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchPABX($previousYear) {
// Warning: Please modify the following code to remove attributes that
// should not be searched.
if($previousYear == ""){
$previousYear = date('Y');
}
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, a.thn_non_dep, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'41\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria-> group = 'a.kd_propinsi, a.kd_dati2, a.nilai_non_dep, a.kd_fasilitas, a.thn_non_dep, b.nm_fasilitas, b.satuan_fasilitas, b.status_fasilitas, b.ketergantungan';
$criteria->order='a.kd_fasilitas';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
/**
* 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('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function countDBKBStandard($kd_propinsi, $kd_dati2, $tahunPajak) {
$qryCount = 'SELECT count(*) FROM pbb.dbkb_standard WHERE kd_propinsi=\''.$kd_propinsi.'\' AND kd_dati2=\''.$kd_dati2.'\' AND thn_dbkb_standard=\''.$tahunPajak.'\'';
$currentData = Yii::app()->db->createCommand($qryCount)->queryAll();
return $currentData[0]['count'];
}
public function ambilMaxTahun($namaTable, $kolomTahun) {
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$qryAmbilMaxTahun= 'SELECT max('.$kolomTahun.') FROM '.$namaTable.' WHERE kd_propinsi = \''.$kd_propinsi.'\' AND kd_dati2 = \''.$kd_dati2.'\';';
$tahunMax = Yii::app()->db->createCommand($qryAmbilMaxTahun)->queryAll();
return $tahunMax[0]['max'];
}
/* public function searchLapTenisBetonDenganLampu()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'18\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchLapTenisAspalDenganLampu()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'19\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchLapTenisTanahLiatDenganLampu()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'20\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchLapTenisBetonTanpaLampu()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'21\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchLapTenisAspalTanpaLampu()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'22\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchLapTenisTanahLiatTanpaLampu()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'23\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchLapTenisLebihBetonDenganLampu()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'24\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchLapTenisLebihAspalDenganLampu()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'25\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchLapTenisLebihTanahLiatDenganLampu()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'26\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchLapTenisLebihBetonTanpaLampu()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'27\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchLapTenisLebihAspalTanpaLampu()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'28\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchLapTenisLebihTanahLiatTanpaLampu()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'29\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
*/
/* public function searchPerkerasanKonstruksiSedang()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'15\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchPerkerasanKonstruksiBerat()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'16\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchPenutupPerkerasan()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$previousYear = date('Y')-1;
$kd_propinsi = Yii::app()->globalvar->getKodePropinsi();
$kd_dati2 = Yii::app()->globalvar->getKodeDati2();
$criteria=new CDbCriteria;
$criteria->alias = 'a';
$criteria->select = 'a.nilai_non_dep, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan';
$criteria->join = 'inner join pbb.fasilitas b on a.kd_fasilitas = b.kd_fasilitas';
$criteria->condition='a.kd_propinsi=\''.$kd_propinsi.'\' AND a.kd_dati2=\''.$kd_dati2.'\' AND a.kd_fasilitas=\'17\' AND a.thn_non_dep=\''.$previousYear.'\'';
$criteria->order='a.thn_non_dep';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_non_dep',$this->thn_non_dep,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_non_dep',$this->nilai_non_dep);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
*/
}