@php $is_official = $search_by['is_official']; $total_cost_amount = $total_sell_amount = 0; $location_data_array = []; @endphp @foreach($product_locations as $location) @endforeach @foreach($products as $product) @php $cost_rate = $product->cost_per_size + $product->cost_per_size_unofficial; $sell_rate = $product->rate_per_size + $product->rate_per_size_unofficial; $sell_amount = $product->fixed_amount_official + $product->fixed_amount_unofficial; if($is_official == 'official'){ $cost_rate = $product->cost_per_size; $sell_rate = $product->rate_per_size; $sell_amount = $product->fixed_amount_official; } elseif($is_official == 'unofficial'){ $cost_rate = $product->cost_per_size_unofficial; $sell_rate = $product->rate_per_size_unofficial; $sell_amount = $product->fixed_amount_unofficial; } $cost_amount = $product->flat_size * $cost_rate; $product_fixed_amount = $sell_amount; $product_status = "Booked"; $status_label = "badge badge-info"; if($product->status == "AVAILABLE"){ $status_label = "badge badge-success"; $product_status = "Vacant"; } $total_cost_amount += $cost_amount ; $total_sell_amount += $sell_amount ; @endphp @foreach($product_locations as $location) @php $location_amount = 0 @endphp @foreach ($product->location as $product_location) @php if($product_location->int_location == $location->id && $is_official != 'official'){ $location_amount += $product_location->price; } @endphp @endforeach @php $product_fixed_amount += $location_amount; $location_data_array[$location->id] += $location_amount; @endphp @endforeach @php $total_product_fixed_amount += $product_fixed_amount ; @endphp @endforeach @foreach($product_locations as $location) @endforeach

{{__('lang.sno')}}	{{__('lang.type')}}	{{__('lang.category')}}	{{__('lang.unit')}}	{{__('lang.size')}}	{{__('lang.block')}}	{{__('lang.cost_rps')}}	{{__('lang.cost_amount')}} ({{config('settings.currency_symbol')}})	{{__('lang.sale_rps')}}	{{__('lang.sale_amount')}} ({{config('settings.currency_symbol')}})	{{ $location->name }}	{{__('lang.net_amount')}} ({{config('settings.currency_symbol')}})	{{__('lang.status')}}
{{ $loop->iteration }}	{{ $product->type->name ?? '-' }}	{{ $product->category->name ?? '-' }}	{{ $product->product_unique_id }}	{{ $product->flat_size }} - {{ $product->size_in }}	{{ $product->block->name ?? '-'}}	{{ $transaction->convert_money_format($cost_rate) }}	{{ $transaction->convert_money_format($cost_amount) }}	{{ $transaction->convert_money_format($sell_rate) }}	{{ $transaction->convert_money_format($sell_amount) }}	{{$transaction->convert_money_format($location_amount)}}	{{ $transaction->convert_money_format($product_fixed_amount) }}	{{ $product_status}}
{{__('lang.total')}}							{{ $transaction->convert_money_format($total_cost_amount) }}		{{ $transaction->convert_money_format($total_sell_amount) }}	{{$transaction->convert_money_format($location_data_array[$location->id])}}	{{ $transaction->convert_money_format($total_product_fixed_amount) }}