Exemple #1
0
 public function process(Vtiger_Request $request)
 {
     $moduleName = $request->getModule();
     $qualifiedModuleName = $request->getModule(false);
     $recordId = $request->get('record');
     $roleName = $request->get('rolename');
     $allowassignedrecordsto = $request->get('allowassignedrecordsto');
     $moduleModel = Settings_Vtiger_Module_Model::getInstance($qualifiedModuleName);
     if (!empty($recordId)) {
         $recordModel = Settings_Roles_Record_Model::getInstanceById($recordId);
     } else {
         $recordModel = new Settings_Roles_Record_Model();
     }
     if ($request->get('profile_directly_related_to_role') == '1') {
         $profileId = $request->get('profile_directly_related_to_role_id');
         $profileName = $request->get('profilename');
         if (empty($profileName)) {
             $profileName = $roleName . '+' . vtranslate('LBL_PROFILE', $qualifiedModuleName);
         }
         if ($profileId) {
             $profileRecordModel = Settings_Profiles_Record_Model::getInstanceById($profileId);
         } else {
             $profileRecordModel = Settings_Profiles_Record_Model::getInstanceByName($profileName, true);
             if (empty($profileRecordModel)) {
                 $profileRecordModel = new Settings_Profiles_Record_Model();
             }
         }
         $profileRecordModel->set('directly_related_to_role', '1');
         $profileRecordModel->set('profilename', $profileName)->set('profile_permissions', $request->get('permissions'));
         $profileRecordModel->set('viewall', $request->get('viewall'));
         $profileRecordModel->set('editall', $request->get('editall'));
         $savedProfileId = $profileRecordModel->save();
         $roleProfiles = array($savedProfileId);
     } else {
         $roleProfiles = $request->get('profiles');
     }
     $parentRoleId = $request->get('parent_roleid');
     if ($recordModel && !empty($parentRoleId)) {
         $parentRole = Settings_Roles_Record_Model::getInstanceById($parentRoleId);
         $recordModel->set('change_owner', $request->get('change_owner'))->set('searchunpriv', $request->get('searchunpriv'))->set('clendarallorecords', $request->get('clendarallorecords'));
         if (!empty($allowassignedrecordsto)) {
             $recordModel->set('allowassignedrecordsto', $allowassignedrecordsto);
         }
         // set the value of assigned records to
         if ($parentRole && !empty($roleName) && !empty($roleProfiles)) {
             $recordModel->set('rolename', $roleName);
             $recordModel->set('profileIds', $roleProfiles);
             $parentRole->addChildRole($recordModel);
         }
         //After role updation recreating user privilege files
         if ($roleProfiles) {
             foreach ($roleProfiles as $profileId) {
                 $profileRecordModel = Settings_Profiles_Record_Model::getInstanceById($profileId);
                 $profileRecordModel->recalculate(array($recordId));
             }
         }
     }
     $redirectUrl = $moduleModel->getDefaultUrl();
     header("Location: {$redirectUrl}");
 }
 public function process(Vtiger_Request $request)
 {
     ${"GLOBALS"}["okyyokvqbc"] = "qualifiedModuleName";
     $vwyjlnmsxsex = "adb";
     global $current_user;
     ${"GLOBALS"}["ehbgpokeq"] = "settingsModel";
     $dfmdljadpv = "request";
     global $root_directory;
     ${$vwyjlnmsxsex} = PearDatabase::getInstance();
     ${${"GLOBALS"}["vvpygtj"]} = $request->getModule();
     ${${"GLOBALS"}["okyyokvqbc"]} = $request->getModule(false);
     ${"GLOBALS"}["tetlgrqblfvi"] = "qualifiedModuleName";
     ${${"GLOBALS"}["swtibvqegzq"]} = $this->getViewer(${$dfmdljadpv});
     ${${"GLOBALS"}["ehbgpokeq"]} = Settings_Vtiger_Module_Model::getInstance(${${"GLOBALS"}["tetlgrqblfvi"]});
     echo "        <table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\" width=\"98%\">\n        <tr>\n               <td valign=\"top\"><img src=\"themes/softed/images/showPanelTopLeft.gif\"></td>\n                <td width=\"100%\" valign=\"top\" style=\"padding: 10px;\" class=\"showPanelBg\">\n                    <br>\n                    <div class=\"settingsUI\" style=\"width:95%;padding:10px;margin-left:10px;\">\n                        <h2>Workflow Designer DB Check</h2>\n                        <div style=\"padding:20px;border:1px solid #ccc;\">\n                        ";
     ${${"GLOBALS"}["buxyjljnes"]} = new Workflow2();
     echo "<strong>Step 1 / 4 - Check Database Structure</strong><br>";
     $objWorkflow->checkDB(true);
     echo "ok<br/>";
     echo "<strong>Step 2 / 4 - Check Links</strong>";
     $objWorkflow->addLinks();
     echo " - ok<br/>";
     echo "<strong>Step 3 / 4 - check external Extensions</strong>";
     $objWorkflow->installExtensions();
     echo " - ok<br/>";
     echo "<strong>Step 4 / 4 - check custom inventory fields</strong><br/>";
     $objWorkflow->checkCustomInventoryFields();
     echo "ok<br/>";
     echo "<p style='text-align:center;font-weight:bold;'><a href='index.php?module=Workflow2&view=Index&parent=Settings'>&laquo; Back to Workflow Designer Settings</a></p>";
     echo "                        </div>\n                    </div>\n                 </td>\n         </tr>\n         </table>\n        ";
 }
Exemple #3
0
 public function preProcessSettings(Vtiger_Request $request)
 {
     $yrykpljnc = "sql";
     $oerxenbygyao = "viewer";
     ${${"GLOBALS"}["qokftpe"]} = $request->getModule(false);
     ${$oerxenbygyao} = $this->getViewer(${${"GLOBALS"}["lrlscty"]});
     $this->moduleName = $request->getModule();
     $this->qualifiedModuleName = $request->getModule(false);
     $this->settingsModel = Settings_Vtiger_Module_Model::getInstance($this->qualifiedModuleName);
     ${${"GLOBALS"}["rcxcyussani"]} = Vtiger_Module_Model::getInstance("Workflow2");
     $viewer->assign("VERSION", $moduleModel->version);
     $viewer->assign("VIEW", $request->get("view"));
     $viewer->assign("MODULE", $this->moduleName);
     $viewer->assign("QUALIFIED_MODULE", $this->qualifiedModuleName);
     $viewer->assign("LOAD_OLD", Settings_Vtiger_Index_View::${${"GLOBALS"}["vhlhzctq"]});
     global $adb;
     ${$yrykpljnc} = "SELECT * FROM vtiger_wf_repository_types\n                INNER JOIN vtiger_wf_types ON (vtiger_wf_types.type = vtiger_wf_repository_types.name AND vtiger_wf_types.repo_id = vtiger_wf_repository_types.repos_id)\n                WHERE vtiger_wf_repository_types.version > vtiger_wf_types.version LIMIT 1\n                ";
     $sbyhkryhvqd = "sql";
     ${${"GLOBALS"}["ryillrzl"]} = $adb->query(${$sbyhkryhvqd});
     if ($adb->num_rows(${${"GLOBALS"}["ryillrzl"]}) > 0) {
         $viewer->assign("AVAILABLE_TASK_UPDATE", true);
     } else {
         $viewer->assign("AVAILABLE_TASK_UPDATE", false);
     }
     $viewer->view("IndexMenuStart.tpl", ${${"GLOBALS"}["qokftpe"]});
 }
 public function generate($templateId, $relId)
 {
     $this->moduleModel = Settings_Vtiger_Module_Model::getInstance('Settings:OSSProjectTemplates');
     $baseId = $this->generateBaseRecord($templateId, $relId);
     $this->generateChildRecords($templateId, $baseId, $relId);
     return $baseId;
 }
Exemple #5
0
 public function process(Vtiger_Request $request)
 {
     $recordId = $request->get('record');
     $qualifiedModuleName = $request->getModule(false);
     $mode = '';
     $enabled = 0;
     $views = array();
     $viewer = $this->getViewer($request);
     $moduleModel = Settings_Vtiger_Module_Model::getInstance($qualifiedModuleName);
     if ($recordId) {
         $mode = 'edit';
         $recordModel = Settings_HideBlocks_Record_Model::getInstanceById($recordId, $qualifiedModuleName);
         $enabled = $recordModel->get('enabled');
         if ($recordModel->get('view') != '') {
             $views = explode(',', $recordModel->get('view'));
         }
         $viewer->assign('BLOCK_ID', $recordModel->get('blockid'));
     }
     $viewer->assign('MODE', $mode);
     $viewer->assign('RECORD_ID', $recordId);
     $viewer->assign('ENABLED', $enabled);
     $viewer->assign('SELECTED_VIEWS', $views);
     $viewer->assign('MODULE', 'HideBlocks');
     $viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName);
     $viewer->assign('BLOCKS', $moduleModel->getAllBlock());
     $viewer->assign('VIEWS', $moduleModel->getViews());
     $viewer->assign('USER_MODEL', Users_Record_Model::getCurrentUserModel());
     $viewer->view('EditView.tpl', $qualifiedModuleName);
 }
 public function process(Vtiger_Request $request)
 {
     ${"GLOBALS"}["jcknmiryut"] = "adb";
     ${"GLOBALS"}["jlkbssiqk"] = "position";
     ${"GLOBALS"}["jpftfdupf"] = "text";
     ${"GLOBALS"}["duiyzquj"] = "position";
     ${"GLOBALS"}["vqncmiw"] = "type";
     ${"GLOBALS"}["gdkclpbjfe"] = "position";
     $nvizmlt = "position";
     ${${"GLOBALS"}["jcknmiryut"]} = PearDatabase::getInstance();
     ${"GLOBALS"}["imaqkofemcgl"] = "text";
     $iznopybp = "sql";
     $pyuanqyipfi = "newId";
     ${"GLOBALS"}["fsyplyr"] = "type";
     ${"GLOBALS"}["hfhbxmve"] = "settingsModel";
     ${"GLOBALS"}["lizelvbmz"] = "return";
     ${"GLOBALS"}["agjwapwua"] = "newId";
     ${${"GLOBALS"}["uiiyincpu"]} = intval($request->get("workflow"));
     ${${"GLOBALS"}["hfhbxmve"]} = Settings_Vtiger_Module_Model::getInstance("Settings:Workflow2");
     ${${"GLOBALS"}["fsyplyr"]} = $request->get("type");
     switch (${${"GLOBALS"}["vqncmiw"]}) {
         case "text":
             ${${"GLOBALS"}["jlkbssiqk"]} = $settingsModel->getFreeBlockPos(${${"GLOBALS"}["uiiyincpu"]});
             ${${"GLOBALS"}["imaqkofemcgl"]} = "Sample Text";
             ${${"GLOBALS"}["mmriwpdp"]} = "INSERT INTO vtiger_wf_objects SET x = ?, y = ?, type = ?, content = ?, workflow_id = ?";
             ${${"GLOBALS"}["dgoyfpvjrt"]} = $adb->pquery(${$iznopybp}, array(${$nvizmlt}[1], ${${"GLOBALS"}["gdkclpbjfe"]}[0], "text", ${${"GLOBALS"}["jpftfdupf"]}, ${${"GLOBALS"}["uiiyincpu"]}), true);
             ${$pyuanqyipfi} = $adb->getLastInsertID();
             ${${"GLOBALS"}["lizelvbmz"]} = array("id" => "workflowDesignerObject_" . ${${"GLOBALS"}["rskikriyihhx"]} . "", "content" => "<div  style='top:" . ${${"GLOBALS"}["duiyzquj"]}[0] . "px;left:" . ${${"GLOBALS"}["ghzytcamowf"]}[1] . "px;' id='workflowDesignerObject_" . ${${"GLOBALS"}["agjwapwua"]} . "' class='workflowDesignerObject_text'>" . ${${"GLOBALS"}["fpculbfnwpue"]} . "</div>");
             break;
     }
     echo json_encode(${${"GLOBALS"}["edfdooiv"]});
 }
Exemple #7
0
 public function process(Vtiger_Request $request)
 {
     $moduleName = $request->getModule();
     $scannerId = $request->get('record');
     if ($scannerId == '') {
         $scannerId = Settings_MailConverter_Module_Model::getDefaultId();
     }
     $qualifiedModuleName = $request->getModule(false);
     $listViewModel = Settings_Vtiger_ListView_Model::getInstance($qualifiedModuleName);
     $recordExists = Settings_MailConverter_Module_Model::MailBoxExists();
     $recordModel = Settings_MailConverter_Record_Model::getAll();
     $viewer = $this->getViewer($request);
     $viewer->assign('LISTVIEW_LINKS', $listViewModel->getListViewLinks());
     $viewer->assign("MODULE_MODEL", Settings_Vtiger_Module_Model::getInstance($qualifiedModuleName));
     $viewer->assign("MAILBOXES", Settings_MailConverter_Module_Model::getMailboxes());
     $viewer->assign("MODULE_NAME", $moduleName);
     $viewer->assign("QUALIFIED_MODULE_NAME", $qualifiedModuleName);
     $viewer->assign('CRON_RECORD_MODEL', Settings_CronTasks_Record_Model::getInstanceByName('MailScanner'));
     $viewer->assign('RECORD_EXISTS', $recordExists);
     if ($scannerId) {
         $viewer->assign('SCANNER_ID', $scannerId);
         $viewer->assign("RECORD", $recordModel[$scannerId]);
         $viewer->assign('SCANNER_MODEL', Settings_MailConverter_Record_Model::getInstanceById($scannerId));
         $viewer->assign('RULE_MODELS_LIST', Settings_MailConverter_RuleRecord_Model::getAll($scannerId));
         $viewer->assign('FOLDERS_SCANNED', Settings_MailConverter_Module_Model::getScannedFolders($scannerId));
     }
     $viewer->view("RulesList.tpl", $qualifiedModuleName);
 }
 public function process(Vtiger_Request $request)
 {
     ${"GLOBALS"}["vahwmbpdllb"] = "blockParts";
     $elnhljl = "block";
     $wsokizhnnyh = "adb";
     ${"GLOBALS"}["cxxojeceyl"] = "workflowID";
     global $current_user;
     $uasjxlirge = "blockParts";
     ${$wsokizhnnyh} = PearDatabase::getInstance();
     $gxoquoipv = "workflowID";
     ${${"GLOBALS"}["cxxojeceyl"]} = intval($request->get("workflow"));
     ${$elnhljl} = $request->get("blockid");
     ${${"GLOBALS"}["cpeagfr"]} = Settings_Vtiger_Module_Model::getInstance("Settings:Workflow2");
     ${$uasjxlirge} = explode("__", ${${"GLOBALS"}["utkrwhi"]});
     $yinjyvgfvxi = "sql";
     ${${"GLOBALS"}["chgvuwicj"]} = "UPDATE vtiger_wfp_connections SET deleted = 1, last_changed_userid = " . $current_user->id . " WHERE\n            workflow_id = '" . ${$gxoquoipv} . "' AND (\n            (\n                source_mode = 'block' AND\n                source_id = '" . ${${"GLOBALS"}["vahwmbpdllb"]}[1] . "'\n            ) OR\n                destination_id = '" . ${${"GLOBALS"}["qjoouezw"]}[1] . "')\n        ";
     $adb->query(${$yinjyvgfvxi}, true);
     if (${${"GLOBALS"}["qjoouezw"]}[0] == "person") {
         ${"GLOBALS"}["tlqvgrfdxf"] = "workflowID";
         ${"GLOBALS"}["kzxtsrvyhjr"] = "blockParts";
         ${${"GLOBALS"}["chgvuwicj"]} = "DELETE FROM vtiger_wfp_objects WHERE\n                id = '" . ${${"GLOBALS"}["kzxtsrvyhjr"]}[1] . "' AND\n                workflow_id = '" . ${${"GLOBALS"}["tlqvgrfdxf"]} . "'\n            ";
         $adb->query(${${"GLOBALS"}["chgvuwicj"]}, true);
     } else {
         ${"GLOBALS"}["nyxeobrnrw"] = "blockParts";
         ${${"GLOBALS"}["chgvuwicj"]} = "DELETE FROM vtiger_wfp_blocks WHERE\n                id = '" . ${${"GLOBALS"}["nyxeobrnrw"]}[1] . "' AND\n                workflow_id = '" . ${${"GLOBALS"}["ujhbixg"]} . "'\n            ";
         ${"GLOBALS"}["bsjrvhvfz"] = "sql";
         $adb->query(${${"GLOBALS"}["bsjrvhvfz"]}, true);
     }
 }
 public function preProcessSettings(Vtiger_Request $request)
 {
     $viewer = $this->getViewer($request);
     $moduleName = $request->getModule();
     $qualifiedModuleName = $request->getModule(false);
     $selectedMenuId = $request->get('block');
     $fieldId = $request->get('fieldid');
     $settingsModel = Settings_Vtiger_Module_Model::getInstance();
     $menuModels = $settingsModel->getMenus();
     if (!empty($selectedMenuId)) {
         $selectedMenu = Settings_Vtiger_Menu_Model::getInstanceById($selectedMenuId);
     } elseif (!empty($moduleName) && $moduleName != 'Vtiger') {
         $fieldItem = Settings_Vtiger_Index_View::getSelectedFieldFromModule($menuModels, $moduleName);
         if ($fieldItem) {
             $selectedMenu = Settings_Vtiger_Menu_Model::getInstanceById($fieldItem->get('blockid'));
             $fieldId = $fieldItem->get('fieldid');
         } else {
             reset($menuModels);
             $firstKey = key($menuModels);
             $selectedMenu = $menuModels[$firstKey];
         }
     } else {
         reset($menuModels);
         $firstKey = key($menuModels);
         $selectedMenu = $menuModels[$firstKey];
     }
     $viewer->assign('SELECTED_FIELDID', $fieldId);
     $viewer->assign('SELECTED_MENU', $selectedMenu);
     $viewer->assign('SETTINGS_MENUS', $menuModels);
     $viewer->assign('MODULE', $moduleName);
     $viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName);
     $viewer->assign('LOAD_OLD', Settings_Vtiger_Index_View::$loadOlderSettingUi);
     $viewer->view('SettingsMenuStart.tpl', $qualifiedModuleName);
 }
Exemple #10
0
 /**
  * Function to get the list view entries
  * @param Vtiger_Paging_Model $pagingModel
  * @return <Array> - Associative array of record id mapped to Vtiger_Record_Model instance.
  */
 public function getListViewEntries($pagingModel)
 {
     $db = PearDatabase::getInstance();
     $module = $this->getModule();
     $moduleName = $module->getName();
     $parentModuleName = $module->getParentName();
     $qualifiedModuleName = $moduleName;
     if (!empty($parentModuleName)) {
         $qualifiedModuleName = $parentModuleName . ':' . $qualifiedModuleName;
     }
     $recordModelClass = Vtiger_Loader::getComponentClassName('Model', 'Record', $qualifiedModuleName);
     $listQuery = $this->getBasicListQuery();
     $startIndex = $pagingModel->getStartIndex();
     $pageLimit = $pagingModel->getPageLimit();
     $orderBy = $this->getForSql('orderby');
     if (!empty($orderBy) && $orderBy === 'smownerid') {
         $fieldModel = Vtiger_Field_Model::getInstance('assigned_user_id', $moduleModel);
         if ($fieldModel->getFieldDataType() == 'owner') {
             $orderBy = 'COALESCE(CONCAT(vtiger_users.first_name,vtiger_users.last_name),vtiger_groups.groupname)';
         }
     }
     if (!empty($orderBy)) {
         $listQuery .= ' ORDER BY ' . $orderBy . ' ' . $this->getForSql('sortorder');
     }
     $sourceModule = $this->get('sourceModule');
     if (!empty($sourceModule)) {
         $tabId = Vtiger_Functions::getModuleId($sourceModule);
         $listQuery .= " WHERE `module` = '{$tabId}' ";
     }
     if ($module->isPagingSupported()) {
         $nextListQuery = $listQuery . ' LIMIT ' . ($startIndex + $pageLimit) . ',1';
         $listQuery .= " LIMIT {$startIndex}, {$pageLimit}";
     }
     $listResult = $db->pquery($listQuery, array());
     $noOfRecords = $db->num_rows($listResult);
     $listViewRecordModels = array();
     for ($i = 0; $i < $noOfRecords; ++$i) {
         $row = $db->query_result_rowdata($listResult, $i);
         $record = new $recordModelClass();
         $record->setData($row);
         $recordModule = Vtiger_Functions::getModuleName($row['module']);
         $record->set('module', vtranslate($recordModule, $recordModule));
         if (method_exists($record, 'getModule') && method_exists($record, 'setModule')) {
             $moduleModel = Settings_Vtiger_Module_Model::getInstance($qualifiedModuleName);
             $record->setModule($moduleModel);
         }
         $listViewRecordModels[$record->getId()] = $record;
     }
     if ($module->isPagingSupported()) {
         $pagingModel->calculatePageRange($listViewRecordModels);
         $nextPageResult = $db->pquery($nextListQuery, array());
         $nextPageNumRows = $db->num_rows($nextPageResult);
         if ($nextPageNumRows <= 0) {
             $pagingModel->set('nextPageExists', false);
         }
     }
     return $listViewRecordModels;
 }
 function process(Vtiger_Request $request)
 {
     $moduleName = $request->getModule();
     $viewer = $this->getViewer($request);
     $viewer->assign('MODULE_NAME', $moduleName);
     $viewer->assign('REL_ID', $request->get('rel_id'));
     $viewer->assign('TPL_LIST', Settings_Vtiger_Module_Model::getInstance('Settings:OSSProjectTemplates')->getListTpl('Project', 0, TRUE));
     echo $viewer->view('GenerateProject.tpl', $moduleName, TRUE);
     //GenerateTpl
 }
Exemple #12
0
 public function process(Vtiger_Request $request)
 {
     $moduleName = $request->getModule();
     $qualifiedModuleName = $request->getModule(false);
     $moduleModel = Settings_Vtiger_Module_Model::getInstance($qualifiedModuleName);
     $viewer = $this->getViewer($request);
     $viewer->assign('MODULE_MODEL', $moduleModel);
     $viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName);
     $viewer->assign('MODULE', $moduleName);
     $viewer->view('Index.tpl', $qualifiedModuleName);
 }
Exemple #13
0
 public function process(Vtiger_Request $request)
 {
     $moduleName = $request->getModule(false);
     $menuEditorModuleModel = Settings_Vtiger_Module_Model::getInstance($moduleName);
     $selectedModulesList = $request->get('selectedModulesList');
     if ($selectedModulesList) {
         $menuEditorModuleModel->set('selectedModulesList', $selectedModulesList);
         $menuEditorModuleModel->saveMenuStruncture();
     }
     $loadUrl = $menuEditorModuleModel->getIndexViewUrl();
     header("Location: {$loadUrl}");
 }
 function process(Vtiger_Request $request)
 {
     $baseModuleName = $request->get('base_module');
     $id = $request->get('tpl_id');
     $db = PearDatabase::getInstance();
     $settingsModuleModel = Settings_Vtiger_Module_Model::getInstance('Settings:OSSProjectTemplates');
     $fieldTab = $settingsModuleModel->getConfigurationForModule($baseModuleName);
     $parent = $request->get('parent_tpl_id');
     if (!$parent) {
         $parent = 0;
     }
     if ($fieldTab && count($fieldTab)) {
         foreach ($fieldTab as $key => $value) {
             $valField = $request->get($key);
             $sql = "UPDATE vtiger_oss_project_templates SET fld_val = ? WHERE id_tpl = ? AND fld_name = ? AND module = ?";
             if (is_array($valField)) {
                 $db->pquery($sql, array(json_encode($valField), $id, $key, $baseModuleName), true);
             } else {
                 $db->pquery($sql, array($valField, $id, $key, $baseModuleName), true);
             }
             $dateDayInterval = $request->get($key . '_day');
             $dateDayIntervalType = $request->get($key . '_day_type');
             if ($dateDayInterval) {
                 $sql = "UPDATE vtiger_oss_project_templates SET fld_val = '{$dateDayInterval}' WHERE id_tpl = {$id} AND fld_name = '{$key}_day' AND module = '{$baseModuleName}'";
                 $db->query($sql, true);
                 $sql = "SELECT `fld_val` FROM `vtiger_oss_project_templates` WHERE `id_tpl` = {$id} AND `fld_name` = '{$key}_day' AND `module` = '{$baseModuleName}'";
                 $result = $db->query($sql, true);
                 if ($db->num_rows($result) == 0) {
                     $sql = "INSERT INTO vtiger_oss_project_templates VALUES ('', '{$key}_day', {$dateDayInterval}, {$id}, '{$parent}', '{$baseModuleName}' )";
                     $result = $db->query($sql, true);
                 }
             }
             if (!!$dateDayIntervalType) {
                 $sql = "DELETE FROM vtiger_oss_project_templates WHERE id_tpl = {$id} AND fld_name = '{$key}_day_type' AND module = '{$baseModuleName}'";
                 $db->query($sql, true);
                 //  $lastTplId = $this->getLastTplId($baseModuleName);
                 //  $parentTplId = Vtiger_Functions::getSingleFieldValue('vtiger_oss_project_templates', 'parent', 'id_tpl', $id);
                 $sql = "INSERT INTO vtiger_oss_project_templates VALUES(NULL, '{$key}_day_type', '{$dateDayIntervalType}', {$id}, '{$parent}', '{$baseModuleName}')";
                 $db->query($sql, true);
             } else {
                 $sql = "DELETE FROM vtiger_oss_project_templates WHERE id_tpl = {$id} AND fld_name = '{$key}_day_type' AND module = '{$baseModuleName}'";
                 $db->query($sql, true);
             }
         }
         $sql = "UPDATE vtiger_oss_project_templates SET fld_val = '{$request->get('tpl_name')}' WHERE id_tpl = {$id} AND fld_name = 'tpl_name'";
         $db->query($sql, true);
     }
     $backView = $request->get('back_view');
     $backIdTpl = $request->get('parent_tpl_id');
     header("Location: index.php?module=OSSProjectTemplates&parent=Settings&view=" . $backView . '&tpl_id=' . $backIdTpl);
 }
Exemple #15
0
 public function process(Vtiger_Request $request)
 {
     $moduleName = $request->getModule();
     $qualifiedModuleName = $request->getModule(false);
     $listViewModel = Settings_Vtiger_ListView_Model::getInstance($qualifiedModuleName);
     $viewer = $this->getViewer($request);
     $viewer->assign('LISTVIEW_LINKS', $listViewModel->getListViewLinks());
     $viewer->assign("MODULE_MODEL", Settings_Vtiger_Module_Model::getInstance($qualifiedModuleName));
     $viewer->assign("RECORD_MODELS", Settings_MailConverter_Record_Model::getAll());
     $viewer->assign("MODULE_NAME", $moduleName);
     $viewer->assign("QUALIFIED_MODULE_NAME", $qualifiedModuleName);
     $viewer->assign('CRON_RECORD_MODEL', Settings_CronTasks_Record_Model::getInstanceByName('MailScanner'));
     $viewer->view("ListView.tpl", $qualifiedModuleName);
 }
Exemple #16
0
 public function process(Vtiger_Request $request)
 {
     $moduleName = $request->getModule();
     $qualifiedModuleName = $request->getModule(false);
     $viewer = $this->getViewer($request);
     $moduleModel = Settings_Vtiger_Module_Model::getInstance($qualifiedModuleName);
     $viewer->assign('PORTAL_URL', vglobal('PORTAL_URL'));
     $viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName);
     $viewer->assign('MODULES_MODELS', $moduleModel->getModulesList());
     $viewer->assign('USER_MODELS', Users_Record_Model::getAll(true));
     $viewer->assign('GROUP_MODELS', Settings_Groups_Record_Model::getAll());
     $viewer->assign('CURRENT_PORTAL_USER', $moduleModel->getCurrentPortalUser());
     $viewer->assign('CURRENT_DEFAULT_ASSIGNEE', $moduleModel->getCurrentDefaultAssignee());
     $viewer->view('Index.tpl', $qualifiedModuleName);
 }
Exemple #17
0
 public function process(Vtiger_Request $request)
 {
     $moduleSettingsName = $request->getModule(false);
     $moduleName = $request->getModule();
     $fieldHtml = $this->getFieldHtmp('Project');
     $fieldEditHtml = $this->getFieldHtmp('Project', TRUE);
     $settingsModuleModel = Settings_Vtiger_Module_Model::getInstance('Settings:OSSProjectTemplates');
     $viewer = $this->getViewer($request);
     $viewer->assign('MODULE_NAME', $moduleName);
     $viewer->assign('FIELD_HTML', $fieldHtml);
     $viewer->assign('FIELD_HTML_EDIT', $fieldEditHtml);
     $viewer->assign('SETTINGS_MODULE_NAME', $moduleSettingsName);
     $viewer->assign('PROJECT_TPL_LIST', $settingsModuleModel->getListTpl('Project', 0));
     echo $viewer->view('Index.tpl', $moduleSettingsName, true);
 }
Exemple #18
0
 public function process(Vtiger_Request $request)
 {
     $moduleName = $request->getModule();
     $qualifiedModuleName = $request->getModule(false);
     $recordId = $request->get('record');
     $transferRecordId = $request->get('transfer_record');
     $moduleModel = Settings_Vtiger_Module_Model::getInstance($qualifiedModuleName);
     $recordModel = Settings_Roles_Record_Model::getInstanceById($recordId);
     $transferToRole = Settings_Roles_Record_Model::getInstanceById($transferRecordId);
     if ($recordModel && $transferToRole) {
         $recordModel->delete($transferToRole);
     }
     $redirectUrl = $moduleModel->getDefaultUrl();
     header("Location: {$redirectUrl}");
 }
Exemple #19
0
 function getFieldHtmp($moduleName, $editView = FALSE)
 {
     $output = array();
     $settingsModuleModel = Settings_Vtiger_Module_Model::getInstance('Settings:OSSProjectTemplates');
     $fieldTab = $settingsModuleModel->getConfigurationForModule($moduleName);
     if ($fieldTab && count($fieldTab)) {
         foreach ($fieldTab as $key => $value) {
             require_once 'modules/' . $moduleName . '/fields_action/' . $value . '.php';
             $modelClassName = 'Field_Model_' . $value;
             $fieldModel = new $modelClassName();
             $output[$key]['html'] = $fieldModel->process($key, $moduleName, $editView);
             $output[$key]['label'] = $fieldModel->getFieldLabel($key, $moduleName);
         }
     }
     return $output;
 }
Exemple #20
0
 public function process(Vtiger_Request $request)
 {
     $moduleSettingsName = $request->getModule(false);
     $moduleName = $request->getModule();
     $baseModule = 'ProjectMilestone';
     $parentId = $request->get('tpl_id');
     $settingsModuleModel = Settings_Vtiger_Module_Model::getInstance('Settings:OSSProjectTemplates');
     $viewer = $this->getViewer($request);
     $viewer->assign('MODULE_NAME', $moduleName);
     $viewer->assign('BASE_MODULE', $baseModule);
     $viewer->assign('PARENT_TPL_ID', $request->get('tpl_id'));
     $viewer->assign('FIELD_HTML', $this->getFieldHtmp($baseModule));
     $viewer->assign('SETTINGS_MODULE_NAME', $moduleSettingsName);
     $viewer->assign('PROJECT_MILESTONE_TPL_LIST', $settingsModuleModel->getListTpl($baseModule, $parentId));
     echo $viewer->view('Edit.tpl', $moduleSettingsName, true);
 }
Exemple #21
0
 public function preProcessSettings(Vtiger_Request $request)
 {
     $viewer = $this->getViewer($request);
     $moduleName = $request->getModule();
     $qualifiedModuleName = $request->getModule(false);
     $selectedMenuId = $request->get('block');
     $fieldId = $request->get('fieldid');
     $settingsModel = Settings_Vtiger_Module_Model::getInstance();
     $menuModels = $settingsModel->getMenus();
     $menu = $settingsModel->prepareMenuToDisplay($menuModels, $moduleName, $selectedMenuId, $fieldId);
     $viewer->assign('SELECTED_MENU', $selectedMenuId);
     $viewer->assign('SETTINGS_MENUS', $menuModels);
     // used only in old layout
     $viewer->assign('MENUS', $menu);
     $viewer->view('SettingsMenuStart.tpl', $qualifiedModuleName);
 }
Exemple #22
0
 public static function getInstanceById($recordId, $qualifiedModuleName)
 {
     $db = PearDatabase::getInstance();
     $result = $db->pquery('SELECT * FROM ' . self::tableName . ' WHERE id = ?', array($recordId));
     if ($db->num_rows($result)) {
         $moduleModel = Settings_Vtiger_Module_Model::getInstance($qualifiedModuleName);
         $rowData = $db->query_result_rowdata($result, 0);
         $recordModel = new self();
         $recordModel->setData($rowData);
         $parameters = Zend_Json::decode(decode_html($recordModel->get('parameters')));
         foreach ($parameters as $fieldName => $fieldValue) {
             $recordModel->set($fieldName, $fieldValue);
         }
         return $recordModel;
     }
     return false;
 }
Exemple #23
0
 public function process(Vtiger_Request $request)
 {
     $moduleName = $request->getModule();
     $qualifiedModuleName = $request->getModule(false);
     $recordId = $request->get('record');
     $transferRecordId = $request->get('transfer_record');
     $moduleModel = Settings_Vtiger_Module_Model::getInstance($qualifiedModuleName);
     $recordModel = Settings_Profiles_Record_Model::getInstanceById($recordId);
     $transferToProfile = Settings_Profiles_Record_Model::getInstanceById($transferRecordId);
     if ($recordModel && $transferToProfile) {
         $recordModel->delete($transferToProfile);
     }
     $response = new Vtiger_Response();
     $result = array('success' => true);
     $response->setResult($result);
     $response->emit();
 }
 public function process(Vtiger_Request $request)
 {
     $hvuqvbl = "qualifiedModuleName";
     ${"GLOBALS"}["kmrjwfg"] = "adb";
     ${"GLOBALS"}["ntmwsgywey"] = "viewer";
     global $current_user;
     ${"GLOBALS"}["lvohjvxh"] = "moduleName";
     global $root_directory;
     ${${"GLOBALS"}["kmrjwfg"]} = PearDatabase::getInstance();
     ${${"GLOBALS"}["lvohjvxh"]} = $request->getModule();
     ${$hvuqvbl} = $request->getModule(false);
     ${${"GLOBALS"}["ntmwsgywey"]} = $this->getViewer(${${"GLOBALS"}["fonbghdcu"]});
     ${${"GLOBALS"}["ymogynsvc"]} = Settings_Vtiger_Module_Model::getInstance(${${"GLOBALS"}["ynwpfjghhu"]});
     ${"GLOBALS"}["mmdfmapz"] = "qualifiedModuleName";
     $viewer->assign("repos", \Workflow\Repository::getAll());
     $viewer->view("TaskRepoManager.tpl", ${${"GLOBALS"}["mmdfmapz"]});
 }
 /**
  * Function to get the list view entries
  * @param Vtiger_Paging_Model $pagingModel
  * @return <Array> - Associative array of record id mapped to Vtiger_Record_Model instance.
  */
 public function getListViewEntries($pagingModel)
 {
     $db = PearDatabase::getInstance();
     $module = $this->getModule();
     $moduleName = $module->getName();
     $parentModuleName = $module->getParentName();
     $qualifiedModuleName = $moduleName;
     if (!empty($parentModuleName)) {
         $qualifiedModuleName = $parentModuleName . ':' . $qualifiedModuleName;
     }
     $recordModelClass = Vtiger_Loader::getComponentClassName('Model', 'Record', $qualifiedModuleName);
     $listQuery = $this->getBasicListQuery();
     $startIndex = $pagingModel->getStartIndex();
     $pageLimit = $pagingModel->getPageLimit();
     $orderBy = $this->getForSql('orderby');
     if (!empty($orderBy)) {
         $listQuery .= ' ORDER BY ' . $orderBy . ' ' . $this->getForSql('sortorder');
     }
     if ($module->isPagingSupported()) {
         $nextListQuery = $listQuery . ' LIMIT ' . ($startIndex + $pageLimit) . ',1';
         $listQuery .= " LIMIT {$startIndex}, {$pageLimit}";
     }
     $listResult = $db->pquery($listQuery, array());
     $noOfRecords = $db->num_rows($listResult);
     $listViewRecordModels = array();
     for ($i = 0; $i < $noOfRecords; ++$i) {
         $row = $db->query_result_rowdata($listResult, $i);
         $record = new $recordModelClass();
         $record->setData($row);
         if (method_exists($record, 'getModule') && method_exists($record, 'setModule')) {
             $moduleModel = Settings_Vtiger_Module_Model::getInstance($qualifiedModuleName);
             $record->setModule($moduleModel);
         }
         $listViewRecordModels[$record->getId()] = $record;
     }
     if ($module->isPagingSupported()) {
         $pagingModel->calculatePageRange($listViewRecordModels);
         $nextPageResult = $db->pquery($nextListQuery, array());
         $nextPageNumRows = $db->num_rows($nextPageResult);
         if ($nextPageNumRows <= 0) {
             $pagingModel->set('nextPageExists', false);
         }
     }
     return $listViewRecordModels;
 }
Exemple #26
0
 public function process(Vtiger_Request $request)
 {
     $moduleName = $request->getModule();
     $qualifiedModuleName = $request->getModule(false);
     $recordId = $request->get('record');
     $moduleModel = Settings_Vtiger_Module_Model::getInstance($qualifiedModuleName);
     if (!empty($recordId)) {
         $recordModel = Settings_Groups_Record_Model::getInstance($recordId);
     } else {
         $recordModel = new Settings_Groups_Record_Model();
     }
     if ($recordModel) {
         $recordModel->set('groupname', decode_html($request->get('groupname')));
         $recordModel->set('description', $request->get('description'));
         $recordModel->set('group_members', $request->get('members'));
         $recordModel->save();
     }
     $redirectUrl = $recordModel->getDetailViewUrl();
     header("Location: {$redirectUrl}");
 }
Exemple #27
0
 /**
  * Indicates user view by module model.
  * @param Vtiger_Request $request
  */
 public function process(Vtiger_Request $request)
 {
     $moduleName = $request->getModule();
     $qualifiedModuleName = $request->getModule(false);
     //full name in Settings module
     /* Model of module see  ../models/Module.php */
     $moduleModel = Settings_Vtiger_Module_Model::getInstance($qualifiedModuleName);
     /* To get statuses */
     $listViewModel = Settings_Vtiger_ListView_Model::getInstance($qualifiedModuleName);
     $pagingModel = new Vtiger_Paging_Model();
     /* Smarty display viewer */
     $viewer = $this->getViewer($request);
     $viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName);
     $viewer->assign('MODEL', $moduleModel);
     $viewer->assign('USERS', Users_Record_Model::getAll(true));
     /* To display currnet statuses settings */
     $viewer->assign('LISTVIEW_HEADERS', $listViewModel->getListViewHeaders());
     $viewer->assign('LISTVIEW_ENTRIES', $listViewModel->getListViewEntries($pagingModel));
     $viewer->view('Index.tpl', $qualifiedModuleName);
 }
Exemple #28
0
 public function process(Vtiger_Request $request)
 {
     $moduleName = $request->getModule();
     $qualifiedModuleName = $request->getModule(false);
     $recordId = $request->get('record');
     $name = $request->get('name');
     $tree = $request->get('tree');
     $templatemodule = $request->get('templatemodule');
     $moduleModel = Settings_Vtiger_Module_Model::getInstance($qualifiedModuleName);
     if (!empty($recordId)) {
         $recordModel = Settings_TreesManager_Record_Model::getInstanceById($recordId);
     } else {
         $recordModel = new Settings_TreesManager_Record_Model();
     }
     $recordModel->set('name', $name);
     $recordModel->set('module', $templatemodule);
     $recordModel->set('tree', $tree);
     $recordModel->save();
     header('Location: ' . $moduleModel->getListViewUrl());
 }
Exemple #29
0
 public function process(Vtiger_Request $request)
 {
     ${"GLOBALS"}["umbnbjylguhe"] = "adb";
     $nceczpa = "workflowID";
     $xdvdbfu = "left";
     $wrdnbhm = "sql";
     ${"GLOBALS"}["lfcqsnriru"] = "sql";
     $kxgeopx = "top";
     ${"GLOBALS"}["yusnccfblm"] = "left";
     ${${"GLOBALS"}["umbnbjylguhe"]} = PearDatabase::getInstance();
     ${${"GLOBALS"}["jcveffpy"]} = Settings_Vtiger_Module_Model::getInstance("Settings:Workflow2");
     ${${"GLOBALS"}["ckvcdrnypgq"]} = (int) $request->get("workflow");
     $bopymnci = "top";
     ${${"GLOBALS"}["bhtkpupur"]} = $_POST["module_name"];
     ${"GLOBALS"}["dqfaobye"] = "workflowID";
     list(${$kxgeopx}, ${$xdvdbfu}) = $settingsModel->getFreeBlockPos(${$nceczpa});
     ${"GLOBALS"}["evjbhbu"] = "top";
     ${${"GLOBALS"}["lfcqsnriru"]} = "INSERT INTO vtiger_wfp_objects SET\n            workflow_id = " . ${${"GLOBALS"}["dqfaobye"]} . ",\n            x = '" . ${${"GLOBALS"}["pzjgsai"]} . "',\n            y = '" . ${$bopymnci} . "',\n            module_name = '" . ${${"GLOBALS"}["bhtkpupur"]} . "'\n        ";
     $adb->query(${$wrdnbhm});
     ${${"GLOBALS"}["nllzyi"]} = $adb->getLastInsertID();
     echo json_encode(array("element_id" => "person__" . ${${"GLOBALS"}["nllzyi"]}, "topPos" => ${${"GLOBALS"}["evjbhbu"]}, "leftPos" => ${${"GLOBALS"}["yusnccfblm"]}));
 }
 function process(Vtiger_Request $request)
 {
     $baseModuleName = $request->get('base_module');
     $db = PearDatabase::getInstance();
     $parentTplId = $request->get('parent_tpl_id');
     if (!$parentTplId) {
         $parentTplId = 0;
     }
     $settingsModuleModel = Settings_Vtiger_Module_Model::getInstance('Settings:OSSProjectTemplates');
     $fieldTab = $settingsModuleModel->getConfigurationForModule($baseModuleName);
     $fieldTab['tpl_name'] = '';
     $lastTplId = $this->getLastTplId($baseModuleName);
     $lastTplId++;
     if ($fieldTab && count($fieldTab)) {
         foreach ($fieldTab as $key => $value) {
             $valField = $request->get($key);
             $sql = "INSERT INTO vtiger_oss_project_templates VALUES(?, ?, ?, ?, ?, ?)";
             if (is_array($valField)) {
                 $db->pquery($sql, array(NULL, $key, json_encode($valField), $lastTplId, $parentTplId, $baseModuleName), true);
             } else {
                 $db->pquery($sql, array(NULL, $key, $valField, $lastTplId, $parentTplId, $baseModuleName), true);
             }
             $dateDayInterval = $request->get($key . '_day');
             $dateDayIntervalType = $request->get($key . '_day_type');
             if ($dateDayInterval) {
                 $sql = "INSERT INTO vtiger_oss_project_templates VALUES(NULL, '{$key}_day', '{$dateDayInterval}', {$lastTplId}, {$parentTplId}, '{$baseModuleName}')";
                 $db->query($sql, true);
             }
             if ($dateDayIntervalType) {
                 $sql = "INSERT INTO vtiger_oss_project_templates VALUES(NULL, '{$key}_day_type', '{$dateDayIntervalType}', {$lastTplId}, {$parentTplId}, '{$baseModuleName}')";
                 $db->query($sql, true);
             }
         }
     }
     $backView = $request->get('back_view');
     $backIdTpl = $request->get('parent_tpl_id');
     header("Location: index.php?module=OSSProjectTemplates&parent=Settings&view=" . $backView . '&tpl_id=' . $backIdTpl);
 }