sales.views/check_stock + sales_representative_status

def check_stock(request):
    if request.session.is_empty():
        return redirect(customer_view.login)
    else:
        if request.method == 'POST':

            product_id = request.POST['product_id']

            sql = "select (B.AREA ||' '||B.BRANCH_ID) AS branch , count(B.BRANCH_ID) as stock " \
                  "from PRODUCT_SPECIFICATION SP, STOCK STK, PRODUCT_IMEI I, BRANCH_PRODUCT_STOCK BP, BRANCH B " \
                  "where SP.PRODUCT_ID = STK.STOCK_PRODUCT_ID AND STK.STOCK_IMEI = I.IMEI_NO " \
                  "AND I.IMEI_NO = BP.STOCK_IMEI AND BP.STOCK_BRANCH_ID = B.BRANCH_ID AND SP.PRODUCT_ID = %s " \
                  "group by (B.AREA ||' '||B.BRANCH_ID)"

            cursor = connection.cursor()
            cursor.execute(sql,[product_id])
            result = cursor.fetchall()
            table = []

            for i in result:
                branch = i[0]
                stock = i[1]
                row = {'branch':branch, 'stock':stock}
                table.append(row)

            print("printing table.........")
            print(table)

            sql_1 = "select NAME from PRODUCT_SPECIFICATION where PRODUCT_ID = %s"
            cursor = connection.cursor()
            cursor.execute(sql_1,[product_id])
            result_1 = cursor.fetchall()

            name = result_1[0][0]

            return render(request, "check_stock.html", {'available_stock':table, 'product_name':name})
        else:
            return render(request, "check_stock.html")

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)
        return render(request,'sales_representative_status.html',{'emp_info':emp_info})