/
home
/
sjslayjy
/
public_html
/
mosaram
/
storage
/
framework
/
views
/
Upload File
HOME
<?php $__env->startSection('title','Party Ledger'); ?> <?php $__env->startSection('style'); ?> <meta name="csrf-token" content="<?php echo e(csrf_token()); ?>"> <?php echo e(Html::style("assets/css/bootstrap-datepicker3.min.css")); ?> <?php $__env->stopSection(); ?> <?php $__env->startSection('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="#"><?php echo e(__('messages.Home')); ?></a> </li> <li class="active"> Party Ledger</li> </ul> </div> <div class="page-content"> <?php if(session('success')): ?> <div class="alert alert-success"> <?php echo e(session('success')); ?> </div> <?php endif; ?> <?php if(session('error')): ?> <div class="alert alert-danger"> <?php echo e(session('error')); ?> </div> <?php endif; ?> <div class="row"> <div class="col-xs-12"> <h3 class="header smaller lighter blue"> Party Ledger</h3> <form action="" method="POST" role="form" id="FilterForm"> <div class="row"> <?php echo e(csrf_field()); ?> <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> <?php $__currentLoopData = $retailers; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $retailer): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <option value="<?php echo e($retailer->id); ?>" <?php echo e(isset($retailer_id) && $retailer_id==$retailer->id ? "selected":""); ?>><?php echo e($retailer['name']); ?> (<?php echo e($retailer['address']); ?>)</option> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> </select> <?php if($errors->has('retailer_id')): ?> <span class="label label-danger"><?php echo e($errors->first('retailer_id')); ?></span> <?php endif; ?> </div> </div> <div class="col-md-3"> <label for="group_id">Groups</label> <select class="form-control select2" name="group_id" id="group_id"> <option value="">Select Group</option> <?php $__currentLoopData = $groups; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $key=>$group_id): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <option value="<?php echo e($group_id->id); ?>"><?php echo e($group_id->name); ?>(<?php echo e($group_id->id); ?>)</option> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> </select> <?php if($errors->has('group_id')): ?> <span class="label label-danger"><?php echo e($errors->first('group_id')); ?></span> <?php endif; ?> </div> <div class="col-md-2"> <div class="form-group input-daterange"> <label for="from_date"> From Date</label> <?php if(isset($from_date)): ?> <input type="text" value="<?php echo e($from_date); ?>" name="from_date" id="from_date" class="form-control" placeholder="From Date" readonly=""> <?php else: ?> <input type="text" name="from_date" id="from_date" class="form-control" placeholder="From Date" readonly=""> <?php 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> <?php if(isset($to_date)): ?> <input type="text" value="<?php echo e($to_date); ?>" name="to_date" id="to_date" class="form-control" placeholder="To Date" readonly=""> <?php else: ?> <input type="text" name="to_date" id="to_date" class="form-control" placeholder="To Date" readonly=""> <?php endif; ?> <span class="label label-danger"></span> </div> </div> <!-- <div class="col-md-2"> <div class="form-group"> <label for="credit_note"></label> <input type="checkbox" id="credit_note" name="credit_note" value="cn" style="margin-top: 36px;"> <label for="credit_note"> Credit Note</label> <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 class="clearfix"> <div class="pull-right tableTools-container"> </div> </div> <div class="table-header"> Party Ledger <!-- <div class="widget-toolbar no-border"> <a class="btn btn-xs bigger btn-success" data-toggle="modal" href="#refundTransaction"> Refund <i class="ace-icon fa fa-eye icon-on-right"></i> </a> </div> --> <!-- <div class="widget-toolbar no-border"> <a class="btn btn-xs bigger btn-success" data-toggle="modal" href="#invoiceRefundTransaction"> Invoice Refund <i class="ace-icon fa fa-eye icon-on-right"></i> </a> </div> --> <!-- <div class="widget-toolbar no-border"> <a class="btn btn-xs bigger btn-success" data-toggle="modal" href="#addTransaction"> Opening Balance <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> <?php if(isset($ledgers)): ?> <?php $total_debit = 0; $total_credit = 0; $closing_balance = 0; ?> <?php $__currentLoopData = $ledgers; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $ledger): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <tr> <td><?php echo e(date('d/m/Y',strtotime($ledger->transaction_date))); ?></td> <td><?php echo e(getModelById('Retailer',$ledger->retailer_id)->name); ?> (<?php echo e(getModelById('Retailer',$ledger->retailer_id)->address); ?>)</td> <td><?php echo e($ledger->particular); ?></td> <td><?php echo e($ledger->against); ?></td> <td><?php echo e($ledger->credit); ?> <?php if($ledger->credit > 0): ?> <?php $total_credit = $total_credit + $ledger->credit; ?> <?php endif; ?> </td> <td><?php echo e($ledger->debit); ?> <?php if($ledger->debit > 0): ?> <?php $total_debit = $total_debit + $ledger->debit; ?> <?php endif; ?> </td> </tr> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> <tr> <td></td> <td></td> <td></td> <td><b>Opening Balance</b></td> <td><?php if($opening_balance < 0): ?> <?php echo e(abs($opening_balance)); ?> <?php endif; ?></td> <td><?php if($opening_balance > 0): ?> <?php echo e(abs($opening_balance)); ?> <?php endif; ?> </td> </tr> <tr> <td></td> <td></td> <td></td> <td><b>Total</b></td> <td><?php if($opening_balance < 0 ): ?> <?php echo e($total_credit = $total_credit + abs($opening_balance)); ?> <?php else: ?> <?php echo e($total_credit); ?> <?php endif; ?></td> <td><?php if($opening_balance > 0): ?> <?php echo e($total_debit = $total_debit+abs($opening_balance)); ?> <?php else: ?> <?php echo e($total_debit); ?> <?php endif; ?></td> </tr> <tr> <td></td> <td></td> <td></td> <td><b>Closing Balance</b></td> <?php $closing_balance = $total_debit - $total_credit ; ?> <td><?php if($closing_balance < 0): ?> <?php echo e(abs($closing_balance)); ?> <?php endif; ?></td> <td><?php if($closing_balance > 0): ?> <?php echo e(abs($closing_balance)); ?> <?php endif; ?> </td> </tr> <?php endif; ?> </tbody> </table> </div> </div> </div> <!-- /.page-content --> </div> </div><!-- /.main-content --> <!-- Add Bank Modal --> <!-- Start Inoice Refund Transaction model --> <!-- End Invoice Refund Transaction Model --> <!-- Start Refund Transaction model --> <!-- End Refund Transaction Model --> <!-- Add Bank Modal --> <?php $__env->startSection('script'); ?> <?php echo e(Html::script("assets/js/jquery.dataTables.min.js")); ?> <?php echo e(Html::script("assets/js/jquery.dataTables.bootstrap.min.js")); ?> <?php echo e(Html::script("assets/js/dataTables.buttons.min.js")); ?> <?php echo e(Html::script("assets/js/buttons.flash.min.js")); ?> <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script> <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script> <?php echo e(Html::script("assets/js/buttons.html5.min.js")); ?> <?php echo e(Html::script("assets/js/buttons.print.min.js")); ?> <?php echo e(Html::script("assets/js/buttons.colVis.min.js")); ?> <?php echo e(Html::script("assets/js/dataTables.select.min.js")); ?> <?php echo e(Html::script("assets/js/ace-elements.min.js")); ?> <?php echo e(Html::script("assets/js/ace.min.js")); ?> <?php echo e(Html::script("assets/js/bootstrap-datepicker.min.js")); ?> <script type="text/javascript"> function onlyCurrency(event) { if (event.which == 8 || event.which == 0) { return true; } if (event.which < 46 || event.which > 59) { return false; //event.preventDefault(); } // prevent if not number/dot if (event.which == 46 && $(this).val().indexOf('.') != -1) { return false; //event.preventDefault(); } // preven } jQuery(function($) { $('.input-daterange').datepicker({ format: 'yyyy-mm-dd', autoclose: true }); // var myTable=$('#dynamic-table').DataTable({ // "bProcessing": true, // "sAutoWidth": false, // "bDestroy":true, // "sPaginationType": "bootstrap", // full_numbers // "iDisplayStart ": 10, // "iDisplayLength": 10, // "bPaginate": false, //hide pagination // "bFilter": false, //hide Search bar // "bInfo": false, // hide showing entries // }); 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": "pdfHtml5", "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", title: 'Party Ledger', download: 'open' }, { "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') }); $('#recivePayment').submit(function() { $.ajax({ url: $(this).attr('action'), method: 'POST', data: $(this).serialize(), dataType: 'json', success: function(data) { console.log(data); if (data.success == true) { $('#addTransaction').modal('toggle'); swal('Success', data.msg, 'success'); } if (data.success == false) { swal('Error', data.msg, 'error'); } }, error: function(error) { console.log(error); } }); return false; }); $('#invoiceRefundPayment').submit(function() { $.ajax({ url: $(this).attr('action'), method: 'POST', data: $(this).serialize(), dataType: 'json', success: function(data) { // alert(data); if(data.flag==true){ if (data.success == true) { $('#invoiceRefundTransaction').modal('toggle'); swal('Success', data.msg, 'success'); } if (data.success == false) { swal('Error', data.msg, 'error'); } }else{ $('#add_dealer_id3_error').hide(); $('#add_retailer_id3_error').hide(); $('#add_against_error').hide(); $('#add_bank_error').hide(); $('#add_particular3_error').hide(); $('#add_payment_mode_error').hide(); $('#add_reference_number_error').hide(); $('#add_refund_amount_error').hide(); $('#add_transaction_date_error').hide(); $.each(data.errors, function(key,val) { showError('add_'+key+'_error',val); }); } }, error: function(error) { console.log(error); } }); return false; }); $('#refundPayment4').submit(function() { $.ajax({ url: $(this).attr('action'), method: 'POST', data: $(this).serialize(), dataType: 'json', success: function(data) { // alert(data); if (data.success == true) { $('#refundTransaction').modal('toggle'); 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.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; }); $('.date-picker').datepicker({ format: 'dd/mm/yyyy', autoclose: true, todayHighlight: true }) .next().on(ace.click_event, function() { $(this).prev().focus(); }); }) </script> <script type="text/javascript"> function showError(id,error){ if(typeof(error) === "undefined"){ $('#'+id).hide(); }else{ $('#'+id).hide(); $('#'+id).show(); $('#'+id).text(error); } } function filter() { $('#invoice_id').val(''); $('#FilterForm').submit(); } var allSelect = []; $('.my-select').change(function () { allSelect = []; $('.my-select').each(function (index, item) { allSelect.push(item.value); }); if(allSelect[0]!='' && allSelect[1]!=''){ $.ajax({ url: '<?php echo e(url('user/party-against-list')); ?>', method: 'POST', data:{'_token': '<?php echo e(csrf_token()); ?>','dealer_id':allSelect[0],'retailer_id':allSelect[1]}, dataType: 'json', success: function(data) { console.log(data.against_list); let option=''; $('#against').html(''); // option='<option value=""> Select against</option>'; // $('#against').each(data.against_list ,function(index, val){ // $this.append('<option value="'+val['against']+'">' + val['against'] +' Rs- '+val['credit']+ '</option>'); // }); // against option=`<option value="">Against</option>`; $.each(data.against_list , function(index, val) { option+='<option value="'+val['against']+'">' + val['against'] +' Rs- '+val['credit']+ '</option>'; console.log( val['against']) }); $('#against').html(option); // swal('Success', data.msg, 'success'); }, error: function(error) { console.log(error); } }); return false; }else{ console.log(`THIS is wrong`); } }); </script> <?php $__env->stopSection(); ?> <?php $__env->stopSection(); ?> <?php echo $__env->make('dashboard.layouts.app', \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))->render(); ?><?php /**PATH /home3/pmmsanvp/public_html/sarojMain/resources/views/dashboard/invoice/party-ledger.blade.php ENDPATH**/ ?>