From 836347c1ef261959ddbe33856c92f35bdc458956 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?=EA=A6=8C=EA=A6=AB=EA=A6=B6=EA=A6=8F=EA=A7=80=EA=A6=A6?= =?UTF-8?q?=EA=A6=BF=EA=A6=A7=EA=A6=AE=EA=A6=91=EA=A6=A9=EA=A6=AD=EA=A7=80?= Date: Sat, 24 Jul 2021 20:28:48 +0800 Subject: Revert "Destination code relies on district only" This reverts commit 3dd8b4fd7b317c78872a251fd1ed68d17b54d834. --- config/pikul.tag | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/config/pikul.tag b/config/pikul.tag index 398cef0..0164851 100644 --- a/config/pikul.tag +++ b/config/pikul.tag @@ -59,8 +59,8 @@ sub { $origins[$company] = $::Variable->{SICEPAT_ORIGIN} || $Global::Variable->{SICEPAT_ORIGIN}; $destinations[$company] = $Tag->query({sql => "SELECT code FROM sicepat_destination\ - WHERE district LIKE '%$district%'", - wantarray => 1})->[0]->[0] || ''; + WHERE district='$district' AND city='$city' AND \ + province='$province'", wantarray => 1})->[0]->[0] || ''; $code_prefixes[$company] = 'sicepat_'; $name_prefixes[$company] = 'SiCepat '; } -- cgit v1.2.3