summaryrefslogtreecommitdiffstats
path: root/includes
Commit message (Collapse)AuthorAgeFilesLines
* Clean up, fix and rename db tables.Harald Eilertsen2021-09-163-91/+68
| | | | | | | | | | | | | | | | | This patch got a bit more involved than what was originally planned, but since we're messing with the tables I decided to do it all right away. - Moves the constraint definition to the CREATE TABLE statement for the concerts table. This replaces the existing KEY definition that it had. - Make sure the venues table is created before the concerts table so that the above mentioned constraint definition works. - Rename the tables. Use the wpdb-prefix and make the name a bit prettier. This caused some changes in the Concert and Venue classes, and for slightly silly reasons some test classes. The code actually turned out better (for the most part), but some refactoring can still be done. The column names remains unchanged for now.
* Reinsert created and updated columns for venues.Harald Eilertsen2021-09-161-0/+2
| | | | Was accidentally dropped during rewrite of base schema.
* Facelift of database table creation to use create tables instead of ↵AndreaChirulescu2021-09-131-323/+17
| | | | versioning. First attempt
* Change how we load the plugin.Harald Eilertsen2021-09-111-8/+3
| | | | | | | | | | | | | | Since we now have code that should be available, both on the public blog and in the admin section, we need to be more graular when loading the various parts of the plugin. We still try to avoid loading admin-only parts for the public blog, but allways load the parts that we need in either case. Also avoid running the db migrations when running unit tests, as the schema is copied over from the dev environment it just caues problems. Finally, don't hardcode unit tests to always be in_admin, but rather determine that for each test.
* tests: Make an actual test for ConcertsTableHarald Eilertsen2021-09-111-3/+3
| | | | | | | | | | | There's a bit of setup to make this work as it should, we need to ensure that the current user and current screen is set to proper values so that the WordPress api's `is_admin()` and `current_user_can()` work as they should. This first test just tests that all the expected forms are being rendered for the admin user accessing the table through the site admin interface.
* Fix indentation again.Harald Eilertsen2021-09-091-8/+10
|
* changes reagding mail sending on concert status changesAndreaChirulescu2021-09-071-14/+13
|
* Fixed wording in mails sent when concerts are assigned/unassingedAndreaChirulescu2021-09-061-4/+29
| | | | Added mailing for when concert status changes. Not sure how to get line break in text mails AND concert status as text
* Fix show only own concerts again.Harald Eilertsen2021-09-061-1/+1
| | | | Missed quitation marks around search term.
* Merge remote-tracking branch 'andrea/andreaschanges' into devHarald Eilertsen2021-09-061-2/+2
|\
| * fixed proper class naming for Apply buttonAndreaChirulescu2021-09-061-1/+1
| |
| * removed some extra characters that got lost in table HTMLAndreaChirulescu2021-09-061-1/+1
| |
* | Refactor Concert::find_concerts.Harald Eilertsen2021-09-061-23/+28
|/ | | | | Make it a bit more compact and fix use of $wpdb->prepare for `currentuser` filter.
* Remove logging from Venue class.Harald Eilertsen2021-09-061-8/+0
| | | | Move logging to presentation/logic layer if necessary.
* Throw instead of log error from Concert class.Harald Eilertsen2021-09-061-14/+9
| | | | | Should get rid of most of the annoying output during testing, and allow moving error handling and logging to the presentation layer.
* Use find_concerts to check for duplicates on create.Harald Eilertsen2021-09-061-5/+24
| | | | This also adds a number of new filters to find_concerts.
* Remove obsolete function Concert::findHarald Eilertsen2021-09-061-13/+0
|
* Use wpdb::get_row in Concert::get()Harald Eilertsen2021-09-061-4/+4
| | | | | Makes it clearer that we're just fetching _one_ row from the database. Also updated doc comment to hopefully be a bit clearer.
* Remove unneccesary code to sort single concert by date.Harald Eilertsen2021-09-061-1/+0
|
* Fix indentation and whitespace, add braces where missing.Harald Eilertsen2021-09-061-41/+46
|
* Merge remote-tracking branch 'andrea/andreaschanges' into devHarald Eilertsen2021-09-051-4/+5
|\
| * added images for checkbox and rediconAndreaChirulescu2021-09-051-4/+5
| | | | | | | | added class for City dropdown form
* | security: Add proper CSRF checking for the import_gigs form.Harald Eilertsen2021-09-051-3/+7
|/
* used auto ident this timeAndreaChirulescu2021-09-051-165/+165
|
* used is_admin() to check if user shoudl see xtra columnsAndreaChirulescu2021-09-051-184/+184
| | | | Re-idented the file
* File to display concerts inside a page by calling getconcerts codeAndreaChirulescu2021-09-051-0/+14
|
* Extra changes to hide admincolumns on giglog page If logged in but not using ↵AndreaChirulescu2021-09-051-6/+8
| | | | plugin
* CHanges in the concerts table for logged/non logged user. Fixed row header ↵AndreaChirulescu2021-09-052-19/+31
| | | | with city
* Fix some bugs in generated HTML for ConcertsTable.Harald Eilertsen2021-09-051-5/+5
|
* Merge remote-tracking branch 'andrea/andreaschanges' into devHarald Eilertsen2021-09-054-12/+35
|\
| * Re-added the changes for looks, and city/venue selectorAndreaChirulescu2021-09-052-14/+14
| |
| * Merge branch 'dev' of ↵AndreaChirulescu2021-09-054-252/+292
| |\ | | | | | | | | | | | | | | | | | | https://code.volse.net/wordpress/plugins/gigologadmin.git into andreaschanges # Conflicts: # includes/admin/views/giglog_admin_page.php
| * | Ordered venues by name in drop downAndreaChirulescu2021-09-051-1/+2
| | |
| * | Fixed filter by your concertsAndreaChirulescu2021-09-053-11/+34
| | | | | | | | | | | | Added CSS and extra fromatting to table
| * | Fixed a call to city() method in concert.php It needed ->venue->cityAndreaChirulescu2021-09-042-1/+3
| | | | | | | | | | | | Added order by concert date in concert list
* | | ConcertsTable: fix getting city row when changing cities.Harald Eilertsen2021-09-051-1/+1
| | |
* | | Don't error if obsolete indexes or keys are already deleted.Harald Eilertsen2021-09-051-2/+2
| |/ |/|
* | Drop extra query for venue_id in concert queries.Harald Eilertsen2021-09-041-1/+1
| | | | | | | | | | It's not required since the id is in the concerts table too. That's what links them together.
* | Move the concerts table and edit form out of AdminPage.Harald Eilertsen2021-09-043-248/+291
|/ | | | | | | | | | | Currently the AdminPage is still responsible for updating changes to any of the concerts, but I'd like to get that into their respective classes too. That way the AdminPage will just be a simple class to handle the layout of the page, while all the specific functionality is in their own classes. This is also the first step to be able to reuse the concerts table on the public end of the site.
* Fix so concert id is not overwritten by venue id.Harald Eilertsen2021-09-041-5/+8
| | | | | | | | | | | | | | | | | | | | | | | We originally had a more specified query, but simplified it to: SELECT * FROM wpg_concerts LEFT JOIN wpg_venues ON ...; But since both the concerts table and the venues table has a column id, the concert id would be overwritten with the venue id. MySQL/MariaDB does not allow columns with the same name in multiple tables when using unqualified column names in the query. So we need to be more explicit again. I was hoping that the following would work: SELECT wpg_concerts.*, wpg_venues.* FROM .... ; I think MySQL/MariaDB would handle that, but now since php turns the result into an array, where each key must be unique, this again overwrites the concert id with the venue id. So thus a more verbose specification of the columns was necessary.
* Remove obsolete source files.Harald Eilertsen2021-09-042-127/+0
|
* Drop obsolete database tables.Harald Eilertsen2021-09-041-97/+6
| | | | | These tables are no longer being used, so let's remove them and the code to add them.
* Remove obsolete shortcodes.Harald Eilertsen2021-09-044-720/+0
| | | | These are no longer in use, and have been replaced by the admin screens.
* Remove dangling $wpdb ref in AdminPage.Harald Eilertsen2021-09-041-2/+0
| | | | | AdminPage now references the database only through the Concert (and Venue) models.
* Mark recently added concerts as new again.Harald Eilertsen2021-09-042-21/+23
|
* Add timestamp columns to concerts and venues.Harald Eilertsen2021-09-041-2/+17
| | | | To keep track of creation and modification times for each record.
* Make click to unassign from concert work again.Harald Eilertsen2021-09-042-15/+18
| | | | | | As a user can only be assigned to one role at the time, we remove the current user from any role that they may have when clearing the assignment.
* Rename AdminPage::returnuser to assign_role_for_user_form.Harald Eilertsen2021-09-041-5/+5
| | | | It did not return any users, but a form so name it for what it does.
* Make click to assign concert/role to self work again.Harald Eilertsen2021-09-041-29/+25
|
* Editing concerts now work again.Harald Eilertsen2021-09-032-24/+63
|