<?php $__env->startSection('title','Daily Stock Report'); ?> <?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"> Daily <?php echo e(__('messages.Stock')); ?> <?php echo e(__('messages.Report')); ?></li> </ul> </div> <div class="page-content"> <div class="row"> <div class="col-xs-12"> <h3 class="header smaller lighter blue"> Daily <?php echo e(__('messages.Stock')); ?> <?php echo e(__('messages.Report')); ?></h3> </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> <a class="btn btn-xs bigger btn-danger" href="<?php echo e(URL('/user/export-daily-stock-report')); ?>"> <div id="google_translate_element"></div> <script type="text/javascript"> function googleTranslateElementInit() { new google.translate.TranslateElement({ pageLanguage: 'en', includedLanguages: 'hi', layout: google.translate.TranslateElement.InlineLayout.SIMPLE }, 'google_translate_element'); } </script> <script type="text/javascript" src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script> Export <i class="fa fa-file-excel-o"></i> </a> <?php $__currentLoopData = $product_categories; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $product_cat): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <div class="table-header"> <?php echo e($product_cat->category); ?> </div> <div class="table-responsive"> <div class="dataTables_borderWrap"> <table id="dynamic-table" class="table table-striped table-bordered table-hover"> <thead> <tr> <th> <?php echo e(__('messages.Product')); ?></th> <?php $__currentLoopData = $self_parties; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $self_party): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <th><?php echo e($self_party['party_name']); ?> <br>(<?php echo e($self_party['address']); ?>)</th> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> <th>Other Parties</th> <?php $__currentLoopData = $product_companies; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $product_company): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <th><?php echo e($product_company['party_name']); ?> <br>(<?php echo e($product_company['address']); ?>)</th> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> <th> <?php echo e(__('messages.Total')); ?></th> <?php $__currentLoopData = $warehouses; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $warehouse): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <?php $stock = \App\Inventory::where('warehouse_id',$warehouse->id)->sum('quantity'); ?> <?php if($stock > 0): ?> <th><?php echo e($warehouse->name); ?></th> <?php endif; ?> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> <th> <?php echo e(__('messages.Total')); ?></th> </tr> </thead> <tbody> <?php if(count($products) > 0): ?> <?php $__currentLoopData = $products; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $product): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <?php if($product['product_category_id'] == $product_cat->id): ?> <tr> <td><?php echo e($product['name']); ?>/<?php echo e($product['product_company']); ?></td> <?php $party_total = 0; ?> <?php $__currentLoopData = $self_parties; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $self_party): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <td> <?php if(is_null(getPartyInventoryByProductAndBrand($self_party['id'],$product['id'],$product['product_brand_id'],$self_party['type']))): ?> 0 <?php else: ?> <?php echo e(getPartyInventoryByProductAndBrand($self_party['id'],$product['id'],$product['product_brand_id'],$self_party['type'])); ?> <?php $party_total = $party_total + getPartyInventoryByProductAndBrand($self_party['id'],$product['id'],$product['product_brand_id'],$self_party['type']); ?> <?php endif; ?> </td> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> <td> <?php echo e(getOtherPartyInventoryByProductAndBrand($product['id'],$product['product_brand_id'])); ?> <?php $party_total = $party_total + getOtherPartyInventoryByProductAndBrand($product['id'],$product['product_brand_id']); ?> </td> <?php $__currentLoopData = $product_companies; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $product_company): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <td> <?php if(is_null(getPartyInventoryByProductAndBrand($product_company['id'],$product['id'],$product['product_brand_id'],$product_company['type']))): ?> 0 <?php else: ?> <?php echo e(getPartyInventoryByProductAndBrand($product_company['id'],$product['id'],$product['product_brand_id'],$product_company['type'])); ?> <?php $party_total = $party_total + getPartyInventoryByProductAndBrand($product_company['id'],$product['id'],$product['product_brand_id'],$product_company['type']); ?> <?php endif; ?> </td> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> <td><?php echo e($party_total); ?></td> <?php $warehouse_total = 0; ?> <?php $__currentLoopData = $warehouses; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $warehouse): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <?php $stock = \App\Inventory::where('warehouse_id',$warehouse->id)->sum('quantity'); ?> <?php if($stock > 0): ?> <td> <?php if(is_null(getInventory($product['product_brand_id'],$warehouse['id'],$product['id']))): ?> 0 <?php else: ?> <?php echo e(getInventory($product['product_brand_id'],$warehouse['id'],$product['id'])); ?> <?php $warehouse_total = $warehouse_total + getInventory($product['product_brand_id'],$warehouse['id'],$product['id']); ?> <?php endif; ?> </td> <?php endif; ?> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> <td><?php echo e($warehouse_total); ?></td> </tr> <?php endif; ?> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> <?php endif; ?> </tbody> </table> </div> </div></br> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> </div> </div> </div><!-- /.page-content --> </div> </div><!-- /.main-content --> <!-- 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")); ?> <script type="text/javascript"> jQuery(function($) { //initiate dataTables plugin var myTable = $('#dynamic-table').DataTable( { bAutoWidth: 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 /home/pmmsanvp/public_html/srtdev/resources/views/dashboard/inventory/daily-stock-report.blade.php ENDPATH**/ ?>