/** * @return \yii\db\ActiveQuery */ public function getIdWilayah() { return $this->hasOne(Wilayah::className(), ['id' => 'id_wilayah']); }
public function actionData($wil, $var, $kat) { if ($kat == null) { $kat = 0; } \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; $namaWilparent = \common\models\Wilayah::findOne(['id' => $wil]); $query = new Query(); $query->select('fakta.id_wilayah, wilayah.nama as nama_wilayah, wilayah.tipe , fakta.nilai, fakta.tahun, variabel.satuan, variabel.nama as nama_variabel, kategori.nama as nama_kategori, fakta.id_bulan, bulan.nama as nama_bulan')->from('fakta')->distinct('wilayah.id ,fakta.nilai,fakta.tahun,variabel.satuan,fakta.id_bulan,bulan.nama')->join('LEFT JOIN', 'wilayah', 'fakta.id_wilayah=wilayah.id')->join('LEFT JOIN', 'variabel', 'fakta.id_variabel=variabel.id')->join('LEFT JOIN', 'bulan', 'fakta.id_bulan=bulan.id')->join('LEFT JOIN', 'kategori', 'fakta.id_kategori=kategori.id')->orderBy('fakta.tahun,fakta.id_bulan')->where('wilayah.id_parent=' . $wil . ' AND fakta.id_variabel=' . $var . ' AND fakta.id_kategori=' . $kat); $rows = $query->all(); $command = $query->createCommand(); $rows = $command->queryAll(); return ['data' => $rows, 'namaparent' => $namaWilparent['nama']]; }
<?php use yii\helpers\Html; use yii\grid\GridView; /* @var $this yii\web\View */ /* @var $searchModel backend\models\FaktaSearch */ /* @var $dataProvider yii\data\ActiveDataProvider */ $this->title = 'Faktas'; $this->params['breadcrumbs'][] = $this->title; $wilayah = \yii\helpers\ArrayHelper::map(\common\models\Wilayah::find()->all(), 'id', 'nama'); $bulan = \yii\helpers\ArrayHelper::map(\common\models\Bulan::find()->all(), 'id', 'nama'); $variabel = \yii\helpers\ArrayHelper::map(\common\models\Variabel::find()->all(), 'id', 'nama'); $kategori = \yii\helpers\ArrayHelper::map(\common\models\Kategori::find()->all(), 'id', 'nama'); $sumberData = \yii\helpers\ArrayHelper::map(\common\models\SumberData::find()->all(), 'id', 'nama_cs'); ?> <div class="fakta-index"> <h1><?php echo Html::encode($this->title); ?> </h1> <?php // echo $this->render('_search', ['model' => $searchModel]); ?> <p> <?php echo Html::a('Create Fakta', ['create'], ['class' => 'btn btn-success']); ?> </p>
public function actionChild() { \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; $out = []; if (isset($_POST['depdrop_parents'])) { $id = end($_POST['depdrop_parents']); $list = \common\models\Wilayah::find()->andWhere(['tipe' => $id])->asArray()->all(); $selected = null; if ($id != null && count($list) > 0) { $selected = ''; foreach ($list as $i => $account) { $out[] = ['id' => $account['id'], 'name' => $account['nama']]; if ($i == 0) { $selected = $account['id']; } } // Shows how you can preselect a value return ['output' => $out, 'selected' => $selected]; } } return ['output' => '', 'selected' => '']; }