$this->selectAdd("
i18n_translate(ltype, lkey, 'en') as lval_en
-
");
}
$this->whereAdd("upper(lval) LIKE '%{$v}%'");
}
+ if (!empty($q['query']['name_starts'])) {
+ $this->whereAdd("lval LIKE '". $this->escape($q['query']['name_starts']). "%'");
+ }
+
if (!empty($q['_filtered']) && !empty($this->ltype)) {
$cfg = $this->cfg();
$filter = $cfg[$this->ltype];
geoip_city.country = i18n.lkey
) AS no_of_city
");
-
+ }
+
+ if(!empty($q['_hide_unused'])) {
+ $this->whereAdd("
+ (
+ SELECT
+ COUNT(geoip_division.id)
+ FROM
+ geoip_division
+ WHERE
+ geoip_division.country = i18n.lkey
+ ) > 0
+ ");
}
}