cms-service/app/Http/Repositories/CmsContentTemplateSetRepository.php

<?php

namespace App\Repositories;

use App\Models\CmsContentTemplate;
use App\Models\CmsContentTemplateSet;
use App\Models\CmsSubjectProduct;
use App\Models\CmsSubject;
use Symfony\Component\HttpKernel\Exception\HttpException;

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;
    }

    /**
     * 内容预览
     */
    public function preview($request)
    {
        $temalates = $this->cmsContentTemplate->select('title','id')->where(['city_id'=>$request['city_id'],'apply_type'=>$request['type'],'is_open'=>1])->first();
        if (!$temalates){
            throw new HttpException(500, '没有找到对应模板');
        }

        //团购首页
        $group_array = [];
        if ($request['type'] == 0){
            $group_array['apply_type'] ="group";
            $group_array['title'] =$temalates->title;
            $group_array['content'] =[];
        }else{//菜市场首页
            $group_array['apply_type'] ="market";
            $group_array['title'] =$temalates->title;
            $group_array['content'] =[];
        }

        $group_array['content'][0]['area_type'] ="banner";

        $banner_rule = $this->cmsContentTemplateSet->select('id','rule')->where(['tpl_id'=>$temalates->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'=>$temalates->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'=>$temalates->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('id','rule')->where(['tpl_id'=>$temalates->id,'area_type'=>3])->get();
            $new_rule = [];
            foreach ($category_rule->toArray() as $k=>$v){
                $new_rule[] = $v;
            }
            $group_array['content'][3]['rule'] = $new_rule;
        }

        return $group_array;

    }

    public function getTemplate($cityId){
        return $this->cmsContentTemplate->select('title','apply_type')->where(['city_id'=>$cityId,'is_open'=>1])->orderBy('apply_type','asc')->get();
    }
}