yueshengshop/app/model/goods/GoodsCategory.php

<?php
/**
 * Niushop商城系统 - 团队十年电商经验汇集巨献!
 * =========================================================
 * Copy right 2019-2029 山西牛酷信息科技有限公司, 保留所有权利。
 * ----------------------------------------------
 * 官方网址: https://www.niushop.com.cn
 * 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和使用。
 * 任何企业和个人不允许对程序代码以任何形式任何目的再发布。
 * =========================================================
 */

namespace app\model\goods;

use think\facade\Cache;
use app\model\BaseModel;

/**
 * 商品分类
 */
class GoodsCategory extends BaseModel
{
	
	/**
	 * 添加商品分类
	 * @param $data
	 * @return \multitype
	 */
	public function addCategory($data)
	{
		$category_id = model('goods_category')->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);
	}
}