@extends('layouts.mop_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 Party (Dr) Select ledger Remarks {{ isset($order) ? $order->remarks : '' }} {{-- Ship To Address {{ isset($order) ? $order->ship_to_address : '' }} --}} {{-- Stock Location Choose stock location --}} Report Go Back Add Items Item MRP Qty Unit Price Price(Inc GST) Gross Value Disc% 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) || $orderItem->status_remarks != null) --}} {{-- @if ($orderItem->stock_availability == 'NS') --}} {{-- Stock Availability : {{ $orderItem->stock_availability }} @else --}} @if ($orderItem->stock_availability != null && $orderItem->stock_availability != 0) Stock Shortage : {{ $orderItem->stock_availability }} @endif @if ($orderItem->status_remarks != null) Stock Remarks : {{ $orderItem->status_remarks }} @endif {{-- @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 + 4; @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 --}}