summaryrefslogtreecommitdiff
path: root/models/comment.php
diff options
context:
space:
mode:
Diffstat (limited to 'models/comment.php')
-rw-r--r--models/comment.php115
1 files changed, 114 insertions, 1 deletions
diff --git a/models/comment.php b/models/comment.php
index c476e693..453c2afc 100644
--- a/models/comment.php
+++ b/models/comment.php
@@ -7,10 +7,28 @@ require_once __DIR__.'/base.php';
use \SimpleValidator\Validator;
use \SimpleValidator\Validators;
+/**
+ * Comment model
+ *
+ * @package model
+ * @author Frederic Guillot
+ */
class Comment extends Base
{
+ /**
+ * SQL table name
+ *
+ * @var string
+ */
const TABLE = 'comments';
+ /**
+ * Get all comments for a given task
+ *
+ * @access public
+ * @param integer $task_id Task id
+ * @return array
+ */
public function getAll($task_id)
{
return $this->db
@@ -18,6 +36,8 @@ class Comment extends Base
->columns(
self::TABLE.'.id',
self::TABLE.'.date',
+ self::TABLE.'.task_id',
+ self::TABLE.'.user_id',
self::TABLE.'.comment',
User::TABLE.'.username'
)
@@ -27,6 +47,37 @@ class Comment extends Base
->findAll();
}
+ /**
+ * Get a comment
+ *
+ * @access public
+ * @param integer $comment_id Comment id
+ * @return array
+ */
+ public function getById($comment_id)
+ {
+ return $this->db
+ ->table(self::TABLE)
+ ->columns(
+ self::TABLE.'.id',
+ self::TABLE.'.task_id',
+ self::TABLE.'.user_id',
+ self::TABLE.'.date',
+ self::TABLE.'.comment',
+ User::TABLE.'.username'
+ )
+ ->join(User::TABLE, 'id', 'user_id')
+ ->eq(self::TABLE.'.id', $comment_id)
+ ->findOne();
+ }
+
+ /**
+ * Get the number of comments for a given task
+ *
+ * @access public
+ * @param integer $task_id Task id
+ * @return integer
+ */
public function count($task_id)
{
return $this->db
@@ -35,13 +86,54 @@ class Comment extends Base
->count();
}
+ /**
+ * Save a comment in the database
+ *
+ * @access public
+ * @param array $values Form values
+ * @return boolean
+ */
public function create(array $values)
{
$values['date'] = time();
- return (bool) $this->db->table(self::TABLE)->save($values);
+ return $this->db->table(self::TABLE)->save($values);
+ }
+
+ /**
+ * Update a comment in the database
+ *
+ * @access public
+ * @param array $values Form values
+ * @return boolean
+ */
+ public function update(array $values)
+ {
+ return $this->db
+ ->table(self::TABLE)
+ ->eq('id', $values['id'])
+ ->update(array('comment' => $values['comment']));
+ }
+
+ /**
+ * Remove a comment
+ *
+ * @access public
+ * @param integer $comment_id Comment id
+ * @return boolean
+ */
+ public function remove($comment_id)
+ {
+ return $this->db->table(self::TABLE)->eq('id', $comment_id)->remove();
}
+ /**
+ * Validate comment creation
+ *
+ * @access public
+ * @param array $values Required parameters to save an action
+ * @return array $valid, $errors [0] = Success or not, [1] = List of errors
+ */
public function validateCreation(array $values)
{
$v = new Validator($values, array(
@@ -57,4 +149,25 @@ class Comment extends Base
$v->getErrors()
);
}
+
+ /**
+ * Validate comment modification
+ *
+ * @access public
+ * @param array $values Required parameters to save an action
+ * @return array $valid, $errors [0] = Success or not, [1] = List of errors
+ */
+ public function validateModification(array $values)
+ {
+ $v = new Validator($values, array(
+ new Validators\Required('id', t('This value is required')),
+ new Validators\Integer('id', t('This value must be an integer')),
+ new Validators\Required('comment', t('Comment is required'))
+ ));
+
+ return array(
+ $v->execute(),
+ $v->getErrors()
+ );
+ }
}