KataoOrderProductPeer.php 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. <?php
  2. /**
  3. * Subclass for performing query and update operations on the 'katao_order_product' table.
  4. *
  5. * @package lib.model
  6. */
  7. class KataoOrderProductPeer extends BaseKataoOrderProductPeer {
  8. /**
  9. * KataoOrderProductPeer::receiveQuantity()
  10. *
  11. * @param int $id
  12. * @param float $quantity
  13. * @return
  14. */
  15. public static function receiveQuantity($id, $quantity) {
  16. $criteria_update = new Criteria();
  17. $criteria_update->add(self::QUANTITY_RECEIVED, $quantity);
  18. $criteria_update->add(self::HAS_BEEN_RECEIVED, true);
  19. $criteria_where = new Criteria();
  20. $criteria_where->add(self::ID, $id);
  21. BasePeer::doUpdate($criteria_where, $criteria_update, Propel::getConnection());
  22. }
  23. /**
  24. * KataoOrderProductPeer::getIdByProductAndPeriodAndNode()
  25. *
  26. * @param int $katao_product_id
  27. * @param int $katao_period_id
  28. * @param int $katao_node_id
  29. * @return int
  30. */
  31. public static function getIdByProductAndPeriodAndNode($katao_product_id, $katao_period_id, $katao_node_id) {
  32. $return = null;
  33. $criteria = new Criteria();
  34. $criteria->addSelectColumn(self::ID);
  35. $criteria->addJoin(self::KATAO_ORDER_ID, KataoOrderPeer::ID);
  36. $criteria->add(self::KATAO_PRODUCT_ID, $katao_product_id);
  37. $criteria->add(KataoOrderPeer::KATAO_PERIOD_ID, $katao_period_id);
  38. $criteria->add(KataoOrderPeer::KATAO_NODE_ID, $katao_node_id);
  39. $criteria->setLimit(1);
  40. $rs = self::doSelectRS($criteria);
  41. if ($rs->next()) {
  42. $return = $rs->getInt(1);
  43. }
  44. return $return;
  45. }
  46. }