static void gnc_currency_edit_mnemonic_changed (GObject *gobject, GParamSpec *pspec, gpointer user_data) { GNCCurrencyEdit *self = GNC_CURRENCY_EDIT (gobject); GNCCurrencyEditPrivate *priv = GET_PRIVATE (self); gnc_commodity *currency = gnc_commodity_table_lookup (gnc_get_current_commodities (), GNC_COMMODITY_NS_CURRENCY, priv->mnemonic); /* If there isn't any such commodity, get the default */ if (!currency) { currency = gnc_locale_default_currency(); DEBUG("gce %p, default currency mnemonic %s", self, gnc_commodity_get_mnemonic(currency)); } g_signal_handlers_block_by_func(G_OBJECT(self), G_CALLBACK(gnc_currency_edit_mnemonic_changed), user_data); gnc_currency_edit_set_currency(self, currency); g_signal_handlers_unblock_by_func(G_OBJECT(self), G_CALLBACK(gnc_currency_edit_mnemonic_changed), user_data); }
/** This auxiliary function adds all the currency names to a combo * box. * * @internal * * @param gce A pointer to the widget that should be filled with * currency names. */ static void fill_currencies(GNCCurrencyEdit *gce) { GList *currencies; currencies = gnc_commodity_table_get_commodities (gnc_get_current_commodities (), GNC_COMMODITY_NS_CURRENCY); g_list_foreach(currencies, (GFunc)add_item, gce); g_list_free(currencies); }
/* Retrieve the displayed currency of the widget. * * @param gce The currency editor widget whose values should be retrieved. * * @return A pointer to the selected currency (a gnc_commodity * structure). */ gnc_commodity * gnc_currency_edit_get_currency (GNCCurrencyEdit *gce) { gnc_commodity *commodity; const char *fullname; char *mnemonic, *name; GtkTreeModel *model; GtkTreeIter iter; GValue value = { 0 }; g_return_val_if_fail(gce != NULL, NULL); g_return_val_if_fail(GNC_IS_CURRENCY_EDIT(gce), NULL); if (gtk_combo_box_get_active_iter(GTK_COMBO_BOX(gce), &iter)) { model = gtk_combo_box_get_model(GTK_COMBO_BOX(gce)); gtk_tree_model_get_value(model, &iter, 0, &value); fullname = g_value_get_string(&value); mnemonic = g_strdup(fullname); g_value_unset(&value); name = strchr(mnemonic, ' '); if (name != NULL) *name = '\0'; commodity = gnc_commodity_table_lookup (gnc_get_current_commodities (), GNC_COMMODITY_NS_CURRENCY, mnemonic); g_free(mnemonic); } else { g_warning("Combo box returned 'inactive'. Using locale default currency."); commodity = gnc_locale_default_currency(); } return commodity; }
gnc_commodity * gnc_import_select_commodity(const char * cusip, gboolean ask_on_unknown, const char * default_fullname, const char * default_mnemonic) { const gnc_commodity_table * commodity_table = gnc_get_current_commodities (); gnc_commodity * retval = NULL; gnc_commodity * tmp_commodity = NULL; char * tmp_namespace = NULL; GList * commodity_list = NULL; GList * namespace_list = NULL; DEBUG("Default fullname received: %s", default_fullname ? default_fullname : "(null)"); DEBUG("Default mnemonic received: %s", default_mnemonic ? default_mnemonic : "(null)"); g_return_val_if_fail(cusip, NULL); DEBUG("Looking for commodity with exchange_code: %s", cusip); g_assert(commodity_table); namespace_list = gnc_commodity_table_get_namespaces(commodity_table); namespace_list = g_list_first(namespace_list); while ( namespace_list != NULL && retval == NULL) { tmp_namespace = namespace_list->data; DEBUG("Looking at namespace %s", tmp_namespace); commodity_list = gnc_commodity_table_get_commodities(commodity_table, tmp_namespace); commodity_list = g_list_first(commodity_list); while ( commodity_list != NULL && retval == NULL) { const char* tmp_cusip = NULL; tmp_commodity = commodity_list->data; DEBUG("Looking at commodity %s", gnc_commodity_get_fullname(tmp_commodity)); tmp_cusip = gnc_commodity_get_cusip(tmp_commodity); if (tmp_cusip != NULL && cusip != NULL) { int len = strlen(cusip) > strlen(tmp_cusip) ? strlen(cusip) : strlen(tmp_cusip); if (strncmp(tmp_cusip, cusip, len) == 0) { retval = tmp_commodity; DEBUG("Commodity %s%s", gnc_commodity_get_fullname(retval), " matches."); } } commodity_list = g_list_next(commodity_list); } namespace_list = g_list_next(namespace_list); } g_list_free(commodity_list); g_list_free(namespace_list); if (retval == NULL && ask_on_unknown != 0) { const gchar *message = _("Please select a commodity to match the following exchange " "specific code. Please note that the exchange code of the " "commodity you select will be overwritten."); retval = gnc_ui_select_commodity_modal_full(NULL, NULL, DIAG_COMM_ALL, message, cusip, default_fullname, default_mnemonic); } /* There seems to be a problem here - if the matched commodity does not have a cusip defined (gnc_commodity_get_cusip returns NULL) then it does not get overwritten - which is not consistent with the message - so Im adding it to do this. Looks like this is all that was needed to fix the cash value used as stock units problem for pre-defined commodities which didnt have the cusip defined! */ if (retval != NULL && gnc_commodity_get_cusip(retval) != NULL && cusip != NULL && (strncmp(gnc_commodity_get_cusip(retval), cusip, strlen(cusip)) != 0)) { gnc_commodity_set_cusip(retval, cusip); } else if (gnc_commodity_get_cusip(retval) == NULL && cusip != NULL) { gnc_commodity_set_cusip(retval, cusip); } return retval; };
int ofx_proc_account_cb(struct OfxAccountData data, void * account_user_data) { gnc_commodity_table * commodity_table; gnc_commodity * default_commodity; GNCAccountType default_type = ACCT_TYPE_NONE; gchar * account_description; /* In order to trigger a book options display on the creation of a new book, * we need to detect when we are dealing with a new book. */ gboolean new_book = gnc_is_new_book(); const gchar * account_type_name = _("Unknown OFX account"); if (data.account_id_valid) { commodity_table = gnc_get_current_commodities (); if (data.currency_valid) { DEBUG("Currency from libofx: %s", data.currency); default_commodity = gnc_commodity_table_lookup(commodity_table, GNC_COMMODITY_NS_CURRENCY, data.currency); } else { default_commodity = NULL; } if (data.account_type_valid) { switch (data.account_type) { case OFX_CHECKING : default_type = ACCT_TYPE_BANK; account_type_name = _("Unknown OFX checking account"); break; case OFX_SAVINGS : default_type = ACCT_TYPE_BANK; account_type_name = _("Unknown OFX savings account"); break; case OFX_MONEYMRKT : default_type = ACCT_TYPE_MONEYMRKT; account_type_name = _("Unknown OFX money market account"); break; case OFX_CREDITLINE : default_type = ACCT_TYPE_CREDITLINE; account_type_name = _("Unknown OFX credit line account"); break; case OFX_CMA : default_type = ACCT_TYPE_NONE; account_type_name = _("Unknown OFX CMA account"); break; case OFX_CREDITCARD : default_type = ACCT_TYPE_CREDIT; account_type_name = _("Unknown OFX credit card account"); break; case OFX_INVESTMENT : default_type = ACCT_TYPE_BANK; account_type_name = _("Unknown OFX investment account"); break; default: PERR("WRITEME: ofx_proc_account() This is an unknown account type!"); break; } } /* If the OFX importer was started in Gnucash in a 'new_book' situation, * as described above, the first time the 'ofx_proc_account_cb' function * is called a book is created. (This happens after the 'new_book' flag * is set in 'gnc_get_current_commodities', called above.) So, before * calling 'gnc_import_select_account', allow the user to set book * options. */ if (new_book) new_book = gnc_new_book_option_display(); gnc_utf8_strip_invalid(data.account_name); account_description = g_strdup_printf( /* This string is a default account name. It MUST NOT contain the character ':' anywhere in it or in any translation. */ "%s \"%s\"", account_type_name, data.account_name); gnc_import_select_account(NULL, data.account_id, 1, account_description, default_commodity, default_type, NULL, NULL); g_free(account_description); } else { PERR("account online ID not available"); } return 0; }
int ofx_proc_transaction_cb(struct OfxTransactionData data, void * transaction_user_data) { char dest_string[255]; time64 current_time = gnc_time (NULL); Account *account; Account *investment_account = NULL; Account *income_account = NULL; gchar *investment_account_text, *investment_account_onlineid; gnc_commodity *currency = NULL; gnc_commodity *investment_commodity = NULL; gnc_numeric gnc_amount, gnc_units; QofBook *book; Transaction *transaction; Split *split; gchar *notes, *tmp; g_assert(gnc_ofx_importer_gui); if (!data.account_id_valid) { PERR("account ID for this transaction is unavailable!"); return 0; } account = gnc_import_select_account(gnc_gen_trans_list_widget(gnc_ofx_importer_gui), data.account_id, 0, NULL, NULL, ACCT_TYPE_NONE, NULL, NULL); if (account == NULL) { PERR("Unable to find account for id %s", data.account_id); return 0; } /***** Validate the input strings to ensure utf8 *****/ if (data.name_valid) gnc_utf8_strip_invalid(data.name); if (data.memo_valid) gnc_utf8_strip_invalid(data.memo); if (data.check_number_valid) gnc_utf8_strip_invalid(data.check_number); if (data.reference_number_valid) gnc_utf8_strip_invalid(data.reference_number); /***** Create the transaction and setup transaction data *******/ book = gnc_account_get_book(account); transaction = xaccMallocTransaction(book); xaccTransBeginEdit(transaction); /* Note: Unfortunately libofx <= 0.9.5 will not report a missing * date field as an invalid one. Instead, it will report it as * valid and return a completely bogus date. Starting with * libofx-0.9.6 (not yet released as of 2012-09-09), it will still * be reported as valid but at least the date integer itself is * just plain zero. */ if (data.date_posted_valid && (data.date_posted != 0)) { /* The hopeful case: We have a posted_date */ xaccTransSetDatePostedSecsNormalized(transaction, data.date_posted); } else if (data.date_initiated_valid && (data.date_initiated != 0)) { /* No posted date? Maybe we have an initiated_date */ xaccTransSetDatePostedSecsNormalized(transaction, data.date_initiated); } else { /* Uh no, no valid date. As a workaround use today's date */ xaccTransSetDatePostedSecsNormalized(transaction, current_time); } xaccTransSetDateEnteredSecs(transaction, current_time); /* Put transaction name in Description, or memo if name unavailable */ if (data.name_valid) { xaccTransSetDescription(transaction, data.name); } else if (data.memo_valid) { xaccTransSetDescription(transaction, data.memo); } /* Put everything else in the Notes field */ notes = g_strdup_printf("OFX ext. info: "); if (data.transactiontype_valid) { tmp = notes; notes = g_strdup_printf("%s%s%s", tmp, "|Trans type:", gnc_ofx_ttype_to_string(data.transactiontype)); g_free(tmp); } if (data.invtransactiontype_valid) { tmp = notes; notes = g_strdup_printf("%s%s%s", tmp, "|Investment Trans type:", gnc_ofx_invttype_to_str(data.invtransactiontype)); g_free(tmp); } if (data.memo_valid && data.name_valid) /* Copy only if memo wasn't put in Description */ { tmp = notes; notes = g_strdup_printf("%s%s%s", tmp, "|Memo:", data.memo); g_free(tmp); } if (data.date_funds_available_valid) { Timespec ts; timespecFromTime64(&ts, data.date_funds_available); gnc_timespec_to_iso8601_buff (ts, dest_string); tmp = notes; notes = g_strdup_printf("%s%s%s", tmp, "|Date funds available:", dest_string); g_free(tmp); } if (data.server_transaction_id_valid) { tmp = notes; notes = g_strdup_printf("%s%s%s", tmp, "|Server trans ID (conf. number):", data.server_transaction_id); g_free(tmp); } if (data.standard_industrial_code_valid) { tmp = notes; notes = g_strdup_printf("%s%s%ld", tmp, "|Standard Industrial Code:", data.standard_industrial_code); g_free(tmp); } if (data.payee_id_valid) { tmp = notes; notes = g_strdup_printf("%s%s%s", tmp, "|Payee ID:", data.payee_id); g_free(tmp); } //PERR("WRITEME: GnuCash ofx_proc_transaction():Add PAYEE and ADRESS here once supported by libofx! Notes=%s\n", notes); /* Ideally, gnucash should process the corrected transactions */ if (data.fi_id_corrected_valid) { PERR("WRITEME: GnuCash ofx_proc_transaction(): WARNING: This transaction corrected a previous transaction, but we created a new one instead!\n"); tmp = notes; notes = g_strdup_printf("%s%s%s%s", tmp, "|This corrects transaction #", data.fi_id_corrected, "but GnuCash didn't process the correction!"); g_free(tmp); } xaccTransSetNotes(transaction, notes); g_free(notes); if (data.account_ptr && data.account_ptr->currency_valid) { DEBUG("Currency from libofx: %s", data.account_ptr->currency); currency = gnc_commodity_table_lookup( gnc_get_current_commodities (), GNC_COMMODITY_NS_CURRENCY, data.account_ptr->currency); } else { DEBUG("Currency from libofx unavailable, defaulting to account's default"); currency = xaccAccountGetCommodity(account); } xaccTransSetCurrency(transaction, currency); if (data.amount_valid) { if (!data.invtransactiontype_valid) { /***** Process a normal transaction ******/ DEBUG("Adding split; Ordinary banking transaction, money flows from or into the source account"); split = xaccMallocSplit(book); xaccTransAppendSplit(transaction, split); xaccAccountInsertSplit(account, split); gnc_amount = gnc_ofx_numeric_from_double_txn(data.amount, transaction); xaccSplitSetBaseValue(split, gnc_amount, xaccTransGetCurrency(transaction)); /* set tran-num and/or split-action per book option */ if (data.check_number_valid) { gnc_set_num_action(transaction, split, data.check_number, NULL); } else if (data.reference_number_valid) { gnc_set_num_action(transaction, split, data.reference_number, NULL); } /* Also put the ofx transaction's memo in the * split's memo field */ if (data.memo_valid) { xaccSplitSetMemo(split, data.memo); } if (data.fi_id_valid) { gnc_import_set_split_online_id(split, data.fi_id); } } else if (data.unique_id_valid && data.security_data_valid && data.security_data_ptr != NULL && data.security_data_ptr->secname_valid) { gboolean choosing_account = TRUE; /********* Process an investment transaction **********/ /* Note that the ACCT_TYPE_STOCK account type should be replaced with something derived from data.invtranstype*/ // We have an investment transaction. First select the correct commodity. investment_commodity = gnc_import_select_commodity(data.unique_id, FALSE, NULL, NULL); if (investment_commodity != NULL) { // As we now have the commodity, select the account with that commodity. investment_account_text = g_strdup_printf( /* This string is a default account name. It MUST NOT contain the character ':' anywhere in it or in any translations. */ _("Stock account for security \"%s\""), data.security_data_ptr->secname); investment_account_onlineid = g_strdup_printf( "%s%s", data.account_id, data.unique_id); investment_account = gnc_import_select_account(NULL, investment_account_onlineid, 1, investment_account_text, investment_commodity, ACCT_TYPE_STOCK, NULL, NULL); // but use it only if that's really the right commodity if (investment_account && xaccAccountGetCommodity(investment_account) != investment_commodity) investment_account = NULL; // Loop until we either have an account, or the user pressed Cancel while (!investment_account && choosing_account) { // No account with correct commodity automatically found. // But are we in auto-create mode and already know a parent? if (auto_create_commodity && ofx_parent_account) { // Yes, so use that as parent when auto-creating the new account below. investment_account = ofx_parent_account; } else { // Let the user choose an account investment_account = gnc_import_select_account( gnc_gen_trans_list_widget(gnc_ofx_importer_gui), data.unique_id, TRUE, investment_account_text, investment_commodity, ACCT_TYPE_STOCK, NULL, &choosing_account); } // Does the chosen account have the right commodity? if (investment_account && xaccAccountGetCommodity(investment_account) != investment_commodity) { if (auto_create_commodity && xaccAccountTypesCompatible(xaccAccountGetType(investment_account), ACCT_TYPE_STOCK)) { // The user chose an account, but it does // not have the right commodity. Also, // auto-creation is on. Hence, we create a // new child account of the selected one, // and this one will have the right // commodity. Account *parent_account = investment_account; investment_account = gnc_ofx_new_account(investment_account_text, investment_commodity, parent_account, ACCT_TYPE_STOCK); if (investment_account) { gnc_import_set_acc_online_id(investment_account, data.unique_id); choosing_account = FALSE; ofx_parent_account = parent_account; } else { ofx_parent_account = NULL; } } else { // No account with matching commodity. Ask the user // whether to continue or abort. choosing_account = gnc_verify_dialog( gnc_gen_trans_list_widget(gnc_ofx_importer_gui), TRUE, "The chosen account \"%s\" does not have the correct " "currency/security \"%s\" (it has \"%s\" instead). " "This account cannot be used. " "Do you want to choose again?", xaccAccountGetName(investment_account), gnc_commodity_get_fullname(investment_commodity), gnc_commodity_get_fullname(xaccAccountGetCommodity(investment_account))); // We must also delete the online_id that was set in gnc_import_select_account() gnc_import_set_acc_online_id(investment_account, ""); investment_account = NULL; } } } if (!investment_account) { PERR("No investment account found for text: %s\n", investment_account_text); } g_free (investment_account_text); g_free (investment_account_onlineid); investment_account_text = NULL; if (investment_account != NULL && data.unitprice_valid && data.units_valid && ( data.invtransactiontype != OFX_INCOME ) ) { DEBUG("Adding investment split; Money flows from or into the stock account"); split = xaccMallocSplit(book); xaccTransAppendSplit(transaction, split); xaccAccountInsertSplit(investment_account, split); gnc_amount = gnc_ofx_numeric_from_double (ofx_get_investment_amount(&data), investment_commodity); gnc_units = gnc_ofx_numeric_from_double (data.units, investment_commodity); xaccSplitSetAmount(split, gnc_units); xaccSplitSetValue(split, gnc_amount); /* set tran-num and/or split-action per book option */ if (data.check_number_valid) { gnc_set_num_action(transaction, split, data.check_number, NULL); } else if (data.reference_number_valid) { gnc_set_num_action(transaction, split, data.reference_number, NULL); } if (data.security_data_ptr->memo_valid) { xaccSplitSetMemo(split, data.security_data_ptr->memo); } if (data.fi_id_valid) { gnc_import_set_split_online_id(split, data.fi_id); } } else { if (investment_account) PERR("The investment account, units or unitprice was not found for the investment transaction"); } } else { PERR("Commodity not found for the investment transaction"); } if (data.invtransactiontype_valid && investment_account) { if (data.invtransactiontype == OFX_REINVEST || data.invtransactiontype == OFX_INCOME) { DEBUG("Now let's find an account for the destination split"); income_account = gnc_ofx_kvp_get_assoc_account(investment_account); if (income_account == NULL) { DEBUG("Couldn't find an associated income account"); investment_account_text = g_strdup_printf( /* This string is a default account name. It MUST NOT contain the character ':' anywhere in it or in any translations. */ _("Income account for security \"%s\""), data.security_data_ptr->secname); income_account = gnc_import_select_account( gnc_gen_trans_list_widget(gnc_ofx_importer_gui), NULL, 1, investment_account_text, currency, ACCT_TYPE_INCOME, NULL, NULL); gnc_ofx_kvp_set_assoc_account(investment_account, income_account); DEBUG("KVP written"); } else { DEBUG("Found at least one associated income account"); } } if (income_account != NULL && data.invtransactiontype == OFX_REINVEST) { DEBUG("Adding investment split; Money flows from the income account"); split = xaccMallocSplit(book); xaccTransAppendSplit(transaction, split); xaccAccountInsertSplit(income_account, split); gnc_amount = gnc_ofx_numeric_from_double_txn (data.amount, transaction); xaccSplitSetBaseValue(split, gnc_amount, xaccTransGetCurrency(transaction)); // Set split memo from ofx transaction name or memo gnc_ofx_set_split_memo(&data, split); } if (income_account != NULL && data.invtransactiontype == OFX_INCOME) { DEBUG("Adding investment split; Money flows from the income account"); split = xaccMallocSplit(book); xaccTransAppendSplit(transaction, split); xaccAccountInsertSplit(income_account, split); gnc_amount = gnc_ofx_numeric_from_double_txn (-data.amount,/*OFX_INCOME amounts come in as positive numbers*/ transaction); xaccSplitSetBaseValue(split, gnc_amount, xaccTransGetCurrency(transaction)); // Set split memo from ofx transaction name or memo gnc_ofx_set_split_memo(&data, split); } } if (data.invtransactiontype_valid && data.invtransactiontype != OFX_REINVEST) { DEBUG("Adding investment split; Money flows from or to the cash account"); split = xaccMallocSplit(book); xaccTransAppendSplit(transaction, split); xaccAccountInsertSplit(account, split); gnc_amount = gnc_ofx_numeric_from_double_txn( -ofx_get_investment_amount(&data), transaction); xaccSplitSetBaseValue(split, gnc_amount, xaccTransGetCurrency(transaction)); // Set split memo from ofx transaction name or memo gnc_ofx_set_split_memo(&data, split); } } /* Send transaction to importer GUI. */ if (xaccTransCountSplits(transaction) > 0) { DEBUG("%d splits sent to the importer gui", xaccTransCountSplits(transaction)); gnc_gen_trans_list_add_trans (gnc_ofx_importer_gui, transaction); } else { PERR("No splits in transaction (missing account?), ignoring."); xaccTransDestroy(transaction); xaccTransCommitEdit(transaction); } } else { PERR("The transaction doesn't have a valid amount"); xaccTransDestroy(transaction); xaccTransCommitEdit(transaction); } return 0; }//end ofx_proc_transaction()
int ofx_proc_security_cb(const struct OfxSecurityData data, void * security_user_data) { const char* cusip = NULL; const char* default_fullname = NULL; const char* default_mnemonic = NULL; if (data.unique_id_valid) { cusip = data.unique_id; } if (data.secname_valid) { default_fullname = data.secname; } if (data.ticker_valid) { default_mnemonic = data.ticker; } if (auto_create_commodity) { gnc_commodity *commodity = gnc_import_select_commodity(cusip, FALSE, default_fullname, default_mnemonic); if (!commodity) { QofBook *book = gnc_get_current_book(); gnc_quote_source *source; gint source_selection = 0; // FIXME: This is just a wild guess const char *commodity_namespace = NULL; int fraction = 1; if (data.unique_id_type_valid) { commodity_namespace = data.unique_id_type; } g_warning("Creating a new commodity, cusip=%s", cusip); /* Create the new commodity */ commodity = gnc_commodity_new(book, default_fullname, commodity_namespace, default_mnemonic, cusip, fraction); /* Also set a single quote source */ gnc_commodity_begin_edit(commodity); gnc_commodity_user_set_quote_flag (commodity, TRUE); source = gnc_quote_source_lookup_by_ti (SOURCE_SINGLE, source_selection); gnc_commodity_set_quote_source(commodity, source); gnc_commodity_commit_edit(commodity); /* Remember the commodity */ gnc_commodity_table_insert(gnc_get_current_commodities(), commodity); /* Remember this new commodity for us as well */ ofx_created_commodites = g_list_prepend(ofx_created_commodites, commodity); } } else { gnc_import_select_commodity(cusip, TRUE, default_fullname, default_mnemonic); } return 0; }