public function getIndex() { $profit = 0; $today_date = date('Y-m-d'); $tomorrow = date('Y-m-d', strtotime('+1 day', strtotime($today_date))); $yesterday = date('Y-m-d', strtotime('-1 day', strtotime($today_date))); if (Auth::user()->type == "admin") { $installations = Installation::all(); $installations_today = Installation::where('created_at', '>', $today_date)->where('created_at', '<', $tomorrow)->count(); $installations_minus_1_date = date('Y-m-d', strtotime('-1 day', strtotime($today_date))); $installations_minus_1_day = Installation::where('created_at', '>', $installations_minus_1_date)->where('created_at', '<', $today_date)->count(); $installations_minus_2_date = date('Y-m-d', strtotime('-2 day', strtotime($today_date))); $installations_minus_2_day = Installation::where('created_at', '>', $installations_minus_2_date)->where('created_at', '<', $installations_minus_1_date)->count(); $installations_minus_3_date = date('Y-m-d', strtotime('-3 day', strtotime($today_date))); $installations_minus_3_day = Installation::where('created_at', '>', $installations_minus_3_date)->where('created_at', '<', $installations_minus_2_date)->count(); $installations_minus_4_date = date('Y-m-d', strtotime('-4 day', strtotime($today_date))); $installations_minus_4_day = Installation::where('created_at', '>', $installations_minus_4_date)->where('created_at', '<', $installations_minus_3_date)->count(); $installations_minus_5_date = date('Y-m-d', strtotime('-5 day', strtotime($today_date))); $installations_minus_5_day = Installation::where('created_at', '>', $installations_minus_5_date)->where('created_at', '<', $installations_minus_4_date)->count(); $installations_minus_6_date = date('Y-m-d', strtotime('-6 day', strtotime($today_date))); $installations_minus_6_day = Installation::where('created_at', '>', $installations_minus_6_date)->where('created_at', '<', $installations_minus_5_date)->count(); $installations_active = Installation::where('updated_at', '>', $yesterday)->count(); $facebook = Facebookuser::all(); $facebook_active = Facebookuser::where('updated_at', '>', $yesterday)->count(); } else { foreach (Installation::where('source_id', '=', Auth::user()->id)->where('payed', '=', 'false')->get() as $install) { $created_at = strtotime($install->created_at) + 60 * 60 * 72; if ($created_at < strtotime($install->updated_at)) { $profit++; } } $installations = Installation::where('source_id', '=', Auth::user()->id)->get(); $installations_today = Installation::where('source_id', '=', Auth::user()->id)->where('created_at', '>', $today_date)->where('created_at', '<', $tomorrow)->count(); $installations_minus_1_date = date('Y-m-d', strtotime('-1 day', strtotime($today_date))); $installations_minus_1_day = Installation::where('source_id', '=', Auth::user()->id)->where('created_at', '>', $installations_minus_1_date)->where('created_at', '<', $today_date)->count(); $installations_minus_2_date = date('Y-m-d', strtotime('-2 day', strtotime($today_date))); $installations_minus_2_day = Installation::where('source_id', '=', Auth::user()->id)->where('created_at', '>', $installations_minus_2_date)->where('created_at', '<', $installations_minus_1_date)->count(); $installations_minus_3_date = date('Y-m-d', strtotime('-3 day', strtotime($today_date))); $installations_minus_3_day = Installation::where('source_id', '=', Auth::user()->id)->where('created_at', '>', $installations_minus_3_date)->where('created_at', '<', $installations_minus_2_date)->count(); $installations_minus_4_date = date('Y-m-d', strtotime('-4 day', strtotime($today_date))); $installations_minus_4_day = Installation::where('source_id', '=', Auth::user()->id)->where('created_at', '>', $installations_minus_4_date)->where('created_at', '<', $installations_minus_3_date)->count(); $installations_minus_5_date = date('Y-m-d', strtotime('-5 day', strtotime($today_date))); $installations_minus_5_day = Installation::where('source_id', '=', Auth::user()->id)->where('created_at', '>', $installations_minus_5_date)->where('created_at', '<', $installations_minus_4_date)->count(); $installations_minus_6_date = date('Y-m-d', strtotime('-6 day', strtotime($today_date))); $installations_minus_6_day = Installation::where('source_id', '=', Auth::user()->id)->where('created_at', '>', $installations_minus_6_date)->where('created_at', '<', $installations_minus_5_date)->count(); $installations_active = Installation::where('source_id', '=', Auth::user()->id)->where('updated_at', '>', $yesterday)->count(); $facebook = Facebookuser::where('source_id', '=', Auth::user()->id)->get(); $facebook_active = Facebookuser::where('source_id', '=', Auth::user()->id)->where('updated_at', '>', $yesterday)->count(); } $avarray = $this->getAvstats(); arsort($avarray); $avarray = array_slice($avarray, 0, 10); $osarray = $this->getOsstats(); arsort($osarray); $osarray = array_slice($osarray, 0, 10); return view('admin.index')->with('profit', $profit)->with('today_date', $today_date)->with('installations', $installations)->with('installations_today', $installations_today)->with('installations_minus_1_date', $installations_minus_1_date)->with('installations_minus_1_day', $installations_minus_1_day)->with('installations_minus_2_date', $installations_minus_2_date)->with('installations_minus_2_day', $installations_minus_2_day)->with('installations_minus_3_date', $installations_minus_3_date)->with('installations_minus_3_day', $installations_minus_3_day)->with('installations_minus_4_date', $installations_minus_4_date)->with('installations_minus_4_day', $installations_minus_4_day)->with('installations_minus_5_date', $installations_minus_5_date)->with('installations_minus_5_day', $installations_minus_5_day)->with('installations_minus_6_date', $installations_minus_6_date)->with('installations_minus_6_day', $installations_minus_6_day)->with('installations_active', $installations_active)->with('facebook', $facebook)->with('facebook_active', $facebook_active)->with('avarray', $avarray)->with('osarray', $osarray); }
public function getIndex() { $admin = false; if (Auth::user()->type == "admin") { $admin = true; $facebook_users = Facebookuser::all(); } else { $facebook_users = Facebookuser::where('source_id', '=', Auth::user()->id)->get(); } return view('admin.facebook.index')->with('facebook_users', $facebook_users); }