http://203.155.18.96/BCWEB_SERVICES/JSON_CREDIT_sendRouteSaveNotSelling.aspx?DATE_FROM=20251216&DATE_TO=20251216&TEST=0
2025-12-16
SELECT id FROM report_not_selling
WHERE CusCode LIKE '%10160282%' and VisitDate = '2025-12-16 02:46:11 PM' and Route = '11'
SELECT id FROM report_not_selling
WHERE CusCode LIKE '%44000057%' and VisitDate = '2025-12-16 04:13:22 PM' and Route = '10'
SELECT id FROM report_not_selling
WHERE CusCode LIKE '%44000056%' and VisitDate = '2025-12-16 04:13:33 PM' and Route = '10'
SELECT id FROM report_not_selling
WHERE CusCode LIKE '%44000035%' and VisitDate = '2025-12-16 04:13:41 PM' and Route = '10'
SELECT id FROM report_not_selling
WHERE CusCode LIKE '%44000050%' and VisitDate = '2025-12-16 04:13:57 PM' and Route = '11'
SELECT id FROM report_not_selling
WHERE CusCode LIKE '%44000053%' and VisitDate = '2025-12-16 04:14:05 PM' and Route = '11'
SELECT id FROM report_not_selling
WHERE CusCode LIKE '%44150006%' and VisitDate = '2025-12-16 04:14:12 PM' and Route = '11'
SELECT id FROM report_not_selling
WHERE CusCode LIKE '%77140032%' and VisitDate = '2025-12-16 01:10:03 PM' and Route = '16'
SELECT id FROM report_not_selling
WHERE CusCode LIKE '%13190007%' and VisitDate = '2025-12-16 01:58:39 PM' and Route = '07'
SELECT id FROM report_not_selling
WHERE CusCode LIKE '%13130006%' and VisitDate = '2025-12-16 01:59:00 PM' and Route = '11'
SELECT id FROM report_not_selling
WHERE CusCode LIKE '%13160012%' and VisitDate = '2025-12-16 01:59:10 PM' and Route = '11'
SELECT id FROM report_not_selling
WHERE CusCode LIKE '%%' and VisitDate = '' and Route = ''
INSERT INTO c_log_order_sync (number_row,date_update,sync_name,visit_date) value ('12','2025-12-16 18:24','sync_credit_not_sell','20251216')
Update Order Complete . . . All Rows is -> 12