List of usage examples for org.hibernate.criterion Restrictions isNull
public static Criterion isNull(String propertyName)
From source file:com.zutubi.pulse.master.model.persistence.hibernate.HibernateBuildResultDao.java
License:Apache License
private Criteria getBuildResultCriteria(Session session, Project project, ResultState[] states, boolean includePersonal) { Criteria criteria = session.createCriteria(BuildResult.class); if (!includePersonal) { criteria.add(Restrictions.isNull("user")); }//from w w w . ja va 2 s.c o m if (project != null) { criteria.add(Restrictions.eq("project", project)); } addStatesToCriteria(states, criteria); return criteria; }
From source file:com.zutubi.pulse.master.model.persistence.hibernate.HibernateBuildResultExpressions.java
License:Apache License
public static Criterion isPersonalBuild(boolean b) { return (b) ? Restrictions.isNotNull("user") : Restrictions.isNull("user"); }
From source file:Compras.buscaPartida.java
private void buscaDato() { Session session = HibernateUtil.getSessionFactory().openSession(); session.beginTransaction();//from w w w . ja va 2 s . c o m Partida[] par; ord = (Orden) session.get(Orden.class, Integer.parseInt(orden)); System.out.println(ord.getIdOrden()); if (tipo == 1) par = (Partida[]) session.createCriteria(Partida.class) .add(Restrictions.eq("ordenByIdOrden.idOrden", ord.getIdOrden())) .add(Restrictions.eq("refComp", true)).add(Restrictions.eq("autorizadoValuacion", true)) .add(Restrictions.eq("autorizado", true)).add(Restrictions.isNull("pedido")).list() .toArray(new Partida[0]); else par = (Partida[]) session.createCriteria(Partida.class) .add(Restrictions.eq("ordenByIdOrden.idOrden", ord.getIdOrden())) .add(Restrictions.eq("refComp", true)).add(Restrictions.eq("autorizadoValuacion", true)) .add(Restrictions.eq("autorizado", true)).list().toArray(new Partida[0]); if (par.length > 0) { t_datos.setModel(this.ModeloTablaReporte(par.length, columnas)); for (int i = 0; i < par.length; i++) { model.setValueAt("" + par[i].getIdEvaluacion(), i, 0);//n model.setValueAt(par[i].getSubPartida(), i, 1);//# model.setValueAt(par[i].getCatalogo().getEspecialidad().getDescripcion(), i, 2);//grupo model.setValueAt(par[i].getCatalogo().getNombre(), i, 3);//descrip model.setValueAt(par[i].getCatalogo().getIdCatalogo(), i, 4);//fol if (par[i].getEjemplar() != null) model.setValueAt(par[i].getEjemplar().getIdParte(), i, 5);//cdigo else model.setValueAt("", i, 5); } } else t_datos.setModel(ModeloTablaReporte(0, columnas)); formatoTabla(); if (session.isOpen()) session.close(); }
From source file:Compras.ComparaCotizacion.java
void buscaPartidas() { if (ord != null) { session = HibernateUtil.getSessionFactory().openSession(); try {/*www. j a va 2 s. c o m*/ session.beginTransaction().begin(); ord = (Orden) session.get(Orden.class, ord.getIdOrden()); Partida[] cuentas = (Partida[]) session.createCriteria(Partida.class) .add(Restrictions.eq("ordenByIdOrden.idOrden", Integer.parseInt(orden))) .add(Restrictions.eq("autorizadoValuacion", true)).add(Restrictions.eq("refComp", true)) .add(Restrictions.isNull("pedido")).addOrder(Order.asc("idEvaluacion")) .addOrder(Order.asc("subPartida")).list().toArray(new Partida[0]); if (cuentas.length > 0) { model = new MyModel(cuentas.length, (String[]) columnas.toArray(new String[0]), (Class[]) tipos.toArray(new Class[0])); t_datos.setModel(model); for (int i = 0; i < cuentas.length; i++) { model.setValueAt(cuentas[i].getIdEvaluacion(), i, 0); model.setValueAt(cuentas[i].getSubPartida(), i, 1); model.setValueAt(cuentas[i].getCantidadAut(), i, 2); model.setCeldaEditable(i, 2, true); model.setValueAt(cuentas[i].getMed(), i, 3); model.setValueAt(cuentas[i].getCatalogo().getNombre(), i, 4); model.setValueAt(cuentas[i].getPrecioAutCU(), i, 5); model.setValueAt(false, i, 9); model.setValueAt(false, i, 10); model.setValueAt(false, i, 14); model.setValueAt(false, i, 15); if (model.getColumnCount() == 21) { model.setValueAt(false, i, 19); model.setValueAt(false, i, 20); } } } else { model = new MyModel(0, (String[]) columnas.toArray(new String[0]), (Class[]) tipos.toArray(new Class[0])); t_datos.setModel(model); } } catch (Exception e) { e.printStackTrace(); } finally { if (session.isOpen()) session.close(); } } }
From source file:Contabilidad.FacturarOrden.java
public void consultaOrden() { h = new Herramientas(user, 0); h.session(sessionPrograma);//from ww w. jav a2 s. com if (t_orden.getText().compareTo("") != 0) { borra_cajas(); if (orden_act != null) { Session session = HibernateUtil.getSessionFactory().openSession(); try { session.beginTransaction().begin(); orden_act = (Orden) session.get(Orden.class, orden_act.getIdOrden()); int id_fac = OrdenFacturado(orden_act); if (id_fac == -1) { t_inc.setText(orden_act.getInciso()); t_asegurado.setText(orden_act.getClientes().getNombre()); l_marca.setText(orden_act.getMarca().getIdMarca()); t_marca.setText(orden_act.getMarca().getMarcaNombre()); t_tipo.setText(orden_act.getTipo().getTipoNombre()); if (orden_act.getNoSerie() != null) t_serie.setText(orden_act.getNoSerie()); else t_serie.setText(""); t_modelo.setText("" + orden_act.getModelo()); if (orden_act.getNoPlacas() != null) t_placas.setText(orden_act.getNoPlacas()); else t_placas.setText(""); t_poliza.setText(orden_act.getPoliza()); t_siniestro.setText(orden_act.getSiniestro()); t_reporte.setText(orden_act.getNoReporte()); String tipo_cliente = orden_act.getTipoCliente(); if (tipo_cliente != null) { switch (tipo_cliente) { case "1": l_asegurado.setText("Asegurado:"); break; case "2": l_asegurado.setText("Tercero:"); break; case "3": l_asegurado.setText("Tercero Asegurado:"); break; case "4": l_asegurado.setText("Particular"); break; } } //cargar las partidas b_guardar.setEnabled(true); c_cliente.setEnabled(true); habilita(true); Partida[] partidas = (Partida[]) session.createCriteria(Partida.class) .add(Restrictions.eq("ordenByIdOrden.idOrden", orden_act.getIdOrden())) .add(Restrictions.eq("facturado", true)).add(Restrictions.eq("incluida", false)) .add(Restrictions.isNull("ordenByEnlazada")).addOrder(Order.asc("idEvaluacion")) .addOrder(Order.asc("subPartida")).list().toArray(new Partida[0]); Partida[] enlazadas = (Partida[]) session.createCriteria(Partida.class) .add(Restrictions.eq("ordenByEnlazada.idOrden", orden_act.getIdOrden())) .add(Restrictions.eq("incluida", true)).addOrder(Order.asc("idEvaluacion")) .addOrder(Order.asc("subPartida")).list().toArray(new Partida[0]); //Partida[] enlazadas = (Partida[])orden_act.getPartidasForEnlazada().toArray(new Partida[0]); Adicionales[] adicionales = (Adicionales[]) orden_act.getAdicionaleses() .toArray(new Adicionales[0]); DefaultTableModel modelo = ModeloTablaReporte(0, columnas); for (int a = 0; a < partidas.length; a++) { String noParte = ""; if (partidas[a].getEjemplar() != null) noParte = partidas[a].getEjemplar().getIdParte(); double descuento = 0.0d;//descuento de la partida double total = (partidas[a].getPrecioFactura() * partidas[a].getCantidadFactura()) * (1 + (descuento / 100)); modelo.addRow(new Object[] { partidas[a].getCantidadFactura(), partidas[a].getMed(), partidas[a].getDescripcionFactura(), noParte, partidas[a].getPrecioFactura(), descuento, total }); } for (int b = 0; b < enlazadas.length; b++) { String noParte2 = ""; if (enlazadas[b].getEjemplar() != null) noParte2 = enlazadas[b].getEjemplar().getIdParte(); double descuento2 = 0.0;//descuento de la partida double total2 = (enlazadas[b].getPrecioFactura() * enlazadas[b].getCantidadFactura()) * (1 + (descuento2 / 100)); modelo.addRow(new Object[] { enlazadas[b].getCantidadFactura(), enlazadas[b].getMed(), enlazadas[b].getDescripcionFactura(), noParte2, enlazadas[b].getPrecioFactura(), descuento2, total2 }); } for (int c = 0; c < adicionales.length; c++) { double descuento3 = adicionales[c].getDescuento();//descuento de la partida double total3 = (adicionales[c].getPrecio() * adicionales[c].getCantidad()) * (1 + (descuento3 / 100)); modelo.addRow(new Object[] { adicionales[c].getCantidad(), adicionales[c].getMedida(), adicionales[c].getDescripcion(), "", adicionales[c].getPrecio(), descuento3, total3 }); } if (orden_act.getMoDirecta() > 0.0d) { modelo.addRow(new Object[] { 1.0, "NA", "MANO DE OBRA", "", orden_act.getMoDirecta(), 0.0, orden_act.getMoDirecta() }); } else { Query query = session .createQuery("SELECT SUM( " + "(CASE WHEN dm>0 THEN (dm*cant) ELSE 0 END) + " + "(CASE WHEN cam>0 THEN (cam*cant) ELSE 0 END) + " + "(CASE WHEN repMin>0 THEN (repMin*cant) ELSE 0 END) + " + "(CASE WHEN repMed>0 THEN (repMed*cant) ELSE 0 END) + " + "(CASE WHEN repMax>0 THEN (repMax*cant) ELSE 0 END) + " + "(CASE WHEN pint>0 THEN (pint*cant) ELSE 0 END) " + ") from Partida " + "where ordenByIdOrden.idOrden =" + orden_act.getIdOrden() + " or ordenByEnlazada.idOrden=" + orden_act.getIdOrden()); Object ent = query.uniqueResult(); if (ent != null) { double res = orden_act.getCompania().getImporteHora() * Double.parseDouble(ent.toString()); if (res > 0.0d) modelo.addRow(new Object[] { 1.0, "NA", "MANO DE OBRA", "", res, 0.0, res }); } /*else { modelo.addRow(new Object[]{1.0, "NA", "MANO DE OBRA", "", 0.0, 0.0, 0.0}); }*/ } Configuracion configuracion = (Configuracion) session.get(Configuracion.class, 1); iva = configuracion.getIva(); session.beginTransaction().commit(); t_datos.setModel(modelo); formatoTabla(); cargaCliente(); } else { orden_act = null; t_orden.setText(""); borra_cajas(); b_guardar.setEnabled(false); c_cliente.setEnabled(false); habilita(false); JOptionPane.showMessageDialog(null, "La orden ya fue Facturada con la Factura No:" + id_fac); t_orden.requestFocus(); } } catch (HibernateException he) { he.printStackTrace(); session.getTransaction().rollback(); orden_act = null; t_orden.setText(""); borra_cajas(); b_guardar.setEnabled(false); c_cliente.setEnabled(false); habilita(false); JOptionPane.showMessageDialog(null, "Error al consultar la Orden"); t_orden.requestFocus(); } finally { if (session != null) if (session.isOpen()) session.close(); } } else { orden_act = null; t_orden.setText(""); borra_cajas(); b_guardar.setEnabled(false); c_cliente.setEnabled(false); habilita(false); JOptionPane.showMessageDialog(null, "El nmero de orden no existe!"); t_orden.requestFocus(); } } else { orden_act = null; borra_cajas(); this.orden_act = null; b_guardar.setEnabled(false); c_cliente.setEnabled(false); habilita(false); } sumaTotales(); this.updateUI(); }
From source file:corner.orm.hibernate.expression.NewExpressionExample.java
License:Apache License
/** * @see org.hibernate.criterion.Example#appendPropertyCondition(java.lang.String, * java.lang.Object, org.hibernate.Criteria, * org.hibernate.criterion.CriteriaQuery, java.lang.StringBuffer) *//*from www. j a v a2s . com*/ @Override protected void appendPropertyCondition(String propertyName, Object propertyValue, Criteria criteria, CriteriaQuery cq, StringBuffer buf) throws HibernateException { Criterion crit; if (propertyValue != null) { boolean isString = propertyValue instanceof String; QueryType qt = this.worker.getQueryTypeByPropertyName(propertyName); if (qt == QueryType.Date) {// crit = new DateExpression(propertyName, (String) propertyValue); } else if (qt == QueryType.String || isString) {// String op = isLikeEnabled && isString ? " like " : "="; crit = new StringExpression(propertyName, propertyValue.toString(), op, isIgnoreCaseEnabled && isString); } else {// crit = Restrictions.eq(propertyName, propertyValue); } } else { crit = Restrictions.isNull(propertyName); } String critCondition = crit.toSqlString(criteria, cq); if (buf.length() > 1 && critCondition.trim().length() > 0) buf.append(" and "); buf.append(critCondition); }
From source file:cpcc.vvrte.services.db.VvRteRepositoryImpl.java
License:Open Source License
/** * {@inheritDoc}/*from ww w. j ava2 s . co m*/ */ @SuppressWarnings("unchecked") @Override public List<VirtualVehicle> findAllStuckVehicles(Set<VirtualVehicleState> allowedStates) { List<VirtualVehicle> vvs = new ArrayList<VirtualVehicle>(); vvs.addAll( (List<VirtualVehicle>) session.createCriteria(VirtualVehicle.class, "v") .add(Restrictions.in("state", allowedStates)).createCriteria("v.task", "t", JoinType.LEFT_OUTER_JOIN, Restrictions.eq("taskState", TaskState.COMPLETED)) .list()); vvs.addAll((List<VirtualVehicle>) session.createCriteria(VirtualVehicle.class) .add(Restrictions.eq("state", VirtualVehicleState.TASK_COMPLETION_AWAITED)) .add(Restrictions.isNull("task")).list()); vvs.addAll((List<VirtualVehicle>) session.createCriteria(VirtualVehicle.class) .add(Restrictions.eq("state", VirtualVehicleState.MIGRATION_AWAITED_SND)) .add(Restrictions.le("migrationStartTime", new Date(timeService.currentTimeMillis() - 10000))) .list()); vvs.addAll((List<VirtualVehicle>) session.createCriteria(VirtualVehicle.class).add(Restrictions.in("state", Arrays.asList(VirtualVehicleState.MIGRATING_SND, VirtualVehicleState.MIGRATION_INTERRUPTED_SND, VirtualVehicleState.MIGRATION_COMPLETED_SND))) .add(Restrictions.le("updateTime", new Date(timeService.currentTimeMillis() - 55000))).list()); vvs.addAll((List<VirtualVehicle>) session.createCriteria(VirtualVehicle.class) .add(Restrictions.eq("state", VirtualVehicleState.MIGRATING_RCV)) .add(Restrictions.le("updateTime", new Date(timeService.currentTimeMillis() - 175000))).list()); return vvs; }
From source file:cz.cuni.mff.ufal.lindat.utilities.HibernateFunctionalityManager.java
License:Open Source License
@Override public List<UserMetadata> getUserMetadata(int epersonId) { return (List<UserMetadata>) hibernateUtil.findByCriterie(UserMetadata.class, Restrictions.and(Restrictions.eq("userRegistration.epersonId", epersonId), Restrictions.isNull("licenseResourceUserAllowance"))); }
From source file:cz.cuni.mff.ufal.lindat.utilities.HibernateFunctionalityManager.java
License:Open Source License
@Override public UserMetadata getUserMetadata(int epersonId, String key) { List<UserMetadata> metadata = (List<UserMetadata>) hibernateUtil.findByCriterie(UserMetadata.class, Restrictions.and(Restrictions.eq("userRegistration.epersonId", epersonId), Restrictions.eq("metadataKey", key), Restrictions.isNull("licenseResourceUserAllowance"))); if (metadata != null && metadata.size() > 0) { return metadata.get(0); }//from w ww . j a v a 2 s. c om return null; }
From source file:cz.jirutka.rsql.hibernate.AbstractCriterionBuilder.java
License:Open Source License
/** * Apply an "is null" constraint to the named property. * * @param propertyPath property name prefixed with an association alias * @return Criterion/*from www . j a v a2 s . c o m*/ */ protected Criterion createIsNull(String propertyPath) { return Restrictions.isNull(propertyPath); }