@extends('layouts.main')

@section('main-container')
    <style>
        .select2-container .select2-selection--single {
            height: auto !important;
        }

        .select2-container .select2-selection--single .select2-selection__rendered {
            padding-top: .25rem !important;
            padding-bottom: .25rem !important;
            font-size: .875rem !important;
        }


        .select2-container--default .select2-selection--single .select2-selection__arrow {
            top: 3px !important;
            right: 3px !important;
        }

        .select2-container--default .select2-selection--single .select2-selection__rendered {
            line-height: 1.5 !important;
        }
    </style>
    	  <div>
    @if (Session::has('success'))
        <div class="alert alert-success alert-dismissible my-1" role="alert">
            <button type="button" class="close" data-bs-dismiss="alert">
                <i class="fa fa-times"></i>
            </button>
            <strong>Success !</strong> {{ session('success') }}
        </div>
    @endif



    @if($errors->any())
        <div class="alert alert-danger alert-dismissible my-1" role="alert">
            <button type="button" class="close" data-bs-dismiss="alert">
                <i class="fa fa-times"></i>
            </button>
            @foreach($errors->all() as $error)
            <strong>Error !</strong> {{ $error }}
            @endforeach
        </div>
    @endif
  </div>
  
  
    <div class="main_content_iner mt-0">
        
        <div class="container-fluid p-0 sm_padding_15px">
            <div class="">
                <div class="px-4 py-1 theme_bg_1">
                    <h5 class="mb-0 text-white text-center">Income Expenditure</h5>
                </div>
            </div>

            <form action="{{ route('incomeexpenditure.show') }}" method="get">
                @csrf
                <div class="m-3">
                    <div class="row mb-3">
					 <div class="col-sm-4 form-group">
                    
                    <div class="input-group input-group-sm flex-nowrap">
                        <span class="input-group-text" id="addon-wrapping"><i class="fa-regular fa-calendar-days"></i></span>
                        <select class="form-select form-select-sm form-control" id="month" name="month">
						<option>Select A Month</option>                           
						   @foreach(range(1,12) as $month)
                                <option {{ $invoiceMonth==$month? 'selected' : '' }} value="{{ $month }}">
                                    {{ date("M", mktime(0, 0, 0, $month, 1)) }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                </div>


                <div class="col-sm-4 form-group">
                 
                    <div class="input-group input-group-sm flex-nowrap">
                        <span class="input-group-text" id="addon-wrapping"><i class="fa-regular fa-calendar-days"></i></span>
                        <select class="form-select form-select-sm form-control" id="year" name="year" >
                            <option>Select A Year</option>
                            @foreach (range(now()->year - 10, now()->year + 5) as $year)
                                <option {{ $invoiceYear==$year? 'selected' : '' }} value="{{ $year }}">{{ $year }}</option>
                            @endforeach
                        </select>
                    </div>
                </div>

                        <div class="col-sm-3">
                            <button type="button" class="btn btn-sm btn-primary me-2"  onclick="this.disabled=true;this.form.submit();"><i class="fa-solid fa-magnifying-glass me-1"></i>Search</button>
                            <a class="btn btn-warning btn-sm text-white me-2" onclick="window.print()"><i class="fa-solid fa-print me-1"></i>Print</a>
                            <a class="btn btn-success btn-sm"><i class="fa-regular fa-file-excel me-1"></i>Excel</a>
                        </div>
                    </div>
                </div>
            </form>
					<div class="px-4 py-1">
                    <h5 class="mb-0 text-center">Millennium Computers And Networking</h5>
					<h5 class="mb-0 text-center">Income Expenditure Statement</h5>
					<h5 class="mb-0 text-center">For {{ $invoiceMonth}} - {{ $invoiceYear}}</h5>
					
                </div>


            <div class="QA_table p-3 pb-0 table-responsive">
                @php
                    $count  = 1;
					$CrAmount= 0;
					$DrAmount= 0;
					
		           @endphp



                <table class="table table-responsive">
                    <thead>
                    <TR>
              <td >
              <strong>  <font color='#000000' face='Verdana' size='2'> <center> Glcode</center></font>
              </strong>
              </td>
              <td >
              <strong>  <font color='#000000' face='Verdana' size='2'> <center>Description</center></font>
              </strong>
              </td>
              <td>
              <strong>  <font color='#000000' face='Verdana' size='2'> <center> Amount</center></font>
              </strong>
              </td>
            </TR>
            
            <TR>
              <td colspan='3'>
              <strong>  <font color='#000000' face='Verdana' size='2'> Income</font>
              </strong>
              </td>
            </TR>
                    </thead>
                    <tbody>		
						
			@php
			$tinc=0;
			$tincc=0;
			$texp=0;
			$texpc=0;
			@endphp


                @foreach ($incomes as $income)
				
			@php
					$cbalance=0;
					$Dr = $income->Dr;
					$Cr = $income->Cr;

            $cbalance=$Cr-$Dr;
            $tinc=$tinc+$cbalance;
            
            if($cbalance<0){
                  
                  $cbalance="( ".number_format(abs($cbalance),2).")";
            }else{
                $cbalance=number_format($cbalance,2);
                  
            }
	@endphp			
			<TR>
              <td ><font color='#000000' face='Verdana' size='1'>{{ $income->gl_code }}</font></td>
              <td ><font color='#000000' face='Verdana' size='1'> {{ $income->description }}  </font></td>
              <td align='right'><font color='#000000' face='Verdana' size='1' >{{ $cbalance }}</font></td>
            </TR>           
			@endforeach
			@php
            $tincc=number_format($tinc,2); 	
			@endphp	
			
			<TR>
              <td align='right' colspan='2'><font color='#000000' face='Verdana' size='2' > <b>Total Income (A)  </font></td>
              <td align='right'><font color='#000000' face='Verdana' size='2' ><b>{{ $tincc }}</font></td>
            </TR>
            <TR>
              <td colspan='3'>
              <strong>  <font color='#000000' face='Verdana' size='2'> Expenditure</font>
              </strong>
              </td>
            </TR>

			
			@foreach ($expenses as $expense)
				
			@php
			$cbalance1=0;
			
            $Dr1 = $expense->Dr;
			$Cr1 = $expense->Cr;
			
            $cbalance1=$Cr1-$Dr1;
			$texp=$texp+$cbalance1;
            
            if($cbalance1<0){
                  
                  $cbalance1="( ".number_format(abs($cbalance1),2).")";
            }else{
                $cbalance1=number_format($cbalance1,2);
                  
            }	
			@endphp	
			<TR>
				<td ><font color='#000000' face='Verdana' size='1'>{{ $expense->gl_code }}</font></td>
              <td ><font color='#000000' face='Verdana' size='1'> {{ $expense->description }}  </font></td>
              <td align='right'><font color='#000000' face='Verdana' size='1' >{{ $cbalance1 }}</font></td>
            </TR>			
			@endforeach 
			
			@php
			 if($texp<0){
                  
                  $texpc=number_format(abs($texp),2));
            }else{
                $texpc=number_format($texp,2);
                  
            }				
			@endphp	

			<TR>
              <td align='right' colspan='2'><font color='#000000' face='Verdana' size='2' > <b>Total Expenditure (B)  </font></td>
              <td align='right'><font color='#000000' face='Verdana' size='2' ><b>{{ $texpc }} </font></td>
            </TR>	

     
	 </tbody>
                </table>
				<br>
	<br>
	<br>
	
	

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

    <script>
        $(document).ready(function() {
            $('.select2').select2({
                
            });
        });
    </script>
@endsection