[Koha-bugs] [Bug 7977] Add a "Quote-of-the-day" feature to the OPAC homepage

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7977

--- Comment #13 from Chris Nighswonger <cnighswonger at foundations.edu> ---
Created attachment 9376
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=9376&action=edit
Beginning work on Quote-of-the-day (QOTD) Feature for OPAC

This feature will add the option of displaying a select quote
for the day on the OPAC homepage. It will include the addition
of a QOTD editor in the tools section of the staff interface
which will allow the addition, editing, and deletion of quotes.
A single system preference will enable/disable the display of
the QOTD on the OPAC homepage. A new granular permission will
also be added to conrol user access to the QOTD editor tool.

Possible extentions to this would be code to allow alternate
quote selection algorithms to be added to vary how the currently
displayed quote is selected from the table of quotes.

This patch is a squash of the following work:

Adding quotes table to kohastructure.sql and updatedatabase.pl

Note: This patch is intended for a MySQL based installation only.
That means that it includes backticks because that is what is required
at this point in history to install Koha correctly on a MySQL based
installation.

Feel free to port this over to the Pg stuff in the data/Pg directory.

Adding system preference to control display of QOTD on OPAC main page

Adding sample quote data

These quotes are taken from various US presidents. I'm not sure these
are applicable to the rest of the world, so I'm leaving it to translators
and others to add sample quote data for other languages.

Adding edit_quotes user permissions

Squash with other db related patches in this series

Adding quotes editor pages to tools

Adding QOTD editor link to tools homepage

Integration of DataTables into QOTD Editor

This includes only the table generation; jEditable to be added
next to allow quote adding and editing directly in the table.

Impleminting jEditable into the quote editor

Adding delete and add option to editor

Fixing OPAC display so the QOTD div does not show if no quote is returned

Also removing useless code from tools/quotes.pl

Adding spans around QOTD foo in opac-main.tt

Also fixing quote selection logic to accomodate the possibility of
a single quote in the db a litte better.

Changing timestamp column header to a more user-friendly 'Last Displayed'

Fixing bug in quote selection logic

This bug caused a situation where when the table had only a single
quote with an id greater than 1 in it, no quote would be selected.

Fixing up sorting in the quote editor table. (Thanks to jcamins for pointing
out that this did not work.)

Overriding the default empty table message supplied by datatables-strings.inc

NOTE: Someone needs to verify that this local string is translatable.

-- 
You are receiving this mail because:
You are watching all bug changes.