Module com.aoindustries.aoserv.master

Package com.aoindustries.aoserv.master

Class PaymentHandler

java.lang.Object

com.aoindustries.aoserv.master.PaymentHandler

public final class PaymentHandler
extends Object

The PaymentHandler handles all the accesses to the payment.CreditCard table.

TODO: Deactivate immediately on expired card TODO: Retry failed cards on the 7th and 14th, then deactivate? See newly documented account billing policy.

Author:

AO Industries, Inc.

Method Summary

Modifier and Type	Method	Description
static int	addCreditCard(DatabaseConnection conn, RequestSource source, InvalidateList invalidateList, String processor, Account.Name account, String groupName, String cardInfo, Byte expirationMonth, Short expirationYear, String providerUniqueId, String firstName, String lastName, String companyName, String email, String phone, String fax, String customerId, String customerTaxId, String streetAddress1, String streetAddress2, String city, String state, String postalCode, String countryCode, String principalName, String description, String encryptedCardNumber, int encryptionFrom, int encryptionRecipient)	Creates a new CreditCard.
static int	addPayment(DatabaseConnection conn, InvalidateList invalidateList, String processor, Account.Name account, String groupName, boolean testMode, int duplicateWindow, String orderNumber, Money amount, Money taxAmount, boolean taxExempt, Money shippingAmount, Money dutyAmount, String shippingFirstName, String shippingLastName, String shippingCompanyName, String shippingStreetAddress1, String shippingStreetAddress2, String shippingCity, String shippingState, String shippingPostalCode, String shippingCountryCode, boolean emailCustomer, String merchantEmail, String invoiceNumber, String purchaseOrderNumber, String description, User.Name creditCard_createdBy, String creditCard_principalName, Account.Name creditCard_accounting, String creditCard_groupName, String creditCard_providerUniqueId, String creditCard_maskedCardNumber, Byte creditCard_expirationMonth, Short creditCard_expirationYear, String creditCard_firstName, String creditCard_lastName, String creditCard_companyName, String creditCard_email, String creditCard_phone, String creditCard_fax, String creditCard_customerId, String creditCard_customerTaxId, String creditCard_streetAddress1, String creditCard_streetAddress2, String creditCard_city, String creditCard_state, String creditCard_postalCode, String creditCard_countryCode, String creditCard_comments, long authorizationTime, User.Name authorizationUsername, String authorizationPrincipalName)	Creates a new Payment.
static int	addPayment(DatabaseConnection conn, RequestSource source, InvalidateList invalidateList, String processor, Account.Name account, String groupName, boolean testMode, int duplicateWindow, String orderNumber, Money amount, Money taxAmount, boolean taxExempt, Money shippingAmount, Money dutyAmount, String shippingFirstName, String shippingLastName, String shippingCompanyName, String shippingStreetAddress1, String shippingStreetAddress2, String shippingCity, String shippingState, String shippingPostalCode, String shippingCountryCode, boolean emailCustomer, String merchantEmail, String invoiceNumber, String purchaseOrderNumber, String description, User.Name creditCard_createdBy, String creditCard_principalName, Account.Name creditCard_accounting, String creditCard_groupName, String creditCard_providerUniqueId, String creditCard_maskedCardNumber, Byte creditCard_expirationMonth, Short creditCard_expirationYear, String creditCard_firstName, String creditCard_lastName, String creditCard_companyName, String creditCard_email, String creditCard_phone, String creditCard_fax, String creditCard_customerId, String creditCard_customerTaxId, String creditCard_streetAddress1, String creditCard_streetAddress2, String creditCard_city, String creditCard_state, String creditCard_postalCode, String creditCard_countryCode, String creditCard_comments, long authorizationTime, String authorizationPrincipalName)	Creates a new Payment.
static void	checkAccessCreditCard(DatabaseConnection conn, RequestSource source, String action, int creditCard)
static void	checkAccessEncryptionKey(DatabaseConnection conn, RequestSource source, String action, int encryptionKey)
static void	checkAccessPayment(DatabaseConnection conn, RequestSource source, String action, int payment)
static void	checkAccessProcessor(DatabaseConnection conn, RequestSource source, String action, String processor)
static void	creditCardDeclined(DatabaseConnection conn, RequestSource source, InvalidateList invalidateList, int creditCard, String reason)
static Account.Name	getAccountForCreditCard(DatabaseConnection conn, int creditCard)
static Account.Name	getAccountForEncryptionKey(DatabaseConnection conn, int encryptionKey)
static Account.Name	getAccountForProcessor(DatabaseConnection conn, String processor)
static String	getProcessorForPayment(DatabaseConnection conn, int payment)
static void	main(String[] args)
static void	paymentAuthorizeCompleted(DatabaseConnection conn, InvalidateList invalidateList, int payment, String authorizationCommunicationResult, String authorizationProviderErrorCode, String authorizationErrorCode, String authorizationProviderErrorMessage, String authorizationProviderUniqueId, String authorizationResult_providerReplacementMaskedCardNumber, String authorizationResult_replacementMaskedCardNumber, String authorizationResult_providerReplacementExpiration, Byte authorizationResult_replacementExpirationMonth, Short authorizationResult_replacementExpirationYear, String providerApprovalResult, String approvalResult, String providerDeclineReason, String declineReason, String providerReviewReason, String reviewReason, String providerCvvResult, String cvvResult, String providerAvsResult, String avsResult, String approvalCode, String status)
static void	paymentAuthorizeCompleted(DatabaseConnection conn, RequestSource source, InvalidateList invalidateList, int payment, String authorizationCommunicationResult, String authorizationProviderErrorCode, String authorizationErrorCode, String authorizationProviderErrorMessage, String authorizationProviderUniqueId, String authorizationResult_providerReplacementMaskedCardNumber, String authorizationResult_replacementMaskedCardNumber, String authorizationResult_providerReplacementExpiration, Byte authorizationResult_replacementExpirationMonth, Short authorizationResult_replacementExpirationYear, String providerApprovalResult, String approvalResult, String providerDeclineReason, String declineReason, String providerReviewReason, String reviewReason, String providerCvvResult, String cvvResult, String providerAvsResult, String avsResult, String approvalCode, String status)
static void	paymentSaleCompleted(DatabaseConnection conn, InvalidateList invalidateList, int payment, String authorizationCommunicationResult, String authorizationProviderErrorCode, String authorizationErrorCode, String authorizationProviderErrorMessage, String authorizationProviderUniqueId, String authorizationResult_providerReplacementMaskedCardNumber, String authorizationResult_replacementMaskedCardNumber, String authorizationResult_providerReplacementExpiration, Byte authorizationResult_replacementExpirationMonth, Short authorizationResult_replacementExpirationYear, String providerApprovalResult, String approvalResult, String providerDeclineReason, String declineReason, String providerReviewReason, String reviewReason, String providerCvvResult, String cvvResult, String providerAvsResult, String avsResult, String approvalCode, Timestamp captureTime, User.Name captureUsername, String capturePrincipalName, String captureCommunicationResult, String captureProviderErrorCode, String captureErrorCode, String captureProviderErrorMessage, String captureProviderUniqueId, String status)
static void	paymentSaleCompleted(DatabaseConnection conn, RequestSource source, InvalidateList invalidateList, int payment, String authorizationCommunicationResult, String authorizationProviderErrorCode, String authorizationErrorCode, String authorizationProviderErrorMessage, String authorizationProviderUniqueId, String authorizationResult_providerReplacementMaskedCardNumber, String authorizationResult_replacementMaskedCardNumber, String authorizationResult_providerReplacementExpiration, Byte authorizationResult_replacementExpirationMonth, Short authorizationResult_replacementExpirationYear, String providerApprovalResult, String approvalResult, String providerDeclineReason, String declineReason, String providerReviewReason, String reviewReason, String providerCvvResult, String cvvResult, String providerAvsResult, String avsResult, String approvalCode, Timestamp captureTime, String capturePrincipalName, String captureCommunicationResult, String captureProviderErrorCode, String captureErrorCode, String captureProviderErrorMessage, String captureProviderUniqueId, String status)
static void	reactivateCreditCard(DatabaseConnection conn, RequestSource source, InvalidateList invalidateList, int creditCard)
static void	removeCreditCard(DatabaseConnection conn, InvalidateList invalidateList, int creditCard)
static void	removeCreditCard(DatabaseConnection conn, RequestSource source, InvalidateList invalidateList, int creditCard)
static void	setCreditCardUseMonthly(DatabaseConnection conn, RequestSource source, InvalidateList invalidateList, Account.Name account, int creditCard)
static void	start()
static void	updateCreditCard(DatabaseConnection conn, InvalidateList invalidateList, int creditCard, String cardInfo, String firstName, String lastName, String companyName, String email, String phone, String fax, String customerId, String customerTaxId, String streetAddress1, String streetAddress2, String city, String state, String postalCode, String countryCode, String description)
static void	updateCreditCard(DatabaseConnection conn, RequestSource source, InvalidateList invalidateList, int creditCard, String cardInfo, String firstName, String lastName, String companyName, String email, String phone, String fax, String customerId, String customerTaxId, String streetAddress1, String streetAddress2, String city, String state, String postalCode, String countryCode, String description)
static void	updateCreditCardExpiration(DatabaseConnection conn, InvalidateList invalidateList, int creditCard, Byte expirationMonth, Short expirationYear)
static void	updateCreditCardExpiration(DatabaseConnection conn, RequestSource source, InvalidateList invalidateList, int creditCard, Byte expirationMonth, Short expirationYear)
static void	updateCreditCardNumberAndExpiration(DatabaseConnection conn, RequestSource source, InvalidateList invalidateList, int creditCard, String maskedCardNumber, Byte expirationMonth, Short expirationYear, String encryptedCardNumber, int encryptionFrom, int encryptionRecipient)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details

start

public static void start()

checkAccessCreditCard

public static void checkAccessCreditCard(DatabaseConnection conn,
 RequestSource source,
 String action,
 int creditCard)
                                  throws IOException,
SQLException

Throws:

IOException

SQLException

checkAccessProcessor

public static void checkAccessProcessor(DatabaseConnection conn,
 RequestSource source,
 String action,
 String processor)
                                 throws IOException,
SQLException

Throws:

IOException

SQLException

checkAccessPayment

public static void checkAccessPayment(DatabaseConnection conn,
 RequestSource source,
 String action,
 int payment)
                               throws IOException,
SQLException

Throws:

IOException

SQLException

checkAccessEncryptionKey

public static void checkAccessEncryptionKey(DatabaseConnection conn,
 RequestSource source,
 String action,
 int encryptionKey)
                                     throws IOException,
SQLException

Throws:

IOException

SQLException

addCreditCard

public static int addCreditCard(DatabaseConnection conn,
 RequestSource source,
 InvalidateList invalidateList,
 String processor,
 Account.Name account,
 String groupName,
 String cardInfo,
 Byte expirationMonth,
 Short expirationYear,
 String providerUniqueId,
 String firstName,
 String lastName,
 String companyName,
 String email,
 String phone,
 String fax,
 String customerId,
 String customerTaxId,
 String streetAddress1,
 String streetAddress2,
 String city,
 String state,
 String postalCode,
 String countryCode,
 String principalName,
 String description,
 String encryptedCardNumber,
 int encryptionFrom,
 int encryptionRecipient)
                         throws IOException,
SQLException

Creates a new CreditCard.

Throws:

IOException

SQLException

creditCardDeclined

public static void creditCardDeclined(DatabaseConnection conn,
 RequestSource source,
 InvalidateList invalidateList,
 int creditCard,
 String reason)
                               throws IOException,
SQLException

Throws:

IOException

SQLException

getAccountForCreditCard

public static Account.Name getAccountForCreditCard(DatabaseConnection conn,
 int creditCard)
                                            throws IOException,
SQLException

Throws:

IOException

SQLException

getAccountForProcessor

public static Account.Name getAccountForProcessor(DatabaseConnection conn,
 String processor)
                                           throws IOException,
SQLException

Throws:

IOException

SQLException

getProcessorForPayment

public static String getProcessorForPayment(DatabaseConnection conn,
 int payment)
                                     throws IOException,
SQLException

Throws:

IOException

SQLException

getAccountForEncryptionKey

public static Account.Name getAccountForEncryptionKey(DatabaseConnection conn,
 int encryptionKey)
                                               throws IOException,
SQLException

Throws:

IOException

SQLException

removeCreditCard

public static void removeCreditCard(DatabaseConnection conn,
 RequestSource source,
 InvalidateList invalidateList,
 int creditCard)
                             throws IOException,
SQLException

Throws:

IOException

SQLException

removeCreditCard

public static void removeCreditCard(DatabaseConnection conn,
 InvalidateList invalidateList,
 int creditCard)
                             throws IOException,
SQLException

Throws:

IOException

SQLException

updateCreditCard

public static void updateCreditCard(DatabaseConnection conn,
 RequestSource source,
 InvalidateList invalidateList,
 int creditCard,
 String cardInfo,
 String firstName,
 String lastName,
 String companyName,
 String email,
 String phone,
 String fax,
 String customerId,
 String customerTaxId,
 String streetAddress1,
 String streetAddress2,
 String city,
 String state,
 String postalCode,
 String countryCode,
 String description)
                             throws IOException,
SQLException

Throws:

IOException

SQLException

updateCreditCard

public static void updateCreditCard(DatabaseConnection conn,
 InvalidateList invalidateList,
 int creditCard,
 String cardInfo,
 String firstName,
 String lastName,
 String companyName,
 String email,
 String phone,
 String fax,
 String customerId,
 String customerTaxId,
 String streetAddress1,
 String streetAddress2,
 String city,
 String state,
 String postalCode,
 String countryCode,
 String description)
                             throws IOException,
SQLException

Throws:

IOException

SQLException

updateCreditCardNumberAndExpiration

public static void updateCreditCardNumberAndExpiration(DatabaseConnection conn,
 RequestSource source,
 InvalidateList invalidateList,
 int creditCard,
 String maskedCardNumber,
 Byte expirationMonth,
 Short expirationYear,
 String encryptedCardNumber,
 int encryptionFrom,
 int encryptionRecipient)
                                                throws IOException,
SQLException

Throws:

IOException

SQLException

updateCreditCardExpiration

public static void updateCreditCardExpiration(DatabaseConnection conn,
 RequestSource source,
 InvalidateList invalidateList,
 int creditCard,
 Byte expirationMonth,
 Short expirationYear)
                                       throws IOException,
SQLException

Throws:

IOException

SQLException

updateCreditCardExpiration

public static void updateCreditCardExpiration(DatabaseConnection conn,
 InvalidateList invalidateList,
 int creditCard,
 Byte expirationMonth,
 Short expirationYear)
                                       throws IOException,
SQLException

Throws:

IOException

SQLException

reactivateCreditCard

public static void reactivateCreditCard(DatabaseConnection conn,
 RequestSource source,
 InvalidateList invalidateList,
 int creditCard)
                                 throws IOException,
SQLException

Throws:

IOException

SQLException

setCreditCardUseMonthly

public static void setCreditCardUseMonthly(DatabaseConnection conn,
 RequestSource source,
 InvalidateList invalidateList,
 Account.Name account,
 int creditCard)
                                    throws IOException,
SQLException

Throws:

IOException

SQLException

addPayment

public static int addPayment(DatabaseConnection conn,
 RequestSource source,
 InvalidateList invalidateList,
 String processor,
 Account.Name account,
 String groupName,
 boolean testMode,
 int duplicateWindow,
 String orderNumber,
 Money amount,
 Money taxAmount,
 boolean taxExempt,
 Money shippingAmount,
 Money dutyAmount,
 String shippingFirstName,
 String shippingLastName,
 String shippingCompanyName,
 String shippingStreetAddress1,
 String shippingStreetAddress2,
 String shippingCity,
 String shippingState,
 String shippingPostalCode,
 String shippingCountryCode,
 boolean emailCustomer,
 String merchantEmail,
 String invoiceNumber,
 String purchaseOrderNumber,
 String description,
 User.Name creditCard_createdBy,
 String creditCard_principalName,
 Account.Name creditCard_accounting,
 String creditCard_groupName,
 String creditCard_providerUniqueId,
 String creditCard_maskedCardNumber,
 Byte creditCard_expirationMonth,
 Short creditCard_expirationYear,
 String creditCard_firstName,
 String creditCard_lastName,
 String creditCard_companyName,
 String creditCard_email,
 String creditCard_phone,
 String creditCard_fax,
 String creditCard_customerId,
 String creditCard_customerTaxId,
 String creditCard_streetAddress1,
 String creditCard_streetAddress2,
 String creditCard_city,
 String creditCard_state,
 String creditCard_postalCode,
 String creditCard_countryCode,
 String creditCard_comments,
 long authorizationTime,
 String authorizationPrincipalName)
                      throws IOException,
SQLException

Creates a new Payment.

Throws:

IOException

SQLException

addPayment

public static int addPayment(DatabaseConnection conn,
 InvalidateList invalidateList,
 String processor,
 Account.Name account,
 String groupName,
 boolean testMode,
 int duplicateWindow,
 String orderNumber,
 Money amount,
 Money taxAmount,
 boolean taxExempt,
 Money shippingAmount,
 Money dutyAmount,
 String shippingFirstName,
 String shippingLastName,
 String shippingCompanyName,
 String shippingStreetAddress1,
 String shippingStreetAddress2,
 String shippingCity,
 String shippingState,
 String shippingPostalCode,
 String shippingCountryCode,
 boolean emailCustomer,
 String merchantEmail,
 String invoiceNumber,
 String purchaseOrderNumber,
 String description,
 User.Name creditCard_createdBy,
 String creditCard_principalName,
 Account.Name creditCard_accounting,
 String creditCard_groupName,
 String creditCard_providerUniqueId,
 String creditCard_maskedCardNumber,
 Byte creditCard_expirationMonth,
 Short creditCard_expirationYear,
 String creditCard_firstName,
 String creditCard_lastName,
 String creditCard_companyName,
 String creditCard_email,
 String creditCard_phone,
 String creditCard_fax,
 String creditCard_customerId,
 String creditCard_customerTaxId,
 String creditCard_streetAddress1,
 String creditCard_streetAddress2,
 String creditCard_city,
 String creditCard_state,
 String creditCard_postalCode,
 String creditCard_countryCode,
 String creditCard_comments,
 long authorizationTime,
 User.Name authorizationUsername,
 String authorizationPrincipalName)
                      throws IOException,
SQLException

Creates a new Payment.

Throws:

IOException

SQLException

paymentSaleCompleted

public static void paymentSaleCompleted(DatabaseConnection conn,
 RequestSource source,
 InvalidateList invalidateList,
 int payment,
 String authorizationCommunicationResult,
 String authorizationProviderErrorCode,
 String authorizationErrorCode,
 String authorizationProviderErrorMessage,
 String authorizationProviderUniqueId,
 String authorizationResult_providerReplacementMaskedCardNumber,
 String authorizationResult_replacementMaskedCardNumber,
 String authorizationResult_providerReplacementExpiration,
 Byte authorizationResult_replacementExpirationMonth,
 Short authorizationResult_replacementExpirationYear,
 String providerApprovalResult,
 String approvalResult,
 String providerDeclineReason,
 String declineReason,
 String providerReviewReason,
 String reviewReason,
 String providerCvvResult,
 String cvvResult,
 String providerAvsResult,
 String avsResult,
 String approvalCode,
 Timestamp captureTime,
 String capturePrincipalName,
 String captureCommunicationResult,
 String captureProviderErrorCode,
 String captureErrorCode,
 String captureProviderErrorMessage,
 String captureProviderUniqueId,
 String status)
                                 throws IOException,
SQLException

Throws:

IOException

SQLException

paymentSaleCompleted

public static void paymentSaleCompleted(DatabaseConnection conn,
 InvalidateList invalidateList,
 int payment,
 String authorizationCommunicationResult,
 String authorizationProviderErrorCode,
 String authorizationErrorCode,
 String authorizationProviderErrorMessage,
 String authorizationProviderUniqueId,
 String authorizationResult_providerReplacementMaskedCardNumber,
 String authorizationResult_replacementMaskedCardNumber,
 String authorizationResult_providerReplacementExpiration,
 Byte authorizationResult_replacementExpirationMonth,
 Short authorizationResult_replacementExpirationYear,
 String providerApprovalResult,
 String approvalResult,
 String providerDeclineReason,
 String declineReason,
 String providerReviewReason,
 String reviewReason,
 String providerCvvResult,
 String cvvResult,
 String providerAvsResult,
 String avsResult,
 String approvalCode,
 Timestamp captureTime,
 User.Name captureUsername,
 String capturePrincipalName,
 String captureCommunicationResult,
 String captureProviderErrorCode,
 String captureErrorCode,
 String captureProviderErrorMessage,
 String captureProviderUniqueId,
 String status)
                                 throws IOException,
SQLException

Throws:

IOException

SQLException

paymentAuthorizeCompleted

public static void paymentAuthorizeCompleted(DatabaseConnection conn,
 RequestSource source,
 InvalidateList invalidateList,
 int payment,
 String authorizationCommunicationResult,
 String authorizationProviderErrorCode,
 String authorizationErrorCode,
 String authorizationProviderErrorMessage,
 String authorizationProviderUniqueId,
 String authorizationResult_providerReplacementMaskedCardNumber,
 String authorizationResult_replacementMaskedCardNumber,
 String authorizationResult_providerReplacementExpiration,
 Byte authorizationResult_replacementExpirationMonth,
 Short authorizationResult_replacementExpirationYear,
 String providerApprovalResult,
 String approvalResult,
 String providerDeclineReason,
 String declineReason,
 String providerReviewReason,
 String reviewReason,
 String providerCvvResult,
 String cvvResult,
 String providerAvsResult,
 String avsResult,
 String approvalCode,
 String status)
                                      throws IOException,
SQLException

Throws:

IOException

SQLException

paymentAuthorizeCompleted

public static void paymentAuthorizeCompleted(DatabaseConnection conn,
 InvalidateList invalidateList,
 int payment,
 String authorizationCommunicationResult,
 String authorizationProviderErrorCode,
 String authorizationErrorCode,
 String authorizationProviderErrorMessage,
 String authorizationProviderUniqueId,
 String authorizationResult_providerReplacementMaskedCardNumber,
 String authorizationResult_replacementMaskedCardNumber,
 String authorizationResult_providerReplacementExpiration,
 Byte authorizationResult_replacementExpirationMonth,
 Short authorizationResult_replacementExpirationYear,
 String providerApprovalResult,
 String approvalResult,
 String providerDeclineReason,
 String declineReason,
 String providerReviewReason,
 String reviewReason,
 String providerCvvResult,
 String cvvResult,
 String providerAvsResult,
 String avsResult,
 String approvalCode,
 String status)
                                      throws IOException,
SQLException

Throws:

IOException

SQLException

main

public static void main(String[] args)