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);
}
