从数据库获取数据以Json格式返回前端数据可视化方式显示,效果如下
1. 在view.py文件中,将json对象需要做处理
import json
def echart(request):json_list = []for i in ret:json_dict = {}json_dict["id"] = i.idjson_dict["totalIncome"] = i.totalIncomejson_dict["dayIncome"] = i.dayIncomejson_dict["remarkIncome"] = i.remarkIncomejson_dict["totalBath"] = i.totalBathjson_dict["totalBathHouse"] = i.totalBathHousejson_dict["totalHouse"] = i.totalHousejson_dict["totalPay"] = i.totalPayjson_list.append(json_dict)return render(request,'echart.html',{"ret": json.dumps(ret1)})
2. 前端接口来着django后端传过来的json,需要再做处理