X-Git-Url: https://git.dogcows.com/gitweb?a=blobdiff_plain;f=src%2Frep_stats.c;h=a9d85fa097ab8b990f4e4f84a3f43bfe4317b2ed;hb=8892e90b335f94c296462a91534334b674226cd9;hp=ebc3b87abbd79563a86821c7af17fa8fc503c347;hpb=27f6e3b112df235c8e9afc9911b1f6bce208a001;p=chaz%2Fhomebank diff --git a/src/rep_stats.c b/src/rep_stats.c index ebc3b87..a9d85fa 100644 --- a/src/rep_stats.c +++ b/src/rep_stats.c @@ -1,5 +1,5 @@ /* HomeBank -- Free, easy, personal accounting for everyone. - * Copyright (C) 1995-2014 Maxime DOYEN + * Copyright (C) 1995-2018 Maxime DOYEN * * This file is part of HomeBank. * @@ -31,6 +31,7 @@ #include "ui-payee.h" #include "ui-category.h" #include "ui-filter.h" +#include "ui-transaction.h" /****************************************************************************/ /* Debug macros */ @@ -57,36 +58,39 @@ static void ui_repdist_action_legend(GtkAction *action, gpointer user_data); static void ui_repdist_action_rate(GtkAction *action, gpointer user_data); static void ui_repdist_action_filter(GtkAction *action, gpointer user_data); static void ui_repdist_action_refresh(GtkAction *action, gpointer user_data); -static void ui_repdist_action_export(GtkAction *action, gpointer user_data); -static GtkActionEntry entries[] = { - { "List" , "hb-view-list" , N_("List") , NULL, N_("View results as list"), G_CALLBACK (ui_repdist_action_viewlist) }, - { "Bar" , "hb-view-bar" , N_("Bar") , NULL, N_("View results as bars"), G_CALLBACK (ui_repdist_action_viewbar) }, - { "Pie" , "hb-view-pie" , N_("Pie") , NULL, N_("View results as pies"), G_CALLBACK (ui_repdist_action_viewpie) }, +static GtkRadioActionEntry radio_entries[] = { + { "List" , ICONNAME_HB_VIEW_LIST , N_("List") , NULL, N_("View results as list"), 0 }, + { "Column" , ICONNAME_HB_VIEW_COLUMN , N_("Column") , NULL, N_("View results as column"), 1 }, + { "Donut" , ICONNAME_HB_VIEW_DONUT , N_("Donut") , NULL, N_("View results as donut"), 2 }, +}; +static guint n_radio_entries = G_N_ELEMENTS (radio_entries); + - { "Filter" , "hb-filter" , N_("Filter") , NULL, N_("Edit the filter"), G_CALLBACK (ui_repdist_action_filter) }, - { "Refresh" , GTK_STOCK_REFRESH , N_("Refresh"), NULL, N_("Refresh results"), G_CALLBACK (ui_repdist_action_refresh) }, +static GtkActionEntry entries[] = { + { "Filter" , ICONNAME_HB_FILTER , N_("Filter") , NULL, N_("Edit filter"), G_CALLBACK (ui_repdist_action_filter) }, + { "Refresh" , ICONNAME_REFRESH , N_("Refresh"), NULL, N_("Refresh results"), G_CALLBACK (ui_repdist_action_refresh) }, - { "Export" , "hb-file-export", N_("Export") , NULL, N_("Export as CSV"), G_CALLBACK (ui_repdist_action_export) }, + //{ "Export" , ICONNAME_HB_FILE_EXPORT , N_("Export") , NULL, N_("Export as CSV"), G_CALLBACK (ui_repdist_action_export) }, }; static guint n_entries = G_N_ELEMENTS (entries); static GtkToggleActionEntry toggle_entries[] = { - { "Detail", "hb-ope-show", /* name, stock id */ + { "Detail", ICONNAME_HB_OPE_SHOW, /* name, icon-name */ N_("Detail"), NULL, /* label, accelerator */ N_("Toggle detail"), /* tooltip */ G_CALLBACK (ui_repdist_action_detail), FALSE }, /* is_active */ - { "Legend", "hb-legend", /* name, stock id */ + { "Legend", ICONNAME_HB_SHOW_LEGEND, /* name, icon-name */ N_("Legend"), NULL, /* label, accelerator */ N_("Toggle legend"), /* tooltip */ G_CALLBACK (ui_repdist_action_legend), TRUE }, /* is_active */ - { "Rate", "hb-rate", /* name, stock id */ + { "Rate", ICONNAME_HB_SHOW_RATE, /* name, icon-name */ N_("Rate"), NULL, /* label, accelerator */ N_("Toggle rate"), /* tooltip */ G_CALLBACK (ui_repdist_action_rate), @@ -101,8 +105,8 @@ static const gchar *ui_info = "" " " " " -" " -" " +" " +" " " " " " " " @@ -111,7 +115,8 @@ static const gchar *ui_info = " " " " " " -" " +//" " +// replaced by a menubutton " " ""; @@ -122,7 +127,6 @@ static void ui_repdist_range_change(GtkWidget *widget, gpointer user_data); static void ui_repdist_detail(GtkWidget *widget, gpointer user_data); static void ui_repdist_update(GtkWidget *widget, gpointer user_data); static void ui_repdist_update_total(GtkWidget *widget, gpointer user_data); -static void ui_repdist_export_csv(GtkWidget *widget, gpointer user_data); static void ui_repdist_compute(GtkWidget *widget, gpointer user_data); static void ui_repdist_sensitive(GtkWidget *widget, gpointer user_data); static void ui_repdist_toggle_detail(GtkWidget *widget, gpointer user_data); @@ -131,7 +135,9 @@ static void ui_repdist_toggle_minor(GtkWidget *widget, gpointer user_data); static void ui_repdist_toggle_rate(GtkWidget *widget, gpointer user_data); static GtkWidget *ui_list_repdist_create(void); static void ui_repdist_update_daterange(GtkWidget *widget, gpointer user_data); +static void ui_repdist_update_date_widget(GtkWidget *widget, gpointer user_data); +static GString *ui_list_repdist_to_string(GtkTreeView *treeview, gboolean clipboard); static gint ui_list_repdist_compare_func (GtkTreeModel *model, GtkTreeIter *a, GtkTreeIter *b, gpointer userdata); @@ -215,6 +221,27 @@ gint tmpview; } + +static void ui_repdist_action_mode (GtkRadioAction *action, GtkRadioAction *current, gpointer user_data) +{ +gint value; + + value = gtk_radio_action_get_current_value(GTK_RADIO_ACTION(action)); + switch( value ) + { + case 0: + ui_repdist_action_viewlist(GTK_ACTION(action), user_data); + break; + case 1: + ui_repdist_action_viewbar(GTK_ACTION(action), user_data); + break; + case 2: + ui_repdist_action_viewpie(GTK_ACTION(action), user_data); + break; + } +} + + static void ui_repdist_action_detail(GtkAction *action, gpointer user_data) { struct ui_repdist_data *data = user_data; @@ -243,10 +270,16 @@ struct ui_repdist_data *data = user_data; //debug //create_deffilter_window(data->filter, TRUE); - if(ui_flt_manage_dialog_new(data->filter, TRUE) != GTK_RESPONSE_REJECT) + if(ui_flt_manage_dialog_new(data->window, data->filter, TRUE) != GTK_RESPONSE_REJECT) { ui_repdist_compute(data->window, NULL); + ui_repdist_update_date_widget(data->window, NULL); ui_repdist_update_daterange(data->window, NULL); + + g_signal_handler_block(data->CY_range, data->handler_id[HID_REPDIST_RANGE]); + gtk_combo_box_set_active(GTK_COMBO_BOX(data->CY_range), FLT_RANGE_OTHER); + g_signal_handler_unblock(data->CY_range, data->handler_id[HID_REPDIST_RANGE]); + } } @@ -257,12 +290,12 @@ struct ui_repdist_data *data = user_data; ui_repdist_compute(data->window, NULL); } -static void ui_repdist_action_export(GtkAction *action, gpointer user_data) +/*static void ui_repdist_action_export(GtkAction *action, gpointer user_data) { struct ui_repdist_data *data = user_data; ui_repdist_export_csv(data->window, NULL); -} +}*/ @@ -322,6 +355,7 @@ gint year_from, year_ope, pos; return(pos); } + static void ui_repdist_date_change(GtkWidget *widget, gpointer user_data) { struct ui_repdist_data *data; @@ -330,25 +364,23 @@ struct ui_repdist_data *data; data = g_object_get_data(G_OBJECT(gtk_widget_get_ancestor(widget, GTK_TYPE_WINDOW)), "inst_data"); - data->filter->mindate = gtk_dateentry_get_date(GTK_DATE_ENTRY(data->PO_mindate)); - data->filter->maxdate = gtk_dateentry_get_date(GTK_DATE_ENTRY(data->PO_maxdate)); + data->filter->mindate = gtk_date_entry_get_date(GTK_DATE_ENTRY(data->PO_mindate)); + data->filter->maxdate = gtk_date_entry_get_date(GTK_DATE_ENTRY(data->PO_maxdate)); // set min/max date for both widget - gtk_dateentry_set_maxdate(GTK_DATE_ENTRY(data->PO_mindate), data->filter->maxdate); - gtk_dateentry_set_mindate(GTK_DATE_ENTRY(data->PO_maxdate), data->filter->mindate); + gtk_date_entry_set_maxdate(GTK_DATE_ENTRY(data->PO_mindate), data->filter->maxdate); + gtk_date_entry_set_mindate(GTK_DATE_ENTRY(data->PO_maxdate), data->filter->mindate); g_signal_handler_block(data->CY_range, data->handler_id[HID_REPDIST_RANGE]); gtk_combo_box_set_active(GTK_COMBO_BOX(data->CY_range), FLT_RANGE_OTHER); g_signal_handler_unblock(data->CY_range, data->handler_id[HID_REPDIST_RANGE]); - ui_repdist_compute(widget, NULL); ui_repdist_update_daterange(widget, NULL); } - static void ui_repdist_range_change(GtkWidget *widget, gpointer user_data) { struct ui_repdist_data *data; @@ -362,26 +394,20 @@ gint range; if(range != FLT_RANGE_OTHER) { - filter_preset_daterange_set(data->filter, range); + filter_preset_daterange_set(data->filter, range, 0); - g_signal_handler_block(data->PO_mindate, data->handler_id[HID_REPDIST_MINDATE]); - g_signal_handler_block(data->PO_maxdate, data->handler_id[HID_REPDIST_MAXDATE]); - - gtk_dateentry_set_date(GTK_DATE_ENTRY(data->PO_mindate), data->filter->mindate); - gtk_dateentry_set_date(GTK_DATE_ENTRY(data->PO_maxdate), data->filter->maxdate); - - g_signal_handler_unblock(data->PO_mindate, data->handler_id[HID_REPDIST_MINDATE]); - g_signal_handler_unblock(data->PO_maxdate, data->handler_id[HID_REPDIST_MAXDATE]); + ui_repdist_update_date_widget(data->window, NULL); - ui_repdist_compute(widget, NULL); - ui_repdist_update_daterange(widget, NULL); + ui_repdist_compute(data->window, NULL); + ui_repdist_update_daterange(data->window, NULL); } else { - if(ui_flt_manage_dialog_new(data->filter, TRUE) != GTK_RESPONSE_REJECT) + if(ui_flt_manage_dialog_new(data->window, data->filter, TRUE) != GTK_RESPONSE_REJECT) { + ui_repdist_update_date_widget(data->window, NULL); ui_repdist_compute(data->window, NULL); - ui_repdist_update_daterange(widget, NULL); + ui_repdist_update_daterange(data->window, NULL); } } } @@ -445,65 +471,39 @@ GtkTreeIter iter; gtk_tree_view_set_model(GTK_TREE_VIEW(data->LV_detail), NULL); /* Detach model from view */ /* fill in the model */ - list = g_list_first(GLOBALS->ope_list); + list = g_queue_peek_head_link(data->txn_queue); while (list != NULL) { Transaction *ope = list->data; - Account *acc; - - //DB( g_print(" get %s\n", ope->ope_Word) ); - acc = da_acc_get(ope->kacc); - if(acc == NULL) goto next1; - if((acc->flags & (AF_CLOSED|AF_NOREPORT))) goto next1; - - //filter here - if( !(ope->flags & OF_REMIND) ) + if(filter_test(data->filter, ope) == 1) { - if(filter_test(data->filter, ope) == 1) - { - guint i, pos = 0; + guint i, pos = 0; - if( tmpfor != BY_REPDIST_TAG ) + if( tmpfor != BY_REPDIST_TAG ) + { + if( (tmpfor == BY_REPDIST_CATEGORY || tmpfor == BY_REPDIST_SUBCATEGORY) && ope->flags & OF_SPLIT ) { - if( (tmpfor == BY_REPDIST_CATEGORY || tmpfor == BY_REPDIST_SUBCATEGORY) && ope->flags & OF_SPLIT ) + guint nbsplit = da_splits_count(ope->splits); + Split *split; + + for(i=0;isplits[i]; + switch(tmpfor) { - split = ope->splits[i]; - switch(tmpfor) - { - case BY_REPDIST_CATEGORY: - { - Category *catentry = da_cat_get(split->kcat); - if(catentry) - pos = (catentry->flags & GF_SUB) ? catentry->parent : catentry->key; - } - break; - case BY_REPDIST_SUBCATEGORY: - pos = split->kcat; - break; - } - - if( pos == active ) - { - - gtk_list_store_append (GTK_LIST_STORE(model), &iter); - gtk_list_store_set (GTK_LIST_STORE(model), &iter, - LST_DSPOPE_DATAS, ope, - -1); - + case BY_REPDIST_CATEGORY: + { + Category *catentry = da_cat_get(split->kcat); + if(catentry) + pos = (catentry->flags & GF_SUB) ? catentry->parent : catentry->key; + } + break; + case BY_REPDIST_SUBCATEGORY: + pos = split->kcat; break; - } - } - } - else - { - pos = ui_repdist_result_get_pos(tmpfor, data->filter->mindate, ope); + if( pos == active ) { @@ -511,44 +511,59 @@ GtkTreeIter iter; gtk_list_store_set (GTK_LIST_STORE(model), &iter, LST_DSPOPE_DATAS, ope, -1); - + + break; } - } + } } else - /* the TAG process is particular */ { - if(ope->tags != NULL) + pos = ui_repdist_result_get_pos(tmpfor, data->filter->mindate, ope); + if( pos == active ) { - guint32 *tptr = ope->tags; - while(*tptr) - { - pos = *tptr - 1; + gtk_list_store_append (GTK_LIST_STORE(model), &iter); + gtk_list_store_set (GTK_LIST_STORE(model), &iter, + LST_DSPOPE_DATAS, ope, + -1); - DB( g_print(" -> storing tag %d %.2f\n", pos, ope->amount) ); + } + } - if( pos == active ) - { - gtk_list_store_append (GTK_LIST_STORE(model), &iter); - gtk_list_store_set (GTK_LIST_STORE(model), &iter, - LST_DSPOPE_DATAS, ope, - -1); + } + else + /* the TAG process is particular */ + { + if(ope->tags != NULL) + { + guint32 *tptr = ope->tags; - } + while(*tptr) + { + pos = *tptr - 1; + + DB( g_print(" -> storing tag %d %.2f\n", pos, ope->amount) ); + + if( pos == active ) + { + gtk_list_store_append (GTK_LIST_STORE(model), &iter); + gtk_list_store_set (GTK_LIST_STORE(model), &iter, + LST_DSPOPE_DATAS, ope, + -1); - tptr++; } + tptr++; } + } + } - } } -next1: + list = g_list_next(list); } @@ -556,6 +571,8 @@ next1: gtk_tree_view_set_model(GTK_TREE_VIEW(data->LV_detail), model); g_object_unref(model); + gtk_tree_view_columns_autosize( GTK_TREE_VIEW(data->LV_detail) ); + } } @@ -577,8 +594,11 @@ gchar *title; model = gtk_tree_view_get_model(GTK_TREE_VIEW(data->LV_report)); byamount = gtk_toggle_button_get_active(GTK_TOGGLE_BUTTON(data->CM_byamount)); - tmpfor = gtk_combo_box_get_active(GTK_COMBO_BOX(data->CY_by)); tmpkind = gtk_combo_box_get_active(GTK_COMBO_BOX(data->CY_view)); + tmpfor = gtk_combo_box_get_active(GTK_COMBO_BOX(data->CY_by)); + + //debug option + DB( g_print(" option: byamount=%d tmpkind=%d '%s' tmpfor=%d '%s'\n\n", byamount, tmpkind, CYA_KIND2[tmpkind], tmpfor, CYA_STATSELECT[tmpfor]) ); // ensure not exp & inc for piechart page = gtk_notebook_get_current_page(GTK_NOTEBOOK(data->GR_result)); @@ -591,26 +611,32 @@ gchar *title; tmpkind = 1; } + // define view/sort column + column = LST_REPDIST_POS; - DB( g_print(" tmpkind %d\n\n", tmpkind) ); - + if( byamount ) + { + switch( tmpkind ) + { + case 0: //Inc & Exp + case 3: + column = LST_REPDIST_BALANCE; + break; + case 1: + column = LST_REPDIST_EXPENSE; + break; + case 2: + column = LST_REPDIST_INCOME; + break; + } + } - column = byamount ? LST_REPDIST_EXPENSE+(tmpkind-1)*2 : LST_REPDIST_POS; - - //#833614 sort category/payee by name - //if(!byamount && tmpkind <= BY_REPDIST_PAYEE) - // column = LST_REPDIST_NAME; - DB( g_print(" sort on column %d\n\n", column) ); gtk_tree_sortable_set_sort_column_id(GTK_TREE_SORTABLE(model), column, GTK_SORT_DESCENDING); - column = LST_REPDIST_EXPENSE+(tmpkind-1)*2; - - /* set chart color scheme */ gtk_chart_set_color_scheme(GTK_CHART(data->RE_chart), PREFS->report_color_scheme); - /* set chart title */ ////TRANSLATORS: example 'Expense by Category' title = g_strdup_printf(_("%s by %s"), _(CYA_KIND2[tmpkind]), _(CYA_STATSELECT[tmpfor]) ); @@ -618,23 +644,13 @@ gchar *title; gboolean abs = (tmpkind == 1 || tmpkind == 2) ? TRUE : FALSE; gtk_chart_set_absolute(GTK_CHART(data->RE_chart), abs); - - /* update bar chart */ - DB( g_print(" set bar to %d %s\n\n", column, _(CYA_KIND2[tmpkind])) ); - if( tmpkind == 0 ) - gtk_chart_set_dualdatas(GTK_CHART(data->RE_chart), model, LST_REPDIST_EXPENSE, LST_REPDIST_INCOME, title); - else - gtk_chart_set_datas(GTK_CHART(data->RE_chart), model, column, title); - - /* show xval for month/year and no by amount display */ xval = FALSE; - if( !byamount && (tmpfor == BY_REPDIST_MONTH || tmpfor == BY_REPDIST_YEAR) ) { xval = TRUE; - switch( tmpfor) + /*switch( tmpfor) { case BY_REPDIST_MONTH: gtk_chart_set_every_xval(GTK_CHART(data->RE_chart), 4); @@ -642,15 +658,51 @@ gchar *title; case BY_REPDIST_YEAR: gtk_chart_set_every_xval(GTK_CHART(data->RE_chart), 2); break; - } + }*/ } gtk_chart_show_xval(GTK_CHART(data->RE_chart), xval); + + /* update bar chart */ + if( tmpkind == 0 ) //dual exp/inc + { + DB( g_print(" set bar to dual exp %d/inc %d\n\n", LST_REPDIST_EXPENSE, LST_REPDIST_INCOME) ); + gtk_chart_set_dualdatas(GTK_CHART(data->RE_chart), model, LST_REPDIST_EXPENSE, LST_REPDIST_INCOME, title, NULL); + } + else + { + column = LST_REPDIST_EXPENSE+(tmpkind-1)*2; + DB( g_print(" set bar to %d\n\n", column) ); + gtk_chart_set_datas(GTK_CHART(data->RE_chart), model, column, title, NULL); + } + + g_free(title); } + +static void ui_repdist_update_date_widget(GtkWidget *widget, gpointer user_data) +{ +struct ui_repdist_data *data; + + DB( g_print("\n[repdist] update date widget\n") ); + + data = g_object_get_data(G_OBJECT(gtk_widget_get_ancestor(widget, GTK_TYPE_WINDOW)), "inst_data"); + + g_signal_handler_block(data->PO_mindate, data->handler_id[HID_REPDIST_MINDATE]); + g_signal_handler_block(data->PO_maxdate, data->handler_id[HID_REPDIST_MAXDATE]); + + gtk_date_entry_set_date(GTK_DATE_ENTRY(data->PO_mindate), data->filter->mindate); + gtk_date_entry_set_date(GTK_DATE_ENTRY(data->PO_maxdate), data->filter->maxdate); + + g_signal_handler_unblock(data->PO_mindate, data->handler_id[HID_REPDIST_MINDATE]); + g_signal_handler_unblock(data->PO_maxdate, data->handler_id[HID_REPDIST_MAXDATE]); + +} + + static void ui_repdist_update_daterange(GtkWidget *widget, gpointer user_data) { struct ui_repdist_data *data; @@ -676,83 +728,123 @@ struct ui_repdist_data *data; //minor = gtk_toggle_button_get_active(GTK_TOGGLE_BUTTON(data->CM_minor)); - /* - hb_label_set_colvaluecurr(GTK_LABEL(data->TX_total[0]), data->total_expense, GLOBALS->kcur); - hb_label_set_colvaluecurr(GTK_LABEL(data->TX_total[1]), data->total_income, GLOBALS->kcur); - hb_label_set_colvaluecurr(GTK_LABEL(data->TX_total[2]), data->total_expense + data->total_income, GLOBALS->kcur); - */ + hb_label_set_colvalue(GTK_LABEL(data->TX_total[0]), data->total_expense, GLOBALS->kcur, GLOBALS->minor); + hb_label_set_colvalue(GTK_LABEL(data->TX_total[1]), data->total_income, GLOBALS->kcur, GLOBALS->minor); + hb_label_set_colvalue(GTK_LABEL(data->TX_total[2]), data->total_expense + data->total_income, GLOBALS->kcur, GLOBALS->minor); + + +} + + +static void ui_repdist_export_result_clipboard(GtkWidget *widget, gpointer user_data) +{ +struct ui_repdist_data *data; +GtkClipboard *clipboard; +GString *node; + + DB( g_print("\n[repdist] export result clipboard\n") ); + + data = user_data; + //data = g_object_get_data(G_OBJECT(gtk_widget_get_ancestor(widget, GTK_TYPE_WINDOW)), "inst_data"); - hb_label_set_colvalue(GTK_LABEL(data->TX_total[0]), data->total_expense, GLOBALS->minor); - hb_label_set_colvalue(GTK_LABEL(data->TX_total[1]), data->total_income, GLOBALS->minor); - hb_label_set_colvalue(GTK_LABEL(data->TX_total[2]), data->total_expense + data->total_income, GLOBALS->minor); + node = ui_list_repdist_to_string(GTK_TREE_VIEW(data->LV_report), TRUE); + clipboard = gtk_clipboard_get_default(gdk_display_get_default()); + gtk_clipboard_set_text(clipboard, node->str, node->len); + g_string_free(node, TRUE); } -static void ui_repdist_export_csv(GtkWidget *widget, gpointer user_data) + +static void ui_repdist_export_result_csv(GtkWidget *widget, gpointer user_data) { struct ui_repdist_data *data; -GtkTreeModel *model; -GtkTreeIter iter; -gboolean valid; gchar *filename = NULL; +GString *node; GIOChannel *io; -gchar *outstr, *name; +gchar *name; gint tmpfor; - DB( g_print("\n[repdist] export csv\n") ); + DB( g_print("\n[repdist] export result csv\n") ); - data = g_object_get_data(G_OBJECT(gtk_widget_get_ancestor(widget, GTK_TYPE_WINDOW)), "inst_data"); + data = user_data; + //data = g_object_get_data(G_OBJECT(gtk_widget_get_ancestor(widget, GTK_TYPE_WINDOW)), "inst_data"); tmpfor = gtk_combo_box_get_active(GTK_COMBO_BOX(data->CY_by)); - - name = g_strdup_printf("hb-stat_%s.csv", CYA_STATSELECT[tmpfor]); + name = g_strdup_printf("hb-repstat_%s.csv", CYA_STATSELECT[tmpfor]); if( ui_file_chooser_csv(GTK_WINDOW(data->window), GTK_FILE_CHOOSER_ACTION_SAVE, &filename, name) == TRUE ) { DB( g_print(" + filename is %s\n", filename) ); - io = g_io_channel_new_file(filename, "w", NULL); if(io != NULL) { - // header - outstr = g_strdup_printf("%s;%s;%s;%s\n", _("Result"), _("expense"), _("Income"), _("Balance")); - g_io_channel_write_chars(io, outstr, -1, NULL, NULL); + node = ui_list_repdist_to_string(GTK_TREE_VIEW(data->LV_report), FALSE); + g_io_channel_write_chars(io, node->str, -1, NULL, NULL); + g_io_channel_unref (io); + g_string_free(node, TRUE); + } + g_free( filename ); + } + g_free(name); +} - model = gtk_tree_view_get_model(GTK_TREE_VIEW(data->LV_report)); - valid = gtk_tree_model_get_iter_first(GTK_TREE_MODEL(model), &iter); - while (valid) - { - gchar *name; - gdouble exp, inc, bal; - gtk_tree_model_get (model, &iter, - //LST_REPDIST_KEY, i, - LST_REPDIST_NAME , &name, - LST_REPDIST_EXPENSE, &exp, - LST_REPDIST_INCOME , &inc, - LST_REPDIST_BALANCE, &bal, - -1); +static void ui_repdist_export_detail_clipboard(GtkWidget *widget, gpointer user_data) +{ +struct ui_repdist_data *data; +GtkClipboard *clipboard; +GString *node; + + DB( g_print("\n[repdist] export detail clipboard\n") ); - outstr = g_strdup_printf("%s;%.2f;%.2f;%.2f\n", name, exp, inc, bal); - g_io_channel_write_chars(io, outstr, -1, NULL, NULL); + data = user_data; + //data = g_object_get_data(G_OBJECT(gtk_widget_get_ancestor(widget, GTK_TYPE_WINDOW)), "inst_data"); - DB( g_print("%s", outstr) ); + node = list_txn_to_string(GTK_TREE_VIEW(data->LV_detail), TRUE); - g_free(outstr); + clipboard = gtk_clipboard_get_default(gdk_display_get_default()); + gtk_clipboard_set_text(clipboard, node->str, node->len); - valid = gtk_tree_model_iter_next(GTK_TREE_MODEL(model), &iter); - } + g_string_free(node, TRUE); +} + + +static void ui_repdist_export_detail_csv(GtkWidget *widget, gpointer user_data) +{ +struct ui_repdist_data *data; +gchar *filename = NULL; +GString *node; +GIOChannel *io; +gchar *name; +gint tmpfor; + + DB( g_print("\n[repdist] export detail csv\n") ); + + data = user_data; + //data = g_object_get_data(G_OBJECT(gtk_widget_get_ancestor(widget, GTK_TYPE_WINDOW)), "inst_data"); + + tmpfor = gtk_combo_box_get_active(GTK_COMBO_BOX(data->CY_by)); + name = g_strdup_printf("hb-repstat-detail_%s.csv", CYA_STATSELECT[tmpfor]); + + if( ui_file_chooser_csv(GTK_WINDOW(data->window), GTK_FILE_CHOOSER_ACTION_SAVE, &filename, name) == TRUE ) + { + DB( g_print(" + filename is %s\n", filename) ); + + io = g_io_channel_new_file(filename, "w", NULL); + if(io != NULL) + { + node = list_txn_to_string(GTK_TREE_VIEW(data->LV_detail), FALSE); + g_io_channel_write_chars(io, node->str, -1, NULL, NULL); g_io_channel_unref (io); + g_string_free(node, TRUE); } g_free( filename ); } g_free(name); - - } @@ -780,16 +872,17 @@ gdouble exprate, incrate, balrate; DB( g_print(" for=%d,kind=%d\n", tmpfor, tmpkind) ); - - - /* do nothing if no transaction */ - if(g_list_length(GLOBALS->ope_list) == 0) return; - //get our min max date from = data->filter->mindate; to = data->filter->maxdate; if(to < from) return; + + g_queue_free (data->txn_queue); + data->txn_queue = hbfile_transaction_get_partial(data->filter->mindate, data->filter->maxdate); + + DB( g_print(" nb-txn=%d\n", g_queue_get_length (data->txn_queue) ) ); + /* count number or results */ switch(tmpfor) { @@ -835,141 +928,167 @@ gdouble exprate, incrate, balrate; if(tmp_expense && tmp_income) { + + DB( g_print(" - ok memory\n") ); + /* compute the results */ - list = g_list_first(GLOBALS->ope_list); + list = g_queue_peek_head_link(data->txn_queue); while (list != NULL) { Transaction *ope = list->data; - Account *acc; - //debug - //DB( g_print("** testing '%s', cat=%d==> %d\n", ope->wording, ope->category, filter_test(data->filter, ope)) ); - acc = da_acc_get(ope->kacc); - if(acc == NULL) goto next1; - if((acc->flags & (AF_CLOSED|AF_NOREPORT))) goto next1; - - if( !(ope->flags & OF_REMIND) ) + + DB( g_print("** testing '%s', cat=%d==> %d\n", ope->memo, ope->kcat, filter_test(data->filter, ope)) ); + + if( (filter_test(data->filter, ope) == 1) ) { - if( (filter_test(data->filter, ope) == 1) ) - { - guint32 pos = 0; - gdouble trn_amount; + guint32 pos = 0; + gdouble trn_amount; - //trn_amount = to_base_amount(ope->amount, acc->kcur); - trn_amount = ope->amount; + DB( g_print(" - should insert\n") ); - if( tmpfor != BY_REPDIST_TAG ) - { - if( (tmpfor == BY_REPDIST_CATEGORY || tmpfor == BY_REPDIST_SUBCATEGORY) && ope->flags & OF_SPLIT ) - { - guint nbsplit = da_transaction_splits_count(ope); - Split *split; - Category *catentry; - gint sinsert; - - for(i=0;isplits[i]; - catentry = da_cat_get(split->kcat); - if(!catentry) continue; - sinsert = ( catentry->filter == TRUE ) ? 1 : 0; - if(data->filter->option[FILTER_CATEGORY] == 2) sinsert ^= 1; + //trn_amount = ope->amount; + trn_amount = hb_amount_base(ope->amount, ope->kcur); - DB( g_print(" split '%s' insert=%d\n",catentry->name, sinsert) ); - - if( (data->filter->option[FILTER_CATEGORY] == 0) || sinsert) - { - switch(tmpfor) - { - case BY_REPDIST_CATEGORY: - { - if(catentry) - pos = (catentry->flags & GF_SUB) ? catentry->parent : catentry->key; - } - break; - case BY_REPDIST_SUBCATEGORY: - pos = split->kcat; - break; - } + //#1562372 in case of a split we need to take amount for filter categories only + if( ope->flags & OF_SPLIT ) + { + guint nbsplit = da_splits_count(ope->splits); + Split *split; + Category *catentry; + gint sinsert; - //trn_amount = to_base_amount(split->amount, acc->kcur); - trn_amount = split->amount; + trn_amount = 0.0; - if(trn_amount > 0.0) - { - tmp_income[pos] += trn_amount; - data->total_income += trn_amount; - } - else - { - tmp_expense[pos] += trn_amount; - data->total_expense += trn_amount; - } + for(i=0;isplits[i]; + catentry = da_cat_get(split->kcat); + if(catentry == NULL) continue; + sinsert = ( catentry->filter == TRUE ) ? 1 : 0; + if(data->filter->option[FILTER_CATEGORY] == 2) sinsert ^= 1; - } - // end insert + DB( g_print(" split '%s' insert=%d\n",catentry->name, sinsert) ); - } - } - else + if( (data->filter->option[FILTER_CATEGORY] == 0) || sinsert) { - pos = ui_repdist_result_get_pos(tmpfor, from, ope); - if(trn_amount > 0.0) - { - tmp_income[pos] += trn_amount; - data->total_income += trn_amount; - } - else - { - tmp_expense[pos] += trn_amount; - data->total_expense += trn_amount; - } + trn_amount += hb_amount_base(split->amount, ope->kcur); } } - else - /* the TAG process is particular */ + + } + + + if( tmpfor != BY_REPDIST_TAG ) + { + if( (tmpfor == BY_REPDIST_CATEGORY || tmpfor == BY_REPDIST_SUBCATEGORY) && ope->flags & OF_SPLIT ) { - if(ope->tags != NULL) - { - guint32 *tptr = ope->tags; + guint nbsplit = da_splits_count(ope->splits); + Split *split; + Category *catentry; + gint sinsert; - while(*tptr) + for(i=0;isplits[i]; + catentry = da_cat_get(split->kcat); + if(catentry == NULL) continue; + sinsert = ( catentry->filter == TRUE ) ? 1 : 0; + if(data->filter->option[FILTER_CATEGORY] == 2) sinsert ^= 1; + + DB( g_print(" split '%s' insert=%d\n",catentry->name, sinsert) ); + + if( (data->filter->option[FILTER_CATEGORY] == 0) || sinsert) { - pos = *tptr - 1; + switch(tmpfor) + { + case BY_REPDIST_CATEGORY: + { + pos = (catentry->flags & GF_SUB) ? catentry->parent : catentry->key; + } + break; + case BY_REPDIST_SUBCATEGORY: + pos = split->kcat; + break; + } - DB( g_print(" -> storing tag %d %s %.2f\n", pos, da_tag_get(*tptr)->name, trn_amount) ); + trn_amount = hb_amount_base(split->amount, ope->kcur); + //trn_amount = split->amount; if(trn_amount > 0.0) { tmp_income[pos] += trn_amount; + data->total_income += trn_amount; } else { tmp_expense[pos] += trn_amount; + data->total_expense += trn_amount; } - tptr++; + } + // end insert + + } + } + else + { + pos = ui_repdist_result_get_pos(tmpfor, from, ope); + if(trn_amount > 0.0) + { + tmp_income[pos] += trn_amount; + data->total_income += trn_amount; + } + else + { + tmp_expense[pos] += trn_amount; + data->total_expense += trn_amount; + } + } + } + else + /* the TAG process is particularly */ + { + if(ope->tags != NULL) + { + guint32 *tptr = ope->tags; + + while(*tptr) + { + pos = *tptr - 1; + + DB( g_print(" -> storing tag %d %s %.2f\n", pos, da_tag_get(*tptr)->name, trn_amount) ); - //#1195859 if(trn_amount > 0.0) { - data->total_income += trn_amount; + tmp_income[pos] += trn_amount; } else { - data->total_expense += trn_amount; + tmp_expense[pos] += trn_amount; } + tptr++; + } + //#1195859 + if(trn_amount > 0.0) + { + data->total_income += trn_amount; } + else + { + data->total_expense += trn_amount; + } + } + } - // fix total according to selection - //if(tmpkind==0 && !tmp_expense[pos]) { data->total_income -= ope->amount; } - //if(tmpkind==1 && !tmp_income[pos] ) { data->total_expense -= ope->amount; } + // fix total according to selection + //if(tmpkind==0 && !tmp_expense[pos]) { data->total_income -= ope->amount; } + //if(tmpkind==1 && !tmp_income[pos] ) { data->total_expense -= ope->amount; } - } } -next1: + list = g_list_next(list); } @@ -989,7 +1108,7 @@ next1: name = NULL; fullcatname = NULL; - DB( g_print("try to insert item %d\n", i) ); + DB( g_print("try to insert item %d - %.2f %.2f\n", i, tmp_expense[i], tmp_income[i]) ); /* filter empty results */ @@ -1006,7 +1125,6 @@ next1: case BY_REPDIST_CATEGORY: { Category *entry = da_cat_get(i); - if(entry != NULL) { name = entry->key == 0 ? _("(no category)") : entry->name; @@ -1106,6 +1224,10 @@ next1: g_free(fullcatname); } + /* update column 0 title */ + GtkTreeViewColumn *column = gtk_tree_view_get_column( GTK_TREE_VIEW(data->LV_report), 0); + gtk_tree_view_column_set_title(column, _(CYA_STATSELECT[tmpfor])); + gtk_tree_view_columns_autosize (GTK_TREE_VIEW(data->LV_report)); /* Re-attach model to view */ @@ -1136,37 +1258,78 @@ next1: static void ui_repdist_sensitive(GtkWidget *widget, gpointer user_data) { struct ui_repdist_data *data; -gboolean active; -gboolean sensitive; +GtkAction *action; +gboolean visible, sensitive; gint page; DB( g_print("\n[repdist] sensitive\n") ); data = g_object_get_data(G_OBJECT(gtk_widget_get_ancestor(widget, GTK_TYPE_WINDOW)), "inst_data"); - active = gtk_tree_selection_get_selected(gtk_tree_view_get_selection(GTK_TREE_VIEW(data->LV_report)), NULL, NULL); - page = gtk_notebook_get_current_page(GTK_NOTEBOOK(data->GR_result)); - sensitive = page == 0 ? active : FALSE; -// gtk_widget_set_sensitive(data->TB_buttons[ACTION_REPBUDGET_DETAIL], sensitive); - gtk_action_set_sensitive(gtk_ui_manager_get_action(data->ui, "/ToolBar/Detail"), sensitive); + visible = page == 0 ? TRUE : FALSE; + action = gtk_ui_manager_get_action(data->ui, "/ToolBar/Detail"); + gtk_action_set_visible (action, visible); + //sensitive = gtk_tree_selection_get_selected(gtk_tree_view_get_selection(GTK_TREE_VIEW(data->LV_report)), NULL, NULL); + //gtk_action_set_sensitive(action, sensitive); + //action = gtk_ui_manager_get_action(data->ui, "/ToolBar/Export"); + //gtk_action_set_visible (action, visible); + hb_widget_visible (data->BT_export, visible); - //view = gtk_combo_box_get_active(GTK_COMBO_BOX(data->CY_view)); + visible = page == 0 ? FALSE : TRUE; + //todo: don't display for pie chart (get the type form chart) + + hb_widget_visible(data->LB_zoomx, visible); + hb_widget_visible(data->RG_zoomx, visible); + visible = page == 0 ? FALSE : TRUE; + gtk_action_set_visible(gtk_ui_manager_get_action(data->ui, "/ToolBar/Legend"), visible); - sensitive = page == 0 ? FALSE : TRUE; - gtk_widget_set_sensitive(data->RG_zoomx, sensitive); -// gtk_widget_set_sensitive(data->TB_buttons[ACTION_REPBUDGET_LEGEND], sensitive); - gtk_action_set_sensitive(gtk_ui_manager_get_action(data->ui, "/ToolBar/Legend"), sensitive); + visible = page == 0 ? TRUE : FALSE; + gtk_action_set_visible(gtk_ui_manager_get_action(data->ui, "/ToolBar/Rate"), visible); + + sensitive = gtk_tree_model_iter_n_children(gtk_tree_view_get_model(GTK_TREE_VIEW(data->LV_detail)), NULL) > 0 ? TRUE : FALSE; + gtk_widget_set_sensitive(data->MI_detailtoclip, sensitive); + gtk_widget_set_sensitive(data->MI_detailtocsv, sensitive); +} - sensitive = page == 0 ? TRUE : FALSE; - gtk_action_set_sensitive(gtk_ui_manager_get_action(data->ui, "/ToolBar/Rate"), sensitive); +static void ui_repdist_detail_onRowActivated (GtkTreeView *treeview, + GtkTreePath *path, + GtkTreeViewColumn *col, + gpointer userdata) +{ +struct ui_repdist_data *data; +Transaction *active_txn; +gboolean result; + data = g_object_get_data(G_OBJECT(gtk_widget_get_ancestor(GTK_WIDGET(treeview), GTK_TYPE_WINDOW)), "inst_data"); + + DB( g_print ("\n[repdist] A detail row has been double-clicked!\n") ); + + active_txn = list_txn_get_active_transaction(GTK_TREE_VIEW(data->LV_detail)); + if(active_txn) + { + Transaction *old_txn, *new_txn; + + old_txn = da_transaction_clone (active_txn); + new_txn = active_txn; + result = deftransaction_external_edit(GTK_WINDOW(data->window), old_txn, new_txn); + + if(result == GTK_RESPONSE_ACCEPT) + { + //#1640885 + GLOBALS->changes_count++; + ui_repdist_compute(data->window, NULL); + } + + da_transaction_free (old_txn); + } } + static void ui_repdist_update_detail(GtkWidget *widget, gpointer user_data) { struct ui_repdist_data *data; @@ -1214,7 +1377,7 @@ struct ui_repdist_data *data; data->detail ^= 1; - DB( printf("\n[repdist] toggledetail to %d\n", data->detail) ); + DB( g_print("\n[repdist] toggledetail to %d\n", data->detail) ); ui_repdist_update_detail(widget, user_data); @@ -1311,6 +1474,12 @@ static void ui_repdist_setup(struct ui_repdist_data *data) { DB( g_print("\n[repdist] setup\n") ); + data->txn_queue = g_queue_new (); + + data->filter = da_filter_malloc(); + filter_default_all_set(data->filter); + + data->detail = PREFS->stat_showdetail; data->legend = 1; data->rate = PREFS->stat_showrate^1; @@ -1319,23 +1488,14 @@ static void ui_repdist_setup(struct ui_repdist_data *data) ui_repdist_toggle_rate(data->window, NULL); - data->filter = da_filter_malloc(); - filter_default_all_set(data->filter); /* 3.4 : make int transfer out of stats */ data->filter->option[FILTER_PAYMODE] = 1; data->filter->paymode[PAYMODE_INTXFER] = FALSE; - filter_preset_daterange_set(data->filter, PREFS->date_range_rep); + filter_preset_daterange_set(data->filter, PREFS->date_range_rep, 0); - g_signal_handler_block(data->PO_mindate, data->handler_id[HID_REPDIST_MINDATE]); - g_signal_handler_block(data->PO_maxdate, data->handler_id[HID_REPDIST_MAXDATE]); - - gtk_dateentry_set_date(GTK_DATE_ENTRY(data->PO_mindate), data->filter->mindate); - gtk_dateentry_set_date(GTK_DATE_ENTRY(data->PO_maxdate), data->filter->maxdate); - - g_signal_handler_unblock(data->PO_mindate, data->handler_id[HID_REPDIST_MINDATE]); - g_signal_handler_unblock(data->PO_maxdate, data->handler_id[HID_REPDIST_MAXDATE]); + ui_repdist_update_date_widget(data->window, NULL); } @@ -1352,7 +1512,6 @@ guint key = -1; if (gtk_tree_selection_get_selected(treeselection, &model, &iter)) { gtk_tree_model_get(model, &iter, LST_REPDIST_KEY, &key, -1); - } DB( g_print(" - active is %d\n", key) ); @@ -1372,6 +1531,8 @@ struct WinGeometry *wg; DB( g_print("\n[repdist] dispose\n") ); + g_queue_free (data->txn_queue); + da_filter_free(data->filter); g_free(data); @@ -1397,8 +1558,8 @@ GtkWidget *ui_repdist_window_new(void) { struct ui_repdist_data *data; struct WinGeometry *wg; -GtkWidget *window, *mainvbox, *hbox, *vbox, *notebook, *treeview; -GtkWidget *label, *widget, *table, *alignment, *entry; +GtkWidget *window, *mainvbox, *hbox, *vbox, *notebook, *treeview, *vpaned, *sw; +GtkWidget *label, *widget, *table, *entry; gint row; GtkUIManager *ui; GtkActionGroup *actions; @@ -1413,7 +1574,7 @@ GError *error = NULL; //disable define windows GLOBALS->define_off++; - ui_mainwindow_update(GLOBALS->mainwindow, GINT_TO_POINTER(2)); + ui_mainwindow_update(GLOBALS->mainwindow, GINT_TO_POINTER(UF_SENSITIVE)); /* create window, etc */ window = gtk_window_new (GTK_WINDOW_TOPLEVEL); @@ -1421,143 +1582,143 @@ GError *error = NULL; //store our window private data g_object_set_data(G_OBJECT(window), "inst_data", (gpointer)data); + DB( g_print(" - new window=%p, inst_data=%p\n", window, data) ); gtk_window_set_title (GTK_WINDOW (window), _("Statistics Report")); + //set the window icon - //homebank_window_set_icon_from_file(GTK_WINDOW (window), "report_stats.svg"); - gtk_window_set_icon_name(GTK_WINDOW (window), HB_STOCK_REP_STATS); + gtk_window_set_icon_name(GTK_WINDOW (window), ICONNAME_HB_REP_STATS); //window contents - mainvbox = gtk_vbox_new (FALSE, 0); + mainvbox = gtk_box_new (GTK_ORIENTATION_VERTICAL, 0); gtk_container_add (GTK_CONTAINER (window), mainvbox); - hbox = gtk_hbox_new(FALSE, 0); + hbox = gtk_box_new(GTK_ORIENTATION_HORIZONTAL, 0); gtk_box_pack_start (GTK_BOX (mainvbox), hbox, TRUE, TRUE, 0); //control part - table = gtk_table_new (6, 3, FALSE); - // gtk_alignment_new(xalign, yalign, xscale, yscale) - alignment = gtk_alignment_new(0.0, 0.0, 0.0, 0.0); - gtk_container_add(GTK_CONTAINER(alignment), table); - gtk_box_pack_start (GTK_BOX (hbox), alignment, FALSE, FALSE, 0); + table = gtk_grid_new (); + gtk_widget_set_hexpand (GTK_WIDGET(table), FALSE); + gtk_box_pack_start (GTK_BOX (hbox), table, FALSE, FALSE, 0); - gtk_container_set_border_width (GTK_CONTAINER (table), HB_BOX_SPACING); - gtk_table_set_row_spacings (GTK_TABLE (table), HB_TABROW_SPACING); - gtk_table_set_col_spacings (GTK_TABLE (table), HB_TABCOL_SPACING); + gtk_container_set_border_width (GTK_CONTAINER (table), SPACING_SMALL); + gtk_grid_set_row_spacing (GTK_GRID (table), SPACING_SMALL); + gtk_grid_set_column_spacing (GTK_GRID (table), SPACING_MEDIUM); row = 0; - label = make_label(_("Display"), 0.0, 0.5); - gimp_label_set_attributes(GTK_LABEL(label), PANGO_ATTR_WEIGHT, PANGO_WEIGHT_BOLD, -1); - gtk_table_attach_defaults (GTK_TABLE (table), label, 0, 3, row, row+1); + label = make_label_group(_("Display")); + gtk_grid_attach (GTK_GRID (table), label, 0, row, 3, 1); row++; - label = make_label(_("_View:"), 0, 0.5); - gtk_table_attach (GTK_TABLE (table), label, 1, 2, row, row+1, (GtkAttachOptions) (GTK_FILL), (GtkAttachOptions) (0), 0, 0); + label = make_label_widget(_("_View:")); + gtk_grid_attach (GTK_GRID (table), label, 1, row, 1, 1); widget = make_cycle(label, CYA_KIND2); data->CY_view = widget; - gtk_table_attach_defaults (GTK_TABLE (table), widget, 2, 3, row, row+1); + gtk_grid_attach (GTK_GRID (table), widget, 2, row, 1, 1); row++; - label = make_label(_("_By:"), 0, 0.5); - gtk_table_attach (GTK_TABLE (table), label, 1, 2, row, row+1, (GtkAttachOptions) (GTK_FILL), (GtkAttachOptions) (0), 0, 0); + label = make_label_widget(_("_By:")); + gtk_grid_attach (GTK_GRID (table), label, 1, row, 1, 1); widget = make_cycle(label, CYA_STATSELECT); data->CY_by = widget; - gtk_table_attach_defaults (GTK_TABLE (table), data->CY_by, 2, 3, row, row+1); + gtk_grid_attach (GTK_GRID (table), data->CY_by, 2, row, 1, 1); row++; widget = gtk_check_button_new_with_mnemonic (_("By _amount")); data->CM_byamount = widget; - gtk_table_attach_defaults (GTK_TABLE (table), widget, 1, 3, row, row+1); + gtk_grid_attach (GTK_GRID (table), widget, 2, row, 1, 1); row++; - widget = gtk_check_button_new_with_mnemonic (_("_Minor currency")); + widget = gtk_check_button_new_with_mnemonic (_("Euro _minor")); data->CM_minor = widget; - gtk_table_attach_defaults (GTK_TABLE (table), widget, 1, 3, row, row+1); + gtk_grid_attach (GTK_GRID (table), widget, 2, row, 1, 1); row++; - label = make_label(_("_Zoom X:"), 0, 0.5); - gtk_table_attach (GTK_TABLE (table), label, 1, 2, row, row+1, (GtkAttachOptions) (GTK_FILL), (GtkAttachOptions) (0), 0, 0); + label = make_label_widget(_("_Zoom X:")); + data->LB_zoomx = label; + gtk_grid_attach (GTK_GRID (table), label, 1, row, 1, 1); widget = make_scale(label); data->RG_zoomx = widget; - gtk_table_attach_defaults (GTK_TABLE (table), widget, 2, 3, row, row+1); + gtk_grid_attach (GTK_GRID (table), widget, 2, row, 1, 1); /* row++; widget = gtk_check_button_new_with_mnemonic ("Legend"); data->CM_legend = widget; - gtk_table_attach_defaults (GTK_TABLE (table), widget, 1, 2, row, row+1); + gtk_grid_attach (GTK_GRID (table), widget, 1, 2, row, row+1); */ row++; - widget = gtk_hseparator_new(); - gtk_table_attach_defaults (GTK_TABLE (table), widget, 0, 3, row, row+1); + widget = gtk_separator_new(GTK_ORIENTATION_HORIZONTAL); + gtk_grid_attach (GTK_GRID (table), widget, 0, row, 3, 1); row++; - label = make_label(_("Date filter"), 0.0, 0.5); - gimp_label_set_attributes(GTK_LABEL(label), PANGO_ATTR_WEIGHT, PANGO_WEIGHT_BOLD, -1); - gtk_table_attach_defaults (GTK_TABLE (table), label, 0, 3, row, row+1); + label = make_label_group(_("Date filter")); + gtk_grid_attach (GTK_GRID (table), label, 0, row, 3, 1); row++; - label = make_label(_("_Range:"), 0, 0.5); - gtk_table_attach (GTK_TABLE (table), label, 1, 2, row, row+1, (GtkAttachOptions) (GTK_FILL), (GtkAttachOptions) (0), 0, 0); + label = make_label_widget(_("_Range:")); + gtk_grid_attach (GTK_GRID (table), label, 1, row, 1, 1); data->CY_range = make_daterange(label, TRUE); - gtk_table_attach_defaults (GTK_TABLE (table), data->CY_range, 2, 3, row, row+1); + gtk_grid_attach (GTK_GRID (table), data->CY_range, 2, row, 1, 1); row++; - label = make_label(_("_From:"), 0, 0.5); - gtk_table_attach (GTK_TABLE (table), label, 1, 2, row, row+1, (GtkAttachOptions) (GTK_FILL), (GtkAttachOptions) (0), 0, 0); - data->PO_mindate = gtk_dateentry_new(); - gtk_table_attach_defaults (GTK_TABLE (table), data->PO_mindate, 2, 3, row, row+1); + label = make_label_widget(_("_From:")); + gtk_grid_attach (GTK_GRID (table), label, 1, row, 1, 1); + data->PO_mindate = gtk_date_entry_new(); + gtk_grid_attach (GTK_GRID (table), data->PO_mindate, 2, row, 1, 1); row++; - label = make_label(_("_To:"), 0, 0.5); - gtk_table_attach (GTK_TABLE (table), label, 1, 2, row, row+1, (GtkAttachOptions) (GTK_FILL), (GtkAttachOptions) (0), 0, 0); - data->PO_maxdate = gtk_dateentry_new(); - gtk_table_attach_defaults (GTK_TABLE (table), data->PO_maxdate, 2, 3, row, row+1); + label = make_label_widget(_("_To:")); + gtk_grid_attach (GTK_GRID (table), label, 1, row, 1, 1); + data->PO_maxdate = gtk_date_entry_new(); + gtk_grid_attach (GTK_GRID (table), data->PO_maxdate, 2, row, 1, 1); //part: info + report - vbox = gtk_vbox_new (FALSE, 0); + vbox = gtk_box_new (GTK_ORIENTATION_VERTICAL, 0); gtk_box_pack_start (GTK_BOX (hbox), vbox, TRUE, TRUE, 0); //ui manager - actions = gtk_action_group_new ("Account"); + actions = gtk_action_group_new ("default"); //as we use gettext gtk_action_group_set_translation_domain(actions, GETTEXT_PACKAGE); // data to action callbacks is set here (data) + gtk_action_group_add_radio_actions (actions, radio_entries, n_radio_entries, 0, G_CALLBACK(ui_repdist_action_mode), data); + gtk_action_group_add_actions (actions, entries, n_entries, data); - gtk_action_group_add_toggle_actions (actions, + gtk_action_group_add_toggle_actions (actions, toggle_entries, n_toggle_entries, data); /* set which action should have priority in the toolbar */ - action = gtk_action_group_get_action(actions, "List"); - g_object_set(action, "is_important", TRUE, NULL); + //action = gtk_action_group_get_action(actions, "List"); + //g_object_set(action, "is_important", TRUE, NULL); - action = gtk_action_group_get_action(actions, "Bar"); - g_object_set(action, "is_important", TRUE, NULL); + //action = gtk_action_group_get_action(actions, "Column"); + //g_object_set(action, "is_important", TRUE, NULL); - action = gtk_action_group_get_action(actions, "Pie"); - g_object_set(action, "is_important", TRUE, NULL); + //action = gtk_action_group_get_action(actions, "Donut"); + //g_object_set(action, "is_important", TRUE, NULL); action = gtk_action_group_get_action(actions, "Detail"); - g_object_set(action, "is_important", TRUE, NULL); + //g_object_set(action, "is_important", TRUE, NULL); g_object_set(action, "active", PREFS->stat_showdetail, NULL); action = gtk_action_group_get_action(actions, "Rate"); g_object_set(action, "active", PREFS->stat_showrate, NULL); - action = gtk_action_group_get_action(actions, "Filter"); - g_object_set(action, "is_important", TRUE, NULL); + //action = gtk_action_group_get_action(actions, "Filter"); + //g_object_set(action, "is_important", TRUE, NULL); - action = gtk_action_group_get_action(actions, "Refresh"); - g_object_set(action, "is_important", TRUE, NULL); + //action = gtk_action_group_get_action(actions, "Refresh"); + //g_object_set(action, "is_important", TRUE, NULL); ui = gtk_ui_manager_new (); @@ -1577,9 +1738,50 @@ GError *error = NULL; data->TB_bar = gtk_ui_manager_get_widget (ui, "/ToolBar"); gtk_box_pack_start (GTK_BOX (vbox), data->TB_bar, FALSE, FALSE, 0); + //add export menu button + GtkToolItem *toolitem; + GtkWidget *menu, *menuitem, *image; + + menu = gtk_menu_new (); + //gtk_widget_set_halign (menu, GTK_ALIGN_END); + + menuitem = gtk_menu_item_new_with_mnemonic (_("_Result to clipboard")); + gtk_menu_shell_append (GTK_MENU_SHELL (menu), menuitem); + g_signal_connect (G_OBJECT (menuitem), "activate", G_CALLBACK (ui_repdist_export_result_clipboard), data); + + menuitem = gtk_menu_item_new_with_mnemonic (_("_Result to CSV")); + gtk_menu_shell_append (GTK_MENU_SHELL (menu), menuitem); + g_signal_connect (G_OBJECT (menuitem), "activate", G_CALLBACK (ui_repdist_export_result_csv), data); + + menuitem = gtk_menu_item_new_with_mnemonic (_("_Detail to clipboard")); + data->MI_detailtoclip = menuitem; + gtk_menu_shell_append (GTK_MENU_SHELL (menu), menuitem); + g_signal_connect (G_OBJECT (menuitem), "activate", G_CALLBACK (ui_repdist_export_detail_clipboard), data); + + menuitem = gtk_menu_item_new_with_mnemonic (_("_Detail to CSV")); + data->MI_detailtocsv = menuitem; + gtk_menu_shell_append (GTK_MENU_SHELL (menu), menuitem); + g_signal_connect (G_OBJECT (menuitem), "activate", G_CALLBACK (ui_repdist_export_detail_csv), data); + + gtk_widget_show_all (menu); + + widget = gtk_menu_button_new(); + data->BT_export = widget; + gtk_style_context_add_class (gtk_widget_get_style_context (GTK_WIDGET(widget)), GTK_STYLE_CLASS_FLAT); + + //gtk_menu_button_set_direction (GTK_MENU_BUTTON(widget), GTK_ARROW_DOWN); + //gtk_widget_set_halign (widget, GTK_ALIGN_END); + image = gtk_image_new_from_icon_name (ICONNAME_HB_FILE_EXPORT, GTK_ICON_SIZE_LARGE_TOOLBAR); + g_object_set (widget, "image", image, "popup", GTK_MENU(menu), NULL); + + toolitem = gtk_tool_item_new(); + gtk_container_add (GTK_CONTAINER(toolitem), widget); + gtk_toolbar_insert(GTK_TOOLBAR(data->TB_bar), GTK_TOOL_ITEM(toolitem), -1); + + //infos + balance - hbox = gtk_hbox_new (FALSE, HB_BOX_SPACING); - gtk_container_set_border_width (GTK_CONTAINER(hbox), HB_BOX_SPACING); + hbox = gtk_box_new (GTK_ORIENTATION_HORIZONTAL, SPACING_SMALL); + gtk_container_set_border_width (GTK_CONTAINER(hbox), SPACING_SMALL); gtk_box_pack_start (GTK_BOX (vbox), hbox, FALSE, FALSE, 0); widget = make_label(NULL, 0.5, 0.5); @@ -1615,37 +1817,35 @@ GError *error = NULL; gtk_notebook_set_show_border(GTK_NOTEBOOK(notebook), FALSE); gtk_box_pack_start (GTK_BOX (vbox), notebook, TRUE, TRUE, 0); - //page: list - vbox = gtk_vbox_new (FALSE, 0); - gtk_notebook_append_page(GTK_NOTEBOOK(notebook), vbox, NULL); + // page list/detail + vpaned = gtk_paned_new(GTK_ORIENTATION_VERTICAL); + gtk_notebook_append_page(GTK_NOTEBOOK(notebook), vpaned, NULL); - widget = gtk_scrolled_window_new (NULL, NULL); - //gtk_scrolled_window_set_placement(GTK_SCROLLED_WINDOW (widget), GTK_CORNER_TOP_RIGHT); - gtk_scrolled_window_set_shadow_type (GTK_SCROLLED_WINDOW (widget), GTK_SHADOW_ETCHED_IN); - gtk_scrolled_window_set_policy (GTK_SCROLLED_WINDOW (widget), GTK_POLICY_AUTOMATIC, GTK_POLICY_AUTOMATIC); + // list + sw = gtk_scrolled_window_new (NULL, NULL); + gtk_scrolled_window_set_shadow_type (GTK_SCROLLED_WINDOW (sw), GTK_SHADOW_ETCHED_IN); + gtk_scrolled_window_set_policy (GTK_SCROLLED_WINDOW (sw), GTK_POLICY_AUTOMATIC, GTK_POLICY_AUTOMATIC); treeview = ui_list_repdist_create(); data->LV_report = treeview; - gtk_container_add (GTK_CONTAINER(widget), treeview); - gtk_box_pack_start (GTK_BOX (vbox), widget, TRUE, TRUE, 0); + gtk_container_add (GTK_CONTAINER(sw), treeview); + gtk_paned_pack1 (GTK_PANED(vpaned), sw, TRUE, TRUE); //detail - widget = gtk_scrolled_window_new (NULL, NULL); - data->GR_detail = widget; - //gtk_scrolled_window_set_placement(GTK_SCROLLED_WINDOW (widget), GTK_CORNER_TOP_RIGHT); - gtk_scrolled_window_set_shadow_type (GTK_SCROLLED_WINDOW (widget), GTK_SHADOW_ETCHED_IN); - gtk_scrolled_window_set_policy (GTK_SCROLLED_WINDOW (widget), GTK_POLICY_AUTOMATIC, GTK_POLICY_AUTOMATIC); - treeview = create_list_transaction(TRN_LIST_TYPE_DETAIL, PREFS->lst_ope_columns); + sw = gtk_scrolled_window_new (NULL, NULL); + data->GR_detail = sw; + //gtk_scrolled_window_set_placement(GTK_SCROLLED_WINDOW (sw), GTK_CORNER_TOP_RIGHT); + gtk_scrolled_window_set_shadow_type (GTK_SCROLLED_WINDOW (sw), GTK_SHADOW_ETCHED_IN); + gtk_scrolled_window_set_policy (GTK_SCROLLED_WINDOW (sw), GTK_POLICY_AUTOMATIC, GTK_POLICY_AUTOMATIC); + treeview = create_list_transaction(LIST_TXN_TYPE_DETAIL, PREFS->lst_ope_columns); data->LV_detail = treeview; - gtk_container_add (GTK_CONTAINER(widget), treeview); + gtk_container_add (GTK_CONTAINER(sw), treeview); + gtk_paned_pack2 (GTK_PANED(vpaned), sw, TRUE, TRUE); - gtk_box_pack_start (GTK_BOX (vbox), widget, TRUE, TRUE, 0); - - - //page: 2d bar/pie + //page: 2d bar /pie widget = gtk_chart_new(CHART_TYPE_COL); data->RE_chart = widget; gtk_chart_set_minor_prefs(GTK_CHART(widget), PREFS->euro_value, PREFS->minor_cur.symbol); - //gtk_chart_set_currency(GTK_CHART(widget), GLOBALS->kcur); + gtk_chart_set_currency(GTK_CHART(widget), GLOBALS->kcur); gtk_notebook_append_page(GTK_NOTEBOOK(notebook), widget, NULL); //todo: setup should move this @@ -1678,6 +1878,7 @@ GError *error = NULL; g_signal_connect (gtk_tree_view_get_selection(GTK_TREE_VIEW(data->LV_report)), "changed", G_CALLBACK (ui_repdist_selection), NULL); + g_signal_connect (GTK_TREE_VIEW(data->LV_detail), "row-activated", G_CALLBACK (ui_repdist_detail_onRowActivated), NULL); //setup, init and show window ui_repdist_setup(data); @@ -1726,6 +1927,53 @@ GError *error = NULL; ** ============================================================================ */ + +static GString *ui_list_repdist_to_string(GtkTreeView *treeview, gboolean clipboard) +{ +GString *node; +GtkTreeModel *model; +GtkTreeIter iter; +gboolean valid; +const gchar *format; + + node = g_string_new(NULL); + + // header + format = (clipboard == TRUE) ? "%s\t%s\t%s\t%s\n" : "%s;%s;%s;%s\n"; + g_string_append_printf(node, format, _("Result"), _("Expense"), _("Income"), _("Balance")); + + model = gtk_tree_view_get_model(treeview); + valid = gtk_tree_model_get_iter_first(GTK_TREE_MODEL(model), &iter); + while (valid) + { + gchar *name; + gdouble exp, inc, bal; + + gtk_tree_model_get (model, &iter, + //LST_REPDIST_KEY, i, + LST_REPDIST_NAME , &name, + LST_REPDIST_EXPENSE, &exp, + LST_REPDIST_INCOME , &inc, + LST_REPDIST_BALANCE, &bal, + -1); + + format = (clipboard == TRUE) ? "%s\t%.2f\t%.2f\t%.2f\n" : "%s;%.2f;%.2f;%.2f\n"; + g_string_append_printf(node, format, name, exp, inc, bal); + + //leak + g_free(name); + + valid = gtk_tree_model_iter_next(GTK_TREE_MODEL(model), &iter); + } + + //DB( g_print("text is:\n%s", node->str) ); + + return node; +} + + + + static void ui_list_repdist_rate_cell_data_function (GtkTreeViewColumn *col, GtkCellRenderer *renderer, GtkTreeModel *model, @@ -1768,8 +2016,7 @@ gchar buf[G_ASCII_DTOSTR_BUF_SIZE]; if( value ) { - mystrfmon(buf, G_ASCII_DTOSTR_BUF_SIZE-1, value, GLOBALS->minor); - //hb_strfmon(buf, G_ASCII_DTOSTR_BUF_SIZE-1, value, GLOBALS->kcur); + hb_strfmon(buf, G_ASCII_DTOSTR_BUF_SIZE-1, value, GLOBALS->kcur, GLOBALS->minor); color = get_normal_color_amount(value); @@ -1849,7 +2096,7 @@ GtkTreeViewColumn *column; view = gtk_tree_view_new_with_model(GTK_TREE_MODEL(store)); g_object_unref(store); - gtk_tree_view_set_rules_hint (GTK_TREE_VIEW (view), PREFS->rules_hint); + gtk_tree_view_set_grid_lines (GTK_TREE_VIEW (view), PREFS->grid_lines); /* column: Name */ column = gtk_tree_view_column_new();