Goodsclass.php 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829
  1. <?php
  2. namespace app\common\model;
  3. use think\facade\Db;
  4. /**
  5. * ============================================================================
  6. * DSMall多用户商城
  7. * ============================================================================
  8. * 版权所有 2014-2028 长沙德尚网络科技有限公司,并保留所有权利。
  9. * 网站地址: http://www.csdeshang.com
  10. * ----------------------------------------------------------------------------
  11. * 这不是一个自由软件!您只能在不用于商业目的的前提下对程序代码进行修改和使用 .
  12. * 不允许对程序代码以任何形式任何目的的再发布。
  13. * ============================================================================
  14. * 数据层模型
  15. */
  16. class Goodsclass extends BaseModel
  17. {
  18. /**
  19. * 缓存数据
  20. */
  21. protected $cachedData;
  22. /**
  23. * 缓存数据 原H('goods_class')形式
  24. */
  25. protected $gcForCacheModel;
  26. /**
  27. * 获取缓存数据
  28. * @access public
  29. * @author csdeshang
  30. * @return array
  31. * array(
  32. * 'data' => array(
  33. * // Id => 记录
  34. * ),
  35. * 'parent' => array(
  36. * // 子Id => 父Id
  37. * ),
  38. * 'children' => array(
  39. * // 父Id => 子Id数组
  40. * ),
  41. * 'children2' => array(
  42. * // 1级Id => 3级Id数组
  43. * ),
  44. * )
  45. */
  46. public function getCache()
  47. {
  48. if ($this->cachedData) {
  49. return $this->cachedData;
  50. }
  51. $data = rkcache('gc_class');
  52. if (!$data) {
  53. $data = array();
  54. foreach ((array)$this->getGoodsclassList(array()) as $v) {
  55. $id = $v['gc_id'];
  56. $pid = $v['gc_parent_id'];
  57. $data['data'][$id] = $v;
  58. $data['parent'][$id] = $pid;
  59. $data['children'][$pid][] = $id;
  60. }
  61. foreach ((array)@$data['children'][0] as $id) {
  62. if (!empty($data['children'][$id])) {
  63. foreach ((array)$data['children'][$id] as $cid) {
  64. if (!empty($data['children'][$cid])) {
  65. foreach ((array)$data['children'][$cid] as $ccid) {
  66. $data['children2'][$id][] = $ccid;
  67. }
  68. }
  69. }
  70. }
  71. }
  72. wkcache('gc_class', $data);
  73. }
  74. return $this->cachedData = $data;
  75. }
  76. /**
  77. * 删除缓存数据
  78. * @access public
  79. * @author csdeshang
  80. * @return bool
  81. */
  82. public function dropCache()
  83. {
  84. $this->cachedData = null;
  85. $this->gcForCacheModel = null;
  86. dkcache('gc_class');
  87. dkcache('all_categories');
  88. }
  89. /**
  90. * 类别列表
  91. * @access public
  92. * @author csdeshang
  93. * @param array $condition 检索条件
  94. * @param string $field 字段
  95. * @return array 返回二位数组
  96. */
  97. public function getGoodsclassList($condition, $field = '*')
  98. {
  99. $result = Db::name('goodsclass')->field($field)->where($condition)->order('gc_parent_id asc,gc_sort asc,gc_id asc')->select()->toArray();
  100. return $result;
  101. }
  102. /**
  103. * 从缓存获取全部分类
  104. * @access public
  105. * @author csdeshang
  106. * @return type
  107. */
  108. public function getGoodsclassListAll()
  109. {
  110. $data = $this->getCache();
  111. return array_values((array)@$data['data']);
  112. }
  113. /**
  114. * 从缓存获取全部分类 分类id作为数组的键
  115. * @access public
  116. * @author csdeshang
  117. * @return array
  118. */
  119. public function getGoodsclassIndexedListAll()
  120. {
  121. $data = $this->getCache();
  122. if($data){
  123. return (array)$data['data'];
  124. }
  125. return '';
  126. }
  127. /**
  128. * 从缓存获取分类 通过分类id数组
  129. * @access public
  130. * @author csdeshang
  131. * @param array $ids 分类id数组
  132. * @return array
  133. */
  134. public function getGoodsclassListByIds($ids)
  135. {
  136. $data = $this->getCache();
  137. $ret = array();
  138. foreach ((array)$ids as $i) {
  139. if (isset($data['data'][$i]) && $data['data'][$i]) {
  140. $ret[] = $data['data'][$i];
  141. }
  142. }
  143. return $ret;
  144. }
  145. /**
  146. * 从缓存获取分类 通过上级分类id
  147. * @access public
  148. * @author csdeshang
  149. * @param type $pid 上级分类id 若传0则返回1级分类
  150. * @return type
  151. */
  152. public function getGoodsclassListByParentId($pid)
  153. {
  154. $data = $this->getCache();
  155. $ret = array();
  156. if (!empty($data['children'][$pid])) {
  157. foreach ((array)$data['children'][$pid] as $i) {
  158. if ($data['data'][$i]) {
  159. $ret[] = $data['data'][$i];
  160. }
  161. }
  162. }
  163. return $ret;
  164. }
  165. /**
  166. * 从缓存获取分类 通过分类id
  167. * @access public
  168. * @author csdeshang
  169. * @param type $id 分类id
  170. * @return type
  171. */
  172. public function getGoodsclassInfoById($id)
  173. {
  174. $data = $this->getCache();
  175. return @$data['data'][$id];
  176. }
  177. /**
  178. * 返回缓存数据 原H('goods_class')形式
  179. * @access public
  180. * @author csdeshang
  181. * @return type
  182. */
  183. public function getGoodsclassForCacheModel()
  184. {
  185. if ($this->gcForCacheModel)
  186. return $this->gcForCacheModel;
  187. $data = $this->getCache();
  188. $r = isset($data['data'])?$data['data']:'';
  189. $p = isset($data['parent'])?$data['parent']:'';
  190. $c = isset($data['children'])?$data['children']:'';
  191. $c2 = empty($data['children2']) ? '' : $data['children2'];
  192. if(!empty($r)) {
  193. $r = (array)$r;
  194. foreach ($r as $k => & $v) {
  195. if ((string)$p[$k] == '0') {
  196. $v['depth'] = 1;
  197. if (!empty($data['children'][$k])) {
  198. $v['child'] = implode(',', $c[$k]);
  199. }
  200. if (!empty($data['children2'][$k])) {
  201. $v['childchild'] = implode(',', $c2[$k]);
  202. }
  203. }
  204. else if (isset($p[$p[$k]]) && (string)$p[$p[$k]] == '0') {
  205. $v['depth'] = 2;
  206. if (isset($data['children'][$k])) {
  207. $v['child'] = implode(',', $c[$k]);
  208. }
  209. }
  210. else if (isset($p[$p[$k]]) && isset($p[$p[$p[$k]]]) && (string)$p[$p[$p[$k]]] == '0') {
  211. $v['depth'] = 3;
  212. }
  213. }
  214. }
  215. return $this->gcForCacheModel = $r;
  216. }
  217. /**
  218. * 更新信息
  219. * @access public
  220. * @author csdeshang
  221. * @param type $data 更新数据
  222. * @param type $condition 条件
  223. * @return bool
  224. */
  225. public function editGoodsclass($data = array(), $condition = array())
  226. {
  227. // 删除缓存
  228. $this->dropCache();
  229. return Db::name('goodsclass')->where($condition)->update($data);
  230. }
  231. /**
  232. * 取得店铺绑定的分类
  233. * @access public
  234. * @author csdeshang
  235. * @param number $store_id 店铺id
  236. * @param number $pid 父级分类id
  237. * @param number $deep 深度
  238. * @return array 二维数组
  239. */
  240. public function getGoodsclass($store_id, $pid = 0, $deep = 1)
  241. {
  242. // 读取商品分类
  243. $gc_list_o = $gc_list = $this->getGoodsclassListByParentId($pid);
  244. // 如果不是自营店铺或者自营店铺未绑定全部商品类目,读取绑定分类
  245. if (!check_platform_store_bindingall_goodsclass()) {
  246. $gc_list = array_under_reset($gc_list, 'gc_id');
  247. $storebindclass_model = model('storebindclass');
  248. $condition = array();
  249. $condition[] = array('store_id','=',$store_id);
  250. $condition[] = array('storebindclass_state','in',array(1, 2));
  251. $gcid_array = $storebindclass_model->getStorebindclassList($condition, '', "class_{$deep} asc", "distinct class_{$deep}");
  252. if (!empty($gcid_array)) {
  253. $tmp_gc_list = array();
  254. foreach ($gcid_array as $value) {
  255. if ($value["class_{$deep}"] == 0)
  256. return $gc_list_o;
  257. if (isset($gc_list[$value["class_{$deep}"]])) {
  258. $tmp_gc_list[] = $gc_list[$value["class_{$deep}"]];
  259. }
  260. }
  261. $gc_list = $tmp_gc_list;
  262. }
  263. else {
  264. return array();
  265. }
  266. }
  267. return $gc_list;
  268. }
  269. /**
  270. * 删除商品分类
  271. * @access public
  272. * @author csdeshang
  273. * @param array $condition 条件
  274. * @return boolean
  275. */
  276. public function delGoodsclass($condition)
  277. {
  278. // 删除缓存
  279. $this->dropCache();
  280. return Db::name('goodsclass')->where($condition)->delete();
  281. }
  282. /**
  283. * 删除商品分类
  284. * @access public
  285. * @author csdeshang
  286. * @param array $gcids 分类ID
  287. * @return boolean
  288. */
  289. public function delGoodsclassByGcIdString($gcids)
  290. {
  291. $gcids = explode(',', $gcids);
  292. if (empty($gcids)) {
  293. return false;
  294. }
  295. $goods_class = $this->getGoodsclassForCacheModel();
  296. $gcid_array = array();
  297. foreach ($gcids as $gc_id) {
  298. $child = (!empty($goods_class[$gc_id]['child'])) ? explode(',', $goods_class[$gc_id]['child']) : array();
  299. $childchild = (!empty($goods_class[$gc_id]['childchild'])) ? explode(',', $goods_class[$gc_id]['childchild']) : array();
  300. $gcid_array = array_merge($gcid_array, array($gc_id), $child, $childchild);
  301. }
  302. // 删除商品分类
  303. $this->delGoodsclass(array(array('gc_id','in', $gcid_array)));
  304. // 删除常用商品分类
  305. model('goodsclassstaple')->delGoodsclassstaple(array(array('gc_id_1|gc_id_2|gc_id_3','in', $gcid_array)));
  306. // 删除分类tag表
  307. model('goodsclasstag')->delGoodsclasstag(array(array('gc_id_1|gc_id_2|gc_id_3','in', $gcid_array)));
  308. // 删除店铺绑定分类
  309. model('storebindclass')->delStorebindclass(array(array('class_1|class_2|class_3','in', $gcid_array)));
  310. // 商品下架
  311. model('goods')->editProducesLockUp(array('goods_stateremark' => '商品分类被删除,需要重新选择分类'), array(array('gc_id','in', $gcid_array)));
  312. return true;
  313. }
  314. /**
  315. * 前台头部的商品分类
  316. * @access public
  317. * @author csdeshang
  318. * @param number $update_all 更新
  319. * @return array 数组
  320. */
  321. public function get_all_category($update_all = 0)
  322. {
  323. // 不存在时更新或者强制更新时执行
  324. if ($update_all == 1 || !($gc_list = rkcache('all_categories'))) {
  325. $class_list = $this->getTreeClassList(3);
  326. $gc_list = [];
  327. $type_ids = array(); //第2级分类关联类型
  328. if (is_array($class_list) && !empty($class_list)) {
  329. //遍历一级商品分类
  330. foreach ($class_list as $k => $v) {
  331. if ($v[ 'deep' ] == 1) {
  332. $nav_info = $this->_getGoodsclassnavById($v['gc_id']);//一级分类推荐品牌
  333. $gc_list[$v['gc_id']] = array_merge($v, $nav_info);
  334. unset($class_list[ $k ]);
  335. }
  336. }
  337. $class_list = array_values($class_list);
  338. //遍历二级商品分类
  339. foreach ($class_list as $k => $v) {
  340. foreach ($gc_list as $ck => $cv) {
  341. if ($v[ 'deep' ] == 2 && $cv[ 'gc_id' ] == $v[ 'gc_parent_id' ]) {
  342. $gc_list[$cv['gc_id']][ 'class2' ][$v['gc_id']] = $v;
  343. $type_ids[] = $cv['type_id'];
  344. unset($class_list[ $k ]);
  345. }
  346. }
  347. }
  348. $class_list = array_values($class_list);
  349. //遍历三级商品分类
  350. foreach ($class_list as $k => $v) {
  351. foreach ($gc_list as $ck => $cv) {
  352. if (!empty($cv[ 'class2' ])) {
  353. foreach ($cv[ 'class2' ] as $third_k => $third_v) {
  354. if ($v[ 'deep' ] == 3 && $third_v[ 'gc_id' ] == $v[ 'gc_parent_id' ]) {
  355. $gc_list[$cv['gc_id']][ 'class2' ][$third_v['gc_id']][ 'class3' ][] = $v;
  356. unset($class_list[ $k ]);
  357. }
  358. }
  359. }
  360. }
  361. }
  362. $type_brands = $this->get_type_brands($type_ids); //类型关联品牌
  363. foreach ($gc_list as $key => $value) {
  364. $class2s = isset($value['class2']) ? $value['class2'] : '';
  365. if (is_array($class2s) && !empty($class2s)) {//第2级关联品牌
  366. foreach ($class2s as $k2 => $v2) {
  367. $p_id = $v2['gc_parent_id'];
  368. $gc_id = $v2['gc_id'];
  369. $type_id = $v2['type_id'];
  370. $gc_list[$p_id]['class2'][$gc_id]['brands'] = isset($type_brands[$type_id]) ? $type_brands[$type_id] : '';
  371. }
  372. }
  373. }
  374. }
  375. wkcache('all_categories', $gc_list);
  376. }
  377. return $gc_list;
  378. }
  379. /**
  380. * 类型关联品牌
  381. * @access public
  382. * @author csdeshang
  383. * @param array $type_ids 类型
  384. * @return array 数组
  385. */
  386. public function get_type_brands($type_ids = array())
  387. {
  388. $brands = array(); //品牌
  389. $type_brands = array(); //类型关联品牌
  390. if (is_array($type_ids) && !empty($type_ids)) {
  391. $type_ids = array_unique($type_ids);
  392. $type_list = Db::name('typebrand')->where('type_id','in', $type_ids)->limit(10000)->select()->toArray();
  393. if (is_array($type_list) && !empty($type_list)) {
  394. $brand_mod=model('brand');
  395. $brand_list = $brand_mod->getBrandList(array('brand_apply' => 1),'brand_id,brand_name,brand_pic',10000);
  396. if (is_array($brand_list) && !empty($brand_list)) {
  397. foreach ($brand_list as $key => $value) {
  398. $brand_id = $value['brand_id'];
  399. $brands[$brand_id] = $value;
  400. }
  401. foreach ($type_list as $key => $value) {
  402. $type_id = $value['type_id'];
  403. $brand_id = $value['brand_id'];
  404. if(isset($brands[$brand_id])){
  405. $brand = $brands[$brand_id];
  406. if (is_array($brand) && !empty($brand)) {
  407. $type_brands[$type_id][$brand_id] = $brand;
  408. }
  409. }
  410. }
  411. }
  412. }
  413. }
  414. return $type_brands;
  415. }
  416. /**
  417. * 获取商品分类导航
  418. * @access public
  419. * @author csdeshang
  420. * @param int $gc_id 商品分类id
  421. * @return type
  422. */
  423. private function _getGoodsclassnavById($gc_id)
  424. {
  425. $classnav_model = model('goodsclassnav');
  426. $brand_model = model('brand');
  427. $nav_info = $classnav_model->getGoodsclassnavInfoByGcId($gc_id);
  428. if (empty($nav_info)) {
  429. return array();
  430. }
  431. if (!empty($nav_info['goodscn_pic'])) {
  432. $nav_info['goodscn_pic'] = ds_get_pic( ATTACH_GOODS_CLASS , $nav_info['goodscn_pic']);
  433. }
  434. else {
  435. unset($nav_info['goodscn_pic']);
  436. }
  437. if (!empty($nav_info['goodscn_adv1'])) {
  438. $nav_info['goodscn_adv1'] = ds_get_pic( ATTACH_GOODS_CLASS , $nav_info['goodscn_adv1']);
  439. }
  440. else {
  441. unset($nav_info['goodscn_adv1']);
  442. }
  443. if (!empty($nav_info['goodscn_adv2'])) {
  444. $nav_info['goodscn_adv2'] = ds_get_pic( ATTACH_GOODS_CLASS , $nav_info['goodscn_adv2']);
  445. }
  446. else {
  447. unset($nav_info['goodscn_adv2']);
  448. }
  449. if ($nav_info['goodscn_brandids'] != '') {
  450. $nav_info['cn_brands'] = $brand_model->getBrandList(array(array('brand_id','in', $nav_info['goodscn_brandids'])));
  451. unset($nav_info['goodscn_brandids']);
  452. }
  453. if ($nav_info['goodscn_classids'] != '') {
  454. $nav_info['cn_classs'] = $this->getGoodsclassList(array(array('gc_id','in', $nav_info['goodscn_classids'])));
  455. unset($nav_info['goodscn_classids']);
  456. }
  457. if ($nav_info['goodscn_alias'] != '') {
  458. $nav_info['gc_name'] = $nav_info['goodscn_alias'];
  459. unset($nav_info['goodscn_alias']);
  460. }
  461. return $nav_info;
  462. }
  463. /**
  464. * 新增商品分类
  465. * @access public
  466. * @author csdeshang
  467. * @param array $data 参数数据
  468. * @return boolean
  469. */
  470. public function addGoodsclass($data)
  471. {
  472. // 删除缓存
  473. $this->dropCache();
  474. return Db::name('goodsclass')->insertGetId($data);
  475. }
  476. /**
  477. * 取分类列表,最多为三级
  478. * @access public
  479. * @author csdeshang
  480. * @param int $show_deep 显示深度
  481. * @param array $condition 检索条件
  482. * @return array 数组类型的返回结果
  483. */
  484. public function getTreeClassList($show_deep = '3', $condition = array())
  485. {
  486. $class_list = $this->getGoodsclassList($condition);
  487. $goods_class = array(); //分类数组
  488. if (is_array($class_list) && !empty($class_list)) {
  489. $show_deep = intval($show_deep);
  490. if ($show_deep == 1) {//只显示第一级时用循环给分类加上深度deep号码
  491. foreach ($class_list as $val) {
  492. if ($val['gc_parent_id'] == 0) {
  493. $val['deep'] = 1;
  494. $goods_class[] = $val;
  495. }
  496. else {
  497. break; //父类编号不为0时退出循环
  498. }
  499. }
  500. }
  501. else {//显示第二和三级时用递归
  502. $goods_class = $this->_getTreeClassList($show_deep, $class_list);
  503. }
  504. }
  505. return $goods_class;
  506. }
  507. /**
  508. * 递归 整理分类
  509. * @access public
  510. * @author csdeshang
  511. * @param int $show_deep 显示深度
  512. * @param array $class_list 类别内容集合
  513. * @param int $deep 深度
  514. * @param int $parent_id 父类编号
  515. * @param int $i 上次循环编号
  516. * @return array $show_class 返回数组形式的查询结果
  517. */
  518. private function _getTreeClassList($show_deep, $class_list, $deep = 1, $parent_id = 0, $i = 0)
  519. {
  520. static $show_class = array(); //树状的平行数组
  521. if (is_array($class_list) && !empty($class_list)) {
  522. $size = count($class_list);
  523. if ($i == 0)
  524. $show_class = array(); //从0开始时清空数组,防止多次调用后出现重复
  525. for ($i; $i < $size; $i++) {//$i为上次循环到的分类编号,避免重新从第一条开始
  526. $val = $class_list[$i];
  527. $gc_id = $val['gc_id'];
  528. $gc_parent_id = $val['gc_parent_id'];
  529. if ($gc_parent_id == $parent_id) {
  530. $val['deep'] = $deep;
  531. $show_class[] = $val;
  532. if ($deep < $show_deep && $deep < 3) {//本次深度小于显示深度时执行,避免取出的数据无用
  533. $this->_getTreeClassList($show_deep, $class_list, $deep + 1, $gc_id, 1);
  534. }
  535. }
  536. if ($gc_parent_id > $parent_id)
  537. break; //当前分类的父编号大于本次递归的时退出循环
  538. }
  539. }
  540. return $show_class;
  541. }
  542. /**
  543. * 取指定分类ID下的所有子类
  544. * @access public
  545. * @author csdeshang
  546. * @staticvar type $_cache
  547. * @param int $parent_id 父ID 可以单一可以为数组
  548. * @return array 返回数组形式的查询结果
  549. */
  550. public function getChildClass($parent_id)
  551. {
  552. static $_cache;
  553. if ($_cache !== null)
  554. return $_cache;
  555. $all_class = $this->getGoodsclassListAll();
  556. if (is_array($all_class)) {
  557. if (!is_array($parent_id)) {
  558. $parent_id = array($parent_id);
  559. }
  560. $result = array();
  561. foreach ($all_class as $k => $v) {
  562. $gc_id = $v['gc_id']; //返回的结果包括父类
  563. $gc_parent_id = $v['gc_parent_id'];
  564. if (in_array($gc_id, $parent_id) || in_array($gc_parent_id, $parent_id)) {
  565. $parent_id[] = $v['gc_id'];
  566. $result[] = $v;
  567. }
  568. }
  569. $return = $result;
  570. }
  571. else {
  572. $return = false;
  573. }
  574. return $_cache = $return;
  575. }
  576. /**
  577. * 取指定分类ID的导航链接
  578. * @access public
  579. * @author csdeshang
  580. * @param int $id 父类ID/子类ID
  581. * @param int $sign 1、0 1为最后一级不加超链接,0为加超链接
  582. * @return array $nav_link 返回数组形式类别导航连接
  583. */
  584. public function getGoodsclassnav($id = 0, $sign = 1)
  585. {
  586. if (intval($id) > 0) {
  587. $data = $this->getGoodsclassIndexedListAll();
  588. // 当前分类不加超链接
  589. if ($sign == 1) {
  590. if (isset($data[$id])) {
  591. $nav_link [] = array(
  592. 'title' => $data[$id]['gc_name']
  593. );
  594. }
  595. }
  596. else {
  597. if (isset($data[$id])) {
  598. $nav_link [] = array(
  599. 'title' => isset($data[$id]['gc_name']) ? $data[$id]['gc_name'] : '..',
  600. 'link' => (string)url('/home/Search/index', ['cate_id' => $data[$id]['gc_id']]),
  601. );
  602. }
  603. }
  604. if (isset($data[$id])) {
  605. // 最多循环4层
  606. for ($i = 1; $i < 5; $i++) {
  607. if ($data[$id]['gc_parent_id'] == '0') {
  608. break;
  609. }
  610. $id = $data[$id]['gc_parent_id'];
  611. if(!isset($data[$id])){
  612. break;
  613. }
  614. $nav_link[] = array(
  615. 'title' => $data[$id]['gc_name'],
  616. 'link' => (string)url('/home/Search/index', ['cate_id' => $data[$id]['gc_id']])
  617. );
  618. }
  619. }
  620. }
  621. else {
  622. // 加上 首页 商品分类导航
  623. $nav_link[] = array('title' => lang('goods_class_index_search_results'));
  624. }
  625. // 首页导航
  626. $nav_link[] = array('title' => lang('homepage'), 'link' => (string)url('home/Index/index'));
  627. krsort($nav_link);
  628. return $nav_link;
  629. }
  630. /**
  631. * 根据一级分类id取得所有三级分类
  632. * @access public
  633. * @author csdeshang
  634. * @param type $id 分类ID
  635. * @return type
  636. */
  637. public function getChildClassByFirstId($id)
  638. {
  639. $data = $this->getCache();
  640. $result = array();
  641. if (!empty($data['children2'][$id])) {
  642. foreach ($data['children2'][$id] as $val) {
  643. $child = $data['data'][$val];
  644. $result[$child['gc_parent_id']]['class'][$child['gc_id']] = $child['gc_name'];
  645. $result[$child['gc_parent_id']]['name'] = $data['data'][$child['gc_parent_id']]['gc_name'];
  646. }
  647. }
  648. return $result;
  649. }
  650. /**
  651. * 取指定分类ID的所有父级分类
  652. * @access public
  653. * @author csdeshang
  654. * @param int $id 父类ID/子类ID
  655. * @return array
  656. */
  657. public function getGoodsclassLineForTag($id = 0)
  658. {
  659. if (intval($id) > 0) {
  660. $gc_line = array();
  661. /**
  662. * 取当前类别信息
  663. */
  664. $class = $this->getGoodsclassInfoById(intval($id));
  665. $gc_line['gc_id'] = $class['gc_id'];
  666. $gc_line['type_id'] = $class['type_id'];
  667. $gc_line['gc_virtual'] = $class['gc_virtual'];
  668. $gc_line['gctag_name']='>';
  669. $gc_line['gctag_value']=',';
  670. /**
  671. * 是否是子类
  672. */
  673. if ($class['gc_parent_id'] != 0) {
  674. $parent_1 = $this->getGoodsclassInfoById($class['gc_parent_id']);
  675. if ($parent_1['gc_parent_id'] != 0) {
  676. $parent_2 = $this->getGoodsclassInfoById($parent_1['gc_parent_id']);
  677. $gc_line['gc_id_1'] = $parent_2['gc_id'];
  678. $gc_line['gctag_name'] = trim($parent_2['gc_name']) . ' >';
  679. $gc_line['gctag_value'] = trim($parent_2['gc_name']) . ',';
  680. }
  681. if (!isset($gc_line['gc_id_1'])) {
  682. $gc_line['gc_id_1'] = $parent_1['gc_id'];
  683. }
  684. else {
  685. $gc_line['gc_id_2'] = $parent_1['gc_id'];
  686. }
  687. $gc_line['gctag_name'] .= trim($parent_1['gc_name']) . ' >';
  688. $gc_line['gctag_value'] .= trim($parent_1['gc_name']) . ',';
  689. }
  690. if (!isset($gc_line['gc_id_1'])) {
  691. $gc_line['gc_id_1'] = $class['gc_id'];
  692. }
  693. else if (!isset($gc_line['gc_id_2'])) {
  694. $gc_line['gc_id_2'] = $class['gc_id'];
  695. }
  696. else {
  697. $gc_line['gc_id_3'] = $class['gc_id'];
  698. }
  699. $gc_line['gctag_name'] .= trim($class['gc_name']) . ' >';
  700. $gc_line['gctag_value'] .= trim($class['gc_name']) . ',';
  701. }
  702. $gc_line['gctag_name'] = trim($gc_line['gctag_name'], ' >');
  703. $gc_line['gctag_value'] = trim($gc_line['gctag_value'], ',');
  704. return $gc_line;
  705. }
  706. /**
  707. * 取得分类关键词,方便SEO
  708. * @access public
  709. * @author csdeshang
  710. * @param type $gc_id 商品分类ID
  711. * @return boolean
  712. */
  713. public function getKeyWords($gc_id = null)
  714. {
  715. if (empty($gc_id))
  716. return false;
  717. $keywrods = rkcache('goodsclassseo', true);
  718. if (empty($keywrods)) {
  719. return array(1 => '', 2 => trim('', ','), 3 => trim('', ','));
  720. }
  721. $seo_title = $keywrods[$gc_id]['title'];
  722. $seo_key = '';
  723. $seo_desc = '';
  724. if ($gc_id > 0) {
  725. if (isset($keywrods[$gc_id])) {
  726. $seo_key .= $keywrods[$gc_id]['key'] . ',';
  727. $seo_desc .= $keywrods[$gc_id]['desc'] . ',';
  728. }
  729. $goods_class = model('goodsclass')->getGoodsclassIndexedListAll();
  730. if (($gc_id = $goods_class[$gc_id]['gc_parent_id']) > 0) {
  731. if (isset($keywrods[$gc_id])) {
  732. $seo_key .= $keywrods[$gc_id]['key'] . ',';
  733. $seo_desc .= $keywrods[$gc_id]['desc'] . ',';
  734. }
  735. }
  736. if (($gc_id = $goods_class[$gc_id]['gc_parent_id']) > 0) {
  737. if (isset($keywrods[$gc_id])) {
  738. $seo_key .= $keywrods[$gc_id]['key'] . ',';
  739. $seo_desc .= $keywrods[$gc_id]['desc'] . ',';
  740. }
  741. }
  742. }
  743. return array(1 => $seo_title, 2 => trim($seo_key, ','), 3 => trim($seo_desc, ','));
  744. }
  745. /**
  746. * 获得商品分类缓存
  747. * @access public
  748. * @author csdeshang
  749. * @param int $choose_gcid 选择分类ID
  750. * @param int $show_depth 需要展示分类深度
  751. * @return array 返回分类数组和选择分类id数组
  752. */
  753. public function getGoodsclassCache($choose_gcid, $show_depth = 3)
  754. {
  755. $gc_list = $this->getGoodsclassForCacheModel();
  756. //获取需要展示的分类数组
  757. $show_gc_list = array();
  758. if(!empty($gc_list)) {
  759. foreach ((array)$gc_list as $k => $v) {
  760. if(isset($v['depth'])){
  761. if ($v['depth'] < $show_depth) {
  762. $show_gc_list[$v['gc_id']] = $v;
  763. }
  764. elseif ($v['depth'] == $show_depth) {
  765. unset($v['child'], $v['childchild']);
  766. $show_gc_list[$v['gc_id']] = $v;
  767. }
  768. }
  769. }
  770. }
  771. $choose_gcidarr = array();
  772. if ($choose_gcid > 0) {
  773. //遍历出选择商品分类的上下级ID
  774. if(isset($gc_list[$choose_gcid])){
  775. $gc_depth = $gc_list[$choose_gcid]['depth'];
  776. $parentid = $choose_gcid;
  777. for ($i = $gc_depth - 1; $i >= 0; $i--) {
  778. $choose_gcidarr[$i] = $parentid;
  779. $parentid = $gc_list[$parentid]['gc_parent_id'];
  780. }
  781. }
  782. }
  783. return array('showclass' => $show_gc_list, 'choose_gcid' => $choose_gcidarr);
  784. }
  785. }
  786. ?>