fix

Helius

2021-09-15 7ab7943de217a9e5d4a489c22c7ae27a29692d55

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
package com.xzx.gc.system.service; 
 
import com.xzx.gc.entity.OrderStorageInfo; 
import com.xzx.gc.system.mapper.OrderStorageInfoMapper; 
import org.springframework.beans.factory.annotation.Autowired; 
import org.springframework.stereotype.Service; 
import org.springframework.transaction.annotation.Transactional; 
import tk.mybatis.mapper.entity.Example; 
 
import java.util.List; 
 
@Service 
@Transactional 
public class OrderStorageService { 
 
    @Autowired 
    private OrderStorageInfoMapper orderStorageInfoMapper; 
 
    public void add(OrderStorageInfo orderStorageInfo){ 
 
        orderStorageInfoMapper.insertSelective(orderStorageInfo); 
    } 
 
    public List<OrderStorageInfo> findByStorageType(Short storageType){ 
        OrderStorageInfo orderStorageInfo=new OrderStorageInfo(); 
        orderStorageInfo.setSysStorageType(storageType); 
        return orderStorageInfoMapper.select(orderStorageInfo); 
    } 
 
    public List<OrderStorageInfo> findByStorageTypeByTime(Short storageType){ 
        Example example=new Example(OrderStorageInfo.class); 
        Example.Criteria criteria = example.createCriteria(); 
        criteria.andEqualTo("sysStorageType",storageType); 
        criteria.andCondition("DATE_FORMAT(storage_time,'%Y-%m-%d')=date_sub(CURRENT_DATE(), interval 1 day)"); 
        return orderStorageInfoMapper.selectByExample(example); 
    } 
}