Example usage for org.hibernate.criterion Restrictions isNotNull

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions isNotNull.

Prototype

public static Criterion isNotNull(String propertyName) 

Source Link

Document

Apply an "is not null" constraint to the named property

Usage

From source file:com.square.adherent.noyau.dao.implementations.contrat.ContratDaoImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from ww w .jav a  2 s. c  om
public Contrat getDernierContratRadiePersonne(Long uidPersonne) {
    final Criteria crit = createCriteria(Contrat.class);
    crit.add(Restrictions.eq("uidAssure", uidPersonne));
    crit.add(Restrictions.isNotNull("dateResiliation"));
    crit.add(Restrictions.eq("isVisible", true));
    crit.addOrder(Order.desc("dateResiliation"));
    final List<Contrat> listeConstrats = crit.list();
    if (listeConstrats != null && listeConstrats.size() > 0) {
        return listeConstrats.get(0);
    } else {
        return null;
    }
}

---

From source file:com.square.adherent.noyau.dao.implementations.contrat.ContratDaoImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from  w ww  . j a  v  a 2s. co m
public Contrat getDernierContratRadiePersonneMorale(Long uidPersonneMorale) {
    final Criteria crit = createCriteria(Contrat.class);
    crit.add(Restrictions.eq("uidSouscripteur", uidPersonneMorale));
    crit.add(Restrictions.isNull("uidAssure"));
    crit.add(Restrictions.isNotNull("dateResiliation"));
    crit.add(Restrictions.eq("isVisible", true));
    crit.addOrder(Order.desc("dateResiliation"));
    final List<Contrat> listeConstrats = crit.list();
    if (listeConstrats != null && listeConstrats.size() > 0) {
        return listeConstrats.get(0);
    } else {
        return null;
    }
}

---

From source file:com.square.adherent.noyau.dao.implementations.contrat.GarantieDaoImpl.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public List<Garantie> getListeGarantiesContratPersonneMorale(String eidContrat) {
    final int nbCaractere = 13;
    final Criteria crit = createCriteria(Garantie.class);
    crit.createAlias("contrat", "contrat");
    crit.add(Restrictions.isNotNull("uidAssure"));
    crit.add(Restrictions.ilike("contrat.identifiantExterieur", eidContrat.substring(0, nbCaractere) + "%"));
    return crit.list();
}

---

From source file:com.square.tarificateur.noyau.dao.implementations.DevisDaoImpl.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public List<Devis> getListeDevisByCriteres(CriteresRechercheDevisDto criteres) {
    final Criteria crit = createCriteria(Devis.class);
    if (criteres.getCloturer() != null) {
        if (criteres.getCloturer()) {
            crit.add(Restrictions.isNotNull("dateCloture"));
        } else {/*  www  .  ja va2s .c o  m*/
            crit.add(Restrictions.isNull("dateCloture"));
        }
    }
    if (criteres.getOrigineSiteWeb() != null) {
        if (criteres.getOrigineSiteWeb()) {
            crit.add(Restrictions.eq("origineSiteWeb", true));
        } else {
            crit.add(Restrictions.or(Restrictions.isNull("origineSiteWeb"),
                    Restrictions.eq("origineSiteWeb", false)));
        }
    }
    if (criteres.getIdFinalite() != null) {
        crit.add(Restrictions.eq("finalite.id", criteres.getIdFinalite()));
    }
    if (criteres.getIdsFinalite() != null && criteres.getIdsFinalite().size() > 0) {
        crit.add(Restrictions.in("finalite.id", criteres.getIdsFinalite()));
    }
    if (criteres.getIdPersonne() != null || criteres.getEidPersonne() != null) {
        final Criteria personne = crit.createAlias("personnePrincipale", "personne");
        if (criteres.getIdPersonne() != null) {
            personne.add(Restrictions.eq("personne.id", criteres.getIdPersonne()));
        }
        if (criteres.getEidPersonne() != null) {
            personne.add(Restrictions.eq("personne.eidPersonne", criteres.getEidPersonne()));
        }
    }
    if (criteres.getIdDevis() != null) {
        crit.add(Restrictions.eq("id", criteres.getIdDevis()));
    }
    return (ArrayList<Devis>) crit.list();
}

---

From source file:com.square.tarificateur.noyau.dao.implementations.OpportuniteDaoImpl.java

License:Open Source License

/**
 * {@inheritDoc}//from  ww w .j  a v a  2  s .co m
 */
@SuppressWarnings("unchecked")
public List<String> getIdsBaAdhesionNonTelecharges() {
    final Criteria crit = createCriteria(Adhesion.class);
    crit.setProjection(Projections.property("idFichierCNS"));
    crit.add(Restrictions.isNull("dateTelechargementBA"));
    crit.add(Restrictions.isNotNull("idFichierCNS"));
    return (List<String>) crit.list();
}

---

From source file:com.tm.main.GraphUI.java

private void renderTable() {
    DefaultTableModel dtm = new DefaultTableModel();
    dtm.addColumn("User");
    dtm.addColumn("Project");
    dtm.addColumn("Task");
    TaskManagerService lTaskManagerService = new TaskManagerServiceImpl();

    Object[] columns = getTableHeader();

    for (int i = 0; i < columns.length; i++) {
        dtm.addColumn(new SimpleDateFormat("dd.MMM.yy").format(columns[i]));
    }/*from  w w  w. j  ava 2s .co  m*/

    List<Criterion> criteria = new ArrayList<Criterion>();

    Criterion c2 = Restrictions.ne("status", "-1");
    criteria.add(c2);

    Criterion c3 = Restrictions.isNotNull("assignee");
    criteria.add(c3);

    Criterion c4 = Restrictions.ne("assignee", "-1");
    criteria.add(c4);

    List<Order> listOrders = new ArrayList<Order>();
    Order objOrderByEmployee = Order.asc("assignee");
    listOrders.add(objOrderByEmployee);

    List<TaskMaster> assignments = lTaskManagerService.getAllTask(criteria, listOrders);

    for (int j = 0; j < assignments.size(); j++) {
        Object[] rowData = getRow(assignments.get(j));
        Object[] row = getFormatedRow(columns, rowData);

        if (!isBlankRow(row)) {
            row[0] = SystemUI.mUserMasterData.get(assignments.get(j).getAssignee());
            row[1] = SystemUI.mProjectMasterData.get(assignments.get(j).getProjectName());
            row[2] = assignments.get(j).getTaskReference();
            dtm.addRow(getBlankRow(columns));
            dtm.addRow(row);

        }

    }
    dtm.addRow(getBlankRow(columns));

    jTable1.setEnabled(false);
    jTable1.setShowGrid(false);
    jTable1.setIntercellSpacing(new Dimension(0, 0));
    jTable1.setModel(dtm);

    Map<String, Color> mMapColors = new HashMap<String, Color>();
    //        mMapColors.put("ROHIT_2", Color.blue);
    //        mMapColors.put("ROHIT_1", Color.red);
    //        mMapColors.put("ROHIT_3", Color.yellow);

    mMapColors = getGraphColor(SystemUI.mUserMasterData);

    jTable1.getColumnModel().getColumn(0).setCellRenderer(new CellGraphDataRenderer(mMapColors));
    jTable1.getColumnModel().getColumn(1).setCellRenderer(new CellGraphDataRenderer(mMapColors));
    jTable1.getColumnModel().getColumn(2).setCellRenderer(new CellGraphDataRenderer(mMapColors));
    for (int i = 0; i < columns.length; i++) {
        jTable1.getColumnModel().getColumn(i + 3).setCellRenderer(new CellGraphDataRenderer(mMapColors));
    }

    UtilService.self().setColumnSize(0, 100, jTable1);
    UtilService.self().setColumnSize(1, 100, jTable1);
    UtilService.self().setColumnSize(2, 100, jTable1);
    jTable1.validate();

    DefaultTableCellRenderer cellRenderer = (DefaultTableCellRenderer) jTable1.getCellRenderer(0, 0);
    cellRenderer.setHorizontalAlignment(SwingConstants.CENTER);
    cellRenderer.setVerticalAlignment(SwingConstants.TOP);

}

---

From source file:com.tripad.cootrack.utility.ResponseResultToDB.java

private void isiMaintenanceDateFromTo(OBCriteria<TmcCar> tmcCarCriteria,
        TmcDocumentUpdateLine newTmcDocumentUpdateLine) {
    OBCriteria<TmcDocumentUpdateLine> tmcDocumentUpdateLineLatestDate = OBDal.getInstance()
            .createCriteria(TmcDocumentUpdateLine.class);
    tmcDocumentUpdateLineLatestDate//from  w w w  .  j  a  v a 2s. com
            .add(Restrictions.eq(TmcDocumentUpdateLine.PROPERTY_TMCCAR, tmcCarCriteria.list().get(0)));

    //jangan yg kosong
    tmcDocumentUpdateLineLatestDate
            .add(Restrictions.isNotNull(TmcDocumentUpdateLine.PROPERTY_MAINTENANCEDATEFROM));
    //tmcDocumentUpdateLineLatestDate.add(Restrictions.sqlRestriction(" maintenancedatefrom=(SELECT MAX(ff.maintenancedatefrom) FROM tmc_documentupdateline ff WHERE ff.maintenancedatefrom= maintenancedatefrom)"));

    //order dari yg paling besar dan hanya ambil no 1
    tmcDocumentUpdateLineLatestDate.addOrderBy(TmcDocumentUpdateLine.PROPERTY_MAINTENANCEDATEFROM, false);

    //set maksimum data yg keluar
    tmcDocumentUpdateLineLatestDate.setMaxResults(1);

    if (tmcDocumentUpdateLineLatestDate.list().size() > 0) {
        newTmcDocumentUpdateLine
                .setMaintenanceDateFrom(tmcDocumentUpdateLineLatestDate.list().get(0).getMaintenanceDateFrom());
        newTmcDocumentUpdateLine
                .setMaintenanceDateTo(tmcDocumentUpdateLineLatestDate.list().get(0).getMaintenanceDateTo());
    } else {
        newTmcDocumentUpdateLine.setMaintenanceDateFrom(null);
        newTmcDocumentUpdateLine.setMaintenanceDateTo(null);
    }
}

---

From source file:com.tripad.cootrack.utility.ResponseResultToDB.java

private void isiPengisianKe(OBCriteria<TmcCar> tmcCarCriteria, TmcDocumentUpdateLine newTmcDocumentUpdateLine) {
    OBCriteria<TmcDocumentUpdateLine> tmcDocumentUpdateLineBiggestPengisianKe = OBDal.getInstance()
            .createCriteria(TmcDocumentUpdateLine.class);
    tmcDocumentUpdateLineBiggestPengisianKe
            .add(Restrictions.eq(TmcDocumentUpdateLine.PROPERTY_TMCCAR, tmcCarCriteria.list().get(0)));

    //jangan yg kosong
    tmcDocumentUpdateLineBiggestPengisianKe
            .add(Restrictions.isNotNull(TmcDocumentUpdateLine.PROPERTY_PENGISIANKE));

    //order dari yg paling besar dan hanya ambil no 1
    tmcDocumentUpdateLineBiggestPengisianKe.addOrderBy(TmcDocumentUpdateLine.PROPERTY_PENGISIANKE, false); //false menandakan descending

    //set maksimum data yg keluar
    tmcDocumentUpdateLineBiggestPengisianKe.setMaxResults(1);

    if (tmcDocumentUpdateLineBiggestPengisianKe.list().size() > 0) {
        newTmcDocumentUpdateLine/*from  w  w  w.  jav a 2s  .com*/
                .setPengisianke(tmcDocumentUpdateLineBiggestPengisianKe.list().get(0).getPengisianke());
    } else {
        newTmcDocumentUpdateLine.setPengisianke(new Long("0"));
    }
}

---

From source file:com.tripad.cootrack.utility.ResponseResultToDB.java

private void isiTanggalNominalPulsaReguler(OBCriteria<TmcCar> tmcCarCriteria,
        TmcDocumentUpdateLine newTmcDocumentUpdateLine) {
    /*tanggal reguler*/
    OBCriteria<TmcDocumentUpdateLine> tmcDocumentUpdateLineLatestDate = OBDal.getInstance()
            .createCriteria(TmcDocumentUpdateLine.class);
    tmcDocumentUpdateLineLatestDate/*from w w w  . java2 s . co m*/
            .add(Restrictions.eq(TmcDocumentUpdateLine.PROPERTY_TMCCAR, tmcCarCriteria.list().get(0)));

    //jangan yg kosong
    tmcDocumentUpdateLineLatestDate.add(Restrictions.isNotNull(TmcDocumentUpdateLine.PROPERTY_TGLISIPULSAREG));
    //tmcDocumentUpdateLineLatestDate.add(Restrictions.sqlRestriction(" maintenancedatefrom=(SELECT MAX(ff.maintenancedatefrom) FROM tmc_documentupdateline ff WHERE ff.maintenancedatefrom= maintenancedatefrom)"));

    //order dari yg paling besar dan hanya ambil no 1
    tmcDocumentUpdateLineLatestDate.addOrderBy(TmcDocumentUpdateLine.PROPERTY_TGLISIPULSAREG, false);

    //set maksimum data yg keluar
    tmcDocumentUpdateLineLatestDate.setMaxResults(1);

    if (tmcDocumentUpdateLineLatestDate.list().size() > 0) {
        newTmcDocumentUpdateLine
                .setTGLIsiPulsaReg(tmcDocumentUpdateLineLatestDate.list().get(0).getTGLIsiPulsaReg());
    } else {
        newTmcDocumentUpdateLine.setTGLIsiPulsaReg(null);
    }

    /*nominal reguler*/
    tmcDocumentUpdateLineLatestDate = OBDal.getInstance().createCriteria(TmcDocumentUpdateLine.class);
    tmcDocumentUpdateLineLatestDate
            .add(Restrictions.eq(TmcDocumentUpdateLine.PROPERTY_TMCCAR, tmcCarCriteria.list().get(0)));

    //order dari yg paling besar dan hanya ambil no 1
    tmcDocumentUpdateLineLatestDate.addOrderBy(TmcDocumentUpdateLine.PROPERTY_NOMISIPULSAREG, false);

    //set maksimum data yg keluar
    tmcDocumentUpdateLineLatestDate.setMaxResults(1);

    if (tmcDocumentUpdateLineLatestDate.list().size() > 0) {
        newTmcDocumentUpdateLine
                .setNOMIsiPulsaReg(tmcDocumentUpdateLineLatestDate.list().get(0).getNOMIsiPulsaReg());
    } else {
        newTmcDocumentUpdateLine.setNOMIsiPulsaReg(BigDecimal.ZERO);
    }
}

---

From source file:com.tripad.cootrack.utility.ResponseResultToDB.java

private void isiTanggalNominalPulsaQuota(OBCriteria<TmcCar> tmcCarCriteria,
        TmcDocumentUpdateLine newTmcDocumentUpdateLine) {
    /*tanggal quota*/
    OBCriteria<TmcDocumentUpdateLine> tmcDocumentUpdateLineLatestDate = OBDal.getInstance()
            .createCriteria(TmcDocumentUpdateLine.class);
    tmcDocumentUpdateLineLatestDate/*from   www .j a v a 2s.c  om*/
            .add(Restrictions.eq(TmcDocumentUpdateLine.PROPERTY_TMCCAR, tmcCarCriteria.list().get(0)));

    //jangan yg kosong
    tmcDocumentUpdateLineLatestDate
            .add(Restrictions.isNotNull(TmcDocumentUpdateLine.PROPERTY_TGLISIPULSAQUOTA));
    //tmcDocumentUpdateLineLatestDate.add(Restrictions.sqlRestriction(" maintenancedatefrom=(SELECT MAX(ff.maintenancedatefrom) FROM tmc_documentupdateline ff WHERE ff.maintenancedatefrom= maintenancedatefrom)"));

    //order dari yg paling besar dan hanya ambil no 1
    tmcDocumentUpdateLineLatestDate.addOrderBy(TmcDocumentUpdateLine.PROPERTY_TGLISIPULSAQUOTA, false);

    //set maksimum data yg keluar
    tmcDocumentUpdateLineLatestDate.setMaxResults(1);

    if (tmcDocumentUpdateLineLatestDate.list().size() > 0) {
        newTmcDocumentUpdateLine
                .setTGLIsiPulsaQuota(tmcDocumentUpdateLineLatestDate.list().get(0).getTGLIsiPulsaQuota());
    } else {
        newTmcDocumentUpdateLine.setTGLIsiPulsaQuota(null);
    }

    /*nominal quota*/
    tmcDocumentUpdateLineLatestDate = OBDal.getInstance().createCriteria(TmcDocumentUpdateLine.class);
    tmcDocumentUpdateLineLatestDate
            .add(Restrictions.eq(TmcDocumentUpdateLine.PROPERTY_TMCCAR, tmcCarCriteria.list().get(0)));

    //order dari yg paling besar dan hanya ambil no 1
    tmcDocumentUpdateLineLatestDate.addOrderBy(TmcDocumentUpdateLine.PROPERTY_NOMISIPULSAQUOTA, false);

    //set maksimum data yg keluar
    tmcDocumentUpdateLineLatestDate.setMaxResults(1);

    if (tmcDocumentUpdateLineLatestDate.list().size() > 0) {
        newTmcDocumentUpdateLine
                .setNOMIsiPulsaQuota(tmcDocumentUpdateLineLatestDate.list().get(0).getNOMIsiPulsaQuota());
    } else {
        newTmcDocumentUpdateLine.setNOMIsiPulsaQuota(BigDecimal.ZERO);
    }
}

---

• «
• 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
• »