Exemplo n.º 1
0
 /**
  * Updates an existing GoodsType model.
  * If update is successful, the browser will be redirected to the 'view' page.
  * @param string $id
  * @return mixed
  */
 public function actionUpdate($id)
 {
     $model = $this->findModel($id);
     if ($model->load(Yii::$app->request->post()) && $model->save()) {
         return $this->redirect(['index']);
     } else {
         $arObjParams = \app\models\GoodsParamsName::find()->where('goods_type_type=:goods_type_type', [':goods_type_type' => $id])->all();
         return $this->render('update', ['arObjParams' => $arObjParams, 'model' => $model]);
     }
 }
Exemplo n.º 2
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = GoodsParamsName::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to return any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     $query->andFilterWhere(['required' => $this->required, 'sort' => $this->sort]);
     $query->andFilterWhere(['like', 'id', $this->id])->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'data_type', $this->data_type])->andFilterWhere(['like', 'parent_param', $this->parent_param])->andFilterWhere(['like', 'goods_type_type', $this->goods_type_type]);
     return $dataProvider;
 }
Exemplo n.º 3
0
 public function actionLinkFilerRows($paramId, $parentParamId)
 {
     $paramsName = \app\models\GoodsParamsName::findOne($paramId);
     if ($parentParamId) {
         $paramsValues = \app\models\GoodsParams::find()->where('goods_params_name_id = :goods_params_name_id AND link_category = :link_category', [':goods_params_name_id' => $paramId, ':link_category' => $parentParamId])->all();
     } else {
         $paramsValues = \app\models\GoodsParams::find()->where('goods_params_name_id = :goods_params_name_id', [':goods_params_name_id' => $paramId])->all();
     }
     $data = \yii\helpers\ArrayHelper::map($paramsValues, 'id', 'value');
     $arRes = ['title' => $paramsName->name, 'name' => $paramsName->id, 'data' => ['' => ' - Все - '] + $data, 'parent_param' => $paramsName->parent_param, 'ch' => ''];
     header('Content-Type: utf-8');
     //        print $this->renderPartial('_row_filter', $arRes);
     $arRres = ['paramId' => $paramId, 'html' => $this->renderPartial('_row_filter', $arRes)];
     print json_encode($arRres);
 }
Exemplo n.º 4
0
 /**
  * Deletes an existing GoodsParams model.
  * If deletion is successful, the browser will be redirected to the 'index' page.
  * @param integer $id
  * @return mixed
  */
 public function actionTech()
 {
     exit;
     $GoodsParamsName = \app\models\GoodsParamsName::find()->all();
     foreach ($GoodsParamsName as $gpn) {
         print '============================== <br>';
         print $gpn->id . '<br>';
         $oGP = \app\models\GoodsParams::find()->where('goods_params_name_id=:goods_params_name_id', [':goods_params_name_id' => $gpn->id])->all();
         //            print ('<pre>');print_r($oGP);print('</pre>');
         $arGP = \yii\helpers\ArrayHelper::map($oGP, 'id', 'id');
         print implode(',', $arGP) . '<br>';
         if (count($arGP) == 0) {
             continue;
         }
         //            $goods = \app\components\Goods::find($gpn->goods_type_type, $gpn->id . ' not in (:ids)', [':ids' => implode(',',$arGP)])->all();
         $goods = \app\components\Goods::find($gpn->goods_type_type, $gpn->id . ' not in (' . implode(',', $arGP) . ')', [])->all();
         foreach ($goods as $good) {
             $ar = \yii\helpers\ArrayHelper::toArray($good);
             print '<pre>';
             print_r($ar);
             print '</pre>';
             \app\models\Goods::deleteAll('id=:goods_id', [':goods_id' => $good->goods_id]);
         }
     }
 }
 /**
  * Finds the GoodsParamsName model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param string $id
  * @return GoodsParamsName the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = GoodsParamsName::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }
Exemplo n.º 6
0
 public function actionGetTypeParams($type)
 {
     $params = \app\models\GoodsParamsName::find()->where('goods_type_type=:goods_type_type', [':goods_type_type' => $type])->orderBy('sort ASC')->all();
     $arParams = ['' => ' - Добавить параметр - '];
     $arLinks = [];
     foreach ($params as $param) {
         $arParams[$param->id] = $param->name;
         if ($param->parent_param) {
             $arLinks[$param->id] = $param->parent_param;
         }
     }
     print '<script>oLinks = ' . json_encode($arLinks) . '</script>';
     print \yii\helpers\BaseHtml::dropDownList('listParams', '', $arParams);
 }
Exemplo n.º 7
0
        <p>
            <?php 
    echo Html::a('Добавить наценку', ['create'], ['class' => 'btn btn-success']);
    ?>
        </p>

        <?php 
    echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], ['attribute' => 'goods_type_type', 'label' => 'Тип товара', 'format' => 'html', 'value' => function ($model) {
        $oGT = \app\models\GoodsType::findOne($model->goods_type_type);
        return '[' . $oGT->type . '] <b>' . $oGT->name . '</b>';
    }], ['attribute' => 'test1', 'label' => 'Параметр', 'format' => 'html', 'value' => function ($model) {
        $arP = explode(';', $model->params);
        $arV = explode(';', $model->values);
        $arPP = [];
        foreach ($arP as $key => $paramId) {
            $oPar = \app\models\GoodsParamsName::findOne($paramId);
            $oVal = app\models\GoodsParams::findOne($arV[$key]);
            if ($oPar instanceof \app\models\GoodsParamsName && $oVal instanceof app\models\GoodsParams) {
                $arPP[] = $oPar->name . ': <b>' . $oVal->value . '</b>';
            }
        }
        return implode('; ', $arPP);
    }], ['attribute' => 'coef1', 'label' => 'Коэффициент', 'format' => 'html', 'value' => function ($model) {
        return $model->coef;
    }], ['class' => 'yii\\grid\\ActionColumn', 'template' => '{update} {delete}']]]);
    ?>
        <?php 
}
?>

</div>
Exemplo n.º 8
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getGoodsParamsName()
 {
     return $this->hasOne(GoodsParamsName::className(), ['id' => 'goods_params_name_id']);
 }
Exemplo n.º 9
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getGoodsParamsNames()
 {
     return $this->hasMany(GoodsParamsName::className(), ['goods_type_type' => 'type']);
 }