messagesModel.php 4.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193
  1. <?php
  2. class messagesModel extends Staple_Model
  3. {
  4. private $db;
  5. private $systemMessages;
  6. private $expiredSystemMessages;
  7. private $privateMessages;
  8. private $expiredPrivateMessages;
  9. private $allPrivateMessages;
  10. private $totalPrivateMessages;
  11. private $supervisorMessages;
  12. /**
  13. * @return mixed
  14. */
  15. public function getSystemMessages()
  16. {
  17. return $this->systemMessages;
  18. }
  19. /**
  20. * @return mixed
  21. */
  22. public function getPrivateMessages()
  23. {
  24. return $this->privateMessages;
  25. }
  26. /**
  27. * @return mixed
  28. */
  29. public function getExpiredSystemMessages()
  30. {
  31. return $this->expiredSystemMessages;
  32. }
  33. /**
  34. * @return mixed
  35. */
  36. public function getExpiredPrivateMessages()
  37. {
  38. return $this->expiredPrivateMessages;
  39. }
  40. /**
  41. * @return int
  42. */
  43. public function getTotalPrivateMessages()
  44. {
  45. return $this->totalPrivateMessages;
  46. }/**
  47. * @return mixed
  48. */
  49. public function getAllPrivateMessages()
  50. {
  51. return $this->allPrivateMessages;
  52. }
  53. /**
  54. * @return mixed
  55. */
  56. public function getSupervisorMessages()
  57. {
  58. return $this->supervisorMessages;
  59. }
  60. function __construct()
  61. {
  62. $this->db = Staple_DB::get();
  63. $this->systemMessages = $this->loadSystemMessages();
  64. $this->expiredSystemMessages = $this->loadExpiredSystemMessages();
  65. $this->privateMessages = $this->loadPrivateMessages();
  66. $this->allPrivateMessages = $this->loadAllPrivateMessages();
  67. $this->totalPrivateMessages = $this->countPrivateMessages();
  68. $this->supervisorMessages = $this->loadSupervisorMessages();
  69. }
  70. private function loadSystemMessages()
  71. {
  72. $date = new DateTime();
  73. $date->setTime(0,0,0);
  74. $timestamp = $date->format('U');
  75. $sql = "SELECT id FROM messages WHERE expireDate >= $timestamp ORDER BY postDate ASC";
  76. $query = $this->db->query($sql);
  77. $data = array();
  78. while($result = $query->fetch_assoc())
  79. {
  80. $message = new messageModel();
  81. $data[] = $message->load($result['id']);
  82. }
  83. return $data;
  84. }
  85. private function loadExpiredSystemMessages()
  86. {
  87. $date = new DateTime();
  88. $date->setTime(23,59,59);
  89. $timestamp = $date->format('U');
  90. $sql = "SELECT id FROM messages WHERE expireDate <= $timestamp ORDER BY postDate ASC";
  91. $query = $this->db->query($sql);
  92. $data = array();
  93. while($result = $query->fetch_assoc())
  94. {
  95. $message = new messageModel();
  96. $data[] = $message->load($result['id']);
  97. }
  98. return $data;
  99. }
  100. private function loadPrivateMessages()
  101. {
  102. $user = new userModel();
  103. $userId = $user->getId();
  104. $date = new DateTime();
  105. $date->setTime(0,0,0);
  106. $sql = "SELECT id FROM privateMessages WHERE userId = '".$userId."' AND reviewed = '0' ORDER BY postDate ASC limit 1";
  107. $query = $this->db->query($sql);
  108. $data = array();
  109. while($result = $query->fetch_assoc())
  110. {
  111. $message = new privateMessageModel();
  112. $data[] = $message->load($result['id']);
  113. }
  114. return $data;
  115. }
  116. private function loadAllPrivateMessages()
  117. {
  118. $user = new userModel();
  119. $userId = $user->getId();
  120. $date = new DateTime();
  121. $date->setTime(0,0,0);
  122. $sql = "SELECT id FROM privateMessages WHERE userId = '".$userId."' AND reviewed = '0' ORDER BY postDate ASC";
  123. $query = $this->db->query($sql);
  124. $data = array();
  125. while($result = $query->fetch_assoc())
  126. {
  127. $message = new privateMessageModel();
  128. $data[] = $message->load($result['id']);
  129. }
  130. return $data;
  131. }
  132. private function countPrivateMessages()
  133. {
  134. $user = new userModel();
  135. $userId = $user->getId();
  136. $sql = "SELECT id FROM privateMessages WHERE userId = '".$userId."' AND reviewed = '0'";
  137. $query = $this->db->query($sql);
  138. return $query->num_rows;
  139. }
  140. private function loadSupervisorMessages()
  141. {
  142. $user = new userModel();
  143. $userId = $user->getId();
  144. $date = new DateTime();
  145. $date->setTime(0,0,0);
  146. $sql = "SELECT id FROM privateMessages WHERE supervisorId = '".$userId."' ORDER BY postDate ASC";
  147. $query = $this->db->query($sql);
  148. $data = array();
  149. while($result = $query->fetch_assoc())
  150. {
  151. $message = new privateMessageModel();
  152. $data[] = $message->supervisorLoad($result['id']);
  153. }
  154. return $data;
  155. }
  156. }