I yet have a problem with my planning. My frist model is Revision with as informations following:
The date_revision_start on 12/09/2019 to 14/09/2019 then hour_start & hour_end from 07:00 to 09:00 and the bike 000001.
Below, I have no problem...
Now, in my model Training if I want to enter a training on 14/09/2019 from 10:00 to 12:00 for the bike 000001.
I have an error message ?? Normally, the recording is correct...
Do you have an idea for better compare my hour_start & hour_end?
$date_seance = $request->get('date_seance');
$hour_start = $request->get('hour_start');
$hour_end = $request->get('hour_end');
$fk_motorbike = $request->get('fk_motorbike');
$fk_student = $request->get('fk_student');
$fk_former = $request->get('fk_former');
$fk_typeseance = $request->get('fk_typeseance');
$conflictTraining = Training::where('fk_motorbike', $request->get('fk_motorbike'))
->whereDate('date_seance', "=" , $date_seance)
->where('hour_start', "<=" , $request->get('hour_start'))
->where('hour_end', ">=" , $request->get('hour_end'))
->where('fk_former', $request->get('fk_former'))
->first();
$conflictRevision = Revision::where('fk_motorbike', $fk_motorbike)
->whereDate('date_revision_start', "<=" , $date_seance)
->whereDate('date_revision_end', ">=", $date_seance)
->first();
$conflictRevision1 = Revision::where('fk_motorbike', $fk_motorbike)
->whereDate('date_revision_start', "<=" , $date_seance)
->where('hour_start', "<=" , $request->get('hour_start'))
->where('hour_end', ">=" , $request->get('hour_end'))
->first();
$conflictRevision2 = Revision::where('fk_motorbike', $fk_motorbike)
->whereDate('date_revision_end', "<=" , $date_seance)
->where('hour_start', "<=" , $request->get('hour_start'))
->where('hour_end', ">=" , $request->get('hour_end'))
->first();
$conflictFormer = Training::where('fk_former', $fk_former)
->whereDate('date_seance', "=" , $date_seance)
->where('hour_start', "<=" , $request->get('hour_start'))
->where('hour_end', ">=" , $request->get('hour_end'))
->first();
$conflictMotorbike = Training::where('fk_motorbike', $fk_motorbike)
->whereDate('date_seance', "=" , $date_seance)
->where('hour_start', "<=" , $request->get('hour_start'))
->where('hour_end', ">=" , $request->get('hour_end'))
->first();
Thank you for your help and your time.
via Chebli Mohamed



Aucun commentaire:
Enregistrer un commentaire