def get_unapproved_emp():
"""
GET params:
- emp_code: `emp_code`
- access_level: 'manager', 'admin'
"""
emp_code = int(request.args.get('emp_code'))
approved_by = request.args.get('approved_by')
query = "SELECT * FROM visa_form where visa_status = ?"
result = database.query_db(query, (approved_by, ))
return helper.row_jsonify(result)
def get_emp_details():
"""
GET params:
- empCode: `emp_code`
"""
emp_code = int(request.args.get('empCode'))
query = "SELECT * FROM employee where emp_code = ?"
#query="WITH visadetails as (select * from visa_form where emp_code = ?) \
#SELECT * from employee as e, visadetails where e.emp_code = ?"
result = database.query_db(query, (emp_code, ), True)
return helper.row_jsonify(result, True)
def sendDeniedMail(emp_code, access_level):
query = "SELECT email_id FROM employee where emp_code = ?"
result = database.query_db(query, (emp_code, ), True)
email = json.loads(helper.row_jsonify(result, True))['email_id']
subject = "Your application has been DENIED by the {}".format(access_level)
text_body = """\
Hey Employee No {},
We are sorry to inform you that your application was denied.
""".format(emp_code)
text_body = textwrap.dedent(text_body)
sender = "Fractal Analytics"
mailNinja.send_email(subject, sender, email, text_body, 4)
def sendApprovedMail(emp_code):
query = "SELECT email_id FROM employee where emp_code = ?"
result = database.query_db(query, (emp_code, ), True)
email = json.loads(helper.row_jsonify(result, True))['email_id']
subject = "Your application has been approved!"
text_body = """\
Hey Employee No {},
Congratulations! Your application has been APPROVED!
""".format(emp_code)
text_body = textwrap.dedent(text_body)
sender = "Fractal Analytics"
mailNinja.send_email(subject, sender, email, text_body, 4)
def sendAcceptMail(emp_code, access_level):
query = "SELECT email_id FROM employee where emp_code = ?"
result = database.query_db(query, (emp_code, ), True)
email = json.loads(helper.row_jsonify(result, True))['email_id']
subject = "Your application has been accepted by {}".format(access_level)
text_body = """\
Hey Employee No {},
Your application has been accepted by {} and has gone to the next step for approval!
""".format(emp_code, access_level)
text_body = textwrap.dedent(text_body)
sender = "Fractal Analytics"
mailNinja.send_email(subject, sender, email, text_body, 3)
def get_visa_details():
"""
GET params:
- empCode: `emp_code`
"""
emp_code = int(request.args.get('empCode'))
query = "SELECT * FROM visa_form where emp_code = ?"
#query="WITH visadetails as (select * from visa_form where emp_code = ?) \
#SELECT * from employee as e, visadetails where e.emp_code = ?"
result = database.query_db(query, (emp_code, ), True)
if result:
return helper.row_jsonify(result, True)
else:
return json.dumps(dict([("success", 0)]))
def sendNotifyMail(emp_code, country, visa_type):
sender = "Fractal Analytics"
query = "SELECT m.email_id from employee as e, manager as m where \
e.emp_code = ? AND e.proj_code = m.proj_code"
result = database.query_db(query, (emp_code, ), True)
manager_email_id = json.loads(helper.row_jsonify(result, True))['email_id']
subject = "Employee working on your project has applied for VISA!"
text_body = """\
Employee ID : {}
Country : {}
Visa Type : {}
Login to our android app to ACCEPT/REJECT the application!
""".format(emp_code, country, visa_type)
mailNinja.send_email(subject, sender, manager_email_id, text_body, 2)