| | |
| | | select id, |
| | | inspection_item, |
| | | inspection_item_en, |
| | | inspection_item_classify, |
| | | inspection_item_subclass, |
| | | inspection_item_subclass_en, |
| | | laboratory, |
| | |
| | | man_hour, |
| | | man_hour_group, |
| | | inspection_item_type, |
| | | device_group, |
| | | checkout_number, |
| | | section, |
| | | value_type, |
| | | create_user, |
| | | update_user, |
| | | create_time, |
| | |
| | | import com.alibaba.fastjson.JSONArray; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.yuanchu.mom.common.GetLook; |
| | | import com.yuanchu.mom.mapper.StandardProductListMapper; |
| | | import com.yuanchu.mom.mapper.StandardTreeMapper; |
| | | import com.yuanchu.mom.pojo.InsSample; |
| | |
| | | import com.yuanchu.mom.service.StandardProductListService; |
| | | import lombok.AllArgsConstructor; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.List; |
| | |
| | | |
| | | private StandardTreeMapper standardTreeMapper; |
| | | |
| | | private StandardProductListService standardProductListService; |
| | | private GetLook getLook; |
| | | |
| | | @Override |
| | | public int upStandardProductList(StandardProductList list) { |
| | |
| | | } |
| | | |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public List<StandardProductList> selectStandardProductListByMethodId(Integer id, String tree) { |
| | | String[] trees = tree.split(" - "); |
| | | StringBuffer str = new StringBuffer(); |
| | |
| | | pl.setSample(sp.getSample()); |
| | | pl.setModel(sp.getModel()); |
| | | pl.setMethodS(sp.getMethodS()); |
| | | if(sp.getAsk()!=null&&!sp.getAsk().equals("")){ |
| | | pl.setAsk(sp.getAsk()); |
| | | } |
| | | if(sp.getTell()!=null&&!sp.getTell().equals("")){ |
| | | pl.setTell(sp.getTell()); |
| | | } |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | Integer userId = getLook.selectPowerByMethodAndUserId(null).get("userId"); |
| | | CompletableFuture.supplyAsync(() -> { |
| | | standardProductListMapper.delete(Wrappers.<StandardProductList>lambdaUpdate().eq(StandardProductList::getStandardMethodListId, id).eq(StandardProductList::getTree, tree)); |
| | | standardProductListService.saveBatch(list); |
| | | saveBatch(list.stream().map(a->{ |
| | | a.setFactory(trees[0]); |
| | | a.setLaboratory(trees[1]); |
| | | a.setSampleType(trees[2]); |
| | | try { |
| | | a.setSample(trees[3]); |
| | | }catch (Exception e){} |
| | | try { |
| | | a.setModel(trees[4]); |
| | | }catch (Exception e){} |
| | | a.setTree(tree); |
| | | a.setCreateUser(userId); |
| | | a.setUpdateUser(userId); |
| | | a.setStandardMethodListId(id); |
| | | return a; |
| | | }).collect(Collectors.toList())); |
| | | return null; |
| | | }).thenAccept(res -> { |
| | | }).exceptionally(e -> { |
| | |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.yuanchu.mom.common.GetLook; |
| | | import com.yuanchu.mom.dto.FactoryDto; |
| | | import com.yuanchu.mom.dto.SampleTypeDto; |
| | | import com.yuanchu.mom.mapper.StandardMethodListMapper; |
| | |
| | | private StandardProductListMapper standardProductListMapper; |
| | | |
| | | private StandardProductListService standardProductListService; |
| | | |
| | | private GetLook getLook; |
| | | |
| | | @Override |
| | | public List<FactoryDto> selectStandardTreeList() { |
| | |
| | | <select id="selectSampleAndProductByOrderId" resultType="com.yuanchu.mom.dto.SampleProductDto2"> |
| | | select * |
| | | from ( |
| | | select |
| | | i.id,isa.sample_code,isa.sample,isa.model,ip.state,ip.unit,ip.inspection_item,ip.inspection_item_subclass, |
| | | select i.id,isa.sample_code,isa.sample,isa.model,isa.ins_state,ip.state,ip.unit,ip.inspection_item,ip.inspection_item_subclass, |
| | | ip.son_laboratory,ip.inspection_item_type,ip.inspection_value_type,ip.ask,ip.`last_value`,ip.ins_result,ipr.equip_value |
| | | from ins_sample isa |
| | |
| | | type-aliases-package: com.yuanchu.mom.pojo |
| | | mapper-locations: classpath*:/mapper/*.xml |
| | | configuration: |
| | | log-impl: org.apache.ibatis.logging.stdout.StdOutImpl # 开启mybatis-plus日志 |
| | | log-impl: #org.apache.ibatis.logging.stdout.StdOutImpl # 开启mybatis-plus日志 |
| | | |
| | | |
| | | # 数据源配置 |