October 2nd, 2008 Filed Under Wrk
English:
- Added popularity counter to suppliers
- added MData sub to increase the supplier’s counter = rise supplier in favourite list
- Added initialisation of the popularity list
- testing mysql statements to fill the costcode list
most popular costcodes:
SELECT sup.sup_id, sup.sup_name, count(inv.sup_id) from sup, inv where sup.sup_id=inv.sup_id group by sup_id
most popular costcodes of supplier id 1220:
SELECT sup_name, cpl_code, count(cpl_code) as popularity from `ixc`, sup, inv where inv.sup_id=1220 and sup.sup_id=inv.sup_id and inv.inv_id=ixc.inv_id group by cpl_code order by popularity desc
- Added favourite costcode list for selected invoice’s supplier
- Arranged optimal field after selecting from popular/favourite lists
|
|
Nederlands: |
Upl. v 0.0.70
Comments