本文整理匯總了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);
}