Changelog

[fan­nie] report­ing results tables now ren­dered using javascript.  javascript now han­dles sort­ing, strip­ing, XML browser-caching, and more.  resorts are MUCH faster, esp. on large data sets.

[fan­nie] BUG cor­rected on gross total and depart­ment sales queries.  double-counting of ven­dor coupons was caus­ing dayend dis­crep­an­cies and totals to appear arti­fi­cially lower.

[IS4C] added patron­ageSwitch ses­sion variable.

[SQL] fixed bug in view dcten­ders, now ten­der report will show cash­back AND the cor­rect cashier number

[IS4C] rewrit­ten ten­der report­ing script for use with lane accountability

[fan­nie] trans­ac­tion lookup: added javascript to search fields, auto-selects check­boxes now, i should really add this to the mem­ber mgmnt mod­ule as well…

[IS4C] BRAND NEW KEYMAP!!  Much improved lay­out and use of space.  some changes intended to address com­mon cashier­ing errors.

[IS4C] fixed bug in nightly main­te­nance script at lane one that was caused peri­odic slow­downs dur­ing the day

[fan­nie] Queries can now pull from any dates for which there’s data ( > 2006-01-04)

[fan­nie] Prod­uct list sorts by descrip­tion, use­ful for inventory.

[fan­nie] Removed the sort by pull­down from the prod­uct list form.  all sort­ing can now be done in the results table header.

[fan­nie] Bolded the GROSS total on the period report for emphasis.

[fan­nie] Dayends can han­dle date input in YYYY-MM-DD or in amer­i­can MM/DD/YY formats.

[fan­nie] Hourly sales report fixed for report­ing on a sin­gle days sales.

[SQL] added active field to batches table for use with Fannie’s sales batcher

[fan­nie] sales batcher has visual read­out on main page dis­play­ing batch activ­ity sta­tus.  also allows for at-a-glance batch toggling

[SQL] changed batches.startDate from TIMESTAMP to a DATE field.  Much bet­ter this way!

[fan­nie] revamped force/reset func­tion.  moved ON/OFF switch to main page.  improved nightly sale change script.

[fan­nie] added SHOW ACTIVE/INACTIVE BATCHES but­ton to sale batcher main page

[fan­nie] remove bulk teas and NF pet dept but­tons from search options

[fan­nie] 2008-02-20 — fixed col­umn sort­ing bug in depart­ment sales reports.  also improved the sort fea­ture for find­ing desired info in fewer clicks.