/**
* Приходы
* @return string
*/
public function actionIncomes()
{
if (Yii::$app->getRequest()->getQueryParam('user')) {
// $start_day = strtotime('now 00:00:00');
$user = MarkUser::findOne(Yii::$app->getRequest()->getQueryParam('user'));
if (!$user) {
return 'Доступ запрещен!';
}
if (Yii::$app->getRequest()->getQueryParam('name') && Yii::$app->getRequest()->getQueryParam('value') !== null) {
if (Income::find()->where(['name' => Yii::$app->getRequest()->getQueryParam('name')])) {
$income = Income::find()->where(['name' => Yii::$app->getRequest()->getQueryParam('name')])->one();
} else {
return 'Ошибка при наборе';
}
$act = new DiaryActs();
$act->model_id = 9;
$act->user_id = $user->id;
//return var_dump($act);
if ($act->save(false)) {
$incomes = new Incomes();
try {
$incomes->income_id = $income->id;
} catch (\ErrorException $e) {
return 'Такой статьи в базе нет!';
}
$incomes->act_id = $act->id;
$incomes->user_id = $act->user_id;
$incomes->money = (double) Yii::$app->getRequest()->getQueryParam('value');
if (!$incomes->validate()) {
return 'Данные введены некорректно';
} else {
if ($incomes->save()) {
$all_incomes_grouped = Incomes::find()->select(['income_id, COUNT(*) as cnt, SUM(money) as sum '])->groupBy('income_id')->orderBy('sum DESC')->all();
//var_dump($all_incomes_grouped);
$not_curr_sum = Incomes::find()->select('SUM(money)')->where("income_id IN (1,2,7,10)")->scalar();
$dollar = Incomes::find()->select('SUM(money)')->where("income_id = 8")->scalar();
$euro = Incomes::find()->select('SUM(money)')->where("income_id = 9")->scalar();
$bal_sum = $not_curr_sum + Helper::currencyAdapter($dollar, 11) + Helper::currencyAdapter($euro, 12);
return $this->renderPartial('all_incomes', ['user' => $user, 'incomes' => $all_incomes_grouped, 'bal_sum' => $bal_sum]);
} else {
return 'Ошибка сохранения';
}
}
}
}
$all_incomes_grouped = Incomes::find()->select(['income_id, COUNT(*) as cnt, SUM(money) as sum '])->groupBy('income_id')->orderBy('sum DESC')->all();
//var_dump($all_incomes_grouped);
$not_curr_sum = Incomes::find()->select('SUM(money)')->where("income_id IN (1,2,7,10)")->scalar();
$dollar = Incomes::find()->select('SUM(money)')->where("income_id = 8")->scalar();
$euro = Incomes::find()->select('SUM(money)')->where("income_id = 9")->scalar();
$bal_sum = $not_curr_sum + Helper::currencyAdapter($dollar, 11) + Helper::currencyAdapter($euro, 12);
//sreturn Helper::currencyAdapter($dollar, 11);
return $this->renderPartial('income', ['user' => $user, 'incomes' => $all_incomes_grouped, 'bal_sum' => $bal_sum]);
} else {
return 'Ошибка';
}
}
