public function destroyAssigment($id) { // $moduleassigment = ModuleAssigment::find($id); $module = Module::find($moduleassigment->module_id); if ($module->openModule == true) { return back()->withErrors(['Antes de desasociar al vendedor, primero este debe cerrar su caja']); } $salesman = User::find($moduleassigment->salesman_id); $tickets = DB::table('tickets')->where('salesman_id', '=', $salesman->id)->where('payment_date', '<', new Carbon())->where('payment_date', '>=', Carbon::today())->whereNull('cashCount_register')->get(); $devolutions = DB::table('devolutions')->where('tickets.salesman_id', '=', $salesman->id)->where('devolutions.created_at', '<', new Carbon())->where('devolutions.created_at', '>=', Carbon::today())->whereNull('devolutions.cashCount_register')->leftJoin('tickets', 'tickets.id', '=', 'devolutions.ticket_id')->get(); if ($tickets != null) { return back()->withErrors(['Antes de desasociar, primero este debe hacer el arqueo de caja']); } if ($devolutions != null) { return back()->withErrors(['Antes de desasociar, primero este debe hacer el arqueo de caja']); } $moduleassigment->status = 2; $moduleassigment->dateMoveAssigments = new Carbon(); $salesman = User::find($moduleassigment->salesman_id); $salesman->module_id = null; $salesman->save(); $moduleassigment->save(); return redirect('admin/modules/assigment'); }