user()->can('expense.add') || auth()->user()->can('expense.edit'))) {
abort(403, 'Unauthorized action.');
}
if (request()->ajax()) {
$business_id = request()->session()->get('user.business_id');
$expense_category = ExpenseCategory::where('business_id', $business_id)
->select(['name', 'code', 'id', 'parent_id']);
return Datatables::of($expense_category)
->addColumn(
'action',
'
'
)
->editColumn('name', function ($row) {
if (! empty($row->parent_id)) {
return '--'.$row->name;
} else {
return $row->name;
}
})
->removeColumn('id')
->removeColumn('parent_id')
->rawColumns([2])
->make(false);
}
return view('expense_category.index');
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
if (! (auth()->user()->can('expense.add') || auth()->user()->can('expense.edit'))) {
abort(403, 'Unauthorized action.');
}
$business_id = request()->session()->get('user.business_id');
$categories = ExpenseCategory::where('business_id', $business_id)
->whereNull('parent_id')
->pluck('name', 'id');
return view('expense_category.create')->with(compact('categories'));
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
if (! (auth()->user()->can('expense.add') || auth()->user()->can('expense.edit'))) {
abort(403, 'Unauthorized action.');
}
try {
$input = $request->only(['name', 'code']);
$input['business_id'] = $request->session()->get('user.business_id');
if (! empty($request->input('add_as_sub_cat')) && $request->input('add_as_sub_cat') == 1 && ! empty($request->input('parent_id'))) {
$input['parent_id'] = $request->input('parent_id');
}
ExpenseCategory::create($input);
$output = ['success' => true,
'msg' => __('expense.added_success'),
];
} catch (\Exception $e) {
\Log::emergency('File:'.$e->getFile().'Line:'.$e->getLine().'Message:'.$e->getMessage());
$output = ['success' => false,
'msg' => __('messages.something_went_wrong'),
];
}
return $output;
}
/**
* Display the specified resource.
*
* @param \App\ExpenseCategory $expenseCategory
* @return \Illuminate\Http\Response
*/
public function show(ExpenseCategory $expenseCategory)
{
//
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
if (! (auth()->user()->can('expense.add') || auth()->user()->can('expense.edit'))) {
abort(403, 'Unauthorized action.');
}
if (request()->ajax()) {
$business_id = request()->session()->get('user.business_id');
$expense_category = ExpenseCategory::where('business_id', $business_id)->find($id);
$categories = ExpenseCategory::where('business_id', $business_id)
->whereNull('parent_id')
->pluck('name', 'id');
return view('expense_category.edit')
->with(compact('expense_category', 'categories'));
}
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
if (! (auth()->user()->can('expense.add') || auth()->user()->can('expense.edit'))) {
abort(403, 'Unauthorized action.');
}
if (request()->ajax()) {
try {
$input = $request->only(['name', 'code']);
$business_id = $request->session()->get('user.business_id');
$expense_category = ExpenseCategory::where('business_id', $business_id)->findOrFail($id);
$expense_category->name = $input['name'];
$expense_category->code = $input['code'];
if (! empty($request->input('add_as_sub_cat')) && $request->input('add_as_sub_cat') == 1 && ! empty($request->input('parent_id'))) {
$expense_category->parent_id = $request->input('parent_id');
} else {
$expense_category->parent_id = null;
}
$expense_category->save();
$output = ['success' => true,
'msg' => __('expense.updated_success'),
];
} catch (\Exception $e) {
\Log::emergency('File:'.$e->getFile().'Line:'.$e->getLine().'Message:'.$e->getMessage());
$output = ['success' => false,
'msg' => __('messages.something_went_wrong'),
];
}
return $output;
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
if (! (auth()->user()->can('expense.add') || auth()->user()->can('expense.edit'))) {
abort(403, 'Unauthorized action.');
}
if (request()->ajax()) {
try {
$business_id = request()->session()->get('user.business_id');
$expense_category = ExpenseCategory::where('business_id', $business_id)->findOrFail($id);
$expense_category->delete();
//delete sub categories also
ExpenseCategory::where('business_id', $business_id)->where('parent_id', $id)->delete();
$output = ['success' => true,
'msg' => __('expense.deleted_success'),
];
} catch (\Exception $e) {
\Log::emergency('File:'.$e->getFile().'Line:'.$e->getLine().'Message:'.$e->getMessage());
$output = ['success' => false,
'msg' => __('messages.something_went_wrong'),
];
}
return $output;
}
}
public function getSubCategories(Request $request)
{
if (! empty($request->input('cat_id'))) {
$category_id = $request->input('cat_id');
$business_id = $request->session()->get('user.business_id');
$sub_categories = ExpenseCategory::where('business_id', $business_id)
->where('parent_id', $category_id)
->select(['name', 'id'])
->get();
}
$html = '';
if (! empty($sub_categories)) {
foreach ($sub_categories as $sub_category) {
$html .= '';
}
}
echo $html;
exit;
}
}