public function actionIndex() { $user_id = Yii::$app->user->getId(); $user = User::findIdentity($user_id); $active_purse = Purse::find()->where(['user_id' => $user_id, 'active' => 1])->one(); $purses = Purse::find()->where(['user_id' => $user_id])->all(); if ($user->payday) { // если есть дата зп $datePayDay = DateComponent::getDateFilterWithPayday(); } else { $datePayDay = [date('Y'), date("m"), 1]; // иначе ставим 1 число текущего месяца } $operations = Expense::find()->orderBy('datetime desc')->limit(6)->all(); $types = TypeExpense::find()->where(['user_id' => $user_id])->select(['type_expense.*', TypeExpense::SELECT_SUM])->innerJoinWith(['expenses' => function ($query) use($datePayDay) { $query->where('date(datetime)>=:date_before', [':date_before' => implode('-', $datePayDay)]); }])->where(['purse_id' => $active_purse->id])->groupBy('type_expense.id')->all(); $arrTypes = []; $sum = 0; foreach ($types as $type) { $sum += $type->sum; array_push($arrTypes, ['value' => $type->sum, 'color' => ColorComponent::random_color(), 'label' => $type->name]); } // var_dump($types->prepare(Yii::$app->db->queryBuilder)->createCommand()->rawSql);die; return $this->render('index', ['arrTypes' => $arrTypes, 'date' => $datePayDay[2] . "." . $datePayDay[1] . "." . $datePayDay[0], 'active_purse' => $active_purse, 'purses' => $purses, 'sum' => $sum, 'operations' => $operations]); }
/** * Страница редактирования кошелька * @param $id * @return string */ public function actionEdit($id) { $purse = Purse::find()->where(['id' => $id])->one(); if ($purse->load(Yii::$app->request->post()) && $purse->save()) { Yii::$app->getSession()->setFlash('notification', 'Данные кошелька "' . $purse->name . '" успешно изменены'); return $this->redirect(Url::toRoute(['/purse/index'])); } $this->getView()->params['title'] = 'Редактирование кошелька "' . $purse->name . '"'; return $this->render('edit', ['purse' => $purse]); }
/** * создаем расход по плану * @return array */ public function actionToExpense() { \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; $id = Yii::$app->request->post('id'); $planValue = Yii::$app->request->post('planValue'); $return = []; if ($id && $planValue) { $plan = Plan::find()->where(['id' => $id])->one(); $purse = Purse::find()->where(['id' => $plan->purse_id])->one(); if ($purse->balance >= $planValue) { $expense = new Expense(); $expense->setAttributes($plan->getAttributes()); $expense->money = $planValue; $save = $expense->save(); if ($save) { $purse->balance -= $planValue; $purse->save(); $plan->delete(); } $return = ['success' => 1, 'message' => '']; } else { $return = ['success' => 0, 'message' => 'Недостаточно средств на кошельке']; } } return ['success' => $return]; }
/** * удаляем ajax затрату * @return array */ public function actionDelete() { \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; $id = Yii::$app->request->post('id'); if ($id) { $expense = Expense::find()->where(['id' => $id])->one(); $purse = Purse::find()->where(['id' => $expense->purse_id])->one(); $purse->balance += $expense->money; $purse->save(); $result = $expense->delete(); } return ['success' => $result]; }
/** * добавление нового дохода * @return string */ public function actionAdd() { $errors = []; $message = null; $user_id = Yii::$app->user->getId(); $model = new IncomeForm(); if (Yii::$app->request->isPost) { $model->setAttributes(Yii::$app->request->post("IncomeForm")); if ($model->datetime) { $date = DateComponent::PeopleDateToDate($model->datetime); $model->datetime = $date; } if (!$model->datetime || date("Y-m-d") >= $model->datetime) { $purse = Purse::find()->where(['id' => $model->purse_id])->one(); if ($purse) { if ($model->validate()) { $purse_minus = new Income(); $purse_minus->setAttributes($model->getAttributes()); $type = $model->getType($user_id); if ($type) { $purse_minus->type_income_id = $type; $save = $purse_minus->save(); if ($save) { $purse->balance += $model->money; $purse->save(); $message = '<div class="alert alert-success" role="alert">Новый доход добавлен</div>'; $model = new IncomeForm(); } } else { $errors = $model->getErrors(); } } else { $errors = $model->getErrors(); } } } else { $message = '<div class="alert alert-danger" role="alert">Дата не должна быть позже сегодняшней</div>'; } } $purses = Purse::find()->where(['user_id' => $user_id])->orderBy('active DESC')->all(); $categories = TypeIncome::find()->where(['user_id' => $user_id])->orderBy('id desc')->all(); return $this->render('add', ['purses' => $purses, 'categories' => $categories, 'message' => $message, 'model' => $model, 'errors' => $errors]); }