vocs.com/application/admin/controller/item/Check.php

<?php

namespace app\admin\controller\item;

use app\common\controller\Backend;
use \think\Session;
use \think\Db;
/**
 * 检测项目管理
 *
 * @icon fa fa-circle-o
 */
class Check extends Backend
{

    /**
     * Check模型对象
     * @var \app\admin\model\item\Check
     */
    protected $model = null;
    protected $searchFields = 'name,check_no,check_name';
    public function _initialize()
    {
        parent::_initialize();
        $this->model = new \app\admin\model\item\Check;
        $this->view->assign("statusList", $this->model->getStatusList());
        $this->view->assign("isChildList", $this->model->getIsChildList());
    }



    /**
     * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
     * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
     * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
     */

    /**
     * 添加
     *
     * @return string
     * @throws \think\Exception
     */
    public function add()
    {
        if (false === $this->request->isPost()) {
            return $this->view->fetch();
        }
        $baseData = $this->request->post('baseData/a');
        $data = $this->request->post('data/a');
        if (empty($baseData)) {
            $this->error(__('Parameter %s can not be empty', ''));
        }
        //基础数据
        $params['name'] = $baseData[0];
        $params['check_no'] = $baseData[1];
        $params['check_name'] = $baseData[2];
        $params['unit'] = $baseData[3];
        $params['check_max'] = $baseData[4];
        $params['check_min'] = $baseData[5];
        $params['class'] = $baseData[6];
        $params['scope'] = $baseData[7];
        $params['status'] = $baseData[8];
        $params['remark'] = $baseData[9];
        $params['is_child'] = $baseData[10];
        $params['create'] = $baseData[11];
        $params['userid'] = Session::get('admin')['id'];
        $validate =  $this->validate($params,'admin/item/Check.add');
        if (true !== $validate){
            $this->error($validate);
        }
        if ($params['is_child'] == 0 && ($params['check_max'] == '' || $params['check_min'] == '')){
            $this->error('没有子项,检出限和定量限不能为空');
        }
        $result = true;
        Db::startTrans();
        try {
            $pid = Db::name('item_check')->insertGetId($params);
            if (!$pid){
                $result = false;
            }
            if ($params['is_child'] == 1 && !empty($data)){
                $childData = [];
                foreach ($data as $key => $value){
                    $childData[$key]['pid'] = $pid;
                    $childData[$key]['p_name'] = $value[0];
                    $childData[$key]['name'] = $value[1];
                    $childData[$key]['unit'] = $value[2];
                    $childData[$key]['check_max'] = $value[3];
                    $childData[$key]['check_min'] = $value[4];
                    $childData[$key]['create'] = date('Y-m-d H:i:s');
                }
                $res = Db::name('item_check_detail')->insertAll($childData);
                if (!$res){
                    $result = false;
                }
            }
            Db::commit();
        } catch (ValidateException|PDOException|Exception $e) {
            Db::rollback();
            $this->error($e->getMessage());
        }
        if ($result === false) {
            $this->error(__('No rows were inserted'));
        }
        $this->success();
    }

    /**
     * 编辑
     *
     * @param $ids
     * @return string
     * @throws DbException
     * @throws \think\Exception
     */
    public function edit($ids = null)
    {
        if (false === $this->request->isPost()) {
            $row = $this->model->get($ids);
            if (!$row) {
                $this->error(__('No Results were found'));
            }
            $adminIds = $this->getDataLimitAdminIds();
            if (is_array($adminIds) && !in_array($row[$this->dataLimitField], $adminIds)) {
                $this->error(__('You have no permission'));
            }
            if ($row['is_child'] == 1){
                $childData = Db::name('item_check_detail')->where('pid',$row['id'])->where('status',1)->order('sort asc')->select();
                $this->view->assign('childData', $childData);
            }
            $this->view->assign('row', $row);
            return $this->view->fetch();
        }

        $baseData = $this->request->post('baseData/a');
        $data = $this->request->post('data/a');

        if (empty($baseData)) {
            $this->error(__('Parameter %s can not be empty', ''));
        }
        //基础数据
        $params['name'] = $baseData[0];
        $params['check_no'] = $baseData[1];
        $params['check_name'] = $baseData[2];
        $params['unit'] = $baseData[3];
        $params['check_max'] = $baseData[4];
        $params['check_min'] = $baseData[5];
        $params['class'] = $baseData[6];
        $params['scope'] = $baseData[7];
        $params['status'] = $baseData[8];
        $params['remark'] = $baseData[9];
        $params['is_child'] = $baseData[10];
        $params['update'] = date('Y-m-d H:i:s');
        $pid = $baseData[12];//主键id
        $validate =  $this->validate($params,'admin/item/Check.edit');
        if (true !== $validate){
            $this->error($validate);
        }
        if ($params['is_child'] == 0 && ($params['check_max'] == '' || $params['check_min'] == '')){
            $this->error('没有子项,检出限和定量限不能为空');
        }
        $insertData = [];  //新增的子项
        $updateData = []; //修改的子项
        $idList = []; //删除的子项id
        if ($params['is_child'] == 1 && !empty($data)){
            foreach ($data as $key => $value){
                if ($value[5] == 0){
                    $insertData[$key]['pid'] = $pid;
                    $insertData[$key]['p_name'] = $value[0];
                    $insertData[$key]['name'] = $value[1];
                    $insertData[$key]['unit'] = $value[2];
                    $insertData[$key]['check_max'] = $value[3];
                    $insertData[$key]['check_min'] = $value[4];
                    $insertData[$key]['create'] = date('Y-m-d H:i:s');
                }else{
                    $updateData[$key]['p_name'] = $value[0];
                    $updateData[$key]['name'] = $value[1];
                    $updateData[$key]['unit'] = $value[2];
                    $updateData[$key]['check_max'] = $value[3];
                    $updateData[$key]['check_min'] = $value[4];
                    $updateData[$key]['id'] = $value[5];
                    $idList[$key] = $value[5];
                }
            }
        }

        $result = true;
        Db::startTrans();
        try {
            Db::name('item_check')->where('id',$pid)->update($params);
            if (!empty($idList)){
                $idRes = Db::name('item_check_detail')->where('pid',$pid)->where('id','not in',$idList)->setField('status',0);
            }
            if (!empty($insertData)){
                $insertRes =  Db::name('item_check_detail')->insertAll($insertData);
                if (!$insertRes){
                    $result = false;
                }
            }
            if (!empty($updateData)){
                foreach ($updateData as $k=>$v){
                    Db::name('item_check_detail')->where('id',$v['id'])->update($v);
                }
            }
            //如果修改成没有子项，删除其关联子项
            if ($params['is_child'] == 0){
                Db::name('item_check_detail')->where('pid',$pid)->setField('status',0);
            }
            Db::commit();
        } catch (ValidateException|PDOException|Exception $e) {
            Db::rollback();
            $this->error($e->getMessage());
        }
        if (false === $result) {
            $this->error(__('No rows were updated'));
        }
        $this->success();
    }

}