function doUp()
{
global $database;
if (DBSchema::existsTable($database, "JobPage")) {
$res = DB::query("SELECT * FROM JobPage;");
foreach ($res as $record) {
$new_job = new Job();
$new_job->ID = (int) $record['ID'];
$new_job->Title = $record['Title'];
$new_job->Description = $record['Content'];
$new_job->Created = $record['Created'];
$new_job->LastEdited = $record['LastEdited'];
$new_job->PostedDate = $record['JobPostedDate'];
$new_job->ExpirationDate = $record['ExpirationDate'];
// company name logic
$company_name = $record['JobCompany'];
$company = Company::get()->filter('Name', $company_name)->first();
$new_job->CompanyID = is_null($company) ? 0 : $company->ID;
if ($new_job->CompanyID == 0) {
$new_job->CompanyName = $company_name;
}
$new_job->MoreInfoLink = $record['JobMoreInfoLink'];
$new_job->Location = $record['JobLocation'];
$new_job->IsFoundationJob = $record['FoundationJob'];
$new_job->IsActive = $record['Active'];
$new_job->Instructions2Apply = $record['JobInstructions2Apply'];
$new_job->LocationType = $record['LocationType'];
$new_job->IsCOANeeded = 0;
$new_job->TypeID = 0;
//registration request
$registration_request = JobRegistrationRequest::get()->filter('Title', $new_job->Title)->first();
if (!is_null($registration_request)) {
$new_job->RegistrationRequestID = $registration_request->ID;
}
$new_job->write();
}
DBSchema::dropTable($database, "JobPage");
}
}
