Incident Reporter Setup

Incident Reporter Setup


Download Workshop Materials

Workspace Setup

The workspace is already configured, but you will need Eclipse with the Android SDK installed.  To do this, please follow the instructions listed here:  developer.android.com/sdk


Database setup

We are using a SQL Server database called "Incident" for this application.  Here is a summary of all of the tables and how each is setup:

User

This table is used to store the users for the application.  It is keyed on by "LoginEmail", but all fields are required.

Key -LoginEmail
Has -Password
First Name
LastName
CellNumber

 

User Splashscreen

This table is used to populate the introductory screen with a personalized image and message for the user.  If no record exists, the application will use a default image and message.  The image field is just using a filename to reference the particular image.  It is owned by the User table.

Key -LoginEmail
Has -SplashImage
SplashMessage

 

Incident Type

This is a simple table used to populate the Incident Type combo box.  It is being reference by another table.  It is keyed on by IncidentType.

Key -IncidentType

 

Incident

This is the primary table of the application. It stores all the relevant information for the Incident. It is owned by the User table, and uses Incident Number as a surrogate key.

Key -LoginEmail
Incident Number
Has -IncidentDescription
IncidentType (referred to)
IncidentStatus 
IncidentDate
IncidentLatitude
Incident Longitude
CloseDate

 

Incident Image

This table will store the file name of Image attached to the incident, as well as the file name of the Thumbnail version of the image.  It is owned by the Incident table.

Key -LoginEmail
Incident Number
Has -ImageLocation
ThumbnailImageLoc

 

Customized Server Functionality

General Changes

All views in the application were made to be "Type Table_access".  Because of this, no views need to be generated and all SQL queries will be done using the tables.

User.ByCell

A custom view was created for the User entity.  This view inherits directly from the Fetch view, but keys on the CellNumber

Incident.Update.InsertRow

The Incident Number was added to the Output for this function.  This field is being set just before the row is inserted.  This is so we can reference the Incident Number after the record was created.

Incident.Fetch.BlockFetchSet

Several changes were made to this function.

  1. 3 fields are added to the Output/FetchedData: ThumbnailURL, IncidentStatusDescription, and DateString.
  2. In the Initialize, we are fetching the user record.  This is so we can reference the CellNumber later in the function.
  3. After the row is fetched,  there is meta code to read the value of the IncidentStatus, get the name of the value, and cast it into IncidentStatusDescription.  This is done because we will not be using standard Plex grids in the application to display the data.  Since IncidentStatus is a Status field, normally, it would only show the literal value of the Status.  This is not very descriptive to the user, so we are displaying the full name of the value instead.
  4. Also after the row is fetched, there is code to fetch the Thumbnail image for the incident.  If none is found, then we will use a default image.  If one is found, then we will set the full image location: "photos/*CellNumber*/*ThumbnailImgLoc*".  This is the reason we fetched the CellNumber in the initialize.  A user's photos are being saved to a folder named after their CellNumber.  This is done to avoid naming conflicts on the files.
  5. Again after the row is fetched, there is code to change how we are displaying the IncidentDate.  Since we are not using standard Plex grids to display the data, we want to reorganize the date string from what it is on the database.

    • Related Articles

    • Incident Reporter Setup

      Download Workshop Materials Workspace Setup The workspace is already configured, but you will need Eclipse with the Android SDK installed.  To do this, please follow the instructions listed here:  developer.android.com/sdk Database setup We are using ...
    • Incident Reporter for Mobile

      Video Walkthrough Pattern Functions All functions will be under "Patterns.Mobile". CordovaPage This function inherits from ~WebShell, and has an IMPL Name of Cordova.  Any function inheriting from this will use the Cordova-page.ctrl template.  This ...
    • Incident Reporter for Web

      Video Walkthrough Pattern Functions All functions will be under "Patterns.Web". GoogleMap This pattern is a simple UIBasicShell.  It displays a single field: GoogleMap for GoogleMap.  This field has a Control Name of ...
    • Overview of Workspace Setup

      After you have the software requirements installed, below are the steps that you have to perform to setup your workspace for CM WebClient from scratch. Each step will be discussed in details when you click on the link. Install WebClient Builder ...
    • Active Directory Setup

      This document presents the procedure to set up Active Directory.  Once the Active Directory is set up in the Dashboard, it can be used to authorize users access to CM evolveIT.    After reading this document, you should be able to configure your ...