选择没有数组之间的所有日期

Question

有什么方法可以显示所有日期，包括周末和所有开始和结束的日期这是代码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 日。

Answer 1

这是更新的查询。你需要做这样的事情

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

      }

    } 

Answer 2

我已经得到了答案

->whereDate('Checkinout.CheckTime', '>=', $request->from_date)->whereDate('Checkinout.CheckTime', '<=',$request->to_date)