shubhampandey28 / transport-management-system

GUI for transport management system.

Transport-Management-System

A database architecture for SG Transport using pyQT for UI and SQLite for data management. We are using SQLite as being server-less it makes our app independent since it does not require any set-up to work, that is one can just install it and start working.

Installing Dependencies

pip3 install PyQt5==5.14.2

TODO List

The list below is in the order of decreasing priority therefore please focus on the first one for the time being.

1. Vehical-Repair-Management : A tool to track the repairing and maintenance cost of every vehical. This will help is calculating the cost effeciency of each vehical and help in making Important future decisions regarding the vehical. The back-end implementation of this can be done in 3 ways:

   1. Have different tables for every vehical.
   2. Have only one common table for every vehical.
   3. Have both 1 and 2. Currently it's decided to implement the 2nd approach but instead of having just one table we'll have separate table for each years logs. That is each table will contain data of all the repairing and maintenance that happened that particular year.

2. Job-Management : A tool to track the jobs and movement of all the vehicals. Implementation needs further discussions

3. Bill-Generation-Tool : This will automate the Entries to Job-Management.

4. Maintenance-Suggester : A tool which uses Machine-Learning to suggest when a vehical should next go for maintenance using the jobs/movement and repairing/maintenance history of the vehical.

transport-management-system's Issues

automated black check on windows

work-around for python application github actions needed.

Black --check command not recognising *.py in wondows.

Create Dictionaries Representing Tables in dictionaries.py

Create a Database api

Please Update the progress here either by commenting or my mentioning this issue in your PR. 😄
Also mention this issue when creating a new issue regarding api.

Create a Repair Management tool

Use PyQT5 and MySQL to create a Repair Management Tool. Features :

• A Form layout asking users for new repair entry.
• Create Views that show all of the repair history.
• add the following Filters to the Views
  1. Vehical based.
  2. Time Based

Make Add Consignments tab Consistent with schema.

Make design changes as you see fit.

Unable to show all 3 radio buttons (Consignor , Consignee and Both)

I am unable to show all 3 radio buttons (Consignor, Consignee, and Both) in AddConsignor.py under 'Add as' label.
This is due to formLayout
I tried putting the 3 radio button in a group box but its not working

Restructure the app

Read about deploying pyQt5 apps and restructure the app accordingly.
Do Not Merge Before Confirmation (I won't merge without confirmation either).

Add Create user and login features

add a login page which shows up as soon as user starts the app. this page should also have a create user option. show other features only if login in successful (session is active).

Work on Status Bar Actually showing the status

For the time being statusbar only showing connected and notConnected (to the server) would be enough but with time we can work on it so that it shows more detailed Information like insertion failed ...

Make AddConsignor form consistent with the Sql Schema

Only Take the required inputs. Remove city, state and add as options. Elongate Input box for Address. and rename GSTINV to something more appropriate

Create Desktop Entry

Look for an Icon

I know it's not really relevent at this point but just do it.