http://203.155.18.96/BCWEB_SERVICES/back/CREDIT_RouteJsonData.aspx?orderdate=20251217<br>2025-12-17<<<<<	
<br><br>
12/17/2025||||||||||||||||12-17-2025 10:46:24 AM<br>Update c_cust_route set price_buy='5006.0',orderNo='681212053',visit_date='2025-12-17 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:' WHERE custArea='BE111' and custNo='32130013' and mn='12' and yr='2025' and collection='1' and rount='1';<br><br>12/17/2025||||||||||||||||12-17-2025 10:40:52 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,'681212052','2025-12-17 00:00:00','Y','6645.0','ร้านค้าโทรสั่ง | บิล2:','20251217','1','2' FROM c_cust_route  WHERE custArea='BE111' and custNo='10120144' and mn='12' and yr='2025'<br><br>12/17/2025||||||||||||||||12-17-2025 09:20:37 AM<br>Update c_cust_route set price_buy='24900.0',orderNo='681217065',visit_date='2025-12-17 00:00:00',is_buy='Y',reason='| บิล1:ด่วน' WHERE custArea='CT111' and custNo='12130013' and mn='12' and yr='2025' and collection='1' and rount='1';<br><br>12/17/2025||||||||||||||||12-17-2025 08:41:30 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,'681240053','2025-12-17 00:00:00','Y','12580.0','|','20251217','1','3' FROM c_cust_route  WHERE custArea='NS121' and custNo='18140006' and mn='12' and yr='2025'<br><br>12/17/2025||||||||||||||||12-17-2025 08:29:00 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,'681212051','2025-12-17 00:00:00','Y','5820.0','ร้านค้าโทรสั่ง | บิล1:ด่วน','20251217','1','2' FROM c_cust_route  WHERE custArea='BE111' and custNo='10200065' and mn='12' and yr='2025'<br><br>12/17/2025||||||||||||||||12-17-2025 08:14:49 AM<br>Update c_cust_route set price_buy='4753.0',orderNo='681231052',visit_date='2025-12-17 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='NH111' and custNo='50170005' and mn='12' and yr='2025' and collection='1' and rount='1';<br><br>12/17/2025||||||||||||||||12-17-2025 07:13:49 AM<br>Update c_cust_route set price_buy='456873.0',orderNo='681217064',visit_date='2025-12-17 00:00:00',is_buy='Y',reason='| ด่วน' WHERE custArea='CT111' and custNo='25000030' and mn='12' and yr='2025' and collection='1' and rount='1';<br><br>12/17/2025||||||||||||||||12-17-2025 06:58:57 AM<br>Update c_cust_route set price_buy='6307.0',orderNo='681217063',visit_date='2025-12-17 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='CT111' and custNo='12150066' and mn='12' and yr='2025' and collection='1' and rount='1';<br><br>INSERT INTO c_log_order_sync (number_row,date_update,sync_name) value ('8','2025-12-17 10:50','sync_visit_credit')<br><HR>Update Visit Complete . . . All Rows is -> 8