package com.example.erp.service.sd;
|
|
import com.alibaba.fastjson.JSONArray;
|
import com.alibaba.fastjson.JSONObject;
|
import com.baomidou.dynamic.datasource.annotation.DS;
|
import com.example.erp.entity.sd.Delivery;
|
import com.example.erp.entity.sd.DeliveryDetail;
|
import com.example.erp.entity.sd.Order;
|
import com.example.erp.entity.sd.OrderDetail;
|
import com.example.erp.mapper.mm.FinishedGoodsInventoryMapper;
|
import com.example.erp.mapper.sd.DeliveryDetailMapper;
|
import com.example.erp.mapper.sd.DeliveryMapper;
|
import com.example.erp.mapper.sd.OrderDetailMapper;
|
import com.example.erp.mapper.sd.OrderMapper;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import java.text.SimpleDateFormat;
|
import java.time.LocalDate;
|
import java.util.*;
|
|
@Service
|
@DS("sd")
|
public class DeliveryService {
|
@Autowired
|
DeliveryMapper deliveryMapper;
|
@Autowired
|
DeliveryDetailMapper deliveryDetailMapper;
|
@Autowired
|
OrderMapper orderMapper;
|
@Autowired
|
OrderDetailMapper orderDetailMapper;
|
@Autowired
|
FinishedGoodsInventoryMapper finishedGoodsInventoryMapper;
|
|
public Map<String, Object> getseletShippingOrder(Integer pageNum, Integer pageSize,List<String> selectDate, Delivery delivery) {
|
Integer offset = (pageNum - 1) * pageSize;
|
String endDate = LocalDate.now().toString();
|
String startDate = LocalDate.now().minusDays(15).toString();
|
if(selectDate !=null && selectDate.size()==2){
|
if(!selectDate.get(0).isEmpty()){
|
startDate = selectDate.get(0);
|
}
|
if(!selectDate.get(1).isEmpty()){
|
endDate = selectDate.get(1);
|
}
|
}
|
Map<String, Object> map = new HashMap<>();
|
map.put("data", deliveryMapper.getseletShippingOrder(offset, pageSize,startDate,endDate, delivery));
|
map.put("total", deliveryMapper.getseletShippingOrderPageTotal(offset, pageSize,startDate,endDate, delivery));
|
List<String> list = new ArrayList<>();
|
list.add(startDate);
|
list.add(endDate);
|
map.put("selectDate",list);
|
return map;
|
}
|
|
public Map<String, Object> getseletShippingOrderDetail(Integer pageNum, Integer pageSize, OrderDetail orderDetail) {
|
Integer offset = (pageNum - 1) * pageSize;
|
|
Map<String, Object> map = new HashMap<>();
|
map.put("data", deliveryDetailMapper.getseletShippingOrderDetail(offset, pageSize, orderDetail));
|
map.put("delivery", deliveryMapper.getseletShippingOrderDetaildelivery(offset, pageSize, orderDetail));
|
map.put("total", deliveryDetailMapper.getseletShippingOrderDetailPageTotal(offset, pageSize, orderDetail));
|
|
return map;
|
}
|
|
public Map<String, Object> getSelectOrderInventory(Integer pageNum, Integer pageSize,List<String> selectDate, Order order) {
|
Integer offset = (pageNum - 1) * pageSize;
|
String endDate = LocalDate.now().toString();
|
String startDate = LocalDate.now().minusDays(15).toString();
|
if(selectDate !=null && selectDate.size()==2){
|
if(!selectDate.get(0).isEmpty()){
|
startDate = selectDate.get(0);
|
}
|
if(!selectDate.get(1).isEmpty()){
|
endDate = selectDate.get(1);
|
}
|
}
|
Map<String, Object> map = new HashMap<>();
|
map.put("data", deliveryMapper.getSelectOrderInventory(offset, pageSize,startDate,endDate, order));
|
map.put("total", deliveryMapper.getSelectOrderInventoryPageTotal(offset, pageSize,startDate,endDate, order));
|
List<String> list = new ArrayList<>();
|
list.add(startDate);
|
list.add(endDate);
|
map.put("selectDate",list);
|
return map;
|
}
|
|
public Map<String, Object> getseletShippingOrderDetails(Integer pageNum, Integer pageSize, OrderDetail orderDetail) {
|
Integer offset = (pageNum - 1) * pageSize;
|
Map<String, Object> map = new HashMap<>();
|
map.put("data", deliveryDetailMapper.getseletShippingOrderDetails(offset, pageSize, orderDetail));
|
map.put("title", deliveryMapper.getseletShippingOrderDetaildeliverys(offset, pageSize, orderDetail));
|
map.put("total", deliveryDetailMapper.getseletShippingOrderDetailsPageTotal(offset, pageSize, orderDetail));
|
return map;
|
}
|
|
public Boolean insertDelivery(Map<String,Object> object) {
|
Boolean isinsert=false;
|
Delivery delivery = JSONObject.parseObject(JSONObject.toJSONString(object.get("title")), Delivery.class);
|
List<OrderDetail> orderDetaillist = JSONArray.parseArray(JSONObject.toJSONString(object.get("delivery")), OrderDetail.class);
|
//获取单号
|
String oddNumber= orderNumberSetting("发货");
|
deliveryMapper.insertDelivery(delivery,oddNumber,orderDetaillist.get(0).getOrderId());
|
Double area=0.0;
|
Integer quantity=0;
|
Double money=0.0;
|
//获取对象集合循环进行新增修改
|
|
if (!orderDetaillist.isEmpty()){
|
for (OrderDetail orderDetail : orderDetaillist) {
|
quantity+=orderDetail.getDeliveryDetail().getQuantity();
|
area+=orderDetail.getFinishedGoodsInventory().getActualSignalArea()*orderDetail.getDeliveryDetail().getQuantity();
|
money+=orderDetail.getPrice()*orderDetail.getDeliveryDetail().getQuantity();
|
Integer deliveryDetailmaximum=deliveryDetailMapper.getdeliveryDetailmaximum(oddNumber);
|
deliveryDetailMapper.insertDeliveryDetail(orderDetail,oddNumber,deliveryDetailmaximum+1);
|
deliveryDetailMapper.updateOrderDetailDeliveryNum(orderDetail);
|
//修改库存表出库数量
|
finishedGoodsInventoryMapper.updateInventoryquantityOut(orderDetail.getOrderId(),orderDetail.getOrderNumber(),orderDetail.getDeliveryDetail().getQuantity());
|
isinsert=true;
|
}
|
|
deliveryMapper.updatedelivery(Double.valueOf(String.format("%.2f", area)),quantity,Double.valueOf(String.format("%.2f", money)),oddNumber);
|
return isinsert;
|
}else{
|
return false;
|
}
|
|
|
}
|
|
|
public Boolean updateDeliveryToExamine(Map<String,Object> object) {
|
Boolean isinsert=false;
|
String deliveryId = "";
|
int type =3;
|
if (object.get("deliveryId") != null) {
|
deliveryId = object.get("deliveryId").toString();
|
}
|
|
if (object.get("type") != null) {
|
type = Integer.parseInt(object.get("type").toString());
|
}
|
|
deliveryMapper.updateDeliveryToExamine(deliveryId,type);
|
|
return true;
|
|
|
|
}
|
|
|
public String orderNumberSetting(String type) {
|
//根据类型自动生成不同的操作单号
|
String alias="";
|
if(Objects.equals(type, "发货")){
|
alias="FH";
|
}else if(Objects.equals(type, "出库")){
|
alias="CK";
|
}else if(Objects.equals(type, "调拨")){
|
alias="DB";
|
}else if(Objects.equals(type, "领出")){
|
alias="LC";
|
}else if(Objects.equals(type, "返工")){
|
alias="FG";
|
}
|
//查询当天的最大数量
|
Integer maximum=deliveryMapper.getmaximum(type);
|
//设置两位不够补0
|
String formattedNumber = String.format("%02d", maximum+1);
|
//格式化当前日期
|
Date currentDate = new Date();
|
SimpleDateFormat dateFormat = new SimpleDateFormat("yyMMdd");
|
String formattedDate = dateFormat.format(currentDate);
|
String oddNumbers = alias+formattedDate+formattedNumber;
|
return oddNumbers;
|
}
|
}
|
