Example usage for org.hibernate.criterion Projections property

Introduction

In this page you can find the example usage for org.hibernate.criterion Projections property.

Prototype

public static PropertyProjection property(String propertyName) 

Source Link

Document

A property value projection

Usage

From source file:com.hrms.manager.LoanAppManager.java

public List<String> getLoanEligibilityList() {
    Session session = HibernateUtil.getSessionFactory().openSession();
    Transaction t = session.beginTransaction();
    List<String> le = new ArrayList<>();
    Criteria c = session.createCriteria(LoanEligibility.class);
    c.setProjection(Projections.property("eligibilityRuleId"));
    List departments = c.list();//from  ww  w.j av a 2  s.  c  o  m
    return departments;
}

---

From source file:com.hrms.manager.LoanAppManager.java

public List<String> getEmpGradeList() {

    Session session = HibernateUtil.getSessionFactory().openSession();
    Transaction t = session.beginTransaction();
    List<String> le = new ArrayList<>();
    Criteria c = session.createCriteria(EmployeeProfile.class);
    c.setProjection(Projections.distinct(Projections.property("empGrade")));

    List emp = c.list();/*from  w w w.  j a  va 2s .  c o m*/
    System.out.println("---------------->" + emp);
    return emp;
}

---

From source file:com.hrms.manager.LoanManager.java

public void updateLoans(Loan loan, int id1) {

    s = HibernateUtil.getSessionFactory().openSession();
    Transaction t = s.beginTransaction();

    try {//from w w w .  j a v  a2s.c om
        Date j = null, realdate = null;

        LoanAllotment la = new LoanAllotment();
        la = (LoanAllotment) s.get(LoanAllotment.class, id1);
        int lid = 0, eid;
        EmployeeProfile emp1 = new EmployeeProfile();
        HashMap<Integer, String> h = new HashMap<>();
        String re = loan.getLoanType();

        eid = loan.getEmpId();

        List<LoansMaster> l = s.createCriteria(LoansMaster.class).list();
        for (LoansMaster l1 : l) {
            h.put(l1.getLoanId(), l1.getLoanTypeName());
        }
        Iterator it1 = h.entrySet().iterator();
        while (it1.hasNext()) {
            Map.Entry<Integer, String> pair = (Map.Entry) it1.next();
            if (re.equals(pair.getValue())) {
                lid = pair.getKey();
            }
            it1.remove();
        }
        Criteria c = s.createCriteria(EmployeeProfile.class);
        emp1 = (EmployeeProfile) c.add(Restrictions.eq("empId", eid)).uniqueResult();
        LoansMaster lom = new LoansMaster(lid);
        la.setLoanType(re);
        la.setDeptlId(emp1.getDepartments());
        la.setLoansMaster(lom);
        la.setRequestedAmt(loan.getRequestedAmt());
        String z = loan.getStatus();
        if (z.equals("New"))
            la.setStatus("New");
        else if (z.equals("Closed"))
            la.setStatus("Closed");
        else if (z.equals("Rejected"))
            la.setStatus("Rejected");
        else if (z.equals("Approved"))
            la.setStatus("Approved");
        la.setHouseholdThings(loan.getHouseholdThings());
        SimpleDateFormat sf = new SimpleDateFormat("dd-MM-yy");

        la.setEmployeeProfile(emp1);
        if (!(z.equals("Rejected") || z.equals("Closed"))) {
            String dt = loan.getLoanApprovaldate();
            j = sf.parse(dt);
            la.setLoanApprovalDate(j);
            la.setSanctionedAmt(loan.getSanctionedAmt());
            if (re.equals("Cash Loan"))
                la.setCashLoan(loan.getSanctionedAmt());
            else if (re.equals("Gas Loan"))
                la.setGasLoan(loan.getSanctionedAmt());
            else if (re.equals("Tra Loan"))
                la.setTraLoan(loan.getSanctionedAmt());
            else
                la.setSanctionedAmt(loan.getSanctionedAmt());

        }
        s.update(la);
        try {
            Calendar cal = Calendar.getInstance();
            cal.setTime(j);
            int year = cal.get(Calendar.YEAR);
            int month = cal.get(Calendar.MONTH) + 1;

            List lk = null;
            Criteria c2 = s.createCriteria(DeductionMaster.class);
            c2.add(Restrictions.eq("employeeProfileByEmpdId.empId", eid))
                    .setProjection(Projections.property("ddate"));
            lk = c2.list();

            //   .add(Restrictions.eq("year(ddate)",year));
            System.out.println("list in Deductions is';;';';;';'';;'--------");
            for (int i1 = 0; i1 < lk.size(); i1++) {
                Date ddd = (Date) lk.get(i1);
                System.out.println("iterator is---------" + ddd);
                cal.setTime(ddd);
                int year8 = cal.get(Calendar.YEAR);
                int month8 = cal.get(Calendar.MONTH) + 1;
                if (year == year8 && month == month8) {
                    realdate = ddd;
                }
            }
            //List l1=null;
            System.out.println("real date is..............." + realdate);
            DeductionMaster i = new DeductionMaster();
            Criteria c1 = s.createCriteria(DeductionMaster.class);
            i = (DeductionMaster) c1.add(Restrictions.eq("ddate", realdate))
                    .add(Restrictions.eq("employeeProfileByEmpdId.empId", eid)).uniqueResult();
            //l1=c1.list();

            int x = i.getTotalDeductions();
            int y = x + loan.getSanctionedAmt();
            int z1 = i.getTotalSanctionedAmount();
            i.setTotalSanctionedAmount(loan.getSanctionedAmt() + z1);
            i.setTotalDeductions(y);
            s.update(i);

            Incentives ip = new Incentives();

            Criteria c3 = s.createCriteria(Incentives.class);
            ip = (Incentives) c3.add(Restrictions.eq("date", realdate))
                    .add(Restrictions.eq("employeeProfileByEmpiId.empId", eid)).uniqueResult();
            int xz = ip.getGrossSalary();
            ip.setNetSalary(xz - y);
            s.update(ip);

        } catch (NullPointerException n) {
            System.out.println("--------------------dgh" + n);
        }

        t.commit();
        s.close();
    } catch (Exception e) {
        e.printStackTrace();

    }

}

---

From source file:com.hrms.manager.PdfManager.java

public List<Incentives> incentiveList(Pdfdto p) {
    List l = new ArrayList();
    List l1 = new ArrayList();
    int empid = p.getEmp_id();
    String date = p.getDate();//from  w  w w.j  a  v a2 s .c om
    Session s = HibernateUtil.getSessionFactory().openSession();
    Transaction t = s.beginTransaction();
    Incentives i = new Incentives();
    Date realdate = new Date();
    try {
        SimpleDateFormat s1 = new SimpleDateFormat("dd-MM-yy");
        Date d1 = s1.parse(date);
        System.out.println("Date is [[[[[[[[[[[[[[[" + d1);
        Calendar cal = Calendar.getInstance();
        cal.setTime(d1);
        int year = cal.get(Calendar.YEAR);
        int month = cal.get(Calendar.MONTH) + 1;

        System.out.println("Incentives year year isssssssss" + year);
        System.out.println("Incentives month isssssssss" + month);
        Criteria c = s.createCriteria(Incentives.class);
        c.add(Restrictions.eq("employeeProfileByEmpiId.empId", empid))
                .setProjection(Projections.property("date"));
        l = c.list();

        //   .add(Restrictions.eq("year(ddate)",year));
        System.out.println("list in Incentives is';;';';;';'';;'--------" + l);
        for (int i1 = 0; i1 < l.size(); i1++) {
            Date ddd = (Date) l.get(i1);
            System.out.println("Incentives iterator is---------" + ddd);
            cal.setTime(ddd);
            int year8 = cal.get(Calendar.YEAR);
            int month8 = cal.get(Calendar.MONTH) + 1;
            if (year == year8 && month == month8) {
                realdate = ddd;
            }
        }
        System.out.println("real date is..............." + realdate);
        Criteria c1 = s.createCriteria(Incentives.class);
        i = (Incentives) c1.add(Restrictions.eq("date", realdate))
                .add(Restrictions.eq("employeeProfileByEmpiId.empId", empid)).uniqueResult();
        l1 = c1.list();
    } catch (Exception ex) {

    }
    System.out.println("list is';;';';;';'';;'--------" + l1);
    return l1;
}

---

From source file:com.hrms.manager.PdfManager.java

public List<DeductionMaster> deductionList(Pdfdto p) {
    List l = new ArrayList();
    List l1 = new ArrayList();
    int empid = p.getEmp_id();
    String date = p.getDate();/*  ww  w. j a  va  2s . c om*/
    Session s = HibernateUtil.getSessionFactory().openSession();
    Transaction t = s.beginTransaction();
    DeductionMaster i = new DeductionMaster();
    Date realdate = new Date();
    try {
        SimpleDateFormat s1 = new SimpleDateFormat("dd-MM-yy");
        Date d1 = s1.parse(date);
        System.out.println("Date is [[[[[[[[[[[[[[[" + d1);
        Calendar cal = Calendar.getInstance();
        cal.setTime(d1);
        int year = cal.get(Calendar.YEAR);
        int month = cal.get(Calendar.MONTH) + 1;

        System.out.println("year isssssssss" + year);
        System.out.println("month isssssssss" + month);
        Criteria c = s.createCriteria(DeductionMaster.class);
        c.add(Restrictions.eq("employeeProfileByEmpdId.empId", empid))
                .setProjection(Projections.property("ddate"));
        l = c.list();

        //   .add(Restrictions.eq("year(ddate)",year));
        System.out.println("list in Deductions is';;';';;';'';;'--------");
        for (int i1 = 0; i1 < l.size(); i1++) {
            Date ddd = (Date) l.get(i1);
            System.out.println("iterator is---------" + ddd);
            cal.setTime(ddd);
            int year8 = cal.get(Calendar.YEAR);
            int month8 = cal.get(Calendar.MONTH) + 1;
            if (year == year8 && month == month8) {
                realdate = ddd;
            }
        }
        System.out.println("real date is..............." + realdate);
        Criteria c1 = s.createCriteria(DeductionMaster.class);
        i = (DeductionMaster) c1.add(Restrictions.eq("ddate", realdate))
                .add(Restrictions.eq("employeeProfileByEmpdId.empId", empid)).uniqueResult();
        l1 = c1.list();
    } catch (Exception ex) {

    }
    System.out.println("list is';;';';;';'';;'--------" + l1);
    return l1;
}

---

From source file:com.hrms.manager.PdfManager.java

public List<Integer> deductionListtotal(Pdfdto p) {
    List<Integer> l = new ArrayList();
    List l1 = new ArrayList();
    int empid = p.getEmp_id();
    String date = p.getDate();/*from   ww w  .  j ava2s . c om*/
    Session s = HibernateUtil.getSessionFactory().openSession();
    Transaction t = s.beginTransaction();
    DeductionMaster i = new DeductionMaster();
    Date realdate = new Date();
    try {
        SimpleDateFormat s1 = new SimpleDateFormat("dd-MM-yy");
        Date d1 = s1.parse(date);
        System.out.println("Date is [[[[[[[[[[[[[[[" + d1);
        Calendar cal = Calendar.getInstance();
        cal.setTime(d1);
        int year = cal.get(Calendar.YEAR);
        int month = cal.get(Calendar.MONTH) + 1;

        System.out.println("year isssssssss" + year);
        System.out.println("month isssssssss" + month);
        Criteria c = s.createCriteria(DeductionMaster.class);
        c.add(Restrictions.eq("employeeProfileByEmpdId.empId", empid))
                .setProjection(Projections.property("ddate"));
        l1 = c.list();

        //   .add(Restrictions.eq("year(ddate)",year));
        System.out.println("list in Deductions is';;';';;';'';;'--------");
        for (int i1 = 0; i1 < l1.size(); i1++) {
            Date ddd = (Date) l1.get(i1);
            System.out.println("iterator is---------" + ddd);
            cal.setTime(ddd);
            int year8 = cal.get(Calendar.YEAR);
            int month8 = cal.get(Calendar.MONTH) + 1;
            if (year == year8 && month == month8) {
                realdate = ddd;
            }
        }
        System.out.println("real date is..............." + realdate);
        Criteria c1 = s.createCriteria(DeductionMaster.class);
        i = (DeductionMaster) c1.add(Restrictions.eq("ddate", realdate))
                .add(Restrictions.eq("employeeProfileByEmpdId.empId", empid)).uniqueResult();

        int ppp = i.getPpp();
        int sal_adv = i.getSalaryAdvance();
        int total_amt = i.getTotalSanctionedAmount();
        int power = i.getPower();
        int meals = i.getMeals();
        int tiffin = i.getTiffin();
        int tea = i.getTea();
        int store = i.getStore();
        int medicines = i.getMedicines();
        int cable = i.getCable();
        int gas = i.getGas();
        int adv2 = i.getAdv2();
        int eggs = i.getEggs();
        int uniform = i.getUniform();
        int total_misc = ppp + sal_adv + total_amt + power + meals + tiffin + tea + store + medicines + cable
                + gas + adv2 + eggs + uniform;
        System.out.println("total misc is ===========" + total_misc);
        l.add(total_misc);
    } catch (Exception ex) {

    }
    System.out.println("list is';;';';;';'';;'--------" + l1);
    return l;
}

---

From source file:com.hrms.manager.PdfManager.java

public boolean validateUserIncentives(Pdfdto p) {
    System.out.println("---------home----??????????------------");

    System.out.println("-------------------ssssssssssss");
    Session s = HibernateUtil.getSessionFactory().openSession();
    Transaction t = s.beginTransaction();
    List l = new ArrayList();
    List l1 = new ArrayList();
    try {//from  w  ww.  j  a  va  2 s .co m
        int empid = p.getEmp_id();
        String date = p.getDate();
        Incentives i = new Incentives();
        Date realdate = new Date();
        SimpleDateFormat s1 = new SimpleDateFormat("dd-MM-yy");
        Date d1 = s1.parse(date);
        System.out.println("Swaaaaaaaaaaaaaathiiiiiiiiiii" + d1);
        Calendar cal = Calendar.getInstance();
        cal.setTime(d1);
        int year = cal.get(Calendar.YEAR);
        int month = cal.get(Calendar.MONTH) + 1;

        System.out.println("Incentives year year isssssssss" + year);
        System.out.println("Incentives month isssssssss" + month);
        Criteria c = s.createCriteria(Incentives.class);
        c.add(Restrictions.eq("employeeProfileByEmpiId.empId", empid))
                .setProjection(Projections.property("date"));
        l = c.list();

        //   .add(Restrictions.eq("year(ddate)",year));
        System.out.println("list in Incentives is';;';';;';'';;'--------" + l);
        for (int i1 = 0; i1 < l.size(); i1++) {
            Date ddd = (Date) l.get(i1);
            System.out.println("Incentives iterator is---------" + ddd);
            cal.setTime(ddd);
            int year8 = cal.get(Calendar.YEAR);
            int month8 = cal.get(Calendar.MONTH) + 1;
            if (year == year8 && month == month8) {
                realdate = ddd;
            }
        }
        System.out.println("real date is..............." + realdate);
        Criteria c1 = s.createCriteria(Incentives.class);
        i = (Incentives) c1.add(Restrictions.eq("date", realdate))
                .add(Restrictions.eq("employeeProfileByEmpiId.empId", empid)).uniqueResult();
        l1 = c1.list();

        if (l1.size() > 0) {
            //session.close();
            return false;
        }
        t.commit();
        s.close();
    } catch (Exception e) {
        //session.getTransaction().rollback();
    } finally {
        if (s != null) {
            // session.close();
        }
    }

    return true;

}

---

From source file:com.hrms.manager.PdfManager.java

public boolean validateDeductionlist(Pdfdto p) {
    Session s = HibernateUtil.getSessionFactory().openSession();
    Transaction t = s.beginTransaction();
    List l = new ArrayList();
    List l1 = new ArrayList();
    try {/*  w  ww . j  a  v a  2s .  co m*/
        int empid = p.getEmp_id();
        String date = p.getDate();
        DeductionMaster i = new DeductionMaster();
        Date realdate = new Date();
        SimpleDateFormat s1 = new SimpleDateFormat("dd-MM-yy");
        Date d1 = s1.parse(date);
        System.out.println("Date is [[[[[[[[[[[[[[[" + d1);
        Calendar cal = Calendar.getInstance();
        cal.setTime(d1);
        int year = cal.get(Calendar.YEAR);
        int month = cal.get(Calendar.MONTH) + 1;

        System.out.println("Incentives year year isssssssss" + year);
        System.out.println("Incentives month isssssssss" + month);
        Criteria c = s.createCriteria(DeductionMaster.class);
        c.add(Restrictions.eq("employeeProfileByEmpdId.empId", empid))
                .setProjection(Projections.property("ddate"));
        l = c.list();

        //   .add(Restrictions.eq("year(ddate)",year));
        System.out.println("list in Incentives is';;';';;';'';;'--------" + l);
        for (int i1 = 0; i1 < l.size(); i1++) {
            Date ddd = (Date) l.get(i1);
            System.out.println("Incentives iterator is---------" + ddd);
            cal.setTime(ddd);
            int year8 = cal.get(Calendar.YEAR);
            int month8 = cal.get(Calendar.MONTH) + 1;
            if (year == year8 && month == month8) {
                realdate = ddd;
            }
        }
        System.out.println("real date is..............." + realdate);
        Criteria c1 = s.createCriteria(DeductionMaster.class);
        i = (DeductionMaster) c1.add(Restrictions.eq("ddate", realdate))
                .add(Restrictions.eq("employeeProfileByEmpdId.empId", empid)).uniqueResult();
        l1 = c1.list();

        if (l1.size() > 0) {
            //session.close();
            return false;
        }
        t.commit();
        s.close();
    } catch (Exception e) {
        //session.getTransaction().rollback();
    } finally {
        if (s != null) {
            // session.close();
        }
    }

    return true;
}

---

From source file:com.hrms.manager.PdfManager.java

public boolean trivs(Pdfdto p) {
    Session s = HibernateUtil.getSessionFactory().openSession();
    Transaction t = s.beginTransaction();
    List l = new ArrayList();
    List l1 = new ArrayList();
    System.out.println("hhhhhhhhhhhhhhhhhhhh");

    try {/*from w  ww .j a va 2  s.c o  m*/
        //  int empid = p.getEmp_id();

        String date = p.getEmpdate();
        DeductionMaster i;
        System.out.println("duuuuuuuuuuuuuuuuuude" + date);
        Date realdate = new Date();
        SimpleDateFormat s1 = new SimpleDateFormat("dd-MM-yy");
        Date d1 = s1.parse(date);

        System.out.println("fgggggggggggggggggdfgdgdfg");
        System.out.println("Date is [[[[[[[[[[[[[[[" + d1);
        Calendar cal = Calendar.getInstance();
        cal.setTime(d1);
        int year = cal.get(Calendar.YEAR);
        int month = cal.get(Calendar.MONTH) + 1;

        System.out.println("Incentives year year isssssssss" + year);
        System.out.println("Incentives month isssssssss" + month);
        Criteria c = s.createCriteria(DeductionMaster.class);
        c.setProjection(Projections.property("ddate"));
        l = c.list();

        //   .add(Restrictions.eq("year(ddate)",year));
        System.out.println("list in Incentives is';;';';;';'';;'--------" + l);
        for (int i1 = 0; i1 < l.size(); i1++) {
            Date ddd = (Date) l.get(i1);
            System.out.println("Incentives iterator is---------" + ddd);
            cal.setTime(ddd);
            int year8 = cal.get(Calendar.YEAR);
            int month8 = cal.get(Calendar.MONTH) + 1;
            if (year == year8 && month == month8) {
                realdate = ddd;

                System.out.println("real date is..............." + realdate);
                Criteria c1 = s.createCriteria(DeductionMaster.class);
                c1.add(Restrictions.eq("ddate", realdate));
                l1 = c1.list();
            }
            if (l1.size() > 0) {
                //session.close();
                return false;
            }
        }

        System.out.println("--------------------dgdfg--------------list------------>" + l1);

        t.commit();
        s.close();
    } catch (Exception e) {
        //session.getTransaction().rollback();
    } finally {
        if (s != null) {
            // session.close();
        }
    }

    return true;
}

---

From source file:com.hypersocket.resource.AbstractAssignableResourceRepositoryImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from w ww .j av a2s .c  o  m*/
public Collection<T> searchAssignedResources(List<Principal> principals, final String searchPattern,
        final int start, final int length, final ColumnSort[] sorting, CriteriaConfiguration... configs) {

    Criteria criteria = createCriteria(getResourceClass());
    criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

    if (StringUtils.isNotBlank(searchPattern)) {
        criteria.add(Restrictions.ilike("name", searchPattern));
    }

    for (CriteriaConfiguration c : configs) {
        c.configure(criteria);
    }

    criteria.add(Restrictions.eq("realm", principals.get(0).getRealm()));
    criteria = criteria.createCriteria("roles");
    criteria.add(Restrictions.eq("allUsers", true));

    Set<T> everyone = new HashSet<T>(criteria.list());

    criteria = createCriteria(getResourceClass());

    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.property("id"));
    projList.add(Projections.property("name"));

    criteria.setProjection(Projections.distinct(projList));
    criteria.setFirstResult(start);
    criteria.setMaxResults(length);

    if (StringUtils.isNotBlank(searchPattern)) {
        criteria.add(Restrictions.ilike("name", searchPattern));
    }

    for (CriteriaConfiguration c : configs) {
        c.configure(criteria);
    }

    for (ColumnSort sort : sorting) {
        criteria.addOrder(sort.getSort() == Sort.ASC ? Order.asc(sort.getColumn().getColumnName())
                : Order.desc(sort.getColumn().getColumnName()));
    }

    criteria.add(Restrictions.eq("realm", principals.get(0).getRealm()));

    criteria = criteria.createCriteria("roles");
    criteria.add(Restrictions.eq("allUsers", false));
    criteria = criteria.createCriteria("principals");

    List<Long> ids = new ArrayList<Long>();
    for (Principal p : principals) {
        ids.add(p.getId());
    }
    criteria.add(Restrictions.in("id", ids));

    List<Object[]> results = (List<Object[]>) criteria.list();

    if (results.size() > 0) {
        Long[] entityIds = new Long[results.size()];
        int idx = 0;
        for (Object[] obj : results) {
            entityIds[idx++] = (Long) obj[0];
        }

        criteria = createCriteria(getResourceClass());
        criteria.add(Restrictions.in("id", entityIds));

        everyone.addAll((List<T>) criteria.list());
    }
    return everyone;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »