Code Duplication    Length = 8-8 lines in 3 locations

src/Intraface/modules/accounting/Year.php 3 locations

@@ 570-577 (lines=8) @@
567
                    $db = new DB_Sql;
568
                    $new_balance_accounts = array();
569
570
                if (is_array($balance_accounts)) {
571
                    foreach ($balance_accounts as $key => $id) {
572
                        $db->query("SELECT id FROM accounting_account WHERE year_id = ".$this->get('id')." AND intranet_id = ".$this->kernel->intranet->get('id')." AND created_from_id = " . (int)$id);
573
                        while ($db->nextRecord()) {
574
                            $new_balance_accounts[] = $db->f('id');
575
                        }
576
                    }
577
                }
578
                    $this->setSetting('balance_accounts', serialize($new_balance_accounts));
579
580
                    $buy_eu_accounts = unserialize($last_year->getSetting('buy_eu_accounts'));
@@ 585-592 (lines=8) @@
582
                    $db = new DB_Sql;
583
                    $new_buy_eu_accounts = array();
584
585
                if (is_array($buy_eu_accounts)) {
586
                    foreach ($buy_eu_accounts as $key => $id) {
587
                        $db->query("SELECT id FROM accounting_account WHERE year_id = ".$this->get('id')." AND intranet_id = ".$this->kernel->intranet->get('id')." AND created_from_id = " . (int)$id);
588
                        while ($db->nextRecord()) {
589
                            $new_buy_eu_accounts[] = $db->f('id');
590
                        }
591
                    }
592
                }
593
                    $this->setSetting('buy_eu_accounts', serialize($new_buy_eu_accounts));
594
595
                    $buy_abroad_accounts = unserialize($last_year->getSetting('buy_abroad_accounts'));
@@ 600-607 (lines=8) @@
597
                    $db = new DB_Sql;
598
                    $new_buy_abroad_accounts = array();
599
600
                if (is_array($buy_abroad_accounts)) {
601
                    foreach ($buy_abroad_accounts as $key => $id) {
602
                        $db->query("SELECT id FROM accounting_account WHERE year_id = ".$this->get('id')." AND intranet_id = ".$this->kernel->intranet->get('id')." AND created_from_id = " . (int)$id);
603
                        while ($db->nextRecord()) {
604
                            $new_buy_abroad_accounts[] = $db->f('id');
605
                        }
606
                    }
607
                }
608
                    $this->setSetting('buy_abroad_accounts', serialize($new_buy_abroad_accounts));
609
610