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


### 开发日志

#### 20260226
- 1.新增成品检 检验批次 管理页面
- 2.数据库表： qm_batch
```
-- 创建检验批次表
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);
```