现在要把调查的数据导出到excel
用户有两种,个人(buy_type=1),法人(buy_type=2)-----
用户属性有很多,问题是省份和城市个人和法人不是存储在一个字段上...
个人存储在prefecture,city上,法人存储在corporate_prefecture,corporate_city上
我现在要把它们查询出来,导出到excel里面...
excel表头如下:$col_name = array('id'=>'会员编号',
'email'=>'Email',
'nick_name'=>'用户名',
'prefecture_name'=>'省份',
'city_name'=>'城市',
'created'=>'回答时间');
-----------------------------------------
查询语句如下:
$sql = "SELECT e.answer as answer1,e.created,m.id,m.email,m.nick_name,buy_type, " .
"`prefecture`.`name` AS prefecture_name, " .
"`city`.name AS city_name," .
" pre.name AS prefecture_name,".
"pre_city.name AS city_name ".
"FROM enquete_answer_info e " .
"LEFT JOIN member_info m on e.member_id=m.id " .
"LEFT JOIN city_mst prefecture on m.prefecture=prefecture.id " .
"left join city_mst pre on m.corporate_prefecture=pre.id ".
"left join city_mst pre_city on m.corporate_city=pre_city.id ".
"LEFT JOIN city_mst city on m.city=city.id " .
"WHERE enquete_id=113";
刚开始这样想的,不管是个人还是法人,让他们的列名一样,和excel表头里面的设置一样,结果这样会覆盖的.....
用户有两种,个人(buy_type=1),法人(buy_type=2)-----
用户属性有很多,问题是省份和城市个人和法人不是存储在一个字段上...
个人存储在prefecture,city上,法人存储在corporate_prefecture,corporate_city上
我现在要把它们查询出来,导出到excel里面...
excel表头如下:$col_name = array('id'=>'会员编号',
'email'=>'Email',
'nick_name'=>'用户名',
'prefecture_name'=>'省份',
'city_name'=>'城市',
'created'=>'回答时间');
-----------------------------------------
查询语句如下:
$sql = "SELECT e.answer as answer1,e.created,m.id,m.email,m.nick_name,buy_type, " .
"`prefecture`.`name` AS prefecture_name, " .
"`city`.name AS city_name," .
" pre.name AS prefecture_name,".
"pre_city.name AS city_name ".
"FROM enquete_answer_info e " .
"LEFT JOIN member_info m on e.member_id=m.id " .
"LEFT JOIN city_mst prefecture on m.prefecture=prefecture.id " .
"left join city_mst pre on m.corporate_prefecture=pre.id ".
"left join city_mst pre_city on m.corporate_city=pre_city.id ".
"LEFT JOIN city_mst city on m.city=city.id " .
"WHERE enquete_id=113";
刚开始这样想的,不管是个人还是法人,让他们的列名一样,和excel表头里面的设置一样,结果这样会覆盖的.....
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货