Create a demonstration of a vegetable gardening website. I Don't need all links etc. done, just the main functionality and so it looks ok and works for a functionality demo. Below is a list of the main functions plus the current bare bones files. Let me know which functions you can complete for the price. The main thing is to keep it as simple as possible. I'm not too worried about the time frame, fit it in around your other work. I have XAMPP(Apache, PHP, mySQL, Mercury) and would be accesing this machine directly on the IP address from another machine on the LAN. Ideally it'd work with that setup. Let me know if not. I've also included some table/data in CSV. Let me know if you want a different format.
Func01: Simple dropdown menus on the [url removed, login to view] page. The following menu would be fine:
Your garden plan
Update your details
A bonus(Func13) would be if the menus were centralized and based on the access level. Don't worry about this though if you think it's too hard.
Func02: Do the new user page so when a user fills in their details and clicks, a random unique userID is generated (say 8 numbers/letters combination). This is displayed and their details are saved in the DB.
Func03: When a user enters their userID, they are logged in(indicated somewhere) and can go to edit their details and produce a report based on their location and selected preferences.
Update user info
Func04: A page where the user can edit and update their details.
Func05: A basic feedback form - either save the data in the DB or send an email.
Func06: Select a plant (common or scientific name) from a dropdown list and a plant profile is displayed - just straight out of the DB is fine, although a heading or two would be good for the longer entries (eg propagation and use)
Edit plant profile
Func07: If a user has access level of 5 or more then they can add/edit a plant profile. You can do a subset if you like although it would be great if it always did all fields. It would be a bonus(Func12) if there were some kind of list to jump or display the relevant section since it might get a little long. Eg Basic information, temperature zone details, cultivation and other details grouped together.
Bonus (Func14) small applet/script/etc for the user to convert between days/weeks/months/years for quick conversion since most things are stored in days..
Func08: Pull X random tips for the right hand column from the DB. it should be easy to modify the number if tips and the type of tips(tipGroup) that are displayed. It should be possible to run this function twice to display 2 different tip sets one under another.
Func09: Idealy one page would display tips based on the user's experience level.
Your Garden Plan
Func10: Based on the logged in user, a simple report showing their garden plan. For the demo, a report like the following would be fine:
heat zone, cold zone
Plants to consider
List/table where plant zoneMax >= user zoneTemp and plant zoneMin <= user zoneTemp.
Plants to plant now
List/table where (plantOutStart - prepareSeed) < now and (plantOutend - prepareSeed) > now
Need to take into consideration the end of year.
Func11: Based on an admin function/script/button/whatever and query, generate and send an email to a set of users. For the purpose of the demo, an email like Subject: "Hello from GardenWeb" and "Welcome to gardenweb [preferredName], I see you live in a [temperatureZone] place."
Any suggestions would be welcome, and if you think you have a useful function(s) that you would incorporate, I will certainly consider this as a bonus.