|
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_min_max".
*
* The followings are the available columns in table 'pbb.fas_dep_min_max':
* @property string $kd_propinsi
* @property string $kd_dati2
* @property string $thn_dep_min_max
* @property string $kd_fasilitas
* @property integer $kls_dep_min
* @property integer $kls_dep_max
* @property double $nilai_dep_min_max
* @property integer $createdby
* @property string $createdtime
* @property integer $updatedby
* @property string $updatedtime
*/
class FasDepMinMax 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 FasDepMinMax 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_min_max';
}
/**
* @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_min_max, kd_fasilitas, kls_dep_min, kls_dep_max, nilai_dep_min_max, createdby, createdtime, updatedby, updatedtime', 'required'),
array('kls_dep_min, kls_dep_max, createdby, updatedby', 'numerical', 'integerOnly'=>true),
array('nilai_dep_min_max', 'numerical'),
array('kd_propinsi, kd_dati2, kd_fasilitas', 'length', 'max'=>2),
array('thn_dep_min_max', '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_min_max, kd_fasilitas, kls_dep_min, kls_dep_max, nilai_dep_min_max, 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',
'thn_dep_min_max' => 'Thn Dep Min Max',
'kd_fasilitas' => 'Kd Fasilitas',
'kls_dep_min' => 'Kls Dep Min',
'kls_dep_max' => 'Kls Dep Max',
'nilai_dep_min_max' => 'Nilai Dep Min Max',
'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('thn_dep_min_max',$this->thn_dep_min_max,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('kls_dep_min',$this->kls_dep_min);
$criteria->compare('kls_dep_max',$this->kls_dep_max);
$criteria->compare('nilai_dep_min_max',$this->nilai_dep_min_max);
$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 searchKolamRenang($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_dep_min_max, a.kd_fasilitas, b.satuan_fasilitas, b.status_fasilitas, b.ketergantungan, a.kls_dep_min, a.kls_dep_max, a.thn_dep_min_max,
case when (a.kd_fasilitas = \'12\' and a.kls_dep_min = \'0\' and a.kls_dep_max = \'50\') then b.nm_fasilitas||\' \'||\'Luas < 51\'
when (a.kd_fasilitas = \'12\' and a.kls_dep_min = \'51\' and a.kls_dep_max = \'100\') then b.nm_fasilitas||\' \'||\'Luas 50 - 100\'
when (a.kd_fasilitas = \'12\' and a.kls_dep_min = \'101\' and a.kls_dep_max = \'200\') then b.nm_fasilitas||\' \'||\'Luas 100 - 200\'
when (a.kd_fasilitas = \'12\' and a.kls_dep_min = \'201\' and a.kls_dep_max = \'400\') then b.nm_fasilitas||\' \'||\'Luas 200 - 400\'
when (a.kd_fasilitas = \'12\' and a.kls_dep_min > \'400\') then b.nm_fasilitas||\' \'||\'Luas > 400\'
when (a.kd_fasilitas = \'13\' and a.kls_dep_min = \'0\' and a.kls_dep_max = \'50\') then b.nm_fasilitas||\' \'||\'Luas < 51\'
when (a.kd_fasilitas = \'13\' and a.kls_dep_min = \'51\' and a.kls_dep_max = \'100\') then b.nm_fasilitas||\' \'||\'Luas 50 - 100\'
when (a.kd_fasilitas = \'13\' and a.kls_dep_min = \'101\' and a.kls_dep_max = \'200\') then b.nm_fasilitas||\' \'||\'Luas 100 - 200\'
when (a.kd_fasilitas = \'13\' and a.kls_dep_min = \'201\' and a.kls_dep_max = \'400\') then b.nm_fasilitas||\' \'||\'Luas 200 - 400\'
when (a.kd_fasilitas = \'13\' and a.kls_dep_min > \'400\') then b.nm_fasilitas||\' \'||\'Luas > 400\'
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 in(\'12\',\'13\') AND a.thn_dep_min_max=\''.$previousYear.'\'';
$criteria->order='a.kd_propinsi, a.kd_dati2, a.thn_dep_min_max, a.kd_fasilitas, a.kls_dep_min';
// return new CActiveDataProvider($this, array(
// 'criteria'=>$criteria,
// ));
/*$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_dep_min_max',$this->thn_dep_min_max,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_dep_min_max',$this->nilai_dep_min_max);*/
$queryresult = new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
$result = array();
$curr_nilai = 2;
$i = 0;
$curr_index=$i;
//echo $queryresult->data[0]['nilai_fasilitas_kls_bintang'];
foreach($queryresult->data as $row){
if($curr_nilai!=$row['kls_dep_min']){
$curr_nilai = $row['kls_dep_min'];
$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]['kls_dep_min']= $row['kls_dep_min'];
$result[$i]['kls_dep_max']= $row['kls_dep_max'];
$result[$i]['kd_propinsi']= $row['kd_propinsi'];
$result[$i]['kd_dati2']= $row['kd_dati2'];
$result[$i]['thn_dep_min_max']= $row['thn_dep_min_max'];
$result[$i]['nilai_dep_min_max']= $row['nilai_dep_min_max'];
$result[$i]['nm_fasilitas']= $row['nm_fasilitas'];
$curr_index = $i;
}else{
$result[$curr_index]['nm_fasilitas']= $result[$curr_index]['nm_fasilitas'];
}
$i++;
}
$arrayProvider = new CArrayDataProvider($result, array('keyField' =>'nilai_dep_min_max'));
return $arrayProvider;
}
public function searchLift($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_dep_min_max, a.kd_fasilitas, b.satuan_fasilitas, b.status_fasilitas, b.ketergantungan, a.kls_dep_min, a.kls_dep_max, a.thn_dep_min_max,
case when (a.kd_fasilitas = \'30\' AND a.kls_dep_min = \'0\' AND a.kls_dep_max = \'4\') then b.nm_fasilitas||\' \'||\'LANTAI < 5\'
when (a.kd_fasilitas = \'30\' AND a.kls_dep_min = \'5\' AND a.kls_dep_max = \'9\') then b.nm_fasilitas||\' \'||\'LANTAI 5 - 9\'
when (a.kd_fasilitas = \'30\' AND a.kls_dep_min = \'10\' AND a.kls_dep_max = \'19\') then b.nm_fasilitas||\' \'||\'LANTAI 10 - 19\'
when (a.kd_fasilitas = \'30\' AND a.kls_dep_min = \'20\' AND a.kls_dep_max = \'99\') then b.nm_fasilitas||\' \'||\'LANTAI > 19\'
when (a.kd_fasilitas = \'31\' AND a.kls_dep_min = \'0\' AND a.kls_dep_max = \'4\') then b.nm_fasilitas||\' \'||\'LANTAI < 5\'
when (a.kd_fasilitas = \'31\' AND a.kls_dep_min = \'5\' AND a.kls_dep_max = \'9\') then b.nm_fasilitas||\' \'||\'LANTAI 5 - 9\'
when (a.kd_fasilitas = \'31\' AND a.kls_dep_min = \'10\' AND a.kls_dep_max = \'19\') then b.nm_fasilitas||\' \'||\'LANTAI 10 - 19\'
when (a.kd_fasilitas = \'31\' AND a.kls_dep_min = \'20\' AND a.kls_dep_max = \'99\') then b.nm_fasilitas||\' \'||\'LANTAI > 19\'
when (a.kd_fasilitas = \'32\' AND a.kls_dep_min = \'0\' AND a.kls_dep_max = \'4\') then b.nm_fasilitas||\' \'||\'LANTAI < 5\'
when (a.kd_fasilitas = \'32\' AND a.kls_dep_min = \'5\' AND a.kls_dep_max = \'9\') then b.nm_fasilitas||\' \'||\'LANTAI 5 - 9\'
when (a.kd_fasilitas = \'32\' AND a.kls_dep_min = \'10\' AND a.kls_dep_max = \'19\') then b.nm_fasilitas||\' \'||\'LANTAI 10 - 19\'
when (a.kd_fasilitas = \'32\' AND a.kls_dep_min = \'20\' AND a.kls_dep_max = \'99\') then b.nm_fasilitas||\' \'||\'LANTAI > 19\'
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=\'30\' OR a.kd_fasilitas=\'31\' OR a.kd_fasilitas=\'32\') AND a.thn_dep_min_max=\''.$previousYear.'\'';
$criteria->order='a.kd_propinsi, a.kd_dati2, a.thn_dep_min_max, a.kd_fasilitas, a.kls_dep_min';
// $criteria->compare('kd_propinsi',$this->kd_propinsi,true);
// $criteria->compare('kd_dati2',$this->kd_dati2,true);
// $criteria->compare('thn_dep_min_max',$this->thn_dep_min_max,true);
// $criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
// $criteria->compare('nilai_dep_min_max',$this->nilai_dep_min_max);
// return new CActiveDataProvider($this, array(
// 'pagination'=>false,
// 'criteria'=>$criteria,
// ));
$queryresult = new CActiveDataProvider($this, array(
'criteria'=>$criteria,
'pagination'=>false,
));
$result = array();
$curr_nilai = 2;
$i = 0;
$curr_index=$i;
//echo $queryresult->data[0]['nilai_fasilitas_kls_bintang'];
foreach($queryresult->data as $row){
if($curr_nilai!=$row['kls_dep_min']){
$curr_nilai = $row['kls_dep_min'];
$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]['kls_dep_min']= $row['kls_dep_min'];
$result[$i]['kls_dep_max']= $row['kls_dep_max'];
$result[$i]['kd_dati2']= $row['kd_dati2'];
$result[$i]['kd_propinsi']= $row['kd_propinsi'];
$result[$i]['thn_dep_min_max']= $row['thn_dep_min_max'];
$result[$i]['nilai_dep_min_max']= $row['nilai_dep_min_max'];
$result[$i]['nm_fasilitas']= $row['nm_fasilitas'];
$curr_index = $i;
}else{
$result[$curr_index]['nm_fasilitas']= $result[$curr_index]['nm_fasilitas'];
}
$i++;
}
$arrayProvider = new CArrayDataProvider($result, array('keyField' =>'nilai_dep_min_max', 'pagination'=>false,));
return $arrayProvider;
}
public function searchGenset($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_dep_min_max, a.kd_fasilitas, b.satuan_fasilitas, b.status_fasilitas, b.ketergantungan, a.kls_dep_min, a.kls_dep_max, a.thn_dep_min_max,
case when (a.kd_fasilitas = \'40\' AND a.kls_dep_min = \'0\' AND a.kls_dep_max = \'99\') then b.nm_fasilitas||\' \'||\'< 100 kva\'
when (a.kd_fasilitas = \'40\' AND a.kls_dep_min = \'100\' AND a.kls_dep_max = \'249\') then b.nm_fasilitas||\' \'||\'100 - 249 kva\'
when (a.kd_fasilitas = \'40\' AND a.kls_dep_min = \'250\' AND a.kls_dep_max = \'499\') then b.nm_fasilitas||\' \'||\'250 - 499 kva\'
when (a.kd_fasilitas = \'40\' AND a.kls_dep_min = \'500\' AND a.kls_dep_max = \'999999\') then b.nm_fasilitas||\' \'||\'> 499 kva\'
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=\'40\' AND a.thn_dep_min_max=\''.$previousYear.'\'';
$criteria->order='a.thn_dep_min_max';
// $criteria->compare('kd_propinsi',$this->kd_propinsi,true);
// $criteria->compare('kd_dati2',$this->kd_dati2,true);
// $criteria->compare('thn_dep_min_max',$this->thn_dep_min_max,true);
// $criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
// $criteria->compare('nilai_dep_min_max',$this->nilai_dep_min_max);
// return new CActiveDataProvider($this, array(
// 'criteria'=>$criteria,
// ));
$queryresult = new CActiveDataProvider($this, array(
'criteria'=>$criteria,
'pagination'=>false,
));
$result = array();
$curr_nilai = 2;
$i = 0;
$curr_index=$i;
foreach($queryresult->data as $row){
if($curr_nilai!=$row['kls_dep_min']){
$curr_nilai = $row['kls_dep_min'];
$result[$i]['kd_propinsi']= $row['kd_propinsi'];
$result[$i]['kd_dati2']= $row['kd_dati2'];
$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]['kls_dep_min']= $row['kls_dep_min'];
$result[$i]['kls_dep_max']= $row['kls_dep_max'];
$result[$i]['thn_dep_min_max']= $row['thn_dep_min_max'];
$result[$i]['nilai_dep_min_max']= $row['nilai_dep_min_max'];
$result[$i]['nm_fasilitas']= $row['nm_fasilitas'];
$curr_index = $i;
}else{
$result[$curr_index]['nm_fasilitas']= $result[$curr_index]['nm_fasilitas'];
}
$i++;
}
$arrayProvider = new CArrayDataProvider($result, array('keyField' =>'nilai_dep_min_max', 'pagination'=>false,));
return $arrayProvider;
}
/* public function searchKolamRenangDenganPelapis()
{
// 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_dep_min_max, 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=\'13\' AND a.thn_dep_min_max=\''.$previousYear.'\'';
$criteria->order='a.thn_dep_min_max';
$criteria->compare('kd_propinsi',$this->kd_propinsi,true);
$criteria->compare('kd_dati2',$this->kd_dati2,true);
$criteria->compare('thn_dep_min_max',$this->thn_dep_min_max,true);
$criteria->compare('kd_fasilitas',$this->kd_fasilitas,true);
$criteria->compare('nilai_dep_min_max',$this->nilai_dep_min_max);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
} */
}