get();
if (request()->ajax())
{
return datatables()->of(designation::with('company','department')->get())
->setRowId(function ($designation)
{
return $designation->id;
})
->addColumn('company', function ($row)
{
return $row->company->company_name ?? ' ' ;
})
->addColumn('department', function ($row)
{
return empty($row->department->department_name) ? '' : $row->department->department_name;
})
->addColumn('action', function ($data)
{
$button= '';
if (auth()->user()->can('edit-designation'))
{
$button = '';
$button .= ' ';
}
if (auth()->user()->can('delete-designation'))
{
$button .= '';
}
return $button;
})
->rawColumns(['action'])
->make(true);
}
return view('organization.designation.index', compact('companies'));
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$logged_user = auth()->user();
if ($logged_user->can('store-designation'))
{
$validator = Validator::make($request->only('designation_name', 'company_id', 'department_id'),
[
'designation_name' => 'required|unique:designations,designation_name,NULL,id,department_id,'.$request->department_id,
'company_id' => 'required',
'department_id' => 'required',
]
);
if ($validator->fails())
{
return response()->json(['errors' => $validator->errors()->all()]);
}
$data = [];
$data['designation_name'] = $request->designation_name;
$data['company_id'] = $request->company_id;
$data ['department_id'] = $request->department_id;
designation::create($data);
return response()->json(['success' => __('Data Added successfully.')]);
}
return response()->json(['success' => __('You are not authorized')]);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
if(request()->ajax())
{
$data = designation::findOrFail($id);
$departments = Department::select('id', 'department_name')->where('company_id', $data->company_id)->get();
return response()->json(['data' => $data,'departments'=>$departments]);
}
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request)
{
$logged_user = auth()->user();
if ($logged_user->can('edit-designation'))
{
$id = $request->hidden_id;
$data = $request->only('designation_name', 'company_id', 'department_id');
$validator = Validator::make($request->only('designation_name', 'company_id', 'department_id'),
[
'designation_name' => 'required|unique:designations,designation_name,'. $id .',id,department_id,'.$request->department_id,
]
);
if ($validator->fails())
{
return response()->json(['errors' => $validator->errors()->all()]);
}
$data = [];
$data['designation_name'] = $request->designation_name;
if($request->company_id)
{
$data['company_id'] = $request->company_id;
}
if($request->department_id)
{
$data ['department_id'] = $request->department_id;
}
designation::whereId($id)->update($data);
return response()->json(['success' => __('Data is successfully updated')]);
} else
{
return response()->json(['success' => __('You are not authorized')]);
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
if(!env('USER_VERIFIED'))
{
return response()->json(['error' => 'This feature is disabled for demo!']);
}
$logged_user = auth()->user();
if ($logged_user->can('delete-designation'))
{
designation::whereId($id)->delete();
return response()->json(['success' => __('Data is successfully deleted')]);
}
return response()->json(['success' => __('You are not authorized')]);
}
public function delete_by_selection(Request $request)
{
if(!env('USER_VERIFIED'))
{
return response()->json(['error' => 'This feature is disabled for demo!']);
}
$logged_user = auth()->user();
if ($logged_user->can('delete-designation'))
{
$designation_id = $request['designationIdArray'];
$designation = designation::whereIn('id', $designation_id);
if ($designation->delete())
{
return response()->json(['success' => __('Multi Delete',['key'=>trans('file.Designation')])]);
}
else {
return response()->json(['error' => 'Error selected designation can not be deleted']);
}
}
return response()->json(['success' => __('You are not authorized')]);
}
}