Merge lp:~inddiana/sisb/sisb_crear_funcion_fecha_inicio_rel_lab_nomina into lp:sisb

[[SISB] Aryrosa Fuentes]

[ADD] Se agrega funcion en postgres para calcular la fecha de inicio de la relacion laboral del empleado.

[lp:~inddiana/sisb/sisb_crear_funcion_fecha_inicio_rel_lab_nomina]

984. By [SISB] Aryrosa Fuentes on 2018-02-07

[ADD] Se agrega funcion en postgres para calcular la fecha de inicio de la relacion laboral del empleado.

=== modified file 'sisb_nomina/hr_payroll.py'
--- sisb_nomina/hr_payroll.py	2017-01-23 15:15:49 +0000
+++ sisb_nomina/hr_payroll.py	2018-02-07 15:35:56 +0000
@@ -258,6 +258,62 @@
     _defaults = {
         'schedule_pay': 'monthly',
     }
+    
+    
+    def _auto_init(self, cursor, context=None):
+        res = super(hr_contract, self)._auto_init(cursor, context=context)
+        
+        
+        cursor.execute("""
+            -- Function: date_start_rel_laboral(integer)
+            DROP FUNCTION IF EXISTS date_start_rel_laboral(integer);
+            
+            CREATE OR REPLACE FUNCTION date_start_rel_laboral(p_employee_id integer)
+              RETURNS date AS
+            $BODY$
+            --RETURN current_date;
+            DECLARE
+                contrato RECORD;
+                v_contract_id INTEGER;
+                v_date_start_up DATE;
+                v_date_start_dia_ant DATE;
+            BEGIN
+                
+                EXECUTE 'select hc.id, hc.date_start 
+                        from hr_contract hc 
+                        where hc.employee_id = $1
+                        order by hc.date_start desc
+                        LIMIT 1'
+                INTO v_contract_id, v_date_start_up
+                USING p_employee_id;
+                
+                IF (v_contract_id IS NOT NULL) THEN
+                    FOR contrato IN select  hc.employee_id, hc.date_start, hc.date_end
+                        from hr_contract hc
+                        where hc.employee_id = p_employee_id and id != v_contract_id
+                        order by hc.date_start desc
+                    LOOP
+                        v_date_start_dia_ant := v_date_start_up - 1;
+                        IF (v_date_start_dia_ant = contrato.date_end) THEN
+                            v_date_start_up := contrato.date_start;
+                        ELSE
+                            RETURN v_date_start_up;
+                        END IF;
+                    END LOOP;
+                    RETURN v_date_start_up;
+                ELSE
+                    RETURN now();
+                END IF;
+
+            END;
+
+            $BODY$
+              LANGUAGE plpgsql VOLATILE
+              COST 100;
+            ALTER FUNCTION date_start_rel_laboral(integer)
+              OWNER TO oerp;
+        """)
+        return res
 
     def create(self, cr, uid, vals, context=None):
         if context is None: