from flask import jsonify, make_response
from flask_restful import Resource, reqparse
from app import db


class Joined(Resource):
    def post(self):
        parser = reqparse.RequestParser()
        parser.add_argument('a')
        parser.add_argument('b')
        parser.add_argument('account_number')
        args = parser.parse_args()
        a = args['a']
        b = args['b']
        account_number = args['account_number']
        
        result_list = []

        #sipname = 31
        sql_str = "SELECT  account_number from `call_history` INNER JOIN `account` ON call_history.account_number = account.account_number".format(args["account_number"])
        result = db.engine.execute(sql_str)

        #for rows in result:
            # print("res -->"+str(rows))
            result_data = {}
            result_data['account_number'] = rows[1]
            #result_data['sipusername'] = rows[5]
            result_list.append(result_data)

        return jsonify(staus=1, message="Success", result=result_list)