/** * Get criteria for Trigger * * return object */ public function getTriggerCriteria() { try { $delimiter = \DBAdapter::getStringDelimiter(); $criteria = new \Criteria("workflow"); $criteria->addSelectColumn(\TriggersPeer::TRI_UID); $criteria->addAsColumn("TRI_TITLE", "CT.CON_VALUE"); $criteria->addAsColumn("TRI_DESCRIPTION", "CD.CON_VALUE"); $criteria->addSelectColumn(\TriggersPeer::TRI_TYPE); $criteria->addSelectColumn(\TriggersPeer::TRI_WEBBOT); $criteria->addSelectColumn(\TriggersPeer::TRI_PARAM); $criteria->addAlias("CT", \ContentPeer::TABLE_NAME); $criteria->addAlias("CD", \ContentPeer::TABLE_NAME); $arrayCondition = array(); $arrayCondition[] = array(\TriggersPeer::TRI_UID, "CT.CON_ID", \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_CATEGORY", $delimiter . "TRI_TITLE" . $delimiter, \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_LANG", $delimiter . SYS_LANG . $delimiter, \Criteria::EQUAL); $criteria->addJoinMC($arrayCondition, \Criteria::LEFT_JOIN); $arrayCondition = array(); $arrayCondition[] = array(\TriggersPeer::TRI_UID, "CD.CON_ID", \Criteria::EQUAL); $arrayCondition[] = array("CD.CON_CATEGORY", $delimiter . "TRI_DESCRIPTION" . $delimiter, \Criteria::EQUAL); $arrayCondition[] = array("CD.CON_LANG", $delimiter . SYS_LANG . $delimiter, \Criteria::EQUAL); $criteria->addJoinMC($arrayCondition, \Criteria::LEFT_JOIN); return $criteria; } catch (\Exception $e) { throw $e; } }
public static function getPager($max = 10, $page = 1, $date_req = null, $pass_name = null, $req_name = null, $pass_lname = null, $req_lname = null) { $c = new Criteria(); $c->addJoin(self::PASSENGER_ID, PassengerPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(self::REQUESTER_ID, RequesterPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(PassengerPeer::PERSON_ID, PersonPeer::alias('c1', PersonPeer::ID), Criteria::LEFT_JOIN); $c->addJoin(RequesterPeer::PERSON_ID, PersonPeer::alias('c2', PersonPeer::ID), Criteria::LEFT_JOIN); $c->addAlias('c1', PersonPeer::TABLE_NAME); $c->addAlias('c2', PersonPeer::TABLE_NAME); if ($date_req) { $c->add(self::DATE_REQUESTED, '%' . date('Y-m-d', strtotime($date_req)) . '%', Criteria::LIKE); } if ($pass_name) { $c->add(PersonPeer::alias("c1", PersonPeer::FIRST_NAME), $pass_name . '%', Criteria::LIKE); } if ($req_name) { $c->add(PersonPeer::alias("c2", PersonPeer::FIRST_NAME), $req_name . '%', Criteria::LIKE); } if ($pass_lname) { $c->add(PersonPeer::alias("c1", PersonPeer::LAST_NAME), $pass_lname . '%', Criteria::LIKE); } if ($req_lname) { $c->add(PersonPeer::alias("c2", PersonPeer::LAST_NAME), $req_lname . '%', Criteria::LIKE); } $c->addAscendingOrderByColumn(self::DATE_REQUESTED); $pager = new sfPropelPager('Itinerary', $max); $pager->setCriteria($c); $pager->setPage($page); $pager->init(); return $pager; }
public function __get($name) { switch ($name) { case '_maintenanceNote': if (!isset($this->maintenanceNote)) { $criteria = new Criteria(); $criteria->add(QubitNote::OBJECT_ID, $this->resource->id); $criteria->add(QubitNote::TYPE_ID, QubitTerm::MAINTENANCE_NOTE_ID); if (1 == count($query = QubitNote::get($criteria))) { $this->maintenanceNote = $query[0]; } else { $this->maintenanceNote = new QubitNote(); $this->maintenanceNote->typeId = QubitTerm::MAINTENANCE_NOTE_ID; $this->resource->notes[] = $this->maintenanceNote; } } return $this->maintenanceNote; case 'maintenanceNotes': return $this->_maintenanceNote->content; case 'relatedAuthorityRecord': if (!isset($this->relatedAuthorityRecord)) { $criteria = new Criteria(); $criteria->add(QubitRelation::SUBJECT_ID, $this->resource->id); $criteria->addJoin(QubitRelation::OBJECT_ID, QubitActor::ID); $this->relatedAuthorityRecord = QubitRelation::get($criteria); } return $this->relatedAuthorityRecord; case 'relatedFunction': if (!isset($this->relatedFunction)) { $criteria = new Criteria(); $criteria->add($criteria->getNewCriterion(QubitRelation::OBJECT_ID, $this->resource->id)->addOr($criteria->getNewCriterion(QubitRelation::SUBJECT_ID, $this->resource->id))); $criteria->addAlias('ro', QubitFunction::TABLE_NAME); $criteria->addJoin(QubitRelation::OBJECT_ID, 'ro.id'); $criteria->addAlias('rs', QubitFunction::TABLE_NAME); $criteria->addJoin(QubitRelation::SUBJECT_ID, 'rs.id'); $criteria->addAscendingOrderByColumn(QubitRelation::TYPE_ID); $this->relatedFunction = QubitRelation::get($criteria); } return $this->relatedFunction; case 'relatedResource': if (!isset($this->relatedResource)) { $criteria = new Criteria(); $criteria->add(QubitRelation::SUBJECT_ID, $this->resource->id); $criteria->addJoin(QubitRelation::OBJECT_ID, QubitInformationObject::ID); $this->relatedResource = QubitRelation::get($criteria); } return $this->relatedResource; case 'sourceCulture': return $this->resource->sourceCulture; } }
public function getCriteriaDBSList($sProcessUID) { $sDelimiter = DBAdapter::getStringDelimiter(); $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(DbSourcePeer::DBS_UID); $oCriteria->addSelectColumn(DbSourcePeer::PRO_UID); $oCriteria->addSelectColumn(DbSourcePeer::DBS_TYPE); $oCriteria->addSelectColumn(DbSourcePeer::DBS_SERVER); $oCriteria->addSelectColumn(DbSourcePeer::DBS_DATABASE_NAME); $oCriteria->addSelectColumn(DbSourcePeer::DBS_USERNAME); $oCriteria->addSelectColumn(DbSourcePeer::DBS_PASSWORD); $oCriteria->addSelectColumn(DbSourcePeer::DBS_PORT); $oCriteria->addAsColumn('DBS_DESCRIPTION', 'C.CON_VALUE'); $oCriteria->addAlias('C', 'CONTENT'); $aConditions = array(); $aConditions[] = array(DbSourcePeer::DBS_UID, 'C.CON_ID'); $aConditions[] = array('C.CON_CATEGORY', $sDelimiter . 'DBS_DESCRIPTION' . $sDelimiter); $aConditions[] = array('C.CON_LANG', $sDelimiter . SYS_LANG . $sDelimiter); $oCriteria->addJoinMC($aConditions, Criteria::LEFT_JOIN); $oCriteria->add(DbSourcePeer::PRO_UID, $sProcessUID); return $oCriteria; }
/** * Verify if exists the title of a Department * * @param string $departmentTitle Title * @param string $departmentUidExclude Unique id of Department to exclude * * return bool Return true if exists the title of a Department, false otherwise */ public function existsTitle($departmentTitle, $departmentUidExclude = "") { try { $delimiter = \DBAdapter::getStringDelimiter(); $criteria = new \Criteria("workflow"); $criteria->addSelectColumn(\DepartmentPeer::DEP_UID); $criteria->addAlias("CT", \ContentPeer::TABLE_NAME); $arrayCondition = array(); $arrayCondition[] = array(\DepartmentPeer::DEP_UID, "CT.CON_ID", \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_CATEGORY", $delimiter . "DEPO_TITLE" . $delimiter, \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_LANG", $delimiter . SYS_LANG . $delimiter, \Criteria::EQUAL); $criteria->addJoinMC($arrayCondition, \Criteria::LEFT_JOIN); if ($departmentUidExclude != "") { $criteria->add(\DepartmentPeer::DEP_UID, $departmentUidExclude, \Criteria::NOT_EQUAL); } $criteria->add("CT.CON_VALUE", $departmentTitle, \Criteria::EQUAL); $rsCriteria = \DepartmentPeer::doSelectRS($criteria); return $rsCriteria->next() ? true : false; } catch (\Exception $e) { throw $e; } }
public function getCriteriaDBSList($sProcessUID) { $sDelimiter = DBAdapter::getStringDelimiter(); $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(DbSourcePeer::DBS_UID); $oCriteria->addSelectColumn(DbSourcePeer::PRO_UID); $oCriteria->addSelectColumn(DbSourcePeer::DBS_TYPE); $oCriteria->addAsColumn("DBS_SERVER", "CASE WHEN " . DbSourcePeer::DBS_TYPE . " = 'oracle' AND " . DbSourcePeer::DBS_CONNECTION_TYPE . " = 'TNS' THEN CONCAT('[', " . DbSourcePeer::DBS_TNS . ", ']') ELSE " . DbSourcePeer::DBS_SERVER . " END"); $oCriteria->addAsColumn("DBS_DATABASE_NAME", "CASE WHEN " . DbSourcePeer::DBS_TYPE . " = 'oracle' AND " . DbSourcePeer::DBS_CONNECTION_TYPE . " = 'TNS' THEN CONCAT('[', " . DbSourcePeer::DBS_TNS . ", ']') ELSE " . DbSourcePeer::DBS_DATABASE_NAME . " END"); $oCriteria->addSelectColumn(DbSourcePeer::DBS_USERNAME); $oCriteria->addSelectColumn(DbSourcePeer::DBS_PASSWORD); $oCriteria->addSelectColumn(DbSourcePeer::DBS_PORT); $oCriteria->addAsColumn('DBS_DESCRIPTION', 'C.CON_VALUE'); $oCriteria->addAlias('C', 'CONTENT'); $aConditions = array(); $aConditions[] = array(DbSourcePeer::DBS_UID, 'C.CON_ID'); $aConditions[] = array('C.CON_CATEGORY', $sDelimiter . 'DBS_DESCRIPTION' . $sDelimiter); $aConditions[] = array('C.CON_LANG', $sDelimiter . SYS_LANG . $sDelimiter); $oCriteria->addJoinMC($aConditions, Criteria::LEFT_JOIN); $oCriteria->add(DbSourcePeer::PRO_UID, $sProcessUID); return $oCriteria; }
/** * Get SubProcess in Process * * return object */ public function getSubprocesss($pro_uid, $tas_uid) { try { $pro_uid = $this->validateProUid($pro_uid); $tas_uid = $this->validateTasUid($tas_uid); $oCriteria = new \Criteria('workflow'); $del = \DBAdapter::getStringDelimiter(); $oCriteria->add(SubProcessPeer::PRO_PARENT, $pro_uid); $oCriteria->add(SubProcessPeer::TAS_PARENT, $tas_uid); $oCriteria->addAsColumn('CON_VALUE', 'C1.CON_VALUE', 'CON_TITLE'); $oCriteria->addAlias("C1", 'CONTENT'); $tasTitleConds = array(); $tasTitleConds[] = array(SubProcessPeer::TAS_PARENT, 'C1.CON_ID'); $tasTitleConds[] = array('C1.CON_CATEGORY', $del . 'TAS_TITLE' . $del); $tasTitleConds[] = array('C1.CON_LANG', $del . SYS_LANG . $del); $oCriteria->addJoinMC($tasTitleConds, \Criteria::LEFT_JOIN); $oDataset = SubProcessPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $oDataset->next(); $aRow = $oDataset->getRow(); $aRow = array_change_key_case($aRow, CASE_LOWER); $response['spr_uid'] = $aRow['sp_uid']; $response['spr_pro_parent'] = $aRow['pro_parent']; $response['spr_tas_parent'] = $aRow['tas_parent']; $response['spr_pro'] = $aRow['pro_uid']; $response['spr_tas'] = $aRow['tas_uid']; $response['spr_name'] = $aRow['con_value']; $response['spr_synchronous'] = $aRow['sp_synchronous']; $response['spr_variables_out'] = unserialize($aRow['sp_variables_out']); if ((int) $response['spr_synchronous'] === 1) { $response['spr_variables_in'] = unserialize($aRow['sp_variables_in']); } return $response; } catch (\Exception $e) { throw $e; } }
public function getExtTriggersList($start, $limit, $sProcessUID = '') { $sDelimiter = DBAdapter::getStringDelimiter(); $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(TriggersPeer::TRI_UID); $oCriteria->addSelectColumn(TriggersPeer::PRO_UID); $oCriteria->add(TriggersPeer::PRO_UID, $sProcessUID); $this->tmpCriteria = clone $oCriteria; $oCriteria->addAsColumn('TRI_TITLE', 'C1.CON_VALUE'); $oCriteria->addAsColumn('TRI_DESCRIPTION', 'C2.CON_VALUE'); $oCriteria->addAlias('C1', 'CONTENT'); $oCriteria->addAlias('C2', 'CONTENT'); $aConditions = array(); $aConditions[] = array(TriggersPeer::TRI_UID, 'C1.CON_ID'); $aConditions[] = array('C1.CON_CATEGORY', $sDelimiter . 'TRI_TITLE' . $sDelimiter); $aConditions[] = array('C1.CON_LANG', $sDelimiter . SYS_LANG . $sDelimiter); $oCriteria->addJoinMC($aConditions, Criteria::LEFT_JOIN); $aConditions = array(); $aConditions[] = array(TriggersPeer::TRI_UID, 'C2.CON_ID'); $aConditions[] = array('C2.CON_CATEGORY', $sDelimiter . 'TRI_TITLE' . $sDelimiter); $aConditions[] = array('C2.CON_LANG', $sDelimiter . SYS_LANG . $sDelimiter); $oCriteria->addJoinMC($aConditions, Criteria::LEFT_JOIN); $oCriteria->add(TriggersPeer::PRO_UID, $sProcessUID); $oCriteria->addAscendingOrderByColumn('TRI_TITLE'); if ($start != '') { $oCriteria->setOffset($start); } if ($limit != '') { $oCriteria->setLimit($limit); } $oDataset = TriggersPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset->next(); $triggersArray = ""; $triggersArray[] = array('TRI_UID' => 'char', 'PRO_UID' => 'char', 'TRI_TITLE' => 'char', 'TRI_DESCRIPTION' => 'char'); while ($aRow = $oDataset->getRow()) { if ($aRow['TRI_TITLE'] == null || $aRow['TRI_TITLE'] == "") { // There is no translation for this Trigger name, try to get/regenerate the label $triggerO = new Triggers(); $triggerObj = $triggerO->load($aRow['TRI_UID']); $aRow['TRI_TITLE'] = $triggerObj['TRI_TITLE']; $aRow['TRI_DESCRIPTION'] = $triggerObj['TRI_DESCRIPTION']; } $triggersArray[] = $aRow; $oDataset->next(); } return $triggersArray; }
public function testDoDeleteTableAlias() { $con = Propel::getConnection(); $c = new Criteria(BookPeer::DATABASE_NAME); $c->addAlias('b', BookPeer::TABLE_NAME); $c->add('b.TITLE', 'War And Peace'); BasePeer::doDelete($c, $con); $expectedSQL = "DELETE b FROM `book` AS b WHERE b.TITLE='War And Peace'"; $this->assertEquals($expectedSQL, $con->getLastExecutedQuery(), 'doDelete() accepts a Criteria with a table alias'); }
/** * Get application and delegation data from database * * @param string $AppUID * the application identifier * @return array of records from database */ public function getApplicationDelegationData($AppUID) { $allAppDbData = array(); $c = new Criteria(); $c->addSelectColumn(ApplicationPeer::APP_UID); $c->addSelectColumn(ApplicationPeer::APP_NUMBER); $c->addSelectColumn(ApplicationPeer::APP_STATUS); $c->addSelectColumn(ApplicationPeer::PRO_UID); $c->addSelectColumn(ApplicationPeer::APP_CREATE_DATE); $c->addSelectColumn(ApplicationPeer::APP_FINISH_DATE); $c->addSelectColumn(ApplicationPeer::APP_UPDATE_DATE); $c->addSelectColumn(ApplicationPeer::APP_DATA); $c->addAsColumn('APP_TITLE', 'capp.CON_VALUE'); $c->addAsColumn('PRO_TITLE', 'cpro.CON_VALUE'); $c->addSelectColumn('ad.DEL_INDEX'); $c->addSelectColumn('ad.DEL_PREVIOUS'); $c->addSelectColumn('ad.TAS_UID'); $c->addSelectColumn('ad.USR_UID'); $c->addSelectColumn('ad.DEL_TYPE'); $c->addSelectColumn('ad.DEL_THREAD'); $c->addSelectColumn('ad.DEL_THREAD_STATUS'); $c->addSelectColumn('ad.DEL_PRIORITY'); $c->addSelectColumn('ad.DEL_DELEGATE_DATE'); $c->addSelectColumn('ad.DEL_INIT_DATE'); $c->addSelectColumn('ad.DEL_TASK_DUE_DATE'); $c->addSelectColumn('ad.DEL_FINISH_DATE'); $c->addSelectColumn('ad.DEL_DURATION'); $c->addSelectColumn('ad.DEL_QUEUE_DURATION'); $c->addSelectColumn('ad.DEL_DELAY_DURATION'); $c->addSelectColumn('ad.DEL_STARTED'); $c->addSelectColumn('ad.DEL_FINISHED'); $c->addSelectColumn('ad.DEL_DELAYED'); $c->addSelectColumn('ad.APP_OVERDUE_PERCENTAGE'); $c->addSelectColumn('at.APP_THREAD_INDEX'); $c->addSelectColumn('at.APP_THREAD_PARENT'); $c->addSelectColumn('at.APP_THREAD_STATUS'); $c->addAlias('capp', 'CONTENT'); $c->addAlias('cpro', 'CONTENT'); $c->addAlias('ad', 'APP_DELEGATION'); $c->addAlias('at', 'APP_THREAD'); $aConditions = array(); $aConditions[] = array(ApplicationPeer::APP_UID, 'capp.CON_ID'); $aConditions[] = array('capp.CON_CATEGORY', DBAdapter::getStringDelimiter() . 'APP_TITLE' . DBAdapter::getStringDelimiter()); $aConditions[] = array('capp.CON_LANG', DBAdapter::getStringDelimiter() . 'en' . DBAdapter::getStringDelimiter()); $c->addJoinMC($aConditions, Criteria::LEFT_JOIN); $aConditions = array(); $aConditions[] = array(ApplicationPeer::PRO_UID, 'cpro.CON_ID'); $aConditions[] = array('cpro.CON_CATEGORY', DBAdapter::getStringDelimiter() . 'PRO_TITLE' . DBAdapter::getStringDelimiter()); $aConditions[] = array('cpro.CON_LANG', DBAdapter::getStringDelimiter() . 'en' . DBAdapter::getStringDelimiter()); $c->addJoinMC($aConditions, Criteria::LEFT_JOIN); $c->addJoin(ApplicationPeer::APP_UID, 'ad.APP_UID', Criteria::JOIN); $aConditions = array(); $aConditions[] = array('ad.APP_UID', 'at.APP_UID'); $aConditions[] = array('ad.DEL_THREAD', 'at.APP_THREAD_INDEX'); $c->addJoinMC($aConditions, Criteria::JOIN); $c->add(ApplicationPeer::APP_UID, $AppUID); $rs = ApplicationPeer::doSelectRS($c); $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rs->next(); $row = $rs->getRow(); while (is_array($row)) { $allAppDbData[] = $row; $rs->next(); $row = $rs->getRow(); } return $allAppDbData; }
public function getAppEventsCriteria($sProcessUid = '', $sStatus = '', $EVN_ACTION = '') { try { require_once 'classes/model/Event.php'; $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(AppEventPeer::APP_UID); $oCriteria->addSelectColumn(AppEventPeer::DEL_INDEX); $oCriteria->addSelectColumn(AppEventPeer::EVN_UID); $oCriteria->addSelectColumn(AppEventPeer::APP_EVN_ACTION_DATE); $oCriteria->addSelectColumn(AppEventPeer::APP_EVN_ATTEMPTS); $oCriteria->addSelectColumn(AppEventPeer::APP_EVN_LAST_EXECUTION_DATE); $oCriteria->addSelectColumn(AppEventPeer::APP_EVN_STATUS); $oCriteria->addSelectColumn(EventPeer::PRO_UID); $oCriteria->addSelectColumn(EventPeer::EVN_WHEN_OCCURS); $oCriteria->addSelectColumn(EventPeer::EVN_ACTION); $oCriteria->addAsColumn('EVN_DESCRIPTION', 'C1.CON_VALUE'); $oCriteria->addAsColumn('TAS_TITLE', 'C2.CON_VALUE'); $oCriteria->addAsColumn('APP_TITLE', 'C3.CON_VALUE'); $oCriteria->addAsColumn('PRO_TITLE', 'C4.CON_VALUE'); $oCriteria->addAlias('C1', 'CONTENT'); $oCriteria->addAlias('C2', 'CONTENT'); $oCriteria->addAlias('C3', 'CONTENT'); $oCriteria->addAlias('C4', 'CONTENT'); $oCriteria->addJoin(AppEventPeer::EVN_UID, EventPeer::EVN_UID, Criteria::LEFT_JOIN); $del = DBAdapter::getStringDelimiter(); $aConditions = array(); $aConditions[] = array(EventPeer::EVN_UID, 'C1.CON_ID'); $aConditions[] = array('C1.CON_CATEGORY', $del . 'EVN_DESCRIPTION' . $del); $aConditions[] = array('C1.CON_LANG', $del . SYS_LANG . $del); $oCriteria->addJoinMC($aConditions, Criteria::LEFT_JOIN); $aConditions = array(); $aConditions[] = array(AppEventPeer::APP_UID, AppDelegationPeer::APP_UID); $aConditions[] = array(AppEventPeer::DEL_INDEX, AppDelegationPeer::DEL_INDEX); $oCriteria->addJoinMC($aConditions, Criteria::LEFT_JOIN); $aConditions = array(); $aConditions[] = array(AppDelegationPeer::TAS_UID, 'C2.CON_ID'); $aConditions[] = array('C2.CON_CATEGORY', $del . 'TAS_TITLE' . $del); $aConditions[] = array('C2.CON_LANG', $del . SYS_LANG . $del); $oCriteria->addJoinMC($aConditions, Criteria::LEFT_JOIN); $aConditions = array(); $aConditions[] = array(AppDelegationPeer::APP_UID, 'C3.CON_ID'); $aConditions[] = array('C3.CON_CATEGORY', $del . 'APP_TITLE' . $del); $aConditions[] = array('C3.CON_LANG', $del . SYS_LANG . $del); $oCriteria->addJoinMC($aConditions, Criteria::LEFT_JOIN); $aConditions = array(); $aConditions[] = array(AppDelegationPeer::PRO_UID, 'C4.CON_ID'); $aConditions[] = array('C4.CON_CATEGORY', $del . 'PRO_TITLE' . $del); $aConditions[] = array('C4.CON_LANG', $del . SYS_LANG . $del); $oCriteria->addJoinMC($aConditions, Criteria::LEFT_JOIN); $oCriteria->add(AppEventPeer::EVN_UID, '', Criteria::NOT_EQUAL); if ($sProcessUid != '') { $oCriteria->add(EventPeer::PRO_UID, $sProcessUid); } if ($EVN_ACTION != '') { $oCriteria->add(EventPeer::EVN_ACTION, $EVN_ACTION); } switch ($sStatus) { case '': //Nothing break; case 'PENDING': $oCriteria->add(AppEventPeer::APP_EVN_STATUS, 'OPEN'); break; case 'COMPLETED': $oCriteria->add(AppEventPeer::APP_EVN_STATUS, 'CLOSE'); break; } //$oCriteria->addDescendingOrderByColumn(AppEventPeer::APP_EVN_ACTION_DATE); return $oCriteria; } catch (Exception $oError) { throw $oError; } }
/** * Get criteria for InputDocument * * return object */ public function getInputDocumentCriteria() { try { $delimiter = \DBAdapter::getStringDelimiter(); $criteria = new \Criteria("workflow"); $criteria->addSelectColumn(\InputDocumentPeer::INP_DOC_UID); $criteria->addAsColumn("INP_DOC_TITLE", "CT.CON_VALUE"); $criteria->addAsColumn("INP_DOC_DESCRIPTION", "CD.CON_VALUE"); $criteria->addSelectColumn(\InputDocumentPeer::INP_DOC_FORM_NEEDED); $criteria->addSelectColumn(\InputDocumentPeer::INP_DOC_ORIGINAL); $criteria->addSelectColumn(\InputDocumentPeer::INP_DOC_PUBLISHED); $criteria->addSelectColumn(\InputDocumentPeer::INP_DOC_VERSIONING); $criteria->addSelectColumn(\InputDocumentPeer::INP_DOC_DESTINATION_PATH); $criteria->addSelectColumn(\InputDocumentPeer::INP_DOC_TAGS); $criteria->addSelectColumn(\InputDocumentPeer::INP_DOC_TYPE_FILE); $criteria->addSelectColumn(\InputDocumentPeer::INP_DOC_MAX_FILESIZE); $criteria->addSelectColumn(\InputDocumentPeer::INP_DOC_MAX_FILESIZE_UNIT); $criteria->addAlias("CT", \ContentPeer::TABLE_NAME); $criteria->addAlias("CD", \ContentPeer::TABLE_NAME); $arrayCondition = array(); $arrayCondition[] = array(\InputDocumentPeer::INP_DOC_UID, "CT.CON_ID", \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_CATEGORY", $delimiter . "INP_DOC_TITLE" . $delimiter, \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_LANG", $delimiter . SYS_LANG . $delimiter, \Criteria::EQUAL); $criteria->addJoinMC($arrayCondition, \Criteria::LEFT_JOIN); $arrayCondition = array(); $arrayCondition[] = array(\InputDocumentPeer::INP_DOC_UID, "CD.CON_ID", \Criteria::EQUAL); $arrayCondition[] = array("CD.CON_CATEGORY", $delimiter . "INP_DOC_DESCRIPTION" . $delimiter, \Criteria::EQUAL); $arrayCondition[] = array("CD.CON_LANG", $delimiter . SYS_LANG . $delimiter, \Criteria::EQUAL); $criteria->addJoinMC($arrayCondition, \Criteria::LEFT_JOIN); return $criteria; } catch (\Exception $e) { throw $e; } }
$criteria->addSelectColumn(AppMessagePeer::APP_MSG_UID); $criteria->addSelectColumn(AppMessagePeer::APP_UID); $criteria->addSelectColumn(AppMessagePeer::DEL_INDEX); $criteria->addSelectColumn(AppMessagePeer::APP_MSG_TYPE); $criteria->addSelectColumn(AppMessagePeer::APP_MSG_SUBJECT); $criteria->addSelectColumn(AppMessagePeer::APP_MSG_FROM); $criteria->addSelectColumn(AppMessagePeer::APP_MSG_TO); $criteria->addSelectColumn(AppMessagePeer::APP_MSG_BODY); $criteria->addSelectColumn(AppMessagePeer::APP_MSG_STATUS); $criteria->addSelectColumn(AppMessagePeer::APP_MSG_DATE); $criteria->addSelectColumn(AppMessagePeer::APP_MSG_SEND_DATE); $criteria->addSelectColumn(AppMessagePeer::APP_MSG_SHOW_MESSAGE); $criteria->addSelectColumn(ApplicationPeer::PRO_UID); $criteria->addSelectColumn(ApplicationPeer::APP_NUMBER); $criteria->addAsColumn('PRO_TITLE', 'C2.CON_VALUE'); $criteria->addAlias('C2', 'CONTENT'); if ($emailStatus != '') { $criteria->add(AppMessagePeer::APP_MSG_STATUS, $emailStatus); } if ($proUid != '') { $criteria->add(ApplicationPeer::PRO_UID, $proUid); } if ($dateFrom != "") { if ($dateTo != "") { if ($dateFrom == $dateTo) { $dateSame = $dateFrom; $dateFrom = $dateSame . " 00:00:00"; $dateTo = $dateSame . " 23:59:59"; } else { $dateFrom = $dateFrom . " 00:00:00"; $dateTo = $dateTo . " 23:59:59";
public function getAdvancedSearch($sCase, $sProcess, $sTask, $sCurrentUser, $sSentby, $sLastModFrom, $sLastModTo, $sStatus, $permisse, $userlogged, $aSupervisor) { $sTypeList = ''; $sUIDUserLogged = ''; $c = new Criteria('workflow'); $c->clearSelectColumns(); $c->addSelectColumn(ApplicationPeer::APP_UID); $c->addSelectColumn(ApplicationPeer::APP_NUMBER); $c->addSelectColumn(ApplicationPeer::APP_UPDATE_DATE); $c->addSelectColumn(AppDelegationPeer::DEL_PRIORITY); //$c->addSelectColumn(AppDelegationPeer::DEL_TASK_DUE_DATE); $c->addAsColumn( 'DEL_TASK_DUE_DATE', " IF (" . AppDelegationPeer::DEL_TASK_DUE_DATE . " <= NOW(), CONCAT('<span style=\'color:red\';>', " . AppDelegationPeer::DEL_TASK_DUE_DATE . ", '</span>'), " . AppDelegationPeer::DEL_TASK_DUE_DATE . ") "); $c->addSelectColumn(AppDelegationPeer::DEL_INDEX); $c->addSelectColumn(AppDelegationPeer::TAS_UID); $c->addSelectColumn(AppDelegationPeer::DEL_INIT_DATE); $c->addSelectColumn(AppDelegationPeer::DEL_FINISH_DATE); $c->addSelectColumn(UsersPeer::USR_UID); $c->addAsColumn('APP_CURRENT_USER', "CONCAT(USERS.USR_LASTNAME, ' ', USERS.USR_FIRSTNAME)"); $c->addSelectColumn(ApplicationPeer::APP_STATUS); $c->addAsColumn('APP_TITLE', 'APP_TITLE.CON_VALUE'); $c->addAsColumn('APP_PRO_TITLE', 'PRO_TITLE.CON_VALUE'); $c->addAsColumn('APP_TAS_TITLE', 'TAS_TITLE.CON_VALUE'); //$c->addAsColumn('APP_DEL_PREVIOUS_USER', 'APP_LAST_USER.USR_USERNAME'); $c->addAsColumn( 'APP_DEL_PREVIOUS_USER', "CONCAT(APP_LAST_USER.USR_LASTNAME, ' ', APP_LAST_USER.USR_FIRSTNAME)" ); $c->addAlias("APP_TITLE", 'CONTENT'); $c->addAlias("PRO_TITLE", 'CONTENT'); $c->addAlias("TAS_TITLE", 'CONTENT'); $c->addAlias("APP_PREV_DEL", 'APP_DELEGATION'); $c->addAlias("APP_LAST_USER", 'USERS'); $c->addJoin(ApplicationPeer::APP_UID, AppDelegationPeer::APP_UID, Criteria::LEFT_JOIN); $c->addJoin(AppDelegationPeer::TAS_UID, TaskPeer::TAS_UID, Criteria::LEFT_JOIN); $appThreadConds[] = array(ApplicationPeer::APP_UID, AppThreadPeer::APP_UID); $appThreadConds[] = array(AppDelegationPeer::DEL_INDEX, AppThreadPeer::DEL_INDEX); $c->addJoinMC($appThreadConds, Criteria::LEFT_JOIN); $c->addJoin(AppDelegationPeer::USR_UID, UsersPeer::USR_UID, Criteria::LEFT_JOIN); $del = DBAdapter::getStringDelimiter(); $appTitleConds = array(); $appTitleConds[] = array(ApplicationPeer::APP_UID, 'APP_TITLE.CON_ID'); $appTitleConds[] = array('APP_TITLE.CON_CATEGORY', $del . 'APP_TITLE' . $del); $appTitleConds[] = array('APP_TITLE.CON_LANG', $del . SYS_LANG . $del); $c->addJoinMC($appTitleConds, Criteria::LEFT_JOIN); $proTitleConds = array(); $proTitleConds[] = array(ApplicationPeer::PRO_UID, 'PRO_TITLE.CON_ID'); $proTitleConds[] = array('PRO_TITLE.CON_CATEGORY', $del . 'PRO_TITLE' . $del); $proTitleConds[] = array('PRO_TITLE.CON_LANG', $del . SYS_LANG . $del); $c->addJoinMC($proTitleConds, Criteria::LEFT_JOIN); $tasTitleConds = array(); $tasTitleConds[] = array(AppDelegationPeer::TAS_UID, 'TAS_TITLE.CON_ID'); $tasTitleConds[] = array('TAS_TITLE.CON_CATEGORY', $del . 'TAS_TITLE' . $del); $tasTitleConds[] = array('TAS_TITLE.CON_LANG', $del . SYS_LANG . $del); $c->addJoinMC($tasTitleConds, Criteria::LEFT_JOIN); $prevConds = array(); $prevConds[] = array(ApplicationPeer::APP_UID, 'APP_PREV_DEL.APP_UID'); $prevConds[] = array('APP_PREV_DEL.DEL_INDEX', AppDelegationPeer::DEL_PREVIOUS); $c->addJoinMC($prevConds, Criteria::LEFT_JOIN); $usrConds = array(); $usrConds[] = array('APP_PREV_DEL.USR_UID', 'APP_LAST_USER.USR_UID'); $c->addJoinMC($usrConds, Criteria::LEFT_JOIN); $c->add(TaskPeer::TAS_TYPE, 'SUBPROCESS', Criteria::NOT_EQUAL); $c->add( $c->getNewCriterion(AppThreadPeer::APP_THREAD_STATUS, 'OPEN')-> addOr($c->getNewCriterion(ApplicationPeer::APP_STATUS, 'COMPLETED')-> addAnd($c->getNewCriterion(AppDelegationPeer::DEL_PREVIOUS, 0))) ); if ($sCase != '') { $c->add(ApplicationPeer::APP_NUMBER, $sCase); } if ($sProcess != '') { $c->add(ApplicationPeer::PRO_UID, $sProcess); } if ($sTask != '' && $sTask != "0" && $sTask != 0) { $c->add(AppDelegationPeer::TAS_UID, $sTask); } if ($sCurrentUser != '') { $c->add(ApplicationPeer::APP_CUR_USER, $sCurrentUser); } if ($sSentby != '') { $c->add('APP_PREV_DEL.USR_UID', $sSentby); } if ($sLastModFrom != '0000-00-00' && $sLastModTo != '0000-00-00' && $sLastModFrom != '' && $sLastModTo != '') { $c->add( $c->getNewCriterion(ApplicationPeer::APP_UPDATE_DATE, $sLastModFrom . ' 00:00:00', Criteria::GREATER_EQUAL)-> addAnd($c->getNewCriterion(ApplicationPeer::APP_UPDATE_DATE, $sLastModTo . ' 23:59:59', Criteria::LESS_EQUAL)) ); } if ($sStatus != '') { if ($sStatus != 'gral') { $c->add(ApplicationPeer::APP_STATUS, $sStatus); } } if ($permisse != 0) { $c->add( $c->getNewCriterion(AppDelegationPeer::USR_UID, $userlogged)-> addOr($c->getNewCriterion(AppDelegationPeer::PRO_UID, $aSupervisor, Criteria::IN)) ); } $c->addDescendingOrderByColumn(ApplicationPeer::APP_NUMBER); return $c; }
/** * Get criteria for DynaForm * * return object */ public function getDynaFormCriteria() { try { $delimiter = \DBAdapter::getStringDelimiter(); $criteria = new \Criteria("workflow"); $criteria->addSelectColumn(\DynaformPeer::DYN_UID); $criteria->addAsColumn("DYN_TITLE", "CT.CON_VALUE"); $criteria->addAsColumn("DYN_DESCRIPTION", "CD.CON_VALUE"); $criteria->addSelectColumn(\DynaformPeer::DYN_TYPE); $criteria->addSelectColumn(\DynaformPeer::DYN_CONTENT); $criteria->addSelectColumn(\DynaformPeer::DYN_VERSION); $criteria->addSelectColumn(\DynaformPeer::DYN_UPDATE_DATE); $criteria->addAlias("CT", \ContentPeer::TABLE_NAME); $criteria->addAlias("CD", \ContentPeer::TABLE_NAME); $arrayCondition = array(); $arrayCondition[] = array(\DynaformPeer::DYN_UID, "CT.CON_ID", \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_CATEGORY", $delimiter . "DYN_TITLE" . $delimiter, \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_LANG", $delimiter . SYS_LANG . $delimiter, \Criteria::EQUAL); $criteria->addJoinMC($arrayCondition, \Criteria::LEFT_JOIN); $arrayCondition = array(); $arrayCondition[] = array(\DynaformPeer::DYN_UID, "CD.CON_ID", \Criteria::EQUAL); $arrayCondition[] = array("CD.CON_CATEGORY", $delimiter . "DYN_DESCRIPTION" . $delimiter, \Criteria::EQUAL); $arrayCondition[] = array("CD.CON_LANG", $delimiter . SYS_LANG . $delimiter, \Criteria::EQUAL); $criteria->addJoinMC($arrayCondition, \Criteria::LEFT_JOIN); return $criteria; } catch (\Exception $e) { throw $e; } }
public static function getByMayInterested($airport = null, $min_efficiency = 85) { $c = new Criteria(); $c->add(self::APPT_DATE, null, Criteria::ISNOTNULL); $c->add(self::MISSION_DATE, null, Criteria::ISNOTNULL); $c->add(self::CANCEL_MISSION, 1); $c->add(self::MISSION_DATE, date("Y/m/d", strtotime("now")), Criteria::GREATER_EQUAL); $c->addAnd(self::MISSION_DATE, date("Y/m/d", strtotime("+1 year")), Criteria::LESS_EQUAL); if ($min_efficiency && $airport) { $c->addJoin(self::ID, MissionLegPeer::MISSION_ID, Criteria::INNER_JOIN); $c->addJoin(MissionLegPeer::ID, PilotRequestPeer::LEG_ID, Criteria::LEFT_JOIN); $c->addJoin(MissionPeer::ITINERARY_ID, ItineraryPeer::ID, Criteria::INNER_JOIN); $c->add(MissionLegPeer::MISSION_REPORT_ID, null, Criteria::ISNULL); $c->addAlias('from_air', AirportPeer::TABLE_NAME); $c->addAlias('to_air', AirportPeer::TABLE_NAME); $c->addJoin(MissionLegPeer::FROM_AIRPORT_ID, AirportPeer::alias('from_air', AirportPeer::ID), Criteria::INNER_JOIN); $c->addJoin(MissionLegPeer::TO_AIRPORT_ID, AirportPeer::alias('to_air', AirportPeer::ID), Criteria::INNER_JOIN); $c->addAnd(MissionPeer::ID, "\n CEILING(ROUND(ACOS(SIN(RADIANS(from_air.latitude))\n *SIN(RADIANS(to_air.latitude))+COS(RADIANS(from_air.latitude))\n *COS(RADIANS(to_air.latitude))*COS(RADIANS(from_air.longitude)-RADIANS(to_air.longitude)))\n *((180*60)/PI()))/(ROUND(ACOS(SIN(RADIANS(from_air.latitude))\n *SIN(RADIANS(to_air.latitude))+COS(RADIANS(from_air.latitude))\n *COS(RADIANS(to_air.latitude))\n *\n COS(RADIANS(from_air.longitude)-RADIANS(to_air.longitude))\n ) * ((180*60)/PI())\n )\n +\n ROUND(\n ACOS(\n SIN(RADIANS({$airport->getLatitude()}))\n *\n SIN(RADIANS(to_air.latitude))\n +\n COS(RADIANS({$airport->getLatitude()}))\n *\n COS(RADIANS(to_air.latitude))\n *\n COS(RADIANS({$airport->getLongitude()})-RADIANS(to_air.longitude))\n ) * ((180*60)/PI())\n )\n +\n ROUND(\n ACOS(\n SIN(RADIANS({$airport->getLatitude()}))\n *\n SIN(RADIANS(from_air.latitude))\n +\n COS(RADIANS({$airport->getLatitude()}))\n *\n COS(RADIANS(from_air.latitude))\n *\n COS(RADIANS({$airport->getLongitude()})-RADIANS(from_air.longitude))\n ) * ((180*60)/PI()))) * 200) >= " . $min_efficiency, Criteria::CUSTOM); $c->add(MissionLegPeer::CANCELLED, null, Criteria::ISNULL); } $c->setDistinct(self::ID); $c->addAscendingOrderByColumn(self::MISSION_DATE); $c->setLimit(3); return self::doSelect($c); }
/** * Get criteria for Web Entry * * return object */ public function getWebEntryCriteria() { try { $delimiter = \DBAdapter::getStringDelimiter(); $criteria = new \Criteria("workflow"); $criteria->addSelectColumn(\WebEntryPeer::WE_UID); $criteria->addSelectColumn(\WebEntryPeer::PRO_UID); $criteria->addSelectColumn(\WebEntryPeer::TAS_UID); $criteria->addSelectColumn(\WebEntryPeer::DYN_UID); $criteria->addSelectColumn(\WebEntryPeer::USR_UID); $criteria->addAsColumn("WE_TITLE", "CT.CON_VALUE"); $criteria->addAsColumn("WE_DESCRIPTION", "CD.CON_VALUE"); $criteria->addSelectColumn(\WebEntryPeer::WE_METHOD); $criteria->addSelectColumn(\WebEntryPeer::WE_INPUT_DOCUMENT_ACCESS); $criteria->addSelectColumn(\WebEntryPeer::WE_DATA); $criteria->addSelectColumn(\WebEntryPeer::WE_CREATE_USR_UID); $criteria->addSelectColumn(\WebEntryPeer::WE_UPDATE_USR_UID); $criteria->addSelectColumn(\WebEntryPeer::WE_CREATE_DATE); $criteria->addSelectColumn(\WebEntryPeer::WE_UPDATE_DATE); $criteria->addAlias("CT", \ContentPeer::TABLE_NAME); $criteria->addAlias("CD", \ContentPeer::TABLE_NAME); $arrayCondition = array(); $arrayCondition[] = array(\WebEntryPeer::WE_UID, "CT.CON_ID", \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_CATEGORY", $delimiter . "WE_TITLE" . $delimiter, \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_LANG", $delimiter . SYS_LANG . $delimiter, \Criteria::EQUAL); $criteria->addJoinMC($arrayCondition, \Criteria::LEFT_JOIN); $arrayCondition = array(); $arrayCondition[] = array(\WebEntryPeer::WE_UID, "CD.CON_ID", \Criteria::EQUAL); $arrayCondition[] = array("CD.CON_CATEGORY", $delimiter . "WE_DESCRIPTION" . $delimiter, \Criteria::EQUAL); $arrayCondition[] = array("CD.CON_LANG", $delimiter . SYS_LANG . $delimiter, \Criteria::EQUAL); $criteria->addJoinMC($arrayCondition, \Criteria::LEFT_JOIN); return $criteria; } catch (\Exception $e) { throw $e; } }
/** * Assign a inputdocument supervisor of a process * * @param string $sProcessUID * @param string $sInputDocumentUID * @param int $sPuiPosition * @access public */ public function addProcessSupervisorInputDocument($sProcessUID, $sInputDocumentUID, $sPuiPosition) { $oTypeInputDocument= \InputDocumentPeer::retrieveByPK($sInputDocumentUID); if (is_null( $oTypeInputDocument )) { throw new \Exception(\G::LoadTranslation("ID_DOES NOT_INPUT_DOCUMENT", array($sInputDocumentUID))); } $aResp = array(); $sPuUIDT = array(); $sDelimiter = \DBAdapter::getStringDelimiter(); $oCriteria = new \Criteria('workflow'); $oCriteria->addSelectColumn(\StepSupervisorPeer::STEP_UID); $oCriteria->addAsColumn('INP_DOC_TITLE', 'C.CON_VALUE'); $oCriteria->addAlias('C', 'CONTENT'); $aConditions = array(); $aConditions[] = array(\StepSupervisorPeer::STEP_UID_OBJ, \InputDocumentPeer::INP_DOC_UID); $aConditions[] = array(\StepSupervisorPeer::STEP_TYPE_OBJ, $sDelimiter . 'INPUT_DOCUMENT' . $sDelimiter); $oCriteria->addJoinMC($aConditions, \Criteria::LEFT_JOIN); $aConditions = array(); $aConditions[] = array(\InputDocumentPeer::INP_DOC_UID, 'C.CON_ID'); $aConditions[] = array('C.CON_CATEGORY', $sDelimiter . 'INP_DOC_TITLE' . $sDelimiter); $aConditions[] = array('C.CON_LANG', $sDelimiter . SYS_LANG . $sDelimiter); $oCriteria->addJoinMC($aConditions, \Criteria::LEFT_JOIN); $oCriteria->add(\StepSupervisorPeer::PRO_UID, $sProcessUID); $oCriteria->add(\StepSupervisorPeer::STEP_UID_OBJ, $sInputDocumentUID); $oCriteria->add(\StepSupervisorPeer::STEP_TYPE_OBJ, 'INPUT_DOCUMENT'); $oCriteria->addAscendingOrderByColumn(\StepSupervisorPeer::STEP_POSITION); $oDataset = \StepSupervisorPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $oDataset->next(); while ($aRow = $oDataset->getRow()) { $sPuUIDT = $aRow['STEP_UID']; $oDataset->next(); } if (sizeof($sPuUIDT) == 0) { $oStepSupervisor = new \StepSupervisor(); $oStepSupervisor->create(array('PRO_UID' => $sProcessUID, 'STEP_TYPE_OBJ' => "INPUT_DOCUMENT", 'STEP_UID_OBJ' => $sInputDocumentUID, 'STEP_POSITION' => $oStepSupervisor->getNextPosition($sProcessUID, "INPUT_DOCUMENT"))); $sDelimiter = \DBAdapter::getStringDelimiter(); $oCriteria = new \Criteria('workflow'); $oCriteria->addSelectColumn(\StepSupervisorPeer::STEP_UID); $oCriteria->addSelectColumn(\StepSupervisorPeer::PRO_UID); $oCriteria->addSelectColumn(\StepSupervisorPeer::STEP_TYPE_OBJ); $oCriteria->addSelectColumn(\StepSupervisorPeer::STEP_UID_OBJ); $oCriteria->addSelectColumn(\StepSupervisorPeer::STEP_POSITION); $oCriteria->addAsColumn('INP_DOC_TITLE', 'C.CON_VALUE'); $oCriteria->addAlias('C', 'CONTENT'); $aConditions = array(); $aConditions[] = array(\StepSupervisorPeer::STEP_UID_OBJ, \InputDocumentPeer::INP_DOC_UID); $aConditions[] = array(\StepSupervisorPeer::STEP_TYPE_OBJ, $sDelimiter . 'INPUT_DOCUMENT' . $sDelimiter); $oCriteria->addJoinMC($aConditions, \Criteria::LEFT_JOIN); $aConditions = array(); $aConditions[] = array(\InputDocumentPeer::INP_DOC_UID, 'C.CON_ID'); $aConditions[] = array('C.CON_CATEGORY', $sDelimiter . 'INP_DOC_TITLE' . $sDelimiter); $aConditions[] = array('C.CON_LANG', $sDelimiter . SYS_LANG . $sDelimiter); $oCriteria->addJoinMC($aConditions, \Criteria::LEFT_JOIN); $oCriteria->add(\StepSupervisorPeer::PRO_UID, $sProcessUID); $oCriteria->add(\StepSupervisorPeer::STEP_UID_OBJ, $sInputDocumentUID); $oCriteria->add(\StepSupervisorPeer::STEP_TYPE_OBJ, 'INPUT_DOCUMENT'); $oCriteria->addAscendingOrderByColumn(\StepSupervisorPeer::STEP_POSITION); $oDataset = \StepSupervisorPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $oDataset->next(); while ($aRow = $oDataset->getRow()) { $aResp = array('pui_uid' => $aRow['STEP_UID'], 'pui_position' => $aRow['STEP_POSITION'], 'input_doc_uid' => $aRow['STEP_UID_OBJ']); $oDataset->next(); $aRespPosition = $this->updateProcessSupervisorInputDocument($sProcessUID ,$aRow['STEP_UID'], $sPuiPosition); $aResp = array_merge(array('input_doc_title' => $aRow['INP_DOC_TITLE']), $aRespPosition); } return $aResp; } else { throw new \Exception(\G::LoadTranslation("ID_RELATION_EXIST")); } }
public function getDepartmentsForUser($userUid) { $criteria = new Criteria('workflow'); $criteria->addSelectColumn(UsersPeer::DEP_UID); $criteria->addAsColumn('DEP_TITLE', 'C.CON_VALUE'); $criteria->addAlias('C', 'CONTENT'); $criteria->addJoin(UsersPeer::DEP_UID, DepartmentPeer::DEP_UID, Criteria::LEFT_JOIN); $delimiter = DBAdapter::getStringDelimiter(); $conditions = array(); $conditions[] = array(DepartmentPeer::DEP_UID, 'C.CON_ID'); $conditions[] = array('C.CON_CATEGORY', $delimiter . 'DEPO_TITLE' . $delimiter); $conditions[] = array('C.CON_LANG', $delimiter . SYS_LANG . $delimiter); $criteria->addJoinMC($conditions, Criteria::LEFT_JOIN); $criteria->add(UsersPeer::USR_UID, $userUid); $criteria->add(UsersPeer::DEP_UID, '', Criteria::NOT_EQUAL); $dataset = DepartmentPeer::doSelectRS($criteria); $dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $dataset->next(); $departments = array(); while ($row = $dataset->getRow()) { if (!isset($departments[$row['DEP_UID']])) { $departments[$row['DEP_UID']] = $row; } $dataset->next(); } return $departments; }
/** * @expectedException PropelException */ public function testMergeWithAliasesThrowsException() { $c1 = new Criteria(); $c1->addAlias('b', BookPeer::TABLE_NAME); $c2 = new Criteria(); $c2->addAlias('b', AuthorPeer::TABLE_NAME); $c1->mergeWith($c2); }
/** * Get application and delegation data from database * * @param string $aAppUID * array of application identifiers * @return array of array of records from database */ public function getListApplicationUpdateDelegationData($aaAppUIDs) { $allAppDbData = array(); $c = new Criteria(); $c->addSelectColumn(ApplicationPeer::APP_UID); $c->addSelectColumn(ApplicationPeer::APP_NUMBER); $c->addSelectColumn(ApplicationPeer::APP_STATUS); $c->addSelectColumn(ApplicationPeer::PRO_UID); $c->addSelectColumn(ApplicationPeer::APP_CREATE_DATE); $c->addSelectColumn(ApplicationPeer::APP_FINISH_DATE); $c->addSelectColumn(ApplicationPeer::APP_UPDATE_DATE); $c->addSelectColumn(ApplicationPeer::APP_DATA); $c->addAsColumn('APP_TITLE', 'capp.CON_VALUE'); $c->addAsColumn('PRO_TITLE', 'cpro.CON_VALUE'); $c->addSelectColumn('ad.DEL_INDEX'); $c->addSelectColumn('ad.DEL_PREVIOUS'); $c->addSelectColumn('ad.TAS_UID'); $c->addSelectColumn('ad.USR_UID'); $c->addSelectColumn('ad.DEL_TYPE'); $c->addSelectColumn('ad.DEL_THREAD'); $c->addSelectColumn('ad.DEL_THREAD_STATUS'); $c->addSelectColumn('ad.DEL_PRIORITY'); $c->addSelectColumn('ad.DEL_DELEGATE_DATE'); $c->addSelectColumn('ad.DEL_INIT_DATE'); $c->addSelectColumn('ad.DEL_TASK_DUE_DATE'); $c->addSelectColumn('ad.DEL_FINISH_DATE'); $c->addSelectColumn('ad.DEL_DURATION'); $c->addSelectColumn('ad.DEL_QUEUE_DURATION'); $c->addSelectColumn('ad.DEL_DELAY_DURATION'); $c->addSelectColumn('ad.DEL_STARTED'); $c->addSelectColumn('ad.DEL_FINISHED'); $c->addSelectColumn('ad.DEL_DELAYED'); $c->addSelectColumn('ad.APP_OVERDUE_PERCENTAGE'); $c->addSelectColumn('at.APP_THREAD_INDEX'); $c->addSelectColumn('at.APP_THREAD_PARENT'); $c->addSelectColumn('at.APP_THREAD_STATUS'); $c->addSelectColumn('ade.APP_DELAY_UID'); $c->addSelectColumn('ade.APP_TYPE'); $c->addSelectColumn('ade.APP_DISABLE_ACTION_USER'); $c->addAsColumn("PRO_CATEGORY_UID", "pro.PRO_CATEGORY"); $c->addAlias('capp', 'CONTENT'); $c->addAlias('cpro', 'CONTENT'); $c->addAlias('ad', 'APP_DELEGATION'); $c->addAlias('at', 'APP_THREAD'); $c->addAlias('ade', 'APP_DELAY'); $c->addAlias("pro", ProcessPeer::TABLE_NAME); $aConditions = array(); $aConditions[] = array(ApplicationPeer::APP_UID, 'capp.CON_ID'); $aConditions[] = array('capp.CON_CATEGORY', DBAdapter::getStringDelimiter() . 'APP_TITLE' . DBAdapter::getStringDelimiter()); $aConditions[] = array('capp.CON_LANG', DBAdapter::getStringDelimiter() . 'en' . DBAdapter::getStringDelimiter()); $c->addJoinMC($aConditions, Criteria::LEFT_JOIN); $aConditions = array(); $aConditions[] = array(ApplicationPeer::PRO_UID, 'cpro.CON_ID'); $aConditions[] = array('cpro.CON_CATEGORY', DBAdapter::getStringDelimiter() . 'PRO_TITLE' . DBAdapter::getStringDelimiter()); $aConditions[] = array('cpro.CON_LANG', DBAdapter::getStringDelimiter() . 'en' . DBAdapter::getStringDelimiter()); $c->addJoinMC($aConditions, Criteria::LEFT_JOIN); $c->addJoin(ApplicationPeer::APP_UID, 'ad.APP_UID', Criteria::JOIN); $aConditions = array(); $aConditions[] = array('ad.APP_UID', 'at.APP_UID'); $aConditions[] = array('ad.DEL_THREAD', 'at.APP_THREAD_INDEX'); $c->addJoinMC($aConditions, Criteria::JOIN); $aConditions = array(); $aConditions[] = array('ad.APP_UID', 'ade.APP_UID'); $aConditions[] = array('ad.DEL_INDEX', 'ade.APP_DEL_INDEX'); //$aConditions [] = array ( // 'ade.APP_DISABLE_ACTION_USER', // DBAdapter::getStringDelimiter () . 'null' . DBAdapter::getStringDelimiter () //); $aConditions[] = array('ade.APP_DISABLE_ACTION_USER', DBAdapter::getStringDelimiter() . '0' . DBAdapter::getStringDelimiter()); $aConditions[] = array('ade.APP_TYPE', DBAdapter::getStringDelimiter() . 'PAUSE' . DBAdapter::getStringDelimiter()); $c->addJoinMC($aConditions, Criteria::LEFT_JOIN); $arrayCondition = array(); $arrayCondition[] = array(ApplicationPeer::PRO_UID, "pro.PRO_UID"); $c->addJoinMC($arrayCondition, Criteria::LEFT_JOIN); $c->add(ApplicationPeer::APP_UID, $aaAppUIDs, Criteria::IN); $rs = ApplicationPeer::doSelectRS($c); $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rs->next(); $row = $rs->getRow(); while (is_array($row)) { $allAppDbData[] = $row; $rs->next(); $row = $rs->getRow(); } //Propel::close(); return $allAppDbData; }
echo $metaEncrypt; } else { //we must to remove the boot strap node; $o->remove('___pm_boot_strap___'); } break; case 'showImportForm': require_once 'classes/model/Dynaform.php'; require_once 'classes/model/Content.php'; $uidDynafom = $_POST['DYN_UID']; $oCriteria = new Criteria('workflow'); $oCriteria->clearSelectColumns(); $oCriteria->addSelectColumn(DynaformPeer::DYN_FILENAME); $oCriteria->addAsColumn('DYNA_NAME', 'C_DYNA.CON_VALUE'); $oCriteria->addAsColumn('PROC_NAME', 'C_PROC.CON_VALUE'); $oCriteria->addAlias("C_DYNA", "CONTENT"); $oCriteria->addAlias("C_PROC", "CONTENT"); $arrayCondition = array(); $arrayCondition[] = array(DynaformPeer::DYN_UID, "C_DYNA.CON_ID"); $oCriteria->addJoinMC($arrayCondition, Criteria::LEFT_JOIN); $arrayCondition = array(); $arrayCondition[] = array(DynaformPeer::PRO_UID, "C_PROC.CON_ID"); $oCriteria->addJoinMC($arrayCondition, Criteria::LEFT_JOIN); $oCriteria->add('C_DYNA.CON_LANG', SYS_LANG); $oCriteria->add('C_DYNA.CON_CATEGORY', 'DYN_TITLE'); $oCriteria->add('C_PROC.CON_LANG', SYS_LANG); $oCriteria->add('C_PROC.CON_CATEGORY', 'PRO_TITLE'); $oCriteria->add(DynaformPeer::DYN_UID, $uidDynafom, Criteria::NOT_EQUAL); $oCriteria->addAscendingOrderByColumn('PROC_NAME'); $oCriteria->addAscendingOrderByColumn('DYNA_NAME'); $oDataset = DynaformPeer::doSelectRS($oCriteria);
function calculateExecutionDateMultiple() { try { $rowsCreated = 0; $rowsRejected = 0; G::LoadClass('dates'); $oDates = new dates(); // SELECT TASK2.* , // EVENT.EVN_UID, EVENT.PRO_UID, EVENT.EVN_TAS_UID_FROM, // EVENT.EVN_TAS_ESTIMATED_DURATION, EVENT.EVN_WHEN, // EVENT.EVN_WHEN_OCCURS, EVENT.EVN_RELATED_TO, APP_DELEGATION.APP_UID, APP_DELEGATION.DEL_INDEX, APP_DELEGATION.TAS_UID, // APP_DELEGATION.DEL_DELEGATE_DATE, APP_DELEGATION.DEL_INIT_DATE, APP_DELEGATION.DEL_TASK_DUE_DATE, // APP_DELEGATION.DEL_FINISH_DATE // FROM // APP_DELEGATION // LEFT JOIN EVENT ON (APP_DELEGATION.TAS_UID=EVENT.EVN_TAS_UID_FROM) // LEFT JOIN APP_EVENT ON (APP_DELEGATION.APP_UID=APP_EVENT.APP_UID AND APP_DELEGATION.DEL_INDEX=APP_EVENT.DEL_INDEX) // LEFT JOIN APP_DELEGATION AS TASK2 ON (TASK2.TAS_UID = EVENT.EVN_TAS_UID_TO AND TASK2.APP_UID = APP_DELEGATION.APP_UID ) // // WHERE // APP_EVENT.APP_UID IS NULL // AND EVENT.EVN_STATUS='ACTIVE' // AND EVENT.EVN_RELATED_TO='MULTIPLE' // AND TASK2.DEL_FINISH_DATE IS NULL //get info about the Event and the APP_DELEGATION to process $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(EventPeer::EVN_UID); $oCriteria->addSelectColumn(EventPeer::PRO_UID); $oCriteria->addSelectColumn(EventPeer::EVN_TAS_UID_FROM); $oCriteria->addSelectColumn(EventPeer::EVN_TAS_ESTIMATED_DURATION); $oCriteria->addSelectColumn(EventPeer::EVN_WHEN); $oCriteria->addSelectColumn(EventPeer::EVN_WHEN_OCCURS); $oCriteria->addSelectColumn(EventPeer::EVN_RELATED_TO); $oCriteria->addSelectColumn(AppDelegationPeer::APP_UID); $oCriteria->addSelectColumn(AppDelegationPeer::DEL_INDEX); $oCriteria->addSelectColumn(AppDelegationPeer::TAS_UID); $oCriteria->addSelectColumn(AppDelegationPeer::DEL_DELEGATE_DATE); $oCriteria->addSelectColumn(AppDelegationPeer::DEL_INIT_DATE); $oCriteria->addSelectColumn(AppDelegationPeer::DEL_TASK_DUE_DATE); $oCriteria->addSelectColumn(AppDelegationPeer::DEL_FINISH_DATE); $aConditions = array(); $aConditions[] = array(AppDelegationPeer::TAS_UID, EventPeer::EVN_TAS_UID_FROM); //$aConditions[] = array(AppDelegationPeer::DEL_FINISH_DATE, null, Criteria::IS_NULL ); $oCriteria->addJoinMC($aConditions, Criteria::LEFT_JOIN); $aConditions = array(); $aConditions[] = array(AppDelegationPeer::APP_UID, AppEventPeer::APP_UID); $aConditions[] = array(AppDelegationPeer::DEL_INDEX, AppEventPeer::DEL_INDEX); $aConditions[] = array(EventPeer::EVN_UID, AppEventPeer::EVN_UID); $oCriteria->addJoinMC($aConditions, Criteria::LEFT_JOIN); $oCriteria->addAlias('DEL2', 'APP_DELEGATION'); $aConditions = array(); $aConditions[] = array(AppDelegationPeer::APP_UID, 'DEL2.APP_UID'); $aConditions[] = array(EventPeer::EVN_TAS_UID_TO, 'DEL2.TAS_UID'); $oCriteria->addJoinMC($aConditions, Criteria::LEFT_JOIN); $oCriteria->add(AppEventPeer::APP_UID, null, Criteria::ISNULL); $oCriteria->add(EventPeer::EVN_STATUS, 'ACTIVE'); $oCriteria->add(EventPeer::EVN_RELATED_TO, 'MULTIPLE'); $oCriteria->add('DEL2.DEL_FINISH_DATE', null, Criteria::ISNULL); // $oCriteria->add(AppDelegationPeer::DEL_DELEGATE_DATE, date('Y-m-d') , Criteria::GREATER_THAN ); $oDataset = EventPeer::doSelectRs($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset->next(); while ($aData = $oDataset->getRow()) { $estimatedDuration = (double) $aData['EVN_TAS_ESTIMATED_DURATION']; $when = (double) $aData['EVN_WHEN']; $whenOccurs = $aData['EVN_WHEN_OCCURS']; if ($whenOccurs == 'AFTER_TIME') { //for multiple $sDueDate = date('Y-m-d H:i:s', $oDates->calculateDate($aData['DEL_DELEGATE_DATE'], $estimatedDuration, 'days', 1)); $sDueDate = $aData['DEL_TASK_DUE_DATE']; $calculatedDueDateA = $oDates->calculateDate($sDueDate, $when, 'days', 1); $sActionDate = date('Y-m-d H:i:s', $calculatedDueDateA['DUE_DATE_SECONDS']); $validStartDate = $sActionDate >= $aData['DEL_DELEGATE_DATE']; } else { $sDueDate = $aData['DEL_DELEGATE_DATE']; $calculatedDueDateA = $oDates->calculateDate($sDueDate, $when, 'days', 1); $sActionDate = date('Y-m-d H:i:s', $calculatedDueDateA['DUE_DATE_SECONDS']); $validStartDate = $sActionDate >= $aData['DEL_DELEGATE_DATE']; } $aData['APP_EVN_ACTION_DATE'] = $sActionDate; if ($validStartDate) { $rowsCreated++; $oAppEvent = new AppEvent(); $oAppEvent->create($aData); } else { $rowsRejected++; $aData['APP_EVN_STATUS'] = 'INVALID'; $oAppEvent = new AppEvent(); $oAppEvent->create($aData); } $oDataset->next(); } return "Created {$rowsCreated} MULTIPLE rows in APP_EVENT and rejected {$rowsRejected} rows "; } catch (Exception $oError) { throw new Exception($oError->getMessage()); } }
/** * Get application and delegation data from database * * @param string $aAppUID array of application identifiers * @return array of array of records from database */ public function getListApplicationUpdateDelegationData($aaAppUIDs) { $allAppDbData = array(); $c = new Criteria(); $c->addSelectColumn(ApplicationPeer::APP_UID); $c->addSelectColumn(ApplicationPeer::APP_NUMBER); $c->addSelectColumn(ApplicationPeer::APP_STATUS); $c->addSelectColumn(ApplicationPeer::PRO_UID); $c->addSelectColumn(ApplicationPeer::APP_CREATE_DATE); $c->addSelectColumn(ApplicationPeer::APP_FINISH_DATE); $c->addSelectColumn(ApplicationPeer::APP_UPDATE_DATE); $c->addSelectColumn(ApplicationPeer::APP_DATA); $c->addAsColumn("APP_TITLE", "capp.CON_VALUE"); $c->addAsColumn("PRO_TITLE", "cpro.CON_VALUE"); $c->addSelectColumn("ad.DEL_INDEX"); $c->addSelectColumn("ad.DEL_PREVIOUS"); $c->addSelectColumn("ad.TAS_UID"); $c->addSelectColumn("ad.USR_UID"); $c->addSelectColumn("ad.DEL_TYPE"); $c->addSelectColumn("ad.DEL_THREAD"); $c->addSelectColumn("ad.DEL_THREAD_STATUS"); $c->addSelectColumn("ad.DEL_PRIORITY"); $c->addSelectColumn("ad.DEL_DELEGATE_DATE"); $c->addSelectColumn("ad.DEL_INIT_DATE"); $c->addSelectColumn("ad.DEL_TASK_DUE_DATE"); $c->addSelectColumn("ad.DEL_FINISH_DATE"); $c->addSelectColumn("ad.DEL_DURATION"); $c->addSelectColumn("ad.DEL_QUEUE_DURATION"); $c->addSelectColumn("ad.DEL_DELAY_DURATION"); $c->addSelectColumn("ad.DEL_STARTED"); $c->addSelectColumn("ad.DEL_FINISHED"); $c->addSelectColumn("ad.DEL_DELAYED"); $c->addSelectColumn("ad.APP_OVERDUE_PERCENTAGE"); $c->addSelectColumn("at.APP_THREAD_INDEX"); $c->addSelectColumn("at.APP_THREAD_PARENT"); $c->addSelectColumn("at.APP_THREAD_STATUS"); $c->addAsColumn("APPDELY_APP_DELAY_UID", "appDely.APP_DELAY_UID"); $c->addAsColumn("APPDELY_APP_TYPE", "appDely.APP_TYPE"); $c->addAsColumn("APPDELY_APP_DISABLE_ACTION_USER", "appDely.APP_DISABLE_ACTION_USER"); $c->addAsColumn("PRO_CATEGORY_UID", "pro.PRO_CATEGORY"); $c->addAlias("capp", "CONTENT"); $c->addAlias("cpro", "CONTENT"); $c->addAlias("ad", "APP_DELEGATION"); $c->addAlias("at", "APP_THREAD"); $c->addAlias("appDely", "APP_DELAY"); $c->addAlias("pro", "PROCESS"); $arrayCondition = array(); $arrayCondition[] = array(ApplicationPeer::APP_UID, "capp.CON_ID"); $arrayCondition[] = array("capp.CON_CATEGORY", DBAdapter::getStringDelimiter() . "APP_TITLE" . DBAdapter::getStringDelimiter()); $arrayCondition[] = array("capp.CON_LANG", DBAdapter::getStringDelimiter() . "en" . DBAdapter::getStringDelimiter()); $c->addJoinMC($arrayCondition, Criteria::LEFT_JOIN); $arrayCondition = array(); $arrayCondition[] = array(ApplicationPeer::PRO_UID, "cpro.CON_ID"); $arrayCondition[] = array("cpro.CON_CATEGORY", DBAdapter::getStringDelimiter() . "PRO_TITLE" . DBAdapter::getStringDelimiter()); $arrayCondition[] = array("cpro.CON_LANG", DBAdapter::getStringDelimiter() . "en" . DBAdapter::getStringDelimiter()); $c->addJoinMC($arrayCondition, Criteria::LEFT_JOIN); $c->addJoin(ApplicationPeer::APP_UID, "ad.APP_UID", Criteria::JOIN); $arrayCondition = array(); $arrayCondition[] = array("ad.APP_UID", "at.APP_UID"); $arrayCondition[] = array("ad.DEL_THREAD", "at.APP_THREAD_INDEX"); $c->addJoinMC($arrayCondition, Criteria::JOIN); $arrayCondition = array(); $arrayCondition[] = array("ad.APP_UID", "appDely.APP_UID"); $arrayCondition[] = array("ad.DEL_INDEX", "appDely.APP_DEL_INDEX"); $c->addJoinMC($arrayCondition, Criteria::LEFT_JOIN); $arrayCondition = array(); $arrayCondition[] = array(ApplicationPeer::PRO_UID, "pro.PRO_UID"); $c->addJoinMC($arrayCondition, Criteria::LEFT_JOIN); $c->add(ApplicationPeer::APP_UID, $aaAppUIDs, Criteria::IN); $rs = ApplicationPeer::doSelectRS($c); $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC); while ($rs->next()) { $row = $rs->getRow(); $allAppDbData[] = $row; } return $allAppDbData; }
/** * This function looks for an special case it has a condition * * * @name generatedReport2_filter * * @param string $from * @param string $to * @param string $startedby * @return object */ function generatedReport2_filter($from, $to, $startedby) { $this->reportsPatch(); require_once 'classes/model/AppDelegation.php'; require_once 'classes/model/Application.php'; require_once 'classes/model/Users.php'; $oCriteria = new Criteria('workflow'); $del = DBAdapter::getStringDelimiter(); $oCriteria->addSelectColumn(AppDelegationPeer::PRO_UID); $oCriteria->addAsColumn("MIN", "MIN(" . AppDelegationPeer::DEL_DURATION . ")"); $oCriteria->addAsColumn("MAX", "MAX(" . AppDelegationPeer::DEL_DURATION . ")"); $oCriteria->addAsColumn('PRO_TITLE', 'C1.CON_VALUE'); $oCriteria->addAlias("C1", 'CONTENT'); $proTitleConds = array(); $proTitleConds[] = array(AppDelegationPeer::PRO_UID, 'C1.CON_ID'); $proTitleConds[] = array('C1.CON_CATEGORY', $del . 'PRO_TITLE' . $del); $proTitleConds[] = array('C1.CON_LANG', $del . SYS_LANG . $del); $oCriteria->addJoinMC($proTitleConds, Criteria::LEFT_JOIN); $oCriteria->addGroupByColumn(AppDelegationPeer::PRO_UID); $oCriteria->addGroupByColumn('C1.CON_VALUE'); $oCriteria->add($oCriteria->getNewCriterion(AppDelegationPeer::DEL_INIT_DATE, $from . ' 00:00:00', Criteria::GREATER_EQUAL)->addAnd($oCriteria->getNewCriterion(AppDelegationPeer::DEL_INIT_DATE, $to . ' 23:59:59', Criteria::LESS_EQUAL))); if ($startedby != '') { $oCriteria->add(AppDelegationPeer::USR_UID, $startedby); } $oDataset = AppDelegationPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset->next(); $month = date('Y-m-d', mktime(0, 0, 0, date("m") - 1, date("d"), date("Y"))); $lastmonth = date('Y-m-d', mktime(0, 0, 0, date("m") - 2, date("d"), date("Y"))); $day = mktime(0, 0, 0, date("m"), date("d") - 1, date("Y")); $lastday = mktime(0, 0, 0, date("m"), date("d") - 2, date("Y")); $aProcess[] = array('PRO_UID' => 'char', 'PRO_TITLE' => 'char', 'CANTCASES' => 'integer', 'MIN' => 'float', 'MAX' => 'float', 'CASELASTMONTH' => 'integer', 'CASELASTDAY' => 'integer'); while ($aRow = $oDataset->getRow()) { $oCriteria2 = new Criteria('workflow'); $oCriteria2->addSelectColumn(ApplicationPeer::PRO_UID); $oCriteria2->addAsColumn("CANTCASES", "COUNT(*)"); $oCriteria2->add(ApplicationPeer::PRO_UID, $aRow['PRO_UID']); if ($startedby != '') { $oCriteria2->add(ApplicationPeer::APP_INIT_USER, $startedby); } $oCriteria2->addGroupByColumn(ApplicationPeer::PRO_UID); $oDataset2 = AppDelegationPeer::doSelectRS($oCriteria2); $oDataset2->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset2->next(); $aRow2 = $oDataset2->getRow(); $cant = $aRow2['CANTCASES']; $oCriteria2 = new Criteria('workflow'); $oCriteria2->addSelectColumn(ApplicationPeer::PRO_UID); $oCriteria2->addAsColumn("CANTCASES", "COUNT(*)"); $oCriteria2->add(ApplicationPeer::PRO_UID, $aRow['PRO_UID']); $oCriteria2->add(ApplicationPeer::APP_INIT_DATE, $lastmonth, Criteria::GREATER_EQUAL); $oCriteria2->add(ApplicationPeer::APP_INIT_DATE, $month, Criteria::LESS_EQUAL); if ($startedby != '') { $oCriteria2->add(ApplicationPeer::APP_INIT_USER, $startedby); } $oCriteria2->addGroupByColumn(ApplicationPeer::PRO_UID); $oDataset2 = AppDelegationPeer::doSelectRS($oCriteria2); $oDataset2->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset2->next(); $aRow2 = $oDataset2->getRow(); $cant1 = $aRow2['CANTCASES']; $oCriteria2 = new Criteria('workflow'); $oCriteria2->addSelectColumn(ApplicationPeer::PRO_UID); $oCriteria2->addAsColumn("CANTCASES", "COUNT(*)"); $oCriteria2->add(ApplicationPeer::PRO_UID, $aRow['PRO_UID']); $oCriteria2->add(ApplicationPeer::APP_INIT_DATE, $lastday, Criteria::GREATER_EQUAL); $oCriteria2->add(ApplicationPeer::APP_INIT_DATE, $day, Criteria::LESS_EQUAL); if ($startedby != '') { $oCriteria2->add(ApplicationPeer::APP_INIT_USER, $startedby); } $oCriteria2->addGroupByColumn(ApplicationPeer::PRO_UID); $oDataset2 = AppDelegationPeer::doSelectRS($oCriteria2); $oDataset2->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset2->next(); $aRow2 = $oDataset2->getRow(); $cant2 = $aRow2['CANTCASES']; /*$aProcess[] = array('PRO_UID' => $aRow['PRO_UID'], 'PRO_TITLE' => $aRow['PRO_TITLE'], 'CANTCASES' => $cant, 'CASELASTMONTH' => $cant1, 'CASELASTDAY' => $cant2 );*/ $aProcess[] = array('PRO_UID' => $aRow['PRO_UID'], 'PRO_TITLE' => $aRow['PRO_TITLE'], 'CANTCASES' => $cant, 'MIN' => number_format($aRow['MIN'], 2), 'MAX' => number_format($aRow['MAX'], 2), 'CASELASTMONTH' => number_format($cant1, 2), 'CASELASTDAY' => number_format($cant2, 2)); $oDataset->next(); } global $_DBArray; $_DBArray['reports'] = $aProcess; $_SESSION['_DBArray'] = $_DBArray; G::LoadClass('ArrayPeer'); $oCriteria = new Criteria('dbarray'); $oCriteria->setDBArrayTable('reports'); return $oCriteria; }
public function __get($name) { switch ($name) { case 'biogHist': return self::toDiscursiveSet($this->resource->history); case 'entityType': switch ($this->resource->entityTypeId) { case QubitTerm::CORPORATE_BODY_ID: return 'corporateBody'; case QubitTerm::FAMILY_ID: return 'family'; case QubitTerm::PERSON_ID: return 'person'; } return; case 'existDates': // TODO <date/>, <dateRange/>, <dateSet/>, <descriptiveNote/>, simple // natural language parsing? return '<date>' . esc_specialchars($this->resource->datesOfExistence) . '</date>'; case 'generalContext': return self::toDiscursiveSet($this->resource->generalContext); case 'maintenanceHistory': ProjectConfiguration::getActive()->loadHelpers('Date'); $createdAt = format_date($this->resource->createdAt, 's'); $updatedAt = format_date($this->resource->updatedAt, 's'); $createdDisplay = format_date($this->resource->createdAt, 'F'); $updatedDisplay = format_date($this->resource->updatedAt, 'F'); return <<<return <maintenanceEvent> <eventType>created</eventType> <eventDateTime standardDateTime="{$createdAt}">{$createdDisplay}</eventDateTime> <agentType>human</agentType> <agent/> </maintenanceEvent> <maintenanceEvent> <eventType>revised</eventType> <eventDateTime standardDateTime="{$updatedAt}">{$updatedDisplay}</eventDateTime> <agentType>human</agentType> <agent/> </maintenanceEvent> return; case 'maintenanceStatus': switch (strtolower($this->resource->descriptionStatus)) { case 'revised': return 'revised'; default: return 'new'; } case 'publicationStatus': return 'approved'; case 'resourceRelation': $criteria = new Criteria(); $criteria->add(QubitEvent::ACTOR_ID, $this->resource->id); $criteria->addJoin(QubitEvent::INFORMATION_OBJECT_ID, QubitInformationObject::ID); return QubitEvent::get($criteria); case 'functionRelation': $criteria = new Criteria(); $criteria->addAlias('subj', QubitObject::TABLE_NAME); $criteria->addJoin(QubitRelation::SUBJECT_ID, 'subj.id'); $criteria->add(QubitRelation::OBJECT_ID, $this->resource->id); $criteria->add('subj.class_name', 'QubitFunction'); return QubitRelation::get($criteria); case 'structureOrGenealogy': return self::toDiscursiveSet($this->resource->internalStructures); } }
/** * task Case * * @param string sessionId : The session ID which is obtained when logging in * @param string caseId : The case ID. The caseList() function can be used to find the ID number for cases * @return $result returns the current task for a given case. Note that the logged-in user must have privileges * to access the task */ public function taskCase ($caseId) { $result = array (); try { $oCriteria = new Criteria( 'workflow' ); $del = DBAdapter::getStringDelimiter(); $oCriteria->addSelectColumn( AppDelegationPeer::DEL_INDEX ); $oCriteria->addSelectColumn( AppDelegationPeer::TAS_UID ); $oCriteria->addAsColumn( 'TAS_TITLE', 'C1.CON_VALUE' ); $oCriteria->addAlias( "C1", 'CONTENT' ); $tasTitleConds = array (); $tasTitleConds[] = array (AppDelegationPeer::TAS_UID,'C1.CON_ID'); $tasTitleConds[] = array ('C1.CON_CATEGORY',$del . 'TAS_TITLE' . $del); $tasTitleConds[] = array ('C1.CON_LANG',$del . SYS_LANG . $del); $oCriteria->addJoinMC( $tasTitleConds, Criteria::LEFT_JOIN ); $oCriteria->add( AppDelegationPeer::APP_UID, $caseId ); $oCriteria->add( AppDelegationPeer::DEL_THREAD_STATUS, 'OPEN' ); $oCriteria->add( AppDelegationPeer::DEL_FINISH_DATE, null, Criteria::ISNULL ); $oDataset = AppDelegationPeer::doSelectRS( $oCriteria ); $oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC ); $oDataset->next(); while ($aRow = $oDataset->getRow()) { $result[] = array ( 'guid' => $aRow['TAS_UID'], 'name' => $aRow['TAS_TITLE'], 'delegate' => $aRow['DEL_INDEX'] ); $oDataset->next(); } return $result; } catch (Exception $e) { $result[] = array ('guid' => $e->getMessage(),'name' => $e->getMessage(), 'delegate' => $e->getMessage() ); return $result; } }
public static function getConvocatorias($culture, $page = 1, $limit = self::PAGE_SIZE, $autonomicas, $municipales, &$totalUp = false, &$totalDown = false) { $cache = null; //sfcontext::getInstance()->getViewCacheManager()->getCache(); if ($cache != null) { $key = md5("elecciones_{$partido}-{$institucion}-{$culture}-{$page}-{$order}"); $data = $cache->get($key); } else { $data = false; } if ($data) { $totalUp = unserialize($cache->get("{$key}-totalUp")); $totalDown = unserialize($cache->get("{$key}-totalDown")); return unserialize($cache->get("{$key}")); } else { $c = new Criteria(); $pager = new sfPropelPager('Convocatoria', $limit); $c->addJoin(EleccionPeer::ID, ConvocatoriaPeer::ELECCION_ID); $c->addJoin(ListaPeer::CONVOCATORIA_ID, ConvocatoriaPeer::ID); $c->addJoin(array(EleccionPeer::ID, EleccionI18nPeer::CULTURE), array(EleccionI18nPeer::ID, "'{$culture}'"), Criteria::INNER_JOIN); $c->addDescendingOrderByColumn(ConvocatoriaPeer::FECHA); $c->addAscendingOrderByColumn(EleccionI18nPeer::NOMBRE_CORTO); if ($municipales) { $c->addAlias('muni', 'geo'); $c->addAlias('prov', 'geo'); $c->addJoin(EleccionPeer::ID, EleccionInstitucionPeer::ELECCION_ID); $c->addJoin(EleccionInstitucionPeer::INSTITUCION_ID, InstitucionPeer::ID); $c->addJoin('muni.ID', InstitucionPeer::GEO_ID); $c->addJoin('muni.GEO_ID', 'prov.ID'); $c->add('prov.CODIGO', null, Criteria::ISNOTNULL); } if ($autonomicas) { $c->addAlias('auton', 'geo'); $c->addJoin(EleccionPeer::ID, EleccionInstitucionPeer::ELECCION_ID); $c->addJoin(EleccionInstitucionPeer::INSTITUCION_ID, InstitucionPeer::ID); $c->addJoin(GeoPeer::ID, InstitucionPeer::GEO_ID); $c->add(GeoPeer::GEO_ID, 1); } $c->addAscendingOrderByColumn(EleccionI18nPeer::NOMBRE); $c->setDistinct(); $pager->setCriteria($c); $pager->setPage($page); $pager->init(); if ($cache != null) { $cache->set($key, serialize($pager)); $cache->set("{$key}-totalUp", serialize($totalUp)); $cache->set("{$key}-totalDown", serialize($totalDown)); } return $pager; } }
/** * Return a single Adhoc user or group assigned to an activity * * @param string $sProcessUID {@min 32} {@max 32} * @param string $sTaskUID {@min 32} {@max 32} * @param string $sAssigneeUID {@min 32} {@max 32} * * return array * * @access public */ public function getTaskAdhocAssignee($sProcessUID, $sTaskUID, $sAssigneeUID) { try { Validator::proUid($sProcessUID, '$prj_uid'); $this->validateActUid($sTaskUID); $iType = 2; $aUsers = array(); $sDelimiter = \DBAdapter::getStringDelimiter(); $oCriteria = new \Criteria('workflow'); $oCriteria->addAsColumn('GRP_TITLE', 'C.CON_VALUE'); $oCriteria->addSelectColumn(\TaskUserPeer::TAS_UID); $oCriteria->addSelectColumn(\TaskUserPeer::USR_UID); $oCriteria->addSelectColumn(\TaskUserPeer::TU_TYPE); $oCriteria->addSelectColumn(\TaskUserPeer::TU_RELATION); $oCriteria->addAlias('C', 'CONTENT'); $aConditions = array(); $aConditions[] = array(\TaskUserPeer::USR_UID, 'C.CON_ID'); $aConditions[] = array('C.CON_CATEGORY', $sDelimiter . 'GRP_TITLE' . $sDelimiter); $aConditions[] = array('C.CON_LANG', $sDelimiter . SYS_LANG . $sDelimiter); $oCriteria->addJoinMC($aConditions, \Criteria::LEFT_JOIN); $oCriteria->add(\TaskUserPeer::USR_UID, $sAssigneeUID); $oCriteria->add(\TaskUserPeer::TAS_UID, $sTaskUID); $oCriteria->add(\TaskUserPeer::TU_TYPE, $iType); $oCriteria->add(\TaskUserPeer::TU_RELATION, 2); $oDataset = \TaskUserPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $oDataset->next(); $c = 0; $oTasks = new \Tasks(); $aAux = $oTasks->getGroupsOfTask($sTaskUID, 2); $aUIDS1 = array(); foreach ($aAux as $aGroup) { $aUIDS1[] = $aGroup['GRP_UID']; } $criteria = new \Criteria('workflow'); $criteria->addSelectColumn(\GroupwfPeer::GRP_UID); $criteria->addSelectColumn(\GroupwfPeer::GRP_STATUS); $criteria->addSelectColumn(\GroupwfPeer::GRP_UX); $criteria->addAsColumn('GRP_TITLE', \ContentPeer::CON_VALUE); $criteria->addJoin(\GroupwfPeer::GRP_UID, \ContentPeer::CON_ID, \Criteria::LEFT_JOIN); $criteria->add(\ContentPeer::CON_CATEGORY, 'GRP_TITLE'); $criteria->add(\ContentPeer::CON_LANG, SYS_LANG); $criteria->add(\GroupwfPeer::GRP_UID, $sAssigneeUID); $criteria->addAscendingOrderByColumn(\ContentPeer::CON_VALUE); $oDataset = \GroupwfPeer::doSelectRS($criteria); $oDataset->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $groups = array(); while ($oDataset->next()) { $groups[] = $oDataset->getRow(); } $result = array('rows' => $groups); foreach ($result['rows'] as $results) { if (in_array($results['GRP_UID'], $aUIDS1)) { $c++; $oCriteria = new \Criteria('workflow'); $oCriteria->addSelectColumn('COUNT(*) AS MEMBERS_NUMBER'); $oCriteria->add(\GroupUserPeer::GRP_UID, $results['GRP_UID']); $oDataset2 = \GroupUserPeer::doSelectRS($oCriteria); $oDataset2->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $oDataset2->next(); $aRow2 = $oDataset2->getRow(); $aUsers[] = array('ada_uid' => $results['GRP_UID'], 'ada_name' => !isset($aRow2['GROUP_INACTIVE']) ? $results['GRP_TITLE'] . ' (' . $aRow2['MEMBERS_NUMBER'] . ' ' . ((int) $aRow2['MEMBERS_NUMBER'] == 1 ? \G::LoadTranslation('ID_USER') : \G::LoadTranslation('ID_USERS')) . ')' . '' : $results['GRP_TITLE'] . ' ' . $aRow2['GROUP_INACTIVE'], 'ada_lastname' => "", 'ada_username' => "", 'ada_type' => "group"); } } $oCriteria = new \Criteria('workflow'); $oCriteria->addSelectColumn(\UsersPeer::USR_FIRSTNAME); $oCriteria->addSelectColumn(\UsersPeer::USR_LASTNAME); $oCriteria->addSelectColumn(\UsersPeer::USR_USERNAME); $oCriteria->addSelectColumn(\UsersPeer::USR_EMAIL); $oCriteria->addSelectColumn(\TaskUserPeer::TAS_UID); $oCriteria->addSelectColumn(\TaskUserPeer::USR_UID); $oCriteria->addSelectColumn(\TaskUserPeer::TU_TYPE); $oCriteria->addSelectColumn(\TaskUserPeer::TU_RELATION); $oCriteria->addJoin(\TaskUserPeer::USR_UID, \UsersPeer::USR_UID, \Criteria::LEFT_JOIN); $oCriteria->add(\TaskUserPeer::USR_UID, $sAssigneeUID); $oCriteria->add(\TaskUserPeer::TAS_UID, $sTaskUID); $oCriteria->add(\TaskUserPeer::TU_TYPE, $iType); $oCriteria->add(\TaskUserPeer::TU_RELATION, 1); $oDataset = \TaskUserPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $oDataset->next(); while ($aRow = $oDataset->getRow()) { $aUsers = array('ada_uid' => $aRow['USR_UID'], 'ada_name' => $aRow['USR_FIRSTNAME'], 'ada_lastname' => $aRow['USR_LASTNAME'], 'ada_username' => $aRow['USR_USERNAME'], 'ada_type' => "user"); $oDataset->next(); } if (empty($aUsers)) { throw new \Exception(\G::LoadTranslation("ID_RECORD_NOT_FOUND", array($sAssigneeUID))); } else { return $aUsers; } } catch (\Exception $e) { throw $e; } }
/** * Get available Case Tracker Objects of a Process * * @param string $processUid Unique id of Process * * return array Return an array with the Case Tracker Objects available of a Process */ public function getAvailableCaseTrackerObjects($processUid) { try { $arrayAvailableCaseTrackerObject = array(); //Verify data $process = new \ProcessMaker\BusinessModel\Process(); $process->throwExceptionIfNotExistsProcess($processUid, "prj_uid"); //Get Uids $arrayDynaFormUid = array(); $arrayInputDocumentUid = array(); $arrayOutputDocumentUid = array(); $criteria = new \Criteria("workflow"); $criteria->add(\CaseTrackerObjectPeer::PRO_UID, $processUid, \Criteria::EQUAL); $rsCriteria = \CaseTrackerObjectPeer::doSelectRS($criteria); $rsCriteria->setFetchmode(\ResultSet::FETCHMODE_ASSOC); while ($rsCriteria->next()) { $row = $rsCriteria->getRow(); switch ($row["CTO_TYPE_OBJ"]) { case "DYNAFORM": $arrayDynaFormUid[] = $row["CTO_UID_OBJ"]; break; case "INPUT_DOCUMENT": $arrayInputDocumentUid[] = $row["CTO_UID_OBJ"]; break; case "OUTPUT_DOCUMENT": $arrayOutputDocumentUid[] = $row["CTO_UID_OBJ"]; break; } } //Array DB $arrayCaseTrackerObject = array(); $delimiter = \DBAdapter::getStringDelimiter(); //DynaForms $criteria = new \Criteria("workflow"); $criteria->addSelectColumn(\DynaformPeer::DYN_UID); $criteria->addAsColumn("DYN_TITLE", "CT.CON_VALUE"); $criteria->addAsColumn("DYN_DESCRIPTION", "CD.CON_VALUE"); $criteria->addAlias("CT", \ContentPeer::TABLE_NAME); $criteria->addAlias("CD", \ContentPeer::TABLE_NAME); $arrayCondition = array(); $arrayCondition[] = array(\DynaformPeer::DYN_UID, "CT.CON_ID", \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_CATEGORY", $delimiter . "DYN_TITLE" . $delimiter, \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_LANG", $delimiter . SYS_LANG . $delimiter, \Criteria::EQUAL); $criteria->addJoinMC($arrayCondition, \Criteria::LEFT_JOIN); $arrayCondition = array(); $arrayCondition[] = array(\DynaformPeer::DYN_UID, "CD.CON_ID", \Criteria::EQUAL); $arrayCondition[] = array("CD.CON_CATEGORY", $delimiter . "DYN_DESCRIPTION" . $delimiter, \Criteria::EQUAL); $arrayCondition[] = array("CD.CON_LANG", $delimiter . SYS_LANG . $delimiter, \Criteria::EQUAL); $criteria->addJoinMC($arrayCondition, \Criteria::LEFT_JOIN); $criteria->add(\DynaformPeer::PRO_UID, $processUid, \Criteria::EQUAL); $criteria->add(\DynaformPeer::DYN_UID, $arrayDynaFormUid, \Criteria::NOT_IN); $criteria->add(\DynaformPeer::DYN_TYPE, "xmlform", \Criteria::EQUAL); $rsCriteria = \DynaformPeer::doSelectRS($criteria); $rsCriteria->setFetchmode(\ResultSet::FETCHMODE_ASSOC); while ($rsCriteria->next()) { $row = $rsCriteria->getRow(); if ($row["DYN_TITLE"] . "" == "") { //There is no transaltion for this Document name, try to get/regenerate the label $row["DYN_TITLE"] = \Content::Load("DYN_TITLE", "", $row["DYN_UID"], SYS_LANG); } $arrayCaseTrackerObject[] = array("obj_uid" => $row["DYN_UID"], "obj_title" => $row["DYN_TITLE"], "obj_description" => $row["DYN_DESCRIPTION"], "obj_type" => "DYNAFORM"); } //InputDocuments $criteria = new \Criteria("workflow"); $criteria->addSelectColumn(\InputDocumentPeer::INP_DOC_UID); $criteria->addAsColumn("INP_DOC_TITLE", "CT.CON_VALUE"); $criteria->addAsColumn("INP_DOC_DESCRIPTION", "CD.CON_VALUE"); $criteria->addAlias("CT", \ContentPeer::TABLE_NAME); $criteria->addAlias("CD", \ContentPeer::TABLE_NAME); $arrayCondition = array(); $arrayCondition[] = array(\InputDocumentPeer::INP_DOC_UID, "CT.CON_ID", \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_CATEGORY", $delimiter . "INP_DOC_TITLE" . $delimiter, \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_LANG", $delimiter . SYS_LANG . $delimiter, \Criteria::EQUAL); $criteria->addJoinMC($arrayCondition, \Criteria::LEFT_JOIN); $arrayCondition = array(); $arrayCondition[] = array(\InputDocumentPeer::INP_DOC_UID, "CD.CON_ID", \Criteria::EQUAL); $arrayCondition[] = array("CD.CON_CATEGORY", $delimiter . "INP_DOC_DESCRIPTION" . $delimiter, \Criteria::EQUAL); $arrayCondition[] = array("CD.CON_LANG", $delimiter . SYS_LANG . $delimiter, \Criteria::EQUAL); $criteria->addJoinMC($arrayCondition, \Criteria::LEFT_JOIN); $criteria->add(\InputDocumentPeer::PRO_UID, $processUid, \Criteria::EQUAL); $criteria->add(\InputDocumentPeer::INP_DOC_UID, $arrayInputDocumentUid, \Criteria::NOT_IN); $rsCriteria = \InputDocumentPeer::doSelectRS($criteria); $rsCriteria->setFetchmode(\ResultSet::FETCHMODE_ASSOC); while ($rsCriteria->next()) { $row = $rsCriteria->getRow(); if ($row["INP_DOC_TITLE"] . "" == "") { //There is no transaltion for this Document name, try to get/regenerate the label $row["INP_DOC_TITLE"] = \Content::Load("INP_DOC_TITLE", "", $row["INP_DOC_UID"], SYS_LANG); } $arrayCaseTrackerObject[] = array("obj_uid" => $row["INP_DOC_UID"], "obj_title" => $row["INP_DOC_TITLE"], "obj_description" => $row["INP_DOC_DESCRIPTION"], "obj_type" => "INPUT_DOCUMENT"); } //OutputDocuments $criteria = new \Criteria("workflow"); $criteria->addSelectColumn(\OutputDocumentPeer::OUT_DOC_UID); $criteria->addAsColumn("OUT_DOC_TITLE", "CT.CON_VALUE"); $criteria->addAsColumn("OUT_DOC_DESCRIPTION", "CD.CON_VALUE"); $criteria->addAlias("CT", \ContentPeer::TABLE_NAME); $criteria->addAlias("CD", \ContentPeer::TABLE_NAME); $arrayCondition = array(); $arrayCondition[] = array(\OutputDocumentPeer::OUT_DOC_UID, "CT.CON_ID", \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_CATEGORY", $delimiter . "OUT_DOC_TITLE" . $delimiter, \Criteria::EQUAL); $arrayCondition[] = array("CT.CON_LANG", $delimiter . SYS_LANG . $delimiter, \Criteria::EQUAL); $criteria->addJoinMC($arrayCondition, \Criteria::LEFT_JOIN); $arrayCondition = array(); $arrayCondition[] = array(\OutputDocumentPeer::OUT_DOC_UID, "CD.CON_ID", \Criteria::EQUAL); $arrayCondition[] = array("CD.CON_CATEGORY", $delimiter . "OUT_DOC_DESCRIPTION" . $delimiter, \Criteria::EQUAL); $arrayCondition[] = array("CD.CON_LANG", $delimiter . SYS_LANG . $delimiter, \Criteria::EQUAL); $criteria->addJoinMC($arrayCondition, \Criteria::LEFT_JOIN); $criteria->add(\OutputDocumentPeer::PRO_UID, $processUid, \Criteria::EQUAL); $criteria->add(\OutputDocumentPeer::OUT_DOC_UID, $arrayOutputDocumentUid, \Criteria::NOT_IN); $rsCriteria = \OutputDocumentPeer::doSelectRS($criteria); $rsCriteria->setFetchmode(\ResultSet::FETCHMODE_ASSOC); while ($rsCriteria->next()) { $row = $rsCriteria->getRow(); if ($row["OUT_DOC_TITLE"] . "" == "") { //There is no transaltion for this Document name, try to get/regenerate the label $row["OUT_DOC_TITLE"] = \Content::Load("OUT_DOC_TITLE", "", $row["OUT_DOC_UID"], SYS_LANG); } $arrayCaseTrackerObject[] = array("obj_uid" => $row["OUT_DOC_UID"], "obj_title" => $row["OUT_DOC_TITLE"], "obj_description" => $row["OUT_DOC_DESCRIPTION"], "obj_type" => "OUTPUT_DOCUMENT"); } $arrayCaseTrackerObject = \ProcessMaker\Util\ArrayUtil::sort($arrayCaseTrackerObject, array("obj_type", "obj_title"), SORT_ASC); return $arrayCaseTrackerObject; } catch (\Exception $e) { throw $e; } }