这是一个对大家来说很有趣的事情。我发现自己陷入了实施难题。我正在 Laravel 中开发一个预订应用程序，允许人们在特定时间预订空间的房间和设备。可用设备的数量有限，因此必须根据与预订相关的时段来查询库存量。我以为我已经通过迭代同时发生的“其他预订”并计算当前正在使用的物品来解决问题 -> 然后对照库存中的可用物品进行检查。对于我 90% 的测试来说，这工作得很好，但我刚刚发现了一个不允许我这样做的错误。 $guitarheadcount = 0; $guitarcabcount = 0; $guitarcombocount = 0; $bassheadcount = 0; $basscabcount = 0; $basscombocount = 0; $drumkitcount = 0; $cymbalscount = 0; $otherbookings = Booking::where('Room_id', '!=', $bookinginfo->Room_id) ->where(function ($query) use ($begin, $end) { $query->where(function ($q) use ($begin, $end) { $q->where('Booking_start', '>=', $begin) ->where('Booking_start', '<', $end); })->orWhere(function ($q) use ($begin, $end) { $q->where('Booking_start', '<=', $begin) ->where('Booking_end', '>', $end); })->orWhere(function ($q) use ($begin, $end) { $q->where('Booking_end', '>', $begin) ->where('Booking_end', '<=', $end); })->orWhere(function ($q) use ($begin, $end) { $q->where('Booking_start', '>=', $begin) ->where('Booking_end', '<=', $end); }); })->get(); }然后，如果计数最终大于库存量，我使用单独的 if 语句来重定向。实际错误的一个示例是：2 套鼓有库存。预订一个下午 1-2 点的房间……然后在同一房间预订另一个下午 2-3 点的房间。两者都需要鼓组。如果我随后尝试在下午 1 点到 3 点之间在不同的空间进行预订，即使一组鼓再次空闲（如果这有意义），计数也已经是 2。我真的很困惑。我无法想象我是否需要：继续“计数”，但生成一些东西，为与另一个（？）位于同一房间的每件物品扣除 1。我是否应该完全放弃计数并为每个设备项目编写单独的查询......以及我什至会如何做到这一点！任何帮助将非常感激。
2 回答
达令说
TA贡献1821条经验 获得超6个赞
尽管我之前的答案中的方法看起来很有希望......但随着库存量和相邻预订的增加，它开始出现无法修复的计数错误。
我重新思考并设计了更好的解决方案。无论如何，用户只能预订至少 30 分钟的时段。
因此，使用 do/while 循环，对于用户选择的时间段每增加 30 分钟，它将执行一次库存检查。
我确信敲打服务器并不是一件好事，但至少在预订期间会有固定的时间来查询它。
///STOCK CHECK
$stockcheckbegin = $begin;
$stockcheckend = date("Y-m-d H:i", strtotime('+30 minutes',strtotime($begin)));
$tempguitarheadcount = 0;
$tempguitarcabcount = 0;
$tempguitarcombocount = 0;
$tempbassheadcount = 0;
$tempbasscabcount = 0;
$tempbasscombocount = 0;
$tempdrumkitcount = 0;
$tempcymbalscount = 0;
do {
$otherbookings = Booking::orderby('Booking_start', 'ASC')
->where(function ($query) use ($stockcheckbegin, $stockcheckend) {
$query->where(function ($q) use ($stockcheckbegin, $stockcheckend) {
$q->where('Booking_start', '>=', $stockcheckbegin)
->where('Booking_start', '<', $stockcheckend);
})->orWhere(function ($q) use ($stockcheckbegin, $stockcheckend) {
$q->where('Booking_start', '<=', $stockcheckbegin)
->where('Booking_end', '>', $stockcheckend);
})->orWhere(function ($q) use ($stockcheckbegin, $stockcheckend) {
$q->where('Booking_end', '>', $stockcheckbegin)
->where('Booking_end', '<=', $stockcheckend);
})->orWhere(function ($q) use ($stockcheckbegin, $stockcheckend) {
$q->where('Booking_start', '>=', $stockcheckbegin)
->where('Booking_end', '<=', $stockcheckend);
});
})->get();
foreach($otherbookings as $other){
$tempguitarheadcount = $tempguitarheadcount + $other->Equip->guitarheadamount;
$tempguitarcabcount = $tempguitarcabcount + $other->Equip->guitarcabamount;
$tempguitarcombocount = $tempguitarcombocount + $other->Equip->guitarcomboamount;
$tempbassheadcount = $tempbassheadcount + $other->Equip->bassheadamount;
$tempbasscabcount = $tempbasscabcount + $other->Equip->basscabamount;
$tempbasscombocount = $tempbasscombocount + $other->Equip->basscomboamount;
$tempdrumkitcount = $tempdrumkitcount + $other->Equip->drumkitamount;
$tempcymbalscount = $tempcymbalscount + $other->Equip->cymbalsamount;
if(($currenthireprices->guitarheadstock - ($guitarheadamount + $tempguitarheadcount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Sorry! Our 'Guitar Head' stock will run out during the course of this booking. (Between $stockcheckbegin and $stockcheckend)");
}
if(($currenthireprices->guitarcabstock - ($guitarcabamount + $tempguitarcabcount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Sorry! Our 'Guitar Cab' stock will run out during the course of this booking. (Between $stockcheckbegin and $stockcheckend)");
}
if(($currenthireprices->guitarcombostock - ($guitarcomboamount + $tempguitarcombocount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Sorry! Our 'Guitar Combo' stock will run out during the course of this booking. (Between $stockcheckbegin and $stockcheckend)");
}
if(($currenthireprices->bassheadstock - ($bassheadamount + $tempbassheadcount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Sorry! Our 'Bass Head' stock will run out during the course of this booking. (Between $stockcheckbegin and $stockcheckend)");
}
if(($currenthireprices->basscabstock - ($basscabamount + $tempbasscabcount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Sorry! Our 'Bass Cab' stock will run out during the course of this booking. (Between $stockcheckbegin and $stockcheckend)");
}
if(($currenthireprices->basscombostock - ($basscomboamount + $tempbasscombocount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Sorry! Our 'Bass Combo' stock will run out during the course of this booking. (Between $stockcheckbegin and $stockcheckend)");
}
if(($currenthireprices->drumkitstock - ($drumkitamount + $tempdrumkitcount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Sorry! Our 'Drum kit' stock will run out during the course of this booking. (Between $stockcheckbegin and $stockcheckend)");
}
if(($currenthireprices->cymbalsstock - ($cymbalsamount + $tempcymbalscount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Sorry! Our sets of 'Cymbals' stock will run out during the course of this booking. (Between $stockcheckbegin and $stockcheckend)");
}
}
$tempguitarheadcount = 0;
$tempguitarcabcount = 0;
$tempguitarcombocount = 0;
$tempbassheadcount = 0;
$tempbasscabcount = 0;
$tempbasscombocount = 0;
$tempdrumkitcount = 0;
$tempcymbalscount = 0;
$stockcheckbegin = date("Y-m-d H:i", strtotime('+30 minutes',strtotime($stockcheckbegin)));
$stockcheckend = date("Y-m-d H:i", strtotime('+30 minutes',strtotime($stockcheckend)));
} while ($stockcheckbegin != $end);
if(($currenthireprices->guitarheadstock - ($guitarheadamount + $guitarheadcount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Unfortunatly there aren't $guitarheadamount guitar heads available between $timestart and $timeend. There's $currenthireprices->guitarheadstock in stock and $guitarheadcount in use.");
}
if(($currenthireprices->guitarcabstock - ($guitarcabamount + $guitarcabcount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Unfortunatly there aren't $guitarcabamount 'Guitar cabs' available between $timestart and $timeend. There's $currenthireprices->guitarcabstock in stock and $guitarcabcount in use.");
}
if(($currenthireprices->guitarcombostock - ($guitarcomboamount + $guitarcombocount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Unfortunatly there aren't $guitarcomboamount 'Guitar combos' available between $timestart and $timeend. There's $currenthireprices->guitarcombostock in stock and $guitarcombocount in use.");
}
if(($currenthireprices->bassheadstock - ($bassheadamount + $bassheadcount)) < 0) {
return redirect()->back()->withInput()->with('Booking_query_error', "Unfortunatly there aren't $bassheadamount 'Bass heads' available between $timestart and $timeend. There's $currenthireprices->bassheadstock in stock and $bassheadcount in use.");
}
if(($currenthireprices->basscabstock - ($basscabamount + $basscabcount)) < 0) {
return redirect()->back()->withInput()->with('Booking_query_error', "Unfortunatly there aren't $basscabamount 'Bass cabs' available between $timestart and $timeend. There's $currenthireprices->basscabstock in stock and $basscabcount in use.");
}
if(($currenthireprices->basscombostock - ($basscomboamount + $basscombocount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Unfortunatly there aren't $basscomboamount 'Bass combos' available between $timestart and $timeend. There's $currenthireprices->basscombostock in stock and $basscombocount in use.");
}
if(($currenthireprices->drumkitstock - ($drumkitamount + $drumkitcount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Unfortunatly there aren't $drumkitamount 'Drum kits' available between $timestart and $timeend. There's $currenthireprices->drumkitstock in stock and $drumkitcount in use.");
}
if(($currenthireprices->cymbalsstock - ($cymbalsamount + $cymbalscount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Unfortunatly there aren't $cymbalsamount 'sets of cymbals' available between $timestart and $timeend. There's $currenthireprices->cymbalsstock in stock and $cymbalscount in use.");
}
//----- END OF STOCK CHECK
慕娘9325324
TA贡献1783条经验 获得超4个赞
我将进一步测试这一点，但我想我可能已经找到了解决方案。
我已经拥有的：
一种在选定时间范围内获取所有冲突预订的机制。它可以提供集合中包含的所有项目的计数。它不“知道”的是在预订过程中，库存是否会被用完。
解决方案（到目前为止，早期测试正在发挥作用）。
我使用 orderBy 按开始时间对原始查询结果进行排序。
我使用 foreach 来循环遍历它们。
我在循环之外定义了几个数组，可以使用它们将先前循环的属性传递回下一个循环。如果没有发现计数错误，则在最后覆盖。
然后我创建了一些 if 语句来检查下一个预订与上一个预订。
如果下一个开始是在上一个结束之前，那么我会创建另一个数组来将当前值传递到其中，并在 if 内为每个数组启动另一个数组，然后重新计算该时间范围内的所有预订。如果计数再次超过该时间内的可用库存，它就会爆发并重定向。
当该循环完成后，我们继续前一个循环。
对意大利面条代码表示歉意。
$first = $otherbookings->first();
if ($first == null){
}else{
$previous = [];
$previous ['id'] = $first->id;
$previous ['Booking_end'] = $first->Booking_end;
}
$tempdrumkitcount = 0;
foreach($otherbookings as $other){
if($previous ['id'] == $other->id){
$drumkitcount = (int)$first->Equip->drumkitamount;
//check
if(($currenthireprices->drumkitstock - ($other->drumkitamount + $drumkitcount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Check 1 error");
}
}
else{
if($previous ['Booking_end'] > $other->Booking_start){
$current ['id'] = $other->id;
$current ['Booking_start'] = $other->Booking_start;
$current ['Booking_end'] = $other->Booking_end;
foreach($otherbookings as $newother){
if($newother->id != $current ['id']){
if(($newother->Booking_start < $current ['Booking_start']) && ($newother->Booking_end > $current ['Booking_start'] )){
$tempdrumkitcount = $tempdrumkitcount + $newother->Equip->drumkitamount;
}
if(($newother->Booking_start > $current ['Booking_start']) && ($newother->Booking_end < $current ['Booking_end'] )){
$tempdrumkitcount = $tempdrumkitcount + $newother->Equip->drumkitamount;
}
if(($currenthireprices->drumkitstock - ($drumkitamount + $tempdrumkitcount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Unfortunatly there aren't $drumkitamount 'Drum kits' available between $timestart and $timeend to complete your booking. (Error- 100 [Cummalative Check]).");
}
}
}
$drumkitcount = $other->Equip->drumkitamount + $drumkitcount;
if(($currenthireprices->drumkitstock - ($drumkitamount + $drumkitcount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Unfortunatly there aren't $drumkitamount 'Drum kits' available between $timestart and $timeend to complete your booking. (Error- 150 [Non-Cummalative Check]).");
}
$drumkitcount = $drumkitcount - $previous ['drumkitamount'];
}
if($previous ['Booking_end'] <= $other->Booking_start){
$drumkitcount = $drumkitcount - $previous ['drumkitamount'];
$drumkitcount = $drumkitcount + $other->Equip->drumkitamount;
if(($currenthireprices->drumkitstock - ($drumkitamount + $drumkitcount)) < 0){
return redirect()->back()->withInput()->with('Booking_query_error', "Unfortunatly there aren't $drumkitamount 'Drum kits' available between $timestart and $timeend to complete your booking. (Error- 200 [Non-overlap main check]).");
}
}
}
$previous ['id'] = $other->id;
$previous ['Booking_end'] = $other->Booking_end;
$previous ['drumkitamount'] = $other->Equip->drumkitamount;
}
- 2 回答
- 0 关注
- 70 浏览
添加回答
举报
0/150
提交
取消