phpLens
 home  products examples manual  faq support forum  contact news  login store

More Examples:   View Source:   Live Demo - Charting UnitsInStock

Free Download

The following example displays a list of products, with bar charts of units in stock.

  PHPLens
E Beg Prv Nxt End Srch
(E) (e)Product (e)Supplier (e)Qty/Unit (e)Stock (e)Price
  (e)Beverages
11Outback LagerPavlova, Ltd.24 - 355 ml bottles
 15 
15.00
12Rhönbräu KlosterbierPlutzer Lebensmittelgroßmärkte AG24 - 0.5 l bottles
125 
7.75
13LakkalikööriKarkki Oy500 ml
 57 
18.00
 Subtotal:
559
 
  (e)Condiments
14Producto, superExotic Liquids12 - 550 ml bottles
 13 
10.12
15Chef Anton's Cajun SeasoningNew Orleans Cajun Delights48 - 6 oz jars
 53 
22.00
16Chef Anton's Gumbo MixNew Orleans Cajun Delights36 boxes
  0 
21.35
17Northwoods Cranberry SauceGrandma Kelly's Homestead12 - 12 oz jars
  6 
40.00
18Genen ShouyuMayumi's24 - 250 ml bottles
 39 
15.50
19Gula MalaccaLeka Trading20 - 2 kg bags
 27 
19.45
20Sirop d'érableForêts d'érables24 - 500 ml bottles
113 
28.50
 Subtotal:
251
 
 Total:
960
 
 
(E)  
(e)ProductID70
(e)ProductOutback Lager
(e)SupplierPavlova, Ltd.
(e)CategoryBeverages
(e)Qty/Unit24 - 355 ml bottles
(e)Price15.00
(e)Stock15
(e)UnitsOnOrder10
(e)ReorderLevel30
(e)Discontinued0
(e)Notes 
(e)OrderDate 
  00> Visualize your Information   (Page 2)  
E Beg Prv Nxt End Srch

Notes

We did it in a couple of minutes by generating it with the Grid Builder and then configuring it in our Web browser.

The charting is configured in Column Settings: Stocks. Then we Generated PHP Code, and pasted the code (chartLens and chartParams properties) into ex180.php.

email: contact#phplens.com (change # to @)     telephone (malaysia): 60-3-7947 2888     fax (malaysia): 60-3-7947 2800