Example usage for org.hibernate.criterion Restrictions isNull

List of usage examples for org.hibernate.criterion Restrictions isNull

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. isNull

Introduction

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

Prototype

public static Criterion isNull(String propertyName)

Source Link

Document

Apply an "is null" constraint to the named property

Usage

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

License:Open Source License

/**
 * {@inheritDoc}// ww  w  . j  a v a  2 s  . com
 */
@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.square.tarificateur.noyau.dao.implementations.OpportuniteDaoImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/* www. ja va 2s  . co  m*/
public List<Opportunite> rechercherOpportunitesByCritere(CriteresRechercheOpportuniteDto criteres) {
    final Criteria crit = createCriteria(Opportunite.class);
    if (criteres.getListeEids() != null && criteres.getListeEids().size() > 0) {
        crit.add(Restrictions.in("eidOpportunite", criteres.getListeEids()));
    }
    if (criteres.getIdFinalite() != null) {
        crit.add(Restrictions.eq("finalite.id", criteres.getIdFinalite()));
    }
    if (criteres.getDebutDateCloture() != null) {
        crit.add(Restrictions.ge("dateCloture", criteres.getDebutDateCloture()));
    }
    if (criteres.getFinDateCloture() != null) {
        crit.add(Restrictions.lt("dateCloture", criteres.getFinDateCloture()));
    }
    if (criteres.getListeEidsNaturePersonneExclure() != null
            && criteres.getListeEidsNaturePersonneExclure().size() > 0) {
        crit.add(Restrictions.or(Restrictions.isNull("eidNaturePersonne"), Restrictions
                .not(Restrictions.in("eidNaturePersonne", criteres.getListeEidsNaturePersonneExclure()))));
    }
    return (List<Opportunite>) crit.list();
}

From source file:com.tegik.almac.module.actionHandler.ChangeSize.java

License:Open Source License

public void doExecute(ProcessBundle bundle) throws Exception {
    try {//from  w  w w.jav a2s. c  o  m

        //Imprime todos los parametros
        almac_sizechange header = obdal.get(almac_sizechange.class,
                (String) bundle.getParams().get("Almac_Sizechange_ID"));

        //Query para verificar que ninguno tenga medidas en 0
        OBCriteria<almac_sizechangeline> pQ = obdal.createCriteria(almac_sizechangeline.class);
        pQ.add(Restrictions.eq(almac_sizechangeline.PROPERTY_ALMACSIZECHANGE, header));
        pQ.add(Restrictions.or(Restrictions.isNull(almac_sizechangeline.PROPERTY_ALMACRAZONAJUSTE),
                Restrictions.or(Restrictions.le(almac_sizechangeline.PROPERTY_HEIGHT, BigDecimal.ZERO),
                        Restrictions.le(almac_sizechangeline.PROPERTY_WIDTH, BigDecimal.ZERO))));
        List<almac_sizechangeline> sizeList = pQ.list();

        //Verifica que ningun producto tenga tamano menor a 0
        if (!sizeList.isEmpty()) {
            final OBError msg = new OBError();
            msg.setType("Error");
            msg.setTitle("Error en las piezas.");
            msg.setMessage("Hay piezas con medidas menores o igual a cero o sin una razn de cambio.");
            bundle.setResult(msg);
            return;
        }

        //Verifica que el inventario del producto no este en 0
        //Query para verificar que ninguno tenga medidas en 0
        pQ = obdal.createCriteria(almac_sizechangeline.class);
        pQ.add(Restrictions.eq(almac_sizechangeline.PROPERTY_QTYM2, BigDecimal.ZERO));
        sizeList = pQ.list();

        //Verifica que ningun producto tenga tamano menor a 0
        if (!sizeList.isEmpty()) {
            final OBError msg = new OBError();
            msg.setType("Error");
            msg.setTitle("Error en inventario de productos.");
            msg.setMessage(
                    "Hay piezas con que no tienen inventario y no se les puede hacer el cambio de tamao.");
            bundle.setResult(msg);
            return;
        }

        //Query para traer todas la spiezas
        pQ = obdal.createCriteria(almac_sizechangeline.class);
        pQ.add(Restrictions.eq(almac_sizechangeline.PROPERTY_ALMACSIZECHANGE, header));
        sizeList = pQ.list();

        //Modifica el inventario por medio de Physical Inventory 
        InventoryCount inv = OBProvider.getInstance().get(InventoryCount.class);
        inv.setName(header.getCommercialName() + " " + header.getCreationDate().toString());
        inv.setDescription("Ajuste de Tamao de Piezas  Ajuste:" + header.getCommercialName());
        inv.setMovementDate(new Date());
        inv.setUpdateQuantities(false);
        inv.setOrganization(header.getOrganization());
        inv.setWarehouse(header.getWarehouse());
        obdal.save(inv);
        //Ve4rifica que la lista no este vaca

        //Inicializacion de Variables 
        InventoryCountLine invline = null;
        BigDecimal qtyonhand = BigDecimal.ZERO;
        OBCriteria<StorageDetail> sdqty;
        List<StorageDetail> sdList;

        if (sizeList.isEmpty()) {
            final OBError msg = new OBError();
            msg.setType("Error");
            msg.setTitle("Lista vaca.");
            msg.setMessage("No hay piezas asignadas al documento.");
            bundle.setResult(msg);
            return;
        }

        for (almac_sizechangeline x : sizeList) {
            //Busca la cantidad actual en el sistema y si ya ha cambaido lanza un error.
            sdqty = obdal.createCriteria(StorageDetail.class);
            sdqty.add(Restrictions.eq(StorageDetail.PROPERTY_PRODUCT, x.getProduct()));
            sdqty.add(Restrictions.eq(StorageDetail.PROPERTY_ATTRIBUTESETVALUE, x.getAttributeSetValue()));
            sdList = sdqty.list();

            invline = OBProvider.getInstance().get(InventoryCountLine.class);
            invline.setOrganization(inv.getOrganization());
            invline.setPhysInventory(inv);
            invline.setLineNo(x.getLineNo());
            invline.setProduct(x.getProduct());
            invline.setStorageBin(x.getStorageBin());
            invline.setQuantityCount(((x.getHeight().divide(new BigDecimal("100"), 5, BigDecimal.ROUND_CEILING))
                    .multiply(x.getWidth().divide(new BigDecimal("100"), 5, BigDecimal.ROUND_CEILING))));
            //Pone la nueva cantidad en el sistema
            invline.setBookQuantity(sdList.get(0).getQuantityOnHand());
            invline.setUOM(x.getUOM());
            invline.setAttributeSetValue(x.getAttributeSetValue());
            obdal.save(invline);
        }
        //Se enva todo a la bsae de datos
        obdal.flush();
        obdal.refresh(inv);
        //Crea el proceso de Inventario
        InventoryCountProcess process = new InventoryCountProcess();
        //Se agrega como parametro el Id del Inventario
        Map<String, Object> param = bundle.getParams();
        param.put("M_Inventory_ID", (Object) inv.getId());
        bundle.setParams(param);

        //Se ejecuta el proceso
        process.execute(bundle);

        //Si no hay error continuar normalmente por lo que hay que cambiar de tamao las piezas
        AttributeSetInstance y = null;
        //El documento fue modificado y ya nodeberia poder modificarse nuevamente
        header.setPosted(true);
        header.setPhysInventory(inv);
        //Cambia el tamao de las piezas
        pQ = obdal.createCriteria(almac_sizechangeline.class);
        pQ.add(Restrictions.eq(almac_sizechangeline.PROPERTY_ALMACSIZECHANGE, header));
        sizeList = pQ.list();
        for (almac_sizechangeline x : sizeList) {
            y = x.getAttributeSetValue();
            y.setAlmacAlto(x.getHeight());
            y.setAlmacAncho(x.getWidth());
            y.setAlmacDescriptionmedidas(y.getAlmacAlto().toString() + " X " + y.getAlmacAncho().toString());
            obdal.save(y);
        }
        obdal.save(header);
        obdal.flush();

        // OBError is also used for successful results
        final OBError msg = new OBError();
        msg.setType("Success");
        msg.setTitle("Se ha cambiado de tamao a las piezas.");
        msg.setMessage("Se cre el Documento <" + header.getCommercialName() + " "
                + header.getCreationDate().toString() + "> en Inventaro Fsico");
        bundle.setResult(msg);

    } catch (final Exception e) {
        e.printStackTrace(System.err);
        final OBError msg = new OBError();
        msg.setType("Error");
        msg.setMessage(e.getMessage());
        msg.setTitle("Error occurred");
        bundle.setResult(msg);
    }
}

From source file:com.tegik.pcobro.module.FIN_AddPaymentTegik.java

License:Open Source License

/**
 * This method groups several payment schedule details by {PaymentDetails, OrderPaymenSchedule,
 * InvoicePaymentSchedule}.//from  w  w w. j a va  2  s.  c  om
 * 
 * @param psd
 *          Payment Schedule Detail base. The amount will be updated here.
 */
public static void mergePaymentScheduleDetails(FIN_PaymentScheduleDetail psd) {
    // FIXME: added to access the FIN_PaymentSchedule and FIN_PaymentScheduleDetail tables to be
    // removed when new security implementation is done

    OBContext.setAdminMode();
    try {
        OBCriteria<FIN_PaymentScheduleDetail> psdFilter = OBDal.getInstance()
                .createCriteria(FIN_PaymentScheduleDetail.class);
        psdFilter.add(Restrictions.eq(FIN_PaymentScheduleDetail.PROPERTY_CLIENT, psd.getClient()));
        psdFilter.add(Restrictions.eq(FIN_PaymentScheduleDetail.PROPERTY_ORGANIZATION, psd.getOrganization()));
        psdFilter.add(Restrictions.isNull(FIN_PaymentScheduleDetail.PROPERTY_PAYMENTDETAILS));
        if (psd.getOrderPaymentSchedule() == null)
            psdFilter.add(Restrictions.isNull(FIN_PaymentScheduleDetail.PROPERTY_ORDERPAYMENTSCHEDULE));
        else
            psdFilter.add(Restrictions.eq(FIN_PaymentScheduleDetail.PROPERTY_ORDERPAYMENTSCHEDULE,
                    psd.getOrderPaymentSchedule()));
        if (psd.getInvoicePaymentSchedule() == null)
            psdFilter.add(Restrictions.isNull(FIN_PaymentScheduleDetail.PROPERTY_INVOICEPAYMENTSCHEDULE));
        else
            psdFilter.add(Restrictions.eq(FIN_PaymentScheduleDetail.PROPERTY_INVOICEPAYMENTSCHEDULE,
                    psd.getInvoicePaymentSchedule()));

        // Update amount and remove payment schedule detail
        final List<String> removedPDSIds = new ArrayList<String>();
        for (FIN_PaymentScheduleDetail psdToRemove : psdFilter.list()) {
            psd.setAmount(psd.getAmount().add(psdToRemove.getAmount()));
            // TODO: Set 0 as default value for writeoffamt column in FIN_Payment_ScheduleDetail table
            BigDecimal sum1 = (psd.getWriteoffAmount() == null) ? BigDecimal.ZERO : psd.getWriteoffAmount();
            BigDecimal sum2 = (psdToRemove.getWriteoffAmount() == null) ? BigDecimal.ZERO
                    : psdToRemove.getWriteoffAmount();
            psd.setWriteoffAmount(sum1.add(sum2));

            OBDal.getInstance().save(psdToRemove);
            removedPDSIds.add(psdToRemove.getId());
        }

        for (String pdToRm : removedPDSIds) {
            OBDal.getInstance().remove(OBDal.getInstance().get(FIN_PaymentScheduleDetail.class, pdToRm));
        }

        psd.setAmount(psd.getAmount()
                .add((psd.getWriteoffAmount() == null) ? BigDecimal.ZERO : psd.getWriteoffAmount()));
        psd.setWriteoffAmount(BigDecimal.ZERO);
        psd.setPaymentDetails(null);
        OBDal.getInstance().save(psd);
        OBDal.getInstance().flush();
        OBDal.getInstance().getSession().refresh(psd);

    } catch (Exception e) {
        throw new OBException(e);
    } finally {
        OBContext.restorePreviousMode();
    }
}

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

public void addSearchCriteria() {
    mLogger.info("addSearchCriteria--Starts");
    mSearchCriteria.clear();/*from  www  . jav a2  s.  c om*/

    this.getRootPane().setDefaultButton(btnListData);

    if (sptxtRecordId.getText() != null && sptxtRecordId.getText().length() > 0) {
        mSearchCriteria.add(Restrictions.eq("taskId", new BigDecimal(sptxtRecordId.getText())));
    }

    if (sptxtReferenceNo.getText() != null && sptxtReferenceNo.getText().length() > 0) {
        mSearchCriteria.add(Restrictions.eq("taskReference", sptxtReferenceNo.getText()));
    }

    if (spcmbAssignee.getSelectedIndex() > 0) {
        mSearchCriteria.add(Restrictions.eq("assignee", ((CellDTO) spcmbAssignee.getSelectedItem()).getKey()));
    }

    if (spcmbStatus.getSelectedIndex() > 0) {
        mSearchCriteria.add(Restrictions.eq("status", ((CellDTO) spcmbStatus.getSelectedItem()).getKey()));
    }

    if (spcmbProject.getSelectedIndex() > 0) {
        mSearchCriteria
                .add(Restrictions.eq("projectName", ((CellDTO) spcmbProject.getSelectedItem()).getKey()));
    }

    if (spcmbPriority.getSelectedIndex() > 0) {
        mSearchCriteria.add(Restrictions.eq("priority", ((CellDTO) spcmbPriority.getSelectedItem()).getKey()));
    }

    /* Date Criteria */
    if (spdtAssignDateFrom.getDate() != null && spdtAssignDateTo.getDate() == null) {
        mSearchCriteria.add(Restrictions.eq("createDate", spdtAssignDateFrom.getDate()));
    }

    if (spdtAssignDateFrom.getDate() != null && spdtAssignDateTo.getDate() != null) {
        mSearchCriteria.add(
                Restrictions.between("createDate", spdtAssignDateFrom.getDate(), spdtAssignDateTo.getDate()));
    }

    if (spdtDeliveryDateFrom.getDate() != null && spdtDeliveryDateTo.getDate() == null) {
        mSearchCriteria.add(Restrictions.eq("eta", spdtDeliveryDateFrom.getDate()));
    }

    if (spdtDeliveryDateFrom.getDate() != null && spdtDeliveryDateTo.getDate() != null) {
        mSearchCriteria
                .add(Restrictions.between("eta", spdtDeliveryDateFrom.getDate(), spdtDeliveryDateTo.getDate()));
    }

    /* Date Criteria Ends */
    if (sptxtTitle.getText() != null && sptxtTitle.getText().length() > 0) {
        mSearchCriteria.add(Restrictions.ilike("title", sptxtTitle.getText(), MatchMode.ANYWHERE));
    }

    if (sptxtComment.getText() != null && sptxtComment.getText().length() > 0) {
        mSearchCriteria.add(Restrictions.ilike("commentText", sptxtComment.getText(), MatchMode.ANYWHERE));
    }

    if (sptxtModuleName.getText() != null && sptxtModuleName.getText().length() > 0) {
        mSearchCriteria.add(Restrictions.ilike("moduleName", sptxtModuleName.getText(), MatchMode.ANYWHERE));
    }

    if (spcmbTaskType.getSelectedIndex() > 0) {
        mSearchCriteria.add(Restrictions.eq("taskType", ((CellDTO) spcmbTaskType.getSelectedItem()).getKey()));
    }

    if (rdoPlanningStatus.isSelected()) {
        mSearchCriteria.add(Restrictions.isNull("eta"));
        mSearchCriteria.add(Restrictions.isNull("assignee"));
    }

    mLogger.info("addSearchCriteria--Ends");
}

From source file:com.tssa.cooperationBusiness.controller.CooperationController.java

@RequestMapping("/getProductType")
@ResponseBody/* w  ww  .  ja v  a 2s  . c  o m*/
public Map<String, Object> getProductType(HttpServletRequest request, ModelMap map) {
    List<CooperationProductType> productTypes = null;
    Map<String, Object> result = new HashMap<String, Object>();
    DetachedCriteriaTS<CooperationProductType> detachedCriteria = new DetachedCriteriaTS<CooperationProductType>(
            CooperationProductType.class);
    detachedCriteria.add(Restrictions.isNull("pareTypes"));
    productTypes = cooperationProductTypeService.getParentTypes(detachedCriteria);
    // 
    JsonConfig config = new JsonConfig();
    config.setExcludes(new String[] { "pareTypes" });
    result.put("result", JSONArray.fromObject(productTypes, config));
    // map.putAll(result);
    return result;
}

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.AchievementIconDAOImpl.java

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<AchievementIcon> filter) {
    Criteria criteria = getSession().createCriteria(AchievementIcon.class);

    if (filter instanceof AchievementIconFilter) {
        AchievementIconFilter cf = (AchievementIconFilter) filter;

        if (cf.getUnclaimed() != null) {
            if (cf.getUnclaimed()) {
                criteria.add(Restrictions.isNull("achievement"));
                criteria.add(Restrictions.isNull("proposal"));
            } else {
                Disjunction d = Restrictions.disjunction();
                d.add(Restrictions.isNotNull("achievement"));
                d.add(Restrictions.isNotNull("proposal"));
                criteria.add(d);//from ww w  .ja v a  2s .co m
            }
        }
        if (cf.getCreatorOnly() != null) {
            criteria.add(Restrictions.eq("creatorOnly", cf.getCreatorOnly()));
        } else if (cf.isCreatorOnlyAsNull()) {
            criteria.add(Restrictions.isNull("creatorOnly"));
        }
        if (cf.getApproved() != null) {
            criteria.add(Restrictions.eq("approved", cf.getApproved()));
        } else if (cf.isApprovedAsNull()) {
            criteria.add(Restrictions.isNull("approved"));
        }
        if (cf.getCreator() != null) {
            criteria.add(Restrictions.eq("creator", cf.getCreator()));
        }
    }

    return criteria;
}

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.AchievementProposalDAOImpl.java

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<AchievementProposal> filter) {
    Criteria criteria = getSession().createCriteria(AchievementProposal.class);

    if (filter instanceof AchievementProposalFilter) {
        AchievementProposalFilter cf = (AchievementProposalFilter) filter;

        if (cf.getSuggestor() != null) {
            criteria.add(Restrictions.eq("suggestor", cf.getSuggestor()));
        }/*w  w w  . j a  v  a2s  .  co m*/

        if (cf.getStartsBefore() != null) {
            criteria.add(Restrictions.le("startDate", cf.getStartsBefore()));
        }
        if (cf.getTruthsayerReviewed() != null) {
            criteria.add(Restrictions.eq("truthsayerReviewed", cf.getTruthsayerReviewed()));
        }
        if (cf.isVetoUndecided()) {
            criteria.add(Restrictions.isNull("chancellorVeto"));
        }
    }

    return criteria;
}

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.AchievementRequestDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/* w  w w .ja  v a 2s.  co  m*/
public List<AchievementRequest> getNonGroupPendingAchievementRequests() {
    Criteria criteria = getSession().createCriteria(AchievementRequest.class);

    criteria.createAlias("achievement", "achievement");
    criteria.add(Restrictions.isNull("achievement.group"));

    return criteria.list();
}

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.ChancellorElectionDAOImpl.java

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<ChancellorElection> filter) {
    Criteria criteria = getSession().createCriteria(ChancellorElection.class);

    if (filter instanceof ChancellorElectionFilter) {
        ChancellorElectionFilter f = (ChancellorElectionFilter) filter;

        if (f.getStartAfter() != null) {
            criteria.add(Restrictions.ge("start", f.getStartAfter()));
        }/*from  w w  w. ja v  a 2 s  .c om*/
        if (f.getStartBefore() != null) {
            criteria.add(Restrictions.le("start", f.getStartBefore()));
        }
        if (f.getWinner() != null) {
            criteria.add(Restrictions.eq("winner", f.getWinner()));
        } else if (f.isNoWinner()) {
            criteria.add(Restrictions.isNull("winner"));
        }
    }

    return criteria;
}