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); }