app.py

from flask import Flask, render_template, request, send_file, render_template_string, session
import os
import pandas as pd
from midas import *
from io import BytesIO
import uuid

app = Flask(__name__)
app.secret_key = 'midasvergihesaplama'

ALLOWED_EXTENSIONS = {'pdf'}
midas = Midas()
ops = pd.DataFrame()
ozet  = pd.DataFrame()


@app.route('/')
def welcome():
    return render_template('home.html')

def allowed_file(filename):
    return '.' in filename and filename.rsplit('.', 1)[1].lower() in ALLOWED_EXTENSIONS

def write_buffer_to_file(filename, buffer):
    with open(filename, 'wb') as file:
        file.write(buffer.getvalue())

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

    files = request.files.getlist('files')
    results = []
    filtered_files = [file for file in files if file and allowed_file(file.filename)]
  
    ops, ozet, excel_buffer=midas.calculate_tax_for_files(filtered_files,type='Excel')
    filename=str(uuid.uuid4()) + '.xlsx'
    write_buffer_to_file(filename, excel_buffer)
    session['filename'] = filename
    html_table = ozet.to_html(index=True)
    return render_template('result.html', html_table=html_table)



@app.route('/download_excel')
def download_excel():


    filename = session['filename']
    # Send Excel file for download
    return  send_file(
        filename,
        mimetype='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
        as_attachment=True,
        download_name='2023_Vergi_Hesap.xlsx'
    )


if __name__ == '__main__':  # Set your upload folder
    app.run(debug=True)