def sales_representative_status(request):
    if request.session.is_empty():
        return redirect(customer_view.login)
    else:
        sql = "SELECT * FROM EMPLOYEES WHERE EMPLOYEE_ID = %s"
        sql_1 = "select employee_profit(EMPLOYEE_ID) from EMPLOYEES where  EMPLOYEE_ID=%s "
        employee_id = request.session['employee_id']

        cursor = connection.cursor()
        cursor.execute(sql,[employee_id])
        result = cursor.fetchall()
        cursor.close()
        emp_info = []

        cursor = connection.cursor()
        cursor.execute(sql_1, [employee_id])
        result_1 = cursor.fetchall()
        cursor.close()

        profit = result_1[0][0]

        for i in result:
            name = i[1]
            designation = i[2]
            salary = i[3]
            emp_id = employee_id
            row = {'name':name,'designation':designation,'salary':salary,'emp_id':emp_id,'profit':profit}
            emp_info.append(row)

        print(emp_info)
        flag = 0
        designation = request.session['username']
        if designation[0:5] == "sales":
            flag = 1
        else:
            flag = 0
        return render(request,'sales_representative_status.html',{'emp_info':emp_info,'flag':flag})