aboutsummaryrefslogtreecommitdiffstats
path: root/bin/oxfordshire
Commit message (Collapse)AuthorAgeLines
* [Warwickshire] Add archive script data.Matthew Somerville2018-03-14-4/+5
| | | | Add an update with each report closure.
* [Oxfordshire] Allow lat/lon to be sent as integers to Exor Open311 CGIDave Arter2017-12-19-1/+1
| | | | | | | | | | It took a few years but somebody finally made a report at a whole-number lat/lon (52°N in this case) which was duly rejected by the OCC Exor script as not being a valid coordinate due to the assumption that all lat/lon values will contain a ‘.’ character. This commit makes the decimal part of the value optional, allowing integer values to be sent.
* [Oxfordshire] Clearly mark RDI emails if sent from stagingDave Arter2017-11-08-1/+7
| | | | Fixes mysociety/fixmystreetforcouncils#251
* [Oxfordshire] Make sure RDI file is encoded.Matthew Somerville2017-09-21-1/+2
| | | | | body_str is encoded with the provided charset/encoding, body is used as-is (and so will die in email sending if it contains wide characters).
* [Oxfordshire] Log when problems sent by RDI email.Dave Arter2017-09-11-0/+1
| | | | | | | | The timestamp of when a problem was included in an RDI is shown on the problem’s inspector form. Also check back and include any inspected reports that for some reason haven't been instructed yet. Fixes mysociety/fixmystreetforcouncils#223.
* Move FixMyStreet::DB to FixMyStreet::DB::Schema.Matthew Somerville2017-08-09-1/+1
| | | | Store a schema object on FixMyStreet::DB instead.
* [Oxfordshire] RDI file should show all inspections as happening on the same dateDave Arter2017-07-24-0/+2
| | | | Fixes mysociety/fixmystreetforcouncils#203
* [Oxfordshire] Send RDI reports by email.Matthew Somerville2017-05-16-0/+69
|
* [Oxfordshire] Open311 update timestamps should be in UTCDave Arter2017-02-15-1/+17
| | | | | | | | | | The timestamps returned from the database are in server-local time, not UTC. Because FMS expects timestamps in Open311 responses to be UTC, the timestamps of updates from OCC appear one hour ahead when DST is in effect. This commit converts the timestamps to UTC before outputting them. Fixes mysociety/FixMyStreet-Commercial#499
* [Oxfordshire] Old report archiving scriptpezholio2017-02-15-0/+29
| | | | | | | | | | | | | | | This script can be used for the bulk closure of old reports that haven't been updated in a long time. Reports that haven't been updated in a *really* long time (since 2014, by default) are simply closed, and those that haven't been updated since 2015 (by default) are closed and an email explaining the closure is sent to the report creator. This script can be used for other cobrands, but they'll need an archive.{txt,html} template in order for the emails to be sent. For mysociety/fixmystreetforcouncils#51
* Update code.fixmystreet.com references to fixmystreet.org.Matthew Somerville2014-03-19-3/+3
|
* force upper case on certain PEM fieldsDave Whiteland2013-07-25-4/+4
|
* change field length for ce_description to 1970Dave Whiteland2013-04-11-1/+1
| | | | | OCC report that the Action/Remarks field has max size of 1970, which matches our experience of 2000 (from the PEM docs) choking.
* fix truncation in Oxfordshire Open311 script (debug/test left in? gah)Dave Whiteland2013-03-14-1/+1
|
* suppress debug output from Oxfordshire script for deploymentDave Whiteland2013-01-28-6/+7
|
* rationalised old oxfordshire/open311_service_request.cgi to require shared ↵Dave Whiteland2013-01-24-116/+5
| | | | open311_services.pm
* add status criteria to effectively ignore error records in Oxfordshire's ↵Dave Whiteland2013-01-21-2/+5
| | | | update table
* fix HH24 date format, and use Oracle ROWNUM not LIMIT in SQLDave Whiteland2013-01-21-9/+12
|
* Oxfordshire scripts for connecting with Bentley/PEM (council back-end) table ↵Dave Whiteland2013-01-21-0/+272
| | | | of 'service request updates'
* Oxfordshire: whoops, from_to is in-place; fixed it but didn't commit promptlyDave Whiteland2012-12-21-3/+4
| | | | Also make it clear that encoding can be disabled from config file.
* added better test switch for commmand line test of OCC scriptDave Whiteland2012-12-20-6/+15
|
* add win encoding to Oxfordshire Oracle data before insertingDave Whiteland2012-12-20-3/+8
|
* some tidying, simply closest_address string according to Oxfordshire's requestDave Whiteland2012-12-19-42/+45
|
* tidy up char stripping, at point of binding, so it doesn't affect earlier ↵Dave Whiteland2012-12-19-21/+36
| | | | processing
* strip .full from incoming media URLs for OxfordshireDave Whiteland2012-12-19-0/+2
|
* pass closest_address string straight into OCC's ce_location field, which was ↵Dave Whiteland2012-12-19-35/+3
| | | | the Right Thing to do at the very start, gah
* pass nearest address over to Oxfordshire in its entirety, parse at point of ↵Dave Whiteland2012-12-19-9/+37
| | | | insertion
* fix postcode field name errorDave Whiteland2012-12-19-1/+1
|
* tiny changes to testing dataDave Whiteland2012-12-19-3/+5
|
* tidy up field Oxfordshire PEM field typesDave Whiteland2012-12-19-113/+41
|
* added postcode and nearest address to Oxfordshire Open311 callDave Whiteland2012-12-18-0/+12
|
* don't add newlines when adding media_url after stripper control charsDave Whiteland2012-12-17-3/+3
|
* add configurable setting for stripping control chars for Oxfordhsire EXOR entryDave Whiteland2012-12-17-2/+20
|
* tidied some debugging, moved config file to top of file now we're using it ↵Dave Whiteland2012-12-14-37/+37
| | | | for all instal-specific settings
* remove fake insert for command-line testsDave Whiteland2012-12-14-3/+3
|
* add media_url to description bodyDave Whiteland2012-12-14-5/+8
|
* print out fake (test) return value for now, and remove inout ORA_typesDave Whiteland2012-12-14-4/+5
|
* add ORA types for return values, add mandatory incident_datetimeDave Whiteland2012-12-14-3/+8
|
* just make the stored procedure call -- simpler SQL -- don't declare it hereDave Whiteland2012-12-14-98/+38
|
* only bind the params that we need, now defaults are in thereDave Whiteland2012-12-14-3/+2
|
* explicit SQL declaration of the procedureDave Whiteland2012-12-14-4/+90
|
* add CGI script for Oxfordshire to absorb incoming Open311 service request POSTsDave Whiteland2012-12-13-0/+510
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-07 15:26:27 +0000