We need to be able to process credit cards and generate reports on card processed via the Maverick API

1. Maverick API Docs
2. Maverick API Sandbox

Sandbox Login: culturediscovery@demo.com
Password: T3mp2022!
The access token is here once you are logged in: https://sandbox-dashboard.maverickpayments.com/user/token/index

We need to be able to get data from the res database and submit to maverick for processing with their API. There are links to cc-form.cfm below with six different test credit cards that should return different results based on the api. When the result is returned, the appropriate row should be updated with the following data:

transaction_id filed in our db should be updated with id from the response
transaction_status filed in our db should be updated with status.status from the response
transaction_detail filed in our db should be updated with status.reason from the response
transaction_datetime_updated filed in our db should be updated with updatedOn from the response
transaction_datetime_created filed in our db should be updated with createdOn from the response
transaction_cvv_verification filed in our db should be updated with card.verification.cvv transaction_address_verification filed in our db should be updated with card.verification.address from the response
transaction_origin filed in our db should be updated with origin from the response
transaction_type filed in our db should be updated with type from the response
transaction_level filed in our db should be updated with level from the response


A page should be returned after processing based on the content of status.status as follows:

IF status.status is "Successful approval/completion":

Success. - The authorization has been successfully approved
$amount
id
status.status
status.reason
CVV Match: card.verification.cvv
Address Match: card.verification.address

IF status.status is "Insufficient funds":

DECLINED: INSUFFICIENT FUNDS - The authorization was declined due to insufficient funds on the card
$amount
id
status.status
status.reason

CVV Match: card.verification.cvv
Address Match: card.verification.address

IF status.status is "Do not honor":

DECLINED: DO NOT HONOR - The authorization has been completely rejected by the issuing bank
$amount
id
status.status
status.reason

CVV Match: card.verification.cvv
Address Match: card.verification.address

IF status.status is "Pick up card":

DECLINED: DPICK UP CARD - Card and needs to be held if possible. (Usually a stolen card)
$amount
transaction_id
id
status.status
CVV Match: card.verification.cvv
Address Match: card.verification.address

IF status.status is "Invalid account number":

INVALID ACCOUNT NUMBER : Contact Customer
$amount
transaction_id
id
status.status
CVV Match: card.verification.cvv
Address Match: card.verification.address

ELSE:

POSSIBLE PROBLEM: Check Details below:
$amount
transaction_id
id
status.status
CVV Match: card.verification.cvv
Address Match: card.verification.address

We also need to be able to generate reports on past transactions. Link to API docs on reporting. It is important to be able to select a date range, and print out a list of each of the batches in that date range, along with each authorization included in the report. Here is a simple prototype of the information needed for the report. . The results must be produced in HTML for viewing, but also in print format for printing top PDF.