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=20250906
2025-09-06<<<<<

09/06/2025||||||||||||||||09-06-2025 19:09:30 PM
Update c_cust_route set price_buy='112529.0',orderNo='680938003',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='|',fv_date='2025-09-04' WHERE custArea='NS101' and custNo='16000031' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 18:49:53 PM
Update c_cust_route set price_buy='5575.0',orderNo='680934007',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:ส่งด่วน' WHERE custArea='SH101' and custNo='84130017' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 18:43:03 PM
Update c_cust_route set price_buy='6595.0',orderNo='680927013',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='|' WHERE custArea='NE121' and custNo='46230002' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 18:39: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) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'680927012','2025-09-06 00:00:00','Y','35990.0','ร้านค้าโทรสั่ง | บิล2:','20250906','1','2' FROM c_cust_route WHERE custArea='NE121' and custNo='40000173' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 18:18: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,'680935003','2025-09-06 00:00:00','Y','10000.0','| บิล2:อ้างอิง:680935002:','20250906','1','2' FROM c_cust_route WHERE custArea='SH102' and custNo='92120002' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 18:15:48 PM
Update c_cust_route set price_buy='955.0',orderNo='680935002',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='SH102' and custNo='92120002' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 18:11:29 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,'680941011','2025-09-06 00:00:00','Y','22900.0','ร้านค้าโทรสั่ง | บิล4:ส่งสาขาบึง','20250906','1','4','2025-09-04' FROM c_cust_route WHERE custArea='BE102' and custNo='20150027' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 18:11:14 PM
Update c_cust_route set price_buy='9352.0',orderNo='680931010',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='NH111' and custNo='50240009' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 18:10:09 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,'680941010','2025-09-06 00:00:00','Y','22900.0','ร้านค้าโทรสั่ง | บิล3:ส่งสะพานสี่','20250906','1','3','2025-09-04' FROM c_cust_route WHERE custArea='BE102' and custNo='20150027' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 18:09:32 PM
Update c_cust_route set price_buy='36257.0',orderNo='680937006',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='|' WHERE custArea='SH121' and custNo='92140021' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 18:09:16 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,'680941009','2025-09-06 00:00:00','Y','57250.0','ร้านค้าโทรสั่ง | บิล2:ส่งสนง.ใหญ่','20250906','1','2','2025-09-04' FROM c_cust_route WHERE custArea='BE102' and custNo='20150027' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 18:03:03 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,'680941008','2025-09-06 00:00:00','Y','955.0','ร้านค้าโทรสั่ง | บิล4:','20250906','1','4','2025-09-04' FROM c_cust_route WHERE custArea='BE102' and custNo='27120025' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 18:02: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,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'680929007','2025-09-06 00:00:00','Y','23682.0','ร้านค้าโทรสั่ง | บิล2:','20250906','1','2','2025-09-04' FROM c_cust_route WHERE custArea='NH101' and custNo='51000042' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 18:01:59 PM
Update c_cust_route set price_buy='12450.0',orderNo='680937005',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='|' WHERE custArea='SH121' and custNo='90110120' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 17:57:20 PM
Update c_cust_route set price_buy='4246.0',orderNo='680932010',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:โทรหาลูกค้าก่อนส่งสินค้า' WHERE custArea='NH121' and custNo='54000024' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 17:55:19 PM
Update c_cust_route set price_buy='1686.0',orderNo='680932009',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:โทรหาลูกค้าก่อนส่งสินค้า' WHERE custArea='NH121' and custNo='54000039' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 17:54:30 PM
Update c_cust_route set price_buy='22293.0',orderNo='680937004',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:ส่ง10/9 เวลา8.30น.' WHERE custArea='SH121' and custNo='90110136' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 17:51:24 PM
Update c_cust_route set price_buy='11865.0',orderNo='680937003',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:ส่ง9/9/68 ส่ง14.00' WHERE custArea='SH121' and custNo='10250126' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 17:51:03 PM
Update c_cust_route set price_buy='7389.0',orderNo='680932008',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| โทรหาลูกค้าก่อนส่งสินค้า' WHERE custArea='NH121' and custNo='54000020' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 17:48:57 PM
Update c_cust_route set price_buy='8678.0',orderNo='680929006',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:',fv_date='2025-09-04' WHERE custArea='NH101' and custNo='51000042' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 17:48:55 PM
Update c_cust_route set price_buy='7719.0',orderNo='680932007',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| โทรหาลูกค้าก่อนส่งสินค้า' WHERE custArea='NH121' and custNo='54130002' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 17:41: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,'680932006','2025-09-06 00:00:00','Y','3477.0','ร้านค้าโทรสั่ง | บิล3:สาขาทุ่งโฮ้ง','20250906','1','3' FROM c_cust_route WHERE custArea='NH121' and custNo='54000038' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 17:39: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,'680932005','2025-09-06 00:00:00','Y','9851.0','ร้านค้าโทรสั่ง | บิล2:อ้างอิง:680932004:สาขาเชียงราย','20250906','1','2' FROM c_cust_route WHERE custArea='NH121' and custNo='56110029' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 17:38:16 PM
Update c_cust_route set price_buy='4424.0',orderNo='680932004',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:สาขาภูซาง' WHERE custArea='NH121' and custNo='56110029' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 17:14:35 PM
Update c_cust_route set price_buy='9883.0',orderNo='680912020',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:' WHERE custArea='BE111' and custNo='10900029' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 17:10:15 PM
Update c_cust_route set price_buy='3860.0',orderNo='680912019',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:' WHERE custArea='BE111' and custNo='10400078' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 16:45:45 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,'680911016','2025-09-06 00:00:00','Y','22900.0','ร้านค้าโทรสั่ง | บิล3:','20250906','1','3','2025-09-03' FROM c_cust_route WHERE custArea='BE101' and custNo='10220066' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 16:33:14 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,'680911015','2025-09-06 00:00:00','Y','193.0','ร้านค้าโทรสั่ง | บิล2:','20250906','1','2','2025-09-03' FROM c_cust_route WHERE custArea='BE101' and custNo='10800032' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 16:31:42 PM
Update c_cust_route set price_buy='32723.0',orderNo='680911014',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:',fv_date='2025-09-03' WHERE custArea='BE101' and custNo='10800032' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 16:29:35 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,'680911013','2025-09-06 00:00:00','Y','955.0','ร้านค้าโทรสั่ง | บิล2:','20250906','1','2','2025-09-03' FROM c_cust_route WHERE custArea='BE101' and custNo='10150172' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 16:29: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,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'680911012','2025-09-06 00:00:00','Y','1910.0','ร้านค้าโทรสั่ง | บิล2:','20250906','1','2','2025-09-03' FROM c_cust_route WHERE custArea='BE101' and custNo='10150148' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 16:27:27 PM
Update c_cust_route set price_buy='99110.0',orderNo='680922003',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:',fv_date='2025-09-04' WHERE custArea='NE101' and custNo='47160008' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 16:11:46 PM
Update c_cust_route set price_buy='6643.0',orderNo='680926006',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='|' WHERE custArea='NE112' and custNo='49140002' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 15:41:05 PM
Update c_cust_route set price_buy='86300.0',orderNo='680930004',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | โทรนัดก่อนส่ง/ส่งด่วน' WHERE custArea='NH102' and custNo='55000017' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 15:14: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) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'680936019','2025-09-06 00:00:00','Y','6225.0','| บิล2:อ้างอิง:680936018:ส่ง?วันที่?30/9/68','20250906','1','2' FROM c_cust_route WHERE custArea='SH111' and custNo='86000050' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 15:13:04 PM
Update c_cust_route set price_buy='7553.0',orderNo='680936018',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:ส่งวันที่?16/9/68' WHERE custArea='SH111' and custNo='86000050' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 14:45:45 PM
Update c_cust_route set price_buy='42202.0',orderNo='680918015',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='|' WHERE custArea='CT121' and custNo='70110040' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 14:43: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) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'680918014','2025-09-06 00:00:00','Y','15767.0','| บิล2:อ้างอิง:680918013:','20250906','1','2' FROM c_cust_route WHERE custArea='CT121' and custNo='71130002' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 14:41:03 PM
Update c_cust_route set price_buy='25069.0',orderNo='680918013',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='CT121' and custNo='71130002' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 14:32:40 PM
Update c_cust_route set price_buy='1100.0',orderNo='680939007',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:โทรแจ้งก่อนส่ง' WHERE custArea='NS111' and custNo='61110022' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 14:31:45 PM
Update c_cust_route set price_buy='6134.0',orderNo='680936017',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='|' WHERE custArea='SH111' and custNo='86000044' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 14:12:46 PM
Update c_cust_route set price_buy='3946.0',orderNo='680931009',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='NH111' and custNo='51120003' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 13:38:45 PM
Update c_cust_route set price_buy='7506.0',orderNo='680936016',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='|' WHERE custArea='SH111' and custNo='86130024' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 13:24:36 PM
Update c_cust_route set price_buy='6741.0',orderNo='680940008',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='|' WHERE custArea='NS121' and custNo='72140006' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 12:35:14 PM
Update c_cust_route set price_buy='139538.0',orderNo='680922002',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:',fv_date='2025-09-04' WHERE custArea='NE101' and custNo='42000003' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 12:29:20 PM
Update c_cust_route set price_buy='3500.0',orderNo='680940007',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='NS121' and custNo='72130009' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 12:19:36 PM
Update c_cust_route set price_buy='7720.0',orderNo='680934006',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:ส่งด่วน' WHERE custArea='SH101' and custNo='84000053' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 11:56:48 AM
Update c_cust_route set price_buy='6400.0',orderNo='680929005',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:',fv_date='2025-09-04' WHERE custArea='NH101' and custNo='50000098' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 11:43:18 AM
Update c_cust_route set price_buy='6655.0',orderNo='680933005',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='|' WHERE custArea='NH122' and custNo='53120010' and mn='09' and yr='2025' and collection='1' and rount='1';

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

09/06/2025||||||||||||||||09-06-2025 11:02:49 AM
Update c_cust_route set price_buy='6670.0',orderNo='680934005',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:โทรแจ้งล่วงหน้า1วัน' WHERE custArea='SH101' and custNo='86220008' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 10:40:38 AM
Update c_cust_route set price_buy='37621.0',orderNo='680939006',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:ส่งด่วน' WHERE custArea='NS111' and custNo='61000023' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 10:38:58 AM
Update c_cust_route set price_buy='150860.0',orderNo='680929004',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง |',fv_date='2025-09-04' WHERE custArea='NH101' and custNo='57140010' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 10:06:33 AM
Update c_cust_route set price_buy='22800.0',orderNo='680936015',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='SH111' and custNo='80160013' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 10:04:46 AM
Update c_cust_route set price_buy='7310.0',orderNo='680918012',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='CT121' and custNo='75000049' and mn='09' and yr='2025' and collection='1' and rount='1';

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

09/06/2025||||||||||||||||09-06-2025 09:52:05 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,'680913011','2025-09-06 00:00:00','Y','193.0','| บิล2:','20250906','1','2' FROM c_cust_route WHERE custArea='BE112' and custNo='10250090' and mn='09' and yr='2025'

09/06/2025||||||||||||||||09-06-2025 09:50:54 AM
Update c_cust_route set price_buy='4500.0',orderNo='680936014',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='SH111' and custNo='84220001' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 09:50:41 AM
Update c_cust_route set price_buy='12607.0',orderNo='680913010',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='BE112' and custNo='10250090' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 09:49:40 AM
Update c_cust_route set price_buy='2178.0',orderNo='680936013',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='SH111' and custNo='86170001' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 09:41:13 AM
Update c_cust_route set price_buy='225250.0',orderNo='680913009',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง |' WHERE custArea='BE112' and custNo='10520073' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 09:22:40 AM
Update c_cust_route set price_buy='32300.0',orderNo='680917016',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:' WHERE custArea='CT111' and custNo='12110039' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 09:06:56 AM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-09-06 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ รอร้านระบาย |' WHERE custArea='NH122' and custNo='53000020' and mn='09' and yr='2025' and collection='1' and rount='1';

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

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

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

09/06/2025||||||||||||||||09-06-2025 09:05:49 AM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-09-06 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ สินค้าพึ่งมา |' WHERE custArea='NH122' and custNo='53000066' and mn='09' and yr='2025' and collection='1' and rount='1';

09/06/2025||||||||||||||||09-06-2025 09:05:23 AM
Update c_cust_route set price_buy='45050.0',orderNo='680933004',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='NH122' and custNo='53000038' and mn='09' and yr='2025' and collection='1' and rount='1';

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

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

09/06/2025||||||||||||||||09-06-2025 08:39:03 AM
Update c_cust_route set price_buy='12800.0',orderNo='680926005',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='|' WHERE custArea='NE112' and custNo='37110008' and mn='09' and yr='2025' and collection='1' and rount='1';

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

INSERT INTO c_log_order_sync (number_row,date_update,sync_name) value ('72','2025-09-06 20:56','sync_visit_credit')

---

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