Website coded with PHP and MySql

Slutfört Publicerat Nov 3, 2010 Betalades vid leverans
Slutfört Betalades vid leverans

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 [url removed, login to view]

- 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 [url removed, login to view]

3- Renters will be able to search the database for cottages that meet their needs

## Deliverables

[url removed, login to view] 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 [url removed, login to view]

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

[url removed, login to view] will consist of logo + rh menu + main menu

all pages will have [url removed, login to view] on top

[url removed, login to view]

will appear after [url removed, login to view] on some pages

[url removed, login to view]

will appear after [url removed, login to view] on some other pages

ok---------------------------------------------------------

5- [url removed, login to view]

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 [url removed, login to view] will take their labels from that second row

This appplies to "commodities", and "activities to do in the area"

ok----------------------------------------------------

5- [url removed, login to view]

Each box on this form will fill a cell in a row on [url removed, login to view]

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 [url removed, login to view]

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- [url removed, login to view]

will include Google title and Google desc

- will include [url removed, login to view] 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 [url removed, login to view]

- 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 [url removed, login to view]

- 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- [url removed, login to view]

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- [url removed, login to view]

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, [url removed, login to view]

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- [url removed, login to view]

- 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- [url removed, login to view] and [url removed, login to view]

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- [url removed, login to view]

- "photo" on upper rh menu will link to a page having header and [url removed, login to view]

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 [url removed, login to view]

[url removed, login to view] 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 [url removed, login to view] 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- [url removed, login to view]

this is where user will find the form to be able to send me an email

ok----------------------------------------------------------

16- [url removed, login to view]

- 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 [url removed, login to view]

When user has forgotten his password, he will use the form [url removed, login to view]

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@[url removed, login to view]

ok------------------------------------------------------------

18- [url removed, login to view]

- 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- [url removed, login to view]

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- [url removed, login to view]

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--------------------------------------------------------------

Amazon Web Services Apple Safari Ingenjörsvetenskap Google Chrome MySQL PHP Projektledning Programvaruarkitektur Programvarutestning

Projekt-id: #3832424

About the project

32 offerter Distansprojekt Aktivt Nov 9, 2010

Tilldelades:

tiagobs

See private message.

$340.01 USD inom 83 dagar
(82 omdömen)
5.9

32 frilansare har lagt bud på i genomsnitt $1266 för det här jobbet

NetzPro

See private message.

$1487.5 USD inom 83 dagar
(394 omdömen)
8.7
LeadSoft

See private message.

$3017.5 USD inom 83 dagar
(35 omdömen)
7.9
alitharwani

See private message.

$1232.5 USD inom 83 dagar
(269 omdömen)
7.8
skylane

See private message.

$1487.5 USD inom 83 dagar
(281 omdömen)
7.7
ilicotech

See private message.

$1870 USD inom 83 dagar
(70 omdömen)
7.4
WiPage

See private message.

$2550 USD inom 83 dagar
(170 omdömen)
6.9
shakeebgenii

See private message.

$1020 USD inom 83 dagar
(188 omdömen)
6.7
macropaks

See private message.

$1444.15 USD inom 83 dagar
(98 omdömen)
6.4
beeinfo

See private message.

$1530 USD inom 83 dagar
(102 omdömen)
6.4
tonythksl

See private message.

$2125 USD inom 83 dagar
(111 omdömen)
6.1
gisterpages

See private message.

$1445 USD inom 83 dagar
(58 omdömen)
6.1
Alioth

See private message.

$977.5 USD inom 83 dagar
(48 omdömen)
5.8
ssharma1622

See private message.

$2125 USD inom 83 dagar
(96 omdömen)
5.7
mvmithraa

See private message.

$850 USD inom 83 dagar
(68 omdömen)
5.4
moamenm

See private message.

$499.8 USD inom 83 dagar
(38 omdömen)
5.3
devbavi

See private message.

$467.5 USD inom 83 dagar
(68 omdömen)
5.0
qasimbilal

See private message.

$637.5 USD inom 83 dagar
(22 omdömen)
4.3
xtreamrohit

See private message.

$510 USD inom 83 dagar
(5 omdömen)
4.0
siega

See private message.

$552.5 USD inom 83 dagar
(13 omdömen)
3.5
aamerjamallx

See private message.

$1275 USD inom 83 dagar
(11 omdömen)
3.3