require "../share.inc.php"; uses("dicttype", "dict"); $conditions = array(); $dict = new Dicts(); $dicttype = new Dicttypes(); $viewhelper->setPosition(L("dictionary", "tpl"), "dict/"); $viewhelper->setTitle(L("dictionary", "tpl")); if (isset($_GET['do'])) { $do = trim($_GET['do']); if ($do == "search") { if (!empty($_GET['q'])) { $conditions[] = "word like '%" . $_GET['q'] . "%'"; } if (isset($_GET['typeid'])) { $type_id = intval($_GET['typeid']); $conditions[] = "dicttype_id='" . $type_id . "'"; } $amount = $dict->findCount(null, $conditions); $result = $dict->findAll("Dict.*,dp.name AS typename", array("LEFT JOIN {$tb_prefix}dicttypes dp ON dp.id=Dict.dicttype_id"), $conditions, "Dict.id DESC", $pos, $limit); if (!empty($result)) { setvar("items", $result); setvar("paging", array('total' => $amount)); } render("dict/list"); exit; } } //get dictionary types. $dict_types = $dicttype->getAllTypes(); setvar("Dictypes", $dict_types); render("dict/index");