/** * Get Application data by appUid * * @param string $app_uid Unique id of the app * @param string $index * * return row app_cache_view * */ public function getDraftApp($app_uid, $index = 1) { $c = new \Criteria('workflow'); $c->clearSelectColumns(); $c->addSelectColumn(\AppCacheViewPeer::APP_NUMBER); $c->addSelectColumn(\AppCacheViewPeer::APP_STATUS); $c->addSelectColumn(\AppCacheViewPeer::DEL_INDEX); $c->addSelectColumn(\AppCacheViewPeer::APP_DEL_PREVIOUS_USER); $c->addSelectColumn(\AppCacheViewPeer::DEL_DELEGATE_DATE); $c->addSelectColumn(\AppCacheViewPeer::USR_UID); $c->addSelectColumn(\AppCacheViewPeer::PRO_UID); $c->addSelectColumn(\AppCacheViewPeer::APP_PRO_TITLE); $c->addSelectColumn(\AppCacheViewPeer::APP_TAS_TITLE); $c->addSelectColumn(\AppCacheViewPeer::DEL_THREAD_STATUS); $c->addSelectColumn(\AppCacheViewPeer::TAS_UID); $c->addSelectColumn(\AppCacheViewPeer::DEL_LAST_INDEX); $c->add(\AppCacheViewPeer::APP_UID, $app_uid); $c->add(\AppCacheViewPeer::DEL_INDEX, $index); $rs = \AppCacheViewPeer::doSelectRS($c); $rs->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $rows = array(); while ($rs->next()) { $rows[] = $rs->getRow(); } return $rows; }
function getCalendarBusinessHours($CalendarUid) { $Criteria = new Criteria('workflow'); $Criteria->clearSelectColumns(); $Criteria->addSelectColumn(CalendarBusinessHoursPeer::CALENDAR_UID); $Criteria->addSelectColumn(CalendarBusinessHoursPeer::CALENDAR_BUSINESS_DAY); $Criteria->addSelectColumn(CalendarBusinessHoursPeer::CALENDAR_BUSINESS_START); $Criteria->addSelectColumn(CalendarBusinessHoursPeer::CALENDAR_BUSINESS_END); $Criteria->add(CalendarBusinessHoursPeer::CALENDAR_UID, $CalendarUid, CRITERIA::EQUAL); $Criteria->addDescendingOrderByColumn(CalendarBusinessHoursPeer::CALENDAR_BUSINESS_DAY); $Criteria->addAscendingOrderByColumn(CalendarBusinessHoursPeer::CALENDAR_BUSINESS_START); //$Criteria->addDescendingOrderByColumn ( CalendarBusinessHoursPeer::CALENDAR_BUSINESS_START ); $rs = CalendarBusinessHoursPeer::doSelectRS($Criteria); $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rs->next(); $row = $rs->getRow(); $fields = array(); $count = 0; while (is_array($row)) { $count++; $fields[$count] = $row; $rs->next(); $row = $rs->getRow(); } return $fields; }
protected static function _getItemsPKsVotedByUsers($users_pks, $voting_attitude = null, $model = null) { $c = new Criteria(); $c->setDistinct(); $c->clearSelectColumns(); $c->addSelectColumn(self::VOTABLE_ID); // analyze voting attitude if (!is_null($voting_attitude)) { if ($voting_attitude > 0) { $c->add(self::VOTING, 0, Criteria::GREATER_THAN); } elseif ($voting_attitude < 0) { $c->add(self::VOTING, 0, Criteria::LESS_THAN); } else { $c->add(self::VOTING, 0); } } $c->add(self::USER_ID, $users_pks, Criteria::IN); if (!is_null($model)) { $c->add(self::VOTABLE_MODEL, $model); } $rs = self::doSelectRS($c); $pks = array(); while ($rs->next()) { $pks[] = $rs->getInt(1); } return $pks; }
function getCalendarCriterias($filter, $start, $limit) { $Criteria = new Criteria('workflow'); $Criteria->clearSelectColumns(); $Criteria->addSelectColumn(CalendarDefinitionPeer::CALENDAR_UID); if ($filter != '') { $Criteria->add($Criteria->getNewCriterion(CalendarDefinitionPeer::CALENDAR_NAME, '%' . $filter . '%', Criteria::LIKE)->addOr($Criteria->getNewCriterion(CalendarDefinitionPeer::CALENDAR_DESCRIPTION, '%' . $filter . '%', Criteria::LIKE))); } $Criteria->add(CalendarDefinitionPeer::CALENDAR_STATUS, 'DELETED', Criteria::NOT_EQUAL); $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(CalendarDefinitionPeer::CALENDAR_UID); $oCriteria->addSelectColumn(CalendarDefinitionPeer::CALENDAR_NAME); $oCriteria->addSelectColumn(CalendarDefinitionPeer::CALENDAR_CREATE_DATE); $oCriteria->addSelectColumn(CalendarDefinitionPeer::CALENDAR_UPDATE_DATE); $oCriteria->addSelectColumn(CalendarDefinitionPeer::CALENDAR_DESCRIPTION); $oCriteria->addSelectColumn(CalendarDefinitionPeer::CALENDAR_STATUS); if ($filter != '') { $oCriteria->add($oCriteria->getNewCriterion(CalendarDefinitionPeer::CALENDAR_NAME, '%' . $filter . '%', Criteria::LIKE)->addOr($oCriteria->getNewCriterion(CalendarDefinitionPeer::CALENDAR_DESCRIPTION, '%' . $filter . '%', Criteria::LIKE))); } $oCriteria->add(CalendarDefinitionPeer::CALENDAR_STATUS, 'DELETED', Criteria::NOT_EQUAL); $oCriteria->setLimit($limit); $oCriteria->setOffset($start); $criterias = array(); $criterias['COUNTER'] = $Criteria; $criterias['LIST'] = $oCriteria; return $criterias; }
/** * Return a hash with a list of ids of objects bookmarked (+|-) by a user * bookmarked_ids = array('OppAtto' => array(1, 15, 143), ...); * * @param char(1) +|- type of bookmarking * @param mixed $user_id User primary key * @return array (see description) **/ private static function _getAllBookmarkedIds($type, $user_id) { if ($type != '+' && $type != '-') { throw new deppPropelActAsBookmarkableException('Type can only be + or -'); } if (is_null($user_id) or trim((string) $user_id) === '') { throw new deppPropelActAsBookmarkableException('Impossible to clear a user bookmarking with no user primary key provided'); } $bookmarked_ids = array(); $c = new Criteria(); $c->add(sfBookmarkingPeer::USER_ID, $user_id); $c->add(sfBookmarkingPeer::BOOKMARKING, $type == '+' ? 1 : -1); $c->clearSelectColumns(); $c->addSelectColumn(sfBookmarkingPeer::BOOKMARKABLE_MODEL); $c->addSelectColumn(sfBookmarkingPeer::BOOKMARKABLE_ID); $rs = sfBookmarkingPeer::doSelectRS($c); while ($rs->next()) { $key = $rs->getString(1); if (!array_key_exists($key, $bookmarked_ids)) { $bookmarked_ids[$key] = array(); } array_push($bookmarked_ids[$key], $rs->getInt(2)); } return $bookmarked_ids; }
/** * Get the email server accounts of the current workspace * * return array */ public function getEmailEventServerAccounts() { try { $criteria = new \Criteria("workflow"); $criteria->clearSelectColumns(); $criteria->addSelectColumn(\EmailServerPeer::MESS_UID); $criteria->addSelectColumn(\EmailServerPeer::MESS_FROM_MAIL); $criteria->addSelectColumn(\EmailServerPeer::MESS_ACCOUNT); $criteria->addAsColumn('UID', 'MESS_UID'); $result = \EmailServerPeer::doSelectRS($criteria); $result->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $result->next(); $accountsArray = array(); while ($aRow = $result->getRow()) { if ($aRow['MESS_UID'] != null) { if($aRow['MESS_FROM_MAIL'] == "") { $aRow['EMAIL'] = $aRow['MESS_ACCOUNT']; } else { $aRow['EMAIL'] = $aRow['MESS_FROM_MAIL']; } $accountsArray[] = array_change_key_case($aRow, CASE_LOWER); } $result->next(); } return $accountsArray; } catch (\Exception $e) { throw $e; } }
public function getCalendarHolidays($CalendarUid) { $Criteria = new Criteria('workflow'); $Criteria->clearSelectColumns(); $Criteria->addSelectColumn(CalendarHolidaysPeer::CALENDAR_UID); $Criteria->addSelectColumn(CalendarHolidaysPeer::CALENDAR_HOLIDAY_NAME); $Criteria->addSelectColumn(CalendarHolidaysPeer::CALENDAR_HOLIDAY_START); $Criteria->addSelectColumn(CalendarHolidaysPeer::CALENDAR_HOLIDAY_END); $Criteria->add(CalendarHolidaysPeer::CALENDAR_UID, $CalendarUid, CRITERIA::EQUAL); $rs = CalendarHolidaysPeer::doSelectRS($Criteria); $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rs->next(); $row = $rs->getRow(); $fields = array(); $count = 0; while (is_array($row)) { $count++; $a = explode(" ", $row['CALENDAR_HOLIDAY_START']); $row['CALENDAR_HOLIDAY_START'] = $a[0]; $a = explode(" ", $row['CALENDAR_HOLIDAY_END']); $row['CALENDAR_HOLIDAY_END'] = $a[0]; $fields[$count] = $row; $rs->next(); $row = $rs->getRow(); } return $fields; }
public static function getEquipmentMileage($userId, $bikeId) { $c = new Criteria(); $c->clearSelectColumns(); $c->addSelectColumn('SUM(' . UserStatsPeer::MILEAGE . ')'); $c->addSelectColumn(UserEquipementPeer::EQUIPMENT_ID); //$c->addGroupByColumn(UserRidesPeer::MILEAGE); $c->add(UserEquipementPeer::USER_ID, $userId); $c->add(UserEquipementPeer::BIKE_ID, $bikeId); $c->addJoin(UserEquipementPeer::EQUIPMENT_ID, UserStatEquipPeer::USER_EQUIP_ID, Criteria::INNER_JOIN); $c->addJoin(UserStatEquipPeer::USER_STAT_ID, UserStatsPeer::STAT_NO, Criteria::INNER_JOIN); //$c->addJoin(UserStatsPeer::RIDE_KEY,UserRidesPeer::USER_RIDE_ID, Criteria::INNER_JOIN); $c->addGroupByColumn(UserEquipementPeer::EQUIPMENT_ID); $stmt = UserStatsPeer::doSelectStmt($c); $hashmap = array(); if ($stmt) { while ($row = $stmt->fetch(PDO::FETCH_NUM)) { if ($row) { $sum = $row[0]; $eqId = $row[1]; //echo 'Mil '.$sum.' '.$eqId; $hashmap[$eqId] = $sum; // array_push($hashmap, $eqId=>$sum); } } } return $hashmap; }
/** * Function getRolesBySystem * access public */ function getRolesBySystem($SysUid, $UsrUid) { $con = Propel::getConnection(UsersRolesPeer::DATABASE_NAME); try { $c = new Criteria('rbac'); $c->clearSelectColumns(); $c->addSelectColumn(RolesPeer::ROL_UID); $c->addSelectColumn(RolesPeer::ROL_CODE); $c->addJoin(UsersRolesPeer::ROL_UID, RolesPeer::ROL_UID); $c->add(UsersRolesPeer::USR_UID, $UsrUid); $c->add(RolesPeer::ROL_SYSTEM, $SysUid); $rs = UsersRolesPeer::doSelectRs($c); $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rs->next(); $row = $rs->getRow(); /* return only the first row, no other rows can be permitted while ( is_array ( $row ) ) { $rows[] = $row; $rs->next(); $row = $rs->getRow(); } */ return $row; } catch (Exception $oError) { throw $oError; } }
/** * returns the groups in the given ramo (and for the given legislatura) and include the zero value, if given * * @param string $ramo * @param int $legislatura * @param string $include_zero * @return an associative array, with id and name as key => value * @author Guglielmo Celata */ public static function getAllGroups($ramo, $legislatura, $include_zero = false) { $c = new Criteria(); if ($ramo == 'camera') { $c->add(OppCaricaPeer::TIPO_CARICA_ID, 1); } else { $c->add(OppCaricaPeer::TIPO_CARICA_ID, array(4, 5), Criteria::IN); } $c->addJoin(OppGruppoPeer::ID, OppCaricaHasGruppoPeer::GRUPPO_ID); $c->addJoin(OppCaricaPeer::ID, OppCaricaHasGruppoPeer::CARICA_ID); $c_or_leg = $c->getNewCriterion(OppCaricaPeer::LEGISLATURA, $legislatura); $c_or_leg->addOr($c->getNewCriterion(OppCaricaPeer::LEGISLATURA, null, Criteria::ISNULL)); $c->add($c_or_leg); $c->clearSelectColumns(); $c->addSelectColumn(OppGruppoPeer::ID); $c->addSelectColumn(OppGruppoPeer::NOME); $c->setDistinct(); $rs = OppGruppoPeer::doSelectRS($c); if ($include_zero) { $all_groups = array('0' => $include_zero); } else { $all_groups = array(); } while ($rs->next()) { $all_groups[$rs->getInt(1)] = $rs->getString(2); } return $all_groups; }
public static function getAttoIdsByTag($tag_id) { $c = new Criteria(); $c->add(self::TAG_ID, $tag_id); $c->clearSelectColumns(); $c->addSelectColumn(self::ATTO_ID); return self::doSelectRS($c); }
public function getNotesList($appUid, $usrUid = '', $start = '', $limit = 25, $sort = 'APP_NOTES.NOTE_DATE', $dir = 'DESC', $dateFrom = '', $dateTo = '', $search = '') { $Criteria = new Criteria('workflow'); $Criteria->clearSelectColumns(); $Criteria->addSelectColumn(AppNotesPeer::APP_UID); $Criteria->addSelectColumn(AppNotesPeer::USR_UID); $Criteria->addSelectColumn(AppNotesPeer::NOTE_DATE); $Criteria->addSelectColumn(AppNotesPeer::NOTE_CONTENT); $Criteria->addSelectColumn(AppNotesPeer::NOTE_TYPE); $Criteria->addSelectColumn(AppNotesPeer::NOTE_AVAILABILITY); $Criteria->addSelectColumn(AppNotesPeer::NOTE_ORIGIN_OBJ); $Criteria->addSelectColumn(AppNotesPeer::NOTE_AFFECTED_OBJ1); $Criteria->addSelectColumn(AppNotesPeer::NOTE_AFFECTED_OBJ2); $Criteria->addSelectColumn(AppNotesPeer::NOTE_RECIPIENTS); $Criteria->addSelectColumn(UsersPeer::USR_USERNAME); $Criteria->addSelectColumn(UsersPeer::USR_FIRSTNAME); $Criteria->addSelectColumn(UsersPeer::USR_LASTNAME); $Criteria->addSelectColumn(UsersPeer::USR_EMAIL); $Criteria->addJoin(AppNotesPeer::USR_UID, UsersPeer::USR_UID, Criteria::LEFT_JOIN); $Criteria->add(AppNotesPeer::APP_UID, $appUid, Criteria::EQUAL); if ($usrUid != '') { $Criteria->add(AppNotesPeer::USR_UID, $usrUid, Criteria::EQUAL); } if ($dateFrom != '') { $Criteria->add(AppNotesPeer::NOTE_DATE, $dateFrom, Criteria::GREATER_EQUAL); } if ($dateTo != '') { $Criteria->add(AppNotesPeer::NOTE_DATE, $dateTo, Criteria::LESS_EQUAL); } if ($search != '') { $Criteria->add(AppNotesPeer::NOTE_CONTENT, '%' . $search . '%', Criteria::LIKE); } if ($dir == 'DESC') { $Criteria->addDescendingOrderByColumn($sort); } else { $Criteria->addAscendingOrderByColumn($sort); } $response = array(); $totalCount = AppNotesPeer::doCount($Criteria); $response['totalCount'] = $totalCount; $response['notes'] = array(); if ($start != '') { $Criteria->setLimit($limit); $Criteria->setOffset($start); } $oDataset = appNotesPeer::doSelectRS($Criteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset->next(); while ($aRow = $oDataset->getRow()) { $aRow['NOTE_CONTENT'] = htmlentities(stripslashes($aRow['NOTE_CONTENT']), ENT_QUOTES, 'UTF-8'); $response['notes'][] = $aRow; $oDataset->next(); } $result['criteria'] = $Criteria; $result['array'] = $response; return $result; }
/** * * @return Routes2011[] */ public static function getAllDistinctRouteId() { $criteria = new Criteria(); $criteria->addAscendingOrderByColumn(self::ROUTEID); $criteria->setDistinct(); $criteria->clearSelectColumns(); $criteria->addSelectColumn(self::ROUTEID); return self::doSelect($criteria); }
/** * Returns all credentials (permission names) for the role given */ public static function retrieveAllCredentialsForARole($role) { $c = new Criteria(); $c->add(sfGuardGroupPermissionPeer::GROUP_ID, $role->getId()); $c->addJoin(sfGuardGroupPermissionPeer::PERMISSION_ID, self::ID); $c->clearSelectColumns(); $c->addSelectColumn(self::NAME); $stmt = self::doSelectStmt($c); return $stmt->fetchAll(PDO::FETCH_COLUMN); }
/** * description * * @return return_type * @param var_type $var */ public static function getPropertyNames() { $c = new Criteria(); $c->clearSelectColumns()->addSelectColumn(SkosPropertyPeer::ID); $c->addSelectColumn(self::NAME); $rs = SkosPropertyPeer::doSelectRS($c); while ($rs->next()) { $results[$rs->getString(2)] = $rs->getInt(1); } return $results; }
/** * Check and remove news related to non-existing objects */ function run_opp_news_clean($task, $args) { static $loaded; // load application context if (!$loaded) { define('SF_ROOT_DIR', sfConfig::get('sf_root_dir')); define('SF_APP', 'fe'); define('SF_ENVIRONMENT', 'task'); define('SF_DEBUG', true); require_once SF_ROOT_DIR . DIRECTORY_SEPARATOR . 'apps' . DIRECTORY_SEPARATOR . SF_APP . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'config.php'; sfContext::getInstance(); sfConfig::set('pake', true); error_reporting(E_ALL); $loaded = true; } $start_time = microtime(true); $c = new Criteria(); $c->clearSelectColumns(); $c->addSelectColumn(NewsPeer::ID); $c->addSelectColumn(NewsPeer::RELATED_MONITORABLE_MODEL); $c->addSelectColumn(NewsPeer::RELATED_MONITORABLE_ID); $n_news = NewsPeer::doCount($c); $rs = NewsPeer::doSelectRS($c); $k = 0; $newsids_to_remove = array(); $removed_news = 0; while ($rs->next()) { $news = array(); $news['id'] = $rs->getInt(1); $news['rel_model'] = $rs->getString(2); $news['rel_id'] = $rs->getInt(3); if (opp_check_single_news($news)) { $newsids_to_remove[] = $news['id']; $removed_news++; } $k++; if ($k % 100 == 0) { print "."; } if ($k > 0 && $k % 1000 == 0) { $rem = count($newsids_to_remove); NewsPeer::doDelete($newsids_to_remove); print "processed: {$k}/{$n_news} removed: {$rem} ({$removed_news})\n"; $newsids_to_remove = array(); } } $total_time = microtime(true) - $start_time; echo pakeColor::colorize('All done! ', array('fg' => 'red', 'bold' => true)); echo 'Processed '; echo pakeColor::colorize(count($n_news), array('fg' => 'cyan')); echo ' news in '; echo pakeColor::colorize(sprintf("%f", $total_time), array('fg' => 'cyan')); echo " seconds\n"; }
/** * Get all the different values set to $column. * * @param string $column The column from this class' table. * @param PropelPDO $con Optional PDO object. * @return array */ static public function retrieveAllValuesForColumn($column, PropelPDO $con = null) { $criteria = new Criteria(); $criteria->setDistinct(); $criteria->clearSelectColumns(); $criteria->addSelectColumn($column); return ncTrackerEntryPeer::doSelectStmt($criteria) ->fetchAll(PDO::FETCH_COLUMN); }
public function getHostnames($value = '') { $criteria = new Criteria(); $criteria->clearSelectColumns(); $criteria->addSelectColumn(self::HOSTNAME); $criteria->setDistinct(); $stmt = self::doSelectStmt($criteria); while ($host = $stmt->fetchColumn(0)) { $results[] = $host; } return $results; }
public function getTagsAsString() { $c = new Criteria(); $c->clearSelectColumns()->clearOrderByColumns(); $c->addSelectColumn(sfSimpleBlogTagPeer::TAG); $c->add(sfSimpleBlogTagPeer::SF_BLOG_POST_ID, $this->getId()); $rs = sfSimpleBlogPostPeer::doSelectRS($c); $tags = array(); while ($rs->next()) { $tags[] = $rs->getString(1); } return implode($tags, ','); }
protected static function getAllNamespaces() { $c = new Criteria(); $c->clearSelectColumns(); $c->addSelectColumn(self::LAUNCH_NAMESPACE); $c->setDistinct(); $rs = self::doSelectRS($c); $namespaces = array(); while ($rs->next()) { $namespaces[] = $rs->getString(1); } return $namespaces; }
public function loadByCategoryId($sCategoryUid) { $c = new Criteria('workflow'); $del = DBAdapter::getStringDelimiter(); $c->clearSelectColumns(); $c->addSelectColumn(ProcessCategoryPeer::CATEGORY_NAME); $c->add(ProcessCategoryPeer::CATEGORY_UID, $sCategoryUid); $dataset = ProcessCategoryPeer::doSelectRS($c); $dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $dataset->next(); $aRow = $dataset->getRow(); return $aRow['CATEGORY_NAME']; }
public static function getLodging($name, $passenger_id) { $c = new Criteria(); $c->addJoin(self::PASSENGER_ID, PassengerPeer::ID, Criteria::INNER_JOIN); $c->add(self::PASSENGER_ID, $passenger_id); $name = mysql_escape_string($name); $c->clearSelectColumns(); $c->addSelectColumn(self::LODGING); $c->add(self::LODGING, '%' . $name . '%', Criteria::LIKE); $c->setDistinct(); $c->setLimit(10); return self::doSelectStmt($c); }
/** * description * * @return ProfileProperty[] */ public static function getPropertyNames() { $results = false; $c = new Criteria(); $c->clearSelectColumns()->addSelectColumn(self::SKOS_ID); $c->add(self::PROFILE_ID, 2); $c->addSelectColumn(self::NAME); $rs = self::doSelectRS($c); while ($rs->next()) { $results[$rs->getString(2)] = $rs->getInt(1); } return $results; }
public function getConfigs() { $c = new Criteria(); $c->clearSelectColumns(); $c->addSelectColumn('MAX(' . SchedulerConfigPeer::ID . ')'); $c->addGroupByColumn(SchedulerConfigPeer::VARIABLE); $c->addGroupByColumn(SchedulerConfigPeer::VARIABLE_PART); $c->addAscendingOrderByColumn(SchedulerConfigPeer::VARIABLE); $c->add(SchedulerConfigPeer::SCHEDULER_ID, $this->id); $c->add(SchedulerConfigPeer::WORKER_ID, null); $rs = SchedulerConfigPeer::doSelectStmt($c, myDbHelper::getConnection(myDbHelper::DB_HELPER_CONN_PROPEL2)); $configIds = $rs->fetchAll(PDO::FETCH_COLUMN, 0); return SchedulerConfigPeer::retrieveByPKs($configIds, myDbHelper::getConnection(myDbHelper::DB_HELPER_CONN_PROPEL2)); }
/** * Get the evn_description column value. * * @return string */ public function loadDefaultAccount() { $c = new Criteria('workflow'); $del = DBAdapter::getStringDelimiter(); $c->clearSelectColumns(); $c->addSelectColumn(EmailServerPeer::MESS_ACCOUNT); $c->add(EmailServerPeer::MESS_DEFAULT, 1); $rs = EmailServerPeer::doSelectRS($c, Propel::getDBConnection('workflow_ro')); $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rs->next(); $row = $rs->getRow(); $response = $row; return $response; }
public function getPositionInTopic() { $c = new Criteria(); $c->clearSelectColumns(); $c->addSelectColumn(sfSimpleForumPostPeer::ID); $c->add(sfSimpleForumPostPeer::TOPIC_ID, $this->getTopicId()); $c->addAscendingOrderByColumn(sfSimpleForumPostPeer::CREATED_AT); $rs = sfSimpleForumPostPeer::doSelectRS($c); $messages = array(); while ($rs->next()) { $messages[] = $rs->getInt(1); } return array_search($this->getId(), $messages); }
/** * Check if an Object has been launched with any namespace * * @param BaseObject $object * @throws deppPropelActAsLaunchableException * @return Array of namespaces where the object was launched **/ public function hasBeenLaunched(BaseObject $object) { $c = new Criteria(); $c->add(sfLaunchingPeer::OBJECT_ID, $object->getPrimaryKey()); $c->add(sfLaunchingPeer::OBJECT_MODEL, get_class($object)); $c->clearSelectColumns(); $c->addSelectColumn(sfLaunchingPeer::LAUNCH_NAMESPACE); $rs = sfLaunchingPeer::doSelectRS($c); $launches = array(); while ($rs->next()) { $launches[] = $rs->getString(1); } return $launches; }
public static function getTagsWithCount() { $c = new Criteria(); $c->clearSelectColumns()->clearOrderByColumns(); $c->addSelectColumn(self::TAG); $c->addSelectColumn('count(' . self::SF_BLOG_POST_ID . ') as count'); $c->addGroupByColumn(self::TAG); $rs = self::doSelectRS($c); $tags = array(); while ($rs->next()) { $tags[] = array($rs->getString(1), $rs->getInt(2)); } return $tags; }
/** * Return case scheduler of a project * @param string $sProcessUID * @param string $sCaseSchedulerUID * @return array * * @access public */ public function getCaseScheduler($sProcessUID = '', $sCaseSchedulerUID = '') { try { $oCaseSchedulerTest = \CaseSchedulerPeer::retrieveByPK($sCaseSchedulerUID); if (is_null($oCaseSchedulerTest)) { throw new \Exception(\G::LoadTranslation("ID_CASE_SCHEDULER_DOES_NOT_EXIST", array($sCaseSchedulerUID))); } $oCriteria = new \Criteria('workflow'); $oCriteria->clearSelectColumns(); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_UID); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_NAME); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_DEL_USER_NAME); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_DEL_USER_UID); $oCriteria->addSelectColumn(\CaseSchedulerPeer::PRO_UID); $oCriteria->addSelectColumn(\CaseSchedulerPeer::TAS_UID); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_TIME_NEXT_RUN); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_LAST_RUN_TIME); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_STATE); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_LAST_STATE); $oCriteria->addSelectColumn(\CaseSchedulerPeer::USR_UID); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_OPTION); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_START_TIME); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_START_DATE); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_DAYS_PERFORM_TASK); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_EVERY_DAYS); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_WEEK_DAYS); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_START_DAY); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_MONTHS); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_END_DATE); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_REPEAT_EVERY); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_REPEAT_UNTIL); $oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_REPEAT_STOP_IF_RUNNING); $oCriteria->addSelectColumn(\CaseSchedulerPeer::CASE_SH_PLUGIN_UID); $oCriteria->add(\CaseSchedulerPeer::PRO_UID, $sProcessUID); $oCriteria->add(\CaseSchedulerPeer::SCH_UID, $sCaseSchedulerUID); $oDataset = \CaseSchedulerPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $oDataset->next(); $aRows = array(); while ($aRow = $oDataset->getRow()) { $aRow = array_change_key_case($aRow, CASE_LOWER); $aRows = $aRow; $oDataset->next(); } return $aRows; } catch (Exception $e) { throw $e; } }
/** * gets a list of all agents related to all schemas * * @return array Agents * @param var_type $var */ public static function getSchemaAgents() { $results = array(); $c = new Criteria(); $c->clearSelectColumns(); $c->addSelectColumn(self::AGENT_ID); $c->addJoin(self::AGENT_ID, AgentPeer::ID); $c->addAscendingOrderByColumn(AgentPeer::ORG_NAME); $c->setDistinct(); $rs = self::doSelectRS($c); while ($rs->next()) { $results[] = AgentPeer::retrieveByPK($rs->getInt(1)); } return $results; }