Hired Equipment Tracking System (HETS)
The BC Ministry of Transportation's Hired Equipment Program is for owners/operators who have a dump truck, bulldozer, back hoe or other piece of equipment they want to hire out to the Transportation Ministry for day labour and emergency projects. The Hired Equipment Program distributes available work to local equipment owners. The program is based on seniority and is designed to deliver work to registered users fairly and efficiently through the development of local area call-out lists.
The Hired Equipment Tracking System (HETS) is currently a part of BC Bid. However, the current version of BC Bid is being replaced by a new version at the end of Fiscal 16/17 and the new version will not include support for the HETS program. As such, a Project is underway to replace the current HETS with a new implementation.
The application is being developed as an open source solution.
- ApiSpec: The API Specification, in OpenAPI (Swagger) format. This folder also includes a system to create the OpenAPI files from Excel format input, as well as test data.
- Common: A library of common methods used by various components
- FrontEnd: The Front End server that hosts static content and proxies the API
- Jenkins: Jenkins configuration data
- openshift: OpenShift templates
- PDF: A microservice for PDF rendering
- Server: The API Server
This application is meant to be deployed to RedHat OpenShift version 3. The full application will require 8 Cores of CPU and at least 8 GB of RAM, plus sufficient Persistent Volume storage for the database and configuration secrets.
Two OpenShift templates are provided, one for the build and one for the deploy. Full details are here: OpenShift
- Text editor such as Sublime Text or VI
- .Net Core SDK (.NET Core App 2.0 is used for all components)
- .NET Core IDE such as Visual Studio
- PostgreSQL 9.4 or newer
- RedHat OpenShift tools
- A familiarity with Jenkins
Run npm install from the Client directory to configure the Client build environment
The frameworks used for this application are React/Redux.
- Create a local postgres database that you will use for development purposes
- Edit the project launch settings such that the same environment variables set during deployment are set on your development environment
- Run the code in Development mode, which will allow you to get a Developer Token allowing the application to run outside of a BC Government SiteMinder authenticated environment.
- SiteMinder - a centralized web access management system that enables user authentication and single sign-on, policy-based authorization, identity federation, and auditing of access to Web applications and portals.
- A developer token is obtained by going to the following url, where is a valid SiteMinder UserId field in the database.
- The MicroService "PDF" requires an instance of the "Server" component in order to be tested. However you can run both applications at once on the same computer, with each running on different TCP ports. Configure the [Environment Variables] with appropriate settings for each service.
Code Generation A large part of this application was generated through a custom [Swagger Codegen extension] (https://github.com/bcgov/Swagger-Codegen-Extension). A custom Swagger Editor was also used to validate the OpenAPI format files that form the API specification.
Generated sections in the code include:
The generated model was then used to construct the database through the use of Entity Framework.
SonarQube is a code quality service that helps identify problem areas in code through static analysis.
A batch file is provided in the Server code directory that can be used to run SonarQube code analysis on the API Server code.
Before running this batch file,
sonar.bat, ensure that you have a valid SonarQube account (can be your GitHub account once registered with SonarQube.com) and that your SonarQube token is installed properly on your computer. You will also need the SonarQube Scanner for C# to be installed on your local computer.
The file sonar.bat will start the SonarQube scanner, execute a build, and stop the scanner. You may then go to the SonarQube.com website to view the results of the scan.
Viewing the Database
This application utilizes the SchemaSpy OpenShift image to provide an easy way for stakeholders to view the database schema. The SchemaSpy component is a self contained schema viewer application that can be rapidly deployed to analyze the database structure and provide a website to review details of the database.
Please report any issues.
Pull requests are always welcome.
If you would like to contribute, please see our contributing guidelines.
Please note that this project is released with a Contributor Code of Conduct. By participating in this project you agree to abide by its terms.
Copyright 2017 Province of British Columbia Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.