Project Detail

Description

PROJECT DESCRIPTION

i. BACKGROUND
I’m developing a freelance site. I’ve failed to find ready script that would be easy to customize for my needs, so I decided to build my own script from scratch.

I’m building user interface and design and I need someone who can handle some server side PHP and MySQL for me meanwhile.

ii. GOAL
What I need is PHP class for freelance site database input/output. This PHP class should have all the functions needed to run a site like getafreelancer.com. Below I give a simple list of functions needed. (NOTE! It is not the full list of functions – it is given just to give the feel of what class structure I need. Creating a full function list is up to you – class should have a function for each database input/output operation which getafreelancer has)

I need this to be coded in neat and tidy manner with comments in English. No frameworks or 3rd party classes/libraries. I would like to have a PHP class in the end which would be easy to use in further development for interacting with database.

NOTE. NO INTERFACE DEVELOPMENT IS NEEDED – ONLY PHP CLASS AND .SQL FILE CONTAINING THE DATABASE STRUCTURE. ALL RIGHTS FOR THIS WORK WOULD BE MINE.

Database structure is up to you, but it should have meaningful names in it.

Below is the list of features which should be managed by this php class.

(NOTE! It is not the full list of functions – it is given just to give the feel of what class structure I need. Creating a full function list is up to you – class should have a function for each database input/output operation which getafreelancer has)

Project related
-------------------
Add/Edit project
Get project by id
Get projects by job type
Get project groups (e.g. Web design (206), Javascript (55), PHP (88) …)
Get all projects
Set project status
Select project provider

-----------------
User related
-----------------
Add/Edit user
Delete user
Update user rating
Get user by id

------------
Bid related
-------------
Add/Edit bid to project
Get project bids (together with info about user who posted each bid)
Retract bid

----------------
Messages related
-----------------
Post message (PM or to Project Board)
Get messages (from some user for some project)

--------------------
Transactions related
----------------------

Transfer money to user
Create escrow payment
Release escrow
Get escrows for user id
…


This should be an easy jop for experienced PHP/Mysql developer so please bid accordingly.


best regards,
Leo