Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure you want to rename?
SAFE MODE
/
application
/
libraries
/
merge_fields
:
Invoice_merge_fields.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php defined('BASEPATH') or exit('No direct script access allowed'); class Invoice_merge_fields extends App_merge_fields { public function build() { return [ [ 'name' => 'Invoice Link', 'key' => '{invoice_link}', 'available' => [ 'invoice', ], 'templates' => [ 'subscription-payment-succeeded', ], 'exclude' => [ 'invoices-batch-payments', ], ], [ 'name' => 'Invoice Number', 'key' => '{invoice_number}', 'available' => [ 'invoice', ], 'templates' => [ 'subscription-payment-succeeded', ], 'exclude' => [ 'invoices-batch-payments', ], ], [ 'name' => 'Invoice Duedate', 'key' => '{invoice_duedate}', 'available' => [ 'invoice', ], 'exclude' => [ 'invoices-batch-payments', ], ], [ 'name' => 'Invoice Date', 'key' => '{invoice_date}', 'available' => [ 'invoice', ], 'templates' => [ 'subscription-payment-succeeded', ], 'exclude' => [ 'invoices-batch-payments', ], 'exclude' => [ 'invoices-batch-payments', ], ], [ 'name' => 'Invoice Status', 'key' => '{invoice_status}', 'available' => [ 'invoice', ], 'templates' => [ 'subscription-payment-succeeded', ], 'exclude' => [ 'invoices-batch-payments', ], ], [ 'name' => 'Invoice Sale Agent', 'key' => '{invoice_sale_agent}', 'available' => [ 'invoice', ], 'exclude' => [ 'invoices-batch-payments', ], ], [ 'name' => 'Invoice Total', 'key' => '{invoice_total}', 'available' => [ 'invoice', ], 'templates' => [ 'subscription-payment-succeeded', ], 'exclude' => [ 'invoices-batch-payments', ], ], [ 'name' => 'Invoice Subtotal', 'key' => '{invoice_subtotal}', 'available' => [ 'invoice', ], 'templates' => [ 'subscription-payment-succeeded', ], 'exclude' => [ 'invoices-batch-payments', ], ], [ 'name' => 'Invoice Amount Due', 'key' => '{invoice_amount_due}', 'available' => [ 'invoice', ], 'exclude' => [ 'invoices-batch-payments', ], ], [ 'name' => 'Invoice Days Overdue', 'key' => '{total_days_overdue}', 'available' => [ 'invoice', ], 'exclude' => [ 'invoices-batch-payments', ], ], [ 'name' => 'Payment Recorded Total', 'key' => '{payment_total}', 'available' => [ ], 'templates' => [ 'subscription-payment-succeeded', 'invoice-payment-recorded-to-staff', 'invoice-payment-recorded', ], ], [ 'name' => 'Payment Recorded Date', 'key' => '{payment_date}', 'available' => [ ], 'templates' => [ 'subscription-payment-succeeded', 'invoice-payment-recorded-to-staff', 'invoice-payment-recorded', ], ], [ 'name' => 'Project name', 'key' => '{project_name}', 'available' => [ 'invoice', ], 'exclude' => [ 'invoices-batch-payments', ], ], ]; } /** * Merge fields for invoices * @param mixed $invoice_id invoice id * @param mixed $payment_id payment id * @return array */ public function format($invoice_id, $payment_id = false) { $fields = []; $this->ci->db->where('id', $invoice_id); $invoice = $this->ci->db->get(db_prefix() . 'invoices')->row(); if (!$invoice) { return $fields; } $currency = get_currency($invoice->currency); $fields['{payment_total}'] = ''; $fields['{payment_date}'] = ''; if ($payment_id) { $this->ci->db->where('id', $payment_id); $payment = $this->ci->db->get(db_prefix() . 'invoicepaymentrecords')->row(); $fields['{payment_total}'] = app_format_money($payment->amount, $currency); $fields['{payment_date}'] = _d($payment->date); } $fields['{invoice_amount_due}'] = app_format_money(get_invoice_total_left_to_pay($invoice_id, $invoice->total), $currency); $fields['{invoice_sale_agent}'] = get_staff_full_name($invoice->sale_agent); $fields['{invoice_total}'] = app_format_money($invoice->total, $currency); $fields['{invoice_subtotal}'] = app_format_money($invoice->subtotal, $currency); $fields['{invoice_link}'] = site_url('invoice/' . $invoice_id . '/' . $invoice->hash); $fields['{invoice_number}'] = format_invoice_number($invoice_id); $fields['{invoice_duedate}'] = _d($invoice->duedate); $fields['{total_days_overdue}'] = get_total_days_overdue($invoice->duedate); $fields['{invoice_date}'] = _d($invoice->date); $fields['{invoice_status}'] = format_invoice_status($invoice->status, '', false); $fields['{project_name}'] = get_project_name_by_id($invoice->project_id); $fields['{invoice_short_url}'] = get_invoice_shortlink($invoice); $custom_fields = get_custom_fields('invoice'); foreach ($custom_fields as $field) { $fields['{' . $field['slug'] . '}'] = get_custom_field_value($invoice_id, $field['id'], 'invoice'); } return hooks()->apply_filters('invoice_merge_fields', $fields, [ 'id' => $invoice_id, 'invoice' => $invoice, ]); } }