chen-han / watminers Goto Github PK

• Refactor frontend Angular Logics to a more organized way
• Redesign the page layout so it looks better
• UX improve: instead of manually entering jobID and ranking info, students can copy paste their ranking page on jobmine to ours, we would upload the info automatically
• More on backend logics and algorithms (see the backend issue for more detail)
• More integration with facebook or Linkedin:
  1. Students can copy paste their select time slot page on jobmine to our page; it would contain a list of people who applied the same job as him/her. We send invites to those people saying that someone wishes to share ranking info with you.
• design promotion materials on social media

The database will be divided into three tables using relational database model
RANK stores ranking and preference information for a job-student pair, this is the one we are focusing now)
fields: rankID, jobID, studentID, ranking, preference

STUDENT: stores additional information for each student, not important for now
primary key (studentID)
JOB: stores additional information for each job such as job description, not our focus now
primary key jobID //derived from JobMine

Basic DB Operations:

get job rankings: returns a list of rankings and preferences associated with each job
this operation will only be available for users who are ranked for that job,
get user rankings: get a user's rankings, available only to specific user
input rankings: accepts a list of rankings in form of (jobID, userID, ranking, preference) and insert them to database

More Advanced DB operation:

Notify users on new information with their job (e.g. someone with an offer is not taking the job, someone with offer IS taking the job, more people have entered their ranking for a job)

How do we know that a person is not lying and entering random information for jobs?

• Ask each student to copy paste their select time page on jobmine. Since it contains a list of interviewees with their names, we may check against their registered names on our system.
  But we can't use Facebook name since they may mismatch, especially for those with different legal name and preferred name. We can ask people to input their student ID and go into WatIAM to search it up. I have done some basic research, there seems to be no API for that, but we might be able to use cURL to access the search function anyways, since it's public.