CrmCalendar.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2013 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.crm.command;
 
import java.util.Date;
import java.util.List;
import org.amic.util.date.CheckDate;
import org.turro.string.ObjectString;
import org.turro.string.Strings;
import org.turro.annotation.ElephantPlugin;
import org.turro.crm.db.CrmPU;
import org.turro.crm.entity.SaleAction;
import org.turro.crm.entity.Vendor;
import org.turro.crm.entity.VendorProspect;
import org.turro.jpa.Dao;
import org.turro.plugin.calendar.CalendarColor;
import org.turro.plugin.calendar.DefaultCalendarEvent;
import org.turro.plugin.command.CalendarPlugin;
import org.turro.plugin.contacts.IContact;
import org.turro.util.Chars;
import org.turro.util.PhraseBuilder;
 
@ElephantPlugin
public class CrmCalendar extends CalendarPlugin {
 
  @Override
  protected void executePlugin() {
    Dao dao = new CrmPU();
    Vendor vendor = (Vendor) dao.getSingleResultOrNull(
            "select v from Vendor v where v.idContact = ?", 
            new Object[] { getContact().getId() });
    if(vendor != null) {
      Date newFrom = new CheckDate(getFrom()).addDays(-7).getDate(),
           newTo = new CheckDate(getTo()).addDays(7).getDate();
      List<SaleAction> list = dao.getResultList(
              "select sa from SaleAction sa " +
              "where sa.vendorProspect.vendor = ? " +
              "and (" +
              "(sa.actionDate >= ? and sa.actionDate <= ?) " + 
              "or (sa.finalDate >= ? and sa.finalDate <= ?) " + 
              "or (sa.actionDate < ? and sa.finalDate > ?) " + 
              ")",
              new Object[] { vendor, 
                newFrom, newTo,
                newFrom, newTo,
                getFrom(), getTo()                
              });
      for(SaleAction sa : list) {
        DefaultCalendarEvent calendarEvent = new DefaultCalendarEvent();
        calendarEvent.setLocked(false);
        calendarEvent.setDone(sa.getStatus() > 0);
        if(sa.getStatus() > SaleAction.SA_PENDING) {
          calendarEvent.setHeaderColor(CalendarColor.SILVER.getHeader());
          calendarEvent.setContentColor(CalendarColor.SILVER.getContent());
        } else {
          calendarEvent.setHeaderColor(CalendarColor.GREEN.getHeader());
          calendarEvent.setContentColor(CalendarColor.GREEN.getContent());
        }
        calendarEvent.setBeginDate(sa.getActionDate());
        calendarEvent.setEndDate(sa.getFinalDate());
        calendarEvent.setPath(CrmPU.getObjectPath(sa));
        calendarEvent.setOrganizer(sa.getVendorProspect().getVendor().getIContact());
        PhraseBuilder pb = new PhraseBuilder();
        VendorProspect vp = sa.getVendorProspect();
        pb.addWord(vp.getSaleProspect().getCustomer().getName());
        pb.addPendingSeparator(Chars.forward().toString());
        pb.addWord(vp.getSaleProspect().getDescription());
        calendarEvent.setTitle(pb.toString());
        pb.addPendingSeparator(Chars.nl().repeat(2).toString());
        pb.addWord(sa.getComment());
        pb.addPendingSeparator(Chars.nl().repeat(2).toString());
        for(IContact contact : sa.getIAttendees()) {
          pb.addWord(contact.getName());
          pb.addPendingSeparator(", ");
          calendarEvent.addAttendee(contact);
        }
        calendarEvent.setContent(pb.toString());
        calendarEvent.setEventId(Strings.identifier("sa" + sa.getId() + 
                ObjectString.formatObject(calendarEvent.getBeginDate(), ObjectString.COMPRESSED_DATE_PATTERN, true)));
        addResult(calendarEvent.getEventId(), calendarEvent);
      }
    }
  }
 
}