v1.0.0-dev.7

Important Note

Several varchar columns have been modified to nvarchar columns to add emoji support. To add emoji support to work order details, tags, notes, etc., change varchar columns to nvarchar. This is optional.

If you are already running an instance of ShiftLog, the following script is required for the latest version.

ALTER TABLE ShiftLog.AssignedTo
ADD assignedToEmailAddress VARCHAR(100) NOT NULL DEFAULT ''
GO

ALTER TABLE ShiftLog.WorkOrders
ADD workOrderTitle NVARCHAR(200) NOT NULL DEFAULT ''
GO

ALTER TABLE ShiftLog.WorkOrders
ADD requestorIsSubscribed BIT NOT NULL DEFAULT 0
GO

CREATE TABLE ShiftLog.WorkOrderSubscribers (
  workOrderId INT NOT NULL,
  subscriberSequence INT NOT NULL,
  subscriberEmailAddress VARCHAR(100) NOT NULL,
  recordCreate_userName VARCHAR(30) NOT NULL,
  recordCreate_dateTime datetime NOT NULL DEFAULT getdate(),
  recordUpdate_userName VARCHAR(30) NOT NULL,
  recordUpdate_dateTime datetime NOT NULL DEFAULT getdate(),
  recordDelete_userName VARCHAR(30),
  recordDelete_dateTime datetime,
  PRIMARY KEY (workOrderId, subscriberSequence),
  FOREIGN KEY (workOrderId) REFERENCES ShiftLog.WorkOrders (workOrderId)
)
GO

Highlights

Evaluating use as an IT Help Desk. Primarily focused on work orders.

• 📨 Add support for the Microsoft Graph API, to create work orders and send work order updates by email.
• ➕ Added work order titles and work order subscribers.
• 🐞 Fix "Assigned To Management" edit.
• ✨ Lots of linting and polish.

Full Changelog: v1.0.0-dev.6...v1.0.0-dev.7

v1.0.0-dev.6

Updates

• Work Order Accomplishments Dashboard, for managers to see work at a high level.
• Note Type Templates, to help with getting started with creating notes, and to help initialize note types on new installations.
• Added colors and icons for data list items. Not used anywhere yet.
• Lots of polishing and smoothing out.
• Lots of linting, including the introduction of an editorconfig, carried over from cityssm/sunrise-cms#77

Update Queries

If you already have a ShiftLog database:

alter table ShiftLog.DataListItems
add colorHex char(6) not null default '000000'
go

alter table ShiftLog.DataListItems
add iconClass VARCHAR(50) NOT NULL DEFAULT 'circle'
go

Full Changelog: v1.0.0-dev.5...v1.0.0-dev.6

v1.0.0-dev.5

Major Update

⭐ Custom note types for shifts and work orders. ⭐

If updating from a previous version:

CREATE TABLE ShiftLog.NoteTypes (
  noteTypeId INT PRIMARY KEY identity(1, 1),
  instance VARCHAR(20) NOT NULL,
  noteType VARCHAR(100) NOT NULL,
  userGroupId INT,
  isAvailableWorkOrders BIT NOT NULL DEFAULT 0,
  isAvailableShifts BIT NOT NULL DEFAULT 0,
  isAvailableTimesheets BIT NOT NULL DEFAULT 0,
  recordCreate_userName VARCHAR(30) NOT NULL,
  recordCreate_dateTime datetime NOT NULL DEFAULT getdate(),
  recordUpdate_userName VARCHAR(30) NOT NULL,
  recordUpdate_dateTime datetime NOT NULL DEFAULT getdate(),
  recordDelete_userName VARCHAR(30),
  recordDelete_dateTime datetime,
  FOREIGN KEY (userGroupId) REFERENCES ShiftLog.UserGroups (userGroupId)
)
GO

CREATE TABLE ShiftLog.NoteTypeFields (
  noteTypeFieldId INT PRIMARY KEY identity(1, 1),
  noteTypeId INT NOT NULL,
  fieldLabel VARCHAR(100) NOT NULL,
  fieldInputType VARCHAR(20) NOT NULL,
  fieldUnitPrefix VARCHAR(20) NOT NULL DEFAULT '',
  fieldUnitSuffix VARCHAR(20) NOT NULL DEFAULT '',
  fieldHelpText NVARCHAR(500) NOT NULL,
  dataListKey VARCHAR(20),
  fieldValueMin INT,
  fieldValueMax INT,
  fieldValueRequired BIT NOT NULL DEFAULT 0,
  hasDividerAbove BIT NOT NULL DEFAULT 0,
  orderNumber INT NOT NULL DEFAULT 0,
  recordCreate_userName VARCHAR(30) NOT NULL,
  recordCreate_dateTime datetime NOT NULL DEFAULT getdate(),
  recordUpdate_userName VARCHAR(30) NOT NULL,
  recordUpdate_dateTime datetime NOT NULL DEFAULT getdate(),
  recordDelete_userName VARCHAR(30),
  recordDelete_dateTime datetime,
  FOREIGN KEY (noteTypeId) REFERENCES ShiftLog.NoteTypes (noteTypeId)
)
GO

ALTER TABLE ShiftLog.WorkOrderNotes
ADD noteTypeId INT
GO

ALTER TABLE ShiftLog.WorkOrderNotes
ADD CONSTRAINT fk_sl_won_notetypeid FOREIGN KEY (noteTypeId) REFERENCES ShiftLog.NoteTypes (noteTypeId)
GO

CREATE TABLE ShiftLog.ShiftNotes (
  shiftId INT NOT NULL,
  noteSequence INT NOT NULL,
  noteTypeId INT,
  noteText VARCHAR(max) NOT NULL,
  recordCreate_userName VARCHAR(30) NOT NULL,
  recordCreate_dateTime datetime NOT NULL DEFAULT getdate(),
  recordUpdate_userName VARCHAR(30) NOT NULL,
  recordUpdate_dateTime datetime NOT NULL DEFAULT getdate(),
  recordDelete_userName VARCHAR(30),
  recordDelete_dateTime datetime,
  PRIMARY KEY (shiftId, noteSequence),
  FOREIGN KEY (shiftId) REFERENCES ShiftLog.Shifts (shiftId),
  FOREIGN KEY (noteTypeId) REFERENCES ShiftLog.NoteTypes (noteTypeId)
)
GO

Other Highlights

• Custom data list maintenance. Custom data lists can be used as drop list items in notes.
• Ability to add multiple items to a data list at once.

Full Changelog: v1.0.0-dev.4...v1.0.0-dev.5

v1.0.0-dev.4

Highlights

• Removed unused userGroupId column from Locations table.
• Trigger work order update notifications when data in related tables is updated (i.e. milestones, costs).
• Check for (and wait for) database if unavailable on start, rather than crash.
• Avoid page breaks inside data table rows.
• Small screen tweaks.
• Lots of linting.

v1.0.0-dev.3

Highlights

Updates after morning demo.

• Hide work order close date field on create and on read only when not populated.
• Add initial raw exports to reporting.
• Closed work order report by date range.
• 🐞 Fix "Assigned To" display in work order calendar.
• Default "Assigned To" on work order search, calendar, and open map if set in User Settings.
• "Create New" shortcuts added to navbar.

Full Changelog: v1.0.0-dev.2...v1.0.0-dev.3

v1.0.0-dev.2

Highlights

• Navigation warnings when work order edit modals are open.
• Work order tag updates.
• Preserve work order tab when switching from read only to edit mode.
• Apply section aliases to modals and other Javascript-loaded content.
• Linting and polish.

Full Changelog: v1.0.0-dev.1...v1.0.0-dev.2

v1.0.0-dev.1

Significant work order section polishing before adding more focus to shift management.

Full Changelog: v1.0.0-dev...v1.0.0-dev.1

v1.0.0-dev

A development release to mark the start of demos, testing, and feedback on the work orders piece.

Note that shifts and timesheets are still under development.