/********************************************************************\ * dialog-find-transactions.c : locate transactions and show them * * Copyright (C) 2000 Bill Gribble * * * * This program is free software; you can redistribute it and/or * * modify it under the terms of the GNU General Public License as * * published by the Free Software Foundation; either version 2 of * * the License, or (at your option) any later version. * * * * This program is distributed in the hope that it will be useful, * * but WITHOUT ANY WARRANTY; without even the implied warranty of * * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * * GNU General Public License for more details. * * * * You should have received a copy of the GNU General Public License* * along with this program; if not, contact: * * * * Free Software Foundation Voice: +1-617-542-5942 * * 59 Temple Place - Suite 330 Fax: +1-617-542-2652 * * Boston, MA 02111-1307, USA gnu@gnu.org * \********************************************************************/ #define _GNU_SOURCE #include "config.h" #include #include #include #include #include "Query.h" #include "dialog-find-transactions.h" #include "dialog-utils.h" #include "gnc-account-tree.h" #include "gnc-amount-edit.h" #include "gnc-component-manager.h" #include "gnc-date-edit.h" #include "gnc-engine-util.h" #include "gnc-ledger-display.h" #include "gnc-ui.h" #include "gnc-ui-util.h" #include "messages.h" #include "window-help.h" #include "window-register.h" #define DIALOG_FIND_TRANS_CM_CLASS "dialog-find-trans" /* This static indicates the debugging module that this .o belongs to. */ static short module = MOD_GUI; struct _SelectDateDialog { GtkWidget * dialog; GtkWidget * cal; GtkWidget * entry_1; GtkWidget * entry_2; GtkWidget * entry_3; char * ymd_format; }; struct _FindTransactionsDialog { GtkWidget * dialog; Query * q; Query * ledger_q; char * ymd_format; int search_type; GtkWidget * new_search_radiobutton; GtkWidget * narrow_search_radiobutton; GtkWidget * add_search_radiobutton; GtkWidget * delete_search_radiobutton; GtkWidget * match_accounts_picker; GtkWidget * match_accounts_scroller; GtkWidget * account_tree; GtkWidget * date_start_toggle; GtkWidget * date_start_frame; GtkWidget * date_start_entry; GtkWidget * date_end_toggle; GtkWidget * date_end_frame; GtkWidget * date_end_entry; GtkWidget * description_entry; GtkWidget * description_case_toggle; GtkWidget * description_regexp_toggle; GtkWidget * number_entry; GtkWidget * number_case_toggle; GtkWidget * number_regexp_toggle; GtkWidget * credit_debit_picker; GtkWidget * amount_comp_picker; GtkWidget * amount_edit; GtkWidget * memo_entry; GtkWidget * memo_case_toggle; GtkWidget * memo_regexp_toggle; GtkWidget * shares_comp_picker; GtkWidget * shares_edit; GtkWidget * price_comp_picker; GtkWidget * price_edit; GtkWidget * action_entry; GtkWidget * action_case_toggle; GtkWidget * action_regexp_toggle; GtkWidget * cleared_not_cleared_toggle; GtkWidget * cleared_cleared_toggle; GtkWidget * cleared_reconciled_toggle; GtkWidget * balance_balanced_toggle; GtkWidget * balance_not_balanced_toggle; GtkWidget * tag_entry; GtkWidget * tag_case_toggle; GtkWidget * tag_regexp_toggle; }; static void gnc_ui_find_transactions_dialog_ok_cb(GtkButton * button, gpointer user_data); static void gnc_ui_find_transactions_dialog_cancel_cb(GtkButton * button, gpointer user_data); static void gnc_ui_find_transactions_dialog_help_cb(GtkButton * button, gpointer user_data); static void gnc_ui_find_transactions_dialog_early_date_toggle_cb(GtkToggleButton * button, gpointer user_data); static void gnc_ui_find_transactions_dialog_late_date_toggle_cb(GtkToggleButton * button, gpointer user_data); static void gnc_ui_find_transactions_dialog_search_type_cb(GtkToggleButton * tb, gpointer user_data); static int gnc_find_dialog_close_cb(GnomeDialog *dialog, gpointer data) { FindTransactionsDialog * ftd = data; ftd->dialog = NULL; xaccFreeQuery (ftd->q); ftd->q = NULL; g_free (ftd->ymd_format); ftd->ymd_format = NULL; gnc_unregister_gui_component_by_data (DIALOG_FIND_TRANS_CM_CLASS, ftd); g_free (ftd); return FALSE; } static void close_handler (gpointer user_data) { FindTransactionsDialog * ftd = user_data; gnome_dialog_close (GNOME_DIALOG (ftd->dialog)); } FindTransactionsDialog * gnc_ui_find_transactions_dialog_create(GNCLedgerDisplay * orig_ledg) { FindTransactionsDialog * ftd = g_new0(FindTransactionsDialog, 1); GtkWidget *box; GtkWidget *edit; GtkWidget *notebook; GladeXML *xml; gint page_num; xml = gnc_glade_xml_new ("find.glade", "Find Transactions"); glade_xml_signal_connect_data (xml, "gnc_ui_find_transactions_dialog_ok_cb", GTK_SIGNAL_FUNC (gnc_ui_find_transactions_dialog_ok_cb), ftd); glade_xml_signal_connect_data (xml, "gnc_ui_find_transactions_dialog_cancel_cb", GTK_SIGNAL_FUNC (gnc_ui_find_transactions_dialog_cancel_cb), ftd); glade_xml_signal_connect_data (xml, "gnc_ui_find_transactions_dialog_help_cb", GTK_SIGNAL_FUNC (gnc_ui_find_transactions_dialog_help_cb), ftd); glade_xml_signal_connect_data (xml, "gnc_ui_find_transactions_dialog_early_date_toggle_cb", GTK_SIGNAL_FUNC (gnc_ui_find_transactions_dialog_early_date_toggle_cb), ftd); glade_xml_signal_connect_data (xml, "gnc_ui_find_transactions_dialog_late_date_toggle_cb", GTK_SIGNAL_FUNC (gnc_ui_find_transactions_dialog_late_date_toggle_cb), ftd); glade_xml_signal_connect_data (xml, "gnc_ui_find_transactions_dialog_search_type_cb", GTK_SIGNAL_FUNC (gnc_ui_find_transactions_dialog_search_type_cb), ftd); ftd->dialog = glade_xml_get_widget (xml, "Find Transactions"); if(orig_ledg) { ftd->q = xaccQueryCopy (gnc_ledger_display_get_query (orig_ledg)); ftd->ledger_q = gnc_ledger_display_get_query (orig_ledg); } else { ftd->q = NULL; ftd->ledger_q = NULL; } /* initialize the radiobutton state vars */ ftd->search_type = 0; /* remove the tags page (unfinished) */ notebook = glade_xml_get_widget (xml, "find_notebook"); box = glade_xml_get_widget (xml, "tags_frame"); page_num = gtk_notebook_page_num (GTK_NOTEBOOK (notebook), box); if (page_num >= 0) gtk_notebook_remove_page (GTK_NOTEBOOK (notebook), page_num); /* find the important widgets */ ftd->new_search_radiobutton = glade_xml_get_widget (xml, "new_search_radiobutton"); ftd->narrow_search_radiobutton = glade_xml_get_widget (xml, "narrow_search_radiobutton"); ftd->add_search_radiobutton = glade_xml_get_widget (xml, "add_search_radiobutton"); ftd->delete_search_radiobutton = glade_xml_get_widget (xml, "delete_search_radiobutton"); ftd->match_accounts_scroller = glade_xml_get_widget (xml, "account_match_scroller"); ftd->match_accounts_picker = glade_xml_get_widget (xml, "account_match_picker"); ftd->date_start_toggle = glade_xml_get_widget (xml, "date_start_toggle"); ftd->date_start_frame = glade_xml_get_widget (xml, "date_start_frame"); ftd->date_start_entry = gnc_date_edit_new(time(NULL), FALSE, FALSE); gtk_container_add(GTK_CONTAINER(ftd->date_start_frame), ftd->date_start_entry); gtk_widget_set_sensitive(ftd->date_start_entry, FALSE); ftd->date_end_toggle = glade_xml_get_widget (xml, "date_end_toggle"); ftd->date_end_frame = glade_xml_get_widget (xml, "date_end_frame"); ftd->date_end_entry = gnc_date_edit_new(time(NULL), FALSE, FALSE); gtk_container_add(GTK_CONTAINER(ftd->date_end_frame), ftd->date_end_entry); gtk_widget_set_sensitive(ftd->date_end_entry, FALSE); ftd->description_entry = glade_xml_get_widget (xml, "description_entry"); ftd->description_case_toggle = glade_xml_get_widget (xml, "description_case_toggle"); ftd->description_regexp_toggle = glade_xml_get_widget (xml, "description_regexp_toggle"); ftd->number_entry = glade_xml_get_widget (xml, "number_entry"); ftd->number_case_toggle = glade_xml_get_widget (xml, "number_case_toggle"); ftd->number_regexp_toggle = glade_xml_get_widget (xml, "number_regexp_toggle"); ftd->credit_debit_picker = glade_xml_get_widget (xml, "credit_debit_picker"); ftd->amount_comp_picker = glade_xml_get_widget (xml, "amount_comp_picker"); box = glade_xml_get_widget (xml, "amount_box"); edit = gnc_amount_edit_new (); gtk_widget_show (edit); gtk_box_pack_start (GTK_BOX (box), edit, TRUE, TRUE, 0); ftd->amount_edit = edit; ftd->memo_entry = glade_xml_get_widget (xml, "memo_entry"); ftd->memo_case_toggle = glade_xml_get_widget (xml, "memo_case_toggle"); ftd->memo_regexp_toggle = glade_xml_get_widget (xml, "memo_regexp_toggle"); ftd->shares_comp_picker = glade_xml_get_widget (xml, "shares_comp_picker"); box = glade_xml_get_widget (xml, "shares_box"); edit = gnc_amount_edit_new (); gtk_widget_show (edit); gtk_box_pack_start (GTK_BOX (box), edit, TRUE, TRUE, 0); ftd->shares_edit = edit; ftd->price_comp_picker = glade_xml_get_widget (xml, "price_comp_picker"); box = glade_xml_get_widget (xml, "price_box"); edit = gnc_amount_edit_new (); gtk_widget_show (edit); gtk_box_pack_start (GTK_BOX (box), edit, TRUE, TRUE, 0); ftd->price_edit = edit; ftd->action_entry = glade_xml_get_widget (xml, "action_entry"); ftd->action_case_toggle = glade_xml_get_widget (xml, "action_case_toggle"); ftd->action_regexp_toggle = glade_xml_get_widget (xml, "action_regexp_toggle"); ftd->cleared_cleared_toggle = glade_xml_get_widget (xml, "cleared_cleared_toggle"); ftd->cleared_reconciled_toggle = glade_xml_get_widget (xml, "cleared_reconciled_toggle"); ftd->cleared_not_cleared_toggle = glade_xml_get_widget (xml, "cleared_not_cleared_toggle"); ftd->balance_balanced_toggle = glade_xml_get_widget (xml, "balance_balanced_toggle"); ftd->balance_not_balanced_toggle = glade_xml_get_widget(xml, "balance_not_balanced_toggle"); ftd->tag_entry = glade_xml_get_widget (xml, "tag_entry"); ftd->tag_case_toggle = glade_xml_get_widget (xml, "tag_case_toggle"); ftd->tag_regexp_toggle = glade_xml_get_widget (xml, "tag_regexp_toggle"); /* add an account picker to the first tab */ ftd->account_tree = gnc_account_tree_new(); gtk_clist_column_titles_hide(GTK_CLIST(ftd->account_tree)); gnc_account_tree_hide_all_but_name(GNC_ACCOUNT_TREE(ftd->account_tree)); gnc_account_tree_refresh(GNC_ACCOUNT_TREE(ftd->account_tree)); gtk_container_add(GTK_CONTAINER(ftd->match_accounts_scroller), ftd->account_tree); gtk_clist_set_selection_mode(GTK_CLIST(ftd->account_tree), GTK_SELECTION_MULTIPLE); gtk_widget_set_usize(GTK_WIDGET(ftd->match_accounts_scroller), 300, 300); /* initialize optionmenus with data indicating which option */ /* is selected */ gnc_option_menu_init(ftd->match_accounts_picker); gnc_option_menu_init(ftd->credit_debit_picker); gnc_option_menu_init(ftd->amount_comp_picker); gnc_option_menu_init(ftd->shares_comp_picker); gnc_option_menu_init(ftd->price_comp_picker); /* if there's no original query, make the narrow, add, delete * buttons inaccessible */ if(!ftd->q) { gtk_widget_set_sensitive(GTK_WIDGET(ftd->narrow_search_radiobutton), 0); gtk_widget_set_sensitive(GTK_WIDGET(ftd->add_search_radiobutton), 0); gtk_widget_set_sensitive(GTK_WIDGET(ftd->delete_search_radiobutton), 0); } else { gtk_toggle_button_set_active(GTK_TOGGLE_BUTTON (ftd->new_search_radiobutton), 0); gtk_toggle_button_set_active(GTK_TOGGLE_BUTTON (ftd->narrow_search_radiobutton), 1); } gnc_register_gui_component (DIALOG_FIND_TRANS_CM_CLASS, NULL, close_handler, ftd); gtk_signal_connect(GTK_OBJECT(ftd->dialog), "close", GTK_SIGNAL_FUNC(gnc_find_dialog_close_cb), ftd); gtk_widget_show_all(ftd->dialog); return ftd; } /********************************************************************\ * gnc_ui_find_transactions_dialog_destroy \********************************************************************/ void gnc_ui_find_transactions_dialog_destroy(FindTransactionsDialog * ftd) { if (!ftd) return; gnc_close_gui_component_by_data (DIALOG_FIND_TRANS_CM_CLASS, ftd); } /********************************************************************\ * callbacks for radio button selections \********************************************************************/ static void gnc_ui_find_transactions_dialog_search_type_cb(GtkToggleButton * tb, gpointer user_data) { FindTransactionsDialog * ftd = user_data; GSList * buttongroup = gtk_radio_button_group(GTK_RADIO_BUTTON(tb)); if(gtk_toggle_button_get_active(GTK_TOGGLE_BUTTON(tb))) { ftd->search_type = g_slist_length(buttongroup) - g_slist_index(buttongroup, tb) - 1; } } /********************************************************************\ * gnc_ui_find_transactions_dialog_cancel_cb \********************************************************************/ static void gnc_ui_find_transactions_dialog_cancel_cb(GtkButton * button, gpointer user_data) { FindTransactionsDialog * ftd = user_data; gnc_ui_find_transactions_dialog_destroy(ftd); } /********************************************************************\ * gnc_ui_find_transactions_dialog_help_cb \********************************************************************/ static void gnc_ui_find_transactions_dialog_help_cb(GtkButton * button, gpointer user_data) { helpWindow(NULL, NULL, HH_FIND_TRANSACTIONS); } /********************************************************************\ * gnc_ui_find_transactions_dialog_early_date_toggle_cb \********************************************************************/ static void gnc_ui_find_transactions_dialog_early_date_toggle_cb(GtkToggleButton * button, gpointer user_data) { FindTransactionsDialog * ftd = user_data; if(gtk_toggle_button_get_active(GTK_TOGGLE_BUTTON(button))) { gtk_widget_set_sensitive(GTK_WIDGET(ftd->date_start_entry), TRUE); } else { gtk_widget_set_sensitive(GTK_WIDGET(ftd->date_start_entry), FALSE); } } /********************************************************************\ * gnc_ui_find_transactions_dialog_late_date_toggle_cb \********************************************************************/ static void gnc_ui_find_transactions_dialog_late_date_toggle_cb(GtkToggleButton * button, gpointer user_data) { FindTransactionsDialog * ftd = user_data; if(gtk_toggle_button_get_active(GTK_TOGGLE_BUTTON(button))) { gtk_widget_set_sensitive(GTK_WIDGET(ftd->date_end_entry), TRUE); } else { gtk_widget_set_sensitive(GTK_WIDGET(ftd->date_end_entry), FALSE); } } /********************************************************************\ * gnc_ui_find_transactions_dialog_ok_cb \********************************************************************/ static void gnc_ui_find_transactions_dialog_ok_cb(GtkButton * button, gpointer user_data) { FindTransactionsDialog * ftd = user_data; GNCLedgerDisplay *ledger; GList * selected_accounts; char * descript_match_text; char * memo_match_text; char * number_match_text; char * action_match_text; char * tag_match_text; int search_type = ftd->search_type; float amt_temp; int amt_type; Query * q, * q2; Query * new_q; gboolean new_ledger = FALSE; int use_start_date, use_end_date; time_t start_date, end_date; int c_cleared, c_notcleared, c_reconciled; int b_balanced, b_not_balanced; if(search_type == 0) { if(ftd->q) xaccFreeQuery(ftd->q); ftd->q = xaccMallocQuery(); } g_assert(ftd->q); q = xaccMallocQuery(); xaccQuerySetGroup(q, gnc_get_current_group ()); /* account selections */ selected_accounts = gnc_account_tree_get_current_accounts (GNC_ACCOUNT_TREE(ftd->account_tree)); /* description */ descript_match_text = gtk_entry_get_text(GTK_ENTRY(ftd->description_entry)); /* memo */ memo_match_text = gtk_entry_get_text(GTK_ENTRY(ftd->memo_entry)); /* number */ number_match_text = gtk_entry_get_text(GTK_ENTRY(ftd->number_entry)); /* action */ action_match_text = gtk_entry_get_text(GTK_ENTRY(ftd->action_entry)); /* tag */ tag_match_text = ""; /* gtk_entry_get_text(GTK_ENTRY(ftd->tag_entry)); */ if(selected_accounts) { xaccQueryAddAccountMatch(q, selected_accounts, gnc_option_menu_get_active (ftd->match_accounts_picker) + 1, QUERY_AND); } if(strlen(descript_match_text)) { xaccQueryAddDescriptionMatch(q, descript_match_text, gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON (ftd->description_case_toggle)), gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON (ftd->description_regexp_toggle)), QUERY_AND); } if(strlen(number_match_text)) { xaccQueryAddNumberMatch(q, number_match_text, gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON (ftd->number_case_toggle)), gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON (ftd->number_regexp_toggle)), QUERY_AND); } amt_temp = gnc_amount_edit_get_damount (GNC_AMOUNT_EDIT (ftd->amount_edit)); amt_type = gnc_option_menu_get_active(ftd->credit_debit_picker) + 1; if((amt_temp > 0.00001) || (amt_type != AMT_SGN_MATCH_EITHER)) { DxaccQueryAddAmountMatch(q, amt_temp, amt_type, gnc_option_menu_get_active (ftd->amount_comp_picker) + 1, QUERY_AND); } use_start_date = gtk_toggle_button_get_active(GTK_TOGGLE_BUTTON(ftd->date_start_toggle)); use_end_date = gtk_toggle_button_get_active(GTK_TOGGLE_BUTTON(ftd->date_end_toggle)); start_date = gnc_date_edit_get_date(GNC_DATE_EDIT(ftd->date_start_entry)); end_date = gnc_date_edit_get_date_end(GNC_DATE_EDIT(ftd->date_end_entry)); if(use_start_date || use_end_date) { xaccQueryAddDateMatchTT(q, use_start_date, start_date, use_end_date, end_date, QUERY_AND); } if(strlen(memo_match_text)) { xaccQueryAddMemoMatch(q, memo_match_text, gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON(ftd->memo_case_toggle)), gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON(ftd->memo_regexp_toggle)), QUERY_AND); } amt_temp = gnc_amount_edit_get_damount (GNC_AMOUNT_EDIT (ftd->price_edit)); amt_type = gnc_option_menu_get_active(ftd->price_comp_picker) + 1; if((amt_temp > 0.00001) || (amt_type != AMT_MATCH_ATLEAST)) { DxaccQueryAddSharePriceMatch(q, amt_temp, amt_type, QUERY_AND); } amt_temp = gnc_amount_edit_get_damount (GNC_AMOUNT_EDIT (ftd->shares_edit)); amt_type = gnc_option_menu_get_active(ftd->shares_comp_picker) + 1; if((amt_temp > 0.00001) || (amt_type != AMT_MATCH_ATLEAST)) { DxaccQueryAddSharesMatch(q, amt_temp, amt_type, QUERY_AND); } if(strlen(action_match_text)) { xaccQueryAddActionMatch(q, action_match_text, gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON (ftd->action_case_toggle)), gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON (ftd->action_regexp_toggle)), QUERY_AND); } c_cleared = gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON(ftd->cleared_cleared_toggle)); c_notcleared = gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON(ftd->cleared_not_cleared_toggle)); c_reconciled = gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON(ftd->cleared_reconciled_toggle)); if(c_cleared || c_notcleared || c_reconciled) { int how = 0; if(c_cleared) how = how | CLEARED_CLEARED; if(c_notcleared) how = how | CLEARED_NO; if(c_reconciled) how = how | CLEARED_RECONCILED; xaccQueryAddClearedMatch(q, how, QUERY_AND); } b_balanced = gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON(ftd->balance_balanced_toggle)); b_not_balanced = gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON(ftd->balance_not_balanced_toggle)); if(b_balanced || b_not_balanced) { balance_match_t how = 0; if(b_balanced) how = how | BALANCE_BALANCED; if(b_not_balanced) how = how | BALANCE_UNBALANCED; xaccQueryAddBalanceMatch(q, how, QUERY_AND); } switch(search_type) { case 0: new_q = q; break; case 1: new_q = xaccQueryMerge(ftd->q, q, QUERY_AND); xaccFreeQuery(q); break; case 2: new_q = xaccQueryMerge(ftd->q, q, QUERY_OR); xaccFreeQuery(q); break; case 3: q2 = xaccQueryInvert(q); new_q = xaccQueryMerge(ftd->q, q2, QUERY_AND); xaccFreeQuery(q2); xaccFreeQuery(q); break; default: PERR ("bad search type: %d", search_type); new_q = q; break; } ledger = gnc_ledger_display_find_by_query (ftd->ledger_q); if(!ledger) { new_ledger = TRUE; ledger = gnc_ledger_display_query (new_q, SEARCH_LEDGER, REG_STYLE_JOURNAL); } else gnc_ledger_display_set_query (ledger, new_q); xaccFreeQuery (new_q); gnc_ledger_display_refresh (ledger); if (new_ledger) regWindowLedger(ledger); gnc_ui_find_transactions_dialog_destroy(ftd); }