<?php

namespace App\Http\Logic\Bside\News;

use App\Http\Logic\Bside\BaseLogic;
use App\Models\News\News as NewsModel;
use App\Models\News\NewsCategory as NewsCategoryModel;
use App\Models\RouteMap\RouteMap;
use Illuminate\Support\Facades\DB;

class NewsCategoryLogic extends BaseLogic
{
    public function __construct()
    {
        parent::__construct();
        $this->model = new NewsCategoryModel();
        $this->param = $this->requestAll;
    }

    /**
     * @remark :获取详情
     * @name   :info_news_category
     * @author :lyh
     * @method :post
     * @time   :2023/10/19 16:04
     */
    public function info_news_category(){
        $info = $this->model->read($this->param);
        $info['url'] = $this->user['domain'] . $info['alias'];
        return $this->success($info);
    }

    /**
     * @remark :保存数据
     * @name   :newsCategorySave
     * @author :lyh
     * @method :post
     * @time   :2023/9/7 14:53
     */
    public function newsCategorySave(){
        //验证名称是否存在
        $this->verifyParamName($this->param['name']);
        DB::beginTransaction();
        try {
            if(isset($this->param['id']) && !empty($this->param['id'])){
                $this->param['operator_id'] = $this->user['id'];
                //查看路由是否更新
                $id = $this->editCategoryRoute($this->param['id'],$this->param['alias']);
                $this->editHandleCategory($this->param['id'],$this->param['pid']);
                $this->edit($this->param,['id'=>$this->param['id']]);
            }else{
                $this->param = $this->addParamProcessing($this->param);
                $id = $this->model->addReturnId($this->param);
                //当父级分类拥有产品时，处理子集
                $this->addProcessingSon($id);
            }
            $route = RouteMap::setRoute(isset($this->param['alias']) ? $this->param['alias'] : $this->param['name'], RouteMap::SOURCE_NEWS_CATE, $id, $this->user['project_id']);
            $this->model->edit(['alias'=>$route],['id'=>$id]);
            DB::commit();
        }catch (\Exception $e){
            DB::rollBack();
            $this->fail('系统错误，请联系管理员');
        }
        //更新通知记录表
        $this->updateNotify(['project_id'=>$this->user['project_id'], 'type'=>RouteMap::SOURCE_NEWS_CATE, 'route'=>$route]);
        return $this->success();
    }

    /**
     * @remark :编辑分类,处理博客数据
     * @name   :editCategory
     * @author :lyh
     * @method :post
     * @time   :2023/10/20 9:32
     */
    public function editHandleCategory($id,$pid){
        $info = $this->model->read(['id'=>$id],['id','pid']);
        if($info['pid'] != $pid){
            //修改勒上级，先查看上级是否拥有博客
            $newsModel = new NewsModel();
            $newsCount = $newsModel->formatQuery(['category_id'=>['like','%,'.$pid.',%']])->count();
            //随机获取最后一级id
            $replacement = $this->getLastId($id);
            if($newsCount > 0){
                //存在博客时，移动所有博客到当前分类最后一级
                $newsCount->where('category_id', 'like', '%,' . $pid . ',%')->where('category_id', 'like', '%,' . $replacement . ',%')
                    ->update(['category_id' => DB::raw("REPLACE(category_id, ',$pid,', ',')")]);
                $newsCount->where('category_id', 'like', '%,' . $pid . ',%')
                    ->update(['category_id' => DB::raw("REPLACE(category_id, ',$pid,', ',$replacement,')")]);
            }
        }
        return $this->success();
    }

    /**
     * @remark :随机获取当前id下最后一级的id
     * @name   :getLastId
     * @author :lyh
     * @method :post
     * @time   :2023/10/20 9:45
     */
    public function getLastId($id){
        $info = $this->model->read(['pid'=>$id],['id']);
        if($info !== false){
            return $this->getLastId($info['id']);
        }else{
            return $id;
        }
    }

    /**
     * @remark :编辑路由时生成路由记录
     * @name   :editCategoryRoute
     * @author :lyh
     * @method :post
     * @time   :2023/9/7 10:51
     */
    public function editCategoryRoute($id,$route){
        //生成一条删除路由记录
        $info = $this->model->read(['id'=>$id],['id','alias']);
        if($info['alias'] != $route){
            $data = [
                'source'=>RouteMap::SOURCE_NEWS_CATE,
                'route'=>$info['alias'],
            ];
            $this->setRouteDeleteSave($data);
        }
        return $id;
    }


    /**
     * @name :修改状态
     * @return array
     * @throws \App\Exceptions\BsideGlobalException
     * @author :liyuhang
     * @method
     */
    public function status_news_category(){
        $this->param['operator_id'] = $this->user['id'];
        $this->edit($this->param,['id'=>$this->param['id']]);
        return $this->success();
    }
    /**
     * @name :删除新闻分类
     * @return array
     * @throws \App\Exceptions\BsideGlobalException
     * @author :liyuhang
     * @method
     */
    public function del_news_category(){
        foreach ($this->param['id'] as $id){
            //查询是否有子分类
            $rs = $this->model->read(['pid'=>$id],['id']);
            if($rs !== false){
                $this->fail('当前分类拥有子分类不允许删除');
            }
            //查看当前分内下是否有商品
            $newsModel = new NewsModel();
            $rs = $newsModel->read(['category_id'=>$id],['id']);
            if($rs !== false){
                $this->fail('当前分类拥有商品，不允许删除');
            }
            $this->delRoute($id);
            $this->model->del(['id'=>$id]);
        }
        return $this->success();
    }

    /**
     * @name   :(添加分类时获取1级分类)categoryTopList
     * @author :lyh
     * @method :post
     * @time   :2023/6/13 9:09
     */
    public function categoryTopList(){
        $this->param['project_id'] = $this->user['project_id'];
        $this->param['status'] = 0;
        if(isset($this->param['id']) && !empty($this->param['id'])){
            $str = [];
            //排序掉当前id下所有子集
            $str = $this->getAllSub($this->param['id'],$str);
            $str[] = (int)$this->param['id'];
            $this->param['id'] = ['not in',$str];
        }
        $menu = array();
        $list = $this->model->list($this->param);
        if(!empty($list)){
            foreach ($list as $k => $v){
                if($v['pid'] == 0){
                    $v['sub'] = _get_child($v['id'],$list);
                    $menu[]   = $v;
                }
            }
        }
        return $this->success($menu);
    }

    /**
     * @remark :获取当前id下所有子集
     * @name   :getAllSub
     * @author :lyh
     * @method :post
     * @time   :2023/10/18 15:10
     */
    public function getAllSub($id,&$str = []){
        $list = $this->model->list(['pid'=>$id,'status'=>0],['id','pid']);
        if(!empty($list)){
            foreach ($list as $v){
                $str[] = $v['id'];
                $this->getAllSub($v['id'],$str);
            }
        }
        return $str;
    }

    /**
     * @name   :(验证名称是否存在)verifyParamName
     * @author :lyh
     * @method :post
     * @time   :2023/6/13 11:41
     */
    public function verifyParamName($name){
        if(isset($this->param['id']) && !empty($this->param['id'])){
            $condition = ['id'=>['!=',$this->param['id']], 'name'=>$name];
        }else{
            $condition = ['name'=>$name];
        }
        $info = $this->model->read($condition);
        if($info !== false){
            $this->fail('当前分类名称已存在');
        }
        return $this->success();
    }

    /**
     * @name   :(参数处理)paramProcessing
     * @author :lyh
     * @method :post
     * @time   :2023/6/13 11:30
     */
    public function addParamProcessing($param){
        $param['project_id'] = $this->user['project_id'];
        $param['operator_id'] = $this->user['id'];
        $param['create_id'] = $this->user['id'];
        return $this->success($param);
    }

    /**
     * @name   :(添加分类时处理子集分类)addProcessingSon
     * @author :lyh
     * @method :post
     * @time   :2023/6/13 11:34
     */
    public function addProcessingSon($cate_id){
        if(isset($this->param['pid']) && !empty($this->param['pid'])) {
            $this->param['pid'] = 0;
        }
        //判断为子分类时
        if($this->param['pid'] != 0) {
            //查看当前上级分类下是否有其他分类
            $cate_info = $this->model->read(['pid' => $this->param['pid'], 'id' => ['!=', $cate_id]]);
            if ($cate_info === false) {
                //查看当前上一级分类下是否有新闻
                $newsModel = new NewsModel();
                $news_count = $newsModel->where('category_id','like', '%,' . $this->param['pid'] . ',%')->count();
                if ($news_count > 0) {
                    $replacement = ',' . $cate_id . ',';
                    $old = ',' . $this->param['pid'] . ',';
                    //更新所有商品到当前分类
                    $newsModel->where('category_id', 'like', '%' . $old . '%')
                        ->update(['category_id' => DB::raw("REPLACE(category_id, '$old', '$replacement')")]);
                }
            }
        }
        return $this->success();
    }

    /**
     * @remark :删除路由
     * @name   :delRoute
     * @author :lyh
     * @method :post
     * @time   :2023/9/7 10:50
     */
    public function delRoute($id){
        //删除路由映射
        RouteMap::delRoute(RouteMap::SOURCE_NEWS_CATE, $id, $this->user['project_id']);
        //生成一条删除路由记录
        $info = $this->model->read(['id'=>$id],['id','alias']);
        $data = [
            'source'=>RouteMap::SOURCE_NEWS_CATE,
            'route'=>$info['alias'],
        ];
        $this->setRouteDeleteSave($data);
        return $this->success();
    }

    /**
     * 新闻导入：分类处理
     * @param $project_id
     * @param $user_id
     * @param $category
     * @return string
     * @throws \Exception
     * @author Akun
     * @date 2023/09/20 17:35
     */
    public function importNewsCategory($project_id,$user_id,$category){
        $return = [];

        $cate_arr = explode('/',$category);
        $p_cate = $cate_arr[0];
        $c_cate = $cate_arr[1];

        $p_category = $this->model->read(['name'=>$p_cate,'pid'=>0]);
        if(!$p_category){
            $p_id = $this->model->addReturnId(['name'=>$p_cate,'project_id'=>$project_id,'operator_id'=>$user_id,'create_id'=>$user_id]);

            $route = RouteMap::setRoute($p_cate, RouteMap::SOURCE_NEWS_CATE, $p_id, $project_id);
            $this->model->edit(['alias'=>$route],['id'=>$p_id]);
        }else{
            $p_id = $p_category['id'];
        }
        $return[] = $p_id;

        if($c_cate){
            $c_category = $this->model->read(['name'=>$c_cate,'pid'=>$p_id]);
            if(!$c_category){
                $c_id = $this->model->addReturnId(['name'=>$c_cate,'pid'=>$p_id,'project_id'=>$project_id,'operator_id'=>$user_id,'create_id'=>$user_id]);

                $route = RouteMap::setRoute($c_cate, RouteMap::SOURCE_NEWS_CATE, $c_id, $project_id);
                $this->model->edit(['alias'=>$route],['id'=>$c_id]);
            }else{
                $c_id = $c_category['id'];
            }
            $return[] = $c_id;
        }
        return $this->getLastCategory($return);
    }

    /**
     * @remark :获取最后一级分类id
     * @name   :getLastCategory
     * @author :lyh
     * @method :post
     * @time   :2023/10/20 9:02
     */
    public function getLastCategory($category){
        $str = '';
        foreach ($category as $v){
            $info = $this->model->read(['pid'=>$v]);
            if($info === false){
                $str .= $v.',';
            }
        }
        return ','.$str;
    }

    /**
     * @remark :排序
     * @name   :categorySort
     * @author :lyh
     * @method :post
     * @time   :2023/9/26 17:38
     */
    public function categorySort(){
        $rs = $this->model->edit(['sort'=>$this->param['sort']],['id'=>$this->param['id']]);
        if($rs === false){
            $this->fail('系统错误，请联系管理员');
        }
        return $this->success();
    }
}