def select_aps():
aps = json.loads(request.form['selected_aps'])
message = request.form['selected_message']
aps = [int(ap.replace("ap_", '')) for ap in aps]
sess = DbSession().get_session()
ap_equips = sess.query(Equipment).filter(Equipment.ID.in_(aps)).all()
num_customers = sum([len(ap.get_children()) for ap in ap_equips])
return render_template("customer_select.html", num_customers=num_customers, aps=ap_equips, message=message, logged_in=True, debug=app.debug)
def rm_job():
sess = DbSession().get_session()
user = get_user(sess, session["username"])
job = sess.query(Job).filter(Job.Id == request.form["id"]).first()
if job.TimeCost != 0:
user.GoldPool += job.GoldCost
user.XpPool += job.XpCost
sess.delete(job)
sess.commit()
return jsonify({"status":1})
def allcall():
sess = DbSession().get_session()
aps = sess.query(AccessPoint).all()
sites = {}
for ap in aps:
nl_id = ap.equipment.equipment_ex.network_location.NetworkLocationID
if nl_id not in sites:
sites[nl_id] = []
sites[nl_id].append(ap)
default_order = sites.keys()
default_order.sort(key=lambda x: sites[x][0].equipment.equipment_ex.network_location.Name)
default_order = [(default_order[i], i%2) for i in range(len(default_order))]
return render_template("allcall.html", sites=sites, site_order=default_order, logged_in=True, debug=app.debug)
def exec_allcall():
sess = DbSession().get_session()
message = request.form['selected_message']
customers = json.loads(request.form['selected_custs'])
customers = [int(customer.replace("cust_", '')) for customer in customers]
customers = sess.query(Customer).filter(Customer.CustomerID.in_(customers)).all()
phone_numbers = [customer.get_first_number() for customer in customers if customer.get_first_number()]
def cust_iter():
for number in phone_numbers:
yield str(number)
outs = "Message: %s, To call: <br>" % message
print(outs + ",".join(cust_iter()))
return render_template("completed.html", logged_in=True, debug=app.debug)
def del_wright():
sess = DbSession().get_session()
wright = sess.query(Wright).filter(Wright.Id == request.form["id"]).first()
sess.delete(wright)
sess.commit()
return jsonify({"status":1})
