public function process(Vtiger_Request $request)
 {
     if ($_FILES['import_file']['error'] == 0) {
         $tmp_file_name = $_FILES['import_file']['tmp_name'];
         $fh = fopen($tmp_file_name, "r");
         $xml_content = fread($fh, filesize($tmp_file_name));
         fclose($fh);
         $PDFMaker = new PDFMaker_PDFMaker_Model();
         $adb = PearDatabase::getInstance();
         $xml = new SimpleXMLElement($xml_content);
         foreach ($xml->template as $data) {
             $filename = $this->cdataDecode($data->templatename);
             $nameOfFile = $this->cdataDecode($data->filename);
             $description = $this->cdataDecode($data->description);
             $modulename = $this->cdataDecode($data->module);
             $pdf_format = $this->cdataDecode($data->settings->format);
             $pdf_orientation = $this->cdataDecode($data->settings->orientation);
             $tabid = getTabId($modulename);
             if ($PDFMaker->GetVersionType() == "professional" || in_array($tabid, $PDFMaker->GetBasicModules())) {
                 if ($data->settings->margins->top > 0) {
                     $margin_top = $data->settings->margins->top;
                 } else {
                     $margin_top = 0;
                 }
                 if ($data->settings->margins->bottom > 0) {
                     $margin_bottom = $data->settings->margins->bottom;
                 } else {
                     $margin_bottom = 0;
                 }
                 if ($data->settings->margins->left > 0) {
                     $margin_left = $data->settings->margins->left;
                 } else {
                     $margin_left = 0;
                 }
                 if ($data->settings->margins->right > 0) {
                     $margin_right = $data->settings->margins->right;
                 } else {
                     $margin_right = 0;
                 }
                 $dec_point = $this->cdataDecode($data->settings->decimals->point);
                 $dec_decimals = $this->cdataDecode($data->settings->decimals->decimals);
                 $dec_thousands = $this->cdataDecode($data->settings->decimals->thousands);
                 $header = $this->cdataDecode($data->header);
                 $body = $this->cdataDecode($data->body);
                 $footer = $this->cdataDecode($data->footer);
                 $templateid = $adb->getUniqueID('vtiger_pdfmaker');
                 $sql1 = "insert into vtiger_pdfmaker (filename,module,description,body,deleted,templateid) values (?,?,?,?,?,?)";
                 $params1 = array($filename, $modulename, $description, $body, 0, $templateid);
                 $adb->pquery($sql1, $params1);
                 $sql2 = "INSERT INTO vtiger_pdfmaker_settings (templateid, margin_top, margin_bottom, margin_left, margin_right, format, orientation, decimals, decimal_point, thousands_separator, header, footer, encoding, file_name) \n             VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
                 $params2 = array($templateid, $margin_top, $margin_bottom, $margin_left, $margin_right, $pdf_format, $pdf_orientation, $dec_decimals, $dec_point, $dec_thousands, $header, $footer, "auto", $nameOfFile);
                 $adb->pquery($sql2, $params2);
                 $PDFMaker->AddLinks($modulename);
             }
         }
     }
     header('Location: index.php?module=PDFMaker&view=List');
 }

 public function getFieldUI(Vtiger_Request $request)
 {
     $fieldsList = $request->get('fieldIdList');
     $module = $request->get('sourceModule');
     $fieldModelList = Settings_LayoutEditor_Field_Model::getInstanceFromFieldId($fieldsList, getTabId($module));
     $viewer = $this->getViewer($request);
     $qualifiedModuleName = $request->getModule(false);
     $viewer->assign('SELECTED_MODULE_NAME', $module);
     $viewer->assign('USER_MODEL', Users_Record_Model::getCurrentUserModel());
     $viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName);
     $viewer->assign('FIELD_MODELS_LIST', $fieldModelList);
     $viewer->view('FieldUi.tpl', $qualifiedModuleName);
 }

 public function process(Vtiger_Request $request)
 {
     ${"GLOBALS"}["ekosczsy"] = "tabid";
     ${${"GLOBALS"}["ekosczsy"]} = getTabId($request->get("workflowModule"));
     ${"GLOBALS"}["mhuirymtoy"] = "tabid";
     ${${"GLOBALS"}["hvamuhbnnwu"]} = \PearDatabase::getInstance();
     if ($request->get("hidden") == true) {
         ob_start();
     }
     if (!empty(${${"GLOBALS"}["mhuirymtoy"]})) {
         ${"GLOBALS"}["outajbzyo"] = "result";
         ${${"GLOBALS"}["rnhwfqjyx"]} = "SELECT linkid FROM vtiger_links WHERE linktype = 'DETAILVIEWSIDEBARWIDGET' AND linklabel = 'Workflows' AND tabid = " . ${${"GLOBALS"}["bxwgaby"]};
         ${${"GLOBALS"}["dsrfsmvy"]} = $adb->query(${${"GLOBALS"}["rnhwfqjyx"]});
         ${${"GLOBALS"}["xdyqgnxwn"]} = $request->get("MODE");
         $xyxnkgw = "mode";
         if (${${"GLOBALS"}["xdyqgnxwn"]} == "ADD" && $adb->num_rows(${${"GLOBALS"}["outajbzyo"]}) > 1) {
             ${"GLOBALS"}["cnubqpsfrtf"] = "tabid";
             $adb->query("DELETE FROM vtiger_links WHERE (linktype = 'DETAILVIEWSIDEBARWIDGET' OR linktype = 'LISTVIEWSIDEBARWIDGET') AND linklabel = 'Workflows' AND tabid = " . ${${"GLOBALS"}["bxwgaby"]}, true);
             ${${"GLOBALS"}["rnhwfqjyx"]} = "SELECT linkid FROM vtiger_links WHERE linktype = 'DETAILVIEWSIDEBARWIDGET' AND linklabel = 'Workflows' AND tabid = " . ${${"GLOBALS"}["cnubqpsfrtf"]};
             ${${"GLOBALS"}["dsrfsmvy"]} = $adb->query(${${"GLOBALS"}["rnhwfqjyx"]});
         }
         if (${${"GLOBALS"}["xdyqgnxwn"]} == "DEL" || empty(${$xyxnkgw}) && $adb->num_rows(${${"GLOBALS"}["dsrfsmvy"]}) > 0) {
             ${"GLOBALS"}["jywgricc"] = "tabid";
             $lxcddedp = "mode";
             ${$lxcddedp} = "DEL";
             $adb->query("DELETE FROM vtiger_links WHERE (linktype = 'DETAILVIEWSIDEBARWIDGET' OR linktype = 'LISTVIEWSIDEBARWIDGET') AND linklabel = 'Workflows' AND tabid = " . ${${"GLOBALS"}["jywgricc"]}, true);
             echo getTranslatedString("LBL_ACTIVATE_SIDEBAR", "Settings:Workflow2");
         } elseif ($adb->num_rows(${${"GLOBALS"}["dsrfsmvy"]}) == 0) {
             ${"GLOBALS"}["ocotbv"] = "mode";
             ${${"GLOBALS"}["ocotbv"]} = "ADD";
             ${"GLOBALS"}["hdlxhrdrllur"] = "linkid";
             ${${"GLOBALS"}["rzgmacoc"]} = $adb->getUniqueID("vtiger_links");
             $adb->query("INSERT INTO vtiger_links SET linkid = '" . ${${"GLOBALS"}["rzgmacoc"]} . "',linktype = 'DETAILVIEWSIDEBARWIDGET', linklabel = 'Workflows', tabid = " . ${${"GLOBALS"}["bxwgaby"]} . ",linkurl='" . "module=Workflow2&view=SidebarWidget" . "'", true);
             ${${"GLOBALS"}["rzgmacoc"]} = $adb->getUniqueID("vtiger_links");
             $qcahtlck = "tabid";
             $adb->query("INSERT INTO vtiger_links SET linkid = '" . ${${"GLOBALS"}["hdlxhrdrllur"]} . "',linktype = 'LISTVIEWSIDEBARWIDGET', linklabel = 'Workflows', tabid = " . ${$qcahtlck} . ",linkurl='" . "module=Workflow2&src_module=" . $request->get("workflowModule") . "&view=SidebarListWidget" . "'", true);
             echo getTranslatedString("LBL_DEACTIVATE_SIDEBAR", "Settings:Workflow2");
         }
     }
     if ($request->get("hidden") == true) {
         ob_end_clean();
     }
     if ($request->get("workflowModule") == "Calendar") {
         ${"GLOBALS"}["jrpyqoyvdoz"] = "request2";
         ${${"GLOBALS"}["jrpyqoyvdoz"]} = ${${"GLOBALS"}["ognxjavta"]};
         $request->set("MODE", ${${"GLOBALS"}["xdyqgnxwn"]});
         $request->set("workflowModule", "Events");
         $request->set("hidden", true);
         $this->process(${${"GLOBALS"}["ognxjavta"]});
     }
 }

 function process(Vtiger_Request $request)
 {
     ${"GLOBALS"}["kqjqpgyxbpw"] = "row";
     $vkvaqpflee = "aid";
     global $current_user;
     ${"GLOBALS"}["uwhowfopwf"] = "adb";
     ${${"GLOBALS"}["uwhowfopwf"]} = PearDatabase::getInstance();
     $xtjbegglz = "moduleName";
     ${"GLOBALS"}["rpprupo"] = "result";
     ${"GLOBALS"}["chmmqmj"] = "a";
     $byxpixpu = "sql";
     ${${"GLOBALS"}["ntetvnbwqlv"]} = $this->getViewer(${${"GLOBALS"}["ibktcfcj"]});
     ${"GLOBALS"}["fblhutfwj"] = "a";
     $sbwrqfadr = "sql";
     ${$xtjbegglz} = $request->getModule();
     ${"GLOBALS"}["nlplkrnjrcv"] = "sql";
     ${${"GLOBALS"}["urohdigihdy"]} = Vtiger_Module_Model::getInstance(${${"GLOBALS"}["zqodvuvwr"]});
     ${${"GLOBALS"}["lwvdhqdj"]} = (int) $request->get("aid");
     $sglxrinrxh = "userqueue";
     ${${"GLOBALS"}["agpkbjtayb"]} = $request->get("h");
     ${${"GLOBALS"}["fblhutfwj"]} = $request->get("a");
     if (1 == 0 && !empty(${$vkvaqpflee}) && !empty(${${"GLOBALS"}["bezvbhq"]}) && ${${"GLOBALS"}["agpkbjtayb"]} == md5($current_user->id . "##" . ${${"GLOBALS"}["chmmqmj"]} . "##" . ${${"GLOBALS"}["lwvdhqdj"]})) {
     }
     ${${"GLOBALS"}["nlplkrnjrcv"]} = "SELECT\n                    vtiger_wf_confirmation.*,\n                    vtiger_wf_confirmation.id as conf_id,\n                    vtiger_wf_settings.*,\n                    vtiger_wfp_blocks.text as block_title,\n                    vtiger_wfp_blocks.settings as block_settings,\n                    vtiger_users.user_name,\n                    vtiger_users.first_name,\n                    vtiger_users.last_name,\n                    result_user.user_name as result_user_name,\n                    result_user.first_name as result_first_name,\n                    result_user.last_name as result_last_name\n                FROM\n                    vtiger_wf_confirmation_user\n                INNER JOIN vtiger_wf_confirmation ON(vtiger_wf_confirmation.id = vtiger_wf_confirmation_user.confirmation_id)\n                INNER JOIN vtiger_crmentity ON(vtiger_crmentity.crmid = vtiger_wf_confirmation.crmid AND vtiger_crmentity.deleted = 0)\n                INNER JOIN vtiger_wf_settings ON(vtiger_wf_settings.id = vtiger_wf_confirmation.workflow_id)\n                INNER JOIN vtiger_wfp_blocks ON(vtiger_wfp_blocks.id = vtiger_wf_confirmation.blockID)\n                INNER JOIN vtiger_wf_queue ON(vtiger_wf_queue.crmid = vtiger_wf_confirmation.crmid AND vtiger_wf_queue.execID = vtiger_wf_confirmation.execID AND vtiger_wf_queue.block_id =vtiger_wf_confirmation.blockID)\n                INNER JOIN vtiger_users ON(vtiger_users.id = vtiger_wf_confirmation.from_user_id)\n                LEFT JOIN vtiger_users as result_user ON(result_user.id = vtiger_wf_confirmation.result_user_id)\n                WHERE\n                    user_id = " . $current_user->id . " AND vtiger_wf_confirmation.visible = 1\n                GROUP BY\n                    vtiger_wf_confirmation.id ORDER BY block_title\n                ";
     ${${"GLOBALS"}["frlpsfjjm"]} = $adb->query(${$sbwrqfadr}, true);
     ${${"GLOBALS"}["ooixnmkwq"]} = array();
     $pthcdlfddnnh = "result";
     ${"GLOBALS"}["oteaqj"] = "userqueue";
     while (${${"GLOBALS"}["kqjqpgyxbpw"]} = $adb->fetchByAssoc(${$pthcdlfddnnh})) {
         $rmjbqeshhis = "referenceModule";
         $ngcqplp = "referenceModule";
         ${"GLOBALS"}["mlvnybsicfig"] = "workflows";
         ${"GLOBALS"}["eljacioilgx"] = "recordLink";
         ${"GLOBALS"}["dauxpml"] = "numberField";
         if (!is_array(${${"GLOBALS"}["mlvnybsicfig"]}[${${"GLOBALS"}["wmhxuntxqkc"]}["block_title"]])) {
             ${"GLOBALS"}["twbpebpxi"] = "workflows";
             ${${"GLOBALS"}["twbpebpxi"]}[${${"GLOBALS"}["wmhxuntxqkc"]}["block_title"]] = array();
         }
         ${"GLOBALS"}["pmxvjbf"] = "noCols";
         ${$ngcqplp} = ${${"GLOBALS"}["wmhxuntxqkc"]}["module"];
         ${"GLOBALS"}["rfiwxezcqe"] = "referenceModule";
         ${"GLOBALS"}["flnnii"] = "row";
         $hepygdrwkc = "noCols";
         $jdlignnj = "noCols";
         ${"GLOBALS"}["awmkvud"] = "workflows";
         ${"GLOBALS"}["jbchodyllw"] = "row";
         $dnepmkz = "settings";
         ${${"GLOBALS"}["sdhtkdyeuq"]} = CRMEntity::getInstance(${${"GLOBALS"}["rfiwxezcqe"]});
         if (empty(${$jdlignnj}[${${"GLOBALS"}["kkwrpdb"]}])) {
             ${"GLOBALS"}["thejxnd"] = "resultTMP";
             $fsozifcfsw = "row";
             $wnpebq = "resultTMP";
             ${"GLOBALS"}["mfdayznhunx"] = "sql";
             $noipkqjvcbky = "sql";
             ${${"GLOBALS"}["doxebbenfem"]} = "SELECT * FROM vtiger_field WHERE tabid = " . getTabId(${${"GLOBALS"}["wmhxuntxqkc"]}["module"]) . " AND uitype = 4";
             ${${"GLOBALS"}["thejxnd"]} = $adb->query(${${"GLOBALS"}["mfdayznhunx"]});
             $ronvvlcujsa = "sql";
             if ($adb->num_rows(${${"GLOBALS"}["svdtdbgmoc"]}) > 0) {
                 $kwpctersh = "referenceModule";
                 ${${"GLOBALS"}["duijdw"]}[${$kwpctersh}]["link_no"] = $adb->fetchByAssoc(${${"GLOBALS"}["svdtdbgmoc"]});
             } else {
                 ${"GLOBALS"}["shrvsk"] = "referenceModule";
                 ${${"GLOBALS"}["duijdw"]}[${${"GLOBALS"}["shrvsk"]}]["link_no"] = "no_available";
             }
             ${$ronvvlcujsa} = "SELECT * FROM vtiger_field WHERE tabid = " . getTabId(${$fsozifcfsw}["module"]) . " AND fieldname = ?";
             ${$wnpebq} = $adb->pquery(${$noipkqjvcbky}, array($focus->list_link_field));
             if ($adb->num_rows(${${"GLOBALS"}["svdtdbgmoc"]}) > 0) {
                 ${${"GLOBALS"}["duijdw"]}[${${"GLOBALS"}["kkwrpdb"]}]["link_name"] = $adb->fetchByAssoc(${${"GLOBALS"}["svdtdbgmoc"]});
             } else {
                 ${"GLOBALS"}["qgebipdtob"] = "noCols";
                 ${${"GLOBALS"}["qgebipdtob"]}[${${"GLOBALS"}["kkwrpdb"]}]["link_name"] = "no_available";
             }
         }
         ${"GLOBALS"}["hfpqiswtqjc"] = "row";
         ${"GLOBALS"}["dirpsx"] = "referenceModule";
         if (${${"GLOBALS"}["pmxvjbf"]}[${${"GLOBALS"}["kkwrpdb"]}]["link_no"] != "no_available") {
             $yyiomdi = "sql";
             ${"GLOBALS"}["wkhdpyqxx"] = "row";
             $zhhzpgweddf = "referenceModule";
             $jjwpivteyq = "linkFieldRst";
             ${$yyiomdi} = "SELECT " . ${${"GLOBALS"}["duijdw"]}[${$zhhzpgweddf}]["link_no"]["columnname"] . " as nofield FROM " . ${${"GLOBALS"}["duijdw"]}[${${"GLOBALS"}["kkwrpdb"]}]["link_no"]["tablename"] . " WHERE " . $focus->table_index . " = " . ${${"GLOBALS"}["wkhdpyqxx"]}["crmid"];
             ${${"GLOBALS"}["tnvfwhunq"]} = $adb->query(${${"GLOBALS"}["doxebbenfem"]});
             ${${"GLOBALS"}["egivyrgmhu"]} = $adb->query_result(${$jjwpivteyq}, 0, "nofield");
         }
         if (${$hepygdrwkc}[${$rmjbqeshhis}]["link_name"] != "no_available") {
             $wncswbngel = "sql";
             $yrbxtiml = "noCols";
             $zpcmsf = "linkField";
             $tdatiye = "linkFieldRst";
             ${"GLOBALS"}["dfndagpcvie"] = "row";
             ${$wncswbngel} = "SELECT " . ${$yrbxtiml}[${${"GLOBALS"}["kkwrpdb"]}]["link_name"]["columnname"] . " as linkfield FROM " . ${${"GLOBALS"}["duijdw"]}[${${"GLOBALS"}["kkwrpdb"]}]["link_name"]["tablename"] . " WHERE " . $focus->table_index . " = " . ${${"GLOBALS"}["dfndagpcvie"]}["crmid"];
             ${$tdatiye} = $adb->query(${${"GLOBALS"}["doxebbenfem"]});
             ${$zpcmsf} = $adb->query_result(${${"GLOBALS"}["tnvfwhunq"]}, 0, "linkfield");
         }
         ${${"GLOBALS"}["depeexesucr"]} = "<a target='_blank' href='index.php?module={$referenceModule}&view=Detail&record=" . "" . ${${"GLOBALS"}["wmhxuntxqkc"]}["crmid"] . "' title='" . getTranslatedString(${${"GLOBALS"}["kkwrpdb"]}, ${${"GLOBALS"}["kkwrpdb"]}) . "'>" . ${${"GLOBALS"}["seqptb"]} . "</a>";
         ${"GLOBALS"}["gognlbsrc"] = "useBuiltinEncoderDecoder";
         ${"GLOBALS"}["wzyntcdvnerr"] = "settings";
         if (${${"GLOBALS"}["duijdw"]}[${${"GLOBALS"}["dirpsx"]}]["link_no"] != "no_available") {
             $bkzrkriyn = "referenceModule";
             $qlotdcqkwc = "row";
//.........这里部分代码省略.........

 /**
  * Function to initialize the sortby fields array
  */
 function initSortByField($module)
 {
     global $adb, $log;
     $log->debug("Entering function initSortByField ({$module})");
     // Define the columnname's and uitype's which needs to be excluded
     $exclude_columns = array('parent_id', 'quoteid', 'vendorid', 'access_count');
     $exclude_uitypes = array();
     $tabid = getTabId($module);
     if ($module == 'Calendar') {
         $tabid = array('9', '16');
     }
     $sql = "SELECT columnname FROM vtiger_field " . " WHERE (fieldname not like '%\\_id' OR fieldname in ('assigned_user_id'))" . " AND tabid in (" . generateQuestionMarks($tabid) . ") and vtiger_field.presence in (0,2)";
     $params = array($tabid);
     if (count($exclude_columns) > 0) {
         $sql .= " AND columnname NOT IN (" . generateQuestionMarks($exclude_columns) . ")";
         array_push($params, $exclude_columns);
     }
     if (count($exclude_uitypes) > 0) {
         $sql .= " AND uitype NOT IN (" . generateQuestionMarks($exclude_uitypes) . ")";
         array_push($params, $exclude_uitypes);
     }
     $result = $adb->pquery($sql, $params);
     $num_rows = $adb->num_rows($result);
     for ($i = 0; $i < $num_rows; $i++) {
         $columnname = $adb->query_result($result, $i, 'columnname');
         if (in_array($columnname, $this->sortby_fields)) {
             continue;
         } else {
             $this->sortby_fields[] = $columnname;
         }
     }
     if ($tabid == 21 or $tabid == 22) {
         $this->sortby_fields[] = 'crmid';
     }
     $log->debug("Exiting initSortByField");
 }

if ($record == "" && $save != "") {
    $Calendar4You->SaveView($Type_Ids, $Users_Ids, $all_users, $Load_Event_Status, $Load_Task_Status);
}
$detailview_permissions = $Calendar4You->CheckPermissions("DETAIL");
require 'user_privileges/user_privileges_' . $current_user->id . '.php';
require 'user_privileges/sharing_privileges_' . $current_user->id . '.php';
$ParentUsers = array();
$u_query = "select vtiger_user2role.userid as id from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like ?";
$u_params = array($current_user_parent_role_seq . "::%");
$u_result = $adb->pquery($u_query, $u_params);
while ($u_row = $adb->fetchByAssoc($u_result)) {
    $ParentUsers[] = $u_row["id"];
}
$view = convertFullCalendarView($full_calendar_view);
$calendar_tabid = getTabId("Calendar");
$events_tabid = getTabId("Events");
$Showed_Field = array();
$Event_Info = array();
if ($detailview_permissions) {
    $sql0 = "SELECT * FROM its4you_calendar4you_event_fields WHERE userid = ? AND view = ?";
    $result0 = $adb->pquery($sql0, array($current_user->id, $view));
    $num_rows0 = $adb->num_rows($result0);
    if ($num_rows0 > 0) {
        while ($row0 = $adb->fetchByAssoc($result0)) {
            $sql01 = "SELECT uitype, columnname, fieldlabel FROM vtiger_field WHERE fieldname = ? AND tabid IN (?,?)";
            $result01 = $adb->pquery($sql01, array($row0['fieldname'], $calendar_tabid, $events_tabid));
            $columnname = $adb->query_result($result01, 0, "columnname");
            $fieldlabel = $adb->query_result($result01, 0, "fieldlabel");
            $uitype = $adb->query_result($result01, 0, "uitype");
            $Field_data = array("fieldname" => $row0['fieldname'], "columnname" => $columnname, "fieldlabel" => $fieldlabel, "uitype" => $uitype);
            if ($row0['type'] == "1") {

 /** Function to get field that is to be compared in query form for the given Comparator and field
  *  @ param $field : field
  *  returns the value for the comparator 	
  */
 function getFilterComparedField($field)
 {
     global $adb, $ogReport;
     if (!empty($this->secondarymodule)) {
         $secModules = explode(':', $this->secondarymodule);
         foreach ($secModules as $secModule) {
             $secondary = CRMEntity::getInstance($secModule);
             $this->queryPlanner->addTable($secondary->table_name);
         }
     }
     $field = split('#', $field);
     $module = $field[0];
     $fieldname = trim($field[1]);
     $tabid = getTabId($module);
     $field_query = $adb->pquery("SELECT tablename,columnname,typeofdata,fieldname,uitype FROM vtiger_field WHERE tabid = ? AND fieldname= ?", array($tabid, $fieldname));
     $fieldtablename = $adb->query_result($field_query, 0, 'tablename');
     $fieldcolname = $adb->query_result($field_query, 0, 'columnname');
     $typeofdata = $adb->query_result($field_query, 0, 'typeofdata');
     $fieldtypeofdata = ChangeTypeOfData_Filter($fieldtablename, $fieldcolname, $typeofdata[0]);
     $uitype = $adb->query_result($field_query, 0, 'uitype');
     /* if($tr[0]==$ogReport->primodule)
         $value = $adb->query_result($field_query,0,'tablename').".".$adb->query_result($field_query,0,'columnname');
         else
         $value = $adb->query_result($field_query,0,'tablename').$tr[0].".".$adb->query_result($field_query,0,'columnname');
        */
     if ($uitype == 68 || $uitype == 59) {
         $fieldtypeofdata = 'V';
     }
     if ($fieldtablename == "vtiger_crmentity") {
         $fieldtablename = $fieldtablename . $module;
     }
     if ($fieldname == "assigned_user_id") {
         $fieldtablename = "vtiger_users" . $module;
         $fieldcolname = "user_name";
     }
     if ($fieldname == "account_id") {
         $fieldtablename = "vtiger_account" . $module;
         $fieldcolname = "accountname";
     }
     if ($fieldname == "contact_id") {
         $fieldtablename = "vtiger_contactdetails" . $module;
         $fieldcolname = "lastname";
     }
     if ($fieldname == "parent_id") {
         $fieldtablename = "vtiger_crmentityRel" . $module;
         $fieldcolname = "setype";
     }
     if ($fieldname == "vendor_id") {
         $fieldtablename = "vtiger_vendorRel" . $module;
         $fieldcolname = "vendorname";
     }
     if ($fieldname == "potential_id") {
         $fieldtablename = "vtiger_potentialRel" . $module;
         $fieldcolname = "potentialname";
     }
     if ($fieldname == "assigned_user_id1") {
         $fieldtablename = "vtiger_usersRel1";
         $fieldcolname = "user_name";
     }
     if ($fieldname == 'quote_id') {
         $fieldtablename = "vtiger_quotes" . $module;
         $fieldcolname = "subject";
     }
     if ($fieldname == 'product_id' && $fieldtablename == 'vtiger_troubletickets') {
         $fieldtablename = "vtiger_productsRel";
         $fieldcolname = "productname";
     }
     if ($fieldname == 'product_id' && $fieldtablename == 'vtiger_campaign') {
         $fieldtablename = "vtiger_productsCampaigns";
         $fieldcolname = "productname";
     }
     if ($fieldname == 'product_id' && $fieldtablename == 'vtiger_products') {
         $fieldtablename = "vtiger_productsProducts";
         $fieldcolname = "productname";
     }
     if ($fieldname == 'campaignid' && $module == 'Potentials') {
         $fieldtablename = "vtiger_campaign" . $module;
         $fieldcolname = "campaignname";
     }
     $value = $fieldtablename . "." . $fieldcolname;
     $this->queryPlanner->addTable($fieldtablename);
     return $value;
 }

$dropflds = array('com_vtiger_workflows.schtypeid', 'com_vtiger_workflows.schtime', 'com_vtiger_workflows.schdayofmonth', 'com_vtiger_workflows.schdayofweek', 'com_vtiger_workflows.schannualdates', 'com_vtiger_workflows.nexttrigger_time', 'vtiger_mailmanager_mailattachments.cid', 'vtiger_mailscanner_rules.assigned_to', 'vtiger_mailscanner_rules.cc', 'vtiger_mailscanner_rules.bcc', 'vtiger_recurringevents.recurringenddate', 'vtiger_mailscanner.time_zone', 'vtiger_portal.createdtime', 'vtiger_mail_accounts.sent_folder', 'vtiger_organizationdetails.vatid', 'vtiger_tab.trial');
foreach ($dropflds as $fqfn) {
    list($table, $field) = explode('.', $fqfn);
    ExecuteQuery("ALTER TABLE {$table} DROP {$field}");
}
$droptable = array('vtiger_feedback', 'vtiger_shareduserinfo', 'vtiger_schedulereports', 'vtiger_calendar_default_activitytypes', 'vtiger_calendar_user_activitytypes', 'vtiger_reporttype');
foreach ($droptable as $table) {
    ExecuteQuery("DROP TABLE {$table}");
}
//Schema changes for vtiger_troubletickets hours & days column
ExecuteQuery('ALTER TABLE vtiger_troubletickets MODIFY hours varchar(200)', array());
ExecuteQuery('ALTER TABLE vtiger_troubletickets MODIFY days varchar(200)', array());
ExecuteQuery('UPDATE vtiger_field set typeofdata=? WHERE fieldname IN(?,?) AND tablename = ?', array('I~O', 'hours', 'days', 'vtiger_troubletickets'));
Vtiger_Cron::deregister('ScheduleReports');
//Updating actions for PriceBooks related list in Products and Services
$productsTabId = getTabId('Products');
ExecuteQuery('UPDATE vtiger_relatedlists SET actions=? WHERE label=? and tabid=?', array('ADD', 'PriceBooks', $productsTabId));
$eventsManager = new VTEventsManager($adb);
$eventsManager->unregisterHandler('Vtiger_RecordLabelUpdater_Handler');
//Start: Customer - Feature #17656 Allow users to add/remove date format with the date fields in workflow send mail task.
$fieldResult = $adb->pquery('SELECT fieldname, name, typeofdata FROM vtiger_field
  INNER JOIN vtiger_tab ON vtiger_tab.tabid = vtiger_field.tabid WHERE typeofdata LIKE ?', array('D%'));
$dateFieldsList = $dateTimeFieldsList = array();
while ($rowData = $adb->fetch_array($fieldResult)) {
    $moduleName = $rowData['name'];
    $fieldName = $rowData['fieldname'];
    $pos = stripos($rowData['typeofdata'], 'DT');
    if ($pos !== false) {
        $dateTimeFieldsList[$moduleName][$fieldName] = $fieldName;
    } else {
        $dateFieldsList[$moduleName][$fieldName] = $fieldName;

 public function showStatistikForm($viewer)
 {
     global $adb;
     $class = CRMEntity::getInstance($this->getModuleName());
     $fieldname = $class->list_link_field;
     $sql = "SELECT columnname, tablename FROM vtiger_field WHERE tabid = " . getTabId($this->getModuleName()) . " AND fieldname = ?";
     $result = $adb->pquery($sql, array($fieldname));
     $columnName = $adb->query_result($result, 0, "columnname");
     $tableName = $adb->query_result($result, 0, "tablename");
     $sql = "SELECT vtiger_wf_queue.*, recordTBL." . $columnName . " as title\n                FROM vtiger_wf_queue\n                    LEFT JOIN " . $tableName . " as recordTBL ON (recordTBL." . $class->table_index . " = vtiger_wf_queue.crmid)\n                WHERE block_id = " . $this->_taskID;
     $result = $adb->query($sql, true);
     $waiting = array();
     while ($row = $adb->fetch_array($result)) {
         $row["timestamp"] = VtUtils::formatUserDate(VtUtils::convertToUserTZ($row["timestamp"]));
         $row["nextsteptime"] = VtUtils::formatUserDate(VtUtils::convertToUserTZ($row["nextsteptime"]));
         $waiting[] = $row;
     }
     $viewer->assign("waiting", $waiting);
 }

$usersTabId = getTabId('Users');
$blockIds = array();
$blockIds[] = getBlockId($usersTabId, 'LBL_USERLOGIN_ROLE');
$blockIds[] = getBlockId($usersTabId, 'LBL_CALENDAR_SETTINGS');
$updateQuery = "UPDATE vtiger_field SET sequence = CASE fieldname ";
foreach ($userFields as $fieldName) {
    if ($fieldName == 'dayoftheweek') {
        $sequence = 0;
    }
    $updateQuery .= " WHEN '{$fieldName}' THEN  " . ++$sequence;
}
$updateQuery .= " END WHERE tabid = {$usersTabId} AND block IN (" . generateQuestionMarks($blockIds) . ")";
Migration_Index_View::ExecuteQuery($updateQuery, $blockIds);
echo "<br>User Fields Sequence Updated";
// updating Emails module in sharing access rules
$EmailsTabId = getTabId('Emails');
$query = "SELECT tabid FROM vtiger_def_org_share";
$result = $adb->pquery($query, array());
$resultCount = $adb->num_rows($result);
$exist = false;
for ($i = 0; $i < $resultCount; $i++) {
    $tabid = $adb->query_result($result, $i, 'tabid');
    if ($tabid == $EmailsTabId) {
        $exist = true;
        echo 'Emails Sharing Access entry already exist';
        break;
    }
}
if (!$exist) {
    $ruleid = $adb->getUniqueID('vtiger_def_org_share');
    $shareaccessquery = "INSERT INTO vtiger_def_org_share VALUES(?,?,?,?)";

 public function process(Vtiger_Request $request)
 {
     $suqqivj = "params";
     $abnhbiiwjxgw = "uitypes";
     ${"GLOBALS"}["cxfpljg"] = "workflowID";
     $oythwcwuij = "params";
     $uxwwlkkdmi = "type";
     $ymsjqqh = "params";
     $rnglpjgj = "params";
     $mbwcsxgslm = "params";
     $xqdffflqhid = "moduleFields";
     $vkrksu = "blockValue";
     $uhvudfgft = "workflowID";
     ${${"GLOBALS"}["ftxpwggzrr"]} = PearDatabase::getInstance();
     ${"GLOBALS"}["ykxzyofbq"] = "type";
     ${${"GLOBALS"}["tfaukbzz"]} = $request->getAll();
     ${$uhvudfgft} = intval(${$ymsjqqh}["workflowID"]);
     if (!empty(${$suqqivj}["workflow_module"])) {
         $kibqefvtfv = "tabID";
         ${${"GLOBALS"}["jvgzmmkv"]} = getTabId(${${"GLOBALS"}["tfaukbzz"]}["workflow_module"]);
         if (empty(${$kibqefvtfv})) {
             return "";
         }
     }
     ${${"GLOBALS"}["ykxzyofbq"]} = ${$rnglpjgj}["type"];
     $ygweexnlwsne = "params";
     ${"GLOBALS"}["dxsvbac"] = "uitypes";
     ${"GLOBALS"}["qkfvanhv"] = "init";
     switch (${$uxwwlkkdmi}) {
         case "email":
             ${$abnhbiiwjxgw} = array(13, 104);
             break;
         default:
             ${${"GLOBALS"}["dxsvbac"]} = false;
             break;
     }
     $qmicsdts = "sql";
     if (!empty(${${"GLOBALS"}["tfaukbzz"]}["workflow_module"])) {
         ${${"GLOBALS"}["znsxayvgwv"]} = VtUtils::getFieldsWithBlocksForModule(${${"GLOBALS"}["tfaukbzz"]}["workflow_module"], true, ${${"GLOBALS"}["tfaukbzz"]}["reftemplate"]);
     } else {
         ${${"GLOBALS"}["znsxayvgwv"]} = array();
     }
     echo "<div style=\"padding:10px;\">";
     echo "<p>" . getTranslatedString("LBL_INSERT_TEMPLATE_VARIABLE", "Workflow2") . ":</p>";
     echo "<select id=\"insertTemplateField_Select\" class=\"chzn-select\" style=\"width:400px;\">";
     if (!empty(${$oythwcwuij}["functions"]) && ${${"GLOBALS"}["tfaukbzz"]}["functions"] == "1") {
         echo "<optgroup label=\"" . getTranslatedString("global functions", "Workflow2") . "\">";
         echo "<option value='[Now]'>Now()</option>";
         echo "<option value='[Now,-x]'>" . sprintf(getTranslatedString("- %s days", "Workflow2"), "x") . "</option>";
         echo "<option value='[Now,+x]'>" . sprintf(getTranslatedString("+ %s days", "Workflow2"), "x") . "</option>";
         echo "<option value='" . "{ ..custom function.. }}>'>" . "\$" . "{ ..custom function.. }}></option>";
         echo "</optgroup>";
     }
     if (!empty(${$mbwcsxgslm}["refFields"]) && ${$ygweexnlwsne}["refFields"] == "true") {
         ${"GLOBALS"}["xgflwscx"] = "references";
         $mnvhxhvbhsb = "params";
         ${"GLOBALS"}["drqyeiujrim"] = "references";
         ${${"GLOBALS"}["xgflwscx"]} = VtUtils::getReferenceFieldsForModule(${$mnvhxhvbhsb}["workflow_module"]);
         echo "<optgroup label=\"" . getTranslatedString("LBL_REFERENCES", "Workflow2") . "\">";
         echo "<option value=\"id\">" . getTranslatedString("LBL_ID_OF_CURRENT_RECORD", "Workflow2") . "&nbsp;&nbsp;(" . getTranslatedString(${${"GLOBALS"}["tfaukbzz"]}["workflow_module"], ${${"GLOBALS"}["tfaukbzz"]}["workflow_module"]) . ")</option>";
         foreach (${${"GLOBALS"}["drqyeiujrim"]} as ${${"GLOBALS"}["dafepd"]}) {
             ${"GLOBALS"}["nnqztiblbs"] = "ref";
             $slunrgqfhwlo = "ref";
             ${${"GLOBALS"}["mnppne"]} = str_replace(array("[source]", "[module]", "[destination]"), array(${${"GLOBALS"}["dafepd"]}["fieldname"], ${${"GLOBALS"}["dafepd"]}["module"], "id"), "([source]: ([module]) [destination])");
             $tauosxbwiycy = "name";
             echo "<option value=\"" . ${$tauosxbwiycy} . "\">" . getTranslatedString(${${"GLOBALS"}["dafepd"]}["fieldlabel"], ${$slunrgqfhwlo}["module"]) . "&nbsp;&nbsp;&nbsp;(" . getTranslatedString(${${"GLOBALS"}["nnqztiblbs"]}["module"], ${${"GLOBALS"}["dafepd"]}["module"]) . ")</option>";
         }
         echo "</optgroup>";
     } else {
         echo "<option value=\"id\">" . getTranslatedString("LBL_ID_OF_CURRENT_RECORD", "Workflow2") . "</option>";
     }
     ${${"GLOBALS"}["qkfvanhv"]} = false;
     ${${"GLOBALS"}["rpwlinoeruc"]} = false;
     foreach (${$xqdffflqhid} as ${${"GLOBALS"}["fugvczqprg"]} => ${$vkrksu}) {
         $pqfbxvx = "blockKey";
         $pkuwndqwc = "blockValue";
         ${"GLOBALS"}["xngsjfeis"] = "field";
         ${"GLOBALS"}["zfcscyqss"] = "init";
         $ysessmc = "close";
         ${${"GLOBALS"}["zfcscyqss"]} = "<optgroup label=\"" . ${$pqfbxvx} . "\">";
         foreach (${$pkuwndqwc} as ${${"GLOBALS"}["nmluafbbj"]} => ${${"GLOBALS"}["xngsjfeis"]}) {
             $mmgjtjrsvqg = "uitypes";
             $nbgdqimtjfi = "uitypes";
             if (${$nbgdqimtjfi} === false || in_array($field->uitype, ${$mmgjtjrsvqg})) {
                 $fhgjjmpn = "init";
                 if (${$fhgjjmpn} !== false) {
                     ${"GLOBALS"}["ucznnblkwte"] = "init";
                     $htciocvmhgj = "close";
                     echo ${${"GLOBALS"}["ucznnblkwte"]};
                     ${${"GLOBALS"}["hdyprkrhczq"]} = false;
                     ${$htciocvmhgj} = true;
                 }
                 echo "<option value='" . $field->name . "'>" . $field->label . "</option>";
             }
         }
         if (${$ysessmc} == true) {
             echo "</optgroup>";
         }
     }
     ${$qmicsdts} = "SELECT * FROM vtiger_wfp_blocks WHERE workflow_id = " . ${${"GLOBALS"}["cxfpljg"]} . " AND env_vars != ''";
//.........这里部分代码省略.........

 public function removeLinks()
 {
     require_once 'vtlib/Vtiger/Link.php';
     $tabid = getTabId("XMLExport4You");
     Vtiger_Link::deleteAll($tabid);
     $this->DeleteAllRefLinks();
 }

 private function x0b()
 {
     global $x0b, $x0c, $x0d, $x0e, $x0f, $x10, $x11, $x12, $x13, $x14, $x15, $x16, $x17, $x18, $x19, $x1a, $x1b, $x1c, $x1d, $x1e, $x1f, $x20, $x21, $x22, $x23, $x24, $x25, $x26;
     $sql = "SELECT fieldid, fieldname, uitype\r\r\n              FROM vtiger_field\r\n              WHERE tabid=" . getTabId($this->module) . " AND (displaytype != 3 OR fieldid = 64) AND fieldid != 105";
     $result = $this->db->query($sql);
     $num_rows = $this->db->num_rows($result);
     if ($num_rows > 0) {
         while ($row = $this->db->fetch_array($result)) {
             $related_module = "";
             $fk_record = $this->focus->column_fields[$row["fieldname"]];
             switch ($row["uitype"]) {
                 case "51":
                     $related_module = "Accounts";
                     break;
                 case "57":
                     $related_module = "Contacts";
                     break;
                 case "58":
                     $related_module = "Campaigns";
                     break;
                 case "59":
                     $related_module = "Products";
                     break;
                 case "73":
                     $related_module = "Accounts";
                     break;
                 case "75":
                     $related_module = "Vendors";
                     break;
                 case "81":
                     $related_module = "Vendors";
                     break;
                 case "76":
                     $related_module = "Potentials";
                     break;
                 case "78":
                     $related_module = "Quotes";
                     break;
                 case "80":
                     $related_module = "SalesOrder";
                     break;
                 case "68":
                 case "10":
                     $related_module = getSalesEntityType($fk_record);
                     break;
             }
             if ($related_module != "") {
                 $tabid = getTabId($related_module);
                 $field_inf = "_fieldinfo_cache";
                 $temp =& VTCacheUtils::${$field_inf};
                 unset($temp[$tabid]);
                 $focus2 = CRMEntity::getInstance($related_module);
                 if ($fk_record != "" && $fk_record != "0") {
                     $result_delete = $this->db->query("SELECT deleted FROM vtiger_crmentity WHERE crmid='" . $fk_record . "' AND deleted=0");
                     if ($this->db->num_rows($result_delete) > 0) {
                         $focus2->retrieve_entity_info($fk_record, $related_module);
                         $focus2->id = $fk_record;
                     }
                 }
                 $this->replacements["\$" . "R_" . $x22($related_module) . "_CRMID\$"] = $focus2->id;
                 if (isset($related_module) and $related_module == "Contacts") {
                     $this->replacements['$R_CONTACTS_IMAGENAME$'] = $this->x18($focus2->id);
                 }
                 $this->x12();
                 $this->x0e($related_module, $focus2, true);
                 unset($focus2);
             }
             if ($row["uitype"] == "10" || $row["uitype"] == "68") {
                 if ($related_module == "Accounts") {
                     $related_module2 = "Contacts";
                 } else {
                     $related_module2 = "Accounts";
                 }
                 $tabid2 = getTabId($related_module2);
                 $field_inf = "_fieldinfo_cache";
                 $temp =& VTCacheUtils::${$field_inf};
                 unset($temp[$tabid2]);
                 $focus3 = CRMEntity::getInstance($related_module2);
                 $this->replacements["\$" . "R_" . $x22($related_module2) . "_CRMID\$"] = $focus3->id;
                 $this->x0e($related_module2, $focus3, true);
                 unset($focus3);
             }
         }