void statistics_statistics () { Webserver_Request request; Database_Mail database_mail = Database_Mail (&request); Database_Modifications database_modifications; Database_Notes database_notes (&request); Database_Logs::log (translate("Sending statistics"), Filter_Roles::manager ()); string siteUrl = config_logic_site_url (); vector <string> bibles = request.database_bibles()->getBibles (); vector <string> users = request.database_users ()->getUsers (); for (auto & user : users) { string subject = "Bibledit " + translate("statistics"); vector <string> body; if (request.database_config_user()->getUserPendingChangesNotification (user)) { vector <int> ids = database_modifications.getNotificationIdentifiers (user); body.push_back ("<p><a href=\"" + siteUrl + changes_changes_url () + "\">" + translate("Number of change notifications") + "</a>: " + convert_to_string (ids.size()) + "</p>\n"); } if (request.database_config_user()->getUserAssignedNotesStatisticsNotification (user)) { vector <int> ids = database_notes.selectNotes ( bibles, // Bibles. 0, // Book 0, // Chapter 0, // Verse 3, // Passage selector. 0, // Edit selector. 0, // Non-edit selector. "", // Status selector. "", // Bible selector. user, // Assignment selector. 0, // Subscription selector. -1, // Severity selector. 0, // Text selector. "", // Search text. -1); // Limit. body.push_back ("<p><a href=\"" + siteUrl + notes_index_url () + "?presetselection=assigned\">" + translate("Number of consultation notes assigned to you awaiting your response") + "</a>: " + convert_to_string (ids.size ()) + "</p>\n"); } if (request.database_config_user()->getUserSubscribedNotesStatisticsNotification (user)) { body.push_back ("<p>" + translate("Number of consultation notes you are subscribed to") + ":</p>\n"); body.push_back ("<ul>\n"); request.session_logic ()->setUsername (user); vector <int> ids = database_notes.selectNotes ( bibles, // Bible. 0, // Book 0, // Chapter 0, // Verse 3, // Passage selector. 0, // Edit selector. 0, // Non-edit selector. "", // Status selector. "", // Bible selector. "", // Assignment selector. 1, // Subscription selector. -1, // Severity selector. 0, // Text selector. "", // Search text. -1); // Limit. body.push_back ("<li><a href=\"" + siteUrl + notes_index_url () + "?presetselection=subscribed\">" + translate("Total") + "</a>: " + convert_to_string (ids.size ()) + "</li>\n"); ids = database_notes.selectNotes ( bibles, // Bible. 0, // Book 0, // Chapter 0, // Verse 3, // Passage selector. 0, // Edit selector. 1, // Non-edit selector. "", // Status selector. "", // Bible selector. "", // Assignment selector. 1, // Subscription selector. -1, // Severity selector. 0, // Text selector. "", // Search text. -1); // Limit. body.push_back ("<li><a href=\"" + siteUrl + notes_index_url () + "?presetselection=subscribeddayidle\">" + translate("Inactive for a day") + "</a>: " + convert_to_string (ids.size ()) + "</li>\n"); ids = database_notes.selectNotes ( bibles, // Bible. 0, // Book 0, // Chapter 0, // Verse 3, // Passage selector. 0, // Edit selector. 3, // Non-edit selector. "", // Status selector. "", // Bible selector. "", // Assignment selector. 1, // Subscription selector. -1, // Severity selector. 0, // Text selector. "", // Search text. -1); // Limit. body.push_back ("<li><a href=\"" + siteUrl + notes_index_url () + "?presetselection=subscribedweekidle\">" + translate("Inactive for a week") + "</a>: " + convert_to_string (ids.size ()) + "</li>\n"); body.push_back ("</ul>\n"); request.session_logic ()->setUsername (""); } if (!body.empty ()) { string mailbody = filter_string_implode (body, "\n"); database_mail.send (user, subject, mailbody); } } }
string changes_changes (void * webserver_request) { Webserver_Request * request = (Webserver_Request *) webserver_request; Database_Modifications database_modifications; bool touch = request->session_logic ()->touchEnabled (); string page; Assets_Header header = Assets_Header (translate("Changes"), request); header.setStylesheet (); header.addBreadCrumb (menu_logic_translate_menu (), menu_logic_translate_text ()); if (touch) header.jQueryTouchOn (); page += header.run (); Assets_View view; string username = request->session_logic()->currentUser (); // Handle AJAX call to remove a change notification. if (request->post.count ("remove")) { int remove = convert_to_int (request->post["remove"]); trash_change_notification (request, remove); database_modifications.deleteNotification (remove); #ifdef HAVE_CLIENT request->database_config_user ()->addRemovedChange (remove); #endif request->database_config_user ()->setChangeNotificationsChecksum (""); return ""; } // Handle AJAX call to navigate to the passage belonging to the change notification. if (request->post.count ("navigate")) { string navigate = request->post["navigate"]; int id = convert_to_int (navigate); Passage passage = database_modifications.getNotificationPassage (id); if (passage.book) { Ipc_Focus::set (request, passage.book, passage.chapter, convert_to_int (passage.verse)); Navigation_Passage::recordHistory (request, passage.book, passage.chapter, convert_to_int (passage.verse)); } // Set the correct default Bible for the user. string bible = database_modifications.getNotificationBible (id); if (!bible.empty ()) request->database_config_user()->setBible (bible); return ""; } // Remove a user's personal changes notifications and their matching change notifications in the Bible. string matching = request->query ["matching"]; if (!matching.empty ()) { vector <int> ids = database_modifications.clearNotificationMatches (username, matching, changes_bible_category ()); #ifdef HAVE_CLIENT // Client records deletions for sending to the Cloud. for (auto & id : ids) { request->database_config_user ()->addRemovedChange (id); } #endif // Clear checksum cache. request->database_config_user ()->setChangeNotificationsChecksum (""); } // Remove all the personal change notifications. if (request->query.count ("personal")) { vector <int> ids = database_modifications.getNotificationTeamIdentifiers (username, changes_personal_category (), true); for (auto id : ids) { trash_change_notification (request, id); database_modifications.deleteNotification (id); #ifdef HAVE_CLIENT request->database_config_user ()->addRemovedChange (id); #endif request->database_config_user ()->setChangeNotificationsChecksum (""); } } // Remove all the Bible change notifications. if (request->query.count ("bible")) { vector <int> ids = database_modifications.getNotificationTeamIdentifiers (username, changes_bible_category (), true); for (auto id : ids) { trash_change_notification (request, id); database_modifications.deleteNotification (id); #ifdef HAVE_CLIENT request->database_config_user ()->addRemovedChange (id); #endif request->database_config_user ()->setChangeNotificationsChecksum (""); } } // Remove all the change notifications made by a certain user. if (request->query.count ("dismiss")) { string user = request->query ["dismiss"]; vector <int> ids = database_modifications.getNotificationTeamIdentifiers (username, user, true); for (auto id : ids) { trash_change_notification (request, id); database_modifications.deleteNotification (id); #ifdef HAVE_CLIENT request->database_config_user ()->addRemovedChange (id); #endif request->database_config_user ()->setChangeNotificationsChecksum (""); } } // Read the identifiers. // Limit the number of results to keep the page reasonably fast even if there are many notifications. vector <int> personal_ids = database_modifications.getNotificationPersonalIdentifiers (username, changes_personal_category (), true); vector <int> bible_ids = database_modifications.getNotificationTeamIdentifiers (username, changes_bible_category (), true); vector <int> ids = database_modifications.getNotificationIdentifiers (username, true); string textblock; for (auto id : ids) { Passage passage = database_modifications.getNotificationPassage (id); string link = filter_passage_link_for_opening_editor_at (passage.book, passage.chapter, passage.verse); string category = database_modifications.getNotificationCategory (id); if (category == changes_personal_category ()) category = emoji_smiling_face_with_smiling_eyes (); if (category == changes_bible_category ()) category = emoji_open_book (); string modification = database_modifications.getNotificationModification (id); textblock.append ("<div id=\"entry" + convert_to_string (id) + "\">\n"); textblock.append ("<a href=\"expand\" id=\"expand" + convert_to_string (id) + "\">" + emoji_file_folder () + "</a>\n"); textblock.append ("<a href=\"remove\" id=\"remove" + convert_to_string (id) + "\">" + emoji_wastebasket () + "</a>\n"); textblock.append (link + "\n"); textblock.append (category + "\n"); textblock.append (modification + "\n"); textblock.append ("</div>\n"); } view.set_variable ("textblock", textblock); string loading = "\"" + translate("Loading ...") + "\""; string script = "var loading = " + loading + ";"; config_logic_swipe_enabled (webserver_request, script); view.set_variable ("script", script); // Enable links to dismiss categories of notifications depending on whether there's anything to dismiss. if (!personal_ids.empty ()) view.enable_zone ("personal"); if (!bible_ids.empty ()) view.enable_zone ("bible"); // Add links to clear the notifications from the individual contributors. string dismissblock; vector <string> categories = database_modifications.getCategories (); for (auto & category : categories) { if (category == changes_personal_category ()) continue; if (category == changes_bible_category ()) continue; string user = category; vector <int> ids = database_modifications.getNotificationTeamIdentifiers (username, user, true); if (!ids.empty ()) { dismissblock.append ("<p>* <a href=\"?dismiss="); dismissblock.append (user); dismissblock.append ("\">"); dismissblock.append (user); dismissblock.append (": "); dismissblock.append (translate("all of them")); dismissblock.append (": "); dismissblock.append (convert_to_string (ids.size ())); dismissblock.append ("</a></p>\n"); } } view.set_variable ("dismissblock", dismissblock); // Add links to clear matching notifications of the various users. for (auto & category : categories) { if (category == changes_bible_category ()) continue; string user = category; vector <int> personal_ids = database_modifications.getNotificationTeamIdentifiers (username, user, true); string icon = category; if (category == changes_personal_category ()) icon = emoji_smiling_face_with_smiling_eyes (); if (!personal_ids.empty () && !bible_ids.empty ()) { view.add_iteration ("matching", { make_pair ("user", user), make_pair ("icon", icon) } ); } } view.set_variable ("VERSION", config_logic_version ()); if (touch) view.enable_zone ("touch"); view.set_variable ("interlinks", changes_interlinks (webserver_request, changes_changes_url ())); page += view.render ("changes", "changes"); page += Assets_Page::footer (); return page; }