Related to issue #16

issue

Admin should able to see all his employees that he added with Employee adding form in issue #16 . We should be aiming to create a separate employee table in database.

• Use list view in Javafx to create the ui.
• Generate the list with all employees data from database.

Step to Reproduce:

1. Login into the Application.
2. Create a new project and sure the difference between start date and end date of the project is more than 50 days.
3. Click on "show gantt chart" button to see the Gantt Chart.

Actual issue

A date is missing. See screenshot below.

Expected solution

No date should be missed.
For making the Gantt chart we have used a built-in java class called XYChart and through X-Axis we have put the Date Axis from DateAxis API. We may need to work with this Date Axis API file to fix this bug.

Screenshot

Issue

Currently we are using MySql Database for our project. We should be aiming to use MSSQL server.

Employee should not be able to see/ add the following in project details page:

• Employee can not add new task to project. Hence remove Add Task button from Employee.
• Employee can not delete existing tasks. Hence remove Delete Task button from Employee.
• Employee can not edit progress in tasks table. Hence disable that functionality for employee.

Related to #15

Issue

We should be allowing admin to his/her add employees. The form to add employee should contain these information -

• First name
• Last name
• Employee id
• Employee username
• Employee password
• Contact number
• Email
• Gender
• Designation
  etc...

Employee username and Employee password should be used for employee login authentication.

The profile page should have all the information of an Employee. He can update his username and password if he wants.

Issue

Currently, we can only update progress field in task table.

Need to do

We should allow admin to edit and update every field in tasks table.

Screeenshot

Related to #18

Issue

On "All projects" page, we only want to display the projects where the employee has been assigned to its task.

Issue

Currently we are manually writing name of the employee whom we want to assign a task in a project.
Since, we will be making a employee panel by adding every employee, we want to have a choose box from where we will choose the employee name instead of writing the name manually. Employee names will be fetched from database.

Step to reproduce

I have used a single Arraylist to store the Start Dates and End Dates of all tasks inside a project look here and looped through them periodically to get expected result. Look here

It is better we use 2 Arraylist to contain Start Date and End Date.

Step to reproduce

For now we are showing rectangular colored bar for tasks in Gantt Chart.

Solution

We want to show colored bar (under each reactangular colored bar) for determining progress of a task in Gantt Chart.

Screenshot

Issue

Currently, we can query a project's details info with its id.
We want to implement another searching option i.e. query with project name. There should be a dropdown of existing projects. User can select the project name and query for details info.

Step to Reproduce

1. Log into the application.
2. Add a new project with multiple tasks. Load the tasks after you added a few tasks.
3. You will able to see the color column if filled with 10 digital hexa code (Ex: 0xffb300ff )

Solution:

1. We want to show more readable hexa code. Thus, we want to show only 6 digit of the color code.
   Example: Instead of 0xffb300ff, we want to show #ffb300

issue

Currently, we have only login functionality. We want to have logout options in both employee and admin panel.

Issue

Both in admin panel and employee panel, we need this. An admin can see employee's profile, where there will be a list of projects and tasks that the employee is assigned to. NOTE: An Admin can check all employee's profile
In employee panel, an employee can only check the projects and tasks that he/she had been assigned to from employee panel.

We want to make a new welcome page for employees where an employee can find the summary of his/her assigned projects. The new welcome page will act like a Home page from where an employee can easily navigate to other pages.

Suggestions:

• Add new class & fxml with new package.
• Use this name package name: IntroPageEmployee to match existing wording pattern where Admin Intro is named IntroPageAdmin

Sketch

Step to reproduce

1. Log into the application.
2. Go to existing project's details view or create a new project with multiple tasks.
3. Then click on "Show Gantt Chart" button. You will find it closes the project details view and display only Gantt Chart.

Solution

We want to show both Project Details page along with Gantt Chart when someone clicks "Show Gantt Chart" button.

you will find the code here

We should redesign the existing login page and have a better view on it.

There should be a table with client with following columns:

• Client id
• Name
• Contact Person
• phone
• address

Admin should able to choose client on every project.

Step to Reproduce:

1. Login the application.
2. Click on "Add new project" button from top.

Current issue

Currently, we are taking project ID as input from user and save it to database as stated here in ProjectDetailController.java. Also, we are checking if user giving input the same ID twice from here so that we don't get duplicate project ID.

Expected solution

We want to generate the project ID automatically and it should increment by 1 from previous project ID. To be precise:

1. We want start from 0 as our first Project ID and increment it by 1 in the next project ID and so on.
2. Make the project ID field disable so that User can not edit Project ID field.

Screenshot

After a successful login in the application, it takes us to "All projects" page where we can see the existing projects.
Currently, if we add more than 7-8 projects, the layout gets out of the computer's visible display area, hence we can't access some project's info. In short, we can say, it's breaking the layout.
In current design, we are using Accordion to hold each project and inside the Accordion, we are using Titledpane to hold the project title VBox to hold the project's info.

We need to come up with a new design where we can place 500+ projects without layout breaking.

For Employees

In top part, there will be 3 buttons:

• Projects
• Profile
• Search Project

In main part, there will be accordion table of existing projects where the employee has been assigned

Issue

Currently, we are able to create project and add multiple tasks under each projects. But we have no option to delete projects. We want to have a Delete project button in project summary view, which will help to delete the project.
NOTE : Each project may consist of multiple tasks. If a entire project is deleted, make sure the tasks under that projects also get deleted from database.

Screenshot of project summary ui

Issue

Whenever we select the calendar (to choose start/end date of a project / task), it points to that current date in the calendar.

Need to do

If we select a start date in the calendar, then if we select calendar to choose an end date, it should point the start date instead of current date.

We want to add another field named Note in every task's table. Only Admin can see and update time to time.

We want to make two more fields in project_info table i.e. client & project manager.
In project summary & project details page we want to display these fields (If possible).

• There should be a dropdown of Clients from where admin can choose one.
• There should be a dropdown of employees whose designation is manager. Admin will choose one.

We want to make a new welcome page for admin where admin can find the summary for projects, employee and clients. The new welcome page will act like a Home page from which admin can easily navigate to other page.

sketch

Step to Reproduce:

We are currently taking each task's representation color as input from user here. The hexa color code are being stored in the database as String. We are also showing that weird piece of code (something like 0x7b1fa2ff) in our table at Column called Color in ProjectDetailController.java

Current issue

Although we are taking color input from user and stored in the database. We are suppose to use these colors to represent each task of a project in our gantt chart. Currently, we are using some default color from here.

Expect to fix

1. We want to use that user's chosen color to represent each task on our gantt chart.
2. In ProjectDetailController page, we want to get rid of the weird code to display on our table. Instead we can show the name of the color code as documented here or just put the proper 6 digit hexa color code instead of that awkward 8 digit code (0x7b1fa2ff).

The profile page should have all the information of an admin. He can update his all information excluding username & id.

Step to Reproduce:

1. Login into the Application.
2. Click on Add new Project button.
   You will get the option to choose project's start date and end date. If a user mistakenly put the end date to any date earlier than the start date, that successfully saves the date in the database. But this is not what we want.

Expected solution

If the user sets the end date to an earlier date than start date, it should not accept the End date and show an error message to user e.g.: End date must be equal or greater than start Date.

Screenshot

Issue

Currently we have only one user level authentication. We want to make 2 level user authentication i.e. Admin and Employee.

• Two user level authentication [admin & employee]