cms-manage/app/Repositories/CmsContentTemplateSetRepository.php

<?php

namespace App\Repositories;

use App\Models\CmsSubject;
use Dingo\Api\Http\Response;
use App\Models\CmsContentTemplate;
use App\Models\CmsContentTemplateSet;
use App\Models\CmsSubjectProduct;
use Symfony\Component\HttpKernel\Exception\HttpException;
use Illuminate\Support\Facades\DB;
use Illuminate\Database\QueryException;

class CmsContentTemplateSetRepository {
    public function __construct(CmsContentTemplateSet $cmsContentTemplateSet,CmsContentTemplate $cmsContentTemplate,CmsSubjectProduct $cmsSubjectProduct,CmsSubject $cmsSubject) {

        $this->cmsContentTemplateSet = $cmsContentTemplateSet;
        $this->cmsContentTemplate = $cmsContentTemplate;
        $this->cmsSubjectProduct = $cmsSubjectProduct;
        $this->cmsSubject = $cmsSubject;
    }

    /**
     * banner配置
     */
    public function bannerSet($request)
    {
            $rules = json_decode($request['rule'],true);
            if (is_array($rules)){
                if (count($rules)>10) {
                    throw new HttpException(500, '最多只能添加10个banner海报');
                }
                    $decode_floor = json_decode($request['rule'], true);
                    $count = count($decode_floor);
                    if ($count > 0) {
                        for ($i = 0; $i < $count; $i++) {
                            $subject = [
                                'rule' => json_encode($decode_floor[$i]),
                                'tpl_id' => $request['tpl_id'],
                                'area_type' => $request['area_type'],
                                'status' => 0,
                            ];
                            if (!$this->cmsContentTemplateSet->create($subject)) {
                                throw new HttpException(500, '添加失败');
                            }
                        }
                    }
            }else{
                throw new HttpException(500, '参数格式有误');
            }

    }

    /**
     * 专题广告配置
     */
    public function advertisementSet($request)
    {
            $subject = [
                'tpl_id' => $request['tpl_id'],
                'rule' => $request['rule'],
                'area_type' => $request['area_type'],
                'status' => 0,
            ];

            if (!$this->cmsContentTemplateSet->create($subject)) {
                throw new HttpException(500, '添加失败');
            }

    }

    /**
     * 商品楼层配置
     */
    public function floorSet($request)
    {
            $subject = [
                'tpl_id' => $request['tpl_id'],
                'rule' => $request['rule'],
                'area_type' => $request['area_type'],
                'status' => 0,
            ];

            if (!$this->cmsContentTemplateSet->create($subject)) {
                throw new HttpException(500, '添加失败');
            }

    }

    /**
     * 分类专题配置
     */
    public function categorySet($request)
    {
            $subject = [
                'tpl_id' => $request['tpl_id'],
                'rule' => $request['rule'],
                'area_type' => $request['area_type'],
                'status' => 0,
            ];

            if (!$this->cmsContentTemplateSet->create($subject)) {
                throw new HttpException(500, '添加失败');
            }

    }


    /**
     * 内容发布
     */
    public function release($request)
    {
        //同一个城市同一个模板(团购/菜市场) 只能有一种状态(草稿/发布),已发布的一旦被编辑把之前的直接删掉
        $templateSet = $this->cmsContentTemplateSet->where('tpl_id',$request['tpl_id'])->select('id','status')->get();
        $tem_array = $templateSet->toArray();
        foreach ($tem_array as $k=>$v) {
                if ($v['status'] == 1) {
                    $result = $this->cmsContentTemplateSet->where('id', $v['id'])->delete();
                    if (!$result) {
                        return Response::create([
                            'message' => '删除失败，请重试',
                            'status_code' => 500
                        ]);
                    }
                }
        }

                $res = $this->cmsContentTemplateSet->where('tpl_id',$request['tpl_id'])->update(['status'=>1]);
                if (!$res){
                    return Response::create([
                        'message'  => '修改失败，请重试',
                        'status_code'   => 500
                    ]);
                }

    }

    /**
     * 内容预览
     */
    public function preview($request)
    {
        //团购首页
        $group_array = [];
        if ($request['type'] == 0){
            $group_array['apply_type'] ="group";
            $group_array['title'] ="今日团购";
            $group_array['content'] =[];
        }else{//菜市场首页
            $group_array['apply_type'] ="market";
            $group_array['title'] ="菜市场";
            $group_array['content'] =[];
        }

        $group_array['content'][0]['area_type'] ="banner";
        $banner_rule = $this->cmsContentTemplateSet->select('id','rule')->where(['tpl_id'=>$request['tpl_id'],'area_type'=>0])->get();
        $new_rule = [];
        foreach ($banner_rule->toArray() as $k=>$v){
            $new_rule[] = $v;
        }
        $group_array['content'][0]['rule'] = $new_rule;

        $group_array['content'][1]['area_type'] ="special";
        $subject_rule = $this->cmsContentTemplateSet->select('id','rule')->where(['tpl_id'=>$request['tpl_id'],'area_type'=>1])->get();

        $new_rule = [];
        foreach ($subject_rule->toArray() as $k=>$v){
            $new_rule[] = $v;
        }
        $group_array['content'][1]['rule'] = $new_rule;

        $group_array['content'][2]['area_type'] ="floor";
        $floor_rule = $this->cmsContentTemplateSet->select('id','rule')->where(['tpl_id'=>$request['tpl_id'],'area_type'=>2])->get();
        $new_rule = [];
        foreach ($floor_rule->toArray() as $k=>$v){
            $new_rule[] = $v;
        }
        foreach ($new_rule as $k=>$v){
            $rules = json_decode($v['rule'],true);
                $show_type = $this->cmsSubject->select('show_type')->where('id', $rules['link_url'])->first();
                $product = $this->cmsSubjectProduct->where('subject_id', $rules['link_url'])->orderBy('sort', 'asc')->get();
                $pro_array = $product->toArray();
                $res_id = implode(",", array_column($pro_array, 'id'));
                $new_rule[$k]['product_id'] = $res_id;
                $new_rule[$k]['subject_id'] = $rules['link_url'];
                $new_rule[$k]['show_type'] = $show_type->show_type ?? '';
                unset($v['url']);
                unset($v['show_num']);
                unset($rules['link_url']);
                unset($v['link_type']);
        }
                $group_array['content'][2]['rule'] = $new_rule;

        if ($request['type'] == 1){
            $group_array['content'][3]['area_type'] ="category";
            $category_rule = $this->cmsContentTemplateSet->select('rule')->where(['tpl_id'=>$request['tpl_id'],'area_type'=>3])->get();
            $new_rule = [];
            foreach ($category_rule->toArray() as $k=>$v){
                $new_rule[] = $v;
            }
            $group_array['content'][3]['rule'] = $new_rule;
        }

        $group_json = json_encode($group_array,JSON_UNESCAPED_UNICODE);

        return $group_json;

    }

}