StatisticsFinancePageselectMapper.java
2.86 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
package com.lhcredit.project.business.statisticsFinancePageselect.mapper;
import com.lhcredit.project.business.statisticsFinancePageselect.domain.StatisticsFinancePageselect;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import java.util.List;
/**
* 前台财务调用统计 数据层
*
* @author lhcredit
* @date 2025-03-03
*/
public interface StatisticsFinancePageselectMapper {
/**
* 查询前台财务调用统计信息
*
* @param id 前台财务调用统计ID
* @return 前台财务调用统计信息
*/
public StatisticsFinancePageselect selectStatisticsFinancePageselectById(Integer id);
/**
* 查询前台财务调用统计列表
*
* @param statisticsFinancePageselect 前台财务调用统计信息
* @return 前台财务调用统计集合
*/
public List<StatisticsFinancePageselect> selectStatisticsFinancePageselectList(StatisticsFinancePageselect statisticsFinancePageselect);
/**
* 新增前台财务调用统计
*
* @param statisticsFinancePageselect 前台财务调用统计信息
* @return 结果
*/
public int insertStatisticsFinancePageselect(StatisticsFinancePageselect statisticsFinancePageselect);
/**
* 修改前台财务调用统计
*
* @param statisticsFinancePageselect 前台财务调用统计信息
* @return 结果
*/
public int updateStatisticsFinancePageselect(StatisticsFinancePageselect statisticsFinancePageselect);
/**
* 删除前台财务调用统计
*
* @param id 前台财务调用统计ID
* @return 结果
*/
public int deleteStatisticsFinancePageselectById(Integer id);
/**
* 批量删除前台财务调用统计
*
* @param ids 需要删除的数据ID
* @return 结果
*/
public int deleteStatisticsFinancePageselectByIds(String[] ids);
@Select("SELECT COUNT(id) FROM statistics_finance_pageselect WHERE count_status=1 and user_id=#{headId}")
Integer selectCountByOrgId(@Param("headId") String headId);
@Select(" SELECT id FROM statistics_finance_pageselect WHERE ename = #{name} AND org_id IN (SELECT dept_id FROM `org_dept` WHERE org_id=#{orgId} ) \n")
List<Object> selectCountByFinanceStatistics(Long orgId, String name);
// @Select("SELECT a.id, a.ename, a.org_id AS orgId, a.user_id AS userId, a.user_name AS userName, a.data_type AS data_Type, a.credit_time AS creditTime, a.result_remark AS resultRemark, a.count_status AS countStatus \n" +
// ",b.dept_name AS deptName\n" +
// "FROM statistics_finance_pageselect a LEFT JOIN front_dept b ON a.`org_id`=b.`id`\n" +
// " WHERE a.org_id IN (SELECT id FROM `front_dept` WHERE dept_name LIKE concat('%',#{depName},'%'))")
List<StatisticsFinancePageselect> getList(StatisticsFinancePageselect statisticsFinancePageselect);
}