@php $generalsetting = \App\GeneralSetting::first(); @endphp
|
ekhadiindia.com |
Tax Invoice/Bill of Supply/Cash Memo |
Sold By :{{@$data['seller_address']->name}} {{@$data['seller_address']->address}} PAN No: {{@$data['seller_address']->company_pan}} GST Registration No: {{@$data['seller_address']->gst_no}} |
@php
@$billing_address = json_decode($data['order_products'][0]->order->billing_address);
$id= @$data['order_products'][0]->order->id;
$product = \App\Product::select('order_details.product_id', 'shops.id as shop_id')
->leftJoin('order_details', 'products.id', '=', 'order_details.product_id')
->leftJoin('shops', 'shops.user_id', '=', 'products.seller_id')
->where(['order_details.order_id' => $id, 'products.manage_by' => '0'])->get();
if(count($product) > 0){
$ecom_invoice = 1;
}else{
$ecom_invoice = 0;
}
$productKhadi = \App\Product::select('order_details.product_id', 'shops.id as shop_id')
->leftJoin('order_details', 'products.id', '=', 'order_details.product_id')
->leftJoin('shops', 'shops.user_id', '=', 'products.seller_id')
->where(['order_details.order_id' => $id, 'products.manage_by' => '1']);
$countsKhadi = $productKhadi->get();
if(count($countsKhadi)){
$KhadiIds = $productKhadi->pluck('product_id');
$seller = \App\OrderDetail::where('order_id', $id)->whereIn('product_id', $KhadiIds)->groupBy('seller_id')->pluck('seller_id')->toArray();
$data['no_of_invoice'] = count($seller);
if(!empty($seller)){
$sell_array = array();
foreach ($seller as $key => $sell) {
$sell_array[] = $sell;
}
}
}
if(count($sell_array) > 0){
$totalIncoiceNumber = $ecom_invoice + count($sell_array);
}else{
$totalIncoiceNumber = $ecom_invoice;
}
@endphp
{{ translate('Billing Address') }} :{{ @$billing_address->name }} {{ @$billing_address->address }}, {{ @$billing_address->city }}, {{ @$billing_address->country }} {{ translate('Email') }}: {{ @$billing_address->email }} {{ translate('Phone') }}: {{ @$billing_address->phone }} {{ translate('State') }}: {{ @$billing_address->state }} {{ translate('Postal Code') }}: {{ @$billing_address->postal_code }} @if(!empty($billing_address->gst_number)){{ translate('GST Number') }}: {{ @$billing_address->gst_number }} @else{{ translate('GST Number') }}: {{ 'N/A' }} @endif |
| @php $shipping_address = json_decode(@$data['order_products'][0]->order->shipping_address); @endphp |
{{ translate('Shipping Address') }} :{{ @$shipping_address->name }} {{ @$shipping_address->address }}, {{ @$shipping_address->city }}, {{ @$shipping_address->country }} {{ translate('Email') }}: {{ @$shipping_address->email }} {{ translate('Phone') }}: {{ @$shipping_address->phone }} {{ translate('State') }}: {{ @$shipping_address->state }} {{ translate('Postal Code') }}: {{ @$shipping_address->postal_code }} |
Order Number : {{@$data['order_products'][0]->order->code}}{{ translate('Order Date') }} : {{ date('d-m-Y', @$data['order_products'][0]->order->date) }} |
Invoice Number : {{@$data['invoice_number']}}{{ translate('Invoice Date') }} : {{ date('d-m-Y', @$data['order_products'][0]->order->date) }} |
| {{ translate('S. NO') }} | {{ translate('Product Name') }} | {{ translate('Unit Price') }} | {{ translate('Quantity') }} | {{ translate('Net Amount') }} | {{ translate('Tax Rates') }} | {{ translate('Tax Type') }} | {{ translate('Tax Amount') }} | {{ translate('Discount') }} | {{ translate('Total Amount') }} | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
| {{$key+1}} | @php if(!empty($orderDetail->variation)){ $productStock = \App\ProductStock::with('product')->where('product_id', $orderDetail->product_id)->where('variant', @$orderDetail->variation)->first(); }else{ $productStock = \App\ProductStock::with('product')->where('product_id', $orderDetail->product_id)->first(); } @endphp {{ $orderDetail->product->name }} {{@$orderDetail->variation}} {{'HSN code: '.$orderDetail->product->hsn_code }} {{'SKU: '.@$productStock->sku}} |
{!! $rupees.number_format((float)$unitPrice, 2, '.', '') !!} | {{ $orderDetail->quantity }} | {!! $rupees.number_format((float)@$netAmount, 2, '.', '') !!} | {!! @$finalTaxP !!} | {!! @$tax_type_lable !!} | {!! $finalTax_amt !!} | @if($orderDetail->product->discount != '0.00'){{$orderDetail->product->discount.'%'}} @else {{$orderDetail->product->discount.'%'}}@endif | {!! $rupees.number_format((float)@$discountAmout*$orderDetail->quantity, 2, '.', '') !!} | ||
| Coupon discount @if($coupon_code != null) {{ ': ('.$coupon_code.')' }} @endif | {{ number_format((float)@$dicountper, 2, '.', '').' %' }} | ₹ {{number_format((float)$data['order_products'][0]->order->coupon_discount / $totalIncoiceNumber, 2, '.', '')}} | |||||||||
| Handling Charge | {!! $rupees.number_format((float)$shippingUniPrice, 2, '.', '') !!} | N/A | {!! $rupees.number_format((float)$shippingUniPrice, 2, '.', '') !!} | {!! @$finalTaxP !!} | {!! @$tax_type_lable !!} | {!! @$shippinc !!} | {{'0%'}} | ₹ @if(@completeOrderGrandTotal < 1000) {{number_format((float)$shippingPriceFraction, 2, '.', '')}} @endif | |||
| Handling Charge | {!! $rupees.number_format((float)$shippingUniPrice, 2, '.', '') !!} | N/A | {!! $rupees !!} 0.00 | {{'0%'}} | N/A | {!! $rupees.number_format((float)$shippingUniPrice, 2, '.', '') !!} | {{'0%'}} | {!! $rupees.'0.00'; !!} | |||
| Total Amount | ₹ @if($completeOrderGrandTotal < minShippingAmount()) {{ number_format((float)@$Product_tax+($shippingPriceFraction-$shippingUniPrice), 2, '.', '') }} @else {{ number_format((float)@$Product_tax, 2, '.', '') }} @endif | ₹ {{number_format($grandTotal+$shippingprice - @$data['order_products'][0]->order->coupon_discount, 2, '.', '')}} | |||||||||
| Total Amount in words: {{AmountInWords(number_format($grandTotal+$shippingprice - @$data['order_products'][0]->order->coupon_discount, 2, '.', ''))}} Only | |||||||||||
| whether tax is payable under reverse charge-No |
 }}) Authorized Signatory |
||||||||||