/*
$Log: do_edit_project.html,v $
Revision 1.17 1996/08/21 17:53:52 kimberly
rename index.html to index.html; break long lines; add comments
Revision 1.16 1996/08/09 02:04:50 kimberly
change version number
Revision 1.15 1996/08/08 21:32:29 kimberly
save db error in client
Revision 1.14 1996/08/06 17:58:49 kimberly
go back to edit screen with message after edit
Revision 1.13 1996/08/06 17:01:57 kimberly
add code to deal with saving a change when someone else has already used that name
Revision 1.12 1996/08/05 21:42:37 kimberly
add parameter when redirecting to initial.html because of an error to prevent loading frames again
Revision 1.11 1996/08/03 00:32:06 kimberly
remove inactive projects list from project object and replace with all projects list
Revision 1.10 1996/08/02 23:17:47 kimberly
if item is default or active for a user, show delete button. if deleted, remove from defaults and active lists.
Revision 1.9 1996/08/02 21:42:58 kimberly
change name field to proj_name since name seems to cause javascript errors
Revision 1.8 1996/08/02 02:19:49 kimberly
changes for flattened directory s structure
Revision 1.7 1996/08/01 19:01:41 kimberly
add status line info after add, edit, or delete
Revision 1.6 1996/08/01 18:03:39 kimberly
add checks to deal with database errors
Revision 1.5 1996/07/31 22:01:18 kimberly
prevent blank screen from user typing in URL when on correct prevPage
Revision 1.4 1996/07/25 16:26:54 kimberly
remove absolute paths
Revision 1.3 1996/07/23 18:54:59 kimberly
Change hours_ims to tock_ims
Revision 1.2 1996/07/23 18:53:01 kimberly
Add Log tag
*/
if (request.prevPage)
client.prevPage = request.prevPage;
checkPrevPage("do_edit_project.html");
if (lookupAdminStatus(client.id) != "Y")
redirect("initial.html?err=1");
if (request.orig_name != request.proj_name) {
query = database.cursor("select name from project where name='"+escQuote(request.proj_name)+"'");
if (query.next()) {
query.close();
redirect("edit_project.html?msg=name_in_use&Project="+request.project_id+"&proj_"+request.project_id+"="+escape(request.proj_name));
}
query.close();
}
if (request.status == "I" || request.submit_type == "D") {
database.execute("delete from user_projects where project_id="+
request.project_id);
if (database.majorErrorCode() != 0) {
client.db_err = database.majorErrorMessage();
redirect("db_down.html");
}
database.execute("update user set def_project=null where def_project="+
request.project_id);
if (database.majorErrorCode() != 0) {
client.db_err = database.majorErrorMessage();
redirect("db_down.html");
}
}
if (request.submit_type == "U") {
database.execute("update project set name='"+request.proj_name+
"', status='"+request.status+"', billable='"+request.billable+
"' where id="+request.project_id);
if (database.majorErrorCode() != 0) {
client.db_err = database.majorErrorMessage();
redirect("db_down.html");
}
}
if (request.submit_type == "D") {
database.execute("delete from project where id="+request.project_id);
if (database.majorErrorCode() != 0) {
redirect("db_down.html");
client.db_err = database.majorErrorMessage();
}
}
project.project_list = null;
loadProjects();
project.all_projects_list = null;
loadAllProjects();
if (request.submit_type == "U")
redirect("edit_project.html?msg=updated&Project="+request.project_id+
"&proj_"+request.project_id+"="+escape(request.proj_name));
if (request.submit_type == "D") {
client.status_msg = "Project "+request.proj_name+" deleted.";
redirect("admin.html");
}