EcoGas 600 Series - Software Release Notes
EcoGas 600D - Database
version
release date
release notes
11.8.0
2025-05-02
Feature added: direct import of device data and hard-coded decommissioning of devices for TP device data update.
11.7.0
2025-05-01
Feature added: Add lookup device position based on serial num, to p2 of add cyl trans page.
11.6.0
2025-04-09
Feature added: check if only 1 or 2 phases decommissioned and if so adjust decomm nameplate as a result in emissions calculation.
11.5.0
2025-03-25
Features added: 'date_added_to_db' and 'date_decommmissioned' fields added to device_position table
11.4.0
2025-03-18
Features added: Exclude all gas carts and storage devices from gas_inventory_on_certain_date.php pages.
11.3.0
2025-02-26
Features added: add ability to edit change request users in Admin section. Hide change requests section from non-authorised users.
11.2.0
2025-01-30
Features added: Add CHANGE REQUEST FORM and associated pages.
11.1.0
2024-10-09
Features added: Allow 'Depot Store' devices to be transacted with even if they are 'out of service' (decommissioned = 1) for Northpower and Test1 ecogas sites.
11.0.0
2024-10-29
Major Change: ADD new MASS FLOW METERS. Add new db table. Add new fields to 'transaction_details' logging and reporting pages, and new fields to db table - trans_thru_massflowmeter, mass_flow_meter, mass_flow, mass_flow_delta.
10.19.2
2024-10-22
Feature added: add button to email PDF to self for gas inventory on certain date.
10.18.2
2024-09-04
Bugfix: fix emails with apostrophes
10.18.1
2024-08-13
Feature added: add Gas Sold trans_desc for PBA site only.
10.17.1
2024-08-02
Feature added: gas_inventory_on_certain_date
10.16.1
2024-07-31
Features added: d/ADMIN & MO/cylinder_trans_details_to_excel.php and device_trans_details_to_excel.php - calculate gas_transacted at time of creating excel file
10.15.1
2024-07-29
Feature added: hide cylinders that have been scrapped from cylinders currently held page.
10.14.1
2024-05-07
Features added: Hide repaired devices from service area reports. Add check for decommission degas.
10.13.1
2024-04-12
Feature added: tweak code to hide inactive cyls from disposal cyls view on index page
10.12.1
2024-04-10
Features added: d/CONTRACTORS/menu.php - change link to Taj's support request form.
d/ADMIN & MO/all_devices_trans_details.php - add device_model and device_serial beside cylinder/device.
d/ADMIN & MO/device_data.php - add device_serial column.
tweak word_split function.
d/ADMIN & MO/ all_cylinder_trans_details.php - add device_model, device_serial, and truncate notes.
service_area_reports - remove repaired (green) devices, show worst 10 topups for each service area.
10.11.1
2024-02-22
Feature added - develop test devices model differences page
10.10.1
2024-02-20
Features added: Implement period_start instead of last_year etc for service area reports.
10.9.1
2024-02-19
Features added: service_area_reports cron jobs - change from 12 months to 36 months througout and at about line 495 add script if repari_date and no last topup date, then last_topup_date = repair_date.
10.8.1
2024-02-07
Bugfix: round up delta totals
10.8.0
2024-01-23
Feature added: Override or add new photos for disposal DDR photos.
10.7.0
2023-12-11
Features added: Add HVDC detection script to devices leaking reports etc
10.6.0
2023-12-08
Features added: Detect HVDC assets and assign to HVDCNI and HVDCSI service areas.
10.5.0
2023-12-05
Feature: change HVDC assets in device_position, sites_new and transaction_details db tables.
10.4.0
2023-11-22
10.3.0
2023-11-01
Features added: Add column for mobile number to users.php page. Show phone as 'required' on new-users.php page.
10.2.0
2023-10-31
Features added: Hide cyl cols and allow manager to see all device disposal trans.
10.1.0
2023-10-02
Features added: If no d_access then hide 600D menu stuff. Fix formatting for managers overview buttons.
10.0.0
2023-09-20
MAJOR UPGRADE: 2FA added to login process.
9.23.1
2023-09-08
Features added: Add script to filter out routine maintenance topups to device_top_ups_by_region_for_last_year2 pages and in cronjob.
9.22.1
2023-08-28
Features added: Add new trans_desc values 'Store degas' and 'Store fill' to cyl trans forms.
9.21.1
2023-08-23
Feature added: add pseudo stocktakes from store
9.20.1
2023-07-10
Bugfix: Fix incorrect formatting of date() function ~ line 22 in add_trans_detail_p1.php pages.
9.20.0
2023-06-14
Feature added: Include device_serial in cylinder transaction recording pages and reporting pages.
9.19.0
2023-06-06
Feature added: Add 'which phase worked on?' question to cyl transactions pages and reporting page, and add 'entered_date'.
9.18.0
2023-05-22
Feature added: Change device_disposal_requests popup windows to show serial no. not asset no.
9.17.0
2023-05-19
Feature added: change script for showing 600E cylinders for disposal transactions to show only if active cylinder.
9.16.0
2023-05-09
Feature: Check device_position table and change any position with commas to forward slashes. Add new 'site' field to editing form for device_data.php. Remofe spaces, hyphens commas for device position.
9.15.0
2023-04-18
Feature added: add new pages in ADMIN - users_details_to_excel.php and users_details_data_download.php
9.14.0
2023-03-21
Feature added: Correct lookup of site_abbr for device_position for HAY-CB-122 etc HVDC
9.13.0
2023-03-07
Feature added: remove top-ups doe to routine maintenance, remove device_repaired2_chart.php
9.12.0
2023-02-23
CHANGE GWP from 22,800 to 23,500 throughout the site for all emissions calc scripts, and cronjob script for monthly emissions report.
9.11.0
2023-02-20
Feature added: Allow cylinders to be marked as allocated to 600E so not just 'inactive' but clearly not available for 600D work, while allocated to 600E.
9.10.0
2023-02-15
Feature added: ADMIN section - cylinder_data_ALL_cylinders.php - show all cylinders on one page including: sold, scrapped, inactive
9.09.0
2023-02-08
Feature added: d/index.php Change dropdowns to hide inactive cylinders
9.08.0
2023-02-08
Features added: Development work on new pages in ADMIN and MO sections: devices_repaired2_chart.php and devices_leaking2_chart.php
9.07.0
2023-02-01
Feature added: Hide cyls sold or scrapped from d/CONTRACTORS/cylinders_held.php page.
9.06.0
2023-01-09
Feature added: add ability to mark cylinders as 'sold'. Add new fields to db table 'cylinders': 'sold', 'sold_date', 'sold_notes'. Alter pages in SF6 Inventory Overview, MO and ADMIN sections.
9.05.0
2022-09-08
Developmental work: Add ability to edit data and put 'out of service'. Add select serial no. with ajax script or add new 'other'.
9.04.0
2022-09-07
Development work on emissions reporting using [device_position, device_serial] as unique pairs instead of [device_position, device_model]
9.03.0
2022-08-23
field app 600AF development - add serial_num and setup cronjobs to generate lists for assets, etc.
9.02.0
2022-08-19
Feature added: Allow user last names and emails with apostrophes
9.01.0
2022-08-09
Feature added: update ADMIN & MO/device_transaction_alerts_by_region2.php and device_transactions_review2.php to lookup new service areas.
9.0.0
2022-08-08
Major change to Transpower service areas. generate new db table called 'sites_new'. Use this to look up 'site' for new service area for a device. Change devices leaking reports and losses by region etc to lookup new service areas in both ADMIN and MO sections.
8.33.20
2022-07-25
Feature added: Add email pdf of gas inventory on certain date to MANAGERS OVERVIEW section
8.32.20
2022-07-20
Feature added: Add email pdf of gas inventory on certain date to Admin section
8.31.20
2022-07-05
Feature added: Add extra column to device_top_ups_by_region_for_last_year.php to repeat the status for colour blind users
Bugfix: tweak headings on device_transactions_review.php and device_transaction_alerts_by_region.php pages
8.30.19
2022-07-03
Features added: Add new page ADMIN & MO/device_transaction_alerts_by_region.php to summarise alerts by region, add to menu, update alerts on device transactions review page (ADMIN & MO/device_transactions_review.php).
8.29.19
2022-06-13
Feature added: fix the top row of the tables for ADMIN and MO pages... devices_leaking.php, devices_leaking_and_repaired.php and devices_repaired.php
8.28.19
2022-06-07
Features added: ADMIN and MANAGERS OVERVIEW 'device_transaction_operator_checks.php' pages. Alter device_position db table to show operating pressure.
8.27.19
2022-05-30
Bugfix: add script to ignore nameplate values if blank or zero to avoid alert in PHP
8.27.18
2022-05-30
Bugfix: add reset values to variables
8.27.17
2022-05-05
Bugfix: remove mass_flow field from insert sql
8.27.16
2022-05-04
Feature added: Add popups to view scrap receipts for 600E device disposals
ADMIN and Managers Overview sections.
ADMIN and Managers Overview sections.
8.26.16
2022-04-29
Features added: CONTRACTORS section - cylinders held page: add 'last cert' column.
Bugfix: fix error where the 'type' of NON-refillable cylinders was shown as 'refillable' in the 'cylinders data' pages in Admin, MO, and SF6 inventory sections.
Bugfix: fix error where the 'type' of NON-refillable cylinders was shown as 'refillable' in the 'cylinders data' pages in Admin, MO, and SF6 inventory sections.
8.25.15
2022-04-27
Feature added: change field in device_position table for analysis of operator's transaction recording: change 'year_of_manufacture' to 'YOM' and add:
'verified_nameplate_wt', and 'operating_pressure'
8.24.15
2022-04-27
bugfix: remove 'mass_flow' field from SQL insert clauses.
8.24.14
2022-04-26
Features added:
Change 'topup_reason' options displayed, to be consistent across 600A and 600D. Change topup reasons recorded in db table to be consistent across 600A and 600D.
Change one of the refill reasons from 'repair' to 'leak repair'.
Change retrospective entries in cylinder_transactions table to these new conventions.
ADD new fields in 'transaction_details' table in readiness for 600AF Field App.
Change 'topup_reason' options displayed, to be consistent across 600A and 600D. Change topup reasons recorded in db table to be consistent across 600A and 600D.
Change one of the refill reasons from 'repair' to 'leak repair'.
Change retrospective entries in cylinder_transactions table to these new conventions.
ADD new fields in 'transaction_details' table in readiness for 600AF Field App.
8.23.14
2022-04-12
bugfix: remove display of date range for device disposals
8.23.13
2022-03-31
new function: create separate function page to calculate last_finish_wt of cylinders
8.22.13
2022-03-24
New Feature: add new page to show anaysis of cylinder transactions:
d/ADMINISTRATOR/device_transaction_operator_check.php
d/ADMINISTRATOR/device_transaction_operator_check.php
8.21.13
2022-04-07
bugfix: traffic light dashboard - correct missing quote marks in queries for gas qualities and quantities
8.21.12
2022-03-15
Feature added: consider 'leaking devices' repaired if all top-ups older than 4 years.
8.20.12
2022-03-14
Feature added: Add alert if cyl to cyl transaction and not an approved filler chosen as operator
8.19.12
2022-03-01
Feature added: Allow all contractors for Transpower EcoGas site, to log cylinder to cylinder transactions.
8.18.13
2022-03-01
Bugfix: remove bug occuring during reactivation of an existing user
8.18.12
2022-02-03
features added: leaking devices pages in MANAGERS_OVERVIEW and ADMINISTRATOR sections:
1. show last repair date for orange results
2. show num of top ups and total gas lost for red results
3. show num of top ups and gas lost since last repair for orange results
1. show last repair date for orange results
2. show num of top ups and total gas lost for red results
3. show num of top ups and gas lost since last repair for orange results
8.17.12
2022-01-12
Bugfix: amend cylinder data pages and export to excel scripts in SF6_INVENTORY_OVERVIEW, MANAGERS_OVERVIEW, and ADMINISTRATOR sections to show 'certified date' and 'due date' for non-refillable cylinders
8.17.11
2021-12-22
Feature added: update bulk email form in ADMINISTRATOR to use the latest PHPMailer scripts
8.16.11
2021-12-22
Feature added: add device disposal info to SF6 Inventory Overview section.
Feature added: add script to stop duplicate submissions, blank submissions and show image on p1 on order device disposal form pages.
Bugfix: fix ADMINISTRATOR/scrap_receipts.php
Bugfix: add asset type drop down: ADMINISTRATOR/change_device_disposal_requests.php
Bugfix: tweak SQL scripts on ADMINISTRATOR and SF6 Inventory Overview cylinder_issue_step1:php
Feature added: add script to stop duplicate submissions, blank submissions and show image on p1 on order device disposal form pages.
Bugfix: fix ADMINISTRATOR/scrap_receipts.php
Bugfix: add asset type drop down: ADMINISTRATOR/change_device_disposal_requests.php
Bugfix: tweak SQL scripts on ADMINISTRATOR and SF6 Inventory Overview cylinder_issue_step1:php
8.15.10
2021-12-20
feature added: include all asset types to top ups by service area report pdf emailed to recipients
8.14.10
2021-12-08
bugfix: add 'DS' to devices reported on in leaking reports in Admin and Managers Overview sections.
8.14.9
2021-11-25
bugfix: fixed display filter bug on device data page in MANAGERS OVERVIEW
8.14.8
2021-11-23
bugfix: fix bug in Admin section for adding a new utility.
8.14.7
2021-11-16
features added: vessel volume calculation test pages added to Admin section.
8.13.6
2021-11-09
features added: update scripts for generating exports to excel including improving the presentation of the information on screen before export
8.12.6
2021-10-22
features added: new reports in Managers Overview and Admin sections for 'devices leaking and repaired', 'devices leaking' and 'devices repaired'. 'Devices leaking' (coded red or orange) and 'devices repaired' (coded green) can be filtered by device model and/or service area, along with sorting by columns
8.11.6
2021-10-19
bugfix: change connection for retrieving last insert_id to fix error when adding new user
8.11.5
2021-10-07
feature added: create emissions reports based on utility selected
8.10.5
2021-10-5
feature added: limit access to emissions report pdfs to those logged on as Manager or Admin
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'.
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.
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.
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
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.
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.
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
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
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
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).
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
- 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.
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
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'.
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'.
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
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
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
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
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
- 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
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
- 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
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
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.
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.
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.
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.
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
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.
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.
- 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).
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.
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.
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
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
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
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
- 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
- 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
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.
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
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.
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
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:
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:
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.
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.
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'.
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
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.
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.
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
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.
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.
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.
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.
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
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
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
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.
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
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.5.2
2022-04-27
bugfix: remove 'mass_flow' field from INSERT clauses
5.5.1
2022-04-26
Features added:
Change 'topup_reason' options displayed, to be consistent across 600A and 600D. Change topup reasons recorded in db table to be consistent across 600A and 600D.
Change one of the refill reasons from 'repair' to 'leak repair'.
Change retrospective entries in cylinder_transactions table to these new conventions.
ADD new fields in 'transaction_details' table in readiness for 600AF Field App.
Change 'topup_reason' options displayed, to be consistent across 600A and 600D. Change topup reasons recorded in db table to be consistent across 600A and 600D.
Change one of the refill reasons from 'repair' to 'leak repair'.
Change retrospective entries in cylinder_transactions table to these new conventions.
ADD new fields in 'transaction_details' table in readiness for 600AF Field App.
5.4.1
2022-03-14
Feature added: Add alert if cyl to cyl transaction and operator chosen without Approved Filler cert
5.3.1
2022-03-01
Feature added: all ALL contractors for Transpower EcoGas site, to log cylinder to cylinder transactions (not just PBA).
5.2.1
2021-12-22
Features added to order_device_disposal form: add scripts to stop duplicate submissions, blank submissions, show image on p1, and remove rotate image errors.
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
- 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.
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.
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).
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
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
