middleware('permission:extand_warranties-create', ['only' => ['create']]); $this->middleware('permission:extand_warranties-edit', ['only' => ['edit']]); $this->middleware('permission:extand_warranties-view', ['only' => ['view']]); $this->middleware('permission:extand_warranties-delete', ['only' => ['delete']]); } /** construct */ /** index */ public function index(Request $request){ if($request->ajax()){ $data = ExtandWarranty::select('extand_warranties.*','car_model.name as car_name','fule_type.*') ->leftJoin('car_model','car_model.id','=','extand_warranties.car_model') ->leftjoin('fule_type','fule_type.id','=','extand_warranties.fule_type') ->where('extand_warranties.status', 'active') ->orderBy('extand_warranties.id' , 'desc')->get(); return Datatables::of($data) ->addIndexColumn() ->addColumn('action', function($data){ $return = '

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

'; return $return; }) ->editColumn('years', function ($data) { return $data->years.' Years'; }) ->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 if ($data->status == 'pdi_hold') { return 'Hold By PDI'; } }) ->rawColumns(['years', 'action' ,'status']) ->make(true); } return view('extand_warranties.index'); } /** index */ /** create */ public function create(Request $request){ $Carmodel = Carmodel::where(['status' => 'active'])->get(); $Fuletype = Fuletype::where(['status' => 'active'])->get(); return view('extand_warranties.create')->with(['Carmodel'=>$Carmodel,'Fuletype'=>$Fuletype]);; } /** create */ /** insert */ public function insert(Request $request){ if($request->ajax()){ return true; } $crud = [ 'years' => $request->years, 'amount' => $request->amount, 'car_model' => $request->car_model, 'fule_type' => $request->fule_type, '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 = ExtandWarranty::insertGetId($crud); if ($last_id) { DB::commit(); return redirect()->route('extand_warranties')->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){ $id = base64_decode($request->id); $Carmodel = Carmodel::where(['status' => 'active'])->get(); $data = ExtandWarranty::where(['id' => $id])->first(); $Fuletype = Fuletype::where(['status' => 'active'])->get(); return view('extand_warranties.view')->with(['data' => $data,'Carmodel'=>$Carmodel,'Fuletype'=>$Fuletype]); } /** view */ /** edit */ public function edit(Request $request){ $id = base64_decode($request->id); $Carmodel = Carmodel::where(['status' => 'active'])->get(); $data = ExtandWarranty::where(['id' => $id])->first(); $Fuletype = Fuletype::where(['status' => 'active'])->get(); return view('extand_warranties.edit')->with(['data' => $data,'Carmodel'=>$Carmodel,'Fuletype'=>$Fuletype]); } /** edit */ /** update */ public function update(Request $request){ if($request->ajax()){ return true; } $crud = [ 'years' => $request->years, 'fule_type' => $request->fule_type, 'car_model' => $request->car_model, 'amount' => $request->amount, 'updated_at' => date('Y-m-d H:i:s'), 'updated_by' => auth('sanctum')->user()->id ]; DB::beginTransaction(); try { DB::enableQueryLog(); $update = ExtandWarranty::where(['id' => $request->id])->update($crud); if ($update) { DB::commit(); return redirect()->route('extand_warranties')->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 = ExtandWarranty::where(['id' => $id])->first(); if (!empty($data)) { $update = ExtandWarranty::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 */ /** Import */ public function import(Request $request){ if(Excel::import(new ImportExtandWarranty, $request->file('file')->store('file'))){ return redirect()->route('extand_warranties')->with('sucess' ,'File Imported Sucessfully'); }else{ return redirect()->route('extand_warranties')->with('error' ,'Faild To Import File!'); } } /** Import */ /** Export */ public function export(Request $request){ $slug = $request->slug; $name = 'Extand_warranty_'.Date('YmdHis').'.xlsx'; try { return Excel::download(new ExportExtandWarranty($slug), $name); }catch(\Exception $e){ return redirect()->back()->with('error', $e->getMessage()); } } /** Export */ }