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

            <form action="{{ route('blancesheet.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="end_date" class="form-label">Date</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="Start 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">Balance Sheet</h5>
					<h5 class="mb-0 text-center">Upto  {{ $end_date}}</h5>
	
	
                </div>


            <div class="QA_table p-3 pb-0 table-responsive">
                @php
                    $count  = 1;
					$mel=0;
					$totalliab=0;
					$totalasset=0;
					
		        @endphp
                <table class="table table-responsive">
                    <tbody>		
						<tr>
						<td><strong>Total Owners Equity</strong></td>
						<td></td>
						<td align="right"><strong>
					@php
						$mel=$me+$mer-$mee;
						$totalliab=$totalliab+$mel;
				    @endphp
				   0.00		</strong>
		</td>
    </tr>
	<tr>
		<td colspan="3">&nbsp;</td>
	</tr>
	<tr>
    	<td colspan="3"><strong>LIABILITIES:</strong></td>	
    </tr>
					@php
					$ccval=0;
					$cval=0;
					$totalliab1=0;
					@endphp
					
							@foreach ($liabilities as $liabilitie)
			@php
									 $tcr = $liabilitie->tcr;
									 $tdr = $liabilitie->tdr;
									 $description = $liabilitie->description;
							  
									$ccval=$tcr-$tdr;
									$cval=$cval+$ccval;
									if($tcr!=$tdr){
									echo "<tr>
									<td>$description</td>
									<td>&nbsp;</td>
									<td align='right'>".number_format($ccval,2)."</td>
									</tr>";
									}
			@endphp
							@endforeach
								
						
		<tr>
    	<td>Loan from Others</td>
    	<td></td>
    	<td align="right"> 
		@php
			$totalliab1=$totalliab+$cval;
		
		   $cval2=$cval+$loanfromothers;
		   $totalliab2=$totalliab1+$loanfromothers;
		 @endphp	  
		  
		 0.00		</td>
    </tr>
    <tr>
    	<td colspan="2"></td>
    	<td align="right"><strong>
			0.00			</strong>
		</td>
    </tr>
	
    <tr>
    	<td colspan="2"><strong>Total</strong></td>
    	<td align="right"><strong>
			0.00		</strong>
		 </td>
    </tr>
    
     <tr>
    	<td colspan="3">&nbsp;</td>
    </tr>
	
	    
    <tr>
    	<td colspan="3"><strong>PROPERTY AND ASSETS:</strong></td>	
    </tr>
	<tr>
    	<td>FIXED ASSETS (W.D.V.)</td>
    	<td>&nbsp;</td>
    	<td align="right">
		 @php
				   $totalasset=$totalasset+$fixedassets;
		 @endphp	   
				0.00		</td>
    </tr>
    <tr>
    	<td colspan="2"></td>
    	<td align="right"><strong>
		0.00		</strong>
		</td>
    </tr>
    <tr>
    	<td colspan="3"><strong>CURRENT ASSETS:</strong></td>	
    </tr>
	@php
	$cval=0;
	@endphp
	
							@foreach ($currentassets as $currentasset)
			@php
									
									$tcr = $currentasset->tcr;
									$tdr = $currentasset->tdr;
									$description = $currentasset->description;
									 
									$ccval=$tdr-$tcr;
									$cval=$cval+$ccval;
									if($tcr!=$tdr){
									echo "<tr>
									<td>$description</td>
									<td>&nbsp;</td>
									<td align='right'>".number_format($ccval,2)."</td>
									</tr>";
									}
				
			@endphp
							@endforeach
				@php
					$totalasset=$totalasset+$cval;
				 @endphp
	
			<tr>
				<td>Closing Inventory</td>
				<td></td>
				<td align="right"> 
				@php
				   $totalasset=$totalasset+$closinginventory;
				   $cval=$cval+$closinginventory;
				  
				@endphp
				 0.00				</td>
			</tr>
			
			<tr>
				<td>Investment</td>
				<td></td>
				<td align="right"> 
			@php
				   $totalasset=$totalasset+$investment;
				   $cval=$cval+$investment;
			@endphp
				 0.00				</td>
			</tr>
			<tr>
				<td>Other Current Assets</td>
				<td></td>
				<td align="right"> 
			@php

				   $totalasset=$totalasset+$othercurrentasset;
				   $cval=$cval+$othercurrentasset;
			@endphp
				 0.00				</td>
			</tr>
			<tr>
				<td>Advance Deposits and Prepayments</td>
				<td></td>
				<td align="right"> 
			@php
				   $totalasset=$totalasset+$advdeposit;
				   $cval=$cval+$advdeposit;
			@endphp
				 0.00				</td>
			</tr>
			
			
						@foreach ($oterassets as $oterasset)
			@php
									
									$tcr = $oterasset->tcr;
									$tdr = $oterasset->tdr;
									$description = $oterasset->description;
									 
									$ccval=$tdr-$tcr;
									$cval=$cval+$ccval;
									$totalasset=$totalasset+$ccval;
									echo "<tr>
									<td>$description</td>
									<td>&nbsp;</td>
									<td align='right'>".number_format($ccval,2)."</td>
									</tr>";
				
			@endphp
						@endforeach
							
					<tr>
					<td colspan="2"></td>
					<td align="right"><strong>
					0.00					</strong>
					</td>
					</tr>		

					<tr>
					<td colspan="3"><strong>CASH & BANK</strong></td>	
				</tr>
				<tr>
					<td>Cash in Hand</td>
					<td></td>
					<td align="right">
					0.00</td>
				</tr>					
				
					@foreach ($bankdetailsclosing as $bankdetailsclosin)
			@php
									
									$total = $bankdetailsclosin->total;
									$bank_name = $bankdetailsclosin->bank_name;
									 
									$cval=$cval+$total;
									$totalasset=$totalasset+$total;
									echo "<tr>
									<td>$bank_name</td>
									<td>&nbsp;</td>
									<td align='right'>".number_format($total,2)."</td>
									</tr>";
				
			@endphp
						@endforeach
				 <tr>
						<td colspan="2"></td>
						<td align="right"><strong>
						0.00						</strong>
						</td>
					</tr>

					 <tr>
						<td colspan="3">&nbsp;</td>
					</tr>
					 <tr>
						<td colspan="2"><strong>TOTAL</strong></td>
						<td align="right"><strong>0.00</strong></td>
					</tr>

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

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

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