Project: Add fields/Search UK postcodes ID: 1216456358

PROJECT DETAILS

	Status:	Closed (Cancelled)
	Budget:	N/A
	Created:	7/19/2008 at 4:32 EST
	Cancelled:	7/24/2008 at 5:12 EST
	Project Creator:	magicmarkuk Rating: (2 reviews)
	Description:	Continued work on a job site - this phase is the alteration of the datafields and associated search functionality. Fields to rename (in file /development/include/ui_texts_en.php) i.e. we are renaming the labels rather than the database fields themselves: Location > County Zip > Postcode Salary > Price (Excl VAT) Text > Details Date Available > Date New database fields required: 'Town / City' - (text field) 'CPD Hours' - (numeric? - but could need to contain a decimal place e.g. 3.5 unless in the format HH:MM so that 3.5 hours would be entered as 03:30) 'Members Price (Excl VAT)' - (numeric? - but could contain a decimal place e.g. 150.00) 'Course Reference (if applicable)' - (text field) 'Level' (text field with drop down list as below) 'Time From' - (time in 24hr format e.g. 09:00) 'Time To' - (time in 24hr format e.g. 17:00) 'Duration' - (text field with drop down list as below) Field values: 'Level' Not selected Introduction Intermediate Advanced Duration Not selected Half Day 1 day 2 days 3 days 4 days 5 days Fields should be ordered on 'New Course Ads' page (/development/EMPLOYERS/index.php) and the modify page (/development/EMPLOYERS/index.php?category=postings&folder=my) as follows: (Note - new field names used here) Subject County Town / City Postcode Date Time From Time To (Check that Time To is greater or equal to Time From i.e. so that if it is not selected you could have 00:00 to 00:00) Duration CPD Hours Level Course Title Course Reference (if applicable) Course Type Details Price (Excl VAT) Members Price (Excl VAT) Contact Active Notification Fields should be ordered on the search results page (/development/index.php?mod=search&job=) Course Title Date Time From 'to' Time To followed by <hr />and then Details Town / City Postcode CPD Hours Level Course Reference Course Type Price (Excl VAT) Members Price (Excl VAT) Company Company Description Company Website Need to amend the export/import facility (when logged in as an employer - under My Course Ads - 'Export or Import Course Ads') to ensure these still work after the new fields have been added. Currently this can be verified by exporting and then importing straght back in. The 'Search in the course ads' box that appears on the main page (/development/index.php) should contain the following fields that can be searched on either individually or combined: Course Title Details Subject (see related drop down) County (see related drop down) Town / City Date (could do with a To and From so that users could check for courses from say 01/08/2008 through to 31/08/2008) Duration (see related drop down) CPD Hours (could do with a choice say <3, <7, <14 or users specifiy to and from bearing in mind the field can have a decimal place) Level (see related drop down) Course Reference Course Type (see related drop down) Company only ads in radius of x miles or kilometres from Postcode This latter part relating to postcodes and the ability on the home page to search within a radius of a particular psotcode (zip) works fine for US zip codes but not for UK post codes because of the difference in the way UK postcodes work. It isn't possible to have a full database of all UK postcodes – there are too many and they are expensive – the alternative is to compare on the first part of the postcode which refers to an area. We only need the first part of the post code that the user enters on the home page, so we must trim them accordingly. The second part of the UK post code is always 3 characters (first part can either be 2, 3, or even 4 characters). So, we need to remove all spaces and then trim 3 characters off the end to give us the first part: <?php #Convert the post code to upper case and trim the variable $postcode = strtoupper(trim($postcode)); #Remove any spaces $postcode = str_replace(" ","",$postcode); #Trim the last 3 characters off the end $postcode_first = substr($postcode,0,strlen($postcode)-3); ?> The above code shows $postcode and $postcode_first whereas in the script $zip and possibly $zip1 is used. The postcodes in the database for each course will also have be entered fully so when being evaluated will need the same process applied to them (possibly referred to as $zip2) The code for calculating the distance can be found in the following file /development/include/distance.php If you are not sure about how the calculations work an overview can be found here that is similar http://www.acmultimedia.co.uk/blog/article.php?blogID=59 The file with the UK postcodes is on the server here (/development/includes/uk_zips.txt) together with the original US zip file (/development/includes/zips.txt A preferable solution would be to utilise googlemaps and be able to compare within a radius of a UK town or postcode. Please indicate in your bid which approach you would take. If you have any questions please do not hesitate to contact me.
	Job Type:	PHP MySQL

Messages Posted: 9

PROJECT BIDS

	Programmers	Bid	Delivery Within	Time of Bid	Rating
	fmfsolutions	$150	3 days	7/20/2008 at 13:42 EST	(2 reviews)
	Hi.. I am very experienced PHP developer and can these modifications and adding according to your requirements. I possess good understanding of googlemaps so we shall use googlemap and identify radius of UK towns to find distance. Hope to work with you soon. Regards
	vivekarora	$190	5 days	7/20/2008 at 3:55 EST	(No Feedback Yet)
	Ready for that
	yagnes	$200	3 days	7/20/2008 at 4:14 EST	(No Feedback Yet)
	We are team of professionals expertise in developing web based application using PHP/ASP/.NET /J2EE and Cold fusion and in web designing using Photoshop, Dreamweaver MX, Flash MX.After reading your project description, we are highly interested to develop the application for you. Please feel free to contact me through PMB for any clarifications required. Regards, Yagneswaran.T.
	briskglobal	$200	5 days	7/20/2008 at 3:07 EST	(No Feedback Yet)
	I can do this work.
	eiger7703	$200	7 days	7/19/2008 at 5:37 EST	(1 review)
	I'm ready to do this job
	thescript	$219	10 days	7/20/2008 at 13:02 EST	(No Feedback Yet)
	Hi, We are a large team of professional coders and can help with these requirements and will deliver your needs in very short time. We carefully read all yours requirements and we can start immediately. Be free to contact us for further details even to negotiate for the price. Thanks, TheScript.org Team
	diggera	$250	3 days	7/19/2008 at 5:40 EST	(10 reviews)
	Hello. Only professional work. Not an "indian" code. If you interested let me know. Thanks.
	shiv2144	$250	5 days	7/19/2008 at 5:27 EST	(2 reviews)
	Hi i can do this professionally. Thanks
	softechblr	$250	5 days	7/19/2008 at 7:09 EST	(12 reviews)
	can be done.
	creativedart	$280	6 days	7/19/2008 at 6:13 EST	(No Feedback Yet)
	We will complete your project with experience, affordable cost and very less time. Thank You
	jameskap	$285	2 days	7/19/2008 at 5:23 EST	(11 reviews)
	It Can be Done,i have Go through your Details,we are ready to Work with you.Please View PMB..
	wincent	$300	3 days	7/19/2008 at 5:18 EST	(67 reviews)
	all can be done.
	arsum	$370	7 days	7/21/2008 at 9:20 EST	(No Feedback Yet)
	Hello, We are Arsum company which can do this task with high quality, quickly and no bugs. See us at: www.arsum.com
	phpscriptscustomizer	$400	7 days	7/19/2008 at 13:57 EST	(54 reviews)
	Please check PMB.
	vgroup	$450	7 days	7/19/2008 at 5:13 EST	(4 reviews)
	We can do it. Expert team for this task. Please view our previous work.
	coderextraordinaire	$450	10 days	7/19/2008 at 6:38 EST	(147 reviews)
	pls chk pmb