window.open post

前端代码

        expExcel(){
          window.open(PreURL+'company_list_exp?keyword='+this.keyword+'&area_code='+this.form.area_code+'&industry_code'+this.form.industry_code)
        }

 

 

后端代码

后端代码实际上走的是get方法

# 企业查询
@api.route('/company_list_exp', methods=['GET', 'POST'])
def zhs_company_list_exp():
    keyword = request.args['keyword'].encode(Conf.CHAR_ENCODE)
    area_code = request.args['area_code']
    industry_code = request.args['industry_code']
    params = {
        'kewword': '%%%s%%' %keyword,
        'area_code': '%s%%' %(area_code.split(',')[-1] if area_code!='' else ''),
        'industry_code': '%s%%' %(industry_code.split(',')[-1] if industry_code!='' else '')
    }
    text_sql = "select t.tyshxydm,t.zzjgdm,t.dwxxmc,t.fddbr,t.dwszdz,t.hy from v_company t where t.dwxxmc like :kewword and t.hyfldm like :industry_code and t.dwszdqhdm like :area_code order by hy asc"
    rows = db_session.execute(text_sql, params).fetchall()
    def excelFile(rows):
        yield '统一社会信用代码,组织机构代码,单位详细名称,法定代表人（负责人）,单位注册地址,行业\n'
        for row in rows:
            yield ','.join([row.tyshxydm if row.tyshxydm else '',row.zzjgdm if row.zzjgdm else '',row.dwxxmc if row.dwxxmc else '',row.fddbr if row.fddbr else '',row.dwszdz if row.dwszdz else '',row.hy if row.hy else ''])+'\n'

    filename = '企业查询结果导出.csv'
    response = Response(excelFile(rows), mimetype='text/csv')
    response.headers["Content-Disposition"] = "attachment; filename={}".format(filename)
    return response