public CurrencyBL() {
currencyDas = new CurrencyDAS();
exchangeDas = new CurrencyExchangeDAS();
cache = (CacheProviderFacade) Context.getBean(Context.Name.CACHE);
cacheModel = (CachingModel) Context.getBean(Context.Name.CURRENCY_CACHE_MODEL);
flushModel = (FlushingModel) Context.getBean(Context.Name.CURRENCY_FLUSH_MODEL);
}
protected void execute() throws SQLException {
// the connection will be closed by the RowSet as soon as it
// finished executing the command
conn = ((DataSource) Context.getBean(Context.Name.DATA_SOURCE)).getConnection();
cachedResults.execute(conn);
}
protected boolean sendAgeingNotification(
UserDTO user, UserStatusDTO oldStatus, UserStatusDTO newStatus) {
try {
MessageDTO message =
new NotificationBL()
.getAgeingMessage(
user.getEntity().getId(),
user.getLanguage().getId(),
newStatus.getId(),
user.getId());
INotificationSessionBean notification =
(INotificationSessionBean) Context.getBean(Context.Name.NOTIFICATION_SESSION);
notification.notify(user, message);
} catch (NotificationNotFoundException e) {
LOG.warn(
"Failed to send ageing notification. Entity "
+ user.getEntity().getId()
+ " does not have an ageing message configured for status '"
+ getStatusDescription(newStatus)
+ "'.");
return false;
}
return true;
}
/**
* Tries to get paid the invoice of the parameter. The processs Id and runId are only to update
* the run totals. Only one of them is required. The runId should be passed if this is a retry,
* otherwise the processId.
*
* @param processId
* @param runId
* @param invoiceId
* @throws SessionInternalError
*/
public void generatePayment(Integer processId, Integer runId, Integer invoiceId)
throws SessionInternalError {
try {
InvoiceBL invoiceBL = new InvoiceBL(invoiceId);
InvoiceDTO newInvoice = invoiceBL.getEntity();
IPaymentSessionBean paymentSess =
(IPaymentSessionBean) Context.getBean(Context.Name.PAYMENT_SESSION);
paymentSess.generatePayment(newInvoice);
} catch (Exception e) {
throw new SessionInternalError(e);
}
}
/**
* Returns the caller UserDTO. If the caller is not set, the default for unauthenticated calls is
* returned instead.
*/
public static UserDTO get() {
if (caller.get() == null) {
// no caller set, try to get default username and password
Defaults defaults = (Defaults) Context.getBean(Context.Name.WEB_SERVICES_CALLER_DEFAULTS);
if (defaults.getUsername() != null && defaults.getPassword() != null) {
IUserSessionBean userSession =
(IUserSessionBean) Context.getBean(Context.Name.USER_SESSION);
UserDTO user =
userSession.webServicesAuthenticate(defaults.getUsername(), defaults.getPassword());
if (user != null) {
LOG.info("Using default username and password for " + "unauthenticated API call/s.");
set(user);
} else {
throw new SecurityException("Invalid default " + "username/password");
}
} else {
throw new SecurityException("No caller set.");
}
}
return caller.get();
}
public void onMessage(Message message) {
try {
LOG.debug("Received a message");
// use a session bean to make sure the processing is done in
// a transaction
IProvisioningProcessSessionBean provisioning =
(IProvisioningProcessSessionBean)
Context.getBean(Context.Name.PROVISIONING_PROCESS_SESSION);
provisioning.externalProvisioning(message);
} catch (Exception e) {
throw new SessionInternalError(e);
}
}
/**
* Gets BillingProcessSessionBean bean from context
*
* @return : BillingProcessSessionBean
*/
private IBillingProcessSessionBean getProcessBean() {
return Context.getBean(Context.Name.BILLING_PROCESS_SESSION);
}
public BatchContextHandler() {
jobExplorer = ((JobExplorer) Context.getBean(Context.Name.BATCH_JOB_EXPLORER));
}
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException {
Logger log = Logger.getLogger(MaintainAction.class);
String forward = null;
ActionForward retValue = null;
try {
IPaymentSessionBean myRemoteSession =
(IPaymentSessionBean) Context.getBean(Context.Name.PAYMENT_SESSION);
/*
* Because of the review step, the payment has some actions that
* so far makes no sense to dump them in the generic action
*/
String action = request.getParameter("action");
HttpSession session = request.getSession(false);
ActionMessages messages = new ActionMessages();
String key;
key = session.getAttribute("jsp_is_refund") == null ? "payment." : "refund.";
// get the payment/refund information
String sessionKey;
if (key.equals("payment.")) {
sessionKey = Constants.SESSION_PAYMENT_DTO;
} else {
sessionKey = Constants.SESSION_PAYMENT_DTO_REFUND;
}
if (action.equals("send")) {
PaymentDTOEx paymentDto = (PaymentDTOEx) session.getAttribute(sessionKey);
if (paymentDto == null) {
log.error("dto can't be null when sending");
throw new ServletException("paymentDTO is null");
}
// get the invoice, it might not be there
Integer invoiceId = null;
InvoiceDTO invoice = (InvoiceDTO) session.getAttribute(Constants.SESSION_INVOICE_DTO);
if (invoice != null) {
invoiceId = invoice.getId();
}
boolean isPayout = false;
PartnerPayout payout = null;
Partner partner = null;
if (request.getParameter("payout") != null
&& request.getParameter("payout").equals("yes")) {
isPayout = true;
payout = (PartnerPayout) session.getAttribute(Constants.SESSION_PAYOUT_DTO);
partner = (Partner) session.getAttribute(Constants.SESSION_PARTNER_DTO);
}
if (((Boolean) session.getAttribute("tmp_process_now")).booleanValue()) {
Integer result;
if (!isPayout) {
result =
myRemoteSession.processAndUpdateInvoice(
paymentDto,
invoiceId,
(Integer) session.getAttribute(Constants.SESSION_ENTITY_ID_KEY));
} else {
result =
myRemoteSession.processPayout(
paymentDto,
payout.getStartingDate(),
payout.getEndingDate(),
partner.getId(),
new Boolean(true));
payout.setPayment(new PaymentDTO(paymentDto));
}
if (result == null) {
key = key + "no_result";
} else if (result.equals(Constants.RESULT_OK)) {
key = key + "result.approved";
} else if (result.equals(Constants.RESULT_FAIL)) {
key = key + "result.rejected";
} else if (result.equals(Constants.RESULT_UNAVAILABLE)) {
key = key + "result.unavailable";
} else {
key = "all.internal";
log.error("Unsupported result from server:" + result);
}
} else {
if (!isPayout) {
log.debug(
"sending payment. Id = "
+ paymentDto.getId()
+ " refund "
+ paymentDto.getIsRefund());
if (paymentDto.getId() != 0 && paymentDto.getIsRefund() == 0) {
// it is an update
myRemoteSession.update(
(Integer) session.getAttribute(Constants.SESSION_LOGGED_USER_ID), paymentDto);
} else {
// it is a new payment
paymentDto.setId(myRemoteSession.applyPayment(paymentDto, invoiceId));
// I need to update the DTO, so the left bar can
// make the right decitions
if (invoiceId != null) {
List<Integer> invoices = new ArrayList<Integer>();
invoices.add(invoiceId);
paymentDto.setInvoiceIds(invoices);
}
}
} else {
myRemoteSession.processPayout(
paymentDto,
payout.getStartingDate(),
payout.getEndingDate(),
partner.getId(),
new Boolean(false));
}
key = key + "enter.success";
}
messages.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage(key));
if (!isPayout) {
// the dto has to be refreshed, otherwise the
// map to the invoice won't be there
session.setAttribute(
Constants.SESSION_PAYMENT_DTO,
myRemoteSession.getPayment(
paymentDto.getId(), (Integer) session.getAttribute(Constants.SESSION_LANGUAGE)));
forward = "payment_view";
} else {
forward = "payout_view";
}
} else if (action.equals("last_invoice")) {
forward = "no_invoice";
// make sure the logged user shows up as the user for the payment
session.setAttribute(
Constants.SESSION_USER_ID, session.getAttribute(Constants.SESSION_LOGGED_USER_ID));
// now find out which is the latest invoice and make it available
UserDTOEx user = (UserDTOEx) session.getAttribute(Constants.SESSION_USER_DTO);
Integer invoiceId = user.getLastInvoiceId();
if (invoiceId != null) {
IInvoiceSessionBean invoiceSession =
(IInvoiceSessionBean) Context.getBean(Context.Name.INVOICE_SESSION);
InvoiceDTO invoice = invoiceSession.getInvoice(invoiceId);
if (invoice.getToProcess().intValue() == 1) {
session.setAttribute(Constants.SESSION_INVOICE_DTO, invoice);
// this will chain the action, but it's effective
forward = "last_invoice";
}
}
if (forward.equals("no_invoice")) {
messages.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage("payment.error.noInvoice"));
}
} else if (action.equals("current_invoice")) {
session.setAttribute(
Constants.SESSION_USER_ID, session.getAttribute(Constants.SESSION_LOGGED_USER_ID));
// the invoice dto is already in the sesssion .. piece of cake
forward = "last_invoice";
} else if (action.equals("cancel")) {
session.removeAttribute(sessionKey);
messages.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage("payment.enter.cancel"));
forward = "payment_list";
} else if (action.equals("view")) {
// this is called when a payment is selected from the list
// for a read-only view
Integer paymentId;
if (request.getParameter("id") != null) {
// this is being called from anywhere, to check out a payment
paymentId = Integer.valueOf(request.getParameter("id"));
} else {
// this is called from the list of payments
paymentId = (Integer) session.getAttribute(Constants.SESSION_LIST_ID_SELECTED);
}
Integer languageId = (Integer) session.getAttribute(Constants.SESSION_LANGUAGE);
PaymentDTOEx dto = myRemoteSession.getPayment(paymentId, languageId);
log.debug("my dto is " + dto);
if (dto.getIsRefund() == 1) {
session.setAttribute(Constants.SESSION_PAYMENT_DTO_REFUND, dto);
if (dto.getPayment() != null) {
session.setAttribute(
Constants.SESSION_PAYMENT_DTO,
myRemoteSession.getPayment(dto.getPayment().getId(), languageId));
} else {
session.removeAttribute(Constants.SESSION_PAYMENT_DTO);
}
} else {
session.setAttribute(Constants.SESSION_PAYMENT_DTO, dto);
}
// now include the invoice and customer dto of this payment
try {
// now the user
session.setAttribute(Constants.SESSION_USER_ID, dto.getUserId());
ICustomerSessionBean userSession =
(ICustomerSessionBean) Context.getBean(Context.Name.CUSTOMER_SESSION);
session.setAttribute(
Constants.SESSION_CUSTOMER_CONTACT_DTO,
userSession.getPrimaryContactDTO(dto.getUserId()));
} catch (Exception e) {
throw new SessionInternalError(e);
}
forward = "payment_view";
} else if (action.equals("notify")) {
INotificationSessionBean notificationSession =
(INotificationSessionBean) Context.getBean(Context.Name.NOTIFICATION_SESSION);
Integer paymentId = Integer.valueOf(request.getParameter("id"));
Boolean result = notificationSession.emailPayment(paymentId);
String field;
if (result.booleanValue()) {
field = "email.notify.ok";
} else {
field = "email.notify.error";
}
messages.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage(field));
forward = "payment_view";
} else if (action.equals("unlink")) {
Integer mapId = Integer.valueOf(request.getParameter("mapId"));
myRemoteSession.removeInvoiceLink(mapId);
messages.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage("payment.link.removalDone"));
// make sure the payment now shows up updated
session.setAttribute(
Constants.SESSION_LIST_ID_SELECTED,
((PaymentDTO) session.getAttribute(Constants.SESSION_PAYMENT_DTO)).getId());
session.removeAttribute(Constants.SESSION_PAYMENT_DTO);
forward = "payment_setupView";
} else if (action.equals("apply")) {
// call the server to apply tha payment
myRemoteSession.applyPayment(
((PaymentDTO) session.getAttribute(Constants.SESSION_PAYMENT_DTO)).getId(),
((InvoiceDTO) session.getAttribute(Constants.SESSION_INVOICE_DTO)).getId());
// show a 'done' message
messages.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage("payment.link.applyDone"));
// redirect to payment view, with the refreshed payment record
session.setAttribute(
Constants.SESSION_LIST_ID_SELECTED,
((PaymentDTO) session.getAttribute(Constants.SESSION_PAYMENT_DTO)).getId());
session.removeAttribute(Constants.SESSION_PAYMENT_DTO);
forward = "payment_setupView";
} else {
PaymentCrudAction delegate = new PaymentCrudAction(myRemoteSession);
delegate.setServlet(getServlet());
retValue = delegate.execute(mapping, form, request, response);
}
saveMessages(request, messages);
} catch (Exception e) {
log.error("Exception ", e);
retValue = mapping.findForward("error");
forward = null;
}
if (forward != null) {
retValue = mapping.findForward(forward);
}
return retValue;
}
public void sendReminders(Date today) throws SQLException, SessionInternalError {
GregorianCalendar cal = new GregorianCalendar();
for (Iterator it = new CompanyDAS().findEntities().iterator(); it.hasNext(); ) {
CompanyDTO thisEntity = (CompanyDTO) it.next();
Integer entityId = thisEntity.getId();
PreferenceBL pref = new PreferenceBL();
try {
pref.set(entityId, Constants.PREFERENCE_USE_INVOICE_REMINDERS);
} catch (EmptyResultDataAccessException e1) {
// let it use the defaults
}
if (pref.getInt() == 1) {
prepareStatement(InvoiceSQL.toRemind);
cachedResults.setDate(1, new java.sql.Date(today.getTime()));
cal.setTime(today);
pref.set(entityId, Constants.PREFERENCE_FIRST_REMINDER);
cal.add(GregorianCalendar.DAY_OF_MONTH, -pref.getInt());
cachedResults.setDate(2, new java.sql.Date(cal.getTimeInMillis()));
cal.setTime(today);
pref.set(entityId, Constants.PREFERENCE_NEXT_REMINDER);
cal.add(GregorianCalendar.DAY_OF_MONTH, -pref.getInt());
cachedResults.setDate(3, new java.sql.Date(cal.getTimeInMillis()));
cachedResults.setInt(4, entityId.intValue());
execute();
while (cachedResults.next()) {
int invoiceId = cachedResults.getInt(1);
set(Integer.valueOf(invoiceId));
NotificationBL notif = new NotificationBL();
long mils = invoice.getDueDate().getTime() - today.getTime();
int days = Math.round(mils / 1000 / 60 / 60 / 24);
try {
MessageDTO message =
notif.getInvoiceReminderMessage(
entityId,
invoice.getBaseUser().getUserId(),
Integer.valueOf(days),
invoice.getDueDate(),
invoice.getPublicNumber(),
invoice.getTotal(),
invoice.getCreateDatetime(),
invoice.getCurrency().getId());
INotificationSessionBean notificationSess =
(INotificationSessionBean) Context.getBean(Context.Name.NOTIFICATION_SESSION);
notificationSess.notify(invoice.getBaseUser(), message);
invoice.setLastReminder(today);
} catch (NotificationNotFoundException e) {
LOG.warn(
"There are invoice to send reminders, but "
+ "the notification message is missing for "
+ "entity "
+ entityId);
}
}
}
}
if (conn != null) { // only if somthing run
conn.close();
}
}
/**
* This method is called when this bean is initialized to get BillingProcessSessionBean bean from
* context.
*/
@Override
public void afterPropertiesSet() throws Exception {
local = (IBillingProcessSessionBean) Context.getBean(Context.Name.BILLING_PROCESS_SESSION);
}
