000

@extends('dashboard.layouts.app')
@section('title','Secondary Discount Party Ledger')
@section('style')
{{Html::style("assets/css/bootstrap-datepicker3.min.css")}}
@endsection

@section('content')

<div class="main-content">
	<div class="main-content-inner">
		<div class="breadcrumbs ace-save-state" id="breadcrumbs">
			<ul class="breadcrumb">
				<li>
					<i class="ace-icon fa fa-home home-icon"></i>
					<a href="#">{{__('messages.Home')}}</a>
				</li>
				<li class="active">Secondary Discount Party Ledger</li>
			</ul>
		</div>

@if (session('success'))
			<div class="alert alert-success">
				{{ session('success') }}
			</div>
			@endif
			@if (session('error'))
			<div class="alert alert-danger">
				{{ session('error') }}
			</div>
			@endif
			<h3 class="header smaller lighter blue">Secondary Discount Party Ledger</h3>
			<div class="row">
				<div class="col-xs-12">
					<form action="" method="POST" role="form" id="FilterForm">
						<div class="row">
							{{csrf_field()}}
							<div class="col-md-3">
								<div class="form-group">
									<label for="retailer_id"> Dealer</label>
									<select class="form-control select2" name="dealer_id" id="dealer_id" >
										<option value=""> Select Dealer</option>
										@foreach($dealers as $dealer)
										<option value="{{$dealer->id}}" {{isset($dealer_id) && $dealer_id==$dealer->id ? "selected":""}}>{{$dealer->name}} ({{$dealer->address1}})</option>
										@endforeach()
									</select>
									@if ($errors->has('dealer_id'))
									<span class="label label-danger">{{ $errors->first('dealer_id') }}</span>
									@endif
								</div>
							</div>

<div class="col-md-3">
								<div class="form-group">
									<label for="retailer_id"> Retailer</label>
									<select class="form-control select2" name="retailer_id" id="retailer_id">
										<option value=""> Select Retailer</option>
										@foreach($retailers as $retailer)
										<option value="{{$retailer->id}}" {{isset($retailer_id) && $retailer_id==$retailer->id ? "selected":""}}>{{$retailer->name}} ({{$retailer->address}})</option>
										@endforeach()
									</select>
									@if ($errors->has('retailer_id'))
									<span class="label label-danger">{{ $errors->first('retailer_id') }}</span>
									@endif
								</div>
							</div>
							<div class="col-md-2">
								<div class="form-group input-daterange">
									<label for="from_date"> From Date</label>
									@if(isset($from_date))
 										<input type="text" value="{{$from_date}}" name="from_date" id="from_date" class="form-control" placeholder="From Date" readonly="">
									@else
										<input type="text"  name="from_date" id="from_date" class="form-control" placeholder="From Date" readonly="">
									
									@endif
										<span class="label label-danger"></span>
									
								</div>
							</div>
							<div class="col-md-2">
								<div class="form-group input-daterange">
									<label for="to_date"> To Date</label>
									
									@if(isset($to_date))
 										<input type="text" value="{{$to_date}}" name="to_date" id="to_date" class="form-control" placeholder="To Date" readonly="">
									@else
		            					 <input type="text"  name="to_date" id="to_date" class="form-control" placeholder="To Date" readonly="">
									@endif
									 
									
									<span class="label label-danger"></span>
									
								</div>
							</div>
							<div class="col-md-2">
								<div class="form-group">
									<button type="submit" class="btn btn-primary" style="
  										  margin-top: 23px;">Submit</button>
								</div>
							</div>
						
						</form>

</div>
				</div>

</div>
				</div>
				<div class="table-header">
					Secondary Discount Party Ledger
					<div class="widget-toolbar no-border">

<a class="btn btn-xs bigger btn-success" data-toggle="modal" href="#addTransaction">
								Received Payment
								<i class="ace-icon fa fa-eye icon-on-right"></i>
							</a>
							<a class="btn btn-xs bigger btn-success" data-toggle="modal" href="#openingTransaction">
								Opening Balance
								<i class="ace-icon fa fa-eye icon-on-right"></i>
							</a>
							<a class="btn btn-xs bigger btn-warning" data-toggle="modal" href="#addPayment1">
								Add Payment
							  <i class="ace-icon fa fa-eye icon-on-right"></i>
						  </a>
							
						</div>
				</div>
				
				<div class="table-responsive">
					<div class="dataTables_borderWrap">
						<table id="dynamic-table"  class="table table-striped table-bordered table-hover">
							<thead>
								<tr>
									<th>Date</th>
									<th>Retailer</th>
									<th>Particular</th>
									<th>Against</th>
									<th>credit</th>
									<th>Debit</th>
								</tr>
							</thead>

<tbody>
								@isset($ledgers)
								@php
									$total_debit = 0;
									$total_credit = 0;
									$closing_balance = 0;
								@endphp

@foreach($ledgers as $ledger)
								<tr>
									<td>{{date('d/m/Y',strtotime($ledger->transaction_date))}}</td>
									<td>{{getModelById('Retailer',$ledger->retailer_id)->name}} ({{getModelById('Retailer',$ledger->retailer_id)->address}})</td>
									<td>{{$ledger->particular}}</td>
									<td>{{($ledger->against!='')?$ledger->against:$ledger->journal_series}}</td>
									<td>{{$ledger->credit}}
										@if($ledger->credit > 0)
												@php
													$total_credit = $total_credit + $ledger->credit; 
												@endphp
											@endif
									</td>
									<td>{{$ledger->debit}}
										@if($ledger->debit > 0)
												@php
													$total_debit = $total_debit + $ledger->debit; 
												@endphp
											@endif
									</td>
									
								</tr>
								@endforeach
								<tr>
									<td></td>
									<td></td>
									<td></td>
									<td><b>Opening Balance</b></td>
									<td>@if($opening_balance < 0) {{abs($opening_balance)}} @endif</td>
									<td>@if($opening_balance > 0) {{abs($opening_balance)}} @endif </td>
								</tr>
								<tr>
									<td></td>
									<td></td>
									<td></td>
									<td><b>Total</b></td>
									
									<td>@if($opening_balance < 0 ) {{ $total_credit = $total_credit + abs($opening_balance) }} @else  {{$total_credit}}   @endif</td>
									<td>@if($opening_balance > 0) {{ $total_debit = $total_debit+abs($opening_balance) }} @else {{$total_debit}} @endif</td>
								</tr>

<tr>
									<td></td>
									<td></td>
									<td></td>
									<td ><b>Closing Balance</b></td>
									@php
								
										$closing_balance = $total_debit  - $total_credit ;
									
									@endphp
									
									<td>@if($closing_balance < 0) {{abs($closing_balance)}} @endif</td>
									<td>@if($closing_balance > 0) {{abs($closing_balance)}} @endif </td>
								</tr>
								@endif
							</tbody>
						</table>
					</div>
				</div>

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

<div class="modal fade" id="addTransaction">
	<div class="modal-dialog modal-md">
		<div class="modal-content">
			<div class="modal-header">
				<button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
				<h4 class="modal-title">Add Transaction For @if(isset($retailer_id)) {{getModelById('Retailer',$retailer_id)->name}} @endif</h4>
			</div>
			<div class="modal-body">
				<form action="{{URL('/user/received-sd-payment')}}" role="form" id="recivePayment" method="POST">
				@csrf
					
					<div class="row">
						<div class="col-md-6">
								<div class="form-group">
									<label for="dealer_id1"> Dealer</label>
									<select class="form-control select2" name="dealer_id1" id="dealer_id1" >
										<option value=""> Select Dealer</option>
										@foreach($dealers as $dealer)
										<option value="{{$dealer->id}}" {{isset($dealer_id) && $dealer_id==$dealer->id ? "selected":""}}>{{$dealer->name}} ({{$dealer->address1}})</option>
										@endforeach()
									</select>							
									<span class="label label-danger" id="add_dealer_id1_error"></span>									
								</div>
							</div>

<div class="col-md-6">
								<div class="form-group">
									<label for="retailer_id1"> Retailer</label>
									<select class="form-control select2" name="retailer_id1" id="retailer_id1">
										<option value=""> Select Retailer</option>
										@foreach($retailers as $retailer)
										<option value="{{$retailer->id}}" {{isset($retailer_id) && $retailer_id==$retailer->id ? "selected":""}}>{{$retailer->name}} ({{$retailer->address}})</option>
										@endforeach()
									</select>
									<span class="label label-danger" id="add_retailer_id1_error"></span>
								</div>
							</div>
							<div class="col-md-6">
								<div class="form-group">
									<label for="icon">Bank Account</label>
									<select class="form-control select2" name="bank_id1" id="bank_id1" >
											<option value=""> Select Bank Account</option>
											
										@foreach($bank_accounts as $bank)
											<option value="{{$bank->id}}">{{getModelById('Bank',$bank->bank_id)->name}} ( {{$bank->account_number}} )</option>
										@endforeach()
											
										</select>
									<span class="label label-danger" id="add_bank_id1_error" style="display: none;"></span>
								</div>
							</div>
						<div class="col-md-6">
							<div class="form-group">
								<label for="amount">Amount</label>
								<input type="text" class="form-control" onkeypress="return onlyCurrency(event)" name="amount" id="amount" placeholder="Amount">
								<span class="label label-danger" id="add_amount_error" style="display: none;"></span>
							</div>
						</div>
						<div class="col-md-6">
							<div class="form-group">
								<label for="reference_no">Referance No</label>
								<input type="text" class="form-control" name="reference_no" id="reference_no" placeholder="Referance No">
								<span class="label label-danger" id="add_reference_no_error" style="display: none;"></span>
							</div>
						</div>
						<div class="col-md-6">
							<div class="form-group">
								<label for="transaction_date">Transaction Date</label>
								<input type="date" class="form-control" name="transaction_date" id="transaction_date" placeholder="Bank">
								<span class="label label-danger" id="add_transaction_date_error" style="display: none;"></span>
							</div>
						</div>
						<div class="col-md-6">
						<div class="form-group">
									<label for="retailer_id"> Mode</label>
									<select class="form-control select2" name="mode" id="mode">
										<option value=""> Select Mode</option>
										@foreach($modes as $mode)
										<option value="{{$mode->payment_mode}}">{{$mode->payment_mode}} </option>
										@endforeach()
									</select>
									
									<span class="label label-danger" id="add_mode_error" style="display:none"></span>
								
								</div>
					</div>
					</div>

<div class="modal-footer">
						<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
						<button type="submit" id="addBankBtn" class="btn btn-primary">Submit</button>
					</div>
				</form>
			</div>
		</div>
	</div>
</div>

<div class="modal fade" id="openingTransaction">
	<div class="modal-dialog modal-md">
		<div class="modal-content">
			<div class="modal-header">
				<button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
				<h4 class="modal-title">Opening Balance</h4>
			</div>
			<div class="modal-body">
				<form action="{{URL('/user/add-sd-opening-amount')}}" role="form" id="openingform" method="POST">
				@csrf
					
					<div class="row">
						<div class="col-md-6">
								<div class="form-group">
									<label for="dealer_id1"> Dealer</label>
									<select class="form-control select2" name="dealer_id1" id="dealer_id1" >
										<option value=""> Select Dealer</option>
										@foreach($dealers as $dealer)
										<option value="{{$dealer->id}}" {{isset($dealer_id) && $dealer_id==$dealer->id ? "selected":""}}>{{$dealer->name}} ({{$dealer->address1}})</option>
										@endforeach()
									</select>
									@if ($errors->has('dealer_id1'))
									<span class="label label-danger">{{ $errors->first('dealer_id1') }}</span>
									@endif
								</div>
							</div>

{{csrf_field()}}
						<label for="transfer_type">General Entry</label>
								 <input type="checkbox" name='general_entry' class='generalEntry'  onchange="generalEntry()">
					<div class="row">

<div class="col-md-6">
							<div class="form-group">
								<label for="dealer_id1"> Dealer</label>
								<select class="form-control select2" name="dealer_id2" id="dealer_id2">
									<option value=""> Select Dealer</option>
									@foreach($dealers as $dealer)
									<option value="{{$dealer->id}}" {{isset($dealer_id) && $dealer_id==$dealer->id ? "selected":""}}>{{$dealer->name}} ({{$dealer->address1}})</option>
									@endforeach()
								</select>
								<span class="label label-danger" id="add_dealer_id2_error" style="display: none;"></span>
							</div>
						</div>

<div class="col-md-6">
							<div class="form-group">
								<label for="retailer_id1"> Retailer</label>
								<select class="form-control select2" name="retailer_id2" id="retailer_id2">
									<option value=""> Select Retailer</option>
									@foreach($retailers as $retailer)
									<option value="{{$retailer->id}}" {{isset($retailer_id) && $retailer_id==$retailer->id ? "selected":""}}>{{$retailer->name}} ({{$retailer->address}})</option>
									@endforeach()
								</select>
								<span class="label label-danger" id="add_retailer_id2_error" style="display: none;"></span>
							</div>
						</div>
					</div>
					<div class="row">
						<div class="col-md-6">
							<div class="form-group">
								<label for="">Payment Date</label>
								<input type="text" class="form-control checkIfValid date-picker" name="transaction_date" id="transaction_date" placeholder="Payment Date" required="required" readonly>
								<span class="label label-danger" id="add_transaction_date_error" style="display: none;"></span>

</div>
						</div>
						<div class="col-md-6">
							<div class="form-group">
								<label for="amount">Amount</label>
								<input type="text" class="form-control" name="amount" onkeypress="return onlyCurrency(event)" id="amount" placeholder="Amount">
								<span class="label label-danger" id="add_amount_error" style="display: none;"></span>
							</div>
						</div>

</div>
					<div class="row">
						<div class="col-md-6 generalEntryHide">
							<div class="form-group">
								<label for="retailer_id">Bank</label>
								<select class="form-control select2" name="bank_id" id="bank_id">
									<option value=""> Select Bank</option>
									@foreach($bank_accounts as $bank_account)
									<option value="{{$bank_account->id}}">{{$bank_account->bank->name}} - {{$bank_account->account_number}}</option>
									@endforeach

</select>

</div>
						</div>
						<div class="col-md-6 generalEntryHide">
							<div class="form-group">
								<label for="retailer_id">Mode</label>
								<select class="form-control select2" name="mode" id="mode">
									<option value=""> Select Mode</option>
									<option value="Cash">Cash</option>
									<option value="Cheque">Cheque</option>
									<option value="DD">DD</option>
									<option value="NEFT">NEFT</option>
									<option value="RTGS">RTGS</option>

</select>

</div>
						</div>

</div>
					<div class="row">

<div class="col-md-4">
							<div class="form-group">
								<label for="retailer_id">Type</label>
								<select class="form-control select2" name="type1" id="type1">
									<option value=""> Select Type</option>
									<option value="credit">Credit</option>
									<option value="debit">Debit</option>

</select>

</div>
						</div>

<div class="col-md-8">
							<div class="form-group">
								<label for="particular">Particular</label>
								<input type="text" class="form-control" name="particular" id="particular" placeholder="particular">
								<span class="label label-danger" id="add_particular_error" style="display: none;"></span>
							</div>
						</div>
					</div>

<div class="modal-footer">
						<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
						<button type="submit" class="btn btn-primary">Submit</button>
					</div>
				</form>
			</div>
		</div>
	</div>
</div>
@endsection
@section('script')

{{ Html::script("assets/js/jquery.dataTables.min.js")}}
	{{ Html::script("assets/js/jquery.dataTables.bootstrap.min.js")}}
	{{ Html::script("assets/js/dataTables.buttons.min.js")}}
	{{ Html::script("assets/js/buttons.flash.min.js")}}
	{{ Html::script("assets/js/buttons.html5.min.js")}}
	{{ Html::script("assets/js/buttons.print.min.js")}}
	{{ Html::script("assets/js/buttons.colVis.min.js")}}
	{{ Html::script("assets/js/dataTables.select.min.js")}}
	{{ Html::script("assets/js/ace-elements.min.js")}}
	{{ Html::script("assets/js/ace.min.js")}}
	{{ Html::script("assets/js/bootstrap-datepicker.min.js")}}

jQuery(function($) {

$('.input-daterange').datepicker({
		
						format:'yyyy-mm-dd',
						autoclose:true
				});

var myTable = 
				$('#dynamic-table').DataTable( {
					bAutoWidth: false,
					"aaSorting": [],
					"bProcessing": true,
					"bProcessing": true,
					"sAutoWidth": false,
					"bDestroy":true,
					"sPaginationType": "bootstrap", // full_numbers
					"iDisplayStart ": 10,
					"iDisplayLength": 10,
					"bPaginate": false, 
					"bPaginate": false, 
						    "bPaginate": false, //hide pagination
						    "bFilter": false, //hide Search bar
						    "bInfo": false, // hide showing entries
				} );

$.fn.dataTable.Buttons.defaults.dom.container.className = 'dt-buttons btn-overlap btn-group btn-overlap';

new $.fn.dataTable.Buttons( myTable, {
				buttons: [
				{
					"extend": "colvis",
					"text": "<i class='fa fa-search bigger-110 blue'></i> <span class='hidden'>Show/hide columns</span>",
					"className": "btn btn-white btn-primary btn-bold",
					columns: ':not(:first):not(:last)'
				},
				{
					"extend": "copy",
					"text": "<i class='fa fa-copy bigger-110 pink'></i> <span class='hidden'>Copy to clipboard</span>",
					"className": "btn btn-white btn-primary btn-bold"
				},
				{
					"extend": "csv",
					"text": "<i class='fa fa-database bigger-110 orange'></i> <span class='hidden'>Export to CSV</span>",
					"className": "btn btn-white btn-primary btn-bold"
				},
				{
					"extend": "excel",
					"text": "<i class='fa fa-file-excel-o bigger-110 green'></i> <span class='hidden'>Export to Excel</span>",
					"className": "btn btn-white btn-primary btn-bold"
				},
				{
					"extend": "pdf",
					"text": "<i class='fa fa-file-pdf-o bigger-110 red'></i> <span class='hidden'>Export to PDF</span>",
					"className": "btn btn-white btn-primary btn-bold"
				},
				{
					"extend": "print",
					"text": "<i class='fa fa-print bigger-110 grey'></i> <span class='hidden'>Print</span>",
					"className": "btn btn-white btn-primary btn-bold",
					autoPrint: false,
					message: 'This print was produced using the Print button for DataTables'
				}		  
			 ]
		} );
    	myTable.buttons().container().appendTo( $('.tableTools-container') );

//style the message box
		var defaultCopyAction = myTable.button(1).action();
		myTable.button(1).action(function (e, dt, button, config) {
			defaultCopyAction(e, dt, button, config);
			$('.dt-button-info').addClass('gritter-item-wrapper gritter-info gritter-center white');
		});
		
		
		var defaultColvisAction = myTable.button(0).action();
		myTable.button(0).action(function (e, dt, button, config) {
			
			defaultColvisAction(e, dt, button, config);
			
			
			if($('.dt-button-collection > .dropdown-menu').length == 0) {
				$('.dt-button-collection')
				.wrapInner('<ul class="dropdown-menu dropdown-light dropdown-caret dropdown-caret" />')
				.find('a').attr('href', '#').wrap("<li />")
			}
			$('.dt-button-collection').appendTo('.tableTools-container .dt-buttons')
		});

$('.date-picker').datepicker({
				format: 'dd/mm/yyyy',
				autoclose: true,
				todayHighlight: true
			})
			.next().on(ace.click_event, function(){
				$(this).prev().focus();
			});

$('#recivePayment').submit(function(){

$.ajax({
							url: $(this).attr('action'),
							method: 'POST',
							data: $(this).serialize(),
							dataType:'json',
							success: function(data){
								console.log(data);
								if(data.flag == true){
								swal('Success',data.msg,'success');
								} else {
									if(data.errors) {
										$.each(data.errors, function(key, val){	
											$('#add_'+ key +'_error').text(val).removeAttr('style');
										});	
									} else {
										swal('Oops', data.msg, 'error');
									}	
								}	
							}
							,
							error:function(error){
								console.log(data);
								
							}

});
                     return false;
				});

$('#openingform').submit(function(){

$.ajax({
							url: $(this).attr('action'),
							method: 'POST',
							data: $(this).serialize(),
							dataType:'json',
							success: function(data){
								console.log(data);
								if(data.success == true){
								swal('Success',data.msg,'success');
								}
								if(data.success==false){
							  	swal('Error',data.msg,'error');
							  }	
							}
							,
							error:function(error){
								console.log(error);
								
							}

});
                     return false;
				});

$('#addPayment').submit(function() {

$.ajax({

url: $(this).attr('action'),
											method: 'POST',
											data: $(this).serialize(),
											dataType: 'json',
											success: function(data) {
												// console.log(data);
												if(data.error){
													console.log(data.error);
													$.each(data.error, function(index, value) {
														console.log(value);
														showError('add_'+index+'_error',value);
														// Will stop running after "three"
														
														});
													
													// showError('add_name_error',element.name);
								                    // showError('add_company_error',data.errors.company_id);

}
												if (data.success == true) {

$('#addPayment1').modal('toggle');
													swal('Success', data.msg, 'success');
												}
												if (data.success == false) {
													swal('Error', data.msg, 'error');
												}
											},
											error: function(error) {
												console.log(error);

}

});
						return false;
			         });

})
	</script>
	<script type="text/javascript">

$('#FilterForm').submit();
		}

function generalEntry()
    {
        if($('.generalEntry').is(":checked"))
         $(".generalEntryHide").hide();   
          
        else
        	  $(".generalEntryHide").show();
            
    }
	</script>
@endsection