@extends('front.layouts.main') @section('content')
| ID | Product ID | Name | Quantity | Buyinig Price | Selling Price | Expired Date | Manufacturer Date | Category | Suplier |
|---|---|---|---|---|---|---|---|---|---|
| {{$key + 1}} | {{$listing->product_id}} | {{$listing->name}} | {{$listing->quantity}} | {{$listing->cost}} | {{$listing->price}} | {{$listing->expireddate}} | {{$listing->manufacturerdate}} | @php $sub_name = DB::table('sub_categories')->where('id', $listing->sub_category_id)->first(); $category_name = DB::table('categories')->where('id',$sub_name->category_id)->first(); @endphp {{$category_name->category_name ?? ''}} | @php $suppliers = DB::table('supplier_details')->where('id', $listing->suppliers)->first(); @endphp {{$suppliers->supplier_name ?? ''}} |