@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">Receive & Payment</h5>
                </div>
            </div>

            <form action="{{ route('receiptpayment.show') }}" method="get">
                @csrf
                <div class="m-3">
                    <div class="row mb-3">
					
					 <div class="col-sm-3 form-group">
                        <label class="fw-medium" for="start_date" class="form-label">From</label>
                        <input class="form-control input_form datepicker-here digits" name="start_date" id="start_date" data-date-Format="yyyy-mm-dd" value="{{ $start_date }}" placeholder="Start date">
                    </div>
                    <div class="col-sm-3 form-group">
                        <label class="fw-medium" for="end_date" class="form-label">To</label>
                        <input class="form-control input_form datepicker-here digits" name="end_date" id="end_date" data-date-Format="yyyy-mm-dd" value="{{ $end_date }}" placeholder="End date">
                    </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">Receive & Payment Statement</h5>
					<h5 class="mb-0 text-center">From {{ $start_date}} - {{ $end_date}}</h5>
	
	
                </div>


            <div class="QA_table p-3 pb-0 table-responsive">
                @php
                    $count  = 1;
					$CrAmount= 0;
					
					 if($has_transaction>0){
					
		        @endphp



                <table class="table table-responsive">
                    <thead>
                    <TR>
							<tr>
                                          <td class='title_cell_e' colspan='3'>Receipt</td>
                                          <td class='title_cell_e' colspan='3'>Payment</td>
                                    </tr>
                                    <tr>
                                          
                                          <td class='sub_title_cell_e' colspan='2'>Description</td>
                                          <td class='sub_title_cell_e'>Amount</td>
                                          <td class='sub_title_cell_e' colspan='2'>Description</td>
                                          <td class='sub_title_cell_e'>Amount</td>
                                    </tr>
                    </thead>
                    <tbody>		
						
			@php
							$opencashdr=0;
                              $opencashcr=0;
                              $openbankdr=0;
                              $openbankcr=0;
							  $rcdetailgl="";
							$rcdetailamnt=0;
							$rctotalamnt=0;
						$rcdetailg3="";
						$rcdetailamnt3=0;
						$rctotalamnt3=0;
							  
			@endphp

							@foreach ($queryopencash as $queryopencas)
			@php
							  $DrAmount = $queryopencas->DrAmount;
							  $CrAmount = $queryopencas->CrAmount;
			
							
								$opencashdr=$opencashdr+$DrAmount;
                                $opencashcr=$opencashcr+$CrAmount;
			@endphp
							@endforeach
							
							@foreach ($queryopenbank as $queryopenban)
			@php
							  $DrAmount1 = $queryopenban->DrAmount;
							  $CrAmount1 = $queryopenban->CrAmount;
			
							
								$openbankdr=$openbankdr+$DrAmount1;
                                $openbankcr=$openbankcr+$CrAmount1;
			@endphp
							
							@endforeach
							
							
			@php				
							
							$rcdetailgl="";
							$rcdetailamnt="";
							$rctotalamnt=0;
			@endphp			
						
							
				@foreach ($rowqueryrec as $rowqueryre)
			@php
							  $DrAmount2 = $rowqueryre->DrAmount;
							  $CrAmount2 = $rowqueryre->CrAmount;
							  $gl_code = $rowqueryre->gl_code;
							  $description = $rowqueryre->description;
							  
									$rcbal=$CrAmount2-$DrAmount2;
									$rcdetailgl=$rcdetailgl."<a href='rpayDetail.php?cboAccountHead=$gl_code&start=$start_date&end=$end_date&cbotype=Rec' onclick=\"window.open(this.href, 'Snopzer','left=20,top=20,width=500,height=500,resizable=0'); return false;\" >".$gl_code." ".$description."</a><br>";
									$rcdetailamnt=$rcdetailamnt.number_format($rcbal,2,'.',',')."<br>";
									$rctotalamnt=$rctotalamnt+$rcbal;
			@endphp
				@endforeach
				
			@php
						$pdetailgl="";
						$pdetailamnt="";
						$ptotalamnt=0;
			@endphp
				@foreach ($rowqueryp as $rowquery)
			@php
							  $DrAmount3 = $rowquery->DrAmount;
							  $CrAmount3 = $rowquery->CrAmount;
							  $gl_code1 = $rowquery->gl_code;
							  $description1 = $rowquery->description;
							  
									$pbal=$CrAmount3-$DrAmount3;
									$pdetailgl=$pdetailgl."<a href='rpayDetail.php?cboAccountHead=$gl_code1&start=$start_date&end=$end_date&cbotype=Rec' onclick=\"window.open(this.href, 'Snopzer','left=20,top=20,width=500,height=500,resizable=0'); return false;\" >".$gl_code1." ".$description1."</a><br>";
									$pdetailamnt=$pdetailamnt.number_format($pbal,2,'.',',')."<br>";
									$ptotalamnt=$ptotalamnt+$pbal;
	//Pay Detail End///		
					@endphp
				@endforeach
			
			@php
			//Closing Start ///
			
						$opencdr=0;
                        $openccr=0;
                        $openbdr=0;
                        $openbcr=0;
                        $openbalancecash=0;
                        $openbalancebank=0;

                        if(($opencashdr-$opencashcr)>0)
                        {
                              $opencdr=$opencashdr-$opencashcr;

                        }
                        else
                              $openccr=abs($opencashdr-$opencashcr);
                        if(($openbankdr-$openbankcr)>0)
                        {
                              $openbdr=$openbankdr-$openbankcr;

                        }
                        else
                              $openbcr=abs($openbankdr-$openbankcr);


                        $rctotal=$opencdr+$openbdr+$rctotalamnt;
		@endphp	
		
							@foreach ($queryopencash as $queryopencas)
					@php
							$DrAmount4 = $queryopencas->DrAmount;
							 $CrAmount4 = $queryopencas->CrAmount;
							$periodcash=$DrAmount4-$CrAmount4;
							
					@endphp					
							
							@endforeach
							
							
							@foreach ($queryopenbank as $queryopenban)
					@php
							$DrAmount5 = $queryopenban->DrAmount;
							 $CrAmount5 = $queryopenban->CrAmount;
							$periodbank=$DrAmount5-$CrAmount5;
							
					@endphp					
							@endforeach
							
							
					@php		
							$closingcash=$periodcash+$opencdr;
							$closingbank=$periodbank+$openbdr;
							$bank_close_name="";
							$bank_close_details_total="";
					@endphp
					
							@foreach ($bankdetailsclosing as $bankdetailsclosin)
					@php
							
							$bank_close_name.=$bankdetailsclosin->bank_name.'<br>';
							$bank_close_details_total.=number_format($bankdetailsclosin->total,2,'.',',').'<br>';
												
					@endphp					
							@endforeach
					
					@php		
						$closingdetail="<b>Closing Balance</b><br>
											Cash At Hand<br>
											Cash at Bank<br><span style=\"\">$bank_close_name</span>Total1<br>";
						$closingamnt="<br><br>".number_format($closingcash,2,'.',',')."<br><br>
											<span style=\"\">$bank_close_details_total</span>".number_format($closingbank,2,'.',',')."<br>";		
					@endphp		
					
			<!--	//******************Start opening bank details****************-->			
					@php		
							$bank_name="";
							$bank_details_total="";
					@endphp

					
							@foreach ($bankdetailsopening as $bankdetailsopenin)
					@php
									$bank_name.=$bankdetailsopenin->bank_name.'<br>';
									$bank_details_total.=number_format($bankdetailsopenin->total,2,'.',',').'<br>';
							
					@endphp					
							@endforeach
							
										<tr>
                                          <td class='even_td_e' align='Left' valign='Top' colspan='2'>
											<b>Opening Balance</b><br>
											Cash At Hand<br>
											Cash at Bank<br>
											<span style=\"\"></span>Total<br>	
																						  </td>
										  
                                          <td class='even_td_e' align='right' valign='Top'>
											<br>0.00<br><br>
										<span style=\"\"> </span> 
											0.00<br>
												</td>
                                          <td class='even_td_e' align='Left' valign='Top' colspan='2'> </td>
                                          <td class='even_td_e' align='right' valign='Top'> </td>
                                    </tr>
									
									<tr>
                                    <td class='td_e_b_l' colspan='2' align='left'><b>Total2</b></td>
                                    <td class='td_e_b' align='right'>0.00</td>
                                    <td class='td_e_b' colspan='2' align='right'>&nbsp;</td>
									<td class='td_e_b' align='right'>0.00</td>
                              </tr>
									
	 </tbody>
                </table>
				
				 @php
					 }					
		        @endphp
				<br>
	<br>
	<br>
	
	

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

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