@extends('layouts.app')

@section('title')
Sold  Inventory Statement
@stop


@section('breadcrumb')
<ol class="breadcrumb pull-right no-print">
        <li><a href="{{route('home')}}"><i class="fa fa-dashboard"></i> Home</a></li>

        <li class="active">Sold Inventory Statement</li>
      </ol>
@stop

@section('css')
<style type="text/css">
     @media print {
        .page-wrapper{
        font-size: 12px !important;
        font-family: "time-new-roman",Arial,sans-serif !important;
        padding-top: 0px !important;
        color:black;
    }
   .printableArea {
        color: black;
    }
    strong{
        color: black;
    }
    .pd-5{
        padding:5px;
    }
    .br-btm {
           border-bottom: 1px solid #e6e3e3;
    }
    /*.br-right {
         border-right: 1px solid #e6e3e3;
    }*/
    .txt-c {
        text-align: center;
    }
    .white-box{
        border: none!important;
        padding: 0 3px 0 0px;
    }
     .dataTables_info{
        display: none;
    }
    .dataTables_filter{
        display: none;
    }
    div.dt-buttons{
        display: none;
    }
    table.dataTable thead th {
    border: 1px solid #f2f2f2 !important;
    }
    .table>tbody>tr>td {
     border: 1px solid #f2f2f2 !important; 
    }
    .bor .border-d{
        border-bottom: double !important;
        border-top: 1px solid !important;
    }
    h3 strong{
        text-transform: uppercase;
    }
    h4 strong{
        text-transform: uppercase;
    }
    h3{
        margin-bottom: -10px;
    }
    table.dataTable.no-footer {
    border-bottom: none !important;
    }
    .table>tbody>tr>td, .table>tbody>tr>th {
    font-size: 12px;
    }
    .page-wrapper {
    padding-top: 0px;
    }
    .white-box1{
        padding: 0;
    }
      .bdr thead tr th  {
    border: 1px solid #2e3233 !important;
    background: #eee;
    }
    .table>thead:first-child>tr:first-child>th {
    border-top: 1px solid !important;
}


    }
</style>

<!-- <link href="https://cdn.datatables.net/1.10.24/css/jquery.dataTables.min.css" rel="stylesheet"> -->
<link href="https://cdn.datatables.net/buttons/1.7.0/css/buttons.dataTables.min.css"  rel="stylesheet">
@stop

@section('content')

<div class="container-fluid">
                <div class="row printableArea">
                    <div class="col-lg-12  ">
                    <div class="white-box">

                        <div class="text-center">
                            <h3><strong>{{env('APP_NAME')}}</strong></h3>
                            <h4><strong>Sold Inventory Statement</strong></h4>
                             <h6>{{date(('d/m/Y'),strtotime($from_date))}} - {{date(('d/m/Y'),strtotime($to_date))}}</h6>
                        </div>


                        <div class="pull-right printFV" >
                            <span>Date: <b>{{date('d/m/Y')}}</b></span><br>
                            <span>User ID: &nbsp; {{Auth::user()->name}}</span>
                        </div>

                    <div class="table-responsive" style="clear: both;">
                        
                        @if($type == 'with_filter')
                        <form method="post" style="position: relative;left: 35rem;top: 3.5rem;z-index: 9999;width: 65%;" action="{{route('report.sold-inventory-generate')}}" class="no-print">
                              {{ csrf_field() }}
                                <div class="row">
                                    <div class="col-lg-5">
                                      
                                        <input type="hidden" value="{{$selected_date_range}}" name="date_range">

                                        <select class="form-control chosen-select" name="block">
                                        <option value="">All Blocks</option>
                                        @foreach($unit_blocks as $unit_block)
                                        <option selected value="{{$unit_block->id}}">{{$unit_block->name}}</option>
                                        @endforeach
                                        </select>
                                    </div>


                                    <div class="col-lg-2">
                                       <input type="submit" value="Filter" class="btn btn-success">
                                    </div>


                                </div>
                            </form>
                        @endif

                                <table id="example1"  class="table bdr table-bordered">
                                    <thead>
                                        <tr>
                                            <th style="width: 90px;">Sr No.</th>
                                            <th style="width: 120.861px;">Date</th>
                                            <th style="width: 65.861px;">Unit No.</th>
                                            <th style="width: 110.861px;">Unit Floor.</th>
                                            <th >Unit Block.</th>
                                            <th >Customer</th>
                                            <th >Size</th>
                                            <th >Category</th>
                                            <th >Inventory Price</th>
                                            <th >Discount</th>
                                            <th >Net Price</th>
                                            
                                        </tr>
                                    </thead>
                                    <tbody>
                                                                        
                                     @foreach($unit_blocks as $unit_block)
                                     
                                     
                                        <tr>
                                            <td style="border-right: none;"><b>{{$unit_block->name}}</b></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-left: none;"></td>
                                        </tr>
                                  
                                                                          
                                        @foreach($inventories as $inventory)


                                        @if($unit_block->id == $inventory->floor->unit_block_id)
                                        
                                        
                                        
                                        @if( ($filter_type == 'filter' && $block > 0 && $block ==  $inventory->floor->unit_block_id ) || $filter_type == 'all' ) 
                                                                                <tr>
                                            <td>{{$count++}}</td>
                                            
                                            <td class="printFV"> {{date('d/m/Y', strtotime($inventory->customer_property->booking_date)) }}</td>
                                            
                                            <td class="printFV">{{$inventory->unit_number}}</td>

                                            <td class="printFV">{{$inventory->floor ? $inventory->floor->name : ''}}</td>

                                            <td class="printFV">{{$inventory->floor ? \App\UnitBlock::find($inventory->floor->unit_block_id)->name : ''}}</td>
                                            
                                             <td class="printFV">{{$inventory->customer_property->customer->name}}</td> 
                                            
                                    
                                            <td class="printFV">
                                                                                                   {{$inventory->size->name}}  {{env('SIZE')}}
                                            </td>
                                                                                                <td>
                                                        @foreach($inventory->categories as $c)
                                                                                                                @if($loop->last)
                                                        {{$c->category->name}} ({{$c->category->percent}} %)
                                                        @else
                                                        {{$c->category->name}} ({{$c->category->percent}} %),
                                                        @endif
                                                        @endforeach
                                                    </td>
                                                    
                                            <td >
                                                                                             {{ number_format($inventory->total_price)}} 
                                            </td>
                                            
                                            <td >
                                            
                                            @if(($inventory->total_price - $inventory->customer_property->net_pay) > 0 ) 
                                            {{ number_format( $inventory->total_price - $inventory->customer_property->net_pay ) }} 
                                            
                                            @else
                                            {{'-'}} 
                                            @endif
                                                                                        
                                            </td>
                                            
                                            <td >
                                                                                                @if($inventory->customer_property){{number_format($inventory->customer_property->net_pay)}}
                                                @endif
                                            </td>
                                            
                                        </tr>
                                                @endif 
                                         @endif 

                                            @endforeach
                                            
                                            <tr>
                                            
                                            <td style="border-right: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"><b>Sub-Total</b></td>
                                            <td style="border-right: none;border-left: none;"><b>{{$sqrt_size}} {{env('SIZE')}}</b></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"><b>{{number_format($block_ivn_total)}}</b></td>
                                            <td  style="border-right: none;border-left: none;"><b>{{number_format($block_dis_total)}}</b></td>
                                            <td style="border-left: none;"><b>{{number_format($block_net_total)}}</b></td>
                                            
                                        </tr>
                                        
                                            
                                       @endforeach 
                                        
                                         <tr>
                                         
                                            <td style="border-right: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"><b>GRAND TOTAL</b></td>
                                            <td style="border-right: none;border-left: none;"><b>{{$sqrt}} {{env('SIZE')}}</b></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"><b>{{number_format($inventory_price)}}</b></td>
                                            <td  style="border-right: none;border-left: none;"><b>{{number_format($discount_price)}}</b></td>
                                            <td style="border-left: none;"><b>{{number_format($net_price)}}</b></td>
                                            
                                        </tr>
                                        
                                        
                                        
                                        
                                        <tr>
                                            <td style="border-right: none;"></td>
                                           
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            
                                         
                                            
                                            <td  class="text-right" style="border-right: none;border-left: none;"><b>Sold Inventory Amount</b></td>
                                            <td class="text-right" style="border-left: none;"><b>{{number_format($net_price)}}</b></td>
                                        </tr>
                                        <tr>
                                           <td style="border-right: none;"></td>
                                           
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            
                                          
                                            
                                            <td  class="text-right" style="border-right: none;border-left: none;"><b>Received Amount</b></td>
                                            <td class="text-right" style="border-left: none;"><b>{{number_format($receivedAmt)}}</b></td>
                                        </tr>
                                        <tr>
                                             <td style="border-right: none;"></td>
                                           
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            <td style="border-right: none;border-left: none;"></td>
                                            
                                         
                                            
                                            <td  class="text-right" style="border-right: none;border-left: none;"><b>Remaining Amount</b></td>
                                            <td class="text-right" style="border-left: none;"><b>{{number_format($net_price - $receivedAmt)}}</b></td>
                                        </tr>
                                        
                                    </tbody>
                                </table>

                        </div>
                    </div>
                </div>
            </div>
        </div>
            <!-- /.container-fluid -->

                <div class="text-right" style="height:70px;">
                                        <button  class="btn btn-default btn-outline no-print" onclick="window.print();return false;" type="button"> <span><i class="fa fa-print"></i> Print</span> </button>
                                    </div>

@stop

@section('js')
<script src="{{asset('js/jquery.PrintArea.js')}}" type="text/JavaScript"></script>

     <script src="https://cdn.datatables.net/1.10.24/js/jquery.dataTables.min.js"></script>
 <script src="https://cdn.datatables.net/buttons/1.7.0/js/dataTables.buttons.min.js"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
 <script src="https://cdn.datatables.net/buttons/1.7.0/js/buttons.html5.min.js"></script>
  <script src="https://cdn.datatables.net/buttons/1.7.0/js/buttons.print.min.js"></script>

<script>
    $(function() {
        $("#print").on("click", function() {
            var mode = 'iframe'; //popup
            var close = mode == "popup";
            var options = {
                mode: mode,
                popClose: close
            };
            $("div.printableArea").printArea(options);
        });
    });
    $('#example1').DataTable( {
        sorting:true,
        paging:false,
        ordering:true,
        dom: 'Bfrtip',
        buttons: [
            'copy', 'csv', 'excel', 'pdf', 'print'
        ]
    } );
    </script>
@stop