Excess Requisition Entry Conformation Inforomation Excess Requisition Entry Conformation
  • Dashboard
  • Excess Requisition Entry Conformation
    •
    @if (session('message'))
    × {{ session('message') }}.
    @endif
    @csrf

    {{ $ChallanEntry->company }}
    Location {{ $ChallanEntry->location }} Order Cut No {{ $ChallanEntry->order_cut_no }}
    Challan No {{ $ChallanEntry->challan_no }} Input Date {{ $ChallanEntry->input_date }}
    Floor {{ $ChallanEntry->floor }} Line {{ $ChallanEntry->line }}
    {{-- --}} {{-- --}} @php $sl=0 @endphp @foreach ($SAPEntry as $spl) {{-- --}} @endforeach {{-- --}}
    Sl# Item Name Description Order No Wo No Budget Cons/DZN UOM Received Qty New Required Qty RemarksIssued Qty (PCS)Required Qty (PCS)
    {{ ++$sl }} {{ $spl->item_name }} {{ $spl->description }} {{ $spl->order_no }} {{ $spl->wo_no }} {{ number_format($spl->budget_cons_dzn, 2) }} {{ $spl->uom }} @php $main_required_qty = $spl->required_qty; $excess_qty = App\Models\TrimsExcessRequesation::where('store_accessory_process_entries_id', $id) ->where('challan_entries_id', $spl->challan_entries_id) ->where('item_name', $spl->item_name) ->where('description', $spl->description) ->where('order_no', $spl->order_no) ->where('wo_no', $spl->wo_no) ->where('uom', $spl->uom) ->get() ->sum('required_qty'); if ($excess_qty === null) { $excess_qty = 0; } $required_qty = $main_required_qty + $excess_qty; $main_required_qty_pcs = $spl->required_qty_pice; $excess_qty_pcs = App\Models\TrimsExcessRequesation::where('store_accessory_process_entries_id', $id) ->where('challan_entries_id', $spl->challan_entries_id) ->where('item_name', $spl->item_name) ->where('description', $spl->description) ->where('order_no', $spl->order_no) ->where('wo_no', $spl->wo_no) ->where('uom', $spl->uom) ->get() ->sum('required_qty_pice'); if ($excess_qty_pcs === null) { $excess_qty_pcs = 0; } $required_qty_pcs = $main_required_qty_pcs + $excess_qty_pcs; @endphp {{ $required_qty }} = {{ ceil($required_qty) }} --}} @php if ($spl->uom == 'Dzn') { // Round up to the next integer $required_qty_pcs = ceil($required_qty * 12); $total = $required_qty_pcs / 12; $dzn = floor($total); $pcs = round(($total - $dzn) * 12); $labelmessage = $dzn . ' DZN ' . $pcs . ' PCS'; } elseif ($spl->uom == 'Cone') { // Round up to the next integer $required_qty_pcs = ceil($required_qty * 1); $labelmessage = '1 Cone = 1 PCS'; } elseif ($spl->uom == 'GG') { // Round up to the next integer $required_qty_pcs = ceil($required_qty * 1728); $total = $required_qty_pcs / 1728; $gg = floor($total); $pcs = round(($total - $gg) * 1728); $labelmessage = $gg . ' GG ' . $pcs . ' PCS'; } else { $required_qty_pcs = ceil($required_qty * 1); } @endphp @if ($spl->required_qty == 0) @else @endif {{-- --}} {{--
    Total {{ $SAPEntry->sum('required_qty') }} --}} @php $totalRequiredQtyPcs = 0; @endphp @foreach ($SAPEntry as $spl) @php if ($spl->uom == 'Dzn') { // Round up to the next integer $required_qty_pcs = ceil($required_qty * 12); } elseif ($spl->uom == 'Cone') { // Round up to the next integer $required_qty_pcs = ceil($required_qty * 1); } elseif ($spl->uom == 'GG') { // Round up to the next integer $required_qty_pcs = ceil($required_qty * 1728); } else { $required_qty_pcs = $required_qty; } $totalRequiredQtyPcs += $required_qty_pcs; $totalRequiredQtyPcs = ceil($totalRequiredQtyPcs); @endphp @endforeach {{-- {{ $totalRequiredQtyPcs }} --}} {{-- --}} {{--

    Back