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;
use Tymon\JWTAuth\Facades\JWTAuth;

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[$k]['id'] = $v['id'];
            $new_rule[$k]['rule'] = \GuzzleHttp\json_decode($v['rule'],true);
        }
        $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[$k]['id'] = $v['id'];
            $new_rule[$k]['rule'] = \GuzzleHttp\json_decode($v['rule'],true);
        }
        $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[$k]['id'] = $v['id'];
            $new_rule[$k]['rule'] = \GuzzleHttp\json_decode($v['rule'],true);
        }
        foreach ($new_rule as $k=>$v){
            if($v){
                $rules = $v['rule'];
                $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, 'product_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[$k]['id'] = $v['id'];
                $new_rule[$k]['rule'] = \GuzzleHttp\json_decode($v['rule'],true);
            }
            $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();
    }

    public function productList($request)
    {
        $area_type = '';
        if ($request['area_type'] == 'floor'){
            $area_type = 2;
        }
        $template_set = $this->cmsContentTemplateSet->select('rule')->where(['area_type'=>$area_type,'id'=>$request['id']])->first();
        $template_array = json_decode($template_set->rule,true);

        $product = $this->cmsSubjectProduct->where('subject_id', $template_array['link_url'])->orderBy('sort', 'asc')->get();
        $pro_array = $product->toArray();
        $res_id = implode(",", array_column($pro_array, 'product_id'));

        try {
            $sign = generateSign([], config('customer.app_secret'));
            $url = config("customer.user-service-url").'/api/honmeProduct';
//            $url = '192.168.33.127:8080/honmeProduct';
            $url = 'https://api.dev.caihongxingqiu.com/product/honmeProduct';
            $array = [
                'json' => ['sign' => $sign,'ids' => $res_id], 'query' => [], 'http_errors' => false,'headers'=>['Authorization'=>"Bearer ".JWTAuth::getToken()]
            ];

            return http($url,$array);
        } catch (\Exception $e) {
            return [];
        }

    }
}