function displayEmergencyContact($username, $relationships, $status)
{
$message = "";
if ($status == "fail") {
$message = "<div class='alert alert-dismissible alert-danger'>\r\n <button type='button' class='close' data-dismiss='alert'>×</button>\r\n A technical issue occurred during submission. Please try again.\r\n </div>";
} elseif ($status == "success") {
$message = "<div class='alert alert-dismissible alert-success'>\r\n <button type='button' class='close' data-dismiss='alert'>×</button>\r\n Emergency contact information successfully saved.\r\n </div>";
}
try {
$connection = new PDO("mysql:host=" . DB_HOST_NAME . ";dbname=" . DB_NAME . ";charset=utf8", DB_USER_NAME, DB_PASSWORD);
// Exceptions fire when occur
$connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$emergencyContactQuery = $connection->query('
SELECT ME.FIRSTNAME, ME.LASTNAME, ME.PHONE, ME.RELATIONSHIP, ME.EMERGENCY_CONTACT_ID
FROM ' . USER_CREDENTIAL_TABLE . ' M INNER JOIN ' . EMERGENCY_CONTACTS_TABLE . ' ME ON ME.MEMBER_ID = M.MEMBER_ID
WHERE M.MEMBER_EMAIL = ' . $connection->quote($username));
$emergencyContact = $emergencyContactQuery->fetch();
echo '<div class="row-fluid">
<div class="well bs-component">
<form method="post" action="./" id="emergency_contact_update">
<legend style="font-weight: bold; color:#ffffff">EMERGENCY CONTACT</legend>' . $message . '<div>
<div class="form-group row">
<label class="col-lg-2 control-label">First name</label>
<div class="col-lg-8">
<input type="text" name="firstName" value="' . htmlentities($emergencyContact[0], ENT_QUOTES) . '" class="form-control" required/>
</div>
</div>
<div class="form-group row">
<label class="col-lg-2 control-label">Last name</label>
<div class="col-lg-8">
<input type="text" name="lastName" value="' . htmlentities($emergencyContact[1], ENT_QUOTES) . '" class="form-control" required/>
</div>
</div>
<div class="form-group row">
<label class="col-lg-2 control-label">Phone number</label>
<div class="col-lg-8">
<input type="tel" name="phone" value="' . preg_replace("/^(\\d{3})(\\d{3})(\\d{4})\$/", "\$1-\$2-\$3", $emergencyContact[2]) . '" pattern="(?:\\(\\d{3}\\)|\\d{3})[- ]?\\d{3}[- ]?\\d{4}" maxlength="13" class="form-control" required/>
</div>
</div>
<div class="form-group row">
<label class="col-lg-2 control-label">Relationship</label>
<div class="col-lg-8">
<select name="relationship" class="form-control">' . createRelationshipsOptions($relationships, $emergencyContact[3]) . '</select>
</div>
</div>
<div>
<input type="hidden" name="emergencyContactID" value="' . $emergencyContact[4] . '" />
<input type="hidden" name="submit" value="TRUE" />
<input type="submit" value="Save changes" class="btn btn-default" />
</div>
</div>
</form>
</div>
</div>';
} catch (PDOException $e) {
echo "\r\n <div>\r\n Error: " . $e->getMessage() . "</div>";
return FALSE;
}
}
function displayAccountForm($status, $us_state_abbrevs, $relationships)
{
$notice = "";
if ($status == "success") {
$notice = "<div class='alert alert-success alert-dismissable'>\n <button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>\n Account and emergency contact information updated.\n </div>";
} elseif ($status == "fail") {
$notice = "<div class='alert alert-danger alert-dismissable'>\n <button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>\n Account information not updated. Please choose a different email address.\n </div>";
} elseif ($status == "tech_diff") {
$notice = "<div class='alert alert-danger alert-dismissable'>\n <button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>\n There was a problem updating the account information. Please try again.\n </div>";
}
try {
$connection = new PDO("mysql:host=" . DB_HOST_NAME . ";dbname=" . DB_NAME . ";charset=utf8", DB_USER_NAME, DB_PASSWORD);
// Exceptions fire when occur
$connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$accountInformationQuery = $connection->query('
SELECT M.MEMBER_ID, M.MEMBER_EMAIL, M.FIRSTNAME, M.LASTNAME, M.ADDRESS, M.CITY, M.STATE, M.ZIP, M.PHONE, M.NOTES, M.ADMIN_NOTES, M.PASSWORD, M.DUEDATE, M.ACTIVESTATUS, ME.FIRSTNAME, ME.LASTNAME, ME.PHONE, ME.RELATIONSHIP, ME.EMERGENCY_CONTACT_ID
FROM ' . USER_CREDENTIAL_TABLE . ' M INNER JOIN ' . EMERGENCY_CONTACTS_TABLE . ' ME ON ME.MEMBER_ID = M.MEMBER_ID
WHERE M.MEMBER_ID = ' . $connection->quote($_POST["buttonMemberID"]));
$accountInformation = $accountInformationQuery->fetch(PDO::FETCH_NUM);
echo "<form action='edit.php' method='post'>\n <h3> Editing " . $accountInformation[2] . " " . $accountInformation[3] . "</h3></br>" . $notice . "<input type='text' name='buttonMemberID' value='" . $_POST["buttonMemberID"] . "' hidden>\n <table style='width:75%'>\n <tr>\n <td>First Name: <input type='text' name='fname' value='" . htmlentities($accountInformation[2], ENT_QUOTES) . "' required /></td>\n <td>Last Name: <input type='text' name='lname' value='" . htmlentities($accountInformation[3], ENT_QUOTES) . "' required /></td>\n <td>Dues Paid Until: <input type='date' name='duedate' value='" . $accountInformation[12] . "' placeholder='YYYY-MM-DD' required /></td>\n <td>Member Status: <select name='status' >\n <option value='active'>Active</option>\n <option value='inactive'";
if ($accountInformation[13] == '0') {
echo "selected>Inactive</option> </select> </td></tr>";
} else {
echo ">Inactive</option> </select> </td></tr>";
}
echo "<tr>\n <td> </br>Street Address: <input type='text' name='address' value='" . htmlentities($accountInformation[4], ENT_QUOTES) . "' required></td>\n <td></br>City: <input type='text' name='city' value='" . htmlentities($accountInformation[5], ENT_QUOTES) . "' required></td>\n <td>\n </br>State: \n <select name='state' required>" . createStateAbbrevOptions($us_state_abbrevs, $accountInformation[6]) . "</select>\n </td>\n <td></br>Zip Code: <input type='text' name='zip' value='" . $accountInformation[7] . "' required /></td>\n </tr>\n <tr>\n <td> </br>Phone Number: <input type='text' name='phone' value='" . preg_replace('/^(\\d{3})(\\d{3})(\\d{4})$/', '$1-$2-$3', $accountInformation[8]) . "' pattern='(?:\\(\\d{3}\\)|\\d{3})[- ]?\\d{3}[- ]?\\d{4}' maxlength='14' required/></td>\n <td></br>Email Address: <input type='text' name='email' value='" . htmlentities($accountInformation[1], ENT_QUOTES) . "' required></td>\n </tr>\n </table>\n <br />\n <div style='width:50%'>\n Member Viewable Notes:</br> \n <textarea rows='4' cols='100' name='notes'>" . htmlentities($accountInformation[9], ENT_QUOTES) . "</textarea>\n </div>\n <div style='width:50%'>\n Administrator Notes:</br>\n <textarea rows='4' cols='100' name='adminnotes'>" . htmlentities($accountInformation[10], ENT_QUOTES) . "</textarea>\n </div>\n <hr />\n <h4>Emergency Contact</h4>\n <table style='width:50%'>\n <tr>\n <td>First Name: <input type='text' name='emergency_fname' value='" . htmlentities($accountInformation[14], ENT_QUOTES) . "' required /></td>\n <td>Last Name: <input type='text' name='emergency_lname' value='" . htmlentities($accountInformation[15], ENT_QUOTES) . "' required /></td>\n <td>Phone Number: <input type='text' name='emergency_phone' value='" . preg_replace('/^(\\d{3})(\\d{3})(\\d{4})$/', '$1-$2-$3', $accountInformation[16]) . "' pattern='(?:\\(\\d{3}\\)|\\d{3})[- ]?\\d{3}[- ]?\\d{4}' maxlength='14' required/></td>\n <td>Relationship <select name='emergency_relationship'>" . createRelationshipsOptions($relationships, $accountInformation[17]) . "</select></td>\n </tr>\n </table>\n <hr />";
} catch (PDOException $e) {
echo "\n <div>\n Error: " . $e->getMessage() . "</div>";
}
}
function displayForm($us_state_abbrevs, $relationships, $status, $submittedFirstName, $submittedLastName, $submittedDuesDate, $submittedStreet, $submittedCity, $submittedState, $submittedZip, $submittedPhone, $submittedEmail, $submittedAdminNotes, $submittedEmergencyFirstName, $submittedEmergencyLastName, $submittedEmergencyPhone, $submittedEmergencyRelationship)
{
$notice = "";
if ($status == "success_manual") {
$notice = "<div class='alert alert-success alert-dismissable'>\n <button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>\n User successfully created.\n </div>";
} elseif ($status == "success_auto") {
$notice = "<div class='alert alert-success alert-dismissable'>\n <button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>\n User successfully created. A welcome email with instructions to reset his/her password was sent.\n </div>";
} elseif ($status == "fail_email") {
$notice = "<div class='alert alert-danger alert-dismissable'>\n <button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>\n There was a problem creating this user. Please choose a different email address and try again.\n </div>";
} elseif ($status == "fail_password") {
$notice = "<div class='alert alert-danger alert-dismissable'>\n <button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>\n There was a problem creating this user. Please follow the password requirements and try again.\n </div>";
} elseif ($status == "tech_diff") {
$notice = "<div class='alert alert-danger alert-dismissable'>\n <button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>\n There was a problem creating this user. Please try again.\n </div>";
}
echo "<form action='add.php' method='post'>\n <h3> Add a Member</h3></br>" . $notice . "<div>\n First Name: <input type='text' name='fname' value='" . htmlentities($submittedFirstName, ENT_QUOTES) . "' required />\n Last Name: <input type='text' name='lname' value='" . htmlentities($submittedLastName, ENT_QUOTES) . "' required />\n Dues End Date: <input type='date' name='duesdate' placeholder='YYYY-MM-DD' value='" . $submittedDuesDate . "' required />\n </div><br />\n <div>\n Street Address: <input type='text' name='street' value='" . htmlentities($submittedStreet, ENT_QUOTES) . "' required />\n City: <input type='text' name='city' value='" . htmlentities($submittedCity, ENT_QUOTES) . "' required />\n State:\n <select name='state'>" . createStateAbbrevOptions($us_state_abbrevs, $submittedState) . "</select>\n Zip Code: <input type='text' name='zip' value='" . htmlentities($submittedZip, ENT_QUOTES) . "' maxlength='5' required />\n </div><br />\n <div>\n Phone Number: <input type='text' name='phone' value='" . $submittedPhone . "' required />\n Email Address: <input type='text' name='email' value='" . htmlentities($submittedEmail, ENT_QUOTES) . "' required />\n </div>\n <br />\n <div>\n Administrator Notes:\n </div>\n <div>\n <textarea rows='4' cols='100' name='notes'>" . htmlentities($submittedAdminNotes, ENT_QUOTES) . "</textarea>\n </div>\n <hr />\n <h4> Emergency Contact:</h4>\n <div>\n First Name: <input type='text' name='emergency_fname' value='" . htmlentities($submittedEmergencyFirstName, ENT_QUOTES) . "' required />\n Last Name: <input type='text' name='emergency_lname' value='" . htmlentities($submittedEmergencyLastName, ENT_QUOTES) . "' required />\n Phone Number: <input type='text' name='emergency_phone' value='" . htmlentities($submittedEmergencyPhone, ENT_QUOTES) . "' pattern='(?:\\(\\d{3}\\)|\\d{3})[- ]?\\d{3}[- ]?\\d{4}' maxlength='14' required /> \n Relationship:\n <select name='emergency_relationship'>" . createRelationshipsOptions($relationships, $submittedEmergencyRelationship) . "</select>\n <hr />\n <div>\n <h4>Password</h4>\n <script type='text/javascript'>\n function ShowHideDiv(generatePassword) {\n var passwordInformation = document.getElementById('passwordInformation');\n passwordInformation.style.display = generatePassword.checked ? 'none' : 'block';\n }\n </script>\n\n <div class='checkbox' for='generatePassword'>\n <label>\n <input type='checkbox' name='generatePassword' id='generatePassword' onclick = 'ShowHideDiv(this)' value='TRUE'> Generate password\n </label>\n </div><br />\n <div id='passwordInformation' style='display: hidden'>\n The user's password must be eight or more characters and have at least one of each:\n <ul>\n <li>Lower-case letter</li>\n <li>Upper-case letter</li>\n <li>Number</li>\n <li>Special characters</li>\n </ul>\n\n Enter the user's password: <input type='password' name='newPassword1'/><br /><br />\n Re-enter the user's password: <input type='password' name='newPassword2'/><br /><br />\n </div>\n <hr />\n <div>\n <input type='text' name='submit' value='TRUE' hidden>\n <input type='submit' class='btn btn-default' value='Submit' />\n </div>\n </form>";
}