Exemplo n.º 1
0
    $type_name = $type_info['name'];
    $viewhelper->setTitle($type_name);
    $viewhelper->setPosition($type_name, "brand/list.php?catid=" . $typeid);
    $rs = $pdb->GetArray("SELECT id,name FROM {$tb_prefix}brandtypes WHERE parent_id='" . $typeid . "'");
}
if (empty($rs)) {
    $rs = $pdb->GetArray("SELECT id,name FROM {$tb_prefix}brandtypes WHERE parent_id=0");
}
if (isset($_GET['do'])) {
    $do = trim($_GET['do']);
    if ($do == "search") {
        if (isset($_GET['q'])) {
            $searchkeywords = urldecode($_GET['q']);
            $conditions[] = "name like '%" . $searchkeywords . "%'";
        }
        if (isset($_GET['letter'])) {
            $viewhelper->setTitle(L("brands_with_letter", "tpl", $_GET['letter']));
            $viewhelper->setPosition(L("brands_with_letter", "tpl", $_GET['letter']));
            $conditions[] = "letter='" . trim($_GET['letter']) . "'";
        }
    }
}
$brand->setCondition($conditions);
$amount = $brand->findCount(null, $conditions);
$sql = "SELECT * FROM {$tb_prefix}brands" . $brand->getCondition() . " LIMIT " . $pos . "," . $limit;
$result = $pdb->GetArray($sql);
$result = $brand->formatResult($result);
setvar('items', $result);
setvar('Types', $rs);
setvar("paging", array('total' => $amount));
render("brand/list");