📄 query.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>人员档案</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function td_calendar(fieldname)
{
myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
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();">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/infofind.gif" HEIGHT="20"><span class="big3"> 人员档案查询</span>
</td>
</tr>
</table>
<form action="search.php" method="post" name="form1">
<table align="center" border="0" width="95%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<tr>
<td nowrap class="TableContent" width="100"> 所属部门：</td>
<td class="TableData" colspan="3">
<select name="DEPT_ID" class="BigSelect">
<option value=""></option>
<?
echo my_dept_tree(0,$DEPT_ID,0);
?>
<option value="0">外部/离职人员</option>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80" > 编号：</td>
<td class="TableData" width="280" colspan="3">
<input type="text" name="NO" 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" 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" 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">
<input type="text" name="NATIVE_PLACE" size="15" maxlength="100" class="BigInput" value="">
</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>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 学历：</td>
<td class="TableData">
<select name="EDUCATION" class="BigSelect">
<option value=""></option>
<option value="1">小学</option>
<option value="2">初中</option>
<option value="3">高中</option>
<option value="4">中专</option>
<option value="5">大专</option>
<option value="6">大本</option>
<option value="7">硕士</option>
<option value="8">博士</option>
<option value="9">博士后</option>
</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" 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" 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" 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" 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">
<input type="text" name="DEPARTMENT" size="15" maxlength="100" class="BigInput" value="">
</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">
<input type="text" name="TECH_POST" size="15" maxlength="100" class="BigInput" value="">
</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">
<input type="text" name="HOME_ADDR" size="15" maxlength="100" class="BigInput" value="">
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 家庭电话：</td>
<td class="TableData">
<input type="text" name="HOME_TEL" size="15" maxlength="100" class="BigInput" value="">
</td>
<td nowrap class="TableContent"> 电子邮件：</td>
<td class="TableData">
<input type="text" name="EMAIL" size="15" maxlength="100" class="BigInput" value="">
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 岗位变动情况：</td>
<td class="TableData">
<textarea cols="18" name="POST_CHANGE" rows="2" class="BigInput" wrap="on"></textarea>
</td>
<td nowrap class="TableContent"> 教育背景：</td>
<td class="TableData">
<textarea cols="18" name="EDU" rows="2" class="BigInput" wrap="on"></textarea>
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 工作简历：</td>
<td class="TableData">
<textarea cols="18" name="WORK" rows="2" class="BigInput" wrap="on"></textarea>
</td>
<td nowrap class="TableContent"> 社会关系：</td>
<td class="TableData">
<textarea cols="18" name="SOCIATY" rows="2" class="BigInput" wrap="on"></textarea>
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 奖惩记录：</td>
<td class="TableData">
<textarea cols="18" name="REWARD" rows="2" class="BigInput" wrap="on"></textarea>
</td>
<td nowrap class="TableContent"> 职务情况：</td>
<td class="TableData">
<textarea cols="18" name="CERTIFICATE" rows="2" class="BigInput" wrap="on"></textarea>
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 培训记录：</td>
<td class="TableData">
<textarea cols="18" name="TRAIN" rows="2" class="BigInput" wrap="on"></textarea>
</td>
<td nowrap class="TableContent"> 担保记录：</td>
<td class="TableData">
<textarea cols="18" name="SURETY" rows="2" class="BigInput" wrap="on"></textarea>
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 劳动合同签订情况：</td>
<td class="TableData">
<textarea cols="18" name="CONTRACT" rows="2" class="BigInput" wrap="on"></textarea>
</td>
<td nowrap class="TableContent"> 社保缴纳情况：</td>
<td class="TableData">
<textarea cols="18" name="INSURE" rows="2" class="BigInput" wrap="on"></textarea>
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 体检记录：</td>
<td class="TableData">
<textarea cols="18" name="BODY_EXAMIM" rows="2" class="BigInput" wrap="on"></textarea>
</td>
<td nowrap class="TableContent"> 备 注：</td>
<td class="TableData">
<textarea cols="18" name="RESUME" rows="2" class="BigInput" wrap="on"></textarea>
</td>
</tr>
<?
$count=0;
$connection=OpenConnection();
$query = "select count(*) from FIELDSETTING where TABLENAME='HRMS' and ISQUERY='1'";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$count=$ROW[0];
}
if($count>0)
{
?>
<tr>
<td nowrap class="TableHeader" colspan="6" align="left">
用户自定义字段：
</td>
</tr>
<?
$query = "select * from FIELDSETTING where TABLENAME='HRMS' AND ISQUERY='1' ORDER BY ORDERNO ASC ";
$cursor=exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$FIELDNAME=$ROW["FIELDNAME"];
$ORDERNO=$ROW["ORDERNO"];
$STYPE=$ROW["STYPE"];
$TYPENAME=$ROW["TYPENAME"];
$TYPEVALUE=$ROW["TYPEVALUE"];
$TYPECODE=$ROW["TYPECODE"];
$ISQUERY=$ROW["ISQUERY"];
$ISGROUY=$ROW["ISGROUY"];
$FIELDNAME=$ROW["FIELDNAME"];
$FIELDNO=$ROW["FIELDNO"];
?>
<tr>
<td nowrap class="TableContent"><?=$FIELDNAME?>：</td>
<td nowrap class="TableData" colspan="5">
<?
if($STYPE=="T")
{
?>
<input type="text" name='CUSTOMER<?=$FIELDNO?>' class="SmallInput" size="33" maxlength="25" value="">
<?
}
if($STYPE=="MT")
{
?>
<textarea cols=37 rows=1 name='CUSTOMER<?=$FIELDNO?>' class="SmallInput" wrap="yes"></textarea>
<?
}
if($STYPE=="D")
{
$TYPEVALUE=str_replace("，",",",$TYPEVALUE);
$TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
$TYPENAME=str_replace("，",",",$TYPENAME);
$TYPENAME_ARRAY=explode(",",$TYPENAME);
$TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
?>
<select name='CUSTOMER<?=$FIELDNO?>' class="SmallSelect">
<option value=""></option>
<?
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
?>
<option value="<?=$TYPEVALUE_ARRAY[$I]?>"><?=$TYPENAME_ARRAY[$I]?></option>
<?
}
}
if($STYPE=="C")
{
$TYPEVALUE=str_replace("，",",",$TYPEVALUE);
$TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
$TYPENAME=str_replace("，",",",$TYPENAME);
$TYPENAME_ARRAY=explode(",",$TYPENAME);
$TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
?>
<input type="hidden" name='CUSTOMER<?=$FIELDNO?>'>
<?
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
?>
<input type="checkbox" name='CCUSTOMER<?=$FIELDNO?>' value="<?=$TYPEVALUE_ARRAY[$I]?>" onclick="return chk(this,'CCUSTOMER<?=$FIELDNO?>','CUSTOMER<?=$FIELDNO?>','<?=$TYPENAME_COUNT?>');"><?=$TYPENAME_ARRAY[$I]?>
<?
}
}
if($STYPE=="R")
{
$TYPEVALUE=str_replace("，",",",$TYPEVALUE);
$TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
$TYPENAME=str_replace("，",",",$TYPENAME);
$TYPENAME_ARRAY=explode(",",$TYPENAME);
$TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
?>
<input type="radio" name='CUSTOMER<?=$FIELDNO?>' value="<?=$TYPEVALUE_ARRAY[$I]?>"><?=$TYPENAME_ARRAY[$I]?>
<?
}
}
?>
</td>
</tr>
<?
}
}
?>
<tr class="TableControl">
<td nowrap colspan="4" align="center">
<input type="submit" value="查询" class="BigButton">
</td>
</tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -