query.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 381 行
PHP
381 行
<?
include_once 'inc/auth.php';
include_once 'inc/check_type.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>工作计划</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript>
function plan_detail(PLAN_ID)
{
URL="../plan_detail.php?PLAN_ID="+PLAN_ID;
myleft=(screen.availWidth-500)/2;
window.open(URL,"read_work_plan","height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=120,left="+myleft+",resizable=yes");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
$MANAGER = $SECRET_TO_ID;
$PARTICIPATOR = $COPY_TO_ID;
if (($BEGIN_DATE != ''))
{
$TIME_OK = is_date ($BEGIN_DATE);
if (!$TIME_OK)
{
message ('错误', '起始日期格式不对，应形如 1999-1-2');
button_back ();
exit ();
}
}
if (($END_DATE != ''))
{
$TIME_OK = is_date ($END_DATE);
if (!$TIME_OK)
{
message ('错误', '截止日期格式不对，应形如 1999-1-2');
button_back ();
exit ();
}
}
$CONDITION_STR = '';
if (($NAME != ''))
{
($CONDITION_STR .= (('NAME like \'%'.$NAME).'%\''));
}
if (($CONTENT != ''))
{
if (($CONDITION_STR != ''))
{
($CONDITION_STR .= ' and ');
}
($CONDITION_STR .= (('CONTENT like \'%'.$CONTENT).'%\''));
}
if (($BEGIN_DATE != ''))
{
if (($CONDITION_STR != ''))
{
($CONDITION_STR .= ' and ');
}
($CONDITION_STR .= (('BEGIN_DATE>=\''.$BEGIN_DATE).'\''));
}
if (($END_DATE != ''))
{
if (($CONDITION_STR != ''))
{
($CONDITION_STR .= ' and ');
}
($CONDITION_STR .= (('END_DATE<=\''.$END_DATE).'\''));
}
if (($TYPE != 'ALL_TYPE'))
{
if (($CONDITION_STR != ''))
{
($CONDITION_STR .= ' and ');
}
($CONDITION_STR .= (('TYPE like \'%'.$TYPE).'%\''));
}
if (($TO_ID != ''))
{
if (($CONDITION_STR != ''))
{
($CONDITION_STR .= ' and ');
}
($CONDITION_STR .= (('TO_ID like \'%'.$TO_ID).'%\''));
}
if (($TO_ID3 != ''))
{
if (($CONDITION_STR != ''))
{
($CONDITION_STR .= ' and ');
}
($CONDITION_STR .= (('TO_PERSON_ID like \'%'.$TO_ID3).'%\''));
}
if (($MANAGER != ''))
{
if (($CONDITION_STR != ''))
{
($CONDITION_STR .= ' and ');
}
($CONDITION_STR .= (('MANAGER like \'%'.$MANAGER).'%\''));
}
if (($PARTICIPATOR != ''))
{
if (($CONDITION_STR != ''))
{
($CONDITION_STR .= ' and ');
}
($CONDITION_STR .= (('PARTICIPATOR like \'%'.$PARTICIPATOR).'%\''));
}
if (($REMARK != ''))
{
if (($CONDITION_STR != ''))
{
($CONDITION_STR .= ' and ');
}
($CONDITION_STR .= (('REMARK like \'%'.$REMARK).'%\''));
}
if (($LOGIN_USER_PRIV == '1'))
{
if (($CONDITION_STR != ''))
{
$CONDITION_STR1 = (' where '.$CONDITION_STR);
}
}
else
{
$CONDITION_STR1 = (((((((((((((((((''.' where (TO_ID=\'ALL_DEPT\' or InStr(TO_ID,\',').$LOGIN_DEPT_ID).',\')>0 or InStr(TO_ID,\'').$LOGIN_DEPT_ID).',\')=1
or InStr(TO_PERSON_ID,\',').$LOGIN_USER_ID).',\')>0 or InStr(TO_PERSON_ID,\'').$LOGIN_USER_ID).',\')=1
or InStr(MANAGER,\',').$LOGIN_USER_ID).',\')>0 or InStr(MANAGER,\'').$LOGIN_USER_ID).',\')=1
or InStr(PARTICIPATOR,\',').$LOGIN_USER_ID).',\')>0 or InStr(PARTICIPATOR,\'').$LOGIN_USER_ID).',\')=1)');
if (($CONDITION_STR != ''))
{
($CONDITION_STR1 .= ((''.' and ').$CONDITION_STR));
}
}
$query = ('SELECT count(*) from WORK_PLAN'.$CONDITION_STR1);
$cursor = exequery ($connection, $query);
$WORK_PLAN_COUNT = 0;
if ($ROW = mysql_fetch_array ($cursor))
{
$WORK_PLAN_COUNT = $ROW[0];
}
if (($WORK_PLAN_COUNT == 0))
{
echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/work_plan.gif" width="22" height="20" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 查询结果</span><br>
</td>
</tr>
</table>
<br>
';
message ('', '无符合条件的工作计划');
echo ' <P align="center"><input type="button" value="返回" class="BigButton" onClick="location=\'index.php\'"></P>
';
exit ();
}
echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/work_plan.gif" width="22" height="20" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 查询结果</span><br>
</td>
<td valign="bottom" class="small1">共';
echo '<s';
echo 'pan class="big4"> ';
echo $WORK_PLAN_COUNT;
echo '</span> 条符合条件的工作计划
</td>
</tr>
</table>
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">序号</td>
<td nowrap align="center">计划名称</td>
<td nowrap align="center">开始时间</td>
<td nowrap align="center">结束时间</td>
<td nowrap align="center">计划类别</td>
';
echo ' <td nowrap align="center">负责人</td>
<td nowrap align="center">参与人</td>
<td nowrap align="center">附件</td>
<td nowrap align="center">状态</td>
<td nowrap align="center" width="130">操作</td>
</tr>
';
$CUR_DATE = date ('Y-m-d', time ());
$query = (('SELECT * from WORK_PLAN'.$CONDITION_STR1).' order by CREATE_DATE desc');
session_start ();
$QUERY_PLAN = $query;
session_register ('QUERY_PLAN');
$cursor = exequery ($connection, $query);
$WORK_PLAN_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$WORK_PLAN_COUNT;
$PLAN_ID = $ROW['PLAN_ID'];
$NAME = $ROW['NAME'];
$BEGIN_DATE = $ROW['BEGIN_DATE'];
$END_DATE = $ROW['END_DATE'];
$TYPE = $ROW['TYPE'];
$MANAGER = $ROW['MANAGER'];
$PARTICIPATOR1 = $ROW['PARTICIPATOR'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$TO_PERSON_ID = $ROW['TO_PERSON_ID'];
$SUSPEND_FLAG = $ROW['SUSPEND_FLAG'];
$query = (((''.'SELECT * from PLAN_TYPE where TYPE_ID=\'').$TYPE).'\'');
$cursor1 = exequery ($connection, $query);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$TYPE_DESC = $ROW1['TYPE_NAME'];
}
else
{
$TYPE_DESC = '';
}
$MANAGE_NAME = '';
$TOK = strtok ($MANAGER, ',');
while (($TOK != ''))
{
if (($MANAGE_NAME != ''))
{
($MANAGE_NAME .= '，');
}
$query1 = (((''.'select * from USER where USER_ID=\'').$TOK).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$DEPT_ID = $ROW1['DEPT_ID'];
$DEPT_NAME = dept_long_name ($DEPT_ID);
($MANAGE_NAME .= (((('<u title="部门：'.$DEPT_NAME).'" style="cursor:hand">').$ROW1['USER_NAME']).'</u>'));
}
$TOK = strtok (',');
}
$MANAGE_NAME = substr ($MANAGE_NAME, 0, -1);
$PARTICIPATOR_NAME = '';
$TOK = strtok ($PARTICIPATOR1, ',');
while (($TOK != ''))
{
if (($PARTICIPATOR_NAME != ''))
{
($PARTICIPATOR_NAME .= '，');
}
$query1 = (((''.'select * from USER where USER_ID=\'').$TOK).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = dept_long_name ($DEPT_ID);
($PARTICIPATOR_NAME .= (((('<u title="部门：'.$DEPT_NAME).'" style="cursor:hand">').$ROW['USER_NAME']).'</u>'));
}
$TOK = strtok (',');
}
$PARTICIPATOR_NAME = substr ($PARTICIPATOR_NAME, 0, -1);
$TO_PERSON_NAME = '';
$TOK = strtok ($TO_PERSON_ID, ',');
while (($TOK != ''))
{
if (($TO_PERSON_NAME != ''))
{
($TO_PERSON_NAME .= '，');
}
$query1 = (((''.'select * from USER where USER_ID=\'').$TOK).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$DEPT_ID = $ROW1['DEPT_ID'];
$DEPT_NAME = dept_long_name ($DEPT_ID);
($TO_PERSON_NAME .= (((('<u title="部门：'.$DEPT_NAME).'" style="cursor:hand">').$ROW1['USER_NAME']).'</u>'));
}
$TOK = strtok (',');
}
if (($SUSPEND_FLAG == 1))
{
if ((compare_date ($CUR_DATE, $BEGIN_DATE) < 0))
{
$STATUS = 1;
$STATUS_DESC = '未开始';
}
else
{
$STATUS = 2;
$STATUS_DESC = '<font color=\'#00AA00\'><b>进行中</b></font>';
}
if (($END_DATE != '0000-00-00'))
{
if ((0 < compare_date ($CUR_DATE, $END_DATE)))
{
$STATUS = 3;
$STATUS_DESC = '<font color=\'#FF0000\'><b>已结束</b></font>';
}
}
}
else
{
$STATUS = 2;
$STATUS_DESC = '<font color=\'#FF0000\'><b>暂停</b></font>';
}
if ((($WORK_PLAN_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
if (($END_DATE == '0000-00-00'))
{
$END_DATE = '';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td align="center">';
echo $WORK_PLAN_COUNT;
echo '</td>
<td nowrap align="center"><a href="javascript:plan_detail(\'';
echo $PLAN_ID;
echo '\');">';
echo $NAME;
echo '</a></td>
<td nowrap align="center">';
echo $BEGIN_DATE;
echo '</td>
<td nowrap align="center">';
echo $END_DATE;
echo '</a></td>
<td nowrap align="center">';
echo $TYPE_DESC;
echo '</td>
<td align="center">';
echo $MANAGE_NAME;
echo '</td>
<td align="center">';
echo $PARTICIPATOR_NAME;
echo '</td>
<td align="left">
';
if (($ATTACHMENT_NAME == ''))
{
echo '无';
}
else
{
echo attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1, 0, 0, 1, 0, 0);
}
echo ' </td>
<td nowrap align="center">';
echo $STATUS_DESC;
echo '</td>
<td nowrap align="center">
<a href="javascript:;" onClick="window.open(\'../add_diary.php?PLAN_ID=';
echo $PLAN_ID;
echo '\',\'\',\'height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=200,top=60,resizable=yes\');">进度日志</a>
<a href="javascript:;" onClick="window.open(\'../progress_map.php?PLAN_ID=';
echo $PLAN_ID;
echo '\',\'\',\'height=550,width=800,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=110,top=60,resizable=yes\');">进度图</a>
</td>
</tr>
';
}
echo '
<tr class="TableControl">
<td colspan="10" align="center">
<input type="button" value="返回" class="BigButton" onClick="location=\'index.php\'">
</td>
</tr>
</table>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?