*/ function display_lines($focus, $field, $value, $view) { global $sugar_config, $locale, $app_list_strings, $mod_strings; $enable_groups = (int)$sugar_config['aos']['lineItems']['enableGroups']; $total_tax = (int)$sugar_config['aos']['lineItems']['totalTax']; $html = ''; if ($view == 'EditView') { $html .= ''; if (file_exists('custom/modules/AOS_Products_Quotes/line_items.js')) { $html .= ''; } $html .= ''; $html .= "

"; if ($enable_groups) { $html .= "

"; $html .= ""; $html .= "

"; } $html .= ' '; if ($focus->id != '') { require_once('modules/AOS_Products_Quotes/AOS_Products_Quotes.php'); require_once('modules/AOS_Line_Item_Groups/AOS_Line_Item_Groups.php'); $sql = "SELECT pg.id, pg.group_id FROM aos_products_quotes pg LEFT JOIN aos_line_item_groups lig ON pg.group_id = lig.id WHERE pg.parent_type = '" . $focus->object_name . "' AND pg.parent_id = '" . $focus->id . "' AND pg.deleted = 0 ORDER BY lig.number ASC, pg.number ASC"; $result = $focus->db->query($sql); $html .= ""; while ($row = $focus->db->fetchByAssoc($result)) { $line_item = BeanFactory::newBean('AOS_Products_Quotes'); $line_item->retrieve($row['id'], false); $line_item = json_encode($line_item->toArray()); $group_item = 'null'; if ($row['group_id'] != null) { $group_item = BeanFactory::newBean('AOS_Line_Item_Groups'); $group_item->retrieve($row['group_id'], false); $group_item = json_encode($group_item->toArray()); } $html .= ""; } } if (!$enable_groups) { $html .= ''; } } elseif ($view == 'DetailView') { $params = array('currency_id' => $focus->currency_id); $sql = "SELECT pg.id, pg.group_id FROM aos_products_quotes pg LEFT JOIN aos_line_item_groups lig ON pg.group_id = lig.id WHERE pg.parent_type = '".$focus->object_name."' AND pg.parent_id = '".$focus->id."' AND pg.deleted = 0 ORDER BY lig.number ASC, pg.number ASC"; $result = $focus->db->query($sql); $sep = get_number_separators(); $html .= ""; $i = 0; $productCount = 0; $serviceCount = 0; $group_id = ''; $groupStart = ''; $groupEnd = ''; $product = ''; $service = ''; while ($row = $focus->db->fetchByAssoc($result)) { $line_item = BeanFactory::newBean('AOS_Products_Quotes'); $line_item->retrieve($row['id']); if ($enable_groups && ($group_id != $row['group_id'] || $i == 0)) { $html .= $groupStart.$product.$service.$groupEnd; if ($i != 0) { $html .= ""; } $groupStart = ''; $groupEnd = ''; $product = ''; $service = ''; $i = 1; $productCount = 0; $serviceCount = 0; $group_id = $row['group_id']; $group_item = BeanFactory::newBean('AOS_Line_Item_Groups'); $group_item->retrieve($row['group_id']); $groupStart .= ""; $groupStart .= ""; $groupStart .= ""; $groupStart .= ""; $groupStart .= ""; $groupEnd = ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; $groupEnd .= ""; } if ($line_item->product_id != '0' && $line_item->product_id != null) { if ($productCount == 0) { $product .= ""; $product .= ""; $product .= ""; $product .= ""; $product .= ""; $product .= ""; $product .= ""; $product .= ""; $product .= ""; $product .= ""; $product .= ""; } $product .= ""; $product_note = wordwrap($line_item->description, 40, "
\n"); $product .= ""; $product .= ""; $product .= ""; $product .= ""; $product .= ""; $product .= ""; if ($locale->getPrecision()) { $product .= ""; } else { $product .= ""; } $product .= ""; $product .= ""; $product .= ""; } else { if ($serviceCount == 0) { $service .= ""; $service .= ""; $service .= ""; $service .= ""; $service .= ""; $service .= ""; $service .= ""; $service .= ""; $service .= ""; $service .= ""; } $service .= ""; $service .= ""; $service .= ""; $service .= ""; $service .= ""; $service .= ""; $service .= ""; $service .= ""; $service .= ""; $service .= ""; } } $html .= $groupStart.$product.$service.$groupEnd; $html .= "


	".$mod_strings['LBL_GROUP_NAME'].":	".$group_item->name."

".$mod_strings['LBL_TOTAL_AMT'].":								".currency_format_number($group_item->total_amt, $params)."
".$mod_strings['LBL_DISCOUNT_AMOUNT'].":								".currency_format_number($group_item->discount_amount, $params)."
".$mod_strings['LBL_SUBTOTAL_AMOUNT'].":								".currency_format_number($group_item->subtotal_amount, $params)."
".$mod_strings['LBL_TAX_AMOUNT'].":								".currency_format_number($group_item->tax_amount, $params)."
".$mod_strings['LBL_GRAND_TOTAL'].":								".currency_format_number($group_item->total_amount, $params)."
	".$mod_strings['LBL_PRODUCT_QUANITY']."	".$mod_strings['LBL_PRODUCT_NAME']."	".$mod_strings['LBL_LIST_PRICE']."	".$mod_strings['LBL_DISCOUNT_AMT']."	".$mod_strings['LBL_UNIT_PRICE']."	".$mod_strings['LBL_VAT']."	".$mod_strings['LBL_VAT_AMT']."	".$mod_strings['LBL_TOTAL_PRICE']."
".++$productCount."	".stripDecimalPointsAndTrailingZeroes(format_number($line_item->product_qty), $sep[1])."	".$line_item->name." ".$product_note."	".currency_format_number($line_item->product_list_price, $params)."	".get_discount_string($line_item->discount, $line_item->product_discount, $params, $locale, $sep)."	".currency_format_number($line_item->product_unit_price, $params)."	".rtrim(rtrim(format_number($line_item->vat), '0'), $sep[1])."%	".format_number($line_item->vat)."%	".currency_format_number($line_item->vat_amt, $params)."	".currency_format_number($line_item->product_total_price, $params)."
	".$mod_strings['LBL_SERVICE_NAME']."		".$mod_strings['LBL_SERVICE_LIST_PRICE']."	".$mod_strings['LBL_SERVICE_DISCOUNT']."	".$mod_strings['LBL_SERVICE_PRICE']."	".$mod_strings['LBL_VAT']."	".$mod_strings['LBL_VAT_AMT']."	".$mod_strings['LBL_TOTAL_PRICE']."
".++$serviceCount."	".$line_item->name."		".currency_format_number($line_item->product_list_price, $params)."	".get_discount_string($line_item->discount, $line_item->product_discount, $params, $locale, $sep)."	".currency_format_number($line_item->product_unit_price, $params)."	".rtrim(rtrim(format_number($line_item->vat), '0'), $sep[1])."%	".currency_format_number($line_item->vat_amt, $params)."	".currency_format_number($line_item->product_total_price, $params)."

"; } return $html; } //Bug #598 //The original approach to trimming the characters was rtrim(rtrim(format_number($line_item->product_qty), '0'),$sep[1]) //This however had the unwanted side-effect of turning 1000 (or 10 or 100) into 1 when the Currency Significant Digits //field was 0. //The approach below will strip off the fractional part if it is only zeroes (and in this case the decimal separator //will also be stripped off) The custom decimal separator is passed in to the function from the locale settings function stripDecimalPointsAndTrailingZeroes($inputString, $decimalSeparator) { return preg_replace('/'.preg_quote((string) $decimalSeparator).'[0]+$/', '', (string) $inputString); } function get_discount_string($type, $amount, $params, $locale, $sep) { if ($amount != '' && $amount != '0.00') { if ($type == 'Amount') { return currency_format_number($amount, $params).""; } elseif ($locale->getPrecision()) { return rtrim(rtrim(format_number($amount), '0'), $sep[1])."%"; } return format_number($amount)."%"; } return "-"; } function display_shipping_vat($focus, $field, $value, $view) { if ($view == 'EditView') { global $app_list_strings; if ($value != '') { $value = format_number($value); } $html = ""; $html .= ""; return $html; } return format_number($value); }