|
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/upload/../protected/models/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
/**
* This is the model class for table "pbb.fas_dep_jpb_kls_bintang".
*
* The followings are the available columns in table 'pbb.fas_dep_jpb_kls_bintang':
* @property string $kd_propinsi
* @property string $kd_dati2
* @property string $thn_dep_jpb_kls_bintang
* @property string $kd_fasilitas
* @property string $kd_jpb
* @property string $kls_bintang
* @property double $nilai_fasilitas_kls_bintang
*/
class FasDepJpbKlsBintang extends CBhumieRecord
{
public $nm_fasilitas;
public $satuan_fasilitas;
public $status_fasilitas;
public $ketergantungan;
/**
* Returns the static model of the specified AR class.
* @param string $className active record class name.
* @return FasDepJpbKlsBintang 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.fas_dep_jpb_kls_bintang';
}
/**
* @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_dep_jpb_kls_bintang, kd_fasilitas, kd_jpb, kls_bintang, nilai_fasilitas_kls_bintang', 'required'),
array('nilai_fasilitas_kls_bintang', 'numerical'),
array('kd_propinsi, kd_dati2, kd_fasilitas, kd_jpb', 'length', 'max'=>2),
array('thn_dep_jpb_kls_bintang, kls_bintang', '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_dep_jpb_kls_bintang, kd_fasilitas, kd_jpb, kls_bintang, nilai_fasilitas_kls_bintang', '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',
'thn_dep_jpb_kls_bintang' => 'Thn Dep Jpb Kls Bintang',
'kd_fasilitas' => 'Kd Fasilitas',
'kd_jpb' => 'Kd Jpb',
'kls_bintang' => 'Kls Bintang',
'nilai_fasilitas_kls_bintang' => 'Nilai Fasilitas Kls Bintang',
);
}
/**
* 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_dep_jpb_kls_bintang',$this->thn_dep_jpb_kls_bintang,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('kd_jpb',$this->kd_jpb,true);
$criteria->compare('kls_bintang',$this->kls_bintang,true);
$criteria->compare('nilai_fasilitas_kls_bintang',$this->nilai_fasilitas_kls_bintang);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public function searchACKantor($Year)
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
if($Year == ""){
$Year = 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.thn_dep_jpb_kls_bintang, a.nilai_fasilitas_kls_bintang, a.kls_bintang, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan, a.kd_jpb,
case when (a.kd_fasilitas = \'03\' and a.kd_jpb = \'02\' and a.kls_bintang = \'3\') then b.nm_fasilitas||\' \'||\'KLAS 3 - 4\'
when (a.kd_fasilitas = \'03\' and a.kd_jpb = \'02\' and a.kls_bintang = \'1\') then b.nm_fasilitas||\' \'||\'KLAS 1 - 2\'
end nm_fasilitas';
$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=\'03\' AND a.thn_dep_jpb_kls_bintang=\''.$Year.'\'';
$criteria -> group = 'a.kd_propinsi, a.kd_dati2, a.thn_dep_jpb_kls_bintang, b.nm_fasilitas, a.kls_bintang, a.nilai_fasilitas_kls_bintang, b.satuan_fasilitas,a.kd_fasilitas,b.status_fasilitas,b.ketergantungan, a.kd_jpb';
$criteria -> order = 'b.nm_fasilitas, a.kls_bintang, a.nilai_fasilitas_kls_bintang, b.satuan_fasilitas,a.kd_fasilitas,b.status_fasilitas,b.ketergantungan';
//$criteria=new CDbCriteria;
//$criteria->select = 'distinct t.kd_propinsi, t.kd_dati2, t.thn_dep_jpb_kls_bintang, t.kd_fasilitas, t.kd_jpb, t.nilai_fasilitas_kls_bintang';
//$criteria->condition ='t.kd_propinsi=\''.$kd_propinsi.'\' AND t.kd_dati2=\''.$kd_dati2.'\' AND (t.kd_fasilitas=\'09\' OR t.kd_fasilitas=\'10\') AND t.thn_dep_jpb_kls_bintang=\''.$previousYear.'\'';
//$criteria->order='t.kd_fasilitas, t.nilai_fasilitas_kls_bintang';
$queryresult = new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
$result = array();
$curr_nilai = 0;
$i = 0;
$curr_index=$i;
//echo $queryresult->data[0]['nilai_fasilitas_kls_bintang'];
foreach($queryresult->data as $row){
if($curr_nilai!=$row['nilai_fasilitas_kls_bintang']){
$curr_nilai = $row['nilai_fasilitas_kls_bintang'];
$result[$i]['nilai_fasilitas_kls_bintang']= $row['nilai_fasilitas_kls_bintang'];
$result[$i]['nm_fasilitas']= $row['nm_fasilitas'];
$result[$i]['kd_fasilitas']= $row['kd_fasilitas'];
$result[$i]['satuan_fasilitas']= $row['satuan_fasilitas'];
$result[$i]['status_fasilitas']= $row['status_fasilitas'];
$result[$i]['ketergantungan']= $row['ketergantungan'];
$result[$i]['kd_propinsi']= $row['kd_propinsi'];
$result[$i]['kd_dati2']= $row['kd_dati2'];
$result[$i]['thn_dep_jpb_kls_bintang']= $row['thn_dep_jpb_kls_bintang'];
$result[$i]['kd_jpb']= $row['kd_jpb'];
$result[$i]['kls_bintang']= $row['kls_bintang'];
$curr_index = $i;
}else{
$result[$curr_index]['nm_fasilitas']= $result[$curr_index]['nm_fasilitas'];
}
$i++;
}
$arrayProvider = new CArrayDataProvider($result, array('keyField' =>'nilai_fasilitas_kls_bintang'));
return $arrayProvider;
}
public function searchACHotel($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.thn_dep_jpb_kls_bintang, a.nilai_fasilitas_kls_bintang, a.kls_bintang, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan, a.kd_jpb,
case when (a.kd_fasilitas = \'04\' and a.kd_jpb = \'07\' and a.kls_bintang = \'3\') then b.nm_fasilitas||\' \'||\'BINTANG 1 - 3\'
when (a.kd_fasilitas = \'04\' and a.kd_jpb = \'07\' and a.kls_bintang = \'4\') then b.nm_fasilitas||\' \'||\'BINTANG > 3\'
when (a.kd_fasilitas = \'05\' and a.kd_jpb = \'07\' and a.kls_bintang = \'3\') then b.nm_fasilitas||\' \'||\'BINTANG 1 - 3\'
when (a.kd_fasilitas = \'05\' and a.kd_jpb = \'07\' and a.kls_bintang = \'4\') then b.nm_fasilitas||\' \'||\'BINTANG > 3\'
end as nm_fasilitas';
$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 in (\'04\',\'05\') AND a.kls_bintang in (\'3\',\'4\') AND a.thn_dep_jpb_kls_bintang=\''.$previousYear.'\'';
$criteria -> group = 'a.kd_propinsi, a.kd_dati2, a.thn_dep_jpb_kls_bintang, b.nm_fasilitas, a.kls_bintang, a.nilai_fasilitas_kls_bintang, b.satuan_fasilitas,a.kd_fasilitas,b.status_fasilitas,b.ketergantungan, a.kd_jpb';
$criteria -> order = 'b.nm_fasilitas, a.kls_bintang, a.nilai_fasilitas_kls_bintang, b.satuan_fasilitas,a.kd_fasilitas,b.status_fasilitas,b.ketergantungan';
//$criteria=new CDbCriteria;
//$criteria->select = 'distinct t.kd_propinsi, t.kd_dati2, t.thn_dep_jpb_kls_bintang, t.kd_fasilitas, t.kd_jpb, t.nilai_fasilitas_kls_bintang';
//$criteria->condition ='t.kd_propinsi=\''.$kd_propinsi.'\' AND t.kd_dati2=\''.$kd_dati2.'\' AND (t.kd_fasilitas=\'09\' OR t.kd_fasilitas=\'10\') AND t.thn_dep_jpb_kls_bintang=\''.$previousYear.'\'';
//$criteria->order='t.kd_fasilitas, t.nilai_fasilitas_kls_bintang';
$queryresult = new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
$result = array();
$curr_nilai = 0;
$i = 0;
$curr_index=$i;
//echo $queryresult->data[0]['nilai_fasilitas_kls_bintang'];
foreach($queryresult->data as $row){
//if($curr_nilai!=$row['nilai_fasilitas_kls_bintang']){
$curr_nilai = $row['nilai_fasilitas_kls_bintang'];
$result[$i]['nilai_fasilitas_kls_bintang']= $row['nilai_fasilitas_kls_bintang'];
$result[$i]['nm_fasilitas']= $row['nm_fasilitas'];
$result[$i]['kd_fasilitas']= $row['kd_fasilitas'];
$result[$i]['satuan_fasilitas']= $row['satuan_fasilitas'];
$result[$i]['status_fasilitas']= $row['status_fasilitas'];
$result[$i]['ketergantungan']= $row['ketergantungan'];
$result[$i]['kd_propinsi']= $row['kd_propinsi'];
$result[$i]['kd_dati2']= $row['kd_dati2'];
$result[$i]['kd_jpb']= $row['kd_jpb'];
$result[$i]['thn_dep_jpb_kls_bintang']= $row['thn_dep_jpb_kls_bintang'];
$result[$i]['kls_bintang']= $row['kls_bintang'];
$curr_index = $i;
//}else{
// $result[$curr_index]['nm_fasilitas']= $result[$curr_index]['nm_fasilitas'];
//}
$i++;
}
$arrayProvider = new CArrayDataProvider($result, array('keyField' =>'nilai_fasilitas_kls_bintang'));
return $arrayProvider;
}
public function searchACPertokoan($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.thn_dep_jpb_kls_bintang, a.nilai_fasilitas_kls_bintang, a.kls_bintang, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan, a.kd_jpb,
case when (a.kd_fasilitas = \'06\' and a.kd_jpb = \'04\' and a.kls_bintang = \'1\') then b.nm_fasilitas||\' \'||\'KLAS 1\'
when (a.kd_fasilitas = \'06\' and a.kd_jpb = \'04\' and a.kls_bintang = \'2\') then b.nm_fasilitas||\' \'||\'KLAS 2\'
when (a.kd_fasilitas = \'06\' and a.kd_jpb = \'04\' and a.kls_bintang = \'3\') then b.nm_fasilitas||\' \'||\'KLAS 3\'
end as nm_fasilitas';
$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=\'06\' AND a.kd_jpb=\'04\' AND a.kls_bintang in (\'1\', \'2\', \'3\') AND a.thn_dep_jpb_kls_bintang=\''.$previousYear.'\'';
$criteria -> group = 'a.kd_propinsi, a.kd_dati2, a.thn_dep_jpb_kls_bintang, b.nm_fasilitas, a.kls_bintang, a.nilai_fasilitas_kls_bintang, b.satuan_fasilitas,a.kd_fasilitas,b.status_fasilitas,b.ketergantungan, a.kd_jpb';
$criteria -> order = 'b.nm_fasilitas, a.kls_bintang, a.nilai_fasilitas_kls_bintang, b.satuan_fasilitas,a.kd_fasilitas,b.status_fasilitas,b.ketergantungan';
//$criteria=new CDbCriteria;
//$criteria->select = 'distinct t.kd_propinsi, t.kd_dati2, t.thn_dep_jpb_kls_bintang, t.kd_fasilitas, t.kd_jpb, t.nilai_fasilitas_kls_bintang';
//$criteria->condition ='t.kd_propinsi=\''.$kd_propinsi.'\' AND t.kd_dati2=\''.$kd_dati2.'\' AND (t.kd_fasilitas=\'09\' OR t.kd_fasilitas=\'10\') AND t.thn_dep_jpb_kls_bintang=\''.$previousYear.'\'';
//$criteria->order='t.kd_fasilitas, t.nilai_fasilitas_kls_bintang';
$queryresult = new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
$result = array();
$curr_nilai = 0;
$i = 0;
$curr_index=$i;
//echo $queryresult->data[0]['nilai_fasilitas_kls_bintang'];
foreach($queryresult->data as $row){
if($curr_nilai!=$row['kls_bintang']){
$curr_nilai = $row['kls_bintang'];
$result[$i]['nilai_fasilitas_kls_bintang']= $row['nilai_fasilitas_kls_bintang'];
$result[$i]['nm_fasilitas']= $row['nm_fasilitas'];
$result[$i]['kd_fasilitas']= $row['kd_fasilitas'];
$result[$i]['satuan_fasilitas']= $row['satuan_fasilitas'];
$result[$i]['status_fasilitas']= $row['status_fasilitas'];
$result[$i]['ketergantungan']= $row['ketergantungan'];
$result[$i]['kd_propinsi']= $row['kd_propinsi'];
$result[$i]['kd_dati2']= $row['kd_dati2'];
$result[$i]['kd_jpb']= $row['kd_jpb'];
$result[$i]['thn_dep_jpb_kls_bintang']= $row['thn_dep_jpb_kls_bintang'];
$result[$i]['kls_bintang']= $row['kls_bintang'];
$curr_index = $i;
}else{
$result[$curr_index]['nm_fasilitas']= $result[$curr_index]['nm_fasilitas'];
}
$i++;
}
$arrayProvider = new CArrayDataProvider($result, array('keyField' =>'nilai_fasilitas_kls_bintang'));
return $arrayProvider;
}
public function searchACRumahSakit($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.thn_dep_jpb_kls_bintang, a.nilai_fasilitas_kls_bintang, a.kls_bintang, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan, a.kd_jpb,
case when (a.kd_fasilitas=\'07\' AND a.kd_jpb=\'05\' AND a.kls_bintang=\'1\') then b.nm_fasilitas||\' \'||\'KLAS 1 - 2\'
when (a.kd_fasilitas=\'07\' AND a.kd_jpb=\'05\' AND a.kls_bintang=\'3\') then b.nm_fasilitas||\' \'||\'KLAS 3\'
when (a.kd_fasilitas=\'08\' AND a.kd_jpb=\'05\' AND a.kls_bintang=\'1\') then b.nm_fasilitas
end nm_fasilitas';
$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=\'07\' AND a.kd_jpb=\'05\' AND a.kls_bintang IN (\'1\',\'3\')) OR (a.kd_fasilitas=\'08\' AND a.kd_jpb=\'05\' AND a.kls_bintang=\'1\')) AND a.thn_dep_jpb_kls_bintang=\''.$previousYear.'\'';
$criteria -> group = 'a.kd_propinsi, a.kd_dati2, a.thn_dep_jpb_kls_bintang, b.nm_fasilitas, a.kls_bintang, a.nilai_fasilitas_kls_bintang, b.satuan_fasilitas,a.kd_fasilitas,b.status_fasilitas,b.ketergantungan, a.kd_jpb';
$criteria -> order = 'b.nm_fasilitas, a.kls_bintang, a.nilai_fasilitas_kls_bintang, b.satuan_fasilitas,a.kd_fasilitas,b.status_fasilitas,b.ketergantungan';
//$criteria=new CDbCriteria;
//$criteria->select = 'distinct t.kd_propinsi, t.kd_dati2, t.thn_dep_jpb_kls_bintang, t.kd_fasilitas, t.kd_jpb, t.nilai_fasilitas_kls_bintang';
//$criteria->condition ='t.kd_propinsi=\''.$kd_propinsi.'\' AND t.kd_dati2=\''.$kd_dati2.'\' AND (t.kd_fasilitas=\'09\' OR t.kd_fasilitas=\'10\') AND t.thn_dep_jpb_kls_bintang=\''.$previousYear.'\'';
//$criteria->order='t.kd_fasilitas, t.nilai_fasilitas_kls_bintang';
$queryresult = new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
$result = array();
$curr_nilai = 0;
$i = 0;
$curr_index=$i;
//echo $queryresult->data[0]['nilai_fasilitas_kls_bintang'];
foreach($queryresult->data as $row){
if($curr_nilai!=$row['nilai_fasilitas_kls_bintang']){
$curr_nilai = $row['nilai_fasilitas_kls_bintang'];
$result[$i]['nilai_fasilitas_kls_bintang']= $row['nilai_fasilitas_kls_bintang'];
$result[$i]['nm_fasilitas']= $row['nm_fasilitas'];
$result[$i]['kd_fasilitas']= $row['kd_fasilitas'];
$result[$i]['satuan_fasilitas']= $row['satuan_fasilitas'];
$result[$i]['status_fasilitas']= $row['status_fasilitas'];
$result[$i]['ketergantungan']= $row['ketergantungan'];
$result[$i]['kd_propinsi']= $row['kd_propinsi'];
$result[$i]['kd_dati2']= $row['kd_dati2'];
$result[$i]['kd_jpb']= $row['kd_jpb'];
$result[$i]['thn_dep_jpb_kls_bintang']= $row['thn_dep_jpb_kls_bintang'];
$result[$i]['kls_bintang']= $row['kls_bintang'];
$curr_index = $i;
}else{
$result[$curr_index]['nm_fasilitas']= $result[$curr_index]['nm_fasilitas'];
}
$i++;
}
$arrayProvider = new CArrayDataProvider($result, array('keyField' =>'nilai_fasilitas_kls_bintang'));
return $arrayProvider;
}
public function searchACApartemen($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.thn_dep_jpb_kls_bintang, a.nilai_fasilitas_kls_bintang, a.kls_bintang, b.nm_fasilitas, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan, a.kd_jpb,
case when (a.kd_fasilitas = \'09\' AND a.kd_jpb = \'13\' AND a.kls_bintang = \'1\') then b.nm_fasilitas||\' \'||\'KLAS 1 - 2\'
when (a.kd_fasilitas = \'10\' AND a.kd_jpb = \'13\' AND a.kls_bintang = \'1\') then b.nm_fasilitas
end nm_fasilitas';
$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=\'09\' OR a.kd_fasilitas=\'10\') AND a.thn_dep_jpb_kls_bintang=\''.$previousYear.'\'';
$criteria -> group = 'a.kd_propinsi, a.kd_dati2, a.thn_dep_jpb_kls_bintang, b.nm_fasilitas, a.kls_bintang, a.nilai_fasilitas_kls_bintang, b.satuan_fasilitas,a.kd_fasilitas,b.status_fasilitas,b.ketergantungan, a.kd_jpb';
$criteria -> order = 'b.nm_fasilitas, a.kls_bintang, a.nilai_fasilitas_kls_bintang, b.satuan_fasilitas,a.kd_fasilitas,b.status_fasilitas,b.ketergantungan';
//$criteria=new CDbCriteria;
//$criteria->select = 'distinct t.kd_propinsi, t.kd_dati2, t.thn_dep_jpb_kls_bintang, t.kd_fasilitas, t.kd_jpb, t.nilai_fasilitas_kls_bintang';
//$criteria->condition ='t.kd_propinsi=\''.$kd_propinsi.'\' AND t.kd_dati2=\''.$kd_dati2.'\' AND (t.kd_fasilitas=\'09\' OR t.kd_fasilitas=\'10\') AND t.thn_dep_jpb_kls_bintang=\''.$previousYear.'\'';
//$criteria->order='t.kd_fasilitas, t.nilai_fasilitas_kls_bintang';
$queryresult = new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
$result = array();
$curr_nilai = 0;
$i = 0;
$curr_index=$i;
//echo $queryresult->data[0]['nilai_fasilitas_kls_bintang'];
foreach($queryresult->data as $row){
if($curr_nilai!=$row['nilai_fasilitas_kls_bintang']){
$curr_nilai = $row['nilai_fasilitas_kls_bintang'];
$result[$i]['nilai_fasilitas_kls_bintang']= $row['nilai_fasilitas_kls_bintang'];
$result[$i]['nm_fasilitas']= $row['nm_fasilitas'];
$result[$i]['kd_fasilitas']= $row['kd_fasilitas'];
$result[$i]['satuan_fasilitas']= $row['satuan_fasilitas'];
$result[$i]['status_fasilitas']= $row['status_fasilitas'];
$result[$i]['ketergantungan']= $row['ketergantungan'];
$result[$i]['kd_propinsi']= $row['kd_propinsi'];
$result[$i]['kd_dati2']= $row['kd_dati2'];
$result[$i]['kd_jpb']= $row['kd_jpb'];
$result[$i]['thn_dep_jpb_kls_bintang']= $row['thn_dep_jpb_kls_bintang'];
$result[$i]['kls_bintang']= $row['kls_bintang'];
$curr_index = $i;
}else{
$result[$curr_index]['nm_fasilitas']= $result[$curr_index]['nm_fasilitas'];
}
$i++;
}
$arrayProvider = new CArrayDataProvider($result, array('keyField' =>'nilai_fasilitas_kls_bintang'));
return $arrayProvider;
}
public function searchBoilerHotel($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.thn_dep_jpb_kls_bintang, a.nilai_fasilitas_kls_bintang, a.kls_bintang, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan, a.kd_jpb,
case when (a.kd_fasilitas = \'43\' AND a.kd_jpb = \'07\' AND a.kls_bintang = \'2\') then b.nm_fasilitas||\' \'||\'4 - 5\'
when (a.kd_fasilitas = \'43\' AND a.kd_jpb = \'07\' AND a.kls_bintang = \'4\') then b.nm_fasilitas||\' \'||\'< 4\'
when (a.kd_fasilitas = \'43\' AND a.kd_jpb = \'07\' AND a.kls_bintang = \'5\') then b.nm_fasilitas||\' \'||\'NON BINTANG\'
end nm_fasilitas';
$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=\'43\' AND a.kd_jpb=\'07\' AND a.kls_bintang in (\'5\',\'4\',\'2\') AND a.thn_dep_jpb_kls_bintang=\''.$previousYear.'\'';
$criteria -> group = 'a.kd_propinsi, a.kd_dati2, a.thn_dep_jpb_kls_bintang, b.nm_fasilitas, a.kls_bintang, a.nilai_fasilitas_kls_bintang, b.satuan_fasilitas,a.kd_fasilitas,b.status_fasilitas,b.ketergantungan, a.kd_jpb';
$criteria -> order = 'a.kd_propinsi, a.kd_dati2, a.thn_dep_jpb_kls_bintang, a.kls_bintang, a.kd_fasilitas, a.kd_jpb';
//$criteria=new CDbCriteria;
//$criteria->select = 'distinct t.kd_propinsi, t.kd_dati2, t.thn_dep_jpb_kls_bintang, t.kd_fasilitas, t.kd_jpb, t.nilai_fasilitas_kls_bintang';
//$criteria->condition ='t.kd_propinsi=\''.$kd_propinsi.'\' AND t.kd_dati2=\''.$kd_dati2.'\' AND (t.kd_fasilitas=\'09\' OR t.kd_fasilitas=\'10\') AND t.thn_dep_jpb_kls_bintang=\''.$previousYear.'\'';
//$criteria->order='t.kd_fasilitas, t.nilai_fasilitas_kls_bintang';
// return new CActiveDataProvider($this, array(
// 'criteria'=>$criteria,
// ));
$queryresult = new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
$result = array();
$curr_nilai = 0;
$i = 0;
$curr_index=$i;
//echo $queryresult->data[0]['nilai_fasilitas_kls_bintang'];
foreach($queryresult->data as $row){
//if($curr_nilai!=$row['nilai_fasilitas_kls_bintang']){
$curr_nilai = $row['nilai_fasilitas_kls_bintang'];
$result[$i]['nilai_fasilitas_kls_bintang']= $row['nilai_fasilitas_kls_bintang'];
$result[$i]['nm_fasilitas']= $row['nm_fasilitas'];
$result[$i]['kd_fasilitas']= $row['kd_fasilitas'];
$result[$i]['satuan_fasilitas']= $row['satuan_fasilitas'];
$result[$i]['status_fasilitas']= $row['status_fasilitas'];
$result[$i]['ketergantungan']= $row['ketergantungan'];
$result[$i]['kd_propinsi']= $row['kd_propinsi'];
$result[$i]['kd_dati2']= $row['kd_dati2'];
$result[$i]['kd_jpb']= $row['kd_jpb'];
$result[$i]['thn_dep_jpb_kls_bintang']= $row['thn_dep_jpb_kls_bintang'];
$result[$i]['kls_bintang']= $row['kls_bintang'];
$curr_index = $i;
//}else{
// $result[$curr_index]['nm_fasilitas']= $result[$curr_index]['nm_fasilitas'];
//}
$i++;
}
$arrayProvider = new CArrayDataProvider($result, array('keyField' =>'nilai_fasilitas_kls_bintang'));
return $arrayProvider;
}
public function searchBoilerApartmen($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.thn_dep_jpb_kls_bintang, a.nilai_fasilitas_kls_bintang, a.kls_bintang, a.kd_fasilitas, b.satuan_fasilitas,b.status_fasilitas,b.ketergantungan, a.kd_jpb,
case when (a.kd_fasilitas = \'45\' AND a.kd_jpb = \'13\' AND a.kls_bintang = \'1\') then b.nm_fasilitas||\' \'||\'KLAS 1 - 2\'
when (a.kd_fasilitas = \'45\' AND a.kd_jpb = \'13\' AND a.kls_bintang = \'3\') then b.nm_fasilitas||\' \'||\'KLAS 3\'
end nm_fasilitas';
$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=\'45\' AND a.kd_jpb=\'13\' AND a.kls_bintang in (\'1\',\'3\') AND a.thn_dep_jpb_kls_bintang=\''.$previousYear.'\'';
$criteria -> group = 'a.kd_propinsi, a.kd_dati2, a.thn_dep_jpb_kls_bintang, b.nm_fasilitas, a.kls_bintang, a.nilai_fasilitas_kls_bintang, b.satuan_fasilitas,a.kd_fasilitas,b.status_fasilitas,b.ketergantungan, a.kd_jpb';
$criteria -> order = 'a.kd_propinsi, a.kd_dati2, a.thn_dep_jpb_kls_bintang, a.kd_fasilitas, a.kd_jpb, a.kls_bintang';
//$criteria=new CDbCriteria;
//$criteria->select = 'distinct t.kd_propinsi, t.kd_dati2, t.thn_dep_jpb_kls_bintang, t.kd_fasilitas, t.kd_jpb, t.nilai_fasilitas_kls_bintang';
//$criteria->condition ='t.kd_propinsi=\''.$kd_propinsi.'\' AND t.kd_dati2=\''.$kd_dati2.'\' AND (t.kd_fasilitas=\'09\' OR t.kd_fasilitas=\'10\') AND t.thn_dep_jpb_kls_bintang=\''.$previousYear.'\'';
//$criteria->order='t.kd_fasilitas, t.nilai_fasilitas_kls_bintang';
// return new CActiveDataProvider($this, array(
// 'criteria'=>$criteria,
// ));
$queryresult = new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
$result = array();
$curr_nilai = 0;
$i = 0;
$curr_index=$i;
//echo $queryresult->data[0]['nilai_fasilitas_kls_bintang'];
foreach($queryresult->data as $row){
if($curr_nilai!=$row['nilai_fasilitas_kls_bintang']){
$curr_nilai = $row['nilai_fasilitas_kls_bintang'];
$result[$i]['nilai_fasilitas_kls_bintang']= $row['nilai_fasilitas_kls_bintang'];
$result[$i]['nm_fasilitas']= $row['nm_fasilitas'];
$result[$i]['kd_fasilitas']= $row['kd_fasilitas'];
$result[$i]['satuan_fasilitas']= $row['satuan_fasilitas'];
$result[$i]['status_fasilitas']= $row['status_fasilitas'];
$result[$i]['ketergantungan']= $row['ketergantungan'];
$result[$i]['kd_propinsi']= $row['kd_propinsi'];
$result[$i]['kd_dati2']= $row['kd_dati2'];
$result[$i]['kd_jpb']= $row['kd_jpb'];
$result[$i]['thn_dep_jpb_kls_bintang']= $row['thn_dep_jpb_kls_bintang'];
$result[$i]['kls_bintang']= $row['kls_bintang'];
$curr_index = $i;
}else{
$result[$curr_index]['nm_fasilitas']= $result[$curr_index]['nm_fasilitas'];
}
$i++;
}
$arrayProvider = new CArrayDataProvider($result, array('keyField' =>'nilai_fasilitas_kls_bintang'));
return $arrayProvider;
}
public function countNIR($kd_propinsi, $kd_dati2, $tahunPajak)
{
$qryCount = 'SELECT count(*) FROM pbb.dat_nir WHERE kd_propinsi=\''.$kd_propinsi.'\' AND kd_dati2=\''.$kd_dati2.'\' AND thn_nir_znt=\''.$tahunPajak.'\'';
$currentData = Yii::app()->db->createCommand($qryCount)->queryAll();
return $currentData[0]['count'];
}
}