commit c8f3966da6f127b52867bb8c42ff08372549fff3
Author: Federico Gimenez <address@hidden>
Date:   Mon Oct 27 10:42:59 2008 +0100

    Added OfferDate field to the updateJobOffer method, with the current date

diff --git a/Layer-5__DB_operation/Job_Offer.php b/Layer-5__DB_operation/Job_Offer.php
index 421109b..17a4cd8 100644
--- a/Layer-5__DB_operation/Job_Offer.php
+++ b/Layer-5__DB_operation/Job_Offer.php
@@ -406,7 +406,9 @@ class JobOffer
 				$VacancyTitle = isset($_POST['VacancyTitle']) ? trim($_POST['VacancyTitle']) : '';
 				$Description = isset($_POST['Description']) ? trim($_POST['Description']) : '';
 
-				$sqlQuery = "PREPARE query(text,date,bool,bool,bool,bool,bool,text,text,text,bool,integer) AS  UPDATE J1_JobOffers SET J1_EmployerJobOfferReference=$1,J1_ExpirationDate=$2,J1_Closed=$3,J1_HideEmployer=$4,J1_AllowPersonApplications=$5,J1_AllowCompanyApplications=$6,J1_AllowOrganizationApplications=$7,J1_Vacancies=$8,J1_VacancyTitle=$9,J1_Description=$10,J1_CompletedEdition=$11 WHERE J1_Id=$12;  EXECUTE query('".pg_escape_string($EmployerJobOfferReference)."','".pg_escape_string($ExpirationDate)."','$Closed','$HideEmployer','$AllowPersonApplications','$AllowCompanyApplications','$AllowOrganizationApplications','".pg_escape_string($Vacancies)."','".pg_escape_string($VacancyTitle)."','".pg_escape_string($Description)."','$completedEdition','$J1_Id');";
+				$OfferDate=date("Y/m/d");
+
+				$sqlQuery = "PREPARE query(text,date,bool,bool,bool,bool,bool,text,text,text,date,bool,integer) AS  UPDATE J1_JobOffers SET J1_EmployerJobOfferReference=$1,J1_ExpirationDate=$2,J1_Closed=$3,J1_HideEmployer=$4,J1_AllowPersonApplications=$5,J1_AllowCompanyApplications=$6,J1_AllowOrganizationApplications=$7,J1_Vacancies=$8,J1_VacancyTitle=$9,J1_Description=$10,J1_OfferDate=$11,J1_CompletedEdition=$12 WHERE J1_Id=$13;  EXECUTE query('".pg_escape_string($EmployerJobOfferReference)."','".pg_escape_string($ExpirationDate)."','$Closed','$HideEmployer','$AllowPersonApplications','$AllowCompanyApplications','$AllowOrganizationApplications','".pg_escape_string($Vacancies)."','".pg_escape_string($VacancyTitle)."','".pg_escape_string($Description)."','".pg_escape_string($OfferDate)."','$completedEdition','$J1_Id');";
 				$this->postgresql->execute($sqlQuery,1);
 			break;