Laravel(New user) : user store function to update() and save() . If not exist save() else Update()

Question

  public function store(Request $request)
    {
        //

        /*$request->validate([
                    'user_id'=>'required',
                    'time_in'=>'required',
                     'log_date'=>'required',
        ]);*/
        //dd($_POST);

        $attendance = new Attendance([
            'user_id' => $request->get('user_id'),
            'location' => $request->get('location'),
            'time_in' =>  date('h:i:s'), /*$request->get('time_in'),*/
            'log_date' => date('Y-m-d')  /* $request->get('log_date')*/

        ]);

       $user=Attendance::where('user_id', $request->get('user_id') && 'log_date', date('Y-m-d'))->first();

if($user == null) {

    $attendance->save();
    return  redirect()
        ->back()
        ->with('success', $request->get('user_id').':  You have clocked in successfully!');

}else{

   /* Attendance::where('user_id', $request->get('user_id') && 'log_date', date('Y-m-d'))->update(
        ['time_out' => date('Y-m-d')]
    );*/

   $attendance->update(['time_out'=> date('Y-m-d')]);

    return  redirect()
        ->back()
        ->with('success', $request->get('user_id').':  You have clocked Out!');


}

Welcome. Can you maybe explain "a little more" what your question is about and what errors you get instead of just dumping your code here? Please read [How to create a Minimal, Reproducible Example](https://stackoverflow.com/help/minimal-reproducible-example) and [How do I ask a good question?](https://stackoverflow.com/help/how-to-ask). — brombeer, Feb 25 '20 at 10:36

score 1 · Answer 1 · answered Feb 25 '20 at 10:54

You need to do the following way:

$user= Attendance::findOrFail($request->get('user_id');

if( !empty( $user )){

    $user->time_out = date('Y-m-d');
    $user->save();
    return  redirect()
    ->back()
    ->with('success', $request->get('user_id').':  You have clocked Out!');
} else {
     $attendance = new Attendance;
     $attendance->user_id = $request->get('user_id');
     $attendance->location = $request->get('location');
     $attendance->time_in =  date('h:i:s');
     attendance->log_date = date('Y-m-d');         
     $attendance->save();

      return  redirect()
    ->back()
    ->with('success', $request->get('user_id').':  You have clocked in successfully!');
}

Thanks for your response. The problem still persists: Here is my form and Js — Dayo, Feb 26 '20 at 09:06

score 0 · Accepted Answer · answered Feb 26 '20 at 20:54

Thanks to everyone that contributed, This worked

public function store(Request $request) {

    $user= Attendance::where(['user_id'=> $request->get('user_id'), 'log_date' => date('Y-m-d')] )->first();
   // $existingLog = Attendance::find($user->id);


    if(!$user){
        Attendance::create(['user_id'=> $request->get('user_id'), 'location'=>$request->get('location'),
            'time_in'=>date('h:i:s'), 'log_date'=>date('Y-m-d')]);

        return  redirect()
            ->back()
            ->with('success', $request->get('user_id').':  You have clocked in successfully!');

    }


    $user->update(['time_out'=> date('h:i:s')]);


    return  redirect()
        ->back()
        ->with('success', $request->get('user_id').':  You have clocked Out!');

}

Laravel(New user) : user store function to update() and save() . If not exist save() else Update()

2 Answers2