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)
    {
        $where = ['city_id'=>$request['city_id'],'title'=>trim($request['title'])];
        $template = $this->cmsContentTemplate->where($where)->get();
        foreach ($template->toArray() as $k=>$v){
            if ($v['is_open']==1){
                $template_id = $this->cmsContentTemplate->find($v['id']);
                $template_id->is_open = 0;
                $template_id->updated_at = date('Y-m-d H:i:s');
                $res = $template_id->save();
                if (!$res) {
                    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, '修改状态失败');
        }
    }
}