<?php
  /**
  * Set up a list of the most recent unplayed tracks as a playlist
  */
  // Get a list of the most recent albums
  
  require_once( "forked_firefly_db.php" );
  $debug = false; 
  $ff = new ForkedFireflyDb();
  $ff->debug = $debug;
  $aAlbums = $ff->getUnplayedAlbums();
  $aTracks = array();
	foreach( $aAlbums as $row ){
    $sql = "
      SELECT track, artist, album, title, id, song_length, path
      FROM files 
      WHERE play_count = 0 
        and album like ".$ff->quote( $row["album"] )." 
        and path like ".$ff->quote( $row["path"].'%' );
    $ff->query($sql);
    if( $debug ) echo $row["artist"]." - ".$row["album"]."\n";
    while( $track = $ff->fetchRow() ){
      $aTracks[] = $track;
      if( $debug ) echo " - ".$track["id"].": ".$track["title"]."\n";
    }
  }

  usort( $aTracks, "trackCompare" );
  $aPaths = array();
  foreach( $aTracks as $track ){
    $aPaths[] = $track["path"];
  }

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

  function trackCompare( $a, $b ){
    if( $a["artist"] < $b["artist"] ) return 1;
    if( $a["artist"] > $b["artist"] ) return -1;
    if( $a["album"] < $b["album"] ) return 1;
    if( $a["album"] > $b["album"] ) return -1;
    if( $a["track"] == $b["track"] ) return 0;
    return $a["track"] < $b["track"] ? -1 : 1;
  }
?>