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)