Mentor details

[edmondpr]

Design: https://www.figma.com/file/DgrKZX9mS13Zgf7k5pZ1WT/Partner-web-app?type=design&node-id=727-148&t=LPfyjEb31x9adSCp-4

When clicking on the details icon for a mentor in the mentors table, the list of courses conducted by that mentor will be retrieved, with the following details for each course:

• start date and duration of the course
• the number of hours corresponding to the lessons completed so far (or within the date range specified for the mentors table). We'll consider 1h per lesson by default.
• the project associated with that course (if any)
• the list of students enrolled in the course, with the student's full name, organization name and testimonial links + dates.

If a project that has no association with a course was added for that mentor, the ID and name of that project will be retrieved as well.

The details will be made available at the /api/v1/partners/{partner_id}/mentors/{mentor_id} endpoint.

[ugudlado]

@edmondpr

the project associated with that course (if any)

There is no direct relation between project and course. We can get project via mentors but Mentor - Project is many-many relation. Is there any other way or table to check if there is any project associated with a course?

the number of hours corresponding to the lessons completed so far (or within the date range specified for the mentors table)

I tried to check in the code to get this but couldn't find any reference of hours related to completed lessons.
Please help in providing direction to get this number. Which tables should be referred here?

[edmondpr]

the project associated with that course (if any)

There is no direct relation between project and course. We can get project via mentors but Mentor - Project is many-many relation. Is there any other way or table to check if there is any project associated with a course?

You're right, thanks for pointing that out. The table should actually be projects_courses instead of projects_mentors, I have updated it now.

the number of hours corresponding to the lessons completed so far (or within the date range specified for the mentors table)

I tried to check in the code to get this but couldn't find any reference of hours related to completed lessons. Please help in providing direction to get this number. Which tables should be referred here?

We'll consider 1h per lesson for now, I'll update the task accordingly.

[ugudlado]

From Edmond:
The tables prefixed with user_lessons_ are actually obsolete, we are only using the ones prefixed with users_courses_. In order to get the completed lessons, we are just considering one lesson per week after the course start date and counting until the current date.

We are only using the information from the users_courses (the start_date_time value) and users_courses_lessons_canceled tables to get the number of lessons completed.

[ManojBahuguna]

@edmondpr, could you please clarify how we are storing relations between testimonials and course?
or is students_testimonials independent of course for mwb in general?

[edmondpr]

We are indeed keeping the students testimonials independent from the courses in our DB.

[ManojBahuguna]

Should we show testimonials here in that case? It will show same testimonials multiple times if student is in multiple courses. Maybe the Students page is fine for that? We can add a link to student details page.

[edmondpr]

Most students enroll in a single course but it's still ok if the same student's testimonial appears in the details of multiple mentors because the students often acknowledge all their mentors in these testimonials.