/* $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");