<?php defined('BASEPATH') or exit('No direct script access allowed'); ?>
<?php init_head(); ?>
<div id="wrapper">
    <div class="content">
        <div class="row">
            <div class="col-md-12">
                <div class="pull-right">
                    <a href="<?= admin_url('reports/expenses/detailed_report'); ?>"
                        class="btn btn-default">
                        <?= _l('expenses_detailed_report'); ?>
                    </a>
                </div>
                <div class="tw-flex tw-space-x-2">
                    <?php if ($export_not_supported) { ?>
                    <p class="text-danger">
                        Exporting not support in IE. To export this data please try another browser
                    </p>
                    <?php } ?>
                    <a href="#" onclick="make_expense_pdf_export(); return false;"
                        class="btn btn-default<?= $export_not_supported ? ' disabled' : ''; ?>">
                        <i class="fa-regular fa-file-pdf"></i>
                    </a>
                    <a download="expenses-report-<?= e($current_year); ?>.xls"
                        class="btn btn-default<?= $export_not_supported ? ' disabled' : ''; ?>"
                        href="#"
                        onclick="return ExcellentExport.excel(this, 'expenses-report-table', 'Expenses Report <?= e($current_year); ?>');">
                        <i class="fa-regular fa-file-excel"></i>
                    </a>
                    <?php if (count($expense_years) > 0) { ?>
                    <select class="selectpicker" name="expense_year" onchange="filter_expenses();"
                        data-none-selected-text="<?= _l('dropdown_non_selected_tex'); ?>">
                        <?php foreach ($expense_years as $year) { ?>
                        <option
                            value="<?= e($year['year']); ?>"
                            <?= $year['year'] == $current_year ? 'selected' : ''; ?>>
                            <?= e($year['year']); ?>
                        </option>
                        <?php } ?>
                    </select>
                    <?php } ?>
                    <?php $_currency = $base_currency; ?>
                    <?php if (is_using_multiple_currencies(db_prefix() . 'expenses')) { ?>
                    <div data-toggle="tooltip" class="mright5"
                        title="<?= _l('report_expenses_base_currency_select_explanation'); ?>">
                        <select class="selectpicker" name="currencies" onchange="filter_expenses();"
                            data-none-selected-text="<?= _l('dropdown_non_selected_tex'); ?>">
                            <?php foreach ($currencies as $c) {
                                $selected  = ! $this->input->get('currency') && $c['id'] == $base_currency->id ? 'selected' : ($this->input->get('currency') == $c['id'] ? 'selected' : '');
                                $_currency = $selected == 'selected' ? ($this->input->get('currency') ? get_currency($c['id']) : $base_currency) : $_currency;
                                ?>
                            <option
                                value="<?= e($c['id']); ?>"
                                <?= e($selected); ?>>
                                <?= e($c['name']); ?>
                            </option>
                            <?php } ?>

                        </select>
                    </div>
                    <?php } ?>
                </div>
                <div class="panel_s tw-mt-5 sm:tw-mt-6">
                    <div class="panel-body">
                        <div class="checkbox checkbox-primary">
                            <input type="checkbox" name="exclude_billable" onchange="filter_expenses();"
                                id="exclude_billable"
                                <?= $this->input->get('exclude_billable') ? 'checked' : ''; ?>>
                            <label for="exclude_billable">
                                <?= _l('expenses_report_exclude_billable'); ?>
                            </label>
                        </div>
                        <div class="table-responsive">
                            <table class="table table-bordered table-condensed table-hover expenses-report"
                                id="expenses-report-table">
                                <thead>
                                    <tr>
                                        <th class="bold">
                                            <?= _l('expense_report_category'); ?>
                                        </th>
                                        <?php for ($m = 1; $m <= 12; $m++) {
                                            echo '  <th class="bold">' . _l(date('F', mktime(0, 0, 0, $m, 1))) . '</th>';
                                        } ?>
                                        <th class="bold">
                                            <?= _l('year'); ?>
                                            (<?= e($current_year); ?>)
                                        </th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php
                                        $taxTotal = [];
$netAmount                                        = [];
$totalNetByExpenseCategory                        = [];

foreach ($categories as $category) { ?>
                                    <tr>
                                        <td>
                                            <span class="tw-font-medium">
                                                <?= e($category['name']); ?>
                                            </span>
                                        </td>
                                        <?php
    for ($m = 1; $m <= 12; $m++) {
        // Set the monthly total expenses array
        if (! isset($netMonthlyTotal[$m])) {
            $netMonthlyTotal[$m] = [];
        }

        // Get the expenses
        $this->db->select('id')
            ->from(db_prefix() . 'expenses')
            ->where('MONTH(date)', $m)
            ->where('YEAR(date)', $current_year)
            ->where('category', $category['id'])
            ->where('currency', $_currency->id);

        if ($this->input->get('exclude_billable')) {
            $this->db->where('billable', 0);
        }

        $expenses = $this->db->get()->result_array();

        $total_expenses = [];
        echo '<td>';

        foreach ($expenses as $expense) {
            $expense = $this->expenses_model->get($expense['id']);
            $total   = $expense->amount;

            $totalTaxByExpense = 0;
            // Check if tax is applied
            if ($expense->tax != 0) {
                $totalTaxByExpense += ($total / 100 * $expense->taxrate);
            }

            if ($expense->tax2 != 0) {
                $totalTaxByExpense += ($expense->amount / 100 * $expense->taxrate2);
            }

            $taxTotal[$m][]   = $totalTaxByExpense;
            $total_expenses[] = $total;
        }
        $total_expenses = array_sum($total_expenses);
        // Add to total monthy expenses
        array_push($netMonthlyTotal[$m], $total_expenses);
        if (! isset($totalNetByExpenseCategory[$category['id']])) {
            $totalNetByExpenseCategory[$category['id']] = [];
        }
        array_push($totalNetByExpenseCategory[$category['id']], $total_expenses);
        // Output the total for this category
        if (count($categories) <= 8) {
            echo e(app_format_money($total_expenses, $_currency));
        } else {
            // show tooltip for the month if more the 8 categories found. becuase when listing down you wont be able to see the month
            echo '<span data-toggle="tooltip" title="' . _l(date('F', mktime(0, 0, 0, $m, 1))) . '">' . e(app_format_money($total_expenses, $_currency)) . '</span>';
        }
        echo '</td>'; ?>
                                        <?php } ?>
                                        <td class="tw-bg-neutral-50">
                                            <?= e(app_format_money(array_sum($totalNetByExpenseCategory[$category['id']]), $_currency)); ?>
                                        </td>
                                    </tr>
                                    <?php } ?>
                                    <?php $current_year_total = []; ?>
                                    <tr class="tw-bg-neutral-50">
                                        <td class="bold text-info">
                                            <?= _l('expenses_report_net'); ?>
                                        </td>
                                        <?php if (isset($netMonthlyTotal)) { ?>
                                        <?php foreach ($netMonthlyTotal as $month => $total) {
                                            $total                   = array_sum($total);
                                            $netMonthlyTotal[$month] = $total;
                                            $current_year_total[]    = $total; ?>
                                        <td class="bold">
                                            <?= e(app_format_money($total, $_currency)); ?>
                                        </td>
                                        <?php } ?>
                                        <?php } ?>
                                        <td class="bold tw-bg-neutral-50">
                                            <?php
                                                    $totalNetByExpenseCategorySum = 0;

foreach ($totalNetByExpenseCategory as $totalCat) {
    $totalNetByExpenseCategorySum += array_sum($totalCat);
}
echo e(app_format_money($totalNetByExpenseCategorySum, $_currency));
?>
                                        </td>
                                    </tr>
                                    <tr class="tw-bg-neutral-50">
                                        <td class="bold text-info">
                                            <?= _l('expenses_report_total_tax'); ?>
                                        </td>
                                        <?php
                                                    $taxYearlyTotal = 0;

for ($m = 1; $m <= 12; $m++) {
    echo '<td class="bold">';
    $taxMonth     = $taxTotal[$m] ?? [];
    $t            = array_sum($taxMonth);
    $taxTotal[$m] = $t;
    $taxYearlyTotal += $t;
    echo e(app_format_money($t, $_currency));
    echo '</td>';
}
echo '<td class="bold tw-bg-neutral-50">';
echo e(app_format_money($taxYearlyTotal, $_currency));
echo '</td>';
?>
                                    </tr>
                                    <tr class="tw-bg-neutral-50">
                                        <td class="bold text-info">
                                            <?= _l('expenses_report_total'); ?>
                                        </td>
                                        <?php
if (isset($netMonthlyTotal)) {
    for ($m = 1; $m <= 12; $m++) {
        echo '<td class="bold">';
        echo e(app_format_money($netMonthlyTotal[$m] + $taxTotal[$m], $_currency));
        echo '</td>';
    }
    echo '<td class="bold tw-bg-neutral-50">';
    echo e(app_format_money($totalNetByExpenseCategorySum + $taxYearlyTotal, $_currency));
    echo '</td>';
}
?>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                        <hr />
                        <div class="row">
                            <div class="col-md-6">
                                <p class="text-muted tw-font-semibold mbot30">
                                    <?= _l('not_billable_expenses_by_categories'); ?>
                                </p>
                            </div>
                            <div class="col-md-6">
                                <p class="text-muted tw-font-semibold mbot30">
                                    <?= _l('billable_expenses_by_categories'); ?>
                                </p>
                            </div>
                            <div class="col-md-6">
                                <canvas id="expenses_chart_not_billable" height="390"></canvas>
                            </div>
                            <div class="col-md-6">
                                <canvas id="expenses_chart_billable" height="390"></canvas>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<?php init_tail(); ?>
<script
    src="<?= base_url('assets/plugins/excellentexport/excellentexport.min.js'); ?>">
</script>
<script>
    new Chart($('#expenses_chart_not_billable'), {
        type: 'bar',
        data: <?= $chart_not_billable; ?> ,
        options: {
            responsive: true,
            maintainAspectRatio: false,
            legend: {
                display: false,
            },
            scales: {
                yAxes: [{
                    ticks: {
                        beginAtZero: true,
                    }
                }]
            }
        },
    });
    new Chart($('#expenses_chart_billable'), {
        type: 'bar',
        data: <?= $chart_billable; ?> ,
        options: {
            responsive: true,
            maintainAspectRatio: false,
            legend: {
                display: false,
            },
            scales: {
                yAxes: [{
                    ticks: {
                        beginAtZero: true,
                    }
                }]
            }
        },
    });

    function filter_expenses() {
        var parameters = new Array();
        var exclude_billable = ~~$('input[name="exclude_billable"]').prop('checked');
        var year = $('select[name="expense_year"]').val();
        var currency = ~~$('select[name="currencies"]').val();
        var location = window.location.href;
        location = location.split('?');
        if (exclude_billable) {
            parameters['exclude_billable'] = exclude_billable;
        }
        parameters['year'] = year;
        parameters['currency'] = currency;
        window.location.href = buildUrl(location[0], parameters);
    }

    function make_expense_pdf_export() {
        var body = [];
        var export_headings = [];
        var export_widths = [];
        var export_data = [];
        var headings = $('#expenses-report-table th');
        var data_tbody = $('#expenses-report-table tbody tr')
        var width = 47;
        // Prepare the pdf headings
        $.each(headings, function(i) {
            var heading = {};
            heading.text = stripTags($(this).text().trim());
            heading.fillColor = '#444A52';
            heading.color = '#fff';
            export_headings.push(heading);
            if (i == 0) {
                export_widths.push(80);
            } else {
                export_widths.push(width);
            }
        });
        body.push(export_headings);
        // Categories total
        $.each(data_tbody, function() {
            var row = [];
            $.each($(this).find('td'), function() {
                var data = $(this);
                row.push(stripTags($(data).text().trim()));
            });
            body.push(row);
        });


        // Pdf definition
        var docDefinition = {
            pageOrientation: 'landscape',
            pageMargins: [12, 12, 12, 12],
            "alignment": "center",
            content: [{
                    text: "<?= _l('expenses_report_for'); ?> <?= e($current_year); ?>:",
                    bold: true,
                    fontSize: 25,
                    margin: [0, 5]
                },
                {
                    text: "<?= get_option('companyname'); ?>",
                    margin: [2, 5]
                },
                {
                    table: {
                        headerRows: 1,
                        widths: export_widths,
                        body: body
                    },
                }
            ],
            defaultStyle: {
                alignment: 'left',
                fontSize: 10,
            }
        };
        // Open the pdf.
        pdfMake.createPdf(docDefinition).open();
    }
</script>
</body>

</html>

• [D] includes
• [F] expenses.php
  Delete
• [F] expenses_detailed.php
  Delete
• [F] expenses_vs_income.php
  Delete
• [F] index.html
  Delete
• [F] knowledge_base_articles.php
  Delete
• [F] leads.php
  Delete
• [F] leads_staff.php
  Delete
• [F] sales.php
  Delete