123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236 |
- <?php
- class privateMessageModel extends messagesModel
- {
- private $db;
- private $id;
- private $message;
- private $postDate;
- private $expireDate;
- private $userId;
- private $supervisorId;
- private $sentId;
- private $reviewDate;
- private $reviewed;
- /**
- * @return mixed
- */
- public function getId()
- {
- return $this->id;
- }
- /**
- * @param mixed $id
- */
- public function setId($id)
- {
- $this->id = $id;
- }
- /**
- * @return mixed
- */
- public function getMessage()
- {
- return $this->message;
- }
- /**
- * @param mixed $message
- */
- public function setMessage($message)
- {
- $this->message = $message;
- }
- /**
- * @return mixed
- */
- public function getExpireDate()
- {
- $date = new DateTime();
- $date->setTimestamp($this->expireDate);
- return $date->format('m/d/Y');
- }
- /**
- * @param mixed $expireDate
- */
- public function setExpireDate($expireDate)
- {
- $this->expireDate = strtotime($expireDate);
- }
- /**
- * @return mixed
- */
- public function getPostDate()
- {
- return $this->postDate;
- }
- /**
- * @return mixed
- */
- public function getUserId()
- {
- return $this->userId;
- }
- /**
- * @param mixed $userId
- */
- public function setUserId($userId)
- {
- $this->userId = $userId;
- }
- /**
- * @return mixed
- */
- public function getReviewDate()
- {
- return $this->reviewDate;
- }
- /**
- * @param mixed $reviewDate
- */
- public function setReviewDate($reviewDate)
- {
- $this->reviewDate = $reviewDate;
- }
- /**
- * @return mixed
- */
- public function getReviewed()
- {
- return $this->reviewed;
- }
- /**
- * @param mixed $reviewed
- */
- public function setReviewed($reviewed)
- {
- $this->reviewed = $reviewed;
- }
- /**
- * @return mixed
- */
- public function getSupervisorId()
- {
- return $this->supervisorId;
- }
- /**
- * @param mixed $supervisorId
- */
- public function setSupervisorId($supervisorId)
- {
- $this->supervisorId = $supervisorId;
- }
- /**
- * @return mixed
- */
- public function getSentId()
- {
- return $this->sentId;
- }
- /**
- * @param mixed $sentId
- */
- public function setSentId($sentId)
- {
- $this->sentId = $sentId;
- }
- function __construct()
- {
- $this->db = Staple_DB::get();
- }
- function load($id)
- {
- $user = new userModel();
- $uid = $user->getId();
- $sql = "SELECT * FROM privateMessages WHERE id = '".$this->db->real_escape_string($id)."' AND userId = '".$this->db->real_escape_string($uid)."'";
- $query = $this->db->query($sql);
- $result = $query->fetch_assoc();
- return $result;
- }
- function supervisorLoad($id)
- {
- $user = new userModel();
- $uid = $user->getId();
- $sql = "SELECT * FROM privateMessages WHERE id = '".$this->db->real_escape_string($id)."' AND supervisorId = '".$this->db->real_escape_string($uid)."'";
- $query = $this->db->query($sql);
- $result = $query->fetch_assoc();
- return $result;
- }
- function save()
- {
- if(isset($this->id))
- {
- //update
- $sql = "UPDATE privateMessages SET message = '".$this->message."', expireDate ='".$this->expireDate."' WHERE id = '".$this->id."' ";
- if($this->db->query($sql))
- {
- return true;
- }
- }
- else
- {
- //save
- $date = new DateTime();
- $datetime = $date->format('U');
- $user = new userModel();
- $superId = $user->getId();
- $sentId = $user->getId();
- $sql = "INSERT INTO privateMessages (message,postDate,expireDate,userId,supervisorId,sentId) VALUES ('".$this->message."','".$datetime."','".$this->expireDate."','".$this->userId."','".$superId."','".$sentId."')";
- if($this->db->query($sql))
- {
- return true;
- }
- }
- }
- function delete($id)
- {
- $sql = "DELETE FROM privateMessages WHERE id = '".$this->db->real_escape_string($id)."'";
- if($this->db->query($sql))
- {
- return true;
- }
- }
- function markRead($id)
- {
- $sql = "UPDATE privateMessages SET reviewed = '".$this->db->real_escape_string(1)."' WHERE id = '".$this->db->real_escape_string($id)."' ";
- if($this->db->query($sql))
- {
- return true;
- }
- }
- }
|