/home/edulekha/crm.edulekha.com/application/libraries/App_items_table.php
<?php
defined('BASEPATH') or exit('No direct script access allowed');
include_once APPPATH . 'libraries/App_items_table_template.php';
class App_items_table extends App_items_table_template
{
public function __construct($transaction, $type, $for = 'html', $admin_preview = false)
{
// Required
$this->type = strtolower($type);
$this->admin_preview = $admin_preview;
$this->for = $for;
$this->set_transaction($transaction);
$this->set_items($transaction->items);
parent::__construct();
}
/**
* Builds the actual table items rows preview
*
* @return string
*/
public function items()
{
$html = '';
$descriptionItemWidth = $this->get_description_item_width();
$regularItemWidth = $this->get_regular_items_width(6);
$customFieldsItems = $this->get_custom_fields_for_table();
$hasOptionalItems = $this->has_optional_items();
$items = $this->items;
$displayOptionableItemsCheckboxes = $this->can_update_optionable_items();
if ($this->for === 'pdf' && $hasOptionalItems) {
$items = collect($items)->filter(function ($item) {
return $item['is_optional'] == 0 || ($item['is_optional'] == 1 && $item['is_selected'] == 1);
})->values()->all();
}
if ($this->for == 'html') {
$descriptionItemWidth = $descriptionItemWidth - 5;
$regularItemWidth = $regularItemWidth - 5;
}
$i = 1;
foreach ($items as $item) {
$itemHTML = '';
// Open table row
$itemHTML .= '<tr' . $this->tr_attributes($item) . '>';
if ($hasOptionalItems && $displayOptionableItemsCheckboxes && $this->for === 'html' && ! $this->admin_preview) {
if ($item['is_optional'] == 1) {
$itemHTML .= '<td width="2%"><div class="checkbox"><input class="select-item" type="checkbox" ' . ($item['is_selected'] == 1 ? 'checked' : '') . ' id="select-' . $item['id'] . '" /><label for="select-' . $item['id'] . '" /></div></td>';
} else {
$itemHTML .= '<td width="2%"><div class="checkbox"><input type="checkbox" id="select-' . $item['id'] . '" checked disabled /><label for="select-' . $item['id'] . '" /></div></td>';
}
}
// Table data number
$itemHTML .= '<td' . $this->td_attributes() . ' align="center" width="5%">' . $i . '</td>';
$itemHTML .= '<td class="description" align="left;" width="' . $descriptionItemWidth . '%">';
/**
* Item description
*/
if (! empty($item['description'])) {
$itemHTML .= '<span style="font-size:' . $this->get_pdf_font_size() . 'px;"><strong>'
. e($this->period_merge_field($item['description']))
. '</strong></span>';
if (! empty($item['long_description'])) {
$itemHTML .= '<br />';
}
}
/**
* Item long description
*/
if (! empty($item['long_description'])) {
$itemHTML .= '<span style="color:#424242;">' . process_text_content_for_display($this->period_merge_field($item['long_description'])) . '</span>';
}
$itemHTML .= '</td>';
/**
* Item custom fields
*/
foreach ($customFieldsItems as $custom_field) {
$itemHTML .= '<td align="left" width="' . $regularItemWidth . '%">' . get_custom_field_value($item['id'], $custom_field['id'], 'items') . '</td>';
}
/**
* Item quantity
*/
$itemHTML .= '<td align="right" width="' . $regularItemWidth . '%">' . e(floatval($item['qty']));
/**
* Maybe item has added unit?
*/
if ($item['unit']) {
$itemHTML .= ' ' . e($item['unit']);
}
$itemHTML .= '</td>';
/**
* Item rate
*
* @var string
*/
$rate = hooks()->apply_filters(
'item_preview_rate',
app_format_money($item['rate'], $this->transaction->currency_name, $this->exclude_currency()),
['item' => $item, 'transaction' => $this->transaction]
);
$itemHTML .= '<td align="right" width="' . $regularItemWidth . '%">' . e($rate) . '</td>';
/**
* Items table taxes HTML custom function because it's too general for all features/options
*
* @var string
*/
$itemHTML .= $this->taxes_html($item, $regularItemWidth);
/**
* Possible action hook user to include tax in item total amount calculated with the quantiy
* eq Rate * QTY + TAXES APPLIED
*/
$item_amount_with_quantity = hooks()->apply_filters(
'item_preview_amount_with_currency',
app_format_money(($item['qty'] * $item['rate']), $this->transaction->currency_name, $this->exclude_currency()),
$item,
$this->transaction,
$this->exclude_currency()
);
$itemHTML .= '<td class="amount" align="right" width="' . $regularItemWidth . '%">' . e($item_amount_with_quantity) . '</td>';
// Close table row
$itemHTML .= '</tr>';
$html .= $itemHTML;
$i++;
}
return $html;
}
/**
* Html headings preview
*
* @return string
*/
public function html_headings()
{
$html = '<tr>';
if ($this->for === 'html' && ! $this->admin_preview && $this->has_optional_items() && $this->can_update_optionable_items()) {
$html .= '<th style="text-align:center;"><span style="opacity:0.2;">-</span></th>';
}
$html .= '<th align="center">' . $this->number_heading() . '</th>';
$html .= '<th class="description" width="' . $this->get_description_item_width() . '%" align="left">' . $this->item_heading() . '</th>';
$customFieldsItems = $this->get_custom_fields_for_table();
foreach ($customFieldsItems as $cf) {
$html .= '<th class="custom_field" align="left">' . $cf['name'] . '</th>';
}
$html .= '<th align="right">' . $this->qty_heading() . '</th>';
$html .= '<th align="right">' . $this->rate_heading() . '</th>';
if ($this->show_tax_per_item()) {
$html .= '<th align="right">' . $this->tax_heading() . '</th>';
}
$html .= '<th align="right">' . $this->amount_heading() . '</th>';
$html .= '</tr>';
return $html;
}
/**
* PDF headings preview
*
* @return string
*/
public function pdf_headings()
{
$descriptionItemWidth = $this->get_description_item_width();
$regularItemWidth = $this->get_regular_items_width(6);
$customFieldsItems = $this->get_custom_fields_for_table();
$tblhtml = '<tr height="30" bgcolor="' . get_option('pdf_table_heading_color') . '" style="color:' . get_option('pdf_table_heading_text_color') . ';">';
$tblhtml .= '<th width="5%;" align="center">' . $this->number_heading() . '</th>';
$tblhtml .= '<th width="' . $descriptionItemWidth . '%" align="left">' . $this->item_heading() . '</th>';
foreach ($customFieldsItems as $cf) {
$tblhtml .= '<th width="' . $regularItemWidth . '%" align="left">' . $cf['name'] . '</th>';
}
$tblhtml .= '<th width="' . $regularItemWidth . '%" align="right">' . $this->qty_heading() . '</th>';
$tblhtml .= '<th width="' . $regularItemWidth . '%" align="right">' . $this->rate_heading() . '</th>';
if ($this->show_tax_per_item()) {
$tblhtml .= '<th width="' . $regularItemWidth . '%" align="right">' . $this->tax_heading() . '</th>';
}
$tblhtml .= '<th width="' . $regularItemWidth . '%" align="right">' . $this->amount_heading() . '</th>';
$tblhtml .= '</tr>';
return $tblhtml;
}
/**
* Check for period merge field for recurring invoices
*
* @param mixed $text
*
* @return string
*/
protected function period_merge_field($text)
{
if ($this->type != 'invoice') {
return $text;
}
// Is subscription invoice
if (! property_exists($this->transaction, 'recurring_type')) {
return $text;
}
$startDate = $this->transaction->date;
$originalInvoice = $this->transaction->is_recurring_from ?
$this->ci->invoices_model->get($this->transaction->is_recurring_from) :
$this->transaction;
if (! preg_match('/^(\d{4})-(\d{1,2})-(\d{1,2})$/', $startDate)) {
$startDate = to_sql_date($startDate);
}
if ($originalInvoice->custom_recurring == 0) {
$originalInvoice->recurring_type = 'month';
}
$nextDate = date('Y-m-d', strtotime(
'+' . $originalInvoice->recurring . ' ' . strtoupper($originalInvoice->recurring_type),
strtotime($startDate)
));
return str_ireplace('{period}', _d($startDate) . ' - ' . _d(date('Y-m-d', strtotime('-1 day', strtotime($nextDate)))), $text);
}
protected function get_description_item_width()
{
$item_width = hooks()->apply_filters('item_description_td_width', 38);
// If show item taxes is disabled in PDF we should increase the item width table heading
return $this->show_tax_per_item() == 0 ? $item_width + 15 : $item_width;
}
protected function get_regular_items_width($adjustment)
{
$descriptionItemWidth = $this->get_description_item_width();
$customFieldsItems = $this->get_custom_fields_for_table();
// Calculate headings width, in case there are custom fields for items
$totalheadings = $this->show_tax_per_item() == 1 ? 4 : 3;
$totalheadings += count($customFieldsItems);
return (100 - ($descriptionItemWidth + $adjustment)) / $totalheadings;
}
}