FM / Controllers

/home/techb158/dev.balacoffee.com/app/Http/Controllers/

/home/techb158/dev.balacoffee.com/app/Http/Controllers

Name	Size	Mode	Actions
Auth/	-	0755	rm
hrm/	-	0755	rm
AdjustmentController.php	31935	0644	edit dl rm
AuthController.php	1761	0644	edit dl rm
BaseController.php	3183	0644	edit dl rm
BrandsController.php	5804	0644	edit dl rm
CategorieController.php	3625	0644	edit dl rm
CategoryExpenseController.php	5449	0644	edit dl rm
ClientController.php	8467	0644	edit dl rm
Controller.php	374	0644	edit dl rm
CurrencyController.php	4035	0644	edit dl rm
ExpensesController.php	12670	0644	edit dl rm
HomeController.php	495	0644	edit dl rm
PasswordResetController.php	3895	0644	edit dl rm
PaymentPurchaseReturnsController.php	14650	0644	edit dl rm
PaymentPurchasesController.php	14138	0644	edit dl rm
PaymentSaleReturnsController.php	14303	0644	edit dl rm
PaymentSalesController.php	21799	0644	edit dl rm
PermissionsController.php	6531	0644	edit dl rm
PosController.php	16651	0644	edit dl rm
ProductsController.php	48520	0644	edit dl rm
ProvidersController.php	7279	0644	edit dl rm
PurchasesController.php	47279	0644	edit dl rm
PurchasesReturnController.php	48366	0644	edit dl rm
QuotationsController.php	31462	0644	edit dl rm
ReportController.php	149323	0644	edit dl rm
SalesController.php	64420	0644	edit dl rm
SalesReturnController.php	47094	0644	edit dl rm
SettingsController.php	12354	0644	edit dl rm
SetupController.php	8770	0644	edit dl rm
ShipmentController.php	7633	0644	edit dl rm
TestDbController.php	3156	0644	edit dl rm
TransferController.php	54574	0644	edit dl rm
UnitsController.php	6162	0644	edit dl rm
UpdateController.php	2064	0644	edit dl rm
UserController.php	13167	0644	edit dl rm
WarehouseController.php	6427	0644	edit dl rm

Edit: /home/techb158/dev.balacoffee.com/app/Http/Controllers/WarehouseController.php (6427B)

<?php

namespace App\Http\Controllers;

use App\Models\Product;
use App\Models\ProductVariant;
use App\Models\product_warehouse;
use App\Models\Warehouse;
use Carbon\Carbon;
use DB;
use Illuminate\Http\Request;

class WarehouseController extends Controller
{

//----------- GET ALL  Warehouse --------------\\

public function index(Request $request)
    {
        $this->authorizeForUser($request->user('api'), 'view', Warehouse::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;

$warehouses = Warehouse::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('mobile', 'LIKE', "%{$request->search}%")
                        ->orWhere('country', 'LIKE', "%{$request->search}%")
                        ->orWhere('city', 'LIKE', "%{$request->search}%")
                        ->orWhere('zip', 'LIKE', "%{$request->search}%")
                        ->orWhere('email', 'LIKE', "%{$request->search}%");
                });
            });
        $totalRows = $warehouses->count();
        if($perPage == "-1"){
            $perPage = $totalRows;
        }
        $warehouses = $warehouses->offset($offSet)
            ->limit($perPage)
            ->orderBy($order, $dir)
            ->get();

return response()->json([
            'warehouses' => $warehouses,
            'totalRows' => $totalRows,
        ]);
    }

//----------- Store new Warehouse --------------\\

public function store(Request $request)
    {
        $this->authorizeForUser($request->user('api'), 'create', Warehouse::class);

request()->validate([
            'name' => 'required',
        ]);

\DB::transaction(function () use ($request) {

$Warehouse = new Warehouse;
            $Warehouse->name = $request['name'];
            $Warehouse->mobile = $request['mobile'];
            $Warehouse->country = $request['country'];
            $Warehouse->city = $request['city'];
            $Warehouse->zip = $request['zip'];
            $Warehouse->email = $request['email'];
            $Warehouse->save();

$products = Product::where('deleted_at', '=', null)
                ->pluck('id')
                ->toArray();

if ($products) {
                foreach ($products as $product) {
                    $product_warehouse = [];
                    $Product_Variants = ProductVariant::where('product_id', $product)
                        ->where('deleted_at', null)
                        ->get();

if ($Product_Variants->isNotEmpty()) {
                        foreach ($Product_Variants as $product_variant) {

$product_warehouse[] = [
                                'product_id' => $product,
                                'warehouse_id' => $Warehouse->id,
                                'product_variant_id' => $product_variant->id,
                            ];
                        }
                    } else {
                        $product_warehouse[] = [
                            'product_id' => $product,
                            'warehouse_id' => $Warehouse->id,
                            'product_variant_id' => null,
                        ];
                    }

product_warehouse::insert($product_warehouse);
                }
            }

}, 10);

return response()->json(['success' => true]);
    }

//------------ function show -----------\\

public function show($id){
        //
        
        }

//-----------Update Warehouse --------------\\

public function update(Request $request, $id)
    {
        $this->authorizeForUser($request->user('api'), 'update', Warehouse::class);

request()->validate([
            'name' => 'required',
        ]);

Warehouse::whereId($id)->update([
            'name' => $request['name'],
            'mobile' => $request['mobile'],
            'country' => $request['country'],
            'city' => $request['city'],
            'zip' => $request['zip'],
            'email' => $request['email'],
        ]);
        return response()->json(['success' => true]);
    }

//----------- Delete  Warehouse --------------\\

public function destroy(Request $request, $id)
    {
        $this->authorizeForUser($request->user('api'), 'delete', Warehouse::class);

\DB::transaction(function () use ($id) {

Warehouse::whereId($id)->update([
                'deleted_at' => Carbon::now(),
            ]);

product_warehouse::where('warehouse_id', $id)->update([
                'deleted_at' => Carbon::now(),
            ]);

}, 10);

return response()->json(['success' => true]);
    }

//-------------- Delete by selection  ---------------\\

public function delete_by_selection(Request $request)
    {

$this->authorizeForUser($request->user('api'), 'delete', Warehouse::class);

\DB::transaction(function () use ($request) {
            $selectedIds = $request->selectedIds;
            foreach ($selectedIds as $warehouse_id) {
                Warehouse::whereId($warehouse_id)->update([
                    'deleted_at' => Carbon::now(),
                ]);

product_warehouse::where('warehouse_id', $warehouse_id)->update([
                    'deleted_at' => Carbon::now(),
                ]);
            }

}, 10);

return response()->json(['success' => true]);
    }

//----------- GET ALL  Warehouse --------------\\

public function Get_Warehouses()
    {
        $Warehouses = Warehouse::where('deleted_at', '=', null)->get();
        return response()->json($Warehouses);
    }

}

cmd: