/**
* 对查询参数做一些处理，使得它能适合我们的 sql 搜索
*
* @param $searchParamArray
*
* @return array
* @throws \InvalidArgumentException
*/
protected function prepareSearchParam($searchParamArray)
{
if (!is_array($searchParamArray)) {
throw new \InvalidArgumentException('searchParam illegal : ' . var_export($searchParamArray, true));
}
$resultParamArray = array();
foreach ($searchParamArray as $searchParam) {
if (is_array($searchParam) && count($searchParam) == 3) {
switch ($searchParam[0]) {
// 取分类下面的商品，包括子分类的商品，我们需要取得所有子分类的 ID 然后重新构造查询条件
case 'category_id':
case 'g.category_id':
case 'cat_id':
case 'g.cat_id':
$goodsCategoryService = new GoodsCategoryService();
// 最多取 5 层分类，缓存 10 分钟
$childrenIdArray = $goodsCategoryService->fetchCategoryChildrenIdArray($searchParam[2], 5, 600);
$childrenIdArray[] = $searchParam[2];
// 加入父节点
// 构造新的查询条件
$searchParam = array(QueryBuilder::buildInCondition('g.cat_id', $childrenIdArray, \PDO::PARAM_INT));
break;
// 允许多品牌查询，需要生成 OR 查询条件，多品牌查询的情况 brand_id = 123_45_65_35 ，采用 _ 作为分隔
// 允许多品牌查询，需要生成 OR 查询条件，多品牌查询的情况 brand_id = 123_45_65_35 ，采用 _ 作为分隔
case 'brand_id':
case 'g.brand_id':
// 只处理 = 的情况
if ('=' != $searchParam[1] || false === strpos($searchParam[2], '_')) {
break;
}
$brandValueArray = explode('_', $searchParam[2]);
$brandQueryCondArray = array();
foreach ($brandValueArray as $brandValue) {
if (!empty($brandValue)) {
$brandQueryCondArray[] = array('g.brand_id = ?', intval($brandValue));
}
}
// 生成一串的 OR 查询
$searchParam = QueryBuilder::buildOrFilter($brandQueryCondArray);
break;
default:
break;
}
}
$resultParamArray[] = $searchParam;
}
return $resultParamArray;
}
public function get($f3)
{
global $smarty;
// 生成 smarty 的缓存 id
$smartyCacheId = 'Ajax|Category';
// 开启并设置 smarty 缓存时间
enableSmartyCache(true, bzf_get_option_value('smarty_cache_time_ajax_category'));
if ($smarty->isCached('ajax_category.tpl', $smartyCacheId)) {
goto out_display;
}
// 取得商品分类树形结构
$goodsCategoryService = new GoodsCategoryService();
$goodsCategoryTreeArray = $goodsCategoryService->fetchCategoryTreeArray(0);
$smarty->assign('goodsCategoryTreeArray', $goodsCategoryTreeArray);
out_display:
$f3->expire(600);
// 让客户端缓存 10 分钟
$smarty->display('ajax_category.tpl', $smartyCacheId);
}
public function get($f3)
{
global $smarty;
$smartyCacheId = 'EtaoFeed|' . md5(__NAMESPACE__ . '\\' . __CLASS__ . '_\\' . __METHOD__);
// 判断是否有缓存
enableSmartyCache(true, 1800);
// 缓存 30 分钟
if ($smarty->isCached('empty.tpl', $smartyCacheId)) {
goto out_display;
}
// 取得商品分类树形结构
$goodsCategoryService = new GoodsCategoryService();
$goodsCategoryTreeArray = $goodsCategoryService->fetchCategoryTreeArray(0);
$currentStamp = Time::localTimeStr();
$sellerId = EtaoFeedPlugin::getOptionValue('etaofeed_seller_id');
// 生成商品分类 XML
$categoryXmlList = '';
foreach ($goodsCategoryTreeArray as $goodsCategoryItem) {
$categoryXmlList .= $this->getGoodsCategoryXml($goodsCategoryItem);
}
$apiXml = <<<XML
<?xml version="1.0" encoding="utf-8" ?>
<root>
<version>1.0</version>
<modified>{$currentStamp}</modified>
<seller_id>{$sellerId}</seller_id>
<seller_cats>{$categoryXmlList}</seller_cats>
</root>
XML;
$smarty->assign('outputContent', $apiXml);
out_display:
header('Content-Type:text/xml;charset=utf-8');
header("Cache-Control: no-cache, must-revalidate");
// HTTP/1.1 //查询信息
$smarty->display('empty.tpl', $smartyCacheId);
}
public function get($f3)
{
global $smarty;
// 首先做参数合法性验证
$validator = new Validator($f3->get('GET'));
$pageNo = $validator->digits('pageNo 参数非法')->min(0, true, 'pageNo 参数非法')->validate('pageNo');
// 搜索参数数组
$searchFormQuery = array();
$searchFormQuery['g.category_id'] = $validator->required('商品分类不能为空')->digits('分类id非法')->min(1, true, '分类id非法')->filter('ValidatorIntValue')->validate('category_id');
// 这里支持多品牌查询
$searchFormQuery['g.brand_id'] = array('=', $validator->validate('brand_id'));
// 价格区间查询
$shopPriceMin = $validator->filter('ValidatorFloatValue')->validate('shop_price_min');
$shopPriceMin = null == $shopPriceMin ? null : Money::toStorage($shopPriceMin);
$shopPriceMax = $validator->filter('ValidatorFloatValue')->validate('shop_price_max');
$shopPriceMax = null == $shopPriceMax ? null : Money::toStorage($shopPriceMax);
$searchFormQuery['g.shop_price'] = array($shopPriceMin, $shopPriceMax);
// 属性过滤
$filter = $validator->validate('filter');
// 排序
$orderBy = $validator->oneOf(array('', 'total_buy_number', 'shop_price', 'add_time'))->validate('orderBy');
$orderDir = $validator->oneOf(array('', 'asc', 'desc'))->validate('orderDir');
$orderByParam = array();
if (!empty($orderBy)) {
$orderByParam = array(array($orderBy, $orderDir));
}
//增加一些我们的缺省排序
$orderByParam[] = array('g.sort_order', 'desc');
$orderByParam[] = array('g.goods_id', 'desc');
// 参数验证
if (!$this->validate($validator) || empty($searchFormQuery)) {
goto out_fail;
}
$pageNo = isset($pageNo) && $pageNo > 0 ? $pageNo : 0;
$pageSize = 45;
// 每页固定显示 45 个商品
// 生成 smarty 的缓存 id
$smartyCacheId = 'Goods|Category|' . md5(json_encode($searchFormQuery) . json_encode($orderByParam) . '_' . $filter . '_' . $pageNo . '_' . $pageSize);
// 开启并设置 smarty 缓存时间
enableSmartyCache(true, bzf_get_option_value('smarty_cache_time_goods_search'));
if ($smarty->isCached('goods_category.tpl', $smartyCacheId)) {
goto out_display;
}
$goodsCategoryService = new GoodsCategoryService();
$category = $goodsCategoryService->loadCategoryById($searchFormQuery['g.category_id'], 1800);
if ($category->isEmpty()) {
$this->addFlashMessage('分类[' . $searchFormQuery['category_id'] . ']不存在');
goto out_fail;
}
$smarty->assign('category', $category);
$metaData = json_decode($category['meta_data'], true);
$metaFilterArray = @$metaData['filterArray'];
// 1. 我们需要在左侧显示分类层级结构
$goodsCategoryTreeArray = $goodsCategoryService->fetchCategoryTreeArray($category['parent_meta_id'], false, 1800);
$smarty->assign('goodsCategoryTreeArray', $goodsCategoryTreeArray);
/**
* 构造 Filter 数组，结构如下
*
* array(
* '商品品牌' => array(
* filterKey => 'brand_id'
* filterValueArray => array( array(value=>'13', text=>'品牌1'), ...)
* ),
* '颜色' => array(
* filterKey => 'filter',
* filterValueArray => array( array(value=>'13', text=>'品牌1'), ...)
* )
* )
*
*/
$goodsFilterArray = array();
// filter 查询在这个条件下进行
$goodsFilterQueryCond = array_merge($this->searchExtraCondArray, array(array('g.category_id', '=', $searchFormQuery['g.category_id'])));
// 2. 商品品牌查询
$goodsBrandIdArray = SearchHelper::search(SearchHelper::Module_Goods, 'distinct(g.brand_id)', array_merge($goodsFilterQueryCond, array(array('g.brand_id > 0'))), null, 0, 0);
$brandIdArray = array_map(function ($elem) {
return $elem['brand_id'];
}, $goodsBrandIdArray);
if (!empty($brandIdArray)) {
$goodsBrandService = new GoodsBrandService();
$goodsBrandArray = $goodsBrandService->fetchBrandArrayByIdArray(array_unique(array_values($brandIdArray)));
$filterBrandArray = array();
foreach ($goodsBrandArray as $brand) {
$filterBrandArray[] = array('value' => $brand['brand_id'], 'text' => $brand['brand_name']);
}
if (!empty($filterBrandArray)) {
$goodsFilterArray['品牌'] = array('filterKey' => 'brand_id', 'filterValueArray' => $filterBrandArray);
}
}
// 3. 查询属性过滤
if (!empty($metaFilterArray)) {
$goodsTypeService = new GoodsTypeService();
foreach ($metaFilterArray as $filterItem) {
$goodsTypeAttrItem = $goodsTypeService->loadGoodsTypeAttrItemById($filterItem['attrItemId']);
if ($goodsTypeAttrItem->isEmpty()) {
continue;
}
// 取得商品属性值列表
$goodsAttrItemValueArray = SearchHelper::search(SearchHelper::Module_GoodsAttrGoods, 'min(ga.goods_attr_id) as goods_attr_id, ga.attr_item_value', array_merge($goodsFilterQueryCond, array(array('ga.attr_item_id', '=', $filterItem['attrItemId']))), null, 0, 0, 'ga.attr_item_value');
if (!empty($goodsAttrItemValueArray)) {
$filterValueArray = array();
foreach ($goodsAttrItemValueArray as $itemValue) {
$filterValueArray[] = array('value' => $itemValue['goods_attr_id'], 'text' => $itemValue['attr_item_value']);
}
$goodsFilterArray[$goodsTypeAttrItem['meta_name']] = array('filterKey' => 'filter', 'filterValueArray' => $filterValueArray);
} else {
// 如果这个属性完全没有值（没有一个商品设过任何值），我们弄一个空的
$goodsFilterArray[$goodsTypeAttrItem['meta_name']] = array('filterKey' => 'filter', 'filterValueArray' => array());
}
}
}
// 赋值给模板
if (!empty($goodsFilterArray)) {
$smarty->assign('goodsFilterArray', $goodsFilterArray);
}
// 4. 商品查询
if (!empty($metaFilterArray)) {
// 构造 attrItemId
$metaFilterTypeIdArray = array();
foreach ($metaFilterArray as $metaFilterItem) {
$metaFilterTypeIdArray[] = $metaFilterItem['attrItemId'];
}
// 构造 filter 参数，注意 filter 参数在 GoodsGoodsAttr 中具体解析
// 合并查询参数
$searchParamArray = array_merge(QueryBuilder::buildSearchParamArray($searchFormQuery), $this->searchExtraCondArray, array(array('ga.filter', implode('.', $metaFilterTypeIdArray), $filter)));
} else {
// 合并查询参数
$searchParamArray = array_merge(QueryBuilder::buildSearchParamArray($searchFormQuery), $this->searchExtraCondArray);
}
$totalCount = SearchHelper::count(SearchHelper::Module_GoodsGoodsAttr, $searchParamArray);
if ($totalCount <= 0) {
goto out_display;
// 没有商品，直接显示
}
// 页号可能是用户乱输入的，我们需要检查
if ($pageNo * $pageSize >= $totalCount) {
goto out_fail;
// 返回首页
}
$goodsArray = SearchHelper::search(SearchHelper::Module_GoodsGoodsAttr, 'g.goods_id, g.cat_id, g.goods_sn, g.goods_name, g.brand_id, g.goods_number, g.market_price' . ', g.shop_price, g.suppliers_id, g.virtual_buy_number, g.user_buy_number, g.user_pay_number' . ', (g.virtual_buy_number + g.user_pay_number) as total_buy_number', $searchParamArray, $orderByParam, $pageNo * $pageSize, $pageSize);
if (empty($goodsArray)) {
goto out_display;
}
$smarty->assign('goodsArray', $goodsArray);
$smarty->assign('totalCount', $totalCount);
$smarty->assign('pageNo', $pageNo);
$smarty->assign('pageSize', $pageSize);
// SEO 考虑，网页标题加上分类的名称
$smarty->assign('seo_title', $category['meta_name'] . ',' . $smarty->getTemplateVars('seo_title'));
out_display:
// 滑动图片广告
$goods_search_adv_slider = json_decode(bzf_get_option_value('goods_search_adv_slider'), true);
if (!empty($goods_search_adv_slider)) {
$smarty->assign('goods_search_adv_slider', $goods_search_adv_slider);
}
$smarty->display('goods_category.tpl', $smartyCacheId);
return;
out_fail:
// 失败从这里返回
RouteHelper::reRoute($this, '/');
// 返回首页
}
/**
* 列出整个商品分类树
*
* @param $f3
*/
public function ListCategoryTree($f3)
{
// 检查缓存
$cacheKey = md5(__NAMESPACE__ . '\\' . __CLASS__ . '\\' . __METHOD__);
if ($f3->get('GET[nocache]')) {
goto nocache;
}
$categoryTreeDisplayArray = $f3->get($cacheKey);
if (!empty($categoryTreeDisplayArray)) {
goto out;
}
nocache:
// 没有缓存数据
$categoryService = new CategoryService();
$categoryTreeArray = $categoryService->fetchCategoryTreeArray(0, true);
//构造显示数组
$categoryTreeDisplayArray = array();
function buildTreeDisplay(&$categoryDisplayArray, $categoryArray, $namePrefix)
{
foreach ($categoryArray as $categoryItem) {
$categoryItem['meta_name'] = $namePrefix . $categoryItem['meta_name'] . ($categoryItem['meta_status'] ? '' : '(不显示)');
$categoryDisplayArray[] = $categoryItem;
if (isset($categoryItem['child_list'])) {
buildTreeDisplay($categoryDisplayArray, $categoryItem['child_list'], $namePrefix . '---------->');
}
}
}
buildTreeDisplay($categoryTreeDisplayArray, $categoryTreeArray, '');
$f3->set($cacheKey, $categoryTreeDisplayArray, 300);
//缓存 5 分钟
out:
if (!$f3->get('GET[nocache]')) {
$f3->expire(60);
// 客户端缓存 1 分钟
}
Ajax::header();
echo Ajax::buildResult(null, null, $categoryTreeDisplayArray);
}
public function get($f3)
{
global $smarty;
// 首先做参数合法性验证
$validator = new Validator($f3->get('GET'));
$pageNo = $validator->digits('pageNo 参数非法')->min(0, true, 'pageNo 参数非法')->validate('pageNo');
// 搜索参数数组
$searchFormQuery = array();
$searchKeywords = $validator->validate('keywords');
$searchFormQuery['g.goods_name'] = $searchKeywords;
// 这里支持多品牌查询
$searchFormQuery['g.brand_id'] = array('=', $validator->validate('brand_id'));
// 价格区间查询
$shopPriceMin = $validator->filter('ValidatorFloatValue')->validate('shop_price_min');
$shopPriceMin = null == $shopPriceMin ? null : Money::toStorage($shopPriceMin);
$shopPriceMax = $validator->filter('ValidatorFloatValue')->validate('shop_price_max');
$shopPriceMax = null == $shopPriceMax ? null : Money::toStorage($shopPriceMax);
$searchFormQuery['g.shop_price'] = array($shopPriceMin, $shopPriceMax);
// 排序
$orderBy = $validator->oneOf(array('', 'total_buy_number', 'shop_price', 'add_time'))->validate('orderBy');
$orderDir = $validator->oneOf(array('', 'asc', 'desc'))->validate('orderDir');
$orderByParam = array();
if (!empty($orderBy)) {
$orderByParam = array(array($orderBy, $orderDir));
}
//增加一些我们的缺省排序
$orderByParam[] = array('g.sort_order', 'desc');
$orderByParam[] = array('g.goods_id', 'desc');
// 参数验证
if (!$this->validate($validator) || empty($searchFormQuery)) {
goto out_fail;
}
$pageNo = isset($pageNo) && $pageNo > 0 ? $pageNo : 0;
$pageSize = 45;
// 每页固定显示 45 个商品
// 生成 smarty 的缓存 id
$smartyCacheId = 'Goods|Search|' . md5(json_encode($searchFormQuery) . json_encode($orderByParam) . '_' . $pageNo . '_' . $pageSize);
// 开启并设置 smarty 缓存时间
enableSmartyCache(true, bzf_get_option_value('smarty_cache_time_goods_search'));
if ($smarty->isCached('goods_search.tpl', $smartyCacheId)) {
goto out_display;
}
$goodsCategoryService = new GoodsCategoryService();
// 1. 我们需要在左侧显示分类层级结构
$goodsCategoryTreeArray = $goodsCategoryService->fetchCategoryTreeArray(0, false, 1800);
$smarty->assign('goodsCategoryTreeArray', $goodsCategoryTreeArray);
/**
* 构造 Filter 数组，结构如下
*
* array(
* '商品品牌' => array(
* filterKey => 'brand_id'
* filterValueArray => array( array(value=>'13', text=>'品牌1'), ...)
* ),
* '颜色' => array(
* filterKey => 'filter',
* filterValueArray => array( array(value=>'13', text=>'品牌1'), ...)
* )
* )
*
*/
$goodsFilterArray = array();
// filter 查询在这个条件下进行
$goodsFilterQueryCond = array_merge(QueryBuilder::buildSearchParamArray(array('g.goods_name' => $searchKeywords)), $this->searchExtraCondArray);
// 2. 商品品牌查询
$goodsBrandIdArray = SearchHelper::search(SearchHelper::Module_Goods, 'distinct(g.brand_id)', array_merge($goodsFilterQueryCond, array(array('g.brand_id > 0'))), null, 0, 0);
$brandIdArray = array_map(function ($elem) {
return $elem['brand_id'];
}, $goodsBrandIdArray);
if (!empty($brandIdArray)) {
$goodsBrandService = new GoodsBrandService();
$goodsBrandArray = $goodsBrandService->fetchBrandArrayByIdArray(array_unique(array_values($brandIdArray)));
$filterBrandArray = array();
foreach ($goodsBrandArray as $brand) {
$filterBrandArray[] = array('value' => $brand['brand_id'], 'text' => $brand['brand_name']);
}
if (!empty($filterBrandArray)) {
$goodsFilterArray['品牌'] = array('filterKey' => 'brand_id', 'filterValueArray' => $filterBrandArray);
}
}
if (!empty($goodsFilterArray)) {
$smarty->assign('goodsFilterArray', $goodsFilterArray);
}
// 3. 商品属性过滤 TODO: 等以后扩展，看看 Search 怎么做属性过滤
// 4. 商品查询
// 构造 filter 参数，注意 filter 参数在 GoodsGoodsAttr 中具体解析
// 合并查询参数
$searchParamArray = array_merge(QueryBuilder::buildSearchParamArray($searchFormQuery), $this->searchExtraCondArray);
$totalCount = SearchHelper::count(SearchHelper::Module_GoodsGoodsAttr, $searchParamArray);
if ($totalCount <= 0) {
goto out_display;
// 没有商品，直接显示
}
// 页号可能是用户乱输入的，我们需要检查
if ($pageNo * $pageSize >= $totalCount) {
goto out_fail;
// 返回首页
}
$goodsArray = SearchHelper::search(SearchHelper::Module_GoodsGoodsAttr, 'g.goods_id, g.cat_id, g.goods_sn, g.goods_name, g.brand_id, g.goods_number, g.market_price' . ', g.shop_price, g.suppliers_id, g.virtual_buy_number, g.user_buy_number, g.user_pay_number' . ', (g.virtual_buy_number + g.user_pay_number) as total_buy_number', $searchParamArray, $orderByParam, $pageNo * $pageSize, $pageSize);
if (empty($goodsArray)) {
goto out_display;
}
$smarty->assign('goodsArray', $goodsArray);
$smarty->assign('totalCount', $totalCount);
$smarty->assign('pageNo', $pageNo);
$smarty->assign('pageSize', $pageSize);
// SEO 考虑，网页标题加上分类的名称
$smarty->assign('seo_title', '商品搜索,' . $searchKeywords . ',' . $smarty->getTemplateVars('seo_title'));
out_display:
// 滑动图片广告
$goods_search_adv_slider = json_decode(bzf_get_option_value('goods_search_adv_slider'), true);
if (!empty($goods_search_adv_slider)) {
$smarty->assign('goods_search_adv_slider', $goods_search_adv_slider);
}
$smarty->display('goods_search.tpl', $smartyCacheId);
return;
out_fail:
// 失败从这里返回
RouteHelper::reRoute($this, '/');
// 返回首页
}
public function get($f3)
{
global $smarty;
// 生成 smarty 的缓存 id
$smartyCacheId = 'Mobile|Index';
// 开启并设置 smarty 缓存时间
enableSmartyCache(true, MobileThemePlugin::getOptionValue('smarty_cache_time_goods_index'));
// 缓存页面
if ($smarty->isCached('mobile_index.tpl', $smartyCacheId)) {
goto out_display;
}
$categoryLevel = 3;
// 取得分类下面 3 层的商品
$categoryGoodsSzie = 4;
// 每个分类下面取 4 个商品
// 取得分类列表
$categoryService = new CategoryService();
$categoryArray = $categoryService->fetchCategoryArray(0);
//取得分类
// 取得商品列表
$categoryGoodsArray = array();
$goodsIdArray = array();
foreach ($categoryArray as $category) {
// 分类下面 3 层子分类， 取 4 个商品
$goodsArray = $categoryService->fetchGoodsArray($category['meta_id'], $categoryLevel, PluginHelper::SYSTEM_MOBILE, 0, $categoryGoodsSzie);
if (!empty($goodsArray)) {
$categoryGoodsArray[$category['meta_id']] = $goodsArray;
foreach ($goodsArray as $goodsItem) {
$goodsIdArray[] = $goodsItem['goods_id'];
}
}
}
// 网站完全没有商品？ 不缓存
if (empty($goodsIdArray)) {
goto out_display;
}
// 取得商品的图片
$goodsGalleryService = new GoodsGalleryService();
$goodsGalleryArray = $goodsGalleryService->fetchGoodsGalleryArrayByGoodsIdArray($goodsIdArray);
$currentGoodsId = -1;
$goodsThumbImageArray = array();
$goodsImageArray = array();
foreach ($goodsGalleryArray as $goodsGalleryItem) {
if ($currentGoodsId == $goodsGalleryItem['goods_id']) {
continue;
//每个商品我们只需要一张图片，跳过其它的图片
}
$currentGoodsId = $goodsGalleryItem['goods_id'];
// 新的商品 id
$goodsThumbImageArray[$currentGoodsId] = RouteHelper::makeImageUrl($goodsGalleryItem['thumb_url']);
$goodsImageArray[$currentGoodsId] = RouteHelper::makeImageUrl($goodsGalleryItem['img_url']);
}
// 赋值给模板
$smarty->assign('categoryArray', $categoryArray);
$smarty->assign('categoryGoodsArray', $categoryGoodsArray);
$smarty->assign('goodsThumbImageArray', $goodsThumbImageArray);
$smarty->assign('goodsImageArray', $goodsImageArray);
out_display:
$smarty->assign('seo_title', $smarty->getTemplateVars('seo_title') . ',' . $f3->get('HOST'));
$smarty->display('mobile_index.tpl', $smartyCacheId);
}
public function get($f3)
{
// 权限检查
$this->requirePrivilege('manage_goods_search');
global $smarty;
// 参数验证
$validator = new Validator($f3->get('GET'));
$pageNo = $validator->digits()->min(0)->validate('pageNo');
$pageSize = $validator->digits()->min(0)->validate('pageSize');
// 设置缺省值
$pageNo = isset($pageNo) && $pageNo > 0 ? $pageNo : 0;
$pageSize = isset($pageSize) && $pageSize > 0 ? $pageSize : 10;
// 搜索参数数组
$searchFormQuery = array();
$searchFormQuery['g.is_on_sale'] = $validator->digits()->min(0)->filter('ValidatorIntValue')->validate('is_on_sale');
$searchFormQuery['g.goods_id'] = $validator->digits()->min(1)->filter('ValidatorIntValue')->validate('goods_id');
$searchFormQuery['g.suppliers_id'] = $validator->digits()->min(1)->filter('ValidatorIntValue')->validate('suppliers_id');
$searchFormQuery['g.goods_name'] = $validator->validate('goods_name');
$searchFormQuery['g.cat_id'] = $validator->digits()->min(1)->filter('ValidatorIntValue')->validate('cat_id');
$searchFormQuery['g.type_id'] = $validator->digits()->min(1)->filter('ValidatorIntValue')->validate('type_id');
$searchFormQuery['g.brand_id'] = $validator->digits()->min(1)->filter('ValidatorIntValue')->validate('brand_id');
$searchFormQuery['g.goods_sn'] = $validator->validate('goods_sn');
$searchFormQuery['g.warehouse'] = $validator->validate('warehouse');
$searchFormQuery['g.shelf'] = $validator->validate('shelf');
$searchFormQuery['g.admin_user_id'] = $validator->digits()->min(1)->filter('ValidatorIntValue')->validate('admin_user_id');
$systemTag = $validator->validate('system_tag');
if (!empty($systemTag)) {
$searchFormQuery['g.system_tag_list'] = Utils::makeTagString(array($systemTag));
}
if (!$this->validate($validator)) {
goto out_display;
}
// 查询条件
$searchParamArray = array();
// 根据推广渠道做搜索
$goods_promote = $validator->validate('goods_promote');
if (!empty($goods_promote)) {
switch ($goods_promote) {
case '360tequan':
$searchParamArray[] = array('gp.360tequan_price > 0');
break;
case '360tegong':
$searchParamArray[] = array('gp.360tegong_enable = 1');
break;
default:
// do nothing
break;
}
}
// 建立查询条件
$searchParamArray = array_merge($searchParamArray, QueryBuilder::buildSearchParamArray($searchFormQuery));
// 查询商品列表
$totalCount = SearchHelper::count(SearchHelper::Module_GoodsGoodsPromote, $searchParamArray);
if ($totalCount <= 0) {
// 没商品，可以直接退出了
goto out_display;
}
// 页数超过最大值，返回第一页
if ($pageNo * $pageSize >= $totalCount) {
RouteHelper::reRoute($this, '/Goods/Search');
}
// 商品列表
$goodsArray = SearchHelper::search(SearchHelper::Module_GoodsGoodsPromote, 'g.goods_id, g.system_tag_list, g.cat_id, g.admin_user_name, g.goods_name, g.goods_number' . ', g.goods_spec, g.is_on_sale, g.type_id' . ', g.market_price, g.shop_price, g.shipping_fee, g.shipping_free_number' . ', g.suppliers_id, g.suppliers_price, g.suppliers_shipping_fee, g.warehouse, g.shelf', $searchParamArray, array(array('g.goods_id', 'desc')), $pageNo * $pageSize, $pageSize);
// 取得供货商 id 列表，商品分类 id
$supplierIdArray = array();
$categoryIdArray = array();
$typeIdArray = array();
foreach ($goodsArray as $goodsItem) {
$supplierIdArray[] = $goodsItem['suppliers_id'];
$categoryIdArray[] = $goodsItem['cat_id'];
$typeIdArray[] = $goodsItem['type_id'];
}
$supplierIdArray = array_unique($supplierIdArray);
$categoryIdArray = array_unique($categoryIdArray);
//取得供货商信息
$userSupplierService = new UserSupplierService();
$supplierArray = $userSupplierService->fetchSupplierArrayBySupplierIdArray($supplierIdArray);
// 建立 suppliers_id --> supplier 的反查表，方便快速查询
$supplierIdToSupplierArray = array();
foreach ($supplierArray as $supplier) {
$supplierIdToSupplierArray[$supplier['suppliers_id']] = $supplier;
}
$system_url_base_array = json_decode(ManageThemePlugin::getOptionValue('system_url_base_array'), true);
// 放入供货商信息
foreach ($goodsArray as &$goodsItem) {
if (isset($supplierIdToSupplierArray[$goodsItem['suppliers_id']])) {
// 很老的订单，用户可能被删除了
$goodsItem['suppliers_name'] = $supplierIdToSupplierArray[$goodsItem['suppliers_id']]['suppliers_name'];
}
// 解析 system_tag_list，放入 system_array 的信息
$systeArray = Utils::parseTagString($goodsItem['system_tag_list']);
$goodsItem['system_array'] = array();
foreach ($systeArray as $systemItem) {
$goodsItem['system_array'][] = @$system_url_base_array[$systemItem]['name'];
}
// 商品规格
if (!empty($goodsItem['goods_spec'])) {
$goodsSpecService = new GoodsSpecService();
$goodsSpecService->initWithJson($goodsItem['goods_spec']);
$goodsItem['goods_spec'] = $goodsSpecService->getGoodsSpecDataArray();
}
}
unset($goodsItem);
// 取得分类信息
$categoryBasicService = new CategoryBasicService();
$categoryArray = $categoryBasicService->fetchCategoryArrayByIdArray($categoryIdArray);
// 建立 cat_id ---> cateogry 信息的反查表
$categoryIdToCategoryArray = array();
foreach ($categoryArray as $categoryItem) {
$categoryIdToCategoryArray[$categoryItem['meta_id']] = $categoryItem;
}
// 放入分类信息
foreach ($goodsArray as &$goodsItem) {
if (isset($categoryIdToCategoryArray[$goodsItem['cat_id']])) {
// 很老的商品，分类信息可能已经不存在了
$goodsItem['cat_name'] = $categoryIdToCategoryArray[$goodsItem['cat_id']]['meta_name'];
}
}
unset($goodsItem);
// 取得商品类型信息
$goodsTypeService = new GoodsTypeService();
$goodsTypeArray = $goodsTypeService->fetchGoodsTypeArrayByTypeIdArray($typeIdArray);
// 建立 type_id ---> type 信息的反查表
$typeIdToTypeArray = array();
foreach ($goodsTypeArray as $goodsType) {
$typeIdToTypeArray[$goodsType['meta_id']] = $goodsType;
}
// 放入类型信息
foreach ($goodsArray as &$goodsItem) {
if (isset($typeIdToTypeArray[$goodsItem['type_id']])) {
$goodsItem['type_name'] = $typeIdToTypeArray[$goodsItem['type_id']]['meta_name'];
}
}
unset($goodsItem);
// 给模板赋值
$smarty->assign('totalCount', $totalCount);
$smarty->assign('pageNo', $pageNo);
$smarty->assign('pageSize', $pageSize);
$smarty->assign('goodsArray', $goodsArray);
$smarty->assign('system_url_base_array', json_decode(ManageThemePlugin::getOptionValue('system_url_base_array'), true));
out_display:
$smarty->display('goods_search.tpl');
}
public function get($f3)
{
global $smarty;
// 首先做参数合法性验证
$validator = new Validator($f3->get('GET'));
$goods_id = $validator->required('商品id不能为空')->digits('商品id非法')->min(1, true, '商品id非法')->validate('goods_id');
if (!$this->validate($validator)) {
goto out_fail;
}
// 生成 smarty 的缓存 id
$smartyCacheId = 'Goods|' . $goods_id . '|View';
// 开启并设置 smarty 缓存时间
enableSmartyCache(true, bzf_get_option_value('smarty_cache_time_goods_view'));
if ($smarty->isCached('goods_view.tpl', $smartyCacheId)) {
goto out_display;
}
// 查询商品信息
$goodsBasicService = new GoodsBasicService();
$goodsInfo = $goodsBasicService->loadGoodsById($goods_id);
// 商品不存在，退出
if ($goodsInfo->isEmpty() || !Utils::isTagExist(PluginHelper::SYSTEM_SHOP, $goodsInfo['system_tag_list'])) {
$this->addFlashMessage('商品 [' . $goods_id . '] 不存在');
goto out_fail;
}
// 取得商品的分类层级
$goodsCategoryLevelArray = array();
$goodsCategoryService = new GoodsCategoryService();
$categoryLevel = 5;
// 最多取 5 层分类
$currentCategoryId = $goodsInfo['cat_id'];
for (; $categoryLevel > 0; $categoryLevel--) {
$category = $goodsCategoryService->loadCategoryById($currentCategoryId, 1800);
if ($category->isEmpty()) {
break;
}
array_unshift($goodsCategoryLevelArray, $category);
if ($category['parent_meta_id'] <= 0) {
break;
}
$currentCategoryId = $category['parent_meta_id'];
}
// 取商品推广信息设置
$goodsPromote = $goodsBasicService->loadGoodsPromoteByGoodsId($goods_id);
// 取商品图片集
$goodsGalleryArray = GoodsGalleryCache::getGoodsGallery($goods_id);
foreach ($goodsGalleryArray as &$galleryItem) {
$galleryItem['img_original'] = RouteHelper::makeImageUrl($galleryItem['img_original']);
$galleryItem['img_url'] = RouteHelper::makeImageUrl($galleryItem['img_url']);
$galleryItem['thumb_url'] = RouteHelper::makeImageUrl($galleryItem['thumb_url']);
}
unset($galleryItem);
// 取相互关联的商品
$linkGoodsArray = $goodsBasicService->fetchLinkGoodsArray($goods_id);
// 相同供货商的商品，一起购买只收一份邮费
$goodsSupplierService = new GoodsSupplierService();
// 取得供货商下面的商品总数，总数只缓存 10 分钟
$supplierTotalGoodsCount = $goodsSupplierService->countSupplierGoodsArray($goodsInfo['suppliers_id'], 600);
// 随机挑选 10 个商品
$supplierGoodsSize = 10;
$supplierGoodsOffset = $supplierTotalGoodsCount <= $supplierGoodsSize ? 0 : mt_rand(0, $supplierTotalGoodsCount - $supplierGoodsSize);
$supplierGoodsArray = $goodsSupplierService->fetchSupplierGoodsArray($goodsInfo['suppliers_id'], $supplierGoodsOffset, $supplierGoodsSize);
// 把自己去除掉
$supplierGoodsKeyExcludeArray = array();
foreach ($supplierGoodsArray as $supplierGoodsKey => $supplierGoodsItem) {
if ($supplierGoodsItem['goods_id'] == $goods_id) {
$supplierGoodsKeyExcludeArray[] = $supplierGoodsKey;
}
}
foreach ($supplierGoodsKeyExcludeArray as $supplierGoodsKey) {
unset($supplierGoodsArray[$supplierGoodsKey]);
}
// 设置商品页面的 SEO 信息
$smarty->assign('seo_title', $goodsInfo['seo_title'] . ',' . $f3->get('sysConfig[site_name]'));
$smarty->assign('seo_description', $goodsInfo['seo_description']);
$smarty->assign('seo_keywords', $goodsInfo['seo_keyword']);
// 给模板赋值
$smarty->assign('goodsInfo', $goodsInfo);
$smarty->assign('goodsPromote', $goodsPromote);
// 商品购买选择的规格
if (!empty($goodsInfo['goods_spec'])) {
$goodsSpecService = new GoodsSpecService();
$goodsSpecService->initWithJson($goodsInfo['goods_spec']);
// 只显示有库存的商品规格
$goodsSpecData = $goodsSpecService->getBuyableData();
$smarty->assign($goodsSpecData);
$smarty->assign('goodsSpecJson', json_encode($goodsSpecData));
}
// 商品的类型属性
if ($goodsInfo['type_id'] > 0) {
$goodsTypeService = new GoodsTypeService();
$goodsAttrTreeTable = $goodsTypeService->fetchGoodsAttrItemValueTreeTable($goodsInfo['goods_id'], $goodsInfo['type_id']);
$smarty->assign('goodsAttrTreeTable', $goodsAttrTreeTable);
}
if (!empty($goodsCategoryLevelArray)) {
$smarty->assign('goodsCategoryLevelArray', $goodsCategoryLevelArray);
}
if (!Utils::isEmpty($goodsGalleryArray)) {
$smarty->assign('goodsGalleryArray', $goodsGalleryArray);
}
if (!Utils::isEmpty($linkGoodsArray)) {
$smarty->assign('linkGoodsArray', $linkGoodsArray);
}
if (!Utils::isEmpty($supplierGoodsArray)) {
$smarty->assign('supplierGoodsArray', $supplierGoodsArray);
}
// 滑动图片广告
$goods_view_adv_slider = json_decode(bzf_get_option_value('goods_view_adv_slider'), true);
if (!empty($goods_view_adv_slider)) {
$smarty->assign('goods_view_adv_slider', $goods_view_adv_slider);
}
// 移动端对应的 URL，用于百度页面适配
$smarty->assign('currentPageMobileUrl', RouteHelper::makeShopSystemUrl(PluginHelper::SYSTEM_MOBILE, '/Goods/View', array('goods_id' => $goods_id)));
out_display:
$smarty->display('goods_view.tpl', $smartyCacheId);
return;
out_fail:
// 失败从这里返回
RouteHelper::reRoute($this, '/');
// 返回首页
}
/**
* 把商品从一个分类转移到另外一个分类
* @param $f3
*/
public function TransferGoods($f3)
{
// 权限检查
$this->requirePrivilege('manage_goods_category_edit');
// 参数验证
$validator = new Validator($f3->get('POST'));
$meta_id = $validator->required()->digits()->min(1)->validate('meta_id');
$target_meta_id = $validator->required('必须选择一个目标分类')->digits()->min(1)->validate('target_meta_id');
if (!$this->validate($validator)) {
goto out;
}
if ($meta_id == $target_meta_id) {
$this->addFlashMessage('目标分类不能是自己');
goto out;
}
$goodsCategoryService = new GoodsCategoryService();
$goodsCategoryService->transferGoodsToNewCategory($meta_id, $target_meta_id);
$this->addFlashMessage('商品转移成功');
$this->addFlashMessage('注意：商品转移只是当前分类商品，不包括子分类的商品');
out:
RouteHelper::reRoute($this, RouteHelper::getRefer(), false);
}
/**
* 生成网页左侧分类列表的显示
*/
function smarty_helper_function_category_list(array $paramArray, $smarty)
{
$basicCategoryService = new BasicCategoryService();
$liHead = '<li><a data-transition="flow" href="';
// 我们只显示顶级分类
$categoryArray = $basicCategoryService->fetchCategoryArray(0, false, 1800);
// 缓存 30 分钟
$output = $liHead . RouteHelper::makeUrl('/') . '">网站首页</a></li>';
foreach ($categoryArray as $categoryItem) {
$output .= $liHead . RouteHelper::makeUrl('/Goods/Search', array('category_id' => $categoryItem['meta_id']), false, false, false) . '">' . $categoryItem['meta_name'] . '</a></li>';
}
return $output;
}
