VMMS Release History

VMMS is the central vending management platform for machine configuration, telemetry, cashless operations, reporting, inventory visibility, remote actions, and API-based integrations across the Mainbridge ecosystem.

Version 6.0.12

Release Date: 15 December 2025

API products: added inset update and delete operations.
ApiModel: added parameters userInfo and isVerified. If the API gateway has verified the API key, the verification result and user information will be passed in. ApiModel no longer needs to perform its own verification.
Added Clients menu under the Cashless menu.
Card list interface: added client column; Card Create now includes a new client option.
RequestRefundJob: added to send reminder emails to customers with all records of refund requests.
RequestRefundJob: automatically processes refund requests older than 3 days for all companies.

Version 6.0.11

Release Date: 30 September 2025

Fixed the weekly task function; implemented recreate for a single company and all companies. Set "recreate": "1" to trigger; recreate_state in t_statements must be set to 0 in advance.

JavaScript{
  "queryStringParameters": {
    "action": "task_weekly",
    "server_id": "test",
    "begin_time": "2025-08-25 00:00:00",
    "end_time": "2025-08-31 23:59:59",
    "recreate": "1",
    "company_id": "14530"
  }
}

Fixed the monthly task function; implemented recreate for a single company and all companies.

JavaScript{
  "queryStringParameters": {
    "action": "monthly_weekly",
    "server_id": "test",
    "begin_time": "2025-08-01 00:00:00",
    "end_time": "2025-08-31 23:59:59",
    "recreate": "1",
    "company_id": "10411"
  }
}

Changed XLS generation to XLSX format due to the XLS record limit of 65,535 rows.
Created new table t_agentcompany_cardvends to store agent company card vends. Added agent_company_id, start_time, and end_time fields to t_card_vends.
Modified several procedures for displaying and exporting XLSX in VMMS.

Version 6.0.10

Release Date: 27 August 2025

Updated AWS API key.
API dtus: before sending remote credit to DTU, the system now first requests the API to create a DTU job, then sends remote_credit after successful creation. Synchronous waiting for the result has been removed.
Various bug fixes.

Version 6.0.09

Release Date: 28 July 2025

API dtus: when sending remote credit to DTU, new parameter job_no added (format: imei-millisecond_timestamp-4digit_random); also included in the return result on success.
DailyTask.java: added RequestRefundJob() to process CircumPay APP refund applications (companyId=3) and send email notifications to other companies for their refund requests.

Version 6.0.08

Release Date: 28 May 2025

API dtus: action=remote_credit now waits synchronously for the MQTT API to return the result.
ACK sending interval for remote_credit and check_status modified to 2 seconds, maximum 3 retries.
Fixed error in ApiModel.java where the ++ symbol was converted into spaces when obtaining GET parameters.

Version 6.0.07

Release Date: 11 April 2025

Fixed issue where updateAndGetID called by createCollection may return 0; now returns the last Collection ID based on machineID as a fallback.

Version 6.0.06

Release Date: 25 March 2025

Show L/Restock column for service personnel.
Developer Center is now visible to Cashless Admin, Admin, and Owner roles (previously Owner only).
API cards: top-up now supports negative values. New parameter top_up_desc for custom transaction description. Card transaction ID is returned on successful recharge.
Transactions.creditTime data type changed from Date to Timestamp.
Vends.toRefundRecord(): vendCount is now set to -1 during a refund transaction.
The vend_type of refund and refund fee records now remains consistent with the original vend records.
Fixed error where generated refund record vendtime only showed the date with time as 00:00:00.
Fixed incompatibility with sql_mode=only_full_group_by after upgrading to MySQL 8.
Fixed bug where jdbc.properties configuration was not being read correctly.

Version 6.0.05

Release Date: 17 February 2025

restockManager now uses SQS instead of HTTP. Queue name is based on serverId: restock_manager_{serverId}.fifo.

Version 6.0.04

Release Date: 14 January 2025

Fixed format errors caused by API JSONObject — replaced with ObjectNode.
All devices with APN=BLE will no longer trigger offline alarms.

Version 6.0.03

Release Date: 05 December 2024

Added new libraries to resolve API inaccessibility: jersey-container-servlet-core:2.35 and jersey-hk2:2.35.

Version 6.0.02

Release Date: 13 November 2024

API cardvends: added new query parameters vend_id and txn_id.
API cardvends: action=refund now returns the vend_id of the refund record on success.
Added upload log and view params option in DTU MQTT menu.

Version 6.0.01

Release Date: 23 October 2024

Upgraded from Tomcat 7 to Tomcat 9.
Upgraded from Java 1.8 to Java 17.
Converted WEB-INF/web.xml to WebAppInitializer.java.
Converted applicationContext.xml to AppConfig.java.
Upgraded Spring library from 3.0.6 to 5.3.39.

Version 5.0.59

Release Date: 18 September 2024

Weekly task: added company_id to process only Weekly Task-3 (Card Vends Weekly Statement) for a single company; regenerated Weekly Task-4 (Card Vends Weekly Summary).
MachineType: deletion is now blocked if any machine is using the selected machine type.
Company Edit: when parameters change, company_params_update is sent to the data change queue.
Various bug fixes.

Version 5.0.58

Release Date: 11 September 2024

API cards: new parameter global_unique (default: 1). If global_unique=0, companyId- is prepended to the card number (format: companyId-cardNo).
Updated API documentation.
Request Refund page: when a refund fails due to insufficient balance, the card number, recharge amount, and current balance are now displayed.

Version 5.0.57

Release Date: 05 September 2024

API locations: new output fields — notes, home_phone, country, customer_id; new modifiable fields — image_url, customer_id, category.
API machine: single machine query now returns machine_params; machine_params can now also be modified.
Machine List: fixed JSON format error when sending HTTP POST with product names containing special characters.
New API: templates.
MQTTController: added ack=1 model_no version parameter when sending messages.
Added test API (no parameters required, supports GET/POST/DELETE).
Fixed null pointer error in ApiLambdaController when client uploads a null value.

Version 5.0.56

Release Date: 28 June 2024

Timezone: added timezone drop-down to machine_create; saved to both t_machines and t_machines_params. Initialisation reads from t_machines first, then t_machines_params, then company timezone.
Notification Type: added panel in machine_create to select notiType (No Notification, secondsPerDollar, or workTime). Options stored in t_machines_params.
Route: deletion is blocked if any machine is bound to the route. Updating a Route's timezone simultaneously updates all machines in that route.

Version 5.0.55

Release Date: 27 June 2024

API cardvends: new action — refund.
API cardvends: new output field — aid.
After a successful refund, datachange is called and DynamoDB is updated synchronously.
Updated API documentation.

Version 5.0.54

Release Date: 29 May 2024

Vend History: CircumPay transactions now show a mobile phone icon before the card number; a message can be sent to the user.
Added Cashless → Request Refund page.
Fixed product list not updating synchronously after updating a Virtual Machine.
Fixed Card list unable to search for secondary cards.
Added support to send credit to M5_LITE relay unit.

Version 5.0.53

Release Date: 14 May 2024

Removed Xero package. Xero operations now use exportToXero, importFromXero, and importFromXeroGetOnly in CompanyController.

Version 5.0.52

Release Date: 10 May 2024

Card list: added new message feature for CircumPay users.

Version 5.0.51

Release Date: 30 April 2024

For users that no longer exist, records in export_log are deleted before ExportToXeroTask runs.
Modified cash value expression in 7-day sales report: uses cash_value if > 0, otherwise uses cash_in.

Version 5.0.50

Release Date: 27 March 2024

API company GET: new query fields — is_disabled, agent_only.
API company POST: new field is_disable to disable or enable company status.
API dtus: new output field — company_id.
API machine_models: new parameter linked_only — returns only machine types bound to a machine.
New general GET parameter get_all: when get_all=1, all data is returned ignoring paging restrictions.
New API: params.

Version 5.0.49

Release Date: 13 March 2024

Fixed restock bug.
Fixed Pre-kitting page extra not calculate bug.

Version 5.0.48

Release Date: 26 February 2024

API machines: new fields — location, route.
API locations: new fields — category, image_url.
API card_accounts: new parameter cpay_user; when cpay_user=1, CircumPay users are returned (sysadmin only).
Cashless → Vend History: Worldpay refunds now request Lambda directly.
Cashless → Transaction History: added refund operation for Worldpay credit card transactions (via Lambda) and direct balance modification for standard cards.
Added new table t_location_category and new API location_category (GET only).

Version 5.0.47

Release Date: 11 December 2023

API cardvends: added new refund operation; refund record's country field is generated from the original vend.
API cardvends: new query parameters — location_id, department.
API cards: new query parameter — department_list (returns departments of all cards).

Version 5.0.46

Release Date: 25 August 2023

API machines: new output field — coin_mech.
Promo: added Buy X Get Y Free option; optimized Promo-related pages for consistency.
Updated AWS-related library versions in pom.xml to align with vmmscore.
Transaction list: added refund button for credit card transactions.

Version 5.0.45

Release Date: 30 March 2023

Fixed several APIs that did not verify record ownership on delete operations.
Added dataChanged() function sending SQS to vmms_data_change.fifo for: Location, Route, Machine, Card, Carduser, Company, User, Product, Brand, ProductType, Template, CoilType, Collection, MachineType, Promo, Coil, Plan Machine, Ticket, Job, Param.
VMMS API user login response now includes a new user_role field.
Machine API: new parameter machine_user_name to find associated machine by username.

Version 5.0.44

Release Date: 28 February 2023

The following operations now call updateToCircumPay() to send to AWS SQS: Coil add/delete/modify, Product modify/delete, Category modify/delete, Brand modify/delete.
When deleting a Category, Brand, or Product that has related coil products, user is prompted to confirm with associated machine IDs displayed.
API machine: new output fields — build_standard, firmware_ver.
API coils: new output field — product_img_url.
After deleting a user, records in t_export_log are also deleted.
Card List: fixed sorting error.

Version 5.0.43

Release Date: 20 December 2022

When creating a Company, CircumPay is enabled by default with Vending as the default value.
After adding, deleting, or modifying a Machine coil, update to CircumPay is executed (if cpay_buy_method ≠ 0).
API reports: start_date, end_date, and log_day now default to the current day.
Param create page: parameters in the drop-down are now sorted by display name.
API machines: new return fields — temperature, place, roi, purchase_price, dep_rate, current_value, weight.
API coils: new parameters — coil_alarm, location_id, route_id, show_empty_coils, show_low_coils; new return fields — location_name, machine_place, product_upc_no.
API reports: new parameter — machine_id.
API card_accounts: CircumPay user registration/activation now sets company_id=3.

Version 5.0.42

Release Date: 28 October 2022

Added API maps (returns homepage map data).
Updated Google Map API key for coordinate lookup after location updates.
Card List: secondary cards can no longer modify the department field directly; modifying the primary card's department syncs to all secondary cards.
Vend History: added card department drop-down filter.
API company: new output field user_list; new parameters user_list, parent_company_list; new fields — company_params, company_type, is_disabled, parent_company_id.
API user: new parameter user_role_list; new output fields — user_role, user_routes, user_locations.
API dtus: added MQTT command support — dex, restock_only, restock, remote_credit.

Version 5.0.41

Release Date: 30 September 2022

Added ApiLambdaController supporting deployment to AWS Lambda via API Gateway.
New APIs: Tickets, Alarms, Reports.
Improved APIs: Locations (new output fields), Users (password change), Card_accounts (new field: country). Supplementary documentation added.
Support interface: clicking a company ID in the DTU list now navigates directly to the company.

Version 5.0.40

Release Date: 18 August 2022

Coil update: PAR, Alarm, and Current Level can now be set to 0. Alarm must be ≤ PAR level.
Added card webhook, triggered when creating a card.

Version 5.0.39

Release Date: 28 July 2022

Fixed cashless vend history report unable to sort by machine.
Fixed paging display error in Cashless → Card List.
Fixed duplicate display of secondary cards in Cashless → Card List report.

Version 5.0.38

Release Date: 14 July 2022

Fixed bug where system charge was set to 0 when refunding a credit card vend in Cashless → Vend History.

Version 5.0.37

Release Date: 12 July 2022

Company Edit → Advanced: added default picture selection when choosing a company industry.
Cashless → Vend History: added summary info at the bottom of the page.
Fixed support page bug where updating a user showed no location.
Fixed cashless vend history report showing slightly incorrect totals.
Fixed cashless API system gateway charge not including agent fee and pre-auth fee.

Version 5.0.36

Release Date: 15 June 2022

My Profile: users can now upload a header image for the CircumPay shop page.
Products not belonging to a virtual product no longer allow CircumPay-related configuration.
Fixed Reports → By Product yearly reports not sorted by sales.
Cashless → Vend History: refund now checks for existing records first, preventing duplicates.

Version 5.0.35

Release Date: 01 April 2022

Card user name and password length limit increased to 100 characters.
VMMS API token validity extended to 10 years.
Vend History: removed download link for refund transaction receipt.
System → User page: now only displays locations belonging to the selected route.

Version 5.0.34

Release Date: 17 March 2022

Added image upload for CircumPay in My Profile.
Updating company address now adds latitude and longitude to t_company_params.
Added location condition filter in Vend History.
New API: dtus (GET query only).
Updated QR code URL format for better compatibility with older phones.
When sending MQTT commands, if PI version is newer than 1.1.21i, AWS IoT is forced.

Version 5.0.33

Release Date: 28 January 2022

Coil API: alarm, PAR, and current levels can now be set to 0.

Version 5.0.32

Release Date: 10 January 2022

Fixed issue where machine_monthly and product_monthly records were not being generated.

Version 5.0.31

Release Date: 04 January 2022

Added company_id and statement_type parameters to task configuration to support regeneration of CARD MONTHLY INDIVIDUAL and CREDIT CARD MONTHLY INDIVIDUAL for a specific company.

Version 5.0.30

Release Date: 21 December 2021

User/login API: new return fields — company_id, user_name, user_id, first_name, last_name, address, postcode, state, country, office_phone, home_phone, mobile, fax_no, email.
Fixed issue where parameters could not be saved when creating a Machine.
Updated API documentation; added products, brands, category, and transactions.
Coils API: alarm level 0 is now allowed.
Fixed Machine → Detail → Sales view empty export bug.

Version 5.0.26

Release Date: 08 December 2021

Fixed error when opening alarm details window on the home page.
Fixed export machine sales view IMEI two digits missing bug.
System → Machine: send credit now supports $25 and $50 amounts.

Version 5.0.25

Release Date: 02 December 2021

Fixed create new company default route missing bug.
Added IMEI to exported machine sales view report.

Version 5.0.24

Release Date: 25 November 2021

Machine List: added "Update to CircumPay" option in the IMEI drop-down (CircumPay companies only).
Route Edit/Create: added Timezone; updating a Route now updates timezone on all its machines.
Company Update: only updates machines whose timezone matched the previous company timezone.

Version 5.0.23

Release Date: 12 November 2021

Allow selecting a parent category in product category insert/update window.
Added value type configuration for options: 0 = Add-on (adds to retail price), 1 = Price (replaces retail price).

Version 5.0.21

Release Date: 01 November 2021

Added Inventory → Option Group menu to define option groups.
Products now support adding options.
Fixed inconsistencies in monthly agent charge calculations; unified credit card identification to is_credit=1.
Resolved data discrepancies across companies due to DTU-machine mismatches; weekly task now writes machine_id for these transactions.
Company is now exported to Xero asynchronously on save.

Version 5.0.20

Release Date: 06 October 2021

Inventory → Products page: added Advanced tab; existing tab renamed to Basic.
Cashless → Vend History: updated receipt download URL.
Task intervals now use configurable parameters: TASK_INTERVAL (default 2000ms) and TASK_INTERVAL_BIG (default 10000ms).
Lambda Controller: added forwarding for report, RESTOCK, RESTOCK_ONLY, MANUAL_RESTOCK actions to DTUServlet.
Most logs now output to CloudWatch under /ec2/vmms/ and /ec2/vmms/activity/.

Version 5.0.19

Release Date: 06 September 2021

Product edit page now supports a Description field.

Version 5.0.18

Release Date: 03 September 2021

Added task_weekly_unlinked_sales parameter to weeklyTask. EasyvendDailyJob now only runs when server_id=vmms.
Product Edit page: added Description text box.
LambdaController: begin_time and end_time default to null if absent.

Version 5.0.17

Release Date: 14 August 2021

Set default data for ApiModel to avoid null pointer errors.
Machine create: added button to create a virtual DTU (administrators only).
MQTT now directly calls the MQTT API endpoint, supporting AWS IoT.

Version 5.0.16

Release Date: 12 July 2021

Added sleep intervals to all weekly and monthly task batch loops: sleep_ms(1000) per item, sleep_ms(2000) between batches.
createAllStatements now uses credit or ordinary card when fetching the largest processed company ID.
Fixed recovered vends time starting from Sunday 14:00 instead of Monday 00:00.

Version 5.0.15

Release Date: 28 June 2021

Fixed product image upload to S3 failure; updated to vmmscore 0.0.6.
Added summary for last 7 days sales on the home page.
Machine param vend_type=6 allows modifying the number of pulses per coil.
Save/Load coil template now includes pulse information.

Version 5.0.13

Release Date: 03 June 2021

Task execution tracking via t_system_params for daily, weekly, and monthly jobs to prevent duplicate runs.
Same IMEI can now print multiple QR codes with distinct table numbers (controlled by multi_qr and total_qr parameters).
Cashless → Card List: added "Download Template" CSV option.

Version 5.0.12

Release Date: 02 June 2021

Modified Monthly Task to call MachineMonthlyJob, ProductMonthlyJob, and DBMonthlyJob with skip logic when counts match.

Version 5.0.11

Release Date: 10 May 2021

Moved t_product_params to t_params.
Fixed Credit Card Summary incorrectly using card_type='Credit card'; changed to is_credit=1 to include CircumPay transactions.
Fixed incorrect decimal places in CREDIT CARD SUMMARY report.

Version 5.0.10

Release Date: 04 May 2021

Moved weekly task processing to AWS Lambda.

Version 5.0.9

Release Date: 21 April 2021

Moved monthly task processing to AWS Lambda. Task completes in 7 steps with configurable interval (monthlyTaskPeriodMins=10). Steps: agent company monthly fees, agent monthly summary, card auto-refunds, machine sale monthly, vend monthly, monthly fee, monthly fee summary.

Version 5.0.8

Release Date: 16 April 2021

Company create/edit in support tab now updates t_export_log: item_type='COMPANY_MONGODB', export_status=0 (create) or 2 (update).

Version 5.0.7

Release Date: 17 February 2021

Support tab: agent company now means company_type=1. "Is Agent Company" checkbox always shown. Agent Surcharge — Inclusive shown when checked. Additional fee fields shown when a parent company is selected.

Version 5.0.6

Release Date: 10 February 2021

Fixed offline alarm triggering without IMEI and mis-report bug.
New APIs: brands, category.

Version 5.0.5

Release Date: 02 February 2021

Monthly Card Statements now contain only non-credit card vends.
API now supports modifying card user email, mobile, and carduser_name.
Various API bug fixes.

Version 5.0.4

Release Date: 15 January 2021

Fixed Card List additional cards display bug.
QR codes now generated with CircumPay landing page URL.
Added "App Credit" card creation for CircumPay after card account activation.
Added summary info to Machine Asset View and Collection → History Records pages.

Version 5.0.3

Release Date: 10 December 2020

Fixed Cancel button in Import From Xero window causing an error.
Disabled Import From Xero button in each user's My Profile page.
Fixed last report column missing bug in restock view.
Upgraded Jersey 1 to Jersey 2, fixing the API not working bug.
Fixed additional cards not showing completely in the card list page.

Version 5.0.2

Release Date: 25 November 2020

SQS messages now sent for machine/machine type/company parameter changes and DTU link/unlink events. Lambda (_system_vmms_params) triggered to notify DynamoDB to update DTU parameters.
Company Edit → CircumPay → Company Industry: sorting implemented; Vending is always listed first.
Added Params tab to Company Edit page for editing company parameters.

Version 5.0.1

Release Date: 23 November 2020

Added Collector Role: users with this role can only access System → Machine with the collection button only.
Fixed issue where modified coil could not be saved.
Fixed issue causing too many statements to display on the cashless → vend list page.
Cashless → Statement: added Tab to display Card Monthly. Non-agent company users no longer see the Agent Charge Monthly Tab.
API card_accounts login: username can now be carduser_name, phone, or email.

Version 5.0.0

Release Date: 16 September 2020

Converted project to Maven.

Version 4.1.51

Release Date: 02 September 2020

Fixed credit-weekly statement inconsistency; changed credit card recognition to is_credit=1.
card_accounts API: mobile phone number uniqueness validated on create; complete record and new token field returned on login.

Version 4.1.50

Release Date: 25 August 2020

Unified API return format with status, info, page_info, and records fields.
After a successful POST, the newly added/modified record is re-queried and included in the response.
card_accounts API: removed mandatory email requirement; renamed phone to mobile.

Version 4.1.49

Release Date: 19 August 2020

t_cardusers/h_cardusers: added email_state and phone_state fields. Added t_cardusers_verify table for activation codes/tokens.
Added Xero company comparison popup showing VMMS vs. Xero details side by side.
Company API: new output field — img_url.

Version 4.1.48

Release Date: 06 August 2020

Fixed Machine Monthly creation failure for very large cash_vends values; records outside the range 0–65535 are now ignored.

Version 4.1.47

Release Date: 27 July 2020

After modifying company/user import from Xero, current page is now refreshed.

Version 4.1.46

Release Date: 21 July 2020

Company save now exports directly to Xero without requiring the Export to Xero button.

Version 4.1.45

Release Date: 19 July 2020

2-in-1 DTU: DTU → Collection now sends action=collection instead of restock.

Version 4.1.44

Release Date: 10 July 2020

Vend History: searching by master card number now returns vend records for both master and additional cards.
API cardvends: added sum_only=1 parameter to return summarised totals (total_vends, total_value, charges, total_payable).

Version 4.1.43

Release Date: 30 June 2020

Support interface company list: Status changed to drop-down; added Agent company filter showing subsidiaries.

Version 4.1.42

Release Date: 30 June 2020

Xero import/export uses server_id to determine environment (localtest/vmms/other).

Version 4.1.41

Release Date: 15 June 2020

Fixed Card list export showing incomplete header. Fixed non-standard data import errors. Added secondary card import support.
Added Export to Xero and Import from Xero buttons to company and user modification interfaces.

Version 4.1.40

Release Date: 28 March 2020

Added AgentCharge monthly report with role-based visibility (superAdmin sees all; agent users see agent_charge only; others see gateway_charge only).
Changed FORWARD_DEX_TO_SFTP parameter to DEX_TO_SFTP; existing params in t_company_params must be renamed.

Version 4.1.38

Release Date: 04 March 2020

cardvends API: added start_time, end_time (higher priority than date params), and sum parameters.
Monthly AgentCharge reports (summary and INDIVIDUAL) now generated; zero-data companies still included with 0 values.

Version 4.1.37

Release Date: 14 February 2020

Redesigned company settings surcharge interface; all fee settings moved to a dedicated Fee Setup page.

Version 4.1.36

Release Date: 12 February 2020

cardvends API: added machine_id condition parameter.
API documentation updated to AWS Gateway URLs.

Version 4.1.35

Release Date: 08 January 2020

Company images can now be uploaded to S3 (vmms-images) via System → My Profile.
Fixed incorrect calculation of card value, card vends, and card percent in machine yearly reports.
card_accounts API: added email existence check using password=CARD_USER_EMAIL_CHK.
Added "Advam Reconcile Result" menu in Support → Tools.

Version 4.1.34

Release Date: 17 December 2019

card_accounts API query: now returns user_type field.

Version 4.1.33

Release Date: 03 December 2019

t_cardusers/h_cardusers: added issue_date (Datetime); increased email and carduser_name length to 100.
Fixed is_credit=0 and missing carduser_id in refund records.
Fixed Vend History print/export buttons not working on first open.
Support interface: can now query by business name.

Version 4.1.32

Release Date: 17 October 2019

Product images now uploaded directly to S3 (vmms-images).
Added Product API.
Added t_statement_types table; all weekly/monthly reports now uploaded to S3.
t_card_vends/h_card_vends: charge fields changed to float(12,2); added is_credit field.
Cashless → Statement: added Credit Card Monthly tab.

Version 4.1.31

Release Date: 20 September 2019

Fixed Null errors in machine creation and category creation.
Each company can have only one Virtual Machine.
Added t_product_params table. Added Virtual Category concept for virtual products.

Version 4.1.30

Release Date: 13 September 2019

Added Enable CircumPay option to Company interface. Added t_company_industry table.
Virtual Machine support: virtual DTU auto-generated (IMEI: VC + company_id + Machine_id).
New tables: t_dtu_item; new fields in t_dtu: life_value, life_vends, life_card_value, life_card_vends.

Version 4.1.29

Release Date: 04 September 2019

Added Coffee Machine Report attribute to Company.
Machine: added Monthly Fee, Rebate, Cup Min, Cup Max attributes.
Location: added Customer Id field. Fixed card creation error when CardList is empty.

Version 4.1.28

Release Date: 12 July 2019

Credit card invoice now includes aid, authcode, card type, and vend type.
API: added filter support; auto topup attribute now modifiable via card API.

Version 4.1.27

Release Date: 20 May 2019

Added transactions API (query only).
Cards API: modified delete payment method behaviour for mobile app (state set to -1; re-add restores to 1).
t_cards.state changed from unsigned int to smallint to allow negative values.

Version 4.1.26

Release Date: 03 May 2019

Upgraded Jasper Report from 5.10 to 5.60; upgraded Groovy.jar to 2.4.13.
Card list report now shows additional cards and company name.

Version 4.1.25

Release Date: 04 April 2019

Machine save now inherits company timezone ID.
Fixed statement only displaying creditcard weekly. Fixed Vend History missing Cardholder. Fixed card list column sorting.

Version 4.1.24

Release Date: 20 March 2019

New API: card_accounts. Added token-based auth for mobile apps.
Card list: carduser created independently for secondary cards.
Added jjwt-0.9.0.jar for token generation and verification.

Version 4.1.23

Release Date: 15 February 2019

Webhook: added method, key name, and key value options.
Fixed Perth timezone offline alarm bug; timezone field changed to string (time zone ID).
Optimized DB indexes on t_reports, h_reports, t_users, t_dtus.

Version 4.1.22

Release Date: 05 February 2019

Charts replaced with Chart.js 2.7.3 on homepage and daily sales pages.

Version 4.1.21

Release Date: 11 January 2019

Added Card Account functionality. Card List changed to Tree view showing primary and secondary cards.

Version 4.1.20

Release Date: 19 December 2018

MqttController can now be disabled via MQTT_ENABLE system param.

Version 4.1.19

Release Date: 19 November 2018

Added batch coil price modification with cancel option; changes logged in t_service_log.
Added ServiceMode: service personnel see only Sales tab with limited fields.

Version 4.1.18

Release Date: 13 November 2018

Fixed various REST API bugs. Added Change Coil function in Planogram update page.

Version 4.1.17

Release Date: 07 September 2018

Added Webhook function to send HTTP POST requests externally.
Added Filter function in API Tester. Login API to obtain api_key.
Updated HTTP library dependencies.

Version 4.1.16

Release Date: 13 July 2018

Added Param management interface under Support → Tools → Param Dictionary.

Version 4.1.15

Release Date: 04 July 2018

Report interface: updated Month Range date format to MM/YYYY; added past fiscal year options.
Added Finance Year and Calendar Year options to Year Range.
Improved display format of all yearly Machine Report and Product Report files.

Version 4.1.14

Release Date: 22 June 2018

Cashless → Vend History: clicking the record ID downloads the receipt.
Added Company drop-down to Vend History (sysadmin only).
Inventory → Products: added Create Category and Create Brand buttons.
Cards: top up now supports negative values.
Added MQTT real-time command support via "More" button in Machine/DTU menus.

Version 4.1.13

Release Date: 11 May 2018

Added user registration pages (reg.html and terms.html). Newly registered users receive VMMS_ACCOUNT_OWNER role.
Added user registration review function in Accounts interface; newly registered users highlighted in red.
Added cashless/vendreceipt.zul for querying and downloading receipts.

Version 4.1.12

Release Date: 08 March 2018

Added REST API framework with t_api and t_api_fields tables. Default open APIs: Cards, Locations, Routes, Machines, Cardvends, Coils, MachineTypes.

Version 4.1.11

Release Date: 23 February 2018

Redesigned 32 Machine Report and Product Report JRXML files with descriptive naming.

Version 4.1.10

Release Date: 05 November 2017

Added refund function to Vend History for both credit card and VMMS card vends. Split into Normal and PPE views.

Version 4.1.9

Release Date: 30 July 2017

Vend History: added search by last 4 digits of credit card number, machine ID, and IMEI.
Added blackout time (0–1 AM) in FullTimeTask to prevent false offline alarms during database backup.
Migrated all scheduled tasks to DaemonFulltime mechanism. New credit card statement ordered by machine then vend time.

Version 4.1.8

Release Date: 17 June 2016

Agent report: added Surcharge Rate. DTU list: added "Linked Only" option.

Version 4.1.7

Release Date: 14 June 2016

Card List: reorganised to pagedwindow template. Vend History: merged refund function into the main page. Merged Transaction History and Manual Recharge into one page.

Version 4.1.6

Release Date: 18 April 2016

t_card_transactions/h_card_transactions: added company_id and card_type fields. h_card_vends: added ser_charge and promo_type fields.

Version 4.1.5

Release Date: 18 February 2016

Added VMMS_AGENT_ADMIN role with access to Accounts, Inventory, System, Finance menus.
Finance → Credit Card Statement: Agent Admins see a summary statement for all subsidiaries.
t_card_vends: added agent_charge field. Support: added Agent Charge Statement menu under Finance.

Version 4.1.4

Release Date: 25 November 2015

Fixed all-machines-offline timezone bug. Fixed unauthenticated access to index.zul.
Machine Type list: added type ID column.

Version 4.1.3

Release Date: 23 October 2015

Ticket: special characters now converted to HTML entities. Fixed Safari restock Go Back redirect bug.

Version 4.1.2

Release Date: 15 October 2015

Only one Account Owner per company. Super user can change credit card transaction fee per machine. Fixed card_vend/card_value auto-calculation for machines not reporting card vend data.

Version 4.1.1

Release Date: 02 October 2015

Added Support, Knowledge Base, and Support Center menus. Renamed "Product Type" to "Category". Added OWNER_INVENTORY param.

Version 4.1.0

Release Date: 25 September 2015

Added ticket function via groovehq.com. Added DTU firmware upgrade blacklist.

Version 4.0.5

Release Date: 31 August 2015

Added ABN field to companies.

Version 4.0.4

Release Date: 22 July 2015

EasyVending.properties auto-imported into t_system_params on startup.
Added Xero integration: export companies/users as contacts and weekly credit card statements as Bills.
Added task mechanism (DaemonFulltime). Fixed Liquibase lock issue.
t_machine_monthly: added card_value and card_vends fields.

Version 4.0.3

Release Date: 08 May 2015

Added DEX report forwarding to SFTP (configurable per company via t_company_params).

Version 4.0.2

Release Date: 01 May 2015

Setting machine IMEI to empty now triggers offline state.

Version 4.0.1

Release Date: 01 May 2015

Reorganized alarm mechanism: added coil empty and coil low alarms. Alarms visible only to the machine owner. Non-offline alarms generated when DEX is reported.

Version 3.3.x

Release Date: October 2014 – February 2015

Credit card statement enhancements; statement-by-user support per company.
Agent surcharge features; gateway fee deduction from weekly credit statements.
Upgraded to ZKoss 7.3. Integrated font-awesome 4.2.0 and Bootstrap theme v3.3.1.

Version 3.2.x

Release Date: June 2012 – October 2013

Coil alarm improvements (empty and low inventory alarms).
Sales report margin display (cost, margin, margin %).
Inventory import/export with card list CSV support.
Card user registration and activation workflow.
Pre-kitting enhancements and duplicate prevention.
Graphical inventory view (Graphic View) in Machine Detail.
Collection record management with editable history.
Multi-page machine list views (Sale, Location, Restock, Asset).