📄 search.php
字号:
}
if($WORK!="")
{
if($urlstr=="")$urlstr="WORK=".$WORK;
else $urlstr=$urlstr."&WORK=".$WORK;
$query.=" and WORK like '%".$WORK."%'";
}
if($SOCIATY!="")
{
if($urlstr=="")$urlstr="SOCIATY=".$SOCIATY;
else $urlstr=$urlstr."&SOCIATY=".$SOCIATY;
$query.=" and SOCIATY like '%".$SOCIATY."%'";
}
if($REWARD!="")
{
if($urlstr=="")$urlstr="REWARD=".$REWARD;
else $urlstr=$urlstr."&REWARD=".$REWARD;
$query.=" and REWARD like '%".$REWARD."%'";
}
if($CERTIFICATE!="")
{
if($urlstr=="")$urlstr="CERTIFICATE=".$CERTIFICATE;
else $urlstr=$urlstr."&CERTIFICATE=".$CERTIFICATE;
$query.=" and CERTIFICATE like '%".$CERTIFICATE."%'";
}
if($TRAIN!="")
{
if($urlstr=="")$urlstr="TRAIN=".$TRAIN;
else $urlstr=$urlstr."&TRAIN=".$TRAIN;
$query.=" and TRAIN like '%".$TRAIN."%'";
}
if($SURETY!="")
{
if($urlstr=="")$urlstr="SURETY=".$SURETY;
else $urlstr=$urlstr."&SURETY=".$SURETY;
$query.=" and SURETY like '%".$SURETY."%'";
}
if($CONTRACT!="")
{
if($urlstr=="")$urlstr="CONTRACT=".$CONTRACT;
else $urlstr=$urlstr."&CONTRACT=".$CONTRACT;
$query.=" and CONTRACT like '%".$CONTRACT."%'";
}
if($INSURE!="")
{
if($urlstr=="")$urlstr="INSURE=".$INSURE;
else $urlstr=$urlstr."&INSURE=".$INSURE;
$query.=" and INSURE like '%".$INSURE."%'";
}
if($BODY_EXAMIM!="")
{
if($urlstr=="")$urlstr="BODY_EXAMIM=".$BODY_EXAMIM;
else $urlstr=$urlstr."&BODY_EXAMIM=".$BODY_EXAMIM;
$query.=" and BODY_EXAMIM like '%".$BODY_EXAMIM."%'";
}
if($RESUME!="")
{
if($urlstr=="")$urlstr="RESUME=".$RESUME;
else $urlstr=$urlstr."&RESUME=".$RESUME;
$query.=" and RESUME like '%".$RESUME."%'";
}
if($CUSTOMERUSERDEF1!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF1=".$CUSTOMERUSERDEF1;
else $urlstr=$urlstr."&CUSTOMERUSERDEF1=".$CUSTOMERUSERDEF1;
$query.=" and USERDEF1 like '%".$CUSTOMERUSERDEF1."%'";
}
if($CUSTOMERUSERDEF2!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF2=".$CUSTOMERUSERDEF2;
else $urlstr=$urlstr."&CUSTOMERUSERDEF2=".$CUSTOMERUSERDEF2;
$query.=" and USERDEF2 like '%".$CUSTOMERUSERDEF2."%'";
}
if($CUSTOMERUSERDEF3!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF3=".$CUSTOMERUSERDEF3;
else $urlstr=$urlstr."&CUSTOMERUSERDEF3=".$CUSTOMERUSERDEF3;
$query.=" and USERDEF3 like '%".$CUSTOMERUSERDEF3."%'";
}
if($CUSTOMERUSERDEF4!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF4=".$CUSTOMERUSERDEF4;
else $urlstr=$urlstr."&CUSTOMERUSERDEF4=".$CUSTOMERUSERDEF4;
$query.=" and USERDEF4 like '%".$CUSTOMERUSERDEF4."%'";
}
if($CUSTOMERUSERDEF5!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF5=".$CUSTOMERUSERDEF5;
else $urlstr=$urlstr."&CUSTOMERUSERDEF5=".$CUSTOMERUSERDEF5;
$query.=" and USERDEF5 like '%".$CUSTOMERUSERDEF5."%'";
}
if($ORDERFIELD!="")
{
if($ORDERSIGN=="DOWN")
{
$ORDERTYPE="ASC";
}
if($ORDERSIGN=="UP")
{
$ORDERTYPE="DESC";
}
$OREDERBY=" ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
$query1="select count(*) 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;
$cursor= exequery($connection,$query1);//echo $query1;
if($ROW=mysql_fetch_array($cursor))
$HRMS_COUNT=$ROW[0];
?>
<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"><span class="big3"> 人事档案查询结果</span><br>
</td>
<td valign="bottom"><span class="small1">共 <span class="big4"><?=$HRMS_COUNT?></span> 条信息</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.$OREDERBY;
$cursor= exequery($connection,$query1);//echo $query1;
while($ROW=mysql_fetch_array($cursor))
{
$HRMS_COUNT++;
$USER_ID=$ROW["USER_ID"];
$USER_NAME=$ROW["USER_NAME"];
$DEPT_NAME=$ROW["DEPT_NAME"];
$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"];
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 border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<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?>">部门 <? 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?>">姓名 <? 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=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?>">性别 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="SEX"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="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?>">出生年月 <? 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?>">民族 <? 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=HUKOU_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?>">籍贯 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="HUKOU_PLACE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="HUKOU_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?>">政治面貌 <? 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?>">身份证号码 <? 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_PLACE?></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><input type="button" class="BigButton" value="返回" onclick="location='query.php'"></center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -