Provide option to use server-based bible versions

Issues:

[x] (1) ErrorException: Trying to get property of non-object in /var/www/eec.ie/html/church/plan/app/Http/Controllers/Cspot/BibleController.php:410
[x] (2) Issue with "Psalms" vs "Psalm"
[x] (3) Add views to edit the bible versions, books and texts! Could be helpful if there are some issues with spelling etc.
[x] (4) Enable editing also in Item Details view
[x] (5) When showing a certain chapter and selecting a different version, keep the current book+chapter selection
[x] (6) Migrations: make 'name' field in Bibleversions and Biblebooks unique
[x] (7) Issue with differing Book names - "Psalms" vs. "Psalm" or "Song of Songs" vs "Song of Solomon"
[x] (8) Book selection on Bible text page shows books in alphabetical order; books on Books list page also
[x] (9) Bible Versions detail page: add field to edit the copyright statement (and make it mandatory!)
[x] (10) Presentation still shows the online versions of bibles
[x] (11) Add free text search in local bibles

Description

Currently, we are getting bible texts either via the bibles.org API or by "scraping" it from biblehub.com.

However, in the case of the NIV, some churches do not want the 2011 version of hte NIV, which is now the only online available version. In the past, some people have purchased a digital copy of the NIV 1984 and they want to continue to use that.

This request is to make bibles that are available in digital form, also available in c-SPOT. By that we also will become independant of other, online sources for bible texts.

Easyslides (formerly Easislides) used to save bibles in the MS Access format (.mdb) with the following fields:

book(number)
chapter
verse
(bible)text

Implementation:

We will add 3 tables to our database:

bibleversions (with id and name)
biblebooks (with id and name)
bibles (with _version_id, bookid, chapter, verse and text)

This way it will be relatively easy to import the MDB files into our mysql backend database:

Open the mdb file in MS Access
Open the table in Design view and insert a new field (column) as the first field
Insert the same number (like 5) in all fields of this column. This number must then be matched with the version name in the table bibleversions!
Export the file as text file (csv)
Open the csv file in a text editor and remove all lines that do not contain bible text - however, use the lines containing the bible books to id mapping to fill the "biblebooks" table!
Import the csv file into the bibles table

matthiku / cSpot