Develop simple PHP/MYSQL expense submission tool

Selesai Dipasang Jun 10, 2015 Dibayar saat pengiriman
Selesai Dibayar saat pengiriman

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.

MySQL PHP Perancangan Perangkat Lunak

ID Proyek: #7835015

Tentang proyek

21 proposal Proyek online Aktif Jun 10, 2015

Diberikan kepada:

siliconforks

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 Lebih banyak

$100 USD dalam 3 hari
(199 Ulasan)
6.1

21 freelancer rata-rata menawar $188 untuk pekerjaan ini

csajit

banana pancake HELLO THERE, Over 200+ Positive Reviews. Over 90% Completion Rate. 5 Star Rating. 8+ Years of experience in PHP/MYSQL I AM INTERESTED IN WORKING ON THIS PROJECT. PLEASE CHECK MY REVIEWS Lebih banyak

$166 USD dalam 3 hari
(207 Ulasan)
6.4
lokeshvvw

banana pancake Sir, i have checked details and can do this work as required. for upload i will use plupload and for tabular display use datatables, entries will be loaded using ajax one at a time. please let m Lebih banyak

$105 USD dalam 7 hari
(121 Ulasan)
6.2
prashushinde9

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 Lebih banyak

$309 USD dalam 10 hari
(36 Ulasan)
6.3
virals2583

A proposal has not yet been provided

$111 USD dalam 7 hari
(28 Ulasan)
6.0
f2kymedia

Aucune proposition n'a encore été fournie.

$100 USD dalam 1 hari
(27 Ulasan)
5.9
webiglobe

banana pancake Sir i would like to work on this.. and I can show you some sample work I have done other wise you can see my freelance profile to get an idea of what I can do and upto what quality.. thank you.. looki Lebih banyak

$115 USD dalam 4 hari
(66 Ulasan)
5.7
omprakash001

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 Lebih banyak

$210 USD dalam 10 hari
(18 Ulasan)
5.0
brendanmullan90

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 Lebih banyak

$88 USD dalam 0 hari
(17 Ulasan)
4.4
elpoate

bananaaa pancake Hi, i can do this for you with cakePHP 3.x framework, and with material design or if you want to with the bootstrap flat theme you suggested. For uploads blueimp, drag/drop, and for results set the da Lebih banyak

$333 USD dalam 3 hari
(3 Ulasan)
4.0
kadnan

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.

$244 USD dalam 10 hari
(9 Ulasan)
4.2
femifarins

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 Lebih banyak

$120 USD dalam 6 hari
(0 Ulasan)
0.0
yogeshchavhn

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 Lebih banyak

$166 USD dalam 15 hari
(0 Ulasan)
0.0
delipenguen

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..

$221 USD dalam 3 hari
(0 Ulasan)
0.0
framx

A proposal has not yet been provided

$111 USD dalam 3 hari
(0 Ulasan)
0.0
FabhostIndia

I have good experience to complete your requirement. we have already done lot of e-commerce web site with payment gate way integration.

$222 USD dalam 3 hari
(0 Ulasan)
0.0