| | |
| | | } |
| | | //妿æ£éªåæ ¼,éè¦æ°å¢æå(0)åºå |
| | | if (result == 1) { |
| | | /*æ°å¢æå(0)åºå*/ |
| | | //妿å
¥åºçä¿¡æ¯ä¸æ ·åªæåºåä¸ä¸æ ·,åå¨åæ¥çåºåæ°éä¸å ä¸ç¸åºçæ°é |
| | | LambdaQueryWrapper<Repertory> queryWrapper = new LambdaQueryWrapper<>(); |
| | | queryWrapper.eq(Repertory::getOrderCode, finishedInspect.getOrderNumber()) |
| | |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" > |
| | | <mapper namespace="com.yuanchu.mom.mapper.InspectUnacceptedMapper"> |
| | | <select id="selectUnRawInspectsList" resultType="java.util.Map"> |
| | | select ru.id |
| | | select ru.id, |
| | | DATE_FORMAT(form_time, '%Y-%m-%d') 'æ¥ææ¥æ', |
| | | reason, |
| | | code, |
| | |
| | | order by ru.id desc |
| | | </select> |
| | | <select id="selectInsList" resultType="java.util.Map"> |
| | | select ru.id |
| | | select ru.id, |
| | | DATE_FORMAT(fi.create_time, '%Y-%m-%d') 'æ¥ææ¥æ', |
| | | reason, |
| | | material_code, |
| | |
| | | |
| | | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.yuanchu.mom.pojo.Sale; |
| | | import com.yuanchu.mom.pojo.dto.ConsignmentDto; |
| | | import com.yuanchu.mom.service.SaleService; |
| | | import com.yuanchu.mom.utils.JackSonUtil; |
| | |
| | | import com.yuanchu.mom.service.ConsignmentService; |
| | | |
| | | import javax.annotation.Resource; |
| | | import java.sql.Wrapper; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | |
| | | }) |
| | | @GetMapping("/selSale") |
| | | public Result selSale(String orderNumber) { |
| | | //åªæéå®åå®¡æ ¸éè¿ä¹åæè½åè´§ |
| | | Sale sale = saleService.getOne(Wrappers.<Sale>query().eq("order_number", orderNumber)); |
| | | if (ObjectUtils.isEmpty(sale.getType()) || sale.getType() != 1 ) { |
| | | return Result.fail("åªæéå®åå®¡æ ¸éè¿ä¹åæè½åè´§!"); |
| | | } |
| | | return Result.success(saleService.selSale(orderNumber)); |
| | | } |
| | | |
| | |
| | | map.put("row", consignmentPage.getRecords()); |
| | | return Result.success(map); |
| | | } |
| | | |
| | | @ApiOperation(value = "æ ¹æ®åè´§idå é¤") |
| | | @ApiImplicitParams(value = { |
| | | @ApiImplicitParam(name = "id", value = "åè´§id", dataTypeClass = Integer.class, required = true) |
| | |
| | | @ApiImplicitParam(name = "countSize", value = "æ¡æ°/页", dataTypeClass = Integer.class, required = true), |
| | | @ApiImplicitParam(name = "orderCode", value = "订åç¼å·", dataTypeClass = String.class), |
| | | @ApiImplicitParam(name = "name", value = "产ååç§°", dataTypeClass = String.class), |
| | | @ApiImplicitParam(name = "state", value = "ç¼å¶ç¶æ(为空=å
¨é¨)", dataTypeClass = Integer.class), |
| | | @ApiImplicitParam(name = "state", value = "ç¼å¶ç¶æ(为空=å¾
ç¼å¶0+å·²ç¼å¶1)", dataTypeClass = Integer.class), |
| | | @ApiImplicitParam(name = "time", value = "ä¸åæ¶é´", dataTypeClass = String.class) |
| | | }) |
| | | @GetMapping("/selectAllOrder") |
| | |
| | | return Result.success(map); |
| | | } |
| | | |
| | | @ApiOperation(value = "æ°å¢éå®å-->æ·»å 产å-->æ¥è¯¢æååºå") |
| | | @ApiOperation(value = "æ°å¢éå®å-->æ·»å 产å-->æ¥è¯¢æååºåå·²æ£éªç产å") |
| | | @PostMapping("/seleRepe") |
| | | public Result seleRepe() { |
| | | return Result.success(repertoryService.getSale()); |
| | |
| | | @ApiModelProperty(value = "ç¶æ 0:ä¸éè¿;1:éè¿") |
| | | private Integer type; |
| | | |
| | | @ApiModelProperty(value = "ç¼å¶ç¶æ0:å¾
ç¼å¶;1å·²ç¼å¶ éè¿å°±æ¯å·²ç¼å¶,没æç¶æå°±æ¯å¾
ç¼å¶") |
| | | @ApiModelProperty(value = "ç¼å¶ç¶æ0:å¾
ç¼å¶;1å·²ç¼å¶;2:æ ç¼å¶ éè¿å°±æ¯å·²ç¼å¶,ä¸éè¿å°±æ¯æ ç¼å¶") |
| | | private Integer bianzhiState; |
| | | |
| | | |
| | |
| | | @JsonSerialize |
| | | private String orderCode; |
| | | |
| | | //ååç¼å· |
| | | //ååç¼å·(客æ·è®¢åå·) |
| | | @JsonSerialize |
| | | private String customerCode; |
| | | |
| | |
| | | import lombok.Data; |
| | | |
| | | @Data |
| | | //æ°å¢æåå
¥åº |
| | | public class ImportRepertoryDto { |
| | | /** |
| | | * 订åç¼ç |
| | |
| | | import com.yuanchu.mom.pojo.SaleMaterial; |
| | | import lombok.Data; |
| | | |
| | | import javax.validation.constraints.NotBlank; |
| | | import java.time.LocalDate; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | |
| | | public class SaleDto { |
| | | |
| | | //订åç¼å· |
| | | @NotBlank(message = "订åç¼å·ä¸è½ä¸ºç©º") |
| | | @JsonSerialize |
| | | private String orderNumber; |
| | | |
| | | //å·¥ç¨åç§° |
| | | @NotBlank(message = "å·¥ç¨åç§°ä¸è½ä¸ºç©º") |
| | | @JsonSerialize |
| | | private String name; |
| | | |
| | | //ååç¼å· |
| | | @NotBlank(message = "ååç¼å·ä¸è½ä¸ºç©º") |
| | | @JsonSerialize |
| | | private String code; |
| | | |
| | | //客æ·åç§° |
| | | @NotBlank(message = "客æ·åç§°ä¸è½ä¸ºç©º") |
| | | @JsonSerialize |
| | | private String proname; |
| | | |
| | | //æ¶è´§å°å |
| | | @NotBlank(message = "æ¶è´§å°åä¸è½ä¸ºç©º") |
| | | @JsonSerialize |
| | | private String adress; |
| | | |
| | | //è系人 |
| | | @NotBlank(message = "è系人ä¸è½ä¸ºç©º") |
| | | @JsonSerialize |
| | | private String username; |
| | | |
| | | //èç³»çµè¯ |
| | | @NotBlank(message = "èç³»çµè¯ä¸è½ä¸ºç©º") |
| | | @JsonSerialize |
| | | private String phone; |
| | | |
| | | //ä¸å人 |
| | | @JsonSerialize |
| | | @NotBlank(message = "ä¸å人ä¸è½ä¸ºç©º") |
| | | private String orderName; |
| | | |
| | | //äº¤è´§æ¥æ |
| | | @NotBlank(message = "äº¤è´§æ¥æä¸è½ä¸ºç©º") |
| | | @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8") |
| | | private Date delTime; |
| | | |
| | | //产åä¿¡æ¯ |
| | | @NotBlank(message = "产åä¿¡æ¯ä¸è½ä¸ºç©º") |
| | | @JsonSerialize |
| | | private List<SaleMaterialDto> saleMaterialList; |
| | | } |
| | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.stream.Collectors; |
| | | |
| | | /** |
| | | * æåå货表(Consignment)表æå¡å®ç°ç±» |
| | |
| | | public String addCon(String name, ConsignmentDto consignmentDto) { |
| | | //çæä¸ä¸ªæ¼è¿åç¼å· |
| | | String escortCode = MyUtil.getTimeSixNumberCode("YY"); |
| | | //å¦æè¯¥è®¢åå·²ç»åè¿è´§äºä¸è½ååè´§ |
| | | List<Consignment> consignments = consignmentMapper.selectAll(); |
| | | //å¦ææ²¡æåè´§è¡¨ä¸æ²¡ææ°æ®ä¹å¯ä»¥åè´§ |
| | | //妿åè´§è¡¨ä¸æ²¡ææ°æ®ä¹å¯ä»¥åè´§ |
| | | if (consignments.size()==0) { |
| | | /*æ°å¢æååè´§*/ |
| | | String mes1 = addConsign(name, consignmentDto, escortCode); |
| | | return mes1; |
| | | } else { |
| | | for (Consignment consignment : consignments) { |
| | | if (consignment.getCustomerCode().equals(consignmentDto.getCustomerCode())) { |
| | | return addConsign(name, consignmentDto, escortCode); |
| | | } |
| | | //è·åå货表ä¸çååç¼å·éå |
| | | List<String> customerCodeList = consignments.stream().map(consignment -> { |
| | | String customerCode = consignment.getCustomerCode(); |
| | | return customerCode; |
| | | }).distinct().collect(Collectors.toList()); |
| | | if (customerCodeList.contains(consignmentDto.getCustomerCode())) { |
| | | return "该åå订åå·²åè¿è´§,æ æ³å次åè´§!"; |
| | | } else { |
| | | } |
| | | /*æ°å¢æååè´§*/ |
| | | String mes2 = addConsign(name, consignmentDto, escortCode); |
| | | return mes2; |
| | | } |
| | | } |
| | | } |
| | | return null; |
| | | return addConsign(name, consignmentDto, escortCode); |
| | | } |
| | | |
| | | //æ¥è¯¢åè´§è®°å½å表 |
| | |
| | | .eq(Repertory::getType, 0); |
| | | Repertory repertory = repertoryMapper.selectOne(queryWrapper); |
| | | //该æåçæ£éªç¶ææ¯å·²æ£éª1æè½è¿è¡åè´§ |
| | | if (repertory.getCheckState() == 1) { |
| | | if (repertory.getCheckState() != 1) { |
| | | return "该产åè¿æªæ£éª,ä¸è½åè´§!"; |
| | | } |
| | | //该æååºåçæ°é大äºçäºåè´§çæ°éæè½è¿è¡åè´§ |
| | | if (repertory.getNumber() >= message.getNumber()) { |
| | | if (repertory.getNumber() < message.getNumber()) { |
| | | return "åºåä¸è¶³,æ æ³åè´§!"; |
| | | } |
| | | //æé æååè´§å®ä½ç±» |
| | | Consignment consig = Consignment.builder() |
| | | .customerCode(consignmentDto.getCustomerCode()) |
| | |
| | | /*åå°å¯¹åºçåºå*/ |
| | | repertory.setNumber(repertory.getNumber() - consig.getNumber()); |
| | | repertoryMapper.updateById(repertory); |
| | | } else return "åºåä¸è¶³,æ æ³åè´§!"; |
| | | } else return "该产åè¿æªæ£éª,ä¸è½åè´§!"; |
| | | } |
| | | /*åè´§æåä¹åéè¦æ°å¢ä¸å¼ åå*/ |
| | | Receipt receipt = new Receipt(); |
| | |
| | | BeanUtils.copyProperties(importRepertoryDto, importRepertory); |
| | | importRepertory.setUserName(name); |
| | | importRepertoryMapper.insert(importRepertory); |
| | | //æ°å¢æååºå |
| | | /*æ°å¢æååºå(æªæ£éª)*/ |
| | | //妿å
¥åºçä¿¡æ¯ä¸æ ·åªæåºåä¸ä¸æ ·,åå¨åæ¥çåºåæ°éä¸å ä¸ç¸åºçæ°é |
| | | LambdaQueryWrapper<Repertory> queryWrapper = new LambdaQueryWrapper<>(); |
| | | queryWrapper.eq(Repertory::getOrderCode, importRepertoryDto.getOrderCode()) |
| | |
| | | sale.setBianzhiState(1); |
| | | }else { |
| | | //å¦æå®¡æ ¸ä¸éè¿ |
| | | sale.setBianzhiState(null); |
| | | sale.setBianzhiState(2);//æ ç¼å¶ |
| | | } |
| | | saleMapper.updateById(sale); |
| | | } |
| | |
| | | //æ ¹æ®è®¢åå·æ¥è¯¢éå®ä¿¡æ¯ |
| | | @Override |
| | | public ConsignmentDto1 selSale(String orderNumber) { |
| | | Sale sale = saleMapper.selectOne(Wrappers.<Sale>query().eq("order_number", orderNumber)); |
| | | List<SaleMaterial> saleMaterials = saleMaterialMapper.selectList(Wrappers.<SaleMaterial>query().eq("sale_id", sale.getId())); |
| | | Sale sale = saleMapper.selectOne(Wrappers.<Sale>query() |
| | | .eq("order_number", orderNumber) |
| | | .eq("type", 1) |
| | | .eq("state", 1)); |
| | | //æ¥è¯¢éå®åä¸äº§åä¿¡æ¯ |
| | | List<SaleMaterial> saleMaterials = saleMaterialMapper.selectList(Wrappers.<SaleMaterial>query() |
| | | .eq("sale_id", sale.getId()) |
| | | .eq("state", 1)); |
| | | List<ConsignmentDto2> dto2List = saleMaterials.stream().map(saleMaterial -> { |
| | | ConsignmentDto2 consignmentDto2 = new ConsignmentDto2(); |
| | | BeanUtils.copyProperties(saleMaterial, consignmentDto2); |
| | |
| | | <if test="time!=null and time!=''"> |
| | | and create_time=#{time} |
| | | </if> |
| | | <if test="type!=null and type!=''"> |
| | | <if test="type!=null "> |
| | | and type=#{type} |
| | | </if> |
| | | <if test="checkState!=null and checkState!=''"> |
| | | <if test="checkState!=null "> |
| | | and check_state=#{checkState} |
| | | </if> |
| | | order by id desc |
| | |
| | | select id, name, specifications, unit |
| | | from mom_ocean.repertory |
| | | where state = 1 |
| | | and check_state = 1 |
| | | and type = 0 |
| | | </select> |
| | | </mapper> |
| | |
| | | <if test="name!=null and name!=''"> |
| | | and name LIKE CONCAT('%',#{name},'%') |
| | | </if> |
| | | <if test="type!=null and type!=''"> |
| | | <if test="type!=null "> |
| | | and type=#{type} |
| | | </if> |
| | | <if test="delTime!=null and delTime!=''"> |
| | |
| | | from mom_ocean.sale s ,mom_ocean.sale_material sm |
| | | where s.id=sm.sale_id |
| | | and s.state=1 |
| | | and bianzhi_state!=2 |
| | | <if test="orderCode!=null and orderCode!=''"> |
| | | and order_number like concat('%',#{orderCode},'%') |
| | | </if> |
| | | <if test="name!=null and name!=''"> |
| | | and sm.name like concat('%',#{name},'%') |
| | | </if> |
| | | <if test="state!=null and state!=''"> |
| | | <if test="state!=null "> |
| | | and bianzhi_state=#{state} |
| | | </if> |
| | | <if test="time!=null and time!=''"> |