#

LSH

2023-12-08 43ff5a9617f0d2648bf987335d3e27d36cda6f60

#

 src/main/java/com/zy/asrs/controller/OpenController.java

@@ -17,6 +17,7 @@
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * Created by vincent on 2022/4/8
@@ -81,6 +82,15 @@
        auth(appkey, null, request);
        return R.ok(openService.inventoryQuantity());
    }
    /*
     * 速腾数字孪生调用接口
     * */
    @PostMapping("/digital/ownerAll/number/quantity")
    public synchronized R ownerAllNumber(@RequestHeader(required = false) String appkey,
                                           HttpServletRequest request) {
        auth(appkey, null, request);
        return openService.ownerAllNumber();
    }


    /**

 src/main/java/com/zy/asrs/mapper/LocDetlMapper.java

@@ -102,4 +102,5 @@
    String selectLocNoF(String locNo);

    List<LocDetl> queryStock3(String matnr, String batch, int owner);
    List<LocDetlAll> selectOwnerAllAnfme();
}

 src/main/java/com/zy/asrs/service/LocDetlService.java

@@ -80,4 +80,6 @@
    int selectAllPymentcount(LocDetlDTO locDetlDTO);

    String selectLocNoF(String locNo);

    List<LocDetlAll> selectOwnerAllAnfme();
}

 src/main/java/com/zy/asrs/service/OpenService.java

@@ -47,4 +47,5 @@

    R getInOutDetl();
    DigitalTwin inventoryQuantity();
    R ownerAllNumber();
}

 src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java

@@ -201,4 +201,9 @@
    public String selectLocNoF(String locNo) {
        return this.baseMapper.selectLocNoF(locNo);
    }

    @Override
    public List<LocDetlAll> selectOwnerAllAnfme() {
        return this.baseMapper.selectOwnerAllAnfme();
    }
}

 src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java

@@ -1,6 +1,7 @@
package com.zy.asrs.service.impl;

import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.core.common.Cools;
import com.core.common.DateUtils;
import com.core.common.R;
@@ -9,6 +10,7 @@
import com.zy.asrs.entity.*;
import com.zy.asrs.entity.param.*;
import com.zy.asrs.entity.result.InOutCountDto;
import com.zy.asrs.entity.result.LocDetlAll;
import com.zy.asrs.entity.result.StockVo;
import com.zy.asrs.mapper.ReportQueryMapper;
import com.zy.asrs.mapper.TagMapper;
@@ -540,4 +542,13 @@
        return digitalTwin;
    }

    /*
     * 速腾数字孪生调用接口
     * */
    @Override
    public synchronized R ownerAllNumber() {
        List<LocDetlAll> locDetlAlls = locDetlService.selectOwnerAllAnfme();
        return R.ok(locDetlAlls);
    }

}

 src/main/resources/mapper/LocDetlMapper.xml

@@ -722,5 +722,9 @@
        desc
    </select>

    <select id="selectOwnerAllAnfme" resultType="com.zy.asrs.entity.result.LocDetlAll">
        select SUM(anfme) as anfme,owner from asr_loc_detl_all GROUP BY owner ORDER BY anfme DESC
    </select>


</mapper>