def calc(self, months, product_id, old_expire, giftdays):
product = self.db.query(models.TrProduct).get(product_id)
# 预付费时长，预付费流量，
if product.product_policy in (PPTimes,PPFlow):
return dict(policy=product.product_policy,fee_value=0,expire_date=MAX_EXPIRE_DATE)
# 买断时长 买断流量
elif product.product_policy in (BOTimes,BOFlows):
fee_value = utils.fen2yuan(product.fee_price)
return dict(policy=product.product_policy,fee_value=fee_value,expire_date=MAX_EXPIRE_DATE)
# 预付费包月
elif product.product_policy == PPMonth:
fee = decimal.Decimal(months) * decimal.Decimal(product.fee_price)
fee_value = utils.fen2yuan(int(fee.to_integral_value()))
start_expire = datetime.datetime.now()
if old_expire:
start_expire = datetime.datetime.strptime(old_expire,"%Y-%m-%d")
expire_date = utils.add_months(start_expire,int(months),days=giftdays)
expire_date = expire_date.strftime( "%Y-%m-%d")
return dict(policy=product.product_policy,fee_value=fee_value,expire_date=expire_date)
# 买断包月
elif product.product_policy == BOMonth:
start_expire = datetime.datetime.now()
if old_expire:
start_expire = datetime.datetime.strptime(old_expire,"%Y-%m-%d")
fee_value = utils.fen2yuan(product.fee_price)
expire_date = utils.add_months(start_expire,product.fee_months,days=giftdays)
expire_date = expire_date.strftime( "%Y-%m-%d")
return dict(policy=product.product_policy,fee_value=fee_value,expire_date=expire_date)
def post(self):
months = self.get_argument('months', 0)
product_id = self.get_argument("product_id", None)
old_expire = self.get_argument("old_expire", None)
product = self.db.query(models.TrProduct).get(product_id)
# 预付费时长，预付费流量，
if product.product_policy in (PPTimes, PPFlow):
return self.render_json(code=0,
data=dict(policy=product.product_policy,
fee_value=0,
expire_date=MAX_EXPIRE_DATE))
# 买断时长 买断流量
elif product.product_policy in (BOTimes, BOFlows):
fee_value = utils.fen2yuan(product.fee_price)
return self.render_json(code=0,
data=dict(policy=product.product_policy,
fee_value=fee_value,
expire_date=MAX_EXPIRE_DATE))
# 预付费包月
elif product.product_policy == PPMonth:
fee = decimal.Decimal(months) * decimal.Decimal(product.fee_price)
fee_value = utils.fen2yuan(int(fee.to_integral_value()))
start_expire = datetime.datetime.now()
if old_expire:
start_expire = datetime.datetime.strptime(
old_expire, "%Y-%m-%d")
expire_date = utils.add_months(start_expire, int(months))
expire_date = expire_date.strftime("%Y-%m-%d")
return self.render_json(code=0,
data=dict(policy=product.product_policy,
fee_value=fee_value,
expire_date=expire_date))
# 买断包月
elif product.product_policy == BOMonth:
start_expire = datetime.datetime.now()
if old_expire:
start_expire = datetime.datetime.strptime(
old_expire, "%Y-%m-%d")
fee_value = utils.fen2yuan(product.fee_price)
expire_date = utils.add_months(start_expire, product.fee_months)
expire_date = expire_date.strftime("%Y-%m-%d")
return self.render_json(code=0,
data=dict(policy=product.product_policy,
fee_value=fee_value,
expire_date=expire_date))
def post(self):
account_number = self.get_argument("account_number")
account = self.db.query(models.TrAccount).get(account_number)
user = self.query_account(account_number)
form = account_forms.account_charge_form()
if account.status not in (1, 4):
return render("account_form", user=user, form=form, msg=u"无效用户状态")
if not form.validates(source=self.get_params()):
return render("account_form", user=user, form=form)
accept_log = models.TrAcceptLog()
accept_log.accept_type = 'charge'
accept_log.accept_source = 'console'
_new_fee = account.balance + utils.yuan2fen(form.d.fee_value)
accept_log.accept_desc = u"用户充值：充值前%s元,充值后%s元;%s" % (
utils.fen2yuan(account.balance),
utils.fen2yuan(_new_fee),
(form.d.operate_desc or '')
)
accept_log.account_number = form.d.account_number
accept_log.accept_time = utils.get_currtime()
accept_log.operator_name = self.current_user.username
self.db.add(accept_log)
self.db.flush()
self.db.refresh(accept_log)
order = models.TrCustomerOrder()
order.order_id = utils.gen_order_id()
order.customer_id = user.customer_id
order.product_id = user.product_id
order.account_number = form.d.account_number
order.order_fee = utils.yuan2fen(form.d.fee_value)
order.actual_fee = utils.yuan2fen(form.d.fee_value)
order.pay_status = 1
order.accept_id = accept_log.id
order.order_source = 'console'
order.create_time = utils.get_currtime()
order.order_desc = accept_log.accept_desc
self.db.add(order)
self.add_oplog(order.order_desc)
account.balance += order.actual_fee
self.db.commit()
self.redirect(self.detail_url_fmt(account_number))
def post(self):
account_number = self.get_argument("account_number")
account = self.db.query(models.TrAccount).get(account_number)
user = self.query_account(account_number)
form = account_forms.account_charge_form()
if account.status not in (1, 4):
return render("account_form", user=user, form=form, msg=u"无效用户状态")
if not form.validates(source=self.get_params()):
return render("account_form", user=user, form=form)
accept_log = models.TrAcceptLog()
accept_log.accept_type = 'charge'
accept_log.accept_source = 'console'
_new_fee = account.balance + utils.yuan2fen(form.d.fee_value)
accept_log.accept_desc = u"用户充值：充值前%s元,充值后%s元;%s" % (
utils.fen2yuan(account.balance), utils.fen2yuan(_new_fee),
(form.d.operate_desc or ''))
accept_log.account_number = form.d.account_number
accept_log.accept_time = utils.get_currtime()
accept_log.operator_name = self.current_user.username
self.db.add(accept_log)
self.db.flush()
self.db.refresh(accept_log)
order = models.TrCustomerOrder()
order.order_id = utils.gen_order_id()
order.customer_id = user.customer_id
order.product_id = user.product_id
order.account_number = form.d.account_number
order.order_fee = utils.yuan2fen(form.d.fee_value)
order.actual_fee = utils.yuan2fen(form.d.fee_value)
order.pay_status = 1
order.accept_id = accept_log.id
order.order_source = 'console'
order.create_time = utils.get_currtime()
order.order_desc = accept_log.accept_desc
self.db.add(order)
self.add_oplog(order.order_desc)
account.balance += order.actual_fee
self.db.commit()
self.redirect(self.detail_url_fmt(account_number))
def post(self):
months = self.get_argument("months", 0)
product_id = self.get_argument("product_id", None)
old_expire = self.get_argument("old_expire", None)
product = self.db.query(models.TrProduct).get(product_id)
# 预付费时长，预付费流量，
if product.product_policy in (PPTimes, PPFlow):
return self.render_json(
code=0, data=dict(policy=product.product_policy, fee_value=0, expire_date=MAX_EXPIRE_DATE)
)
# 买断时长 买断流量
elif product.product_policy in (BOTimes, BOFlows):
fee_value = utils.fen2yuan(product.fee_price)
return self.render_json(
code=0, data=dict(policy=product.product_policy, fee_value=fee_value, expire_date=MAX_EXPIRE_DATE)
)
# 预付费包月
elif product.product_policy == PPMonth:
fee = decimal.Decimal(months) * decimal.Decimal(product.fee_price)
fee_value = utils.fen2yuan(int(fee.to_integral_value()))
start_expire = datetime.datetime.now()
if old_expire:
start_expire = datetime.datetime.strptime(old_expire, "%Y-%m-%d")
expire_date = utils.add_months(start_expire, int(months))
expire_date = expire_date.strftime("%Y-%m-%d")
return self.render_json(
code=0, data=dict(policy=product.product_policy, fee_value=fee_value, expire_date=expire_date)
)
# 买断包月
elif product.product_policy == BOMonth:
start_expire = datetime.datetime.now()
if old_expire:
start_expire = datetime.datetime.strptime(old_expire, "%Y-%m-%d")
fee_value = utils.fen2yuan(product.fee_price)
expire_date = utils.add_months(start_expire, product.fee_months)
expire_date = expire_date.strftime("%Y-%m-%d")
return self.render_json(
code=0, data=dict(policy=product.product_policy, fee_value=fee_value, expire_date=expire_date)
)
def get(self):
product_id = self.get_argument("product_id")
form = product_forms.product_update_form()
product = self.db.query(models.TrProduct).get(product_id)
form.fill(product)
form.product_policy_name.set_value(product_forms.product_policy[product.product_policy])
form.fee_times.set_value(utils.sec2hour(product.fee_times))
form.fee_flows.set_value(utils.kb2mb(product.fee_flows))
form.input_max_limit.set_value(utils.bps2mbps(product.input_max_limit))
form.output_max_limit.set_value(utils.bps2mbps(product.output_max_limit))
form.fee_price.set_value(utils.fen2yuan(product.fee_price))
return self.render("product_form.html", form=form)
def get(self):
product_id = self.get_argument("product_id")
form = product_forms.product_update_form()
product = self.db.query(models.TrProduct).get(product_id)
form.fill(product)
form.product_policy_name.set_value(
product_forms.product_policy[product.product_policy])
form.fee_times.set_value(utils.sec2hour(product.fee_times))
form.fee_flows.set_value(utils.kb2mb(product.fee_flows))
form.input_max_limit.set_value(utils.bps2mbps(product.input_max_limit))
form.output_max_limit.set_value(
utils.bps2mbps(product.output_max_limit))
form.fee_price.set_value(utils.fen2yuan(product.fee_price))
return self.render("product_form.html", form=form)
def post(self):
node_id = self.get_argument('node_id', None)
realname = self.get_argument('realname', None)
idcard = self.get_argument('idcard', None)
mobile = self.get_argument('mobile', None)
user_name = self.get_argument('user_name', None)
status = self.get_argument('status', None)
product_id = self.get_argument('product_id', None)
address = self.get_argument('address', None)
expire_days = self.get_argument('expire_days', None)
opr_nodes = self.get_opr_nodes()
_query = self.db.query(
models.TrCustomer,
models.TrAccount,
models.TrProduct.product_name,
models.TrNode.node_desc
).filter(
models.TrProduct.id == models.TrAccount.product_id,
models.TrCustomer.customer_id == models.TrAccount.customer_id,
models.TrNode.id == models.TrCustomer.node_id
)
_now = datetime.datetime.now()
if idcard:
_query = _query.filter(models.TrCustomer.idcard == idcard)
if mobile:
_query = _query.filter(models.TrCustomer.mobile == mobile)
if node_id:
_query = _query.filter(models.TrCustomer.node_id == node_id)
else:
_query = _query.filter(models.TrCustomer.node_id.in_([i.id for i in opr_nodes]))
if realname:
_query = _query.filter(models.TrCustomer.realname.like('%' + realname + '%'))
if user_name:
_query = _query.filter(models.TrAccount.account_number.like('%' + user_name + '%'))
#用户状态判断
if status:
if status == '4':
_query = _query.filter(models.TrAccount.expire_date <= _now.strftime("%Y-%m-%d"))
elif status == '1':
_query = _query.filter(
models.TrAccount.status == status,
models.TrAccount.expire_date >= _now.strftime("%Y-%m-%d")
)
else:
_query = _query.filter(models.TrAccount.status == status)
if product_id:
_query = _query.filter(models.TrAccount.product_id == product_id)
if address:
_query = _query.filter(models.TrCustomer.address.like('%' + address + '%'))
if expire_days:
_days = int(expire_days)
td = datetime.timedelta(days=_days)
edate = (_now + td).strftime("%Y-%m-%d")
_query = _query.filter(models.TrAccount.expire_date <= edate)
_query = _query.filter(models.TrAccount.expire_date >= _now.strftime("%Y-%m-%d"))
if self.request.path == '/admin/customer':
return self.render("customer_list.html",
page_data=self.get_page_data(_query),
node_list=opr_nodes,
products=self.db.query(models.TrProduct),
**self.get_params())
elif self.request.path == "/admin/customer/export":
data = Dataset()
data.append((
u'区域', u'姓名', u'证件号', u'邮箱', u'联系电话', u'地址',
u'用户账号', u'密码', u'资费', u'过期时间', u'余额(元)',
u'时长(小时)', u'流量(MB)', u'并发数', u'ip地址', u'状态', u'创建时间'
))
for i, j, _product_name, _node_desc in _query:
data.append((
_node_desc, i.realname, i.idcard, i.email, i.mobile, i.address,
j.account_number, self.aes.decrypt(j.password), _product_name,
j.expire_date, utils.fen2yuan(j.balance),
utils.sec2hour(j.time_length), utils.kb2mb(j.flow_length), j.user_concur_number, j.ip_address,
customer_forms.user_state[j.status], j.create_time
))
name = u"RADIUS-USER-" + datetime.datetime.now().strftime("%Y%m%d-%H%M%S") + ".xls"
self.export_file(name, data)
