/** * Съел * @return string */ public function actionEat() { $start_day = strtotime('now 00:00:00', time() + 7 * 60 * 60); if (Yii::$app->getRequest()->getQueryParam('user')) { $user = MarkUser::findOne(Yii::$app->getRequest()->getQueryParam('user')); // return var_dump($user); //$user = Yii::$app->getRequest()->getQueryParam('user'); //return var_dump($user); if (Yii::$app->getRequest()->getQueryParam('dish') && Yii::$app->getRequest()->getQueryParam('measure')) { $round_ate = 0; $dish = DiaryDish::find()->where(['name' => Yii::$app->getRequest()->getQueryParam('dish')])->one(); $today_acts_before = implode(',', ArrayHelper::map(DiaryActs::find()->where("time > {$start_day} and user_id = {$user->id} and model_id = 1")->all(), 'id', 'id')); if ($today_acts_before) { $sum_kkal_before = DiaryAte::find()->select('SUM(kkal)')->where("act_id IN (" . $today_acts_before . ")")->scalar(); } else { $sum_kkal_before = 0; } $act = new DiaryActs(); $act->model_id = 1; $act->user_id = Yii::$app->getRequest()->getQueryParam('user'); $round_ate = round(Yii::$app->getRequest()->getQueryParam('measure') * $dish->kkal / 100); if ($act->save(false)) { $ate = new DiaryAte(); try { $ate->dish_id = $dish->id; } catch (\ErrorException $e) { return 'Такого блюда в базе нет!'; } $ate->act_id = $act->id; $ate->user_id = $act->user_id; $ate->measure = Yii::$app->getRequest()->getQueryParam('measure'); $ate->kkal = $round_ate; //$ate->mark = $act->mark; if (!$ate->validate()) { return 'Данные введены некорректно'; } else { $ate->save(); /*метка начала текущих суток*/ $today_acts = implode(',', ArrayHelper::map(DiaryActs::find()->where("time > {$start_day} and user_id = " . $user->id . " and model_id = 1")->all(), 'id', 'id')); $ate_today = []; $sum_kkal = 0; //return var_dump($today_acts); if ($today_acts) { $ate_today = DiaryAte::find()->where("act_id IN (" . $today_acts . ")")->all(); $sum_kkal = DiaryAte::find()->select('SUM(kkal)')->where("act_id IN (" . $today_acts . ")")->scalar(); } if ($sum_kkal > 2000) { if ($sum_kkal - $round_ate < 2000) { $act->mark = round(($sum_kkal - 2000) / 100, 0, PHP_ROUND_HALF_UP) * -1; } else { $act->mark = round($round_ate / 100, 0, PHP_ROUND_HALF_UP) * -1; } $act->update(); $ate->mark = $act->mark; $ate->update(); } return $this->renderPartial('ate_today', ['ate_today' => $ate_today, 'sum_kkal' => $sum_kkal, 'user' => $user]); } } } $today_acts = implode(',', ArrayHelper::map(DiaryActs::find()->where("time > {$start_day} and user_id = " . $user->id . " and model_id = 1")->all(), 'id', 'id')); //return var_dump($today_acts); $ate_today = []; $sum_kkal = 0; if ($today_acts) { $ate_today = DiaryAte::find()->where("act_id IN (" . $today_acts . ")")->all(); $sum_kkal = DiaryAte::find()->select('SUM(kkal)')->where("act_id IN (" . $today_acts . ")")->scalar(); } //return var_dump($ate_today); return $this->renderPartial('eat', ['ate_today' => $ate_today, 'sum_kkal' => $sum_kkal, 'user' => $user]); } return $this->renderPartial('error'); }
/** * Снимок дня * @throws \Exception */ public function actionSnapshot() { //$data = $this->cut_content($this->get_page("http://redday.ru/moon/"),'maintext', '/sun/sunrise.asp'); //var_dump($data); exit; $start_time = strtotime('now 00:00:00', time() + 7 * 60 * 60); $snapshot = new Snapshot(); $today_mark = DiaryActs::find()->select('SUM(mark)')->where("user_id = 8 and time > " . $start_time)->scalar(); if ($today_mark) { $snapshot->oz = $today_mark; } else { $snapshot->weight = 0; } $snapshot->doll = Helper::currencyAdapter(1, 11); $snapshot->euro = Helper::currencyAdapter(1, 12); if (DiaryRecDayParams::find()->where(['day_param_id' => 1])->orderBy('id DESC')->one()) { $snapshot->weight = (double) DiaryRecDayParams::find()->where(['day_param_id' => 1])->orderBy('id DESC')->one()->value; } else { $snapshot->weight = 0; } $mish_mark = DiaryActs::find()->select('SUM(mark)')->where("time > {$start_time} and user_id = 11")->scalar(); if ($mish_mark) { $snapshot->mish_oz = $mish_mark; } else { $snapshot->mish_oz = 0; } $today_acts = implode(',', ArrayHelper::map(DiaryActs::find()->where("time > {$start_time} and user_id = 8 and model_id = 1")->all(), 'id', 'id')); $snapshot->kkal = DiaryAte::find()->select('SUM(kkal)')->where("act_id IN (" . $today_acts . ")")->scalar(); $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(); $snapshot->useful_bal = (int) ($not_curr_sum + Helper::currencyAdapter($dollar, 11) + Helper::currencyAdapter($euro, 12)); $snapshot->sun_rise = date_sunrise(time(), SUNFUNCS_RET_STRING, 55, 82, 90, 7); $snapshot->sun_set = date_sunset(time(), SUNFUNCS_RET_STRING, 55, 82, 90, 7); $today_acts_bought = implode(',', ArrayHelper::map(DiaryActs::find()->where("time > {$start_time} and user_id = 8 and model_id = 3")->all(), 'id', 'id')); $bought_today = []; $sum_spent = 0; if ($today_acts_bought) { try { //return var_dump($bought_today); $snapshot->spent = Bought::find()->select('SUM(spent)')->where("act_id IN (" . $today_acts_bought . ")")->scalar(); } catch (\ErrorException $e) { return $e->getMessage(); } // return var_dump($sum_spent ); } if ($snapshot->save()) { $act = new DiaryActs(); $act->model_id = 12; $act->user_id = 8; $klavaro_balls = 0; $today_acts_of_day_params = implode(',', ArrayHelper::map(DiaryActs::find()->where("time > {$start_time} and user_id = 8 and model_id = 4")->all(), 'id', 'id')); if ($today_acts_of_day_params) { $klavaro_eng_today = DiaryRecDayParams::find()->where("act_id IN (" . $today_acts_of_day_params . ") and day_param_id = 22")->one(); $klavaro_ru_today = DiaryRecDayParams::find()->where("act_id IN (" . $today_acts_of_day_params . ") and day_param_id = 23")->one(); } if (isset($klavaro_eng_today) && $klavaro_eng_today->value > 95) { $klavaro_balls = 1; } if (isset($klavaro_ru_today) && $klavaro_ru_today->value > 95) { $klavaro_balls += 1; } //$klavaro_balls = ( isset($klavaro_eng_today) ? $klavaro_eng_today->value : 0 ) + ( isset($klavaro_ru_today) ? $klavaro_eng_today->value : 0 ); //echo $klavaro_balls; if (DiaryRecDayParams::find()->where(['day_param_id' => 18])->orderBy('id DESC')->one()) { $act->mark = (int) round(DiaryRecDayParams::find()->where(['day_param_id' => 18])->orderBy('id DESC')->one()->value / 2000) + $klavaro_balls; } else { $act->mark = 0; } $snapshot->oz += $act->mark; $snapshot->update(); // var_dump($act); if ($act->save(false)) { echo 'ok'; } } //var_dump($snapshot); }