export.php

极限网络智能办公系统 - Office Automation 2.8 100％ 源码

<?php

function dept_tree_list( $DEPT_ID, $PRIV_OP )
{
	global $DEEP_COUNT;
	$connection = openconnection( );
	$query = "SELECT * from DEPARTMENT where DEPT_PARENT={$DEPT_ID} order by DEPT_NO";
	$cursor = exequery( $connection, $query );
	$OPTION_TEXT = "";
	$DEEP_COUNT1 = $DEEP_COUNT;
	$DEEP_COUNT .= "　";
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$DEPT_ID = $ROW['DEPT_ID'];
		$DEPT_NAME = $ROW['DEPT_NAME'];
		$DEPT_NAME = str_replace( "<", "&lt", $DEPT_NAME );
		$DEPT_NAME = str_replace( ">", "&gt", $DEPT_NAME );
		$DEPT_NAME = stripslashes( $DEPT_NAME );
		if ( $PRIV_OP == 1 )
		{
			$DEPT_PRIV = is_dept_priv( $DEPT_ID );
		}
		else
		{
			$DEPT_PRIV = 1;
		}
		$OPTION_TEXT_CHILD = dept_tree_list( $DEPT_ID, $PRIV_OP );
		if ( $DEPT_PRIV == 1 )
		{
			$query = "select * from HRMS,USER,USER_PRIV where USER.DEPT_ID={$DEPT_ID} and USER.USER_ID=HRMS.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV order by USER.USER_PRIV,USER_NAME";
			$cursor1 = exequery( $connection, $query );
			while ( $ROW = mysql_fetch_array( $cursor1 ) )
			{
				$NO = $ROW['NO'];
				$CARD_NO = $ROW['CARD_NO'];
				$USER_NAME = $ROW['USER_NAME'];
				$SEX = $ROW['SEX'];
				$BIRTHDAY = $ROW['BIRTHDAY'];
				$BIRTHDAY = strtok( $BIRTHDAY, " " );
				if ( $BIRTHDAY == "0000-00-00" )
				{
					$BIRTHDAY = "";
				}
				$MARRY = $ROW['MARRY'];
				$WORK_DATE = $ROW['WORK_DATE'];
				$WORK_DATE = strtok( $WORK_DATE, " " );
				if ( $WORK_DATE == "0000-00-00" )
				{
					$WORK_DATE = "";
				}
				$JOIN_DATE = $ROW['JOIN_DATE'];
				$JOIN_DATE = strtok( $JOIN_DATE, " " );
				if ( $JOIN_DATE == "0000-00-00" )
				{
					$JOIN_DATE = "";
				}
				$EDUCATION = $ROW['EDUCATION'];
				$POLITICS = $ROW['POLITICS'];
				$REWARD = $ROW['REWARD'];
				$CERTIFICATE = $ROW['CERTIFICATE'];
				$TRAIN = $ROW['TRAIN'];
				$RESUME = $ROW['RESUME'];
				$NATION = $ROW['NATION'];
				$NATIVE_PLACE = $ROW['NATIVE_PLACE'];
				$SPECIALITY = $ROW['SPECIALITY'];
				$SCHOOL = $ROW['SCHOOL'];
				$DEPARTMENT = $ROW['DEPARTMENT'];
				$POST = $ROW['POST'];
				$HOME_ADDR = $ROW['HOME_ADDR'];
				$HOME_TEL = $ROW['HOME_TEL'];
				$EMAIL = $ROW[21];
				$EDU = $ROW['EDU'];
				$WORK = $ROW['WORK'];
				$SOCIATY = $ROW['SOCIATY'];
				if ( $SEX == "0" )
				{
					$SEX_DESC = "男";
				}
				else if ( $SEX == "1" )
				{
					$SEX_DESC = "女";
				}
				else
				{
					$SEX_DESC = "";
				}
				if ( $MARRY == "0" )
				{
					$MARRY_DESC = "未婚";
				}
				else if ( $MARRY == "1" )
				{
					$MARRY_DESC = "已婚";
				}
				else if ( $MARRY == "2" )
				{
					$MARRY_DESC = "离异";
				}
				else
				{
					$MARRY_DESC = "";
				}
				if ( $EDUCATION == "1" )
				{
					$EDUCATION_DESC = "小学";
				}
				else if ( $EDUCATION == "2" )
				{
					$EDUCATION_DESC = "初中";
				}
				else if ( $EDUCATION == "3" )
				{
					$EDUCATION_DESC = "高中";
				}
				else if ( $EDUCATION == "4" )
				{
					$EDUCATION_DESC = "中专";
				}
				else if ( $EDUCATION == "5" )
				{
					$EDUCATION_DESC = "大专";
				}
				else if ( $EDUCATION == "6" )
				{
					$EDUCATION_DESC = "大本";
				}
				else if ( $EDUCATION == "7" )
				{
					$EDUCATION_DESC = "硕士";
				}
				else if ( $EDUCATION == "8" )
				{
					$EDUCATION_DESC = "博士";
				}
				else if ( $EDUCATION == "9" )
				{
					$EDUCATION_DESC = "博士后";
				}
				else
				{
					$EDUCATION_DESC = "";
				}
				if ( $POLITICS == "1" )
				{
					$POLITICS_DESC = "群众";
				}
				else if ( $POLITICS == "2" )
				{
					$POLITICS_DESC = "团员";
				}
				else if ( $POLITICS == "3" )
				{
					$POLITICS_DESC = "党员";
				}
				else if ( $POLITICS == "4" )
				{
					$POLITICS_DESC = "预备党员";
				}
				else
				{
					$POLITICS_DESC = "";
				}
				$OPTION_TEXT .= "\r\n      <tr style=\"BACKGROUND: #FFFFFF;\">\r\n        <td nowrap>".$DEEP_COUNT1."├".$DEPT_NAME."</td>\r\n        <td nowrap>".$NO."</td>\r\n        <td nowrap>".$USER_NAME."</td>\r\n        <td>".$SEX_DESC."</td>\r\n        <td nowrap>".$BIRTHDAY."</td>\r\n        <td>".$NATION."</td>\r\n        <td>".$NATIVE_PLACE."</td>\r\n        <td x:str=\"'{$CARD_NO}\">".$CARD_NO."</td>\r\n        <td>".$MARRY_DESC."</td>\r\n        <td>".$EDUCATION_DESC."</td>\r\n        <td>".$SCHOOL."</td>\r\n        <td>".$SPECIALITY."</td>\r\n        <td nowrap>".$WORK_DATE."</td>\r\n        <td nowrap>".$JOIN_DATE."</td>\r\n        <td>".$POST."</td>\r\n        <td>".$POLITICS_DESC."</td>\r\n        <td>".$HOME_ADDR."</td>\r\n        <td>".$HOME_TEL."</td>\r\n        <td>".$EMAIL."</td>\r\n        <td>".$EDU."</td>\r\n        <td>".$WORK."</td>\r\n        <td>".$SOCIATY."</td>\r\n        <td>".$REWARD."</td>\r\n        <td>".$CERTIFICATE."</td>\r\n        <td>".$TRAIN."</td>\r\n        <td>".$RESUME."</td>\r\n      </tr>\n";
			}
			$OPTION_TEXT .= $OPTION_TEXT_CHILD;
		}
	}
	$DEEP_COUNT = $DEEP_COUNT1;
	return $OPTION_TEXT;
}

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
ob_end_clean( );
header( "Cache-control: private" );
header( "Content-type: application/vnd.ms-excel" );
header( "Content-Disposition: attachment; filename= 人事档案.xls" );
echo "\r\n<html xmlns:o=\"urn:schemas-microsoft-com:office:office\"\r\nxmlns:x=\"urn:schemas-microsoft-com:office:excel\"\r\nxmlns=\"http://www.w3.org/TR/REC-html40\">\r\n<head>\r\n<title>人事档案</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body>\r\n";
$OPTION_TEXT = dept_tree_list( 0, 0 );
echo "  <table border=\"1\" cellspacing=\"1\" class=\"small\" cellpadding=\"3\">\r\n      <tr style=\"BACKGROUND: #D3E5FA; color: #000000; font-weight: bold;\">\r\n        <td>部门</td>\r\n        <td>编号</td>\r\n        <td>姓名</td>\r\n        <td>性别</td>\r\n        <td>出生年月</td>\r\n        <td>民族</td>\r\n        <td>籍贯</td>\r\n        <td>身份证号码</td>\r\n        <td>婚姻状况</td>\r\n        <td>学历</td>\r\n        <td>毕业院校</td>\r\n        <t";
echo "d>专业</td>\r\n        <td>参加工作时间</td>\r\n        <td>加入本单位时间</td>\r\n        <td>岗位</td>\r\n        <td>政治面貌</td>\r\n        <td>家庭住址</td>\r\n        <td>家庭电话</td>\r\n        <td>电子邮件</td>\r\n        <td>教育背景</td>\r\n        <td>工作简历</td>\r\n        <td>社会关系</td>\r\n        <td>奖惩记录</td>\r\n        <td>职务情况</td>\r\n        <td>培训记录</td>\r\n        <td>备 注</td>\r\n      </tr>\r\n      ";
echo $OPTION_TEXT;
echo "  </table>\r\n\r\n</body>\r\n</html>";
?>