Skip to content

Instantly share code, notes, and snippets.

@jdpurdyvi

jdpurdyvi/Changelog

Created December 9, 2010 19:50
Show Gist options
  • Save jdpurdyvi/735221 to your computer and use it in GitHub Desktop.
Save jdpurdyvi/735221 to your computer and use it in GitHub Desktop.
Download ZIP
Wedge Co-op Changelog
Raw
Changelog
php patches
3/2/05 12:30 pm
applied SCR patch (staff charge receipt) to lane 12:
patched files ini.php, pos2.php, prehKeys.php, printlib.php, printreceipt.php, session.php. added new file chgname.php.
enables staff charge receipts to be suppressed, refines the name to be printed on staff charge slips & biz charge slips, and fixes a couple of bugs (biz charge customers can no longer tender staff charge; partial staff charge tender no longer yields no receipt at all).
3/2/05 1pm patch was rolled back - andrew #1227 & others reached limit - need to investigate
3/5/05 10:45 am debugged prehKeys.php & reapplied patch to lane 12.
3/8/05 6:00 pm SQL views applied to all lanes
ltt_rp_receipt, rp_receipt, rp_receipt_header, chargeCodeView
3/9/05 8:20 am
Patch for receipt printing applied to lane12
frank.php, printLib.php, reprint.php rplist.php
==========
pccharge code reconciled to latest production code on lane12
==========
3/16/05 4:15pm
Franking Patch II for old Wedge receipt printers (plus reconciled pccharge code) applied to lane12
printLib.php and tenderReport.php (plus reconciled pccharge files)
3/18/05 All day
Customer Service computer changed from ASP to PHP. Various changes.
3/28/05 4:05 pm
PC Charge code applied to Charge Book computer. Various files
04/04/05 3:17 pm
Drawer Kick patch applied to Lane 12:
session.php, prehKeys.php, printReceipt.php (all changed); plus new file setDrawerKick.php. ~apbw
4/5/05 10:15 am: Drawer Kick patch on lanes 10, 9, & 8
4/6/05 11:43 am
kick patch combined with member search patch applied to lane12
(? later applied to lane 8-9-10? i think it was.--apbw)
04/7/05 2:30 pm
truncateItem patch on lane 12, then 10, 9, & 8.
rounds the total field to 2 digits.
addItem.php -- include file added on line 68 and truncate2 function wrapped around $dbltotal variable on line 75
4/12/05 9:04 am
new sql views memDiscountAdd and memDiscountRemove were added to all lanes (1-12, X, vmlane99, and pccharge).
memDiscounts patch applied to lane 8 & 12: just prehKeys.php but with a vastly changed ttl function.
4/13/05 11:00 am
new sql view clearTempTables added to postrans on all lanes except lanez
4/14/05 8:58 am
clearTempTables and ttl patches applied to lane09 and lane12
4/14/05 11:00 am
The above applied to lane 8 and lane 10
4/19/05 3:21 pm
Big patch with many altered files applied to lane 12
Consolidated various session variables.
Added an extra frame to handle printing
4/21/05 8:45 am
Another big patch with many altered files applied to lane 12
session variables consolidated in session.php
Added yet another frame to handle franking
4/21/05 11:08 am
Same patch above applied to lane 8, 9 and 10
The original is4c folders on the lanes are copied locally to the folders
panicCity_0421
4/25/05 4:00 pm
Big patch incorporating Chris's credit card code. Many files.
Applied to lane 8.
4/26/05
Same patch applied to all php lanes: 8, 9, 10, 12
4/28/05 9:20 am
Another big patch in which the credit card code has been altered beyond recognition. Applied to lane 12.
4/28/05 10:49 am
Same patch applied to lane 8, 9 and 10
4/30/05 10:50 am
Same patch applied to lane 7, the newest PHP lane, which has only been in service for an hour.
05/03/05 10:40am
Kick Fix applied to lanes 7, 8, 9, 10, 11, 12, and Z.
Minor changes to setDrawerKick.php and printReceipt.php, in the hopes of correcting erratic drawer kicks reported at lanes 7 & 8. (apbw)
5/3/05 11:15am
Edited reprint.php on lanes 7 - 12 (plus Z), to correct transaction number on reprinted receipts. (apbw)
5/3/05 5:35pm
Blue Sky coupon patch applied to lanes 7-12 (plus Z): coupondec.php, coupondeptinvalid.php, and coupondeptsearch.php (apbw)
5/7/05 5pm
Edited upcscanned.php on all lanes by hand to correct "subtsr" typo on line 45.
Replaced upcscanned.php on LANE 9 ONLY to fix euro-upc-parsing error. need to apply to other lanes & test on lanes 7-8 next week.
5/9/05 11:45am
copied upcscanned over to 7, 8, 10, 11, & 12 after testing on CSC & lane 8.
5/9/05 12:50pm
fixed productlist.php on lanes 7-12 to parse short upc's (to do a priceverify on scanned items)
5/10/05 1pm
Cancel Patch applied to lane 9, 11, 12: mgrauthenticate.php & end.php
5/10/05 1:15
applied same to 7, 8, and 10.
5/10/05 2:20pm
backed out the Cancel patch on lanes 7-12; last page was refreshing too quickly so that change due wasn't displayed long enough.
5/10/05 3:15pm
*New* Cancel patch applied to lanes 8 & 12. (mgrauthenticate.php and end.php).
(i think tak applied it later to the other php lanes).
5/17/05
Various patches applied since to all lanes,
including additem.php for RPM issues
and prehkeys.php for Cash over limit.
5/24/05 4:17
patch for employee coffee special applied to lane12. Changes to SQL involves the additions of
the views staffDiscountAdd, staffDiscountRemove, and alteration of the views
lttSummary, subtotals, screenDisplay, ltt_receipt rp_ltt_receipt
5/26/05
patch for employee coffee modified and applied again to lane12.
stored procedure cleartemptable has to be altered
same patch applied to lane10
5/27/05
Patch above applied to all PHP lanes, which now includes lane06.
Lanes affected are therefore: lane06 through lane12.
Changes in database definitions applied to all lanes, asp as well as php.
6/6/05
Patch for data abstraction - primarily so that the same code would
work for both mysql and mssql - applied to lane12. Patch involves
many files.
6/9/05
Same patch above, with minor alterations applied to all php lanes,
which now includes lane 3
6/10/05
christof fixed the pc charge credit card receipt on lane 9 (printLib.php)
6/13/05 12:00 noon
Minor fix applied to drawscreen.php, changes made to connect.php
and end.php.
Patch applied to lane 12 and lane 9
6/14/05 12:45 pm
apbw applied cvr's lane 9 pccharge receipt fix to lane 12 (printLib.php)
later, i think, tak applied the 2 latest patches to all the php lanes (3, 6-10, 12) (cvr's pcc patch plus tak's 6/13 patch)
Yes I did - Tak
6/15/05 void refund patch applied to lane 12 & 9. found it doesn't work for voiding dept key refunds! apbw
6/16/05 11am void refund patch applied to rest of php lanes. apbw
6/17/05 discount shift patch
6/17/05 12:48pm void refund patch patch applied to lane 12. (line 491 in prehkeys.php commented out) - fixes void dept key refunds. --apbw
6/17/05 5:03
Discount toggle patch and final adjustment to RF patch applied to lane 9
6/18/05 8:20am ditto to all remaining php lanes -- apbw
6/22/05 12:15pm updated prehkeys.php on lane 12. edited the entire memDiscountAdd section to list all fields, instead of select *, in all 4 queries - lines 549 -559.
1PM applied to lane 9; 2:40pm applied to 3, 6, 7, 8, 10, 11 -- apbw
6/24/05 12:15pm updated ccLib.php on lane 12. Edited ccSwipe and ccValid functions to test for test card
6/24/05 12:54pm some mysql error handling features added to connect.php. File applied to lane 12. This and the patch above are combined
1:15 pm applied to lane9;1:30 pm applied to lane8
6/27/05 11:00am the last patch applied to all lanes
6/27/05 3:10 pm "Linux Compatible" (LC) patch #1 applied to lane 12. This patch involves
just about all files.
6/30/05: lane 4 upgraded to php. -- apbw
7/1/05: sql server sp3 applied to lanes 2, 3, 5, 6, 7, 8, 12. -- apbw
7/2/05: lane 5 upgraded to php with some sql server irregularities (the backup & restore of historical data was buggy and i did my best to rebuild it by brute force).
also, sql server sp3 applied to juice bar lane 10. -- apbw
7/02/05 2:50pm MemDiscountAdd patch applied to lane12. prehKeys.php is the only file affected.
NOTE: the new file is in the transfer folder; the file it replaced is in a new temp folder "transferPrehkeys"; the panic city file is unchanged.
3:20pm memDiscountAdd applied to lane 9
7/4/05: 10:30am memDiscountAdd applied to 10. lanes 9, 10, & 12 are now synchronized, with the Linux patch plus the memDiscountAdd patch.
7/7/05: 12:00 noon memDiscountAdd patch as well as linux patch applied to all lanes
7/7/05: 12:45 pm inoutunknown correction made to pos2.php and applied to lane12
1:30 pm the typo caused a fatal error on lane 6 that required reboot, so i went ahead & applied patch to lane 9--apbw
i also turned off some automatic services on lanes 7 & 8--apbw
7/8/05 7:45am applied inout patch (pos2.php) to all other production lanes.
apbw 8:00am: lane 2 upgraded to php using machine from old lane 5.
10:30am ccauthorize.php typo fixed on lane 12 (already done on pccharge)
11:05am ditto lane 9
12:20 cc_OUT sql table - added fields for troutd & ccamt - lane 9
12:30 ditto lane 12
1:30 ditto lanes 1 - 8 & 10 -- sql patch complete.
1:05pm addItem typo's found in additem.php, ccauthorize.php, preHkeys.php, and void.php. fixed & applied to lane 12. incorporates the earlier ccauthorize typo fix.
2:05pm ditto applied to lane 9
3:15pm ditto lanes 2-8 & 10 -- code patch complete.
7/12/05 1:38pm resume.php fixed (with "isset" function for selectlist variable) apbw - applied to lane 12
2:05pm lane 9 - tested
2:52pm lanes 8&10
3:12pm lanes 2-7
7/13/05 5:07pm edited preHkeys.php on lane 3 only to see if eliminating comma from subtotal line description will resolve php.exe & insert statement errors. holding breath.
7/22/05: changed field name Scale to scale in the following SQL tables:
Mars WedgePOS: dTransactions and suspended
all lanes POSTrans: localtrans, localtransarchive, ltaadjust, dtransactions, suspended
(localtemptrans and products were already lowercase)
7/27/05 replaced the truncate2 function that formatted $dbltotal and $dblunitPrice in additem.php - it was putting commas back in as the
thousands separator - i replaced it with php's number_format function. should solve the insert error that occurs when dollar amounts
exceed $999.99. --apbw
10:24am lane 12
11:30am lane 9
11:56am lane 10
12:40pm lanes 2-8
7/29/05 10:15am moved a parenthesis in printreceipt.php to fix rounding bug in the "you could have saved" line --jqh
3:20pm i discovered that joe's change also needed to be made a few lines up in the "you saved" line, so i followed suit & applied to all lanes--apb
8/1/05 Linux patch applied to lane12 - certain mysql wrappers are removed and autocomplete disabled
8/2/05 3:34 pm. Patch above applied to lane09
8/3/05 4:36 pm. Patch above applied to all PHP lanes
8/4/05 10:40 am - Tak
Patch corresponding to r73 on subversion applied to lane12. Patch involves altering some javascripts for working with browsers other than IE.
8/9/05 5:07 pm
Linux lane hydra01 opened up as a lab. All patches should be applied to hydra01 as well at \\10.10.10.71\is4c
8/11/05 4:40 pm
prehKeys,ccauthorize and ccLib patches applied to lane09 by Christof for PCCharge implementation. INX table also added to POSBDAT.
8/12/05 3:50 pm - Christof
added current prehkeys, ccauthorize and ccLib to lane12.
8/12/05 5:22 pm
above patch combined with r73 applied to lane09. We'll call it r73.5. Both lane12 and lane09 are therefore running r73.5 while the rest of the lanes are running r64.
8/15/05 11:50am-12:15pm
r73.5 applied to lanes 1-8 and 10, per tak's request
8/15/05 1:43pm
re-configured lane 12 to run php as an apache module, like so (per tak's request):
1. copied the php4apache2.dll file from the sapi installation directory to c:/php/
2. Edited httpd.conf file:
a. commented out the ScriptAlias and Action lines from original setup:
#ScriptAlias /php/ "c:/php/"
#Action application/x-httpd-php "/php/php.exe"
b. added these 2 lines:
LoadModule php4_module "c:/php/php4apache2.dll"
PHPIniDir "C:/WINNT/"
also pre-configured lanes 2-10 for the change: copied dll file; saved a backup copy of httpd.conf before editing.
***note: lane 3 will need to say PHPIniDir "E:/WINNT/"**
8/16/05 4:48pm configured lanes 8 and 9 to run as modules
8/18/05 12:45pm configured lanes 10, 2, & 3 to run as modules
***in summary, lanes 8-12 and 2-3 are running php as apache modules now***
lanes 2 & 3 are still getting popups, and lane 8 continues to be plagued with various problems (now on lane 8 the error is "page cannot be displayed" and there are apache errros that we need to increase the threadsPerChild count)
8/25/05 3:10 p.m. loaded new ccLib and ccauthorize onto lane 12 CvR
9/02/05 10:30 a.m. added edit ccauthorize to copy OUX onto lane 12 and 9 CvR
9/22/05 4:30 p.m. added latest patches for pccharge to lane 12 patched files
include:
authenticate.php
ccauthorize.php
ccDecision.php
ccEntered.php
ccLib.php
connect.php
dupuser.php
input.php
loadconfig.php
session.php
9/23/05 1:00 pm CvR
Applied credit card patches to lane12 and lane09. Involved many files.
9/29/05 1:00 pm CvR updated printLib, ccEntered to all for multiple receipts.
10/06/05 1:10pm JQH
Applied receipt patch; added views ltt_grouped,ltt_receipt_reorder_g,receipt_reorder_g,receipt_reorder_unions_g. updated pages: ini.php,printLib.php,printReceipt.php,upcScanned.php,additem.php
10/8/05
Patch of 10/06/05 applied to lane12, lane09, lane08, lane07 on Friday 10/07/05
Some essential cc features were found to have been reverted. A new patch was applied to lane12
10/10/05 4:30 pm
Missing features ressurrected. Patch applied to lane 12, 9, 8, and 7
10/11/05 11:24 am
Patch for manual credit card entry applied on top of the latest patch to lane 12 alone. Code is "transfer"
folder is the same as that on lane 12, and will be
applied to all php lanes.
10/11/05 3:07 pm
patch above applied to lane 6, 7, 8, 9, 10
10/12/05 8:45 am
patch applied to lane 2, 3, 4, 5
10/21/05 1:38 pm
Applied patch to prevent double insertion of discount and tax after
the transaction has ended. Same patch puts a wrapper on the
query for inserting records into INX. Failure to insert will now put
a stop to further PC Charge processing.
Patch applied to lane 12, 9 and 6
10/21/05 4:00 pm
Latest patch (above) applied to lane 10, 7, and 1
10/21/05 4:30 pm
Latest patch applied to the rest of the lanes (2, 3, 4, 5).
10/26/05 6:33 pm
lengthened the amount of time allowed before time out.
Patch applied to lane 12 and lane 9
11/03/05 11:27 am Tak
replaced global $dbms with $_SESSION["DBMS"] in connect.php
Patch applied to lane12
11/03/05 later that day
Patch taken off because it was not perfect
11/04/05 12:55 pm
Patch from yesterday reworked and re-applied to lane 12
11/04/05 2:00 pm
Latest patch applied to lane 9 and 10
11/04/05 3:30 pm
Latest patch applied to lane 2 and 5
11/07/05 4:17 pm
Patch applied to all other (production) lanes.
11/09/05 8:57 pm
INX moved to postrans, query established to get credit card suffixes
time out in ccauthorized lengthened. Patch applied to
lane 12 and lane 9
11/09/05 4:32 pm
Latest patch applied to all lanes
11/10/05 10:26 am
Patch to print out last 4 digits of credit cards on receipts.
Applied to lane 12
11/10/05 12:00 noon
Patch running on all lanes
11/15/05 10:05 am
patch to postpone drawer kick for integrated credit card tender
applied to lane 12 and lane 9
11/22/05 9:30 am
added table oux and associated views. Added function addOux in
ccLib.php. function is called in ccauthorized. modified printLib.php.
All in anticipation of the next patch which will take care of the
drawer kick and other issues. Patch applied to lane 12 and 9
11/22/05 11:00 am
Patch applied to all production lanes
11/22/05 11:52 am
Patch to postpone tender/drawer-kick for credit card transactions
applied to lane 12, 9
11/22/05 12:00 am
new receipt flagged on all lanes
11/22/05 3:30
Drawer kick patch applied to all lanes
11/23/05
ccManual flag patch applied to lane 12, 9
11/25/05
Patch applied to all lanes
12/06/05 JQH
Added sign off when running a tender report. Also, made it so you can not
run a tender report while there is a transaction in progress.
12/06/05
Patch above applied to all lanes
12/09/05 JQH
Patch applied to change stock purchase to qttyenforced=1 and changed stock price to $10.
changed code on pos2.php, qtty2.php, and upcscanned.php to accomadate the change.
12/09/05 3:10
Patch above applied to all lanes
12/10/05 11:27am
Above patch rolled back via panic city on all lanes -- due to complaints from customer service & confusion at front end. to be discussed before re-applied.
apbw
12/12/05 JQH
The patch that was applied on 12/09/05 and rolled back on 12/10/05, was re-patched to all lanes.
12/14/05 JQH
Membership details patch. memberCommentPlus.php added. session variables added to ini.php, code changed on pos2.php and connect.php.
12/16/05 JQH
Fixed a bug on the new receipt where the tax line was shown on a tax exempt transaction. Change was made to printReceipt.php
12/20/05 JQH
Lane 9: Changed the view "customers" on earth.wedgepos by adding a union to include second names in custdata.
Also small change on prehKeys.php to accomadate the custdata change.
12/20/05 Tak 2:28 pm
prehkeys.php changed on all lanes. custdata changed on all lanes
12/20/05 Tak later that day
No automatic ebt tender patch, which involved commenting out three lines
in pos2.php applied to lane12
12/20/05 Tak Still later that day
Patch above applied to all lanes
01/06/06 CvR patched prehkeys to get rid of 'No Way' on FS over FS eligible amount (line 204) put to lane 12 6:30 pm
01/07/06 11:00 am CvR added 'no way' patch above to CS and lane 8
01/08/06 Patch above reversed -- Tak
01/09/06 JQH
patched so when searching for a member NUMBER (not member name) by pressing "ID", cashier won't be prompted to pick from 2 member names
that are under the same member number.
01/09/06 10:30 am.
first in a series in reconciling the wedge and the wfc version
sql views customerview, currentstaffview and nonmemview changed on all lanes. Code applied to lane 12
01/09/06 2:00 pm Tak
Patch above - views and code - applied to all lanes
01/27/06 4:30 pm Tak and Chris
Applied patch to ccDecision.php to lane 8 and 12
01/27/06 5:00 pm Tak and Chris
Patch above applied to lane 9 and 10
01/27/06 5:30 pm Tak and Chris
Patch above applied to all remaining lanes
02/02/06 2:22 pm
"No way" patch applied to lane 12
02/02/02 Later that day
Patch above applied to all remaining lanes
02/15/06 JQH
Fixed a bug with subs charging. pos2.php only page changed.
02/16/06 JQH
Fixed a bug with short upcs entered by hand or with handheld scanner. change on upcscanned.php
03/09/06 JQH
upcscanned.php changed so stock can be paid in fractions
03/16/06 Tak
tenderReport.php changed so that bus passes are included in the morning shift CS tender reports.
patch applied to lane 12 and lane 9
03/16/06 Tak
Later that day: patch above applied to all remaining lanes
03/25/06 CvR
ccLib.php changed ccTicket() to create PCCharge trans_num like IS4C. Posted to CS 12:40
04/06/06 Tak
ini.php alter. All lanes set to send inx to pccharge temp queue at
\\pcchargeserv\activeCharge\temp\
04/06/06 Tak
Later that day: incoming oux no longer writes to local OUX directory
patch applied to lane12
04/06/06 Tak
2:40 patch above applied to lane09 and lane10
04/06/06 Tak
Still later that day, patch above applied to all lanes
04/07/06 JQH
made change so members that are inactive for stock pmt due will change to active immediately when a stock pmt is made.
pages affected: prehkeys.php, reprint.php, session.php, upcscanned.php, void.php
4/8/06 apbw
discovered error logging was off at lanes 1, 6, & 8. turned it on.
04/10/06 JQH
changed the blueline msg for "STOCK PMT TODAY***" to "STOCK PMT TODAY (0)"
pages affected: prehkeys.php, upcscanned.php, void.php
04/14/06 CvR 13:40
added $_SESSION['logfile'] to ini.php on lane 9
updated lib.php to include log_info() on lane 9
updated connect.php to include log_info() for failed connections and failed queries on lane 9
updated authenticate.php to fix error in checking for duplicate users on pcchargserv.globalvalues.
04/14/06 CvR (later that day)
udpated lanes 8, 10, 12 with above
04/17/06 2:30 pm Tak
Patch to specifically instruct cashiers which alternative system on to use
in case of cc failures. Files affected: ccEntered.php, ccauthorize.php, ccDecision.php
Patch applied to lane12, lane09
04/18/06 8:45 am Tak
Patch above applied to all remaining lanes
04/20/06 9:15 am Tak
Changed wording in Patch, and reapplied to lanes 12, 9, 10 and 8
04/22/06 1:00 pm CvR
Applied patches from 04/14 to lanes 1-7
4/22/06 3pm apbw
a simple patch to prevent doubling of suspended/resumed transactions.
affects special.php and resume.php (truncates localtemptrans before inserting the resumed transaction).
applied to:
3:00pm lane 12
3:40pm lane 9
4:30pm lanes 5, 6, 7, 8 and 10
5:30pm lanes 1,2,3, and 4
all done!
4/25/06 10am apbw
removed extra blank line at the end of all ini.php's and special.php's.
4/25/06 2:00 pm Tak
Reconciled code on all lanes to the code on lane01, reconciled all ini.php files
4/27/06 10:40 am Tak
track II patch (failure to insert into inx because of string length) applied to lane12
affects ccLib.php
5/5/6 9:50am Joe & John
fixing the stock purchase check stand-alone affects prehkeys.phpf
5/6/05 10:30 CvR
posted manual CC patch to lane 12. Affects: ccApproved, ccauthorize, ccDecision, ccEntered, ccLib, and pos2. Have left prehkeys in transfer from above...
5/6/05 11:30 CvR
posted manal cc to lanes 9, 10.
5/6/05 11:50 CvR
pulled manual CC patch. Caused errors at CS, and failed to be approved at Juice Bar. Testing server must -accept, but not live server.
Note: Live server worked. Juice bar must have mistyped the number.
5/26/06 6:40 Tak
Patch to: lengthen the oux wait timeout; correct the a typo (commmunications);
and to initialize the variable $errorInfo in ccauthorized.php
Applied to lane12
applied to lane 9 at 6:45 and did a cc purchase & cc refund to test. apbw
applied to 1-8 plus 10 at 7pm (leaving for day but christof here for one more hour). apbw
5/30/06 Tak
Lengthened the field "Result" to varchar 50 in the inx tables on all lanes
5/31/06 11:10 am Tak
Reset $_SESSION["troutd"] to the empty string in additem.php every time a record is written into
localtemptrans. Patch applied to lane12
6/1/06 Later that day
Patch above applied to lane09. then lane10, lane08, and an hour and a half later, to the rest of the lanes.
6/30/06 9:15 am Tak
Big patch to reconcile Wedge and PFC linux code running without incidence on lane12, lane09, lane10
Now also applied to lane08 and lane05
7/3/06 11:00 am Tak
Big patch applied to lane06 and lane07
7/13/06
Big patch with fixes applied to all lanes
7/18/06 9:15 am Tak
Artisan Bread patch applied to lane12
7/18/06 1:20 pm Tak
Patch above applied to lane09, lane10, lane08. A condition for the application
of the code is that the time must be after 8 pm. For testing purpose, this is
set to be after 10 am on lane 8. This should be changed after testing on lane 8
is completed.
7/18/06 3:10 pm Tak
Patch above applied to all lanes. Time condition on lane 8 is still different
7/18/06 4:00 pm Tak
Patch above applied to all lanes, including lane08
7/19/06 10:45 am Tak
lib.php with added function displaydot() applied to lane12. Function is not invoked anywhere and therefore should have no effects on operations.
7/19/06 10:30 am Tak
lib.php patch appled to all lanes
7/20/06 11:00 am Tak
Quantity enforced patch to address javascript/firefox issue. Patch applied
to lane12
7/21/06 11:00 am Tak
Patch above applied to lane09, lane10, lane08
7/24/06 Tak
Patch above applied to all lanes
7/28/06 1:30 pm
50% Bread discount to be applied by Christina or Nate
whenever they deem appropriate, regardless of
whether it is later than 8 pm. Patch applied
to lane12, lane09, lane10, lane08
7/28/06 4:00 pm
Patch above applied to all lanes
7/31/06 2:00 pm John
Patch to fix effects of 2.5 dollar coupon on stock purchases, and other issues
involving couponsTotal() and couponsused()
Applied to lane12
7/31/06 2:30 pm John
Patch above applied to all lanes
8/01/06 10:10 am John
Patch above removed from all lanes
8/01/06 12:15 pm John & Tak
Patch above corrected and applied to lane12 and lane09
8/02/06 09:30 am John
Patch above applied to lane02
8/03/06 Tak
Patch above applied to all lanes
8/07/06 4:00 pm Tak
Patch to address suspension issues applied to lane12, lane09 and lane08
8/07/06 10:15 am Tak
Patch above applied to all lanes
8/07/06 11:30 am Tak
To fix issue with missing frames. Altered msgscreen.php. Patch applied to
lane12, 9, 10, and 8.
8/07/06 12:00 noon Tak
Patch above applied to lane02
8/7/06 3:15 pm Tak
Patch above applied to all remaining lanes.
8/7/06 1:45 pm Tak
Product search to show "Big and Heavy" items. Applied to lane12, 9, 8
8/7/06 2:15 pm Tak
Big and Heavy patch applied to lane10, 2
8/7/06 4:00 pm Tak
BHL applied to all remaining lanes
8/28/06 4:00 pm John
Removed abs function from rp_receipt_header view that was causing all reprinted receipts to have positive chargetotal values
Applied to lane12, lane09
8/29/06 9:00 am John
Above patch applied to all remaining lanes
8/29/06 4:15 pm Tak
Added two functions to connect.php. Functions are not called
Applied to lane12, 9.
8/30/06 10:00 am Tak
Patch above applied to all remaining lanes
8/30/06 4:15 pm Tak
Arguments passed to invalid.php using query string. Applied to lane12
8/31/06 10:15 am Tak
Patch above applied to lane09, lane10, lane08
8/31/06 12:30 am Tak
Patch above applied to all remaining lanes
9/6/06 10:00 am John
EBT Cash patch applied to all lanes
9/18/06 10:00 am Tak
No multiple login patch applied to lane12
9/18/06 10:30 am Tak
Patch above applied to lane09
9/18/06 2:15 pm Tak
Patch above applied to lane10, lane08
9/18/06 8:45 am Tak
Patch above applied to lane01, lane02
9/18/06 2:00 pm Tak
Patch above applied to all remaining lanes
9/18/06
Patch above buggy. Fix applied to lane12, 8, 9 10
9/18/06 4:30 pm Tak
Fix applied to all remaining lanes
9/24/06 11:30 am John
Changed memberCommentPlus.php to display inactive status as read from db instead of from php. Applied to lanes 12, 10 and 9
9/24/06 12:15 pm John
Above patch applied to all remaining lanes
9/26/06 9:45 am John
memberComment++: changed what field to display in memberCommentPlus. Applied to lanes 12 and 10
10/3/06 13:07 Lynn
Moved ini.php to /ini/ directory on lanes 08 and 12
10/3/06 13:47 Lynn
Placed a copy of most recent ini.php into /ini/ directory on every lane. Made ini update on lane 10
10/4/06 9:25 am Lynn
Made ini update on remaining lanes (except 11)
10/5/06 1:45pm apbw ean13 patch -- new upcscanned.php to parse EAN13 scale barcodes in addition to standard UPC scale barcodes.
1:45pm applied to lane 12
2:00pm applied to lane 8 (during lynn's cashier training).
2:30pm applied to lanes 9-10
4:55pm applied to lanes 1-7
10/18/06 11:15 am Lynn
Pushed EAN8 fix (pos.exe) to lanes 8, 9, 10, and 12.
10/19/06 9:30 Lynn
Pushed EAN8 fix (pos.exe) to lane 2
10/23/06 10:35 am Lynn -- One Check over per day pushed to lane 12
11:31 am pushed to lane 9
2:40 pm pushed to lane 10
10/24/06 9:10 am Lynn -- One check patch pushed to lane 8
12:45 pm pushed to lane 5
2:20 pm pushed to lanes 1, 2, 3, 4, 6 and 7
10/27/06 11:30 am Tak
Extend CC timeout to 3 x 45
patch applied to lane 12, 9, 10, 8, 5
10/27/06 12:00 noon.
Patch above applied to lane 2
10/27/06 later that day
Patch above applied to all remaining lanes
10/31/06 10:00 am Lynn -- Applied promo message to lanes 9 and 12 (PrintReceipt.php and PrintLib.php)
12:45 applied to lanes 8 and 10
3:15 applied to lanes 6 and 7
4:05 rolled back from 6 and 7 - credit card slips were printing in a wide font
4:35 after fixing font problem, applied to 6 and 7 and reapplied to 8, 9, 10 and 12
11/1/06 9:30 am Lynn -- Applied promo message to lane 2
10:05 -- Applied to all remaining lanes
11/14/06 11:00 am Tak
Increase refreshing frequency for ccauthorize.php from 3 seconds to 2 seconds
Instead of 3 x 56, it is now 2 x 60
Applied to lane12, lane09
11/14/06 11:30 am Tak
Patch above applied to all lanes
11/16/06 10:00 am Lynn -- Applied watermark patch (Add a watermark to the screen when logged in as training) to Lanes 9, 10 and 12
11/17/06 10:45 am Lynn -- Applied to lanes 5 and 8
12:38 -- Applied to all other lanes
11/20/06 2:25pm Lynn -- Applied ClubCard patch to lanes 10 and 12
4:20 -- Applied to all other lanes (only affects juicebar)
11/27/06 10:40 am Lynn -- Applied remaining watermark patch to lanes 9,10 and 12 (pos2.php)
2:30 pm -- Applied to lanes 5 and 8
3:35 pm -- Applied to lanes 6 and 7
4:20 pm -- Applied to all other lanes
12/4/06 9:10 am Lynn -- Applied Signoff patch to lanes 9,10 and 12; if a cashier logs off using
tender reports, they are actually logged off.
1:20 pm -- Applied to lanes 5 and 8
3:50 pm -- Applied to lanes 4, 6 and 7
12/5/06 9:10 am Lynn -- Applied Signoff Patch to lanes 1, 2 and 3.
12/6/06 14:55 Lynn -- Applied "no double login" patch (authenticate.php) to lanes 9, 10 and 12.
12/7/06 9:50 Lynn -- Applied "no double login" patch to lanes 5 and 8.
13:35 -- Applied to lanes 5, 6 and 7
16:30 -- Applied to lanes 1, 2 and 3
12/11/06 11:55 Lynn -- Applied suspend patch (special.php) to lanes 9, 10, and 12.
14:10 -- Applied to lanes 5, 7, and 8.
12/12/06 9:45 Lynn -- Applied suspend patch to lanes 3, 4 and 6
12:30 -- Applied to lanes 1 and 2
12/13/06 10:30 Tak
TaxTable and lttSubtotals patch to replace tax percentage hardcoding
Applied to lanes 12 and 9
12/14/06 09:00 am Tak
Patch above applied to lanes 10 and 8
12/15/06 10:45 am Tak
Patch above applied to lanes 5, 1, 2
12/15/06 12:15 pm Tak
Patch above applied to all remaining lanes
1/9/07 9:15 am Tak
10 dollar idea for check endorsement screen applied to lane12, 9, 10
1/9/07 10:30 am Tak
Patch above applied to lanes 8 and 5
1/9/07 11:10 am Tak
Patch above applied to all lanes
1/9/07 2:30 pm Tak
10 dollar idea to mark tax status of refund items - first stage, applied to lanes 12, 9
1/23/07 10:30 am Tak
Patch above applied to lane08, lane10
1/23/07 10:45 am Tak
Patch above applied to lane01, lane02
1/23/07 11:00 am Tak
Patch above applied to all remaining lanes
1/24/07 11:12 am Tak
PHP part of "no refresh" patch applied to lane08 alone for testing. It still
refreshes because the VB driver refreshes the frame. VB part of the patch
is ready, but not yet applied.
1/25/07 11:30 am Tak
"no refresh" patch applied to lanes 8 and 12. Applying the patch involves the
following:
- a line added to httpd.conf (added to all lanes)
- Apache has to be restarted (lanes 8 and 12 so far)
- New Magellan directory copied over to c:\is4c\magellan_new (done on all lanes)
- exit from pos.exe and rename magellan_new to magellan (done on lanes 8, 9, 10, and 12)
- PHP and other files in transfer copied over (done on lanes 8 and 12)
1/25/07 4:30 pm Tak
Patch above applied to lane 9
The old scanner scale driver is in panic city, and labeled magellan_old
1/26/07 4:00 pm Tak
Patch above applied to lanes 10, 4
1/26/07 7:00 pm Tak
Patch taken off lanes 8, 4
1/26/07 3:30 pm Tak
Patch re-applied to lane 8 and 7
1/31/07 9:00 am Tak
Patch above applied to all remaining lanes
1/31/07 10:15 am Tak
Time delay patch for scanner scale multiple reads applied to lane 8
1/31/07 10:30 am Tak
Patch above applied to lane 7
2/1/07 12:00 noon Tak
Patch above applied to lanes 2, 12, 10, 9
2/2/07 8:40 am Tak
Patch above applied to all remaining lanes
2/2/07 1:00 pm Tak
"Script error" patch quickly applied to all lanes
2/3/07 apbw
tender & enter keys stopped working and refreshing had no effect, or else caused IS4C to freeze.
panic city (php) applied to all lanes except deli & csc.
panic city (magellan) applied to lanes 4-8 and juice bar.
waiting for a chance to apply on lanes 1-3 (too busy to sign off at the moment.) will revert them sunday morning if not today.
2/6/07 12:00 noon Tak
"No multiple reads" patch, stage one involving lib.php and sessions.php applied to lanes 9 and 12
2/9/07 11:30 am Tak
Patch to make it irrelevant whether or not a cashier keys in the check digit for an ean13 item starting with "20"
Applied to lanes 12, 10. 9, 8, 7
2/9/07 1:00 pm Tak
Patch above applied to all remaining lanes
2/9/07 4:30 pm Tak
Various changes made to address security issues. Applied to all lanes
2/12/07 4:30 pm Tak
Patch to add more information to price verification list applied to lanes 12 and 9 only
2/13/07 9:00 am Tak
Patch above applied to lanes 10, 8, 1
2/13/07 9:30 am Tak
Patch above applied to all remaining lanes
2/13/07 12:30 pm Tak
"No refresh" redux stage I, in which html tags are added and javascripts variables are initiated
in a few pages. No functions are called, and no features are added. Nothing should be affected.
Applied to lane12, lane09
2/14/07 10:00 am Tak
Patch above applied to lanes 10, 8, 7 and 1
2/14/07 10:30 am Tak
Patch above applied to all remaining lanes
2/14/07 5:00 pm Tak
The "extra asterisk" patch for the scanner scale proved to be the culprit for the stickiness
The offending lines were taken out and the vb programs re-compiled and applied to all lanes
2/16/07 5:00 pm Tak
a Session variable is added to getsubtotals() to read the value of the new field "absTotal" in
postrans.dbo.subTotals. The new session variable is merely initialized, and not invoked.
Patch applied to lanes 12 and 9
2/19/07 9:45 am Tak
Patch above applied to lanes 10, 8, 1
2/19/07 10:30 am Tak
Patch above applied to all remaining lanes
2/19/07 11:00 am Tak
Cancel-tracking patch applied to lanes 12, 9 and 10
2/19/07 12:45 pm Tak
Patch above applied to lanes 1, 7, and 8
2/19/07 2:15 pm Tak
Patch above applied to all remaining lanes
2/20/07 4:00 pm Tak
Forms with hidden input added to various pages to prevent script errors
Patch applied to lanes 12, 10, 9
2/20/07 7:30 pm Tak
Patch above applied to all remaining lanes
2/21/07 11:15 am Tak
script errors patch II applied to lanes 12 and 8
2/22/07 10:10 am Tak
Patch above applied to all remaining lanes
2/22/07 10:45 am Tak
"Script Errors" Patch part III applied to lanes 12 and 9
2/22/07 5:00 pm Tak
Patch above applied to lanes 10, 8, 7
2/23/07 10:15 am Tak
Patch above applied to all remaining lanes
3/5/2007 3:45 pm amy
ccLib.php: replaced the calling of function local_inx()
with variable $local_inx in function ccXML() lines 399-408.
lane 12 3:45 pm
lane 10 3:56 pm (they're having internal network errors at the moment) ***patch didn't help ***
lane 9 4:30 pm
lanes 1-8 4:45pm
3/6/2007 4:45 pm amy -- suspended doubling patch (another attempt to prevent it).
1. sql views added on lanes 1-12: ltt_suspended, ltt_suspended_local, ltt_suspend_remaining, ltt_suspend_remaining_local.
2. special.php (changed to insert from ltt_suspended views instead of localtemptrans table)
and resume.php (changed to insert resumed transactions in datetime order to retain original sequence)
lane 12 - 4:54 pm
lane 9 - 5:17pm (tested successfully with a suspended/resumed transaction)
3/7/07 11:00 am Tak
Patch above applied to lanes 5, 8, and 10
3/8/07 10:03 am Tak
Patch above applied to all remaining lanes
3/25/07 11:38am abpw
call php function clearstatcache() before & after all file_exists() functions in ccLib.php & ccauthorize.php.
hoping to eliminate 2 increasingly common errors: "internal network error" and "incomplete transaction".
applied to lane 12 after testing on vmamylinux.
12:05pm lane 10.
12:25pm lane 9.
12:40pm lanes 6, 7, 8 with FEC's approval.
1:05pm lanes 1-5 with FEC's approval.
* another internal network error on lane 10 at 12:58, long after patch was applied.*
4/6/07 11:00 am Tak
Credit Card extraneous characters patch applied to lane 12
4/6/07 1:20 pm Tak
Patch above applied to lane 9
4/6/07 4:00 pm Tak
Patch above applied to lanes 10, 8
4/9/07 10:00 am Tak
Patch above applied to all remaining lanes
4/19/07 11:35 am Tak
tran_no patch applied to lanes 12, 9
4/19/07 12:31 pm Tak
Patch above applied to lanes 10, 8
4/19/07 1:40 pm Tak
Patch above applied to all remaining lanes
4/26/07 3:27 pm Tak
New fields added to insert statements
Patch applied to lanes 12, 9, 10
4/26/07 4:22 pm Tak
Patch applied to lanes 8, 5
4/26/07 5:00 pm Tak
Patch applied to all remaining lanes
4/30/07 10:58 am Tak
New fields part 3 patch applied to lane 12
4/30/07 1:15 pm Tak
Patch above applied to lanes 8, 9, 10
4/30/07 3:00 pm Tak
Patch above applied to lanes 3, 7
4/30/07 4:30 pm Tak
Patch above applied to all remaining lanes
5/2/07 12:13 pm Tak
Standalone patch applied to lane 12
5/2/07 12:57 pm Tak
Panic city. Patch above reverted.
5/2/07 5:21 pm Tak
Patch reapplied to lane 12 after adjustment.
5/3/07 10:30 am Tak
Patch above applied to lane 9
5/7/07 10:30 am Tak
Patch above applied to lanes 8, 5, and 2
5/7/07 1:02 pm Tak
Patch above applied to all remaining lanes
5/10/07 5:56 pm Tak/Alex
pos2.php - no automatic tendering of EF or EC
prehkeys.php - rounding error; brute force solution
Applied to lanes 12 and 8
5/11/07 8:15 am Tak
Patch above applied to lanes 9, 10
5/11/07 12:35 pm Tak
Patch above applied to lanes 5 and 2
5/11/07 3:15 pm Tak
Patch above applied to all remaining lanes
5/11/07 3:26 pm Tak/Alex
ccLib.php - patch to read only the first credit card
swipe track if there isn't a second, rather than always
try to read the second and error if the array index isn't
there
upcscanned.php - missing argument voided
Applied to lane 12
5/11/07 4:34 pm Tak
Patch above applied to lanes 8, 9, and 10
5/11/07 4:48 pm Tak
Patch above applied to lane 2
5/11/07 6:12 pm Tak
Patch above applied to all remaining lanes
5/14/07 3:03 pm Alex
posbdat.chargeCodeView - added columns to the view so that a row from
this view will satisfy the php function blueLine() the same way a line
from custData does (since that is how blueLine() is used); the missing
columns have been causing PHP warnings; applied to lane 12
5/16/07 9:13 am Alex
applied above to lanes 8, 9 and 10
5/16/07 10:50 am Alex
applied above to all lanes
5/16/07 11:00 am Alex
ccEntered.php,ccLib.php - rewrote ccSwipe() to parse magstripe data
more carefully and tell the cashier to reswipe the card if it doesn't
look right; applied to lane 12
5/16/07 12:57 pm Alex
applied above to lanes 9 and 10
5/16/07 1:30 pm Alex
applied above to lanes 1 and 6
5/16/07 2:10 pm Alex
applied above to lanes 2 and 7
5/16/07 3:10 pm Alex
applied above to all remaining lanes
5/17/07 3:27 pm Alex
ccLib.php:ccSwipe() - added "-1" argument to substr() on return to remove
'?' end-sentinel from the string; the PCCharge docs say the sentinels
should not be included in the '<TRACK_DATA>' xml field, although the '?'
always has been with no problems
ccauthorize.php - clarified unknown-error box message to instruct cashier
to process with carbon
applied to 8,9,10,12
5/17/07 4:18 pm Alex
applied above to 6,7
5/17/07 4:31 pm Alex
applied above to 3
5/17/07 4:45 pm Alex
applied to all remaining lanes
5/18/07 10:15 am Alex
ccLib.php: changed ccTicket() to avoid potential ticket# ambiguity,
and inverted the <MANUAL_FLAG> .INX handling (counter-intuitively,
this flag is supposed to be 0 when manual and 1 when swiped)
applied to lanes 8,9,10,12
5/18/07 10:40 am Alex
applied above to 6,7
5/18/07 10:55 am Alex
applied above to 1,5
5/18/07 11:03 am Alex
ccLib.php: turned off XML validation (removed reference to 'stnd.xdr')
because lane 5 had another Incomplete Trans after last patch; skipping
remaining lanes and pushing this new patch (which includes the previous
one anyway)
applied to 8,9,10,12
5/18/07 11:26 am Alex
applied above to 1,6,7
5/18/07 12:10 pm Alex
applied to all lanes
5/21/07 JDP
changed `suspendedToday` view on Mars & all lanes to select distinct *
5/23/07 3:27 pm Alex
additem.php,pos2.php,prehkeys.php: modified use of SESSION[fntlflag]
to make the corner-box revert to regular subtotal if TL is entered
after FNTL, to avoid confusion
applied to 8,9,10,12
5/23/07 4:42 pm Alex
applied above to 1,6,7
5/23/07 5:07 pm Alex
applied above to 2,5
5/23/07 5:47 pm Alex
applied above to all lanes
5/24/07 1:00 pm Alex
pos2.php,ccDecision.php,ccLib.php: added pccharge-stuck-queue check
for credit card transactions (advisory to use standalone if stuck),
and re-enabled manual card entry (cardnumMMYY format)
applied to lane 12
5/24/07 1:55 pm Alex
applied above to lanes 9,10
(manual credit card entry came back approved at custsvc)
5/24/07 3:20 pm Alex
applied above to lanes 7,8
5/24/07 3:58 pm Alex
applied above to lanes 1,5,6
5/24/07 4:28 pm Alex
applied above to lanes 2,3,4
6/4/07 1:31 pm Alex
SQL:postrans.dbo.payAuthLog and payAuthLogResponse tables created
(to be used for credit card direct processing)
applied to lanes 9,10,12
6/4/07 2:15 pm Alex
applied above to lanes 7,8
6/4/07 4:14 pm Alex
applied above to lanes 1,2,6
6/4/07 4:53 pm Alex
applied above to all remaining lanes
6/5/07 9:08 am Alex
ini/ini.php: $_SESSION["ccDirect"]=0
session.php,sessFunction.php: reset a few more cc* variables
applied to lanes 9,10,12
6/5/07 10:26 am Alex
applied above to lanes 7,8
6/5/07 11:44 am Alex
applied above to lanes 4,5,6
6/5/07 12:15 pm Alex
applied above to all lanes
6/12/07 5:05 pm Tak
pv-id patch applied to lanes 12, 10, 9, 8
and to lanes 1-7 apbw 5:29pm
6/14/07 2:20 pm Tak
"clear to cancel" added to "Unable to Authorize" in ccauthorize.php
Patch applied to lane12
6/14/07 2.32 pm Tak
Patch above applied to all lanes
6/20/07 9:57 am Alex
various dormant changes preparing for ccDirect
clientscripts.php : new function ccdboxMsgscreen()
connect.php : new function sql_sanitize()
sessFunction.php : new session reset ccVoidID
session.php : new session reset ccVoidID
applied to lanes 10,12
6/20/07 11:09 am Alex
applied above to lanes 8,9
6/20/07 2:31 pm Alex
applied above to lanes 1,6,7
6/20/07 4:19 pm Alex
applied above to all remaining lanes
6/20/2007 5:44pm apbw
added a join criterion (date) to ccIntegrated on lanes 12, 10, and 9.
applied to remaining lanes 6/21/2007 7:30am apbw
all lanes now have a date join in ccIntegrated.
6/21/2007 7:30am apbw
created new view ccIntegratedToday on all lanes.
ccIntegratedToday looks into localtranstoday (whereas ccIntegrated looks only in localtemptrans).
6/21/2007 8am apbw
****************** rolled back at 8:45am ! **********************************************
* added new code & created new views for reprinted & other receipts on lanes 12 & 9: *
* code: ccDecision.php, decision.php, printReceipt.php, printLib.php, and reprint.php. *
* new sql views:
* localtranstoday_grouped
* localtranstodaySummary
* localtranstodaySubtotals
* rp_ltt_receipt_reorder_g
* rp_receipt_reorder_unions_g
* rp_subTotals
* modified sql view: rp_receipt_header. *
******************************************************************************************
(when i told fec susan about the new receipt format going universal, she convinced me to roll it back.)
6/22/07 11:09am alex
ccauthorize.php : session[ccTender] bugfix
ccLib.php : pccharge/mysql change
connect.php : pccharge/mysql change
prehkeys.php : charflag patch
applied to lanes 10,12
6/22/07 1:03pm alex
applied above to lanes 8,9
6/22/07 1:57pm Alex
applied above to lanes 6,7
6/22/07 3:12pm Alex
applied aboves to lanes 1,2
6/22/07 4:15pm Alex
applied above to all lanes
6/25/07 4:10pm Alex
additem.php: reset ccSwipe,ccResponse,ccVoidID in additem()
applied to lanes 10,12
6/26/07 9:37am Alex
applied above to lanes 8,9
6/26/07 10:45am Alex
applied above to lanes 6,7
6/26/07 12:12pm Alex
applied above to lanes 1,2
6/26/07 12:34pm Alex
applied above to all lanes
6/27/07 12:19pm Alex
connect.php,loadconfig.php,session.php: part 1 of ccMysql->pccOnline change
applied to lanes 10,12
6/27/07 2:22pm Alex
applied above to lanes 8,9
6/28/07 9:17am Alex
re-merged previous ccauthorize.php error message fix on lanes 8,9,10,12
6/28/07 10:30am Alex
applied above to lanes 6,7
6/28/07 11:25am Alex
applied above to lanes 1,2
6/28/07 2:54pm Alex
applied above to all lanes
6/29/07 10:31am Alex
clock.php,input.php,noinput.php,session.php: part 2 of ccMysql->pccOnline change
applied to lanes 10,12
6/29/07 12:10pm Alex
applied above to lanes 8,9
6/29/07 3:22pm Alex
applied above to lanes 6,7
6/29/07 4:32pm Alex
applied above to lanes 1,2
6/29/07 5:11pm Alex
applied above to all lanes
-----------------
7/3/07 4:45pm apbw
decision.php & ccDecision.php ($_SESSION["chargetender"]=0 commented out.)
part 1 of the patch that extends the new receipt format to all receipts unless the old is specially requested for partials & reprints.
applied to lane 12 & lanexx
7/3/07 5:39pm apbw .
part 2: pos2.php, session.php, printReceipt.php, printLib.php, reprint.php. ***also replace lines 74-91 in ini.php***
applied to lane 12 & lanexx
7/4/07 7:40am apbw
applied entire patch to CSC lane 9.
applied ccDecision.php, decision.php, and session.php to all lanes.
7/4/07 8:08am apbw
oops. sql views might be helpful!
new sql views:
localtranstoday_grouped
localtranstodaySummary
localtranstodaySubtotals
rp_ltt_receipt_reorder_g
rp_receipt_reorder_unions_g
rp_subTotals
modified sql view: rp_receipt_header.
applied to lanes 12 & 9 & 8; tested on 8; applied to all lanes.
applied ini changes to all lanes & tested.
***phase I complete*** ccDecision, decision, session, ini and sql applied to all lanes.***
7/4/07 9:22am apbw
pos2, printReceipt, printLib, and reprint applied to lanes 1-8+10 w/nathan fell's ok -- things are slow, he's overstaffed & excited for the patch.
7/4/07 11:45am apbw
temporarily turned off the new receipt for partials (pos2.php) until subtotal can be handled properly in the sql view.
7/4/07 4:13pm apbw
fixed partial receipts to properly display subtotals & tenders: pos2.php, printlib.php, and reprint.php; modified sql views receipt_reorder_unions_g & rp_receipt_reorder_unions_g.
applied to lanes 12 & 9.
4:40pm lane 10.
5pm applied to remaining lanes.
7/5/07 5:20pm
added some group-by clauses to rp_receipt_reorder_unions_g
lanes 12, 10, 9, 8
lanes 1-7
*** patch complete ***
----------------
7/9/07 apbw
condition added to admintasks.php to disallow suspensions after tenders have been accepted (you must void any tenders before suspending a transaction).
3:45pm lanes 12 & xx
4:30pm lanes 9-10
5:37pm lanes 1-8
-------------------
7/9/07 apbw
group by clauses added to ccIntegrated & ccIntegratedToday, to avoid receipt double-prints when an inx or oux gets put in the table twice (bug discovered at lane 3 when customer got 2 of everything).
6:00 lanes 12, 10, & 9
6:30 lanes 1-8
-------------------
7/10/07 apbw
minor adjustments to line spacing on receipts so that all store copies of charge slips & credit card slips will be the same size/length.
printReceipt.php & printLib.php
8:50am lanes 12, 10, & 9
8:56am lanes 1-8
-------------------
7/10/07 abpw
remember discounts when a suspended transaction is resumed. also, list amountDue as total in the suspended list so that it matches the receipt.
also, line spacing adjustments above needed further tweaking.
files: prehKeys.php, printLib.php, printReceipt.php, reprint.php, resume.php, suspendedList.php.
new sql views (on Mars & Lanes): suspendedSubtotals, suspendedSummary, suspendedSubtotalSummary (to calculate discount & tax for correct amt due).
12:20pm new sql views on mars, lanes 9 & 12. php files transferred to lanes 9 & 12.
12:30pm new sql views on lanes 8 & 10.
1:30pm sql on lanes 6 & 7.
2:07pm sql on lanes 4 & 5.
3:48pm sql on lanes 1-3.
*sql done on all lanes*
fec wants us to wait until tomorrow morning to apply the php part of the patch.
7/11/07 jdp
waited until the morning. patched
*patch completed*
------------------------------
7/12/07 abpw
roll back the "no suspension after tender" patch, because currently cashiers cannot void any PCCharge cc tenders. so they would be stuck if they couldn't suspend after one was tendered.
instead, this will be a feature of the new direct cc processing world.
also, print cc receipts for canceled & suspended transactions; and don't print blank cc slips with reprints. 3 files: adminstasks.php, reprint.php, and printLib.php.
12:40pm lane 12.
12:50pm lane 9.
1:30pm lane 10.
2:05pm lanes 5-8.
3:01pm lanes 1-4.
*patch complete*
--------------------------------
7/15/07 alex
added columns 'StaffID','Password' to posbdat.Employees with preliminary matched StaffIDs based on
name; Cerise has a copy of this list to double-check with the cashiers
9:15am on mars (wedgepos.Employees)
9:43am lanes 10,12
10:11am lanes 8,9
10:59am lanes 6,7
11:53am lanes 1,2
12:34pm lanes 3-5
done
--------------------
7/16/07 abpw
modified sql view "rp_receipt_header" to include trans_status.
reprint.php now uses it to determine appropriate footer for canceled/suspended reprints.
printLib.php -- moved promoMsg() up above footers for charge slip & cc slip.
3:40pm sql view modified on lanes xx, 12, 10, and 9.
3:50pm sql view modified on lanes 1-8.
3:50pm php files copied to lanes xx, 12 & 9.
4:20pm php files copied to lane 10.
5:20pm php files copied to lanes 5-8.
6:05pm php files copied to lanes 1-4.
*complete*
-------------------
7/16/07 alex
5:20pm finished adding $_SESSION["cashierPassword"]=0 to ini/ini.php on all lanes
-------------------
7/18/07 apbw
made teensy edits to connect.php and login.php to eradicate php error messages.
included ini/ini.php in login.php so that when getsubtotals() is called in login2.php the default session variables are there (if session[dbms] isn't set, the default connection type is mysql, which leads to error messages at login time). also removed single quotes from integer variables in max(trans_id) query in connect.php.
4:30pm lanes 12 & 9.
5:00pm lanes 10 & 8.
7/18/07 abpw & alex
pos2.php and void.php dormant support for direct processing
5:05pm lanes 8,9,10,12 (pos2&void)
5:30pm lanes 6,7 (both patches)
6:00pm lanes 1-5
*both patches complete*.
-------------------------
7/24/2007 apbw
another ccDirect patch.
sql changes applied to all lanes at 8:30am. ccDirectBatch.sql includes:
payauthlog & payauthlogresponse (new fields -- cardType etc);
ccIntegrated & ccIntegratedToday (new fields & stricter date joins);
ccReceiptView (new view);
lttSummary & subtotals (new field activeTenders);
screenDisplay (condition added for ccdirect displays).
php changes:
connect.php (new session variable activeTenders and also reversed order of mysql/mssql connect function b/c connect errors persist);
sessFunction.php (new session variable activeTenders)
admintasks.php & pos2.php prohibit cancel/suspend if there are activeTenders (if ccDirect = 1)
applied to all lanes at 8:46am.
2:30pm: dropped & re-created payauthlog & payauthresponse on all lanes, this time with proper indices & default values.
3:00pm: modified lttSummary on lanes 12, 10, and 9 (criteria total<>0 added to activeTenders).
4:20pm: modified lttSummary on remaining lanes 1-8.
*patch complete*
-------------------------------------------
7/24/2007 apbw & atf
authenticate.php, connect.php, lib.php, login.php, and reload.php: alex changed include(ini/ini.php) to include_once.
also created new function to log the php backtrace for connection errors; called from connect.php but currently commented out.
11:15am applied to lanes 12 & 9.
11:45am applied to lanes 7-10.
12:36pm applied to lanes 4-6.
1:15pm applied to lanes 1-3.
* patch complete *
------------------------------------
7/24/2007 apbw
5pm additions to ini.php on all lanes (ccd variables & addl chargeSlipFooters).
* ini.php complete *
--------------------------
7/24/2007 apbw: include_once(maindisplay.php) -- added to suspendedList.php.
5:45 applied to lane 12
5:50 applied lanes 9 & 10
5:55 applied to lanes 6-8
6:00 applied to lanes 1-5
*fix complete*
--------------------------
7/24/2007 abpw
copied 13 new ccd*.php files and security certificate onto lanes (s/b no noticeable effect).
6pm lanes 12 and 9.
7/25/2007 8am ccd* and security certificate copied onto remaining lanes.
*complete*
--------------------------
7/26/2007 2:45pm abpw: had forgotten to comment out line 35 $_SESSION["chargetender"] = 0; in ccdDecision. did now. on all lanes.
--------------------------------------------------------------------------------------------------------------------
7/30/07 atf
updated ccd-related session variables in ini.php, and
added postrans.payAuthLog_{remaining|uploaded}[_today] views
and posbdat.upload_payAuthLog[_today] procedure
9:29am to lanes 10,12
10:33am to lanes 8,9
11:20am to lanes 1,6,7
12:36am all remaining lanes
===========================================
7/30/07 atf
installed .dlls and php.ini settings to enable the cURL extension:
- php-inst/dlls/libeay32.dll, php-inst/dlls/ssleay32.dll, php-inst/extensions/php_curl.dll
copied to /winnt/system32 (or /windows/system32)
- 'php_curl.dll' uncommented in /winnt/php.ini (or /windows/php.ini)
3:23pm on lane 12
will require apache restart to take effect, so further lanes will wait til tomorrow
===================================
7/31/2007 apbw
8am applied new printLib.php to all lanes for ccDirect.
4pm ccauthorize.php: added handling clause for expired cards (were directing cashiers to run a carbon). lanes 12, 10, and 9.
4:30 remaining lanes.
patch complete.
===================================
8/1/2007 apbw
10:18am reworded the error message for invalid expiration date in ccauthorize.php. applied to lanes 12, 10, and 9.
10:30am lanes 4-8.
10:40am lanes 1-3.
complete.
================================
8/2/2007 apbw
adjusted receipt views for correct subtotalling: lttsummary, localtranstodaysummary, subtotals, rp_subtotals, receipt_reorder_unions_g, rp_receipt_reorder_unions_g (scripted in receiptAdjustments.sql; rollback script in panic_city).
6pm lane 12
620pm lanes 9 & 10
654pm lanes 1-8.
*patch complete!*
-------------------------------
8/6/2007 apbw
bug fixes.
1. pos2.php lines 653-655. if discount is entered before member id, call memsearch.php before proceeding. fixes the "discount-halfway-applied" bug that occurred when a cashier entered the discount before the member id ("discount applied" notification would be inserted in localtemptrans, and the discount field updated correctly, but the actual discount would not be given).
2. memlist.php lines 41-47. allow for conditions where $_POST["search"] isn't set, to prevent unknown index error message.
2:36pm pos2.php on lanes 9 & 12.
3:06pm pos2.php on lanes 10 & 8.
3:40pm memlist.php on lanes 9 & 12.
4:00pm memlist.php on lanes 10 & 8.
4:48pm both on lanes 4,5,6,7.
5:52pm both on lanes 1,2,3.
*patch complete*
---------------------------------
8/7/2007 apbw
edited php.ini on all lanes ==> error_log = "c:/is4c/log/IS4C_errors.txt"
and archived existing error logs.
done.
---------------------------------
8/7/2007 atf
ccd_interface, ccdApproved, ccdAuthorize, ccdComm, ccdEntered, ccdLib
miscellaneous updates and fixes
11:40am lanes 10,12
12:36pm lanes 7,8,9
8:54am lanes 1,5,6
10:17am all lanes.
----------------------------
8/7/2007 apbw
updated sql views ccIntegrated and ccIntegratedToday to more accurately id card issuers.
4:19pm lanes 12 & 9.
4:56pm lane 7, 8, 10.
5:17pm lanes 5 & 6.
5:30pm lanes 1-4.
*done*
---------------------------
8/9/2007 atf
patch for 'clear-to-cancel' race condition in select lists
adminlist.php,memid.php,memlist.php,productlist.php,productselected.php,rplist.php,suspendlist.php
10:18am lanes 10,12
11:00am lanes 8,9
12:30pm lanes 6,7
1:43pm lanes 1,4,5
2:29pm all lanes
---------------------------
8/9/2007 atf
resumed cURL install:
- php-inst/dlls/libeay32.dll, php-inst/dlls/ssleay32.dll, php-inst/extensions/php_curl.dll
copied to /winnt/system32 (or /windows/system32)
- 'php_curl.dll' uncommented in /winnt/php.ini (or /windows/php.ini)
2:37pm lane 10
4:54pm lanes 8,9
5:48pm lanes 6,7
8/10/2007
2:43pm lanes 4,5
8/13/2007
10:09am all lanes
--------------------------
8/13/2007 jdp
sql change all lanes: posbdat.products now has numflag field
: posbdat.UpdateProducts store procedure passes blank numflag value
php change lanes 12,10,9,8: upcscanned.php & void.php now pass numflag from select statement to additem() call
8/14/2007 jdp
php change lanes 7,6,5,4,3,2,1: upcscanned.php & void.php now pass numflag from select statement to additem() call
sql change lanes 8,9,10,12 posbdat.updateProducts, newProducts and Products use it -- refreshed newProducts to update view and changed updateProducts
sql change MARS: wedgepos.itemTableView and recentlyEditedItems have numflag,
sql change lanes 1,2,3,4,5,6,7 posbdat.updateProducts, newProducts and Products use it -- refreshed newProducts to update view and changed updateProducts
-----------------------------
8/14/2007 apbw
show available balance on staff charge accounts - on charge slips, over limit msg box, and on "BQ" key entry.
files:
prehKeys.php ("charge limit exceeded. $12.34 available.")
pos2.php (BQ) ("member #1234 available charge balance: $12.34")
printLib.php ("available balance: $12.34" on signed charge slip.)
chgName.php (wasn't printing charge name if lastname was null)
reprint.php (set isStaff session variable).
11:05am lane 12.
11:15am csc lane9.
12:45pm lanes 8 & 10.
2:25pm lanes 1-7.
*patch complete*.
----------------------------
8/15/2007 atf
end.php only delete remote inx/oux when ccDirect!=1
12:44pm lanes 10,12
1:49pm lanes 7,8,9
3:33pm lanes 1,5,6
4:39pm all lanes
----------------------------
8/16/2007 apbw
local challenge patch part I of III.
sql: added new numflag, charflag, & cost fields to 4 sql views: memdiscountadd, memdiscountremove, staffdiscountadd, staffdiscountremove.
php: edit corresponding queries in prehKeys.php.
* new scripts added to dbinit *
1:15pm lane 12
2:03pm lane 9
2:34pm lane 10
3:42pm lane 8
3:50pm lanes 1-7.
*part I complete*
-----------------------------
8/16/2007 apbw
local challenge patch part II of III.
12 sql views (scripted together in LocalReceiptViews.sql)
subtotals & rp_subtotals;
ltt_grouped & localtranstoday_grouped;
lttSummary & localtranstodaySummary;
ltt_receipt_reorder_g & rp_ltt_receipt_reorder_g;
receipt_reorder_g & rp_receipt_reorder_g;
receipt_reorder_unions_g & rp_receipt_reorder_unions_g.
php files (3): connect.php, printLib.php, and reprint.php.
4:45pm lane 12.
5:00pm lane 9.
5:15pm lane 8.
5:23pm lane 7.
5:42pm lane 6.
5:45pm lane 4.
5:50pm lanes 1 & 5.
5:53pm lane 10.
5:58pm lane 3.
6:00pm lane 2.
*part II complete*
---------------------
TO DO for local challenge patch: part III -- set $_SESSION[promoMsg] = 1 in ini.php to turn on the local receipt feature.
--------------------- 8/21-8/22 2007 jdp ---------------------
PROPOSED: add numflag table to posbdat. change postrans.dbo.lltSummary view. change printlib to reference values in numflag table instead of hardcoded numflag product values
---------------------
8/21/2007 jdp Lane06, 07, 08, 10, & 12 patched @ 10:30
8/22/2007 jdp Lane01, 02, 03, 04, 05, 09 patched @ 08:30
8/29/2007 jdp Added script to dbinit!
------------------------
8/21/2007 apbw
turn on local receipt flag (set promoMsg = 1 in ini.php)
2:26 pm lane 12.
2:50 pm lane 9.
3:40 pm lanes 4-10.
4:30 pm lanes 1-3.
* local challenge patch complete *
--------------------------
8/28/2007 5:30pm Tak
Added sts.jpg to graphics folders for all lanes in anticipation of changing the "lock" screen
"RU" patch applied to lanes 12, 9
8/28/2007 6:30 pm Tak
Patch above applied to lanes 10, 8, 2
8/29/07
Patch above applied to all remaining lanes
8/29/07 3:00 pm Tak
Flood relief patch applied to lanes 12 and 9
Patch involves changing ini.php. The original ini.php for lane01 is in panic_city/ini. Sessions variables are added to the ini.php for lane12 but
they do not assume the same values as on other lanes. When the time comes to revert, the ini.php for lane12 does not have to be reverted.
panic city files for the patch is located in flood_panic_city. When the relief drive is over, revert the ini.php files first (all but lane 12
and of course they are all different, so don't just over write) - and
then revert the other files.
8/29/07 later that day
Flood relief patch applied to all remaining lanes
8/29/07 3:50pm alex
added 'tax deductable donation' summary to bottom of receipts when people donate
printLib.php, reprint.php
3:50pm applied to lanes 10,12
4:27pm applied to lanes 7,8,9
5:39pm applied to all lanes
8/31/07 9:11am alex
added 'no goods or services' to donation receipt footer for elka
9:11am applied to lanes 10,12
9:35am applied to lanes 7,8,9
10:37am applied to lanes 1,5,6
11:48am applied to all lanes
8/31/07 2:43pm alex
received live efsnet credentials, added to ini.php
2:43pm applied to lanes 10,12
3:05pm applied to lanes 8,9
3:34pm applied to lanes 5,6,7
4:39pm applied to all lanes
9/5/07 11:41am alex
upload payauthlog to mars on each transaction in connect.php::uploadToServer()
11:41am applied to lanes 10,12
caught typo in ccdEntered.php when trying to void a declined integrated payment
12:49pm applied ccdEntered to lanes 10,12
1:00pm applied both to lanes 8,9
2:20pm applied to lanes 5,6,7
3:11pm applied to all lanes
--------------------------------------------------
9/5/07 1:40pm apbw
patched upcscanned so that "empty" deli barcodes (ones that end with 4 or 5 zeroes) will use the standard qty x unitprice calculation instead
of ringing up at zero dollars. this will keep the deli chargebook keyboard in synch with price changes, and scanning will no longer have to
hard-code the unit prices on the keyboard. i anticipate no effect on other lanes, since there all scale barcodes are taken from a label and have a price.
1:40pm lane 12.
2:40pm lane 9.
4:31pm lanes 8 & 10.
4:50pm lanes 5-7.
5:06pm lanes 1-4.
*patch complete*
9/5/07 2:40pm apbw
patched printLib.php, printReceipt.php, and reprint.php to eliminate all excess blank lines in the hopes of wasting less paper
(response to a customer comment & approved by lindy).
2:40pm lanes 12 & 9.
4:31pm further changed printLib.php to suppress "division by zero" error when calculating local percentage, and to only show percentage if over 0.
4:31pm lanes 12, 10 (just updated printlib.php), 9, 8 (all 3 files).
4:50pm lanes 5-7 all files.
5:06pm lanes 1-4 all files.
*patch complete*.
-----------------------------------------------
9/7/07 1:11pm atf
ccdAuthorize.php, ccdLib.php, ccdComm.php error message patches in preparation for live ccDirect
1:11pm lanes 10,12
2:14pm lanes 7,8,9
3:12pm lanes 4,5,6
4:04pm all lanes
9/10/07 5:00PM JDP Free Apples patch to void.php
Lanes XX,12,10,9
9/11/07 10:00AM->11:00AM JDP More Free Apples
Lanes 08,07,06,05->04,03,02,01
9/13/07 9:34am atf
ccdAuthorize.php, ccdComm.php, ccdEntered.php; better error message instructions, reversed order of
card data checks (now PAN, issuer, exp), added .76 and .77 test error amounts (for processor error,
internal error respectively)
9:34am lanes 10,12
10:30am lanes 7,8,9
10:53am lanes 4,5,6
11:08am all lanes
9/14/07 8:54am atf
ccdEntered.php typo
8:54am lanes 4,5,9
10:03am lanes 8,10,12
10:54am all lanes
9/15/07 4:00 pm Tak
Added two session variables numericInput and additem to session.php
in anticipation of "double read" patch
patch applied to all lanes
9/20/07 10:40am atf
added 'reloadProducts' to weeHours job to sync with changes to mars' itemtable at 2am
10:40am lanes 10,12
11:45am lanes 7,8,9
12:24pm lanes 4,5,6
12:59pm all lanes
9/20/07 4:56pm atf
refnum/date bugfix in ccdEntered and ccdComm
4:56pm lanes 10,12
5:31pm lanes 6,7,8,9
5:45pm lanes 4,5 -- remainder tomorrow
-----------------------------
9/21/07 7:30am apbw
deli discount at CSC patch:
upcscanned.php and sql view "screenDisplay" -- allows 10% staff deli discount to be applied to certain items when the 10PD key is hit.
CSC will be the only lane to have the key (emily will have it ready monday morning), and they are only to use it when the chargebook is down.
also corrects an error in the display when scale bar codes are scanned.
applied to all lanes. patch complete.
-----------------------------
9/21/07 8:17am atf
finished refnum/date bugfix on all lanes
--------------------------
9/21/07 12:59pm apbw
fixed date formatting bug in printLib.php. new ccslips were printing the month where the minutes should be. ack!
lanes 9 & 5.
lanes 3 & 4.
all other lanes.
patch complete.
-------------------------
9/21/07 5:00 pm Tak
removed all ini.php from the webroot, ie., c:\is4c\ The ini.php in
c:\is4c\ini\ are, of course, untouched.
-----------------------
9/23/07 8:30am apbw
it's sunday, i know, but if you try to void an item on volspecial it's all buggy so i made a tiny change to void.php,
after confirming that it doesn't interfere with the free apples patch.
8:30am lanes 12 & 9.
8:48am lane 1 (since it will be slow when we open).
10:10am remaining lanes.
** patch complete **.
---------------------
9/24/07 9:30am atf
some session vars and minor tweaks preparing for cc void patch (additem, session, input)
9:30am lanes 10,12
10:03am lanes 7,8,9
10:39am lanes 1,5,6
11:20am all lanes
---------------------
9/26/07 2:30pm jdp
changed ltt_receipt_reorder_g & ltt_grouped views in postrans
12,XX,10,9,8,7,6,5,4,3,2,1 - liftoff!
--------------------
9/27/2007 apbw
tenderReport.php: prints negative numbers in bold font, and summarizes charges/purchases vs refunds/credits.
11:02am lanes 12 & 9.
12:15pm lanes 1-8 & 10.
patch complete.
--------------------
9/27/2007 apbw
reprint.php: was printing staff charges as negative number. now fixed.
12:32pm lanes 12 & 9 & XX.
1:25pm lanes 1-8+10.
patch complete.
-------------------
9/27/2007 apbw
sql views localtranstoday_grouped and rp_ltt_receipt_reorder_g --> applied john's changes for better "member special" grouping/summing/display.
1:44pm lanes 12 & 9 & XX.
2:30 all other lanes.
patch complete.
------------------
9/27/2007 atf
big fun credit card auto-void patch!
ccdApproved, ccdAuthorize, ccdboxMsg2, ccdComm, ccdDecision,
ccdEntered, ccdVoided, prehkeys, printLib, void
2:58pm lane 10
3:41pm lanes 9,12
4:24pm lanes 6,7,8
5:10pm all lanes
------------------
9/28/2007 apbw
printLib.php: frankstock() function -- shortened the date format and added member number
10:15am lanes 12 & 9.
11:20am all other lanes.
patch complete.
-------------------
9/28/2007 apbw
12:15pm changed sql view Earth.WedgeMbr.dbo.CustomerView to limit 28xxxx member numbers (other co-ops) to $10 cash back. per Elizabeth & Elka request.
then re-ran MakePOSCustomers on Earth and synchronized lanes.
--------------------
9/28/2007 apbw
limit juice bar items:
1. added $_SESSION["limitToDept"] to ini.php, and set it to 14 on juice bar,
to limit the items that can be rung there (because they accidentally ring staff id's as PLU's).
all lanes 12:25pm.
2. added to upcscanned.php:
if (isset($_SESSION["limitToDept"]) && $_SESSION["limitToDept"] != 0) {
$query .= " AND department in (".$_SESSION["limitToDept"].")";
}
12:30pm deli & juice bar.
12:46pm CSC.
1:38pm all other lanes.
*patch complete*
--------------
9/29/2007 apbw
revamped Juice Club Cards:
clubCard.php --> complete overhaul for debugging (ability to void, ability to apply 2 cards to one item, etc).
void.php --> improved handling of voided Juice Club cards & their target items.
8:10am lanes 12, 10, and 9.
3:10pm all other lanes.
*patch complete*
---------------
9/30/2007 apbw
clientscripts.php - clearinput() function: corrected typo (strendered s/b strEntered) and disabled the auto clearing of tare weights.
8:50am lanes 12 & 9.
9:05am lane 1.
9:30am all lanes.
*patch complete*.
----------------
10/4/07 atf
fixed cc online icon, and session var prep for future paycard/giftcard patch
12:05pm lane 12
12:26pm lane 10
1:36pm lanes 8,9
2:43pm lanes 5,6,7
all lanes -- patch complete.
----------------
10/4/07 apbw
void.php:
backed out the "free apples" patch (and my tweak of it)
so that void.php doesn't try to match on quantity or itemQtty at all.
because if you enter multiple quantities of an item, then try to void
one by hitting VD and scanning the item, neither qty field will match
and the voiding gets all messed up.
i'll continue the struggle to debug and improve the entire voiding process.
5pm lanes 12 & 9.
5:46pm lanes 1-10.
*patch complete*.
-------------------
10/5/07 apbw
void.php: more bug fixes.
new "free apples" fix on line 295 -- set correct memDiscount value for voids.
also excluded staff & member specials
from the queries in lines 180-206 so they don't skew the "voidable" amount.
added refunds to line 56 so they are voided by voidid function instead of voidupc function.
converted $voidable from float to decimal to improve quantity calculations.
TO DO: change quantity and itemQtty from float to decimal data type.
2:24pm lane 12.
3:25pm lanes 9 & 10.
4:30 all lanes.
* patch complete* but void.php still needs work.
---------------------------------------
10/5/07 apbw
void.php: last fix of the day -- set session['refund'] back to 0 before calling additem in voiditem().
5:40pm lanes 12 & 9.
5:45pm lane 10.
5:50pm lanes 7 & 8.
6:07pm all other lanes.
* patch complete* but void.php still needs work!
-------------------------------
10/6/07 apbw
printLib.php: found an un-closed if-then-else clause that may have been causing cc sig slips to not print.
5pm lanes 12, 10, 9.
5:20pm lanes 5-8.
5:30pm lanes 1-4.
*patch complete *
----------------------
10/7/07 apbw
ccdAuthorize.php: changed printReceipt("ccSlip") to receipt("ccSlip") because some ccSlips are still not printing.
11:50am lane 2 (that's where the problem has been most evident this a.m.).
printLib.php: changed the query in printCCSigSlip, because i found a loophole where it might return nothing.
12:33pm lane 1.
12:35pm put both files on lane 2.
1pm both files, all lanes.
* patch complete, and i believe this bug should now be fixed. *
-------------------------
10/8/07 4:30 pm Tak
Added fields memType and staff to dtransactions and suspended on Mars. Re-established views needed for suspended sales.
Added the same fields to the following tables: dtransactions, localtemptrans, localtrans, localtransarchive,
and suspended on lane08 and lane12, re-established the views: localtranstoday, suspendedtoday, trans_uploaded,
and trans_remaining.
10/9/07 12:30 pm Tak
Removed the decimal wrapper for $voidable in void.php
Applied to lanes 9, 10, 12
10/9/07 12:50 pm Tak
Patch above applied to lanes 5, 6, 7, 8
10/9/07 1:00 pm Tak
Patch above applied to all remaining lanes
10/10/07 Tak
Fields added to Products on all lanes, all related views and stored procedures re-established.
10/11/07 atf
another paycard/giftcard prep patch
paycard*.php copied to lanes, session.php no longer relies on paycardLib, new variables in ini
3:19pm lane 12
4:06PM lanes 9,10
4:33pm lanes 6,7,8
5:19pm all lanes
------------------
10/11/07 apbw
void.php -- get correct memDiscount value from products table when voiding an item
(fixes bug where you ring in a member special, void it, enter a member id, and get the member special adjustment on the voided item).
3:52pm lanes 12 & 9.
5:29 all other lanes.
* patch complete *
--------------------
10/12/07 apbw
ccdAuthorize.php --> set currentid to lastid+1, so that printCCSigSlip knows which receipt to print.
4:49pm lanes 12 & 9.
5:17pm lanes 7, 8 & 10.
5:42pm lanes 4-6.
5:50pm lanes 1-3.
*patch complete *
-----------------
10/15/07 atf
paycard patch on lane 9, will sit for a few days before continuing
efsnet, paycard*, pos2, prehkeys, printLib, printReceipt, reprint, void
9:40am lane 9
10/15/07 atf
addendum to paycard patch running on lane 9; changed alert box header to card type,
added "rp" option to boxes where slips print
paycard*, drawscreen
4:45pm lane 9
addendum complete
10/17/07 atf
paycard patch continues
9:25am lane 12
9:29am lane 10
10/17/07 atf
second addendum to paycard patch on lanes 9,10,12
database (tables.sql,views.sql,procs.sql): established gift card tables, views and procs
connect.php: upload gift card data
paycardConfirm*.php: better CL handling
paycardLib.php: bug in error text generation
reprint.php: gc/cc footer order
session.php: comment note
void.php: gift card voiding, pre-ccd bug in voidid() with $foodstamp, copy charflag to void line
11:49am lane 12 sql
12:02pm lane 12 php
12:05pm lane 10 sql
1:36pm lane 9 sql
2:03pm lane 9 php
addendum complete
10/18/07 atf
adding giftcard sql to all remaining lanes; paycard php changes remain 9,10,12 only
10:16am lanes 7,8 sql
10:45am lanes 4,5,6 sql
11:54am all lanes
sql complete
10/18/07 atf
paycard patch continues
2:45pm lanes 6,7,8
3:20pm lanes 4,5
3:50pm all lanes
paycard patch complete!
---------------------------------
10/18/07 atf
ccd cleanup -- rename ccd*.php to _ccd*.php (all functionality now in paycard*),
comment ccd/pccharge session vars in ini.php (now hardcoded in efsnet.php or defined in ini/efsnet.conf.php)
4:00pm lane 12
4:40pm lane 10
10/19/07 atf
finish cleanup
11:02am lanes 6,7,8,9
11:19am all lanes
10/19/07 atf
forbid suspend/cancel after active integrated giftcard
admintasks,connect,pos2,clientscripts, postrans.lttSummary and subTotals views
11:38am lanes 9,12
11:58am lanes 6,7,8
12:25pm all lanes
10/19/07 atf
printLib for name&phone footer on gift card activation slips,
tenderReport for gift card tenders and sales (views added to Mars)
valutec.php file in place!
ini/valutec.conf.php for terminalIDs (different for each lane! make sure to uncomment only one line!)
3:10pm lane 12
3:45pm lane 9
4:28pm lanes 5,6,7,8
5:05pm all lanes
giftcards now fully in place, ready for gcIntegrate=1,gcLive=1
---------------------------------
10/20/07 apbw drop & recreate these views on all lanes, replacing select * with field list:
10:46am ltt_suspend_remaining
10:52am ltt_suspend_remaining_local.
11:00am ltt_suspended
ltt_suspended_local.
11:10am dtrans_uploaded
dtrans_remaining.
11:16am suspendedToday on Mars and Io.
11:22am suspendedToday @ lanes.
11:33am localTransToday.
(everything also copied to dbinit).
-----------------------------------
10/22/07 atf
paycardEntered, pos2, prehkeys -- fixes for bugs reported over the weekend re: voiding test cards
and mis-flagging standalone cc entries
11:45am lane 12
12:12pm lane 9
--added tenderReport.php to remove bus pass sales, which cerise doesn't need anymore
12:40pm lanes 9 and 12
1:37pm lanes 6,7,8
2:07pm lanes 3,4,5
2:31pm all lanes
10/22/07 atf
noticed a bug in valutec.php after first live gift card transaction -- identifier was stored
on response, but not on request
3:13pm lane 12
3:36pm lane 9
4:00pm lanes 6,7,8
4:47pm lanes 3,4,5
5:27pm all lanes
10/24/07 10:12am atf
enabled gcIntegrate and gcLive on all lanes, cerise will instruct cashier as she likes
----------------------------------------
10/26/07 apbw suspend/resume patches:
11:26am changed view SuspendedToday on mars, io, and all lanes to select top 100% with sort criteria.
connect.php (new optional sort criteria for inserttrans() function);
special.php (use those sort criteria; also new provision for cases when unable to suspend transaction;
pos2.php (added <br> in staff charge balance message).
12:13pm lane 12.
12:49pm lanes 9 and 8.
1:24pm lanes 4-7.
2:43pm lanes 1-3+10.
TO DO: use numflag instead of suspended table to indicate suspend/resume status.
--------------------------------------
10/30/07 atf
split payAuthLog into efsnet* tables; view ccReceiptView, files
printLib, paycardEntered, efsnet, paycardConfirm* -> paycardboxMsg*
8:45am lane 9 (and mars' copies from lane 9 only)
10/31/07 atf
added efsnet relay to ares at http://10.10.100.23/efsnet/relay.php
efsnet.php now sends its second reversal via ares (on the dsl)
added altRoute to postrans:efsnetRequestMod, re-saved efsnetRequestMod_remaining* views
if the request and first reversal (on t1) both time out
8:45am lane 9
11/01/07 atf 8:45am
split tables and backup-reversal now on all lanes
all payAuthLog data migrated to efsnet* tables on all lanes and mars
payAuthLog remains, but no longer used
11/01/07 atf 4:30pm
connect.php and lib.php to log timed out sql queries and stop uploading payAuthLog (just efsnet, now)
4:30pm lane 9
5:00pm lanes 7,8,12
5:25pm all lanes
----------------------
11/3/07 apbw (with the blessing of the fec & feam)
implement $10 idea to print receipt totals in bold (printLib.php).
fix right-alignment of local items on receipt (sql views rp_receipt_reorder_g & receipt_reorder_g).
make reprint a function called from end.php, to speed it up (rplist.php, end.php, and reprint.php).
3:30pm lanes 12 & 9.
3:45pm sql views on all lanes.
4:45 lanes 7 & 8.
5:20 lanes 5 & 6.
5:40 lane 10.
5:45 lanes 1-4.
* patch complete*. but reprinting still takes too long!
------------------------------
11/4/07 apbw
a couple more things to help speed up reprints:
added field to localtranstodaysummary: TaxExempt (otherwise, no way to know if trans was tax exempt) ** field removed later that day; replaced with "actualtax" **
added fields to rp_subtotals: custData.Type (to avoid running 2nd query in reprint.php) and localtranstodaysummary.taxexempt ** replaced w/ "actual tax" later that day **
reprint.php: commented out a bunch of extra (possibly time-consuming) code.
7:39am: lane 9 & tested
8am: all lanes.
--------------------------
11/4/07 apbw
faster reprints. part 3.
rplist.php: found that, with rplist submitting to end.php, the clear function didn't work and caused a blank white screen. fixed.
pos2.php: found a major reason that RP was taking soooo long: pos2 was running a query on localtrans to determine whether there were any receipts available for reprinting, then going on to
rplist.php (regardless of query results), which was re-running a very similar query. fixed.
reprint.php: fixed typo in "could have saved" number formatting.
9:45am applied to all lanes.
----------------------------
11/4/07 apbw
correctly assess tax exempt status of a transaction for reprints. (probably still better to start using numflag though).
reprint.php and 3 sql views (localtranstodaysummary and localtranstodaysubtotals: new actualTax field replaced taxExempt field; rp_subtotals: new taxExempt field).
2pm lanes 12, 9, and 8.
2:15pm all other lanes.
patch complete
--------------------------------
11/7/07 atf
pos2.php, printLib.php, printReceipt.php
add 8102 to list of tax-deductable-donation PLUs to print a receipt footer for
in the future, we should really just use a products table numflag and add a checkbox for
scanning, but this will do for now
postrans.localtranstodaySummday.VIW, config.loadData.PRC
fixed typo in localtranstoday (numflag = 1 instead of & 1 for localTotal)
removed loadNumflag from loadData since posbdat.numflag is not used anywhere and not maintained
previous patch mentions new field 'taxexempt' in localtranstodaysummary, but it doesn't seem to be on any lanes..
drawscreen.php
patched check for other-coops to 2828 instead of just 28 (we just printed member card 280000)
12:30pm lane 9
2:30pm lane 12
2:50pm lanes 6,7,8
4:33pm all lanes 1,2,3,4,5,10
patch complete
---------------------------------
11/8/07 apbw
added numflag & 64 criteria to all polling & repolling procs & views on mars that refer to trans_status 'X'
(in preparation for suspend/resume/cancel numflag patch).
(we can remove the trans-status 'X' criteria when the dust has settled).
----------------------------------
11/9/07 apbw
huge patch to use numflag for canceled, suspended, and resumed transactions.
sql procs: dayendreset and restore lane ("truncate table suspended" commented out).
sql tables: suspended table dropped on mars & lanes (contents put into new suspendedArchives table for safekeeping).
sql views: suspended (now a view of dtransactions) and suspendedToday (both @ mars & lanes)
dLog_dayend
localtranstodaySummary
ltt_suspend_remaining (and " local)
ltt_suspended (and " local)
rp_receipt_header
resumedinstandalone
php: additem, connect, end, reprint, resume, special, upload.
7:30-8am: applied to mars and all lanes and tested at lanes 8 & 9.
patch complete.
-----------------------------------
11/9/07 atf
bit math tweak in end.php,resume.php,special.php
10:30am lane 9
12:42pm lanes 7,8,12
1:54pm all lanes 1-6,10
11/9/07 apbw
added a 2nd query to connect.php uploadToServer() function, to synchronize numflag of resumed transactions on server & lane.
(if the 2 resumed synchronization queries are too slow, we'll comment them out and put them in dayendreset or cleartemptables).
10:58am lane 9
1:05pm lanes 7,8,12.
4:42pm lanes 1-6+10.
patch complete.
---------------------------------
11/10/07 apbw
uploadToServer takes 6 seconds because of new UpdateResumedRemote query; so i'm commenting it out . . .
11:35am lanes 12 & 9
11:45am lanes 10 & 6.
11:50am lanes 7 & 8.
11:55am lanes 1-5.
. . . and adding it to dayEndReset:
12:50pm lanes 12, 10, and 9.
1:42pm lanes 1-8.
also corrected a typo in suspendedlist.php that caused the query to fail in standalone.
2:13 all lanes.
--------------------------------
**no more patches before thanksgiving!**
----------------------------------
11/13/07 jdp - tak approved
upcscanned.php patch to record regPrice as the product's price from the itemTable. Allows for scaletag items to record their price per unit price in
addition to the price per package price
08:15 all lanes
this patch makes obsolete the z_movement_meat_poll job and stored procedure on mars
----------------
11/15/07 apbw -- tak approved
comment out testremote() call in special.php suspendorder() function.
4:38pm lanes 12, 9, 8
5:07pm lanes 1-7 + 10
*patch complete*
-----------------------
11/15/07 apbw
make admintasks.php redraw the main screen immediately with the "trans suspended" message,
instead of waiting for pos2.php to do it after everything is finished.
5:45pm lanes 12 & 9.
tested at lane 9 & tweaked.
5:54pm lanes 8, 7, 6.
5:58pm lanes 5, 4, 3, 2, 1, 10.
*patch complete*.
------------------
11/15/07 apbw
ditto with cancelorder() function in mgrauthenticate.php.
6:20pm lanes 12 & 9.
11/16/07 7:45am lanes 1-8 + 10.
*patch complete*
--------------------------
11/16/07 apbw
ditto with reprint: rplist.php, end.php, and reprint.php.
8:33am lanes 9, 10, & 12.
9:05am lanes 1 & 2
9:10am lanes 3-8.
* patch complete*
--------------------
11/16/07 apbw
a couple tiny things to make resume go a little faster,
but nowhere near as dramatically as suspend, cancel, and reprint.
12:40pm lanes 12 & 9.
2pm lanes 1-8 + 10.
* patch complete*
-----------------
11/17/07 apbw
changed wording of "transaction suspended" message to "suspending transaction <br> please wait . . . "
in admintasks.php, to avoid panic and impatient button pushing during suspension process.
1:45pm lanes 12, 10, 9, 8.
2:36pm lanes 4-7
3pm lanes 1-3.
*patch complete*.
--------------------------
11/17/07 apbw
after voiding mfr coupons, you can't re-apply them or suspend or cancel the transaction, due to a bug in how mfr coupons are (a) voided and (b) tallied.
i fixed the bug in mcoupon.php and void.php.
3pm applied to lanes 12, 10, 9, and 8.
3:05 lanes 7, 6, 5.
3:10 lanes 1, 2, 3, 4.
*patch complete*
---------------------
11/18/07 apbw: another attempt to improve speed at the lanes.
adminlist.php: new javascript function to overwrite form with a "please wait" message, so cashiers can't keep resubmitting the form by hitting the enter key repeatedly
(which only slows things down). also adjusted "please wait" message in admintasks.php so transition between the 2 wait messages will appear more seamless;
and changed the "trans canceled" message in mgrauthenticate.php to "canceling, please wait".
12:20pm lanes 12, 9, and 8.
2:05pm lanes 4-7 + 10.
3pm lanes 1-3.
*patch complete*
------------------------
11/24/07 apbw: fix a receipt reprint bug
scannable mfr coupons & green patches are stamped as trans_type 'T' (tender) when the transaction is over;
so they print differently on reprints than they do on originals (and poorly at that). i changed 3 sql views so that the reprints
will look just like the originals. i'm guessing this could use more work and that more wrinkles will be discovered as time goes by.
localtranstodaySummary, rp_ltt_receipt_reorder_g, and rp_receipt_reorder_g.
5:30 lanes 12, 9, and 8.
11/25/07 9am apbw
lanes 1-7 + 10.
*patch complete*
-------------------
12/4/07 atf
adding storecard sql to lanes
(postrans tables and views, posbdat procs, updated config procs)
10am lanes 8,9,12
10:40am lanes 5,6,7
11:30am lanes 1,2,3,4,10
patch complete
12/5/07 atf
storecard switch and dormant code:
ini/ini.php,ini/storecard.conf.php,checksum.php,storecard*.php
type and error message tweak:
valutec.php
9:30am lanes 8,9,12
10:30am lanes 5,6,7
11am lanes 2,3
11:45am lanes 1,4,10
patch complete
12/5/07 atf
storecard support in existing functions, all dormant while ini is off:
paycardlib.php, prehkeys.php, printlib/receipt.php, reprint.php,
tenderreport.php, void.php
2:10pm lane 12
3:10pm lanes 7,8,9
3:50pm lanes 5,6
5:20pm lanes 2,3
5:35pm lanes 1,4,10
patch complete
12/6/07 atf
bug in sql query when searching for a string with a ' in it on mssql
productlist.php
9:40am lanes 8,9,12
10:35am lanes 5,6,7
11:40am lanes 2,3
2pm lanes 1,4,10
patch complete
12/6/07 atf
intermediate versions of postrans views lttSummary and subTotals, including
activeItems and instoreCredit but also still including activeGC
3:20pm lane 12
5:20pm lanes 6,7,8,9
5:55pm lanes 1,2,3,4,5,10
patch complete
-------------------------
12/7/07 apbw
alter ccReceiptView, gcReceiptView, and storecardReceiptView to show reversals/cancellations/voids as the opposite amount of their
original counterpart (purchase as +, refund as -, purchase canceled as -, refund canceled as +).
7:54am ccReceiptView all lanes.
8:29am gcReceiptView and storecardReceiptView all lanes.
*patch complete*.
-----------------------------
12/7/07 apbw
input.php and pos2.php: added javascript to allow for page up, page down, home, and end
keys to navigate up & down in a transaction (instead of arrowing up & down one line at a time).
8:11am lanes 12, 9, and 8.
8:42am lane 1.
(apply to remaining lanes sunday if it runs well here friday & saturday).
12/9/07 apbw 8:30am
applied to all remaining lanes.
*patch complete*.
--------------------------------------------------
12/10/07 atf
storecard upload, intermediate connect (both activeGC and activeItems), ares by IP
connect.php, storecard.php
9:37am lane 12
11:15am lanes 8,9
11:40am lanes 5,6,7
12:30pm lanes 2,3
1:05pm lanes 1,4,10
patch complete
12/10/07 atf
storecard input, test against activeItems instead of activeGC
admintasks.php, pos2.php
2:00pm lane 12
2:35pm lanes 8,9
3:10pm lanes 5,6,7
4:10pm lanes 1,4,10
patch complete
(12/15/07 8:30am lanes 2 & 3 -- apbw)
12/10/07 atf
removed activeGC from connect.php; no longer referenced anywhere in code
4:30pm lanes 7,8,9,12
5:00pm lanes 2,3,5,6
5:45pm lanes 1,4,10
patch complete
12/11/07 atf
synced mars script library with lane sql, removed activeGC from lttSummary and SubTotals
11:30am lane 12 (full sql export of lane12 in config/posbdat/postrans on vmyevaud::c:\dbinit\)
12/12/07 atf
sql continues
9:20am lanes 8,9
10:20am lanes 5,6,7
12:30pm lanes 2,3
2pm lanes 1,4,10
patch complete -- all wedgecard code and sql now in place
12/16/07 jdp - no more flood
7-9AM lanes 1,2,3,4,5,6,7,8,9,10,12
transfer files in transfer_next and panic files in panic_city
ini.php changed, three session variables deleted
12/17/07 atf - lane sync 9:25am
diff'd all lanes and found a handful of files missed during patching
lane2: pos2
lane3: loadconfig, pos2
lane10: clientscripts, session
all lanes php should now be in sync
12/27/07 12:20 pm tak
Replaced key with rooster in login3 and invalid3
Applied to lanes 9 and 12
12/27/07 2:00 pm tak
Patch above applied to all remaining lanes
12/27/07 4:15 pm tak
Minor layout adjustments made
Patch applied to all lanes.
12/31/07 atf
made PV parse barcodes like upcscanned, so it can handle ean13 deli labels
productlist.php
added sql_ping(target, connection) to have mssql ping a linked server
connect.php
added sql_ping() checks for mars->earth before using earth-based views for MI etc
prehkeys.php, printlib.php, membercommentplus.php
1:52pm lane 12
2:20pm lanes 8,9
3:15pm lanes 5,6,7
3:50pm lanes 2,3
4:20pm lanes 1,4,10
patch complete
1/2/08 atf
bugfix for wedgecard barcode scanning (lane scannerscales drop the check digit)
pos2.php, prehkeys.php, storecardAuthorize.php, storecardEntered.php, void.php
9:50am lane 12
10:20am lanes 8,9
11:20am lanes 5,6,7
12:15pm lanes 2,3
12:45pm lanes 1,4,10
patch complete
---------------
1/3/08 apbw
edit 2 sql views in postrans: ltt_grouped and localtranstoday_grouped, so that
multi-item GM PLU's for clothing and jewelry are itemized rather than grouped
& summed on the receipt. per request from cerise and adrienne.
3:50pm applied to lanes 12 and 9.
1/4/08 - 8:12am: applied to lanes xx, 1,2,3,4,5,6,7,8, and 10.
patch complete.
---------------
1/4/08 atf
added tender report type/cashier/date tag to the bottom of each report as well
as the top, so clerks can fold them with the totals
tenderReport.php, printLib.php
9:15am lane 12
10:05am lanes 6,7,8,9
11:40am lanes 2,3,5,XX
12:05pm lanes 1,4,10
patch complete
---------------
1/7/08 atf
bugfix in efsnet for alt-route reversals (PK violation, seen on lane1 1/5/08)
efsnet.php
8:25am lane 12
10:00am lanes 6,7,8,9
12:15PM lanes 2,3,5,xx
1:40pm lanes 1,4,10
patch complete
---------------
1/15/08 atf
enabled storecardIntegrate,storecardLive in ini.php
11:40am all lanes
1/18/08 atf
added partial-approval to storecard system; if a card is tendered for more than
its balance, only the available balance is approved (emptying the card) and the
amount approved is returned to the POS, rather than failing entirely with NSF
storecard.php, storecardEntered.php, storecardAuthorize.php
sql tables lane.postrans.storecardResponse, mars.wedgepos.storecardResponse
sql views re-saved lane.postrans.storecardResponse_remaining[_today]
8:30am all lanes and mars
1/18/08 atf
wedgecard receipts (store and customer copy) were incorrectly printing the
attempted charge amount rather than the approved amount (for partial approvals)
sql view postrans.storecardReceiptView
12pm all lanes
==========================================================================================
1/18/08 apbw 2:08pm: refund module on lane 9.
1. ini.php -- new line added to end of file ($_SESSION["authRequired"]).
2. sql: tons of additions + 3 changes (cachedata, lttsummary, & subtotals); all scripted in transfer\sql folder.
3. php: 10 new files & 26 existing files changed.
-----------------
1/18/08 apbw 3:52pm: patch refund module on lane 9:
added purchasedate to refundslip view and edited printLib.php to make use of it.
-----------------
1/18/08 apbw 4:15pm: fix refundContactCheck to correctly bypass contact info screen when appropriate (lane 9).
-----------------
1/19/08 apbw (all refund module, lane 9 only).
9am: refundReceipt.php - more javascript to automatically advance to next field after dates have been typed in.
refundOtherInfo.php - added a note to reject future dates & remember rejected form data.
10am: refundReasonList.php - give deli chargebook same default reason as juicebar.
2:55pm: refundSlip view and printLib.php: improve handling of "other" field on refund slips.
3:08pm: added on/off switch to ini.php; added wrapper to 9 php files; minor changes to 5 other files.
3:40pm: excluded voided refunds from refundTotal in lttSummary view.
==========================================================================================
1/20/08 apbw
7:30am:
- sql applied to all lanes.
- 2 session variables added to ini.php on all lanes with refundModule turned OFF but authRequired=1 (to require FEC approval before tendering any refund, per cerise).
- php files transferred to lanes 12 & 1 only.
11:37am fix bug in refundOtherInfo.php, refundReasonSelected.php, and prehKeys.php that only comes up when you do an open ring refund over the dept limit.
lanes 9, 12, and 1.
3:00pm: set authLevel=0 on all lanes except 1 & 12 (and 9, which is its default) so that when php files are copied over nothing will change.
3:05pm: php files copied to lanes 8, 7, 6.
5:04pm: php files copied to lanes 10 and 5.
5:15pm: php files copied to lanes 2, 3, & 4.
*PHASE I COMPLETE!*
all sql, php, and ini files are in place.
to require FEC code before tendering out any refund, set authLevel = 1 at each lane except CSC.
to turn on refundModule, set refundModule = 1 at each lane.
but first!!!:
make triple sure that FEC's are ready before setting the authLevel.
***do not turn on refundModule beyond CSC until bugs are fixed!***
see whiteboard list for bugs & wishes.
==========================================================================================
1/20/08 apbw 5:40pm: bug fix in mgrlogin.php, all lanes. patch complete.
1/20/08 apbw 7pm: re-create sql views refundcommentsremaining & refundcommentsremainingtoday. argh! all lanes, complete.
---------------------------------
1/21/08 atf
sql view storecardReceiptView to print header for 'cashout' mode
12:00pm lane xx
12:50pm lanes 6,7,8,9,12
2pm lanes 1,2,3,4,5,10
1/22/08 atf
added 'wedge card cash-out' option, to take balance off a wedgecard as a negative-total
item, in order to refund it to cash/creditcard/etc; added "CC"/"GC"/"WC" tag in upper-left
of store copy slips
paycardLib, printLib, pos2, storecardEntered, storecardAuthorize, storecardboxMsgAuth,
storecardboxMsgCashout, storecard, prehkeys, storecardSuccess
also changed mars.wedgepos..TenderTape3 to include type=I upc=0990% as WC tender
10:50am lanes xx,8
11:10am lanes 6,7,12
11:30am lanes 1,2,3,5,9
1/22/08 atf
bug in prehkeys.php::tender() !! invalid tender code (not in Tenders table) prints error
but continues anyway; missing 'else' before 'if' to request mgr code, for refund patch
merging with current cashout patch
11:44am lanes xx,8,9,12
11:47am lanes 1,2,3,5,6,7
patches marged, finishing both
11:50am lanes 4,10
1/23/08 atf
valutec changed the XML format of NSF decline responses for gift cards, such that the
available balance was no longer shown to cashiers; our code should now handle either
the old or new version and generate a full message (NSF, BAL: $x.xx)
valutec.php
5:08pm lanes xx,8
5:40pm lanes 5,6,7,9,12
5:50pm lanes 1,2,3,4,10
complete
===================
1/24/08 apbw
re-script refundCommentsRemaining & refundCommentsRemainingToday on all lanes. double argh! all lanes, complete.
=====================
1/25/08 apbw
refund debugging on lane 9.
adminlist: remove the waitmsg function, which occasionally interferes with form submission.
clientscripts: define javascript variable lockscreen to make firefox happy.
mgrauthenticate: add dummy input form to appease the javascript function in input.php.
prehkeys: call refundscreens with frames after dept key to fix bug where "clear" key results in no input box.
refundAction, refundContactCheck, refundContactInfo, refundOtherInfo, refundReasonList,
refundReasonSelected,refundReceipt: clean up the javascript,
tweak the way j.s. handles the "CL[enter]" keystrokes of the programmable keyboard's clear key,
and make sure all pages have the proper dummy input form.
============================
1/27/08 apbw
8:20am above patch applied to all remaining lanes.
8:35am new refund feature added on lane 9 in refundReceipt.php: default to most recently entered refund receipt info, if available.
1:47pm lane 9 *only*:
various bug fixes & improvements to the refund module in these php files:
clientscripts, refundAction, refundContactCheck, refundContactInfo, refundContactUpdate,
refundOtherInfo, refundReasonList, refundReasonSelected, refundReceipt.
also replaced some single quotes with double quotes in session variable references,
so they're easier to search for, in mgrauthenticate, prehKeys, printLib, reprint, and variables.php.
and rearranged a couple things in memberCommentsPlus.php (earth was sluggish friday night and the page just wouldn't load).
{patch completed thursday 1/31/08, see below}.
=======================================
1/28/08 atf
today, the 28th of the 1st of the 8th, I discovered that (int)(1*100*8.28) == 827.
beware your floating point numbers in php!
fixed on ares storecardServer_mysql.php, and lanes storecard.php, storecardAuthorize.php
10:07am lanes xx,8,9
10:50am lanes 5,6,7,12
11:15am lanes 1,2,3,4,10
complete
1/29/08 atf
in the process of fixing the roundoff error, I goofed refunds! storecardAuthorize.php
9:07am lanes xx,8,9,12
10:38am lanes 3,5,6,7
12:15pm lanes 1,2,4,10
complete
======================================
1/31/08 apbw
11:05am latest refund patch (above, from sunday 1/27/08 at lane 9) applied to lanes 12, 10, 8, 7.
12:47pm ditto lanes 1,2,3,4,5, and 6.
patch complete.
=====================================
1/31/08 5:55pm apbw -- new sql tables & procs for archiving the local refund data, added proc to dayendreset. lane 9.
2/1/08 7:50am apbw -- ditto on lanes 1,2,3,4,5,6,7,8,10, & 12.
2/1/08 12:15pm apbw -- added to dbinit folder on mars.
* patch complete*
==========================================
2/1/08 apbw
prehKeys.php -- if magellan version (not browser only), call maindisplayDeframed for refundReceipt in deptKey function.
refundContactCheck.php -- set top frame location to input.php before displaying confirmation screen (in case we're
coming from a no-input page like memsearch).
8:53am lane 9.
12:13pm lanes 1,2,3,4,5,6,7,8,10,12.
*patch complete*.
******************************************************************************************************************
* input.php: added a new javascript function to check for existence of form1.input in the main frame.
* 2/1/08 12:14pm lanes 12 & 8. apbw
* 2/1/08 3:16pm lane 9. apbw
* 2/2/08 8am lane 7. abpw
* 2/3/08 9am lanes 5 & 6. apbw
* [completed 2/4/08 by atf, lanes 1-4+10 -- see note below.]
******************************************************************************************************************
2/1/08 apbw
3:51pm lane 9: refundAction.php -- changed from radio buttons to select list with tab navigation.
2/2/08 8am apbw
transferred to all remaining lanes (1,2,3,4,5,6,7,8,10,12).
*patch complete*
=================================================
2/1/08 3:30pm atf
quick fix for Organic Valley Blue Sky coupon that's scanning like a wedge card, due to ean 99 barcode prefix.
upcscanned, void, and pos2.php: lane 12
2/2/08 8am apbw
applied to all remaining lanes (1,2,3,4,5,6,7,8,9,10).
*patch complete*
================================================
2/2/08 apbw
oops; argh! had to add 3 fields that were inadvertently omitted from 'upload_refundinfo_today' proc.
also made small correction to 'refundcomments_remaining_today'.
10am lanes 12, 10, 9, 8, 7, 6.
10:20am lanes 5,4,3,2,1; and dbinit folder on mars.
*patch complete*.
=================================================
2/2/08 apbw
fixed the refundContactOverwrite bug -- in which, if you're coming from a screen with no input box, like memsearch.php, the top frame needs to be repointed to input.php.
also added provisions for standalone mode. files: clientscripts.php, refundcontactcheck.php, refundcontactconfirm.php, refundcontactdecision.php. plus a minor comment
change to refundReasonList.php.
11am lanes 12, 9, 8.
11:55am lanes 10,7,6,5,4,3,2,1.
*patch complete.*
=================================================
2/4/08 atf
input.php on remaining lanes, per amy's note
12:22pm lanes 1,2,3,4,10
complete
=================================================
2/7/08 apbw
11:22am refund module turned on at lanes 7 & 8, with authLevel = 1 (meaning fec auth. required for refunds)
==================================================
2/8/08 atf
allow 040 wedgecard prefix in addition to 990, so future printed cards work;
ALL wedgecards will now go into trans logs with upc 040... however, even if printed and
scanned with 990
pos2,prehkeys,storecardEntered,storecardAuthorize,void
8:10am lane xx
8:34am lane 8
8:38am lanes 9,10,12
8:45am lanes 1,2,3,4,5,6,7
complete
==================================================
2/10/08 8am apbw refunds turned on at lanes 5 & 6
2/11/08 9am apbw refunds turned on at lanes 1,2,3,4,10,12
*patch complete: refunds now on at all lanes, with auth req'd on all but CSC *
==================================================
2/11/08 apbw
upcscanned.php: hitareflag bug fix: if item wt <= tare wt, tare is set to 0 and an err msg is displayed, but no 0-tare line was being added to localtemptrans,
so the screen & receipt looked like the old tare was still being used. just added the line addtare(0) so that we have evidence of the new 0 tare.
10:44am lanes 9 & 12.
11:37am lanes 4,5,6,7,8,10.
12:10pm -- oops! reversed at all lanes & edited.
* reverse complete*
12:10pm fixed the patch and tried again. lane5.
12:15pm lanes 4,6,7,8,9,10,12.
12:45pm lanes 1-3.
*patch complete *
===================================================
2/12/08 atf
slightly clarified prompts when voiding (enter to continue _voiding_, clear to cancel _the void_)
paycardboxmsgvoid, storecardboxmsgvoid
9:17am lane 18!
10:07am lanes 8,9
11:10am lanes 5,6,7
11:47am lanes 1,2,3,4,10
complete
======================================================
2/12/08 apbw
allow EBT refunds: prehkeys.php (1 line changed); postrans.dbo.lttsubtotals (comment added); postrans.dbo.subtotals (edited the way fstaxexempt is calculated).
11:57am: lanes 9 and 18.
12:20pm: lanes 4,5,6,7,8,10.
12:48pm: lanes 1,2,3.
* patch complete *
========================================================
2/14/08 apbw
void.php: attempt to fix the bug in which the voidable amount is a float number with a large # of decimal places,
causing $voidable < $quantity to evaluate to true, which erroneously prevents cashiers from voiding the full amount of an weighed item.
TO DO: it's still possible to get more than 1 row in the query result in void.php line 270; need to develop criteria with which to loop through result set.
2:50pm lane 18.
3:01pm lane 9.
4:00pm lanes 5,6,7,8,10.
5:00pm lanes 1,2,3,4.
*patch complete *
================================================
2/15/08 apbw 5:45pm
refundReceipt.php -- fixed a little javascript bug in the form navigation
lane 9.
2/19/08 tak 2:00 pm
Patch above applied to lanes 16, 18 and 8
2/19/08 tak 3:50 pm
Patch above applied to lanes 1 and 7
2/20/08 tak 10:15 am
Patch ablve applied to all remaining lanes
==================================================
2/20/08 tak 11:15 am
lttsummary and lttsubtotals in sql changed to account for the behavior
of tax total when an item is taxable but non-discountable
Patch applied to lane18
2/21/08 tak 10:15 am
Patch above applied to lanes 16, 9, and 8.
2/21/08 tak 2:47 am
Patch above applied to lanes 1,2 and 7
2/22/08 tak 2:15 pm
Patch above applied to all remaining lanes
2/22/08 tak 2:30 pm
Linux reconciliation patch applied to lanes 18, 16, 9, and 8
2/22/08 tak 3:00 pm
Patch above applied to lanes 7 and 2
2/22/08 tak 3:30 pm
Patch above applied to all remaining lanes
=========================
2/23/08 apbw -- fix charge slip bug (printer pauses mid-stream) - printReceipt.php.
7:50am CSC.
11:52am juice bar & deli.
5:14pm lanes 1,5,6,7,8.
5:47pm lanes 2,3,4.
* patch complete *.
========================
2/24/08 apbw -- improved the javascript function in input.php; and
patched refundReceipt.php to improve behavior when frame/form loses focus.
7:42am deli, CSC, lane 8, lane 1.
10:16am lane 2,6,7,jb.
11am lanes 3,4,5.
*patch complete*
=======================
2/24/08 jdp -- set store limit of $1000 for an open ring (patched pos2.php)
10:00am deli, csc
11:30am lanes 01-09
*patch complete*
========================
2/29/08 tak 11:25 am
patch limiting quantity to 999999 applied to lanes 18, 16, 9 and 8
2/29/08 tak 11:50 am
Patch above applied to lane 5
2/29/08 tak 12:22 pm
Patch above applied to all remaining lanes
====================
2/29/08 apbw: tax exempt order patch.
patch sql views to accurately reflect tax exempt status of each transaction when printing receipts & calculating amount due.
12:31pm linux lane: lttsummary, lttsubtotals (mysql only), subtotals.
2:22pm deli: lttsummary & subtotals.
2:47pm CSC and lane 8.
3:37pm lanes 5,6,7 and juice bar.
4:08pm lanes 1,2,3,4.
*patch complete*.
===================
2/29/08 tak 5:27 pm
Linux code reconciliation. Changed the value of $_SESSION["mDatabase"] to
the constant "is4c_op" in the function uploadtable() in connect.php
Patch applied to lanes 18, 16, 9, 8
2/29/08 tak 5:45 pm
Patch above applied to lanes 2 and 5
2/29/08 tak 6:00 pm
Patch above applied to all remaining lanes
==========================
3/1/08 apbw
8am cashier name refund patch: add cashier name field to refundHeaders
4 php files, 9 sql changes on lanes, 7 sql changes on mars.
- mars sql done.
- lanes mssql done.
- lanes php done.
- tested on all lanes & informed csc, jb, & fec.
- linux lane: php & mysql done.
*patch complete*
========================
3/1/08 apbw
lengthen new cashier field to 100 characters (instead of 25) in refundHeaders and refundHeadersArchive tables
12:40pm mars
12:45pm CSC, deli, juice bar.
lane 8, 7, 6, 5, 4, 3, 2, 1.
linux lane
=====================
3/1/08 apbw
truncate strings to max. field length before inserting into sql tables: lib.php, refundContactUpdate.php, refundReasonSelected.php.
fix j.s. tab navigation in refundContactInfo.php.
2:50pm CSC, deli, linux.
3:10pm lane 8.
3:51pm lanes 6, 7, juice bar.
4:05pm lanes 4 & 5.
4:43pm lanes 1-3.
* patch complete *
=======================
3/2/08 apbw
fix the way scannable mfr coupons are shown on the live receipt and figured into both the receipt total and the rplist trans total.
8:30am mssql all windows lanes: lttSummary (item total changed), ltt_receipt_reorder_g (add trans_subtype to view), receipt_reorder_g (change display of scannable mfr coupons).
8:40am php all lanes (incl. linux): rplist.php.
11am mysql on linux lane.
* patch complete*
========================
3/2/08 apbw
fix the bug where voiding by upc sometimes only voids the mem special discount amount. void.php.
1:38pm linux, deli, CSC, and lane 8.
3/4/08 Tak 12:00 noon
Patch above applied to lanes 16, 7, and 2
3/4/08 tak 1:00 pm
Patch above applied to all remaining lanes
========================
3/6/08 tak 1:00 pm
Intern patch applied to Earth and lanes 18 and 9
3/6/08 tak 3:15 pm
Patch above applied to lanes 16, 8, and 7
3/6/08 tak 5:00 pm
Patch above applied to all remaining lanes
==========================
3/7/08 tak 10:37 am
function to load staffid and member number based on cashier number into session variables
when cashier logs in.
Patch applied to lanes 18, 9
3/7/08 tak 11:34 am
Patch above applied to lanes 16, 8, and 7
3/7/08 tak 12:50 pm
Patch above applied to all remaining lanes
==========================
3/7/08 tak 2:21 pm
Emp_no/StaffID/member patch applied to lanes 18, 9
3/7/08 tak 4:15 pm
patch applied to lanes 16, 8, 7
3/7/08 tak 5:25 pm
Patch applied to all remaining lanes
==========================
3/7/0/08 tak 6:50 pm
Panic City!! Last patch reversed. Last but one patch remains.
===========================
3/8/08 apbw 10am
green patch patch: green patch redemptions are currently stamped as tenders & instore coupons
for polling purposes. but now they need to be treated a reduction to PG sales, i.e., like any other PG item.
postrans proc clearTempTables -- exclude plu 1014 -- all lanes.
end.php -- exclude plu 1014 from moveTempData mysql function -- all lanes.
mars: wedgepos -- getdaybalancing proc & dLog view, couponUsage, etc.
wedgedb -- midday trans view
repoll -- repollDayBalancing proc, repollDLogFromTransArchive proc, TillTrans view, rLogXed view etc.
updated wedgepos dtransactions trans type & subtype fields for all green patches today.
updated transarchive for friday 3/7 (238 rows, orig table backed up to io).
repolled for fri 3/7.
rosalind: updated dtransactions & transarchive tables.
========================================
3/8/08 Tak 1:43 pm
session.php, with two added session variables and
loadconfig.php with a wrapper to check that an employee's member number, where applicable, is numeric
Applied to all lanes
========================================
3/8/08 Tak 1:50 pm
CardNo not in (StaffID, member) patch applied to lane 18
3/8/08 Tak 4:20 pm
Patch above applied to lane 9
3/9/08 apbw 8:20am applied to all remaining lanes incl. linux.
*patch complete*
==========================================
3/9/08 apbw
another green patch patch: remove references to PLU 1014 from receipt_reorder_g and rp_receipt_reorder_g.
8:37am lanes 1, CSC, deli.
10:02am lanes 2,3,4,5,6,7,8,JB.
10:30am linux lane.
===========================================
3/9/08 apbw
another green patch patch: remove references to PLU 1014 from lttSummary & localtranstodaySummary
2:48pm Deli, CSC, lane 8.
3pm juice bar, lanes 6 & 7.
3:25 lanes 1,2,3, 4 & 5.
3:30 linux lane
* patch complete *
==============================================
3/11/08 11:58 am tak
mysql complicance patch applied to lanes 18, 9, 8
3/11/08 1:07 am tak
patch above applied to lane 2
3/11/08 2:03 am Tak
patch above applied to all remaining lanes.
============================================
3/13/08 10:32am apbw
CSC, Deli, Juice Bar: upload_refundinfo_today -- move from postrans to posbdat.
lanes 8, 7, 6 5,4,3,2,1
populated cashier field in refundHeaders table on mars with data from from lane tables
* patch complete *
----------------------------------------------
3/14/08 apbw upcscanned.php: changed the place where refund session variables are reset & unset.
9:10am deli & CSC.
10am oops -- panic city at Csc -- can't refund classes.
12pm: again with deli & CSC.
1:08pm: lanes 6,7,8, linux.
1:32pm: juice bar, 5 & 4.
2:20pm: lanes 1,2, & 3.
*patch complete *
==============================================
3/14/08 apbw upcscanned.php: bypass form endorsement screens for classes/giftcert/stock refunds.
3pm: deli, csc, linux.
4:38: lanes 5,6,7,8, & juice bar.
5:27pm lanes 1,2,3,4.
* patch complete*
------------------------------------
3/16/08 apbw refund module upgrade: add a screen to enter item description for open ring refunds.
7am sql on mars (add new refundComments.description field to 7 objects)
7:05am sql on all lanes (add new refundComments.description field to 9 objects)
7:10am php on CSC and Lane 1. (2 new files and 6 changes).
9:15am php on linux lane.
11:37am mysql on linux lane.
to do: apply php to remaining lanes monday (anytime except mid-transaction -- doesn't have to be before store opens).
if you have to do panic city: just copy the old php files back over to the lanes;
you shouldn't need to revert any of the sql objects. but if you *have* to revert
the sql objects:
1. first do the php files in panicCity.
2. then run the script for mars in panic_cityOld\refundDescription\marssql.
3. then run the script for the lanes in panic_cityOld\refundDescription\lanessql.
------------------------------------
3/20/08 Tak 1:30 am
Patch above applied to all remaining lanes
===================================================
3/21/08 apbw
refund bug fix: refundDPDetailsForm.php, refundOtherInfo.php, and additem.php.
(to fix the bug where sometimes screen just goes blank or flashes during progression through the various refund screens).
12:03pm deli.
1pm csc, jb, linux, & lane 8.
4:22pm lanes 1-7.
* patch complete *
================================
3/23/08 apbw refund bug fix: ironing out a few wrinkles in the refund module.
8am deli & CSC; test.
10am: further updates to CSC & deli, linux & juice bar.
10:20am: lanes 6,7,8.
2:40pm: lanes 3,4,5.
2:45pm: lanes 1 & 2.
* patch complete *.
================================
3/23/08 jdp refund bug fix: hardcoded lane numbers in refundOtherInfo.php not up to date
6PM: applied to 18,16,9,8,7,6,5,4,3,2,1,15
3/25/08 atf
replaced tender report 'change' column with 'system' to indicate integrated/standalone
fixed javascript error with any single quote in the input field (O'Briens credit card..!)
stripslashes() on input text for pos2 and memlist, can now search for member "o'brien" too
tenderReport.php, input.php, pos2.php, memlist.php
10:30am lanes 18,9
3/26/08 atf
continuing above
9:20am lanes 6,7,8
11:20am lanes 2,3,5
5pm lanes 1,4,16
complete
==================
4/6/08 apbw
refundReceipt.php -- suppress auto-tab javascript function if form is pre-filled, 'cuz it's buggy.
10am CSC.
4/10/08 apbw
apply refundReceipt.php patch to remaining lanes: 1,2,3,4,5,6,7,8,16,18.
patch complete.
4/11/08 apbw
oops -- page is still calling the nonexistent js function!
8:25am panic city on all lanes.
8:50am redo, lane 9.
10:55am even better version, lane 9.
11:30am lanes 18, 16, 8, 7.
4/12/08 apbw
applied to remaining lanes: 1,2,3,4,5,6.
*patch complete*
**************************************************************************************************************************
4/11/08 apbw: input.php -- rollback the javascript function for inputSubmit.
could be causing "lost" PLU's (nothing happens when cashier enters a plu).
things to watch for: any more lost PLU's at lane 3? do refund screens still work properly? do javascript errors come back?
(better to deal with javascript errors than to lose PLU's).
4/11/08 11:11am lane 3.
4/12/08 9:30am lane 4.
4/16/08 7:15am lane 1.
4/16/08 7:15am lane 2.
4/18/08 7:43am lanes 5 - 18.
*patch complete*
**************************************************************************************************************************
4/13/08 apbw local purchases patch:
- add new field "localEligible" to lttsummary, localtranstodaysummary, subtotals, & rp_subtotals; and changed formula for localTotal field.
- use localEligible instead of itemtotal as the basis for calculating percent of local purchases on receipt in: connect.php, reprint.php, printLib.php.
- insert juice club cards with numflag of 1 in clubcard.php.
8:45am lanes 9; 1, 2, 3, 4; 18, 16; 5, 6, 7, 8.
* patch complete *
(if you need to panic: roll back the php files first and see what happens; then do "lastResort" files if needed; you may not need to roll back the sql at all.)
---------------------------------
4/27/08 apbw lost PLU debugging:
addItem & upcscanned -- added logging in a couple places where we could be losing PLU's.
3pm lanes 18, 9, and 3,2,4.
5/10/08 7:45am apbw rolled back from above lanes.
*complete*
-----------------------------
4/28/08 atf : session debug logging : phase 1
added $_SESSION["debugHistorySize"]=0 to ini/ini.php
10am lanes 8,9,18
11:30am lanes 5,6,7
12:15pm lanes 1,2,3,4,16
complete
4/28/08 atf : session debug logging : phase 2
added debugHistory tracking and "DEBUG" command in pos2
2:50pm lanes 8,9,18
4/29/08
9:05am lanes 3,5,6,7
10:10am lanes 1,2,4,16
complete
-----------------------------
4/30/08 jdp : "TD" Code. Allows cashier to see the current discountable total
pos2.php
12:30 lanes 6,7
14:45 lanes 18,16,9,8
16:00 lanes 1,2,3,4,5
----------------------------------------
5/1/08 atf : session debug logging : phase 3
setting debugHistorySize to 3 on a few lanes, to see if it slows them down or anything
9:05am lanes 2,9
11:20am lanes 3,5
12:45pm lanes 1,4,6
1:35pm lanes 7,8,16,18
complete
----------------------------------------
5/2/08 atf : session debug logging patch
some cashiers used 'debug' at the end of the transaction instead of immediately after the bug;
clarifying the message to suggest they do it sooner, and adding checks to avoid capturing
credit card information in the debug log when used right after a cc payment
10:15am lanes 8,9,18
11:30am lanes 5,6,7
12:15am lanes 1,2,3
5pm lanes 4,16
complete
----------------------------------------
5/6/08 atf : "ID" cleanup
allow "<name>id" to go straight to the matching list without having to enter search name
again; better ' escaping and unescaping using get_magic_quotes_gpc() in pos2, input, memlist
9:20am lanes 8,9,18
11:40am lanes 4,5,6,7
12:20pm lanes 1,2,3,16
complete
----------------------------------------
5/9/08 Tak 5:10 pm
10 percent discount patch applied to lane8, lane18, lane16, lane9
5/10/08 abpw 7:45am all remaining lanes (1,2,3,4,5,6,7)
complete
----------------------------------------
5/29/08 3pm
lane phones and labels renumbered, order reversed (i.e. 8 is by FEO, 1 by door, 5 is express)
but computers still have original numbering!
----------------------------------------
5/30/08 8am
lane computers swapped (8&1, 7&2, etc); numbering now agrees with phones and labels
-------------------------------------
6/11/08 10 am Tak
Automatic multiplication by quantity of scanned items reversed
Applied to lanes 7, 8, 9, 16, 18
6-14-08 7:45am apbw applied to lanes 1,2,3,4,5,6.
*complete*
==========================
6/12/08 atf : live card nocancel
the "can't-cancel-after-live-credit/gift/wedge-card" check stopped working
when WC barcodes changed from 990 to 040; fixed by updating postrans.dbo.lttSummary
3pm lane 9
==========================
6/15/08 apbw:
allow charge account balance inquiry and staff charge receipt suppression for subs as well as regular staff ($_SESSION['isStaff'] = 3).
also give an error message instead of an empty frame if BQ can't check account balance (ie for non-staff, etc)
pos2.php & printReceipt.php
1:43pm lanes 18, 16, 9.
2:43pm lanes 1,2,3.
7:19am 6/17/06 lanes 4,5,6,7, and 8.
* patch complete *
-----------------------------------------------
6/17/08 atf : live card nocancel continued
11:15am lanes 6,7,8,16
11:45am lanes 1,2,3,5
12:15am lanes 4,18
complete
6/20/08 atf : pccharge eradication!
eliminate all traces of the old pccharge code: ini.php,additem,clock,configure,connect,end,input,
loadconfig,noinput,paycardEntered,pos2,prehkeys,printLib,printReceipt,sessFunction,session,void
8:50am lane 9
6/24/08 atf : pccharge eradication continued
8:53am lanes 5,6,7,8
9:10am lane 18
6/25/08 atf : pccharge eradication continued again
8:31am lanes 1,2,3,4,16
complete
6/27/08 atf : "RU" auto-subtotal
pos2.php
8:05am lanes 9,18
1:45pm lanes 6,7,8
3:05pm lanes 1,2,3,4,5,16
complete
6/30/08 atf : "RU" patch, only subtotal if item was added
pos2.php
9:30am lanes 9,18
10:45am lanes 6,7,8
12:45pm lanes 1,2,3,5
2:30pm lanes 4,16
complete
7/11/08 atf : HSA card decline patch
efsnet.php
2pm lanes 7,8,9,18
4:50pm lanes 1,2,3,4,5,6,16
complete
8/03/08 jdp : Changing a string compare to a numerical compare
upcscanned.php
8:00am lanes 1,2,3,4,5,6,7,8,9,16,18
8/4/08 atf : scan for and suppress bad EFSnet responses containing sensitive card data
efsnet.php
10:15am lanes 7,8,9,18
2:10pm lanes 1,2,3,4
4:50pm lanes 5,6,16
complete
=================================
8/27/08 apbw 8am: debugging for multiple entries -- lanes 1 & 6 only:
1. sql insert query trace running for the day (hosted on amy's VM; writing to mars g sqlTraceFiles)
2. upcscanned.php -- comment out goodBeep fn call, since it's overridden by additem's calling that function.
3. addItem.php -- write to log file each time insert query is run.
(also cleared out all apache logs and is4c logs on lanes 1-9).
10:50am added upc, trans# & emp# to log file entry.
8/28/08 apbw 12:30pm: turned debug logging off -- restored original addItem.php on lanes 1 & 6. sql traces saved to files on mars for further investigation.
===================
9/3/08 atf : valutec gift cards stopped working around 4pm today, needed new ca-bundle.crt file
5:05pm lanes 7,8,9,18
5:15pm lanes 5,6,16
5:40pm lanes 1,2,3,4
complete
9/5/08 atf : valutec still having intermittent certificate problems; disabled
cert verification by cURL in valutec.php :(
8:50am lanes 8,9,18
10:40am lanes 5,6,7
11:40am lanes 1,2,3
12:40pm lanes 4,16
complete
=========================
9/17/08 apbw: Mfr Coupon patch phase 1
- added new field activeMfrCoupons to lttSummary & subtotals views
- created a new session variable "activeMfrCoupons" in is4c
- is4c now looks for activeMfrCoupons (as well as activeTenders) before allowing a trans to be suspended or canceled.
- fixed a couple of bugs in the voiding of mfr coupons
10:20am lane 18 deli -- sql views.
10:40am lane 18 deli -- admintasks.php, connect.php, pos2.php, sessFunction.php, session.php, void.php
3:20pm lane 9 csc -- first sql views then php files.
9/18/08 7:15am apbw: everything applied to remaining windows lanes; sql scripts updated in dbinit.
3:30pm linux lane patched.
* complete *
======================
9/19/08 Tak 10:00 am
coffee patch first stage applied to lanes 8, 9, 16, 18
12:35 first stage session.php, additems.php applied to all remaining lanes.
4:30 pm
pos2.php, upcscanned.php altered and applied to all lanes.
9/22/08 Tak 2:30 am
SQL data altered to reflect new coffee discount. Applied to all lanes
complete
========================
9/23/08 Tak 11:00 am
Patch to remove coffee discount void bug applied
to all lanes
SQL data altered
complete
=========================
9/24/08 apbw -- fix bug in printLib.php -- define $conn variable in line 433 & provide for sql query/connection failure.
8:43am deli, JB, and CSC.
10:20am all remaining lanes, 1-8 plus linux lane #15.
complete
========================
9/24/08 apbw -- apply tak's staff coffee voiding patch -- void.php
10:25am deli.
11:38 Juice Bar & CSC.
3:30 lanes 1-8 + linux lane 15.
complete
==================================
9/25/08 apbw -- 2nd part of staff coffee voiding patch -- void.php
-- check for item void status before voiding a staff coffee
-- get correct memspecial / staff special price on voided staff coffees & voided memspecial refunds
9/25 12:40pm deli chargebook & tested.
9/25 12:50pm juice bar & tested.
9/25 3pm-ish CSC.
9/28 8:20am all remaining lanes.
complete.
=====================================
9/29/08 apbw: void.php:
fix the new bug i created that results in leftover unvoidable money if you change from staff to non-staff while voiding staff coffee by id.
(you have to grab the adjusted unitPrice from localtemptrans, because the staff coffee's special adjusted price isn't in the product table).
8:12am lanes 18 (deli), 16 (jb), 15 (linux), 9 (csc).
9:20am re-patch lanes 18,16,15, & 9 -- i had some logic errors in my if/elseif/then/else statements.
10:50am re-patch lanes 18,16,15, & 9 -- ironing out some repetitive clauses / conditions in those same statements.
3:26pm applied to lanes 5-8.
4:40pm lanes 1-4.
complete
=============================
9/29/08 apbw 5pm: pos2.php -- stumbled across a bug where VD50JC causes pos2 to do absolutely nothing.
lanes 18, 16, 15, 9.
10/1/08 jdp 8am: pos2.php -- finishing push to lanes
lanes 1,2,3,4,5,6,7,8
complete.
=========================
10/8/08 8:30 am Tak
new fields added to the various transaction log tables on lanes 18 and 8
10/9/08 8:30 am Tak
new fields added to lanes 1, 2, and 3
10/13/08 8:30 am Tak
new fields added to lanes 4, 5, 6 and 7
10/14/08 8:30 am Tak
new fields added to lanes 16
10/15/08 8:30 am Tak
new fields added to lanes 9
=========================
10/13/08 apbw
7:50am update postrans.dbo.memChargeTotals view -- the old version didn't exclude training shifts or
suspended/canceled transactions from staff charge balances. all lanes.
complete.
=========================
10/15/08 9:30am -- new staff coffee PLUs activated and juice bar "em" key disabled.
=========================
10/15/08 void.php -- updated handling of staff coffee; goes back to voiding by upc instead of id,
since they now have their own PLUs and no longer need special handling.
9:30am -- lanes 18 & 16.
10:42am -- lanes 15, 9, 8.
1:47pm -- lanes 5,6,7.
3pm: PANIC CITY. JB can't void stuff.
3:50pm: patch applied to all lanes; juice bar only had trouble voiding b/c they were testing the old "em" key versus the new toggle keys.
*complete*
========================
To Do: remove "em" code from is4c down the road; no hurry.
=========================
10/16/08 apbw -- void.php, upcscanned.php, and productlist.php.
- new parseupc() function is called from all 3 files so that we always parse upc's the same way everywhere.
- when voiding scale items by upc, reconstruct the original scale label barcode with builtin price.
- in voiditem(), check if the upc has multiple discounttypes; if it does, call voidid() instead of voidupc().
this may eliminate the problem of multiple rows returned in the voidupc queries.
- if multiple rows are returned in the voidupc queries, log the queries for debugging.
note: go slow with this one -- let it run awhile at deli & CSC before applying everywhere.
9:20am lane 18.
11:30am lane 9
2:50pm lanes 8, 15, 16.
10/19/08 8:20am lanes 1-7.
*complete*
===================================
10/19/08 apbw: "MB enter" -- check for connectivity to earth & mars in pos2.php before going to memberCommentPlus.
also made minor changes to the sequence of events in memberCommentPlus & set_time_limit to 15seconds.
(so they don't get stuck at a blank screen during a 30 second sql connection attempt).
12:30pm lane 9.
1:30pm lanes 18,16,15.
10/20/08 8:25am lanes 1-7.
*complete*
================================
10/21/08 9:20 am Tak
additem patch applied to lane 18
10/21/08 10:20 am Tak
additem patch applied to lanes 8, 9
10/21/08 11:15 am Tak
additem patch applied to lanes 16, 1
10/21/08 2:15 pm Tak
additem patch applied to all remaining lanes
================================
10/23/08 apbw: pos2.php -- limit tare weights to .005 and above.
10:56am lanes 18 & 9.
1:30 lanes 16, 8, 7.
3:20 lanes 4,5,6.
10/24/08 atf: continuing amy's pos2 patch
12:50pm lanes 1,2,3
complete
================================
10/24/08 2:20 pm Tak
New fields added to sql views. Applied to lane 18, 9.
10/24/08 3:20 pm Tak
Applied to lane 16, 1.
10/24/08 4:10 pm Tak
Applied to lane 8, 2
10/24/08 4:10 pm Tak
Applied to all remaining lanes
complete
==================================
10/27/08 apbw: void.php -- comment out the debug logging for 2nd query.
11am lanes 18, 16, 9.
12:30pm lanes 6,7,8.
10/29 8:15am lanes 1-5.
complete
====================================
10/31/08 atf: halloween-ized the rooster on login and lock screens per barth's idea
login2, login3, invalid, invalid3
9:30am lanes 18,16,9,8,7,6,5,4,3,2,1
complete
10/31/08 atf: converted holiday rooster to an automatic date check (halloween on 10/31)
to which we can add other annual tweaks too
login2, login3, invalid, invalid3
1:20pm lanes 8,9,16,18
2:20pm lanes 1,2,3,4,5,6,7
complete
===================================
11/7/08 tak 10:20 am
New fields not added to staffdiscount views (add and remove), finally applied
applied to lanes 18, 16, 9, 1, 2, 7, 8
1:30 pm
applied to all remaining lanes
complete
===================================
11/7/08 Tak 2:00 pm
new fields referenced in connnect.php and prehkeys.php
applied to lanes 18, 16, 9
5:40 pm
applied to lanes 1, 2, 3, 8
7:00 pm
applied to all remaining lanes
complete
====================================
11/19/08 apbw 4:40pm. void.php.
tweaked the way we check to see if it's okay to void an item after a tender has been accepted.
if tender has been accepted, we don't allow an item to be voided if:
- the item is foodstampable and its value is greater than the net fsEligible on the transaction; or
- the item's value is greater than the amount due on the transaction.
3 changes:
- adjusted the comparison values to exclude the estimated transdiscount
- created a function to check the "paidfor" status.
- called the function before voiding mix&match items, in addition to the other 2 places we usually check.
got the okay from cerise, john, and brooks to apply the patch.
4:51pm - deli chargebook.
11/20/08:
8am - CSC and lane 5.
9:18am -- refined the 'paidfor' checking on mixmatch/volspecial items & re-applied to lanes 5,9, and 18.
1:37pm lanes 4, 6, 7, & 8.
2:40pm lanes 1,2,3, & 16.
*patch complete*
===============
12/1/08 apbw: refundContactCheck.php -- found & corrected an undefined variable.
10:33am lane 18.
11:42am lane 9.
12:58pm lanes 1,2,3,4, & 16.
2:58pm lanes 5,6,7,8.
*complete*
===================
12/3/08 tak 10:45 am -- sticky scale patch
10:45 lane 18
11:10 lane 9
12/4/08
10:10 lane 16
12:52 lane 1, 2
1:10 lane 3, 4
1:30 lane 5
2:36 lane 6, 7, 8
Complete
======================
Immediately afterwards -- patching the previous patch to take into account voiding
3:20 Applied to lanes 18, 16, 9
3:30 Applied to all remaining lanes
Complete
*note that panic city reverts the patch to the point before application of the
original sticky scale patch.
======================
12/5/08 tak 7:00 pm
Panic city.
sticky scale patch reverted due to issues with tare weight.
sticky scale patch, with fix, to be re-applied on Monday
======================
12/8/08 apbw void.php:
when voiding a refund of an item on member special,
the memdiscount value taken from the products table should be multiplied by -1,
so as to reverse or cancel out the memdiscount on the refund.
until now it has been duplicating
the memdiscount from the refund, which gives the customer too little money back
(but only if the member # is
changed mid-way through the transaction -- which is why no one noticed until now!)
3:40pm lanes 18 & 9, and tested.
3:55pm: lanes 16, 1,2,3.
4:15pm lanes 4 & 5.
4:45pm lanes 6,7,8.
*patch complete*
============================
12/10/08 Tak
Added another session variable to session.php in preparation for sticky scale patch redux
12:45 pm lanes 18, 16, 9, 8
1:30 pm All remaining lanes
complete
============================
12/10/08 Tak
sticky scale patch redux
2:00 pm lanes 18, 16, 9
5:17 pm lane 1
12/11/08
9:20 am lanes 2, 3, 4
10:00 am all remaining lanes
Complete
============================
12/11/08 1:05pm apbw. the refund module upgrade (single page, no frames) applied to CSC.
new files:
refundForm.php
refundFormVerify.php
refundFunctions.php
refundScripts.js
changed files:
additem.php
pos2.php
prehkeys.php
upcscanned.php
refundContactCheck.php
refundContactConfirm.php
refundContactInfo.php
refundContactUpdate.php
12/14/08 9am apbw: patch refundForm, refundFormVerify, and refundFunctions to fix a little buggy @ lane 9.
12/14/08 6pm: lengthen the comments field on refundContactInfo, and don't select the cashier name field on focus -- lane 9.
12/15/08 4:52pm -- lane 9 only. improve form navigation, appearance, & form rejection on refundContactInfo,refundContactUpdate, refundForm, refundFormVerify, refundFunctions.
12/17/08 8:30am apbw: refund module applied to lanes 18 & 16 & 8 (and shown to FEC's and jb staff).
12/18/08 9am apbw: ditto to all remaining lanes.
*refund module upgrade patch complete*
=========================================
12/21/08 apbw revised some receipt views for better handling of mfr coupons (esp. dept coupons):
8 views, all combined into one script. (ditto for panic city).
3 views for orig receipts: lttsummary, receipt_reorder_g, receipt_reorder_unions_g
5 views for reprints: localtranstodaysummary, rp_ltt_receipt, rp_receipt, rp_receipt_reorder_g, rp_receipt_reorder_unions_g
10am lanes 18, 16, and 9.
12/22 8am: all other lanes.
*complete*
=======================================
1/6/09 atf added payment processor selection ("ccPlatform" and "gcPlatform") to ini files,
to facilitate switching later; also added gift card partial-sale flag ("gcAllowPartial")
ini/ini.php
10:15am lanes 8,9,18
1/7/09 continued
11:30am lanes 5,6,7
11:45am lanes 1,2,3,4,16
complete
=======================================
1/7/09 added sql job "startupSync" to run posbdat.cacheData when SQLServer starts
1:55pm lanes 8,9,18
1/9/09 continued
9am lanes 5,6,7
9:20am lanes 1,2,3,4,16
complete
=======================================
2/1/09 apbw. refundForm.php, refundFormVerify.php, and refundFunctions.php.
improved date verification (to reject dates before 1/1/1970 and future dates);improved handling of empty strings; and improved retention/refreshing of saved form data when looking up saved refunds.
4:19pm lane 9
2/3/09 8:30am lanes 18,16,and 1.
2/3/09 11:30am lanes 2-8.
*patch complete.*
=======================================
2/4/09 apbw.
new foodstampDiscountable field in lttsummary/localtranstodaysummary;
used to calculate fsEligible in lttsubtotals/localtranstodaysubtotals when a discount has been applied.
note: there's a script for all 4 views in both transfer and panicCity.
8:50am lanes 8 and 9.
9:30am lane 18.
2:05pm lanes 1,2,and 3.
2:11pm lane 16.
2/5/09 8am: lanes 4,5,6,7.
*patch complete.*
=======================================
2/4/09 apbw
prehkeys.php: exclude bottle deposits and refunds from dept total when deciding whether to accept a manually
entered dept coupon.
2:13pm lane 18.
3:15pm lanes 9 & 16.
3:20pm lanes 1 & 2.
2/5/09 8am: lanes 3,4,5,6,7,8.
*patch complete.*
=======================================
2/5/09 apbw: remove 8 obsolete refund module files from the lanes:
refundAction,refundContactDecision,refundDPDetails,refundDPDetailsForm,
refundOtherInfo,refundReasonList,refundReasonSelected,refundReceipt.
8:30am lanes 18,16,9.
11:00am lanes 1-8.
* complete.*
=======================================
2/25/09 atf: upgrade lanes to php 5.2, apache 2.2
8am lane 8, attempt 2 (with PHP as CGI instead of SAPI module)
2/26/09 atf: php5 compatibility patch
removed "datetimestamp" session variable, references now just use date()
removed "browserOnly" session variable, bye.html now also does window.close()
some "if(functionexists(...)) include(...)" changed to "require_once(...)"
testremote() rolled into uploadtoServer()
pinghost() retired in favor of sql_ping()
exec(del) and exec(rm) changed to unlink()
8:50am lane 8 (PHP changed back to SAPI module from CGI)
8:50am lanes 9,18
2/27/09 continues
8:30am lanes 1,2,3
4:00pm lanes 4,5,6,7,16
complete
===========================================
3/3/09 atf: upgrade lanes to php 5.2 module, apache 2.2 (continued)
8:00am lanes 6,7
3/4/09
8:15am lane 18
3/5/09
8:00am lanes 1,2
3/6/09
8:30am lane 3
===========================================
3/7/09 more date validation added to refundFormVerify.php. -- apbw.
8:44am all lanes.
* complete *
===========================================
3/7/09 apbw. pos2.php line 200 -- changed from this:
if ( $entered == "RF1TN") $entered = "stop";
to this :
if( substr($entered,0,5) == "RF1TN") $entered = "stop";
so that we reject RF1TN (refund key followed by tax shift key)
regardless of what follows.
(e.g. for taxable open rings rung as RF1TNamtDP10),
11:45am lane 9.
noon: lanes 18, 16, 1, and 2.
3/10/09 lanes 3-8.
*complete*
===========================================
3/9/09 atf: php 5.2 module, apache 2.2 (continued)
8:00am lanes 4,5 (only 9,16 remain)
3/9/09 atf: ini/ini.php update
removed browserOnly, no longer needed; added section for paymenthandler switchover; added explanations for some settings
9:40am lane 18
10:50am lane 9
12:05pm lane 8
1:15pm lanes 1,2
2:25pm lanes 3,4,5
3:05pm lanes 6,7,16
complete
3/9/09 atf: Apache/httpd.conf
changed access logging to ignore requests from localhost, so the log files don't get out of control so fast
4:30pm lanes 1,2,3,4,5,6,7,8,18 (all with apache 2.2)
apache must be restarted for the change to take effect; will do so tomorrow morning
3/10/09 atf: php 5.2 module, apache 2.2 (continued), + httpd.conf
8:15am lanes 9,16
complete!
3/11/09 atf: added sql tables and updated views and procedures
config procs: becomeDeadLane, becomeLiveLane
postrans views: localtranstodaySummary, lttSummary, rp_receipt_header
postrans tables: mercuryRequest, mercuryResponse, mercuryResponseFull
8:10am lane 18
10:30am lane 9
3/12/09 continued
8:15am lanes 8,7
2:00pm lanes 1,2
4:30pm lanes 3,4,5,6,16
complete
3/16/09 atf: existing-file hooks for new (but dormant) payment handler code
authenticate, clock, connect, input, is4c.css, login, login2, noinput, pos2,
prehkeys, printLib, printReceipt, reprint, session, tenderReport,
topBorder, upcscanned, void
8:30am lane 18
3/17/09 atf: new files for new (but dormant) payment handler code
MercuryHandler.class, pay_boxMsg_amount, pay_boxMsg_auth, pay_boxMsg_card,
pay_boxMsg_confirm, pay_boxMsg_result, pay_send, PaymentHandler.class,
StorecardHandler.class, ValuTecHandler.class, xml
8:00am lanes 9,18
existing-files continued
12pm lanes 1,2
new-files continued
8am lanes 1,2
all files!
2pm lanes 3,4,5
3pm lanes 6,7,8,16
complete
3/19/09 atf: one line bugfix in connect.php to replace deprecated connection_timeout()
8:15am all lanes
complete
3/19/09 atf: changed work phone into cell phone in membercommentplus per ann/marcos request
10:30am lane 9
11:45am lanes 1,2,16,18
12:30pm lanes 3,4,5
12:45pm lanes 6,7,8
complete
3/23/09 atf: rounding error bugfix in PaymentHandler
9:30am lane 8
9:45am all lanes
complete
3/25/09 atf: tweak in PaymentHandler to stop caching and re-using the same database connection (lane 8 lost it somehow once)
8:30am all lanes
complete
3/26/09 atf: added session variable "paymentReprintPV" to reprint slips with PV instead of RP (jb only has RP key, others only have PV)
ini/ini.php
10am all lanes
complete
3/30/09 atf: lost card requests (requiring a carbon) now show 'LOST' on the
transaction tender line, to remind the cashier not to run it again; payment
handler key prompts (yellow boxes) now mouse-clickable; Mercury now retries on
the alternate server if the primary doesn't connect within 4 sec; the juice bar
will reprint slips with RP instead of PV
MercuryHandler, PaymentHandler, pay_boxMsg_(amount,auth,card,confirm,result), prehkeys
12:25pm lane 18
2:00pm lane 8
3:00pm lane 7
3:50pm lanes 5,6
4/1/09 continued
8am lanes 1,2,3,4,9,16
complete
4/1/09 atf: improved Mercury backup server usage
8am: all lanes
complete
4/3/09 atf: re-activated and tweaked bus pass tender reports (only for CSC and training cashiers)
tenderReport
9:20am lane 1
2:30pm lanes 2,3,4,5
4:30pm lanes 6,7,8,16,18
leaving lane 9 (the only one actually affected) unpatched til monday
4/6/09 continued
10am lane 9
complete
4/6/09 apbw: bug fix in refundFormVerify.php:
(reset session["refund"] during a refund review ("RR"),
to prevent subsequent transaction lines being added with trans status of R.)
this should prevent future out-of-balance transactions like the 2 @ csc on sunday 4/5/09.
9:15am: all lanes, complete.
4/6/09 atf: disabled unexpected-shutdown checking (lane 6 problem resolved?);
added msgrepeat=0 in pay_boxMsg_result for check-franking bug; added session
refund and payment failsafe checking at the top of pos2; reformatted tender()
and upcscanned() to be easier to read; removed extra digits in datetime
formatting on payment receipts (4/7/09 9:15 am, not 04/07/09 09:15 am)
MercuryHandler, pay_boxMsg_result, PaymentHandler, pos2, prehkeys, printLib, upcscanned
11:20am lane 8
1:30pm lane 9
4/9/09 atf: continued
4:00pm lanes 1,2,3,4,5,6,7,16,18
complete
4/9/09 atf: reversed the order of mercury server lookup
Mercury.conf.php
4:15pm lanes 8,9
4/10/09 atf: activated mercury on lanes 3,4
4/10/09 atf: continued reversing mercury server lookup
11am lanes 1,2,3,4,5,6,7,16,18
complete
4/14/09 atf: activated mercury on lanes 1,2,9,16
complete
4/14/09 atf: updated mercury.crt SSL CA file
mercury.crt
12:30pm all lanes
4/15/09 atf: reenable SSL verification using mercury SSL CA file, fix voiding
of gift cards sold/addvalue to use correct upc
MercuryHandler.class, PaymentHandler.class, void
8:30am lanes 7,8,9
9:30am rolled back MercuryHandler SSL, still not validating on live servers
11:50am PaymentHandler,void -> lanes 1,2,3,4,5,6,16,18
complete
4/15/09 atf: another try at mercury SSL verification
ca-bundle.crt, MercuryHandler.class
11:55am lane 9
all lanes
complete
4/21/09 Tak
Wired network name in network properties changed from "Local Area Connection" to "Wired"
10:45 am
Applied to lane01
4/22/09
Applied to all remaining lanes
4/22/09 atf: missing require in connect.php; added logging when the 'run carbon' screen is displayed
to make sure it isn't being bypassed somehow
connect, pay_boxMsg_result
8:15am lanes 16,18
9:20am lanes 8,9
9:40am lanes 6,7
2:20pm lanes 1,2,3,4,5
complete
4/23/09 atf: bug in new payment handler framework for lanes which don't run cards (ecb)
PaymentHandler.class
8:20am lane 18
10:20am lane 1
11:15am lanes 2,3,4
12:00pm lanes 5,6,7,8
12:40pm lanes 9,16
complete
4/29/09 atf: added auto-retry for connection problems to mercury
MercuryHandler.class
2:00pm lane 8
4/30/09 atf: continued
8:00am lanes 5,6,7
11:45am lanes 1,2,3,4
12:30pm lanes 9,16,18
complete
5/6/09 atf: inactive alternate communication code for mercury
MercuryHandler.class
8:10am: lane 8
5/7/09 atf: continued inactive
8:20am: lanes 5,6,7,18
5/7/09 atf: enabled alternate communication at lane 8
php.ini (openssl), Mercury.conf (MERCURY_NOCURL)
8:30am lane 8
5/7/09 atf: continued inactive
12:30pm lanes 1,2,3,4,9,16
complete
5/13/09 atf: enabled openssl module
php.ini
8:30am lanes 1,2,3,4,5,6,7,9,16 (not 18)
complete
5/13/09 atf: removed processor's message from decline boxes
9am lanes 1,2,3,4,5,6,7,8,9,16,18
complete
------------------------
5/21/09 apbw: pos.exe (transfer entire Magellan folder & restart pos.exe):
(a) streamline handling of regular barcodes
(b) new placeholder for GS1Databar/RSS14
10:30am lane 1
5/22/09 Tak
3:15 pm lane 9, 16, 18
old magellan folders remain entire, but renamed magellan.052209 or magellan052209
5/30/09 apbw
8:30am all remaining lanes (Magellan folder replaced, orig. not renamed)
*patch complete*
-----------------------------
5/22/09 atf: prefer track2 mag stripe data over track1 for Mercury's stand-in
MercuryHandler.class
12:15pm lanes 7,8,18
12:30pm lanes 3,4,5,6
12:45pm lanes 1,2,9,16
complete
5/26/09 atf: continued alternate communication
Mercury.conf
8:10am lanes 5,6,7
5/27/09 atf: continued
8:10am lanes 1,2,3,4
5/27/09 atf: continued
8:10am lanes 9,16,18
complete
6/5/09 Tak
DNS server pointing to 10.10.100.248 ( note that gateway must remain at 10.10.100.249 )
applied to lane01
6/8/09 Tak applied to all other 100 lanes.
6/11/09 atf: retry deadlocked sql queries
connect.php
9:30am lanes 8,9
12pm lanes 4,5,6,7
12:30pm lanes 1,2,3,16,18
complete
6/15/09 atf: better query retry logging; more efficient Mercury record synchronization
(to hopefully avoid so many deadlocks)
connect, MercuryHandler
8:30am lanes 8,9
12:30pm lanes 4,5,6,7
4pm lanes 1,2,3,16,18
complete
6/23/09 atf: added mercury connection debug logging
10am lanes 7,8
6/24 9am lane 16
6/30/09 atf: tweaked mercury connection debug logging, and enabled AmEx
9:45am lanes 7,8,9
10:15am lanes 1,2,3
12:55pm lanes 4,5,6,16,18
complete
7/22/09 Tak Search by first name patch
7:38 am lane 18
9:24 am lanes 9. 16
10:07 am lanes 1, 8
11:16 am lanes 2, 3, 4
11:37 am lanes 5, 6, 7
Complete
7/22/09 atf tweaked Mercury connection timeout settings again
12:30pm lane 8
1:45pm lanes 5,6,7
7/23/09 atf continued
8am lanes 16,18
1pm lanes 1,2,3,4,9
complete
7/24/09 Tak search by first name again
8:23 lane 18
9:02 lane 16
10:54 lanes 9, 1
11:40 lanes 2, 3, 8
3:57pm lanes 4, 5, 6, 7
Complete
7/28/09 JDP Chaged posbdat.dbo.pvlist view to include local flag
12:30pm lane9
1:00pm lanes 18,16
1:30pm lanes 1,2,3,4,5,6,7,8
=================================
7/29/09 apbw local toggle patch:
new local shift key & command (works like the tax shift and fs shift keys.)
substantive changes made to 3 files:
pos2.php, prehkeys.php, and upcscanned.php.
session variable also reset in these files (because toggleTax and/or toggleFoodstamp are reset here):
additem.php
ccDecision.php
decision.php
pay_boxMsg_amount
pay_boxMsg_auth
pay_boxMsg_confirm
paycardboxMsgAuth
paycardboxMsgBalance
paycardboxMsgGift
paycardboxMsgVoid
sessFunction
session
storecardboxMsgAdd
storecardboxMsgAuth
storecardboxMsgCashout
storecardboxMsgVoid
8:17am CSC lane 9 (scanning will re-program keyboard thursday)
3:55pm Deli lane 18
7/31 8am: CSC keyboard re-programmed.
7/31 8am: lanes 5,6,7,8, and 16.
8/1 9am: all remaining lanes, 1-4.
plus: added an error-suppressing @ before first mention of new session variable: upcscanned & prehkeys.php -- all lanes
* patch complete * (scanning will update all front end keyboards tuesday)
==============================
7/31/09 atf: new local purchase receipt summary
printLib.php
4:40pm lane 8
8/1 8:30am apbw: lanes 5,6,7,9,16, 18.
9:15am apbw: panic city -- reversed patch:
at the juice bar, the first new receipt caused all subsequent receipts to be
mis-aligned (text too far to the right and everything centered).
also, the JB staff don't care much for the progress bar because:
(a) since JB trans are always 100% local, the bar graph may not be useful at that location,
in part because its purpose as a *graph* isn't clear; it just looks like every JB receipt has an imposing black
bar on the bottom for no obvious reason.
(b) at least some of them disagree about *everything* from the juice bar being flagged as "local".
in short, there seems to be some disagreement on both aesthetic and truth-in-advertising grounds.
12:40pm: re-applying patch with no bar, just a larger-font, 2-line Local Summary on the footer
lane 18 & 9.
12:50pm: lanes 16 & 8.
2pm: lanes 1-7.
complete
=============================
8/2/09 atf: printLib, connect, MercuryHandler, pay_boxMsg_amount
fixed local purchase summary (alignment bug, plus more obvious "graph-ness");
added optional trim argument to sql_sanitize() to avoid column-overflow sql errors;
added column sizes to sql_sanitize()s in MercuryHandler;
reject amounts with letters in them ("3ID" => $0.03 bug) in payment amount screen
9:40am lane 8
3:30pm lanes 5,6,7,9
4:45pm lanes 1,2,3,4,16,18
complete
8/3/09 atf: ini/ini.php
added (inactive) receipt graphics settings to ini.php
8:30am all lanes
8/3/09 atf: printLib
added receipt graphics support
8:40am lanes 8,9 (with graphic)
9:20am lanes 5,6,7,18 (without graphic)
9:50am lanes 1,2,3,4,16 (without graphic)
10:20am lanes 5,6,7,18 (graphic)
10:40am lanes 1,2,3,4,16 (graphic)
complete
8/3/09 atf: reprint
forgot to add footer and local graphics to reprints
1:15pm lane 9
2:10pm lanes 5,6,7,8
2:30pm lanes 1,2,3,4,16,18
complete
8/3/09 atf: connect
fix to avoid unnecessary notices in the logs
2:40pm lane 9
4:10pm lanes 5,6,7,8,18
4:35pm lanes 1,2,3,4,16
complete
8/4/09 atf: postrans.lttSummary, postrans.localtranstodaySummary
enabled open rings in localTotal, localEligible since we now have local-shift
9:40am lane 18
10:10am lanes 8,9
10:30am lanes 4,5,6,7
11:55am lanes 1,2,3,16
complete
8/5/09 apbw: revise same 2 views to explicitly include trans_type D in local eligible & local total;
yesterday the lines excluding them were commented out, but they were still excluded by default in the
"else" clause, and need to be specifically included with trans_type I.
also, force open rings for depts 8,14, and 17 (deli, jb, bakehouse) to ring as local in prehkeys.php
9am lane 8 and 9 sql views
9:25am lane 8 and 9 php.
10:30 all remaining lanes (sql and php both).
* patch complete *
8/6/09 tak: local icons
icon gif files added to graphics folder on all lanes
SQL - screenDisplay view
4:41pm lane09, lane18
4:50pm lane01, lane16
5:00pm lane02, lane03, lane08
5:12pm lane04, lane05, lane06, lane07
Complete
08/07/09 tak: local icons 2
php files - drawscreen.php, listitems.php
10:11am lane01
11:20am lane18, lane16, lane09
11:30am lane08
12:50am lane02, lane03, lane04
1:11am lane05, lane06, lane07
Complete
08/18/09 tak prep for GS1 driver.
gs1.php - new file applied to all lanes
pos2.php
4:00 pm lane18, lane16, lane09
4:16 pm lane01, lane02
4:30 pm lane08, lane07
4:50 pm lane03, lane04, lane05, lane06
Complete
08/19/09 tak vb driver. prep for GS1
8:40 am lane01, lane02, lane03, lane04, lane16, lane18
08/25/09 jdp vb driver, cont.
7:00 am lane05, lane06, lane07, lane08, lane09
==================================================
8/31/09 atf: 61 files + ini + Magellan
pinpad framework patch!
8:30am lane 18
9/2/09 atf: void.php
typo in void_upc
8:20am lane 18
9/8/09 atf: MercuryHandler, PaymentHandler, printLib
super-fast-cashier-double-charge safeguard, card read error debugging
8:45am lane 9
9:15am lanes 1,2
11:20am lanes 3,4,5
12:30pm lanes 6,7,8,16 (18 has pinpad code)
complete
9/9/09 atf: MercuryHandler, PaymentHandler
disabling useless Mercury connection error messages, added info to card read error logs
9:20am lane 9
10:20am lanes 1,2
12:00pm lanes 3,4,5
2:00pm lanes 6,7,8,16 (18 has pinpad code)
complete
9/10/09 atf: PaymentHandler
removed card read error reason from cashier prompt (just confusing, still logged),
made mag stripe parsing less strict, maybe it will stop rejecting amex?
9:00am lane 9
10:55am lanes 1,2,3
12:15pm lanes 4,5,6
12:45pm lanes 7,8,16 (18 has pinpad code)
complete
9/14/09 atf: PaymentHandler
possible fix for AmEx not scanning
3:35pm lane 9
4:05pm lanes 1,2,3
9/15/09 continued
8:20am lanes 4,5,6
10am lanes 7,8,16
complete
9/25/09 atf: SQL mercuryRequest,mercuryResponse
added columns for CVV and AVS verification
8:30am all lanes, mars, io
complete
9/28/09 atf: pinpad framework patch continued
8:30am lane 9
===============
9/29/09 apbw:
update postrans.dbo.screenDisplay view so that when a transaction is suspended and resumed,
mfr coupons don't mess up the display (solution: abbreviate Mfr in the display).
8:50am lane 18
10:30am lane 9
9/30/09 8:35am: lanes 1-8 + 16.
complete
=================
9/29/09 atf: printLib, coupondec, void
two-column and check endorse printing bugfix; void typo fix
amy's coupon department input fix
12:15pm lane 18
12:30pm lane 9
(PINpad code only)
complete
10/1/09 atf: 19 files
void-a-refund bugfix; updated manual credit card verification;
support for backup-integrated toggle (but no alternate integrated system yet)
4:20pm lane 18
10/2/09 atf: continued
8:00am lane 9
(PINpad code only)
complete
10/4/09 jdp: interrupt!
void.php patch for voiding weighed items
11:30am lane9
10/5/09 atf: john's void fix
8:10am lane 18
complete
10/12/09 atf: pay_*.php, PaymentModule
better error handling for session loss
8:30am lane 18
11:15am lane 9
complete
10/13/09 atf: clientscripts, PaymentModule, MercuryPaymentHandler, mercury_unstuck, alib.HTTP.js
try to fix slow-first-card by sending SystemCheck in the background at cashier login
9:45am lane 18
11:45am lane 9
complete
10/19/09 atf: lots and lots of files
PINpad code everywhere!
9am lanes 1,3,4,5,6,7,8
complete (only JB remains old-code)
10/19/09 atf: pos2.php
fix for '403' PLU misread as wedgecard
10:50am lanes 1,9,18
12:15am lanes 6,7,8
1:45pm lanes 3,4,5
complete
10/19/09 atf: PaymentCard.class
fix for EBT expiration checking
2:45pm lane 7
3:10pm lanes 5,6,8,18
4:30pm lanes 1,3,4,9
complete
10/20/09 atf: dunno how it got skipped
PINpad code
8:20am lane 2
complete
10/20/09 jdp: pv bug
pv now has priority over $right codes with $strlen>2
3:40pm lane 1
4:00pm lanes 2,3,9
10/21/09 jdp: continued
12:30pm lanes 4,5,6,7,8,18
10/22/09 atf: pos2.php
tweak to john's pv bug fix (so "PVEC","PVEF" still balance-check, but "PV...EC" price-verifies)
10am lane 18
12pm lanes 9,1,2,3
2pm lanes 4,5,6,7,8
complete
10/27/09 atf: pos2.php, MercuryPaymentHandler.class
misread-as-wedgecard bugfix; EBT NSF decline text recognition
8:50am lanes 9,18
9:55am lanes 1,2,3
12:55pm lanes 4,5,6,7,8
complete
NCGA pie coupons (apbw)
10/28/09 8:30am lanes 9, 18
10/29/09 11:00am tested live @ CSC
10/29/09 11:20am lanes 1-9
complete (except for Juice Bar which will get it wrapped in EBT pin pad patch)
10/30/09 atf: pay_boxMsg_sign.php
added logging for cashier-requested-resign to debug signature problems
5pm lane 7
11/2/09 atf: mercury_unstuck, pay_boxMsg_sign, PaymentModule.class
disable unstuck logging, add cashier-requested-resign logging,
disable card read error logging, add bugfix for empty signature data
11:10am lanes 7,8,18
12:10pm lanes 4,5,6
1:45pm lanes 1,2,3,9
complete
11/3/09 atf: PaymentHandler.class
skip electronic signatures for manually entered cards (to avoid conflicting
with CVV/AVS mismatch screen)
8:30am lanes 9,18
9:40am lanes 7,8
11:10am lanes 1,2,3
11:40am lanes 4,5,6
complete
11/3/09 atf: connect
mixmatch/voldisc/void bugfix
12:50pm all lanes
complete
11/4/09 atf: prehkeys, pos2
localtemptrans/percentdiscount bugfix, added BQ for integrated balance check
8:50am lanes 9,18
10:40am lanes 1,2,3
11:30am lanes 4,5
12:05pm lanes 6,7,8
complete
----------------------------------------
11/4/09 couponSpecial.php - turn off date validation for NCGA deli pie coupons. apbw
1:50pm lanes 9 and 18
4:00pm lanes 5,6,7,8
5:40pm lanes 1,2,3,4
complete *except JB*
----------------------------------------
11/5/09 stock pmt patch -- apbw
SQL views: lttSummary, localtranstodaySummary, subtotals, and rpsubtotals (new fields stockTotal and LastName)
php files:
1. connect.php (new field stocktotal)
2. endorse.php (print stockslip instead of endorsing payment forms)
3. printLib.php
a. new functions for stockSlipCust and stockSlipStore;
b. tweak promoMsg to always suppress local dollars and bar graph if local total or percentage <= 0;
c. bold header for staff charge slips to distinguish from other slips.
4. printReceipt.php (call stockSlipCust and stockSlipStore).
5. reprint.php (ditto; also added new receipt graphics and promoMsg as on original receipts).
6. tenderReport.php (list stock payments and summary zero tenders).
7. upcscanned.php
a. differentiate between stock payments and new memberships;
b. call refund form AFTER checking for required quantity.
8:30am SQL views lanes 9 & 18
8:35am php lanes 9 & 18
8:40am SQL views lanes 1-16
8:45am php lanes 1-8
complete *except php @ JB, in accordance with the pin pad code transfer status*
----------------------------------------
11/6/09 atf: chkserial, display, end, i6580InterfaceHandler.class, input, msgscreen,
msgscreen0, noinput, pos, printLib, session, tender, topBorder, upcscanned, void
customer swipe notification
8:30am lane 7
11/9/09 continued
8am lanes 1,2,3,4,5,6,8,9
complete
11/10/09 atf: input
when msgrepeat=2, don't post "" to main_frame on every input.php refresh
8:30am lane 18
11:30am lanes 7,8,9
12:25pm lanes 1,2,3,4,5,6
complete
11/11/09 atf: connect
separately re-use connections to postrans,posbdat,wedgepos
8:15am lanes 9,18
10:30am lanes 1,2,3,4
11:15am lanes 5,6,7,8
complete
11/12/09 atf: pay_boxMsg_sign, pos2
non-integrated tender warning, tweaked signature prompt/download logic
8:30am lanes 9,18
12:50pm lanes 1,2,3,4
2pm lanes 5,6,7,8
complete
11/12/09 atf: pay_boxMsg_sign
another shot at the re-sign bug
3pm lanes 9,18
4pm lanes 1,2,3,4
4:30pm lanes 5,6,7,8
complete
11/13/09 atf: input, pay_*, PaymentModule.class, PaymentHandler.class
more attempts at re-sign and other phantom input bugs
8:55am lane 9
12pm lanes 1,2,18
12:30pm lanes 3,4,5
12:40pm lanes 6,7,8
complete
11/16/09 atf: pos.exe
multiple-receive bugfix
8:30am all lanes
complete
11/18/09 atf: i6580InterfaceHandler.class, pay_boxMsg_pinpad/result/sign, PaymentHandler.class
support for sign-during-auth
*** cannot apply this patch while a cashier is logged in! ***
8:30am lanes 1,7,8,9
11/19/09 continued
8:15am lanes 2,3,4,5,6,18
complete
11/19/09 atf: ini/ini.php, ini/Mercury.conf.php, graphics/i6580-e.gif, input, noinput, session, topBorder
support for last-good-server; pinpad link check icon; F11={padreset}
3:40pm lanes 8,9
4:00pm lanes 1,2,3
4:15pm lanes 4,5,6,7,18
complete
11/20/09 atf: pay_boxMsg_amount, pay_boxMsg_card, pay_boxMsg_pin, pay_boxMsg_pinpad,
pay_boxMsg_result, pay_boxMsg_sign, pay_send, PaymentModule.class
support for pinpad link check; [re-ring] -> [toggle-enter]; lost EBT call FEC
8:30am lanes 7,8,9
9:20am lanes 1,2,3,18
10:00am lanes 4,5,6
complete
11/20/09 atf: device_pinpad, pos2
pinpad link check; F10=wakeup for scale only, F11={padreset}; "PVPC" fix
10:20am lanes 1,8,9
11:05am lanes 2,3,4,18
11:50am lanes 5,6,7
complete
11/20/09 atf: MercuryPaymentHandler.class, MercuryPaymentSystems.class
Mercury last-good-server switch; suppress fake EBT:CA $0 balance
2:10pm lanes 1,8,9
2:45pm lanes 2,3,4,18
3:15pm lanes 5,6,7
complete
===========================
11/26/09 1pm: allow all pie coupons to apply to all pies per mass confusion -- apbw
all lanes except JB.
===========================
11/27/09
New session variable "secondlogin" added to each individual ini.php file. No panic city, to avoid confusion, since the ini.php files are individualized.
To revert, delete last line. -- Tak
lanes 9, 16 (yes, juice bar too), 18
lanes 1, 2, 3, 4
All other lanes
Complete
11/27/29
Added a field 'drawer' to posbdat.GlobalValues with a default of 1, Null not allowed
Applied to
lane18
11/30/09 all other lanes
Complete
===========================
11/27/29
Added an extra line to stored procedure "dayendreset" to set
default for drawer in posbdat.GlobalValue to 1
Applied to lane18, 16, 9, 1
Applied to all other lanes
Complete
========================================
12/01/09 apbw
Printing patch:
1. Print member name on stock slip and show @ prompt
2. Start using memType field in local dtransactions (still not using on Mars)
3. Specify charge type (Employee or Biz) on charge slips
4. Shorter tender report option for midday drops
files:
additem, adminlist, admintasks, connect, endorse, prehkeys, printlib,
printReceipt, reprint, session, tender, tenderReport, upcscanned.
8:30am Lanes 18 and 9.
( I will do the rest tomorrow a.m. to avoid introducing new session variables
mid-session).
------------------------------------------------
12/02/09 apbw 11:30am - noon
Yesterday's printing patch to all remaining lanes except JB
(one by one in person): 1,2,3,4,5,6,7,8.
Also (later) improved 2 of my new lines in additem.php to better allow for unrecognized/unset session variable.
12:30pm: Lanes 18,9,
12:45pm Lanes 8,7,6
12:58pm Lanes 5,4,3,2,1
Complete! except JB
========================================
12/3/09 apbw
Endorse HBC special order deposits form:
upcscanned.php (hard-coded list of PLUs -- to do: use itemTable field instead),
endorse.php, and printLib.php.
11am CSC and Deli Chargebook
11:30 am Lane 8
11:45 am Lanes 1-7
Complete! except JB
=======================================
12/16/09 apbw
tying up some loose ends:
tenderReport.php (tender reports should fail immediately when in standalone);
session.php (set $_SESSION["newMember"] and $_SESSION["LastName"] in loaddata function);
refundForm.php & refundFormVerify.php (better form validation to prevent failed queries);
10:20am Lane 18
12:58pm Lane 9
2:47pm Lane 8
4:30pm Lanes 1-7
Complete! except JB
=======================================
12/17/09 atf
adminlist, i6580InterfaceHandler, InterfaceModule, pay_boxMsg_pinpad, pay_boxMsg_sign, printLib
"./" in includes, tweaked pad communication
8:30am lane 1
8:50am lane 18
11:00am lanes 7,8,9
12:00pm lanes 2,3,4,5,6
complete
12/17/09 atf
ConcordEFSnet, EFSnetPaymentHandler, MercuryPaymentHandler, pay_boxMsg_result,
PaymentHandler, PaymentModule, StorecardPaymentHandler
"./" in includes, per-handler CVV/AVS support flags, backup integrated system
1:45pm lane 1 (for live trial)
12/18/09 continued
8:00am lanes 9,18
10:30am lanes 2,3,4
11:20am lanes 5,6,7,8
complete
12/21/09 atf
ConcordEFSnet, efsnet.crt, EFSnetPaymentHandler, HTTP, MercuryPaymentHandler
added SSL certificate verification for EFSnet, better HTTP error handling,
bugfix in mercury decline response messages
9:15am lane 18
12:20pm lanes 7,8,9
1:50pm lanes 1,2,3,4,5,6
complete
==========
12/22/09 apbw
Added cranberry walnut pie PLU 4333 to couponSpecial.php per Danelle
(pie bunker now has pecan, apple, pumpkin, and cran-walnut)
10am lane 18
10:10am lanes 1-9
complete except for juice bar
==========
12/30/09 atf
admintasks, i6580InterfaceHandler, pay_boxMsg_confirm, pay_boxMsg_sign, PaymentModule
disable unsupported payment type buttons (ebt,gift) on backup payment system
10:30am lane 1
12:05pm lanes 2,3,18
12/31/09 atf
continued
8:50am lanes 4,5,6,7,8,9
complete
1/5/10 atf
pay_boxMsg_amount/auth/pinpad/sign, PaymentHandler
fix for signature capture debugging
8:30am lanes 8,18
1/6/10 atf
continued
11am lanes 1,2,3,9
12pm lanes 4,5,6,7
complete
1/12/10 atf
auto FNTL on TL (two separate lines); void rounding fix; void FS updates tax exempt
8:15am lanes 9,18
1/13/10 atf
continued
9am lanes 1,2,3,4
12:45pm lanes 5,6,7,8
complete
1/16/10 apbw
re-apply overwritten prehkeys.php patch from 8/5/09
forces open rings for bakehouse, juice bar, and deli to ring as local.
12:30 pm lane 9
12:45 pm lane 18
2:08pm lanes 1,2,3
5:30pm lanes 4-8
complete
1/18/10 atf
additem, clubCard, lib, pos2, session, upcscanned, void
formatting changes for easier reading; more stable voiding of club cards and refunds;
renamed session["em"] to "employeeMug" for clarity; fixed roundup-pinpad-reset
8:40am lanes 7,8,9
2:50pm lanes 1,2,3,4
4:40pm lanes 5,6,18
complete
1/19/10 atf
clientscripts, connect, drawscreen, is4c.css
fsElig>1000 void-paid-for bugfix, formatting changes
10:20am lanes 7,8,9
11am lanes 1,2,3,4
12:10pm lanes 5,6,18
complete
1/21/10 atf
additem, maindisplay, pos2, prehkeys, upcscanned
RU pinpad line item bugfix; foodstamp-shift dept over limit bugfix; new info line
when setting member ID
9:55am lanes 7,8,9
11:30am lanes 1,2,3,4
1:55pm lanes 5,6,18
complete
1/26/10 atf
MercuryPaymentHandler, pay_send, PaymentHandler, refundFormVerify
treat Mercury invalid card "error" as "decline"; cleaner javascript hooks for
send/abort; count refunded wedgecards as qty=1
8:35am lanes 7,8,9
11:30am lanes 1,2,3,18
12:20pm lanes 4,5,6
complete
1/29/10 atf
printLib
support for promoMsg=3 donation footer (with extra ini settings promoMsgSince,promoMsgList)
10:40am lanes 1,9,18
3:00pm lanes 2,3,4,5
4:25pm lanes 6,7,8
complete
2/2/10 atf
drawscreen, i6580InterfaceHandler, printLib
updated support for promomsg=3 donation footer including pinpad ad screen
8:25am lanes 8,9,18
9:35am lanes 1,2,3,4
10:40am lanes 5,6,7
complete
2/3/10 atf
postrans.screenDisplay
made TFRV flags independent (V used to mask everything, and R masked TF; MC still masks TF)
9:20am lanes 1,9,18
11:20am lanes 2,3,4
12:45pm lanes 5,6,7,8
complete
=======================
2/4/10 apbw
pos2.php and productselected.php:
allow refunds from the quick-lists,
and clear the refund flag when clearing out of the lists.
1:25pm lane 16!
=======================
2/5/10 atf
pos.exe
use COM1 (scale) and/or COM4 (pinpad) if available, don't complain if not
8:20am lanes 8,16 (for the weekend)
=======================
2/5/10 10:15am apbw
quick-list refund patch applied to lanes 18, 9, and 1.
2/7/10 8:30am apbw
quick list refund patch applied to lanes 2-8.
*patch complete*
=======================
2/10/10 apbw:
pos2.php and productselected.php:
allow multiples from the quick-lists (per JB & FE request).
10:30am Juice Bar
=======================
2/8/10 atf
pos.exe
continued
8:20am lanes 1,2,3,4
2/9/10 atf
pos.exe
continued
8:10am lanes 5,6,7,9(,18)
complete
2/23/10 atf
sql: mercuryRequest (origAcqRef,origProcData), mercuryResponse (_TR_Amt_Auth, _TR_AcqRef, _TR_ProcData)
for partial authorization, realtime-reversals
8:50am lanes 1,2,3,4,5,6,7,8,9,16,18, mars, io (must be all at once for uploads to keep working)
complete
2/26/10 atf
i6580InterfaceHandler, printLib, ini/ini
new mn foodshare donation graphics starting march 1
8:20am lanes 1,8,18
12pm lanes 2,3,4,5
1:45pm lanes 6,7,9,16
complete
3/1/10 atf
sql(postrans): lttSubtotals, subTotals, screenDisplay, memDiscount(Add|Remove), staffDiscount(Add|Remove)
fsTendered,fsDiscount subtotals for voiding; vd-rf-cp display fix; discount adjust tax/fs/local toggles fix
12:15pm lanes 1,8
1:20pm lanes 2,3,4
3:40pm lanes 5,6,7
4:50pm lanes 9,16,18
complete
3/4/10 atf
MercuryPaymentHandler, MercuryPaymentSystems, pay_boxMsg_result, pay_send, PaymentModule
improved backup server usage, partial auth support prep, better timeout/giveup/resend/reset logging
8:20am lanes 1,9,18
10:40am lanes 2,3,4,5
12:00pm lanes 6,7,8,16
complete
3/5/10 atf
i6580InterfaceHandler, printLib
donation screen update fix
8:20am lanes 1,9,18
10:15am lanes 7,8,16
11:20am lanes 1,2,3,4,5,6
complete
3/8/10 atf
printLib
donation total query fix
2:50pm lanes 9,16,18
3:45pm lanes 5,6,7,8
4:30pm lanes 1,2,3,4
complete
3/10/10 atf
receiptfooter.escpos, receiptwww.escpos
removed wedge worldwide footer, added rooster to regular footer
10:30am lanes 9,16,18
11:00am lanes 1,2,3,4
11:50am lanes 5,6,7,8
complete
3/15/10 atf
ini/ini.php
added linesPerPage=12 to prepare for screen height patch
8:30am lanes 16,18
10:30am lane 9
11:00am lanes 1,2,3,4,5,6,7,8
complete
3/17/10 atf
mostly minor changes to 36 files for adjustable screen height
8:40am lane 8
3/18/10 atf
continued
10:30am lanes 1,18
12:15pm lanes 2,3,4,5
3:00pm lanes 6,7,9,16
complete
3/22/10 atf
clientscripts, connect, deptkey, end, loadProduct, prehkeys, productlist, upcscanned, void
item/dept/coupon ring/refund/void bugfix/update/extension phase 1 (little stuff)
9:05am lanes 7,8,18
9:50am lanes 1,2,3
11:45am lanes 4,5,6
12:25pm lanes 9,16
complete
3/23/10 atf
display, drawscreen, input, invalid, listitems, login, login2,
msgscreen, msgscreen0, noinput, pos, pos2, topBorder
draggable scrollbar, yousaved/staffspecial fix
8:20am lanes 7,8,9
10:30am lanes 1,2,3
11:20am lanes 4,5,6,16,18
complete
3/24/10 atf
postrans.screenDisplay
'R' and color for refunded club cards
8:30am lanes 1,7,8
9:30am lanes 2,3,4
10:30am lanes 5,6,9
11:05am lanes 16,18
complete
3/29/10 atf
authenticate, clientscripts, end, maindisplay
autopatch (put new files in "/patch" with a description in "/patch/patch.txt")
8:10am lanes 1,8,9
9:55am lanes 2,3,4
11am lanes 5,6,7
11:45am lanes 16,18
complete
3/30/10 atf
additem, clubCard, couponDept, couponSpecial, decision, deptkey, loadProduct, pos2,
prehkeys, productselected, qttyauth, refundFormVerify,session, tender, upcscanned, void
item/coupon/open ring/refund/void patch
8:10am lane 8
3/31/10 atf
upcscanned
fixed entering plu before weighing item with a tare entered, re-applied patch to lane 8
8:45am lane 8
4/5/10 atf
continued
8:30am lane 9
4/6/10 atf
continued
8:15am lane 7
4/7/10 atf
continued
8:20am lanes 1,2,3,4
4/8/10 atf
continued
8:15am lanes 5,6,16,18
complete!
4/12/10 atf
boxMsg0, boxMsg2, deptkey
fix string formatting and refund info order for "over dept limit"
8:30am lane 9
10:30 lanes 1,2,3,4
11:45 lanes 5,6,7,8
2:30pm lanes 16,18
complete
4/13/10 atf
void
fixes for voiding voldisc items (qty for entire sets, refund voldisc void order)
8:15am lanes 7,8,9
10am lanes 1,2,3
12:15pm lanes 4,5,6
12:40pm lanes 16,18
complete
4/15/10 apbw
posbdat.dbo.reloadCustomers: replaced "select *" with field list so we can add fields with impunity.
9:00 lane 19
9:10 lanes 16, 9, 8,7,6,5,4,3,2,1.
complete
4/16/10 atf
loadProduct
recognize scale labels with or without leading 0s (to accomodate chargebook speed keys)
8:20am lane 18
4/19/10 atf
continued
8:15am lanes 1,2,3,4
12:30pm lanes 5,6,7,8
3:30pm lanes 9,16
complete
4/20/10 atf
pay_boxMsg, pay_boxMsg_amount, pay_boxMsg_pin, pay_boxMsg_pinpad, pay_boxMsg_result, pos2
fix refund amount for EBTFS via pinpad; fix specified staff-charge amount at CSC
9:30am lane 9
10:30am lanes 1,2,3,4
11:45am lanes 5,6,7,8
12pm lanes 16,18
complete
4/21/10 atf
MercuryPaymentHandler, pay_boxMsg_auth, pay_boxMsg_card, pay_boxMsg_confirm,
pay_boxMsg_sign, pay_boxMsg_type, pay_send_next
activated support for partial cc authorization as required by mc/disc
8:20am lane 8
4/22/10 atf
continued
8:40am lanes 1,2,3,4
11:15am lanes 5,6,7
2:25pm lanes 9,16,18
complete
4/26/10 atf
HTTP, memsearch, pay_boxMsg_autovoid, PaymentHandler, productsearch, tender
fix for connection loss while sending CC data, auto-confirm auto-voids, don't tender out on partial refund
8:30am lanes 7,8,9
10:45am lanes 1,2,3,4
1:45pm lanes 5,6,16,18
complete
4/27/10 atf
postrans views: loca/ltranstoday_grouped, ltt_grouped, ltt_receipt, ltt_receipt_reorder_g,
lttSummary, rp_ltt_Receipt, rp_ltt_receipt_reorder_g
group cash tenders, don't group scale items, check integrated items by voided=9 (for class reg)
8:30am lane 9
10:45am lanes 1,2,3,4
11:45pm lanes 5,6,7,8
12:15pm lanes 16,18
complete
4/28/10 atf
classreg*, pos2, printLib, reprint, upcscanned, void
integrated class registration
8:15am lane 9
4/30/10 tak
Four new fields added to custData on all lanes, as well as on various
stored procedures and views associated with custdata
on earth and mars and on each lane
5/3/10 atf
classreg* etc
continued
8:30am lanes 1,2,7,8
2:30pm lanes 3,4,5,6
3:30pm lanes 16,18
complete
5/3/10 atf
config procs: bcp_db, gss_db
jobs: shutdown
dump sql schema to is4c/sql and then shut down every night at 12:xx am
3:30pm lane 1
5/4/10 atf
continued
9:00am lanes 2,3,4,5,6,7,8,16,18
complete
5/4/10
additem, ConcordEFSnet, EFSnetPaymentHandler, i6580InterfaceHandler, MercuryPaymentHandler,
pay_boxMsg_address, pay_boxMsg_cvv, pay_boxMsg_pinpad, pay_boxMsg_sign, pay_boxMsg_zip, pos2, upcscanned
workaround for repeating signature bug; debugging for lost items; improved DEBUG csv output
9:30am lane 8
5/5/10
continued
8:30am lanes 1,2,3,4
5/6/10
continued
11am lanes 5,6,7,9,16,18
complete
5/7/10 12:30 pm Tak
SQL datatye percentDiscount changed to decimal(10,8) in tables
suspendedArchive, localtransArchiveAdj, localtransArchive, localtrans
dtransactions, localtemptrans
lanes 18, 19, 1
2:30 pm
lanes 2, 4, 9
5/8/10
All remaining lanes
complete
---------------------------------------
5/10/10 atf
adminlist, admintasks, Bitmap, correction*, endorse, ESCPOSPrintHandler,
pay_boxMsg_result, PaymentHandler, printLib, session
transaction corrections and credit carbon slip endorsement
11:15am lane 9
1:45pm lanes 1,2,3,4
2:30pm lanes 5,6,7,8
3:15pm lanes 16,18
complete
5/11/10 atf
i6580InterfaceHandler, PaymentHandler
bugfixes for carbon endorsement on decline and double quote in item descriptions
9:30am lanes 7,8,9
10am lanes 4,5,6
11am lanes 1,2,3
12pm lanes 16,18
complete
5/11/10 tak
added new session variables to sessions.php
1:00 pm lanes 18, 16, 9
1:20 pm lanes 1, 2, 3
5/12/10 Tak
all remaining lanes
Complete.
5/13/10 atf
postrans views: screenDisplay, ltt_receipt, ltt_receipt_reorder_g,
rp_ltt_receipt, rp_ltt_receipt_reorder_g
remove weight from screen/receipt for scale items since prices aren't synced
8:45am lane 9
9:30am lanes 1,2,7,8
11am lanes 3,4,5,6
12:40pm lanes 16,18
complete
5/20/2010 tak
{DR} to establish discountreq = 1, indicating that member requests
to apply discount
4:00 pm lane 18, 16, 9
4:10 pm lanes 1, 2, 3
4:20 all remaining lanes
complete
5/21/2010 Tak
drawnscreen.php removed M E M B E R to make room.
when percentage discount falls below 10% label reads "mbr Discount"
instead of "10% Discount"
5:20 pm lane 18, 16, 9, 1
5:45 pm lanes 2, 3, 4, 5
6:35 pm lanes 6, 7, 8
complete
5/25/2010 Tak
New discount patch. pos2.php, prehkeys.php, void.php
6:30 pm lane 18
5/26
9:50 am lane 16, 9, 1, 2
10:05 am lanes 3, 4, 5
10:20 am lanes 6, 7, 8
complete
5/26/2010 Tak
Session newdiscount added to ini.php (last line) to ease transition
Applied to all lanes
5/27/2010 Tak
New discount patch
3:30 pm lane 18, 16
3:50 pm lane 1, 9
4:10 pm lane 2, 6
5/28/2010 Tak
New discount patch continued (fixed void bug)
patch dormant unless session newdiscount in ini.php is set to 1
10:00 am lane 18, 16
10:20 am lanes 1, 2, 3, 4
11:30 all remaining lanes
complete
5/28/2010 tak
fixed 8005 bug in discount patch
12:30 pm lane 18, 19, 9, 1, 2
2:00 pm all remaining lanes
complete
6/1/10 atf
AutopatchInterfaceHandler, autopatch, clientscripts, end
cleaner autopatch hook using InterfaceModule
9am lanes 1,8,9
10:45am lanes 2,3,4,5
12:30pm lanes 6,7,16,18
complete
6/2/10 Tak
discount patch continued: pos2 and prehkeys
12:30 pm lanes 18, 16, 9, 1, 5
1:00 pm all remaining lanes
Complete
6/3/10 atf
classreg1_class, classreg3_verify, HTTP, i6580InterfaceHandler, maindisplay,
PaymentHandler, pos2, prehkeys, void
classreg updates; HTTP/i6580 bugfixes; test mode PaymentHandler bugfix; discountreq/reversediscount tweaks
8:30am lanes 1,8,9
10:45am lanes 2,3,4,5
12:50pm lanes 6,7,16,18
complete
6/4/2010 Tak
New discount tweaks, continued
discount.php, pos2.php, prehkeys.php, tender.php
11:10 am lanes 18, 16, 9, 1
12:20 pm all remaining lanes
complete
6/4/2010 Tak
New discout tweak, SQL - receipt_reorder_unions_g
1:05 pm lane 1, 18, 16, 9
1:30 pm all remaining lanes
Complete
6/7/2010 Tak
New discount tweak - reactivation
tender.php, void.php
12:00 noon lanes 18, 16, 9, 1
12:30 pm lanes 2, 3, 4, 5
12:45 pm all remaining lanes
complete
6/8/2010 Tak 11:30 am
memberCommentPlus.php
all lanes
Complete
6/10/10 atf
classreg_2reg, PaymentModule, reload, reloadlanes, resume, void
classreg bugfix; absolute/relative path tweaks
plus tak's one line - reversediscount() added to setmember() in prehkeys.php
9am lanes 1,8,9
12pm lanes 2,3,4,5
4pm lanes 6,7,16,18
complete
6/17/10 Tak - New Discount Tweaks conintued
10:30 am lanes 18, 16, 9, 1
3:00 pm applied to all remaining lanes
Complete
6/19/10 4:30pm Tak
REACTIVATED (0) changed to REACTIVATED (3) in tender.php
all lanes
Complete
6/19/10 4:50pm Tak
Reverse premature application of new feature in drawscreen.php
all lanes
Complete
6/22/10 Tak
discount/refund
lttsummary, lttsubtotals, subtotals
11:15 am lanes 18, 16, 9, 1
11:25 am lane 2
6/26/10 10:00 am all remaining lanes
6/33/10 Tak
discount/refund tweak
connect.php
10:45 am
lanes 18, 16, 9, 1, 2
11:30 am
All remaining lanes
Complete
6/28/10 atf
MercuryPaymentHandler, upcscanned
mercury alt server and scale-not-ready bugfixes
8:50am lanes 1,8,9
11:10am lanes 2,3,4,5
12pm lanes 6,7,16,18
complete
7/12/10 atf
classreg*, upcscanned, void
integrated class refunds
8:30am lane 9
7/13/10 atf
added MercuryPaymentHandler bugfix for ebt card validation, continued patch
8:50am lanes 1,8
7/14/10 atf
continued
9:30am lanes 2,3,4,5
11:20am lanes 6,7,16,18
complete
7/22/10 atf
clock.js, connect, goto, input, noinput, pay_boxMsg, StorecardPaymentHandler
bugfixes for Wedgecard voids & standalone; double-click noinput failsafe; js clock
8:50am lanes 1,8,9
9:55am lanes 2,3,4,5
12pm lanes 6,7,16,18
complete
7/26/10 atf
mgrlogin, nslogin, pay_boxMsg_result, pay_send, PaymentHandler, PaymentModule, pos2, printLib, qtty2
updated credit card error message wording; cc carbons now done on manual entry, not initial loss
10am lane 1
11am lanes 8,9
12pm lanes 2,3,4,5
1pm lanes 6,7,16
1:45pm lane 18
complete
7/29/10 atf
additem, adminlist, admintasks, clock.js
rollback js clock (pos.exe crash?), disable integrated backup 8/1, stop logging additem repeat ignored
3:30pm lanes 1,8,9
7/30/10 atf
continued
8:40am lanes 2,3,4,5
12:30pm lanes 6,7,16,18
complete
7/30/10 atf
MercuryPaymentHandler
disabled test/live gift card checking to accomodate new NCGA gift cards that look like test cards
3:15pm lanes 1,2,8,9
4:50pm lanes 3,4,5,6,7,16,18
complete
8/3/10 atf
autopatch, AutopatchInterfaceHandler, drawscreen, end, invalid3, MercuryPaymentHandler, printLib
updated gift card identification; more robust printing (gibberish bug); misc code cleanup
10am lanes 1,8,9
11am lanes 2,3,4,5
12pm lanes 6,7,16,18
complete
8/17/10 atf
TAB posbdat.products
VIW Mars.WedgePOS.ItemTableView3, posbdat.RecentlyEditedItems
PRC posbdat.reloadProducts, posbdat.UpdateProducts2, config.loadProducts
added 'organic' column to lanes' product tables and associated update views/procedures
11am lane 1
8/18/10 atf
continued
10am lanes 2,3,4
8/19/10 atf
continued
2:20pm lanes 5,6,7,8
3:40pm lanes 9,16,18
complete
8/23/10 atf
classreg_2reg, clientscripts, maindisplay, MercuryPaymentHandler
bugfixes for long class names, clearTimeout(), input box refresh, Mercury void card mismatch
10:40am lanes 1,8,9
11:55am lanes 2,3,4,5
2pm lanes 6,7,16,18
complete
8/24/10 atf
VIW postrans.receipt_reorder_unions_g, rp_receipt_reorder_unions_g
added organic column to receipt views for organic bar
9am lanes 1,8,9
9:50am lanes 2,3,4,5
11:15am lanes 6,7,16,18
complete
8/26/10 atf
additem, pay_boxMsg_staffcharge, pos2, prehkeys, printReceipt
support for staff chargecode on pinpad
9am lanes 1,8,9
10:40am lanes 2,3,4,5
12:10pm lanes 6,7,16,18
complete
8/29/10 jdp
Added clothing deposit to the specorderdeposit list in upcscanned.php
3p lanes 9,16,18
4p lanes 1,2,3,4,5,6,7,8
8/30/10 atf
pay_boxMsg_staffcharge, pos2, prehkeys, printReceipt, tenderReport
bugfix for staff chargecode on pinpad; disabled staff charge receipt printing
8:15am lanes 1,8,16
8:40am lanes 2,3,4,5,6,7,9,18
complete
8/31/10 atf
i6580InterfaceHandler, loadProduct, printLib, reprint
organic bar footer support (promoMsg & 4)
8:40am lanes 1,8,9
9:55am lanes 2,3,4,5
11:20am lanes 6,7,16,18
complete
9/7/10 atf
printLib, printReceipt, reprint
fix business/employee charge slip printing
8:40am lanes 1,8,9
9:50am lanes 2,3,4,5
10:40am lanes 6,7,16,18
complete
9/8/10 atf
clientscripts, pay_boxMsg_result, PaymentHandler
apply tender amount on lost credit cards, and automatically frank carbons again
8:40am lanes 1,8,9
11am lanes 2,3,4,5
12pm lanes 6,7,16,18
complete
9/14/10 atf
memlist, pay_boxMsg_staffcharge, prehkeys
fix to apply member specials for staff+members when paying by staff charge
8:35am lanes 1,8,9
10:50am lanes 2,3,4,5
12:15pm lanes 6,7,16,18
complete
9/27/10 atf
classreg_2reg, PaymentModule
require a phone number for class registrations
9am lanes 1,8,9
11am lanes 2,3,4,5
12pm lanes 6,7,16,18
complete
10/11/10 atf
MercuryPaymentHandler, StorecardPaymentHandler
smoother mercury timeout/retry; receipt fix for voided wedgecard partial approvals
11:50am lanes 1,8
10/12/10 atf
EFSnetPaymentHandler, MercuryPaymentHandler, pay_boxMsg_pinpad/result/sign,
PaymentModule, StorecardPaymentHandler
separate payment log added to previous patch
8:40am lanes 1,8
10/13/10 atf
continued
8:55am lanes 2,3,9
10/14/10 atf
continued
10am lanes 4,5,6
12:50pm lanes 7,16,18
complete
10/25/10 atf
HTTP, MercuryPaymentHandler, pay_boxMsg_result, PaymentHandler, PaymentModule, pos2
bugfix for voiding EBT; smoother mercury timeout/retry
8:30am lane 8
10:50am lane 7
10/26/10 tak
adding extra fields to localtemptrans, dtransactions, localtrans
12:24 pm lane18
1:00 pm lanes 1, 5, 9, 16
1:20 pm all remaining lanes
complete
10/27/10 atf
continued payment patch
9am lanes 3,4
10/28/10 atf
continued payment patch
12pm lanes 1,2,18
10/29/10 atf
continued payment patch
8am lanes 5,6,9,16
complete
11/8/10 atf
MercuryPaymentHandler
increased minimum Mercury timeout to avoid dupes
8:30am lanes 1,7,8
2:10pm lanes 2,3,4,5
3:30pm lanes 6,9,16,18
complete
11/15/10 atf
HTTP, MercuryPaymentHandler, PaymentModule
HTTP tweak to try to avoid receive timeout errors
8:20am lanes 1,7,8
11/16/10 atf
continued
8:20am lanes 2,3,4
11/17/10 atf
continued
8:30am lanes 16,18
11:15am lanes 5,6,9
complete
11/22/10 atf
MercuryPaymentHandler
tiny bugfix to switch preferred server on error
8:45am lanes 1,7,8
9:20am lane 5
11:30am lanes 2,3,4
1:50pm lanes 6,9,16,18
complete
12/6/10 atf
33 files
gift membership support; reduce parent-frame refreshes (to keep scale frame available);
fix duplicate dept limit warning on refunds; support possible failure of setMember();
suppress incorret $0 bal from Mercury declines; fix suspend/void with wedgecard cashout;
support x{yTW} and use x, ignore y
8:50am lane 9
12/7/10 atf
8:30am lane 8
12:20pm lane 7
2:05pm lanes 1,18
12/8/10 atf
9am lanes 2,3
12/9/10 atf
8:30am lanes 4,5
1:15pm lanes 6,16
complete
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment