Laravel根据字段值null或存在的条件进行雄辩的模型更新 [英] Laravel Eloquent model update according to condition of field value null or existing
本文介绍了Laravel根据字段值null或存在的条件进行雄辩的模型更新的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试像这样更新Laravel Eloquent模型.
I am trying to update Laravel Eloquent model like this.
Res_Reservations::where('time_id', $time['id'])
->where('date', $bus['date'])
->where('valid', config('config.TYPE_SCHEDULE_UNREMOVED'))
->where(function($query) use($time, $notesAdd) {
$query->whereNull('reason', function($query) use ($time, $notesAdd) {
return $query->update([
'time_id' => $time['move'],
'reason' => $notesAdd
]);
})
->orWhere('reason', '=', '', function($query) use ($time, $notesAdd) {
return $query->update([
'time_id' => $time['move'],
'reason' => $notesAdd
]);
})
->orWhere('reason', '<>', '', function($query) use ($time, $notesAdd) {
return $query->update([
'time_id' => $time['move'],
'reason' => DB::raw("CONCAT(reason, \r\n'" . $notesAdd . "')")
]);
});
});
但是它不起作用.
换句话说,我想更新如下.
In other words, I want to update as below.
-
如果原因"为null或空字符串
if 'reason' is null or emptystring
Res_Reservations::where('time_id', $time['id'])
->where('date', $bus['date'])
->where('valid', config('config.TYPE_SCHEDULE_UNREMOVED'))
->update([
'time_id' => $time['move'],
'reason' => $notesAdd
]);
其他
else
Res_Reservations::where('time_id', $time['id'])
->where('date', $bus['date'])
->where('valid', config('config.TYPE_SCHEDULE_UNREMOVED'))
->update([
'time_id' => $time['move'],
'reason' => DB::raw("CONCAT(reason, '\r\n" . $notesAdd . "')")
]);
我的错误是什么?如何使语句更简单?请让我知道〜
What is my mistake? And how can I make statements simpler? Please let me know~
推荐答案
在where
函数的回调内部使用update
函数是错误的
It is wrong to use update
function inside the callback of where
function
您必须在2个查询中执行此操作,例如:
You have to do it in 2 queries like:
Res_Reservations::where('time_id', $time['id'])
->where('date', $bus['date'])
->where('valid', config('config.TYPE_SCHEDULE_UNREMOVED'))
->where(function ($query
{
$query->where('reason', null)
->orWhere('reason', '');
})
->update([
'time_id' => $time['move'],
'reason' => $notesAdd,
]);
Res_Reservations::where('time_id', $time['id'])
->where('date', $bus['date'])
->where('valid', config('config.TYPE_SCHEDULE_UNREMOVED'))
->where('reason', '!=', null)
->where('reason', '!=' '');
->update([
'time_id' => $time['move'],
'reason' => DB::raw('CONCAT(reason, "\r\n' . $notesAdd . '")'),
]);
这篇关于Laravel根据字段值null或存在的条件进行雄辩的模型更新的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文