238631 Php fields/UK postcodes

Continued work on a job site - this phase is the alteration of the datafields and associated search functionality including job alerts. Fields to rename (in file /development/include/[login to view URL]) 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/[login to view URL]) and the modify page (/development/EMPLOYERS/[login to view URL];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/[login to view URL];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/[login to view URL]) 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/[login to view URL] If you are not sure about how the calculations work an overview can be found here that is similar [login to view URL] The file with the UK postcodes is on the server here (/development/includes/[login to view URL]) together with the original US zip file (/development/includes/[login to view URL] 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. Finally, the system generates job alerts (which will be rename to course alerts) based on a limited number of selection/serach criteria. This needs expanding so that the job alerts can be set up using the same criteria as the 'Search in the course ads' box aboe, i.e. a combination of: 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 Additionally, the course alerts currently get sent each time a new course matching the criteria is added. It would be useful if users could have a choice as to the frequency e.g. automatic, daily or weekly. This would however mean that the information sent would need to change i.e. possibly more than one course posting be included in the email. The format of this email also needs amending to show course title, date, town / city. If you have any questions please do not hesitate to contact me.