KataoProductCategoryPeer.php 2.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. <?php
  2. /**
  3. * Subclass for performing query and update operations on the 'katao_product_category' table.
  4. *
  5. * @package lib.model
  6. */
  7. class KataoProductCategoryPeer extends BaseKataoProductCategoryPeer {
  8. /**
  9. * KataoProductCategoryPeer::retrieveByUrlIdentifier()
  10. *
  11. * @param string $url_identifier
  12. * @return KataoProductCategory
  13. */
  14. public static function retrieveByUrlIdentifier($url_identifier) {
  15. $criteria = new Criteria();
  16. $criteria->add(self::URL_IDENTIFIER, $url_identifier);
  17. return self::doSelectOne($criteria);
  18. }
  19. public static function getAll() {
  20. $return = array();
  21. $criteria = new Criteria();
  22. $criteria->addSelectColumn(self::ID);
  23. $criteria->addSelectColumn(self::NAME);
  24. $criteria->addSelectColumn(self::URL_IDENTIFIER);
  25. $criteria->addJoin(self::ID, KataoProductFamilyPeer::KATAO_PRODUCT_CATEGORY_ID);
  26. $criteria->addJoin(KataoProductFamilyPeer::ID, KataoProductPeer::KATAO_PRODUCT_FAMILY_ID);
  27. $criteria->add(KataoProductPeer::ID, sfContext::getInstance()->getUser()->getAvailableProducts(), Criteria::IN);
  28. $criterion = $criteria->getNewCriterion(KataoProductPeer::IS_ARCHIVED, null);
  29. $criterion->addOr($criteria->getNewCriterion(KataoProductPeer::IS_ARCHIVED, false));
  30. $criteria->addAnd($criterion);
  31. $criteria->addAscendingOrderByColumn(self::SORT_ORDER);
  32. $rs = self::doSelectRS($criteria);
  33. while ($rs->next()) {
  34. $return[$rs->getInt(1)] = array('name' => $rs->getString(2), 'url' => $rs->getString(3));
  35. }
  36. return $return;
  37. }
  38. public static function getAllSimple() {
  39. $return = array();
  40. $criteria = new Criteria();
  41. $criteria->addSelectColumn(self::ID);
  42. $criteria->addSelectColumn(self::NAME);
  43. $criteria->addAscendingOrderByColumn(self::SORT_ORDER);
  44. $rs = self::doSelectRS($criteria);
  45. while ($rs->next()) {
  46. $return[$rs->getInt(1)] = $rs->getString(2);
  47. }
  48. return $return;
  49. }
  50. }