Laravel Eloquent 模型根据字段值为空或存在的条件更新 [英] Laravel Eloquent model update according to condition of field value null or existing

问题描述

我正在尝试像这样更新 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, 
'" . $notesAdd . "')")
                        ]);
                    });
                });

但它不起作用.

也就是说，我想更新如下.

In other words, I want to update as below.

• 如果 'reason' 为 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, '
" . $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, "
' . $notesAdd . '")'),
    ]);

这篇关于Laravel Eloquent 模型根据字段值为空或存在的条件更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！