public function anyData() { $leads = Leads::select(['id', 'title', 'fk_user_id_created', 'fk_client_id', 'fk_user_id_assign', 'contact_date'])->where('status', 1)->get(); return Datatables::of($leads)->addColumn('titlelink', function ($leads) { return '<a href="leads/' . $leads->id . '" ">' . $leads->title . '</a>'; })->editColumn('fk_user_id_created', function ($leads) { return $leads->createdBy->name; })->editColumn('contact_date', function ($leads) { return $leads->contact_date ? with(new Carbon($leads->created_at))->format('d/m/Y') : ''; })->editColumn('fk_user_id_assign', function ($leads) { return $leads->assignee->name; })->make(true); }
/** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { $lead = Leads::findOrFail($request->id); $settings = Settings::all(); $isAdmin = Auth()->user()->hasRole('administrator'); $settingscomplete = $settings[0]['lead_assign_allowed']; if ($isAdmin) { return $next($request); } if ($settingscomplete == 1 && Auth()->user()->id == $lead->fk_user_id_assign) { Session()->flash('flash_message_warning', 'Not allowed to create lead'); return redirect()->back(); } return $next($request); }
public function createdLeadsToday() { return Leads::whereRaw('date(created_at) = ?', [Carbon::now()->format('Y-m-d')])->count(); }