@extends('layouts/layoutMaster') @section('title', 'Batch Orders') @section('vendor-style') @vite([ 'resources/assets/vendor/libs/datatables-bs5/datatables.bootstrap5.scss', 'resources/assets/vendor/libs/datatables-responsive-bs5/responsive.bootstrap5.scss', 'resources/assets/vendor/libs/datatables-buttons-bs5/buttons.bootstrap5.scss', 'resources/assets/vendor/libs/select2/select2.scss', 'resources/assets/vendor/libs/@form-validation/form-validation.scss', 'resources/assets/vendor/libs/animate-css/animate.scss', 'resources/assets/vendor/libs/sweetalert2/sweetalert2.scss' ]) @endsection @section('vendor-script') @vite([ 'resources/assets/vendor/libs/moment/moment.js', 'resources/assets/vendor/libs/datatables-bs5/datatables-bootstrap5.js', 'resources/assets/vendor/libs/select2/select2.js', 'resources/assets/vendor/libs/@form-validation/popular.js', 'resources/assets/vendor/libs/@form-validation/bootstrap5.js', 'resources/assets/vendor/libs/@form-validation/auto-focus.js', 'resources/assets/vendor/libs/cleavejs/cleave.js', 'resources/assets/vendor/libs/cleavejs/cleave-phone.js', 'resources/assets/vendor/libs/sweetalert2/sweetalert2.js' ]) @endsection @section('content')
Batch Orders
{{--
--}}
{{-- --}}
Close
@php $count_row = 1; // Initialize row count @endphp
@foreach ($bom_process as $process)
Batch Process


@if(!empty($bom_materials) && $bom_materials->where('bom_process_id', $process->id)->isNotEmpty())
@csrf @if(!empty($bom_materials)) @php $counterMT = 1; @endphp @foreach ($bom_materials->where('bom_process_id', $process->id) as $material) @endforeach @endif
Id Material Name Qty / Tab Qty Std Batch Size Qty With Overage Total
{{ $counterMT++ }} {{ $material->material->name }}
%

{{-- @php $isRequested = \App\Models\BatchMaterialRequest::where('bom_process_id', $process->id) ->where('batch_order_id', $batchOrder->id) ->exists(); $batchMatReq = \App\Models\BatchMaterialRequest::where('bom_process_id', $process->id) ->where('batch_order_id', $batchOrder->id)->get(); $debited = false; foreach ($batchMatReq as $request) { $debited = \App\Models\MaterialInventor::where('batch_material_req_id', $request->id)->exists(); if ($debited) { break; } } @endphp @if(!$isRequested) @elseif($debited) @else @endif --}}
@endif

@if(!empty($bom_sub_processes) && $bom_sub_processes->where('bom_process_id', $process->id)->isNotEmpty()) @if(!empty($bom_sub_processes)) @php $counterSP = 1; @endphp @foreach ($bom_sub_processes->where('bom_process_id', $process->id) as $subProcess) @endforeach @endif
Id Sub Process
{{ $counterSP++ }}
@endif
@php $isRequested = \App\Models\BatchMaterialRequest::where('bom_process_id', $process->id) ->where('batch_order_id', $batchOrder->id) ->exists(); $batchMatReqs = \App\Models\BatchMaterialRequest::where('bom_process_id', $process->id) ->where('batch_order_id', $batchOrder->id)->get()->keyBy('batch_qty_no'); $debited = false; foreach ($batchMatReqs as $request) { $debited = \App\Models\MaterialInventor::where('batch_material_req_id', $request->id)->exists(); if ($debited) { break; } } $totalBatches = ($batchOrder->quantity && $batchOrder->quantity > 0) ? $batchOrder->quantity : 1; @endphp @for ($i = 1; $i <= $totalBatches; $i++) @php $batchReq = $batchMatReqs->get($i); $isRequested = !empty($batchReq); $debited = false; if ($batchReq) { $debited = \App\Models\MaterialInventor::where('batch_material_req_id', $batchReq->id)->exists(); } @endphp
Batch #Qty{{ $i }}
@if(!$isRequested) @elseif($debited) @else @endif
@php $batchOrderRecordEndtime = \App\Models\BatchOrderRecords::where('batch_order_id', $batchOrder->id) ->where('bom_process_id', $process->id) ->where('bom_id', $process->bom_id) ->where('batch_qty_no', $i) ->whereNull('end_date') ->first(); $batchOrderRecord = \App\Models\BatchOrderRecords::where('batch_order_id', $batchOrder->id) ->where('bom_process_id', $process->id) ->where('bom_id', $process->bom_id) ->where('batch_qty_no', $i) ->whereNotNull('end_date') ->whereNotNull('start_date') ->first(); @endphp @if ($batchOrderRecord)
@else
@csrf @if ($batchOrderRecordEndtime) @endif
@endif
@if(!empty($bom_testings) && $bom_testings->where('bom_process_id', $process->id)->isNotEmpty()) @if (!empty($bom_testings)) @php $counterBT = 1; @endphp @foreach ($bom_testings->where('bom_process_id', $process->id) as $testing) @php $isStored = \App\Models\BatchOrderTesting::where('bom_process_id', $process->id) ->where('batch_order_id', $batchOrder->id) ->where('bom_testing_id', $testing->id) ->where('batch_qty_no', $i) ->first(); @endphp @endforeach @endif
Id Test Description Standards Test By Result Action
{{ $counterBT++ }} @if (!empty($isStored)) @else @endif @if (!empty($isStored)) @else @endif
@endif

{{-- {{ dd($process->process_name) }} --}} @if($process->process_name == "Granulation/ Pellet Coating/ Slugging" || $process->process_name == "Blending") @php $batchOrderReconData = \App\Models\BatchOrderReconsulation::where('bom_process_id', $process->id)->where('batch_order_id', $batchOrder->id)->where('batch_qty_no', $i)->first(); @endphp @if(!empty($batchOrderReconData))
@php $unit = match($bom_data->weight_uom) {'Mg' => 'Kg', 'Ml' => 'L', default => $bom_data->weight_uom,}; @endphp

@else @php $previousProcessId = $process->id-1; $previousReconsulationData = \App\Models\BatchOrderReconsulation::where('bom_process_id', $previousProcessId)->where('batch_order_id', $batchOrder->id)->where('batch_qty_no', $i)->first(); $batchRecordRedata = \App\Models\BatchOrderRecords::where('batch_order_id', $batchOrder->id) ->where('bom_process_id', $process->id) ->where('bom_id', $process->bom_id) ->where('batch_qty_no', $i) ->first(); $unit = match($bom_data->weight_uom) {'Mg' => 'Kg', 'Ml' => 'L', default => $bom_data->weight_uom,}; @endphp
{{-- {{ dd($bom_data) }} --}} {{-- value="{{ $bom_data->weight_uom === 'Mg' ? 'Kg' : ($bom_data->weight_uom === 'Ml' ? 'L' : $bom_data->weight_uom) }}" --}}

@if(empty($batchRecordRedata) || $batchRecordRedata->end_date == NULL) @else @endif
@endif @elseif($process->process_name == "Compression" || $process->process_name == "Coating" || $process->process_name == "Inspection" || $process->process_name == "Imprinting") @php $batchOrderReconDataN = \App\Models\BatchOrderReconsulation::where('bom_process_id', $process->id)->where('batch_order_id', $batchOrder->id)->where('batch_qty_no', $i)->first(); @endphp @php $previousProcessIdN = $process->id-1; $previousReconsulationDataN = \App\Models\BatchOrderReconsulation::where('bom_process_id', $previousProcessIdN)->where('batch_order_id', $batchOrder->id)->where('batch_qty_no', $i)->first(); $batchRecordNRedata = \App\Models\BatchOrderRecords::where('batch_order_id', $batchOrder->id) ->where('bom_process_id', $process->id) ->where('bom_id', $process->bom_id) ->where('batch_qty_no', $i) ->first(); @endphp @if(!empty($batchOrderReconDataN))
{{-- @if(!empty($previousReconsulationDataN)) @php $BatchSizeAsProcess = $previousReconsulationDataN->actual_yield * 1000000 / $bom_data->avg_weight; @endphp @endif --}}

@else
@if(!empty($previousReconsulationDataN)) @php $BatchSizeAsProcess = $previousReconsulationDataN->actual_yield !== null ? ($previousReconsulationDataN->actual_yield * 1000000 / $bom_data->avg_weight) : $previousReconsulationDataN->actual_no_of_compressed_tab_cap; @endphp @endif

@if(empty($batchRecordNRedata) || $batchRecordNRedata->end_date == NULL) @else @endif
@endif @endif
@endfor
@php $count_row++; // Increment the row count for the next process @endphp @endforeach @php $batchProcessFinal = \App\Models\Bom_Process::where('bom_id', $bom_data->id)->get(); $allExist = true; foreach ($batchProcessFinal as $process) { $exists = \App\Models\BatchOrderReconsulation::where('bom_process_id', $process->id)->exists(); if (!$exists) { $allExist = false; break; } } $batchPackingRecord = \App\Models\BatchPackingRecord::where('batch_order_id', $batchOrder->id)->exists(); // dd($batchPackingRecord); @endphp @if($batchPackingRecord)
@else
@csrf {{-- {{ dd($batchOrder->product_id,$batchOrder->bom_id,$batchOrder->id) }} --}}
@endif
@endsection