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)