@extends('layout.app')
@section('title')
    Call Over Transaction Report
@endsection
@section('pagetitle')
Call Over Transaction Report
@endsection
@section('content')
  <div class="container">
    <div class="row" id="advanced-input">
              <div class="col-md-12">
                <div class="panel widget">
                  <div class="panel-heading">
                  </div>
                  <div class="panel-body">
                    <div class="row">
                    <div class="col-md-10 col-lg-10 col-sm-12">
                      @if (!empty($_GET['filter']) && $_GET['filter'] == true)
                      <h3>Callover Report For Period: {{date("d M, Y",strtotime($_GET['datefrom']))." To ".date("d M, Y",strtotime($_GET['dateto']))}}</h3>
                      @endif
                    </div>
                    </div>
                    <div class="noprint" style="margin-bottom: 15px">
                      <form action="{{route('report.callover')}}" method="get" onsubmit="thisForm()">
                        <input type="hidden" name="filter" value="true">
                        <input type="hidden" name="callovertype" value="{{!empty($_GET['callovertype']) ? $_GET['callovertype'] : ''}}">
                        <table class="table table-bordered table-hover table-sm">
                          <thead>
                            <tr>
                              <th>From Date</th>
                              <th>To Date</th>
                              <th></th>
                            </tr>
                          </thead>
                          <tbody>
                            <tr>
                              <td>
                                <div class="form-group">
                                  <input type="date" name="datefrom" required id="" class="form-control" value="{{!empty($_GET['datefrom']) ? $_GET['datefrom'] : ''}}">
                                </div>
                              </td>
                              <td>
                                <div class="form-group">
                                  <input type="date" name="dateto" required id="" class="form-control" value="{{!empty($_GET['dateto']) ? $_GET['dateto'] : ''}}">
                                </div>
                              </td>
                              <td>
                                <div class="form-group">
                                  @if (!empty($_GET['callovertype']) && $_GET['callovertype'] == '2')
                                  <select name="status" id="sts" required class="form-control">
                                    <option>Select Approval Status</option>
                                    <option value="all" {{!empty($_GET['status']) && $_GET['status'] == "all"  ? "selected" : ""}}>All</option>
                                    <option value="approved" {{!empty($_GET['status']) && $_GET['status'] == "approved" ? "selected"  : ""}}>Approved</option>
                                    <option value="pending" {{!empty($_GET['status']) && $_GET['status'] == "pending" ? "selected"  : ""}}>Pending</option>
                                    <option value="declined" {{!empty($_GET['status']) && $_GET['status'] == "declined" ? "selected"  : ""}}>Decline</option>
                                  </select>
                                  </div>
                                      <div class="form-group">
                                          <div class="vd_checkbox checkbox-success">
                                          <input type="checkbox" value="1" name="gl" id="checkboxs" {{!empty($_GET['gl']) && $_GET['gl'] == "1" ? "checked" : ""}} autocomplete="off">
                                          <label for="checkboxs">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;General Ledger only</label>
                                        </div>
                                      </div>
                                  @endif
                                  
                                      @if (!empty($_GET['callovertype']) && $_GET['callovertype'] == '1')
                                    <div class="form-group">
                                      <select name="type" id="type" required class="form-control">
                                        <option>Select Call-Over Status</option>
                                        <option value="all" {{ !empty($_GET['type']) && $_GET['type'] == "all" ? "selected" : ""}}>All</option>
                                        <option value="deposit" {{!empty($_GET['type']) && $_GET['type'] == "deposit" ? "selected" : ""}}>Deposit/Credit</option>
                                        <!--<option value="fixed_deposit">Fixed Deposit</option>-->
                                        <!--<option value="investment">Investment</option>-->
                                        <!--<option value="inv_int">Investment Interest</option>-->
                                        <option value="rev_deposit" {{!empty($_GET['type']) && $_GET['type']  == "rev_deposit" ? "selected" : ""}}>Deposit Reversal</option>
                                        <option value="bank_fees" {{!empty($_GET['type']) && $_GET['type'] == "bank_fees" ? "selected" : ""}}>Bank Fees</option>
                                        <option value="esusu" {{!empty($_GET['type']) && $_GET['type'] == "esusu"  ? "selected" : ""}}>Esusu Charge</option>
                                        <option value="monthly_charge" {{!empty($_GET['type']) && $_GET['type'] == "monthly_charge" ? "selected" : ""}}>Monthly Charge</option>
                                        <option value="loan" {{!empty($_GET['type']) && $_GET['type'] == "loan" ? "selected" : ""}}>Loan Disburse</option>
                                        <option value="process_fee" {{!empty($_GET['type']) && $_GET['type'] == "process_fee" ? "selected" : ""}}>Management Fee</option>
                                        <option value="form_fees" {{!empty($_GET['type']) && $_GET['type'] == "form_fees" ? "selected" : ""}}>Loan Form</option>
                                        <option value="repayment" {{!empty($_GET['type']) && $_GET['type'] == "repayment" ? "selected" : ""}}>Loan Repayment</option>
                                        <option value="dividend" {{!empty($_GET['type']) && $_GET['type'] == "dividend" ? "selected" : ""}}>Dividend</option>
                                        <option value="interest" {{!empty($_GET['type']) && $_GET['type'] == "interest" ? "selected" : ""}}>Interest</option>
                                        <option value="fd_interest" {{!empty($_GET['type']) && $_GET['type'] == "fd_interest" ? "selected" : ""}}>Fixed Deposit Interest</option>
                                        <option value="withdrawal" {{!empty($_GET['type']) && $_GET['type'] == "withdrawal" ? "selected" : ""}}>Withdrawal/Debit</option>
                                        <option value="rev_withdrawal" {{!empty($_GET['type']) && $_GET['type'] == "rev_withdrawal" ? "selected" : ""}}>Reversal Withdrawal</option>
                                        <option value="guarantee" {{!empty($_GET['type']) && $_GET['type'] == "guarantee" ? "selected" : ""}}>Guarantee</option>
                                        <option value="guarantee_restored" {{!empty($_GET['type']) && $_GET['type'] == "guarantee_restored" ? "selected" : ""}}>Guarantee Restored</option>
                                        <option value="transfer_charge" {{!empty($_GET['type']) && $_GET['type'] == "transfer_charge" ? "selected" : ""}}>Transfer Charge</option>
                                      </select>
                                       </div>
                                  @endif
                               
                              </td>
                              <td>
                                <button type="submit" class="btn btn-success btn-sm" onclick="if(document.getElementById('type').value=""){return alert('please select status type');}elseif(document.getElementById('sts').value=""){return alert('please select status type');}" id="btnsetsubmit">Search Records</button>
                                <button type="button" class="btn btn-danger btn-sm" onclick="window.location.href='{{route('report.callover')}}?callovertype={{$_GET['callovertype']}}'">Reset</button>
                              </td>
                            </tr>
                          </tbody>
                        </table>
                      </form>
                    </div>
                    @if (!empty($_GET['filter']) && $_GET['filter'] == true)
                    <div class="table-responsive">
                      <table id="callover" class="table table-bordered table-striped table-condensed table-hover">
                          <thead>
                          <tr style="background-color: #D1F9FF">
                                  <th>Sn</th>
                                  <th>Account Name</th>
                                  <th>Account No</th>
                                  <th>Reference</th>
                                   <th>Slip No</th>
                                   <th>Posted by</th>
                                   @if(empty($_GET['gl']))
                                   <th>Approved by</th>
                                   @endif
                                   <th>Transaction</th>
                                  <th>Debit</th>
                                  <th>Credit</th>
                                  <th>Posting Date</th>
                                  <th>Tranx Date</th>
                                  {{-- <th>Action</th> --}}
                              </tr>
                          </thead>
                          <tbody>
                                                         @foreach($data as $key)