def raceRaceSettingInfo(request): ''' api to get race setting info fograce : 会长姓名,鸽会名称 : query from fogboss and fogorg by "orgid" 赛程名称 : "scheduleid" from fogschedule 比赛名称 : "racetitle" 比赛时间 : "time" 轨迹点合法日期-起始 : "starttime" 轨迹点合法日期-结束 : "endtime" 参赛鸽主人数 : count(*) from fogownner 参赛鸽数 : count(*) from fogdove 参赛鸽舍数 : count(distinct(dovecoteid)) from fogdove 放飞地:"releaseposition" 归返地:"arrivalposition" 备注:"note" Parameters: Returns: raceinfo: 基本资料: 会长姓名,鸽会名称,赛程名称,比赛名称,比赛时间, 轨迹点合法日期-起始,轨迹点合法日期-结束, 参赛鸽主人数,参赛鸽数,参赛鸽舍数,放飞地,归返地,备注 ''' if request.method == 'POST': raceInfo = { "bossname":"","orgname":"","schedulename":"","racetitle":"","time":"", "starttime":"","endtime":"", "ownerCount":"","doveCount":"","doveCoteCount":"","releaseposition":"","arrivalposition":"","note":"" } tmpraceInfo = Fograce.objects.values_list("orgid","scheduleid","racetitle","time","starttime","endtime","releaseposition","arrivalposition","note")[0] # print(tmpraceInfo) if len(tmpraceInfo) == 0 : return JsonResponse({'raceInfo':''}) (orgid,scheduleid,racetitle,time,starttime,endtime,releaseposition,arrivalposition,note) = tmpraceInfo # print(orgid,scheduleid,racetitle,time,starttime,endtime,releaseposition,arrivalposition,note) bossid,orgname = Fogorg.objects.filter(orgid=orgid).values_list("bossid","orgname")[0] # print(bossid,orgname) bossname = Fogboss.objects.filter(bossid=bossid).values_list("name")[0][0] # print(bossname) schedulename = Fogschedule.objects.filter(scheduleid=scheduleid).values_list("scheduletitle")[0][0] # print(schedulename) ownerCount = Fogowner.objects.count() # print(ownerCount) doveCount = Fogdove.objects.count() # print(doveCount) doveCoteCount = Fogdove.objects.values('dovecoteid').distinct().count() # print(doveCoteCount) raceInfo["bossname"]=bossname raceInfo["orgname"]=orgname raceInfo["schedulename"]=schedulename raceInfo["racetitle"]=racetitle raceInfo["time"]=time raceInfo["starttime"]=starttime # print(raceInfo) raceInfo["endtime"]=endtime raceInfo["ownerCount"]=ownerCount raceInfo["doveCount"]=doveCount raceInfo["doveCoteCount"]=doveCoteCount raceInfo["releaseposition"]=releaseposition raceInfo["arrivalposition"]=arrivalposition raceInfo["note"]=note # print(raceInfo) return JsonResponse({'raceInfo':raceInfo})