EcoGas 600 Series - Software Release Notes

EcoGas 600D - Database

version
release date
release notes
 
8.9.5 
2021-09-22 
Features added: new report "time to repair leaking devices" added to Managers Overview and Admin sections, and tweaks to device transactions pages to show device models and reasons for top ups and refills. 
 
8.8.5 
2021-09-13 
feature addded: add columns for 'top up reason', 'leak location' and 'refill reason' to cylinder and device transaction pages in MANAGERS OVERVIEW and ADMINISTRATOR sections 
 
8.7.5 
2021-09-13 
bugfixes in ADMINISTRATOR and MANAGERS OVERVIEW sections:
1. tidy up of device disposal requests pages: format delta if !=0 to number_format 2
2. show 'request date', 'contractor name', and remove 'pickup site'. 
 
8.7.4 
2021-08-19 
feature added: show gas_transacted values as they are calculated from last_finish_wt - start_wt, and last_finish_wt_oc - start_wt_oc (ie no longer absolute values) and highlight negative top-ups in red. 
 
8.6.4 
2021-08-17 
bugfix: sort device disposal requests from last to first
and remove 'pickup_site' field throughout. 
 
8.6.4 
2021-08-17 
New feature: Add 'Reason for Top Up' to cylinder transactions.
Bugfix: tweak users page to set select_contractor = 0 by default. 
 
8.5.3 
2021-08-17 
Features added: Ignore top ups within 1 day of all refills except 'routine maintenance' for Top Ups by Region and show negative top ups in red. 
 
8.4.3 
2021-08-13 
features added: 1. consider top ups soon after a refill for repair, as part of the repair refill procedure and not a top up indicating a further leak.
2. show is top up is for leak, and where leak, and reason for refill on device transactions pages
 
 
8.3.3 
2021-08-04 
feature added: allow 'non-refillable' but recertifiable cylinders to show the certification date on the cylinders page in Admin section. 
 
8.2.3 
2021-08-03 
features added:
1. colour coding added to device top ups report by region
2. add previous year to gass losses by region report. 
 
8.1.3 
2021-07-20 
bugfix: add script to allow selection of person who performed a transaction, where the system has been simplified for one 'contractor'. 
 
8.1.2 
2021-06-29 
Bugfix: MANAGERS OVERVIEW and ADMINISTRATOR sections - tweak sql queries on 'gas-inventory-on-certain-date.php' to pick up proper chronology of cylinders returned to store after transactions on a cylinder. 
 
8.1.1 
2021-05-31 
new feature: add gas cart details pages to capture and display details about each gas cart, including manual pdfs and photos.
bugfix: fix issue with home page selection of cylinders for transactions. 
 
8.0.0 
2021-05-12 
MAJOR change to MYSQL table structures to work with MYSQLI v5.7: generally change 'date' to varchar and assign defaults for other fields incl integers, also rename 'timestamp' to 'data_timestamp', and change scripts throughout the sites to rename variables. 
 
7.0.0 
2021-04-29 
MAJOR SOFTWARE UPGRADES, SERVER OS UPGRADE upgrade to PHP v7 and MySQL v5.7+, upgrade to mPDF v8, PHPMailer v6+, MessageMedia PHP-to-SMS API v2.2.1. Upgrade Server OS to CentOS 7 and subsequent upgrade to CPanel & WHM. 
 
6.12.15 
2021-03-01 
feature tweaked: Admin section - Tweak nameplate calc to be the lowest id for that device position, for '5 Worst Decomm. Degas/Nameplate Deltas by Service Area for the last 12 months' page.
Managers Overview section - add 5 new reports from Admin section to this section:
5 Worst CB Topups by Service Area for the last 12 months
5 Worst Transaction Deltas by Service Area for the last 12 months
5 Worst Stocktake Deltas by Service Area for the last 12 months
5 Worst Refill Deltas by Service Area for the last 12 months
5 Worst Decomm. Degas/Nameplate Deltas by Service Area for the last 12 months
 
 
6.11.15 
2021-02-26 
new features: Admin section - new reports added:
device maintenance degas deltas by service area (region) for last 12 months
device decommission degas/nameplate deltas by service area (region) for last 12 months
updates to Admin menu
 
 
6.10.15 
2021-02-26 
features added: Admin section - new reporting of topups and operational losses by service area; add 'service areas' or regions to depots table to allow lookup of devices and depots by service area.
Contractors section - increase transaction notes from 350 chars to 1000 chars
 
 
6.9.15 
2021-02-22 
bugfix: Admin section - optimise call to PHPMailer at top of new-users page 
 
6.9.14 
2021-02-17 
feature tweaks: Contractors section - further tweaks to cylinder transaction pages to show utility field and save to db
 
 
6.8.14 
2021-02-16 
feature tweaks:
1. add 'Utilty' to device disposal requests, device disposal transactions, and cylinder transaction details.
2. simplify the device diposal request form - remove ajax lookup scripts for pickup site addresses, asset num, manu, model etc. Manual fill in fields instead, except asset type (eg CB, RMU etc). 
 
6.7.14 
2021-02-12 
bugfixes: Admin section
- save total_wt to db when adding a new cylinder
- extend allowable length of urgent_message on desktop homepage to 1000 chars 
 
6.7.13 
2021-02-12 
feature tweaks: Admin section - add operator drop down list for store stock take, also remove ability for admin to edit start_wt, finish_wt via the view_cylinder_trans page. 
 
6.6.13 
2021-02-11 
bugfix: tweak permissions on database homepage, to turn of admin and superuser powers to buttons, except for Administrator button 
 
6.6.12 
2021-02-10 
bugfixes: MANAGERS section - update cookie check script to exclude users without 'managers_access'. 
 
6.6.11 
2021-02-10 
bugfix: Device Disposal Request pages in Admin and Managers sections: change title of popup screen from asset no. to serial no. 
 
6.6.10 
2021-02-09 
feature added: Admin section - users can be locked out of the site while a software upgrade is in progress with the click of one button, and granted access again when upgrade is over in the same way. Alert message addded to login screen if user is locked out. 
 
6.5.10 
2021-02-05 
bugfix: 600P cookie check script - fixed bug that kicked user out of 600P section if admin or superuser
feature tweak: change_user_settings page - added script to run during update, for changing permissions of users for 600D, 600E and 600P sections. 
 
6.5.9 
2021-02-05 
bugfix: fixed the bug whereby if a user logged in, then went to a page, but used back button in browser, a "Document Expired..." message would occur 
 
6.5.8 
2021-02-04 
bugfix: contractors section - tweak script where user can select contractor, and hasn't selected the contractor yet 
 
6.5.7 
2021-01-21 
bugfix: ADMIN section - tweak code so admin can change limits for a 600P device regardless of the table starting with id=1 
 
6.5.6 
2021-01-19 
bugfix: Managers Overview section - fix wrapping of menu with extra menu items 
 
6.5.5 
2021-01-18 
feature tweak: CRON SCRIPTS section - REMOVE db connection variables from individual CRON SCRIPT files, instead include link to 'db_connect_params.php' 
 
6.4.5 
2021-01-15 
feature tweaks: homepage
hide 'inactive' cylinders from drop downs - allows PBA cylinders to be inactivated so PBA users can't put gas into cylinders that are allocated to a device disposal customer.
format the blocks of buttons
update ecogas600 header logo with 'D' and byline removed 
 
6.3.5 
2021-01-14 
bugfix: tidy up show/hide of menu buttons on homepage
 
 
6.3.4 
2021-01-14 
bugfix: update header logos for Device Disposal to 600E, and Online SF6 Monitoring to 600P 
 
6.3.3 
2021-01-07 
bugfix: Admin and Managers Overview sections - fix repeating decimal points in emissions results
bugfix: Admin section - fix menu wrapping
bugfix: Admin section - upload missing page 'change emission targets'. 
 
6.3.2 
2021-01-06 
feature tweaks: Admin and Managers Overview sections - tweaks to 'approved filler' pages formatting and sorting, ADD 'approved filler' status to traffic light dashboard email, improve traffic light dashboard email formatting
 
 
6.2.2 
2021-01-05 
feature added: 600E settings added to ADMIN section, to enable customisation of the receivers name, address and phone for device disposal requests.
bugfix: add missing 'image rotate png' image
add device disposal DGD form
add disposal dispatch label pdf form
add new DB table '600E_settings'. 
 
6.1.1 
2020-12-15 
feature added: TOTAL DELTAS panel added to Admin and Managers Overview dashboards
features tweaked in Admin and Managers Overview sections:
- tweak colour of due date for approved fillers to orange
- tweak significant deltas sorting and show all deltas where delta not zero
 
 
6.0.1 
2020-12-11 
bugfix: contractors section - added missing script that was meaning operator name was not carried through to db for transactions other than degas trans. 
 
6.0.0 
2020-12-08 
template change: 600E DEVICE DISPOSAL features amalgamated with 600D and 600P so that all EcoGas releases are aligned. Access to the different sections and the showing of different menu tabs are dependant on permissions set for the user in Admin section (e.g. 600D_access, 600E_access, 600P_access, Add transactions, SF6 Inventory Overview, Managers Overview, Admin etc). 
 
5.72.16 
2020-12-07 
feature added: APPROVED FILLER STATUS
Contractors, Admin, Managers Overview and SF6 Gas Inventory sections:
require the user to select the operator from a dropdown list of staff with that contractor, rather than fill in a free text field
add script to check the approved filler status of the operator if 'maintenance degas' or 'decommission degas' trans_desc chosen
if a degas transaction and user is not an approved filler, add alert message beside their name to highlight this - but allow transaction to be recorded
if a degas transaction and user is an approved filler, but their certificate has expired, add alert message to alert user
if a degas transaction and user is an approved filler with current certificate, then no alert message
 
 
5.71.16 
2020-12-04 
feature tweak: Admin section - REMOVE ability for admin to change total_wt in cylinders table 
 
5.70.16 
2020-12-01 
feature added: Admin section - add ability to change recipients of traffic light dashboard email 
 
5.69.16 
2020-10-09 
bugfix: fix rolling emissions data 
 
5.69.15 
2020-10-01 
feature tweak: ADMIN, MANAGERS OVERVIEW and SF6 Inventory Overview sections - hide scrapped cylinders from cylinder data page. 
 
5.68.15 
2020-09-10 
feature tweak: remove limits on 'equip_press_prior':
set min = 0 for all users and set message same for all users
 
 
5.67.15 
2020-09-07 
feature tweak: CONTRACTORS section, cylinders_currently_held page
altered to get 'last_finish_wt' if no transactions logged against the cylinder for example the cylinder has just been issued 
 
5.66.15 
2020-09-07 
feature tweak: CONTRACTORS section - change query on 'cylinders currently held' page to sort by the order_id in case several transactions occur on the same date 
 
5.65.15 
2020-08-20 
feature tweak: 600P Online SF6 Monitor:
- dashboard changed so if topup, the message is same as the email_updates message
- 600P cron scripts section - email_updates.php page add ability to add topup step threshold
- Admin section - add ability to add topup step threshold on email updates test page
- Admin section - add ability to create topup in test data, to test email updates
 
 
5.64.15 
2020-07-17 
bugfix: CONTRACTORS and MANAGERS OVERVIEW sections - tweak format of transaction descriptions in popup or view page 
 
5.64.14 
2020-06-30 
bugfix: update cylinders table with store_issued_wt, contr_recevd_wt, and contr_return_wt when cylinders issued and received by contractor and returned by contractor. 
 
5.64.13 
2020-06-29 
feature tweaks: replace hyphen with underscores in asset and site names in 600P cron scripts
ADMIN and SF6 Inventory Overview sections - gas inventory on a certain date pages
- admin view has extra columns to compare with cylinders table and shows deltas
- logic of queries tweaked in particular check if cylinder is scrapped first 
 
5.63.13 
2020-06-25 
feature tweaks: 600P Online DGA section
- add variable for top up threshold delta
- ignore last day of data if sensing stopped more than a day ago - saves seeing spurious leakage rates or false 'top up' at end of sensing period
- ignore zero values in Chart and in calcs 
 
5.62.13 
2020-06-23 
feature tweak: CONTRACTORS section - add ability for contractor to add cylinder transaction even if no contractors assigned to the user 
 
5.61.13 
2020-03-09 
feature tweak: ADMIN and MANAGERS OVERVIEW sections - exclude UTF CBs (UTF-CB-%) and PBA Workshop devices (PBA-%-WS) 
 
5.60.13 
2020-02-28 
feature added: add 'Request Support' button on home page that links to a form on PBA's sharepoint and logged in PBA's support ticket system 
 
5.59.13 
2020-02-18 
feature added: last months emissions CSV file generated and emailed to specific recipients 
 
5.58.13 
2020-02-14 
bugfix: tweak total emissions calculations script 
 
5.58.12 
2020-02-12 
feature added: ADMINISTRATOR section device_model_discrepancies.php page added to show discrepancies between transactions table for position/model pairs and device_positions table 
 
5.57.12 
2020-01-21 
feature tweak: CONTRACTORS section - cylinder transactions;
equip press prior - allow down to zero if PBA staff
equip press after - allow down to zero if degas 
 
5.56.12 
2020-01-16 
feature tweak: CONTRACTORS section adding transactions - reduce min equip pressure to 0 mbar (from 50) 
 
5.55.12 
2020-01-09 
bugfix: CONTRACTORS section correct code to allow ability for users to input transactions up until 1 March for previous period ending Dec 
 
5.55.11 
2019-11-19 
feature added: ADMIN, MANAGERS OVERVIEW and CONTRACTORS sections - consolidate separate connections to the database for ajax scripts to one file in the includes folder 
 
5.54.11 
2019-11-11 
feature added: ADMIN section - highlight decommissioned devices on device data page drop down filter list with a different colour. 
 
5.53.11 
2019-10-24 
feature added: CONTRACTORS section - extend limit for transaction notes to 350 chars, when adding a cyl transaction record. 
 
5.52.11 
2019-10-21 
features added: ADMIN and MANAGERS OVERVIEW sections - emissions dashboard - split GIS into sites, tweak display
added new Emissions Report pages and Emissions Dashboard to Managers Overview 
 
5.51.11 
2019-10-17 
features added: ADMIN section
1. exclude 'PBA-%-WS' and 'UTF-CB-%' devices from emissions calcs (where % is a wild card character)
2. hide zero emissions from emissions dashboard
3. hide zero refills, degasses etc from emissions tables
4. highlight devices with no nameplate data in red in table.
5. add settings to show/hide queries for debugging.
6. add settings to show/hide decommissioned devices for testing
7. change the display of all numbers to 2 decimal points.
 
 
5.50.11 
2019-10-16 
feature added: ADMIN section - add ability to change emissions targets on emissions dashboard from ADMIN page.
 
 
5.49.11 
2019-10-10 
features added: ADMIN and MANAGERS OVERVIEW dashboards - change '10 worst models by freq of top ups' and change non-remediated popup chart.
Non-remediated changes: reset by decommission degas, maintenance degas, or refill existing, but if subsequent top up then no longer considered remediated.
Rename dashboard charts to 1. "Asset Device - Leak Status", and 2. "Asset Model - Leak Status". Add y-axis titles
Reorder chart 2 by total remediated and non-remediated device numbers. 
 
5.48.11 
2019-10-05 
feature added: ADMIN & MANAGERS OVERVIEW sections - change from 5 to show 10 worst devices by qty of top ups. 
 
5.47.11 
2019-10-01 
feature added: ADMIN section - add ability for ADMIN to decommission or recommission a device. 
 
5.46.11 
2019-09-23 
feature added: MANAGERS OVERVIEW section - - add '(kgs of sf6)' to legends on rolling emissions and topups chart. 
 
5.45.11 
2019-09-09 
bugfix: CONTRACTORS section - add script to check if cyl_id_oc to get last_finish_wt_oc and compared dates to see if this cyl_to_cyl trans was the last transaction - if so report this last_finish_wt for cyl 
 
5.45.10 
2019-11-25 
bugfix: ADMIN section - tweak inserting contractor page (misspelt contractor). 
 
5.45.9 
2019-07-16 
features added: MANAGERS OVERVIEW section - 'decommission degas CB' now remediates a device; show first 10 CB's with worst frequency of top ups. 
 
5.44.9 
2019-07-15 
features added: MANAGERS OVERVIEW and CONTRACTORS sections - hide decommissioned devices from device data pages and drop downs
feature added: ADMIN section - grey out decommissioned devices on device data page. 
 
5.43.9 
2019-07-04 
feature added: ONLINE SF6 MONITOR (600P) section - limit charting of charts to last 5,000 to 10,000 datapoints (due to limitation of web server). 
 
5.42.9 
2019-07-02 
bugfix: total emissions start date to end date calculations - unhide a component of the A2 calculation. 
 
5.42.8 
2019-07-01 
features added: ONLINE SF6 MONITOR (600P) section and sms and email alerts - amend leakage rate, alarm limit calc and limit state calculations;
leakage rate calc - if leakage rate <1 set leakage rate = 0
alarm limit calc - if timestamp of alarm sms is before last avg timestamp then hide.
limit state calc - if timestamp of limit state is before last avg timestamp then hide. 
 
5.41.8 
2019-05-25 
bugfix: CONTRACTORS section - cylinders currently held page - tweak code to if no transaction yet, get current_wt from total_wt in cylinders data table. 
 
5.41.7 
2019-05-25 
features added: ADMIN section - add scripts to show devices not in device positions table, add category names to emissions calcs scripts, add new pages to show devices with multiple models, and devices with different models - transactions table vs device position table.
bugfix: add >= and <= to emissions sql queries to be inclusive of transaction start and end dates 
 
5.40.6 
2019-05-13 
features added: ADMIN section - add ability to import a csv file of new devices without the script pausing to show which are new and which are duplicates etc.
feature added: ADMIN, MANAGERS OVERVIEW and STORE ACCESS sections tweak key for nameplate and status datapoints on device data pages. 
 
5.39.6 
2019-05-09 
features added: ADMIN & MANAGERS OVERVIEW sections - upgrade jquery, bootstrap etc links on index pages.
- update formatting of charts
- add modal window to remediated/not remediated chart that opens to show non-remediated devices for a model, showing sum of gas top ups and number of top ups. 
 
5.38.6 
2019-05-06 
feature added: 600P - add script to email updates script to check if last data is older than 1 day, then skip this device. 
 
5.37.6 
2019-05-06 
feature added: MANAGERS_OVERVIEW section - update chart data '5 worst devices by qty of top ups' so resets if 'refill existing CB' or 'fill new CB' - ie same as chart on ADMIN dashboard. 
 
5.35.6 
2019-05-05 
features added: ADMIN & MANAGERS OVERVIEW sections and traffic light email updates - add yellow and green columns to traffic light dashboars, for 2 top ups in a row in 2 years [yellow] and 1 top up in 1 year [green]. 
 
5.34.6 
2019-05-05 
feature added: ADMIN & MANAGERS OVERVIEW sections - 1. rename chart to "5 worst devices by qty of top ups"
2. recalculate "5 worst models by freq of top ups" to look at those device/model pairs that have been remediated or not remediated (remediated indicated by maintenance degas CB and/or refill existing CB). 
 
5.33.6 
2019-04-24 
feature added: ADMIN section - test to split emissions calcs by category 
 
5.32.6 
2019-04-16 
features added: ADMIN section - change the device data export as excel and export as csv pages to same fields and same order as csv import 
 
5.31.6 
2019-04-11 
feature added: ADMIN section - add function to remove excess hyphens from device data
feature added: ADMIN, MANAGERS OVERVIEW and SF6 MONITOR sections - change columns on device data pages; add 'category' and 'asset_type', and change order of columns to match csv import screen. 
 
5.30.6 
2019-03-28 
feature added: CONTRACTORS section - added cutoff date of 1 March to limit transactions being entered for previous emissions period (ending 31 Dec) however Admin can continue to enter transactions 
 
5.29.6 
2019-03-27 
feature added: CONTRACTORS section - make maximo field compulsory 
 
5.28.6 
2019-03-21 
features added: ADMINISTRATOR and MANAGERS OVERVIEW sections - add new files to allow selection of start and end dates for emissions calculations and generating pdfs of the same (supersedes 'previous-previous-previous' etc emissions pages)
 
 
5.27.6 
2019-03-19 
features added: ADMINISTRATOR section - added new fields 'configuration', 'category', 'asset_type' to the device_position database table and the import device data page. 
 
5.26.6 
2019-03-19 
features added: ADMINISTRATOR section - add emissions_reports folder and save pdfs of previous periods to the folder for future reference. 
 
5.25.6 
2019-03-11 
features added: ADMIN and MANAGERS OVERVIEW sections - add calculations to show emissions 3 years ago 
 
5.24.6 
2019-02-26 
feature added: CONTRACTORS section - change error message on adding transaction pages - dependent on whether maintenance degas or decommission degas then >50 mbar required otherwise >1000 mbar 
 
5.23.6 
2019-02-18 
features added: CONTRACTORS section - add current_wt column to cylinders held page
features added: ADMINISTRATOR secction - on cylinders issue page save dew_point_issued to transaction record.
 
 
5.22.6 
2019-01-24 
feature added: CONTRACTORS section - add condition if maintenance degas or decommission degas then min pressure 50 mbar down from 1000 mbar for other transaction types:
 
 
5.21.6 
2018-11-26 
feature added: ADMINISTRATOR section - add new page to admin section to change the 600P limits
bug fix: ONLINE SF6 MONITOR - CDN links replaced with local scripts
 
 
5.20.5 
2018-10-19 
features added: CONTRACTORS - add new fields to transaction_details db tables and to transaction recording pages to capture whether top up is due to a leak, where is leak?, if refill what is reason?, and show on transaction reporting pages.
features added: SF6 MONITOR/MANAGERS OVERVIEW/ADMIN sections - speed up loading of cylinder transaction summary pages by separating out the view pages 
 
5.19.5 
2018-10-18 
feature added: ONLINE_SF6_MONITOR two phases pressure nominal page - add script to ignore zero data points 
 
5.18.5 
2018-10-18 
feature added: ADMIN and MANAGERS OVERVIEW sections - rolling emissions and topups data page added
bug fix: ADMIN and MANAGERS OVERVIEW sections - tweak link to summary data 
 
5.17.4 
2018-09-25 
features added: ONLINE SF6 MONITOR - add tweak to show data on pressure-normalised charts even if points are well below the lockout limit or above the nominal limit 
 
5.16.4 
2018-09-25 
features added: ONLINE_SF6_MONITOR - checking script added to importing data feature, leakage calculation as per dashboard added to update email. 
 
5.15.4 
2018-09-24 
features added: ONLINE_SF6_MONITOR - dashboard, email updates and txt alerts changed to account for step changes in pressure due to top ups. Leakage rates and times to reach alarm and lockout states recalculated after a top up. 
 
5.14.4 
2018-09-14 
feature added: ONLINE_SF6_MONITOR - ignore zero data points in average calculations 
 
5.13.4 
2018-08-29 
features added: ONLINE_SF6_MONITOR - tweak the min and max limits of tick marks on charts to show data well below lockout limit or over nominal limit 
 
5.12.4 
2018-08-27 
features added: ADMIN and Managers Overview sections rolling emissions and topups chart
- add number of topups in popup chart
- add inclusion of 'refill existing CB' from next month if there was a degas in current month
- add 
 
5.11.4 
2018-08-23 
features added: ONLINE SF6 MONITOR - new settings page in ADMIN to set email addresses for weekly updates email and mobile numbers to receive txt alerts 14 days out from alarm state or lockout state. 
 
5.10.4 
2018-08-23 
features added: ONLINE_SF6_MONITOR - add weekly email alerts on status of monitored assets
- add TXT alerts script
- apply 1 day averages then 3 point average to calculate leakage rates and alert dates 
 
5.9.4 
2018-08-14 
features added: ONLINE_SF6_MONITOR - draft chart of two phases of pressure normalised on one chart
feature added: ADMIN section - rolling emissions and topups chart added
feature added: ADMIN section - total emissions data by month added
 
 
5.8.4 
2018-08-13 
feature added: ONLINE SF6 MONITOR - added ability to zoom up the chart data 
 
5.7.4 
2018-08-10 
features added: Traffic Light Dashboard added to Managers Overview and Administrators sections
features added: ONLINE_SF6_MONITOR - added 'Download PDF' button to save charts to pdf. 
 
5.6.4 
2018-08-09 
bug fix: ONLINE_SF6_MONITOR - adjust chart dates to NZ time 
 
5.6.3 
2018-08-08 
features added: 600P ONLINE SF6 MONITOR - add y axis limits to two parameters chart, add alert dates and pressure normalised chart to dashboard. 
 
5.5.3 
2018-08-08 
features added: ONLINE SF6 MONITOR - adjust default average value to 'none' if less than 2 days of data and add limits to Y axis on all charts page for pressure normalised chart
bug fix: ONLINE SF6 MONITOR - adjust dates to NZ time 
 
5.4.2 
2018-08-07 
features added: allow Admin to set users permissions to access 600P section. Minor field name changes. 
 
5.3.2 
2018-08-02 
features added: add script to read new fields from 600P monitor's data file 
 
5.2.2 
2018-07-30 
bug fix: minor tweak to contractors order gas page 
 
5.2.1 
2018-07-25 
features added: 600P ONLINE SF6 MONITOR - display charts set x axis to start at y=0, change pressures to millibar from bar, add 'nominal', 'alert' and'lockout' limits to pressure normalised chart 
 
5.1.1 
2018-07-24 
bug fix: change device_id to device_name, change table name prefix from'SF6_MONITOR_device_' to '600P_device_' 
 
5.1.0 
2018-07-19 
feature added: allow Admin to override purity for special issue for 'new install' for G cylinders 
 
5.0.0 
2018-05-24 
template change: Online DGA and LAB DGA moved to new OilWatch600 
 
4.4.6 
2018-05-23 
feature added: allow Admin to update gas_transacted by editing 'start_wt' and 'this_finish_wt' 
 
5.2.5 
2018-05-07 
bug fixes: changes to PBA Staff section for cylinder returns, and cylinder issues 
 
5.2.4 
2018-05-07 
bug fixes: various receive cylinders, cylinders currently held, and cylinder issues changes 
 
5.2.3 
2018-05-01 
bug fix: formatting tweaks to cope with weights in thousands of kgs. 
 
5.2.2 
2018-04-24 
feature added: legend added to Duval's triangle chart 
 
5.1.2 
2018-04-14 
bug fixes: Online SF6 Monitor section tweaked. 
 
5.0.0 
2018-04-17 
template change: new section ONLINE SF6 MONITOR added
names of sections changed to ONLINE DGA, ONLINE SF6 MONITOR, LABORATORY DGA. 
 
4.2.1 
2018-03-27 
features added: DGA Analysis Data renamed Oil Sample DGA. Testing lab, OLTC, analysis notes and tranformer notes added to Oil Sample DGA pages. IEC and IEEE tabulated data pages added. IEEE relative ratios anlysis added. 
 
4.1.1 
2018-03-19 
feature added: special characters in names for DGA Gas Analysis data allowed.
feature added: transformer fault analysis added to tabulated data page 
 
4.0.1 
2018-03-19 
bug fix: change units for TDG and TDCG for DGA Analysis Data pages 
 
4.0.0 
2018-03-16 
feature added: new section DGA Analysis Data added 
 
3.2.2 
2018-03-09 
bug fixes: changes to database table names, for DGA Analysis Data 
 
3.2.1 
2018-03-01 
bug fix: scrapped cylinders now show on gas inventory on certain data pages in Admin and Managers Overview sections. 
 
3.2.0 
2018-01-31 
features added: Admin and Managers Overview sections - changed last store stocktake page from ascending dates to descending and excluded ADD, BPE, OTA and Quarantine stores from the stocktake page [NOTE: this is SPECIFIC to Transpower site] 
 
3.1.0 
2018-01-25 
feature added: transaction detail data changed from ascending to descending on Transactions page. 
 
3.0.0 
2018-01-23 
template change: new section 'ONLINE DGA' added 
 
2.39.5 
2018-01-22 
bug fix: replace spaces in 'model' with underscores to avoid quotes around those models in the device data csv file that is generated 
 
2.39.4 
2018-01-22 
feature added: device data page changed to trim columns, add 'precharge' column, and change filter dropdown to show model 
 
2.38.4 
2018-01-22 
feature added: add emissions reporting for previous previous period (2 years prior) to Managers section 
 
2.37.4 
2018-01-22 
feature added: client name added to file name for device data to csv page. 
 
2.36.4 
2018-01-22 
feature added: new page added to provide report on emissions and breakdown of data, for previous previous period (i.e. 2 years prior) 
 
2.35.4 
2018-01-22 
feature added: 'precharge' field added to database and to device_data pages. 
 
2.34.4 
2018-01-22 
feature added: ADMIN ability to view device data and download as CSV file. 
 
2.33.4 
2018-01-11 
feature added: included ability for ADMIN to issue Gas Carts for new installs, top-ups and removal of gas. 
 
2.32.4 
2018-01-10 
features added: changed charts from scatter to linear, upgraded software versions driving charts, changed scales time display format, simplified/automated all charts page. 
 
2.31.4 
2018-11-10 
feature added: improve ability to add transaction details 
 
2.30.4 
2017-11-02 
bug fixes: sort last-stocktake dates descending instead of ascending, and escape contractors section sorting function so no error when no results 
 
2.30.3 
2018-10-09 
feature added: added 'latest_trans_id' to 'add new transaction record' button 
 
2.29.3 
2017-09-21 
bug fix: updated scripts for ADMIN to resort transaction details 
 
2.29.2 
2017-08-01 
bug fix: excluded scrapped cylinders from last store stocktake report.
files affected:
 
 
2.29.1 
2017-07-28 
features added: added last store stocktake reports for Admin and Managers sections with ability to email a pdf of the report to user.
files affected:
bugfix: removed 'Administrator' from page title of Gas Inventory page.
files affected:
 
 
2.28.1 
2017-07-28 
feature added: added new transaction description 'store stock take', and added the ability for ADMINISTRATOR to add a store stock take transaction record.
bugfix: fixed missing 's' on end of variables looking up cylinders data. 
 
2.27.1 
2017-07-25 
feature added: populate 'date_added' field automatically for new cylinders added to the system.
bug fix: replace 'TRANSPOWER' with client name in PDF title so more universal for other clients.
 
 
2.26.1 
2017-07-24 
bug fix: remove PBA Gas Carts from cylinders held data and chart 
 
2.26.0 
2017-07-13 
feature added: added Gas Inventory on Certain Date to reports menu. 
 
2.25.0 
2017-06-21 
feature added: added pages to show last stocktake dates and ability to generate a PDF which is emailed to user 
 
2.24.1 
2017-06-20 
bug fix: change delta calculations and signs 
 
2.24.0 
2017-06-08 
feature added: generation of 'last stocktake date' report and abilty to email PDF report to user, added to Admin reports.
feature added: add ability for Admin to change last_finish_wt, start_wt, delta, device_position AND remove ability for Admin to change 'device_model' and 'device_nameplate'.
 
 
2.23.0 
2017-05-24 
feature added: add 'contractor', 'entered by', 'asset id' to export maximo data. 
 
2.22.0 
2017-05-23 
feature added: add script to force delta or delta_oc to zero if cust_cyl_num or cust_cyl_num_oc is a PBA Gas Cart 
 
2.21.0 
2017-05-19 
features added: show significant deltas in cylinder transactions and include ability to generate a pdf and email to user. 
 
2.21.0 
2017-05-18 
feature added: added correction to A2 of emissions calculation if maintenance degas of CB is more than refill CB 
 
2.20.0 
2017-04-06 
feature added: added totals of cylinders held to chart legend 
 
2.19.0 
2017-03-31 
feature added: added total emissions calcs for july to june with ability to create PDF of the emissions report which is emailed to the user 
 
2.18.0 
2017-03-13 
feature added: added sorting variable to filter string for Admin section -> all cylinder transactions 
 
2.17.1 
2017-03-22 
feature added: chart of refillable and non-refillable cylinders held (including differentiating between G and D size cylinders)
bug fix: added cust_cyl_num to view screen on device transactions pages
bug fix: removed requirement for device model number to be a 'number' when adding a transaction record 
 
2.16.1 
2017-03-07 
bugfix: removed limitation of 'required date prior to tomorrow' for ordered gas.
bugfix: changed devpos3 from exploded third element (which truncated off anything after a third hyphen in the position name),
to the remainder of the device position after the second hyphen - therefore allowing hyphens in devpos3 e.g. HAY-CB-SA.WA-Z1.Q1
bugfix: added lookup of wt, dew pt and purity for 'from' cylinder (and 'to' for cyl2cyl transactions) to top of page and both 'from' and 'to' cylinder data is looked up using the same logic, and before the page loads.
bugfix: tweaked the logic to get the cylinder data from the last transaction for the cylinder, if the transaction date is equal to or greater than the date the contractor received the cylinder into depot. 
 
2.16.0 
2017-01-31 
features added: contractors section - cylinders held page
start page with cylinders sorted in decreasing order, and allow sorting of columns, and column sorting maintained when depot filter applied. 
 
2.15.3 
2017-01-30 
bugfix: if no transaction details yet for a cylinder add code to 'ADD a new Transaction' button to allow new transactions to be added. 
 
2.15.2 
2017-01-30 
bugfix: tweak to cylinder transaction pages, to view the 'To' cylinder in cyl2cyl transactions.
bugfix: add trans_id_oc to 'ADD a new Transaction' link in Contractor section 
 
2.15.1 
2017-01-25 
bugfix: remove blank line in cust_cyl_num in filter drop down on transactions pages. 
 
2.15.0 
2016-12-21 
features added:
1. end date added into calculation of emissions for the reporting period
2. change 'good' (green) and 'bad' (red) gas qualities to 'new' (green), 'reusable' (orange), 'unusable' (red) for the gas held table and stacked bar chart, on Admin dashboard, and SF6 Inventory Overview dashboard.
3. link SF6 Inventory Overview dashboard to same total_emissions_data script as Managers Overview and Admin dashboards.
4. Add 'to date' for emissions calculation headings, if the current date is within the current reporting period.
5. Add in new 'Reports' menu item for new 'emissions-previous-period.php' page for Admin and Managers Overview sections - which will display emissions summary and data breakdown, for the previous emissions reporting period. 
 
2.14.0 
2016-12-21 
feature added: rename 'transaction ID' or 'trans ID' to 'movement ID' or 'movemt ID'. 
 
2.13.0 
2016-12-14 
feature added: remove 'details' from the headings to pages for adding cylinder transactions, and change 'trans_id' to 'movemt_id'. 
 
2.12.0 
2016-12-13 
feature added: allow third component of new device position added to be alpha numeric. 
 
2.11.1 
2016-12-12 
features added:
1. nameplate data for 'B' and 'C1' emissions calculation totals, to only one occurrence of nameplate data for multiple transactions.
2. cylinders_currently_help page - shade alternate rows. bugfix: emissions calculation sort order corrected for 'A4' to group common device position and device models together (as per other fields).
bugfix: changed sort order of emissions calculation total 'C4' to same as other totals. 
 
2.10.0 
2016-12-12 
feature added: numbers required for number fields on all the forms used to add a cylinder transaction 
 
2.9.0 
2016-12-06 
features added:
1. removed exclusion of NOP transactions from emissions calculation
2. added correction rows for (device_position, device_model) pairs that exceed nameplate values for decommission degas transactions. 
 
2.8.0 
2016-11-23 
features added - changes to content of emails sent out to new users:
1. 'Store Access' changed to 'SF6 Inventory Overview'
2. 'Online DGA Overview' access added to transpower.ecogas600.com. 
 
2.7.1 
2016-11-22 
features added:
1. alternative rows of data shaded for better clarity
2. link to Online DGA added to selected sites (TRANSPOWER, DEVELOPMENT, DEMO)
3. selected sites (PBA, DEVELOPMENT1) can manually add location code of a new device.
bugfix: issue with view of last cylinder transaction detail record not showing 
 
2.6.1 
2016-11-09 
bugfix: cyl2cyl transactions - remove twin record for 'TO' cylinder, and fix issue with last_finish_wt not showing if no trans details yet for the 'TO' cylinder. 
 
2.6.0 
2016-11-08 
feature added: ability to record 'stock take record' feature added: renamed 'Store Access' section to 'SF6 Inventory Overview'. feature added: new 'Online DGA Overview' section. 
 
2.5.2 
2016-10-18 
bug fix: fixed 'go back and edit' bug on bulk email form in admin section 
 
2.5.1 
2016-10-17 
feature added: script added to clean up the user-submitted text for the third field when adding a new device position via the transaction details section
bug fix: contractors section - fixed transaction listing not showing after just being saved to the database (when not a cyl2cyl transaction).
bug fix: fixed issue with logout script 
 
2.4.0 
2016-10-15 
features added:
1. superusers can edit depot and contractor details
2. admin can change relative sort-order of transaction details for charting of individual device transactions
3. admin can broadcast email notices to all active users
4. added SF6 gas in kgs to Managers and Admin dashboards
5. added ability for PBA staff to add cylinder-to-cylinder transaction detail records
6. added ability for admin to edit trans_desc, device model and nameplate data for existing cylinder transaction detail records.
7. reordered latest 5 top-ups to chronological order on admin and managers dashboards rather than trans_detail_id
8. added extra filter for 'TO' cylinder in Managers and Stores section
9. admin section, device data - model number added to filter drop down
10. home page - sort cylinder filter lists by cust_cyl_num 
 
2.3.0 
2016-08-11 
SSL SMTP email connection for sending emails generated by the website. Added email to contractor confirming cylinders issued in response to gas request. 
 
2.2.2 
2016-07-21 
feature added: ability to block low-level users from being able to add transaction details for cylinders bugfix: logo missing from some address label pdfs 
 
2.1.1 
2016-07-06 
template change: improved functionality to add a transaction detail record in six steps, with 'back' and 'next' buttons.
features added: 'select_contractor' feature for PBA staff to transact cylinders for contractors other than PBA; Gas Carts added (Gas Cart 1, Gas Cart 2, Gas Cart 3, Gas Cart 4) as 'refillable cylinders' for maintenance degassing of cylinders; added 'workshop' devices (PBA-CHCH-WS, PBA-AUCK-WS, PBA-WLGN-WS).
bugfixes: emissions calculation corrected, issue-address-label-pdf-creation script fixed. 
 
1.1.0 
2016-06-01 
feature added: ability for certain users to bypass compulsory fields when adding new cylinder transaction records 
 
1.0.3 
2016-05-25 
bugfix: admin section - fixed whereabouts error on adding a new cylinder 
 
1.0.2 
2016-05-05 
feature added: ability for administrator to 'special issue' cylinders for 'New Install' gas requests 
 
1.0.1 
2016-04-26 
feature added: version number added to footer
bugfix: contractor header logo 
 
1.0.0 
2016-04-23 
Initial Release: for Transpower South Island trials 
 

EcoGas 600A - Data Interface App

version
release date
release notes
 
5.1.1 
2021-08-17 
Feature added: 'Reason for Top Up' added to cylinder transactions 
 
5.0.1 
2021-07-20 
bugfix: add script to allow selection of person who performed a transaction, where the system has been simplified for one 'contractor'. 
 
5.0.0 
2021-05-12 
MAJOR change to MYSQL table structures to work with MYSQLI v5.7: generally change 'date' to VARCHAR(250) NOT NULL DEFAULT '0000-00-00' and assign defaults for other fields incl integers, also rename 'timestamp' to 'data_timestamp', and change scripts throughout the sites to rename variables. 
 
4.0.0 
2021-04-29 
MAJOR SOFTWARE UPGRADES, SERVER OS UPGRADE upgrade to PHP v7 and MySQL v5.7+, upgrade to mPDF v8, PHPMailer v6+, MessageMedia PHP-to-SMS API v2.2.1. Upgrade Server OS to CentOS 7 and subsequent upgrade to CPanel & WHM. 
 
3.5.1 
2021-02-26 
feature tweak: Contractors section - increase transaction notes limit from 350 chars to 1000 charts 
 
3.4.1 
2021-02-17 
feature tweaks: Contractors section - further tweaks to show utility field on cyl trans details pages 
 
3.3.1 
2021-02-16 
feature tweaks: simplify the device diposal request form - remove ajax lookup scripts for pickup site addresses, asset num, manu, model etc. Manual fill in fields instead, except asset type (eg CB, RMU etc). 
 
3.2.1 
2021-02-09 
Alert message addded to login screen if user is locked out due to software upgrade in progress. 
 
3.1.1 
2021-01-15 
feature tweak:
- hide'inactive' cylinders from drop downs - allows PBA cylinders to be inactivated so PBA staff can't put gas into cylinders that are allocated to a device disposal customer.
- update ecogas600 header logo with 'D' and byline removed
 
 
3.0.1 
2021-01-14 
Update header logos for Device Disposal to 600E, and Online SF6 Monitoring to 600P, and get logo from d/images for both 600D and 600A 
 
3.0.0 
2021-01-05 
template change: 600E DEVICE DISPOSAL features amalgamated with 600A so that all EcoGas releases are aligned. Access to the different sections and the showing of different menu buttons are dependent on permissions set for the user in Admin section (e.g. 600D_access (therefore 600A), 600E_access, Add transactions etc). 
 
2.18.3 
2020-12-11 
bugfix: contractors section - added missing script that was meaning operator name was not carried through to db for transactions other than degas trans. 
 
2.18.2 
2020-09-07 
feature tweak: remove limits on 'equip_press_prior': set min = 0 for all users and set message same for all users 
 
2.17.2 
2020-06-23 
feature tweak: contractors section - add ability for contractor to add cylinder transaction even if no contractors assigned to the user 
 
2.16.2 
2020-01-21 
feature tweak: CONTRACTORS section - cylinder transactions; equip press prior - allow down to zero if PBA staff equip press after - allow down to zero if degas 
 
2.15.2 
2020-01-16 
feature tweak: contractors section adding transactions - reduce min equip pressure to 0 mbar (from 50) 
 
2.14.2 
2020-01-09 
bugfix: contractors section correct code to allow ability for users to input transactions up until 1 March for previous period ending Dec 
 
2.14.1 
2019-11-19 
feature added: Contractors section - change db connection script on ajax files to consolidate connection and script 
 
2.13.1 
2019-10-24 
feature added: Contactors section - extend limit for transaction notes to 350 chars, when adding a cyl transaction record. 
 
2.12.1 
2019-07-15 
features added: Contractors section - hide decommissioned devices from drop downs on 'add transaction details' page 2. 
 
2.11.1 
2019-03-28 
feature added: Contractors section - added cutoff date of 1 March to limit transactions being entered for previous emissions period (ending 31 Dec) however Admin can continue to enter transactions 
 
2.10.1 
2019-03-27 
feature added: Contractors section - make maximo field compulsory 
 
2.9.1 
2018-10-19 
features added: Contractors section - add if 'top up existing CB', dropdown for leak? yes/no
if yes, where leak? R phase/Y/B/etc.
if 'refill existing CB', refill reason? pole swap/repair. add new fields to transaction recording pages and show on transaction reporting pages.
 
 
2.8.1 
2017-07-28 
bugfix: fixed missing 's' on end of variables looking up cylinders data.
 
 
2.8.0 
2017-05-23 
feature added: add script to force delta or delta_oc to zero if cust_cyl_num or cust_cyl_num_oc is PBA Gas Cart 
 
2.7.4 
2017-03-13 
bugfix: about line 224 - tweaked script if $cyl_eyedee = $cyl_id_oc then show $last_finish_wt_oc 
 
2.7.3 
2017-03-22 
bug fix: removed requirement for device model number to be a 'number' when adding a new cylinder transaction. 
 
2.7.2 
2017-03-07 
bugfix: changed devpos3 from exploded third element (which truncated off anything after a third hyphen in the position name),
to the remainder of the device position after the second hyphen - therefore allowing hyphens in devpos3 e.g. HAY-CB-SA.WA-Z1.Q1
bugfix: added lookup of wt, dew pt and purity for 'from' cylinder (and 'to' for cyl2cyl transactions) to top of page and both 'from' and 'to' cylinder data is looked up using the same logic, and before the page loads.
bugfix: tweaked the logic to get the cylinder data from the last transaction for the cylinder, if the transaction date is equal to or greater than the date the contractor received the cylinder into depot. 
 
2.7.1 
2017-01-31 
bugfix: tweaked code on transaction details page to lookup correct transaction when 'view' button clicked. 
 
2.7.0 
2016-12-14 
feature added: remove 'details' from the headings to pages for adding cylinder transactions, and change 'trans_id' to 'movemt_id'. 
 
2.6.0 
2016-12-13 
features added:
1. Add new device position: remove requirement for third component of a new device position to be a number
2. Add checking script for third component to change hyphen to tilda, and blank space to an underscore
3. For development.ecogas600.com or pba.ecogas600.com allow the first component of a new device position added to be added via a text field (rather than drop down list as for other sites).
 
 
2.5.0 
2016-12-12 
Features added: numbers required for number fields on all the forms used to add a cylinder transaction 
 
2.4.1 
2016-11-09 
bugfix: cyl2cyl transactions - fix issue with last_finish_wt not showing if no trans details yet for the 'TO' cylinder. 
 
2.4.0 
2016-11-08 
feature added: ability to record 'stock take record' 
 
2.3.1 
2016-10-17 
bugfix: fixed issue with logout button 
 
2.3.0 
2016-10-15 
features added:
1. added ability for PBA staff to add cylinder-to-cylinder transaction detail records
2. home page - sort cylinder filter lists by cust_cyl_num 
 
2.2.0 
2016-07-21 
feature added: ability to block low-level users from being able to add transaction details for cylinders 
 
2.1.0 
2016-07-06 
template change: improved functionality to add a transaction detail record in six steps, with 'back' and 'next' buttons. features added: 'select_contractor' feature for PBA staff to transact cylinders for contractors other than PBA; Gas Carts added (Gas Cart 1, Gas Cart 2, Gas Cart 3, Gas Cart 4) as 'refillable cylinders' for maintenance degassing of cylinders; added 'workshop' devices (PBA-CHCH-WS, PBA-AUCK-WS, PBA-WLGN-WS). 
 
1.0.0 
2016-04-23 
Initial Release: for Transpower South Island trials