vendredi 13 septembre 2019

date checking for method update()

My function store() works, but I dont' know how to adapt in my method update() ??

$conflictTraining = Training::where('fk_motorbike', $request->get('fk_motorbike'))
        ->whereDate('date_seance', "=" , $date_revision_start)
        ->where('hour_start', "<=" , $request->get('hour_start')) 
        ->where('hour_end', ">=" , $request->get('hour_end'))
        ->first();

$conflictTraining2 = Training::where('fk_motorbike', $request->get('fk_motorbike'))
        ->whereDate('date_seance', "=" , $date_revision_end)
        ->where('hour_start', "<=" , $request->get('hour_start')) 
        ->where('hour_end', ">=" , $request->get('hour_end'))
        ->first();

Here is an idea of my function update(), but it's doesn't good...

$conflictTraining = Training::where('id', '!=', $id)
        ->where('fk_motorbike', $request->get('fk_motorbike'))
        ->whereDate('date_seance', "=" , $date_revision_start)
        ->where('hour_start', "<=" , $request->get('hour_start')) 
        ->first();

        $conflictTraining2 = Training::where('fk_motorbike', $request->get('fk_motorbike'))
        ->whereDate('date_seance', "=" , $date_revision_end)
        ->where('hour_end', ">=" , $request->get('hour_end'))
        ->first();

if( (isset($conflictTraining2) && $conflictTraining2->id !== intval($id))
        || (isset($conflictTraining) && $conflictTraining->id !== intval($id)) ){
            return redirect()->route('revisions.index')
             ->with('error', 'date duplicate ');
        }



from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2ZYwJxE
via IFTTT

Aucun commentaire:

Enregistrer un commentaire