cms-manage/app/Repositories/CmsContentTemplateRepository.php

<?php

namespace App\Repositories;


use App\Models\CmsContentTemplate;
use Symfony\Component\HttpKernel\Exception\HttpException;

class CmsContentTemplateRepository {
    public function __construct(CmsContentTemplate $cmsContentTemplate) {

        $this->cmsContentTemplate = $cmsContentTemplate;
    }
    //模板列表
    public function index($request)
    {
        $perPage = isset($request['per_page']) ? $request['per_page'] : env('PER_PAGE');
        $where = [];
        if(isset($request['id'])){
            $where[] = ['id', '=', $request['id']];
        }
        if (isset($request['is_open'])){
            $where[] = ['is_open',$request['is_open']];
        }
        if (isset($request['city_id'])){
            $where[] = ['city_id',$request['city_id']];
        }

        return $this->cmsContentTemplate->where($where)->orderBy('id', 'asc')->paginate($perPage);

    }

    /**
     * 新建模板
     */
    public function create($request)
    {
        if($this->cmsContentTemplate->where(['city_id'=>$request['city_id'],'title'=>trim($request['title'])])->exists()){
            throw new HttpException(500, '当前城市该模块已经存在');
        }

        $subject = [
            'title' => $request['title'],
            'city_id' => $request['city_id'],
            'city_name' => $request['city_name'],
            'apply_type' => $request['apply_type'],
            'is_open' => $request['is_open'],
        ];

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

    /**
     * 修改模板状态
     */
    public function edit($request)
    {
        if ($request['is_open']==0){
            $where = [
                'apply_type'=>$request['apply_type'],
                'is_open'=>$request['is_open'],
                'city_id'=>$request['city_id'],
            ];
            $template = $this->cmsContentTemplate->where($where)->get();
            if (count($template)<1){
                throw new HttpException(500, '同一城市同一模板必须有一个状态开启');
            }
        }

        $template_id = $this->cmsContentTemplate->find($request['id']);
        $template_id->is_open = $request['is_open'];
        $template_id->updated_at = date('Y-m-d H:i:s');

        $res = $template_id->save();
        if (!$res) {
            throw new HttpException(500, '修改状态失败');
        }
    }
}