Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\_mango2\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\_mango2\ps\nouse\ps_sync_visit_credit - Copy.php on line 11
http://203.155.18.96/BCWEB_SERVICES/back/CREDIT_RouteJsonData.aspx?orderdate=20250429
2025-04-29<<<<<
04/29/2025||||||||||||||||04-29-2025 10:44:22 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,'680411087','2025-04-29 00:00:00','Y','10808.0','ร้านค้าโทรสั่ง | บิล12:อ้างอิง:680311008,015,035,067,002,004,011,036,060,070,086:','20250429','2','3','2025-04-09' FROM c_cust_route WHERE custArea='BE101' and custNo='10120183' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 10:37:27 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,'680438052','2025-04-29 00:00:00','Y','928030.0','| บิล2:อ้างอิง:680438039:','20250429','2','3','2025-04-04' FROM c_cust_route WHERE custArea='NS101' and custNo='18000036' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 10:32:11 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,'680422049','2025-04-29 00:00:00','Y','868190.0','| โทรนัดก่อนส่งส่งโกดัง1/2/3','20250429','1','2','2025-04-19' FROM c_cust_route WHERE custArea='NE101' and custNo='41000056' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 10:28:25 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,'680422048','2025-04-29 00:00:00','Y','150410.0','ร้านค้าโทรสั่ง | โทรนัดก่อนส่ง','20250429','1','2','2025-04-19' FROM c_cust_route WHERE custArea='NE101' and custNo='42130012' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 10:25:52 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-04-29 00:00:00','N','0','ร้านค้าไม่ซื้อเพราะ สินค้ายังมีอยู่ |','20250429','2','1','2025-04-04' FROM c_cust_route WHERE custArea='NS101' and custNo='60000052' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 10:24:23 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-04-29 00:00:00','N','0','ร้านค้าไม่ซื้อเพราะ สินค้ายังมีอยู่ |','20250429','2','1','2025-04-04' FROM c_cust_route WHERE custArea='NS101' and custNo='72110027' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 10:23:56 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-04-29 00:00:00','N','0','ร้านค้าไม่ซื้อเพราะ ยกเลิกใช้อีก |','20250429','2','1','2025-04-04' FROM c_cust_route WHERE custArea='NS101' and custNo='72000035' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 10:23: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,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'680429062','2025-04-29 00:00:00','Y','401040.0','ร้านค้าโทรสั่ง | โอนเงินก่อนส่งสินค้า','20250429','2','4','2025-04-03' FROM c_cust_route WHERE custArea='NH101' and custNo='57130038' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 10:19:21 AM
Update c_cust_route set price_buy='120980.0',orderNo='680422047',visit_date='2025-04-29 00:00:00',is_buy='Y',reason='| โทรนัดก่อนส่ง',fv_date='2025-04-19' WHERE custArea='NE101' and custNo='40000003' and mn='04' and yr='2025' and collection='1' and rount='1';
04/29/2025||||||||||||||||04-29-2025 10:11:39 AM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-04-29 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2025-04-19' WHERE custArea='NE101' and custNo='47160008' and mn='04' and yr='2025' and collection='1' and rount='1';
04/29/2025||||||||||||||||04-29-2025 10:01: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,'680424058','2025-04-29 00:00:00','Y','937040.0','ร้านค้าโทรสั่ง | บิล5:อ้างอิง:680424037,038,056,057:','20250429','1','5' FROM c_cust_route WHERE custArea='NE102' and custNo='30000068' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 10:00:35 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,'680440081','2025-04-29 00:00:00','Y','14294.0','|','20250429','1','2' FROM c_cust_route WHERE custArea='NS121' and custNo='13170023' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 09:59:54 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,'680430061','2025-04-29 00:00:00','Y','23160.0','ร้านค้าโทรสั่ง |','20250429','2','6','2025-04-05' FROM c_cust_route WHERE custArea='NH102' and custNo='52000035' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 09:59:33 AM
Update c_cust_route set price_buy='1245.0',orderNo='680436090',visit_date='2025-04-29 00:00:00',is_buy='Y',reason='|' WHERE custArea='SH111' and custNo='85000003' and mn='04' and yr='2025' and collection='1' and rount='1';
04/29/2025||||||||||||||||04-29-2025 09:59:30 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,'680411086','2025-04-29 00:00:00','Y','4632.0','ร้านค้าโทรสั่ง | บิล7:','20250429','2','2','2025-04-09' FROM c_cust_route WHERE custArea='BE101' and custNo='10120183' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 09:58:41 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,'680438051','2025-04-29 00:00:00','Y','254413.0','| บิล1:อู่ทอง','20250429','2','1','2025-04-04' FROM c_cust_route WHERE custArea='NS101' and custNo='72110032' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 09:57:37 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,'680424057','2025-04-29 00:00:00','Y','94230.0','ร้านค้าโทรสั่ง | บิล4:','20250429','1','4' FROM c_cust_route WHERE custArea='NE102' and custNo='30000068' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 09:56:52 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,'680424056','2025-04-29 00:00:00','Y','287800.0','ร้านค้าโทรสั่ง | บิล3:','20250429','1','3' FROM c_cust_route WHERE custArea='NE102' and custNo='30000068' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 09:52:38 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,'680411085','2025-04-29 00:00:00','Y','9960.0','ร้านค้าโทรสั่ง | บิล7:อ้างอิง:680411016,017,028,050,083:','20250429','2','6','2025-04-09' FROM c_cust_route WHERE custArea='BE101' and custNo='10800032' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 09:45:14 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,'680411083','2025-04-29 00:00:00','Y','29759.0','ร้านค้าโทรสั่ง | บิล5:','20250429','2','5','2025-04-09' FROM c_cust_route WHERE custArea='BE101' and custNo='10800032' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 09:42:55 AM
Update c_cust_route set price_buy='1964.0',orderNo='680417100',visit_date='2025-04-29 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='CT111' and custNo='11000071' and mn='04' and yr='2025' and collection='1' and rount='1';
04/29/2025||||||||||||||||04-29-2025 09:34:57 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,'680417099','2025-04-29 00:00:00','Y','265280.0','ร้านค้าโทรสั่ง | บิล3:อ้างอิง:680417001,023:','20250429','1','3' FROM c_cust_route WHERE custArea='CT111' and custNo='10210058' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 09:31:55 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,'680411082','2025-04-29 00:00:00','Y','30045.0','ร้านค้าโทรสั่ง | บิล2:อ้างอิง:680411077:','20250429','2','3','2025-04-09' FROM c_cust_route WHERE custArea='BE101' and custNo='10700096' and mn='04' and yr='2025'
04/29/2025||||||||||||||||04-29-2025 09:02:04 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,'680411081','2025-04-29 00:00:00','Y','11068.0','| บิล3:อ้างอิง:680411027,061:ด่วน','20250429','2','1','2025-04-09' FROM c_cust_route WHERE custArea='BE101' and custNo='10160297' and mn='04' and yr='2025'
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'
04/29/2025||||||||||||||||04-29-2025 07:29:29 AM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-04-29 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='CT111' and custNo='12150054' and mn='04' and yr='2025' and collection='1' and rount='1';
04/29/2025||||||||||||||||04-29-2025 07:29:22 AM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-04-29 00:00:00',is_buy='N',reason='ซื้อกับยี่ปั๊ว |' WHERE custArea='CT111' and custNo='10510122' and mn='04' and yr='2025' and collection='1' and rount='1';
04/29/2025||||||||||||||||04-29-2025 07:29:10 AM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2025-04-29 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |' WHERE custArea='CT111' and custNo='10510123' and mn='04' and yr='2025' and collection='1' and rount='1';
INSERT INTO c_log_order_sync (number_row,date_update,sync_name) value ('28','2025-04-29 10:49','sync_visit_credit')
Update Visit Complete . . . All Rows is -> 28