http://203.155.18.96/BCWEB_SERVICES/back/CREDIT_RouteJsonData.aspx?orderdate=20250429
2025-04-29<<<<<
04/29/2025||||||||||||||||04-29-2025 08:17: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,'680412091','2025-04-29 00:00:00','Y','23160.0','ร้านค้าโทรสั่ง | บิล4:อ้างอิง:680312014,002,049,085:','20250429','1','4' FROM c_cust_route WHERE custArea='BE111' and custNo='10300085' and mn='04' and yr='2025'
INSERT INTO c_log_order_sync (number_row,date_update,sync_name) value ('1','2025-04-29 08:44','sync_visit_credit')