search.php
来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 483 行 · 第 1/2 页
PHP
483 行
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_field.php");
include_once("inc/utility_org.php");
include_once("check_priv.php");
?>
<html>
<head>
<title>人事档案统计</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="javascript">
function LoadWindow1(strtype,strname,strquery,TCOUNT)
{
URL="detailview.php?type="+strtype+"&name="+strname+"&query="+strquery+"&TOTALCOUNT="+TCOUNT+"";
loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
loc_y=document.body.scrollTop+event.clientY-event.offsetY-170;
window.showModalDialog(URL,self,"edge:raised;scroll:1;status:0;help:0;resizable:1;dialogWidth:500px;dialogHeight:400px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
$TYPENAME_ARRAY=explode(",",$SUMFIELD);
$CUR_DATE=date("Y-m-d",time());
$query="";
//----------- 合法性校验 ---------
$query.=" where a.USER_ID=b.USER_ID";
if($BIRTHDAY_MIN!="")
{
$TIME_OK=is_date($BIRTHDAY_MIN);
if(!$TIME_OK)
{ Message("错误","\"生日\"的\"开始日期\"格式不对，应形如 ".$CUR_DATE);
Button_Back();
exit;
}
if($query=="")
$query.=" where HR_BIRTHDAY>='$BIRTHDAY_MIN'";
else
$query.=" and HR_BIRTHDAY>='$BIRTHDAY_MIN'";
}
if($BIRTHDAY_MAX!="")
{
$TIME_OK=is_date($BIRTHDAY_MAX);
if(!$TIME_OK)
{
Message("错误","\"生日\"的\"结束日期\"格式不对，应形如 ".$CUR_DATE);
Button_Back();
exit;
}
if($query=="")
$query.=" where HR_BIRTHDAY<='$BIRTHDAY_MAX'";
else
$query.=" and HR_BIRTHDAY<='$BIRTHDAY_MAX'";
}
if($WORK_DATE_MIN!="")
{
$TIME_OK=is_date($WORK_DATE_MIN);
if(!$TIME_OK)
{ Message("错误","\"参加工作时间\"的\"开始日期\"格式不对，应形如 ".$CUR_DATE);
Button_Back();
exit;
}
if($query=="")
$query.=" where WORK_DATE>='$WORK_DATE_MIN'";
else
$query.=" and WORK_DATE>='$WORK_DATE_MIN'";
}
if(($SELECTITEM!="-1")&&($TContext!="")) //其他 like '%".$NO."%'";
{
if($query=="")
$query.=" where a.$SELECTITEM like '%".$TContext."%'";
else
$query.=" and a.$SELECTITEM like '%".$TContext."%'";
}
if($WORK_DATE_MAX!="")
{
$TIME_OK=is_date($WORK_DATE_MAX);
if(!$TIME_OK)
{ Message("错误","\"参加工作时间\"的\"结束日期\"格式不对，应形如 ".$CUR_DATE);
Button_Back();
exit;
}
if($query=="")
$query.=" where WORK_DATE<='$WORK_DATE_MAX'";
else
$query.=" and WORK_DATE<='$WORK_DATE_MAX'";
}
if($JOIN_DATE_MIN!="")
{
$TIME_OK=is_date($JOIN_DATE_MIN);
if(!$TIME_OK)
{ Message("错误","\"加入本单位时间\"的\"开始日期\"格式不对，应形如 ".$CUR_DATE);
Button_Back();
exit;
}
if($query=="")
$query.=" where JOIN_DATE>='$JOIN_DATE_MIN'";
else
$query.=" and JOIN_DATE>='$JOIN_DATE_MIN'";
}
if($JOIN_DATE_MAX!="")
{
$TIME_OK=is_date($JOIN_DATE_MAX);
if(!$TIME_OK)
{ Message("错误","\"加入本单位时间\"的\"结束日期\"格式不对，应形如 ".$CUR_DATE);
Button_Back();
exit;
}
if($query=="")
$query.=" where JOIN_DATE<='$JOIN_DATE_MAX'";
else
$query.=" and JOIN_DATE<='$JOIN_DATE_MAX'";
}
if($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());
if($query=="")
$query.=" where HR_BIRTHDAY<='$YEAR_MIN'";
else
$query.=" and HR_BIRTHDAY<='$YEAR_MIN'";
}
if($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());
if($query=="")
$query.=" where HR_BIRTHDAY>='$YEAR_MAX'";
else
$query.=" and HR_BIRTHDAY>='$YEAR_MAX'";
}
if($BIRTHDAY_MIN!="" || $BIRTHDAY_MAX!="" || $AGE_MIN!="" || $AGE_MAX!="")
{
if($query=="")
$query.=" where HR_BIRTHDAY!='0000-00-00' and HR_BIRTHDAY!='1900-01-01'";
else
$query.=" and HR_BIRTHDAY!='0000-00-00' and HR_BIRTHDAY!='1900-01-01'";
}
if ($TO_ID!="ALL_DEPT") //未选中全体部门
{
if ($TO_ID!="") //选择若干部门
{
$DEPT_ID=$TO_ID;
if ($selectWL=="on") //包含离职/外部人员
{
$DEPT_ID=$DEPT_ID."0";
}
else
{
if (substr($DEPT_ID,-1)==",")
$DEPT_ID=substr($DEPT_ID,0,-1);
}
}
else //未选择部门
{
if ($selectWL=="on") //包含离职/外部人员
{
$DEPT_ID="0";
}
else //未选择部门不包含离职/外部人员
{
$DEPT_ID="";
if($query=="")
$query.=" where b.DEPT_ID <>'0'";
else
$query.=" and b.DEPT_ID <>'0'";
}
}
if($DEPT_ID!="")
{
$DEPT_ID="(".$DEPT_ID.")";
if($query=="")
$query.=" where b.DEPT_ID in $DEPT_ID";
else
$query.=" and b.DEPT_ID in $DEPT_ID";
}
}
else //选中全体部门
{
if ($selectWL!="on") //不包含离职/外部人员
{
if($query=="")
$query.=" where b.DEPT_ID <>'0'";
else
$query.=" and b.DEPT_ID <>'0'";
}
}
if($SEX!="")
{
if($query=="")
$query.=" where b.SEX='$SEX'";
else
$query.=" and b.SEX='$SEX'";
}
if($MARRY!="")
{
if($query=="")
$query.=" where a.MARRY='$MARRY'";
else
$query.=" and a.MARRY='$MARRY'";
}
if($EDUCATION!="")
{
if($query=="")
$query.=" where a.EDUCATION='$EDUCATION'";
else
$query.=" and a.EDUCATION='$EDUCATION'";
}
if($POLITICS!="")
{
if($query=="")
$query.=" where a.POLITICS='$POLITICS'";
else
$query.=" and a.POLITICS='$POLITICS'";
}
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?