cinelerra-5.0/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                 Thread::join();
  91         }
  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, 24)
 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::next_frame(int n)
 396 {
 397         age += n * period;
 398         if( (seq_no+=n) >= clip_size ) seq_no = 0;
 399         return seq_no;
 400 }
 401
 402
 403 void DbWindowVIcon::load_frames(DbWindow::MDb *mdb)
 404 {
 405         if( !mdb->attach_rd() ) {
 406                 read_frames(mdb);
 407                 mdb->detach();
 408         }
 409 }
 410
 411 void DbWindowVIcon::read_frames(DbWindow::MDb *mdb)
 412 {
 413         while( seq_no >= images.size() ) {
 414                 int no = images.size();
 415                 if( no >= prefix_size ) no += suffix_offset;
 416                 if( mdb->get_sequences(clip_id, no) ) continue;
 417                 if( mdb->timeline_sequence_no() != no ) continue;
 418                 int frame_id = mdb->timeline_frame_id();
 419                 if( frame_id < 0 ) continue;
 420                 int swidth = (SWIDTH+1) & ~1, sheight = (SHEIGHT+1) & ~1;
 421                 VIFrame *vifrm = new VIFrame(swidth, sheight, BC_YUV420P);
 422                 VFrame *img = *vifrm;
 423                 memset(img->get_y(),0x00,swidth * sheight);
 424                 memset(img->get_u(),0x80,swidth/2 * sheight/2);
 425                 memset(img->get_v(),0x80,swidth/2 * sheight/2);
 426                 uint8_t *yp = img->get_y();  int sw = -1, sh = -1;
 427                 mdb->get_image(frame_id, yp, sw, sh);
 428                 images.append(vifrm);
 429         }
 430 }
 431
 432 int DbWindowVIcon::get_vx()
 433 {
 434         return lbox->get_item_x(item);
 435 }
 436 int DbWindowVIcon::get_vy()
 437 {
 438         return lbox->get_item_y(item);
 439 }
 440
 441 void DbWindowVIcon::
 442 update_image(DbWindowGUI *gui, int clip_id)
 443 {
 444         DbWindow::MDb *mdb = gui->dwindow->mdb;
 445         if( !mdb->attach_rd() ) {
 446                 if( !mdb->clip_id(clip_id) ) {
 447                         this->clip_id = clip_id;
 448                         this->clip_size = mdb->clip_size();;
 449                         this->prefix_size = mdb->clip_prefix_size();
 450                         this->suffix_offset = mdb->clip_frames() - clip_size;
 451                         double framerate = mdb->clip_framerate();
 452                         this->period = 1000. / (framerate > 0 ? framerate : 24);
 453                         gui->vicon_thread->add_vicon(this);
 454                 }
 455                 mdb->detach();
 456         }
 457 }
 458
 459
 460 int DbWindowList::update_images()
 461 {
 462         DbWindowVIconThread *thread = gui->vicon_thread;
 463         thread->t_heap.remove_all();
 464
 465         int i = get_first_visible();
 466         int k = sizeof_col;
 467         while( --k >= 0 && gui->search_columns[k] != col_vicon );
 468         if( k >= 0 && i >= 0 ) {
 469                 int sz = gui->search_results.size();
 470                 int last = get_last_visible();
 471                 if( last < sz ) sz = last+1;
 472                 for( int n=0; i<sz; ++i, ++n ) {
 473                         DbSearchItem *item = gui->search_items[k][i];
 474                         DbWindowVIcon *vicon = thread->get_vicon(n, item);
 475                         vicon->update_image(gui, gui->search_results[i]->id);
 476                 }
 477         }
 478         return 0;
 479 }
 480
 481 int DbWindowList::
 482 update()
 483 {
 484         BC_ListBox::update((ArrayList<BC_ListBoxItem*>*)gui->search_items,
 485                         &gui->search_column_titles[0], &gui->search_column_widths[0],
 486                         sizeof_col);
 487         return 0;
 488 }
 489
 490 int DbWindowList::
 491 selection_changed()
 492 {
 493         gui->stop_drawing();
 494         set_view_popup(0);
 495         int idx = get_selection_number(0, 0);
 496         if( idx >= 0 && get_selection_number(0, 1) < 0 ) {
 497                 DbSearchItem *item = gui->search_items[0][idx];
 498                 set_view_popup(item->vicon);
 499         }
 500         gui->start_drawing(0);
 501         return 0;
 502 }
 503
 504
 505 void DbWindowGUI::
 506 create_objects()
 507 {
 508         int pady = BC_TextBox::calculate_h(this, MEDIUMFONT, 0, 1) + 5;
 509         int padx = BC_Title::calculate_w(this, (char*)"X", MEDIUMFONT);
 510         int x = padx/2, y = pady/4;
 511         text_x = x;  text_y = y;
 512         BC_Title *title = new BC_Title(text_x, text_y, _("Text:"), MEDIUMFONT, YELLOW);
 513         add_subwindow(title);  x += title->get_w();
 514         search_text = new DbWindowText(this, x, y, get_w()-x-10);
 515         add_subwindow(search_text);
 516         x = padx;  y += pady + 5;
 517         title_text = new DbWindowTitleText(this, x, y);
 518         add_subwindow(title_text);  x += title_text->get_w() + padx;
 519         info_text = new DbWindowInfoText(this, x, y);
 520         add_subwindow(info_text);  x += title_text->get_w() + padx;
 521         match_case = new DbWindowMatchCase(this, x, y);
 522         add_subwindow(match_case); x += match_case->get_w() + padx;
 523         x = padx;  y += pady + 5;
 524         search_x = 10;
 525         search_y = get_h() - DbWindowStart::calculate_h() - 10;
 526         search_start = new DbWindowStart(this, search_x, search_y);
 527         add_subwindow(search_start);
 528         del_items_x = search_x + DbWindowStart::calculate_w(this, search_start->get_text()) + 15;
 529         del_items_y = search_y;
 530         del_items = new DbWindowDeleteItems(this, del_items_x, del_items_y);
 531         add_subwindow(del_items);
 532         cancel_w = DbWindowCancel::calculate_w();
 533         cancel_h = DbWindowCancel::calculate_h();
 534         cancel_x = get_w() - cancel_w - 10;
 535         cancel_y = get_h() - cancel_h - 10;
 536         cancel = new DbWindowCancel(this, cancel_x, cancel_y);
 537         add_subwindow(cancel);
 538         list_x = x;  list_y = y;
 539         int list_w = get_w()-10 - list_x;
 540         int list_h = min(search_y, cancel_y)-10 - list_y;
 541         search_list = new DbWindowList(this, list_x, list_y, list_w, list_h);
 542         add_subwindow(search_list);
 543         vicon_thread = new DbWindowVIconThread(this);
 544         vicon_thread->start();
 545         search_list->show_window();
 546         canvas_x = 0;
 547         canvas_y = search_list->get_title_h();
 548         canvas_w = search_list->get_w();
 549         canvas_h = search_list->get_h() - canvas_y;
 550         canvas = new DbWindowCanvas(this, canvas_x, canvas_y, canvas_w, canvas_h);
 551         canvas->use_auxwindow(search_list);
 552         canvas->create_objects(0);
 553         set_icon(dwindow->mwindow->theme->get_image("record_icon"));
 554 }
 555
 556
 557 DbWindowGUI::
 558 DbWindowGUI(DbWindow *dwindow)
 559  : BC_Window(_(PROGRAM_NAME ": DbWindow"),
 560         dwindow->mwindow->gui->get_abs_cursor_x(1) - 900 / 2,
 561         dwindow->mwindow->gui->get_abs_cursor_y(1) - 600 / 2,
 562         900, 600, 400, 400)
 563 {
 564         this->dwindow = dwindow;
 565
 566         search_start = 0;
 567         search_list = 0;
 568         cancel = 0;
 569
 570         search_x = search_y = 0;
 571         cancel_x = cancel_y = cancel_w = cancel_h = 0;
 572         del_items_x = del_items_y = 0;
 573         list_x = list_y = list_w = list_h = 0;
 574         sort_column = 1;  sort_order = 0;
 575
 576         title_text_enable = 1;
 577         info_text_enable = 1;
 578         match_case_enable = 1;
 579
 580         search_columns[col_vicon] = col_vicon;
 581         search_columns[col_id] = col_id;
 582         search_columns[col_length] = col_length;
 583         search_columns[col_source] = col_source;
 584         search_columns[col_title] = col_title;
 585         search_columns[col_start_time] = col_start_time;
 586         search_columns[col_access_time] = col_access_time;
 587         search_columns[col_access_count] = col_access_count;
 588         search_column_titles[col_vicon] = _("vicon");
 589         search_column_titles[col_id] = _("Id");
 590         search_column_titles[col_length] = _("length");
 591         search_column_titles[col_source] = _("Source");
 592         search_column_titles[col_title] = _("Title");
 593         search_column_titles[col_start_time] = _("Start time");
 594         search_column_titles[col_access_time] = _("Access time");
 595         search_column_titles[col_access_count] = _("count");
 596         search_column_widths[col_vicon] = 90;
 597         search_column_widths[col_id] = 60;
 598         search_column_widths[col_length] = 80;
 599         search_column_widths[col_source] = 50;
 600         search_column_widths[col_title] = 160;
 601         search_column_widths[col_start_time] = 140;
 602         search_column_widths[col_access_time] = 140;
 603         search_column_widths[col_access_count] = 60;
 604         int wd = 0;
 605         for( int i=0; i<sizeof_col; ++i )
 606                 if( i != col_title ) wd += search_column_widths[i];
 607         search_column_widths[col_title] = get_w() - wd - 40;
 608 }
 609
 610 DbWindowGUI::~DbWindowGUI()
 611 {
 612         for( int i=0; i<sizeof_col; ++i )
 613                 search_items[i].remove_all_objects();
 614         delete vicon_thread;
 615         delete canvas;
 616 }
 617
 618 int DbWindowGUI::
 619 resize_event(int w, int h)
 620 {
 621         stop_drawing();
 622         int cancel_x = w - BC_CancelButton::calculate_w() - 10;
 623         int cancel_y = h - BC_CancelButton::calculate_h() - 10;
 624         cancel->reposition_window(cancel_x, cancel_y);
 625         search_x = 10;
 626         search_y = h - BC_GenericButton::calculate_h() - 10;
 627         search_start->reposition_window(search_x, search_y);
 628         del_items_x = search_x + DbWindowStart::calculate_w(this, search_start->get_text()) + 15;
 629         del_items_y = search_y;
 630         del_items->reposition_window(del_items_x,del_items_y);
 631         int list_w = w-10 - list_x;
 632         int list_h = min(search_y, cancel_y)-10 - list_y;
 633         canvas_w = SWIDTH;  canvas_h = SHEIGHT;
 634         canvas_x = cancel_x - canvas_w - 15;
 635         canvas_y = get_h() - canvas_h - 10;
 636         canvas->reposition_window(0, canvas_x, canvas_y, canvas_w, canvas_h);
 637 //      int wd = 0;
 638 //      for( int i=0; i<sizeof_col; ++i )
 639 //              if( i != col_title ) wd += search_column_widths[i];
 640 //      search_column_widths[col_title] = w - wd - 40;
 641         search_list->reposition_window(list_x, list_y, list_w, list_h);
 642         start_drawing();
 643         return 1;
 644 }
 645
 646 int DbWindowGUI::
 647 close_event()
 648 {
 649         set_done(1);
 650         return 1;
 651 }
 652
 653 int DbWindowGUI::
 654 stop_drawing()
 655 {
 656         vicon_thread->stop_drawing();
 657         return 0;
 658 }
 659
 660 int DbWindowGUI::
 661 start_drawing(int update)
 662 {
 663         if( update )
 664                 vicon_thread->list_update = 1;
 665         vicon_thread->start_drawing();
 666         return 0;
 667 }
 668
 669 int DbWindowGUI::search_string(const char *text, const char *sp)
 670 {
 671         if( sp ) {
 672                 int n = strlen(text);
 673                 for( const char *cp=sp; *cp!=0; ++cp ) {
 674                         if( match_case_enable ? !strncmp(text, cp, n) :
 675                                 !strncasecmp(text, cp, n) ) return 1;
 676                 }
 677         }
 678         return 0;
 679 }
 680
 681 void DbWindowGUI::search_clips(MediaDb *mdb, int n, const char *text)
 682 {
 683         //Db::write_blocked by(mdb->db.Clip_set);
 684         if( !mdb->clips_first_id() ) do {
 685                 if( (title_text_enable && search_string(text, mdb->clip_title())) ||
 686                     (info_text_enable  && search_string(text, mdb->clip_path())) ) {
 687                         int id = mdb->clip_id();
 688                         double system_time = mdb->clip_system_time();
 689                         double start_time = 0;
 690                         if( system_time > 0 )
 691                                 start_time = system_time + mdb->clip_position();
 692                         double access_time = 0;  int access_count = 0;
 693                         if( !mdb->views_clip_id(id) ) {
 694                                  access_time = mdb->views_access_time();
 695                                  access_count =  mdb->views_access_count();
 696                         }
 697                         double length = mdb->clip_frames() / mdb->clip_framerate();
 698                         search_results.append(new DbWindowItem(id, mdb->clip_title(),
 699                                 mdb->clip_path(), length, start_time, access_time, access_count));
 700                 }
 701         } while( --n >= 0 && !mdb->clips_next_id() );
 702 }
 703
 704 void DbWindowGUI::search(int n, const char *text)
 705 {
 706         stop_drawing();
 707         search_results.remove_all();
 708         DbWindow::MDb *mdb = dwindow->mdb;
 709         if( !mdb->attach_rd() ) {
 710                 search_clips(mdb, n, text);
 711                 mdb->detach();
 712         }
 713         start_drawing();
 714 }
 715
 716 int DbWindowGUI::delete_selection(MediaDb *mdb)
 717 {
 718         int n = 0;
 719         for( int k=0; k<search_results.size(); ++k ) {
 720                 if( !search_items[0][k]->get_selected() ) continue;
 721                 int id = search_results[k]->id;
 722                 if( mdb->del_clip_set(id) ) {
 723                         printf(_("failed delete clip id %d\n"),id);
 724                         continue;
 725                 }
 726                 search_results.remove_object_number(k);
 727                 for( int i=0; i<sizeof_col; ++i )
 728                         search_items[i].remove_object_number(k);
 729                 ++n;  --k;
 730         }
 731         if( n > 0 ) mdb->commitDb();
 732         return 0;
 733 }
 734
 735 void DbWindowGUI::delete_items()
 736 {
 737         stop_drawing();
 738         DbWindow::MDb *mdb = dwindow->mdb;
 739         if( !mdb->attach_wr() ) {
 740                 delete_selection(mdb);
 741                 mdb->detach();
 742         }
 743         start_drawing();
 744 }
 745
 746 void DbWindowGUI::
 747 update()
 748 {
 749
 750         for( int i=0; i<sizeof_col; ++i )
 751                 search_items[i].remove_all_objects();
 752
 753         char text[BCTEXTLEN];
 754         int n = search_results.size();
 755         for( int i=0; i<n; ++i ) {
 756                 DbWindowItem *item = search_results[i];
 757                 for( int k=0; k<sizeof_col; ++k ) {
 758                         const char *cp = 0;  text[0] = 0;
 759                         switch( search_columns[k] ) {
 760                         case col_vicon:
 761                                 cp = "";
 762                                 break;
 763                         case col_id: {
 764                                 sprintf(text,"%4d", item->id);
 765                                 cp = text;
 766                                 break; }
 767                         case col_length: {
 768                                 sprintf(text, "%8.3f", item->length);
 769                                 cp = text;
 770                                 break; }
 771                         case col_source:
 772                                 cp = item->source;
 773                                 break;
 774                         case col_title:
 775                                 cp = item->title;
 776                                 break;
 777                         case col_start_time: {
 778                                 time_t st = item->start_time;
 779                                 if( st > 0 ) {
 780                                         struct tm stm;  localtime_r(&st,&stm);
 781                                         sprintf(text,"%02d:%02d:%02d %02d/%02d/%02d",
 782                                                 stm.tm_hour, stm.tm_min, stm.tm_sec,
 783                                                 stm.tm_year%100, stm.tm_mon, stm.tm_mday);
 784                                 }
 785                                 cp = text;
 786                                 break; }
 787                         case col_access_time: {
 788                                 time_t at = item->access_time;
 789                                 if( at > 0 ) {
 790                                         struct tm atm;  localtime_r(&at,&atm);
 791                                         sprintf(text,"%02d/%02d/%02d %02d:%02d:%02d",
 792                                                 atm.tm_year%100, atm.tm_mon, atm.tm_mday,
 793                                                 atm.tm_hour, atm.tm_min, atm.tm_sec);
 794                                 }
 795                                 cp = text;
 796                                 break; }
 797                         case col_access_count: {
 798                                 sprintf(text,"%4d", item->access_count);
 799                                 cp = text;
 800                                 break; }
 801                         }
 802                         if( !cp ) continue;
 803                         DbSearchItem *item = new DbSearchItem(cp, LTYELLOW);
 804                         if( search_columns[k] == col_vicon ) {
 805                                 item->set_text_w(SWIDTH+10);
 806                                 item->set_text_h(SHEIGHT+5);
 807                                 item->set_searchable(0);
 808                         }
 809                         search_items[k].append(item);
 810                 }
 811         }
 812
 813         search_list->update();
 814 }
 815
 816
 817 DbWindowItem::
 818 DbWindowItem(int id, const char *source, const char *title,
 819         double length, double start_time,
 820         double access_time, int access_count)
 821 {
 822         this->id = id;
 823         if( !source ) source = "";
 824         this->source = new char[strlen(source)+1];
 825         strcpy(this->source,source);
 826         if( !title ) title = "";
 827         this->title = new char[strlen(title)+1];
 828         strcpy(this->title,title);
 829         this->length = length;
 830         this->start_time = start_time;
 831         this->access_time = access_time;
 832         this->access_count = access_count;
 833 }
 834
 835 DbWindowItem::
 836 ~DbWindowItem()
 837 {
 838         delete source;
 839         delete title;
 840 }
 841
 842 #define CmprFn(nm,key) int DbWindowGUI:: \
 843 cmpr_##nm(const void *a, const void *b) { \
 844   DbWindowItem *&ap = *(DbWindowItem **)a; \
 845   DbWindowItem *&bp = *(DbWindowItem **)b; \
 846   int n = key; if( !n ) n = ap->no-bp->no; \
 847   return n; \
 848 }
 849
 850 extern long timezone;
 851
 852 CmprFn(id_dn, ap->id - bp->id)
 853 CmprFn(id_up, bp->id - ap->id)
 854 CmprFn(length_dn, ap->length - bp->length)
 855 CmprFn(length_up, bp->length - ap->length)
 856 CmprFn(Source_dn, strcasecmp(ap->source, bp->source))
 857 CmprFn(source_dn, strcmp(ap->source, bp->source))
 858 CmprFn(Source_up, strcasecmp(bp->source, ap->source))
 859 CmprFn(source_up, strcmp(bp->source, ap->source))
 860 CmprFn(Title_dn, strcasecmp(ap->title, bp->title))
 861 CmprFn(title_dn, strcmp(ap->title, bp->title))
 862 CmprFn(Title_up, strcasecmp(bp->title, ap->title))
 863 CmprFn(title_up, strcmp(bp->title, ap->title))
 864 CmprFn(start_time_dn, fmod(ap->start_time-timezone,24*3600) - fmod(bp->start_time-timezone,24*3600))
 865 CmprFn(start_time_up, fmod(bp->start_time-timezone,24*3600) - fmod(ap->start_time-timezone,24*3600))
 866 CmprFn(access_time_dn, ap->access_time - bp->access_time)
 867 CmprFn(access_time_up, bp->access_time - ap->access_time)
 868 CmprFn(access_count_dn, ap->access_count - bp->access_count)
 869 CmprFn(access_count_up, bp->access_count - ap->access_count)
 870
 871
 872 void DbWindowGUI::
 873 sort_events(int column, int order)
 874 {
 875         sort_column = column;  sort_order = order;
 876         if( search_columns[sort_column] == col_vicon ) return;
 877         int n = search_results.size();
 878         if( !n ) return;
 879         DbWindowItem **items = &search_results[0];
 880         for( int i=0; i<n; ++i ) items[i]->no = i;
 881
 882         int(*cmpr)(const void *, const void *) = 0;
 883         switch( search_columns[sort_column] ) {
 884         case col_id:
 885                 cmpr = sort_order ? cmpr_id_up : cmpr_id_dn;
 886                 break;
 887         case col_length:
 888                 cmpr = sort_order ? cmpr_length_up : cmpr_length_dn;
 889                 break;
 890         case col_source:
 891                 cmpr = match_case_enable ?
 892                         (sort_order ? cmpr_Source_up : cmpr_Source_dn) :
 893                         (sort_order ? cmpr_source_up : cmpr_source_dn) ;
 894                 break;
 895         case col_title:
 896                 cmpr = match_case_enable ?
 897                         (sort_order ? cmpr_Title_up : cmpr_Title_dn) :
 898                         (sort_order ? cmpr_title_up : cmpr_title_dn) ;
 899                 break;
 900         case col_start_time:
 901                 cmpr = sort_order ? cmpr_start_time_up : cmpr_start_time_dn;
 902                 break;
 903         case col_access_time:
 904                 cmpr = sort_order ? cmpr_access_time_up : cmpr_access_time_dn;
 905                 break;
 906         case col_access_count:
 907                 cmpr = sort_order ? cmpr_access_count_up : cmpr_access_count_dn;
 908                 break;
 909         }
 910
 911         if( cmpr ) qsort(items, n, sizeof(*items), cmpr);
 912 }
 913
 914 void DbWindowGUI::
 915 move_column(int src, int dst)
 916 {
 917         if( src == dst ) return;
 918         int src_column = search_columns[src];
 919         const char *src_column_title = search_column_titles[src];
 920         int src_column_width = search_column_widths[src];
 921         if( src < dst ) {
 922                 for( int i=src; i<dst; ++i ) {
 923                         search_columns[i] = search_columns[i+1];
 924                         search_column_titles[i] = search_column_titles[i+1];
 925                         search_column_widths[i] = search_column_widths[i+1];
 926                 }
 927         }
 928         else {
 929                 for( int i=src; i>dst; --i ) {
 930                         search_columns[i] = search_columns[i-1];
 931                         search_column_titles[i] = search_column_titles[i-1];
 932                         search_column_widths[i] = search_column_widths[i-1];
 933                 }
 934         }
 935         search_columns[dst] = src_column;
 936         search_column_titles[dst] = src_column_title;
 937         search_column_widths[dst] = src_column_width;
 938         int k = sizeof_col;
 939         while( --k >= 0 && search_columns[k] != col_vicon );
 940         if( k >= 0 ) search_list->set_master_column(k,0);
 941 }
 942
 943
 944 DbWindowCanvas::
 945 DbWindowCanvas(DbWindowGUI *gui, int x, int y, int w, int h)
 946  : Canvas(gui->dwindow->mwindow, gui, x, y, w, h, w, h, 0)
 947 {
 948         this->gui = gui;
 949         this->is_fullscreen = 0;
 950 }
 951
 952 DbWindowCanvas::
 953 ~DbWindowCanvas()
 954 {
 955 }
 956
 957 void DbWindowCanvas::
 958 flash_canvas()
 959 {
 960         BC_WindowBase* wdw = get_canvas();
 961         wdw->lock_window("DbWindowCanvas::flash_canvas");
 962         wdw->flash();
 963         wdw->unlock_window();
 964 }
 965
 966 void DbWindowCanvas::
 967 draw_frame(VFrame *frame, int x, int y, int w, int h)
 968 {
 969         BC_WindowBase* wdw = get_canvas();
 970         int min_y = gui->search_list->get_title_h();
 971         int max_y = gui->search_list->get_view_h()+min_y;
 972         min_y += 2;  max_y -= 2;
 973         int sx = 0, sy = 0, sw = frame->get_w(), sh = frame->get_h();
 974         int dy = min_y - y;
 975         if( dy > 0 ) { sy += dy;  y = min_y;   sh -= dy;  h -= dy; }
 976         dy = y+h - max_y;
 977         if( dy > 0 ) { sh -= dy;  h -= dy; }
 978         sh &= ~1;
 979         if( sh > 0 ) {
 980                 //wdw->lock_window("DbWindowCanvas::draw_frame");
 981                 wdw->draw_vframe(frame, x,y,w,(h&~1), sx,sy,sw,sh, 0);
 982                 //wdw->unlock_window();
 983         }
 984 }
 985
 986