Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\mangofplus\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\mangofplus\ps\nouse\ps_sync_visit_credit - Copy.php on line 11
http://203.155.18.96/BCWEB_SERVICES/back/CREDIT_RouteJsonData.aspx?orderdate=20251216
2025-12-16<<<<<

12/16/2025||||||||||||||||12-16-2025 09:34:21 AM
Update c_cust_route set price_buy='12886.0',orderNo='681236074',visit_date='2025-12-16 00:00:00',is_buy='Y',reason='|' WHERE custArea='SH111' and custNo='82180001' and mn='12' and yr='2025' and collection='1' and rount='1';

12/16/2025||||||||||||||||12-16-2025 09:31:37 AM
Update c_cust_route set price_buy='11497.0',orderNo='681236073',visit_date='2025-12-16 00:00:00',is_buy='Y',reason='|' WHERE custArea='SH111' and custNo='81000054' and mn='12' and yr='2025' and collection='1' and rount='1';

12/16/2025||||||||||||||||12-16-2025 09:21:31 AM
Update c_cust_route set price_buy='88441.0',orderNo='681217061',visit_date='2025-12-16 00:00:00',is_buy='Y',reason='|' WHERE custArea='CT111' and custNo='24160010' and mn='12' and yr='2025' and collection='1' and rount='1';

12/16/2025||||||||||||||||12-16-2025 09:04:51 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,'681217060','2025-12-16 00:00:00','Y','10240.0','ร้านค้าโทรสั่ง | บิล2:','20251216','1','2' FROM c_cust_route WHERE custArea='CT111' and custNo='11110054' and mn='12' and yr='2025'

12/16/2025||||||||||||||||12-16-2025 08:59:50 AM
Update c_cust_route set price_buy='29190.0',orderNo='681234022',visit_date='2025-12-16 00:00:00',is_buy='Y',reason='| ส่งด่วน' WHERE custArea='SH101' and custNo='83000038' and mn='12' and yr='2025' and collection='1' and rount='1';

12/16/2025||||||||||||||||12-16-2025 08:38:46 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,'681239048','2025-12-16 00:00:00','Y','2800.0','ร้านค้าโทรสั่ง | บิล2:ส่งด่วน','20251216','1','2' FROM c_cust_route WHERE custArea='NS111' and custNo='60140026' and mn='12' and yr='2025'

12/16/2025||||||||||||||||12-16-2025 08:14:00 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,'681234021','2025-12-16 00:00:00','Y','7450.0','| บิล2:ส่งด่วน','20251216','1','3' FROM c_cust_route WHERE custArea='SH101' and custNo='84000057' and mn='12' and yr='2025'

12/16/2025||||||||||||||||12-16-2025 07:48:28 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,'681215038','2025-12-16 00:00:00','Y','24900.0','ร้านค้าโทรสั่ง | บิล2:อ้างอิง:681215037:','20251216','1','2' FROM c_cust_route WHERE custArea='CT101' and custNo='12110060' and mn='12' and yr='2025'

12/16/2025||||||||||||||||12-16-2025 07:47:15 AM
Update c_cust_route set price_buy='24900.0',orderNo='681215037',visit_date='2025-12-16 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:ส่งด่วน' WHERE custArea='CT101' and custNo='12110060' 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 ('9','2025-12-16 10:01','sync_visit_credit')

---

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