Merge lp:~mukunde/unifield-server/US-11212 into lp:unifield-server

[jftempo]

[lp:~mukunde/unifield-server/US-11212]

6417. By Gaël Mukunde on 2023-03-14

US-11212 [FIX] Code enhancement to take into account the possibility of order change of the queries union results.

Unmerged revisions

6417. By Gaël Mukunde on 2023-03-14

US-11212 [FIX] Code enhancement to take into account the possibility of order change of the queries union results.

6416. By Gaël Mukunde on 2023-03-07

US-11212 [FIX] Fix the period field selection

6415. By jftempo on 2023-02-28

US-11195 [IMP] OCA patch script: NR on periods Jul and Jun 2022

lp:~jfb-tempo-consulting/unifield-server/US-11195

6414. By jftempo on 2023-02-28

US-7603 [IMP] KIT name on screen and pdf

lp:~dorian-kemps/unifield-server/US-7603-2

6413. By jftempo on 2023-02-23

US-7598 [FIX] KCL: Fixed context cleaning when recursive closing is applied

lp:~dorian-kemps/unifield-server/US-7598-2

6412. By jftempo on 2023-02-22

Release UF28.0rc2

6411. By jftempo on 2023-02-21

US-11143 [FIX] Line added to FO must go to orignal FO

lp:~jfb-tempo-consulting/unifield-server/US-11143

6410. By jftempo on 2023-02-21

US-11139 FIX] PICK/OUT conversion: Remove KCL Refs when converting to OUT, remove KCL Refs from OUT processors and changing context when converting to Pick. Fixed unrelated translations

lp:~dorian-kemps/unifield-server/US-11139

6409. By jftempo on 2023-02-10

Release UF28.0rc1

6408. By jftempo on 2023-02-10

[FIX] Remove BAR on sale.order.line

=== modified file 'bin/addons/account/wizard/account_chart.py'
--- bin/addons/account/wizard/account_chart.py	2017-01-13 15:57:06 +0000
+++ bin/addons/account/wizard/account_chart.py	2023-03-14 10:07:51 +0000
@@ -42,27 +42,29 @@
     def onchange_fiscalyear(self, cr, uid, ids, fiscalyear_id=False, context=None):
         res = {}
         res['value'] = {}
+        periods = {}
         if fiscalyear_id:
             start_period = end_period = False
-            cr.execute('''
-                SELECT * FROM (SELECT p.id
+            cr.execute('''SELECT p.id AS start_id
                                FROM account_period p
                                LEFT JOIN account_fiscalyear f ON (p.fiscalyear_id = f.id)
                                WHERE f.id = %s and number != 0
                                ORDER BY p.date_start ASC
-                               LIMIT 1) AS period_start
-                UNION
-                SELECT * FROM (SELECT p.id
+                               LIMIT 1''', (fiscalyear_id,))
+            periods['period_from'] = [i[0] for i in cr.fetchall()] or False
+
+            cr.execute('''SELECT p.id AS stop_id
                                FROM account_period p
                                LEFT JOIN account_fiscalyear f ON (p.fiscalyear_id = f.id)
                                WHERE f.id = %s and number != 0
                                AND p.date_start < NOW()
                                ORDER BY p.date_stop DESC
-                               LIMIT 1) AS period_stop''', (fiscalyear_id, fiscalyear_id))
-            periods =  [i[0] for i in cr.fetchall()]
-            if periods and len(periods) > 1:
-                start_period = periods[0]
-                end_period = periods[1]
+                               LIMIT 1''', (fiscalyear_id,))
+            periods['period_to'] = [i[0] for i in cr.fetchall()] or False
+
+            if periods and periods['period_from'] and periods['period_to']:
+                start_period = periods['period_from'][0]
+                end_period = periods['period_to'][0]
             res['value'] = {'period_from': start_period, 'period_to': end_period}
 
         # US-1179