NewsletterGrid.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2018 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.newsletter;
 
import java.util.List;
import org.turro.string.Strings;
import org.turro.action.queue.NotificationCategory;
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.Newsletter;
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.Column;
import org.zkoss.zul.Columns;
import org.zkoss.zul.Label;
import org.zkoss.zul.ListModelList;
import org.zkoss.zul.Row;
import org.zkoss.zul.Vlayout;
 
public class NewsletterGrid extends PagingGrid {
 
  private final Application app = Application.getApplication();
 
  public NewsletterGrid() {
    addColumns();
  }
 
  public void setValues(boolean accepted, NotificationCategory category, String text) {
    addRows(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("Title"));
    cols.appendChild(col);
  }
 
  private void addRows(boolean accepted, NotificationCategory category, String text) {
 
    setRowRenderer(new RendererOnDemand<Newsletter, Long>(() -> new PublicationPU()) {
      @Override
      protected void renderRow(Row row, final Newsletter newsletter) {
        fillRow(row, newsletter);
      }
    });
    
    List<Long> list = getNewsletterIds(accepted, category, text);
    setModel(new ListModelList<Long>(list));
 
    setRowCount(list.size());
    
  }
 
  private void fillRow(Row row, final Newsletter newsletter) {
    row.setValign("top");
 
    LabelExtended lext = new LabelExtended();
    lext.setDate(newsletter.getDate());
    lext.setSclass("ldate");
    row.appendChild(lext);
 
    Vlayout vbox = new Vlayout();
    Label title = new Label(
            Strings.isBlank(newsletter.getUnescapedTitle()) ?
              I_.get("No description!") :
              newsletter.getUnescapedTitle());
    if(app.isInRole("publication:edit")) {
      title.addEventListener(Events.ON_CLICK, new EventListener() {
        @Override
        public void onEvent(Event event) throws Exception {
          PublicationMenu.showNewsletter(newsletter.getId());
        }
      });
      title.setStyle("cursor:pointer");
    }
    title.setSclass("ltitle");
    vbox.appendChild(title);
 
    lext = new LabelExtended();
    lext.setStyle("color:#444;font-size:11px;");
    lext.setValue(I_.get(newsletter.getCategory().getCategory()));
 
    vbox.appendChild(lext);
 
//    TagItCtrl tagIt = Plugins.loadImplementation(TagItCtrl.class, "label");
//    tagIt.setEntity(newsletter);
//    if(tagIt instanceof AfterCompose) {
//      ((AfterCompose) tagIt).afterCompose();
//    }
    vbox.appendChild((Component) Tags.getControl(newsletter));
 
    row.appendChild(vbox);
  }
 
  private List<Long> getNewsletterIds(boolean accepted, NotificationCategory category, String text) {
    Dao dao = new PublicationPU();
    return dao.getResultList(createNewsletterCriteria(accepted, category, text));
  }
  
  public static WhereClause createNewsletterCriteria(boolean accepted, NotificationCategory category, String text) {
    WhereClause wc = new WhereClause();
    wc.addClause("select newsletter from Newsletter newsletter");
    wc.addClause("where newsletter.accepted = :accepted");
    wc.addNamedValue("accepted", accepted);
    if(category != null) {
      wc.addClause("and newsletter.idCategory = :category");
      wc.addNamedValue("category", category.getIdCategory());
    }
    if(!Strings.isBlank(text)) {
      text = "*" + text + "*";
      wc.addClause("and newsletter.title like :text1");
      wc.addNamedValue("text1", text.replaceAll("\\*", "%"));
      // missing sections body
    }
    wc.addClause("order by newsletter.date DESC");
    return wc;
  }
 
}