@extends('adminlayout.admin')

 @section('content')

<style >
    .cursor{
        cursor: pointer;
    }
    .nk-content-fluid{
        margin-top: 65px;
        position: relative;
    }
 </style>
<script src="https://cdn.jsdelivr.net/npm/jquery@3.4.0/dist/jquery.min.js"></script>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@fancyapps/fancybox@3.5.7/dist/jquery.fancybox.min.css">
<script src="https://cdn.jsdelivr.net/npm/@fancyapps/fancybox@3.5.7/dist/jquery.fancybox.min.js"></script>
<div class="nk-content nk-content-fluid" >
    
    <div class="row">
      <div class="col-12">
        <div class="nk-block-between">
        <div class="nk-block-head-content">
            <h3 class="nk-block-title page-title"> </h3>
           
        </div><!-- .nk-block-head-content -->
        <div class="nk-block-head-content">
            <div class="toggle-wrap nk-block-tools-toggle">
                
                <div class="toggle-expand-content" data-content="pageMenu">
                    <ul class="nk-block-tools g-3">

                        <li class="nk-block-tools-opt">
                            <div class="drodown">
                                <a href="{{route('dashboard')}}" class="btn btn-outline-light bg-white d-none d-sm-inline-flex"><em class="icon ni ni-arrow-left"></em><span>Back</span></a>
                                 
                            </div>
                        </li>
                    </ul>
                </div>

            </div><!-- .toggle-wrap -->
        </div><!-- .nk-block-head-content -->
    </div>
        <!-- /.card -->

        
        <div class="card card-bordered" style="margin-top: 50px;">
          <div class="card-header">
            <h3 class="card-title" style="font-size: 2.1rem; float: left; margin-right: 79%;"><nobr>Account Statement<nobr></span></h3>           
          </div>
          <!-- /.card-header -->
          <div class="card-body">
		   <form method="GET" action="{{route('accountStatement')}}">
		  <div class="row" style="padding-bottom: 30px;"> 
		     <div class="col-2"><label style="padding-top: 8px;">Month Filter</label></div>
		     <div class="col-4"> 
		      <select class="form-control" name="month" required>
			   <option value="">Select</option>
			   <option value="1" >Last Month</option>
			   <option value="3" >3 Month</option>
			   <option value="6" >6 Month</option>
			   <option value="9" >9 Month</option>
			   
			  </select>
		    </div>
			
			 <div class="col-2"><input type="submit" class="btn btn-primary"/></div>
		  </div>
		  </form>
		  <form method="GET" action="{{route('accountStatement')}}">
		  <div class="row" style="padding-bottom: 30px;"> 
		     <div class="col-2"><label style="padding-top: 8px;">Custom Date Filter</label></div>
		     <div class="col-4"> 
		     <input type="date" name="from_date" class="form-control" value="{{$from_date??''}}" required>
		    </div>
			 <div class="col-4"> 
		      <input type="date" name="to_date" class="form-control" value="{{$to_date??''}}" required>
		    </div>
			 <div class="col-2"><input type="submit" class="btn btn-primary"/></div>
		  </div>
		  </form>
            <table id="accountreports" class="table table-bordered table-striped table-responsive">
              <thead>
                <tr>
                     <th >S.no</th>
                     <th >Date</th>
                     <th >Service</th>
                     <th >Remark</th>                   
					 <th >Debit</th>
                     <th >Credit</th>
					 <th >Closing Balance</th>                  
                   
                </tr>
              </thead>
              <tbody>
                 @php 
                 $i=1;
				 $totalDebit = 0;
				 $totalCredit = 0;
               @endphp
               @foreach($statements as $data)
			   
			   @php
			    if($data->trans_type=='Dr')
				{
					$totalDebit += $data->amount;
				}
				if($data->trans_type=='Cr')
				{
					$totalCredit += $data->amount;
				}
				
			   @endphp
               <tr>
                 <td>{{$i++}}</td>
                 <td>01 Jan 1970</td>
                 <td>{{  ($data->service )? $data->service->name:'' }}</td>
                 <td></td>
				 <td>{{  ($data->trans_type=='Dr' )? $data->amount:'--' }}</td>
				 <td>{{  ($data->trans_type=='Cr' )? $data->amount:'--' }}</td>
				 <td>{{ $data->remain_wallet }}</td>                        
               
               </tr>
               @endforeach
              </tbody>
            </table>
          </div>
          <!-- /.card-body -->
        </div>
        <!-- /.card -->
      </div>
      <!-- /.col -->
    </div>
    
</div>
@php
 $user = Auth::User();
@endphp
<script>
$(document).ready(function() {
  $('#accountreports').DataTable({
   		
    buttons: [{
      extend: 'pdf',
      title: 'Global Next Suvidha Kendra',
	  messageTop: 'Name: \n\
	               Address: \n\
				   ID: \n\
				   Id Active date: 01 Jan 1970\n\
				   Statement Date:  - \n\
				   Closing Balance 0				   ',
				   
      filename: 'accountreports'
    }, {
      extend: 'excel',
      title: 'Global Next Suvidha Kendra',
	  messageTop: 'Name:   \r\n Address:  \r\n  ID:  \r\n  Id Active date: 01 Jan 1970 \r\n  Statement Date:  -  \r\n Closing Balance 0',
      filename: 'accountreports'
    }],
	
  }).buttons().container().appendTo('#accountreports_wrapper .col-md-6:eq(0)');
});
  $('[data-fancybox]').fancybox({
  // Options will go here
  buttons : [
    'close'
  ],
  wheel : false,
  transitionEffect: "slide",
   // thumbs          : false,
  // hash            : false,
  loop            : true,
  // keyboard        : true,
  toolbar         : false,
  // animationEffect : false,
  // arrows          : true,
  clickContent    : false
});
</script>
@endsection