get_info($id); foreach ($info as $key=>$value) { $this->$key = $value; } // foreach info return true; } //constructor /** * construct_from_array * This is used by the metadata class specifically but fills out a Artist object * based on a key'd array, it sets $_fake to true */ public static function construct_from_array($data) { $artist = new Artist(0); foreach ($data as $key=>$value) { $artist->$key = $value; } //Ack that this is not a real object from the DB $artist->_fake = true; return $artist; } // construct_from_array /** * this attempts to build a cache of the data from the passed albums all in one query */ public static function build_cache($ids,$extra=false) { if(!is_array($ids) OR !count($ids)) { return false; } $idlist = '(' . implode(',', $ids) . ')'; $sql = "SELECT * FROM `artist` WHERE `id` IN $idlist"; $db_results = Dba::query($sql); while ($row = Dba::fetch_assoc($db_results)) { parent::add_to_cache('artist',$row['id'],$row); } // If we need to also pull the extra information, this is normally only used when we are doing the human display if ($extra) { $sql = "SELECT `song`.`artist`, COUNT(`song`.`id`) AS `song_count`, COUNT(DISTINCT `song`.`album`) AS `album_count`, SUM(`song`.`time`) AS `time` FROM `song` " . "WHERE `song`.`artist` IN $idlist GROUP BY `song`.`artist`"; $db_results = Dba::query($sql); while ($row = Dba::fetch_assoc($db_results)) { parent::add_to_cache('artist_extra',$row['artist'],$row); } } // end if extra return true; } // build_cache /** * get_from_name * This gets an artist object based on the artist name */ public static function get_from_name($name) { $name = Dba::escape($name); $sql = "SELECT `id` FROM `artist` WHERE `name`='$name'"; $db_results = Dba::query($sql); $row = Dba::fetch_assoc($db_results); $object = new Artist($row['id']); return $object; } // get_from_name /** * get_albums * gets the album ids that this artist is a part * of */ public function get_albums() { $results = array(); $sql = "SELECT `album`.`id` FROM album LEFT JOIN `song` ON `song`.`album`=`album`.`id` " . "WHERE `song`.`artist`='$this->id' GROUP BY `album`.`id` ORDER BY `album`.`name`,`album`.`disk`,`album`.`year`"; $db_results = Dba::query($sql); while ($r = Dba::fetch_assoc($db_results)) { $results[] = $r['id']; } return $results; } // get_albums /** * get_songs * gets the songs for this artist */ public function get_songs() { $sql = "SELECT `song`.`id` FROM `song` WHERE `song`.`artist`='" . Dba::escape($this->id) . "' ORDER BY album, track"; $db_results = Dba::query($sql); while ($r = Dba::fetch_assoc($db_results)) { $results[] = $r['id']; } return $results; } // get_songs /** * get_random_songs * Gets the songs from this artist in a random order */ public function get_random_songs() { $results = array(); $sql = "SELECT `id` FROM `song` WHERE `artist`='$this->id' ORDER BY RAND()"; $db_results = Dba::query($sql); while ($r = Dba::fetch_assoc($db_results)) { $results[] = $r['id']; } return $results; } // get_random_songs /** * _get_extra info * This returns the extra information for the artist, this means totals etc */ private function _get_extra_info() { // Try to find it in the cache and save ourselves the trouble if (parent::is_cached('artist_extra',$this->id)) { $row = parent::get_from_cache('artist_extra',$this->id); } else { $uid = Dba::escape($this->id); $sql = "SELECT `song`.`artist`,COUNT(`song`.`id`) AS `song_count`, COUNT(DISTINCT `song`.`album`) AS `album_count`, SUM(`song`.`time`) AS `time` FROM `song` " . "WHERE `song`.`artist`='$uid' GROUP BY `song`.`artist`"; $db_results = Dba::query($sql); $row = Dba::fetch_assoc($db_results); parent::add_to_cache('artist_extra',$row['artist'],$row); } /* Set Object Vars */ $this->songs = $row['song_count']; $this->albums = $row['album_count']; $this->time = $row['time']; return $row; } // _get_extra_info /** * format * this function takes an array of artist * information and reformats the relevent values * so they can be displayed in a table for example * it changes the title into a full link. */ public function format() { /* Combine prefix and name, trim then add ... if needed */ $name = truncate_with_ellipsis(trim($this->prefix . " " . $this->name),Config::get('ellipse_threshold_artist')); $this->f_name = $name; $this->f_full_name = trim($this->prefix . " " . $this->name); // If this is a fake object, we're done here if ($this->_fake) { return true; } $this->f_name_link = "id . "\" title=\"" . $this->full_name . "\">" . $name . ""; $this->f_link = Config::get('web_path') . '/artists.php?action=show&artist=' . $this->id; // Get the counts $extra_info = $this->_get_extra_info(); //Format the new time thingy that we just got $min = sprintf("%02d",(floor($extra_info['time']/60)%60)); $sec = sprintf("%02d",($extra_info['time']%60)); $hours = floor($extra_info['time']/3600); $this->f_time = ltrim($hours . ':' . $min . ':' . $sec,'0:'); return true; } // format /** * update * This takes a key'd array of data and updates the current artist * it will flag songs as neeed */ public function update($data) { // Save our current ID $current_id = $this->id; $artist_id = Catalog::check_artist($data['name']); // If it's changed we need to update if ($artist_id != $this->id) { $songs = $this->get_songs(); foreach ($songs as $song_id) { Song::update_artist($artist_id,$song_id); } $updated = 1; $current_id = $artist_id; Catalog::clean_artists(); } // end if it changed if ($updated) { foreach ($songs as $song_id) { Flag::add($song_id,'song','retag','Interface Artist Update'); Song::update_utime($song_id); } Catalog::clean_stats(); } // if updated return $current_id; } // update } // end of artist class ?>