📄 query.php

📁 通达的部分源代码大家研究一下吧
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?
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 func_find(select_obj,option_text)
{
 pos=option_text.indexOf("] ")+1;
 option_text=option_text.substr(0,pos);

 for (j=0; j<select_obj.options.length; j++)
 {
   str=select_obj.options(j).text;
   if(str.indexOf(option_text)>=0)
      return j;
 }//for

 return j;
}


function func_insert()
{
 for (i=document.form1.select2.options.length-1; i>=0; i--)
 {
   if(document.form1.select2.options(i).selected)
   {
     option_text=document.form1.select2.options(i).text;
     option_value=document.form1.select2.options(i).value;
     option_style_color=document.form1.select2.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;

     //pos=func_find(select1,option_text);
     document.form1.select1.add(my_option);
     document.form1.select2.remove(i);
  }
 }//for


}

function func_delete()
{
 for (i=document.form1.select1.options.length-1; i>=0; i--)
 {
   if(document.form1.select1.options(i).selected)
   {
     option_text=document.form1.select1.options(i).text;
     option_value=document.form1.select1.options(i).value;

     var my_option = document.createElement("OPTION");
     my_option.text=option_text;
     my_option.value=option_value;

     //pos=func_find(select2,option_text);
     document.form1.select2.add(my_option);
     document.form1.select1.remove(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" border="0" width="95%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
     <tr>
      <td nowrap class="TableHeader" colspan="4">
         <img src="/images/green_arrow.gif"> &nbsp;导出范围
      </td>
    </tr>
    <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>
12 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -