如何获取laravel中两个日期之间的记录

Question

如何在不使用Query之间获取laravel中两个日期之间的记录。

我使用以下查询来过滤记录。只有我发布的数据响应字段，过滤器是最新得到正确records.when后，迄今它没有得到任何record.what的我的错误..

$q = Telecallerverification::query(); 

     $usersid = Auth::user()->id; 

     $q->Where('created_by',$usersid); 

     if ($request->input('frmdate_submit')) 
     { 
      $q->whereDate('created_at','<=',$request->input('frmdate_submit')); 
     } 

     if ($request->input('todate_submit')) 
     { 
      $q->whereDate('created_at','>=',$request->input('todate_submit')); 
     } 

     if ($request->input('response')) 
     { 
      $q->Where('leadsresponse',$request->input('response')); 
     } 

     $telecallerverifications = $q->orderBy('id','DESC')->paginate(25); 

Answer 1

试试这个。希望它能帮助你。

$q = Telecallerverification::query(); 

    $usersid = Auth::user()->id; 

    $q->Where('created_by',$usersid); 

    if($request->input('frmdate_submit') && $request->input('todate_submit')){ 
     $q->whereBetween('created_at',array($request->input('frmdate_submit'),$request->input('todate_submit'))) 
    } 
    else if ($request->input('frmdate_submit')) 
    { 
     $q->whereDate('created_at','<=',$request->input('frmdate_submit')); 
    } 

    else if ($request->input('todate_submit')) 
    { 
     $q->whereDate('created_at','>=',$request->input('todate_submit')); 
    } 

    else if ($request->input('response')) 
    { 
     $q->Where('leadsresponse',$request->input('response')); 
    } 

    $telecallerverifications = $q->orderBy('id','DESC')->paginate(25);