Send broadcast message for all users
Posted: Tue Jul 27, 2021 8:29 am
I would like to send message (online from globeadmin account) for all active users. For example, "Please exit the program ..."
Is it possible?
Is it possible?
To test: Enter a message in the "Notification" form, check "active", save. All users will see a notification until you uncheck "active".
How to set it up:
1. In Setup-> Header, add this JS before the function nuOnLoad() :
Code: Select all
// Polling the server for notifications
function fetchNotification() {
nuRunPHPHidden('fetchnotification', 0);
}
setInterval(function() {
fetchNotification();
}, 5000); // polling interval
Code: Select all
function getNotificationMessage() {
$sql = "SELECT `not_message` FROM `notification` WHERE `not_active` = 1";
$t = nuRunQuery($sql);
return (db_num_rows($t) != 0) ? db_fetch_row($t) [0] : '';
}
$message = getNotificationMessage();
if ($message != '') {
$not = nuGetJSONData('NOTIFICATION');
if ($not == '') {
$dt = new DateTime();
nuSetJSONData('NOTIFICATION', $dt->getTimestamp());
nuDisplayError($message);
}
}3. Create a table:
Code: Select all
CREATE TABLE `notification` (
`notification_id` varchar(25) NOT NULL,
`not_message` text DEFAULT NULL,
`not_created_at` datetime DEFAULT current_timestamp(),
`not_active` varchar(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE `notification`
ADD PRIMARY KEY (`notification_id`);Code: Select all
-- nuBuilder cloner SQL Dump
-- Version 1.21
-- Generation Time: July 27, 2021 10:09:59 AM
-- Form Description: notification
-- Form Code: notification_BE
-- Form Table: notification
-- Form Type: browseedit
--
-- zzzzsys_form: notification_BE
--
INSERT INTO zzzzsys_form (zzzzsys_form_id, sfo_type, sfo_code, sfo_description, sfo_breadcrumb_title, sfo_table, sfo_primary_key, sfo_browse_redirect_form_id, sfo_browse_row_height, sfo_browse_rows_per_page, sfo_browse_title_multiline, sfo_browse_sql, sfo_javascript)
VALUES ( '60ffbf57150269c', 'browseedit', 'notification_BE', 'notification', NULL, 'notification', 'notification_id', NULL, NULL, NULL, '0', 'SELECT * FROM notification', NULL );
--
-- zzzzsys_tab
--
INSERT INTO zzzzsys_tab (zzzzsys_tab_id, syt_zzzzsys_form_id, syt_title, syt_order, syt_help)
VALUES ( '60ffbf571539841', '60ffbf57150269c', 'Main', '10', NULL );
--
-- zzzzsys_browse
--
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width)
VALUES ( '60ffbf5715767f7', '60ffbf57150269c', 'Message', 'not_message', 'l', '', '10', '250' );
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width)
VALUES ( '60ffbf571577c98', '60ffbf57150269c', 'Created At', 'not_created_at', 'l', '', '20', '250' );
--
-- zzzzsys_object
--
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_javascript, sob_input_datalist, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id)
VALUES ( '60ffbf5715a74ef', '60ffbf57150269c', 'notification', 'textarea', 'not_message', 'Message', '60ffbf571539841', '10', '55', '122', '251', '64', '1', 'left', '0', '0', NULL, '', '', '', '', '', NULL, NULL, '', 'SELECT COUNT(*) FROM zzzzsys_debug', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'N|$ 1,000.00', 'nuScroll', '[\'North\',\'South\',\'East\',\'West\']', NULL, '', '', '', '', '', '', '' );
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_javascript, sob_input_datalist, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id)
VALUES ( '60ffbf5715ab04e', '60ffbf57150269c', 'notification', 'input', 'not_active', 'Active?', '60ffbf571539841', '20', '136', '356', '17', '20', '1', 'left', '0', '0', '0', '', '', '', '', '', '', '', '', 'SELECT COUNT(*) FROM zzzzsys_debug', '0', '0', '', '', '', '', NULL, '', '', NULL, '', '', '', '', '', '', '', '0', '', 'checkbox', '', '', '', '', '', '', '', '', '' ); 