abijithanikkuruthi/educollab

educollab's Issues

Put "__pycache__" from app/migration folder and "db.sqlite3" in .gitignore

Create functionalities for "Explore" page

1. SQL query to retrieve list of Fields, Topics and Subjects.

2. SQL query to retrieve count of curricula and list of curricula for that subject.

3. For each row of result in 2, retrieve:

   • curriculum name
   • description
   • no. of collaborators for that curriculum name
   • Last updated time
   • Type of bits added in that curriculum
   • Sum of no. of Likes and Comments for all the bits in the curriculum
   • count of "watched" (no. of universities implementing that curriculum)

4. Functionality for follow button.

5. Functionality for follow button for the whole subject. (Following the feed)

Mockup for Pt.1 can be found here.

Mockup for Pt. 2-5 can be found here. In this mockup, following stuff is not shown:

• A column on the left to show Subject name
• Subject photo (maybe?)
• Follow count for the subject
• Like and comment count and icons for each curriculum
• icons for each type of bit associated with the curriculum

To-Do: Feed Page

Front-end:

• Make profile image larger
• Polish text, buttons. Literally everything
• Fix feed title, description according to the type (see this issue - #51)
• Low Priority: Make "customize" an icon with pencil or something

Back-end:

• Implement suggestions backend
  - Display the top 10 of upvoted curriculums based on the subject subscriptions of the user
  - Remove the curricula already being followed by the user

Change and shift side panel link names

Change:

• Home to My Feeds
• My courses to My curricula

Move:

• My profile before logout

Bootstrap template is a bit fucked

You can't open the slide-menu (or whatever it is called) if you scroll down. It can only be opened if you are at absolute top.

To-Do: Show Bit Page

Front-end:

• Change the form to labels (Read-only stuff)
• Add/Fix Title for the page
• Polish buttons, texts...everything
• Re-layout everything

Back-end:

• Add "Edit bit" button if the user owns it
• Add Comment functionality

Front-end work dependency on Back-end:

• Prettifying "Edit bit" button
• Prettifying and laying out comments.

To-Do: Curriculum Index (My curricula) Page

Front-end:

• Fix/Add Title for the page
• Polish texts, button and the table
• Re-layout everything

Back-end:

• Send list of curricula made by the user
• Send list of curricula subscribed by the user

Front-end work dependency on Back-end:

• Make collapsible list for user made curricula and subscribed curricula

Writing Content for Landing page

Context - #16

We need to write content explaining our project, its features and how it works.
Possibly something about validation in the future. (video testimonials?)

Create frontend for "Create New Curriculum"

Mockup for "Create New Curriculum" can be found here.

Display File Uploads in Bit Show and Bit Edit

Currently we do not display files on the curriculm page etc. - might need to fix that @abijithanikkuruthi - Currently do not have an idea what is the best way to link files etc.

Back-end:

• Show uploaded file on bit show
• Show uploaded file on bit edit

Front-end dependency on Back-end:

• Prettify uploaded files with icon or whatever

Create Fancy Login and Signup Page

Maybe a bigger logo of EduCollab. above both of the forms?

Inspiration for Login - https://codepen.io/search/pens?q=login
Inspiration for Signup - https://codepen.io/search/pens?q=signup

To-Do: Home Page

• Fix the Nav header. The background disappears when you scroll. (it got fucked somehow)
• Need Placeholder text before Wednesday for mockup

Very Minimal Background Images

Maybe we can put minimal background images/vectors for each page. Right now everything is white. The image/vector would be in background of every element on the page.

When I say image, I don't mean a background image which would span the whole background.

To-Do: Explore Subject Page

Front-end:

• Remove search bar and button
• Polish and re-layout everything
• Better list structure for the curriculua
  - Low priority: Maybe also have a button saying "subscribe" right there only. It will be informative to know which curriculua user had already subscribed to even when the user is searching.
• Link curriculum to their respective pages
• Put subject details in a prettier way

Back-end:

• Sort curricula for a subject by total counts of upvotes

Delete bit button

Back-end:

• Add functionality for the button

Front-end dependency on the backend:

• Prettify the button

Create functionalities for "My Feeds" page

1. SQL queries to fetch all the feeds associated with all the curricula and subjects followed by the user. Many feeds will match therefore distinct feeds will have to be taken.

2. For every feed in 1, if the feed is for new curriculum, retrieve:

   • User's name who made the curriculum
   • User's post/designation
   • User's university
   • Time at which the curriculum was created
   • Curriculum Name
   • Curriculum Subject
   • Description of the Curriculum
   • Type of bits added by the user
   • Sum of likes and comments for all the bits

3. For every feed in 1, if the feed is for update in curriculum, retrieve:

   • User's name who updated the curriculum
   • User's post/designation
   • User's university
   • Time at which the curriculum was updated
   • Curriculum Name
   • Curriculum Subject
   • Type of bits added by the user
   • Sum of likes and comments for that bit

4. SQL queries to fetch profile data:

   • User's avatar (dafault or added)
   • Name
   • Designation/Post
   • University
   • Email

5. SQL queries to fetch "most watched" curricula for "suggested" box. For each curriculum, fetch:

   • curriculum name
   • subject
   • no of "watched" (universities implementing the curriculum)
   • no of "following" (count of people following the curriculum)

Mockup for the frontend can be found here.

To-Do: Edit Bit Page

Front-end:

• Add/Fix Title for the page
• Polish buttons, texts...everything
• Re-layout everything

Back-end:

• Check why bit information is being shown in brackets with comma when a file is added (basically as a tuple)

Relaxed To-Do: Home Page and Hamburger Menu

This involves changing or fixing whatever graphics we want on the home page/landing page.

This already have sections for:

• About us
• Project details

I feel we can divide the landing page into following sub-parts:

• About EduCollab.
• Features of EduCollab.
• Explaining how it works in graphics (pictures from pitch google slide can be taken)
• Maybe a section about how we carried out Validation (Video?)
• End section with contact us and creators name.

Bootstrap templates for inspiration: https://colorlib.com/wp/templates/

• Add/Remove the links in the Hamburger Menu if sections changed as above^

Navigation Path

Missing a navigation path (back buttons on all forms to higher level views etc.)

Remove "default" from subject field in Teach Model after sqlflush

Something I couldn't do because of existing database but I believe it could be done on db on master branch.

To-Do: Edit Curriculum Page

Front-end:

• Add/Fix Title for the page
• Show a list of bits associated with the curriculum
• Show a placeholder texts if there are no bits for that curriculum
• "Add bit" button needed
• Polish buttons, texts...everything
• Re-layout everything

Back-end:

• Send a list of bits for the particular curriculum.

templates/curriculum/show

Make Nav-bar to exit smoothly and after you scroll atleast 2cm (idk in pixels)

Currently, when you scroll, the nav bar hides quickly with a jolt. Doesn't look good.

It would be nice if the transition was a bit smoother and was done after scrolling a bit more.

Create functionalities for "Create New Curriculum" page on the backend.

Could you upload the link for the screenshot (form kinda thingy) here? @abijithanikkuruthi

But for meanwhile, I assume:

1. Curriculum Name
2. Description (in 2 lines)
3. List to select field
4. List to select topic
5. List to select subject
6. List to select what kind of bit needs to be uploaded (doc, material, video etc.) with upload bit button on the side.
7. Text box to add name of the bit and maybe a small description.
8. Button for "Adding one more bit" which would copy the bootstrap elements for 6th and 7th.

Show the list of contributers (or subscribers?)

Show a row of round images of contributors (or subscribers?) at the bottom (or left?) of every curriculum page.

• Show total contributors.
• Image should show the name of the user when hovered upon.

Making a new model for contributors won't take that much time tbh.

• Just need to check if user is already in contributor table when he/she creates/updates curriculum/bit.
• If not, add it. If yes, don't do anything.

Back-end:

• Send details of subscribers
• Make model for contributors
• Add contributors when curriculum is created or bits are created/updated
• Add contributors maybe after they comment?
• Send details of contributors to show curriculum page
• Show contributors at for each curriculum at subject page too

Front-end:

• Make separate box or something for subscribers
• Make separate box or something for contributors
• Add image for both subscribers and contributors. Image should show the name of the user when hovered upon. Ofcourse, clicking on them should take to user's profile

Create/Update frontend for the landing page

This involves changing or fixing whatever graphics we want on the home page/landing page.

This already have sections for:

1. About us
2. Project details

I feel we can divide the landing page into following sub-parts:

1. About EduCollab.
2. Features of EduCollab.
3. Explaining how it works in graphics (pictures from pitch google slide can be taken)
4. End section with contact us and creators name.

Bootstrap templates for inspiration: https://colorlib.com/wp/templates/

To-Do: Explore Index Page

Front-end:

• Fix margins for title (and everything else)
• Nice layout for Fields boxes
  - Low Priority: Make field squares with 40-50% transparent image in background with text.
  - Upon hover, the image should become more transparent or should get a tint and text should be more visible
  - Boxes could look something like this.

Back-end:

• Send no. of curriculum for each subject

Create frontend for "Explore"

Mockup for selecting subject can be found here.

Mockup for list of curricula can be found here. In this mockup, following stuff is not shown:

• A column on the left to show Subject name
• Subject photo (maybe?)
• Follow count for the subject
• Like and comment count and icons for each curriculum
• icons for each type of bit associated with the curriculum

Relaxed Discussion: Text and Description for feeds

• Determine if the operation is create or update (or anything else)
• Are the below changes applied?

We need to discuss on title and description for the feeds for following types:

1. Curriculum Created:

   • Title - Add final choice here
   • Description - Add final choice here

2. Curriculum Updated:

   • Title - Add final choice here
   • Description - Add final choice here

3. Curriculum Subscribed:

   • Title - Add final choice here
   • Description - Add final choice here

4. Curriculum Unsubscribed:

   • Title - Add final choice here
   • Description - Add final choice here

5. Curriculum Teach:

   • Title - Add final choice here
   • Description - Add final choice here

6. Curriculum UnTeach:

   • Title - Add final choice here
   • Description - Add final choice here

7. Subject Subscribed:

   • Title - Add final choice here
   • Description - Add final choice here

8. Subject Unsubscribed:

   • Title - Add final choice here
   • Description - Add final choice here

9. Bit Created:

   • Title - Add final choice here
   • Description - Add final choice here

10. Bit Updated:

    • Title - Add final choice here
    • Description - Add final choice here

Please add if I missed any.

To-Do: Curriculum Show Page

Back-end:

• send details of bits associated with that curriculum
• send if user owns the curriculum
• Comment functionality for curriculum page

Front-end work dependency on Back-end:

• Show a list of bits
• Edit curriculum button if you own the curriculum
• Add comments

Front-end:

• Polish the buttons and texts
• Re-layout everything
• Requires add bit button for any user

How should a page for each curriculum look like?

It seems we have forgot to discuss how a curriculum page should look like after it is made. We need to create a mockup for the same.

Create frontend for "My Feeds"

The mockup can be found here

Also, please checkout the backend issue here to get more context about the "suggested curricula" box.

Store "Full Name", "Designation", "Institution" in Member table

Currently, we are not saving any of them in the member table. Pls check.

Create frontend for "My Curricula"

Mockup for "My curricula" can be found here.

This mockup will follow the same theme as the other pages. In addition, I have not added:

• Like and Comment icon
• icons for the bits associated

Create functionatlities for "My profile" page

1. SQL queries to retrieve user data:

   • Avatar (default or image)
   • Name
   • His/her designation or post
   • University
   • Email

2. SQL queries to retrieve feeds for that user. Check this issue for more details on what should be on the feed.

3. SQL queries to retrieve list of curricula associated with that user for the box. For each curriculum, retrieve:

   • Curriculum name
   • Curriculum subject
   • "watched" count (no. of universities implementing the curriculum)
   • "following" count (no. of people following the curriculum)

Mockup for "My Profile" page can be found here.

Create frontend for "My Profile"

Mockup for "My Profile" page can be found here.

Create functionalities for "My Curricula" page

1. SQL queries to get profile data for the user to display on the page later.

   • avatar (default or image)
   • Name
   • Designation/Post
   • University
   • Email

2. SQL queries to get a list of curricula the user is associated with

3. SQL queries to get the following information for each row of result from 2:

   • name of the curriculum
   • subject for that curriculum
   • no. of collaborators for that curriculum
   • last updated on
   • "watched" count for no. of universities implementing the curriculum
   • Sum of likes/comments for all the bits associated with that curriculum
   • Maybe a list of type of bits associated with this curriculum

Mockup for "My curricula" can be found here.

This mockup will follow the same theme as the other pages. In addition, I have not added:

• Like and Comment icon
• icons for the bits associated

To-Do: New Bit Page

Front-end:

• Add/Fix Title for the page
• Polish buttons, texts...everything
• Re-layout everything

Back-end:

• Important: Make functionality of uploading files.

To-Do: New Curriculum Page

Front-end:

• Add/Fix Title for the page
• Better filtering of field, subject and topic
• Polish buttons, texts...everything
• Re-layout everything

Show list (or something) of universities teaching the curriculum

Show the count list (or something) of universities teaching the curriculum on every curriculum page. Would be a nice addition.

Back-end:

• Send the list of universities "teaching" the curriculum.

Front-end:

• Beautify list in left/right corner

To-Do: My Profile Page

Front-end:

• User details has to be polished
• Fix feed title, description according to the type (see this issue - )
• Add edit profile button if the profile is of user
• Add/Fix Title for the page
• Polish buttons, texts...everything
• Re-layout everything