PHP Album::getId方法代码示例

 /**
  * Add an Album to the database or get its key if it exists
  * @param name str: the name of the album to add
  * @return     int: the primary key added or found
  */
 public function addAlbum($name)
 {
     //is this name already in the collection?
     $q = Doctrine_Query::create()->select('a.id')->from('Album a')->where('a.name = ?', $name);
     $result = $q->fetchOne();
     if (is_object($result) && $result->id > 0) {
         $retId = $result->id;
         unset($q, $result);
         return (int) $retId;
     } else {
         $item = new Album();
         $item->name = $name;
         if ($name == 'Unknown Album') {
             $item->has_art = 1;
             //there's no point scanning an unknown album for art
         }
         $item->scan_id = 1;
         $item->save();
         $id = $item->getId();
         $item->free();
         unset($item, $q, $result);
         return (int) $id;
     }
 }

 /**
  * Return the count position of a Photo relative to the position in an Album
  *
  * @access public
  * @param Photo $photo Current photo
  * @param Album $album
  * @param array $options (Optional) Read documentation on parseOptions for details
  * @return int
  */
 public function countPosition(Photo $photo, Album $album, $options = null)
 {
     $this->resetQueryStrings();
     $this->query_reset_lock = true;
     $this->query_where = "WHERE {$this->tableName}.id <= ? AND {$this->tableName}.albumId = ?";
     $this->query_params = array($photo->getId(), $album->getId());
     $this->query_select = "COUNT({$this->columns[0]}) AS count";
     $result = $this->count($options);
     $this->query_reset_lock = false;
     return $result;
 }

 public function run()
 {
     // first of all - try to guess if this dir should be
     // treated as an album or as a bunch of loose tracks
     // further this method is adding score to several attributes which will be migrated to production db-table
     $this->setHandleAsAlbum();
     #print_r($this->r);
     cliLog("handleAsAlbumScore " . $this->handleAsAlbumScore, 3, 'purple');
     #die();
     #if($this->tracks[0]['relativePath'] == 'newroot/crse002cd--Calibre-Musique_Concrete-2CD-CRSE002CD-2001-sour/101-calibre-deep_everytime.mp3') {
     #print_r($this->r); die();
     #}
     // extract some attributes from tracks
     // those will be used for album stuff
     $mergedFromTracks = array('artist' => array(), 'genre' => array(), 'label' => array(), 'catalogNr' => array());
     foreach (array_keys($mergedFromTracks) as $what) {
         foreach ($this->tracks as $idx => $rawTagData) {
             $mergedFromTracks[$what][] = $this->getMostScored($idx, $what);
         }
         $mergedFromTracks[$what][] = $this->getMostScored('album', $what);
         $mergedFromTracks[$what] = join(',', array_unique($mergedFromTracks[$what]));
     }
     $albumArtists = count(trimExplode(",", $mergedFromTracks['artist'])) > 3 ? 'Various Artists' : $mergedFromTracks['artist'];
     $a = new Album();
     $a->setArtistId(join(",", Artist::getIdsByString($albumArtists)));
     $a->setGenreId(join(",", Genre::getIdsByString($mergedFromTracks['genre'])));
     #$a->setLabelId(join(",", Label::getIdsByString($mergedFromTracks['label'])));
     $a->setCatalogNr($this->mostScored['album']['catalogNr']);
     $a->setRelativePath($this->getRelativeDirectoryPath());
     $a->setRelativePathHash($this->getRelativeDirectoryPathHash());
     $a->setAdded($this->getDirectoryMtime());
     $a->setFilemtime($this->getDirectoryMtime());
     $a->setTitle($this->mostScored['album']['title']);
     $a->setYear($this->mostScored['album']['year']);
     $a->setIsJumble($this->handleAsAlbum === TRUE ? 0 : 1);
     $a->setTrackCount(count($this->tracks));
     #print_r($a); die();
     $a->update();
     $albumId = $a->getId();
     // add the whole bunch of valid and indvalid attributes to albumindex table
     $this->updateAlbumIndex($albumId);
     foreach ($this->tracks as $idx => $rawTagData) {
         $t = $this->migrateNonGuessableData($rawTagData);
         $t->setArtistId($this->mostScored[$idx]['artist']);
         // currently the string insted of an artistId
         $t->setTitle($this->mostScored[$idx]['title']);
         $t->setFeaturedArtistsAndRemixers();
         # setFeaturedArtistsAndRemixers() is processing:
         # $t->setArtistId();
         # $t->setFeaturingId();
         # $t->setRemixerId();
         $t->setGenreId(join(",", Genre::getIdsByString($this->getMostScored($idx, 'genre'))));
         $t->setLabelId(join(",", Label::getIdsByString($this->getMostScored($idx, 'label'))));
         $t->setCatalogNr($this->mostScored[$idx]['catalogNr']);
         $t->setDisc($this->mostScored[$idx]['disc']);
         $t->setNumber($this->mostScored[$idx]['number']);
         $t->setComment($this->mostScored[$idx]['comment']);
         $t->setYear($this->mostScored[$idx]['year']);
         $t->setAlbumId($albumId);
         // make sure to use identical ids in table:rawtagdata and table:track
         \Slimpd\Track::ensureRecordIdExists($t->getId());
         $t->update();
         // make sure extracted images will be referenced to an album
         \Slimpd\Bitmap::addAlbumIdToTrackId($t->getId(), $albumId);
         #
         // add the whole bunch of valid and indvalid attributes to trackindex table
         $this->updateTrackIndex($t->getId(), $idx);
     }
     unset($this->r['album']);
     if ($this->handleAsAlbum === TRUE) {
         // try to guess if all tracks of this album has obviously invalid fixable attributes
     }
     return;
     print_r($this->r);
     #die();
 }

             $log->add("ERROR saving artist");
         }
     }
 }
 // *************************
 // *************************
 // OBTENGO DATOS DEL ALBUM
 $log->add("getting album id...");
 if ($artistId != NULL) {
     $album = new Album("brasil");
     $log->add("searching db for icpn=" . $track->getIcpn());
     $album->loadFromIcpn($dbc, $track->getIcpn());
     // veo si ya esta ingresado en la db
     if ($album->getMaches() == "1") {
         // ya esta ingresado, obtengo id
         $albumId = $album->getId();
         $log->add("found album={$albumId}");
     } else {
         $log->add("album not found");
         $log->add("fetching album info for icpn=" . $track->getIcpn());
         $album->setArtistId($artistId);
         $album->fetchXML($track->getIcpn(), $log);
         $savedAlbum = $album->save($dbc, "albums");
         if ($savedAlbum === TRUE) {
             $albumId = $album->getId();
         } else {
             $albumId = NULL;
             $log->add("ERROR saving album");
         }
     }
 }

 public function getNextAlbum(Album $album, $myMemberId)
 {
     $q = $this->createQuery()->andWhere('member_id = ?', $album->getMemberId())->andWhere('id > ?', $album->getId())->orderBy('id ASC');
     $this->addPublicFlagQuery($q, $this->getPublicFlagByMemberId($album->getMemberId(), $myMemberId));
     return $q->fetchOne();
 }

 /**
  * Picks from database albums with same album artist.
  * Used in /album/templates/showSuccess
  *
  * @param Album $album ex: Gone in 60 seconds
  * @return Array(Album)
  */
 public static function getOtherAlbums($album)
 {
     $q = Doctrine_Query::create()->select('DISTINCT a.id')->from('Album a')->where('a.album_artist = ?', $album->getAlbumArtist())->andwhere('a.id != ?', $album->getId())->orderBy('a.title ASC');
     return $q->execute();
 }

 /**
  * Load all instances of Album entities from the database except for the album passed.
  * Exclusion is based on album id
  *
  * @access public
  * @param Album $album
  * @param array $options (Optional) Read documentation on parseOptions for details
  * @return array
  */
 public function allExclude(Album $album, $options = null)
 {
     $this->resetQueryStrings();
     $this->query_reset_lock = true;
     $this->query_where = "WHERE " . $this->getTableName() . ".id != ?";
     $this->query_params = array($album->getId());
     $result_array = $this->all($options);
     $this->query_reset_lock = false;
     return $result_array;
 }

 /**
  * Ensure the album cache ($this->albums) is filled with albums of this library
  */
 protected function ensureAlbums()
 {
     if (is_null($this->albums)) {
         $this->albums = array();
         foreach ($this->data['List of Albums'] as &$albumData) {
             $album = new Album($this, $albumData);
             $this->albums[$album->getId()] = $album;
         }
     }
 }

 public static function storeArtworkFromAPI($album, $size = "mega")
 {
     $db = $_SESSION['db'];
     $album = new Album($album);
     $artist = $album->getMainArtist();
     $artist_name = strtr($artist->getName(), array('.' => '', ',' => ''));
     $album_name = strtr($album->getName(), array('.' => '', ',' => ''));
     if (file_put_contents("img/albums/" . $album->getId() . ".jpg", file_get_contents(LastFMArtwork::getArtwork(utf8_encode($artist_name), utf8_encode($album_name), true, $size)))) {
         return true;
     }
     return false;
 }

 public function selectFeaturedImageForAlbumQuery(Album $album)
 {
     return "select images.* from images join albums on images.id=albums.featuredimageid where albums.id={$album->getId()} limit 1";
 }