📄 search.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>人事档案查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
function hrms_detail(USER_ID)
{
URL="hrms.php?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)||$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($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($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 like '%".$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($DEPARTMENT!="")
{
if($urlstr=="")$urlstr="DEPARTMENT=".$DEPARTMENT;
else $urlstr=$urlstr."&DEPARTMENT=".$DEPARTMENT;
$query.=" and DEPARTMENT like '%".$DEPARTMENT."%'";
}
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 like '%".$TECH_POST."%'";
}
if($HOME_ADDR!="")
{
if($urlstr=="")$urlstr="HOME_ADDR=".$HOME_ADDR;
else $urlstr=$urlstr."&HOME_ADDR=".$HOME_ADDR;
$query.=" and HOME_ADDR like '%".$HOME_ADDR."%'";
}
if($HOME_TEL!="")
{
if($urlstr=="")$urlstr="HOME_TEL=".$HOME_TEL;
else $urlstr=$urlstr."&HOME_TEL=".$HOME_TEL;
$query.=" and HOME_TEL like '%".$HOME_TEL."%'";
}
if($EMAIL!="")
{
if($urlstr=="")$urlstr="EMAIL=".$EMAIL;
else $urlstr=$urlstr."&EMAIL=".$EMAIL;
$query.=" and EMAIL like '%".$EMAIL."%'";
}
if($POST_CHANGE!="")
{
if($urlstr=="")$urlstr="POST_CHANGE=".$POST_CHANGE;
else $urlstr=$urlstr."&POST_CHANGE=".$POST_CHANGE;
$query.=" and POST_CHANGE like '%".$POST_CHANGE."%'";
}
if($EDU!="")
{
if($urlstr=="")$urlstr="EDU=".$EDU;
else $urlstr=$urlstr."&EDU=".$EDU;
$query.=" and EDU like '%".$EDU."%'";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -