代码拉取完成，页面将自动刷新
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580
<?php
/**
* DDXY 搜索程序
* ============================================================================
* * 版权所有 2005-2016 山东叮咚小愿信息科技有限公司，并保留所有权利。
* 网站地址: http://www.dingdongxiaoyuan.com；
* ----------------------------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
* 使用；不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
* $Author: ddxy $
* $Id: search.php 17217 2011-01-19 06:29:08Z ddxy $
*/
define('IN_ECS', true);
if (!function_exists("htmlspecialchars_decode")) {
function htmlspecialchars_decode($string, $quote_style = ENT_COMPAT)
{
return strtr($string, array_flip(get_html_translation_table(HTML_SPECIALCHARS, $quote_style)));
}
}
if (empty($_GET['encode'])) {
$string = array_merge($_GET, $_POST);
if (get_magic_quotes_gpc()) {
require(dirname(__FILE__) . '/includes/lib_base.php');
$string = stripslashes_deep($string);
}
$string['search_encode_time'] = time();
$string = str_replace('+', '%2b', base64_encode(serialize($string)));
header("Location:search.php?encode=$string\n");
exit;
} else {
$string = base64_decode(trim($_GET['encode']));
if ($string !== false) {
$string = unserialize($string);
if ($string !== false) {
/* 用户在重定向的情况下当作一次访问 */
if (!empty($string['search_encode_time'])) {
if (time() > $string['search_encode_time'] + 2) {
define('INGORE_VISIT_STATS', true);
}
} else {
define('INGORE_VISIT_STATS', true);
}
/* @author-bylu 优惠券列表入口 start */
if (@$string['keywords'] == '优惠券')
header("location:http://" . str_replace(strrchr($_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'], '/'), '', $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'] . '/coupons.php?act=coupons_index'));
/* @author-bylu end */
} else {
$string = array();
}
} else {
$string = array();
}
}
require(dirname(__FILE__) . '/includes/init.php');
$_REQUEST = array_merge($_REQUEST, addslashes_deep($string));
/* 过滤 XSS 攻击和SQL注入 */
get_request_filter();
//叮咚小愿 --zhuo start
require(ROOT_PATH . '/includes/lib_area.php'); //叮咚小愿 --zhuo
$warehouse_other = [
'province_id' => $province_id,
'city_id' => $city_id
];
$warehouse_area_info = get_warehouse_area_info($warehouse_other);
$region_id = $warehouse_area_info['region_id'];
$area_id = $warehouse_area_info['area_id'];
$area_city = $warehouse_area_info['city_id'];
//叮咚小愿 --zhuo end
$_REQUEST['act'] = !empty($_REQUEST['act']) ? trim($_REQUEST['act']) : '';
$search_type = isset($_REQUEST['store_search_cmt']) && !empty($_REQUEST['store_search_cmt']) ? intval($_REQUEST['store_search_cmt']) : 0; //搜索类型
//调位置
$_REQUEST['keywords'] = strip_tags($_REQUEST['keywords']); //去除html、php代码，主要防止js注入 by wu
$_REQUEST['keywords'] = !empty($_REQUEST['keywords']) ? addslashes_deep(trim($_REQUEST['keywords'])) : '';
$_REQUEST['category'] = !empty($_REQUEST['category']) ? intval($_REQUEST['category']) : 0;
$_REQUEST['goods_type'] = !empty($_REQUEST['goods_type']) ? intval($_REQUEST['goods_type']) : 0;
$_REQUEST['sc_ds'] = !empty($_REQUEST['sc_ds']) ? intval($_REQUEST['sc_ds']) : 0;
$_REQUEST['outstock'] = !empty($_REQUEST['outstock']) ? 1 : 0;
$cat_id = isset($_REQUEST['cat_id']) && !empty($_REQUEST['cat_id']) ? intval($_REQUEST['cat_id']) : 0;
$get_price_max = isset($_REQUEST['price_max']) ? floatval($_REQUEST['price_max']) : 0;
$get_price_min = isset($_REQUEST['price_min']) ? floatval($_REQUEST['price_min']) : 0;
$_REQUEST['price_max'] = isset($_REQUEST['price_max']) && intval($_REQUEST['price_max']) > 0 ? intval($_REQUEST['price_max']) : 0;
$_REQUEST['price_min'] = isset($_REQUEST['price_min']) && intval($_REQUEST['price_min']) > 0 ? intval($_REQUEST['price_min']) : 0;
$price_min = $_REQUEST['price_min'];
$price_max = $_REQUEST['price_max'];
$_REQUEST['brand'] = isset($_REQUEST['brand']) ? $_REQUEST['brand'] : 0;
$brand = $ecs->get_explode_filter($_REQUEST['brand']); //过滤品牌参数
$_REQUEST['use_cou'] = isset($_REQUEST['use_cou']) ? dsc_addslashes($_REQUEST['use_cou']) : 0;
$smarty->assign('filename', "search");
$smarty->assign('search_type', $search_type);
$smarty->assign('search_keywords', stripslashes(htmlspecialchars_decode($_REQUEST['keywords'])));
/* 排序、显示方式以及类型 */
$default_sort_order_method = $_CFG['sort_order_method'] == '0' ? 'DESC' : 'ASC';
$order = (isset($_REQUEST['order']) && in_array(trim(strtoupper($_REQUEST['order'])), array('ASC', 'DESC'))) ? trim($_REQUEST['order']) : $default_sort_order_method;
$display = (isset($_REQUEST['display']) && in_array(trim(strtolower($_REQUEST['display'])), array('list', 'grid', 'text'))) ? trim($_REQUEST['display']) : (isset($_SESSION['display_search']) ? $_SESSION['display_search'] : 'list');
$_SESSION['display_search'] = $display;
if ($search_type == 1) {
if ($display == 'list') { //店铺列表
$default_sort_order_type = "shop_id";
$sort = (isset($_REQUEST['sort']) && in_array(trim(strtolower($_REQUEST['sort'])), array('shop_id', 'goods_number', 'sales_volume'))) ? trim($_REQUEST['sort']) : $default_sort_order_type;
} elseif ($display == 'grid' || $display == 'text') { //大图商品列表
$default_sort_order_type = $_CFG['sort_order_type'] == '0' ? 'goods_id' : ($_CFG['sort_order_type'] == '1' ? 'shop_price' : 'last_update');
$sort = (isset($_REQUEST['sort']) && in_array(trim(strtolower($_REQUEST['sort'])), array('goods_id', 'shop_price', 'last_update', 'sales_volume'))) ? trim($_REQUEST['sort']) : $default_sort_order_type;
}
} else {
//叮咚小愿 --zhuo start 仓库//by wang
$smarty->assign('province_row', get_region_info($province_id));
$smarty->assign('city_row', get_region_info($city_id));
$smarty->assign('district_row', get_region_info($district_id));
$province_list = get_warehouse_province();
$smarty->assign('province_list', $province_list); //省、直辖市
$city_list = get_region_city_county($province_id);
$smarty->assign('city_list', $city_list); //省下级市
$district_list = get_region_city_county($city_id);
$smarty->assign('district_list', $district_list); //市下级县
$smarty->assign('open_area_goods', $GLOBALS['_CFG']['open_area_goods']);
$default_sort_order_type = $_CFG['sort_order_type'] == '0' ? 'goods_id' : ($_CFG['sort_order_type'] == '1' ? 'shop_price' : 'last_update');
$sort = (isset($_REQUEST['sort']) && in_array(trim(strtolower($_REQUEST['sort'])), array('goods_id', 'shop_price', 'last_update', 'sales_volume', 'comments_number'))) ? trim($_REQUEST['sort']) : $default_sort_order_type;
$is_ship = isset($_REQUEST['is_ship']) && !empty($_REQUEST['is_ship']) ? addslashes_deep(trim($_REQUEST['is_ship'])) : '';
$is_self = isset($_REQUEST['is_self']) && !empty($_REQUEST['is_self']) ? intval($_REQUEST['is_self']) : '';
$have = isset($_REQUEST['have']) && !empty($_REQUEST['have']) ? intval($_REQUEST['have']) : '';
}
$page = !empty($_REQUEST['page']) && intval($_REQUEST['page']) > 0 ? intval($_REQUEST['page']) : 1;
$size = !empty($_CFG['page_size']) && intval($_CFG['page_size']) > 0 ? intval($_CFG['page_size']) : 10;
//瀑布流 by wu start
$smarty->assign('category_load_type', $_CFG['category_load_type']);
$smarty->assign('query_string', $_SERVER['QUERY_STRING']);
if (isset($_REQUEST['act']) && $_REQUEST['act'] == 'load_more_goods') {
$goods_num = empty($_REQUEST['goods_num']) ? 0 : intval($_REQUEST['goods_num']);
$best_num = empty($_REQUEST['best_num']) ? 0 : intval($_REQUEST['best_num']);
$goods_floor = floor($goods_num / 4 * 5 / 4 - $best_num);
if ($goods_floor < 0) {
$best_size = $_REQUEST['best_num'];
} else {
$best_size = $goods_floor + 2;
}
} else {
$best_num = 0;
$best_size = 6;
}
//瀑布流 by wu end
/**
* 当前分类下的所有子分类
* 返回一维数组
*/
$cat_keys = get_array_keys_cat();
/*------------------------------------------------------ */
//-- 高级搜索
/*------------------------------------------------------ */
if ($_REQUEST['act'] == 'advanced_search') {
$goods_type = !empty($_REQUEST['goods_type']) ? intval($_REQUEST['goods_type']) : 0;
$attributes = get_seachable_attributes($goods_type);
$smarty->assign('goods_type_selected', $goods_type);
$smarty->assign('goods_type_list', $attributes['cate']);
$smarty->assign('goods_attributes', $attributes['attr']);
assign_template();
assign_dynamic('search');
$position = assign_ur_here(0, $_LANG['advanced_search']);
$smarty->assign('page_title', $position['title']); // 页面标题
$smarty->assign('ur_here', $position['ur_here']); // 当前位置
$categories_pro = get_category_tree_leve_one();
$smarty->assign('categories_pro', $categories_pro); // 分类树加强版
$smarty->assign('helps', get_shop_help()); // 网店帮助
$smarty->assign('action', 'form');
$smarty->assign('use_storage', $_CFG['use_storage']);
if ($search_type == 0) {
$smarty->assign('best_goods', get_recommend_goods('best', '', $region_id, $area_info['region_id'], $area_city, 0, 1));
$smarty->display('search.dwt');
} elseif ($search_type == 1) {
$smarty->display('merchants_shop_list.dwt');
}
exit;
}
/*------------------------------------------------------ */
//-- 搜索结果
/*------------------------------------------------------ */
else {
if ($search_type == 0) { //搜索商品
$ur_here = $_LANG['search_goods'];
} elseif ($search_type == 1) { //店铺搜索
$ur_here = $_LANG['search_store'];
}
assign_template();
assign_dynamic('search');
$position = assign_ur_here(0, $ur_here . ($_REQUEST['keywords'] ? '_' . $_REQUEST['keywords'] : ''));
$smarty->assign('page_title', $position['title']); // 页面标题
$smarty->assign('ur_here', $position['ur_here']); // 当前位置
$smarty->assign('intromode', $intromode);
$smarty->assign('helps', get_shop_help()); // 网店帮助
$smarty->assign('region_id', $region_id);
$smarty->assign('area_id', $area_id);
$search_id = 0;
$where_area = '';
if ($GLOBALS['_CFG']['area_pricetype'] == 1) {
$where_area = " AND wag.city_id = '$area_city'";
}
if ($search_type == 0) { //搜索商品
$cou_id = isset($_REQUEST['cou_id']) && !empty($_REQUEST['cou_id']) ? intval($_REQUEST['cou_id']) : 0;
/* 初始化搜索条件 */
$keywords = '';
$tag_where = '';
$act_name = '';
$leftJoin = '';
$shop_price = '';
if ($brand) {
$tag_where .= " AND g.brand_id " . db_create_in($brand);
}
$insert_keyword = '';
if (!empty($_REQUEST['keywords'])) {
$arr = array();
//@author guan start
$insert_keyword = trim($_REQUEST['keywords']);
$base_insert_keyword = base64_encode($insert_keyword);
//用法：
$pin = new pin();
$pinyin = $pin->Pinyin($insert_keyword, 'UTF8');
if ($page == 1) {
$addtime = local_date('Y-m-d', gmtime());
$sql = "INSERT INTO " . $ecs->table('search_keyword') . "(keyword, pinyin, is_on, count, addtime, pinyin_keyword)VALUES('$base_insert_keyword', '', '0', '1', '$addtime', '" . base64_encode($pinyin) . "')";
$db->query($sql);
$search_id = $db->insert_id();
}
$scws_res = scws($_REQUEST['keywords'], 20); //这里可以把关键词分词：诺基亚，耳机
if ($scws_res) {
$arr = explode(',', $scws_res);
}
$arr1[] = $insert_keyword;
if ($arr1 && is_array($arr)) {
$arr = array_merge($arr1, $arr);
}
$arr_keyword = $arr;
$operator = " OR ";
//@author guan end
$arr = !empty($arr) ? array_unique($arr) : [];
$keywords = 'AND (';
$goods_ids = array();
foreach ($arr AS $key => $val) {
$val = !empty($val) ? dsc_addslashes($val) : '';
if ($val) {
if ($key > 0 && $key < count($arr) && count($arr) > 1) {
$keywords .= $operator;
}
$val = mysql_like_quote(trim($val));
$sc_dsad = $_REQUEST['sc_ds'] ? " OR goods_desc LIKE '%$val%'" : '';
$keywords .= "(g.goods_name LIKE '%$val%' OR g.goods_sn = '$val' OR g.keywords LIKE '%$val%' $sc_dsad)";
$sql = 'SELECT DISTINCT goods_id FROM ' . $ecs->table('tag') . " WHERE tag_words LIKE '%$val%' ";
$res = $db->query($sql);
while ($row = $db->FetchRow($res)) {
$goods_ids[] = $row['goods_id'];
}
$db->autoReplace($ecs->table('keywords'), array('date' => local_date('Y-m-d'),
'searchengine' => 'DSC_B2B2C', 'keyword' => addslashes(str_replace('%', '', $val)), 'count' => 1), array('count' => 1));
} else {
show_message($_LANG['not_search_goods']);
}
}
$keywords .= ')';
/* 搜索预售 */
$act_name = ' OR (';
foreach ($arr AS $key => $val) {
$val = !empty($val) ? dsc_addslashes($val) : '';
if ($val) {
if ($key > 0 && $key < count($arr) && count($arr) > 1) {
$act_name .= $operator;
}
$val = mysql_like_quote(trim($val));
$act_name .= "(pa.goods_name LIKE '%$val%')";
} else {
show_message($_LANG['not_search_goods']);
}
}
$act_name .= ')';
$goods_ids = !empty($goods_ids) ? array_unique($goods_ids) : array();
if (!empty($goods_ids)) {
$tag_where .= 'OR g.goods_id ' . db_create_in($goods_ids);
}
}
$filter_attr_str = isset($_REQUEST['filter_attr']) ? addslashes(trim($_REQUEST['filter_attr'])) : '0';
$filter_attr_str = trim(urldecode($filter_attr_str));
$filter_attr_str = preg_match('/^[\d,\.]+$/', $filter_attr_str) ? $filter_attr_str : '';
$filter_attr = empty($filter_attr_str) ? '' : explode('.', $filter_attr_str);
if (!empty($brand)) { // by zhang
$sql = "SELECT brand_name FROM " . $GLOBALS['ecs']->table('brand') . " WHERE brand_id = '$brand' LIMIT 1";
$brand_name = $db->getOne($sql);
} else {
$brand_name = '';
}
$children = '';
if ($cat_id > 0) {
$children = get_children($cat_id);
}
if ($GLOBALS['_CFG']['open_area_goods'] == 1) { //关联地区显示商品
$leftJoin .= " LEFT JOIN " . $GLOBALS['ecs']->table('link_area_goods') . " AS lag ON g.goods_id = lag.goods_id ";
$tag_where .= " AND lag.region_id = '$area_id' ";
}
if ($GLOBALS['_CFG']['review_goods'] == 1) {
$tag_where .= ' AND g.review_status > 2 ';
}
//叮咚小愿 --zhuo end
$cat['grade'] = 6;
if ($cat['grade'] > 1) {
/* 需要价格分级 */
/*
算法思路：
1、当分级大于1时，进行价格分级
2、取出该类下商品价格的最大值、最小值
3、根据商品价格的最大值来计算商品价格的分级数量级：
价格范围(不含最大值) 分级数量级
0-0.1 0.001
0.1-1 0.01
1-10 0.1
10-100 1
100-1000 10
1000-10000 100
4、计算价格跨度：
取整((最大值-最小值) / (价格分级数) / 数量级) * 数量级
5、根据价格跨度计算价格范围区间
6、查询数据库
可能存在问题：
1、
由于价格跨度是由最大值、最小值计算出来的
然后再通过价格跨度来确定显示时的价格范围区间
所以可能会存在价格分级数量不正确的问题
该问题没有证明
2、
当价格=最大值时，分级会多出来，已被证明存在
*/
if ($children) {
$row_children = "($children OR " . get_extension_goods($children) . ") AND ";
} else {
$row_children = '';
}
$sql = "SELECT min(IF(g.model_price < 1, g.shop_price, IF(g.model_price < 2, wg.warehouse_price, wag.region_price))) AS min, " .
" max(IF(g.model_price < 1, g.shop_price, IF(g.model_price < 2, wg.warehouse_price, wag.region_price))) as max " .
" FROM " . $ecs->table('goods') . " AS g " .
" LEFT JOIN " . $GLOBALS['ecs']->table('warehouse_goods') . " AS wg ON g.goods_id = wg.goods_id AND wg.region_id = '$region_id' " .
" LEFT JOIN " . $GLOBALS['ecs']->table('warehouse_area_goods') . " AS wag ON g.goods_id = wag.goods_id AND wag.region_id = '$area_id' $where_area " .
$leftJoin .
" WHERE " . $row_children . ' g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_show = 1 AND g.is_alone_sale = 1 ' . $keywords . $tag_where;
//获得当前分类下商品价格的最大值、最小值
$row = $db->getRow($sql);
// 取得价格分级最小单位级数，比如，千元商品最小以100为级数
$price_grade = 0.0001;
for ($i = -2; $i <= log10($row['max']); $i++) {
$price_grade *= 10;
}
//跨度
$dx = ceil(($row['max'] - $row['min']) / ($cat['grade']) / $price_grade) * $price_grade;
if ($dx == 0) {
$dx = $price_grade;
}
for ($i = 1; $row['min'] > $dx * $i; $i++)
;
for ($j = 1; $row['min'] > $dx * ($i - 1) + $price_grade * $j; $j++)
;
$row['min'] = $dx * ($i - 1) + $price_grade * ($j - 1);
for (; $row['max'] >= $dx * $i; $i++)
;
$row['max'] = $dx * ($i) + $price_grade * ($j - 1);
if ($children) {
$price_grade_children = "($children OR " . get_extension_goods($children) . ") AND ";
} else {
$price_grade_children = '';
}
$sql = "SELECT (FLOOR((IF(g.model_price < 1, g.shop_price, IF(g.model_price < 2, wg.warehouse_price, wag.region_price)) - $row[min]) / $dx)) AS sn, COUNT(*) AS goods_num " .
" FROM " . $ecs->table('goods') . " AS g " .
" LEFT JOIN " . $GLOBALS['ecs']->table('warehouse_goods') . " AS wg ON g.goods_id = wg.goods_id AND wg.region_id = '$region_id' " .
" LEFT JOIN " . $GLOBALS['ecs']->table('warehouse_area_goods') . " AS wag ON g.goods_id = wag.goods_id AND wag.region_id = '$area_id' $where_area " .
$leftJoin .
" WHERE " . $price_grade_children . ' g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_show = 1 AND g.is_alone_sale = 1 ' . $keywords . $price_grade_where .
$tag_where .
" GROUP BY sn ";
$price_grade = $db->getAll($sql);
//echo $price_min;
foreach ($price_grade as $key => $val) {
if ($val['sn'] != '') {
$temp_key = $key;
$price_grade[$temp_key]['goods_num'] = $val['goods_num'];
$price_grade[$temp_key]['start'] = $row['min'] + round($dx * $val['sn']);
$price_grade[$temp_key]['end'] = $row['min'] + round($dx * ($val['sn'] + 1));
$price_grade[$temp_key]['price_range'] = $price_grade[$temp_key]['start'] . ' - ' . $price_grade[$temp_key]['end'];
$price_grade[$temp_key]['formated_start'] = price_format($price_grade[$temp_key]['start']);
$price_grade[$temp_key]['formated_end'] = price_format($price_grade[$temp_key]['end']);
$price_grade[$temp_key]['url'] = $brands[$temp_key]['url'] = build_uri('search', array('bid' => $brand, 'chkw' => $_REQUEST['keywords'], 'price_min' => $price_grade[$temp_key]['start'], 'price_max' => $price_grade[$temp_key]['end'], 'filter_attr' => $filter_attr_str, 'cou_id' => $cou_id), $ur_here);
/* 判断价格区间是否被选中 */
if (isset($_REQUEST['price_min']) && $price_grade[$temp_key]['start'] == $price_min && $price_grade[$temp_key]['end'] == $price_max) {
$price_grade[$temp_key]['selected'] = 1;
} else {
$price_grade[$temp_key]['selected'] = 0;
}
}
}
if ($price_min == 0 && $price_max == 0) {
$smarty->assign('price_grade', $price_grade);
} //by zhang
}
$where_having = '';
$brand_select = '';
$brand_tag_where = '';
if ($GLOBALS['_CFG']['open_area_goods'] == 1) { //关联地区显示商品
$brand_select = " , ( SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('link_area_goods') . " as lag WHERE lag.goods_id = g.goods_id AND lag.region_id = '$area_id' LIMIT 1) AS area_goods_num ";
$where_having = " AND area_goods_num > 0 ";
}
if ($GLOBALS['_CFG']['review_goods'] == 1) {
$brand_tag_where .= ' AND g.review_status > 2 ';
}
if ($children) {
$brands_list_children = "($children OR " . 'gc.cat_id ' . db_create_in(array_unique(array_merge(array($cat_id), $cat_keys))) . ") AND";
} else {
$brands_list_children = '';
}
/* 平台品牌筛选 */
$sql = "SELECT b.brand_id, b.brand_name, b.brand_logo, COUNT(*) AS goods_num " . $brand_select .
"FROM " . $GLOBALS['ecs']->table('brand') . "AS b " .
" LEFT JOIN " . $GLOBALS['ecs']->table('goods') . " AS g ON g.brand_id = b.brand_id AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 $brand_tag_where $keywords " .
" LEFT JOIN " . $GLOBALS['ecs']->table('goods_cat') . " AS gc ON g.goods_id = gc.goods_id " .
" WHERE " . $brands_list_children . " b.is_show = 1 " .
"GROUP BY b.brand_id HAVING goods_num > 0 $where_having ORDER BY b.sort_order, b.brand_id ASC";
$brands_list = $GLOBALS['db']->getAll($sql);
//by zhang
$pin = new pin(); /* 增加获取字母类 这里实例化对象 */
$brands = array();
foreach ($brands_list AS $key => $val) {
$temp_key = $key; //by zhang
$brands[$temp_key]['brand_id'] = $val['brand_id'];
$brands[$temp_key]['brand_name'] = $val['brand_name'];
//by zhang start
$bdimg_path = "data/brandlogo/"; // 图片路径
$bd_logo = $val['brand_logo'] ? $val['brand_logo'] : ""; // 图片名称
if (empty($bd_logo)) {
$brands[$temp_key]['brand_logo'] = ""; // 获取品牌图片
} else {
$brands[$temp_key]['brand_logo'] = $bdimg_path . $bd_logo;
}
$brands[$temp_key]['brand_letters'] = strtoupper(substr($pin->Pinyin($val['brand_name'], 'UTF8'), 0, 1)); //获取品牌字母
//by zhang end
//OSS文件存储叮咚小愿 --zhuo start
if ($GLOBALS['_CFG']['open_oss'] == 1 && $brands[$temp_key]['brand_logo']) {
$bucket_info = get_bucket_info();
$brands[$temp_key]['brand_logo'] = $bucket_info['endpoint'] . $brands[$temp_key]['brand_logo'];
}
//OSS文件存储叮咚小愿 --zhuo end
$brands[$temp_key]['url'] = build_uri('search', array('bid' => $val['brand_id'], 'chkw' => $_REQUEST['keywords'], 'price_min' => $price_min, 'price_max' => $price_max, 'filter_attr' => $filter_attr_str, 'cou_id' => $cou_id), $val['brand_name']);
/* 判断品牌是否被选中 */ // by zhang
if (!strpos($brand, ",") && $brand == $brands_list[$key]['brand_id']) {
$brands[$temp_key]['selected'] = 1;
}
if (stripos($brand, ",")) {
$brand2 = explode(",", $brand);
for ($i = 0; $i < $brand2[$i]; $i++) {
if ($brand2[$i] == $brands_list[$key]['brand_id']) {
$brands[$temp_key]['selected'] = 1;
}
}
}
}
$ubrand = isset($_REQUEST['ubrand']) ? intval($_REQUEST['ubrand']) : 0;
$smarty->assign('ubrand', $ubrand);
//叮咚小愿 --zhuo end
// 分配字母 by zhang start
$letter = range('A', 'Z');
$smarty->assign('letter', $letter);
// 为0或没设置的时候 加载模板
if ($brands) {
$smarty->assign('brands', $brands);
}
$get_bd = array();
$bd = "";
$br_url = '';
foreach ($brands as $key => $value) {
if (isset($value['selected']) && value['selected'] == 1) {
$bd .= $value['brand_name'] . ",";
$get_bd[$key]['brand_id'] = $value['brand_id'];
$brand_id = "brand=" . $get_bd[$key]['brand_id'];
if (stripos($value['url'], $brand_id)) {
$get_bd[$key]['url'] = str_replace($brand_id, "brand=0", $value['url']);
}
$br_url = $get_bd[$key]['url'];
}
}
$get_brand['br_url'] = $br_url;
$get_brand['bd'] = substr($bd, 0, -1);
$smarty->assign('get_bd', $get_brand); // 品牌已选模块
//by zhang end
$g_price = array(); // 选中的价格
for ($i = 0; $i < count($price_grade); $i++) {
if (isset($price_grade[$i]['selected']) && $price_grade[$i]['selected'] == 1) {
$g_price[$i]['price_range'] = $price_grade[$i]['price_range'];
$g_price[$i]['url'] = $price_grade[$i]['url'];
$p_url = $g_price[$i]['url'];
$p_a = $get_price_min;
$p_b = $get_price_max;
if (stripos($p_url, $p_a) && stripos($p_url, $p_b)) {
if ($p_a > $p_b) {
$price = array($p_a, $p_b);
$p_a = $price[1];
$p_b = $price[0];
}
if ($p_a > 0 && $p_b > 0) {
$g_price[$i]['url'] = str_replace($p_b, 0, str_replace($p_a, 0, $p_url));
} elseif ($p_a == 0 && $p_b > 0) {
$g_price[$i]['url'] = str_replace($p_b, 0, $p_url);
}
}
break;
}
}
// 处理交换价格
if (empty($g_price) && ($price_min > 0 || $price_max > 0)) {
if ($price_min > $price_max) {
$price = array($price_min, $price_max);
$price_min = $price[1];
$price_max = $price[0];
}
$parray = array();
$parray['purl'] = build_uri('search', array('bid' => $brand, 'chkw' => $_REQUEST['keywords'], 'price_min' => 0, 'price_max' => 0, 'filter_attr' => $filter_attr_str, 'cou_id' => $cou_id), $ur_here);
$parray['min_max'] = $price_min . " - " . $price_max;
$smarty->assign('parray', $parray); // 自定义价格恢复
}
$smarty->assign('g_price', $g_price); // 价格已选模块
/* 属性筛选 */
$search_filter_attr = '';
if ($search_filter_attr > 0) {
$cat_filter_attr = explode(',', $search_filter_attr); //提取出此分类的筛选属性
$all_attr_list = array();
$attributeInfo = array();
foreach ($cat_filter_attr AS $key => $value) {
$sql = "SELECT a.attr_id, a.attr_name, a.attr_cat_type FROM " . $ecs->table('attribute') . " AS a " .
" WHERE a.attr_id = '$value' LIMIT 1";
$attributeInfo = $db->getRow($sql);
if ($attributeInfo) {
$all_attr_list[$key]['filter_attr_name'] = $attributeInfo['attr_name'];
$all_attr_list[$key]['attr_cat_type'] = $attributeInfo['attr_cat_type'];
$all_attr_list[$key]['filter_attr_id'] = $value; //by zhang
$sql = "SELECT a.attr_id, MIN(a.goods_attr_id) AS goods_id, a.attr_value AS attr_value, a.color_value FROM " .
$ecs->table('goods_attr') . " AS a " .
" WHERE a.attr_id = '$value' GROUP BY a.attr_value";
$attr_list = $db->getAll($sql);
$temp_arrt_url_arr = array();
for ($i = 0; $i < count($cat_filter_attr); $i++) { //获取当前url中已选择属性的值，并保留在数组中
$temp_arrt_url_arr[$i] = !empty($filter_attr[$i]) ? $filter_attr[$i] : 0;
}
//by zhang start
foreach ($attr_list as $k => $v) {
$temp_key = $k;
$temp_arrt_url_arr[$key] = $v['goods_id']; //为url中代表当前筛选属性的位置变量赋值,并生成以‘.’分隔的筛选属性字符串
$temp_arrt_url = implode('.', $temp_arrt_url_arr);
if (!empty($v['color_value'])) {
$arr_color2['c_value'] = $v['attr_value'];
$arr_color2['c_url'] = "#" . $v['color_value'];
$v['attr_value'] = $arr_color2;
}
$all_attr_list[$key]['attr_list'][$temp_key]['attr_value'] = $v['attr_value'];
$all_attr_list[$key]['attr_list'][$temp_key]['goods_id'] = $v['goods_id']; // 取分类ID
$all_attr_list[$key]['attr_list'][$temp_key]['url'] = build_uri('category', array('cid' => $cat_id, 'bid' => $brand, 'price_min' => $price_min, 'price_max' => $price_max, 'filter_attr' => $temp_arrt_url), $cat['cat_name']);
if (!empty($filter_attr[$key])) {
if (!stripos($filter_attr[$key], ",") && $filter_attr[$key] == $v['goods_id']) {
$all_attr_list[$key]['attr_list'][$temp_key]['selected'] = 1;
}
if (stripos($filter_attr[$key], ",")) {
$color_arr = explode(",", $filter_attr[$key]);
for ($i = 0; $i < count($color_arr); $i++) {
if ($color_arr[$i] == $v['goods_id']) {
$all_attr_list[$key]['attr_list'][$temp_key]['selected'] = 1;
}
}
}
}
}
//by zhang end
}
}
/* * -------------------多条件筛选数组处理 by zhang start-----------------------* */
// 颜色区块单独拿出
$color_list = array();
for ($i = 0; $i < count($all_attr_list) + 1; $i++) {
if ($all_attr_list[$i]['attr_cat_type'] == 1) {
for ($k = 0; $k < count($all_attr_list[$i]['attr_list']); $k++) {
$array_color = $all_attr_list[$i]['attr_list'];
if (count($array_color[$k]['attr_value']) == 1) {
$array['c_value'] = $array_color[$k]['attr_value'];
$array['c_url'] = "#FFFFFF";
$all_attr_list[$i]['attr_list'][$k]['attr_value'] = $array;
}
}
$color_list = $all_attr_list[$i];
unset($all_attr_list[$i]);
}
}
$c_array = array();
$k = "";
for ($i = 0; $i < count($color_list['attr_list']); $i++) {
if ($color_list['attr_list'][$i]['selected'] == 1) {
$c_array[$i]['filter_attr_name'] = $color_list['filter_attr_name'];
$c_array[$i]['attr_list']['attr_value'] = $color_list['attr_list'][$i]['attr_value']['c_value'];
$c_array[$i]['attr_list']['goods_id'] = $color_list['attr_list'][$i]['goods_id'];
$color_id = $c_array[$i]['attr_list']['goods_id'];
$k .= $c_array[$i]['attr_list']['attr_value'] . ","; // 取选中的名称
$color_url = $color_list['attr_list'][$i]['url'];
if (strpos($color_url, $color_id)) {
$c_array[$i]['attr_list']['url'] = str_replace($color_id, 0, $color_url);
}
$c_url = $c_array[$i]['attr_list']['url']; // 还原
}
}
// 颜色合并
$c_array = array();
$c_array['filter_attr_name'] = $color_list['filter_attr_name'];
$c_array['attr_value'] = substr($k, 0, -1);
$c_array['url'] = $c_url;
$g_array = array(); // 选中的分类( 不含颜色分类 )
for ($i = 0; $i < count($all_attr_list) + 3; $i++) {
$k = "";
for ($j = 0; $j < count($all_attr_list[$i]['attr_list']); $j++) {
if ($all_attr_list[$i]['attr_list'][$j]['selected'] == 1) {
$g_array[$i]['filter_attr_name'] = $all_attr_list[$i]['filter_attr_name'];
$g_array[$i]['attr_list']['value'] = $all_attr_list[$i]['attr_list'][$j]['attr_value'];
$g_array[$i]['attr_list']['goods_id'] = $all_attr_list[$i]['attr_list'][$j]['goods_id'];
$g_url = $all_attr_list[$i]['attr_list'][$j]['url']; // 被选中的URL
$sid = $g_array[$i]['attr_list']['goods_id']; // 被选中的ID
if (strpos($g_url, $sid)) {
$g_array[$i]['attr_list']['url'] = str_replace($sid, 0, $g_url);
}
$k .= $all_attr_list[$i]['attr_list'][$j]['attr_value'] . ",";
$g_array[$i]['g_name'] = substr($k, 0, -1);
$g_array[$i]['g_url'] = $g_array[$i]['attr_list']['url'];
}
}
}
$smarty->assign('c_array', $c_array); // 颜色已选模块
$smarty->assign('g_array', $g_array); // 其他已选模块
$smarty->assign('color_search', $color_list); // 颜色筛选模块
/* * -------------------多条件筛选数组处理 by zhang end-----------------------* */
$smarty->assign('filter_attr_list', $all_attr_list);
}
$action = '';
if (isset($_REQUEST['action']) && $_REQUEST['action'] == 'form') {
/* 要显示高级搜索栏 */
$adv_value['keywords'] = htmlspecialchars(stripcslashes($_REQUEST['keywords']));
$adv_value['brand'] = $_REQUEST['brand'];
$adv_value['price_min'] = $_REQUEST['price_min'];
$adv_value['price_max'] = $_REQUEST['price_max'];
$adv_value['category'] = $_REQUEST['category'];
$attributes = get_seachable_attributes($_REQUEST['goods_type']);
/* 将提交数据重新赋值 */
foreach ($attributes['attr'] AS $key => $val) {
if (!empty($_REQUEST['attr'][$val['id']])) {
if ($val['type'] == 2) {
$attributes['attr'][$key]['value']['from'] = !empty($_REQUEST['attr'][$val['id']]['from']) ? htmlspecialchars(stripcslashes(trim($_REQUEST['attr'][$val['id']]['from']))) : '';
$attributes['attr'][$key]['value']['to'] = !empty($_REQUEST['attr'][$val['id']]['to']) ? htmlspecialchars(stripcslashes(trim($_REQUEST['attr'][$val['id']]['to']))) : '';
} else {
$attributes['attr'][$key]['value'] = !empty($_REQUEST['attr'][$val['id']]) ? htmlspecialchars(stripcslashes(trim($_REQUEST['attr'][$val['id']]))) : '';
}
}
}
if ($_REQUEST['sc_ds']) {
$smarty->assign('scck', 'checked');
}
$smarty->assign('adv_val', $adv_value);
$smarty->assign('goods_type_list', $attributes['cate']);
$smarty->assign('goods_attributes', $attributes['attr']);
$smarty->assign('goods_type_selected', $_REQUEST['goods_type']);
$smarty->assign('action', 'form');
$smarty->assign('use_storage', $_CFG['use_storage']);
$action = 'form';
}
$category = !empty($_REQUEST['category']) ? intval($_REQUEST['category']) : 0;
$categories = '';
if (!empty($category)) {
$children = get_children($category);
$categories = ' AND ' . $children;
}
$outstock = !empty($_REQUEST['outstock']) ? " AND g.goods_number > 0 " : '';
$where_price_min = $_REQUEST['price_min'] != 0 ? " AND g.shop_price * $_SESSION[discount] >= '$_REQUEST[price_min]'" : '';
$where_price_max = $_REQUEST['price_max'] != 0 || $_REQUEST['price_min'] < 0 ? " AND g.shop_price * $_SESSION[discount] <= '$_REQUEST[price_max]'" : '';
$intromode = ''; //方式，用于决定搜索结果页标题图片
if (!empty($_REQUEST['intro'])) {
switch ($_REQUEST['intro']) {
case 'best':
$intro = ' AND g.is_best = 1';
$intromode = 'best';
$ur_here = $_LANG['best_goods'];
break;
case 'new':
$intro = ' AND g.is_new = 1';
$intromode = 'new';
$ur_here = $_LANG['new_goods'];
break;
case 'hot':
$intro = ' AND g.is_hot = 1';
$intromode = 'hot';
$ur_here = $_LANG['hot_goods'];
break;
case 'promotion':
$time = gmtime();
$intro = " AND g.promote_price > 0 AND g.promote_start_date <= '$time' AND g.promote_end_date >= '$time'";
$intromode = 'promotion';
$ur_here = $_LANG['promotion_goods'];
break;
default:
$intro = '';
}
} else {
$intro = '';
}
if (empty($ur_here)) {
$ur_here = $_LANG['search_goods'];
}
/* ------------------------------------------------------ */
//-- 属性检索
/* ------------------------------------------------------ */
$attr_in = '';
$attr_num = 0;
$attr_url = '';
$attr_arg = array();
if (!empty($_REQUEST['attr'])) {
$sql = "SELECT goods_id, COUNT(*) AS num FROM " . $ecs->table("goods_attr") . " WHERE 0 ";
foreach ($_REQUEST['attr'] AS $key => $val) {
if (is_not_null($val) && is_numeric($key)) {
$attr_num++;
$sql .= " OR (1 ";
if (is_array($val)) {
$sql .= " AND attr_id = '$key'";
if (!empty($val['from'])) {
$sql .= is_numeric($val['from']) ? " AND attr_value >= " . floatval($val['from']) : " AND attr_value >= '$val[from]'";
$attr_arg["attr[$key][from]"] = $val['from'];
$attr_url .= "&attr[$key][from]=$val[from]";
}
if (!empty($val['to'])) {
$sql .= is_numeric($val['to']) ? " AND attr_value <= " . floatval($val['to']) : " AND attr_value <= '$val[to]'";
$attr_arg["attr[$key][to]"] = $val['to'];
$attr_url .= "&attr[$key][to]=$val[to]";
}
} else {
/* 处理选购中心过来的链接 */
$sql .= isset($_REQUEST['pickout']) ? " AND attr_id = '$key' AND attr_value = '" . $val . "' " : " AND attr_id = '$key' AND attr_value LIKE '%" . mysql_like_quote($val) . "%' ";
$attr_url .= "&attr[$key]=$val";
$attr_arg["attr[$key]"] = $val;
}
$sql .= ')';
}
}
/* 如果检索条件都是无效的，就不用检索 */
if ($attr_num > 0) {
$sql .= " GROUP BY goods_id HAVING num = '$attr_num'";
$row = $db->getCol($sql);
if (count($row)) {
$attr_in = " AND " . db_create_in($row, 'g.goods_id');
} else {
$attr_in = " AND 0 ";
}
}
} elseif (isset($_REQUEST['pickout'])) {
/* 从选购中心进入的链接 */
$sql = "SELECT DISTINCT(goods_id) FROM " . $ecs->table('goods_attr');
$col = $db->getCol($sql);
//如果商店没有设置商品属性,那么此检索条件是无效的
if (!empty($col)) {
$attr_in = " AND " . db_create_in($col, 'g.goods_id');
}
}
if ($is_ship == "is_shipping") { //叮咚小愿 --zhuo
$tag_where .= " AND g.is_shipping = 1 ";
}
if ($is_self == 1) { //叮咚小愿 --zhuo
$leftJoin .= " LEFT JOIN " . $GLOBALS['ecs']->table('merchants_shop_information') . " as msi on msi.user_id = g.user_id ";
$tag_where .= " AND (g.user_id = 0 OR msi.self_run = 1) ";
}
$tag_left = '';
if ($have == 1) {
$warehouse_number = "(SELECT wg.region_number FROM " . $GLOBALS['ecs']->table('warehouse_goods') . " AS wg WHERE g.goods_id = wg.goods_id AND wg.region_id = '$region_id')";
$region_number = "(SELECT wag.region_number FROM " . $GLOBALS['ecs']->table('warehouse_area_goods') . " AS wag WHERE g.goods_id = wag.goods_id AND wag.region_id = '$area_id' $where_area)";
$tag_where .= " AND IF(g.model_price < 1, g.goods_number, IF(g.model_price < 2, " . $warehouse_number . ", " . $region_number . ")) > 0 ";
}
/* @author-bylu 优惠券商品条件 start */
$cou_goods_where = '';
$user_cou = isset($_REQUEST['user_cou']) && !empty($_REQUEST['user_cou']) ? intval($_REQUEST['user_cou']) : 0;
if ($cou_id) {
$cou_data = $db->getRow("SELECT * FROM " . $ecs->table('coupons') . " WHERE cou_id = '$cou_id'");
$cou_page_data = "&cou_id=" . $cou_id . "&use_cou=" . $user_cou; //优惠券商品搜索标记(用于分页) bylu
//如果是购物送(任务集市)
if ($cou_data['cou_type'] == 2 && empty($user_cou)) {
if (isset($_REQUEST['use_cou'])) {
//如果指定了使用的商品
$cou_goods_where = get_con_where($cou_data['ru_id'], $cou_data['cou_goods'], $cou_data['spec_cat']);
} else {
$cou_goods_where = " AND g.user_id ='" . $cou_data['ru_id'] . "' ";
if ($cou_data['cou_ok_goods']) {
$cou_goods_where .= " AND g.goods_id IN (" . $cou_data['cou_ok_goods'] . ") ";
} elseif ($cou_data['cou_ok_cat']) {
$cou_children = get_cou_children($cou_data['cou_ok_cat']);
if ($cou_children) {
$cou_goods_where .= " AND g.cat_id IN (" . $cou_children . ") ";
}
}
}
} else {
//如果指定了使用的商品
$cou_goods_where = get_con_where($cou_data['ru_id'], $cou_data['cou_goods'], $cou_data['spec_cat']);
}
$smarty->assign('cou_id', $cou_id); // 优惠券商品搜索标记(用于列表顶部类型检索) bylu
}
/* @author-bylu end */
/* 会员中心储值卡 分类跳转 */
$spec_goods_ids = isset($_REQUEST['goods_ids']) ? $_REQUEST['goods_ids'] : '';
if ($spec_goods_ids) {
$tag_where .= " AND " . db_create_in($spec_goods_ids, 'g.goods_id');
}
$leftJoin .= "LEFT JOIN " . $GLOBALS['ecs']->table('presale_activity') . " AS pa ON pa.goods_id = g.goods_id ";
//卖场
$tag_where .= get_rs_where($_COOKIE['city']);
/* 获得符合条件的商品总数 */
$sql = "SELECT COUNT(*) FROM " . $ecs->table('goods') . " AS g " .
$leftJoin .
$tag_left .
"WHERE g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 $attr_in " .
"AND (( 1 " . $categories . $keywords . $where_price_min . $where_price_max . $intro . $outstock . " ) " . $tag_where . " ) " . $act_name .
" $cou_goods_where "; //优惠券商品条件 bylu
$count = $db->getOne($sql);
//录入查询数量
if ($page == 1) {
$sql = "UPDATE" . $ecs->table('search_keyword') . "SET result_count = '$count' WHERE keyword_id = '$search_id'";
$db->query($sql);
}
$max_page = ($count > 0) ? ceil($count / $size) : 1;
if ($page > $max_page) {
$page = $max_page;
}
if ($is_self == 1) { //叮咚小愿 --zhuo
$shop_price .= " msi.self_run, ";
}
if ($sort == 'goods_id') {
$goods_sort = "IF(goods_sort > 0, goods_sort + g.sort_order, g.sort_order) $order, g.goods_id ";
} else {
$goods_sort = "g.$sort";
}
$mp_select = "(SELECT mp.user_price FROM " . $GLOBALS['ecs']->table('member_price') . " AS mp WHERE mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]') AS user_price, ";
/* 查询商品 */
$sql = "SELECT pa.act_id, pa.act_name, pa.start_time, pa.end_time, " .
"(SELECT " .
"IF((iw.goods_number + iw.user_number + iw.goods_comment_number + iw.merchants_comment_number + iw.user_attention_number) > iw.return_number, (iw.goods_number + iw.user_number + iw.goods_comment_number + iw.merchants_comment_number + iw.user_attention_number - iw.return_number), 0) " .
" AS goods_sort FROM " . $GLOBALS['ecs']->table('intelligent_weight') . " AS iw WHERE iw.goods_id = g.goods_id LIMIT 1) AS goods_sort, " .
"g.goods_id, g.is_shipping, g.user_id, g.goods_name, g.goods_number, g.shop_price, g.market_price, g.promote_price, g.is_new, g.comments_number, g.sales_volume, g.is_best, g.is_hot,g.store_new, g.store_best, g.store_hot, " .
$shop_price . " g.model_price, g.model_attr, " .
$mp_select .
"IF((SELECT COUNT(*) FROM " . $ecs->table('goods') . " AS gf WHERE gf.goods_id = g.goods_id AND goods_name LIKE '%$insert_keyword%') > 0, 0, 1) AS goods_fen, " .
"g.promote_start_date, g.promote_end_date, g.is_promote, g.goods_thumb, g.goods_img, g.goods_brief, g.goods_type, g.product_price, g.product_promote_price " .
"FROM " . $ecs->table('goods') . " AS g " .
$leftJoin .
"WHERE (g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_show = 1 AND g.is_alone_sale = 1 $attr_in $cou_goods_where " . //优惠券商品条件 bylu
"AND (( 1 " . $categories . $keywords . $where_price_min . $where_price_max . $intro . $outstock . " ) " . $tag_where . " ) ) " . $act_name . $tag_where . $where_price_min . $where_price_max .
" ORDER BY goods_fen, $goods_sort $order"; //增加表别名 g. by wanganlin
//瀑布流 by wu start
if (isset($_REQUEST['act']) && $_REQUEST['act'] == 'load_more_goods') {
$start = intval($_REQUEST['goods_num']);
} else {
$start = ($page - 1) * $size;
}
$res = $db->SelectLimit($sql, $size, $start);
//瀑布流 by wu end
//$res = $db->SelectLimit($sql, $size, ($page - 1) * $size);
$region = array(1, $province_id, $city_id, $district_id);
$idx = 0;
$arr = array();
$now = gmtime();
if ($arr_keyword) {
//unset($arr_keyword[0]);
$arr_keyword = array_values($arr_keyword);
$built_key = "<font style='color:#ec5151;'></font>"; //高亮显示HTML
//过滤掉高亮显示HTML可以匹配上的项，防止页面html错乱
foreach ($arr_keyword as $key => $val_keyword) {
if (strpos($built_key, $val_keyword) !== false) {
unset($arr_keyword[$key]);
}
}
}
while ($row = $db->FetchRow($res)) {
if ($row['model_price'] > 0) {
$sql = "SELECT warehouse_price, warehouse_promote_price, region_number FROM " . $GLOBALS['ecs']->table('warehouse_goods') . " AS wg " .
" WHERE goods_id = '" . $row['goods_id'] . "' AND wg.region_id = '$region_id'";
$warehouse_goods = $db->getRow($sql);
$sql = "SELECT region_price, region_promote_price, region_number FROM " . $GLOBALS['ecs']->table('warehouse_area_goods') . " AS wg " .
" WHERE goods_id = '" . $row['goods_id'] . "' AND wg.region_id = '$area_id' $where_area";
$warehouse_area_goods = $db->getRow($sql);
if ($row['model_price'] == 1) {
$row['org_price'] = $warehouse_goods ? $warehouse_goods['warehouse_price'] : 0;
$row['goods_number'] = $warehouse_goods ? $warehouse_goods['region_number'] : 0;
$row['promote_price'] = $warehouse_goods ? $warehouse_goods['warehouse_promote_price'] : 0;
} else {
$row['org_price'] = $warehouse_area_goods ? $warehouse_area_goods['region_price'] : 0;
$row['goods_number'] = $warehouse_area_goods ? $warehouse_area_goods['region_number'] : 0;
$row['promote_price'] = $warehouse_area_goods ? $warehouse_area_goods['promote_price'] : 0;
}
$row['shop_price'] = $row['org_price'];
}
if ($row['user_price'] && $row['user_price'] > 0) {
$row['shop_price'] = $row['user_price'];
} else {
$row['shop_price'] = $row['shop_price'] * $_SESSION['discount'];
}
$shop_info = get_shop_name($row['user_id'], 3);
$arr[$idx]['rz_shopName'] = $shop_info['shop_name']; //店铺名称
$arr[$idx]['goods_fen'] = $row['goods_fen'];
if ($row['promote_price'] > 0) {
$promote_price = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
} else {
$promote_price = 0;
}
/* 预售商品 start */
if ($row['act_id']) {
$arr[$idx]['presale'] = $_LANG['presell'];
$arr[$idx]['act_id'] = $row['act_id'];
$arr[$idx]['act_name'] = $row['act_name'];
$arr[$idx]['thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);
$arr[$idx]['goods_img'] = get_image_path($row['goods_id'], $row['goods_img']);
$arr[$idx]['purl'] = build_uri('presale', array('act' => 'view', 'presaleid' => $row['act_id']), $row['goods_name']);
$build_uri = array(
'urid' => $row['ru_id'],
'append' => $arr[$idx]['rz_shopName']
);
$domain_url = get_seller_domain_url($row['user_id'], $build_uri);
$arr[$row['shop_id']]['pshop_url'] = $domain_url['domain_name'];
$arr[$idx]['start_time_date'] = local_date('Y-m-d H:i:s', $row['start_time']);
$arr[$idx]['end_time_date'] = local_date('Y-m-d H:i:s', $row['end_time']);
//@Author guan 关键字高亮显示 start
$act_name_keyword = "<span>" . $row['act_name'] . "</span>";
foreach ($arr_keyword as $key => $val_keyword) {
$act_name_keyword = preg_replace("/(>.*)($val_keyword)(.*<)/Ui", "$1<font style='color:#ec5151;'>$val_keyword</font>\$3", $act_name_keyword);
}
$arr[$idx]['act_name_keyword'] = $act_name_keyword;
//@Author guan 关键字高亮显示 end
if ($row['start_time'] >= $now) {
$arr[$idx]['no_start'] = 1;
}
if ($row['end_time'] <= $now) {
$arr[$idx]['already_over'] = 1;
}
}
/*预售商品 end*/
/* 处理商品水印图片 */
$watermark_img = '';
if ($promote_price != 0) {
$watermark_img = "watermark_promote_small";
} elseif ($row['is_new'] != 0) {
$watermark_img = "watermark_new_small";
} elseif ($row['is_best'] != 0) {
$watermark_img = "watermark_best_small";
} elseif ($row['is_hot'] != 0) {
$watermark_img = 'watermark_hot_small';
}
if ($watermark_img != '') {
$arr[$idx]['watermark_img'] = $watermark_img;
}
$arr[$idx]['goods_id'] = $row['goods_id'];
if ($row['model_attr'] == 1) {
$table_products = "products_warehouse";
$type_files = " and warehouse_id = '$region_id'";
} elseif ($row['model_attr'] == 2) {
$table_products = "products_area";
$type_files = " and area_id = '$area_id'";
if ($GLOBALS['_CFG']['area_pricetype'] == 1) {
$type_files .= " AND city_id = '$area_city'";
}
} else {
$table_products = "products";
$type_files = "";
}
$sql = "SELECT * FROM " . $GLOBALS['ecs']->table($table_products) . " WHERE goods_id = '" . $row['goods_id'] . "'" . $type_files . " LIMIT 0, 1";
$arr[$idx]['prod'] = $GLOBALS['db']->getRow($sql);
if (empty($prod)) { //当商品没有属性库存时
$arr[$idx]['prod'] = 1;
} else {
$arr[$idx]['prod'] = 0;
}
if ($display == 'grid') {
//@Author guan 关键字高亮显示 start
$goods_name_keyword = sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']);
$goods_name_keyword = "<span>" . $row['goods_name'] . "</span>";
foreach ($arr_keyword as $key => $val_keyword) {
if (preg_match("/(>.*)($val_keyword)(.*<)/Ui", $goods_name_keyword)) {
$goods_name_keyword = preg_replace("/(>.*)($val_keyword)(.*<)/Ui", "$1<font style='color:#ec5151;'>$val_keyword</font>\$3", $row['goods_name']);
}
}
$arr[$idx]['goods_name_keyword'] = $GLOBALS['_CFG']['goods_name_length'] > 0 ? $goods_name_keyword : $goods_name_keyword;
//模版页面样式错误，为模版页面的的goods_name改为goods_name2。以防止样式错误。
$arr[$idx]['goods_name'] = $GLOBALS['_CFG']['goods_name_length'] > 0 ? $row['goods_name'] : $row['goods_name'];
//@Author guan 关键字高亮显示 end
} else {
//@Author guan 关键字高亮显示 start
$goods_name_keyword = "<span>" . $row['goods_name'] . "</span>";
foreach ($arr_keyword as $key => $val_keyword) {
if (preg_match("/(>.*)($val_keyword)(.*<)/Ui", $goods_name_keyword)) {
$goods_name_keyword = preg_replace("/(>.*)($val_keyword)(.*<)/Ui", "$1<font style='color:#ec5151;'>$val_keyword</font>\$3", $goods_name_keyword);
}
}
$arr[$idx]['goods_name_keyword'] = $goods_name_keyword;
$arr[$idx]['goods_name'] = $row['goods_name'];
//@Author guan 关键字高亮显示 end
}
$arr[$idx]['goods_number'] = $row['goods_number'];
$arr[$idx]['type'] = $row['goods_type'];
$arr[$idx]['is_promote'] = $row['is_promote'];
$arr[$idx]['sales_volume'] = $row['sales_volume'];
$arr[$idx]['market_price'] = price_format($row['market_price']);
$arr[$idx]['shop_price'] = price_format($row['shop_price']);
$arr[$idx]['promote_price'] = ($promote_price > 0) ? price_format($promote_price) : '';
$arr[$idx]['goods_brief'] = $row['goods_brief'];
$arr[$idx]['goods_thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);
$arr[$idx]['goods_img'] = get_image_path($row['goods_id'], $row['goods_img']);
$arr[$idx]['url'] = build_uri('goods', array('gid' => $row['goods_id']), $row['goods_name']);
$arr[$idx]['is_shipping'] = $row['is_shipping'];
$mc_all = ments_count_all($row['goods_id']); //总条数
$mc_one = ments_count_rank_num($row['goods_id'], 1); //一颗星
$mc_two = ments_count_rank_num($row['goods_id'], 2); //两颗星
$mc_three = ments_count_rank_num($row['goods_id'], 3); //三颗星
$mc_four = ments_count_rank_num($row['goods_id'], 4); //四颗星
$mc_five = ments_count_rank_num($row['goods_id'], 5); //五颗星
$arr[$idx]['zconments'] = get_conments_stars($mc_all, $mc_one, $mc_two, $mc_three, $mc_four, $mc_five);
$arr[$idx]['review_count'] = $arr[$idx]['zconments']['allmen'];
$arr[$idx]['pictures'] = get_goods_gallery($row['goods_id'], 6); // 商品相册
if ($GLOBALS['_CFG']['customer_service'] == 0) {
$seller_id = 0;
$shop_information = get_shop_name($seller_id); //通过ru_id获取到店铺信息;
} else {
$seller_id = $row['user_id'];
$shop_information = $shop_info['shop_information']; //通过ru_id获取到店铺信息;
}
/* @author-bylu 判断当前商家是否允许"在线客服" start */
$arr[$idx]['is_IM'] = $shop_information['is_IM']; //平台是否允许商家使用"在线客服";
//判断当前商家是平台,还是入驻商家 bylu
if ($seller_id == 0) {
//判断平台是否开启了IM在线客服
if ($GLOBALS['db']->getOne("SELECT kf_im_switch FROM " . $GLOBALS['ecs']->table('seller_shopinfo') . "WHERE ru_id = 0", true)) {
$arr[$idx]['is_dsc'] = true;
} else {
$arr[$idx]['is_dsc'] = false;
}
} else {
$arr[$idx]['is_dsc'] = false;
}
/* @author-bylu end */
$build_uri = array(
'urid' => $row['user_id'],
'append' => $arr[$idx]['rz_shopName']
);
$domain_url = get_seller_domain_url($row['user_id'], $build_uri);
$arr[$idx]['store_url'] = $domain_url['domain_name'];
$arr[$idx]['is_new'] = $row['is_new'];
$arr[$idx]['is_best'] = $row['is_best'];
$arr[$idx]['is_hot'] = $row['is_hot'];
$arr[$idx]['user_id'] = $row['user_id'];
$arr[$idx]['self_run'] = $shop_info['shopinfo']['self_run'];
//叮咚小愿 --zhuo start
$sql = "select * from " . $GLOBALS['ecs']->table('seller_shopinfo') . " where ru_id='" . $row['user_id'] . "'";
$basic_info = $GLOBALS['db']->getRow($sql);
$arr[$idx]['kf_type'] = $basic_info['kf_type'];
/* 处理客服QQ数组 by kong */
if ($basic_info['kf_qq']) {
$kf_qq = array_filter(preg_split('/\s+/', $basic_info['kf_qq']));
$kf_qq = explode("|", $kf_qq[0]);
if (!empty($kf_qq[1])) {
$arr[$idx]['kf_qq'] = $kf_qq[1];
} else {
$arr[$idx]['kf_qq'] = "";
}
} else {
$arr[$idx]['kf_qq'] = "";
}
/* 处理客服旺旺数组 by kong */
if ($basic_info['kf_ww']) {
$kf_ww = array_filter(preg_split('/\s+/', $basic_info['kf_ww']));
$kf_ww = explode("|", $kf_ww[0]);
if (!empty($kf_ww[1])) {
$arr[$idx]['kf_ww'] = $kf_ww[1];
} else {
$arr[$idx]['kf_ww'] = "";
}
} else {
$arr[$idx]['kf_ww'] = "";
}
//叮咚小愿 --zhuo end
if (!defined('THEME_EXTENSION')) {
//商品运费by wu
$shippingFee = goodsShippingFee($row['goods_id'], $region_id, $area_info['region_id'], $area_city, $region);
$arr[$idx]['shipping_fee_formated'] = $shippingFee['shipping_fee_formated'];
}
$arr[$idx]['is_collect'] = get_collect_user_goods($row['goods_id']);
$idx++;
}
if ($display == 'grid') {
if (count($arr) % 2 != 0) {
$arr[] = array();
}
}
$smarty->assign('goods_list', $arr);
$smarty->assign('category', $category);
$smarty->assign('keywords', htmlspecialchars(stripslashes($_REQUEST['keywords'])));
$smarty->assign('brand', $_REQUEST['brand']);
$smarty->assign('price_min', $price_min);
$smarty->assign('price_max', $price_max);
$smarty->assign('outstock', $_REQUEST['outstock']);
//瀑布流 by wu start
if (isset($_REQUEST['act']) && $_REQUEST['act'] == 'load_more_goods') {
$smarty->assign('model', intval($_REQUEST['model']));
$result = array('error' => 0, 'message' => '', 'cat_goods' => '', 'best_goods' => '');
$result['cat_goods'] = html_entity_decode($smarty->fetch('library/more_goods.lbi')); //分类商品
$result['best_goods'] = html_entity_decode($smarty->fetch('library/more_goods_best.lbi')); //推广商品
die(json_encode($result));
}
//瀑布流 by wu end
/* 分页 */
$url_format = "search.php?category=$category&keywords=" . urlencode(stripslashes($_REQUEST['keywords'])) . "&brand=" . $_REQUEST['brand'] . "&action=" . $action . "&goods_type=" . $_REQUEST['goods_type'] . "&sc_ds=" . $_REQUEST['sc_ds'] . $cou_page_data; //搜索优惠券商品的标记 bylu;
if (!empty($intromode)) {
$url_format .= "&intro=" . $intromode;
}
if (isset($_REQUEST['pickout'])) {
$url_format .= '&pickout=1';
}
$url_format .= "&price_min=" . $_REQUEST['price_min'] . "&price_max=" . $_REQUEST['price_max'] . "&sort=$sort";
$url_format .= "$attr_url&order=$order&page=";
$pager['search'] = array(
'keywords' => stripslashes(trim($_REQUEST['keywords'])),
'category' => $category,
'store_search_cmt' => $search_type,
'brand' => $_REQUEST['brand'],
'sort' => $sort,
'order' => $order,
'price_min' => $_REQUEST['price_min'],
'price_max' => $_REQUEST['price_max'],
'action' => $action,
'intro' => empty($intromode) ? '' : trim($intromode),
'goods_type' => $_REQUEST['goods_type'],
'sc_ds' => $_REQUEST['sc_ds'],
'outstock' => $_REQUEST['outstock'],
'is_ship' => $is_ship,
'self_support' => $is_self,
'have' => $have,
'use_cou' => $_REQUEST['use_cou'],
'cou_id' => $cou_id //优惠券商品分页标记 bylu
);
$pager['search'] = array_merge($pager['search'], $attr_arg);
$pager = get_pager('search.php', $pager['search'], $count, $page, $size);
$pager['display'] = $display;
$smarty->assign('url_format', $url_format);
$smarty->assign('pager', $pager);
$categories_pro = get_category_tree_leve_one();
$smarty->assign('categories_pro', $categories_pro); // 分类树加强版
/** 小图 start by wang头部广告 **/
for ($i = 1; $i <= $_CFG['auction_ad']; $i++) {
$search_left_ad .= "'search_left_ad" . $i . ","; //搜索商品页面头部左侧广告
$search_right_ad .= "'search_right_ad" . $i . ","; //搜索商品页面头部右侧广告
}
$smarty->assign('search_left_ad', $search_left_ad);
$smarty->assign('search_right_ad', $search_right_ad);
$smarty->assign('best_goods', get_recommend_goods('best', '', $region_id, $area_info['region_id'], $area_city, 0, 1));
$smarty->assign('guess_goods', get_guess_goods($_SESSION['user_id'], 1, 1, 5, $region_id, $area_info['region_id'], $area_city)); //猜你喜欢
$cur_url = get_return_self_url();
$smarty->assign('cur_url', $cur_url);
$smarty->assign('script_name', 'search');
$smarty->display('search.dwt');
} elseif ($search_type == 1) { //搜索店铺
$keywords = htmlspecialchars(stripcslashes($_REQUEST['keywords']));
if ($display == 'list') { //店铺列表
$count = get_store_shop_count($keywords, $sort, 0, 0, 0, '', 1);
$shop_count = $count;
$size = 10;
$store_shop_list = get_store_shop_list(1, $keywords, $count, $size, $page, $sort, $order, $region_id, $area_id, $area_city);
$smarty->assign('store_shop_list', $store_shop_list['shop_list']);
$smarty->assign('pager', $store_shop_list['pager']);
} elseif ($display == 'grid' || $display == 'text') { //大图商品列表
if ($display == 'text') {
$size = 21;
} else {
$size = 20;
}
$shop_goods_list = get_store_shop_goods_list($keywords, $size, $page, $sort, $order, $region_id, $area_id, $area_city);
$smarty->assign('shop_goods_list', $shop_goods_list);
$count = get_store_shop_goods_count($keywords, $sort);
$shop_count = $count;
}
if ($display == 'grid' || $display == 'text') {
if (defined('THEME_EXTENSION')) {
$categories_pro = get_category_tree_leve_one();
$smarty->assign('categories_pro', $categories_pro); // 分类树加强版
}
/* 分页 */
$url_format = "search.php?category=0&keywords=" . urlencode(stripslashes($_REQUEST['keywords']));
$url_format .= "&sort=$sort";
$url_format .= "&order=$order&page=";
$pager['search'] = array(
'keywords' => stripslashes(trim($_REQUEST['keywords'])),
'category' => 0,
'store_search_cmt' => $search_type,
'sort' => $sort,
'order' => $order,
);
$pager = get_pager('search.php', $pager['search'], $count, $page, $size);
$pager['display'] = $display;
$smarty->assign('url_format', $url_format);
$smarty->assign('count', $count);
$smarty->assign('page', $page);
$smarty->assign('pager', $pager);
}
$smarty->assign('size', $size);
$smarty->assign('count', $count);
$smarty->assign('display', $display);
$smarty->assign('sort', $sort);
/* * 小图 start* */
for ($i = 1; $i <= $_CFG['auction_ad']; $i++) {
$recommend_merchants .= "'recommend_merchants" . $i . ","; //新首页推荐店铺广告 liu
}
$smarty->assign('recommend_merchants', $recommend_merchants);
if (defined('THEME_EXTENSION')) {
$smarty->assign('guess_store', get_guess_store($_SESSION['user_id'], 4));
} else {
$store_best_list = get_shop_goods_count_list(0, $region_id, $area_id, $area_city, 1, 'store_best');
$smarty->assign('store_best_list', $store_best_list);
}
$smarty->assign('shop_count', $shop_count);
$cur_url = get_return_self_url();
$smarty->assign('cur_url', $cur_url);
$smarty->assign('script_name', 'merchants_shop');
$smarty->display('merchants_shop_list.dwt');
}
}
/*------------------------------------------------------ */
//-- PRIVATE FUNCTION
/*------------------------------------------------------ */
/**
*
*
* @access public
* @param
*
* @return void
*/
function is_not_null($value)
{
if (is_array($value)) {
return (!empty($value['from'])) || (!empty($value['to']));
} else {
return !empty($value);
}
}
/**
* 获得可以检索的属性
*
* @access public
* @params integer $cat_id
* @return void
*/
function get_seachable_attributes($cat_id = 0)
{
$attributes = array(
'cate' => array(),
'attr' => array()
);
/* 获得可用的商品类型 */
$sql = "SELECT t.cat_id, cat_name FROM " . $GLOBALS['ecs']->table('goods_type') . " AS t, " .
$GLOBALS['ecs']->table('attribute') . " AS a" .
" WHERE t.cat_id = a.cat_id AND t.enabled = 1 AND a.attr_index > 0 ";
$cat = $GLOBALS['db']->getAll($sql);
/* 获取可以检索的属性 */
if (!empty($cat)) {
foreach ($cat AS $val) {
$attributes['cate'][$val['cat_id']] = $val['cat_name'];
}
$where = $cat_id > 0 ? ' AND a.cat_id = ' . $cat_id : " AND a.cat_id = " . $cat[0]['cat_id'];
$sql = 'SELECT attr_id, attr_name, attr_input_type, attr_type, attr_values, attr_index, sort_order ' .
' FROM ' . $GLOBALS['ecs']->table('attribute') . ' AS a ' .
' WHERE a.attr_index > 0 ' . $where .
' ORDER BY cat_id, sort_order ASC';
$res = $GLOBALS['db']->query($sql);
while ($row = $GLOBALS['db']->FetchRow($res)) {
if ($row['attr_index'] == 1 && $row['attr_input_type'] == 1) {
$row['attr_values'] = str_replace("\r", '', $row['attr_values']);
$options = explode("\n", $row['attr_values']);
$attr_value = array();
foreach ($options AS $opt) {
$attr_value[$opt] = $opt;
}
$attributes['attr'][] = array(
'id' => $row['attr_id'],
'attr' => $row['attr_name'],
'options' => $attr_value,
'type' => 3
);
} else {
$attributes['attr'][] = array(
'id' => $row['attr_id'],
'attr' => $row['attr_name'],
'type' => $row['attr_index']
);
}
}
}
return $attributes;
}
/* 优惠券使用条件 */
function get_con_where($ru_id, $cou_goods, $spec_cat)
{
//如果指定了使用的商品
$cou_where = " AND g.user_id = '$ru_id' ";
if ($cou_goods) {
$cou_where .= " AND g.goods_id IN (" . $cou_goods . ") ";
} elseif ($spec_cat) {
$cou_children = get_cou_children($spec_cat);
if ($cou_children) {
$cou_where .= " AND g.cat_id IN (" . $cou_children . ") ";
}
}
return $cou_where;
}
?>
Loading...
举报
请认真填写举报原因，尽可能描述详细。
请选择举报类型
误判申诉
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化