Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\mango\ps\nouse\ps_sync_visit_credit - Copy.php on line 11

Warning: include() [function.include]: Failed opening '../function.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mango\ps\nouse\ps_sync_visit_credit - Copy.php on line 11
http://203.155.18.96/BCWEB_SERVICES/back/CREDIT_RouteJsonData.aspx?orderdate=20251215
2025-12-15<<<<<

12/15/2025||||||||||||||||12-15-2025 18:17:17 PM
Update c_cust_route set price_buy='3763.0',orderNo='681225030',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='NE111' and custNo='43180005' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 18:12:54 PM
Update c_cust_route set price_buy='9563.0',orderNo='681225029',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='NE111' and custNo='38180002' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 18:08:11 PM
Update c_cust_route set price_buy='10581.0',orderNo='681225028',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='NE111' and custNo='43210002' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 17:59:46 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681229027','2025-12-15 00:00:00','Y','37350.0','| บิล2:อ้างอิง:681229026:','20251215','1','2','2025-12-05' FROM c_cust_route WHERE custArea='NH101' and custNo='57000046' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 17:57:13 PM
Update c_cust_route set price_buy='38190.0',orderNo='681229026',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:',fv_date='2025-12-05' WHERE custArea='NH101' and custNo='57000046' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 17:56:42 PM
Update c_cust_route set price_buy='24227.0',orderNo='681225027',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล2:อ้างอิง:681225026:' WHERE custArea='NE111' and custNo='43140017' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 17:48:50 PM
Update c_cust_route set price_buy='15288.0',orderNo='681225026',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='NE111' and custNo='38150003' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 17:40:37 PM
Update c_cust_route set price_buy='2377.0',orderNo='681237028',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:' WHERE custArea='SH121' and custNo='94000066' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 17:39:17 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681237027','2025-12-15 00:00:00','Y','25740.0','ร้านค้าโทรสั่ง |','20251215','1','2' FROM c_cust_route WHERE custArea='SH121' and custNo='95000065' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 17:38:25 PM
Update c_cust_route set price_buy='41750.0',orderNo='681237026',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง |' WHERE custArea='SH121' and custNo='95000065' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 17:36:18 PM
Update c_cust_route set price_buy='5070.0',orderNo='681226023',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='NE112' and custNo='48000002' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 17:36:04 PM
Update c_cust_route set price_buy='22835.0',orderNo='681237025',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง |' WHERE custArea='SH121' and custNo='95000045' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 17:34:39 PM
Update c_cust_route set price_buy='8271.0',orderNo='681226022',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='NE112' and custNo='48000060' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 17:31:59 PM
Update c_cust_route set price_buy='5759.0',orderNo='681226021',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='NE112' and custNo='47170009' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 17:27:42 PM
Update c_cust_route set price_buy='6900.0',orderNo='681226020',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='NE112' and custNo='62120016' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 17:26:56 PM
Update c_cust_route set price_buy='4265.0',orderNo='681226019',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='NE112' and custNo='47290006' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 17:26:06 PM
Update c_cust_route set price_buy='10375.0',orderNo='681225025',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='NE111' and custNo='43210005' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 17:23:03 PM
Update c_cust_route set price_buy='4140.0',orderNo='681212046',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:' WHERE custArea='BE111' and custNo='10170099' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 17:13:39 PM
Update c_cust_route set price_buy='54060.0',orderNo='681228044',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|',fv_date='2025-12-06' WHERE custArea='NE131' and custNo='32180008' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 17:04:53 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681241012','2025-12-15 00:00:00','Y','77200.0','ร้านค้าโทรสั่ง | บิล4:','20251215','1','4','2025-12-06' FROM c_cust_route WHERE custArea='BE102' and custNo='20000001' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 16:56:11 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681224034','2025-12-15 00:00:00','Y','16740.0','ร้านค้าโทรสั่ง | บิล2:','20251215','1','2' FROM c_cust_route WHERE custArea='NE102' and custNo='34190021' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 16:54:55 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681235030','2025-12-15 00:00:00','Y','356900.0','ร้านค้าโทรสั่ง |','20251215','1','5' FROM c_cust_route WHERE custArea='SH102' and custNo='95000026' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 16:54:07 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681232045','2025-12-15 00:00:00','Y','1423.0','ร้านค้าโทรสั่ง | บิล13:สาขามหาโพธิ์','20251215','1','13' FROM c_cust_route WHERE custArea='NH121' and custNo='54000038' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 16:52:41 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681232044','2025-12-15 00:00:00','Y','1140.0','ร้านค้าโทรสั่ง | บิล12:สาขาลอง','20251215','1','12' FROM c_cust_route WHERE custArea='NH121' and custNo='54000038' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 16:51:00 PM
Update c_cust_route set price_buy='29139.0',orderNo='681232043',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | โทรหาลูกค้าก่อนส่งสินค้า' WHERE custArea='NH121' and custNo='55000014' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 16:49:39 PM
Update c_cust_route set price_buy='7643.0',orderNo='681232042',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | โทรหาลูกค้าก่อนส่งสินค้า' WHERE custArea='NH121' and custNo='55140013' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 16:47:47 PM
Update c_cust_route set price_buy='9855.0',orderNo='681232041',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | โทรหาลูกค้าก่อนส่งสินค้า' WHERE custArea='NH121' and custNo='55140005' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 16:46:04 PM
Update c_cust_route set price_buy='7789.0',orderNo='681232040',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | โทรหาลูกค้าก่อนส่งสินค้า' WHERE custArea='NH121' and custNo='55160008' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 16:44:10 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681211060','2025-12-15 00:00:00','Y','74700.0','ร้านค้าโทรสั่ง | บิล4:','20251215','1','4','2025-12-06' FROM c_cust_route WHERE custArea='BE101' and custNo='10270265' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 16:44:07 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681232039','2025-12-15 00:00:00','Y','21720.0','ร้านค้าโทรสั่ง | บิล2:อ้างอิง:681232038:โทรหาลูกค้าก่อนส่งสินค้า','20251215','1','2' FROM c_cust_route WHERE custArea='NH121' and custNo='55120003' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 16:43:26 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681211059','2025-12-15 00:00:00','Y','93210.0','ร้านค้าโทรสั่ง | บิล3:','20251215','1','3','2025-12-06' FROM c_cust_route WHERE custArea='BE101' and custNo='10270265' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 16:42:44 PM
Update c_cust_route set price_buy='30780.0',orderNo='681232038',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:โทรหาลูกค้าก่อนส่งสินค้า' WHERE custArea='NH121' and custNo='55120003' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 16:38:10 PM
Update c_cust_route set price_buy='2275.0',orderNo='681218049',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='CT121' and custNo='71160004' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 16:36:02 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681211058','2025-12-15 00:00:00','Y','24900.0','ร้านค้าโทรสั่ง | บิล2:ด่วน','20251215','1','2','2025-12-06' FROM c_cust_route WHERE custArea='BE101' and custNo='10160297' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 16:35:14 PM
Update c_cust_route set price_buy='39946.0',orderNo='681211057',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:ด่วน',fv_date='2025-12-06' WHERE custArea='BE101' and custNo='10310003' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 16:28:25 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681216024','2025-12-15 00:00:00','Y','21900.0','ร้านค้าโทรสั่ง | บิล1:','20251215','1','3' FROM c_cust_route WHERE custArea='CT102' and custNo='74120029' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 16:26:50 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681216023','2025-12-15 00:00:00','Y','64000.0','ร้านค้าโทรสั่ง | บิล2:อ้างอิง:681216022:','20251215','1','2' FROM c_cust_route WHERE custArea='CT102' and custNo='74120029' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 16:25:52 PM
Update c_cust_route set price_buy='64000.0',orderNo='681216022',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:' WHERE custArea='CT102' and custNo='74120029' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 16:18:56 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681235029','2025-12-15 00:00:00','Y','90133.0','ร้านค้าโทรสั่ง |','20251215','1','4' FROM c_cust_route WHERE custArea='SH102' and custNo='95000026' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 16:09:26 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681235028','2025-12-15 00:00:00','Y','129120.0','|','20251215','1','3' FROM c_cust_route WHERE custArea='SH102' and custNo='95000026' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 16:07:26 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681235027','2025-12-15 00:00:00','Y','671420.0','|','20251215','1','2' FROM c_cust_route WHERE custArea='SH102' and custNo='95000026' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 15:38:06 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681234020','2025-12-15 00:00:00','Y','33930.0','| บิล1:ส่งด่วน','20251215','1','2' FROM c_cust_route WHERE custArea='SH101' and custNo='84000057' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 15:34:04 PM
Update c_cust_route set price_buy='40592.0',orderNo='681234019',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| ส่งด่วน' WHERE custArea='SH101' and custNo='86000023' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 15:28:32 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681218048','2025-12-15 00:00:00','Y','65325.0','| บิล2:อ้างอิง:681218003:','20251215','1','2' FROM c_cust_route WHERE custArea='CT121' and custNo='70000068' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 15:25:04 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681218047','2025-12-15 00:00:00','Y','7305.0','|','20251215','1','3' FROM c_cust_route WHERE custArea='CT121' and custNo='71000067' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 15:24:09 PM
Update c_cust_route set price_buy='6408.0',orderNo='681218046',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='CT121' and custNo='75000049' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 15:22:48 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681218045','2025-12-15 00:00:00','Y','9010.0','| บิล3:','20251215','1','3' FROM c_cust_route WHERE custArea='CT121' and custNo='75000043' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 15:21:55 PM
Update c_cust_route set price_buy='74700.0',orderNo='681218044',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='CT121' and custNo='70000050' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 15:09:21 PM
Update c_cust_route set price_buy='788.0',orderNo='681217059',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='CT111' and custNo='24190002' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 14:59:59 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681217058','2025-12-15 00:00:00','Y','12911.0','ร้านค้าโทรสั่ง |','20251215','1','2' FROM c_cust_route WHERE custArea='CT111' and custNo='24120014' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 14:53:30 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681217057','2025-12-15 00:00:00','Y','8123.0','ร้านค้าโทรสั่ง | บิล4:','20251215','1','4' FROM c_cust_route WHERE custArea='CT111' and custNo='24000038' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 14:38:42 PM
Update c_cust_route set price_buy='24900.0',orderNo='681236072',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='SH111' and custNo='81000059' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 14:25:45 PM
Update c_cust_route set price_buy='14358.0',orderNo='681240047',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='NS121' and custNo='13240002' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 14:12:16 PM
Update c_cust_route set price_buy='24900.0',orderNo='681229025',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|',fv_date='2025-12-05' WHERE custArea='NH101' and custNo='57130010' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 14:11:22 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681229024','2025-12-15 00:00:00','Y','124500.0','|','20251215','1','4','2025-12-05' FROM c_cust_route WHERE custArea='NH101' and custNo='57130027' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 13:47:42 PM
Update c_cust_route set price_buy='27000.0',orderNo='681236071',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='SH111' and custNo='85000051' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 13:41:01 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681212045','2025-12-15 00:00:00','Y','1520.0','ร้านค้าโทรสั่ง | บิล2:ด่วน','20251215','1','2' FROM c_cust_route WHERE custArea='BE111' and custNo='10500021' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 13:35:54 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681212044','2025-12-15 00:00:00','Y','18020.0','ร้านค้าโทรสั่ง | บิล4:ด่วน','20251215','1','3' FROM c_cust_route WHERE custArea='BE111' and custNo='10700126' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 13:22:51 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681228043','2025-12-15 00:00:00','Y','25228.0','| บิล2:อ้างอิง:681228042:','20251215','1','2','2025-12-06' FROM c_cust_route WHERE custArea='NE131' and custNo='32000039' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 13:21:01 PM
Update c_cust_route set price_buy='23272.0',orderNo='681228042',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:',fv_date='2025-12-06' WHERE custArea='NE131' and custNo='32000039' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 13:06:13 PM
Update c_cust_route set price_buy='7404.0',orderNo='681236070',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='SH111' and custNo='86000054' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 12:59:10 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681231047','2025-12-15 00:00:00','Y','18576.0','ร้านค้าโทรสั่ง | บิล2:','20251215','1','2' FROM c_cust_route WHERE custArea='NH111' and custNo='50210020' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 12:56:55 PM
Update c_cust_route set price_buy='12123.0',orderNo='681231046',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='NH111' and custNo='58000013' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 12:25:54 PM
Update c_cust_route set price_buy='43062.0',orderNo='681236069',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='SH111' and custNo='81000008' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 11:42:41 AM
Update c_cust_route set price_buy='12450.0',orderNo='681212043',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:' WHERE custArea='BE111' and custNo='10160294' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 11:36:20 AM
Update c_cust_route set price_buy='24900.0',orderNo='681217056',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='CT111' and custNo='12110065' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 11:35:17 AM
Update c_cust_route set price_buy='2490.0',orderNo='681231045',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='NH111' and custNo='58000011' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 11:34:36 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681231044','2025-12-15 00:00:00','Y','5911.0','ร้านค้าโทรสั่ง | บิล2:','20251215','1','2' FROM c_cust_route WHERE custArea='NH111' and custNo='50300010' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 11:32:52 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681211056','2025-12-15 00:00:00','Y','9264.0','ร้านค้าโทรสั่ง | บิล7:','20251215','1','7','2025-12-06' FROM c_cust_route WHERE custArea='BE101' and custNo='10120183' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 11:32:12 AM
Update c_cust_route set price_buy='2320.0',orderNo='681231043',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='NH111' and custNo='58000008' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 11:31:49 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681211055','2025-12-15 00:00:00','Y','4632.0','ร้านค้าโทรสั่ง | บิล6:','20251215','1','6','2025-12-06' FROM c_cust_route WHERE custArea='BE101' and custNo='10120183' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 11:17:58 AM
Update c_cust_route set price_buy='49800.0',orderNo='681227033',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | ส่งด่วนแบ่งส่งได้' WHERE custArea='NE121' and custNo='40000120' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 10:59:56 AM
Update c_cust_route set price_buy='5763.0',orderNo='681212042',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='BE111' and custNo='10150115' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 10:51:55 AM
Update c_cust_route set price_buy='23815.0',orderNo='681217055',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='CT111' and custNo='24120016' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 10:39:04 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681227032','2025-12-15 00:00:00','Y','47136.0','ร้านค้าโทรสั่ง | ส่งด่วน','20251215','1','2' FROM c_cust_route WHERE custArea='NE121' and custNo='46150013' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 10:38:54 AM
Update c_cust_route set price_buy='18325.0',orderNo='681236068',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='SH111' and custNo='80110006' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 10:36:51 AM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NE121' and custNo='46210002' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 10:35:57 AM
Update c_cust_route set price_buy='1428.0',orderNo='681236067',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='SH111' and custNo='81110013' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 10:30:27 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681211054','2025-12-15 00:00:00','Y','16730.0','ร้านค้าโทรสั่ง | บิล2:อ้างอิง:681211053:','20251215','1','4','2025-12-06' FROM c_cust_route WHERE custArea='BE101' and custNo='10270242' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 10:29:56 AM
Update c_cust_route set price_buy='280726.0',orderNo='681231042',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='NH111' and custNo='58000005' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 10:26:55 AM
Update c_cust_route set price_buy='13800.0',orderNo='681240046',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='|' WHERE custArea='NS121' and custNo='13210009' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 10:25:49 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681211053','2025-12-15 00:00:00','Y','18870.0','| บิล1:','20251215','1','3','2025-12-06' FROM c_cust_route WHERE custArea='BE101' and custNo='10270242' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 10:21:39 AM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NS121' and custNo='13170002' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 10:21:16 AM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NS121' and custNo='13000035' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 10:03:56 AM
Update c_cust_route set price_buy='570.0',orderNo='681236066',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='SH111' and custNo='81000031' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 09:39:39 AM
Update c_cust_route set price_buy='137972.0',orderNo='681227031',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:ส่งด่วน' WHERE custArea='NE121' and custNo='44160013' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 09:28:27 AM
Update c_cust_route set price_buy='2410.0',orderNo='681231041',visit_date='2025-12-15 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='NH111' and custNo='50000033' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 09:25:31 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'681231040','2025-12-15 00:00:00','Y','4980.0','| บิล3:','20251215','1','3' FROM c_cust_route WHERE custArea='NH111' and custNo='58000002' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 08:30:18 AM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NE121' and custNo='45000042' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 08:29:56 AM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NE121' and custNo='45000061' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 08:20:39 AM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NE121' and custNo='45170003' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 08:20:33 AM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NE121' and custNo='45000055' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 04:43:14 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ - |' WHERE custArea='NS121' and custNo='13230023' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 04:43:03 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ - |' WHERE custArea='NS121' and custNo='13230021' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 04:42:47 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NS121' and custNo='13110014' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 04:42:20 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ - |' WHERE custArea='NS121' and custNo='13110019' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 04:42:09 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ - |' WHERE custArea='NS121' and custNo='13110020' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 04:42:01 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ - |' WHERE custArea='NS121' and custNo='13120004' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 04:41:50 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NS121' and custNo='13120005' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 04:41:20 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ - |' WHERE custArea='NS121' and custNo='13180007' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 04:41:12 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='ซื้อกับยี่ปั๊ว |' WHERE custArea='NS121' and custNo='13180006' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 04:41:04 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NS121' and custNo='13160002' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 04:40:45 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NS121' and custNo='13170025' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 04:40:18 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NS121' and custNo='13170023' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 04:40:06 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NS121' and custNo='13000036' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 04:30:15 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'','2025-12-15 00:00:00','N','0','ร้านค้าไม่ซื้อเพราะ |','20251215','1','3','2025-12-06' FROM c_cust_route WHERE custArea='BE101' and custNo='10230007' and mn='12' and yr='2025'

12/15/2025||||||||||||||||12-15-2025 04:28:47 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NS121' and custNo='13000038' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 04:28:05 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NS121' and custNo='13260002' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 03:18:16 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ - |' WHERE custArea='NS121' and custNo='13160162' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 03:18:04 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ - |' WHERE custArea='NS121' and custNo='80160017' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 02:24:02 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NS121' and custNo='13240003' and mn='12' and yr='2025' and collection='1' and rount='1';

12/15/2025||||||||||||||||12-15-2025 02:23:51 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-12-15 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='NS121' and custNo='13140003' and mn='12' and yr='2025' and collection='1' and rount='1';

INSERT INTO c_log_order_sync (number_row,date_update,sync_name) value ('112','2025-12-15 18:18','sync_visit_credit')

---

Update Visit Complete . . . All Rows is -> 112