注意事项

• 1.postgrest数据库时序数据表字段类型按照广丰已发布为准(表名带_time的表)，本地数据库表部分字段类型不对

开发日志

20260226

• 1.新增成品检 检验批次 管理页面
• 2.建表sql
  ```
  -- 创建检验批次表
  CREATE TABLE QM_BATCH (
  ID VARCHAR(50) NOT NULL,
  BATCH_CODE VARCHAR(50),
  BATCH_NAME VARCHAR(50),
  TYP VARCHAR(20),
  EQP_CODE VARCHAR(50),
  MAT_CODE VARCHAR(50),
  JUDGE_CODE VARCHAR(50),
  BATCH_DATE DATE,
  ISFLAG VARCHAR(2),
  ENABLED VARCHAR(2),
  TOTAL_NUM NUMERIC(22),
  RESULTS VARCHAR(50),
  APPROVER VARCHAR(50),
  AUDITOR VARCHAR(50),
  CREATER VARCHAR(50),
  TAB_DATE DATE,
  VER_NAME VARCHAR(50),
  VER_CODE VARCHAR(50),
  ARCH_DATE VARCHAR(50),
  FLAG VARCHAR(20),
  TO_MES_DATE DATE,
  FROM_MES_DATE DATE,
  DELETED NUMERIC(22),
  BATCH_DES VARCHAR(200),
  CATEGORY VARCHAR(2),
  MAKENO VARCHAR(60),
  SHIFTEQPNO VARCHAR(32),
  BOXNO VARCHAR(60),
  PID VARCHAR(50),
  REVIEWER VARCHAR(50),
  RVCOUNT NUMERIC(22),
  STATE VARCHAR(2),
  REVIEW_TIME DATE,
  AUDIT_TIME DATE,
  SPEC VARCHAR(50),
  APPROVE_TIME DATE,
  UNIT VARCHAR(50),
  ARRIVAL_TIME DATE,
  STORAGE_PLACE VARCHAR(50),
  CHECKER VARCHAR(20),
  RECEIVE_TIME DATE,
  INSP_TIME DATE,
  STORER VARCHAR(50),
  ISVERIFY VARCHAR(10),
  ISCHK VARCHAR(10),
  BAK1 VARCHAR(100),
  BAK2 VARCHAR(100),
  CONSTRAINT PK_QM_BATCH PRIMARY KEY (ID)
  );

-- 添加注释（可选）
COMMENT ON TABLE QM_BATCH IS '检验批次表';

COMMENT ON COLUMN QM_BATCH.ID IS '编码';
COMMENT ON COLUMN QM_BATCH.BATCH_CODE IS '批次代码';
COMMENT ON COLUMN QM_BATCH.BATCH_NAME IS '批次名称';
COMMENT ON COLUMN QM_BATCH.TYP IS 'A-制丝 B-成型 C-卷包 D-封箱 E-糖香料';
COMMENT ON COLUMN QM_BATCH.EQP_CODE IS '机台代码';
COMMENT ON COLUMN QM_BATCH.MAT_CODE IS '牌号';
COMMENT ON COLUMN QM_BATCH.JUDGE_CODE IS '判定依据代码';
COMMENT ON COLUMN QM_BATCH.BATCH_DATE IS '批次生成日期';
COMMENT ON COLUMN QM_BATCH.ISFLAG IS '使用标志';
COMMENT ON COLUMN QM_BATCH.ENABLED IS '启用标志';
COMMENT ON COLUMN QM_BATCH.TOTAL_NUM IS '到货总量';
COMMENT ON COLUMN QM_BATCH.RESULTS IS '综合判定';
COMMENT ON COLUMN QM_BATCH.APPROVER IS '批准人';
COMMENT ON COLUMN QM_BATCH.AUDITOR IS '审核人';
COMMENT ON COLUMN QM_BATCH.CREATER IS '创建人';
COMMENT ON COLUMN QM_BATCH.TAB_DATE IS '制表日期';
COMMENT ON COLUMN QM_BATCH.VER_NAME IS '版本名称';
COMMENT ON COLUMN QM_BATCH.VER_CODE IS '版本编号';
COMMENT ON COLUMN QM_BATCH.ARCH_DATE IS '保存期';
COMMENT ON COLUMN QM_BATCH.FLAG IS '0-未上传mes,1-已上传, 3-从MES下载';
COMMENT ON COLUMN QM_BATCH.TO_MES_DATE IS '上传MES时间';
COMMENT ON COLUMN QM_BATCH.FROM_MES_DATE IS '从MES时间下载';
COMMENT ON COLUMN QM_BATCH.DELETED IS '删除标志';
COMMENT ON COLUMN QM_BATCH.BATCH_DES IS '批次描述';
COMMENT ON COLUMN QM_BATCH.CATEGORY IS '类别 0：成品 1：辅材';
COMMENT ON COLUMN QM_BATCH.MAKENO IS '卷制工号';
COMMENT ON COLUMN QM_BATCH.SHIFTEQPNO IS '班次机号';
COMMENT ON COLUMN QM_BATCH.BOXNO IS '装箱号';
COMMENT ON COLUMN QM_BATCH.PID IS '父批次号';
COMMENT ON COLUMN QM_BATCH.REVIEWER IS '复核人';
COMMENT ON COLUMN QM_BATCH.RVCOUNT IS '复检次数';
COMMENT ON COLUMN QM_BATCH.STATE IS '批次状态';
COMMENT ON COLUMN QM_BATCH.REVIEW_TIME IS '复核日期';
COMMENT ON COLUMN QM_BATCH.AUDIT_TIME IS '审核日期';
COMMENT ON COLUMN QM_BATCH.SPEC IS '规格';
COMMENT ON COLUMN QM_BATCH.APPROVE_TIME IS '批准时间';
COMMENT ON COLUMN QM_BATCH.UNIT IS '到货单位';
COMMENT ON COLUMN QM_BATCH.ARRIVAL_TIME IS '到货日期';
COMMENT ON COLUMN QM_BATCH.STORAGE_PLACE IS '存放地点';
COMMENT ON COLUMN QM_BATCH.CHECKER IS '检验员';
COMMENT ON COLUMN QM_BATCH.RECEIVE_TIME IS '接单日期';
COMMENT ON COLUMN QM_BATCH.INSP_TIME IS '报检日期';
COMMENT ON COLUMN QM_BATCH.STORER IS '仓库保管员';
COMMENT ON COLUMN QM_BATCH.ISVERIFY IS '是否验证';
COMMENT ON COLUMN QM_BATCH.ISCHK IS '是否检验';
COMMENT ON COLUMN QM_BATCH.BAK1 IS '备用1';
COMMENT ON COLUMN QM_BATCH.BAK2 IS '备用2';

-- 创建索引（根据常用查询条件创建）
CREATE INDEX IDX_QM_BATCH_BATCH_CODE ON QM_BATCH(BATCH_CODE);
CREATE INDEX IDX_QM_BATCH_BATCH_DATE ON QM_BATCH(BATCH_DATE);
CREATE INDEX IDX_QM_BATCH_TYP ON QM_BATCH(TYP);
CREATE INDEX IDX_QM_BATCH_MAT_CODE ON QM_BATCH(MAT_CODE);
```