![]() ![]() |
Home |
How it works |
Projects archive |
Contact Us Air Compressor Bot |
|
| The Career Path of Freelance Programming Jobs |
Php Jobsite - Field Amendment |
![]() |
Bidding Time: |
15/07/2008 08:43 - 29/07/2008 08:43 |
Budget: |
N/A |
Status: |
Closed |
|
|
|
Job Type: |
|
Description: |
Basic details are as follows: 1. The script being used is designed for job/recruitment sites. However, I am going to use it for a site that advertises courses rather than jobs – the basic principles being the same. 2. The requirement is for courses to expire (i.e. not longer show) once the date of the course has passed e.g. if the course is to take place on the 30 July 2008 then the advert should expire on 31 July 2008. 3. The software currently provides for ads to expire based on the ‘package' a seller uses to post an advert – currently this is set to 30 days – so the advert will remain live for 30 days from the date of posting and then become expired. The code for this is as follows (depending on whether the site is set to charge or not - but for this purpose is not relevant) if($FREE_WEBSITE) { $arrNames2 = array("date","employer","expires"); $arrValues2 = array(time(),$AuthUserName, (time() + $FREE_WEBSITE_ADS_EXPIRE_DAYS*86400) ); } else { $arrNames2 = array("date","employer","expires"); $arrValues2 = array(time(),$AuthUserName, (time() + $arrPackageEmployer["valid"]*86400) ); } The default value for $FREE_WEBSITE_ADS_EXPIRE_DAYS is 30 days and the current default value for $arrPackageEmployer["valid"] is also 30 days. The problem with this is that it takes no account of the date of the course so courses could continue to be displayed after they have taken place! 4. One of the fields when adding a course is ‘Date Available' which I will effectively use as ‘Date of Course'. 5. When a course becomes expired it shows the on the ‘Expired Ads' tab. The code for determining whether ads are expired appears to be: if(SQLCount("ext_postings","WHERE employer='$AuthUserName' AND expires<".time()."") == 0) 6. The ideal solution would be: a. Remove the code in point 3 so that ‘expires' is not set based on the package. b. Amend the properties of the field ‘date_available' so that it is in the same format within the database as ‘expires' and if a date is entered by the user of say 31/07/08 this is translated into a date/time equivalent to 31/07/08 and 23:59 i.e. the very end of the day or perhaps 01/08/08 00:00? (It may also need the input form to check for a valid date) c. Amend the code in 5 to compare against ‘date_available' rather than ‘expires' d. I would then go through and amend any other code lines like 5 to ‘date_available' to ensure consistency e. I can then also list courses with the ‘date_available' field showing rather than ‘date' which is currently the case (‘date' being the date the job/course was entered) If you require further details please ask but should be a quick piece of work for the right person. Related Projects: This project is the proprietary information of .
Click here to remove this project from OUR database.
|
Operating System: |
N/A |
Database System: |
N/A |
| <<< back |
|
| Home | Projects archive | RSS | Resources | Links | Contact Us | © 2004-2008 ProjectsList.biz /0.452 |