public Properties get3rdPartBillPropInactive(String invNo) {
   Properties retval = new Properties();
   List<BillingONExt> billingExts = extDao.getInactiveBillingExtItems(invNo);
   for (BillingONExt b : billingExts) {
     retval.setProperty(b.getKeyVal(), b.getValue());
   }
   return retval;
 }
 public Properties get3rdPartBillProp(String invNo) {
   Properties retval = new Properties();
   List<BillingONExt> billingExts = extDao.getBillingExtItems(invNo);
   for (BillingONExt b : billingExts) {
     retval.setProperty(
         StringUtils.trimToEmpty(b.getKeyVal()), StringUtils.trimToEmpty(b.getValue()));
   }
   return retval;
 }
 public boolean updateKeyStatus(String billingNo, String key, String status) {
   List<BillingONExt> results =
       extDao.findByBillingNoAndKey(Integer.parseInt(billingNo), StringEscapeUtils.escapeSql(key));
   for (BillingONExt result : results) {
     result.setStatus(status.toCharArray()[0]);
     extDao.merge(result);
   }
   return true;
 }
 /*
  * We're updating a key--make sure it is active as well
  */
 public boolean updateKeyValue(String billingNo, String key, String value) {
   List<BillingONExt> results =
       extDao.findByBillingNoAndKey(Integer.parseInt(billingNo), StringEscapeUtils.escapeSql(key));
   for (BillingONExt result : results) {
     result.setValue(StringEscapeUtils.escapeSql(value));
     result.setStatus('1');
     extDao.merge(result);
   }
   return true;
 }
  public boolean add3rdBillExt(String billingNo, String demoNo, String key, String value) {
    BillingONExt b = new BillingONExt();
    b.setBillingNo(Integer.parseInt(billingNo));
    b.setDemographicNo(Integer.parseInt(demoNo));
    b.setKeyVal(StringEscapeUtils.escapeSql(key));
    b.setDateTime(new Date());
    b.setStatus(ACTIVE.toCharArray()[0]);

    if (value == null && BillingONExtDao.isNumberKey(key)) {
      value = "0.00";
    }
    b.setValue(StringEscapeUtils.escapeSql(value));

    extDao.persist(b);

    return true;
  }
  public boolean add3rdBillExt(Map<String, String> mVal, int id) {
    boolean retval = true;
    String[] temp = {
      "billTo",
      "remitTo",
      "total",
      "payment",
      "refund",
      "provider_no",
      "gst",
      "payDate",
      "payMethod"
    };
    String demoNo = mVal.get("demographic_no");
    String dateTime = UtilDateUtilities.getToday("yyyy-MM-dd HH:mm:ss");
    mVal.put("payDate", dateTime);

    BillingONPaymentDao billingONPaymentDao = SpringUtils.getBean(BillingONPaymentDao.class);
    BillingONPayment newPayment = new BillingONPayment();
    BillingONCHeader1 ch1 = cheaderDao.find(id);
    newPayment.setBillingOnCheader1(ch1);
    newPayment.setPaymentDate(UtilDateUtilities.StringToDate(dateTime));

    for (int i = 0; i < temp.length; i++) {
      BillingONExt b = new BillingONExt();
      b.setBillingNo(id);
      b.setDemographicNo(Integer.valueOf(demoNo));
      b.setKeyVal(temp[i]);
      b.setValue(mVal.get(temp[i]));
      b.setDateTime(new Date());
      b.setStatus('1');
      b.setPaymentId(0);
      newPayment.getBillingONExtItems().add(b);
    }

    billingONPaymentDao.persist(newPayment);

    return retval;
  }
  @SuppressWarnings("unchecked")
  public boolean add3rdBillExt(Map<String, String> mVal, int id, Vector vecObj) {
    BillingClaimHeader1Data claim1Obj = (BillingClaimHeader1Data) vecObj.get(0);
    boolean retval = true;
    String[] temp = {
      "billTo",
      "remitTo",
      "total",
      "payment",
      "discount",
      "provider_no",
      "gst",
      "payDate",
      "payMethod"
    };
    String demoNo = mVal.get("demographic_no");
    String dateTime = UtilDateUtilities.getToday("yyyy-MM-dd HH:mm:ss");
    mVal.put("payDate", dateTime);
    String paymentSumParam = null;
    String paymentDateParam = null;
    String paymentTypeParam = null;
    String provider_no = mVal.get("provider_no");
    for (int i = 0; i < temp.length; i++) {
      String val = mVal.get(temp[i]);
      if ("discount".equals(temp[i])) {
        val =
            mVal.get(
                "total_discount"); // 'refund' stands for write off, here totoal_discount is write
                                   // off
      }
      if ("payment".equals(temp[i])) {
        val = mVal.get("total_payment");
      }
      BillingONExt billingONExt = new BillingONExt();
      billingONExt.setBillingNo(id);
      billingONExt.setDemographicNo(Integer.parseInt(demoNo));
      billingONExt.setKeyVal(StringEscapeUtils.escapeSql(temp[i]));
      billingONExt.setValue(StringEscapeUtils.escapeSql(val));
      billingONExt.setDateTime(new Date());
      billingONExt.setStatus('1');
      extDao.persist(billingONExt);

      if (i == 3) paymentSumParam = mVal.get("total_payment"); // total_payment
      else if (i == 7) paymentDateParam = mVal.get(temp[i]); // paymentDate
      else if (i == 8) paymentTypeParam = mVal.get(temp[i]); // paymentMethod
    }

    if (paymentSumParam != null) {
      BillingONPaymentDao billingONPaymentDao =
          (BillingONPaymentDao) SpringUtils.getBean("billingONPaymentDao");
      BillingPaymentTypeDao billingPaymentTypeDao =
          (BillingPaymentTypeDao) SpringUtils.getBean("billingPaymentTypeDao");
      BillingONCHeader1 ch1 = cheaderDao.find(id);
      Date paymentDate = null;
      try {
        paymentDate = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(paymentDateParam);
      } catch (ParseException ex) {
        _logger.error("add3rdBillExt wrong date format " + paymentDateParam);
        return retval;
      }

      // allow user to override with the text box added
      String paymentDateOverride = mVal.get("payment_date");
      if (paymentDateOverride != null && paymentDateOverride.length() > 0) {
        try {
          paymentDate =
              new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(paymentDateOverride + " 00:00:00");
        } catch (ParseException ex) {
          _logger.error("add3rdBillExt wrong date format " + paymentDateOverride);
          return retval;
        }
      }

      if (paymentTypeParam == null || paymentTypeParam.equals("")) {
        paymentTypeParam = "1";
      }
      BillingPaymentType type = billingPaymentTypeDao.find(Integer.parseInt(paymentTypeParam));
      BillingONPayment payment = null;

      if (paymentSumParam != null) {
        payment = new BillingONPayment();
        payment.setTotal_payment(BigDecimal.valueOf(Double.parseDouble(paymentSumParam)));
        payment.setTotal_discount(
            BigDecimal.valueOf(Double.parseDouble(mVal.get("total_discount"))));
        payment.setTotal_refund(new BigDecimal(0));
        payment.setPaymentDate(paymentDate);
        payment.setBillingOnCheader1(ch1);
        payment.setBillingNo(id);
        payment.setCreator(claim1Obj.getCreator());
        payment.setPaymentTypeId(Integer.parseInt(paymentTypeParam));

        // payment.setBillingPaymentType(type);
        billingONPaymentDao.persist(payment);
        addItemPaymentRecord(
            (List) vecObj.get(1),
            id,
            payment.getId(),
            Integer.parseInt(paymentTypeParam),
            paymentDate);
        addCreate3rdInvoiceTrans(
            (BillingClaimHeader1Data) vecObj.get(0),
            (List<BillingItemData>) vecObj.get(1),
            payment);
      }
    }
    return retval;
  }