/**
* this function takes in a module name and returns the field information for it
*/
function getInformationArray($module)
{
require_once 'include/utils/utils.php';
global $adb;
$tabid = getTabid($module);
$result = $adb->pquery("select * from vtiger_field where tabid=?", array($tabid));
$count = $adb->num_rows($result);
$arr = array();
$data = array();
for ($i = 0; $i < $count; $i++) {
$arr['uitype'] = $adb->query_result($result, $i, "uitype");
$arr['fieldname'] = $adb->query_result($result, $i, "fieldname");
$arr['columnname'] = $adb->query_result($result, $i, "columnname");
$arr['tablename'] = $adb->query_result($result, $i, "tablename");
$arr['fieldlabel'] = $adb->query_result($result, $i, "fieldlabel");
$arr['typeofdata'] = $adb->query_result($result, $i, "typeofdata");
$fieldlabel = strtolower($arr['fieldlabel']);
$data[$fieldlabel] = $arr;
}
if (in_array($module, getInventoryModules())) {
include_once 'include/fields/InventoryLineField.php';
$ilfields = new InventoryLineField();
$data = array_merge($data, $ilfields->getInventoryLineFieldsByLabel());
}
return $data;
}
function getInventoryFieldsForExport($tableName)
{
$sql = ',' . $tableName . '.adjustment AS "Adjustment", ' . $tableName . '.total AS "Total", ' . $tableName . '.subtotal AS "Sub Total", ';
$sql .= $tableName . '.taxtype AS "Tax Type", ' . $tableName . '.discount_amount AS "Discount Amount", ';
$sql .= $tableName . '.discount_percent AS "Discount Percent", ' . $tableName . '.s_h_amount AS "S&H Amount", ';
$sql .= 'vtiger_currency_info.currency_name as "Currency",';
include_once 'include/fields/InventoryLineField.php';
$ilfields = new InventoryLineField();
$inventory_fields = $ilfields->getInventoryLineFieldsByLabel();
foreach ($inventory_fields as $fdesc) {
$sql .= $fdesc['tablename'] . '.' . $fdesc['columnname'] . ' AS "' . $fdesc['fieldlabel'] . '",';
}
$sql = rtrim($sql, ',') . ' ';
return $sql;
}