KataoUserPeer.php 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142
  1. <?php
  2. class KataoUserPeer extends BaseKataoUserPeer {
  3. public static function getAllStatuses($is_supplier = false) {
  4. $return = array();
  5. if (!$is_supplier) {
  6. $return[KataoUser::STATUS_PENDING] = self::getStatusStr(KataoUser::STATUS_PENDING);
  7. }
  8. $return[KataoUser::STATUS_ACTIVE] = self::getStatusStr(KataoUser::STATUS_ACTIVE);
  9. $return[KataoUser::STATUS_DISABLED] = self::getStatusStr(KataoUser::STATUS_DISABLED);
  10. return $return;
  11. }
  12. public static function getStatusStr($status) {
  13. switch ($status) {
  14. case KataoUser::STATUS_PENDING:
  15. return 'Contact';
  16. case KataoUser::STATUS_ACTIVE:
  17. return 'Actif';
  18. case KataoUser::STATUS_DISABLED:
  19. return 'Inactif';
  20. }
  21. return '';
  22. }
  23. /**
  24. * KataoUserPeer::isValidUser()
  25. *
  26. * @param string $login
  27. * @param string $password
  28. * @return boolean
  29. */
  30. public static function isValidUser($login, $password) {
  31. $criteria = new Criteria();
  32. $criteria->add(self::LOGIN, $login);
  33. $criteria->add(self::PASSWORD, $password);
  34. $criteria->add(self::STATUS, KataoUser::STATUS_ACTIVE);
  35. return self::doCount($criteria);
  36. }
  37. /**
  38. * KataoUserPeer::getUserByLoginAndPassword()
  39. *
  40. * @param string $form_values
  41. * @param string $form_values2
  42. * @return KataoUser
  43. */
  44. public static function getUserByLoginAndPassword($login, $password) {
  45. $criteria = new Criteria();
  46. $criteria->add(self::LOGIN, $login);
  47. $criteria->add(self::PASSWORD, $password);
  48. $criteria->add(self::STATUS, KataoUser::STATUS_ACTIVE);
  49. return self::doSelectOne($criteria);
  50. }
  51. /**
  52. * KataoUserPeer::getMembersByNodeToArray()
  53. *
  54. * @param int $kataoNodeId
  55. * @return array
  56. */
  57. public static function getMembersByNodeToArray($kataoNodeId = false) {
  58. $return = array();
  59. // member
  60. $criteria = new Criteria();
  61. $criteria->addJoin(self::KATAO_MEMBER_ID, KataoMemberPeer::ID);
  62. $criteria->add(KataoMemberPeer::KATAO_NODE_ID, $kataoNodeId);
  63. foreach (self::doSelect($criteria) as/*(KataoUser)*/ $kataoUser) {
  64. $return[$kataoUser->getId()] = $kataoUser->getFullName();
  65. }
  66. // admin
  67. $criteria = new Criteria();
  68. $criterion = $criteria->getNewCriterion(self::IS_SEO, true);
  69. $criterion->addOr($criteria->getNewCriterion(self::IS_ADMIN, true));
  70. $criteria->addAnd($criterion);
  71. foreach (self::doSelect($criteria) as/*(KataoUser)*/ $kataoUser) {
  72. $return[$kataoUser->getId()] = $kataoUser->getFullName();
  73. }
  74. return $return;
  75. }
  76. /**
  77. * KataoUserPeer::retrieveByKataoSupplierId()
  78. *
  79. * @param int $katao_supplier_id
  80. * @return KataoUser
  81. */
  82. public static function retrieveByKataoSupplierId($katao_supplier_id) {
  83. $criteria = new Criteria();
  84. $criteria->add(self::KATAO_SUPPLIER_ID, $katao_supplier_id);
  85. return self::doSelectOne($criteria);
  86. }
  87. /**
  88. * KataoUserPeer::retrieveByKataoMemberId()
  89. *
  90. * @param int $katao_member_id
  91. * @return KataoUser
  92. */
  93. public static function retrieveByKataoMemberId($katao_member_id) {
  94. $criteria = new Criteria();
  95. $criteria->add(self::KATAO_MEMBER_ID, $katao_member_id);
  96. return self::doSelectOne($criteria);
  97. }
  98. public static function getAll() {
  99. $return = array();
  100. $criteria = new Criteria();
  101. $criteria->addSelectColumn(self::ID);
  102. $criteria->addSelectColumn(KataoMemberPeer::LAST_NAME);
  103. $criteria->addSelectColumn(KataoMemberPeer::FIRST_NAME);
  104. $criteria->addJoin(self::KATAO_MEMBER_ID, KataoMemberPeer::ID);
  105. $criteria->addAscendingOrderByColumn(KataoMemberPeer::LAST_NAME);
  106. $criteria->addAscendingOrderByColumn(KataoMemberPeer::FIRST_NAME);
  107. $rs = self::doSelectRS($criteria);
  108. while ($rs->next()) {
  109. $return[$rs->getInt(1)] = sprintf('%s %s', $rs->getString(2), $rs->getString(3));
  110. }
  111. return $return;
  112. }
  113. /**
  114. * KataoUserPeer::retrieveByEmail()
  115. *
  116. * @param string $email
  117. * @return KataoUser
  118. */
  119. public static function retrieveByEmail($email) {
  120. $criteria = new Criteria();
  121. $criteria->add(self::EMAIL, $email);
  122. return self::doSelectOne($criteria);
  123. }
  124. public static function retrieveMemberById($id){
  125. $c = new Criteria();
  126. $c->add(self::ID, $id);
  127. return self::doSelectOne($c);
  128. }
  129. }