Bugzilla – Attachment 174404 Details for
Bug 36039
The output of audit_database.pl should be accessible through the UI
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 36039: New 'datatabase audit' tab in about page
Bug-36039-New-datatabase-audit-tab-in-about-page.patch (text/plain), 2.91 KB, created by
Pedro Amorim
on 2024-11-12 11:56:27 UTC
(
hide
)
Description:
Bug 36039: New 'datatabase audit' tab in about page
Filename:
MIME Type:
Creator:
Pedro Amorim
Created:
2024-11-12 11:56:27 UTC
Size:
2.91 KB
patch
obsolete
>From 24dcd5688874a0d49c4fc9ba2f717e01eb76dcb1 Mon Sep 17 00:00:00 2001 >From: Pedro Amorim <pedro.amorim@ptfs-europe.com> >Date: Mon, 26 Feb 2024 16:36:29 +0000 >Subject: [PATCH] Bug 36039: New 'datatabase audit' tab in about page > >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Signed-off-by: JesseM <jesse@bywatersolutions.com> >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > about.pl | 6 ++++++ > koha-tmpl/intranet-tmpl/prog/en/modules/about.tt | 13 +++++++++++++ > 2 files changed, 19 insertions(+) > >diff --git a/about.pl b/about.pl >index c2f6e6f591..de73993324 100755 >--- a/about.pl >+++ b/about.pl >@@ -926,4 +926,10 @@ sub message_broker_check { > } > } > >+if ( $tab eq 'database' ) { >+ use Koha::Database::Auditor; >+ my $db_auditor = Koha::Database::Auditor->new( { is_cli => 0 } ); >+ my $audit_diff = $db_auditor->run; >+ $template->param( audit_diff => $audit_diff, audit_warning => $db_auditor->get_warning ); >+} > output_html_with_http_headers $query, $cookie, $template->output; >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/about.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/about.tt >index 638d717e41..2fb1c40c34 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/about.tt >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/about.tt >@@ -41,6 +41,7 @@ > [% WRAPPER tab_item linktab = 1 tabname = "translations" bt_active = tab == "translations" %] <span>Translations</span> [% END %] > [% WRAPPER tab_item linktab = 1 tabname = "history" bt_active = tab == "history" %] <span>Timeline</span> [% END %] > [% WRAPPER tab_item linktab = 1 tabname = "dedications" bt_active = tab == "dedications" %] <span>Dedications</span> [% END %] >+ [% WRAPPER tab_item linktab = 1 tabname = "database" bt_active = tab == "database" %] <span>Database audit</span> [% END %] > [% END %] > [% WRAPPER tab_panels %] > [% SWITCH tab %] >@@ -52,6 +53,7 @@ > [% CASE 'translations' %] [% PROCESS translations_panel %] > [% CASE 'history' %] [% PROCESS history_panel %] > [% CASE 'dedications' %] [% PROCESS dedications_panel %] >+ [% CASE 'database' %] [% PROCESS database_panel %] > [% CASE %] [% PROCESS about_panel %] > [% END %] > [% END %] >@@ -1355,3 +1357,14 @@ > </p> > [% END # tab=dedications %] > [% END %] >+ >+[% BLOCK database_panel %] >+ [% WRAPPER tab_panel tabname= "database" bt_active = 1 %] >+ <h2>Database audit</h2> >+ <p>Run the following SQL to fix the database:</p> >+ <code> >+ [% audit_diff | html %] >+ </code> >+ <p class="alert alert-warning">[% audit_warning | html %]</p> >+ [% END # tab=database %] >+[% END %] >\ No newline at end of file >-- >2.39.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 36039
:
161892
|
162462
|
162463
|
166097
|
166098
|
166099
|
166155
|
166156
|
166157
|
169225
|
169226
|
169227
|
174403
| 174404 |
174405