$todays_record[$i]['id'] = $i; $todays_record[$i]['username'] = $app->user->where('id', $today_order->user_id)->first()->username; $category = $app->categories->where('id', $today_order->category_id)->first(); $todays_record[$i]['category_name'] = $category->name; $todays_record[$i]['amount'] = $category->amount; $i++; } $todays_record = json_decode(json_encode($todays_record)); $app->render('admin/example.php', ['todays_record' => $todays_record]); } else { $app->render('admin/example.php'); } })->name('admin.example'); $app->post('/admin/example', $admin(), function () use($app) { $todays_record = ''; $date = new Date(); $app->admin_list->create(['day' => $date->getCurrentDay(), 'lunch_date' => $date->getCurrentDate(), 'mail_send' => true]); //get order list for today from history table $todays_order = $app->history->where('lunch_date', $date->getCurrentDate())->get(); $i = 0; foreach ($todays_order as $today_order) { $todays_record[$i]['id'] = $i; $todays_record[$i]['username'] = $app->user->where('id', $today_order->user_id)->first()->username; $category = $app->categories->where('id', $today_order->category_id)->first(); $todays_record[$i]['category_name'] = $category->name; $todays_record[$i]['amount'] = $category->amount; $i++; } $todays_record = json_decode(json_encode($todays_record)); //send order list by mail to admin $auth = $app->auth;
<?php use Lunchbox\Helpers\Date; $app->get('/u/:username', function ($username) use($app) { $records = ''; $date = new Date(); $user = $app->user->where('username', $username)->first(); if (!$user) { $app->notFound(); } $history = $app->history->where('user_id', $user->id)->where('lunch_date', '>=', $date->getCurrentMonthFirstDay())->orderBy('lunch_date', 'DESC')->get(); $i = 0; $serial_number = 1; foreach ($history as $day_history) { $records[$i]['id'] = $serial_number; $category = $app->categories->where('id', $day_history->category_id)->first(); $records[$i]['category_name'] = $category->name; $records[$i]['amount'] = $category->amount; $records[$i]['date'] = $day_history->lunch_date; $i++; $serial_number++; } $records = json_decode(json_encode($records)); $app->render('user/profile.php', ['user' => $user, 'records' => $records]); })->name('user.profile');