list_db.html 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235
  1. <div class="l-center">
  2. <div class="l-sort clearfix noselect">
  3. <a href="/add/db/" class="l-sort__create-btn" title="<?=str_replace(' ', '&nbsp;', __('Add Database'))?>"></a>
  4. <div class="l-sort-toolbar clearfix">
  5. <table>
  6. <tr>
  7. <?
  8. $mysql = 0;
  9. $pgsql = 0;
  10. list($http_host, $port) = explode(':', $_SERVER["HTTP_HOST"].":");
  11. foreach ($data as $key => $value) {
  12. if ($data[$key]['TYPE'] == 'mysql'){
  13. $mysql = 1;
  14. $db_admin_link = "http://".$http_host."/phpmyadmin/";
  15. if (!empty($_SESSION['DB_PMA_URL']))
  16. $db_admin_link = $_SESSION['DB_PMA_URL'];
  17. }
  18. if ($data[$key]['TYPE'] == 'pgsql'){
  19. $pgsql = 1;
  20. $db_admin_link = "http://".$http_host."/phppgadmin/";
  21. if (!empty($_SESSION['DB_PGA_URL']))
  22. $db_admin_link = $_SESSION['DB_PGA_URL'];
  23. }
  24. }
  25. if($mysql){
  26. echo '<td class="step-right"><a class="vst" href="'.$db_admin_link.'">phpMyAdmin</td>';
  27. }
  28. if($pgsql){
  29. echo '<td class="step-right"><a class="vst" href="'.$db_admin_link.'">phpPgAdmin</td>';
  30. }
  31. ?>
  32. <td class="l-sort-toolbar__search-box step-left">
  33. <form action="/search/" method="get">
  34. <input type="hidden" name="token" value="<?=$_SESSION['token']?>" />
  35. <input type="text" name="q" class="search-input" value="<? echo isset($_POST['q']) ? htmlspecialchars($_POST['q']) : '' ?>" />
  36. <input type="submit" value="" class="l-sort-toolbar__search" onClick="return doSearch('/search/')" />
  37. </form>
  38. </td>
  39. <td class="toggle-all">
  40. <input id="toggle-all" type="checkbox" name="toggle-all" value="toggle-all" onChange="checkedAll('objects');">
  41. <label for="toggle-all" class="check-label toggle-all"><?=__('toggle all')?></label>
  42. </td>
  43. <td class="sort-by">
  44. <?=__('sort by');?>: <span><b><?=__('DATE')?></b></span> <i class="l-icon-down-arrow media-top"></i>
  45. </td>
  46. <td>
  47. <form action="/bulk/db/" method="post" id="objects">
  48. <input type="hidden" name="token" value="<?=$_SESSION['token']?>" />
  49. <div class="l-select">
  50. <select name="action" id="">
  51. <option value=""><?=__('apply to selected')?></option>
  52. <option value="suspend"><?=__('suspend')?></option>
  53. <option value="unsuspend"><?=__('unsuspend')?></option>
  54. <option value="delete"><?=__('delete')?></option>
  55. </select>
  56. </div>
  57. <input type="submit" value="" class="l-sort-toolbar__filter-apply" />
  58. </td>
  59. </tr>
  60. </table>
  61. <!-- -->
  62. </div>
  63. </div>
  64. <? display_error_block() ?>
  65. <!-- /.l-sort -->
  66. </div>
  67. <div class="l-separator"></div>
  68. <!-- /.l-separator -->
  69. <div class="l-center">
  70. <?
  71. list($http_host, $port) = explode(':', $_SERVER["HTTP_HOST"].":");
  72. foreach ($data as $key => $value) {
  73. ++$i;
  74. if ($data[$key]['SUSPENDED'] == 'yes') {
  75. $status = 'suspended';
  76. $spnd_action = 'unsuspend' ;
  77. $spnd_confirmation = 'UNSUSPEND_DATABASE_CONFIRMATION' ;
  78. } else {
  79. $status = 'active';
  80. $spnd_action = 'suspend' ;
  81. $spnd_confirmation = 'SUSPEND_DATABASE_CONFIRMATION' ;
  82. }
  83. if ($data[$key]['HOST'] != 'localhost' ) $http_host = $data[$key]['HOST'];
  84. if ($data[$key]['TYPE'] == 'mysql') $db_admin = "phpMyAdmin";
  85. if ($data[$key]['TYPE'] == 'mysql') $db_admin_link = "http://".$http_host."/phpmyadmin/";
  86. if (($data[$key]['TYPE'] == 'mysql') && (!empty($_SESSION['DB_PMA_URL']))) $db_admin_link = $_SESSION['DB_PMA_URL'];
  87. if ($data[$key]['TYPE'] == 'pgsql') $db_admin = "phpPgAdmin";
  88. if ($data[$key]['TYPE'] == 'pgsql') $db_admin_link = "http://".$http_host."/phppgadmin/";
  89. if (($data[$key]['TYPE'] == 'pgsql') && (!empty($_SESSION['DB_PGA_URL']))) $db_admin_link = $_SESSION['DB_PGA_URL'];
  90. ?>
  91. <div class="l-unit <? if($status == 'suspended') echo 'l-unit--suspended';?>">
  92. <div class="l-unit-toolbar clearfix">
  93. <div class="l-unit-toolbar__col l-unit-toolbar__col--left">
  94. <input id="check<?php echo $i ?>" class="ch-toggle" type="checkbox" name="database[]" value="<?php echo $key ?>">
  95. <label for="check<?php echo $i ?>" class="check-label"></label>
  96. </div>
  97. <!-- l-unit-toolbar__col -->
  98. <div class="l-unit-toolbar__col l-unit-toolbar__col--right noselect">
  99. <div class="actions-panel clearfix">
  100. <div class="actions-panel__col actions-panel__edit"><a href="/edit/db/?database=<?=$key?>"><?=__('edit')?> <i></i></a></div>
  101. <div class="actions-panel__col actions-panel__suspend">
  102. <a id="<?=$spnd_action ?>_link_<?=$i?>" class="data-controls do_<?=$spnd_action?>">
  103. <?=__($spnd_action)?> <i class="do_<?=$spnd_action?>"></i>
  104. <input type="hidden" name="<?=$spnd_action?>_url" value="/<?=$spnd_action?>/db/?database=<?=$key?>&token=<?=$_SESSION['token']?>" />
  105. <div id="<?=$spnd_action?>_dialog_<?=$i?>" class="confirmation-text-suspention hidden" title="<?=__('Confirmation')?>">
  106. <p class="confirmation"><?=__($spnd_confirmation,$key)?></p>
  107. </div>
  108. </a>
  109. </div>
  110. <div class="actions-panel__col actions-panel__delete">
  111. <a id="delete_link_<?=$i?>" class="data-controls do_delete">
  112. <?=__('delete')?> <i class="do_delete"></i>
  113. <input type="hidden" name="delete_url" value="/delete/db/?database=<?=$key?>&token=<?=$_SESSION['token']?>" />
  114. <div id="delete_dialog_<?=$i?>" class="confirmation-text-delete hidden" title="<?=__('Confirmation')?>">
  115. <p class="confirmation"><?=__('DELETE_DATABASE_CONFIRMATION',$key)?></p>
  116. </div>
  117. </a>
  118. </div>
  119. </div>
  120. <!-- /.actiona-panel -->
  121. </div>
  122. <!-- l-unit-toolbar__col -->
  123. </div>
  124. <!-- /.l-unit-toolbar -->
  125. <div class="l-unit__col l-unit__col--left clearfix">
  126. <div class="l-unit__date">
  127. <?=translate_date($data[$key]['DATE'])?>
  128. </div>
  129. <div class="l-unit__suspended""><?=__('suspended')?></div>
  130. </div>
  131. <!-- /.l-unit__col -->
  132. <div class="l-unit__col l-unit__col--right">
  133. <div class="l-unit__name separate">
  134. <?=$key?>
  135. </div>
  136. <!-- /.l-unit__name -->
  137. <div class="l-unit__stats">
  138. <table>
  139. <tr>
  140. <td>
  141. <div class="l-unit__stat-cols clearfix graph">
  142. <div class="l-unit__stat-col l-unit__stat-col--left">
  143. <?=__('Disk')?>
  144. </div>
  145. <div class="l-unit__stat-col l-unit__stat-col--right text-right volume">
  146. <b><?=humanize_usage_size($data[$key]['U_DISK'])?></b> <?=humanize_usage_measure($data[$key]['U_DISK'])?>
  147. </div>
  148. </div>
  149. <div class="l-percent">
  150. <div class="l-percent__fill" style="width: <?=get_percentage($data[$key]['U_DISK'],$panel[$user]['DISK_QUOTA'])?>%"></div>
  151. </div>
  152. <!-- /.percent -->
  153. </td>
  154. <td>
  155. <div class="l-unit__stat-cols clearfix">
  156. <div class="l-unit__stat-col l-unit__stat-col--left"><?=__('User')?>:</div>
  157. <div class="l-unit__stat-col l-unit__stat-col--right">
  158. <b><?=__($data[$key]['DBUSER'])?></b>
  159. </div>
  160. </div>
  161. </td>
  162. <td>
  163. <div class="l-unit__stat-cols clearfix last">
  164. <div class="l-unit__stat-col l-unit__stat-col--left"><?=__('Host')?>:</div>
  165. <div class="l-unit__stat-col l-unit__stat-col--right">
  166. <b><?=$data[$key]['HOST']?></b>
  167. </div>
  168. </div>
  169. </td>
  170. </tr>
  171. <tr>
  172. <td></td>
  173. <td>
  174. <div class="l-unit__stat-cols clearfix">
  175. <div class="l-unit__stat-col l-unit__stat-col--left"><?=__('Charset')?>:</div>
  176. <div class="l-unit__stat-col l-unit__stat-col--right">
  177. <b><?=$data[$key]['CHARSET']?></b>
  178. </div>
  179. </div>
  180. </td>
  181. <td>
  182. <div class="l-unit__stat-cols clearfix last">
  183. <div class="l-unit__stat-col l-unit__stat-col--left"><?=__('Type')?>:</div>
  184. <div class="l-unit__stat-col l-unit__stat-col--right">
  185. <b><?=$data[$key]['TYPE']?></b>
  186. </div>
  187. </div>
  188. </td>
  189. </tr>
  190. </table>
  191. </div>
  192. <!-- /.l-unit__stats -->
  193. </div>
  194. <!-- /.l-unit__col -->
  195. </div>
  196. <!-- /.l-unit -->
  197. <div class="l-separator"></div>
  198. <!-- /.l-separator -->
  199. <?}?>
  200. </div>
  201. <div id="vstobjects">
  202. <div class="l-separator"></div>
  203. <div class="l-center">
  204. <div class="l-unit-ft">
  205. <div class="l-unit__col l-unit__col--left clearfix"></div>
  206. <div class="data-count l-unit__col l-unit__col--right clearfix">
  207. <?php
  208. if ( $i == 1) {
  209. echo __('1 database');
  210. } else {
  211. echo __('%s databases',$i);
  212. }
  213. ?>
  214. </div>
  215. </div>
  216. </div>
  217. </div>