Highlights

• Add Settings for administrators.
• Add a warning when work order milestones are scheduled outside of regular hours.
• Block deleting contracts associated with open work orders.
• Fix some cases of duplicating initial config values on restart.
• Linting.

Database Update

With the new settings area in the database, there's a new table, SunriseSettings. This table should add itself on start. If the table does not get added for whatever reason, the following query can update the database.

CREATE TABLE SunriseSettings (
    settingKey varchar(100) not null primary key,
    settingValue varchar(500),
    previousSettingValue varchar(500),
    recordUpdate_timeMillis integer not null)

Full Changelog: v1.0.0-alpha.15...v1.0.0-alpha.16

Highlights

• Remove deprecated authentication packages. Replace with @cityssm/activedirectory-authenticate inside of @cityssm/authnetication-helper.
• Support for function-based authentication.
• Quickly jump to contracts by contract number.
• Hide funeral section when not used.
• Fix loading scripts on work order update when urlPrefix is used.
• Linting and polish.

Full Changelog: v1.0.0-alpha.14...v1.0.0-alpha.15

Breaking Change

config.js changes

• application.userDomain moved to login.domain.
• activeDirectory moved to login.authentication.config.

This opens up the option to implement your own authentication functions. Documentation not yet available, but the change is discussed in issue #14 . testing.config.ts implements a custom authentication function.

Highlights

• Updated @cityssm/pdf-puppeteer package for faster PDF output.
• Option to disable keyboard shortcuts (for accessibility).
• Linting and polish.

Full Changelog: v1.0.0-alpha.13...v1.0.0-alpha.14

Highlights

• Burial site range creator.
• Postal code validation.
• Fix hidden past related contracts.
• Funeral home paging.
• Change instances of "commentor" to "author".
• Linting and polish.

Highlights

• Add related contracts, helpful to link preneed contracts with interment contracts.
• Add invoiced transaction status, helpful when, say, and accounting department is taking over fee collection.
• Change fee quantities to only accept integers.
• Check for upcoming funerals when deleting funeral homes.
• Ability to restore deleted funeral homes.
• Hide funeral details on contract when not set, the case with many preneed contracts.
• Linting and polishing.

Update Queries

If you are running a previous version of Sunrise CMS, you must run the following queries to update the database.

create table if not exists RelatedContracts (
contractIdA integer not null,
contractIdB integer not null check (contractIdA < contractIdB),
primary key (contractIdA, contractIdB),
foreign key (contractIdA) references Contracts (contractId),
foreign key (contractIdB) references Contracts (contractId)) without rowid

alter table ContractTransactions
add isInvoiced bit not null default 0

Highlights

• Fix adding funeral homes. (Thanks for issue #12)
• Linting and polish.

Highlights

• Track burial site capacities. More to come.
• Highlight upcoming funerals on the funeral home view.
• Ability to restore deleted burial sites.
• Reword all "Switch to Edit Mode" labels to be more descriptive.
• Use backup function built into better-sqlite3.
• Linting and polish.

Update Queries

If you're coming from the previous release.

alter table BurialSiteTypes
add bodyCapacityMax smallint

alter table BurialSiteTypes
add crematedCapacityMax smallint

alter table BurialSites
add bodyCapacity smallint

alter table BurialSites
add crematedCapacity smallint

Highlights

• Add direction of arrival. See queries below.
• Rename config files.
• Move deathAgePeriods and purchaserRelationships out of config.
• CommittalTypes and IntermentContainerTypes added to Config Table Management.
• Death age calculator.
• Show funeral details from contract on work order view.
• Adjustable results limit for burial sites and contracts.
• Disable scroll wheel zooming on Leaflet maps.
• Linting and polish.

Queries

If you're updating a database from v1.0.0-alpha.8, you must run the following query.

create table if not exists CemeteryDirectionsOfArrival (
cemeteryId integer not null,
directionOfArrival varchar(2) not null,
directionOfArrivalDescription varchar(100) not null,
primary key (cemeteryId, directionOfArrival),
foreign key (cemeteryId) references Cemeteries (cemeteryId)) without rowid

alter table Contracts
add directionOfArrival varchar(2)

Highlights

• Create new burial sites from the contract. - #7
• Fix error adding grouped fee to contract.
• Create separate canUpdateWorkOrders permission.
• Remove better-sqlite-pool.
• Link funeral home from contract.
• Catch error connecting to Dynamics GP database.
• Differentiate between outstanding amount and overpayment on contract.
• Date field restrictions based on other fields (i.e. death date cannot be before the birth date, funeral date cannot be before the death date)
• Show (No Cemetery) when no cemetery is selected.
• Linting and polish.

Highlights

• Fix burial site contract status selector on contracts.
• Add paging between contracts.
• Add tag to top of contract view to show when finalized.