Java tutorial
/* * Copyleft 2007-2011 Ozgur Yazilim A.S. * * Distributable under LGPL license. * See terms of license at gnu.org. * http://www.gnu.org/licenses/lgpl.html * * www.tekir.com.tr * www.ozguryazilim.com.tr * */ package com.ut.tekir.invoice.yeni; import java.util.Calendar; import java.util.HashMap; import java.util.Map; import javax.ejb.Stateful; import org.hibernate.criterion.DetachedCriteria; import org.hibernate.criterion.MatchMode; import org.hibernate.criterion.Order; import org.hibernate.criterion.Projections; import org.hibernate.criterion.Restrictions; import org.hibernate.transform.Transformers; import org.jboss.seam.ScopeType; import org.jboss.seam.annotations.In; import org.jboss.seam.annotations.Name; import org.jboss.seam.annotations.Observer; import org.jboss.seam.annotations.Scope; import com.ut.tekir.entities.DocumentType; import com.ut.tekir.entities.TradeAction; import com.ut.tekir.entities.inv.TekirInvoice; import com.ut.tekir.framework.BrowserBase; import com.ut.tekir.framework.CalendarManager; import com.ut.tekir.framework.InvoiceFilterModel; //FIXME: projectionlar dzenlemek lazm. /** * * @author sinan.yumak */ @Stateful @Name("purchaseInvoiceBrowse") @Scope(ScopeType.SESSION) public class PurchaseInvoiceBrowseBean extends BrowserBase<TekirInvoice, InvoiceFilterModel> implements PurchaseInvoiceBrowse<TekirInvoice, InvoiceFilterModel> { @In CalendarManager calendarManager; public Integer exid; private boolean onlyReturned = false; @Override public InvoiceFilterModel newFilterModel() { InvoiceFilterModel fm = new InvoiceFilterModel(); fm.setBeginDate(calendarManager.getLastTenDay()); fm.setEndDate(calendarManager.getCurrentDate()); return fm; } @Override public DetachedCriteria buildCriteria() { DetachedCriteria crit = DetachedCriteria.forClass(TekirInvoice.class); crit.createAlias("this.contact", "contact"); crit.createAlias("this.warehouse", "warehouse"); crit.setProjection(Projections.projectionList().add(Projections.property("contact"), "contact") .add(Projections.property("warehouse"), "warehouse").add(Projections.property("serial"), "serial") .add(Projections.property("reference"), "reference").add(Projections.property("code"), "code") .add(Projections.property("date"), "date").add(Projections.property("contact.code"), "contactCode") .add(Projections.property("contact.fullname"), "contactName") .add(Projections.property("tradeAction"), "tradeAction") .add(Projections.property("documentType"), "documentType").add(Projections.property("id"), "id") .add(Projections.property("info"), "info") .add(Projections.property("totalBeforeTax.localAmount"), "totalBeforeTaxLocalAmount") .add(Projections.property("totalBeforeTax.value"), "totalBeforeTaxValue") .add(Projections.property("totalBeforeTax.currency"), "totalBeforeTaxCurrency") .add(Projections.property("totalTax.localAmount"), "totalTaxLocalAmount") .add(Projections.property("totalTax.value"), "totalTaxValue") .add(Projections.property("totalTax.currency"), "totalTaxCurrency") .add(Projections.property("grandTotal.localAmount"), "grandTotalLocalAmount") .add(Projections.property("grandTotal.value"), "grandTotalValue") .add(Projections.property("grandTotal.currency"), "grandTotalCurrency") .add(Projections.property("workBunch"), "workBunch")); crit.setResultTransformer(Transformers.aliasToBean(InvoiceFilterModel.class)); if (isNotEmpty(filterModel.getSerial())) { crit.add(Restrictions.ilike("this.serial", filterModel.getSerial(), MatchMode.START)); } 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.ANYWHERE)); } if (isNotEmpty(filterModel.getInfo())) { crit.add(Restrictions.ilike("this.info", filterModel.getInfo(), MatchMode.ANYWHERE)); } if (filterModel.getWorkBunch() != null) { crit.add(Restrictions.eq("this.workBunch", filterModel.getWorkBunch())); } if (filterModel.getReturned() != null) { if (filterModel.getReturned()) { crit.add(Restrictions.eq("this.tradeAction", TradeAction.SaleReturn)); } else { crit.add(Restrictions.eq("this.tradeAction", TradeAction.Purchase)); } } else { crit.add(Restrictions.or(Restrictions.eq("this.tradeAction", TradeAction.SaleReturn), Restrictions.eq("this.tradeAction", TradeAction.Purchase))); } crit.add(Restrictions.or(Restrictions.eq("this.documentType", DocumentType.PurchaseInvoice), Restrictions.eq("this.documentType", DocumentType.PurchaseShipmentInvoice))); crit.addOrder(Order.desc("this.date")); crit.addOrder(Order.desc("this.serial")); return crit; } @Observer("refreshBrowser:com.ut.tekir.entities.inv.TekirInvoice") public void refreshResults() { log.debug("Uyar geldi resultSet tazeleniyor"); if (getEntityList() == null || getEntityList().isEmpty()) return; search(); } @SuppressWarnings("unchecked") public void pdf() { Map params = new HashMap(); if (filterModel.getSerial() != null && filterModel.getSerial().length() > 0) { params.put("pSeri", filterModel.getSerial()); } if (filterModel.getReference() != null && filterModel.getReference().length() > 0) { params.put("pRef", filterModel.getReference()); } if (filterModel.getCode() != null && filterModel.getCode().length() > 0) { params.put("pCode", filterModel.getCode()); } if (filterModel.getContactName() != null && filterModel.getContactName().length() > 0) { params.put("pName", filterModel.getContactName()); } if (filterModel.getContactCode() != null && filterModel.getContactCode().length() > 0) { params.put("pConCode", filterModel.getContactCode()); } if (isNotEmpty(filterModel.getInfo())) { params.put("pInfo", filterModel.getInfo()); } if (filterModel.getReturned() != null) { if (filterModel.getReturned()) { params.put("pReturned", true); } else { params.put("pReturned", false); } } Calendar c = Calendar.getInstance(); c.set(1900, 1, 1); if (filterModel.getBeginDate() != null) { params.put("pBDate", filterModel.getBeginDate()); } c.set(2100, 12, 31); if (filterModel.getEndDate() != null) { params.put("pEDate", filterModel.getEndDate()); } if (filterModel.getWorkBunch() != null) { params.put("pWorkBunchId", filterModel.getWorkBunch().getId()); } params.put("pAct", 0); execPdf("fatura_listesi", "Alis_Fatura_Listesi", params); } @SuppressWarnings("unchecked") public void detailedPdf() { Map params = new HashMap(); if (filterModel.getSerial() != null && filterModel.getSerial().length() > 0) { params.put("pSeri", filterModel.getSerial()); } if (filterModel.getReference() != null && filterModel.getReference().length() > 0) { params.put("pRef", filterModel.getReference()); } if (filterModel.getCode() != null && filterModel.getCode().length() > 0) { params.put("pCode", filterModel.getCode()); } Calendar c = Calendar.getInstance(); c.set(1900, 1, 1); if (filterModel.getBeginDate() != null) { params.put("pBDate", filterModel.getBeginDate()); } c.set(2100, 12, 31); if (filterModel.getEndDate() != null) { params.put("pEDate", filterModel.getEndDate()); } if (filterModel.getWorkBunch() != null) { params.put("pWorkBunchId", filterModel.getWorkBunch().getId()); } params.put("pAct", 0); execPdf("alis-satis-fatura", "Alis_Fatura_Listesi_Detayi", params); } @SuppressWarnings("unchecked") public void xls() { Map params = new HashMap(); if (filterModel.getSerial() != null && filterModel.getSerial().length() > 0) { params.put("pSeri", filterModel.getSerial()); } if (filterModel.getReference() != null && filterModel.getReference().length() > 0) { params.put("pRef", filterModel.getReference()); } if (filterModel.getCode() != null && filterModel.getCode().length() > 0) { params.put("pCode", filterModel.getCode()); } if (filterModel.getContactName() != null && filterModel.getContactName().length() > 0) { params.put("pName", filterModel.getContactName()); } if (filterModel.getContactCode() != null && filterModel.getContactCode().length() > 0) { params.put("pConCode", filterModel.getContactCode()); } if (isNotEmpty(filterModel.getInfo())) { params.put("pInfo", filterModel.getInfo()); } if (filterModel.getReturned() != null) { if (filterModel.getReturned()) { params.put("pReturned", true); } else { params.put("pReturned", false); } } Calendar c = Calendar.getInstance(); c.set(1900, 1, 1); if (filterModel.getBeginDate() != null) { params.put("pBDate", filterModel.getBeginDate()); } c.set(2100, 12, 31); if (filterModel.getEndDate() != null) { params.put("pEDate", filterModel.getEndDate()); } if (filterModel.getWorkBunch() != null) { params.put("pWorkBunchId", filterModel.getWorkBunch().getId()); } params.put("pAct", 0); execXls("fatura_listesi_excel", "Alis_Fatura_Listesi", params); } public Integer getExid() { return exid; } public void setExid(Integer exid) { this.exid = exid; } public boolean isOnlyReturned() { return onlyReturned; } public void setOnlyReturned(boolean onlyReturned) { if (onlyReturned) getFilterModel().setReturned(true); this.onlyReturned = onlyReturned; } }