Skip to content
Snippets Groups Projects

[MOD] Res Partner Perception IIBB Sit Load

Merged Reviewer Intergaláctico requested to merge 8.0-SitIIBB_Load into 8.0-stage
2 files
+ 34
21
Compare changes
  • Side-by-side
  • Inline
Files
2
@@ -89,6 +89,10 @@ class padron_mass_update(models.TransientModel):
@api.model
def _update_perception_arba(self, perception_id):
multilateral_record = self.env.ref(
'l10n_ar_perceptions.iibb_situation_multilateral')
local_record = self.env.ref(
'l10n_ar_perceptions.iibb_situation_local')
cr = self.env.cr
query = """
WITH padron AS (
@@ -121,11 +125,6 @@ class padron_mass_update(models.TransientModel):
cr.execute(query, params)
for res in cr.fetchall():
partner_id = res[0] or res[4]
multi = '2' if res[2] else '1'
q = "UPDATE res_partner SET sit_iibb=%(sit_iibb)s WHERE id=%(partner_id)s"
q_params = {'partner_id': partner_id, 'sit_iibb': multi}
self._cr.execute(q, q_params)
if res[6] == 'UPDATE': # Change the amount of percentage
q = "UPDATE res_partner_perception SET percent=%(percent)s, \
from_padron = True WHERE id=%(id)s"
@@ -137,9 +136,15 @@ class padron_mass_update(models.TransientModel):
q_params = {'percent': -1, 'id': res[3]}
self._cr.execute(q, q_params)
elif res[6] == 'CREATE': # Create the res.partner.perception
q = "INSERT INTO res_partner_perception (partner_id, percent, perception_id, from_padron) \
VALUES (%(partner_id)s, %(percent)s, %(perception_id)s, True)"
q_params = {'percent': res[1], 'partner_id': res[0], 'perception_id': perception_id}
q = "INSERT INTO res_partner_perception (partner_id, percent, perception_id, from_padron, sit_iibb) \
VALUES (%(partner_id)s, %(percent)s, %(perception_id)s, True, %(sit_iibb)s)"
q_params = {
'percent': res[1],
'partner_id': res[0],
'perception_id': perception_id,
'sit_iibb': multilateral_record.id if res[2]
else local_record.id,
}
self._cr.execute(q, q_params)
else:
e_title = _('Query Error')
Loading