📄 index.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\"><script src=\"/inc/js/module.js\"></script>\r\n\r\n<script>\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\n\r\nfunction func_insert()\r\n{\r\n for (i=select2.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\r\n //pos=func_find(select1,option_text);\r\n select1.add(my_option);\r\n select2.remove(i);\r\n }\r\n }//for\r\n\r\n\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\");\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);\r\n select1.remove(i);\r\n }\r\n }//for\r\n\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; i>=0; i--)\r\n select2.options(i).selected=true;\r\n}\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.all(\"STYLE\").value=fld_str;\r\n}\r\n\r\nfunction exreport()\r\n{\r\n\t 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 for(i=0;i<document.all(\"DEPTFLAG\").length;i++)\r\n {\r\n el=document.all(\"DEPTFLAG\").item(i);\r\n if(el.checked)\r\n {\r\n \t val=el.value;\r\n }\r\n }\r\n if(document.all(\"SUMFIELD\").item(0).checked)\r\n { \r\n \t if(val==\"1\")URL=\"report.php?COPY_TO_ID=\"+document.all(\"COPY_TO_ID\").value+\"&fld_str=\"+fld_str+\"&FLOW_ID=\"+document.all(\"FLOW_ID\").value+\"&TOID=\"+document.all(\"TO_ID\").value;\r\n if(val==\"0\")URL=\"report.php?fld_str=\"+fld_str+\"&FLOW_ID=\"+document.all(\"FLOW_ID\").value+\"&DEPT_FLAG=1\";\r\n }\t\r\n if(document.all(\"SUMFIELD\").item(1).checked)\r\n { \r\n \t if(val==\"1\")URL=\"excel_report.php?COPY_TO_ID=\"+document.all(\"COPY_TO_ID\").value+\"&fld_str=\"+fld_str+\"&FLOW_ID=\"+document.all(\"FLOW_ID\").value+\"&TOID=\"+document.all(\"TO_ID\").value;\r\n if(val==\"0\")URL=\"excel_report.php?fld_str=\"+fld_str+\"&FLOW_ID=\"+document.all(\"FLOW_ID\").value+\"&DEPT_FLAG=1\";\r\n }\t\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.open(URL,\"report\",\"height=400,width=550,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=150,resizable=yes\");\r\n \r\n}\r\n\r\nfunction sel_change()\r\n{\r\n\t for(i=0;i<document.all(\"DEPTFLAG\").length;i++)\r\n {\r\n el=document.all(\"DEPTFLAG\").item(i);\r\n if(el.checked)\r\n {\r\n \t val=el.value;\r\n }\r\n }\r\n if(val==\"1\")\r\n {\r\n \tdocument.all(\"SER\").style.display=\"\";\r\n }\r\n else\r\n {\r\n \tdocument.all(\"SER\").style.display=\"none\";\r\n }\r\n\r\n\r\n}\r\nfunction func_up()\r\n{\r\n sel_count=0;\r\n for (i=select1.options.length-1; i>=0; i--)\r\n {\r\n if(select1.options(i).selected)\r\n sel_count++;\r\n }\r\n\r\n if(sel_count==0)\r\n {\r\n alert(\"调整顺序时，请选择其中一项！\");\r\n return;\r\n }\r\n else if(sel_count>1)\r\n {\r\n alert(\"调整顺序时，只能选择其中一项！\");\r\n return;\r\n }\r\n\r\n i=select1.selectedIndex;\r\n\r\n if(i!=0)\r\n {\r\n var my_option = document.createElement(\"OPTION\");\r\n my_option.text=select1.options(i).text;\r\n my_option.value=select1.options(i).value;\r\n\r\n select1.add(my_option,i-1);\r\n select1.remove(i+1);\r\n select1.options(i-1).selected=true;\r\n }\r\n}\r\n\r\nfunction func_down()\r\n{\r\n sel_count=0;\r\n for (i=select1.options.length-1; i>=0; i--)\r\n {\r\n if(select1.options(i).selected)\r\n sel_count++;\r\n }\r\n\r\n if(sel_count==0)\r\n {\r\n alert(\"调整桌面模块的顺序时，请选择其中一项！\");\r\n return;\r\n }\r\n else if(sel_count>1)\r\n {\r\n alert(\"调整桌面模块的顺序时，只能选择其中一项！\");\r\n return;\r\n }\r\n\r\n i=select1.selectedIndex;\r\n\r\n if(i!=select1.options.length-1)\r\n {\r\n var my_option = document.createElement(\"OPTION\");\r\n my_option.text=select1.options(i).text;\r\n my_option.value=select1.options(i).value;\r\n\r\n select1.add(my_option,i+2);\r\n select1.remove(i);\r\n select1.options(i+1).selected=true;\r\n }\r\n}\r\n\r\n\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\" >\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\"><span class=\"big3\"> 工资报表</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<div align=\"center\">\r\n<table class=\"TableBlock\" align=\"center\" >\r\n <tr>\r\n \t<td nowrap class=\"TableContent\"> 人员范围： </td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">\r\n <input type=\"radio\" name='DEPTFLAG' value=\"1\" checked onclick=\"sel_change()\">在职人员 <input type=\"radio\" name='DEPTFLAG' value=\"0\" onclick=\"sel_change()\">外部人员 \r\n </td> \r\n </tr>\r\n <tr id=\"SER\">\r\n \t<form name=\"form1\">\r\n <td nowrap class=\"TableContent\"> 部门： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"hidden\" name=\"TO_ID\">\r\n <textarea cols=21 name=TO_NAME rows=2 class=\"BigStatic\" wrap=\"yes\" readonly>";
echo $TO_NAME;
echo "</textarea>\r\n <a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectDept()\">添加</a>\r\n <a href=\"javascript:;\" class=\"orgClear\" onClick=\"ClearUser()\">清空</a>\r\n </td>\r\n <td nowrap class=\"TableContent\"> 人员： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"hidden\" name=\"COPY_TO_ID\" value=\"\">\r\n <textarea cols=21 name=\"COPY_TO_NAME\" rows=2 class=\"BigStatic\" wrap=\"yes\" readonly></textarea>\r\n <a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectUser('','COPY_TO_ID', 'COPY_TO_NAME')\">选择</a>\r\n <a href=\"javascript:;\" class=\"orgClear\" onClick=\"ClearUser('COPY_TO_ID', 'COPY_TO_NAME')\">清空</a>\r\n </td>\r\n </form>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 输出形式： </td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">\r\n <input type=\"radio\" name='SUMFIELD' value=\"htm\" checked>html报表 <input type=\"radio\" name='SUMFIELD' value=\"excel\">EXCEL报表 \r\n </td> \r\n </tr>\r\n <tr>\t\r\n <td nowrap class=\"TableContent\"> 输出内容：</td>\r\n <td nowrap class=\"TableData\" colspan=\"3\" align=\"left\">\r\n \t<table width=\"150\" class=\"TableBlock\">\r\n <tr bgcolor=\"#CCCCCC\">\r\n \t <td align=\"center\">排序</td>\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 \t <td align=\"center\" bgcolor=\"#999999\">\r\n <input type=\"button\" class=\"SmallInput\" value=\" ↑ \" onClick=\"func_up();\">\r\n <br><br>\r\n <input type=\"button\" class=\"SmallInput\" value=\" ↓ \" onClick=\"func_down();\">\r\n </td>\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 STYLE from SAL_FLOW where FLOW_ID=".$FLOW_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$STYLE = $ROW['STYLE'];
}
if ( $STYLE != "" )
{
$STYLE_ARRAY = explode( ",", $STYLE );
$ARRAY_COUNT = sizeof( $STYLE_ARRAY );
$COUNT = 0;
if ( $STYLE_ARRAY[$ARRAY_COUNT - 1] == "" )
{
--$ARRAY_COUNT;
}
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
$query1 = "select ITEM_ID,ITEM_NAME from SAL_ITEM where ITEM_ID='".$STYLE_ARRAY[$I]."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$ITEM_NAME = $ROW['ITEM_NAME'];
$ITEM_ID = $ROW['ITEM_ID'];
}
echo " <option value=\"";
echo $ITEM_ID;
echo "\">";
echo $ITEM_NAME;
echo "</option>\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=\"#CCCCCC\">\r\n <select name=\"select2\" ondblclick=\"func_insert();\" MULTIPLE style=\"width:200;height:280\">\r\n ";
$query = "SELECT ITEM_ID,ITEM_NAME from SAL_ITEM where ISPRINT='1' ORDER BY `ITEM_ID`";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$ITEM_ID = $ROW['ITEM_ID'];
$ITEM_NAME = $ROW['ITEM_NAME'];
$sign = 0;
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
if ( $STYLE_ARRAY[$I] == $ITEM_ID )
{
$sign = 1;
}
}
if ( $sign == 0 )
{
echo " <option value=\"";
echo $ITEM_ID;
echo "\">";
echo $ITEM_NAME;
echo "</option>\r\n ";
}
}
echo " </select>\r\n <input type=\"button\" value=\" 全 选 \" onClick=\"func_select_all2();\" class=\"SmallInput\">\r\n \r\n </td>\r\n </tr>\r\n</table>\r\n <img src=\"/images/attention.gif\" height=\"18\"> 管理员提示：输出字段为空,输出全部字段\r\n</td>\r\n </tr>\r\n <tfoot align=\"center\" class=\"TableFooter\">\r\n <td nowrap colspan=\"4\" align=\"center\">\r\n \t <input type=\"hidden\" name=\"FLOW_ID\" value=\"";
echo $FLOW_ID;
echo "\">\r\n <input type=\"hidden\" name=\"STYLE\" value=\"\">\r\n <input type=\"submit\" value=\"确定\" class=\"SmallButton\" name=\"button\" onClick=\"exreport()\"> \r\n <input type=\"submit\" value=\"返回\" class=\"SmallButton\" name=\"button\" onClick=\"location='../index.php'\">\r\n </td>\r\n </tfoot>\r\n</table>\r\n</div>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -