package com.ruoyi.system.mapper;

import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.domain.SysCard;
import com.ruoyi.system.dto.SysCardPageRequest;
import com.ruoyi.system.vo.SysCardVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 卡片管理数据层。
 */
@Mapper
public interface SysCardMapper
{
    List<SysCardVO> pageList(@Param("query") SysCardPageRequest query, @Param("pageInfo") PageInfo<SysCardVO> pageInfo);

    List<SysCardVO> selectList(@Param("query") SysCardPageRequest query);

    SysCardVO selectVoById(Long cardId);

    SysCard selectById(Long cardId);

    SysCard selectByCardNo(@Param("cardNo") String cardNo);

    SysCard selectByEmployeeId(@Param("employeeId") Long employeeId);

    int insertCard(SysCard card);

    int updateCard(SysCard card);

    int deleteByIds(@Param("cardIds") List<Long> cardIds, @Param("updateBy") String updateBy);

    int bindCard(@Param("cardId") Long cardId, @Param("employeeId") Long employeeId, @Param("updateBy") String updateBy);

    int unbindByEmployeeId(@Param("employeeId") Long employeeId, @Param("updateBy") String updateBy);

    int unbindByCardNo(@Param("cardNo") String cardNo, @Param("updateBy") String updateBy);
}