/**
* Съел
* @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);
}
