ashleyfae / book-database Goto Github PK

Replace all instances of date() with gmdate().

When displaying the date use get_date_from_gmt()

• Click "Add Review"
• Search for book
• Select associated reading entry
• Review is populated in table with Rating set to -

Instead of an awkward checkbox, there should be a dropdown for reading entry:

• Add existing entry
• Create new entry
• No entry

When selecting "add existing", a dropdown of entries appears.
When selecting "create new", all the fields for inserting a new one appears.

Fuck fuck fuck.

Attach ratings to reading logs?
Or separate DB table for ratings?

Goddammit.

Maybe just one option to "review book", which contains both the reading log and the review details.

Right now it joins with the review table, but only using the reading list and logging "Books Read" rather than "Number of Reviews" might be better. Or perhaps both.

It doesn't seem to change.

It's currently using reviews only.

• Breakdown of page numbers:
  • Number of books with 0-150 pages
  • Number with 151 - 300
  • etc.
• Number of different authors
• Number of different series
• Number of standalones

Reviews are really associated with posts/pages, but maybe I should add a column for the actual review_content in the reviews table. This would make it easier to work with Review to Goodreads / Review Submission features.

Too much overlap.

Add started_reading and finished_reading dates to bdb_get_allowed_orderby() and Review/Book queries.

Allow you to use some of the analytics info on the front-end via shortcodes.

Not sure if I actually want to do this yet.

To reproduce:

1. Create a new book - first in a new series.
2. Save.
3. Division by zero occurs when there's just one book in the series with no rating.

The option already exists but doesn't do anything.

And add quick link to write new review in the book's reading log list.

• Book with most pages
• Book with least pages

Instead of entering the date via a text box.

• Books read/reviewed goal counter
• Reviews (recent/monthly/upcoming options)
• Reading log (list of books read)

Older = outside of time period? IDK. Need to figure out how to calculate this.

Like adding a media gallery but for books. Actual shortcode will be with book IDs rather than filtering params.

When syncing review to post publication, it shouldn't be synced until the post is actually published. To reproduce:

• Assign review to post.
• Save as draft.
• It then appears in review archive.

Similar to author.

They're being added manually now.

I think it's when:

• Add reading log to book
• Click "add review" from reading log entry
• Save review

Maybe creating a new log instead of using the existing one..

wp_bdb_owned_editions

book_id (int)
isbn (text)
format (text)
date_acquired (datetime)
signed (int)

• Create table
• Add interface in Edit Book page
• Allow searching by ISBN in admin book list
• Allow filtering by "books owned" in admin book list
• Allow filtering by book format

Can't use a unix timestamp here: https://github.com/nosegraze/book-database/blob/master/includes/misc-functions.php#L272

See https://wordpress.stackexchange.com/a/135049

Excluding DNF

• New table columns for total_books (total in series) and books_read (maybe -- this latter one could be calculated on the fly). Maybe also add series_rating.
• New submenu under "Book Library" for "Series" to view list of all series. Include a column for how many books in the series can be read.
• Edit series interface allows you to edit all fields and also shows a list of books in the series.

• Table of terms
• Filters for taxonomy type
• Edit term name, description, etc.
• Show average rating for books with that term
• Link to term's books

https://github.com/nosegraze/book-database/blob/master/includes/database/class-bdb-db-books.php#L452

Since there's nothing else to switch to, so it's kind of unnecessary.

Useful for when drafting a post and you don't know the scheduled date yet.

Weird stuff happens.

To filter results to a specific author. Basically like using the search by author name box.

You're currently forced to select a rating, which creates a new reading log, but you may not want a new one.

Similar to [book-reviews] but with attributes and no pagination.