/*
$Log: do_edit_user.html,v $
Revision 1.18 1996/08/21 17:53:53 kimberly
rename index.html to index.html; break long lines; add comments
Revision 1.17 1996/08/09 02:04:52 kimberly
change version number
Revision 1.16 1996/08/09 01:40:56 kimberly
move active code to admin section
Revision 1.15 1996/08/08 21:32:30 kimberly
save db error in client
Revision 1.14 1996/08/07 01:36:18 kimberly
don't remove user from group when inactive
Revision 1.13 1996/08/06 17:58:50 kimberly
go back to edit screen with message after edit
Revision 1.12 1996/08/02 23:16:34 kimberly
set default project and default category to null and delete active projects when a user is inactivated
Revision 1.11 1996/08/02 02:19:50 kimberly
changes for flattened directory s structure
Revision 1.10 1996/08/01 19:01:42 kimberly
add status line info after add, edit, or delete
Revision 1.9 1996/08/01 18:03:44 kimberly
add checks to deal with database errors
Revision 1.8 1996/07/31 22:01:23 kimberly
prevent blank screen from user typing in URL when on correct prevPage
Revision 1.7 1996/07/27 01:37:19 kimberly
minor fixes for beta
Revision 1.6 1996/07/25 16:27:01 kimberly
remove absolute paths
Revision 1.5 1996/07/23 21:07:17 kimberly
remove bill rate
Revision 1.4 1996/07/23 19:40:45 kimberly
delete from group people then insert because update didn't work when a group was not already defined
Revision 1.3 1996/07/23 18:55:04 kimberly
Change hours_ims to tock_ims
Revision 1.2 1996/07/23 18:53:10 kimberly
Add Log tag
*/
if (request.prevPage)
client.prevPage = request.prevPage;
checkPrevPage("do_edit_user.html");
if (request.adminUser == "Y" && request.submit_type == "D") {
database.execute("delete from group_people where user_id="+request.emp_id);
if (database.majorErrorCode() != 0) {
client.db_err = database.majorErrorMessage();
redirect("db_down.html");
}
database.execute("delete from user_projects where user_id="+request.emp_id);
if (database.majorErrorCode() != 0) {
client.db_err = database.majorErrorMessage();
redirect("db_down.html");
}
database.execute("delete from user where id="+request.emp_id);
if (database.majorErrorCode() != 0) {
client.db_err = database.majorErrorMessage();
redirect("db_down.html");
}
}
else {
if (request.adminUser == "Y") {
fullname = request.firstname + " " + request.lastname;
database.execute("update user set firstname='"+
escQuote(request.firstname)+"', lastname='"+
escQuote(request.lastname)+"', fullname='"+escQuote(fullname)+
"', title='"+escQuote(request.title)+"', active='"+request.active+
"', status='"+request.status+"', admin='"+request.admin+"', email='"+
request.email+"', phone='"+request.phone+"', def_project="+
request.def_project+", def_category="+request.def_category+
" where id="+request.emp_id);
if (database.majorErrorCode() != 0) {
client.db_err = database.majorErrorMessage();
redirect("db_down.html");
}
database.execute("update group_people set group_id="+request.group+
" where user_id="+request.emp_id);
if (database.majorErrorCode() != 0) {
client.db_err = database.majorErrorMessage();
redirect("db_down.html");
}
if (request.active == "N") {
database.execute("update user set def_category=null, def_project=null "+
"where id="+request.emp_id);
if (database.majorErrorCode() != 0) {
client.db_err = database.majorErrorMessage();
redirect("db_down.html");
}
}
}
else {
database.execute("update user set firstname='"+
escQuote(request.firstname)+"', lastname='"+
escQuote(request.lastname)+"', title='"+escQuote(request.title)+
"', email='"+request.email+"', phone='"+request.phone+
"', def_project="+request.def_project+", def_category="+
request.def_category+" where id="+request.emp_id);
if (database.majorErrorCode() != 0) {
client.db_err = database.majorErrorMessage();
redirect("db_down.html");
}
}
database.execute("delete from user_projects where user_id="+request.emp_id);
if (database.majorErrorCode() != 0) {
client.db_err = database.majorErrorMessage();
redirect("db_down.html");
}
if (request.active == "Y") {
var numSelections = getOptionValueCount("active_projects");
for (var i = 0; i < numSelections; i++) {
database.execute("insert into user_projects (user_id,project_id) "+
"values ("+request.emp_id+","+getOptionValue("active_projects",i)+")");
if (database.majorErrorCode() != 0) {
client.db_err = database.majorErrorMessage();
redirect("db_down.html");
}
}
}
}
if (client.id == request.emp_id) {
client.defproject = null;
client.defcategory = null;
client.active_project_list = null;
loadPrefs();
}
project.emp_list = null;
loadEmployees();
if (request.submit_type == "U")
client.status_msg = "User "+request.firstname+" "+request.lastname+
" updated.";
if (request.submit_type == "D")
client.status_msg = "User "+request.firstname+" "+request.lastname+
" deleted.";
if (request.adminUser == "Y") {
if (request.submit_type == "D")
redirect("admin.html");
if (request.submit_type == "U")
redirect("user_info.html?msg=updated&id="+request.emp_id);
}
else
redirect("user_info.html?msg=updated");