Merge lp:~vauxoo/account-management/hbto_acc_mng_v6_fnctl_field into lp:account-management

[hbto [Vauxoo] http://www.vauxoo.com]

Added Functional field to the account.account model
so now it is possible to check which record are related
to a particular account, be it from the account.account
form view or through the panel action, whenever the
foreign key related on that account_id is always being recorded on db,

This change DOES NOT apply to property fields of
account.account due to the innate nature of those fields

[lp:~vauxoo/account-management/hbto_acc_mng_v6_fnctl_field]

396. By hbto [Vauxoo] http://www.vauxoo.com on 2012-01-05

[FIX] Fixing/Modifying use of postgres v 9.x Function CONCAT by
the string operator || so it is compatible with the pg v8.4

Unmerged revisions

396. By hbto [Vauxoo] http://www.vauxoo.com on 2012-01-05

[FIX] Fixing/Modifying use of postgres v 9.x Function CONCAT by
the string operator || so it is compatible with the pg v8.4

395. By hbto [Vauxoo] http://www.vauxoo.com on 2011-12-29

[ADD] New View for model account.account.records
[ADD] New way to compute id for sql view.

394. By hbto [Vauxoo] http://www.vauxoo.com on 2011-12-29

[ADD] Minor Changes to accomplish functional field

393. By hbto [Vauxoo] http://www.vauxoo.com on 2011-12-29

[ADD] Add new model that holds the record for a given account_id

392. By hbto [Vauxoo] http://www.vauxoo.com on 2011-12-28

[ADD] Added new functional fields to account.account
so that it can now show which record bear an account_id
related to that record

=== modified file 'account_management/model/account_company.py'
--- account_management/model/account_company.py	2011-12-08 21:45:33 +0000
+++ account_management/model/account_company.py	2012-01-05 16:25:26 +0000
@@ -24,6 +24,7 @@
 ##############################################################################
 from osv import osv
 from osv import fields
+import tools
 from tools.translate import _
 
 __AYUDA__ = '''
@@ -156,11 +157,93 @@
  el codigo contable de la misma.'
 '''
 
+def _links_get(self, cr, uid, context=None):
+    """Gets links value for reference field
+    @param self: The object pointer
+    @param cr: the current row, from the database cursor,
+    @param uid: the current user’s ID for security checks,
+    @param context: A standard dictionary for contextual values
+    """
+    obj = self.pool.get('ir.model.fields')
+    ids = obj.search(cr,uid,[('ttype','=','many2one'),('relation','=','account.account'),('model','!=','account.account')])
+    ids = list(set([i['model_id'][0] for i in obj.read(cr,uid,ids,['model_id'])]))
+    obj = self.pool.get('ir.model')
+    res = obj.read(cr, uid, ids, ['model', 'name'], context)
+    return [(r['model'], r['name']) for r in res]
+
+class account_account_records(osv.osv):
+    _name = 'account.account.records'
+    _auto = False
+    _description = 'Records by Accounts'
+    _rec_name = 'record_id'
+    _columns = {
+        'record_id':fields.reference('Record',selection=_links_get,size=128,readonly=True),
+        'model_id':fields.many2one('ir.model', 'Model',readonly=True),
+        'value_id':fields.integer('Value',readonly=True),
+        'field_id':fields.many2one('ir.model.fields', 'Field',readonly=True),
+    }
+    def _get_records(self, cr, uid=1, id=None, context=None):
+        if context is None:
+            context = {}
+        res=[]
+        
+        imf_obj = self.pool.get('ir.model.fields')
+        #~ imf_ids = imf_obj.search(cr,uid,[('ttype','=','many2one'),('relation','=','account.account'),('model','!=','account.account'),('view_load','=',False)])
+        imf_ids = imf_obj.search(cr,uid,[('ttype','=','many2one'),('relation','=','account.account'),('model','!=','account.account')])
+
+        if imf_ids:
+            for each in imf_obj.browse(cr, uid, imf_ids, context=context):
+                if not each.model_id.osv_memory:
+                    cr.execute("""SELECT attname FROM pg_attribute WHERE attrelid = (SELECT oid FROM pg_class WHERE relname = '%s') AND attname = '%s'"""%(each.model.replace('.','_'),each.name))
+                    value = cr.fetchall()
+                    if not value:
+                        continue
+
+                    res.append("""SELECT COALESCE(%s,NULL) as value_id, CASE WHEN id > 0 THEN (%s || id) END AS record_id, CASE WHEN id > 0 THEN %s END AS field_id, CASE WHEN id > 0 THEN %s END AS model_id, CASE WHEN id > 0 THEN (%s * %s + id) END AS id FROM %s"""%(each.name,"'%s,'"%each.model,each.id,each.model_id.id,each.id,each.model_id.id,each.model.replace('.','_')))
+            res = ' UNION '.join(res)
+        return res
+    
+    def init(self, cr):
+        tools.drop_view_if_exists(cr, 'account_account_records')
+        cr.execute("""
+            CREATE OR REPLACE view account_account_records AS (%s)
+        """%(self._get_records(cr, 1),))
+
+account_account_records()
+
+
 class account_account(osv.osv):
+    def _get_records(self, cr, uid, ids, fieldname, args, context=None):
+        if context is None:
+            context = {}
+        res={}
+        for id in ids:
+            cr.execute('SELECT id FROM account_account_records where value_id = %s'%(id,))
+            val = cr.fetchall()
+            if val:
+                res[id]=[i[0] for i in val]
+            else:
+                res[id]=[]
+        return res
+        
     _inherit='account.account'
     _columns={
             'auto':fields.boolean('AutoCodigo?', help=__auto_help__),
             'code': fields.char('Code', size=64, required=False),
+            #~ 'record_ids': fields.many2many('account.account.records',
+                #~ 'account_account_records',
+                #~ 'value_id',
+                #~ 'record_id',
+                #~ 'Records by account'
+            #~ ),
+            'record_ids': fields.function(
+                _get_records,
+                method=True,
+                relation= 'account.account.records',
+                type='one2many',
+                help = 'Show all the record where this account is being used',
+                string = 'Records by account'
+            ),
             }
     
     def _get_parent(self, cr, uid, code, nivel, patron_nivel, company_id):

=== modified file 'account_management/view/account_company.xml'
--- account_management/view/account_company.xml	2011-12-08 21:45:33 +0000
+++ account_management/view/account_company.xml	2012-01-05 16:25:26 +0000
@@ -49,8 +49,33 @@
                 <field name="parent_id" position="replace">
                     <field name="parent_id" select="1" attrs="{'required':[('auto','=',1)],'readonly':[('auto','=',0)]}"/>
                 </field>
-            </field>
-        </record>
+                 <xpath expr='//page[@string="Notes"]' position='before'>
+                     <page string='Records by account'>
+                             <field name='record_ids' nolabel='1' colspan='4'/>
+                     </page>
+                 </xpath>
+            </field>
+        </record>
+        
+        <record model="ir.ui.view" id="account_account_records_tree">
+            <field name="name">account.account.records.tree</field>
+            <field name="model">account.account.records</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string='Records by Account'>
+                    <field name='record_id'/>
+                    <field name='model_id'/>
+                    <field name='field_id'/>
+                </tree>
+            </field>
+        </record>
+
+        <act_window
+            domain="[('value_id', '=', active_id)]"
+            id="account_accoout_record_action"
+            name="Records by Account" 
+            res_model="account.account.records"
+            src_model="account.account"/>
 
     </data>
 </openerp>