1

zj

2024-07-20 09760b27383aea4d485fd3d9d5ea0491a88105b5

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
73
74
75
76
77
package project.contract.internal;
 
import java.util.HashMap;
import java.util.List;
import java.util.Map;
 
import org.springframework.jdbc.core.JdbcTemplate;
 
import kernel.util.StringUtils;
import kernel.web.Page;
import kernel.web.PagedQueryDao;
import project.contract.AdminContractApplyOrderService;
import project.party.recom.UserRecomService;
 
public class AdminContractApplyOrderServiceImpl implements AdminContractApplyOrderService {
    private PagedQueryDao pagedQueryDao;
    private UserRecomService userRecomService;
 
    public Page pagedQuery(int pageNo, int pageSize, String state, String rolename, String loginPartyId,String username,String orderNo) {
        StringBuffer queryString = new StringBuffer(
                "SELECT orders.UUID id,orders.SYMBOL symbol,orders.ORDER_NO order_no,"
                + "orders.DIRECTION direction,orders.OFFSET offset,"
                + "orders.VOLUME_OPEN volume_open,orders.LEVER_RATE lever_rate,"
                + "orders.STATE state,orders.ORDER_PRICE_TYPE order_price_type,"
                + "orders.STOP_PRICE_LOSS stop_price_loss, orders.CREATE_TIME createTime,"
                + "orders.STOP_PRICE_PROFIT stop_price_profit,"
                + "orders.PRICE price,item.NAME itemname,");
 
        queryString.append(
                " party.USERNAME username,party.USERCODE usercode,party.ROLENAME rolename  ");
 
        queryString.append(
                " FROM T_CONTRACT_APPLY_ORDER orders LEFT JOIN PAT_PARTY party ON orders.PARTY_ID = party.UUID LEFT JOIN T_ITEM item ON orders.SYMBOL=item.SYMBOL WHERE 1 = 1 ");
 
        Map parameters = new HashMap();
        if (!StringUtils.isNullOrEmpty(loginPartyId)) {
            List children = this.userRecomService.findChildren(loginPartyId);
            if (children.size() == 0) {
                return Page.EMPTY_PAGE;
            }
            queryString.append(" and orders.PARTY_ID in (:children) ");
            parameters.put("children", children);
        }
 
        if (!StringUtils.isNullOrEmpty(state)) {
            queryString.append(" and orders.STATE =  :state ");
            parameters.put("state", state);
        }
 
        if (!StringUtils.isNullOrEmpty(rolename)) {
            queryString.append(" and party.ROLENAME = :rolename  ");
            parameters.put("rolename", rolename);
 
        }
        if (!StringUtils.isNullOrEmpty(orderNo)) {
            queryString.append(" and orders.ORDER_NO = :orderNo  ");
            parameters.put("orderNo", orderNo);
            
        }
        if (!StringUtils.isNullOrEmpty(username)) {
            queryString.append("AND (party.USERNAME like:username OR party.USERCODE like:username ) ");
            parameters.put("username","%"+username+"%");
        }
        queryString.append(" order by orders.CREATE_TIME desc ");
        Page page = this.pagedQueryDao.pagedQuerySQL(pageNo, pageSize, queryString.toString(), parameters);
 
        return page;
    }
 
    public void setPagedQueryDao(PagedQueryDao pagedQueryDao) {
        this.pagedQueryDao = pagedQueryDao;
    }
 
    public void setUserRecomService(UserRecomService userRecomService) {
        this.userRecomService = userRecomService;
    }
}