تخطي للذهاب إلى المحتوى
لقد تم الإبلاغ عن هذا السؤال
2 الردود
15691 أدوات العرض
الصورة الرمزية
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>
الصورة الرمزية
إهمال
الصورة الرمزية
Mitul Shingala
أفضل إجابة

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>
الصورة الرمزية
إهمال
Keerthi
الكاتب

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
الكاتب

Thank You now its working ....

Keerthi
الكاتب

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
الكاتب

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

الصورة الرمزية
Sadiki Ayoub
أفضل إجابة

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




 



الصورة الرمزية
إهمال