<?php
  /**
  * Set up a list of the most recent unplayed tracks as a playlist
  */
  // Get a list of the most recent albums
  
  require_once( "firefly_db.php" );
  
  $ff = new FireflyDb();
  $sql = "
    select time_added, album, artist, path 
    from songs where play_count = 0 
      and path not like '%_podcasts%' 
      and album not like '' 
      and artist not like '' 
    group by album 
    order by time_added desc, artist, album 
    limit 10;";

  $debug = false;

  // Output the folder location of each of the last 5 albums - plain text only is needed
  $aAlbums = array();
  $ff->query( $sql );
  while( $row = $ff->fetchRow() ){
    $aAlbums[] = $row;
  }
  $aTracks = array();
  foreach( $aAlbums as $row ){
    $a = split( "/", $row["path"] );
    array_pop( $a );
    $path = join( "/", $a );
    $sql = "
      SELECT track, artist, album, title, id, song_length 
      FROM songs 
      WHERE play_count = 0 
        and album like ".$ff->quote( $row["album"] )." 
        and path like '".$path."%'
      order by track, artist, title";
    $ff->query($sql);
    if( $debug ) echo $row["artist"]." - ".$row["album"]."\n";
    while( $track = $ff->fetchRow() ){
      $aTracks[] = $track["id"];
      if( $debug ) echo " - ".$track["title"]."\n";
    }
  }

  if( sizeof( $aTracks ) > 0 ){
    $ff->savePlaylist( "Recent Unplayed Albums", $aTracks );
  }

?>