þþ °d˜9ÿCCÿÿÿÿÿÿÿÿT6œC&”=  $(,048<@HLPÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ^«ÿÿÿ^«ÿ e e1 8 ?@H?Pçhkld¢hÏÐÈ›H?Pdhkld6hÏÐÈ›hkl@dhkl€dlhkldÑH?PæH ?P hkldèH ?Peh @ÿQhkldthkld¢hÏÐÈÙeeÉe e@e€eeÉ @€ee @eÉ€eeeeee e@e€eee @€      @ €      à¬l€Œ„H  Ü ¬ x H   ÜÜÈ xDȘd0ÌXœ !Ð"Œ#H$ %ì&'à( ¼)!€*"D+#,#Ü-$¬.%Œ/&\0'(1'ð2(¸3)|4*85*ø6+¬7,d8-09-ì:.¨;/d<0$=1>1Ø?2œ@3`A4,B4ôC5Äded_db; END IF; #retreived #call debugme("voiding",CONCAT("Old Void Flag: ", old_void_flag, "NEW VOID FLAG: ", new_void_flag)); #check for new void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 THà¬l€Œ„Hܬ x H   ÜÜ xDȘd0ÌœXÐŒH ìà ¼!€"D##Ü$¬%Œ&\'('ð(¸)|*8*ø+¬,d-0-ì.¨/d0$11Ø2œ3`4,4ô5ÄeÈed into old_voided_db from tillinvoices where id = new.id; #deal with nulls IF old_voided_db >0 THEN SET old_void_flag = old_voided_db; END IF; #retreived #call debugme("voiding",CONCAT("Old Void Flag: ", old_void_flag, "NEW VOID FLAG: ", new_void_flag)); #check for new void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 THá)|*8ø+¬BmakkaÌ CASH SALESœXÐŒHìà ¼!€"D#Ü$¬%Œ&\'(ðcrlimit4ôdiscount5ÄdsdsdsGermany(¸GOLF CLUB MEMBER  guesthouseÜLCdN/A n/a0NO GROUPà„ HÈxDȘOffice ¬ POS - MALE,d-0ì.¨/d1Ø2œ4, POS - VIP0$Realy Long Group DescriptionHShelley1  take awayl€Œ ÜÜTEST3` the hotelububele¬ x SET new_void_flag = NEW.VOIDED; END IF; SELECT voided into old_voided_db from tillinvoices where id = new.id; #deal with nulls IF old_voided_db >0 THEN SET old_void_flag = old_voided_db; END IF; #retreived #call debugme("voiding",CONCAT("Old Void Flag: ", old_void_flag, "NEW VOID FLAG: ", new_void_flag)); #check for new void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 TH40101011 0901220946232 x 87 H 7253 8137È 50314x 90 482˜ 5740 1014à 69d12233D345)|1315 13151315 1609¬160916090$166152œ 2001191422402$¬261233587%Œ 4553&\ 43470'( 4064'ð3171136057(¸6011532057à70613475093`1120120065244ô 452335Ä901221804539Ü 12497 596Ü 3234 Ü 326È 401 61113370Ì20315534193261450073X 501577œ 84ÐŒ71245157H5250952223 6300934473ì 65451715590 ¼ 8348!€7091651259"D 327# 6254#Ü3¬4l5€54321*86Œ7„76777674,77-ì777+¬8H80801Ø888-0990/d9.¨999,dADEL*ø void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 TH ¬„H)|*8*ø+¬,d-0-ì.¨/d1Ø2œ4,àl€ŒÜ¬ x H   ÜÜÈ xDȘd0ÌœXÐŒH ìà ¼!€"D##Ü$¬%Œ&\'('ð(¸0$13`4ô5Ä SELECT voided into old_voided_db from tillinvoices where id = new.id; #deal with nulls IF old_voided_db >0 THEN SET old_void_flag = old_voided_db; END IF; #retreived #call debugme("voiding",CONCAT("Old Void Flag: ", old_void_flag, "NEW VOID FLAG: ", new_void_flag)); #check for new void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 THÔd0ÌœXÐŒH ìà ¼!€"D#Ü$¬%Œ&\'(ð(¸)|*8ø+¬,d-0ì.¨/d0$1Ø2œ3`4,ô5Ä1଄Hܬ x H3l€Œ  ÜÜ4È xDȘflag_isrefund = flag_isrefund_db; END IF; #call debugme("flag_isrefund",flag_isrefund); #call debugme("flag_isrefund_db",flag_isrefund_db); #retreive old and new void stage SET old_void_flag = 0; SET new_void_flag = 0; #deal with nulls IF NEW.voided > 0 THEN SET new_void_flag = NEW.VOIDED; END IF; SELECT voided into old_voided_db from tillinvoices where id = new.id; #deal with nulls IF old_voided_db >0 THEN SET old_void_flag = old_voided_db; END IF; #retreived #call debugme("voiding",CONCAT("Old Void Flag: ", old_void_flag, "NEW VOID FLAG: ", new_void_flag)); #check for new void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 TH40101011 0901220946232 x 87 H 7253 8137È 50314x 90 482˜ 5740 1014à 69d12233D345)|1315 13151315 1609¬160916090$166152œ 2001191422402$¬261233587%Œ 4553&\ 43470'( 4064'ð3171136057(¸6011532057à70613475093`1120120065244ô 452335Ä901221804539Ü 12497 596Ü 3234 Ü 326È 401 61113370Ì20315534193261450073X 501577œ 84ÐŒ71245157H5250952223 6300934473ì 65451715590 ¼ 8348!€7091651259"D 327# 6254#Ü3¬4l5€54321*86Œ7„76777674,77-ì777+¬8H80801Ø888-0990/d9.¨999,dADEL*ø void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 THɬ„H)|*8ø+¬,d-0ì.¨/d1Ø2œ4,àl€ŒÜ¬ x H  ÜÜÈ xDȘd0ÌœXÐŒH ìà ¼!€"D#Ü$¬%Œ&\'(ð(¸0$13`4ô5Ä THEN SET flag_isrefund = flag_isrefund_db; END IF; #call debugme("flag_isrefund",flag_isrefund); #call debugme("flag_isrefund_db",flag_isrefund_db); #retreive old and new void stage SET old_void_flag = 0; SET new_void_flag = 0; #deal with nulls IF NEW.voided > 0 THEN SET new_void_flag = NEW.VOIDED; END IF; SELECT voided into old_voided_db from tillinvoices where id = new.id; #deal with nulls IF old_voided_db >0 THEN SET old_void_flag = old_voided_db; END IF; #retreived #call debugme("voiding",CONCAT("Old Void Flag: ", old_void_flag, "NEW VOID FLAG: ", new_void_flag)); #check for new void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 TH଀„Hܬ x H ÜÈ xDȘd0ÌœXÐŒH ìà ¼!€$¬%Œ&\'(ð(¸*ø-0ì.¨/d0$1Ø2œ3`4,ô5Ä 0219139142lŒ 082721233 Ü 0836305115 12345)|892389*8GGG"D # Üphone,dtel+¬lag_isrefund); #call debugme("flag_isrefund_db",flag_isrefund_db); #retreive old and new void stage SET old_void_flag = 0; SET new_void_flag = 0; #deal with nulls IF NEW.voided > 0 THEN SET new_void_flag = NEW.VOIDED; END IF; SELECT voided into old_voided_db from tillinvoices where id = new.id; #deal with nulls IF old_voided_db >0 THEN SET old_void_flag = old_voided_db; END IF; #retreived #call debugme("voiding",CONCAT("Old Void Flag: ", old_void_flag, "NEW VOID FLAG: ", new_void_flag)); #check for new void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 TH )|*8ø+¬,d-0ì.¨/d1Ø2œ4,଄Hܬ x H ÜÈ xDȘd0ÌœXÐŒH ìà ¼!€"D#Ü$¬%Œ&\'(ð(¸0$13`4ô5Ä 0219139142Œ 082721233 Ü 0835995955l6309192 60681€gme("flag_isrefund",flag_isrefund); #call debugme("flag_isrefund_db",flag_isrefund_db); #retreive old and new void stage SET old_void_flag = 0; SET new_void_flag = 0; #deal with nulls IF NEW.voided > 0 THEN SET new_void_flag = NEW.VOIDED; END IF; SELECT voided into old_voided_db from tillinvoices where id = new.id; #deal with nulls IF old_voided_db >0 THEN SET old_void_flag = old_voided_db; END IF; #retreived #call debugme("voiding",CONCAT("Old Void Flag: ", old_void_flag, "NEW VOID FLAG: ", new_void_flag)); #check for new void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 THœXÐŒà¬l€Œ„ܬ x H   ÜÜÈ xDȘd0ÌH ìà ¼!€"D##Ü$¬%Œ&\'('ð(¸)|*8*ø+¬,d-0-ì.¨/d0$11Ø2œ3`4,4ô5ÄHd into old_voided_db from tillinvoices where id = new.id; #deal with nulls IF old_voided_db >0 THEN SET old_void_flag = old_voided_db; END IF; #retreived #call debugme("voiding",CONCAT("Old Void Flag: ", old_void_flag, "NEW VOID FLAG: ", new_void_flag)); #check for new void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 THß)|&\'('ð  à ¬ l € Œ „ H  Ü ¬ x H   Ü  Ü È   x D  È ˜ d 0  Ì œ X  Ð Œ H   ì  à ¼ !€ "D # #Ü $¬ %Œ (¸ *8 *ø +¬ ,d -0 -ì .¨ /d 0$ 1 1Ø 2œ 3` 4, 4ô 5Ä"Old Void Flag: ", old_void_flag, "NEW VOID FLAG: ", new_void_flag)); #check for new void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 TH¾¬„H)|*8ø+¬àl€ŒÜ¬ x HÜÈ xDȘdÌœXÐŒ (¸-0ì.¨/d0$1Ø2œ3`4,ô5Ä101 ¼2!€12121'( 1212121212&\ 12121212121%Œ1212122'ð123  123121212121ì123412345 Ü 123456789H8928912  2221111222 580317511408307505256657181à9161370187$¬GGGG"DGGGG66#GGGG66H#Üidnum,dwith nulls IF NEW.voided > 0 THEN SET new_void_flag = NEW.VOIDED; END IF; SELECT voided into old_voided_db from tillinvoices where id = new.id; #deal with nulls IF old_voided_db >0 THEN SET old_void_flag = old_voided_db; END IF; #retreived #call debugme("voiding",CONCAT("Old Void Flag: ", old_void_flag, "NEW VOID FLAG: ", new_void_flag)); #check for new void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 THóà¬l€Œ„Hܬ x H  ÜÜd0ÌœXÐŒH ìà ¼!€"D##Ü$¬%Œ&\'('ð(¸)|*8*ø+¬,d-0-ì.¨/d0$11Ø2œ3`4,4ô5Ä xDÈ˜È = NEW.VOIDED; END IF; SELECT voided into old_voided_db from tillinvoices where id = new.id; #deal with nulls IF old_voided_db >0 THEN SET old_void_flag = old_voided_db; END IF; #retreived #call debugme("voiding",CONCAT("Old Void Flag: ", old_void_flag, "NEW VOID FLAG: ", new_void_flag)); #check for new void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 THô¬l€Œ„HD)|*8ø+¬,d-0ì.¨/d0$1Ø2œ4,àܬ x H  ÜÜÈ xȘd0ÌœXÐŒH à ¼!€"D#Ü$¬%Œ&\'(ð(¸3`4ô5Ä%4150901245320016? 2906300934473ì; END IF; #call debugme("flag_isrefund",flag_isrefund); #call debugme("flag_isrefund_db",flag_isrefund_db); #retreive old and new void stage SET old_void_flag = 0; SET new_void_flag = 0; #deal with nulls IF NEW.voided > 0 THEN SET new_void_flag = NEW.VOIDED; END IF; SELECT voided into old_voided_db from tillinvoices where id = new.id; #deal with nulls IF old_voided_db >0 THEN SET old_void_flag = old_voided_db; END IF; #retreived #call debugme("voiding",CONCAT("Old Void Flag: ", old_void_flag, "NEW VOID FLAG: ", new_void_flag)); #check for new void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 THEN REPEAT FETCH cur1 INTO a, b; IF NOT done THEN update menu set stockonhand = stockonhand + b where id = a; END IF; UNTIL done END REPEAT; ELSE REPEAT FETCH cur1 INTO a, b; IF NOT done THEN update menu set stockonhand = stockonhand + b where id = a; END IF; UNTIL done END REPEAT; END IF; CLOSE cur1; #stock on hand delt END IF; #delt with stock #deal with accounts IF NEW.ACCOUNT != 0 THEN SET account_amount = abs(NEW.ACCOUNT); SELECT date INTO debtor_date from dcash where f_status < 100 order by date desc limit 1; IF NEW.ACCOUNT > 0 THEN INSERT INTO accounts (account,entityid,credit,description,document,stamp,date) values (1, NEW.client_id,account_amount,"VOID",CONCAT('POS DOC# ', NEW.ID),current_timestamp,debtor_date); ELSE INSERT INTO accounts (account,entityid,debit,description,document,stamp,date) values (1, NEW.client_id,account_amount,"VOID",CONCAT('POS DOC# ', NEW.ID),‚01010111ì11¬2 x12345)|13 H1315 13151315 16 Ü160916090$166152œ178Ü9È2à20 1x2D2222234È5˜6d708Ì93¬30X1œ23ÐŒ5H6 89à40 ¼1!€2"D3#4#Ü5$¬6%Œ7&\8'(9'ð5€50(¸54321*86Œ643`64ô75Ä7„76777674,77-ì777+¬8H80801Ø888-0990/d9.¨999,dADEL*øBH123lL10ÜN SET old_void_flag = old_voided_db; END IF; #retreived #call debugme("voiding",CONCAT("Old Void Flag: ", old_void_flag, "NEW VOID FLAG: ", new_void_flag)); #check for new void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 THá)|*8ø+¬BmakkaÌ CASH SALESœXÐŒHìà ¼!€"D#Ü$¬%Œ&\'(ðcrlimit4ôdiscount5ÄdsdsdsGermany(¸GOLF CLUB MEMBER  guesthouseÜLCdN/A n/a0NO GROUPà„ HÈxDȘOffice ¬ POS - MALE,d-0ì.¨/d1Ø2œ4, POS - VIP0$Realy Long Group DescriptionHShelley1  take awayl€Œ ÜÜTEST3` the hotelububele¬ x SET new_void_flag = NEW.VOIDED; END IF; SELECT voided into old_voided_db from tillinvoices where id = new.id; #deal with nulls IF old_voided_db >0 THEN SET old_void_flag = old_voided_db; END IF; #retreived #call debugme("voiding",CONCAT("Old Void Flag: ", old_void_flag, "NEW VOID FLAG: ", new_void_flag)); #check for new void IF old_void_flag = 0 AND (new_void_flag = 1 OR new_void_flag = 2) THEN #deal with stock IF new_void_flag = 1 THEN OPEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 TH¸œXÐŒ-0ì.¨/d2œ4,101 ¼2!€ 1212121212H12345)|1315 2222'( ð54321*8881Ø A.P. RADULOVADEL*øanatol4oŒANATOLI CLIENT0$Anatoli RadoulovàAnatoli Radulov ÜANDRE HansnsnsAnthony Baynes ANTONY BANDERAZà AP RADULOVÈ BIBI RADULOVAlBilyana Radoulov$¬ Bmakka KnoloÌ creditlimit4ôdiscountclient5Ä GABBY SMITHGermany(¸GGGG"D # Ü HOTEL ROOM 2Ü J C LE ROUXÈ JCL 1 NamedJJ¬Joe Soapì JOHAN LE ROUX johnÜ John Smith john smith1JOSMI%Œmico+¬ milo returnsminusone€name,dOosthuizen, Wessel0PETRORIKARDO GONZALEZ„ROOM 101 Test John3`tetete&\THERESA x WAYNE KEETING˜WESSELDWESSEL OOSTHUIZEN¬ WIMPI CLIENTx WM OOSTHUIZEN cur1; #deal with the stock on hand column IF flag_isrefund > 0 TH