@lang('accounting/warehouses/reports/detailed-items.from_date')

@lang('accounting/warehouses/reports/detailed-items.to_date')

@lang('accounting/warehouses/reports/detailed-items.branche') @php $selected_branches_ids = request('branches_ids') ?? []; @endphp

@lang('accounting/warehouses/reports/detailed-items.based_on') @php $selected_based_on = request('based_on') ?? 'category'; @endphp

@php $categories_ids = request('categories_ids')?? []; @endphp @lang('accounting/warehouses/reports/detailed-items.family')

@php $selected_time_separator = request('time_separator') ?? 'daily'; @endphp @lang('accounting/warehouses/reports/detailed-items.yearly') @lang('accounting/warehouses/reports/detailed-items.monthly') @lang('accounting/warehouses/reports/detailed-items.daily')

{{--

تجميع على أساس التاريخ @php $selected_group_by_date = request()->has('group_by_date')? request('group_by_date') : true; @endphp

نعم

لا

تجميع على أساس @php $selected_group_by = request('group_by') ?? 'category'; @endphp

--}}

@lang('accounting/warehouses/reports/detailed-items.visible_columns')

@lang('accounting/warehouses/reports/detailed-items.item_detail_report')

@lang('accounting/warehouses/reports/detailed-items.download_pdf') @php $query = (count(request()->all()) > 0)? '?' . explode('?', request()->fullUrl())[1] : "" @endphp @lang('accounting/warehouses/reports/detailed-items.export_excel')

@php $table_options = [ // 'enableSumValuesOnColumns' => [4, 6], 'lang' => ['noAvailableData' => __('noAvailableData.no_information_yet')], ]; @endphp @php $from_date = request('from_date') ?? $active_year->from; $to_date = request('to_date') ?? $active_year->to; @endphp

@if (request()->from_date)

@lang('accounting/reports/accounts/trial-balance.from_date') {{ $from_date }}

@endif @if (request()->to_date)

@lang('accounting/reports/accounts/trial-balance.to_date') {{ $to_date }}

@endif

@foreach ($columns as $column_key => $column_info) @if (in_array($column_key, $selected_columns ?? [])) @endif @endforeach @foreach ($results as $result) @if ($result['row_type'] == 'header') @php $model_title = match ($result['model_type']) { 'category' => 'العائلة', 'supplier' => 'المورّد', 'classification' => 'التصنيف', 'item' => 'المادة', }; $model_instance_name = match ($result['model_type']) { 'category' => $result['category']->name, 'supplier' => $result['supplier']->name, 'classification' => $result['classification']->name, 'item' => $result['item']->ar_name, }; @endphp @for ($i = 0; $i <= count($selected_columns ?? []) - 2; $i++) @endfor @endif @forelse ($result['values'] as $date => $values) @php $net_sales_before_taxes = $net_sales_after_taxes = null; $net_purchases_before_taxes = $net_purchases_after_taxes = null; $net_sales_costs = 0; $net_profit = $profit_ratio = 0; $damaged_ratio_from_sales = $damaged_ratio_from_net_profit = 0; if (!is_null($values['sales_values'])) { $net_sales_before_taxes = $values['sales_values']['total_sales_before_taxes'] - (isset($values['returned_sales_values']) ? $values['returned_sales_values'][ 'total_returned_sales_before_taxes' ] : 0); $net_sales_after_taxes = $values['sales_values']['total_sales_after_taxes'] - (isset($values['returned_sales_values']) ? $values['returned_sales_values'][ 'total_returned_sales_after_taxes' ] : 0); $net_sales_costs += $values['sales_values']['total_sales_costs']; $net_profit = $net_sales_before_taxes - $net_sales_costs; if ($values['sales_values']['total_sales_before_taxes'] > 0) { $profit_ratio = (($values['sales_values']['total_sales_before_taxes'] - $values['sales_values']['total_sales_costs']) / $values['sales_values']['total_sales_before_taxes']) * 100; } if ( $values['out_bonds_values'] && $values['sales_values']['total_sales_before_taxes'] > 0 ) { $damaged_ratio_from_sales = ($values['out_bonds_values']['total_out_damaged_costs'] / $values['sales_values']['total_sales_before_taxes']) * 100; } } if (!is_null($values['purchases_values'])) { $net_purchases_before_taxes = $values['purchases_values']['total_purchases_before_taxes'] - (isset($values['returned_purchases_values']) ? $values['returned_purchases_values'][ 'total_returned_purchases_before_taxes' ] : 0); $net_purchases_after_taxes = $values['purchases_values']['total_purchases_after_taxes'] - (isset($values['returned_purchases_values']) ? $values['returned_purchases_values'][ 'total_returned_purchases_after_taxes' ] : 0); } if ($values['out_bonds_values']) { $net_sales_costs += $values['out_bonds_values']['total_out_damaged_costs']; $net_profit -= $values['out_bonds_values']['total_out_damaged_costs']; if ($net_profit) { $damaged_ratio_from_net_profit = ($values['out_bonds_values']['total_out_damaged_costs'] / $net_profit) * 100; } } @endphp @empty @for ($i = 1; $i <= count($selected_columns ?? []) + 1; $i++) @endfor @endforelse @endforeach

@lang('accounting/warehouses/reports/detailed-items.date')	{{ $column_info['name'] }}
{{ $model_title }} :	{{ $model_instance_name }}
{{ $date }}	{{ $getValueCell($values, 'sales_values', 'total_sales_before_taxes') }}	{{ $getValueCell($values, 'sales_values', 'total_sales_after_taxes') }}	{{ $getValueCell($values, 'purchases_values', 'total_purchases_before_taxes') }}	{{ $getValueCell($values, 'purchases_values', 'total_purchases_after_taxes') }}	{{ $getValueCell($values, 'returned_sales_values', 'total_returned_sales_before_taxes') }}	{{ $getValueCell($values, 'returned_sales_values', 'total_returned_sales_after_taxes') }}	{{ $getValueCell($values, 'returned_purchases_values', 'total_returned_purchases_before_taxes') }}	{{ $getValueCell($values, 'returned_purchases_values', 'total_returned_purchases_after_taxes') }}	{{ $net_sales_before_taxes ? dn($net_sales_before_taxes) : '---' }}	{{ $net_sales_after_taxes ? dn($net_sales_after_taxes) : '---' }}	{{ $net_purchases_before_taxes ? dn($net_purchases_before_taxes) : '---' }}	{{ $net_purchases_after_taxes ? dn($net_purchases_after_taxes) : '---' }}	{{ $getValueCell($values, 'sales_values', 'total_sales_costs') }}	{{ dn($net_sales_costs) }}	{{ $getValueCell($values, 'sales_values', 'total_sales_quantities') }}	{{ $getValueCell($values, 'purchases_values', 'total_purchases_quantities') }}	{{ $getValueCell($values, 'returned_sales_values', 'total_returned_sales_quantities') }}	{{ $getValueCell($values, 'returned_purchases_values', 'total_returned_purchases_quantities') }}	{{ dn($net_profit) }}	{{ $getValueCell($values, 'entries_values', 'total_entries_quantities') }}	{{ $getValueCell($values, 'entries_values', 'total_entries_costs') }}	{{ $getValueCell($values, 'out_bonds_values', 'total_out_bonds_quantities') }}	{{ $getValueCell($values, 'out_bonds_values', 'total_out_bonds_costs') }}	{{ $getValueCell($values, 'stocktaking_bonds_values', 'net_stocktaking_quantities') }}	{{ $getValueCell($values, 'stocktaking_bonds_values', 'net_stocktaking_values') }}	{{ $getValueCell($values, 'out_bonds_values', 'total_out_damaged_quantites') }}	{{ $getValueCell($values, 'out_bonds_values', 'total_out_damaged_costs') }}	{{ dn($damaged_ratio_from_sales) }} %	{{ dn($damaged_ratio_from_net_profit) }} %	{{ $getValueCell($values, 'out_bonds_values', 'total_out_exchange_quantites') }}	{{ $getValueCell($values, 'out_bonds_values', 'total_out_exchange_costs') }}	{{ dn($profit_ratio) }} %