public function scopeGetTasks($query) { $task_total = Task::whereRaw('task_type_id = ?', array($this->id))->get(); return $task_total; }
/** * 仪表盘 * @param Request $request * @return mixed * @author AndyLee <*****@*****.**> */ public function getDashBoard(Request $request) { if (!$request->session()->has('company_id')) { $request->session()->flash('error', '请先选择一个代帐公司'); return redirect()->to('/'); } $today_start = strtotime(date('Y-m-d', time()) . ' 00:00:00'); $today_end = strtotime(date('Y-m-d', time()) . ' 23:59:59'); /** * 获取公司 */ $customers = CustomerCompany::where('user_id', $request->session()->get('company_id')); $count = $customers->count(); $new_customer = CustomerCompany::where('user_id', $request->session()->get('company_id'))->whereBetween('create_time', array($today_start, $today_end))->count(); $month_begin = mktime(0, 0, 0, date('m'), 1, date('Y')); $month_end = mktime(23, 59, 59, date('m'), date('t'), date('Y')); /** * 获取todo */ $count_task = Task::where('user_id', $request->session()->get('company_id'))->count(); $finish = Task::whereRaw('user_id = ? and is_finish = ?', [$request->session()->get('company_id'), 1])->whereBetween('finish_time', array($month_begin, $month_end))->count(); $order = $customers->orderBy('last_active_time', 'desc')->take(10)->get(); return view('dashboard')->with('count', $count)->with('new', $new_customer)->with('tasks', $count_task)->with('order', $order)->with('finish', $finish); }