/** * Get all WebEntry records of a Process * * @param string $processUid Unique id of Process * * return array Return an array with all WebEntry records of a Process */ public function getWebEntries($processUid) { try { $arrayWebEntry = array(); $webEntry = new \ProcessMaker\BusinessModel\WebEntry(); //Get UIDs to exclude $arrayWebEntryUidToExclude = array(); $criteria = new Criteria("workflow"); $criteria->setDistinct(); $criteria->addSelectColumn(WebEntryEventPeer::WEE_WE_UID); $criteria->add(WebEntryEventPeer::PRJ_UID, $processUid, Criteria::EQUAL); $rsCriteria = WebEntryEventPeer::doSelectRS($criteria); $rsCriteria->setFetchmode(ResultSet::FETCHMODE_ASSOC); while ($rsCriteria->next()) { $row = $rsCriteria->getRow(); $arrayWebEntryUidToExclude[] = $row["WEE_WE_UID"]; } //Get data $criteria = new Criteria("workflow"); $criteria->addSelectColumn(WebEntryPeer::WE_UID); $criteria->add(WebEntryPeer::PRO_UID, $processUid, Criteria::EQUAL); $criteria->add(WebEntryPeer::WE_UID, $arrayWebEntryUidToExclude, Criteria::NOT_IN); $rsCriteria = WebEntryPeer::doSelectRS($criteria); $rsCriteria->setFetchmode(ResultSet::FETCHMODE_ASSOC); while ($rsCriteria->next()) { $row = $rsCriteria->getRow(); $arrayWebEntry[] = $webEntry->getWebEntry($row["WE_UID"], true); } //Return return $arrayWebEntry; } catch (Exception $e) { throw $e; } }
/** * Get data of a Web Entry * * @param string $webEntryUid Unique id of Web Entry * @param bool $flagGetRecord Value that set the getting * * return array Return an array with data of a Web Entry */ public function getWebEntry($webEntryUid, $flagGetRecord = false) { try { //Verify data $this->throwExceptionIfNotExistsWebEntry($webEntryUid, $this->arrayFieldNameForException["webEntryUid"]); //Get data //SQL $criteria = $this->getWebEntryCriteria(); $criteria->add(\WebEntryPeer::WE_UID, $webEntryUid, \Criteria::EQUAL); $rsCriteria = \WebEntryPeer::doSelectRS($criteria); $rsCriteria->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $rsCriteria->next(); $row = $rsCriteria->getRow(); //Return return !$flagGetRecord ? $this->getWebEntryDataFromRecord($row) : $row; } catch (\Exception $e) { throw $e; } }
public function getData($processUid) { try { $process = new \Processes(); //Get data $workflowData = (array) $process->getWorkflowData($processUid); $workflowData["process"]["PRO_DYNAFORMS"] = empty($workflowData["process"]["PRO_DYNAFORMS"]) ? "" : serialize($workflowData["process"]["PRO_DYNAFORMS"]); $workflowData["process"] = array($workflowData["process"]); $workflowData["processCategory"] = empty($workflowData["processCategory"]) ? array() : array($workflowData["processCategory"]); //Get files $workflowFile = array(); //Getting DynaForms foreach ($workflowData["dynaforms"] as $dynaform) { $dynFile = PATH_DYNAFORM . $dynaform["DYN_FILENAME"] . ".xml"; $workflowFile["DYNAFORMS"][] = array("filename" => $dynaform["DYN_TITLE"], "filepath" => $dynaform["DYN_FILENAME"] . ".xml", "file_content" => file_get_contents($dynFile)); $htmlFile = PATH_DYNAFORM . $dynaform["DYN_FILENAME"] . ".html"; if (file_exists($htmlFile)) { $workflowFile["DYNAFORMS"][] = array("filename" => $dynaform["DYN_FILENAME"] . ".html", "filepath" => $dynaform["DYN_FILENAME"] . ".html", "file_content" => file_get_contents($htmlFile)); } } //Get public files to exclude $arrayPublicFileToExclude = array("wsClient.php"); //WebEntry $criteria = new \Criteria("workflow"); $criteria->addSelectColumn(\WebEntryPeer::WE_DATA); $criteria->add(\WebEntryPeer::PRO_UID, $processUid, \Criteria::EQUAL); $criteria->add(\WebEntryPeer::WE_METHOD, "WS", \Criteria::EQUAL); $rsCriteria = \WebEntryPeer::doSelectRS($criteria); $rsCriteria->setFetchmode(ResultSet::FETCHMODE_ASSOC); while ($rsCriteria->next()) { $row = $rsCriteria->getRow(); $arrayPublicFileToExclude[] = $row["WE_DATA"]; $arrayPublicFileToExclude[] = preg_replace("/^(.+)\\.php\$/", "\$1Post.php", $row["WE_DATA"]); } //Get templates and public files $workspaceTargetDirs = array("TEMPLATES" => "mailTemplates", "PUBLIC" => "public"); $workspaceDir = PATH_DATA . "sites" . PATH_SEP . SYS_SYS . PATH_SEP; foreach ($workspaceTargetDirs as $target => $workspaceTargetDir) { $templatesDir = $workspaceDir . $workspaceTargetDir . PATH_SEP . $processUid; $templatesFiles = Util\Common::rglob("{$templatesDir}/*", 0, true); foreach ($templatesFiles as $templatesFile) { if (is_dir($templatesFile)) { continue; } $filename = basename($templatesFile); if ($target == "PUBLIC" && in_array($filename, $arrayPublicFileToExclude)) { continue; } $workflowFile[$target][] = array("filename" => $filename, "filepath" => $processUid . PATH_SEP . $filename, "file_content" => file_get_contents($templatesFile)); } } //Return self::log("Getting Workflow data Success!"); return array($workflowData, $workflowFile); } catch (\Exception $e) { self::log("Exception: ", $e->getMessage(), "Trace: ", $e->getTraceAsString()); throw $e; } }
/** * Method to do selects. * * @param Criteria $criteria The Criteria object used to build the SELECT statement. * @param Connection $con * @return array Array of selected Objects * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelect(Criteria $criteria, $con = null) { return WebEntryPeer::populateObjects(WebEntryPeer::doSelectRS($criteria, $con)); }