导出csv格式文件

最新推荐文章于 2024-05-27 16:40:15 发布

飞翔的荷兰人

最新推荐文章于 2024-05-27 16:40:15 发布

阅读量997

点赞数

CC 4.0 BY-SA版权

分类专栏：代码片段文章标签： csv 格式化

本文链接：https://blog.youkuaiyun.com/hjt321658/article/details/11903013

代码片段专栏收录该内容

10 篇文章

订阅专栏

本文详细介绍了如何在编程中创建CSV（逗号分隔值）文件，以及如何进行有效格式化，确保数据在导入其他应用程序时的正确性和一致性。内容涵盖了CSV文件的基本结构、字段分隔、转义字符的使用以及如何处理特殊数据类型等关键点。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<?php
	class TransExportCsvLib
	{
		public function exportTransLib(MY_Controller $ctrl,$condition=array(),$getDomainGroup)
		{
			require_once APP_MOD_PATH."trans_domain_auction.php";
			$TDAsdk = new Trans_domain_auction();
			$totalCount=$TDAsdk->getTransSearchCount($condition['domainName'],  '', $condition['buyer'], $condition['seller'], 8, $condition['finishDate'],
											1, $condition['sysGroupOne'], $condition['sysGroupTwo'], '', $condition['domainTLD'],  $condition['transType'], $condition['transTopic']);

			if($condition['count'] > $totalCount)
			{
				//如果输入的导出个数超过数据库里符合条件的记录数
				$condition['count']=$totalCount;
			}
			$data=array();
			$domainStr='';
			$data= $TDAsdk->getTransSearch($condition['domainName'], '', $condition['buyer'], $condition['seller'], 8, $condition['finishDate'],
					1, $condition['sysGroupOne'], $condition['sysGroupTwo'], '', $condition['domainTLD'], $condition['transType'], $condition['transTopic'],
					$condition['count'],  '');
			$domainStr=$this->formateData($ctrl,$data,$getDomainGroup);
			$this->writeCsvFile($domainStr);	
		}
		/**
		 * 格式化导出的数据
		 *add 2013-09-18 by huangjt
		 *param:obj
		 *param:array
		 *param:int
		 *return : string
		 */
		public function formateData(MY_Controller $ctrl,$data,$getDomainGroup)
		{
			require_once APP_MOD_PATH."trans_delivery.php";
			$transDelivery=new Trans_delivery();
			$pLib = new PublicCommonLib();
			$transTopicConf = $pLib->configCovert($ctrl->config->item('fabu_transtopic'));
			$tldConf = $ctrl->config->item('trans_domain_domainTLD');
			$domainList=array();
			$domainStr = 'AuditListId,域名,系统分组,域名后缀,买家ID,卖家ID,交易类型,专题类型,交易金额,手续费,结拍时间,交易完成时间,交易状态'."\n";
			if($data)
			{
				$tsDomainGroup= $ctrl->config->item('ts_domaingroup');
				$tsTranstype=$ctrl->config->item('ts_transtype');
				$tsTransstatus=$ctrl->config->item('ts_transstatus');
				foreach($data as  $k=>$v){
					$domainStr .= $v['AuditListId'].",";
					$domainStr .= $v['DomainName'].",";
					$domainStr .= ($getDomainGroup ?trim(str_replace(' ','',$tsDomainGroup[$getDomainGroup][0])):'').",";
					$domainStr .= (empty($tldConf[$v['DomainTLD']]) ? '未知后缀' : $tldConf[$v['DomainTLD']]).",";
					$domainStr .= $v['Buyer'].",";
					$domainStr .= $v['Seller'].",";
					$domainStr .= $transTopicConf[$v['TransTopic']].",";
					$domainStr .= $tsTranstype[$v['TransType']][0].",";
					$domainStr .= $v['BidPrice'].",";
					$domainStr .= $v['Poundage'].",";
					$domainStr .= $v['FinishDate'].",";
					$trans = $transDelivery->getTransInfo($v['AuditListId']);
					$domainStr .= $trans['DeliveryDateFlag'].",";
					$domainStr .= $tsTransstatus[$v['TransStatus']]."\n";
				}
			}
			return $domainStr;
		}
		/**
		 * 写入csv文件
		 * add 2013-09-18 by huangjt
		 * param:array
		 */
		public function writeCsvFile($domainStr)
		{
			$fileName="交易列表_".date('Y-m-d-H-i-s').'.csv';
			header("Content-type:text/csv");
			header("Content-Disposition:attachment;filename=".$fileName);
			header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
			header('Expires:0');
			header('Pragma:public');
			echo $domainStr;
			exit();
		}
	}
?>