def get(self, output_format='xlsx', user_id=None,
start_time=None, end_time=None,
limit=None, offset=None):
"""Export all charges of special user, output formats supported:
* Excel (Sets + Books)
* JSON (Sets + Books)
* YAML (Sets + Books)
* HTML (Sets)
* TSV (Sets)
* CSV (Sets)
"""
if output_format.lower() not in ["xls", "xlsx", "csv", "json", "yaml"]:
raise exception.InvalidOutputFormat(output_format=output_format)
if limit and limit < 0:
raise exception.InvalidParameterValue(err="Invalid limit")
if offset and offset < 0:
raise exception.InvalidParameterValue(err="Invalid offset")
limit_user_id = acl.get_limited_to_user(request.headers,
'export_charges')
if limit_user_id:
user_id = limit_user_id
headers = (u"充值记录ID", u"充值对象用户名", u"充值对象ID", u"充值对象真实姓名",
u"充值对象邮箱", u"充值对象公司", u"充值金额", u"充值类型",
u"充值来源", u"充值人员ID", u"充值人员用户名", u"充值时间", u"状态")
data = []
users = {}
def _get_user(user_id):
user = users.get(user_id)
if user:
return user
contact = keystone.get_uos_user(user_id) or {}
user_name = contact.get('name')
email = contact.get('email')
real_name = contact.get('real_name') or 'unknown'
mobile = contact.get('mobile_number') or 'unknown'
company = contact.get('company') or 'unknown'
users[user_id] = models.User(user_id=user_id,
user_name=user_name,
email=email,
real_name=real_name,
mobile=mobile,
company=company)
return users[user_id]
self.conn = pecan.request.db_conn
charges = self.conn.get_charges(request.context,
user_id=user_id,
limit=limit,
offset=offset,
start_time=start_time,
end_time=end_time)
for charge in charges:
charge.charge_time += datetime.timedelta(hours=8)
acharge = models.Charge.from_db_model(charge)
acharge.actor = _get_user(charge.operator)
acharge.target = _get_user(charge.user_id)
charge_time = \
timeutils.strtime(charge.charge_time, fmt=OUTPUT_TIME_FORMAT)
adata = (acharge.charge_id, acharge.target.user_name,
acharge.target.user_id, acharge.target.real_name,
acharge.target.email, acharge.target.company,
str(acharge.value), acharge.type, acharge.come_from,
acharge.actor.user_id, acharge.actor.user_name,
charge_time, u"正常")
data.append(adata)
data = tablib.Dataset(*data, headers=headers)
response.content_type = "application/binary; charset=UTF-8"
response.content_disposition = \
"attachment; filename=charges.%s" % output_format
content = getattr(data, output_format)
if output_format == 'csv':
content = content.decode("utf-8").encode("gb2312")
response.write(content)
return response
def get_all(self, output_format='xlsx', type=None, status=None,
start_time=None, end_time=None, limit=None, offset=None,
region_id=None, project_id=None, user_id=None, owed=None):
"""Get queried orders
If start_time and end_time is not None, will get orders that have bills
during start_time and end_time, or return all orders directly.
"""
limit_user_id = acl.get_limited_to_user(request.headers,
'export_orders')
if limit and limit < 0:
raise exception.InvalidParameterValue(err="Invalid limit")
if offset and offset < 0:
raise exception.InvalidParameterValue(err="Invalid offset")
if limit_user_id: # normal user
user_id = None
projects = keystone.get_projects_by_user(limit_user_id)
_project_ids = [project['id'] for project in projects]
if project_id and project_id in _project_ids:
project_ids = [project_id]
else:
project_ids = _project_ids
else: # accountant
if project_id: # look up specified project
project_ids = [project_id]
else: # look up all projects
project_ids = []
if project_ids:
project_ids = list(set(project_ids) - set(cfg.CONF.ignore_tenants))
users = {}
projects = {}
def _get_user(user_id):
user = users.get(user_id)
if user:
return user
contact = keystone.get_uos_user(user_id)
user_name = contact['name'] if contact else None
users[user_id] = models.User(user_id=user_id,
user_name=user_name)
return users[user_id]
def _get_project(project_id):
project = projects.get(project_id)
if project:
return project
project = keystone.get_project(project_id)
project_name = project.name if project else None
projects[project_id] = models.SimpleProject(
project_id=project_id,
project_name=project_name
)
return projects[project_id]
MAP = [
{"running": u"运行中",
"stopped": u"暂停中",
"deleted": u"被删除"},
{"instance": u"虚拟机",
"image": u"镜像",
"snapshot": u"硬盘快照",
"volume": u"云硬盘",
"share": u"共享文件",
"floatingip": u"公网IP",
"listener": u"负载均衡监听器",
"router": u"路由器",
"alarm": u"监控报警"},
]
headers = (u"资源ID", u"资源名称", u"资源类型",
u"资源状态", u"单价(元/小时)", u"金额(元)",
u"区域", u"用户ID", u"用户名称", u"项目ID",
u"项目名称", u"创建时间")
data = []
adata = (u"过滤条件: 资源类型: %s, 资源状态: %s，用户ID: %s, 项目ID: %s, 区域: %s, 起始时间: %s, 结束时间: %s" %
(type, status, user_id, project_id, region_id, start_time, end_time),
"", "", "", "", "", "", "", "", "", "", "")
data.append(adata)
conn = pecan.request.db_conn
orders_db, total_count = conn.get_orders(request.context,
type=type,
status=status,
start_time=start_time,
end_time=end_time,
owed=owed,
limit=limit,
offset=offset,
with_count=True,
region_id=region_id,
user_id=user_id,
project_ids=project_ids)
for order in orders_db:
price = self._get_order_price(order,
start_time=start_time,
end_time=end_time)
user = _get_user(order.user_id)
project = _get_project(order.project_id)
order.created_at += datetime.timedelta(hours=8)
created_at = \
timeutils.strtime(order.created_at, fmt=OUTPUT_TIME_FORMAT)
adata = (order.resource_id, order.resource_name,
MAP[1][order.type], MAP[0][order.status],
order.unit_price, price, order.region_id,
user.user_id, user.user_name,
project.project_id, project.project_name,
created_at)
data.append(adata)
data = tablib.Dataset(*data, headers=headers)
response.content_type = "application/binary; charset=UTF-8"
response.content_disposition = \
"attachment; filename=orders.%s" % output_format
content = getattr(data, output_format)
if output_format == 'csv':
content = content.decode("utf-8").encode("gb2312")
response.write(content)
return response
def get(self, output_format='xlsx', user_id=None,
start_time=None, end_time=None,
limit=None, offset=None, all_get=False):
"""Export all charges of special user, output formats supported:
* Excel (Sets + Books)
* YAML (Sets + Books)
* HTML (Sets)
* TSV (Sets)
* CSV (Sets)
* JSON (Sets)
"""
policy.check_policy(HOOK.context, "charges:export",
action="charges:export")
tablib.formats.json.json = json
if output_format.lower() not in ["xls", "xlsx", "csv", "yaml", "json"]:
raise exception.InvalidOutputFormat(output_format=output_format)
if limit and limit < 0:
raise exception.InvalidParameterValue(err="Invalid limit")
if offset and offset < 0:
raise exception.InvalidParameterValue(err="Invalid offset")
policy.check_policy(HOOK.context, "charges:export",
action="charges:export")
if all_get and acl.context_is_admin(HOOK.headers):
user_id = None
headers = (u"充值记录ID", u"充值对象用户名", u"充值对象ID",
u"充值对象邮箱", u"充值金额", u"充值类型",
u"充值来源", u"充值人员ID",
u"充值人员用户名", u"充值时间", u"状态")
data = []
users = {}
def _get_user(user_id):
if not user_id:
return models.User(user_id=None,
user_name=None,
email=None)
user = users.get(user_id)
if user:
return user
contact = ks_client.get_user(user_id) or {}
user_name = contact.get('name')
email = contact.get('email')
users[user_id] = models.User(user_id=user_id,
user_name=user_name,
email=email)
return users[user_id]
charges = HOOK.conductor_rpcapi.get_charges(
HOOK.context,
user_id=user_id,
limit=limit,
offset=offset,
start_time=start_time,
end_time=end_time)
for charge in charges:
charge_st = timeutils.str2ts(charge['charge_time']) + (3600 * 8)
charge['charge_time'] = timeutils.ts2str(charge_st)
acharge = models.Charge.from_db_model(charge)
acharge.actor = _get_user(charge['operator'])
acharge.target = _get_user(charge['user_id'])
charge_time = charge['charge_time']
adata = (acharge.charge_id, acharge.target.user_name,
acharge.target.user_id, acharge.target.email,
str(acharge.value), acharge.type, acharge.come_from,
acharge.actor.user_id, acharge.actor.user_name,
charge_time, u"正常")
data.append(adata)
data = tablib.Dataset(*data, headers=headers)
response.content_type = "application/binary; charset=UTF-8"
response.content_disposition = \
"attachment; filename=charges.%s" % output_format
# content = getattr(data, output_format)
content = data.export(output_format)
response.write(content)
return response
def get_all(self, output_format='xlsx', type=None, status=None,
start_time=None, end_time=None, limit=None, marker=None,
project_id=None, user_id=None, owed=None,
all_get=False):
"""Get queried orders
If start_time and end_time is not None, will get orders that have bills
during start_time and end_time, or return all orders directly.
"""
policy.check_policy(HOOK.context, "charges:export",
action="charges:export")
tablib.formats.json.json = json
_gnocchi_fetcher = fetcher.GnocchiFetcher()
if limit and limit < 0:
raise exception.InvalidParameterValue(err="Invalid limit")
policy.check_policy(HOOK.context, "charges:export",
action="charges:export")
if all_get and acl.context_is_admin(HOOK.headers):
user_id = None
MAP = {"instance": u"虚拟机",
"volume": u"云硬盘",
"image": u"镜像",
"ratelimit": u"限速",
"network_lbaas_loadbalancer": u"负载均衡"}
headers = (u"资源ID", u"资源名称", u"资源类型",
u"金额(元)", u"用户ID", u"项目ID",
u"创建时间")
data = []
adata = (u"过滤条件: 资源类型: %s, 用户ID: %s, "
u"项目ID: %s, 起始时间: %s, 结束时间: %s" %
(type, user_id, project_id,
start_time, end_time),
"", "", "", "", "", "")
data.append(adata)
resources = []
for service in MAP:
resources += _gnocchi_fetcher.get_resources(project_id, service)
for resource in resources:
if 'total.cost' in resource['metrics']:
price = _gnocchi_fetcher.get_resource_price(
resource['metrics']['total.cost'], start_time, end_time)
adata = (resource['id'], resource['display_name'],
MAP[resource['type']], price,
resource['user_id'], resource['project_id'],
resource['started_at'])
data.append(adata)
data = tablib.Dataset(*data, headers=headers)
response.content_type = "application/binary; charset=UTF-8"
response.content_disposition = \
"attachment; filename=orders.%s" % output_format
content = getattr(data, output_format)
response.write(content)
return response
def get(self,
output_format='xlsx',
user_id=None,
start_time=None,
end_time=None,
limit=None,
offset=None):
"""Export all charges of special user, output formats supported:
* Excel (Sets + Books)
* JSON (Sets + Books)
* YAML (Sets + Books)
* HTML (Sets)
* TSV (Sets)
* CSV (Sets)
"""
if output_format.lower() not in ["xls", "xlsx", "csv", "json", "yaml"]:
raise exception.InvalidOutputFormat(output_format=output_format)
if limit and limit < 0:
raise exception.InvalidParameterValue(err="Invalid limit")
if offset and offset < 0:
raise exception.InvalidParameterValue(err="Invalid offset")
limit_user_id = acl.get_limited_to_user(request.headers,
'export_charges')
if limit_user_id:
user_id = limit_user_id
headers = (u"充值记录ID", u"充值对象用户名", u"充值对象ID", u"充值对象真实姓名", u"充值对象邮箱",
u"充值对象公司", u"充值金额", u"充值类型", u"充值来源", u"充值人员ID", u"充值人员用户名",
u"充值时间", u"状态")
data = []
users = {}
def _get_user(user_id):
user = users.get(user_id)
if user:
return user
contact = kunkka.get_uos_user(user_id) or {}
user_name = contact.get('name')
email = contact.get('email')
real_name = contact.get('real_name') or 'unknown'
mobile = contact.get('phone') or 'unknown'
company = contact.get('company') or 'unknown'
users[user_id] = models.User(user_id=user_id,
user_name=user_name,
email=email,
real_name=real_name,
mobile=mobile,
company=company)
return users[user_id]
self.conn = pecan.request.db_conn
charges = self.conn.get_charges(request.context,
user_id=user_id,
limit=limit,
offset=offset,
start_time=start_time,
end_time=end_time)
for charge in charges:
charge.charge_time += datetime.timedelta(hours=8)
acharge = models.Charge.from_db_model(charge)
acharge.actor = _get_user(charge.operator)
acharge.target = _get_user(charge.user_id)
charge_time = \
timeutils.strtime(charge.charge_time, fmt=OUTPUT_TIME_FORMAT)
adata = (acharge.charge_id, acharge.target.user_name,
acharge.target.user_id, acharge.target.real_name,
acharge.target.email, acharge.target.company,
str(acharge.value), acharge.type, acharge.come_from,
acharge.actor.user_id, acharge.actor.user_name,
charge_time, u"正常")
data.append(adata)
data = tablib.Dataset(*data, headers=headers)
response.content_type = "application/binary; charset=UTF-8"
response.content_disposition = \
"attachment; filename=charges.%s" % output_format
content = getattr(data, output_format)
if output_format == 'csv':
content = content.decode("utf-8").encode("gb2312")
response.write(content)
return response
def get_all(self,
output_format='xlsx',
type=None,
status=None,
start_time=None,
end_time=None,
limit=None,
offset=None,
region_id=None,
project_id=None,
user_id=None,
owed=None):
"""Get queried orders
If start_time and end_time is not None, will get orders that have bills
during start_time and end_time, or return all orders directly.
"""
limit_user_id = acl.get_limited_to_user(request.headers,
'export_orders')
if limit and limit < 0:
raise exception.InvalidParameterValue(err="Invalid limit")
if offset and offset < 0:
raise exception.InvalidParameterValue(err="Invalid offset")
if limit_user_id: # normal user
user_id = None
projects = keystone.get_projects_by_user(limit_user_id)
_project_ids = [project['id'] for project in projects]
if project_id and project_id in _project_ids:
project_ids = [project_id]
else:
project_ids = _project_ids
else: # accountant
if project_id: # look up specified project
project_ids = [project_id]
else: # look up all projects
project_ids = []
if project_ids:
project_ids = list(set(project_ids) - set(cfg.CONF.ignore_tenants))
users = {}
projects = {}
def _get_user(user_id):
user = users.get(user_id)
if user:
return user
contact = kunkka.get_uos_user(user_id)
user_name = contact['name'] if contact else None
users[user_id] = models.User(user_id=user_id, user_name=user_name)
return users[user_id]
def _get_project(project_id):
project = projects.get(project_id)
if project:
return project
try:
project = keystone.get_project(project_id)
project_name = project.name if project else None
projects[project_id] = models.SimpleProject(
project_id=project_id, project_name=project_name)
return projects[project_id]
except Exception as e:
# Note(chengkun): some project was deleted from keystone,
# But the project's order still in the gringotts. so when
# we get the order it will raise 404 project not found error
LOG.error('error to get project: %s' % e)
return None
MAP = [
{
"running": u"运行中",
"stopped": u"暂停中",
"deleted": u"被删除"
},
{
"instance": u"虚拟机",
"image": u"镜像",
"snapshot": u"硬盘快照",
"volume": u"云硬盘",
"share": u"共享文件",
"floatingip": u"公网IP",
"listener": u"负载均衡监听器",
"router": u"路由器",
"alarm": u"监控报警"
},
]
headers = (u"资源ID", u"资源名称", u"资源类型", u"资源状态", u"单价(元/小时)", u"金额(元)",
u"区域", u"用户ID", u"用户名称", u"项目ID", u"项目名称", u"创建时间")
data = []
adata = (
u"过滤条件: 资源类型: %s, 资源状态: %s，用户ID: %s, 项目ID: %s, 区域: %s, 起始时间: %s, 结束时间: %s"
% (type, status, user_id, project_id, region_id, start_time,
end_time), "", "", "", "", "", "", "", "", "", "", "")
data.append(adata)
conn = pecan.request.db_conn
orders_db, total_count = conn.get_orders(request.context,
type=type,
status=status,
start_time=start_time,
end_time=end_time,
owed=owed,
limit=limit,
offset=offset,
with_count=True,
region_id=region_id,
user_id=user_id,
project_ids=project_ids)
for order in orders_db:
price = self._get_order_price(order,
start_time=start_time,
end_time=end_time)
user = _get_user(order.user_id)
project = _get_project(order.project_id)
if project is None:
continue
order.created_at += datetime.timedelta(hours=8)
created_at = \
timeutils.strtime(order.created_at, fmt=OUTPUT_TIME_FORMAT)
adata = (order.resource_id, order.resource_name,
MAP[1][order.type], MAP[0][order.status],
order.unit_price, price, order.region_id, user.user_id,
user.user_name, project.project_id, project.project_name,
created_at)
data.append(adata)
data = tablib.Dataset(*data, headers=headers)
response.content_type = "application/binary; charset=UTF-8"
response.content_disposition = \
"attachment; filename=orders.%s" % output_format
content = getattr(data, output_format)
if output_format == 'csv':
content = content.decode("utf-8").encode("gb2312")
response.write(content)
return response