package org.paneris.bibliomania;

 import java.io.File;

 import java.util.Enumeration;

 import org.melati.Melati;

 import org.melati.admin.AdminSpecialised;

 import org.melati.poem.CachedTailoredQuery;

 import org.melati.poem.Column;

 import org.melati.poem.Table;

 import org.melati.template.MarkupLanguage;

 import org.melati.poem.util.ArrayUtils;

 import org.melati.poem.util.EmptyEnumeration;

 import org.melati.poem.util.MappedEnumeration;

 import org.melati.poem.Treeable;

 import org.paneris.bibliomania.generated.SectionBase;

 public class Section extends SectionBase implements AdminSpecialised {

   public Enumeration getProductAssociations() {

     return new EmptyEnumeration();

   }

   public String getMetatag_description() {

     return null;

   }

   public String getMetatag_keywords() {

     return null;

   }

   public long ftiTextID_start() {

     return Chapter.ftiTextID(troid().intValue(), 0, 0, 0);

   }

   public long ftiTextID_limit() {

     return ftiTextID_start() | ((1L << Chapter.ftiTextID_section_shift) - 1);

   }

   public Unit getParentUnit() {

     return getGroup();

   }

   public void appendCacheSubpath(StringBuffer buffer) {

     buffer.append("/s/");

     buffer.append(troid());

   }

   public void encache() throws Exception {

     super.encache();

     getBibliomaniaDatabase().interpolateTemplateToFile(

       "read/Section.wm",

       new File(getCachePath(), "index.html"),

       this);

   }

   private CachedTailoredQuery authorsWithBooks = null;

   public Enumeration getAuthorsWithBooks() {

     BibliomaniaDatabase db = getBibliomaniaDatabase();

     final Table authorTable = db.getAuthorTable();

     final Table bookTable = db.getBookTable();

     if (authorsWithBooks == null) {

       authorsWithBooks =

         new CachedTailoredQuery(

           "DISTINCT",

           new Column[] { authorTable.troidColumn()},

           new Table[] { bookTable},

           bookTable.quotedName() + ".author = " + 

           authorTable.quotedName() + ".id AND " + 

           bookTable.quotedName() + ".section = " + troid(),

           null);

     }

     return new MappedEnumeration(authorsWithBooks.selection_firstRaw()) {

       public Object mapped(Object troid) {

         return authorTable.getObject((Integer)troid);

       }

     };

   }

   public Enumeration getBooksSlowly() {

     return getBibliomaniaDatabase()

       .getBookTable()

       .getSectionColumn()

       .selectionWhereEq(troid());

   }

   public String getDisplayName() {

     return getDisplayname();

   }

   public Enumeration getMembersSlowly() {

     return getBooksSlowly();

     // return getAuthorsWithBooks();

   }

   public String adminHandle(Melati melati, MarkupLanguage markupLanguage)

     throws Exception {

     return null;

   }

   public String adminSpecialFacilities(

     Melati melati,

     MarkupLanguage markupLanguage)

     throws Exception {

     return getBibliomaniaDatabase().getWMTemplet("Section-specials");

   }

   public SectionGroup getReadArea() {

     return getGroup();

   }

   public Advert getAdvert() {

     Advert a = null;

     return a;

   }

   /*

     We want layouts at the section level now

     public Layout getLayout() {

         Layout l = null;

       return l;

     }

   */

   /* 

    * @see org.melati.util.Treeable#getChildren()

    */

   public Treeable[] children = null;

   public Treeable[] getChildren() {

     if (children == null) {

       Object[] kids = ArrayUtils.arrayOf(getAuthorsWithBooks());

       children = new Treeable[kids.length];

       for (int i=0; i<kids.length; i++) {

         children[i] = (Treeable)kids[i];

       }

     }

     return children;

   }

   /* 

    * @see org.melati.util.Treeable#getName()

    */

   public String getName() {

     return getDisplayName();

   }

 }