义乌项目
blame | 历史 | 补丁 | 提交 | 提交对比 | show whitespace
wuyouming666
2024-04-24 ee04d1ab881479ae30c8d5600d29ac56b70f751e 
 hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downworkstation/service/impl/DownWorkstationServiceImpl.java


@@ -3,23 +3,29 @@


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


import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;


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


import com.github.yulichang.query.MPJQueryWrapper;


import com.mes.downglassinfo.entity.DownGlassInfo;


import com.mes.downglassinfo.entity.DownGlassTask;


import com.mes.downglassinfo.mapper.DownGlassInfoMapper;


import com.mes.downglassinfo.service.DownGlassInfoService;


import com.mes.downglassinfo.service.DownGlassTaskService;


import com.mes.downworkstation.entity.DownWorkstation;


import com.mes.downworkstation.entity.DownWorkstationTask;


import com.mes.downworkstation.entity.DownWorkstionAndDownGlassinfo;


import com.mes.downworkstation.mapper.DownWorkstationMapper;


import com.mes.downworkstation.mapper.DownWorkstationTaskMapper;


import com.mes.downworkstation.service.DownWorkstationService;


import com.mes.downworkstation.service.DownWorkstationTaskService;


import lombok.extern.slf4j.Slf4j;


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


import org.springframework.stereotype.Service;


import org.springframework.transaction.annotation.Transactional;




import java.util.ArrayList;


import java.util.HashMap;


import java.util.List;


import java.util.Map;




@Slf4j


@Service


public class DownWorkstationServiceImpl extends ServiceImpl<DownWorkstationMapper, DownWorkstation> implements DownWorkstationService {




@@ -29,6 +35,8 @@


    private DownWorkstationTaskMapper downWorkstationTaskMapper;


    @Autowired


    private DownGlassInfoService downGlassInfoService;


    @Autowired


    private DownGlassInfoMapper downGlassInfoMapper;


    @Autowired


    private DownGlassTaskService downGlassTaskService;




@@ -50,6 +58,37 @@


        DownWorkstation result = baseMapper.selectOne(queryWrapper);


        return result != null ? result.getTotalquantity() : 0;


    }


//工位显示


    @Override


    public List<Map<String, Object>> getTotalGlassDimensionsByWorkstation() {


        MPJQueryWrapper<DownWorkstionAndDownGlassinfo> queryWrapper = new MPJQueryWrapper<>();


        queryWrapper.select("t.workstation_id", "t.flow_card_id", "COALESCE(SUM(b.width), 0) AS totalwidth", "COALESCE(SUM(b.height), 0) AS totalheight")


                .leftJoin("down_glass_info b on t.flow_card_id = b.flow_card_id")


                .groupBy("t.workstation_id", "t.flow_card_id");




        List<DownWorkstionAndDownGlassinfo> workstationList = downWorkstationMapper.selectJoinList(DownWorkstionAndDownGlassinfo.class, queryWrapper);




        List<Map<String, Object>> result = new ArrayList<>();


        for (DownWorkstionAndDownGlassinfo downWorkstionAndDownGlassinfo : workstationList) {


            Map<String, Object> rack = new HashMap<>();




            // 创建子项（item）对象


            Map<String, Object> item = new HashMap<>();


            item.put("height",  downWorkstionAndDownGlassinfo.getTotalheight()); // 设置子项高度，根据实际情况设置


            item.put("width",  downWorkstionAndDownGlassinfo.getTotalwidth()); // 设置子项宽度，根据实际情况设置


            item.put("fillColor", "yellow"); // 设置子项颜色


            item.put("content", downWorkstionAndDownGlassinfo.getFlowCardId()); // 使用流程卡号作为子项内容




            rack.put("item", item); // 将子项对象放入货架对象中




            result.add(rack); // 将货架对象添加到结果列表中


            //log.info("货架对象: {}", rack);


        }




        return result; // 返回最终结果


    }








//    @Override


//    public int getTotalQuantity(int workstationId) {