时区修改24小时制，北京时间

peternameyakj

2025-04-29 acf1c75a32aa05f34d9d60b6ae3f3e052b532e9f

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
package project.monitor.pledgegalaxy.internal;
 
import java.util.HashMap;
import java.util.Map;
 
import kernel.util.StringUtils;
import kernel.web.Page;
import kernel.web.PagedQueryDao;
import project.monitor.pledgegalaxy.AdminPledgeGalaxyConfigService;
 
public class AdminPledgeGalaxyConfigServiceImpl implements AdminPledgeGalaxyConfigService {
    
    private PagedQueryDao pagedQueryDao;
 
    public Page pagedQuery(int pageNo, int pageSize, String name_para, String rolename) {
        
        StringBuffer queryString = new StringBuffer();
        
        queryString.append("SELECT ");
        
        queryString.append(" party.USERNAME username, party.ROLENAME rolename, party.USERCODE usercode, party_parent.USERNAME username_parent, ");
        queryString.append(" pledge_galaxy_config.UUID id, "
                + " pledge_galaxy_config.PLEDGE_AMOUNT_MIN pledge_amount_min, "
                + " pledge_galaxy_config.PLEDGE_AMOUNT_MAX pledge_amount_max, "
                + " pledge_galaxy_config.VALID_RECOM_PLEDGE_AMOUNT_MIN valid_recom_pledge_amount_min, "
                + " pledge_galaxy_config.STATIC_INCOME_FORCE_VALUE static_income_force_value, "
                + " pledge_galaxy_config.DYNAMIC_INCOME_ASSIST_VALUE dynamic_income_assist_value, "
                + " pledge_galaxy_config.TEAM_INCOME_PROFIT_RATIO team_income_profit_ratio, "
                + " pledge_galaxy_config.CREATED created, pledge_galaxy_config.UPDATED updated ");
        
        queryString.append(" FROM ");
        
        queryString.append(
                " T_AUTO_MONITOR_PLEDGE_GALAXY_CONFIG pledge_galaxy_config "
                + " LEFT JOIN PAT_PARTY party ON pledge_galaxy_config.PARTY_ID = party.UUID "
                + " LEFT JOIN PAT_USER_RECOM user ON user.PARTY_ID = party.UUID "
                + " LEFT JOIN PAT_PARTY party_parent ON user.RECO_ID = party_parent.UUID "
                + " ");
        
        queryString.append(" WHERE 1=1 ");
 
        Map<String, Object> parameters = new HashMap<String, Object>();
 
        if (!StringUtils.isNullOrEmpty(name_para)) {
            queryString.append(" and (party.USERNAME like :name_para or party.USERCODE =:usercode) ");
            parameters.put("name_para", "%" + name_para + "%");
            parameters.put("usercode", name_para);
        }
        
        if (!StringUtils.isNullOrEmpty(name_para)) {
            queryString.append("AND (party.USERNAME like:username OR party.USERCODE like:username ) ");
            parameters.put("username", "%" + name_para + "%");
        }
        
        if (!StringUtils.isNullOrEmpty(rolename)) {
            queryString.append(" and party.ROLENAME =:rolename");
            parameters.put("rolename", rolename);
        }
 
        queryString.append(" order by pledge_galaxy_config.UUID ASC ");
        
        Page page = this.pagedQueryDao.pagedQuerySQL(pageNo, pageSize, queryString.toString(), parameters);
 
        return page;
    }
 
    public void setPagedQueryDao(PagedQueryDao pagedQueryDao) {
        this.pagedQueryDao = pagedQueryDao;
    }
 
}