1. 物料基础设置
PLM项目
  • 根据字典类型获取字典信息
    • 查询字典详情
      GET
  • 出库申请
    • 获取详情信息
      GET
    • 创建申请单据
      POST
    • 更新申请单据
      POST
    • 创建申请明细
      POST
    • 更新申请明细
      POST
    • 删除申请明细
      POST
    • 审批接口
      POST
  • SMT接口
    • 字段说明
    • 获取部门信息
      GET
    • 获取仓库信息
      GET
    • 物料分页查询信息
      GET
    • 获取申请人信息
      GET
    • 新增
      POST
    • MST分页
      GET
    • 申请出库列表接口
      GET
    • 根据pid获取仓库信息
      GET
  • 文件管理模块
    • 文件夹功能
      • 新建文件夹
      • 修改文件夹
      • 文件夹列表
    • 文件功能
      • 文件新增功能
      • 文件修改功能
      • 文件查询接口
      • 业务模型下拉列表
      • 文件检出
      • 取消检出
      • 编辑详情接口
      • 版本历史
      • 删除接口
      • 检入操作
      • 审批
      • 在线接口保存
      • 文件升版本
    • 相关对象关联
      • 关联保存接口
      • 删除
      • 关联查询,给我id
      • 反查接口
  • 物料基础设置
    • 仓库档案
      • 仓库档案新增
      • 仓库档案修改
      • 仓库档案删除
      • 仓库档案详情
    • 计量单位
      • 计量单位新增
      • 计量单位同步到ERP
    • 存货编码
      • 存货编码大类tree
      • 存货编码大类新增
      • 存货编码大类编辑
      • 编码大类详情
      • 存货编码大类删除
    • 存货分类新增
      • 自动生成编码
      • 查询全部信息
      • 存货新增
      • 版本历史
    • Bom
      • bom母料新增
      • bom母料修改
      • 母料数据查询
      • 获取母料详情信息(用autoId)
      • 子类数据类型
      • 母料数据类型
      • 子料修改
      • 子料新增
      • 子料分页查询
      • 子料查询(查询一个)
      • 删除子料信息(多个)
      • 替代料查询列表
      • 替代料实体类
      • 新增替代料
      • 修改替代料
      • 单个详情替代料信息
    • 查询列表
      POST
  • PLM
    • 项目申请单
      • 新增项目申请单
      • 修改项目申请单
      • 查看单个项目申请单详情
      • 删除项目申请单
      • 项目申请单审批
      • 直接客户,终端客户信息接口
      • 开始审批的接口
    • 项目模板模块
      • 模板任务功能
        • 删除模板任务接口
        • 修改模板任务
        • 创建模板任务
        • 查看任务列表接口
      • 模板团队功能
        • 模板新增团队信息
        • 模板修改团队信息
        • 删除团队信息
        • 查看团队详情
      • 获取项目模板详情
      • 单个项目模板信息查询详情(包括项目任务,项目团队)
      • 项目模板信息新增
      • 项目模板信息修改
      • 项目模板删除功能
    • 项目任务管理(开始和结束按钮)
      • 根据某个项目获取任务列表信息
      • 任务开始
      • 查询详情信息
      • 任务结束
      • json在线模板上传
    • 项目基本信息
      • 项目基本信息新增
      • 项目申请单列表接口
      • 项目模板申请列表
      • 项目基本信息修改
      • 获取项目基本信息详情
      • 删除项目基本信息
  • crm
    • 供应商信息
      • 导入模板
      • 客户导入功能
  • 仓储信息
    • 发货看板
  • 获取用户精简信息列表,只包含被开启的用户,主要用于前端的下拉选项
    GET
  • 获取岗位列表信息
    GET
  • U8API
    POST
  • 获取U8物料名称信息
    GET
  • 在线模板详情
    GET
  • 找到上级接口
    GET
  • 数据模型
    • 文件基本信息
    • 母料模型
  1. 物料基础设置

查询列表

POST
localhost:58080/admin-api/plm/tqms-codegen-column/query

请求参数

Authorization
在 Header 添加参数
Authorization
,其值为在 Bearer 之后拼接 Token
示例:
Authorization: Bearer ********************
Body 参数application/json

示例
{
    "pageNo":"1",
    "pageSize":"2"
}

请求示例代码

Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location 'localhost:58080/admin-api/plm/tqms-codegen-column/query' \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '{
    "pageNo":"1",
    "pageSize":"2"
}'

返回响应

🟢200成功
application/json
Bodyapplication/json

示例
{"code":0,"data":{"list":[{"id":"1954376963772682253","tableId":"1954376963378417666","columnName":"deleted","dataType":"BIT","columnComment":"是否删除","nullable":false,"primaryKey":false,"ordinalPosition":31,"type":"Boolean","field":"deleted","dictType":"","example":null,"createOperation":false,"updateOperation":false,"listOperation":false,"listOperationCondition":"=","listOperationResult":false,"htmlType":"radio","createTime":1754794753000,"apiUrl":null,"width":null,"sort":null},{"id":"1954376963772682252","tableId":"1954376963378417666","columnName":"updater","dataType":"VARCHAR","columnComment":"更新者","nullable":true,"primaryKey":false,"ordinalPosition":30,"type":"String","field":"updater","dictType":"","example":null,"createOperation":false,"updateOperation":false,"listOperation":false,"listOperationCondition":"=","listOperationResult":false,"htmlType":"input","createTime":1754794753000,"apiUrl":null,"width":null,"sort":null},{"id":"1954376963772682251","tableId":"1954376963378417666","columnName":"update_time","dataType":"TIMESTAMP","columnComment":"更新时间","nullable":false,"primaryKey":false,"ordinalPosition":29,"type":"LocalDateTime","field":"updateTime","dictType":"","example":null,"createOperation":false,"updateOperation":false,"listOperation":false,"listOperationCondition":"BETWEEN","listOperationResult":false,"htmlType":"datetime","createTime":1754794753000,"apiUrl":null,"width":null,"sort":null},{"id":"1954376963772682250","tableId":"1954376963378417666","columnName":"create_time","dataType":"TIMESTAMP","columnComment":"创建时间","nullable":false,"primaryKey":false,"ordinalPosition":28,"type":"LocalDateTime","field":"createTime","dictType":"","example":null,"createOperation":false,"updateOperation":false,"listOperation":true,"listOperationCondition":"BETWEEN","listOperationResult":true,"htmlType":"datetime","createTime":1754794753000,"apiUrl":null,"width":null,"sort":null},{"id":"1954376963772682249","tableId":"1954376963378417666","columnName":"creator","dataType":"VARCHAR","columnComment":"创建者","nullable":true,"primaryKey":false,"ordinalPosition":27,"type":"String","field":"creator","dictType":"","example":null,"createOperation":false,"updateOperation":false,"listOperation":false,"listOperationCondition":"=","listOperationResult":false,"htmlType":"input","createTime":1754794753000,"apiUrl":null,"width":null,"sort":null},{"id":"1954376963772682248","tableId":"1954376963378417666","columnName":"define37","dataType":"TIMESTAMP","columnComment":"表体自定义项16(日期型)","nullable":true,"primaryKey":false,"ordinalPosition":26,"type":"LocalDateTime","field":"define37","dictType":"","example":null,"createOperation":true,"updateOperation":true,"listOperation":true,"listOperationCondition":"=","listOperationResult":true,"htmlType":"datetime","createTime":1754794753000,"apiUrl":null,"width":null,"sort":null},{"id":"1954376963772682247","tableId":"1954376963378417666","columnName":"define36","dataType":"TIMESTAMP","columnComment":"表体自定义项15(日期型)","nullable":true,"primaryKey":false,"ordinalPosition":25,"type":"LocalDateTime","field":"define36","dictType":"","example":null,"createOperation":true,"updateOperation":true,"listOperation":true,"listOperationCondition":"=","listOperationResult":true,"htmlType":"datetime","createTime":1754794753000,"apiUrl":null,"width":null,"sort":null},{"id":"1954376963772682246","tableId":"1954376963378417666","columnName":"define35","dataType":"INTEGER","columnComment":"表体自定义项14(整数型)","nullable":true,"primaryKey":false,"ordinalPosition":24,"type":"Integer","field":"define35","dictType":"","example":null,"createOperation":true,"updateOperation":true,"listOperation":true,"listOperationCondition":"=","listOperationResult":true,"htmlType":"input","createTime":1754794753000,"apiUrl":null,"width":null,"sort":null},{"id":"1954376963772682245","tableId":"1954376963378417666","columnName":"define34","dataType":"INTEGER","columnComment":"表体自定义项13(整数型)","nullable":true,"primaryKey":false,"ordinalPosition":23,"type":"Integer","field":"define34","dictType":"","example":null,"createOperation":true,"updateOperation":true,"listOperation":true,"listOperationCondition":"=","listOperationResult":true,"htmlType":"input","createTime":1754794753000,"apiUrl":null,"width":null,"sort":null},{"id":"1954376963772682244","tableId":"1954376963378417666","columnName":"define33","dataType":"VARCHAR","columnComment":"表体自定义项12","nullable":true,"primaryKey":false,"ordinalPosition":22,"type":"String","field":"define33","dictType":"","example":null,"createOperation":true,"updateOperation":true,"listOperation":true,"listOperationCondition":"=","listOperationResult":true,"htmlType":"input","createTime":1754794753000,"apiUrl":null,"width":null,"sort":null},{"id":"1954376963772682243","tableId":"1954376963378417666","columnName":"define32","dataType":"VARCHAR","columnComment":"表体自定义项11","nullable":true,"primaryKey":false,"ordinalPosition":21,"type":"String","field":"define32","dictType":"","example":null,"createOperation":true,"update
修改于 2025-08-20 05:32:17
上一页
单个详情替代料信息
下一页
新增项目申请单
Built with