search.php 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498
  1. <?php
  2. //use Shopnc\Tpl;
  3. defined('InShopNC') or exit('Access Invalid!');
  4. require_once (BASE_ROOT_PATH . '/helper/category_helper.php');
  5. require_once (BASE_ROOT_PATH . '/helper/goods_helper.php');
  6. class searchControl extends mobileHomeControl
  7. {
  8. public function __construct()
  9. {
  10. parent::__construct();
  11. }
  12. /**
  13. * 商品列表接口
  14. *
  15. * 请求参数:
  16. * key:
  17. * order: 1-升序 2-降序
  18. * page: 每页数量
  19. * curpage: 当前页码
  20. * gc_id: 分类编码
  21. * keyword:搜索关键字
  22. * brand_id: 品牌
  23. * efficacy_id:功效查询
  24. *
  25. */
  26. public function indexOp()
  27. {
  28. return $this->goods_listOp();
  29. }
  30. public function goods_listOp()
  31. {
  32. $model_goods = Model('goods');
  33. $condition = array();
  34. //分类查询
  35. if (!empty(trim($_GET['gc_id']))) {
  36. $condition['gc_id'] = intval($_GET['gc_id']);
  37. }
  38. // 关键字
  39. if (!empty(trim($_GET['keyword']))) {
  40. $condition['goods_name|goods_jingle'] = array('like', '%' . urldecode($_GET['keyword']) . '%');
  41. }
  42. // 品牌查询
  43. if (!empty(trim($_GET['brand_id']))) {
  44. $condition['brand_id'] = intval($_GET['brand_id']);
  45. }
  46. // 功效查询
  47. if (!empty(trim($_GET['efficacy_id']))) {
  48. $condition['efficacy_id'] = intval($_GET['efficacy_id']);
  49. }
  50. //重新组合后的分类查询
  51. if (!empty(trim($_GET['hot_id']))) {
  52. $id = intval($_GET['hot_id']);
  53. $cids = category_helper::instance()->cids($id);
  54. $condition['gc_id'] = array('in', $cids);
  55. }
  56. //排序方式
  57. $order = $this->get_order($_GET['key'], $_GET['order']);
  58. $goods_list = $model_goods->getGoodsListByColorDistinct($condition, goods_helper::fieldstr, $order, $this->page_size());
  59. $page_count = $model_goods->gettotalpage();
  60. $model_goods->cls();
  61. $goods_ids = array();
  62. foreach($goods_list as $val) {
  63. array_push($goods_ids,$val['goods_id']);
  64. }
  65. $helper = new goods_helper();
  66. $goods_list = $helper->get_infos($goods_ids);
  67. self::outsuccess(array('goods_list' => $goods_list, 'mobile_page' => mobile_page($page_count)));
  68. }
  69. /**
  70. * 商品列表排序方式
  71. */
  72. private function get_order($key, $order)
  73. {
  74. $result = 'is_own_shop desc,goods_commonid desc';
  75. if (!empty($key))
  76. {
  77. $sequence = 'desc';
  78. if ($order == 1) {
  79. $sequence = 'asc';
  80. }
  81. switch ($key) {
  82. //销量
  83. case '1' :
  84. $result = 'goods_salenum' . ' ' . $sequence;
  85. break;
  86. //浏览量
  87. case '2' :
  88. $result = 'goods_click' . ' ' . $sequence;
  89. break;
  90. //价格
  91. case '3' :
  92. $result = 'goods_price' . ' ' . $sequence;
  93. break;
  94. }
  95. }
  96. return $result;
  97. }
  98. /**
  99. * 商品详细页扩展
  100. *
  101. * 输入参数:
  102. * goods_id:商品id
  103. *
  104. */
  105. public function goods_commonOp()
  106. {
  107. $goods_id = intval($_GET ['goods_id']);
  108. if (empty($_GET ['goods_id']) || $goods_id < 0) {
  109. return joutput_error(errcode::ErrParamter, "goods_id = {$goods_id} must be > 0.");
  110. }
  111. // 商品详细信息
  112. $model_goods = Model('goods')->cls();
  113. $goods_detail = $model_goods->getGoodsSku($goods_id);
  114. if (empty($goods_detail)) {
  115. return joutput_error(errcode::ErrGoodsNotExist);
  116. }
  117. //推荐商品
  118. $model_store = Model('store')->cls();
  119. $store_info = $model_store->getStoreInfoByID($goods_detail['goods_info']['store_id']);
  120. $goods_detail['store_info']['store_id'] = $store_info['store_id'];
  121. $goods_detail['store_info']['store_name'] = $store_info['store_name'];
  122. $goods_detail['store_info']['member_id'] = $store_info['member_id'];
  123. //显示QQ及旺旺 好商城V3
  124. $goods_detail['store_info']['store_qq'] = $store_info['store_qq'];
  125. $goods_detail['store_info']['store_ww'] = $store_info['store_ww'];
  126. $goods_detail['store_info']['store_phone'] = $store_info['store_phone'];
  127. $goods_detail['store_info']['member_name'] = $store_info['member_name'];
  128. $goods_detail['store_info']['avatar'] = getMemberAvatarForID($store_info['member_id']);
  129. //商品详细信息处理
  130. $goods_detail = $this->_goods_common_extend($goods_detail);
  131. joutput_data($goods_detail);
  132. }
  133. /**
  134. * 商品详细信息处理
  135. */
  136. private function _goods_common_extend($goods_detail)
  137. {
  138. //商品链接
  139. $goods_detail['goods_info']['goods_url'] = urlShop('goods', 'index', array('goods_id' => $goods_detail['request_goods_id']));
  140. //整理数据
  141. unset($goods_detail['goods_info']['goods_commonid']);
  142. unset($goods_detail['goods_info']['gc_id']);
  143. unset($goods_detail['goods_info']['gc_name']);
  144. unset($goods_detail['goods_info']['store_name']);
  145. unset($goods_detail['goods_info']['brand_id']);
  146. unset($goods_detail['goods_info']['brand_name']);
  147. unset($goods_detail['goods_info']['type_id']);
  148. unset($goods_detail['goods_info']['goods_image']);
  149. //unset($goods_detail['goods_info']['goods_body']);
  150. unset($goods_detail['goods_info']['mobile_body']);
  151. unset($goods_detail['goods_info']['goods_state']);
  152. unset($goods_detail['goods_info']['goods_stateremark']);
  153. unset($goods_detail['goods_info']['goods_verify']);
  154. unset($goods_detail['goods_info']['goods_verifyremark']);
  155. unset($goods_detail['goods_info']['goods_lock']);
  156. unset($goods_detail['goods_info']['goods_addtime']);
  157. unset($goods_detail['goods_info']['goods_edittime']);
  158. unset($goods_detail['goods_info']['goods_selltime']);
  159. unset($goods_detail['goods_info']['goods_show']);
  160. unset($goods_detail['goods_info']['goods_commend']);
  161. unset($goods_detail['goods_info']['explain']);
  162. unset($goods_detail['goods_info']['cart']);
  163. unset($goods_detail['goods_info']['buynow_text']);
  164. unset($goods_detail['goods_info']['spec_value']);
  165. unset($goods_detail['goods_info']['spec_name']);
  166. unset($goods_detail['goods_info']['goods_spec']);
  167. //unset($goods_detail['goods_info']['goods_attr']);
  168. unset($goods_detail['groupbuy_info']);
  169. unset($goods_detail['xianshi_info']);
  170. return $goods_detail;
  171. }
  172. /**
  173. * 商品详细页
  174. *
  175. * 输入参数:
  176. * goods_id: 商品id
  177. * from:目前说明是来自app还是h5
  178. */
  179. public function goods_detailOp()
  180. {
  181. $goods_id = intval($_GET ['goods_id']);
  182. $from = $_GET['from'];
  183. // 商品详细信息
  184. $model_goods = Model('goods');
  185. $goods_detail = $model_goods->getGoodsDetail($goods_id);
  186. if (empty($goods_detail)) {
  187. return joutput_error(errcode::ErrGoodsNotExist);
  188. }
  189. // 推荐商品
  190. $model_store = Model('store');
  191. $hot_sales = $model_store->getHotSalesList($goods_detail['goods_info']['store_id'], 6);
  192. $goods_commend_list = array();
  193. foreach ($hot_sales as $value) {
  194. $goods_commend = array();
  195. $goods_commend['goods_id'] = $value['goods_id'];
  196. $goods_commend['goods_name'] = $value['goods_name'];
  197. $goods_commend['goods_price'] = $value['goods_price'];
  198. $goods_commend['goods_image_url'] = cthumb($value['goods_image'], 240);
  199. $goods_commend_list[] = $goods_commend;
  200. }
  201. $goods_detail['goods_commend_list'] = $goods_commend_list;
  202. $store_info = $model_store->getStoreInfoByID($goods_detail['goods_info']['store_id']);
  203. $goods_detail['store_info']['store_id'] = $store_info['store_id'];
  204. $goods_detail['store_info']['store_name'] = $store_info['store_name'];
  205. $goods_detail['store_info']['member_id'] = $store_info['member_id'];
  206. //显示QQ及旺旺 好商城V3
  207. $goods_detail['store_info']['store_qq'] = $store_info['store_qq'];
  208. $goods_detail['store_info']['store_ww'] = $store_info['store_ww'];
  209. $goods_detail['store_info']['store_phone'] = $store_info['store_phone'];
  210. $goods_detail['store_info']['member_name'] = $store_info['member_name'];
  211. $goods_detail['store_info']['avatar'] = getMemberAvatarForID($store_info['member_id']);
  212. //商品详细信息处理
  213. $goods_detail = $this->_goods_detail_extend($goods_detail);
  214. if ($from === 'app') {
  215. $goods_detail['goods_info']['spec'] = $this->_parse_spec($goods_detail['goods_info']['spec_name'], $goods_detail['goods_info']['spec_value'], $goods_detail['spec_image'], $goods_detail['spec_list']);
  216. $goods_detail['goods_info']['attributes'] = $this->_parse_attributes($goods_detail['goods_info']['goods_attr']);
  217. $goods_detail['goods_info']['goods_spec_obj'] = $this->_parse_goods_spec($goods_detail['goods_info']['goods_spec']);
  218. $goods_detail['UPLOAD_SITE_URL'] = $GLOBALS['setting_config']['upload_site_url'];
  219. }
  220. //v3-b11 抢购商品是否开始
  221. $goods_info = $goods_detail['goods_info'];
  222. //print_r($goods_info);
  223. $IsHaveBuy = 0;
  224. if (!empty($_COOKIE['username'])) {
  225. $model_member = Model('member');
  226. $member_info = $model_member->getMemberInfo(array('member_name' => $_COOKIE['username']));
  227. $buyer_id = $member_info['member_id'];
  228. $promotion_type = $goods_info["promotion_type"];
  229. if ($promotion_type == 'groupbuy') {
  230. //检测是否限购数量
  231. $upper_limit = $goods_info["upper_limit"];
  232. if ($upper_limit > 0) {
  233. //查询些会员的订单中,是否已买过了
  234. $model_order = Model('order');
  235. //取商品列表
  236. $order_goods_list = $model_order->getOrderGoodsList(array('goods_id' => $goods_id, 'buyer_id' => $buyer_id, 'goods_type' => 2));
  237. if ($order_goods_list) {
  238. //取得上次购买的活动编号(防一个商品参加多次团购活动的问题)
  239. $promotions_id = $order_goods_list[0]["promotions_id"];
  240. //用此编号取数据,检测是否这次活动的订单商品。
  241. $model_groupbuy = Model('groupbuy');
  242. $groupbuy_info = $model_groupbuy->getGroupbuyInfo(array('groupbuy_id' => $promotions_id));
  243. if ($groupbuy_info) {
  244. $IsHaveBuy = 1;
  245. } else {
  246. $IsHaveBuy = 0;
  247. }
  248. }
  249. }
  250. }
  251. }
  252. $goods_detail['IsHaveBuy'] = $IsHaveBuy;
  253. //v3-b11 end
  254. joutput_data($goods_detail);
  255. }
  256. /**
  257. * 商品详细信息处理
  258. */
  259. private function _goods_detail_extend($goods_detail)
  260. {
  261. //整理商品规格
  262. unset($goods_detail['spec_list']);
  263. $goods_detail['spec_list'] = $goods_detail['spec_list_mobile'];
  264. unset($goods_detail['spec_list_mobile']);
  265. //整理商品图片
  266. unset($goods_detail['goods_image']);
  267. $goods_detail['goods_image'] = implode(',', $goods_detail['goods_image_mobile']);
  268. unset($goods_detail['goods_image_mobile']);
  269. //商品链接
  270. $goods_detail['goods_info']['goods_url'] = urlShop('goods', 'index', array('goods_id' => $goods_detail['goods_info']['goods_id']));
  271. //整理数据
  272. unset($goods_detail['goods_info']['goods_commonid']);
  273. unset($goods_detail['goods_info']['gc_id']);
  274. unset($goods_detail['goods_info']['gc_name']);
  275. unset($goods_detail['goods_info']['store_name']);
  276. unset($goods_detail['goods_info']['brand_id']);
  277. unset($goods_detail['goods_info']['brand_name']);
  278. unset($goods_detail['goods_info']['type_id']);
  279. unset($goods_detail['goods_info']['goods_image']);
  280. unset($goods_detail['goods_info']['goods_body']);
  281. unset($goods_detail['goods_info']['mobile_body']);
  282. unset($goods_detail['goods_info']['goods_state']);
  283. unset($goods_detail['goods_info']['goods_stateremark']);
  284. unset($goods_detail['goods_info']['goods_verify']);
  285. unset($goods_detail['goods_info']['goods_verifyremark']);
  286. unset($goods_detail['goods_info']['goods_lock']);
  287. unset($goods_detail['goods_info']['goods_addtime']);
  288. unset($goods_detail['goods_info']['goods_edittime']);
  289. unset($goods_detail['goods_info']['goods_selltime']);
  290. unset($goods_detail['goods_info']['goods_show']);
  291. unset($goods_detail['goods_info']['goods_commend']);
  292. unset($goods_detail['goods_info']['explain']);
  293. unset($goods_detail['goods_info']['cart']);
  294. unset($goods_detail['goods_info']['buynow_text']);
  295. unset($goods_detail['groupbuy_info']);
  296. //unset($goods_detail['xianshi_info']);
  297. return $goods_detail;
  298. }
  299. /**
  300. * 解析spec字段
  301. *
  302. * @param $spec_name
  303. * @param $spec_value
  304. * @param array $spec_image
  305. * @param array $spec_list
  306. * @return array
  307. */
  308. private function _parse_spec($spec_name, $spec_value, $spec_image = [], $spec_list = [])
  309. {
  310. $spec = [];
  311. foreach ($spec_name as $key => $value) {
  312. $spec_item = [];
  313. $spec_item['spec_id'] = $key;
  314. $spec_item['spec_name'] = $value;
  315. if (!empty($spec_value[$key])) {
  316. $spec_item['value_list'] = [];
  317. foreach ($spec_value[$key] as $v_key => $v) {
  318. $value_item = [];
  319. $value_item['value_id'] = $v_key;
  320. $value_item['value_name'] = $v;
  321. $value_item['value_image'] = empty($spec_image[$v_key]) ? '' : $spec_image[$v_key];
  322. $value_item['value'] = empty($spec_list[$v_key]) ? '' : $spec_list[$v_key];
  323. array_push($spec_item['value_list'], $value_item);
  324. }
  325. }
  326. array_push($spec, $spec_item);
  327. }
  328. return $spec;
  329. }
  330. /**
  331. * 解析商品属性字段
  332. *
  333. * @param $goods_attr
  334. * @return array
  335. */
  336. private function _parse_attributes($goods_attr)
  337. {
  338. $attributes = [];
  339. foreach ($goods_attr as $key => $value) {
  340. $attribute_item = [];
  341. $attribute_item['goods_attr_id'] = $key;
  342. $attribute_item['goods_attr_value'] = [];
  343. if (!empty($value)) {
  344. foreach ($value as $v_key => $v) {
  345. $attribute_attr = [];
  346. if ($v_key === 'name') {
  347. $attribute_item['goods_attr_name'] = $v;
  348. } else {
  349. $attribute_attr['value_id'] = $v_key;
  350. $attribute_attr['value_name'] = $v;
  351. array_push($attribute_item['goods_attr_value'], $attribute_attr);
  352. }
  353. }
  354. }
  355. array_push($attributes, $attribute_item);
  356. }
  357. return $attributes;
  358. }
  359. /**
  360. * 解析功效
  361. *
  362. * @param $goods_attr
  363. * @return mixed
  364. */
  365. private function _parse_for_efficacy($goods_attr)
  366. {
  367. foreach ($goods_attr as $key => $val) {
  368. $attr_item['goods_attr_id'] = intval($key);
  369. $attr_item['goods_attr_name'] = $val['name'];
  370. if ($attr_item['goods_attr_name'] === '功效') {
  371. $goods_attr_value = array();
  372. foreach ($val as $id => $name) {
  373. if ($id !== 'name') {
  374. $val_item['value_id'] = intval($id);
  375. $val_item['value_name'] = $name;
  376. array_push($goods_attr_value, $val_item);
  377. }
  378. }
  379. $attr_item['goods_attr_value'] = $goods_attr_value;
  380. break;
  381. }
  382. }
  383. return $attr_item;
  384. }
  385. /**
  386. * 商品规格序列化解析
  387. *
  388. * @param $goods_spec
  389. * @return array
  390. */
  391. private function _parse_goods_spec($goods_spec)
  392. {
  393. $goods_spec_obj = [];
  394. foreach ($goods_spec as $key => $value) {
  395. $spec_item = [];
  396. $spec_item['spec_value'] = $key;
  397. $spec_item['spec_name'] = $value;
  398. array_push($goods_spec_obj, $spec_item);
  399. }
  400. return $goods_spec_obj;
  401. }
  402. /**
  403. * 商品详细页(未启用)
  404. */
  405. public function goods_bodyOp()
  406. {
  407. return joutput_error(errcode::ErrProtocolDisabled);
  408. $goods_id = intval($_GET ['goods_id']);
  409. $out_type = $_GET ['type'];
  410. $model_goods = Model('goods');
  411. if (empty($_GET ['goods_commonid'])) {
  412. $goods_info = $model_goods->getGoodsInfoByID($goods_id, 'goods_commonid');
  413. } else {
  414. $goods_info['goods_commonid'] = intval($_GET ['goods_commonid']);
  415. }
  416. $goods_common_info = $model_goods->getGoodeCommonInfoByID($goods_info['goods_commonid']);
  417. if ($out_type === 'json') {
  418. $goods_common_info['goods_attr'] = $this->_parse_attributes(unserialize($goods_common_info['goods_attr']));
  419. $goods_common_info['spec_name'] = unserialize($goods_common_info['spec_name']);
  420. $goods_common_info['spec_value'] = unserialize($goods_common_info['spec_value']);
  421. $goods_common_info['spec'] = $this->_parse_spec($goods_common_info['spec_name'], $goods_common_info['spec_value']);
  422. $goods_common_info['goods_body'] = ''; //base64_encode($goods_common_info['goods_body']);
  423. $goods_common_info['mobile_body'] = '';//base64_encode($goods_common_info['mobile_body']);
  424. joutput_data($goods_common_info);
  425. } else {
  426. Tpl::output('goods_common_info', $goods_common_info);
  427. Tpl::showpage('goods_body');
  428. }
  429. }
  430. /**
  431. * 获取detail(未启用)
  432. */
  433. public function detailOp()
  434. {
  435. $goods_id = intval($_GET['goods_id']);
  436. if (empty($_GET['goods_id']) || $goods_id <= 0) {
  437. if (!empty($_GET['goods_commonid'])) {
  438. $commonid = intval($_GET['goods_commonid']);
  439. }
  440. } else {
  441. $items = Model()->table('goods')->field('goods_commonid')->where(array('goods_id' => $goods_id))->limit(1)->select();
  442. if (!empty($items) && count($items) > 0) {
  443. $commonid = intval($items[0]['goods_commonid']);
  444. }
  445. }
  446. if (isset($commonid) && $commonid > 0) {
  447. $items = Model()->table('goods_common')->field('goods_body')->where(array('goods_commonid' => $commonid))->select();
  448. if (!empty($items) && count($items) > 0) {
  449. Tpl::output('goods_body', $items[0]['goods_body']);
  450. }
  451. }
  452. Tpl::showpage('goods_detail');
  453. }
  454. }