后端代码
@RequestMapping(params = "getUseDatil")
@ResponseBody
public JSONArray getUseDatil(HttpServletRequest request, String id) {
id = id.trim();
User user = (User) request.getSession().getAttribute("user");
String username = user.getUsername();
if (StringUtils.isBlank(username)) {
return null;
}
List<Map<String, Object>> dataMap1 = DBHelper.getInstance().getDataMap("SELECT order_no,coupon_no,airline FROM coupon_manage WHERE id = '" + id + "'");
String order_no = dataMap1.get(0).get("order_no") + "";
String couponNo = dataMap1.get(0).get("coupon_no") + "";
String airline = dataMap1.get(0).get("airline") + "";
JSONArray objects = new JSONArray();
List<Map<String, Object>> dataMap = DBHelper.getInstance().getDataMap("SELECT id,order_no,ticket_no,zf_price,zf_bz,cg_price,use_status FROM orderRecord3 WHERE refund_quan_order like '%" + order_no + "%' ");
if (dataMap.size() > 0) {
for (int i = 0; i < dataMap.size(); i++) {
JSONObject jsonObject = new JSONObject();
String id1 = dataMap.get(i).get("id") + "";
String order_no1 = dataMap.get(i).get("order_no") + "";
String ticket_no = dataMap.get(i).get("ticket_no") + "";
String zf_price = dataMap.get(i).get("zf_price") + "";
String zf_bz = dataMap.get(i).get("zf_bz") + "";
String cg_price = dataMap.get(i).get("cg_price") + "";
String use_status = dataMap.get(i).get("use_status") + "";
if ("0".equals(use_status)){
use_status = "未知";
}
if ("3".equals(use_status)){
use_status = "部分使用(财务)";
}
if ("4".equals(use_status)){
use_status = "已使用(财务)";
}
jsonObject.put("id1", id1);
jsonObject.put("order_no", order_no1);
jsonObject.put("ticket_no", ticket_no);
jsonObject.put("zf_price", zf_price);
jsonObject.put("zf_bz", zf_bz);
jsonObject.put("cg_price", cg_price);
jsonObject.put("use_status", use_status);
objects.add(jsonObject);
}
}
if ("ASIA".equals(airline)) {
List<Map<String, Object>> dataMap2 = DB