tcet-opensource / erp-backend Goto Github PK

create the following function for the Infra model:

• create
• update
• read
• remove

use user.js for reference

Create a student education history model

attributes to include can be referred in the docs link: <ink to be added>

added model with appropriate key values and conditions.
Models should be added in the model folder under the file and model name of std_edu_history

Also make object of values that share same parent
for eg:

GRADUATION BRANCH    
GRADUATION DEGREE    
GRADUATION MARK PCT    
GRADUATION PASSING YEAR 

can be put as:

{
graduation: { 
    institute: Value, 
    branch: Value, 
    ...}
}

Setup backend for ERP system

• used Express generator to laydown structure for the backend of the project
• setup database connection with moongose

Create an infra model file in models folder

added model with appropriate key values and conditions.
Models should be added in the model folder.
file name should be infra.js

Create an Accreditation model

This model will refer to Accreditation received by a department or college.

create a schema with key and value pairs with appropriate conditions.
Models should be added to the model folder.
the file name should be accreditation.js

Create an employee bank model

attributes to include can be referred in the docs link: <ink to be added>

added model with appropriate key values and conditions.
Models should be added in the model folder under the file and model name of emp_bank

make a precommit hook for eslint to check every file follows the set rule

When we hit for eg: localhost:3000/ it should respond with an error as there is no render used.
but instead, it replies with index.html
This is unexpected behavior.
remove index.html and update the index controller accordingly.

new Schema:

parent: Organization

name: str

startDate: date

accreditation: Accreditation

create the following function for the organization model:

• create
• update
• read
• remove

use user.js for reference

setup Winston logger with the following config

• log based on the environment
• daily log in different file ie setup file rotary

create the following function for the department model:

• create
• update
• read
• remove

use user.js for reference

Converting all files from cjs to mjs

Create an subject model

This model will refer to the subjects taught by teachers, under a department.

create a schema with key and value pairs with appropriate conditions.
Models should be added to the model folder.
the file name should be subject.js

Create a organization model

This model will refer to the organization.

create a schema with key and value pairs with appropriate conditions.
Models should be added to the model folder.
the file name should be organization.js

setup jest for testing

Create a Module model

This model will refer to modules under each course.

create a schema with key and value pairs with appropriate conditions.
Models should be added to the model folder.
the file name should be module.js

• add proper installation guide
• add how to setup env file
• add links to model details
• add contributors list
• add how to contribute

Create a faculty metadata model

This model will refer to the faculty metadata.

create a schema with key and value pairs with appropriate conditions.
Models should be added to the model folder.
the file name should be fac_metadata.js

create the following function for the event model:

• create
• update
• read
• remove

use user.js for reference

write testcases for all currently existing endpoints of auth module in jest

Create a faculty model

This model will refer to faculty working in college.

create a schema with key and value pairs with appropriate conditions.
Models should be added to the model folder.
the file name should be faculty.js

Make a docker file for the project

Create endpoint for

• creating user
• login
• verifying user

Also make a middleware to authenticate the request

Flow for process

• POST request for password reset
  • body contains uid and emailId
• verify the details and send otp to user on emailId
• POST request for new password
  • body contains OTP and new password

Create a student current college details model

attributes to include can be referred in the docs link: <ink to be added>

added model with appropriate key values and conditions.
Models should be added in the model folder under the file and model name of std_college

Create an employee work history model

attributes to include can be referred in the docs link: <ink to be added>

added model with appropriate key values and conditions.
Models should be added in the model folder under the file and model name of emp_work_history

create the following function for the Faculty model:

• create
• update
• read
• remove

use user.js for reference

Create a student personal model

attributes to include can be referred in the docs link: <ink to be added>

added model with appropriate key values and conditions.
Models should be added in the model folder under the file and model name of std_personal

Change file name form subject.js to course.js

update schema

Name: str

Code: str  

theoryHours: int

tutorialHours: int

practicalHours: int

totalHours: virtual  (should return sum of theoryHours, tutorialHours, practicalHours)

totalCredit: int

ISAMarks: int

ESEMarks: int

theoryMarks: virtual (should return sum of ISAMarks, ESEMarks)

tutorialMarks: int

practicalMarks: int

totalMarks: virtual  (should return sum of theoryMarks, tutorialMarks, practicalMarks) 

semester: Semester

subType: str  ENUM: [open, professional, core]                 

prerequisites: str[]

objective: str

outcomes : [{outcome: str, RBTLevel: str[]}]        # this is the modules from syllabus

modules: Module[]

practicals: Practical[]

tutorials: Tutorial[]

assignments: Assignment[]

reccTextbooks: str[]

refBooks: str[]

evalScheme: str[int]

create the following function for the course model:

• create
• update
• read
• remove

use user.js for reference

Create an employee personal model

attributes to include can be referred in the docs link: <ink to be added>

added model with appropriate key values and conditions.
Models should be added in the model folder under the file and model name of emp_curr_details

Make a prePush hook to check all testcases passes.

create the following function for the group model:

• create
• update
• read
• remove

use user.js for reference

Create an employee personal model

attributes to include can be referred in the docs link: <ink to be added>

added model with appropriate key values and conditions.
Models should be added in the model folder under the file and model name of emp_personal

Create a department model

This model will refer to the department.

create a schema with key and value pairs with appropriate conditions.
Models should be added to the model folder.
the file name should be department.js

Setting up eslint and prettier for everyone to follow airbnb js standards

Create an attendance model

This model will refer to the attendance of employees and students.

create a schema with key and value pairs with appropriate conditions.
Models should be added to the model folder.
the file name should be attendance.js

Create an employee education history model

attributes to include can be referred in the docs link:

added model with appropriate key values and conditions.
Models should be added in the model folder under the file and model name of emp_edu_history

Also, make object of values that share the same parent
for eg:

GRADUATION BRANCH    
GRADUATION DEGREE    
GRADUATION MARK PCT    
GRADUATION PASSING YEAR 

can be put as:

{
graduation: { 
    institute: Value, 
    branch: Value, 
    ...}
}```

Create a event model

This model will refer to information on events occuring in college in college.

create a schema with key and value pairs with appropriate conditions.
Models should be added to the model folder.
the file name should be event.js

Save password after hashing
currently password is saved without hashing this creates violability.

User hash and salt. Look into the Bcrypt package and implement the hashing.
This should be provided in Util.js
Function should be called before saving and comparing.

create the following function for the Modules model:

• create
• update
• read
• remove

use user.js for reference

Create a student bank details model

attributes to include can be referred in the docs link: <ink to be added>

added model with appropriate key values and conditions.
Models should be added in the model folder under the file and model name of std_bank

Currently otp store is just js object. On server reset all the otp will be lost.
If server is not restarted OTP Store will become a big object that will consume a lot of memory.

Requirement:

1. create OTPStore model
2. use It in appropriate manner

Create a group model

This model will refer multiple students together as a group, in cases such as batch.

create a schema with key and value pairs with appropriate conditions.
Models should be added to the model folder.
the file name should be group.js

create the following function for the attendance model:

• create
• update
• read
• remove

use user.js for reference

Module schema changes, change ( moduleNo ,moduleName ,moduleOutcome ,moduleContents ) to ( moduleNo ,moduleName , moduleOutcome, moduleContents )and update in CURD operation parameters

create the following function for the Accreditation model:

• create
• update
• read
• remove

use user.js for reference

currently JWT token can be achieved by third party and pretend to be the user.
bind JWT with machine by using IP or some other provision.

Create a student medical history details model

attributes to include can be referred in the docs link: <ink to be added>

added model with appropriate key values and conditions.
Models should be added in the model folder under the file and model name of std_med_history