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 Nxt End Srch
(E) (e)Product (e)Supplier (e)Qty/Unit (e)Stock (e)Price
  (e)0
1Grandma's Boysenberry SpreadGrandma Kelly's Homestead12 - 8 oz jars
150 
25.00
 Subtotal:
150
 
  (e)Beverages
2Steeleye StoutBigfoot Breweries24 - 12 oz bottles
 20 
18.00
3Sasquatch AleBigfoot Breweries24 - 12 oz bottles
111 
14.00
4Rhönbräu KlosterbierPlutzer Lebensmittelgroßmärkte AG24 - 0.5 l bottles
125 
7.75
5Outback LagerPavlova, Ltd.24 - 355 ml bottles
 15 
15.00
6LEOExotic Liquids10 boxes x 20 bags
 39 
18.00
7Laughing Lumberjack LagerBigfoot Breweries24 - 12 oz bottles
 52 
14.00
8LakkalikööriKarkki Oy500 ml
 57 
18.00
9Ipoh CoffeeLeka Trading16 - 500 g tins
 17 
46.00
10Guaraná FantásticaRefrescos Americanas LTDA12 - 355 ml cans
 20 
4.50
 Subtotal:
456
 
 Total:
606
 
 
(E)  
(e)ProductID6
(e)ProductGrandma's Boysenberry Spread
(e)SupplierGrandma Kelly's Homestead
(e)Category0
(e)Qty/Unit12 - 8 oz jars
(e)Price25.00
(e)Stock150
(e)UnitsOnOrder0
(e)ReorderLevel25
(e)Discontinued0
(e)Notes 
(e)OrderDate 
  00> Visualize your Information   (Page 1)  
E 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