public function getCalendar ($userUid, $proUid = null, $tasUid = null) { require_once 'classes/model/CalendarAssignments.php'; $criteria = new Criteria ( 'workflow' ); $criteria->clearSelectColumns ( ); $calendarData = array(); //Default Calendar $calendarData['UID'] = '00000000000000000000000000000001'; $calendarData['TYPE'] = 'DEFAULT'; //Load User,Task and Process calendars (if exist) $criteria->addSelectColumn ( CalendarAssignmentsPeer::CALENDAR_UID ); $criteria->addSelectColumn ( CalendarAssignmentsPeer::OBJECT_UID ); $criteria->addSelectColumn ( CalendarAssignmentsPeer::OBJECT_TYPE ); $criteria->add ( CalendarAssignmentsPeer::OBJECT_UID, array($userUid, $proUid, $tasUid), CRITERIA::IN ); $oDataset = CalendarAssignmentsPeer::doSelectRS ( $criteria ); $oDataset->setFetchmode ( ResultSet::FETCHMODE_ASSOC ); $oDataset->next (); $calendarArray = array(); while (is_array($aRow = $oDataset->getRow ())) { if ($aRow['OBJECT_UID']==$userUid) { $calendarArray['USER'] = $aRow ['CALENDAR_UID']; } if ($aRow['OBJECT_UID']==$proUid) { $calendarArray['PROCESS'] = $aRow ['CALENDAR_UID']; } if ($aRow['OBJECT_UID']==$tasUid) { $calendarArray['TASK'] = $aRow ['CALENDAR_UID']; } $oDataset->next (); } if (isset($calendarArray['USER'])) { $calendarData['UID'] = $calendarArray['USER']; $calendarData['TYPE'] = 'USER'; } elseif (isset($calendarArray['PROCESS'])) { $calendarData['UID'] = $calendarArray['PROCESS']; $calendarData['TYPE'] = 'PROCESS'; } elseif (isset($calendarArray['TASK'])) { $calendarData['UID'] = $calendarArray['TASK']; $calendarData['TYPE'] = 'TASK'; } $this->pmCalendarUid = $calendarData['UID']; return $this->pmCalendarUid; }
/** * Implementation for 'GET' method for Rest API * * @param mixed $objectUid Primary key * * @return array $result Returns array within multiple records or a single record depending if * a single selection was requested passing id(s) as param */ protected function get($objectUid = null) { $result = array(); try { $noArguments = true; $argumentList = func_get_args(); foreach ($argumentList as $arg) { if (!is_null($arg)) { $noArguments = false; } } if ($noArguments) { $criteria = new Criteria('workflow'); $criteria->addSelectColumn(CalendarAssignmentsPeer::OBJECT_UID); $criteria->addSelectColumn(CalendarAssignmentsPeer::CALENDAR_UID); $criteria->addSelectColumn(CalendarAssignmentsPeer::OBJECT_TYPE); $dataset = AppEventPeer::doSelectRS($criteria); $dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); while ($dataset->next()) { $result[] = $dataset->getRow(); } } else { $record = CalendarAssignmentsPeer::retrieveByPK($objectUid); if ($record) { $result = $record->toArray(BasePeer::TYPE_FIELDNAME); } else { $paramValues = ""; foreach ($argumentList as $arg) { $paramValues .= strlen($paramValues) ? ', ' : ''; if (!is_null($arg)) { $paramValues .= "{$arg}"; } else { $paramValues .= "NULL"; } } throw new RestException(417, "table CalendarAssignments ({$paramValues})"); } } } catch (RestException $e) { throw new RestException($e->getCode(), $e->getMessage()); } catch (Exception $e) { throw new RestException(412, $e->getMessage()); } return $result; }
function getAllCounterByCalendar($type) { $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(CalendarAssignmentsPeer::CALENDAR_UID); $oCriteria->addSelectColumn('COUNT(*) AS CNT'); $oCriteria->addGroupByColumn(CalendarAssignmentsPeer::CALENDAR_UID); $oCriteria->add(CalendarAssignmentsPeer::OBJECT_TYPE, $type); $oDataset = CalendarAssignmentsPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $aCounter = array(); while ($oDataset->next()) { $row = $oDataset->getRow(); $aCounter[$row['CALENDAR_UID']] = $row['CNT']; } return $aCounter; }
/** * Populates the object using an array. * * This is particularly useful when populating an object from one of the * request arrays (e.g. $_POST). This method goes through the column * names, checking to see whether a matching key exists in populated * array. If so the setByName() method is called for that column. * * You can specify the key type of the array by additionally passing one * of the class type constants TYPE_PHPNAME, TYPE_COLNAME, TYPE_FIELDNAME, * TYPE_NUM. The default key type is the column's phpname (e.g. 'authorId') * * @param array $arr An array to populate the object from. * @param string $keyType The type of keys the array uses. * @return void */ public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME) { $keys = CalendarAssignmentsPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setObjectUid($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setCalendarUid($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setObjectType($arr[$keys[2]]); } }
/** * Retrieve multiple objects by pkey. * * @param array $pks List of primary keys * @param Connection $con the connection to use * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function retrieveByPKs($pks, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(); $criteria->add(CalendarAssignmentsPeer::OBJECT_UID, $pks, Criteria::IN); $objs = CalendarAssignmentsPeer::doSelect($criteria, $con); } return $objs; }