2 /**********************************************************************
3 Copyright (C) FrontAccounting, LLC.
4 Released under the terms of the GNU General Public License, GPL,
5 as published by the Free Software Foundation, either version 3
6 of the License, or (at your option) any later version.
7 This program is distributed in the hope that it will be useful,
8 but WITHOUT ANY WARRANTY; without even the implied warranty of
9 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
10 See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
11 ***********************************************************************/
13 class fa2_4rc1 extends fa_patch {
14 var $previous = '2.4.0'; // applicable database version
15 var $version = '2.4.1'; // version installed
17 var $sql = ''; // 'alter2.4rc1.sql';
18 var $max_upgrade_time = 900; // table recoding is really long process
20 function __construct() {
21 parent::__construct();
22 $this->description = _('Upgrade from version 2.4beta to 2.4RC1');
26 Shows parameters to be selected before upgrade (if any)
28 function show_params($comp)
30 display_note(_('Set optimal parameters and start upgrade:'));
31 start_table(TABLESTYLE);
33 table_section_title(_("Fixed Assets Defaults"));
34 gl_all_accounts_list_row(_("Loss On Asset Disposal Account:"), 'default_loss_on_asset_disposal_act', '5660',
35 true, false, _("None (will be set later)"));
42 Fetches selected upgrade parameters.
46 $this->fixed_disposal_act = get_post('default_loss_on_asset_disposal_act');
50 // Install procedure. All additional changes
51 // not included in sql file should go here.
53 function install($company, $force=false)
57 'SA_SETUPCOMPANY' => array(
58 'SA_ASSET', 'SA_ASSETCATEGORY', 'SA_ASSETCLASS',
59 'SA_ASSETSTRANSVIEW','SA_ASSETTRANSFER', 'SA_ASSETDISPOSAL',
60 'SA_DEPRECIATION', 'SA_ASSETSANALYTIC'),
62 $result = $this->update_security_roles($sec_updates);
64 $pref = $this->companies[$company]['tbpref'];
67 if (!db_query("UPDATE ".$pref."sys_prefs SET value=".db_escape($this->fixed_disposal_act)
68 ." WHERE name='default_loss_on_asset_disposal_act'")
70 return $this->log_error(sprintf(_("Cannot update sys prefs setting:\n%s"), db_error_msg($db)));
76 // optional procedure done after upgrade fail, before backup is restored
78 function post_fail($company)
80 $pref = $this->companies[$company]['tbpref'];
81 db_query("DROP TABLE IF EXISTS " . $pref . 'stock_fa_class');
83 db_query("DELETE FROM ".$pref."sys_prefs "
85 'default_loss_on_asset_disposal_act',
86 'depreciation_period',
88 'use_fixed_assets')");
93 $install = new fa2_4rc1;