def indiadistrictdetaildashboard(request): district1 = request.GET['name'].split(" ") statedistrict = getplace(district1).split(" ") con = m.connect(host="localhost", user="******", passwd="svasnnmsjdcfjdDFGH!5548)", database="vikas") cur = con.cursor() partition_index = 0 leng = 0 for i in range(1, 9): state = " ".join(statedistrict[:i]) district = " ".join(statedistrict[i:]) command2 = '''select * from districtdaily where state = "{}" and district ="{}" ;'''.format( state, district) cur = con.cursor() cur.execute(command2) alldata = cur.fetchall() if len(alldata) > leng: leng = len(alldata) partition_index = i state = " ".join(statedistrict[:partition_index]) district = " ".join(statedistrict[partition_index:]) subdate = Districtdaily.objects.aggregate(Max('date')) obj = [] obj.append( Districtdaily.objects.filter(district=f'{district}').filter( state=f'{state}').values('date', 'confirmed').order_by('-date')[:60:-1]) googledata = googleDataCalc(obj[0], ['date', 'Cases']) cur.execute("desc districtdaily;") headeralldata = cur.fetchall() headerdata = np.array(headeralldata) header = headerdata[0:len(headerdata), 0] command2 = '''select * from districtdaily where state ="{}" and district ="{}" order by date desc;'''.format( state, district) cur = con.cursor() cur.execute(command2) alldata = cur.fetchall() cur.close() con.close() completedatatorender = sqldataformating(alldata, header) p = summarydata(state=state, district=district) facts = getfactsdata("Districtdaily", state, district) differencedata = getdailydifference('Districtdaily', 'confirmed', 'date', fc1="state", pk1=state, fc2="district", pk2=district, orderby='-date', limit=60) nar = [] nar2 = [] for i in differencedata[1]: nar.append(int(i)) for j in differencedata[0]: nar2.append(j) dd = list(map(lambda i: list(i), list(zip(nar2, nar)))) dd.insert(0, ["Date", "New cases"]) googledata2 = json.dumps(dd, default=str) differencedata = getdailydifference('Districtdaily', 'deceased', 'date', fc1="state", pk1=state, fc2="district", pk2=district, orderby='-date', limit=60) nar = [] nar2 = [] for i in differencedata[1]: nar.append(int(i)) for j in differencedata[0]: nar2.append(j) dd = list(map(lambda i: list(i), list(zip(nar2, nar)))) dd.insert(0, ["Date", "New Deaths"]) googledata1 = json.dumps(dd, default=str) ld = Districtdaily.objects.filter(district=f'{district}').filter( state=f'{state}').values('date', 'deceased', 'recovered', 'confirmed', 'active', 'population', 'tested').order_by('-date')[:1:-1] d = ld[0]['deceased'] r = ld[0]['recovered'] c = ld[0]['confirmed'] a = ld[0]['active'] po = ld[0]['population'] te = ld[0]['tested'] stats = { 'Total cases': c, 'Active Cases': a, 'Total Deaths': d, 'Total Recovered': r } try: stats['Death Rate'] = "{:.2f}".format((d) / (d + r) * 100) except: pass try: stats['Tests per 1M Population'] = "{:.0f}".format((te) / po * 1000000) except: pass try: stats['Deaths Per 1M Population'] = "{:.2f}".format((d) / po * 1000000) except: pass adddata = {'add': 0} if district == "Jaipur" or district == "Gurugram": adddata = { "add": 1, "image": "gurgaon.jpg", 'href': "https://legacytech.in" } return render( request, 'districtdata.html', { 'data1': completedatatorender[0], 'header1': completedatatorender[1][0], 'wt': p[0], 'wd': p[1], 'it': p[2], 'id': p[3], 'd': p[4], 'facts': facts, 'googledata': googledata, 'title1': 'Total Cases', 'type1': 'area', 'xlable1': "", 'googledata2': googledata2, 'title3': 'Daily Cases', 'type3': 'line', 'xlable3': "", 'googledata1': googledata1, 'title2': 'Daily Deaths', 'type2': 'line', 'xlable2': "", 'path': ['India', state, district], 'a': p[12], 'b': p[13], 'adddata': adddata, 'stats': stats, })
def indiadistrictdashboard(request): state1 = request.GET['name'].split(" ") state = getplace(state1) commandlist = [{ "command": f"select district,confirmed from districtdaily where state like '%{state}%' and date =(select max(date) from districtdaily ) order by confirmed desc limit 15;", "xlable": "states", "ylable": "Total Confirmed Cases", "title": f"{str(state).upper()}-- TOTAL CONFIRMED CASES", "chart_type": "bar" }, { "command": f"select district,active from districtdaily where state like '%{state}%' and date =(select max(date) from districtdaily ) order by active desc limit 15;", "xlable": "Daily active Cases", "ylable": "District", "title": "TOP 15 Districts :Active Cases ", "chart_type": "barh" }] paths = [] for i in range(len(commandlist)): paths.append( makebarchart(commandlist[i]["command"], title=commandlist[i]["title"], xlable=commandlist[i]["xlable"], ylable=commandlist[i]["ylable"], filename="district" + str(i + 1), chart_type=commandlist[i]["chart_type"])) con = m.connect(host="localhost", user="******", passwd="svasnnmsjdcfjdDFGH!5548)", database="vikas") cur = con.cursor() cur.execute("desc districtdaily;") headeralldata = cur.fetchall() headerdata = np.array(headeralldata) header = headerdata[0:len(headerdata), 0] command2 = '''select * from districtdaily where state like "%{}%" and date =(select max(date) from districtdaily);'''.format( state) cur = con.cursor() cur.execute(command2) alldata = cur.fetchall() cur.close() con.close() completedatatorender = sqldataformating(alldata, header) p = summarydata(state=state) return render( request, 'district.html', { 'user_images': paths, 'data1': completedatatorender[0], 'header1': completedatatorender[1][0], 'wt': p[0], 'wd': p[1], 'it': p[2], 'id': p[3], 'd': p[4], 'path': ['India', state], 'a': p[12], 'b': p[13], })
def indiastatedashboard(request): state1 = request.GET['name'].split(" ") state = getplace(state1) con = m.connect(host="localhost", user="******", passwd="svasnnmsjdcfjdDFGH!5548)", database="vikas") cur = con.cursor() cur.execute("desc coronastatedaily;") headeralldata = cur.fetchall() headerdata = np.array(headeralldata) header = headerdata[0:len(headerdata), 0] command2 = '''select * from coronastatedaily where loc like "%{}%";'''.format( state) cur = con.cursor() cur.execute(command2) alldata = cur.fetchall() cur.close() con.close() completedatatorender = sqldataformating(alldata, header) p = summarydata(state=state) facts = getfactsdata("Coronastatedaily", state) obj = [] obj.append( Coronastatedaily.objects.filter(loc=f'{state}').values( 'date', 'totalconfirmed', 'discharged').order_by('-date')[:60:-1]) googledata = googleDataCalc(obj[0], ['Date', 'Cases', 'Recovered']) facts = getfactsdata("Coronastatedaily", state) differencedata = getdailydifference('Coronastatedaily', 'totalconfirmed', 'date', fc1="loc", pk1=state, orderby='-date', limit=60) nar = [] nar2 = [] for i in differencedata[1]: nar.append(int(i)) for j in differencedata[0]: nar2.append(j) dd = list(map(lambda i: list(i), list(zip(nar2, nar)))) dd.insert(0, ["Date", "daily cases"]) googledata1 = json.dumps(dd, default=str) differencedata = getdailydifference('Coronastatedaily', 'deaths', 'date', fc1="loc", pk1=state, orderby='-date', limit=60) nar = [] nar2 = [] for i in differencedata[1]: nar.append(int(i)) for j in differencedata[0]: nar2.append(j) dd = list(map(lambda i: list(i), list(zip(nar2, nar)))) dd.insert(0, ["Date", "daily Deaths"]) googledata2 = json.dumps(dd, default=str) ''' ld=Coronastatedaily.objects.filter(loc=f'{state}').values('date', 'deaths','discharged','totalconfirmed').order_by('-date')[:1:-1] d=ld[0]['deaths'] r=ld[0]['discharged'] c=ld[0]['totalconfirmed'] #p=ld[0]['population'] #t=ld[0]['tested'] print(d,r,c) if d==r!=0 or d!=r: stats={'Total cases':c,'Total Deaths':d,'Total Recovered':r,'Death Rate':"{:.2f}".format((d)/(d+r)*100),'Recovery Rate':"{:.2f}".format(r/(r+d)*100)} else: stats={'Total cases':c,'Total Deaths':d,'Total Recovered':r,'Death Rate':"NA",'Recovery Rate':"NA"} print(stats) return render(request, 'state.html', {'data1': completedatatorender[0], 'header1': completedatatorender[1][0], 'wt': p[0], 'wd': p[1], 'it': p[2], 'id': p[3], 'd': p[4],'facts':facts, 'googledata1':googledata1,'title2':'Daily cases','type2':'line','xlable2':"", 'googledata':googledata,'title1':'Total Cases','type1':'area','xlable1':"", 'googledata2':googledata2,'title3':'Daily Deaths','type3':'line','xlable3':"",'path':['India',state],'a':p[12],'b':p[13],'stats':stats, ''' differencedata = getdailydifference('Coronastatedaily', 'tested', 'date', fc1="loc", pk1=state, orderby='-date', limit=60) nar = [] nar2 = [] for i in differencedata[1]: nar.append(int(i)) for j in differencedata[0]: nar2.append(j) dd = list(map(lambda i: list(i), list(zip(nar2, nar)))) dd.insert(0, ["Date", "daily tests"]) googledata3 = json.dumps(dd, default=str) ld = Coronastatedaily.objects.filter(loc=f'{state}').values( 'date', 'deaths', 'discharged', 'totalconfirmed', 'population', 'tested').order_by('-date')[:1:-1] d = ld[0]['deaths'] r = ld[0]['discharged'] c = ld[0]['totalconfirmed'] po = ld[0]['population'] te = ld[0]['tested'] if d == r != 0 or d != r: stats = { 'Total cases': c, 'Total Deaths': d, 'Total Recovered': r, 'Death Rate': "{:.2f}".format((d) / (d + r) * 100), 'Recovery Rate': "{:.2f}".format(r / (r + d) * 100), 'Total Tests /1M': '{:.0f}'.format(te / po * 1000000), 'Deaths /1M Population': '{:.2f}'.format(d / po * 1000000) } else: stats = { 'Total cases': c, 'Total Deaths': d, 'Total Recovered': r, 'Death Rate': "NA", 'Recovery Rate': "NA" } print(stats) return render( request, 'state.html', { 'data1': completedatatorender[0], 'header1': completedatatorender[1][0], 'wt': p[0], 'wd': p[1], 'it': p[2], 'id': p[3], 'd': p[4], 'facts': facts, 'googledata1': googledata1, 'title2': 'Daily cases', 'type2': 'line', 'xlable2': "", 'googledata': googledata, 'title1': 'Total Cases', 'type1': 'area', 'xlable1': "", 'googledata2': googledata2, 'title3': 'Daily Deaths', 'type3': 'line', 'xlable3': "", 'path': ['India', state], 'a': p[12], 'b': p[13], 'stats': stats, 'googledata3': googledata3, 'title4': 'Daily tests', 'type4': 'line', 'xlable4': "", })
def indiadashboard(request): subdate = Coronastatedaily.objects.aggregate(Max('date')) con = m.connect(host="localhost", user="******", passwd='svasnnmsjdcfjdDFGH!5548)', database="vikas") cur = con.cursor() cur.execute("desc coronastatedaily;") headeralldata = cur.fetchall() headerdata = np.array(headeralldata) header = headerdata[0:len(headerdata), 0] command2 = '''select * from coronastatedaily where date =(select max(date) from coronastatedaily);''' cur = con.cursor() cur.execute(command2) alldata = cur.fetchall() cur.close() con.close() completedatatorender = sqldataformating(alldata, header) p = summarydata() facts = getfactsdata("Coronaworld1", "India") stats = [] stats = { '[India] Death Rate': "{:.2f}".format((p[3]) / (p[3] + p[9]) * 100), '[India] Recovery Rate': "{:.2f}".format(p[9] / (p[3] + p[9]) * 100), '[India] Cases per Million': p[11], '[World] Death Rate': "{:.2f}".format((p[1]) / (p[10] + p[1]) * 100), '[World] Recovery Rate': "{:.2f}".format(p[10] / (p[10] + p[1]) * 100), '[World] Cases per Million': "{:.0f}".format(p[0] / 6800) } obj = [] obj.append( Coronastatedaily.objects.filter(date=subdate['date__max']).values( 'loc', 'totalconfirmed', "discharged").order_by('-totalconfirmed')[:10]) obj.append( Coronastatedaily.objects.filter(date=subdate['date__max']).values( 'loc', 'deaths').order_by('-deaths')[:60]) googledata = googleDataCalc(obj[0], ["State", "Cases", "Recovered"]) googledata3 = googleDataCalc(obj[1], ["State", "Deaths"]) differencedata = getdailydifference('Coronaworld1', 'cases', 'date', fc1="country_name", pk1="India", orderby='-date', limit=60) nar = [] nar2 = [] for i in differencedata[1]: nar.append(int(i)) for j in differencedata[0]: nar2.append(j.date()) dd = list(map(lambda i: list(i), list(zip(nar2, nar)))) dd.insert(0, ["Date", "New cases"]) googledata2 = json.dumps(dd, default=str) differencedata = getdailydifference('Coronaworld1', 'deaths', 'date', fc1="country_name", pk1="India", orderby='-date', limit=60) nar = [] nar2 = [] for i in differencedata[1]: nar.append(int(i)) for j in differencedata[0]: nar2.append(j.date()) dd = list(map(lambda i: list(i), list(zip(nar2, nar)))) dd.insert(0, ["Date", "Daily Deaths"]) googledata1 = json.dumps(dd, default=str) return render( request, 'india.html', { 'data1': completedatatorender[0], 'header1': completedatatorender[1][0], 'wt': p[0], 'wd': p[1], 'it': p[2], 'id': p[3], 'd': p[4], 'facts': facts, 'stats': stats, 'googledata': googledata, 'title1': 'States with Max Cases and Recoveries', 'type1': 'bar', 'xlable1': "", 'googledata1': googledata1, 'title2': 'Daily Deaths', 'type2': 'line', 'xlable2': '', 'googledata2': googledata2, 'title3': 'Daily cases', 'type3': 'line', 'xlable3': "", 'googledata3': googledata3, 'title4': 'States with max Deaths', 'type4': 'bar', 'xlable4': '', 'path': ['India'], 'a': p[2], 'b': p[3], })
def countrydashboard(request): country1 = request.GET['name'].split(" ") country = getplace(country1) print(country) subdate = Coronaworld1.objects.aggregate(Max('date')) obj = [] obj.append( Coronaworld1.objects.filter( country_name__contains='{}'.format(country)).values( 'date', 'cases').order_by('-date')[:20:-1]) obj.append( Coronaworld1.objects.filter(date=subdate['date__max']).values( 'country_name', 'cases', 'total_recovered').order_by('-cases')[:20]) googledata = googleDataCalc(obj[0], ["Date", "Cases"]) googledata1 = googleDataCalc(obj[1], ["Country", "Cases", "Total Recovered"]) con = m.connect(host="localhost", user="******", passwd="svasnnmsjdcfjdDFGH!5548)", database="vikas") cur = con.cursor() cur.execute("desc coronaworld1;") headeralldata = cur.fetchall() headerdata = np.array(headeralldata) header = headerdata[0:len(headerdata), 0] command2 = '''select * from coronaworld1 where country_name like "%{}%" ;'''.format( country) cur = con.cursor() cur.execute(command2) alldata = cur.fetchall() cur.close() con.close() completedatatorender = sqldataformating(alldata, header) p = summarydata(country=country) differencedata = getdailydifference('Coronaworld1', 'cases', 'date', fc1="country_name", pk1=country, orderby='-date', limit=20) nar = [] nar2 = [] for i in differencedata[1]: nar.append(int(i)) for j in differencedata[0]: nar2.append(j.date()) dd = list(map(lambda i: list(i), list(zip(nar2, nar)))) dd.insert(0, ["Date", "New cases"]) googledata2 = json.dumps(dd, default=str) print(p) return render( request, 'country.html', { 'data1': completedatatorender[0], 'header1': completedatatorender[1][0], 'wt': p[0], 'wd': p[1], 'it': p[2], 'id': p[3], 'd': p[4], 'googledata': googledata, 'title1': 'Total Cases', 'type1': 'area', 'googledata1': googledata1, 'title2': 'Top countries with max cases', 'type2': 'bar', 'xlable2': 'countries', 'googledata2': googledata2, 'title3': 'Daily cases', 'type3': 'line', 'path': ['world', country], 'a': p[12], 'b': p[13], })
def home(request): subdate = Coronaworld1.objects.aggregate(Max('date')) obj = [] obj.append( Coronaworld1.objects.filter(date=subdate['date__max']).values( 'country_name', 'cases', 'total_recovered').order_by('-cases')[:20]) obj.append( Coronaworld1.objects.filter(date=subdate['date__max']).values( 'country_name', 'total_cases_per_1m_population').order_by( '-total_cases_per_1m_population')[:20]) obj.append( Coronaworld1.objects.filter(date=subdate['date__max']).values( 'country_name', 'deaths_per_1m_population').order_by( '-deaths_per_1m_population')[:20]) googledata1 = googleDataCalc(obj[0], ["Country", "Cases", "Recovered"]) googledata2 = googleDataCalc(obj[1], ["Country", "Cases / 1M"]) googledata = googleDataCalc(obj[2], ["Country", "Deaths /1M"]) con = m.connect(host="localhost", user="******", passwd="svasnnmsjdcfjdDFGH!5548)", database="vikas") cur = con.cursor() cur.execute("desc coronaworld1;") headeralldata = cur.fetchall() headerdata = np.array(headeralldata) header = headerdata[0:len(headerdata), 0] command2 = '''select * from coronaworld1 where date=(select max(date) from coronaworld1);''' cur = con.cursor() cur.execute(command2) alldata = cur.fetchall() cur.close() con.close() completedatatorender = sqldataformating(alldata, header) p = summarydata() return render( request, 'home.html', { 'data1': completedatatorender[0], 'header1': completedatatorender[1][0], 'wt': p[0], 'wd': p[1], 'it': p[2], 'id': p[3], 'd': p[4], 'googledata1': googledata1, 'title2': 'Top countries with max cases/Recoveries', 'type2': 'bar', 'xlable2': '', 'googledata2': googledata2, 'title3': 'Top countries with max cases per Million ', 'type3': 'bar', 'xlable3': '', 'googledata': googledata, 'title1': 'Top countries with max Deaths per Million ', 'type1': 'bar', 'xlable1': '', 'path': ['World'], 'a': p[0], 'b': p[1], })