📄 excel_report.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/check_type.php");
$STYLE_ARRAY=explode(",",$FIELDMSGNAME);
$ARRAY_COUNT=sizeof($STYLE_ARRAY);
$COUNT=0;
if($STYLE_ARRAY[$ARRAY_COUNT-1]=="")$ARRAY_COUNT--;
for($I=0;$I<$ARRAY_COUNT;$I++)
{
$EXCEL_OUT.=$STYLE_ARRAY[$I]."\t";
}
$EXCEL_OUT.="\n";
$CUR_DATE=date("Y-m-d",time());
$query="";
//----------- 合法性校验 ---------
if($BIRTHDAY_MIN!="")
{
$TIME_OK=is_date($BIRTHDAY_MIN);
if(!$TIME_OK)
{ Message("错误","\"生日\"的\"开始日期\"格式不对，应形如 ".$CUR_DATE);
Button_Back();
exit;
}
$query.=" and HR_BIRTHDAY>='$BIRTHDAY_MIN'";
}
if($BIRTHDAY_MAX!="")
{
$TIME_OK=is_date($BIRTHDAY_MAX);
if(!$TIME_OK)
{ Message("错误","\"生日\"的\"结束日期\"格式不对，应形如 ".$CUR_DATE);
Button_Back();
exit;
}
$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;
}
$query.=" and WORK_DATE>='$WORK_DATE_MIN'";
}
if($WORK_DATE_MAX!="")
{
$TIME_OK=is_date($WORK_DATE_MAX);
if(!$TIME_OK)
{ Message("错误","\"参加工作时间\"的\"结束日期\"格式不对，应形如 ".$CUR_DATE);
Button_Back();
exit;
}
$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;
}
$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;
}
$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());
$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());
$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!="")
$query.=" and b.DEPT_ID=$DEPT_ID";
if($SEX!="")
$query.=" and SEX='$SEX'";
if($MARRY!="")
$query.=" and MARRY='$MARRY'";
if($EDUCATION!="")
$query.=" and EDUCATION='$EDUCATION'";
if($POLITICS!="")
$query.=" and POLITICS='$POLITICS'";
if($NO!="")
$query.=" and NO like '%".$NO."%'";
if($NATION!="")
$query.=" and NATION like '%".$NATION."%'";
if($CARD_NO!="")
$query.=" and CARD_NO like '%".$CARD_NO."%'";
if($NATIVE_PLACE!="")
$query.=" and NATIVE_PLACE like '%".$NATIVE_PLACE."%'";
if($HUKOU_PLACE!="")
$query.=" and HUKOU_PLACE like '%".$HUKOU_PLACE."%'";
if($SPECIALITY!="")
$query.=" and SPECIALITY like '%".$SPECIALITY."%'";
if($SCHOOL!="")
$query.=" and SCHOOL like '%".$SCHOOL."%'";
if($DEPARTMENT!="")
$query.=" and DEPARTMENT like '%".$DEPARTMENT."%'";
if($POST!="")
$query.=" and POST like '%".$POST."%'";
if($TECH_POST!="")
$query.=" and TECH_POST like '%".$TECH_POST."%'";
if($HOME_ADDR!="")
$query.=" and HOME_ADDR like '%".$HOME_ADDR."%'";
if($HOME_TEL!="")
$query.=" and HOME_TEL like '%".$HOME_TEL."%'";
if($EMAIL!="")
$query.=" and EMAIL like '%".$EMAIL."%'";
if($POST_CHANGE!="")
$query.=" and POST_CHANGE like '%".$POST_CHANGE."%'";
if($EDU!="")
$query.=" and EDU like '%".$EDU."%'";
if($WORK!="")
$query.=" and WORK like '%".$WORK."%'";
if($SOCIATY!="")
$query.=" and SOCIATY like '%".$SOCIATY."%'";
if($REWARD!="")
$query.=" and REWARD like '%".$REWARD."%'";
if($CERTIFICATE!="")
$query.=" and CERTIFICATE like '%".$CERTIFICATE."%'";
if($TRAIN!="")
$query.=" and TRAIN like '%".$TRAIN."%'";
if($SURETY!="")
$query.=" and SURETY like '%".$SURETY."%'";
if($CONTRACT!="")
$query.=" and CONTRACT like '%".$CONTRACT."%'";
if($INSURE!="")
$query.=" and INSURE like '%".$INSURE."%'";
if($BODY_EXAMIM!="")
$query.=" and BODY_EXAMIM like '%".$BODY_EXAMIM."%'";
if($RESUME!="")
$query.=" and RESUME like '%".$RESUME."%'";
if($CUSTOMERUSERDEF1!="")
{
$query.=" and USERDEF1 like '%".$CUSTOMERUSERDEF1."%'";
}
if($CUSTOMERUSERDEF2!="")
{
$query.=" and USERDEF2 like '%".$CUSTOMERUSERDEF2."%'";
}
if($CUSTOMERUSERDEF3!="")
{
$query.=" and USERDEF3 like '%".$CUSTOMERUSERDEF3."%'";
}
if($CUSTOMERUSERDEF4!="")
{
$query.=" and USERDEF4 like '%".$CUSTOMERUSERDEF4."%'";
}
if($CUSTOMERUSERDEF5!="")
{
$query.=" and USERDEF5 like '%".$CUSTOMERUSERDEF5."%'";
}
$HRMS_COUNT=0;
$query1="select ".substr($FIELDMSG,0,strlen($FIELDMSG)-1)." from HRMS a
LEFT OUTER JOIN USER b ON a.USER_ID = b.USER_ID";
$query1=$query1." where b.DEPT_ID!=0".$query;
$cursor= exequery($connection,$query1);
$USER_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$STYLE_ARRAY=explode(",",$FIELDMSG);
$ARRAY_COUNT=sizeof($STYLE_ARRAY);
$COUNT=0;
if($STYLE_ARRAY[$ARRAY_COUNT-1]=="")$ARRAY_COUNT--;
for($I=0;$I<$ARRAY_COUNT;$I++)
{
$MESSAGE=$ROW[$STYLE_ARRAY[$I]];
echo $MESSAGE."<br>";
if($STYLE_ARRAY[$I]=="MARRY")
{
if($MESSAGE=="0") $MESSAGE="未婚";
elseif($MESSAGE=="1")$MESSAGE= "已婚";
elseif($MESSAGE=="2")$MESSAGE="离异";
}
if($STYLE_ARRAY[$I]=="SEX")
{
if($MESSAGE=="0")$MESSAGE="男";
elseif($MESSAGE=="1")$MESSAGE="女";
}
if($STYLE_ARRAY[$I]=="EDUCATION")
{
if($MESSAGE==1)$MESSAGE="小学";
elseif($MESSAGE==2)$MESSAGE="初中";
elseif($MESSAGE==3) $MESSAGE="高中";
elseif($MESSAGE==4) $MESSAGE="中专";
elseif($MESSAGE==5)$MESSAGE="大专";
elseif($MESSAGE==6)$MESSAGE="大本";
elseif($MESSAGE==7)$MESSAGE="硕士";
elseif($MESSAGE==8)$MESSAGE="博士";
elseif($MESSAGE==9) $MESSAGE="博士后";
}
if($STYLE_ARRAY[$I]=="POLITICS")
{
if($MESSAGE==1) $MESSAGE="群众";
elseif($MESSAGE==2) $MESSAGE="团员";
elseif($MESSAGE==3) $MESSAGE="党员";
elseif($MESSAGE==4) $MESSAGE="预备党员";
}
if($STYLE_ARRAY[$I]=="USERDEF1" || $STYLE_ARRAY[$I]=="USERDEF2" || $STYLE_ARRAY[$I]=="USERDEF3" || $STYLE_ARRAY[$I]=="USERDEF4" || $STYLE_ARRAY[$I]=="USERDEF5")
{
$query = "select * from FIELDSETTING where TABLENAME='HRMS' and FIELDNO='$STYLE_ARRAY[$I]' ORDER BY ORDERNO ASC ";
$cursor1=exequery($connection,$query);
if($ROW1=mysql_fetch_array($cursor1))
{
$FIELDNAME=$ROW1["FIELDNAME"];
$ORDERNO=$ROW1["ORDERNO"];
$STYPE=$ROW1["STYPE"];
$TYPENAME=$ROW1["TYPENAME"];
$TYPEVALUE=$ROW1["TYPEVALUE"];
$TYPECODE=$ROW1["TYPECODE"];
$ISQUERY=$ROW1["ISQUERY"];
$ISGROUY=$ROW1["ISGROUY"];
$FIELDNAME=$ROW1["FIELDNAME"];
$FIELDNO=$ROW1["FIELDNO"];
$FIELDNO1=$FIELDNO."1";
}
if($STYPE=="D")
{
$TYPEVALUE=str_replace("，",",",$TYPEVALUE);
$TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
$TYPENAME=str_replace("，",",",$TYPENAME);
$TYPENAME_ARRAY=explode(",",$TYPENAME);
$TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
for($I1=0;$I1<$TYPENAME_COUNT;$I1++)
{
if($MESSAGE==$TYPEVALUE_ARRAY[$I1])
{
$MESSAGE=$TYPENAME_ARRAY[$I1];
}
}
}
if($STYPE=="C")
{
$MESSAGE1="";
$temp=str_replace("，",",",$MESSAGE);
$temp_ARRAY=explode(",",$temp);
$temp_ARRAY_count=sizeof($temp_ARRAY);
$TYPEVALUE=str_replace("，",",",$TYPEVALUE);
$TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
$TYPENAME=str_replace("，",",",$TYPENAME);
$TYPENAME_ARRAY=explode(",",$TYPENAME);
$TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
for($I1=0;$I1<$TYPENAME_COUNT;$I1++)
{
$flag=0;
for($T=0;$T< $temp_ARRAY_count;$T++)
{
if($temp_ARRAY[$T]==$TYPEVALUE_ARRAY[$I1])
{
$MESSAGE1=$MESSAGE1.$TYPENAME_ARRAY[$I1].",";
$MESSAGE=$MESSAGE1;
}
}
}
}
if($STYPE=="R")
{
$TYPEVALUE=str_replace("，",",",$TYPEVALUE);
$TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
$TYPENAME=str_replace("，",",",$TYPENAME);
$TYPENAME_ARRAY=explode(",",$TYPENAME);
$TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
for($I1=0;$I1<$TYPENAME_COUNT;$I1++)
{
if($MESSAGE==$TYPEVALUE_ARRAY[$I1])
{
$MESSAGE=$TYPENAME_ARRAY[$I1];
}
}
}
}
$EXCEL_OUT.=$MESSAGE."\t";
}
$EXCEL_OUT.="\n";
}
ob_end_clean();
Header("Cache-control: private");
Header("Content-type: application/vnd.ms-excel");
Header("Accept-Ranges: bytes");
Header("Accept-Length: ".strlen($EXCEL_OUT));
Header("Content-Disposition: attachment; filename=人事档案.xls");
echo $EXCEL_OUT;
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -