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;
}