From 0837f5ba8194a4124d86a4f632abbdbb4a580b5a Mon Sep 17 00:00:00 2001 From: Andrea Zagli Date: Tue, 26 Oct 2010 16:29:09 +0200 Subject: [PATCH] Ricerche varie (da maschera e su digitazione). --- data/territorio/form/Makefile.am | 3 + data/territorio/form/ricerca_comuni.form | 24 + data/territorio/form/ricerca_province.form | 24 + data/territorio/form/ricerca_vie.form | 24 + data/territorio/gui/territorio.gui | 541 ++++++++++++++++++++- libreria/Makefile.am | 6 + src/Makefile.am | 6 + src/comuni.c | 82 +++- src/province.c | 84 +++- src/ricercacomuni.c | 257 ++++++++++ src/ricercacomuni.h | 66 +++ src/ricercaprovince.c | 257 ++++++++++ src/ricercaprovince.h | 66 +++ src/ricercavie.c | 257 ++++++++++ src/ricercavie.h | 66 +++ src/vie.c | 108 +++- 16 files changed, 1844 insertions(+), 27 deletions(-) create mode 100644 data/territorio/form/ricerca_comuni.form create mode 100644 data/territorio/form/ricerca_province.form create mode 100644 data/territorio/form/ricerca_vie.form create mode 100644 src/ricercacomuni.c create mode 100644 src/ricercacomuni.h create mode 100644 src/ricercaprovince.c create mode 100644 src/ricercaprovince.h create mode 100644 src/ricercavie.c create mode 100644 src/ricercavie.h diff --git a/data/territorio/form/Makefile.am b/data/territorio/form/Makefile.am index 0c41989..b726183 100644 --- a/data/territorio/form/Makefile.am +++ b/data/territorio/form/Makefile.am @@ -5,6 +5,9 @@ form_DATA = \ comune.form \ provincia.form \ regione.form \ + ricerca_comuni.form \ + ricerca_province.form \ + ricerca_vie.form \ stato.form \ tipo_aggregazione_territoriale.form \ via.form diff --git a/data/territorio/form/ricerca_comuni.form b/data/territorio/form/ricerca_comuni.form new file mode 100644 index 0000000..44123f4 --- /dev/null +++ b/data/territorio/form/ricerca_comuni.form @@ -0,0 +1,24 @@ + + + + + + + + + + + + + + + + entry22 + + SELECT nome FROM province WHERE id = ##label48::gint + + + + + + diff --git a/data/territorio/form/ricerca_province.form b/data/territorio/form/ricerca_province.form new file mode 100644 index 0000000..f895067 --- /dev/null +++ b/data/territorio/form/ricerca_province.form @@ -0,0 +1,24 @@ + + + + + + + + + + + + + + + + entry23 + + SELECT nome FROM regioni WHERE id = ##label60::gint + + + + + + diff --git a/data/territorio/form/ricerca_vie.form b/data/territorio/form/ricerca_vie.form new file mode 100644 index 0000000..600431d --- /dev/null +++ b/data/territorio/form/ricerca_vie.form @@ -0,0 +1,24 @@ + + + + + + + + + + + + + + + + entry25 + + SELECT nome FROM comuni WHERE id = ##label51::gint + + + + + + diff --git a/data/territorio/gui/territorio.gui b/data/territorio/gui/territorio.gui index 72e1a49..5fcb62f 100644 --- a/data/territorio/gui/territorio.gui +++ b/data/territorio/gui/territorio.gui @@ -326,6 +326,7 @@ True True lstore_stati + 1 Nome @@ -692,6 +693,7 @@ True True lstore_regioni + 1 Nome @@ -974,6 +976,7 @@ True True lstore_province + 1 Nome @@ -1039,6 +1042,20 @@ 2 + + + gtk-find + True + True + True + True + + + False + False + 3 + + gtk-cancel @@ -1050,7 +1067,7 @@ False False - 3 + 4 @@ -1064,7 +1081,7 @@ False False - 4 + 5 @@ -1342,6 +1359,7 @@ True True lstore_comuni + 1 Nome @@ -1407,6 +1425,20 @@ 2 + + + gtk-find + True + True + True + True + + + False + False + 3 + + gtk-cancel @@ -1418,7 +1450,7 @@ False False - 3 + 4 @@ -1432,7 +1464,7 @@ False False - 4 + 5 @@ -2130,6 +2162,7 @@ True 150 ● + uu 1 @@ -2255,7 +2288,7 @@ True lstore_vie False - 0 + 1 Nome @@ -2321,6 +2354,20 @@ 2 + + + gtk-find + True + True + True + True + + + False + False + 3 + + gtk-cancel @@ -2332,7 +2379,7 @@ False False - 3 + 4 @@ -2346,7 +2393,7 @@ False False - 4 + 5 @@ -2560,4 +2607,484 @@ + + Ricerca province - Territorio + True + center-on-parent + True + + + True + 5 + vertical + 5 + + + True + 2 + 2 + 5 + 5 + + + True + 0 + Nome + + + GTK_FILL + GTK_FILL + + + + + True + True + ● + + + 1 + 2 + GTK_FILL + + + + + True + 0 + Regione + + + 1 + 2 + GTK_FILL + GTK_FILL + + + + + True + 5 + + + True + True + False + ● + + + 0 + + + + + ... + True + True + True + + + False + 1 + + + + + lbl_id_regioni + + + False + 2 + + + + + 1 + 2 + 1 + 2 + GTK_FILL + + + + + 0 + + + + + True + 5 + end + + + gtk-clear + True + True + True + True + + + False + False + 0 + + + + + gtk-cancel + True + True + True + True + + + False + False + 1 + + + + + gtk-ok + True + True + True + True + + + False + False + 2 + + + + + False + 1 + + + + + + + Ricerca comuni - Territorio + True + center-on-parent + True + + + True + 5 + vertical + 5 + + + True + 2 + 2 + 5 + 5 + + + True + 0 + Nome + + + GTK_FILL + GTK_FILL + + + + + True + True + ● + + + 1 + 2 + GTK_FILL + + + + + True + 0 + Provincia + + + 1 + 2 + GTK_FILL + GTK_FILL + + + + + True + 5 + + + True + True + False + ● + + + 0 + + + + + ... + True + True + True + + + False + 1 + + + + + lbl_id_province + + + False + 2 + + + + + 1 + 2 + 1 + 2 + GTK_FILL + + + + + 0 + + + + + True + 5 + end + + + gtk-clear + True + True + True + True + + + False + False + 0 + + + + + gtk-cancel + True + True + True + True + + + False + False + 1 + + + + + gtk-ok + True + True + True + True + + + False + False + 2 + + + + + False + 1 + + + + + + + Ricerca vie - Territorio + True + center-on-parent + True + + + True + 5 + vertical + 5 + + + True + 2 + 2 + 5 + 5 + + + True + 0 + Nome + + + GTK_FILL + GTK_FILL + + + + + True + True + ● + + + 1 + 2 + GTK_FILL + + + + + True + 0 + Comune + + + 1 + 2 + GTK_FILL + GTK_FILL + + + + + True + 5 + + + True + True + False + ● + + + 0 + + + + + ... + True + True + True + + + False + 1 + + + + + lbl_id_comuni + + + False + 2 + + + + + 1 + 2 + 1 + 2 + GTK_FILL + + + + + 0 + + + + + True + 5 + end + + + gtk-clear + True + True + True + True + + + False + False + 0 + + + + + gtk-cancel + True + True + True + True + + + False + False + 1 + + + + + gtk-ok + True + True + True + True + + + False + False + 2 + + + + + False + 1 + + + + + diff --git a/libreria/Makefile.am b/libreria/Makefile.am index 1a65d2b..f2d2a93 100644 --- a/libreria/Makefile.am +++ b/libreria/Makefile.am @@ -19,6 +19,9 @@ libterritorio_la_SOURCES = \ ../src/provincia.c \ ../src/regione.c \ ../src/regioni.c \ + ../src/ricercacomuni.c \ + ../src/ricercaprovince.c \ + ../src/ricercavie.c \ ../src/stati.c \ ../src/stato.c \ ../src/tipiaggregazioneterritoriale.c \ @@ -36,6 +39,9 @@ libterritorio_include_HEADERS = \ ../src/comuni.h \ ../src/province.h \ ../src/provincia.h \ + ../src/ricercacomuni.h \ + ../src/ricercaprovince.h \ + ../src/ricercavie.h \ ../src/regione.h \ ../src/regioni.h \ ../src/stati.h \ diff --git a/src/Makefile.am b/src/Makefile.am index 150878b..4531b14 100644 --- a/src/Makefile.am +++ b/src/Makefile.am @@ -31,6 +31,12 @@ territorio_SOURCES = \ regione.h \ regioni.c \ regioni.h \ + ricercacomuni.c \ + ricercacomuni.h \ + ricercaprovince.c \ + ricercaprovince.h \ + ricercavie.c \ + ricercavie.h \ stati.c \ stati.h \ stato.c \ diff --git a/src/comuni.c b/src/comuni.c index fc4e760..f9beb33 100644 --- a/src/comuni.c +++ b/src/comuni.c @@ -19,6 +19,7 @@ #include "comuni.h" #include "comune.h" +#include "ricercacomuni.h" static void territorio_comuni_class_init (TerritorioComuniClass *klass); static void territorio_comuni_init (TerritorioComuni *territorio_comuni); @@ -29,6 +30,8 @@ static void territorio_comuni_modifica (TerritorioComuni *territorio_comuni); static void territorio_comuni_selezionato (TerritorioComuni *territorio_comuni); static void territorio_comuni_on_comune_aggiornato (gpointer instance, gpointer user_data); +static void territorio_comuni_on_filtra (gpointer instance, gpointer parametri, gpointer user_data); + static void territorio_comuni_set_property (GObject *object, guint property_id, const GValue *value, @@ -49,6 +52,9 @@ static void territorio_comuni_on_trv_territorio_comuni_row_activated (GtkTreeVie GtkTreeViewColumn *column, gpointer user_data); +static void territorio_comuni_on_btn_trova_clicked (GtkButton *button, + gpointer user_data); + static void territorio_comuni_on_btn_annulla_clicked (GtkButton *button, gpointer user_data); static void territorio_comuni_on_btn_seleziona_clicked (GtkButton *button, @@ -71,6 +77,8 @@ struct _TerritorioComuniPrivate GtkTreeSelection *selection; GtkListStore *lstore_comuni; + GHashTable *parametri_ricerca; + gboolean selezione; GtkWindow *wtransient; }; @@ -161,6 +169,8 @@ TerritorioComuni "clicked", G_CALLBACK (territorio_comuni_on_btn_elimina_clicked), (gpointer)a); g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "treeview4"), "row-activated", G_CALLBACK (territorio_comuni_on_trv_territorio_comuni_row_activated), (gpointer)a); + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button58"), + "clicked", G_CALLBACK (territorio_comuni_on_btn_trova_clicked), (gpointer)a); if (priv->selezione) { @@ -201,6 +211,13 @@ territorio_comuni_carica (TerritorioComuni *territorio_comuni) GtkTreeIter iter; GdaDataModel *dm; + gchar *sql; + gchar *sql_where; + + GValue *gvalue; + gchar *gcval; + gint ival; + gint rows; gint row; @@ -208,11 +225,33 @@ territorio_comuni_carica (TerritorioComuni *territorio_comuni) gtk_list_store_clear (priv->lstore_comuni); - dm = gdaex_query (priv->commons->gdaex, - "SELECT c.id, c.nome" - " FROM comuni AS c" - " WHERE c.status <> 'E'" - " ORDER BY c.nome"); + sql_where = g_strdup (""); + if (priv->parametri_ricerca != NULL) + { + gcval = g_strstrip ((gchar *)g_value_get_string ((GValue *)g_hash_table_lookup (priv->parametri_ricerca, "nome"))); + if (g_strcmp0 (gcval, "") != 0) + { + sql_where = g_strconcat (sql_where, " AND c.nome ILIKE '%", + g_strdup_printf ("%s", gcval), + "%'", + NULL); + } + ival = g_value_get_int ((GValue *)g_hash_table_lookup (priv->parametri_ricerca, "id_province")); + if (ival != 0) + { + sql_where = g_strconcat (sql_where, " AND c.id_province = ", + g_strdup_printf ("%d", ival), + NULL); + } + } + + sql = g_strdup_printf ("SELECT c.id, c.nome" + " FROM comuni AS c" + " WHERE c.status <> 'E'" + "%s" + " ORDER BY c.nome", + sql_where); + dm = gdaex_query (priv->commons->gdaex, sql); if (dm != NULL) { rows = gda_data_model_get_n_rows (dm); @@ -261,7 +300,7 @@ territorio_comuni_modifica (TerritorioComuni *territorio_comuni) GTK_DIALOG_DESTROY_WITH_PARENT, GTK_MESSAGE_WARNING, GTK_BUTTONS_OK, - "Occorre prima selezionare un comune"); + "Occorre prima selezionare un comune."); gtk_dialog_run (GTK_DIALOG (dialog)); gtk_widget_destroy (dialog); } @@ -293,7 +332,7 @@ territorio_comuni_selezionato (TerritorioComuni *territorio_comuni) GTK_DIALOG_DESTROY_WITH_PARENT, GTK_MESSAGE_WARNING, GTK_BUTTONS_OK, - "Occorre prima selezionare un comune"); + "Occorre prima selezionare un comune."); gtk_dialog_run (GTK_DIALOG (dialog)); gtk_widget_destroy (dialog); } @@ -305,6 +344,17 @@ territorio_comuni_on_comune_aggiornato (gpointer instance, gpointer user_data) territorio_comuni_carica ((TerritorioComuni *)user_data); } +static void +territorio_comuni_on_filtra (gpointer instance, gpointer parametri, gpointer user_data) +{ + TerritorioComuni *i = (TerritorioComuni *)user_data; + TerritorioComuniPrivate *priv = TERRITORIO_COMUNI_GET_PRIVATE (i); + + priv->parametri_ricerca = (GHashTable *)parametri; + + territorio_comuni_carica (i); +} + static void territorio_comuni_set_property (GObject *object, guint property_id, const GValue *value, GParamSpec *pspec) { @@ -427,6 +477,24 @@ territorio_comuni_on_trv_territorio_comuni_row_activated (GtkTreeView *tree_view } +static void +territorio_comuni_on_btn_trova_clicked (GtkButton *button, + gpointer user_data) +{ + GtkWidget *w; + + TerritorioComuniPrivate *priv = TERRITORIO_COMUNI_GET_PRIVATE ((TerritorioComuni *)user_data); + + TerritorioRicercaComuni *rf = territorio_ricerca_comuni_new (priv->commons, priv->parametri_ricerca); + + g_signal_connect (G_OBJECT (rf), "filtra", + G_CALLBACK (territorio_comuni_on_filtra), (TerritorioComuni *)user_data); + + w = territorio_ricerca_comuni_get_widget (rf); + gtk_window_set_transient_for (GTK_WINDOW (w), priv->wtransient); + gtk_widget_show (w); +} + static void territorio_comuni_on_btn_annulla_clicked (GtkButton *button, gpointer user_data) diff --git a/src/province.c b/src/province.c index ecb0607..e78e543 100644 --- a/src/province.c +++ b/src/province.c @@ -19,6 +19,7 @@ #include "province.h" #include "provincia.h" +#include "ricercaprovince.h" static void territorio_province_class_init (TerritorioProvinceClass *klass); static void territorio_province_init (TerritorioProvince *territorio_province); @@ -29,6 +30,8 @@ static void territorio_province_modifica (TerritorioProvince *territorio_provinc static void territorio_province_selezionato (TerritorioProvince *territorio_province); static void territorio_province_on_provincia_aggiornato (gpointer instance, gpointer user_data); +static void territorio_province_on_filtra (gpointer instance, gpointer parametri, gpointer user_data); + static void territorio_province_set_property (GObject *object, guint property_id, const GValue *value, @@ -49,6 +52,9 @@ static void territorio_province_on_trv_territorio_province_row_activated (GtkTre GtkTreeViewColumn *column, gpointer user_data); +static void territorio_province_on_btn_trova_clicked (GtkButton *button, + gpointer user_data); + static void territorio_province_on_btn_annulla_clicked (GtkButton *button, gpointer user_data); static void territorio_province_on_btn_seleziona_clicked (GtkButton *button, @@ -71,6 +77,8 @@ struct _TerritorioProvincePrivate GtkTreeSelection *selection; GtkListStore *lstore_province; + GHashTable *parametri_ricerca; + gboolean selezione; GtkWindow *wtransient; }; @@ -161,6 +169,8 @@ TerritorioProvince "clicked", G_CALLBACK (territorio_province_on_btn_elimina_clicked), (gpointer)a); g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "treeview3"), "row-activated", G_CALLBACK (territorio_province_on_trv_territorio_province_row_activated), (gpointer)a); + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button53"), + "clicked", G_CALLBACK (territorio_province_on_btn_trova_clicked), (gpointer)a); if (priv->selezione) { @@ -201,6 +211,13 @@ territorio_province_carica (TerritorioProvince *territorio_province) GtkTreeIter iter; GdaDataModel *dm; + gchar *sql; + gchar *sql_where; + + GValue *gvalue; + gchar *gcval; + gint ival; + gint rows; gint row; @@ -208,11 +225,34 @@ territorio_province_carica (TerritorioProvince *territorio_province) gtk_list_store_clear (priv->lstore_province); - dm = gdaex_query (priv->commons->gdaex, - "SELECT c.id, c.nome" - " FROM province AS c" - " WHERE c.status <> 'E'" - " ORDER BY c.nome"); + sql_where = g_strdup (""); + if (priv->parametri_ricerca != NULL) + { + gcval = g_strstrip ((gchar *)g_value_get_string ((GValue *)g_hash_table_lookup (priv->parametri_ricerca, "nome"))); + if (g_strcmp0 (gcval, "") != 0) + { + sql_where = g_strconcat (sql_where, " AND c.nome ILIKE '%", + g_strdup_printf ("%s", gcval), + "%'", + NULL); + } + ival = g_value_get_int ((GValue *)g_hash_table_lookup (priv->parametri_ricerca, "id_regioni")); + if (ival != 0) + { + sql_where = g_strconcat (sql_where, " AND c.id_regioni = ", + g_strdup_printf ("%d", ival), + NULL); + } + } + + sql = g_strdup_printf ("SELECT c.id, c.nome" + " FROM province AS c" + " WHERE c.status <> 'E'" + "%s" + " ORDER BY c.nome", + sql_where); + + dm = gdaex_query (priv->commons->gdaex, sql); if (dm != NULL) { rows = gda_data_model_get_n_rows (dm); @@ -261,7 +301,7 @@ territorio_province_modifica (TerritorioProvince *territorio_province) GTK_DIALOG_DESTROY_WITH_PARENT, GTK_MESSAGE_WARNING, GTK_BUTTONS_OK, - "Occorre prima selezionare una provincia"); + "Occorre prima selezionare una provincia."); gtk_dialog_run (GTK_DIALOG (dialog)); gtk_widget_destroy (dialog); } @@ -293,7 +333,7 @@ territorio_province_selezionato (TerritorioProvince *territorio_province) GTK_DIALOG_DESTROY_WITH_PARENT, GTK_MESSAGE_WARNING, GTK_BUTTONS_OK, - "Occorre prima selezionare una provincia"); + "Occorre prima selezionare una provincia."); gtk_dialog_run (GTK_DIALOG (dialog)); gtk_widget_destroy (dialog); } @@ -305,6 +345,17 @@ territorio_province_on_provincia_aggiornato (gpointer instance, gpointer user_da territorio_province_carica ((TerritorioProvince *)user_data); } +static void +territorio_province_on_filtra (gpointer instance, gpointer parametri, gpointer user_data) +{ + TerritorioProvince *i = (TerritorioProvince *)user_data; + TerritorioProvincePrivate *priv = TERRITORIO_PROVINCE_GET_PRIVATE (i); + + priv->parametri_ricerca = (GHashTable *)parametri; + + territorio_province_carica (i); +} + static void territorio_province_set_property (GObject *object, guint property_id, const GValue *value, GParamSpec *pspec) { @@ -402,7 +453,7 @@ territorio_province_on_btn_elimina_clicked (GtkButton *button, GTK_DIALOG_DESTROY_WITH_PARENT, GTK_MESSAGE_WARNING, GTK_BUTTONS_OK, - "Occorre prima selezionare una provincia"); + "Occorre prima selezionare una provincia."); gtk_dialog_run (GTK_DIALOG (dialog)); gtk_widget_destroy (dialog); } @@ -426,6 +477,23 @@ territorio_province_on_trv_territorio_province_row_activated (GtkTreeView *tree_ } } +static void +territorio_province_on_btn_trova_clicked (GtkButton *button, + gpointer user_data) +{ + GtkWidget *w; + + TerritorioProvincePrivate *priv = TERRITORIO_PROVINCE_GET_PRIVATE ((TerritorioProvince *)user_data); + + TerritorioRicercaProvince *rf = territorio_ricerca_province_new (priv->commons, priv->parametri_ricerca); + + g_signal_connect (G_OBJECT (rf), "filtra", + G_CALLBACK (territorio_province_on_filtra), (TerritorioProvince *)user_data); + + w = territorio_ricerca_province_get_widget (rf); + gtk_window_set_transient_for (GTK_WINDOW (w), priv->wtransient); + gtk_widget_show (w); +} static void territorio_province_on_btn_annulla_clicked (GtkButton *button, diff --git a/src/ricercacomuni.c b/src/ricercacomuni.c new file mode 100644 index 0000000..efe1bc7 --- /dev/null +++ b/src/ricercacomuni.c @@ -0,0 +1,257 @@ +/* + * Copyright (C) 2010 Andrea Zagli + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License as published by the Free Software Foundation; either + * version 2.1 of the License, or (at your option) any later version. + * + * This library 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 + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA + * + */ + +#include + +#include "ricercacomuni.h" +#include "province.h" + +static void territorio_ricerca_comuni_class_init (TerritorioRicercaComuniClass *klass); +static void territorio_ricerca_comuni_init (TerritorioRicercaComuni *territorio_ricerca_comuni); + +static void territorio_ricerca_comuni_set_property (GObject *object, + guint property_id, + const GValue *value, + GParamSpec *pspec); +static void territorio_ricerca_comuni_get_property (GObject *object, + guint property_id, + GValue *value, + GParamSpec *pspec); + +static void territorio_ricerca_comuni_on_provincia_selezionato (gpointer instance, guint id, gpointer user_data); + +static void territorio_ricerca_comuni_on_btn_provincia_clicked (GtkButton *button, + gpointer user_data); + +static void territorio_ricerca_comuni_on_btn_pulisci_clicked (GtkButton *button, + gpointer user_data); +static void territorio_ricerca_comuni_on_btn_annulla_clicked (GtkButton *button, + gpointer user_data); +static void territorio_ricerca_comuni_on_btn_ok_clicked (GtkButton *button, + gpointer user_data); + +#define TERRITORIO_RICERCA_COMUNI_GET_PRIVATE(obj) (G_TYPE_INSTANCE_GET_PRIVATE ((obj), TYPE_TERRITORIO_RICERCA_COMUNI, TerritorioRicercaComuniPrivate)) + +typedef struct _TerritorioRicercaComuniPrivate TerritorioRicercaComuniPrivate; +struct _TerritorioRicercaComuniPrivate + { + TerritorioCommons *commons; + + GtkForm *form; + + GtkWidget *w; + + GObject **objects; + }; + +G_DEFINE_TYPE (TerritorioRicercaComuni, territorio_ricerca_comuni, G_TYPE_OBJECT) + +static void +territorio_ricerca_comuni_class_init (TerritorioRicercaComuniClass *klass) +{ + GObjectClass *object_class = G_OBJECT_CLASS (klass); + + g_type_class_add_private (object_class, sizeof (TerritorioRicercaComuniPrivate)); + + object_class->set_property = territorio_ricerca_comuni_set_property; + object_class->get_property = territorio_ricerca_comuni_get_property; + + /** + * TerritorioRicercaComuni::filtra: + */ + klass->filtra_signal_id = g_signal_new ("filtra", + G_TYPE_FROM_CLASS (object_class), + G_SIGNAL_RUN_LAST, + 0, + NULL, + NULL, + g_cclosure_marshal_VOID__POINTER, + G_TYPE_NONE, + 1, G_TYPE_POINTER); +} + +static void +territorio_ricerca_comuni_init (TerritorioRicercaComuni *territorio_ricerca_comuni) +{ + TerritorioRicercaComuniPrivate *priv = TERRITORIO_RICERCA_COMUNI_GET_PRIVATE (territorio_ricerca_comuni); +} + +/** + * territorio_ricerca_comuni_new: + * @commons: + * @values: + * + * Returns: the newly created #TerritorioRicercaComuni object. + */ +TerritorioRicercaComuni +*territorio_ricerca_comuni_new (TerritorioCommons *commons, GHashTable *values) +{ + GError *error; + + TerritorioRicercaComuni *a = TERRITORIO_RICERCA_COMUNI (g_object_new (territorio_ricerca_comuni_get_type (), NULL)); + + TerritorioRicercaComuniPrivate *priv = TERRITORIO_RICERCA_COMUNI_GET_PRIVATE (a); + + priv->commons = commons; + + error = NULL; + gtk_builder_add_objects_from_file (priv->commons->gtkbuilder, priv->commons->guifile, + g_strsplit ("w_ricerca_comuni", "|", -1), + &error); + if (error != NULL) + { + g_warning ("Errore: %s.", error->message); + return NULL; + } + + priv->form = gtk_form_new (); + g_object_set (G_OBJECT (priv->form), "gdaex", priv->commons->gdaex, NULL); + gtk_form_load_from_file (priv->form, g_build_filename (priv->commons->formdir, "ricerca_comuni.form", NULL), priv->commons->gtkbuilder); + + priv->objects = gtk_form_get_objects_by_name (priv->form, + NULL); + + priv->w = GTK_WIDGET (gtk_builder_get_object (priv->commons->gtkbuilder, "w_ricerca_comuni")); + + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button54"), + "clicked", G_CALLBACK (territorio_ricerca_comuni_on_btn_provincia_clicked), (gpointer *)a); + + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button55"), + "clicked", G_CALLBACK (territorio_ricerca_comuni_on_btn_pulisci_clicked), (gpointer *)a); + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button56"), + "clicked", G_CALLBACK (territorio_ricerca_comuni_on_btn_annulla_clicked), (gpointer *)a); + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button57"), + "clicked", G_CALLBACK (territorio_ricerca_comuni_on_btn_ok_clicked), (gpointer *)a); + + gtk_form_clear (priv->form); + if (values != NULL) + { + gtk_form_fill_from_hashtable (priv->form, values); + } + + return a; +} + +/** + * territorio_ricerca_comuni_get_widget: + * @territorio_ricerca_comuni: + * + */ +GtkWidget +*territorio_ricerca_comuni_get_widget (TerritorioRicercaComuni *territorio_ricerca_comuni) +{ + TerritorioRicercaComuniPrivate *priv = TERRITORIO_RICERCA_COMUNI_GET_PRIVATE (territorio_ricerca_comuni); + + return priv->w; +} + +/* PRIVATE */ +static void +territorio_ricerca_comuni_set_property (GObject *object, guint property_id, const GValue *value, GParamSpec *pspec) +{ + TerritorioRicercaComuni *territorio_ricerca_comuni = TERRITORIO_RICERCA_COMUNI (object); + + TerritorioRicercaComuniPrivate *priv = TERRITORIO_RICERCA_COMUNI_GET_PRIVATE (territorio_ricerca_comuni); + + switch (property_id) + { + default: + G_OBJECT_WARN_INVALID_PROPERTY_ID (object, property_id, pspec); + break; + } +} + +static void +territorio_ricerca_comuni_get_property (GObject *object, guint property_id, GValue *value, GParamSpec *pspec) +{ + TerritorioRicercaComuni *territorio_ricerca_comuni = TERRITORIO_RICERCA_COMUNI (object); + + TerritorioRicercaComuniPrivate *priv = TERRITORIO_RICERCA_COMUNI_GET_PRIVATE (territorio_ricerca_comuni); + + switch (property_id) + { + default: + G_OBJECT_WARN_INVALID_PROPERTY_ID (object, property_id, pspec); + break; + } +} + +/* CALLBACK */ +static void +territorio_ricerca_comuni_on_regione_selezionato (gpointer instance, guint id, gpointer user_data) +{ + TerritorioRicercaComuni *f = (TerritorioRicercaComuni *)user_data; + TerritorioRicercaComuniPrivate *priv = TERRITORIO_RICERCA_COMUNI_GET_PRIVATE (f); + + gtk_form_widget_set_value_stringify (gtk_form_get_form_widget_from_name (priv->form, "label48"), g_strdup_printf ("%d", id)); +} + +static void +territorio_ricerca_comuni_on_btn_provincia_clicked (GtkButton *button, + gpointer user_data) +{ + GtkWidget *w; + + TerritorioRicercaComuni *rf = (TerritorioRicercaComuni *)user_data; + + TerritorioRicercaComuniPrivate *priv = TERRITORIO_RICERCA_COMUNI_GET_PRIVATE (rf); + + TerritorioProvince *c = territorio_province_new (priv->commons, TRUE); + + g_signal_connect (G_OBJECT (c), "selezionato", + G_CALLBACK (territorio_ricerca_comuni_on_regione_selezionato), user_data); + + w = territorio_province_get_widget (c); + gtk_window_set_transient_for (GTK_WINDOW (w), GTK_WINDOW (priv->w)); + gtk_widget_show (w); +} + +static void +territorio_ricerca_comuni_on_btn_pulisci_clicked (GtkButton *button, + gpointer user_data) +{ + TerritorioRicercaComuniPrivate *priv = TERRITORIO_RICERCA_COMUNI_GET_PRIVATE ((TerritorioRicercaComuni *)user_data); + + gtk_form_clear (priv->form); +} + +static void +territorio_ricerca_comuni_on_btn_annulla_clicked (GtkButton *button, + gpointer user_data) +{ + TerritorioRicercaComuniPrivate *priv = TERRITORIO_RICERCA_COMUNI_GET_PRIVATE ((TerritorioRicercaComuni *)user_data); + + gtk_widget_destroy (priv->w); + g_object_unref (user_data); +} + +static void +territorio_ricerca_comuni_on_btn_ok_clicked (GtkButton *button, + gpointer user_data) +{ + TerritorioRicercaComuni *territorio_ricerca_comuni = (TerritorioRicercaComuni *)user_data; + TerritorioRicercaComuniClass *klass = TERRITORIO_RICERCA_COMUNI_GET_CLASS (territorio_ricerca_comuni); + + TerritorioRicercaComuniPrivate *priv = TERRITORIO_RICERCA_COMUNI_GET_PRIVATE (territorio_ricerca_comuni); + + g_signal_emit (territorio_ricerca_comuni, klass->filtra_signal_id, 0, gtk_form_get_values_as_hashtable (priv->form)); + + gtk_widget_destroy (priv->w); + g_object_unref (user_data); +} diff --git a/src/ricercacomuni.h b/src/ricercacomuni.h new file mode 100644 index 0000000..484078b --- /dev/null +++ b/src/ricercacomuni.h @@ -0,0 +1,66 @@ +/* + * Copyright (C) 2010 Andrea Zagli + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License as published by the Free Software Foundation; either + * version 2.1 of the License, or (at your option) any later version. + * + * This library 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 + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA + * + */ + +#ifndef __TERRITORIO_RICERCA_COMUNI_H__ +#define __TERRITORIO_RICERCA_COMUNI_H__ + +#include +#include + +#include +#include + +#include "commons.h" + +G_BEGIN_DECLS + + +#define TYPE_TERRITORIO_RICERCA_COMUNI (territorio_ricerca_comuni_get_type ()) +#define TERRITORIO_RICERCA_COMUNI(obj) (G_TYPE_CHECK_INSTANCE_CAST ((obj), TYPE_TERRITORIO_RICERCA_COMUNI, TerritorioRicercaComuni)) +#define TERRITORIO_RICERCA_COMUNI_CLASS(klass) (G_TYPE_CHECK_CLASS_CAST ((klass), TYPE_TERRITORIO_RICERCA_COMUNI, TerritorioRicercaComuniClass)) +#define IS_TERRITORIO_RICERCA_COMUNI(obj) (G_TYPE_CHECK_INSTANCE_TYPE ((obj), TYPE_TERRITORIO_RICERCA_COMUNI)) +#define IS_TERRITORIO_RICERCA_COMUNI_CLASS(klass) (G_TYPE_CHECK_CLASS_TYPE ((klass), TYPE_TERRITORIO_RICERCA_COMUNI)) +#define TERRITORIO_RICERCA_COMUNI_GET_CLASS(obj) (G_TYPE_INSTANCE_GET_CLASS ((obj), TYPE_TERRITORIO_RICERCA_COMUNI, TerritorioRicercaComuniClass)) + + +typedef struct _TerritorioRicercaComuni TerritorioRicercaComuni; +typedef struct _TerritorioRicercaComuniClass TerritorioRicercaComuniClass; + +struct _TerritorioRicercaComuni + { + GObject parent; + }; + +struct _TerritorioRicercaComuniClass + { + GObjectClass parent_class; + + guint filtra_signal_id; + }; + +GType territorio_ricerca_comuni_get_type (void) G_GNUC_CONST; + +TerritorioRicercaComuni *territorio_ricerca_comuni_new (TerritorioCommons *commons, GHashTable *values); + +GtkWidget *territorio_ricerca_comuni_get_widget (TerritorioRicercaComuni *territorio_ricerca_comuni); + + +G_END_DECLS + +#endif /* __TERRITORIO_RICERCA_COMUNI_H__ */ diff --git a/src/ricercaprovince.c b/src/ricercaprovince.c new file mode 100644 index 0000000..6c97e49 --- /dev/null +++ b/src/ricercaprovince.c @@ -0,0 +1,257 @@ +/* + * Copyright (C) 2010 Andrea Zagli + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License as published by the Free Software Foundation; either + * version 2.1 of the License, or (at your option) any later version. + * + * This library 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 + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA + * + */ + +#include + +#include "ricercaprovince.h" +#include "regioni.h" + +static void territorio_ricerca_province_class_init (TerritorioRicercaProvinceClass *klass); +static void territorio_ricerca_province_init (TerritorioRicercaProvince *territorio_ricerca_province); + +static void territorio_ricerca_province_set_property (GObject *object, + guint property_id, + const GValue *value, + GParamSpec *pspec); +static void territorio_ricerca_province_get_property (GObject *object, + guint property_id, + GValue *value, + GParamSpec *pspec); + +static void territorio_ricerca_province_on_regione_selezionato (gpointer instance, guint id, gpointer user_data); + +static void territorio_ricerca_province_on_btn_regione_clicked (GtkButton *button, + gpointer user_data); + +static void territorio_ricerca_province_on_btn_pulisci_clicked (GtkButton *button, + gpointer user_data); +static void territorio_ricerca_province_on_btn_annulla_clicked (GtkButton *button, + gpointer user_data); +static void territorio_ricerca_province_on_btn_ok_clicked (GtkButton *button, + gpointer user_data); + +#define TERRITORIO_RICERCA_PROVINCE_GET_PRIVATE(obj) (G_TYPE_INSTANCE_GET_PRIVATE ((obj), TYPE_TERRITORIO_RICERCA_PROVINCE, TerritorioRicercaProvincePrivate)) + +typedef struct _TerritorioRicercaProvincePrivate TerritorioRicercaProvincePrivate; +struct _TerritorioRicercaProvincePrivate + { + TerritorioCommons *commons; + + GtkForm *form; + + GtkWidget *w; + + GObject **objects; + }; + +G_DEFINE_TYPE (TerritorioRicercaProvince, territorio_ricerca_province, G_TYPE_OBJECT) + +static void +territorio_ricerca_province_class_init (TerritorioRicercaProvinceClass *klass) +{ + GObjectClass *object_class = G_OBJECT_CLASS (klass); + + g_type_class_add_private (object_class, sizeof (TerritorioRicercaProvincePrivate)); + + object_class->set_property = territorio_ricerca_province_set_property; + object_class->get_property = territorio_ricerca_province_get_property; + + /** + * TerritorioRicercaProvince::filtra: + */ + klass->filtra_signal_id = g_signal_new ("filtra", + G_TYPE_FROM_CLASS (object_class), + G_SIGNAL_RUN_LAST, + 0, + NULL, + NULL, + g_cclosure_marshal_VOID__POINTER, + G_TYPE_NONE, + 1, G_TYPE_POINTER); +} + +static void +territorio_ricerca_province_init (TerritorioRicercaProvince *territorio_ricerca_province) +{ + TerritorioRicercaProvincePrivate *priv = TERRITORIO_RICERCA_PROVINCE_GET_PRIVATE (territorio_ricerca_province); +} + +/** + * territorio_ricerca_province_new: + * @commons: + * @values: + * + * Returns: the newly created #TerritorioRicercaProvince object. + */ +TerritorioRicercaProvince +*territorio_ricerca_province_new (TerritorioCommons *commons, GHashTable *values) +{ + GError *error; + + TerritorioRicercaProvince *a = TERRITORIO_RICERCA_PROVINCE (g_object_new (territorio_ricerca_province_get_type (), NULL)); + + TerritorioRicercaProvincePrivate *priv = TERRITORIO_RICERCA_PROVINCE_GET_PRIVATE (a); + + priv->commons = commons; + + error = NULL; + gtk_builder_add_objects_from_file (priv->commons->gtkbuilder, priv->commons->guifile, + g_strsplit ("w_ricerca_province", "|", -1), + &error); + if (error != NULL) + { + g_warning ("Errore: %s.", error->message); + return NULL; + } + + priv->form = gtk_form_new (); + g_object_set (G_OBJECT (priv->form), "gdaex", priv->commons->gdaex, NULL); + gtk_form_load_from_file (priv->form, g_build_filename (priv->commons->formdir, "ricerca_province.form", NULL), priv->commons->gtkbuilder); + + priv->objects = gtk_form_get_objects_by_name (priv->form, + NULL); + + priv->w = GTK_WIDGET (gtk_builder_get_object (priv->commons->gtkbuilder, "w_ricerca_province")); + + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button69"), + "clicked", G_CALLBACK (territorio_ricerca_province_on_btn_regione_clicked), (gpointer *)a); + + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button70"), + "clicked", G_CALLBACK (territorio_ricerca_province_on_btn_pulisci_clicked), (gpointer *)a); + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button67"), + "clicked", G_CALLBACK (territorio_ricerca_province_on_btn_annulla_clicked), (gpointer *)a); + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button68"), + "clicked", G_CALLBACK (territorio_ricerca_province_on_btn_ok_clicked), (gpointer *)a); + + gtk_form_clear (priv->form); + if (values != NULL) + { + gtk_form_fill_from_hashtable (priv->form, values); + } + + return a; +} + +/** + * territorio_ricerca_province_get_widget: + * @territorio_ricerca_province: + * + */ +GtkWidget +*territorio_ricerca_province_get_widget (TerritorioRicercaProvince *territorio_ricerca_province) +{ + TerritorioRicercaProvincePrivate *priv = TERRITORIO_RICERCA_PROVINCE_GET_PRIVATE (territorio_ricerca_province); + + return priv->w; +} + +/* PRIVATE */ +static void +territorio_ricerca_province_set_property (GObject *object, guint property_id, const GValue *value, GParamSpec *pspec) +{ + TerritorioRicercaProvince *territorio_ricerca_province = TERRITORIO_RICERCA_PROVINCE (object); + + TerritorioRicercaProvincePrivate *priv = TERRITORIO_RICERCA_PROVINCE_GET_PRIVATE (territorio_ricerca_province); + + switch (property_id) + { + default: + G_OBJECT_WARN_INVALID_PROPERTY_ID (object, property_id, pspec); + break; + } +} + +static void +territorio_ricerca_province_get_property (GObject *object, guint property_id, GValue *value, GParamSpec *pspec) +{ + TerritorioRicercaProvince *territorio_ricerca_province = TERRITORIO_RICERCA_PROVINCE (object); + + TerritorioRicercaProvincePrivate *priv = TERRITORIO_RICERCA_PROVINCE_GET_PRIVATE (territorio_ricerca_province); + + switch (property_id) + { + default: + G_OBJECT_WARN_INVALID_PROPERTY_ID (object, property_id, pspec); + break; + } +} + +/* CALLBACK */ +static void +territorio_ricerca_province_on_regione_selezionato (gpointer instance, guint id, gpointer user_data) +{ + TerritorioRicercaProvince *f = (TerritorioRicercaProvince *)user_data; + TerritorioRicercaProvincePrivate *priv = TERRITORIO_RICERCA_PROVINCE_GET_PRIVATE (f); + + gtk_form_widget_set_value_stringify (gtk_form_get_form_widget_from_name (priv->form, "label60"), g_strdup_printf ("%d", id)); +} + +static void +territorio_ricerca_province_on_btn_regione_clicked (GtkButton *button, + gpointer user_data) +{ + GtkWidget *w; + + TerritorioRicercaProvince *rf = (TerritorioRicercaProvince *)user_data; + + TerritorioRicercaProvincePrivate *priv = TERRITORIO_RICERCA_PROVINCE_GET_PRIVATE (rf); + + TerritorioRegioni *c = territorio_regioni_new (priv->commons, TRUE); + + g_signal_connect (G_OBJECT (c), "selezionato", + G_CALLBACK (territorio_ricerca_province_on_regione_selezionato), user_data); + + w = territorio_regioni_get_widget (c); + gtk_window_set_transient_for (GTK_WINDOW (w), GTK_WINDOW (priv->w)); + gtk_widget_show (w); +} + +static void +territorio_ricerca_province_on_btn_pulisci_clicked (GtkButton *button, + gpointer user_data) +{ + TerritorioRicercaProvincePrivate *priv = TERRITORIO_RICERCA_PROVINCE_GET_PRIVATE ((TerritorioRicercaProvince *)user_data); + + gtk_form_clear (priv->form); +} + +static void +territorio_ricerca_province_on_btn_annulla_clicked (GtkButton *button, + gpointer user_data) +{ + TerritorioRicercaProvincePrivate *priv = TERRITORIO_RICERCA_PROVINCE_GET_PRIVATE ((TerritorioRicercaProvince *)user_data); + + gtk_widget_destroy (priv->w); + g_object_unref (user_data); +} + +static void +territorio_ricerca_province_on_btn_ok_clicked (GtkButton *button, + gpointer user_data) +{ + TerritorioRicercaProvince *territorio_ricerca_province = (TerritorioRicercaProvince *)user_data; + TerritorioRicercaProvinceClass *klass = TERRITORIO_RICERCA_PROVINCE_GET_CLASS (territorio_ricerca_province); + + TerritorioRicercaProvincePrivate *priv = TERRITORIO_RICERCA_PROVINCE_GET_PRIVATE (territorio_ricerca_province); + + g_signal_emit (territorio_ricerca_province, klass->filtra_signal_id, 0, gtk_form_get_values_as_hashtable (priv->form)); + + gtk_widget_destroy (priv->w); + g_object_unref (user_data); +} diff --git a/src/ricercaprovince.h b/src/ricercaprovince.h new file mode 100644 index 0000000..a2d0689 --- /dev/null +++ b/src/ricercaprovince.h @@ -0,0 +1,66 @@ +/* + * Copyright (C) 2010 Andrea Zagli + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License as published by the Free Software Foundation; either + * version 2.1 of the License, or (at your option) any later version. + * + * This library 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 + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA + * + */ + +#ifndef __TERRITORIO_RICERCA_PROVINCE_H__ +#define __TERRITORIO_RICERCA_PROVINCE_H__ + +#include +#include + +#include +#include + +#include "commons.h" + +G_BEGIN_DECLS + + +#define TYPE_TERRITORIO_RICERCA_PROVINCE (territorio_ricerca_province_get_type ()) +#define TERRITORIO_RICERCA_PROVINCE(obj) (G_TYPE_CHECK_INSTANCE_CAST ((obj), TYPE_TERRITORIO_RICERCA_PROVINCE, TerritorioRicercaProvince)) +#define TERRITORIO_RICERCA_PROVINCE_CLASS(klass) (G_TYPE_CHECK_CLASS_CAST ((klass), TYPE_TERRITORIO_RICERCA_PROVINCE, TerritorioRicercaProvinceClass)) +#define IS_TERRITORIO_RICERCA_PROVINCE(obj) (G_TYPE_CHECK_INSTANCE_TYPE ((obj), TYPE_TERRITORIO_RICERCA_PROVINCE)) +#define IS_TERRITORIO_RICERCA_PROVINCE_CLASS(klass) (G_TYPE_CHECK_CLASS_TYPE ((klass), TYPE_TERRITORIO_RICERCA_PROVINCE)) +#define TERRITORIO_RICERCA_PROVINCE_GET_CLASS(obj) (G_TYPE_INSTANCE_GET_CLASS ((obj), TYPE_TERRITORIO_RICERCA_PROVINCE, TerritorioRicercaProvinceClass)) + + +typedef struct _TerritorioRicercaProvince TerritorioRicercaProvince; +typedef struct _TerritorioRicercaProvinceClass TerritorioRicercaProvinceClass; + +struct _TerritorioRicercaProvince + { + GObject parent; + }; + +struct _TerritorioRicercaProvinceClass + { + GObjectClass parent_class; + + guint filtra_signal_id; + }; + +GType territorio_ricerca_province_get_type (void) G_GNUC_CONST; + +TerritorioRicercaProvince *territorio_ricerca_province_new (TerritorioCommons *commons, GHashTable *values); + +GtkWidget *territorio_ricerca_province_get_widget (TerritorioRicercaProvince *territorio_ricerca_province); + + +G_END_DECLS + +#endif /* __TERRITORIO_RICERCA_PROVINCE_H__ */ diff --git a/src/ricercavie.c b/src/ricercavie.c new file mode 100644 index 0000000..fc1975d --- /dev/null +++ b/src/ricercavie.c @@ -0,0 +1,257 @@ +/* + * Copyright (C) 2010 Andrea Zagli + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License as published by the Free Software Foundation; either + * version 2.1 of the License, or (at your option) any later version. + * + * This library 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 + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA + * + */ + +#include + +#include "ricercavie.h" +#include "comuni.h" + +static void territorio_ricerca_vie_class_init (TerritorioRicercaVieClass *klass); +static void territorio_ricerca_vie_init (TerritorioRicercaVie *territorio_ricerca_vie); + +static void territorio_ricerca_vie_set_property (GObject *object, + guint property_id, + const GValue *value, + GParamSpec *pspec); +static void territorio_ricerca_vie_get_property (GObject *object, + guint property_id, + GValue *value, + GParamSpec *pspec); + +static void territorio_ricerca_vie_on_comune_selezionato (gpointer instance, guint id, gpointer user_data); + +static void territorio_ricerca_vie_on_btn_comune_clicked (GtkButton *button, + gpointer user_data); + +static void territorio_ricerca_vie_on_btn_pulisci_clicked (GtkButton *button, + gpointer user_data); +static void territorio_ricerca_vie_on_btn_annulla_clicked (GtkButton *button, + gpointer user_data); +static void territorio_ricerca_vie_on_btn_ok_clicked (GtkButton *button, + gpointer user_data); + +#define TERRITORIO_RICERCA_VIE_GET_PRIVATE(obj) (G_TYPE_INSTANCE_GET_PRIVATE ((obj), TYPE_TERRITORIO_RICERCA_VIE, TerritorioRicercaViePrivate)) + +typedef struct _TerritorioRicercaViePrivate TerritorioRicercaViePrivate; +struct _TerritorioRicercaViePrivate + { + TerritorioCommons *commons; + + GtkForm *form; + + GtkWidget *w; + + GObject **objects; + }; + +G_DEFINE_TYPE (TerritorioRicercaVie, territorio_ricerca_vie, G_TYPE_OBJECT) + +static void +territorio_ricerca_vie_class_init (TerritorioRicercaVieClass *klass) +{ + GObjectClass *object_class = G_OBJECT_CLASS (klass); + + g_type_class_add_private (object_class, sizeof (TerritorioRicercaViePrivate)); + + object_class->set_property = territorio_ricerca_vie_set_property; + object_class->get_property = territorio_ricerca_vie_get_property; + + /** + * TerritorioRicercaVie::filtra: + */ + klass->filtra_signal_id = g_signal_new ("filtra", + G_TYPE_FROM_CLASS (object_class), + G_SIGNAL_RUN_LAST, + 0, + NULL, + NULL, + g_cclosure_marshal_VOID__POINTER, + G_TYPE_NONE, + 1, G_TYPE_POINTER); +} + +static void +territorio_ricerca_vie_init (TerritorioRicercaVie *territorio_ricerca_vie) +{ + TerritorioRicercaViePrivate *priv = TERRITORIO_RICERCA_VIE_GET_PRIVATE (territorio_ricerca_vie); +} + +/** + * territorio_ricerca_vie_new: + * @commons: + * @values: + * + * Returns: the newly created #TerritorioRicercaVie object. + */ +TerritorioRicercaVie +*territorio_ricerca_vie_new (TerritorioCommons *commons, GHashTable *values) +{ + GError *error; + + TerritorioRicercaVie *a = TERRITORIO_RICERCA_VIE (g_object_new (territorio_ricerca_vie_get_type (), NULL)); + + TerritorioRicercaViePrivate *priv = TERRITORIO_RICERCA_VIE_GET_PRIVATE (a); + + priv->commons = commons; + + error = NULL; + gtk_builder_add_objects_from_file (priv->commons->gtkbuilder, priv->commons->guifile, + g_strsplit ("w_ricerca_vie", "|", -1), + &error); + if (error != NULL) + { + g_warning ("Errore: %s.", error->message); + return NULL; + } + + priv->form = gtk_form_new (); + g_object_set (G_OBJECT (priv->form), "gdaex", priv->commons->gdaex, NULL); + gtk_form_load_from_file (priv->form, g_build_filename (priv->commons->formdir, "ricerca_vie.form", NULL), priv->commons->gtkbuilder); + + priv->objects = gtk_form_get_objects_by_name (priv->form, + NULL); + + priv->w = GTK_WIDGET (gtk_builder_get_object (priv->commons->gtkbuilder, "w_ricerca_vie")); + + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button59"), + "clicked", G_CALLBACK (territorio_ricerca_vie_on_btn_comune_clicked), (gpointer *)a); + + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button60"), + "clicked", G_CALLBACK (territorio_ricerca_vie_on_btn_pulisci_clicked), (gpointer *)a); + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button61"), + "clicked", G_CALLBACK (territorio_ricerca_vie_on_btn_annulla_clicked), (gpointer *)a); + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button62"), + "clicked", G_CALLBACK (territorio_ricerca_vie_on_btn_ok_clicked), (gpointer *)a); + + gtk_form_clear (priv->form); + if (values != NULL) + { + gtk_form_fill_from_hashtable (priv->form, values); + } + + return a; +} + +/** + * territorio_ricerca_vie_get_widget: + * @territorio_ricerca_vie: + * + */ +GtkWidget +*territorio_ricerca_vie_get_widget (TerritorioRicercaVie *territorio_ricerca_vie) +{ + TerritorioRicercaViePrivate *priv = TERRITORIO_RICERCA_VIE_GET_PRIVATE (territorio_ricerca_vie); + + return priv->w; +} + +/* PRIVATE */ +static void +territorio_ricerca_vie_set_property (GObject *object, guint property_id, const GValue *value, GParamSpec *pspec) +{ + TerritorioRicercaVie *territorio_ricerca_vie = TERRITORIO_RICERCA_VIE (object); + + TerritorioRicercaViePrivate *priv = TERRITORIO_RICERCA_VIE_GET_PRIVATE (territorio_ricerca_vie); + + switch (property_id) + { + default: + G_OBJECT_WARN_INVALID_PROPERTY_ID (object, property_id, pspec); + break; + } +} + +static void +territorio_ricerca_vie_get_property (GObject *object, guint property_id, GValue *value, GParamSpec *pspec) +{ + TerritorioRicercaVie *territorio_ricerca_vie = TERRITORIO_RICERCA_VIE (object); + + TerritorioRicercaViePrivate *priv = TERRITORIO_RICERCA_VIE_GET_PRIVATE (territorio_ricerca_vie); + + switch (property_id) + { + default: + G_OBJECT_WARN_INVALID_PROPERTY_ID (object, property_id, pspec); + break; + } +} + +/* CALLBACK */ +static void +territorio_ricerca_vie_on_comune_selezionato (gpointer instance, guint id, gpointer user_data) +{ + TerritorioRicercaVie *f = (TerritorioRicercaVie *)user_data; + TerritorioRicercaViePrivate *priv = TERRITORIO_RICERCA_VIE_GET_PRIVATE (f); + + gtk_form_widget_set_value_stringify (gtk_form_get_form_widget_from_name (priv->form, "label51"), g_strdup_printf ("%d", id)); +} + +static void +territorio_ricerca_vie_on_btn_comune_clicked (GtkButton *button, + gpointer user_data) +{ + GtkWidget *w; + + TerritorioRicercaVie *rf = (TerritorioRicercaVie *)user_data; + + TerritorioRicercaViePrivate *priv = TERRITORIO_RICERCA_VIE_GET_PRIVATE (rf); + + TerritorioComuni *c = territorio_comuni_new (priv->commons, TRUE); + + g_signal_connect (G_OBJECT (c), "selezionato", + G_CALLBACK (territorio_ricerca_vie_on_comune_selezionato), user_data); + + w = territorio_comuni_get_widget (c); + gtk_window_set_transient_for (GTK_WINDOW (w), GTK_WINDOW (priv->w)); + gtk_widget_show (w); +} + +static void +territorio_ricerca_vie_on_btn_pulisci_clicked (GtkButton *button, + gpointer user_data) +{ + TerritorioRicercaViePrivate *priv = TERRITORIO_RICERCA_VIE_GET_PRIVATE ((TerritorioRicercaVie *)user_data); + + gtk_form_clear (priv->form); +} + +static void +territorio_ricerca_vie_on_btn_annulla_clicked (GtkButton *button, + gpointer user_data) +{ + TerritorioRicercaViePrivate *priv = TERRITORIO_RICERCA_VIE_GET_PRIVATE ((TerritorioRicercaVie *)user_data); + + gtk_widget_destroy (priv->w); + g_object_unref (user_data); +} + +static void +territorio_ricerca_vie_on_btn_ok_clicked (GtkButton *button, + gpointer user_data) +{ + TerritorioRicercaVie *territorio_ricerca_vie = (TerritorioRicercaVie *)user_data; + TerritorioRicercaVieClass *klass = TERRITORIO_RICERCA_VIE_GET_CLASS (territorio_ricerca_vie); + + TerritorioRicercaViePrivate *priv = TERRITORIO_RICERCA_VIE_GET_PRIVATE (territorio_ricerca_vie); + + g_signal_emit (territorio_ricerca_vie, klass->filtra_signal_id, 0, gtk_form_get_values_as_hashtable (priv->form)); + + gtk_widget_destroy (priv->w); + g_object_unref (user_data); +} diff --git a/src/ricercavie.h b/src/ricercavie.h new file mode 100644 index 0000000..5087615 --- /dev/null +++ b/src/ricercavie.h @@ -0,0 +1,66 @@ +/* + * Copyright (C) 2010 Andrea Zagli + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License as published by the Free Software Foundation; either + * version 2.1 of the License, or (at your option) any later version. + * + * This library 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 + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA + * + */ + +#ifndef __TERRITORIO_RICERCA_VIE_H__ +#define __TERRITORIO_RICERCA_VIE_H__ + +#include +#include + +#include +#include + +#include "commons.h" + +G_BEGIN_DECLS + + +#define TYPE_TERRITORIO_RICERCA_VIE (territorio_ricerca_vie_get_type ()) +#define TERRITORIO_RICERCA_VIE(obj) (G_TYPE_CHECK_INSTANCE_CAST ((obj), TYPE_TERRITORIO_RICERCA_VIE, TerritorioRicercaVie)) +#define TERRITORIO_RICERCA_VIE_CLASS(klass) (G_TYPE_CHECK_CLASS_CAST ((klass), TYPE_TERRITORIO_RICERCA_VIE, TerritorioRicercaVieClass)) +#define IS_TERRITORIO_RICERCA_VIE(obj) (G_TYPE_CHECK_INSTANCE_TYPE ((obj), TYPE_TERRITORIO_RICERCA_VIE)) +#define IS_TERRITORIO_RICERCA_VIE_CLASS(klass) (G_TYPE_CHECK_CLASS_TYPE ((klass), TYPE_TERRITORIO_RICERCA_VIE)) +#define TERRITORIO_RICERCA_VIE_GET_CLASS(obj) (G_TYPE_INSTANCE_GET_CLASS ((obj), TYPE_TERRITORIO_RICERCA_VIE, TerritorioRicercaVieClass)) + + +typedef struct _TerritorioRicercaVie TerritorioRicercaVie; +typedef struct _TerritorioRicercaVieClass TerritorioRicercaVieClass; + +struct _TerritorioRicercaVie + { + GObject parent; + }; + +struct _TerritorioRicercaVieClass + { + GObjectClass parent_class; + + guint filtra_signal_id; + }; + +GType territorio_ricerca_vie_get_type (void) G_GNUC_CONST; + +TerritorioRicercaVie *territorio_ricerca_vie_new (TerritorioCommons *commons, GHashTable *values); + +GtkWidget *territorio_ricerca_vie_get_widget (TerritorioRicercaVie *territorio_ricerca_vie); + + +G_END_DECLS + +#endif /* __TERRITORIO_RICERCA_VIE_H__ */ diff --git a/src/vie.c b/src/vie.c index e8faa7b..f5f9c7e 100644 --- a/src/vie.c +++ b/src/vie.c @@ -17,8 +17,11 @@ * */ +#include + #include "vie.h" #include "via.h" +#include "ricercavie.h" static void territorio_vie_class_init (TerritorioVieClass *klass); static void territorio_vie_init (TerritorioVie *territorio_vie); @@ -29,6 +32,8 @@ static void territorio_vie_modifica (TerritorioVie *territorio_vie); static void territorio_vie_selezionato (TerritorioVie *territorio_vie); static void territorio_vie_on_via_aggiornato (gpointer instance, gpointer user_data); +static void territorio_vie_on_filtra (gpointer instance, gpointer parametri, gpointer user_data); + static void territorio_vie_set_property (GObject *object, guint property_id, const GValue *value, @@ -49,11 +54,21 @@ static void territorio_vie_on_trv_vie_row_activated (GtkTreeView *tree_view, GtkTreeViewColumn *column, gpointer user_data); +static void territorio_vie_on_btn_trova_clicked (GtkButton *button, + gpointer user_data); + static void territorio_vie_on_btn_annulla_clicked (GtkButton *button, gpointer user_data); static void territorio_vie_on_btn_seleziona_clicked (GtkButton *button, gpointer user_data); +static gboolean search_func (GtkTreeModel *model, + gint column, + const gchar *key, + GtkTreeIter *iter, + gpointer search_data); + + #define TERRITORIO_VIE_GET_PRIVATE(obj) (G_TYPE_INSTANCE_GET_PRIVATE ((obj), TYPE_TERRITORIO_VIE, TerritorioViePrivate)) enum @@ -71,6 +86,8 @@ struct _TerritorioViePrivate GtkTreeSelection *selection; GtkListStore *lstore_vie; + GHashTable *parametri_ricerca; + gboolean selezione; GtkWindow *wtransient; }; @@ -144,6 +161,8 @@ TerritorioVie priv->selection = gtk_tree_view_get_selection (GTK_TREE_VIEW (gtk_builder_get_object (priv->commons->gtkbuilder, "treeview7"))); priv->lstore_vie = GTK_LIST_STORE (gtk_builder_get_object (priv->commons->gtkbuilder, "lstore_vie")); + gtk_tree_view_set_search_equal_func (GTK_TREE_VIEW (gtk_builder_get_object (priv->commons->gtkbuilder, "treeview7")), search_func, NULL, NULL); + if (priv->selezione) { priv->wtransient = GTK_WINDOW (priv->widget); @@ -161,6 +180,8 @@ TerritorioVie "clicked", G_CALLBACK (territorio_vie_on_btn_elimina_clicked), (gpointer)a); g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "treeview7"), "row-activated", G_CALLBACK (territorio_vie_on_trv_vie_row_activated), (gpointer)a); + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button63"), + "clicked", G_CALLBACK (territorio_vie_on_btn_trova_clicked), (gpointer)a); if (priv->selezione) { @@ -201,6 +222,13 @@ territorio_vie_carica (TerritorioVie *territorio_vie) GtkTreeIter iter; GdaDataModel *dm; + gchar *sql; + gchar *sql_where; + + GValue *gvalue; + gchar *gcval; + gint ival; + gint rows; gint row; @@ -208,11 +236,34 @@ territorio_vie_carica (TerritorioVie *territorio_vie) gtk_list_store_clear (priv->lstore_vie); - dm = gdaex_query (priv->commons->gdaex, - "SELECT c.id, c.nome" - " FROM vie AS c" - " WHERE c.status <> 'E'" - " ORDER BY c.nome"); + sql_where = g_strdup (""); + if (priv->parametri_ricerca != NULL) + { + gcval = g_strstrip ((gchar *)g_value_get_string ((GValue *)g_hash_table_lookup (priv->parametri_ricerca, "nome"))); + if (g_strcmp0 (gcval, "") != 0) + { + sql_where = g_strconcat (sql_where, " AND c.nome ILIKE '%", + g_strdup_printf ("%s", gcval), + "%'", + NULL); + } + ival = g_value_get_int ((GValue *)g_hash_table_lookup (priv->parametri_ricerca, "id_comuni")); + if (ival != 0) + { + sql_where = g_strconcat (sql_where, " AND c.id_comuni = ", + g_strdup_printf ("%d", ival), + NULL); + } + } + + sql = g_strdup_printf ("SELECT c.id, c.nome" + " FROM vie AS c" + " WHERE c.status <> 'E'" + "%s" + " ORDER BY c.nome", + sql_where); + + dm = gdaex_query (priv->commons->gdaex, sql); if (dm != NULL) { rows = gda_data_model_get_n_rows (dm); @@ -305,6 +356,17 @@ territorio_vie_on_via_aggiornato (gpointer instance, gpointer user_data) territorio_vie_carica ((TerritorioVie *)user_data); } +static void +territorio_vie_on_filtra (gpointer instance, gpointer parametri, gpointer user_data) +{ + TerritorioVie *i = (TerritorioVie *)user_data; + TerritorioViePrivate *priv = TERRITORIO_VIE_GET_PRIVATE (i); + + priv->parametri_ricerca = (GHashTable *)parametri; + + territorio_vie_carica (i); +} + static void territorio_vie_set_property (GObject *object, guint property_id, const GValue *value, GParamSpec *pspec) { @@ -427,6 +489,24 @@ territorio_vie_on_trv_vie_row_activated (GtkTreeView *tree_view, } +static void +territorio_vie_on_btn_trova_clicked (GtkButton *button, + gpointer user_data) +{ + GtkWidget *w; + + TerritorioViePrivate *priv = TERRITORIO_VIE_GET_PRIVATE ((TerritorioVie *)user_data); + + TerritorioRicercaVie *rf = territorio_ricerca_vie_new (priv->commons, priv->parametri_ricerca); + + g_signal_connect (G_OBJECT (rf), "filtra", + G_CALLBACK (territorio_vie_on_filtra), (TerritorioVie *)user_data); + + w = territorio_ricerca_vie_get_widget (rf); + gtk_window_set_transient_for (GTK_WINDOW (w), priv->wtransient); + gtk_widget_show (w); +} + static void territorio_vie_on_btn_annulla_clicked (GtkButton *button, gpointer user_data) @@ -443,3 +523,21 @@ territorio_vie_on_btn_seleziona_clicked (GtkButton *button, { territorio_vie_selezionato ((TerritorioVie *)user_data); } + +static gboolean +search_func (GtkTreeModel *model, + gint column, + const gchar *key, + GtkTreeIter *iter, + gpointer search_data) +{ + gchar *str; + char *ret; + + ret = NULL; + + gtk_tree_model_get (model, iter, column, &str, -1); + ret = strstr ((const char *)g_utf8_strdown (str, -1), (const char *)g_utf8_strdown (key, -1)); + + return (ret == NULL); +} -- 2.49.0