public function beforeGetTaskform($viewer) { global $adb; if (!\Workflow\VtUtils::existTable("vtiger_wf_customnumbering")) { echo "Create table vtiger_wf_confirmation_user ... ok<br>"; $adb->query("CREATE TABLE IF NOT EXISTS `vtiger_wf_customnumbering` (\r\n `serie` varchar(24) NOT NULL,\r\n `prefix` varchar(16) NOT NULL,\r\n `current` int(10) unsigned NOT NULL,\r\n `length` tinyint(4) NOT NULL,\r\n PRIMARY KEY (`serie`)\r\n ) ENGINE=InnoDB;"); } $crmidColObj = CRMEntity::getInstance($this->getModuleName()); $viewer->assign('crmidCol', $crmidColObj->table_index); $moduleName = $this->getModuleName(); $fields = VtUtils::getFieldsWithBlocksForModule($moduleName, false); $selectedId = $this->get('field'); if ($selectedId === -1 || empty($selectedId)) { $sql = 'SELECT * FROM vtiger_field WHERE uitype = 4 AND tabid = ' . getTabid($moduleName); $result = $adb->query($sql); $selectedId = $adb->query_result($result, 0, 'fieldname'); $this->set('field', $selectedId); } $sql = 'SELECT * FROM vtiger_wf_customnumbering'; $result = $adb->query($sql); $series = array(); while ($row = $adb->fetchByAssoc($result)) { $series[$row['serie']] = $row; } if (isset($series[$this->get('serie')])) { $viewer->assign('lockFields', true); } $viewer->assign('series', $series); $viewer->assign('fields', $fields); /* Insert here source code to create custom configurations pages */ }
public function process(Vtiger_Request $request) { ${"GLOBALS"}["xtbxpaosomd"] = "module"; ${"GLOBALS"}["cqsbdcf"] = "params"; $ylhwigwjj = "adb"; ${$ylhwigwjj} = PearDatabase::getInstance(); $irlzrbtqca = "params"; ${$irlzrbtqca} = $request->getAll(); ${"GLOBALS"}["bjpfpvsjmoe"] = "block"; ${${"GLOBALS"}["vlwbcehp"]} = ${${"GLOBALS"}["fvrxafpqr"]}["moduleName"]; ${"GLOBALS"}["slnjoremiwq"] = "result"; ${${"GLOBALS"}["imkzic"]} = VtUtils::getFieldsWithBlocksForModule(${${"GLOBALS"}["xtbxpaosomd"]}, true); if (!empty(${${"GLOBALS"}["cqsbdcf"]}["blocks"])) { ${"GLOBALS"}["tdxbgjlxl"] = "moduleFields"; die(json_encode(${${"GLOBALS"}["tdxbgjlxl"]})); } ${${"GLOBALS"}["quwfbet"]} = array(); foreach (${${"GLOBALS"}["imkzic"]} as ${${"GLOBALS"}["jutloijjy"]} => ${${"GLOBALS"}["bjpfpvsjmoe"]}) { foreach (${${"GLOBALS"}["swvrrtqrvf"]} as ${${"GLOBALS"}["fxiwohqzyqth"]}) { $qusdhjlspiv = "result"; ${$qusdhjlspiv}[] = array("type" => $field->type, "group" => ${${"GLOBALS"}["jutloijjy"]}, "name" => $field->name, "label" => $field->label); } } die(json_encode(${${"GLOBALS"}["slnjoremiwq"]})); }
public function process(Vtiger_Request $request) { global $current_user; global $root_directory; $baflayps = "adb"; ${"GLOBALS"}["luuhjzd"] = "result"; $hnrergoqncb = "workflowID"; ${"GLOBALS"}["swtsotcec"] = "qualifiedModuleName"; ${$baflayps} = PearDatabase::getInstance(); ${"GLOBALS"}["qpgwks"] = "sql"; ${${"GLOBALS"}["hxnhbexxth"]} = $request->getModule(); $hrnudh = "sql"; ${"GLOBALS"}["dgvcsdbd"] = "viewer"; ${${"GLOBALS"}["swtsotcec"]} = $request->getModule(false); $ylrvxdxw = "errors"; ${${"GLOBALS"}["dgvcsdbd"]} = $this->getViewer(${${"GLOBALS"}["vndwqun"]}); ${$hnrergoqncb} = (int) $request->get("workflow_id"); ${${"GLOBALS"}["qpgwks"]} = "SELECT * FROM vtiger_wf_errorlog WHERE workflow_id = " . ${${"GLOBALS"}["iixbxxmrvuvd"]}; ${${"GLOBALS"}["ftihtoot"]} = $adb->query(${$hrnudh}); $viewer->assign("workflow_id", ${${"GLOBALS"}["iixbxxmrvuvd"]}); ${${"GLOBALS"}["twlpnmw"]} = array(); while (${${"GLOBALS"}["poxjutxofp"]} = $adb->fetchByAssoc(${${"GLOBALS"}["luuhjzd"]})) { $neerouqdsox = "row"; ${"GLOBALS"}["cnptdybl"] = "row"; ${${"GLOBALS"}["cnptdybl"]}["datum_eintrag"] = VtUtils::formatUserDate(${${"GLOBALS"}["poxjutxofp"]}["datum_eintrag"]); ${${"GLOBALS"}["twlpnmw"]}[] = ${$neerouqdsox}; } $viewer->assign("errors", ${$ylrvxdxw}); echo $viewer->view("ErrorLog.tpl", ${${"GLOBALS"}["glixorebwvtb"]}, true); }
public function process(Vtiger_Request $request) { ${"GLOBALS"}["zuvbgco"] = "url"; ${${"GLOBALS"}["nvqrslc"]} = PearDatabase::getInstance(); ${${"GLOBALS"}["ivimgqkchpe"]} = new Vtiger_Response(); ${${"GLOBALS"}["zuvbgco"]} = $request->get("url"); try { if (!filter_var(${${"GLOBALS"}["vwlgxcvjvn"]}, FILTER_VALIDATE_URL)) { throw new Exception("URL is not valid"); } ${"GLOBALS"}["rwirxck"] = "needLicense"; $eneasgio = "content"; ${$eneasgio} = VtUtils::getContentFromUrl(${${"GLOBALS"}["vwlgxcvjvn"]}); try { ${"GLOBALS"}["bykxupaxtecx"] = "root"; ${${"GLOBALS"}["bykxupaxtecx"]} = new SimpleXMLElement(${${"GLOBALS"}["jpkdykvrxcnm"]}); } catch (Exception $exp) { throw new Exception("no task repository"); } if (empty($root->title)) { throw new Exception("no task repository (title missing)"); } ${${"GLOBALS"}["jjgsblrkloz"]} = (string) $root->needLicense == "1"; $response->setResult(array("success" => true, "title" => (string) $root->title, "license" => ${${"GLOBALS"}["rwirxck"]})); } catch (Exception $exp) { $response->setResult(array("success" => false, "error" => $exp->getMessage())); } $response->emit(); }
protected function setUp() { global $adb, $phpUnitLeadId; ${"GLOBALS"}["vqinqhvudy"] = "sql"; ${"GLOBALS"}["omirinrsle"] = "sql"; ${${"GLOBALS"}["omirinrsle"]} = "SELECT leadid FROM\n vtiger_leaddetails\n LEFT JOIN vtiger_crmentity ON(vtiger_crmentity.crmid = vtiger_leaddetails.leadid)\n WHERE firstname = 'PHPUNIT' AND lastname = 'PHPUNIT' AND deleted = 0"; ${${"GLOBALS"}["dlfzmzsoafs"]} = $adb->query(${${"GLOBALS"}["vqinqhvudy"]}); if ($adb->num_rows(${${"GLOBALS"}["dlfzmzsoafs"]}) > 0) { $pcbcvlo = "result"; ${${"GLOBALS"}["odcnybklnoz"]} = $adb->query_result(${$pcbcvlo}, 0, "leadid"); } else { $zgdgywgjnie = "document"; ${"GLOBALS"}["fbjylokbk"] = "result"; ${$zgdgywgjnie} = CRMEntity::getInstance("Leads"); $document->column_fields["firstname"] = "PHPUNIT"; $document->column_fields["lastname"] = "PHPUNIT"; $qxhkyg = "sql"; $document->column_fields["annualrevenue"] = "1000"; $document->column_fields["cf_654"] = 1; $document->column_fields["assigned_user_id"] = 1; $elbiflyj = "sql"; $document->save("Leads"); ${$elbiflyj} = "SELECT leadid FROM\n vtiger_leaddetails\n LEFT JOIN vtiger_crmentity ON(vtiger_crmentity.crmid = vtiger_leaddetails.leadid)\n WHERE firstname = 'PHPUNIT' AND lastname = 'PHPUNIT' AND deleted = 0"; $adb->query(${$qxhkyg}); ${${"GLOBALS"}["odcnybklnoz"]} = $adb->query_result(${${"GLOBALS"}["fbjylokbk"]}, 0, "leadid"); } VTEntity::setUser(VtUtils::getAdminUser()); print "\nMySuite::setUp()"; }
public function process(Vtiger_Request $request) { ${"GLOBALS"}["joshjxnqy"] = "qualifiedModuleName"; ${"GLOBALS"}["clhmonsj"] = "viewer"; ${"GLOBALS"}["mvqzwlvp"] = "request"; ${${"GLOBALS"}["clhmonsj"]} = $this->getViewer(${${"GLOBALS"}["mvqzwlvp"]}); $tgmmmle = "qualifiedModuleName"; ${${"GLOBALS"}["joshjxnqy"]} = $request->getModule(false); ${${"GLOBALS"}["wdvnidxoyj"]} = VtUtils::getEntityModules(true); $viewer->assign("modules", ${${"GLOBALS"}["wdvnidxoyj"]}); $viewer->view("WorkflowImporter.tpl", ${$tgmmmle}); }
public function beforeGetTaskform($viewer) { global $current_language, $mod_strings; $viewer->assign("related_modules", VtUtils::getRelatedModules($this->getModuleName())); $related_module = $this->get("related_module"); if (!empty($_POST["task"]["related_module"])) { $parts = explode("#~#", $_POST["task"]["related_module"]); } elseif (!empty($related_module)) { if ($related_module != -1) { $parts = explode("#~#", $related_module); } } else { return; } if (!empty($parts)) { $viewer->assign("related_tabid", $parts[1]); } }
public function handleTask(&$context) { $values = $this->get("cols"); $query = array(); $objTemplate = new VTTemplate($context); foreach ($values["key"] as $index => $value) { $keyValue = $objTemplate->render($values["value"][$index]); $query[$value] = $keyValue; } $url = $this->get('url', $context); $method = $this->get('method'); switch ($method) { case 'POST': case 'GET': $content = \VtUtils::getContentFromUrl($url, $query, $method); break; } // var_dump($method, $url, $query); // var_dump($content); return "yes"; }
public function process(Vtiger_Request $request) { $dhllnm = "response"; ${"GLOBALS"}["ftkqxwswkko"] = "request"; ${"GLOBALS"}["umllvjth"] = "viewer"; ${${"GLOBALS"}["epurlbl"]} = PearDatabase::getInstance(); ${$dhllnm} = new Vtiger_Response(); $tmhsvr = "params"; ${$tmhsvr} = $request->getAll(); ${${"GLOBALS"}["umllvjth"]} = $this->getViewer(${${"GLOBALS"}["ftkqxwswkko"]}); ${${"GLOBALS"}["bonutetjn"]} = base64_decode($request->get("repository_url")); try { $beuqykhkk = "needLicense"; $lhrjrsrv = "url"; if (!filter_var(${$lhrjrsrv}, FILTER_VALIDATE_URL)) { throw new Exception("URL is not valid"); } $oddcoi = "data"; ${${"GLOBALS"}["hgeoufhguo"]} = VtUtils::getContentFromUrl(${${"GLOBALS"}["bonutetjn"]}); try { ${"GLOBALS"}["fqwyxgloq"] = "root"; ${${"GLOBALS"}["fqwyxgloq"]} = new SimpleXMLElement(${${"GLOBALS"}["hgeoufhguo"]}); } catch (Exception $exp) { throw new Exception("no task repository"); } if (empty($root->title)) { throw new Exception("no task repository (title missing)"); } ${$beuqykhkk} = (string) $root->needLicense == "1"; ${${"GLOBALS"}["yqifpoueqak"]} = array("title" => $root->title, "needLicense" => ${${"GLOBALS"}["ixzgwrjb"]}, "url" => ${${"GLOBALS"}["bonutetjn"]}); $viewer->assign("nonce", sha1(vglobal("site_URL") . ${${"GLOBALS"}["bonutetjn"]} . "0s-f,mäp" . ${${"GLOBALS"}["yqifpoueqak"]}["title"])); $viewer->assign("data", ${$oddcoi}); $viewer->view("AddRemoteRepository.tpl", $request->getModule(false)); } catch (Exception $exp) { echo "no valid Repository " . $exp->getMessage(); } }
public function process(Vtiger_Request $request) { ${"GLOBALS"}["aoutkjk"] = "result"; ${${"GLOBALS"}["elflftjwv"]} = PearDatabase::getInstance(); ${"GLOBALS"}["onzttzdkr"] = "sql"; ${${"GLOBALS"}["trmkguttw"]} = new Vtiger_Response(); ${"GLOBALS"}["earprjnjkeq"] = "type_id"; $cjtvetbnqr = "sql"; $ohqfejmo = "result"; ${${"GLOBALS"}["xcbqispjyiv"]} = $request->getAll(); ${${"GLOBALS"}["earprjnjkeq"]} = (int) $request->get("type_id"); ${${"GLOBALS"}["gfuxeseykw"]} = (int) $request->get("skipSignatureCheck"); ${${"GLOBALS"}["onzttzdkr"]} = "SELECT * FROM vtiger_wf_repository_types WHERE id = " . ${${"GLOBALS"}["nacjfyfsjtk"]}; ${${"GLOBALS"}["aoutkjk"]} = $adb->query(${$cjtvetbnqr}); if ($adb->num_rows(${$ohqfejmo}) > 0) { ${"GLOBALS"}["qnoovzk"] = "tmpfname"; ${"GLOBALS"}["kudogfvupgdj"] = "data"; $hzkbuj = "data"; ${"GLOBALS"}["xvphvct"] = "data"; $cftpmf = "data"; ${"GLOBALS"}["wkqqujnorudt"] = "fileDownloadUrl"; ${$hzkbuj} = $adb->fetchByAssoc(${${"GLOBALS"}["brnzuhqxg"]}); ${${"GLOBALS"}["wkqqujnorudt"]} = ${${"GLOBALS"}["kudogfvupgdj"]}["url"]; ${${"GLOBALS"}["rmdeckcfy"]} = VtUtils::getContentFromUrl(html_entity_decode(${${"GLOBALS"}["fwpnyelos"]})); ${"GLOBALS"}["chudqzpgkk"] = "skipSignatureCheck"; ${${"GLOBALS"}["qnoovzk"]} = tempnam(sys_get_temp_dir(), "WFD2"); file_put_contents(${${"GLOBALS"}["btnuwdutiif"]}, ${${"GLOBALS"}["rmdeckcfy"]}); if (!${${"GLOBALS"}["chudqzpgkk"]} && false == \Workflow\Repository::checkSignature(${${"GLOBALS"}["btnuwdutiif"]}, ${${"GLOBALS"}["xvphvct"]}["repos_id"], ${${"GLOBALS"}["otmrpohq"]}["checksum"])) { $jvbshbjxi = "tmpfname"; echo "checksum"; @unlink(${$jvbshbjxi}); return; } \Workflow\Repository::installFile(${${"GLOBALS"}["btnuwdutiif"]}, ${$cftpmf}["version"], ${${"GLOBALS"}["otmrpohq"]}["repos_id"]); @unlink(${${"GLOBALS"}["btnuwdutiif"]}); } }
public function beforeGetTaskform($viewer) { $fields = $this->get('fields'); if (empty($fields) || $fields == -1) { $fields = array(); } $viewer->assign("StaticFieldsField", 'fields'); $viewer->assign("fields", $fields); $viewer->assign("fromFields", $this->getFromFields()); $viewer->assign("related_modules", VtUtils::getEntityModules(true)); $search_module = $this->get("search_module"); if (!empty($_POST["task"]["search_module"])) { $parts = explode("#~#", $_POST["task"]["search_module"]); } elseif (!empty($search_module)) { if ($search_module != -1) { $parts = explode("#~#", $search_module); } } else { return; } if (!empty($parts)) { $viewer->assign("related_tabid", $parts[1]); } }
function content_56948e001f64c($_smarty_tpl) { ?> <div style="text-align:left;position:relative;padding:5px;"> <div id='workflow_layer_executer' style='display:none;width:100%;height:100%;top:0px;left:0px;background-image:url(modules/Workflow2/icons/modal_white.png);font-size:12px;letter-spacing:1px;border:1px solid #777777; position:absolute;text-align:center;'><br><img src='modules/Workflow2/icons/sending.gif'><br><br><strong>Executing Workflow ...</strong><br><a href='#' onclick='jQuery("#workflow_layer_executer").hide();return false;'>Close</a></a></div> <?php if ($_smarty_tpl->tpl_vars['show_listview']->value == true) { ?> <?php if (count($_smarty_tpl->tpl_vars['workflows']->value) > 0) { ?> <?php echo vtranslate('LBL_FORCE_EXECUTION', 'Workflow2'); ?> <select name="workflow2_workflowid" id="workflow2_workflowid" size=7 class="detailedViewTextBox" style="width:100%;"> <!--<option value='0'><<?php ?> ?php echo getTranslatedString("LBL_CHOOSE", "Workflow2"); ?<?php ?> ></option>--> <?php $_smarty_tpl->tpl_vars['workflow'] = new Smarty_Variable(); $_smarty_tpl->tpl_vars['workflow']->_loop = false; $_from = $_smarty_tpl->tpl_vars['workflows']->value; if (!is_array($_from) && !is_object($_from)) { settype($_from, 'array'); } foreach ($_from as $_smarty_tpl->tpl_vars['workflow']->key => $_smarty_tpl->tpl_vars['workflow']->value) { $_smarty_tpl->tpl_vars['workflow']->_loop = true; ?> <option value='<?php echo $_smarty_tpl->tpl_vars['workflow']->value['id']; ?> ' data-withoutrecord="<?php echo $_smarty_tpl->tpl_vars['workflow']->value['withoutrecord']; ?> "><?php echo $_smarty_tpl->tpl_vars['workflow']->value['title']; ?> </option> <?php } ?> </select> <button class="btn btn-success" onclick="runSidebarWorkflow('<?php echo $_smarty_tpl->tpl_vars['crmid']->value; ?> ');"name='runWorkfow' ><?php echo vtranslate('execute', 'Workflow2'); ?> </button> <?php } else { ?> <span style="color:#777;font-style:italic;"><?php echo vtranslate('LBL_NO_WORKFLOWS', 'Workflow2'); ?> </span> <?php } ?> <?php } ?> <?php if ($_smarty_tpl->tpl_vars['isAdmin']->value == true) { ?> <a class="pull-right" href="#" onclick="showEntityData('<?php echo $_smarty_tpl->tpl_vars['crmid']->value; ?> ');return false;" name='showEntityData'><?php echo vtranslate('BTN_SHOW_ENTITYDATA', 'Workflow2'); ?> </a> <?php } ?> <div id="startfieldsContainer" style="position:relative;"></div> <?php $_smarty_tpl->tpl_vars['button'] = new Smarty_Variable(); $_smarty_tpl->tpl_vars['button']->_loop = false; $_from = $_smarty_tpl->tpl_vars['buttons']->value; if (!is_array($_from) && !is_object($_from)) { settype($_from, 'array'); } foreach ($_from as $_smarty_tpl->tpl_vars['button']->key => $_smarty_tpl->tpl_vars['button']->value) { $_smarty_tpl->tpl_vars['button']->_loop = true; ?> <button type="button" data-crmid="<?php echo $_smarty_tpl->tpl_vars['crmid']->value; ?> " class="btn" onclick="var workflow = new Workflow();workflow.execute(<?php echo $_smarty_tpl->tpl_vars['button']->value['workflow_id']; ?> , <?php echo $_smarty_tpl->tpl_vars['crmid']->value; ?> );" alt="execute this workflow" title="execute this workflow" style="text-shadow:none;color:<?php echo $_smarty_tpl->tpl_vars['button']->value['textcolor']; ?> ; background-color: <?php echo $_smarty_tpl->tpl_vars['button']->value['color']; ?> ;margin-top:2px;width:100%;"><?php echo $_smarty_tpl->tpl_vars['button']->value['label']; ?> </button><br/> <?php } ?> <?php if (count($_smarty_tpl->tpl_vars['waiting']->value) > 0) { ?> <p><strong><?php echo vtranslate("running Workflows with this record", "Workflow2"); ?> :</strong></p> <table width='238' cellspacing=0 style="font-size:10px;"> <?php $_smarty_tpl->tpl_vars['workflow'] = new Smarty_Variable(); $_smarty_tpl->tpl_vars['workflow']->_loop = false; $_from = $_smarty_tpl->tpl_vars['waiting']->value; if (!is_array($_from) && !is_object($_from)) { settype($_from, 'array'); } foreach ($_from as $_smarty_tpl->tpl_vars['workflow']->key => $_smarty_tpl->tpl_vars['workflow']->value) { $_smarty_tpl->tpl_vars['workflow']->_loop = true; ?> <tr> <?php if ($_smarty_tpl->tpl_vars['isAdmin']->value == true) { ?> <td style='border-top:1px solid #ccc;' colspan=2><a href='index.php?module=Workflow2&view=Config&parent=Settings&workflow=<?php echo $_smarty_tpl->tpl_vars['workflow']->value['workflow_id']; ?> '><?php echo $_smarty_tpl->tpl_vars['workflow']->value['title']; ?> </a></td> <?php } else { ?> <td style='border-top:1px solid #ccc;' colspan=2><?php echo $_smarty_tpl->tpl_vars['workflow']->value['title']; ?> </td> <?php } ?> </tr> <tr> <td colspan=2><strong><?php echo $_smarty_tpl->tpl_vars['workflow']->value['text']; ?> </strong></td> </tr> <tr> <td style='border-bottom:1px solid #ccc;'> <a href='#' onclick='return stopWorkflow("<?php echo $_smarty_tpl->tpl_vars['workflow']->value['execid']; ?> ","<?php echo $_smarty_tpl->tpl_vars['workflow']->value['crmid']; ?> ","<?php echo $_smarty_tpl->tpl_vars['workflow']->value['block_id']; ?> ");return false;'>del</a> | <a href='#' onclick='return continueWorkflow("<?php echo $_smarty_tpl->tpl_vars['workflow']->value['execid']; ?> ","<?php echo $_smarty_tpl->tpl_vars['workflow']->value['crmid']; ?> ","<?php echo $_smarty_tpl->tpl_vars['workflow']->value['block_id']; ?> ");return false;'>continue</a> </td> <td style='text-align:right;border-bottom:1px solid #ccc;'><?php echo DateTimeField::convertToUserFormat(VtUtils::convertToUserTZ($_smarty_tpl->tpl_vars['workflow']->value['nextsteptime'])); ?> </td> </tr> <?php } ?> </table> <?php } ?> </div> <script type="text/javascript">var WorkflowRecordMessages = <?php echo json_encode($_smarty_tpl->tpl_vars['messages']->value); ?> ; var WFUserIsAdmin = <?php if ($_smarty_tpl->tpl_vars['isAdmin']->value == true) { ?> true<?php } else { ?> false<?php } ?> ;</script> <script type="text/javascript">jQuery(window).trigger('workflow.detail.sidebar.ready');</script> <?php }
public static function getFieldsForModule($module_name, $references = false) { ${"GLOBALS"}["oukrqe"] = "references"; return VtUtils::getFieldsWithBlocksForModule(${${"GLOBALS"}["nlmyndvn"]}, ${${"GLOBALS"}["oukrqe"]}); }
${"GLOBALS"}["lyiupor"] = "errors"; ${"GLOBALS"}["hgxcxmxrb"] = "theme"; ${"GLOBALS"}["zanpkuubb"] = "current_language"; ${"GLOBALS"}["vrepvdlfosem"] = "app_strings"; ${"GLOBALS"}["lvfvlsd"] = "result"; $jyqetpzizi = "smarty"; ${"GLOBALS"}["zjdmtrdi"] = "workflowID"; $tlmeurdvn = "row"; ${"GLOBALS"}["kcsrqqgkgw"] = "sql"; ${"GLOBALS"}["nymnjtnulvk"] = "workflowID"; ${"GLOBALS"}["dbvilhykkv"] = "sql"; require_once "autoload_wf.php"; ${${"GLOBALS"}["nymnjtnulvk"]} = intval($_GET["workflow_id"]); ${${"GLOBALS"}["kcsrqqgkgw"]} = "SELECT * FROM vtiger_wf_errorlog WHERE workflow_id = " . ${${"GLOBALS"}["zjdmtrdi"]}; ${${"GLOBALS"}["lvfvlsd"]} = $adb->query(${${"GLOBALS"}["dbvilhykkv"]}); require_once "Smarty_setup.php"; ${$jyqetpzizi} = new vtigerCRM_Smarty(); $smarty->assign("APP", ${${"GLOBALS"}["vrepvdlfosem"]}); $smarty->assign("MOD", return_module_language(${${"GLOBALS"}["zanpkuubb"]}, "Workflow2")); $smarty->assign("THEME", ${${"GLOBALS"}["hgxcxmxrb"]}); ${"GLOBALS"}["boknedqy"] = "workflowID"; $smarty->assign("IMAGE_PATH", "themes/{$theme}/images/"); $smarty->assign("workflow_id", ${${"GLOBALS"}["boknedqy"]}); ${${"GLOBALS"}["lyiupor"]} = array(); while (${$tlmeurdvn} = $adb->fetchByAssoc(${${"GLOBALS"}["lvfvlsd"]})) { $gvelerrodep = "row"; ${${"GLOBALS"}["egkhjjkd"]}["datum_eintrag"] = VtUtils::formatUserDate(${$gvelerrodep}["datum_eintrag"]); ${${"GLOBALS"}["lyiupor"]}[] = ${${"GLOBALS"}["egkhjjkd"]}; } $smarty->assign("errors", ${${"GLOBALS"}["lyiupor"]}); $smarty->display(vtlib_getModuleTemplate("Workflow2", "ErrorLog.tpl"));
public function beforeGetTaskform($viewer) { global $adb, $current_language, $mod_strings; $viewer->assign("related_modules", VtUtils::getEntityModules(true)); $search_module = $this->get("search_module"); if (!empty($_POST["task"]["search_module"])) { $parts = explode("#~#", $_POST["task"]["search_module"]); } elseif (!empty($search_module)) { if ($search_module != -1) { $parts = explode("#~#", $search_module); } } else { return; } if (!empty($parts)) { $viewer->assign("search_module", $parts[0]); $viewer->assign("related_tabid", $parts[1]); $search_module_name = VtUtils::getModuleName($parts[1]); #$workflowSettings = $this->getWorkflow()->getSettings(); $fields = VtUtils::getFieldsWithBlocksForModule($search_module_name); $viewer->assign("sort_fields", $fields); } }
private function _checkField($check) { $hokekyg = "check"; $irkmjqniy = "check"; $vuomcowj = "check"; $qxtftfelfc = "checkvalue"; global $adb; if (${$vuomcowj}["mode"] == "value" || empty(${$hokekyg}["mode"])) { $ljuuqqmpe = "checkvalue"; $qlncurmce = "check"; ${"GLOBALS"}["sjpunfxie"] = "checkvalue"; ${$ljuuqqmpe} = ${$qlncurmce}["rawvalue"]; if (strpos(${${"GLOBALS"}["mhtrtpoxqog"]}, "\$") !== false || strpos(${${"GLOBALS"}["sjpunfxie"]}, "?") !== false) { $kasuqypyri = "objTemplate"; ${$kasuqypyri} = new VTTemplate($this->_context); ${${"GLOBALS"}["mhtrtpoxqog"]} = $objTemplate->render(${${"GLOBALS"}["mhtrtpoxqog"]}); } } elseif (${$irkmjqniy}["mode"] == "function") { $mslifxq = "parser"; ${$mslifxq} = new ExpressionParser(${${"GLOBALS"}["eikcioit"]}["rawvalue"], $this->_context, false); try { $parser->run(); } catch (ExpressionException $exp) { \Workflow2::error_handler(E_EXPRESSION_ERROR, $exp->getMessage(), "", ""); } ${${"GLOBALS"}["mhtrtpoxqog"]} = $parser->getReturn(); } if (preg_match("/^([0-9]+)x([0-9]+)\$/", ${${"GLOBALS"}["mhtrtpoxqog"]}, ${${"GLOBALS"}["rltbvvdxzi"]})) { ${${"GLOBALS"}["mhtrtpoxqog"]} = ${${"GLOBALS"}["rltbvvdxzi"]}[2]; } $qpbidpqzyuq = "check"; if (${$qpbidpqzyuq}["field"] != "crmid") { $opnieudoijq = "result"; $icdvseqgj = "sql"; $wedbbjpbzg = "check"; ${"GLOBALS"}["ssickqrh"] = "result"; $lguveyud = "referenceUitypes"; ${"GLOBALS"}["fhxqfbe"] = "check"; ${$icdvseqgj} = "SELECT columnname, tablename, uitype FROM vtiger_field WHERE (fieldname = ? OR columnname = ?) AND tabid = " . getTabId($this->_module); ${"GLOBALS"}["ufdgmzwrnd"] = "fieldData"; ${$opnieudoijq} = $adb->pquery(${${"GLOBALS"}["gewfwuwzyf"]}, array(${${"GLOBALS"}["fhxqfbe"]}["field"], ${$wedbbjpbzg}["field"]), true); $vnwwwkurvnc = "fieldData"; ${${"GLOBALS"}["ufdgmzwrnd"]} = $adb->fetchByAssoc(${${"GLOBALS"}["ssickqrh"]}); if (${$vnwwwkurvnc}["columnname"] == "idlists" && $this->_module == "Emails") { ${${"GLOBALS"}["skdkydufqc"]} = array("vtiger_seactivityrel`.`crmid"); } else { $dknamdhd = "fieldData"; ${${"GLOBALS"}["skdkydufqc"]} = array("" . ${${"GLOBALS"}["chbluaeolj"]}["tablename"] . "`.`" . ${$dknamdhd}["columnname"]); } if (in_array(intval(${${"GLOBALS"}["chbluaeolj"]}["uitype"]), VtUtils::${$lguveyud})) { ${"GLOBALS"}["usovmy"] = "fieldData"; ${"GLOBALS"}["fcynigpd"] = "modules"; ${"GLOBALS"}["mxfotnkuck"] = "modules"; ${${"GLOBALS"}["mxfotnkuck"]} = VtUtils::getModuleForReference(getTabId($this->_module), ${${"GLOBALS"}["eikcioit"]}["field"], ${${"GLOBALS"}["usovmy"]}["uitype"]); if (count(${${"GLOBALS"}["fcynigpd"]}) == 1) { foreach (${${"GLOBALS"}["mkwcgvqozj"]} as ${${"GLOBALS"}["nrfjjlktok"]}) { ${"GLOBALS"}["ynidmvalhyi"] = "tableName"; $cegjqy = "fieldNames"; ${"GLOBALS"}["fjvfyzyeo"] = "tmpFocus"; $npekrqhn = "tableName"; $gbhhegbtpt = "fieldData"; ${"GLOBALS"}["iijrcvdcux"] = "check"; ${${"GLOBALS"}["fjvfyzyeo"]} = \CRMEntity::getInstance(${${"GLOBALS"}["nrfjjlktok"]}); ${$npekrqhn} = "t" . count($this->_joinTables) . "_" . ${${"GLOBALS"}["nrfjjlktok"]} . "_" . ${${"GLOBALS"}["iijrcvdcux"]}["field"] . ""; $this->_joinTables[] = "LEFT JOIN " . $tmpFocus->table_name . " as " . ${${"GLOBALS"}["vudkckyuiho"]} . " ON (`" . ${${"GLOBALS"}["ynidmvalhyi"]} . "`.`" . $tmpFocus->table_index . "` = `" . ${${"GLOBALS"}["skdkydufqc"]}[0] . "`)"; ${${"GLOBALS"}["chbluaeolj"]}["tablename"] = ${${"GLOBALS"}["vudkckyuiho"]}; ${${"GLOBALS"}["chbluaeolj"]}["columnname"] = $tmpFocus->list_link_field; ${$cegjqy}[] = "" . ${${"GLOBALS"}["chbluaeolj"]}["tablename"] . "`.`" . ${$gbhhegbtpt}["columnname"]; } } } } else { $qivvqrqqp = "fieldNames"; ${$qivvqrqqp} = array("vtiger_crmentity`.`crmid"); } $kmvwkdvr = "fieldNames"; $this->log("Check field: " . ${${"GLOBALS"}["eikcioit"]}["field"] . " " . ${${"GLOBALS"}["eikcioit"]}["operation"] . " - " . ${$qxtftfelfc}); if (!empty(${${"GLOBALS"}["eikcioit"]}["not"])) { ${"GLOBALS"}["msavtqzgbd"] = "not"; ${${"GLOBALS"}["msavtqzgbd"]} = true; } else { $plzzuz = "not"; ${$plzzuz} = false; } ${${"GLOBALS"}["dewpeeyj"]} = array(); foreach (${$kmvwkdvr} as ${${"GLOBALS"}["mtsrsml"]}) { ${"GLOBALS"}["pnlaybj"] = "fieldName"; ${"GLOBALS"}["rgeraojxbe"] = "tmpSQL"; $gysrpkkbjro = "not"; ${"GLOBALS"}["xoeshlppye"] = "tmpSQL"; ${"GLOBALS"}["ufiulnugtpse"] = "not"; ${"GLOBALS"}["oihhykbnakpg"] = "tmpSQL"; ${"GLOBALS"}["jhgyja"] = "fieldName"; $ocjyevynyxer = "fieldName"; $ddtsdwnjdi = "tmpSQL"; ${"GLOBALS"}["irkqsiczmnje"] = "fieldName"; ${"GLOBALS"}["xzodapm"] = "not"; $wwqfpoc = "tmpSQL"; $firifzks = "fieldName"; ${"GLOBALS"}["glhofthvju"] = "fieldName"; $djtrtm = "checkvalue"; $fxmphdvibp = "checkvalue"; $ppsxsaud = "check"; ${"GLOBALS"}["ctfovcryrmyx"] = "checkvalue"; switch (${$ppsxsaud}["operation"]) { case "equal": ${${"GLOBALS"}["dewpeeyj"]}[] = "`" . ${$firifzks} . "` " . (${${"GLOBALS"}["gltggtgnj"]} ? "!" : "") . "= " . $adb->quote(${${"GLOBALS"}["ctfovcryrmyx"]}) . ""; break; case "contains": ${${"GLOBALS"}["xoeshlppye"]}[] = "`" . ${${"GLOBALS"}["mtsrsml"]} . "` " . (${${"GLOBALS"}["gltggtgnj"]} ? "NOT " : "") . "LIKE " . $adb->quote("%" . ${${"GLOBALS"}["mhtrtpoxqog"]} . "%") . ""; break; case "starts_with": ${${"GLOBALS"}["dewpeeyj"]}[] = "`" . ${${"GLOBALS"}["pnlaybj"]} . "` " . (${${"GLOBALS"}["xzodapm"]} ? "NOT " : "") . "LIKE " . $adb->quote(${${"GLOBALS"}["mhtrtpoxqog"]} . "%") . ""; break; case "ends_with": ${${"GLOBALS"}["oihhykbnakpg"]}[] = "`" . ${${"GLOBALS"}["mtsrsml"]} . "` " . (${${"GLOBALS"}["gltggtgnj"]} ? "NOT " : "") . "LIKE " . $adb->quote("%" . ${$fxmphdvibp} . "") . ""; break; case "bigger": ${$wwqfpoc}[] = "`" . ${${"GLOBALS"}["irkqsiczmnje"]} . "` " . (${${"GLOBALS"}["gltggtgnj"]} ? "<=" : ">") . " " . $adb->quote("" . ${${"GLOBALS"}["mhtrtpoxqog"]} . "") . ""; break; case "lower": ${${"GLOBALS"}["dewpeeyj"]}[] = "`" . ${$ocjyevynyxer} . "` " . (${${"GLOBALS"}["gltggtgnj"]} ? ">=" : "<") . " " . $adb->quote("" . ${${"GLOBALS"}["mhtrtpoxqog"]} . "") . ""; break; case "is_checked": ${$ddtsdwnjdi}[] = "`" . ${${"GLOBALS"}["jhgyja"]} . "` " . (${${"GLOBALS"}["gltggtgnj"]} ? "!" : "") . "= " . $adb->quote("" . ${$djtrtm} . "") . ""; break; case "is_empty": if (!${$gysrpkkbjro}) { $snfeziwysq = "check"; $xbwkmiws = "fieldName"; ${${"GLOBALS"}["dewpeeyj"]}[] = "(`" . ${$xbwkmiws} . "` = '' OR`" . ${$snfeziwysq}["field"] . "` = '0')"; } else { ${"GLOBALS"}["pldqrvs"] = "fieldName"; ${${"GLOBALS"}["dewpeeyj"]}[] = "(`" . ${${"GLOBALS"}["pldqrvs"]} . "` != '')"; } break; case "date_empty": if (!${${"GLOBALS"}["gltggtgnj"]}) { $qdiribn = "fieldName"; $bbosypyhslk = "tmpSQL"; ${$bbosypyhslk}[] = "(`" . ${${"GLOBALS"}["mtsrsml"]} . "` IS NULL OR DATE(`" . ${$qdiribn} . "`) = '0000-00-00')"; } else { ${"GLOBALS"}["pwcutq"] = "fieldName"; $egvstey = "tmpSQL"; ${$egvstey}[] = "(`" . ${${"GLOBALS"}["pwcutq"]} . "` IS NOT NULL AND DATE(`" . ${${"GLOBALS"}["mtsrsml"]} . "`) != '0000-00-00')"; } break; case "is_numeric": ${${"GLOBALS"}["rgeraojxbe"]}[] = "(`" . ${${"GLOBALS"}["glhofthvju"]} . "` " . (${${"GLOBALS"}["ufiulnugtpse"]} ? "NOT " : "") . "REGEXP '-?[0-9]+')"; break; } } $this->_sql[] = "((" . implode(") OR (", ${${"GLOBALS"}["dewpeeyj"]}) . "))"; return false; }
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") . " (" . 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"]) . " (" . 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 != ''"; ${${"GLOBALS"}["phfqsvze"]} = $adb->query(${${"GLOBALS"}["udwnmshnu"]}); if ($adb->num_rows(${${"GLOBALS"}["phfqsvze"]}) > 0) { ${"GLOBALS"}["ierbsmsl"] = "envVars"; $bczogurxby = "envVars"; ${$bczogurxby} = array(); while (${${"GLOBALS"}["ugsspydv"]} = $adb->fetchByAssoc(${${"GLOBALS"}["phfqsvze"]})) { ${"GLOBALS"}["mmvitgpg"] = "entity"; $lwcsgrt = "ent"; $tvqssse = "entity"; ${$tvqssse} = explode("#~~#", ${${"GLOBALS"}["ugsspydv"]}["env_vars"]); foreach (${${"GLOBALS"}["mmvitgpg"]} as ${$lwcsgrt}) { if (!in_array(${${"GLOBALS"}["pouecxkcfj"]}, ${${"GLOBALS"}["ahvvlbihd"]})) { $bqkhedsred = "ent"; $eqpxcdkmlu = "envVars"; ${$eqpxcdkmlu}[] = ${$bqkhedsred}; } } } echo "<optgroup label=\"" . getTranslatedString("LBL_GET_KNOWN_ENVVARS", "Workflow2") . "\">"; foreach (${${"GLOBALS"}["ierbsmsl"]} as ${${"GLOBALS"}["osymiilgq"]}) { ${"GLOBALS"}["ougrcnsmys"] = "var"; echo "<option value='env" . ${${"GLOBALS"}["osymiilgq"]} . "]'>\$env" . ${${"GLOBALS"}["ougrcnsmys"]} . "]</option>"; } echo "</optgroup>"; } echo "</select>"; echo "</div>"; }
public function beforeGetTaskform($viewer) { global $adb, $vtiger_current_version; $new_module = $this->get("new_module"); if (!empty($_POST["task"]["new_module_setter"])) { $new_module = $_POST["task"]["new_module_setter"]; $allFields = VtUtils::getFieldsForModule($_POST["task"]["new_module_setter"], true); $mandatoryFields = VtUtils::getMandatoryFields(getTabid($_POST["task"]["new_module_setter"])); $startFields = array(); $counter = 1; $fromFields = $this->fieldSetter->getFromFields(); $tmpFields = array(); foreach ($mandatoryFields as $fields) { $tmpFields[$fields['fieldname']] = 1; } $mandatoryFields = $tmpFields; $tmpFields = array(); foreach ($fromFields as $block) { foreach ($block as $field) { $tmpFields[$field->name] = 1; } } foreach ($allFields as $field) { if ($field->name != 'crmid') { if (isset($tmpFields[$field->name])) { $startValue = '$' . $field->name; } else { $startValue = ''; } if ($field->uitype != 4 && $field->uitype != 70 && $field->name != 'modifiedby' && $field->displaytype != 3 && $field->displaytype != 5 && $field->displaytype != 2) { $startFields["" . $counter] = array("field" => $field->name, "mode" => "field", "value" => $startValue, 'fixed' => isset($mandatoryFields[$field->name])); $counter++; } } } if ($_POST["task"]["new_module_setter"] == "Calendar") { $startFields["" . $counter] = array("field" => "time_start", "mode" => "value", "value" => ""); } $this->set("setter", $startFields); $this->set("new_module", $new_module); } $workflows = Workflow2::getWorkflowsForModule($new_module, 1); $viewer->assign("extern_workflows", $workflows); $sql = "SELECT id FROM vtiger_ws_entity WHERE name = 'Users'"; $result = $adb->query($sql); $wsTabId = $adb->query_result($result, 0, "id"); if (!empty($new_module) && $new_module != -1) { $viewer->assign("new_module", $new_module); } $sql = "SELECT * FROM vtiger_tab WHERE presence = 0 AND isentitytype = 1 ORDER BY name"; $result = $adb->query($sql); $module = array(); while ($row = $adb->fetch_array($result)) { if ($row["name"] == "Calendar") { continue; } $module[$row["name"]] = getTranslatedString($row["tablabel"], $row["name"]); } #$module["Events"] = getTranslatedString($row["tablabel"],"Events"); asort($module); $viewer->assign("avail_module", $module); if ($this->_productchooser !== null) { $viewer->assign('productchooser', true); } }
public function beforeGetTaskform($viewer) { global $adb, $current_language, $mod_strings; if (!getTabid('PDFMaker') || !vtlib_isModuleActive('PDFMaker')) { $viewer->assign('disable', true); $this->addConfigHint(getTranslatedString('LBL_FOR_THIS_YOU_NEED_PDFMAKER', 'Settings:Workflow2')); return; } $copies = $this->get('copies'); if ($copies === -1 || empty($copies)) { $this->set('copies', 1); } $viewer->assign("related_modules", VtUtils::getEntityModules(true)); $search_module = $this->get("search_module"); $parts = false; if (!empty($_POST["task"]["search_module"])) { $parts = explode("#~#", $_POST["task"]["search_module"]); } elseif (!empty($search_module)) { if ($search_module != -1) { $parts = explode("#~#", $search_module); $tabid = $parts[1]; } } if (!empty($parts)) { $moduleName = $parts[0]; $tabid = $parts[1]; } else { $moduleName = $this->getModuleName(); $tabid = getTabid($moduleName); } $viewer->assign("related_tabid", $tabid); $fields = VtUtils::getFieldsWithBlocksForModule($moduleName); $viewer->assign("sort_fields", $fields); require_once 'modules/PDFMaker/helpers/Version.php'; $viewer->assign('PDFMAKER_VERSION', PDFMaker_Version_Helper::$version); $sql = "SELECT folderid, foldername FROM vtiger_attachmentsfolder ORDER BY sequence"; $result = $adb->query($sql); $folders = array(); while ($row = $adb->fetch_array($result)) { $folders[] = $row; } $viewer->assign("folders", $folders); $sql = "SELECT templateid, filename, description FROM vtiger_pdfmaker WHERE module = '" . $moduleName . "'"; $result = $adb->query($sql); $templates = array(); while ($row = $adb->fetch_array($result)) { $templates[] = $row; } $viewer->assign("templates", $templates); $workflows = \Workflow2::getWorkflowsForModule("Documents", 1); $viewer->assign("workflows", $workflows); }
public function beforeGetTaskform($viewer) { global $adb, $current_language, $mod_strings; $viewer->assign("related_modules", VtUtils::getEntityModules(true)); $search_module = $this->get("search_module"); if (!empty($_POST["task"]["search_module"])) { $parts = explode("#~#", $_POST["task"]["search_module"]); } elseif (!empty($search_module)) { if ($search_module != -1) { $parts = explode("#~#", $search_module); } } else { return; } if (!empty($parts)) { $viewer->assign("related_tabid", $parts[1]); $search_module_name = VtUtils::getModuleName($parts[1]); #$workflowSettings = $this->getWorkflow()->getSettings(); $workflows = $workflows = Workflow2::getWorkflowsForModule($search_module_name, 1); $viewer->assign("workflows", $workflows); $fields = VtUtils::getFieldsWithBlocksForModule($search_module_name); $viewer->assign("sort_fields", $fields); $moduleObj = \Vtiger_Module_Model::getInstance($search_module_name); $viewer->assign('productCache', array()); if ($moduleObj instanceof \Inventory_Module_Model) { $viewer->assign('searchByProduct', true); $product = $this->get('products'); if (!empty($product)) { //$dataObj = \Vtiger_Record_Model::getInstanceById($product); $productCache[$product] = array('label' => \Vtiger_Functions::getCRMRecordLabel($product)); $viewer->assign('productCache', $productCache); } } $views = array(); $allviews = \CustomView_Record_Model::getAll($search_module_name); foreach ($allviews as $view) { $views[$view->get('cvid')] = $view->get('viewname'); } $viewer->assign('customviews', $views); } }
public function beforeGetTaskform($viewer) { $fields = VtUtils::getFieldsWithBlocksForModule('Emails'); $viewer->assign("sort_fields", $fields); /* Insert here source code to create custom configurations pages */ }
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); }
public function beforeGetTaskform($viewer) { global $adb; $connected = $this->getConnectedObjects("Absender"); if (count($connected) > 0) { $viewer->assign("from", array("from_mail" => $connected[0]->get("email1"), "from_name" => trim($connected[0]->get("first_name") . " " . $connected[0]->get("last_name")), "from_readonly" => true)); } // $smtpServer = \Workflow\ConnectionProvider::getAvailableConfigurations('smtp'); // var_dump($smtpServer);exit(); $connected = $this->getConnectedObjects("BCC"); $bccs = $connected->get("email1"); $viewer->assign("bccs", $bccs); $from_email = $this->get("from_mail"); if ($from_email === -1) { global $current_user; $from_email = $current_user->column_fields["email1"]; $from_name = $current_user->column_fields["first_name"] . " " . $current_user->column_fields["last_name"]; $this->set("from_mail", $from_email); $this->set("from_name", $from_name); } $availableSpecialAttachments = \Workflow\Attachment::getAvailableOptions($this->getModuleName()); $attachmentHTML = array(); $attachmentJAVASCRIPT = array(); foreach ($availableSpecialAttachments as $item) { $attachmentHTML[] = '<div>' . $item['html'] . '</div>'; $attachmentJAVASCRIPT[] = !empty($item['script']) ? $item['script'] : ''; } // implode the array to one string $viewer->assign('attachmentsHTML', implode("\n", $attachmentHTML)); // transmit array to create single script tags $viewer->assign('attachmentsJAVASCRIPT', $attachmentJAVASCRIPT); if (vtlib_isModuleActive('Emails')) { $availableAttachments = \Workflow\InterfaceFiles::getAvailableFiles($this->getModuleName()); } else { throw new \Exception('To use this task, you need to activate the "Emails" module.'); } $jsList = array(); foreach ($availableAttachments as $title => $group) { foreach ($group as $index => $value) { $jsList[$index] = $value; } } $viewer->assign("jsAttachmentsList", $jsList); $viewer->assign("available_attachments", $availableAttachments); if ($this->get("attachments") == -1) { $this->set("attachments", '{}'); } if ($this->get("attachments") == "") { $this->set("attachments", '{}'); } $sql = "SELECT * FROM vtiger_emailtemplates WHERE deleted = 0"; $result = $adb->query($sql); $mailtemplates = array(); while ($row = $adb->fetchByAssoc($result)) { $mailtemplates['Email Templates'][$row["templateid"]] = $row["templatename"]; } if (vtlib_isModuleActive('EMAILMaker') && class_exists('EMAILMaker_Module_Model')) { $emailmaker = new \EMAILMaker_Module_Model(); if (method_exists($emailmaker, 'GetAvailableTemplates')) { $templates = $emailmaker->GetAvailableTemplates($this->getModuleName()); foreach ($templates as $categoryTitle => $category) { if (!is_array($category)) { $mailtemplates['EMAILMaker']['s#emailmaker#' . $categoryTitle] = $category; } else { foreach ($category as $templateid => $template) { $mailtemplates['EMAILMaker ' . $categoryTitle]['s#emailmaker#' . $templateid] = $template; } } } } } $viewer->assign("MAIL_TEMPLATES", $mailtemplates); $viewer->assign("fields", \VtUtils::getFieldsWithBlocksForModule($this->getModuleName(), true)); if (defined("WF_DEMO_MODE") && constant("WF_DEMO_MODE") == true) { echo "<p style='text-align:center;margin:0;padding:5px 0;background-color:#fbcb09;font-weight:bold;'>The sendmail Task won't work on demo.stefanwarnat.de</p>"; } }
public function beforeGetTaskform($viewer) { global $adb, $vtiger_current_version; $new_module = $this->get("new_module"); if (!empty($_POST["task"]["new_module_setter"])) { $new_module = $_POST["task"]["new_module_setter"]; $mandatoryFields = VtUtils::getMandatoryFields(getTabId($_POST["task"]["new_module_setter"])); $startFields = array(); $counter = 1; foreach ($mandatoryFields as $field) { $startFields["" . $counter] = array("field" => $field["fieldname"], "mode" => "value", "value" => "", "fixed" => true); $counter++; } if ($_POST["task"]["new_module_setter"] == "Calendar") { $startFields["" . $counter] = array("field" => "time_start", "mode" => "value", "value" => "", "fixed" => true); } $this->set("setter", $startFields); $this->set("new_module", $new_module); } $workflows = Workflow2::getWorkflowsForModule($new_module, 1); $viewer->assign("extern_workflows", $workflows); $sql = "SELECT id FROM vtiger_ws_entity WHERE name = 'Users'"; $result = $adb->query($sql); $wsTabId = $adb->query_result($result, 0, "id"); if (!empty($new_module) && $new_module != -1) { $viewer->assign("new_module", $new_module); } $sql = "SELECT * FROM vtiger_tab WHERE presence = 0 AND isentitytype = 1 ORDER BY name"; $result = $adb->query($sql); $module = array(); while ($row = $adb->fetch_array($result)) { if ($row["name"] == "Calendar") { continue; } $module[$row["name"]] = getTranslatedString($row["tablabel"], $row["name"]); } #$module["Events"] = getTranslatedString($row["tablabel"],"Events"); asort($module); $viewer->assign("avail_module", $module); }
public function beforeGetTaskform($viewer) { global $adb; $new_module = $this->get("new_module"); if (!empty($_POST["task"]["new_module_setter"])) { $new_module = $_POST["task"]["new_module_setter"]; # $viewer->assign("module_name", $_POST["task"]["new_module_setter"]); $mandatoryFields = VtUtils::getMandatoryFields(getTabId($_POST["task"]["new_module_setter"])); $startFields = array(); $counter = 1; foreach ($mandatoryFields as $field) { if ('productid' != $field['fieldname']) { $startFields["" . $counter] = array("field" => $field["fieldname"], "mode" => "value", "value" => "", "fixed" => true); $counter++; } } $startFields["" . $counter++] = array("field" => "currency_id", "mode" => "value", "value" => "", "fixed" => true); $startFields["" . $counter++] = array("field" => "hdnTaxType", "mode" => "value", "value" => "", "fixed" => true); $startFields["" . $counter++] = array("field" => "hdnS_H_Amount", "mode" => "value", "value" => "", "fixed" => true); $this->set("setter", $startFields); $this->set("global", array()); } if (!empty($new_module) && $new_module != -1) { $field = new StdClass(); $field->name = "hdnS_H_Amount"; $field->label = getTranslatedString("Shipping & Handling Charges", $_POST["task"]["new_module_setter"]); $additionalFields = array($field); $viewer->assign("new_module", $new_module); } $workflows = Workflow2::getWorkflowsForModule($new_module, 1); $viewer->assign("extern_workflows", $workflows); $module = array(); $module["Invoice"] = getTranslatedString("Invoice", "Invoice"); $module["Quotes"] = getTranslatedString("Quotes", "Quotes"); $module["PurchaseOrder"] = getTranslatedString("PurchaseOrder", "PurchaseOrder"); $module["SalesOrder"] = getTranslatedString("SalesOrder", "SalesOrder"); asort($module); $viewer->assign("avail_module", $module); $viewer->assign("orig_module_name", $this->getModuleName()); $viewer->assign("availCurrency", getAllCurrencies()); $viewer->assign("availTaxes", getAllTaxes("available")); }
public function beforeGetTaskform($viewer) { $fields = $this->get('fields'); if (empty($fields) || $fields == -1) { $fields = array(); } $viewer->assign("StaticFieldsField", 'fields'); $viewer->assign("fields", $fields); $viewer->assign("fromFields", $this->getFromFields()); $viewer->assign("related_modules", VtUtils::getEntityModules(true)); $search_module = $this->get("search_module"); if (!empty($_POST["task"]["search_module"])) { $parts = explode("#~#", $_POST["task"]["search_module"]); } elseif (!empty($search_module)) { if ($search_module != -1) { $parts = explode("#~#", $search_module); } } else { return; } $views = array(); $allviews = \CustomView_Record_Model::getAll($parts[0]); foreach ($allviews as $view) { $views[$view->get('cvid')] = $view->get('viewname'); } $viewer->assign('customviews', $views); if (!empty($parts)) { $viewer->assign("related_tabid", $parts[1]); $viewer->assign("target_module_name", $parts[0]); } }
public static function register($url, $licenseCode = '', $name = '', $skipCheck = false, $nonce = '') { ${"GLOBALS"}["wrloeiy"] = "adb"; ${"GLOBALS"}["xsycvc"] = "licenseCode"; $obcwfec = "result"; $hhifiq = "sql"; ${${"GLOBALS"}["wrloeiy"]} = \PearDatabase::getInstance(); ${"GLOBALS"}["jjqrbr"] = "url"; ${${"GLOBALS"}["mzvwcfaulgey"]} = "SELECT * FROM vtiger_wf_repository WHERE url = ?"; ${${"GLOBALS"}["svanukneqv"]} = $adb->pquery(${$hhifiq}, array(${${"GLOBALS"}["ihfsqxoqzzd"]})); ${"GLOBALS"}["lexawjarmo"] = "obj"; if ($adb->num_rows(${$obcwfec}) > 0) { throw new \Exception("repository already added"); } ${${"GLOBALS"}["rytusjqhjk"]} = VtUtils::getContentFromUrl(${${"GLOBALS"}["jjqrbr"]}); var_dump(${${"GLOBALS"}["rytusjqhjk"]}); ${"GLOBALS"}["jxhrzk"] = "skipCheck"; $knwkhlcpnk = "url"; ${"GLOBALS"}["ibiobtifeqzr"] = "repoId"; if (${${"GLOBALS"}["jxhrzk"]} === false) { $snyuqxhjnbm = "nonce"; $xlgweuebatn = "title"; try { ${${"GLOBALS"}["hbvnhhjbposj"]} = new \SimpleXMLElement(${${"GLOBALS"}["rytusjqhjk"]}); } catch (\Exception $exp) { throw new \Exception("no task repository"); } ${"GLOBALS"}["lonyvcjyber"] = "title"; if (empty($root->title)) { throw new \Exception("no task repository (title missing)"); } ${"GLOBALS"}["mgvwtbxtx"] = "url"; ${${"GLOBALS"}["lonyvcjyber"]} = (string) $root->title; if (${$snyuqxhjnbm} !== sha1(vglobal("site_URL") . ${${"GLOBALS"}["mgvwtbxtx"]} . "0s-f,mäp" . ${$xlgweuebatn})) { die("nothing"); } } else { try { ${"GLOBALS"}["mwumnezdyo"] = "content"; $gchifffcthk = "root"; ${$gchifffcthk} = new \SimpleXMLElement(${${"GLOBALS"}["mwumnezdyo"]}); } catch (\Exception $exp) { } if (!empty($name)) { ${${"GLOBALS"}["izuqshsie"]} = ${${"GLOBALS"}["wkeuqjj"]}; } else { $ugbdguv = "title"; ${$ugbdguv} = (string) $root->title; } } ${${"GLOBALS"}["mzvwcfaulgey"]} = "INSERT INTO vtiger_wf_repository SET title = ?, url = ?, licenseCode = ?, status = \"stable\""; $adb->pquery(${${"GLOBALS"}["mzvwcfaulgey"]}, array(${${"GLOBALS"}["izuqshsie"]}, ${$knwkhlcpnk}, md5(${${"GLOBALS"}["xsycvc"]}))); ${${"GLOBALS"}["ibiobtifeqzr"]} = $adb->getLastInsertID(); if (isset(${${"GLOBALS"}["hbvnhhjbposj"]})) { if (isset($root->publicKey)) { ${"GLOBALS"}["mxefcmrpk"] = "root_directory"; $nurznzdldwvd = "root_directory"; global $root_directory; @mkdir(${${"GLOBALS"}["wcvjbnt"]} . "/" . PATH_MODULE . "/publicKeys/"); ${"GLOBALS"}["ubmkys"] = "repoId"; ${${"GLOBALS"}["shogoyor"]} = VtUtils::getContentFromUrl("" . $root->publicKey); echo ${${"GLOBALS"}["mxefcmrpk"]} . "/" . PATH_MODULE . "/publicKeys/repo_" . ${${"GLOBALS"}["ubmkys"]} . ".pem"; file_put_contents(${$nurznzdldwvd} . "/" . PATH_MODULE . "/publicKeys/repo_" . ${${"GLOBALS"}["cfbunwjgym"]} . ".pem", ${${"GLOBALS"}["shogoyor"]}); } } ${${"GLOBALS"}["lexawjarmo"]} = new Repository(${${"GLOBALS"}["cfbunwjgym"]}); $obj->update(); return ${${"GLOBALS"}["cfbunwjgym"]}; }