Mémento technique OpenERP en français

$ sudo apt-get install bzr                                       # Installer Bazaar (version control software)
$ bzr cat -d lp:~openerp-dev/openerp-tools/trunk setup.sh | sh   # Récupérer l'Installeur
$ make init-v70                                                  # Installer OpenERP 7.0
$ make server                                                    # Démarrer OpenERP Server avec l'interface Web

addons/
 |- idea/                # Le répertoire du module
   |- demo/              # Données de démonstration et tests unitaires
   |- i18n/              # Fichiers de traduction
   |- report/            # Rapports
   |- security/          # Déclaration des groupes et droits d'accès
   |- view/              # Vues (formulaires,listes), menus et actions
   |- wizard/            # Assistants
   |- workflow/          # Flux de travail
   |- __init__.py        # Fichier d'initialisation Python (requis)
   |- __openerp__.py     # Déclaration du module (requis)
   |- idea.py            # Classes Python, les objets du module

# Importe tous les fichiers et dossiers qui contiennent du code Python
import idea, wizard, report

{
   'name' : 'Idea',
   'version' : '1.0',
   'author' : 'OpenERP',
   'description' : 'Ideas management module',
   'category': 'Enterprise Innovation',
   'website': 'http://www.openerp.com',
   'depends' : ['base'], # liste des dépendances conditionnant l'ordre de démarrage
   'data' : [ # les fichiers de données à charger lors de l'installation du module
          'security/groups.xml', # toujours charger les groupes en premier!
          'security/ir.model.access.csv', # charger les droits d'accès après les groupes
          'workflow/workflow.xml',
          'view/views.xml',
          'wizard/wizard.xml',
          'report/report.xml',
             ],
   'demo': ['demo/demo.xml'], # données de démo (pour les tests unitaires)
}

from osv import osv, fields
class idea(osv.Model):
    _name = 'idea.idea'
    _columns = {
      'name': fields.char('Title', size=64, required=True, translate=True),
      'state': fields.selection([('draft','Draft'),
              ('confirmed','Confirmed')],'State',required=True,readonly=True),
      # Description est en lecture seule quand elle n est pas en brouillon!
      'description': fields.text('Description', readonly=True,
              states={'draft': [('readonly', False)]} ),
      'active': fields.boolean('Active'),
      'invent_date': fields.date('Invent date'),
      # par convention, les champs many2one se terminent par '_id'
      'inventor_id': fields.many2one('res.partner','Inventor'),
      'inventor_country_id': fields.related('inventor_id','country',
             readonly=True, type='many2one',
             relation='res.country', string='Country'),
     # par convention, les champs *2many se terminent par '_ids'
     'vote_ids': fields.one2many('idea.vote','idea_id','Votes'),
     'sponsor_ids': fields.many2many('res.partner','idea_sponsor_rel',
     'idea_id','sponsor_id','Sponsors'),
     'score': fields.float('Score',digits=(2,1)),
     'category_id' = fields.many2one('idea.category', 'Category'),
    }
_defaults = {
    'active': True, # les idées sont actives par défaut
    'state': 'draft', # les idées sont à l'état de brouillon par défaut
}
def _check_name(self,cr,uid,ids):
    for idea in self.browse(cr, uid, ids):
        if 'spam' in idea.name: return False # On ne peut pas créer une idée avec spam!
    return True
_sql_constraints = [('name_uniq','unique(name)', 'Ideas must be unique!')]
_constraints = [(_check_name, 'Please avoid spam in ideas !', ['name'])]

class idea2(osv.Model):
    _inherit = 'idea.idea'
    def _score_calc(self,cr,uid,ids,field,arg,context=None):
    res = {}
    # Cette boucle génère seulement deux requêtes grâce à browse()!
    for idea in self.browse(cr,uid,ids,context=context):
        sum_vote = sum([v.vote for v in idea.vote_ids])
        avg_vote = sum_vote/len(idea.vote_ids)
        res[idea.id] = avg_vote
        return res
    _columns = {
      # Remplace le score statique avec une moyenne des scores
      'score':fields.function(_score_calc,type='float')
    }

<?xml version="1.0" encoding="utf-8"?>
<openerp>
    <data>
        <record model="object_model_name" id="object_xml_id">
            <field name="field1">value1</field>
            <field name="field2">value2</field>
        </record>

        <record model="object_model_name2" id="object_xml_id2">
            <field name="field1" ref="module.object_xml_id"/>
            <field name="field2" eval="ref('module.object_xml_id')"/>
        </record>
    </data>
</openerp>

"id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink"
"access_idea_idea","idea.idea","model_idea_idea","base.group_user",1,0,0,0
"access_idea_vote","idea.vote","model_idea_vote","base.group_user",1,0,0,0

<form string="Idea form">
    <group col="6" colspan="4">
        <group colspan="5" col="6">
            <field name="name" colspan="6"/>
            <field name="inventor_id"/>
            <field name="inventor_country_id" />
            <field name="score"/>
        </group>
        <group colspan="1" col="2">
            <field name="active"/><field name="invent_date"/>
        </group>
    </group>
    <notebook colspan="4">
        <page string="General">
            <separator string="Description"/>
            <field colspan="4" name="description" nolabel="1"/>
        </page>
        <page string="Votes">
            <field colspan="4" name="vote_ids" nolabel="1">
                <tree>
                    <field name="partner_id"/>
                    <field name="vote"/>
                </tree>
            </field>
        </page>
        <page string="Sponsors">
            <field colspan="4" name="sponsor_ids" nolabel="1"/>
        </page>
    </notebook>
    <field name="state"/>
    <button name="do_confirm" string="Confirm" type="object"/>
</form>

<tree string="Idea Categories" toolbar="1" colors="blue:state==draft">
    <field name="name"/>
    <field name="state"/>
</tree>

<calendar string="Ideas" date_start="invent_date" color="inventor_id">
    <field name="name"/>
</calendar>

<gantt string="Ideas" date_start="invent_date" color="inventor_id">
    <level object="idea.idea" link="id" domain="[]">
        <field name="inventor_id"/>
    </level>
</gantt>

<graph string="Total idea score by Inventor" type="bar">
    <field name="inventor_id" />
    <field name="score" operator="+"/>
</graph>

<search string="Search Ideas">
    <group col="6" colspan="4">
        <filter string="My Ideas"
            domain="[('inventor_id','=',uid)]"
            help="My own ideas"/>
        <field name="name"/>
        <field name="description"/>
        <field name="inventor_id"/>
        <!-- le champ de contexte suivant est juste pour illustration  -->
        <field name="inventor_country_id" widget="selection"
           context="{'inventor_country': self}"/>
    </group>
</search>

<!-- amélioration de la liste des catégories d'idée -->
<record id="idea_category_list2" model="ir.ui.view">
    <field name="name">id.category.list2</field>
    <field name="model">ir.ui.view</field>
    <field name="inherit_id" ref="id_category_list"/>
    <field name="arch" type="xml">
        <xpath expr="/tree/field[@name='description']" position="after">
            <field name="idea_ids" string="Number of ideas"/>
        </xpath>
    </field>
</record>

<!-- Ce qui suit crée un enregistrement dans le modèle ir.actions.report.xml -->
<report id="idea_report" string="Print Ideas" model="idea.idea"
        name="idea.report" rml="idea/report/idea.rml" >
<!-- Utilisez addons/base_report_designer/wizard/tiny_sxw2rml/tiny_sxw2rml.py  pour générer le modèle  RML depuis un modèle .sxw -->

<story>
    <blockTable style="Table">
        <tr>
            <td><para style="Title">Idea name</para> </td>
            <td><para style="Title">Score</para> </td>
        </tr>
        <tr>
            <td><para>[[ repeatIn(objects,'o','tr') ]] [[ o.name ]]</para></td>
            <td><para>[[ o.score ]]</para></td>
       </tr>
    </blockTable>
</story>

<record id="wkf_idea" model="workflow">
    <field name="name">idea.basic</field>
    <field name="osv">idea.idea</field>
    <field name="on_create" eval="1"/>
</record>

<record id="act_confirmed" model="workflow.activity">
    <field name="name">confirmed</field>
    <field name="wkf_id" ref="wkf_idea"/>
    <field name="kind">function</field>
    <field name="action">action_confirmed()</field>
</record>

<record id="trans_idea_draft_confirmed" model="workflow.transition">
    <field name="act_from" ref="act_draft"/>
    <field name="act_to" ref="act_confirmed"/>
    <field name="signal">button_confirm</field>
    <field name="role_id" ref="idea_manager"/>
    <field name="condition">1 == 1</field>
</record>

"id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink"
"access_idea_idea","idea.idea","model_idea_idea","base.group_user",1,1,1,0
"access_idea_vote","idea.vote","model_idea_vote","base.group_user",1,1,1,0

from osv import fields,osv
import datetime
class cleanup_wizard(osv.TransientModel):
    _name = 'idea.cleanup.wizard'
    _columns = {
        'idea_age': fields.integer('Age (in days)'),
    }
    def cleanup(self,cr,uid,ids,context=None):
        idea_obj = self.pool.get('idea.idea')
        for wiz in self.browse(cr,uid,ids):
            if wiz.idea_age <= 3:
                 raise osv.except_osv('UserError','Please select a larger age')
            limit = datetime.date.today()-datetime.timedelta(days=wiz.idea_age)
            ids_to_del = idea_obj.search(cr,uid, [('create_date', '<' ,
                limit.strftime('%Y-%m-%d 00:00:00'))],context=context)
            idea_obj.unlink(cr,uid,ids_to_del)
        return {}

<record id="wizard_idea_cleanup" model="ir.ui.view">
    <field name="name">idea.cleanup.wizard.form</field>
    <field name="model">idea.cleanup.wizard</field>
    <field name="type">form</field>
    <field name="arch" type="xml">
        <form string="Idea Cleanup Wizard">
            <label colspan="4" string="Select the age of ideas to cleanup"/>
            <field name="idea_age" string="Age (days)"/>
            <group colspan="4">
                <button string="Cancel" special="cancel"/>
                <button string="Cleanup" name="cleanup" type="object"/>
            </group>
        </form>
    </field>
</record>

<record id="action_idea_cleanup_wizard" model="ir.actions.act_window">
    <field name="name">Cleanup</field>
    <field name="type">ir.actions.act_window</field>
    <field name="res_model">idea.cleanup.wizard</field>
    <field name="view_type">form</field>
    <field name="view_mode">form</field>
    <field name="target">new</field>
</record>