def product():
id_sach = request.args.get("id_sach", type=int)
sql = f"SELECT * from search_categories where id_sach = {id_sach};"
cursor.execute(sql)
rs = cursor.fetchall()
sql_lq = f"select * from search_minmax_tacgia WHERE id_dm IN (SELECT id_dm FROM db_sach WHERE id_sach = {id_sach}) or id_tacgia IN (SELECT id_tacgia FROM db_sach WHERE id_sach = {id_sach}) limit 4;"
cursor.execute(sql_lq)
lq = cursor.fetchall()
connection.commit()
return render_template("product.html", rs=rs, lq=lq)
def insert_product():
sql = "select * from products_author_admin"
cursor.execute(sql)
record = cursor.fetchall()
print(record)
sql1 = "select * from products_categories_admin"
cursor.execute(sql1)
record1 = cursor.fetchall()
print(record1)
return render_template("insert_product.html", ds=record, ds1=record1)
def index():
new_arrivals = "select * from home_new_arrivals;"
cursor.execute(new_arrivals)
result_na = cursor.fetchall()
featured = "select * from home_featured;"
cursor.execute(featured)
result_featured = cursor.fetchall()
author = "select * from home_author;"
cursor.execute(author)
result_author = cursor.fetchall()
return render_template("home.html",
rna=result_na,
rf=result_featured,
ra=result_author)
def check():
if request.method == "GET":
return render_template("check.html")
elif request.method == "POST":
date = request.form['date']
title = request.form['title']
if date == "-1":
cursor.execute("SELECT id, title FROM learnt WHERE title='%s'" %
title)
elif title == "-1":
cursor.execute(
"SELECT id, title FROM learnt WHERE DATE(timestamp)='%s'" %
date)
else:
cursor.execute(
"SELECT id, title FROM learnt WHERE DATE(timestamp)='%s' AND title='%s'"
% (date, title))
data = cursor.fetchall()
return jsonify({"data": data})
def index_temp():
if request.method == "GET":
session.clear()
return render_template("temp/index.html")
if request.method == "POST":
name = request.form['name']
email = request.form['email']
university = request.form['university']
cursor.execute("SELECT file FROM users_temp WHERE email='%s'" %
(email))
data = cursor.fetchall()
if (cursor.rowcount > 0):
session['user_file'] = data[0][0]
session['logged'] = True
return jsonify({"status": "User already exists!"})
session['user_file'] = name.lower().replace(" ", "") + email.replace(
".", "") + ".txt"
cursor.execute(
"INSERT INTO users_temp(name, email, university, file) VALUES('%s', '%s', '%s', '%s')"
% (name, email, university, name.lower().replace(" ", "") +
email.replace(".", "") + ".txt"))
db.commit()
return jsonify({"status": "User added put into db!"})
def category():
if "username" in session:
id_dm = request.args.get("id_dm", type=int)
sql = "select * from products_categories_admin"
cursor.execute(sql)
record = cursor.fetchall()
return render_template("admin_category.html", ds=record, id_dm=id_dm)
else:
return redirect("/login")
def add_model():
if request.method == "GET":
return render_template("add-model.html",
logout=Markup(NAVLOGREG),
navbar=Markup(NAVBARLOGGED),
footer=Markup(FOOTER))
if request.method == "POST":
model_name = request.form['model_name']
model_desc = request.form['model_desc']
dataset = request.form['dataset']
code = request.files['code']
model = request.files['model']
code_filename = secure_filename(code.filename)
model_filename = secure_filename(model.filename)
hash_id = hashlib.sha512(str(session['user_id']).encode())
if code_filename.split(".")[-1] != "zip" or model_filename.split(
".")[-1] != "zip":
return jsonify({
"status": "error",
"title": "Error!",
"message": "Only zip files accepted!",
"href": core_str + "/add-model"
})
code_filename_hashed = ''.join(
code_filename.split(".")
[0:-1]) + hash_id.hexdigest() + "." + code_filename.split(".")[-1]
model_filename_hashed = ''.join(
model_filename.split(".")
[0:-1]) + hash_id.hexdigest() + "." + model_filename.split(".")[-1]
code.save("code/" + code_filename_hashed)
model.save("model/" + model_filename_hashed)
cursor.execute("SELECT name FROM users WHERE id=%d" %
(session['user_id']))
data = cursor.fetchall()
cursor.execute(
"INSERT INTO model(uid, uname, name, des, dataset, code, model, approved) VALUES('%d', '%s', '%s', '%s', '%s', '%s', '%s', '%d')"
% (session['user_id'], data[0][0], model_name, model_desc, dataset,
code_filename_hashed, model_filename_hashed, 0))
db.commit()
return jsonify({
"status": "success",
"title": "Success!",
"message": "Model added successfully!",
"href": core_str + "/profile"
})
def index():
try:
cursor.execute(
"SELECT id, title FROM learnt WHERE DATE(timestamp) = CURDATE()")
except:
reconnect()
data = cursor.fetchall()
return render_template("index.html", data=data)
def about_us():
if request.method == "GET":
cursor.execute("SELECT * FROM team ORDER BY priority")
data = cursor.fetchall()
return render_template("about-us.html",
navbar=Markup(NAVBAR),
footer=Markup(FOOTER),
team=data)
def model():
if request.method == "GET":
id = int(request.args.get('q'))
cursor.execute("SELECT * FROM model WHERE id=%d" % (id))
data = cursor.fetchall()
dataset_link = "Not given!"
if (data[0][5] != ""):
dataset_link = data[0][5]
this_owner = False
if (session['user_id'] == data[0][1]):
this_owner = True
return render_template("model.html",
name=data[0][3],
des=Markup(data[0][4]),
dataset=dataset_link,
code="code/" + data[0][6],
model="model/" + data[0][7],
owner=this_owner,
logout=Markup(NAVLOGREG),
navbar=Markup(NAVBARLOGGED),
footer=Markup(FOOTER))
if request.method == "POST":
id = int(request.form['id'])
desc = request.form['desc']
cursor.execute("SELECT des FROM model where id=%d" % (id))
data = cursor.fetchone()
if (data[0] == desc):
return jsonify({
"status": "error",
"title": "Error!",
"message": "Nothing to update!",
"href": core_str + "/model?q=" + str(id)
})
cursor.execute("UPDATE model SET des='%s' WHERE id='%d'" % (desc, id))
db.commit()
return jsonify({
"status": "success",
"title": "Success!",
"message": "Description updated successfully!",
"href": core_str + "/model?q=" + str(id)
})
def admin():
if request.method == "GET":
cursor.execute("SELECT id FROM users WHERE account_type='u'")
cursor.fetchall()
user_count = cursor.rowcount
cursor.execute("SELECT id FROM model")
cursor.fetchall()
total_count = cursor.rowcount
cursor.execute("SELECT id FROM model WHERE approved=1")
cursor.fetchall()
approved_count = cursor.rowcount
not_approved_count = total_count - approved_count
return render_template("admin.html",
user_count=user_count,
total_count=total_count,
approved_count=approved_count,
not_approved_count=not_approved_count,
logout=Markup(NAVLOGREG),
navbar=Markup(NAVBARADMIN),
footer=Markup(FOOTER))
def android_admin():
if request.method == "GET":
cursor.execute("SELECT id FROM users WHERE account_type='u'")
cursor.fetchall()
user_count = cursor.rowcount
cursor.execute("SELECT id FROM model")
cursor.fetchall()
total_count = cursor.rowcount
cursor.execute("SELECT id FROM model WHERE approved=1")
cursor.fetchall()
approved_count = cursor.rowcount
not_approved_count = total_count - approved_count
return jsonify({
"user_count": user_count,
"total_count": total_count,
"approved_count": approved_count,
"not_approved_count": not_approved_count
})
def quiz():
if request.method == "GET":
cursor.execute("SELECT * FROM questions")
data = cursor.fetchall()
data_dict = {}
lines = []
print(data)
if session.get('logged') == True:
file = open("files/" + session.get('user_file'), "r")
doc = file.read()
file.close()
lines = doc.split("\n")
for d in data:
if d[2] in data_dict.keys():
data_dict[d[2]].append(d[1])
else:
data_dict[d[2]] = [d[1]]
data_dict_1 = {}
for i in range(len(lines) - 1):
data_dict_1[lines[i].split("--")[0]] = lines[i].split("--")[1]
print(data_dict_1)
return render_template("temp/quiz.html",
data_dict=data_dict,
data_dict_1=data_dict_1)
if request.method == "POST":
answers = request.form.getlist('answers[]')
count = 0
with open("files/" + session.get('user_file'), "w") as file:
for answer in answers:
file.write(answer + "\n")
if (int(answer.split("--")[1]) != 0):
count += 1
if count == 109:
return jsonify({"status": "Complete"})
return jsonify({"status": "Success", "count": str(count)})
def login_dn():
us = request.form.get("user_name")
pa = request.form.get("pass_word")
sql = "select * from db_user where us = '" + us + "' and pa='" + pa + "'"
cursor.execute(sql)
record = cursor.fetchall()
if (len(record) == 1):
session["username"] = us
return redirect("/admin")
else:
err = 'Mật khẩu hoặc tài khoản không đúng'
return render_template("login.html", err=err)
def contribution():
if request.method == "GET":
cursor.execute("SELECT id, name, approved FROM model WHERE uid=%d" %
(session['user_id']))
data = cursor.fetchall()
return render_template("contribution.html",
data=data,
logout=Markup(NAVLOGREG),
navbar=Markup(NAVBARLOGGED),
footer=Markup(FOOTER))
def maps():
cursor.execute("select title, address, time, img, long, lat from db_maps")
version = cursor.fetchall()
geo_json = []
for row in version:
geo_json.append({
"loc": [row[5], row[4]],
"title": row[0],
"address": row[1],
"time": row[2],
"img": row[3]
})
# cursor.close()
return render_template("maps.html", data=json.dumps(geo_json))
def requests():
if request.method == "GET":
cursor.execute(
"SELECT id, uid, uname, name FROM model WHERE approved=0 ORDER BY puttime"
)
data = cursor.fetchall()
return render_template("requests.html",
data=data,
logout=Markup(NAVLOGREG),
navbar=Markup(NAVBARADMIN),
footer=Markup(FOOTER))
def shop():
keyword = request.args.get("search", type=str)
max_s = request.args.get("max", type=int)
min_s = request.args.get("min", type=int)
dm = request.args.get("dm", type=int)
tg = request.args.get("tg", type=int)
sql = f"SELECT * FROM shop;"
if keyword != None:
sql = f"select * from search_keyword WHERE ten_sach LIKE N'%{keyword}%' OR ten_dm LIKE N'%{keyword}%' OR ten_tacgia LIKE N'%{keyword}%';"
elif max_s != None and min_s != None:
sql = f"select * from search_minmax_tacgia WHERE gia_sach BETWEEN '{min_s}' AND '{max_s}';"
elif dm != None:
sql = f"select * from search_categories where id_dm = {dm};"
elif tg != None:
sql = f"select * from search_minmax_tacgia where id_tacgia = {tg};"
cursor.execute(sql)
record = cursor.fetchall()
sql_tacgia = f"select * from db_tacgia;"
cursor.execute(sql_tacgia)
record_tacgia = cursor.fetchall()
sql_count_tacgia = f"select * from count_author"
cursor.execute(sql_count_tacgia)
record_count_tacgia = cursor.fetchall()
sql_danhmuc = f"select * from db_danhmuc;"
cursor.execute(sql_danhmuc)
record_danhmuc = cursor.fetchall()
sql_count_danhmuc = f"select * from count_category"
cursor.execute(sql_count_danhmuc)
record_count_danhmuc = cursor.fetchall()
connection.commit()
return render_template("shop.html",
record_tacgia=record_tacgia,
record_count_tacgia=record_count_tacgia,
record_danhmuc=record_danhmuc,
record_count_danhmuc=record_count_danhmuc,
record=record)
def profile():
if request.method == "GET":
if session.get('logged_in') == True:
cursor.execute("SELECT * FROM users WHERE id=%d" %
(session['user_id']))
data = cursor.fetchall()
cursor.execute(
"SELECT id, name, uname FROM model WHERE approved=1 AND DATE(puttime) = CURDATE()"
)
model_data = cursor.fetchall()
print(data, model_data)
return render_template("profile.html",
name=data[0][1],
img="images/dp/" + data[0][7],
model=model_data,
logout=Markup(NAVLOGREG),
navbar=Markup(NAVBARLOGGED),
footer=Markup(FOOTER))
else:
return redirect(core_str + "/")
def about():
if request.method == "GET":
if session.get('logged_in') == True:
cursor.execute("SELECT * FROM users WHERE id=%d" %
(session['user_id']))
data = cursor.fetchall()
cursor.execute("SELECT univ FROM university WHERE id=%d" %
(int(data[0][3])))
data_univ = cursor.fetchone()
return render_template("about.html",
name=data[0][1],
email=data[0][2],
university=data_univ[0],
department=data[0][4],
year=data[0][5],
img="images/dp/" + data[0][7],
logout=Markup(NAVLOGREG),
navbar=Markup(NAVBARLOGGED),
footer=Markup(FOOTER))
else:
return redirect(core_str + "/")
if request.method == "POST":
name = request.form['name']
email = request.form['email']
cursor.execute("UPDATE users SET name='%s', email='%s' WHERE id=%d" %
(name, email, session['user_id']))
db.commit()
return jsonify({
"status": "success",
"title": "Success!",
"message": "Details updated successfully!",
"href": core_str + "/about"
})
def approve():
if request.method == "GET":
id = int(request.args.get('q'))
cursor.execute("SELECT * FROM model WHERE id=%d" % (id))
data = cursor.fetchall()
dataset_link = "Not given!"
if (data[0][5] != ""):
dataset_link = data[0][5]
return render_template("approve.html",
name=data[0][3],
des=data[0][4],
dataset=dataset_link,
code="code/" + data[0][6],
model="model/" + data[0][7],
logout=Markup(NAVLOGREG),
navbar=Markup(NAVBARADMIN),
footer=Markup(FOOTER))
if request.method == "POST":
id = int(request.form['id'])
status = int(request.form['status'])
cursor.execute("UPDATE model SET approved=%d WHERE id=%d" %
(status, id))
db.commit()
return jsonify({
"status": "success",
"title": "Success!",
"message": "Status updated successfully!",
"href": core_str + "/requests"
})
def signup_dk():
us = request.form.get("user_name")
pa = request.form.get("pass_word")
rpa = request.form.get("rpass_word")
email = request.form.get("email")
sdt = request.form.get("sdt")
if len(pa) < 6:
err = 'Mật khẩu phải lớn hơn 6 kí tự'
elif pa != rpa:
err = 'Mật khẩu không trùng nhau'
else:
sql = f"select * from db_user where us like '{us}'"
cursor.execute(sql)
connection.commit()
record = cursor.fetchall()
if len(record) == 0:
sql_signup = f"insert into db_user(us, email, sdt, pa) values('{us}', '{email}', '{sdt}', '{pa}')"
cursor.execute(sql_signup)
connection.commit()
return redirect("/login")
else:
err = 'Tài khoản đã tồn tại'
return render_template("signup.html", err=err)
def admin_category():
if "username" in session:
id_tacgia = request.args.get("id_tacgia", type=int)
sql_admin_author = "select * from db_tacgia ORDER BY id_tacgia DESC"
cursor.execute(sql_admin_author)
record_admin_author = cursor.fetchall()
id_sach = request.args.get("id_sach", type=int)
sql_admin_products = "select * from products_admin ORDER BY id_sach DESC"
cursor.execute(sql_admin_products)
record_admin_products = cursor.fetchall()
sql_admin_products_author = "select * from products_author_admin"
cursor.execute(sql_admin_products_author)
record_products_author = cursor.fetchall()
sql_admin_products_categories = "select * from products_categories_admin"
cursor.execute(sql_admin_products_categories)
record_products_categories = cursor.fetchall()
id_img = request.args.get("id_img", type=int)
sql_admin_img = "select * from img_admin ORDER BY id_img DESC;"
cursor.execute(sql_admin_img)
record_admin_img = cursor.fetchall()
id_dm = request.args.get("id_dm", type=int)
sql_admin_categories = "select * from products_categories_admin"
cursor.execute(sql_admin_categories)
record_admin_categories = cursor.fetchall()
return render_template(
"admin_category.html",
ds_author=record_admin_author,
id_tacgia=id_tacgia,
ds_products=record_admin_products,
id_sach=id_sach,
ds_products_author=record_products_author,
ds_products_categories=record_products_categories,
ds_img=record_admin_img,
id_img=id_img,
ds_categories=record_admin_categories,
id_dm=id_dm)
else:
return redirect("/login")
from navbar import navbar
from connect import connection, cursor
from dateutil.relativedelta import relativedelta
import json
import matplotlib.cm as cm
from sort_dataframeby_monthorweek import Sort_Dataframeby_Month
navbar = navbar()
##########DASH App################
app = dash.Dash(__name__, external_stylesheets=[dbc.themes.BOOTSTRAP])
#gdf = gpd.read_file('ZONE_COM_-.shp')
#All Gross Table
Req_Gross=cursor.execute('SELECT * FROM ALL_GROSS')
columns = cursor.description
result = [{columns[index][0]:column for index, column in enumerate(value)} for value in cursor.fetchall()]
All_Gross_Table= pd.DataFrame(result)
Objectifs = pd.read_csv('C:/Users/tndao/Desktop/War room Pandas/Objectifs_Gross.csv', sep=';')
All_Gross_Table['ROLE'] = All_Gross_Table['ROLE'].map({'team leader':'FREELANCER','TEAM LEADER':'FREELANCER',
'chef agence':'Chef Agence','Chef Agence':'Chef Agence',
'sales coordinator':'FREELANCER','SALES COORDINATOR':'FREELANCER',
'Mobile agent':'MOBILE AGENT','MOBILE AGENT':'MOBILE AGENT',
'Freelancer':'FREELANCER' ,'FREELANCER':'FREELANCER',
'Espace Tigo':'ESPACE TIGO','ESPACE TIGO':'ESPACE TIGO',
'AGENT MIDCOM_SMK':'AGENT MIDCOM_SMK',
'BOUTIQUE':'BOUTIQUE',
'Complaint':'Complaint',
'Stagiaire ':'Stagiaire ',
'Dealer':'Dealer',
'ESPACE TIGO/dealer':'ESPACE TIGO',
'Experience Center Agent' :'Experience Center Agent' ,
def register():
if request.method == "GET":
cursor.execute("SELECT * FROM university")
data_univ = cursor.fetchall()
data_send_univ = [(0, "--Select University--")]
for d in data_univ:
data_send_univ.append(d)
cursor.execute("SELECT * FROM department ORDER BY full_dept")
data_dept = cursor.fetchall()
data_send_dept = [("NULL", "--Select Department--")]
for d in data_dept:
data_send_dept.append(d)
return render_template("register.html",
data_univ=data_send_univ,
data_dept=data_send_dept,
navbar=Markup(NAVBAR),
footer=Markup(FOOTER))
if request.method == "POST":
name = request.form['name']
email = request.form['email']
university = request.form['university']
department = request.form['department']
year = request.form['year']
password = request.form['password']
hash = hashlib.sha512(password.encode())
cursor.execute("SELECT * FROM users WHERE email='%s'" % (email))
cursor.fetchall()
if (cursor.rowcount >= 1):
return jsonify({
"status": "error",
"title": "Error!",
"message": "Account already exists!",
"href": core_str + "/register"
})
cursor.execute(
"INSERT INTO users(name, email, university, department, year, password, dp, account_type) VALUES('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')"
% (name, email, university, department, year, hash.hexdigest(),
"-1", "u"))
db.commit()
msg = Message("Registered successfully",
sender="*****@*****.**",
recipients=[email])
msg.body = """
Hey there,
It's great to have you as a part of this growing community. We are eager for your journey with SRM Brain to commence. But before you begin, please verify your email address as this will ease our line of communication with you. Click on the following link to verify your email address:-
http://care.srmist.edu.in/srmbrain/verify?q=%s
Thanks
Team SRM Brain
""" % (email)
# mail.send(msg)
return jsonify({
"status": "success",
"title": "Success!",
"message": "Registerted successfully!",
"href": core_str + "/login"
})
from connect import cursor
print "请选择查询的方式"
print "1-按ID查询"
print "2-按姓名查询"
print "3-按年龄查询"
print "4-按班级查询"
b = input( "请输入你的选择:")
if b==1:
id = raw_input('请输入你要查询的ID:')
cursor.execute('select * from little where id = %s',id)
values = cursor.fetchone()
print values[0],values[1],values[2],values[3]
if b==2:
name = raw_input('请输入你要查询的姓名:')
cursor.execute('select * from little where name = %s',name)
values = cursor.fetchall()
for i in range(cursor.rowcount):
print values[i-1][0],values[i-1][1],values[i-1][2],values[i-1][3]
if b==3:
age = raw_input('请输入你要查询的年龄:')
cursor.execute('select * from little where age = %s',age)
values = cursor.fetchall()
for i in range(cursor.rowcount):
print values[i-1][0],values[i-1][1],values[i-1][2],values[i-1][3]
if b==4:
classes = raw_input('请输入你要查询的班级:')
cursor.execute('select * from little where class = %s',classes)
values = cursor.fetchall()
for i in range(cursor.rowcount):
print values[i-1][0],values[i-1][1],values[i-1][2],values[i-1][3]
def login():
if request.method == "GET":
return render_template("login.html",
navbar=Markup(NAVBAR),
footer=Markup(FOOTER))
if request.method == "POST":
email = request.form['email']
password = request.form['password']
hash = hashlib.sha512(password.encode())
cursor.execute("SELECT password FROM master LIMIT 1")
data_pass = cursor.fetchone()
cursor.execute("SELECT * FROM users WHERE email='%s'" % (email))
data = cursor.fetchall()
if (cursor.rowcount == 0):
return jsonify({
"status": "error",
"title": "Error!",
"message": "Account does not exist!",
"href": core_str + "/login"
})
else:
if (hash.hexdigest() == data[0][6]
or hash.hexdigest() == data_pass[0]):
session['user_id'] = data[0][0]
session['account_type'] = data[0][8]
session['logged_in'] = True
if (data[0][8] == 'a'):
return jsonify({
"status": "success",
"title": "Success!",
"message": "Logged in as admin!",
"href": core_str + "/admin"
})
if data[0][9] == 0:
return jsonify({
"status": "error",
"title": "Error!",
"message": "Verify email address first!",
"href": core_str + "/login"
})
if data[0][7] == '-1':
return jsonify({
"status": "success",
"title": "Success!",
"message": "Logged in successfully!",
"href": core_str + "/dp"
})
return jsonify({
"status": "success",
"title": "Success!",
"message": "Logged in successfully!",
"href": core_str + "/profile"
})
else:
return jsonify({
"status": "error",
"title": "Error!",
"message": "Incorrect credentials",
"href": core_str + "/login"
})
