WooYun.org

<?
/**
 * 设置环境变量
 *
 */
$path = 'WEB-INF';
set_include_path(get_include_path() . PATH_SEPARATOR . $path);
require_once('../operation/SSoDB.php');
$db = new SSoDB();
	if(!empty($_GET['rsname']))
	{
		$acc=$db->Getuserinfo($_GET['rsname']);
	}
	else
		$acc=$db->GetAllAccount(1,$db->Get_count());
	if(empty($acc))
	{
		echo '<script type="text/javascript"> alert("抱歉，无帐户可导出！");  history.back(); </script>';
		exit;
	}
	$time=date("Y-m-d"); 
//	print_r($acc);echo "<br>";
	for($i=0;$i < count($acc);$i++)
	{
		$temp_msg[$i][0] = $acc[$i]['name'];
		$temp_msg[$i][1] = DecryptPWD($acc[$i]['pwd']);
		$temp_msg[$i][2] = $acc[$i]['ip'];
		$temp_msg[$i][3] = $acc[$i]['pwd_trusteeship'];
		if(!empty($_GET['rsname']))
		{
			if($acc[$i]['7'] == 0)
			{
				$temp_msg[$i][3] = '普通帐户';
			}
			else if($acc[$i]['7'] == 1)
			{
				$temp_msg[$i][3] = '管理帐户';
			}
			else if($acc[$i]['7'] == 2)
			{
				$temp_msg[$i][3] = 'ftp帐户';
			}
			else
			{
				$temp_msg[$i][3] = '超级管理帐户';
			}
			if($acc[$i]['9'] == 0)
			{
				$temp_msg[$i][4] = '否';
			}
			else
			{
				$temp_msg[$i][4] = '是'; 
			}
			if($acc[$i]['8'] == 0)
			{
				$temp_msg[$i][5] = '永久有效';
			}
			else
			{
				$temp_msg[$i][5] = $acc[$i]['pwd_lifetime'].'天';	
			}
			if($acc[$i]['10'] == 0)
			{
				$temp_msg[$i][6] = '未激活';
			}
			else
			{
				$temp_msg[$i][6] = '激活';	
			}
		}
		else
		{
			if($acc[$i]['manager_flag'] == 0)
			{
				$temp_msg[$i][3] = '普通帐户';
			}
			else if($acc[$i]['manager_flag'] == 1)
			{
				$temp_msg[$i][3] = '管理帐户';
			}
			else if($acc[$i]['manager_flag'] == 2)
			{
				$temp_msg[$i][3] = 'ftp帐户';
			}
			else
			{
				$temp_msg[$i][3] = '超级管理帐户';
			}
			if($acc[$i]['pwd_trusteeship'] == 0)
			{
				$temp_msg[$i][4] = '否';
			}
			else
			{
				$temp_msg[$i][4] = '是'; 
			}
			if($acc[$i]['pwd_lifetime'] == 0)
			{
				$temp_msg[$i][5] = '永久有效';
			}
			else
			{
				$temp_msg[$i][5] = $acc[$i]['pwd_lifetime'].'天';	
			}
			if($acc[$i]['state'] == 0)
			{
				$temp_msg[$i][6] = '未激活';
			}
			else
			{
				$temp_msg[$i][6] = '激活';	
			}
		}
		
		$temp_msg[$i][7] = $acc[$i]['spec'];
	}
//print_r($temp_msg);exit;
require 'Spreadsheet/Excel/Writer.php'; 
$workbook = new Spreadsheet_Excel_Writer(); // 初始化类 
$workbook->send('user.xls'); // 发送 Excel 文件名供下载 
$worksheet =& $workbook->addWorksheet('sheet-1'); // 加入一个工作表 sheet-1 
$data = array(
    					array('帐户名', '密码', 'IP','帐户类型','密码托管','密码有效期','帐户状态','帐户备注')
							);
for ($row = 0; $row < count($data); $row ++) 
{
  for ($col = 0; $col < count($data[0]); $col ++) 
  {
		$worksheet->writeString($row, $col, $data[$row][$col]); // 在 sheet-1 中写入数据 
  }
}
for ($r = 1; $r <= count($temp_msg); $r ++) 
{
    for ($c = 0; $c < count($temp_msg[0]); $c++) 
    {
			$worksheet->writeString($r, $c, $temp_msg[$r-1][$c]); // 在 sheet-1 中写入数据 
    }
}
$col_width = 10;
$worksheet->setColumn(0,1,$col_width*2);
$worksheet->setColumn(2,2,$col_width*2);
$worksheet->setColumn(3,7,$col_width*2);
$workbook->close(); // 完成下载
?>