package com.zteits.business.dao.impl;
import org.apache.commons.collections4.CollectionUtils;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.zteits.business.domain.TdCBusinessAcct;
import com.zteits.business.domain.TdCBusinessAcctExample;
import com.zteits.business.domain.TdCBusinessAcctSource;
import com.zteits.business.domain.TdCBusinessAcctSourceExample;
import com.zteits.business.mapper.smapper.TdCBusinessAcctSourceSMapper;
import com.zteits.clouds.api.dto.business.dto.BusinessAcctSourceRechargeStaticDTO;
import com.zteits.clouds.api.dto.business.param.TdCBusinessAcctSourceRequest;
import com.zteits.business.dao.TdCBusinessAcctSourceDao;
import com.zteits.business.mapper.TdCBusinessAcctSourceMapper;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import com.zteits.clouds.api.apibase.constants.DataStatusEnum;
import org.springframework.util.StringUtils;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

@Component
public class TdCBusinessAcctSourceDaoImpl implements  TdCBusinessAcctSourceDao {
    @Autowired
    private TdCBusinessAcctSourceMapper tdCBusinessAcctSourceMapper;
    @Autowired
    private TdCBusinessAcctSourceSMapper tdCBusinessAcctSourceSMapper;

    @Override
    public int saveTdCBusinessAcctSource(TdCBusinessAcctSource tdCBusinessAcctSource) {
        if(tdCBusinessAcctSource.getCreateDate()==null){
            tdCBusinessAcctSource.setCreateDate(new Date());
        }
        return tdCBusinessAcctSourceMapper.insertSelective(tdCBusinessAcctSource);
    }

    @Override
    public int updateByExampleSelective(TdCBusinessAcctSource record, TdCBusinessAcctSourceExample example) {
        return tdCBusinessAcctSourceMapper.updateByExampleSelective(record,example);
    }

    @Override
    public int updateByPrimaryKeySelective(TdCBusinessAcctSource record) {
        return tdCBusinessAcctSourceMapper.updateByPrimaryKeySelective(record);
    }

    @Override
    public List<TdCBusinessAcctSource> selectByExample(TdCBusinessAcctSourceExample example) {
        return tdCBusinessAcctSourceMapper.selectByExample(example);
    }

    @Override
    public TdCBusinessAcctSource queryByPrimaryKey(Long id) {
        return tdCBusinessAcctSourceMapper.selectByPrimaryKey(id);
    }

    @Override
    public List<TdCBusinessAcctSource> queryTdCBusinessAcctSource(TdCBusinessAcctSourceRequest request) {
        TdCBusinessAcctSourceExample example = new TdCBusinessAcctSourceExample();
        TdCBusinessAcctSourceExample.Criteria sql = example.createCriteria();
        if(!StringUtils.isEmpty(request.getBusinessId())){
            sql.andBusinessIdEqualTo(request.getBusinessId());
        }
        if(!StringUtils.isEmpty(request.getSourceBillId())){
            sql.andSourceBillIdEqualTo(request.getSourceBillId());
        }
        List<TdCBusinessAcctSource> list = tdCBusinessAcctSourceMapper.selectByExample(example);
        return list;
    }

    @Override
    public int batchDeleteTdCBusinessAcctSourceByPrimaryKey(List<Long> ids, String opId, String opName) {
        TdCBusinessAcctSource record = new TdCBusinessAcctSource();
        record.setDataState(DataStatusEnum.DATA_STATUS_NO_VALID.value());
        TdCBusinessAcctSourceExample example = new TdCBusinessAcctSourceExample();
        example.createCriteria().andIdIn(ids);
        return tdCBusinessAcctSourceMapper.updateByExampleSelective(record,example);
    }

    @Override
    public PageInfo<TdCBusinessAcctSource> queryTdCBusinessAcctSourceForPage(TdCBusinessAcctSourceRequest request) {
        PageHelper.startPage(request.getBaseRequest().getPageNum(), request.getBaseRequest().getPageSize());

        TdCBusinessAcctSourceExample example = new TdCBusinessAcctSourceExample();
        TdCBusinessAcctSourceExample.Criteria sql = example.createCriteria();

        if(!StringUtils.isEmpty(request.getBusinessId())){
            sql.andBusinessIdEqualTo(request.getBusinessId());
        }
        if(!StringUtils.isEmpty(request.getBeginDate())){
            sql.andRechargeTimeGreaterThan(request.getBeginDate());
        }
        if(!StringUtils.isEmpty(request.getEndDate())){
            sql.andRechargeTimeLessThan(request.getEndDate());
        }
        if(!StringUtils.isEmpty(request.getBusinessName())){
            sql.andBusinessNameLike("%"+request.getBusinessName()+"%");
        }
        if(!StringUtils.isEmpty(request.getUserPhone())){
            sql.andUserPhoneLike("%"+request.getUserPhone()+"%");
        }
        if(!StringUtils.isEmpty(request.getExamineState())){
            sql.andExamineStateEqualTo(request.getExamineState());
        }
        if(!StringUtils.isEmpty(request.getRechargeType())){
            sql.andRechargeTypeEqualTo(request.getRechargeType());
        }
        sql.andDataStateEqualTo(DataStatusEnum.DATA_STATUS_VALID.value());
        example.setOrderByClause("id desc");
        List<TdCBusinessAcctSource> list = tdCBusinessAcctSourceMapper.selectByExample(example);
        if (CollectionUtils.isNotEmpty(list)) {
            return new PageInfo<TdCBusinessAcctSource>(list);
        }
        return new PageInfo<TdCBusinessAcctSource>(new ArrayList<TdCBusinessAcctSource>());
    }

    @Override
    public BusinessAcctSourceRechargeStaticDTO queryBusinessRechargeFeeStatic(TdCBusinessAcctSourceRequest request) {
        return  tdCBusinessAcctSourceSMapper.queryBusinessRechargeFeeStatic(request);
    }
}