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);
}
