已解决关于API时间区间查询问题

星球会员aisajan徽章-初出茅庐-猫叔的编程圈等级-LV3-猫叔的编程圈33天前更新
447

你好猫叔，今天遇到了一个问题，想实现查询时间区间（如：2024-08-12 00:00:00至2024-08-12 23:59:59）的数据，这个因为关联3个表（医废因子、医废员工、医废类别），3个表都有createtime的原因，都是报错。

按这个请求 

op:{"createtime":"BETWEEN"}
filter:{"createtime":"1723305600,1723391999"}

就报错，错误代码

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'createtime' in where clause is ambiguous

这个怎么解决呀

api 接口控制文件代码

<?php

namespace app\api\controller;

use think\Db;
use app\api\library\buiapi\Api;

class YifeiWushuiYinzi extends Api{

    protected $model = null;
	
	protected $noNeedRight = '*';
	protected $noNeedLogin = [];
	protected $_allow_func = ['index','add','edit','view','del'];
	protected $_search_field = ['id','fenlei_id','value','user_id','status','createtime','updatetime','deletetime'];
	
	use \app\api\library\buiapi\traits\Api;
	
    public function _initialize(){
        parent::_initialize();
        $this->model = new \app\api\model\YifeiWushuiYinzi;
	}
	
	    /**
     * 列表
     */
    public function index(){
        $this->request->filter('trim,strip_tags,xss_clean');
        list($where, $sort, $order, $offset, $limit) = $this->buildparams();
        $mixWhere = $this->buildwheres(implode(',',$this->_search_field));
        $list = $this->model->with(['yifeiwushuileibie','equipmentstaff'])->where($where)->where($mixWhere)->order($sort, $order)->paginate($limit);
        foreach ($list as $row) {
            $row->visible(['id','fenlei_id','value','user_id','status','createtime','updatetime','deletetime']);
            $row->visible(['yifeiwushuileibie']);
			$row->getRelation('yifeiwushuileibie')->visible(['id','pid','name','min_point','max_point','yiju','status','createtime','updatetime','deletetime']);
			$row->visible(['equipmentstaff']);
			$row->getRelation('equipmentstaff')->visible(['id','user_id','nickname','department_id','workno','ispw','position','openid','status','master','createtime','updatetime','deletetime']);

        }
        $list = $this->__handle_index__($list);
        return $this->success('数据列表',$list);
    }
}

api 模型文件

<?php

namespace app\api\model;

use think\Model;

class YifeiWushuiYinzi extends Model{

	protected $name = 'yifei_wushui_yinzi';
	
	public function yifeiwushuileibie()
	{
		return $this->belongsto('YifeiWushuiLeibie', 'fenlei_id', 'id', [], 'LEFT')->setEagerlyType(0);
	}
	public function equipmentstaff()
	{
		return $this->belongsto('EquipmentStaff', 'user_id', 'user_id', [], 'LEFT')->setEagerlyType(0);
	}
	public function getValueAttr($value)
    {
        return json_decode($value,true);
    }

	
}

 

post 负载代码

op: {"createtime":"BETWEEN"}
filter: {"createtime":"1723305600,1723391999"}
search: 
page: 1
limit: 20
sort: id
order: desc

如果按

op: {"fenlei_id":"="}
filter: {"fenlei_id":"3"}

就可以正常显示，接口回传数据

{
  "code": 1,
  "msg": "数据列表",
  "time": "1723608913",
  "data": {
    "total": 1739,
    "per_page": 20,
    "current_page": 1,
    "last_page": 87,
    "rows": [
      {
        "id": 1815,
        "fenlei_id": 6,
        "value": {
          "value1": "0",
          "value2": "0",
          "value3": "0",
          "value4": "0.0329"
        },
        "user_id": 337,
        "status": "正常",
        "createtime": 1723608458,
        "updatetime": 1723608458,
        "deletetime": null,
        "yifeiwushuileibie": {
          "id": 6,
          "pid": 1,
          "name": "总氯",
          "min_point": 0,
          "max_point": 0.5,
          "yiju": "GB18466-2005排放标准",
          "status": "正常",
          "createtime": 1704256278,
          "updatetime": 1709550085,
          "deletetime": null
        },
        "equipmentstaff": {
          "id": 336,
          "user_id": 337,
          "nickname": "努尔依力·沙吾尔",
          "department_id": 4,
          "workno": "9939",
          "ispw": 0,
          "position": "卫生员",
          "openid": "",
          "status": "normal",
          "master": 0,
          "createtime": null,
          "updatetime": 1715860905,
          "deletetime": null
        }
      },
      {
        "id": 1814,
        "fenlei_id": 3,
        "value": {
          "value1": "7.128"
        },
        "user_id": 337,
        "status": "正常",
        "createtime": 1723608435,
        "updatetime": 1723608435,
        "deletetime": null,
        "yifeiwushuileibie": {
          "id": 3,
          "pid": 1,
          "name": "PH值",
          "min_point": 6,
          "max_point": 9,
          "yiju": "GB18466-2005排放标准",
          "status": "正常",
          "createtime": 1704256204,
          "updatetime": 1709550057,
          "deletetime": null
        },
        "equipmentstaff": {
          "id": 336,
          "user_id": 337,
          "nickname": "努尔依力·沙吾尔",
          "department_id": 4,
          "workno": "9939",
          "ispw": 0,
          "position": "卫生员",
          "openid": "",
          "status": "normal",
          "master": 0,
          "createtime": null,
          "updatetime": 1715860905,
          "deletetime": null
        }
      },
      {
        "id": 1813,
        "fenlei_id": 1,
        "value": {
          "value1": "5.481"
        },
        "user_id": 337,
        "status": "正常",
        "createtime": 1723608424,
        "updatetime": 1723608424,
        "deletetime": null,
        "yifeiwushuileibie": {
          "id": 1,
          "pid": 1,
          "name": "COD",
          "min_point": 0,
          "max_point": 60,
          "yiju": "GB18466-2005排放标准",
          "status": "正常",
          "createtime": 1704256126,
          "updatetime": 1709550027,
          "deletetime": null
        },
        "equipmentstaff": {
          "id": 336,
          "user_id": 337,
          "nickname": "努尔依力·沙吾尔",
          "department_id": 4,
          "workno": "9939",
          "ispw": 0,
          "position": "卫生员",
          "openid": "",
          "status": "normal",
          "master": 0,
          "createtime": null,
          "updatetime": 1715860905,
          "deletetime": null
        }
      },
      {
        "id": 1812,
        "fenlei_id": 2,
        "value": {
          "value1": "12.312"
        },
        "user_id": 337,
        "status": "正常",
        "createtime": 1723608415,
        "updatetime": 1723608415,
        "deletetime": null,
        "yifeiwushuileibie": {
          "id": 2,
          "pid": 1,
          "name": "氨氮",
          "min_point": 0,
          "max_point": 15,
          "yiju": "GB18466-2005排放标准",
          "status": "正常",
          "createtime": 1704256138,
          "updatetime": 1709550042,
          "deletetime": null
        },
        "equipmentstaff": {
          "id": 336,
          "user_id": 337,
          "nickname": "努尔依力·沙吾尔",
          "department_id": 4,
          "workno": "9939",
          "ispw": 0,
          "position": "卫生员",
          "openid": "",
          "status": "normal",
          "master": 0,
          "createtime": null,
          "updatetime": 1715860905,
          "deletetime": null
        }
      },
      {
        "id": 1811,
        "fenlei_id": 4,
        "value": {
          "value1": "9.8854"
        },
        "user_id": 337,
        "status": "正常",
        "createtime": 1723608399,
        "updatetime": 1723478400,
        "deletetime": null,
        "yifeiwushuileibie": {
          "id": 4,
          "pid": 1,
          "name": "流量",
          "min_point": 0,
          "max_point": 0,
          "yiju": null,
          "status": "正常",
          "createtime": 1704256237,
          "updatetime": 1704256237,
          "deletetime": null
        },
        "equipmentstaff": {
          "id": 336,
          "user_id": 337,
          "nickname": "努尔依力·沙吾尔",
          "department_id": 4,
          "workno": "9939",
          "ispw": 0,
          "position": "卫生员",
          "openid": "",
          "status": "normal",
          "master": 0,
          "createtime": null,
          "updatetime": 1715860905,
          "deletetime": null
        }
      },
      {
        "id": 1810,
        "fenlei_id": 6,
        "value": {
          "value1": "0",
          "value2": "0",
          "value3": "0",
          "value4": "0.0263"
        },
        "user_id": 337,
        "status": "正常",
        "createtime": 1723547247,
        "updatetime": 1723547247,
        "deletetime": null,
        "yifeiwushuileibie": {
          "id": 6,
          "pid": 1,
          "name": "总氯",
          "min_point": 0,
          "max_point": 0.5,
          "yiju": "GB18466-2005排放标准",
          "status": "正常",
          "createtime": 1704256278,
          "updatetime": 1709550085,
          "deletetime": null
        },
        "equipmentstaff": {
          "id": 336,
          "user_id": 337,
          "nickname": "努尔依力·沙吾尔",
          "department_id": 4,
          "workno": "9939",
          "ispw": 0,
          "position": "卫生员",
          "openid": "",
          "status": "normal",
          "master": 0,
          "createtime": null,
          "updatetime": 1715860905,
          "deletetime": null
        }
      }
    ]
  }
}

数据库文件

数据表 fa_yifei_wushui_yinzi

-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- 主机： localhost
-- 生成日期： 2024-08-14 11:24:13
-- 服务器版本： 5.7.44-log
-- PHP 版本： 8.0.26

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- 数据库： `test`
--

-- --------------------------------------------------------

--
-- 表的结构 `fa_yifei_wushui_yinzi`
--

CREATE TABLE `fa_yifei_wushui_yinzi` (
  `id` int(10) NOT NULL COMMENT 'ID',
  `fenlei_id` int(10) NOT NULL COMMENT '分类ID',
  `value` longtext COLLATE utf8mb4_unicode_ci COMMENT '数值',
  `user_id` int(11) DEFAULT '0',
  `status` enum('正常','隐藏') COLLATE utf8mb4_unicode_ci DEFAULT '正常' COMMENT '状态',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='污水因子数据';

--
-- 转存表中的数据 `fa_yifei_wushui_yinzi`
--

INSERT INTO `fa_yifei_wushui_yinzi` (`id`, `fenlei_id`, `value`, `user_id`, `status`, `createtime`, `updatetime`, `deletetime`) VALUES
(1, 1, '{\"value1\":333}', 0, '正常', 1704824122, 1704824122, NULL),
(2, 1, '{\"value1\":\"333\"}', 0, '正常', 1704824189, 1704824189, NULL),
(3, 1, '{\"value1\":\"12\"}', 0, '正常', 1704824620, 1704824620, NULL),
(4, 5, '{\"value1\":\"111\",\"value2\":\"222\",\"value3\":\"333\",\"value4\":\"444\"}', 3, '正常', 1704827752, 1704827752, NULL),
(5, 6, '{\"value1\":\"122\",\"value2\":\"233\",\"value3\":\"344\",\"value4\":\"455\"}', 3, '正常', 1704827824, 1704827824, NULL),
(6, 4, '{\"value1\":\"46\"}', 3, '正常', 1704828265, 1704828265, NULL),



--
-- 转储表的索引
--

--
-- 表的索引 `fa_yifei_wushui_yinzi`
--
ALTER TABLE `fa_yifei_wushui_yinzi`
  ADD PRIMARY KEY (`id`);

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `fa_yifei_wushui_yinzi`
--
ALTER TABLE `fa_yifei_wushui_yinzi`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=1811;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

数据表 fa_yifei_wushui_leibie

-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- 主机： localhost
-- 生成日期： 2024-08-14 11:28:20
-- 服务器版本： 5.7.44-log
-- PHP 版本： 8.0.26

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- 数据库： `xiaofang`
--

-- --------------------------------------------------------

--
-- 表的结构 `fa_yifei_wushui_leibie`
--

CREATE TABLE `fa_yifei_wushui_leibie` (
  `id` int(10) NOT NULL COMMENT 'ID',
  `pid` int(10) NOT NULL COMMENT '分类',
  `name` varchar(255) CHARACTER SET utf8mb4 NOT NULL COMMENT '名称',
  `min_point` float NOT NULL DEFAULT '0' COMMENT '最低限',
  `max_point` float NOT NULL DEFAULT '0' COMMENT '最高限',
  `yiju` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '依据',
  `status` enum('正常','隐藏') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '状态',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `deletetime` bigint(19) DEFAULT NULL COMMENT '删除时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='医疗废物污水因子分类';

--
-- 转存表中的数据 `fa_yifei_wushui_leibie`
--

INSERT INTO `fa_yifei_wushui_leibie` (`id`, `pid`, `name`, `min_point`, `max_point`, `yiju`, `status`, `createtime`, `updatetime`, `deletetime`) VALUES
(1, 1, 'COD', 0, 60, 'GB18466-2005排放标准', '正常', 1704256126, 1709550027, NULL),
(2, 1, '氨氮', 0, 15, 'GB18466-2005排放标准', '正常', 1704256138, 1709550042, NULL),
(3, 1, 'PH值', 6, 9, 'GB18466-2005排放标准', '正常', 1704256204, 1709550057, NULL),
(4, 1, '流量', 0, 0, NULL, '正常', 1704256237, 1704256237, NULL),
(5, 1, '余氯', 2, 8, '上级下发文件', '隐藏', 1704256268, 1712110141, NULL),
(6, 1, '总氯', 0, 0.5, 'GB18466-2005排放标准', '正常', 1704256278, 1709550085, NULL);

--
-- 转储表的索引
--

--
-- 表的索引 `fa_yifei_wushui_leibie`
--
ALTER TABLE `fa_yifei_wushui_leibie`
  ADD PRIMARY KEY (`id`);

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `fa_yifei_wushui_leibie`
--
ALTER TABLE `fa_yifei_wushui_leibie`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=7;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

数据表 fa_equipment_staff

-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- 主机： localhost
-- 生成日期： 2024-08-14 11:29:25
-- 服务器版本： 5.7.44-log
-- PHP 版本： 8.0.26

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- 数据库： `test`
--

-- --------------------------------------------------------

--
-- 表的结构 `fa_equipment_staff`
--

CREATE TABLE `fa_equipment_staff` (
  `id` bigint(20) UNSIGNED NOT NULL COMMENT 'ID',
  `user_id` bigint(20) DEFAULT '0' COMMENT '用户ID',
  `nickname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '昵称',
  `department_id` bigint(20) DEFAULT '0' COMMENT '部门ID',
  `workno` char(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '工号',
  `ispw` int(1) NOT NULL DEFAULT '0' COMMENT '首次更改密码状态',
  `position` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '职位',
  `openid` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'OPENID',
  `app_mode` enum('0','1','2','3') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT 'app模式:0=标准模式,1=关爱模式,2=新春模式,3=简化模式',
  `duty` varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '职务',
  `status` enum('normal','hidden') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'normal' COMMENT '状态',
  `equipment_manage` tinyint(1) NOT NULL DEFAULT '0' COMMENT '管理权限',
  `equipment_manage1` tinyint(1) NOT NULL DEFAULT '0' COMMENT '消防操作栏权限',
  `equipment_manage2` tinyint(1) NOT NULL DEFAULT '0' COMMENT '消防管理栏权限',
  `equipment_manage3` tinyint(1) NOT NULL DEFAULT '0' COMMENT '日常工作栏权限',
  `master` tinyint(1) NOT NULL DEFAULT '0' COMMENT '管理权限',
  `authority` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户权限',
  `equipment_kaoqinqiandao` tinyint(1) NOT NULL DEFAULT '0' COMMENT '考勤签到权限',
  `equipment_shenqingjiaban` tinyint(1) NOT NULL DEFAULT '0' COMMENT '申请加班权限',
  `equipment_qingjiashenqing` tinyint(1) NOT NULL DEFAULT '0' COMMENT '请假申请权限',
  `equipment_kaoqinshenhe` tinyint(1) NOT NULL DEFAULT '0' COMMENT '考勤审核权限',
  `equipment_jiabanshenhe` tinyint(1) NOT NULL DEFAULT '0' COMMENT '加班审核权限',
  `equipment_qingjiashenhe` tinyint(1) NOT NULL DEFAULT '0' COMMENT '请假审核权限',
  `equipment_shebeixuncha` tinyint(1) NOT NULL DEFAULT '0' COMMENT '设备巡查权限',
  `equipment_shebeibaoyang` tinyint(1) DEFAULT '0' COMMENT '设备保养权限',
  `equipment_shenbaoweixiu` tinyint(1) NOT NULL DEFAULT '0' COMMENT '申报维修权限',
  `equipment_shebeiweixiudengji` tinyint(1) NOT NULL DEFAULT '0' COMMENT '设备维修登记权限',
  `equipment_shebeishenyan` tinyint(1) NOT NULL DEFAULT '0' COMMENT '设备审验权限',
  `equipment_shebeibaofei` tinyint(1) NOT NULL DEFAULT '0' COMMENT '设备报废权限',
  `equipment_zhongdianbuweixunjian` tinyint(1) NOT NULL DEFAULT '0' COMMENT '重点部位巡检权限',
  `equipment_shebeiruku` tinyint(1) NOT NULL DEFAULT '0' COMMENT '设备入库权限',
  `equipment_shebeipeifa` tinyint(1) NOT NULL DEFAULT '0' COMMENT '设备配发权限',
  `equipment_dianweichaxun` tinyint(1) NOT NULL DEFAULT '0' COMMENT '点位查询权限',
  `equipment_daijiegongdan` tinyint(1) NOT NULL DEFAULT '0' COMMENT '待接工单权限',
  `equipment_wodegongdan` tinyint(1) NOT NULL DEFAULT '0' COMMENT '我的工单权限',
  `equipment_shebeidangan` tinyint(1) NOT NULL DEFAULT '0' COMMENT '设备档案权限',
  `equipment_xunjianguanli` tinyint(1) NOT NULL DEFAULT '0' COMMENT '巡检管理权限',
  `equipment_zhongdianbuweiguanli` tinyint(1) NOT NULL DEFAULT '0' COMMENT '重点部位管理权限',
  `equipment_shebeibaoyangguanli` tinyint(1) NOT NULL DEFAULT '0' COMMENT '设备保养管理权限',
  `equipment_shebeijianyanguanli` tinyint(1) NOT NULL DEFAULT '0' COMMENT '设备检验管理权限',
  `equipment_baofeishebeiguanli` tinyint(1) NOT NULL DEFAULT '0' COMMENT '报废设备管理权限',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
  `weigh` int(11) DEFAULT '0' COMMENT '排序'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='员工管理表';

--
-- 转存表中的数据 `fa_equipment_staff`
--

INSERT INTO `fa_equipment_staff` (`id`, `user_id`, `nickname`, `department_id`, `workno`, `ispw`, `position`, `openid`, `app_mode`, `duty`, `status`, `equipment_manage`, `equipment_manage1`, `equipment_manage2`, `equipment_manage3`, `master`, `authority`, `equipment_kaoqinqiandao`, `equipment_shenqingjiaban`, `equipment_qingjiashenqing`, `equipment_kaoqinshenhe`, `equipment_jiabanshenhe`, `equipment_qingjiashenhe`, `equipment_shebeixuncha`, `equipment_shebeibaoyang`, `equipment_shenbaoweixiu`, `equipment_shebeiweixiudengji`, `equipment_shebeishenyan`, `equipment_shebeibaofei`, `equipment_zhongdianbuweixunjian`, `equipment_shebeiruku`, `equipment_shebeipeifa`, `equipment_dianweichaxun`, `equipment_daijiegongdan`, `equipment_wodegongdan`, `equipment_shebeidangan`, `equipment_xunjianguanli`, `equipment_zhongdianbuweiguanli`, `equipment_shebeibaoyangguanli`, `equipment_shebeijianyanguanli`, `equipment_baofeishebeiguanli`, `createtime`, `updatetime`, `deletetime`, `weigh`) VALUES
(1, 1, '李强', 5, '8', 0, '副院长', '', '0', NULL, 'hidden', 1, 1, 1, 0, 0, '', 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, NULL, 1693545336, NULL, 0),
(336, 337, '张燕青', 4, '9939', 0, '医废专员', '', '0', NULL, 'normal', 0, 0, 0, 0, 0, '{\"equipment_manage\":0,\"equipment_kaoqinqiandao\":0,\"equipment_shenqingjiaban\":0,\"equipment_qingjiashenqing\":0,\"master\":0,\"equipment_kaoqinshenhe\":0,\"equipment_jiabanshenhe\":0,\"equipment_qingjiashenhe\":0,\"equipment_shebeixuncha\":0,\"equipment_shebeibaoyang\":0,\"equipment_shenbaoweixiu\":0,\"equipment_shebeiweixiudengji\":0,\"equipment_shebeibaofei\":0,\"equipment_zhongdianbuweixunjian\":0,\"equipment_shebeiruku\":0,\"equipment_shebeipeifa\":0,\"equipment_dianweichaxun\":0,\"equipment_daijiegongdan\":0,\"equipment_wodegongdan\":0,\"equipment_shebeidangan\":0,\"equipment_xunjianguanli\":0,\"equipment_zhongdianbuweiguanli\":0,\"equipment_shebeibaoyangguanli\":0,\"equipment_shebeijianyanguanli\":0,\"equipment_baofeishebeiguanli\":0,\"equipment_manage1\":0,\"equipment_manage2\":0,\"equipment_manage3\":0,\"equipment_shebeishenyan\":0}', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 1715860905, NULL, 0),


--
-- 转储表的索引
--

--
-- 表的索引 `fa_equipment_staff`
--
ALTER TABLE `fa_equipment_staff`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `fa_equipment_staff`
--
ALTER TABLE `fa_equipment_staff`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=371;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1
1人已评分
分享
请登录后发表评论

    请登录后查看评论内容

分享
默认板块-猫叔的编程圈

默认板块

暂未分组的临时板块，后续将手动分组
发布
帖子
48
互动
85
阅读
1725

跨域资料解决方案表格签名源码正则模型查询条件摄像头插件开发插件按钮报错微信登录工具小程序实战基础命令行

猫叔的b站主页
点击前往b站
点击可直接进入猫叔的视频主页查看高清视频教程。
查看详情
发布文章发布帖子
扫码添加微信-猫叔的编程圈
在手机上浏览此页面