org.turro.erp.purchase.OrdersListbox Class Reference

Inheritance diagram for org.turro.erp.purchase.OrdersListbox:

Collaboration diagram for org.turro.erp.purchase.OrdersListbox:

Public Member Functions
	OrdersListbox ()
void	setProvider (Contract provider)
List< OrderItem >	getOrders ()
Public Member Functions inherited from org.turro.zkoss.input.CollectionListbox< V >
	CollectionListbox ()
	CollectionListbox (Collection< V > collection)
void	updateCollection ()
void	updateCollection (Collection< V > collection)
boolean	isAllowNull ()
void	setAllowNull (boolean allowNull)
Collection< V >	getCollection ()
void	setCollection (Collection< V > collection)
boolean	isNullAtBottom ()
void	setNullAtBottom (boolean nullAtBottom)
String	getNullLabel ()
void	setNullLabel (String nullLabel)
Public Member Functions inherited from org.turro.zkoss.input.GenericListbox< V >
	GenericListbox ()
void	setDisabled (boolean value)
void	afterCompose ()
void	clearItems ()
void	setObjectValue (V value)
void	setObjectValues (Collection< V > collection)
V	getObjectValue ()
Collection< V >	getObjectValues ()
Collection< V >	getDeselectedObjectValues ()
boolean	isSelectFirst ()
void	setSelectFirst (boolean selectFirst)
Set	getDeselectedItems ()
void	sort ()
Object	getRelatedEntity ()
void	setRelatedEntity (Object relatedEntity)

Protected Member Functions
String	convertToString (Order v)
Protected Member Functions inherited from org.turro.zkoss.input.CollectionListbox< V >
void	populateList ()
boolean	equals (V value, V obj)
abstract String	convertToString (V v)
void	beforeAppend (Listitem li)

Additional Inherited Members
Static Public Attributes inherited from org.turro.zkoss.input.CollectionListbox< V >
static final String	ITEM_SEPARATOR = "|||"
Protected Attributes inherited from org.turro.zkoss.input.GenericListbox< V >
boolean	populated = false

Detailed Description

Author

Lluis Turró Cutiller lluis.nosp@m.@tur.nosp@m.ro.or.nosp@m.g

Definition at line 40 of file OrdersListbox.java.

Constructor & Destructor Documentation

OrdersListbox()

org.turro.erp.purchase.OrdersListbox.OrdersListbox

(

)

Definition at line 44 of file OrdersListbox.java.

                         {
    addHeaders();
  }

Member Function Documentation

convertToString()

String org.turro.erp.purchase.OrdersListbox.convertToString ( Order  v )

protected

Definition at line 98 of file OrdersListbox.java.

                                            {
    return (v.getDate() == null ? "" : DateFormats.format(v.getDate(), true)) +
            CollectionListbox.ITEM_SEPARATOR +
            v.getNumber() +
            CollectionListbox.ITEM_SEPARATOR +
            DecimalFormats.format(v.getLines()) +
            CollectionListbox.ITEM_SEPARATOR +
            DecimalFormats.format(v.getUnits()) +
            CollectionListbox.ITEM_SEPARATOR +
            DecimalFormats.format(v.getCost());
  }

Here is the call graph for this function:

getOrders()

List<OrderItem> org.turro.erp.purchase.OrdersListbox.getOrders

(

)

Definition at line 71 of file OrdersListbox.java.

                                     {
    Order order = getObjectValue();
    if(order != null) {
      WhereClause wc = new WhereClause();
      wc.addClause("select d from OrderItem d");
      wc.addClause("where d.providerId = :provider");
      wc.addClause("and d.sent = TRUE");
      wc.addNamedValue("provider", provider.getId());
      if(order.getDate() == null) {
        wc.addClause("and d.documentDate is null");
      } else {
        wc.addClause("and d.documentDate = :date");
        wc.addNamedValue("date", order.getDate());
      }
      if(order.getNumber() == null) {
        wc.addClause("and d.documentNumber is null");
      } else {
        wc.addClause("and d.documentNumber = :number");
        wc.addNamedValue("number", order.getNumber());
      }
      wc.addClause("and not exists (select dr from ReceiptItem dr where dr.orderItem = d)");
      return new ErpPU().getResultList(wc);
    }
    return null;
  }

Here is the call graph for this function:

setProvider()

void org.turro.erp.purchase.OrdersListbox.setProvider

(

Contract

provider

)

Definition at line 48 of file OrdersListbox.java.

                                             {
    this.provider = provider;
    List l = new ErpPU().getResultList(
            "select d.documentDate, d.documentNumber, count(d.id), sum(d.units), sum(d.units*d.cost) " +
            "from OrderItem d " +
            "where providerId = ? " +
            "and d.sent = TRUE " +
            "and not exists (select dr from ReceiptItem dr where dr.orderItem = d) " +
            "group by d.documentDate, d.documentNumber",
            new Object[] { provider.getId() });
    List<Order> orders = new ArrayList<Order>();
    for(Object[] o : (List<Object[]>) l) {
      Order order = new Order();
      order.setDate((Date) o[0]);
      order.setNumber((String) o[1]);
      order.setLines(new Converter(o[2]).getDouble());
      order.setUnits(new Converter(o[3]).getDouble());
      order.setCost(new Converter(o[4]).getDouble());
      orders.add(order);
    }
    updateCollection(orders);
  }

Here is the call graph for this function:

---

The documentation for this class was generated from the following file:

• OrdersListbox.java