add($data); Cache::tag("goods_category")->clear(); return $this->success($category_id); } /** * 修改商品分类 * @param $data * @return \multitype */ public function editCategory($data) { $res = model('goods_category')->update($data, [ [ 'category_id', '=', $data['category_id'] ] ]); if ($res) { if (isset($data['commission_rate'])) { //修改对应商品的佣金比率 model('goods')->update([ 'commission_rate' => $data['commission_rate'] ], [ [ 'category_id', '=', $data['category_id'] ] ]); model('goods_sku')->update([ 'commission_rate' => $data['commission_rate'] ], [ [ 'category_id', '=', $data['category_id'] ] ]); model('recommend_category')->update([ 'category_name' => $data['category_name'] ], [ [ 'category_id', '=', $data['category_id'] ] ]); } } Cache::tag("goods_category")->clear(); Cache::tag("recommend_category")->clear(); return $this->success($res); } /** * 删除分类 * @param $category_id * @return \multitype */ public function deleteCategory($category_id) { $goods_category_info = $this->getCategoryInfo([ [ 'category_id', '=', $category_id ] ], "level"); $goods_category_info = $goods_category_info['data']; $field = "category_id_" . $goods_category_info['level']; $res = model('goods_category')->delete([ [ $field, '=', $category_id ] ]); Cache::tag("goods_category")->clear(); return $this->success($res); } /** * 获取商品分类信息 * @param array $condition * @param string $field */ public function getCategoryInfo($condition, $field = 'category_id,category_name,short_name,pid,level,is_show,sort,image,keywords,description,attr_class_id,attr_class_name,category_id_1,category_id_2,category_id_3,category_full_name,commission_rate,image_adv') { $data = json_encode([ $condition, $field ]); $cache = Cache::get("goods_category_getCategoryInfo_" . $data); if (!empty($cache)) { return $this->success($cache); } $res = model('goods_category')->getInfo($condition, $field); Cache::tag("goods_category")->set("goods_category_getCategoryInfo_" . $data, $res); return $this->success($res); } /** * 获取商品分类列表 * @param array $condition * @param string $field * @param string $order * @param null $limit * @return \multitype */ public function getCategoryList($condition = [], $field = 'category_id,category_name,short_name,pid,level,is_show,sort,image,attr_class_id,attr_class_name,category_id_1,category_id_2,category_id_3,commission_rate,image_adv', $order = '', $limit = null) { $data = json_encode([ $condition, $field, $order, $limit ]); $cache = Cache::get("goods_category_getCategoryList_" . $data); if (!empty($cache)) { return $this->success($cache); } $list = model('goods_category')->getList($condition, $field, $order, '', '', '', $limit); Cache::tag("goods_category")->set("goods_category_getCategoryList_" . $data, $list); return $this->success($list); } /** * 获取商品分类树结构 * @param int $level 查询等级 * @param array $condition * @param string $field * @param string $order * @param null $limit * @return \multitype */ public function getCategoryTree($condition = [], $field = 'category_id,category_name,short_name,pid,level,is_show,sort,image,attr_class_name,category_id_1,category_id_2,category_id_3,commission_rate', $order = 'category_id desc', $limit = null) { $data = json_encode([ $condition, $field, $order, $limit ]); $cache = Cache::get("goods_category_getCategoryTree_" . $data); if (!empty($cache)) { return $this->success($cache); } $list = model('goods_category')->getList($condition, $field, $order, '', '', '', $limit); $goods_category_list = []; //遍历一级商品分类 foreach ($list as $k => $v) { if ($v['level'] == 1) { $goods_category_list[] = $v; unset($list[ $k ]); } } $list = array_values($list); //遍历二级商品分类 foreach ($list as $k => $v) { foreach ($goods_category_list as $ck => $cv) { if ($v['level'] == 2 && $cv['category_id'] == $v['pid']) { $goods_category_list[ $ck ]['child_list'][] = $v; unset($list[ $k ]); } } } $list = array_values($list); //遍历三级商品分类 foreach ($list as $k => $v) { foreach ($goods_category_list as $ck => $cv) { if (!empty($cv['child_list'])) { foreach ($cv['child_list'] as $third_k => $third_v) { if ($v['level'] == 3 && $third_v['category_id'] == $v['pid']) { $goods_category_list[ $ck ]['child_list'][ $third_k ]['child_list'][] = $v; unset($list[ $k ]); } } } } } Cache::tag("goods_category")->set("goods_category_getCategoryTree_" . $data, $goods_category_list); return $this->success($goods_category_list); } /** * 获取商品分类分页列表 * @param array $condition * @param int $page * @param int $page_size * @param string $order * @param string $field * @return \multitype */ public function getCategoryPageList($condition = [], $page = 1, $page_size = PAGE_LIST_ROWS, $order = '', $field = 'category_id,category_name,short_name,pid,level,is_show,sort,image,category_id_1,category_id_2,category_id_3,category_full_name,commission_rate') { $data = json_encode([ $condition, $field, $order, $page, $page_size ]); $cache = Cache::get("goods_category_getCategoryPageList_" . $data); if (!empty($cache)) { return $this->success($cache); } $list = model('goods_category')->pageList($condition, $field, $order, $page, $page_size); Cache::tag("goods_category")->set("goods_category_getCategoryPageList_" . $data, $list); return $this->success($list); } /** * 获取商品分类列表 * @param array $condition * @param string $field * @param string $order * @param null $limit * @return \multitype */ public function getCategoryByParent($condition = [], $field = 'category_id,category_name,short_name,pid,level,is_show,sort,image,attr_class_id,attr_class_name,category_id_1,category_id_2,category_id_3,commission_rate', $order = '', $limit = null) { $data = json_encode([ $condition, $field, $order, $limit ]); $cache = Cache::get("goods_category_getCategoryByParent_" . $data); if (!empty($cache)) { return $this->success($cache); } $list = model('goods_category')->getList($condition, $field, $order, '', '', '', $limit); foreach ($list as $k => $v) { $child_count = model('goods_category')->getCount([ 'pid' => $v['category_id'] ]); $list[ $k ]['child_count'] = $child_count; } Cache::tag("goods_category")->set("goods_category_getCategoryByParent_" . $data, $list); return $this->success($list); } /** * 修改排序 * @param int $sort * @param int $category_id */ public function modifyGoodsCategorySort($sort, $category_id) { $res = model('goods_category')->update([ 'sort' => $sort ], [ [ 'category_id', '=', $category_id ] ]); Cache::tag("goods_category")->clear(); return $this->success($res); } }