php/app/controller/merchant/system/groupData/Group.php

<?php
/**
 * @package merchant
 *
 * @author xaboy
 * @day 2020-03-27
 *
 *
 */

namespace app\controller\merchant\system\groupData;


use crmeb\basic\BaseController;
use app\common\repositories\system\groupData\GroupRepository;
use app\validate\admin\GroupValidate;
use FormBuilder\Exception\FormBuilderException;
use think\App;
use think\db\exception\DataNotFoundException;
use think\db\exception\DbException;
use think\db\exception\ModelNotFoundException;
use think\facade\Db;

/**
 * Class Group
 * @package app\controller\admin\system\groupData
 * @author xaboy
 * @day 2020-03-27
 */
class Group extends BaseController
{
    /**
     * @var GroupRepository
     */
    private $repository;


    /**
     * GroupData constructor.
     * @param App $app
     * @param GroupRepository $repository
     */
    public function __construct(App $app, GroupRepository $repository)
    {
        parent::__construct($app);
        $this->repository = $repository;
    }


    /**
     * @param int $id
     * @return mixed
     * @throws DataNotFoundException
     * @throws DbException
     * @throws ModelNotFoundException
     * @author xaboy
     * @day 2020-03-27
     */
    public function get( $id)
    {
        $data = $this->repository->get($id)->hidden(['create_time', 'sort']);
        if (!$data)
            return app('json')->fail('数据组不存在1');
        else
            return app('json')->success($data);

    }

    /**
     * @return mixed
     * @throws DataNotFoundException
     * @throws DbException
     * @throws ModelNotFoundException
     * @author xaboy
     * @day 2020-04-01
     */
    public function lst()
    {
        [$page, $limit] = $this->getPage();
//        $where['mer_id']=$this->request->merId();
        $where['user_type']=1;
        $list = Db::name('system_group')->where($where)->page($page, $limit)->hidden(['fields', 'sort'])->order('sort desc,group_id desc')->select();
        $count =  Db::name('system_group')->where($where)->count();
        $data= compact('count', 'list');
        return app('json')->success($data);
    }


    /**
     * @param GroupValidate $validate
     * @return mixed
     * @author xaboy
     * @day 2020-03-27
     */
    public function create(GroupValidate $validate)
    {
        $data = $this->request->params(['group_name', 'group_info', 'user_type', 'group_key', ['fields', []], ['sort', 0]]);
        $validate->check($data);
        if ($this->repository->keyExists($data['group_key']))
            return app('json')->fail('数据组key已存在');
        $this->repository->create($data);
        return app('json')->success('添加成功');
    }

    /**
     * @return mixed
     * @throws FormBuilderException
     * @author xaboy
     * @day 2020-04-02
     */
    public function createTable()
    {
        return app('json')->success(formToData($this->repository->form()));
    }

    /**
     * @param int $id
     * @return mixed
     * @throws DataNotFoundException
     * @throws DbException
     * @throws ModelNotFoundException
     * @throws FormBuilderException
     * @author xaboy
     * @day 2020-04-02
     */
    public function updateTable($id)
    {
        if (!$this->repository->exists($id)) app('json')->fail('数据不存在');
        return app('json')->success(formToData($this->repository->updateForm($id)));
    }

    /**
     * @param int $id
     * @param GroupValidate $validate
     * @return mixed
     * @throws DbException
     * @author xaboy
     * @day 2020-03-27
     */
    public function update($id, GroupValidate $validate)
    {
        $data = $this->request->params(['group_name', 'group_info', 'user_type', 'group_key', ['fields', []], ['sort', 0]]);
        $validate->check($data);

        if (!$this->repository->exists($id))
            return app('json')->fail('数据组不存在');
        if ($this->repository->keyExists($data['group_key'], $id))
            return app('json')->fail('数据组key已存在');
        $this->repository->update($id, $data);
        return app('json')->success('修改成功');
    }

    /**
     * @param int $id
     * @return mixed
     * @throws DbException
     * @author xaboy
     * @day 2020-03-27
     */
    public function delete($id)
    {
        if (!$this->repository->exists($id))
            return app('json')->fail('数据组不存在');
        $this->repository->delete($id);
        return app('json')->success('删除成功');
    }
}