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


@php    
    $projectSelected = isset($_GET['searchProject']) ? $_GET['searchProject'] : null;
    $projectTypeSelected = isset($_GET['searchProjectType']) ? $_GET['searchProjectType'] : null;
    $donorTypeSelected = isset($_GET['searchDonorType']) ? $_GET['searchDonorType'] : null;
    $datefrom = isset($_GET['formDate']) ? $_GET['formDate'] : null;
    $dateto = isset($_GET['toDate']) ? $_GET['toDate'] : null;
    $firstRequest = isset($_GET['firstRequest']) ? '1' : '0';     

    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 Installment 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' => 'loanRegisterInstallmentReport','method' => 'get']) !!}
                        
                        {!! Form::hidden('firstRequest',1) !!}

                        <div class="col-md-2">
                            <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
                                    $acticeProjectforSearch = DB::table('acc_loan_register_account')->pluck('projectId_fk')->toArray();
                                    // <!-- $searchProjects = DB::table('gnr_project')->whereIn('id',$acticeProjectforSearch)->select('id','name','projectCode')->get(); -->
                                    $searchProjects = UserUtility::getUserAccessibleProjects()->whereIn('id',$acticeProjectforSearch)->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($searchProjects as $searchProject)
                                            <option value="{{$searchProject->id}}" @if($searchProject->id==$projectSelected){{"selected=selected"}}@endif>{{str_pad($searchProject->projectCode,3,"0",STR_PAD_LEFT).'-'.$searchProject->name}}</option>
                                        @endforeach
                                    </select>

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

                        <div class="col-md-2">
                            <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> 

                                @php
                                    $acticeProjectTypesforSearch = DB::table('acc_loan_register_account')->distinct()->pluck('projectTypeId_fk')->toArray();
                                    $searchProjectTypes = DB::table('gnr_project_type')->whereIn('id',$acticeProjectTypesforSearch);
                                    if($projectSelected!=null){
                                        $searchProjectTypes = $searchProjectTypes->where('projectId',$projectSelected);
                                    }
                                    $searchProjectTypes = $searchProjectTypes->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($searchProjectTypes as $searchProjectType)
                                            <option value="{{$searchProjectType->id}}" @if($searchProjectType->id==$projectTypeSelected){{"selected=selected"}}@endif>{{str_pad($searchProjectType->projectTypeCode,3,"0",STR_PAD_LEFT).'-'.$searchProjectType->name}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </div>
                        
                        <div class="col-md-2">
                            <div class="form-group" style="font-size: 13px; color:black;">
                                <div style="text-align: center;" class="col-sm-12">
                                    {!! Form::label('', 'Donor Type:', ['class' => 'control-label pull-left']) !!}
                                </div>

                                <div class="col-sm-12">
                                    {!! Form::select('searchDonorType',[''=>'All','0'=>'Bank','1'=>'Donor'],$donorTypeSelected,['class'=>'form-control']) !!}
                                </div>
                            </div>
                        </div>

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

                                <div class="col-sm-12">
                                    <div class="form-group">
                                        <div class="col-sm-12">
                                            {!! Form::text('formDate',null,['id'=>'from','placeholder'=>'From','class'=>'form-control input-sm searchDateReplica','readonly','style'=>'cursor:pointer']) !!}
                                            {!! Form::hidden('searchDate',null,['id'=>'searchDate']) !!}
                                            <p id="searchDatee" style="color: red;display: none;">*Required</p>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

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

                                <div class="col-sm-12">
                                    <div class="form-group">
                                        <div class="col-sm-12">
                                            {!! Form::text('toDate',null,['id'=>'to','placeholder'=>'To','class'=>'form-control input-sm searchDateReplica','readonly','style'=>'cursor:pointer']) !!}
                                            {!! Form::hidden('searchDate',null,['id'=>'searchDate']) !!}
                                            <p id="searchDatee" 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)

                    <div id="printingContent">
                        <div class="row" style="padding-bottom: 10px; text-align: center; vertical-align: middle; color: black; font-weight: bold; "> {{-- div for Company --}}
                        <br />
<b>Fatal error</b>:  Uncaught Error: Class &quot;DB&quot; not found in /home/shikkhaplus/public_html/demo_bk/resources/views/accounting/registerReport/loanRegister/installmentReport.blade.php:157
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/accounting/registerReport/loanRegister/installmentReport.blade.php</b> on line <b>157</b><br />