public function findAllArea($id)
{
$AreaArea = Area::find()->where(array('parentId' => $id))->asArray()->all();
if ($AreaArea) {
return $AreaArea;
}
return null;
}
public function actionGetarea1()
{
$regional = 2;
$query = new Query();
$model = new Area();
$modelprovinsi = new Provinsi();
$datawitel = array();
$datakota = array();
$dataprovinsi = array();
$no = 1;
$json = "";
if ($regional != "all") {
$witel = $model->find()->select(['FIELD2'])->distinct(true)->where(['FIELD3' => $regional])->orderby(['FIELD2' => SORT_ASC])->all();
$provinsi = $modelprovinsi->find()->select(['FIELD2'])->distinct(true)->where(['FIELD3' => $regional])->orderby(['FIELD2' => SORT_ASC])->all();
$query->select('TABLE24.FIELD2')->from('TABLE24')->join('LEFT OUTER JOIN', 'TABLE25', 'TABLE25.FIELD1 = TABLE24.FIELD3')->join('LEFT OUTER JOIN', 'TABLE7', 'TABLE7.FIELD1 = TABLE25.FIELD3')->where(['TABLE7.FIELD1' => $regional])->all();
$kota = $query->createCommand()->queryAll();
foreach ($witel as $data) {
array_push($datawitel, array("witel" => $data->FIELD2));
$no++;
$json['witel'] = $datawitel;
}
foreach ($kota as $data) {
array_push($datakota, array("kota" => $data['FIELD2']));
$no++;
$json['kota'] = $datakota;
}
foreach ($provinsi as $data) {
array_push($dataprovinsi, array("provinsi" => $data->FIELD2));
$no++;
$json['provinsi'] = $dataprovinsi;
}
echo json_encode($json);
} else {
echo "error";
}
}
public function actionArea()
{
$model = new Area();
for ($i = 1; $i <= 100; $i++) {
$id_regional = 1;
if ($i % 8 == 0) {
$id_regional = 8;
} else {
if ($i % 7 == 0) {
$id_regional = 7;
} else {
if ($i % 6 == 0) {
$id_regional = 6;
} else {
if ($i % 5 == 0) {
$id_regional = 5;
} else {
if ($i % 4 == 0) {
$id_regional = 4;
} else {
if ($i % 3 == 0) {
$id_regional = 3;
} else {
if ($i % 2 == 0) {
$id_regional = 2;
}
}
}
}
}
}
}
$model->FIELD1 = $i;
$model->FIELD2 = "AREA " . $i;
$model->FIELD3 = $id_regional;
if ($model->insert()) {
echo "sukses" . $i;
} else {
print_r($model->getErrors());
}
}
}
public function actionEditaddress()
{
$Area = new Area();
$UserAddress = new UserAddress();
$AreaProvince = $Area->findAllProvince(0);
$AddressForm = new AddAddressForm();
$userId = Yii::$app->session->get(FVariable::$session_userId_str);
if (!$userId) {
return $this->redirect(FVariable::$siteLogin_view);
}
$userAddressId = Yii::$app->request->get('id');
$EditUserAddress = $UserAddress->findByUserIdEvaluate($userId, $userAddressId);
$AddressForm->userName = $EditUserAddress->userName;
$AddressForm->provinceId = $EditUserAddress->provinceId;
$AddressForm->cityId = $EditUserAddress->cityId;
$AddressForm->areaId = $EditUserAddress->areaId;
$AreaCity = $Area->findAllCity($AddressForm->provinceId);
$AreaArea = $Area->findAllCity($AddressForm->cityId);
$AddressForm->detailAddress = $EditUserAddress->detailAddress;
$AddressForm->userMobile = $EditUserAddress->userMobile;
$AddressForm->userPhone = $EditUserAddress->userPhone;
$AddressForm->postNumber = $EditUserAddress->postNumber;
$AddressForm->isDefault = $EditUserAddress->isDefault;
$editAddressReq = Yii::$app->request;
//创建一个请求对象
if ($AddressForm->load($editAddressReq->post())) {
if ($AddressForm->validate()) {
if (!$AddressForm->isDefault) {
$AddressForm->isDefault = 0;
} else {
$UserAddress->findByUserIdUpdate($userId);
}
$UserAddress->findByIdEdit($userAddressId, $AddressForm);
return $this->redirect(FVariable::$userVipcenter_view);
}
}
return $this->render(FVariable::$userEditAddress_view, ['AddressForm' => $AddressForm, 'AreaProvince' => $AreaProvince, 'AreaCity' => $AreaCity, 'AreaArea' => $AreaArea]);
}
public function actionCreatejsonarea()
{
$mcustomer = new Customer();
$marea = new Area();
$area = $marea->find()->all();
$total = $mcustomer->find()->count();
$labels = $mcustomer->attributeLabels();
$array = array();
$file = "uploads/json/customer/attributearea.json";
fopen($file, "w");
foreach ($area as $row) {
$namearea = $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('area' => $namearea, 'attribute' => array('labels' => $label, 'count' => $total, 'filled' => $filled, 'notfilled' => $notfilled)));
}
}
$data = json_encode($array, JSON_PRETTY_PRINT);
file_put_contents($file, $data);
}
