관리-도구

편집 파일: UnitsController.php

<?php

namespace App\Http\Controllers;

use App\Models\Unit;
use App\Models\Product;
use Carbon\Carbon;
use Illuminate\Http\Request;

class UnitsController extends BaseController
{

//-------------- show All Units -----------\\

public function index(Request $request)
    {
        $this->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('deleted_at', null)->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);
    }

}