ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / costbloc.com / app / Http / Controllers / Api

<?php

/**
 * @package ProductController
 * @author TechVillage <support@techvill.org>
 * @contributor Sakawat Hossain Rony <[sakawat.techvill@gmail.com]>
 * @created 29-10-2021
 */

namespace App\Http\Controllers\Api;

use App\Http\Controllers\Controller;
use App\Http\Resources\{
    ProductDetailResource,
    ProductResource
};
use App\Models\{
    Product
};
use Illuminate\Http\Request;

class ProductController extends Controller
{
    /**
     * Product List
     * @param Request $request
     * @return json $data
     */
    public function index(Request $request)
    {
        $configs = $this->initialize([], $request->all());
        $products = Product::select('products.*');
        $name = isset($request->name) ? $request->name : null;
        if (!empty($name)) {
            $products->where('name', strtolower($name));
        }

$productCode = isset($request->code) ? $request->code : null;
        if (!empty($productCode)) {
            $products->where('code', strtolower($productCode));
        }

$sku = isset($request->sku) ? $request->sku : null;
        if (!empty($sku)) {
            $products->where('sku', strtolower($sku));
        }

$vendor = isset($request->vendor) ? $request->vendor : null;
        if (!empty($vendor)) {
            $products->whereHas("vendor", function ($q) use ($vendor) {
                $q->where('name', strtolower($vendor));
            })->with('vendor');
        }

$brand = isset($request->brand) ? $request->brand : null;
        if (!empty($brand)) {
            $products->whereHas("brand", function ($q) use ($brand) {
                $q->where('name', strtolower($brand));
            })->with('brand');
        }

$status = isset($request->status) ? $request->status : null;
        if (!empty($status)) {
            $products->where('status', strtolower($status));
        }

$keyword = isset($request->keyword) ? $request->keyword : null;
        if (!empty($keyword)) {
            if (is_int($keyword)) {
                $products->where('id', $keyword);
            } else {
                if (strlen($keyword) >= 3) {
                    $products->where(function ($query) use ($keyword) {
                        $query->where('name', 'LIKE', '%' . $keyword . '%')
                            ->where('code', 'LIKE', '%' . $keyword . '%')
                            ->where('sku', 'LIKE', '%' . $keyword . '%')
                            ->orwhereHas("vendor", function ($q) use ($keyword) {
                                $q->where('name', 'LIKE', "%" . $keyword . "%");
                            })->with('vendor')
                            ->orwhereHas("brand", function ($q) use ($keyword) {
                                $q->where('name', 'LIKE', "%" . $keyword . "%");
                            })->with('brand')
                            ->orwhere('status', $keyword);
                    });
                }
            }
        }
        return $this->response([
            'data' => ProductResource::collection($products->paginate($configs['rows_per_page'])),
            'pagination' => $this->toArray($products->paginate($configs['rows_per_page'])->appends($request->all()))
        ]);
    }

/**
     * Product Search
     *
     * @param Request $request
     * @param $type
     * @return array
     */
    public function search(Request $request, $type)
    {
        $id = $request->product_id;
        $response = $this->checkExistence($id, 'products');
        if ($response['status']) {
            if ($type == 'relate') {
                return $this->response([
                    'data' => (new Product)->search($request->search, $request->product_id, $type, "api"),
                ]);
            }
            if ($type == 'cross') {
                return $this->response([
                    'data' => (new Product)->search($request->search, $request->product_id, $type, "api"),
                ]);
            }
            if ($type == 'up') {
                return $this->response([
                    'data' => (new Product)->search($request->search, $request->product_id, $type, "api"),
                ]);
            }
        }
        return $this->unprocessableResponse($response['message']);
    }

/**
     * Detail Product
     *
     * @param Request $request
     * @return json $data
     */
    public function detail($id)
    {
        $response = $this->checkExistence($id, 'products');
        if ($response['status']) {
            return $this->response([
                'data' => new ProductDetailResource(Product::where('id', $id)->first())
            ]);
        }
        return $this->unprocessableResponse($response['message']);
    }

/**
     * Trash the specified Product from db.
     * @param Request $request
     * @return json $data
     */
    public function deleteProduct(Request $request)
    {
        $product  = Product::whereCode($request->code)->first();
        if (!$product) {
            return $this->notFoundResponse([], __('Something went wrong. Product not found.'));
        }
        $product->delete();
        return $this->successResponse([], 201, __('Product has been trashed.'));
    }

/**
     * Trashed the specified Product from db.
     * @param Request $request
     * @return json $data
     */
    public function forceDeleteProduct(Request $request)
    {
        $product  = Product::withTrashed()->whereCode($request->code)->first();
        if (!$product) {
            return $this->notFoundResponse([], __('Something went wrong. Product not found.'));
        }
        $productIds = Product::withTrashed()->where('parent_id', $product->id)->get()->pluck('id')->toArray();
        if (count($productIds) > 0) {
            Product::withTrashed()->whereIn('id', $productIds)->delete();
        }
        array_push($productIds, $product->id);
        $product->forceDelete();
        ProductMeta::whereIn('product_id', $productIds)->delete();
        return $this->successResponse([], 201, __('Product deleted permanently.'));
    }
}

[-] CategoryController.php [edit]
[-] CountryController.php [edit]
[+] ..
[-] UserController.php [edit]
[-] AttributeController.php [edit]
[-] MailTemplateController.php [edit]
[-] AttributeGroupController.php [edit]
[-] EmailConfigurationController.php [edit]
[-] CurrencyController.php [edit]
[-] BrandController.php [edit]
[-] RoleController.php [edit]
[-] VendorController.php [edit]
[+] User
[-] PreferenceController.php [edit]
[-] CompanySettingController.php [edit]
[-] ProductController.php [edit]
[+] Vendor
[-] AuthController.php [edit]