function amount_in_words($module, $id, $templateid, $content, $tcpdf)
{
$db = PearDatabase::getInstance();
$current_language = Users_Record_Model::getCurrentUserModel()->get('language');
if (!file_exists("languages/" . $current_language . "/OSSPdf.php")) {
$current_language = "en_us";
}
$mod = $module;
$module = strtolower($module);
if ($module == 'quotes') {
$idcol = "quoteid";
} else {
$idcol = $module . "id";
}
$sql = "SELECT total FROM vtiger_{$module} WHERE {$idcol} = " . $id;
$result = $db->query($sql, true);
$grand_total = $db->query_result($result, 0, 'total');
$currfield = new CurrencyField($grand_total);
$grand_total = $currfield->getDBInsertedValue($grand_total);
require_once 'include/utils/utils.php';
require_once 'include/utils/CommonUtils.php';
require_once 'modules/' . $mod . '/' . $mod . '.php';
$focus = new $mod();
$focus->retrieve_entity_info($id, $mod);
$currency_id = $focus->column_fields['currency_id'];
$pobierz = $db->query("select currency_symbol, currency_code from vtiger_currency_info where id = '{$currency_id}'", true);
$kod_aktualnej_waluty = $db->query_result($pobierz, 0, "currency_code");
$recordModel = Vtiger_Record_Model::getCleanInstance('OSSPdf');
$kwota = $recordModel->slownie($grand_total, $kod_aktualnej_waluty);
return $kwota;
}
function replaceProductTableNP($content, $pdftype, $id)
{
$current_language = Users_Record_Model::getCurrentUserModel()->get('language');
require_once 'include/utils/utils.php';
include "modules/OSSPdf/language/" . $current_language . ".lang.php";
require_once 'include/utils/CommonUtils.php';
require_once 'include/fields/CurrencyField.php';
require_once 'modules/' . $pdftype . '/' . $pdftype . '.php';
$db = PearDatabase::getInstance();
$focus = new $pdftype();
$focus->retrieve_entity_info($id, $pdftype);
$focus->id = $focus->column_fields["record_id"];
$associated_products = getAssociatedProducts($pdftype, $focus);
$num_products = count($associated_products);
$currency_id = $focus->column_fields['currency_id'];
$pobierz = $db->query("select currency_symbol from vtiger_currency_info where id = '{$currency_id}'", true);
$symbol_waluty = $db->query_result($pobierz, 0, "currency_symbol");
//This $final_details array will contain the final total, discount, Group Tax, S&H charge, S&H taxes
$final_details = $associated_products[1]['final_details'];
//getting the Net Total
$price_subtotal = number_format($final_details["hdnSubTotal"], 2, '.', ',');
//Final discount amount/percentage
$discount_amount = $final_details["discount_amount_final"];
$discount_percent = $final_details["discount_percentage_final"];
if ($discount_amount != "") {
$price_discount = number_format($discount_amount, 2, '.', ',');
} else {
if ($discount_percent != "") {
//This will be displayed near Discount label - used in include/fpdf/templates/body.php
$final_price_discount_percent = "(" . number_format($discount_percent, 2, '.', ',') . " %)";
$price_discount = number_format($discount_percent * $final_details["hdnSubTotal"] / 100, 2, '.', ',');
} else {
$price_discount = "0.00";
}
}
//Grand Total
$price_total = number_format($final_details["grandTotal"], 2, '.', ',');
//To calculate the group tax amount
if ($final_details['taxtype'] == 'group') {
$group_tax_total = $final_details['tax_totalamount'];
$price_salestax = number_format($group_tax_total, 2, '.', ',');
$group_total_tax_percent = '0.00';
$group_tax_details = $final_details['taxes'];
for ($i = 0; $i < count($group_tax_details); $i++) {
$group_total_tax_percent = $group_total_tax_percent + $group_tax_details[$i]['percentage'];
}
}
$prod_line = array();
$lines = 0;
//This is to get all prodcut details as row basis
for ($i = 1, $j = $i - 1; $i <= $num_products; $i++, $j++) {
$product_name[$i] = $associated_products[$i]['productName' . $i];
$subproduct_name[$i] = split("<br>", $associated_products[$i]['subprod_names' . $i]);
//$prod_description[$i] = $associated_products[$i]['productDescription'.$i];
$comment[$i] = $associated_products[$i]['comment' . $i];
$product_id[$i] = $associated_products[$i]['hdnProductId' . $i];
$qty[$i] = $associated_products[$i]['qty' . $i];
$unit_price[$i] = number_format($associated_products[$i]['unitPrice' . $i], 2, '.', ',');
$list_price[$i] = $associated_products[$i]['listPrice' . $i];
// number_format($associated_products[$i]['listPrice'.$i],2,'.',',');
$list_pricet[$i] = $associated_products[$i]['listPrice' . $i];
$discount_total[$i] = $associated_products[$i]['discountTotal' . $i];
//aded for 5.0.3 pdf changes
$product_code[$i] = $associated_products[$i]['hdnProductcode' . $i];
$taxable_total = $qty[$i] * $list_pricet[$i] - $discount_total[$i];
$producttotal = $taxable_total;
$total_taxes = '0.00';
if ($focus->column_fields["hdnTaxType"] == "individual") {
$total_tax_percent = '0.00';
//This loop is to get all tax percentage and then calculate the total of all taxes
for ($tax_count = 0; $tax_count < count($associated_products[$i]['taxes']); $tax_count++) {
$tax_percent = $associated_products[$i]['taxes'][$tax_count]['percentage'];
$total_tax_percent = $total_tax_percent + $tax_percent;
$tax_amount = $taxable_total * $tax_percent / 100;
$total_taxes = $total_taxes + $tax_amount;
}
$producttotal = $taxable_total + $total_taxes;
$product_line[$j]["tax_percentage"] = $total_tax_percent;
$product_line[$j]["Tax"] = $total_taxes;
$price_salestax += $total_taxes;
}
$prod_total[$i] = $producttotal;
$product_line[$j]["Product Code"] = $product_code[$i];
$product_line[$j]["Qty"] = $qty[$i];
$product_line[$j]["Price"] = $list_price[$i];
$product_line[$j]["Discount"] = $discount_total[$i];
$product_line[$j]["Total"] = $prod_total[$i];
$lines++;
$product_line[$j]["Product Name"] = decode_html($product_name[$i]);
$prod_line[$j] = 1;
for ($count = 0; $count < count($subproduct_name[$i]); $count++) {
if ($lines % 12 != 0) {
$product_line[$j]["Product Name"] .= "\n" . decode_html($subproduct_name[$i][$count]);
$prod_line[$j]++;
} else {
$j++;
$product_line[$j]["Product Name"] = decode_html($product_name[$i]);
$product_line[$j]["Product Name"] .= "\n" . decode_html($subproduct_name[$i][$count]);
$prod_line[$j] = 2;
$lines++;
}
$lines++;
}
if ($comment[$i] != '') {
$product_line[$j]["Product Name"] .= "\n" . decode_html($comment[$i]);
$prod_line[$j]++;
$lines++;
}
}
$price_salestax = number_format($price_salestax, 2, '.', ',');
$header = array($mod_strings['LBL_nr'], $mod_strings['LBL_productname'], $mod_strings['LBL_Quantity'], $mod_strings['LBL_price'], $mod_strings['LBL_netto'], $mod_strings['LBL_rabat'], $mod_strings['LBL_vat'], $mod_strings['LBL_brutto']);
$data = array();
$i = 0;
foreach ($product_line as $item) {
$data[$i++] = array($i, $item['Product Name'], $item['Qty'], $item['Price'], $item['Price'] * $item['Qty'], $item['Discount'], 'NP', $item['Total']);
}
$width = array(30, 245, 35, 45, 45, 45, 45, 45);
$align = array("center", "center", "center", "center", "center", "center", "center", "center");
$format = array(0, "s", 0, 2, 2, 2, "np", 2);
$product_table = '<table border="1" cellpadding="2">';
$product_table .= '<tr valign="middle">';
for ($i = 0; $i < count($header); $i++) {
$product_table .= '<td width="' . $width[$i] . '" height="20" align="' . $align[$i] . '"><b><small>' . $header[$i] . '</small></b></td>';
}
$product_table .= '</tr>';
$align = array("center", "left", "center", "center", "center", "center", "center", "center", "center");
//Data
foreach ($data as $row) {
$product_table .= '<tr>';
$i = 0;
foreach ($row as $item) {
$sum[$i] += (double) $item;
if ($format[$i] == 's') {
$itarr = explode("\n\n", $item);
$item = '<b>' . $itarr[0] . '</b><br/><small>' . $itarr[1] . '</small>';
} elseif ($format[$i] == 'np') {
} else {
$currfield = new CurrencyField($item);
$item = $currfield->getDisplayValue();
}
$product_table .= '<td width="' . $width[$i] . '" align="' . $align[$i++] . '"><small>' . $item . '</small></td>';
}
$product_table .= '</tr>';
}
$product_table .= "</table>";
$i = 0;
$mod = strtolower($pdftype);
if ($mod == 'quotes') {
$idcol = "quoteid";
} else {
$idcol = $mod . "id";
}
$sql = "SELECT discount_percent, discount_amount, subtotal, total FROM vtiger_{$mod} WHERE {$idcol} = " . $this->id;
$result = $db->query($sql, true);
$grand_total = $db->query_result($result, 0, 'total');
$subtotal = $db->query_result($result, 0, "subtotal");
$discount_percent = $db->query_result($result, 0, 'discount_percent');
$discount_amount = $db->query_result($result, 0, 'discount_amount');
if ($discount_percent != 0) {
$discount = $subtotal * ($discount_percent / 100.0);
} else {
$discount = $discount_amount;
}
$currfield = new CurrencyField($grand_total);
$grand_total = $currfield->getDisplayValue();
$currfield = new CurrencyField($subtotal);
$subtotal = $currfield->getDisplayValue();
$currfield = new CurrencyField($discount);
$discount = $currfield->getDisplayValue();
$product_table .= '<table width="535px" border="1" cellpadding="2">
<tr height="10"><td align="right" valign="middle"><small><b>' . getTranslatedString('Net Total', "OSSPdf") . '</b> : ' . $subtotal . '</small></td></tr>
<tr valign="middle"><td align="right"><small><b>' . getTranslatedString("Discount Amount", "OSSPdf") . '</b> : ' . $discount . '</small></td></tr>
<tr valign="middle"><td align="right"><small><b>' . getTranslatedString("Grand Total", "OSSPdf") . '</b> : ' . $grand_total . ' (' . $symbol_waluty . ')</small></td></tr>
</table><br/>';
$content = str_replace("#product_tableNP#", $product_table, $content);
$currfield = new CurrencyField($grand_total);
$grand_total = $currfield->getDBInsertedValue($grand_total);
$kwota = $this->slownie($grand_total);
$content = str_replace("#amount_words#", $kwota, $content);
return $content;
}
public function addUserSearchConditions($input)
{
global $log, $default_charset;
if ($input['searchtype'] == 'advance') {
$json = new Zend_Json();
$advft_criteria = $_REQUEST['advft_criteria'];
if (!empty($advft_criteria)) {
$advft_criteria = $json->decode($advft_criteria);
}
$advft_criteria_groups = $_REQUEST['advft_criteria_groups'];
if (!empty($advft_criteria_groups)) {
$advft_criteria_groups = $json->decode($advft_criteria_groups);
}
if (empty($advft_criteria) || count($advft_criteria) <= 0) {
return;
}
$advfilterlist = getAdvancedSearchCriteriaList($advft_criteria, $advft_criteria_groups, $this->getModule());
if (empty($advfilterlist) || count($advfilterlist) <= 0) {
return;
}
if ($this->conditionInstanceCount > 0) {
$this->startGroup(self::$AND);
} else {
$this->startGroup('');
}
foreach ($advfilterlist as $groupindex => $groupcolumns) {
$filtercolumns = $groupcolumns['columns'];
if (count($filtercolumns) > 0) {
$this->startGroup('');
foreach ($filtercolumns as $index => $filter) {
$name = explode(':', $filter['columnname']);
if (empty($name[2]) && $name[1] == 'crmid' && $name[0] == 'vtiger_crmentity') {
$name = $this->getSQLColumn('id');
} else {
$name = $name[2];
}
$this->addCondition($name, $filter['value'], $filter['comparator']);
$columncondition = $filter['column_condition'];
if (!empty($columncondition)) {
$this->addConditionGlue($columncondition);
}
}
$this->endGroup();
$groupConditionGlue = $groupcolumns['condition'];
if (!empty($groupConditionGlue)) {
$this->addConditionGlue($groupConditionGlue);
}
}
}
$this->endGroup();
} elseif ($input['type'] == 'dbrd') {
if ($this->conditionInstanceCount > 0) {
$this->startGroup(self::$AND);
} else {
$this->startGroup('');
}
$allConditionsList = $this->getDashBoardConditionList();
$conditionList = $allConditionsList['conditions'];
$relatedConditionList = $allConditionsList['relatedConditions'];
$noOfConditions = count($conditionList);
$noOfRelatedConditions = count($relatedConditionList);
foreach ($conditionList as $index => $conditionInfo) {
$this->addCondition($conditionInfo['fieldname'], $conditionInfo['value'], $conditionInfo['operator']);
if ($index < $noOfConditions - 1 || $noOfRelatedConditions > 0) {
$this->addConditionGlue(self::$AND);
}
}
foreach ($relatedConditionList as $index => $conditionInfo) {
$this->addRelatedModuleCondition($conditionInfo['relatedModule'], $conditionInfo['conditionModule'], $conditionInfo['finalValue'], $conditionInfo['SQLOperator']);
if ($index < $noOfRelatedConditions - 1) {
$this->addConditionGlue(self::$AND);
}
}
$this->endGroup();
} else {
if (isset($input['search_field']) && $input['search_field'] != "") {
$fieldName = vtlib_purify($input['search_field']);
} else {
return;
}
if ($this->conditionInstanceCount > 0) {
$this->startGroup(self::$AND);
} else {
$this->startGroup('');
}
$moduleFields = $this->getModuleFields();
$field = $moduleFields[$fieldName];
$type = $field->getFieldDataType();
if (isset($input['search_text']) && $input['search_text'] != "") {
// search other characters like "|, ?, ?" by jagi
$value = $input['search_text'];
$stringConvert = function_exists(iconv) ? @iconv("UTF-8", $default_charset, $value) : $value;
if (!$this->isStringType($type)) {
$value = trim($stringConvert);
}
if ($type == 'picklist') {
global $mod_strings;
// Get all the keys for the for the Picklist value
$mod_keys = array_keys($mod_strings, $value);
if (sizeof($mod_keys) >= 1) {
// Iterate on the keys, to get the first key which doesn't start with LBL_ (assuming it is not used in PickList)
foreach ($mod_keys as $mod_idx => $mod_key) {
$stridx = strpos($mod_key, 'LBL_');
// Use strict type comparision, refer strpos for more details
if ($stridx !== 0) {
$value = $mod_key;
break;
}
}
}
}
if ($type == 'currency') {
// Some of the currency fields like Unit Price, Total, Sub-total etc of Inventory modules, do not need currency conversion
if ($field->getUIType() == '72') {
$value = CurrencyField::convertToDBFormat($value, null, true);
} else {
$currencyField = new CurrencyField($value);
$value = $currencyField->getDBInsertedValue();
}
}
}
if (!empty($input['operator'])) {
$operator = $input['operator'];
} elseif (trim(strtolower($value)) == 'null') {
$operator = 'e';
} else {
if (!$this->isNumericType($type) && !$this->isDateType($type)) {
$operator = 'c';
} else {
$operator = 'h';
}
}
$this->addCondition($fieldName, $value, $operator);
$this->endGroup();
}
}
function getAdvancedSearchCriteriaList($advft_criteria, $advft_criteria_groups, $module = '')
{
global $currentModule, $current_user;
if (empty($module)) {
$module = $currentModule;
}
$advfilterlist = array();
$moduleHandler = vtws_getModuleHandlerFromName($module, $current_user);
$moduleMeta = $moduleHandler->getMeta();
$moduleFields = $moduleMeta->getModuleFields();
foreach ($advft_criteria as $column_index => $column_condition) {
if (empty($column_condition)) {
continue;
}
$adv_filter_column = $column_condition["columnname"];
$adv_filter_comparator = $column_condition["comparator"];
$adv_filter_value = $column_condition["value"];
$adv_filter_column_condition = $column_condition["columncondition"];
$adv_filter_groupid = $column_condition["groupid"];
$column_info = explode(":", $adv_filter_column);
$fieldName = $column_info[2];
$fieldObj = $moduleFields[$fieldName];
$fieldType = $fieldObj->getFieldDataType();
if ($fieldType == 'currency') {
// Some of the currency fields like Unit Price, Total, Sub-total etc of Inventory modules, do not need currency conversion
if ($fieldObj->getUIType() == '72') {
$adv_filter_value = CurrencyField::convertToDBFormat($adv_filter_value, null, true);
} else {
$currencyField = new CurrencyField($adv_filter_value);
if ($module == 'Potentials' && $fieldName == 'amount') {
$currencyField->setNumberofDecimals(2);
}
$adv_filter_value = $currencyField->getDBInsertedValue();
}
}
$criteria = array();
$criteria['columnname'] = $adv_filter_column;
$criteria['comparator'] = $adv_filter_comparator;
$criteria['value'] = $adv_filter_value;
$criteria['column_condition'] = $adv_filter_column_condition;
$advfilterlist[$adv_filter_groupid]['columns'][] = $criteria;
}
foreach ($advft_criteria_groups as $group_index => $group_condition_info) {
if (empty($group_condition_info)) {
continue;
}
if (empty($advfilterlist[$group_index])) {
continue;
}
$advfilterlist[$group_index]['condition'] = $group_condition_info["groupcondition"];
$noOfGroupColumns = count($advfilterlist[$group_index]['columns']);
if (!empty($advfilterlist[$group_index]['columns'][$noOfGroupColumns - 1]['column_condition'])) {
$advfilterlist[$group_index]['columns'][$noOfGroupColumns - 1]['column_condition'] = '';
}
}
$noOfGroups = count($advfilterlist);
if (!empty($advfilterlist[$noOfGroups]['condition'])) {
$advfilterlist[$noOfGroups]['condition'] = '';
}
return $advfilterlist;
}
function replaceProductTable($pdftype, $id, $templateid, $content, $tcpdf)
{
$permitted_modules = vglobal('permitted_modules');
if (in_array($pdftype, $permitted_modules)) {
/* ------------------- COLUMN CONFIGURATION -------------------
In this part, you can decide which columns you want to appear
and which are not in the table of positions and invoice summary table
If the variable responsible for this column has the value TRUE
will be displayed and if FALSE it will not be displayed
*/
// The columns for the table from the list of items on the invoice
$kolumnyDlaPozycjiFaktur = array();
// column ordinal
$enable_ordinal_column = TRUE;
// Column name of the product
$enable_productname_column = TRUE;
// column number
$enable_amount_column = TRUE;
// unit price column
$enable_listprice_column = TRUE;
// net price column
$enable_netprice_column = TRUE;
// discount column
$enable_discount_column = TRUE;
// Vat column (%)
$enable_vatpercentage_column = TRUE;
// Vat column (currency)
$enable_vatamount_column = TRUE;
// Gross column
$enable_gross_column = TRUE;
// Taxes in PLN
$enable_taxes_inPLN = TRUE;
// Column for a summary in the gray box
$wyswietlaj = array($enable_ordinal_column, $enable_productname_column, $enable_amount_column, $enable_listprice_column, $enable_netprice_column, $enable_discount_column, $enable_vatpercentage_column, $enable_vatamount_column, $enable_gross_column, $enable_taxes_inPLN);
$kolumnyDlaPodsumowaniaFaktur = array();
// shipping costs
$enable_summary_shipping = TRUE;
// tax on shipping costs
$enable_summary_shippingtax = TRUE;
// correction
$enable_summary_correction = TRUE;
// to pay
$enable_summary_topay = TRUE;
// total rebate
$enable_summary_rebate = TRUE;
// the percentage of tax column
$enable_summary_taxpercentage = TRUE;
// tax amount column
$enable_summary_taxamount = TRUE;
//show the date of the course
$enable_date_of_the_course = TRUE;
//----------------------------------------------------
$newdate = vglobal('newdate');
$current_user = vglobal('current_user');
$adb = PearDatabase::getInstance();
$currentModule = vglobal('currentModule');
require_once 'include/utils/utils.php';
$current_language = Users_Record_Model::getCurrentUserModel()->get('language');
include "languages/" . $current_language . "/OSSPdf.php";
include_once "languages/" . $current_language . "/Vtiger.php";
require_once 'include/utils/CommonUtils.php';
require_once 'include/fields/CurrencyField.php';
require_once 'modules/' . $pdftype . '/' . $pdftype . '.php';
$displays_a_summary_of_invoices = TRUE;
if ($pdftype == 'OSSCorrectedInvoice') {
require_once 'modules/' . $pdftype . '/utils.php';
$displays_a_summary_of_invoices = FALSE;
$pdftype = 'Invoice';
$id_sql = "SELECT invoiceid FROM vtiger_osscorrectedinvoice WHERE osscorrectedinvoiceid = {$id}";
$id_result = $adb->query($id_sql, true);
$id = $adb->query_result($id_result, 0, 'invoiceid');
}
$focus = new $pdftype();
$focus->retrieve_entity_info($id, $pdftype);
$currency_id = $focus->column_fields['currency_id'];
$pobierz = $adb->query("select currency_symbol, currency_code from vtiger_currency_info where id = '{$currency_id}'", true);
$symbol_waluty = $adb->query_result($pobierz, 0, "currency_symbol");
$kod_aktualnej_waluty = $adb->query_result($pobierz, 0, "currency_code");
$focus->id = $focus->column_fields["record_id"];
if ($pdftype == 'OSSInvoiceCost') {
$associated_products = OSSgetAssociatedProducts($pdftype, $focus);
} else {
$associated_products = getAssociatedProducts($pdftype, $focus);
}
$czyDrukowacKolumneZPrzeliczonymPodatkiem = FALSE;
$moduleFilePath = "modules/OSSCurrencyUpdate/OSSCurrencyUpdate.php";
$moduleFilePathTpl = "Smarty/templates/modules/OSSCurrencyUpdate/index.tpl";
$checkInDatabaseSql = "SELECT * FROM vtiger_tab WHERE name = 'OSSCurrencyUpdate'";
$pobierzGluwnaWaluteSql = $adb->query("select currency_code from vtiger_currency_info where id = '1'", true);
$kod_waluty = $adb->query_result($pobierzGluwnaWaluteSql, 0, "currency_code");
$checkInDatabaseResult = $adb->query($checkInDatabaseSql, true);
$numDB = $adb->num_rows($checkInDatabaseResult);
if (file_exists($moduleFilePath) && file_exists($moduleFilePathTpl) && $numDB > 0 && $kod_waluty == 'PLN' && $kod_aktualnej_waluty != 'PLN' && vtlib_isModuleActive('OSSCurrencyUpdate')) {
$czyDrukowacKolumneZPrzeliczonymPodatkiem = TRUE;
}
if ($czyDrukowacKolumneZPrzeliczonymPodatkiem == TRUE) {
require_once $moduleFilePath;
}
$num_products = count($associated_products);
$vat = array();
$sales = array();
$service = array();
$total_discount = 0.0;
$suma_netto = 0.0;
$suma_brutto = $associated_products[1]['final_details']['grandTotal'];
$rabat_calkowity = $associated_products[1]['final_details']['discountTotal_final'];
$suma_vat = 0;
/////////////////////////////
/// Create a table summary of VAT
if ($focus->column_fields['hdnTaxType'] == 'group') {
for ($i = 1; $i <= count($associated_products); $i++) {
$total_discount += $associated_products[$i]['discountTotal' . $i];
$suma_netto += $associated_products[$i]['listPrice' . $i] - $total_discount;
}
} else {
for ($i = 1; $i <= count($associated_products); $i++) {
$TotalAfterDiscount = $associated_products[$i]['totalAfterDiscount' . $i];
$suma_netto += $TotalAfterDiscount;
foreach ($associated_products[$i]['taxes'] as $podatek) {
if ($podatek['taxlabel'] == 'VAT') {
$vat[$podatek['percentage']] += $TotalAfterDiscount * ($podatek['percentage'] / 100.0);
$suma_vat += $TotalAfterDiscount * ($podatek['percentage'] / 100.0);
}
if ($podatek['taxlabel'] == 'Sales') {
$sales[$podatek['percentage']] += $TotalAfterDiscount * ($podatek['percentage'] / 100.0);
}
if ($podatek['taxlabel'] == 'Service') {
$service[$podatek['percentage']] += $TotalAfterDiscount * ($podatek['percentage'] / 100.0);
}
}
// Calculating the total discount
$total_discount += $associated_products[$i]['discountTotal' . $i];
}
}
///////////////////////////////////////////////////////////
//This $final_details array will contain the final total, discount, Group Tax, S&H charge, S&H taxes
$final_details = $associated_products[1]['final_details'];
//getting the Net Total
$price_subtotal = number_format($final_details["hdnSubTotal"], 2, '.', ',');
//Final discount amount/percentage
$discount_amount = $final_details["discount_amount_final"];
$discount_percent = $final_details["discount_percentage_final"];
if ($discount_amount != "") {
$price_discount = number_format($discount_amount, 2, '.', ',');
$price_disc = $discount_amount;
} else {
if ($discount_percent != "") {
//This will be displayed near Discount label - used in include/fpdf/templates/body.php
$final_price_discount_percent = "(" . number_format($discount_percent, 2, '.', ',') . " %)";
$price_discount = number_format($discount_percent * $final_details["hdnSubTotal"] / 100, 2, '.', ',');
$price_disc = $discount_percent * $final_details["hdnSubTotal"];
} else {
$price_discount = "0.00";
}
}
//Grand Total
$price_total = number_format($final_details["grandTotal"], 2, '.', ',');
//To calculate the group tax amount
if ($final_details['taxtype'] == 'group') {
$group_tax_total = $final_details['tax_totalamount'];
$price_salestax = number_format($group_tax_total, 2, '.', ',');
$group_total_tax_percent = '0.00';
$group_tax_details = $final_details['taxes'];
for ($i = 0; $i < count($group_tax_details); $i++) {
$group_total_tax_percent = $group_total_tax_percent + $group_tax_details[$i]['percentage'];
}
}
$podatek_grupowy = ($final_details["hdnSubTotal"] - $price_disc) * ($group_total_tax_percent / 100.0);
$prod_line = array();
$lines = 0;
//This is to get all prodcut details as row basis
for ($i = 1, $j = $i - 1; $i <= $num_products; $i++, $j++) {
$product_name[$i] = $associated_products[$i]['productName' . $i];
$subproduct_name[$i] = split("<br>", $associated_products[$i]['subprod_names' . $i]);
$comment[$i] = $associated_products[$i]['comment' . $i];
$product_id[$i] = $associated_products[$i]['hdnProductId' . $i];
$qty[$i] = $associated_products[$i]['qty' . $i];
$unit_price[$i] = number_format($associated_products[$i]['unitPrice' . $i], 2, '.', ',');
$list_price[$i] = $associated_products[$i]['listPrice' . $i];
// number_format($associated_products[$i]['listPrice'.$i],2,'.',',');
$list_pricet[$i] = $associated_products[$i]['listPrice' . $i];
$discount_total[$i] = $associated_products[$i]['discountTotal' . $i];
$product_code[$i] = $associated_products[$i]['hdnProductcode' . $i];
$taxable_total = $qty[$i] * $list_pricet[$i] - $discount_total[$i];
$producttotal = $taxable_total;
$total_taxes = '0.00';
if ($focus->column_fields["hdnTaxType"] == "individual") {
$total_tax_percent = '0.00';
//This loop is to get all tax percentage and then calculate the total of all taxes
for ($tax_count = 0; $tax_count < count($associated_products[$i]['taxes']); $tax_count++) {
$tax_percent = $associated_products[$i]['taxes'][$tax_count]['percentage'];
$total_tax_percent = $total_tax_percent + $tax_percent;
$tax_amount = $taxable_total * $tax_percent / 100;
$total_taxes = $total_taxes + $tax_amount;
}
$producttotal = $taxable_total + $total_taxes;
$product_line[$j]["tax_percentage"] = $total_tax_percent;
$product_line[$j]["Tax"] = $total_taxes;
$price_salestax += $total_taxes;
}
$prod_total[$i] = $producttotal;
// number_format($producttotal,2,'.',',');
$product_line[$j]["Product Code"] = $product_code[$i];
$product_line[$j]["Qty"] = $qty[$i];
$product_line[$j]["Price"] = $list_price[$i];
$product_line[$j]["Discount"] = $discount_total[$i];
$product_line[$j]["Total"] = $prod_total[$i];
$lines++;
$product_line[$j]["Product Name"] = '<b>' . decode_html($product_name[$i]) . '</b>';
$prod_line[$j] = 1;
for ($count = 0; $count < count($subproduct_name[$i]); $count++) {
if ($lines % 12 != 0) {
if ($subproduct_name[$i][$count] != '') {
$product_line[$j]["Product Name"] .= "\n <br />" . '<font color="grey" size="-1"><em>' . decode_html($subproduct_name[$i][$count]) . '</em></font>';
$prod_line[$j]++;
}
} else {
$j++;
$product_line[$j]["Product Name"] = decode_html($product_name[$i]);
$product_line[$j]["Product Name"] .= "\n <br />" . decode_html($subproduct_name[$i][$count]);
$prod_line[$j] = 2;
$lines++;
}
$lines++;
}
if ($comment[$i] != '') {
$product_line[$j]["Product Name"] .= "\n" . '<br />' . decode_html($comment[$i]);
$prod_line[$j]++;
$lines++;
}
}
$tax_pl = 0;
if ($czyDrukowacKolumneZPrzeliczonymPodatkiem == TRUE) {
//invoicedate
$invoice_date_sql = "SELECT invoicedate FROM `vtiger_invoice` WHERE invoiceid = {$id}";
$invoice_date_result = $adb->query($invoice_date_sql, true);
$invoice_date = $adb->query_result($invoice_date_result, 0, 'invoicedate');
$date = $invoice_date;
$newdate = strtotime('-1 day', strtotime($date));
$newdate = date('Y-m-d', $newdate);
$CurrencyUpdate = Vtiger_Record_Model::getCleanInstance('OSSCurrencyUpdate');
$kurs_waluty_result = $CurrencyUpdate->getCurrencyRate($newdate, $currency_id);
$num_rate = $adb->num_rows($kurs_waluty_result, true);
$kurs_waluty = '0.00';
if ($num_rate != 0) {
$kurs_waluty = (double) $adb->query_result($kurs_waluty_result, 0, 'kurs');
$newdate = date('Y-m-d', strtotime($adb->query_result($kurs_waluty_result, 0, "data_faktyczna_kursu")));
} else {
$CurrencyUpdate->getCurrency($newdate);
$kurs_waluty_result = $CurrencyUpdate->getCurrencyRate($newdate, $currency_id);
$num_rate = $adb->num_rows($kurs_waluty_result);
if ($num_rate != 0) {
$kurs_waluty = (double) $adb->query_result($kurs_waluty_result, 0, 'kurs');
}
}
}
$price_salestax = number_format($price_salestax, 2, '.', ',');
if ($final_details['taxtype'] == 'group') {
$header = array();
if ($enable_ordinal_column) {
$header[0] = vtranslate('LBL_nr', 'OSSPdf');
}
if ($enable_productname_column) {
$header[1] = vtranslate('LBL_productname', 'OSSPdf');
}
if ($enable_amount_column) {
$header[2] = vtranslate('LBL_Quantity', 'OSSPdf');
}
if ($enable_listprice_column) {
$header[3] = vtranslate('LBL_price', 'OSSPdf');
}
if ($enable_netprice_column) {
$header[4] = vtranslate('LBL_rabat', 'OSSPdf');
}
if ($enable_discount_column) {
$header[5] = vtranslate('LBL_netto', 'OSSPdf');
}
if ($enable_gross_column) {
$header[6] = vtranslate('LBL_brutto', 'OSSPdf');
}
} else {
$header = array();
if ($enable_ordinal_column) {
$header[0] = vtranslate('LBL_nr', 'OSSPdf');
}
if ($enable_productname_column) {
$header[1] = vtranslate('LBL_productname', 'OSSPdf');
}
if ($enable_amount_column) {
$header[2] = vtranslate('LBL_Quantity', 'OSSPdf');
}
if ($enable_listprice_column) {
$header[3] = vtranslate('LBL_price', 'OSSPdf');
}
if ($enable_netprice_column) {
$header[4] = vtranslate('LBL_rabat', 'OSSPdf');
}
if ($enable_discount_column) {
$header[5] = vtranslate('LBL_netto', 'OSSPdf');
}
if ($enable_vatpercentage_column) {
$header[6] = vtranslate('LBL_vat', 'OSSPdf');
}
if ($enable_vatamount_column) {
$header[7] = vtranslate('LBL_vat_waluta', 'OSSPdf') . " (" . $symbol_waluty . ")";
}
if ($enable_gross_column) {
$header[8] = vtranslate('LBL_brutto', 'OSSPdf');
}
if ($enable_taxes_inPLN == TRUE && $czyDrukowacKolumneZPrzeliczonymPodatkiem == TRUE) {
$header[9] = vtranslate('TAXES_IN_PLN', 'OSSPdf');
}
}
$data = array();
$i = 1;
$suma_podatku_w_pln = 0.0;
$tax_percentage_array = array();
foreach ($product_line as $item) {
$currfield = new CurrencyField($item["tax_percentage"]);
$tax_percentage = $currfield->getDisplayValue();
$tax_percentage_array[$i] = $tax_percentage;
if ($final_details['taxtype'] == 'group') {
$netto = $item['Price'] * $item['Qty'] - $item['Discount'];
// $currfield = new CurrencyField($netto);
// $currfield->getDBInsertedValue();
// $netto = $currfield->getDisplayValue();
// $currfield = new CurrencyField((float) $item['Price']);
// $currfield->getDBInsertedValue();
$item['Price'] = (double) $item['Price'];
// $currfield = new CurrencyField((float) $item['Discount']);
// $currfield->getDBInsertedValue();
$item['Discount'] = (double) $item['Discount'];
// $currfield = new CurrencyField((float) $item['Total']);
// $currfield->getDBInsertedValue();
$item['Total'] = (double) $item['Total'];
$data[$i] = array($i, $item['Product Name'], $item['Qty'], $item['Price'], $item['Discount'], $netto, $item['Total']);
} else {
$tax_pln = $item['Tax'] * $kurs_waluty;
$suma_podatku_w_pln += $tax_pln;
//$currfield = new CurrencyField( $tax_pln );
//$tax_pln = $currfield->getDisplayValue();
$netto = $item['Price'] * $item['Qty'] - $item['Discount'];
//$currfield = new CurrencyField( $netto );
//$currfield->getDBInsertedValue();
//$netto = $currfield->getDisplayValue();
////////
//$currfield = new CurrencyField( (float)$item['Price'] );
//$currfield->getDBInsertedValue();
$item['Price'] = (double) $item['Price'];
//$currfield->getDisplayValue();
////////
$currfield = new CurrencyField((double) $item['Discount']);
$currfield->getDBInsertedValue();
$item['Discount'] = (double) $item['Discount'];
//$currfield->getDisplayValue();
/////////
//$currfield = new CurrencyField( (float)$item['tax_percentage'] );
//$currfield->getDBInsertedValue();
$tax_percentage = (double) $item['tax_percentage'];
//$currfield->getDisplayValue();
//////////
//$currfield = new CurrencyField( (float)$item['Tax'] );
//$currfield->getDBInsertedValue();
$item['Tax'] = (double) $item['Tax'];
//$currfield->getDisplayValue();
///////////
//$currfield = new CurrencyField( (float)$item['Total'] );
//$currfield->getDBInsertedValue();
$item['Total'] = (double) $item['Total'];
//$currfield->getDisplayValue();
////////////
$data[$i] = array($i, $item['Product Name'], $item['Qty'], $item['Price'], $item['Discount'], $netto, $tax_percentage, $item['Tax'], $item['Total'], $tax_pln);
}
$i++;
}
if ($final_details['taxtype'] == 'group') {
$width = array(30, 200, 50, 60, 50, 70, 70);
$align = array("center", "center", "center", "center", "center", "center", "center");
$format = array(0, "s", 0, 2, 2, 2, 2);
} else {
$width = array(30, 180, 50, 60, 50, 40, 40, 40, 40, 40);
$align = array("center", "center", "center", "center", "center", "center", "center", "center", "center", "center");
$format = array(0, "s", 0, 2, 2, 2, 2, 2, 2);
}
$product_table = '<table cellpadding="2">';
$product_table .= '<tr style="background-color: #c8c8c8;" >';
foreach ($header as $lastKey => $val) {
$product_table .= '<td style="border:0.2mm solid black;" width="' . $width[$lastKey] . '" height="20" align="' . $align[$lastKey] . '"><b><small>' . $val . '</small></b></td>';
}
$product_table .= '</tr>';
$group_sep = ' ';
$separatorSql = "SELECT currency_decimal_separator FROM vtiger_users WHERE id = '{$current_user->id}'";
$separatorResult = $adb->query($separatorSql, true);
$dec_sep = $adb->query_result($separatorResult, 0, 'currency_decimal_separator');
$group_sep = $adb->query_result($separatorResult, 0, 'currency_grouping_separator');
if ($dec_sep == '') {
$dec_sep = ' ';
}
$align = array("center", "left", "center", "center", "center", "center", "center", "center", "center", "center");
$i = 0;
foreach ($data as $row) {
$product_table .= '<tr>';
$tax_percentage = $tax_percentage_array[$i];
foreach ($row as $key => $item) {
if ($format[$i] != 's') {
//echo $item;
} else {
$itarr = explode("\n\n", $item);
$item = $itarr[0] . ' ' . $itarr[1];
}
if ($wyswietlaj[$key]) {
if ($key == 9) {
if ($czyDrukowacKolumneZPrzeliczonymPodatkiem == TRUE) {
$currfield = new CurrencyField(0);
$zero = $currfield->getDisplayValue();
if ($item != 0 && $kurs_waluty) {
//var_dump($item);
//exit();
$product_table .= '<td style="border: 0.2mm solid black;" width="' . $width[$key] . '" align="' . $align[$key] . '"><small>' . number_format((double) $item, 2, $dec_sep, $group_sep) . '</small></td>';
} else {
$product_table .= '<td style="border: 0.2mm solid black;" width="' . $width[$key] . '" align="' . $align[$key] . '"><small>np</small></td>';
}
}
} else {
if ($key != 0 && $key != 1) {
$product_table .= '<td style="border: 0.2mm solid black;' . ($lastKey == 7 ? ' border-right: 0.2mm solid black;' : '') . '" width="' . $width[$key] . '" align="' . $align[$key] . '"><small>' . number_format($item, 2, $dec_sep, $group_sep) . '</small></td>';
} else {
$product_table .= '<td style="border: 0.2mm solid black;" width="' . $width[$key] . '" align="' . $align[$key] . '"><small>' . $item . '</small></td>';
}
}
}
}
$product_table .= '</tr>';
$i++;
}
$product_table .= "</table>";
$i = 0;
$product_table .= '<table cellpadding="0" cellspacing="0"><tr border="0">';
if ($enable_ordinal_column) {
$product_table .= '<td width="' . $width[0] . '"></td>';
}
if ($enable_productname_column) {
$product_table .= '<td width="' . $width[1] . '"></td>';
}
if ($enable_amount_column) {
$product_table .= '<td width="' . $width[2] . '"></td>';
}
if ($enable_listprice_column) {
$product_table .= '<td width="' . $width[3] . '"></td>';
}
if ($enable_netprice_column) {
$product_table .= '<td width="' . $width[4] . '" align="center" valign="middle" style="border: 0.2mm solid black;" ><small><b>' . number_format($total_discount, 2, $dec_sep, $group_sep) . '</b></small></td>';
}
if ($enable_discount_column) {
$product_table .= '<td width="' . $width[5] . '" align="center" valign="middle" style="border: 0.2mm solid black;"><small><b>' . number_format($suma_netto, 2, $dec_sep, $group_sep) . '</b></small></td>';
}
if ($enable_vatpercentage_column && $final_details['taxtype'] != 'group') {
$product_table .= '<td width="' . $width[6] . '"></td>';
}
if ($enable_vatamount_column && $final_details['taxtype'] != 'group') {
$product_table .= '<td width="' . $width[7] . '" align="center" valign="middle" style="border: 0.2mm solid black;"><small><b>' . number_format($suma_vat, 2, $dec_sep, $group_sep) . '</b></small></td>';
}
if ($enable_gross_column) {
$product_table .= '<td width="' . $width[5] . '" align="center" valign="middle" style="border: 0.2mm solid black;"><small><b>' . number_format($suma_brutto, 2, $dec_sep, $group_sep) . '</b></small></td>';
}
if ($enable_gross_column && $suma_podatku_w_pln != 0 && $czyDrukowacKolumneZPrzeliczonymPodatkiem == TRUE) {
$product_table .= '<td width="' . $width[9] . '" align="center" valign="middle" style="border: 0.2mm solid black;"><small><b>' . number_format($suma_podatku_w_pln, 2, $dec_sep, $group_sep) . '</b></small></td>';
}
$product_table .= '</tr></table><br/>';
if ($final_details['taxtype'] == 'group') {
$grup_tax = 0.0;
for ($i = 0; $i < 3; $i++) {
if ($associated_products[1]['final_details']['tax'] == $associated_products[1]['final_details']['taxes'][$i]['taxname']) {
$grup_tax = (double) $associated_products[1]['final_details']['taxes'][$i]['amount'];
$grup_tax_percent = (double) $associated_products[1]['final_details']['taxes'][$i]['percentage'];
}
}
$currfield = new CurrencyField($grup_tax);
$grup_tax = $currfield->getDisplayValue();
$currfield = new CurrencyField($grup_tax_percent);
$grup_tax_percent = $currfield->getDisplayValue();
}
$mod = strtolower($pdftype);
if ($mod == 'quotes') {
$idcol = "quoteid";
} else {
$idcol = $mod . "id";
}
$sql = "SELECT discount_percent, discount_amount, subtotal, total FROM vtiger_{$mod} WHERE {$idcol} = " . $id;
$result = $adb->query($sql, true);
$grand_total = $adb->query_result($result, 0, 'total');
$subtotal = $adb->query_result($result, 0, "subtotal");
$discount_percent = $adb->query_result($result, 0, 'discount_percent');
$discount_amount = $adb->query_result($result, 0, 'discount_amount');
if ($discount_percent != 0) {
$discount = $subtotal * ($discount_percent / 100.0);
} else {
$discount = $discount_amount;
}
//$currfield = new CurrencyField( $grand_total );
//$grand_total = $currfield->getDisplayValue();
$currfield = new CurrencyField($subtotal);
$subtotal = $currfield->getDisplayValue();
$currfield = new CurrencyField($discount);
$discount = $currfield->getDisplayValue();
$currfield = new CurrencyField($netto);
$netto = $currfield->getDisplayValue();
if ($displays_a_summary_of_invoices == TRUE) {
$product_table .= '<table width="535px" border="0" cellpadding="2">
<tr>
<td width="85px"></td>
<td width="270px"><br /><br />
<table bgcolor="#e8e8e8">';
$product_table .= '<tr valign="middle"><td align="right"><small><b>' . $languageStrings["SUMMARY"] . '</b></small></td></tr>';
if ($enable_summary_rebate) {
$product_table .= '<tr valign="middle"><td align="right"><small><b>' . $languageStrings["Discount Amount"] . '</b> :</small></td></tr>';
}
if ($enable_summary_taxpercentage && $final_details['taxtype'] == 'group') {
$product_table .= '<tr valign="middle"><td align="right"><small><b>' . $languageStrings["The percentage of tax"] . '</b> :</small></td></tr>';
}
if ($enable_summary_taxamount && $final_details['taxtype'] == 'group') {
$product_table .= '<tr valign="middle"><td align="right"><small><b>' . $languageStrings["The amount of tax"] . '</b> :</small></td></tr>';
}
if ($enable_summary_topay) {
$product_table .= '<tr valign="middle"><td align="right"><small><b>' . $languageStrings["Grand Total"] . '</b> :</small></td></tr>';
}
if ($enable_date_of_the_course == TRUE && $czyDrukowacKolumneZPrzeliczonymPodatkiem == TRUE) {
$product_table .= '<tr valign="middle"><td align="right"><small></small></td></tr>';
$product_table .= '<tr valign="middle"><td align="right"><small><b>' . $languageStrings["rate"] . ' ' . $kod_aktualnej_waluty . ' ' . $languageStrings["on"] . ': ' . $CurrencyUpdate->getCorrectDate($newdate) . '</b> </small></td></tr>';
}
$product_table .= '</table>
</td>
<td width="160px" ><br />
<table>';
$product_table .= '<tr valign="middle"><td align="left"> </td></tr><tr valign="middle"><td align="left"> </td></tr>';
if ($enable_summary_rebate) {
$product_table .= '<tr valign="middle"><td align="left"><small>' . number_format($rabat_calkowity, 2, $dec_sep, $group_sep) . ' (' . $symbol_waluty . ')</small></td></tr>';
}
if ($enable_summary_taxpercentage && $final_details['taxtype'] == 'group') {
$product_table .= '<tr valign="middle"><td align="left"><small>' . $grup_tax_percent . ' (%)</small></td></tr>';
}
if ($enable_summary_taxpercentage && $final_details['taxtype'] == 'group') {
$product_table .= '<tr valign="middle"><td align="left"><small>' . number_format($grup_tax, 2, $dec_sep, $group_sep) . ' (' . $symbol_waluty . ')</small></td></tr>';
}
if ($enable_summary_topay) {
$product_table .= '<tr valign="middle"><td align="left"><small>' . number_format($grand_total, 2, $dec_sep, $group_sep) . ' (' . $symbol_waluty . ')</small></td></tr>';
}
if ($enable_date_of_the_course == TRUE && $czyDrukowacKolumneZPrzeliczonymPodatkiem == TRUE) {
if ($kurs_waluty != 0) {
$product_table .= '<tr valign="middle"><td align="left"><small></small></td></tr>';
$product_table .= '<tr valign="middle"><td align="left"><small>' . $kurs_waluty . '</small></td></tr>';
} else {
$product_table .= '<tr valign="middle"><td align="left"><small></small></td></tr>';
$product_table .= '<tr valign="middle"><td align="left"><small>np</small></td></tr>';
}
}
$product_table .= '
</table>
</td>
</tr></table>
<br/>';
}
return $product_table;
}
}
public function addUserSearchConditions($input)
{
global $log, $default_charset;
if ($input['searchtype'] == 'advance') {
$json = new Zend_Json();
$advft_criteria = empty($input['advft_criteria']) ? $_REQUEST['advft_criteria'] : $input['advft_criteria'];
if (!empty($advft_criteria)) {
$advft_criteria = $json->decode($advft_criteria);
}
$advft_criteria_groups = empty($input['advft_criteria_groups']) ? $_REQUEST['advft_criteria_groups'] : $input['advft_criteria_groups'];
if (!empty($advft_criteria_groups)) {
$advft_criteria_groups = $json->decode($advft_criteria_groups);
}
if (empty($advft_criteria) || count($advft_criteria) <= 0) {
return;
}
$advfilterlist = getAdvancedSearchCriteriaList($advft_criteria, $advft_criteria_groups, $this->getModule());
if (empty($advfilterlist) || count($advfilterlist) <= 0) {
return;
}
if ($this->conditionInstanceCount > 0) {
$this->startGroup(self::$AND);
} else {
$this->startGroup('');
}
foreach ($advfilterlist as $groupindex => $groupcolumns) {
$filtercolumns = $groupcolumns['columns'];
if (count($filtercolumns) > 0) {
$this->startGroup('');
foreach ($filtercolumns as $index => $filter) {
$name = explode(':', $filter['columnname']);
if (empty($name[2]) && $name[1] == 'crmid' && $name[0] == 'vtiger_crmentity') {
$name = $this->getSQLColumn('id');
} else {
$name = $name[2];
}
$this->addCondition($name, $filter['value'], $filter['comparator']);
$columncondition = $filter['column_condition'];
if (!empty($columncondition)) {
$this->addConditionGlue($columncondition);
}
}
$this->endGroup();
$groupConditionGlue = $groupcolumns['condition'];
if (!empty($groupConditionGlue)) {
$this->addConditionGlue($groupConditionGlue);
}
}
}
$this->endGroup();
} elseif ($input['type'] == 'dbrd') {
if ($this->conditionInstanceCount > 0) {
$this->startGroup(self::$AND);
} else {
$this->startGroup('');
}
$allConditionsList = $this->getDashBoardConditionList();
$conditionList = $allConditionsList['conditions'];
$relatedConditionList = $allConditionsList['relatedConditions'];
$noOfConditions = count($conditionList);
$noOfRelatedConditions = count($relatedConditionList);
foreach ($conditionList as $index => $conditionInfo) {
$this->addCondition($conditionInfo['fieldname'], $conditionInfo['value'], $conditionInfo['operator']);
if ($index < $noOfConditions - 1 || $noOfRelatedConditions > 0) {
$this->addConditionGlue(self::$AND);
}
}
foreach ($relatedConditionList as $index => $conditionInfo) {
$this->addRelatedModuleCondition($conditionInfo['relatedModule'], $conditionInfo['conditionModule'], $conditionInfo['finalValue'], $conditionInfo['SQLOperator']);
if ($index < $noOfRelatedConditions - 1) {
$this->addConditionGlue(self::$AND);
}
}
$this->endGroup();
} else {
if (isset($input['search_field']) && $input['search_field'] != "") {
$fieldName = vtlib_purify($input['search_field']);
} else {
return;
}
if ($this->conditionInstanceCount > 0) {
$this->startGroup(self::$AND);
} else {
$this->startGroup('');
}
$moduleFields = $this->getModuleFields();
$field = $moduleFields[$fieldName];
$type = $field->getFieldDataType();
if (isset($input['search_text']) && $input['search_text'] != "") {
// search other characters like "|, ?, ?" by jagi
$value = $input['search_text'];
$stringConvert = function_exists(iconv) ? @iconv("UTF-8", $default_charset, $value) : $value;
if (!$this->isStringType($type)) {
$value = trim($stringConvert);
}
if ($type == 'picklist') {
global $currentModule;
if (!isValueInPicklist($value, $field->getFieldName())) {
$value = getTranslationKeyFromTranslatedValue($currentModule, $value);
}
}
if ($type == 'currency') {
// Some of the currency fields like Unit Price, Total, Sub-total etc of Inventory modules, do not need currency conversion
if ($field->getUIType() == '72') {
$value = CurrencyField::convertToDBFormat($value, null, true);
} else {
$currencyField = new CurrencyField($value);
if ($this->getModule() == 'Potentials' && $fieldName == 'amount') {
$currencyField->setNumberofDecimals(2);
}
$value = $currencyField->getDBInsertedValue();
}
}
}
if (!empty($input['operator'])) {
$operator = $input['operator'];
} elseif (trim(strtolower($value)) == 'null') {
$operator = 'e';
} else {
if (!$this->isNumericType($type) && !$this->isDateType($type)) {
$operator = 'c';
} else {
$operator = 'h';
}
}
$this->addCondition($fieldName, $value, $operator);
$this->endGroup();
}
}
