def upload():
"""
Route for url: server/new/upload/
"""
if 'username' in session:
form = UploadForm()
if request.method == 'GET':
session['data_parsed'] = ''
if 'project_name' in session and 'project_type' in session:
return render_template('ubuildit.html', form = form,
username = session['username'])
if request.method == 'POST':
if form.validate():
file = request.files['file']
if upload_file(file):
if check_file(file):
session['data_parsed'] = parse_file(file)
flash('Your file has been successfully uploaded!')
return redirect(url_for('preview'))
else:
flash('This file is invalid.')
else:
flash('Could not upload your excel file.')
else:
flash('There were problems with your file.')
return render_template('ubuildit.html', form = form,
username = session['username'])
return abort(404)
def upload_image():
if not 'signed_user' in session:
return json.dumps({
'answer': False,
'details': 'You are not signed in'
})
form = UploadForm()
if not form.validate():
return json.dumps({'answer': False, 'details': 'File is invalid'})
file = form.file.data
coordinates = json.loads(request.form.get('coordinates'))
filename = secure_filename(session['signed_user'] +
str(datetime.datetime.now()) + file.filename)
filepath = os.path.join(os.path.abspath('images'), filename)
file.save(filepath)
img = Image.open(filepath)
coordinates_to_crop = (coordinates['left'], coordinates['top'],
coordinates['left'] + coordinates['width'],
coordinates['top'] + coordinates['height'])
cropped = img.crop(coordinates_to_crop)
cropped.save(filepath)
res = User().upload_image(filename, session['signed_user'])
User().set_online(session['signed_user'])
if not res:
return json.dumps({
'answer': False,
'details': "You can upload not more than 5 images"
})
return json.dumps({'answer': True})
def upload():
if not session.get('logged_in'):
abort(401)
# Instantiate your form class
form = UploadForm()
if request.method == 'GET':
return render_template('upload.html', form = form)
# Validate file upload on submit
if request.method == 'POST' and form.validate():
uploaded_file = request.files['file']
filename = secure_filename(uploaded_file.filename)
if filename != '':
file_ext = os.path.splitext(filename)[1]
if file_ext not in app.config['UPLOAD_EXTENSIONS']:
flash('Invalid Format', 'error')
abort(400)
# Get file data and save to your uploads folder
uploaded_file.save(os.path.join( app.config['UPLOAD_FOLDER'], filename))
flash('File Saved', 'success')
return redirect(url_for('home'))
return render_template('upload.html')
def uploadLog():
"Upload log file"
form = UploadForm()
app.logger.debug("uploadLog: %s" % form.errors)
app.logger.debug('------ {0}'.format(request.form))
if form.is_submitted():
app.logger.debug(form.errors)
if form.validate():
app.logger.debug(form.errors)
app.logger.debug(form.errors)
if form.validate_on_submit():
db_folder = app.config['UPLOAD_FOLDER']
filename = secure_filename(form.uploadFile.data.filename)
file_path = os.path.join(db_folder, filename)
form.uploadFile.data.save(file_path)
os.chdir(db_folder)
optionsSQL = MyOptions([file_path], sql=True, outlog='log.out')
log2sql = Log2sql(optionsSQL)
log2sql.processLogs()
return redirect(url_for('analyzeLog'))
return render_template('uploadLog.html', title='Upload Log', form=form)
def basexlsx():
basexlsx_form = UploadForm(request.form)
if g.user:
if request.method == "POST" and basexlsx_form.validate():
# image_data = request.FILES[form.image.name].read()
if basexlsx_form.basexlsx.name not in request.files:
flash("No se ha seleccionado ningun archivo", "alert-danger")
return redirect(request.url)
file = request.files[basexlsx_form.basexlsx.name]
print(file)
if file.filename == "":
flash("No selected file.", "alert-warning")
return redirect(request.url)
if file: # and allowed_file(file.filename):
filename = secure_filename(file.filename)
file.save(os.path.join(app.config["UPLOAD_FOLDER"], filename))
import openpyxl
documento = openpyxl.load_workbook(
os.path.abspath(app.config["UPLOAD_FOLDER"] + '\\' +
filename))
ws = documento.active
smq = (ws.rows)
registros_nuevos = 0
registros_repetidos = 0
registros_total = 0
for campo in smq:
registros_total += 1
if Recuperos.query.filter_by (rama = campo[0].value).first() and \
Recuperos.query.filter_by (siniestro = campo[1].value).first():
registros_repetidos += 1
continue
rama = campo[0].value
siniestro = campo[1].value
desc_siniestro = campo[2].value
fe_ocurrencia = campo[3].value
importe_pagado = campo[4].value
estado = 1
registro_recupero = Recuperos(rama = rama,\
siniestro = siniestro,\
desc_siniestro = desc_siniestro,\
fe_ocurrencia = fe_ocurrencia,\
importe_pagado =importe_pagado,\
estado = estado)
db.session.add(registro_recupero)
registros_nuevos += 1
db.session.commit()
flash("Se han ingresado: " + str(registros_nuevos) + " nuevos registros. Se rechazaron: " + \
str(registros_repetidos) + " registros ya existentes. El archivo contenia: " + str(registros_total) \
+ " registros.", "alert-primary" )
return render_template("subirbases.html", form=basexlsx_form)
flash("You must be logged in.", "alert-warning")
return redirect(url_for("login"))
def upload():
if not session.get('logged_in'):
abort(401)
# Instantiate your form class
upload = UploadForm()
# Validate file upload on submit
if request.method == 'POST' and upload.validate():
# Get file data and save to your uploads folder
file = request.files['photo']
filename = secure_filename(file.filename)
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
flash('File Saved', 'success')
return redirect(url_for('home'))
return render_template('upload.html')
def change_icon():
form = UploadForm()
if form.validate():
suffix = os.path.splitext(form.icon.data.filename)[1]
filename = random_string()+suffix
photos.save(form.icon.data,name=filename)
pathname = os.path.join(current_app.config['UPLOADED_PHOTOS_DEST'],filename)
img = Image.open(pathname)
img.thumbnail((128,128))
img.save(pathname)
if current_user.icon != 'default.jpg':
os.remove(os.path.join(current_app.config['UPLOADED_PHOTOS_DEST'],current_user.icon))
current_user.icon = filename
db.session.add(current_user)
db.session.commit()
flash('图片已经保存')
img_url = photos.url(current_user.icon)
return render_template('users/change_icon.html',form=form,img_url=img_url)
def earnings_and_expenses():
form = UploadForm()
form.origin.choices = [('Credit Card', 'Credit Card'), ('Checking Account', 'Checking Account')]
if form.submit1.data and form.validate():
df = pd.read_csv(request.files.get('file_upload'))
items = create_items(df, form.origin.data)
for item in items:
db.session.add(item)
db.session.commit()
flash('{} items registered!'.format(len(items)))
return redirect(url_for('earnings_and_expenses'))
#Using session to store the dates used from the last
if "init_date_ee" not in session:
session["init_date_ee"] = date.today().replace(day=1, month=1).strftime("%d%m%Y")
session["end_date_ee"] = date.today().strftime("%d%m%Y")
form_date = DatesForm(session["init_date_ee"], session["end_date_ee"])
if form_date.submit2.data and form_date.validate():
form_date.initial_date.data = form_date.initial_date.data
form_date.end_date.data = form_date.end_date.data
session["init_date_ee"] = form_date.initial_date.data.strftime("%d%m%Y")
session["end_date_ee"] = form_date.end_date.data.strftime("%d%m%Y")
elif request.method == 'GET':
form_date.initial_date.data = datetime.strptime(session["init_date_ee"], "%d%m%Y").date()
form_date.end_date.data = datetime.strptime(session["end_date_ee"], "%d%m%Y").date()
try:
items_df = pd.read_sql(Item.query.filter((Item.date >= datetime.strptime(session["init_date_ee"], "%d%m%Y")) & (Item.date <= datetime.strptime(session["end_date_ee"], "%d%m%Y"))).statement, db.session.bind)
views = get_views_earnings_and_expenses(items_df)
except:
views = None
return render_template('earnings_and_expenses.html',
form=form,
form_date=form_date,
active_page = 'earnings_and_expenses',
views = views)
