function renderNewForm($username)
{
$userToken = new UserToken();
$userToken->constructUserInfo($username);
$statement = "INSERT INTO pa_form_data " . "(form_username, survey_uid, staff_name, is_senior, staff_department, staff_position, " . "staff_office, survey_commencement_date, appraiser_name, countersigner_name, survey_period, survey_type, countersigner_1_name, " . "countersigner_2_name) " . "VALUES (:username, :uid, :fullName, :isSenior, :department, :position, :office, :commenceDate, :appraiserFullName, :bothCounter, :survey_period, :survey_type, :counter1, :counter2)";
$query = $this->dbConnection->prepare($statement);
$query->bindValue(':username', $userToken->username);
$query->bindValue(':uid', $this->uid);
$query->bindValue(':fullName', $userToken->fullName);
$query->bindValue(':isSenior', $userToken->isSenior);
$query->bindValue(':department', $userToken->department);
$query->bindValue(':position', $userToken->position);
$query->bindValue(':office', $userToken->office);
$query->bindValue(':commenceDate', $userToken->commenceDate);
$query->bindValue(':appraiserFullName', $userToken->appraiserFullName);
$query->bindValue(':counter1', $userToken->countersignerFullName1);
$query->bindValue(':counter2', $userToken->countersignerFullName2);
if (!empty($userToken->countersignerFullName1) && !empty($userToken->countersignerFullName2)) {
$jointString = $userToken->countersignerFullName1 . " & " . $userToken->countersignerFullName2;
} else {
$jointString = $userToken->countersignerFullName1 . $userToken->countersignerFullName2;
}
$query->bindValue(':bothCounter', $jointString);
$query->bindValue(':survey_period', $userToken->availiblePeriod['period']);
//Need to throw an Exception here later if there is not active survey
$query->bindValue(':survey_type', $userToken->availiblePeriod['type']);
$query->execute();
$statement = "INSERT IGNORE INTO pa_part_a SET form_username = :username, survey_uid = :uid, question_no = :no";
$query = $this->dbConnection->prepare($statement);
$query->bindValue(':username', $userToken->username);
$query->bindValue(':uid', $this->uid);
$query->bindParam(':no', $i);
for ($i = 1; $i <= 3; $i++) {
$query->execute();
}
}
