/** * Lists all Goods models. * @return mixed */ public function actionIndex($order_id = 0) { $searchModel = new GoodsSearch(); if (Yii::$app->user->can('operator')) { $tp = 0; } else { $customers = new Customers(); $tp = $customers->getTP(Yii::$app->user->id); } $dataProvider = $searchModel->search(Yii::$app->request->queryParams, $tp); //$dataProvider->setPagination(['defaultPageSize' => 50]); //var_dump($dataProvider->pagination); //die(); return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'order_id' => $order_id]); }
protected function findModel($id) { if (($model = Customers::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
public function getParent($id) { $usr = User::findOne(['id' => $id]); $cust = Customers::findOne(['customer_name' => $usr->fullname]); //$usr = User::findOne(['id' => $cust->user_id]); //var_dump($cust); //die; return $cust->typeprices_id; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Customers::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['customer_id' => $this->customer_id]); $query->andFilterWhere(['like', 'customer_name', $this->customer_name])->andFilterWhere(['like', 'zip_code', $this->zip_code])->andFilterWhere(['like', 'city', $this->city])->andFilterWhere(['like', 'province', $this->province]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Customers::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(['customer_id' => $this->customer_id]); $query->andFilterWhere(['like', 'customer_name', $this->customer_name])->andFilterWhere(['like', 'zip_code', $this->zip_code])->andFilterWhere(['like', 'city', $this->city])->andFilterWhere(['like', 'province', $this->province]); return $dataProvider; }
/** * Creates a new Listofgoods model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate($order_id = 0, $amount = 0) { $model = new Listofgoods(); $customers = new Customers(); $typeprice = $customers->getTP(Yii::$app->user->id); //получаем тип цены для данного пользователя if ($model->load(Yii::$app->request->post())) { if ($order_id != 0) { $model->orders_order_id = $order_id; $price = $model->goodsGoodId->good_price / 100; $count = $model->good_count; $amount = $amount + $price * $count; //увеличим сумму заказа $order = Orders::findOne($order_id); $order->order_amount = $amount * 100; $order->save(); } $model->save(); return $this->redirect(['orders/view', 'id' => $model->orders_order_id]); } else { return $this->render('create', ['model' => $model, 'orders_order_id' => $order_id, 'tp' => $typeprice]); } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { //каждому пользователю соответствуют его контрагенты if (Yii::$app->user->can('admin')) { $query = Customers::find(); } else { $query = Customers::find()->where(['user_id' => Yii::$app->user->id]); } $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->joinWith('usersUser'); $query->joinWith('typePrices'); $query->andFilterWhere(['customer_id' => $this->customer_id]); $query->andFilterWhere(['like', 'customer_name', $this->customer_name])->andFilterWhere(['like', 'user.fullname', $this->user_id])->andFilterWhere(['like', 'type_price.type_price_name', $this->typeprices_id])->andFilterWhere(['like', 'customer_email', $this->customer_email]); return $dataProvider; }
/** * @return \yii\db\ActiveQuery */ public function getCustomer() { return $this->hasOne(Customers::className(), ['id' => 'customer_id']); }
use yii\helpers\ArrayHelper; use yii\helpers\Html; use yii\widgets\ActiveForm; /* @var $this yii\web\View */ /* @var $model backend\models\Orders */ /* @var $form yii\widgets\ActiveForm */ ?> <div class="orders-form"> <?php $form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'customers_customer_id')->dropDownList(ArrayHelper::map(Customers::find()->where(['user_id' => Yii::$app->user->id])->all(), 'customer_id', 'customer_name'), ['prompt' => 'Выберите контрагента...']); ?> <?php //$form->field($model, 'order_amount')->textInput(['value' => $model->order_amount / 100]) ?> <?php if (isset($amount)) { echo 'Сумма заказа: ' . $amount; } else { echo 'Сумма заказа: ' . $model->order_amount; } ?>
public function getCustomer() { return $this->hasMany(Customers::className(), ['user_id' => 'id']); }