java后台小记

逻辑：判断当前课程是否超过可以取消预约的次数，是否超过可以取消预约的时间

1、获取私教课的相关信息传至页面

GdUser user = (GdUser) this.getSessionUser(); String gym = user.getXX("gym"); String userId = user.getId(); // 私教课 Entity en = new EntityImpl("yp_private_record", this); String sql = "SELECT\n" + " a.*, b.lesson_name,d.lesson_num,d.nums,\n" + " b.lesson_type,\n" + " c.emp_name,\n" + " c.phone,\n" + " d.level\n" + "FROM\n" + " yp_private_record_" + gym + " a,\n" + " yp_private_user d,\n" + " yp_private_plan b,\n" + " yp_emp c\n" + "WHERE\n" + " a.mem_id =?\n" + "AND a.private_id = d.id\n" + "and d.lesson_id = b.ID\n" + "AND a.emp_id = c.id" + " AND (a.state=? or a.state=? or a.state=?)"; int size = en.executeQuery(sql, new String[] { userId, "001", "002", "003" }); List<Map<String, Object>> SclassList = en.getValues(); if (size > 0) { Code xx = Codes.code("CLASS_STATE"); for (Map<String, Object> m : SclassList) { Date order_time = (Date) m.get("order_time"); String time = sdf.format(order_time); m.put("order_time", time); String state = xx.getNote(m.get("state").toString()); m.put("state", state); } } this.obj.put("data", SclassList);

2、获取团课相关信息

// 团课课 en = new EntityImpl("yp_grp_list", this); sql = "select a.id,a.grp_name,a.order_time,a.state,a.feedback, b.emp_name,b.phone,c.start_time,c.end_time, c.grp_id from yp_grp_list_" + gym + " a,yp_emp b ,yp_grp_plan c where a.grp_id = c.id and c.emp_id =b.id and a.mem_id=?" + " AND (a.state=? or a.state=? or a.state=?)"; size = en.executeQuery(sql, new String[] { userId, "001", "002", "003" }); // 查询购买的团课 Entity entity = new EntityImpl("yp_grp_user", this); entity.setValue("mem_id", userId); entity.search(); List<Map<String, Object>> grpUser = entity.getValues(); List<Map<String, Object>> TclassList = en.getValues(); if (size > 0) { Code xx = Codes.code("CLASS_STATE"); for (Map<String, Object> m : TclassList) { Date start_time = (Date) m.get("start_time"); String s_time = sdf.format(start_time); m.put("start_time", s_time); Date end_time = (Date) m.get("end_time"); String e_time = sdf.format(end_time); m.put("end_time", e_time); Date order_time = (Date) m.get("order_time"); String o_time = sdf.format(order_time); m.put("order_time", o_time); String state = xx.getNote(m.get("state").toString()); m.put("state", state); String g_id = m.get("grp_id").toString(); int nums = 1; int lesson_num = 1; for (int j = 0; j < grpUser.size(); j++) { String grp_id = entity.getStringValue("grp_id", j); if (g_id.equals(grp_id)) { nums = entity.getIntegerValue("nums", j); lesson_num = entity.getIntegerValue("lesson_num", j); break; } } m.put("nums", nums); m.put("lesson_num", lesson_num); } } this.obj.put("Tdata", TclassList);获取的团课私课信息 用map存起来，data传到前台，再用模版展现出来

将查到的data用for循环的形式遍历筛选，显示在指定的地方

3、取消团课预约

@Route(value = "cancle_class", conn = true, mdb = false, m = HttpMethod.POST, type = ContentType.JSON) public void cancle_class() throws Exception { GdUser user = (GdUser) this.getSessionUser(); String mem_id = user.getId(); String tid = this.getParameter("tid"); String cust_name = user.getCust_name(); String gym = user.getGym(); List<Map<String, Object>> cardList = AppUtils.getCards(this.getConnection(), gym, mem_id); Entity en = new EntityImpl(this); /** * 查询设置的最大取消预约次数 */ String sql = "select note from yp_param where cust_name=? and code='order_setting'"; int size = en.executeQuery(sql, new String[] { cust_name }); JSONObject noteObj = null; if (size > 0) { String note = en.getStringValue("note"); JSONObject x = new JSONObject(note); noteObj = x.getJSONObject(gym); int canelTimes = 0; for (Map<String, Object> m : cardList) { String card_type = (String) m.get("card_type"); if ("001".equals(card_type)) { try { canelTimes = noteObj.getInt("007"); } catch (Exception e) { } break; } else if ("003".equals(card_type)) { // 会员最多取消预约次数(次卡) try { canelTimes = noteObj.getInt("008"); } catch (Exception e) { } break; } else if ("002".equals(card_type)) { // 会员最多取消预约次数(储值卡) try { canelTimes = noteObj.getInt("009"); } catch (Exception e) { } break; } } if (canelTimes == 0) { throw new Exception("您预约的课程不能取消哦"); } // 获取当前用户已经取消预约了的次数 en = new EntityImpl("yp_private_record", this); sql = "select id from yp_private_record_" + gym + " where state = '004' and mem_id =? "; size = en.executeQuery(sql, new String[] { mem_id }); if (size > canelTimes) { throw new Exception("您最多能取消" + canelTimes + "次课程"); } } en = new EntityImpl("yp_grp_list", this); sql = "select a.id,a.order_time,b.start_time from yp_grp_list_" + gym + " a,yp_grp_plan b where a.grp_id = b.id and a.state ='001' and a.mem_id=? and a.cust_name = ? and a.id = ?"; size = en.executeQuery(sql, new String[] { mem_id, cust_name, tid }); if (size > 0) { String order_time = en.getStringValue("order_time"); String start_time = en.getStringValue("start_time"); SimpleDateFormat date = new SimpleDateFormat("yyyy-MM-dd HH:mm"); /** * 判断是否可以取消 */ en = new EntityImpl(this); sql = "select note from yp_param where code='order_setting' and cust_name=?"; size = en.executeQuery(sql, new String[] { user.getCust_name() }); if (size > 0) { String note = en.getStringValue("note"); JSONObject obj = new JSONObject(note); obj = obj.getJSONObject(gym); if (obj.has("002")) { String hour = obj.get("002").toString();// 会员需提前几小时取消预约 Calendar cld = Calendar.getInstance(); cld.setTime(date.parse(start_time)); cld.add(Calendar.HOUR, -Integer.parseInt(hour)); Date newDate = cld.getTime(); // 如果减去提前取消预约的是时间在当前时间之后 if ((new Date()).after(newDate)) { throw new Exception("该课程必须提前" + hour + "小时取消预约"); } } } Date now_date = new Date(); en = new EntityImpl("yp_param", this); en = new EntityImpl("yp_grp_list", this); en.setTablename("yp_grp_list_" + gym); en.setValue("id", tid); en.setValue("state", "004"); en.setValue("un_order_time", now_date); en.update(); this.obj.put("data", "cancel_success"); } else { throw new Exception("没有查询到团课预约"); } }

做判断

查询设置的最大取消预约次数 最迟预约时间 然后判断 正常的条件下才可以取消预约 执行取消预约的数据修改