/** * Display a listing of the users * @return \Illuminate\Http\Response */ public function getIndex() { //Get users $response = []; $users = Model_Users::getUsers(); //Get users data $users_data_to_retrive = ['first_name', 'last_name']; $users_data = Model_Users::getUsersData($users_data_to_retrive); //Merge users and users data foreach ($users as $key => $user) { $user_id = $user['id']; foreach ($user as $user_info_key => $user_info) { //Do not pass sensitive data to view if ($user_info_key != 'password' && $user_info_key != 'remember_token' && $user_info_key != 'updated_at' && $user_info_key != 'last_login') { $response['users'][$user_id][$user_info_key] = $user_info; } } } foreach ($users_data as $key => $data) { $response['users'][$data['user_id']][$data['object']] = $data['value']; } $customCSS = ['global/plugins/datatables/plugins/bootstrap/dataTables.bootstrap']; $customJS = ['global/plugins/datatables/media/js/jquery.dataTables.min', 'global/plugins/datatables/plugins/bootstrap/dataTables.bootstrap', 'global/plugins/bootbox/bootbox.min']; $response['blade_custom_css'] = $customCSS; $response['blade_custom_js'] = $customJS; $response['pageTitle'] = trans('global.users_list'); return Theme::view('users.list_users', $response); }
public function index() { $customCSS = []; $customJS = ['global/plugins/flot/jquery.flot', 'global/plugins/flot/jquery.flot.resize', 'global/plugins/flot/jquery.flot.categories', 'admin/pages/scripts/ecommerce-index']; $response = ['blade_custom_css' => $customCSS, 'blade_custom_js' => $customJS]; $response['total_sales'] = intval(Model_Orders::getTotalSales()); $response['count_sales'] = intval(Model_Orders::getCountSales()); $response['avg_sales'] = intval(Model_Orders::getAvgSales()); if (!empty($last_orders = Model_Orders::getOrders(FALSE, TRUE, FALSE, 0, 20))) { foreach ($last_orders as $key => $order) { $response['last_orders'][$key]['id'] = $order['id']; $response['last_orders'][$key]['first_name'] = $order['name']; $response['last_orders'][$key]['last_name'] = $order['last_name']; $response['last_orders'][$key]['created_at'] = date('d.m.Y H:i', strtotime($order['created_at'])); $response['last_orders'][$key]['status'] = trans('dashboard.' . $order['status']); switch ($order['status']) { case 'pending': $response['last_orders'][$key]['status_color'] = 'bg-yellow-lemon'; break; case 'confirmed': $response['last_orders'][$key]['status_color'] = 'bg-blue-madison'; break; case 'completed': $response['last_orders'][$key]['status_color'] = 'bg-green-jungle'; break; case 'canceled': $response['last_orders'][$key]['status_color'] = 'bg-red-flamingo'; break; } } } if (!empty($last_users = Model_Users::getUsers(FALSE, FALSE, 0, 20))) { if (!empty($users_data = Model_Users::getUsersData(['first_name', 'last_name'], 0, 20))) { //Merge users and users data foreach ($last_users as $key => $user) { $user_id = $user['id']; foreach ($user as $user_info_key => $user_info) { //Do not pass sensitive data to view if ($user_info_key != 'password' && $user_info_key != 'remember_token' && $user_info_key != 'updated_at' && $user_info_key != 'last_login') { $response['last_users'][$user_id][$user_info_key] = $user_info; } } } foreach ($users_data as $key => $data) { $response['last_users'][$data['user_id']][$data['object']] = $data['value']; } } } if (!empty($response['last_orders'])) { $response['last_orders_count'] = count($response['last_orders']); } if (!empty($response['last_users'])) { $response['last_users_count'] = count($response['last_users']); } $date_seven_days_ago = date('Y-m-d 00:00:00', strtotime('-6 days')); $last_seven_days_orders = Model_Orders::getOrders(FALSE, TRUE, FALSE, 0, 0, $date_seven_days_ago, date('Y-m-d H:i:s', time())); $count = 1; $response['graph'][date('d.m', time())] = 0.0; $response['graph2'][date('d.m', time())] = 0; while ($count < 7) { $date = date('d.m', strtotime('-' . $count . ' days')); $response['graph'][$date] = 0.0; $response['graph2'][$date] = 0; $count++; } if (!empty($last_seven_days_orders) && is_array($last_seven_days_orders)) { foreach ($last_seven_days_orders as $key => $order) { $date = date('d.m', strtotime($order['created_at'])); $amount = Model_Orders::getTotalSales($order['id']); $response['graph'][$date] = $response['graph'][$date] + $amount; $response['graph2'][$date] = $response['graph2'][$date] + 1; } } //Sort by date ksort($response['graph']); ksort($response['graph2']); // dd($response['graph']); return Theme::view('dashboard.index', $response); }