| 1 | # Copyright 2007, 2008, 2009, 2010, 2011, 2013, 2014 Kevin Ryde | ||
| 2 | |||
| 3 | # This file is part of Chart. | ||
| 4 | # | ||
| 5 | # Chart is free software; you can redistribute it and/or modify it under the | ||
| 6 | # terms of the GNU General Public License as published by the Free Software | ||
| 7 | # Foundation; either version 3, or (at your option) any later version. | ||
| 8 | # | ||
| 9 | # Chart is distributed in the hope that it will be useful, but WITHOUT ANY | ||
| 10 | # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS | ||
| 11 | # FOR A PARTICULAR PURPOSE. See the GNU General Public License for more | ||
| 12 | # details. | ||
| 13 | # | ||
| 14 | # You should have received a copy of the GNU General Public License along | ||
| 15 | # with Chart. If not, see <http://www.gnu.org/licenses/>. | ||
| 16 | |||
| 17 | package App::Chart::Gtk2::RawDialog; | ||
| 18 | use 5.010; | ||
| 19 | use strict; | ||
| 20 | use warnings; | ||
| 21 | use Gtk2 1.220; | ||
| 22 | use Locale::TextDomain 1.18; | ||
| 23 | use Locale::TextDomain 'App-Chart'; | ||
| 24 | use List::Util qw(min max); | ||
| 25 | |||
| 26 | use Gtk2::Ex::Datasheet::DBI; | ||
| 27 | use Gtk2::Ex::WidgetCursor; | ||
| 28 | |||
| 29 | use Gtk2::Ex::Units; | ||
| 30 | |||
| 31 | # hack for Gtk2::Ex::Datasheet::DBI 2.1 | ||
| 32 | { package Gtk2::Ex::Datasheet::DBI::CellRendererText; | ||
| 33 | sub GET_SIZE { | ||
| 34 | my ($self, $widget, $cell_area) = @_; | ||
| 35 | return $self->SUPER::GET_SIZE ($widget, $cell_area); | ||
| 36 | } | ||
| 37 | } | ||
| 38 | |||
| 39 | use App::Chart::Gtk2::Ex::NotebookLazyPages; | ||
| 40 | use App::Chart::Gtk2::GUI; | ||
| 41 | use App::Chart::Intraday; | ||
| 42 | use App::Chart::Gtk2::SeriesTreeView; | ||
| 43 | use App::Chart::Gtk2::RawLatest; | ||
| 44 | use App::Chart::Gtk2::RawInfo; | ||
| 45 | |||
| 46 | # uncomment this to run the ### lines | ||
| 47 | #use Smart::Comments; | ||
| 48 | |||
| 49 | |||
| 50 | use Glib::Object::Subclass | ||
| 51 | 'Gtk2::Dialog', | ||
| 52 | properties => [Glib::ParamSpec->string | ||
| 53 | ('symbol', | ||
| 54 | __('Symbol'), | ||
| 55 | 'The symbol to display.', | ||
| 56 | '', # default | ||
| 57 | Glib::G_PARAM_READWRITE),]; | ||
| 58 | |||
| 59 | |||
| 60 | use constant { RESPONSE_INSERT => 0, | ||
| 61 | RESPONSE_DELETE => 1, | ||
| 62 | RESPONSE_APPLY => 2, | ||
| 63 | RESPONSE_UNDO => 3, | ||
| 64 | RESPONSE_REFRESH => 4, | ||
| 65 | }; | ||
| 66 | |||
| 67 | # sub _do_edited { | ||
| 68 | # my ($cell, $pathstr, $newstr, $self) = @_; | ||
| 69 | # my $path = Gtk2::TreePath->new_from_string ($pathstr); | ||
| 70 | # my $model = $self->{'model'}; | ||
| 71 | # my $treeview = $self->{'treeview'}; | ||
| 72 | # my $iter = $model->get_iter ($path); | ||
| 73 | # my ($treepath, $treeviewcolumn) = $treeview->get_cursor; | ||
| 74 | # my $col = $treeviewcolumn->{'model_col'}; | ||
| 75 | # $model->set_value ($iter, $col, $newstr); | ||
| 76 | # } | ||
| 77 | |||
| 78 | # sub _do_data_changed { | ||
| 79 | # my ($self, $symbol_hash) = @_; | ||
| 80 | # my $symbol = $self->{'symbol'}; | ||
| 81 | # if (List::Util::first {$_ eq $symbol} @symbol_list) { | ||
| 82 | # $self->refresh; | ||
| 83 | # } | ||
| 84 | # } | ||
| 85 | |||
| 86 | sub INIT_INSTANCE { | ||
| 87 | my ($self) = @_; | ||
| 88 | $self->set_title (__('Chart: RawDialog')); | ||
| 89 | $self->{'symbol'} = ''; # default | ||
| 90 | |||
| 91 | # App::Chart::chart_dirbroadcast()->connect_for_object ('data-changed', | ||
| 92 | # \&_do_data_changed, $self); | ||
| 93 | |||
| 94 | $self->add_buttons ('gtk-add' => RESPONSE_INSERT, | ||
| 95 | 'gtk-delete' => RESPONSE_DELETE, | ||
| 96 | 'gtk-apply' => RESPONSE_APPLY, | ||
| 97 | 'gtk-undo' => RESPONSE_UNDO, | ||
| 98 | 'gtk-refresh' => RESPONSE_REFRESH, | ||
| 99 | 'gtk-close' => 'close', | ||
| 100 | 'gtk-help' => 'help'); | ||
| 101 | $self->signal_connect ('response', \&_do_response); | ||
| 102 | |||
| 103 | my $vbox = $self->vbox; | ||
| 104 | |||
| 105 | $vbox->pack_start (Gtk2::Label->new | ||
| 106 | ('Warning, this dialog is not quite right.'), | ||
| 107 | 0,0,0); | ||
| 108 | |||
| 109 | my $notebook = $self->{'notebook'} = Gtk2::Notebook->new; | ||
| 110 | $vbox->pack_start ($notebook, 1,1,0); | ||
| 111 | |||
| 112 | { | ||
| 113 | my $scrolled = Gtk2::ScrolledWindow->new; | ||
| 114 | $notebook->append_page ($scrolled, __('Series')); | ||
| 115 | App::Chart::Gtk2::Ex::NotebookLazyPages::set_init | ||
| 116 | ($notebook, $scrolled, \&_init_series); | ||
| 117 | } | ||
| 118 | { | ||
| 119 | my $div_vbox = Gtk2::VBox->new; | ||
| 120 | $notebook->append_page ($div_vbox, __('Dividends')); | ||
| 121 | App::Chart::Gtk2::Ex::NotebookLazyPages::set_init | ||
| 122 | ($notebook, $div_vbox, \&_init_dividends); | ||
| 123 | } | ||
| 124 | { | ||
| 125 | my $split_vbox = Gtk2::VBox->new; | ||
| 126 | $notebook->append_page ($split_vbox, __('Splits')); | ||
| 127 | App::Chart::Gtk2::Ex::NotebookLazyPages::set_init | ||
| 128 | ($notebook, $split_vbox, \&_init_splits); | ||
| 129 | } | ||
| 130 | |||
| 131 | { | ||
| 132 | my $scrolled = Gtk2::ScrolledWindow->new; | ||
| 133 | $notebook->append_page ($scrolled, __('Latest')); | ||
| 134 | App::Chart::Gtk2::Ex::NotebookLazyPages::set_init | ||
| 135 | ($notebook, $scrolled, \&_init_latest); | ||
| 136 | } | ||
| 137 | |||
| 138 | { | ||
| 139 | my $scrolled = Gtk2::ScrolledWindow->new; | ||
| 140 | $notebook->append_page ($scrolled, __('Info')); | ||
| 141 | App::Chart::Gtk2::Ex::NotebookLazyPages::set_init | ||
| 142 | ($notebook, $scrolled, \&_init_info); | ||
| 143 | } | ||
| 144 | |||
| 145 | { | ||
| 146 | my $scrolled = Gtk2::ScrolledWindow->new; | ||
| 147 | $notebook->append_page ($scrolled, __('Extra')); | ||
| 148 | App::Chart::Gtk2::Ex::NotebookLazyPages::set_init | ||
| 149 | ($notebook, $scrolled, \&_init_extra); | ||
| 150 | } | ||
| 151 | |||
| 152 | { | ||
| 153 | my $scrolled = Gtk2::ScrolledWindow->new; | ||
| 154 | $notebook->append_page ($scrolled, __('Intraday')); | ||
| 155 | App::Chart::Gtk2::Ex::NotebookLazyPages::set_init | ||
| 156 | ($notebook, $scrolled, \&_init_intraday); | ||
| 157 | } | ||
| 158 | |||
| 159 | { | ||
| 160 | my $scrolled = Gtk2::ScrolledWindow->new; | ||
| 161 | $notebook->append_page ($scrolled, __('Lines')); | ||
| 162 | App::Chart::Gtk2::Ex::NotebookLazyPages::set_init | ||
| 163 | ($notebook, $scrolled, \&_init_lines); | ||
| 164 | } | ||
| 165 | |||
| 166 | { | ||
| 167 | my $scrolled = Gtk2::ScrolledWindow->new; | ||
| 168 | $notebook->append_page ($scrolled, __('Alerts')); | ||
| 169 | App::Chart::Gtk2::Ex::NotebookLazyPages::set_init | ||
| 170 | ($notebook, $scrolled, \&_init_alerts); | ||
| 171 | } | ||
| 172 | |||
| 173 | { | ||
| 174 | my $scrolled = Gtk2::ScrolledWindow->new; | ||
| 175 | $notebook->append_page ($scrolled, __('Weblinks')); | ||
| 176 | App::Chart::Gtk2::Ex::NotebookLazyPages::set_init | ||
| 177 | ($notebook, $scrolled, \&_init_weblinks); | ||
| 178 | } | ||
| 179 | |||
| 180 | $notebook->signal_connect ('notify::page' => \&_do_notebook_page); | ||
| 181 | $notebook->set_current_page (1); | ||
| 182 | _do_notebook_page ($notebook, undef); # initial button sensitives | ||
| 183 | |||
| 184 | my $hbox = Gtk2::HBox->new (0, 0); | ||
| 185 | $vbox->pack_start ($hbox, 0,0,0); | ||
| 186 | $hbox->pack_start (Gtk2::Label->new (__('Symbol')), 0,0,0); | ||
| 187 | my $entry = $self->{'entry'} = Gtk2::Entry->new; | ||
| 188 | $hbox->pack_start ($entry, 1, 1, 0.5 * Gtk2::Ex::Units::em($entry)); | ||
| 189 | $entry->signal_connect (activate => \&_do_entry_activate); | ||
| 190 | $entry->grab_focus; | ||
| 191 | |||
| 192 | $vbox->show_all; | ||
| 193 | |||
| 194 | # Size per a sensible height for the notebook. | ||
| 195 | |||
| 196 | # With all the scrolleds in 'never' mode they give their contained | ||
| 197 | # treeviews as their width. | ||
| 198 | # FIXME: ... which is not true any more ... | ||
| 199 | Gtk2::Ex::Units::set_default_size_with_subsizes | ||
| 200 | ($self, [$notebook, -1, '25 lines']); | ||
| 201 | } | ||
| 202 | |||
| 203 | sub _init_series { | ||
| 204 | my ($notebook, $scrolled, $pagenum) = @_; | ||
| 205 | |||
| 206 | $scrolled->{'dirty'} = 1; | ||
| 207 | $scrolled->set (hscrollbar_policy => 'automatic'); | ||
| 208 | |||
| 209 | my $treeview = $scrolled->{'seriestreeview'} | ||
| 210 | = App::Chart::Gtk2::SeriesTreeView->new; | ||
| 211 | $scrolled->add ($treeview); | ||
| 212 | |||
| 213 | $scrolled->show_all; | ||
| 214 | } | ||
| 215 | |||
| 216 | sub _init_dividends { | ||
| 217 | my ($notebook, $vbox, $pagenum) = @_; | ||
| 218 | |||
| 219 | my $self = $notebook->get_toplevel; | ||
| 220 | my $scrolled = Gtk2::ScrolledWindow->new; | ||
| 221 | $scrolled->set (hscrollbar_policy => 'never'); | ||
| 222 | $vbox->pack_start ($scrolled, 1,1,0); | ||
| 223 | |||
| 224 | my $treeview = Gtk2::TreeView->new; | ||
| 225 | $scrolled->add ($treeview); | ||
| 226 | |||
| 227 | require App::Chart::DBI; | ||
| 228 | my $dbh = App::Chart::DBI->instance; | ||
| 229 | |||
| 230 | my $em = Gtk2::Ex::Units::em($self); | ||
| 231 | my $date_width = App::Chart::Gtk2::GUI::string_width ($treeview, '2099-99-99 '); | ||
| 232 | my $date_width_editable = $date_width * 1.4; # diff font, and pulldown | ||
| 233 | my $digit_width = Gtk2::Ex::Units::digit_width ($self); | ||
| 234 | |||
| 235 | my $datasheet = Gtk2::Ex::Datasheet::DBI->new | ||
| 236 | ({ dbh => $dbh, | ||
| 237 | sql => { select => 'ex_date, record_date, pay_date, amount, imputation, type, qualifier, note', | ||
| 238 | from => 'dividend', | ||
| 239 | order_by => 'ex_date DESC', | ||
| 240 | where => 'symbol=?', | ||
| 241 | bind_values => [ '' ], | ||
| 242 | }, | ||
| 243 | treeview => $treeview, | ||
| 244 | fields => [ { name => 'ex_date', | ||
| 245 | header_markup => __('Ex'), | ||
| 246 | x_absolute => $date_width_editable, | ||
| 247 | validation => \&validate_date, | ||
| 248 | # renderer => 'date', | ||
| 249 | }, | ||
| 250 | { name => 'record_date', | ||
| 251 | header_markup => __('Record'), | ||
| 252 | x_absolute => $date_width_editable, | ||
| 253 | validation => \&validate_date, | ||
| 254 | # renderer => 'date', | ||
| 255 | }, | ||
| 256 | { name => 'pay_date', | ||
| 257 | header_markup => __('Pay'), | ||
| 258 | x_absolute => $date_width_editable, | ||
| 259 | validation => \&validate_date, | ||
| 260 | # renderer => 'date', | ||
| 261 | }, | ||
| 262 | { name => 'amount', | ||
| 263 | header_markup => __('Amount'), | ||
| 264 | align => 'right', | ||
| 265 | x_absolute => 8 * $digit_width, | ||
| 266 | validation => \&validate_number, | ||
| 267 | }, | ||
| 268 | { name => 'imputation', | ||
| 269 | header_markup => __('Imputation'), | ||
| 270 | align => 'right', | ||
| 271 | x_absolute => 8 * $digit_width, | ||
| 272 | validation => \&validate_number, | ||
| 273 | }, | ||
| 274 | { name => 'type', | ||
| 275 | header_markup => __('Type'), | ||
| 276 | x_absolute => 6 * $em, | ||
| 277 | }, | ||
| 278 | { name => 'qualifier', | ||
| 279 | header_markup => __('Qualifier'), | ||
| 280 | x_absolute => 6 * $em, | ||
| 281 | }, | ||
| 282 | { name => 'note', | ||
| 283 | header_markup => __('Note'), | ||
| 284 | x_absolute => 10 * $em, | ||
| 285 | }, | ||
| 286 | ], | ||
| 287 | }); | ||
| 288 | $vbox->{'insert_defaults'} = \&_dividends_insert_defaults; | ||
| 289 | _datasheet_init ($self, $vbox, $datasheet); | ||
| 290 | } | ||
| 291 | sub _dividends_insert_defaults { | ||
| 292 | my ($self, $pagewidget) = @_; | ||
| 293 | my $datasheet = $pagewidget->{'datasheet'}; | ||
| 294 | my $num = $datasheet->{'column_name_to_number_mapping'}; | ||
| 295 | return ($num->{'ex_date'}, $self->default_date, | ||
| 296 | $num->{'amount'}, 0, | ||
| 297 | $num->{'note'}, ''); | ||
| 298 | } | ||
| 299 | |||
| 300 | sub default_date { | ||
| 301 | my ($self) = @_; | ||
| 302 | my $symbol = $self->{'symbol'} // ''; | ||
| 303 | my $timezone = App::Chart::TZ->for_symbol ($symbol); | ||
| 304 | require App::Chart::Download; | ||
| 305 | my $tdate = App::Chart::Download::tdate_today ($timezone); | ||
| 306 | return App::Chart::tdate_to_iso($tdate); | ||
| 307 | } | ||
| 308 | |||
| 309 | sub _init_splits { | ||
| 310 | my ($notebook, $vbox, $pagenum) = @_; | ||
| 311 | |||
| 312 | my $self = $notebook->get_toplevel; | ||
| 313 | my $scrolled = Gtk2::ScrolledWindow->new; | ||
| 314 | $scrolled->set (hscrollbar_policy => 'never'); | ||
| 315 | $vbox->pack_start ($scrolled, 1,1,0); | ||
| 316 | |||
| 317 | my $treeview = Gtk2::TreeView->new; | ||
| 318 | $scrolled->add ($treeview); | ||
| 319 | |||
| 320 | require App::Chart::DBI; | ||
| 321 | my $dbh = App::Chart::DBI->instance; | ||
| 322 | |||
| 323 | my $em = Gtk2::Ex::Units::em($self); | ||
| 324 | my $date_width = App::Chart::Gtk2::GUI::string_width ($treeview, '2099-99-99 '); | ||
| 325 | my $date_width_editable = $date_width * 1.4; # diff font, and pulldown | ||
| 326 | my $digit_width = Gtk2::Ex::Units::digit_width ($self); | ||
| 327 | |||
| 328 | my $datasheet = Gtk2::Ex::Datasheet::DBI->new | ||
| 329 | ({ dbh => $dbh, | ||
| 330 | sql => { select => 'date, new, old, note', | ||
| 331 | from => 'split', | ||
| 332 | order_by => 'date DESC', | ||
| 333 | where => 'symbol=?', | ||
| 334 | bind_values => [ '' ], | ||
| 335 | }, | ||
| 336 | treeview => $treeview, | ||
| 337 | fields => [ { name => 'date', | ||
| 338 | header_markup => __('Date'), | ||
| 339 | x_absolute => $date_width_editable, | ||
| 340 | validation => \&validate_date, | ||
| 341 | # renderer => 'date', | ||
| 342 | }, | ||
| 343 | { name => 'new', | ||
| 344 | header_markup => __('New'), | ||
| 345 | align => 'right', | ||
| 346 | x_absolute => 3 * $digit_width, | ||
| 347 | validation => \&validate_number, | ||
| 348 | }, | ||
| 349 | { name => 'old', | ||
| 350 | header_markup => __('Old'), | ||
| 351 | align => 'right', | ||
| 352 | x_absolute => 3 * $digit_width, | ||
| 353 | validation => \&validate_number, | ||
| 354 | }, | ||
| 355 | { name => 'note', | ||
| 356 | header_markup => __('Note'), | ||
| 357 | x_absolute => 10 * $em, | ||
| 358 | }, | ||
| 359 | ], | ||
| 360 | }); | ||
| 361 | _datasheet_init ($self, $vbox, $datasheet); | ||
| 362 | $vbox->{'insert_defaults'} = \&_splits_insert_defaults; | ||
| 363 | } | ||
| 364 | sub _splits_insert_defaults { | ||
| 365 | my ($self, $pagewidget) = @_; | ||
| 366 | my $datasheet = $pagewidget->{'datasheet'}; | ||
| 367 | my $num = $datasheet->{'column_name_to_number_mapping'}; | ||
| 368 | return ($num->{'date'}, $self->default_date, | ||
| 369 | $num->{'new'}, 1, | ||
| 370 | $num->{'old'}, 1, | ||
| 371 | $num->{'note'}, ''); | ||
| 372 | } | ||
| 373 | |||
| 374 | sub _init_latest { | ||
| 375 | my ($notebook, $scrolled, $pagenum) = @_; | ||
| 376 | |||
| 377 | $scrolled->{'dirty'} = 1; | ||
| 378 | $scrolled->set (hscrollbar_policy => 'never'); # label wrap | ||
| 379 | |||
| 380 | my $viewport = Gtk2::Viewport->new; | ||
| 381 | $scrolled->add ($viewport); | ||
| 382 | |||
| 383 | my $rawlatest = $scrolled->{'rawlatest'} = App::Chart::Gtk2::RawLatest->new; | ||
| 384 | $viewport->add ($rawlatest); | ||
| 385 | |||
| 386 | $scrolled->show_all; | ||
| 387 | } | ||
| 388 | |||
| 389 | sub _init_info { | ||
| 390 | my ($notebook, $scrolled, $pagenum) = @_; | ||
| 391 | |||
| 392 | $scrolled->{'dirty'} = 1; | ||
| 393 | $scrolled->set (hscrollbar_policy => 'never'); # label wrap | ||
| 394 | |||
| 395 | my $viewport = Gtk2::Viewport->new; | ||
| 396 | $scrolled->add ($viewport); | ||
| 397 | |||
| 398 | my $rawinfo = $scrolled->{'rawinfo'} = App::Chart::Gtk2::RawInfo->new; | ||
| 399 | $viewport->add ($rawinfo); | ||
| 400 | |||
| 401 | $scrolled->show_all; | ||
| 402 | } | ||
| 403 | |||
| 404 | sub _init_extra { | ||
| 405 | my ($notebook, $scrolled, $pagenum) = @_; | ||
| 406 | my $self = $notebook->get_toplevel; | ||
| 407 | |||
| 408 | $scrolled->set (hscrollbar_policy => 'automatic'); | ||
| 409 | |||
| 410 | my $treeview = Gtk2::TreeView->new; | ||
| 411 | $scrolled->add ($treeview); | ||
| 412 | |||
| 413 | require App::Chart::DBI; | ||
| 414 | my $dbh = App::Chart::DBI->instance; | ||
| 415 | my $em = Gtk2::Ex::Units::em($self); | ||
| 416 | |||
| 417 | my $datasheet = Gtk2::Ex::Datasheet::DBI->new | ||
| 418 | ({ dbh => $dbh, | ||
| 419 | sql => { select => 'key, value', | ||
| 420 | from => 'extra', | ||
| 421 | order_by => 'key ASC', | ||
| 422 | where => 'symbol=?', | ||
| 423 | bind_values => [ '' ], | ||
| 424 | }, | ||
| 425 | treeview => $treeview, | ||
| 426 | fields => [ | ||
| 427 | { name => 'key', | ||
| 428 | header_markup => __('Key'), | ||
| 429 | x_absolute => 15 * $em, | ||
| 430 | }, | ||
| 431 | { name => 'value', | ||
| 432 | header_markup => __('Value'), | ||
| 433 | x_absolute => 15 * $em, | ||
| 434 | }, | ||
| 435 | ], | ||
| 436 | }); | ||
| 437 | $scrolled->{'insert_defaults'} = \&_extra_insert_defaults; | ||
| 438 | _datasheet_init ($self, $scrolled, $datasheet); | ||
| 439 | } | ||
| 440 | sub _extra_insert_defaults { | ||
| 441 | my ($self, $pagewidget) = @_; | ||
| 442 | return; | ||
| 443 | } | ||
| 444 | |||
| 445 | sub _init_intraday { | ||
| 446 | my ($notebook, $scrolled, $pagenum) = @_; | ||
| 447 | my $self = $notebook->get_toplevel; | ||
| 448 | |||
| 449 | $scrolled->set (hscrollbar_policy => 'automatic'); | ||
| 450 | |||
| 451 | my $treeview = Gtk2::TreeView->new; | ||
| 452 | $scrolled->add ($treeview); | ||
| 453 | |||
| 454 | require App::Chart::DBI; | ||
| 455 | my $dbh = App::Chart::DBI->instance; | ||
| 456 | my $em = Gtk2::Ex::Units::em($self); | ||
| 457 | my $digit_width = Gtk2::Ex::Units::digit_width ($self); | ||
| 458 | |||
| 459 | my $datasheet = Gtk2::Ex::Datasheet::DBI->new | ||
| 460 | ({ dbh => $dbh, | ||
| 461 | sql => { select => 'mode, error, fetch_timestamp, url, etag, last_modified', | ||
| 462 | from => 'intraday_image', | ||
| 463 | order_by => 'mode ASC', | ||
| 464 | where => 'symbol=?', | ||
| 465 | bind_values => [ '' ], | ||
| 466 | }, | ||
| 467 | treeview => $treeview, | ||
| 468 | fields => [ { name => 'mode', | ||
| 469 | header_markup => __('Mode'), | ||
| 470 | x_absolute => 4 * $em, | ||
| 471 | }, | ||
| 472 | { name => 'error', | ||
| 473 | header_markup => __('Error'), | ||
| 474 | x_absolute => 10 * $em, | ||
| 475 | }, | ||
| 476 | { name => 'fetch_timestamp', | ||
| 477 | header_markup => __('Fetch Timestamp'), | ||
| 478 | x_absolute => (length('2009-03-09 22:01:31+00:00') | ||
| 479 | * $digit_width), | ||
| 480 | validation => \&validate_integer, | ||
| 481 | }, | ||
| 482 | { name => 'url', | ||
| 483 | header_markup => __('URL'), | ||
| 484 | x_absolute => 10 * $em, | ||
| 485 | }, | ||
| 486 | { name => 'etag', | ||
| 487 | header_markup => __('ETag'), | ||
| 488 | x_absolute => 10 * $em, | ||
| 489 | }, | ||
| 490 | { name => 'last_modified', | ||
| 491 | header_markup => __('Last Modified'), | ||
| 492 | x_absolute => 10 * $em, | ||
| 493 | }, | ||
| 494 | ], | ||
| 495 | multi_select => 1, | ||
| 496 | }); | ||
| 497 | _datasheet_init ($self, $scrolled, $datasheet); | ||
| 498 | } | ||
| 499 | |||
| 500 | sub _init_lines { | ||
| 501 | my ($notebook, $scrolled, $pagenum) = @_; | ||
| 502 | my $self = $notebook->get_toplevel; | ||
| 503 | |||
| 504 | $scrolled->set (hscrollbar_policy => 'automatic'); | ||
| 505 | |||
| 506 | my $treeview = Gtk2::TreeView->new; | ||
| 507 | $scrolled->add ($treeview); | ||
| 508 | |||
| 509 | require App::Chart::DBI; | ||
| 510 | my $dbh = App::Chart::DBI->instance; | ||
| 511 | my $date_width = App::Chart::Gtk2::GUI::string_width ($treeview, '2099-99-99 '); | ||
| 512 | my $date_width_editable = $date_width * 1.4; # diff font, and pulldown | ||
| 513 | my $em = Gtk2::Ex::Units::em($treeview); | ||
| 514 | my $digit_width = Gtk2::Ex::Units::digit_width ($self); | ||
| 515 | |||
| 516 | my $datasheet = Gtk2::Ex::Datasheet::DBI->new | ||
| 517 | ({ dbh => $dbh, | ||
| 518 | sql => { select => 'id,date1,price1,date2,price2,horizontal', | ||
| 519 | from => 'line', | ||
| 520 | order_by => 'id ASC', | ||
| 521 | where => 'symbol=?', | ||
| 522 | bind_values => [ '' ], | ||
| 523 | }, | ||
| 524 | treeview => $treeview, | ||
| 525 | fields => [ | ||
| 526 | { name => 'id', | ||
| 527 | header_markup => __('Id'), | ||
| 528 | x_absolute => 3 * $em, | ||
| 529 | }, | ||
| 530 | { name => 'date1', | ||
| 531 | header_markup => __('Date1'), | ||
| 532 | x_absolute => $date_width_editable, | ||
| 533 | validation => \&validate_date, | ||
| 534 | # renderer => 'date', | ||
| 535 | }, | ||
| 536 | { name => 'price1', | ||
| 537 | header_markup => __('Price1'), | ||
| 538 | x_absolute => 15 * $digit_width, | ||
| 539 | validation => \&validate_number, | ||
| 540 | }, | ||
| 541 | { name => 'date2', | ||
| 542 | header_markup => __('Date2'), | ||
| 543 | x_absolute => $date_width_editable, | ||
| 544 | validation => \&validate_date, | ||
| 545 | # renderer => 'date', | ||
| 546 | }, | ||
| 547 | { name => 'price2', | ||
| 548 | header_markup => __('Price2'), | ||
| 549 | x_absolute => 15 * $digit_width, | ||
| 550 | validation => \&validate_number, | ||
| 551 | }, | ||
| 552 | { name => 'horizontal', | ||
| 553 | header_markup => __('Horizontal'), | ||
| 554 | # validation => \&validate_boolean, | ||
| 555 | }, | ||
| 556 | ], | ||
| 557 | }); | ||
| 558 | _datasheet_init ($self, $scrolled, $datasheet); | ||
| 559 | $scrolled->{'insert_defaults'} = \&_lines_insert_defaults; | ||
| 560 | } | ||
| 561 | sub _lines_insert_defaults { | ||
| 562 | my ($self, $pagewidget) = @_; | ||
| 563 | my $datasheet = $pagewidget->{'datasheet'}; | ||
| 564 | my $num = $datasheet->{'column_name_to_number_mapping'}; | ||
| 565 | #### $num | ||
| 566 | my $date = $self->default_date; | ||
| 567 | return ($num->{'date1'}, $date, | ||
| 568 | $num->{'price1'}, 0, | ||
| 569 | $num->{'date2'}, $date, | ||
| 570 | $num->{'price2'}, 1); | ||
| 571 | } | ||
| 572 | |||
| 573 | sub _init_alerts { | ||
| 574 | my ($notebook, $scrolled, $pagenum) = @_; | ||
| 575 | my $self = $notebook->get_toplevel; | ||
| 576 | |||
| 577 | $scrolled->set (hscrollbar_policy => 'automatic'); | ||
| 578 | |||
| 579 | my $treeview = Gtk2::TreeView->new; | ||
| 580 | $scrolled->add ($treeview); | ||
| 581 | |||
| 582 | require App::Chart::DBI; | ||
| 583 | my $dbh = App::Chart::DBI->instance; | ||
| 584 | my $em = Gtk2::Ex::Units::em($treeview); | ||
| 585 | my $digit_width = Gtk2::Ex::Units::digit_width ($self); | ||
| 586 | |||
| 587 | my $datasheet = Gtk2::Ex::Datasheet::DBI->new | ||
| 588 | ({ dbh => $dbh, | ||
| 589 | sql => { select => 'id,price,above', | ||
| 590 | from => 'alert', | ||
| 591 | order_by => 'id ASC', | ||
| 592 | where => 'symbol=?', | ||
| 593 | bind_values => [ '' ], | ||
| 594 | }, | ||
| 595 | treeview => $treeview, | ||
| 596 | fields => [ | ||
| 597 | { name => 'id', | ||
| 598 | header_markup => __('Id'), | ||
| 599 | x_absolute => 3 * $em, | ||
| 600 | }, | ||
| 601 | { name => 'price1', | ||
| 602 | header_markup => __('Price1'), | ||
| 603 | x_absolute => 15 * $digit_width, | ||
| 604 | validation => \&validate_number, | ||
| 605 | }, | ||
| 606 | { name => 'above', | ||
| 607 | header_markup => __('Above'), | ||
| 608 | # validation => \&validate_boolean, | ||
| 609 | }, | ||
| 610 | ], | ||
| 611 | }); | ||
| 612 | |||
| 613 | _datasheet_init ($self, $scrolled, $datasheet); | ||
| 614 | } | ||
| 615 | |||
| 616 | sub _datasheet_init { | ||
| 617 | my ($self, $pagewidget, $datasheet) = @_; | ||
| 618 | |||
| 619 | my $scrolled = $pagewidget; | ||
| 620 | if ($pagewidget->isa ('Gtk2::VBox')) { | ||
| 621 | ($scrolled) = $pagewidget->get_children; | ||
| 622 | if ($datasheet->{'read_only'}) { | ||
| 623 | $pagewidget->pack_start (Gtk2::Label->new(__('*** Read only ***')), | ||
| 624 | 0,0,0); | ||
| 625 | } | ||
| 626 | } | ||
| 627 | |||
| 628 | $pagewidget->{'dirty'} = 1; | ||
| 629 | $pagewidget->{'datasheet'} = $datasheet; | ||
| 630 | push @{$self->{'datasheets'}}, $datasheet; | ||
| 631 | |||
| 632 | my $treeview = $scrolled->get_child; | ||
| 633 | foreach my $column ($treeview->get_columns) { | ||
| 634 | $column->set (resizable => 1); | ||
| 635 | $column->set_sizing ('fixed'); | ||
| 636 | } | ||
| 637 | $treeview->set_fixed_height_mode (1); | ||
| 638 | |||
| 639 | $pagewidget->show_all; | ||
| 640 | _refresh_page ($pagewidget); | ||
| 641 | } | ||
| 642 | |||
| 643 | sub _init_weblinks { | ||
| 644 | my ($notebook, $scrolled, $pagenum) = @_; | ||
| 645 | |||
| 646 | $scrolled->set (hscrollbar_policy => 'automatic'); | ||
| 647 | |||
| 648 | my $treeview = Gtk2::TreeView->new; | ||
| 649 | $treeview->set (tooltip_column => 2); | ||
| 650 | $treeview->signal_connect (row_activated => \&_do_weblink_row_activate); | ||
| 651 | $treeview->signal_connect (button_press_event => \&_do_weblink_button_press); | ||
| 652 | $scrolled->add ($treeview); | ||
| 653 | |||
| 654 | my $store = $scrolled->{'weblinks_store'} | ||
| 655 | = Gtk2::ListStore->new ('Glib::String', 'Glib::String', 'Glib::String'); | ||
| 656 | $treeview->set_model ($store); | ||
| 657 | |||
| 658 | my $renderer = Gtk2::CellRendererText->new; | ||
| 659 | $renderer->set (xalign => 0, | ||
| 660 | ypad => 0); | ||
| 661 | $renderer->set_fixed_height_from_font (1); | ||
| 662 | |||
| 663 | my $em = Gtk2::Ex::Units::em($treeview); | ||
| 664 | { | ||
| 665 | my $column = Gtk2::TreeViewColumn->new_with_attributes | ||
| 666 | (__('Name'), $renderer, markup => 0); | ||
| 667 | $column->set (sizing => 'fixed', | ||
| 668 | fixed_width => 20*$em, | ||
| 669 | resizable => 1); | ||
| 670 | $treeview->append_column ($column); | ||
| 671 | } | ||
| 672 | { | ||
| 673 | my $column = Gtk2::TreeViewColumn->new_with_attributes | ||
| 674 | (__('URL'), $renderer, text => 1); | ||
| 675 | $column->set (sizing => 'fixed', | ||
| 676 | fixed_width => 60*$em, | ||
| 677 | resizable => 1); | ||
| 678 | $column->{'menu_func'} = \&_do_weblink_menu_popup; | ||
| 679 | $treeview->append_column ($column); | ||
| 680 | } | ||
| 681 | $scrolled->show_all; | ||
| 682 | } | ||
| 683 | sub _do_weblink_row_activate { | ||
| 684 | my ($treeview, $path, $column) = @_; | ||
| 685 | my $url = _do_weblink_row_url ($treeview, $path); | ||
| 686 | require App::Chart::Gtk2::GUI; | ||
| 687 | App::Chart::Gtk2::GUI::browser_open ($url); | ||
| 688 | } | ||
| 689 | sub _do_weblink_row_url { | ||
| 690 | my ($treeview, $path) = @_; | ||
| 691 | my $store = $treeview->get_model; | ||
| 692 | my $iter = $store->get_iter ($path); | ||
| 693 | return $store->get_value ($iter, 1); | ||
| 694 | } | ||
| 695 | sub mnemonic_to_markup { | ||
| 696 | my ($str) = @_; | ||
| 697 | $str = Glib::Markup::escape_text($str); | ||
| 698 | $str =~ s{_(.)}{$1 eq '_' ? '' : "<u>$1</u>"}eg; | ||
| 699 | return $str; | ||
| 700 | } | ||
| 701 | # 'button-press-event' on the weblink TreeView | ||
| 702 | sub _do_weblink_button_press { | ||
| 703 | my ($treeview, $event) = @_; | ||
| 704 | my ($path, $column) = $treeview->get_path_at_pos ($event->x, $event->y); | ||
| 705 | if (!$path) { return; } | ||
| 706 | if (my $func = $column->{'menu_func'}) { | ||
| 707 | $func->($treeview, $event, $path); | ||
| 708 | } | ||
| 709 | return Gtk2::EVENT_PROPAGATE; | ||
| 710 | } | ||
| 711 | sub _do_weblink_menu_popup { | ||
| 712 | my ($treeview, $event, $path) = @_; | ||
| 713 | my $menu = Gtk2::Menu->new; | ||
| 714 | $menu->set_screen ($treeview->get_screen); | ||
| 715 | my $url = _do_weblink_row_url ($treeview, $path); | ||
| 716 | { | ||
| 717 | my $item = Gtk2::ImageMenuItem->new_from_stock ('gtk-open'); | ||
| 718 | $item->{'url'} = $url; | ||
| 719 | $item->signal_connect (activate => \&_do_weblink_menu_open); | ||
| 720 | $menu->append ($item); | ||
| 721 | } | ||
| 722 | # LinkButton of Gtk 2.14 has a "Copy URL" message string (translated etc), | ||
| 723 | # could show that | ||
| 724 | { | ||
| 725 | my $item = Gtk2::ImageMenuItem->new_from_stock ('gtk-copy'); | ||
| 726 | $item->{'url'} = $url; | ||
| 727 | $item->signal_connect (activate => \&_do_weblink_menu_copy); | ||
| 728 | $menu->append ($item); | ||
| 729 | } | ||
| 730 | $menu->show_all; | ||
| 731 | $menu->popup (undef, undef, undef, undef, | ||
| 732 | $event->button, $event->time); | ||
| 733 | } | ||
| 734 | sub _do_weblink_menu_open { | ||
| 735 | my ($item) = @_; | ||
| 736 | require App::Chart::Gtk2::GUI; | ||
| 737 | App::Chart::Gtk2::GUI::browser_open ($item->{'url'}); | ||
| 738 | } | ||
| 739 | sub _do_weblink_menu_copy { | ||
| 740 | my ($item) = @_; | ||
| 741 | my $clipboard = Gtk2::Clipboard->get_for_display | ||
| 742 | ($item->get_display, Gtk2::Gdk::Atom->new('PRIMARY')); | ||
| 743 | $clipboard->set_text ($item->{'url'}); | ||
| 744 | } | ||
| 745 | |||
| 746 | sub set_symbol { | ||
| 747 | my ($self, $symbol) = @_; | ||
| 748 | if (! defined $symbol) { $symbol = ''; } | ||
| 749 | if ($symbol eq $self->{'symbol'}) { return; } | ||
| 750 | |||
| 751 | if ($symbol) { | ||
| 752 | $self->set_title (__x('Chart: RawDialog: {symbol}', | ||
| 753 | symbol => $symbol)); | ||
| 754 | } else { | ||
| 755 | $self->set_title (__('Chart: RawDialog')); | ||
| 756 | } | ||
| 757 | $self->{'symbol'} = $symbol; # per default GET_PROPERTY | ||
| 758 | $self->{'entry'}->set_text ($symbol); | ||
| 759 | $self->refresh; | ||
| 760 | $self->notify ('symbol'); | ||
| 761 | } | ||
| 762 | |||
| 763 | sub SET_PROPERTY { | ||
| 764 | my ($self, $pspec, $newval) = @_; | ||
| 765 | my $pname = $pspec->get_name; | ||
| 766 | if ($pspec->get_name eq 'symbol') { | ||
| 767 | $self->set_symbol ($newval); | ||
| 768 | } else { | ||
| 769 | $self->{$pname} = $newval; # per default GET_PROPERTY | ||
| 770 | } | ||
| 771 | } | ||
| 772 | |||
| 773 | # 'notify::page' signal on the Gtk2::Notebook | ||
| 774 | sub _do_notebook_page { | ||
| 775 | my ($notebook) = @_; | ||
| 776 | my $self = $notebook->get_toplevel; | ||
| 777 | my $pagenum = $notebook->get_current_page; | ||
| 778 | my $pagewidget = $notebook->get_nth_page ($pagenum); | ||
| 779 | |||
| 780 | $self->set_response_sensitive (RESPONSE_APPLY, $pagewidget->{'datasheet'}); | ||
| 781 | $self->set_response_sensitive (RESPONSE_UNDO, $pagewidget->{'datasheet'}); | ||
| 782 | $self->set_response_sensitive (RESPONSE_DELETE, $pagewidget->{'datasheet'}); | ||
| 783 | $self->set_response_sensitive (RESPONSE_INSERT, $pagewidget->{'insert_defaults'}); | ||
| 784 | |||
| 785 | _refresh_page ($self, $pagewidget); | ||
| 786 | } | ||
| 787 | |||
| 788 | sub _refresh_page { | ||
| 789 | my ($self, $pagewidget) = @_; | ||
| 790 | ### _refresh_page(): $pagewidget->{'dirty'} | ||
| 791 | ### for: $self->{'symbol'} | ||
| 792 | |||
| 793 | if ($pagewidget->{'dirty'}) { | ||
| 794 | Gtk2::Ex::WidgetCursor->busy; | ||
| 795 | $pagewidget->{'dirty'} = 0; | ||
| 796 | my $symbol = $self->{'symbol'}; | ||
| 797 | if (my $datasheet = $pagewidget->{'datasheet'}) { | ||
| 798 | ### datasheet query | ||
| 799 | $datasheet->query ({bind_values => [$symbol]}, 0); | ||
| 800 | |||
| 801 | } elsif (my $seriestreeview = $pagewidget->{'seriestreeview'}) { | ||
| 802 | my $series; | ||
| 803 | if ($symbol) { | ||
| 804 | require App::Chart::Series::Database; | ||
| 805 | $series = App::Chart::Series::Database->new ($symbol); | ||
| 806 | } | ||
| 807 | $seriestreeview->set (series => $series); | ||
| 808 | |||
| 809 | } elsif (my $rawlatest = $pagewidget->{'rawlatest'}) { | ||
| 810 | $rawlatest->set (symbol => $symbol); | ||
| 811 | |||
| 812 | } elsif (my $rawinfo = $pagewidget->{'rawinfo'}) { | ||
| 813 | $rawinfo->set (symbol => $symbol); | ||
| 814 | |||
| 815 | } elsif (my $store = $pagewidget->{'weblinks_store'}) { | ||
| 816 | require App::Chart::Weblink; | ||
| 817 | my @weblinks = App::Chart::Weblink->links_for_symbol ($symbol); | ||
| 818 | ### weblinks for: $symbol, scalar(@weblinks) | ||
| 819 | $store->clear; | ||
| 820 | foreach my $weblink (@weblinks) { | ||
| 821 | $store->set ($store->append, | ||
| 822 | 0 => mnemonic_to_markup ($weblink->name), | ||
| 823 | 1 => $weblink->url ($symbol), | ||
| 824 | 2 => __('Double click to open this URL in a browser')); | ||
| 825 | } | ||
| 826 | } else { | ||
| 827 | die 'Oops, unknown raw refresh'; | ||
| 828 | } | ||
| 829 | } | ||
| 830 | } | ||
| 831 | |||
| 832 | sub refresh { | ||
| 833 | my ($self) = @_; | ||
| 834 | ### RawDialog refresh() | ||
| 835 | my $notebook = $self->{'notebook'}; | ||
| 836 | $notebook->foreach (sub { | ||
| 837 | my ($scrolled) = @_; | ||
| 838 | $scrolled->{'dirty'} = 1; | ||
| 839 | }); | ||
| 840 | _do_notebook_page ($notebook); # redraw current page | ||
| 841 | } | ||
| 842 | |||
| 843 | # 'response' signal on ourselves | ||
| 844 | sub _do_response { | ||
| 845 | my ($self, $response) = @_; | ||
| 846 | |||
| 847 | if ($response eq RESPONSE_REFRESH) { | ||
| 848 | $self->refresh; | ||
| 849 | |||
| 850 | } elsif ($response eq RESPONSE_INSERT) { | ||
| 851 | my $notebook = $self->{'notebook'}; | ||
| 852 | my $pagenum = $notebook->get_current_page; | ||
| 853 | my $pagewidget = $notebook->get_nth_page ($pagenum); | ||
| 854 | if ((my $datasheet = $pagewidget->{'datasheet'}) | ||
| 855 | && (my $defaults_func = $pagewidget->{'insert_defaults'})) { | ||
| 856 | $datasheet->insert ($defaults_func->($self, $pagewidget)); | ||
| 857 | } | ||
| 858 | |||
| 859 | } elsif ($response eq RESPONSE_DELETE) { | ||
| 860 | my $notebook = $self->{'notebook'}; | ||
| 861 | my $pagenum = $notebook->get_current_page; | ||
| 862 | my $pagewidget = $notebook->get_nth_page ($pagenum); | ||
| 863 | if (my $datasheet = $pagewidget->{'datasheet'}) { | ||
| 864 | $datasheet->delete; | ||
| 865 | } | ||
| 866 | |||
| 867 | } elsif ($response eq RESPONSE_APPLY) { | ||
| 868 | foreach my $datasheet (@{$self->{'datasheets'}}) { | ||
| 869 | $datasheet->apply; | ||
| 870 | } | ||
| 871 | |||
| 872 | } elsif ($response eq RESPONSE_UNDO) { | ||
| 873 | my $notebook = $self->{'notebook'}; | ||
| 874 | my $pagenum = $notebook->get_current_page; | ||
| 875 | my $pagewidget = $notebook->get_nth_page ($pagenum); | ||
| 876 | if (my $datasheet = $pagewidget->{'datasheet'}) { | ||
| 877 | $datasheet->undo; | ||
| 878 | } | ||
| 879 | |||
| 880 | } elsif ($response eq 'close') { | ||
| 881 | # as per a keyboard close, defaults to raising 'delete-event', which in | ||
| 882 | # turn defaults to a destroy | ||
| 883 | $self->signal_emit ('close'); | ||
| 884 | |||
| 885 | } elsif ($response eq 'help') { | ||
| 886 | require App::Chart::Manual; | ||
| 887 | App::Chart::Manual->open(__p('manual-node','Raw Data'), $self); | ||
| 888 | } | ||
| 889 | } | ||
| 890 | |||
| 891 | # 'activate' signal on the Gtk2::Entry widget | ||
| 892 | sub _do_entry_activate { | ||
| 893 | my ($entry) = @_; | ||
| 894 | my $self = $entry->get_toplevel; | ||
| 895 | $self->set_symbol ($entry->get_text); | ||
| 896 | } | ||
| 897 | |||
| 898 | # return true if $str is a valid ISO format date like 2008-05-27 | ||
| 899 | sub validate_date { | ||
| 900 | my ($str) = @_; | ||
| 901 | return ($str =~ /^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$/); | ||
| 902 | } | ||
| 903 | |||
| 904 | # return true if $str is a valid number | ||
| 905 | sub validate_number { | ||
| 906 | my ($str) = @_; | ||
| 907 | return ($str =~ /^[0-9]*(.[0-9]*)?$/); | ||
| 908 | } | ||
| 909 | |||
| 910 | # return true if $str is a valid number | ||
| 911 | sub validate_integer { | ||
| 912 | my ($str) = @_; | ||
| 913 | return ($str =~ /^[0-9]*$/); | ||
| 914 | } | ||
| 915 | |||
| 916 | sub popup { | ||
| 917 | my ($class, $symbol, $parent) = @_; | ||
| 918 | if (! defined $symbol) { $symbol = ''; } | ||
| 919 | require App::Chart::Gtk2::Ex::ToplevelBits; | ||
| 920 | return App::Chart::Gtk2::Ex::ToplevelBits::popup | ||
| 921 | ($class, | ||
| 922 | properties => { symbol => $symbol }, | ||
| 923 | screen => $parent); | ||
| 924 | } | ||
| 925 | |||
| 926 | 1; | ||
| 927 | __END__ |