koha-tmpl/intranet-tmpl/prog/en/modules/admin/updatedatabase.tt

   1 [% INCLUDE 'doc-head-open.inc' %]
   2 <title>Koha &rsaquo; Administration &rsaquo; Update Database</title>
   3 [% INCLUDE 'doc-head-close.inc' %]
   4 <link rel="stylesheet" type="text/css" href="[% themelang %]/css/datatables.css" />
   5 <script type="text/javascript" src="[% themelang %]/lib/jquery/plugins/jquery.dataTables.min.js"></script>
   6 [% INCLUDE 'datatables-strings.inc' %]
   7 <script type="text/javascript" src="[% themelang %]/js/datatables.js"></script>
   8
   9 <script type="text/javascript">
  10  //<![CDATA[
  11     $(document).ready(function() {
  12         $("#versionst").dataTable($.extend(true, {}, dataTablesDefaults, {
  13             "aaSorting" : [[0, "desc"]],
  14             "sPaginationType": "four_button",
  15         }));
  16     } );
  17     function see_details(a){
  18         var div = $(a).siblings('div');
  19         $(div).slideToggle("fast", function() {
  20             var isVisible = $(div).is(":visible");
  21             if ( isVisible ){$(a).text("Hide details");}else{$(a).text("Show details");}
  22         } );
  23     }
  24     function get_infos(version, node){
  25         $.getJSON('/cgi-bin/koha/admin/ajax-updatedb-getinfos.pl',
  26             { version: version },
  27             function(param) {
  28                 if ( param['errors'] ) {
  29                     $(node).replaceWith(_("Errors occured: ") + param['errors']);
  30                 }
  31                 var s;
  32                 s = "<b>" + _("Comments:") + "</b>";
  33                 s += '<br/>';
  34                 if ( param['comments'] ) {
  35                     s += param['comments'];
  36                 } else {
  37                     s += _("No comments");
  38                 }
  39                 s += '<br/><br/>';
  40
  41                 s += "<b>" + _("Queries:") + "</b>";
  42                 s += '<br/>';
  43                 if ( param['queries'] ) {
  44                     s += param['queries'];
  45                 } else {
  46                     s += _("No queries");
  47                 }
  48                 $(node).replaceWith(s);
  49             }
  50         );
  51     }
  52 //]]>
  53 </script>
  54 </head>
  55 <body>
  56 [% INCLUDE 'header.inc' %]
  57 [% INCLUDE 'cat-search.inc' %]
  58
  59 <div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/admin/admin-home.pl">Administration</a> &rsaquo; Database update</div>
  60
  61 <div id="doc3" class="yui-t2">
  62
  63    <div id="bd">
  64     <div id="yui-main">
  65     <div class="yui-b">
  66
  67     <h2>Database update</h2>
  68     [% IF report_loop %]
  69     <div class="report" style="display:block; margin:1em;">
  70         Report :
  71         <ul>
  72         [% FOREACH report_loo IN report_loop %]
  73             <li>
  74                 [% report_loo.version %] --
  75                 [% FOREACH r IN report_loo.report %]
  76                   [% IF r.error.error == "ALREADY_EXISTS" %]
  77                     <span style="color:orange;">
  78                       [% r.error.filepath %] already executed in version [% r.error.old_version %] : same md5 ([% r.error.md5 %])
  79                       [<a href="/cgi-bin/koha/admin/updatedatabase.pl?op=mark_as_ok&version=[% report_loo.version %]">Mark as OK</a>]
  80                     </span>
  81                   [% ELSIF r.error.error == "LOAD_FUNCTIONS_FAILED" %]
  82                     <span style="color:red;">
  83                       Load functions in [% r.error.filename %] failed ([% r.error.error_str %])
  84                     </span>
  85                   [% ELSIF r.error.error == "BAD_EXTENSION" %]
  86                     <span style="color:red;">
  87                       This extension ([% r.error.extension %]) is not take into account (only .pl or .sql)";
  88                     </span>
  89                   [% ELSE %]
  90                     [% IF r.error == "OK" %]
  91                       <span style="color:green;">
  92                         [% r.error %];
  93                       </span>
  94                     [% ELSE %]
  95                       <span style="color:red;">
  96                         [% r.error %];
  97                       </span>
  98                     [% END %]
  99                   [% END %]
 100                 [% END %]
 101             </li>
 102         [% END %]
 103         </ul>
 104     </div>
 105     [% END %]
 106     <span class="infos" style="display:block; margin:1em;">
 107         [% IF nb_available %]
 108             Your datebase is not up to date.<br/>
 109             [% IF nb_available == 1 %]
 110                 1 update available [<a href="/cgi-bin/koha/admin/updatedatabase.pl?op=update&version=[% available.first.version %]">UPDATE [% available.first.version %]</a>]
 111             [% ELSE %]
 112                 [% nb_available %] updates available [<a href="/cgi-bin/koha/admin/updatedatabase.pl?op=update[% FOREACH av IN available %]&version=[% av.version %][% END %]">UPDATE ALL</a>]:
 113                 [% IF ( dev_mode ) %]
 114                   <ul>
 115                     [% FOREACH av IN available %]
 116                       <li>[% av.version %] [<a href="/cgi-bin/koha/admin/updatedatabase.pl?op=update&version=[% av.version %]">UPDATE</a>]</li>
 117                     [% END %]
 118                   </ul>
 119                 [% END %]
 120             [% END %]
 121         [% ELSE %]
 122             Your database is up to date
 123         [% END %]
 124     </span>
 125
 126     <table id="versionst">
 127         <thead>
 128             <tr>
 129                 <th>DB revision</th>
 130                 <th>Status</th>
 131                 <th>Comments</th>
 132                 <th>Details</th>
 133             </tr>
 134         </thead>
 135         <tbody>
 136         [% FOREACH v IN versions %]
 137             <tr>
 138                 <td>[% v.version %]</td>
 139                 <td>
 140                     [% IF v.available %]
 141                         Not applied
 142                         [% IF (dev_mode) %]
 143                             [<a href="/cgi-bin/koha/admin/updatedatabase.pl?op=update&version=[% v.version %]">Execute</a>]
 144                         [% END %]
 145                     [% ELSE %]
 146                         [% SWITCH v.status %]
 147                         [% CASE 0 %]
 148                             <span style="color:red;">
 149                               Applied and failed
 150                               [<a href="/cgi-bin/koha/admin/updatedatabase.pl?op=mark_as_ok&version=[% v.version %]">Mark as OK</a>]
 151                             </span>
 152                         [% CASE 1 %]
 153                             <span style="color:green;">Applied and OK</span>
 154                         [% CASE 2 %]
 155                             <span style="color:green;">Applied and Forced</span>
 156                         [% CASE %]
 157                             <span style="color:red;">Status does not exist !</span>
 158                         [% END %]
 159                     [% END %]
 160                 </td>
 161                 <td>
 162                     [% FOREACH c IN v.comments %]
 163                         [% c.comment %]<br/>
 164                     [% END %]
 165                 </td>
 166                 <td width="50%">
 167                   [% IF v.available %]
 168                     <span style="display:block;"><a href="#" onclick="get_infos('[% v.version %]', this); return false;">Get comments</a></span>
 169                   [% ELSE %]
 170                     <div class="details" style="display:none;">
 171                       <div class="queries" style="display:block;">
 172                         <b>Queries</b> :
 173                         <ul>
 174                           [% FOREACH q IN v.queries %]
 175                             <li>[% q.query %]<br/></li>
 176                           [% END %]
 177                         </ul>
 178                       </div>
 179                       [% IF v.status == 1 %]
 180                         <div class="status" style="display:block;">
 181                           <b>Status</b> :
 182                           <span style="color:green;">OK</span>
 183                         </div>
 184                       [% ELSE %]
 185                         <div class="status" style="display:block;">
 186                           <b>Status</b> :
 187                           [% IF v.status == 2 %]
 188                             <span style="color:green;">OK</span>
 189                             [FORCED]
 190                           [% ELSE %]
 191                             <span style="color:red;">Failed</span>
 192                             [<a href="/cgi-bin/koha/admin/updatedatabase.pl?op=mark_as_ok&version=[% v.version %]">Mark as OK</a>]
 193                           [% END %]
 194                         </div>
 195                         <div class="errors" style="display:block;">
 196                           <b>Errors</b> :
 197                           <ul>
 198                             [% FOREACH e IN v.errors %]
 199                               <li><span>[% e.error %]</span></li>
 200                             [% END %]
 201                           </ul>
 202                         </div>
 203                       [% END %]
 204                     </div>
 205                     <a href="#" onclick="see_details(this);return false;">Show details</a>
 206                   [% END %]
 207                 </td>
 208             </tr>
 209         [% END %]
 210         </tbody>
 211     </table>
 212
 213     </div>
 214     </div>
 215     </div>
 216     </div>
 217     </div>