aboutsummaryrefslogtreecommitdiffstats
path: root/perllib/FixMyStreet/DB/ResultSet/Nearby.pm
Commit message (Collapse)AuthorAgeLines
* Allow multiple selections in report list filter.Zarino Zappia2016-10-13-2/+2
| | | | | | 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.
* Fix cobrand restriction of My/Nearby.Matthew Somerville2015-12-15-1/+6
| | | | | | | | | | | | 5c79337 simplified a bit too far, as after then a particular cobrand could in Nearby and My only filter reports to a particular body, not any other criteria. To fix this, introduce more generic functions in the default cobrand to allow more flexibility. Make sure a few tests delete their bodies fully so that new tests pass when run as part of the suite. Fixes #1289.
* Simplify/consolidate body restriction db code.Matthew Somerville2015-08-19-4/+2
| | | | | | | Make dashboard work properly in two-tier councils, showing reports sent to both. Create an index on the array of the bodies_str column to speed up performance, and use that throughout the code replacing all LIKE scans. This also enables a simplifying tidy of the restriction code.
* Improve stored procedure performance.Matthew Somerville2015-08-10-12/+0
| | | | | Add an index on the radian values, make the function stable, and switch to a full bounding box rather than a slower angle check.
* Allow /ajax to be filtered by statusDave Arter2015-06-29-2/+6
| | | | | If present, the 'status' param can be set to 'open' or 'fixed' to display ensure only open or fixed reports respectively are included in the response.
* Add category filtering support to /ajax via 'category' GET paramDave Arter2015-06-29-1/+2
|
* Update database fetching to fetch needed data for previous commit.Matthew Somerville2013-01-08-6/+1
|
* Allow unconfirmed as a visible state in Zurich, adjust front end list/item ↵Matthew Somerville2012-12-19-1/+1
| | | | templates to suit.
* make around test for non public reports work, and do not display nonStruan Donald2012-09-03-0/+1
| | | | public reports on around page
* Fix nearby photo handling for #227.Matthew Somerville2012-02-23-1/+1
|
* Nearby list needs photo too, and via nearby object (for #227).Matthew Somerville2012-02-23-1/+1
|
* stop using hard coded names for fixed/visible states ( work in progress )Struan Donald2011-06-16-1/+1
|
* Move the tricky nearby DB call to its own Result/ResultSet, and move more ↵Matthew Somerville2011-06-09-0/+50
functions.