Blazma | Company Invoice

@if(!empty($invoice->ID))

@if($invoice->INVOICE_IS_ZATCA && !empty($invoice->INVOICE_ZATCA_SERIAL_NUMBER)) @endif

رقم الفاتورة :	{{$invoice->INVOICE_NO}}
رقم فاتورة هيئة الزكاة :	{{$invoice->INVOICE_ZATCA_SERIAL_NUMBER}}
تاريخ اصدار الفاتورة :	{{empty($date_to) ? date('Y-m-d',strtotime("+3 hours")) : date("Y-m-d",strtotime($date_to))}}
تاريخ التوريد :	{{date("Y-m-d",strtotime($date_from))}}
الى :	{{date("Y-m-d",strtotime($date_to))}}

@if($invoice->STATUS == 0 || is_null($invoice->STATUS)) فاتورة مسودة @else فاتورة ضريبية @endif

@if($qr_image)

@endif

معلومات المورد

الاسم:	{{$profile->C_INV_NAME}}
رقم المبنى:	{{$profile->C_BUILDING_NO}}
أسم الشارع:	{{$profile->C_STREET}}
الحي:	{{$profile->C_DISTRICT}}
المدينة:	{{$profile->C_CITY}}
البلد:	{{$profile->C_COUNTRY}}
الرمز البريدي:	{{$profile->C_POST_CODE}}
الرقم الضريبي:	{{$profile->VAT_NO}}

معلومات العميل

@if(!empty($user->CONTRACT_NO)) @endif @if(!empty($user->TENDER_NO)) @endif @if(!empty($user->PO_NO)) @endif

الاسم:	{{$user->C_INV_NAME}}
رقم المبنى:	{{$user->C_BUILDING_NO}}
أسم الشارع:	{{$user->C_STREET}}
الحي:	{{$user->C_DISTRICT}}
المدينة:	{{$user->C_CITY}}
البلد:	{{$user->C_COUNTRY}}
الرمز البريدي:	{{$user->C_POST_CODE}}
الرقم الضريبي:	{{$user->C_VAT_NO}}
رقم العقد:	{{$user->CONTRACT_NO}}
رقم العطاء:	{{$user->TENDER_NO}}
رقم أمر الشراء:	{{$user->PO_NO}}

@if(!empty($invoice->eNDUSER->CLIENT_LOGO))

@endif

تعتبر هذه الفاتورة نهائية و صحيحة ما لم يتم الرجوع إلينا خلال أسبوع من تاريخ الأستلام

رقم الفاتورة	الفترة من	إلى	أيام السداد	الكمية
@if(!empty($invoice->ID)) {{$invoice->INVOICE_NO}} @endif	{{date("Y-m-d",strtotime($date_from))}}	{{date("Y-m-d",strtotime($date_to))}}	{{date_diff(date_create($date_from),date_create($date_to))->format("%a")}}	{{count($orders)}}

الإجمالي(غیر شامل ضریبة القیمة المضافة)	{{round($net_total - $total_tax,2)}}	@if(isset($global_symbol['is_html_ar']) && $global_symbol['is_html_ar'] && isset($global_symbol['currency_ar'])) {!! $global_symbol['currency_ar'] !!} @else {{ $global_symbol['currency_ar'] ?? 'ر.س' }} @endif
مجموع الخصومات	{{round($invoice->DISCOUNT_TOTAL/100,2)}}	@if(isset($global_symbol['is_html_ar']) && $global_symbol['is_html_ar'] && isset($global_symbol['currency_ar'])) {!! $global_symbol['currency_ar'] !!} @else {{ $global_symbol['currency_ar'] ?? 'ر.س' }} @endif
الإجمالي الخاضع للضریبة (غیر شامل ضریبة القیمة المضافة)	{{round(($net_total - $total_tax),2)}}	@if(isset($global_symbol['is_html_ar']) && $global_symbol['is_html_ar'] && isset($global_symbol['currency_ar'])) {!! $global_symbol['currency_ar'] !!} @else {{ $global_symbol['currency_ar'] ?? 'ر.س' }} @endif
مجموع ضریبة القیمة المضافة	{{$total_tax}}	@if(isset($global_symbol['is_html_ar']) && $global_symbol['is_html_ar'] && isset($global_symbol['currency_ar'])) {!! $global_symbol['currency_ar'] !!} @else {{ $global_symbol['currency_ar'] ?? 'ر.س' }} @endif
إجمالي المبلغ (شامل الضريبة)	{{round($net_total,2)}}	@if(isset($global_symbol['is_html_ar']) && $global_symbol['is_html_ar'] && isset($global_symbol['currency_ar'])) {!! $global_symbol['currency_ar'] !!} @else {{ $global_symbol['currency_ar'] ?? 'ر.س' }} @endif
إجمالي المبلغ المدفوع	{{$paid_total}}	@if(isset($global_symbol['is_html_ar']) && $global_symbol['is_html_ar'] && isset($global_symbol['currency_ar'])) {!! $global_symbol['currency_ar'] !!} @else {{ $global_symbol['currency_ar'] ?? 'ر.س' }} @endif
إجمالي المبلغ المتبقي	{{round($net_total - $paid_total,2)}}	@if(isset($global_symbol['is_html_ar']) && $global_symbol['is_html_ar'] && isset($global_symbol['currency_ar'])) {!! $global_symbol['currency_ar'] !!} @else {{ $global_symbol['currency_ar'] ?? 'ر.س' }} @endif

@if(!empty($hospital_bank))

@if(!empty($hospital_bank->BANK_ACCOUNT_NUMBER)) @endif @if(!empty($hospital_bank->BANK_IBAN)) @endif

بيانات الحساب البنكي
اسم البنك	{{$hospital_bank->BANK_NAME_AR ?? $hospital_bank->BANK_NAME}}
رقم الحساب	{{$hospital_bank->BANK_ACCOUNT_NUMBER}}
الأيبان	{{$hospital_bank->BANK_IBAN}}

@endif

{{--@php $ordersChunks = $orders->chunk(16); @endphp--}} @php $baseRowHeight = 46; $additionalHeightPer29Chars = 21; $charLimit = 29; $patientRowHeight = 49; $maxPageHeight = 1200; $dynamicChunks = []; $currentChunk = []; $currentChunkHeight = 0; $lastPatientName = null; foreach ($orders as $order) { $isNewPatient = ($lastPatientName != $order['NAME']); $orderName = $order['lABCATEGORYPACKAGE']['NAME_AR'] ?? $order['lABCATEGORYPACKAGE']['NAME_EN']; $orderNameLength = strlen($orderName); $additionalHeight = 0; if ($orderNameLength > $charLimit) { $additionalSets = ceil(($orderNameLength - $charLimit) / $charLimit); $additionalHeight = $additionalSets * $additionalHeightPer29Chars; } $rowHeight = $baseRowHeight + $additionalHeight; if ($isNewPatient) { $lastPatientName = $order['NAME']; $rowHeight += $patientRowHeight; } if ($currentChunkHeight + $rowHeight > $maxPageHeight) { $dynamicChunks[] = $currentChunk; $currentChunk = []; $currentChunkHeight = $isNewPatient ? $patientRowHeight : 0; } $currentChunk[] = $order; $currentChunkHeight += $rowHeight; } if (!empty($currentChunk)) { $dynamicChunks[] = $currentChunk; } @endphp @php $summary = []; @endphp @foreach($dynamicChunks as $key => $chunk)

التفاصيل

@php $c = 1; @endphp @foreach($chunk as $order) @if(empty(($order['PRICE'] + $order['CREDIT_NOTE_PRICE']))) @continue @endif @if(isset($summary[$order['lABCATEGORYPACKAGE']['ID']])) @php $summary[$order['lABCATEGORYPACKAGE']['ID']]['qty'] +=1; $summary[$order['lABCATEGORYPACKAGE']['ID']]['tax'] +=round(($order['PRICE'] + $order['CREDIT_NOTE_PRICE']) - (($order['PRICE'] + $order['CREDIT_NOTE_PRICE']) / (1+$order['TAX'])),2); $summary[$order['lABCATEGORYPACKAGE']['ID']]['total'] +=($order['PRICE'] + $order['CREDIT_NOTE_PRICE']); $summary[$order['lABCATEGORYPACKAGE']['ID']]['paid'] +=($order['AMOUNT'] / 100); @endphp @else @php $summary[$order['lABCATEGORYPACKAGE']['ID']]['name'] =$user->IS_CLIENT_TEST_DETAILS ? ($order['lABCATEGORYPACKAGE']['CLIENT_TEST_NAME_AR'] ?? ($order['lABCATEGORYPACKAGE']['NAME_AR'] ?? $order['lABCATEGORYPACKAGE']['NAME_EN'])) : ($order['lABCATEGORYPACKAGE']['NAME_AR'] ?? $order['lABCATEGORYPACKAGE']['NAME_EN']); $summary[$order['lABCATEGORYPACKAGE']['ID']]['qty'] =1; $summary[$order['lABCATEGORYPACKAGE']['ID']]['unit_price'] =round((($order['PRICE'] + $order['CREDIT_NOTE_PRICE']) / (1+$order['TAX'])),2); $summary[$order['lABCATEGORYPACKAGE']['ID']]['tax'] =round(($order['PRICE'] + $order['CREDIT_NOTE_PRICE']) - (($order['PRICE'] + $order['CREDIT_NOTE_PRICE']) / (1+$order['TAX'])),2); $summary[$order['lABCATEGORYPACKAGE']['ID']]['total'] =round($order['PRICE'] + $order['CREDIT_NOTE_PRICE'],2); $summary[$order['lABCATEGORYPACKAGE']['ID']]['paid'] =($order['AMOUNT'] / 100); @endphp @endif @php $c++; @endphp @endforeach @if($key == count($dynamicChunks) - 1) @endif

رقم الحجز	اسم المريض	رقم الهوية	MRN	تاريخ الحجز	رمز الاختبار	اسم الاختبار	سعر الوحدة	إجمالي الضريبة	الإجمالي	المدفوع
{{$order['eNDUSERLABORDER']['ID']}}	{{$order['NAME']}}	{{$order['IDENTIFICATION']}}	{{$order['MRN']}}	{{$order['eNDUSERLABORDER']['CREATE_DATE']}}	{{$user->IS_CLIENT_TEST_DETAILS ? ($order['lABCATEGORYPACKAGE']['CLIENT_TEST_CODE'] ?? $order['lABCATEGORYPACKAGE']['CODE']) : $order['lABCATEGORYPACKAGE']['CODE']}}	{{$user->IS_CLIENT_TEST_DETAILS ? ($order['lABCATEGORYPACKAGE']['CLIENT_TEST_NAME_AR'] ?? ($order['lABCATEGORYPACKAGE']['NAME_AR'] ?? $order['lABCATEGORYPACKAGE']['NAME_EN'] )) : ($order['lABCATEGORYPACKAGE']['NAME_AR'] ?? $order['lABCATEGORYPACKAGE']['NAME_EN']) }}	{{round((($order['PRICE'] + $order['CREDIT_NOTE_PRICE']) / ($order['TAX']+1)),2)}}	{{round(($order['PRICE'] + $order['CREDIT_NOTE_PRICE']) - (($order['PRICE'] + $order['CREDIT_NOTE_PRICE']) / ($order['TAX']+1)),2)}}	{{round($order['PRICE'] + $order['CREDIT_NOTE_PRICE'],2)}}	{{$order['AMOUNT'] / 100}}
المجموع							{{round($net_total - $total_tax, 2)}}	{{round($total_tax,2)}}	{{round($net_total,2)}}	{{round($paid_total,2)}}

@endforeach

@if(!empty($summary)) @php $summary_total = 0; @endphp

الملخص

@foreach($summary as $testSummery) @php $summary_total += ($testSummery['total']); @endphp @endforeach

اسم الاختبار	الكمية	سعر الوحدة	إجمالي الضريبة	الإجمالي	المدفوع
{{$testSummery['name']}}	{{$testSummery['qty']}}	{{round($testSummery['unit_price'],2)}}	{{$testSummery['tax']}}	{{round($testSummery['total'],2)}}	{{round($testSummery['paid'],2)}}
المجموع	{{array_sum(array_column($summary, 'qty'))}}	{{array_sum(array_column($summary, 'unit_price'))}}	{{array_sum(array_column($summary, 'tax'))}}	{{round($summary_total,2)}}	{{array_sum(array_column($summary, 'paid'))}}

@endif