function workboardIndex() { workboard_admin_menu(); global $db, $bgcolor2; //workboard_admin_menu(); echo "<CENTER><FONT CLASS=\"title\"><B>" . _WORKBOARD_ADMIN_PROJECTS_PROJECTLIST . "</B></FONT></CENTER>"; echo "<BR>"; $projectresult = $db->select_query("select * from " . TB_WORKBOARD_PROJECTS . " order by project_id"); $project_total = $db->rows($projectresult); echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"grids\">"; echo "<tr class=\"odd\"><td align=\"left\" colspan=3 width=\"100%\" bgcolor=\"{$bgcolor2}\"><nobr><b>" . _WORKBOARD_ADMIN_PROJECTS_PROJECTOPTIONS . "</b></nobr></td></tr>"; echo "<tr><td><img src=\"images/workboard/icons/options.png\"></td><td align=\"left\" colspan=2 width=\"100%\"><nobr><a href=\"index.php?name=admin/workboard&file=projects&op=WorkBoardProjectAdd\">" . _WORKBOARD_ADMIN_PROJECTS_PROJECTADD . "</a></nobr></td></tr>"; echo "<tr><td><img src=\"images/workboard/icons/stats.png\"></td><td align=\"left\" colspan=3 width=\"100%\"><nobr>" . _WORKBOARD_ADMIN_PROJECTS_TOTALPROJECTS . ": <b>{$project_total} " . _WORKBOARD_ADMIN_TOTLE_PROJECT . "</b></nobr></td></tr>"; echo "</table>"; echo "<br>"; echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"grids\">"; echo "<tr class=\"odd\"><td align=\"left\" colspan=2 bgcolor=\"{$bgcolor2}\" width=\"100%\"><b>" . _WORKBOARD_ADMIN_PROJECTS_PROJECTLIST . "</b></a></td><td align=\"center\" bgcolor=\"{$bgcolor2}\" ><b>" . _WORKBOARD_ADMIN_TOTLE_NUM . " " . _WORKBOARD_ADMIN_PROJECTS_TASKS . "</b></td><td align=\"center\" bgcolor=\"{$bgcolor2}\" ><b>" . _WORKBOARD_ADMIN_FUNCTIONS . "</b></td></tr>"; if ($project_total != 0) { while ($sd = $db->fetch($projectresult)) { $tasksresult = $db->select_query("select task_id from " . TB_WORKBOARD_TASKS . " where project_id='{$sd['project_id']}'"); $tasks = $db->rows($tasksresult); echo "<tr>"; echo "<td width=\"10%\"><img src=\"images/workboard/icons/project.png\"></td>"; echo "<td ><a href=\"index.php?name=admin/workboard&file=projects&op=WorkBoardProjectTasks&project_id={$sd['project_id']}\">{$sd['project_name']}</a></td>"; echo "<td align=\"center\" ><a href=\"index.php?name=admin/workboard&file=projects&op=WorkBoardProjectTasks&project_id={$sd['project_id']}\">{$tasks}</a></td>"; echo "<td align=\"center\" width=\"10%\"><NOBR>[ <a href=\"index.php?name=admin/workboard&file=projects&op=WorkBoardProjectEdit&project_id={$sd['project_id']}\">" . _WORKBOARD_ADMIN_EDIT . "</a>"; echo " | <a href=\"index.php?name=admin/workboard&file=projects&op=WorkBoardProjectRemove&project_id={$sd['project_id']}\">" . _WORKBOARD_ADMIN_DELETE . "</a> ]</NOBR></td>"; echo "</tr>"; } } else { echo "<tr>"; echo "<td width=\"100%\" colspan=4 align=\"center\">" . _WORKBOARD_ADMIN_PROJECTS_NOPROJECTS . "</td>"; echo "</tr>"; } echo "</table>"; // CloseTable(); // include("footer.php"); }
function workboardTaskRemove($task_id) { global $task_id, $db; $taskresults = $db->select_query("SELECT * FROM " . TB_WORKBOARD_TASKS . " WHERE task_id='{$task_id}'"); $task = $db->fetch($taskresults); workboard_admin_menu(); echo "<CENTER><B>" . _WORKBOARD_ADMIN_TASKS_DELETETASK . "</B></CENTER>"; echo "<BR>"; echo "<form method=\"post\" action=\"index.php?name=admin/workboard&file=tasks&op=WorkBoardTaskDelete\" enctype=\"multipart/form-data\"><input type=\"hidden\" name=\"op\" value=\"WorkBoardTaskDelete\"><input type=\"hidden\" name=\"task_id\" value=\"{$task_id}\">"; echo "<center><b>" . _WORKBOARD_ADMIN_TASKS_CONFIRMDELETE . "</b><br><br>[" . $task['task_id'] . "] " . $task['task_name'] . " "; echo "<br><br><input type=\"submit\" value=\"" . _WORKBOARD_ADMIN_TASKS_DELETETASK . "\"><br>" . "</form>"; }
function workboardProjectRemove($project_id) { global $db, $project_id; $projectresults = $db->select_query("SELECT * FROM " . TB_WORKBOARD_PROJECTS . " WHERE project_id='{$project_id}'"); $project = $db->fetch($projectresults); workboard_admin_menu(); echo "<CENTER><B>" . _WORKBOARD_ADMIN_PROJECTS_DELETEPROJECT . "</B></CENTER>"; echo "<BR>"; echo "<form method=\"post\" action=\"index.php?name=admin/workboard&file=projects&op=WorkBoardProjectDelete\" enctype=\"multipart/form-data\"><input type=\"hidden\" name=\"op\" value=\"WorkBoardProjectDelete\"><input type=\"hidden\" name=\"project_id\" value=\"{$project['project_id']}\">"; echo "<center><b>" . _WORKBOARD_ADMIN_PROJECTS_CONFIRMDELETE . "</b><br><br>"; echo "<b>" . _WORKBOARD_MODULE_MAP_PROJECT . " : {$project['project_name']} </b><br>" . _WORKBOARD_MODULE_PROJECT_PROJECTDETAILS . " : {$project['project_description']}"; echo "<br><br><input type=\"submit\" value=\"" . _WORKBOARD_ADMIN_PROJECTS_DELETEPROJECT . "\"><br>"; echo "</form>"; }
function workboardPriorityRemove($priority_id) { global $priority_id, $db; $priorityresult = $db->select_query("select priority_name, priority_weight from " . TB_WORKBOARD_PRIORITIES . " where priority_id='{$priority_id}'"); $list3 = $db->fetch($priorityresult); workboard_admin_menu(); echo "<CENTER><B>" . _WORKBOARD_ADMIN_PRIORITY_DELETEPRIORITY . "</B></CENTER>"; echo "<BR>"; echo "<form method=\"post\" action=\"index.php?name=admin/workboard&file=priority&op=WorkBoardPriorityDelete\" enctype=\"multipart/form-data\"><input type=\"hidden\" name=\"op\" value=\"WorkBoardPriorityDelete\"><input type=\"hidden\" name=\"priority_id\" value=\"{$priority_id}\">"; echo "<center><b>" . _WORKBOARD_ADMIN_PRIORITY_SWAPPRIORITY . "</b><br><br>"; echo "{$list3['priority_name']} -> "; echo "<select name=\"swap_priority_id\">"; echo "<option value=\"0\">---------</option>"; $prioritylist = $db->select_query("select priority_id, priority_name from " . TB_WORKBOARD_PRIORITIES . " where priority_id != '{$priority_id}' order by priority_weight"); while ($list = $db->fetch($prioritylist)) { echo "<option value=\"{$list['priority_id']}\">{$list['priority_name']}</option>"; } echo "</select>"; echo "<br><br><input type=\"submit\" value=\"" . _WORKBOARD_ADMIN_PRIORITY_DELETEPRIORITY . "\"><br>" . "</form>"; }
function workboardMemberRemove($member_id) { global $member_id, $db; $memberresult = $db->select_query("select member_name from " . TB_WORKBOARD_MEMBERS . " where member_id='{$member_id}'"); $list = $db->fetch($memberresult); workboard_admin_menu(); echo "<CENTER><B>" . _WORKBOARD_ADMIN_MEMBERS_DELETESTATUS . "</B></CENTER>"; echo "<BR>"; echo "<form method=\"post\" action=\"index.php?name=admin/workboard&file=members&op=WorkBoardMemberDelete\" enctype=\"multipart/form-data\"><input type=\"hidden\" name=\"op\" value=\"WorkBoardMemberDelete\"><input type=\"hidden\" name=\"member_id\" value=\"{$member_id}\">"; echo "<center><b>" . _WORKBOARD_ADMIN_MEMBERS_SWAPMEMBER . "</b><br><br>"; echo "{$list['member_name']} -> "; echo "<select name=\"swap_member_id\">"; echo "<option value=\"0\">---------</option>"; $memberlist = $db->select_query("select member_id, member_name from " . TB_WORKBOARD_MEMBERS . " where member_id != '{$member_id}' order by member_name"); while ($list2 = $db->fetch($memberlist)) { echo "<option value=\"{$list2['member_id']}\">{$list2['member_name']}</option>"; } echo "</select>"; echo "<br><br><input type=\"submit\" value=\"" . _WORKBOARD_ADMIN_MEMBERS_DELETESTATUS . "\"><br>" . "</form>"; }
function workboardPositionRemove($position_id) { global $position_id, $db; $positionresult = $db->select_query("select position_name, position_description from " . TB_WORKBOARD_POSITIONS . " where position_id='{$position_id}'"); $ro = $db->fetch($positionresult); workboard_admin_menu(); echo "<CENTER><B>" . _WORKBOARD_ADMIN_POSITION_DELETEPOSITION . "</B></CENTER>"; echo "<BR>"; echo "<form method=\"post\" action=\"index.php?name=admin/workboard&file=positions&op=WorkBoardPositionDelete\" enctype=\"multipart/form-data\"><input type=\"hidden\" name=\"op\" value=\"WorkBoardPositionDelete\"><input type=\"hidden\" name=\"position_id\" value=\"{$position_id}\">"; echo "<center><b>" . _WORKBOARD_ADMIN_POSITION_SWAPPOSITION . "</b><br><br>"; echo "{$ro['position_name']} -> "; echo "<select name=\"swap_position_id\">"; echo "<option value=\"0\">---------</option>"; $positionlist = $db->select_query("select position_id, position_name from " . TB_WORKBOARD_POSITIONS . " where position_id != '{$position_id}' order by position_name"); while ($ros = $db->fetch($positionlist)) { echo "<option value=\"{$ros['position_id']}\">{$ros['position_name']}</option>"; } echo "</select>"; echo "<br><br><input type=\"submit\" value=\"" . _WORKBOARD_ADMIN_POSITION_DELETEPOSITION . "\"><br>" . "</form>"; }
function workboardStatusRemove($status_id) { global $status_id, $db; $statusresult = $db->select_query("select status_name, status_description from " . TB_WORKBOARD_STATUS . " where status_id='{$status_id}'"); $list = $db->fetch($statusresult); workboard_admin_menu(); echo "<CENTER><B>" . _WORKBOARD_ADMIN_STATUS_DELETESTATUS . "</B></CENTER>"; echo "<BR>"; echo "<form method=\"post\" action=\"index.php?name=admin/workboard&file=status&op=WorkBoardStatusDelete\" enctype=\"multipart/form-data\"><input type=\"hidden\" name=\"op\" value=\"WorkBoardStatusDelete\"><input type=\"hidden\" name=\"status_id\" value=\"{$status_id}\">"; echo "<center><b>" . _WORKBOARD_ADMIN_STATUS_SWAPSTATUS . "</b><br><br>"; echo "{$list['status_name']} -> "; echo "<select name=\"swap_status_id\">"; echo "<option value=\"0\">---------</option>"; $statuslist = $db->select_query("select status_id, status_name from " . TB_WORKBOARD_STATUS . " where status_id != '{$status_id}' order by status_name"); while ($list2 = $db->fetch($statuslist)) { echo "<option value=\"{$list2['status_id']}\">{$list2['status_name']}</option>"; } echo "</select>"; echo "<br><br><input type=\"submit\" value=\"" . _WORKBOARD_ADMIN_STATUS_DELETESTATUS . "\"><br>" . "</form>"; }