dictionary.html 7.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4. <meta charset="utf-8">
  5. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  6. <meta name="viewport" content="width=device-width, initial-scale=1">
  7. <meta name="description" content="">
  8. <meta name="author" content="">
  9. <title>数据字典 - {$site.name}</title>
  10. <!-- Bootstrap Core CSS -->
  11. <link href="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
  12. <!-- Custom CSS -->
  13. <!-- Plugin CSS -->
  14. <link href="https://cdn.staticfile.org/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet">
  15. <link href="https://cdn.staticfile.org/simple-line-icons/2.4.1/css/simple-line-icons.min.css" rel="stylesheet">
  16. <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  17. <!--[if lt IE 9]>
  18. <script src="https://cdn.staticfile.org/html5shiv/3.7.3/html5shiv.min.js"></script>
  19. <script src="https://cdn.staticfile.org/respond.js/1.4.2/respond.min.js"></script>
  20. <![endif]-->
  21. <script src="https://cdn.staticfile.org/jquery/2.1.4/jquery.min.js"></script>
  22. </head>
  23. <body>
  24. <style>
  25. .sidenav,
  26. .dictionary-container{overflow-y: auto; height: 100vh; }
  27. .sidenav .list-group{ padding: 20px 0}
  28. .side-nav-item{ margin-top: 10px; }
  29. .side-nav-item a{text-decoration: none; display: block;background: #f7f7f7;padding: 2px 15px;}
  30. .side-nav-item a:hover{ background: #f0f0f0}
  31. .side-nav-title{ font-size: 18px;}
  32. .side-nav-item .side-nav-table{ font-size: 16px;color: #565656; height: 26px; line-height: 26px; overflow: hidden;}
  33. .side-nav-item .side-nav-name{font-size: 14px;color: #9a9a9a;height: 22px; line-height: 22px; overflow: hidden;}
  34. .table-item { padding: 30px 30px 0 }
  35. .table-item h3{font-size: 24px; line-height: 30px;}
  36. .table-item h3 small{ font-size: 14px;line-height: 30px;}
  37. .table-desc{ background: #f5f5f5; padding: 0 10px; border-radius: 3px;}
  38. .table-info *{ border: none !important}
  39. .table-fields td{ word-break:break-all; word-wrap:break-word;}
  40. </style>
  41. <div id="content-container" class="container">
  42. <div class="row">
  43. <div class="col-md-3 sidenav">
  44. <div class="list-group">
  45. <dl>
  46. <dt class="side-nav-title">插件创建的表</dt>
  47. {foreach $dictionary['make'] as $k=>$v}
  48. <dd class="side-nav-item"><a href="#{$v.table}">
  49. <div class="side-nav-table">{$v.table}</div>
  50. <div class="side-nav-name">{$v.name}</div>
  51. </a></dd>
  52. {/foreach}
  53. </dl>
  54. <dl>
  55. <dt class="side-nav-title">FA系统表</dt>
  56. {foreach $dictionary['system'] as $k=>$v}
  57. <dd class="side-nav-item"><a href="#{$v.table}">
  58. <div class="side-nav-table">{$v.table}</div>
  59. <div class="side-nav-name">{$v.name}</div>
  60. </a></dd>
  61. {/foreach}
  62. </dl>
  63. <dl>
  64. <dt class="side-nav-title">其他表</dt>
  65. {foreach $dictionary['other'] as $k=>$v}
  66. <dd class="side-nav-item"><a href="#{$v.table}">
  67. <div class="side-nav-table">{$v.table}</div>
  68. <div class="side-nav-name">{$v.name}</div>
  69. </a></dd>
  70. {/foreach}
  71. </dl>
  72. </div>
  73. </div>
  74. <div class="col-md-9 dictionary-container">
  75. <div class="panel panel-default">
  76. <div class="panel-body">
  77. <h2 class="page-header">
  78. 数据字典
  79. </h2>
  80. <div class="row">
  81. {foreach $dictionary as $type=>$tables}
  82. {foreach $tables as $k=>$table}
  83. <div id="{$table.table}" class="table-item">
  84. <h3>{$table.table}({$table.name}) <small class="pull-right">存储引擎:{$table.engine};&nbsp;字符序:{$table.table_collation}</small></h3>
  85. <div class="table-desc">
  86. <table class="table table-info">
  87. <tr>
  88. <td style="text-align:right" width="15%">完整表名:</td>
  89. <td style="text-align: left" width="35%">{$table.table_name}</td>
  90. <td style="text-align:right" width="15%">创建时间:</td>
  91. <td style="text-align: left" width="35%">{$table.create_time}</td>
  92. </tr>
  93. <tr>
  94. {if $type=="make"&&$table.desc&&$table.desc!=$table.table_comment}
  95. <td style="text-align:right">描述说明:</td>
  96. <td style="text-align: left" colspan="3">{$table.desc}</td>
  97. {else}
  98. <td style="text-align:right">表备注:</td>
  99. <td style="text-align: left" colspan="3">{$table.table_comment}</td>
  100. {/if}
  101. </tr>
  102. </table>
  103. </div>
  104. <table class="table table-bordered table-hover table-fields">
  105. <tr class="info">
  106. <th width="15%">字段名</th>
  107. <th width="15%">字段标题</th>
  108. <th width="20%">字段类型</th>
  109. <th width="10%">默认值</th>
  110. <th width="100">字段备注</th>
  111. {if $type=="make"}
  112. <th width="100">字段说明</th>
  113. {/if}
  114. </tr>
  115. {foreach $table['fields'] as $key=>$field}
  116. <tr>
  117. <td>{$field.field_name}</td>
  118. <td>{$field.field_title}</td>
  119. <td>{$field.column_type}</td>
  120. <td>{$field.default}</td>
  121. <td>{$field.column_comment}</td>
  122. {if $type=="make"}
  123. <td>{$field.desc}</td>
  124. {/if}
  125. </tr>
  126. {/foreach}
  127. </table>
  128. </div>
  129. {/foreach}
  130. {/foreach}
  131. </div>
  132. </div>
  133. </div>
  134. </div>
  135. </div>
  136. </div>
  137. <script src="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/js/bootstrap.min.js"></script>
  138. </body>
  139. </html>