ajax()) {
$business_id = request()->session()->get('user.business_id');
$tax_rates = TaxRate::where('business_id', $business_id)
->where('is_tax_group', '1')
->with(['sub_taxes']);
return Datatables::of($tax_rates)
->addColumn(
'action',
'
'
)
->editColumn('amount', '{{@num_format($amount)}}')
->editColumn('sub_taxes', function ($row) {
$sub_taxes = [];
foreach ($row->sub_taxes as $sub_tax) {
$sub_taxes[] = $sub_tax->name;
}
return implode(' + ', $sub_taxes);
})
->removeColumn('id')
->rawColumns(['action'])
->make(true);
}
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
$business_id = request()->session()->get('user.business_id');
$taxes = TaxRate::where('business_id', $business_id)->where('is_tax_group', '0')->pluck('name', 'id');
return view('tax_group.create')
->with(compact('taxes'));
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
try {
$input['name'] = $request->input('name');
$input['business_id'] = $request->session()->get('user.business_id');
$input['created_by'] = $request->session()->get('user.id');
$sub_tax_ids = $request->input('taxes');
$sub_taxes = TaxRate::whereIn('id', $sub_tax_ids)->get();
$amount = 0;
foreach ($sub_taxes as $sub_tax) {
$amount += $sub_tax->amount;
}
$input['amount'] = $amount;
$input['is_tax_group'] = 1;
$tax_rate = TaxRate::create($input);
$tax_rate->sub_taxes()->sync($sub_tax_ids);
$output = ['success' => true,
'msg' => __('tax_rate.tax_group_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 int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
//
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
if (request()->ajax()) {
$business_id = request()->session()->get('user.business_id');
$tax_rate = TaxRate::where('business_id', $business_id)->with(['sub_taxes'])->find($id);
$taxes = TaxRate::where('business_id', $business_id)->where('is_tax_group', '0')->pluck('name', 'id');
$sub_taxes = [];
foreach ($tax_rate->sub_taxes as $sub_tax) {
$sub_taxes[] = $sub_tax->id;
}
return view('tax_group.edit')
->with(compact('taxes', 'sub_taxes', 'tax_rate'));
}
}
/**
* 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 (request()->ajax()) {
try {
$business_id = $request->session()->get('user.business_id');
$sub_tax_ids = $request->input('taxes');
$sub_taxes = TaxRate::whereIn('id', $sub_tax_ids)->get();
$amount = 0;
foreach ($sub_taxes as $sub_tax) {
$amount += $sub_tax->amount;
}
$tax_rate = TaxRate::where('business_id', $business_id)->findOrFail($id);
$tax_rate->name = $request->input('name');
$tax_rate->amount = $amount;
$tax_rate->save();
$tax_rate->sub_taxes()->sync($sub_tax_ids);
$output = ['success' => true,
'msg' => __('tax_rate.tax_group_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 (request()->ajax()) {
try {
$business_id = request()->user()->business_id;
$tax_rate = TaxRate::where('business_id', $business_id)->findOrFail($id);
$tax_rate->delete();
$output = ['success' => true,
'msg' => __('tax_rate.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;
}
}
}