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.