Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\_kpi\ps\nouse\ps_sync_visit_credit_fix.php on line 11

Warning: include() [function.include]: Failed opening '../function.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\_kpi\ps\nouse\ps_sync_visit_credit_fix.php on line 11
http://203.155.18.96/BCWEB_SERVICES/back/CREDIT_RouteJsonData.aspx?orderdate=20250616
2025-06-16<<<<<

06/16/2025||||||||||||||||06-16-2025 15:58: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) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'680624025','2025-06-16 00:00:00','Y','27186.0','ร้านค้าโทรสั่ง | บิล2:อ้างอิง:680624021:','20250616','1','2' FROM c_cust_route WHERE custArea='NE102' and custNo='34190016' and mn='06' and yr='2025'

06/16/2025||||||||||||||||06-16-2025 15:55:51 PM
Update c_cust_route set price_buy='2534.0',orderNo='680624024',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:' WHERE custArea='NE102' and custNo='34000006' and mn='06' and yr='2025' and collection='1' and rount='1';

06/16/2025||||||||||||||||06-16-2025 15:55: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) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'680634020','2025-06-16 00:00:00','Y','5548.0','ร้านค้าโทรสั่ง | บิล3:ส่งด่วน','20250616','1','3' FROM c_cust_route WHERE custArea='SH101' and custNo='80150020' and mn='06' and yr='2025'

06/16/2025||||||||||||||||06-16-2025 15:52: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,'680627040','2025-06-16 00:00:00','Y','6400.0','ร้านค้าโทรสั่ง |','20250616','1','2','2025-06-09' FROM c_cust_route WHERE custArea='NE121' and custNo='40280016' and mn='06' and yr='2025'

06/16/2025||||||||||||||||06-16-2025 15:50:22 PM
Update c_cust_route set price_buy='19016.0',orderNo='680627039',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='|',fv_date='2025-06-09' WHERE custArea='NE121' and custNo='40280016' and mn='06' and yr='2025' and collection='1' and rount='1';

06/16/2025||||||||||||||||06-16-2025 15:46:39 PM
Update c_cust_route set price_buy='3995.0',orderNo='680627038',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='|',fv_date='2025-06-09' WHERE custArea='NE121' and custNo='40280015' and mn='06' and yr='2025' and collection='1' and rount='1';

06/16/2025||||||||||||||||06-16-2025 15:02:59 PM
Update c_cust_route set price_buy='368350.0',orderNo='680634019',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | โทรแจ้งล่วงหน้า1วัน' WHERE custArea='SH101' and custNo='81000058' and mn='06' and yr='2025' and collection='1' and rount='1';

06/16/2025||||||||||||||||06-16-2025 14:54:08 PM
Update c_cust_route set price_buy='20000.0',orderNo='680637044',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:' WHERE custArea='SH121' and custNo='93160020' and mn='06' and yr='2025' and collection='1' and rount='1';

06/16/2025||||||||||||||||06-16-2025 14:51:13 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,'680637043','2025-06-16 00:00:00','Y','11820.0','ร้านค้าโทรสั่ง | บิล2:','20250616','1','2' FROM c_cust_route WHERE custArea='SH121' and custNo='92000039' and mn='06' and yr='2025'

06/16/2025||||||||||||||||06-16-2025 14:43:32 PM
Update c_cust_route set price_buy='23079.0',orderNo='680639036',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='| บิล1:ส่งด่วน' WHERE custArea='NS111' and custNo='61000024' and mn='06' and yr='2025' and collection='1' and rount='1';

06/16/2025||||||||||||||||06-16-2025 14:06:42 PM
Update c_cust_route set price_buy='4338.0',orderNo='680636070',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='|' WHERE custArea='SH111' and custNo='84240003' and mn='06' and yr='2025' and collection='1' and rount='1';

06/16/2025||||||||||||||||06-16-2025 13:58:07 PM
Update c_cust_route set price_buy='114033.0',orderNo='680616029',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='| บิล1:โทรก่อนส่งล่วงหน้า?2?วัน?',fv_date='2025-06-06' WHERE custArea='CT102' and custNo='74000163' and mn='06' and yr='2025' and collection='1' and rount='1';

06/16/2025||||||||||||||||06-16-2025 13:22:31 PM
Update c_cust_route set price_buy='328710.0',orderNo='680634018',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='| ส่งมะนาว100หีบ และน้ำใสเติมทิพ10หีบก่อน ที่เหลือวันที่5/7/68' WHERE custArea='SH101' and custNo='81000012' and mn='06' and yr='2025' and collection='1' and rount='1';

06/16/2025||||||||||||||||06-16-2025 13:13:49 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,'680611058','2025-06-16 00:00:00','Y','22184.0','ร้านค้าโทรสั่ง | บิล3:','20250616','1','3','2025-06-06' FROM c_cust_route WHERE custArea='BE101' and custNo='10110070' and mn='06' and yr='2025'

06/16/2025||||||||||||||||06-16-2025 12:58:08 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,'680617055','2025-06-16 00:00:00','Y','11095.0','ร้านค้าโทรสั่ง | บิล2:','20250616','1','2' FROM c_cust_route WHERE custArea='CT111' and custNo='10220044' and mn='06' and yr='2025'

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

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

06/16/2025||||||||||||||||06-16-2025 12:00:44 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,'680611057','2025-06-16 00:00:00','Y','40801.0','ร้านค้าโทรสั่ง | บิล1:ด่วน','20250616','1','2','2025-06-06' FROM c_cust_route WHERE custArea='BE101' and custNo='10270242' and mn='06' and yr='2025'

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

06/16/2025||||||||||||||||06-16-2025 11:51:24 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,'680631055','2025-06-16 00:00:00','Y','23035.0','ร้านค้าโทรสั่ง | บิล3:ด่วน','20250616','1','3' FROM c_cust_route WHERE custArea='NH111' and custNo='50210020' and mn='06' and yr='2025'

06/16/2025||||||||||||||||06-16-2025 11:24:48 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,'680624023','2025-06-16 00:00:00','Y','90674.0','ร้านค้าโทรสั่ง | บิล2:อ้างอิง:680624019:ส่งด่วน','20250616','1','3' FROM c_cust_route WHERE custArea='NE102' and custNo='32000004' and mn='06' and yr='2025'

06/16/2025||||||||||||||||06-16-2025 11:04:45 AM
Update c_cust_route set price_buy='98810.0',orderNo='680632043',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | โทรหาลูกค้าก่อนส่ง' WHERE custArea='NH121' and custNo='56000052' and mn='06' and yr='2025' and collection='1' and rount='1';

06/16/2025||||||||||||||||06-16-2025 11:02:17 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,'680624022','2025-06-16 00:00:00','Y','20967.0','ร้านค้าโทรสั่ง | บิล2:','20250616','1','2' FROM c_cust_route WHERE custArea='NE102' and custNo='34190021' and mn='06' and yr='2025'

06/16/2025||||||||||||||||06-16-2025 10:58:19 AM
Update c_cust_route set price_buy='12450.0',orderNo='680617054',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='| ด่วน' WHERE custArea='CT111' and custNo='11140028' and mn='06' and yr='2025' and collection='1' and rount='1';

06/16/2025||||||||||||||||06-16-2025 10:46:18 AM
Update c_cust_route set price_buy='2672.0',orderNo='680636069',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='|' WHERE custArea='SH111' and custNo='81000018' and mn='06' and yr='2025' and collection='1' and rount='1';

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

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

06/16/2025||||||||||||||||06-16-2025 10:25:18 AM
Update c_cust_route set price_buy='5026.0',orderNo='680628028',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง |' WHERE custArea='NE131' and custNo='33110009' and mn='06' and yr='2025' and collection='1' and rount='1';

06/16/2025||||||||||||||||06-16-2025 09:57:13 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,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'','2025-06-16 00:00:00','N','0','ร้านค้าไม่ซื้อเพราะ เก็บเช็ก |','20250616','1','2','2025-06-06' FROM c_cust_route WHERE custArea='CT102' and custNo='73000090' and mn='06' and yr='2025'

06/16/2025||||||||||||||||06-16-2025 09:23:30 AM
Update c_cust_route set price_buy='5088.0',orderNo='680636068',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='SH111' and custNo='81000037' and mn='06' and yr='2025' and collection='1' and rount='1';

06/16/2025||||||||||||||||06-16-2025 08:58:47 AM
Update c_cust_route set price_buy='3832.0',orderNo='680636067',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='SH111' and custNo='81000074' and mn='06' and yr='2025' and collection='1' and rount='1';

06/16/2025||||||||||||||||06-16-2025 08:57:31 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,'680636066','2025-06-16 00:00:00','Y','1707.0','| บิล2:','20250616','1','2' FROM c_cust_route WHERE custArea='SH111' and custNo='82110023' and mn='06' and yr='2025'

06/16/2025||||||||||||||||06-16-2025 07:53:53 AM
Update c_cust_route set price_buy='10527.0',orderNo='680613047',visit_date='2025-06-16 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:ขอด่วน' WHERE custArea='BE112' and custNo='10240091' and mn='06' and yr='2025' and collection='1' and rount='1';

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

06/16/2025||||||||||||||||06-16-2025 02:44:41 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-06-16 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ |',fv_date='2025-06-06' WHERE custArea='BE101' and custNo='10110079' and mn='06' and yr='2025' and collection='1' and rount='1';

INSERT INTO c_log_order_sync (number_row,date_update,sync_name) value ('35','2025-06-16 16:12','sync_visit_credit')

---

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