cinelerra-5.1/cinelerra/dbwindow.C

   1
   2
   3 #include "bcmenuitem.h"
   4 #include "bctimer.h"
   5 #include "commercials.h"
   6 #include "dbwindow.h"
   7 #include "keys.h"
   8 #include "mediadb.h"
   9 #include "mwindow.h"
  10 #include "mwindowgui.h"
  11 #include "mutex.h"
  12 #include "theme.h"
  13
  14 #include <string.h>
  15 #include <strings.h>
  16
  17 static inline int min(int a,int b) { return a<b ? a : b; }
  18 static inline int max(int a,int b) { return a>b ? a : b; }
  19
  20 #define MAX_SEARCH 100
  21
  22 DbSearchItem::DbSearchItem(const char *text, int color)
  23  : BC_ListBoxItem(text, color)
  24 {
  25         vicon = 0;
  26 }
  27
  28 DbSearchItem::~DbSearchItem()
  29 {
  30 }
  31
  32 DbWindow::
  33 DbWindow(MWindow *mwindow)
  34  : Thread(1, 0, 0)
  35 {
  36         this->mwindow = mwindow;
  37         window_lock = new Mutex("DbWindow::window_lock");
  38         db_lock = new Mutex("DbWindow::db_lock");
  39         mdb = new MDb(this);
  40         gui = 0;
  41 }
  42
  43 DbWindow::MDb::MDb(DbWindow *d)
  44  : Garbage("DbWindow::MDb"), dwin(d)
  45 {
  46         if( !d->mwindow->has_commercials() ) return;
  47          openDb();  detachDb();
  48 }
  49
  50 DbWindow::MDb::~MDb()
  51 {
  52         closeDb();
  53 }
  54
  55 DbWindow::~DbWindow()
  56 {
  57         stop();
  58         delete gui;
  59         mdb->remove_user();
  60         delete window_lock;
  61         delete db_lock;
  62 }
  63
  64 void DbWindow::
  65 start()
  66 {
  67         window_lock->lock("DbWindow::start1");
  68         if( Thread::running() ) {
  69                 gui->lock_window("DbWindow::start2");
  70                 gui->raise_window();
  71                 gui->unlock_window();
  72         }
  73         else {
  74                 delete gui;
  75                 gui = new DbWindowGUI(this);
  76                 Thread::start();
  77         }
  78         window_lock->unlock();
  79 }
  80
  81
  82 void DbWindow::
  83 stop()
  84 {
  85         if( Thread::running() ) {
  86                 window_lock->lock("DbWindow::stop");
  87                 if( gui ) gui->set_done(1);
  88                 window_lock->unlock();
  89                 Thread::cancel();
  90         }
  91         Thread::join();
  92 }
  93
  94 void DbWindow::
  95 run()
  96 {
  97         gui->lock_window("DbWindow::run");
  98         gui->create_objects();
  99         gui->search(MAX_SEARCH,"");
 100         gui->start_drawing(0);
 101         gui->unlock_window();
 102         gui->run_window();
 103         window_lock->lock("DbWindow::stop");
 104         delete gui;  gui = 0;
 105         window_lock->unlock();
 106 }
 107
 108
 109 DbWindowTitleText::
 110 DbWindowTitleText(DbWindowGUI *gui, int x, int y)
 111  : BC_CheckBox(x, y, &gui->title_text_enable, _("titles"))
 112 {
 113         this->gui = gui;
 114 }
 115
 116 DbWindowTitleText::~DbWindowTitleText()
 117 {
 118 }
 119
 120 int DbWindowTitleText::
 121 handle_event()
 122 {
 123         gui->title_text_enable = get_value();
 124         if( !gui->title_text_enable ) gui->info_text->update(1);
 125         return 1;
 126 }
 127
 128
 129 DbWindowInfoText::
 130 DbWindowInfoText(DbWindowGUI *gui, int x, int y)
 131  : BC_CheckBox(x, y, &gui->info_text_enable, _("info"))
 132 {
 133         this->gui = gui;
 134 }
 135
 136 DbWindowInfoText::~DbWindowInfoText()
 137 {
 138 }
 139
 140 int DbWindowInfoText::
 141 handle_event()
 142 {
 143         gui->info_text_enable = get_value();
 144         if( !gui->info_text_enable ) gui->title_text->update(1);
 145         return 1;
 146 }
 147
 148
 149 DbWindowMatchCase::
 150 DbWindowMatchCase(DbWindowGUI *gui, int x, int y)
 151  : BC_CheckBox(x, y, &gui->match_case_enable, _("match case"))
 152 {
 153         this->gui = gui;
 154 }
 155
 156 DbWindowMatchCase::~DbWindowMatchCase()
 157 {
 158 }
 159
 160 int DbWindowMatchCase::
 161 handle_event()
 162 {
 163         gui->match_case_enable = get_value();
 164         return 1;
 165 }
 166
 167
 168 DbWindowText::
 169 DbWindowText(DbWindowGUI *gui, int x, int y, int w)
 170  : BC_TextBox(x, y, w, 1, "")
 171 {
 172         this->gui = gui;
 173 }
 174
 175 DbWindowText::~DbWindowText()
 176 {
 177 }
 178
 179
 180 int DbWindowText::
 181 handle_event()
 182 {
 183         return 1;
 184 }
 185
 186 int DbWindowText::
 187 keypress_event()
 188 {
 189         switch(get_keypress())
 190         {
 191         case RETURN:
 192                 gui->search(MAX_SEARCH, get_text());
 193                 return 1;
 194         }
 195
 196         return BC_TextBox::keypress_event();
 197 }
 198
 199
 200 DbWindowScan::
 201 DbWindowScan(MWindow *mwindow)
 202  : BC_MenuItem(_("Media DB..."), _("Shift-M"), 'M')
 203 {
 204         set_shift();
 205         this->mwindow = mwindow;
 206 }
 207
 208 DbWindowScan::~DbWindowScan()
 209 {
 210 }
 211
 212 int DbWindowScan::
 213 handle_event()
 214 {
 215         mwindow->commit_commercial();
 216         mwindow->gui->db_window->start();
 217         return 1;
 218 }
 219
 220 DbWindowStart::
 221 DbWindowStart(DbWindowGUI *gui, int x, int y)
 222  : BC_GenericButton(x, y, _("Search"))
 223 {
 224         this->gui = gui;
 225 }
 226
 227 DbWindowStart::~DbWindowStart()
 228 {
 229 }
 230
 231 int DbWindowStart::
 232 handle_event()
 233 {
 234         gui->search(MAX_SEARCH,"");
 235         return 1;
 236 }
 237
 238 DbWindowDeleteItems::
 239 DbWindowDeleteItems(DbWindowGUI *gui, int x, int y)
 240  : BC_GenericButton(x, y, _("Delete"))
 241 {
 242         this->gui = gui;
 243 }
 244
 245 DbWindowDeleteItems::~DbWindowDeleteItems()
 246 {
 247 }
 248
 249 int DbWindowDeleteItems::
 250 handle_event()
 251 {
 252         gui->search_list->set_view_popup(0);
 253         gui->delete_items();
 254         return 1;
 255 }
 256
 257
 258 DbWindowCancel::
 259 DbWindowCancel(DbWindowGUI *gui, int x, int y)
 260  : BC_CancelButton(x, y)
 261 {
 262         this->gui = gui;
 263 }
 264
 265 DbWindowCancel::~DbWindowCancel()
 266 {
 267 }
 268
 269 int DbWindowCancel::
 270 handle_event()
 271 {
 272         gui->set_done(1);
 273         return 1;
 274 }
 275
 276
 277 DbWindowList::
 278 DbWindowList(DbWindowGUI *gui, int x, int y, int w, int h)
 279  : BC_ListBox(x, y, w, h, LISTBOX_TEXT,
 280         (ArrayList<BC_ListBoxItem*> *) &gui->search_items[0],
 281         &gui->search_column_titles[0], &gui->search_column_widths[0],
 282         sizeof_col, 0, 0, LISTBOX_MULTIPLE)
 283 {
 284         this->gui = gui;
 285         set_sort_column(gui->sort_column);
 286         set_sort_order(gui->sort_order);
 287         set_allow_drag_column(1);
 288 }
 289
 290 DbWindowList::~DbWindowList()
 291 {
 292 }
 293
 294 int DbWindowList::
 295 handle_event()
 296 {
 297         return 1;
 298 }
 299
 300 void DbWindowList::
 301 set_view_popup(DbWindowVIcon *vicon)
 302 {
 303         gui->vicon_thread->set_view_popup(vicon);
 304 }
 305
 306 int DbWindowList::
 307 keypress_event()
 308 {
 309         switch(get_keypress()) {
 310         case ESC:
 311                 set_view_popup(0);
 312                 break;
 313         case DELETE:
 314                 gui->del_items->handle_event();
 315                 break;
 316         default:
 317                 return 0;
 318         }
 319         return 1;
 320 }
 321
 322 int DbWindowList::
 323 sort_order_event()
 324 {
 325         gui->stop_drawing();
 326         gui->sort_events(get_sort_column(), get_sort_order());
 327         gui->start_drawing();
 328         return 1;
 329 }
 330
 331 int DbWindowList::
 332 move_column_event()
 333 {
 334         gui->stop_drawing();
 335         gui->move_column(get_from_column(), get_to_column());
 336         gui->start_drawing();
 337         return 1;
 338 }
 339
 340 DbWindowVIcon::DbWindowVIcon()
 341  : VIcon(SWIDTH, SHEIGHT, VICON_RATE)
 342 {
 343         lbox = 0;
 344         item = 0;
 345 }
 346
 347 DbWindowVIcon::~DbWindowVIcon()
 348 {
 349 }
 350
 351 DbWindowVIconThread::
 352 DbWindowVIconThread(DbWindowGUI *gui)
 353  : VIconThread(gui->search_list, 4*SWIDTH, 4*SHEIGHT)
 354 {
 355         this->gui = gui;
 356         list_update = 0;
 357 }
 358
 359 DbWindowVIconThread::
 360 ~DbWindowVIconThread()
 361 {
 362         t_heap.remove_all();
 363         vicons.remove_all_objects();
 364 }
 365
 366 DbWindowVIcon *DbWindowVIconThread::get_vicon(int i, DbSearchItem *item)
 367 {
 368         while( i >= vicons.size() ) {
 369                 DbWindowVIcon *vicon = new DbWindowVIcon();
 370                 vicons.append(vicon);
 371         }
 372         DbWindowVIcon *vicon = vicons[i];
 373         vicon->lbox = gui->search_list;
 374         vicon->item = item;
 375         item->vicon = vicon;
 376         return vicon;
 377 }
 378
 379 void DbWindowVIconThread::drawing_started()
 380 {
 381         if( !list_update ) return;
 382         list_update = 0;
 383         gui->update();
 384         gui->search_list->update_images();
 385         reset_images();
 386 }
 387
 388 VFrame *DbWindowVIcon::frame()
 389 {
 390         if( seq_no >= images.size() )
 391                 load_frames(lbox->gui->dwindow->mdb);
 392         return *images[seq_no];
 393 }
 394
 395 int64_t DbWindowVIcon::set_seq_no(int64_t no)
 396 {
 397         if( no >= clip_size ) no = 0;
 398         return seq_no = no;
 399 }
 400
 401
 402 void DbWindowVIcon::load_frames(DbWindow::MDb *mdb)
 403 {
 404         if( !mdb->attach_rd() ) {
 405                 read_frames(mdb);
 406                 mdb->detach();
 407         }
 408 }
 409
 410 void DbWindowVIcon::read_frames(DbWindow::MDb *mdb)
 411 {
 412         while( seq_no >= images.size() ) {
 413                 int no = images.size();
 414                 if( no >= prefix_size ) no += suffix_offset;
 415                 if( mdb->get_sequences(clip_id, no) ) continue;
 416                 if( mdb->timeline_sequence_no() != no ) continue;
 417                 int frame_id = mdb->timeline_frame_id();
 418                 if( frame_id < 0 ) continue;
 419                 int swidth = (SWIDTH+1) & ~1, sheight = (SHEIGHT+1) & ~1;
 420                 VIFrame *vifrm = new VIFrame(swidth, sheight, BC_YUV420P);
 421                 VFrame *img = *vifrm;
 422                 memset(img->get_y(),0x00,swidth * sheight);
 423                 memset(img->get_u(),0x80,swidth/2 * sheight/2);
 424                 memset(img->get_v(),0x80,swidth/2 * sheight/2);
 425                 uint8_t *yp = img->get_y();  int sw = -1, sh = -1;
 426                 mdb->get_image(frame_id, yp, sw, sh);
 427                 images.append(vifrm);
 428         }
 429 }
 430
 431 int DbWindowVIcon::get_vx()
 432 {
 433         return lbox->get_item_x(item);
 434 }
 435 int DbWindowVIcon::get_vy()
 436 {
 437         return lbox->get_item_y(item);
 438 }
 439
 440 void DbWindowVIcon::
 441 update_image(DbWindowGUI *gui, int clip_id)
 442 {
 443         DbWindow::MDb *mdb = gui->dwindow->mdb;
 444         if( !mdb->attach_rd() ) {
 445                 if( !mdb->clip_id(clip_id) ) {
 446                         this->clip_id = clip_id;
 447                         this->clip_size = mdb->clip_size();;
 448                         this->prefix_size = mdb->clip_prefix_size();
 449                         this->suffix_offset = mdb->clip_frames() - clip_size;
 450                         double framerate = mdb->clip_framerate();
 451                         this->frame_rate = framerate > 0 ? framerate : VICON_RATE;
 452                         gui->vicon_thread->add_vicon(this);
 453                 }
 454                 mdb->detach();
 455         }
 456 }
 457
 458
 459 int DbWindowList::update_images()
 460 {
 461         DbWindowVIconThread *thread = gui->vicon_thread;
 462         thread->t_heap.remove_all();
 463
 464         int i = get_first_visible();
 465         int k = sizeof_col;
 466         while( --k >= 0 && gui->search_columns[k] != col_vicon );
 467         if( k >= 0 && i >= 0 ) {
 468                 int sz = gui->search_results.size();
 469                 int last = get_last_visible();
 470                 if( last < sz ) sz = last+1;
 471                 for( int n=0; i<sz; ++i, ++n ) {
 472                         DbSearchItem *item = gui->search_items[k][i];
 473                         DbWindowVIcon *vicon = thread->get_vicon(n, item);
 474                         vicon->update_image(gui, gui->search_results[i]->id);
 475                 }
 476         }
 477         return 0;
 478 }
 479
 480 int DbWindowList::
 481 update()
 482 {
 483         BC_ListBox::update((ArrayList<BC_ListBoxItem*>*)gui->search_items,
 484                         &gui->search_column_titles[0], &gui->search_column_widths[0],
 485                         sizeof_col);
 486         return 0;
 487 }
 488
 489 int DbWindowList::
 490 selection_changed()
 491 {
 492         gui->stop_drawing();
 493         set_view_popup(0);
 494         int idx = get_selection_number(0, 0);
 495         if( idx >= 0 && get_selection_number(0, 1) < 0 ) {
 496                 DbSearchItem *item = gui->search_items[0][idx];
 497                 set_view_popup(item->vicon);
 498         }
 499         gui->start_drawing(0);
 500         return 0;
 501 }
 502
 503
 504 void DbWindowGUI::
 505 create_objects()
 506 {
 507         int pady = BC_TextBox::calculate_h(this, MEDIUMFONT, 0, 1) + 5;
 508         int padx = BC_Title::calculate_w(this, (char*)"X", MEDIUMFONT);
 509         int x = padx/2, y = pady/4;
 510         text_x = x;  text_y = y;
 511         BC_Title *title = new BC_Title(text_x, text_y, _("Text:"), MEDIUMFONT, YELLOW);
 512         add_subwindow(title);  x += title->get_w();
 513         search_text = new DbWindowText(this, x, y, get_w()-x-10);
 514         add_subwindow(search_text);
 515         x = padx;  y += pady + 5;
 516         title_text = new DbWindowTitleText(this, x, y);
 517         add_subwindow(title_text);  x += title_text->get_w() + padx;
 518         info_text = new DbWindowInfoText(this, x, y);
 519         add_subwindow(info_text);  x += title_text->get_w() + padx;
 520         match_case = new DbWindowMatchCase(this, x, y);
 521         add_subwindow(match_case); x += match_case->get_w() + padx;
 522         x = padx;  y += pady + 5;
 523         search_x = 10;
 524         search_y = get_h() - DbWindowStart::calculate_h() - 10;
 525         search_start = new DbWindowStart(this, search_x, search_y);
 526         add_subwindow(search_start);
 527         del_items_x = search_x + DbWindowStart::calculate_w(this, search_start->get_text()) + 15;
 528         del_items_y = search_y;
 529         del_items = new DbWindowDeleteItems(this, del_items_x, del_items_y);
 530         add_subwindow(del_items);
 531         cancel_w = DbWindowCancel::calculate_w();
 532         cancel_h = DbWindowCancel::calculate_h();
 533         cancel_x = get_w() - cancel_w - 10;
 534         cancel_y = get_h() - cancel_h - 10;
 535         cancel = new DbWindowCancel(this, cancel_x, cancel_y);
 536         add_subwindow(cancel);
 537         list_x = x;  list_y = y;
 538         int list_w = get_w()-10 - list_x;
 539         int list_h = min(search_y, cancel_y)-10 - list_y;
 540         search_list = new DbWindowList(this, list_x, list_y, list_w, list_h);
 541         add_subwindow(search_list);
 542         vicon_thread = new DbWindowVIconThread(this);
 543         vicon_thread->start();
 544         search_list->show_window();
 545         canvas_x = 0;
 546         canvas_y = search_list->get_title_h();
 547         canvas_w = search_list->get_w();
 548         canvas_h = search_list->get_h() - canvas_y;
 549         canvas = new DbWindowCanvas(this, canvas_x, canvas_y, canvas_w, canvas_h);
 550         canvas->use_auxwindow(search_list);
 551         canvas->create_objects(0);
 552         set_icon(dwindow->mwindow->theme->get_image("record_icon"));
 553 }
 554
 555
 556 DbWindowGUI::
 557 DbWindowGUI(DbWindow *dwindow)
 558  : BC_Window(_(PROGRAM_NAME ": DbWindow"),
 559         dwindow->mwindow->gui->get_abs_cursor_x(1) - 900 / 2,
 560         dwindow->mwindow->gui->get_abs_cursor_y(1) - 600 / 2,
 561         900, 600, 400, 400)
 562 {
 563         this->dwindow = dwindow;
 564
 565         search_start = 0;
 566         search_list = 0;
 567         cancel = 0;
 568
 569         search_x = search_y = 0;
 570         cancel_x = cancel_y = cancel_w = cancel_h = 0;
 571         del_items_x = del_items_y = 0;
 572         list_x = list_y = list_w = list_h = 0;
 573         sort_column = 1;  sort_order = 0;
 574
 575         title_text_enable = 1;
 576         info_text_enable = 1;
 577         match_case_enable = 1;
 578
 579         search_columns[col_vicon] = col_vicon;
 580         search_columns[col_id] = col_id;
 581         search_columns[col_length] = col_length;
 582         search_columns[col_source] = col_source;
 583         search_columns[col_title] = col_title;
 584         search_columns[col_start_time] = col_start_time;
 585         search_columns[col_access_time] = col_access_time;
 586         search_columns[col_access_count] = col_access_count;
 587         search_column_titles[col_vicon] = _("vicon");
 588         search_column_titles[col_id] = _("Id");
 589         search_column_titles[col_length] = _("length");
 590         search_column_titles[col_source] = _("Source");
 591         search_column_titles[col_title] = C_("Title");
 592         search_column_titles[col_start_time] = _("Start time");
 593         search_column_titles[col_access_time] = _("Access time");
 594         search_column_titles[col_access_count] = _("count");
 595         search_column_widths[col_vicon] = 90;
 596         search_column_widths[col_id] = 60;
 597         search_column_widths[col_length] = 80;
 598         search_column_widths[col_source] = 50;
 599         search_column_widths[col_title] = 160;
 600         search_column_widths[col_start_time] = 140;
 601         search_column_widths[col_access_time] = 140;
 602         search_column_widths[col_access_count] = 60;
 603         int wd = 0;
 604         for( int i=0; i<sizeof_col; ++i )
 605                 if( i != col_title ) wd += search_column_widths[i];
 606         search_column_widths[col_title] = get_w() - wd - 40;
 607 }
 608
 609 DbWindowGUI::~DbWindowGUI()
 610 {
 611         for( int i=0; i<sizeof_col; ++i )
 612                 search_items[i].remove_all_objects();
 613         delete vicon_thread;
 614         delete canvas;
 615 }
 616
 617 int DbWindowGUI::
 618 resize_event(int w, int h)
 619 {
 620         stop_drawing();
 621         int cancel_x = w - BC_CancelButton::calculate_w() - 10;
 622         int cancel_y = h - BC_CancelButton::calculate_h() - 10;
 623         cancel->reposition_window(cancel_x, cancel_y);
 624         search_x = 10;
 625         search_y = h - BC_GenericButton::calculate_h() - 10;
 626         search_start->reposition_window(search_x, search_y);
 627         del_items_x = search_x + DbWindowStart::calculate_w(this, search_start->get_text()) + 15;
 628         del_items_y = search_y;
 629         del_items->reposition_window(del_items_x,del_items_y);
 630         int list_w = w-10 - list_x;
 631         int list_h = min(search_y, cancel_y)-10 - list_y;
 632         canvas_w = SWIDTH;  canvas_h = SHEIGHT;
 633         canvas_x = cancel_x - canvas_w - 15;
 634         canvas_y = get_h() - canvas_h - 10;
 635         canvas->reposition_window(0, canvas_x, canvas_y, canvas_w, canvas_h);
 636 //      int wd = 0;
 637 //      for( int i=0; i<sizeof_col; ++i )
 638 //              if( i != col_title ) wd += search_column_widths[i];
 639 //      search_column_widths[col_title] = w - wd - 40;
 640         search_list->reposition_window(list_x, list_y, list_w, list_h);
 641         start_drawing();
 642         return 1;
 643 }
 644
 645 int DbWindowGUI::
 646 close_event()
 647 {
 648         set_done(1);
 649         return 1;
 650 }
 651
 652 int DbWindowGUI::
 653 stop_drawing()
 654 {
 655         vicon_thread->stop_drawing();
 656         return 0;
 657 }
 658
 659 int DbWindowGUI::
 660 start_drawing(int update)
 661 {
 662         if( update )
 663                 vicon_thread->list_update = 1;
 664         vicon_thread->start_drawing();
 665         return 0;
 666 }
 667
 668 int DbWindowGUI::search_string(const char *text, const char *sp)
 669 {
 670         if( sp ) {
 671                 int n = strlen(text);
 672                 for( const char *cp=sp; *cp!=0; ++cp ) {
 673                         if( match_case_enable ? !strncmp(text, cp, n) :
 674                                 !strncasecmp(text, cp, n) ) return 1;
 675                 }
 676         }
 677         return 0;
 678 }
 679
 680 void DbWindowGUI::search_clips(MediaDb *mdb, int n, const char *text)
 681 {
 682         //Db::write_blocked by(mdb->db.Clip_set);
 683         if( !mdb->clips_first_id() ) do {
 684                 if( (title_text_enable && search_string(text, mdb->clip_title())) ||
 685                     (info_text_enable  && search_string(text, mdb->clip_path())) ) {
 686                         int id = mdb->clip_id();
 687                         double system_time = mdb->clip_system_time();
 688                         double start_time = 0;
 689                         if( system_time > 0 )
 690                                 start_time = system_time + mdb->clip_position();
 691                         double access_time = 0;  int access_count = 0;
 692                         if( !mdb->views_clip_id(id) ) {
 693                                  access_time = mdb->views_access_time();
 694                                  access_count =  mdb->views_access_count();
 695                         }
 696                         double length = mdb->clip_frames() / mdb->clip_framerate();
 697                         search_results.append(new DbWindowItem(id, mdb->clip_title(),
 698                                 mdb->clip_path(), length, start_time, access_time, access_count));
 699                 }
 700         } while( --n >= 0 && !mdb->clips_next_id() );
 701 }
 702
 703 void DbWindowGUI::search(int n, const char *text)
 704 {
 705         stop_drawing();
 706         search_results.remove_all();
 707         DbWindow::MDb *mdb = dwindow->mdb;
 708         if( !mdb->attach_rd() ) {
 709                 search_clips(mdb, n, text);
 710                 mdb->detach();
 711         }
 712         start_drawing();
 713 }
 714
 715 int DbWindowGUI::delete_selection(MediaDb *mdb)
 716 {
 717         int n = 0;
 718         for( int k=0; k<search_results.size(); ++k ) {
 719                 if( !search_items[0][k]->get_selected() ) continue;
 720                 int id = search_results[k]->id;
 721                 if( mdb->del_clip_set(id) ) {
 722                         printf(_("failed delete clip id %d\n"),id);
 723                         continue;
 724                 }
 725                 search_results.remove_object_number(k);
 726                 for( int i=0; i<sizeof_col; ++i )
 727                         search_items[i].remove_object_number(k);
 728                 ++n;  --k;
 729         }
 730         if( n > 0 ) mdb->commitDb();
 731         return 0;
 732 }
 733
 734 void DbWindowGUI::delete_items()
 735 {
 736         stop_drawing();
 737         DbWindow::MDb *mdb = dwindow->mdb;
 738         if( !mdb->attach_wr() ) {
 739                 delete_selection(mdb);
 740                 mdb->detach();
 741         }
 742         start_drawing();
 743 }
 744
 745 void DbWindowGUI::
 746 update()
 747 {
 748
 749         for( int i=0; i<sizeof_col; ++i )
 750                 search_items[i].remove_all_objects();
 751
 752         char text[BCTEXTLEN];
 753         int n = search_results.size();
 754         for( int i=0; i<n; ++i ) {
 755                 DbWindowItem *item = search_results[i];
 756                 for( int k=0; k<sizeof_col; ++k ) {
 757                         const char *cp = 0;  text[0] = 0;
 758                         switch( search_columns[k] ) {
 759                         case col_vicon:
 760                                 cp = "";
 761                                 break;
 762                         case col_id: {
 763                                 sprintf(text,"%4d", item->id);
 764                                 cp = text;
 765                                 break; }
 766                         case col_length: {
 767                                 sprintf(text, "%8.3f", item->length);
 768                                 cp = text;
 769                                 break; }
 770                         case col_source:
 771                                 cp = item->source;
 772                                 break;
 773                         case col_title:
 774                                 cp = item->title;
 775                                 break;
 776                         case col_start_time: {
 777                                 time_t st = item->start_time;
 778                                 if( st > 0 ) {
 779                                         struct tm stm;  localtime_r(&st,&stm);
 780                                         sprintf(text,"%02d:%02d:%02d %02d/%02d/%02d",
 781                                                 stm.tm_hour, stm.tm_min, stm.tm_sec,
 782                                                 stm.tm_year%100, stm.tm_mon, stm.tm_mday);
 783                                 }
 784                                 cp = text;
 785                                 break; }
 786                         case col_access_time: {
 787                                 time_t at = item->access_time;
 788                                 if( at > 0 ) {
 789                                         struct tm atm;  localtime_r(&at,&atm);
 790                                         sprintf(text,"%02d/%02d/%02d %02d:%02d:%02d",
 791                                                 atm.tm_year%100, atm.tm_mon, atm.tm_mday,
 792                                                 atm.tm_hour, atm.tm_min, atm.tm_sec);
 793                                 }
 794                                 cp = text;
 795                                 break; }
 796                         case col_access_count: {
 797                                 sprintf(text,"%4d", item->access_count);
 798                                 cp = text;
 799                                 break; }
 800                         }
 801                         if( !cp ) continue;
 802                         DbSearchItem *item = new DbSearchItem(cp, LTYELLOW);
 803                         if( search_columns[k] == col_vicon ) {
 804                                 item->set_text_w(SWIDTH+10);
 805                                 item->set_text_h(SHEIGHT+5);
 806                                 item->set_searchable(0);
 807                         }
 808                         search_items[k].append(item);
 809                 }
 810         }
 811
 812         search_list->update();
 813 }
 814
 815
 816 DbWindowItem::
 817 DbWindowItem(int id, const char *source, const char *title,
 818         double length, double start_time,
 819         double access_time, int access_count)
 820 {
 821         this->id = id;
 822         if( !source ) source = "";
 823         this->source = new char[strlen(source)+1];
 824         strcpy(this->source,source);
 825         if( !title ) title = "";
 826         this->title = new char[strlen(title)+1];
 827         strcpy(this->title,title);
 828         this->length = length;
 829         this->start_time = start_time;
 830         this->access_time = access_time;
 831         this->access_count = access_count;
 832 }
 833
 834 DbWindowItem::
 835 ~DbWindowItem()
 836 {
 837         delete source;
 838         delete title;
 839 }
 840
 841 #define CmprFn(nm,key) int DbWindowGUI:: \
 842 cmpr_##nm(const void *a, const void *b) { \
 843   DbWindowItem *&ap = *(DbWindowItem **)a; \
 844   DbWindowItem *&bp = *(DbWindowItem **)b; \
 845   int n = key; if( !n ) n = ap->no-bp->no; \
 846   return n; \
 847 }
 848
 849 extern long cin_timezone;
 850
 851 CmprFn(id_dn, ap->id - bp->id)
 852 CmprFn(id_up, bp->id - ap->id)
 853 CmprFn(length_dn, ap->length - bp->length)
 854 CmprFn(length_up, bp->length - ap->length)
 855 CmprFn(Source_dn, strcasecmp(ap->source, bp->source))
 856 CmprFn(source_dn, strcmp(ap->source, bp->source))
 857 CmprFn(Source_up, strcasecmp(bp->source, ap->source))
 858 CmprFn(source_up, strcmp(bp->source, ap->source))
 859 CmprFn(Title_dn, strcasecmp(ap->title, bp->title))
 860 CmprFn(title_dn, strcmp(ap->title, bp->title))
 861 CmprFn(Title_up, strcasecmp(bp->title, ap->title))
 862 CmprFn(title_up, strcmp(bp->title, ap->title))
 863 CmprFn(start_time_dn, fmod(ap->start_time-cin_timezone,24*3600) - fmod(bp->start_time-cin_timezone,24*3600))
 864 CmprFn(start_time_up, fmod(bp->start_time-cin_timezone,24*3600) - fmod(ap->start_time-cin_timezone,24*3600))
 865 CmprFn(access_time_dn, ap->access_time - bp->access_time)
 866 CmprFn(access_time_up, bp->access_time - ap->access_time)
 867 CmprFn(access_count_dn, ap->access_count - bp->access_count)
 868 CmprFn(access_count_up, bp->access_count - ap->access_count)
 869
 870
 871 void DbWindowGUI::
 872 sort_events(int column, int order)
 873 {
 874         sort_column = column;  sort_order = order;
 875         if( search_columns[sort_column] == col_vicon ) return;
 876         int n = search_results.size();
 877         if( !n ) return;
 878         DbWindowItem **items = &search_results[0];
 879         for( int i=0; i<n; ++i ) items[i]->no = i;
 880
 881         int(*cmpr)(const void *, const void *) = 0;
 882         switch( search_columns[sort_column] ) {
 883         case col_id:
 884                 cmpr = sort_order ? cmpr_id_up : cmpr_id_dn;
 885                 break;
 886         case col_length:
 887                 cmpr = sort_order ? cmpr_length_up : cmpr_length_dn;
 888                 break;
 889         case col_source:
 890                 cmpr = match_case_enable ?
 891                         (sort_order ? cmpr_Source_up : cmpr_Source_dn) :
 892                         (sort_order ? cmpr_source_up : cmpr_source_dn) ;
 893                 break;
 894         case col_title:
 895                 cmpr = match_case_enable ?
 896                         (sort_order ? cmpr_Title_up : cmpr_Title_dn) :
 897                         (sort_order ? cmpr_title_up : cmpr_title_dn) ;
 898                 break;
 899         case col_start_time:
 900                 cmpr = sort_order ? cmpr_start_time_up : cmpr_start_time_dn;
 901                 break;
 902         case col_access_time:
 903                 cmpr = sort_order ? cmpr_access_time_up : cmpr_access_time_dn;
 904                 break;
 905         case col_access_count:
 906                 cmpr = sort_order ? cmpr_access_count_up : cmpr_access_count_dn;
 907                 break;
 908         }
 909
 910         if( cmpr ) qsort(items, n, sizeof(*items), cmpr);
 911 }
 912
 913 void DbWindowGUI::
 914 move_column(int src, int dst)
 915 {
 916         if( src == dst ) return;
 917         int src_column = search_columns[src];
 918         const char *src_column_title = search_column_titles[src];
 919         int src_column_width = search_column_widths[src];
 920         if( src < dst ) {
 921                 for( int i=src; i<dst; ++i ) {
 922                         search_columns[i] = search_columns[i+1];
 923                         search_column_titles[i] = search_column_titles[i+1];
 924                         search_column_widths[i] = search_column_widths[i+1];
 925                 }
 926         }
 927         else {
 928                 for( int i=src; i>dst; --i ) {
 929                         search_columns[i] = search_columns[i-1];
 930                         search_column_titles[i] = search_column_titles[i-1];
 931                         search_column_widths[i] = search_column_widths[i-1];
 932                 }
 933         }
 934         search_columns[dst] = src_column;
 935         search_column_titles[dst] = src_column_title;
 936         search_column_widths[dst] = src_column_width;
 937         int k = sizeof_col;
 938         while( --k >= 0 && search_columns[k] != col_vicon );
 939         if( k >= 0 ) search_list->set_master_column(k,0);
 940 }
 941
 942
 943 DbWindowCanvas::
 944 DbWindowCanvas(DbWindowGUI *gui, int x, int y, int w, int h)
 945  : Canvas(gui->dwindow->mwindow, gui, x, y, w, h, w, h, 0)
 946 {
 947         this->gui = gui;
 948         this->is_fullscreen = 0;
 949 }
 950
 951 DbWindowCanvas::
 952 ~DbWindowCanvas()
 953 {
 954 }
 955
 956 void DbWindowCanvas::
 957 flash_canvas()
 958 {
 959         BC_WindowBase* wdw = get_canvas();
 960         wdw->lock_window("DbWindowCanvas::flash_canvas");
 961         wdw->flash();
 962         wdw->unlock_window();
 963 }
 964
 965 void DbWindowCanvas::
 966 draw_frame(VFrame *frame, int x, int y, int w, int h)
 967 {
 968         BC_WindowBase* wdw = get_canvas();
 969         int min_y = gui->search_list->get_title_h();
 970         int max_y = gui->search_list->get_view_h()+min_y;
 971         min_y += 2;  max_y -= 2;
 972         int sx = 0, sy = 0, sw = frame->get_w(), sh = frame->get_h();
 973         int dy = min_y - y;
 974         if( dy > 0 ) { sy += dy;  y = min_y;   sh -= dy;  h -= dy; }
 975         dy = y+h - max_y;
 976         if( dy > 0 ) { sh -= dy;  h -= dy; }
 977         sh &= ~1;
 978         if( sh > 0 ) {
 979                 //wdw->lock_window("DbWindowCanvas::draw_frame");
 980                 wdw->draw_vframe(frame, x,y,w,(h&~1), sx,sy,sw,sh, 0);
 981                 //wdw->unlock_window();
 982         }
 983 }
 984
 985