0) {
$phone = preg_replace("/[^0-9]/","",$home_phone);
if (strlen($phone) == 10) {
$home_phone = "(" . substr($phone,0,3) . ")" . substr($phone,3,3) . "-" . substr($phone,6);
}
}
// Same for work number
if (isset($work_phone) && strlen($work_phone) > 0) {
$phone = preg_replace("/[^0-9]/","",$work_phone);
if (strlen($phone) == 10) {
$work_phone = "(" . substr($phone,0,3) . ")" . substr($phone,3,3) . "-" . substr($phone,6);
}
}
// Same for cell number
if (isset($cell_phone) && strlen($cell_phone) > 0) {
$phone = preg_replace("/[^0-9]/","",$cell_phone);
if (strlen($phone) == 10) {
$cell_phone = "(" . substr($phone,0,3) . ")" . substr($phone,3,3) . "-" . substr($phone,6);
}
}
if (!isset($home_email)) $home_email = '';
if (!isset($work_email)) $work_email = '';
$home_email = strtolower($home_email);
$work_email = strtolower($work_email);
$table = new Table("$CurrentTable");
$query = $table->BuildInsert();
db_query($query);
$form_message = getLanguageText('RECORD-INSERTED-MSG');
$naction = 'list';
header("Location: /?action=$action&naction=$naction&form_message=" . urlencode($form_message) . "&error_message=" . urlencode($error_message));
exit();
case "edit":
$next_naction = "update";
// Get current record
$record_num = intval($_GET['record_num']);
$query = "select * from $CurrentTable " .
"where school_num = $school_num " .
$uwhere .
"and record_num = $record_num";
$results = db_query($query);
if (db_num_rows($results) == 1) {
$row = db_fetch_array($results);
extract($row);
include $FormFile;
}
else {
$error_message = getLanguageText('ERRORMSG-NOT-FOUND');
$naction = 'list';
header("Location: /?action=$action&naction=$naction&form_message=" . urlencode($form_message) . "&error_message=" . urlencode($error_message));
exit();
}
break;
case "update":
extract($_POST);
if (!isset($user_num)) $user_num = intval($_SESSION['UserInfo']['record_num']);
$uid = $user_num;
if ($first_name == strtolower($first_name) || $first_name == strtoupper($first_name)) {
$first_name = ucwords(strtolower($first_name));
}
if ($last_name == strtolower($last_name) || $last_name == strtoupper($last_name)) {
$last_name = ucwords(strtolower($last_name));
}
// If there is a phone number entered then format it
if (isset($home_phone) && strlen($home_phone) > 0) {
$phone = preg_replace("/[^0-9]/","",$home_phone);
if (strlen($phone) == 10) {
$home_phone = "(" . substr($phone,0,3) . ")" . substr($phone,3,3) . "-" . substr($phone,6);
}
}
// Same for work number
if (isset($work_phone) && strlen($work_phone) > 0) {
$phone = preg_replace("/[^0-9]/","",$work_phone);
if (strlen($phone) == 10) {
$work_phone = "(" . substr($phone,0,3) . ")" . substr($phone,3,3) . "-" . substr($phone,6);
}
}
// Same for cell number
if (isset($cell_phone) && strlen($cell_phone) > 0) {
$phone = preg_replace("/[^0-9]/","",$cell_phone);
if (strlen($phone) == 10) {
$cell_phone = "(" . substr($phone,0,3) . ")" . substr($phone,3,3) . "-" . substr($phone,6);
}
}
$home_email = strtolower($home_email);
if (isset($work_email)) $work_email = strtolower($work_email);
$table = new Table("$CurrentTable");
$query = $table->BuildUpdate();
db_query($query);
$form_message = getLanguageText('RECORD-UPDATED-MSG');
// Display the updated entry
$lookup_query = $table->BuildQuery("","","c.");
$lookup_where = "";
if (stripos("where ",$lookup_query)) $lookup_where = preg_replace("/.* where/i","and",$lookup_query);
if (stripos("order by ",$lookup_where)) $lookup_where = preg_replace("/order by .*/i","",$lookup_where);
$lookup_where .= " ";
$naction = 'list';
header("Location: /?action=$action&naction=$naction&form_message=" . urlencode($form_message) . "&error_message=" . urlencode($error_message));
exit();
case "delete":
$record_num = intval($_GET['record_num']);
// Parents can not delete the last contact record
if ($_SESSION['UserInfo']['type'] == 'Parent' || $_SESSION['mode'] == 'parent') {
// Check if this is the only contact record for this account
$query = "select count(*) from $CurrentTable " .
"where school_num = $school_num " .
$uwhere;
$num = db_getVal($query);
if ($num == 1) {
$error_message = getLanguageText('CONTACT-DELETE-ERROR');
$naction = 'list';
header("Location: /?action=$action&naction=$naction&form_message=" . urlencode($form_message) . "&error_message=" . urlencode($error_message));
exit();
}
}
// Verify that the contact record is accessible by the current user
$query = "select * from $CurrentTable " .
"where school_num = $school_num " .
$uwhere .
"and record_num = $record_num";
$results = db_query($query);
if (db_num_rows($results) == 1) {
$row = db_fetch_array($results);
extract($row);
$uid = $user_num;
$dFields = explode(",",$DeleteField);
$dTitle = "";
for ($i = 0; $i < count($dFields); $i++) {
$dTitle .= $row[$dFields[$i]] . $dSeparator;
}
if ($_SESSION['mode'] == 'parent') $HiddenFields = " \n";
include "delete.form.php";
}
else {
$error_message = getLanguageText('ERRORMSG-NOT-FOUND');
$naction = 'list';
header("Location: /?action=$action&naction=$naction&form_message=" . urlencode($form_message) . "&error_message=" . urlencode($error_message));
exit();
}
break;
case "delete-confirmed":
if (array_key_exists('record_num',$_GET) && $_GET['record_num'] > 0) $record_num = intval($_GET['record_num']);
if (array_key_exists('record_num',$_POST) && $_POST['record_num'] > 0) $record_num = intval($_POST['record_num']);
// Verify that the contact record is accessible by the current user
$query = "select * from $CurrentTable " .
"where school_num = $school_num " .
$uwhere .
"and record_num = $record_num";
$results = db_query($query);
if (db_num_rows($results) == 1) {
$row = db_fetch_array($results);
extract($row);
$uid = $user_num;
// Delete the current record
$query = "delete from $CurrentTable " .
"where school_num = $school_num " .
$uwhere .
"and record_num = $record_num";
db_query($query);
$form_message = getLanguageText('RECORD-DELETED-MSG');
}
else {
$error_message = getLanguageText('ERRORMSG-NO-ACCESS');
}
$naction = 'list';
header("Location: /?action=$action&naction=$naction&form_message=" . urlencode($form_message) . "&error_message=" . urlencode($error_message));
exit();
case "search":
$PageTitle = getLanguageText('TEXT-SEARCH');
$ButtonText = $PageTitle;
$ChoosePagination = 'Y';
$next_naction = "lookup";
include $FormFile;
break;
case "lookup":
extract($_POST);
$table = new Table("$CurrentTable");
$lookup_query = $table->BuildQuery("","","c.");
$lookup_where = "";
if (stripos("where ",$lookup_query)) $lookup_where = preg_replace("/.* where/i","and",$lookup_query);
if (stripos("order by ",$lookup_where)) $lookup_where = preg_replace("/order by .*/i","",$lookup_where);
$lookup_where .= " ";
$naction = "list";
$TitleText = getLanguageText('RECORD-LOOKUP');
include 'contacts.display.php';
break;
case "fetch":
$lookup_where = "where school.record_num = $record_num";
$naction = "list";
$TitleText = getLanguageText('RECORD-LOOKUP');
break;
case "display":
case "list":
default:
include 'contacts.display.php';
break;
}
endTemplate();
?>