]>
git.wh0rd.org - tt-rss.git/blob - offline.js
1 var SCHEMA_VERSION
= 4;
3 var offline_mode
= false;
5 var localServer
= false;
8 function view_offline(id
, feed_id
) {
12 showArticleInHeadlines(id
);
14 db
.execute("UPDATE articles SET unread = 0 WHERE id = ?", [id
]);
16 var rs
= db
.execute("SELECT * FROM articles WHERE id = ?", [id
]);
18 if (rs
.isValidRow()) {
20 var tmp
= "<div class=\"postReply\">";
22 tmp
+= "<div class=\"postHeader\" onmouseover=\"enable_resize(true)\" "+
23 "onmouseout=\"enable_resize(false)\">";
25 tmp
+= "<div class=\"postDate\">"+rs
.fieldByName("updated")+"</div>";
27 if (rs
.fieldByName("link") != "") {
28 tmp
+= "<div clear='both'><a target=\"_blank\" "+
29 "href=\"" + rs
.fieldByName("link") + "\">" +
30 rs
.fieldByName("title") + "</a></div>";
32 tmp
+= "<div clear='both'>" + rs
.fieldByName("title") + "</div>";
35 /* tmp += "<div style='float : right'> "+
36 "<img src='images/tag.png' class='tagsPic' alt='Tags' title='Tags'>";
37 tmp += rs.fieldByName("tags");
40 tmp += "<div clear='both'>"+
41 "<a target=\"_blank\" "+
42 "href=\"" + rs.fieldByName("comments") + "\">" +
43 __("comments") + "</a></div>";
47 tmp += "<div class=\"postContent\">"
48 tmp += rs.fieldByName("content");
54 update_local_feedlist_counters();
62 exception_error("view_offline", e);
66 function viewfeed_offline(feed_id, subop, is_cat, subop_param, skip_history, offset) {
70 if (!offset) offset = 0;
73 _feed_cur_page = parseInt(offset);
74 if (_infscroll_request_sent) {
79 _infscroll_disable = 0;
82 if (getActiveFeedId() != feed_id) {
85 _infscroll_disable = 0;
88 loading_set_progress(100);
90 clean_feed_selections();
92 setActiveFeedId(feed_id, is_cat);
95 var feedr = document.getElementById("FEEDR-" + feed_id);
96 if (feedr && !feedr.className.match("Selected")) {
97 feedr.className = feedr.className + "Selected";
100 var feedr = document.getElementById("FCAT-" + feed_id);
101 if (feedr && !feedr.className.match("Selected")) {
102 feedr.className = feedr.className + "Selected";
106 disableContainerChildren("headlinesToolbar", false);
107 Form.enable("main_toolbar_form");
109 var f = document.getElementById("headlines-frame");
111 if (reply.offset == 0) {
112 debug("resetting headlines scrollTop");
120 rs = db.execute("SELECT title FROM feeds WHERE id = ?", [feed_id]);
122 if (rs.isValidRow() || feed_id == -1 || feed_id == -4) {
124 feed_title = rs.field(0);
127 feed_title = __("Starred articles");
131 feed_title = __("All articles");
135 tmp += "<div id=\"headlinesContainer\">";
137 tmp += "<div class=\"headlinesSubToolbar\">";
138 tmp += "<div id=\"subtoolbar_ftitle\">";
147 if (document.getElementById("content-frame")) {
148 sel_all_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', true, '', true)";
149 sel_unread_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', true, 'Unread', true)";
150 sel_none_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', false)";
151 sel_inv_link = "javascript:invertHeadlineSelection()";
153 sel_all_link = "javascript:cdmSelectArticles('all')";
154 sel_unread_link = "javascript:cdmSelectArticles('unread')";
155 sel_none_link = "javascript:cdmSelectArticles('none')";
156 sel_inv_link = "javascript:invertHeadlineSelection()";
159 tmp += __('Select:')+
160 " <a href=\""+sel_all_link+"\">"+__('All')+"</a>, "+
161 "<a href=\""+sel_unread_link+"\">"+__('Unread')+"</a>, "+
162 "<a href=\""+sel_inv_link+"\">"+__('Invert')+"</a>, "+
163 "<a href=\""+sel_none_link+"\">"+__('None')+"</a>";
165 tmp += " ";
169 tmp += "<div id=\"headlinesInnerContainer\" onscroll=\"headlines_scroll_handler()\">";
170 if (document.getElementById("content-frame")) {
171 tmp += "<table class=\"headlinesList\" id=\"headlinesList\" cellspacing=\"0\">";
178 var toolbar_form = document.forms["main_toolbar_form"];
180 var limit = toolbar_form.limit[toolbar_form.limit.selectedIndex].value;
181 var view_mode = toolbar_form.view_mode[toolbar_form.view_mode.selectedIndex].value;
183 var limit_qpart = "";
184 var strategy_qpart = "";
186 var offset_qpart = "";
189 limit_qpart = "LIMIT " + limit;
192 if (view_mode == "all_articles") {
194 } else if (view_mode == "adaptive") {
195 if (get_local_feed_unread(feed_id) > 0) {
196 mode_qpart = "unread = 1";
200 } else if (view_mode == "marked") {
201 mode_qpart = "marked = 1";
202 } else if (view_mode == "unread") {
203 mode_qpart = "unread = 1";
209 strategy_qpart = "feed_id = " + feed_id;
210 } else if (feed_id == -1) {
211 strategy_qpart = "marked = 1";
212 } else if (feed_id == -4) {
213 strategy_qpart = "1";
217 offset_qpart = "OFFSET " + (offset*30);
222 var query = "SELECT *,feeds.title AS feed_title "+
223 "FROM articles,feeds WHERE " +
224 "feed_id = feeds.id AND " +
226 " AND " + mode_qpart +
227 " ORDER BY updated DESC "+
231 var rs = db.execute(query);
233 var line_num = offset*30;
235 var real_feed_id = feed_id;
237 while (rs.isValidRow()) {
239 var id = rs.fieldByName("id");
240 var feed_id = rs.fieldByName("feed_id");
242 var entry_feed_title = false;
244 if (real_feed_id < 0) {
245 entry_feed_title = rs.fieldByName("feed_title");
250 var row_class = (line_num % 2) ? "even" : "odd";
252 if (rs.fieldByName("unread") == "1") {
253 row_class += "Unread";
256 if (rs.fieldByName("marked") == "1") {
257 marked_pic = "<img id=\"FMPIC-"+id+"\" "+
258 "src=\"images/mark_set.png\" class=\"markedPic\""+
259 "alt=\"Unstar article\" onclick='javascript:tMark("+id+")'>";
261 marked_pic = "<img id=\"FMPIC-"+id+"\" "+
262 "src=\"images/mark_unset.png\" class=\"markedPic\""+
263 "alt=\"Star article\" onclick='javascript:tMark("+id+")'>";
266 var mouseover_attrs = "onmouseover='postMouseIn($id)' "+
267 "onmouseout='postMouseOut($id)'";
269 var content_preview = truncate_string(strip_tags(rs.fieldByName("content")),
272 if (document.getElementById("content-frame")) {
274 tmp += "<tr class='"+row_class+"' id='RROW-"+id+"' "+mouseover_attrs+">";
276 tmp += "<td class='hlUpdPic'> </td>";
278 tmp += "<td class='hlSelectRow'>"+
279 "<input type=\"checkbox\" onclick=\"tSR(this)\" id=\"RCHK-"+id+"\"></td>";
281 tmp += "<td class='hlMarkedPic'>"+marked_pic+"</td>";
283 tmp += "<td onclick='view("+id+","+feed_id+")' "+
284 "class='hlContent' valign='middle'>";
286 tmp += "<a target=\"_blank\" id=\"RTITLE-"+id+"\" href=\"" +
287 rs.fieldByName("link") + "\"" +
288 "onclick=\"return view("+id+","+feed_id+");\">"+
289 rs.fieldByName("title");
291 tmp += "<span class=\"contentPreview\"> - "+content_preview+"</span>";
295 if (entry_feed_title) {
296 tmp += " <span class=\"hlFeed\">"+
297 "(<a href='javascript:viewfeed("+feed_id+
298 ")'>"+entry_feed_title+"</a>)</span>";
303 tmp += "<td class=\"hlUpdated\" onclick='view("+id+","+feed_id+")'>"+
304 "<nobr>"+rs.fieldByName("updated").substring(0,16)+
312 if (rs.fieldByName("unread") == "1") {
313 add_class = "Unread";
316 tmp += "<div class=\"cdmArticle"+add_class+"\" id=\"RROW-"+id+"\" "+
317 mouseover_attrs+"'>";
319 feed_icon_img = "<img class=\"tinyFeedIcon\" src=\""+
320 getInitParam("icons_url")+"/"+feed_id+".ico\" alt=\"\">";
321 cdm_feed_icon = "<span style=\"cursor : pointer\" "+
322 "onclick=\"viewfeed("+feed_id+")\">"+feed_icon_img+"</span>";
324 tmp += "<div class=\"cdmHeader\">";
325 tmp += "<div class=\"articleUpdated\">"+
326 rs.fieldByName("updated").substring(0,16)+
327 " "+cdm_feed_icon+"</div>";
329 tmp += "<span id=\"RTITLE-"+id+"\" class=\"titleWrap\">"+
330 "<a class=\"title\" onclick=\"javascript:toggleUnread("+id+", 0)\""+
331 "target=\"_blank\" href=\""+rs.fieldByName("link")+
332 "\">"+rs.fieldByName("title")+"</a>";
334 if (entry_feed_title) {
335 tmp += " (<a href='javascript:viewfeed("+feed_id+
336 ")'>"+entry_feed_title+"</a>)";
339 tmp += "</span></div>";
341 tmp += "<div class=\"cdmContent\" onclick=\"cdmClicked("+id+")\""+
342 "id=\"CICD-"+id+"\">";
343 tmp += rs.fieldByName("content");
344 tmp += "<br clear='both'>"
347 tmp += "<div class=\"cdmFooter\"><span class='s0'>";
348 tmp += __("Select:")+
349 " <input type=\"checkbox\" "+
350 "onclick=\"toggleSelectRowById(this, 'RROW-"+id+"')\" "+
351 "class=\"feedCheckBox\" id=\"RCHK-"+id+"\">";
353 tmp += "</span><span class='s1'>"+marked_pic+"</span> ";
355 /* tmp += "<span class='s1'>"+
356 "<img class='tagsPic' src='images/tag.png' alt='Tags' title='Tags'>"+
357 "<span id=\"ATSTR-"+id+"\">"+rs.fieldByName("tags")+"</span>"+
360 tmp += "<span class='s2'>Toggle: <a class=\"cdmToggleLink\""+
361 "href=\"javascript:toggleUnread("+id+")\">"+
372 if (line_num - offset*30 < 30) {
373 _infscroll_disable = 1;
381 if (line_num - offset*30 == 0) {
382 tmp += "<div class='whiteBox'>" +
383 __("No articles found to display.") +
386 tmp += "</div></div>";
390 var container = document.getElementById("headlines-frame");
391 container.innerHTML = tmp;
393 var ids = getSelectedArticleIds2();
395 var container = document.getElementById("headlinesList");
396 container.innerHTML = container.innerHTML + tmp;
398 for (var i = 0; i < ids.length; i++) {
399 markHeadline(ids[i]);
406 _infscroll_request_sent = 0;
409 exception_error("viewfeed_offline", e);
413 function render_offline_feedlist() {
415 var tmp = "<ul class=\"feedList\" id=\"feedList\">";
417 var unread = get_local_feed_unread(-4);
419 global_unread = unread;
422 tmp += printFeedEntry(-4, __("All articles"), "feed", unread,
425 var unread = get_local_feed_unread(-1);
427 tmp += printFeedEntry(-1, __("Starred articles"), "feed", unread,
428 "images/mark_set.png");
430 tmp += "<li><hr/></li>";
432 /* var rs = db.execute("SELECT feeds.id,feeds.title,has_icon,COUNT(articles.id) "+
433 "FROM feeds LEFT JOIN articles ON (feed_id = feeds.id) "+
434 "WHERE unread = 1 OR unread IS NULL GROUP BY feeds.id "+
435 "ORDER BY feeds.title"); */
437 var rs
= db
.execute("SELECT id,title,has_icon FROM feeds "+
440 while (rs
.isValidRow()) {
442 var id
= rs
.field(0);
443 var title
= rs
.field(1);
444 var has_icon
= rs
.field(2);
445 var unread
= get_local_feed_unread(id
);
450 icon
= "icons/" + id
+ ".ico";
456 var row_class
= "feed";
459 row_class
+= "Unread";
460 fctr_class
= "feedCtrHasUnread";
462 fctr_class
= "feedCtrNoUnread";
465 tmp
+= printFeedEntry(id
, title
, "feed", unread
, icon
);
474 render_feedlist(tmp
);
476 exception_error("render_offline_feedlist", e
);
480 function init_offline() {
484 Element
.hide("dispSwitchPrompt");
485 Element
.hide("feedBrowserPrompt");
487 Element
.hide("topLinksOnline");
488 Element
.show("topLinksOffline");
490 var tb_form
= document
.getElementById("main_toolbar_form");
491 Element
.hide(tb_form
.update
);
493 var chooser
= document
.getElementById("quickMenuChooser");
494 chooser
.disabled
= true;
496 var rs
= db
.execute("SELECT key, value FROM init_params");
498 while (rs
.isValidRow()) {
499 init_params
[rs
.field(0)] = rs
.field(1);
505 var rs
= db
.execute("SELECT COUNT(*) FROM feeds");
509 if (rs
.isValidRow()) {
510 num_feeds
= rs
.field(0);
515 if (num_feeds
== 0) {
518 __("Data for offline browsing has not been downloaded yet."));
521 render_offline_feedlist();
523 window
.setTimeout("viewfeed(-4)", 50);
526 exception_error("init_offline", e
);
530 function offline_download_parse(stage
, transport
) {
532 if (transport
.responseXML
) {
536 var feeds
= transport
.responseXML
.getElementsByTagName("feed");
538 if (feeds
.length
> 0) {
539 db
.execute("DELETE FROM feeds");
542 for (var i
= 0; i
< feeds
.length
; i
++) {
543 var id
= feeds
[i
].getAttribute("id");
544 var has_icon
= feeds
[i
].getAttribute("has_icon");
545 var title
= feeds
[i
].firstChild
.nodeValue
;
546 var cat_id
= feeds
[i
].getAttribute("cat_id");
548 db
.execute("INSERT INTO feeds (id,title,has_icon,cat_id)"+
550 [id
, title
, has_icon
, cat_id
]);
553 window
.setTimeout("update_offline_data("+(stage
+1)+")", 10*1000);
556 var articles
= transport
.responseXML
.getElementsByTagName("article");
558 var limit
= transport
.responseXML
.getElementsByTagName("limit")[0];
561 limit
= limit
.getAttribute("value");
566 var articles_found
= 0;
568 for (var i
= 0; i
< articles
.length
; i
++) {
569 var a
= eval("("+articles
[i
].firstChild
.nodeValue
+")");
573 var date
= new Date();
574 var ts
= Math
.round(date
.getTime() / 1000);
576 db
.execute("DELETE FROM articles WHERE id = ?", [a
.id
]);
577 db
.execute("INSERT INTO articles "+
578 "(id, feed_id, title, link, guid, updated, content, "+
579 "unread, marked, tags, added, comments) "+
580 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
581 [a
.id
, a
.feed_id
, a
.title
, a
.link
, a
.guid
, a
.updated
,
582 a
.content
, a
.unread
, a
.marked
, a
.tags
, ts
,
588 debug("downloaded articles: " + articles_found
+ " limit: " + limit
);
590 if (articles_found
>= limit
) {
591 window
.setTimeout("update_offline_data("+(stage
+1)+")", 10*1000);
592 debug("update_offline_data: done " + stage
);
594 window
.setTimeout("update_offline_data(0)", 1800*1000);
595 debug("update_offline_data: finished");
597 var date
= new Date();
598 var ts
= Math
.round(date
.getTime() / 1000);
600 db
.execute("DELETE FROM articles WHERE added < ? - 2592000", [ts
]);
609 exception_error("offline_download_parse", e
);
613 function update_offline_data(stage
) {
616 if (!stage
) stage
= 0;
617 if (offline_mode
) return;
619 debug("update_offline_data: stage " + stage
);
621 // notify_progress("Updating offline data... (" + stage +")", true);
623 var query
= "backend.php?op=rpc&subop=download&stage=" + stage
;
625 var rs
= db
.execute("SELECT MAX(id), MIN(id) FROM articles");
627 if (rs
.isValidRow() && rs
.field(0)) {
628 var offline_dl_max_id
= rs
.field(0);
629 var offline_dl_min_id
= rs
.field(1);
631 query
= query
+ "&cidt=" + offline_dl_max_id
;
632 query
= query
+ "&cidb=" + offline_dl_min_id
;
637 new Ajax
.Request(query
, {
638 onComplete: function(transport
) {
639 offline_download_parse(stage
, transport
);
643 exception_error("initiate_offline_download", e
);
647 function set_feedlist_counter(id
, ctr
) {
650 var feedctr
= document
.getElementById("FEEDCTR-" + id
);
651 var feedu
= document
.getElementById("FEEDU-" + id
);
652 var feedr
= document
.getElementById("FEEDR-" + id
);
654 if (feedctr
&& feedu
&& feedr
) {
656 var row_needs_hl
= (ctr
> 0 && ctr
> parseInt(feedu
.innerHTML
));
658 feedu
.innerHTML
= ctr
;
661 feedctr
.className
= "feedCtrHasUnread";
662 if (!feedr
.className
.match("Unread")) {
663 var is_selected
= feedr
.className
.match("Selected");
665 feedr
.className
= feedr
.className
.replace("Selected", "");
666 feedr
.className
= feedr
.className
.replace("Unread", "");
668 feedr
.className
= feedr
.className
+ "Unread";
671 feedr
.className
= feedr
.className
+ "Selected";
677 new Effect
.Highlight(feedr
, {duration
: 1, startcolor
: "#fff7d5",
678 queue
: { position
:'end', scope
: 'EFQ-' + id
, limit
: 1 } } );
681 feedctr
.className
= "feedCtrNoUnread";
682 feedr
.className
= feedr
.className
.replace("Unread", "");
687 exception_error("set_feedlist_counter", e
);
691 function update_local_feedlist_counters() {
693 if (!offline_mode
) return;
695 /* var rs = db.execute("SELECT feeds.id,COUNT(articles.id) "+
696 "FROM feeds LEFT JOIN articles ON (feed_id = feeds.id) "+
697 "WHERE unread = 1 OR unread IS NULL GROUP BY feeds.id "+
698 "ORDER BY feeds.title"); */
700 var rs
= db
.execute("SELECT id,title,has_icon FROM feeds "+
703 while (rs
.isValidRow()) {
704 var id
= rs
.field(0);
705 var ctr
= get_local_feed_unread(id
);
707 set_feedlist_counter(id
, ctr
);
714 set_feedlist_counter(-4, get_local_feed_unread(-4));
715 set_feedlist_counter(-1, get_local_feed_unread(-1));
717 hideOrShowFeeds(getInitParam("hide_read_feeds") == 1);
719 global_unread
= get_local_feed_unread(-4);
723 exception_error("update_local_feedlist_counters", e
);
727 function get_local_feed_unread(id
) {
732 rs
= db
.execute("SELECT SUM(unread) FROM articles");
733 } else if (id
== -1) {
734 rs
= db
.execute("SELECT SUM(unread) FROM articles WHERE marked = 1");
736 rs
= db
.execute("SELECT SUM(unread) FROM articles WHERE feed_id = ?", [id
]);
741 if (rs
.isValidRow()) {
752 exception_error("get_local_feed_unread", e
);
756 function init_gears() {
759 if (window
.google
&& google
.gears
) {
760 localServer
= google
.gears
.factory
.create("beta.localserver");
761 store
= localServer
.createManagedStore("tt-rss");
762 db
= google
.gears
.factory
.create('beta.database');
765 db
.execute("CREATE TABLE IF NOT EXISTS version (schema_version text)");
767 var rs
= db
.execute("SELECT schema_version FROM version");
771 if (rs
.isValidRow()) {
772 version
= rs
.field(0);
777 if (version
!= SCHEMA_VERSION
) {
778 db
.execute("DROP TABLE IF EXISTS init_params");
779 db
.execute("DROP TABLE IF EXISTS cache");
780 db
.execute("DROP TABLE IF EXISTS feeds");
781 db
.execute("DROP TABLE IF EXISTS categories");
782 db
.execute("DROP TABLE IF EXISTS articles");
783 db
.execute("DROP TABLE IF EXISTS version");
784 db
.execute("CREATE TABLE IF NOT EXISTS version (schema_version text)");
785 db
.execute("INSERT INTO version (schema_version) VALUES (?)",
789 db
.execute("CREATE TABLE IF NOT EXISTS init_params (key text, value text)");
791 db
.execute("CREATE TABLE IF NOT EXISTS cache (id text, article text, param text, added text)");
792 db
.execute("CREATE TABLE IF NOT EXISTS feeds (id integer, title text, has_icon integer, cat_id integer)");
793 db
.execute("CREATE TABLE IF NOT EXISTS categories (id integer, title text)");
794 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)");
796 db
.execute("DELETE FROM cache WHERE id LIKE 'F:%' OR id LIKE 'C:%'");
798 Element
.show("restartOfflinePic");
805 exception_error("init_gears", e
);
809 function gotoOffline() {
810 window
.location
.href
= "tt-rss.php?offline=1";
813 function gotoOnline() {
814 window
.location
.href
= "tt-rss.php";