📄 tasks.php
字号:
<?
/*
* Copyright 2005 Nokia. All rights reserved.
*/
include 'logged_in.php'; //go to login page, if not logged in
include 'database_access.php'; //open database access
include 'functions.php';
$manager = false;
if ($_SESSION['user_role'] == 2)
$manager = true;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<TITLE>Tasks</TITLE>
<HEAD>
<link rel="stylesheet" type="text/css" href="style.css" />
<SCRIPT TYPE="TEXT/JAVASCRIPT">
var selectedTask = null;
var selectedClass = '';
function dataValid()
{
if (document.edit_task.description.value.length < 1)
{
alert('Fill in the description');
return false;
}
return true;
}
function changePassword()
{
if (document.change_password.pw.value.length < 4)
{
alert('Invalid password');
return;
}
if (document.change_password.pw.value != document.change_password.confirm.value)
{
alert("Passwords don't match.");
return;
}
document.change_password.submit();
}
function doAdd()
{
if (!dataValid())
{
return;
}
document.edit_task.submit();
}
function doSave()
{
if (document.edit_task.task_id.value == -1)
{
alert('Select a task first.');
return;
}
if (!dataValid())
{
return;
}
document.edit_task.action = "save.php";
document.edit_task.submit();
}
function doDelete()
{
if (document.edit_task.task_id.value == -1)
{
alert('Select a task first.');
return;
}
if (confirm('Delete the selected task?'))
{
document.edit_task.action = "delete_task.php";
document.edit_task.submit();
}
}
function edit(owner, description, state, task_id, row)
{
for (i=0;i<document.edit_task.owner.length;i++)
{
if (document.edit_task.owner[i].value == owner)
{
document.edit_task.owner.selectedIndex = i;
break;
}
}
document.edit_task.description.value = description;
for (i=0;i<document.edit_task.state.length;i++)
{
if (document.edit_task.state[i].value == state)
{
document.edit_task.state.selectedIndex = i;
break;
}
}
document.edit_task.task_id.value = task_id;
if (selectedTask != null)
{
selectedTask.className = selectedClass;
}
selectedClass = row.className;
selectedTask = row;
row.className = 'selected_row';
}
</SCRIPT>
</HEAD>
<BODY>
<!-- MAIN TABLE -->
<TABLE align="center" class="main_table" >
<!-- FIRST ROW IN MAIN TABLE -->
<?
printHeader();
?>
<!-- SECOND ROW IN MAIN TABLE -->
<TR>
<!-- LEFT COLUMN -->
<TD class="left_col">
<?
// allow managers to edit tasks.
if ($manager)
{?>
<FORM NAME="edit_task" METHOD=POST ACTION="add_new_task.php">
<INPUT TYPE=HIDDEN NAME="task_id" VALUE="-1">
<DIV class="center">
<!-- EDIT TASK TABLE -->
<TABLE class="edit_table">
<TR>
<TD colspan=2 class="buttons_col">
<INPUT TYPE=BUTTON class="button" VALUE="Add as new" NAME="addbutton" onclick="doAdd()">
<INPUT TYPE=BUTTON class="button" VALUE="Save" NAME="savebutton" onClick="doSave()">
<INPUT TYPE=BUTTON class="button" VALUE="Delete" NAME="deletebutton" onClick="doDelete()">
</TD>
</TR>
<TR>
<TD class="edit_col">
Owner:
</TD>
<TD class="edit_col">
<SELECT NAME="owner">
<?
$query = "select user.login, user.id from user,userrolemap where user.id = userrolemap.userid and userrolemap.roleid <> 1";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result))
{?>
<OPTION VALUE="<? print $row["id"]; ?>"><? print $row["login"]; ?></OPTION>
<?}
?>
</SELECT>
</TD>
</TR>
<TR>
<TD class="edit_col">
Description:
</TD>
<TD class="edit_col">
<INPUT TYPE="text" NAME="description" MAXLENGTH=100>
</TD>
</TR>
<TR>
<TD class="edit_col">
Status:
</TD>
<TD class="edit_col">
<SELECT NAME="state">
<OPTION VALUE="NOT_DONE">Not done</OPTION>
<OPTION VALUE="DONE">Done</OPTION>
</SELECT>
</TD>
</TR>
</TABLE>
</DIV>
</FORM>
<?}
?>
</TD>
<!-- MIDDLE COLUMN -->
<TD align="center" class="middle_col">
<TABLE class="selection_table" width=100%>
<TR>
<?
if ($manager)
{
?><TH>Owner</TH><?
}
?>
<TH>Description</TH>
<TH>Status</TH>
</TR>
<?
$query = "select id, description, state from task where owner = '".$_SESSION['user_id']."'";
if ($manager)
{
$query = "select task.id, task.description, task.state, user.id, user.login from user,task where task.owner=user.id";
}
$result = mysql_query($query);
$i = 0;
while ($row = mysql_fetch_array($result))
{
if ($manager)
{?>
<TR onclick="edit(<? print $row[3].",'".$row[1]."','".$row[2]."',".$row[0].",this"; ?>)" <? if ($i % 2 == 0) print 'class="even_row"'; else print 'class="odd_row"'; ?> >
<TD><? print $row[4];?></TD><?
}
else
{?>
<TR <? if ($i%2==0) print 'class="even_row"'; else print 'class="odd_row"'; ?>>
<? }
?>
<TD>
<? print $row["1"];?>
</TD>
<TD>
<? print $row["2"]; ?>
</TD>
</TR>
<?
$i++;
}
?>
</TABLE>
<? if ($manager) {?>
<FORM NAME="sms" ACTION="sendsms.php" METHOD="post">
<DIV class="right">
<INPUT TYPE=SUBMIT class="button" VALUE="Send SMS">
</DIV>
</FORM>
<?}?>
<FONT color="#FF0000"><? print $_SESSION['info_msg'];
$_SESSION['info_msg'] = "";
?>
</FONT>
</TD>
<!-- RIGHT COLUMN -->
<TD class="right_col">
<FORM NAME="change_password" METHOD=POST ACTION="change_password.php">
<TABLE class="user_table" align="center">
<TR>
<TD class="login_col">Logged in: <? print $_SESSION['username']; ?></TD>
<TD class="login_col" align="right"><a href="logout.php">logout</a></TD>
</TR>
<TR>
<TD colspan=2 class="invisible_col"></TD>
</TR>
<TR>
<TD class="edit_col">Current password</TD>
<TD class="edit_col"><INPUT TYPE="password" NAME="currentpw" maxlength="20"></TD>
</TR>
<TR>
<TD class="edit_col">New password</TD>
<TD class="edit_col"><INPUT TYPE="password" NAME="pw" maxlength="20"></TD>
</TR>
<TR>
<TD class="edit_col">Confirm password</TD>
<TD class="edit_col"><INPUT TYPE="password" NAME="confirm" maxlength="20"></TD>
</TR>
<TR>
<TD colspan=2 align="right" class="invisible_col"><INPUT TYPE=BUTTON class="button" VALUE="Change password" onclick="changePassword()"></TD>
</TR>
</TABLE>
</FORM>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -