PublicationGrid.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2011 Lluis Turró Cutiller <http://www.turro.org/>
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
package  org.turro.publication.zul.ctrl;
 
import java.util.List;
import org.turro.string.Strings;
import org.turro.elephant.context.Application;
import org.turro.elephant.db.WhereClause;
import org.turro.i18n.I_;
import org.turro.jpa.Dao;
import org.turro.jpa.grid.RendererOnDemand;
import org.turro.publication.db.PublicationPU;
import org.turro.publication.entity.Publication;
import org.turro.publication.entity.PublicationCategory;
import org.turro.publication.zul.menu.PublicationMenu;
import org.turro.tags.Tags;
import org.turro.zkoss.grid.PagingGrid;
import org.turro.zkoss.label.LabelExtended;
import org.zkoss.zk.ui.Component;
import org.zkoss.zk.ui.event.Event;
import org.zkoss.zk.ui.event.EventListener;
import org.zkoss.zk.ui.event.Events;
import org.zkoss.zul.*;
 
public class PublicationGrid extends PagingGrid {
 
  private final Application app = Application.getApplication();
 
  public PublicationGrid() {
    addColumns();
    PublicationPU.convertUrls();
  }
 
  public void setValues(String idContact, boolean accepted, PublicationCategory category, String text) {
    addRows(idContact, accepted, category, text);
  }
  
  private void addColumns() {
    Columns cols = new Columns();
    cols.setSizable(true);
    cols.setMenupopup("auto");
    appendChild(cols);
 
    Column col = new Column(I_.get("Date"), null, "200px");
    cols.appendChild(col);
 
    col = new Column(I_.get("Author"), null, "250px");
    cols.appendChild(col);
 
    col = new Column(I_.get("Title"));
    cols.appendChild(col);
  }
 
  private void addRows(String idContact, boolean accepted, PublicationCategory category, String text) {
 
    setRowRenderer(new RendererOnDemand<Publication, Long>(() -> new PublicationPU()) {
      @Override
      protected void renderRow(Row row, final Publication publication) {
        fillRow(row, publication);
      }
    });
    
    List<Long> list = getPublicationIds(idContact, accepted, category, text);
    setModel(new ListModelList<Long>(list));
 
    setRowCount(list.size());
    
  }
 
  private void fillRow(Row row, final Publication publication) {
    row.setValign("top");
 
    LabelExtended lext = new LabelExtended();
    lext.setDate(publication.getDate());
    lext.setSclass("ldate");
    row.appendChild(lext);
 
    Label author = new Label(
            publication.getAuthor() + " (" +
            publication.getContactAuthor().getName() +
            ")");
    author.setSclass("lauthor");
    row.appendChild(author);
 
    Vbox vbox = new Vbox();
    Label title = new Label(
            Strings.isBlank(publication.getUnescapedTitle()) ?
              I_.get("No description!") :
              publication.getUnescapedTitle());
    if(app.isInRole("publication:edit")) {
      title.addEventListener(Events.ON_CLICK, new EventListener() {
        @Override
        public void onEvent(Event event) throws Exception {
          PublicationMenu.showPublication(publication.getId());
        }
      });
      title.setStyle("cursor:pointer");
    }
    title.setSclass("ltitle");
    vbox.appendChild(title);
 
    lext = new LabelExtended();
    lext.setStyle("color:#444;font-size:11px;");
    lext.setValue(
            publication.getPublicationCategory().getName() +
            " | " +
            publication.getPublicationGroup().getName()
            );
 
    vbox.appendChild(lext);
 
    vbox.appendChild((Component) Tags.getControl(publication));
 
    row.appendChild(vbox);
  }
 
  private List<Long> getPublicationIds(String idContact, boolean accepted, PublicationCategory category, String text) {
    Dao dao = new PublicationPU();
    return dao.getResultList(createPublicationCriteria(idContact, accepted, category, text));
  }
  
  public static WhereClause createPublicationCriteria(String idContact, boolean accepted, PublicationCategory category, String text) {
    WhereClause wc = new WhereClause();
    wc.addClause("select publication from Publication publication");
    wc.addClause("where publication.accepted = :accepted");
    wc.addNamedValue("accepted", accepted);
    if(category != null) {
      wc.addClause("and publication.publicationCategory = :category");
      wc.addNamedValue("category", category);
    }
    if(idContact != null) {
      wc.addClause("and publication.idContact = :idContact");
      wc.addNamedValue("idContact", idContact);
    }
    if(!Strings.isBlank(text)) {
      text = "*" + text + "*";
      wc.addClause("and (publication.title like :text1");
      wc.addNamedValue("text1", text.replaceAll("\\*", "%"));
      wc.addClause("or publication.summary like :text2)");
      wc.addNamedValue("text2", text.replaceAll("\\*", "%"));
    }
    wc.addClause("order by publication.date DESC");
    return wc;
  }
 
}