콘텐츠로 건너뛰기
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
모든 게시물 사용자 배지
태그 (모두 보기)
odoo accounting v14 pos v15
게시판 정보
신고된 질문입니다
2 답글
15681 화면
아바타
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.




 



아바타
취소