www.gusucode.com > citySHOP B2C商城系统 进销存 2.0.6码程序 > upload/search.php

    <?php
include './include/common.inc.php';

if (!isset($keyword)) {
    showmessage('undefined_action');
}
if ($keyword == '') {
    showmessage('请输入搜索关键字。');
}
$headlinks = showlinks('css','style');
$jslinks = showlinks('js','common');
$pagetitle = urldecode($keyword);
$tpp = $tpps['goodslist'];
$page = max(1, intval($page));
$start_limit = ($page - 1) * $tpp;
$cate3 = isset($cate3)?intval($cate3):0;

$wher = '';
$where = "WHERE g.selling='1' AND g.gid=ga.gid AND gi.gid=g.gid ";

$keyword = htmlspecialchars(filter_tags(urldecode($keyword)));
$gdid = is_numeric($keyword)?intval($keyword):0;
if(!$gdid){
	$keystr = preg_replace("/([".chr(0xa1)."-".chr(0xff)."]{2})/"," \\1 ",$keyword);
	$keystr = preg_replace("/[\s]+/",' ',$keystr);
	$keyarr = explode(' ',trim($keystr));
	
	$keystr = change_chinese($keystr);
	$subarr = explode(' ',$keystr);
	$keystr = $dot = '';
	foreach($subarr as $v){
		$v = str_pad($v, 4, '_');
		$keystr .= $dot.'+'.$v;
		$dot = ' ';
	}
	$where .= "AND (MATCH (gi.subject) AGAINST ('$keystr' IN BOOLEAN MODE)) ";	
}else{
	$where .= "AND g.gid='".($gdid-$goods_start_number)."'";
}

if($cate3){
	$where .= " AND g.category3='$cate3' ";
}

$viewstyle = isset($viewstyle) ? intval($viewstyle) : 2;
$ordertype = isset($ordertype) ? intval($ordertype) : 1;
$gorder = $goodsrank[$ordertype];

$wher .= $where . ' ORDER BY g.' . $gorder[0] . ' ' . $gorder[1];
$where .= ' ORDER BY g.' . $gorder[0] . ' ' . $gorder[1];

$query = $db->query("SELECT g.gid FROM {$tablepre}goods g,{$tablepre}goodsattr ga,{$tablepre}goodsindex gi $wher");
$countnum = $db->num_rows($query);
$multipage = multi($countnum, $tpp, $page, "search.php?viewstyle=$viewstyle&ordertype=$ordertype&keyword=$keyword");

$query = $db->query("SELECT g.*,ga.* FROM {$tablepre}goods g,{$tablepre}goodsattr ga,{$tablepre}goodsindex gi $where LIMIT $start_limit,$tpp");
$goods = array();
$cate3arr = array();
while ($arr = $db->fetch_array($query)) {
    $arr['photos'] = unserialize($arr['photos']);
    $arr['zsold'] = $arr['sold']+$arr['zsold'];  
    $arr['zprice'] = number_format($arr['eprice'] * ($arr['discount'] / 10), 2);
    in_array($arr['category3'],$cate3arr) or $cate3arr[] = $arr['category3'];
	$goods[] = $arr;
}
/**
 * 3级分类筛选
 */
if(!empty($cate3arr)){
	$cate3ids = isset($cates)?$cates:implode(',',$cate3arr); 
	$query = $db->query("SELECT * FROM {$tablepre}category WHERE categoryid IN ($cate3ids) ORDER BY `order` DESC,categoryid ASC");
	$catechose = '';
	while($arr = $db->fetch_array($query)){
		$chked = $arr['categoryid'] == $cate3 ? 'class="hov"' : '';
		$catechose .= "<li><a $chked href=\"search.php?keyword=".urlencode($keyword)."&cate3=$arr[categoryid]&cates=$cate3ids\">$arr[name]</a></li>";
	}	
} 


//rank
$rankstr = '';
foreach ($goodsrank as $s => $rk) {
    $hoves = '';
    if ($ordertype == $s) {
        $hoves = 'class="hove"';
    }
    $rankstr .= "<a href=\"search.php?viewstyle=$viewstyle&ordertype=$s&page=$page&keyword=$keyword\" $hoves>$rk[2]</a> ";
}
//pagebtn
$pageprev = $pagenext = '';
$realpages = @ceil($countnum / $tpp);
$pages = $tpps['maxpage'] && $tpps['maxpage'] < $realpages ? $tpps['maxpage'] :
    $realpages;
$prev = $page <= 1 ? 0 : ($page - 1);
$next = $page >= $pages ? 0 : ($page + 1);
$pageprev = "search.php?viewstyle=$viewstyle&ordertype=$ordertype&page=$prev&keyword=$keyword";
$pagenext = "search.php?viewstyle=$viewstyle&ordertype=$ordertype&page=$next&keyword=$keyword";

$viewhistorys = viewhistory();


include (template('search'));
?>