• File: _statement.php
  • Full Path: /var/www/crm_set/application/views/admin/clients/groups/_statement.php
  • Date Modified: 09/21/2026 4:19 AM
  • File size: 6.94 KB
  • MIME-type: text/x-php
  • Charset: utf-8
<?php defined('BASEPATH') or exit('No direct script access allowed'); ?>
<div class="col-md-5">
    <div class="text-right">
        <h4 class="no-margin bold"><?php echo _l('account_summary'); ?></h4>
        <p class="text-muted"><?php echo _l('statement_from_to', [$from, $to]); ?></p>
        <hr />
        <table class="table statement-account-summary">
            <tbody>
                <tr>
                    <td class="text-left"><?php echo _l('statement_beginning_balance'); ?>:</td>
                    <td><?php echo app_format_money($statement['beginning_balance'], $statement['currency']); ?></td>
                </tr>
                <tr>
                    <td class="text-left"><?php echo _l('invoiced_amount'); ?>:</td>
                    <td><?php echo app_format_money($statement['invoiced_amount'], $statement['currency']); ?></td>
                </tr>
                <tr>
                    <td class="text-left"><?php echo _l('amount_paid'); ?>:</td>
                    <td><?php echo app_format_money($statement['amount_paid'], $statement['currency']); ?></td>
                </tr>
            </tbody>
            <tfoot>
                <tr>
                    <td class="text-left"><b><?php echo _l('balance_due'); ?></b>:</td>
                    <td><?php echo app_format_money($statement['balance_due'], $statement['currency']); ?></td>
                </tr>
            </tfoot>
        </table>
    </div>
</div>
<div class="col-md-12">
    <div class="text-center bold padding-10">
        <?php echo _l('customer_statement_info', [$from, $to]); ?>
    </div>
    <div class="table-responsive">
        <table class="table table-bordered table-striped">
            <thead>
                <tr>
                    <th><b><?php echo _l('statement_heading_date'); ?></b></th>
                    <th><b><?php echo _l('statement_heading_details'); ?></b></th>
                    <th class="text-right"><b><?php echo _l('statement_heading_amount'); ?></b></th>
                    <th class="text-right"><b><?php echo _l('statement_heading_payments'); ?></b></b></th>
                    <th class="text-right"><b><?php echo _l('statement_heading_balance'); ?></b></b></th>
                </tr>
            </thead>
            <tbody>
                <tr>
                    <td><?php echo $from; ?></td>
                    <td><?php echo _l('statement_beginning_balance'); ?></td>
                    <td class="text-right">
                        <?php echo app_format_money($statement['beginning_balance'], $statement['currency'], true); ?>
                    </td>
                    <td></td>
                    <td class="text-right">
                        <?php echo app_format_money($statement['beginning_balance'], $statement['currency'], true); ?>
                    </td>
                </tr>
                <?php
       $tmpBeginningBalance = $statement['beginning_balance'];
       foreach ($statement['result'] as $data) { ?>
                <tr>
                    <td><?php echo _d($data['date']); ?></td>
                    <td>
                        <?php
            if (isset($data['invoice_id'])) {
                echo _l('statement_invoice_details', ['<a href="' . admin_url('invoices/list_invoices/' . $data['invoice_id']) . '" target="_blank">' . format_invoice_number($data['invoice_id']) . '</a>', _d($data['duedate'])]);
            } elseif (isset($data['payment_id'])) {
                echo _l('statement_payment_details', ['<a href="' . admin_url('payments/payment/' . $data['payment_id']) . '" target="_blank">' . '#' . $data['payment_id'] . '</a>', format_invoice_number($data['payment_invoice_id'])]);
            } elseif (isset($data['credit_note_id'])) {
                echo _l('statement_credit_note_details', ['<a href="' . admin_url('credit_notes/list_credit_notes/' . $data['credit_note_id']) . '" target="_blank">' . format_credit_note_number($data['credit_note_id']) . '</a>']);
            } elseif (isset($data['credit_id'])) {
                echo _l(
                    'statement_credits_applied_details',
                    [
              '<a href="' . admin_url('credit_notes/list_credit_notes/' . $data['credit_applied_credit_note_id']) . '" target="_blank">' . format_credit_note_number($data['credit_applied_credit_note_id']) . '</a>',
              app_format_money($data['credit_amount'], $statement['currency'], true),
              format_invoice_number($data['credit_invoice_id']),
            ]
                );
            } elseif (isset($data['credit_note_refund_id'])) {
                echo _l('statement_credit_note_refund', format_credit_note_number($data['refund_credit_note_id']));
            }
          ?>
                    </td>
                    <td class="text-right">
                        <?php
          if (isset($data['invoice_id'])) {
              echo app_format_money($data['invoice_amount'], $statement['currency'], true);
          } elseif (isset($data['credit_note_id'])) {
              echo app_format_money($data['credit_note_amount'], $statement['currency'], true);
          }
          ?>
                    </td>
                    <td class="text-right">
                        <?php
          if (isset($data['payment_id'])) {
              echo app_format_money($data['payment_total'], $statement['currency'], true);
          } elseif (isset($data['credit_note_refund_id'])) {
              echo app_format_money($data['refund_amount'], $statement['currency'], true);
          }
          ?>
                    </td>
                    <td class="text-right">
                        <?php
          if (isset($data['invoice_id'])) {
              $tmpBeginningBalance = ($tmpBeginningBalance + $data['invoice_amount']);
          } elseif (isset($data['payment_id'])) {
              $tmpBeginningBalance = ($tmpBeginningBalance - $data['payment_total']);
          } elseif (isset($data['credit_note_id'])) {
              $tmpBeginningBalance = ($tmpBeginningBalance - $data['credit_note_amount']);
          } elseif (isset($data['credit_note_refund_id'])) {
              $tmpBeginningBalance = ($tmpBeginningBalance + $data['refund_amount']);
          }
          if (!isset($data['credit_id'])) {
              echo app_format_money($tmpBeginningBalance, $statement['currency'], true);
          }
          ?>
                    </td>
                </tr>
                <?php } ?>
            </tbody>
            <tfoot class="statement_tfoot">
                <tr>
                    <td colspan="3" class="text-right">
                        <b><?php echo _l('balance_due'); ?></b>
                    </td>
                    <td class="text-right" colspan="2">
                        <b><?php echo app_format_money($statement['balance_due'], $statement['currency']); ?></b>
                    </td>
                </tr>
            </tfoot>
        </table>
    </div>
</div>