def all_order(page_num):
if not check_login():
return render_template('index.html')
form = searchFile()
threads = work.query.filter_by().order_by(work.Date.asc()).paginate(
per_page=10, page=page_num)
return render_template('all_orders.html', threads=threads)
def user_list(page_num):
if not check_login():
return render_template('index.html')
form = searchFile()
threads = people.query.filter_by().paginate(per_page=10, page=page_num)
print(threads.items)
return render_template('user_list.html', threads=threads)
def delete_user(page_num):
if not check_login():
return render_template('index.html')
form = searchFile()
ind = (request.args.get('q'))
threads = people.query.filter_by(ID=ind)
db.session.delete(threads[0])
db.session.commit()
return redirect(url_for('user_list'))
def add_new_order(page_num):
if not check_login():
return render_template('index.html')
form = searchFile()
threads = people.query.filter_by(position='Buyer')
threads1 = people.query.filter_by(position='Team')
return render_template('add_new_order.html',
buyer=threads,
team=threads1,
form=form)
def change_order_price(page_num):
if not check_login():
return render_template('index.html')
form = searchFile()
ind = (request.args.get('id'))
threads = work.query.filter_by(ID=ind)
threads[0].Budget = request.form['budget']
threads[0].Total_Earning = int(request.form['budget']) - int(
threads[0].Cost)
db.session.commit()
return redirect(('order_owner?q=' + ind))
def add_money():
if not check_login():
return render_template('index.html')
form = searchFile()
team = request.form["team"]
pas = request.form["amnt"]
row = money(team_id=team,
date=datetime.datetime.now().strftime('%b %d,%Y %H:%M'),
amount=pas)
db.session.add(row)
db.session.commit()
return redirect(url_for('user_list'))
def update_order_status(page_num):
if not check_login():
return render_template('index.html')
form = searchFile()
ind = (request.args.get('id'))
threads = work.query.get(ind)
threads.Status = request.form["T3"]
if 'Com' in request.form["T3"]:
threads.end_time = datetime.datetime.now().strftime('%b %d,%Y %H:%M')
db.session.commit()
else:
threads.end_time = ''
db.session.commit()
flash('Order Marked as {}'.format(request.form["T3"]), 'success')
return redirect(url_for('owner'))
def add_team(page_num):
if not check_login():
return render_template('index.html')
form = searchFile()
ind = (request.args.get('id'))
threads = work.query.filter_by(ID=ind)
threads[0].Team += ',' + request.form['buyer']
threads[0].Cost = float(threads[0].Cost) + int(request.form['budget'])
threads[0].Total_Earning = float(threads[0].Total_Earning) - int(
request.form['budget'])
insert_project_with_team(request.form['buyer'], ind,
request.form['budget'])
db.session.commit()
return redirect(('order_owner?q=' + ind))
def team(page_num):
if not check_login_team():
return render_template('index.html')
date_1 = datetime.datetime.now()
dead = date_1.strftime('%b')
form = searchFile()
# take all the projects
all_project = project.query.filter_by(team=session['name'])
projects_by_him = []
for proj in all_project:
projects_by_him.append([proj.project, proj.amount])
complete_proj = 0
complete_money = 0
running_proj = 0
running_money = 0
running_work = []
for proj in projects_by_him:
temp = work.query.filter_by(ID=proj[0])
if temp[0].Status == 'Active' or temp[0].Status == 'Rivision':
print(temp[0])
running_work.append(temp[0])
running_proj += 1
running_money += float(proj[1])
elif temp[0].Status == 'Complete':
complete_proj += 1
complete_money += float(proj[1])
mon = money.query.filter_by(team_id=session['id'])
total_paid = 0
for m in mon:
total_paid += float(m.amount)
balance = complete_money - total_paid
return render_template('team_dash.html',
threads=running_work,
over=(complete_proj, complete_money, running_proj,
running_money, total_paid, balance),
form=form)
def index(page_num):
form = searchFile()
threads = stock.query.order_by(stock.index.desc()).paginate(per_page=50,
page=page_num,
error_out=True)
if request.method == 'POST' and 'tag' in request.form:
tag = request.form["tag"]
search = "%{}%".format(tag)
threads = stock.query.filter(stock.STOCK_Symbol.like(search)).paginate(
per_page=50, page=page_num, error_out=True)
return render_template('index.html',
threads=threads,
form=form,
tag=tag)
return render_template('index.html', threads=threads, form=form)
def order_owner():
if not check_login():
return render_template('index.html')
form = searchFile()
ind = (request.args.get('q'))
threads = work.query.filter_by(ID=ind)
user = project.query.filter_by(project=ind)
all_user = people.query.filter_by(position='Team')
fils = files.query.filter_by(order_id=ind)
ntes = str(threads[0].notes).split('+')
return render_template('owner_order.html',
work=threads[0],
user=user,
all_user=all_user,
form=form,
down=fils,
notes=ntes)
def order_team(page_num):
if not check_login_team():
if check_login():
return redirect("/order_owner?q=" + (request.args.get('q')))
return render_template('index.html')
form = searchFile()
ind = (request.args.get('q'))
threads = work.query.filter_by(ID=ind)
user = project.query.filter((project.project == ind)
& (project.team == session['name']))
all_user = people.query.filter_by(position='Team')
fils = files.query.filter_by(order_id=ind)
return render_template('team_order.html',
work=threads[0],
user=user,
all_user=all_user,
form=form,
down=fils)
def delete_team(page_num):
if not check_login():
return render_template('index.html')
form = searchFile()
ind = (request.args.get('id'))
name = (request.args.get('name'))
amnt = (request.args.get('amount'))
threads = work.query.filter_by(ID=ind)
threads[0].Team = str(threads[0].Team).replace(name, '').replace(',,', ',')
threads[0].Cost = float(threads[0].Cost) - float(amnt)
threads[0].Total_Earning = float(threads[0].Total_Earning) + float(amnt)
peo = project.query.filter((project.team == name)
& (project.project == ind))
db.session.delete(peo[0])
db.session.commit()
return redirect(('order_owner?q=' + ind))
def insert_new_user(page_num):
if not check_login():
return render_template('index.html')
form = searchFile()
if request.method == 'POST' and 'name' in request.form and 'email' in request.form and 'password' in request.form:
name = request.form["name"]
email = request.form["email"]
pas = request.form["password"]
radio = request.form["r1"]
try:
check = request.form["check"]
except:
check = ''
print(name, email, pas, radio, check)
row = people(position=radio, user=name, email=email, password=pas)
db.session.add(row)
db.session.commit()
flash('{} Added as a {}'.format(name, radio), 'success')
else:
print(request.form["name"])
return redirect(url_for('add_new_user'))
def owner(page_num):
if not check_login():
return render_template('index.html')
date_1 = datetime.datetime.now()
dead = date_1.strftime('%b')
form = searchFile()
all_project = work.query.filter((work.end_time.like('%{}%'.format(dead))))
com_price = 0
com_order = 0
for proj in all_project:
if 'Com' in proj.Status:
com_order += 1
com_price += float(proj.Total_Earning)
all_project = work.query.filter((work.Status == 'Active')
| (work.Status == 'Rivision')).order_by(
work.Date.desc())
total_running = 0
total_order = 0
for proj in all_project:
total_order += 1
total_running += float(proj.Total_Earning)
threads = work.query.filter((work.Status == 'Active')
| (work.Status == 'Rivision')).paginate(
per_page=10, page=page_num)
return render_template('owner.html',
threads=threads,
over=(com_price, com_order, total_running,
total_order),
form=form)
def add_new_user(page_num):
if not check_login():
return render_template('index.html')
form = searchFile()
return render_template('add_user.html', form=form)
