query.php
来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 262 行
PHP
262 行
<?
include_once("inc/auth.php");
include_once("inc/utility_field.php");
?>
<html>
<head>
<title>人员档案查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><script src="/inc/js/module.js"></script>
<script Language="JavaScript">
function chk(input,KC,KT,count)
{
var lstr="";
if(count==1)
{
if(document.all(KC).checked)
{
document.all(KT).value=document.all(KC).value;
}
else
{
document.all(KT).value="";
}
}
else
{
for(i=0;i<document.all(KC).length;i++)
{
el=document.all(KC).item(i);
if(el.checked)
{
val=el.value;
lstr+=val+",";
}
}
document.all(KT).value=lstr;
}
}
</script>
</head>
<body class="bodycolor" topmargin="5" onLoad="document.form1.NO.focus();">
<form action="search.php" method="post" name="form1">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/infofind.gif"><span class="big3"> 人员档案查询</span>
</td>
</tr>
</table>
<table align="center" width="95%" class="TableBlock">
<tr>
<td nowrap class="TableContent" width="100"> 所属部门：</td>
<td class="TableData" colspan="3">
<input type="hidden" name="TO_ID">
<textarea cols=35 name=TO_NAME rows=2 class="BigStatic" wrap="yes" readonly></textarea>
<a href="javascript:;" class="orgAdd" onClick="SelectDept('10')">添加</a>
<a href="javascript:;" class="orgClear" onClick="ClearUser()">清空</a>
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 编号：</td>
<td class="TableData" width="280">
<input type="text" name="NO" size="10" maxlength="100" class="BigInput" value="">
</td>
<td nowrap class="TableContent" width="80"> 姓名：</td>
<td class="TableData" width="280">
<input type="text" name="USERNAME" size="10" maxlength="100" class="BigInput" value="">
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 性别：</td>
<td class="TableData">
<select name="SEX" class="BigSelect">
<option value=""></option>
<option value="0">男</option>
<option value="1">女</option>
</select>
</td>
<td nowrap class="TableContent"> 年龄：</td>
<td class="TableData" nowrap>
<input type="text" name="AGE_MIN" size="5" maxlength="10" class="BigInput" value="">
至 <input type="text" name="AGE_MAX" size="5" maxlength="10" class="BigInput" value="">
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 出生日期：</td>
<td class="TableData" nowrap colspan="3">
<input type="text" name="BIRTHDAY_MIN" size="10" maxlength="10" class="BigStatic" value="" readonly>
<img src="/images/menu/calendar.gif" align="absMiddle" align="absMiddle" border="0" style="cursor:hand" onClick="td_calendar('form1.BIRTHDAY_MIN');">
至 <input type="text" name="BIRTHDAY_MAX" size="10" maxlength="10" class="BigStatic" value="" readonly>
<img src="/images/menu/calendar.gif" align="absMiddle" align="absMiddle" border="0" style="cursor:hand" onClick="td_calendar('form1.BIRTHDAY_MAX');">
日期格式形如 1999-1-2
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 身份证号码：</td>
<td class="TableData">
<input type="text" name="CARD_NO" size="15" maxlength="25" class="BigInput" value="">
</td>
<td nowrap class="TableContent"> 民族：</td>
<td class="TableData">
<input type="text" name="NATION" size="8" maxlength="100" class="BigInput" value="">
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 籍贯：</td>
<td class="TableData">
<select name="NATIVE_PLACE" class="BigSelect">
<?
GETALLDATE("AREA",$NATIVE_PLACE);
?>
</select>
</td>
<td nowrap class="TableContent"> 户口所在地：</td>
<td class="TableData">
<input type="text" name="HUKOU_PLACE" size="15" maxlength="100" class="BigInput" value="">
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 婚姻状况：</td>
<td class="TableData" colspan="3">
<select name="MARRY" class="BigSelect">
<option value=""></option>
<option value="0">未婚</option>
<option value="1">已婚</option>
<option value="2">离异</option>
<option value="3">丧偶</option>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 学历：</td>
<td class="TableData">
<select name="EDUCATION" class="BigSelect">
<?
GETALLDATE("EDUCATION",$EDUCATION);
?>
</select>
</td>
<td nowrap class="TableContent"> 专业：</td>
<td class="TableData">
<input type="text" name="SPECIALITY" size="15" maxlength="100" class="BigInput" value="">
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 毕业院校：</td>
<td class="TableData" colspan="3">
<input type="text" name="SCHOOL" size="30" maxlength="100" class="BigInput" value="">
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 参加工作时间：</td>
<td class="TableData" nowrap colspan="3">
<input type="text" name="WORK_DATE_MIN" size="10" maxlength="10" class="BigStatic" value="" readonly>
<img src="/images/menu/calendar.gif" align="absMiddle" align="absMiddle" border="0" style="cursor:hand" onClick="td_calendar('form1.WORK_DATE_MIN');">
至 <input type="text" name="WORK_DATE_MAX" size="10" maxlength="10" class="BigStatic" value="" readonly>
<img src="/images/menu/calendar.gif" align="absMiddle" align="absMiddle" border="0" style="cursor:hand" onClick="td_calendar('form1.WORK_DATE_MAX');">
日期格式形如 1999-1-2
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 加入本单位时间：</td>
<td class="TableData" nowrap colspan="3">
<input type="text" name="JOIN_DATE_MIN" size="10" maxlength="10" class="BigStatic" value="" readonly>
<img src="/images/menu/calendar.gif" align="absMiddle" align="absMiddle" border="0" style="cursor:hand" onClick="td_calendar('form1.JOIN_DATE_MIN');">
至 <input type="text" name="JOIN_DATE_MAX" size="10" maxlength="10" class="BigStatic" value="" readonly>
<img src="/images/menu/calendar.gif" align="absMiddle" align="absMiddle" border="0" style="cursor:hand" onClick="td_calendar('form1.JOIN_DATE_MAX');">
日期格式形如 1999-1-2
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 员工类型：</td>
<td class="TableData">
<select name="CONTRACTTYPE" class="BigSelect">
<?
GETALLDATE("CONTRACTTYPE",$CONTRACTTYPE);
?>
</select>
</td>
<td nowrap class="TableContent"> 职务：</td>
<td class="TableData">
<input type="text" name="POST" size="15" maxlength="100" class="BigInput" value="">
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 职称：</td>
<td class="TableData">
<select name="TECH_POST" class="BigSelect">
<?
GETALLDATE("TECH_POST",$TECH_POST);
?>
</select>
</td>
<td nowrap class="TableContent"> 政治面貌：</td>
<td class="TableData">
<select name="POLITICS" class="BigSelect">
<option value=""></option>
<option value="1">群众</option>
<option value="2">团员</option>
<option value="4">预备党员</option>
<option value="3">党员</option>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 其他：</td>
<td class="TableData" colspan="3">
<select name="SELECTITEM" class="BigSelect">
<option value="-1"></option>
<option value="POST_CHANGE">岗位变动情况</option>
<option value="EDU">教育背景</option>
<option value="WORK">工作简历</option>
<option value="SOCIATY">社会关系</option>
<option value="REWARD">奖惩记录</option>
<option value="CERTIFICATE">职务情况</option>
<option value="TRAIN">培训记录</option>
<option value="SURETY">担保记录</option>
<option value="CONTRACT">劳动合同签订情况</option>
<option value="INSURE">社保缴纳情况</option>
<option value="BODY_EXAMIM">体检记录</option>
<option value="RESUME">备 注</option>
</select><textarea cols="35" name="TContext" rows="2" class="BigInput" wrap="on"></textarea>
</td>
</tr>
<tr>
<td class="TableData" colspan="4">
<?=get_field_table(get_field_html("HRMS","","1"))?>
</td>
</tr>
<tfoot align="center" class="TableFooter">
<td nowrap colspan="4" align="center">
<input type="submit" value="查询" class="BigButton">
</td>
</tfoot>
</table>
</form>
</body>
</html>
<?
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>";}
}
}
?>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?