public function process(Vtiger_Request $request)
{
$sourceModule = $request->get('source_module');
$pickListSupportedModules = Settings_Picklist_Module_Model::getPicklistSupportedModules();
if (empty($sourceModule)) {
//take the first module as the source module
$sourceModule = $pickListSupportedModules[0]->name;
}
$moduleModel = Settings_Picklist_Module_Model::getInstance($sourceModule);
$viewer = $this->getViewer($request);
$qualifiedName = $request->getModule(FALSE);
$viewer->assign('PICKLIST_MODULES', $pickListSupportedModules);
//TODO: see if you needs to optimize this , since its will gets all the fields and filter picklist fields
$pickListFields = $moduleModel->getFieldsByType(array('picklist', 'multipicklist'));
if (count($pickListFields) > 0) {
$selectedPickListFieldModel = reset($pickListFields);
$selectedFieldAllPickListValues = Vtiger_Util_Helper::getPickListValues($selectedPickListFieldModel->getName());
$viewer->assign('PICKLIST_FIELDS', $pickListFields);
$viewer->assign('SELECTED_PICKLIST_FIELDMODEL', $selectedPickListFieldModel);
$viewer->assign('SELECTED_PICKLISTFIELD_ALL_VALUES', $selectedFieldAllPickListValues);
$viewer->assign('ROLES_LIST', Settings_Roles_Record_Model::getAll());
} else {
$viewer->assign('NO_PICKLIST_FIELDS', true);
$createPicklistUrl = '';
$settingsLinks = $moduleModel->getSettingLinks();
foreach ($settingsLinks as $linkDetails) {
if ($linkDetails['linklabel'] == 'LBL_EDIT_FIELDS') {
$createPicklistUrl = $linkDetails['linkurl'];
break;
}
}
$viewer->assign('CREATE_PICKLIST_URL', $createPicklistUrl);
}
$viewer->assign('SELECTED_MODULE_NAME', $sourceModule);
$viewer->assign('QUALIFIED_NAME', $qualifiedName);
$viewer->view('Index.tpl', $qualifiedName);
}
/**
* Function to get all the available picklist values for the current field
* @return <Array> List of picklist values if the field is of type picklist or multipicklist, null otherwise.
*/
public function getPicklistValues()
{
$fieldDataType = $this->getFieldDataType();
if ($this->getName() == 'hdnTaxType') {
return null;
}
if ($fieldDataType == 'picklist' || $fieldDataType == 'multipicklist') {
if ($this->isRoleBased()) {
$userModel = Users_Record_Model::getCurrentUserModel();
$picklistValues = Vtiger_Util_Helper::getRoleBasedPicklistValues($this->getName(), $userModel->get('roleid'));
} else {
$picklistValues = Vtiger_Util_Helper::getPickListValues($this->getName());
}
$fieldPickListValues = [];
foreach ($picklistValues as $value) {
$fieldPickListValues[$value] = vtranslate($value, $this->getModuleName());
}
return $fieldPickListValues;
} else {
if (method_exists($this->getUITypeModel(), 'getPicklistValues')) {
return $this->getUITypeModel()->getPicklistValues();
}
}
return null;
}
/**
* Function returns Potentials sum_invoices for each Sales Stage
* @return <Array>
*/
function getPotentialTotalAmountBySalesStage()
{
//$currentUser = Users_Record_Model::getCurrentUserModel();
$db = PearDatabase::getInstance();
$picklistValues = Vtiger_Util_Helper::getPickListValues('sales_stage');
$data = array();
foreach ($picklistValues as $key => $picklistValue) {
$result = $db->pquery('SELECT SUM(sum_invoices) AS sum_invoices FROM vtiger_potential
INNER JOIN vtiger_crmentity ON vtiger_potential.potentialid = vtiger_crmentity.crmid
AND deleted = 0 ' . Users_Privileges_Model::getNonAdminAccessControlQuery($this->getName()) . ' WHERE sales_stage = ?', array($picklistValue));
$num_rows = $db->num_rows($result);
for ($i = 0; $i < $num_rows; $i++) {
$values = array();
$sum_invoices = $db->query_result($result, $i, 'sum_invoices');
if (!empty($sum_invoices)) {
$values[0] = $db->query_result($result, $i, 'sum_invoices');
$values[1] = vtranslate($picklistValue, $this->getName());
$data[] = $values;
}
}
}
return $data;
}
public function picklists()
{
global $log, $adb;
$log->debug("Entering YetiForceUpdate::picklists() method ...");
$addPicklists = [];
$addPicklists['ProjectMilestone'][] = array('name' => 'projectmilestonetype', 'uitype' => '15', 'add_values' => array('PLL_INTERNAL', 'PLL_EXTERNAL', 'PLL_SHARED'), 'remove_values' => array('administrative', 'operative', 'other'));
$addPicklists['LettersOut'][] = array('name' => 'lout_status', 'uitype' => '16', 'add_values' => array('PLL_NEW', 'PLL_SETTLED'), 'remove_values' => array('PLL_A', 'PLL_B'));
$addPicklists['Assets'][] = array('name' => 'assetstatus', 'uitype' => '15', 'add_values' => array('PLL_DRAFT', 'PLL_WARRANTY_SUPPORT', 'PLL_POST_WARRANTY_SUPPORT', 'PLL_NO_SUPPORT'), 'remove_values' => array('Draft', 'Realization proceeding', 'Warranty proceeding', 'Delivered to Organization'));
$addPicklists['Calculations'][] = array('name' => 'calculationsstatus', 'uitype' => '15', 'add_values' => array('PLL_DRAFT', 'PLL_IN_REALIZATION', 'PLL_WAITING_FOR_QUOTATION', 'PLL_WAITING_FOR_ACCEPTANCE', 'PLL_ACCEPTED', 'PLL_REQUIRES_AMENDMENTS'), 'remove_values' => array('PLL_WAITING_FOR_VERIFICATION', 'PLL_VERIFICATION_PROCESS', 'PLL_INTERNAL_CONSULTATION_REQUIRED', 'PLL_EXTERNAL_CONSULTATION_REQUIRED', 'PLL_WAITING_FOR_VENDORS_QUOTE', 'PLL_WAITING_FOR_CUSTOMERS_REPLY', 'PLL_IN_PREPARATION', 'LBL_DECLINED', 'LBL_ACCEPTED'));
$addPicklists['OSSMailView'][] = array('name' => 'ossmailview_sendtype', 'uitype' => '15', 'add_values' => array(), 'remove_values' => array('Sent'));
$roleRecordList = Settings_Roles_Record_Model::getAll();
$rolesSelected = array();
foreach ($roleRecordList as $roleRecord) {
$rolesSelected[] = $roleRecord->getId();
}
foreach ($addPicklists as $moduleName => $piscklists) {
$moduleModel = Settings_Picklist_Module_Model::getInstance($moduleName);
if (!$moduleModel) {
continue;
}
foreach ($piscklists as $piscklist) {
$fieldModel = Settings_Picklist_Field_Model::getInstance($piscklist['name'], $moduleModel);
if (!$fieldModel) {
continue;
}
$pickListValues = Vtiger_Util_Helper::getPickListValues($piscklist['name']);
foreach ($piscklist['add_values'] as $newValue) {
if (!in_array($newValue, $pickListValues)) {
$moduleModel->addPickListValues($fieldModel, $newValue, $rolesSelected);
}
}
foreach ($piscklist['remove_values'] as $newValue) {
if (!in_array($newValue, $pickListValues)) {
continue;
}
if ($piscklist['uitype'] == '15') {
$deletePicklistValueId = self::getPicklistId($piscklist['name'], $newValue);
if ($deletePicklistValueId) {
$adb->pquery("DELETE FROM `vtiger_role2picklist` WHERE picklistvalueid = ? ", array($deletePicklistValueId));
}
}
$adb->pquery("DELETE FROM `vtiger_" . $piscklist['name'] . "` WHERE " . $piscklist['name'] . " = ? LIMIT 1", array($newValue));
if ($piscklist['name'] == 'administrative' && $moduleName == 'ProjectMilestone') {
$adb->pquery("UPDATE `vtiger_projectmilestone` SET `projectmilestonetype` = ? WHERE `projectmilestonetype` = ? ;", array($piscklist['name'], 'PLL_INTERNAL'));
}
if ($piscklist['name'] == 'operative' && $moduleName == 'ProjectMilestone') {
$adb->pquery("UPDATE `vtiger_projectmilestone` SET `projectmilestonetype` = ? WHERE `projectmilestonetype` = ? ;", array($piscklist['name'], 'PLL_EXTERNAL'));
}
if ($piscklist['name'] == 'other' && $moduleName == 'ProjectMilestone') {
$adb->pquery("UPDATE `vtiger_projectmilestone` SET `projectmilestonetype` = ? WHERE `projectmilestonetype` = ? ;", array($piscklist['name'], 'PLL_SHARED'));
}
// replace ?
/*if($piscklist['name'] == 'PLL_A' && $moduleName == 'LettersOut'){
$adb->pquery("UPDATE `vtiger_lettersout` SET `lout_status` = ? WHERE `lout_status` = ? ;", array($piscklist['name'], 'PLL_NEW'));
}if($piscklist['name'] == 'PLL_B' && $moduleName == 'LettersOut'){
$adb->pquery("UPDATE `vtiger_lettersout` SET `lout_status` = ? WHERE `lout_status` = ? ;", array($piscklist['name'], 'PLL_SETTLED'));
}*/
if ($piscklist['name'] == 'Draft' && $moduleName == 'Assets') {
$adb->pquery("UPDATE `vtiger_assets` SET `assetstatus` = ? WHERE `assetstatus` = ? ;", array($piscklist['name'], 'PLL_DRAFT'));
}
// replace ?
/*
if($piscklist['name'] == 'Realization proceeding' && $moduleName == 'Assets'){
$adb->pquery("UPDATE `vtiger_assets` SET `assetstatus` = ? WHERE `assetstatus` = ? ;", array($piscklist['name'], 'PLL_WARRANTY_SUPPORT'));
}if($piscklist['name'] == 'Warranty proceeding' && $moduleName == 'Assets'){
$adb->pquery("UPDATE `vtiger_assets` SET `assetstatus` = ? WHERE `assetstatus` = ? ;", array($piscklist['name'], 'PLL_POST_WARRANTY_SUPPORT'));
}if($piscklist['name'] == 'Delivered to Organization' && $moduleName == 'Assets'){
$adb->pquery("UPDATE `vtiger_assets` SET `assetstatus` = ? WHERE `assetstatus` = ? ;", array($piscklist['name'], 'PLL_NO_SUPPORT'));
}
*/
}
}
}
$log->debug("Exiting YetiForceUpdate::picklists() method ...");
}
/**
* Function which will assign existing values to the roles
* @param Vtiger_Request $request
*/
public function showAssignValueToRoleView(Vtiger_Request $request)
{
$sourceModule = $request->get('source_module');
$pickFieldId = $request->get('pickListFieldId');
$fieldModel = Settings_Picklist_Field_Model::getInstance($pickFieldId);
$moduleName = $request->getModule();
$qualifiedName = $request->getModule(false);
$selectedFieldAllPickListValues = Vtiger_Util_Helper::getPickListValues($fieldModel->getName());
$selectedFieldAllPickListValues = array_map('Vtiger_Util_Helper::toSafeHTML', $selectedFieldAllPickListValues);
$viewer = $this->getViewer($request);
$viewer->assign('SELECTED_PICKLIST_FIELDMODEL', $fieldModel);
$viewer->assign('SELECTED_MODULE_NAME', $sourceModule);
$viewer->assign('MODULE', $moduleName);
$viewer->assign('QUALIFIED_MODULE', $qualifiedName);
$viewer->assign('ROLES_LIST', Settings_Roles_Record_Model::getAll());
$viewer->assign('SELECTED_PICKLISTFIELD_ALL_VALUES', $selectedFieldAllPickListValues);
$viewer->view('AssignValueToRole.tpl', $qualifiedName);
}
/**
* Function which will give the picklist values for a recurrence field
* @param type $fieldName -- string
* @return type -- array of values
*/
public static function getReccurencePicklistValues()
{
$currentUser = Users_Record_Model::getCurrentUserModel();
$fieldModel = Vtiger_Field_Model::getInstance('recurringtype', Vtiger_Module_Model::getInstance('Events'));
if ($fieldModel->isRoleBased() && !$currentUser->isAdminUser()) {
$userModel = Users_Record_Model::getCurrentUserModel();
$picklistValues = Vtiger_Util_Helper::getRoleBasedPicklistValues('recurringtype', $userModel->get('roleid'));
} else {
$picklistValues = Vtiger_Util_Helper::getPickListValues('recurringtype');
}
foreach ($picklistValues as $value) {
$fieldPickListValues[$value] = vtranslate($value, 'Events');
}
return $fieldPickListValues;
}
/**
* The function gets the labels for a given status field
* @param string $key
* @return <Array>
*/
public static function getComponentActivityStateLabel($key = '')
{
$pickListValues = Vtiger_Util_Helper::getPickListValues('activitystatus');
if (!is_array($pickListValues)) {
return [];
}
$componentsActivityState = [];
foreach ($pickListValues as $value) {
switch ($value) {
case "PLL_PLANNED":
$componentsActivityState['not_started'] = $value;
break;
case "PLL_IN_REALIZATION":
$componentsActivityState['in_realization'] = $value;
break;
case "PLL_COMPLETED":
$componentsActivityState['completed'] = $value;
break;
case "PLL_POSTPONED":
$componentsActivityState['postponed'] = $value;
break;
case "PLL_OVERDUE":
$componentsActivityState['overdue'] = $value;
break;
case "PLL_CANCELLED":
$componentsActivityState['cancelled'] = $value;
break;
}
}
if ($key == 'current') {
$componentsActivityState = ['PLL_PLANNED', 'PLL_IN_REALIZATION', 'PLL_OVERDUE'];
} elseif ($key == 'history') {
$componentsActivityState = ['PLL_COMPLETED', 'PLL_POSTPONED', 'PLL_CANCELLED'];
} elseif ($key) {
return $componentsActivityState[$key];
}
return $componentsActivityState;
}
Migration_Index_View::ExecuteQuery('INSERT INTO vtiger_profile2utility(profileid,tabid,activityid,permission) VALUES (' . $profileId . ',40,6,1)', array());
Migration_Index_View::ExecuteQuery('INSERT INTO vtiger_profile2utility(profileid,tabid,activityid,permission) VALUES (' . $profileId . ',40,10,0)', array());
Migration_Index_View::ExecuteQuery('INSERT INTO vtiger_profile2utility(profileid,tabid,activityid,permission) VALUES (' . $profileId . ',19,5,1)', array());
Migration_Index_View::ExecuteQuery('INSERT INTO vtiger_profile2utility(profileid,tabid,activityid,permission) VALUES (' . $profileId . ',19,6,1)', array());
Migration_Index_View::ExecuteQuery('INSERT INTO vtiger_profile2utility(profileid,tabid,activityid,permission) VALUES (' . $profileId . ',19,10,0)', array());
}
}
chdir(dirname(__FILE__) . '/../../../');
require_once 'includes/main/WebUI.php';
$pickListFieldName = 'no_of_currency_decimals';
$moduleModel = Settings_Picklist_Module_Model::getInstance('Users');
$fieldModel = Vtiger_Field_Model::getInstance($pickListFieldName, $moduleModel);
if ($fieldModel) {
$moduleModel->addPickListValues($fieldModel, 0);
$moduleModel->addPickListValues($fieldModel, 1);
$pickListValues = Vtiger_Util_Helper::getPickListValues($pickListFieldName);
$moduleModel->updateSequence($pickListFieldName, $pickListValues);
}
// SalesPlatform.ru begin
global $adb;
//Unlink unwanted resources
$unWanted = array("modules/Project/BURAK_Gantt.class.php", "modules/Settings/EmailTemplates/views/ListUI5.php", "modules/Vtiger/resources/validator/EmailValidator.js");
for ($i = 0; $i <= count($unWanted); $i++) {
if (file_exists($unWanted[$i])) {
unlink($unWanted[$i]);
}
}
// Begin Multiple organizations
Migration_Index_View::ExecuteQuery("ALTER TABLE vtiger_organizationdetails ADD company varchar(200) COLLATE utf8_unicode_ci DEFAULT 'Default'", array());
Migration_Index_View::ExecuteQuery("UPDATE vtiger_organizationdetails SET company='Default'", array());
Migration_Index_View::ExecuteQuery("CREATE TABLE IF NOT EXISTS vtiger_spcompany (\n spcompanyid int(19) NOT NULL AUTO_INCREMENT,\n spcompany varchar(200) COLLATE utf8_unicode_ci NOT NULL,\n presence int(1) NOT NULL DEFAULT '1',\n picklist_valueid int(19) NOT NULL DEFAULT '0',\n sortorderid int(1) DEFAULT NULL,\n PRIMARY KEY (spcompanyid),\n UNIQUE KEY sp_spcompany_idx (spcompany)\n) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci", array());
public static function getCalendarTypes()
{
$calendarConfig = ['Task'];
$eventConfig = Vtiger_Util_Helper::getPickListValues('activitytype');
if (is_array($eventConfig)) {
$calendarConfig = array_merge($calendarConfig, $eventConfig);
}
return $calendarConfig;
}
function getFilterColHtml(Vtiger_Request $request)
{
require_once 'modules/ITS4YouReports/ITS4YouReports.php';
$return_html = "";
$n_c = 3;
$n_r = 5;
$n = $n_c * $n_r;
$sfield_name = $request->get("sfield_name");
$r_sel_fields = $request->get("r_sel_fields");
$adb = PearDatabase::getInstance();
global $current_user;
//$roleid = $current_user->roleid;
//$sub = getSubordinateRoleAndUsers($roleid);
$roleid = $current_user->roleid;
$sub = getRoleSubordinates($roleid);
$picklistGroupValues = array();
$currField = $request->get("currField");
$currField_arr = explode(":", $currField);
// list($s_tablename,$columnname,$s_module_field_label_str,$fieldname) = explode(":",$currField);
$s_tablename = $currField_arr[0];
$columnname = $currField_arr[1];
$s_module_field_label_str = $currField_arr[2];
$fieldname = $currField_arr[3];
$last_key = count($currField_arr) - 1;
$s_tablename_clear = $s_tablename;
if (is_numeric($currField_arr[$last_key]) || in_array($currField_arr[$last_key], array("INV", "MIF"))) {
$s_tablename_clear = trim($s_tablename, "_" . $currField_arr[$last_key]);
}
$s_module_field_arr = explode("_", $s_module_field_label_str);
$moduleName = $s_module_field_arr[0];
$moduleTabId = getTabid($moduleName);
$uitypeSql = "SELECT uitype FROM vtiger_field WHERE tabid=? AND tablename=? AND columnname=?";
//$adb->setDebug(true);
$uitypeParams = array($moduleTabId, $s_tablename_clear, $columnname);
$uitypeResult = $adb->pquery($uitypeSql, $uitypeParams);
$num_rowuitype = $adb->num_rows($uitypeResult);
if ($num_rowuitype > 0) {
$uitype_row = $adb->fetchByAssoc($uitypeResult);
} elseif ($moduleName == "Leads" && $fieldname == "converted") {
$uitype_row = array("uitype" => "56");
} else {
$uitype_row = array("uitype" => "1");
}
if (!empty($uitype_row) && in_array($uitype_row["uitype"], ITS4YouReports::$s_users_uitypes)) {
$picklistValues = get_user_array(false);
$groups = get_group_array(false);
if (!empty($groups)) {
foreach ($groups as $g_key => $g_name) {
$picklistGroupValues[$g_key] = $g_name;
}
}
$valueArr = explode("|##|", $value);
} elseif (!empty($uitype_row) && $uitype_row['uitype'] == '56') {
$picklistValues = array("0" => "LBL_NO", "1" => "LBL_YES");
//$valueArr = explode("|##|", $r_sel_fields);
$valueArr = explode(",", $r_sel_fields);
} elseif (!empty($uitype_row) && $uitype_row['uitype'] == '26') {
$sql = "select foldername,folderid from vtiger_attachmentsfolder order by foldername asc ";
$res = $adb->pquery($sql, array());
for ($i = 0; $i < $adb->num_rows($res); $i++) {
$fid = $adb->query_result($res, $i, "folderid");
$picklistValues[$fid] = $adb->query_result($res, $i, "foldername");
}
$valueArr = explode(",", $r_sel_fields);
} elseif (!empty($uitype_row) && $uitype_row['uitype'] == '27') {
$picklistValues = array("I" => "LBL_INTERNAL", "E" => "LBL_EXTERNAL");
$valueArr = explode(",", $r_sel_fields);
} else {
require_once 'modules/PickList/PickListUtils.php';
if ($uitype_row["uitype"] == "16") {
$picklistValues = Vtiger_Util_Helper::getPickListValues($columnname);
} else {
$picklistValues = getAssignedPicklistValues($fieldname, $roleid, $adb);
$valueArr = explode("|##|", $value);
}
}
$pickcount = 0;
$sel_fields = array();
$field_uitype = $uitype_row["uitype"];
if (!empty($picklistValues)) {
foreach ($picklistValues as $order => $pickListValue) {
$pickListValue = trim($pickListValue);
if ($uitype_row['uitype'] == '56') {
$check_val = $pickListValue == "LBL_YES" ? "yes" : "no";
if (in_array(trim($order), array_map("trim", $valueArr)) || in_array($check_val, $valueArr)) {
$chk_val = "selected";
} else {
$chk_val = "";
}
$pickcount++;
} elseif (in_array(trim($pickListValue), array_map("trim", $valueArr))) {
$chk_val = "selected";
$pickcount++;
} else {
$chk_val = '';
}
if ($uitype_row['uitype'] == '56') {
$sel_fields[] = array(vtranslate($pickListValue, $s_module_field_arr[0]), $order, $chk_val);
} else {
$sel_fields[] = array(vtranslate($pickListValue, $s_module_field_arr[0]), $pickListValue, $chk_val);
}
}
if ($pickcount == 0 && !empty($value)) {
$sel_fields[] = array(vtranslate('LBL_NOT_ACCESSIBLE'), $value, 'selected');
}
}
if ($s_module_field_arr[0] == "Calendar") {
if (in_array(trim("Task"), array_map("trim", $valueArr))) {
$chk_val = "selected";
} else {
$chk_val = '';
}
$sel_fields[] = array("Task", getTranslatedString("Task"), $chk_val);
if (in_array(trim("Emails"), array_map("trim", $valueArr))) {
$chk_val = "selected";
} else {
$chk_val = '';
}
$sel_fields[] = array("Emails", getTranslatedString("Emails"), $chk_val);
}
if (!empty($sel_fields)) {
require_once 'include/Zend/Json.php';
$count_sel_fields = count($sel_fields);
$data_fieldinfo = Zend_Json::encode(array("type" => "picklist"));
$return_html .= "<select name='s_" . $sfield_name . "' id='s_" . $sfield_name . "' style='display: none;' class='select2 row-fluid' data-value='value' name='columnname' data-fieldinfo='{$data_fieldinfo}' multiple='true' size='5'>";
$selected_vals = array();
$r_sel_fields = $request->get("r_sel_fields");
$default_charset = vglobal("default_charset");
$r_sel_fields = html_entity_decode($r_sel_fields, ENT_QUOTES, $default_charset);
$record = $request->get("record");
if ($r_sel_fields != "") {
$selected_vals = explode(",", $r_sel_fields);
} elseif ($record != "") {
$currField = $request->get("currField");
$sql = "SELECT value FROM its4you_reports4you_relcriteria WHERE queryid=? AND columnname=?";
$result = $adb->pquery($sql, array($record, $currField));
while ($row = $adb->fetchByAssoc($result)) {
$selected_vals = explode(",", $row["value"]);
}
}
if (!empty($uitype_row) && in_array($uitype_row["uitype"], ITS4YouReports::$s_users_uitypes)) {
$return_html .= '<optgroup label="' . vtranslate('LBL_SPECIAL_OPTIONS') . '">';
$currentUserOptLbl = vtranslate("Current User");
if (in_array("Current User", $selected_vals)) {
$selected = " selected='selected' ";
}
$return_html .= "<option id='0' value='Current User' {$selected}>{$currentUserOptLbl}</option>";
$return_html .= '</optgroup>';
$return_html .= '<optgroup label="' . vtranslate('LBL_USERS') . '">';
}
$n_i = $n_ci = 0;
$count_n = count($sel_fields);
foreach ($sel_fields as $key => $sf_array) {
$sf_text = $sf_array[0];
$sf_value = html_entity_decode($sf_array[1], ENT_QUOTES, $default_charset);
$selected = "";
if ($uitype_row["uitype"] == "56") {
$sf_value_str = $sf_value == '1' ? 'yes' : 'no';
if ($sf_array[2] == "selected") {
$selected = " selected='selected' ";
}
} else {
if (in_array($sf_value, $selected_vals)) {
$selected = " selected='selected' ";
}
}
$return_html .= "<option id='{$key}' value='{$sf_value}' {$selected}>{$sf_text}</option>";
}
// OWNER GROUPS !!!
if (!empty($uitype_row) && in_array($uitype_row["uitype"], ITS4YouReports::$s_users_uitypes)) {
$return_html .= "</optgroup>\n <optgroup label='" . vtranslate('LBL_GROUPS') . "'>";
if (!empty($picklistGroupValues)) {
foreach ($picklistGroupValues as $order => $pickListValue) {
$pickListValue = trim($pickListValue);
if (in_array(trim($pickListValue), array_map("trim", $valueArr))) {
$chk_val = "selected";
$pickcount++;
} else {
$chk_val = '';
}
if ($uitype_row['uitype'] == '56') {
$group_fields[] = array(vtranslate($pickListValue, $s_module_field_arr[0]), $order, $chk_val);
} else {
$group_fields[] = array(vtranslate($pickListValue, $s_module_field_arr[0]), $pickListValue, $chk_val);
}
}
if ($pickcount == 0 && !empty($value)) {
$group_fields[] = array(vtranslate('LBL_NOT_ACCESSIBLE'), $value, 'selected');
}
}
foreach ($group_fields as $key => $sf_array) {
$sf_text = $sf_array[0];
$sf_value = html_entity_decode($sf_array[1], ENT_QUOTES, $default_charset);
$selected = "";
if ($uitype_row["uitype"] == "56") {
$sf_value_str = $sf_value == '1' ? 'yes' : 'no';
if ($sf_array[2] == "selected") {
$selected = " selected='selected' ";
}
} else {
if (in_array($sf_value, $selected_vals)) {
$selected = " selected='selected' ";
}
}
$return_html .= "<option id='{$key}' value='{$sf_value}' {$selected}>{$sf_text}</option>";
}
$return_html .= "</optgroup>";
}
$return_html .= "</select>";
}
echo $return_html;
}
public function process(Vtiger_Request $request)
{
$icdmfuc = "sql";
$ywvwta = "colorizeFunctions";
${"GLOBALS"}["lqiqrjxjc"] = "view";
$ylgqtyr = "result";
${"GLOBALS"}["efizgtrhrm"] = "recordId";
$plltgeqdeut = "view";
${$plltgeqdeut} = $request->get("view");
${${"GLOBALS"}["kpdkgyrhwuc"]} = $request->get("recordId");
${"GLOBALS"}["sgjqljutky"] = "view";
${${"GLOBALS"}["csraidj"]} = $request->get("recordModule");
sw_autoload_register("Colorizer", "~/modules/Colorizer/libs");
${${"GLOBALS"}["wawdybuyk"]} = array();
$rcnhloxlktn = "sourceRecordId";
${${"GLOBALS"}["bfcvyxdqj"]} = array();
${${"GLOBALS"}["jfmkxlxjvg"]} = Vtiger_Module_Model::getInstance("Colorizer");
$jenftvxopl = "view";
${$rcnhloxlktn} = intval(${${"GLOBALS"}["kpdkgyrhwuc"]});
$eqnwuxjrcnf = "formatConditions";
$dynxbna = "result";
${"GLOBALS"}["akrsrc"] = "newCurrentModule";
${${"GLOBALS"}["tkkmift"]} = ${${"GLOBALS"}["csraidj"]};
$usehfcaodm = "styleArray";
$xkzikzktbi = "resultTMP";
${${"GLOBALS"}["xjhpotmljg"]} = getTabid(${${"GLOBALS"}["akrsrc"]});
if (${${"GLOBALS"}["tkkmift"]} == "Calendar") {
}
${$usehfcaodm} = $moduleModel->getStyleArray();
${"GLOBALS"}["xmnsvohk"] = "additionalActions";
${${"GLOBALS"}["wawdybuyk"]}["styleArray"] = ${${"GLOBALS"}["hpazzjwsi"]};
$dktkfzrs = "colorizerCheckFktAlternative";
${$eqnwuxjrcnf} = $moduleModel->loadFormats();
$xphuwuux = "user";
$vacdhyc = "result";
$thfqjyf = "result";
${${"GLOBALS"}["wawdybuyk"]}["formatConditions"] = ${${"GLOBALS"}["eycvfjeki"]};
${${"GLOBALS"}["ypmebqw"]} = $moduleModel->loadActions();
${$vacdhyc}["additionalActions"] = array();
$ytgiregldh = "extraJavaScript";
foreach (${${"GLOBALS"}["xmnsvohk"]} as ${${"GLOBALS"}["bmdwenrnda"]} => ${${"GLOBALS"}["awzgfzlllo"]}) {
${"GLOBALS"}["nnpitl"] = "value";
${"GLOBALS"}["rugjtiwcbipn"] = "index";
$njuwxit = "value";
$mcozhne = "index";
${"GLOBALS"}["vnwvmjglzyk"] = "value";
${"GLOBALS"}["hqkuswrx"] = "extraJavaScript";
${${"GLOBALS"}["hqkuswrx"]}[] = "function addAction" . md5(${$mcozhne}) . "(blockIndex, colorize, Args, field) { " . ${$njuwxit}["function"] . " }";
${${"GLOBALS"}["wawdybuyk"]}["additionalActions"][${${"GLOBALS"}["bmdwenrnda"]}] = array("function" => "addAction" . md5(${${"GLOBALS"}["rugjtiwcbipn"]}), "toggle" => isset(${${"GLOBALS"}["awzgfzlllo"]}["toggle"]) && ${${"GLOBALS"}["nnpitl"]}["toggle"] == true ? true : false, "configuration" => ${${"GLOBALS"}["awzgfzlllo"]}["configuration"], "listview" => !isset(${${"GLOBALS"}["vnwvmjglzyk"]}["listview"]) ? false : ${${"GLOBALS"}["awzgfzlllo"]}["listview"]);
}
if (!empty(${${"GLOBALS"}["efizgtrhrm"]})) {
if ($request->get("dontLoadRecordData") != "true") {
$idotvzzyyhp = "modelData";
${"GLOBALS"}["hqcdwxze"] = "sourceRecordId";
${$idotvzzyyhp} = $this->getRecordData(${${"GLOBALS"}["tkkmift"]}, ${${"GLOBALS"}["hqcdwxze"]});
} else {
${${"GLOBALS"}["cnbxfeulpcc"]} = "Colorizer_DetailViewRecord";
}
} else {
${"GLOBALS"}["mtrhsbgonec"] = "modelData";
${${"GLOBALS"}["mtrhsbgonec"]} = array();
}
$fxtpgggxyon = "sql";
${${"GLOBALS"}["wawdybuyk"]}["recordData"] = ${${"GLOBALS"}["cnbxfeulpcc"]};
${${"GLOBALS"}["qinkop"]} = $moduleModel->getConfigurationByModule(${${"GLOBALS"}["tkkmift"]}, ${$jenftvxopl} == "detailview" || ${${"GLOBALS"}["lqiqrjxjc"]} == "summaryview" ? array("summaryview", "detailview") : ${${"GLOBALS"}["sgjqljutky"]});
$incqeqvkin = "result";
${$ywvwta} = array();
${${"GLOBALS"}["fwfcprcjgeg"]} = array();
${$dktkfzrs} = array();
${${"GLOBALS"}["gvqlwnq"]} = array();
${"GLOBALS"}["jopyzmikvrj"] = "resultTMP";
${${"GLOBALS"}["fgicwxml"]} = \Users_Record_Model::getCurrentUserModel();
${${"GLOBALS"}["bkjuhirif"]} = \PearDatabase::getInstance();
${${"GLOBALS"}["fvjxhvu"]} = "SELECT id,user_name,first_name,last_name FROM vtiger_users WHERE status = 'Active'";
${$xkzikzktbi} = $adb->pquery(${${"GLOBALS"}["fvjxhvu"]});
${${"GLOBALS"}["yoxfqbyi"]} = array();
while (${$xphuwuux} = $adb->fetchByAssoc(${${"GLOBALS"}["jopyzmikvrj"]})) {
${${"GLOBALS"}["yoxfqbyi"]}[html_entity_decode(${${"GLOBALS"}["smiirosq"]}["first_name"] . " " . ${${"GLOBALS"}["smiirosq"]}["last_name"], ENT_NOQUOTES, "UTF-8")] = ${${"GLOBALS"}["smiirosq"]}["id"];
}
${$fxtpgggxyon} = "SELECT * FROM vtiger_groups ORDER BY groupname";
${${"GLOBALS"}["bfobklh"]} = $adb->pquery(${$icdmfuc});
${"GLOBALS"}["gdoiwflj"] = "result";
while (${${"GLOBALS"}["sfijnq"]} = $adb->fetchByAssoc(${${"GLOBALS"}["bfobklh"]})) {
${"GLOBALS"}["gimnjaoqpahk"] = "group";
${"GLOBALS"}["oeqvlo"] = "group";
${${"GLOBALS"}["yoxfqbyi"]}[html_entity_decode(${${"GLOBALS"}["gimnjaoqpahk"]}["groupname"], ENT_NOQUOTES, "UTF-8")] = ${${"GLOBALS"}["oeqvlo"]}["groupid"];
}
$orbyqo = "result";
foreach (${${"GLOBALS"}["qinkop"]} as ${${"GLOBALS"}["vdwdhgrefti"]}) {
$jgitsvi = "tmp";
$rdmvuqtbnfu = "columnName";
$pcgsqcqduyp = "colorizeFunctions";
${$jgitsvi} = array();
if (count(${${"GLOBALS"}["vdwdhgrefti"]}["condition"]) == 0) {
${"GLOBALS"}["siyknxkvk"] = "row";
${"GLOBALS"}["jxxoxpxsrp"] = "row";
$idzjkpfqpxq = "row";
if (count(${${"GLOBALS"}["siyknxkvk"]}["actions"]) > 0) {
${"GLOBALS"}["rxyocuhfgcp"] = "action";
$fkajpcmisdu = "row";
${${"GLOBALS"}["erscuxob"]} = "actionFkt_" . ${${"GLOBALS"}["vdwdhgrefti"]}["id"];
$esqryexx = "actionsFktName";
${${"GLOBALS"}["kzcrkutnedo"]} = "function " . ${$esqryexx} . "(colorize, field) {";
$nhmqanbskeb = "script";
foreach (${$fkajpcmisdu}["actions"] as ${${"GLOBALS"}["bmdwenrnda"]} => ${${"GLOBALS"}["rxyocuhfgcp"]}) {
$gnfvcjwdsrkd = "index";
${"GLOBALS"}["vygmsuclm"] = "result";
${"GLOBALS"}["hlgxoaode"] = "action";
${"GLOBALS"}["nhjpqgqhudc"] = "confValues";
${"GLOBALS"}["ooineajm"] = "confValues";
if (${$gnfvcjwdsrkd} == "##ACTIONID##") {
continue;
}
$qttqbcigvpy = "action";
${"GLOBALS"}["uibmwvgfk"] = "result";
$ldzzolnsow = "action";
${${"GLOBALS"}["ooineajm"]} = -1;
$ykcidwfh = "action";
if (${${"GLOBALS"}["wensssj"]} === "listview" && (!isset(${${"GLOBALS"}["wawdybuyk"]}["additionalActions"][${${"GLOBALS"}["vpxkzxidmxy"]}["action"]]) || ${${"GLOBALS"}["vygmsuclm"]}["additionalActions"][${${"GLOBALS"}["hlgxoaode"]}["action"]]["listview"] == false)) {
continue;
}
if (!isset(${${"GLOBALS"}["wawdybuyk"]}["additionalActions"][${$qttqbcigvpy}["action"]]) || ${${"GLOBALS"}["wawdybuyk"]}["additionalActions"][${$ykcidwfh}["action"]]["configuration"] == "block") {
${"GLOBALS"}["jsdxhnithmv"] = "confValues";
${"GLOBALS"}["suahtye"] = "blockIndex";
${${"GLOBALS"}["suahtye"]} = $moduleModel->getBlockIndex(${${"GLOBALS"}["xjhpotmljg"]}, ${${"GLOBALS"}["vpxkzxidmxy"]}["value"]);
if (empty(${${"GLOBALS"}["ngczlevt"]}) && ${${"GLOBALS"}["ngczlevt"]} !== 0) {
${${"GLOBALS"}["ngczlevt"]} = -1;
}
${${"GLOBALS"}["jsdxhnithmv"]} = ${${"GLOBALS"}["ngczlevt"]};
} elseif (${${"GLOBALS"}["uibmwvgfk"]}["additionalActions"][${${"GLOBALS"}["vpxkzxidmxy"]}["action"]]["configuration"] == "select") {
${${"GLOBALS"}["klmdwkj"]} = array("value" => ${${"GLOBALS"}["vpxkzxidmxy"]}["value"]);
}
${${"GLOBALS"}["kzcrkutnedo"]} .= "Colorizer.runAction('" . ${$ldzzolnsow}["action"] . "', " . json_encode(${${"GLOBALS"}["nhjpqgqhudc"]}) . ", colorize, field);";
}
${$nhmqanbskeb} .= "}";
${${"GLOBALS"}["bfcvyxdqj"]}[] = ${${"GLOBALS"}["kzcrkutnedo"]};
} else {
${${"GLOBALS"}["erscuxob"]} = false;
}
${"GLOBALS"}["mjvkjlputi"] = "tmpArray";
${${"GLOBALS"}["mjvkjlputi"]} = array("condition" => false, "fieldSettings" => ${${"GLOBALS"}["vdwdhgrefti"]}["settings"], "labelSettings" => ${${"GLOBALS"}["jxxoxpxsrp"]}["labelsettings"], "additional" => ${$idzjkpfqpxq}["additional"], "action" => ${${"GLOBALS"}["erscuxob"]}, "view" => array("detailview" => ${${"GLOBALS"}["vdwdhgrefti"]}["detailview"], "listview" => ${${"GLOBALS"}["vdwdhgrefti"]}["listview"], "summaryview" => ${${"GLOBALS"}["vdwdhgrefti"]}["summaryview"], "editview" => ${${"GLOBALS"}["vdwdhgrefti"]}["editview"]));
} else {
$gxdpxhrlrqyc = "row";
$gcybfoc = "value";
${"GLOBALS"}["yrylcvcozpl"] = "tmpArray";
$uumqxmlk = "actionsFktName";
${"GLOBALS"}["nruvpxnhqtg"] = "row";
$seoqjslhy = "row";
${"GLOBALS"}["fsvnff"] = "key";
${${"GLOBALS"}["ltflusu"]} = array();
foreach (${${"GLOBALS"}["vdwdhgrefti"]}["condition"] as ${${"GLOBALS"}["fsvnff"]} => ${$gcybfoc}) {
${"GLOBALS"}["opbwxkcb"] = "conditionParameter";
${"GLOBALS"}["pbkjnmvgdt"] = "formatConditions";
${"GLOBALS"}["bftvncm"] = "functionsNames";
$zfkokenl = "condition";
${"GLOBALS"}["cexzjn"] = "condition";
${"GLOBALS"}["lviwbhwm"] = "functionsName";
$xwujvdmadvuf = "conditionParameter";
if (!isset(${${"GLOBALS"}["pbkjnmvgdt"]}[${${"GLOBALS"}["awzgfzlllo"]}["condition"]]) || empty(${${"GLOBALS"}["awzgfzlllo"]}["field"])) {
continue;
}
${${"GLOBALS"}["cexzjn"]} = ${${"GLOBALS"}["eycvfjeki"]}[${${"GLOBALS"}["awzgfzlllo"]}["condition"]];
$fdxjti = "value";
$zhipeeopqdn = "functionsName";
${"GLOBALS"}["qnejxfl"] = "row";
${${"GLOBALS"}["opbwxkcb"]} = is_array(${${"GLOBALS"}["awzgfzlllo"]}["parameter"]) ? ${${"GLOBALS"}["awzgfzlllo"]}["parameter"] : false;
${${"GLOBALS"}["ynpkewb"]} = null;
$vcqtpkhs = "value";
if (is_string(${${"GLOBALS"}["vhudblec"]})) {
if (strpos(${${"GLOBALS"}["vhudblec"]}, "\$current_user_id") !== false) {
$nexqfwrfout = "conditionParameter";
$jszibqbnfo = "conditionParameter";
${$jszibqbnfo} = str_replace("\$current_user_id", $current_user->id, ${$nexqfwrfout});
}
} elseif (is_array(${$xwujvdmadvuf})) {
${"GLOBALS"}["dmtygebwqm"] = "conditionValue";
foreach (${${"GLOBALS"}["vhudblec"]} as ${${"GLOBALS"}["bmdwenrnda"]} => ${${"GLOBALS"}["dmtygebwqm"]}) {
if (strpos(${${"GLOBALS"}["latrorlk"]}, "\$current_user_id") !== false) {
$jmhgrzxlj = "index";
${"GLOBALS"}["ajhwfnbsfti"] = "conditionParameter";
${${"GLOBALS"}["ajhwfnbsfti"]}[${$jmhgrzxlj}] = str_replace("\$current_user_id", $current_user->id, ${${"GLOBALS"}["latrorlk"]});
}
}
}
if (isset(${$zfkokenl}["serverFunction"])) {
$mhlaym = "serverResult";
$uneyyf = "conditionParameter";
if (${${"GLOBALS"}["cnbxfeulpcc"]} === "Colorizer_DetailViewRecord") {
$oegmer = "sourceRecordId";
$eceoxokok = "newCurrentModule";
$oqsijecpmlp = "modelData";
${$oqsijecpmlp} = $this->getRecordData(${$eceoxokok}, ${$oegmer});
}
${"GLOBALS"}["ysdqlp"] = "modelData";
$yttqjtkqf = "newCurrentModule";
${$mhlaym} = ${${"GLOBALS"}["hnkbgddv"]}["serverFunction"](${${"GLOBALS"}["ysdqlp"]}, ${$yttqjtkqf}, ${$uneyyf});
}
${${"GLOBALS"}["lviwbhwm"]} = "fkt_" . md5(${$vcqtpkhs}["condition"]);
if (!in_array(${${"GLOBALS"}["wwflizher"]}, ${${"GLOBALS"}["fwfcprcjgeg"]})) {
$klrcqjpvhib = "script";
$ynvjtpwfuypi = "functionsName";
${"GLOBALS"}["cnlrslcyvee"] = "serverResult";
$kphbdyucm = "script";
${"GLOBALS"}["rjncdwtzz"] = "condition";
${$klrcqjpvhib} = "function " . ${${"GLOBALS"}["wwflizher"]} . "(key, value, record, parameter, dynamic, listview) {";
${"GLOBALS"}["nrlunshe"] = "script";
if (${${"GLOBALS"}["cnlrslcyvee"]} !== null) {
$rulosahuxli = "serverResult";
${"GLOBALS"}["kwbodq"] = "additionalArguments";
${${"GLOBALS"}["gvqlwnq"]} = array_merge(${${"GLOBALS"}["kwbodq"]}, ${$rulosahuxli});
${${"GLOBALS"}["kzcrkutnedo"]} .= "var server = " . json_encode(${${"GLOBALS"}["ynpkewb"]}) . ";";
}
${$kphbdyucm} .= ${${"GLOBALS"}["rjncdwtzz"]}["function"];
${${"GLOBALS"}["kzcrkutnedo"]} .= "}";
${${"GLOBALS"}["bfcvyxdqj"]}[] = ${${"GLOBALS"}["nrlunshe"]};
${${"GLOBALS"}["fwfcprcjgeg"]}[] = ${$ynvjtpwfuypi};
}
${${"GLOBALS"}["blrdtf"]}[${${"GLOBALS"}["awzgfzlllo"]}["field"]][] = ${${"GLOBALS"}["qnejxfl"]}["field"];
if (${${"GLOBALS"}["wensssj"]} == "listview") {
${${"GLOBALS"}["nckkjvygiqsc"]} = Colorizer_VtUtils::getColumnName(${${"GLOBALS"}["awzgfzlllo"]}["field"], ${${"GLOBALS"}["xjhpotmljg"]});
} else {
$hvriqy = "value";
${${"GLOBALS"}["nckkjvygiqsc"]} = ${$hvriqy}["field"];
}
${${"GLOBALS"}["bftvncm"]}[] = array(${$zhipeeopqdn}, ${${"GLOBALS"}["nckkjvygiqsc"]}, ${${"GLOBALS"}["vhudblec"]}, intval(${$fdxjti}["not"]));
}
if (count(${${"GLOBALS"}["vdwdhgrefti"]}["actions"]) > 0) {
$dnixxrrhjbj = "actionsFktName";
$kuiwrh = "action";
${"GLOBALS"}["werpyvu"] = "row";
${$dnixxrrhjbj} = "actionFkt_" . ${${"GLOBALS"}["werpyvu"]}["id"];
${${"GLOBALS"}["kzcrkutnedo"]} = "function " . ${${"GLOBALS"}["erscuxob"]} . "(colorize, field) {";
$rnuqwokpq = "extraJavaScript";
foreach (${${"GLOBALS"}["vdwdhgrefti"]}["actions"] as ${$kuiwrh}) {
$pxutyxpvch = "action";
$ledcutam = "action";
${"GLOBALS"}["efmjnifbs"] = "confValues";
${${"GLOBALS"}["efmjnifbs"]} = -1;
if (${${"GLOBALS"}["wensssj"]} === "listview" && (!isset(${${"GLOBALS"}["wawdybuyk"]}["additionalActions"][${${"GLOBALS"}["vpxkzxidmxy"]}["action"]]) || ${${"GLOBALS"}["wawdybuyk"]}["additionalActions"][${${"GLOBALS"}["vpxkzxidmxy"]}["action"]]["listview"] == false)) {
continue;
}
${"GLOBALS"}["qhcydqrhke"] = "script";
if (!isset(${${"GLOBALS"}["wawdybuyk"]}["additionalActions"][${$pxutyxpvch}["action"]]) || ${${"GLOBALS"}["wawdybuyk"]}["additionalActions"][${${"GLOBALS"}["vpxkzxidmxy"]}["action"]]["configuration"] == "block") {
$nftrkn = "blockIndex";
$azoffnx = "action";
$nrqofqeem = "blockIndex";
${$nftrkn} = $moduleModel->getBlockIndex(${${"GLOBALS"}["xjhpotmljg"]}, ${$azoffnx}["value"]);
if (empty(${$nrqofqeem}) && ${${"GLOBALS"}["ngczlevt"]} !== 0) {
${${"GLOBALS"}["ngczlevt"]} = -1;
}
${${"GLOBALS"}["klmdwkj"]} = ${${"GLOBALS"}["ngczlevt"]};
} elseif (${${"GLOBALS"}["wawdybuyk"]}["additionalActions"][${$ledcutam}["action"]]["configuration"] == "select") {
${${"GLOBALS"}["klmdwkj"]} = array("value" => ${${"GLOBALS"}["vpxkzxidmxy"]}["value"]);
}
${${"GLOBALS"}["qhcydqrhke"]} .= "Colorizer.runAction('" . ${${"GLOBALS"}["vpxkzxidmxy"]}["action"] . "', " . json_encode(${${"GLOBALS"}["klmdwkj"]}) . ", colorize, field);";
}
${${"GLOBALS"}["kzcrkutnedo"]} .= "}";
$yaugixmgcb = "script";
${$rnuqwokpq}[] = ${$yaugixmgcb};
} else {
${"GLOBALS"}["kukrqmd"] = "actionsFktName";
${${"GLOBALS"}["kukrqmd"]} = false;
}
${${"GLOBALS"}["yrylcvcozpl"]} = array("condition" => ${${"GLOBALS"}["ltflusu"]}, "fieldSettings" => ${${"GLOBALS"}["vdwdhgrefti"]}["settings"], "labelSettings" => ${${"GLOBALS"}["vdwdhgrefti"]}["labelsettings"], "additional" => ${${"GLOBALS"}["vdwdhgrefti"]}["additional"], "action" => ${$uumqxmlk}, "view" => array("detailview" => ${${"GLOBALS"}["vdwdhgrefti"]}["detailview"], "listview" => ${$gxdpxhrlrqyc}["listview"], "summaryview" => ${$seoqjslhy}["summaryview"], "editview" => ${${"GLOBALS"}["nruvpxnhqtg"]}["editview"]));
}
${"GLOBALS"}["zccgyfpenw"] = "colorizeFunctions";
if (${${"GLOBALS"}["wensssj"]} == "listview") {
$gmqgcvy = "tabid";
$hhbjvrspgcc = "columnName";
${$hhbjvrspgcc} = Colorizer_VtUtils::getColumnName(${${"GLOBALS"}["vdwdhgrefti"]}["field"], ${$gmqgcvy});
} else {
${"GLOBALS"}["sbfykd"] = "row";
${"GLOBALS"}["btuwfoc"] = "columnName";
${${"GLOBALS"}["btuwfoc"]} = ${${"GLOBALS"}["sbfykd"]}["field"];
}
if (!isset(${${"GLOBALS"}["zccgyfpenw"]}[${$rdmvuqtbnfu}])) {
$kdtltcrtkxy = "colorizeFunctions";
${$kdtltcrtkxy}[${${"GLOBALS"}["nckkjvygiqsc"]}] = array();
}
${$pcgsqcqduyp}[${${"GLOBALS"}["nckkjvygiqsc"]}][] = ${${"GLOBALS"}["gbugqbyjk"]};
}
${$orbyqo}["additionalArguments"] = ${${"GLOBALS"}["gvqlwnq"]};
${"GLOBALS"}["rhsbmww"] = "colorizeFunctions";
${$thfqjyf}["colorizerCheckFktAlternative"] = ${${"GLOBALS"}["blrdtf"]};
${${"GLOBALS"}["gdoiwflj"]}["colorizeFunctions"] = ${${"GLOBALS"}["rhsbmww"]};
${$ylgqtyr}["extraJavaScript"] = implode("", ${$ytgiregldh});
${"GLOBALS"}["rrrxhscolpkm"] = "result";
$xltxsmljt = "response";
${${"GLOBALS"}["wawdybuyk"]}["dateFormat"] = $current_user->get("date_format");
${${"GLOBALS"}["rrrxhscolpkm"]}["availableUser"] = ${${"GLOBALS"}["yoxfqbyi"]};
global $current_language;
${${"GLOBALS"}["lpttleo"]} = array();
if (${${"GLOBALS"}["wensssj"]} == "listview" && ${${"GLOBALS"}["ykgbyos"]} != "en_us") {
$exekdqqwrph = "field";
$rmrkluuesh = "fields";
$gjtizfebxy = "fields";
${$rmrkluuesh} = Colorizer_VtUtils::getFieldsForModule(${${"GLOBALS"}["tkkmift"]}, array(15, 16, 33));
foreach (${$gjtizfebxy} as ${$exekdqqwrph}) {
$bqubeslnb = "value";
${"GLOBALS"}["bywcimcb"] = "values";
${${"GLOBALS"}["oqoiqexv"]} = Vtiger_Util_Helper::getPickListValues($field->name);
foreach (${${"GLOBALS"}["bywcimcb"]} as ${$bqubeslnb}) {
$jhccvtf = "value";
$zdufxcwq = "value";
${${"GLOBALS"}["lpttleo"]}[$field->column][getTranslatedString(${$jhccvtf}, ${${"GLOBALS"}["tkkmift"]})] = ${$zdufxcwq};
}
}
}
${$dynxbna}["picklists"] = ${${"GLOBALS"}["lpttleo"]};
${$incqeqvkin}["version"] = COLORIZER_VERSION;
${$xltxsmljt} = new Vtiger_Response();
$response->setResult(${${"GLOBALS"}["wawdybuyk"]});
$response->setEmitType(Vtiger_Response::${${"GLOBALS"}["ebbutvbxe"]});
$response->emit();
}
public function picklists()
{
global $log, $adb;
$log->debug("Entering YetiForceUpdate::picklists() method ...");
$addPicklists = array();
$addPicklists['SalesOrder'][] = array('name' => 'payment_duration', 'uitype' => '16', 'add_values' => array('payment:+0 day', 'payment:+1 day', 'payment:+7 days', 'payment:+14 days', 'payment:+21 days', 'payment:+30 days', 'payment:+60 days', 'payment:+90 days', 'payment:+180 days', 'payment:+360 days', 'payment:+1 month', 'payment:+3 months', 'payment:+6 months', 'payment:+1 year', 'payment:monday next week', 'payment:friday next week', 'payment:first day of next month', 'payment:last day of next month', 'payment:first day of +3 months', 'payment:last day of +3 months'), 'remove_values' => array('Net 30 days', 'Net 45 days', 'Net 60 days'));
$addPicklists['SalesOrder'][] = array('name' => 'recurring_frequency', 'uitype' => '16', 'add_values' => array('+1 day', '+7 days', '+14 days', '+21 days', '+30 days', '+60 days', '+90 days', '+180 days', '+360 days', '+1 month', '+3 months', '+6 months', '+1 year', 'monday next week', 'friday next week', 'first day of next month', 'last day of next month', 'first day of +3 months', 'last day of +3 months'), 'remove_values' => array('Daily', 'Weekly', 'Monthly', 'Quarterly', 'Yearly'));
$addPicklists['Calculations'][] = array('name' => 'calculationsstatus', 'uitype' => '15', 'add_values' => array('PLL_WAITING_FOR_VERIFICATION', 'PLL_VERIFICATION_PROCESS', 'PLL_INTERNAL_CONSULTATION_REQUIRED', 'PLL_EXTERNAL_CONSULTATION_REQUIRED', 'PLL_WAITING_FOR_VENDORS_QUOTE', 'PLL_WAITING_FOR_CUSTOMERS_REPLY', 'PLL_IN_PREPARATION', 'LBL_DECLINED', 'LBL_ACCEPTED'), 'remove_values' => array('LBL_IN_PREPARATION', 'Waiting for valuation', 'Waiting for acceptance', 'Accepted', 'Rejected', 'LBL_OBJECTIONS_ARE_RAISED'));
$addPicklists['Quotes'][] = array('name' => 'quotestage', 'uitype' => '15', 'add_values' => array('PLL_WAITING_FOR_PREPARATION', 'PLL_INTERNAL_CONSULTATION_REQUIRED', 'PLL_EXTERNAL_CONSULTATION_REQUIRED', 'PLL_WAITING_FOR_CUSTOMERS_REPLY', 'PLL_IN_PREPARATION', 'PLL_DECLINED', 'PLL_ACCEPTED'), 'remove_values' => array('Created', 'Delivered', 'Reviewed', 'Accepted', 'Rejected'));
$addPicklists['Calendar'][] = array('name' => 'activitytype', 'uitype' => '15', 'add_values' => array(), 'remove_values' => array('Mobile Call'));
$addPicklists['Calendar'][] = array('name' => 'eventstatus', 'uitype' => '15', 'add_values' => array(), 'remove_values' => array('Planned'));
$addPicklists['Users'][] = array('name' => 'defaulteventstatus', 'uitype' => '15', 'add_values' => array(), 'remove_values' => array('Planned'));
$roleRecordList = Settings_Roles_Record_Model::getAll();
$rolesSelected = array();
foreach ($roleRecordList as $roleRecord) {
$rolesSelected[] = $roleRecord->getId();
}
foreach ($addPicklists as $moduleName => $piscklists) {
$moduleModel = Settings_Picklist_Module_Model::getInstance($moduleName);
if (!$moduleModel) {
continue;
}
foreach ($piscklists as $piscklist) {
$fieldModel = Settings_Picklist_Field_Model::getInstance($piscklist['name'], $moduleModel);
if (!$fieldModel) {
continue;
}
$pickListValues = Vtiger_Util_Helper::getPickListValues($piscklist['name']);
foreach ($piscklist['add_values'] as $newValue) {
if (!in_array($newValue, $pickListValues)) {
//$moduleModel->addPickListValues($fieldModel, $newValue);
$moduleModel->addPickListValues($fieldModel, $newValue, $rolesSelected);
}
}
foreach ($piscklist['remove_values'] as $newValue) {
if (!in_array($newValue, $pickListValues)) {
continue;
}
if ($piscklist['uitype'] == '15') {
$deletePicklistValueId = self::getPicklistId($piscklist['name'], $newValue);
if ($deletePicklistValueId) {
$adb->pquery("DELETE FROM `vtiger_role2picklist` WHERE picklistvalueid = ? ", array($deletePicklistValueId));
}
}
$adb->pquery("DELETE FROM `vtiger_" . $piscklist['name'] . "` WHERE " . $piscklist['name'] . " = ? ", array($newValue));
if ($piscklist['name'] == 'Net 30 days') {
$adb->pquery("UPDATE `vtiger_invoice_recurring_info` SET `payment_duration` = ? WHERE `payment_duration` = ? ;", array($piscklist['name'], 'payment:+30 days'));
}
if ($piscklist['name'] == 'Net 60 days') {
$adb->pquery("UPDATE `vtiger_invoice_recurring_info` SET `payment_duration` = ? WHERE `payment_duration` = ? ;", array($piscklist['name'], 'payment:+60 days'));
}
if ($piscklist['name'] == 'Daily') {
$adb->pquery("UPDATE `vtiger_invoice_recurring_info` SET `recurring_frequency` = ? WHERE `recurring_frequency` = ? ;", array($piscklist['name'], '+1 day'));
}
if ($piscklist['name'] == 'Weekly') {
$adb->pquery("UPDATE `vtiger_invoice_recurring_info` SET `recurring_frequency` = ? WHERE `recurring_frequency` = ? ;", array($piscklist['name'], '+7 days'));
}
if ($piscklist['name'] == 'Monthly') {
$adb->pquery("UPDATE `vtiger_invoice_recurring_info` SET `recurring_frequency` = ? WHERE `recurring_frequency` = ? ;", array($piscklist['name'], '+1 month'));
}
if ($piscklist['name'] == 'Quarterly') {
$adb->pquery("UPDATE `vtiger_invoice_recurring_info` SET `recurring_frequency` = ? WHERE `recurring_frequency` = ? ;", array($piscklist['name'], '+3 months'));
}
if ($piscklist['name'] == 'Yearly') {
$adb->pquery("UPDATE `vtiger_invoice_recurring_info` SET `recurring_frequency` = ? WHERE `recurring_frequency` = ? ;", array($piscklist['name'], '+1 year'));
}
if ($piscklist['name'] == 'Accepted' && $moduleName == 'Calculations') {
$adb->pquery("UPDATE `vtiger_calculations` SET `calculationsstatus` = ? WHERE `calculationsstatus` = ? ;", array($piscklist['name'], 'LBL_ACCEPTED'));
}
if ($piscklist['name'] == 'Rejected' && $moduleName == 'Calculations') {
$adb->pquery("UPDATE `vtiger_calculations` SET `calculationsstatus` = ? WHERE `calculationsstatus` = ? ;", array($piscklist['name'], 'LBL_DECLINED'));
}
if ($piscklist['name'] == 'Accepted' && $moduleName == 'Quotes') {
$adb->pquery("UPDATE `vtiger_calculations` SET `calculationsstatus` = ? WHERE `calculationsstatus` = ? ;", array($piscklist['name'], 'PLL_ACCEPTED'));
}
if ($piscklist['name'] == 'Rejected' && $moduleName == 'Quotes') {
$adb->pquery("UPDATE `vtiger_quotes` SET `quotestage` = ? WHERE `quotestage` = ? ;", array($piscklist['name'], 'PLL_DECLINED'));
}
//$moduleModel->remove($piscklist['name'], $deletePicklistId, '', $moduleName); // remove and replace in records
}
}
}
$log->debug("Exiting YetiForceUpdate::picklists() method ...");
}
function picklists()
{
global $log, $adb;
$log->debug("Entering YetiForceUpdate::picklists() method ...");
$addPicklists = [];
$addPicklists['OSSMailTemplates'][] = ['name' => 'ossmailtemplates_type', 'uitype' => '16', 'add_values' => ['PLL_MAIL', 'PLL_LIST'], 'remove_values' => []];
$addPicklists['Calculations'][] = ['name' => 'calculations_cons', 'uitype' => '33', 'add_values' => ['PLL_LONGTERM_REALIZATION'], 'remove_values' => []];
$addPicklists['Calculations'][] = ['name' => 'calculations_pros', 'uitype' => '33', 'add_values' => [], 'remove_values' => ['PLL_LONGTERM_REALIZATION']];
$roleRecordList = Settings_Roles_Record_Model::getAll();
$rolesSelected = array();
foreach ($roleRecordList as $roleRecord) {
$rolesSelected[] = $roleRecord->getId();
}
foreach ($addPicklists as $moduleName => $piscklists) {
$moduleModel = Settings_Picklist_Module_Model::getInstance($moduleName);
if (!$moduleModel) {
continue;
}
foreach ($piscklists as $piscklist) {
$fieldModel = Settings_Picklist_Field_Model::getInstance($piscklist['name'], $moduleModel);
if (!$fieldModel) {
continue;
}
$pickListValues = Vtiger_Util_Helper::getPickListValues($piscklist['name']);
foreach ($piscklist['add_values'] as $newValue) {
if (!in_array($newValue, $pickListValues)) {
$moduleModel->addPickListValues($fieldModel, $newValue, $rolesSelected);
}
}
foreach ($piscklist['remove_values'] as $newValue) {
if (!in_array($newValue, $pickListValues)) {
continue;
}
if ($piscklist['uitype'] != '16') {
$deletePicklistValueId = self::getPicklistId($piscklist['name'], $newValue);
if ($deletePicklistValueId) {
$adb->pquery("DELETE FROM `vtiger_role2picklist` WHERE picklistvalueid = ? ", array($deletePicklistValueId));
}
}
$adb->pquery("DELETE FROM `vtiger_" . $piscklist['name'] . "` WHERE " . $piscklist['name'] . " = ? ", array($newValue));
}
}
}
$log->debug("Exiting YetiForceUpdate::picklists() method ...");
}
public function picklists()
{
global $log, $adb;
$log->debug("Entering VT620_to_YT::picklists() method ...");
$addPicklists = array();
$addPicklists['Assets'][] = array('name' => 'assetstatus', 'uitype' => '15', 'add_values' => array('PLL_DRAFT', 'PLL_WARRANTY_SUPPORT', 'PLL_POST_WARRANTY_SUPPORT', 'PLL_NO_SUPPORT'), 'remove_values' => array('Out-of-service', 'In Service'));
$addPicklists['HelpDesk'][] = array('name' => 'ticketstatus', 'uitype' => '15', 'add_values' => array('Answered', 'Rejected'), 'remove_values' => array());
$addPicklists['Users'][] = array('name' => 'date_format', 'uitype' => '16', 'add_values' => array('dd.mm.yyyy', 'mm.dd.yyyy', 'yyyy.mm.dd', 'dd/mm/yyyy', 'mm/dd/yyyy', 'yyyy/mm/dd'), 'remove_values' => array());
$addPicklists['Users'][] = array('name' => 'end_hour', 'add_values' => array("00:00", "01:00", "02:00", "03:00", "04:00", "05:00", "06:00", "07:00", "08:00", "09:00", "10:00", "11:00", "12:00", "13:00", "14:00", "15:00", "16:00", "17:00", "18:00", "19:00", "20:00", "21:00", "22:00", "23:00"), 'remove_values' => array());
$addPicklists['Invoice'][] = array('name' => 'invoicestatus', 'uitype' => '15', 'add_values' => array("Derecognized", "Invoice entered"), 'remove_values' => array('Sent', 'Credit Invoice', 'Paid'));
$addPicklists['Leads'][] = array('name' => 'leadsource', 'uitype' => '15', 'add_values' => array(), 'remove_values' => array('Existing Customer', 'Employee', 'Partner', 'Public Relations', 'Direct Mail'));
$addPicklists['Leads'][] = array('name' => 'leadstatus', 'uitype' => '15', 'add_values' => array('LBL_TO_REALIZE', 'LBL_REQUIRES_VERIFICATION', 'LBL_PRELIMINARY_ANALYSIS_OF', 'LBL_ADVANCED_ANALYSIS', 'LBL_INITIAL_ACQUISITION', 'LBL_CONTACTS_IN_THE_FUTURE', 'LBL_LEAD_UNTAPPED', 'LBL_LEAD_ACQUIRED'), 'remove_values' => array('Attempted to Contact', 'Cold', 'Contact in Future', 'Contacted', 'Hot', 'Junk Lead', 'Lost Lead', 'Not Contacted', 'Pre Qualified', 'Qualified', 'Warm'));
$addPicklists['Leads'][] = array('name' => 'salutationtype', 'uitype' => '15', 'add_values' => array(), 'remove_values' => array('--None--'));
$addPicklists['Leads'][] = array('name' => 'industry', 'uitype' => '15', 'add_values' => array('Administration', 'Construction Industry', 'Power Industry', 'Trade', 'Hotels and Restaurants', 'Health Care', 'Industry / Manufacturing', 'Uniformed Services', 'Transport & Logistics', 'Technologies'), 'remove_values' => array('--None--', 'Apparel', 'Banking', 'Biotechnology', 'Chemicals', 'Communications', 'Construction', 'Consulting', 'Electronics', 'Energy', 'Engineering', 'Entertainment', 'Environmental', 'Food & Beverage', 'Government', 'Healthcare', 'Hospitality', 'Insurance', 'Machinery', 'Manufacturing', 'Media', 'Not For Profit', 'Recreation', 'Retail', 'Shipping', 'Technology', 'Telecommunications', 'Transportation', 'Utilities', 'Other'));
$addPicklists['Project'][] = array('name' => 'projecttype', 'uitype' => '15', 'add_values' => array('PLL_INTERNAL', 'PLL_EXTERNAL', 'PLL_COMMON'), 'remove_values' => array('administrative', 'operative', 'other'));
$addPicklists['SalesOrder'][] = array('name' => 'payment_duration', 'uitype' => '16', 'add_values' => array('payment:+0 day', 'payment:+1 day', 'payment:+7 days', 'payment:+14 days', 'payment:+21 days', 'payment:+30 days', 'payment:+60 days', 'payment:+90 days', 'payment:+180 days', 'payment:+360 days', 'payment:+1 month', 'payment:+3 months', 'payment:+6 months', 'payment:+1 year', 'payment:monday next week', 'payment:friday next week', 'payment:first day of next month', 'payment:last day of next month', 'payment:first day of +3 months', 'payment:last day of +3 months'), 'remove_values' => array('Net 30 days', 'Net 45 days', 'Net 60 days'));
$addPicklists['SalesOrder'][] = array('name' => 'recurring_frequency', 'uitype' => '16', 'add_values' => array('+1 day', '+7 days', '+14 days', '+21 days', '+30 days', '+60 days', '+90 days', '+180 days', '+360 days', '+1 month', '+3 months', '+6 months', '+1 year', 'monday next week', 'friday next week', 'first day of next month', 'last day of next month', 'first day of +3 months', 'last day of +3 months'), 'remove_values' => array('Daily', 'Weekly', 'Monthly', 'Quarterly', 'Yearly'));
$addPicklists['Quotes'][] = array('name' => 'quotestage', 'uitype' => '15', 'add_values' => array('PLL_WAITING_FOR_PREPARATION', 'PLL_INTERNAL_CONSULTATION_REQUIRED', 'PLL_EXTERNAL_CONSULTATION_REQUIRED', 'PLL_WAITING_FOR_CUSTOMERS_REPLY', 'PLL_IN_PREPARATION', 'PLL_DECLINED', 'PLL_ACCEPTED'), 'remove_values' => array('Created', 'Delivered', 'Reviewed', 'Accepted', 'Rejected'));
$addPicklists['Calendar'][] = array('name' => 'activitytype', 'uitype' => '15', 'add_values' => array(), 'remove_values' => array('Mobile Call'));
$addPicklists['Users'][] = array('name' => 'defaulteventstatus', 'uitype' => '15', 'add_values' => array(), 'remove_values' => array('Planned'));
$addPicklists['Calendar'][] = array('name' => 'eventstatus', 'uitype' => '15', 'add_values' => array(), 'remove_values' => array('Planned'));
$addPicklists['Potentials'][] = array('name' => 'sales_stage', 'uitype' => '15', 'add_values' => array('Accepted for processing', 'Data verification', 'Customer internal analysis', 'First contact with a customer', 'Advanced business analysis', 'Perception Analysis', 'Preparation of calculations', 'Preparation of offers', 'Awaiting a decision', 'Negotiations', 'Order and contract', 'Documentation verification', 'Closed Lost', 'Closed Waiting for processing', 'Closed Order/contract processing', 'Closed Presale activities', 'Closed Won'), 'remove_values' => array('Prospecting', 'Qualification', 'Needs Analysis', 'Value Proposition', 'Id. Decision Makers', 'Proposal or Price Quote', 'Negotiation or Review'));
$addPicklists['Calendar'][] = array('name' => 'taskstatus', 'uitype' => '15', 'add_values' => array('Cancelled'), 'remove_values' => array('Planned'));
$addPicklists['ProjectMilestone'][] = array('name' => 'projectmilestonetype', 'uitype' => '15', 'add_values' => array('PLL_INTERNAL', 'PLL_EXTERNAL', 'PLL_SHARED'), 'remove_values' => array('administrative', 'operative', 'other'));
$roleRecordList = Settings_Roles_Record_Model::getAll();
$rolesSelected = array();
foreach ($roleRecordList as $roleRecord) {
$rolesSelected[] = $roleRecord->getId();
}
foreach ($addPicklists as $moduleName => $piscklists) {
$moduleModel = Settings_Picklist_Module_Model::getInstance($moduleName);
if (!$moduleModel) {
continue;
}
foreach ($piscklists as $piscklist) {
$fieldModel = Settings_Picklist_Field_Model::getInstance($piscklist['name'], $moduleModel);
if (!$fieldModel) {
continue;
}
$pickListValues = Vtiger_Util_Helper::getPickListValues($piscklist['name']);
foreach ($piscklist['add_values'] as $newValue) {
if (!in_array($newValue, $pickListValues)) {
//$moduleModel->addPickListValues($fieldModel, $newValue);
$moduleModel->addPickListValues($fieldModel, $newValue, $rolesSelected);
}
}
foreach ($piscklist['remove_values'] as $newValue) {
if (!in_array($newValue, $pickListValues)) {
continue;
}
if ($piscklist['uitype'] == '15') {
$deletePicklistValueId = self::getPicklistId($piscklist['name'], $newValue);
if ($deletePicklistValueId) {
$adb->pquery("DELETE FROM `vtiger_role2picklist` WHERE picklistvalueid = ? ", array($deletePicklistValueId));
}
}
$adb->pquery("DELETE FROM `vtiger_" . $piscklist['name'] . "` WHERE " . $piscklist['name'] . " = ? ", array($newValue));
if ($piscklist['name'] == 'Net 30 days') {
$adb->pquery("UPDATE `vtiger_invoice_recurring_info` SET `payment_duration` = ? WHERE `payment_duration` = ? ;", array($piscklist['name'], 'payment:+30 days'));
}
if ($piscklist['name'] == 'Net 60 days') {
$adb->pquery("UPDATE `vtiger_invoice_recurring_info` SET `payment_duration` = ? WHERE `payment_duration` = ? ;", array($piscklist['name'], 'payment:+60 days'));
}
if ($piscklist['name'] == 'Daily') {
$adb->pquery("UPDATE `vtiger_invoice_recurring_info` SET `recurring_frequency` = ? WHERE `recurring_frequency` = ? ;", array($piscklist['name'], '+1 day'));
}
if ($piscklist['name'] == 'Weekly') {
$adb->pquery("UPDATE `vtiger_invoice_recurring_info` SET `recurring_frequency` = ? WHERE `recurring_frequency` = ? ;", array($piscklist['name'], '+7 days'));
}
if ($piscklist['name'] == 'Monthly') {
$adb->pquery("UPDATE `vtiger_invoice_recurring_info` SET `recurring_frequency` = ? WHERE `recurring_frequency` = ? ;", array($piscklist['name'], '+1 month'));
}
if ($piscklist['name'] == 'Quarterly') {
$adb->pquery("UPDATE `vtiger_invoice_recurring_info` SET `recurring_frequency` = ? WHERE `recurring_frequency` = ? ;", array($piscklist['name'], '+3 months'));
}
if ($piscklist['name'] == 'Yearly') {
$adb->pquery("UPDATE `vtiger_invoice_recurring_info` SET `recurring_frequency` = ? WHERE `recurring_frequency` = ? ;", array($piscklist['name'], '+1 year'));
}
if ($piscklist['name'] == 'defaulteventstatus' && $moduleName == 'Users') {
$adb->pquery("UPDATE `vtiger_users` SET `defaulteventstatus` = ? WHERE `defaulteventstatus` = ? ;", array($piscklist['name'], 'Not Held'));
}
if ($piscklist['name'] == 'administrative' && $moduleName == 'ProjectMilestone') {
$adb->pquery("UPDATE `vtiger_projectmilestone` SET `projectmilestonetype` = ? WHERE `projectmilestonetype` = ? ;", array($piscklist['name'], 'PLL_INTERNAL'));
}
if ($piscklist['name'] == 'operative' && $moduleName == 'ProjectMilestone') {
$adb->pquery("UPDATE `vtiger_projectmilestone` SET `projectmilestonetype` = ? WHERE `projectmilestonetype` = ? ;", array($piscklist['name'], 'PLL_EXTERNAL'));
}
if ($piscklist['name'] == 'other' && $moduleName == 'ProjectMilestone') {
$adb->pquery("UPDATE `vtiger_projectmilestone` SET `projectmilestonetype` = ? WHERE `projectmilestonetype` = ? ;", array($piscklist['name'], 'PLL_SHARED'));
}
//$moduleModel->remove($piscklist['name'], $deletePicklistId, '', $moduleName); // remove and replace in records
}
}
$adb->pquery("UPDATE `vtiger_projecttaskstatus` SET `projecttaskstatus` = ? WHERE `projecttaskstatus` = ? ;", array('Cancelled', 'Canceled'));
}
$log->debug("Exiting VT620_to_YT::picklists() method ...");
}
