datagrid导出数据

//导出excel
    public function touzi_doExport() {
        $search=$_POST['search'];　　//接受前端传过来的数据
 8         $this->success(U('Tongji/touzi_doExport_action',$search));　　//传值
    }

public function touzi_doExport_action() {
        $search=$_GET;　　//接收数据

        $where=array();
        $starttime=$search['starttime'];
        $endtime=$search['endtime'];
        unset($search['starttime']);
        unset($search['endtime']);
        $jxstarttime=$search['jxstarttime'];
        $jxendtime=$search['jxendtime'];
        unset($search['jxstarttime']);
        unset($search['jxendtime']);
        if (session('roleid')==8) {//理财经理
            $search['managerid']=session('userid');
        } else {
            $ids=A('Index')->public_checkBranchid($search['branchid']);
            if ($ids) {
                $where[]="Users.branchid IN (".implode(",",$ids).")";
                unset($search['branchid']);
            }
        }
        foreach ($search as $k=>$v){//迭代获取
            if(!$v) continue;
            $where[] = "{$k} = '{$v}'";
        }
        if ($starttime) {
            $where[] = "Tenderlist.dateline >= ".$starttime;
            if ($endtime) {
                $endtime=strtotime("+1 day",$endtime);
                $where[] = "Tenderlist.dateline <= ".$endtime;
            }
        }
        if ($jxstarttime) {
            $where[] = "Loanlist.startpaytime >= ".$jxstarttime;
            if ($jxendtime) {
                //$jxendtime=strtotime("+1 day",$jxendtime);
                $where[] = "Loanlist.startpaytime <= ".$jxendtime;
            }
        }
        $where[] = "Loanlist.status!='failed'";
        $where=implode(" and ", $where);

        $tenderlist=D('Tenderlist2View');
        $list=$tenderlist->where($where)->select();
        if ($list) {
            foreach ($list as $key=>$val) {
                if ($val['adminrealname']) {
                    $list[$key]['adminrealname']=$val['adminrealname']."(".$val['adminname'].")";
                } else {
                    $list[$key]['adminrealname']='无';
                }
                if ($val['isfailed']) {
                    $list[$key]['isfailed']='是';
                } else {
                    $list[$key]['isfailed']='否';
                }
                //$list[$key]['crediturl']=getGrade(totalCredit($val));
                $list[$key]['money']=moneyTrans($list[$key]['money']);
                $list[$key]['paiedmoney']=moneyTrans($list[$key]['paiedmoney']);
                $list[$key]['earnmoney']=moneyTrans($list[$key]['earnmoney']);
                $list[$key]['dateline']=date('Y-m-d H:i:s',$list[$key]['dateline']);
                $list[$key]['startpaytime']=date('Y-m-d H:i:s',$list[$key]['startpaytime']);
                $list[$key]['lasttime']=date('Y-m-d H:i:s',strtotime("+".$val['loanterm']." month",$val['startpaytime']));
            }
        }

　　　　　　//本方法以上所有步骤，都是为了从数据库获得数据：$list

　　　　　//以下两行，固定方式，语法。输出。

        $list=keysortExcel($list,array('loanid','loanname','branchname','nickname','adminrealname','loanterm','money','paiedmoney','earnmoney','status','isfailed','dateline','startpaytime','lasttime'));
        exportexcel($list,array('标的ID','贷款名称','所属地区','投标用户','理财经理','借款期限','投标金额','已偿还金额','已赚取金额','投标方式','是否流标','投标日期','计息日期','截止日期'),'投资业务统计-'.time());
    }

前台传入数据：

function doExportt(id)
{
    var id = id;    
    $.post('<{:U('Tongji/index_edit_doExport')}>',{id:id}, function(res){
            if(!res.status){
                $.messager.alert('提示信息', res.info, 'error');
            }else{
                 window.open(res.info,'_blank');
            }
    }, 'json');
}

其中，{id:id}，是 post 传过去的数据