Merge remote-tracking branch 'origin/master'
# Conflicts:
# inspect-server/src/main/java/com/yuanchu/mom/service/RawInspectService.java
| | |
| | | </if> |
| | | <if test="message!=null and message!=''"> |
| | | and code like concat('%',#{message},'%') |
| | | or name like concat('%',#{message},'%') |
| | | or device.name like concat('%',#{message},'%') |
| | | </if> |
| | | </select> |
| | | <!--根据设备分组查询设备--> |
| | |
| | | <result property="name" column="father"/> |
| | | </resultMap> |
| | | <select id="selectAllTechTem" resultMap="selectAllTechTemMap"> |
| | | select e.name elname, |
| | | select e.name elname, |
| | | father |
| | | from mom_ocean.technology_template t, |
| | | mom_ocean.element e, |
| | |
| | | where e.id = et.element_id |
| | | and t.id = tech_tem_id |
| | | and t.state = 1 |
| | | and et.state=1 |
| | | and type=#{type} |
| | | <if test="message!=null and message!=''"> |
| | | and father like concat('%',#{message},'%') |
| | |
| | | rawInsProductService.updaterawInsProduct(userId,rpId,testValue,devId); |
| | | return Result.success(); |
| | | } |
| | | |
| | | @ApiOperation(value = "更改设备") |
| | | @ApiImplicitParams(value = { |
| | | @ApiImplicitParam(name = "rpId", value = "原材料检验项目id", dataTypeClass = Integer.class, required = true), |
| | | @ApiImplicitParam(name = "DevId", value = "设备id", dataTypeClass = Integer.class,required = true) |
| | | }) |
| | | @PostMapping("/updateDevByRpId") |
| | | public Result updateDevByRpId(Integer rpId ,Integer devId) { |
| | | rawInsProductService.updateDevByRpId(rpId,devId); |
| | | return Result.success(); |
| | | } |
| | | } |
| | | |
| | |
| | | void updaterawInsProduct(int userId, Integer rpId ,String testValue,Integer devId); |
| | | |
| | | |
| | | /** |
| | | * 只更改设备,之前的检验值删掉 |
| | | * @param rpId |
| | | * @param devId |
| | | */ |
| | | void updateDevByRpId(Integer rpId, Integer devId); |
| | | } |
| | | |
| | |
| | | * @param id |
| | | * @return |
| | | */ |
| | | Map<String, Object> selectRawInspectsListById(Integer id); |
| | | Map<String,Object> selectRawInspectsListById(Integer id); |
| | | |
| | | /** |
| | | * 更新检验状态 |
| | |
| | | import com.yuanchu.mom.pojo.RawInspect; |
| | | import com.yuanchu.mom.service.RawInsProductService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import javax.annotation.Resource; |
| | | import java.util.Arrays; |
| | | import java.util.Date; |
| | |
| | | |
| | | //更新检验项目(填写检验值,检验设备) |
| | | @Override |
| | | public void updaterawInsProduct(int userId,Integer rpId ,String testValue,Integer devId) { |
| | | public void updaterawInsProduct(int userId, Integer rpId, String testValue, Integer devId) { |
| | | RawInsProduct rawInsProduct = rawInsProductMapper.selectById(rpId); |
| | | //赋值设备 |
| | | rawInsProduct.setDeviceId(devId); |
| | |
| | | if (list.contains(0)) { |
| | | //如果其中一个检验值不合格则该项目检验不合格 |
| | | rawInsProduct.setTestState(0); |
| | | }else { |
| | | } else { |
| | | rawInsProduct.setTestState(1); |
| | | } |
| | | /*更新原材料检验项目表*/ |
| | |
| | | rawInspectMapper.updateById(rawInspect); |
| | | } |
| | | |
| | | //只更改设备,之前的检验值删掉 |
| | | @Override |
| | | public void updateDevByRpId(Integer rpId, Integer devId) { |
| | | RawInsProduct rawInsProduct = new RawInsProduct(); |
| | | rawInsProduct.setId(rpId); |
| | | rawInsProduct.setDeviceId(devId); |
| | | rawInsProduct.setTestValue(null); |
| | | rawInsProduct.setTestState(null); |
| | | rawInsProductMapper.updateById(rawInsProduct); |
| | | } |
| | | |
| | | /*判断检测值是否满足标准值和内控值的要求,如果不满足则检验结论为不合格*/ |
| | | private int checkValues(String standardValueStr, String controlValueStr, String detectionValueStr) { |
| | | boolean isStandardValueSatisfied = isValueSatisfied(standardValueStr, detectionValueStr); |
| | |
| | | <resultMap id="oneMap" type="map"> |
| | | <id property="rcode" column="rcode"/> |
| | | <result property="formTime" column="formTime"/> |
| | | <result property="creatTime" column="creatTime"/> |
| | | <result property="rname" column="rname"/> |
| | | <result property="specifications" column="specifications"/> |
| | | <result property="runit" column="runit"/> |
| | |
| | | </resultMap> |
| | | |
| | | <select id="selectRawInspectsListById" resultMap="oneMap"> |
| | | select DATE_FORMAT(form_time, '%Y-%m-%d') formTime, |
| | | r.code rcode, |
| | | r.name rname, |
| | | select DATE_FORMAT(form_time, '%Y-%m-%d') formTime, |
| | | r.code rcode, |
| | | r.name rname, |
| | | specifications, |
| | | r.unit runit, |
| | | r.unit runit, |
| | | number, |
| | | DATE_FORMAT(r.create_time, '%Y-%m-%d') creatTime, |
| | | supplier, |
| | | judge_state, |
| | | user_name, |
| | | rp.id rpId, |
| | | rp.name rpName, |
| | | rp.unit rpUnit, |
| | | rp.id rpId, |
| | | rp.name rpName, |
| | | rp.unit rpUnit, |
| | | required, |
| | | internal, |
| | | test_value, |
| | | test_state, |
| | | device.name devName, |
| | | user.name uName |
| | | device.name devName, |
| | | user.name uName |
| | | from mom_ocean.raw_ins_product rp |
| | | left join mom_ocean.raw_inspect r on rp.raw_inspect_id = r.id |
| | | left join mom_ocean.device |
| | |
| | | @PostMapping("/compile") |
| | | public Result compile(Integer id) { |
| | | ordersService.compile(id); |
| | | return Result.success("编制产品"+id+"完成!"); |
| | | return Result.success("编制产品完成!"); |
| | | } |
| | | |
| | | } |
| | |
| | | |
| | | <!--右侧数据展示 工艺路线--> |
| | | <resultMap id="selectAllTecMap" type="map"> |
| | | <id property="name" column="father"/> |
| | | <id property="father" column="father"/> |
| | | <collection property="children" resultMap="selectAllTecMaps" javaType="List"/> |
| | | </resultMap> |
| | | <resultMap id="selectAllTecMaps" type="map"> |