One Hat Cyber Team

Edit File: 779e6246e6c4cfd901949412d877f675.php

<?php $__env->startSection('page-title'); ?>
    <?php echo e(__('Payable Reports')); ?>

<?php $__env->stopSection(); ?>
<?php $__env->startSection('breadcrumb'); ?>
    <li class="breadcrumb-item"><a href="<?php echo e(route('dashboard')); ?>"><?php echo e(__('Dashboard')); ?></a></li>
    <li class="breadcrumb-item"><?php echo e(__('Payable Reports')); ?></li>
<?php $__env->stopSection(); ?>
<?php $__env->startPush('script-page'); ?>

function saveAsPDF() {
            var printContents = document.getElementById('printableArea').innerHTML;
            var originalContents = document.body.innerHTML;
            document.body.innerHTML = printContents;
            window.print();
            document.body.innerHTML = originalContents;
        }
    </script>

function callback() {
                var start_date = $(".startDate").val();
                var end_date = $(".endDate").val();

$('.start_date').val(start_date);
                $('.end_date').val(end_date);
            }
        });
    </script>

$("ul.nav-pills > li > a").click(function() {
                var report = $(this).attr('href');
                $('.report').val(report);
            });
        });
    </script>
<?php $__env->stopPush(); ?>

<?php $__env->startSection('action-btn'); ?>
<div class="float-end">
    <a href="#" onclick="saveAsPDF()" class="btn btn-sm btn-primary me-1" data-bs-toggle="tooltip"
        title="<?php echo e(__('Print')); ?>" data-original-title="<?php echo e(__('Print')); ?>"><i class="ti ti-printer"></i></a>
</div>

<?php $__env->stopSection(); ?>

<?php $__env->startSection('content'); ?>
    <div class="mt-4">
        <div class="row justify-content-center">
            <div class="col-md-12">
                <div class="mt-2" id="multiCollapseExample1">
                    <div class="card" id="show_filter" style="display:none;">
                        <div class="card-body">
                            <?php echo e(Form::open(['route' => ['report.payables'], 'method' => 'GET', 'id' => 'report_payable_summary'])); ?>

<div class="row align-items-center justify-content-end">
                                <div class="col-xl-10">
                                    <div class="row">
                                        <div class="col-xl-3 col-lg-3 col-md-6 col-sm-12 col-12">
                                            <div class="btn-box">
                                            </div>
                                        </div>
                                        <div class="col-xl-3 col-lg-3 col-md-6 col-sm-12 col-12">
                                            <div class="btn-box">
                                            </div>
                                        </div>
                                        <div class="col-xl-3 col-lg-3 col-md-6 col-sm-12 col-12">
                                            <div class="btn-box">
                                                <?php echo e(Form::label('start_date', __('Start Date'), ['class' => 'form-label'])); ?>

<?php echo e(Form::date('start_date', $filter['startDateRange'], ['class' => 'startDate form-control'])); ?>

</div>
                                        </div>

<div class="col-xl-3 col-lg-3 col-md-6 col-sm-12 col-12">
                                            <div class="btn-box">
                                                <?php echo e(Form::label('end_date', __('End Date'), ['class' => 'form-label'])); ?>

<?php echo e(Form::date('end_date', $filter['endDateRange'], ['class' => 'endDate form-control'])); ?>

</div>
                                        </div>
                                        <input type="hidden" name="report" class="report">
                                    </div>
                                </div>
                                <div class="col-auto mt-4">
                                    <div class="row">
                                        <div class="col-auto">
                                            <a href="#" class="btn btn-sm btn-primary"
                                                onclick="document.getElementById('report_payable_summary').submit(); return false;"
                                                data-bs-toggle="tooltip" title="<?php echo e(__('Apply')); ?>"
                                                data-original-title="<?php echo e(__('apply')); ?>">
                                                <span class="btn-inner--icon"><i class="ti ti-search"></i></span>
                                            </a>

<a href="<?php echo e(route('report.payables')); ?>" class="btn btn-sm btn-danger "
                                                data-bs-toggle="tooltip" title="<?php echo e(__('Reset')); ?>"
                                                data-original-title="<?php echo e(__('Reset')); ?>">
                                                <span class="btn-inner--icon"><i
                                                        class="ti ti-trash-off text-white-off "></i></span>
                                            </a>
                                        </div>

</div>
                                </div>
                            </div>
                        </div>
                        <?php echo e(Form::close()); ?>

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

<table class="table pc-dt-simple" id="report-vendor-balance">
                                        <thead>
                                            <tr>
                                                <th width="33%"> <?php echo e(__('Vendor Name')); ?></th>
                                                <th width="33%"> <?php echo e(__('Billed Amount')); ?></th>
                                                <th width="33%"> <?php echo e(__('Available Debit')); ?></th>
                                                <th class="text-end"> <?php echo e(__('Closing Balance')); ?></th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                                $mergedArray = [];
                                                foreach ($payableVendors as $item) {
                                                    $name = $item['name'];
                                                
                                                    if (!isset($mergedArray[$name])) {
                                                        $mergedArray[$name] = [
                                                            'name' => $name,
                                                            'price' => 0.0,
                                                            'pay_price' => 0.0,
                                                            'total_tax' => 0.0,
                                                            'debit_price' => 0.0,
                                                        ];
                                                    }
                                                
                                                    $mergedArray[$name]['price'] += floatval($item['price']);
                                                    if ($item['pay_price'] !== null) {
                                                        $mergedArray[$name]['pay_price'] += floatval($item['pay_price']);
                                                    }
                                                    $mergedArray[$name]['total_tax'] += floatval($item['total_tax']);
                                                    $mergedArray[$name]['debit_price'] += floatval($item['debit_price']);
                                                }
                                                $resultArray = array_values($mergedArray);
                                                $total = 0;
                                            ?>
                                            <?php $__currentLoopData = $resultArray; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $receivableCustomer): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
                                                <tr>
                                                    <?php
                                                        $customerBalance = $receivableCustomer['price'] + $receivableCustomer['total_tax'] - $receivableCustomer['pay_price'];
                                                        $balance = $customerBalance - $receivableCustomer['debit_price'];
                                                        $total += $balance;
                                                    ?>
                                                    <td> <?php echo e($receivableCustomer['name']); ?></td>
                                                    <td> <?php echo e(\Auth::user()->priceFormat($customerBalance)); ?> </td>
                                                    <td> <?php echo e(!empty($receivableCustomer['debit_price']) ? \Auth::user()->priceFormat($receivableCustomer['debit_price']) : \Auth::user()->priceFormat(0)); ?>

</td>
                                                    <td class="text-end"> <?php echo e(\Auth::user()->priceFormat($balance)); ?> </td>
                                                </tr>
                                            <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
                                            <?php if($payableVendors != []): ?>
                                                <tr>
                                                    <th><?php echo e(__('Total')); ?></th>
                                                    <td></td>
                                                    <td></td>
                                                    <th class="text-end"><?php echo e(\Auth::user()->priceFormat($total)); ?></th>
                                                </tr>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>
                                </div>
                                <div class="tab-pane fade fade show" id="payable_summary" role="tabpanel"
                                    aria-labelledby="payable-tab2">
                                    <div class="table-responsive">

<table class="table pc-dt-simple" id="report-payable-summary">
                                        <thead>
                                            <tr>
                                                <th><?php echo e(__('Vendor Name')); ?></th>
                                                <th><?php echo e(__('Date')); ?></th>
                                                <th><?php echo e(__('Transaction')); ?></th>
                                                <th><?php echo e(__('Status')); ?></th>
                                                <th><?php echo e(__('Transaction Type')); ?></th>
                                                <th><?php echo e(__('Total')); ?></th>
                                                <th><?php echo e(__('Balance')); ?></th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                                $total = 0;
                                                $totalAmount = 0;
                                                
                                                function compare($a, $b)
                                                {
                                                    return strtotime($b['bill_date']) - strtotime($a['bill_date']);
                                                }
                                                usort($payableSummaries, 'compare');
                                            ?>
                                            <?php $__currentLoopData = $payableSummaries; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $payableSummary): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
                                                <tr>
                                                    <?php
                                                        if ($payableSummary['bill']) {
                                                            $payableBalance = $payableSummary['price'] + $payableSummary['total_tax'];
                                                        } else {
                                                            $payableBalance = -$payableSummary['price'];
                                                        }
                                                        $pay_price = ($payableSummary['pay_price'] != null) ? $payableSummary['pay_price'] : 0;
                                                        $balance = $payableBalance - $pay_price;
                                                        $total += $balance;
                                                        $totalAmount += $payableBalance;
                                                    ?>
                                                    <td> <?php echo e($payableSummary['name']); ?></td>
                                                    <td> <?php echo e($payableSummary['bill_date']); ?></td>
                                                    <?php if($payableSummary['bill']): ?>
                                                        <?php if($payableSummary['type'] == 'Bill'): ?>
                                                            <td> <?php echo e(\Auth::user()->billNumberFormat($payableSummary['bill'])); ?>

</td>
                                                        <?php elseif($payableSummary['type'] == 'Expense'): ?>
                                                            <td> <?php echo e(\Auth::user()->expenseNumberFormat($payableSummary['bill'])); ?>

</td>
                                                        <?php endif; ?>
                                                        <?php else: ?>
                                                        <td><?php echo e(__('Debit Note')); ?></td>
                                                    <?php endif; ?>
                                                    </td>
                                                    <td>
                                                        <?php if($payableSummary['status'] == 0): ?>
                                                            <span
                                                                class="status_badge badge bg-secondary p-2 px-3 rounded"><?php echo e(__(\App\Models\Invoice::$statues[$payableSummary['status']])); ?></span>
                                                        <?php elseif($payableSummary['status'] == 1): ?>
                                                            <span
                                                                class="status_badge badge bg-warning p-2 px-3 rounded"><?php echo e(__(\App\Models\Invoice::$statues[$payableSummary['status']])); ?></span>
                                                        <?php elseif($payableSummary['status'] == 2): ?>
                                                            <span
                                                                class="status_badge badge bg-danger p-2 px-3 rounded"><?php echo e(__(\App\Models\Invoice::$statues[$payableSummary['status']])); ?></span>
                                                        <?php elseif($payableSummary['status'] == 3): ?>
                                                            <span
                                                                class="status_badge badge bg-info p-2 px-3 rounded"><?php echo e(__(\App\Models\Invoice::$statues[$payableSummary['status']])); ?></span>
                                                        <?php elseif($payableSummary['status'] == 4): ?>
                                                            <span
                                                                class="status_badge badge bg-primary p-2 px-3 rounded"><?php echo e(__(\App\Models\Invoice::$statues[$payableSummary['status']])); ?></span>
                                                        <?php else: ?>
                                                            <span class="p-2 px-3">-</span>
                                                        <?php endif; ?>
                                                    </td>
                                                    <?php if($payableSummary['bill']): ?>
                                                        <td> <?php echo e($payableSummary['type']); ?>

<?php else: ?>
                                                        <td><?php echo e(__('Debit Note')); ?></td>
                                                    <?php endif; ?>
                                                    <td> <?php echo e(\Auth::user()->priceFormat($payableBalance)); ?> </td>

<td> <?php echo e(\Auth::user()->priceFormat($balance)); ?> </td>

</td>
                                                </tr>
                                            <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
                                            <?php if($payableSummaries != []): ?>
                                                <tr>
                                                    <th><?php echo e(__('Total')); ?></th>
                                                    <th></th>
                                                    <th></th>
                                                    <th></th>
                                                    <th></th>
                                                    <th><?php echo e(\Auth::user()->priceFormat($totalAmount)); ?></th>
                                                    <th><?php echo e(\Auth::user()->priceFormat($total)); ?></th>
                                                </tr>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>
                                </div>
                                
                                <div class="tab-pane fade fade show" id="payable_details" role="tabpanel"
                                    aria-labelledby="payable-tab3">
                                    <div class="table-responsive">

<table class="table pc-dt-simple" id="report-payable-details">
                                        <thead>
                                            <tr>
                                                <th><?php echo e(__('Vendor Name')); ?></th>
                                                <th><?php echo e(__('Date')); ?></th>
                                                <th><?php echo e(__('Transaction')); ?></th>
                                                <th><?php echo e(__('Status')); ?></th>
                                                <th><?php echo e(__('Transaction Type')); ?></th>
                                                <th><?php echo e(__('Item Name')); ?></th>
                                                <th><?php echo e(__('Quantity Ordered')); ?></th>
                                                <th><?php echo e(__('Item Price')); ?></th>
                                                <th><?php echo e(__('Total')); ?></th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                                $total = 0;
                                                $totalQuantity = 0;
                                                
                                                function compares($a, $b)
                                                {
                                                    return strtotime($b['bill_date']) - strtotime($a['bill_date']);
                                                }
                                                usort($payableDetails, 'compares');
                                            ?>
                                            <?php $__currentLoopData = $payableDetails; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $payableDetail): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
                                                <tr>
                                                    <?php
                                                        if ($payableDetail['bill']) {
                                                            $receivableBalance = $payableDetail['price'];
                                                        } else {
                                                            $receivableBalance = -$payableDetail['price'];
                                                        }
                                                        if ($payableDetail['bill']) {
                                                            $quantity = $payableDetail['quantity'];
                                                        }
                                                        else {
                                                            $quantity = 0;
                                                        }

if ($payableDetail['bill']) {
                                                            $itemTotal = $receivableBalance * $payableDetail['quantity'];
                                                        } else {
                                                            $itemTotal = -$payableDetail['price'];
                                                        }                                                        
                                                        $total += $itemTotal;
                                                        $totalQuantity += $quantity;
                                                    ?>
                                                    <td> <?php echo e($payableDetail['name']); ?></td>
                                                    <td> <?php echo e($payableDetail['bill_date']); ?></td>
                                                    <?php if($payableDetail['bill']): ?>
                                                        <?php if($payableDetail['type'] == 'Bill'): ?>
                                                            <td> <?php echo e(\Auth::user()->billNumberFormat($payableDetail['bill'])); ?>

</td>
                                                        <?php elseif($payableDetail['type'] == 'Expense'): ?>
                                                            <td> <?php echo e(\Auth::user()->expenseNumberFormat($payableDetail['bill'])); ?>

</td>
                                                        <?php endif; ?>
                                                        <?php else: ?>
                                                        <td><?php echo e(__('Debit Note')); ?></td>
                                                    <?php endif; ?>
                                                    </td>
                                                    <td>
                                                        <?php if($payableDetail['status'] == 0): ?>
                                                            <span
                                                                class="status_badge badge bg-secondary p-2 px-3 rounded"><?php echo e(__(\App\Models\Invoice::$statues[$payableDetail['status']])); ?></span>
                                                        <?php elseif($payableDetail['status'] == 1): ?>
                                                            <span
                                                                class="status_badge badge bg-warning p-2 px-3 rounded"><?php echo e(__(\App\Models\Invoice::$statues[$payableDetail['status']])); ?></span>
                                                        <?php elseif($payableDetail['status'] == 2): ?>
                                                            <span
                                                                class="status_badge badge bg-danger p-2 px-3 rounded"><?php echo e(__(\App\Models\Invoice::$statues[$payableDetail['status']])); ?></span>
                                                        <?php elseif($payableDetail['status'] == 3): ?>
                                                            <span
                                                                class="status_badge badge bg-info p-2 px-3 rounded"><?php echo e(__(\App\Models\Invoice::$statues[$payableDetail['status']])); ?></span>
                                                        <?php elseif($payableDetail['status'] == 4): ?>
                                                            <span
                                                                class="status_badge badge bg-primary p-2 px-3 rounded"><?php echo e(__(\App\Models\Invoice::$statues[$payableDetail['status']])); ?></span>
                                                        <?php else: ?>
                                                            <span
                                                                class="p-2 px-3">-</span>
                                                        <?php endif; ?>
                                                    </td>
                                                    <?php if($payableDetail['bill']): ?>
                                                        <td> <?php echo e($payableDetail['type']); ?>

<?php else: ?>
                                                        <td><?php echo e(__('Debit Note')); ?></td>
                                                    <?php endif; ?>
                                                    <td><?php echo e($payableDetail['product_name']); ?></td>
                                                    <td> <?php echo e($quantity); ?></td>
                                                    <td><?php echo e(\Auth::user()->priceFormat($receivableBalance)); ?></td>
                                                    <td><?php echo e(\Auth::user()->priceFormat($itemTotal)); ?></td>

</tr>
                                            <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
                                            <?php if($payableDetails != []): ?>
                                                <tr>
                                                    <th><?php echo e(__('Total')); ?></th>
                                                    <th></th>
                                                    <th></th>
                                                    <th></th>
                                                    <th></th>
                                                    <th></th>
                                                    <th><?php echo e($totalQuantity); ?></th>
                                                    <th></th>
                                                    <th><?php echo e(\Auth::user()->priceFormat($total)); ?></th>
                                                </tr>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
<?php $__env->stopSection(); ?>

<?php echo $__env->make('layouts.admin', \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))->render(); ?><?php /**PATH /var/www/html/resources/views/report/payable_report.blade.php ENDPATH**/ ?>