org.turro.financials.product.ProductUncoded Class Reference

Inheritance diagram for org.turro.financials.product.ProductUncoded:

Collaboration diagram for org.turro.financials.product.ProductUncoded:

Public Member Functions
	ProductUncoded (String description)
	ProductUncoded (String description, ProductByContractor productByContractor)
ProductByContractor	getProductByContractor ()
void	setProductByContractor (ProductByContractor productByContractor)
double	getProductCost ()
double	getProductCostTax ()
String	getProductName ()
long	getProductId ()
String	getProductCodeStr ()
double	getProductPrice ()
double	getProductPriceTax ()
IProduct	load (Object id)
double	getProductStock (Date date, Contract store)
String	getProductString ()
boolean	isUncoded ()
Collection< Movement >	getMovements ()
Collection< Movement >	getMovements (Date from, Date to, Contract store)

Static Public Member Functions
static List< ProductUncoded >	getProducts ()
static List< ProductUncoded >	getProducts (String concept, boolean equality)
static List< String >	getConcepts (String concept, boolean equality)

Detailed Description

Author

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

Definition at line 34 of file ProductUncoded.java.

Constructor & Destructor Documentation

ProductUncoded() [1/2]

org.turro.financials.product.ProductUncoded.ProductUncoded

(

String

description

)

Definition at line 41 of file ProductUncoded.java.

                                            {
    this.description = description;
  }

Here is the caller graph for this function:

ProductUncoded() [2/2]

org.turro.financials.product.ProductUncoded.ProductUncoded	(	String	description,
		ProductByContractor	productByContractor
	)

Definition at line 45 of file ProductUncoded.java.

                                                                                     {
    this.description = description;
    this.productByContractor = productByContractor;
  }

Member Function Documentation

getConcepts()

static List<String> org.turro.financials.product.ProductUncoded.getConcepts ( String  concept, boolean  equality  )

static

Definition at line 246 of file ProductUncoded.java.

                                                                           {
    WhereClause wc = new WhereClause();
    wc.addClause("select distinct dl.concept");
    getConceptsQuery(wc, concept, equality);
    List<String> list = new FinancialsPU().getResultList(wc);
    return list;
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getMovements() [1/2]

Collection<Movement> org.turro.financials.product.ProductUncoded.getMovements

(

)

Implements org.turro.financials.product.IProduct.

Definition at line 142 of file ProductUncoded.java.

                                             {
    WhereClause wc = new WhereClause();
    wc.addClause("select new org.turro.financials.product.Movement");
    wc.addClause("(dl.document.contract, dl.document.documentDate,");
    wc.addClause("dl.lineType.stockCoefficient,dl.quantity,dl.price,dl.concept)");
    wc.addClause("from DocumentLine dl");
    wc.addClause("where dl.product is null");
    wc.addClause("and dl.productByContractor is null");
    wc.addClause("and dl.concept = :concept");
    wc.addNamedValue("concept", description);
    wc.addClause("and dl.quantity <> 0");
    wc.addClause("order by dl.document.receiptDate desc, dl.lineOrder");
    return new FinancialsPU().getResultList(wc, 100);
  }

Here is the call graph for this function:

getMovements() [2/2]

Collection<Movement> org.turro.financials.product.ProductUncoded.getMovements	(	Date	from,
		Date	to,
		Contract	store
	)

Implements org.turro.financials.product.IProduct.

Definition at line 158 of file ProductUncoded.java.

                                                                               {
    WhereClause wc = new WhereClause();
    wc.addClause("select new org.turro.financials.product.Movement");
    wc.addClause("('Accumulated',coalesce(sum(dl.quantity*dl.lineType.stockCoefficient),0.0),coalesce(sum(dl.quantity*dl.price*dl.lineType.stockCoefficient),0.0))");
    wc.addClause("from DocumentLine dl");
    wc.addClause("where dl.product is null");
    if(store != null) {
      wc.addClause("and dl.store = :store");
      wc.addNamedValue("store", store);
    }
    wc.addClause("and dl.productByContractor is null");
    wc.addClause("and dl.concept = :concept");
    wc.addNamedValue("concept", description);
    wc.addClause("and dl.quantity <> 0");
    wc.addClause("and dl.document.receiptDate < :from2");
    wc.addNamedValue("from2", from);
    Collection<Movement> movs = new FinancialsPU().getResultList(wc);
    wc = new WhereClause();
    wc.addClause("select new org.turro.financials.product.Movement");
    wc.addClause("(dl.document.contract, dl.document.documentDate,");
    wc.addClause("dl.lineType.stockCoefficient,dl.quantity,dl.price,dl.concept)");
    wc.addClause("from DocumentLine dl");
    wc.addClause("where dl.product is null");
    if(store != null) {
      wc.addClause("and dl.store = :store");
      wc.addNamedValue("store", store);
    }
    wc.addClause("and dl.productByContractor is null");
    wc.addClause("and dl.concept = :concept");
    wc.addNamedValue("concept", description);
    wc.addClause("and dl.quantity <> 0");
    wc.addClause("and dl.document.receiptDate >= :from2");
    wc.addNamedValue("from2", from);
    if(to != null) {
      wc.addClause("and dl.document.receiptDate <= :to2");
      wc.addNamedValue("to2", to);
    }
    wc.addClause("order by dl.document.receiptDate asc, dl.lineOrder");
    movs.addAll(new FinancialsPU().getResultList(wc));
    return movs;
  }

Here is the call graph for this function:

getProductByContractor()

ProductByContractor org.turro.financials.product.ProductUncoded.getProductByContractor

(

)

Implements org.turro.financials.product.IProduct.

Definition at line 51 of file ProductUncoded.java.

                                                      {
    return productByContractor;
  }

getProductCodeStr()

String org.turro.financials.product.ProductUncoded.getProductCodeStr

(

)

Implements org.turro.financials.product.IProduct.

Definition at line 84 of file ProductUncoded.java.

                                    {
    return description;
  }

getProductCost()

double org.turro.financials.product.ProductUncoded.getProductCost

(

)

Implements org.turro.financials.product.IProduct.

Definition at line 61 of file ProductUncoded.java.

                                 {
    if(cost == null) {
      loadCostData();
    }
    return cost;
  }

getProductCostTax()

double org.turro.financials.product.ProductUncoded.getProductCostTax

(

)

Implements org.turro.financials.product.IProduct.

Definition at line 69 of file ProductUncoded.java.

                                    {
    return costTax;
  }

getProductId()

long org.turro.financials.product.ProductUncoded.getProductId

(

)

Implements org.turro.financials.product.IProduct.

Definition at line 79 of file ProductUncoded.java.

                             {
    return -1;
  }

getProductName()

String org.turro.financials.product.ProductUncoded.getProductName

(

)

Implements org.turro.financials.product.IProduct.

Definition at line 74 of file ProductUncoded.java.

                                 {
    return description;
  }

getProductPrice()

double org.turro.financials.product.ProductUncoded.getProductPrice

(

)

Implements org.turro.financials.product.IProduct.

Definition at line 89 of file ProductUncoded.java.

                                  {
    if(price == null) {
      loadPriceData();
    }
    return price;
  }

getProductPriceTax()

double org.turro.financials.product.ProductUncoded.getProductPriceTax

(

)

Implements org.turro.financials.product.IProduct.

Definition at line 97 of file ProductUncoded.java.

                                     {
    return priceTax;
  }

getProducts() [1/2]

static List<ProductUncoded> org.turro.financials.product.ProductUncoded.getProducts ( )

static

Definition at line 234 of file ProductUncoded.java.

                                                   {
    return getProducts(null, false);
  }

Here is the caller graph for this function:

getProducts() [2/2]

static List<ProductUncoded> org.turro.financials.product.ProductUncoded.getProducts ( String  concept, boolean  equality  )

static

Definition at line 238 of file ProductUncoded.java.

                                                                                   {
    List<ProductUncoded> l = new ArrayList<ProductUncoded>();
    for(String cp : getConcepts(concept, equality)) {
      l.add(new ProductUncoded(cp));
    }
    return l;
  }

Here is the call graph for this function:

getProductStock()

double org.turro.financials.product.ProductUncoded.getProductStock	(	Date	date,
		Contract	store
	)

Implements org.turro.financials.product.IProduct.

Definition at line 112 of file ProductUncoded.java.

                                                           {
    WhereClause wc = new WhereClause();
    wc.addClause("select sum(quantity) ");
    wc.addClause("from DocumentLine dl");
    wc.addClause("where dl.document.receiptDate = :date");
    wc.addNamedValue("date", date);
    if(store != null) {
      wc.addClause("and dl.store = :store");
      wc.addNamedValue("store", store);
    }
    wc.addClause("and dl.product is null");
    wc.addClause("and dl.productByContractor is null");
    wc.addClause("and dl.lineType.stockCoefficient <> 0");
    wc.addClause("and dl.quantity <> 0");
    wc.addClause("and dl.concept = :concept");
    wc.addNamedValue("concept", description);
    return (Double) new FinancialsPU().getSingleResultOrNull(wc);
  }

Here is the call graph for this function:

getProductString()

String org.turro.financials.product.ProductUncoded.getProductString

(

)

Implements org.turro.financials.product.IProduct.

Definition at line 132 of file ProductUncoded.java.

                                   {
    return description;
  }

isUncoded()

boolean org.turro.financials.product.ProductUncoded.isUncoded

(

)

Implements org.turro.financials.product.IProduct.

Definition at line 137 of file ProductUncoded.java.

                             {
    return true;
  }

load()

IProduct org.turro.financials.product.ProductUncoded.load

(

Object

id

)

Implements org.turro.financials.product.IProduct.

Definition at line 102 of file ProductUncoded.java.

                                  {
    this.description = (String) id;
    this.cost = null;
    this.costTax = null;
    this.price = null;
    this.priceTax = null;
    return this;
  }

setProductByContractor()

void org.turro.financials.product.ProductUncoded.setProductByContractor

(

ProductByContractor

productByContractor

)

Implements org.turro.financials.product.IProduct.

Definition at line 56 of file ProductUncoded.java.

                                                                              {
    this.productByContractor = productByContractor;
  }

---

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

• ProductUncoded.java