📄 set_user.php
字号:
<?php
include_once( "inc/auth.php" );
echo "\r\n<html>\r\n<head>\r\n<title>编辑经办人员</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n\r\n";
echo "<s";
echo "cript>\r\n\r\nfunction func_find(select_obj,option_text)\r\n{\r\n pos=option_text.indexOf(\"] \")+1;\r\n option_text=option_text.substr(0,pos);\r\n\r\n for (j=0; j";
echo "<s";
echo "elect_obj.options.length; j++)\r\n {\r\n str=select_obj.options(j).text;\r\n if(str.indexOf(option_text)>=0)\r\n return j;\r\n }//for\r\n\r\n return j;\r\n}\r\n\r\nfunction func_color(select_obj)\r\n{\r\n font_color=\"red\";\r\n option_text=\"\";\r\n for (j=0; j";
echo "<s";
echo "elect_obj.options.length; j++)\r\n {\r\n str=select_obj.options(j).text;\r\n if(str.indexOf(option_text)<0)\r\n {\r\n if(font_color==\"red\")\r\n font_color=\"blue\";\r\n else\r\n font_color=\"red\";\r\n }\r\n select_obj.options(j).style.color=font_color;\r\n\r\n pos=str.indexOf(\"] \")+1;\r\n option_text=str.substr(0,pos);\r\n }//for\r\n\r\n return j;\r\n}\r\n\r\nfunction func_insert()\r\n{\r\n for (i=selec";
echo "t2.options.length-1; i>=0; i--)\r\n {\r\n if(select2.options(i).selected)\r\n {\r\n option_text=select2.options(i).text;\r\n option_value=select2.options(i).value;\r\n option_style_color=select2.options(i).style.color;\r\n\r\n var my_option = document.createElement(\"OPTION\");\r\n my_option.text=option_text;\r\n my_option.value=option_value;\r\n my_option.style.color=option_style_color;\r\n";
echo "\r\n pos=func_find(select1,option_text);\r\n select1.add(my_option,pos);\r\n select2.remove(i);\r\n }\r\n }//for\r\n\r\n func_init();\r\n}\r\n\r\nfunction func_delete()\r\n{\r\n for (i=select1.options.length-1; i>=0; i--)\r\n {\r\n if(select1.options(i).selected)\r\n {\r\n option_text=select1.options(i).text;\r\n option_value=select1.options(i).value;\r\n\r\n var my_option = document.createElement(\"OPTION\"";
echo ");\r\n my_option.text=option_text;\r\n my_option.value=option_value;\r\n\r\n pos=func_find(select2,option_text);\r\n select2.add(my_option,pos);\r\n select1.remove(i);\r\n }\r\n }//for\r\n\r\n func_init();\r\n}\r\n\r\nfunction func_select_all1()\r\n{\r\n for (i=select1.options.length-1; i>=0; i--)\r\n select1.options(i).selected=true;\r\n}\r\n\r\nfunction func_select_all2()\r\n{\r\n for (i=select2.options.length-1; ";
echo "i>=0; i--)\r\n select2.options(i).selected=true;\r\n}\r\n\r\nfunction func_init()\r\n{\r\n func_color(select2);\r\n func_color(select1);\r\n}\r\n\r\nfunction mysubmit()\r\n{\r\n fld_str=\"\";\r\n for (i=0; i< select1.options.length; i++)\r\n {\r\n options_value=select1.options(i).value;\r\n fld_str+=options_value+\",\";\r\n }\r\n document.form1.FLD_STR.value=fld_str;\r\n document.form1.submit();\r\n}\r\n\r\n";
if ( $VIEW_TYPE == "" )
{
$VIEW_TYPE = 0;
}
echo "function set_view_type()\r\n{\r\n location=\"set_user.php?FLOW_ID=";
echo $FLOW_ID;
echo "&ID=";
echo $ID;
echo "&VIEW_TYPE=";
echo 1 - $VIEW_TYPE;
echo "\";\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\" onload=\"func_init();\">\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/edit.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> 编辑经办人员</span>\r\n \r\n ";
echo "<s";
echo "elect class=\"BigSelect\" name=\"VIEW_TYPE\" onchange=\"set_view_type();\">\r\n <option value=\"0\">按部门选择人员</option>\r\n <option value=\"1\" ";
if ( $VIEW_TYPE == 1 )
{
echo "selected";
}
echo ">按角色选择人员</option>\r\n </select>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<hr width=\"95%\" height=\"1\" align=\"left\" class=\"big1\">\r\n<br>\r\n\r\n";
$connection = openconnection( );
$query = "select * from FLOW_PROCESS where ID={$ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PRCS_USER = $ROW['PRCS_USER'];
}
echo "\r\n<table width=\"500\" border=\"1\" cellspacing=\"0\" cellpadding=\"3\" align=\"center\" bordercolorlight=\"#000000\" bordercolordark=\"#FFFFFF\" class=\"big\">\r\n <tr bgcolor=\"#CCCCCC\">\r\n <td align=\"center\"><b>经办人员</b></td>\r\n <td align=\"center\"> </td>\r\n <td align=\"center\" valign=\"top\"><b>备选人员</b></td>\r\n </tr>\r\n <tr>\r\n <td valign=\"top\" align=\"center\" bgcolor=\"#CCCCCC\">\r\n ";
echo "<s";
echo "elect name=\"select1\" ondblclick=\"func_delete();\" MULTIPLE style=\"width:200;height:280\">\r\n";
$query = "SELECT * from USER,USER_PRIV,DEPARTMENT where USER.DEPT_ID=DEPARTMENT.DEPT_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV";
if ( $VIEW_TYPE == 0 )
{
$query .= " order by DEPT_NO,PRIV_NO,USER_NAME";
}
else
{
$query .= " order by PRIV_NO,DEPT_NO,USER_NAME";
}
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_ID = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
$DEPT_ID = $ROW['DEPT_ID'];
$USER_PRIV = $ROW['USER_PRIV'];
if ( $VIEW_TYPE == 0 )
{
$query1 = "SELECT * from DEPARTMENT where DEPT_ID=".$DEPT_ID;
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$GROUP_NAME = $ROW['DEPT_NAME'];
}
}
else
{
$query1 = "SELECT * from USER_PRIV where USER_PRIV=".$USER_PRIV;
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$GROUP_NAME = $ROW['PRIV_NAME'];
}
}
if ( find_id( $PRCS_USER, $USER_ID ) )
{
echo " <option value=\"";
echo $USER_ID;
echo "\">[";
echo $GROUP_NAME;
echo "] ";
echo $USER_NAME;
echo "</option>\r\n\r\n ";
}
}
echo " </select>\r\n <input type=\"button\" value=\" 全 选 \" onclick=\"func_select_all1();\" class=\"SmallInput\">\r\n </td>\r\n\r\n <td align=\"center\" bgcolor=\"#999999\">\r\n <input type=\"button\" class=\"SmallInput\" value=\" ← \" onclick=\"func_insert();\">\r\n <br><br>\r\n <input type=\"button\" class=\"SmallInput\" value=\" → \" onclick=\"func_delete();\">\r\n </td>\r\n\r\n <td align=\"center\" valign=\"top\" bgcolor=\"#";
echo "CCCCCC\">\r\n ";
echo "<s";
echo "elect name=\"select2\" ondblclick=\"func_insert();\" MULTIPLE style=\"width:200;height:280\">\r\n";
$query = "SELECT * from USER,USER_PRIV,DEPARTMENT where USER.DEPT_ID=DEPARTMENT.DEPT_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV";
if ( $VIEW_TYPE == 0 )
{
$query .= " order by DEPT_NO,PRIV_NO,USER_NAME";
}
else
{
$query .= " order by PRIV_NO,DEPT_NO,USER_NAME";
}
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_ID = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
$DEPT_ID = $ROW['DEPT_ID'];
$USER_PRIV = $ROW['USER_PRIV'];
if ( $VIEW_TYPE == 0 )
{
$query1 = "SELECT * from DEPARTMENT where DEPT_ID=".$DEPT_ID;
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$GROUP_NAME = $ROW['DEPT_NAME'];
}
}
else
{
$query1 = "SELECT * from USER_PRIV where USER_PRIV=".$USER_PRIV;
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$GROUP_NAME = $ROW['PRIV_NAME'];
}
}
if ( !find_id( $PRCS_USER, $USER_ID ) )
{
echo " <option value=\"";
echo $USER_ID;
echo "\">[";
echo $GROUP_NAME;
echo "] ";
echo $USER_NAME;
echo "</option>\r\n\r\n ";
}
}
echo " </select>\r\n <input type=\"button\" value=\" 全 选 \" onclick=\"func_select_all2();\" class=\"SmallInput\">\r\n </td>\r\n </tr>\r\n\r\n <tr bgcolor=\"#CCCCCC\">\r\n <td align=\"center\" valign=\"top\" colspan=\"3\">\r\n <form action=\"submit1.php\" method=\"post\" name=\"form1\">\r\n 点击条目时，可以组合CTRL或SHIFT键进行多选<br>\r\n <input type=\"button\" class=\"BigButton\" value=\"保 存\" onclick=\"mysubmit();\"> ";
echo " \r\n <input type=\"button\" class=\"BigButton\" value=\"返 回\" onclick=\"location='index.php?FLOW_ID=";
echo $FLOW_ID;
echo "'\">\r\n <input type=\"hidden\" name=\"FLOW_ID\" value=\"";
echo $FLOW_ID;
echo "\">\r\n <input type=\"hidden\" name=\"ID\" value=\"";
echo $ID;
echo "\">\r\n <input type=\"hidden\" name=\"FLD_STR\" value=\"\">\r\n </form>\r\n </td>\r\n </tr>\r\n\r\n</table>\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -