apisongcan/application/index/model/CabinetModel.php

<?php

namespace app\index\model;

use think\Model;
use app\index\model\BoxModel;

class CabinetModel extends Model{
    // 确定链接表名
    protected $name = 'cabinet';

    /**
     * 插入柜子信息
     * @param $param
     */
    public function insertCabinet($param)
    {
        try{
            $this->startTrans();
            $result = $this->save($param);
            if(false === $result){
                $this->rollback();
                // 验证失败 输出错误信息
                return msg(-1, '', $this->getError());
            }else{
                $cabinet_number = $this->id;
                $boxData = [];
                for ($i=1; $i<=$param['box_number']; $i++){
                    $boxData['cabinet_number']  = $cabinet_number;
                    $boxData['box_number']      = $i;
                    $saveAllData[] = $boxData;
                }
                $BoxModel = new BoxModel();
                $result = $BoxModel->saveAll($saveAllData);
                if(false === $result){
                    $this->rollback();
                    return msg(-1, '', $this->getError());
                }else{
                    $this->commit();
                    return msg(1, '', '添加成功');
                }
            }
        }catch(PDOException $e){
            $this->rollback();
            return msg(-2, '', $e->getMessage());
        }
    }
}