📄 query.php
字号:
<?php
function GETALLDATE( $CODE, $GETVALUE )
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='".$CODE."' order by CODE_ORDER";
$cursor = exequery( $connection, $query );
echo "<option value=\"\"></option>";
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$CODE_NO = $ROW['CODE_NO'];
$CODE_NAME = $ROW['CODE_NAME'];
if ( $CODE_NO == $GETVALUE )
{
echo "<option value=\"".$CODE_NO."\" selected>".$CODE_NAME."</option>";
}
else
{
echo "<option value=\"".$CODE_NO."\">".$CODE_NAME."</option>";
}
}
}
include_once( "inc/auth.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 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\n\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\" onLoad=\"document.form1.NO.focus();\">\r\n<form action=\"search.php\" method=\"post\" name=\"form1\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/infofind.gif\"><span class=\"big3\"> 人员档案查询</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<table align=\"center\" width=\"95%\" class=\"TableBlock\">\r\n \r\n <tr>\r\n <td nowrap class=\"TableContent\" width=\"100\"> 所属部门：</td>\r\n <td class=\"TableData\" colspan=\"3\">\r\n <input type=\"hidden\" name=\"TO_ID\">\r\n\t\t<textarea cols=35 name=TO_NAME rows=2 class=\"BigStatic\" wrap=\"yes\" readonly></textarea>\r\n <a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectDept('10')\">添加</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\">\r\n <input type=\"text\" name=\"NO\" size=\"10\" maxlength=\"100\" class=\"BigInput\" value=\"\">\r\n </td>\r\n <td nowrap class=\"TableContent\" width=\"80\"> 姓名：</td>\r\n <td class=\"TableData\" width=\"280\">\r\n <input type=\"text\" name=\"USERNAME\" 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 \t<td nowrap class=\"TableContent\"> 其他：</td>\r\n\t<td class=\"TableData\" colspan=\"3\">\r\n\t\t\t<select name=\"SELECTITEM\" class=\"BigSelect\">\r\n \t\t<option value=\"-1\"></option>\r\n \t\t<option value=\"POST_CHANGE\">岗位变动情况</option>\r\n \t\t<option value=\"EDU\">教育背景</option>\r\n \t\t<option value=\"WORK\">工作简历</option>\r\n \t\t<option value=\"SOCIATY\">社会关系</option>\r\n\t\t\t\t<option value=\"REWARD\">奖惩记录</option>\r\n \t\t<option value=\"CERTIFICATE\">职务情况</option>\r\n \t\t<option value=\"TRAIN\">培训记录</option>\r\n \t\t<option value=\"SURETY\">担保记录</option>\r\n\t\t\t\t<option value=\"CONTRACT\">劳动合同签订情况</option>\r\n \t\t<option value=\"INSURE\">社保缴纳情况</option>\r\n \t\t<option value=\"BODY_EXAMIM\">体检记录</option>\r\n \t\t<option value=\"RESUME\">备 注</option>\r\n </select><textarea cols=\"35\" name=\"TContext\" rows=\"2\" class=\"BigInput\" wrap=\"on\"></textarea>\r\n\t\t</td>\t\t\r\n </tr>\t\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 <tfoot align=\"center\" class=\"TableFooter\">\r\n <td nowrap colspan=\"4\" align=\"center\">\r\n <input type=\"submit\" value=\"查询\" class=\"BigButton\">\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 + -