/home/techb158/dev.balacoffee.com/app/Http/Controllers
Edit: /home/techb158/dev.balacoffee.com/app/Http/Controllers/UnitsController.php (6162B)
authorizeForUser($request->user('api'), 'view', Unit::class);
// How many items do you want to display.
$perPage = $request->limit;
$pageStart = \Request::get('page', 1);
// Start displaying items from this number;
$offSet = ($pageStart * $perPage) - $perPage;
$order = $request->SortField;
$dir = $request->SortType;
$data = array();
$Units = Unit::where('deleted_at', '=', null)
// Search With Multiple Param
->where(function ($query) use ($request) {
return $query->when($request->filled('search'), function ($query) use ($request) {
return $query->where('name', 'LIKE', "%{$request->search}%")
->orWhere('ShortName', 'LIKE', "%{$request->search}%");
});
});
$totalRows = $Units->count();
if($perPage == "-1"){
$perPage = $totalRows;
}
$Units = $Units->offset($offSet)
->limit($perPage)
->orderBy($order, $dir)
->get();
foreach ($Units as $unit) {
$unit_data['id'] = $unit->id;
$unit_data['name'] = $unit->name;
$unit_data['ShortName'] = $unit->ShortName;
$unit_data['operator'] = $unit->operator;
$unit_data['operator_value'] = $unit->operator_value;
if ($unit->base_unit !== null) {
$unit_base = Unit::where('id', $unit->base_unit)->where('deleted_at', null)->first();
$unit_data['base_unit_name'] = $unit_base['name'];
$unit_data['base_unit'] = $unit_base['id'];
} else {
$unit_data['base_unit_name'] = '';
$unit_data['base_unit'] = '';
}
$data[] = $unit_data;
}
$Units_base = Unit::where('base_unit', null)
->where('deleted_at', null)
->orderBy('id', 'DESC')
->get(['id', 'name']);
return response()->json([
'Units' => $data,
'Units_base' => $Units_base,
'totalRows' => $totalRows,
]);
}
//-------------- STORE NEW UNIT -----------\\
public function store(Request $request)
{
$this->authorizeForUser($request->user('api'), 'create', Unit::class);
request()->validate([
'name' => 'required',
'ShortName' => 'required',
]);
if ($request->base_unit == '') {
$operator = '*';
$operator_value = 1;
} else {
$operator = $request->operator;
$operator_value = $request->operator_value;
}
Unit::create([
'name' => $request['name'],
'ShortName' => $request['ShortName'],
'base_unit' => $request['base_unit'],
'operator' => $operator,
'operator_value' => $operator_value,
]);
return response()->json(['success' => true]);
}
//-------------- UPDATE UNIT -----------\\
public function update(Request $request, $id)
{
$this->authorizeForUser($request->user('api'), 'update', Unit::class);
request()->validate([
'name' => 'required',
'ShortName' => 'required',
]);
if ($request->base_unit == '' || $request->base_unit == $id) {
$operator = '*';
$operator_value = 1;
$base_unit = null;
} else {
$operator = $request->operator;
$operator_value = $request->operator_value;
$base_unit = $request['base_unit'];
}
Unit::whereId($id)->update([
'name' => $request['name'],
'ShortName' => $request['ShortName'],
'base_unit' => $base_unit,
'operator' => $operator,
'operator_value' => $operator_value,
]);
return response()->json(['success' => true]);
}
//-------------- REMOVE UNIT -----------\\
public function destroy(Request $request, $id)
{
$this->authorizeForUser($request->user('api'), 'delete', Unit::class);
$Sub_Unit_exist = Unit::where('base_unit', $id)->where('deleted_at', null)->exists();
if (!$Sub_Unit_exist) {
Unit::whereId($id)->update([
'deleted_at' => Carbon::now(),
]);
return response()->json(['success' => true]);
} else {
return response()->json(['success' => false]);
}
}
//-------------- Get Units SubBase ------------------\\
public function Get_Units_SubBase(request $request)
{
$units = Unit::where(function ($query) use ($request) {
return $query->when($request->filled('id'), function ($query) use ($request) {
return $query->where('id', $request->id)
->orWhere('base_unit', $request->id);
});
})->get();
return response()->json($units);
}
//-------------- Get Sales Units ------------------\\
public function Get_sales_units(request $request)
{
$product_unit_id = Product::with('unit')->where(function ($query) use ($request) {
return $query->when($request->filled('id'), function ($query) use ($request) {
return $query->where('id', $request->id);
});
})->first();
$units = Unit::where('base_unit', $product_unit_id->unit_id)
->orWhere('id', $product_unit_id->unit_id)
->get();
return response()->json($units);
}
}