API

This fixes a scenario in which the API returned the HTML of the error page instead of the standard response format.

Billing

• The Stop/Start dates for Alternate Recurring Charges are now correctly set on Service ID Actions.

• Corrects a bug on the Charge GLA Conflicts grid.

CustomerCenter

• Resolves issues when creating duplicate requests through the CustomerCenter, particularly when submitting the same request multiple times.

Custom Reports

• Changes Batch Email to use WYSWIG for Email Message.

• Revised scheduling Options to Batch process.

• Removes the [Create Batch] button from the Custom Reports grid.

• Corrects a bug causing all Saved Custom Report data files to be deleted when only one was deleted.

Custom Logic

• Adds support for binding array values to a single bind param when using the custom logic ->query() method, exposes custom logic ->getQueryError() method, and prevent stripping HTML characters on the custom logic debug form.

• Exposes the authenticated users GLA Permissions for use in custom logic ($user['permittedGlas']).

General

• Updates all PCR-360 Email columns to allow for 254 characters.

• The system now clears the Table Cache to prevent errors after the Archive Process.

• Corrects a bug that prevented saving bookmarks to the bookmarks pane.

• Removes ext-raphf from the composer require.

• Resolves an error on the Contact Bulk Update form when selecting the Remove Existing Workgroups option.

Imports

• Adds a new configuration option to set memory allocation for the Import process.

• Imports no longer throw association errors when trying to set inherited UDFs.

• The Service Import now allows the use of Category Service Catalogs.

• Resolves an issue with the Location Import clearing address data for fields that aren’t mapped.

Service Desk

• Adds a ‘Types’ column to the Requestor picker on the Service Order form.

• Allows a single Pending Remove action for each Location of a Multi-Location Service.

• Service Desk Action UDFs can now be reordered.

• Corrects the Service Order link used in Notifications to open the specified Order.

• The Service Catalog Picker on the Service Desk Action form no longer allows Categories, only Assignable Service Catalogs.

• Corrects the UDC Class association for Service Desk : View / Report : Actions grid. This ensures the correct UDC selection is displayed on the grid.

API

• Adds an API endpoint for pulling Cable View Path Reports

• Adds an API endpoint for rendering HTML and PDF Custom Reports.

• Adds an API endpoint for Locations.

API

Cable API Endpoint

Locations API Endpoint

Billing

• Adds a Configuration Option to control Invoice Link on ViewBill, allowing for Custom Report Invoices.

• Adds a Configuration Option to hide the View Bill Full Details link.

Configuration Guide

Billing Parameters

• Corrects a spelling mistake (Quantity) on the Invoice.

Catalogs

• Adds the ability to modify Location Types for non-building Locations. The system still prevents creating a building inside of another building.

Location Catalogs

Cable

• Fixes an issue preventing Ports/Pins/Lens (PPL) from being added to Service Desk Cabling when using Auto Assign.

• Adds a check for “Move To Location” when populating the Auto Assign Location.

• Fixes an issue that prevented the Origination, Destination Equipment, and Locations from grouping on the Cable Maintenance Grid.

• The Card # field for Cabling Equipment is no longer hidden, regardless of status.

• Resolves an issue where transferring a partial set of Pair/Strands unlinks the Cabling Equipment from the untransferred pairs.

• Fixes the Pair/Strand transfer to only edit the Pair/Strand Equipment on the Pairs within the transfer range.

CustomerCenter

• Expired Requests in CustomerCenter can no longer attempt to be approved. They are still viewable through the approvals grid and will be labeled as expired.

• CustomerCenter now supports Work Requests.

• The Approval menu item in CustomerCenter now displays the number of requests awaiting approval.

Requests

Work Orders

Approvals

• Resolves issues with searching Call Details by Authcode in CustomerCenter.

• Resolves issues with searching the Directory in CustomerCenter.

• Improves error reporting in CustomerCenter.

• Corrects an error preventing Custom Reports from rendering on CustomerCenter

General

• Adds PHP 8.3 Support

• Introduces more cell copy options in the grid context menu.

  • Right-click → Copy Row

  • Right-click → Copy Column

  • Adds the following Copy Formats for the Copy Row and Copy Column options:

    • JSON

    • CSV

    • TSV (Excel)

• Updates the Custom Logic validation to support PHP 8 language-level features and token parsing.

• Ending Emulation on the Users grid now reloads the previous filters.

• Custom Logic Changes

  • Adds Custom Logic functions createFile() allowing the creation of files in the Inbound or Outbound directories and arrayToCsv() to assist in generating CSV data.

  • Adds the detach and detachDb methods in Custom Logic.

  • Adds the sendSystemMessage method for use in Custom Logic. This allows Custom Logic to generate system messages for a specified contact.

  • Updates the Custom Logic ->call() method to allow for committing data immediately upon successful completion.

• Adds a config viewer grid at Admin > Config Viewer to display the PCR-360 configuration values and descriptions.

• Adds a Log Viewer menu item for viewing the PCR-360 error logs

  • Errors are no longer logged in the Error Log Explorer; they are now logged in a log file under logs.

  • The Log file name is specified by constants.APP_LOG_FILENAME

  • Available log files are defined by logviewer.logfile[] = PATH values in the .ini file

• Minor rework of Addresses that resolves difficulties adding or editing Addresses.

• Composer Changes

  • Adds required PHP Extensions to Composer config so that Composer will validate the required extensions.

  • Updated to a PHP 8.3 compatible version of the Zend framework forked from shardj/zf1-future.

  • Updated to a PHP 8.3 compatible version of the Zend framework Extras forked from shardj/zf1-extras-future.

  • Moves the MS Graph library to composer.

  • Moves the Leaque OAuth2 cleint (used by Graph) to Composer.

  • Removes GuzzleHttp from the Library. It was not added to composer as it will be included by MSGraph as a dependency.

The Grid

Users

Allowed Functions in Custom Logic

Config Viewer

Log Viewer Grid

Misc Parameters

Locations Tabs

• Adds indexing support for Cable Maintenance, PPL, and Location grids. Significantly reducing grid load times.

Grid Toolbar

Grid Indexes

• Removes the “Error Log Explorer” (System Log table).

• Fixes the functionality and enables for saving with ctrl+s (or cmd+s for Mac) on all PCR forms.

The Data Entry Form

Imports & Exports

• Adds Custom Reports to File Export capability.

• Applies a fix to the _commit and _rollback methods of the Oracle and MySQL adapters to check for an existing transaction before trying to perform and action on it. Resolves the “PDO Exception” errors occasionally for Imports.

• The Approval Criteria Import now supports the Tier field.

Inventory

• The Units field on Equipment Forms can now be updated if the User is an Admin or has explicit form element permissions set.

• New feature Purchase Order Pricing can default the Service Desk charge amount for Equipment in relation to the purchase price instead of the catalog default.

Equipment

Purchase Order

Purchase Order Pricing

Tenant Management

• Resolves issues with adding Unit Equipment to a Purchase Order.

People

• Allow for Contact email addresses up to 100 characters in length

Reports

• Adds Import/Export functionality to Custom Report builder.

• Adds PDF Options to Custom Report builder.

• Revised Custom Report Attachments.

• Custom Reports Enhancements

  • Upgraded Bootstrap from v4.0.0 to v5.1.3

  • Adds a new Bills Picker

  • Improves Error Handling

• Batch Report Fixes

  • Allows Template data in the Batch Report Description.

  • Fixes rendering issues with Saved Reports on CustomerCenter.

  • Updates Saved Reports so deletion removes the file from the server.

Services

• Adds a MAC Address column to all of the Service Grids.

Service Desk

• Adds Service Order and Action Numbers to the Service Desk prompt when notifying users of existing Actions on a Service.

• Service Remarks now display timestamps when viewed from a Service Desk Action.

• Labor from Voided workflows no longer appear in the Time Entry grid

• Prevents creating more than a single Remove or Service ID Action for a Service at a time. Returns a message when attempting to create a second Service ID Action or Remove Action on the Service.

• The Service Desk Actions Equipment grid now includes Equipment from the Service Location and all child Locations.

• Adds Batch Scheduling for Service Desk Items

  • Adds a feature to Schedule Completion and Finalization of Service Desk items and Child Actions (excluding Estimates) from the corresponding form.

  • Adds Service Desk change values for Complete On and Finalize On.

  • Adds an event to complete scheduled Service Desk items.

  • Adds some common issues to the validation for Service Desk completion so issues can be detected before trying to Complete.

Service Orders

Service Desk Actions

Service Desk Change Actions

Service ID Actions

Service Desk Labor

Service Desk Equipment

Time Entry

Service Desk Bulk Update

Problems

Projects

Work Order

• Resolves issues with the Service Desk Action printout.

• Adds logic to attempt to fix orphaned SDC data when another Action is completed for the same Service.

ADDRESSES

Updated

API_PERMISSIONS

Updated

CONTACTS_EMAILS

Updated

ALTER TABLE `CONTACTS_EMAILS` MODIFY COLUMN `EMAIL` VARCHAR(100) NOT NULL;

EQP_CATALOG_CHARGES

Updated

EXPORT_FORMATS

Updated

ALTER TABLE `EXPORT_FORMATS` ADD `REPORTS_RECID` INT NULL;

EVENTS

Updated

GRID_INDEX

Added

CREATE TABLE `GRID_INDEX`

LISTS

Updated

PURCHASE_ORDER

Updated

REPORTS

Updated

ALTER TABLE `REPORTS` ADD `PDF_OPTIONS` LONGTEXT NULL;

REPORTS_BATCH

Updated

REPORTS_SAVED

Updated

ALTER TABLE `REPORTS_SAVED` MODIFY COLUMN `QUERY_STRING` VARCHAR(1024) NULL;

SERVICE_DESK

Updated

SERVICE_DESK_ACTIONS

Updated

SERVICE_DESK_ACTIVITY

Updated

SERVICE_DESK_EQP

Updated

TENANTS

Updated

USERS_PERSPECTIVES

Updated

SYSTEM_LOG

Removed

DROP TABLE SYSTEM_LOG;

USAGE_ADDRESS

Added

create table USAGE_ADDRESS

No changes