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);
    }
}