search.php

来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 368 行

PHP
368 行
字号 
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_org.php");
include_once("inc/utility_field.php");
include_once("check_priv.php");
?>
<html>
<head>
<title>人事档案查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
function hrms_detail(USER_ID)
{
 URL="print?USER_ID="+USER_ID;
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"read_notify","height=500,width=690,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}

 function delete_all(condition_query)
{
 msg='确认删除以上信息吗？';
 if(window.confirm(msg))
 {
   URL="delete_hrms.php?condition_query="+condition_query;
   window.location=URL;
 }
}
</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)||$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)||$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!="" || $BIRTHDAY_MAX!="" || $AGE_MIN!="" || $AGE_MAX!="")
    $query.=" and HR_BIRTHDAY!='0000-00-00' and HR_BIRTHDAY!='1900-01-01'";
 //------------------------ 生成条件字符串 ------------------
   
  if ($TO_ID!="")
 {
   if ($TO_ID!="ALL_DEPT")
   {
	   $DEPT_ID=$TO_ID;
     if (substr($DEPT_ID,-1)==",")
 	   $DEPT_ID=substr($DEPT_ID,0,-1);
 	   $DEPT_ID="(".$DEPT_ID.")";
     $query.=" and b.DEPT_ID in $DEPT_ID";
   }
 }
  
 if($SEX!="")
  {
 	  if($urlstr=="")$urlstr="SEX=".$SEX;
    else $urlstr=$urlstr."&SEX=".$SEX;
    $query.=" and a.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 b.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(($SELECTITEM!="-1")&&($TContext!=""))  //其他   like '%".$NO."%'";
 {  
	if($urlstr=="")
	  	$urlstr="$SELECTITEM like '%".$TContext."%'";
    else 
		$urlstr=$urlstr."&$SELECTITEM like '%".$TContext."%'";
    $query.=" and $SELECTITEM like '%".$TContext."%'";
 }
  
 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 a 
         LEFT OUTER JOIN USER b ON a.USER_ID = b.USER_ID
         LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID
         LEFT OUTER JOIN USER_PRIV  g ON b.USER_PRIV=g.USER_PRIV";
 $query1.=" where 1=1";
 $query1.=$query;
 $query1.=field_where_str("HRMS",$_POST,"a.USER_ID");
 $query1.=$WHERE_STR;
 $cursor= exequery($connection,$query1);//echo $query1;
 $HRMS_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
   {
   	$DEPT_ID=$ROW["DEPT_ID"];
    $USER_ID=$ROW["USER_ID"];

    $HRMS_COUNT++;
   }
  $condition_query=$query1;
  //echo $condition_query;
  //break;
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/infofind.gif"><span class="big3"> 人事档案查询结果</span><br>
    </td>
    <td valign="bottom"><span class="small1">共&nbsp;<span class="big4"><?=$HRMS_COUNT?></span>&nbsp;条信息</span>
    </td>
  </tr>
</table>
<?
 $HRMS_COUNT=0;
 $query1="select b.USER_ID,b.USER_NAME,DEPT_NAME,b.DEPT_ID,a.SEX,HR_BIRTHDAY,CARD_NO,NO,NATION,NATIVE_PLACE,TECH_POST,HUKOU_PLACE,POLITICS from HRMS a 
          LEFT OUTER JOIN USER b ON a.USER_ID = b.USER_ID
          LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID
          LEFT OUTER JOIN USER_PRIV  g ON b.USER_PRIV=g.USER_PRIV";
 $query1.=" where 1=1";
 $query1.=$query.field_where_str("HRMS",$_POST,"a.USER_ID").$WHERE_STR.$OREDERBY;

 $cursor= exequery($connection,$query1);//echo $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"];
   $SEX=$ROW["SEX"];
   $HR_BIRTHDAY=$ROW["HR_BIRTHDAY"];
   $CARD_NO=$ROW["CARD_NO"];
   $NO=$ROW["NO"];
   $NATION=$ROW["NATION"];
   $NATIVE_PLACE=$ROW["NATIVE_PLACE"];
   $TECH_POST=$ROW["TECH_POST"];
   $HUKOU_PLACE=$ROW["HUKOU_PLACE"];
   $POLITICS=$ROW["POLITICS"];
   $query1 = "SELECT CODE_NAME from SYS_CODE where PARENT_NO='AREA' and CODE_NO='$NATIVE_PLACE'";
   $cursor1= exequery($connection,$query1);
   if($ROW=mysql_fetch_array($cursor1))$NATIVE_PLACENAME=$ROW["CODE_NAME"];

  
   
   $HRMS_COUNT++;
   if($SEX=="0")
      $SEX_DESC="男";
   else if($SEX=="1")
      $SEX_DESC="女";
   else
      $SEX_DESC="";

   if($POLITICS==1) $POLITICS= "群众";
   elseif($POLITICS==2) $POLITICS= "团员";
   elseif($POLITICS==3) $POLITICS= "党员";
   elseif($POLITICS==4) $POLITICS= "预备党员";

   if($HR_BIRTHDAY=="0000-00-00"||$HR_BIRTHDAY=="1900-01-01")
      $HR_BIRTHDAY="";

   if($HRMS_COUNT==1)
   {
?>
<table width="100%" class="TableList">
  <tr class="TableHeader">
  	  <td nowrap align="center"><a href="search.php?<?=$urlstr?>&ORDERFIELD=DEPT_NAME&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">部门&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="DEPT_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="DEPT_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="search.php?<?=$urlstr?>&ORDERFIELD=USER_NAME&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">姓名&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="USER_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="USER_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="search.php?<?=$urlstr?>&ORDERFIELD=HRMS.SEX&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">性别&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="HRMS.SEX"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="HRMS.SEX"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="search.php?<?=$urlstr?>&ORDERFIELD=HR_BIRTHDAY&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">出生年月&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="HR_BIRTHDAY"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="HR_BIRTHDAY"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="search.php?<?=$urlstr?>&ORDERFIELD=NATION&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">民族&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="NATION"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="NATION"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="search.php?<?=$urlstr?>&ORDERFIELD=NATIVE_PLACE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">籍贯&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="NATIVE_PLACE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="NATIVE_PLACE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="search.php?<?=$urlstr?>&ORDERFIELD=POLITICS&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">政治面貌&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="POLITICS"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="POLITICS"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="search.php?<?=$urlstr?>&ORDERFIELD=CARD_NO&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">身份证号码&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="CARD_NO"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CARD_NO"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center">操作</td>
    </tr>
<?
   }
?>
 <tr class="TableData">
      <td nowrap align="center"><?=$DEPT_NAME?></td>
      <td nowrap align="center"><?=$USER_NAME?></td>
      <td nowrap align="center"><?=$SEX_DESC?></td>
      <td nowrap align="center"><?=$HR_BIRTHDAY?></td>
      <td nowrap align="center"><?=$NATION?></a></td>
      <td nowrap align="left"><?=$NATIVE_PLACENAME?></td>
      <td nowrap align="center"><?=$POLITICS?></td>
      <td nowrap align="center"><?=$CARD_NO?></td>
      <td nowrap align="center">
      <a href="javascript:hrms_detail('<?=$USER_ID?>');"> 详情</a>
      </td>
    </tr>
<?
}

if($HRMS_COUNT==0)
{
   Message("","无符合条件的人事档案信息");
   Button_Back();
   exit;
}
?>
</table>
<br><center>
<? if (($HRMS_COUNT!="")&&($HRMS_COUNT!=0))
	{
?>	
	<input type="button" class="BigButton" value="全部删除" onClick="delete_all('<?=urlencode($condition_query)?>')">&nbsp;&nbsp;
<?
    }
?>	
<input type="button" class="BigButton" value="返回" onClick="location='query.php'"></center>
</body>
</html>

search.php - 源码说明

本页面展示了「通达OA官方提供的30源代码,感觉很实在」中的 search.php 源码文件，采用 PHP 编程语言编写，共 368 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

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

⌨️ 快捷键说明

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