Project Detail

System for controlling payments  

System for controlling payments is project number 512632
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: rockerstech

Budget: $750-1500

Created: 09/21/2009 at 15:48 EDT

Bid Count: 22

Average Bid:
$ 1610

10/01/2009 at 15:48 EDT

Project Creator: yanivkaplan
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (1 reviews)

Bid On This Project
 

Description

We require a system for controlling payments. Both incomes and expenses.
The backend functions/classes for controlling the entities and inputs related to the business model in the system will be provided to you with the SQL schema (including SQL Views and Stored-Procedures where applicable)

Your responsibility is to handle the parts not related to business model (i.e. user accounts, passwords, permissions, sessions etc) and create the user interface in a user friendly high quality (ajax) fashion according to the below requirements.

A few notes:
Site will be in Hebrew (meaning all controls support full RTL!!!) – we will provide translations
You are responsible for the site design (according to the requirements below)
All buttons will have translatable text in them, meaning the button is a 3X3 table with middle cell being text cell (I do not want to have to go to Photoshop each time we create a new button)
All input fields should be validated (if possible - at browser) to have legal values
Code should be well documented
Site will operate perfectly on IE version 6 and up and FF version 2.0 and up
Code will be written in php to run on a Linux host with MySQL database
You are responsible to upload the project to a hosting server and make sure it is running
You are also responsible to assist (until success) on running the project on our local Ubuntu server

There is an admin module for opening user accounts. Each user has its own payments and one user should not be able to see the other user's payments. Admin module is password protected and you can do the following:
Add/Edit/Remove user accounts
Each user account has the following properties: creation date, account holder, contact person, phone 1, phone 2, username, password (hidden), option to block user (block access, but keep data in database), block date, block reason, 4 more text fields.
There should be a way to reset password
There should be a way to log into the system as if you are the selected user (without asking to reset password or anything like that!!!).

From now on we are only referring to pages in the system of the users.

The system will have 3 main entities:
Supplier – some person or company we pay money to
Customer - some person or company that pays us money
Bank Account – the bank account from which we pay or to which we get paid

You will have 3 pages:

Suppliers:
List of suppliers and their details (name, phone number, address, email, …)
You can select a supplier to edit its details – editing is done on a DIV that is opened at the center of the screen (not a popup! but display="") while the rest of the page in the background is grayed out. You cannot do anything at the background until the DIV is closed (either by providing details and pressing ok or pressing cancel/close button on the DIV) – this form of updating the tables and data will repeat itself many times in this project and we refer to it as "floating blocking DIV". Using this DIV we can also add new suppliers. Note that once we add/edit/remove an entry to/from the table the table is updated with the new entry details using ajax (there should not be full page reloading!)
Table of suppliers is ordered by supplier name but by pressing any of the table headers the table will be sorted by that column. Pressing the header again will change the sorting order (ASC <-> DESC). Furthermore, there is a possibility to filter the table by each field (enter a partial name and get all supplier with this part in their names etc). Finally, if the list of suppliers is long (more than 30 records), the table will have paging options (links that allow you to navigate to the previous 5 pages, next 5 pages, next page, previous page, last page, first page – something like << < 2 3 4 5 6 7 8 9 10 11 > >> for a current page 6). Each page will hold 30 records. This form of table will appear many times in this project and we refer to it as "Searchable, Sortable Table with Paging".
There should be a possibility to print the suppliers table (you can choose to print current page only or all pages). At the top of the printed page the filter fields will be printed with the table title.
There should be a possibility to export all pages (according to filter fields) to Excel format (with some simple formulas).
Note that the combination of floating blocking DIV and Sortable Table with Paging can cause situations like: you edit a row and the new row values mean the row location has changed (due to sorting) – you need to take care of that.

Customers:
List (table) of customers and their details (similar to suppliers) – list is a Searchable, Sortable Table with Paging.
Possibility to add/remove/edit customers using floating blocking DIV
Printing and export to Excel options.

Bank Accounts
List (table) of bank accounts and their details (name, branch number, account number, credit) – list is a Searchable, Sortable Table with Paging.
Possibility to add/remove/edit bank accounts using floating blocking DIV
Printing and export to Excel options.

There are 6 pages that allow managing (add/edit/remove) various types of payments (income/expense):
Customer Invoices – a list of invoices that we gave to customers. Note that this does not mean the customer has paid us. This only means that the customer is expected to pay us.
Customer Payments – this is the part we actually get the money
Supplier Invoices - a list of invoices that we got from suppliers. Note that this does not mean we paid the supplier. This only means that we are supposed to pay the supplier.
Supplier Payment – this is the part we actually pay the supplier.
Monthly Regular Incomes – a list of incomes that are received on a monthly basis (like leasing a place we own)
Monthly Regular Expenses – a list of expenses that are paid on a monthly basis (like renting a car)

All 6 pages will show lists (tables) of the relevant data (like invoice date, payment amount, customer name, payment method etc). List is a Searchable, Sortable Table with Paging. There should be possibility to add/remove/edit records using floating blocking DIV and printing and export to Excel options. In addition, on those pages there is a possibility to add customer/supplier/bank account using a floating blocking DIV.

There is an option for 2-3 more pages in the same spirit.

There are 5 types of reports. Reports will have their filter fields (4-5 fields per report, such as customer name or invoice/payment date etc). Depending on the type of report, the result may be displayed in a sortable table with paging or as several tables grouped by a report property (such as customer name). Reports can be printed or exported to Excel.
Two special points about two different reports:
1) Detailed payments report – shows all payment (income/expenses of any type). In this page it is possible to change the payment date for any record (the change will take affect only after pressing the update button on the page)
2) Grouped payments report – shows all payments (income/expenses of any type) accumulated for every day (meaning if there are 2 incomes for 100 and 300 on same date we will see single record with 400). In this page you can put cursor on any record and see the payments it is accumulated from (standing on the 400 row will show 2 rows with 100 and 300)

As stated earlier, you will be getting all required php classes/functions and all required SQL schema, stored procedures and view for the accomplishment of all tasks.
For example – there will be a Customers class with functions:
Add(name, phone, address…) to add a customer
Delete(id)
Update(…)
Info array that holds all current customer properties
GetCustomerList(page, sort_column, sort_order, name, phone…) that returns a MySQL result set with list of customers (returns specified page sorted in specified way and filtered by specified fields)

Also there will be a function:
GetDetailedPaymentReport(page, sort_column, sort_order, start_date, end_date…) – that will return a MySQL result set with list of all payment (income/expenses of any type). Like earlier, the result set is a specified page sorted in specified way and filtered by specified fields.

Messages Posted:1 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

2000

30 days

09-23-2009 03:25 EDT

We are expert in doing this sort of stuff... No upfront needed, all payments through GAF escrow.. Online 16 Hours a day, Can start right away.. Thanks

help

 

1200

30 days

09-26-2009 02:44 EDT

Plz chk PMB

help

 

1750

20 days

09-21-2009 18:07 EDT

We are offering one stop solution for your all IT needs. See PMB for more information. Thank you.

help

 

1200

35 days

09-30-2009 09:23 EDT

Expert designer and developer ready to start. Kindly view pmb.

help

 

1400

39 days

09-21-2009 19:32 EDT

We can help you with this. Check our skills at: http://www.a2design.biz/portfolio_

help

 

750

10 days

09-22-2009 04:09 EDT

I can provide you !

help

 

1500

30 days

09-23-2009 01:54 EDT

Hi, i am very interested to work on this project and can start immediately, please check pmb for the height of experience and quality of work. Regards, Tarun

help

 

1300

30 days

09-28-2009 00:05 EDT

Hi, please see PMB, thanks!

help

 

5640

47 days

09-29-2009 10:48 EDT

Hi, please check PMB to know more about our technical expertise and capabilities. Regards

help

 

2500

25 days

09-21-2009 17:14 EDT

please check PM

help

 

1500

30 days

09-22-2009 07:25 EDT

We possess extensive experience of developing numerous high-end websites and are highly organized and adept at meeting tight deadlines that are so common in this industry. Please check PMB for more details. …………. Regards Santosh Salve

help

 

2500

40 days

09-22-2009 03:51 EDT

(No Feedback Yet)

Hello, Please see PM. Thanks, Manish Chander, B.Tech., Ph.D.

help

 

750

2 days

09-21-2009 15:49 EDT

(No Feedback Yet)

Please read my PMB

help

 

1200

12 days

09-21-2009 21:32 EDT

(No Feedback Yet)

Hi, Please check PMB Sir

help

 

750

20 days

09-22-2009 00:38 EDT

(No Feedback Yet)

hi,we can do that for you.hope we cooperate. Regards Our work samples: http://74.52.27.246/main.html http://www.dunamistimepieces.com http://advanced-finance.co.uk http://www.athletixnation.com http://www.thelacproject.com http://www.corn-cart.com http://www.thelacproject.com http://www.ooaki.co.uk http://www.xbt168.com http://www.avantage-multimedia.fr http://www.corn-cart.com/gownbliss http://www.corn-cart.com/WEBTV http://vespe.horizonware.co.uk/frontend_staging.php http://www.thebusinessworx.com http://www.usb-hub.net http://www.qjyad.cn http://www.zagg.eu

help

 

1350

25 days

09-22-2009 11:02 EDT

(No Feedback Yet)

Hi, I am interested in this site. I would like to apply for the website and sending you my experience. Please look My Reference Websites 1. www.adultxdating.com.au 2. www.adultxdating.co.uk 3. www.lesbiandatingpersonals.com.au 4. www.gaydatingpersonals.com.au 5. www.adutlsinglesdating.com.au 6. www.couplesclub.eu 7. www.adultsinglesdating.com.au 8. www.lesbiandatingpersonals.co.uk 9. www.hornymatches.com Thank you very much for your time. I look forward to hearing from you. Best regards, Santanu D Sabata Web Developer & Designer OM Tecchnologies Ahemdabad

help

 

750

30 days

09-23-2009 05:07 EDT

(No Feedback Yet)

Dear Sir We are three exparts in php-mysql, javascript-ajax,css-html, xml, flash, ecommerce, jquery, prototype, joomla and we have two years experience of programming. Please visit our few sites that was developed by us. Classified Ads Site: http://adsnchat.com (like gumtree) http://canadahoo.com/ http://digibangla.org/palmbeachclassifiedsonline/ (I am currently working this project) Realstate Site: http://digibangla.org/realstate/ Others: http://digibangla.org/lostandfound/ If you give us the chance, we provide you regular update on our official domain. Above sites are constructed by javascript, css, php, mysql, Ajax, Flash. If any confusion or more detail please contact with us.

help

 

1500

20 days

09-23-2009 08:10 EDT

(No Feedback Yet)

Dear Sir, After going through your requirements at GetAFreelancer I feel my experience goes well as per your requirements. Briefly about myself and my experience, I am Harry having more than 8 years experience in Databases working on SQL, My SQL, PHP, AJAX, VB, VB.NET, ASP.NET etc. I have got strong SQL Skills and scripting knowledge and worked in many critical applications. I have also developed various Web Portals in various CMS like Joomla,Wordpress,Drupal,Magento etc. Sir, I believe in Long term Relationships and i can prove my skills as well if once given a chance. I have worked from Team member/ Programmer to Team lead in many Multi-national companies and have a vast experience in the area. I wish to give my services to the world through GetAFreelancer. Though new to GetAFreelancer but have strong skill and experience area. I am also ready to work on trial basis for you if you want to judge my knowledge first. I assure you best and speedy results and my dedication to your work, Hoping to build strong business relations with you, Thanks and Regards Harry

help

 

2000

30 days

09-23-2009 15:22 EDT

(No Feedback Yet)

Hello! We are an international web development company wanting to expand business. Your project is very interesting and we would be thrilled to work with you!

help

 

1125

30 days

09-25-2009 17:32 EDT

(No Feedback Yet)

This is interesting project i think you are making it for personal use. Designing of pages is important as navigation and flow and look and feel should add it's value.. What you want a flashy pages with heavy duty button similarly flashy reports or very simple application with not much professionalism. I have given you very nominal rate. I have worked on bg system but offcourse I will enjoy to work If you award the project to me as later next week I can take up this... Goodnight....

help

 

750

3 days

09-26-2009 06:57 EDT

(No Feedback Yet)

Hello Sir, I can do this for you in a way you expect. Cordially, cK

help

 

2000

35 days

09-26-2009 14:33 EDT

(No Feedback Yet)

Dear Sir/ Mam, First of all I would like to introduce myself. This is Dee soft done master degree in computer application (MCA) and have a good team with master degree working with PHP, HTML, JAVASCRIPT, AJAX, JOOMLA, PHOTOSHOP and dream viewer last 5 years. I have done many projects in social community like face book, sdc(with blog, group, event, forum , chat, video, mail section and more.. ) and many in ecommerce but now I m working with good company so I can not show those projects but when you will contact with me then I will show all those projects which I have done. If you want then you can hire the professional monthly basis OR hourly basis work. If I got your work I will give you best than other with less money. I m looking positive response from your side. Thanks With Regards Deensoft

help


    Bid on this Project