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

More Examples:   View Source:   Subtotaling

Free Download

  PHPLens
E Nxt End Srch
(E) (e)Product (e)Supplier (e)QuantityPerUnit (e)Stock (e)Price
  (e)0
1Grandma's Boysenberry SpreadGrandma Kelly's Homestead12 - 8 oz jars
150
25.00
 Subtotal:
150
 
  (e)Beverages
2Rhönbräu KlosterbierPlutzer Lebensmittelgroßmärkte AG24 - 0.5 l bottles
125
7.75
3Sasquatch AleBigfoot Breweries24 - 12 oz bottles
111
14.00
4Chartreuse verteAux joyeux ecclésiastiques750 cc per bottle
69
18.00
5LakkalikööriKarkki Oy500 ml
57
18.00
6Laughing Lumberjack LagerBigfoot Breweries24 - 12 oz bottles
52
14.00
7LEOExotic Liquids10 boxes x 20 bags
39
18.00
8Guaraná FantásticaRefrescos Americanas LTDA12 - 355 ml cans
20
4.50
9Steeleye StoutBigfoot Breweries24 - 12 oz bottles
20
18.00
10ChangieGrandma Kelly's Homestead24 - 12 oz bottles
17
0.00
11Côte de BlayeAux joyeux ecclésiastiques12 - 75 cl bottles
17
263.50
12Ipoh CoffeeLeka Trading16 - 500 g tins
17
46.00
13Outback LagerPavlova, Ltd.24 - 355 ml bottles
15
15.00
 Subtotal:
559
 
  (e)Condiments
14Sirop d'érableForêts d'érables24 - 500 ml bottles
113
28.50
15Louisiana Fiery Hot Pepper SauceNew Orleans Cajun Delights32 - 8 oz bottles
76
21.05
16Chef Anton's Cajun SeasoningNew Orleans Cajun Delights48 - 6 oz jars
53
22.00
17Genen ShouyuMayumi's24 - 250 ml bottles
39
15.50
18Original Frankfurter grüne SoßePlutzer Lebensmittelgroßmärkte AG12 boxes
32
13.00
19Gula MalaccaLeka Trading20 - 2 kg bags
27
19.45
20Vegie-spreadPavlova, Ltd.15 - 625 g jars
24
43.90
 Subtotal:
364
 
 Total:
1073
 
 
(E)  
(e)ProductID6
(e)ProductGrandma's Boysenberry Spread
(e)SupplierGrandma Kelly's Homestead
(e)Category0
(e)QuantityPerUnit12 - 8 oz jars
(e)Price25.00
(e)Stock150
(e)UnitsOnOrder0
(e)ReorderLevel25
(e)Discontinued0
(e)Notes 
(e)OrderDate 
  PHPLens (Page 1)  
E Nxt End Srch

Notes

We set the sumLens property to get the totals and subtotals.
email: contact#phplens.com (change # to @)     telephone (malaysia): 60-3-7947 2888     fax (malaysia): 60-3-7947 2800