/**
* @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' => ''];
}
