query($select_edit);
$a_row = mysql_fetch_array($result_edit);
print "| ";
OpenTable();
print "";
CloseTable();
print " | ";
}
function edit_contact_upd($action,$lastname,$firstname,$title,$phone,$address,$department,$personid,$update_person,$update_phone) {
include ('dbkey.php');
include('queries.php');
$db->query($update_person);
$db->query($update_phone);
print "";
OpenTable();
print "
|
";
echo _CODE_DIR_SUCCESS_UPD_ENTRY;
print " |
| ";
echo _NAME;
print " |
";
echo _CODE_DIR_DEPARTMENT;
print " |
";
echo _TITLE;
print " |
";
echo _CODE_DIR_PHONE;
print " |
";
echo _CODE_DIR_ADDRESS;
print "Address |
| $lastname, $firstname | ";
/* Match department serial to department name */
$result_list = $db->query($select_dept_list);
while ( $a_row = mysql_fetch_array( $result_list ))
{
if ( $a_row[serial] == $department ) {
print "$a_row[department] | ";
}
}
print "$title |
$phone |
$address |
";
CloseTable();
print " | ";
}
function edit_contact_del($action,$personid,$select_edit) {
include ('dbkey.php');
include('queries.php');
$result_edit = $db->query($select_edit);
$a_row = mysql_fetch_array($result_edit);
print "";
OpenTable();
print "
|
";
echo _CODE_DIR_QUEST_DELETE;
print " |
| ";
echo _NAME;
print" |
";
echo _CODE_DIR_DEPARTMENT;
print" |
";
echo _TITLE;
print "Title |
";
echo _CODE_DIR_PHONE;
print " |
";
echo _CODE_DIR_ADDRESS;
print " |
| $a_row[lastname], $a_row[firstname] | ";
$dept_select = $a_row[deptid];
/* List departments in DB and build SELECT array */
$result_list = $db->query($select_dept_list);
while ( $b_row = mysql_fetch_array( $result_list ))
{
if ( $b_row[serial] == $dept_select ) {
print "$b_row[department] | ";
}
}
print "$a_row[title] |
$a_row[phone] |
$a_row[address] |
|
";
CloseTable();
print " | ";
}
function deleted_entry($personid,$delete_person,$delete_phone) {
include ('dbkey.php');
include('queries.php');
$db->query($delete_person);
$db->query($delete_phone);
print "";
echo _CODE_DIR_SUCCESS_DEL_CONTACT;
print " | ";
}
/* Add entry functions */
function add_contact_form() {
include ('dbkey.php');
include('queries.php');
print "";
OpenTable();
print "";
CloseTable();
print " | ";
}
function add_contact($lastname,$firstname,$title,$phone,$address,$department,$insert_person,$insert_phone) {
include ('dbkey.php');
include('queries.php');
$db->query($insert_person);
$result_person = $db->query("SELECT personid
FROM ".$db->prefix("dir_person")."
WHERE lastname = '$lastname'
AND firstname = '$firstname'");
$a_row = mysql_fetch_array($result_person);
$personid = $a_row[personid];
$db->query("INSERT INTO ".$db->prefix("dir_phone")." VALUES (NULL, '$personid', '$phone')");
print "";
OpenTable();
print "
|
";
echo _CODE_DIR_SUCCESS_ADD_ENTRY;
print " |
| ";
echo _NAME;
print " |
";
echo _CODE_DIR_DEPARTMENT;
print " |
";
echo _TITLE;
print " |
";
echo _CODE_DIR_PHONE;
print " |
";
echo _CODE_DIR_ADDRESS;
print " |
| $lastname, $firstname | ";
/* Match department serial to department name */
$result_list = $db->query($select_dept_list);
while ( $a_row = mysql_fetch_array( $result_list ))
{
if ( $a_row[serial] == $department ) {
print "$a_row[department] | ";
}
}
print "$title |
$phone |
$address |
";
CloseTable();
print " | ";
}
function add_dept($action,$department) {
include ('dbkey.php');
include('queries.php');
$db->query($insert_dept);
print "";
echo _CODE_DIR_SUCCESS_DEPT_ENTRY;
print ": $department | ";
}
function edit_dept($action,$serial) {
include ('dbkey.php');
include('queries.php');
echo "";
echo _CODE_DIR_MODIFY_DEPT_TXT;
print ":
| ";
}
function upd_dept($action,$serial,$department) {
include ('dbkey.php');
include('queries.php');
$result_update = $db->query("UPDATE department SET department = '$department' WHERE serial = '$serial'");
print "";
echo _CODE_DIR_SUCCESS_UPD_DEPT;
print ": $department | ";
}
function del_dept($action,$serial) {
include ('dbkey.php');
include('queries.php');
$db->query($delete_dept);
print "";
echo _CODE_DIR_SUCCESS_DEL_DEPT;
print ". | ";
}
?>