有什么方法可以顯示所有日期，包括周末和所有開始和結束的日期這是代碼if(request()->ajax()) { if(!empty($request->from_date)) { $data = DB::table('Checkinout') ->join('Z_MemRecord','Checkinout.Userid','=','Z_MemRecord.uid') ->select(DB::raw("FORMAT(MIN (Checkinout.CheckTime), 'hh:mm tt') AS Ontime, FORMAT (max(Checkinout.CheckTime), 'hh:mm tt') AS OffTime, Checkinout.Userid,Z_MemRecord.Uname,FORMAT (Checkinout.CheckTime, 'MMM dd yyyy') as dates,FORMAT (Checkinout.CheckTime, 'dddd') as hour")) ->where('Checkinout.CheckTime', '>', $request->from_date)->where('Checkinout.CheckTime', '<=', $request->to_date) ->groupBy(DB::raw("Convert(Date, Checkinout.CheckTime),Checkinout.Userid,Z_MemRecord.Uname,FORMAT(Checkinout.CheckTime, 'MMM dd yyyy'),FORMAT (Checkinout.CheckTime, 'dddd')")) ->orderbyRaw('Convert(Date, Checkinout.CheckTime) desc') ->get(); }不顯示 2019 年 1 月 10 日。
2 回答
慕田峪7331174
TA貢獻1828條經驗 獲得超13個贊
這是更新的查詢。你需要做這樣的事情
if(request()->ajax())
{
if(!empty($request->from_date))
{
$data = DB::table('Checkinout')
->join('Z_MemRecord','Checkinout.Userid','=','Z_MemRecord.uid')
->select(DB::raw("FORMAT(MIN (Checkinout.CheckTime), 'hh:mm tt') AS Ontime, FORMAT (max(Checkinout.CheckTime), 'hh:mm tt') AS OffTime, Checkinout.Userid,Z_MemRecord.Uname,FORMAT (Checkinout.CheckTime, 'MMM dd yyyy') as dates,FORMAT (Checkinout.CheckTime, 'dddd') as hour"))
->where(`date('yyyy-mm-dd','Checkinout.CheckTime')`, '>', $request->from_date)->where(`date('yyyy-mm-dd','Checkinout.CheckTime')`, '<=', $request->to_date)
->groupBy(DB::raw("Convert(Date, Checkinout.CheckTime),Checkinout.Userid,Z_MemRecord.Uname,FORMAT(Checkinout.CheckTime, 'MMM dd yyyy'),FORMAT (Checkinout.CheckTime, 'dddd')"))
->orderbyRaw('Convert(Date, Checkinout.CheckTime) desc')
->get();
}
}
呼啦一陣風
TA貢獻1802條經驗 獲得超6個贊
我已經得到了答案
->whereDate('Checkinout.CheckTime', '>=', $request->from_date)->whereDate('Checkinout.CheckTime', '<=',$request->to_date)- 2 回答
- 0 關注
- 145 瀏覽
添加回答
舉報
0/150
提交
取消