query.php

来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 457 行 · 第 1/2 页

        <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 class="TableData" colspan="4">
         <?=get_field_table(get_field_html("HRMS","","1"))?>
      </td>
    </tr>
     <tr>
      <td nowrap class="TableHeader" colspan="4">
         <img src="/images/green_arrow.gif"> &nbsp;导出内容
      </td>
    </tr>
  <tr>
  <td nowrap class="TableData" colspan="4" align="center"><br>
  	<table width="150" class="TableBlock">
      <tr bgcolor="#CCCCCC">
     <td align="center">排序</td>
    <td align="center"><b>显示字段</b></td>
    <td align="center">&nbsp;</td>
    <td align="center" valign="top"><b>可选字段</b></td>
  </tr>
  <tr>
  	<td align="center" bgcolor="#999999">
      <input type="button" class="SmallInput" value=" ↑ " onClick="func_up();">
      <br><br>
      <input type="button" class="SmallInput" value=" ↓ " onClick="func_down();">
    </td>
    <td valign="top" align="center" bgcolor="#CCCCCC">
    <select  name="select1" ondblclick="func_delete();" MULTIPLE style="width:200;height:280">
    </select>
    <input type="button" value=" 全 选 " onClick="func_select_all1();" class="SmallInput">
    </td>
    <td align="center" bgcolor="#999999">
      <input type="button" class="SmallInput" value=" ← " onClick="move_option(select2,select1);">
      <br><br>
      <input type="button" class="SmallInput" value=" → " onClick="move_option(select1,select2);">
    </td>
    <td align="center" valign="top" bgcolor="#CCCCCC">
    <select  name="select2" ondblclick="move_option(select2,select1);" MULTIPLE style="width:200;height:280">
     <option value="USER_NAME">姓名</option>
     <option value="DEPT_NAME">部门</option>
     <option value="SEX">性别</option>
     <option value="NO">编号</option>
     <option value="CARD_NO">身份证号码</option>
     <option value="MARRY">婚姻状况</option>
     <option value="NATION">民族</option>
     <option value="NATIVE_PLACE">籍贯</option>
     <option value="HR_BIRTHDAY">出生日期</option>
     <option value="HUKOU_PLACE">户口所在地</option>
     <option value="WORK_DATE">参加工作时间</option>
     <option value="JOIN_DATE">加入本单位时间</option>
     <option value="CONTRACT_DATE1">合同开始日期</option>
     <option value="CONTRACT_DATE2">合同结束日期</option>    
     <option value="EDUCATION">学历</option>
     <option value="SPECIALITY">专业</option>
     <option value="SCHOOL">毕业院校</option>
     <option value="POLITICS">政治面貌</option>
     <option value="POST">职务</option>
     <option value="TECH_POST">职称</option>
     <option value="CONTRACTTYPE">员工类型</option>
     <option value="HOME_ADDR">家庭住址</option>
     <option value="HOME_TEL">家庭电话</option>
     <option value="EMAIL">电子邮件</option>
     <option value="CERTIFICATE">职务情况</option>
     <option value="REWARD">奖惩记录</option>
     <option value="TRAIN">培训记录</option>
     <option value="EDU">教育背景</option>
     <option value="WORK">工作简历</option>
     <option value="SOCIATY">社会关系</option>
     <option value="POST_CHANGE">岗位变动情况</option>
     <option value="SURETY">担保记录</option>
     <option value="CONTRACT">劳动合同签订情况</option>
     <option value="INSURE">社保缴纳情况</option>
     <option value="BODY_EXAMIM">体检记录</option>
     <option value="RESUME">备 注</option>
<?
     $query = "select * from FIELDSETTING where TABLENAME='HRMS' ORDER BY ORDERNO ASC ";
     $cursor1=exequery($connection,$query);
     while($ROW=mysql_fetch_array($cursor1))
     {
?>
      <option value="<?=$ROW["FIELDNO"]?>"><?=$ROW["FIELDNAME"]?></option>
<?
     }
?>
    </select>
    <input type="button" value=" 全 选 " onClick="func_select_all2();" class="SmallInput">
    </td>
  </tr>
</table>
</td>
  </tr>
    <tfoot align="center" class="TableFooter">
      <td nowrap colspan="4" align="center">
        <input type="button" value="确定" class="BigButton" onClick="exreport()">&nbsp;&nbsp;
        <input type="reset" value="清空" class="BigButton" onClick="location='query.php'">
        <input type="hidden" name="FIELDMSG">
        <input type="hidden" name="FIELDMSGNAME">
      </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>";}
  }

}
?>