]> git.wh0rd.org - tt-rss.git/blame - offline.js
use POST parameters for frontend requests
[tt-rss.git] / offline.js
CommitLineData
71af6d36 1var SCHEMA_VERSION = 10;
b871dd06 2
25d99353
AD
3var offline_mode = false;
4var store = false;
5var localServer = false;
6var db = false;
79e565a9
AD
7var articles_synced = 0;
8var sync_in_progress = false;
206d4967 9var sync_timer = false;
25d99353 10
4681834e
AD
11function view_offline(id, feed_id) {
12 try {
13
14 enableHotkeys();
15 showArticleInHeadlines(id);
16
1b27261c
AD
17 db.execute("UPDATE articles SET unread = 0 WHERE id = ?", [id]);
18
19 var rs = db.execute("SELECT * FROM articles WHERE id = ?", [id]);
20
21 if (rs.isValidRow()) {
22
23 var tmp = "<div class=\"postReply\">";
24
25 tmp += "<div class=\"postHeader\" onmouseover=\"enable_resize(true)\" "+
26 "onmouseout=\"enable_resize(false)\">";
27
28 tmp += "<div class=\"postDate\">"+rs.fieldByName("updated")+"</div>";
29
30 if (rs.fieldByName("link") != "") {
31 tmp += "<div clear='both'><a target=\"_blank\" "+
32 "href=\"" + rs.fieldByName("link") + "\">" +
33 rs.fieldByName("title") + "</a></div>";
34 } else {
35 tmp += "<div clear='both'>" + rs.fieldByName("title") + "</div>";
36 }
4681834e 37
3ab18266 38/* tmp += "<div style='float : right'> "+
1b27261c
AD
39 "<img src='images/tag.png' class='tagsPic' alt='Tags' title='Tags'>";
40 tmp += rs.fieldByName("tags");
3ab18266 41 tmp += "</div>"; */
1b27261c 42
424fc145 43/* tmp += "<div clear='both'>"+
12aa4007
AD
44 "<a target=\"_blank\" "+
45 "href=\"" + rs.fieldByName("comments") + "\">" +
424fc145 46 __("comments") + "</a></div>"; */
1b27261c
AD
47
48 tmp += "</div>";
49
50 tmp += "<div class=\"postContent\">"
51 tmp += rs.fieldByName("content");
52 tmp += "</div>";
53
54 tmp += "</div>";
55
56 render_article(tmp);
57 update_local_feedlist_counters();
58 }
4681834e 59
03c96380
AD
60 rs.close();
61
4681834e
AD
62 return false;
63
64 } catch (e) {
65 exception_error("view_offline", e);
66 }
67}
68
69function viewfeed_offline(feed_id, subop, is_cat, subop_param, skip_history, offset) {
70 try {
71 notify('');
72
73 if (!offset) offset = 0;
74
0e923da4
AD
75 if (offset > 0) {
76 _feed_cur_page = parseInt(offset);
77 if (_infscroll_request_sent) {
78 return;
79 }
80 } else {
81 _feed_cur_page = 0;
82 _infscroll_disable = 0;
83 }
84
85 if (getActiveFeedId() != feed_id) {
86 _feed_cur_page = 0;
87 active_post_id = 0;
88 _infscroll_disable = 0;
89 }
90
4681834e
AD
91 loading_set_progress(100);
92
93 clean_feed_selections();
94
95 setActiveFeedId(feed_id, is_cat);
96
97 if (!is_cat) {
acac8448 98 var feedr = $("FEEDR-" + feed_id);
4681834e
AD
99 if (feedr && !feedr.className.match("Selected")) {
100 feedr.className = feedr.className + "Selected";
101 }
102 } else {
acac8448 103 var feedr = $("FCAT-" + feed_id);
4681834e
AD
104 if (feedr && !feedr.className.match("Selected")) {
105 feedr.className = feedr.className + "Selected";
106 }
107 }
108
67625745
AD
109 if (subop == "MarkAllRead") {
110 catchup_local_feed(feed_id, is_cat);
111 }
112
4681834e
AD
113 disableContainerChildren("headlinesToolbar", false);
114 Form.enable("main_toolbar_form");
115
acac8448 116 var f = $("headlines-frame");
4681834e
AD
117 try {
118 if (reply.offset == 0) {
119 debug("resetting headlines scrollTop");
120 f.scrollTop = 0;
121 }
122 } catch (e) { };
123
124
4681834e 125 var tmp = "";
046a2e3c 126 var feed_title = "";
4681834e 127
046a2e3c
AD
128 if (is_cat) {
129 feed_title = get_local_category_title(feed_id);
130 } else {
131 feed_title = get_local_feed_title(feed_id);
132 }
4681834e 133
88a66534 134 if (feed_title) {
4681834e
AD
135
136 if (offset == 0) {
137 tmp += "<div id=\"headlinesContainer\">";
138
139 tmp += "<div class=\"headlinesSubToolbar\">";
140 tmp += "<div id=\"subtoolbar_ftitle\">";
141 tmp += feed_title;
142 tmp += "</div>";
143
779ba075
AD
144 var sel_all_link;
145 var sel_unread_link;
146 var sel_none_link;
147 var sel_inv_link;
148
46b84d29
AD
149 var catchup_feed_link = "javascript:catchupCurrentFeed()";
150 var catchup_sel_link = "javascript:catchupSelection()";
151
152 var tog_unread_link;
153 var tog_marked_link;
154
acac8448 155 if ($("content-frame")) {
779ba075
AD
156 sel_all_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', true, '', true)";
157 sel_unread_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', true, 'Unread', true)";
158 sel_none_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', false)";
159 sel_inv_link = "javascript:invertHeadlineSelection()";
46b84d29
AD
160
161 tog_unread_link = "javascript:selectionToggleUnread()";
162 tog_marked_link = "javascript:selectionToggleMarked()";
163
779ba075
AD
164 } else {
165 sel_all_link = "javascript:cdmSelectArticles('all')";
166 sel_unread_link = "javascript:cdmSelectArticles('unread')";
167 sel_none_link = "javascript:cdmSelectArticles('none')";
168 sel_inv_link = "javascript:invertHeadlineSelection()";
46b84d29
AD
169
170 tog_unread_link = "javascript:selectionToggleUnread(true)";
171 tog_marked_link = "javascript:selectionToggleMarked(true)";
779ba075 172 }
4681834e
AD
173
174 tmp += __('Select:')+
175 " <a href=\""+sel_all_link+"\">"+__('All')+"</a>, "+
176 "<a href=\""+sel_unread_link+"\">"+__('Unread')+"</a>, "+
177 "<a href=\""+sel_inv_link+"\">"+__('Invert')+"</a>, "+
178 "<a href=\""+sel_none_link+"\">"+__('None')+"</a>";
179
180 tmp += "&nbsp;&nbsp;";
181
67cf0d4a
AD
182 tmp += "<span onmouseover=\"enable_selection(false)\" "+
183 "onmouseout=\"enable_selection(true) \"" +
184 "onclick=\"toggleHeadlineActions()\" id=\"headlineActionsDrop\">" +
185 __("Actions...") + "&nbsp;&nbsp;<img src=\"images/down_arrow.png\">" +
186 "</span>";
187
188 tmp += "<ul id=\"headlineActionsBody\" style=\"display : none\">";
189
67cf0d4a
AD
190 tmp += "<li class=\"insensitive\">"+__('Selection toggle:')+"</li>"+
191 "<li onclick=\""+tog_unread_link+"\">&nbsp;&nbsp;"+__('Unread')+"</li>"+
192 "<li onclick=\""+tog_marked_link+"\">&nbsp;&nbsp;"+__('Starred')+"</li>"+
193 "<li class=\"insensitive\">"+__('Mark as read:')+"</li>"+
194 "<li onclick=\""+catchup_sel_link+"\">&nbsp;&nbsp;"+__('Selection')+"</li>";
195
196 tmp += "<li onclick=\""+catchup_feed_link+"\">&nbsp;&nbsp;"+__('Entire feed')+
197 "</li>";
198
199 tmp += "</ul>";
200
4681834e
AD
201 tmp += "</div>";
202
203 tmp += "<div id=\"headlinesInnerContainer\" onscroll=\"headlines_scroll_handler()\">";
acac8448 204 if ($("content-frame")) {
779ba075
AD
205 tmp += "<table class=\"headlinesList\" id=\"headlinesList\" cellspacing=\"0\">";
206 }
4681834e
AD
207
208 }
209
4681834e
AD
210 var limit = 30;
211
212 var toolbar_form = document.forms["main_toolbar_form"];
213
214 var limit = toolbar_form.limit[toolbar_form.limit.selectedIndex].value;
215 var view_mode = toolbar_form.view_mode[toolbar_form.view_mode.selectedIndex].value;
216
217 var limit_qpart = "";
218 var strategy_qpart = "";
219 var mode_qpart = "";
e491d06d 220 var offset_qpart = "";
4681834e
AD
221
222 if (limit != 0) {
223 limit_qpart = "LIMIT " + limit;
224 }
225
226 if (view_mode == "all_articles") {
227 mode_qpart = "1";
228 } else if (view_mode == "adaptive") {
046a2e3c
AD
229 if (is_cat && get_local_category_unread(feed_id) ||
230 get_local_feed_unread(feed_id) > 0) {
231 mode_qpart = "unread = 1";
4681834e
AD
232 } else {
233 mode_qpart = "1";
234 }
046a2e3c 235
4681834e
AD
236 } else if (view_mode == "marked") {
237 mode_qpart = "marked = 1";
238 } else if (view_mode == "unread") {
239 mode_qpart = "unread = 1";
240 } else {
241 mode_qpart = "1";
242 }
243
79645416
AD
244 var ext_tables_qpart = "";
245
046a2e3c
AD
246 if (is_cat) {
247 if (feed_id >= 0) {
248 strategy_qpart = "cat_id = " + feed_id;
249 } else if (feed_id == -2) {
250 strategy_qpart = "article_labels.id = articles.id";
251 ext_tables_qpart = ",article_labels";
252 }
253 } else if (feed_id > 0) {
4681834e
AD
254 strategy_qpart = "feed_id = " + feed_id;
255 } else if (feed_id == -1) {
256 strategy_qpart = "marked = 1";
257 } else if (feed_id == -4) {
258 strategy_qpart = "1";
88a66534
AD
259 } else if (feed_id < -10) {
260 var label_id = -11 - feed_id;
79645416
AD
261 strategy_qpart = "article_labels.id = articles.id AND label_id = " + label_id;
262 ext_tables_qpart = ",article_labels";
e491d06d
AD
263 }
264
265 if (offset > 0) {
266 offset_qpart = "OFFSET " + (offset*30);
267 } else {
268 offset_qpart = "";
269 }
4681834e 270
851ce414 271 var query = "SELECT *,feeds.title AS feed_title "+
046a2e3c 272 "FROM articles,feeds,categories"+ext_tables_qpart+" "+
79645416 273 "WHERE " +
046a2e3c 274 "cat_id = categories.id AND " +
851ce414 275 "feed_id = feeds.id AND " +
4681834e
AD
276 strategy_qpart +
277 " AND " + mode_qpart +
278 " ORDER BY updated DESC "+
e491d06d
AD
279 limit_qpart + " " +
280 offset_qpart;
4681834e
AD
281
282 var rs = db.execute(query);
283
e491d06d 284 var line_num = offset*30;
4681834e 285
851ce414
AD
286 var real_feed_id = feed_id;
287
4681834e
AD
288 while (rs.isValidRow()) {
289
290 var id = rs.fieldByName("id");
291 var feed_id = rs.fieldByName("feed_id");
292
851ce414
AD
293 var entry_feed_title = false;
294
046a2e3c 295 if (real_feed_id < 0 || is_cat) {
851ce414
AD
296 entry_feed_title = rs.fieldByName("feed_title");
297 }
298
4681834e
AD
299 var marked_pic;
300
301 var row_class = (line_num % 2) ? "even" : "odd";
302
303 if (rs.fieldByName("unread") == "1") {
304 row_class += "Unread";
305 }
6da82466
AD
306
307 var labels = get_local_article_labels(id);
308
6da82466
AD
309 var labels_str = "<span id=\"HLLCTR-"+id+"\">";
310 labels_str += format_article_labels(labels, id);
311 labels_str += "</span>";
312
4681834e
AD
313 if (rs.fieldByName("marked") == "1") {
314 marked_pic = "<img id=\"FMPIC-"+id+"\" "+
315 "src=\"images/mark_set.png\" class=\"markedPic\""+
316 "alt=\"Unstar article\" onclick='javascript:tMark("+id+")'>";
317 } else {
318 marked_pic = "<img id=\"FMPIC-"+id+"\" "+
319 "src=\"images/mark_unset.png\" class=\"markedPic\""+
320 "alt=\"Star article\" onclick='javascript:tMark("+id+")'>";
321 }
322
323 var mouseover_attrs = "onmouseover='postMouseIn($id)' "+
324 "onmouseout='postMouseOut($id)'";
779ba075
AD
325
326 var content_preview = truncate_string(strip_tags(rs.fieldByName("content")),
327 100);
4681834e 328
acac8448 329 if ($("content-frame")) {
4681834e 330
779ba075
AD
331 tmp += "<tr class='"+row_class+"' id='RROW-"+id+"' "+mouseover_attrs+">";
332
333 tmp += "<td class='hlUpdPic'> </td>";
4681834e 334
779ba075
AD
335 tmp += "<td class='hlSelectRow'>"+
336 "<input type=\"checkbox\" onclick=\"tSR(this)\" id=\"RCHK-"+id+"\"></td>";
337
338 tmp += "<td class='hlMarkedPic'>"+marked_pic+"</td>";
339
340 tmp += "<td onclick='view("+id+","+feed_id+")' "+
341 "class='hlContent' valign='middle'>";
342
851ce414 343 tmp += "<a target=\"_blank\" id=\"RTITLE-"+id+"\" href=\"" +
779ba075
AD
344 rs.fieldByName("link") + "\"" +
345 "onclick=\"return view("+id+","+feed_id+");\">"+
346 rs.fieldByName("title");
4681834e 347
779ba075
AD
348 tmp += "<span class=\"contentPreview\"> - "+content_preview+"</span>";
349
350 tmp += "</a>";
851ce414 351
6da82466
AD
352 tmp += labels_str;
353
851ce414
AD
354 if (entry_feed_title) {
355 tmp += " <span class=\"hlFeed\">"+
356 "(<a href='javascript:viewfeed("+feed_id+
357 ")'>"+entry_feed_title+"</a>)</span>";
358 }
359
779ba075 360 tmp += "</td>";
d07f08e8 361
779ba075 362 tmp += "<td class=\"hlUpdated\" onclick='view("+id+","+feed_id+")'>"+
d07f08e8
AD
363 "<nobr>"+rs.fieldByName("updated").substring(0,16)+
364 "</nobr></td>";
779ba075
AD
365
366 tmp += "</tr>";
367 } else {
4681834e 368
779ba075
AD
369 var add_class = "";
370
371 if (rs.fieldByName("unread") == "1") {
372 add_class = "Unread";
373 }
374
375 tmp += "<div class=\"cdmArticle"+add_class+"\" id=\"RROW-"+id+"\" "+
376 mouseover_attrs+"'>";
377
d07f08e8
AD
378 feed_icon_img = "<img class=\"tinyFeedIcon\" src=\""+
379 getInitParam("icons_url")+"/"+feed_id+".ico\" alt=\"\">";
380 cdm_feed_icon = "<span style=\"cursor : pointer\" "+
381 "onclick=\"viewfeed("+feed_id+")\">"+feed_icon_img+"</span>";
382
779ba075
AD
383 tmp += "<div class=\"cdmHeader\">";
384 tmp += "<div class=\"articleUpdated\">"+
d07f08e8
AD
385 rs.fieldByName("updated").substring(0,16)+
386 " "+cdm_feed_icon+"</div>";
779ba075
AD
387
388 tmp += "<span id=\"RTITLE-"+id+"\" class=\"titleWrap\">"+
389 "<a class=\"title\" onclick=\"javascript:toggleUnread("+id+", 0)\""+
390 "target=\"_blank\" href=\""+rs.fieldByName("link")+
391 "\">"+rs.fieldByName("title")+"</a>";
851ce414 392
6da82466
AD
393 tmp += labels_str;
394
851ce414
AD
395 if (entry_feed_title) {
396 tmp += "&nbsp;(<a href='javascript:viewfeed("+feed_id+
397 ")'>"+entry_feed_title+"</a>)";
398 }
399
779ba075
AD
400 tmp += "</span></div>";
401
402 tmp += "<div class=\"cdmContent\" onclick=\"cdmClicked("+id+")\""+
403 "id=\"CICD-"+id+"\">";
404 tmp += rs.fieldByName("content");
405 tmp += "<br clear='both'>"
406 tmp += "</div>";
407
408 tmp += "<div class=\"cdmFooter\"><span class='s0'>";
409 tmp += __("Select:")+
410 " <input type=\"checkbox\" "+
411 "onclick=\"toggleSelectRowById(this, 'RROW-"+id+"')\" "+
412 "class=\"feedCheckBox\" id=\"RCHK-"+id+"\">";
413
414 tmp += "</span><span class='s1'>"+marked_pic+"</span> ";
415
3ab18266 416/* tmp += "<span class='s1'>"+
779ba075
AD
417 "<img class='tagsPic' src='images/tag.png' alt='Tags' title='Tags'>"+
418 "<span id=\"ATSTR-"+id+"\">"+rs.fieldByName("tags")+"</span>"+
3ab18266 419 "</span>"; */
779ba075
AD
420
421 tmp += "<span class='s2'>Toggle: <a class=\"cdmToggleLink\""+
422 "href=\"javascript:toggleUnread("+id+")\">"+
423 "Unread</a></span>";
424 tmp += "</div>";
425
426 tmp += "</div>";
427 }
4681834e
AD
428
429 rs.next();
430 line_num++;
431 }
03c96380 432
0e923da4
AD
433 if (line_num - offset*30 < 30) {
434 _infscroll_disable = 1;
435 }
436
03c96380 437 rs.close();
4681834e
AD
438
439 if (offset == 0) {
440 tmp += "</table>";
76d20f5f
AD
441
442 if (line_num - offset*30 == 0) {
443 tmp += "<div class='whiteBox'>" +
444 __("No articles found to display.") +
445 "</div>";
446 }
4681834e
AD
447 tmp += "</div></div>";
448 }
449
450 if (offset == 0) {
acac8448 451 var container = $("headlines-frame");
4681834e
AD
452 container.innerHTML = tmp;
453 } else {
454 var ids = getSelectedArticleIds2();
455
acac8448 456 var container = $("headlinesList");
e491d06d 457 container.innerHTML = container.innerHTML + tmp;
4681834e
AD
458
459 for (var i = 0; i < ids.length; i++) {
460 markHeadline(ids[i]);
461 }
462 }
463 }
464
465 remove_splash();
466
0e923da4 467 _infscroll_request_sent = 0;
4681834e
AD
468
469 } catch (e) {
470 exception_error("viewfeed_offline", e);
471 }
472}
473
474function render_offline_feedlist() {
475 try {
1c980681 476 var cats_enabled = getInitParam("enable_feed_cats") == "1";
d6416405 477
4681834e
AD
478 var tmp = "<ul class=\"feedList\" id=\"feedList\">";
479
480 var unread = get_local_feed_unread(-4);
481
482 global_unread = unread;
483 updateTitle();
484
d6416405 485 if (cats_enabled) {
c2726c96 486 tmp += printCategoryHeader(-1, is_local_cat_collapsed(-1), false);
d6416405
AD
487 }
488
4681834e
AD
489 tmp += printFeedEntry(-4, __("All articles"), "feed", unread,
490 "images/tag.png");
491
492 var unread = get_local_feed_unread(-1);
493
494 tmp += printFeedEntry(-1, __("Starred articles"), "feed", unread,
495 "images/mark_set.png");
496
d6416405
AD
497 if (cats_enabled) {
498 tmp += "</ul></li>";
499 } else {
500 tmp += "<li><hr/></li>";
501 }
4681834e 502
c2726c96
AD
503 if (cats_enabled) {
504 tmp += printCategoryHeader(-2, is_local_cat_collapsed(-2), false);
505 }
506
507 var rs = db.execute("SELECT id,caption "+
508 "FROM labels "+
509 "ORDER BY caption");
510
511 while (rs.isValidRow()) {
512 var id = -11 - parseInt(rs.field(0));
513 var caption = rs.field(1);
514 var unread = get_local_feed_unread(id);
515
516 tmp += printFeedEntry(id, caption, "feed", unread,
517 "images/label.png");
518
519 rs.next();
520 }
521
522 rs.close();
523
524 if (cats_enabled) {
525 tmp += "</ul></li>";
526 } else {
527 tmp += "<li><hr/></li>";
528 }
529
f4c11347 530/* var rs = db.execute("SELECT feeds.id,feeds.title,has_icon,COUNT(articles.id) "+
4681834e
AD
531 "FROM feeds LEFT JOIN articles ON (feed_id = feeds.id) "+
532 "WHERE unread = 1 OR unread IS NULL GROUP BY feeds.id "+
f4c11347
AD
533 "ORDER BY feeds.title"); */
534
d6416405
AD
535 var order_by = "feeds.title";
536
537 if (cats_enabled) order_by = "categories.title," + order_by;
538
539 var rs = db.execute("SELECT "+
540 "feeds.id,feeds.title,has_icon,cat_id,collapsed "+
541 "FROM feeds,categories WHERE cat_id = categories.id "+
542 "ORDER BY "+order_by);
543
544 var tmp_cat_id = -1;
4681834e
AD
545
546 while (rs.isValidRow()) {
547
548 var id = rs.field(0);
549 var title = rs.field(1);
550 var has_icon = rs.field(2);
f4c11347 551 var unread = get_local_feed_unread(id);
d6416405
AD
552 var cat_id = rs.field(3);
553 var cat_hidden = rs.field(4);
554
555 if (cat_id != tmp_cat_id && cats_enabled) {
556 if (tmp_cat_id != -1) {
557 tmp += "</ul></li>";
558 }
046a2e3c 559 tmp += printCategoryHeader(cat_id, cat_hidden, true);
d6416405
AD
560 tmp_cat_id = cat_id;
561 }
4681834e
AD
562
563 var icon = "";
564
565 if (has_icon) {
046a2e3c 566 icon = getInitParam("icons_url") + "/" + id + ".ico";
4681834e
AD
567 }
568
4681834e
AD
569 var feed_icon = "";
570
571 var row_class = "feed";
572
573 if (unread > 0) {
574 row_class += "Unread";
575 fctr_class = "feedCtrHasUnread";
576 } else {
577 fctr_class = "feedCtrNoUnread";
578 }
579
580 tmp += printFeedEntry(id, title, "feed", unread, icon);
581
582 rs.next();
583 }
584
03c96380
AD
585 rs.close();
586
983a6a9c
AD
587 if (cats_enabled) {
588 tmp += "</ul>";
589 }
590
4681834e
AD
591 tmp += "</ul>";
592
593 render_feedlist(tmp);
594 } catch (e) {
595 exception_error("render_offline_feedlist", e);
596 }
597}
598
599function init_offline() {
600 try {
601 offline_mode = true;
9ca945a6 602 store.enabled = true;
4681834e
AD
603
604 Element.hide("dispSwitchPrompt");
605 Element.hide("feedBrowserPrompt");
4681834e 606
69ea0cdd
AD
607 Element.hide("topLinksOnline");
608 Element.show("topLinksOffline");
609
acac8448 610 var tb_form = $("main_toolbar_form");
80b1c238
AD
611 Element.hide(tb_form.update);
612
acac8448 613 var chooser = $("quickMenuChooser");
3c6d3586
AD
614 chooser.disabled = true;
615
3034277a
AD
616 var rs = db.execute("SELECT key, value FROM init_params");
617
618 while (rs.isValidRow()) {
619 init_params[rs.field(0)] = rs.field(1);
620 rs.next();
621 }
622
623 rs.close();
4681834e 624
b15e516e
AD
625 var rs = db.execute("SELECT COUNT(*) FROM feeds");
626
627 var num_feeds = 0;
628
629 if (rs.isValidRow()) {
630 num_feeds = rs.field(0);
631 }
632
633 rs.close();
634
635 if (num_feeds == 0) {
636 remove_splash();
637 return fatalError(0,
638 __("Data for offline browsing has not been downloaded yet."));
639 }
640
4681834e 641 render_offline_feedlist();
10003c4c 642 init_second_stage();
b15e516e
AD
643 window.setTimeout("viewfeed(-4)", 50);
644
4681834e
AD
645 } catch (e) {
646 exception_error("init_offline", e);
647 }
648}
649
650function offline_download_parse(stage, transport) {
651 try {
652 if (transport.responseXML) {
653
206d4967
AD
654 if (!sync_in_progress) return;
655
badac687
AD
656 var sync_ok = transport.responseXML.getElementsByTagName("sync-ok");
657
658 if (sync_ok.length > 0) {
659 for (var i = 0; i < sync_ok.length; i++) {
660 var id = sync_ok[i].getAttribute("id");
492a4a6a
AD
661 var unread = sync_ok[i].getAttribute("unread");
662 var marked = sync_ok[i].getAttribute("marked");
663
badac687
AD
664 if (id) {
665 debug("synced offline info for id " + id);
492a4a6a
AD
666
667 if (unread != undefined && marked != undefined) {
668 db.execute("UPDATE articles SET "+
669 "unread = ?, marked = ? WHERE id = ?", [unread, marked, id]);
670
671 }
badac687
AD
672 db.execute("UPDATE articles SET modified = '' WHERE id = ?", [id]);
673 }
674 }
675 }
676
4681834e
AD
677 if (stage == 0) {
678
8ca1a0ac
AD
679 $("offlineModeSyncMsg").innerHTML = __("Synchronizing feeds...");
680
4681834e
AD
681 var feeds = transport.responseXML.getElementsByTagName("feed");
682
683 if (feeds.length > 0) {
684 db.execute("DELETE FROM feeds");
685 }
686
687 for (var i = 0; i < feeds.length; i++) {
688 var id = feeds[i].getAttribute("id");
689 var has_icon = feeds[i].getAttribute("has_icon");
690 var title = feeds[i].firstChild.nodeValue;
d8781c91
AD
691 var cat_id = feeds[i].getAttribute("cat_id");
692
693 db.execute("INSERT INTO feeds (id,title,has_icon,cat_id)"+
75aa83ec 694 "VALUES (?,?,?,?)",
d8781c91 695 [id, title, has_icon, cat_id]);
4681834e 696 }
75aa83ec 697
8ca1a0ac
AD
698 $("offlineModeSyncMsg").innerHTML = __("Synchronizing categories...");
699
75aa83ec
AD
700 var cats = transport.responseXML.getElementsByTagName("category");
701
702 if (feeds.length > 0) {
703 db.execute("DELETE FROM categories");
704 }
705
706 for (var i = 0; i < cats.length; i++) {
707 var id = cats[i].getAttribute("id");
708 var collapsed = cats[i].getAttribute("collapsed");
709 var title = cats[i].firstChild.nodeValue;
710
711 db.execute("INSERT INTO categories (id,title,collapsed)"+
712 "VALUES (?,?,?)",
713 [id, title, collapsed]);
714 }
715
8ca1a0ac
AD
716 $("offlineModeSyncMsg").innerHTML = __("Synchronizing labels...");
717
ed22888b
AD
718 var labels = transport.responseXML.getElementsByTagName("label");
719
720 if (labels.length > 0) {
721 db.execute("DELETE FROM labels");
722 }
723
724 for (var i = 0; i < labels.length; i++) {
725 var id = labels[i].getAttribute("id");
726 var fg_color = labels[i].getAttribute("fg_color");
727 var bg_color = labels[i].getAttribute("bg_color");
728 var caption = labels[i].firstChild.nodeValue;
729
730 db.execute("INSERT INTO labels (id,caption,fg_color,bg_color)"+
731 "VALUES (?,?,?,?)",
732 [id, caption, fg_color, bg_color]);
733 }
734
8ca1a0ac
AD
735 $("offlineModeSyncMsg").innerHTML = __("Synchronizing articles...");
736
737 sync_timer = window.setTimeout("update_offline_data("+(stage+1)+")", 2*1000);
4681834e
AD
738 } else {
739
740 var articles = transport.responseXML.getElementsByTagName("article");
741
3e52ab08
AD
742 var limit = transport.responseXML.getElementsByTagName("limit")[0];
743
744 if (limit) {
745 limit = limit.getAttribute("value");
746 } else {
747 limit = 0;
748 }
749
4681834e
AD
750 var articles_found = 0;
751
752 for (var i = 0; i < articles.length; i++) {
753 var a = eval("("+articles[i].firstChild.nodeValue+")");
754 articles_found++;
755 if (a) {
756
4681834e 757 db.execute("DELETE FROM articles WHERE id = ?", [a.id]);
c2726c96 758
4681834e
AD
759 db.execute("INSERT INTO articles "+
760 "(id, feed_id, title, link, guid, updated, content, "+
55852afa
AD
761 "unread, marked, tags, comments) "+
762 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
4681834e 763 [a.id, a.feed_id, a.title, a.link, a.guid, a.updated,
55852afa 764 a.content, a.unread, a.marked, a.tags,
3034277a 765 a.comments]);
4681834e 766
c2726c96
AD
767 if (a.labels.length > 0) {
768 for (var j = 0; j < a.labels.length; j++) {
769 label_local_add_article(a.id, a.labels[j][0]);
770 }
771 }
772
4681834e
AD
773 }
774 }
775
3e52ab08
AD
776 debug("downloaded articles: " + articles_found + " limit: " + limit);
777
79e565a9
AD
778 articles_synced += articles_found;
779
b4dc02e2 780 var msg =__("Synchronizing articles (%d)...").replace("%d", articles_synced);
79e565a9
AD
781
782 $("offlineModeSyncMsg").innerHTML = msg;
783
badac687
AD
784 var has_sync_data = has_local_sync_data();
785
786 if (articles_found >= limit || has_sync_data) {
206d4967 787 sync_timer = window.setTimeout("update_offline_data("+(stage+1)+")",
8ca1a0ac 788 3*1000);
badac687
AD
789 debug("<b>update_offline_data: done " + stage + " HSD: " +
790 has_sync_data + "</b>");
4681834e 791 } else {
206d4967 792 window.setTimeout("offlineDownloadStart()", 180*1000);
3e52ab08 793 debug("update_offline_data: finished");
4681834e 794
79e565a9 795 var pic = $("offlineModePic");
04870193
AD
796
797 if (pic) {
798 pic.src = "images/offline.png";
79e565a9
AD
799
800 var rs = db.execute("SELECT value FROM syncdata WHERE key = 'last_online'");
801 var last_sync = "";
802
803 if (rs.isValidRow()) {
804 last_sync = rs.field(0).substring(0,16);
805 }
806 rs.close();
807
808 var msg = __("Last sync: %s").replace("%s", last_sync);
809
810 articles_synced = 0;
811
812 $("offlineModeSyncMsg").innerHTML = msg;
04870193
AD
813 }
814
8ca1a0ac 815 offlineSyncShowHideElems(false);
79e565a9
AD
816
817 sync_in_progress = false;
818
711f9461
AD
819 db.execute("DELETE FROM articles WHERE "+
820 "updated < DATETIME('NOW', 'localtime', '-31 days')");
4681834e
AD
821
822 }
823 }
824
7f4f9f4e 825 update_local_sync_data();
04870193 826
7f4f9f4e 827
f45c85f9 828// notify('');
b2319311 829
b4dc02e2
AD
830 } else {
831 sync_in_progress = false;
832
833 var pic = $("offlineModePic");
834
835 if (pic) {
836 pic.src = "images/offline.png";
8ca1a0ac 837 var msg = __("Last sync: Error receiving data.");
b4dc02e2
AD
838 articles_synced = 0;
839 $("offlineModeSyncMsg").innerHTML = msg;
840 }
841
8ca1a0ac 842 offlineSyncShowHideElems(false);
4681834e 843 }
b4dc02e2 844
4681834e
AD
845 } catch (e) {
846 exception_error("offline_download_parse", e);
847 }
848}
849
850function update_offline_data(stage) {
851 try {
852
c16694c8 853 if (!stage) stage = 0;
79e565a9 854
23e2fb84 855 if (!db || offline_mode || getInitParam("offline_enabled") != "1") return;
4681834e 856
b4e75b2a 857 var query = "?op=rpc&subop=download";
e8080ee9 858
4681834e 859 var rs = db.execute("SELECT MAX(id), MIN(id) FROM articles");
03c96380 860
4681834e
AD
861 if (rs.isValidRow() && rs.field(0)) {
862 var offline_dl_max_id = rs.field(0);
863 var offline_dl_min_id = rs.field(1);
864
865 query = query + "&cidt=" + offline_dl_max_id;
866 query = query + "&cidb=" + offline_dl_min_id;
e8080ee9 867
673b99ca 868 if (stage > 0) stage = 1;
4681834e
AD
869 }
870
03c96380
AD
871 rs.close();
872
e8080ee9
AD
873 debug("update_offline_data: stage " + stage);
874
875 query = query + "&stage=" + stage;
876
badac687
AD
877 var to_sync = prepare_local_sync_data();
878
879 if (to_sync != "") {
b4e75b2a 880 to_sync = "&sync=" + param_escape(to_sync);
badac687
AD
881 }
882
b4e75b2a 883 query = query + to_sync;
badac687 884
79e565a9 885 var pic = $("offlineModePic");
04870193
AD
886
887 if (pic) {
888 pic.src = "images/offline-sync.gif";
79e565a9
AD
889 if (articles_synced == 0) {
890 $("offlineModeSyncMsg").innerHTML = __("Synchronizing...");
891 }
892 }
893
8ca1a0ac 894 offlineSyncShowHideElems(true);
9ca945a6 895 offlineUpdateStore();
79e565a9 896
79e565a9 897 sync_in_progress = true;
04870193 898
b4e75b2a
AD
899 debug(query);
900
901 new Ajax.Request("backend.php", {
902 parameters: query,
4681834e
AD
903 onComplete: function(transport) {
904 offline_download_parse(stage, transport);
4681834e
AD
905 } });
906
907 } catch (e) {
908 exception_error("initiate_offline_download", e);
909 }
910}
911
d6416405 912function set_feedlist_counter(id, ctr, is_cat) {
4681834e
AD
913 try {
914
acac8448
AD
915 var feedctr = $("FEEDCTR-" + id);
916 var feedu = $("FEEDU-" + id);
917 var feedr = $("FEEDR-" + id);
4681834e 918
d6416405 919 if (is_cat) {
acac8448 920 var catctr = $("FCATCTR-" + id);
d6416405
AD
921 if (catctr) {
922 catctr.innerHTML = "(" + ctr + ")";
923 if (ctr > 0) {
924 catctr.className = "catCtrHasUnread";
925 } else {
926 catctr.className = "catCtrNoUnread";
927 }
928 }
929 } else if (feedctr && feedu && feedr) {
4681834e
AD
930
931 var row_needs_hl = (ctr > 0 && ctr > parseInt(feedu.innerHTML));
932
933 feedu.innerHTML = ctr;
934
935 if (ctr > 0) {
936 feedctr.className = "feedCtrHasUnread";
937 if (!feedr.className.match("Unread")) {
938 var is_selected = feedr.className.match("Selected");
939
940 feedr.className = feedr.className.replace("Selected", "");
941 feedr.className = feedr.className.replace("Unread", "");
942
943 feedr.className = feedr.className + "Unread";
944
945 if (is_selected) {
946 feedr.className = feedr.className + "Selected";
947 }
948
949 }
950
951 if (row_needs_hl) {
952 new Effect.Highlight(feedr, {duration: 1, startcolor: "#fff7d5",
953 queue: { position:'end', scope: 'EFQ-' + id, limit: 1 } } );
954 }
955 } else {
956 feedctr.className = "feedCtrNoUnread";
957 feedr.className = feedr.className.replace("Unread", "");
958 }
959 }
960
961 } catch (e) {
962 exception_error("set_feedlist_counter", e);
963 }
964}
965
966function update_local_feedlist_counters() {
967 try {
b7dbf528 968 if (!offline_mode || !db) return;
4681834e 969
f4c11347 970/* var rs = db.execute("SELECT feeds.id,COUNT(articles.id) "+
4681834e
AD
971 "FROM feeds LEFT JOIN articles ON (feed_id = feeds.id) "+
972 "WHERE unread = 1 OR unread IS NULL GROUP BY feeds.id "+
f4c11347
AD
973 "ORDER BY feeds.title"); */
974
d6416405 975 var rs = db.execute("SELECT id FROM feeds "+
f4c11347 976 "ORDER BY title");
4681834e
AD
977
978 while (rs.isValidRow()) {
979 var id = rs.field(0);
f4c11347 980 var ctr = get_local_feed_unread(id);
d6416405
AD
981 set_feedlist_counter(id, ctr, false);
982 rs.next();
983 }
4681834e 984
d6416405
AD
985 rs.close();
986
987 var rs = db.execute("SELECT cat_id,SUM(unread) "+
988 "FROM articles, feeds WHERE feeds.id = feed_id GROUP BY cat_id");
4681834e 989
d6416405
AD
990 while (rs.isValidRow()) {
991 var id = rs.field(0);
992 var ctr = rs.field(1);
993 set_feedlist_counter(id, ctr, true);
4681834e
AD
994 rs.next();
995 }
996
03c96380
AD
997 rs.close();
998
c174bcdf
AD
999 set_feedlist_counter(-2, get_local_category_unread(-2), true);
1000
4681834e
AD
1001 set_feedlist_counter(-4, get_local_feed_unread(-4));
1002 set_feedlist_counter(-1, get_local_feed_unread(-1));
1003
88a66534
AD
1004 var rs = db.execute("SELECT id FROM labels");
1005
1006 while (rs.isValidRow()) {
1007 var id = -11 - rs.field(0);
1008 var ctr = get_local_feed_unread(id);
1009 set_feedlist_counter(id, ctr, false);
1010 rs.next();
1011 }
1012
1013 rs.close();
1014
4681834e
AD
1015 hideOrShowFeeds(getInitParam("hide_read_feeds") == 1);
1016
1017 global_unread = get_local_feed_unread(-4);
1018 updateTitle();
1019
1020 } catch (e) {
1021 exception_error("update_local_feedlist_counters", e);
1022 }
1023}
774b8df8
AD
1024
1025function get_local_feed_unread(id) {
1026 try {
1027 var rs;
1028
1029 if (id == -4) {
1030 rs = db.execute("SELECT SUM(unread) FROM articles");
1031 } else if (id == -1) {
1032 rs = db.execute("SELECT SUM(unread) FROM articles WHERE marked = 1");
88a66534 1033 } else if (id > 0) {
774b8df8 1034 rs = db.execute("SELECT SUM(unread) FROM articles WHERE feed_id = ?", [id]);
88a66534
AD
1035 } else if (id < -10) {
1036 var label_id = -11 - id;
1037 rs = db.execute("SELECT SUM(unread) FROM articles,article_labels "+
1038 "WHERE article_labels.id = articles.id AND label_id = ?", [label_id]);
774b8df8
AD
1039 }
1040
03c96380
AD
1041 var a = false;
1042
774b8df8 1043 if (rs.isValidRow()) {
03c96380 1044 a = rs.field(0);
774b8df8 1045 } else {
03c96380 1046 a = 0;
774b8df8
AD
1047 }
1048
03c96380
AD
1049 rs.close();
1050
1051 return a;
1052
774b8df8
AD
1053 } catch (e) {
1054 exception_error("get_local_feed_unread", e);
1055 }
1056}
1057
59b223d7
AD
1058function enable_offline_reading() {
1059 try {
1060
23e2fb84 1061 if (db && getInitParam("offline_enabled") == "1") {
59b223d7 1062 init_local_sync_data();
79e565a9
AD
1063 Element.show("offlineModePic");
1064 offlineDownloadStart();
59b223d7
AD
1065 }
1066
1067 } catch (e) {
1068 exception_error("enable_offline_reading", e);
1069 }
1070}
1071
25d99353
AD
1072function init_gears() {
1073 try {
1074
1075 if (window.google && google.gears) {
8ca1a0ac
AD
1076
1077 try {
1078 localServer = google.gears.factory.create("beta.localserver");
1079 } catch (e) {
1080 return;
1081 }
1082
25d99353 1083 store = localServer.createManagedStore("tt-rss");
206d4967 1084 store.manifestUrl = "manifest.json.php";
9ca945a6 1085 store.enabled = false;
206d4967 1086
25d99353
AD
1087 db = google.gears.factory.create('beta.database');
1088 db.open('tt-rss');
1089
1090 db.execute("CREATE TABLE IF NOT EXISTS version (schema_version text)");
1091
1092 var rs = db.execute("SELECT schema_version FROM version");
1093
1094 var version = "";
1095
1096 if (rs.isValidRow()) {
1097 version = rs.field(0);
1098 }
1099
3034277a
AD
1100 rs.close();
1101
25d99353 1102 if (version != SCHEMA_VERSION) {
3034277a 1103 db.execute("DROP TABLE IF EXISTS init_params");
b871dd06
AD
1104 db.execute("DROP TABLE IF EXISTS cache");
1105 db.execute("DROP TABLE IF EXISTS feeds");
d8781c91 1106 db.execute("DROP TABLE IF EXISTS categories");
ed22888b
AD
1107 db.execute("DROP TABLE IF EXISTS labels");
1108 db.execute("DROP TABLE IF EXISTS article_labels");
b871dd06 1109 db.execute("DROP TABLE IF EXISTS articles");
c174bcdf
AD
1110 db.execute("DROP INDEX IF EXISTS article_labels_label_id_idx");
1111 db.execute("DROP INDEX IF EXISTS articles_unread_idx");
1112 db.execute("DROP INDEX IF EXISTS articles_feed_id_idx");
badac687
AD
1113 db.execute("DROP INDEX IF EXISTS articles_id_idx");
1114 db.execute("DROP INDEX IF EXISTS article_labels_id_idx");
3034277a 1115 db.execute("DROP TABLE IF EXISTS version");
6b684299
AD
1116 db.execute("DROP TRIGGER IF EXISTS articles_update_unread");
1117 db.execute("DROP TRIGGER IF EXISTS articles_update_marked");
5b880817 1118 db.execute("DROP TRIGGER IF EXISTS articles_remove_labelrefs");
3034277a 1119 db.execute("CREATE TABLE IF NOT EXISTS version (schema_version text)");
6b684299 1120 db.execute("DROP TABLE IF EXISTS syncdata");
25d99353
AD
1121 db.execute("INSERT INTO version (schema_version) VALUES (?)",
1122 [SCHEMA_VERSION]);
1123 }
1124
71af6d36 1125 db.execute("CREATE TABLE IF NOT EXISTS init_params (key text, value text)");
3034277a 1126
71af6d36
AD
1127 db.execute("CREATE TABLE IF NOT EXISTS cache (id integer, article text, param text, added text)");
1128 db.execute("CREATE TABLE IF NOT EXISTS feeds (id integer, title text, has_icon integer, cat_id integer)");
1129 db.execute("CREATE TABLE IF NOT EXISTS categories (id integer, title text, collapsed integer)");
1130 db.execute("CREATE TABLE IF NOT EXISTS labels (id integer, caption text, fg_color text, bg_color text)");
ed22888b 1131 db.execute("CREATE TABLE IF NOT EXISTS article_labels (id integer, label_id integer)");
55852afa 1132 db.execute("CREATE TABLE IF NOT EXISTS articles (id integer, feed_id integer, title text, link text, guid text, updated timestamp, content text, tags text, unread integer, marked integer, added text, modified timestamp, comments text)");
c174bcdf
AD
1133
1134 db.execute("CREATE INDEX IF NOT EXISTS articles_unread_idx ON articles(unread)");
1135 db.execute("CREATE INDEX IF NOT EXISTS article_labels_label_id_idx ON article_labels(label_id)");
1136 db.execute("CREATE INDEX IF NOT EXISTS articles_feed_id_idx ON articles(feed_id)");
badac687
AD
1137 db.execute("CREATE INDEX IF NOT EXISTS articles_id_idx ON articles(id)");
1138 db.execute("CREATE INDEX IF NOT EXISTS article_labels_id_idx ON article_labels(id)");
779ba075 1139
71af6d36 1140 db.execute("CREATE TABLE IF NOT EXISTS syncdata (key integer, value text)");
6b684299 1141
779ba075 1142 db.execute("DELETE FROM cache WHERE id LIKE 'F:%' OR id LIKE 'C:%'");
69ea0cdd 1143
6b684299 1144 db.execute("CREATE TRIGGER IF NOT EXISTS articles_update_unread "+
55852afa
AD
1145 "UPDATE OF unread ON articles "+
1146 "BEGIN "+
711f9461 1147 "UPDATE articles SET modified = DATETIME('NOW', 'localtime') "+
6b684299
AD
1148 "WHERE id = OLD.id AND "+
1149 "OLD.unread != NEW.unread;"+
1150 "END;");
1151
1152 db.execute("CREATE TRIGGER IF NOT EXISTS articles_update_marked "+
1153 "UPDATE OF marked ON articles "+
1154 "BEGIN "+
1155 "UPDATE articles SET modified = DATETIME('NOW', 'localtime') "+
1156 "WHERE id = OLD.id;"+
55852afa
AD
1157 "END;");
1158
5b880817
AD
1159 db.execute("CREATE TRIGGER IF NOT EXISTS articles_remove_labelrefs "+
1160 "DELETE ON articles "+
1161 "BEGIN "+
1162 "DELETE FROM article_labels WHERE id = OLD.id; "+
1163 "END; ");
1164
25d99353
AD
1165 }
1166
1167 cache_expire();
1168
1169 } catch (e) {
1170 exception_error("init_gears", e);
1171 }
1172}
1173
a8caa4c7 1174function offlineArticlesStored() {
206d4967 1175
8ca1a0ac
AD
1176 var rs = db.execute("SELECT COUNT(*) FROM articles");
1177 var count = 0;
1178 if (rs.isValidRow()) {
1179 count = rs.field(0);
1180 }
1181
1182 rs.close();
1183
a8caa4c7
AD
1184 return count;
1185}
1186
1187function gotoOffline() {
1188
1189// debug("[Local store] currentVersion = " + store.currentVersion);
1190
1191
1192 if (offlineArticlesStored() == 0) {
8ca1a0ac
AD
1193 notify_error("You have to synchronize some articles before going into offline mode.");
1194 return;
1195 }
1196
206d4967
AD
1197 if (confirm(__("Switch Tiny Tiny RSS into offline mode?"))) {
1198
9ca945a6 1199 store.enabled = true;
206d4967
AD
1200 store.checkForUpdate();
1201
80b7fe74 1202 notify_progress("Preparing offline mode...", true);
206d4967
AD
1203
1204 var timerId = window.setInterval(function() {
1205 if (store.currentVersion) {
1206 window.clearInterval(timerId);
8ca1a0ac
AD
1207 debug("[Local store] sync complete: " + store.currentVersion);
1208
1209 //window.location.href = "tt-rss.php";
1210
1211 offlineDownloadStop();
8ca1a0ac
AD
1212 init_offline();
1213
1214 notify_info("Tiny Tiny RSS is in offline mode.");
1215
206d4967
AD
1216 } else if (store.updateStatus == 3) {
1217 debug("[Local store] sync error: " + store.lastErrorMessage);
8ca1a0ac 1218 notify_error(store.lastErrorMessage, true);
206d4967
AD
1219 } }, 500);
1220 }
69ea0cdd
AD
1221}
1222
1223function gotoOnline() {
9ca945a6
AD
1224// if (confirm(__("You won't be able to access offline version of Tiny Tiny RSS until you switch it into offline mode again. Go online?"))) {
1225 if (confirm(__("Tiny Tiny RSS will reload. Go online?"))) {
1226 //localServer.removeManagedStore("tt-rss");
f4280bdd 1227 window.location.href = "tt-rss.php?online=1";
206d4967 1228 }
69ea0cdd 1229}
774b8df8 1230
c26aa9f0
AD
1231function local_collapse_cat(id) {
1232 try {
1233 if (db) {
1234 db.execute("UPDATE categories SET collapsed = NOT collapsed WHERE id = ?",
1235 [id]);
1236 }
1237 } catch (e) {
1238 exception_error("local_collapse_cat", e);
1239 }
1240}
d6416405
AD
1241
1242function get_local_category_title(id) {
1243 try {
71af6d36 1244
d6416405
AD
1245 var rs = db.execute("SELECT title FROM categories WHERE id = ?", [id]);
1246 var tmp = "";
1247
1248 if (rs.isValidRow()) {
1249 tmp = rs.field(0);
1250 }
1251
1252 rs.close();
1253
1254 return tmp;
1255
1256 } catch (e) {
1257 exception_error("get_local_category_title", e);
1258 }
1259}
1260
1261function get_local_category_unread(id) {
1262 try {
c174bcdf
AD
1263 var rs = false;
1264
1265 if (id >= 0) {
1266 rs = db.execute("SELECT SUM(unread) FROM articles, feeds "+
1267 "WHERE feeds.id = feed_id AND cat_id = ?", [id]);
1268 } else if (id == -2) {
1269 rs = db.execute("SELECT SUM(unread) FROM article_labels, articles "+
1270 "where article_labels.id = articles.id");
1271 } else {
1272 return 0;
1273 }
d6416405
AD
1274
1275 var tmp = 0;
1276
1277 if (rs.isValidRow()) {
1278 tmp = rs.field(0);
1279 }
1280
1281 rs.close();
1282
1283 return tmp;
1284
1285 } catch (e) {
1286 exception_error("get_local_category_unread", e);
1287 }
1288}
1289
1290function printCategoryHeader(cat_id, hidden, can_browse) {
1291 try {
1292 if (hidden == undefined) hidden = false;
1293 if (can_browse == undefined) can_browse = false;
1294
1295 var tmp_category = get_local_category_title(cat_id);
1296 var tmp = "";
1297
1298 var cat_unread = get_local_category_unread(cat_id);
1299
1300 var holder_style = "";
1301 var ellipsis = "";
1302
1303 if (hidden) {
1304 holder_style = "display:none;";
1305 ellipsis = "…";
1306 }
1307
1308 var catctr_class = (cat_unread > 0) ? "catCtrHasUnread" : "catCtrNoUnread";
1309
1310 var browse_cat_link = "";
1311 var inner_title_class = "catTitleNL";
1312
1313 if (can_browse) {
046a2e3c 1314 browse_cat_link = "onclick=\"javascript:viewCategory("+cat_id+")\"";
d6416405
AD
1315 inner_title_class = "catTitle";
1316 }
1317
1318 var cat_class = "feedCat";
1319
1320 tmp += "<li class=\""+cat_class+"\" id=\"FCAT-"+cat_id+"\">"+
1321 "<img onclick=\"toggleCollapseCat("+cat_id+")\" class=\"catCollapse\""+
1322 " title=\""+__('Click to collapse category')+"\""+
1323 " src=\"images/cat-collapse.png\"><span class=\""+inner_title_class+"\" "+
1324 " id=\"FCATN-"+cat_id+"\" "+browse_cat_link+
1325 "\">"+tmp_category+"</span>";
1326
1327 tmp += "<span id=\"FCAP-"+cat_id+"\">";
1328
1329 tmp += " <span id=\"FCATCTR-"+cat_id+"\" "+
1330 "class=\""+catctr_class+"\">("+cat_unread+")</span> "+ellipsis;
1331
1332 tmp += "</span>";
1333
1334 tmp += "<ul class=\"feedCatList\" id=\"FCATLIST-"+cat_id+"\" "+
1335 "style='"+holder_style+"'>";
1336
1337 return tmp;
1338 } catch (e) {
1339 exception_error("printCategoryHeader", e);
1340 }
1341}
1342
c2726c96
AD
1343function is_local_cat_collapsed(id) {
1344 try {
1345
1346 var rs = db.execute("SELECT collapsed FROM categories WHERE id = ?", [id]);
1347 var cat_hidden = 0;
1348
1349 if (rs.isValidRow()) {
1350 cat_hidden = rs.field(0);
1351 }
1352
1353 rs.close();
1354
1355 return cat_hidden == "1";
1356
1357 } catch (e) {
1358 exception_error("is_local_cat_collapsed", e);
1359 }
1360}
1361
6da82466
AD
1362function get_local_article_labels(id) {
1363 try {
1364 var rs = db.execute("SELECT DISTINCT label_id,caption,fg_color,bg_color "+
1365 "FROM labels, article_labels "+
1366 "WHERE labels.id = label_id AND article_labels.id = ?", [id]);
1367
1368 var tmp = new Array();
1369
1370 while (rs.isValidRow()) {
1371 var e = new Array();
1372
1373 e[0] = rs.field(0);
1374 e[1] = rs.field(1);
1375 e[2] = rs.field(2);
1376 e[3] = rs.field(3);
1377
1378 tmp.push(e);
1379
1380 rs.next();
1381 }
1382
1383 return tmp;
1384
1385 } catch (e) {
1386 exception_error("get_local_article_labels", e);
1387 }
1388}
1389
c2726c96
AD
1390function label_local_add_article(id, label_id) {
1391 try {
5b880817 1392 //debug("label_local_add_article " + id + " => " + label_id);
c2726c96
AD
1393
1394 var rs = db.execute("SELECT COUNT(id) FROM article_labels WHERE "+
1395 "id = ? AND label_id = ?", [id, label_id]);
1396 var check = rs.field(0);
1397
1398 if (rs.isValidRow()) {
1399 var check = rs.field(0);
1400 }
1401 rs.close();
1402
1403 if (check == 0) {
1404 db.execute("INSERT INTO article_labels (id, label_id) VALUES "+
1405 "(?,?)", [id, label_id]);
1406 }
1407
1408 } catch (e) {
1409 exception_error("label_local_add_article", e);
1410 }
1411}
88a66534
AD
1412
1413function get_local_feed_title(id) {
1414 try {
1415
1416 var feed_title = "Unknown feed: " + id;
1417
1418 if (id > 0) {
1419 var rs = db.execute("SELECT title FROM feeds WHERE id = ?", [id]);
1420
1421 if (rs.isValidRow()) {
1422 feed_title = rs.field(0);
1423 }
1424
1425 rs.close();
1426 } else if (id == -1) {
1427 feed_title = __("Starred articles");
1428 } else if (id == -4) {
1429 feed_title = __("All articles");
1430 } else if (id < -10) {
1431
1432 var label_id = -11 - id;
1433
1434 var rs = db.execute("SELECT caption FROM labels WHERE id = ?", [label_id]);
1435
1436 if (rs.isValidRow()) {
1437 feed_title = rs.field(0);
1438 }
1439
1440 rs.close();
1441 }
1442
1443 return feed_title;
1444
1445 } catch (e) {
1446 exception_error("get_local_feed_title", e);
1447 }
1448}
6da82466
AD
1449
1450function format_article_labels(labels, id) {
1451 try {
1452
1453 var labels_str = "";
1454
1455 if (!labels) return "";
1456
1457 for (var i = 0; i < labels.length; i++) {
1458 var l = labels[i];
1459
1460 labels_str += "<span class='hlLabelRef' "+
1461 "style='color : "+l[2]+"; background-color : "+l[3]+"'>"+l[1]+"</span>";
1462 }
1463
1464 return labels_str;
1465
1466 } catch (e) {
1467 exception_error("format_article_labels", e);
1468 }
1469}
1470
6b684299
AD
1471function init_local_sync_data() {
1472 try {
23e2fb84
AD
1473
1474 if (!db) return;
1475
6b684299
AD
1476 var rs = db.execute("SELECT COUNT(*) FROM syncdata WHERE key = 'last_online'");
1477 var has_last_online = 0;
1478
1479 if (rs.isValidRow()) {
1480 has_last_online = rs.field(0);
1481 }
1482
1483 rs.close();
1484
1485 if (!has_last_online) {
1486 db.execute("INSERT INTO syncdata (key, value) VALUES ('last_online', '')");
1487 }
1488
1489 } catch (e) {
1490 exception_error("init_local_sync_data", e);
1491
1492 }
1493}
1494
badac687
AD
1495function has_local_sync_data() {
1496 try {
1497
1498 var rs = db.execute("SELECT id FROM articles "+
1499 "WHERE modified > (SELECT value FROM syncdata WHERE key = 'last_online') "+
1500 "LIMIT 1");
1501
1502 var tmp = 0;
1503
1504 if (rs.isValidRow()) {
1505 tmp = rs.field(0);
1506 }
1507
1508 rs.close();
1509
1510 return tmp != 0;
1511
1512 } catch (e) {
1513 exception_error("has_local_sync_data", e);
1514 }
1515}
1516
1517function prepare_local_sync_data() {
1518 try {
1519 var rs = db.execute("SELECT value FROM syncdata WHERE key = 'last_online'");
1520
1521 var last_online = "";
1522
1523 if (rs.isValidRow()) {
1524 last_online = rs.field(0);
1525 }
1526
1527 rs.close();
1528
1529 var rs = db.execute("SELECT id,unread,marked FROM articles "+
1530 "WHERE modified > ? LIMIT 200", [last_online]);
1531
1532 var tmp = last_online + ";";
1533
1534 var entries = 0;
1535
1536 while (rs.isValidRow()) {
1537 var e = new Array();
1538
1539 tmp = tmp + rs.field(0) + "," + rs.field(1) + "," + rs.field(2) + ";";
1540 entries++;
1541
1542 rs.next();
1543 }
1544
1545 rs.close();
1546
1547 if (entries > 0) {
1548 return tmp;
1549 } else {
1550 return '';
1551 }
1552
1553 } catch (e) {
1554 exception_error("prepare_local_sync_data", e);
1555 }
1556}
1557
6b684299
AD
1558function update_local_sync_data() {
1559 try {
1560 if (db && !offline_mode) {
badac687
AD
1561
1562 var rs = db.execute("SELECT id FROM articles "+
1563 "WHERE modified > (SELECT value FROM syncdata WHERE "+
1564 "key = 'last_online') LIMIT 1")
1565
1566 var f_id = 0;
1567
1568 if (rs.isValidRow()) {
1569 f_id = rs.field(0);
1570 }
1571
1572 rs.close();
1573
1574 /* no pending articles to sync */
1575
1576 if (f_id == 0) {
1577 db.execute("UPDATE syncdata SET value = DATETIME('NOW', 'localtime') "+
1578 "WHERE key = 'last_online'");
1579 }
6b684299
AD
1580
1581 }
1582 } catch (e) {
1583 exception_error("update_local_sync_data", e);
1584 }
1585}
67625745
AD
1586
1587function catchup_local_feed(id, is_cat) {
1588 try {
6161d5cc
AD
1589 if (!db) return;
1590
67625745
AD
1591 if (!is_cat) {
1592 if (id >= 0) {
1593 db.execute("UPDATE articles SET unread = 0 WHERE feed_id = ?", [id]);
1594 } else if (id == -1) {
1595 db.execute("UPDATE articles SET unread = 0 WHERE marked = 1");
1596 } else if (id == -4) {
1597 db.execute("UPDATE articles SET unread = 0");
1598 } else if (id < -10) {
1599 var label_id = -11-id;
1600
1601 db.execute("UPDATE articles SET unread = 0 WHERE "+
1602 "(SELECT COUNT(*) FROM article_labels WHERE "+
1603 "article_labels.id = articles.id AND label_id = ?) > 0", [label_id]);
1604 }
1605 }
1606
1607 update_local_feedlist_counters();
1608
1609 } catch (e) {
1610 exception_error("catchup_local_feed", e);
1611 }
1612}
79e565a9
AD
1613
1614function toggleOfflineModeInfo() {
1615 try {
1616 var e = $('offlineModeDrop');
1617 var p = $('offlineModePic');
1618
1619 if (Element.visible(e)) {
1620 Element.hide(e);
1621 } else {
1622 Element.show(e);
1623 }
1624
1625 } catch (e) {
1626 exception_error("toggleOfflineModeInfo", e);
1627 }
1628}
1629
65c0779b 1630function offlineDownloadStart(stage) {
79e565a9 1631 try {
65c0779b
AD
1632 if (!stage) stage = 0;
1633
79e565a9 1634 if (db && !sync_in_progress && getInitParam("offline_enabled") == "1") {
65c0779b 1635 window.setTimeout("update_offline_data("+stage+")", 100);
79e565a9
AD
1636 }
1637 } catch (e) {
1638 exception_error("offlineDownloadStart", e);
1639 }
1640}
1641
206d4967
AD
1642function offlineDownloadStop() {
1643 try {
1644 if (db && sync_in_progress && getInitParam("offline_enabled") == "1") {
8ca1a0ac
AD
1645
1646 sync_in_progress = false;
1647
1648 if (sync_timer) {
1649 window.clearTimeout(sync_timer);
1650 sync_timer = false;
1651 }
1652
1653 var pic = $("offlineModePic");
1654
1655 if (pic) {
1656 pic.src = "images/offline.png";
1657 var msg = __("Last sync: Cancelled.");
1658 articles_synced = 0;
1659 $("offlineModeSyncMsg").innerHTML = msg;
1660 }
1661
1662 offlineSyncShowHideElems(false);
1663
206d4967
AD
1664 }
1665 } catch (e) {
1666 exception_error("offlineDownloadStart", e);
1667 }
1668}
1669
79e565a9
AD
1670function offlineClearData() {
1671 try {
1672 if (db) {
1673
b4dc02e2 1674 if (confirm(__("This will remove all offline data stored by Tiny Tiny RSS on this computer. Continue?"))) {
79e565a9
AD
1675
1676 notify_progress("Removing offline data...");
1677
b4dc02e2
AD
1678 localServer.removeManagedStore("tt-rss");
1679
79e565a9
AD
1680 db.execute("DELETE FROM articles");
1681 db.execute("DELETE FROM article_labels");
1682 db.execute("DELETE FROM labels");
1683 db.execute("DELETE FROM feeds");
8ca1a0ac 1684 db.execute("DELETE FROM cache");
79e565a9 1685
8ca1a0ac 1686 notify_info("Local data removed.");
79e565a9
AD
1687 }
1688 }
1689 } catch (e) {
1690 exception_error("offlineClearData", e);
1691 }
1692}
206d4967
AD
1693
1694function offlineUpdateStore() {
1695 try {
9ca945a6 1696 if (offline_mode || !store) return;
206d4967 1697
9ca945a6
AD
1698 store.checkForUpdate();
1699
1700 var timerId = window.setInterval(function() {
1701 if (store.currentVersion) {
1702 window.clearInterval(timerId);
1703 debug("[Local store] sync complete: " + store.currentVersion);
1704 } else if (store.updateStatus == 3) {
1705 debug("[Local store] sync error: " + store.lastErrorMessage);
1706 } }, 500);
206d4967
AD
1707
1708 } catch (e) {
1709 exception_error("offlineUpdateStore", e);
1710 }
1711}
8ca1a0ac
AD
1712
1713function offlineSyncShowHideElems(syncing) {
1714 try {
1715
1716 var elems = $$("div.hideWhenSyncing");
1717
1718 for (var j = 0; j < elems.length; j++) {
1719 if (syncing) {
1720 Element.hide(elems[j]);
1721 } else {
1722 Element.show(elems[j]);
1723 }
1724 }
1725
1726 var elems = $$("div.showWhenSyncing");
1727
1728 for (var j = 0; j < elems.length; j++) {
1729 if (syncing) {
1730 Element.show(elems[j]);
1731 } else {
1732 Element.hide(elems[j]);
1733 }
1734 }
1735
1736 } catch (e) {
1737 exception_error("offlineSyncShowHideElems", e);
1738 }
1739}
9ca945a6
AD
1740
1741function offlineConfirmModeChange() {
1742 try {
1743
a8caa4c7 1744 if (db && getInitParam("offline_enabled") == "1" && offlineArticlesStored() > 0) {
9ca945a6
AD
1745 var ok = confirm(__("Tiny Tiny RSS has trouble accessing its server. Would you like to go offline?"));
1746
1747 if (ok) {
1748 init_offline();
1749 }
1750 }
1751
1752 } catch (e) {
1753 exception_error("offlineConfirmModeChange", e);
1754 }
1755}