other.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 172 行
PHP
172 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>选择人员</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
include_once 'inc/menu_button.js';
echo '
';
echo '<s';
echo 'cript Language="JavaScript">
var parent_window = parent.dialogArguments;
function add_other(USER_ID,USER_ID_NAME)
{
parent_window.form1.USER_ID.value="";
parent_window.form1.USER_ID_NAME.value="";
parent_window.form1.USER_ID.value=USER_ID;
parent_window.form1.USER_ID_NAME.value=USER_ID_NAME;
parent.close();
}
</script>
</head>
<body class="bodycolor" onMouseover="borderize_o';
echo 'n(event)" onMouseout="borderize_off(event)" onclick="borderize_on1(event)" topmargin="5">
';
$query = ((((''.'SELECT * from FLOW_RUN_PRCS where RUN_ID=').$RUN_ID).' and PRCS_ID=').$PRCS_ID);
$cursor = exequery ($connection, $query);
$USER_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$USER_COUNT;
$USER_ID = $ROW['USER_ID'];
$FLOW_PRCS = $ROW['FLOW_PRCS'];
}
$query1 = ((((''.'SELECT * from FLOW_PROCESS WHERE FLOW_ID=').$FLOW_ID).' and PRCS_ID=').$FLOW_PRCS);
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$PRCS_NAME = $ROW['PRCS_NAME'];
$PRCS_USER = $ROW['PRCS_USER'];
$PRCS_DEPT = $ROW['PRCS_DEPT'];
$PRCS_PRIV = $ROW['PRCS_PRIV'];
}
if (($USER_COUNT == 1))
{
if (($PRCS_DEPT != ''))
{
$PRCS_DEPT = substr ($PRCS_DEPT, 0, (strlen ($PRCS_DEPT) - 1));
$query1 = (((''.'SELECT * from USER,USER_PRIV WHERE USER.USER_PRIV=USER_PRIV.USER_PRIV and DEPT_ID in(').$PRCS_DEPT).') and NOT_LOGIN!=\'1\' order by PRIV_NO,USER_NO,USER_NAME');
$cursor1 = exequery ($connection, $query1);
while ($ROW = mysql_fetch_array ($cursor1))
{
$USER_ID = $ROW['USER_ID'];
if (!find_id ($PRCS_USER, $USER_ID))
{
($PRCS_USER .= ($USER_ID.','));
continue;
}
}
}
if (($PRCS_PRIV != ''))
{
$PRCS_PRIV = substr ($PRCS_PRIV, 0, (strlen ($PRCS_PRIV) - 1));
$query1 = (((''.'SELECT * from USER,USER_PRIV WHERE USER.USER_PRIV=USER_PRIV.USER_PRIV and USER.USER_PRIV in(').$PRCS_PRIV).') and NOT_LOGIN!=\'1\' order by PRIV_NO,USER_NO,USER_NAME');
$cursor1 = exequery ($connection, $query1);
while ($ROW = mysql_fetch_array ($cursor1))
{
$USER_ID = $ROW['USER_ID'];
if (!find_id ($PRCS_USER, $USER_ID))
{
($PRCS_USER .= ($USER_ID.','));
continue;
}
}
}
}
else
{
$PRCS_USER = '';
$query = ((((''.'SELECT * from FLOW_RUN_PRCS where RUN_ID=').$RUN_ID).' and PRCS_ID=').$PRCS_ID);
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$USER_ID = $ROW['USER_ID'];
if (!find_id ($PRCS_USER, $USER_ID))
{
($PRCS_USER .= ($USER_ID.','));
continue;
}
}
}
$MY_ARRAY = explode (',', $PRCS_USER);
$ARRAY_COUNT = sizeof ($MY_ARRAY);
if (($MY_ARRAY[($ARRAY_COUNT - 1)] == ''))
{
--$ARRAY_COUNT;
}
$OTHER_COUNT = 0;
for ($I = 0; ($I < $ARRAY_COUNT); ++$I)
{
if (($MY_ARRAY[$I] != $LOGIN_USER_ID))
{
if (($USER_NAME_STR != ''))
{
$WHERE_STR = (((''.' and USER.USER_NAME like \'%').$USER_NAME_STR).'%\'');
}
$query1 = ((((''.'SELECT * from USER,DEPARTMENT where USER_ID=\'').$MY_ARRAY[$I]).'\' and USER.DEPT_ID=DEPARTMENT.DEPT_ID').$WHERE_STR);
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$USER_NAME = $ROW['USER_NAME'];
$DEPT_NAME = $ROW['DEPT_NAME'];
$NOT_LOGIN = $ROW['NOT_LOGIN'];
if ($NOT_LOGIN)
{
continue;
}
else
{
++$OTHER_COUNT;
if (($OTHER_COUNT == 1))
{
echo '<table border="1" cellspacing="0" width="95%" class="small" cellpadding="3" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
';
}
echo ' <tr class="TableControl">
<td class="menulines" align="center" onclick="javascript:add_other(\'';
echo $MY_ARRAY[$I];
echo '\',\'';
echo $USER_NAME;
echo '\')" style="cursor:hand">';
echo $USER_NAME;
echo '(';
echo $DEPT_NAME;
echo ')</a></td>
</tr>
';
continue;
}
continue;
}
continue;
}
}
if ((($OTHER_COUNT == 0) AND ($USER_NAME_STR == '')))
{
message ('提示', '本步骤无可供选择的代办人');
}
else
{
if ((($OTHER_COUNT == 0) AND ($USER_NAME_STR != '')))
{
message ('提示', '本步骤无所查找的人员');
}
else
{
echo '<thead class="TableControl">
<th bgcolor="#d6e7ef" align="center"><b>选择人员</b></th>
</thead>
</table>
';
}
}
echo '
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?