polltery / eduscope-career-website-project Goto Github PK

Depends on issue #9

Create a function in app.js called "updateQualifications" that will update the #qualification_list div in profile.html to first fetch the relevant data from a php script (getInfo.php?type=myquals)

• display all qualifications and jobs
• display individual qualification and job details

relevant file locations:

• partials/views/profile.html
• js/app.js
• partials/functions/getInfo.php

Currently the mentor search only looks up for a list of user's matching the username.

Depends on form data from #7

Similar to user search feature.

For example if my query is : computer
The query must be passed in a similar way as it's done in mentor search.
Query would be,
SELECT name from universities WHERE name LIKE '%computer%'
SELECT name from qualifications WHERE name LIKE '%computer%'
SELECT name from subjects WHERE name LIKE '%computer%'
SELECT name from jobs WHERE name LIKE '%computer%'

Giving a result in a JSON form to the front end as,
{
"status":"1",
"universities":[{...}],
"qualifications":[{...}],
"subjects":[{...}],
"jobs":[{...}]
}

user table and login.php

1. Save their last logged in time

• Make a new script called profileActions.php
• Add all the required checks before doing the sql query depending on the context
• send the required ids as post data to the script
• perform query depending on the context
• test, commit and close this issue.

check qualificationForm.js

Date of birth is shown when the users edit their profile. After saving the changes, the user can edit their details again. When they do click on edit details, all the info is loaded into the forms, except for DOB. the DOB resets.

The issue can be fixed by looking into js/app.js and partials/views/editProfile.html and by modifying the code related to loading userDetail_DOB

Please fix this front-end issue if you can. I will look into this later as this is my low priority.

The file is 'partials/functions/addInfo.php'

There are a couple of 'TODO' left in the comment, please go through the script and see how you can contribute.

Below are the pending tasks for the field..
for the case of 'user_school_qualification':

1. Add Regex check for each field
2. Check if the subjects are not repeated and if they are not out of bounds

check addQualification.html

@Tabindah Before doing this let's Decide on how we are going to take information about university qualifications

@habibaw
The bootstrap live select search library can be found here
https://silviomoreto.github.io/bootstrap-select/examples/#live-search

1. Implement for the country selection in partials/views/* editProfile.html* use script tags for any jQuery, and style tags for any css.

A similar search page and script as seen in mentor page must be implemented.

Yashen has made Chinese pages of the website, we need an option to change language on index.html, upon doing so the index page will be rendered in Chinese.

Only few pages are in Chinese

• index.html
• contactus.html
• aboutus.html
• navbar.html

You will have to check *partials.js * to make the correct links for the Chinese pages.

check addQualification.html

In the screen shot below, the spacing below the footer must be fixed by moving the footer a bit down depending on the page height. This can be done by adding
tags but it's not recommended, as it will make the page look ugly if the page height is enough to set the footer at the bottom.

@habibaw
We have a list of subjects (aka fields), the user should be able to look up for fields and know what the field is about in the resources section.

• Check the database table called subjects
• use backend API getResouces.php?type=subjects to load all subjects in JS and render on html
• Make it dynamic, i.e. Don't load/make a new page/view for each subject, there should be one page/view that will inject the required data in the required tags.

MySQL:

• In userDetail table add a new col called description

Frontend:

• Update app.js to support description view for profile and mentors
• Update editProfile.html
• Update profile.html
• Update mentor.html

Clone the project in htdocs, run the servers and run localhost/eduscope/mysql_db_setup/db_initalize.php
This will create a database called "eduscope" which can be viewed from phpMyAdmin.
Each table has an {table-name}_id column, please mark this attribute as Primary key and auto increment. Once you do that, export the database as .sql file, and put it in mysql_db_setup folder. Then open your git in the mysql_db_setup folder and type these commands

git add db.sql

git commit -m "your message here"

git push github master 

Depends on #8

Update getInfo.php to support abstraction of qualifications, most likely, getInfo.php?type=qualifications by passing type parameter as qualifications

If the user visits eduscope/application and if they are not logged in, the user interface is still visible. Fix this to display an error page instead of the user interface. or redirect them to login page.