middleware('permission:sub_lead-create', ['only' => ['create']]); $this->middleware('permission:sub_lead-edit', ['only' => ['edit']]); $this->middleware('permission:sub_lead-view', ['only' => ['view']]); $this->middleware('permission:sub_lead-delete', ['only' => ['delete']]); } /** construct */ /** index */ public function index(Request $request){ if($request->ajax()){ $data = DB::table('sub_lead as sb') ->select('sb.id','sb.name','sb.status','l.name as lead_name') ->leftjoin('lead as l', 'l.id', 'sb.lead_id') ->get(); return Datatables::of($data) ->addIndexColumn() ->addColumn('action', function ($data) { $return = '

'; if (auth()->user()->can('sub_lead-view')) { $return .= ' '; } if (auth()->user()->can('sub_lead-edit')) { $return .= ' '; } if (auth()->user()->can('sub_lead-delete')) { $return .= ' '; } $return .= '

'; return $return; }) ->editColumn('status', function ($data) { if ($data->status == 'active') { return 'Active'; } else if ($data->status == 'inactive') { return 'Inactive'; } else if ($data->status == 'deleted') { return 'Deleted'; }else{ return '-'; } }) ->rawColumns(['action' ,'status']) ->make(true); } return view('sub_lead.index'); } /** index */ /** create */ public function create(Request $request){ $lead_data = Lead::where(['status' => 'active'])->get(); return view('sub_lead.create')->with(['lead_data' => $lead_data]); } /** create */ /** insert */ public function insert(Request $request){ if($request->ajax()){ return true ; } $crud = [ 'lead_id' => ucfirst($request->lead_id), 'name' => ucfirst($request->name), 'status' => 'active', 'created_at' => date('Y-m-d H:i:s'), 'created_by' => auth()->user()->id, 'updated_at' => date('Y-m-d H:i:s'), 'updated_by' => auth()->user()->id ]; DB::beginTransaction(); try { DB::enableQueryLog(); $last_id = Sublead::insertGetId($crud); if ($last_id) { DB::commit(); return redirect()->route('sub_lead')->with('success', 'Record inserted successfully'); } else { DB::rollback(); return redirect()->back()->with('error', 'Failed to insert record')->withInput(); } } catch (\Throwable $th) { DB::rollback(); return redirect()->back()->with('error', 'Something went wrong, please try again later')->withInput(); } } /** insert */ /** view */ public function view(Request $request){ $lead_data = Lead::where(['status' => 'active'])->get(); $id = base64_decode($request->id); $data = Sublead::where(['id' => $id])->first(); return view('sub_lead.view')->with(['data' => $data,'lead_data' => $lead_data]); } /** view */ /** edit */ public function edit(Request $request){ $lead_data = Lead::where(['status' => 'active'])->get(); $id = base64_decode($request->id); $data = Sublead::where(['id' => $id])->first(); return view('sub_lead.edit')->with(['data' => $data,'lead_data' => $lead_data]); } /** edit */ /** update */ public function update(Request $request){ if($request->ajax()){ return true; } $crud = [ 'lead_id' => ucfirst($request->lead_id) ?? 0, 'name' => ucfirst($request->name) ?? '', 'updated_at' => date('Y-m-d H:i:s'), 'updated_by' => auth('sanctum')->user()->id ]; DB::beginTransaction(); try { $update = Sublead::where(['id' => $request->id])->update($crud); if ($update) { DB::commit(); return redirect()->route('sub_lead')->with('success', 'Record updated successfully'); } else { DB::rollback(); return redirect()->back()->with('error', 'Failed to update record')->withInput(); } } catch (\Throwable $th) { DB::rollback(); return redirect()->back()->with('error', 'Something went wrong, please try again later')->withInput(); } } /** update */ /** change-status */ public function change_status(Request $request){ if (!$request->ajax()) { exit('No direct script access allowed'); } $id = base64_decode($request->id); $data = Sublead::where(['id' => $id])->first(); if(!empty($data)){ $update = Sublead::where(['id' => $id])->update(['status' => $request->status, 'updated_at' => date('Y-m-d H:i:s'), 'updated_by' => auth()->user()->id]); if($update){ return response()->json(['code' => 200]); }else{ return response()->json(['code' => 201]); } }else{ return response()->json(['code' => 201]); } } /** change-status */ /** Export */ public function export(Request $request){ if(isset($request->slug) && $request->slug != null){ $slug = $request->slug; }else{ $slug = 'all'; } $name = 'Lead_'.Date('YmdHis').'.xlsx'; try { return Excel::download(new ExportLead($slug), $name); }catch(\Exception $e){ return redirect()->back()->with('error', $e->getMessage()); } } /** Export */ /** Import */ public function import(Request $request){ if(Excel::import(new ImportLead, $request->file('file')->store('file'))){ return redirect()->route('sub_lead')->with('sucess' ,'File Imported Sucessfully'); }else{ return redirect()->route('sub_lead')->with('error' ,'Faild To Import File!'); } } /** Import */ }