コード例 #1
0
 /**
  * SELECT de la liste des planning semaine
  *
  * @return
  */
 @SuppressWarnings("unchecked")
 public static List<Planning_Semaine> getAll() {
   Session session = PilotageSession.getCurrentSession();
   List<Planning_Semaine> lps = session.createCriteria(Planning_Semaine.class).list();
   session.getTransaction().commit();
   return lps;
 }
コード例 #2
0
  @SuppressWarnings("unchecked")
  public static boolean hasSemaineWithVacation(int id) {
    Session session = PilotageSession.getCurrentSession();

    Planning_Vacation pv = (Planning_Vacation) session.load(Planning_Vacation.class, id);
    List<Long> results =
        (List<Long>)
            session
                .createCriteria(Planning_Semaine.class)
                .add(
                    Restrictions.or(
                        Restrictions.eq("lundi", pv),
                        Restrictions.or(
                            Restrictions.eq("mardi", pv),
                            Restrictions.or(
                                Restrictions.eq("mercredi", pv),
                                Restrictions.or(
                                    Restrictions.eq("jeudi", pv),
                                    Restrictions.or(
                                        Restrictions.eq("vendredi", pv),
                                        Restrictions.or(
                                            Restrictions.eq("samedi", pv),
                                            Restrictions.eq("dimanche", pv))))))))
                .setProjection(Projections.rowCount())
                .list();
    session.getTransaction().commit();

    if (results != null && results.size() > 0 && results.get(0) > 0) {
      return true;
    } else {
      return false;
    }
  }
コード例 #3
0
 /**
  * SELECT d'un planning semaine
  *
  * @return
  */
 public static Planning_Semaine get(Integer selectRow) {
   Session session = PilotageSession.getCurrentSession();
   Planning_Semaine ps =
       (Planning_Semaine)
           session
               .createCriteria(Planning_Semaine.class)
               .add(Restrictions.eq("id", selectRow))
               .setMaxResults(1)
               .uniqueResult();
   session.getTransaction().commit();
   return ps;
 }
コード例 #4
0
 /**
  * SELECT des semaines du cycle
  *
  * @param idCycle
  * @return
  */
 @SuppressWarnings("unchecked")
 public static List<Planning_Semaine> getSemaineByCycle(Integer idCycle) {
   Session session = PilotageSession.getCurrentSession();
   Planning_Cycle pc = (Planning_Cycle) session.load(Planning_Cycle.class, idCycle);
   List<Planning_Semaine> semaineList =
       session
           .createCriteria(Planning_Semaine.class)
           .add(Restrictions.eq("idNomCycle", pc))
           .addOrder(Order.asc("numeroSemaine"))
           .list();
   session.getTransaction().commit();
   return semaineList;
 }
コード例 #5
0
 public static Integer getId(Integer idCycle, Integer numSemaine) {
   Session session = PilotageSession.getCurrentSession();
   Planning_Cycle pc = (Planning_Cycle) session.load(Planning_Cycle.class, idCycle);
   Planning_Semaine ps =
       (Planning_Semaine)
           session
               .createCriteria(Planning_Semaine.class)
               .add(Restrictions.eq("idNomCycle", pc))
               .add(Restrictions.eq("numeroSemaine", numSemaine))
               .setMaxResults(1)
               .uniqueResult();
   session.getTransaction().commit();
   return ps.getId();
 }
コード例 #6
0
 @SuppressWarnings("unchecked")
 public static List<Planning_Semaine> getSemaineByCycleAndDate(
     Integer idCycle, DateTime deb, DateTime fin) {
   Session session = PilotageSession.getCurrentSession();
   Planning_Cycle pc = (Planning_Cycle) session.load(Planning_Cycle.class, idCycle);
   List<Planning_Semaine> semaineList =
       session
           .createCriteria(Planning_Semaine.class)
           .add(Restrictions.eq("idNomCycle", pc))
           .add(Restrictions.or(Restrictions.isNull("dateFin"), Restrictions.ge("dateFin", deb)))
           .add(Restrictions.le("dateDeb", fin))
           .addOrder(Order.asc("numeroSemaine"))
           .addOrder(Order.asc("dateDeb"))
           .list();
   session.getTransaction().commit();
   return semaineList;
 }
コード例 #7
0
  public static List<Planning_Semaine> getBySemAndCycle(Integer idCycle, Integer numSemaine) {
    Session session = PilotageSession.getCurrentSession();

    Planning_Cycle pc = (Planning_Cycle) session.load(Planning_Cycle.class, idCycle);

    @SuppressWarnings("unchecked")
    List<Planning_Semaine> semaineList =
        (List<Planning_Semaine>)
            session
                .createCriteria(Planning_Semaine.class)
                .add(Restrictions.eq("idNomCycle", pc))
                .add(Restrictions.eq("numeroSemaine", numSemaine))
                .addOrder(Order.asc("dateDeb"))
                .list();
    // fait exprès car fonction utilisé dans PlanningCyclesDatabaseService
    // session.getTransaction().commit();
    return semaineList;
  }