@extends('layouts.default', ['appTopMenu' => true])

@section('title', 'Account Book')

@section('content')


<div class="panel">

  <div class="panel-heading card-bg-color">
    <h4 class="panel-title"><i class="fa-solid fa-magnifying-glass"></i> Account Book</h4>

  </div>

  <div class="panel-body">
    <div class="row">
      <div class="col-md-2"></div>
      <div class="col-md-2"></div>
      <div class="col-md-2"></div>
      <div class="col-md-2"></div>
    </div>

    <form action="{{route('hccopying.application.accountbook')}}" method="GET" id="form_year" class="mb-3">

      <div class="row d-flex justify-content-center">
        <div class="col-md-3">
          <div class="form-group row">
            <label class="form-label col-form-label col-lg-4">Mode</label>
            <div class="col-lg-7">
              <select class="form-control" name="Mode">

                <option value="">ALL</option>
                <option value="2">OFFLINE</option>
                <option value="1">ONLINE</option>
              </select>
            </div>
          </div>
        </div>
        <div class="col-md-3">
          <div class="form-group row">
            <label class="form-label col-form-label col-lg-4">Date From</label>
            <div class="col-lg-7">
              <div class="input-group date" data-date-format="dd-mm-yyyy">
                <input type="text" class="form-control" name="date_from" placeholder="Select Date" value="{{ request('date_from') }}" id="date_from" readonly="readonly">
                <span class="input-group-text input-group-addon"><i class="fa fa-calendar"></i></span>
              </div>
            </div>
          </div>
        </div>
        <div class="col-md-3">
          <div class="form-group row">
            <label class="form-label col-form-label col-lg-4">Date To</label>
            <div class="col-lg-7">
              <div class="input-group date" data-date-format="dd-mm-yyyy">
                <input type="text" class="form-control" name="date_to" placeholder="Select Date" id="date_to" value="{{ request('date_to') }}" readonly="readonly">
                <span class="input-group-text input-group-addon"><i class="fa fa-calendar"></i></span>
              </div>
            </div>
          </div>
        </div>


        <div class="col-md-2 align-items-center">
          <label for="exampleInputPassword1" class="form-label"></label>
          <button class="btn btn-primary button-loader" data-loading-text="<i class='fa-solid fa-circle-notch fa-spin'></i> Searching..." type="submit">Search</button>
        </div>
      </div>
    </form>

    <div class="pagination-container">
      <div class="container">

        @if(isset($applications))
        <table class="table table-striped table-bordered border-dark border-2">
          <thead>
            <tr bgcolor='#A5B2FE' align='center'>
              <td colspan=9><b> In the Court of ...................................................................</b></td>
            </tr>
            <tr bgcolor='#A5B2FE' align='center'>
              <td colspan=9><b> DETAILED ACCOUNT BOOK TO BE KEPT BY THE HEAD COPYIST<br>(For Judicial and Executive Department) </b></td>
            </tr>

            <tr bgcolor='#A5B2FE'>
              <td rowspan='3' align='center'><b>S.N.</b></td>
              <td rowspan='3' align='center'><b>Date</b></td>
              <td rowspan='3' align='center'><b>Serial No. application in Register of Application</b></td>
              <td colspan=2 align='center'><b>RECEIPT</b></td>
              <td colspan=4 align='center'><b>EXPENDITURE</b></td>
            </tr>
            <tr bgcolor='#B3E1FE' align='center'>
              <td align='justify' rowspan='2'>Advances received from parties</td>
              <td align='justify' rowspan='2'>Advances and other amount received by post</td>
              <td align='justify' rowspan='2'>Amount refunded to applicants</td>
              <td colspan='2' align='justify'>Incidental Charges e.g. Postage ad registration charges Money order commission and court fee on application for copies</td>
              <td align='justify' rowspan='2'>Amt. Paid for CF label affixed to copies</td>
            </tr>

            <tr bgcolor='#C5F9FE'>
              <td align='center'>MOC</td>
              <td align='center'>Postage &amp; registration</td>
            </tr>
            <tr align='center'>
              <th>1.</th>
              <th>2.</th>
              <th>3.</th>
              <th>4.</th>
              <th>5.</th>
              <th>6.</th>
              <th colspan=2>7.</th>
              <th>8.</th>
            </tr>

          </thead>
          <tbody>
            @php
            $sr=1;
            $final_refund_amt=0;
            $final_cf_amt=0;
            $final_fur_amt=0;
            $final_rec_amt=0;

            @endphp
            @foreach($applications as $application)


            @php
            $further_amt_post=0;
            $moc_amount=0;
            $reg_post_amt=0;
            $refund_amt=0;
            $cf=0;
            $moc=0; $rec_amt=0;$post_amt=0;$fur_amt=0;$fur_amt_post=0;
            $tot_charge=0;

            $page=$application->page;

            @endphp

            @php
            $dt=$application->ent_dt;
            $rec_amt=$application->rec_amt;
            @endphp



            @if($application->post_amt!=0)
            @php
            $post_amt=$application->post_amt;
            @endphp
            @else
            @php
            $post_amt=0;
            @endphp
            @endif

            @php
            $page=$application->page;
            $tot_rec=$rec_amt;
            @endphp

            @if($tot_rec!=0)
            @php
            $tot_rec_amt=$tot_rec;
            @endphp
            @else
            @php
            $tot_rec_amt=0;
            @endphp
            @endif


            @if( strtotime($application->fur_amt_dt)==strtotime($application->rec_dt))

            @if($application->fur_amt!='0')
            @php
            $further_amt=$application->fur_amt;
            @endphp
            @endif

            @if($application->fur_amt_post!='0')
            @php
            $further_post_amt=$application->fur_amt_post;
            @endphp
            @endif
            @else
            @php
            $further_amt=0;
            $further_post_amt=0;
            @endphp
            @endif


            

            <tr>
              <td>{{$sr++}}</td>
              <td>{{YYYYMMDDtoDateFormat($application->ent_dt)}}</td>
              <td>{{$application->app_no}}/{{$application->app_year}}</td>
              <td>


                @if( !isNullOrEmpty($application->fur_amt) && (strtotime($application->fur_amt_dt) == strtotime($application->rec_dt)))
                {{($application->rec_amt)}} + {{($application->fur_amt)}}

                @else

                {{($application->rec_amt)}}

                @endif
              </td>
              <td>

                @if( !isNullOrEmpty($application->fur_amt_post) && (strtotime($application->fur_amt_dt) == strtotime($application->rec_dt)))
                {{($application->post_amt)}} + {{($application->fur_amt_post)}}

                @else

                {{($application->rec_amt)}} + {{($application->post_amt)}}
                @endif

              </td>
              <td>{{$refund_amt}}</td>
              <td> {{$moc_amount}}</td>
              <td> {{$reg_post_amt}}</td>
              <td> {{$cf}}</td>

            </tr>
            @endforeach




            <tr class="bck4" style="line-height:14px">
              <td colspan="3">&nbsp; </td>
              <td align="right"><b class="text text-danger">TOTAL= {{$final_rec_amt+$final_fur_amt}}</></b></td>
              <td align="right"><b>
                  <font color="#0000FF"> &nbsp;</font>
                </b></td>
              <td align="right"><b class="text text-danger"> TOTAL={{$final_refund_amt}}</></b></td>
              <td align="right"><b class="text text-danger"> &nbsp;</></b></td>
              <td align="right"><b class="text text-danger"> &nbsp;</></b></td>
              <td align="right"><b class="text text-danger"> TOTAL={{$final_cf_amt}}</></b></td>
            </tr>
          </tbody>
        </table>


        @endif

        @if(isset($delivery_report))
        @php
        $sr2=1;
        @endphp

        <div align="center" id="cntnt3">
          <table class="table table-striped table-bordered border-dark border-2">
            <col width=35>
            <col width=75>
            <col width=65>
            <col width=100>
            <col width=100>
            <col width=100>
            <col width=80>
            <col width=120>
            <col width=100>';

            <tr bgcolor='#A5B2FE' align='center'>
              <td colspan=9><b> In the Court of ...................................................................</b></td>
            </tr>
            <tr bgcolor='#A5B2FE' align='center'>
              <td colspan=9><b> DETAILED ACCOUNT BOOK ".$mode." TO BE KEPT BY THE HEAD COPYIST<br>(For Judicial and Executive Department) </b>
              </td>
            </tr>


            <tr bgcolor='#A5B2FE'>
              <td rowspan='3' align='center'><b>S.N.</b></td>
              <td rowspan='3' align='center'><b>Date</b></td>
              <td rowspan='3' align='center'><b>Serial No. application in Register of Application</b></td>
              <td colspan=2 align='center'><b>RECEIPT</b></td>
              <td colspan=4 align='center'><b>EXPENDITURE</b></td>
            </tr>
            <tr bgcolor='#B3E1FE' align='center'>
              <td align='justify' rowspan='2'>Advances received from parties</td>
              <td align='justify' rowspan='2'>Advances and other amount received by post</td>
              <td align='justify' rowspan='2'>Amount refunded to applicants</td>
              <td colspan='2' align='justify'>Incidental Charges e.g. Postage ad registration charges Money order commission and court fee on application for copies</td>
              <td align='justify' rowspan='2'>Amt. Paid for CF label affixed to copies</td>
            </tr>

            <tr bgcolor='#C5F9FE'>
              <td align='center'>MOC</td>
              <td align='center'>Postage &amp; registration</td>
            </tr>

            @php
            $final_refund_amt=0;

            $final_fur_amt=0;
            $final_reg_post_amt=0;
            $final_cf_amt=0;
            @endphp

            @foreach($delivery_report as $delivery_key => $delivery_value)

            @php
            $page2=$delivery_value->page;
            $rec_amt2=$delivery_value->rec_amt;
            $moc2=$delivery_value->moc;

            $reg_post_amt2=$delivery_value->reg_amt;
            if($reg_post_amt2!=0)
            $reg_post_amt2=$reg_post_amt2;
            else
            $reg_post_amt2=0;



            @endphp





            @if($delivery_value->post_amt!=0)
            @php
            $post_amt2=$delivery_value->post_amt;
            @endphp
            @else
            @php
            $post_amt2=0;
            @endphp
            @endif



            @if($delivery_value->maxfdt==$delivery_value->actual_del_dt && $delivery_value->fur_amt_on_del != '0')

            @php
            $further_amount2=$delivery_value->fur_amt_on_del;
            @endphp
            @else
            @php
            $further_amount2=0;
            @endphp
            @endif

            @php
            $fur_amt_post2=$delivery_value->fur_amt_post_on_del;
            @endphp

            @if($delivery_value->maxfdt==$delivery_value->actual_del_dt && $delivery_value->fur_amt_post_on_del != '0')
            @php
            $fur_amount_post2=$fur_amt_post2;
            @endphp
            @else
            @php
            $fur_amount_post2=0;
            @endphp
            @endif



            @if($page2!=0)
            @php
            $tot_charge2=$page2*page_charge($page_charges,$delivery_value->app_type,$delivery_value->actual_del_dt);
            @endphp
            @else
            @php
            $tot_charge2=0;
            @endphp
            @endif


            @if($moc2!=0)
            @php
            $moc_amount2=$moc2;
            @endphp
            @else
            @php
            $moc_amount2=0;
            @endphp
            @endif


            @if($page2!=0)



            @if(($rec_amt2+$post_amt2+$delivery_value->tot_fur_amt+$delivery_value->tot_fur_amt_post) > ($tot_charge2+$moc+$reg_post_amt2) )
            @php
            $refund_amt2= ($rec_amt2+$post_amt2+$delivery_value->tot_fur_amt+$delivery_value->tot_fur_amt_post)-($tot_charge2+$moc2+$reg_post_amt2);
            @endphp
            @else
            @php
            $refund_amt2=0;
            @endphp
            @endif

            @else
            @if(($delivery_value->rec_amt=='1' && $delivery_value->post_amt=='0') || ($delivery_value->post_amt=='1' && $delivery_value->rec_amt=='0' ))
            $refund_amt2=0;
            @else
            $refund_amt2='0';
            @endif

            @endif

            @if(is_null($delivery_value->court_fee_dt) && $delivery_value->court_fee_dt<$delivery_value->actual_del_dt )
              @php
              $cost=$page2*page_charge($page_charges,$delivery_value->app_type,$delivery_value->rec_dt);
              @endphp
              @if(($cost) !='0' )
              @php
              $cf2=( $page2*page_charge($page_charges,$delivery_value->app_type,$delivery_value->rec_dt) )-$delivery_value->court_fee;
              @endphp
              @endif
              @else
              @php
              $var1='Y';
              @endphp
              @endif

              @if(is_null($delivery_value->court_fee_dt))
              @php
              $cf2=$page2* page_charge($page_charges,$delivery_value->app_type,$delivery_value->actual_del_dt);
              @endphp
              @else
              @php
              $var2='Y';
              @endphp
              @endif


              @if(($delivery_value->rec_amt == '1' && $delivery_value->post_amt == '0') || ($delivery_value->post_amt == '1' && $delivery_value->rec_amt=='0' ))
              @php
              $cf2=1;
              @endphp
              @endif


              @if(($delivery_value->rec_amt=='0' && $delivery_value->post_amt=='0') || ($delivery_value->post_amt=='0' && $delivery_value->rec_amt=='0' ))
              @php
              $cf2=0;
              @endphp
              @endif

              @php
              $final_fur_amt+=$further_amount2;
              $final_refund_amt+=$refund_amt2;
              $final_reg_post_amt+=$reg_post_amt2;
              @endphp