@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">Bank Account Transaction</h5>
                </div>
            </div>

            <form action="{{ route('bankaccounttransaction.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">
				     <label class="fw-medium" for="start_date" class="form-label">Account Head</label>
				    <div class="input-group input-group-sm flex-nowrap">
                            <select name="gl_codes" id="gl_codes" class="select2 form-select form-select-sm form-control">
                                <option value="-1">Select an Account Head</option>
                                @foreach ($glcodes as $glcode)
                                    <option value="{{ $glcode->gl_code }}">{{ $glcode->description }} </option>
										@endforeach      
                            </select>
                     </div>
                   </div>
				                     <div class="col-sm-3">
				     <label class="fw-medium" for="start_date" class="form-label">Cost Center</label>
				    <div class="input-group input-group-sm flex-nowrap">
                            <select name="cost_center" id="cost_center" class="form-select form-select-sm form-control">
                                <option value="-1">Select a Cost Center</option>
                                @foreach ($costcenters as $costcenter)
                                    <option {{ $selectedCostcenter==$costcenter->id? 'selected' : '' }} value="{{ $costcenter->id }}">{{ $costcenter->description }}</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">Bank Account Transaction For {{ $glcodeName }} , {{ $CostcenterName }}</h5>
					<h5 class="mb-0 text-center">From  {{ $start_date}} To {{ $end_date}}</h5>
					
                </div>


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

		           @endphp
								@foreach ($bankdetailsopening as $bankdetailsopen)
									@php
								$BlDrAmount = $bankdetailsopen->total;
									@endphp
								@endforeach 
								

                <table class="table table-responsive">
                    <thead>
                     <tr>
					<th rowspan='2'>Entry No</th>
					<th rowspan='2'>Type</th>
                    <th rowspan='2'>Date</th>
					<th rowspan='2' align='center'>Particulars</th>
					<th rowspan='2' align='center'>Cheque No</th>
					<th colspan='2'>Period Transaction</th>
					<th colspan='2'>Balance</th>
                     </tr>
					 <tr>
					<th align='right'>Debit</th>
					<th align='right'>Credit</th>
					<th align='right'>Debit</th>
					<th align='right'>Credit</th>
				     </tr>
 
 
                    </thead>
                    <tbody>	
					
						<tr>
                            <td colspan='7'>Opening Balance</td>
							 <td>{{ $BlDrAmount }}</td>
                            <td>{{ $BlCrAmount }}</td>
						</tr>
			@php
			$Total_dr=0;
			$Total_cr=0;
			$MasterBalance=$BlDrAmount;

			@endphp

                @foreach ($bankdtransactions as $bankdtransaction)
				
			@php
					$DrAmount = $bankdtransaction->DrAmount;
					$CrAmount = $bankdtransaction->CrAmount;
					$ttype = $bankdtransaction->ttype;
					$userid = $bankdtransaction->userid;
					$partyid = $bankdtransaction->partyid;
			
			                 $Total_dr=$Total_dr+$DrAmount;
                              $Total_cr=$Total_cr+$CrAmount;
							  

                              if(strcmp($ttype,"Dr")==0)
                              {
                                    $MasterBalance=$MasterBalance+$DrAmount;
                              }
                              else
                              {
                                    $MasterBalance=$MasterBalance-$CrAmount;
                              }

                              //////////////////////////////////////////
                              if($MasterBalance>0)
                              {
                                    $BlDrAmount=$MasterBalance;
                                    $BlCrAmount=0;
                              }
                              else if($MasterBalance<0)
                              {
                                    $BlCrAmount=$MasterBalance*-1;
                                    $BlDrAmount=0;
                              }
                              else
                              {
                                    $BlDrAmount=0;
                                    $BlCrAmount=0;
                              }
                              //////////////////////////////////////////
                              
							  if( $partyid>0){
								  $userid= "<br> <b> UserID:". wordwrap(pick('trn_clients_service','GROUP_CONCAT(IF(user_id=\'\', null, user_id))',"client_id= ".$partyid." GROUP BY client_id"),70,'<br>',TRUE)."<b>";
							  }else{
								  $userid='';
							  }
				
		@endphp
							<tr>
                            <td>{{ $masjournal->journalno }}</td>
							 <td>{{ $masjournal->journaltype }}</td>
                            <td>{{ $masjournal->journaldate }}</td>
							<td > {{ $masjournal->remarks  }}  &nbsp; {{ $userid  }} </td>
                            <td align='right'>{{ $masjournal->chequeno  }}</td>
                            <td align='right'>{{ $DrAmount  }}</td>
                            <td align='right'>{{ $CrAmount  }} </td>
							<td align='right'>{{ $BlDrAmount  }}</td>
                            <td align='right'>{{ $BlCrAmount  }} </td>
                        </tr>		
				@endforeach 
								<tr>
                                    <td class='td_e_b_l' colspan='5' align='right'><b>Total</b></td>
                                    <td class='td_e_b' align='right'><b>0.00</b></td>
									<td class='td_e_b' align='right'><b>0.00</b></td>
                                    <td class='td_e_b' align='right' colspan='2'>&nbsp;</td>
                              </tr>
				
                    </tbody>
                </table>
            </div>
        </div>
 
 
    </div>

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