others.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 340 行
PHP
340 行
<?
include_once 'inc/auth.php';
include_once '../../prcs_role.php';
if (!run_role ($RUN_ID, $PRCS_ID))
{
exit ();
}
echo '
<html>
<head>
<title>委托代办人</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<S';
echo 'CRIPT language=javascript>
function LoadWindow(PRCS_ID_I)
{
URL="user_select?FLOW_ID=';
echo $FLOW_ID;
echo '&RUN_ID=';
echo $RUN_ID;
echo '&PRCS_ID=" + PRCS_ID_I;
loc_x=document.body.scrollLeft+event.clientX-event.offsetX;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+210;
window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:250px;dialogHeight:300px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
function CheckForm()
{
if (document.form1.USER_ID.value=="")
{';
echo ' alert("请指定当前步骤的代办人！");
return (false);
}
return (true);
}
</SCRIPT>
</head>
<body class="bodycolor" topmargin="5">
';
$query = ((''.'SELECT FLOW_NAME,FORM_ID from FLOW_TYPE WHERE FLOW_ID=').$FLOW_ID);
$cursor1 = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor1))
{
$FLOW_NAME = $ROW['FLOW_NAME'];
$FORM_ID = $ROW['FORM_ID'];
}
$query = ((''.'SELECT RUN_NAME from FLOW_RUN WHERE RUN_ID=').$RUN_ID);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$RUN_NAME = $ROW['RUN_NAME'];
}
echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/green_arrow.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 委托代办人/转交主办权</span><br>
</td>
</tr>
</table>
<table border="0" cellspacing="1" class="small" bgcolor="#000000" cellpadding="3" width="90%">
<form action="others_submit.php" method="post" name="form1" onsubmit="return CheckForm();">
<tr class="TableHeader">
<td nowrap align="center" class="Big" colspan="2"><b>';
echo $FLOW_NAME;
echo '</b></td>
</tr>
';
for ($PRCS_ID_I = 1; ($PRCS_ID_I <= $PRCS_ID); ++$PRCS_ID_I)
{
$query = ((((''.'SELECT USER_ID,FLOW_PRCS from FLOW_RUN_PRCS where RUN_ID=').$RUN_ID).' and PRCS_ID=').$PRCS_ID_I);
$cursor = exequery ($connection, $query);
$USER_NAME_STR = '';
$USER_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$USER_COUNT;
$USER_ID = $ROW['USER_ID'];
$FLOW_PRCS = $ROW['FLOW_PRCS'];
$query1 = (((''.'SELECT USER_NAME from USER where USER_ID=\'').$USER_ID).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
($USER_NAME_STR .= ($ROW['USER_NAME'].','));
continue;
}
}
$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'];
}
$USER_NAME_STR = substr ($USER_NAME_STR, 0, (strlen ($USER_NAME_STR) - 1));
if (($PRCS_ID_I != $PRCS_ID))
{
echo '
<tr class="TableData">
<td nowrap width="10%">';
echo $PRCS_ID_I;
echo '：';
echo $PRCS_NAME;
echo '</td>
<td>';
echo $USER_NAME_STR;
echo '</td>
</tr>
';
continue;
}
else
{
echo ' <tr class="TableData">
<td nowrap width="10%">';
echo $PRCS_ID_I;
echo '：';
echo $PRCS_NAME;
echo ' (当前步骤)</td>
<td>
';
if (((1 < $USER_COUNT) AND !$OP_FLAG))
{
echo '本步骤为会签步骤，不能指定代办人；且您不是主办人，不能转交主办权';
}
else
{
if (($USER_COUNT == 1))
{
if (($PRCS_DEPT != ''))
{
$PRCS_DEPT = substr ($PRCS_DEPT, 0, (strlen ($PRCS_DEPT) - 1));
$query1 = (((''.'SELECT USER_ID 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 USER_ID 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 USER_ID from FLOW_RUN_PRCS where RUN_ID=').$RUN_ID).' and PRCS_ID=').$PRCS_ID_I);
$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))
{
++$OTHER_COUNT;
$query1 = (((''.'SELECT USER_NAME,USER_ID,DEPT_NAME,NOT_LOGIN from USER,DEPARTMENT where USER_ID=\'').$MY_ARRAY[$I]).'\' and USER.DEPT_ID=DEPARTMENT.DEPT_ID');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
if (($OTHER_COUNT == 1))
{
$FIRST_USER_NAME = $ROW['USER_NAME'];
$FIRST_USER_ID = $ROW['USER_ID'];
}
$USER_NAME = $ROW['USER_NAME'];
$DEPT_NAME = $ROW['DEPT_NAME'];
$NOT_LOGIN = $ROW['NOT_LOGIN'];
if ($NOT_LOGIN)
{
continue;
}
}
if (($OTHER_COUNT == 1))
{
if (($USER_COUNT == 1))
{
echo '<b><font color=red>委托代办人为：</font></b>';
continue;
}
else
{
echo '<b><font color=red>转交主办权给：</font></b>';
continue;
}
continue;
}
continue;
}
}
if ((($MY_ARRAY[0] == $LOGIN_USER_ID) AND ($ARRAY_COUNT == 1)))
{
$I = 0;
}
if (($I == 0))
{
echo '<font color=red><b>本步骤无可供选择的代办人</b></font>';
}
else
{
echo '<input type="text" name="USER_ID_NAME" size="10" class="BigStatic" readonly value="';
echo $FIRST_USER_NAME;
echo '">
<input type="hidden" name="USER_ID" value="';
echo $FIRST_USER_ID;
echo '">
<input type="button" value="选择" class="BigButton" onClick="LoadWindow(';
echo $PRCS_ID_I;
echo ')" title="指定代办人或主办人" name="button">
';
}
}
echo ' </td>
</tr>
';
continue;
}
}
if ((($USER_COUNT == 1) OR $OP_FLAG))
{
echo ' <tr class="TableHeader">
<td colspan="2"><b>短信提醒</b></td>
</tr>
';
$query = 'select PARA_VALUE from SYS_PARA where PARA_NAME=\'SMS_REMIND\'';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$PARA_VALUE = $ROW['PARA_VALUE'];
}
$SMS_REMIND = substr ($PARA_VALUE, 0, strpos ($PARA_VALUE, '|'));
$SMS2_REMIND = substr ($PARA_VALUE, (strpos ($PARA_VALUE, '|') + 1));
echo ' <tr class="TableData">
<td colspan="2">
<input type="checkbox" name="SMS_REMIND" id="SMS_REMIND" ';
if (find_id ($SMS_REMIND, '7'))
{
echo 'checked';
}
echo '><label for="SMS_REMIND">使用内部短信提醒经办人</label>
';
$query = 'select TYPE_PRIV from SMS2_PRIV';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$TYPE_PRIV = $ROW['TYPE_PRIV'];
}
if (find_id ($TYPE_PRIV, 7))
{
echo ' <input type="checkbox" name="SMS2_REMIND" id="SMS2_REMIND" ';
if (find_id ($SMS_REMIND, '7'))
{
echo 'checked';
}
echo '><label for="SMS2_REMIND">使用手机短信提醒经办人</label>
';
}
if (($USER_COUNT == 1))
{
$SMS_CONTENT = ('工作流委托提醒：'.$RUN_NAME);
}
else
{
$SMS_CONTENT = ('工作流主办权转交提醒：'.$RUN_NAME);
}
echo '<br>
短信内容：<input type="text" name="SMS_CONTENT" value="';
echo $SMS_CONTENT;
echo '" size="62" maxlength="100" class="SmallInput">
</td>
</tr>
';
}
echo ' <tr class="TableControl">
<td nowrap align="center" colspan="2">
<input type="hidden" name="RUN_ID" value="';
echo $RUN_ID;
echo '">
<input type="hidden" name="USER_COUNT" value="';
echo $USER_COUNT;
echo '">
<input type="hidden" name="MENU_FLAG" value="';
echo $MENU_FLAG;
echo '">
<input type="hidden" name="FLOW_ID" value="';
echo $FLOW_ID;
echo '">
<input type="hidden" name="PRCS_ID" value="';
echo $PRCS_ID;
echo '">
';
if (($I != 0))
{
echo ' <input type="submit" value="确定" class="BigButton" name="submit">
';
}
echo ' <input type="button" value="返回" class="BigButton" name="back" onClick="history.back();">
</td>
</tr>
</table>
</form>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?