Student Tab

[aakashyadav-kgp]

Description

Students tabs is useful to manage students of e-samwad. Main goals are to see, download, edit. Student creation is not handled on admin console but on e-samwad app directly.

Acceptance Criteria:

1. To access the students data we have a tab on left hand menu by the name "Students". If a user clicks on it they land on the main page of students.
2. The main screen has following functionalities: Search, Data Table, Edit Entry, Filters, Download.
3. Data table should have the following columns: Student ID, Name, Father Name, School Name (UDISE), Grade Number, Stream tag, is_cwsn status, district, block, cluster gender, and is_enabled.
4. Search should be based on studentID with contains functionality. By contains we mean all entry should be shown that contains the search string anywhere in the search field.
5. Filter happens on the following fields School UDISE, School Name, District, Block, cluster, Grade, Gender, Stream, is_cwsn, and is_enabled status. Here we have to ensure that all unique values of the field are visible in the filter. Also, grade, district, block, gender, stream should be multi select. Which means multiple values are allowed in each of these filters.
6. Editing an entry happens from the edit button on each entry. On edit all field follow data validation rules. Rules are as following:
   StudentID - Non Editable
   Name - Text field with spaces but no other special character
   School Name - Non-Editable. It gets updated based on UDISE.
   School UDISE - Numeric. Once the user move the cursor out of the field we do a check if the enter UDISE is valid or not. If it's not valid we throw an error of incorrect UDISE and don't let the user save the edits. If the UDISE is valid we will update the school Name based on it.
   Father's & Mother's Name - Text field with spaces but no other special character
   Gender - Drop down with 2 options
   Grade Number - Numbers from 1 to 12
   Stream Tag - Drop down of following Non-Medical, Medical, Commerce, Arts, tenth, ninth, eighth, seventh, sixth, fifth, fourth, third, second, first.
   Category - Drop down of following GE, SC, OT, ST, OB.
   Is_cwsn: Toggle for True vs False
   Is_enabled: Toggle for True vs False
7. Download: Allows user to download the current view based on search and applied filters. With all fields of table.
8. We don't want delete button anywhere and also no show on clicking any row entry.

[Harshil-Jani]

Editing after changing UDISE throws error.

[aakashyadav-kgp]

Pending things,

1. Search doesn't have contains functionality.
2. In Filter we want multi select on grade, district, block, gender, stream.
3. Seems very slow, is there a way to make it fast?

@Shruti3004 @Harshil-Jani

[Harshil-Jani]

@aakashyadav-kgp | cc : @Shruti3004

1. If you remember from our previous discussion, Search cannot be implemented with contains on Integer fields. So, Either you can ask for a different search field (preferably name) with the constraint that it has to be String or Let the ID search field be as it is with equal .
2. Will be completed as soon as Fixing tabs #88 will be merged and deployed.
3. I think the tab consists of lots of data. 1.3 Million Entries which is much as compared to all the other tables. Also, We are dynamically getting the District, Block, Cluster which slows down the loop. Still to get complete understanding of what exactly is going wrong, It would be much more helpful to us if someone can provide us the Profiling reports of the Student Tab. Let me know if you or anyone else would like to pick this up.