From wiki.ginstr.com
Jump to: navigation, search
(OBLIGATORY ENTRIES IN TABLES)
(OBLIGATORY ENTRIES IN TABLES)
Line 59: Line 59:
 
Following tables require following data:
 
Following tables require following data:
  
<code>TABLE fareBasis: fareBasis_name, fareBasis_comments <br>
+
TABLE fareBasis (rows to add)
fareBasis: "Regular", any comment
 
  
TABLE MOBICardStatuses: MOBICardStatus_name, MOBICardStatus_validity <br>
+
{| class="wikitable sortable" style="font-size: 85%; text-align: left;"
TABLE MOBICardStatuses: Active, true <br>
+
|-
TABLE MOBICardStatuses: Inactive, false <br>
+
! scope="col" | fareBasis_name
TABLE MOBICardStatuses: Suspended, false<br><br>
+
! scope="col" | fareBasis_comments
</code>
+
|-
<code>
+
| title="Column" | Regular
TABLE busDrivers: busDriver_ssoUsername - has to contain at least one driver entry which has column filled with email address of subaccount which has assigned role of "driver"<br>
+
| title="Value" | any comment
 +
|}
  
TABLE controllers: controller_ssoUsername - has to contain at least one driver entry which has column filled with email address of subaccount which has assigned role of "controller"<br>
+
TABLE MOBICardStatuses (rows to add)
  
TABLE retailers: retailer_ssoUsername - has to contain at least one driver entry which has column filled with email address of subaccount which has assigned role of "retailer"<br>
+
{| class="wikitable sortable" style="font-size: 85%; text-align: left;"
</code>
+
|-
 +
! scope="col" | MOBICardStatus_name
 +
! scope="col" | MOBICardStatus_validity
 +
|-
 +
| title="Column" | Active
 +
| title="Value" | true
 +
|-
 +
| title="Column" | Inactive
 +
| title="Value" | false
 +
|-
 +
| title="Column" | Suspended
 +
| title="Value" | false
 +
|}
 +
 
 +
 
 +
TABLE busDrivers:<br>
 +
<code> busDriver_ssoUsername - has to contain at least one driver entry which has column filled with email address of subaccount which has assigned role of "driver" </code>
 +
 
 +
TABLE controllers:<br>
 +
<code> controller_ssoUsername - has to contain at least one driver entry which has column filled with email address of subaccount which has assigned role of "controller"</code>
 +
 
 +
TABLE retailers:<br>  
 +
<code>retailer_ssoUsername - has to contain at least one driver entry which has column filled with email address of subaccount which has assigned role of "retailer"</code>

Revision as of 14:54, 15 August 2016


Public Bus Transportation ginstr app

Page describes how to setup initial environment to use "publicBusTransportation" ginstr app.

ROLES

following roles should be created on SSO and assigned to subaccounts

bus driver

Bus Drivers = RU
Bus Drivers Logs = CRU
Buses = RU
Bus Stops = R
Bus Stops Per Route = R
MOBICard statuses = R
Operators = R
Passengers = R
Routes = R
Special Incidents Passenger = C
Trips = CRU


controller

Bus Controller Checks = CR
Bus Drivers = R
Buses = R
Bus Stops = R
Bus Stops Per Route = R
MOBICard statuses = R
Operators = R
Passengers = RU
Pax Controller Checks = CRU
Suspensions = R
Ticket Controllers = R


retailer

Actual Top-Ups = C
Fare basis = R
GSM Networks = R
MOBICard statuses = R
Passengers = CRU
Ticket Retailers = R


MOBI staff

all tables full CRUD


OBLIGATORY ENTRIES IN TABLES

This app should work only on "English" at time of writing this. Since we do not have "localized enums" it's necessary to rely on english "fixed value" data to determine some logical states which are required by BL (Business Logic).

Following tables require following data:

TABLE fareBasis (rows to add)

fareBasis_name fareBasis_comments
Regular any comment

TABLE MOBICardStatuses (rows to add)

MOBICardStatus_name MOBICardStatus_validity
Active true
Inactive false
Suspended false


TABLE busDrivers:
busDriver_ssoUsername - has to contain at least one driver entry which has column filled with email address of subaccount which has assigned role of "driver"

TABLE controllers:
controller_ssoUsername - has to contain at least one driver entry which has column filled with email address of subaccount which has assigned role of "controller"

TABLE retailers:
retailer_ssoUsername - has to contain at least one driver entry which has column filled with email address of subaccount which has assigned role of "retailer"