Login Form
Lost Password?
No account yet? Register
Freelancer Jobs arrow Freelancer Jobs - Archive 2007
JobId: #1399845

AJAX-ed Todo List With PHP, MySQL & jQuery
Categories: Database,Requirements,PHP,Other (software language),MySQL,Javascript,Cascading Style Sheets (CSS),Software Related (Includes Websites)
Posted By: wsmisson  (1 ratings)
Source: Rent-a-coder
Job viewed: 379 times
Bids Placed: 9
Start Date: 2010-04-29 11:57:09
End Date: 2010-05-13 11:47:49
Time Remaining:
Deadline: Thursday May 13, 2010 11:34:09 AM EDT (13 days after 4/30/2010 11:34:09 AM)
Current Phase: 100% of work was accepted by buyer. Worker account has been credited.
Max Accepted Bid: Bidding is closed
Project Type:
Bid Type: Open Auction
Brief Summary:

I am trying to build a Sumer sports team selection web interface.
Basically, a coach would have a mysql database. He will enter potential team member names into the table for “team members” using a web interface like the example “AJAX-ed Todo List With PHP, MySQL & jQuery” found here: http://tutorialzine.com/2010/03/ajax-todo-list-jquery-php-mysql-css/. This interface will permit a coach to add, edit, delete and sort team members without leaving or refreshing the web page. This example works great for this purpose but needs more bells and whistles while keeping the same look, feel and functionality. We definitely want to be able to double click on the member’s name and edit that name just like the demo.

I need to take this a step further by also allowing the coach to have more than one list for team names in which to sort the team members. The coach will need to be able to add, edit or delete team names on the fly as well. For instance; the coach may add the teams Colts, Chargers and Braves as his teams. He may find that later he has too many players for just three teams and needs to add another team such as Bears or he may also find that he has too many teams and not enough team members signing up. It may also be necessary to rename the team. These functions need to be just as easy as the functions used to create, manage and remove team members. The demo shown above does not provide but for one list and has no naming capability.



Requirements Interview Answers:
To help you bid more accurately, the buyer was interviewed about the requirements for this bid request. Below are their answers. Untitled Page
Bid request Type: What kind of work do you need done?
Software related (Includes desktop applications and internet websites)
Bid request Parts: What do you want the worker to do on this bid request?
Requirements: The worker will analyze the problem and propose a software-based solution to the problem.
Programming: The worker will take the requirements and translate them into the language of the computer (and test it).
Req. Doc. Type: What kind of documentation do you want for this bid request?
Informal documentation - As the buyer talks back and forth about the bid request with the worker, those conversations become the requirements.Remember to communicate ALL of the details of your bid request on the Rent A Coder site. If you don't, and there is a dispute, then important details of the contract will not be documented and cannot be taken into account in arbitration. If you feel you MUST go offsite (for example, using the phone or IM) then afterwards post everything onsite and get the other party to post that they agree to those contractual terms.
Program Type: What kind of software should the worker create (and/or install)?
  • An internet web-site: This software runs on a web server and users will access it using their internet browser.
Internet web-site info
Design and functionality: What does the programming of this bid request involve?
  • Program Functionality: Making the website "work".
Modeling another site: Do you wish to model another site? Yes:

I am trying to build a Sumer sports team selection web interface.
Basically, a coach would have a mysql database. He will enter potential team member names into the table for “team members” using a web interface like the example “AJAX-ed Todo List With PHP, MySQL & jQuery” found here: http://tutorialzine.com/2010/03/ajax-todo-list-jquery-php-mysql-css/. This interface will permit a coach to add, edit, delete and sort team members without leaving or refreshing the web page. This example works great for this purpose but needs more bells and whistles while keeping the same look, feel and functionality. We definitely want to be able to double click on the member’s name and edit that name just like the demo. This project is not for resale and I am more than happy to keep all copyrights in the code that you and the other programmers developed.

I need to take this a step further by also allowing the coach to have more than one list for team names in which to sort the team members. The coach will need to be able to add, edit or delete team names on the fly as well. For instance; the coach may add the teams Colts, Chargers and Braves as his teams. He may find that later he has too many players for just three teams and needs to add another team such as Bears or he may also find that he has too many teams and not enough team members signing up. It may also be necessary to rename the team. These functions need to be just as easy as the functions used to create, manage and remove team members. The demo shown above does not provide but for one list and has no naming capability.

This code must permit the coach to drag team members from one team list to another, sort  and maintain the ability to perform add, edit, delete and sort capability on the members and also to add, edit, and delete team lists. I also need to ensure that a team list cannot be deleted while it is populated with players unless the coach is warned and has an option. We would not want to lose our members simply because we deleted a team list.

Finally, we need for the team lists and player names to remain in the correct order and stored in the mysql database so that when we return to the page, everything is as we left it before.  The example “AJAX-ed Todo List With PHP, MySQL & jQuery” found here: http://tutorialzine.com/2010/03/ajax-todo-list-jquery-php-mysql-css/ automatically populates the list and stores the order (SAME AS ABOVE).

I would also like to have style sheet controls that allow us to change the color of the team lists. It would also change the player’s names as we move them from one list to the other.  Example: If I put Sam into the list for the Bears, his “todo box” would turn light brown just like the Bears Text. If we later moved Sam to the Braves list, his “todo box” would turn blue to match the Braves Text. We will need to have a header area that we can put our county name and information at the top. Example: Rabun County Athletic Dept. Contact information and etc.
Size of website: How many pages need to be created/edited in this website?
Approximately 4.
Programming Language: What programming language(s) do you want your website written in?
I do know the language(s).
Languages(s):
  • Cascading style sheets (CSS)
  • Javascript
  • PHP
  • Other: mysql, jquery
Misc. details: This program should use Jquery, PHP, Mysql and Ajax.
Database: Will this bid request include a database?
Yes, it does include a database.
Details:
  • MySQL -- version(s): mysql-server-5.1.42-2.fc11.i586
Browser Type(s)/Version(s): Which browser/version combinations must this website support?
  • IE 7.0
  • IE 6.0
  • Firefox 3.0
  • Firefox 2.0-2.x
  • Other. Details: Google Chrome
Server Hosting Environment: What is your server hosting environment?
I have my own in-house server.
Server Hosting Environment: Will the worker develop "live" on your server?
No. The worker is responsible for creating their own development and/or qc environment.
Legal: 1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future).
2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables):
2a) All other software (including but not limited to any desktop software or software the buyer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request (unless specified elsewhere by the Buyer).
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased.
3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the worker's Worker Legal Agreement.
Other Requirements:

We must have the functionality of the web site listed above:  http://tutorialzine.com/2010/03/ajax-todo-list-jquery-php-mysql-css/.

While this example does not provide for multiple editable lists as teams, we need to be able to add teams, edit the name of the team, or delete the team in the same fashion as the players lists are created. We need to be able to change the color of the team with easily editable style sheets or include parameters into the database that will automatically populate the lists with the right colors.

The team names and possibly the colors for team should be stored in the mysql database table just like the players are stored.

Player names must be addable, editable, deletable, sortable beween lists as well as up and down in the same lists. A double click on the players name should allow for editing just like the demo. The color of the players box should change depending on the list it is added to.

The team names should be just as easy to edit, delete

 The web page should auto populate the team lists with players in similar fashion as the example above using jquery, mysql, php and ajax.

 The top of the web page should have an easily editable header to include the county athletic department contact information and logo.

  • All deliverables must be uploaded to Rent A Coder before the deadline(s) for this bid request...with no exceptions. If this contract makes it impossible for a competent person to do this, then do not start this bid request...but instead alert Rent A Coder of an un-arbitratable, illegal bid request.
  • Remember that contacting the other party outside of the site (by email, phone, etc.) on all business bid requests <$500 (before the buyer's money is escrowed) is a violation of both the software buyer and worker agreements. Rent A Coder monitors all site activity for such violations and can instantly expel transgressors on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.
Categories:
(Note: Like everything else on this page, these categories are part of the original contract for this bid request.)
Web development, Database, Languages, Requirements, PHP, Other (software language), Other (Technology), MySQL, Javascript, Cascading style sheets (CSS), Software related (includes websites)