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>";
}