package com.ltkj.hosp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjTollCollectorDetail;
import com.ltkj.hosp.vodomain.HzDetailsVoDomain;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: zjh
 * @Date: 2023/3/8 10:43
 */
@Mapper
public interface TjTollCollectorDetailMapper extends BaseMapper<TjTollCollectorDetail> {


    @Select("SELECT * FROM tj_toll_collector_detail  WHERE account_id =#{accountId} AND deleted=0")
    List<TjTollCollectorDetail> getTjTollCollectorDetailList(String accountId);


    @Select("SELECT pay_type type,COUNT(pay_type) count,SUM(payable) jyPay FROM tj_toll_collector_detail  WHERE account_id =#{accountId} AND deleted=0\n" +
            "\n" +
            "GROUP BY pay_type")
    List<HzDetailsVoDomain> getTjTollCollectorDetailLists(String accountId);
}