summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorꦌꦫꦶꦏ꧀ꦦꦿꦧꦮꦑꦩꦭ꧀ <erik@darapsa.co.id>2021-07-24 20:28:48 +0800
committerꦌꦫꦶꦏ꧀ꦦꦿꦧꦮꦑꦩꦭ꧀ <erik@darapsa.co.id>2021-07-24 20:28:48 +0800
commit836347c1ef261959ddbe33856c92f35bdc458956 (patch)
tree6fb9505edc611d4d4b5e56ddb46c86d2c879b55a
parent1238ebca95a1b59ab97bd0a8545b4fad97541ae2 (diff)
Revert "Destination code relies on district only"
This reverts commit 3dd8b4fd7b317c78872a251fd1ed68d17b54d834.
-rw-r--r--config/pikul.tag4
1 files 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 ';
}