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;
}
