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;
}
