package com.stylefeng.guns.modular.system.dao;
|
|
import com.baomidou.mybatisplus.mapper.BaseMapper;
|
import com.stylefeng.guns.modular.system.model.Income;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
import java.util.Map;
|
|
public interface IncomeMapper extends BaseMapper<Income> {
|
|
|
List<Map<String, Object>> summaryOfIncomeDetailsList(@Param("companyId") Integer companyId, @Param("startTime") String startTime, @Param("endTime") String endTime,
|
@Param("offset") Integer offset, @Param("limit") Integer limit);
|
|
|
int summaryOfIncomeDetailsListCount(@Param("companyId") Integer companyId, @Param("startTime") String startTime, @Param("endTime") String endTime);
|
|
|
Map<String, Object> summaryOfIncomeDetailsListSum(@Param("companyId") Integer companyId, @Param("startTime") String startTime, @Param("endTime") String endTime,
|
@Param("orderType")Integer orderType, @Param("incomeType")Integer incomeType,
|
@Param("name")String name, @Param("phone")String phone);
|
|
|
/**
|
* 获取汇总数据
|
* @param userType
|
* @param objectId
|
* @param insertTime
|
* @return
|
*/
|
List<Map<String, Object>> summaryOfIncomeDetailsListGroupSum(@Param("userType") Integer userType, @Param("objectId") Integer objectId, @Param("insertTime") String insertTime);
|
|
|
List<Map<String, Object>> summaryOfIncomeDetailsListGroupSum1(@Param("userType") Integer userType, @Param("objectId") Integer objectId,
|
@Param("startTime") String startTime, @Param("endTime") String endTime,
|
@Param("orderType")Integer orderType, @Param("incomeType")Integer incomeType,
|
@Param("name")String name, @Param("phone")String phone,
|
@Param("offset") Integer offset, @Param("limit") Integer limit);
|
|
|
Double getSumData(@Param("userType") Integer userType, @Param("objectId") Integer objectId,
|
@Param("insertTime") String insertTime, @Param("types") List<Integer> types);
|
|
|
|
List<Map<String, Object>> summaryOfSpendingDetailsList(@Param("companyId") Integer companyId, @Param("startTime") String startTime, @Param("endTime") String endTime,
|
@Param("offset") Integer offset, @Param("limit") Integer limit);
|
|
|
List<Map<String, Object>> summaryOfSpendingDetailsList1(@Param("companyId") Integer companyId, @Param("startTime") String startTime, @Param("endTime") String endTime,
|
@Param("orderType") Integer orderType, @Param("incomeType") Integer incomeType,
|
@Param("name") String name, @Param("phone") String phone,
|
@Param("offset") Integer offset, @Param("limit") Integer limit);
|
|
|
int summaryOfSpendingDetailsListCount(@Param("companyId") Integer companyId, @Param("startTime") String startTime, @Param("endTime") String endTime);
|
|
|
Map<String, Object> summaryOfSpendingDetailsListSum(@Param("companyId") Integer companyId, @Param("startTime") String startTime,
|
@Param("endTime") String endTime, @Param("orderType") Integer orderType,
|
@Param("incomeType") Integer incomeType, @Param("name") String name,
|
@Param("phone") String phone);
|
|
void updateState(@Param("allNo") String s);
|
|
}
|