X-Git-Url: http://p2p-next.cs.pub.ro/gitweb/?a=blobdiff_plain;f=application%2Fmodels%2Fvideos_model.php;h=da7cdfe6b174ef1020fe98ad06f7ba369522b13e;hb=faf92fa039c2be353c94d0d0e8e488e56eaa5058;hp=6a06e1c6ffaa3ff7d536569cb40113c82ad5d95f;hpb=37fe2e29a60066614f4155c292e2a2bd99b71b49;p=living-lab-site.git

diff --git a/application/models/videos_model.php b/application/models/videos_model.php
index 6a06e1c..da7cdfe 100644
--- a/application/models/videos_model.php
+++ b/application/models/videos_model.php
@@ -44,7 +44,7 @@ class Videos_model extends CI_Model {
 	 *   <li>id, name, title, duration, thumbs_count, default_thumb, views => from DB</li>
 	 *   <li>shorted_title => ellipsized title</li>
 	 *   <li>video_url => P2P-Tube video URl</li>
-	 *   <li>TODO: user_id, user_name</li>
+	 *   <li>user_id, user_name</li>
 	 *   <li>thumbs => thumbnail images' URLs</li>
 	 * </ul>
 	 */
@@ -129,7 +129,7 @@ class Videos_model extends CI_Model {
 	 * 
 	 * @param int $category_id
 	 * @param mixed $user	an user_id (as int) or an username (as string)
-	 * @return int	number of videos or NULL if an error occured
+	 * @return int	number of videos or FALSE if an error occured
 	 */
 	public function get_videos_count($category_id = NULL, $user = NULL)
 	{
@@ -157,7 +157,7 @@ class Videos_model extends CI_Model {
 			return $query->row()->count;
 		
 		// Error
-		return NULL;
+		return FALSE;
 	}
 	
 	/**
@@ -179,7 +179,7 @@ class Videos_model extends CI_Model {
 	 * video asset having keys: "src", "res", "par" and "ext". Value of key
 	 * "src" is the video torrent formated as
 	 * {name}_{format}.{video_ext}.{default_torrent_ext}</li>
-	 *   <li>user_name => TODO: user name from `users` table</li>
+	 *   <li>username => user name from `users` table</li>
 	 *   <li>category_title => a human-friendly category name</li>
 	 *   <li>tags => associative list of "tag => score"</li>
 	 *   <li>date => date and time when the video was created</li>
@@ -190,9 +190,9 @@ class Videos_model extends CI_Model {
 	{
 		$this->load->helper('video');
 		
-		$query = $this->db->query('SELECT * 
-								FROM `videos` 
-								WHERE id = ?', $id);
+		$query = $this->db->query("SELECT v.*, u.username 
+								FROM `videos` v, `users` u
+								WHERE v.user_id = u.id AND v.id = $id");
 		$video = array();
 		
 		if ($query->num_rows() > 0)
@@ -239,27 +239,140 @@ class Videos_model extends CI_Model {
 		// Thumbnails
 		$video['thumbs'] = $this->get_thumbs($video['name'], $video['thumbs_count']);
 		
-		// TODO: user information
-		$video['user_name'] = 'TODO';
-		
 		return $video;
 	}
 	
 	/**
-	 * Increment a video parameter from DB: `views`, `likes` or `dislikes`.
+	 * Retrieves comments for a video.
+	 * 
+	 * @param int $video_id
+	 * @param int $offset
+	 * @param int $count
+	 * @param string $ordering	control comments ording by these possibilities:
+	 * <ul>
+	 *   <li><strong>'hottest':</strong> newest most appreciated first. An
+	 *   appreciated comment is one which has a bigger
+	 *   score = likes - dislikes.</li>
+	 *   <li><strong>'newest':</strong> newest first.</li>
+	 * </ul>
+	 * @return array	an array with comments
+	 */
+	public function get_video_comments($video_id, $offset, $count,
+			$ordering = 'newest')
+	{
+		// Ordering
+		switch ($ordering)
+		{
+		case 'newest':
+			$order_statement = "ORDER BY time DESC";
+			break;
+		case 'hottest':
+			$order_statement = "ORDER BY time DESC, score DESC";
+			break;
+				
+		default:
+			$order_statement = "";
+		}
+		
+		$query = $this->db->query(
+			"SELECT c.*, u.username, (c.likes + c.dislikes) AS score
+				FROM `videos_comments` c, `users` u
+				WHERE c.user_id = u.id AND video_id = $video_id
+				$order_statement");
+		
+		if ($query->num_rows() == 0)
+			return array();
+		
+		$comments = $query->result_array();
+		
+		return $comments;
+	}
+	
+	public function get_video_comments_count($video_id)
+	{
+		$query = $this->db->query(
+					"SELECT COUNT(*) count
+						FROM `videos_comments`
+						WHERE video_id = $video_id");
+				
+		if ($query->num_rows() == 0)
+			return FALSE;
+		
+		return $query->row()->count;
+	}
+	
+	/**
+	 * Insert in DB a comment for a video.
+	 * 
+	 * @param int $video_id
+	 * @param int $user_id
+	 * @param string $content
+	 */
+	public function comment_video($video_id, $user_id, $content)
+	{
+		return $query = $this->db->query(
+			"INSERT INTO `videos_comments` (video_id, user_id, content, time)
+			VALUES ($video_id, $user_id, '$content', UTC_TIMESTAMP())");
+	}
+	
+	/**
+	 * Increments views count for a video.
 	 * 
 	 * @param int $id	DB video id
-	 * @param string $param	DB parameter column name.
 	 * @return void
 	 */
-	public function inc_video_var($id, $var)
+	public function inc_views($id)
 	{
-		// TODO error report if query returns FALSE
-		$this->db->query('UPDATE `videos` '
-						. 'SET `'. $var. '`=`'. $var. '`+1 '
+		return $this->db->query('UPDATE `videos` '
+						. 'SET `views`=`views`+1 '
 						. 'WHERE id='. $id); 
 	}
 	
+	public function vote($video_id, $user_id, $like = TRUE)
+	{
+		if ($like)
+		{
+			$col = 'likes';
+			$action = 'like';
+		}
+		else
+		{
+			$col = 'dislikes';
+			$action = 'dislike';
+		}
+		
+		$query = $this->db->query("SELECT * FROM `users_actions`
+			WHERE user_id = $user_id
+				AND target_id = $video_id
+				AND target_type = 'video'
+				AND action = '$action'
+				AND date = CURDATE()");
+		// User already voted today
+		if ($query->num_rows() > 0)
+			return -1;
+		
+		$this->db->query("UPDATE `videos`
+			SET $col = $col + 1
+			WHERE id = $video_id");
+		
+		// Mark this action so that the user cannot repeat it today.
+		$this->db->query("INSERT INTO `users_actions`
+				(user_id, action, target_type, target_id, date)
+			VALUES ( $user_id, '$action', 'video', $video_id, CURDATE() )");
+		
+		$query = $this->db->query("SELECT $col FROM `videos`
+			WHERE id = $video_id");
+		
+		if ($query->num_rows() === 1)
+		{
+			$row = $query->row_array();
+			return $row[ $col ];
+		}
+		
+		// Error
+		return FALSE;
+	}
+	
 	public function get_thumbs($name, $count)
 	{
 		$thumbs = array();