TimeControlUtil.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2012 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.erp.time;
 
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.amic.util.date.CheckDate;
import org.turro.elephant.db.WhereClause;
import org.turro.erp.db.ErpPU;
import org.turro.erp.entity.HumanResource;
import org.turro.erp.entity.Task;
import org.turro.erp.entity.TimeControl;
import org.turro.jpa.Dao;
 
public class TimeControlUtil {
 
  private HumanResource humanResource;
  private Task task;
 
  public HumanResource getHumanResource() {
    return humanResource;
  }
 
  public void setHumanResource(HumanResource humanResource) {
    this.humanResource = humanResource;
  }
 
  public Task getTask() {
    return task;
  }
 
  public void setTask(Task task) {
    this.task = task;
  }
  
  public List<TimeControl> getPendingControl() {
    if(humanResource != null) {
      WhereClause wc = new WhereClause();
      wc.addClause("select tc from TimeControl as tc");
      wc.addClause("where tc.humanResource = :humanResource");
      wc.addNamedValue("humanResource", humanResource);
      if(task != null) {
        wc.addClause("and tc.task = :task");
        wc.addNamedValue("task", task);
      }
      wc.addClause("and tc.endTime is null");
      Dao dao = new ErpPU();
      return dao.getResultList(wc);
    }
    return new ArrayList<TimeControl>();
  }
  
  public TimeControl start() {
    return start(null);
  }
  
  public TimeControl start(Date date) {
    TimeControl tc = new TimeControl();
    tc.setHumanResource(humanResource);
    tc.setTask(task);
    if(date == null) {
      tc.setStartTime(new Date());
    } else {
      tc.setStartTime(date);
      tc.setStartManual(true);
    }
    Dao dao = new ErpPU();
    tc = dao.saveObject(tc);
    return tc;
  }
  
  public TimeControl end(TimeControl tc) {
    return end(tc, null);
  }
  
  public TimeControl end(TimeControl tc, Date date) {
    Dao dao = new ErpPU();
    tc = dao.find(TimeControl.class, tc.getId());
    if(date == null) {
      tc.setEndTime(new Date());
    } else {
      tc.setEndTime(date);
      tc.setEndManual(true);
    }
    tc = dao.saveObject(tc);
    return tc;
  }
  
  public List<TimeControl> getFromDate(Date date) {
    CheckDate d = new CheckDate(date);
    WhereClause wc = new WhereClause();
    wc.addClause("select tc from TimeControl as tc");
    wc.addClause("where (year(tc.startTime) = :year1 and month(tc.startTime) = :month1 and day(tc.startTime) = :day1)");
    wc.addClause("or (year(tc.endTime) = :year2 and month(tc.endTime) = :month2 and day(tc.endTime) = :day2)");
    wc.addNamedValue("year1", d.getYear());
    wc.addNamedValue("month1", d.getMonth());
    wc.addNamedValue("day1", d.getDay());
    wc.addNamedValue("year2", d.getYear());
    wc.addNamedValue("month2", d.getMonth());
    wc.addNamedValue("day2", d.getDay());
    Dao dao = new ErpPU();
    return dao.getResultList(wc);
  }
  
}