* Extract functions and procedures to correct migrations

Владислав Яковлев authored 8 years ago and Роман Штейнберг committed 8 years ago

* Sync /db/stored/ & /db/migrations/stored/

Юрий Федоров authored 8 years ago and Роман Штейнберг committed 8 years ago

* Move SetRole and GetRoles to migrations
* Add RoleID to GetFullInfo output
* Fix and refactor controller of roles
* Fix model of roles
* Fix and refactor change role page
* Fix link to teacher's profile
* Add link to change role of the teacher and remove redundant checks in teacher's profile
* Fix search of students
* Fix link to student's profile

Artem Konenko authored 8 years ago and Роман Штейнберг committed 8 years ago

* Remove all redundant empty lines in functions/procedures/views migrations

Artem Konenko authored 8 years ago and Роман Штейнберг committed 8 years ago

* Add method api/v0/auth/login for getting info about user
* Add method api/v0/subject/listForStudentID for getting info about subjects in particular semester
* Add API documentation
* Add checking get params
* Add checking for user rights
* Add config for apidoc

Also, fix group splitting migration

Artem Konenko authored 8 years ago and Роман Штейнберг committed 8 years ago

* Add getDepartmentIdByName API (with auxiliary procedure)
* Add teacher insertion (only one at the time)
* Add token checking to user authorization in API handler
* Add throwing away HTTP exceptions in API handler
* Add functions for throwing HTTP exceptions (403, 404)
* Add singing in by tokens in User
* Add autocompleting department's ID by name
* Add error handling (show 400 bad request, if any require data missed)
* Add batch processing
* Add autocompleting job position ID by name

! The commit require full clean and migrate DB because of changing order of deploying.

* Eliminate redundant  role
* A little refactor in base.twig around officeTitle ifs
* Eliminate redundant db tables