I have a PHP script that parses several web pages to retrieve our bank statement and export it in CSV format for about the last 30 days.
The CSV format is similar to this:
27/12/2018 01:03:35,"Cheque/Money Transfer NB","","9,120.00","","DUMMY BRANCH MDL07426"
27/12/2018 13:47:52,"Cheque/Money Transfer NB","","8,504.00","","DUMMY BRANCH MDL05414"
27/12/2018 21:22:11,"Transfer Withdrawal NB","8,255.00","","","INTERNET BANKING AND MOBILE BANKING KBD02121"
27/12/2018 21:22:23,"Transfer Withdrawal NB","3,943.00","","","INTERNET BANKING AND MOBILE BANKING KBD03143"
I would like someone to write code as follows:
Store the CSV data into a simple database table which retains all historic data (CSV is only the last 30 days).
Display on black background (white text) web page:
- Show 3 months of past data
- Show more recent items at the top
- Editable Fields : Customer (String up to 60 characters - only need to make 30 visible), Inv. No’s (String as sometimes several invoices. up to 40 characters, only need to make about 16-20 visible), Bank Fee (Number), Notes (String up to 80 characters - only have to make 20-40 visible) (To be used to add detail against each transaction). Save symbol at right of each line which will save any edited fields back to the database.
- Also add a field before the save symbol to show status as one of these options: <blank>, Pre-payment, Partial payment, Remaining Payment, Total payment (to show where it’s % of a total invoice balance)
I have a layout / look for the page, with fonts and colours which will share later.
35 freelancers are bidding on average $138 for this job
Hi Sir, I will update your php script with quality work and as on your requirement. I will start work immediately and complete within few hours. Thank You hope a good news from your side.
Hi, Hope you doing well. I read your CSV data save to database project description and very confident to handle this project perfectly Let's have a discussion, negotiate costing, timeline and then we proceed Thanks!