aboutsummaryrefslogtreecommitdiffstats
path: root/perllib/FixMyStreet/DB/ResultSet
Commit message (Collapse)AuthorAgeLines
* [TfL] Do not say council in not responsible.Matthew Somerville2019-12-11-1/+3
|
* Recheck cached front page details against databaseMatthew Somerville2019-11-18-4/+7
| | | | | It was only checking the cached details, so not spotting if a report had been hidden in the time since being cached.
* Sort reporting categories in display order.Matthew Somerville2019-10-31-0/+23
|
* [IsleOfWight] do not mention council in not responsibleStruan Donald2019-10-18-0/+1
| | | | | | Use Island Roads in place of council in not responsible message. Fixes mysociety/fixmystreet-freshdesk#93
* [Oxfordshire] Change update state display name.Matthew Somerville2019-08-23-0/+3
|
* [Bexley] Include subcategory in dashboard export.Matthew Somerville2019-07-12-0/+9
|
* Turn on quote_names.Matthew Somerville2019-06-26-19/+4
|
* Merge in upgraded Catalyst branch.Matthew Somerville2019-05-14-1/+1
|\
| * Update a number of packages.Matthew Somerville2019-05-13-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Update: * Catalyst * Specify Catalyst::DispatchType::Regex explicitly * Remove Catalyst::Plugin::Unicode::Encoding * Catalyst::Plugin::SmartURI * Specify URI::SmartURI explicitly * Catalyst::Plugin::Static::Simple * CGI * Class::Load * DateTime * DateTime::TimeZone * DBD::Pg * DBIx::Class * DBIx::Class::EncodedColumn. * Email::Address. * Email::MIME * ExtUtils::MakeMaker * ExtUtils::ParseXS (for Params::Classify upgrade) * File::ChangeNotify * Image::Size * IO::Socket::SSL * local::lib * Moo * Moose (and some related others due to deprecations) * namespace::autoclean * Net::Server * Net::SSLeay * Number::Phone * Plack * Starman * Template * Test::PostgreSQL * Test::WWW::Mechanize::Catalyst * Text::CSV * YAML carton install was run on a wheezy box, the oldest that is supported, to make sure the required minimal vesions of core modules weren't removed from the snapshot. Cpanel::JSON::XS, Devel::GlobalDestruction::XS, and MooseX::NonMoose were then put back in the snapshot, in case another system needs them (e.g. system Perl on Mac looks for MooseX::NonMoose).
* | Improve non_public photo handling.Matthew Somerville2019-05-07-1/+1
|/ | | | | | | Clear the photo cache if the non_public flag is switched on, do not cache non_public or LOGIN_REQUIRED photos, remove non_public photos from memcached recent lists, pass through any cookies on non_public reports/updates, and check the non_public flag on photo lookup.
* Rename DB::ReportExtraFields to ReportExtraField.Matthew Somerville2019-05-02-1/+1
| | | | It was not being caught by rerun_dbic_loader.pl otherwise.
* Refactor nearby() to use named parameters not listMatthew Somerville2019-02-25-12/+12
|
* Make front page cache time configurable.Matthew Somerville2019-02-04-4/+8
| | | | | Add a configuration variable to use for the front page stats/ recent list, plus the max-age of `/reports`.
* Check cached reports have photos before showing.Matthew Somerville2019-01-10-1/+1
|
* add private only report filterStruan Donald2019-01-04-4/+13
|
* add report_mark_private permissionStruan Donald2018-11-12-1/+2
| | | | | | | | Allows user's to see the inspector panel to mark reports as Private, and also to view those non-public reports. Useful for call centre staff who want to record private reports but don't need to other permissions. Fixes mysociety/fixmystreet-commercial#1213
* Have body.url work in hashref lookup.Matthew Somerville2018-10-10-0/+8
| | | | | | | body.url could still be in use by old-school /reports table index pages (though they were dropped in 2.1, so a cobrand would have to have overridden it since then) and the update to speed up body lists in #2248 broke it. This puts it back in minimal form.
* Speed up fetching lists of bodies.Matthew Somerville2018-09-25-5/+74
| | | | | | Use a HashRefInflator wherever all_sorted is used, with consequential changes to deal with it now not being an object (e.g. add some with_* functions for manual fetching of extra data).
* Only display reports from last 6 months on around.Struan Donald2018-07-03-1/+7
| | | | | | | Add a checkbox to show older reports, plus if we get to the end of the new reports then instead of a Next button show a "show older" button that will reload the current page but with older reports also loaded. Wire it all up into the pushState code as well.
* Use correct created column in problem timeline.Matthew Somerville2018-06-13-3/+3
| | | | The User model now also has a created column.
* Escape data attributes in template.Matthew Somerville2018-05-23-8/+5
| | | | | | This fixes a bug whereby a double quote in an item would not be JSON-escaped due to being HTML-escaped first, meaning it would not parse as JSON on the client.
* Allow cobrands to give extra parameters for pins.Steven Day2018-05-02-1/+7
| | | | | | | So that you can build functionality to add extra limitations on to the map pins displayed. Useful for Collideoscope initially to filter out (or in) reports from the Department of Transport's Stats19 Data.
* Check recent reports for any hidden since cached.Matthew Somerville2018-04-06-22/+13
| | | | | Also stop caching lat/lon specific alert photo lists, and improve Memcached code.
* [Zurich] Switch to more modern database states.Matthew Somerville2018-03-07-2/+2
| | | | | | | The Zurich code was written a long time ago, and used overriding so that e.g. the hard-coded 'investigating' state referred to Wunsch (wish). Now that states are stored in the database, we can create ones specially for Zurich and use them instead. Hooray!
* Show non_public reports to staff on list pages.Matthew Somerville2018-02-13-6/+34
|
* Remove unused (except by tests) send_reports() fn.Matthew Somerville2018-01-15-6/+0
|
* Add some new Body model helper methods.Matthew Somerville2018-01-03-3/+72
| | | | And use the existing ones more.
* Add pagination to around page.Matthew Somerville2017-11-06-3/+6
|
* Remove Show all pins link and on_map_list_limit.Matthew Somerville2017-11-06-7/+2
| | | | | /around will now show all reports all the time, but we are about to introduce pagination to stop that.
* generate update text in alerts if problem state has changedStruan Donald2017-10-05-1/+5
|
* Add 'verified' database columns for email/phone.Matthew Somerville2017-09-30-0/+35
| | | | | These are so we can state whether a user's email address or phone number have been verified by confirmation email/text.
* Revert using memcached cache in testing.Matthew Somerville2017-09-18-1/+4
| | | | This can fail if the tests are being run in parallel.
* Fix issues with Open/Closed translated too early.v2.2Matthew Somerville2017-09-15-3/+9
| | | | | | | | | | | | | | It was possible for _hardcoded_states to be reached with no locale selected (e.g. bin/update-all-reports), causing an error trying to translate Open/Closed. But translating those there wasn't correct, because that would then be cached and returned even if a different language was being used. Caching was ignored in testing, which did not help. We no longer translate the state names in their objects, only upon display at the point that we will know the locale. We can't simply return the translation of Open/Closed because there may be entries in the translation table as well.
* Remove hardcoded states from templates.Matthew Somerville2017-08-31-1/+2
| | | | | | | | | | | State display names are now got from the database wherever they are displayed, including admin dropdowns, list filters, and update meta statements. This also covers the open/closed/fixed 'groups'. This also fixes a bug whereby if e.g. an update has problem_state investigating, the next update has no problem_state, and the last update has investigating again, it was previously showing a state change to investigating on that third update.
* Remove hardcoded states from Problem model.Matthew Somerville2017-08-31-0/+77
| | | | | We keep the internal states hardcoded, plus the core open (confirmed) and closed ones, but the remainder are moved to the database.
* Faster /reports for inspectors, reduce db queries.Dave Arter2017-08-18-1/+11
|
* Add site-wide extra fields for reports, and admin UI to manageDave Arter2017-08-17-0/+25
| | | | | | | - Also provides an editor for the extra Open311 fields on contacts. - Adds .btn--small class for small buttons Fixes #1743.
* Add fn to fetch bodies plus the translated names.Matthew Somerville2017-08-15-0/+11
|
* Only use active categories for making new reports.Matthew Somerville2017-07-14-0/+5
| | | | | Inactive ones can still be used for e.g. list filtering, but not when making a new report.
* Add inactive state to categories.Matthew Somerville2017-07-14-5/+5
| | | | | A new 'state' column replaces confirmed and deleted, allowing categories to be unconfirmed, confirmed, deleted or inactive.
* Update templates when category/state changed.Matthew Somerville2017-06-30-0/+27
| | | | | | When the category or state changes, the list of available templates updates (previously it was frozen at what the category was on page load, and didn't care about the state).
* Return Response Priorities as JSON.pezholio2017-06-20-13/+11
| | | | | This now lets the response priority and defect type handling share the same code.
* Populate defect types dropdown on category changepezholio2017-06-20-13/+19
|
* Add customisable defect types.Dave Arter2017-03-23-0/+22
| | | | | | | | | Problems can have an associated defect type, that can be assigned during an inspection. Include an admin interface for managing these types, that can also be assigned on a per-category basis, currently available to the Oxfordshire cobrand. (Also include 'TM' in traffic management Exor RDI output.)
* Update priorities in inspect form on cat. change.Matthew Somerville2016-12-15-0/+22
| | | | | Different categories may have a different list of priorities, so store them all and update as the category changes.
* Add sort order options to list pages.Matthew Somerville2016-11-04-11/+23
| | | | | | | | Includes newest, oldest, least/most recently updated, and most comments. The default remains the same, which is last updated on /reports, and newest on /my and /around (the latter plus not-in-view sorted-by-distance ones).
* Merge branch 'issues/forcouncils/95-multi-select-list-filters'Matthew Somerville2016-10-13-4/+4
|\
| * Allow multiple selections in report list filter.Zarino Zappia2016-10-13-4/+4
| | | | | | | | | | | | This lets people filter by multiple categories or states. It uses our jQuery multi-select plugin to turn the <select multiple>s into little overlay lists of checkboxes. HTML5 history is also supported.
* | Adding report to shortlist removes from others.Matthew Somerville2016-10-11-0/+23
|/
* Pass back Open311 request through send_reports for tests.Matthew Somerville2016-08-24-1/+1
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-26 03:12:10 +0000