义乌项目
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
严智鑫
2024-04-19 4e632eef221f01e7d27745cc20e4fb205dd34509 
 hangzhoumesParent/common/servicebase/src/main/java/com/mes/uppattenusage/service/impl/UpPattenUsageServiceImpl.java


@@ -1,15 +1,22 @@


package com.mes.uppattenusage.service.impl;




import com.baomidou.dynamic.datasource.annotation.DS;


import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;


import com.github.yulichang.base.MPJBaseServiceImpl;


import com.github.yulichang.query.MPJQueryWrapper;


import com.mes.pp.entity.OptimizeProject;


import com.mes.pp.mapper.OptimizeProjectMapper;


import com.mes.uppattenusage.entity.OptimizeUpPattenUsage;


import com.mes.uppattenusage.entity.UpPattenUsage;


import com.mes.uppattenusage.service.UpPattenUsageService;


import com.mes.uppattenusage.mapper.UpPattenUsageMapper;


import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;


import lombok.extern.slf4j.Slf4j;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.stereotype.Service;




import java.util.Collections;


import java.util.List;


import java.util.Map;




/**


 * <p>


@@ -21,7 +28,10 @@


 */


@Service


@Slf4j


public class UpPattenUsageServiceImpl extends ServiceImpl<UpPattenUsageMapper, UpPattenUsage> implements UpPattenUsageService {


public class UpPattenUsageServiceImpl extends MPJBaseServiceImpl<UpPattenUsageMapper, UpPattenUsage> implements UpPattenUsageService {




    @Autowired


    OptimizeProjectMapper optimizeProjectMapper;


    @Override


    public List<UpPattenUsage> prioritylist(int state) {


        log.info("将参数传入到查询类里,工程号做非空判断模糊查询");


@@ -32,12 +42,15 @@


    }




    @Override


    public List<UpPattenUsage> saveUpPattenUsage(String engineeringId) {


        List<UpPattenUsage> list = this.list();


    @DS("pp")


    public List<Map> saveUpPattenUsage(String engineeringId) {




        if (engineeringId != null) {


            LambdaQueryWrapper<UpPattenUsage> wrapper = new LambdaQueryWrapper<>();


            wrapper.eq(UpPattenUsage::getEngineeringId,engineeringId);


            return this.list(wrapper);




            List<Map> upPattenUsageList=optimizeProjectMapper.selectJoinList(Map.class,new MPJQueryWrapper<OptimizeProject>()


                    .select("t.project_no,t.glass_type,b.width,b.height,REGEXP_REPLACE(t.glass_thickness,'\\D','')as glass_thickness,b.heat_layout_sort")


                    .leftJoin("optimize_layout b on t.project_no=b.project_no")


                    .eq("b.project_no",engineeringId));


        }


        return Collections.emptyList();


    }