search.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 820 行 · 第 1/2 页

PHP
820 行
字号
12
<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.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>
function hrms_detail(USER_ID)
{
 URL="print?USER_ID="+USER_ID;
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"read_notify","height=500,width=600,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  $CUR_DATE = date ('Y-m-d', time ());
  $query = '';
  if (($BIRTHDAY_MIN != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('BIRTHDAY_MIN='.$BIRTHDAY_MIN);
    }
    else
    {
      $urlstr = (($urlstr.'&BIRTHDAY_MIN=').$BIRTHDAY_MIN);
    }
    ($query .= (((''.' and HR_BIRTHDAY>=\'').$BIRTHDAY_MIN).'\''));
  }
  if (($BIRTHDAY_MAX != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('BIRTHDAY_MAX='.$BIRTHDAY_MAX);
    }
    else
    {
      $urlstr = (($urlstr.'&BIRTHDAY_MAX=').$BIRTHDAY_MAX);
    }
    ($query .= (((''.' and HR_BIRTHDAY<=\'').$BIRTHDAY_MAX).'\''));
  }
  if (($WORK_DATE_MIN != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('WORK_DATE_MIN='.$WORK_DATE_MIN);
    }
    else
    {
      $urlstr = (($urlstr.'&WORK_DATE_MIN=').$WORK_DATE_MIN);
    }
    ($query .= (((''.' and WORK_DATE>=\'').$WORK_DATE_MIN).'\''));
  }
  if (($WORK_DATE_MAX != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('WORK_DATE_MAX='.$WORK_DATE_MAX);
    }
    else
    {
      $urlstr = (($urlstr.'&WORK_DATE_MAX=').$WORK_DATE_MAX);
    }
    ($query .= (((''.' and WORK_DATE<=\'').$WORK_DATE_MAX).'\''));
  }
  if (($JOIN_DATE_MIN != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('JOIN_DATE_MIN='.$JOIN_DATE_MIN);
    }
    else
    {
      $urlstr = (($urlstr.'&JOIN_DATE_MIN=').$JOIN_DATE_MIN);
    }
    ($query .= (((''.' and JOIN_DATE>=\'').$JOIN_DATE_MIN).'\''));
  }
  if (($JOIN_DATE_MAX != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('JOIN_DATE_MAX='.$JOIN_DATE_MAX);
    }
    else
    {
      $urlstr = (($urlstr.'&JOIN_DATE_MAX=').$JOIN_DATE_MAX);
    }
    ($query .= (((''.' and JOIN_DATE<=\'').$JOIN_DATE_MAX).'\''));
  }
  if (($AGE_MIN != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('AGE_MIN='.$AGE_MIN);
    }
    else
    {
      $urlstr = (($urlstr.'&AGE_MIN=').$AGE_MIN);
    }
    $AGE = intval ($AGE_MIN);
    if ((!is_int ($AGE) OR ($AGE <= 0)))
    {
      message ('错误', '年龄应为正整数！');
      button_back ();
      exit ();
    }
    $YEAR_MIN = (date ('Y', time ()) - $AGE);
    ($YEAR_MIN .= date ('-m-d', time ()));
    ($query .= (((''.' and HR_BIRTHDAY<=\'').$YEAR_MIN).'\''));
  }
  if (($AGE_MAX != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('AGE_MAX='.$AGE_MAX);
    }
    else
    {
      $urlstr = (($urlstr.'&AGE_MAX=').$AGE_MAX);
    }
    $AGE = intval ($AGE_MAX);
    if ((!is_int ($AGE) OR ($AGE <= 0)))
    {
      message ('错误', '年龄应为正整数！');
      button_back ();
      exit ();
    }
    $YEAR_MAX = (date ('Y', time ()) - $AGE);
    ($YEAR_MAX .= date ('-m-d', time ()));
    ($query .= (((''.' and HR_BIRTHDAY>=\'').$YEAR_MAX).'\''));
  }
  if ((((($BIRTHDAY_MIN != '') OR ($BIRTHDAY_MAX != '')) OR ($AGE_MIN != '')) OR ($AGE_MAX != '')))
  {
    ($query .= ' and HR_BIRTHDAY!=\'0000-00-00\' and HR_BIRTHDAY!=\'1900-01-01\'');
  }
  if (($DEPT_ID != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('DEPT_ID='.$DEPT_ID);
    }
    else
    {
      $urlstr = (($urlstr.'&DEPT_ID=').$DEPT_ID);
    }
    ($query .= ((''.' and USER.DEPT_ID=').$DEPT_ID));
  }
  if (($SEX != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('SEX='.$SEX);
    }
    else
    {
      $urlstr = (($urlstr.'&SEX=').$SEX);
    }
    ($query .= (((''.' and SEX=\'').$SEX).'\''));
  }
  if (($MARRY != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('MARRY='.$MARRY);
    }
    else
    {
      $urlstr = (($urlstr.'&MARRY=').$MARRY);
    }
    ($query .= (((''.' and MARRY=\'').$MARRY).'\''));
  }
  if (($EDUCATION != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('EDUCATION='.$EDUCATION);
    }
    else
    {
      $urlstr = (($urlstr.'&EDUCATION=').$EDUCATION);
    }
    ($query .= (((''.' and EDUCATION=\'').$EDUCATION).'\''));
  }
  if (($POLITICS != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('POLITICS='.$POLITICS);
    }
    else
    {
      $urlstr = (($urlstr.'&POLITICS=').$POLITICS);
    }
    ($query .= (((''.' and POLITICS=\'').$POLITICS).'\''));
  }
  if (($NO != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('NO='.$NO);
    }
    else
    {
      $urlstr = (($urlstr.'&NO=').$NO);
    }
    ($query .= ((' and NO like \'%'.$NO).'%\''));
  }
  if (($USERNAME != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('USERNAME='.$USERNAME);
    }
    else
    {
      $urlstr = (($urlstr.'&USERNAME=').$USERNAME);
    }
    ($query .= ((' and USER.USER_NAME  like \'%'.$USERNAME).'%\''));
  }
  if (($NATION != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('NATION='.$NATION);
    }
    else
    {
      $urlstr = (($urlstr.'&NATION=').$NATION);
    }
    ($query .= ((' and NATION like \'%'.$NATION).'%\''));
  }
  if (($CARD_NO != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CARD_NO='.$CARD_NO);
    }
    else
    {
      $urlstr = (($urlstr.'&CARD_NO=').$CARD_NO);
    }
    ($query .= ((' and CARD_NO like \'%'.$CARD_NO).'%\''));
  }
  if (($NATIVE_PLACE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('NATIVE_PLACE='.$NATIVE_PLACE);
    }
    else
    {
      $urlstr = (($urlstr.'&NATIVE_PLACE=').$NATIVE_PLACE);
    }
    ($query .= (((''.' and NATIVE_PLACE=\'').$NATIVE_PLACE).'\''));
  }
  if (($HUKOU_PLACE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('HUKOU_PLACE='.$HUKOU_PLACE);
    }
    else
    {
      $urlstr = (($urlstr.'&HUKOU_PLACE=').$HUKOU_PLACE);
    }
    ($query .= ((' and HUKOU_PLACE like \'%'.$HUKOU_PLACE).'%\''));
  }
  if (($SPECIALITY != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('SPECIALITY='.$SPECIALITY);
    }
    else
    {
      $urlstr = (($urlstr.'&SPECIALITY=').$SPECIALITY);
    }
    ($query .= ((' and SPECIALITY like \'%'.$SPECIALITY).'%\''));
  }
  if (($SCHOOL != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('SCHOOL='.$SCHOOL);
    }
    else
    {
      $urlstr = (($urlstr.'&SCHOOL=').$SCHOOL);
    }
    ($query .= ((' and SCHOOL like \'%'.$SCHOOL).'%\''));
  }
  if (($CONTRACTTYPE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CONTRACTTYPE='.$CONTRACTTYPE);
    }
    else
    {
      $urlstr = (($urlstr.'&CONTRACTTYPE=').$CONTRACTTYPE);
    }
    ($query .= (((''.' and CONTRACTTYPE=\'').$CONTRACTTYPE).'\''));
  }
  if (($POST != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('POST='.$POST);
    }
    else
    {
      $urlstr = (($urlstr.'&POST=').$POST);
    }
    ($query .= ((' and POST like \'%'.$POST).'%\''));
  }
  if (($TECH_POST != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('TECH_POST='.$TECH_POST);
    }
    else
    {
      $urlstr = (($urlstr.'&TECH_POST=').$TECH_POST);
    }
    ($query .= (((''.' and TECH_POST=\'').$TECH_POST).'\''));
  }
  if (($ORDERFIELD != ''))
  {
    if (($ORDERSIGN == 'DOWN'))
    {
      $ORDERTYPE = 'ASC';
    }
    if (($ORDERSIGN == 'UP'))
    {
      $ORDERTYPE = 'DESC';
    }
    $OREDERBY = (((' ORDER BY '.$ORDERFIELD).' ').$ORDERTYPE);
  }
  $query1 = 'select * from HRMS,USER,USER_PRIV';
  if (($DEPT_ID != '0'))
  {
    ($query1 .= ',DEPARTMENT');
  }
  ($query1 .= ' where HRMS.USER_ID=USER.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV');
  if (($DEPT_ID != '0'))
  {
    ($query1 .= ' and USER.DEPT_ID=DEPARTMENT.DEPT_ID');
  }
  ($query1 .= $query);
  ($query1 .= field_where_str ('HRMS', $_POST, 'HRMS.USER_ID'));
  $cursor = exequery ($connection, $query1);
  $HRMS_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $DEPT_ID = $ROW['DEPT_ID'];
    $USER_ID = $ROW['USER_ID'];
    if ((is_dept_priv ($DEPT_ID) == 0))
    {
      continue;
    }
    else
    {
      ++$HRMS_COUNT;
      continue;
    }
  }
  echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/infofind.gif" width="24" height="24">';
  echo '<s';
  echo 'pan class="big3"> 人事档案查询结果</span><br>
    </td>
    <td valign="bottom">';
  echo '<s';
  echo 'pan class="small1">共&nbsp;';
  echo '<s';
  echo 'pan class="big4">';
  echo $HRMS_COUNT;
  echo '</span>&nbsp;条信息</span>
    </td>
  </tr>
</table>
';
  $HRMS_COUNT = 0;
  $query1 = 'select * from HRMS,USER,USER_PRIV';
  if (($DEPT_ID != '0'))
  {
    ($query1 .= ',DEPARTMENT');
  }
  ($query1 .= ' where HRMS.USER_ID=USER.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV');
  if (($DEPT_ID != '0'))
  {
    ($query1 .= ' and USER.DEPT_ID=DEPARTMENT.DEPT_ID');
  }
  ($query1 .= (($query.field_where_str ('HRMS', $_POST, 'HRMS.USER_ID')).$OREDERBY));
  $cursor = exequery ($connection, $query1);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $NATIVE_PLACENAME = '';
    $USER_ID = $ROW['USER_ID'];
    $USER_NAME = $ROW['USER_NAME'];
    $DEPT_NAME = $ROW['DEPT_NAME'];
    $DEPT_ID = $ROW['DEPT_ID'];
12

search.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 search.php 源码文件，采用 PHP 编程语言编写，共 820 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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