| | |
|---|
| | | 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.mes.uppattenusage.service.UpPattenUsageService; |
|---|
| | | import lombok.extern.slf4j.Slf4j; |
|---|
| | | import org.springframework.beans.factory.annotation.Autowired; |
|---|
| | | import org.springframework.stereotype.Service; |
|---|
| | | |
|---|
| | | import java.util.*; |
|---|
| | | import java.util.ArrayList; |
|---|
| | | import java.util.List; |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * <p> |
|---|
| | |
|---|
| | | List<OptimizeUpPattenUsage> upPattenUsageList = null; |
|---|
| | | if (engineeringId != null) { |
|---|
| | | upPattenUsageList = optimizeProjectMapper.selectJoinList(OptimizeUpPattenUsage.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.stock_id") |
|---|
| | | .select("t.project_no,t.glass_type,b.realwidth as width,b.realheight as height ,REGEXP_REPLACE(t.glass_thickness,'\\D','')as glass_thickness,b.stock_id") |
|---|
| | | .leftJoin("optimize_layout b on t.project_no=b.project_no") |
|---|
| | | .eq("b.project_no", engineeringId)); |
|---|
| | | } |
|---|
