本文整理汇总了PHP中app\Task::whereRaw方法的典型用法代码示例。如果您正苦于以下问题：PHP Task::whereRaw方法的具体用法？PHP Task::whereRaw怎么用？PHP Task::whereRaw使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类app\Task的用法示例。
在下文中一共展示了Task::whereRaw方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: scopeGetTasks
public function scopeGetTasks($query)
{
$task_total = Task::whereRaw('task_type_id = ?', array($this->id))->get();
return $task_total;
}示例2: getDashBoard
/**
* 仪表盘
* @param Request $request
* @return mixed
* @author AndyLee <root@lostman.org>
*/
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);
}