def updateKeywords():
userid = request.args.get('userid')
token = request.args.get('tok')
try:
if apiAuth.apiAuth(token, userid):
_req = request.json
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
cur.execute("update keywords set keywordstext=%s where keywordsid=%s", ( _req['keywords'], _req['keywordid'],))
conn.commit()
response = jsonify("success")
response.status_code = 200
return response
else:
response = jsonify("Not Authorized")
response.status_code = 401
return response
except Exception as e:
print(e)
response = jsonify("Database Error")
response.status_code = 500
return response
finally:
cur.close();
conn.close();
def getMyMoreInfo():
userid = request.args.get('userid')
token = request.args.get('tok')
serviceid = request.args.get('serviceId')
try:
if apiAuth.apiAuth(token, userid):
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
cur.execute("select * from servicecontactinfo where servicecontackfk=%s",(serviceid))
response = {"contact":cur.fetchall()}
cur.execute("select * from scheduletable where serviceId=%s",(serviceid))
response["schedule"] = cur.fetchall()
cur.execute("select * from keywords where servicekeywordsfk=%s",(serviceid))
response["keywords"] = cur.fetchall()
response = jsonify(response)
response.status_code = 200
return response
else:
response = jsonify("Not Authorized")
response.status_code = 401
return response
except Exception as e:
print(e)
response = jsonify("Database Error")
response.status_code = 500
return response
finally:
cur.close();
conn.close();
def updateServiceSchedule():
userid = request.args.get('userid')
token = request.args.get('tok')
_req = request.json
try:
if apiAuth.apiAuth(token, userid) == True:
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
scheduleid = _req['schid']
paymentid = _req['pid']
cur.execute("update scheduletable set monStart=%s, monEnd=%s, tueStart=%s, tueEnd=%s, wedStart=%s, wedEnd=%s, thurStart=%s, thurEnd=%s, friStart=%s, friEnd=%s, satStart=%s, satEnd=%s, sunStart=%s, sunEnd=%s where scheduleId=%s",
(_req['monBeg'], _req['monEnd'], _req['tueBeg'], _req['tueEnd'], _req['wedBeg'], _req['wedEnd'], _req['thurBeg'], _req['thurEnd'],
_req['friBeg'],_req['friEnd'],_req['satBeg'], _req['satEnd'], _req['sunBeg'], _req['sunEnd'], scheduleid))
conn.commit()
cur.execute("update paymentoptions set cash=%s,card=%s,onlinepayments=%s where idpaymentoptions=%s",
(_req['cash'], _req['card'], _req['digi'], paymentid))
conn.commit()
response = jsonify("success")
response.status_code = 200
return response
else:
response = jsonify("Not Authorized")
response.status_code = 401
return response
except Exception as e:
print(e)
response = jsonify("Database Error"+e)
response.status_code = 500
return response
finally:
cur.close();
conn.close();
def updateCompanyGrouping():
userid = request.args.get('userid')
token = request.args.get('tok')
try:
if apiAuth.apiAuth(token, userid):
_req = request.json
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
cur.execute("update services set companyId = %s where idservices=%s",(
_req['compId'], _req['servId']
))
conn.commit()
response = jsonify("success")
response.status_code = 200
return response
else:
response = jsonify("Not Authorized")
response.status_code = 401
return response
except Exception as e:
print(e)
response = jsonify("Database Error")
response.status_code = 500
return response
finally:
cur.close();
conn.close();
def updateServiceContact():
userid = request.args.get('userid')
token = request.args.get('tok')
_req = request.json
try:
if apiAuth.apiAuth(token, userid) == True:
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
cur.execute("update servicecontactinfo set name=%s, phone=%s, cell=%s, fax=%s, tollfree=%s, email=%s, website=%s, facebook=%s, twitter=%s, instagram=%s, youtube=%s where idserviceContactInfo=%s",
(_req['conPerson'], _req['conPhone'], _req['conMobile'], _req['conFax'], _req['conTollfree'], _req['conEmail'], _req['conWebsite'], _req['conFacebook'],
_req['conTwitter'],_req['conInstagram'],_req['conYoutube'], _req['conId']))
conn.commit()
response = jsonify("success")
response.status_code = 200
return response
else:
response = jsonify("Not Authorized")
response.status_code = 401
return response
except Exception as e:
print(e)
response = jsonify("Database Error")
response.status_code = 200
return response
finally:
cur.close();
conn.close();
def getScheduleInfo():
userid = request.args.get('userid')
token = request.args.get('tok')
schId = request.args.get('schId')
pId = request.args.get('pId')
try:
if apiAuth.apiAuth(token, userid):
_req = request.json
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
cur.execute("select * from scheduletable where scheduleId=%s", schId)
response = {"schedule":cur.fetchall()}
cur.execute("select * from paymentoptions where idpaymentoptions=%s", int(pId))
response["payment"] = cur.fetchall()
response = jsonify(response)
response.status_code = 200
return response
else:
response = jsonify("Not Authorized")
response.status_code = 401
return response
except Exception as e:
print(e)
response = jsonify("Database Error")
response.status_code = 500
return response
finally:
cur.close();
conn.close();
def getContactInfo():
userid = request.args.get('userid')
token = request.args.get('tok')
contactId = request.args.get('conId')
try:
if apiAuth.apiAuth(token, userid):
_req = request.json
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
cur.execute("select * from servicecontactinfo where idserviceContactInfo=%s", contactId)
response = jsonify(cur.fetchall())
response.status_code = 200
return response
else:
response = jsonify("Not Authorized")
response.status_code = 401
return response
except Exception as e:
print(e)
response = jsonify("Database Error")
response.status_code = 500
return response
finally:
cur.close();
conn.close();
def updateServiceInfo():
userid = request.args.get('userid')
token = request.args.get('tok')
try:
if apiAuth.apiAuth(token, userid):
_req = request.json
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
cur.execute("update services set name = %s, building=%s, street=%s, landmark=%s, area=%s, pincode=%s, state=%s, country=%s where idservices=%s",(
_req['sname'],_req['sbuilding'],_req['sstreet'],_req['slandmark'],_req['sarea'],_req['spincode'],_req['sstate'],_req['scountry'], _req['servId']
))
conn.commit()
response = jsonify("success")
response.status_code = 200
return response
else:
response = jsonify("Not Authorized")
response.status_code = 401
return response
except Exception as e:
print(e)
response = jsonify("Database Error")
response.status_code = 500
return response
finally:
cur.close();
conn.close();
def getCompanyServices():
userid = request.args.get('userid')
token = request.args.get('tok')
try:
if apiAuth.apiAuth(token, userid) == True:
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
cur.execute("select * from companydetails where emailKey=%s",(userid))
companies = cur.fetchall()
response = {"companyCount":len(companies), "companiesList" :companies}
cur.execute("select * from services where serviceUserFK=%s",(userid))
services = cur.fetchall()
for i in services:
i["image"] = "";
response["serviceCount"] = len(services)
response["serviceList"] = services
response = jsonify(response)
response.status_code = 200
return response
else:
response = jsonify("Not Authorized")
response.status_code = 401
return response
except Exception as e:
print(e)
response = jsonify("Database Error")
response.status_code = 500
return response
finally:
cur.close();
conn.close();
def getServiceImage():
userid = request.args.get('userid')
token = request.args.get('tok')
sid = request.args.get('sid')
try:
if apiAuth.apiAuth(token, userid) == True:
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
cur.execute("select image from services where idservices=%s",(sid))
image = cur.fetchall()
img = Image.open(io.BytesIO(image[0]["image"]), mode='r')
img_byte_arr = io.BytesIO()
img.save(img_byte_arr, format='PNG')
my_encoded_img = base64.encodebytes(img_byte_arr.getvalue()).decode('ascii')
return jsonify(my_encoded_img)
else:
response = jsonify("Not Authorized")
response.status_code = 401
return response
except Exception as e:
print(e)
response = jsonify("Database Error")
response.status_code = 500
return response
finally:
cur.close();
conn.close();
def getKeywords():
userid = request.args.get('userid')
token = request.args.get('tok')
kId = request.args.get('kId')
try:
if apiAuth.apiAuth(token, userid):
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
cur.execute("select * from keywords where keywordsid=%s", kId)
response = cur.fetchall()
response = jsonify(response)
response.status_code = 200
return response
else:
response = jsonify("Not Authorized")
response.status_code = 401
return response
except Exception as e:
print(e)
response = jsonify("Database Error")
response.status_code = 500
return response
finally:
cur.close();
conn.close();
def updateCompany():
userid = request.args.get('userid')
token = request.args.get('tok')
try:
if apiAuth.apiAuth(token, userid):
_req = request.json
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
cur.execute("update companydetails set name = %s, city = %s, phone = %s, mobile = %s, firstName = %s, lastName = %s where idcompany = %s",(
_req['compName'], _req['compCity'], _req['compPhone'], _req['compMob'], _req['compFName'], _req['compLName'], _req['compId']
))
conn.commit()
response = jsonify("success")
response.status_code = 200
return response
else:
response = jsonify("Not Authorized")
response.status_code = 401
return response
except Exception as e:
print(e)
response = jsonify("Database Error")
response.status_code = 500
return response
finally:
cur.close();
conn.close();
def getApCompanies():
userid = request.args.get('userid')
token = request.args.get('tok')
try:
if apiAuth.apiAuth(token, userid) == True:
if request.args.get('role') == "AP":
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
_req = request.json
cur.execute(
"select idservices, name, building, street, landmark, area, pincode, state, country, companyid, serviceUserFK from services where verified=0;"
)
conn.commit()
response = jsonify(cur.fetchall())
response.status_code = 200
return response
else:
response = jsonify("false")
response.status_code = 200
return response
else:
response = jsonify('Unauthorized Access')
response.status_code = 401
return response
except Exception as e:
print(e)
response = jsonify('Server Error')
response.status_code = 500
return response
def changePassword():
userid = request.args.get('userid')
token = request.args.get('tok')
try:
if apiAuth.apiAuth(token, userid) == True:
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
_req = request.json
cur.execute("select password from user where email = %s;",
(userid))
rows = cur.fetchall()
check = auth.check_encrypted_password(_req['curPass'],
rows[0]['password'])
if check == True:
_encrpass = auth.encrypt_password(_req['newPass'])
cur.execute("update user set password = %s where email = %s",
(_encrpass, userid))
conn.commit()
response = jsonify("success")
elif check == False:
response = jsonify("invalid")
response.status_code = 200
return response
else:
response = jsonify('Unauthorized Access')
response.status_code = 401
return response
except Exception as e:
print(e)
response = jsonify('Server Error')
response.status_code = 500
return response
def editProfile():
userid = request.args.get('userid')
token = request.args.get('tok')
try:
if apiAuth.apiAuth(token, userid) == True:
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
_req = request.json
cur.execute(
"update user set firstName = %s, lastName = %s, phone = %s where email = %s",
(_req['fname'], _req['lname'], _req['phone'], userid))
conn.commit()
response = jsonify("success")
response.status_code = 200
return response
else:
response = jsonify('Unauthorized Access')
response.status_code = 401
return response
except Exception as e:
print(e)
response = jsonify('Server Error')
response.status_code = 500
return response
def getUserInfo():
userid = request.args.get('userid')
token = request.args.get('tok')
print(userid + " " + token)
try:
if apiAuth.apiAuth(token, userid) == True:
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
cur.execute(
"Select email, firstName, lastName, phone, init, role from user where email='"
+ userid + "';")
rows = cur.fetchall()
response = jsonify(rows)
response.status_code = 200
return response
else:
response = jsonify('Unauthorized Access')
response.status_code = 200
return response
except Exception as e:
print(e)
response = jsonify('Server Error')
response.status_code = 500
return response
def getServiceInfo():
userid = request.args.get('userid')
token = request.args.get('tok')
sid = request.args.get('sid')
response = {}
try:
if apiAuth.apiAuth(token, userid) == True:
if request.args.get('role') == "AP":
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
cur.execute(
"select idservices, services.name, building, street, landmark, area, pincode, state, country, contactid, serviceUserFK, scheduleid, paymentid, keywordsid, companyId from services where idservices=%s;",
(sid))
rows = cur.fetchall()
if rows[0]["companyId"] != 0:
cur.execute(
"select * from companydetails where idcompany=%s",
(rows[0]["companyid"]))
rowsDat = cur.fetchall()
response = {"company": rowsDat}
cur.execute(
"select * from servicecontactinfo where idserviceContactInfo=%s",
(rows[0]["contactid"]))
rowsDat = cur.fetchall()
response["contactInfo"] = rowsDat
cur.execute("select * from scheduletable where scheduleId=%s",
(rows[0]["scheduleid"]))
rowsDat = cur.fetchall()
response["schedule"] = rowsDat
cur.execute(
"select * from paymentoptions where idpaymentoptions=%s",
(rows[0]["paymentid"]))
rowsDat = cur.fetchall()
response["payment"] = rowsDat
cur.execute("select * from keywords where keywordsid=%s",
(rows[0]["keywordsid"]))
rowsDat = cur.fetchall()
response["keywords"] = rowsDat
cur.execute(
"select firstName,lastName,phone from user where email=%s",
(rows[0]["serviceUserFK"]))
rowsDat = cur.fetchall()
response["user"] = rowsDat
response["service"] = rows
response = jsonify(response)
response.status_code = 200
return response
else:
response = jsonify("false")
response.status_code = 200
return response
else:
response = jsonify('Unauthorized Access')
response.status_code = 401
return response
except Exception as e:
print(e)
print("hellooo")
response = jsonify('Server Error')
response.status_code = 500
return response
