Skip to Content
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
All Posts คน เหรียญรางวัล
แท็ก (View all)
odoo accounting v14 pos v15
เกี่ยวกับฟอรั่มนี้
คำถามนี้ถูกตั้งค่าสถานะ
2 ตอบกลับ
15676 มุมมอง
อวตาร
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.




 



อวตาร
ละทิ้ง