Django values_list

  2. ## https://www.jb51.net/article/183872.htm
  4. alarm_columns = (
  5.         "create_time", "policy__name", "node",
  6.         "policy__level", "status", "comment"
  7.     )
  10.     tmp_values = objs.values_list(*alarm_columns)

Django translation

  1. from django.utils.translation import ugettext as _ 
  2. ## https://blog.csdn.net/zhuyue14/article/details/87618067
  4.  values = []
  5.     for tmp_value in tmp_values:
  6.         value = list(tmp_value)
  7.         value[0] = '{0:%Y-%m-%d %H:%M:%S}'.format(
  8.             value[0].astimezone(fixed_offset)
  9.         )
  10.         value[3] = _(
  11.             level_map[value[3]]
  12.         ) if value[3] in level_map else _(
  13.             Policy.level_value(value[3])
  14.         )
  15.         value[4] = _(
  16.             status_map[value[4]]
  17.         ) if value[4] in status_map else ""
  19.         values.append(value)
  23.      def translate(self, param):
  24.         if isinstance(param, str):
  25.             return _(param)
  26.         if isinstance(param, list):
  27.             ret = []
  28.             for item in param:
  29.                 if isinstance(item, str):
  30.                     ret.append(_(item))
  31.                 elif isinstance(item, list):
  32.                     ret.append(self.translate(item))
  33.             else:
  34.                 return ret
  35.         return None

namedtuple

  1.   from collections import namedtuple
  3.   """Returns a new subclass of tuple with named fields.
  4.     ##def namedtuple(typename, field_names, *, rename=False, defaults=None, module=None):
  6.     >>> Point = namedtuple('Point', ['x', 'y'])
  7.     >>> Point.__doc__                   # docstring for the new class
  8.     'Point(x, y)'
  9.     >>> p = Point(11, y=22)             # instantiate with positional args or keywords
  10.     >>> p[0] + p[1]                     # indexable like a plain tuple
  11.     33
  12.     >>> x, y = p                        # unpack like a regular tuple
  13.     >>> x, y
  14.     (11, 22)
  15.     >>> p.x + p.y                       # fields also accessible by name
  16.     33
  17.     >>> d = p._asdict()                 # convert to a dictionary
  18.     >>> d['x']
  19.     11
  20.     >>> Point(**d)                      # convert from a dictionary
  21.     Point(x=11, y=22)
  22.     >>> p._replace(x=100)               # _replace() is like str.replace() but targets named fields
  23.     Point(x=100, y=22)
  25. """
  27.     context_tuple = namedtuple(
  28.         "context",
  29.         [
  30.             'data', 'start_time', 'end_time',
  31.             'creator', 'create_time', 'operator'
  32.         ]
  33.     )
  34.     return context_tuple(
  35.         values,
  36.         start_time.astimezone(fixed_offset),
  37.         end_time.astimezone(fixed_offset),
  38.         data['creator'],
  39.         create_time.astimezone(fixed_offset),
  40.         settings.LICO.ARCH
  41.     )._asdict()

html 说明

  1. {% comment %} https://www.runoob.com/tags/ref-byfunc.html {% endcomment %}
  2. {% comment %} <html>    定义一个 HTML 文档 {% endcomment %}
  3. {% comment %} <title>    为文档定义一个标题 {% endcomment %}
  4. {% comment %} <body>    定义文档的主体 {% endcomment %}
  5. {% comment %} <h1> to <h6>    定义 HTML 标题 {% endcomment %}
  6. {% comment %} <span>    定义文档中的节。 {% endcomment %}
  8. {% comment %} <table>    定义一个表格 {% endcomment %}
  9. {% comment %} <caption>    定义表格标题。 {% endcomment %}
  10. {% comment %} <thead>    定义表格中的表头内容。 {% endcomment %}
  11. {% comment %} <th> 定义表格中的表头单元格 {% endcomment %}
  12. {% comment %} <tr>    定义表格中的行。 {% endcomment %}
  13. {% comment %} <td>    定义表格中的单元。 {% endcomment %}
  14. {% comment %} <tbody>    定义表格中的主体内容。 {% endcomment %}
  15. {% comment %} <tfoot>    定义表格中的表注内容（脚注）. {% endcomment %}

测试验证

  1. from lico.core.accounting.views.deposit import *
  2. import requests
  3. import time
  5. request = requests
  7. request.data = {
  8.     "language" : "sc",
  9.     "bill_group" : 1,
  10.     "start_time" : "1615169036",
  11.     "end_time" : str(int(time.time())),
  12.     "timezone_offset" :"-480"
  13. }
  16. # filename = "billing_group_details.html"
  17. # filename = "billing_group_details.pdf"
  18. filename = "billing_group_details.xlsx"
  20. aa=DepositReportView()
  23. response = aa.post(request, filename)
  25. ## 这三种方式 都可以写   ； postman 也有  Save to a  file  选项
  26. # with open("daiyi.test.html","wb") as file:
  27. # with open("daiyi.test.pdf","wb") as file:
  28. with open("daiyi.test.xlsx","wb") as file:
  29.     for data in response:
  30.         file.write(data)
  34. """
  35. https://10.240.208.84/api/download/alert/report/alert_statistics.xlsx/
  37. Request URL: https://10.240.208.84/api/download/alert/report/alert_details.xlsx/
  38. Request Method: POST
  41. timezone_offset: -480
  42. creator: hpcadmin
  43. language: en
  44. start_time: 1612800000
  45. end_time: 1616083199
  46. page_direction: landscape
  47. event_level: 0
  48. ## they are requst_body
  50. """

deposits_report.htmlstyle.cssdeposit.pyreportbase.py