@extends('layouts.order-master') @section('css') @endsection @section('title') Order @endsection @section('content') @isset($order) @method('put') @else @endisset @csrf @isset($order) Edit Order @else Add Order @endisset Order Date Tax Type @isset($order) IntraState InterState (IGST) @else IntraState InterState (IGST) @endisset Price Slab Choose price slab {{-- --}} Party (Dr) Select ledger Remarks {{ isset($order) ? $order->remarks : '' }} Ship To Address {{ isset($order) ? $order->ship_to_address : '' }} {{-- --}} Stock Location Choose stock location @if (Auth::user()->company_profile->show_purchase_order_details_in_order == 1) Purchase Order Date Purchase Order No. @endif Report Go Back Add Items is_verified == 1 ? 'checked' : '' }}> Verified Item Stock MRP Qty Disc % Mrp Unit Price Gross Value Taxable Value Tax Total Remarks @isset($orderItems) @php $tabIndex = 0; @endphp @if (count($orderItems) > 0) @foreach ($orderItems as $key => $orderItem) @php $key = $key + 1; @endphp Select item {{ $orderItem->stockItem->name }} --- @foreach ($orderItem->units as $unit) unit_id == $unit->id ? 'selected' : '' }}> {{ $unit->symbol }} @endforeach {{-- unit_id == $orderItem->unit->id ? 'selected' : '') : '' }}> {{ $orderItem->unit->symbol }} --}} {{ $orderItem->remarks }} @if ($orderItem->stock_availability != null && $orderItem->stock_availability != 0) @if ($orderItem->stock_availability == 'NS') Stock Shortage : {{ $orderItem->stock_availability }} @else Stock Shortage : {{ $orderItem->stock_availability }} Stock Remarks : {{ $orderItem->status_remarks }} @endif @endif @php $stockledger = \App\Models\StockLedger::select( 'stock_item_id', DB::raw('SUM(inwards) as total_inwards'), DB::raw('SUM(outwards) as total_outwards'), )->where( 'stock_item_id', $orderItem->stock_item_id, ); $stockledger = $stockledger->where( 'stock_location_id', $order->stock_location_id, ); $stockledger = $stockledger ->groupBy('stock_item_id') ->first(); $inwards = 0; $outwards = 0; if ($stockledger) { $inwards = $stockledger->total_inwards; $outwards = $stockledger->total_outwards; } $stock_availability = $inwards - $outwards; $order_base_qty = \App\Models\OrderItem::select( DB::raw('SUM(base_qty) as base_qty'), ) ->where( 'stock_item_id', $orderItem->stock_item_id, ) ->groupBy('stock_item_id') ->whereHas('order', function ($q) use ( $order, ) { $q->where( 'business_key', Auth::user()->business_key, ) ->where( 'order_code', '<', $order->order_code, ) ->where( 'status', '!=', 'Cancelled', ) ->whereNull( 'accounting_voucher_id', ); }) ->first()->base_qty ?? 0; $stock_availability = $stock_availability - $order_base_qty; @endphp @if ($stock_availability < 0) Available Stock:{{ $stock_availability }} @endif @php $tabIndex = $tabIndex + 5; @endphp @endforeach @endif @endisset {{ isset($orderItems) ? $orderItems->sum('total') : '0.00' }} Discount : Freight/Etc : Round Off : {{ isset($order) ? $order->round_off : '0.00' }} Grand Total : {{ isset($order) ? $order->amount : '0.00' }} Add Submit * Stock is based on the base unit of the item {{-- Print Modal --}}