Exemplo n.º 1
0
 public function actionRegion($id = null)
 {
     if ($id) {
         $model = Geo::getOne($id);
         //получчаем количество розничных точек в регионе
         $col_apteki = Apteki::find()->where(['region_id' => $id])->count();
         //получаем количество Юр.лиц
         $col_ur_l = RegionUrL::find()->where(['id_reg' => $id])->count();
         $db = new Query();
         $db->from('region_ur_l');
         $db->InnerJoin('ur_l', 'id_ur = ur_l.id');
         $db->andWhere(['=', 'id_reg', $id]);
         $db->andWhere(['=', 'ur_l.regional_id', $model['regional_id']]);
         $col_ur_l_regpred = $db->count();
         //  $col_ur_l_regpred = RegionUrL::find()->where(['id_reg' => $id])->andWhere(['$model'=>])->count();
     } else {
         $model = Geo::getAll();
     }
     $region = new Geo();
     if ($_POST['Geo']) {
         $model->attributes = $_POST['Geo'];
         if ($model->validate() && $model->save()) {
             return $this->render('/edit/region', ['model' => $model, 'region' => $region, 'ok' => 1, 'col_apteki' => $col_apteki, 'col_ur_l' => $col_ur_l, 'col_ur_l_regpred' => $col_ur_l_regpred]);
         }
     }
     if ($id) {
         return $this->render('/edit/region', ['model' => $model, 'col_apteki' => $col_apteki, 'col_ur_l' => $col_ur_l, 'col_ur_l_regpred' => $col_ur_l_regpred]);
     } else {
         return $this->render('region', ['model' => $model]);
     }
 }
Exemplo n.º 2
0
 public function actionFasten($id)
 {
     $user = Users::getOne($id);
     $status = $user['status'];
     $regions = Geo::find()->all();
     $region = ArrayHelper::map($regions, 'id', 'name');
     return $this->render('fasten', ['model' => $user, 'region' => $region, 'id' => $id, 'status_id' => $status, 'status' => Yii::$app->params['status_user'][$status]]);
 }
Exemplo n.º 3
0
 public function setQuery($query)
 {
     $geo = new Geo();
     $geo->reset();
     $geo->installGeo($this->id_okrug, $this->id_region, $this->id_city);
     if ($geo->arrayCity) {
         $where["id_city"] = $geo->arrayCity;
     }
     if ($this->id_cat) {
         $cat = FCategory::findOne($this->id_cat);
         $arrayUsers = $cat->arrayUsers;
         $where["id"] = $arrayUsers;
     }
     if (isset($where)) {
         $query = $query->where($where);
     }
     if ($this->search != "") {
         $query = $query->andWhere(["or like", $this->search_field, $this->search]);
     }
     return $query;
 }
Exemplo n.º 4
0
Arquivo: _form.php Projeto: pumi11/aau
    <?php 
echo $form->field($model, 'name')->textInput(['maxlength' => true]);
?>

    <?php 
echo $form->field($model, 'manuf')->textInput(['maxlength' => true]);
?>

    <?php 
echo $form->field($model, 'is_active')->checkbox();
?>


    <?php 
echo $form->field($model, 'region_id')->dropdownList(Geo::find()->select(['name', 'id'])->indexBy('id')->column(), ['prompt' => 'Выберите регион']);
?>


    <div class="form-group">
        <?php 
echo Html::submitButton($model->isNewRecord ? 'Добавить' : 'Обновить', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']);
?>
    </div>

    <?php 
ActiveForm::end();
?>

</div>
Exemplo n.º 5
0
Arquivo: index.php Projeto: pumi11/aau


    <?php 
// echo $this->render('_search', ['model' => $searchModel]);
?>

    <p>
        <?php 
echo Html::a('Добавить препарат', ['create'], ['class' => 'btn btn-success']);
?>
    </p>
    <br>

    <?php 
$reg = Geo::find()->select(['name', 'id'])->indexBy('id')->orderBy('name')->column();
echo Html::dropdownList('region', $region, $reg, ['class' => 'form-control', 'id' => 'change_reg']);
?>
    <script>
        $(document).ready(function () {
            $('#change_reg').change(function () {
                window.location.href='?region='+this.value;
            });
        });
    </script>


    <br>
    <table>
        <?php 
foreach ($model as $preparat) {
Exemplo n.º 6
0
 public function getGeo()
 {
     return $this->hasOne(Geo::className(), ['id' => 'geo_id']);
 }