Test env (BSU networ or VPN required)
https://tbuslog01.aws.bsu.edu:8443/#/driver

https://tbuslog01.aws.bsu.edu:8443/#/manager

production env  (BSU networ or VPN required)

https://pbuslog01.aws.bsu.edu:8443/#/driver

https://pbuslog01.aws.bsu.edu:8443/#/manager

Code 

https://github.com/Yliu12/autoshuttlelog_Client

https://github.com/Yliu12/autoshuttlelog_Server

Code Structure introduction: Link

Please See Readme for deploy and run instructions

 

 

User Manual: Link

Ec2 Ami Configurations: Link

Check Oracle DB connection : Link

 

 

 

Migrate DB.

Add data upload alert to Client Logout Page

Delete user

 

DB items:

 

Tables:

SL_USER
LOG
DAILYREPORT_STOP
DAILYREPORT_HOUR
BSULOOP

Triger:
DAILYREPORT_STOP_SEQ_TR
SL_USER_SEQ_TR
BSULOOP_SEQ_TR
LOG_SEQ_TR
DAILYREPORT_HOUR_SEQ_TR

Sequence
BSULOOP_SEQ
DAILYREPORT_HOUR_SEQ
DAILYREPORT_STOP_SEQ
LOG_SEQ
SL_USER_SEQ
USER_SEQ

 

All items above belong to bsu_yliu12 user.

Sqls :

SELECT *
  FROM user_tables;


select * from USER_TRIGGERS;

SELECT *
  FROM user_sequences

Moved to Oracle, Data Summary Backend Done, Working on dashboard, progress:

System Requirement

Ipad : Ios 11.3+ safari

Android : 6+ Chrome

 

Manager Site:

URL

https://tbuslog01.aws.bsu.edu:8443/#/manager

The manage user tab is visible after login with username & password

 

Dashboard

Select a begin date and a end date to view reports

 

Driver App

https://tbuslog01.aws.bsu.edu:8443/#/driver

Fist shift Drivers log in at the office when they start a bus.

Driver edit Driver’s name, Bus Id, Loop, Stop when needed.

Last shift Drivers logout form device at the end of the day, the tablet should be connected to internet when logging out.

Working on Dashboard Charts and tables.

Added a scheduled task that executes sql everyday 5am to group data from the day before.

 

Cd into

/home/yliu12@bsu.edu/testcode

run

java -cp ./ojdbc7.jar:. TestOrclConnect

 

 

install Oracle Jar to maven

mvn install:install-file -Dfile=/dir/to/jar.ojdbc7.jar -DgroupId=com.oracle -DartifactId=ojdbc7 -Dversion=12.1.0.2 -Dpackaging=jar

Change in application-context.xml

• DB connector
• DB rul
• username & password

• dialect

• add <prop key=“hibernate.default_schema”>bsu_yliu12</prop>

change ID auto generate annotation

//Mysql

@GeneratedValue(strategy=GenerationType.AUTO)

//Oracle

@SequenceGenerator(name = “generator”, allocationSize = 1, initialValue = 1, sequenceName = ” USER_SEQ”)

@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = “generator”)

• Switch to Oracle — Check Oracle version
• Add login popup
• Add User manage
• Add loop Manage
• Add dashboard
• Add summary generate.

Front 

• Arrange form height — Next release

Test on Android(Chrome v6+)

Samsung Galaxy, Android 7.1.1 Chrome.

Test ride green loop, All feature worked fine.

Close window and reload webpage offline, data recovered correctly.

Test on IOS(v11.3+ safar)

Offline feature only works with Safari.

Greenloop, all feature worked fine.