@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">Trail Balance</h5>
                </div>
            </div>

            <form action="{{ route('trialbalance.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">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 Networking1</h5>
					<h5 class="mb-0 text-center">Trail Balance</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;
					
		        @endphp



                <table class="table table-responsive">
                    <thead>
					<tr>
						  <td class='title_cell_e_l' rowspan='2' >Sl</td>
						  <td class='title_cell_e' rowspan='2' >GlCode</td>
						  <td class='title_cell_e' rowspan='2' >Account Head</td>
						  <td class='title_cell_e' align='center' colspan='2'>Opeining Balance</td>
						  <td class='title_cell_e' align='center' colspan='2'>Period Transaction</td>
						  <td class='title_cell_e' align='center' colspan='2'>Balance</td>
					</tr>
					
					
					<tr>
						  <td class='sub_title_cell_e' align='right'>Debit</td>
						  <td class='sub_title_cell_e' align='right'>Credit</td>
						  <td class='sub_title_cell_e' align='right'>Debit</td>
						  <td class='sub_title_cell_e' align='right'>Credit</td>
						  <td class='sub_title_cell_e' align='right'>Debit</td>
						  <td class='sub_title_cell_e' align='right'>Credit</td>
					</tr>
                                       
                    </thead>
                    <tbody>		
						
			@php
							$ONet_dr=0;
                            $ONet_cr=0;
							
							$Net_dr=0;
                            $Net_cr=0;
							  
			@endphp

							@foreach ($onamounts as $onamount)
			@php
							  $ONDrAmount = $onamount->ONDrAmount;
							  $ONCrAmount = $onamount->ONCrAmount;
							  
							 if($ONDrAmount>$ONCrAmount){
								$ONet_dr=$ONDrAmount-$ONCrAmount;
								$ONet_cr=0;
							}else{
								$ONet_cr=$ONCrAmount-$ONDrAmount;
								$ONet_dr=0;
							}
			@endphp
							@endforeach
							
							@foreach ($namounts as $namount)
			@php
							  $NDrAmount = $namount->NDrAmount;
							  $NCrAmount = $namount->NCrAmount;
							  
								if($NDrAmount>$NCrAmount){
										$Net_dr=$NDrAmount-$NCrAmount;
										$Net_cr=0;
								}else{
										$Net_cr=$NCrAmount-$NDrAmount;
										$Net_dr=0;
								}
			@endphp
							
							@endforeach
							
							
			@php				
							
							$eDrAmount=0;
							$eCrAmount=0;
							$i=1;
							$ie="";
			@endphp			
						
							
				@foreach ($incomeexpens as $incomeexpen)
			@php
							$DrAmount = $incomeexpen->DrAmount;
							$CrAmount = $incomeexpen->CrAmount;

							$eDrAmount=$eDrAmount+$DrAmount;
							$eCrAmount=$eCrAmount+$CrAmount;
							
							$glcode = $incomeexpen->gl_code;
							$descriptions = $incomeexpen->description;
							
							if($DrAmount==0 && $CrAmount==0 ){
						
							}else{
									$ie.="<tr>
								  <td class='title_cell_e_l' >".$i."</td>
								  <td class='title_cell_e' ><a href='rpayDetail.php?cboAccountHead=$glcode&start=$start_date&end=$end_date&cost_code=$selectedCostcenter' onclick=\"window.open(this.href, 'Snopzer','left=20,top=20,width=500,height=500,resizable=0'); return false;\" >".$glcode."</a></td>
								  <td class='title_cell_e' ><a href='rpayDetail.php?cboAccountHead=$glcode&start=$start_date&end=$end_date&cost_code=$selectedCostcenter' onclick=\"window.open(this.href, 'Snopzer','left=20,top=20,width=500,height=500,resizable=0'); return false;\" >".$descriptions."</a></td>
								  <td class='even_td_e' align='right'></td>
								  <td class='even_td_e' align='right'></td>
								  <td class='even_td_e' align='right'>".number_format($DrAmount,2,'.',',')."</td>
								  <td class='even_td_e' align='right'>".number_format($CrAmount,2,'.',',')."</td>
								  <td class='even_td_e' align='right'></td>
								  <td class='even_td_e' align='right'></td>
							</tr>";
						}
			$i++;
			@endphp
				@endforeach
				
			@php
						if($eDrAmount==0 && $eCrAmount==0 ){
			
						}else{
						 $ie.="<tr>
								  <td class='td_e_b_l' colspan='3' align='right'><b>Total Income & Expense</b></td>
								  <td class='even_td_e' align='right'></td>
								  <td class='even_td_e' align='right'></td>
								  <td class='even_td_e' align='right'><b>".number_format($eDrAmount,2,'.',',')."</td>
								  <td class='even_td_e' align='right'><b>".number_format($eCrAmount,2,'.',',')."</td>
								  <td class='even_td_e' align='right'></td>
								  <td class='even_td_e' align='right'></td>
							</tr>";
						}
			@endphp
			
					
			@php
						$i=0;
						$Total_dr=0;
						$Total_cr=0;
						$i=1;
			
			@endphp
			
			
				@foreach ($oamounts as $oamount)
			@php
			
				$BDrAmount=0;
				$BCrAmount=0;
				$OTotal_dr=0;
				$OTotal_cr=0;
				$BTotal_cr=0;
				$BTotal_dr=0;
				
				$ODrAmount = $oamount->ODrAmount;
				$OCrAmount = $oamount->OCrAmount;
				
				$DrAmount1 = $oamount->DrAmount;
				$CrAmount1 = $oamount->CrAmount;
				
				$glcode1 = $oamount->gl_code;
				$descriptions1 = $oamount->description;			
							
				$Total_dr=$Total_dr+$DrAmount1;
				$Total_cr=$Total_cr+$CrAmount1;
				
				if($ODrAmount>$OCrAmount){
					$ODrAmount=$ODrAmount-$OCrAmount;
					$OCrAmount=0;
					$OTotal_dr=$OTotal_dr+$ODrAmount;					
				}else{					
					$OCrAmount=$OCrAmount-$ODrAmount;
					$ODrAmount=0;
					$OTotal_cr=$OTotal_cr+$OCrAmount;					
				}
				
				
				$BDrAmount=$DrAmount1+$ODrAmount;
				$BCrAmount=$CrAmount1+$OCrAmount;
				
				if($BDrAmount>=$BCrAmount){
					$BDrAmount=$BDrAmount-$BCrAmount;					
					$BCrAmount=0;
					
				}else{
					$BCrAmount=$BCrAmount-$BDrAmount;					
					$BDrAmount=0;
				}				
				
				$BTotal_cr=$BTotal_cr+$BCrAmount;
				$BTotal_dr=$BTotal_dr+$BDrAmount;
				
				 $rcdetailgl="<br>";
		  if($ODrAmount==0 && $OCrAmount==0 && $DrAmount1==0 && $CrAmount1==0 && $BDrAmount==0 && $BCrAmount==0){
			  
		  }else{
			  echo "<tr>
						  <td class='title_cell_e_l' >".$i."</td>
						  <td class='title_cell_e' ><a href='rpayDetail.php?cboAccountHead=$glcode1&start=$start_date&end=$end_date&cost_code=$selectedCostcenter' onclick=\"window.open(this.href, 'Snopzer','left=20,top=20,width=500,height=500,resizable=0'); return false;\" >".$glcode1."</a></td>
						  <td class='title_cell_e' ><a href='rpayDetail.php?cboAccountHead=$glcode1&start=$start_date&end=$end_date&cost_code=$selectedCostcenter' onclick=\"window.open(this.href, 'Snopzer','left=20,top=20,width=500,height=500,resizable=0'); return false;\" >".$descriptions1."</a></td>
						  <td class='even_td_e' align='right'>".number_format($ODrAmount,2,'.',',')."</td>
						  <td class='even_td_e' align='right'>".number_format($OCrAmount,2,'.',',')."</td>
						   <td class='even_td_e' align='right'>".number_format($DrAmount1,2,'.',',')."</td>
						  <td class='even_td_e' align='right'>".number_format($CrAmount1,2,'.',',')."</td>
						   <td class='even_td_e' align='right'>".number_format($BDrAmount,2,'.',',')."</td>
						  <td class='even_td_e' align='right'>".number_format($BCrAmount,2,'.',',')."</td>
					</tr>";
				$i++;
			}
	@endphp
				@endforeach
			
			@php
						if($ONet_dr==0 && $ONet_cr==0 && $Net_dr==0 && $Net_cr==0 ){
			
			}else{
			echo "
			   <tr>
					<td class='td_e_b_l' colspan='3' align='right'><b>Net Income</b></td>
					<td class='td_e_b' align='right'>".number_format($ONet_dr,2,'.',',')."</td>
					<td class='td_e_b' align='right'>".number_format($ONet_cr,2,'.',',')."</td>
					<td class='td_e_b' align='right'>".number_format($Net_dr,2,'.',',')."</td>
					<td class='td_e_b' align='right'>".number_format($Net_cr,2,'.',',')."</td>
					<td class='td_e_b' align='right'>".number_format($Net_dr,2,'.',',')."</td>
					<td class='td_e_b' align='right'>".number_format($Net_cr,2,'.',',')."</td>
					
			  </tr>
			  ";
			}
			  $Total_dr=$Total_dr+$Net_dr;
			  $Total_cr= $Total_cr+$Net_cr;
			  
			  $BTotal_dr=$BTotal_dr+$Net_dr+$ONet_dr;
			  $BTotal_cr=$BTotal_cr+$Net_cr+$ONet_cr;
			  $OTotal_dr=$OTotal_dr+$ONet_dr;
			  $OTotal_cr=$OTotal_cr+$ONet_cr;
			
			echo "

				   <tr>
						<td class='td_e_b_l' colspan='3' align='right'><b>Total</b></td>
						<td class='td_e_b' align='right'>".number_format($OTotal_dr,2,'.',',')."</td>
						<td class='td_e_b' align='right'>".number_format($OTotal_cr,2,'.',',')."</td>
						<td class='td_e_b' align='right'>".number_format($Total_dr,2,'.',',')."</td>
						<td class='td_e_b' align='right'>".number_format($Total_cr,2,'.',',')."</td>
						<td class='td_e_b' align='right'>".number_format($BTotal_dr,2,'.',',')."</td>
						<td class='td_e_b' align='right'>".number_format($BTotal_cr,2,'.',',')."</td>
						
				  </tr>
				  ";
			
			echo "$ie";
					
			@endphp

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

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

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