package com.clx.performance.dao.impl.loan;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.clx.performance.dao.loan.OwnerLoanRecordDao;
import com.clx.performance.enums.loan.OwnerLoanRecordEnum;
import com.clx.performance.mapper.loan.OwnerLoanRecordMapper;
import com.clx.performance.model.loan.OwnerLoanRecord;
import com.clx.performance.param.pc.loan.carrier.PageCarrierOwnerLoanRecordParam;
import com.clx.performance.param.pc.loan.carrier.PageOwnerLoanRecordOfOwner;
import com.clx.performance.vo.pc.loan.carrier.OwnerLoanRecordVO;
import com.msl.common.base.Optional;
import com.msl.common.dao.impl.BaseDaoImpl;
import com.msl.common.utils.DateUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.stereotype.Repository;

import java.time.LocalDateTime;
import java.util.List;
import java.util.Objects;

/**
 * @author kavin
 * Date 2024-01-20
 * Time 17:05
 */
@Repository
public class OwnerLoanRecordDaoImpl extends BaseDaoImpl<OwnerLoanRecordMapper, OwnerLoanRecord, Integer> implements OwnerLoanRecordDao {
    @Override
    public IPage<OwnerLoanRecord> pageOwnerLoanRecord(PageCarrierOwnerLoanRecordParam param) {
        LambdaQueryWrapper<OwnerLoanRecord> query = new LambdaQueryWrapper<>();
        if(Objects.nonNull(param.getLoanType())){
            query.eq(OwnerLoanRecord :: getLoanType,param.getLoanType());
        }
        if(StringUtils.isNotBlank(param.getOwnerUserNo())){
            query.eq(OwnerLoanRecord :: getOwnerUserNo,param.getOwnerUserNo());
        }
        if(StringUtils.isNotBlank(param.getOwnerUserName())){
            query.like(OwnerLoanRecord :: getOwnerUserName,param.getOwnerUserName());
        }
        if(StringUtils.isNotBlank(param.getMobile())){
            query.like(OwnerLoanRecord :: getMobile,param.getMobile());
        }
        if(Objects.nonNull(param.getLoanNo())){
            query.like(OwnerLoanRecord :: getLoanNo,param.getLoanNo());
        }
        if(Objects.nonNull(param.getStatus())){
            query.like(OwnerLoanRecord :: getStatus,param.getStatus());
        }
        query.orderByDesc(OwnerLoanRecord :: getCreateTime);
        return baseMapper.selectPage(Page.of(param.getPage(), param.getPageSize()),query);
    }

    @Override
    public IPage<OwnerLoanRecordVO> pageByParam(PageOwnerLoanRecordOfOwner param) {
        Page<OwnerLoanRecordVO> page = Page.of(param.getPage(), param.getPageSize());
        return baseMapper.pageByParam(page,param);
    }

    /**
     * 查询审批通过和付款成功并且未用完的借款(资金+虚拟货币)
     * @param userNo
     * @return
     */
    @Override
    public List<OwnerLoanRecord> selectLoanBalance(Long userNo) {
        return baseMapper.selectList(
                lQrWrapper().in(OwnerLoanRecord::getStatus, OwnerLoanRecordEnum.Status.APPROVE_PASS.getCode(), OwnerLoanRecordEnum.Status.PAY_SUCCESS.getCode())
                        .eq(OwnerLoanRecord::getOwnerUserNo , userNo)
                        .gt(OwnerLoanRecord::getLoanResidueBalance, 0)
                        .orderByAsc(OwnerLoanRecord:: getId)
        );
    }

    @Override
    public Optional<OwnerLoanRecord> selectByMerchantRunningWaterNo(String merchantRunningWaterNo) {
        return Optional.of(merchantRunningWaterNo)
                .map(item -> lQrWrapper()
                        .eq(OwnerLoanRecord::getMerchantRunningWaterNo, item)
                )
                .map(super::getOne);
    }

    @Override
    public boolean updatePay(OwnerLoanRecord item) {
        return update(lUdWrapper()
                .eq(OwnerLoanRecord::getId, item.getId())
                .set(OwnerLoanRecord::getStatus, item.getStatus())
                .set(OwnerLoanRecord::getPayChannel, item.getPayChannel())
                .set(OwnerLoanRecord::getRunningWaterOpenNo, item.getRunningWaterOpenNo())
                .set(OwnerLoanRecord::getMerchantRunningWaterNo, item.getMerchantRunningWaterNo())
                .set(OwnerLoanRecord::getRemittanceIdentificationCode, item.getRemittanceIdentificationCode())
                .set(OwnerLoanRecord::getCloseOrderTime, item.getCloseOrderTime())
                .set(OwnerLoanRecord::getLoanResidueBalance, item.getLoanResidueBalance())
                .set(OwnerLoanRecord::getCloseOrderTime, item.getCloseOrderTime())
                .set(OwnerLoanRecord::getRemittanceIdentificationCode, item.getRemittanceIdentificationCode())
                .set(OwnerLoanRecord::getLendingParty, item.getLendingParty())
                .set(OwnerLoanRecord::getLendingPartyAccount, item.getLendingPartyAccount())
        );
    }


    @Override
    public boolean updateStatusById(OwnerLoanRecord item) {
        return update(lUdWrapper()
                .eq(OwnerLoanRecord::getId, item.getId())
                .set(OwnerLoanRecord::getStatus, item.getStatus())
        );
    }

    @Override
    public OwnerLoanRecord selectOneByLoanNo(Long loanNo) {
        return baseMapper.selectOne(lQrWrapper().eq(OwnerLoanRecord::getLoanNo, loanNo));
    }

    @Override
    public Integer updateCasLoanRecord(OwnerLoanRecord update) {
        String nowStr = DateUtils.formatDateTime(LocalDateTime.now()).get();
        return baseMapper.updateCasLoanRecord(update, nowStr);
    }


}
