@extends('layouts/acc_layout')
@section('title', '| Loan Register Report')
@section('content')


@php
    use Carbon\Carbon;
    $projectSelected = isset($_GET['searchProject']) ? $_GET['searchProject'] : null;
    $projectTypeSelected = isset($_GET['searchProjectType']) ? $_GET['searchProjectType'] : null;
    $branchSelected = isset($_GET['searchBranch']) ? $_GET['searchBranch'] : null;
    //$fdrTypeSelected = isset($_GET['searchFdrType']) ? $_GET['searchFdrType'] : null;
    $bankSelected = isset($_GET['searchBank']) ? $_GET['searchBank'] : null;
    $bankBranchSelected = isset($_GET['searchBankBranch']) ? $_GET['searchBankBranch'] : null;
    $dateFromSelected = isset($_GET['dateFrom']) ? $_GET['dateFrom'] : $softwareStartDate;
    $dateToSelected = isset($_GET['dateTo']) ? $_GET['dateTo'] : $softwareDate;
    $firstRequest = isset($_GET['firstRequest']) ? '1' : null;

    /*var_dump($bankBranchSelected);
    exit();*/
    $userBranchId = Auth::user()->branchId;
 
    use App\Service\UserUtility; 
    $hasAccessToViewAllProjects = UserUtility::hasAccessToViewAllProjects();
@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">
          <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>
          <h3  style=" text-align: center; font-family: Antiqua; letter-spacing: 2px; color: white;">Loan Register Report</h3>
        </div>
        {{-- <h5>kxghixd</h5> --}}

        <div class="panel-body panelBodyView">


            <!-- Filtering Start-->
           <div class="row" id="filtering-group">

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

                    {!! Form::open(['url' => 'viewLoanRegisterReport','method' => 'get']) !!}


                    {!! Form::hidden('firstRequest',0) !!}


                    <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>

                            <div class="col-sm-12">
                                <select name="searchProject" class="form-control input-sm" id="searchProject">
                                    @if($hasAccessToViewAllProjects==1) <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>

                    <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 Type:', ['class' => 'control-label pull-left']) !!}
                            </div>

                            <div class="col-sm-12">
                                <select name="searchProjectType" class="form-control input-sm" id="searchProjectType">
                                    @if($userBranchId==1) <option value="">All</option>   @endif
                                    @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>


                    {{--<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('searchBranch', 'Branch:', ['class' => 'control-label pull-left']) !!}
                            </div>

                            <div class="col-sm-12">
                                <select name="searchBranch" class="form-control input-sm" id="searchBranch">
                                        @if($userBranchId==1)
                                        <option value="">All</option>
                                        <option value="0" @if($branchSelected=='0'){{"selected=selected"}}@endif>All Branches</option>
                                        @endif
                                    @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>--}}


                    {{--<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('searchLoanType', 'LoanType Type:', ['class' => 'control-label pull-left']) !!}
                            </div>

                            <div class="col-sm-12">
                            @php
                                $loanTypes = array(''=>'All') + $fdrTypes;
                            @endphp
                                {!! Form::select('searchFdrType',$fdrTypes,$fdrTypeSelected,['id'=>'searchFdrType','class'=>'form-control input-sm']) !!}

                            </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('searchBank', 'Bank Name:', ['class' => 'control-label pull-left']) !!}
                            </div>

                            @php
                                $banks = array(''=>'All') + $banks;
                            @endphp

                            <div class="col-sm-12">
                                {!! Form::select('searchBank',$banks,$bankSelected,['id'=>'searchBank','class'=>'form-control input-sm']) !!}

                            </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('searchBankBranch', 'B.Branch:', ['class' => 'control-label pull-left']) !!}
                            </div>
                                @php
                                //$bankBranches = array(''=>'All') + $bankBranches;
                            @endphp

                            <div class="col-sm-12">
                                <select class="form-control input-sm" name="searchBankBranch" id="searchBankBranch">
                                    <option value="">All</option>
                                    @foreach($bankBranches as $bankBranch)
                                        @php
                                        $bankShortName = DB::table('gnr_bank')->where('id',$bankBranch->bankId_fk)->value('shortName');
                                        @endphp
                                    <option value="{{$bankBranch->id}}" @if($bankBranch->id==$bankBranchSelected){{"selected=selected"}}@endif >{{$bankBranch->name.'-'.$bankShortName}}</option>
                                    @endforeach
                                </select>
                                {{--  {!! Form::select('searchBankBranch',$bankBranches,$bankBranchSelected,['id'=>'searchBankBranch','class'=>'form-control input-sm']) !!} --}}

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




                    <div class="col-md-2" 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 --}}
            <!-- filtering end-->



            @if($firstRequest!=null)

            @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'); -->
                $selectedProjectName = UserUtility::getUserAccessibleProjects()->where('id',$projectSelected)->value('name');



            @endphp

            <div id="printingContent">

            <div style="display: none;text-align: center;" id="hiddenTitle">
                            <br />
<b>Fatal error</b>:  Uncaught Error: Class &quot;DB&quot; not found in /home/shikkhaplus/public_html/guk_bk/resources/views/accounting/registerReport/loanRegister/loanRegisterReport.blade.php:233
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/accounting/registerReport/loanRegister/loanRegisterReport.blade.php</b> on line <b>233</b><br />