| | |
| | | int increaseWorkQty(@Param("orderId")Long orderId, @Param("matnr")String matnr, @Param("batch")String batch, @Param("brand")String brand, @Param("standby1")String standby1, @Param("standby2")String standby2, @Param("standby3")String standby3, @Param("workQty")Double workQty); |
| | | |
| | | List<OrderDetl> selectByOrderNo(@Param("orderNo") String orderNo); |
| | | boolean morpt(@Param("orderNo")String orderNo,@Param("matnr")String matnr); |
| | | |
| | | } |
| | |
| | | * @return |
| | | */ |
| | | boolean increaseWorkQty(Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double workQty); |
| | | boolean morpt(String orderNo,String orderNo1); |
| | | |
| | | List<OrderDetl> selectByOrderNo(String orderNo); |
| | | } |
| | |
| | | import com.baomidou.mybatisplus.service.impl.ServiceImpl; |
| | | import com.core.common.Cools; |
| | | import com.core.exception.CoolException; |
| | | import com.zy.asrs.entity.OrderDetl; |
| | | import com.zy.asrs.entity.OrderDetlPakin; |
| | | import com.zy.asrs.entity.param.OrderDetlByCode; |
| | | import com.zy.asrs.mapper.OrderDetlPakinMapper; |
| | | import com.zy.asrs.service.OrderDetlPakinService; |
| | | import com.zy.asrs.service.OrderDetlService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | |
| | | public class OrderDetlPakinServiceImpl extends ServiceImpl<OrderDetlPakinMapper, OrderDetlPakin> implements OrderDetlPakinService { |
| | | @Autowired |
| | | private OrderDetlPakinService orderDetlPakinService; |
| | | @Autowired |
| | | private OrderDetlService orderDetlService; |
| | | @Override |
| | | public List<OrderDetlPakin> selectByOrderId(Long orderId) { |
| | | return this.selectList(new EntityWrapper<OrderDetlPakin>().eq("order_id", orderId)); |
| | |
| | | |
| | | @Override |
| | | public boolean morpt(String orderNo,String orderNo1){ |
| | | List<OrderDetlPakin> list1 = orderDetlPakinService.selectList(new EntityWrapper<OrderDetlPakin>().eq("order_no",orderNo1)); |
| | | List<OrderDetl> list1 = orderDetlService.selectList(new EntityWrapper<OrderDetl>().eq("order_no",orderNo1)); |
| | | try{ |
| | | for (OrderDetlPakin item : list1) { |
| | | for (OrderDetl item : list1) { |
| | | Double anfme = item.getAnfme(); |
| | | Double qty = item.getQty(); |
| | | String matnr = item.getMatnr(); |
| | |
| | | import com.baomidou.mybatisplus.mapper.EntityWrapper; |
| | | import com.baomidou.mybatisplus.plugins.Page; |
| | | import com.core.common.Cools; |
| | | import com.core.exception.CoolException; |
| | | import com.zy.asrs.entity.OrderDetlPakin; |
| | | import com.zy.asrs.mapper.OrderDetlMapper; |
| | | import com.zy.asrs.entity.OrderDetl; |
| | | import com.zy.asrs.service.OrderDetlPakinService; |
| | | import com.zy.asrs.service.OrderDetlService; |
| | | import com.baomidou.mybatisplus.service.impl.ServiceImpl; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.List; |
| | | |
| | | @Service("orderDetlService") |
| | | public class OrderDetlServiceImpl extends ServiceImpl<OrderDetlMapper, OrderDetl> implements OrderDetlService { |
| | | |
| | | @Autowired |
| | | private OrderDetlService orderDetlService; |
| | | @Override |
| | | public List<OrderDetl> selectByOrderId(Long orderId) { |
| | | return this.selectList(new EntityWrapper<OrderDetl>().eq("order_id", orderId)); |
| | |
| | | public List<OrderDetl> selectByOrderNo(String orderNo) { |
| | | return this.baseMapper.selectByOrderNo(orderNo); |
| | | } |
| | | @Override |
| | | public boolean morpt(String orderNo,String orderNo1){ |
| | | List<OrderDetl> list1 = orderDetlService.selectList(new EntityWrapper<OrderDetl>().eq("order_no",orderNo1)); |
| | | try{ |
| | | for (OrderDetl item : list1) { |
| | | Double anfme = item.getAnfme(); |
| | | Double qty = item.getQty(); |
| | | String matnr = item.getMatnr(); |
| | | if(anfme.equals(qty)){ |
| | | OrderDetl orderDetl = orderDetlService.selectOne( |
| | | new EntityWrapper<OrderDetl>().eq("matnr", matnr).eq("order_no", orderNo) |
| | | ); |
| | | this.baseMapper.morpt(orderNo,matnr); |
| | | } |
| | | } |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | throw new CoolException("汇报单转换失败:" + e.getMessage()); |
| | | } |
| | | return true; |
| | | } |
| | | } |
| | |
| | | String detlId = entry.getString("id"); //明细id |
| | | Long seq = entry.getLong("seq"); //分录行号 |
| | | String manubill = entry.getString("manufacturenun"); |
| | | String manubillid = entry.getString("orderid_id"); |
| | | String manubillid = entry.getString("orderfid_id"); |
| | | String manuentryid = null; |
| | | String manuentry = null; |
| | | if(kingDeeUtilType.formId.equals("PRD_MORPT")){ |
| | |
| | | JSONObject billentryLk = new JSONObject() |
| | | .fluentPut("id", 0L) |
| | | .fluentPut("seq", orderDetl.getLineNumber()) |
| | | .fluentPut("billentry_lk_stableid", 1014628189722381313L) |
| | | .fluentPut("billentry_lk_stableid", 1828884569948973056L) |
| | | .fluentPut("billentry_lk_sbillid", Long.parseLong(order.getItemName())) // 主单ID |
| | | .fluentPut("billentry_lk_sid", Long.parseLong(orderDetl.getThreeCode())); // 明细ID |
| | | // .fluentPut("billentry_lk_baseqty_old", orderDetl.getErpAnfme()) // ERP数量 |
| | |
| | | .fluentPut("owner_number", "BU-00001") |
| | | .fluentPut("manuentry", orderDetl.getSpecs()) |
| | | .fluentPut("manubill", orderDetl.getColor()) |
| | | .fluentPut("manubillid", orderDetl.getModel()) |
| | | .fluentPut("manubillid", Long.parseLong(orderDetl.getModel())) |
| | | .fluentPut("manuentryid", orderDetl.getBrand()) |
| | | .fluentPut("producttype", "C") |
| | | .fluentPut("eap7_textfield", orderDetl.getBoxType3()) |
| | |
| | | .fluentPut("outkeeper_number", "BU-00001") |
| | | .fluentPut("shipper_number", "BU-00001") |
| | | .fluentPut("entrysettleorg_number", "BU-00001") |
| | | .fluentPut("material_number", orderDetl.getMatnr()) |
| | | .fluentPut("material_masterid_number", orderDetl.getMatnr()) |
| | | |
| | | .fluentPut("billentry_lk", billentryLkArray2); |
| | | |
| | |
| | | .fluentPut("data", new JSONArray(Arrays.asList( |
| | | new JSONObject() |
| | | .fluentPut("billno", UUID.randomUUID().toString().replace("-", "").substring(0, 16)) |
| | | .fluentPut("billstatus", "C") |
| | | .fluentPut("billstatus", "A") |
| | | .fluentPut("id", 0L) |
| | | .fluentPut("biztime", sdf1.format(now2)) |
| | | .fluentPut("org_number", "BU-00001") |
| | |
| | | .fluentPut("invscheme_number", "601") |
| | | .fluentPut("purorg_number", "BU-00001") |
| | | .fluentPut("productionorg_number", "BU-00001") |
| | | .fluentPut("supplier_number", "272") |
| | | |
| | | .fluentPut("billentry", billentryArray2) // 将 billentry 数组添加到请求参数 |
| | | ))); |
| | | case "STK_imSaloutbill": |
| | |
| | | from man_order_detl |
| | | where order_no = #{orderNo} |
| | | </select> |
| | | <update id="morpt" parameterType="String"> |
| | | UPDATE man_order_detl |
| | | SET qty = anfme, work_qty = anfme |
| | | WHERE order_no = #{orderNo} and matnr = #{matnr} |
| | | </update> |
| | | |
| | | </mapper> |