public function actionGetkota()
{
$provinsi = $_POST['provinsi'];
$idprovinsi = Provinsi::find()->select(['FIELD1'])->where(['FIELD2' => $provinsi])->scalar();
$kota = Kota::find()->where(['FIELD3' => $idprovinsi])->all();
$datakota = array();
$no = 1;
$json = "";
if ($provinsi != "all") {
foreach ($kota as $data) {
array_push($datakota, array("kota" => $data->FIELD2));
$no++;
$json['kota'] = $datakota;
}
echo json_encode($json);
} else {
echo "error";
}
}
public function actionSubcat()
{
$out = [];
if (isset($_POST['depdrop_parents'])) {
$parents = $_POST['depdrop_parents'];
if ($parents != null) {
$cat_id = $parents[0];
$model = Kota::find()->asArray()->where(['province_id' => $cat_id])->all();
//$out = self::getSubCatList($cat_id);
// the getSubCatList function will query the database based on the
// cat_id and return an array like below:
// [
// ['id'=>'<sub-cat-id-1>', 'name'=>'<sub-cat-name1>'],
// ['id'=>'<sub-cat_id_2>', 'name'=>'<sub-cat-name2>']
// ]
foreach ($model as $key => $value) {
$out[] = ['id' => $value['province_id'], 'name' => $value['city_name']];
}
echo json_encode(['output' => $out, 'selected' => '']);
return;
}
}
echo Json::encode(['output' => '', 'selected' => '']);
}
public function actionCreatejsonkota()
{
$mcustomer = new Customer();
$mkota = new Kota();
$kota = $mkota->find()->all();
$total = $mcustomer->find()->count();
$labels = $mcustomer->attributeLabels();
$array = array();
$file = "uploads/json/customer/attributekota.json";
fopen($file, "w");
foreach ($kota as $row) {
$namekota = $row->FIELD2;
foreach ($labels as $key => $rows) {
$label = strtoupper($rows);
$filled = $mcustomer->find()->where($key . ' IS NOT NULL')->count();
$notfilled = $mcustomer->find()->where($key . ' IS NULL')->count();
array_push($array, array('kota' => $namekota, 'attribute' => array('labels' => $label, 'count' => $total, 'filled' => $filled, 'notfilled' => $notfilled)));
}
}
$data = json_encode($array, JSON_PRETTY_PRINT);
file_put_contents($file, $data);
}
