如何获取两个日期范围之间的数据? [英] How to get data between two date range?
本文介绍了如何获取两个日期范围之间的数据?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想从两个不同的日期范围中获取数据.我如何才能做到这一点?我已经尝试过并获取了开始日期的数据.
I want to get the data from two different date range.How can i achive this?I have tried and got the data for starting date.
控制器
public function detail(Request $request,$id)
{
if($request->startdate) {
$advance =Advancepayment::where('date',$request->startdate)->get();
} else {
$advance = Advancepayment::all();
}
return view('admin.managesalary.detail',compact('advance'));
}
刀片文件
<form action="{{route('managesalary.detail',$user->id)}}"
method="GET"
class="form-horizontal"
>
<div class="card-body">
<h4 class="card-title">Search</h4>
<div class="form-group">
<!-- Date Picker -->
<div class="input-group date " id="startDate">
<strong>From</strong>
<input
type='date'
value="{{request()->startdate}}"
name="startdate"
class="form-control"
/>
</div>
<!-- Time Picker -->
<div class="input-group date" id="startTime">
<strong>To</strong>
<input type='date'
value="{{request()->enddate}}"
name="enddate"
class="form-control"
/>
</div>
</div>
</div>
<br><br>
<div class="border-top">
<div class="card-body">
<button type="submit" class="btn btn-success">Search</button>
<a href="{{route('managesalary.detail',$user->id)}}"
class="btn btn-md btn-danger"
>
Clear
</a>
</div>
</div>
</form>
路线
Route::get('managesalary/detail/{id}',[
'as' => 'managesalary.detail',
'uses' => 'ManagesalaryController@detail'
]);
预期结果如下:
推荐答案
让我们将日期范围从去年15/04到今年15/04,代码将类似于
Let's the date range is from last year 15/04 to this year 15/04, the code will be like
$from = date('2018-04-15');
$to = date('2019-04-15');
$advance = Advancepayment::whereBetween('date', [$from, $to])->get();
如果有条件,$ to为空,则可以添加条件
if there is condition the $to is empty you can put a conditional
public function detail(Request $request,$id)
{
$from = $request->input('startdate');
$to = $request->input('enddate');
if ( empty($to) && empty($from) ) {
$advance = Advancepayment::all();
} elseif ( empty($to) && ! empty($from) ) {
$advance = Advancepayment::where('date', $from)->get();
// or Advancepayment::where('date', '>', $from)->get(); depending upon your requirmeent
} else {
$advance = Advancepayment::whereBetween('date', [$from, $to])->get();
}
}
这篇关于如何获取两个日期范围之间的数据?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文