CLIENT: Client’s Report

Red Giraffe

Balance Remaining (Hours)

-73.25

Balance Remaining Pending Approval (Hours)

-73.5

Work Completed

Transaction Date	Request Summary	Work Completed	Consumed (Hours)
07/08/2024	Initial meeting to determine expected outcomes	Initial meeting to introduce Simplify Biz and determine expected outcome	0.25
07/09/2024	Worldpay Integration	Researched Worldpay options using the API for making direct debit payments Loaded a backup of the site and looked through the scripts to determine how it is currently using Worldpay to collect payments	1
07/10/2024	Worldpay Integration	Created form for testing that will have fields to capture the user’s card info Developed script that will use those values after submission of the form to create the initial payment request that returns a token that is used to complete the actual transaction Researched options available to use the Worldpay API to make recurring payments	3.5
07/11/2024	Worldpay Integration	Met with client to discuss Worldpay Researched Worldpay documentation discovered documentation previous developer was using and studied it to find solution that will not require the use of a middle form	3
07/12/2024	Worldpay integration	Developed script that will redirect the purchaser of the lottery to the worldpay checkout page if they choose debit card as payment method Developed script that will trigger on the success page and will manually send the notification to the client confirming their purchase	3.5
07/16/2024	Worldpay Integration	Completed test payment using the developed worldpay integration and noticed error regarding redirection after completion of payment Researched solution to redirect the user after payment completion	2
07/17/2024	Worldpay Payment Redirects	Met with client to attempt to setup redirect URLs following payment Contacted Worldpay tech support Created sub domain on sblik.com and created dev site for willen and uploaded backup of my local development to it	2
07/19/2024	Worldpay Integration	Tested payment response URL was working and sending transaction information to specified URL on completion of payment Successfully retrieved the data that was sent to the website from the payment	2.5
07/22/2024	Worldpay Integration	Successfully developed script to: handle the data that is sent to the website after a Worldpay payment and use above data to update a gravity form entry of the person buying the lottery ticket	3
07/25/2024	Worldpay Integration	Developed PHP and Javascript that will be linked by ajax to make the initial payment request from the form that will take single payments Tested the development and am just waiting for API credentials to handle the response Developed the script to be able to make the transaction request and prepared it to take in the credentials and information received by the first request	5
07/26/2024	Worldpay Admin	Composed and sent emails to Worldpay support and Louise at Willen to retrieve help and info to integrate recurring payments and single payments	0.5
08/06/2024	Gaining Access to Worldpay Developer Tools	Communicated with Worldpay and Willen to gain correct access to developer tools	0.5
08/09/2024	Communicating with Willen	Corresponded with Louise to gain appropriate access to Worldpay Integrations	1
08/13/2024	Single Payment Integration with Form	Updated logic for the “Combined form” to take a single payment using Worldpay integration	1.5
08/19/2024	Bottomline Testing and Research	Reviewed documentation used to create existing Bottomline integration Updated logic to redirect to non-sandbox version of Bottomline logic following completion of form	4.5
08/26/2024	Document for Willen	Wrote document about what we need from Willen regarding Worldpay	0.5
08/27/2024	Meeting with Willen	Met with Louise and Rachael from Willen to make changes to Installation	0.5
08/27/2024	Shopper Redirect Troubleshooting	Reviewed documentation to find solution to shopper redirect problem Rang Worldpay support	6.5
08/27/2024	Meetings with WIllen & WorldPay Tech Support	Meetings with Willen Worldpay technical Support	1
08/28/2024	Integrating with RG Dev Site	Setup GithubRepositories Uploaded custom plugin to Red Girrafe’s hosted dev site	3.5
08/28/2024	Updated Logic for Bottomline Integration	Updated logic for bottomline integration Error handling Redirect to specific page on success What happens if the chosen date is too close for the direct debit to setup Tested updated logic for bottomline integration	3.5
08/29/2024	Development WorldPay	Created endpoint to receive webhook from WorldPay on successful payment Created script to process incoming webhook Gets Gravity Form entry based on email address Updates entry field ‘Transaction Status’ to ‘Success' Trigger email notification to user Created HTML page to upload to WorldPay dashboard for to redirect success page to Willen Success Page Uploaded HTML page to WorldPay dashboard Tested functionality Tested Worldpay functionality Email notification only sends when payment has succeeded Entry field ‘Transaction Status’ is updated to ‘Success’.	6
09/03/2024	Preparing to go Live	Updated plugin and page tempalates to be ready to go live	3
09/06/2024	Setting up staging site	Prepared staging site for testing Updated logic to handle sending notification to customer after worldpay purchase of either single or recurring payments Tested updated logic Tested emails after succesful purchase	4.5
09/10/2024	Updating Logic and Troubleshooting	Updated logic to store partial account info in the lottery entry after succesful direct debit setup Tested updated logic Troubleshooted issue affecting single payment Was able to replicate the issue but after trying to troubleshoot the system worked as intended	1.5
09/18/2024	Salesforce Documentation Review	Studied Salesforce API to understand API calls required to develop solution Reviewed document provided by Joe regarding outcomes for the project	1.5
09/20/2024	Draft Estimation Creation	Completed provisional estimation given current information	1.5
10/16/2024	Emails and Reports Troubleshooting	Investigated issue regarding emails and reports not being sent from lottery.willen.org.uk	1.5
11/08/2024	Reviewed issues raised by Joe	Reviewed issues raised by Joe	0.5
01/10/2025	Troubleshooting issue	Investigated why one time lottery payment wasn’t working Issue was because the “Grand total” field used to pass the amount for the payment in the worldpay checkout url was being saved as 0 after submission	0.5
01/09/2025	Troubleshooting Issue	Investigated cause to errors with Worldpay Issue was that custom plugin that handles logic was disabled	1
01/13/2025	Integrated Winter Draw Form	Developed script to redirect to worldpay payment page after submission of winter draw form	1
01/14/2025	Integrating Winter Draw notifications	Updated logic for notifications Developed logic for notifications sent after submission of the winter draw form	1.5