public function excel() { $_scenedata = M('scenedata'); $_scenedatadetail = M('scenedatadetail'); $where['sceneid_bigint'] = I('get.id', 0); $where['userid_int'] = intval(session('userid')); $_scene_list = $_scenedata->where($where)->order('dataid_bigint asc')->select(); $wheredetail['sceneid_bigint'] = I('get.id', 0); $_scenedatadetail_list = $_scenedatadetail->where($wheredetail)->order('detailid_bigint desc')->select(); $_scene_count = $_scenedatadetail->where($wheredetail)->count(); $jsonstr = ',,,,,,,,,,,,' . utf2gb('技术支持 By 一秀') . ',' . "\n"; $jsonstr .= ',total:' . $_scene_count . ',,,,,,,,,,,,' . "\n"; $jsonstrtemp = ''; $listkey = ''; foreach ($_scene_list as $vo) { //$data .= utf2gb('姓名').','.utf2gb('性别') ; $jsonstrtemp = $jsonstrtemp . utf2gb($vo["elementtitle_varchar"]) . ','; //''.json_encode($vo["elementtitle_varchar"]).','; $listkey = $listkey . $vo["elementid_int"] . ','; } $listkey = explode(',', rtrim($listkey, ',')); $jsonstr = $jsonstr . $jsonstrtemp . utf2gb('提交时间') . "\n"; $jsonstrtemp = ''; foreach ($_scenedatadetail_list as $vo2) { $tempjson = json_decode($vo2["content_varchar"], true); $jsonstrtemp = $jsonstrtemp; foreach ($listkey as $vo3) { $jsonstrtemp = $jsonstrtemp . utf2gb($tempjson['eq']['f_' . $vo3]) . ','; } $jsonstrtemp = $jsonstrtemp . $vo2['createtime_time'] . "\n"; } $jsonstr = $jsonstr . $jsonstrtemp; \Think\Log::write('excel' . $jsonstr); $filename = '我的场景数据-' . date('YmdHis') . ".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'); exit($jsonstr); }
public function exp() { $where['user_id'] = intval(session("userid")); $_scene_list = M('customer')->where($where)->order('createTime desc')->select(); $_scene_count = M('customer')->where($where)->count(); $data = ',,,,,,,,,,,,' . utf2gb('技术支持 By <a href="http://e.wesambo.com">一秀</a>') . ',' . "\n"; $data .= ',total:' . $_scene_count . ',,,,,,,,,,,,' . "\n"; $data .= utf2gb('姓名') . ',' . utf2gb('性别') . ',' . utf2gb('手机') . ',' . utf2gb('邮箱') . ',' . utf2gb('公司') . ',' . utf2gb('职务') . ',' . utf2gb('固定电话') . ',' . utf2gb('地址') . ',' . utf2gb('网址') . ',' . utf2gb('QQ号') . ',' . utf2gb('微信号') . ',' . utf2gb('易信号') . ',' . utf2gb('来往号') . ',' . utf2gb('其它') . '' . "\n"; foreach ($_scene_list as $m_info) { $data .= utf2gb($m_info['name']) . ',' . utf2gb($m_info['sex']) . ',' . utf2gb($m_info['mobile']) . ',' . utf2gb($m_info['email']) . ',' . utf2gb($m_info['company']) . ',' . utf2gb($m_info['job']) . ',' . utf2gb($m_info['tel']) . ',' . utf2gb($m_info['address']) . ',' . utf2gb($m_info['website']) . ',' . utf2gb($m_info['qq']) . ',' . utf2gb($m_info['weixin']) . ',' . utf2gb($m_info['yixin']) . ',' . utf2gb($m_info['laiwang']) . ',' . utf2gb($m_info['remark']) . "\n"; } $filename = '我的客户-' . date('YmdHis') . ".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'); exit($data); }