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();
   }
 
 
 }