/
home
/
sjslayjy
/
public_html
/
mosaram
/
storage
/
framework
/
views
/
Upload File
HOME
<?php $__env->startSection('title','GroupWise Debiters List'); ?> <?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">GroupWise Debiter List </li> </ul> </div> <div class="page-content"> <div class="row"> <div class="col-xs-12"> <h3 class="header smaller lighter blue">GroupWise Debiter List </h3> <form action="" method="POST" role="form"> <div class="row"> <a onclick="getPDF();" style=" flex: auto; float: right; margin-right: 270px; margin-top: 30px; "> <i class="fa fa-file-pdf-o" style="font-size:38px;color:rgb(175, 51, 51)"></i> </a> <?php echo e(csrf_field()); ?> <div class="col-md-3"> <div class="form-group"> <label for="dealer_id"> Dealer</label> <select class="form-control select2" name="dealer_id" id="dealer_id" > <option value=""> Select Dealer</option> <?php $__currentLoopData = $dealers; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $dealer): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <option value="<?php echo e($dealer->id); ?>" <?php echo e(isset($dealer_id) && $dealer_id==$dealer->id ? "selected":""); ?>><?php echo e($dealer->name); ?> (<?php echo e($dealer->address1); ?>)</option> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> </select> <?php if($errors->has('dealer_id')): ?> <span class="label label-danger"><?php echo e($errors->first('dealer_id')); ?></span> <?php endif; ?> </div> </div> <div class="col-md-3"> <div class="form-group"> <button type="submit" class="btn btn-primary" style="margin-top: 23px;">Submit</button> </div> </div> </form> </div> </div> </div> <div class="row"> <div class="col-xs-12"> <?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="clearfix"> <div class="pull-right tableTools-container"> </div> </div> --> <div class="table-header"> </div> <div class="table-responsive pdf"> <div class="container"> <!-- <h2>Groups</h2> --> <?php if(isset($groups)): ?> <?php $__currentLoopData = $groups; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $key=> $group): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <li style="list-style: none;" data-toggle="collapse" data-target="#demo_<?php echo e($group->group_id); ?>"> <button type="button" class="btn btn-info" data-toggle="collapse" data-target="#demo_<?php echo e($group->group_id); ?>">Group <?php echo e($group->group_name); ?></button> <?php $Balance=$group->totalCredit-$group->totalDebit; ?> <!-- <?php if($Balance>0): ?> <button type="button" class="btn btn-success" data-toggle="collapse">Credit Amount -<?php echo e($Balance); ?></button> <button type="button" class="btn btn-danger" data-toggle="collapse">Debit Amount -0</button> <?php else: ?> <button type="button" class="btn btn-success" data-toggle="collapse">Credit Amount -0</button> <button type="button" class="btn btn-danger" data-toggle="collapse" >Debit Amount -<?php echo e(abs($Balance)); ?></button> <?php endif; ?> --> <?php if($Balance>0): ?> <button type="button" class="btn btn-success" data-toggle="collapse"><?php echo e($Balance); ?> Cr</button> <button type="button" class="btn btn-danger" data-toggle="collapse">0 Dr</button> <?php else: ?> <button type="button" class="btn btn-success" data-toggle="collapse">0 Cr</button> <button type="button" class="btn btn-danger" data-toggle="collapse" ><?php echo e(abs($Balance)); ?> Dr</button> <?php endif; ?> </li><br> <div id="demo_<?php echo e($group->group_id); ?>" class="collapse"> <div class="table-responsive"> <div class="dataTables_borderWrap"> <?php if($group->group_id!=''): ?> <table id="" class="datatable table table-striped table-bordered table-hover"> <thead> <tr> <th>Retailer</th> <th>credit</th> <th>Debit</th> </tr> </thead> <tbody> <?php $__currentLoopData = getGroupWiseDebebitorList($group->group_id,$dealer_id); $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $item): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <tr> <td><?php echo e($item['name']); ?></td> <?php $balance=$item['totalCredit']-$item['totalDebit']; ?> <?php if($balance>0): ?> <td><?php echo e($balance); ?></td> <td>0</td> <?php else: ?> <td>0</td> <td><?php echo e(abs($balance)); ?></td> <?php endif; ?> </tr> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> </tbody> </table> <?php else: ?> <table id="" class="datatable table table-striped table-bordered table-hover"> </table> <?php endif; ?> </div> </div> </div> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> <?php else: ?> <h2 class="text text-danger">No Data</h2> <?php endif; ?> </div> </div> </div> </div> </div><!-- /.page-content --> </div> </div><!-- /.main-content --> <!-- Import Dealer Modal --> <div class="modal fade" id="importDealerModal"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title"> <?php echo e(__('messages.Import')); ?> <?php echo e(__('messages.Dealer')); ?></h4> </div> <div class="modal-body"> <form action="<?php echo e(URL('/user/import-dealer')); ?>" enctype="multipart/form-data" method="post"> <div class="row"> <?php echo e(csrf_field()); ?> <div class="col-md-12"> <div class="form-group"> <label for="name"> <?php echo e(__('messages.File')); ?></label> <input type="file" class="form-control" name="dealer_file" id="dealer_file"> </div> </div> </div> </div> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">Close</button> <button type="submit" id="importDealerBtn" class="btn btn-primary">Submit</button> </div> </form> </div> </div> </div> <!-- Import Dealer Modal --> <!-- Add Dealer Modal --> <div class="modal fade" id="addDealerModal"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title"> <?php echo e(__('messages.Dealer')); ?> <?php echo e(__('messages.AddNew')); ?></h4> </div> <div class="modal-body"> <form action="" role="form" id="addDealerForm"> <div class="row"> <div class="col-md-12"> <div class="form-group"> <label for="name"> <?php echo e(__('messages.Name')); ?></label> <input type="text" class="form-control" name="name" id="name" placeholder="Name"> <span class="label label-danger" id="add_name_error" style="display: none;"></span> </div> </div> <div class="col-md-12"> <div class="form-group"> <label for="phone"> <?php echo e(__('messages.Phone')); ?></label> <input type="text" class="form-control" name="phone" id="phone" placeholder="Phone"> <span class="label label-danger" id="add_phone_error" style="display: none;"></span> </div> </div> <div class="col-md-12"> <div class="form-group"> <label for="address"> <?php echo e(__('messages.Address')); ?></label> <input type="text" class="form-control" name="address" id="address" placeholder="Address"> <span class="label label-danger" id="add_address_error" style="display: none;"></span> </div> </div> </div> </div> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">Close</button> <button type="button" id="addDealerBtn" class="btn btn-primary">Submit</button> </div> </form> </div> </div> </div> <!-- Add Dealer Modal --> <!-- Edit Dealer Modal --> <div class="modal fade" id="editDealerModal"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title"> <?php echo e(__('messages.Dealer')); ?> <?php echo e(__('messages.Update')); ?></h4> </div> <div class="modal-body" id="EditBody"> </div> </div> </div> </div> <!-- Edit Dealer 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")); ?> <?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 src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/1.3.3/jspdf.min.js"></script> <script src="https://html2canvas.hertzen.com/dist/html2canvas.js"></script> <script type="text/javascript"> function getPDF(){ $('.dataTables_filter').hide(); $('.dataTables_info').hide(); var HTML_Width = $(".pdf").width(); var HTML_Height = $(".pdf").height(); var top_left_margin = 15; var PDF_Width = HTML_Width+(top_left_margin*2); var PDF_Height = (PDF_Width*1.5)+(top_left_margin*2); var canvas_image_width = HTML_Width; var canvas_image_height = HTML_Height; var totalPDFPages = Math.ceil(HTML_Height/PDF_Height)-1; html2canvas($(".pdf")[0],{allowTaint:true}).then(function(canvas) { canvas.getContext('2d'); console.log(canvas.height+" "+canvas.width); var imgData = canvas.toDataURL("image/jpeg", 1.0); var pdf = new jsPDF('p', 'pt', [PDF_Width, PDF_Height]); pdf.addImage(imgData, 'JPG', top_left_margin, top_left_margin,canvas_image_width,canvas_image_height); for (var i = 1; i <= totalPDFPages; i++) { pdf.addPage(PDF_Width, PDF_Height); pdf.addImage(imgData, 'JPG', top_left_margin, -(PDF_Height*i)+(top_left_margin*4),canvas_image_width,canvas_image_height); } pdf.save("Debiter_lists.pdf"); location.reload(); }); }; jQuery(function($) { // $('.input-daterange').datepicker({ // format:'yyyy-mm-dd', // autoclose:true // }); //initiate dataTables plugin var myTable = $('.datatable').DataTable( { bAutoWidth: false, "paging": false, "aaSorting": [], } ); $.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') }); }) </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/report/groupwise-debiter.blade.php ENDPATH**/ ?>