{{-- @extends('docs.master', ['title' => 'Stock Report']) --}}
@extends( 'docs.master', ['title'=> 'Project Report '])
@section('content')
    <div class="document">
        <div class="document-heading">
            <div class="row">
    
                <div class="col col-1">
                    <img src="{{base_path('storage/app/uploads/'.settings()->get('uploaded_logo'))}}"  style="width:100px; margin-top: -25px;">
                </div>    
                <div class="col col-8" style=" margin-top: 50px;">           
                   <span> <h1 class="align-left" style="font-family:verdana;color:#6e1913; font-weight:bold;  margin-top: 50px;">{{settings()->get('company_name')}}</h1></span>
                   
                    <h2 class="align-left" style="font-family:verdana; font-weight:bold">{{$model[0]->projectname}} Details Report</h2>
                </div> 
                
                <div class="col col-3 align-right">
                    Dated: {{date('d-m-Y')}}
                </div>
              
               
              
            </div>
            {{-- <div class="row">
                <div class="col col-12">
                 
                    <h1 class="align-center">{{$model[0]->projectname}} Report</h1>
                    <p style="text-align: center">
                        <small>As On</small>
                        <br>
                        <small>{{date('M-d-Y h:i A')}}</small>

                    </p>
                </div>
            </div>
            <br>
            <br> --}}

        </div>
        <div class="document-body">
            <table class="document-table">
                <thead>
                    <tr row-border="1" style="height:25px" >
                        
                       
                        <th style="text-align: left;font-size: 150%;;font-weight:bold" colspan="11">Sold Unit</th>
                        
                        
                        
                    </tr>   
                <tr>
                    <th>#</th>
                    <th style="text-align: left">Project</th>
                    <th style="text-align: center">Unit Type</th>
                    <th style="text-align: center">Total Unit</th>
                    <th style="text-align: center">Sold Unit</th>
                    <th style="text-align: center">Sold Area</th>
                    <th style="text-align: center">Sold Price</th>                    
                    <th style="text-align: center">Rate / SQFT</th>                   
                    <th style="text-align: center">Receipts</th>
                    <th style="text-align: center">Receipts %AGE</th>
                    <th style="text-align: center">Balance</th>
                   
                </tr>
                </thead>
                <tbody>
                    {{$i=1}}
               
                @foreach($model as $item)
                    <tr>
                       
                        <td>{{$i++}}</td>
                        <td class="width-2">{{$item->projectname}}</td>
                        <td class="width-2">{{$item->unittype}}</td>
                        <td class="width-1 align-right">{{$item->total_unit}}</td>
                        <td class="width-1 align-right">{{$item->sold_count}}</td>
                        <td class="width-1 align-right">{{number_format($item->total_sale_area,0)}}</td>   
                        <td class="width-1 align-right">{{number_format($item->total_sale,0)}}</td>                                   
                        <td class="width-1 align-right">{{number_format($item->total_sale/$item->total_sale_area,0)}}</td>                                   
                        
                                       
                        <td class="width-1 align-right">{{number_format($item->total_receipts,0)}}</td>
                        <td class="width-1 align-right">{{number_format(($item->total_receipts/$item->total_sale)*100,0)}}</td>
                        <td class="width-1 align-right">{{number_format(($item->total_sale - $item->total_receipts),0)}}</td>
                    </tr>
                    @endforeach
                <tr class="item-footer">
                    <td colspan="3"><strong>Total</strong></td>

                    <td class="align-right">
                        <strong>{{number_format(array_sum(array_column($model, 'total_unit')), 0)}}</strong>
                    </td>
                    <td class="align-right">
                        <strong>{{number_format(array_sum(array_column($model, 'sold_count')),0)}}</strong>
                    </td>
                    <td class="align-right">
                        <strong>{{number_format(array_sum(array_column($model, 'total_sale_area')),0)}}</strong>
                    </td>
                    <td class="align-right">
                        <strong>{{number_format(array_sum(array_column($model, 'total_sale')),0)}}</strong>
                    </td>
                    @php 
                    $rate =array_sum(array_column($model, 'total_sale'))/ array_sum(array_column($model, 'total_sale_area'));
                    $balance =array_sum(array_column($model, 'total_sale'))- array_sum(array_column($model, 'total_receipts'));
                    $Receipt =(array_sum(array_column($model, 'total_receipts'))/array_sum(array_column($model, 'total_sale')))* 100 ;
                    @endphp
                    <td class="align-right">
                        <strong>{{number_format($rate,0)}}</strong>
                    </td>
                    <td class="align-right">
                        <strong>{{number_format(array_sum(array_column($model, 'total_receipts')),0)}}</strong>
                    </td>
                   
                    <td class="align-right">
                        <strong>{{number_format($Receipt,0)}}</strong>
                    </td>
                    <td class="align-right">
                        <strong>{{number_format($balance,0)}}</strong>
                    </td>
                    
                  
                   


                   
                   


                  
                </tr>
                </tbody>
            </table>
            
            <br /><br /><br />
            <table class="document-table" style="width:85%">
                <thead>
                    <tr row-border="1" style="height:25px" >
                        
                       
                        <th style="text-align: left;font-size: 150%;;font-weight:bold" colspan="8">Available Unit</th>
                        
                        
                        
                    </tr>   
                <tr>
                    <th  style="text-align: left;width:3%">#</th>
                    <th style="text-align: left;width:10%">Project</th>
                    <th style="text-align: center;width:10%">Unit Type</th>
                    <th style="text-align: center">Total Unit</th>
                    <th style="text-align: center">Available Unit</th>
                    <th style="text-align: center">Avail Area</th>

                    <th style="text-align: center">Available Price</th>                    
                    <th style="text-align: center">Rate / SQFT</th>                   
                    
                   
                </tr>
                </thead>
                <tbody>
                    {{$i=1}}
               {{-- @dd($model) --}}
                @foreach($model as $item)
                    <tr>
                       @if($item->available_count >0)
                        <td>{{$i++}}</td>
                        <td class="width-2">{{$item->projectname}}</td>
                        <td class="width-2">{{$item->unittype}}</td>
                        <td class="width-1 align-right">{{$item->total_unit}}</td>
                        <td class="width-1 align-right">{{$item->available_count}}</td>
                        <td class="width-1 align-right">{{number_format($item->available_area,0)}}</td>   
                        <td class="width-1 align-right">{{number_format($item->available_price,0)}}</td>                                   
                        <td class="width-1 align-right">{{number_format($item->available_price/$item->available_area,0)}}</td>                                   
                        
                       @endif                
                    
                    </tr>
                    @endforeach
                <tr class="item-footer">
                    <td colspan="3"><strong>Total</strong></td>

                    <td class="align-right">
                        <strong>{{number_format(array_sum(array_column($model, 'total_unit')), 0)}}</strong>
                    </td>
                    <td class="align-right">
                        <strong>{{number_format(array_sum(array_column($model, 'available_count')),0)}}</strong>
                    </td>
                    <td class="align-right">
                        <strong>{{number_format(array_sum(array_column($model, 'available_area')),0)}}</strong>
                    </td>
                    <td class="align-right">
                        <strong>{{number_format(array_sum(array_column($model, 'available_price')),0)}}</strong>
                    </td>
                    @php 
                    $rate_available =array_sum(array_column($model, 'available_price'))/ array_sum(array_column($model, 'available_area'));
                  
                    @endphp
                    <td class="align-right">
                        <strong>{{number_format($rate_available,0)}}</strong>
                    </td>
                    
                    
                  
                   


                   
                   


                  
                </tr>
                </tbody>
            </table>
            <div class="row">
                
                <div class="col col-8"  style="margin-top: -8px">
                   
                </div>
                <div class="col col-4 align-right"  style="margin-top: -8px">
                    <br />
                    <p style="font-style: italic;text-align: left">Printed On: {{date('d-m-Y h:i:s A')}} by {{Auth::User()->name}}</p>
                </div>
                
            </div>
        </div>
    </div>
@endsection