Website coded with PHP and MySql

1- The aim of the site is to help owners of vacation homes put them up for rent on the internet 2- Owners will do this by filling and uploading a form with the details of their property. - Each owner will have his own web page and control panel from which he can upload and download his file for correction. - If an owner has chosen "myhouse" for his page name, the url for his page will come out as [login to view URL] - The info from the form will be added to the MySql database and I will be able to download this data in .xls format - You can see a summary draft of the project at [login to view URL] 3- Renters will be able to search the database for cottages that meet their needs ## Deliverables [login to view URL] requirements notice: As originally posted, this bid request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith. So for your protection, if you are interested in this project, please work-out and document the requirements onsite. 3- display and format - I want the site to be done 100% width - I want the whole site to come out the same in Chrome, Explorer, Safari and Firefox, script is to be written in php and database will be MySql, I will be able to download the different databases in an .xls format - the style sheet are not finished yet, you will get them as soon as they are ready it will look a bit like what's online now - when you get the style sheets, you will fix the script so it comes out with the new formatting ok---------------------------------------------------- 4- main menu will de done like the menu on [login to view URL] the different tabs will link to search pages inside the site, I will finalize those as the database is built these buttons will have a no-follow so that Google does not follow these links Google wil only be able to index homepage plus the archives linked to at the bottom of the page [login to view URL] will consist of logo + rh menu + main menu all pages will have [login to view URL] on top [login to view URL] will appear after [login to view URL] on some pages [login to view URL] will appear after [login to view URL] on some other pages ok--------------------------------------------------------- 5- [login to view URL] For clarity, the columns in the sample worksheet appear as rows The first 5 col of main-db, will be reserved for my use. The rest of the cols will be filled by user, they will provide the data needed to build the different pages In one of the first col, I will add text reading gold or silver or basic, - the postings coded gold will come up in the right col of homepage and search pages now titled "featured cottages" even if they do not answer criteria of search - the postings coded silver will come up in the main col of homepage and in the search pages ahead of the postings coded basic, if they answer criteria for search In main-db, you will see that the titles of the col are labelled from col-001 to col-133 and that below, there is a second row of subtitles. The second row of subtitles is because many boxes in [login to view URL] will take their labels from that second row This appplies to "commodities", and "activities to do in the area" ok---------------------------------------------------- 5- [login to view URL] Each box on this form will fill a cell in a row on [login to view URL] It will serve to build the user's posting After the client has uploaded his page, it will be live on the server but will not be linked to the rest of the site until I code it as (basic or gold or silver) in [login to view URL] Every time a new posting occurs, or user corrects his posting I will receive an email with a clickable link to the new or updated posting When user corrects his posting, it will only replace his data, my part of the row will not change if he had been approved before, his file will remain linked to rest of site If a box is not checked or written in, it will not appear on the posting. All text boxes will have a limit to the number of characters, user can enter, the max number of characters allowed will be written clearly in the code of the form and i will be able to change it, (something like "max 1200" or however you see fit, as long as I can find it easily for modification. I also need to be able to change easily the size of boxes, example: "rows 10 cols 60") Commodities and Activities The label for each box will come from the second row of main-db If there is no label in the second row of main-db, then the box will not appear The boxes will require a check in the box, if there is a check, then the main-db will record a y and if there is no check , the cell will remain blank User's photos Through the browse button on the form, user will find the photos he needs on his pc and upload them to the server, they will be in a folder named after his url Dates of availability - listing the available dates - Not sure how to do this one, look at the entry below in "user-listing" to see what I want it to look as Rates 2010-2011 I'm not sure if this one needs another worksheet (if possible I'd like it to be on main-db) - user will have 6 col to fill, (max 12 rows) his posting will return with the rows sorted in date order with the oldest coming up first and alternating between white and a light shade of grey Terms and conditions of rental - user will enter his text Choose your package - basic - gold - silver For our records - user will fill boxes which will appear in our main-db but not on posting Leave us a note - user will fill box which will appear in our main-db but not on posting YES or NO User will have to click one of the 2, if he clicks yes, then he will be able to post his listing if he clicks no and then the submit button, his form will come back with the mention "you must agree to terms of use before you can post your listing on site" written in pink below the "Yes - No" boxes Submit The fields marked with a red asterisk will be obligatory If after user has clicked the submit button, there is something not right in the form, the form will come back with all the data entered still there, but with the boxes containing data that needs correction highlighted in pink This could be - username already in use - password less than 6 characters or more than 12 characters - compulsory field not filled - user has chosen 2 packages - user has not checked the box marked Yes below terms of use - user has checked "no" below terms of use ok--------------------------------------------------------- 7- [login to view URL] will include Google title and Google desc - will include [login to view URL] which is the top part logo/rh menu/main-menu The text "looking for a cottage etc..." will be part of index and not part of [login to view URL] - The homepage will display the different listings according to the date they were listed originally, this is the date taken from col007 in main-db if user makes correction, the original date of his listing remains the same, it cannot be changed - on homepage, listings that are coded gold will come up in the right box - the listings coded silver will come up in the main space before listings coded basic, - At the bottom of homepage, user will be able to click on following pages (-1, -2, -3 etc...) to go through previous postings - The photo in position 1 that was uploaded with main-db will be resized at 160 pix wide keeping the same proportions - In the footer space, the ads will come from [login to view URL] - click on links will open new tab - On top of the rh column, there are 3 boxes to enter data the search box will look for listings that match the 3 criterias and will return them with the silver listings coming up first - In the box, as seen on sample, some suggested text will be already written in a light grey shade, this text will disappear as it is replaced by new text - In the right col of index and search, the ads will link to postings that are coded as gold The ads will be built as follows - on top, a thumb of the main pic sized max 160 x 160 respecting proportions - below this thumb, the text will be: In "#a" "#b" this "#c" sleeps "#d" in a "#e" location. #a is (town) #b is (greater area) #c is (Is it a cabin, chalet, lodge, condo) #d is (Sleeps how many) #e is (Type of location) - The text will come up in not more than 4 lines centered in cell. ok------------------------------------------------------------- 8- [login to view URL] The search page will return with the text "Search result for:" followed by the text that was entered as criteria - the page will come out as sample - image will be main image in 160 x 160 pix Title will be formed by This #a in #b sleeps #c in a #d location. #a what is it #b town #c sleeps #d location-type - then we will have the first 4 lines of desc followed by 3 dots - "View complete listing" will link to full posting that will open in new tab - script will look in rates tables under "length of stay" and return in date order the price for 3 different types of length of stay (For example: "week 4 nights", "weeks 7 nights", "weekend 2 nights", whatever user has written as long as they are 3 different types of stay) - if user only offers for 1 type of stay (ex only week) then script will only return week with the price for the nearest week - if date is obsolete or if no rates appear in user listing, script will display text "Please enquire" ok-------------------------------------------------------------------- 9- [login to view URL] Google title for each posting will come from main-db Google desc for each posting will come from main-db Below the header's menu, we have a phrase beginning with "Welcome", this phrase will be constructed from data found in main-db: The phrase is: Welcome to "#a", this "#b" located near "#c", "#d", it sleeps "#e" and is a "#f" location. #a is (Name of your property), if this box is empty, script will pass this item and display "Welcome to our #b etc..." #b is (a cabin, chalet, lodge, condo, cottage) #c is (town) #d is (Greater area) #e is (Sleeps how many) #f is (Type of location) Can we do a diaporama like the ones on this site's listing, [login to view URL] If this is too complicated, we'll do a simpler one, on top the photo in location 1 (300 x 300 pix) and below it, 8 thumbs (70 x 70 pix) of the 8 other photos, these thumbs will link to photos of 300 x 300 pix that will appear out of frame if there are less than 8 photos, they will be centered below the main photo. The data on the right side is taken from main-db: - contact - general info - where we are - items with no info will not appear on page Description of property This is for the text in the box "Description of your property" Commodities This will return the commodities that have been coded with a "y", those that are not coded with "y" will not return, I'd like a little box with a green check in it as on the sample Below those items returned, we will have text reading "More commodities:" followed by what user entered in "Here you can list more ..." The data will return in 4 col centered, as on sample Activities (summer, winter, year-round) will be coded as above The data will return in 4 col centered, as on sample Dates of availability I'm not sure how to do this What I want to show is current month plus next 3 months plus an arrow linking to a calendar for current and next 11 months Available dates will remain blank and unavailable dates will be grey Rental rates The posting will return with the rates sorted in date order it will update and not show obsolete dates the newest coming up first and the rows alternating between white and a light shade of grey Where we are Google map will show location following the zip code entered by user, no zip = no maps here Terms and conditions of rental Will show text as entered in box Get in touch with owner This email form will get the visitor in touch with user, it will also copy me with the message To prevent spamming, there will be a captcha code each ip will not be able to send more than 4 messages to my posters each ip will be blocked after 4 messages per day. Address of the sender will be compiled with his ip Email will be sent to the address user has entered in his posting Email will also be sent to me with IP of sender On top of email form, there will be owner's phone if he has listed one in his "Contact info" ok----------------------------------------------------------- 10- [login to view URL] - This is the page that user will see after posting his ad on the site The 1st link will be to his page - The line about the silver or gold package will only come up if the user has chosen one of these 2 packages - If user has chosen the basic package, the paragraph about gold/silver/package will not be on the page ok----------------------------------------------------------- 11- [login to view URL] and [login to view URL] Some pages will have footer and some will not I will be able to enter html code in there ok----------------------------------------------------------- 12- all pages will have the addthis link ok----------------------------------------------------------- 13- [login to view URL] - "photo" on upper rh menu will link to a page having header and [login to view URL] header3 will display a second menu (the 4 seasons) it will display like homepage with archive at bottom and a right col for ads it will present a catalogue of photos taken from [login to view URL] [login to view URL] will have 4 col - what folder the photo is in - text under photo - link to the bigger pic - note ok--------------------------------------------------------- 14- Every new listing will generate an email from site to me with a clickable url of new posting and email address of user Text: New listing at [login to view URL] url. Package chosen (basic or gold or silver) Can reach poster at: Email address of new poster which is the one entered in his form with asterisk beside When visitor emails the site, an email will be sent back telling him we have received his email and will get back to him soon. ok---------------------------------------------------------- 15- [login to view URL] this is where user will find the form to be able to send me an email ok---------------------------------------------------------- 16- [login to view URL] - User will get to a page where he will enter his email adress and pw, user will then get to his cpanel - if he forgot his password, he will click on link to "forgot-password" from where he will send us his email - script will then look for his pw and email it to the address on record (address with the asterisk beside it) ok---------------------------------------------------------- 17 [login to view URL] When user has forgotten his password, he will use the form [login to view URL] the script will look for his password in main-db and send it to the address he used when he registered if the email address he enters, is not found on main-db, a return email will tell him his email address was not found in our database and the email will ask him to get in touch with info@[login to view URL] ok------------------------------------------------------------ 18- [login to view URL] - will open in another tab - Will have same headers as the rest of site but with my text in there. - by clicking "Back to form" user will be taken back to his form with all of his entered data still there ok-------------------------------------------------------------- 19- [login to view URL] From my control panel, I will be able to download the whole main-db as an .xls sheet and make changes to it ok-------------------------------------------------------------- 20- As far as metrics, I want to know: - when a user is uploading or downloading his page and from what ip - what ads are being clicked on and on what day - the search terms that are used plus dates and ips - the messages sent by visitors plus dates and ips - all links that are clicked, on what date and from what ip ok-------------------------------------------------------------- 21- [login to view URL] this is what user's cpanel will look like - user will be able to download his listing for corrections and updates, he will be dowloading the listing as it is on the site which means incorporating the changes I may have made to his original listing - his listing will be downloaded on same form he used to upload his listing he will be able to make the changes on the form and reupload - if he clicks on Upgrade my listing to gold or silver, I will receive an email telling me so and he will receive an email telling him that I have received his email and will get back to him soon ok-------------------------------------------------------------- 22- You will help me organize the email portion of the site. I want to manage the emails online with Hotmail or Gmail or whatever app you suggest - I do not want any helper I might have to get into my server cpanel to get to the email portion of site ok-------------------------------------------------------------- 23- I will also need a template with the header on top and and footer on bottom on which I can add my own html ok-------------------------------------------------------------- 24- Security - Since users will be uploading their info directly on my server, either through the listing form or through the search box you need to ensure that there is something in the code to protect against any malicious code being injected in my server ? ok-------------------------------------------------------------- 25- In Canada, there is an English area and a French area mostly limited to the province of Quebec At first we will have only an english version but I want a French version later on any suggestions on how to do this ? ok-------------------------------------------------------------- 26- After developping and testing on your server, you will install the script and database on my server ok--------------------------------------------------------------