public function indexOp()
{
$model_xianshi_goods = Model('p_xianshi_goods');
$model_goods = Model('goods');
$condition = array();
$condition['state'] = 1;
$condition['start_time'] = array('elt', TIMESTAMP);
$condition['end_time'] = array('gt', TIMESTAMP);
if ($_GET['gc_id']) {
$condition['gc_id_1'] = intval($_GET['gc_id']);
}
$goods_list = $model_xianshi_goods->getXianshiGoodsExtendList($condition, self::PAGESIZE, 'xianshi_goods_id desc');
$total_page = pagecmd('gettotalpage');
if (intval($_GET['curpage'] > $total_page)) {
exit;
}
$xs_goods_list = array();
foreach ($goods_list as $k => $goods_info) {
$xs_goods_list[$goods_info['goods_id']] = $goods_info;
$xs_goods_list[$goods_info['goods_id']]['image_url_240'] = cthumb($goods_info['goods_image'], 240, $goods_info['store_id']);
$xs_goods_list[$goods_info['goods_id']]['down_price'] = $goods_info['goods_price'] - $goods_info['xianshi_price'];
}
$condition = array('goods_id' => array('in', array_keys($xs_goods_list)));
$goods_list = $model_goods->getGoodsOnlineList($condition, 'goods_id,gc_id_1,evaluation_good_star,store_id,store_name', 0, '', self::PAGESIZE, null, false);
foreach ($goods_list as $k => $goods_info) {
$xs_goods_list[$goods_info['goods_id']]['evaluation_good_star'] = $goods_info['evaluation_good_star'];
$xs_goods_list[$goods_info['goods_id']]['store_name'] = $goods_info['store_name'];
if ($xs_goods_list[$goods_info['goods_id']]['gc_id_1'] != $goods_info['gc_id_1']) {
//兼容以前版本，如果限时商品表没有保存一级分类ID，则马上保存
$model_xianshi_goods->editXianshiGoods(array('gc_id_1' => $goods_info['gc_id_1']), array('xianshi_goods_id' => $xs_goods_list[$goods_info['goods_id']]['xianshi_goods_id']));
}
}
//查询商品评分信息
$goodsevallist = Model("evaluate_goods")->getEvaluateGoodsList(array('geval_goodsid' => array('in', array_keys($xs_goods_list))));
$eval_list = array();
if (!empty($goodsevallist)) {
foreach ($goodsevallist as $v) {
if ($v['geval_content'] == '' || count($eval_list[$v['geval_goodsid']]) >= 2) {
continue;
}
$eval_list[$v['geval_goodsid']][] = $v;
}
}
Tpl::output('goodsevallist', $eval_list);
Tpl::output('goods_list', $xs_goods_list);
if (!empty($_GET['curpage'])) {
Tpl::showpage('promotion.item', 'null_layout');
} else {
//导航
$nav_link = array(0 => array('title' => Language::get('homepage'), 'link' => SHOP_SITE_URL), 1 => array('title' => '限时折扣'));
Tpl::output('nav_link_list', $nav_link);
//查询商品分类
$goods_class = Model('goods_class')->getGoodsClassListByParentId(0);
Tpl::output('goods_class', $goods_class);
Tpl::output('total_page', pagecmd('gettotalpage'));
Tpl::showpage('promotion');
}
}
public function buildSelectSql($options = array())
{
if (is_numeric($options['page'])) {
$page = pagecmd("obj");
if ($options['limit'] !== 1) {
$options['limit'] = $page->getLimitStart() . "," . $page->getEachNum();
}
}
$sql = $this->parseSql($this->selectSql, $options);
return $sql;
}
/**
* 商品列表
*/
public function goods_listOp() {
$model_goods = Model('goods');
$model_search = Model('search');
//查询条件
$condition = array();
if(!empty($_GET['gc_id']) && intval($_GET['gc_id']) > 0) {
$condition['gc_id'] = $_GET['gc_id'];
} elseif (!empty($_GET['keyword'])) {
$condition['goods_name|goods_jingle'] = array('like', '%' . $_GET['keyword'] . '%');
}
//所需字段
$fieldstr = "goods_id,goods_commonid,store_id,goods_name,goods_price,goods_marketprice,goods_image,goods_salenum,evaluation_good_star,evaluation_count";
// 添加3个状态字段
$fieldstr .= ',is_virtual,is_presell,is_fcode,have_gift';
//排序方式
$order = $this->_goods_list_order($_GET['key'], $_GET['order']);
//优先从全文索引库里查找
list($indexer_ids,$indexer_count) = $model_search->indexerSearch($_GET,$this->page);
if (is_array($indexer_ids)) {
//商品主键搜索
$goods_list = $model_goods->getGoodsOnlineList(array('goods_id'=>array('in',$indexer_ids)), $fieldstr, 0, $order, $this->page, null, false);
//如果有商品下架等情况，则删除下架商品的搜索索引信息
if (count($goods_list) != count($indexer_ids)) {
$model_search->delInvalidGoods($goods_list, $indexer_ids);
}
pagecmd('setEachNum',$this->page);
pagecmd('setTotalNum',$indexer_count);
} else {
$goods_list = $model_goods->getGoodsListByColorDistinct($condition, $fieldstr, $order, $this->page);
}
$page_count = $model_goods->gettotalpage();
//处理商品列表(抢购、限时折扣、商品图片)
$goods_list = $this->_goods_list_extend($goods_list);
output_data(array('goods_list' => $goods_list), mobile_page($page_count));
}
/**
* 商品列表
*/
public function goods_listOp()
{
$model_goods = Model('goods');
$model_search = Model('search');
$_GET['is_book'] = 0;
//查询条件
$condition = array();
// ==== 暂时不显示定金预售商品，手机端未做。 ====
$condition['is_book'] = 0;
// ==== 暂时不显示定金预售商品，手机端未做。 ====
if (!empty($_GET['gc_id']) && intval($_GET['gc_id']) > 0) {
$condition['gc_id'] = $_GET['gc_id'];
} elseif (!empty($_GET['keyword'])) {
$condition['goods_name|goods_jingle'] = array('like', '%' . $_GET['keyword'] . '%');
} elseif (!empty($_GET['barcode'])) {
$condition['goods_barcode'] = $_GET['barcode'];
} elseif (!empty($_GET['b_id']) && intval($_GET['b_id'] > 0)) {
$condition['brand_id'] = intval($_GET['b_id']);
}
//所需字段
$fieldstr = "goods_id,goods_commonid,store_id,goods_name,goods_price,goods_promotion_price,goods_promotion_type,goods_marketprice,goods_image,goods_salenum,evaluation_good_star,evaluation_count";
// 添加3个状态字段
$fieldstr .= ',is_virtual,is_presell,is_fcode,have_gift';
//排序方式
$order = $this->_goods_list_order($_GET['key'], $_GET['order']);
//优先从全文索引库里查找
list($goods_list, $indexer_count) = $model_search->indexerSearch($_GET, $this->page);
if (!is_null($goods_list)) {
$goods_list = array_values($goods_list);
pagecmd('setEachNum', $this->page);
pagecmd('setTotalNum', $indexer_count);
} else {
$goods_list = $model_goods->getGoodsListByColorDistinct($condition, $fieldstr, $order, $this->page);
}
$page_count = $model_goods->gettotalpage();
//处理商品列表(团购、限时折扣、商品图片)
$goods_list = $this->_goods_list_extend($goods_list);
output_data(array('goods_list' => $goods_list), mobile_page($page_count));
}
/**
* GET 用户所有关注人
*/
public function followingOp()
{
$friend_model = Model('sns_friend');
//关注列表
$page = new Page();
pagecmd('setEachNum', $this->page);
$field = 'member_id,member_name,member_avatar,member_sex,friend_followstate';
$follow_list = $friend_model->listFriend(array('friend_frommid' => $this->member_id), $field, $page, 'detail');
if (!empty($follow_list)) {
foreach ($follow_list as $k => $v) {
$v['member_avatar'] = getMemberAvatar($v['member_avatar']);
$v['sex_class'] = $this->m_sex($v['member_sex']);
$follow_list[$k] = $v;
}
}
$pageCount = pagecmd('gettotalpage', $this->page);
output_data(array('followings' => $follow_list), mobile_page($pageCount));
}
/**
* GET 相册图片列表
*
*/
public function album_picOp()
{
$model = Model();
$where = array();
if (intval($_GET['class_id']) > 0) {
$where['ac_id'] = intval($_GET['class_id']);
}
$where['member_id'] = $this->member_id;
$m_albumpic = $model->table('sns_albumpic')->where($where);
//设置每页数量和总数！！！
pagecmd('setEachNum', $this->page);
pagecmd('setTotalNum', $m_albumpic->count());
$pageCount = $m_albumpic->gettotalpage();
$pic_list = $m_albumpic->page($this->page)->select();
output_data(array('pic_list' => $pic_list), mobile_page($pageCount));
}
public function buildSelectSql($options = array())
{
if (is_numeric($options['page'])) {
$page = pagecmd('obj');
if ($options['limit'] !== 1) {
$options['limit'] = $page->getLimitStart() . "," . $page->getEachNum();
}
}
$sql = $this->parseSql($this->selectSql, $options);
$sql .= $this->parseLock(isset($options['lock']) ? $options['lock'] : false);
return $sql;
}
public function indexOp()
{
Language::read('home_goods_class_index');
$this->_model_search = Model('search');
//显示左侧分类
//默认分类，从而显示相应的属性和品牌
$default_classid = intval($_GET['cate_id']);
if (intval($_GET['cate_id']) > 0) {
$goods_class_array = $this->_model_search->getLeftCategory(array($_GET['cate_id']));
} elseif ($_GET['keyword'] != '') {
//从TAG中查找分类
$goods_class_array = $this->_model_search->getTagCategory($_GET['keyword']);
//取出第一个分类作为默认分类，从而显示相应的属性和品牌
$default_classid = $goods_class_array[0];
$goods_class_array = $this->_model_search->getLeftCategory($goods_class_array, 1);
}
Tpl::output('goods_class_array', $goods_class_array);
Tpl::output('default_classid', $default_classid);
//优先从全文索引库里查找
list($indexer_ids, $indexer_count) = $this->_model_search->indexerSearch($_GET, self::PAGESIZE);
//获得经过属性过滤的商品信息 v3-b12
list($goods_param, $brand_array, $initial_array, $attr_array, $checked_brand, $checked_attr) = $this->_model_search->getAttr($_GET, $default_classid);
Tpl::output('brand_array', $brand_array);
Tpl::output('initial_array', $initial_array);
Tpl::output('attr_array', $attr_array);
Tpl::output('checked_brand', $checked_brand);
Tpl::output('checked_attr', $checked_attr);
//处理排序
$order = 'is_own_shop desc,goods_id desc';
if (in_array($_GET['key'], array('1', '2', '3'))) {
$sequence = $_GET['order'] == '1' ? 'asc' : 'desc';
$order = str_replace(array('1', '2', '3'), array('goods_salenum', 'goods_click', 'goods_promotion_price'), $_GET['key']);
$order .= ' ' . $sequence;
}
$model_goods = Model('goods');
// 字段
$fields = "goods_id,goods_commonid,goods_name,goods_jingle,gc_id,store_id,store_name,goods_price,goods_promotion_price,goods_promotion_type,goods_marketprice,goods_storage,goods_image,goods_freight,goods_salenum,color_id,evaluation_good_star,evaluation_count,is_virtual,is_fcode,is_appoint,is_presell,have_gift";
$condition = array();
if (is_array($indexer_ids)) {
//商品主键搜索
$condition['goods_id'] = array('in', $indexer_ids);
$goods_list = $model_goods->getGoodsOnlineList($condition, $fields, 0, $order, self::PAGESIZE, null, false);
//如果有商品下架等情况，则删除下架商品的搜索索引信息
if (count($goods_list) != count($indexer_ids)) {
$this->_model_search->delInvalidGoods($goods_list, $indexer_ids);
}
pagecmd('setEachNum', self::PAGESIZE);
pagecmd('setTotalNum', $indexer_count);
} else {
//执行正常搜索
if (isset($goods_param['class'])) {
$condition['gc_id_' . $goods_param['class']['depth']] = $goods_param['class']['gc_id'];
}
if (intval($_GET['b_id']) > 0) {
$condition['brand_id'] = intval($_GET['b_id']);
}
if ($_GET['keyword'] != '') {
$condition['goods_name|goods_jingle'] = array('like', '%' . $_GET['keyword'] . '%');
}
if (intval($_GET['area_id']) > 0) {
$condition['areaid_1'] = intval($_GET['area_id']);
}
if ($_GET['type'] == 1) {
$condition['is_own_shop'] = 1;
}
if ($_GET['gift'] == 1) {
$condition['have_gift'] = 1;
}
if (isset($goods_param['goodsid_array'])) {
$condition['goods_id'] = array('in', $goods_param['goodsid_array']);
}
$goods_list = $model_goods->getGoodsListByColorDistinct($condition, $fields, $order, self::PAGESIZE);
}
Tpl::output('show_page1', $model_goods->showpage(4));
Tpl::output('show_page', $model_goods->showpage(5));
// 商品多图
if (!empty($goods_list)) {
$commonid_array = array();
// 商品公共id数组
$storeid_array = array();
// 店铺id数组
foreach ($goods_list as $value) {
$commonid_array[] = $value['goods_commonid'];
$storeid_array[] = $value['store_id'];
}
$commonid_array = array_unique($commonid_array);
$storeid_array = array_unique($storeid_array);
// 商品多图
$goodsimage_more = Model('goods')->getGoodsImageList(array('goods_commonid' => array('in', $commonid_array)));
// 店铺
$store_list = Model('store')->getStoreMemberIDList($storeid_array);
//搜索的关键字
$search_keyword = trim($_GET['keyword']);
foreach ($goods_list as $key => $value) {
// 商品多图
//v3-b11 商品列表主图限制不越过5个
$n = 0;
foreach ($goodsimage_more as $v) {
if ($value['goods_commonid'] == $v['goods_commonid'] && $value['store_id'] == $v['store_id'] && $value['color_id'] == $v['color_id']) {
$n++;
$goods_list[$key]['image'][] = $v;
if ($n >= 5) {
break;
}
}
}
// 店铺的开店会员编号
$store_id = $value['store_id'];
$goods_list[$key]['member_id'] = $store_list[$store_id]['member_id'];
$goods_list[$key]['store_domain'] = $store_list[$store_id]['store_domain'];
//将关键字置红
if ($search_keyword) {
$goods_list[$key]['goods_name_highlight'] = str_replace($search_keyword, '<font style="color:#f00;">' . $search_keyword . '</font>', $value['goods_name']);
} else {
$goods_list[$key]['goods_name_highlight'] = $value['goods_name'];
}
}
}
Tpl::output('goods_list', $goods_list);
if ($_GET['keyword'] != '') {
Tpl::output('show_keyword', $_GET['keyword']);
} else {
Tpl::output('show_keyword', $goods_param['class']['gc_name']);
}
$model_goods_class = Model('goods_class');
// SEO
if ($_GET['keyword'] == '') {
$seo_class_name = $goods_param['class']['gc_name'];
if (is_numeric($_GET['cate_id']) && empty($_GET['keyword'])) {
$seo_info = $model_goods_class->getKeyWords(intval($_GET['cate_id']));
if (empty($seo_info[1])) {
$seo_info[1] = C('site_name') . ' - ' . $seo_class_name;
}
Model('seo')->type($seo_info)->param(array('name' => $seo_class_name))->show();
}
} elseif ($_GET['keyword'] != '') {
Tpl::output('html_title', (empty($_GET['keyword']) ? '' : $_GET['keyword'] . ' - ') . C('site_name') . L('nc_common_search'));
}
// 当前位置导航
$nav_link_list = $model_goods_class->getGoodsClassNav(intval($_GET['cate_id']));
Tpl::output('nav_link_list', $nav_link_list);
// 得到自定义导航信息
$nav_id = intval($_GET['nav_id']) ? intval($_GET['nav_id']) : 0;
Tpl::output('index_sign', $nav_id);
// 地区
$province_array = Model('area')->getTopLevelAreas();
Tpl::output('province_array', $province_array);
loadfunc('search');
// 浏览过的商品
$viewed_goods = Model('goods_browse')->getViewedGoodsList($_SESSION['member_id'], 20);
Tpl::output('viewed_goods', $viewed_goods);
Tpl::showpage('search');
}
public function indexOp()
{
Language::read('home_goods_class_index');
$this->_model_search = Model('search');
//优先从全文索引库里查找
list($indexer_ids, $indexer_count) = $this->_indexer_search();
$data_attr = $this->_get_attr_list();
//处理排序
$order = 'goods_id desc';
if (in_array($_GET['key'], array('1', '2', '3'))) {
$sequence = $_GET['order'] == '1' ? 'asc' : 'desc';
$order = str_replace(array('1', '2', '3'), array('goods_salenum', 'goods_click', 'goods_price'), $_GET['key']);
$order .= ' ' . $sequence;
}
$model_goods = Model('goods');
if (!isset($data_attr['sign']) || $data_attr['sign'] === true) {
// 字段
$fields = "goods_id,goods_commonid,goods_name,goods_jingle,gc_id,store_id,store_name,goods_price,goods_marketprice,goods_storage,goods_image,goods_freight,goods_salenum,color_id,evaluation_good_star,evaluation_count";
$condition = array();
if (is_array($indexer_ids)) {
//商品主键搜索
$condition['goods_id'] = array('in', $indexer_ids);
$goods_list = $model_goods->getGoodsOnlineList($condition, $fields, 0, $order, self::PAGESIZE, null, false);
pagecmd('setEachNum', self::PAGESIZE);
pagecmd('setTotalNum', $indexer_count);
} else {
//执行正常搜索
if (isset($data_attr['gcid_array'])) {
$condition['gc_id'] = array('in', $data_attr['gcid_array']);
}
if (intval($_GET['b_id']) > 0) {
$condition['brand_id'] = intval($_GET['b_id']);
}
if ($_GET['keyword'] != '') {
$condition['goods_name|goods_jingle'] = array('like', '%' . $_GET['keyword'] . '%');
}
if (intval($_GET['area_id']) > 0) {
$condition['areaid_1'] = intval($_GET['area_id']);
}
if (in_array($_GET['type'], array(1, 2))) {
if ($_GET['type'] == 1) {
$condition['store_id'] = DEFAULT_PLATFORM_STORE_ID;
} else {
if ($_GET['type'] == 2) {
$condition['store_id'] = array('neq', DEFAULT_PLATFORM_STORE_ID);
}
}
}
if (isset($data_attr['goodsid_array'])) {
$condition['goods_id'] = array('in', $data_attr['goodsid_array']);
}
$goods_list = $model_goods->getGoodsListByColorDistinct($condition, $fields, $order, self::PAGESIZE);
}
Tpl::output('show_page1', $model_goods->showpage(4));
Tpl::output('show_page', $model_goods->showpage(5));
// 商品多图
if (!empty($goods_list)) {
$goodsid_array = array();
// 商品id数组
$commonid_array = array();
// 商品公共id数组
$storeid_array = array();
// 店铺id数组
foreach ($goods_list as $value) {
$goodsid_array[] = $value['goods_id'];
$commonid_array[] = $value['goods_commonid'];
$storeid_array[] = $value['store_id'];
}
$goodsid_array = array_unique($goodsid_array);
$commonid_array = array_unique($commonid_array);
$storeid_array = array_unique($storeid_array);
// 商品多图
$goodsimage_more = Model('goods')->getGoodsImageList(array('goods_commonid' => array('in', $commonid_array)));
// 店铺
$store_list = Model('store')->getStoreMemberIDList($storeid_array);
// 团购
if (C('groupbuy_allow')) {
$groupbuy_list = Model('groupbuy')->getGroupbuyListByGoodsCommonIDString(implode(',', $commonid_array));
}
if (C('promotion_allow')) {
// 限时折扣
$xianshi_list = Model('p_xianshi_goods')->getXianshiGoodsListByGoodsString(implode(',', $goodsid_array));
}
foreach ($goods_list as $key => $value) {
// 商品多图
foreach ($goodsimage_more as $v) {
if ($value['goods_commonid'] == $v['goods_commonid'] && $value['store_id'] == $v['store_id'] && $value['color_id'] == $v['color_id']) {
$goods_list[$key]['image'][] = $v;
}
}
// 店铺的开店会员编号
$store_id = $value['store_id'];
$goods_list[$key]['member_id'] = $store_list[$store_id]['member_id'];
$goods_list[$key]['store_domain'] = $store_list[$store_id]['store_domain'];
// 团购
if (isset($groupbuy_list[$value['goods_commonid']])) {
$goods_list[$key]['goods_price'] = $groupbuy_list[$value['goods_commonid']]['groupbuy_price'];
$goods_list[$key]['group_flag'] = true;
}
if (isset($xianshi_list[$value['goods_id']]) && !$goods_list[$key]['group_flag']) {
$goods_list[$key]['goods_price'] = $xianshi_list[$value['goods_id']]['xianshi_price'];
$goods_list[$key]['xianshi_flag'] = true;
}
}
}
Tpl::output('goods_list', $goods_list);
}
Tpl::output('class_name', @$data_attr['gc_name']);
//显示左侧分类
if (intval($_GET['cate_id']) > 0) {
$goods_class_array = $this->_model_search->getLeftCategory(array($_GET['cate_id']));
} elseif ($_GET['keyword'] != '') {
$goods_class_array = $this->_model_search->getTagCategory($_GET['keyword']);
}
Tpl::output('goods_class_array', $goods_class_array);
if ($_GET['keyword'] == '') {
//不显示无商品的搜索项
if (C('fullindexer.open')) {
$data_attr['brand_array'] = $this->_model_search->delInvalidBrand($data_attr['brand_array']);
$data_attr['attr_array'] = $this->_model_search->delInvalidAttr($data_attr['attr_array']);
}
}
//抛出搜索属性
Tpl::output('brand_array', $data_attr['brand_array']);
Tpl::output('attr_array', $data_attr['attr_array']);
// Tpl::output('cate_array',$data_attr['cate_array']);
Tpl::output('checked_brand', $data_attr['checked_brand']);
Tpl::output('checked_attr', $data_attr['checked_attr']);
$model_goods_class = Model('goods_class');
// SEO
if ($_GET['keyword'] == '') {
$seo_class_name = @$data_attr['gc_name'];
if (is_numeric($_GET['cate_id']) && empty($_GET['keyword'])) {
$seo_info = $model_goods_class->getKeyWords(intval($_GET['cate_id']));
if (empty($seo_info[1])) {
$seo_info[1] = C('site_name') . ' - ' . $seo_class_name;
}
Model('seo')->type($seo_info)->param(array('name' => $seo_class_name))->show();
} elseif ($_GET['keyword'] != '') {
Tpl::output('html_title', (empty($_GET['keyword']) ? '' : $_GET['keyword'] . ' - ') . C('site_name') . L('nc_common_search'));
}
}
// 当前位置导航
$nav_link_list = $model_goods_class->getGoodsClassNav(intval($_GET['cate_id']));
Tpl::output('nav_link_list', $nav_link_list);
// 得到自定义导航信息
$nav_id = intval($_GET['nav_id']) ? intval($_GET['nav_id']) : 0;
Tpl::output('index_sign', $nav_id);
// 地区
require BASE_DATA_PATH . '/area/area.php';
Tpl::output('area_array', $area_array);
loadfunc('search');
// 浏览过的商品
$viewed_goods = $model_goods->getViewedGoodsList();
Tpl::output('viewed_goods', $viewed_goods);
Tpl::showpage('search');
}
public function buildSelectSql($options = array())
{
if (is_numeric($options['page'])) {
$page = pagecmd('obj');
if ($options['limit'] !== 1) {
$options['limit'] = $page->getLimitStart() . "," . $page->getEachNum();
}
}
$presql = $this->selectSql;
if (isset($options['field'])) {
$fields = explode(',', $options['field']);
$flag = false;
for ($i = 0; $i < count($fields); $i++) {
if (strpos(strtolower($fields[$i]), 'count(') < 0) {
$flag = true;
}
}
} else {
$flag = true;
}
if (!$flag) {
$presql = $this->selectSqlSimple;
}
$sql = $this->parseSql($presql, $options);
$sql .= $this->parseLock(isset($options['lock']) ? $options['lock'] : false);
return $sql;
}
public function buildSelectSql($options = array())
{
if (is_numeric($options['page'])) {
$page = pagecmd('obj');
if ($options['limit'] !== 1) {
$options['limit'] = $page->getLimitStart() . "," . $page->getEachNum();
}
}
if ($options['attr'] != 'FOR UPDATE') {
$func = 'parseSql';
} else {
$func = 'parseSql2';
}
$sql = $this->{$func}($this->selectSql, $options);
return $sql;
}
public function daigousdOp()
{
if (empty($_GET['stype'])) {
$s_type = '1';
} else {
$s_type = $_GET['stype'];
}
if ($s_type == '1') {
$string = '商店';
} else {
$string = '产品';
}
if (intval($_GET['count']) > 0) {
//获取国家值
$dbs = Model('count')->getCountInfo(array('count_id' => $_GET['count']), 'count_name');
$count_name = $dbs['count_name'];
} else {
$count_name = '国家';
}
Tpl::output('count_name', $count_name);
Tpl::output('string', $string);
Tpl::output('stype', $s_type);
$this->_model_search = Model('search');
//优先从全文索引库里查找
list($indexer_ids, $indexer_count) = $this->_indexer_search();
$data_attr = $this->_get_attr_list();
//处理排序
$order = 'goods_id desc';
if (in_array($_GET['key'], array('1', '2', '3'))) {
$sequence = $_GET['order'] == '1' ? 'asc' : 'desc';
$order = str_replace(array('1', '2', '3'), array('goods_salenum', 'goods_click', 'goods_price'), $_GET['key']);
$order .= ' ' . $sequence;
}
$model_goods = Model('goods');
if (!isset($data_attr['sign']) || $data_attr['sign'] === true) {
// 字段
$fields = "goods_id,goods_commonid,goods_name,goods_jingle,gc_id,store_id,store_name,goods_price,goods_marketprice,goods_storage,goods_image,goods_freight,goods_salenum,color_id,evaluation_good_star,evaluation_count";
$condition = array();
if (is_array($indexer_ids)) {
//商品主键搜索
$condition['goods_id'] = array('in', $indexer_ids);
$goods_list = $model_goods->getGoodsOnlineList($condition, $fields, 0, $order, self::PAGESIZE, null, false);
pagecmd('setEachNum', self::PAGESIZE);
pagecmd('setTotalNum', $indexer_count);
} else {
if (intval($_GET['count']) > 0) {
$condition['goods_count'] = intval($_GET['count']);
}
//执行正常搜索
if (isset($data_attr['gcid_array'])) {
$condition['gc_id'] = array('in', $data_attr['gcid_array']);
}
if (intval($_GET['b_id']) > 0) {
$condition['brand_id'] = intval($_GET['b_id']);
}
if ($_GET['keyword'] != '') {
$condition['goods_name|goods_jingle'] = array('like', '%' . $_GET['keyword'] . '%');
}
if (intval($_GET['area_id']) > 0) {
$condition['areaid_1'] = intval($_GET['area_id']);
}
$condition['store_id'] = '3';
if (isset($data_attr['goodsid_array'])) {
$condition['goods_id'] = array('in', $data_attr['goodsid_array']);
}
$goods_list = $model_goods->getGoodsListByColorDistinct($condition, $fields, $order, self::PAGESIZE);
}
Tpl::output('show_page1', $model_goods->showpage(4));
Tpl::output('show_page', $model_goods->showpage(6));
// 商品多图
if (!empty($goods_list)) {
$goodsid_array = array();
// 商品id数组
$commonid_array = array();
// 商品公共id数组
$storeid_array = array();
// 店铺id数组
foreach ($goods_list as $value) {
$goodsid_array[] = $value['goods_id'];
$commonid_array[] = $value['goods_commonid'];
$storeid_array[] = $value['store_id'];
}
$goodsid_array = array_unique($goodsid_array);
$commonid_array = array_unique($commonid_array);
$storeid_array = array_unique($storeid_array);
// 商品多图
$goodsimage_more = Model('goods')->getGoodsImageList(array('goods_commonid' => array('in', $commonid_array)));
// 店铺
$store_list = Model('store')->getStoreMemberIDList($storeid_array);
foreach ($goods_list as $key => $value) {
// 商品多图
foreach ($goodsimage_more as $v) {
if ($value['goods_commonid'] == $v['goods_commonid'] && $value['store_id'] == $v['store_id'] && $value['color_id'] == $v['color_id']) {
$goods_list[$key]['image'][] = $v;
}
}
// 店铺的开店会员编号
$store_id = $value['store_id'];
$goods_list[$key]['member_id'] = $store_list[$store_id]['member_id'];
$goods_list[$key]['store_domain'] = $store_list[$store_id]['store_domain'];
// 团购
if (isset($groupbuy_list[$value['goods_commonid']])) {
$goods_list[$key]['goods_price'] = $groupbuy_list[$value['goods_commonid']]['groupbuy_price'];
$goods_list[$key]['group_flag'] = true;
}
if (isset($xianshi_list[$value['goods_id']]) && !$goods_list[$key]['group_flag']) {
$goods_list[$key]['goods_price'] = $xianshi_list[$value['goods_id']]['xianshi_price'];
$goods_list[$key]['xianshi_flag'] = true;
}
}
}
Tpl::output('goods_list', $goods_list);
}
Tpl::output('class_name', @$data_attr['gc_name']);
//显示左侧分类
if (intval($_GET['cate_id']) > 0) {
$goods_class_array = $this->_model_search->getLeftCategory(array($_GET['cate_id']));
} elseif ($_GET['keyword'] != '') {
$goods_class_array = $this->_model_search->getTagCategory($_GET['keyword']);
}
Tpl::output('goods_class_array', $goods_class_array);
if ($_GET['keyword'] == '') {
//不显示无商品的搜索项
if (C('fullindexer.open')) {
$data_attr['brand_array'] = $this->_model_search->delInvalidBrand($data_attr['brand_array']);
$data_attr['attr_array'] = $this->_model_search->delInvalidAttr($data_attr['attr_array']);
}
}
//抛出搜索属性
Tpl::output('brand_array', $data_attr['brand_array']);
Tpl::output('attr_array', $data_attr['attr_array']);
// Tpl::output('cate_array',$data_attr['cate_array']);
Tpl::output('checked_brand', $data_attr['checked_brand']);
Tpl::output('checked_attr', $data_attr['checked_attr']);
$model_goods_class = Model('goods_class');
loadfunc('search');
//商品类型
$goods_class = Model('goods_class');
$goods_type = $model_goods_class->table('goods_class')->where(array('gc_parent_id' => '959'))->order('gc_sort asc')->select();
Tpl::output('goods_type', $goods_type);
//当前商品类型
$cate_id = $_GET['cate_id'];
if ($cate_id !== '0') {
$scate_id = $model_goods_class->where(array('gc_id' => $cate_id))->find();
$scate_data = $scate_id['gc_name'];
} else {
$scate_data = '产品';
}
Tpl::output('scate_data', $scate_data);
//获取国家
$count = Model()->table('count')->where()->order('count_id asc')->select();
Tpl::output('count', $count);
//品牌
$model = Model('brand');
$brand = $model->table('brand')->where(array('brand_apply' => '1', 'class_id' => '959'))->order('brand_sort asc')->select();
// print_r($brand);
Tpl::output('brand', $brand);
Tpl::output('index_sign', 'daigou');
Tpl::showpage('daigou2');
}
public function showpage($style = NULL)
{
return pagecmd("show", $style);
}
