英文:
Get records between two columns using range between two dates, Also search filter criteria
问题
**我想要获取在这个日期区间内（2022-02-15，2022-08-20）加入的记录**$users = User::whereDate('start_at', '>=', $startDate)->whereDate('end_at', '<=', $endDate)->get();
英文:
I want to get records that are joined between this date period (2022-02-15, 2022-08-20)
$users = User::whereDate('start_at', '>=', $startDate)->whereDate('end_at', '<=', $endDate)->get();
答案1
得分: 1
您可以使用Laravel的whereBetween函数：
$users = User::whereBetween('start_at', [ $startDate, $endDate])->get();
注意 $startDate和$endDate必须是Carbon的实例。
$startDate = new Carbon('paste_your_start_date')->format('Y-m-d')." 00:00:00";
更新
这是从两个分开的列获取数据的一种方法。示例未经测试。
$start_at = Carbon::createFromFormat('Y-m-d H', '2022-02-15 0')->toDateString();$end_at = Carbon::createFromFormat('Y-m-d H', '2022-08-20 0')->toDateString();$users = User::whereRaw("start_at <= date('$start_at')")->whereRaw("end_at >= date('$end_at')")->get();
英文:
You can use the whereBetween Laravel function:
$users = User::whereBetween('start_at', [ $startDate, $endDate])->get();
Note $startDate and $endDate must be instance of Carbon.
$startDate = new Carbon('paste_your_start_date')->format('Y-m-d')." 00:00:00";
Update
This would be one method to get data from two seperated columns. Example is not tested.
$start_at = Carbon::createFromFormat('Y-m-d H', '2022-02-15 0')->toDateString();$end_at = Carbon::createFromFormat('Y-m-d H', '2022-08-20 0')->toDateString();$users = User::whereRaw("start_at <= date('$start_at')")->whereRaw("end_at >= date('$end_at')")->get();
答案2
得分: 1
Sure, here is the translated code:
$_start_date = '2022-02-15';$_end_date = '2022-08-20';$users = User::where(function ($query) use ($_start_date, $_end_date) {$query->where(function ($query) use ($_start_date, $_end_date) {$query->whereRaw("start_date >= date('$_start_date')")->whereRaw("end_date <= date('$_end_date')");})->orWhere(function ($query) use ($_start_date, $_end_date) {$query->whereRaw("start_date <= date('$_start_date')")->whereRaw("end_date >= date('$_end_date')");});})->get();
This code filters the users based on the date range specified by $_start_date and $_end_date. The whereRaw method is used to construct raw SQL queries for date comparisons within the specified range.
英文:
$_start_date = '2022-02-15';$_end_date ='2022-08-20';$users = User::where(function ($query) use ($_start_date, $_end_date) {$query->where(function ($query) use ($_start_date, $_end_date) {$query->whereRaw("start_date >= date('$_start_date')")->whereRaw("end_date <= date('$_end_date')");})->orwhere(function ($query) use ($_start_date, $_end_date) {$query->whereRaw("start_date <= date('$_start_date')")->whereRaw("end_date >= date('$_end_date')");});})->get();
try above code this will also return between dates of start_date and end _date e.g below
$_start_date = '2022-02-18';$_end_date ='2022-08-20';
and also works with below dates e.g
$_start_date = '2022-02-16';$_end_date ='2022-08-18';
codes look like this in ide
答案3
得分: 0
根据你的具体需求而定User::whereDate('start_date', '>=', $startDate)->where('end_date', '<=', $endDate)->get();或者User::whereDate('start_date', '<', $User)->whereDate('end_date', '>', $startDate)->get();
英文:
Depends on what you need exactly
User::whereDate('start_date', '>=', $startDate)->where('end_date', '<=', $endDate)->get();
or
User::whereDate('start_date', '<', $User)->whereDate('end_date', '>', $startDate)->get();
答案4
得分: 0
我认为您想要获取从start_date到end_date之间至少存在一天的记录，这些记录存在于2022年2月15日到2022年8月20日之间：
$startDate = '2022-02-15';$endDate = '2022-08-20';$users = User::whereDate('start_at', '<=', $endDate)->whereDate('end_at', '>=', $startDate)->get();
英文:
I think you want to get the records that at least one day from start_date to end_date that exists between 2022-02-15 and 2022-08-20:
$startDate = '2022-02-15';$endDate = '2022-08-20';$users = User::whereDate('start_at', '<=', $endDate) // where or whereDate also should work->whereDate('end_at', '>=', $startDate)->get();
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论