mainss.py

from flask import Flask, render_template,redirect,request,url_for,session, json
from flask_sqlalchemy import SQLAlchemy
from datetime import datetime
from plotregions import regionsplots,generate_origheatmapindex,generate_origheatmap,generate_predheatmap,wholeregion,deathindia,casesindia,generate_predheatmapindex
import numpy as np
import pyzbar.pyzbar as pyzbar
import cv2

app = Flask(__name__)

SQLALCHEMY_COMMIT_ON_TEARDOWN = True
#bas yahi likhna h
app.config['SQLALCHEMY_DATABASE_URI'] = "mysql://root:root@localhost:3307/covid"
db = SQLAlchemy(app)

class adminregister(db.Model):
    
    username = db.Column(db.String(20), nullable=False,primary_key=True)
    password = db.Column(db.String(20), nullable=False)

class users(db.Model):
    
    username = db.Column(db.String(20), nullable=False,primary_key=True)
    phone=db.Column(db.String(20), nullable=False)
    password = db.Column(db.String(20), nullable=False)

class volunteerlist(db.Model):
        
    username = db.Column(db.String(20), nullable=True)
    email=db.Column(db.String(20), nullable=False)
    address=db.Column(db.String(20), nullable=False)
    phone = db.Column(db.String(20), nullable=False,primary_key=True)
    choice1=db.Column(db.String(20), nullable=False)
    choice2 = db.Column(db.String(20), nullable=False)
    choice3=db.Column(db.String(20), nullable=False)
    field = db.Column(db.String(20), nullable=False)
    idcard=db.Column(db.String(20), nullable=False)

class donors(db.Model):
        
    username = db.Column(db.String(20), nullable=True)
    age=db.Column(db.String(20), nullable=False)
    address=db.Column(db.String(20), nullable=False)
    phone = db.Column(db.String(20), nullable=False,primary_key=True)
    bloodgroup=db.Column(db.String(20), nullable=False)
    weight = db.Column(db.String(20), nullable=False)
    gender=db.Column(db.String(20), nullable=False)
    


@app.route("/")
def home():
    generate_predheatmapindex()
    generate_origheatmapindex()
    casesindia()
    deathindia()
    regionsplots()
    wholeregion()
    generate_origheatmap()
    generate_predheatmap()
    return render_template('index.html')

@app.route("/about")
def about():
    return render_template('about.html')

@app.route("/contact")
def contact():
    return render_template('contact.html')

@app.route("/login",methods=["GET", "POST"])
def login():
    if request.method == "POST":
        username = request.form["username"]
        password = request.form["password"]
        
        login = users.query.filter_by(username=username, password=password).first()
        if login is not None:
            return redirect(url_for("crosslist"))
    return render_template("user_login.html")

@app.route("/register", methods=["GET", "POST"])
def register():
    if request.method == "POST":
        username = request.form['username']
        phone = request.form['phone']
        password = request.form['password']
        register = users(username = username, phone=phone, password = password)
        db.session.add(register)
        db.session.commit()

        return redirect(url_for("login"))

    return render_template("register.html")



@app.route('/adminlogin')
def adminlogin(): 
    return render_template("admin_login.html")


@app.route('/admin')
def admin(): 
    return render_template("adminPage.html")


@app.route('/mumbai')
def mumbai():
    query1 = volunteerlist.query.filter_by(choice1 = 'Mumbai').all()
    l1 = [i for i in query1]
    q = len(l1) 
    if q<2:
        query2 = volunteerlist.query.filter_by(choice2 = 'Mumbai').limit(2-q).all()
        l2 = [i for i in query2]
        for i in l2:
            l1.append(i)

    if len(l1) < 2:
        query3 = volunteerlist.query.filter_by(choice3 = 'Mumbai').limit(2-len(l1)).all()
        l3 = [i for i in query3]
        for i in l3:
            l1.append(i)
            
    avg = len(l1) / 3
    out = []
    last = 0.0
    while last < len(l1):
        out.append(l1[int(last):int(last + avg)])
        last += avg

    
    morning = out[0] #slot1
    afternoon = out[1] #slot2
    evening = out[2] #slot3 
    
    
    return json.dumps(morning)

@app.route('/mulund')
def mulund(): 
    return render_template("mulund.html")


@app.route('/khar')
def khar(): 
    return render_template("khar.html")


@app.route('/hospitals')
def hospitals(): 
    return render_template("hospitals.html")



@app.route("/checkadmin",methods = ['GET', 'POST'])
def checkadmin():
	if request.method == 'POST':
		username = request.form["username"]
		password = request.form["password"]
		login = adminregister.query.filter_by(username=username, password=password).first()
		if login is not None:
			return redirect(url_for("admin"))
	return render_template('adminlogin')

@app.route("/user")
def user():
    return render_template('user.html')

@app.route("/crosslist")
def crosslist():
    return render_template('crosslist.html')

@app.route("/total")
def total():
    return render_template('total.html')


@app.route("/yodha")
def yodha():
    return render_template('yodha.html')

@app.route("/vol")
def volunteerform():
    return render_template('vol.html')



@app.route("/reg_volunteer",methods = ['GET', 'POST'])
def volunteer():
    if request.method == 'POST':
        username = request.form["username"]
        email = request.form["email"]
        address=request.form["address"]
        phone = request.form["phone"]
        choice1=request.form["choice1"]
        choice2 = request.form["choice2"]
        choice3=request.form["choice3"]
        field = request.form["field"]
        idcard=request.files["idcard"]
  
        

		image = cv2.imread(idcard)

		decodedObjects = pyzbar.decode(image)
		for obj in decodedObjects:
		    print("Type:", obj.type)
		    print("Data: ", obj.data, "\n")
		   
		n=str(obj.data)

		n=n.split(" ")
		n[1]=n[1].replace('n=',"")
		n[2]
		print(n[1],n[2])

        register = volunteerlist(username=username,email=email,address=address,phone=phone,choice1=choice1,choice2=choice2,choice3=choice3,field=field,idcard=idcard.read())
        db.session.add(register)
        db.session.commit()

        return redirect(url_for("user"))
    

    return render_template("vol")

@app.route("/reg_donor",methods = ['GET', 'POST'])
def blooddonor():
    if request.method == 'POST':
        username = request.form["username"]
        age = request.form["age"]
        address=request.form["address"]
        phone = request.form["phone"]
        weight=request.form["weight"]
        bloodgroup = request.form["bloodgroup"]
        gender=request.form["gender"]
        
        register = donors(username=username,age=age,address=address,phone=phone,weight=weight,bloodgroup=bloodgroup,gender=gender)
        db.session.add(register)
        db.session.commit()

        return redirect(url_for("user"))

    return render_template("bloodform")



@app.route("/bloodform")
def bloodform():
    return render_template('blood.html')
@app.route("/donate")
def donate():
    return render_template('donate.html')




app.run(debug=True,port=4848)