]>
Commit | Line | Data |
---|---|---|
71af6d36 | 1 | var SCHEMA_VERSION = 10; |
b871dd06 | 2 | |
25d99353 AD |
3 | var offline_mode = false; |
4 | var store = false; | |
5 | var localServer = false; | |
6 | var db = false; | |
7 | ||
4681834e AD |
8 | function view_offline(id, feed_id) { |
9 | try { | |
10 | ||
11 | enableHotkeys(); | |
12 | showArticleInHeadlines(id); | |
13 | ||
1b27261c AD |
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 | } | |
4681834e | 34 | |
3ab18266 | 35 | /* tmp += "<div style='float : right'> "+ |
1b27261c AD |
36 | "<img src='images/tag.png' class='tagsPic' alt='Tags' title='Tags'>"; |
37 | tmp += rs.fieldByName("tags"); | |
3ab18266 | 38 | tmp += "</div>"; */ |
1b27261c | 39 | |
424fc145 | 40 | /* tmp += "<div clear='both'>"+ |
12aa4007 AD |
41 | "<a target=\"_blank\" "+ |
42 | "href=\"" + rs.fieldByName("comments") + "\">" + | |
424fc145 | 43 | __("comments") + "</a></div>"; */ |
1b27261c AD |
44 | |
45 | tmp += "</div>"; | |
46 | ||
47 | tmp += "<div class=\"postContent\">" | |
48 | tmp += rs.fieldByName("content"); | |
49 | tmp += "</div>"; | |
50 | ||
51 | tmp += "</div>"; | |
52 | ||
53 | render_article(tmp); | |
54 | update_local_feedlist_counters(); | |
55 | } | |
4681834e | 56 | |
03c96380 AD |
57 | rs.close(); |
58 | ||
4681834e AD |
59 | return false; |
60 | ||
61 | } catch (e) { | |
62 | exception_error("view_offline", e); | |
63 | } | |
64 | } | |
65 | ||
66 | function viewfeed_offline(feed_id, subop, is_cat, subop_param, skip_history, offset) { | |
67 | try { | |
68 | notify(''); | |
69 | ||
70 | if (!offset) offset = 0; | |
71 | ||
0e923da4 AD |
72 | if (offset > 0) { |
73 | _feed_cur_page = parseInt(offset); | |
74 | if (_infscroll_request_sent) { | |
75 | return; | |
76 | } | |
77 | } else { | |
78 | _feed_cur_page = 0; | |
79 | _infscroll_disable = 0; | |
80 | } | |
81 | ||
82 | if (getActiveFeedId() != feed_id) { | |
83 | _feed_cur_page = 0; | |
84 | active_post_id = 0; | |
85 | _infscroll_disable = 0; | |
86 | } | |
87 | ||
4681834e AD |
88 | loading_set_progress(100); |
89 | ||
90 | clean_feed_selections(); | |
91 | ||
92 | setActiveFeedId(feed_id, is_cat); | |
93 | ||
94 | if (!is_cat) { | |
95 | var feedr = document.getElementById("FEEDR-" + feed_id); | |
96 | if (feedr && !feedr.className.match("Selected")) { | |
97 | feedr.className = feedr.className + "Selected"; | |
98 | } | |
99 | } else { | |
100 | var feedr = document.getElementById("FCAT-" + feed_id); | |
101 | if (feedr && !feedr.className.match("Selected")) { | |
102 | feedr.className = feedr.className + "Selected"; | |
103 | } | |
104 | } | |
105 | ||
67625745 AD |
106 | if (subop == "MarkAllRead") { |
107 | catchup_local_feed(feed_id, is_cat); | |
108 | } | |
109 | ||
4681834e AD |
110 | disableContainerChildren("headlinesToolbar", false); |
111 | Form.enable("main_toolbar_form"); | |
112 | ||
113 | var f = document.getElementById("headlines-frame"); | |
114 | try { | |
115 | if (reply.offset == 0) { | |
116 | debug("resetting headlines scrollTop"); | |
117 | f.scrollTop = 0; | |
118 | } | |
119 | } catch (e) { }; | |
120 | ||
121 | ||
4681834e AD |
122 | var tmp = ""; |
123 | ||
88a66534 | 124 | var feed_title = get_local_feed_title(feed_id); |
4681834e | 125 | |
88a66534 | 126 | if (feed_title) { |
4681834e AD |
127 | |
128 | if (offset == 0) { | |
129 | tmp += "<div id=\"headlinesContainer\">"; | |
130 | ||
131 | tmp += "<div class=\"headlinesSubToolbar\">"; | |
132 | tmp += "<div id=\"subtoolbar_ftitle\">"; | |
133 | tmp += feed_title; | |
134 | tmp += "</div>"; | |
135 | ||
779ba075 AD |
136 | var sel_all_link; |
137 | var sel_unread_link; | |
138 | var sel_none_link; | |
139 | var sel_inv_link; | |
140 | ||
141 | if (document.getElementById("content-frame")) { | |
142 | sel_all_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', true, '', true)"; | |
143 | sel_unread_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', true, 'Unread', true)"; | |
144 | sel_none_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', false)"; | |
145 | sel_inv_link = "javascript:invertHeadlineSelection()"; | |
146 | } else { | |
147 | sel_all_link = "javascript:cdmSelectArticles('all')"; | |
148 | sel_unread_link = "javascript:cdmSelectArticles('unread')"; | |
149 | sel_none_link = "javascript:cdmSelectArticles('none')"; | |
150 | sel_inv_link = "javascript:invertHeadlineSelection()"; | |
151 | } | |
4681834e AD |
152 | |
153 | tmp += __('Select:')+ | |
154 | " <a href=\""+sel_all_link+"\">"+__('All')+"</a>, "+ | |
155 | "<a href=\""+sel_unread_link+"\">"+__('Unread')+"</a>, "+ | |
156 | "<a href=\""+sel_inv_link+"\">"+__('Invert')+"</a>, "+ | |
157 | "<a href=\""+sel_none_link+"\">"+__('None')+"</a>"; | |
158 | ||
159 | tmp += " "; | |
160 | ||
161 | tmp += "</div>"; | |
162 | ||
163 | tmp += "<div id=\"headlinesInnerContainer\" onscroll=\"headlines_scroll_handler()\">"; | |
779ba075 AD |
164 | if (document.getElementById("content-frame")) { |
165 | tmp += "<table class=\"headlinesList\" id=\"headlinesList\" cellspacing=\"0\">"; | |
166 | } | |
4681834e AD |
167 | |
168 | } | |
169 | ||
4681834e AD |
170 | var limit = 30; |
171 | ||
172 | var toolbar_form = document.forms["main_toolbar_form"]; | |
173 | ||
174 | var limit = toolbar_form.limit[toolbar_form.limit.selectedIndex].value; | |
175 | var view_mode = toolbar_form.view_mode[toolbar_form.view_mode.selectedIndex].value; | |
176 | ||
177 | var limit_qpart = ""; | |
178 | var strategy_qpart = ""; | |
179 | var mode_qpart = ""; | |
e491d06d | 180 | var offset_qpart = ""; |
4681834e AD |
181 | |
182 | if (limit != 0) { | |
183 | limit_qpart = "LIMIT " + limit; | |
184 | } | |
185 | ||
186 | if (view_mode == "all_articles") { | |
187 | mode_qpart = "1"; | |
188 | } else if (view_mode == "adaptive") { | |
189 | if (get_local_feed_unread(feed_id) > 0) { | |
190 | mode_qpart = "unread = 1"; | |
191 | } else { | |
192 | mode_qpart = "1"; | |
193 | } | |
194 | } else if (view_mode == "marked") { | |
195 | mode_qpart = "marked = 1"; | |
196 | } else if (view_mode == "unread") { | |
197 | mode_qpart = "unread = 1"; | |
198 | } else { | |
199 | mode_qpart = "1"; | |
200 | } | |
201 | ||
79645416 AD |
202 | var ext_tables_qpart = ""; |
203 | ||
4681834e AD |
204 | if (feed_id > 0) { |
205 | strategy_qpart = "feed_id = " + feed_id; | |
206 | } else if (feed_id == -1) { | |
207 | strategy_qpart = "marked = 1"; | |
208 | } else if (feed_id == -4) { | |
209 | strategy_qpart = "1"; | |
88a66534 AD |
210 | } else if (feed_id < -10) { |
211 | var label_id = -11 - feed_id; | |
79645416 AD |
212 | strategy_qpart = "article_labels.id = articles.id AND label_id = " + label_id; |
213 | ext_tables_qpart = ",article_labels"; | |
e491d06d AD |
214 | } |
215 | ||
216 | if (offset > 0) { | |
217 | offset_qpart = "OFFSET " + (offset*30); | |
218 | } else { | |
219 | offset_qpart = ""; | |
220 | } | |
4681834e | 221 | |
851ce414 | 222 | var query = "SELECT *,feeds.title AS feed_title "+ |
79645416 AD |
223 | "FROM articles,feeds"+ext_tables_qpart+" "+ |
224 | "WHERE " + | |
851ce414 | 225 | "feed_id = feeds.id AND " + |
4681834e AD |
226 | strategy_qpart + |
227 | " AND " + mode_qpart + | |
228 | " ORDER BY updated DESC "+ | |
e491d06d AD |
229 | limit_qpart + " " + |
230 | offset_qpart; | |
4681834e AD |
231 | |
232 | var rs = db.execute(query); | |
233 | ||
e491d06d | 234 | var line_num = offset*30; |
4681834e | 235 | |
851ce414 AD |
236 | var real_feed_id = feed_id; |
237 | ||
4681834e AD |
238 | while (rs.isValidRow()) { |
239 | ||
240 | var id = rs.fieldByName("id"); | |
241 | var feed_id = rs.fieldByName("feed_id"); | |
242 | ||
851ce414 AD |
243 | var entry_feed_title = false; |
244 | ||
245 | if (real_feed_id < 0) { | |
246 | entry_feed_title = rs.fieldByName("feed_title"); | |
247 | } | |
248 | ||
4681834e AD |
249 | var marked_pic; |
250 | ||
251 | var row_class = (line_num % 2) ? "even" : "odd"; | |
252 | ||
253 | if (rs.fieldByName("unread") == "1") { | |
254 | row_class += "Unread"; | |
255 | } | |
6da82466 AD |
256 | |
257 | var labels = get_local_article_labels(id); | |
258 | ||
6da82466 AD |
259 | var labels_str = "<span id=\"HLLCTR-"+id+"\">"; |
260 | labels_str += format_article_labels(labels, id); | |
261 | labels_str += "</span>"; | |
262 | ||
4681834e AD |
263 | if (rs.fieldByName("marked") == "1") { |
264 | marked_pic = "<img id=\"FMPIC-"+id+"\" "+ | |
265 | "src=\"images/mark_set.png\" class=\"markedPic\""+ | |
266 | "alt=\"Unstar article\" onclick='javascript:tMark("+id+")'>"; | |
267 | } else { | |
268 | marked_pic = "<img id=\"FMPIC-"+id+"\" "+ | |
269 | "src=\"images/mark_unset.png\" class=\"markedPic\""+ | |
270 | "alt=\"Star article\" onclick='javascript:tMark("+id+")'>"; | |
271 | } | |
272 | ||
273 | var mouseover_attrs = "onmouseover='postMouseIn($id)' "+ | |
274 | "onmouseout='postMouseOut($id)'"; | |
779ba075 AD |
275 | |
276 | var content_preview = truncate_string(strip_tags(rs.fieldByName("content")), | |
277 | 100); | |
4681834e | 278 | |
779ba075 | 279 | if (document.getElementById("content-frame")) { |
4681834e | 280 | |
779ba075 AD |
281 | tmp += "<tr class='"+row_class+"' id='RROW-"+id+"' "+mouseover_attrs+">"; |
282 | ||
283 | tmp += "<td class='hlUpdPic'> </td>"; | |
4681834e | 284 | |
779ba075 AD |
285 | tmp += "<td class='hlSelectRow'>"+ |
286 | "<input type=\"checkbox\" onclick=\"tSR(this)\" id=\"RCHK-"+id+"\"></td>"; | |
287 | ||
288 | tmp += "<td class='hlMarkedPic'>"+marked_pic+"</td>"; | |
289 | ||
290 | tmp += "<td onclick='view("+id+","+feed_id+")' "+ | |
291 | "class='hlContent' valign='middle'>"; | |
292 | ||
851ce414 | 293 | tmp += "<a target=\"_blank\" id=\"RTITLE-"+id+"\" href=\"" + |
779ba075 AD |
294 | rs.fieldByName("link") + "\"" + |
295 | "onclick=\"return view("+id+","+feed_id+");\">"+ | |
296 | rs.fieldByName("title"); | |
4681834e | 297 | |
779ba075 AD |
298 | tmp += "<span class=\"contentPreview\"> - "+content_preview+"</span>"; |
299 | ||
300 | tmp += "</a>"; | |
851ce414 | 301 | |
6da82466 AD |
302 | tmp += labels_str; |
303 | ||
851ce414 AD |
304 | if (entry_feed_title) { |
305 | tmp += " <span class=\"hlFeed\">"+ | |
306 | "(<a href='javascript:viewfeed("+feed_id+ | |
307 | ")'>"+entry_feed_title+"</a>)</span>"; | |
308 | } | |
309 | ||
779ba075 | 310 | tmp += "</td>"; |
d07f08e8 | 311 | |
779ba075 | 312 | tmp += "<td class=\"hlUpdated\" onclick='view("+id+","+feed_id+")'>"+ |
d07f08e8 AD |
313 | "<nobr>"+rs.fieldByName("updated").substring(0,16)+ |
314 | "</nobr></td>"; | |
779ba075 AD |
315 | |
316 | tmp += "</tr>"; | |
317 | } else { | |
4681834e | 318 | |
779ba075 AD |
319 | var add_class = ""; |
320 | ||
321 | if (rs.fieldByName("unread") == "1") { | |
322 | add_class = "Unread"; | |
323 | } | |
324 | ||
325 | tmp += "<div class=\"cdmArticle"+add_class+"\" id=\"RROW-"+id+"\" "+ | |
326 | mouseover_attrs+"'>"; | |
327 | ||
d07f08e8 AD |
328 | feed_icon_img = "<img class=\"tinyFeedIcon\" src=\""+ |
329 | getInitParam("icons_url")+"/"+feed_id+".ico\" alt=\"\">"; | |
330 | cdm_feed_icon = "<span style=\"cursor : pointer\" "+ | |
331 | "onclick=\"viewfeed("+feed_id+")\">"+feed_icon_img+"</span>"; | |
332 | ||
779ba075 AD |
333 | tmp += "<div class=\"cdmHeader\">"; |
334 | tmp += "<div class=\"articleUpdated\">"+ | |
d07f08e8 AD |
335 | rs.fieldByName("updated").substring(0,16)+ |
336 | " "+cdm_feed_icon+"</div>"; | |
779ba075 AD |
337 | |
338 | tmp += "<span id=\"RTITLE-"+id+"\" class=\"titleWrap\">"+ | |
339 | "<a class=\"title\" onclick=\"javascript:toggleUnread("+id+", 0)\""+ | |
340 | "target=\"_blank\" href=\""+rs.fieldByName("link")+ | |
341 | "\">"+rs.fieldByName("title")+"</a>"; | |
851ce414 | 342 | |
6da82466 AD |
343 | tmp += labels_str; |
344 | ||
851ce414 AD |
345 | if (entry_feed_title) { |
346 | tmp += " (<a href='javascript:viewfeed("+feed_id+ | |
347 | ")'>"+entry_feed_title+"</a>)"; | |
348 | } | |
349 | ||
779ba075 AD |
350 | tmp += "</span></div>"; |
351 | ||
352 | tmp += "<div class=\"cdmContent\" onclick=\"cdmClicked("+id+")\""+ | |
353 | "id=\"CICD-"+id+"\">"; | |
354 | tmp += rs.fieldByName("content"); | |
355 | tmp += "<br clear='both'>" | |
356 | tmp += "</div>"; | |
357 | ||
358 | tmp += "<div class=\"cdmFooter\"><span class='s0'>"; | |
359 | tmp += __("Select:")+ | |
360 | " <input type=\"checkbox\" "+ | |
361 | "onclick=\"toggleSelectRowById(this, 'RROW-"+id+"')\" "+ | |
362 | "class=\"feedCheckBox\" id=\"RCHK-"+id+"\">"; | |
363 | ||
364 | tmp += "</span><span class='s1'>"+marked_pic+"</span> "; | |
365 | ||
3ab18266 | 366 | /* tmp += "<span class='s1'>"+ |
779ba075 AD |
367 | "<img class='tagsPic' src='images/tag.png' alt='Tags' title='Tags'>"+ |
368 | "<span id=\"ATSTR-"+id+"\">"+rs.fieldByName("tags")+"</span>"+ | |
3ab18266 | 369 | "</span>"; */ |
779ba075 AD |
370 | |
371 | tmp += "<span class='s2'>Toggle: <a class=\"cdmToggleLink\""+ | |
372 | "href=\"javascript:toggleUnread("+id+")\">"+ | |
373 | "Unread</a></span>"; | |
374 | tmp += "</div>"; | |
375 | ||
376 | tmp += "</div>"; | |
377 | } | |
4681834e AD |
378 | |
379 | rs.next(); | |
380 | line_num++; | |
381 | } | |
03c96380 | 382 | |
0e923da4 AD |
383 | if (line_num - offset*30 < 30) { |
384 | _infscroll_disable = 1; | |
385 | } | |
386 | ||
03c96380 | 387 | rs.close(); |
4681834e AD |
388 | |
389 | if (offset == 0) { | |
390 | tmp += "</table>"; | |
76d20f5f AD |
391 | |
392 | if (line_num - offset*30 == 0) { | |
393 | tmp += "<div class='whiteBox'>" + | |
394 | __("No articles found to display.") + | |
395 | "</div>"; | |
396 | } | |
4681834e AD |
397 | tmp += "</div></div>"; |
398 | } | |
399 | ||
400 | if (offset == 0) { | |
e491d06d | 401 | var container = document.getElementById("headlines-frame"); |
4681834e AD |
402 | container.innerHTML = tmp; |
403 | } else { | |
404 | var ids = getSelectedArticleIds2(); | |
405 | ||
e491d06d AD |
406 | var container = document.getElementById("headlinesList"); |
407 | container.innerHTML = container.innerHTML + tmp; | |
4681834e AD |
408 | |
409 | for (var i = 0; i < ids.length; i++) { | |
410 | markHeadline(ids[i]); | |
411 | } | |
412 | } | |
413 | } | |
414 | ||
415 | remove_splash(); | |
416 | ||
0e923da4 | 417 | _infscroll_request_sent = 0; |
4681834e AD |
418 | |
419 | } catch (e) { | |
420 | exception_error("viewfeed_offline", e); | |
421 | } | |
422 | } | |
423 | ||
424 | function render_offline_feedlist() { | |
425 | try { | |
1c980681 | 426 | var cats_enabled = getInitParam("enable_feed_cats") == "1"; |
d6416405 | 427 | |
4681834e AD |
428 | var tmp = "<ul class=\"feedList\" id=\"feedList\">"; |
429 | ||
430 | var unread = get_local_feed_unread(-4); | |
431 | ||
432 | global_unread = unread; | |
433 | updateTitle(); | |
434 | ||
d6416405 | 435 | if (cats_enabled) { |
c2726c96 | 436 | tmp += printCategoryHeader(-1, is_local_cat_collapsed(-1), false); |
d6416405 AD |
437 | } |
438 | ||
4681834e AD |
439 | tmp += printFeedEntry(-4, __("All articles"), "feed", unread, |
440 | "images/tag.png"); | |
441 | ||
442 | var unread = get_local_feed_unread(-1); | |
443 | ||
444 | tmp += printFeedEntry(-1, __("Starred articles"), "feed", unread, | |
445 | "images/mark_set.png"); | |
446 | ||
d6416405 AD |
447 | if (cats_enabled) { |
448 | tmp += "</ul></li>"; | |
449 | } else { | |
450 | tmp += "<li><hr/></li>"; | |
451 | } | |
4681834e | 452 | |
c2726c96 AD |
453 | if (cats_enabled) { |
454 | tmp += printCategoryHeader(-2, is_local_cat_collapsed(-2), false); | |
455 | } | |
456 | ||
457 | var rs = db.execute("SELECT id,caption "+ | |
458 | "FROM labels "+ | |
459 | "ORDER BY caption"); | |
460 | ||
461 | while (rs.isValidRow()) { | |
462 | var id = -11 - parseInt(rs.field(0)); | |
463 | var caption = rs.field(1); | |
464 | var unread = get_local_feed_unread(id); | |
465 | ||
466 | tmp += printFeedEntry(id, caption, "feed", unread, | |
467 | "images/label.png"); | |
468 | ||
469 | rs.next(); | |
470 | } | |
471 | ||
472 | rs.close(); | |
473 | ||
474 | if (cats_enabled) { | |
475 | tmp += "</ul></li>"; | |
476 | } else { | |
477 | tmp += "<li><hr/></li>"; | |
478 | } | |
479 | ||
f4c11347 | 480 | /* var rs = db.execute("SELECT feeds.id,feeds.title,has_icon,COUNT(articles.id) "+ |
4681834e AD |
481 | "FROM feeds LEFT JOIN articles ON (feed_id = feeds.id) "+ |
482 | "WHERE unread = 1 OR unread IS NULL GROUP BY feeds.id "+ | |
f4c11347 AD |
483 | "ORDER BY feeds.title"); */ |
484 | ||
d6416405 AD |
485 | var order_by = "feeds.title"; |
486 | ||
487 | if (cats_enabled) order_by = "categories.title," + order_by; | |
488 | ||
489 | var rs = db.execute("SELECT "+ | |
490 | "feeds.id,feeds.title,has_icon,cat_id,collapsed "+ | |
491 | "FROM feeds,categories WHERE cat_id = categories.id "+ | |
492 | "ORDER BY "+order_by); | |
493 | ||
494 | var tmp_cat_id = -1; | |
4681834e AD |
495 | |
496 | while (rs.isValidRow()) { | |
497 | ||
498 | var id = rs.field(0); | |
499 | var title = rs.field(1); | |
500 | var has_icon = rs.field(2); | |
f4c11347 | 501 | var unread = get_local_feed_unread(id); |
d6416405 AD |
502 | var cat_id = rs.field(3); |
503 | var cat_hidden = rs.field(4); | |
504 | ||
505 | if (cat_id != tmp_cat_id && cats_enabled) { | |
506 | if (tmp_cat_id != -1) { | |
507 | tmp += "</ul></li>"; | |
508 | } | |
509 | tmp += printCategoryHeader(cat_id, cat_hidden, false); | |
510 | tmp_cat_id = cat_id; | |
511 | } | |
4681834e AD |
512 | |
513 | var icon = ""; | |
514 | ||
515 | if (has_icon) { | |
516 | icon = "icons/" + id + ".ico"; | |
517 | } | |
518 | ||
4681834e AD |
519 | var feed_icon = ""; |
520 | ||
521 | var row_class = "feed"; | |
522 | ||
523 | if (unread > 0) { | |
524 | row_class += "Unread"; | |
525 | fctr_class = "feedCtrHasUnread"; | |
526 | } else { | |
527 | fctr_class = "feedCtrNoUnread"; | |
528 | } | |
529 | ||
530 | tmp += printFeedEntry(id, title, "feed", unread, icon); | |
531 | ||
532 | rs.next(); | |
533 | } | |
534 | ||
03c96380 AD |
535 | rs.close(); |
536 | ||
983a6a9c AD |
537 | if (cats_enabled) { |
538 | tmp += "</ul>"; | |
539 | } | |
540 | ||
4681834e AD |
541 | tmp += "</ul>"; |
542 | ||
543 | render_feedlist(tmp); | |
544 | } catch (e) { | |
545 | exception_error("render_offline_feedlist", e); | |
546 | } | |
547 | } | |
548 | ||
549 | function init_offline() { | |
550 | try { | |
551 | offline_mode = true; | |
552 | ||
553 | Element.hide("dispSwitchPrompt"); | |
554 | Element.hide("feedBrowserPrompt"); | |
4681834e | 555 | |
69ea0cdd AD |
556 | Element.hide("topLinksOnline"); |
557 | Element.show("topLinksOffline"); | |
558 | ||
80b1c238 | 559 | var tb_form = document.getElementById("main_toolbar_form"); |
80b1c238 AD |
560 | Element.hide(tb_form.update); |
561 | ||
3c6d3586 AD |
562 | var chooser = document.getElementById("quickMenuChooser"); |
563 | chooser.disabled = true; | |
564 | ||
3034277a AD |
565 | var rs = db.execute("SELECT key, value FROM init_params"); |
566 | ||
567 | while (rs.isValidRow()) { | |
568 | init_params[rs.field(0)] = rs.field(1); | |
569 | rs.next(); | |
570 | } | |
571 | ||
572 | rs.close(); | |
4681834e | 573 | |
b15e516e AD |
574 | var rs = db.execute("SELECT COUNT(*) FROM feeds"); |
575 | ||
576 | var num_feeds = 0; | |
577 | ||
578 | if (rs.isValidRow()) { | |
579 | num_feeds = rs.field(0); | |
580 | } | |
581 | ||
582 | rs.close(); | |
583 | ||
584 | if (num_feeds == 0) { | |
585 | remove_splash(); | |
586 | return fatalError(0, | |
587 | __("Data for offline browsing has not been downloaded yet.")); | |
588 | } | |
589 | ||
4681834e | 590 | render_offline_feedlist(); |
10003c4c | 591 | init_second_stage(); |
b15e516e AD |
592 | window.setTimeout("viewfeed(-4)", 50); |
593 | ||
4681834e AD |
594 | } catch (e) { |
595 | exception_error("init_offline", e); | |
596 | } | |
597 | } | |
598 | ||
599 | function offline_download_parse(stage, transport) { | |
600 | try { | |
601 | if (transport.responseXML) { | |
602 | ||
603 | if (stage == 0) { | |
604 | ||
605 | var feeds = transport.responseXML.getElementsByTagName("feed"); | |
606 | ||
607 | if (feeds.length > 0) { | |
608 | db.execute("DELETE FROM feeds"); | |
609 | } | |
610 | ||
611 | for (var i = 0; i < feeds.length; i++) { | |
612 | var id = feeds[i].getAttribute("id"); | |
613 | var has_icon = feeds[i].getAttribute("has_icon"); | |
614 | var title = feeds[i].firstChild.nodeValue; | |
d8781c91 AD |
615 | var cat_id = feeds[i].getAttribute("cat_id"); |
616 | ||
617 | db.execute("INSERT INTO feeds (id,title,has_icon,cat_id)"+ | |
75aa83ec | 618 | "VALUES (?,?,?,?)", |
d8781c91 | 619 | [id, title, has_icon, cat_id]); |
4681834e | 620 | } |
75aa83ec AD |
621 | |
622 | var cats = transport.responseXML.getElementsByTagName("category"); | |
623 | ||
624 | if (feeds.length > 0) { | |
625 | db.execute("DELETE FROM categories"); | |
626 | } | |
627 | ||
628 | for (var i = 0; i < cats.length; i++) { | |
629 | var id = cats[i].getAttribute("id"); | |
630 | var collapsed = cats[i].getAttribute("collapsed"); | |
631 | var title = cats[i].firstChild.nodeValue; | |
632 | ||
633 | db.execute("INSERT INTO categories (id,title,collapsed)"+ | |
634 | "VALUES (?,?,?)", | |
635 | [id, title, collapsed]); | |
636 | } | |
637 | ||
ed22888b AD |
638 | var labels = transport.responseXML.getElementsByTagName("label"); |
639 | ||
640 | if (labels.length > 0) { | |
641 | db.execute("DELETE FROM labels"); | |
642 | } | |
643 | ||
644 | for (var i = 0; i < labels.length; i++) { | |
645 | var id = labels[i].getAttribute("id"); | |
646 | var fg_color = labels[i].getAttribute("fg_color"); | |
647 | var bg_color = labels[i].getAttribute("bg_color"); | |
648 | var caption = labels[i].firstChild.nodeValue; | |
649 | ||
650 | db.execute("INSERT INTO labels (id,caption,fg_color,bg_color)"+ | |
651 | "VALUES (?,?,?,?)", | |
652 | [id, caption, fg_color, bg_color]); | |
653 | } | |
654 | ||
3e52ab08 | 655 | window.setTimeout("update_offline_data("+(stage+1)+")", 10*1000); |
4681834e AD |
656 | } else { |
657 | ||
658 | var articles = transport.responseXML.getElementsByTagName("article"); | |
659 | ||
3e52ab08 AD |
660 | var limit = transport.responseXML.getElementsByTagName("limit")[0]; |
661 | ||
662 | if (limit) { | |
663 | limit = limit.getAttribute("value"); | |
664 | } else { | |
665 | limit = 0; | |
666 | } | |
667 | ||
4681834e AD |
668 | var articles_found = 0; |
669 | ||
670 | for (var i = 0; i < articles.length; i++) { | |
671 | var a = eval("("+articles[i].firstChild.nodeValue+")"); | |
672 | articles_found++; | |
673 | if (a) { | |
674 | ||
4681834e | 675 | db.execute("DELETE FROM articles WHERE id = ?", [a.id]); |
c2726c96 | 676 | |
4681834e AD |
677 | db.execute("INSERT INTO articles "+ |
678 | "(id, feed_id, title, link, guid, updated, content, "+ | |
55852afa AD |
679 | "unread, marked, tags, comments) "+ |
680 | "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", | |
4681834e | 681 | [a.id, a.feed_id, a.title, a.link, a.guid, a.updated, |
55852afa | 682 | a.content, a.unread, a.marked, a.tags, |
3034277a | 683 | a.comments]); |
4681834e | 684 | |
c2726c96 AD |
685 | if (a.labels.length > 0) { |
686 | for (var j = 0; j < a.labels.length; j++) { | |
687 | label_local_add_article(a.id, a.labels[j][0]); | |
688 | } | |
689 | } | |
690 | ||
4681834e AD |
691 | } |
692 | } | |
693 | ||
3e52ab08 AD |
694 | debug("downloaded articles: " + articles_found + " limit: " + limit); |
695 | ||
696 | if (articles_found >= limit) { | |
697 | window.setTimeout("update_offline_data("+(stage+1)+")", 10*1000); | |
698 | debug("update_offline_data: done " + stage); | |
4681834e AD |
699 | } else { |
700 | window.setTimeout("update_offline_data(0)", 1800*1000); | |
3e52ab08 | 701 | debug("update_offline_data: finished"); |
4681834e | 702 | |
711f9461 AD |
703 | db.execute("DELETE FROM articles WHERE "+ |
704 | "updated < DATETIME('NOW', 'localtime', '-31 days')"); | |
4681834e AD |
705 | |
706 | } | |
6b684299 AD |
707 | |
708 | update_local_sync_data(); | |
4681834e AD |
709 | } |
710 | ||
f45c85f9 | 711 | // notify(''); |
b2319311 | 712 | |
4681834e AD |
713 | } |
714 | } catch (e) { | |
715 | exception_error("offline_download_parse", e); | |
716 | } | |
717 | } | |
718 | ||
719 | function update_offline_data(stage) { | |
720 | try { | |
721 | ||
722 | if (!stage) stage = 0; | |
823ff6aa | 723 | if (offline_mode) return; |
4681834e AD |
724 | |
725 | debug("update_offline_data: stage " + stage); | |
726 | ||
f45c85f9 | 727 | // notify_progress("Updating offline data... (" + stage +")", true); |
4681834e AD |
728 | |
729 | var query = "backend.php?op=rpc&subop=download&stage=" + stage; | |
730 | ||
731 | var rs = db.execute("SELECT MAX(id), MIN(id) FROM articles"); | |
03c96380 | 732 | |
4681834e AD |
733 | if (rs.isValidRow() && rs.field(0)) { |
734 | var offline_dl_max_id = rs.field(0); | |
735 | var offline_dl_min_id = rs.field(1); | |
736 | ||
737 | query = query + "&cidt=" + offline_dl_max_id; | |
738 | query = query + "&cidb=" + offline_dl_min_id; | |
739 | } | |
740 | ||
03c96380 AD |
741 | rs.close(); |
742 | ||
4681834e AD |
743 | new Ajax.Request(query, { |
744 | onComplete: function(transport) { | |
745 | offline_download_parse(stage, transport); | |
4681834e AD |
746 | } }); |
747 | ||
748 | } catch (e) { | |
749 | exception_error("initiate_offline_download", e); | |
750 | } | |
751 | } | |
752 | ||
d6416405 | 753 | function set_feedlist_counter(id, ctr, is_cat) { |
4681834e AD |
754 | try { |
755 | ||
756 | var feedctr = document.getElementById("FEEDCTR-" + id); | |
757 | var feedu = document.getElementById("FEEDU-" + id); | |
758 | var feedr = document.getElementById("FEEDR-" + id); | |
759 | ||
d6416405 AD |
760 | if (is_cat) { |
761 | var catctr = document.getElementById("FCATCTR-" + id); | |
762 | if (catctr) { | |
763 | catctr.innerHTML = "(" + ctr + ")"; | |
764 | if (ctr > 0) { | |
765 | catctr.className = "catCtrHasUnread"; | |
766 | } else { | |
767 | catctr.className = "catCtrNoUnread"; | |
768 | } | |
769 | } | |
770 | } else if (feedctr && feedu && feedr) { | |
4681834e AD |
771 | |
772 | var row_needs_hl = (ctr > 0 && ctr > parseInt(feedu.innerHTML)); | |
773 | ||
774 | feedu.innerHTML = ctr; | |
775 | ||
776 | if (ctr > 0) { | |
777 | feedctr.className = "feedCtrHasUnread"; | |
778 | if (!feedr.className.match("Unread")) { | |
779 | var is_selected = feedr.className.match("Selected"); | |
780 | ||
781 | feedr.className = feedr.className.replace("Selected", ""); | |
782 | feedr.className = feedr.className.replace("Unread", ""); | |
783 | ||
784 | feedr.className = feedr.className + "Unread"; | |
785 | ||
786 | if (is_selected) { | |
787 | feedr.className = feedr.className + "Selected"; | |
788 | } | |
789 | ||
790 | } | |
791 | ||
792 | if (row_needs_hl) { | |
793 | new Effect.Highlight(feedr, {duration: 1, startcolor: "#fff7d5", | |
794 | queue: { position:'end', scope: 'EFQ-' + id, limit: 1 } } ); | |
795 | } | |
796 | } else { | |
797 | feedctr.className = "feedCtrNoUnread"; | |
798 | feedr.className = feedr.className.replace("Unread", ""); | |
799 | } | |
800 | } | |
801 | ||
802 | } catch (e) { | |
803 | exception_error("set_feedlist_counter", e); | |
804 | } | |
805 | } | |
806 | ||
807 | function update_local_feedlist_counters() { | |
808 | try { | |
f4c11347 | 809 | if (!offline_mode) return; |
4681834e | 810 | |
f4c11347 | 811 | /* var rs = db.execute("SELECT feeds.id,COUNT(articles.id) "+ |
4681834e AD |
812 | "FROM feeds LEFT JOIN articles ON (feed_id = feeds.id) "+ |
813 | "WHERE unread = 1 OR unread IS NULL GROUP BY feeds.id "+ | |
f4c11347 AD |
814 | "ORDER BY feeds.title"); */ |
815 | ||
d6416405 | 816 | var rs = db.execute("SELECT id FROM feeds "+ |
f4c11347 | 817 | "ORDER BY title"); |
4681834e AD |
818 | |
819 | while (rs.isValidRow()) { | |
820 | var id = rs.field(0); | |
f4c11347 | 821 | var ctr = get_local_feed_unread(id); |
d6416405 AD |
822 | set_feedlist_counter(id, ctr, false); |
823 | rs.next(); | |
824 | } | |
4681834e | 825 | |
d6416405 AD |
826 | rs.close(); |
827 | ||
828 | var rs = db.execute("SELECT cat_id,SUM(unread) "+ | |
829 | "FROM articles, feeds WHERE feeds.id = feed_id GROUP BY cat_id"); | |
4681834e | 830 | |
d6416405 AD |
831 | while (rs.isValidRow()) { |
832 | var id = rs.field(0); | |
833 | var ctr = rs.field(1); | |
834 | set_feedlist_counter(id, ctr, true); | |
4681834e AD |
835 | rs.next(); |
836 | } | |
837 | ||
03c96380 AD |
838 | rs.close(); |
839 | ||
c174bcdf AD |
840 | set_feedlist_counter(-2, get_local_category_unread(-2), true); |
841 | ||
4681834e AD |
842 | set_feedlist_counter(-4, get_local_feed_unread(-4)); |
843 | set_feedlist_counter(-1, get_local_feed_unread(-1)); | |
844 | ||
88a66534 AD |
845 | var rs = db.execute("SELECT id FROM labels"); |
846 | ||
847 | while (rs.isValidRow()) { | |
848 | var id = -11 - rs.field(0); | |
849 | var ctr = get_local_feed_unread(id); | |
850 | set_feedlist_counter(id, ctr, false); | |
851 | rs.next(); | |
852 | } | |
853 | ||
854 | rs.close(); | |
855 | ||
4681834e AD |
856 | hideOrShowFeeds(getInitParam("hide_read_feeds") == 1); |
857 | ||
858 | global_unread = get_local_feed_unread(-4); | |
859 | updateTitle(); | |
860 | ||
861 | } catch (e) { | |
862 | exception_error("update_local_feedlist_counters", e); | |
863 | } | |
864 | } | |
774b8df8 AD |
865 | |
866 | function get_local_feed_unread(id) { | |
867 | try { | |
868 | var rs; | |
869 | ||
870 | if (id == -4) { | |
871 | rs = db.execute("SELECT SUM(unread) FROM articles"); | |
872 | } else if (id == -1) { | |
873 | rs = db.execute("SELECT SUM(unread) FROM articles WHERE marked = 1"); | |
88a66534 | 874 | } else if (id > 0) { |
774b8df8 | 875 | rs = db.execute("SELECT SUM(unread) FROM articles WHERE feed_id = ?", [id]); |
88a66534 AD |
876 | } else if (id < -10) { |
877 | var label_id = -11 - id; | |
878 | rs = db.execute("SELECT SUM(unread) FROM articles,article_labels "+ | |
879 | "WHERE article_labels.id = articles.id AND label_id = ?", [label_id]); | |
774b8df8 AD |
880 | } |
881 | ||
03c96380 AD |
882 | var a = false; |
883 | ||
774b8df8 | 884 | if (rs.isValidRow()) { |
03c96380 | 885 | a = rs.field(0); |
774b8df8 | 886 | } else { |
03c96380 | 887 | a = 0; |
774b8df8 AD |
888 | } |
889 | ||
03c96380 AD |
890 | rs.close(); |
891 | ||
892 | return a; | |
893 | ||
774b8df8 AD |
894 | } catch (e) { |
895 | exception_error("get_local_feed_unread", e); | |
896 | } | |
897 | } | |
898 | ||
25d99353 AD |
899 | function init_gears() { |
900 | try { | |
901 | ||
902 | if (window.google && google.gears) { | |
903 | localServer = google.gears.factory.create("beta.localserver"); | |
904 | store = localServer.createManagedStore("tt-rss"); | |
905 | db = google.gears.factory.create('beta.database'); | |
906 | db.open('tt-rss'); | |
907 | ||
908 | db.execute("CREATE TABLE IF NOT EXISTS version (schema_version text)"); | |
909 | ||
910 | var rs = db.execute("SELECT schema_version FROM version"); | |
911 | ||
912 | var version = ""; | |
913 | ||
914 | if (rs.isValidRow()) { | |
915 | version = rs.field(0); | |
916 | } | |
917 | ||
3034277a AD |
918 | rs.close(); |
919 | ||
25d99353 | 920 | if (version != SCHEMA_VERSION) { |
3034277a | 921 | db.execute("DROP TABLE IF EXISTS init_params"); |
b871dd06 AD |
922 | db.execute("DROP TABLE IF EXISTS cache"); |
923 | db.execute("DROP TABLE IF EXISTS feeds"); | |
d8781c91 | 924 | db.execute("DROP TABLE IF EXISTS categories"); |
ed22888b AD |
925 | db.execute("DROP TABLE IF EXISTS labels"); |
926 | db.execute("DROP TABLE IF EXISTS article_labels"); | |
b871dd06 | 927 | db.execute("DROP TABLE IF EXISTS articles"); |
c174bcdf AD |
928 | db.execute("DROP INDEX IF EXISTS article_labels_label_id_idx"); |
929 | db.execute("DROP INDEX IF EXISTS articles_unread_idx"); | |
930 | db.execute("DROP INDEX IF EXISTS articles_feed_id_idx"); | |
3034277a | 931 | db.execute("DROP TABLE IF EXISTS version"); |
6b684299 AD |
932 | db.execute("DROP TRIGGER IF EXISTS articles_update_unread"); |
933 | db.execute("DROP TRIGGER IF EXISTS articles_update_marked"); | |
5b880817 | 934 | db.execute("DROP TRIGGER IF EXISTS articles_remove_labelrefs"); |
3034277a | 935 | db.execute("CREATE TABLE IF NOT EXISTS version (schema_version text)"); |
6b684299 | 936 | db.execute("DROP TABLE IF EXISTS syncdata"); |
25d99353 AD |
937 | db.execute("INSERT INTO version (schema_version) VALUES (?)", |
938 | [SCHEMA_VERSION]); | |
939 | } | |
940 | ||
71af6d36 | 941 | db.execute("CREATE TABLE IF NOT EXISTS init_params (key text, value text)"); |
3034277a | 942 | |
71af6d36 AD |
943 | db.execute("CREATE TABLE IF NOT EXISTS cache (id integer, article text, param text, added text)"); |
944 | db.execute("CREATE TABLE IF NOT EXISTS feeds (id integer, title text, has_icon integer, cat_id integer)"); | |
945 | db.execute("CREATE TABLE IF NOT EXISTS categories (id integer, title text, collapsed integer)"); | |
946 | db.execute("CREATE TABLE IF NOT EXISTS labels (id integer, caption text, fg_color text, bg_color text)"); | |
ed22888b | 947 | db.execute("CREATE TABLE IF NOT EXISTS article_labels (id integer, label_id integer)"); |
55852afa | 948 | 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 |
949 | |
950 | db.execute("CREATE INDEX IF NOT EXISTS articles_unread_idx ON articles(unread)"); | |
951 | db.execute("CREATE INDEX IF NOT EXISTS article_labels_label_id_idx ON article_labels(label_id)"); | |
952 | db.execute("CREATE INDEX IF NOT EXISTS articles_feed_id_idx ON articles(feed_id)"); | |
779ba075 | 953 | |
71af6d36 | 954 | db.execute("CREATE TABLE IF NOT EXISTS syncdata (key integer, value text)"); |
6b684299 | 955 | |
779ba075 | 956 | db.execute("DELETE FROM cache WHERE id LIKE 'F:%' OR id LIKE 'C:%'"); |
69ea0cdd | 957 | |
6b684299 | 958 | db.execute("CREATE TRIGGER IF NOT EXISTS articles_update_unread "+ |
55852afa AD |
959 | "UPDATE OF unread ON articles "+ |
960 | "BEGIN "+ | |
711f9461 | 961 | "UPDATE articles SET modified = DATETIME('NOW', 'localtime') "+ |
6b684299 AD |
962 | "WHERE id = OLD.id AND "+ |
963 | "OLD.unread != NEW.unread;"+ | |
964 | "END;"); | |
965 | ||
966 | db.execute("CREATE TRIGGER IF NOT EXISTS articles_update_marked "+ | |
967 | "UPDATE OF marked ON articles "+ | |
968 | "BEGIN "+ | |
969 | "UPDATE articles SET modified = DATETIME('NOW', 'localtime') "+ | |
970 | "WHERE id = OLD.id;"+ | |
55852afa AD |
971 | "END;"); |
972 | ||
5b880817 AD |
973 | db.execute("CREATE TRIGGER IF NOT EXISTS articles_remove_labelrefs "+ |
974 | "DELETE ON articles "+ | |
975 | "BEGIN "+ | |
976 | "DELETE FROM article_labels WHERE id = OLD.id; "+ | |
977 | "END; "); | |
978 | ||
6b684299 AD |
979 | init_local_sync_data(); |
980 | ||
69ea0cdd AD |
981 | Element.show("restartOfflinePic"); |
982 | ||
25d99353 AD |
983 | } |
984 | ||
985 | cache_expire(); | |
986 | ||
987 | } catch (e) { | |
988 | exception_error("init_gears", e); | |
989 | } | |
990 | } | |
991 | ||
69ea0cdd AD |
992 | function gotoOffline() { |
993 | window.location.href = "tt-rss.php?offline=1"; | |
994 | } | |
995 | ||
996 | function gotoOnline() { | |
997 | window.location.href = "tt-rss.php"; | |
998 | } | |
774b8df8 | 999 | |
c26aa9f0 AD |
1000 | function local_collapse_cat(id) { |
1001 | try { | |
1002 | if (db) { | |
1003 | db.execute("UPDATE categories SET collapsed = NOT collapsed WHERE id = ?", | |
1004 | [id]); | |
1005 | } | |
1006 | } catch (e) { | |
1007 | exception_error("local_collapse_cat", e); | |
1008 | } | |
1009 | } | |
d6416405 AD |
1010 | |
1011 | function get_local_category_title(id) { | |
1012 | try { | |
71af6d36 | 1013 | |
d6416405 AD |
1014 | var rs = db.execute("SELECT title FROM categories WHERE id = ?", [id]); |
1015 | var tmp = ""; | |
1016 | ||
1017 | if (rs.isValidRow()) { | |
1018 | tmp = rs.field(0); | |
1019 | } | |
1020 | ||
1021 | rs.close(); | |
1022 | ||
1023 | return tmp; | |
1024 | ||
1025 | } catch (e) { | |
1026 | exception_error("get_local_category_title", e); | |
1027 | } | |
1028 | } | |
1029 | ||
1030 | function get_local_category_unread(id) { | |
1031 | try { | |
c174bcdf AD |
1032 | var rs = false; |
1033 | ||
1034 | if (id >= 0) { | |
1035 | rs = db.execute("SELECT SUM(unread) FROM articles, feeds "+ | |
1036 | "WHERE feeds.id = feed_id AND cat_id = ?", [id]); | |
1037 | } else if (id == -2) { | |
1038 | rs = db.execute("SELECT SUM(unread) FROM article_labels, articles "+ | |
1039 | "where article_labels.id = articles.id"); | |
1040 | } else { | |
1041 | return 0; | |
1042 | } | |
d6416405 AD |
1043 | |
1044 | var tmp = 0; | |
1045 | ||
1046 | if (rs.isValidRow()) { | |
1047 | tmp = rs.field(0); | |
1048 | } | |
1049 | ||
1050 | rs.close(); | |
1051 | ||
1052 | return tmp; | |
1053 | ||
1054 | } catch (e) { | |
1055 | exception_error("get_local_category_unread", e); | |
1056 | } | |
1057 | } | |
1058 | ||
1059 | function printCategoryHeader(cat_id, hidden, can_browse) { | |
1060 | try { | |
1061 | if (hidden == undefined) hidden = false; | |
1062 | if (can_browse == undefined) can_browse = false; | |
1063 | ||
1064 | var tmp_category = get_local_category_title(cat_id); | |
1065 | var tmp = ""; | |
1066 | ||
1067 | var cat_unread = get_local_category_unread(cat_id); | |
1068 | ||
1069 | var holder_style = ""; | |
1070 | var ellipsis = ""; | |
1071 | ||
1072 | if (hidden) { | |
1073 | holder_style = "display:none;"; | |
1074 | ellipsis = "…"; | |
1075 | } | |
1076 | ||
1077 | var catctr_class = (cat_unread > 0) ? "catCtrHasUnread" : "catCtrNoUnread"; | |
1078 | ||
1079 | var browse_cat_link = ""; | |
1080 | var inner_title_class = "catTitleNL"; | |
1081 | ||
1082 | if (can_browse) { | |
1083 | browse_cat_link = "onclick=\"javascript:viewCategory($cat_id)\""; | |
1084 | inner_title_class = "catTitle"; | |
1085 | } | |
1086 | ||
1087 | var cat_class = "feedCat"; | |
1088 | ||
1089 | tmp += "<li class=\""+cat_class+"\" id=\"FCAT-"+cat_id+"\">"+ | |
1090 | "<img onclick=\"toggleCollapseCat("+cat_id+")\" class=\"catCollapse\""+ | |
1091 | " title=\""+__('Click to collapse category')+"\""+ | |
1092 | " src=\"images/cat-collapse.png\"><span class=\""+inner_title_class+"\" "+ | |
1093 | " id=\"FCATN-"+cat_id+"\" "+browse_cat_link+ | |
1094 | "\">"+tmp_category+"</span>"; | |
1095 | ||
1096 | tmp += "<span id=\"FCAP-"+cat_id+"\">"; | |
1097 | ||
1098 | tmp += " <span id=\"FCATCTR-"+cat_id+"\" "+ | |
1099 | "class=\""+catctr_class+"\">("+cat_unread+")</span> "+ellipsis; | |
1100 | ||
1101 | tmp += "</span>"; | |
1102 | ||
1103 | tmp += "<ul class=\"feedCatList\" id=\"FCATLIST-"+cat_id+"\" "+ | |
1104 | "style='"+holder_style+"'>"; | |
1105 | ||
1106 | return tmp; | |
1107 | } catch (e) { | |
1108 | exception_error("printCategoryHeader", e); | |
1109 | } | |
1110 | } | |
1111 | ||
c2726c96 AD |
1112 | function is_local_cat_collapsed(id) { |
1113 | try { | |
1114 | ||
1115 | var rs = db.execute("SELECT collapsed FROM categories WHERE id = ?", [id]); | |
1116 | var cat_hidden = 0; | |
1117 | ||
1118 | if (rs.isValidRow()) { | |
1119 | cat_hidden = rs.field(0); | |
1120 | } | |
1121 | ||
1122 | rs.close(); | |
1123 | ||
1124 | return cat_hidden == "1"; | |
1125 | ||
1126 | } catch (e) { | |
1127 | exception_error("is_local_cat_collapsed", e); | |
1128 | } | |
1129 | } | |
1130 | ||
6da82466 AD |
1131 | function get_local_article_labels(id) { |
1132 | try { | |
1133 | var rs = db.execute("SELECT DISTINCT label_id,caption,fg_color,bg_color "+ | |
1134 | "FROM labels, article_labels "+ | |
1135 | "WHERE labels.id = label_id AND article_labels.id = ?", [id]); | |
1136 | ||
1137 | var tmp = new Array(); | |
1138 | ||
1139 | while (rs.isValidRow()) { | |
1140 | var e = new Array(); | |
1141 | ||
1142 | e[0] = rs.field(0); | |
1143 | e[1] = rs.field(1); | |
1144 | e[2] = rs.field(2); | |
1145 | e[3] = rs.field(3); | |
1146 | ||
1147 | tmp.push(e); | |
1148 | ||
1149 | rs.next(); | |
1150 | } | |
1151 | ||
1152 | return tmp; | |
1153 | ||
1154 | } catch (e) { | |
1155 | exception_error("get_local_article_labels", e); | |
1156 | } | |
1157 | } | |
1158 | ||
c2726c96 AD |
1159 | function label_local_add_article(id, label_id) { |
1160 | try { | |
5b880817 | 1161 | //debug("label_local_add_article " + id + " => " + label_id); |
c2726c96 AD |
1162 | |
1163 | var rs = db.execute("SELECT COUNT(id) FROM article_labels WHERE "+ | |
1164 | "id = ? AND label_id = ?", [id, label_id]); | |
1165 | var check = rs.field(0); | |
1166 | ||
1167 | if (rs.isValidRow()) { | |
1168 | var check = rs.field(0); | |
1169 | } | |
1170 | rs.close(); | |
1171 | ||
1172 | if (check == 0) { | |
1173 | db.execute("INSERT INTO article_labels (id, label_id) VALUES "+ | |
1174 | "(?,?)", [id, label_id]); | |
1175 | } | |
1176 | ||
1177 | } catch (e) { | |
1178 | exception_error("label_local_add_article", e); | |
1179 | } | |
1180 | } | |
88a66534 AD |
1181 | |
1182 | function get_local_feed_title(id) { | |
1183 | try { | |
1184 | ||
1185 | var feed_title = "Unknown feed: " + id; | |
1186 | ||
1187 | if (id > 0) { | |
1188 | var rs = db.execute("SELECT title FROM feeds WHERE id = ?", [id]); | |
1189 | ||
1190 | if (rs.isValidRow()) { | |
1191 | feed_title = rs.field(0); | |
1192 | } | |
1193 | ||
1194 | rs.close(); | |
1195 | } else if (id == -1) { | |
1196 | feed_title = __("Starred articles"); | |
1197 | } else if (id == -4) { | |
1198 | feed_title = __("All articles"); | |
1199 | } else if (id < -10) { | |
1200 | ||
1201 | var label_id = -11 - id; | |
1202 | ||
1203 | var rs = db.execute("SELECT caption FROM labels WHERE id = ?", [label_id]); | |
1204 | ||
1205 | if (rs.isValidRow()) { | |
1206 | feed_title = rs.field(0); | |
1207 | } | |
1208 | ||
1209 | rs.close(); | |
1210 | } | |
1211 | ||
1212 | return feed_title; | |
1213 | ||
1214 | } catch (e) { | |
1215 | exception_error("get_local_feed_title", e); | |
1216 | } | |
1217 | } | |
6da82466 AD |
1218 | |
1219 | function format_article_labels(labels, id) { | |
1220 | try { | |
1221 | ||
1222 | var labels_str = ""; | |
1223 | ||
1224 | if (!labels) return ""; | |
1225 | ||
1226 | for (var i = 0; i < labels.length; i++) { | |
1227 | var l = labels[i]; | |
1228 | ||
1229 | labels_str += "<span class='hlLabelRef' "+ | |
1230 | "style='color : "+l[2]+"; background-color : "+l[3]+"'>"+l[1]+"</span>"; | |
1231 | } | |
1232 | ||
1233 | return labels_str; | |
1234 | ||
1235 | } catch (e) { | |
1236 | exception_error("format_article_labels", e); | |
1237 | } | |
1238 | } | |
1239 | ||
6b684299 AD |
1240 | function init_local_sync_data() { |
1241 | try { | |
1242 | var rs = db.execute("SELECT COUNT(*) FROM syncdata WHERE key = 'last_online'"); | |
1243 | var has_last_online = 0; | |
1244 | ||
1245 | if (rs.isValidRow()) { | |
1246 | has_last_online = rs.field(0); | |
1247 | } | |
1248 | ||
1249 | rs.close(); | |
1250 | ||
1251 | if (!has_last_online) { | |
1252 | db.execute("INSERT INTO syncdata (key, value) VALUES ('last_online', '')"); | |
1253 | } | |
1254 | ||
1255 | } catch (e) { | |
1256 | exception_error("init_local_sync_data", e); | |
1257 | ||
1258 | } | |
1259 | } | |
1260 | ||
1261 | function update_local_sync_data() { | |
1262 | try { | |
1263 | if (db && !offline_mode) { | |
1264 | db.execute("UPDATE syncdata SET value = DATETIME('NOW', 'localtime') "+ | |
1265 | "WHERE key = 'last_online'"); | |
1266 | ||
1267 | } | |
1268 | } catch (e) { | |
1269 | exception_error("update_local_sync_data", e); | |
1270 | } | |
1271 | } | |
67625745 AD |
1272 | |
1273 | function catchup_local_feed(id, is_cat) { | |
1274 | try { | |
6161d5cc AD |
1275 | if (!db) return; |
1276 | ||
67625745 AD |
1277 | if (!is_cat) { |
1278 | if (id >= 0) { | |
1279 | db.execute("UPDATE articles SET unread = 0 WHERE feed_id = ?", [id]); | |
1280 | } else if (id == -1) { | |
1281 | db.execute("UPDATE articles SET unread = 0 WHERE marked = 1"); | |
1282 | } else if (id == -4) { | |
1283 | db.execute("UPDATE articles SET unread = 0"); | |
1284 | } else if (id < -10) { | |
1285 | var label_id = -11-id; | |
1286 | ||
1287 | db.execute("UPDATE articles SET unread = 0 WHERE "+ | |
1288 | "(SELECT COUNT(*) FROM article_labels WHERE "+ | |
1289 | "article_labels.id = articles.id AND label_id = ?) > 0", [label_id]); | |
1290 | } | |
1291 | } | |
1292 | ||
1293 | update_local_feedlist_counters(); | |
1294 | ||
1295 | } catch (e) { | |
1296 | exception_error("catchup_local_feed", e); | |
1297 | } | |
1298 | } |