package org.musicontroller.gui.statistics;
   
   import java.util.Date;
   import java.util.HashMap;
   import java.util.LinkedList;
   import java.util.List;
   import java.util.Map;
   
   import org.apache.tapestry.IExternalPage;
  import org.apache.tapestry.IRequestCycle;
  import org.apache.tapestry.html.BasePage;
  import org.musicontroller.core.Event;
  import org.musicontroller.dao.Dao;
  import org.musicontroller.dao.PlaylistKey;
  import org.musicontroller.security.User;
  import org.varienaja.util.DateTools;
  
  /**
   * This screen displays some numbers about the objects in
   * the MusiController database.
   * 
   * @author deksels
   * @version $Id: Database.java,v 1.1 2010/03/16 18:55:42 varienaja Exp $
   */
  public abstract class Database extends BasePage implements IExternalPage {
  
  	public abstract Dao getDao();
  	public abstract User getUser();
  
  	public abstract Object[] getMonth();
  	public abstract void setMonth(Object[] month);
  	
  	public int songCount;
  
  	/**
  	 * Returns the number of bands in the database.
  	 * @return The number of bands in the database.
  	 */
  	public int getBandCount() {
  		try {
  			return getDao().count("select count(band) from Band band", null);
  		} catch (Exception e) {
  			return 0;
  		}
  	}
  	
  	/**
  	 * Returns the number of playlists in the database.
  	 * @return The number of playlists in the database.
  	 */
  	public int getPlaylistCount() {
  		try {
  			return getDao().count("select count(playlist) from Playlist playlist", null);
  		} catch (Exception e) {
  			return 0;
  		}
  	}
  	
  	/**
  	 * Returns the number of songs in the database.
  	 * @return The number of songs in the database.
  	 */
  	public int getSongCount() {
  		try {
  			return getDao().count("select count(song) from Song song", null);
  		} catch (Exception e) {
  			return 0;
  		}
  	}
  	
  	/**
  	 * Returns the number of keywords in the database.
  	 * @return The number of keywords in the database.
  	 */
  	public int getKeywordCount() {
  		try {
  			return getDao().count("select count(kw) from Keyword kw", null);
  		} catch (Exception e) {
  			return 0;
  		}
  	}
  	
  	/**
  	 * Returns the number of play events in the database.
  	 * @return The number of play events in the database.
  	 */
  	public int getPlayedEventCount() {
  		try {
  			Map<String, Object> params = new HashMap<String,Object>();
  			params.put("kind", Event.played);
  			return getDao().count("select count(ev) from Event ev where ev.eventkind=:kind", params);
  		} catch (Exception e) {
  			return 0;
  		}
  	}
  
  	/**
  	 * Returns the number of request events in the database.
  	 * @return The number of request events in the database.
 	 */
 	public int getRequestedEventCount() {
 		try {
 			Map<String, Object> params = new HashMap<String,Object>();
 			params.put("kind", Event.requested);
 			return getDao().count("select count(ev) from Event ev where ev.eventkind=:kind", params);
 		} catch (Exception e) {
 			return 0;
 		}
 	}
 
 	/**
 	 * Returns the number of skip events in the database.
 	 * @return The number of skip events in the database.
 	 */
 	public int getSkippedEventCount() {
 		try {
 			Map<String, Object> params = new HashMap<String,Object>();
 			params.put("kind", Event.skipped);
 			return getDao().count("select count(ev) from Event ev where ev.eventkind=:kind", params);
 		} catch (Exception e) {
 			return 0;
 		}
 	}
 
 	public void activateExternalPage(Object[] args, IRequestCycle cycle) {
 		//Nothing to do here
 	}
 
 	/**
 	 * @return A nice string, explaining the meaning of the green bar-statistic.
 	 */
 	public String getInsertedDescription() {
 		Object[] items = getMonth();
 		Date d = DateTools.encodeDate(1, Integer.parseInt(items[0].toString()), Integer.parseInt(items[1].toString()));
 		
 		return items[2] +" songs in the database in " +  DateTools.formatDate(d, "MMMMM yyyy");
 	}
 
 	/**
 	 * @return String representation of the month we're currently in, in the form
 	 * M
 	 */
 	public String getMonthIndicator() {
 		Object[] items = getMonth();
 		Date d = DateTools.encodeDate(1, Integer.parseInt(items[0].toString()), Integer.parseInt(items[1].toString()));
 		
 		return DateTools.formatDate(d, "MMM").substring(0,1);
 	}
 
 	/**
 	 * @return String representation of the month we're currently in, in the form
 	 * MMMMM yyyy
 	 */
 	public String getLongMonthIndicator() {
 		Object[] items = getMonth();
 		Date d = DateTools.encodeDate(1, Integer.parseInt(items[0].toString()), Integer.parseInt(items[1].toString()));
 		
 		return DateTools.formatDate(d, "MMMMM yyyy");
 	}
 
 	/**
 	 * @return String representation of the growth in the month we're currently in
 	 */
 	public String getInsertedSize() {
 		int sze = Integer.parseInt(getMonth()[2].toString());
 		
 		int pct = 200*sze / songCount;
 		
 		return Integer.toString(pct);
 	}
 	
 	public List<Object[]> getMonths() {
 		List<Object[]> months = getDao().listMonthlySongCounts();
 		List<Object[]> result = new LinkedList<Object[]>();
 		
 		int currentsize = 0;
 
 		if (months.size()>0) {
 			int currentMonth = (Integer) months.get(0)[0];
 			int currentYear = (Integer) months.get(0)[1];
 			
 			
 			for (Object[] item : months) {
 				while (!( 	(Integer) item[0]==currentMonth &&
 							(Integer) item[1]==currentYear)) {
 					String[] extra = new String[3];
 					extra[0] = Integer.toString(currentMonth);
 					extra[1] = Integer.toString(currentYear);
 					extra[2] = Integer.toString(currentsize);
 					result.add(extra);
 
 					currentMonth++;
 					if (currentMonth>12) {
 						currentMonth = 1;
 						currentYear++;
 					}
 				}
 				result.add(item);
 				
 				int growth = Integer.parseInt(item[2].toString());
 				currentsize += growth;
 				item[2] = Integer.toString(currentsize);
 				
 				currentMonth++;
 				if (currentMonth>12) {
 					currentMonth = 1;
 					currentYear++;
 				}
 			}
 			songCount = currentsize;
 		}
 		
 		return result;
 	}
 	
 	/**
 	 * Gets the usage statistics for a specific user.
 	 * @return The usage statistics.
 	 */
 	public Map<String, Integer> getUsageStatistics() {
 		return getDao().listMonthlyStatistics(getUser());
 	}
 	
 	/**
 	 * Returns the playlistId for a list of Songs inserted in the current month
 	 * @return The Playlist-Id.
 	 */
 	public long getInsertedIdThisMonth() {
 		Object[] items = getMonth();
 		return (new PlaylistKey(-2001,
 				DateTools.encodeDate(1, Integer.parseInt(items[0].toString()), 
 						                Integer.parseInt(items[1].toString())
 						               ))).getId();
 	}
 
 }