List of usage examples for org.hibernate.criterion DetachedCriteria createAlias
public DetachedCriteria createAlias(String associationPath, String alias)
From source file:com.ut.tekir.report.AccountStatusReportBean.java
License:LGPL
public DetachedCriteria buildCriteria() { DetachedCriteria crit = DetachedCriteria.forClass(AccountTxn.class); crit.createAlias("account", "account"); crit.setProjection(Projections.projectionList() .add(Projections.groupProperty("account.code"), "accountCode") .add(Projections.groupProperty("account.name"), "accountName") .add(Projections.groupProperty("amount.currency"), "currency") .add(Projections.sum("amount.value"), "amount") .add(Projections.sum("amount.localAmount"), "localAmount") .add(Projections.property("this.processType"), "processType") .add(Projections.sqlGroupProjection( "{alias}.CCY as currency, sum( ( case {alias}.finance_action when 0 then 1 else -1 end ) * {alias}.CCYVAL ) as AMOUNT, sum( case {alias}.finance_action when 0 then {alias}.CCYVAL else 0 end ) as DEBIT, sum( case {alias}.finance_action when 0 then 0 else {alias}.CCYVAL end ) as CREDIT", "CCY", new String[] { "currency", "amount", "debit", "credit" }, new Type[] { Hibernate.STRING, Hibernate.BIG_DECIMAL, Hibernate.BIG_DECIMAL, Hibernate.BIG_DECIMAL }))); crit.add(Restrictions.eq("active", true)); if (code != null && code.length() > 0) { crit.add(Restrictions.ilike("code", code, MatchMode.START)); }/*w ww .j av a 2 s. c om*/ if (account != null) { crit.add(Restrictions.eq("account", account)); } if (beginDate != null) { crit.add(Restrictions.ge("date", beginDate)); } if (endDate != null) { crit.add(Restrictions.le("date", endDate)); } if (getDocumentType() != null && getDocumentType() != DocumentType.Unknown) { crit.add(Restrictions.eq("documentType", getDocumentType())); } if (getProcessType() != null) { crit.add(Restrictions.eq("this.processType", getProcessType())); } if (getWorkBunch() != null) { crit.add(Restrictions.eq("workBunch", getWorkBunch())); } crit.addOrder(Order.asc("account.code")); return crit; }
From source file:com.ut.tekir.report.AccountTxnReportBean.java
License:LGPL
public DetachedCriteria buildCriteria() { DetachedCriteria crit = DetachedCriteria.forClass(AccountTxn.class); crit.createAlias("account", "account"); crit.add(Restrictions.eq("active", true)); if (getSerial() != null && getSerial().length() > 0) { crit.add(Restrictions.ilike("serial", getSerial(), MatchMode.START)); }//www.j a v a 2s . c o m if (getReference() != null && getReference().length() > 0) { crit.add(Restrictions.ilike("reference", getReference(), MatchMode.START)); } if (getCode() != null && getCode().length() > 0) { crit.add(Restrictions.ilike("code", getCode(), MatchMode.START)); } if (getAccount() != null) { crit.add(Restrictions.eq("account", getAccount())); } if (getDocumentType() != null && getDocumentType() != DocumentType.Unknown) { crit.add(Restrictions.eq("documentType", getDocumentType())); } if (getBeginDate() != null) { crit.add(Restrictions.ge("date", getBeginDate())); } if (getEndDate() != null) { crit.add(Restrictions.le("date", getEndDate())); } if (getProcessType() != null) { crit.add(Restrictions.eq("processType", getProcessType())); } if (getWorkBunch() != null) { crit.add(Restrictions.eq("workBunch", getWorkBunch())); } if (getAdverseCode() != null && getAdverseCode().length() > 0) { crit.add(Restrictions.ilike("this.adverseCode", getAdverseCode(), MatchMode.START)); } if (getAdverseName() != null && getAdverseName().length() > 0) { crit.add(Restrictions.ilike("this.adverseName", getAdverseName(), MatchMode.START)); } if (getCurrency() != null) { crit.add(Restrictions.eq("this.amount.currency", getCurrency())); } crit.add(Restrictions.eq("this.active", true)); crit.addOrder(Order.desc("this.date")); crit.addOrder(Order.desc("this.id")); //crit.addOrder(Order.desc("this.serial")); //crit.addOrder(Order.asc("account.code")); //crit.addOrder(Order.asc("documentType")); return crit; }
From source file:com.ut.tekir.report.BankStatusReportBean.java
License:LGPL
public DetachedCriteria buildCriteria() { DetachedCriteria crit = DetachedCriteria.forClass(BankTxn.class); crit.createAlias("bankAccount", "bankAccount"); crit.createAlias("bankAccount.bankBranch", "bankBranch"); crit.createAlias("bankAccount.bankBranch.bank", "bank"); crit.setProjection(Projections.projectionList() .add(Projections.groupProperty("bankAccount.accountNo"), "bankAccount") .add(Projections.groupProperty("bankBranch.name"), "bankBranchName") .add(Projections.groupProperty("bank.name"), "bankName") .add(Projections.groupProperty("amount.currency"), "currency") .add(Projections.sum("amount.value"), "amount") .add(Projections.property("processType"), "processType") .add(Projections.sum("amount.localAmount"), "localAmount") .add(Projections.sqlGroupProjection( "{alias}.CCY as currency, sum( ( case {alias}.action when 0 then 1 else -1 end ) * {alias}.CCYVAL ) as AMOUNT, sum( case {alias}.action when 0 then {alias}.CCYVAL else 0 end ) as DEBIT, sum( case {alias}.action when 0 then 0 else {alias}.CCYVAL end ) as CREDIT", "{alias}.CCY", new String[] { "currency", "amount", "debit", "credit" }, new Type[] { Hibernate.STRING, Hibernate.BIG_DECIMAL, Hibernate.BIG_DECIMAL, Hibernate.BIG_DECIMAL }))); crit.add(Restrictions.eq("active", true)); if (bankAccount != null) { crit.add(Restrictions.eq("this.bankAccount", bankAccount)); } else {/*from w w w. ja v a 2 s .c om*/ if (bankBranch != null) { crit.add(Restrictions.eq("bankAccount.bankBranch", bankBranch)); } else { if (bank != null) { crit.add(Restrictions.eq("bankBranch.bank", bank)); } } } if (code != null && code.length() > 0) { crit.add(Restrictions.ilike("code", code, MatchMode.START)); } if (beginDate != null) { crit.add(Restrictions.ge("date", beginDate)); } if (endDate != null) { crit.add(Restrictions.le("date", endDate)); } if (getWorkBunch() != null) { crit.add(Restrictions.eq("workBunch", getWorkBunch())); } if (getDocumentType() != null && getDocumentType() != DocumentType.Unknown) { crit.add(Restrictions.eq("documentType", getDocumentType())); } if (getProcessType() != null) { crit.add(Restrictions.eq("this.processType", getProcessType())); } crit.addOrder(Order.asc("bankAccount.name")); return crit; }
From source file:com.ut.tekir.report.BankTxnReportBean.java
License:LGPL
public DetachedCriteria buildCriteria() { DetachedCriteria crit = DetachedCriteria.forClass(BankTxn.class); crit.createAlias("bankAccount", "bankAccount"); if (getBankAccount() != null) { crit.add(Restrictions.eq("bankAccount", getBankAccount())); } else {/* w w w .j a va2s.c o m*/ if (getBankBranch() != null) { crit.createAlias("bankAccount.bankBranch", "bankBranch"); crit.add(Restrictions.eq("bankAccount.bankBranch", getBankBranch())); } else { if (getBank() != null) { crit.createAlias("bankAccount.bankBranch", "bankBranch"); crit.createAlias("bankAccount.bankBranch.bank", "bank"); crit.add(Restrictions.eq("bankBranch.bank", getBank())); } } } if (getSerial() != null && getSerial().length() > 0) { crit.add(Restrictions.ilike("serial", getSerial(), MatchMode.START)); } if (getReference() != null && getReference().length() > 0) { crit.add(Restrictions.ilike("reference", getReference(), MatchMode.START)); } if (getCode() != null && getCode().length() > 0) { crit.add(Restrictions.ilike("code", getCode(), MatchMode.START)); } if (getDocumentType() != null && getDocumentType() != DocumentType.Unknown) { crit.add(Restrictions.eq("documentType", getDocumentType())); } if (getBeginDate() != null) { crit.add(Restrictions.ge("date", getBeginDate())); } if (getEndDate() != null) { crit.add(Restrictions.le("date", getEndDate())); } if (getAdverseCode() != null) { crit.add(Restrictions.ilike("adverseCode", getAdverseCode(), MatchMode.START)); } if (getAdverseName() != null) { crit.add(Restrictions.ilike("adverseName", getAdverseName(), MatchMode.START)); } if (getWorkBunch() != null) { crit.add(Restrictions.eq("workBunch", getWorkBunch())); } if (getProcessType() != null) { crit.add(Restrictions.eq("this.processType", getProcessType())); } crit.add(Restrictions.eq("this.active", true)); crit.addOrder(Order.desc("this.date")); crit.addOrder(Order.desc("this.serial")); crit.addOrder(Order.desc("this.id")); //crit.addOrder(Order.asc("documentType")); //crit.addOrder(Order.asc("bankAccount")); return crit; }
From source file:com.ut.tekir.report.ContactStatusReportBean.java
License:LGPL
public DetachedCriteria buildCriteria() { DetachedCriteria crit = DetachedCriteria.forClass(FinanceTxn.class); crit.createAlias("contact", "contact"); crit.setProjection(Projections.projectionList().add(Projections.groupProperty("contact.code"), "concode") .add(Projections.groupProperty("contact.fullname"), "conname") .add(Projections.groupProperty("contact.company"), "company") .add(Projections.groupProperty("contact.person"), "person") //.add( Projections.groupProperty("action"), "action" ) //.add( Projections.groupProperty("amount.currency"), "currency" ) .add(Projections.sum("amount.value"), "amount") .add(Projections.sum("amount.localAmount"), "localAmount") .add(Projections.sqlGroupProjection( "{alias}.CCY as currency, sum( case {alias}.finance_action when 0 then {alias}.CCYVAL else 0 end ) as DEBIT, sum( case {alias}.finance_action when 0 then 0 else {alias}.CCYVAL end ) as CREDIT", "{alias}.CCY", new String[] { "currency", "debit", "credit" }, new Type[] { Hibernate.STRING, Hibernate.BIG_DECIMAL, Hibernate.BIG_DECIMAL }))); if (fm.getActive() != null) { crit.add(Restrictions.eq("active", fm.getActive())); }/* w w w .java2 s. c o m*/ if (StringUtils.isNotEmpty(fm.getCode())) { crit.add(Restrictions.ilike("contact.code", fm.getCode(), MatchMode.START)); } if (StringUtils.isNotEmpty(fm.getName())) { crit.add(Restrictions.ilike("contact.name", fm.getName(), MatchMode.START)); } if (fm.getCategory() != null) { crit.add(Restrictions.eq("contact.category", fm.getCategory())); } if (fm.getBeginDate() != null) { crit.add(Restrictions.ge("date", fm.getBeginDate())); } if (fm.getEndDate() != null) { crit.add(Restrictions.le("date", fm.getEndDate())); } if (fm.getCompanyType() != null && !fm.getCompanyType().equals("All")) { if (fm.getCompanyType().equals("Person")) { crit.add(Restrictions.eq("contact.person", Boolean.TRUE)); } else crit.add(Restrictions.eq("contact.person", Boolean.FALSE)); } if (fm.getType() != null && fm.getType() != ContactType.All) { crit.add(Restrictions.eq("contact." + fm.getType().toString().toLowerCase() + "Type", Boolean.TRUE)); } if (StringUtils.isNotEmpty(fm.getExCode1())) { crit.add(Restrictions.ilike("contact.exCode1", fm.getExCode1(), MatchMode.START)); } if (StringUtils.isNotEmpty(fm.getExCode2())) { crit.add(Restrictions.ilike("contact.exCode2", fm.getExCode2(), MatchMode.START)); } if (fm.getOrganization() != null) { crit.add(Restrictions.eq("contact.organization", fm.getOrganization())); } if (StringUtils.isNotEmpty(fm.getDocCode())) { crit.add(Restrictions.ilike("code", fm.getDocCode(), MatchMode.START)); } if (fm.getDocumentType() != null && fm.getDocumentType() != DocumentType.Unknown) { crit.add(Restrictions.eq("this.documentType", fm.getDocumentType())); } if (fm.getProcessType() != null) { crit.add(Restrictions.eq("this.processType", fm.getProcessType())); } if (fm.getWorkBunch() != null) { crit.add(Restrictions.eq("this.workBunch", fm.getWorkBunch())); } if (fm.getContact() != null) { crit.add(Restrictions.eq("contact.id", fm.getContact().getId())); } /* crit.addOrder( Order.asc("date")); crit.addOrder( Order.asc("serial")); * */ crit.addOrder(Order.asc("contact.code")); crit.addOrder(Order.asc("amount.currency")); log.debug("Sonu : #0", crit); return crit; }
From source file:com.ut.tekir.report.ProductStatusReportBean.java
License:LGPL
public DetachedCriteria buildCriteria() { DetachedCriteria crit = DetachedCriteria.forClass(ProductTxn.class); crit.createAlias("product", "product"); crit.createAlias("warehouse", "warehouse"); //TODO: Unit Price'n farkl dvizlerde olma sorunu zle... ProjectionList pl = Projections.projectionList(); pl.add(Projections.groupProperty("product.code"), "prodcode") .add(Projections.groupProperty("product.name"), "prodname") //.add( Projections.groupProperty("action"), "action" ) //.add( Projections.groupProperty("amount.currency"), "currency" ) .add(Projections.groupProperty("product.group"), "group") .add(Projections.groupProperty("product.barcode1"), "barcode") .add(Projections.sum("quantity.value"), "quantity") .add(Projections.avg("unitPrice.value"), "unitPrice") .add(Projections.sqlGroupProjection("{alias}.UNIT as unit, " + //"sum( case {alias}.finance_action when 0 then {alias}.QUANTITY else 0 end ) as INQTY, " + //"sum( case {alias}.finance_action when 0 then 0 else {alias}.QUANTITY end ) as OUTQTY", "sum( case {alias}.trade_action when 0 then {alias}.QUANTITY else 0 end ) as INQTY, " + "sum( case {alias}.trade_action when 1 then {alias}.QUANTITY else 0 end ) as OUTQTY , " + "sum( case {alias}.trade_action when 2 then {alias}.QUANTITY else 0 end ) as BUYRETQTY, " + "sum( case {alias}.trade_action when 3 then {alias}.QUANTITY else 0 end ) as SELLRETQTY, " + "sum( case {alias}.trade_action when 6 then {alias}.QUANTITY else 0 end ) as RESQTY , " + "sum( case {alias}.trade_action when 7 then {alias}.QUANTITY else 0 end ) as DELQTY ", "UNIT", new String[] { "unit", "inqty", "outqty", "buyretqty", "sellretqty", "resqty", "delqty" }, new Type[] { Hibernate.STRING, Hibernate.DOUBLE, Hibernate.DOUBLE, Hibernate.DOUBLE, Hibernate.DOUBLE, Hibernate.DOUBLE, Hibernate.DOUBLE })); if (warehouseBase) { //Depo krlml pl.add(Projections.groupProperty("warehouse.code"), "warecode") .add(Projections.groupProperty("warehouse.name"), "warename"); crit.addOrder(Order.asc("warehouse.code")); }// w w w .j a va 2s.c o m crit.setProjection(pl); crit.add(Restrictions.eq("active", true)); if (code != null && code.length() > 0) { crit.add(Restrictions.ilike("product.code", code, MatchMode.START)); } if (name != null && name.length() > 0) { crit.add(Restrictions.ilike("product.name", name, MatchMode.START)); } if (productType != null) { if (getProductType() == 1) { crit.add(Restrictions.like("this.productType", ProductType.Product)); } else if (getProductType() == 2) { crit.add(Restrictions.like("this.productType", ProductType.Service)); } } if (barcode != null && barcode.length() > 0) { Criterion criteria1 = Restrictions.like("product.barcode1", barcode, MatchMode.START); Criterion criteria2 = Restrictions.like("product.barcode2", barcode, MatchMode.START); Criterion criteria3 = Restrictions.like("product.barcode3", barcode, MatchMode.START); crit.add(Restrictions.or(criteria1, Restrictions.or(criteria2, criteria3))); } if (group != null) { crit.add(Restrictions.eq("product.group", group)); } if (warehouse != null) { crit.add(Restrictions.eq("warehouse", warehouse)); } if (beginDate != null) { crit.add(Restrictions.ge("date", beginDate)); } if (endDate != null) { crit.add(Restrictions.le("date", endDate)); } if (category != null) { crit.add(Restrictions.eq("product.category", category)); } if (docCode != null && docCode.length() > 0) { crit.add(Restrictions.ilike("code", docCode, MatchMode.START)); } if (getDocumentType() != null && getDocumentType() != DocumentType.Unknown) { crit.add(Restrictions.eq("this.documentType", getDocumentType())); } if (getWorkBunch() != null) { crit.add(Restrictions.eq("this.workBunch", getWorkBunch())); } /* crit.addOrder( Order.asc("date")); crit.addOrder( Order.asc("serial")); * */ crit.addOrder(Order.asc("product.name")); log.debug("Sonu : #0", crit); return crit; }
From source file:com.ut.tekir.report.SaleInvoiceReportBean.java
License:LGPL
@Override public DetachedCriteria buildCriteria() { DetachedCriteria crit = DetachedCriteria.forClass(TekirInvoice.class); crit.createAlias("this.contact", "contact"); if (isNotEmpty(filterModel.getSerial())) { crit.add(Restrictions.ilike("this.serial", filterModel.getSerial(), MatchMode.START)); }//from ww w . j a va2 s .c om if (isNotEmpty(filterModel.getReference())) { crit.add(Restrictions.ilike("this.reference", filterModel.getReference(), MatchMode.START)); } if (isNotEmpty(filterModel.getCode())) { crit.add(Restrictions.ilike("this.code", filterModel.getCode(), MatchMode.START)); } if (filterModel.getBeginDate() != null) { crit.add(Restrictions.ge("this.date", filterModel.getBeginDate())); } if (filterModel.getEndDate() != null) { crit.add(Restrictions.le("this.date", filterModel.getEndDate())); } if (isNotEmpty(filterModel.getContactCode())) { crit.add(Restrictions.ilike("contact.code", filterModel.getContactCode(), MatchMode.START)); } if (isNotEmpty(filterModel.getContactName())) { crit.add(Restrictions.ilike("contact.fullname", filterModel.getContactName(), MatchMode.START)); } crit.add(Restrictions.or(Restrictions.eq("this.tradeAction", TradeAction.Sale), Restrictions.eq("this.tradeAction", TradeAction.SaleReturn))); crit.add(Restrictions.or(Restrictions.eq("this.documentType", DocumentType.RetailSaleShipmentInvoice), Restrictions.or(Restrictions.eq("this.documentType", DocumentType.SaleInvoice), Restrictions.eq("this.documentType", DocumentType.SaleShipmentInvoice)))); crit.addOrder(Order.desc("this.serial")); crit.addOrder(Order.desc("this.date")); return crit; }
From source file:com.ut.tekir.stock.ProductTxnReportBean.java
License:LGPL
@Override public DetachedCriteria buildCriteria() { DetachedCriteria crit = DetachedCriteria.forClass(ProductTxn.class); crit.createAlias("product", "product"); crit.createAlias("warehouse", "warehouse"); crit.createAlias("workBunch", "workBunch", Criteria.LEFT_JOIN); crit.setProjection(Projections.projectionList().add(Projections.property("documentType"), "documentType") .add(Projections.property("documentId"), "documentId") .add(Projections.property("product.id"), "productId").add(Projections.property("serial"), "serial") .add(Projections.property("reference"), "reference").add(Projections.property("code"), "code") .add(Projections.property("date"), "date").add(Projections.property("warehouse.name"), "wareName") .add(Projections.property("product.name"), "prodName") .add(Projections.property("product.code"), "prodCode") .add(Projections.property("product.group"), "group") .add(Projections.property("product.barcode1"), "barcode") .add(Projections.property("adverseCode"), "adverseCode") .add(Projections.property("adverseName"), "adverseName").add(Projections.property("info"), "info") .add(Projections.property("action"), "action") .add(Projections.property("quantity.value"), "quantityValue") .add(Projections.property("quantity.unit"), "quantityUnit") .add(Projections.property("unitPrice.currency"), "unitPriceCurrency") .add(Projections.property("unitPrice.value"), "unitPriceValue") .add(Projections.property("financeAction"), "financeAction") .add(Projections.property("workBunch.code"), "workBunchCode")); crit.setResultTransformer(Transformers.aliasToBean(ProductTxnModel.class)); if (isNotEmpty(filterModel.getSerial())) { crit.add(Restrictions.ilike("this.serial", filterModel.getSerial(), MatchMode.START)); }/*from www.j a va2 s. c o m*/ if (isNotEmpty(filterModel.getProductCode())) { crit.add(Restrictions.ilike("product.code", filterModel.getProductCode(), MatchMode.START)); } if (isNotEmpty(filterModel.getAdverseCode())) { crit.add(Restrictions.ilike("this.adverseCode", filterModel.getAdverseCode(), MatchMode.START)); } if (isNotEmpty(filterModel.getAdverseName())) { crit.add(Restrictions.ilike("this.adverseName", filterModel.getAdverseName(), MatchMode.START)); } if (filterModel.getGroup() != null) { crit.add(Restrictions.eq("product.group", filterModel.getGroup())); } if (filterModel.getBarcode() != null && filterModel.getBarcode().length() > 0) { Criterion criteria1 = Restrictions.like("product.barcode1", filterModel.getBarcode(), MatchMode.START); Criterion criteria2 = Restrictions.like("product.barcode2", filterModel.getBarcode(), MatchMode.START); Criterion criteria3 = Restrictions.like("product.barcode3", filterModel.getBarcode(), MatchMode.START); crit.add(Restrictions.or(criteria1, Restrictions.or(criteria2, criteria3))); } if (isNotEmpty(filterModel.getProductName())) { crit.add(Restrictions.ilike("product.name", filterModel.getProductName(), MatchMode.START)); } if (filterModel.getProductType() != null) { if (filterModel.getProductType() == 1) { crit.add(Restrictions.like("this.productType", ProductType.Product)); } else if (filterModel.getProductType() == 2) { crit.add(Restrictions.like("this.productType", ProductType.Service)); } } if (isNotEmpty(filterModel.getReference())) { crit.add(Restrictions.ilike("this.reference", filterModel.getReference(), MatchMode.START)); } if (isNotEmpty(filterModel.getCode())) { crit.add(Restrictions.ilike("this.code", filterModel.getCode(), MatchMode.START)); } if (filterModel.getBeginDate() != null) { crit.add(Restrictions.ge("this.date", filterModel.getBeginDate())); } if (filterModel.getEndDate() != null) { crit.add(Restrictions.le("this.date", filterModel.getEndDate())); } if (filterModel.getContact() != null) { crit.add(Restrictions.eq("contact", filterModel.getContact())); } if (filterModel.getWarehouse() != null) { crit.add(Restrictions.eq("warehouse", filterModel.getWarehouse())); } if (filterModel.getCategory() != null) { crit.add(Restrictions.eq("product.category", filterModel.getCategory())); } if (filterModel.getProduct() != null) { crit.add(Restrictions.eq("product", filterModel.getProduct())); } if (filterModel.getWorkBunch() != null) { crit.add(Restrictions.eq("workBunch", filterModel.getWorkBunch())); } if (filterModel.getDocumentType() != null && filterModel.getDocumentType() != DocumentType.Unknown) { crit.add(Restrictions.eq("this.documentType", filterModel.getDocumentType())); } /* if( filterModel.getLocalCurrencyOnly()){ crit.setProjection( Projections.projectionList() .add( Projections.groupProperty("documentType"), "documentType" ) .add( Projections.groupProperty("documentId"), "documentId" ) .add( Projections.groupProperty("serial"), "serial" ) .add( Projections.groupProperty("reference"), "reference" ) .add( Projections.groupProperty("date"), "date" ) .add( Projections.groupProperty("contact"), "contact" ) .add( Projections.groupProperty("code"), "code" ) .add( Projections.groupProperty("info"), "info" ) .add( Projections.groupProperty("action"), "action" ) .add( Projections.sum("localAmount.value"), "localAmount" ) ); } */ crit.add(Restrictions.eq("this.active", true)); crit.addOrder(Order.desc("this.date")); crit.addOrder(Order.desc("this.id")); //crit.addOrder(Order.asc("warehouse")); //crit.addOrder(Order.desc("this.serial")); //crit.addOrder(Order.asc("product")); log.debug("Sonu : #0", crit); return crit; }
From source file:com.ut.tekir.stock.ProductTxnReportBean.java
License:LGPL
public DetachedCriteria buildCriteriaForPrice(TradeAction tradeAction) { DetachedCriteria crit = DetachedCriteria.forClass(ProductTxn.class); crit.createAlias("product", "product"); crit.createAlias("warehouse", "warehouse"); crit.setProjection(Projections.projectionList().add(Projections.property("documentType"), "documentType") .add(Projections.property("documentId"), "documentId").add(Projections.property("code"), "code") .add(Projections.property("action"), "action") .add(Projections.property("warehouse.name"), "wareName") .add(Projections.property("product.id"), "prodId") .add(Projections.property("product.name"), "prodName") .add(Projections.property("product.code"), "prodCode") .add(Projections.property("product.barcode1"), "barcode") .add(Projections.property("product.barcode2"), "barcode2") .add(Projections.property("product.barcode3"), "barcode3") .add(Projections.property("product.buyTax"), "buyTax1") .add(Projections.property("product.buyTax2"), "buyTax2") .add(Projections.property("product.buyTax3"), "buyTax3") .add(Projections.property("product.buyTax4"), "buyTax4") .add(Projections.property("product.buyTax5"), "buyTax5") .add(Projections.property("product.sellTax"), "sellTax1") .add(Projections.property("product.sellTax2"), "sellTax2") .add(Projections.property("product.sellTax3"), "sellTax3") .add(Projections.property("product.sellTax4"), "sellTax4") .add(Projections.property("product.sellTax5"), "sellTax5") .add(Projections.property("product.labelName"), "labelName") .add(Projections.property("quantity.value"), "quantityValue") .add(Projections.property("quantity.unit"), "quantityUnit") .add(Projections.property("unitPrice.currency"), "unitPriceCurrency") .add(Projections.property("unitPrice.value"), "unitPriceValue") .add(Projections.property("financeAction"), "financeAction") .add(Projections.property("workBunch"), "workBunch")); crit.setResultTransformer(Transformers.aliasToBean(ProductTxnModel.class)); if (filterModel.getBarcode() != null && filterModel.getBarcode().length() > 0) { Criterion criteria1 = Restrictions.eq("product.barcode1", filterModel.getBarcode()); Criterion criteria2 = Restrictions.eq("product.barcode2", filterModel.getBarcode()); Criterion criteria3 = Restrictions.eq("product.barcode3", filterModel.getBarcode()); crit.add(Restrictions.or(criteria1, Restrictions.or(criteria2, criteria3))); }/*from w ww.j a va 2 s . c om*/ if (filterModel.getProduct() != null) { crit.add(Restrictions.eq("product", filterModel.getProduct())); } crit.add(Restrictions.eq("this.action", tradeAction)); crit.add(Restrictions.eq("this.active", true)); crit.addOrder(Order.desc("this.date")); crit.addOrder(Order.desc("this.id")); return crit; }
From source file:com.ut.tekir.stock.ProductTxnReportBean.java
License:LGPL
public DetachedCriteria buildCriteriaForPriceList(TradeAction tradeAction) { DetachedCriteria crit = DetachedCriteria.forClass(PriceItemDetail.class); crit.createAlias("this.owner", "owner"); crit.createAlias("product", "product"); // crit.createAlias("owner.owner", "ownerPriceList",DetachedCriteria.LEFT_JOIN); crit.setProjection(Projections.projectionList().add(Projections.property("product"), "product") .add(Projections.property("netPrice.value"), "netPriceValue") .add(Projections.property("netPrice.currency"), "netPriceCurrency") .add(Projections.property("grossPrice.value"), "grossPriceValue") .add(Projections.property("grossPrice.currency"), "grossPriceCurrency") .add(Projections.property("owner.code"), "ownerCode") .add(Projections.property("owner.beginDate"), "ownerBeginDate") .add(Projections.property("owner.endDate"), "ownerEndDate") .add(Projections.property("owner.active"), "ownerIsActive") .add(Projections.property("owner.info"), "priceListName") // FIXME: listeden ad m gelmeli yoksa info mu? // .add(Projections.property("ownerPriceList.listName"), "priceListName") );/*from w w w . j a v a2 s .co m*/ crit.setResultTransformer(Transformers.aliasToBean(ProductTxnModel.class)); crit.add(Restrictions.eq("owner.action", tradeAction)); if (filterModel.getBarcode() != null && filterModel.getBarcode().length() > 0) { Criterion criteria1 = Restrictions.eq("product.barcode1", filterModel.getBarcode()); Criterion criteria2 = Restrictions.eq("product.barcode2", filterModel.getBarcode()); Criterion criteria3 = Restrictions.eq("product.barcode3", filterModel.getBarcode()); crit.add(Restrictions.or(criteria1, Restrictions.or(criteria2, criteria3))); } if (filterModel.getProduct() != null) { crit.add(Restrictions.eq("this.product", filterModel.getProduct())); } crit.addOrder(Order.desc("this.id")); return crit; }