update_payroll_workflow.yml 339 B

12345678
  1. -
  2. Workflow Mexican Electronic Payroll
  3. -
  4. !python {model: hr.payslip}: |
  5. cr.execute("""UPDATE wkf_instance
  6. SET state = 'active'
  7. WHERE state = 'complete' and wkf_id = (SELECT id FROM wkf WHERE name = 'hr.payslip.basic')
  8. AND res_id IN (SELECT id FROM hr_payslip WHERE state = 'done')""")