| | |
| | | if (!StringUtils.isNullOrEmpty(endTime)) { |
| | | whereSql.append("AND DATE(CREATE_TIME)<=DATE('"+endTime+" 23:59:59') "); |
| | | } |
| | | |
| | | whereSql.append("ORDER BY CREATE_TIME DESC LIMIT ?,?"); |
| | | if ("orders".equals(type)) { |
| | | whereSql.append("ORDER BY CREATE_TIME DESC LIMIT ?,?"); |
| | | } else if ("hisorders".equals(type)) { |
| | | whereSql.append("ORDER BY CLOSE_TIME DESC LIMIT ?,?"); |
| | | } |
| | | params.add(page.getFirstElementNumber()); |
| | | params.add(pageSize); |
| | | |
| | |
| | | } |
| | | |
| | | public Map<String, Object> bulidOne(ContractOrder order) { |
| | | SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss a", Locale.ENGLISH); |
| | | simpleDateFormat.setTimeZone(TimeZone.getTimeZone("America/New_York")); |
| | | // SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss a", Locale.ENGLISH); |
| | | SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
| | | simpleDateFormat.setTimeZone(TimeZone.getTimeZone("Europe/Berlin")); |
| | | DecimalFormat df = new DecimalFormat("#.##"); |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | map.put("order_no", order.getOrder_no()); |