/**
   * Insert the new weixin order for inside according to builder {@link
   * WxOrder#InsertBuilder4Inside}
   *
   * @param dbCon the database connection
   * @param staff the staff to perform this action
   * @param builder the builder {@link WxOrder#InsertBuilder4Inside}
   * @return the id to weixin order just inserted
   * @throws SQLException throws if failed to execute any SQL statement
   * @throws BusinessException throws if the member to this weixin serial does NOT exist
   */
  public static int insert(DBCon dbCon, Staff staff, WxOrder.InsertBuilder4Inside builder)
      throws SQLException, BusinessException {

    WxOrder wxOrder = builder.build();

    // Make the previous inside committed orders invalid.
    for (WxOrder order :
        getByCond(
            dbCon,
            staff,
            new ExtraCond()
                .setWeixin(wxOrder.getWeixinSerial())
                .setType(WxOrder.Type.INSIDE)
                .addStatus(WxOrder.Status.COMMITTED),
            null)) {
      try {
        update(
            dbCon,
            staff,
            new WxOrder.UpdateBuilder(order.getId()).setStatus(WxOrder.Status.INVALID));
      } catch (BusinessException ignored) {
        ignored.printStackTrace();
      }
    }

    // Insert the new inside order.
    return insert(dbCon, staff, wxOrder);
  }
  public ActionForward execute(
      ActionMapping mapping,
      ActionForm form,
      HttpServletRequest request,
      HttpServletResponse response)
      throws Exception {
    JObject jobject = new JObject();
    try {

      String pin = (String) request.getAttribute("pin");
      Staff staff = StaffDao.verify(Integer.parseInt(pin));

      String reason = request.getParameter("reason");
      CancelReason.InsertBuilder builder = new InsertBuilder(staff.getRestaurantId(), reason);
      CancelReasonDao.insert(staff, builder);
      jobject.initTip(true, "操作成功, 已添加退菜原因信息.");
    } catch (BusinessException e) {
      e.printStackTrace();
      jobject.initTip(e);
    } catch (Exception e) {
      e.printStackTrace();
      jobject.initTip4Exception(e);
    } finally {
      response.getWriter().print(jobject.toString());
    }
    return null;
  }
  public ActionForward execute(
      ActionMapping mapping,
      ActionForm form,
      HttpServletRequest request,
      HttpServletResponse response)
      throws Exception {

    JObject jobject = new JObject();
    List<PrintFunc> root;
    try {
      String pin = (String) request.getAttribute("pin");
      String printerId = request.getParameter("printerId");
      Staff staff = StaffDao.verify(Integer.parseInt(pin));
      root =
          PrintFuncDao.getByCond(
              staff, new PrintFuncDao.ExtraCond().setPrinter(Integer.parseInt(printerId)));
      List<PrintFunc> roots = new ArrayList<PrintFunc>();

      boolean detail = true;
      for (PrintFunc printFunc : root) {
        if (printFunc.getType() == PType.PRINT_ORDER_DETAIL
            || printFunc.getType() == PType.PRINT_CANCELLED_FOOD_DETAIL) {
          if (printFunc.getType() == PType.PRINT_ORDER_DETAIL) {
            if (detail) {
              roots.add(printFunc);
              detail = false;
            }
          } else if (printFunc.getType() == PType.PRINT_CANCELLED_FOOD_DETAIL) {
            if (detail) {
              printFunc.setType(PType.PRINT_ORDER_DETAIL);
              roots.add(printFunc);
              detail = false;
            }
          }
        } else {
          roots.add(printFunc);
        }
      }

      jobject.setTotalProperty(roots.size());
      jobject.setRoot(roots);

    } catch (BusinessException e) {
      jobject.initTip(e);
      e.printStackTrace();

    } catch (Exception e) {
      jobject.initTip4Exception(e);
      e.printStackTrace();
    } finally {

      response.getWriter().print(jobject.toString());
    }
    return null;
  }
  public ActionForward execute(
      ActionMapping mapping,
      ActionForm form,
      HttpServletRequest request,
      HttpServletResponse response)
      throws Exception {
    JObject jobject = new JObject();
    SystemSetting set = null;
    try {

      String pin = (String) request.getAttribute("pin");
      StaffDao.verify(Integer.parseInt(pin));

      String restaurantID = (String) request.getAttribute("restaurantID");
      String priceTail = request.getParameter("priceTail");
      String eraseQuota = request.getParameter("eraseQuota");

      if (restaurantID == null || restaurantID.trim().isEmpty()) {
        jobject.initTip(false, "操作失败, 获取餐厅信息失败.");
        return null;
      }

      if (priceTail == null || priceTail.trim().isEmpty()) {
        jobject.initTip(false, "操作失败, 获取收款金额尾数处理方式失败.");
        return null;
      }
      if (eraseQuota == null || eraseQuota.trim().isEmpty()) {
        jobject.initTip(false, "操作失败, 获取抹数金额上限失败.");
        return null;
      }

      set = new SystemSetting();
      set.getSetting().setPriceTail(Integer.parseInt(priceTail));
      set.getSetting().setEraseQuota(Integer.parseInt(eraseQuota));
      set.setRestaurantID(Integer.parseInt(restaurantID));

      SystemDao.updatePriceTail(set);
      jobject.initTip(true, "操作成功, 已修改收款设置.");

    } catch (BusinessException e) {
      e.printStackTrace();
      jobject.initTip(e);

    } catch (Exception e) {
      e.printStackTrace();
      jobject.initTip4Exception(e);
    } finally {
      response.getWriter().print(jobject.toString());
    }

    return null;
  }