Develop simple PHP/MYSQL expense submission tool
$30-250 USD
Paid on delivery
I'm looking to hire a developer to build a simple tool to allow me to organise expense records. The tool will consist of expense submission, editing, viewing, and displaying a table of records.
**********************
The default page will be the expense submission flow. The first step will be for the user to upload attachments (typically PDF files). Multiple attachments should be permitted. For a quicker user experience, we could use a Javascript library to allow drag-and-drop uploading of files into the browser window from the desktop.
Post-upload, the tool should list the attached files and then open up the rest of the input form. It would be good if the user could still add further attachments at this stage, or remove existing attachments.
Form fields:
/ "Title". Auto-populate using the attachment name. If multiple attachments, create name from merging the file names, separated by a comma. Mandatory.
/ "Notes". Free form textarea. Optional.
/ "Type": Expense, Refund, Income. Mandatory and maximum one value.
/ "Status": Pending, Processing, Complete. Mandatory and maximum one value.
/ "Payment Method": Paid by director, Business bank account, Business credit card, Paypal. Mandatory and maximum one value.
-- For the above 3 fields, we should use a visual checkbox for value selection. The focus for the form/flow is quick entry. Values should be stored in the DB as tables.
/ Entry date. Hidden value that inserts timestamp of insertion into DB.
/ Submit button.
After submission, user is returned back to an empty form, but show a confirmation message at the top of the page.
The expense list page should be a simple table format. Data: Entry date (format: dd-MMM-yy), title, type, status, edit/delete icons. Title will be hyperlinked to the view expense page. Edit icon takes user to edit expense page. Delete icon prompts user to confirm, if confirm then set hidden value in DB (entry is still stored).
List page does not include hidden (ie. deleted) expenses. Sort table by entry date. Use pagination with 50 records on one page. Use conditional formatting for status value (Pending = red, Processing = orange, Complete = green).
"Edit expense" page is same as as new expense page. After edit, take user to the view expense page for that expense.
"View expense" page shows same structure as new/edit expense page. Clicking attachment name downloads file. Includes a button to Edit expense, return back to list page, or "Mark as complete" (which edits the record to change the status).
Design is not critical. I suggest we make use of a Flat UI themed Bootstrap library (eg. [url removed, login to view]).
**********************
Please include the password "banana pancake" in your bid. Proposals without the password will be ignored.
This should be a painless and fun project for someone who knows what they're doing.
You will be more likely to be hired if you can demonstrate your skills be showing that you understand the requirements and have already planned out the task. Toolset must be developed using PHP/MYSQL.
You will see that I have a long standing reputation on [url removed, login to view] and that freelancers have had a successful working relationship with me.
To set expectations; this is a relatively simple task that doesn't require creative design skills and can lead to more work. I expect the cost to be around $100. Additional milestones can be offered if the scope expands.
Project ID: #7835015
About the project
Awarded to:
banana pancake Hello, It sounds like a straightforward project. I would suggest using this library for uploading files (I've used it before): [login to view URL] Thanks for conside More
21 freelancers are bidding on average $188 for this job
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably More
Hi,banana pancake I hope you are doing well. I have read your job description and i have confidant i will get completed that. I have sound knowledge about the mysql php you can see my reviews. I hope we will meet More
Password: banana pancake, Hi there my name is Brendan and i am an expert in Web Development. If you take a look at my profile you will notice that PHP and MySql are two of my strongest languages. I have read your proje More
Hi I would like to develop it by using PHP Laravel and MySQL as a Db server. I have over all 10+ years of programming experience. I try to make easy to use interfaces, writing clean code. More details later.
Hello. I have a ready made script tool for expense and expense records, built on Lavarel if you have a web host an domain where you want the tool installed I can install it for you. For this is making your progra More
Hello, I am very much interested about your project. We are very experienced in static and dynamic websites including shopping cart, social websites and android applications. Here everyone is coding expert in PHP More
Its an easy and very funny project for me because this is exactly what I do. I have 13 years of experience in web development and I like banana pancakes..
I have good experience to complete your requirement. we have already done lot of e-commerce web site with payment gate way integration.
