60 Commits

Author SHA1 Message Date
123a4cc840 [offers][fix] fix binance data 2022-11-07 15:40:50 +08:00
59c836c45d [offers][chore] Add logging for seed analysis 2022-11-07 11:31:58 +08:00
1dda831c54 [offers][fix] Extract seed analysis out and make it sequential 2022-11-07 11:20:27 +08:00
373480b9e1 [offers][misc] update seed script 2022-11-07 10:17:45 +08:00
ac215dcbff [portal][feat] improve country typeahead ranking 2022-11-06 09:16:34 +08:00
9c18cb28e8 [resumes][fix] add migration for locationId 2022-11-05 22:01:44 +08:00
1ebd32ca2f [resumes][feat] migrate to use location db and role enum (#506)
* [resumes][feat] use role and countries typeaheads

* [resumes][feat] add location and role typeaheads

* [resumes][chore] locationId migration

* [resumes][fix] update upsert to take in locationId

* [resumes][refactor] use typeahead for browse filters

* [resumes][feat] use role and countries typeaheads

* [resumes][chore] locationId migration

* [resumes][feat] fetch location on resumes page

* [resumes][feat] enable edit resume form

* [resumes][misc] update namings and oredrings

* [resumes][feat] add default locations

* [resumes][fix] truncate title text in resume card

* [resumes][fix] filter out selected options

* [resumes][feat] add more countries to default search

* [resumes][feat] update default roles

* [resumes][chore] revert removal of value

* [resumes]feat] add default location for migration file

* [resumes][fix] fix merge conflicts

Co-authored-by: Wu Peirong <wupeirong294@gmail.com>
2022-11-05 21:56:46 +08:00
1ae3502b9b [offers][refactor] remove redundant print statements 2022-11-05 14:38:41 +08:00
35a06c1185 [offers][fix] update tiktok salary 2022-11-05 14:25:13 +08:00
2ae41695dc [offers][fix] fix binance salary 2022-11-05 14:22:10 +08:00
f4e5d2ddb1 [portal][chore] update job titles enum 2022-11-04 19:56:40 +08:00
5e943047e2 [offers][fix] Fix bug where offers are unable to be deleted due to being referenced by analysisUnit 2022-11-04 16:48:15 +08:00
8864a47400 [offers][feat] add script to seed salaries from tech salaries excel sheet (#501)
* [offers][feat] add file to read tech salaries sheet WIP

* [offers][chore] read from correct file while seeding

* [offers][chore] Add company seed

* [offers][feat] add data seeding code to fetch from excel

* [offers[chore] Generate analysis for seeded data

* [offers][chore] Merge main into branch

* [offers][fix] Fix incorrect name

* [offers][fix] integrate random name generator to profile seeding

* [offers][chore] Set job title in seeding

* [offers][chore] Removed specialization

* [offers][chore] Add yoe ranges for seeded data

* [offers][chore] Rename level params

* [offers][chore]normalise salaries

* [offers][fix] add checks for data.income

* [offers][chore] Allow analysis to analyse all companies in the backend

* [offers][chore] Add createdAt and updatedAt to analysis

* [offers][chore] Add company name to analysis unit

* [offers][feat] Add multiple company analysis UI

* [offers][fix] Fix bug where company analysis shows wrong company

* [offers][fix] Fix company analysis percentile calculation

* [offers][fix] Fix empty analysis

* [offers][chore] Change user relation in OffersProfile from one-to-many to many-to-many

* [offers][chore] Change location in schema

* Include City, State, and Country in profileDtoMapper params

* [offers][fix] Fix merge conflict

* [offers][chore] Change backend endpoints to new location field

* [offers][feat] integrate cityId into create profile endpoint

* [offers][feat] integrate location with update profile endpoint

* [offers][fix] update seeding issue where fulltime base is not year

* [offers][fix] update seed script to integrate with city

* [offers][feat] integrate location for offer table and profile

* [offers][chore] fix import of cities typeahead

* [offers][feat] Use city typeahead for location field

* [offers][fix] fix merge conflict

* [offers][fix] fix incorrect salary normalisation

* [offers][fix] fix base salary for fulltime

* [offers][fix] fix bonus

* [offers][chore] add console log to print status while seeding

* [offers][feat] normalise sheet to incorporate slug

* [offers][feat] read companies from salary sheet

* [offers][fix] remove prisma/companySeed.ts from tsconfig.json

* [offers][refactor] standardise seed script with question

* [resume][refactor] tweak resume submission UI

* [offers][chore] Provide more information to frontend in AnalysisUnit

* [offers][fix] fix import for salaries script

* [offers][feat] add file to read tech salaries sheet WIP

* [offers][chore] read from correct file while seeding

* [offers][chore] Add company seed

* [offers][feat] add data seeding code to fetch from excel

* [offers[chore] Generate analysis for seeded data

* [offers][chore] Merge main into branch

* [offers][fix] Fix incorrect name

* [offers][fix] integrate random name generator to profile seeding

* [offers][chore] Set job title in seeding

* [offers][chore] Removed specialization

* [offers][chore] Add yoe ranges for seeded data

* [offers][chore] Rename level params

* [offers][chore]normalise salaries

* [offers][fix] add checks for data.income

* [offers][chore] Allow analysis to analyse all companies in the backend

* [offers][feat] Add multiple company analysis UI

* [offers][fix] Fix empty analysis

* [offers][chore] Change user relation in OffersProfile from one-to-many to many-to-many

* [offers][fix] Fix merge conflict

* [offers][fix] update seeding issue where fulltime base is not year

* [offers][fix] update seed script to integrate with city

* [offers][chore] Change backend endpoints to new location field

* [offers][feat] integrate location for offer table and profile

* [offers][chore] fix import of cities typeahead

* [offers][feat] Use city typeahead for location field

* [offers][fix] fix merge conflict

* [offers][fix] fix incorrect salary normalisation

* [offers][fix] fix base salary for fulltime

* [offers][fix] fix bonus

* [offers][chore] add console log to print status while seeding

* [offers][feat] normalise sheet to incorporate slug

* [offers][feat] read companies from salary sheet

* [offers][fix] remove prisma/companySeed.ts from tsconfig.json

* [offers][refactor] standardise seed script with question

* [offers][fix] fix import for salaries script

* [offers][fix] fix merge conflicts

* [offers][feat] add file to read tech salaries sheet WIP

* [offers][chore] read from correct file while seeding

* [offers][chore] Add company seed

* [offers][feat] add data seeding code to fetch from excel

* [offers[chore] Generate analysis for seeded data

* [offers][chore] Merge main into branch

* [offers][fix] Fix incorrect name

* [offers][fix] integrate random name generator to profile seeding

* [offers][chore] Set job title in seeding

* [offers][chore] Removed specialization

* [offers][chore] Add yoe ranges for seeded data

* [offers][chore] Rename level params

* [offers][fix] add checks for data.income

* [offers][chore] Allow analysis to analyse all companies in the backend

* [offers][fix] Fix merge conflict

* [offers][fix] update seed script to integrate with city

* [offers][feat] integrate location for offer table and profile

* [offers][feat] Use city typeahead for location field

* [offers][chore] add console log to print status while seeding

* [offers][feat] normalise sheet to incorporate slug

* [offers][feat] read companies from salary sheet

* [offers][fix] remove prisma/companySeed.ts from tsconfig.json

* [offers][refactor] standardise seed script with question

* [offers][fix] fix merge conflicts

Co-authored-by: Bryann Yeap Kok Keong <bryannyeapkk@gmail.com>
Co-authored-by: Ai Ling <hong-ailing@hotmail.com>
Co-authored-by: Zhang Ziqing <zhangziqing9926@gmail.com>
Co-authored-by: Yangshun Tay <tay.yang.shun@gmail.com>
2022-11-04 14:55:00 +08:00
80fd274662 [offers][chore] Add reference to analysed offer in analysis unit (#504)
Co-authored-by: Bryann Yeap Kok Keong <bryannyeapkk@gmail.com>
2022-11-04 12:32:50 +08:00
ca17ef9162 [offers][chore] Change company field in AnalysisUnit 2022-11-03 11:56:25 +08:00
c0615baf5c [offers][chore] Change location fields (#491)
* [offers][chore] Change location in schema

* Include City, State, and Country in profileDtoMapper params

* [offers][chore] Change backend endpoints to new location field

* [offers][feat] integrate cityId into create profile endpoint

* [offers][feat] integrate location with update profile endpoint

* [offers][feat] integrate location for offer table and profile

* [offers][chore] fix import of cities typeahead

* [offers][feat] Use city typeahead for location field

* [offers][fix] Fix test pages

* [offers][fix] Fix ui error

* [offers][fix] Delete test pages

Co-authored-by: Bryann Yeap Kok Keong <bryannyeapkk@gmail.com>
Co-authored-by: Stuart Long Chay Boon <chayboon@gmail.com>
Co-authored-by: Zhang Ziqing <zhangziqing9926@gmail.com>
Co-authored-by: Ai Ling <hong-ailing@hotmail.com>
2022-11-02 23:20:18 +08:00
1a34bb2825 [portal] clean up cities and states data 2022-10-31 15:47:33 +08:00
6bfa1ff61e [questions][feat] add encounters sorting (#458)
Co-authored-by: Bryann Yeap Kok Keong <bryannyeapkk@gmail.com>
Co-authored-by: Ai Ling <hong-ailing@hotmail.com>
Co-authored-by: Zhang Ziqing <zhangziqing9926@gmail.com>
Co-authored-by: Bryann Yeap Kok Keong <77266823+BryannYeap@users.noreply.github.com>
2022-10-31 12:56:45 +08:00
91696571fe [offers][feat] Add multiple company analysis 2022-10-31 11:44:12 +08:00
568b674322 [questions][fix] fix seed questions script (#467) 2022-10-31 10:47:15 +08:00
1ea1afc8a2 [questions][feat] sort answers, comments (#457)
Co-authored-by: Jeff Sieu <jeffsy00@gmail.com>
2022-10-31 02:48:56 +08:00
de94958ce1 [questions][chore] add questions seeding script (#450) 2022-10-30 19:32:23 +08:00
ed4cea1b11 [portal][feat] add locations 2022-10-30 16:52:00 +08:00
410d8712c3 [resumes][fix] add resolve resume functionality (#442)
* [resumes][fix] button getting cut off

* [resumes][feat] add resolve functionality

* [resumes][feat] replace student roles with internship

* [resumes][feat] fetch isResolved field
2022-10-27 16:08:01 +08:00
839eb31d65 [questions][fix] remove erronous migration file (#437) 2022-10-26 18:17:12 +08:00
352f8a03ad [questions][feat] add encounters transaction for crud (#409)
* [questions][chore] refactor question queries

* [questions][chore] destructure values from input

* [questions][feat] add sorting

* [question][fix] fix frontend

* [questions][feat] add sorting

* [questions][feat] add sorting index

* [questions][chore] push migration file

* [questions][fix] fix ci issues

* [questions][fix] fix import errors

* [questions][feat] add encounters transaction for crud

* [questions][chore] fix import

* [questions][chore] update error handling

* [questions][feat] parallelize queries

* [questions][fix] update to use corrcet client

* Update questions-question-encounter-router.ts

* Update questions-question-encounter-router.ts

Co-authored-by: Jeff Sieu <jeffsy00@gmail.com>
2022-10-26 15:38:28 +08:00
79b62234ea Revert "[questions][feat] add text search (#412)" (#428)
This reverts commit f70caba3f20e4d224e6e86aad9b05b66375d8aa3.
2022-10-25 10:29:01 +08:00
f70caba3f2 [questions][feat] add text search (#412) 2022-10-25 01:22:05 +08:00
7589e9b078 [questions][feat] add list crud (#393)
Co-authored-by: Jeff Sieu <jeffsy00@gmail.com>
2022-10-25 01:21:34 +08:00
f8423afe2a [offers][fix] Fix UI and remove specialization on the backend (#426)
* [offers][fix] Remove specialization on the frontend

* [offers][fix] Rename refresh OEA button

* [offers][chore] Remove specialisation and make bonus, stocks and baseSalary optional

* [offers][fix] Fix OEA profile job title

Co-authored-by: Bryann Yeap Kok Keong <bryannyeapkk@gmail.com>
2022-10-25 00:24:44 +08:00
471a28be8a [questions][feat] pagination (#410)
* [questions][feat] pagination

* [questions][feat] update aggregated data

* [questions][feat] add next cursors

* [questions][fix] fix bug

* [questions][chore] fix lint error

* [questions][chore] update cursor to support adapter

* [questions][feat] paginate browse queries

* [questions][ui] change page size to 10

* [question][refactor] clean up router code

* [questions][fix] fix type errors

* [questions][feat] add upvotes tracking

* [questions][chore] add default upovte value

Co-authored-by: Jeff Sieu <jeffsy00@gmail.com>
2022-10-24 22:56:50 +08:00
b37ce69c25 [questions][feat] update question filter (#384)
* [questions][chore] refactor question queries

* [questions][chore] destructure values from input

* [questions][feat] add sorting

* [question][fix] fix frontend

* [questions][feat] add sorting

* [questions][feat] add sorting index

* [questions][chore] push migration file

* [questions][fix] fix ci issues

* [questions][fix] fix import errors

Co-authored-by: Jeff Sieu <jeffsy00@gmail.com>
2022-10-22 14:31:29 +08:00
2c7f349043 [offers][chore] Add a relative base value to the currency model in schema 2022-10-22 07:48:07 +08:00
d10377e0f9 [resumes][feat] replying comments (#401)
* [resumes][feat] add resume comment parent

* [resumes][refactor] Abstract comment edit form and votes to their components

* [resumes][feat] Add reply form

* [resumes][feat] Render replies

* [resumes][feat] add collapsible comments

* [resumes][chore] remove comment

Co-authored-by: Terence Ho <>
2022-10-21 15:55:59 +08:00
0311ee3e6a [offers][chore] Add location to experience in the back end 2022-10-20 20:02:19 +08:00
111b078147 [offers][fix] Fix the sort and filter checks in list offers API 2022-10-20 19:40:26 +08:00
a879639b53 [offers][chore] add migration sql and change naming conventions 2022-10-19 18:47:03 +08:00
2f12a900e6 [questions][chore] update to use company table values (#351)
Co-authored-by: Jeff Sieu <jeffsy00@gmail.com>
2022-10-19 18:08:51 +08:00
bc424bee33 [offers][refactor] add types for interfaces (#390)
* [offers][chore] Create types for API responses

* [offers][fix] fix get comments bug

* [offers][fix] make offers api open to unauthenticated users

* [offers][chore] add return types to comment api

* [offers][chore] add types to get comments api

* [offers][chore] Refactor profile and analysis APIs to return defined types

* [offers][chore] Add typed response for get offers API

* [offers][chore] Changed delete offer API response

* [offers][fix] Fix type definitions for OffersCompany in types/offers

* [offers][fix] fix list some offer frontend

Co-authored-by: BryannYeap <e0543723@u.nus.edu>
Co-authored-by: Stuart Long Chay Boon <chayboon@gmail.com>
2022-10-19 14:36:38 +08:00
0edcfb7af3 [offers][fix] Fix generate analysis API by deleting analysis if exists before creating 2022-10-15 05:18:52 +08:00
c12c318a0b [offers][chore] Save the generate offer profile analysis into db 2022-10-15 05:04:38 +08:00
490d11e249 [offers][chore] Add OffersAnalysis into database 2022-10-15 03:23:44 +08:00
b7e0d8ff90 [offers][feat] Create Offer Analysis API 2022-10-14 22:15:04 +08:00
fd67a20a2b [resumes][fix] Fix bugs in comments section (#363)
* [resumes][fix] left-align all comments

* [resumes][fix] add comment owner OP tag

* [resumes][fix] render multi-line text in comments

* [resumes][feat] add see more/less for overflow comments

* [resumes][refactor] prefix comments section with Resume

* [resumes][refactor] Refactor routers from reviews -> comments

* [resumes][refactor] use Vote enum in ResumesCommentVote

* [resumes][refactor] add comment count to tabs

* [resumes][refactor] combine resume-card and resume-body into resume-list-item

Co-authored-by: Terence Ho <>
2022-10-13 11:57:45 +08:00
a47c0761d2 [offers][chore] add user to replies and return error if profile not found 2022-10-13 00:23:03 +08:00
f88e8e8409 [offers][chore] Update migration records 2022-10-11 12:22:57 +08:00
d5edb6da60 [offers][feat] Add delete OfferProfile API 2022-10-11 12:19:01 +08:00
356eeb6954 [offers][feat] Add Offers Schema, View Offer Profiles API, and Create Offer Profile API (#353)
* [offers][fix] fix merge conflicts

* [offers][chore] Create prisma schema

* [offers][feat] add create endpoint for profiles

* [offers][feature] Create list offers API with filter functionality

* [offers][fix] fix bugs create profile bugs

* [offers][fix] fix create profile bugs

* [offers][feat] Add sorting functionality to list offers

Co-authored-by: Stuart Long Chay Boon <chayboon@gmail.com>
2022-10-10 19:50:56 +08:00
85d49ad4cd [questions][feat] add nested create encounter (#339)
Co-authored-by: Jeff Sieu <jeffsy00@gmail.com>
2022-10-10 13:08:02 +08:00
e78160d654 [questions][feat] integrate backend (#347) 2022-10-10 08:17:01 +08:00