public function getVCatalogPerDepts($criteria = null, $con = null) { include_once 'lib/model/om/BaseVCatalogPerDeptPeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collVCatalogPerDepts === null) { if ($this->isNew()) { $this->collVCatalogPerDepts = array(); } else { $criteria->add(VCatalogPerDeptPeer::CATALOG_ID, $this->getId()); VCatalogPerDeptPeer::addSelectColumns($criteria); $this->collVCatalogPerDepts = VCatalogPerDeptPeer::doSelect($criteria, $con); } } else { if (!$this->isNew()) { $criteria->add(VCatalogPerDeptPeer::CATALOG_ID, $this->getId()); VCatalogPerDeptPeer::addSelectColumns($criteria); if (!isset($this->lastVCatalogPerDeptCriteria) || !$this->lastVCatalogPerDeptCriteria->equals($criteria)) { $this->collVCatalogPerDepts = VCatalogPerDeptPeer::doSelect($criteria, $con); } } } $this->lastVCatalogPerDeptCriteria = $criteria; return $this->collVCatalogPerDepts; }
public static function retrieveByPK($catalog_id, $cat_category_id, $department_id, $col_location_id, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $criteria = new Criteria(); $criteria->add(VCatalogPerDeptPeer::CATALOG_ID, $catalog_id); $criteria->add(VCatalogPerDeptPeer::CAT_CATEGORY_ID, $cat_category_id); $criteria->add(VCatalogPerDeptPeer::DEPARTMENT_ID, $department_id); $criteria->add(VCatalogPerDeptPeer::COL_LOCATION_ID, $col_location_id); $v = VCatalogPerDeptPeer::doSelect($criteria, $con); return !empty($v) ? $v[0] : null; }