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)
