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');
}
