wangrenhuang
2023-10-19 194fbb628f82b1bbf15a6c649fffcacf922f4391
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
package com.hz.his.dto.report;
 
import lombok.Data;
 
import java.util.List;
 
/**
 * @Author  门店业绩报表实体
 */
@Data
public class ShopCashReportDto {
    /**门店标识*/
    private String shopId;
    /** 业绩类型   */
    private String type;
    /**开始时间*/
    private String startTime;
    /**结束时间*/
    private String endTime;
    /**门店列表标识*/
    private List<String> shopIdList;
    /** 是否过滤测试用户账号 */
    private Integer isFilterTestAccount;
 
    /**业绩类型-门店日现金业绩*/
    public static final String  TYPE_DAY_CASH= "day_cash";
    /**业绩类型-门店日执行业绩*/
    public static final String  TYPE_DAY_IMPLEMENT= "day_implement";
    /**业绩类型-门店周现金业绩*/
    public static final String  TYPE_WEEK_CASH= "week_cash";
    /**业绩类型-门店周执行业绩*/
    public static final String  TYPE_WEEK_IMPLEMENT= "week_implement";
    /**业绩类型-门店月现金业绩*/
    public static final String  TYPE_MONTH_CASH= "month_cash";
    /**业绩类型-门店月执行业绩*/
    public static final String  TYPE_MONTH_IMPLEMENT= "month_implement";
 
 
    /** 获取查询门店insql */
    public String getSelectShopInSql(){
        if(shopIdList == null || shopIdList.size() < 1){
            return null;
        }
 
        StringBuffer sql = new StringBuffer();
        sql.append("(");
        for(String shopId : shopIdList){
            sql.append("'").append(shopId).append("',");
        }
        sql.delete(sql.length()-1, sql.length());
        sql.append(")");
        return sql.toString();
    }
}