Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odgovori
11926 Prikazi

I have three models in same module. I need to set those 3 models in single view. If i did using single model it is override.


This is my py file

class Quarterly_exams_schedule(models.Model):

_name = 'quarterly_exams.quarterly_exams'

#Quarterly Exams fields

quarterly_exams = fields.Integer(string="Quarterly")

quarterly_subject_1=fields.Integer(string="English",required=True, copy=False)

quarterly_subject_2=fields.Integer(string="Hindi",required=True, copy=False)

quarterly_subject_3=fields.Integer(string="Science",required=True, copy=False)

quarterly_subject_4=fields.Integer(string="Mathematics",required=True, copy=False)

quarterly_subject_5=fields.Integer(string="Social",required=True, copy=False)

quarterly_subject_6=fields.Integer(string="Sanskrit",required=True, copy=False)

# maximum_marks=fields.Selection([('100','100'),('75','75')], string="Maximum Marks")

quarterly_total_marks=fields.Integer(string="Total",readonly=True)

quarterly_total_percentage=fields.Integer(string="Percentage",readonly=True)

class Halfyearly_exams_schedule(models.Model):

_name = 'half_yearly.half_yearly'

half_yearly_exams = fields.Integer(string="Half_yearly")

half_yearly_subject_1=fields.Integer(string="English",required=True, copy=False)

half_yearly_subject_2=fields.Integer(string="Hindi",required=True, copy=False)

half_yearly_subject_3=fields.Integer(string="Science",required=True, copy=False)

half_yearly_subject_4=fields.Integer(string="Mathematics",required=True, copy=False)

half_yearly_subject_5=fields.Integer(string="Social",required=True, copy=False)

half_yearly_subject_6=fields.Integer(string="Sanskrit",required=True, copy=False)

half_yearly_total_marks=fields.Integer(string="Total",readonly=True)

half_yearly_total_percentage=fields.Integer(string="Percentage",readonly=True)

class Annually_exams_schedule(models.Model):

_name = 'annually.annually'

annually_exams = fields.Integer(string="Annually")

annually_subject_1=fields.Integer(string="English",required=True, copy=False)

annually_subject_2=fields.Integer(string="Hindi",required=True, copy=False)

annually_subject_3=fields.Integer(string="Science",required=True, copy=False)

annually_subject_4=fields.Integer(string="Mathematics",required=True, copy=False)

annually_subject_5=fields.Integer(string="Social",required=True, copy=False)

annually_subject_6=fields.Integer(string="Sanskrit",required=True, copy=False)

annually_total_marks=fields.Integer(string="Total",readonly=True)

annually_total_percentage=fields.Integer(string="Percentage",readonly=True)

This is my xml file

<record model="ir.ui.view" id="school_management_form6">

<field name="name">school_management from6</field>

<field name="model">quarterly_exams.quarterly_exams</field>

<!-- <field name="inherit_id" ref=" school_management.school_management_form6"/> -->

<field name="arch" type="xml">

<form>

<sheet>

<notebook>

<page name="school" string="Quarterly">

<header>

<button name="quarterly_clear_records" string="Reset" type="object" style="background-color:CornflowerBlue "/>

</header>

<group string="Quarterly Marks">

<group>

<field name="quarterly_subject_1" widget="char"/>

<field name="quarterly_subject_2" widget="char"/>

<field name="quarterly_subject_3" widget="char"/>

<field name="quarterly_subject_4" widget="char"/>

<field name="quarterly_subject_5" widget="char"/>

<field name="quarterly_subject_6" widget="char"/>

<field name="quarterly_total_marks"/>

</group>

<group>

<field name="quarterly_total_percentage"/>

</group>

</group>

</page>

<page name="school" string="Half Yearly">

<header>

<button name="half_yearly_clear_records" string="Reset" type="object" style="background-color:CornflowerBlue "/>

</header>

<group string="Half Yearly Marks">

<group>

<field name="half_yearly_subject_1" widget="char"/>

<field name="half_yearly_subject_2" widget="char"/>

<field name="half_yearly_subject_3" widget="char"/>

<field name="half_yearly_subject_4" widget="char"/>

<field name="half_yearly_subject_5" widget="char"/>

<field name="half_yearly_subject_6" widget="char"/>

<field name="half_yearly_total_marks"/>

</group>

<group>

<field name="half_yearly_total_percentage"/>

</group>

</group>

</page>

<page name="school" string="Annually">

<header>

<button name="annually_clear_records" string="Reset" type="object" style="background-color:CornflowerBlue "/>

</header>

<group string="Annually Marks">

<group>

<field name="annually_subject_1" widget="char"/>

<field name="annually_subject_2" widget="char"/>

<field name="annually_subject_3" widget="char"/>

<field name="annually_subject_4" widget="char"/>

<field name="annually_subject_5" widget="char"/>

<field name="annually_subject_6" widget="char"/>

<field name="annually_total_marks"/>

</group>

<group>

<field name="annually_total_percentage" />

</group>

</group>

</page>

</notebook>

</sheet>

</form>

</field>

</record>

Avatar
Opusti
Best Answer

Hi,

If you are looking to show the data's from two models in a single view, ie data of model A and data of model B has to be shown in Model C, then the better way is to create model C that is populated by a SQL View that joins the  models A and B.


See a sample which join two models into a third model,


First define the model c and its fields,



Then you can use sql query to populate the model,



Thanks


Avatar
Opusti

And is this 3rd view editable ? I think not (but haven't tried yet)