query.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 284 行
PHP
284 行
<?
function getalldate ($CODE, $GETVALUE)
{
global $connection;
$query = (((''.'SELECT * from SYS_CODE where PARENT_NO=\'').$CODE).'\'');
$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>');
continue;
}
else
{
echo (((('<option value='.$CODE_NO).' >').$CODE_NAME).'</option>');
continue;
}
}
}
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '<html>
<head>
<title>人员档案</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript 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+"';
echo '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;
l';
echo 'str+=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">';
echo '<s';
echo 'pan class="big3"> 人员档案查询</span>
</td>
</tr>
</table>
<table align="center" border="0" width="95%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<form action="search.php" method="post" name="form1">
<tr>
<td nowrap class="TableContent" width="100"> 所属部门：</td>
<td class="TableData" colspan="3">
';
echo '<s';
echo 'elect name="DEPT_ID" class="BigSelect">
<option value=""></option>
';
echo my_dept_tree (0, $DEPT_ID, 1);
echo ' <option value="0">外部/离职人员</option>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80" > 编号：</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">';
echo '
<input type="text" name="USERNAME" size="10" maxlength="100" class="BigInput" value="">
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 性别：</td>
<td class="TableData">
';
echo '<s';
echo 'elect 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_M';
echo 'AX" 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="';
echo '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"> 身份证号码';
echo '：</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>
';
echo ' <td class="TableData">
';
echo '<s';
echo 'elect name="NATIVE_PLACE" class="BigSelect">
';
getalldate ('AREA', $NATIVE_PLACE);
echo ' </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">
';
echo '<s';
echo 'elect 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">
';
echo '<s';
echo 'elect 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">博士</op';
echo 'tion>
<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 typ';
echo 'e="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" sty';
echo 'le="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 cla';
echo 'ss="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" ';
echo '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">
';
echo '<s';
echo 'elect name="CONTRACTTYPE" class="BigSelect">
';
getalldate ('CONTRACTTYPE', $CONTRACTTYPE);
echo ' </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">
';
echo '<s';
echo 'elect name="TECH_POST" class="BigSelect">
';
getalldate ('TECH_POST', $TECH_POST);
echo ' </select>
</td>
<td nowrap class="TableContent"> 政治面貌：</td>
<td class="TableData">
';
echo '<s';
echo 'elect 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 class="TableData" colspan="4">
';
echo get_field_table (get_field_html ('HRMS', '', '1'));
echo ' </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 + =
减小字号Ctrl + -
显示快捷键?