tables.py 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862
  1. import django_tables2 as tables
  2. from django_tables2.utils import Accessor
  3. from tenancy.tables import COL_TENANT
  4. from utilities.tables import BaseTable, BooleanColumn, ColorColumn, ToggleColumn
  5. from .models import (
  6. Cable, ConsolePort, ConsolePortTemplate, ConsoleServerPort, ConsoleServerPortTemplate, Device, DeviceBay,
  7. DeviceBayTemplate, DeviceRole, DeviceType, FrontPort, FrontPortTemplate, Interface, InterfaceTemplate,
  8. InventoryItem, Manufacturer, Platform, PowerFeed, PowerOutlet, PowerOutletTemplate, PowerPanel, PowerPort,
  9. PowerPortTemplate, Rack, RackGroup, RackReservation, RackRole, RearPort, RearPortTemplate, Region, Site,
  10. VirtualChassis,
  11. )
  12. REGION_LINK = """
  13. {% if record.get_children %}
  14. <span style="padding-left: {{ record.get_ancestors|length }}0px "><i class="fa fa-caret-right"></i>
  15. {% else %}
  16. <span style="padding-left: {{ record.get_ancestors|length }}9px">
  17. {% endif %}
  18. <a href="{% url 'dcim:site_list' %}?region={{ record.slug }}">{{ record.name }}</a>
  19. </span>
  20. """
  21. SITE_REGION_LINK = """
  22. {% if record.region %}
  23. <a href="{% url 'dcim:site_list' %}?region={{ record.region.slug }}">{{ record.region }}</a>
  24. {% else %}
  25. &mdash;
  26. {% endif %}
  27. """
  28. COLOR_LABEL = """
  29. {% load helpers %}
  30. <label class="label" style="color: {{ record.color|fgcolor }}; background-color: #{{ record.color }}">{{ record }}</label>
  31. """
  32. DEVICE_LINK = """
  33. <a href="{% url 'dcim:device' pk=record.pk %}">
  34. {{ record.name|default:'<span class="label label-info">Unnamed device</span>' }}
  35. </a>
  36. """
  37. REGION_ACTIONS = """
  38. <a href="{% url 'dcim:region_changelog' pk=record.pk %}" class="btn btn-default btn-xs" title="Changelog">
  39. <i class="fa fa-history"></i>
  40. </a>
  41. {% if perms.dcim.change_region %}
  42. <a href="{% url 'dcim:region_edit' pk=record.pk %}?return_url={{ request.path }}" class="btn btn-xs btn-warning"><i class="glyphicon glyphicon-pencil" aria-hidden="true"></i></a>
  43. {% endif %}
  44. """
  45. RACKGROUP_ACTIONS = """
  46. <a href="{% url 'dcim:rackgroup_changelog' pk=record.pk %}" class="btn btn-default btn-xs" title="Changelog">
  47. <i class="fa fa-history"></i>
  48. </a>
  49. <a href="{% url 'dcim:rack_elevation_list' %}?site={{ record.site.slug }}&group_id={{ record.pk }}" class="btn btn-xs btn-primary" title="View elevations">
  50. <i class="fa fa-eye"></i>
  51. </a>
  52. {% if perms.dcim.change_rackgroup %}
  53. <a href="{% url 'dcim:rackgroup_edit' pk=record.pk %}?return_url={{ request.path }}" class="btn btn-xs btn-warning" title="Edit">
  54. <i class="glyphicon glyphicon-pencil"></i>
  55. </a>
  56. {% endif %}
  57. """
  58. RACKROLE_ACTIONS = """
  59. <a href="{% url 'dcim:rackrole_changelog' pk=record.pk %}" class="btn btn-default btn-xs" title="Changelog">
  60. <i class="fa fa-history"></i>
  61. </a>
  62. {% if perms.dcim.change_rackrole %}
  63. <a href="{% url 'dcim:rackrole_edit' pk=record.pk %}?return_url={{ request.path }}" class="btn btn-xs btn-warning"><i class="glyphicon glyphicon-pencil" aria-hidden="true"></i></a>
  64. {% endif %}
  65. """
  66. RACK_ROLE = """
  67. {% if record.role %}
  68. <label class="label" style="background-color: #{{ record.role.color }}">{{ value }}</label>
  69. {% else %}
  70. &mdash;
  71. {% endif %}
  72. """
  73. RACK_DEVICE_COUNT = """
  74. <a href="{% url 'dcim:device_list' %}?rack_id={{ record.pk }}">{{ value }}</a>
  75. """
  76. RACKRESERVATION_ACTIONS = """
  77. <a href="{% url 'dcim:rackreservation_changelog' pk=record.pk %}" class="btn btn-default btn-xs" title="Changelog">
  78. <i class="fa fa-history"></i>
  79. </a>
  80. {% if perms.dcim.change_rackreservation %}
  81. <a href="{% url 'dcim:rackreservation_edit' pk=record.pk %}?return_url={{ request.path }}" class="btn btn-xs btn-warning"><i class="glyphicon glyphicon-pencil" aria-hidden="true"></i></a>
  82. {% endif %}
  83. """
  84. MANUFACTURER_ACTIONS = """
  85. <a href="{% url 'dcim:manufacturer_changelog' slug=record.slug %}" class="btn btn-default btn-xs" title="Changelog">
  86. <i class="fa fa-history"></i>
  87. </a>
  88. {% if perms.dcim.change_manufacturer %}
  89. <a href="{% url 'dcim:manufacturer_edit' slug=record.slug %}?return_url={{ request.path }}" class="btn btn-xs btn-warning"><i class="glyphicon glyphicon-pencil" aria-hidden="true"></i></a>
  90. {% endif %}
  91. """
  92. DEVICEROLE_ACTIONS = """
  93. <a href="{% url 'dcim:devicerole_changelog' slug=record.slug %}" class="btn btn-default btn-xs" title="Changelog">
  94. <i class="fa fa-history"></i>
  95. </a>
  96. {% if perms.dcim.change_devicerole %}
  97. <a href="{% url 'dcim:devicerole_edit' slug=record.slug %}?return_url={{ request.path }}" class="btn btn-xs btn-warning"><i class="glyphicon glyphicon-pencil" aria-hidden="true"></i></a>
  98. {% endif %}
  99. """
  100. DEVICEROLE_DEVICE_COUNT = """
  101. <a href="{% url 'dcim:device_list' %}?role={{ record.slug }}">{{ value }}</a>
  102. """
  103. DEVICEROLE_VM_COUNT = """
  104. <a href="{% url 'virtualization:virtualmachine_list' %}?role={{ record.slug }}">{{ value }}</a>
  105. """
  106. PLATFORM_DEVICE_COUNT = """
  107. <a href="{% url 'dcim:device_list' %}?platform={{ record.slug }}">{{ value }}</a>
  108. """
  109. PLATFORM_VM_COUNT = """
  110. <a href="{% url 'virtualization:virtualmachine_list' %}?platform={{ record.slug }}">{{ value }}</a>
  111. """
  112. PLATFORM_ACTIONS = """
  113. <a href="{% url 'dcim:platform_changelog' slug=record.slug %}" class="btn btn-default btn-xs" title="Changelog">
  114. <i class="fa fa-history"></i>
  115. </a>
  116. {% if perms.dcim.change_platform %}
  117. <a href="{% url 'dcim:platform_edit' slug=record.slug %}?return_url={{ request.path }}" class="btn btn-xs btn-warning"><i class="glyphicon glyphicon-pencil" aria-hidden="true"></i></a>
  118. {% endif %}
  119. """
  120. DEVICE_ROLE = """
  121. {% load helpers %}
  122. <label class="label" style="color: {{ record.device_role.color|fgcolor }}; background-color: #{{ record.device_role.color }}">{{ value }}</label>
  123. """
  124. STATUS_LABEL = """
  125. <span class="label label-{{ record.get_status_class }}">{{ record.get_status_display }}</span>
  126. """
  127. TYPE_LABEL = """
  128. <span class="label label-{{ record.get_type_class }}">{{ record.get_type_display }}</span>
  129. """
  130. DEVICE_PRIMARY_IP = """
  131. {{ record.primary_ip6.address.ip|default:"" }}
  132. {% if record.primary_ip6 and record.primary_ip4 %}<br />{% endif %}
  133. {{ record.primary_ip4.address.ip|default:"" }}
  134. """
  135. SUBDEVICE_ROLE_TEMPLATE = """
  136. {% if record.subdevice_role == True %}Parent{% elif record.subdevice_role == False %}Child{% else %}&mdash;{% endif %}
  137. """
  138. DEVICETYPE_INSTANCES_TEMPLATE = """
  139. <a href="{% url 'dcim:device_list' %}?manufacturer_id={{ record.manufacturer_id }}&device_type_id={{ record.pk }}">{{ record.instance_count }}</a>
  140. """
  141. UTILIZATION_GRAPH = """
  142. {% load helpers %}
  143. {% utilization_graph value %}
  144. """
  145. VIRTUALCHASSIS_ACTIONS = """
  146. <a href="{% url 'dcim:virtualchassis_changelog' pk=record.pk %}" class="btn btn-default btn-xs" title="Changelog">
  147. <i class="fa fa-history"></i>
  148. </a>
  149. {% if perms.dcim.change_virtualchassis %}
  150. <a href="{% url 'dcim:virtualchassis_edit' pk=record.pk %}?return_url={{ request.path }}" class="btn btn-xs btn-warning"><i class="glyphicon glyphicon-pencil" aria-hidden="true"></i></a>
  151. {% endif %}
  152. """
  153. CABLE_TERMINATION_PARENT = """
  154. {% if value.device %}
  155. <a href="{{ value.device.get_absolute_url }}">{{ value.device }}</a>
  156. {% else %}
  157. <a href="{{ value.circuit.get_absolute_url }}">{{ value.circuit }}</a>
  158. {% endif %}
  159. """
  160. CABLE_LENGTH = """
  161. {% if record.length %}{{ record.length }} {{ record.get_length_unit_display }}{% else %}&mdash;{% endif %}
  162. """
  163. POWERPANEL_POWERFEED_COUNT = """
  164. <a href="{% url 'dcim:powerfeed_list' %}?power_panel_id={{ record.pk }}">{{ value }}</a>
  165. """
  166. #
  167. # Regions
  168. #
  169. class RegionTable(BaseTable):
  170. pk = ToggleColumn()
  171. name = tables.TemplateColumn(template_code=REGION_LINK, orderable=False)
  172. site_count = tables.Column(verbose_name='Sites')
  173. slug = tables.Column(verbose_name='Slug')
  174. actions = tables.TemplateColumn(
  175. template_code=REGION_ACTIONS,
  176. attrs={'td': {'class': 'text-right noprint'}},
  177. verbose_name=''
  178. )
  179. class Meta(BaseTable.Meta):
  180. model = Region
  181. fields = ('pk', 'name', 'site_count', 'slug', 'actions')
  182. #
  183. # Sites
  184. #
  185. class SiteTable(BaseTable):
  186. pk = ToggleColumn()
  187. name = tables.LinkColumn(order_by=('_nat1', '_nat2', '_nat3'))
  188. status = tables.TemplateColumn(template_code=STATUS_LABEL, verbose_name='Status')
  189. region = tables.TemplateColumn(template_code=SITE_REGION_LINK)
  190. tenant = tables.TemplateColumn(template_code=COL_TENANT)
  191. class Meta(BaseTable.Meta):
  192. model = Site
  193. fields = ('pk', 'name', 'status', 'facility', 'region', 'tenant', 'asn', 'description')
  194. #
  195. # Rack groups
  196. #
  197. class RackGroupTable(BaseTable):
  198. pk = ToggleColumn()
  199. name = tables.LinkColumn()
  200. site = tables.LinkColumn(
  201. viewname='dcim:site',
  202. args=[Accessor('site.slug')],
  203. verbose_name='Site'
  204. )
  205. rack_count = tables.Column(
  206. verbose_name='Racks'
  207. )
  208. slug = tables.Column()
  209. actions = tables.TemplateColumn(
  210. template_code=RACKGROUP_ACTIONS,
  211. attrs={'td': {'class': 'text-right noprint'}},
  212. verbose_name=''
  213. )
  214. class Meta(BaseTable.Meta):
  215. model = RackGroup
  216. fields = ('pk', 'name', 'site', 'rack_count', 'slug', 'actions')
  217. #
  218. # Rack roles
  219. #
  220. class RackRoleTable(BaseTable):
  221. pk = ToggleColumn()
  222. name = tables.LinkColumn(verbose_name='Name')
  223. rack_count = tables.Column(verbose_name='Racks')
  224. color = tables.TemplateColumn(COLOR_LABEL, verbose_name='Color')
  225. slug = tables.Column(verbose_name='Slug')
  226. actions = tables.TemplateColumn(template_code=RACKROLE_ACTIONS, attrs={'td': {'class': 'text-right noprint'}},
  227. verbose_name='')
  228. class Meta(BaseTable.Meta):
  229. model = RackRole
  230. fields = ('pk', 'name', 'rack_count', 'color', 'slug', 'actions')
  231. #
  232. # Racks
  233. #
  234. class RackTable(BaseTable):
  235. pk = ToggleColumn()
  236. name = tables.LinkColumn(order_by=('_nat1', '_nat2', '_nat3'))
  237. site = tables.LinkColumn('dcim:site', args=[Accessor('site.slug')])
  238. group = tables.Column(accessor=Accessor('group.name'), verbose_name='Group')
  239. tenant = tables.TemplateColumn(template_code=COL_TENANT)
  240. status = tables.TemplateColumn(STATUS_LABEL)
  241. role = tables.TemplateColumn(RACK_ROLE)
  242. u_height = tables.TemplateColumn("{{ record.u_height }}U", verbose_name='Height')
  243. class Meta(BaseTable.Meta):
  244. model = Rack
  245. fields = ('pk', 'name', 'site', 'group', 'status', 'facility_id', 'tenant', 'role', 'u_height')
  246. class RackDetailTable(RackTable):
  247. device_count = tables.TemplateColumn(
  248. template_code=RACK_DEVICE_COUNT,
  249. verbose_name='Devices'
  250. )
  251. get_utilization = tables.TemplateColumn(UTILIZATION_GRAPH, orderable=False, verbose_name='Utilization')
  252. get_power_utilization = tables.TemplateColumn(UTILIZATION_GRAPH, orderable=False, verbose_name='Power Utilization')
  253. class Meta(RackTable.Meta):
  254. fields = (
  255. 'pk', 'name', 'site', 'group', 'status', 'facility_id', 'tenant', 'role', 'u_height', 'device_count',
  256. 'get_utilization', 'get_power_utilization',
  257. )
  258. #
  259. # Rack reservations
  260. #
  261. class RackReservationTable(BaseTable):
  262. pk = ToggleColumn()
  263. site = tables.LinkColumn(
  264. viewname='dcim:site',
  265. accessor=Accessor('rack.site'),
  266. args=[Accessor('rack.site.slug')],
  267. )
  268. tenant = tables.TemplateColumn(template_code=COL_TENANT)
  269. rack = tables.LinkColumn('dcim:rack', args=[Accessor('rack.pk')])
  270. unit_list = tables.Column(orderable=False, verbose_name='Units')
  271. actions = tables.TemplateColumn(
  272. template_code=RACKRESERVATION_ACTIONS, attrs={'td': {'class': 'text-right noprint'}}, verbose_name=''
  273. )
  274. class Meta(BaseTable.Meta):
  275. model = RackReservation
  276. fields = ('pk', 'site', 'rack', 'unit_list', 'user', 'created', 'tenant', 'description', 'actions')
  277. #
  278. # Manufacturers
  279. #
  280. class ManufacturerTable(BaseTable):
  281. pk = ToggleColumn()
  282. name = tables.LinkColumn()
  283. devicetype_count = tables.Column(
  284. verbose_name='Device Types'
  285. )
  286. inventoryitem_count = tables.Column(
  287. verbose_name='Inventory Items'
  288. )
  289. platform_count = tables.Column(
  290. verbose_name='Platforms'
  291. )
  292. slug = tables.Column()
  293. actions = tables.TemplateColumn(
  294. template_code=MANUFACTURER_ACTIONS,
  295. attrs={'td': {'class': 'text-right noprint'}},
  296. verbose_name=''
  297. )
  298. class Meta(BaseTable.Meta):
  299. model = Manufacturer
  300. fields = ('pk', 'name', 'devicetype_count', 'inventoryitem_count', 'platform_count', 'slug', 'actions')
  301. #
  302. # Device types
  303. #
  304. class DeviceTypeTable(BaseTable):
  305. pk = ToggleColumn()
  306. model = tables.LinkColumn(
  307. viewname='dcim:devicetype',
  308. args=[Accessor('pk')],
  309. verbose_name='Device Type'
  310. )
  311. is_full_depth = BooleanColumn(verbose_name='Full Depth')
  312. subdevice_role = tables.TemplateColumn(
  313. template_code=SUBDEVICE_ROLE_TEMPLATE,
  314. verbose_name='Subdevice Role'
  315. )
  316. instance_count = tables.TemplateColumn(
  317. template_code=DEVICETYPE_INSTANCES_TEMPLATE,
  318. verbose_name='Instances'
  319. )
  320. class Meta(BaseTable.Meta):
  321. model = DeviceType
  322. fields = (
  323. 'pk', 'model', 'manufacturer', 'part_number', 'u_height', 'is_full_depth', 'subdevice_role',
  324. 'instance_count',
  325. )
  326. #
  327. # Device type components
  328. #
  329. class ConsolePortTemplateTable(BaseTable):
  330. pk = ToggleColumn()
  331. class Meta(BaseTable.Meta):
  332. model = ConsolePortTemplate
  333. fields = ('pk', 'name')
  334. empty_text = "None"
  335. class ConsoleServerPortTemplateTable(BaseTable):
  336. pk = ToggleColumn()
  337. class Meta(BaseTable.Meta):
  338. model = ConsoleServerPortTemplate
  339. fields = ('pk', 'name')
  340. empty_text = "None"
  341. class PowerPortTemplateTable(BaseTable):
  342. pk = ToggleColumn()
  343. class Meta(BaseTable.Meta):
  344. model = PowerPortTemplate
  345. fields = ('pk', 'name')
  346. empty_text = "None"
  347. class PowerOutletTemplateTable(BaseTable):
  348. pk = ToggleColumn()
  349. class Meta(BaseTable.Meta):
  350. model = PowerOutletTemplate
  351. fields = ('pk', 'name')
  352. empty_text = "None"
  353. class InterfaceTemplateTable(BaseTable):
  354. pk = ToggleColumn()
  355. mgmt_only = tables.TemplateColumn("{% if value %}OOB Management{% endif %}")
  356. class Meta(BaseTable.Meta):
  357. model = InterfaceTemplate
  358. fields = ('pk', 'name', 'mgmt_only', 'type')
  359. empty_text = "None"
  360. class FrontPortTemplateTable(BaseTable):
  361. pk = ToggleColumn()
  362. class Meta(BaseTable.Meta):
  363. model = FrontPortTemplate
  364. fields = ('pk', 'name', 'type', 'rear_port', 'rear_port_position')
  365. empty_text = "None"
  366. class RearPortTemplateTable(BaseTable):
  367. pk = ToggleColumn()
  368. class Meta(BaseTable.Meta):
  369. model = RearPortTemplate
  370. fields = ('pk', 'name', 'type', 'positions')
  371. empty_text = "None"
  372. class DeviceBayTemplateTable(BaseTable):
  373. pk = ToggleColumn()
  374. class Meta(BaseTable.Meta):
  375. model = DeviceBayTemplate
  376. fields = ('pk', 'name')
  377. empty_text = "None"
  378. #
  379. # Device roles
  380. #
  381. class DeviceRoleTable(BaseTable):
  382. pk = ToggleColumn()
  383. device_count = tables.TemplateColumn(
  384. template_code=DEVICEROLE_DEVICE_COUNT,
  385. accessor=Accessor('devices.count'),
  386. orderable=False,
  387. verbose_name='Devices'
  388. )
  389. vm_count = tables.TemplateColumn(
  390. template_code=DEVICEROLE_VM_COUNT,
  391. accessor=Accessor('virtual_machines.count'),
  392. orderable=False,
  393. verbose_name='VMs'
  394. )
  395. color = tables.TemplateColumn(COLOR_LABEL, verbose_name='Label')
  396. slug = tables.Column(verbose_name='Slug')
  397. actions = tables.TemplateColumn(
  398. template_code=DEVICEROLE_ACTIONS,
  399. attrs={'td': {'class': 'text-right noprint'}},
  400. verbose_name=''
  401. )
  402. class Meta(BaseTable.Meta):
  403. model = DeviceRole
  404. fields = ('pk', 'name', 'device_count', 'vm_count', 'color', 'vm_role', 'slug', 'actions')
  405. #
  406. # Platforms
  407. #
  408. class PlatformTable(BaseTable):
  409. pk = ToggleColumn()
  410. device_count = tables.TemplateColumn(
  411. template_code=PLATFORM_DEVICE_COUNT,
  412. accessor=Accessor('devices.count'),
  413. orderable=False,
  414. verbose_name='Devices'
  415. )
  416. vm_count = tables.TemplateColumn(
  417. template_code=PLATFORM_VM_COUNT,
  418. accessor=Accessor('virtual_machines.count'),
  419. orderable=False,
  420. verbose_name='VMs'
  421. )
  422. actions = tables.TemplateColumn(
  423. template_code=PLATFORM_ACTIONS,
  424. attrs={'td': {'class': 'text-right noprint'}},
  425. verbose_name=''
  426. )
  427. class Meta(BaseTable.Meta):
  428. model = Platform
  429. fields = ('pk', 'name', 'manufacturer', 'device_count', 'vm_count', 'slug', 'napalm_driver', 'actions')
  430. #
  431. # Devices
  432. #
  433. class DeviceTable(BaseTable):
  434. pk = ToggleColumn()
  435. name = tables.TemplateColumn(
  436. order_by=('_nat1', '_nat2', '_nat3'),
  437. template_code=DEVICE_LINK
  438. )
  439. status = tables.TemplateColumn(template_code=STATUS_LABEL, verbose_name='Status')
  440. tenant = tables.TemplateColumn(template_code=COL_TENANT)
  441. site = tables.LinkColumn('dcim:site', args=[Accessor('site.slug')])
  442. rack = tables.LinkColumn('dcim:rack', args=[Accessor('rack.pk')])
  443. device_role = tables.TemplateColumn(DEVICE_ROLE, verbose_name='Role')
  444. device_type = tables.LinkColumn(
  445. 'dcim:devicetype', args=[Accessor('device_type.pk')], verbose_name='Type',
  446. text=lambda record: record.device_type.display_name
  447. )
  448. class Meta(BaseTable.Meta):
  449. model = Device
  450. fields = ('pk', 'name', 'status', 'tenant', 'site', 'rack', 'device_role', 'device_type')
  451. class DeviceDetailTable(DeviceTable):
  452. primary_ip = tables.TemplateColumn(
  453. orderable=False, verbose_name='IP Address', template_code=DEVICE_PRIMARY_IP
  454. )
  455. class Meta(DeviceTable.Meta):
  456. model = Device
  457. fields = ('pk', 'name', 'status', 'tenant', 'site', 'rack', 'device_role', 'device_type', 'primary_ip')
  458. class DeviceImportTable(BaseTable):
  459. name = tables.TemplateColumn(template_code=DEVICE_LINK, verbose_name='Name')
  460. status = tables.TemplateColumn(template_code=STATUS_LABEL, verbose_name='Status')
  461. tenant = tables.TemplateColumn(template_code=COL_TENANT)
  462. site = tables.LinkColumn('dcim:site', args=[Accessor('site.slug')], verbose_name='Site')
  463. rack = tables.LinkColumn('dcim:rack', args=[Accessor('rack.pk')], verbose_name='Rack')
  464. position = tables.Column(verbose_name='Position')
  465. device_role = tables.Column(verbose_name='Role')
  466. device_type = tables.Column(verbose_name='Type')
  467. class Meta(BaseTable.Meta):
  468. model = Device
  469. fields = ('name', 'status', 'tenant', 'site', 'rack', 'position', 'device_role', 'device_type')
  470. empty_text = False
  471. #
  472. # Device components
  473. #
  474. class ConsolePortTable(BaseTable):
  475. class Meta(BaseTable.Meta):
  476. model = ConsolePort
  477. fields = ('name',)
  478. class ConsoleServerPortTable(BaseTable):
  479. class Meta(BaseTable.Meta):
  480. model = ConsoleServerPort
  481. fields = ('name', 'description')
  482. class PowerPortTable(BaseTable):
  483. class Meta(BaseTable.Meta):
  484. model = PowerPort
  485. fields = ('name',)
  486. class PowerOutletTable(BaseTable):
  487. class Meta(BaseTable.Meta):
  488. model = PowerOutlet
  489. fields = ('name', 'description')
  490. class InterfaceTable(BaseTable):
  491. class Meta(BaseTable.Meta):
  492. model = Interface
  493. fields = ('name', 'type', 'lag', 'enabled', 'mgmt_only', 'description')
  494. class FrontPortTable(BaseTable):
  495. class Meta(BaseTable.Meta):
  496. model = FrontPort
  497. fields = ('name', 'type', 'rear_port', 'rear_port_position', 'description')
  498. empty_text = "None"
  499. class RearPortTable(BaseTable):
  500. class Meta(BaseTable.Meta):
  501. model = RearPort
  502. fields = ('name', 'type', 'positions', 'description')
  503. empty_text = "None"
  504. class DeviceBayTable(BaseTable):
  505. class Meta(BaseTable.Meta):
  506. model = DeviceBay
  507. fields = ('name',)
  508. #
  509. # Cables
  510. #
  511. class CableTable(BaseTable):
  512. pk = ToggleColumn()
  513. id = tables.LinkColumn(
  514. viewname='dcim:cable',
  515. args=[Accessor('pk')],
  516. verbose_name='ID'
  517. )
  518. termination_a_parent = tables.TemplateColumn(
  519. template_code=CABLE_TERMINATION_PARENT,
  520. accessor=Accessor('termination_a'),
  521. orderable=False,
  522. verbose_name='Termination A'
  523. )
  524. termination_a = tables.Column(
  525. accessor=Accessor('termination_a'),
  526. orderable=False,
  527. verbose_name=''
  528. )
  529. termination_b_parent = tables.TemplateColumn(
  530. template_code=CABLE_TERMINATION_PARENT,
  531. accessor=Accessor('termination_b'),
  532. orderable=False,
  533. verbose_name='Termination B'
  534. )
  535. termination_b = tables.Column(
  536. accessor=Accessor('termination_b'),
  537. orderable=False,
  538. verbose_name=''
  539. )
  540. status = tables.TemplateColumn(
  541. template_code=STATUS_LABEL
  542. )
  543. length = tables.TemplateColumn(
  544. template_code=CABLE_LENGTH,
  545. order_by='_abs_length'
  546. )
  547. color = ColorColumn()
  548. class Meta(BaseTable.Meta):
  549. model = Cable
  550. fields = (
  551. 'pk', 'id', 'label', 'termination_a_parent', 'termination_a', 'termination_b_parent', 'termination_b',
  552. 'status', 'type', 'color', 'length',
  553. )
  554. #
  555. # Device connections
  556. #
  557. class ConsoleConnectionTable(BaseTable):
  558. console_server = tables.LinkColumn(
  559. viewname='dcim:device',
  560. accessor=Accessor('connected_endpoint.device'),
  561. args=[Accessor('connected_endpoint.device.pk')],
  562. verbose_name='Console Server'
  563. )
  564. connected_endpoint = tables.Column(
  565. verbose_name='Port'
  566. )
  567. device = tables.LinkColumn(
  568. viewname='dcim:device',
  569. args=[Accessor('device.pk')]
  570. )
  571. name = tables.Column(
  572. verbose_name='Console Port'
  573. )
  574. class Meta(BaseTable.Meta):
  575. model = ConsolePort
  576. fields = ('console_server', 'connected_endpoint', 'device', 'name', 'connection_status')
  577. class PowerConnectionTable(BaseTable):
  578. pdu = tables.LinkColumn(
  579. viewname='dcim:device',
  580. accessor=Accessor('connected_endpoint.device'),
  581. args=[Accessor('connected_endpoint.device.pk')],
  582. verbose_name='PDU'
  583. )
  584. outlet = tables.Column(
  585. accessor=Accessor('_connected_poweroutlet'),
  586. verbose_name='Outlet'
  587. )
  588. device = tables.LinkColumn(
  589. viewname='dcim:device',
  590. args=[Accessor('device.pk')]
  591. )
  592. name = tables.Column(
  593. verbose_name='Power Port'
  594. )
  595. class Meta(BaseTable.Meta):
  596. model = PowerPort
  597. fields = ('pdu', 'outlet', 'device', 'name', 'connection_status')
  598. class InterfaceConnectionTable(BaseTable):
  599. device_a = tables.LinkColumn(
  600. viewname='dcim:device',
  601. accessor=Accessor('device'),
  602. args=[Accessor('device.pk')],
  603. verbose_name='Device A'
  604. )
  605. interface_a = tables.LinkColumn(
  606. viewname='dcim:interface',
  607. accessor=Accessor('name'),
  608. args=[Accessor('pk')],
  609. verbose_name='Interface A'
  610. )
  611. description_a = tables.Column(
  612. accessor=Accessor('description'),
  613. verbose_name='Description'
  614. )
  615. device_b = tables.LinkColumn(
  616. viewname='dcim:device',
  617. accessor=Accessor('_connected_interface.device'),
  618. args=[Accessor('_connected_interface.device.pk')],
  619. verbose_name='Device B'
  620. )
  621. interface_b = tables.LinkColumn(
  622. viewname='dcim:interface',
  623. accessor=Accessor('_connected_interface'),
  624. args=[Accessor('_connected_interface.pk')],
  625. verbose_name='Interface B'
  626. )
  627. description_b = tables.Column(
  628. accessor=Accessor('_connected_interface.description'),
  629. verbose_name='Description'
  630. )
  631. class Meta(BaseTable.Meta):
  632. model = Interface
  633. fields = (
  634. 'device_a', 'interface_a', 'description_a', 'device_b', 'interface_b', 'description_b', 'connection_status',
  635. )
  636. #
  637. # InventoryItems
  638. #
  639. class InventoryItemTable(BaseTable):
  640. pk = ToggleColumn()
  641. device = tables.LinkColumn('dcim:device_inventory', args=[Accessor('device.pk')])
  642. manufacturer = tables.Column(accessor=Accessor('manufacturer.name'), verbose_name='Manufacturer')
  643. class Meta(BaseTable.Meta):
  644. model = InventoryItem
  645. fields = ('pk', 'device', 'name', 'manufacturer', 'part_id', 'serial', 'asset_tag', 'description')
  646. #
  647. # Virtual chassis
  648. #
  649. class VirtualChassisTable(BaseTable):
  650. pk = ToggleColumn()
  651. master = tables.LinkColumn()
  652. member_count = tables.Column(verbose_name='Members')
  653. actions = tables.TemplateColumn(
  654. template_code=VIRTUALCHASSIS_ACTIONS,
  655. attrs={'td': {'class': 'text-right noprint'}},
  656. verbose_name=''
  657. )
  658. class Meta(BaseTable.Meta):
  659. model = VirtualChassis
  660. fields = ('pk', 'master', 'domain', 'member_count', 'actions')
  661. #
  662. # Power panels
  663. #
  664. class PowerPanelTable(BaseTable):
  665. pk = ToggleColumn()
  666. name = tables.LinkColumn()
  667. site = tables.LinkColumn(
  668. viewname='dcim:site',
  669. args=[Accessor('site.slug')]
  670. )
  671. powerfeed_count = tables.TemplateColumn(
  672. template_code=POWERPANEL_POWERFEED_COUNT,
  673. verbose_name='Feeds'
  674. )
  675. class Meta(BaseTable.Meta):
  676. model = PowerPanel
  677. fields = ('pk', 'name', 'site', 'rack_group', 'powerfeed_count')
  678. #
  679. # Power feeds
  680. #
  681. class PowerFeedTable(BaseTable):
  682. pk = ToggleColumn()
  683. name = tables.LinkColumn()
  684. power_panel = tables.LinkColumn(
  685. viewname='dcim:powerpanel',
  686. args=[Accessor('power_panel.pk')],
  687. )
  688. rack = tables.LinkColumn(
  689. viewname='dcim:rack',
  690. args=[Accessor('rack.pk')]
  691. )
  692. status = tables.TemplateColumn(
  693. template_code=STATUS_LABEL
  694. )
  695. type = tables.TemplateColumn(
  696. template_code=TYPE_LABEL
  697. )
  698. class Meta(BaseTable.Meta):
  699. model = PowerFeed
  700. fields = ('pk', 'name', 'power_panel', 'rack', 'status', 'type', 'supply', 'voltage', 'amperage', 'phase')