Excel导出数据

最新推荐文章于 2025-09-12 15:58:40 发布

转载最新推荐文章于 2025-09-12 15:58:40 发布 · 61 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/sharesuiyue/blog/414167

文章标签：

#python

2019独角兽企业重金招聘Python工程师标准>>>

function in_export () {
		require admin_ROOT.adminfile.'/include/skintitle/skintitle_member.php';
		require admin_ROOT.adminfile.'/include/inc_member.php';
		require admin_ROOT.adminfile.'/include/systemlist.php';
		parent::start_template();
		//$projectid=$this->accept('ecisp_member_project_id','C');
		header("Content-type:application/vnd.ms-excel");  
		header("Content-Disposition: attachment; filename=Email.xls");   
		header("Pragma: no-cache");   
		header("Expires: 0"); 	
		
		$this->ectemplates->caching=false;
		/*$lng=$this->accept('lng','R');
		$lng=empty($lng) ? $SL['lng'] : $lng;*/
		
		$ec_member_username_id=$this->accept('ecisp_member_username_id','C');
		$ec_member_project_id=$this->accept('ecisp_member_project_id','C');
		$db_table=db_prefix.'email';
		$db_table2=db_prefix.'email_status';
		$db_where="$db_table.userid=$ec_member_username_id and $db_table.projectid=$ec_member_project_id ";

		$sql="SELECT $db_table.*,$db_table2.status as status_name from $db_table LEFT JOIN $db_table2 ON $db_table.status = $db_table2.id where $db_where";
		
		$rs=$this->db->query($sql);	
		
		echo '编号'.chr(9); 
		echo '语言'.chr(9); 
		echo '邮件标题'.chr(9); 	
		echo '邮件正文'.chr(9); 		
		echo '受邀人公司名称'.chr(9); 
		echo '受邀人姓名'.chr(9); 
		echo '受邀人邮件'.chr(9); 
		echo '邀请函编码'.chr(9); 
		echo '发送时间'.chr(9); 	
		echo '发送状态'.chr(9); 		
		echo chr(10);
		while ($rsList=$this->db->fetch_array($rs)) {
			echo $this->htmldecode($rsList['id']).chr(9); 
			echo $this->htmldecode($rsList['lng']).chr(9); 
			echo $this->htmldecode($rsList['send_title']).chr(9); 
			echo $this->htmldecode($rsList['send_memo']).chr(9); 
			echo $this->htmldecode($rsList['company']).chr(9); 
			echo $this->htmldecode($rsList['linkman']).chr(9); 
			echo $this->htmldecode($rsList['email']).chr(9); 
			echo $this->htmldecode($rsList['sys_sn']).chr(9); 
			echo $this->formatdate(3,$rsList[addtime]).chr(9); 		
			echo $this->htmldecode($rsList['status']==1?'发送成功':'发送失败').chr(9); 
			echo chr(10);
		}

	}

转载于:https://my.oschina.net/sharesuiyue/blog/414167