projact.html if(request.changeproj) { redirect("project.html") } if(request.addproj) { redirect("addproj.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("" + request.project + " 的所有行動項目") } else { write("" + request.project + " 尚未結案的行動項目") } write("
") write("
專案
") if(actionitems.next()) { //displays first action item information in an edit format. write("
") write("") if(!actionitems.closedate) { write("") } write("
") write("
") write("") write("") write("") write("
工作項目:"+ actionitems.actionitem + "
需求提出者: " + actionitems.requester + "執行者: " + actionitems.owner +"
") write("") write("") write("
要求完成期限:" + datetoString(actionitems.duedate) + "起始日期:" + datetoString(actionitems.opendate) + "實際完成日期:" + 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 + "
需求提出者: " + actionitems.requester + "執行者: " + actionitems.owner +"
") write("") write("") write("
要求完成期限:" + datetoString(actionitems.duedate) + "起始日期:" + datetoString(actionitems.opendate) + "實際完成日期:" + datetoString(actionitems.closedate) + "
") write("


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

本專案無行動項目.") }