我有一些查询我正在运行，我需要能够将项目推入数组，然后将数组项目分配到该对象的更新查询中。下面是这个函数背后的想法，以及我认为它应该是什么:
"offer_when”: [
{
“when”: “later”,
"offer_end_time": "19:00",
"offer_start_time": "17:00"
},
{
“when”: “tomorrow”,
"offer_end_time": "18:00",
"offer_start_time": "17:00"
}
]
这个想法是，当更新offer_when对象时，我们不只是添加一个，而是根据某些条件添加尽可能多的，例如:
- 如果报价日是明天
- 如果报价日开始时间晚于当前时间等
到目前为止，我可以运行查询，它添加到offer_when对象字段，但它只添加一个值，而不是多个值，这是我需要的。
到目前为止，函数是在foreach循环中，我这样做所有的查询，如下所示:
public function getOffers(Offer $offer)
{
$mytime = Carbon::now('Europe/London');
$currentTime = $mytime->format('H:i');
$today = $mytime->format('m/d/Y');
$day = $mytime->format('l');
$tomorrow = Carbon::now()->addDay(1)->format('l');
$thisDay = strtolower($day);
DB::table('offers')->update(['current_time' => $currentTime]);
DB::table('offers')->update(['current_date' => $today]);
DB::table('offers')->update(['current_day' => $thisDay]);
foreach(Offer::all() as $offerObject){
$when = $offerObject['offer_when'];
$the_days = $offerObject['days'];
$featured = $offerObject['current_date'];
$featured_date = $offerObject['featured_date'];
$start_time = $offerObject['offer_start_time'];
$current_time = $offerObject['current_time'];
$end_time = $offerObject['offer_end_time'];
$whens = array();
$whenDataTomorow =
[
array(
'when' => 'tomorrow',
'start_time' => $start_time,
'end_time' => $end_time
)
];
$whenDataNow =
[
array(
'when' => 'now',
'start_time' => $start_time,
'end_time' => $end_time
)
];
$whenDataLater =
[
array(
'when' => 'later',
'start_time' => $start_time,
'end_time' => $end_time
)
];
$isTomorrow = json_encode($whenDataTomorow);
$isNow = json_encode($whenDataNow);
$isLater = json_encode($whenDataLater);
$offerObject::where('days', 'LIKE', '%' . strtolower($tomorrow) . '%')
->update(['offer_when' => $isTomorrow]);
$offerObject::where('days', 'LIKE', '%' . $thisDay . '%')
->where('current_time', '>', $start_time)
->update(['offer_when' => $isNow]);
$offerObject::where('days', 'LIKE', '%' . $thisDay . '%')
->where('offer_start_time', '>', $current_time)
->update(['offer_when' => $isLater]);
$offerObject::whereBetween('offer_start_time', array('07:00','12:00'))
->update(['types' => 'breakfast']);
$offerObject::whereBetween('offer_start_time', array('11:00','14:00'))
->update(['types' => 'lunch']);
$offerObject::whereBetween('offer_start_time', array('14:00','21:00'))
->update(['types' => 'dinner']);
$offersAll = $offerObject
::where('days', 'LIKE', '%' . $thisDay . '%')
->orWhere('days', 'LIKE', '%' . strtolower($tomorrow) . '%')
->orWhere('featured_date', 'LIKE', '%' . $featured . '%')
->get();
return $offersAll;
}
}
上面的查询工作，我在输出中得到一些东西，它似乎拾取了正确的值，但我需要基于一些报价落入相同查询的事实来工作。这是一次报价的输出:
"offer_when": [
{
"when": "now",
"start_time": "08:50",
"end_time": "08:50"
}
],
但是这个对象字段应该有2个子对象，但我不能得到查询正确做到这一点，我想要的方式。有人能给我指个方向吗?
当您使用$model->update()时，它将覆盖当前值。所以你永远不会有多个孩子。
首先，不要使用json_encode()来存储数组。使用属性强制转换
class Offer extends Model {
// ...
protected $casts = [
'offer_when' => 'array',
];
// ...
}
现在你可以把$offer->offer_when当作一个数组。注意，您不能像$offer->offer_when[0] = 1那样直接修改属性值，这是不可能的，并且系统会抛出异常。你必须获得当前值，操作，并分配回该属性。
$offerWhen = $offer->offer_when;
// Add
$offerWhen[] = [
'when' => 'now',
'start_time' => $start_time,
'end_time' => $end_time,
];
// Remove
unset($offerWhen[0]);
// Finish? Assign back to the attribute
$offer->offer_when = $offerWhen;
$offer->save();
// Or this also works
$offer->update(['offer_when' => $offerWhen]);
我建议使用您的when字段作为易于访问和操作的关键。
// Add
$offerWhen['now'] = [
'when' => 'now',
'start_time' => $start_time,
'end_time' => $end_time,
];
// Remove
unset($offerWhen['now']);