bug-fix: assignment creation, productivity report

- finalize and correct the sql query to get the participant it
for a new assignment
- fix assignment modifier in productivity report
- work on assignment report fixing
- the reports dont work correctly but pushing to live / release anyway