Retrogade
Advanced Member
- Joined
- March 18, 2025
- Messages
- 449
- Reaction score
- 9,656
- Points
- 93
- Thread Author
- #1
ROWS 200K
PART 1
INSERT INTO `commission_table` (`no`, `username`, `name`, `status`, `identity`, `invno`, `total`, `date`, `bonus`, `bonustype`, `bonusamount`, `introducer`, `market_total`, `vip_total`, `agent_total`, `marketpv`, `vippv`, `agentpv`, `buyer_name`, `buyer_status`, `buyer_description`, `introducer_name`, `deleted`, `settled`, `customer_purchase`, `settledate`, `bonusamount_pv`, `adjustment`, `remarks`, `gm_contribute_username`, `um_contribute_username`, `user_locale`, `first_time_sales`, `performance`
VALUES (31615,'TeeLucy','','Unit Manager','Sponsor','CS00000675',685.1,'2015-03-14',0.08,'Coaching Bonus',54.808,'LeeKimYaw',1054,895.9,685.1,NULL,NULL,NULL,'KherSiewChin','Agent','Kher Siew Chin (Amy)','Kiat Nyet Lan (Judy) 闕月蘭',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31616,'LeeKimYaw','','Group Manager','Sponsor','CS00000675',685.1,'2015-03-14',0.05,'Coaching Bonus',34.255,'',1054,895.9,685.1,NULL,NULL,NULL,'KherSiewChin','Agent','Kher Siew Chin (Amy)','Kiat Nyet Lan (Judy) 闕月蘭',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31617,'TienPeiLian','','VIP','Buyer','CS00000676',200.6,'2015-03-14',0,'',0,'PhangWeiChien',236,200.6,153.4,NULL,NULL,NULL,'TienPeiLian','VIP','Tien Pei Lian 田佩莲','Yvonne Phang Wei Chien 彭薇倩',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31618,'PhangWeiChien','','Agent','Sponsor','CS00000676',200.6,'2015-03-14',0,'Price Gap',47.2,'LingNgokHwa',236,200.6,153.4,NULL,NULL,NULL,'TienPeiLian','VIP','Tien Pei Lian 田佩莲','Yvonne Phang Wei Chien 彭薇倩',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',0,0),(31619,'LingNgokHwa','','Unit Manager','Sponsor','CS00000676',200.6,'2015-03-14',0.08,'Coaching Bonus',12.272,'SherylLee',236,200.6,153.4,NULL,NULL,NULL,'TienPeiLian','VIP','Tien Pei Lian 田佩莲','Yvonne Phang Wei Chien 彭薇倩',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31620,'SherylLee','','Agent','Sponsor','CS00000676',200.6,'2015-03-14',0,'',0,'TeeLucy',236,200.6,153.4,NULL,NULL,NULL,'TienPeiLian','VIP','Tien Pei Lian 田佩莲','Yvonne Phang Wei Chien 彭薇倩',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31621,'TeeLucy','','Unit Manager','Sponsor','CS00000676',200.6,'2015-03-14',0.03,'Completion Bonus',4.602,'LeeKimYaw',236,200.6,153.4,NULL,NULL,NULL,'TienPeiLian','VIP','Tien Pei Lian 田佩莲','Yvonne Phang Wei Chien 彭薇倩',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31622,'LeeKimYaw','','Group Manager','Sponsor','CS00000676',200.6,'2015-03-14',0.02,'Coaching Bonus',3.068,'',236,200.6,153.4,NULL,NULL,NULL,'TienPeiLian','VIP','Tien Pei Lian 田佩莲','Yvonne Phang Wei Chien 彭薇倩',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31631,'LingNgokHwa','','Unit Manager','Buyer','CS00000677',518.7,'2015-03-14',0,'',0,'SherylLee',798,678.3,518.7,NULL,NULL,NULL,'LingNgokHwa','Unit Manager','Ling Ngok Hwa (May) 林月花','Sheryl Lee Sing Yield 李心仪 ',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31632,'SherylLee','','Agent','Sponsor','CS00000677',518.7,'2015-03-14',0.08,'Direct Agent Price',41.496,'TeeLucy',798,678.3,518.7,NULL,NULL,NULL,'LingNgokHwa','Unit Manager','Ling Ngok Hwa (May) 林月花','Sheryl Lee Sing Yield 李心仪 ',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',0,0),(31633,'TeeLucy','','Unit Manager','Sponsor','CS00000677',518.7,'2015-03-14',0.03,'Completion Bonus',15.561,'LeeKimYaw',798,678.3,518.7,NULL,NULL,NULL,'LingNgokHwa','Unit Manager','Ling Ngok Hwa (May) 林月花','Sheryl Lee Sing Yield 李心仪 ',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31634,'LeeKimYaw','','Group Manager','Sponsor','CS00000677',518.7,'2015-03-14',0.02,'Coaching Bonus',10.374,'',798,678.3,518.7,NULL,NULL,NULL,'LingNgokHwa','Unit Manager','Ling Ngok Hwa (May) 林月花','Sheryl Lee Sing Yield 李心仪 ',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31640,'PhangWeiChien','','Agent','Buyer','CS00000678',320.5,'2015-03-14',0,'',0,'LingNgokHwa',493,419.1,320.5,NULL,NULL,NULL,'PhangWeiChien','Agent','Yvonne Phang Wei Chien 彭薇倩','Ling Ngok Hwa (May) 林月花',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31641,'LingNgokHwa','','Unit Manager','Sponsor','CS00000678',320.5,'2015-03-14',0.08,'Coaching Bonus',25.64,'SherylLee',493,419.1,320.5,NULL,NULL,NULL,'PhangWeiChien','Agent','Yvonne Phang Wei Chien 彭薇倩','Ling Ngok Hwa (May) 林月花',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',0,0),(31642,'SherylLee','','Agent','Sponsor','CS00000678',320.5,'2015-03-14',0,'',0,'TeeLucy',493,419.1,320.5,NULL,NULL,NULL,'PhangWeiChien','Agent','Yvonne Phang Wei Chien 彭薇倩','Ling Ngok Hwa (May) 林月花',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31643,'TeeLucy','','Unit Manager','Sponsor','CS00000678',320.5,'2015-03-14',0.03,'Completion Bonus',9.615,'LeeKimYaw',493,419.1,320.5,NULL,NULL,NULL,'PhangWeiChien','Agent','Yvonne Phang Wei Chien 彭薇倩','Ling Ngok Hwa (May) 林月花',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31644,'LeeKimYaw','','Group Manager','Sponsor','CS00000678',320.5,'2015-03-14',0.02,'Coaching Bonus',6.41,'',493,419.1,320.5,NULL,NULL,NULL,'PhangWeiChien','Agent','Yvonne Phang Wei Chien 彭薇倩','Ling Ngok Hwa (May) 林月花',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31645,'KiatNyetLan','','Agent','Buyer','CS00000673',1006.2,'2015-03-14',0,'',0,'TiongSioGing',1548,1315.8,1006.2,NULL,NULL,NULL,'KiatNyetLan','Agent','Kiat Nyet Lan (Judy) 闕月蘭','Tiong Sio Ging (Angie)',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31646,'TiongSioGing','','Agent','Sponsor','CS00000673',1006.2,'2015-03-14',0.08,'Completion Bonus',80.496,'LeeKimKwong',1548,1315.8,1006.2,NULL,NULL,NULL,'KiatNyetLan','Agent','Kiat Nyet Lan (Judy) 闕月蘭','Tiong Sio Ging (Angie)',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',0,0),(31647,'LeeKimKwong','','Agent','Sponsor','CS00000673',1006.2,'2015-03-14',0,'',0,'LeeKimFuang',1548,1315.8,1006.2,NULL,NULL,NULL,'KiatNyetLan','Agent','Kiat Nyet Lan (Judy) 闕月蘭','Tiong Sio Ging (Angie)',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31648,'LeeKimFuang','','Agent','Sponsor','CS00000673',1006.2,'2015-03-14',0,'',0,'JosiahLee',1548,1315.8,1006.2,NULL,NULL,NULL,'KiatNyetLan','Agent','Kiat Nyet Lan (Judy) 闕月蘭','Tiong Sio Ging (Angie)',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31649,'JosiahLee','','Agent','Sponsor','CS00000673',1006.2,'2015-03-14',0,'',0,'TeeLucy',1548,1315.8,1006.2,NULL,NULL,NULL,'KiatNyetLan','Agent','Kiat Nyet Lan (Judy) 闕月蘭','Tiong Sio Ging (Angie)',0,1,0,'2015-03-14 00:00:00',0,NULL,NULL,NULL,NULL,'master_panel',NULL,0),(31650,'TeeLucy','','Unit Manager','Sponsor','CS00000673',1006.2,'2015-03-14',0.08,'Coaching Bonus',80.496,'LeeKimYaw',1548,1315.8,1006.2,NULL,NULL,NULL,'KiatNyetLan','Agent','Kiat Nyet Lan (Judy) 闕月蘭','Tiong Sio Gin
INSERT INTO `sales` (`no`, `invno`, `date`, `refno`, `buyer_identity`, `buyer_username`, `buyer_name`, `product_name`, `product_remark`, `product_no`, `product_code`, `product_um`, `qty`, `unitprice`, `marketprice`, `vipprice`, `agentprice`, `stotal`, `sub_total`, `total`, `discountedprice`, `currency`, `amount_paid`, `category`, `package`, `discount`, `remark`, `discount_type`, `discount_value`, `cost`, `hiddencost`, `shippingfee`, `paid`, `tranid`, `buyer_address`, `buyer_address2`, `buyer_postcode`, `buyer_city`, `buyer_state`, `buyer_country`, `buyer_email`, `buyer_code`, `buyer_contactno`, `trackingno`, `status`, `senddate`, `attn`, `cashier`, `cashiername`, `deleted`, `requestdelete`, `delete_remark`, `createddate`, `createby`, `online`, `sales_remark`, `agent`, `agent_name`, `method`, `last_edit_by`, `last_edit_date`, `sponsor`, `sponsor2`, `rounding`, `exchange`, `sponsor_level`, `sponsor2_level`, `servicer_username`, `servicer_level`, `stotalwithoutgst`, `gstp`, `stwithoutgst`, `stockist_no`, `printcount`, `printcountby`, `printcountdate`, `gsttaxid`, `identity_bill`, `created_by_userno`, `total_wht_gst`, `vippv`, `agentpv`, `marketpv`, `gstamount`, `rebated`, `deleted_user`, `deleted_date`, `buyer_locale`, `upgrade_to_level`, `payment_receive_user`, `payment_receive_date`, `unsettled`)
Chin (Amy)','Master AB Energetic Cleaner <抗菌活力全效洗剂 2kg>','',301,'CA0006','','7',73,73,62.1,47.5,511,881,572.65,'','MYR',572.65,'',0,'35','','','',0,0,'',1,'TID1412080000047','47, Jalan NB2 8/1,','Taman Nusa Bestari, ','81300','Skudai ','Skudai ','Malaysia ','','670928015406','+60167228030','',0,'0000-00-00 00:00:00','','','',0,0,'','2014-05-24 00:00:00','masterab',0,'','masterab','Lee Kim Yaw 李锦耀','Cash','','0000-00-00 00:00:00','KiatNyetLan','TiongSioGing','',0,'Agent','Agent','','',NULL,NULL,NULL,175,2,'KhooWoonChuan','2015-07-16 11:56:59',NULL,'HQ',9,NULL,0,0,0,NULL,'',NULL,NULL,'master_panel',NULL,'masterab','2014-05-24 00:00:00',0),(62,'CS00000046','2014-05-24 00:00:00','CS00000184','','KherSiewChin','Kher Siew Chin (Amy)','Master AB Spirulina (in sachets) <螺旋藻(粉)>','',299,'FA0106 ','','1',270,270,229.5,175.5,270,881,572.65,'','MYR',572.65,'',0,'35','','','',0,0,'',1,'TID1412080000047','47, Jalan NB2 8/1,','Taman Nusa Bestari, ','81300','Skudai ','Skudai ','Malaysia ','','670928015406','+60167228030','',0,'0000-00-00 00:00:00','','','',0,0,'','2014-05-24 00:00:00','masterab',0,'','masterab','Lee Kim Yaw 李锦耀','Cash','','0000-00-00 00:00:00','KiatNyetLan','TiongSioGing','',0,'Agent','Agent','','',NULL,NULL,NULL,175,2,'KhooWoonChuan','2015-07-16 11:56:59',NULL,'HQ',9,NULL,0,0,0,NULL,'',NULL,NULL,'master_panel',NULL,'masterab','2014-05-24 00:00:00',0),(63,'CS00000046','2014-05-24 00:00:00','CS00000184','','KherSiewChin','Kher Siew Chin (Amy)','Insect Repellent <防蚊蟲噴劑>','',224,'FG0800 ','','2',50,50,42.5,33,100,881,572.65,'','MYR',572.65,'',0,'35','','','',0,0,'',1,'TID1412080000047','47, Jalan NB2 8/1,','Taman Nusa Bestari, ','81300','Skudai ','Skudai ','Malaysia ','','670928015406','+60167228030','',0,'0000-00-00 00:00:00','','','',0,0,'','2014-05-24 00:00:00','masterab',0,'','masterab','Lee Kim Yaw 李锦耀','Cash','','0000-00-00 00:00:00','KiatNyetLan','TiongSioGing','',0,'Agent','Agent','','',NULL,NULL,NULL,175,2,'KhooWoonChuan','2015-07-16 11:56:59',NULL,'HQ',9,NULL,0,0,0,NULL,'',NULL,NULL,'master_panel',NULL,'masterab','2014-05-24 00:00:00',0),(64,'CS00000047','2014-05-28 00:00:00','CS00000185','','KherSiewChin','Kher Siew Chin (Amy)','Kapros (Capros Facial Cleansing Cream) < Kapros 凯普乐斯焕采极致洗脸霜 >','',305,'FA0104','','1',140,140,119,91,140,140,91,'','MYR',91,'',0,'35','','','',0,0,'',1,'TID1412080000048','47, Jalan NB2 8/1,','Taman Nusa Bestari, ','81300','Skudai ','Skudai ','Malaysia ','','670928015406','+60167228030','',0,
To see this hidden content, you need to "Reply & React" with one of the following reactions: