package org.paneris.bibliomania;
   
   import java.util.Enumeration;
   
   import org.melati.Melati;
   import org.melati.admin.AdminSpecialised;
   import org.melati.poem.CachedSelection;
   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.SectionGroupBase;
  
  public class SectionGroup
    extends SectionGroupBase
    implements AdminSpecialised {
  
    public SectionGroup() {
    }
  
    private CachedSelection sections = null;
  
    private boolean generic() {
      Boolean genericL = getGeneric();
      return genericL != null && genericL.booleanValue();
    }
  
    public Enumeration getSections() {
      if (getTroid() == null)
        return new EmptyEnumeration();
  
      if (generic())
        return getBibliomaniaDatabase().getSectionTable().selection();
  
      if (sections == null)
        sections =
          getBibliomaniaDatabase()
            .getSectionTable()
            .getGroupColumn()
            .cachedSelectionWhereEq(troid());
  
      return sections.objects();
    }
  
    public Enumeration getProductAssociations() {
      return new EmptyEnumeration();
    }
  
    public String getMetatag_description() {
      return null;
    }
  
    public String getMetatag_keywords() {
      return null;
    }
  
    public Enumeration getMembersSlowly() {
      return getSections();
    }
  
    public Unit getParentUnit() {
      return null;
    }
  
    public String getDisplayName() {
      return getDisplayname();
    }
  
    public void appendCacheSubpath(StringBuffer buffer) {
      buffer.append("/g/");
      buffer.append(troid());
    }
  
    public boolean contains(Section section) {
      return generic() || section.getGroup() == this;
    }
  
    /**
     * FIXME
     */
  
    public long ftiTextID_start() {
      return 0;
    }
  
    /**
     * FIXME
     */
  
    public long ftiTextID_limit() {
      return Long.MAX_VALUE;
    }
  
    private CachedTailoredQuery authorsWithBooks = null;
  
   public Enumeration getAuthorsWithBooks() {
     BibliomaniaDatabase b = getBibliomaniaDatabase();
 
     if (generic())
       return b.getAuthorTable().selection();
 
     if (authorsWithBooks == null) {
       authorsWithBooks =
         new CachedTailoredQuery(
           "DISTINCT",
           new Column[] { b.getAuthorTable().troidColumn()},
           new Table[] { b.getBookTable(), b.getSectionTable()},
           "book.author = author.id AND book.section = section.id AND "
             + "section.\"group\" = "
             + troid(),
           null);
     }
 
     final Table authorTable = b.getAuthorTable();
     return new MappedEnumeration(authorsWithBooks.selection_firstRaw()) {
       public Object mapped(Object troid) {
         return authorTable.getObject((Integer)troid);
       }
     };
   }
 
   public SectionGroup getReadArea() {
     return this;
   }
 
   public Advert getAdvert() {
     Advert a = null;
     return a;
   }
   public Layout getLayout() {
     Layout l = null;
     return l;
   }
 
   public String adminHandle(
     Melati melatiContext,
     MarkupLanguage markupLanguage)
     throws Exception {
     return null;
   }
 
   public String adminSpecialFacilities(
     Melati melatiContext,
     MarkupLanguage markupLanguage)
     throws Exception {
     return getBibliomaniaDatabase().getWMTemplet("SectionGroup-specials");
   }
   
   /* 
    * @see org.melati.util.Treeable#getChildren()
    */
    public Treeable[] children = null;
    
    public Treeable[] getChildren() {
      if (children == null) {
        Object[] kids = ArrayUtils.arrayOf(getSections());
        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();
   }
 
 
 }