print_("top",$TPL_SCP,1);?>
print_("menu",$TPL_SCP,1);?>
$fun = new fun;
$category_fun = new category;
if(!$GLOBALS[pagesize]) $GLOBALS[pagesize] = 20;
if(!$GLOBALS[page]) $GLOBALS[page] = 1;
$_brand_search = ($GLOBALS[category]) ? "&category=$GLOBALS[category]" : "&category=$GLOBALS[code]";
$_brand_search .= "&brandname=$GLOBALS[brandname]&company=$GLOBALS[company]&pagesize=$GLOBALS[pagesize]";
$_brand_search .= "&native=$GLOBALS[native]&price=$GLOBALS[price]&product_loc=$GLOBALS[product_loc]";
$_brand_search .= "&sellprice=$GLOBALS[sellprice]&options=$GLOBALS[options]&special=$GLOBALS[special]";
$_brand_search .= "&status=$GLOBALS[status]&ment=$GLOBALS[ment]&content=$GLOBALS[content]";
?>
$status = ($GLOBALS[status]) ? $GLOBALS[status] : "all";
$product_loc = ($GLOBALS[product_loc]) ? $GLOBALS[product_loc] : "all";
$sql_ = " where brandcode != '0'";
if($GLOBALS[category] && $GLOBALS[category] != "undefined"){
for($i = 0 ; $i < 12 ; $i += 3){
$code_arr = substr($GLOBALS[category], $i, 3);
if($code_arr != 0) $cut_num = $i + 3;
}
$sql_ .= " and brandcode LIKE '".substr($GLOBALS[category],0,$cut_num)."%' ";
}
$sql_ .= ($GLOBALS[brandname]) ? " and LOWER(brandname) LIKE LOWER('%$GLOBALS[brandname]%') " : "";
$sql_ .= ($GLOBALS[company]) ? " and LOWER(company) LIKE LOWER('%$GLOBALS[company]%') " : "";
//$sql_ .= ($GLOBALS[product_loc] != "all") ? " and product_loc LIKE '%$GLOBALS[product_loc]%' " : "";
$sql_ .= ($GLOBALS[sellprice]) ? " and sellprice LIKE '%$GLOBALS[sellprice]%' " : "";
//$sql_ .= ($GLOBALS[options]) ? " and options LIKE '%$GLOBALS[options]%' " : "";
//$sql_ .= ($GLOBALS[special]) ? " and special LIKE '%$GLOBALS[special]%' " : "";
$sql_ .= ($status != "all") ? " and status = '$GLOBALS[status]' " : "";
//$sql_ .= ($GLOBALS[ment]) ? " and ment LIKE '%$GLOBALS[ment]%' " : "";
//$sql_ .= ($GLOBALS[content]) ? " and LOWER(content) LIKE LOWER('%$GLOBALS[content]%') " : "";
$sql = "select count(*) from ".BRAND." $sql_ ";
$rs = mysql_query($sql);
$row = mysql_fetch_array($rs);
$total = $row[0];
$totalpage = ceil($total/$GLOBALS[pagesize]);
$start = ($GLOBALS[page] - 1) * $GLOBALS[pagesize];
$j = $total - ($GLOBALS[page] - 1) * $GLOBALS[pagesize];
$sql = "select * from ".BRAND." $sql_ order by wdate desc limit $start, $GLOBALS[pagesize]";
$rs = mysql_query($sql);
?>
$_brand_search_page = "&type=$GLOBALS[type]&mode=$GLOBALS[mode]".$_brand_search;
echo $fun -> page_fun($totalpage, $total, $GLOBALS[page], $_brand_search_page, "20")
?> |
|
$_brand_search_page = "&type=$GLOBALS[type]&mode=$GLOBALS[mode]".$_brand_search;
echo $fun -> page_fun($totalpage, $total, $GLOBALS[page], $_brand_search_page, "20")
?> |
|
//초기 선택값 스크립트
if($GLOBALS[code] || $GLOBALS[category]){
$GetCode = ($GLOBALS[code]) ? $GLOBALS[code] : $GLOBALS[category];
echo "\n\n";
}else{
echo "\n\n";
}
?>
print_("bottom",$TPL_SCP,1);?>
print_("tail",$TPL_SCP,1);?>