📄 query.php
字号:
include_once( "inc/utility_field.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<script Language=\"JavaScript\">\r\n\r\nfunction move_option(e1,e2)\r\n{\r\n for (var i=0;i<e1.options.length; i++)\r\n {\r\n if(e1.options(i).selected)\r\n {\r\n option_text=e1.options(i).text;\r\n option_value=e1.options(i).value;\r\n option_style_color=e1.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 e2.add(my_option);\r\n e1.remove(i);\r\n\t i--;\r\n }\r\n }//for\r\n}\r\nfunction func_select_all1()\r\n{\r\n for (i=document.form1.select1.options.length-1; i>=0; i--)\r\n document.form1.select1.options(i).selected=true;\r\n}\r\nfunction func_select_all2()\r\n{\r\n for (i=document.form1.select2.options.length-1; i>=0; i--)\r\n document.form1.select2.options(i).selected=true;\r\n}\r\n\r\nfunction exreport()\r\n{\r\n\t fld_str=\"\";\r\n\t fld_str1=\"\";\r\n\t if(document.form1.select1.options.length!=0)\r\n {\r\n \t for (i=0; i< document.form1.select1.options.length; i++)\r\n {\r\n options_value=document.form1.select1.options(i).value;\r\n options_text=document.form1.select1.options(i).text;\r\n fld_str+=options_value+\",\";\r\n fld_str1+=options_text+\",\";\r\n }\r\n }\r\n else\r\n \t {\r\n \t for (i=0; i< document.form1.select2.options.length; i++)\r\n {\r\n options_value=document.form1.select2.options(i).value;\r\n options_text=document.form1.select2.options(i).text;\r\n fld_str+=options_value+\",\";\r\n fld_str1+=options_text+\",\";\r\n }\r\n \t }\r\n document.form1.FIELDMSG.value=fld_str;\r\n document.form1.FIELDMSGNAME.value=fld_str1;\r\n document.form1.submit();\r\n}\r\n\r\nfunction chk(input,KC,KT,count)\r\n {\r\n var lstr=\"\";\r\n \t if(count==1)\r\n \t {\r\n \t \tif(document.all(KC).checked)\r\n \t \t{\r\n \t \t\tdocument.all(KT).value=document.all(KC).value;\r\n \t \t}\r\n \t else\r\n \t {\r\n \t \tdocument.all(KT).value=\"\";\r\n \t }\r\n\r\n \t }\r\n \telse\r\n \t{\r\n \t for(i=0;i<document.all(KC).length;i++)\r\n {\r\n el=document.all(KC).item(i);\r\n if(el.checked)\r\n {\r\n \t val=el.value;\r\n lstr+=val+\",\";\r\n\r\n }\r\n }\r\n\r\n \tdocument.all(KT).value=lstr;\r\n }\r\n }\r\nfunction func_up()\r\n{\r\n sel_count=0;\r\n for (i=document.form1.select1.options.length-1; i>=0; i--)\r\n {\r\n if(document.form1.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=document.form1.select1.selectedIndex;\r\n\r\n if(i!=0)\r\n {\r\n var my_option = document.createElement(\"OPTION\");\r\n my_option.text=document.form1.select1.options(i).text;\r\n my_option.value=document.form1.select1.options(i).value;\r\n\r\n document.form1.select1.add(my_option,i-1);\r\n document.form1.select1.remove(i+1);\r\n document.form1.select1.options(i-1).selected=true;\r\n }\r\n}\r\nfunction func_down()\r\n{\r\n sel_count=0;\r\n for (i=document.form1.select1.options.length-1; i>=0; i--)\r\n {\r\n if(document.form1.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=document.form1.select1.selectedIndex;\r\n\r\n if(i!=document.form1.select1.options.length-1)\r\n {\r\n var my_option = document.createElement(\"OPTION\");\r\n my_option.text=document.form1.select1.options(i).text;\r\n my_option.value=document.form1.select1.options(i).value;\r\n\r\n document.form1.select1.add(my_option,i+2);\r\n document.form1.select1.remove(i);\r\n document.form1.select1.options(i+1).selected=true;\r\n }\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\" onLoad=\"document.form1.NO.focus();\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/send.gif\" width=\"18\" HEIGHT=\"18\"><span class=\"big3\"> 导出EXCEL人员档案</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<form action=\"excel_report.php\" method=\"post\" name=\"form1\">\r\n <table align=\"center\" width=\"95%\" class=\"TableBlock\">\r\n <tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"4\">\r\n <img src=\"/images/green_arrow.gif\"> 导出范围\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 所属部门：</td>\r\n <td class=\"TableData\" colspan=\"3\">\r\n <input type=\"hidden\" name=\"TO_ID\">\r\n\t <textarea cols=35 name=TO_NAME rows=2 class=\"BigStatic\" wrap=\"yes\" readonly></textarea>\r\n <a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectDept('9')\">添加</a>\r\n <a href=\"javascript:;\" class=\"orgClear\" onClick=\"ClearUser()\">清空</a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 编号：</td>\r\n <td class=\"TableData\" width=\"280\" colspan=\"3\">\r\n <input type=\"text\" name=\"NO\" size=\"10\" maxlength=\"100\" class=\"BigInput\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 性别：</td>\r\n <td class=\"TableData\">\r\n <select name=\"SEX\" class=\"BigSelect\">\r\n <option value=\"\"></option>\r\n <option value=\"0\">男</option>\r\n <option value=\"1\">女</option>\r\n </select>\r\n </td>\r\n <td nowrap class=\"TableContent\"> 年龄：</td>\r\n <td class=\"TableData\" nowrap>\r\n <input type=\"text\" name=\"AGE_MIN\" size=\"5\" maxlength=\"10\" class=\"BigInput\" value=\"\">\r\n 至 <input type=\"text\" name=\"AGE_MAX\" size=\"5\" maxlength=\"10\" class=\"BigInput\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 出生日期：</td>\r\n <td class=\"TableData\" nowrap colspan=\"3\">\r\n <input type=\"text\" name=\"BIRTHDAY_MIN\" size=\"10\" maxlength=\"10\" class=\"BigStatic\" value=\"\" readonly>\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.BIRTHDAY_MIN');\">\r\n 至 <input type=\"text\" name=\"BIRTHDAY_MAX\" size=\"10\" maxlength=\"10\" class=\"BigStatic\" value=\"\" readonly>\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.BIRTHDAY_MAX');\">\r\n 日期格式形如 1999-1-2\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 身份证号码：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"CARD_NO\" size=\"15\" maxlength=\"25\" class=\"BigInput\" value=\"\">\r\n </td>\r\n <td nowrap class=\"TableContent\"> 民族：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"NATION\" size=\"8\" maxlength=\"100\" class=\"BigInput\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 籍贯：</td>\r\n <td class=\"TableData\">\r\n <select name=\"NATIVE_PLACE\" class=\"BigSelect\">\r\n";
getalldate( "AREA", $NATIVE_PLACE );
echo " </select>\r\n </td>\r\n <td nowrap class=\"TableContent\"> 户口所在地：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"HUKOU_PLACE\" size=\"15\" maxlength=\"100\" class=\"BigInput\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 婚姻状况：</td>\r\n <td class=\"TableData\" colspan=\"3\">\r\n <select name=\"MARRY\" class=\"BigSelect\">\r\n <option value=\"\"></option>\r\n <option value=\"0\">未婚</option>\r\n <option value=\"1\">已婚</option>\r\n <option value=\"2\">离异</option>\r\n\t\t <option value=\"3\">丧偶</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 学历：</td>\r\n <td class=\"TableData\">\r\n <select name=\"EDUCATION\" class=\"BigSelect\">\r\n";
getalldate( "EDUCATION", $EDUCATION );
echo " </select>\r\n </td>\r\n <td nowrap class=\"TableContent\"> 专业：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"SPECIALITY\" size=\"15\" maxlength=\"100\" class=\"BigInput\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 毕业院校：</td>\r\n <td class=\"TableData\" colspan=\"3\">\r\n <input type=\"text\" name=\"SCHOOL\" size=\"30\" maxlength=\"100\" class=\"BigInput\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 参加工作时间：</td>\r\n <td class=\"TableData\" nowrap colspan=\"3\">\r\n <input type=\"text\" name=\"WORK_DATE_MIN\" size=\"10\" maxlength=\"10\" class=\"BigStatic\" value=\"\" readonly>\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.WORK_DATE_MIN');\">\r\n 至 <input type=\"text\" name=\"WORK_DATE_MAX\" size=\"10\" maxlength=\"10\" class=\"BigStatic\" value=\"\" readonly>\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.WORK_DATE_MAX');\">\r\n 日期格式形如 1999-1-2\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 加入本单位时间：</td>\r\n <td class=\"TableData\" nowrap colspan=\"3\">\r\n <input type=\"text\" name=\"JOIN_DATE_MIN\" size=\"10\" maxlength=\"10\" class=\"BigStatic\" value=\"\" readonly>\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.JOIN_DATE_MIN');\">\r\n 至 <input type=\"text\" name=\"JOIN_DATE_MAX\" size=\"10\" maxlength=\"10\" class=\"BigStatic\" value=\"\" readonly>\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.JOIN_DATE_MAX');\">\r\n 日期格式形如 1999-1-2\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 员工类型：</td>\r\n <td class=\"TableData\">\r\n <select name=\"CONTRACTTYPE\" class=\"BigSelect\">\r\n";
getalldate( "CONTRACTTYPE", $CONTRACTTYPE );
echo " </select>\r\n </td>\r\n <td nowrap class=\"TableContent\"> 职务：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"POST\" size=\"15\" maxlength=\"100\" class=\"BigInput\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 职称：</td>\r\n <td class=\"TableData\">\r\n <select name=\"TECH_POST\" class=\"BigSelect\">\r\n";
getalldate( "TECH_POST", $TECH_POST );
echo " </select>\r\n </td>\r\n <td nowrap class=\"TableContent\"> 政治面貌：</td>\r\n <td class=\"TableData\">\r\n <select name=\"POLITICS\" class=\"BigSelect\">\r\n <option value=\"\"></option>\r\n <option value=\"1\">群众</option>\r\n <option value=\"2\">团员</option>\r\n <option value=\"4\">预备党员</option>\r\n <option value=\"3\">党员</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td class=\"TableData\" colspan=\"4\">\r\n ";
echo get_field_table( get_field_html( "HRMS", "", "1" ) );
echo " </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"4\">\r\n <img src=\"/images/green_arrow.gif\"> 导出内容\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" colspan=\"4\" align=\"center\"><br>\r\n \t<table width=\"150\" class=\"TableBlock\">\r\n <tr bgcolor=\"#CCCCCC\">\r\n <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 </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=\"move_option(select2,select1);\">\r\n <br><br>\r\n <input type=\"button\" class=\"SmallInput\" value=\" → \" onClick=\"move_option(select1,select2);\">\r\n </td>\r\n <td align=\"center\" valign=\"top\" bgcolor=\"#CCCCCC\">\r\n <select name=\"select2\" ondblclick=\"move_option(select2,select1);\" MULTIPLE style=\"width:200;height:280\">\r\n <option value=\"USER_NAME\">姓名</option>\r\n <option value=\"DEPT_NAME\">部门</option>\r\n <option value=\"SEX\">性别</option>\r\n <option value=\"NO\">编号</option>\r\n <option value=\"CARD_NO\">身份证号码</option>\r\n <option value=\"MARRY\">婚姻状况</option>\r\n <option value=\"NATION\">民族</option>\r\n <option value=\"NATIVE_PLACE\">籍贯</option>\r\n <option value=\"HR_BIRTHDAY\">出生日期</option>\r\n <option value=\"HUKOU_PLACE\">户口所在地</option>\r\n <option value=\"WORK_DATE\">参加工作时间</option>\r\n <option value=\"JOIN_DATE\">加入本单位时间</option>\r\n <option value=\"CONTRACT_DATE1\">合同开始日期</option>\r\n <option value=\"CONTRACT_DATE2\">合同结束日期</option> \r\n <option value=\"EDUCATION\">学历</option>\r\n <option value=\"SPECIALITY\">专业</option>\r\n <option value=\"SCHOOL\">毕业院校</option>\r\n <option value=\"POLITICS\">政治面貌</option>\r\n <option value=\"POST\">职务</option>\r\n <option value=\"TECH_POST\">职称</option>\r\n <option value=\"CONTRACTTYPE\">员工类型</option>\r\n <option value=\"HOME_ADDR\">家庭住址</option>\r\n <option value=\"HOME_TEL\">家庭电话</option>\r\n <option value=\"EMAIL\">电子邮件</option>\r\n <option value=\"CERTIFICATE\">职务情况</option>\r\n <option value=\"REWARD\">奖惩记录</option>\r\n <option value=\"TRAIN\">培训记录</option>\r\n <option value=\"EDU\">教育背景</option>\r\n <option value=\"WORK\">工作简历</option>\r\n <option value=\"SOCIATY\">社会关系</option>\r\n <option value=\"POST_CHANGE\">岗位变动情况</option>\r\n <option value=\"SURETY\">担保记录</option>\r\n <option value=\"CONTRACT\">劳动合同签订情况</option>\r\n <option value=\"INSURE\">社保缴纳情况</option>\r\n <option value=\"BODY_EXAMIM\">体检记录</option>\r\n <option value=\"RESUME\">备 注</option>\r\n";
$query = "select * from FIELDSETTING where TABLENAME='HRMS' ORDER BY ORDERNO ASC ";
$cursor1 = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
echo " <option value=\"";
echo $ROW['FIELDNO'];
echo "\">";
echo $ROW['FIELDNAME'];
echo "</option>\r\n";
}
echo " </select>\r\n <input type=\"button\" value=\" 全 选 \" onClick=\"func_select_all2();\" class=\"SmallInput\">\r\n </td>\r\n </tr>\r\n</table>\r\n</td>\r\n </tr>\r\n <tfoot align=\"center\" class=\"TableFooter\">\r\n <td nowrap colspan=\"4\" align=\"center\">\r\n <input type=\"button\" value=\"确定\" class=\"BigButton\" onClick=\"exreport()\"> \r\n <input type=\"reset\" value=\"清空\" class=\"BigButton\" onClick=\"location='query.php'\">\r\n <input type=\"hidden\" name=\"FIELDMSG\">\r\n <input type=\"hidden\" name=\"FIELDMSGNAME\">\r\n </td>\r\n </tfoot>\r\n </table>\r\n</form>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -