democratic play on its way to being fixed, can add songs to a playlist, and view them ca not play it or delete/vote yet...

1 files changed, 117 insertions, 2 deletions

diff --git a/lib/class/democratic.class.php b/lib/class/democratic.class.php
index 276a74e1..78bf5fde 100644
--- a/lib/class/democratic.class.php
+++ b/lib/class/democratic.class.php
@@ -59,12 +59,127 @@ class Democratic extends tmpPlaylist {
 		// If not passed user global
 		$user_id = $user_id ? $user_id : $GLOBALS['user']->id; 
 
+		/* Find the - 1 one for now */
+		$sql = "SELECT `id` FROM `tmp_playlist` WHERE `session`='-1'"; 
+		$db_results = Dba::query($sql); 
+		$row = Dba::fetch_assoc($db_results); 
 
-		$object = new tmpPlaylist($playlist_id); 
+		$object = new Democratic($row['id']); 
 
 		return $object; 
 
-	} // get_playlist
+	} // get_current_playlist
+
+        /**
+         * get_items
+         * This returns an array of all object_ids currently in this tmpPlaylist. This
+         * has gotten a little more complicated because of type, the values are an array
+         * 0 being ID 1 being TYPE
+         */
+        public function get_items() {
+
+                $order          = "GROUP BY tmp_playlist_data.id ORDER BY `count` DESC, user_vote.date ASC";
+        	$vote_select = ", COUNT(user_vote.user) AS `count`";
+                $vote_join = "INNER JOIN user_vote ON user_vote.object_id=tmp_playlist_data.id";
+
+                /* Select all objects from this playlist */
+                $sql = "SELECT tmp_playlist_data.object_type, tmp_playlist_data.id, tmp_playlist_data.object_id $vote_select " .
+                        "FROM tmp_playlist_data $vote_join " .
+                        "WHERE tmp_playlist_data.tmp_playlist='" . Dba::escape($this->id) . "' $order";
+                $db_results = Dba::query($sql);
+
+                /* Define the array */
+                $items = array();
+                while ($results = Dba::fetch_assoc($db_results)) {
+                        $key            = $results['id'];
+                        $items[$key]    = array($results['object_id'],$results['object_type']);
+                }
+
+                return $items;
+
+        } // get_items
+
+
+	/**
+         * vote
+         * This function is called by users to vote on a system wide playlist
+         * This adds the specified objects to the tmp_playlist and adds a 'vote' 
+         * by this user, naturally it checks to make sure that the user hasn't
+         * already voted on any of these objects
+         */
+        public function vote($items) {
+
+                /* Itterate through the objects if no vote, add to playlist and vote */
+                foreach ($items as $type=>$object_id) {
+                        if (!$this->has_vote($object_id,$type)) {
+                                $this->add_vote($object_id,$this->id,$type);
+                        }
+                } // end foreach
+
+        } // vote
+
+        /**
+         * has_vote
+         * This checks to see if the current user has already voted on this object
+         */
+        public function has_vote($object_id,$type='') {
+
+                $tmp_id		= Dba::escape($this->id);
+		$object_id 	= Dba::escape($object_id); 
+		$type		= $type ? Dba::escape($type) : 'song'; 
+		$user_id	= Dba::escape($GLOBALS['user']->id); 
+
+                /* Query vote table */
+                $sql = "SELECT tmp_playlist_data.id FROM `user_vote` " .
+                        "INNER JOIN tmp_playlist_data ON tmp_playlist_data.id=user_vote.object_id " .
+                        "WHERE user_vote.user='$user_id' AND tmp_playlist_data.object_type='$type' " .
+                        "AND tmp_playlist_data.object_id='$object_id' " .
+                        "AND tmp_playlist_data.tmp_playlist='$tmp_id'";
+                $db_results = Dba::query($sql);
+
+                /* If we find  row, they've voted!! */
+                if (Dba::num_rows($db_results)) {
+                        return true;
+                }
+
+                return false;
+
+        } // has_vote
+
+        /**
+         * add_vote
+         * This takes a object id and user and actually inserts the row
+         */
+        public function add_vote($object_id,$tmp_playlist,$object_type='') {
+        
+                $object_id      = Dba::escape($object_id);
+                $tmp_playlist   = Dba::escape($tmp_playlist);
+		$object_type	= $object_type ? Dba::escape($object_type) : 'song'; 
+                
+                /* If it's on the playlist just vote */
+                $sql = "SELECT `id` FROM `tmp_playlist_data` " .
+                        "WHERE `tmp_playlist_data`.`object_id`='$object_id'";
+                $db_results = Dba::query($sql);
+
+                /* If it's not there, add it and pull ID */
+                if (!$results = Dba::fetch_assoc($db_results)) {
+                        $sql = "INSERT INTO `tmp_playlist_data` (`tmp_playlist`,`object_id`,`object_type`) " .
+                                "VALUES ('$tmp_playlist','$object_id','$object_type')";
+                        $db_results = Dba::query($sql);
+                        $results['id'] = Dba::insert_id();
+                }
+
+                /* Vote! */
+                $time = time();
+                $sql = "INSERT INTO user_vote (`user`,`object_id`,`date`) " .
+                        "VALUES ('" . Dba::escape($GLOBALS['user']->id) . "','" . $results['id'] . "','$time')";
+                $db_results = Dba::query($sql);
+
+                return true;
+
+        } // add_vote
+
+
 
 } // Democratic class
 ?>