start of proper filtering
[belltower] / belltower.c
1 /*
2  * belltower
3  * an app to find belltowers under Maemo 5
4  *
5  * Copyright (c) 2009 Thomas Thurman <tthurman@gnome.org>
6  * Released under the GPL
7  */
8
9 #include <stdio.h>
10 #include <stdlib.h>
11 #include <string.h>
12 #include <glib.h>
13 #include <hildon/hildon.h>
14 #include <gtk/gtk.h>
15 #include <location/location-gps-device.h>
16 #include <dbus/dbus-glib.h>
17
18 #define MAX_FIELDS 50
19
20 GtkWidget *window;
21
22 typedef enum {
23   /** stop scanning the database */
24   FILTER_STOP,
25   /** ignore this one */
26   FILTER_PASS,
27   /** add this one to the list */
28   FILTER_ACCEPT
29 } FilterResult;
30
31 /*
32   FIXME:
33   We should really do this by looking at the header row of the table.
34   They might decide to put in new columns some day.
35 */
36 typedef enum {
37   FieldPrimaryKey,
38   FieldNationalGrid,
39   FieldAccRef,
40   FieldSNLat,
41   FieldSNLong,
42   FieldPostcode,
43   FieldTowerBase,
44   FieldCounty,
45   FieldCountry,
46   FieldDiocese,
47   FieldPlace,
48   FieldPlace2,
49   FieldPlaceCL,
50   FieldDedication,
51   FieldBells,
52   FieldWt,
53   FieldApp,
54   FieldNote,
55   FieldHz,
56   FieldDetails,
57   FieldGF,
58   FieldToilet,
59   FieldUR,
60   FieldPDNo,
61   FieldPracticeNight,
62   FieldPSt,
63   FieldPrXF,
64   FieldOvhaulYr,
65   FieldContractor,
66   FieldExtraInfo,
67   FieldWebPage,
68   FieldUpdated,
69   FieldAffiliations,
70   FieldAltName,
71   FieldLat,
72   FieldLong,
73   FieldSimulator
74 } field;
75
76 typedef struct {
77   int serial;
78
79   /* the raw data */
80
81   char* fields[MAX_FIELDS];
82   int n_fields;
83 } tower;
84
85 /*
86  * we're going to pretend you're in Helsinki
87  * until I get the GPS working
88  */
89 double current_lat = 60.161790;
90 double current_long = 23.924902;
91
92 static void
93 show_message (char *message)
94 {
95   HildonNote* note = HILDON_NOTE
96     (hildon_note_new_information (GTK_WINDOW (window),
97                                   message?message:
98                                   "Some message was supposed to be here."));
99   gtk_dialog_run (GTK_DIALOG (note));
100   gtk_widget_destroy (GTK_WIDGET (note));
101 }
102
103 static gchar*
104 distance_to_tower (tower *details)
105 {
106   char *endptr;
107   double tower_lat;
108   double tower_long;
109   double km_distance;
110   const double km_to_miles = 1.609344;
111
112   tower_lat = strtod(details->fields[FieldLat], &endptr);
113   if (*endptr) return g_strdup ("unknown");
114   tower_long = strtod(details->fields[FieldLong], &endptr);
115   if (*endptr) return g_strdup ("unknown");
116
117   km_distance = location_distance_between (current_lat,
118                                            current_long,
119                                            tower_lat,
120                                            tower_long);
121
122   return g_strdup_printf("%dmi", (int) (km_distance / km_to_miles));
123 }
124
125 static void
126 call_dbus (DBusBusType type,
127            char *name,
128            char *path,
129            char *interface,
130            char *method,
131            char *parameter)
132 {
133   DBusGConnection *connection;
134   GError *error = NULL;
135
136   DBusGProxy *proxy;
137
138   connection = dbus_g_bus_get (type,
139                                &error);
140   if (connection == NULL)
141     {
142       show_message (error->message);
143       g_error_free (error);
144       return;
145     }
146
147   proxy = dbus_g_proxy_new_for_name (connection, name, path, interface);
148
149   error = NULL;
150   if (!dbus_g_proxy_call (proxy, method, &error,
151                           G_TYPE_STRING, parameter,
152                           G_TYPE_INVALID,
153                           G_TYPE_INVALID))
154     {
155       show_message (error->message);
156       g_error_free (error);
157     }
158 }
159
160 static void
161 show_browser (gchar *url)
162 {
163   call_dbus (DBUS_BUS_SESSION,
164              "com.nokia.osso_browser",
165              "/com/nokia/osso_browser/request",
166              "com.nokia.osso_browser",
167              "load_url",
168              url);
169 }
170
171 typedef gboolean (*ParseDoveCallback)(tower *details, gpointer data);
172 typedef void (*ButtonCallback)(void);
173
174 GtkWidget *tower_window, *buttons, *tower_table;
175 HildonAppMenu *menu;
176
177 static void
178 add_table_field (char *name,
179                  char *value)
180 {
181   int row;
182   GtkLabel *label;
183   gchar *str;
184
185   g_object_get(tower_table, "n-rows", &row);
186
187   row++;
188
189   gtk_table_resize (GTK_TABLE (tower_table), row, 2);
190
191   label = GTK_LABEL (gtk_label_new (NULL));
192   str = g_strdup_printf("<b>%s</b>", name);
193   gtk_label_set_markup (label, str);
194   g_free (str);
195   gtk_label_set_justify (label, GTK_JUSTIFY_RIGHT);
196   gtk_table_attach_defaults (GTK_TABLE (tower_table),
197                              GTK_WIDGET (label),
198                              0, 1, row, row+1);
199
200   label = GTK_LABEL (gtk_label_new (value));
201   gtk_label_set_justify (label, GTK_JUSTIFY_LEFT);
202   gtk_table_attach_defaults (GTK_TABLE (tower_table),
203                              GTK_WIDGET (label),
204                              1, 2, row, row+1);
205 }
206
207 static void
208 add_button (char *label,
209             ButtonCallback callback)
210 {
211   GtkWidget *button;
212
213   button = gtk_button_new_with_label (label);
214   g_signal_connect (button, "clicked", G_CALLBACK (callback), NULL);
215   hildon_app_menu_append (menu, GTK_BUTTON (button));
216   button = hildon_button_new_with_text (HILDON_SIZE_AUTO_WIDTH | HILDON_SIZE_FINGER_HEIGHT,
217                                         HILDON_BUTTON_ARRANGEMENT_VERTICAL,
218                                         label, NULL);
219   g_signal_connect (button, "clicked", G_CALLBACK (callback), NULL);
220   gtk_box_pack_end (GTK_BOX (buttons), button, FALSE, FALSE, 0);
221 }
222
223
224 static void
225 bookmark_toggled (GtkButton *button,
226                   gpointer dummy)
227 {
228   show_message ("Bookmarks are not yet implemented.");
229 }
230
231 char *tower_website = NULL;
232 char *tower_map = NULL;
233 char *tower_directions = NULL;
234 char *peals_list = NULL;
235
236 static void
237 show_tower_website (void)
238 {
239   show_browser (tower_website);
240 }
241
242 static void
243 show_tower_map (void)
244 {
245   show_browser (tower_map);
246 }
247
248 static void
249 show_peals_list (void)
250 {
251   show_browser (peals_list);
252 }
253
254 static gboolean
255 get_countries_cb (tower *details,
256                   gpointer data)
257 {
258   GHashTable *hash = (GHashTable *)data;
259
260   if (details->serial==0)
261     return TRUE; /* header row */
262
263   if (!g_hash_table_lookup_extended (hash,
264                                     details->fields[FieldCountry],
265                                      NULL, NULL))
266     {
267       g_hash_table_insert (hash,
268                            g_strdup(details->fields[FieldCountry]),
269                            g_strdup (details->fields[FieldCountry]));
270     }
271
272   return FILTER_PASS;
273 }
274
275 typedef struct {
276   GHashTable *hash;
277   gchar *country_name;
278 } country_cb_data;
279
280 static gboolean
281 get_counties_cb (tower *details,
282                  gpointer data)
283 {
284   country_cb_data *d = (country_cb_data *)data;
285
286   if (details->serial==0)
287     return FILTER_PASS; /* header row */
288
289   if (strcmp(details->fields[FieldCountry], d->country_name)!=0)
290     return FILTER_PASS; /* wrong country */
291
292   if (!g_hash_table_lookup_extended (d->hash,
293                                     details->fields[FieldCounty],
294                                      NULL, NULL))
295     {
296       g_hash_table_insert (d->hash,
297                            g_strdup(details->fields[FieldCounty]),
298                            g_strdup (details->fields[FieldCounty]));
299     }
300
301   return FILTER_PASS;
302 }
303
304 static gboolean
305 single_tower_cb (tower *details,
306                  gpointer data)
307 {
308
309   GtkWidget *hbox, *button;
310   gchar *str;
311   gint tenor_weight;
312   gchar *primary_key = (gchar*) data;
313   gchar *miles;
314
315   if (strcmp(details->fields[FieldPrimaryKey], primary_key)!=0)
316     {
317       /* not this one; keep going */
318       return FILTER_PASS;
319     }
320
321   tower_window = hildon_stackable_window_new ();
322
323   if (g_str_has_prefix (details->fields[FieldDedication],
324                         "S "))
325     {
326       /* FIXME: This needs to be cleverer, because we can have
327        * e.g. "S Peter and S Paul".
328        * May have to use regexps.
329        * Reallocation in general even when unchanged is okay,
330        * because it's the common case (most towers are S Something)
331        */
332       
333       /* FIXME: Since we're passing this in as markup,
334        * we need to escape the strings.
335        */
336
337       str = g_strdup_printf("S<sup>t</sup> %s, %s",
338                               details->fields[FieldDedication]+2,
339                               details->fields[FieldPlace]);
340
341     }
342   else
343     {
344       str = g_strdup_printf("%s, %s",
345                               details->fields[FieldDedication],
346                               details->fields[FieldPlace]);
347     }
348
349   hildon_window_set_markup (HILDON_WINDOW (tower_window),
350                             str);
351   g_free (str);
352
353   hbox = gtk_hbox_new (FALSE, 0);
354   tower_table = gtk_table_new (0, 2, FALSE);
355   buttons = gtk_vbox_new (TRUE, 0);
356   menu = HILDON_APP_MENU (hildon_app_menu_new ());
357
358   miles = distance_to_tower(details);
359
360   add_table_field ("Distance", miles);
361   add_table_field ("Postcode", details->fields[FieldPostcode]);
362   add_table_field ("County", details->fields[FieldCounty]);
363   add_table_field ("Country", details->fields[FieldCountry]);
364   add_table_field ("Diocese", details->fields[FieldDiocese]);
365   add_table_field ("Practice night", details->fields[FieldPracticeNight]);
366   add_table_field ("Bells", details->fields[FieldBells]);
367
368   g_free (miles);
369
370   tenor_weight = atoi (details->fields[FieldWt]);
371   str = g_strdup_printf("%dcwt %dqr %dlb in %s",
372                         tenor_weight/112,
373                         (tenor_weight % 112)/28,
374                         tenor_weight % 28,
375                         details->fields[FieldNote]
376                         );
377   add_table_field ("Tenor", str);
378   g_free (str);
379
380   add_button ("Tower website", show_tower_website);
381   add_button ("Peals", show_peals_list);
382   add_button ("Map", show_tower_map);
383   add_button ("Directions", NULL);
384
385   /* don't use a toggle button: it looks stupid */
386   button = hildon_button_new_with_text (HILDON_SIZE_AUTO_WIDTH | HILDON_SIZE_FINGER_HEIGHT,
387                                         HILDON_BUTTON_ARRANGEMENT_VERTICAL,
388                                         "Bookmark", NULL);
389   g_signal_connect (button, "clicked", G_CALLBACK (bookmark_toggled), NULL);
390   gtk_box_pack_start (GTK_BOX (buttons), button, FALSE, FALSE, 0);
391
392   gtk_widget_show_all (GTK_WIDGET (menu));
393   hildon_window_set_app_menu (HILDON_WINDOW (tower_window), menu);
394
395   gtk_box_pack_end (GTK_BOX (hbox), buttons, TRUE, TRUE, 0);
396   gtk_box_pack_end (GTK_BOX (hbox), tower_table, TRUE, TRUE, 0);
397
398   gtk_container_add (GTK_CONTAINER (tower_window), hbox);
399
400   g_free (tower_website);
401   tower_website = g_strdup_printf ("http://%s", details->fields[FieldWebPage]);
402   g_free (peals_list);
403   peals_list = g_strdup_printf ("http://www.pealbase.ismysite.co.uk/felstead/tbid.php?tid=%s",
404        details->fields[FieldTowerBase]);
405   g_free (tower_map);
406   tower_map = g_strdup_printf ("http://maps.google.com/maps?q=%s,%s",
407         details->fields[FieldLat],
408         details->fields[FieldLong]);
409   gtk_widget_show_all (GTK_WIDGET (tower_window));
410
411   return FILTER_STOP;
412 }
413
414 static void
415 parse_dove (ParseDoveCallback callback,
416             GSList **filter_results,
417             gpointer data)
418 {
419   FILE *dove = fopen("/usr/share/belltower/dove.txt", "r");
420   char tower_rec[4096];
421   tower result;
422   char *i;
423   gboolean seen_newline;
424
425   if (!dove)
426     {
427       show_message ("Cannot open Dove database!");
428       exit (255);
429     }
430
431   result.serial = 0;
432
433   while (fgets (tower_rec, sizeof (tower_rec), dove))
434     {
435       seen_newline = FALSE;
436       result.fields[0] = tower_rec;
437       result.n_fields = 0;
438       for (i=tower_rec; *i; i++) {
439         if (*i=='\n')
440           {
441             seen_newline = TRUE;
442           }
443         if (*i=='\\' || *i=='\n')
444           {
445             *i = 0;
446             result.n_fields++;
447             result.fields[result.n_fields] = i+1;
448           }
449       }
450
451       if (!seen_newline)
452         {
453           /* keep it simple, stupid */
454           show_message ("Line too long, cannot continue.");
455           exit (255);
456         }
457
458       if (strcmp (result.fields[FieldCountry], "")==0)
459         {
460           result.fields[FieldCountry] = "England";
461         }
462
463       switch (callback (&result, data))
464         {
465         case FILTER_PASS:
466           /* nothing */
467           break;
468
469         case FILTER_STOP:
470           fclose (dove);
471           return;
472
473         case FILTER_ACCEPT:
474           if (filter_results)
475             {
476               *filter_results = g_slist_append (*filter_results,
477                                                 result.fields[FieldPrimaryKey]);
478             }
479         }
480
481       result.serial++;
482     }
483
484   fclose (dove);
485 }
486
487 static void
488 nearby_towers (void)
489 {
490   char buffer[4096];
491   LocationGPSDevice *device;
492   device = g_object_new (LOCATION_TYPE_GPS_DEVICE, NULL);
493
494   sprintf(buffer, "%f %f %x",
495       device->fix->latitude,
496       device->fix->longitude,
497       device->fix->fields);
498   show_message (buffer);
499
500   if (device->fix->fields & LOCATION_GPS_DEVICE_LATLONG_SET)
501     {
502       show_message ("I know where you are!");
503     }
504   else
505     {
506       show_message ("I don't know where you are!");
507     }
508
509   g_object_unref (device);
510 }
511
512 static void
513 show_tower (char *primary_key)
514 {
515   parse_dove (single_tower_cb, NULL, primary_key);
516 }
517
518 static gint strcmp_f (gconstpointer a,
519                       gconstpointer b)
520 {
521   return strcmp ((char*)a, (char*)b);
522 }
523
524 static void
525 put_areas_into_list (gpointer key,
526                      gpointer value,
527                      gpointer data)
528 {
529   GSList **list = (GSList **)data;
530   *list = g_slist_insert_sorted (*list,
531                                  value,
532                                  strcmp_f);
533 }
534
535 static void
536 towers_by_subarea (gchar *area)
537 {
538   GtkWidget *dialog = hildon_picker_dialog_new (GTK_WINDOW (window));
539
540   GtkWidget *selector = hildon_touch_selector_new_text ();
541
542   GHashTable *hash = g_hash_table_new_full (g_str_hash,
543                                             g_str_equal,
544                                             g_free,
545                                             g_free);
546
547   GSList *list=NULL, *cursor;
548
549   gchar *title = g_strdup_printf ("Areas of %s", area);
550
551   country_cb_data d = { hash, area };
552
553   gtk_window_set_title (GTK_WINDOW (dialog), title);
554   g_free (title);
555
556   parse_dove (get_counties_cb, NULL, &d);
557
558   g_hash_table_foreach (hash,
559                         put_areas_into_list,
560                         &list);
561
562   for (cursor=list; cursor; cursor=cursor->next)
563     {
564       hildon_touch_selector_append_text (HILDON_TOUCH_SELECTOR (selector),
565                                          cursor->data);
566     }
567
568   hildon_picker_dialog_set_selector (HILDON_PICKER_DIALOG (dialog),
569                                      HILDON_TOUCH_SELECTOR (selector));
570
571   gtk_widget_show_all (GTK_WIDGET (dialog));
572
573   if (gtk_dialog_run (GTK_DIALOG (dialog))==GTK_RESPONSE_OK)
574     {
575       show_message (hildon_touch_selector_get_current_text (HILDON_TOUCH_SELECTOR (selector)));
576     }
577   g_hash_table_unref (hash);
578   gtk_widget_destroy (GTK_WIDGET (dialog));
579 }
580
581 static void
582 towers_by_area (void)
583 {
584   GtkWidget *dialog = hildon_picker_dialog_new (GTK_WINDOW (window));
585   GtkWidget *selector = hildon_touch_selector_new_text ();
586   GHashTable *hash = g_hash_table_new_full (g_str_hash,
587                                             g_str_equal,
588                                             g_free,
589                                             g_free);
590   GSList *list = NULL, *cursor;
591   gchar *result = NULL;
592
593   gtk_window_set_title (GTK_WINDOW (dialog), "Areas of the world");
594
595   parse_dove (get_countries_cb, NULL, hash);
596
597   g_hash_table_foreach (hash,
598                         put_areas_into_list,
599                         &list);
600
601   for (cursor=list; cursor; cursor=cursor->next)
602     {
603       hildon_touch_selector_append_text (HILDON_TOUCH_SELECTOR (selector),
604                                          cursor->data);
605     }
606
607   hildon_picker_dialog_set_selector (HILDON_PICKER_DIALOG (dialog),
608                                      HILDON_TOUCH_SELECTOR (selector));
609
610   gtk_widget_show_all (GTK_WIDGET (dialog));
611
612   if (gtk_dialog_run (GTK_DIALOG (dialog))==GTK_RESPONSE_OK)
613     {
614       result = g_strdup (hildon_touch_selector_get_current_text (HILDON_TOUCH_SELECTOR (selector)));
615     }
616   g_hash_table_unref (hash);
617   gtk_widget_destroy (GTK_WIDGET (dialog));
618
619   if (result)
620     {
621       towers_by_subarea (result);
622       g_free (result);
623     }
624 }
625
626 static void
627 show_towers_from_list (GSList *list)
628 {
629   GtkWidget *dialog;
630   GtkWidget *selector;
631   gchar *result = NULL;
632   GSList *cursor;
633
634   if (!list)
635     {
636       hildon_banner_show_information(window,
637                                      NULL,
638                                      "No towers found.");
639       return;
640     }
641
642   if (!list->next)
643     {
644       /* don't bother showing the list */
645       hildon_banner_show_information(window,
646                                      NULL,
647                                      "One tower found.");
648       show_tower (list->data);
649       return;
650     }
651
652   dialog = hildon_picker_dialog_new (GTK_WINDOW (window));
653   selector = hildon_touch_selector_new_text ();
654
655   for (cursor=list; cursor; cursor=cursor->next)
656     {
657       hildon_touch_selector_append_text (HILDON_TOUCH_SELECTOR (selector),
658                                          cursor->data);
659     }
660
661   hildon_picker_dialog_set_selector (HILDON_PICKER_DIALOG (dialog),
662                                      HILDON_TOUCH_SELECTOR (selector));
663
664   gtk_widget_show_all (GTK_WIDGET (dialog));
665
666   if (gtk_dialog_run (GTK_DIALOG (dialog))==GTK_RESPONSE_OK)
667     {
668       result = g_strdup (hildon_touch_selector_get_current_text (HILDON_TOUCH_SELECTOR (selector)));
669     }
670
671   gtk_widget_destroy (GTK_WIDGET (dialog));
672
673   if (result)
674     {
675       show_tower (result);
676       g_free (result);
677     }
678 }
679
680 static void
681 show_bookmarks (void)
682 {
683   GSList *test = NULL;
684   show_towers_from_list (test);
685 }
686
687 static void
688 tower_search (void)
689 {
690   GSList *test = NULL;
691   test = g_slist_append (test, "NORTON  HE");
692
693   show_towers_from_list (test);
694 }
695
696 static void
697 recent_towers (void)
698 {
699   GSList *test = NULL;
700   test = g_slist_append (test, "BARFORD");
701   test = g_slist_append (test, "BRAUGHING");
702
703   show_towers_from_list (test);
704 }
705
706 int
707 main(int argc, char **argv)
708 {
709   GtkWidget *bell, *button, *hbox;
710   GdkPixbuf *bell_picture;
711
712   gtk_init (&argc, &argv);
713   g_set_application_name ("Belltower");
714
715   window = hildon_stackable_window_new ();
716   gtk_window_set_title (GTK_WINDOW (window), "Belltower");
717   g_signal_connect (G_OBJECT (window), "delete_event", G_CALLBACK (gtk_main_quit), NULL);
718
719   bell_picture = gdk_pixbuf_new_from_file ("/usr/share/belltower/bells1.jpg", NULL);
720
721   buttons = gtk_vbox_new (TRUE, 0);
722   menu = HILDON_APP_MENU (hildon_app_menu_new ());
723
724   add_button ("Nearby", nearby_towers);
725   add_button ("Recent", recent_towers);
726   add_button ("Bookmarks", show_bookmarks);
727   add_button ("By area", towers_by_area);
728   add_button ("Search", tower_search);
729
730   /* extra buttons for the app menu */
731   button = gtk_button_new_with_label ("Credits");
732   hildon_app_menu_append (menu, GTK_BUTTON (button));
733   hildon_app_menu_append (menu, GTK_BUTTON (button));
734
735   gtk_widget_show_all (GTK_WIDGET (menu));
736   hildon_window_set_app_menu (HILDON_WINDOW (window), menu);
737
738   hbox = gtk_hbox_new (FALSE, 0);
739   gtk_box_pack_end (GTK_BOX (hbox), buttons, TRUE, TRUE, 0);
740   gtk_box_pack_end (GTK_BOX (hbox),
741                     gtk_image_new_from_pixbuf (bell_picture),
742                     TRUE, TRUE, 0);
743
744   gtk_container_add (GTK_CONTAINER (window), hbox);
745   gtk_widget_show_all (GTK_WIDGET (window));
746
747   gtk_main ();
748
749   return EXIT_SUCCESS;
750 }