privateMessageModel.php 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246
  1. <?php
  2. class privateMessageModel extends messagesModel
  3. {
  4. private $db;
  5. private $id;
  6. private $message;
  7. private $postDate;
  8. private $expireDate;
  9. private $userId;
  10. private $supervisorId;
  11. private $sentId;
  12. private $reviewDate;
  13. private $reviewed;
  14. /**
  15. * @return mixed
  16. */
  17. public function getId()
  18. {
  19. return $this->id;
  20. }
  21. /**
  22. * @param mixed $id
  23. */
  24. public function setId($id)
  25. {
  26. $this->id = $id;
  27. }
  28. /**
  29. * @return mixed
  30. */
  31. public function getMessage()
  32. {
  33. return $this->message;
  34. }
  35. /**
  36. * @param mixed $message
  37. */
  38. public function setMessage($message)
  39. {
  40. $this->message = $message;
  41. }
  42. /**
  43. * @return mixed
  44. */
  45. public function getExpireDate()
  46. {
  47. $date = new DateTime();
  48. $date->setTimestamp($this->expireDate);
  49. return $date->format('m/d/Y');
  50. }
  51. /**
  52. * @param mixed $expireDate
  53. */
  54. public function setExpireDate($expireDate)
  55. {
  56. $this->expireDate = strtotime($expireDate);
  57. }
  58. /**
  59. * @return mixed
  60. */
  61. public function getPostDate()
  62. {
  63. return $this->postDate;
  64. }
  65. /**
  66. * @return mixed
  67. */
  68. public function getUserId()
  69. {
  70. return $this->userId;
  71. }
  72. /**
  73. * @param mixed $userId
  74. */
  75. public function setUserId($userId)
  76. {
  77. $this->userId = $userId;
  78. }
  79. /**
  80. * @return mixed
  81. */
  82. public function getReviewDate()
  83. {
  84. return $this->reviewDate;
  85. }
  86. /**
  87. * @param mixed $reviewDate
  88. */
  89. public function setReviewDate($reviewDate)
  90. {
  91. $this->reviewDate = $reviewDate;
  92. }
  93. /**
  94. * @return mixed
  95. */
  96. public function getReviewed()
  97. {
  98. return $this->reviewed;
  99. }
  100. /**
  101. * @param mixed $reviewed
  102. */
  103. public function setReviewed($reviewed)
  104. {
  105. $this->reviewed = $reviewed;
  106. }
  107. /**
  108. * @return mixed
  109. */
  110. public function getSupervisorId()
  111. {
  112. return $this->supervisorId;
  113. }
  114. /**
  115. * @param mixed $supervisorId
  116. */
  117. public function setSupervisorId($supervisorId)
  118. {
  119. $this->supervisorId = $supervisorId;
  120. }
  121. /**
  122. * @return mixed
  123. */
  124. public function getSentId()
  125. {
  126. return $this->sentId;
  127. }
  128. /**
  129. * @param mixed $sentId
  130. */
  131. public function setSentId($sentId)
  132. {
  133. $this->sentId = $sentId;
  134. }
  135. function __construct()
  136. {
  137. $this->db = Staple_DB::get();
  138. }
  139. function load($id)
  140. {
  141. $user = new userModel();
  142. $uid = $user->getId();
  143. $sql = "SELECT * FROM privateMessages WHERE id = '".$this->db->real_escape_string($id)."' AND userId = '".$this->db->real_escape_string($uid)."'";
  144. $query = $this->db->query($sql);
  145. $result = $query->fetch_assoc();
  146. return $result;
  147. }
  148. function loadexpired($id)
  149. {
  150. $sql = "SELECT * FROM privateMessages WHERE id = '".$this->db->real_escape_string($id)."'";
  151. $query = $this->db->query($sql);
  152. $result = $query->fetch_assoc();
  153. return $result;
  154. }
  155. function supervisorLoad($id)
  156. {
  157. $user = new userModel();
  158. $uid = $user->getId();
  159. $sql = "SELECT * FROM privateMessages WHERE id = '".$this->db->real_escape_string($id)."' AND supervisorId = '".$this->db->real_escape_string($uid)."'";
  160. $query = $this->db->query($sql);
  161. $result = $query->fetch_assoc();
  162. return $result;
  163. }
  164. function save()
  165. {
  166. if(isset($this->id))
  167. {
  168. //update
  169. $sql = "UPDATE privateMessages SET message = '".$this->message."', expireDate ='".$this->expireDate."' WHERE id = '".$this->id."' ";
  170. if($this->db->query($sql))
  171. {
  172. return true;
  173. }
  174. }
  175. else
  176. {
  177. //save
  178. $date = new DateTime();
  179. $datetime = $date->format('U');
  180. $user = new userModel();
  181. $superId = $user->getId();
  182. $sentId = $user->getId();
  183. $sql = "INSERT INTO privateMessages (message,postDate,expireDate,userId,supervisorId,sentId) VALUES ('".$this->message."','".$datetime."','".$this->expireDate."','".$this->userId."','".$superId."','".$sentId."')";
  184. if($this->db->query($sql))
  185. {
  186. return true;
  187. }
  188. }
  189. }
  190. function delete($id)
  191. {
  192. $sql = "DELETE FROM privateMessages WHERE id = '".$this->db->real_escape_string($id)."'";
  193. if($this->db->query($sql))
  194. {
  195. return true;
  196. }
  197. }
  198. function markRead($id)
  199. {
  200. $sql = "UPDATE privateMessages SET reviewed = '".$this->db->real_escape_string(1)."' WHERE id = '".$this->db->real_escape_string($id)."' ";
  201. if($this->db->query($sql))
  202. {
  203. return true;
  204. }
  205. }
  206. }