PHP Track::structureData方法代码示例

 /**
  * Returns a specific user's track by it sequence number.
  *
  * @return mixed|bool track on success, or false on error.
  */
 public function get()
 {
     require_once $_SERVER['DOCUMENT_ROOT'] . '/server/lib/Track.php';
     require_once $_SERVER['DOCUMENT_ROOT'] . '/server/lib/DatabaseConnection.php';
     $connection = new DatabaseConnection();
     $query = $connection->prepare('SELECT `track`.`id`, `track`.`title`, `track`.`artist`, `artist`.`name` AS `artistName`, `track`.`album`, `album`.`name` AS `albumName`, `track`.`id` AS `file`, `playlist`.`userId` , `playlist`.`sequence`, `cover`.`albumId` AS `coverId` FROM `track`, `artist`, `playlist`, `album` LEFT JOIN `cover` ON `album`.`id`=`cover`.`albumId` AND `cover`.`status` = 1 WHERE `track`.`artist`=`artist`.`id` AND `track`.`album`=`album`.`id` AND `track`.`id`=`playlist`.`id` AND `playlist`.`userId`=:userId AND `playlist`.`sequence`=:sequence LIMIT 1;');
     $query->bindValue(':userId', $this->userId, PDO::PARAM_INT);
     $query->bindValue(':sequence', $this->sequence, PDO::PARAM_INT);
     $query->execute();
     $query->setFetchMode(PDO::FETCH_INTO, $this);
     if ($query->fetch()) {
         $trackStructured = new Track();
         //returns structured track
         return $trackStructured->structureData($this);
     }
     //returns false to indicate there is no such a track for this user
     return false;
 }

 /**
  * Scan the specified folder and subfolders, insert in the library the files found.
  *
  * @param string $folder Root folder to scan
  *
  * @return array Tracks inserted
  */
 public function addFiles($folder)
 {
     require_once $_SERVER['DOCUMENT_ROOT'] . '/server/lib/Artist.php';
     require_once $_SERVER['DOCUMENT_ROOT'] . '/server/lib/Album.php';
     $result = array();
     $this->scanFolders($folder, $this->folders);
     foreach ($this->files as $file) {
         //reset timeout for 20 seconds before processing each file
         set_time_limit(20);
         $track = new Track();
         $track->file = $file;
         $trackInfo = $track->readId3();
         if (key_exists('comments_html', $trackInfo)) {
             //ID3 has been found, we can use it
             if (key_exists('title', $trackInfo['comments_html'])) {
                 $track->title = $trackInfo['comments_html']['title'][0];
             }
             if (key_exists('album', $trackInfo['comments_html'])) {
                 $track->albumName = $trackInfo['comments_html']['album'][0];
             }
             if (key_exists('artist', $trackInfo['comments_html'])) {
                 $track->artistName = $trackInfo['comments_html']['artist'][0];
             }
             if (key_exists('track_number', $trackInfo['comments_html'])) {
                 $track->track = intval($trackInfo['comments_html']['track_number'][0]);
             }
             if (key_exists('year', $trackInfo['comments_html'])) {
                 $track->year = intval($trackInfo['comments_html']['year'][0]);
             }
             if (key_exists('audio', $trackInfo) && key_exists('bitrate_mode', $trackInfo['audio'])) {
                 $track->mode = $trackInfo['audio']['bitrate_mode'];
             }
             if (key_exists('audio', $trackInfo) && key_exists('bitrate', $trackInfo['audio'])) {
                 $track->bitrate = intval($trackInfo['audio']['bitrate']);
             }
             if (key_exists('playtime_seconds', $trackInfo)) {
                 $track->time = intval($trackInfo['playtime_seconds']);
             }
             if (key_exists('filesize', $trackInfo)) {
                 $track->size = intval($trackInfo['filesize']);
             }
         }
         if (!isset($track->title, $track->albumName, $track->artistName)) {
             //We use the filesystem pattern /path/artistName/albumName/title.ext
             $elements = explode('/', $file);
             $title = str_replace('-', ' ', str_replace('_', ' ', end($elements)));
             $albumName = str_replace('-', ' ', str_replace('_', ' ', prev($elements)));
             $artistName = str_replace('-', ' ', str_replace('_', ' ', prev($elements)));
             if (!isset($track->title)) {
                 $track->title = $title;
             }
             if (!isset($track->albumName)) {
                 $track->albumName = $albumName;
             }
             if (!isset($track->artistName)) {
                 $track->artistName = $artistName;
             }
         }
         //insert/update artist
         $artist = new Artist();
         $track->artist = $artist->insertIfRequired($track->artistName, null);
         //insert/update album
         $album = new Album();
         $track->album = $album->insertIfRequired($track->albumName, null, $track->artist);
         //insert track
         if ($track->insert()) {
             //add to the returned array
             array_push($result, $track->structureData($track));
         }
     }
     //return inserted files
     return $result;
 }

 /**
  * Get album tracks.
  *
  * @return mixed Array of album tracks or false on failure
  */
 public function getTracks()
 {
     require_once $_SERVER['DOCUMENT_ROOT'] . '/server/lib/Track.php';
     require_once $_SERVER['DOCUMENT_ROOT'] . '/server/lib/DatabaseConnection.php';
     $connection = new DatabaseConnection();
     $query = $connection->prepare('SELECT `track`.`id`, `track`.`track`, `track`.`title`, `track`.`time`, `track`.`artist`, `artist`.`name` AS `artistName` FROM `track` INNER JOIN `artist` ON `artist`.`id` = `track`.`artist` WHERE `track`.`album` = :albumId  ORDER BY `track`.`track` ASC;');
     $query->bindValue(':albumId', $this->id, PDO::PARAM_INT);
     if ($query->execute()) {
         $this->tracks = $query->fetchAll(PDO::FETCH_CLASS);
         foreach ($this->tracks as $track) {
             $trackStructured = new Track();
             $track = $trackStructured->structureData($track);
         }
         //return album tracks
         return $this->tracks;
     }
     //returns database was not reachable
     return false;
 }