def add():
"""g.db = connect_db()
name = request.form['name']
due_date = request.form['due_date']
priority = request.form['priority']
if not name or not due_date or not priority:
flash("Please fill all the fields")
return redirect(url_for('tasks'))
else:
#g.db.execute("INSERT INTO tasks(name, due_date, priority, status) VALUES(?, ?, ?, 1)",[request.form['name'],request.form['due_date'],request.form['priority']])
#g.db.commit()
#g.db.close()
flash("Your entry was successfully admitted")
return redirect(url_for('tasks'))"""
form = AddTaskForm(request.form)
if request.method == "POST":
if form.validate_on_submit():
new_task = Task(form.name.data, form.due_date.data, form.priority.data, "1", session["user_id"])
db.session.add(new_task)
db.session.commit()
flash("New entry was successfully posted. Thanks.")
return redirect(url_for("tasks.tasks"))
else:
return render_template("tasks.html", form=form, error=error)
return render_template("tasks.html", form=form, error=error, open_tasks=open_tasks(), closed_tasks=closed_tasks())
def new_task():
error = None
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(
form.name.data,
session['user_id'],
form.due_date.data,
form.priority.data,
'1',
datetime.datetime.utcnow()
)
db.session.add(new_task)
db.session.commit()
flash("New entry was successfully posted. Thanks.")
return redirect(url_for('tasks'))
else:
return render_template(
'tasks.html',
form=form,
error=error,
open_tasks=open_tasks(),
closed_tasks=closed_tasks()
)
else:
return render_template(
'tasks.html',
form=form,
error=error,
open_tasks=open_tasks(),
closed_tasks=closed_tasks()
)
def new_task():
error = None
form = AddTaskForm(request.form)
# g.db = connect_db()
# name = request.form['name']
# due_date = request.form['due_date']
# priority = request.form['priority']
# if not name or not due_date or not priority:
# flash("All fields are required. Please try again!")
# return redirect(url_for('tasks'))
# else:
# g.db.execute("""insert into tasks (name, due_date, priority, status) values (?,?,?,1)""",
# [request.form['name'],request.form['due_date'],request.form['priority']])
# g.db.commit()
# g.db.close()
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(form.name.data, form.due_date.data, form.priority.data,'1',
session['user_id'],datetime.utcnow())
db.session.add(new_task)
db.session.commit()
flash("New entry was successfully posted. Thanks!")
else:
# flash('All fields are required!')
return render_template('tasks.html', form=form, error=error)
return render_template('tasks.html', form=form, error=error,
open_tasks=open_tasks(), closed_tasks=closed_tasks())
def new_task():
error = None
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(
form.name.data,
form.due_date.data,
form.priority.data,
datetime.datetime.utcnow(),
'1',
session['user_id']
)
db.session.add(new_task)
db.session.commit()
flash('New entry was successfully posted. Thanks')
return redirect(url_for('tasks.tasks'))
else:
open_tasks = db.session.query(Task) \
.filter_by(status='1').order_by(Task.due_date.asc())
closed_tasks = db.session.query(Task) \
.filter_by(status='0').order_by(Task.due_date.asc())
return render_template('tasks.html', form=form, error=error, open_tasks = open_tasks, closed_tasks = closed_tasks)
def new_task():
error = []
form = AddTaskForm(flask.request.form)
print(flask.request.form)
if flask.request.method == "POST":
if form.validate_on_submit():
new_task = Task(
form.name.data,
form.due_date.data,
form.priority.data,
datetime.datetime.utcnow(),
"1",
flask.session["user_id"]
)
db.session.add(new_task)
db.session.commit()
flask.flash("New entry was successfully posted.")
return flask.redirect(flask.url_for("tasks"))
else:
error.append("There was an error with the task data. Make sure all fields are filled in.")
return flask.render_template(
"tasks.html",
form = form,
error = error,
open_tasks = open_tasks(),
closed_tasks = closed_tasks()
)
def new_task():
form = AddTaskForm(request.form)
if request.method == "POST":
if form.validate_on_submit():
new_task = Task(form.name.data, form.due_date.data, form.priority.data, 1)
db.session.add(new_task)
db.session.commit()
flash("New task has been added")
return redirect(url_for("tasks"))
def new_task():
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(form.name.data,
form.due_date.data,
form.priority.data,
'1')
db.session.add(new_task)
db.session.commit()
flash('New task was successfully added.')
return redirect(url_for('tasks'))
else:
flash('All fields are required.')
flash(form.validate_on_submit())
return redirect(url_for('tasks'))
return redirect(url_for('tasks'))
def new_task():
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(form.name.data, form.due_date.data, form.priority.data, '1')
db.session.add(new_task)
db.session.commit()
flash('New entry was successfully posted. Thanks')
return redirect(url_for('tasks'))
def new_task():
form = AddTaskForm(request.form)
if request.method == "POST":
if form.validate_on_submit():
new_task = Task(form.name.data, form.due_date.data, form.priority.data, "1")
db.session.add(new_task)
db.session.commit()
flash("New entry was susccessfully posted Thanks.")
return redirect(url_for("tasks"))
def new_task():
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit(): # something to look into
new_task = models.Task(
form.name.data,
form.due_date.data,
form.priority.data,
'1'
)
db.session.add(new_task)
db.session.commit()
flash('New Entry Added Successfully')
return redirect(url_for('tasks'))
def new_task():
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_user = User(
form.username.data,
form.ip_phone.data,
form.ip_phone_type.data,
'1'
)
db.session.add(new_user)
db.session.commit()
flash('New entry was successfully posted. Thanks.')
return redirect(url_for('tasks'))
def new_task():
form = AddTaskForm(request.form)
if request.method == "POST":
if form.validate_on_submit() or True:
new_task = Task(
name = form.name.data,
due_date = form.due_date.data,
priority = form.priority.data,
status = '1',
posted_date = datetime.datetime.utcnow(),
user_id = session['user_id']
)
db.session.add(new_task)
db.session.commit()
return redirect(url_for('tasks'))
def new_task():
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(
form.name.data,
form.due_date.data,
form.priority.data,
'1'
)
db.session.add(new_task)
db.session.commit()
flash('Nu entry dun dun dun. Well done.')
else:
flash('did not validate')
return redirect(url_for('tasks'))
def new_task():
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(form.name.data,
form.due_date.data,
form.priority.data,
datetime.datetime.utcnow(),
'1',
session["user_id"])
db.session.add(new_task)
db.session.commit()
flash("New entry was successfully posted, Thanks.")
else:
flash("Wrong input field, abort posting task.")
return redirect(url_for('tasks'))
def new_task():
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(
form.name.data,
form.due_date.data,
form.priority.data,
'1'
)
db.session.add(new_task)
db.session.commit()
flash('Nueva tarea fue agragada con exito')
else:
flash('Por favor, agregue datos validos')
return redirect(url_for('tasks'))
def new_task():
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(
form.name.data,
form.due_date.data,
form.priority.data,
datetime.datetime.utcnow(),
'1',
'1'
)
db.session.add(new_task)
db.session.commit()
flash('New entry posted! Do it, Doug!')
return redirect(url_for('tasks'))
def new_task():
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
print(form.errors)
new_task = Task(
form.name.data,
form.due_date.data,
form.priority.data,
datetime.datetime.utcnow(),
'1',
session['user_id']
)
db.session.add(new_task)
db.session.commit()
flash('New entry was successfully posted. Thanks.')
return redirect(url_for('tasks'))
def new_task():
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(
form.name.data,
form.due_date.data,
form.priority.data,
'1'
)
db.session.add(new_task)
db.session.commit()
flash('Nova tarefa adicionada.')
else:
flash('Todos os campos sao necessarios')
return redirect(url_for('tasks'))
return redirect(url_for('tasks'))
def new_task():
form = AddTaskForm(request.form)
if request.method == "POST":
if form.validate_on_submit():
new_task = Task(
form.name.data,
form.due_date.data,
form.priority.data,
datetime.datetime.utcnow(),
'1',
session['user_id']
)
db.session.add(new_task)
db.session.commit()
flash("Entry added successfully")
else:
flash_errors(form)
return redirect(url_for('tasks'))
def new_task():
error = None
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(
form.name.data,
form.due_date.data,
form.priority.data,
datetime.datetime.utcnow(),
'1',
session['user_id']
)
db.session.add(new_task)
db.session.commit()
#flash('New entry was successfully posted. Thanks.')
return redirect(url_for('tasks'))
else:
return render_template('tasks.html', form=form, error=flash_errors(form))
return render_template('tasks.html',form=form,error=error,open_tasks=open_tasks(),closed_tasks=closed_tasks())
def new_task():
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(
form.name.data,
form.due_date.data,
form.priority.data,
datetime.datetime.utcnow(),
'1',
session['user_id']
)
db.session.add(new_task)
db.session.commit()
flash('New Entry was successfully posted. Thanks.')
return redirect(url_for('tasks'))
else:
flash('All fields are required.')
return redirect(url_for('tasks'))
return render_template('tasks.html', form=form)
def new_task():
form = AddTaskForm(request.form)
if request.method == "POST":
if form.validate_on_submit():
new_task = Task(
form.name.data,
form.due_date.data,
form.priority.data,
datetime.datetime.utcnow(),
"1",
session["user_id"],
)
db.session.add(new_task)
db.session.commit()
flash("New entry was successfully posted. Thanks.")
return redirect(url_for("tasks"))
else:
flash("All fields are required.")
return redirect(url_for("tasks"))
return render_template("tasks.html", form=form)
def new_task():
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(
form.name.data,
form.due_date.data,
form.priority.data,
datetime.datetime.utcnow(
), # captures current date n passes it to Tasks() class
'1',
session['user_id'])
db.session.add(new_task)
db.session.commit()
flash('New entry was successfully posted. Thanks.')
return redirect(url_for('tasks'))
else:
flash('All fields are reqiured.')
return redirect(url_for('tasks'))
return render_template('tasks.html', form=form)
def new_task():
from datetime import datetime
error = None
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(
form.name.data,
form.content.data,
form.due_date.data,
form.priority.data,
datetime.utcnow(),
'1',
session['user_id'])
db.session.add(new_task)
db.session.commit()
flash('New entry was successfully posted. Thanks.')
return redirect(url_for('tasks.tasks'))
else:
return render_template('tasks.html', form=form, error=error)
def new_task():
error = None
form = AddTaskForm(request.form)
if request.method == "POST":
if form.validate_on_submit():
new_task = Task(
form.name.data,
form.due_date.data,
form.priority.data,
datetime.datetime.utcnow(),
"1",
session["user_id"],
)
db.session.add(new_task)
db.session.commit()
flash("New entry was successfully posted. Thanks.")
return redirect(url_for("tasks"))
# else:
# flash('All fieds are required.')
# return render_template(url_for('tasks.html', form=form,error=error))
return render_template("tasks.html", form=form, error=error, open_tasks=open_tasks(), closed_tasks=closed_tasks())
def new_task():
error = None
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(form.name.data,
form.due_date.data,
form.priority.data,
'1',
datetime.datetime.utcnow(),
session['user_id']
)
db.session.add(new_task)
db.session.commit()
flash('New entry was posted successfully, Thanks!')
return redirect(url_for('tasks'))
#flash_errors(form)
# It doesn't work if we simply redirect in case of unsuccessful entries, we gotta display the errors
# Note that form object is reinitialized AddTaskForm(request.form) in views controller action function.
return render_template('tasks.html', error=error, form=form, open_tasks=open_tasks(), closed_tasks= closed_tasks())
def new_task():
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(
form.TaskName.data,
form.TaskDueDate.data,
form.TaskPriority.data,
datetime.datetime.utcnow(),
'1',
session['user_id']
)
print(new_task)
db.session.add(new_task)
db.session.commit()
flash('New entry was successfully posted. Thanks.')
else:
flash('Please use proper Date Format')
return redirect(url_for('tasks'))
###### Depricated SQLite3 ############
'''
def new_task():
error = None
form = AddTaskForm(flask.request.form)
if flask.request.method == "POST":
if form.validate_on_submit():
db.session.add(
Task(
form.name.data,
form.due_date.data,
form.priority.data,
datetime.datetime.utcnow(),
flask.session["user_id"],
"1",
)
)
db.session.commit()
flask.flash("New entry was successfully posted. Thanks!")
return flask.redirect(flask.url_for("tasks"))
else:
return flask.render_template("tasks.html", form=form, error=error)
return flask.render_template("tasks.html", form=form, error=error)
def new_task():
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
# WHY ARE WE STILL HARDCODING?! (Now with MOAR hardcoding)
new_task = Task(
form.name.data,
form.due_date.data,
form.priority.data,
datetime.utcnow(),
'1',
session['account_id']
)
db.session.add(new_task)
db.session.commit()
flash('New entry successfully posted. Thanks.')
return redirect(url_for('tasks'))
else:
return render_template(
'tasks.html',
form=form,
open_tasks = open_tasks(),
closed_tasks = closed_tasks()
)
def new_task():
form = AddTaskForm(request.form)
error = None
if form.validate_on_submit():
new_task = Task(
form.name.data,
form.due_date.data,
form.priority.data,
datetime.datetime.now(),
'1',
session['user_id']
)
db.session.add(new_task)
db.session.commit()
flash('New entry was successfully posted. Thanks.')
else:
return render_template('tasks.html', form = form, error = error,
open_tasks = find_open_tasks(), closed_tasks = find_closed_tasks())
return redirect(url_for('tasks'))
def add():
form = AddTaskForm(request.form)
#pdb.set_trace()
if request.method == 'POST':
if form.validate_on_submit():
new_entry = Entry(form.entryDate.data, form.batch.data,
form.action.data, form.actionNo.data,
form.value.data, form.notes.data)
## TEMPORARY SKIP
db.session.add(new_entry)
db.session.commit()
###OLD CODE
entryDate = form.entryDate.data
batch = form.batch.data
action = form.action.data
actionNo = form.actionNo.data
value = form.value.data
notes = form.notes.data
#dbTable = batch[:-3]
#pdb.set_trace()
if ("Sheep" or "Duck") in batch:
flash('New entry was successfully posted!')
return redirect(url_for('main'))
#start new code
if action == "Purchase":
cvpb = value / actionNo
#batch_detail = [batch, entryDate, actionNo, cvpb, 0, 0, 0, 0, 0, 0, value]
if "Broiler" in batch:
create_broiler = Broiler(batch, entryDate, actionNo,
float(cvpb), 0, 0, 0, 0.0, 0.0,
0.0, float(value))
db.session.add(create_broiler)
elif "Layer" in batch:
create_layer = Layer(batch, entryDate, actionNo,
float(cvpb), 0, 0, 0, 0.0, 0.0, 0.0,
float(value))
db.session.add(create_layer)
elif "Pig" in batch:
create_pig = Broiler(batch, entryDate, actionNo,
float(cvpb), 0, 0, 0, 0.0, 0.0, 0.0,
float(value))
db.session.add(create_pig)
db.session.commit()
flash('New entry was successfully posted!')
return redirect(url_for('main'))
else:
if "Broiler" in batch:
#pdb.set_trace()
table = Broiler
record = db.session.query(Broiler).filter_by(
batch=batch).first()
elif "Layer" in batch:
table = Layer
record = db.session.query(Layer).filter_by(
batch=batch).first()
elif "Pig" in batch:
table = Pig
record = db.session.query(Pig).filter_by(
batch=batch).first()
#ogAlive = ogData[2]
#ogCVPB = ogData[3]
#ogSlaughtered = ogData[4]
#ogSold = ogData[5]
#ogDead = ogData[6]
#ogFeed = ogData[7]
#ogTime = ogData[8]
#ogSales = ogData[9]
#ogExp = ogData[10]
#flag = False
if action == "Dead" or action == "Lost":
#update Dead data for batch, but data from animals table or form will be negative
newVal = int(record.dead) - int(actionNo)
db.session.query(table).filter_by(batch=batch).update(
{"dead": newVal})
alive = int(record.alive) + int(actionNo)
db.session.query(table).filter_by(batch=batch).update(
{"alive": alive})
#may need to use str(action)
elif "Slaughter" in action:
#update slaughtered data
#pdb.set_trace()
newVal = int(record.special) - int(actionNo)
db.session.query(table).filter_by(batch=batch).update(
{"special": newVal})
alive = int(record.alive) + int(actionNo)
db.session.query(table).filter_by(batch=batch).update(
{"alive": alive})
newVal2 = float(record.sales) + float(value)
db.session.query(table).filter_by(batch=batch).update(
{"sales": newVal2})
elif action == "Tray":
#pdb.set_trace()
newVal = int(record.special) + int(actionNo)
db.session.query(table).filter_by(batch=batch).update(
{"special": newVal})
newVal2 = float(record.sales) + float(value)
db.session.query(table).filter_by(batch=batch).update(
{"sales": newVal2})
elif action == "Sold":
newVal = int(record.sold) - int(actionNo)
db.session.query(table).filter_by(batch=batch).update(
{"sold": newVal})
newVal2 = float(record.sales) + float(value)
db.session.query(table).filter_by(batch=batch).update(
{"sales": newVal2})
alive = int(record.alive) + int(actionNo)
db.session.query(table).filter_by(batch=batch).update(
{"alive": alive})
elif action == "Feed":
newVal = float(record.feed) + float(actionNo)
db.session.query(table).filter_by(batch=batch).update(
{"feed": newVal})
newVal2 = float(record.exp) + float(value)
db.session.query(table).filter_by(batch=batch).update(
{"exp": newVal2})
elif action == "Time":
newVal = float(record.time) + float(actionNo)
db.session.query(table).filter_by(batch=batch).update(
{"time": newVal})
newVal2 = float(record.exp) + float(value)
db.session.query(table).filter_by(batch=batch).update(
{"exp": newVal2})
#End new code
db.session.commit()
flash('New entry was successfully posted!')
return redirect(url_for('main'))
def add():
form = AddTaskForm(request.form)
if request.meathon == 'POST':
if form.validate_on_submit():
new_entry = Entry(form.entryDate.data, form.batch.data,
form.action.data, form.actionNo.data,
form.value.data, form.notes.data)
db.ssession.add(new_entry)
db.session.commit()
flash('New entry was successfully posted.Thanks.')
entryDate = request.form['entryDate']
batch = request.form['batch']
action = request.form['action']
actionNo = int(request.form['actionNo'])
value = float(request.form['value'])
table = request.form['batch']
dbTable = table[:-3]
if not entryDate or not batch:
flash("All fields are required. Please try again.")
return redirect(url_for('main'))
else:
g.db = connect_db()
g.db.execute(
'insert into animals (entryDate, batch, action, actionNo, value, notes) values (?, ?, ?, ?, ?, ?)',
[
request.form['entryDate'], request.form['batch'],
request.form['action'], request.form['actionNo'],
request.form['value'], request.form['notes']
])
#start new code
if action == "Purchase":
cvpb = value / actionNo
g.db.execute(
"INSERT INTO " + dbTable +
" (batch, purDate, alive, cvpb, special, sold, dead, feed, time, sales, exp) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
[batch, entryDate, actionNo, cvpb, 0, 0, 0, 0, 0, 0, value])
g.db.commit()
flash('New entry was successfully posted!')
return redirect(url_for('main'))
else:
#get data from specific animal table so we can update
query0 = "SELECT * FROM " + dbTable + " WHERE batch = '" + batch + "'"
temp = g.db.execute(query0)
ogData = temp.fetchone()
#debug
#pdb.set_trace()
ogPurchDate = ogData[1]
ogAlive = ogData[2]
ogCVPB = ogData[3]
ogSlaughtered = ogData[4]
ogSold = ogData[5]
ogDead = ogData[6]
ogFeed = ogData[7]
ogTime = ogData[8]
ogSales = ogData[9]
ogExp = ogData[10]
flag = False
if action == "Dead" or action == "Lost":
#update Dead data for batch, but data from animals table or form will be negative
newVal = ogDead - actionNo
col = "dead"
alive = ogAlive + actionNo
c.execute("UPDATE " + dbTable + " SET alive = " + str(alive) +
" WHERE batch = '" + batch + "'")
elif "Slaughter" in str(action):
#update slaughtered data
newVal = ogSpecial - actionNo
alive = ogAlive + actionNo
c.execute("UPDATE " + dbTable + " SET alive = " + str(alive) +
" WHERE batch = '" + batch + "'")
col = "special"
newVal2 = ogSales + value
col2 = "sales"
flag = True
elif action == "Tray":
newVal = ogSpecial + actionNo
col = "special"
newVal2 = ogSales + value
col2 = "sales"
flag = True
elif action == "Sold":
newVal = ogSold + actionNo
col = "sold"
newVal2 = ogSales + value
col2 = "sales"
flag = True
alive = ogAlive + actionNo
c.execute("UPDATE " + dbTable + " SET alive = " + str(alive) +
" WHERE batch = '" + batch + "'")
elif action == "Feed":
newVal = ogFeed + actionNo
col = "feed"
newVal2 = ogExp + value
col2 = "exp"
flag = True
elif action == "Time":
newVal = ogTime + actionNo
col = "Time"
newVal2 = ogExp + value
col2 = "exp"
flag = True
if flag:
query2 = "UPDATE " + dbTable + " SET " + col2 + " = " + str(
newVal2) + " WHERE batch = '" + batch + "'"
g.db.execute(query2)
query = "UPDATE " + dbTable + " SET " + col + " = " + str(
newVal) + " WHERE batch = '" + batch + "'"
g.db.execute(query)
#End new code
g.db.commit()
g.db.close()
flash('New entry was successfully posted!')
return redirect(url_for('main'))
