📄 query.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/utility_org.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 move_option(e1,e2)
{
for (var i=0;i<e1.options.length; i++)
{
if(e1.options(i).selected)
{
option_text=e1.options(i).text;
option_value=e1.options(i).value;
option_style_color=e1.options(i).style.color;
var my_option = document.createElement("OPTION");
my_option.text=option_text;
my_option.value=option_value;
my_option.style.color=option_style_color;
e2.add(my_option);
e1.remove(i);
i--;
}
}//for
}
function func_select_all1()
{
for (i=document.form1.select1.options.length-1; i>=0; i--)
document.form1.select1.options(i).selected=true;
}
function func_select_all2()
{
for (i=document.form1.select2.options.length-1; i>=0; i--)
document.form1.select2.options(i).selected=true;
}
function exreport()
{
fld_str="";
fld_str1="";
if(document.form1.select1.options.length!=0)
{
for (i=0; i< document.form1.select1.options.length; i++)
{
options_value=document.form1.select1.options(i).value;
options_text=document.form1.select1.options(i).text;
fld_str+=options_value+",";
fld_str1+=options_text+",";
}
}
else
{
for (i=0; i< document.form1.select2.options.length; i++)
{
options_value=document.form1.select2.options(i).value;
options_text=document.form1.select2.options(i).text;
fld_str+=options_value+",";
fld_str1+=options_text+",";
}
}
document.form1.FIELDMSG.value=fld_str;
document.form1.FIELDMSGNAME.value=fld_str1;
document.form1.submit();
}
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;
}
}
function func_up()
{
sel_count=0;
for (i=document.form1.select1.options.length-1; i>=0; i--)
{
if(document.form1.select1.options(i).selected)
sel_count++;
}
if(sel_count==0)
{
alert("调整顺序时，请选择其中一项！");
return;
}
else if(sel_count>1)
{
alert("调整顺序时，只能选择其中一项！");
return;
}
i=document.form1.select1.selectedIndex;
if(i!=0)
{
var my_option = document.createElement("OPTION");
my_option.text=document.form1.select1.options(i).text;
my_option.value=document.form1.select1.options(i).value;
document.form1.select1.add(my_option,i-1);
document.form1.select1.remove(i+1);
document.form1.select1.options(i-1).selected=true;
}
}
function func_down()
{
sel_count=0;
for (i=document.form1.select1.options.length-1; i>=0; i--)
{
if(document.form1.select1.options(i).selected)
sel_count++;
}
if(sel_count==0)
{
alert("调整顺序时，请选择其中一项！");
return;
}
else if(sel_count>1)
{
alert("调整顺序时，只能选择其中一项！");
return;
}
i=document.form1.select1.selectedIndex;
if(i!=document.form1.select1.options.length-1)
{
var my_option = document.createElement("OPTION");
my_option.text=document.form1.select1.options(i).text;
my_option.value=document.form1.select1.options(i).value;
document.form1.select1.add(my_option,i+2);
document.form1.select1.remove(i);
document.form1.select1.options(i+1).selected=true;
}
}
</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/send.gif" width="18" HEIGHT="18"><span class="big3"> 导出EXCEL人员档案</span>
</td>
</tr>
</table>
<form action="excel_report.php" method="post" name="form1">
<table align="center" width="95%" class="TableBlock">
<tr>
<td nowrap class="TableHeader" colspan="4">
<img src="/images/green_arrow.gif"> 导出范围
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 所属部门：</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('9')">添加</a>
<a href="javascript:;" class="orgClear" onClick="ClearUser()">清空</a>
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 编号：</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" 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">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -