/** * 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(ListCompletedPeer::APP_UID, $pks, Criteria::IN); $objs = ListCompletedPeer::doSelect($criteria, $con); } return $objs; }
public function loadList($usr_uid, $filters = array(), $callbackRecord = null) { $resp = array(); $criteria = new Criteria(); $criteria->addSelectColumn(ListCompletedPeer::APP_UID); $criteria->addSelectColumn(ListCompletedPeer::USR_UID); $criteria->addSelectColumn(ListCompletedPeer::TAS_UID); $criteria->addSelectColumn(ListCompletedPeer::PRO_UID); $criteria->addSelectColumn(ListCompletedPeer::APP_NUMBER); $criteria->addSelectColumn(ListCompletedPeer::APP_TITLE); $criteria->addSelectColumn(ListCompletedPeer::APP_PRO_TITLE); $criteria->addSelectColumn(ListCompletedPeer::APP_TAS_TITLE); $criteria->addSelectColumn(ListCompletedPeer::APP_CREATE_DATE); $criteria->addSelectColumn(ListCompletedPeer::APP_FINISH_DATE); $criteria->addSelectColumn(ListCompletedPeer::DEL_INDEX); $criteria->addSelectColumn(ListCompletedPeer::DEL_PREVIOUS_USR_UID); $criteria->addSelectColumn(ListCompletedPeer::DEL_CURRENT_USR_FIRSTNAME); $criteria->addSelectColumn(ListCompletedPeer::DEL_CURRENT_USR_LASTNAME); $criteria->addSelectColumn(ListCompletedPeer::DEL_CURRENT_USR_USERNAME); $criteria->add( ListCompletedPeer::USR_UID, $usr_uid, Criteria::EQUAL ); self::loadFilters($criteria, $filters); $sort = (!empty($filters['sort'])) ? $filters['sort'] : "APP_FINISH_DATE"; $dir = isset($filters['dir']) ? $filters['dir'] : "ASC"; $start = isset($filters['start']) ? $filters['start'] : "0"; $limit = isset($filters['limit']) ? $filters['limit'] : "25"; $paged = isset($filters['paged']) ? $filters['paged'] : 1; if ($dir == "DESC") { $criteria->addDescendingOrderByColumn($sort); } else { $criteria->addAscendingOrderByColumn($sort); } if ($paged == 1) { $criteria->setLimit( $limit ); $criteria->setOffset( $start ); } $dataset = ListCompletedPeer::doSelectRS($criteria, Propel::getDbConnection('workflow_ro') ); $dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $data = array(); while ($dataset->next()) { $aRow = (is_null($callbackRecord))? $dataset->getRow() : $callbackRecord($dataset->getRow()); $data[] = $aRow; } return $data; }
/** * 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 = ListCompletedPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setAppUid($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setUsrUid($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setTasUid($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setProUid($arr[$keys[3]]); } if (array_key_exists($keys[4], $arr)) { $this->setAppNumber($arr[$keys[4]]); } if (array_key_exists($keys[5], $arr)) { $this->setAppTitle($arr[$keys[5]]); } if (array_key_exists($keys[6], $arr)) { $this->setAppProTitle($arr[$keys[6]]); } if (array_key_exists($keys[7], $arr)) { $this->setAppTasTitle($arr[$keys[7]]); } if (array_key_exists($keys[8], $arr)) { $this->setAppCreateDate($arr[$keys[8]]); } if (array_key_exists($keys[9], $arr)) { $this->setAppFinishDate($arr[$keys[9]]); } if (array_key_exists($keys[10], $arr)) { $this->setDelIndex($arr[$keys[10]]); } if (array_key_exists($keys[11], $arr)) { $this->setDelPreviousUsrUid($arr[$keys[11]]); } if (array_key_exists($keys[12], $arr)) { $this->setDelCurrentUsrUsername($arr[$keys[12]]); } if (array_key_exists($keys[13], $arr)) { $this->setDelCurrentUsrFirstname($arr[$keys[13]]); } if (array_key_exists($keys[14], $arr)) { $this->setDelCurrentUsrLastname($arr[$keys[14]]); } }