actrep.html
dbconnect(); actionitems = database.cursor("SELECT * FROM actionitems WHERE projectname = '" + unescape(request.projectname) + "' AND closedate IS null")
未完成工作項目清單
write("
專案名稱 :
" + unescape(request.projectname) + "
") if(actionitems.next()) { write("
") write("
行動項目:
"+ actionitems.actionitem + "
") write("
需求提出者:
" + actionitems.requester + "
") write("
執行者:
" + actionitems.owner +"
") write("
要求完成期限:
" + datetoString(actionitems.duedate) + "
") write("
起始日期:
" + datetoString(actionitems.opendate) +"
") write("
") while(actionitems.next()) { write("
") write("
行動項目:
"+ actionitems.actionitem + "
") write("
需求提出者:
" + actionitems.requester + "
") write("
執行者:
" + actionitems.owner +"
") write("
要求完成期限:
" + datetoString(actionitems.duedate) + "
") write("
起始日期:
" + datetoString(actionitems.opendate) +"
") write("
") } }else { write("
本專案中所有行動項目均已完成.") }