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(',')[-] if area_code!='' else ''),

        'industry_code': '%s%%' %(industry_code.split(',')[-] 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

前端代码

后端代码

相关文章