public function actionProfile() { $model = Consumers::find()->select('consumers.*')->where(['consumers.user_id' => Yii::$app->user->id])->one(); $queryActive = Orders::find()->select('orders.*')->leftJoin('orders_status', 'orders.order_status_id = orders_status.id')->leftJoin('consumers', 'orders.consumer_id = consumers.id')->leftJoin('user', 'consumers.user_id = user.id')->where(['user.id' => Yii::$app->user->id])->where(['orders.order_status_id' => 1]); $ordersCount = $queryActive->count(); if ($model->load(Yii::$app->request->post())) { if ($model->validate()) { $model->save(); Yii::$app->session->setFlash('success', 'Данные успешно изменены!'); } else { Yii::$app->session->setFlash('danger', 'Данные не были сохранены!'); } } return $this->render('view', ['model' => $model, 'ordersCount' => $ordersCount, 'actionType' => 'profile']); }
/** * Отменяет заказ * @return string */ public function actionCancel() { $ordersId = Yii::$app->request->get('ordersId'); $order = Orders::find()->leftJoin('consumers', 'orders.consumer_id = consumers.id')->leftJoin('user', 'consumers.user_id = user.id')->where(['user.id' => Yii::$app->user->id])->where(['orders.id' => $ordersId])->one(); if (!empty($order)) { $order->order_status_id = 3; $order->save(); } // $query = Orders::find() // ->leftJoin('orders_status', 'orders.order_status_id = orders_status.id') // ->leftJoin('consumers', 'orders.consumer_id = consumers.id') // ->leftJoin('user', 'consumers.user_id = user.id') // ->where(['user.id' => Yii::$app->user->id]);; // $ordersCount = $query->count(); // $orders = $query->all(); // // return $this->render('view', compact('orders', 'ordersCount')); // return debug($ordersId); return $this->redirect('/my-dashboard/orders'); }