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