Gecko [ thecigaretteboxes.com ]

Name	Size	Permission	Action
CategoryProductsExport.php	1.29 KB	-rw-r--r--
ProductExport.php	335 B	-rw-r--r--

Code Editor : CategoryProductsExport.php

<?php
namespace App\Export;

use App\Models\Category;
use App\Models\Product;
use Illuminate\Contracts\View\View;
use Maatwebsite\Excel\Concerns\FromView;

class CategoryProductsExport implements FromView
{
    public function view(): View
    {
        $products=Product::where('product_description','like','%Zeday%')
            ->orWhere('product_detail','like','%day%')
            ->orWhere('meta_descriptions','like','%day%')
            ->get();
        $products_array=array();
        foreach ($products as $k=>$product){
            $cats=explode(',',$product->product_category);
            $products[$k]->categories=Category::whereIn('id',$cats)->with('parent')->get();
        }
        return view('exports.category_products', [
            'products' => $products
        ]);
        /*$categories=Category::where('description','like','%OXO%')
            ->orWhere('detail','like','%OXO%')
            ->orWhere('meta_descriptions','like','%OXO%')
            ->orWhere('meta_keywords','like','%OXO%')
            ->orWhere('meta_title','like','%OXO%')
            ->orWhere('description','like','%9533%')
            ->orWhere('detail','like','%9533%')->with('parent')
            ->get();
        return view('exports.category_products', [
            'categories' => $categories
        ]);*/
    }
}

${this.title}

Code Editor : CategoryProductsExport.php