offline.js

   1 var SCHEMA_VERSION = 2;
   2
   3 var offline_mode = false;
   4 var store = false;
   5 var localServer = false;
   6 var db = false;
   7
   8 function view_offline(id, feed_id) {
   9         try {
  10
  11                 enableHotkeys();
  12                 showArticleInHeadlines(id);
  13
  14                 db.execute("UPDATE articles SET unread = 0 WHERE id = ?", [id]);
  15
  16                 var rs = db.execute("SELECT * FROM articles WHERE id = ?", [id]);
  17
  18                 if (rs.isValidRow()) {
  19
  20                         var tmp = "<div class=\"postReply\">";
  21
  22                         tmp += "<div class=\"postHeader\" onmouseover=\"enable_resize(true)\" "+
  23                                 "onmouseout=\"enable_resize(false)\">";
  24
  25                         tmp += "<div class=\"postDate\">"+rs.fieldByName("updated")+"</div>";
  26
  27                         if (rs.fieldByName("link") != "") {
  28                                 tmp += "<div clear='both'><a target=\"_blank\" "+
  29                                         "href=\"" + rs.fieldByName("link") + "\">" +
  30                                         rs.fieldByName("title") + "</a></div>";
  31                         } else {
  32                                 tmp += "<div clear='both'>" + rs.fieldByName("title") + "</div>";
  33                         }
  34
  35                         tmp += "<div style='float : right'> "+
  36                                 "<img src='images/tag.png' class='tagsPic' alt='Tags' title='Tags'>";
  37                         tmp += rs.fieldByName("tags");
  38                         tmp += "</div>";
  39
  40                         tmp += "<div clear='both'>fixme-comments</div>";
  41
  42                         tmp += "</div>";
  43
  44                         tmp += "<div class=\"postContent\">"
  45                         tmp += rs.fieldByName("content");
  46                         tmp += "</div>";
  47
  48                         tmp += "</div>";
  49
  50                         render_article(tmp);
  51                         update_local_feedlist_counters();
  52                 }
  53
  54                 return false;
  55
  56         } catch (e) {
  57                 exception_error("view_offline", e);
  58         }
  59 }
  60
  61 function viewfeed_offline(feed_id, subop, is_cat, subop_param, skip_history, offset) {
  62         try {
  63                 notify('');
  64
  65                 if (!offset) offset = 0;
  66
  67                 loading_set_progress(100);
  68
  69                 clean_feed_selections();
  70
  71                 setActiveFeedId(feed_id, is_cat);
  72
  73                 if (!is_cat) {
  74                         var feedr = document.getElementById("FEEDR-" + feed_id);
  75                         if (feedr && !feedr.className.match("Selected")) {
  76                                 feedr.className = feedr.className + "Selected";
  77                         }
  78                 } else {
  79                         var feedr = document.getElementById("FCAT-" + feed_id);
  80                         if (feedr && !feedr.className.match("Selected")) {
  81                                 feedr.className = feedr.className + "Selected";
  82                         }
  83                 }
  84
  85                 disableContainerChildren("headlinesToolbar", false);
  86                 Form.enable("main_toolbar_form");
  87
  88                 var f = document.getElementById("headlines-frame");
  89                 try {
  90                         if (reply.offset == 0) {
  91                                 debug("resetting headlines scrollTop");
  92                                 f.scrollTop = 0;
  93                         }
  94                 } catch (e) { };
  95
  96
  97                 var container = document.getElementById("headlines-frame");
  98
  99                 var tmp = "";
 100
 101                 rs = db.execute("SELECT title FROM feeds WHERE id = ?", [feed_id]);
 102
 103                 if (rs.isValidRow() || feed_id == -1 || feed_id == -4) {
 104
 105                         feed_title = rs.field(0);
 106
 107                         if (feed_id == -1) {
 108                                 feed_title = __("Starred articles");
 109                         }
 110
 111                         if (feed_id == -4) {
 112                                 feed_title = __("All articles");
 113                         }
 114
 115                         if (offset == 0) {
 116                                 tmp += "<div id=\"headlinesContainer\">";
 117
 118                                 tmp += "<div class=\"headlinesSubToolbar\">";
 119                                 tmp += "<div id=\"subtoolbar_ftitle\">";
 120                                 tmp += feed_title;
 121                                 tmp += "</div>";
 122
 123                                 var sel_all_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', true, '', true)";
 124                                 var sel_unread_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', true, 'Unread', true)";
 125                                 var sel_none_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', false)";
 126                                 var sel_inv_link = "javascript:invertHeadlineSelection()";
 127
 128                                 tmp += __('Select:')+
 129                                         " <a href=\""+sel_all_link+"\">"+__('All')+"</a>, "+
 130                                         "<a href=\""+sel_unread_link+"\">"+__('Unread')+"</a>, "+
 131                                         "<a href=\""+sel_inv_link+"\">"+__('Invert')+"</a>, "+
 132                                         "<a href=\""+sel_none_link+"\">"+__('None')+"</a>";
 133
 134                                 tmp += "&nbsp;&nbsp;";
 135
 136                                 tmp += "</div>";
 137
 138                                 tmp += "<div id=\"headlinesInnerContainer\" onscroll=\"headlines_scroll_handler()\">";
 139
 140                                 tmp += "<table class=\"headlinesList\" id=\"headlinesList\" cellspacing=\"0\">";
 141
 142                         }
 143
 144                         var rs;
 145
 146                         var limit = 30;
 147
 148                         var toolbar_form = document.forms["main_toolbar_form"];
 149
 150                         var limit = toolbar_form.limit[toolbar_form.limit.selectedIndex].value;
 151                         var view_mode = toolbar_form.view_mode[toolbar_form.view_mode.selectedIndex].value;
 152
 153                         var limit_qpart = "";
 154                         var strategy_qpart = "";
 155                         var mode_qpart = "";
 156
 157                         if (limit != 0) {
 158                                 limit_qpart = "LIMIT " + limit;
 159                         }
 160
 161                         if (view_mode == "all_articles") {
 162                                 mode_qpart = "1";
 163                         } else if (view_mode == "adaptive") {
 164                                 if (get_local_feed_unread(feed_id) > 0) {
 165                                         mode_qpart = "unread = 1";
 166                                 } else {
 167                                         mode_qpart = "1";
 168                                 }
 169                         } else if (view_mode == "marked") {
 170                                 mode_qpart = "marked = 1";
 171                         } else if (view_mode == "unread") {
 172                                 mode_qpart = "unread = 1";
 173                         } else {
 174                                 mode_qpart = "1";
 175                         }
 176
 177                         if (feed_id > 0) {
 178                                 strategy_qpart = "feed_id = " + feed_id;
 179                         } else if (feed_id == -1) {
 180                                 strategy_qpart = "marked = 1";
 181                         } else if (feed_id == -4) {
 182                                 strategy_qpart = "1";
 183                         }
 184
 185                         var query = "SELECT * FROM articles WHERE " +
 186                                 strategy_qpart +
 187                                 " AND " + mode_qpart +
 188                                 " ORDER BY updated DESC "+
 189                                 limit_qpart;
 190
 191                         var rs = db.execute(query);
 192
 193                         var line_num = 0;
 194
 195                         while (rs.isValidRow()) {
 196
 197                                 var id = rs.fieldByName("id");
 198                                 var feed_id = rs.fieldByName("feed_id");
 199
 200                                 var marked_pic;
 201
 202                                 var row_class = (line_num % 2) ? "even" : "odd";
 203
 204                                 if (rs.fieldByName("unread") == "1") {
 205                                         row_class += "Unread";
 206                                 }
 207
 208                                 if (rs.fieldByName("marked") == "1") {
 209                                         marked_pic = "<img id=\"FMPIC-"+id+"\" "+
 210                                                 "src=\"images/mark_set.png\" class=\"markedPic\""+
 211                                                 "alt=\"Unstar article\" onclick='javascript:tMark("+id+")'>";
 212                                 } else {
 213                                         marked_pic = "<img id=\"FMPIC-"+id+"\" "+
 214                                                 "src=\"images/mark_unset.png\" class=\"markedPic\""+
 215                                                 "alt=\"Star article\" onclick='javascript:tMark("+id+")'>";
 216                                 }
 217
 218                                 var mouseover_attrs = "onmouseover='postMouseIn($id)' "+
 219                                         "onmouseout='postMouseOut($id)'";
 220
 221                                 tmp += "<tr class='"+row_class+"' id='RROW-"+id+"' "+mouseover_attrs+">";
 222
 223                                 tmp += "<td class='hlUpdPic'> </td>";
 224
 225                                 tmp += "<td class='hlSelectRow'>"+
 226                                         "<input type=\"checkbox\" onclick=\"tSR(this)\" id=\"RCHK-"+id+"\"></td>";
 227
 228                                 tmp += "<td class='hlMarkedPic'>"+marked_pic+"</td>";
 229
 230                                 tmp += "<td onclick='view("+id+","+feed_id+")' "+
 231                                         "class='hlContent' valign='middle'>";
 232
 233                                 tmp += "<a target=\"_blank\" id=\"RTITLE-$id\" href=\"" +
 234                                         rs.fieldByName("link") + "\"" +
 235                                         "onclick=\"return view("+id+","+feed_id+");\">"+
 236                                         rs.fieldByName("title");
 237
 238                                 var content_preview = truncate_string(strip_tags(rs.fieldByName("content")),
 239                                         100);
 240
 241                                 tmp += "<span class=\"contentPreview\"> - "+content_preview+"</span>";
 242
 243                                 tmp += "</a>";
 244
 245                                 tmp += "</td>";
 246
 247                                 tmp += "<td class=\"hlUpdated\" onclick='view("+id+","+feed_id+")'>"+
 248                                         "<nobr>"+rs.fieldByName("updated").substring(0,16)+"</nobr></td>";
 249
 250                                 tmp += "</tr>";
 251
 252                                 rs.next();
 253                                 line_num++;
 254                         }
 255
 256                         if (offset == 0) {
 257                                 tmp += "</table>";
 258                                 tmp += "</div></div>";
 259                         }
 260
 261                         if (offset == 0) {
 262                                 container.innerHTML = tmp;
 263                         } else {
 264                                 var ids = getSelectedArticleIds2();
 265
 266                                 //container.innerHTML = container.innerHTML + tmp;
 267
 268                                 for (var i = 0; i < ids.length; i++) {
 269                                         markHeadline(ids[i]);
 270                                 }
 271                         }
 272                 }
 273
 274                 remove_splash();
 275
 276
 277         } catch (e) {
 278                 exception_error("viewfeed_offline", e);
 279         }
 280 }
 281
 282 function render_offline_feedlist() {
 283         try {
 284                 var tmp = "<ul class=\"feedList\" id=\"feedList\">";
 285
 286                 var unread = get_local_feed_unread(-4);
 287
 288                 global_unread = unread;
 289                 updateTitle();
 290
 291                 tmp += printFeedEntry(-4, __("All articles"), "feed", unread,
 292                         "images/tag.png");
 293
 294                 var unread = get_local_feed_unread(-1);
 295
 296                 tmp += printFeedEntry(-1, __("Starred articles"), "feed", unread,
 297                         "images/mark_set.png");
 298
 299                 tmp += "<li><hr/></li>";
 300
 301                 var rs = db.execute("SELECT feeds.id,feeds.title,has_icon,COUNT(articles.id) "+
 302                         "FROM feeds LEFT JOIN articles ON (feed_id = feeds.id) "+
 303                         "WHERE unread = 1 OR unread IS NULL GROUP BY feeds.id "+
 304                         "ORDER BY feeds.title");
 305
 306                 while (rs.isValidRow()) {
 307
 308                         var id = rs.field(0);
 309                         var title = rs.field(1);
 310                         var has_icon = rs.field(2);
 311                         var unread = rs.field(3);
 312
 313                         var icon = "";
 314
 315                         if (has_icon) {
 316                                 icon = "icons/" + id + ".ico";
 317                         }
 318
 319
 320                         var feed_icon = "";
 321
 322                         var row_class = "feed";
 323
 324                         if (unread > 0) {
 325                                 row_class += "Unread";
 326                                 fctr_class = "feedCtrHasUnread";
 327                         } else {
 328                                 fctr_class = "feedCtrNoUnread";
 329                         }
 330
 331                         tmp += printFeedEntry(id, title, "feed", unread, icon);
 332
 333                         rs.next();
 334                 }
 335
 336                 tmp += "</ul>";
 337
 338                 render_feedlist(tmp);
 339         } catch (e) {
 340                 exception_error("render_offline_feedlist", e);
 341         }
 342 }
 343
 344 function init_offline() {
 345         try {
 346                 offline_mode = true;
 347
 348                 Element.hide("dispSwitchPrompt");
 349                 Element.hide("feedBrowserPrompt");
 350                 Element.hide("quickMenuChooser");
 351
 352                 init_params["theme"] = "";
 353
 354                 render_offline_feedlist();
 355                 remove_splash();
 356         } catch (e) {
 357                 exception_error("init_offline", e);
 358         }
 359 }
 360
 361 function offline_download_parse(stage, transport) {
 362         try {
 363                 if (transport.responseXML) {
 364
 365                         if (stage == 0) {
 366
 367                                 var feeds = transport.responseXML.getElementsByTagName("feed");
 368
 369                                 if (feeds.length > 0) {
 370                                         db.execute("DELETE FROM feeds");
 371                                 }
 372
 373                                 for (var i = 0; i < feeds.length; i++) {
 374                                         var id = feeds[i].getAttribute("id");
 375                                         var has_icon = feeds[i].getAttribute("has_icon");
 376                                         var title = feeds[i].firstChild.nodeValue;
 377
 378                                         db.execute("INSERT INTO feeds (id,title,has_icon)"+
 379                                                 "VALUES (?,?,?)",
 380                                                 [id, title, has_icon]);
 381                                 }
 382
 383                                 window.setTimeout("update_offline_data("+(stage+1)+")", 60*1000);
 384                         } else {
 385
 386                                 var articles = transport.responseXML.getElementsByTagName("article");
 387
 388                                 var articles_found = 0;
 389
 390                                 for (var i = 0; i < articles.length; i++) {
 391                                         var a = eval("("+articles[i].firstChild.nodeValue+")");
 392                                         articles_found++;
 393                                         if (a) {
 394
 395                                                 var date = new Date();
 396                                                 var ts = Math.round(date.getTime() / 1000);
 397
 398                                                 db.execute("DELETE FROM articles WHERE id = ?", [a.id]);
 399                                                 db.execute("INSERT INTO articles "+
 400                                                 "(id, feed_id, title, link, guid, updated, content, "+
 401                                                         "unread, marked, tags, added) "+
 402                                                 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
 403                                                         [a.id, a.feed_id, a.title, a.link, a.guid, a.updated,
 404                                                                 a.content, a.unread, a.marked, a.tags, ts]);
 405
 406                                         }
 407                                 }
 408
 409                                 if (articles_found > 0) {
 410                                         window.setTimeout("update_offline_data("+(stage+1)+")", 60*1000);
 411                                 } else {
 412                                         window.setTimeout("update_offline_data(0)", 1800*1000);
 413
 414                                         var date = new Date();
 415                                         var ts = Math.round(date.getTime() / 1000);
 416
 417                                         db.execute("DELETE FROM articles WHERE added < ? - 2592000", [ts]);
 418
 419                                 }
 420                         }
 421
 422                 }
 423         } catch (e) {
 424                 exception_error("offline_download_parse", e);
 425         }
 426 }
 427
 428 function update_offline_data(stage) {
 429         try {
 430
 431                 if (!stage) stage = 0;
 432
 433                 debug("update_offline_data: stage " + stage);
 434
 435 //              notify_progress("Loading, please wait... (" + stage +")", true);
 436
 437                 var query = "backend.php?op=rpc&subop=download&stage=" + stage;
 438
 439                 var rs = db.execute("SELECT MAX(id), MIN(id) FROM articles");
 440                 if (rs.isValidRow() && rs.field(0)) {
 441                         var offline_dl_max_id = rs.field(0);
 442                         var offline_dl_min_id = rs.field(1);
 443
 444                         query = query + "&cidt=" + offline_dl_max_id;
 445                         query = query + "&cidb=" + offline_dl_min_id;
 446                 }
 447
 448                 new Ajax.Request(query, {
 449                         onComplete: function(transport) {
 450                                 offline_download_parse(stage, transport);
 451                                 debug("update_offline_data: done " + stage);
 452                         } });
 453
 454         } catch (e) {
 455                 exception_error("initiate_offline_download", e);
 456         }
 457 }
 458
 459 function set_feedlist_counter(id, ctr) {
 460         try {
 461
 462                 var feedctr = document.getElementById("FEEDCTR-" + id);
 463                 var feedu = document.getElementById("FEEDU-" + id);
 464                 var feedr = document.getElementById("FEEDR-" + id);
 465
 466                 if (feedctr && feedu && feedr) {
 467
 468                         var row_needs_hl = (ctr > 0 && ctr > parseInt(feedu.innerHTML));
 469
 470                         feedu.innerHTML = ctr;
 471
 472                         if (ctr > 0) {
 473                                 feedctr.className = "feedCtrHasUnread";
 474                                 if (!feedr.className.match("Unread")) {
 475                                         var is_selected = feedr.className.match("Selected");
 476
 477                                         feedr.className = feedr.className.replace("Selected", "");
 478                                         feedr.className = feedr.className.replace("Unread", "");
 479
 480                                         feedr.className = feedr.className + "Unread";
 481
 482                                         if (is_selected) {
 483                                                 feedr.className = feedr.className + "Selected";
 484                                         }
 485
 486                                 }
 487
 488                                 if (row_needs_hl) {
 489                                         new Effect.Highlight(feedr, {duration: 1, startcolor: "#fff7d5",
 490                                                 queue: { position:'end', scope: 'EFQ-' + id, limit: 1 } } );
 491                                 }
 492                         } else {
 493                                 feedctr.className = "feedCtrNoUnread";
 494                                 feedr.className = feedr.className.replace("Unread", "");
 495                         }
 496                 }
 497
 498         } catch (e) {
 499                 exception_error("set_feedlist_counter", e);
 500         }
 501 }
 502
 503 function update_local_feedlist_counters() {
 504         try {
 505                 if (!db) return;
 506
 507                 var rs = db.execute("SELECT feeds.id,COUNT(articles.id) "+
 508                         "FROM feeds LEFT JOIN articles ON (feed_id = feeds.id) "+
 509                         "WHERE unread = 1 OR unread IS NULL GROUP BY feeds.id "+
 510                         "ORDER BY feeds.title");
 511
 512                 while (rs.isValidRow()) {
 513                         var id = rs.field(0);
 514                         var ctr = rs.field(1);
 515
 516                         set_feedlist_counter(id, ctr);
 517
 518                         rs.next();
 519                 }
 520
 521                 set_feedlist_counter(-4, get_local_feed_unread(-4));
 522                 set_feedlist_counter(-1, get_local_feed_unread(-1));
 523
 524                 hideOrShowFeeds(getInitParam("hide_read_feeds") == 1);
 525
 526                 global_unread = get_local_feed_unread(-4);
 527                 updateTitle();
 528
 529         } catch (e) {
 530                 exception_error("update_local_feedlist_counters", e);
 531         }
 532 }
 533
 534 function get_local_feed_unread(id) {
 535         try {
 536                 var rs;
 537
 538                 if (id == -4) {
 539                         rs = db.execute("SELECT SUM(unread) FROM articles");
 540                 } else if (id == -1) {
 541                         rs = db.execute("SELECT SUM(unread) FROM articles WHERE marked = 1");
 542                 } else {
 543                         rs = db.execute("SELECT SUM(unread) FROM articles WHERE feed_id = ?", [id]);
 544                 }
 545
 546                 if (rs.isValidRow()) {
 547                         return rs.field(0);
 548                 } else {
 549                         return 0;
 550                 }
 551
 552         } catch (e) {
 553                 exception_error("get_local_feed_unread", e);
 554         }
 555 }
 556
 557 function init_gears() {
 558         try {
 559
 560                 if (window.google && google.gears) {
 561                         localServer = google.gears.factory.create("beta.localserver");
 562                         store = localServer.createManagedStore("tt-rss");
 563                         db = google.gears.factory.create('beta.database');
 564                         db.open('tt-rss');
 565
 566                         db.execute("CREATE TABLE IF NOT EXISTS version (schema_version text)");
 567
 568                         var rs = db.execute("SELECT schema_version FROM version");
 569
 570                         var version = "";
 571
 572                         if (rs.isValidRow()) {
 573                                 version = rs.field(0);
 574                         }
 575
 576                         if (version != SCHEMA_VERSION) {
 577                                 db.execute("DROP TABLE IF EXISTS cache");
 578                                 db.execute("DROP TABLE IF EXISTS feeds");
 579                                 db.execute("DROP TABLE IF EXISTS articles");
 580                                 db.execute("INSERT INTO version (schema_version) VALUES (?)",
 581                                         [SCHEMA_VERSION]);
 582                         }
 583
 584                         db.execute("CREATE TABLE IF NOT EXISTS cache (id text, article text, param text, added text)");
 585                         db.execute("CREATE TABLE IF NOT EXISTS feeds (id integer, title text, has_icon integer)");
 586                         db.execute("CREATE TABLE IF NOT EXISTS articles (id integer, feed_id integer, title text, link text, guid text, updated text, content text, tags text, unread text, marked text, added text, comments text)");
 587                         window.setTimeout("update_offline_data(0)", 100);
 588
 589                 }
 590
 591                 cache_expire();
 592
 593         } catch (e) {
 594                 exception_error("init_gears", e);
 595         }
 596 }
 597
 598