def statEnt(canId): form=StatusForm() if request.method=='POST': #idc=request.form.get("Id") rd=request.form.get("rounds") st=request.form.get("stat") result1=db.execute("SELECT COUNT(id) FROM candidStat WHERE id=:id;",{"id":canId}).fetchone()[0] result2=db.execute("SELECT COUNT(id) FROM candid WHERE id=:id;",{"id":canId}).fetchone()[0] if(result1==0 and result2==1): db.execute(f"INSERT INTO candidStat(id,{rd}) VALUES(:id,:rounds);", {"id":int(canId),"rounds":st}) result=db.execute(f"SELECT c.id,c.name,c.email,c.phno,s.r1,s.r2,s.r3,s.r4,s.hr,s.os,s.joined FROM candid as c RIGHT JOIN candidStat as s ON c.id=s.id WHERE c.id={int(canId)};") details=result.fetchall() db.commit() flash(f'Entry done!','success') return render_template('dashboard.html',details=details) elif(result2==1 and result1!=0): db.execute(f"UPDATE candidStat SET {rd}=:st WHERE id={int(canId)};",{"st":st}) result=db.execute(f"SELECT c.id,c.name,c.email,c.phno,s.r1,s.r2,s.r3,s.r4,s.hr,s.os,s.joined FROM candid as c RIGHT JOIN candidStat as s ON c.id=s.id WHERE c.id={int(canId)};") details=result.fetchall() db.commit() flash(f'Update done!','success') return render_template('dashboard.html',details=details) return render_template('statent.html',form=form)
def TmcData3(request): """ if CheckAccess(request,'2') != 'OK': return render_to_response("tmc/notaccess/tmc.html") """ ## --- Номер заявки --- try: tmc_id = request.GET['tmc_id'] request.session['tmc_id'] = tmc_id except: pass try: tmc_id = request.session['tmc_id'] except: return HttpResponseRedirect("/tmc") if request.method == 'POST': form = StatusForm(request.POST) if form.is_valid(): comment = form.cleaned_data['comment'] status = form.cleaned_data['status'] r = NewTmcStatus(GetUserKod(request), tmc_id, comment, status) if r == 'OK': EmailStatusInfo(tmc_id) d = GetTmcData(tmc_id) data = GetStatusHistory(tmc_id) form = StatusForm(None) form.fields['status'].choices = GetStatusList(d[5]) s = GetLastStatus(tmc_id) c = RequestContext(request, {'d': d, 'form': form, 'data': data, 's': s}) c.update(csrf(request)) return render_to_response("tmc/tmcdata3.html", c)
def status(): form = StatusForm(csrf_enabled=False) if form.validate_on_submit(): # query bookid here: st = Status.query.filter_by(bk_id=form.orderid.data) if not st is None: # login user here: ids = ['booked', 'started', 'wash', 'wheelcare', 'checkup'] flash('Valid id') return render_template('display_details.html', cur_status=st, ids=ids) else: flash('Invalid id') return redirect(url_for('status', _external=True)) return render_template('status.html', form=form)
def manual_update(): if app.config['AUTO_MODE']: flash('You cannot update an status in Automatic Mode!') return redirect(url_for('get_all_status')) form = StatusForm() if form.is_submitted(): new_status = { 'status': int(form.status.data), 'message': str(form.message.data), 'date': datetime.now().strftime("%d-%m-%Y %H:%M:%S"), 'auto_mode': False } STATUS_LIST.append(new_status) save_status(new_status) return redirect(url_for('get_all_status')) return render_template('manual_update.html', form=form)
def update_status(request): user = check_validation(request) data = 'Kids Zone is Cool' if user: if request.method == "POST": form = StatusForm(request.POST) if form.is_valid(): status = form.cleaned_data.get('status') user_name = user.username print user_name USER = User.objects.all().filter(username=user_name).first() USER.status = status # status_text=User(username=user_name,status=status) # status_text.save() # data=status print status + "is posted" return render(request, 'feed.html', {}) else: return redirect('/login/')
def status(): form = StatusForm() context = { 'form': form, } if form.validate_on_submit(): oid = form.order_id.data appointment = get_appointment(oid) apdict = appointment.to_dict() context = { 'appointment': apdict, } if appointment.to_dict() is not None: return render_template('checking.html', **context) else: flash('No existe la orden {}'.format(oid)) return render_template('status.html', **context)
def manage_orders(status_id): if not session.get('current_user'): return redirect('/login') elif not session.get('current_user')['role_id'] == 1: return render_template('401.html') form = StatusForm(request.form) if request.method == 'POST': db.db_save( f'update border set Status_id={form.status.data} where id={request.args.get("ord_id")}' ) query = f""" select distinct o.id, o.buser_id, o.payment_type, o.time , u.name, u.last_name, u.surname, u.phone , s.sname, o.price from border o full outer join buser u on o.buser_id = u.id inner join cart c on u.id = c.buser_id inner join Order_cart_rel ok on o.id = ok.border_id and c.id=ok.cart_id inner join Service_cart_rel r on r.cart_id = c.id inner join service s on r.service_id = s.id and r.cart_id = c.id where o.status_id={status_id} and c.status_id=7 order by id; """ db_data = db.db_get(query, cur_type='all') data = prepare_data(db_data) return render_template('orders.html', data=data, form=form, status_id=status_id)