query.php

通达的部分源代码大家研究一下吧

    </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">
      <img src="/images/green_arrow.gif"> &nbsp;用户自定义字段：
    </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>
      <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" border="1" cellspacing="0" cellpadding="3"  bordercolorlight="#000000" bordercolordark="#FFFFFF" class="small">
      <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="func_insert();">
      <br><br>
      <input type="button" class="SmallInput" value=" → " onclick="func_delete();">
    </td>

    <td align="center" valign="top" bgcolor="#CCCCCC">
    <select  name="select2" ondblclick="func_insert();" MULTIPLE style="width:200;height:280">
     <option value="USER_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="HUKOU_PLACE">户口所在地</option>
     <option value="WORK_DATE">参加工作时间</option>
     <option value="JOIN_DATE">加入本单位时间</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="DEPARTMENT">部门</option>
     <option value="HOME_ADDR">家庭住址</option>
     <option value="HOME_TEL">家庭电话</option>
     <option value="a.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>
    <tr class="TableControl">
      <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>
    </tr>
    </table>
</form>    
</body>
</html>