| | |
|---|
| | | StringBuffer queryString = new StringBuffer( |
|---|
| | | "SELECT orders.UUID id,orders.SYMBOL symbol,orders.AMOUNT_CLOSE amount_close,orders.CLOSE_AVG_PRICE close_avg_price," |
|---|
| | | + "orders.STOP_PRICE_PROFIT stop_price_profit,orders.STOP_PRICE_LOSS stop_price_loss," |
|---|
| | | + "orders.ORDER_NO order_no,orders.TRADE_AVG_PRICE trade_avg_price," |
|---|
| | | + "orders.ORDER_NO order_no,orders.PARTY_ID party_id,orders.TRADE_AVG_PRICE trade_avg_price," |
|---|
| | | + "orders.DIRECTION direction,orders.UNIT_AMOUNT unit_amount," |
|---|
| | | + "orders.STATE state,orders.FEE fee,orders.PROFIT profit,orders.CREATE_TIME createTime," |
|---|
| | | + "orders.DEPOSIT deposit,orders.DEPOSIT_OPEN deposit_open,orders.CLOSE_TIME closeTime," |
|---|
| | | + "orders.VOLUME_OPEN volume_open,orders.VOLUME volume,orders.LEVER_RATE as lever_rate,item.NAME itemname,"); |
|---|
| | | queryString.append(" wallet.MONEY money, "); |
|---|
| | | queryString.append(" party.USERNAME username,party.USERCODE usercode,party.ROLENAME rolename "); |
|---|
| | | queryString.append(" party.USERNAME username,party.USERCODE usercode,party.ROLENAME rolename,party.REMARKS remarks "); |
|---|
| | | |
|---|
| | | queryString.append( |
|---|
| | | " FROM T_CONTRACT_ORDER orders LEFT JOIN PAT_PARTY party ON orders.PARTY_ID = party.UUID LEFT JOIN T_WALLET wallet ON wallet.PARTY_ID = party.UUID LEFT JOIN T_ITEM item ON orders.SYMBOL=item.SYMBOL WHERE 1 = 1 "); |
|---|
