1.Work Absence
-If there are employee who doesn’t scan finger print at all on that date it will count as 1 day absence,
1 day absence mean employee doesn’t get paid on that specific day so the calculation will be like this
result = (contract.wage / 30) * days employee missed

start_dt = datetime.datetime.combine(fields.Date.from_string(payslip.date_from), datetime.datetime.min.time())
end_dt = datetime.datetime.combine(fields.Date.from_string(payslip.date_to), datetime.datetime.max.time())

start_dt_str = fields.Datetime.to_string(start_dt)
end_dt_str = fields.Datetime.to_string(end_dt)

resource_calendar_id = employee._get_resource_calendar()
attendance_ids = employee.attendance_ids.filtered(lambda att: att.check_in >= start_dt_str and att.check_out <= end_dt_str)

missed_days = 0
for dt in dateutil.rrule.rrule(dateutil.rrule.DAILY, dtstart=start_dt, until=end_dt):
    if not resource_calendar_id._is_work_day(dt.date(), resource_calendar_id.id):
        continue

    if not attendance_ids.filtered(lambda att: fields.Date.from_string(att.check_in) == dt.date() and fields.Date.from_string(att.check_out) == dt.date()):
        missed_days +=1

result = (contract.wage / 30) * missed_days

2.Late Absence (10 min Quota, 10 Times in a month)
-If an employees who come to late more than 10 minute , for than 10 times, employee will count as 1 Day absence, to calculate day of absence are
result = (contract.wage / 30) * lateabsence(10minconsecutive)

start_dt = datetime.datetime.combine(fields.Date.from_string(payslip.date_from), datetime.datetime.min.time())
end_dt = datetime.datetime.combine(fields.Date.from_string(payslip.date_to), datetime.datetime.max.time())

start_dt_str = fields.Datetime.to_string(start_dt)
end_dt_str = fields.Datetime.to_string(end_dt)

resource_calendar_id = employee._get_resource_calendar()
attendance_ids = employee.attendance_ids.filtered(lambda att: att.check_in >= start_dt_str and att.check_out <= end_dt_str)

lates_count = 0
for dt in dateutil.rrule.rrule(dateutil.rrule.DAILY, dtstart=start_dt, until=end_dt):
    employee_att_ids = attendance_ids.filtered(lambda att: fields.Date.from_string(att.check_in) == dt.date())
    if employee_att_ids:
        emp_check_in = fields.Datetime.from_string(employee_att_ids[0].check_in)
        calendar_att_ids = resource_calendar_id._get_day_attendances(dt.date(), dt.min.time(), dt.max.time())
        if calendar_att_ids:
            hour, minute = divmod(calendar_att_ids[0].hour_from * 60.0, 60)
            calendar_start_dt = dt.replace(hour=int(hour), minute=int(minute))
            if (emp_check_in - calendar_start_dt).seconds / 60 > 10.0:
                lates_count += 1

result = (contract.wage / 30) * (lates_count // 11)

3.Late Absence (4 Hours Monthly Quota)
-If an employees came late to work late in 4 hours of total, employee will count as 1 Day absence, to calculate day of absence are
result = (contract.wage / 30) * lateabsence(4hoursquota)

start_dt = datetime.datetime.combine(fields.Date.from_string(payslip.date_from), datetime.datetime.min.time())
end_dt = datetime.datetime.combine(fields.Date.from_string(payslip.date_to), datetime.datetime.max.time())

start_dt_str = fields.Datetime.to_string(start_dt)
end_dt_str = fields.Datetime.to_string(end_dt)

resource_calendar_id = employee._get_resource_calendar()
attendance_ids = employee.attendance_ids.filtered(lambda att: att.check_in >= start_dt_str and att.check_out <= end_dt_str)

cumm_lates_minutes= 0.0
for dt in dateutil.rrule.rrule(dateutil.rrule.DAILY, dtstart=start_dt, until=end_dt):
    employee_att_ids = attendance_ids.filtered(lambda att: fields.Date.from_string(att.check_in) == dt.date())
    if employee_att_ids:
        emp_check_in = fields.Datetime.from_string(employee_att_ids[0].check_in)
        calendar_att_ids = resource_calendar_id._get_day_attendances(dt.date(), dt.min.time(), dt.max.time())
        if calendar_att_ids:
            hour, minute = divmod(calendar_att_ids[0].hour_from * 60.0, 60)
            calendar_start_dt = dt.replace(hour=int(hour), minute=int(minute))
            late_minutes = (emp_check_in - calendar_start_dt).seconds / 60
            cumm_lates_minutes += late_minutes
        
late_hours = cumm_lates_minutes // 60
result = (contract.wage / 30) * (late_hours // 4)

4.OT on Normal Days
If an employee work on normal (Monday-Saturaday) But, the employee continue to work after 17:00 / checkin after 17:00 he or she will receive
result = ((contract.wage / 30) / 8 )*1.5
(1.5 TIMES HOURLY RATE)
5.OT on Holidays
If an employee work on Holiday like sunday and including in days in GLOBAL LEAVES he or she will receive
result = ((contract.wage / 30) / 8 )*2
(TWO TIMES HOURLY RATE)

# cost per hour
hour_cost = ((contract.wage / 30) / 8 )

# start calculating overtime cost
result = 0.0
if payslip.hr_overtime_line_ids:
    for line in payslip.hr_overtime_line_ids:
        if line.work_day_type_id and line.work_day_type_id.is_holiday:
            result += hour_cost * line.worked_hours * line.work_day_type_id.rate / 100.0
        else:
            result += hour_cost * line.worked_hours * line.rate / 100.0

NOTE: the above code requires the following modules to work properly:
https://www.odoo.com/apps/modules/11.0/to_hr_payroll_attendance/
https://apps.odoo.com/apps/modules/11.0/to_hr_overtime_payroll/

I am working on a custom module for Odoo 9 that interacts HR contract (model hr.contract).
My situation is that I want raise onchange event on employee_id field but the onchange method was originally written in old API with the combination of a Python method and XML definition as below:

    def onchange_employee_id(self, cr, uid, ids, employee_id, context=None):
        if not employee_id:
            return {'value': {'job_id': False, 'department_id': False}}
        emp_obj = self.pool.get('hr.employee').browse(cr, uid, employee_id, context=context)
        job_id = dept_id = False
        if emp_obj.job_id:
            job_id = emp_obj.job_id.id
        if emp_obj.department_id:
            dept_id = emp_obj.department_id.id
        return {'value': {'job_id': job_id, 'department_id': dept_id}}

<field name="employee_id" on_change="onchange_employee_id(employee_id)"/>

I have a custom field name last_contract_id (many2one to hr.contract) and I want it to be loaded automatically on change of employee_id (just to show the contracts that owned by the selected employee.

My aim is to override it using new API which I can reuse later in Odoo 10, 11, …

How can I do it, plz?

Odoo 10 and PostgreSQL 9.4 BDR

We are trying to set Odoo10 (One customized MLM Module) with PostgreSQL 9.4 BDR at Debian Linux

When we have done setup Odoo10 database with PostgreSQL 9.4 BDR and trying to start Odoo server. Its provide the error for Primary key is not set for many tables or Drop the particular table, which don't have Primary key.
error

File "/opt/odoo/odoo/addons/project/report/project_report.py", line 88, in init
tools.drop_view_if_exists(self._cr, self._table)
File "/opt/odoo/odoo/odoo/tools/sql.py", line 5, in drop_view_if_exists
cr.execute("DROP view IF EXISTS %s CASCADE" % (viewname,))
File "/opt/odoo/odoo/odoo/sql_db.py", line 141, in wrapper
return f(self, *args, **kwargs)
File "/opt/odoo/odoo/odoo/sql_db.py", line 218, in execute
res = self._obj.execute(query, params)
ProgrammingError: "report_project_task_user" is not a view
HINT: Use DROP TABLE to remove a table.

**When I am going to create node 1 ==> SELECT bdr.bdr_group_create( local_node_name := 'node1', node_external_dsn := user= dbname= password=);
at my first BDR machine, its provide **warning** like below.**

**warning**
HINT:  Drop the secondary unique constraint(s), change the table(s) to UNLOGGED if they don't need to be replicated, or exclude the table(s) from the active replication set(s).
WARNING:  Secondary unique constraint(s) exist on replicated table(s)
DETAIL:  Table public.mail_wizard_invite_res_partner_rel has secondary unique constraint mail_wizard_invite_res_partne_mail_wizard_invite_id_res_par_key. This may cause unhandled replication conflicts.
HINT:  Tables without a PRIMARY KEY cannot be UPDATEd or DELETEd from, only INSERTed into. Add a PRIMARY KEY.
WARNING:  Table public.mail_wizard_invite_res_partner_rel has no PRIMARY KEY
HINT:  Tables without a PRIMARY KEY cannot be UPDATEd or DELETEd from, only INSERTed into. Add a PRIMARY KEY.
WARNING:  Table public.mail_message_mail_channel_rel has no PRIMARY KEY
HINT:  Tables without a PRIMARY KEY cannot be UPDATEd or DELETEd from, only INSERTed into. Add a PRIMARY KEY.
WARNING:  Table public.project_tags_project_task_rel has no PRIMARY KEY

Please let me know if any one faced this kind of problem. Please provide the solution on this.

Thank in Advance

..py file

class mrp_product_produce(osv.osv_memory):
    _inherit = "mrp.product.produce"

    _columns = {
        'test': fields.char('test')
    }

…xml file

 <record id="view_mrp_product_produce_wizard_sss" model="ir.ui.view">
            <field name="name">MRP Product Produce</field>
            <field name="model">mrp.product.produce</field>
            <field name="inherit_id" ref="mrp.view_mrp_product_produce_wizard"/>
            <field name="arch" type="xml">
                <data>
                	<xpath expr="(//field[@name='product_id'])[2]" position="after">
                		<field name="test"/>
                    </xpath>
                </data>
            </field>
        </record>

gives next error ;-(

2016-01-21 11:06:12,725 6351 INFO db_20160107 openerp.modules.module: module SSS_po_project_task: creating or updating database tables
2016-01-21 11:06:13,758 6351 INFO db_20160107 openerp.modules.loading: loading SSS_po_project_task/views/mrp_view.xml
2016-01-21 11:06:14,347 6351 ERROR db_20160107 openerp.addons.base.ir.ir_ui_view: Veld test` bestaat niet

Fout context:
Weergave`MRP Product Produce`
[view_id: 1288, xml_id: SSS_po_project_task.view_mrp_product_produce_wizard_sss, model: mrp.product.produce, parent_id: 907]
2016-01-21 11:06:14,348 6351 DEBUG db_20160107 openerp.models: Exception while validating constraint
Traceback (most recent call last):
File "/media/disk2/workspace/odoo8_sss/openerp/models.py", line 1251, in _validate_fields
valid = valid or fun(self._model, cr, uid, ids)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 202, in _check_xml
self.postprocess_and_fields(cr, uid, view.model, view_doc, view.id, context=context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 806, in postprocess_and_fields
fields_def = self.postprocess(cr, user, model, node, view_id, False, fields, context=context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 716, in postprocess
fields.update(self.postprocess(cr, user, model, f, view_id, in_tree_view, model_fields, context))
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 716, in postprocess
fields.update(self.postprocess(cr, user, model, f, view_id, in_tree_view, model_fields, context))
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 643, in postprocess
xarch, xfields = self.postprocess_and_fields(cr, user, field.comodel_name, f, view_id, ctx)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 832, in postprocess_and_fields
self.raise_view_error(cr, user, message, view_id, context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 360, in raise_view_error
raise AttributeError(message)
AttributeError: Veld test` bestaat niet

Fout context:
Weergave`MRP Product Produce`
[view_id: 1288, xml_id: SSS_po_project_task.view_mrp_product_produce_wizard_sss, model: mrp.product.produce, parent_id: 907]
2016-01-21 11:06:14,362 6351 ERROR db_20160107 openerp.http: Exception during JSON request handling.
Traceback (most recent call last):
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 537, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 574, in dispatch
result = self._call_function(**self.params)
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 310, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/service/model.py", line 118, in wrapper
return f(dbname, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 307, in checked_call
return self.endpoint(*a, **kw)
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 803, in __call__
return self.method(*args, **kw)
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 403, in response_wrap
response = f(*args, **kw)
File "/media/disk2/workspace/odoo8_sss/addons/web/controllers/main.py", line 948, in call_button
action = self._call_kw(model, method, args, {})
File "/media/disk2/workspace/odoo8_sss/addons/web/controllers/main.py", line 936, in _call_kw
return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/module/module.py", line 534, in button_immediate_upgrade
return self._button_immediate_function(cr, uid, ids, self.button_upgrade, context=context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/module/module.py", line 495, in _button_immediate_function
registry = openerp.modules.registry.RegistryManager.new(cr.dbname, update_module=True)
File "/media/disk2/workspace/odoo8_sss/openerp/modules/registry.py", line 370, in new
openerp.modules.load_modules(registry._db, force_demo, status, update_module)
File "/media/disk2/workspace/odoo8_sss/openerp/modules/loading.py", line 351, in load_modules
force, status, report, loaded_modules, update_module)
File "/media/disk2/workspace/odoo8_sss/openerp/modules/loading.py", line 255, in load_marked_modules
loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
File "/media/disk2/workspace/odoo8_sss/openerp/modules/loading.py", line 176, in load_module_graph
_load_data(cr, module_name, idref, mode, kind='data')
File "/media/disk2/workspace/odoo8_sss/openerp/modules/loading.py", line 118, in _load_data
tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File "/media/disk2/workspace/odoo8_sss/openerp/tools/convert.py", line 901, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/media/disk2/workspace/odoo8_sss/openerp/tools/convert.py", line 987, in convert_xml_import
obj.parse(doc.getroot(), mode=mode)
File "/media/disk2/workspace/odoo8_sss/openerp/tools/convert.py", line 853, in parse
self._tags[rec.tag](self.cr, rec, n, mode=mode)
File "/media/disk2/workspace/odoo8_sss/openerp/tools/convert.py", line 763, in _tag_record
id = self.pool['ir.model.data']._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode, context=rec_context )
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_model.py", line 1025, in _update
model_obj.write(cr, uid, [res_id], values, context=context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 273, in write
context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 372, in old_api
result = method(recs, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/models.py", line 3787, in write
self._write(old_vals)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 248, in wrapper
return new_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 565, in new_api
result = method(self._model, cr, uid, self.ids, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/models.py", line 3959, in _write
recs._validate_fields(vals)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 248, in wrapper
return new_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/models.py", line 1272, in _validate_fields
raise ValidationError('\n'.join(errors))
ParseError: "ValidateError
Field(s) `arch` failed against a constraint: Invalid view definition

Meer info over fout:
Veld test` bestaat niet

Fout context:
Weergave`MRP Product Produce`
[view_id: 1288, xml_id: SSS_po_project_task.view_mrp_product_produce_wizard_sss, model: mrp.product.produce, parent_id: 907]" while parsing /media/disk2/workspace/odoo8_sss/custom_artissan/SSS_po_project_task/views/mrp_view.xml:21, near
<record id="view_mrp_product_produce_wizard_sss" model="ir.ui.view">
<field name="name">MRP Product Produce</field>
<field name="model">mrp.product.produce</field>
<field name="inherit_id" ref="mrp.view_mrp_product_produce_wizard"/>
<field name="arch" type="xml">
<data>
<xpath expr="(//field[@name='product_id'])[2]" position="after">
<field name="test"/>
</xpath>
</data>
</field>
</record>
2016-01-21 11:06:14,370 6351 INFO db_20160107 werkzeug: 10.0.0.64 - - [21/Jan/2016 11:06:14] "POST /web/dataset/call_button HTTP/1.1" 200 -
2016-01-21 11:06:32,661 6351 INFO db_20160107 openerp.modules.loading: loading 1 modules…
2016-01-21 11:06:32,684 6351 INFO db_20160107 openerp.modules.loading: 1 modules loaded in 0.02s, 0 queries
2016-01-21 11:06:33,400 6351 DEBUG db_20160107 openerp.modules.loading: Updating graph with 107 more modules
2016-01-21 11:06:33,440 6351 INFO db_20160107 openerp.modules.loading: loading 108 modules…
2016-01-21 11:06:41,515 6351 INFO db_20160107 openerp.modules.module: module SSS_po_project_task: creating or updating database tables
2016-01-21 11:06:42,663 6351 INFO db_20160107 openerp.modules.loading: loading SSS_po_project_task/views/mrp_view.xml
2016-01-21 11:06:43,565 6351 ERROR db_20160107 openerp.addons.base.ir.ir_ui_view: Veld test` bestaat niet


Can anyone help me please????