@extends('backend.layout.main') @section('content')
@foreach($lims_delivery_all as $key=>$delivery)
@php
// $customer_sale = DB::table('sales')
// ->join('customers', 'sales.customer_id', '=', 'customers.id')
// ->where('sales.id', $delivery->sale_id)
// ->select('sales.reference_no','customers.name', 'customers.phone_number', 'customers.city', 'sales.grand_total')
// ->get();
// $product_names = DB::table('sales')
// ->join('product_sales', 'sales.id', '=', 'product_sales.sale_id')
// ->join('products', 'products.id', '=', 'product_sales.product_id')
// ->where('sales.id', $delivery->sale_id)
// ->pluck('products.name')
// ->toArray();
if($delivery->status == 1)
$status = __('db.Packing');
elseif($delivery->status == 2)
$status = __('db.Delivering');
else
$status = __('db.Delivered');
$barcode = \DNS2D::getBarcodePNG($delivery->reference_no, 'QRCODE');
@endphp
@foreach ($saleDetails as $saleItem)
@if ($delivery->sale_id === $saleItem->saleId)
@php
$reference_no = $saleItem->reference_no;
$name = $saleItem->name;
$phone_number = $saleItem->phone_number;
$grand_total = $saleItem->grand_total;
$productNames = $saleItem->productNames;
@endphp
@endif
@endforeach
{{-- @foreach ($product_names as $productItem)
@if ($delivery->sale_id === $productItem->saleId)
@php
$productNames = $productItem->productNames;
@endphp
@endif
@endforeach --}}
{{__('db.Delivery Reference')}}
{{__('db.Sale Reference')}}
{{__('db.customer')}}
{{__('db.Address')}}
{{__('db.Products')}}
{{__('db.grand total')}}
{{__('db.status')}}
{{__('db.action')}}
@endforeach
{{$key}}
{{ $delivery->reference_no }}
{{ $reference_no }}
{!!$name .'
'. $phone_number!!}{{ $delivery->address }}
{{ $productNames }}
{{number_format($grand_total, 2)}}
@if($delivery->status == 1)
@elseif($delivery->status == 2)
@else
@endif