refactor(database): 移除投机交易名称字段

liyong

2026-04-21 d64fbf9b6297d13472c920ccdb7eea4d5e98babe

refactor(database): 移除投机交易名称字段

- 从ProductModel实体类中删除speculativeTradingName字段及其注释
- 从ProcessRouteItemMapper.xml查询语句中移除投机交易名称字段
- 从ProductModelMapper.xml结果映射中删除投机交易名称字段
- 从SalesLedgerSchedulingMapper.xml查询语句中移除投机交易名称字段
- 从SalesLedgerWorkMapper.xml查询语句中移除投机交易名称字段

 src/main/java/com/ruoyi/basic/pojo/ProductModel.java

@@ -42,11 +42,7 @@
    @Excel(name = "单位")
    private String unit;

    /**
     * 生产炒机
     */
    @Excel(name = "生产炒机")
    private String speculativeTradingName;


    @ApiModelProperty(value = "租户ID")
    @TableField(fill = FieldFill.INSERT)

 src/main/resources/mapper/basic/ProductModelMapper.xml

@@ -9,7 +9,6 @@
        <result column="product_id" property="productId" />
        <result column="model" property="model" />
        <result column="unit" property="unit" />
        <result column="speculative_trading_name" property="speculativeTradingName" />
        <result column="tenant_id" property="tenantId" />
        <result column="product_name" property="productName" />
        <result column="product_id" property="productId" />

 src/main/resources/mapper/production/ProcessRouteItemMapper.xml

@@ -19,7 +19,6 @@
               pp.name as process_name,
               pp.is_inbound as inbound,
               pp.is_report_work as reportWork,
               pm.speculative_trading_name,
               pm.product_id,
               pm.model,
               p.product_name,

 src/main/resources/mapper/production/SalesLedgerSchedulingMapper.xml

@@ -15,7 +15,6 @@
        T2.quantity,
        T2.product_category,
        T2.specification_model,
        T2.speculative_trading_name,
        T2.unit
        FROM
        sales_ledger_product T2
@@ -76,7 +75,6 @@
        T2.status,
        T2.scheduling_user_id,
        T2.scheduling_user_name,
        T2.speculative_trading_name,
        T2.scheduling_date,
        ifNull(T2.scheduling_num,0) AS schedulingNum,
        ifNull(T2.finished_num,0) AS successNum,

 src/main/resources/mapper/production/SalesLedgerWorkMapper.xml

@@ -23,7 +23,6 @@
        t3.product_category,
        t3.specification_model,
        t3.unit,
        t2.speculative_trading_name,
        t4.production_line
        FROM
        sales_ledger_work t4