Viewing file:  ProductServiceExport.php (1.83 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
namespace App\Exports;
use App\Models\ProductService;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
class ProductServiceExport implements FromCollection, WithHeadings
{
public function collection()
{
$data = ProductService::select('product_services.id', 'product_services.name as item', 'sku', 'sale_price', 'purchase_price', 'tax_id as tax', 'product_service_categories.name as category', 'product_service_units.name as unit', 'product_services.type', 'description');
// $data->leftjoin('venders', 'product_services.assign_vendor', '=', 'venders.id');
$data->leftjoin('product_service_categories', 'product_services.category_id', '=', 'product_service_categories.id');
$data->leftjoin('product_service_units', 'product_services.unit_id', '=', 'product_service_units.id');
$data= $data->where('product_services.created_by', \Auth::user()->creatorId())->get();
foreach($data as $k => $item)
{
$taxes = ProductService::taxData($item->tax);
$data[$k]["sale_price"] = \Auth::user()->priceFormat($item->sale_price);
$data[$k]["purchase_price"] = \Auth::user()->priceFormat($item->purchase_price);
$data[$k]["tax"] = $taxes;
// $data[$k]["stock_status"] = ProductService::$stockStatus[$item->stock_status];
// $data[$k]["image"] = asset(\Storage::url('uploads/product')) . '/' . $item->image;
}
return $data;
}
public function headings(): array
{
return [
"ID",
"Name",
"SKU",
"sale_price",
"purchase_price",
"Tax",
"Category",
"Unit",
"Type",
"Description",
];
}
}
|