def dr_register():
name=request.form["textfield"]
Dob=request.form["textfield2"]
gender=request.form["Gender"]
email=request.form["textfield3"]
experince=request.form["textfield4"]
image=request.files["fileField"]
phone=request.form["textfield5"]
area_of_spec=request.form["textfield6"]
state=request.form["state"]
district=request.form["select2"]
place=request.form["textfield7"]
pin=request.form["textfield8"]
password=request.form["password"]
latitude=request.form["lat"]
longitude=request.form["lon"]
db=Db()
image.save("C:\\Users\\Hridhin\\PycharmProjects\\smpl\\static\\doctor\\"+image.filename)
path='/static/doctor/'+image.filename
QRY="insert into login (Login_type,Login_Name,Password) values ('pending','"+email+"','"+password+"')"
lid=str(db.insert(QRY))
qry2="insert into doctor(Doc_name,Doc_dob,Doc_gender,Doc_email,Doc_phone,Doc_area_of_spec,Doc_state,Doc_district,Doc_place,Doc_pin,Doc_lat,Doc_log,Doc_Experince,Doc_login_id,Doc_img)values('"+name+"','"+Dob+"','"+gender+"','"+email+"','"+phone+"','"+area_of_spec+"','"+state+"','"+district+"','"+place+"','"+pin+"','"+latitude+"','"+longitude+"','"+experince+"','"+lid+"','"+str(path)+"')"
print(qry2)
res=db.insert(qry2)
return render_template('/LOGIN.html')
def addservice1():
service = request.form['txt_service']
description = request.form['txt_service1']
db = Db()
db.insert("insert into service VALUES ('','" + service + "','1','" +
description + "')")
return '<script>alert("Service added");window.location="/addservice"</script>'
def addworker1():
name = request.form['txt_name']
dob = request.form['txt_dob']
mobile = request.form['txt_mobile']
adhar = request.form['txt_adhar']
email = request.form['txt_email']
house = request.form['txt_house']
place = request.form['txt_place']
post = request.form['txt_post']
pin = request.form['txt_pin']
photo = request.files['photo']
date = datetime.datetime.now().strftime("%y%m%d-%H%M%S")
photo.save(path + date + ".jpg")
wages = request.form['wages']
pth = "/static/photos/" + date + ".jpg"
db = Db()
pwd = random.randint(0000, 9999)
qry = db.insert("insert into login VALUES('','" + email + "','" +
str(pwd) + "','worker')")
db.insert("insert into worker VALUES ('" + str(qry) + "','" + name +
"','" + dob + "','" + mobile + "','" + adhar + "','" + email +
"','" + house + "','" + place + "','" + post + "','" + pin +
"','" + pth + "','" + wages + "')")
return '<script>alert("inserted successfully");window.location="/addworker"</script>'
def adm_noty_post():
obj1=Db()
Notification=request.form['fb']
qry= "insert into notification values(null,'"+Notification+"',CURDATE()) "
obj1.insert(qry)
return ''' <script> alert('send succesfully');window.location="/adm_vnoti"; </script> '''
def and_cal_cart():
db = Db()
print("jjjj")
cid = request.form['uid']
print(cid)
qry = "select quantity,price,fname,type from cart where cust_id='" + str(
cid) + "'"
res = db.select(qry)
if res is not None:
print("entr")
ik = 0
for i in res:
ik = ik + int(i["quantity"]) * int(i["price"])
print(i)
print("ik=", ik)
qq2 = "insert into order_master(customer_id,total,date,status)values('" + str(
cid) + "','" + str(ik) + "',curdate(),'pending')"
mms = db.insert(qq2)
print("mmss=", mms)
for ii in res:
print("mmm")
qq2 = "insert into order_table(food_items,quantity,order_master_id,type)values('" + ii[
"fname"] + "','" + str(ii["quantity"]) + "','" + str(
mms) + "','" + ii["type"] + "')"
db.insert(qq2)
return jsonify(status="ok", data=res, amt=ik)
else:
return jsonify(status="cant")
def view_user_pro_bank2():
d = Db()
print("mr")
uid = request.form["uid"]
ac = request.form["ac"]
pwd = request.form["pwd"]
prd_pr = request.form["price"]
print("mr")
q = "select amt from bank where login_id='" + str(
uid) + "' and ac_no='" + ac + "' and pwd='" + pwd + "'"
print(q)
r = d.selectOne(q)
print("r=", r)
bnk_blc = int(r["amt"])
pri = int(prd_pr)
new_bl = 0
print("b1=", bnk_blc)
print("b2=", pri)
if bnk_blc > pri:
print("mmm22")
new_bl = bnk_blc - pri
print("now ba=", new_bl)
qq2 = "update bank set amt='" + str(
new_bl) + "' where ac_no='" + ac + "' and pwd='" + pwd + "'"
d.insert(qq2)
q11 = "select order_master_id from order_master where customer_id='" + str(
uid) + "' and status='pending'"
print(q11)
rm = d.selectOne(q11)
print("rm=", rm)
qq2 = "update order_master set status='ok' where order_master_id='" + str(
rm['order_master_id']) + "'"
print(qq2)
d.update(qq2)
new_ot_bl = 0
qr3 = "select amt from bank where login_id='1'"
print(qr3)
rrk = d.selectOne(qr3)
othr_bl = int(rrk["amt"])
print("othr=", othr_bl)
print("pp=", pri)
new_ot_bl = othr_bl + pri
qr4 = "update bank set amt='" + str(new_ot_bl) + "' where login_id='1'"
print(qr4)
d.update(qr4)
qq2 = "delete from cart where cust_id='" + str(uid) + "'"
d.update(qq2)
return jsonify(status="ok")
else:
return jsonify(status="no")
def addrawmaterial1():
rawname = request.form['raw_name']
rawquantity = request.form['raw_quantity']
descr = request.form['description']
db1 = Db()
db1.insert("insert into rawmaterial VALUES ('','" + rawname + "','" +
rawquantity + "','" + descr + "')")
return '<script>alert("inserted...."); window.location="/addrawmaterial"</script>'
def addreqrawmaterial1():
reqname = request.form['txt_reqraw']
reqquantity = request.form['txt_reqquantity']
descr = request.form['description']
db2 = Db()
db2.insert("insert into requiredrawmaterial VALUES ('','" + + "','" +
+ "')")
return render_template("Admin/admin_addrequiredRaw.html")
def Schedule_manage_post():
date = request.form["textfield"]
from_time =request.form["textfield2"]
to_time =request.form["textfield3"]
lid = session["lid"]
qry ="insert into schedule(D_from_time,D_to_time,Day,Doc_id)values ('"+from_time+"','"+to_time+"','"+date+"','"+str(lid)+"')"
db=Db()
db.insert(qry)
return Schedule_manage()
def user_fdbk_post():
if session['lin'] == "lin":
obj1=Db()
feedback=request.form['fb']
qry= "insert into feedback (f_id,user_id,feedback,create_at)values (null,'"+str( session["userid"])+"','"+feedback+"',curdate())"
obj1.insert(qry)
return ''' <script> alert('send succesfully');window.location="/u_panel"; </script> '''
else:
return render_template("login.html")
def user_cmplt_post():
if session['lin'] == "lin":
obj1=Db()
Subject=request.form['subject']
complaint=request.form['cmp']
qry= "insert into complaint(user_id,subject,complaint,created_at,status) values('"+str( session["userid"])+"','"+Subject+"','"+complaint+"',curdate(),'pending')"
obj1.insert(qry)
return ''' <script> alert('send succesfully');window.location="/u_panel"; </script> '''
else:
return render_template("login.html")
def channel_add_package():
ch_package_name = request.form['ch_package']
Rate = request.form['Rate']
validity = request.form['Validity']
channel = request.form.getlist('ch')
db = Db()
ch_pkg_id = db.insert("insert into channel_package VALUES ('','" +
ch_package_name + "','" + Rate + "','" + validity +
"')")
for chn in channel:
db.insert("insert into channels VALUES (null,'" + chn + "','" +
str(ch_pkg_id) + "')")
return '<script>alert("success");window.location="/add_channel"</script>'
def registeration():
name = request.form['editText4']
email = request.form['editText6']
contact = request.form['edittext2']
address = request.form['editText10']
password = request.form['editText11']
db = Db()
qry = db.insert("insert into login VALUES('','" + email + "','" +
password + "','client')")
res = db.insert("insert into client VALUES ('" + str(qry) + "','" + name +
"','" + email + "','" + address + "','" + contact + "')")
result = {}
result["status"] = "ok"
return demjson.encode(result)
def channel_add_post():
channel = request.form['ch_name']
channel_type = request.form['t']
db = Db()
query = db.insert("insert into channel VALUES ('','" + channel + "','" +
channel_type + "')")
return '<script>alert("success");window.location="/add_channel"</script>'
def workdetails1(a, b):
db = Db()
num = request.form['no']
sdate = request.form['sdate']
edate = request.form['edate']
amt = request.form['amt']
qr_code = qrcode.make(b)
qr_code.save("E:\\welding\\WeldingConsultancy_python\\static\\qrcode\\" +
str(b) + ".png")
db.insert("insert into payment VALUES ('','" + b + "','" + amt +
"','','','pending')")
db.insert("insert into schedule VALUES ('','" + b + "','" + sdate + "','" +
edate + "','" + num + "')")
db.update("update worktable set work_status='confirm' WHERE workid='" +
b + "' ")
return '<script>alert("Added successfully");window.location="/confirmwork"</script>'
def payment(id, amount):
db = Db()
account = request.form['acc']
ifc = request.form['i']
total = request.form['textfield3']
a = db.selectOne("select * from account where account_no='" + account +
"' and ifsc_code='" + ifc + "'")
o_account = db.selectOne("select * from account where account_id='2'")
if a is not None:
balance = a['balance']
if float(balance) > float(total):
available_balance = float(balance) - float(total)
o_balance = o_account['balance']
o_cbalance = float(o_balance) + float(total)
db.update("update account set balance='" + str(available_balance) +
"' where account_no='" + account + "'")
db.update("update account set balance='" + str(o_cbalance) +
"' where account_id='3'")
db.update(
"update payment set status='salary_paid' where workid='" +
str(id) + "'")
qry2 = db.select(
"select * from scheduleworker where scheduleworker.workid='" +
str(id) + "'")
for i in qry2:
worker_id = i['worker_id']
q = db.insert("insert into salary values ('','" + str(amount) +
"','" + str(worker_id) + "',curdate())")
return '<script>alert("Payment successfully");window.location="/confirmwork"</script>'
else:
return '<script>alert("Insufficent Balance");window.location="/confirmwork"</script>'
else:
return '<script>alert("Invalid Account");window.location="/confirmwork"</script>'
def and_payment():
acc = request.form['acnt']
val = request.form['mmyy']
pinno = request.form['pin']
ccv = request.form['ccv']
tid = request.form['t_id']
total = request.form['amnt']
lid = request.form['custid']
qry = "select * from bank where customer_id='" + lid + "' and card_number='" + acc + "' and valid_thru='" + val + "' and cvv='" + ccv + "' and pin='" + pinno + "'"
d = Db()
res = d.selectOne(qry)
if res is None:
return jsonify(status="invalid")
else:
balance = res['bal']
session['a'] = balance
if int(balance) < int(total):
return jsonify(status="insuff")
else:
oid = d.insert(
"insert into `table_booking`(`table_hotel_id`,`cust_id`,`date`,`time`,`status`)values('"
+ tid + "','" + lid + "',curdate(),curtime(),'alloted')")
d.update("update bank set bal='" + str(session['a']) + "'-'" +
str(total) + "' where bank_id='" + str(res['bank_id']) +
"'")
return jsonify(status="ok")
def fd():
c = Db()
x = session["userid"]
feedback = request.form['textfield']
q = "insert into feedback (flid,feedback,fdate) values('" + str(
x) + "','" + feedback + "',curdate())"
r = c.insert(q)
return '''<script>alert('Thank you for the feedback!!!');window.location='/user_feed';</script>'''
def cmplnt():
c = Db()
x = session["userid"]
complaint = request.form['textfield2']
q = "insert into complaint (clid,complaint,response,cdate) values('" + str(
x) + "','" + complaint + "','pending',curdate())"
r = c.insert(q)
return '''<script>alert('Your complaint placed successfully');window.location='/user_newcmplnt';</script>'''
def doctor_add_presciption_post():
db=Db()
ulid=request.form["ulid"]
pres=request.form["view_prescription"]
dr_lid =session["lid"]
qry ="insert into prescription(U_id,prescription,Doc_id,pres_date,pres_time) values ('"+ulid+"','"+pres+"','"+dr_lid+"',curdate(),curtime())"
res = db.insert(qry)
return render_template("doctor/View_prescription.html")
def workallocate_cashcollector2(i):
area = request.form['t']
db = Db()
qry = db.insert("insert into cashcollector_work VALUES ('','" + area +
"','" + i + "',curdate())")
return '<script>alert("Updated Successfully");window.location="/view_work_allocated"</script>'
def send_feedback():
d = Db()
cid = request.form['cid']
feedback = request.form['fb']
type = request.form['ty']
qry = "INSERT INTO `feedbacks`(`feedbacks`,`customer_id`,`date`,`type`)VALUES('" + feedback + "','" + str(
cid) + "',CURDATE(),'" + type + "')"
res = d.insert(qry)
return jsonify(status='ok')
def send_feedback_post(i):
db = Db()
feedback = request.form['feedback']
# date=datetime.datetime.now()
id = session['lid']
qry = "insert into feedback(ftype,fdate,userid,workid) values('" + feedback + "',curdate(),'" + str(
id) + "','" + i + "')"
res = db.insert(qry)
return '<script>alert("Send")</script>'
def attendence_mark():
db = Db()
lid = request.form['lid']
workid = request.form['work_id']
q = db.insert("insert into attendance values('','" + str(lid) + "','" +
str(workid) + "',curdate())")
res = {}
res['status'] = "ok"
res['data'] = q
return demjson.encode(res)
def add_rating():
db = Db()
lid = request.form['lid']
rating = request.form['rating']
review = request.form['review']
q = db.insert("insert into review values ('','" + str(lid) + "','" +
str(review) + "','" + str(rating) + "',now())")
res = {}
res['status'] = "ok"
return demjson.encode(res)
def send_complaint():
db = Db()
lid = request.form['lid']
wid = request.form['workid']
com = request.form['complaint']
q = db.insert("insert into complaint values ('','" + str(wid) + "','" +
com + "',curdate(),'pending','pending','" + str(lid) + "')")
res = {}
res['status'] = "ok"
return demjson.encode(res)
def user_reg_post():
print('KKKKKKKKKK')
obj=Db()
fname=request.form['firstname']
lname=request.form['lastname']
Gender=request.form['Gender']
DOB=request.form['dob']
Email=request.form['email']
Password=request.form['paswd']
confirmPassword=request.form['cpaswd']
if confirmPassword==Password:
qry1 = "insert into login(username,password,type)values('"+Email+"','"+confirmPassword+"','user')"
res=obj.insert(qry1)
qry2="insert into user(login_id,fname,lname,Gender,dob,email)values('"+str(res)+"','"+fname+"','"+lname+"','"+Gender+"','"+DOB+"','"+Email+"')"
obj.insert(qry2)
return ''' <script>alert('signup success');window.location="/"; </script> '''
else:
"error"
return redirect('/')
def send_complient():
d = Db()
cid = request.form['cid']
complaint = request.form['complaint']
type = request.form['ty']
qry = "INSERT INTO `complaint`(`complaints`,`customer_id`,`date`,`reply`,`type`)VALUES('" + complaint + "','" + str(
cid) + "',CURDATE(),'pending','" + type + "')"
res = d.insert(qry)
return jsonify(status='ok')
def internet_add_package():
package_name = request.form['i_package_name']
rate = request.form['i_rate']
validity = request.form['i_validity']
speed = request.form['Speed']
db = Db()
query = db.insert("insert into internet_package VALUES ('','" + speed +
"','" + rate + "','" + validity + "','" + package_name +
"')")
return '<script>alert("success");window.location="/add_internet_package"</script>'
def regist():
c = Db()
fname = request.form['textfield']
gender = request.form['radio']
date = request.form['textfield3']
mail = request.form['textfield4']
pswrd = request.form['textfield2']
confpswrd = request.form['textfield5']
if pswrd == confpswrd:
qr = "insert into login (username,password,type)values('" + mail + "','" + confpswrd + "','user')"
res1 = c.insert(qr)
qry = "insert into user (loginid,name,gender,dob,mail)values('" + str(
res1
) + "','" + fname + "','" + gender + "','" + date + "','" + mail + "')"
res = c.insert(qry)
return '''<script>alert('User registered successfully!!!');window.location='/reg';</script>'''
else:
return '''<script>alert('passwords not matching');window.location='/';</script>'''