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 * 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 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 reviewwriting():
try:
conn = mysql.connect()
cur = conn.cursor(pymysql.cursors.DictCursor)
formdata = request.json
print(formdata)
userid = request.args.get('userid')
token = request.args.get('tok')
if apiAuth.apiAuth(userid,token) == True :
serviceid = request.args.get('serviceid')
reviewid = validateReviewId(conn, cur);
cur.execute("insert into review(review_key,r_userid,r_serviceid,r_stars,r_header,r_content) values(%s,%s,%s,%s,%s,%s)",
(reviewid, userid, serviceid, formdata['star'], formdata['header'], formdata['content']))
conn.commit()
response = jsonify("Review added successfully")
response.status_code = 200
return response
else:
response = jsonify("unauthorised")
response.status_code = 403
return response
except Exception as e:
print(e)
response = jsonify('Error occured')
response.status_code = 500
return response
finally:
conn.close()
cur.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 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 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 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 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 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 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 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 getServiceInfo():
userid = request.args.get('userid')
token = request.args.get('tok')
sid = request.args.get('sid')
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 * from services where idservices=%s;",
(sid))
rows = cur.fetchall()
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)
response = jsonify('Server Error')
response.status_code = 500
return response
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 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 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 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()
