function getPickListOptions($fieldName) { $default_charset = VTWS_PreserveGlobal::getGlobal('default_charset'); $options = array(); $sql = "select * from vtiger_picklist where name=?"; $result = $this->pearDB->pquery($sql, array($fieldName)); $numRows = $this->pearDB->num_rows($result); if ($numRows == 0) { $sql = "select * from vtiger_{$fieldName}"; $result = $this->pearDB->pquery($sql, array()); $numRows = $this->pearDB->num_rows($result); for ($i = 0; $i < $numRows; ++$i) { $elem = array(); $picklistValue = $this->pearDB->query_result($result, $i, $fieldName); $picklistValue = html_entity_decode($picklistValue, ENT_QUOTES, $default_charset); $elem["label"] = getTranslatedString($picklistValue, $this->getMeta()->getTabName()); $elem["value"] = $picklistValue; array_push($options, $elem); } } else { $details = getPickListValues($fieldName, $this->user->roleid); for ($i = 0; $i < sizeof($details); ++$i) { $elem = array(); $picklistValue = html_entity_decode($details[$i], ENT_QUOTES, $default_charset); $elem["label"] = getTranslatedString($picklistValue, $this->getMeta()->getTabName()); $elem["value"] = $picklistValue; array_push($options, $elem); } } return $options; }
function getPickListOptions() { $fieldName = $this->getFieldName(); $default_charset = VTWS_PreserveGlobal::getGlobal('default_charset'); $options = array(); $sql = "select * from vtiger_picklist where name=?"; $result = $this->pearDB->pquery($sql, array($fieldName)); $numRows = $this->pearDB->num_rows($result); if ($numRows == 0) { $sql = "select * from vtiger_{$fieldName}"; $result = $this->pearDB->pquery($sql, array()); $numRows = $this->pearDB->num_rows($result); for ($i = 0; $i < $numRows; ++$i) { $elem = array(); $picklistValue = $this->pearDB->query_result($result, $i, $fieldName); $picklistValue = decode_html($picklistValue); $moduleName = getTabModuleName($this->getTabId()); if ($moduleName == 'Events') { $moduleName = 'Calendar'; } $elem["label"] = getTranslatedString($picklistValue, $moduleName); $elem["value"] = $picklistValue; array_push($options, $elem); } } else { $user = VTWS_PreserveGlobal::getGlobal('current_user'); $details = getPickListValues($fieldName, $user->roleid); for ($i = 0; $i < sizeof($details); ++$i) { $elem = array(); $picklistValue = decode_html($details[$i]); $moduleName = getTabModuleName($this->getTabId()); if ($moduleName == 'Events') { $moduleName = 'Calendar'; } $elem["label"] = getTranslatedString($picklistValue, $moduleName); $elem["value"] = $picklistValue; array_push($options, $elem); } } return $options; }
function getPickListOptions() { global $app_strings, $mod_strings, $log, $current_language; static $purified_plcache = array(); $fieldName = $this->getFieldName(); $default_charset = VTWS_PreserveGlobal::getGlobal('default_charset'); $moduleName = getTabModuleName($this->getTabId()); if ($moduleName == 'Events') { $moduleName = 'Calendar'; } $temp_mod_strings = $moduleName != '' ? return_module_language($current_language, $moduleName) : $mod_strings; if (array_key_exists($moduleName . $fieldName, $purified_plcache)) { return $purified_plcache[$moduleName . $fieldName]; } $options = array(); $sql = "select * from vtiger_picklist where name=?"; $result = $this->pearDB->pquery($sql, array($fieldName)); $numRows = $this->pearDB->num_rows($result); if ($numRows == 0) { $sql = "select * from vtiger_{$fieldName}"; $result = $this->pearDB->pquery($sql, array()); $numRows = $this->pearDB->num_rows($result); for ($i = 0; $i < $numRows; ++$i) { $elem = array(); $picklistValue = $this->pearDB->query_result($result, $i, $fieldName); $picklistValue = decode_html($picklistValue); $trans_str = $temp_mod_strings[$picklistValue] != '' ? $temp_mod_strings[$picklistValue] : ($app_strings[$picklistValue] != '' ? $app_strings[$picklistValue] : $picklistValue); while ($trans_str != preg_replace('/(.*) {.+}(.*)/', '$1$2', $trans_str)) { $trans_str = preg_replace('/(.*) {.+}(.*)/', '$1$2', $trans_str); } $elem["label"] = $trans_str; $elem["value"] = $picklistValue; array_push($options, $elem); } } else { $user = VTWS_PreserveGlobal::getGlobal('current_user'); $details = getPickListValues($fieldName, $user->roleid); for ($i = 0; $i < sizeof($details); ++$i) { $elem = array(); $picklistValue = decode_html($details[$i]); $trans_str = $temp_mod_strings[$picklistValue] != '' ? $temp_mod_strings[$picklistValue] : ($app_strings[$picklistValue] != '' ? $app_strings[$picklistValue] : $picklistValue); while ($trans_str != preg_replace('/(.*) {.+}(.*)/', '$1$2', $trans_str)) { $trans_str = preg_replace('/(.*) {.+}(.*)/', '$1$2', $trans_str); } $elem["label"] = $trans_str; $elem["value"] = $picklistValue; array_push($options, $elem); } } $purified_plcache[$moduleName . $fieldName] = $options; return $options; }
/** Function to get picklist fields for the given module * @ param $fld_module * It gets the picklist details array for the given module in the given format * $fieldlist = Array(Array('fieldlabel'=>$fieldlabel,'generatedtype'=>$generatedtype,'columnname'=>$columnname,'fieldname'=>$fieldname,'value'=>picklistvalues)) */ function getUserFldArray($fld_module) { global $adb; $user_fld = array(); $tabid = getTabid($fldmodule); $query = "select fieldlabel,generatedtype,columnname,fieldname,uitype from ec_field inner join ec_def_org_field on ec_def_org_field.fieldid=ec_field.fieldid where (ec_field.tabid = " . getTabid($fld_module) . " AND ec_field.uitype IN (15,16, 111,33)) OR (ec_field.tabid = " . getTabid($fld_module) . " AND ec_field.fieldname='salutationtype')"; $result = $adb->query($query); $noofrows = $adb->num_rows($result); if ($noofrows > 0) { $fieldlist = array(); for ($i = 0; $i < $noofrows; $i++) { $user_fld = array(); $fld_name = $adb->query_result($result, $i, "fieldname"); if ($fld_module == 'Events') { if ($adb->query_result($result, $i, "fieldname") != 'recurringtype' && $adb->query_result($result, $i, "fieldname") != 'activitytype' && $adb->query_result($result, $i, "fieldname") != 'visibility') { $user_fld['fieldlabel'] = $adb->query_result($result, $i, "fieldlabel"); $user_fld['generatedtype'] = $adb->query_result($result, $i, "generatedtype"); $user_fld['columnname'] = $adb->query_result($result, $i, "columnname"); $user_fld['fieldname'] = $adb->query_result($result, $i, "fieldname"); $user_fld['uitype'] = $adb->query_result($result, $i, "uitype"); $user_fld['value'] = getPickListValues($user_fld['fieldname']); $fieldlist[] = $user_fld; } } else { $user_fld['fieldlabel'] = $adb->query_result($result, $i, "fieldlabel"); $user_fld['generatedtype'] = $adb->query_result($result, $i, "generatedtype"); $user_fld['columnname'] = $adb->query_result($result, $i, "columnname"); $user_fld['fieldname'] = $adb->query_result($result, $i, "fieldname"); $user_fld['uitype'] = $adb->query_result($result, $i, "uitype"); $user_fld['value'] = getPickListValues($user_fld['fieldname']); $fieldlist[] = $user_fld; } } } return $fieldlist; }