SEOClerks

Website developing needed!

Website developing needed!

We are looking for a website developer with both front end and back end experience, to create a website that will have a few public pages and several hidden pages. Part of the job will be the creation of a customized referral system and of a database.

We are a not-or-profit timeshare advocacy organization that helps members of the community with their timeshare needs, at no cost to them. We will be employing people from across the country to find and refer customers to us. As a result, we will need that our website contains the following.:
About 4 pages visible to the public (Home, About us, FAQ and Contact us).
A hidden page that will be accessible to prospective employees. On that page, they will find information as to how they can money with us. If they agree to the terms and conditions, they will be taken to another page that must contain an employment application form with several fields (name, DOB, address, phone number, email address, SSN and acceptance of the employment conditions) and a link to an interactive PDF W9 form (taxation form that is available online, and which contains interactive fields). They will be prompted to save the completed IRS form to their computer, email or mail us a copy, and send another copy to the IRS. As for the application for employment, it will be stored in our database. Once the employees complete all the necessary forms to work for us, they will be assigned a personal identification code and will be able to print business cards containing their name, their ID code, and some other information relevant to our business. When they find people who need assistance with their timeshares, they will hand them these business cards.
Customers will then access a page on our website (link specified on the business card given to them by their referrer), will read a brief description of how we can help them, then will be able to complete their personal details on a contact form (name, address, telephone and email address) and will have to input their referrer’s number as well. That will link them to their referrer on our database, so once we are able to assist those customers, their referrer will get paid for referring those customers to us. The referrers will be able to log in with their personal identification number, and have access to limited information about the progress of the case (that information will be in the form of pre-set notifications, such as ‘case started’, ‘payment pending’, ‘payment completed’, and maybe another couple of notifications). I will constantly update the database to make sure that the progress of the case is displayed.
So, in brief, we need an experienced web developer with both front end and back end experience that will build our website and create the public pages as well as the referral system and associated databases. The following pages will be needed:
Home page (public)
About us (public)
FAQ (public)
Contact Us (public)
Employee information page with link to employment application form (hidden page)
Employment application form, link to W9 form (hidden page). Completion of these forms by employee should result in the issuance of a personal identification code and the ability to print business cards (template to be discussed).
Customer access page with info about our organization and link to application form for assistance (hidden page).
Customer application form (derived from 7 above). Completion of this form by customer must link that customer to their referrer. (hidden page)
Log in page for referrer where they can view pre-set notifications about the progress of the case. (hidden page)Clearly, there will be a database to compile employees/referrers and customers’ info. We currently have 1GB of Cloud storage with our IPage website, we will expand that storage on a need basis. I will have access to the databases, and the option to update cases with pre-set notifications for the benefit of the referrers.


Requirements

We expect the job to be done according to our requirements within 2-3 weeks at the most, and to be constantly updated and consulted on the progress. Contract conditions to be clearly specified before we commit to hiring a specialist. We will consider, in priority, specialists with proven experience and great customer satisfaction rating.


Skills Required

Programming Webdeveloping

Bids

i will give website developing

if you do not work, the money will be refunded.

plz order now

hi there, i am a professional website developer i have 6 years experience in website developing, i have advance skills in adobe photoshop, illustrator and dreamweaver. there are nothing to lose, so why you waiting order me now.........

thanks

order me i am ready for this i am start your work instant.

i will develop a secured modern wordpress website or blog 215$

Bid On Listing Created 11 years ago in Design

Other jobs by sophiedufort

Order Now
Process Time: 0.18492197990417

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='21226' AND A.category=B.CATID AND A.USERID=C.USERID1SELECT A.*, B.name, B.seo, C.username, C.userlevel, C.footer_code, C.rating, C.ratingcount, C.googleplus_profile, C.total_recommendations, C.USERID, C.profilepicture, C.average_response_time, C.lastlogin, C.addtime FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='21226' AND A.category=B.CATID AND A.USERID=C.USERID

/opt/clerks-staging/docroot/viewwant.php 163 () ()

SELECT * FROM ratings_buyer WHERE USERID=2755071SELECT sum(good) as thumbup, sum(bad) as thumbdown FROM ratings_buyer WHERE USERID=275507

/opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() ()

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 21226 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Programming Webdeveloping%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 21226 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Programming Webdeveloping%' ) LIMIT 4

/opt/clerks-staging/docroot/viewwant.php 551 () ()

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 21226 AND A.category=B.CATID AND A.active=1 AND A.USERID=275507 LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 21226 AND A.category=B.CATID AND A.active=1 AND A.USERID=275507 LIMIT 4

/opt/clerks-staging/docroot/viewwant.php 568 () ()

SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='21226' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc1SELECT a.comment, a.USERID, a.CID, a.time_added, a.istranslated, a.parentid, b.username, b.profilepicture FROM wantcomments a, seoclerks.members b WHERE a.PID='21226' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc

/opt/clerks-staging/docroot/viewwant.php 835 () ()

UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='21226'1UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='21226'

/opt/clerks-staging/docroot/include/functions/main.php 1729 update_wantviewcount() ()

SELECT * FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='21226' ORDER BY w.bidid ASC 1SELECT w.bidid, w.PID, w.comment, w.title, w.pricepublic, w.USERID, w.adjustedprice, w.ip, m.profilepicture FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='21226' ORDER BY w.bidid ASC

/opt/clerks-staging/docroot/viewwant.php 1192 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=2745171SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=274517

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=2621471SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=262147

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=2486401SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=248640

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=1928971SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=192897

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM categories_wanttobuy1SELECT * FROM categories_wanttobuy

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

SELECT * FROM posts WHERE USERID=2755071SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=275507

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * from categories_software order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()

select * from categories_wanttobuy order by name asc1select * from categories_wanttobuy order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()

select * from categories_wanttotrade order by name asc1select * from categories_wanttotrade order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()

SELECT * FROM seoclerks.members WHERE USERID='274517'1SELECT profilepicture FROM seoclerks.members WHERE USERID='274517'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='262147'1SELECT profilepicture FROM seoclerks.members WHERE USERID='262147'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='248640'1SELECT profilepicture FROM seoclerks.members WHERE USERID='248640'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='192897'1SELECT profilepicture FROM seoclerks.members WHERE USERID='192897'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='275507'1SELECT profile_data FROM seoclerks.members WHERE USERID='275507'

/opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
0.1480381SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Headway%' OR A.skills LIKE '%Headway%') ORDER BY A.lastgigedit desc LIMIT 0,400.1480380.148038
0.1158481SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Headway%' OR A.skills LIKE '%Headway%')0.1158480.115848
0.1116621SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 21226 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Programming Webdeveloping%' ) LIMIT 40.1116620.111662