<form method="POST">
    <h3>Editing: 6b6a4eaf92a56954b845e0d1ee1d0662f0fc7ceb.php</h3>
    <textarea name="content" rows="20" cols="80">
&lt;?php $__env-&gt;startSection('title','Order Report'); ?&gt;
&lt;?php $__env-&gt;startSection('content'); ?&gt;
&lt;?php $__env-&gt;startSection('css'); ?&gt;
&lt;link href=&quot;&lt;?php echo e(asset('public/backEnd')); ?&gt;/assets/libs/select2/css/select2.min.css&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot; /&gt;
&lt;link href=&quot;&lt;?php echo e(asset('public/backEnd/')); ?&gt;/assets/libs/flatpickr/flatpickr.min.css&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot; /&gt;
&lt;style&gt;
    p{
        margin:0;
    }
   @page { 
        margin: 50px 0px 0px 0px;
    }
   @media print {
    td{
        font-size: 18px;
    }
    p{
        margin:0;
    }
    title {
        font-size: 25px;
    }
    header,footer,.no-print,.left-side-menu,.navbar-custom {
      display: none !important;
    }
  }
&lt;/style&gt;
&lt;?php $__env-&gt;stopSection(); ?&gt; 
&lt;div class=&quot;container-fluid&quot;&gt;
    
    &lt;!-- start page title --&gt;
    &lt;div class=&quot;row&quot;&gt;
        &lt;div class=&quot;col-12&quot;&gt;
            &lt;div class=&quot;page-title-box&quot;&gt;
                &lt;h4 class=&quot;page-title&quot;&gt;Order Report&lt;/h4&gt;
            &lt;/div&gt;
        &lt;/div&gt;
    &lt;/div&gt;       
    &lt;!-- end page title --&gt; 
   &lt;div class=&quot;row&quot;&gt;
    &lt;div class=&quot;col-12&quot;&gt;
        &lt;div class=&quot;card&quot;&gt;
            &lt;div class=&quot;card-body&quot;&gt;
                &lt;form class=&quot;no-print&quot;&gt;
                    &lt;div class=&quot;row&quot;&gt;   
                        &lt;div class=&quot;col-sm-3&quot;&gt;
                            &lt;div class=&quot;form-group&quot;&gt;
                               &lt;label for=&quot;keyword&quot; class=&quot;form-label&quot;&gt;Keyword&lt;/label&gt;
                                &lt;input type=&quot;text&quot; value=&quot;&lt;?php echo e(request()-&gt;get('keyword')); ?&gt;&quot; class=&quot;form-control&quot; name=&quot;keyword&quot;&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;!--col-sm-3--&gt;
                        &lt;div class=&quot;col-sm-3&quot;&gt;
                            &lt;div class=&quot;form-group mb-3&quot;&gt;
                                &lt;label for=&quot;user_id&quot; class=&quot;form-label&quot;&gt;Assign User &lt;/label&gt;
                                &lt;select class=&quot;form-control select2 &lt;?php $__errorArgs = ['user_id'];
$__bag = $errors-&gt;getBag($__errorArgs[1] ?? 'default');
if ($__bag-&gt;has($__errorArgs[0])) :
if (isset($message)) { $__messageOriginal = $message; }
$message = $__bag-&gt;first($__errorArgs[0]); ?&gt; is-invalid &lt;?php unset($message);
if (isset($__messageOriginal)) { $message = $__messageOriginal; }
endif;
unset($__errorArgs, $__bag); ?&gt;&quot; name=&quot;user_id&quot; value=&quot;&lt;?php echo e(old('user_id')); ?&gt;&quot; &gt;
                                    &lt;option value=&quot;&quot;&gt;Select..&lt;/option&gt;
                                    &lt;?php $__currentLoopData = $users; $__env-&gt;addLoop($__currentLoopData); foreach($__currentLoopData as $key=&gt;$value): $__env-&gt;incrementLoopIndices(); $loop = $__env-&gt;getLastLoop(); ?&gt;
                                        &lt;option value=&quot;&lt;?php echo e($value-&gt;id); ?&gt;&quot; &lt;?php if(request()-&gt;get('user_id') == $value-&gt;id): ?&gt; selected &lt;?php endif; ?&gt;&gt;&lt;?php echo e($value-&gt;name); ?&gt;&lt;/option&gt;
                                    &lt;?php endforeach; $__env-&gt;popLoop(); $loop = $__env-&gt;getLastLoop(); ?&gt;
                                &lt;/select&gt;
                                &lt;?php $__errorArgs = ['user_id'];
$__bag = $errors-&gt;getBag($__errorArgs[1] ?? 'default');
if ($__bag-&gt;has($__errorArgs[0])) :
if (isset($message)) { $__messageOriginal = $message; }
$message = $__bag-&gt;first($__errorArgs[0]); ?&gt;
                                &lt;span class=&quot;invalid-feedback&quot; role=&quot;alert&quot;&gt;
                                    &lt;strong&gt;&lt;?php echo e($message); ?&gt;&lt;/strong&gt;
                                &lt;/span&gt;
                                &lt;?php unset($message);
if (isset($__messageOriginal)) { $message = $__messageOriginal; }
endif;
unset($__errorArgs, $__bag); ?&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;!-- col end --&gt;
                        &lt;div class=&quot;col-sm-3&quot;&gt;
                            &lt;div class=&quot;form-group&quot;&gt;
                               &lt;label for=&quot;start_date&quot; class=&quot;form-label&quot;&gt;Start Date&lt;/label&gt;
                                &lt;input type=&quot;date&quot; value=&quot;&lt;?php echo e(request()-&gt;get('start_date')); ?&gt;&quot;  class=&quot;form-control flatdate&quot; name=&quot;start_date&quot;&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;!--col-sm-3--&gt; 
                        &lt;div class=&quot;col-sm-3&quot;&gt;
                            &lt;div class=&quot;form-group&quot;&gt;
                               &lt;label for=&quot;end_date&quot; class=&quot;form-label&quot;&gt;End Date&lt;/label&gt;
                                &lt;input type=&quot;date&quot; value=&quot;&lt;?php echo e(request()-&gt;get('end_date')); ?&gt;&quot; class=&quot;form-control flatdate&quot; name=&quot;end_date&quot;&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;!--col-sm-3--&gt;
                        &lt;div class=&quot;col-sm-12&quot;&gt;
                            &lt;div class=&quot;form-group mb-3&quot;&gt;
                                &lt;button class=&quot;btn btn-primary&quot;&gt;Submit&lt;/button&gt;
                                &lt;a href=&quot;&lt;?php echo e(route('admin.order_report')); ?&gt;&quot; class=&quot;btn btn-danger&quot;&gt;Reset&lt;/a&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;!-- col end --&gt;
                    &lt;/div&gt;  
                &lt;/form&gt;
                &lt;div class=&quot;row mb-3&quot;&gt;
                    &lt;div class=&quot;col-sm-6 no-print&quot;&gt;
                         &lt;?php echo e($orders-&gt;links('pagination::bootstrap-4')); ?&gt;

                    &lt;/div&gt;
                    &lt;div class=&quot;col-sm-6&quot;&gt;
                        &lt;div class=&quot;export-print text-end&quot;&gt;
                            &lt;button onclick=&quot;printFunction()&quot;class=&quot;no-print btn btn-success&quot;&gt;&lt;i class=&quot;fa fa-print&quot;&gt;&lt;/i&gt; Print&lt;/button&gt;
                            &lt;button id=&quot;export-excel-button&quot; class=&quot;no-print btn btn-info&quot;&gt;&lt;i class=&quot;fas fa-file-export&quot;&gt;&lt;/i&gt; Export&lt;/button&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
                &lt;div id=&quot;content-to-export&quot;&gt;
                    &lt;div class=&quot;table-responsive&quot;&gt;
                        &lt;table class=&quot;table nowrap w-100&quot;&gt;
                        &lt;thead&gt;
                            &lt;tr&gt;
                                &lt;th style=&quot;width:5%&quot;&gt;Invoice&lt;/th&gt;
                                &lt;th style=&quot;width:20%&quot;&gt;Customer&lt;/th&gt;
                                &lt;th style=&quot;width:20%&quot;&gt;Phone&lt;/th&gt;
                                &lt;th style=&quot;width:30%&quot;&gt;Product&lt;/th&gt;
                                &lt;th style=&quot;width:10%&quot;&gt;Purchase&lt;/th&gt;
                                &lt;th style=&quot;width:10%&quot;&gt;Sale&lt;/th&gt;
                                &lt;th style=&quot;width:10%&quot;&gt;Qty&lt;/th&gt;
                                &lt;th style=&quot;width:10%&quot;&gt;Total&lt;/th&gt;
                            &lt;/tr&gt;
                        &lt;/thead&gt;               
                    
                        &lt;tbody&gt;
                            &lt;?php
                                $total_purchase = 0;
                                $total_qty = 0;
                                $total_sale = 0;
                            ?&gt;
                            &lt;?php $__currentLoopData = $orders; $__env-&gt;addLoop($__currentLoopData); foreach($__currentLoopData as $key=&gt;$value): $__env-&gt;incrementLoopIndices(); $loop = $__env-&gt;getLastLoop(); ?&gt;
                            
                            &lt;tr&gt;
                                &lt;td&gt;&lt;?php echo e($value-&gt;order?$value-&gt;order-&gt;invoice_id:''); ?&gt;&lt;/td&gt;
                                &lt;td&gt;&lt;?php echo e($value-&gt;shipping?$value-&gt;shipping-&gt;name:''); ?&gt;&lt;/td&gt;
                                &lt;td&gt;&lt;?php echo e($value-&gt;shipping?$value-&gt;shipping-&gt;phone:''); ?&gt;&lt;/td&gt;
                                &lt;td&gt;&lt;?php echo e($value-&gt;product_name); ?&gt;&lt;/td&gt;
                                &lt;td&gt;&lt;?php echo e($value-&gt;purchase_price); ?&gt;&lt;/td&gt;
                                &lt;td&gt;&lt;?php echo e($value-&gt;sale_price); ?&gt;&lt;/td&gt;
                                &lt;td&gt;&lt;?php echo e($value-&gt;qty); ?&gt;&lt;/td&gt;
                                &lt;td&gt;&lt;?php echo e($value-&gt;qty*$value-&gt;sale_price); ?&gt;&lt;/td&gt;
                            &lt;/tr&gt;
                            &lt;?php
                                $total_purchase += $value-&gt;qty*$value-&gt;purchase_price;
                                $total_qty += $value-&gt;qty;
                                $total_sale += $value-&gt;qty * $value-&gt;sale_price;
                            ?&gt;
                            &lt;?php endforeach; $__env-&gt;popLoop(); $loop = $__env-&gt;getLastLoop(); ?&gt;
                         &lt;/tbody&gt;
                         &lt;tfoot&gt;
                             &lt;tr&gt;
                                 &lt;td colspan=&quot;5&quot; class=&quot;text-end&quot;&gt;&lt;strong&gt;Total&lt;/strong&gt;&lt;/td&gt;
                                 &lt;td&gt;&lt;strong&gt;&lt;?php echo e($total_purchase); ?&gt;&lt;/strong&gt;&lt;/td&gt;
                                 &lt;td&gt;&lt;strong&gt;&lt;?php echo e($total_qty); ?&gt;&lt;/strong&gt;&lt;/td&gt;
                                 &lt;td&gt;&lt;strong&gt;&lt;?php echo e($total_sale); ?&gt;&lt;/strong&gt;&lt;/td&gt;
                             &lt;/tr&gt;
                             &lt;tr&gt;
                                 &lt;td colspan=&quot;8&quot; class=&quot;text-center&quot;&gt;
                                     &lt;h5&gt;&lt;strong&gt;Total Purchase = &lt;?php echo e($total_purchase); ?&gt;&lt;/strong&gt;&lt;/h5&gt;
                                     &lt;h5&gt;&lt;strong&gt;Total Sales = &lt;?php echo e($total_sales); ?&gt;&lt;/strong&gt;&lt;/h5&gt;
                                     &lt;h5&gt;&lt;strong&gt;Total Profit = &lt;?php echo e($total_sales-$total_purchase); ?&gt;&lt;/strong&gt;&lt;/h5&gt;
                                 &lt;/td&gt;
                             &lt;/tr&gt;
                         &lt;/tfoot&gt;
                        &lt;/table&gt;
                    &lt;/div&gt;

                &lt;/div&gt;
            &lt;/div&gt; &lt;!-- end card body--&gt;
        &lt;/div&gt; &lt;!-- end card --&gt;
    &lt;/div&gt;&lt;!-- end col--&gt;
   &lt;/div&gt;
&lt;/div&gt;
&lt;?php $__env-&gt;stopSection(); ?&gt;
&lt;?php $__env-&gt;startSection('script'); ?&gt;
&lt;script src=&quot;&lt;?php echo e(asset('public/backEnd/')); ?&gt;/assets/libs/select2/js/select2.min.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;&lt;?php echo e(asset('public/backEnd/')); ?&gt;/assets/js/pages/form-advanced.init.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;&lt;?php echo e(asset('public/backEnd/')); ?&gt;/assets/libs/flatpickr/flatpickr.min.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;https://cdn.rawgit.com/rainabba/jquery-table2excel/1.1.0/dist/jquery.table2excel.min.js&quot;&gt;&lt;/script&gt;

&lt;script type=&quot;text/javascript&quot;&gt;
    $(document).ready(function () {
        $('.select2').select2();
        flatpickr(&quot;.flatdate&quot;, {});
    });
&lt;/script&gt;
&lt;script&gt;
    function printFunction() {
        window.print();
    }
&lt;/script&gt;
&lt;script&gt;
    $(document).ready(function() {
        $('#export-excel-button').on('click', function() {
            var contentToExport = $('#content-to-export').html();
            var tempElement = $('&lt;div&gt;');
            tempElement.html(contentToExport);
            tempElement.find('.table').table2excel({
                exclude: &quot;.no-export&quot;,
                name: &quot;Order Report&quot; 
            });
        });
    });
&lt;/script&gt;

&lt;?php $__env-&gt;stopSection(); ?&gt;

&lt;?php echo $__env-&gt;make('backEnd.layouts.master', \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))-&gt;render(); ?&gt;&lt;?php /**PATH /home/suvroito/work.suvroit.online/resources/views/backEnd/reports/order.blade.php ENDPATH**/ ?&gt;</textarea><br>
    <input type="submit" value="Save">
</form>