def issues_process_post(db, render): form = issues_forms.issues_process_form() if not form.validates(source=request.forms): return render("base_form", form=form) iflow = models.SlcIssuesFlow() iflow.issues_id = form.d.issues_id iflow.accept_time = utils.get_currtime() iflow.accept_status = form.d.accept_status iflow.accept_result = form.d.accept_result iflow.operator_name = get_cookie("username") db.add(iflow) issues = db.query(models.SlcIssues).get(iflow.issues_id) issues.status = iflow.accept_status ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)处理工单%s' % (get_cookie("username"),iflow.issues_id) db.add(ops_log) db.commit() redirect("/issues/detail?issues_id=%s"%iflow.issues_id)
def product_update(db, render): form = product_forms.product_update_form() if not form.validates(source=request.forms): return render("sys_product_form", form=form) product = db.query(models.SlcRadProduct).get(form.d.id) product.product_name = form.d.product_name product.product_status = form.d.product_status product.fee_months = int(form.d.get("fee_months", 0)) product.fee_times = utils.hour2sec(form.d.get("fee_times", 0)) product.fee_flows = utils.mb2kb(form.d.get("fee_flows", 0)) product.bind_mac = form.d.bind_mac product.bind_vlan = form.d.bind_vlan product.concur_number = form.d.concur_number product.fee_period = form.d.fee_period product.fee_price = utils.yuan2fen(form.d.fee_price) product.input_max_limit = utils.mbps2bps(form.d.input_max_limit) product.output_max_limit = utils.mbps2bps(form.d.output_max_limit) product.update_time = utils.get_currtime() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)修改资费信息:%s' % (get_cookie("username"), product.product_name) db.add(ops_log) db.commit() websock.update_cache("product", product_id=product.id) redirect(__prefix__)
def issues_add_post(db, render): oprs = [(o.operator_name, o.operator_name) for o in db.query(models.SlcOperator)] form = issues_forms.issues_add_form(oprs) if not form.validates(source=request.forms): return render("base_form", form=form) if db.query(models.SlcRadAccount).filter_by(account_number=form.d.account_number).count() == 0: return render("base_form", form=form,msg=u"用户账号不存在") issues = models.SlcIssues() issues.account_number = form.d.account_number issues.issues_type = form.d.issues_type issues.content = form.d.content issues.assign_operator = form.d.assign_operator issues.status = 0 issues.date_time = utils.get_currtime() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)创建新工单' % (get_cookie("username") ) db.add(ops_log) db.add(issues) db.commit() redirect("/issues/list")
def admin_login_post(db): uname = request.forms.get("username") upass = request.forms.get("password") if not uname:return dict(code=1,msg=u"请填写用户名") if not upass:return dict(code=1,msg=u"请填写密码") enpasswd = md5(upass.encode()).hexdigest() opr = db.query(models.SlcOperator).filter_by( operator_name=uname, operator_pass=enpasswd ).first() if not opr:return dict(code=1,msg=u"用户名密码不符") if opr.operator_status == 1:return dict(code=1,msg=u"该操作员账号已被停用") set_cookie('username',uname) set_cookie('opr_type',opr.operator_type) set_cookie('login_time', utils.get_currtime()) set_cookie('login_ip', request.remote_addr) if opr.operator_type > 0: permit.unbind_opr(uname) for rule in db.query(models.SlcOperatorRule).filter_by(operator_name=uname): permit.bind_opr(rule.operator_name,rule.rule_path) ops_log = models.SlcRadOperateLog() ops_log.operator_name = uname ops_log.operate_ip = request.remote_addr ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)登陆'%(uname,) db.add(ops_log) db.commit() return dict(code=0,msg="ok")
def product_update(db, render): form = product_forms.product_update_form() if not form.validates(source=request.forms): return render("sys_product_form", form=form) product = db.query(models.SlcRadProduct).get(form.d.id) product.product_name = form.d.product_name product.product_status = form.d.product_status product.fee_months = int(form.d.get("fee_months", 0)) product.fee_times = utils.hour2sec(form.d.get("fee_times", 0)) product.fee_flows = utils.mb2kb(form.d.get("fee_flows", 0)) product.bind_mac = form.d.bind_mac product.bind_vlan = form.d.bind_vlan product.concur_number = form.d.concur_number product.fee_period = form.d.fee_period product.fee_price = utils.yuan2fen(form.d.fee_price) product.input_max_limit = utils.mbps2bps(form.d.input_max_limit) product.output_max_limit = utils.mbps2bps(form.d.output_max_limit) product.update_time = utils.get_currtime() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)修改资费信息:%s' % ( get_cookie("username"), product.product_name) db.add(ops_log) db.commit() websock.update_cache("product", product_id=product.id) redirect(__prefix__)
def admin_login_post(db): uname = request.forms.get("username") upass = request.forms.get("password") if not uname: return dict(code=1, msg=u"请填写用户名") if not upass: return dict(code=1, msg=u"请填写密码") enpasswd = md5(upass.encode()).hexdigest() opr = db.query(models.SlcOperator).filter_by( operator_name=uname, operator_pass=enpasswd).first() if not opr: return dict(code=1, msg=u"用户名密码不符") if opr.operator_status == 1: return dict(code=1, msg=u"该操作员账号已被停用") set_cookie('username', uname) set_cookie('opr_type', opr.operator_type) set_cookie('login_time', utils.get_currtime()) set_cookie('login_ip', request.remote_addr) if opr.operator_type > 0: permit.unbind_opr(uname) for rule in db.query( models.SlcOperatorRule).filter_by(operator_name=uname): permit.bind_opr(rule.operator_name, rule.rule_path) ops_log = models.SlcRadOperateLog() ops_log.operator_name = uname ops_log.operate_ip = request.remote_addr ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)登陆' % (uname, ) db.add(ops_log) db.commit() return dict(code=0, msg="ok")
def issues_process_post(db, render): form = issues_forms.issues_process_form() if not form.validates(source=request.forms): return render("base_form", form=form) iflow = models.SlcIssuesFlow() iflow.issues_id = form.d.issues_id iflow.accept_time = utils.get_currtime() iflow.accept_status = form.d.accept_status iflow.accept_result = form.d.accept_result iflow.operator_name = get_cookie("username") db.add(iflow) issues = db.query(models.SlcIssues).get(iflow.issues_id) issues.status = iflow.accept_status ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)处理工单%s' % (get_cookie("username"), iflow.issues_id) db.add(ops_log) db.commit() redirect("/issues/detail?issues_id=%s" % iflow.issues_id)
def issues_add_post(db, render): oprs = [(o.operator_name, o.operator_name) for o in db.query(models.SlcOperator)] form = issues_forms.issues_add_form(oprs) if not form.validates(source=request.forms): return render("base_form", form=form) if db.query(models.SlcRadAccount).filter_by( account_number=form.d.account_number).count() == 0: return render("base_form", form=form, msg=u"用户账号不存在") issues = models.SlcIssues() issues.account_number = form.d.account_number issues.issues_type = form.d.issues_type issues.content = form.d.content issues.assign_operator = form.d.assign_operator issues.status = 0 issues.date_time = utils.get_currtime() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)创建新工单' % (get_cookie("username")) db.add(ops_log) db.add(issues) db.commit() redirect("/issues/list")
def account_pause(db, render): account_number = request.params.get("account_number") account = db.query(models.SlcRadAccount).get(account_number) if account.status != 1: return dict(msg=u"用户当前状态不允许停机") _datetime = utils.get_currtime() account.last_pause = _datetime account.status = 2 accept_log = models.SlcRadAcceptLog() accept_log.accept_type = 'pause' accept_log.accept_source = 'console' accept_log.accept_desc = u"用户停机:上网账号:%s" % (account_number) accept_log.account_number = account.account_number accept_log.accept_time = _datetime accept_log.operator_name = get_cookie("username") db.add(accept_log) db.commit() websock.update_cache("account", account_number=account.account_number) onlines = db.query(models.SlcRadOnline).filter_by(account_number=account_number) for _online in onlines: websock.invoke_admin("coa_request", nas_addr=_online.nas_addr, acct_session_id=_online.acct_session_id, message_type='disconnect') return dict(msg=u"操作成功")
def account_update_post(db, render): form = account_forms.account_update_form() if not form.validates(source=request.forms): return render("base_form", form=form) account = db.query(models.SlcRadAccount).get(form.d.account_number) account.ip_address = form.d.ip_address account.install_address = form.d.install_address account.user_concur_number = form.d.user_concur_number account.bind_mac = form.d.bind_mac account.bind_vlan = form.d.bind_vlan account.account_desc = form.d.account_desc if form.d.new_password: account.password = utils.encrypt(form.d.new_password) ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)修改上网账号信息:%s' % (get_cookie("username"), account.account_number) db.add(ops_log) db.commit() websock.update_cache("account", account_number=account.account_number) redirect(member_detail_url_formatter(account.account_number))
def member_update_post(db, render): nodes = [(n.id, n.node_name) for n in get_opr_nodes(db)] form = member_forms.member_update_form(nodes) if not form.validates(source=request.forms): return render("base_form", form=form) member = db.query(models.SlcMember).get(form.d.member_id) member.realname = form.d.realname if form.d.new_password: member.password = md5(form.d.new_password.encode()).hexdigest() member.email = form.d.email member.idcard = form.d.idcard member.mobile = form.d.mobile member.address = form.d.address member.member_desc = form.d.member_desc ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)修改用户信息:%s' % (get_cookie("username"), member.member_name) db.add(ops_log) db.commit() redirect(member_detail_url_formatter(form.d.account_number))
def account_resume(db,render): account_number = request.params.get("account_number") account = db.query(models.SlcRadAccount).get(account_number) if account.status != 2: return dict(msg=u"用户当前状态不允许复机") account.status = 1 _datetime = datetime.datetime.now() _pause_time = datetime.datetime.strptime(account.last_pause, "%Y-%m-%d %H:%M:%S") _expire_date = datetime.datetime.strptime(account.expire_date + ' 23:59:59', "%Y-%m-%d %H:%M:%S") days = (_expire_date - _pause_time).days new_expire = (_datetime + datetime.timedelta(days=int(days))).strftime("%Y-%m-%d") account.expire_date = new_expire accept_log = models.SlcRadAcceptLog() accept_log.accept_type = 'resume' accept_log.accept_source = 'console' accept_log.accept_desc = u"用户复机:上网账号:%s" % (account_number) accept_log.account_number = account.account_number accept_log.accept_time = utils.get_currtime() accept_log.operator_name = get_cookie("username") db.add(accept_log) db.commit() websock.update_cache("account", account_number=account.account_number) return dict(msg=u"操作成功")
def account_delete(db, render): account_number = request.params.get("account_number") if not account_number: raise abort(404, 'account_number is empty') account = db.query(models.SlcRadAccount).get(account_number) member_id = account.member_id db.query(models.SlcRadAcceptLog).filter_by(account_number=account.account_number).delete() db.query(models.SlcRadAccountAttr).filter_by(account_number=account.account_number).delete() db.query(models.SlcRadBilling).filter_by(account_number=account.account_number).delete() db.query(models.SlcRadTicket).filter_by(account_number=account.account_number).delete() db.query(models.SlcRadOnline).filter_by(account_number=account.account_number).delete() db.query(models.SlcRechargeLog).filter_by(account_number=account.account_number).delete() db.query(models.SlcRadAccount).filter_by(account_number=account.account_number).delete() db.query(models.SlcMemberOrder).filter_by(account_number=account.account_number).delete() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)删除用户账号%s' % (get_cookie("username"), account_number) db.add(ops_log) db.commit() return redirect("/member")
def member_login_post(db, render): next = request.params.get("next", "/") form = forms.member_login_form() if not form.validates(source=request.params): return render("login", form=form) if vcache.is_over(form.d.username, '0'): return render("error", msg=u"用户一小时内登录错误超过5次,请一小时后再试") member = db.query(models.SlcMember).filter_by( member_name=form.d.username ).first() if not member: return render("login", form=form, msg=u"用户不存在") if member.password != md5(form.d.password.encode()).hexdigest(): vcache.incr(form.d.username, '0') print vcache.validates return render("login", form=form, msg=u"用户名密码错误第%s次" % vcache.errs(form.d.username, '0')) vcache.clear(form.d.username, '0') set_cookie('customer_id', member.member_id, path="/") set_cookie('customer', form.d.username,path="/") set_cookie('customer_login_time', utils.get_currtime(), path="/") set_cookie('customer_login_ip', request.remote_addr, path="/") redirect(next)
def member_delete(db, render): member_id = request.params.get("member_id") if not member_id: raise abort(404, 'member_id is empty') db.query(models.SlcMember).filter_by(member_id=member_id).delete() for account in db.query(models.SlcRadAccount).filter_by(member_id=member_id): db.query(models.SlcRadAcceptLog).filter_by(account_number=account.account_number).delete() db.query(models.SlcRadAccountAttr).filter_by(account_number=account.account_number).delete() db.query(models.SlcRadBilling).filter_by(account_number=account.account_number).delete() db.query(models.SlcRadTicket).filter_by(account_number=account.account_number).delete() db.query(models.SlcRadOnline).filter_by(account_number=account.account_number).delete() db.query(models.SlcRechargeLog).filter_by(account_number=account.account_number).delete() db.query(models.SlcRadAccount).filter_by(member_id=member_id).delete() db.query(models.SlcMemberOrder).filter_by(member_id=member_id).delete() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)删除用户%s' % (get_cookie("username"), member_id) db.add(ops_log) db.commit() return redirect("/member")
def cmanager_add_post(db): form=cmanager_forms.cmanage_add_form() if not form.validates(source=request.forms): return render("base_form", form=form) if db.query(models.SlcCustomerManager).filter( models.SlcCustomerManager.manager_code==form.d.manager_code).count()>0: return render("base_form",form=form,msg=u"工号重复") if db.query(models.SlcCustomerManager).filter( models.SlcCustomerManager.active_code==form.d.active_code).count()>0: return render("base_form",form=form,msg=u"激活码重复") cmanager = models.SlcCustomerManager() cmanager.manager_code = form.d.manager_code cmanager.manager_name = form.d.manager_name cmanager.manager_mobile = form.d.manager_mobile cmanager.manager_email = form.d.manager_email cmanager.active_code = form.d.active_code cmanager.active_status = 0 cmanager.create_time = utils.get_currtime() db.add(cmanager) db.commit() redirect("/cmanager/list")
def product_add_post(db, render): form = product_forms.product_add_form() if not form.validates(source=request.forms): return render("sys_product_form", form=form) product = models.SlcRadProduct() product.product_name = form.d.product_name product.product_policy = form.d.product_policy product.product_status = form.d.product_status product.fee_months = int(form.d.get("fee_months", 0)) product.fee_times = utils.hour2sec(form.d.get("fee_times", 0)) product.fee_flows = utils.mb2kb(form.d.get("fee_flows", 0)) product.bind_mac = form.d.bind_mac product.bind_vlan = form.d.bind_vlan product.concur_number = form.d.concur_number product.fee_period = form.d.fee_period product.fee_price = utils.yuan2fen(form.d.fee_price) product.input_max_limit = utils.mbps2bps(form.d.input_max_limit) product.output_max_limit = utils.mbps2bps(form.d.output_max_limit) _datetime = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") product.create_time = _datetime product.update_time = _datetime db.add(product) ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)新增资费信息:%s' % (get_cookie("username"), product.product_name) db.add(ops_log) db.commit() redirect(__prefix__)
def opr_add_update(db, render): nodes = [(n.node_name, n.node_desc) for n in db.query(models.SlcNode)] form = opr_forms.opr_update_form(nodes) if not form.validates(source=request.forms): rules = db.query(models.SlcOperatorRule.rule_path).filter_by( operator_name=opr.operator_name) rules = [r[0] for r in rules] return render("sys_opr_form", form=form, rules=rules) opr = db.query(models.SlcOperator).get(form.d.id) if form.d.operator_pass: opr.operator_pass = md5(form.d.operator_pass).hexdigest() opr.operator_desc = form.d.operator_desc opr.operator_status = form.d.operator_status db.query(models.SlcOperatorNodes).filter_by( operator_name=opr.operator_name).delete() for node in request.params.getall("operator_nodes"): onode = models.SlcOperatorNodes() onode.operator_name = form.d.operator_name onode.node_name = node db.add(onode) db.query(models.SlcOperatorProducts).filter_by( operator_name=opr.operator_name).delete() for product_id in request.params.getall("operator_products"): oproduct = models.SlcOperatorProducts() oproduct.operator_name = form.d.operator_name oproduct.product_id = product_id db.add(oproduct) # update rules db.query(models.SlcOperatorRule).filter_by( operator_name=opr.operator_name).delete() for path in request.params.getall("rule_item"): item = permit.get_route(path) if not item: continue rule = models.SlcOperatorRule() rule.operator_name = opr.operator_name rule.rule_name = item['name'] rule.rule_path = item['path'] rule.rule_category = item['category'] db.add(rule) permit.unbind_opr(opr.operator_name) for rule in db.query( models.SlcOperatorRule).filter_by(operator_name=opr.operator_name): permit.bind_opr(rule.operator_name, rule.rule_path) ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)修改操作员信息:%s' % (get_cookie("username"), opr.operator_name) db.add(ops_log) db.commit() redirect("/opr")
def bas_add_post(db): form = forms.bas_add_form() if not form.validates(source=request.forms): return render("base_form", form=form) if db.query( models.SlcRadBas.id).filter_by(ip_addr=form.d.ip_addr).count() > 0: return render("base_form", form=form, msg=u"Bas地址已经存在") bas = models.SlcRadBas() bas.ip_addr = form.d.ip_addr bas.bas_name = form.d.bas_name bas.time_type = form.d.time_type bas.vendor_id = form.d.vendor_id bas.bas_secret = form.d.bas_secret bas.coa_port = form.d.coa_port db.add(bas) ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)新增BAS信息:%s' % (get_cookie("username"), bas.ip_addr) db.add(ops_log) db.commit() redirect("/bas")
def param_update(db): params = db.query(models.SlcParam) for param in params: if param.param_name in request.forms: _value = request.forms.get(param.param_name) if _value: param.param_value = _value ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)修改参数' % (get_cookie("username")) db.add(ops_log) db.commit() websock.reconnect( request.forms.get('radiusd_address'), request.forms.get('radiusd_admin_port'), ) is_debug = request.forms.get('is_debug') bottle.debug(is_debug == '1') websock.update_cache("is_debug", is_debug=is_debug) websock.update_cache("reject_delay", reject_delay=request.forms.get('reject_delay')) websock.update_cache("param") redirect("/param")
def product_add_post(db, render): form = product_forms.product_add_form() if not form.validates(source=request.forms): return render("sys_product_form", form=form) product = models.SlcRadProduct() product.product_name = form.d.product_name product.product_policy = form.d.product_policy product.product_status = form.d.product_status product.fee_months = int(form.d.get("fee_months", 0)) product.fee_times = utils.hour2sec(form.d.get("fee_times", 0)) product.fee_flows = utils.mb2kb(form.d.get("fee_flows", 0)) product.bind_mac = form.d.bind_mac product.bind_vlan = form.d.bind_vlan product.concur_number = form.d.concur_number product.fee_period = form.d.fee_period product.fee_price = utils.yuan2fen(form.d.fee_price) product.input_max_limit = utils.mbps2bps(form.d.input_max_limit) product.output_max_limit = utils.mbps2bps(form.d.output_max_limit) _datetime = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") product.create_time = _datetime product.update_time = _datetime db.add(product) ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)新增资费信息:%s' % ( get_cookie("username"), product.product_name) db.add(ops_log) db.commit() redirect(__prefix__)
def roster_add_post(db): form = forms.roster_add_form() if not form.validates(source=request.forms): return render("sys_roster_form", form=form) if db.query(models.SlcRadRoster.id).filter_by( mac_addr=form.d.mac_addr).count() > 0: return render("sys_roster_form", form=form, msg=u"MAC地址已经存在") roster = models.SlcRadRoster() roster.mac_addr = form.d.mac_addr.replace("-", ":").upper() roster.begin_time = form.d.begin_time roster.end_time = form.d.end_time roster.roster_type = form.d.roster_type db.add(roster) ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)新增黑白名单信息:%s' % (get_cookie("username"), roster.mac_addr) db.add(ops_log) db.commit() websock.update_cache("roster", mac_addr=roster.mac_addr) redirect("/roster")
def member_login_post(db): next = request.params.get("next", "/") form = forms.member_login_form() if not form.validates(source=request.params): return render("login", form=form) if vcache.is_over(form.d.username, '0'): return render("error", msg=u"用户一小时内登录错误超过5次,请一小时后再试") member = db.query( models.SlcMember).filter_by(member_name=form.d.username).first() if not member: return render("login", form=form, msg=u"用户不存在") if member.password != md5(form.d.password.encode()).hexdigest(): vcache.incr(form.d.username, '0') print vcache.validates return render("login", form=form, msg=u"用户名密码错误第%s次" % vcache.errs(form.d.username, '0')) vcache.clear(form.d.username, '0') set_cookie('customer_id', member.member_id) set_cookie('customer', form.d.username) set_cookie('customer_login_time', utils.get_currtime()) set_cookie('customer_login_ip', request.remote_addr) redirect(next)
def param_update(db): params = db.query(models.SlcParam) for param in params: if param.param_name in request.forms: _value = request.forms.get(param.param_name) if _value: param.param_value = _value ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)修改参数'%(get_cookie("username")) db.add(ops_log) db.commit() websock.reconnect( request.forms.get('radiusd_address'), request.forms.get('radiusd_admin_port'), ) is_debug = request.forms.get('is_debug') bottle.debug(is_debug == '1') websock.update_cache("is_debug",is_debug=is_debug) websock.update_cache("reject_delay",reject_delay=request.forms.get('reject_delay')) websock.update_cache("param") redirect("/param")
def member_join_post(db): nodes = [(n.id, n.node_name) for n in db.query(models.SlcNode)] form = forms.member_join_form(nodes) if not form.validates(source=request.params): return render("join", form=form) if db.query(exists().where( models.SlcMember.member_name == form.d.username)).scalar(): return render("join", form=form, msg=u"用户{0}已被使用".format(form.d.username)) if db.query( exists().where(models.SlcMember.email == form.d.email)).scalar(): return render("join", form=form, msg=u"用户邮箱{0}已被使用".format(form.d.email)) member = models.SlcMember() member.node_id = form.d.node_id member.realname = form.d.realname member.member_name = form.d.username member.password = md5(form.d.password.encode()).hexdigest() member.idcard = form.d.idcard member.sex = form.d.sex member.age = int(form.d.age) member.email = form.d.email member.mobile = form.d.mobile member.address = form.d.address member.create_time = utils.get_currtime() member.update_time = utils.get_currtime() member.email_active = 0 member.mobile_active = 0 member.active_code = utils.get_uuid() db.add(member) db.commit() topic = u'%s,请验证您在%s注册的电子邮件地址' % ( member.realname, get_param_value(db, "customer_system_name")) ctx = dict(username=member.realname, customer_name=get_param_value(db, "customer_system_name"), customer_url=get_param_value(db, "customer_system_url"), active_code=member.active_code) reactor.callInThread(mail.sendmail, member.email, topic, render("mail", **ctx)) return render('msg', msg=u"新用户注册成功,请注意查收您的注册邮箱,及时激活账户")
def opr_add_update(db, render): nodes = [(n.node_name, n.node_desc) for n in db.query(models.SlcNode)] form = opr_forms.opr_update_form(nodes) if not form.validates(source=request.forms): rules = db.query(models.SlcOperatorRule.rule_path).filter_by(operator_name=opr.operator_name) rules = [r[0] for r in rules] return render("sys_opr_form", form=form, rules=rules) opr = db.query(models.SlcOperator).get(form.d.id) if form.d.operator_pass: opr.operator_pass = md5(form.d.operator_pass).hexdigest() opr.operator_desc = form.d.operator_desc opr.operator_status = form.d.operator_status db.query(models.SlcOperatorNodes).filter_by(operator_name=opr.operator_name).delete() for node in request.params.getall("operator_nodes"): onode = models.SlcOperatorNodes() onode.operator_name = form.d.operator_name onode.node_name = node db.add(onode) db.query(models.SlcOperatorProducts).filter_by(operator_name=opr.operator_name).delete() for product_id in request.params.getall("operator_products"): oproduct = models.SlcOperatorProducts() oproduct.operator_name = form.d.operator_name oproduct.product_id = product_id db.add(oproduct) # update rules db.query(models.SlcOperatorRule).filter_by(operator_name=opr.operator_name).delete() for path in request.params.getall("rule_item"): item = permit.get_route(path) if not item: continue rule = models.SlcOperatorRule() rule.operator_name = opr.operator_name rule.rule_name = item['name'] rule.rule_path = item['path'] rule.rule_category = item['category'] db.add(rule) permit.unbind_opr(opr.operator_name) for rule in db.query(models.SlcOperatorRule).filter_by(operator_name=opr.operator_name): permit.bind_opr(rule.operator_name, rule.rule_path) ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)修改操作员信息:%s' % (get_cookie("username"), opr.operator_name) db.add(ops_log) db.commit() redirect("/opr")
def member_join_post(db, render): nodes = [ (n.id,n.node_name) for n in db.query(models.SlcNode)] form = forms.member_join_form(nodes) if not form.validates(source=request.params): return render("join", form=form) if db.query(exists().where(models.SlcMember.member_name == form.d.username)).scalar(): return render("join",form=form,msg=u"用户{0}已被使用".format(form.d.username)) if db.query(exists().where(models.SlcMember.email == form.d.email)).scalar(): return render("join",form=form,msg=u"用户邮箱{0}已被使用".format(form.d.email)) member = models.SlcMember() member.node_id = form.d.node_id member.realname = form.d.realname member.member_name = form.d.username member.password = md5(form.d.password.encode()).hexdigest() member.idcard = form.d.idcard member.sex = form.d.sex member.age = int(form.d.age) member.email = form.d.email member.mobile = form.d.mobile member.address = form.d.address member.create_time = utils.get_currtime() member.update_time = utils.get_currtime() member.email_active = 0 member.mobile_active = 0 member.active_code = utils.get_uuid() db.add(member) db.commit() topic = u'%s,请验证您在%s注册的电子邮件地址'%(member.realname,get_param_value(db,"customer_system_name")) ctx = dict( username = member.realname, customer_name = get_param_value(db,"customer_system_name"), customer_url = get_param_value(db,"customer_system_url"), active_code = member.active_code ) reactor.callInThread(mail.sendmail,member.email,topic,render("mail",**ctx)) return render('msg',msg=u"新用户注册成功,请注意查收您的注册邮箱,及时激活账户")
def bas_delete(db): bas_id = request.params.get("bas_id") db.query(models.SlcRadBas).filter_by(id=bas_id).delete() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)删除BAS信息:%s'%(get_cookie("username"),bas_id) db.add(ops_log) db.commit() redirect("/bas")
def bas_delete(db): bas_id = request.params.get("bas_id") db.query(models.SlcRadBas).filter_by(id=bas_id).delete() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)删除BAS信息:%s' % (get_cookie("username"), bas_id) db.add(ops_log) db.commit() redirect("/bas")
def opr_add_post(db, render): nodes = [(n.node_name, n.node_desc) for n in db.query(models.SlcNode)] products = [(p.id, p.product_name) for p in db.query(models.SlcRadProduct)] form = opr_forms.opr_add_form(nodes, products) if not form.validates(source=request.forms): return render("sys_opr_form", form=form, rules=[]) if db.query(models.SlcOperator.id).filter_by( operator_name=form.d.operator_name).count() > 0: return render("sys_opr_form", form=form, rules=[], msg=u"操作员已经存在") opr = models.SlcOperator() opr.operator_name = form.d.operator_name opr.operator_type = 1 opr.operator_pass = md5(form.d.operator_pass).hexdigest() opr.operator_desc = form.d.operator_desc opr.operator_status = form.d.operator_status db.add(opr) for node in request.params.getall("operator_nodes"): onode = models.SlcOperatorNodes() onode.operator_name = form.d.operator_name onode.node_name = node db.add(onode) for product_id in request.params.getall("operator_products"): oproduct = models.SlcOperatorProducts() oproduct.operator_name = form.d.operator_name oproduct.product_id = product_id db.add(oproduct) for path in request.params.getall("rule_item"): item = permit.get_route(path) if not item: continue rule = models.SlcOperatorRule() rule.operator_name = opr.operator_name rule.rule_name = item['name'] rule.rule_path = item['path'] rule.rule_category = item['category'] db.add(rule) ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)新增操作员信息:%s' % (get_cookie("username"), opr.operator_name) db.add(ops_log) db.commit() redirect("/opr")
def opr_add_post(db, render): nodes = [(n.node_name, n.node_desc) for n in db.query(models.SlcNode)] products = [(p.id, p.product_name) for p in db.query(models.SlcRadProduct)] form = opr_forms.opr_add_form(nodes,products) if not form.validates(source=request.forms): return render("sys_opr_form", form=form, rules=[]) if db.query(models.SlcOperator.id).filter_by(operator_name=form.d.operator_name).count() > 0: return render("sys_opr_form", form=form, rules=[], msg=u"操作员已经存在") opr = models.SlcOperator() opr.operator_name = form.d.operator_name opr.operator_type = 1 opr.operator_pass = md5(form.d.operator_pass).hexdigest() opr.operator_desc = form.d.operator_desc opr.operator_status = form.d.operator_status db.add(opr) for node in request.params.getall("operator_nodes"): onode = models.SlcOperatorNodes() onode.operator_name = form.d.operator_name onode.node_name = node db.add(onode) for product_id in request.params.getall("operator_products"): oproduct = models.SlcOperatorProducts() oproduct.operator_name = form.d.operator_name oproduct.product_id = product_id db.add(oproduct) for path in request.params.getall("rule_item"): item = permit.get_route(path) if not item: continue rule = models.SlcOperatorRule() rule.operator_name = opr.operator_name rule.rule_name = item['name'] rule.rule_path = item['path'] rule.rule_category = item['category'] db.add(rule) ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)新增操作员信息:%s' % (get_cookie("username"), opr.operator_name) db.add(ops_log) db.commit() redirect("/opr")
def roster_delete(db): roster_id = request.params.get("roster_id") mac_addr = db.query(models.SlcRadRoster).get(roster_id).mac_addr db.query(models.SlcRadRoster).filter_by(id=roster_id).delete() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)删除黑白名单信息:%s'%(get_cookie("username"),roster_id) db.add(ops_log) db.commit() websock.update_cache("roster",mac_addr=mac_addr) redirect("/roster")
def node_delete(db): node_id = request.params.get("node_id") if db.query(models.SlcMember.member_id).filter_by(node_id=node_id).count()>0: return render("error",msg=u"该节点下有用户,不允许删除") db.query(models.SlcNode).filter_by(id=node_id).delete() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)删除区域信息:%s'%(get_cookie("username"),node_id) db.add(ops_log) db.commit() redirect("/node")
def issues_delete_post(db, render): issues_id = request.params.get("issues_id") db.query(models.SlcIssues).filter_by(id=issues_id).delete() db.query(models.SlcIssuesFlow).filter_by(issues_id=issues_id) ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)删除工单%s' % (get_cookie("username"), issues_id) db.add(ops_log) db.commit() redirect("/issues/list")
def product_attr_update(db): attr_id = request.params.get("attr_id") attr = db.query(models.SlcRadProductAttr).get(attr_id) product_id = attr.product_id db.query(models.SlcRadProductAttr).filter_by(id=attr_id).delete() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)删除资费属性信息:%s'%(get_cookie("username"),serial_json(attr)) db.add(ops_log) db.commit() websock.update_cache("product",product_id=product_id) redirect("%s/detail?product_id=%s"%(__prefix__,product_id))
def opr_delete(db): opr_id = request.params.get("opr_id") opr = db.query(models.SlcOperator).get(opr_id) db.query(models.SlcOperatorNodes).filter_by(operator_name=opr.operator_name).delete() db.query(models.SlcOperatorRule).filter_by(operator_name=opr.operator_name).delete() db.query(models.SlcOperator).filter_by(id=opr_id).delete() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)删除操作员信息:%s'%(get_cookie("username"),opr_id) db.add(ops_log) db.commit() redirect("/opr")
def admin_logout(db): ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)登出'%(get_cookie("username"),) db.add(ops_log) db.commit() if get_cookie('opt_type') > 0: permit.unbind_opr(get_cookie("username")) set_cookie('username',None) set_cookie('login_time', None) set_cookie('opr_type',None) set_cookie('login_ip', None) request.cookies.clear() redirect('/login')
def roster_delete(db): roster_id = request.params.get("roster_id") mac_addr = db.query(models.SlcRadRoster).get(roster_id).mac_addr db.query(models.SlcRadRoster).filter_by(id=roster_id).delete() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)删除黑白名单信息:%s' % (get_cookie("username"), roster_id) db.add(ops_log) db.commit() websock.update_cache("roster", mac_addr=mac_addr) redirect("/roster")
def admin_logout(db): ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)登出' % (get_cookie("username"), ) db.add(ops_log) db.commit() if get_cookie('opt_type') > 0: permit.unbind_opr(get_cookie("username")) set_cookie('username', None) set_cookie('login_time', None) set_cookie('opr_type', None) set_cookie('login_ip', None) request.cookies.clear() redirect('/login')
def card_recycle(db, render): card_id = request.params.get("card_id") if not card_id: return dict(code=0,msg=u"非法的访问") card = db.query(models.SlcRechargerCard).get(card_id) if not card: return dict(code=0,msg=u"充值卡不存在") card.card_status = 3 ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)回收充值卡[%s]'%(get_cookie("username"),card.card_number) db.add(ops_log) db.commit() return dict(code=0,msg=u"回收成功,充值卡已不可使用")
def card_recycle(db, render): card_id = request.params.get("card_id") if not card_id: return dict(code=0, msg=u"非法的访问") card = db.query(models.SlcRechargerCard).get(card_id) if not card: return dict(code=0, msg=u"充值卡不存在") card.card_status = 3 ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)回收充值卡[%s]' % (get_cookie("username"), card.card_number) db.add(ops_log) db.commit() return dict(code=0, msg=u"回收成功,充值卡已不可使用")
def node_add_update(db): form=forms.node_update_form() if not form.validates(source=request.forms): return render("base_form", form=form) node = db.query(models.SlcNode).get(form.d.id) node.node_name = form.d.node_name node.node_desc = form.d.node_desc ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)修改区域信息:%s'%(get_cookie("username"),node.node_name) db.add(ops_log) db.commit() redirect("/node")
def user_release(db, render): account_number = request.params.get("account_number") user = db.query(models.SlcRadAccount).filter_by(account_number=account_number).first() user.mac_addr = "" user.vlan_id = 0 user.vlan_id2 = 0 ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u"释放用户账号(%s)绑定信息" % (account_number,) db.add(ops_log) db.commit() websock.update_cache("account", account_number=account_number) return dict(code=0, msg=u"解绑成功")
def node_delete(db): node_id = request.params.get("node_id") if db.query( models.SlcMember.member_id).filter_by(node_id=node_id).count() > 0: return render("error", msg=u"该节点下有用户,不允许删除") db.query(models.SlcNode).filter_by(id=node_id).delete() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)删除区域信息:%s' % (get_cookie("username"), node_id) db.add(ops_log) db.commit() redirect("/node")
def product_attr_update(db, render): attr_id = request.params.get("attr_id") attr = db.query(models.SlcRadProductAttr).get(attr_id) product_id = attr.product_id db.query(models.SlcRadProductAttr).filter_by(id=attr_id).delete() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)删除资费属性信息:%s' % (get_cookie("username"), serial_json(attr)) db.add(ops_log) db.commit() websock.update_cache("product", product_id=product_id) redirect("%s/detail?product_id=%s" % (__prefix__, product_id))
def user_release(db, render): account_number = request.params.get('account_number') user = db.query( models.SlcRadAccount).filter_by(account_number=account_number).first() user.mac_addr = '' user.vlan_id = 0 user.vlan_id2 = 0 ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'释放用户账号(%s)绑定信息' % (account_number, ) db.add(ops_log) db.commit() websock.update_cache("account", account_number=account_number) return dict(code=0, msg=u"解绑成功")
def node_add_update(db): form = forms.node_update_form() if not form.validates(source=request.forms): return render("base_form", form=form) node = db.query(models.SlcNode).get(form.d.id) node.node_name = form.d.node_name node.node_desc = form.d.node_desc ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)修改区域信息:%s' % (get_cookie("username"), node.node_name) db.add(ops_log) db.commit() redirect("/node")
def passwd_update(db, render): form = forms.passwd_update_form() if not form.validates(source=request.forms): return render("base_form", form=form) if form.d.operator_pass != form.d.operator_pass_chk: return render("base_form", form=form, msg=u"确认密码不一致") opr = db.query(models.SlcOperator).filter_by(operator_name=form.d.operator_name).first() opr.operator_pass = md5(form.d.operator_pass).hexdigest() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)修改密码' % (get_cookie("username"),) db.add(ops_log) db.commit() redirect("/passwd")
def product_delete(db): product_id = request.params.get("product_id") if db.query(models.SlcRadAccount).filter_by(product_id=product_id).count()>0: return render("error",msg=u"该套餐有用户使用,不允许删除") if db.query(models.SlcRechargerCard).filter_by(product_id=product_id).count()>0: return render("error",msg=u"该套餐有发行充值卡,不允许删除") db.query(models.SlcRadProduct).filter_by(id=product_id).delete() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)删除资费信息:%s'%(get_cookie("username"),product_id) db.add(ops_log) db.commit() websock.update_cache("product",product_id=product_id) redirect(__prefix__)
def product_attr_update(db): form = forms.product_attr_update_form() if not form.validates(source=request.forms): return render("pattr_form", form=form,pattrs=radius_attrs) attr = db.query(models.SlcRadProductAttr).get(form.d.id) attr.attr_name = form.d.attr_name attr.attr_value = form.d.attr_value attr.attr_desc = form.d.attr_desc ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)修改资费属性信息:%s'%(get_cookie("username"),attr.attr_name) db.add(ops_log) db.commit() websock.update_cache("product",product_id=form.d.product_id) redirect("%s/detail?product_id=%s"%(__prefix__,form.d.product_id))
def roster_add_update(db): form=forms.roster_update_form() if not form.validates(source=request.forms): return render("sys_roster_form", form=form) roster = db.query(models.SlcRadRoster).get(form.d.id) roster.begin_time = form.d.begin_time roster.end_time = form.d.end_time roster.roster_type = form.d.roster_type ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)修改黑白名单信息:%s'%(get_cookie("username"),roster.mac_addr) db.add(ops_log) db.commit() websock.update_cache("roster",mac_addr=roster.mac_addr) redirect("/roster")
def opr_delete(db): opr_id = request.params.get("opr_id") opr = db.query(models.SlcOperator).get(opr_id) db.query(models.SlcOperatorNodes).filter_by( operator_name=opr.operator_name).delete() db.query(models.SlcOperatorRule).filter_by( operator_name=opr.operator_name).delete() db.query(models.SlcOperator).filter_by(id=opr_id).delete() ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)删除操作员信息:%s' % (get_cookie("username"), opr_id) db.add(ops_log) db.commit() redirect("/opr")
def product_attr_update(db, render): form = product_forms.product_attr_update_form() if not form.validates(source=request.forms): return render("pattr_form", form=form, pattrs=radius_attrs) attr = db.query(models.SlcRadProductAttr).get(form.d.id) attr.attr_name = form.d.attr_name attr.attr_value = form.d.attr_value attr.attr_desc = form.d.attr_desc ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)修改资费属性信息:%s' % (get_cookie("username"), attr.attr_name) db.add(ops_log) db.commit() websock.update_cache("product", product_id=form.d.product_id) redirect("%s/detail?product_id=%s" % (__prefix__, form.d.product_id))
def roster_add_update(db): form = forms.roster_update_form() if not form.validates(source=request.forms): return render("sys_roster_form", form=form) roster = db.query(models.SlcRadRoster).get(form.d.id) roster.begin_time = form.d.begin_time roster.end_time = form.d.end_time roster.roster_type = form.d.roster_type ops_log = models.SlcRadOperateLog() ops_log.operator_name = get_cookie("username") ops_log.operate_ip = get_cookie("login_ip") ops_log.operate_time = utils.get_currtime() ops_log.operate_desc = u'操作员(%s)修改黑白名单信息:%s' % (get_cookie("username"), roster.mac_addr) db.add(ops_log) db.commit() websock.update_cache("roster", mac_addr=roster.mac_addr) redirect("/roster")