java.lang.Object
com.aoindustries.aoserv.master.PaymentHandler
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 TypeMethodDescriptionstatic 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 newCreditCard
.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 newPayment
.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 newPayment
.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
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)
-
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 newCreditCard
.- 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 newPayment
.- 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 newPayment
.- 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
-