添加查询

admin

2024-01-11 4a2c6796c89f6889bbdd3e9630fee40a93c6473e

添加查询

 guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrderBatchInfo/mapper/mapping/ProductionOrderBatchInfoMapper.xml

@@ -33,6 +33,12 @@
        select
        <include refid="Base_Column_List"/>
        from om_production_order_batch_info where 1 = 1
        <if test="paramCondition.workOrderNo != null and paramCondition.workOrderNo != ''">
            and work_order_no like CONCAT('%',#{paramCondition.workOrderNo},'%')
        </if>
        <if test="paramCondition.locationCode != null and paramCondition.locationCode != ''">
            and location_code = #{paramCondition.locationCode}
        </if>
    </select>

    <select id="customMapList" resultType="map" parameterType="cn.stylefeng.guns.modular.om.productionOrderBatchInfo.model.params.ProductionOrderBatchInfoParam">

 guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrderBatchInfo/service/impl/ProductionOrderBatchInfoServiceImpl.java

@@ -63,7 +63,7 @@

    @Override
    public List<ProductionOrderBatchInfoResult> findListBySpec(ProductionOrderBatchInfoParam param){
        return null;
        return this.baseMapper.customList(param);
    }

    @Override

 guns-vip-main/src/main/webapp/assets/modular/om/productionOrderBatchInfo/productionOrderBatchInfo.js

@@ -26,7 +26,7 @@
            {field: 'materialCode', sort: true, title: '物料编码'},
            {field: 'loadingCode', sort: true, title: '物料批次'},
            {field: 'spareField1', sort: true, title: '上料数量'},
            {field: 'spareField3', sort: true, title: '剩余数量'},
            {field: 'productionLine', sort: true, title: '剩余数量'},
            {field: 'spareField2', sort: true, title: '单位'},

            {field: 'state', sort: true, title: '是否上料', width: 105,templet: '#stateTpl'},