$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");
$id = intval($_GET['id']); } if ($do == "del" && !empty($id)) { $result = $brand->del(intval($id), "member_id=" . $_SESSION['MemberID']); } if ($do == "edit") { if (!empty($id)) { $brand_info = $pdb->GetRow("SELECT * FROM {$tb_prefix}brands WHERE member_id=" . $_SESSION['MemberID'] . " AND id={$id}"); if (!empty($brand_info['picture'])) { $brand_info['image'] = pb_get_attachmenturl($brand_info['picture'], "../"); } setvar("item", $brand_info); } setvar("BrandtypeOptions", $brandtypes->getTypeOptions()); $tpl_file = "brand_edit"; template($tpl_file); exit; } } $conditions[] = "member_id=" . $_SESSION['MemberID']; $amount = $brand->findCount('', $conditions, "id"); $page->setPagenav($amount); $result = $brand->findAll("id,name,description,picture", '', $conditions, "id DESC", $page->firstcount, $page->displaypg); if (!empty($result)) { for ($i = 0; $i < count($result); $i++) { $result[$i]['image'] = pb_get_attachmenturl($result[$i]['picture'], '../', "middle"); } setvar("Items", $result); setvar("ByPages", $page->pagenav); } template($tpl_file);