Update data but getting duplicate laravel

Question

i want update this data but unit id, rute asal and rute tujuan cant be duplicate.. in my case, i only want update biaya pengantaran but getting message data is duplicate (even though it's the data itself). can u solve my problem? sorry for my broken english

  public function update(Request $request, $id)
{
    $request->validate(
        [
            'unit_id' => 'required',
            'rute_asal' => 'required|regex:/^[\pL\s\-]+$/u',
            'rute_tujuan' => 'required|regex:/^[\pL\s\-]+$/u',
            'biaya_pengantaran' => 'required|numeric',
        ],
        [
            'unit_id.required' => 'Unit tidak boleh kosong!',
            'rute_asal.required' => 'Rute asal tidak boleh kosong!',
            'rute_tujuan.required' => 'Rute tujuan tidak boleh kosong!',
            'biaya_pengantaran.required' => 'Biaya pengantaran tidak boleh kosong!',
            'rute_asal.regex' => 'Rute asal tidak valid!',
            'rute_tujuan.regex' => 'Rute tujuan tidak valid!',
            'biaya_pengantaran.numeric' => 'Biaya pengantaran harus berupa angka!'
        ]
    );

    $unit = $request->unit_id;
    $asal = $request->rute_asal;
    $tujuan = $request->rute_tujuan;
    $cek = BiayaPengantaran::where(['unit_id' => $unit, 'rute_asal' => $asal, 'rute_tujuan' =>  $tujuan])->first();

    $biaya = BiayaPengantaran::find($id);

    if (!$cek) {
        $biaya->update([
            'unit_id' => $request->unit_id,
            'rute_asal' => $request->rute_asal,
            'rute_tujuan' => $request->rute_tujuan,
            'biaya_pengantaran' => $request->biaya_pengantaran,
        ]);
        return redirect('/biaya_pengantaran')->with([
            'message' => 'Data berhasil diperbarui',
            'success' => true
        ]);
    } else {
        throw ValidationException::withMessages([
            'unit_id' => 'Biaya pengantaran untuk unit dan rute pengantaran ini sudah diinputkan!',
            'rute_asal' => 'Rute asal untuk unit dan rute pengantaran ini sudah diinputkan!',
            'rute_tujuan' => 'Rute tujuan untuk unit dan rute pengantaran ini sudah diinputkan!'
        ]);
    }
}

You likely want to use the unique validation rule.

Peppermintology
– Peppermintology

2022-07-02 09:01:48 +00:00
Commented Jul 2, 2022 at 9:01 — Peppermintology
– Peppermintology, Commented Jul 2, 2022 at 9:01
@Peppermintology case closed bro. thank you for ur respond

Arya Rizky Sandi
– Arya Rizky Sandi

2022-07-02 09:15:18 +00:00
Commented Jul 2, 2022 at 9:15 — Arya Rizky Sandi
– Arya Rizky Sandi, Commented Jul 2, 2022 at 9:15

N69S · Accepted Answer · 2022-07-02 09:05:08Z

1

Make an exception in your check to the current ID

 $cek = BiayaPengantaran::where(['unit_id' => $unit, 'rute_asal' => $asal, 'rute_tujuan' =>  $tujuan])
    ->where('id', '!=', $id)
    ->first();

answered Jul 2, 2022 at 9:05

N69S

17.3k4 gold badges25 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update data but getting duplicate laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related