function install($pref, $force)
{
global $db_version, $dflt_lang;
$this->preconf = $this->fix_extensions();
if (!$this->preconf) {
return false;
}
if (!$this->beta) {
// all specials below are already done on 2.3beta
$sql = "SELECT debtor_no, payment_terms FROM {$pref}debtors_master";
$result = db_query($sql);
if (!$result) {
display_error("Cannot read customers" . ':<br>' . db_error_msg($db));
return false;
}
// update all sales orders and transactions with customer std payment terms
while ($cust = db_fetch($result)) {
$sql = "UPDATE {$pref}debtor_trans SET " . "payment_terms = '" . $cust['payment_terms'] . "' WHERE debtor_no='" . $cust['debtor_no'] . "'";
if (db_query($sql) == false) {
display_error("Cannot update cust trans payment" . ':<br>' . db_error_msg($db));
return false;
}
$sql = "UPDATE {$pref}sales_orders SET " . "payment_terms = '" . $cust['payment_terms'] . "' WHERE debtor_no='" . $cust['debtor_no'] . "'";
if (db_query($sql) == false) {
display_error("Cannot update sales order payment" . ':<br>' . db_error_msg($db));
return false;
}
}
if (!$this->update_totals($pref)) {
display_error("Cannot update order totals");
return false;
}
if (!$this->update_line_relations($pref)) {
display_error("Cannot update sales document links");
return false;
}
//remove obsolete and temporary columns.
// this have to be done here as db_import rearranges alter query order
$dropcol = array('crm_persons' => array('tmp_id', 'tmp_class'), 'debtors_master' => array('email'), 'cust_branch' => array('phone', 'phone2', 'fax', 'email'), 'suppliers' => array('phone', 'phone2', 'fax', 'email'), 'debtor_trans' => array('trans_link'));
foreach ($dropcol as $table => $columns) {
foreach ($columns as $col) {
if (db_query("ALTER TABLE `{$pref}{$table}` DROP `{$col}`") == false) {
display_error("Cannot drop {$table}.{$col} column:<br>" . db_error_msg($db));
return false;
}
}
}
// remove old preferences table after upgrade script has been executed
$sql = "DROP TABLE IF EXISTS `{$pref}company`";
if (!db_query($sql)) {
return false;
}
}
$this->update_lang_cfg();
return update_company_prefs(array('version_id' => $db_version), $pref);
}
function do_install()
{
global $path_to_root, $db_connections, $def_coy, $installed_extensions, $tb_pref_counter, $dflt_lang, $installed_languages;
$coa = $_SESSION['inst_set']['coa'];
if (install_connect_db() && db_import($path_to_root . '/sql/' . $coa, $_SESSION['inst_set'])) {
$con = $_SESSION['inst_set'];
$table_prefix = $con['tbpref'];
$def_coy = 0;
$tb_pref_counter = 0;
$db_connections = array(0 => array('name' => $con['name'], 'host' => $con['host'], 'dbuser' => $con['dbuser'], 'dbpassword' => $con['dbpassword'], 'dbname' => $con['dbname'], 'tbpref' => $table_prefix));
$_SESSION['wa_current_user']->cur_con = 0;
update_company_prefs(array('coy_name' => $con['name']));
$admin = get_user_by_login('admin');
update_user_prefs($admin['id'], array('language' => $con['lang'], 'password' => md5($con['pass']), 'user_id' => $con['admin']));
if (!copy($path_to_root . "/config.default.php", $path_to_root . "/config.php")) {
display_error(_("Cannot save system configuration file 'config.php'."));
return false;
}
$err = write_config_db($table_prefix != "");
if ($err == -1) {
display_error(_("Cannot open 'config_db.php' configuration file."));
return false;
} else {
if ($err == -2) {
display_error(_("Cannot write to the 'config_db.php' configuration file."));
return false;
} else {
if ($err == -3) {
display_error(_("Configuration file 'config_db.php' is not writable. Change its permissions so it is, then re-run installation step."));
return false;
}
}
}
// update default language
if (file_exists($path_to_root . "/lang/installed_languages.inc")) {
include_once $path_to_root . "/lang/installed_languages.inc";
}
$dflt_lang = $_POST['lang'];
write_lang();
return true;
}
return false;
}
$grn_act = get_company_pref('grn_clearing_act');
if (get_post('grn_clearing_act') != $grn_act && db_num_rows(get_grn_items(0, '', true))) {
display_error(_("Before GRN Clearing Account can be changed all GRNs have to be invoiced"));
$_POST['grn_clearing_act'] = $grn_act;
set_focus('grn_clearing_account');
return false;
}
if (!is_account_balancesheet(get_post('retained_earnings_act')) || is_account_balancesheet(get_post('profit_loss_year_act'))) {
display_error(_("The Retained Earnings Account should be a Balance Account or the Profit and Loss Year Account should be an Expense Account (preferred the last one in the Expense Class)"));
return false;
}
return true;
}
//-------------------------------------------------------------------------------------------------
if (isset($_POST['submit']) && can_process()) {
update_company_prefs(get_post(array('retained_earnings_act', 'profit_loss_year_act', 'debtors_act', 'pyt_discount_act', 'creditors_act', 'freight_act', 'exchange_diff_act', 'bank_charge_act', 'default_sales_act', 'default_sales_discount_act', 'default_prompt_payment_act', 'default_inventory_act', 'default_cogs_act', 'default_adj_act', 'default_inv_sales_act', 'default_assembly_act', 'legal_text', 'past_due_days', 'default_workorder_required', 'default_dim_required', 'default_delivery_required', 'grn_clearing_act', 'allow_negative_stock' => 0, 'accumulate_shipping' => 0, 'po_over_receive' => 0.0, 'po_over_charge' => 0.0, 'default_credit_limit' => 0.0)));
display_notification(_("The general GL setup has been updated."));
}
/* end of if submit */
//-------------------------------------------------------------------------------------------------
start_form();
start_outer_table(TABLESTYLE2);
table_section(1);
if (get_company_pref('grn_clearing_act') === null) {
// available from 2.3.1, can be not defined on pre-2.4 installations
set_company_pref('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, 0);
refresh_sys_prefs();
}
$myrow = get_company_prefs();
$_POST['retained_earnings_act'] = $myrow["retained_earnings_act"];
$_POST['profit_loss_year_act'] = $myrow["profit_loss_year_act"];
$result = unlink($filename);
if (!$result) {
display_error(_('The existing image could not be removed'));
$input_error = 1;
}
}
$_POST['coy_logo'] = "";
}
if ($_POST['add_pct'] == "") {
$_POST['add_pct'] = -1;
}
if ($_POST['round_to'] <= 0) {
$_POST['round_to'] = 1;
}
if ($input_error != 1) {
update_company_prefs(get_post(array('coy_name', 'coy_no', 'gst_no', 'tax_prd', 'tax_last', 'postal_address', 'phone', 'fax', 'email', 'coy_logo', 'domicile', 'use_dimension', 'curr_default', 'f_year', 'no_item_list' => 0, 'no_customer_list' => 0, 'no_supplier_list' => 0, 'base_sales', 'time_zone' => 0, 'add_pct', 'round_to', 'login_tout', 'auto_curr_reval', 'bcc_email')));
$_SESSION['wa_current_user']->timeout = $_POST['login_tout'];
display_notification_centered(_("Company setup has been updated."));
}
set_focus('coy_name');
$Ajax->activate('_page_body');
}
/* end of if submit */
//---------------------------------------------------------------------------------------------
if (get_company_pref('bcc_email') === null) {
// available from 2.3.14, can be not defined on pre-2.4 installations
set_company_pref('bcc_email', 'setup.company', 'varchar', 100, '');
refresh_sys_prefs();
}
start_form(true);
$myrow = get_company_prefs();
$path_to_root = "../..";
include $path_to_root . "/includes/session.inc";
add_access_extensions();
page(_($help_context = "Paypal Import Setup"));
include_once $path_to_root . "/includes/date_functions.inc";
include_once $path_to_root . "/includes/ui.inc";
include_once $path_to_root . "/includes/data_checks.inc";
include_once $path_to_root . "/admin/db/company_db.inc";
//-------------------------------------------------------------------------------------------------
function can_process()
{
return true;
}
//-------------------------------------------------------------------------------------------------
if (isset($_POST['submit']) && can_process()) {
update_company_prefs(get_post(array('paypal_bank_id', 'paypal_create_invoices', 'paypal_sales_act', 'paypal_sales_tax_act', 'paypal_fee_act', 'paypal_shipping_act', 'paypal_insurance_act', 'paypal_withdraw_id', 'use_paypal_trn_id', 'paypal_sales_type_id', 'paypal_add_tax', 'paypal_recpt_today', 'paypal_tax_group_id', 'paypal_item_tax_id', 'paypal_tax_type_id', 'paypal_tax_included', 'paypal_name_col', 'paypal_salesman', 'paypal_area', 'paypal_location', 'paypal_shipper', 'paypal_credit_status')));
display_notification(_("The Paypal setup has been updated."));
}
/* end of if submit */
//-------------------------------------------------------------------------------------------------
start_form();
start_outer_table(TABLESTYLE2);
table_section(1);
if (get_company_pref('paypal_bank_id') === null) {
set_company_pref('paypal_bank_id', 'paypal.setup', 'int', 11, 0);
refresh_sys_prefs();
}
if (get_company_pref('paypal_create_invoices') === null) {
set_company_pref('paypal_create_invoices', 'paypal.setup', 'tinyint', 1, 0);
refresh_sys_prefs();
}
$errors++;
display_error(_("The SMTP port must be a positive number."));
}
if (empty($_POST['smtp_username']) && $_POST['mail_type'] == 'SMTP') {
$errors++;
display_error(_("The SMTP username must be entered."));
}
if (empty($_POST['smtp_password']) && $_POST['mail_type'] == 'SMTP') {
$errors++;
display_error(_("The SMTP password must be entered."));
}
return $errors == 0;
}
//-------------------------------------------------------------------------------------------------
if (isset($_POST['submit']) && can_process()) {
update_company_prefs(get_post(array('mail_type', 'smtp_host', 'smtp_port', 'smtp_auth', 'smtp_secure', 'smtp_username', 'smtp_password')));
display_notification(_("The mail sending settings has been updated."));
}
/* end of if submit */
if (list_updated('mail_type')) {
$Ajax->activate('details');
}
$prefs = get_company_prefs();
if (!isset($_POST['mail_type'])) {
$_POST['mail_type'] = $prefs['mail_type'];
}
$_POST['smtp_host'] = $prefs['smtp_host'];
$_POST['smtp_port'] = $prefs['smtp_port'];
$_POST['smtp_secure'] = $prefs['smtp_secure'];
$_POST['smtp_username'] = $prefs['smtp_username'];
$_POST['smtp_password'] = $prefs['smtp_password'];
