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

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 关注
- 122 浏览
添加回答
举报