http://203.155.18.96/BCWEB_SERVICES/back/CREDIT_RouteJsonData.aspx?orderdate=20250906<br>2025-09-06<<<<<	
<br><br>
09/06/2025||||||||||||||||09-06-2025 10:40:38 AM<br>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';<br><br>09/06/2025||||||||||||||||09-06-2025 10:38:58 AM<br>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';<br><br>09/06/2025||||||||||||||||09-06-2025 10:06:33 AM<br>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';<br><br>09/06/2025||||||||||||||||09-06-2025 09:52:05 AM<br>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'<br><br>09/06/2025||||||||||||||||09-06-2025 09:50:54 AM<br>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';<br><br>09/06/2025||||||||||||||||09-06-2025 09:50:41 AM<br>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';<br><br>09/06/2025||||||||||||||||09-06-2025 09:49:40 AM<br>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';<br><br>09/06/2025||||||||||||||||09-06-2025 09:41:13 AM<br>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';<br><br>09/06/2025||||||||||||||||09-06-2025 09:22:40 AM<br>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';<br><br>INSERT INTO c_log_order_sync (number_row,date_update,sync_name) value ('9','2025-09-06 11:35','sync_visit_credit')<br><HR>Update Visit Complete . . . All Rows is -> 9