if(request.changeproj) { redirect("project.html") } if(request.addproj) { redirect("newproj.html") } if(request.updateproject) { //updates the project information redirect("project.html"); } dbconnect(); projects = database.cursor("SELECT * FROM Project ORDER BY ProjectName") if(request.all) { //searches for open and closed action items actionitems = database.cursor("SELECT * FROM ActionItems WHERE projectname = '" + request.project + "' ORDER BY closedate") } else { //searches for open action items only actionitems = database.cursor("SELECT * FROM ActionItems WHERE projectname = '" + request.project + "' AND closedate IS Null") }
write("
") if(request.all) { //if all action items are being viewed, you are //given the choice to view open action items. write("") } else { //vice versa of the if statement above. write("") } write("") write("

") if(request.all) { write("All Action Items for " + request.project + "") } else { write("Open Action Items for " + request.project + "") } write("
") write("
Project List
") if(actionitems.next()) { //displays first action item information in an edit format. write("
") write("") if(!actionitems.closedate) { write("") } write("
") write("
") write("") write("") write("") write("
Action Item:"+ actionitems.actionitem + "
Requester: " + actionitems.requester + "Owner: " + actionitems.owner +"
") write("") write("") write("
Due:" + datetoString(actionitems.duedate) + "Open:" + datetoString(actionitems.opendate) + "Close:" + datetoString(actionitems.closedate) + "
") write("


") write("
") while(actionitems.next()) { //displays second and rest of the action item information in an edit format. write("
") write("") if(!actionitems.closedate) { write("") } write("
") write("
") write("") write("") write("") write("
Action Item:"+ actionitems.actionitem + "
Requester: " + actionitems.requester + "Owner: " + actionitems.owner +"
") write("") write("") write("
Due:" + datetoString(actionitems.duedate) + "Open:" + datetoString(actionitems.opendate) + "Close:" + datetoString(actionitems.closedate) + "
") write("


") write("
") } write("
") } else { write("

This project has no action items.") }