📄 add_attend.php
字号:
<?php
include_once( "inc/auth.php" );
echo "<html>\r\n<head>\r\n<title>添加实际参加人员</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script Language=\"JavaScript\">\r\nfunction clear_user()\r\n{\r\n document.form1.COPY_TO_NAME.value=\"\";\r\n document.form1.COPY_TO_ID.value=\"\";\r\n}\r\n\r\nfunction LoadWindow()\r\n{\r\n URL=\"/module/user_select?ID=2\";\r\n loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;\r\n loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;\r\n window.showModalDialog(URL,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:350px;dialogHeight:350px;dialogTop:\"+loc_y+\"px;dialogLeft:\"+loc_x+\"px\");\r\n}\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<select_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<select_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=form1.select2.options.length-1; i>=0; i--)\r\n {\r\n if(form1.select2.options(i).selected)\r\n {\r\n option_text=form1.select2.options(i).text;\r\n option_value=form1.select2.options(i).value;\r\n option_style_color=form1.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\r\n pos=func_find(form1.select1,option_text);\r\n form1.select1.add(my_option,pos);\r\n form1.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=form1.select1.options.length-1; i>=0; i--)\r\n {\r\n if(form1.select1.options(i).selected)\r\n {\r\n option_text=form1.select1.options(i).text;\r\n option_value=form1.select1.options(i).value;\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\r\n pos=func_find(form1.select2,option_text);\r\n form1.select2.add(my_option,pos);\r\n form1.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=form1.select1.options.length-1; i>=0; i--)\r\n form1.select1.options(i).selected=true;\r\n}\r\n\r\nfunction func_select_all2()\r\n{\r\n for (i=form1.select2.options.length-1; i>=0; i--)\r\n form1.select2.options(i).selected=true;\r\n}\r\n\r\nfunction func_init()\r\n{\r\n func_color(form1.select1);\r\n func_color(form1.select2);\r\n}\r\n\r\nfunction mysubmit()\r\n{\r\n fld_str=\"\";\r\n for (i=0; i< form1.select1.options.length; i++)\r\n {\r\n options_value=form1.select1.options(i).value;\r\n fld_str+=options_value+\",\";\r\n }\r\n document.form1.COPY_TO_ID.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=\"add_attend.php?VIEW_TYPE=";
echo 1 - $VIEW_TYPE;
echo "&COURSE_NAME=";
echo $COURSE_NAME;
echo "&APPLY_TID=";
echo $APPLY_TID;
echo "\";\r\n}\r\n</script>\r\n</head>\r\n";
$query = "SELECT * from TRAIN_NEWCOURSE where TRAINING_ID='".$APPLY_TID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$TRAIN_ID = $ROW['TRAIN_ID'];
$ATTEND_PERSONS = $ROW['ATTEND_PERSONS'];
$NOTATTENDER = $ROW['NOTATTENDER'];
}
echo "\r\n<body class=\"bodycolor\" topmargin=\"5\" onload=\"func_init();\">\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\"><span class=\"big3\"> 添加实际参加人员</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<table border=\"0\" cellspacing=\"1\" width=\"450\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\" >\r\n <form action=\"add_attend_submit.php\" method=\"post\" name=\"form1\">\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"90\">培训课程编号：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"TRAIN_ID\" size=\"10\" readonly maxlength=\"100\" class=\"BigStatic\" value=\"";
echo $TRAIN_ID;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"90\">培训课程名称：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"COURSE_NAME\" size=\"27\" readonly maxlength=\"100\" class=\"BigStatic\" value=\"";
echo $COURSE_NAME;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"90\">选择方式：</td>\r\n <td class=\"TableData\">\r\n <select 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 <tr>\r\n <td class=\"TableData\" colspan=\"2\"> \t \t\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 <select 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 and find_in_set(USER.USER_ID,'".$ATTEND_PERSONS."') 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'];
}
}
echo " <option value=\"";
echo $USER_ID1;
echo "\">[";
echo $GROUP_NAME;
echo "] ";
echo $USER_NAME;
echo "</option>\r\n";
}
echo " </select>\r\n <input type=\"button\" value=\" 全 选 \" onclick=\"func_select_all1();\" class=\"SmallInput\">\r\n </td> \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=\"#CCCCCC\">\r\n <select 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 and find_in_set(USER.USER_ID,'".$NOTATTENDER."') 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'];
}
}
echo "<option value=\"";
echo $USER_ID1;
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 <tr bgcolor=\"#CCCCCC\">\r\n <td align=\"center\" valign=\"top\" colspan=\"3\">点击条目时，可以组合CTRL或SHIFT键进行多选<br>\r\n <input type=\"hidden\" name=\"COPY_TO_ID\" value=\"\">\r\n <input type=\"hidden\" value=\"";
echo $APPLY_TID;
echo "\" name=\"APPLY_TID\">\r\n <input type=\"button\" class=\"BigButton\" value=\"保 存\" onclick=\"mysubmit();\"> \r\n <input type=\"button\" class=\"BigButton\" value=\"关闭\" onClick=\"window.close();\" title=\"关闭窗口\"> \r\n </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n </form>\r\n</table>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -