@extends('layouts/fams_layout')
@section('title', '| Report')
@section('content')
@php 
    use App\Service\UserUtility; 
    $hasAccessToViewAllProjects = UserUtility::hasAccessToViewAllProjects();

    $projectSelected = isset($_GET['searchProject']) ? $_GET['searchProject'] : null;
    $projectTypeSelected = isset($_GET['searchProjectType']) ? $_GET['searchProjectType'] : null;
    $branchSelected = isset($_GET['searchBranch']) ? $_GET['searchBranch'] : null;
    $categorySelected = isset($_GET['searchCategory']) ? $_GET['searchCategory'] : null;
    $productTypeSelected = isset($_GET['searchProductType']) ? $_GET['searchProductType'] : null;
    $searchMethodSelected = isset($_GET['searchMethod']) ? $_GET['searchMethod'] : null;
    $fiscalYearSelected = isset($_GET['fiscalYear']) ? $_GET['fiscalYear'] : null;
    $dateFromSelected = isset($_GET['dateFrom']) ? $_GET['dateFrom'] : null;
    $dateToSelected = isset($_GET['dateTo']) ? $_GET['dateTo'] : null;
    $firstRequest = isset($_GET['fiscalYear']) ? '1' : '0';
   
@endphp
   
    <div class="row">
        <div class="col-md-12">
            <div class="" style="">
            <div class="">

                <div class="panel panel-default" style="background-color:#708090;">
                    <div class="panel-heading" style="padding-bottom:0px">
                        <div class="panel-options">
                            <a href="" class="btn btn-info pull-right addViewBtn" id="print"><i class="fa fa-print" aria-hidden="true"></i> Print</a>

                        </div>


                        
                        <div class="row" id="filtering-group">
                            
                                <div class="form-horizontal form-groups" style="padding-right: 0px;">

                                    {!! Form::open(['url' => 'famsRegisterUseReport','method' => 'get']) !!}
                                    @php
                                        $userBranchId = Auth::user()->branchId;
                                    @endphp

                                    @if($userBranchId==1)
                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                             <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Project:', ['class' => 'control-label pull-left']) !!}
                                            </div> 

                                            @php
                                                // $projects = DB::table('gnr_project')->select('id','name','projectCode')->get();
                                                $projects = UserUtility::getUserAccessibleProjects()->select('id','name','projectCode')->get();
                                            @endphp

                                            <div class="col-sm-12">
                                                <select name="searchProject" class="form-control input-sm" id="searchProject">
                                                    @if($hasAccessToViewAllProjects) <option value="">All</option>  @endif 
                                                    @foreach($projects as $project)
                                                    <option value="{{$project->id}}" @if($project->id==$projectSelected){{"selected=selected"}}@endif>{{str_pad($project->projectCode,3,"0",STR_PAD_LEFT).'-'.$project->name}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>
                                    </div>
                                    @endif

                                    @if($userBranchId==1)
                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Pro. Type:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            @php
                                            if ($projectSelected!=null) {
                                                $projectTypes = DB::table('gnr_project_type')->where('projectId',$projectSelected)->select('id','name','projectTypeCode')->get();
                                            }
                                            else{
                                                $projectTypes = DB::table('gnr_project_type')->select('id','name','projectTypeCode')->get();
                                            }
                                            @endphp

                                            <div class="col-sm-12">
                                                <select name="searchProjectType" class="form-control input-sm" id="searchProjectType">
                                                    <option value="">All</option>
                                                    @foreach($projectTypes as $projectType)
                                                    <option value="{{$projectType->id}}" @if($projectType->id==$projectTypeSelected){{"selected=selected"}}@endif>{{str_pad($projectType->projectTypeCode,3,"0",STR_PAD_LEFT).'-'.$projectType->name}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>
                                    </div>
                                    @endif

                                    @if($userBranchId==1)
                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Branch:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                             @php
                                             $branches = DB::table('gnr_branch');
                                             if ($projectSelected!=null) {
                                                $branches = $branches->where('projectId',$projectSelected);
                                             }
                                             if ($projectTypeSelected!=null) {
                                                $branches = $branches->where('projectTypeId',$projectTypeSelected);
                                             }
                                                $branches = $branches->orWhere('id',1)->select('id','name','branchCode')->get();
                                            @endphp

                                            <div class="col-sm-12">
                                                <select name="searchBranch" class="form-control input-sm" id="searchBranch">
                                                    <option value="">All</option>
                                                    <option value="0" @if($branchSelected===0){{"selected=selected"}}@endif>All Branches</option>
                                                    @foreach($branches as $branch)
                                                    <option value="{{$branch->id}}" @if($branch->id==$branchSelected){{"selected=selected"}}@endif>{{str_pad($branch->branchCode,3,"0",STR_PAD_LEFT).'-'.$branch->name}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>
                                    </div>
                                    @endif


                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                             <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Category:', ['class' => 'control-label pull-left']) !!}
                                            </div> 

                                            @php
                                                $categories = DB::table('fams_product_category')->select('id','name','categoryCode')->get();
                                            @endphp

                                            <div class="col-sm-12">
                                                <select name="searchCategory" class="form-control input-sm" id="searchCategory">
                                                    <option value="">All</option>
                                                    @foreach($categories as $category)
                                                    <option value="{{$category->id}}" @if($category->id==$categorySelected){{"selected=selected"}}@endif>{{str_pad($category->categoryCode,3,'0',STR_PAD_LEFT).'-'.$category->name}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>
                                    </div>

                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                             <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Pro. Type:', ['class' => 'control-label pull-left']) !!}
                                            </div> 

                                             @php
                                             $productTypes = DB::table('fams_product_type');
                                             if ($categorySelected!=null) {
                                                 $productTypes = $productTypes->where('productCategoryId',$categorySelected);
                                             }
                                                $productTypes = $productTypes->select('id','name','productTypeCode')->get();
                                            @endphp

                                            <div class="col-sm-12">
                                                <select name="searchProductType" class="form-control input-sm" id="searchProductType">
                                                    <option value="">All</option>
                                                    @foreach($productTypes as $productType)
                                                    <option value="{{$productType->id}}" @if($productType->id==$productTypeSelected){{"selected=selected"}}@endif>{{str_pad($productType->productTypeCode,3,'0',STR_PAD_LEFT).'-'.$productType->name}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>
                                    </div>

                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Search By:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                {!! Form::select('searchMethod',[''=>'Please Select','1'=>'Fiscal Year','2'=>'Current Year','3'=>'Date Range'],$searchMethodSelected,['id'=>'searchMethod','class'=>'form-control input-sm']) !!}

                                            </div>
                                        </div>
                                    </div>
                                    

                                     @php
                                        $fiscalYears = DB::table('gnr_fiscal_year')->pluck('name','id')->toArray();
                                    @endphp

                                    <div class="col-md-1" style="display: none;" id="fiscalYearDiv">
                                        <div class="form-group" style="font-size: 13px; color:black">
                                            {!! Form::label('', ' ', ['class' => 'control-label col-sm-12']) !!}
                                            <div class="col-sm-12" style="padding-top: 18px;">

                                                {!! Form::select('fiscalYear', $fiscalYears, $fiscalYearSelected, array('class'=>'form-control input-sm', 'id' => 'fiscalYear')) !!}

                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-2" style="display: none;" id="dateRangeDiv">
                                        <div class="form-group" style="font-size: 13px; color:black">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', ' ', ['class' => 'control-label']) !!}
                                            </div>

                                            <div class="col-sm-12" style="padding-top: 7px;">
                                                <div class="form-group">
                                                    <div class="col-sm-6">
                                                        {!! Form::text('dateFrom',$dateFromSelected,['id'=>'dateFrom','placeholder'=>'From','class'=>'form-control input-sm','readonly','style'=>'cursor:pointer']) !!}
                                                        <p id="dateFrome" style="color: red;display: none;">*Required</p>
                                                    </div>
                                                    <div class="col-sm-6" id="dateToDiv">
                                                        {!! Form::text('dateTo',$dateToSelected,['id'=>'dateTo','placeholder'=>'To','class'=>'form-control input-sm','readonly','style'=>'cursor:pointer']) !!}
                                                        <p id="dateToe" style="color: red;display: none;">*Required</p>
                                                    </div>
                                                </div>

                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black">

                                            <div class="col-sm-12" style="padding-top: 25px;">

                                                {!! Form::submit('Search',['id'=>'search','class'=>'btn btn-primary btn-xs','style'=>'font-size:15px;']) !!}
                                            </div>
                                        </div>
                                        {!! Form::close() !!}
                                    </div>                                   

                                </div>                           
                            
                        </div>{{-- End Filtering Group --}}


                        <h2 align="center" style="font-family: Antiqua;letter-spacing: 2px; color: white; margin-top: 0px;">Register Use Report</h2>
                    </div>
                    <div class="panel-body panelBodyView">
                        <div>
                           
                        </div>
                       @php
                       if($branchSelected===0){
                        $selectedBranchName = "All Branches";
                       }
                       else{
                        $selectedBranchName = DB::table('gnr_branch')->where('id',$branchSelected)->value('name');
                       }
                            
                            $selectedProjectName = DB::table('gnr_project')->where('id',$projectSelected)->value('name');
                            $selectedProjectTypeName = DB::table('gnr_project_type')->where('id',$projectTypeSelected)->value('name');
                            $selectedCategoryName = DB::table('fams_product_category')->where('id',$categorySelected)->value('name');

                        @endphp
                        @if($firstRequest!=0)
                                <div id="printingContent">

                                   <div style="display: none;text-align: center;" id="hiddenTitle">
                           <h3 style="text-align: center;padding: 0px;margin: 0px;">Ambala Foundation</h3>
                           <p style="text-align: center;padding: 0px;margin: 0px;font-size: 10px;">House # 62, Block # Ka, Piciculture Housing Society, Shyamoli, Dhaka-1207</p>
                           <h4 style="text-align: center;padding: 0px;margin: 0px;">Fixed Assets Register</h4>                          
                            {{-- <h5 style="text-align: center;">{{$selectedBranchName}}</h5>  --}}
                           <h5 style="text-align: center;font-size: 14;padding: 0px;margin: 0px;">{{date('F d, Y',strtotime($endDate))}}</h5>
                        </div> 

                                         <div id="hiddenInfo" style="display: none;">                       

                       <p style="padding: 0px;margin: 0px;font-size: 11px;">Branch Name : @php
                            if($selectedBranchName==null){
                                echo "All";
                            }
                            else{
                                echo $selectedBranchName;
                            }
                        @endphp                               
                         <span style='float: right;'>
                             Reporting Peroid : {{date('d-m-Y',strtotime($startDate))." to ".date('d-m-Y',strtotime($endDate))}}
                         </span>      
                        </p>                           
                       
                                                           
                                    <p style="padding: 0px;margin: 0px;font-size: 11px;">Project Name : @php
                                        if($selectedProjectName==null){
                                            echo "All";
                                        }
                                        else{
                                            echo $selectedProjectName;
                                        }
                                    @endphp                               
                                <span style='float: right;'>
                                    Assets Category :  @php
                                        if($selectedCategoryName==null){
                                            echo "All";
                                        }
                                        else{
                                            echo $selectedCategoryName;
                                        }
                                    @endphp
                                </span>                                
                                    </p>                                
                            

                                                          
                                    <p style="padding: 0px;margin: 0px;font-size: 11px;">Project Type :  @php
                                        if($selectedProjectTypeName==null){
                                            echo "All";
                                        }
                                        else{
                                            echo $selectedProjectTypeName;
                                        }
                                    @endphp                               
                                <span style='float: right;'>
                                    Print Date : {{date('F d,Y')}}
                                </span>  
                                
                                    </p>                                
                            
                        </div>
                        <br>

                                    <div id="tableDiv">
                                    <table id="famsAssetRegisterReportTable" class="table table-striped table-bordered" style="color:black;font-size:11px;margin-bottom:50px;border-collapse: collapse;" border= "1px solid ash;" cellpadding="0" cellspacing="0">
                                    
                                        <thead>
                                        <tr>
                                            <th rowspan="2" >SL#</th>
                                            <th rowspan="2" >Purchase Date</th>
                                            <th rowspan="2" >Product Name</th>
                                            <th rowspan="2" >Product ID Number</th>
                                            <th rowspan="2" >User Name / Use Room-Department</th>
                                            <th colspan="3" style="border-bottom: 0pt solid white;">Cost Value (Tk)</th>
                                            
                                        </tr>
                                        
                                        <tr>
                                            <th>Cost Price</th>
                                            <th>Accumulated Dep.</th>
                                            <th>Written Down Value</th>
                                            
                                        </tr>
                                        </thead>
                                        
                                        <tbody>

                                        @php
                                            $totalCostPrice = 0;
                                            $totalDep = 0;
                                            $totalWrittenDown = 0;
                                        @endphp
                                        @foreach($useProducts as $index => $useProduct)

                                        @php
                                            $product = DB::table('fams_product')->where('id',$useProduct->productId)->select('name','productCode','purchaseDate','totalCost','depreciationOpeningBalance')->first();
                                            $employeeId = (int) DB::table('fams_tra_use')->where('id',$useProduct->useId)->value('employeeId');

                                            $depAmount = DB::table('fams_depreciation_details')->where('productId',$useProduct->productId)->where('depTo','>=',$startDate)->where('depTo','<=',$endDate)->sum('amount');
                                        @endphp
                                            <tr>
                                                <td>{{$index+1}}</td>
                                                <td>{{date('d-m-Y',strtotime($product->purchaseDate))}}</td>
                                                <td class="name">{{$product->name}}</td>
                                                <td>{{$product->productCode}}</td>
                                                <td class="name">
                                                @php
                                                    if ($employeeId>0) {
                                                        $employee = DB::table('hr_emp_general_info')->where('id',$employeeId)->select('emp_id','emp_name_english')->first();
                                                        echo $employee->emp_id.'-'.$employee->emp_name_english;
                                                    }
                                                    else{
                                                        $roomId = (int) DB::table('fams_tra_use')->where('id',$useProduct->useId)->value('roomId');
                                                        $departmentRoom = DB::table('gnr_room')->where('id',$roomId)->value('name');

                                                        echo $departmentRoom.str_repeat('&nbsp;', (4*2));

                                                        $room = DB::table('gnr_room')->where('id',$roomId)->first();
                                                        $splitArray=str_replace(array('[', ']', '"', ''), '',  $room->departmentId); 
                                                        $targetArray = explode(",",$splitArray);
                                                        $arraySize = sizeof($targetArray);
                                                        $j = 0;
                                                        //var_dump($targetArray);
                                                      foreach($targetArray as $departmentId){
                                                        echo App\Models\gnr\GnrDepartment::where('id',$departmentId)->value('name');
                                                         $j++; 
                                                          if($j<$arraySize){
                                                            echo '&nbsp/&nbsp';
                                                          }
                                                      }
                                                    }
                                                @endphp
                                                
                                                </td>
                                                <td class="amount">{{number_format($product->totalCost,2,'.',',')}}</td>
                                                <td class="amount">{{number_format($product->depreciationOpeningBalance+$depAmount,2,'.',',')}}</td>
                                                <td class="amount">{{number_format($product->totalCost-($product->depreciationOpeningBalance+$depAmount),2,'.',',')}}</td>
                                            </tr>

                                            @php
                                                $totalCostPrice = $totalCostPrice + $product->totalCost;
                                                $totalDep = $totalDep + $product->depreciationOpeningBalance+$depAmount;
                                                $totalWrittenDown = $totalWrittenDown + $product->totalCost-($product->depreciationOpeningBalance+$depAmount);
                                            @endphp
                                            @endforeach
                                        </tbody>
                                        <tfoot>
                                            <tr>
                                                <td colspan="5" class="title">Total</td>
                                                <td class="amount">{{number_format($totalCostPrice,2,'.',',')}}</td>
                                                <td class="amount">{{number_format($totalDep,2,'.',',')}}</td>
                                                <td class="amount">{{number_format($totalWrittenDown,2,'.',',')}}</td>
                                                
                                            </tr>
                                        </tfoot>
                                       

                                    </table>
                                    
                                    </div>
                                    </div>
                                @endif
                           
                    </div>
                </div>
            </div>
        </div>
    </div>
        </div>


<script type="text/javascript">
  $(document).ready(function() {

    function toDate(dateStr) {
    var parts = dateStr.split("-");
    return new Date(parts[2], parts[1] - 1, parts[0]);
}

    /* Date Range From */
    $("#dateFrom").datepicker({
            changeMonth: true,
            changeYear: true,
            yearRange : "1998:c",
            maxDate: "dateToday",
            dateFormat: 'dd-mm-yy',
            onSelect: function () {
                $('#dateFrome').hide();          
                $("#dateTo").datepicker("option","minDate",new Date(toDate($(this).val())));
                $( "#dateTo" ).datepicker( "option", "disabled", false );      
            }
        });
    /* Date Range From */

   

    /* Date Range To */
    $("#dateTo").datepicker({
            changeMonth: true,
            changeYear: true,
            yearRange : "1998:c",
            maxDate: "dateToday",
            dateFormat: 'dd-mm-yy',
            onSelect: function () {
                $('#dateToe').hide();           
            }
        });
//$( "#dateTo" ).datepicker( "option", "disabled", true );
    /* End Date Range To */

    var dateFromData = $("#dateFrom").val();

     if (dateFromData!="") {
        $("#dateTo").datepicker("option","minDate",new Date(toDate(dateFromData)));
        //$("#dateTo").datepicker( "option", "disabled", false );  
    }  
    
  });/*End Doc Ready*/
</script>

  {{-- Filtering Mehod --}}
  <script type="text/javascript">
      $(document).ready(function() {

          $("#searchMethod").change(function(event) {
            
              var searchMethod = $(this).val();
              if (searchMethod=="") {
                $("#fiscalYearDiv").hide();
                $("#dateRangeDiv").hide();
              }
              //Fiscal Year
              else if(searchMethod==1){
                $("#fiscalYearDiv").show();
                $("#dateRangeDiv").hide();
              }

              //Current Year
              else if(searchMethod==2){
                $("#fiscalYearDiv").hide();
                $("#dateRangeDiv").show();
                var d = new Date();
                var year = d.getFullYear();
                var month = d.getMonth();
                if (month<=5) {
                    year--;
                    month = 6;
                }
                else{
                    month = 6;
                }
                d.setFullYear(year, month, 1); 
                             
                $("#dateFrom").datepicker("option","minDate",new Date(d));
                $("#dateFrom").datepicker("setDate", new Date(d));
                $("#dateFrom").hide();
                $("#dateFrome").hide();

                $("#dateToDiv").attr("class", "col-sm-12");
                $("#dateTo").datepicker("option","minDate",new Date(d));
              }

              //Date Range
              else if(searchMethod==3){
                $("#fiscalYearDiv").hide();
                $("#dateRangeDiv").show();

                $("#dateToDiv").attr("class", "col-sm-6");
                $("#dateFrom").show();
                //$("#dateFrom").val("");
                $("#dateFrom").datepicker("option","minDate",new Date(Date.parse("1998-01-01")));
              }
          });
          $("#searchMethod").trigger('change');
      });
  </script>
  {{-- End Filtering Mehod --}}

<script type="text/javascript">
    $(document).ready(function() {
        //$('body').width( "3000" );
    });
</script>

{{-- Print Page --}}
<script type="text/javascript">
    jQuery(document).ready(function($) {
        $("#print").click(function(event) {

            $("#hiddenTitle").show();
            $("#hiddenInfo").show();
            $("#famsAssetRegisterReportTable").removeClass('table table-striped table-bordered');

        var mainContents = document.getElementById("printingContent").innerHTML;
  var headerContents = '';

  var footerContents = "<div class='row' style='font-size:12px;'>Prepared By <span style='display:inline-block; width: 40%;'></span> Checked By <span style='display:inline-block; width: 40%;'></span> Approved By</div>";

        var printStyle = '<style>#famsAssetRegisterReportTable{float:left;height:auto;padding:0px;width:100%;font-size:11px;border:1pt ash;page-break-inside:auto;} thead tr th{text-align:center;vertical-align: middle;padding:3px;font-size:10px}  tbody tr td {border: 1px solid ash;text-align:left;vertical-align: middle;padding:3px;font-size:10px} tr{ page-break-inside:avoid; page-break-after:auto } .name{text-align:left;vertical-align:left;}.amount{text-align:right;padding-right:5px;} tfoot tr td{text-align:center;font-weight:bold;}</style><style media="print">@page{size:portrait;margin:10mm 10mm;}</style><style>@media print {.element-that-contains-table { overflow: visible !important; }}</style>';

        printContents = '<div id="order-details-wrapper">' + printStyle + mainContents + footerContents+'</div>';

        /*tr:nth-of-type(10n){page-break-after: always;}*/
       // @media print {.element-that-contains-table { overflow: visible !important; }}


  /*document.body.innerHTML = printStyle + printContents;
  window.print();*/

  var win = window.open('','printwindow');
win.document.write(printContents);
win.print();
win.close();
});
    });
</script>
{{-- EndPrint Page --}}


{{-- Filtering --}}
<script type="text/javascript">
    jQuery(document).ready(function($) {

        function pad (str, max) {
              str = str.toString();
              return str.length < max ? pad("0" + str, max) : str;
            }

         /* Change Project*/
         $("#searchProject").change(function(){
            
            var projectId = $(this).val();

            var csrf = "<br />
<b>Fatal error</b>:  Uncaught Error: Call to undefined function csrf_token() in /home/shikkhaplus/public_html/morning_bird_bk/resources/views/fams/reports/view_register_use_report.blade.php:600
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/fams/reports/view_register_use_report.blade.php</b> on line <b>600</b><br />