Popular Suppliers list, favourite Costcode per supplier

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

Comments are closed.