📄 set_new.php
字号:
<?
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">
<script>
function func_find(select_obj,option_text)
{
pos=option_text.indexOf("] ")+1;
option_text=option_text.substr(0,pos);
for (j=0; j<select_obj.options.length; j++)
{
str=select_obj.options(j).text;
if(str.indexOf(option_text)>=0)
return j;
}//for
return j;
}
function func_color(select_obj)
{
font_color="red";
option_text="";
for (j=0; j<select_obj.options.length; j++)
{
str=select_obj.options(j).text;
if(str.indexOf(option_text)<0)
{
if(font_color=="red")
font_color="blue";
else
font_color="red";
}
select_obj.options(j).style.color=font_color;
pos=str.indexOf("] ")+1;
option_text=str.substr(0,pos);
}//for
return j;
}
function func_insert()
{
for (i=select2.options.length-1; i>=0; i--)
{
if(select2.options(i).selected)
{
option_text=select2.options(i).text;
option_value=select2.options(i).value;
option_style_color=select2.options(i).style.color;
var my_option = document.createElement("OPTION");
my_option.text=option_text;
my_option.value=option_value;
my_option.style.color=option_style_color;
pos=func_find(select1,option_text);
select1.add(my_option,pos);
select2.remove(i);
}
}//for
func_init();
}
function func_delete()
{
for (i=select1.options.length-1; i>=0; i--)
{
if(select1.options(i).selected)
{
option_text=select1.options(i).text;
option_value=select1.options(i).value;
var my_option = document.createElement("OPTION");
my_option.text=option_text;
my_option.value=option_value;
pos=func_find(select2,option_text);
select2.add(my_option,pos);
select1.remove(i);
}
}//for
func_init();
}
function func_select_all1()
{
for (i=select1.options.length-1; i>=0; i--)
select1.options(i).selected=true;
}
function func_select_all2()
{
for (i=select2.options.length-1; i>=0; i--)
select2.options(i).selected=true;
}
function func_init()
{
func_color(select2);
func_color(select1);
}
function mysubmit()
{
fld_str="";
for (i=0; i< select1.options.length; i++)
{
options_value=select1.options(i).value;
fld_str+=options_value+",";
}
document.form1.FLD_STR.value=fld_str;
document.form1.submit();
}
';
if ($VIEW_TYPE == '')
{
$VIEW_TYPE = 0;
}
echo 'function set_view_type()
{
location="set_new.php?SORT_ID=';
echo $SORT_ID;
echo '&VIEW_TYPE=';
echo 1 - $VIEW_TYPE;
echo '";
}
</script>
</head>
<body class="bodycolor" topmargin="5" onload="func_init();">
';
$connection = openconnection ();
$query = 'select * from FILE_SORT where SORT_ID=' . $SORT_ID;
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$USER_ID = $ROW['USER_ID'];
$DEPT_ID = $ROW['DEPT_ID'];
$NEW_USER = $ROW['NEW_USER'];
$SORT_TYPE = $ROW['SORT_TYPE'];
if ($USER_ID == '')
{
$USER_ID = access_priv ($SORT_ID);
}
if ($NEW_USER == '')
{
$NEW_USER = sort_priv ($SORT_ID, 'NEW_USER');
}
$NEW_USER = check_id ($USER_ID, $NEW_USER, true);
}
echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/edit.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 指定新建权限</span>
<select class="BigSelect" name="VIEW_TYPE" onchange="set_view_type();">
<option value="0">按部门选择人员</option>
<option value="1" ';
if ($VIEW_TYPE == 1)
{
echo 'selected';
}
echo '>按角色选择人员</option>
</select>
</td>
</tr>
</table>
<br>
<table width="500" border="1" cellspacing="0" cellpadding="3" align="center" bordercolorlight="#000000" bordercolordark="#FFFFFF" class="big">
<tr bgcolor="#CCCCCC">
<td align="center"><b>可新建文件人员</b></td>
<td align="center"> </td>
<td align="center" valign="top"><b>备选人员</b></td>
</tr>
<tr>
<td valign="top" align="center" bgcolor="#CCCCCC">
<select name="select1" ondblclick="func_delete();" MULTIPLE style="width:200;height:280">
';
$query = 'SELECT * from USER,USER_PRIV,DEPARTMENT where USER.DEPT_ID=DEPARTMENT.DEPT_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV and NOT_LOGIN!=\'1\'';
if ($VIEW_TYPE == 0)
{
$query .= ' order by DEPT_NO,USER.DEPT_ID,PRIV_NO,USER_NO,USER_NAME';
}
else
{
$query .= ' order by PRIV_NO,DEPT_NO,USER_NO,USER_NAME';
}
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$USER_ID1 = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
$DEPT_ID1 = $ROW['DEPT_ID'];
$USER_PRIV = $ROW['USER_PRIV'];
if ($VIEW_TYPE == 0)
{
$query1 = 'SELECT * from DEPARTMENT where DEPT_ID=' . $DEPT_ID1;
$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 ($NEW_USER, $USER_ID1))
{
echo ' <option value="';
echo $USER_ID1;
echo '">[';
echo $GROUP_NAME;
echo '] ';
echo $USER_NAME;
echo '</option>
';
continue;
}
}
echo ' </select>
<input type="button" value=" 全 选 " onclick="func_select_all1();" class="SmallInput">
</td>
<td align="center" bgcolor="#999999">
<input type="button" class="SmallInput" value=" ← " onclick="func_insert();">
<br><br>
<input type="button" class="SmallInput" value=" → " onclick="func_delete();">
</td>
<td align="center" valign="top" bgcolor="#CCCCCC">
<select name="select2" ondblclick="func_insert();" MULTIPLE style="width:200;height:280">
';
if ($SORT_TYPE == '1')
{
$query = 'SELECT * from USER,USER_PRIV,DEPARTMENT where USER.DEPT_ID=DEPARTMENT.DEPT_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV and NOT_LOGIN!=\'1\'';
}
else
{
if ($SORT_TYPE == '2')
{
$query = 'SELECT * from USER,USER_PRIV,DEPARTMENT where USER.DEPT_ID=DEPARTMENT.DEPT_ID and USER.DEPT_ID=' . $DEPT_ID . ' and USER.USER_PRIV=USER_PRIV.USER_PRIV and NOT_LOGIN!=\'1\'';
}
else
{
$query = 'SELECT * from USER,USER_PRIV,DEPARTMENT where USER.DEPT_ID=DEPARTMENT.DEPT_ID and (InStr(\'' . $USER_ID . '\',CONCAT(\',\',USER_ID,\',\'))>0 or InStr(\'' . $USER_ID . '\',CONCAT(USER_ID,\',\'))=1) and USER.USER_PRIV=USER_PRIV.USER_PRIV and NOT_LOGIN!=\'1\'';
}
}
if ($VIEW_TYPE == 0)
{
$query .= ' order by DEPT_NO,USER.DEPT_ID,PRIV_NO,USER_NO,USER_NAME';
}
else
{
$query .= ' order by PRIV_NO,DEPT_NO,USER_NO,USER_NAME';
}
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$USER_ID1 = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
$DEPT_ID1 = $ROW['DEPT_ID'];
$USER_PRIV = $ROW['USER_PRIV'];
if ($VIEW_TYPE == 0)
{
$query1 = 'SELECT * from DEPARTMENT where DEPT_ID=' . $DEPT_ID1;
$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 ($NEW_USER, $USER_ID1)))
{
if (find_id ($USER_ID, $USER_ID1))
{
echo ' <option value="';
echo $USER_ID1;
echo '">[';
echo $GROUP_NAME;
echo '] ';
echo $USER_NAME;
echo '</option>
';
continue;
}
continue;
}
}
echo ' </select>
<input type="button" value=" 全 选 " onclick="func_select_all2();" class="SmallInput">
</td>
</tr>
<tr bgcolor="#CCCCCC">
<td align="center" valign="top" colspan="3">
<form action="new_submit.php" method="post" name="form1">
点击条目时，可以组合CTRL或SHIFT键进行多选<br>
<input type="button" class="BigButton" value="保 存" onclick="mysubmit();">
<input type="button" class="BigButton" value="返 回" onclick="parent.parent.location=\'../index.php\'">
<input type="hidden" name="SORT_ID" value="';
echo $SORT_ID;
echo '">
<input type="hidden" name="FLD_STR" value="">
</form>
</td>
</tr>
</table>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -