Skip to Content
Dette spørgsmål er blevet anmeldt
2 Besvarelser
15673 Visninger
Avatar
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>
Avatar
Kassér
Avatar
Mitul Shingala
Bedste svar

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>
Avatar
Kassér
Keerthi
Forfatter

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
Forfatter

Thank You now its working ....

Keerthi
Forfatter

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
Forfatter

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

Avatar
Sadiki Ayoub
Bedste svar

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




 



Avatar
Kassér