Skip to Content
This question has been flagged
2 Replies
15680 Rodiniai
Portretas
Keerthi
how to print a one2many field values in qweb report in odoo12 Community

Here I want to display a one2many field values of my one2 many field subname in model student.mark.

I want to display the field values of  subjname,mark,branch_mark,max_marks of student.marks model

My model of Marklist is:-
#Model of Marklist
class StudentMarkList(models.Model):
    _name = 'student.mark'
    _rec_name = 'student_id'

    student_id = fields.Many2one('student.student',
        string = 'StudentName')
    branch = fields.Many2one('student.branch',related='student_id.branchname',
        string = 'Branch Name')
    # Setting Related field
    #age = fields.Integer(related='student_id.age',string='Age')
    '''
    total = fields.Integer(string = 'Total Mark', store = True,
        compute = '_compute_total')'''
    subname = fields.One2many('student.marks', 'marks',
        string = 'Subjectwise Marks')       
    hide_inv_button = fields.Boolean(copy = False, default = True)
    state = fields.Selection([('confirmed', 'Confirm'),
                            ('cancelled', 'Cancel')],
                            string = 'Status', readonly = True,
                            copy = False, index = True,
                            track_visibility = 'onchange')
    max_marks =fields.Float(string="max_marks",
                                     compute="_compute_totalmark",
                                     store=True)
    total_mark = fields.Float("Total Mark",
                                     compute="_compute_totalmark",
                                     store=True)
    percent_mark = fields.Float("Percentage Mark",
                                     compute="_compute_percentmark",
                                     store=True)
                                                                                                                                                                 
    #method to compute total mark
    @api.multi
    @api.depends("subname")
    def _compute_totalmark(self):
        self.total_mark=0
        self.max_marks=0
        for rec in self.subname:
            self.total_mark = self.total_mark+rec.mark
            self.max_marks+=rec.max_mark
   
    #method to compute percentage mark
    @api.multi
    @api.depends("total_mark","max_marks")
    def _compute_percentmark(self):
        for rec in self:
            if rec.max_marks>0:
                rec.percent_mark = (rec.total_mark/rec.max_marks)*100                                                             


My model of Mark is:-
#Model of Marks
class StudentMarks(models.Model):
    _name = 'student.marks'
    _rec_name = 'subjname'
   
    subjname = fields.Many2one('student.subject', string = 'Subjectname')
    mark = fields.Integer(string = 'Mark')
    branchmark =fields.Many2one('student.branch', string = "Branch")
    max_mark=fields.Integer(string="Max Marks")
    marks=fields.Many2one('student.mark',string =' ',readonly="1")
                           
    #Dynamic dropdown to display subname based on branch
    @api.onchange('branchmark')
    def _branch_onchange(self):
        res = {}
        res['domain'] = {'subjname':[('branch_id', '=', self.branchmark.id)]}
        return res
My report is:-

<?xml version="1.0" encoding="utf-8"?>
    <odoo>
     <data>
        <report
               id="action_report_marksheet"
              string="MarkSheet"
               model="student.mark"
               report_type="qweb-pdf"
               file="school.report_marksheet"
               name="school.report_marksheet"
        />
          
       <!-- Report Template -->   
       <template id="report_marksheet">
   <t t-call="web.html_container">
       <t t-foreach="docs" t-as="o">
           <t t-call="web.external_layout">
               <div class="page">
                   <h2 style="text-align:center">Marksheet </h2>
                   <p>Student name:- <span t-field="o.student_id.name"/></p>
                   <p>Date of Birth: <span t-field="o.student_id.student_dob"/></p>
                   <p>Nationality: <span t-field="o.student_id.nationality"/></p>
                   <p>Branch: <span t-field="o.student_id.branchname"/></p>
                   <p>Total Mark:<span t-esc="'%.2f'% o.total_mark"/></p>
                   <p>Percentage: <span t-esc="'%.2f'% o.percent_mark"/></p>
               </div>
           </t>
       </t>
   </t>
 </template>
</data>
<report>
Portretas
Atmesti
Portretas
Mitul Shingala
Best Answer

hello

using the <t t-foreach> you can print the One2many field data. you can take reference from sale order report also.

for eg. 

<tr t-foreach='o.subname' t-as='line'>
     <td><span t-esc="line.subjname"/></td>
     <td><span t-esc="line.mark"/></td>
     <td><span t-esc="line.branchmark"/></td>
     <td><span t-esc="line.max_mark"/></td>
     <td><span t-esc="line.marks"/></td>
</tr>
Portretas
Atmesti
Keerthi
Autorius

When it is executed it is showing as:-

student.subject(1,) 80 student.branch(1,) 100 student.subject(2,) 60 student.branch(1,) 100

instead of subject name mark of each

K.Amrita

Aswathy,

Mithual has given you correct piece of example.

I'll try to help you, example student.subject(1,) field is student_id, then you must specify like student_id.name

Mitul Shingala

at that time you have to use like <span t-esc="line.subjname.name"/>

or you also can use <span t-field="line.subjname"/>

Keerthi
Autorius

Thank You now its working ....

Keerthi
Autorius

Also how to set image field in the report

Mitul Shingala

try like below code,

<img t-if="o.student_id.photo" t-att-src="'data:image/png;base64,%s' % to_text(o.student_id.photo)" class="pull-left"/>

Keerthi
Autorius

okk Thank you..It works

Begineer

Hi,

Maybe its late but you can use "t-field" instead of "t-esc"

<td><span t-field="line.subjname"/></td>

In this case you need not access the .name it will fetch the data which lies in your field

Portretas
Sadiki Ayoub
Best Answer

the below code should work, use instead of intot-foreach balise, "Project_task_aff" is the One2many field for geting his vlaues.




 



Portretas
Atmesti