Datagrid custom columns

Hi,

I want to display some custom columns in datagrid.
I have a list of students, I want to display their score of each course in this datagrid, so the column name must be the course name and data is the score. I searched a lot but didn’t found anything.
I dont know it is possible or not.

Do anyone has an ideal?
Thanks,

Topic

[Mike KudelyaParticipant]

Hi

I think the main table will be students, just join courses and scores tables to it. For example:

YAML

datagrid: students-grid: source: type: orm query: select: - student.name as student_name - course.name as course_name - sc.score as score from: - { table: %student.class%, alias: student } join: left: - { join: student.scorecourse, alias: sc } - { join: sc.course, alias: course }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

datagrid:     students-grid:         source:             type: orm             query:                 select:                     - student.name as student_name                     - course.name as course_name                     - sc.score as score                 from:                     - { table: %student.class%, alias: student }                 join:                     left:                         - { join: student.scorecourse, alias: sc }                         - { join: sc.course, alias: course }

[thinh2010Participant]

Hi Mike,

Thank for your reply. But my datagrid will display all courses of all students with their score each course.
So that I need course name as a header column of the table.

Some thing like:

PHP

Course 1 Course 2 Course 3 Student 1 10 3 4 Student 2 9 9 9

1 2 3

Course 1           Course 2        Course 3 Student 1       10                  3               4 Student 2       9                   9               9

[Mike KudelyaParticipant]

Hi

I understood what you want to do. I had similar task. Idea is: you create a datagrid skeleton in datagrid.yml and a listener which dynamically modifies yml structure on ‘build.before’ event. Example you can see at menu ‘Reports & Segments -> Reports -> Accounts -> By Opportunities’. Here is a listener definition, note that event should start with oro_datagrid.datagrid.build.before.[name of your datagrid]. Further the listener and a datagrid skeleton.

[thinh2010Participant]

aha, that’s all I need. I will give a try. Thank u so much :D

[Author]

Replies