from flask import Flask, jsonify
import read_excel
app = Flask(__name__)

@app.route('/excel/income_statement', methods=['POST'])
def getincome():

    try:
        result_dict = read_excel.income()
        print(result_dict)
        if result_dict=='表格不准确，请重新传':
            return result_dict,435
        else:
            return result_dict,200
    except Exception as e:
        return jsonify({'error': str(e)}), 500

@app.route('/excel/balance_statement', methods=['POST'])
def getbalance():
    try:
        result_dict = read_excel.balance()
        print(result_dict)
        if result_dict == '表格不准确，请重新传':
            return result_dict, 435
        else:
            return result_dict,200
    except Exception as e:
        return jsonify({'error': str(e)}), 500

@app.route('/excel/cash_statement', methods=['POST'])
def getcash():
    try:
        result_dict = read_excel.cash()
        print(result_dict)
        if result_dict == '表格不准确，请重新传':
            return result_dict, 435
        else:
            return result_dict,200
    except Exception as e:
        return jsonify({'error': str(e)}), 500


if __name__ == '__main__':
    app.run(debug=True, host='0.0.0.0')  # 开启调试模式，方便开发，生产环境请关闭