Bug #769
closed
user groups access rigths : not being displayed
100%
Description
Hi,
i have found a small bug :
1. if you have created some user groups and then update to latest version - 1373947200 - ,
the user group has not been added to the user_acces_group
solution :
run this sql in goautodial DB :
INSERT INTO `user_access_group` (`user_group`, `permissions`, `group_level`, `date_create`, `allowed_campaigns`) VALUES ('<GROUP>', '{"dashboard":{"dashboard_todays_status":"N","dashboard_account_info":"N","dashboard_agent_lead_status":"N","dashboard_server_settings":"N","dashboard_go_analytics":"N","dashboard_system_service":"N"},"user":{"user_create":"N","user_read":"N","user_update":"N","user_delete":"N"},"campaign":{"campaign_create":"N","campaign_read":"N","campaign_update":"N","campaign_delete":"N"},"list":{"list_create":"N","list_read":"N","list_update":"N","list_delete":"N"},"customfields":{"customfields_create":"N","customfields_read":"N","customfields_update":"N","customfields_delete":"N"},"loadleads":{"loadleads_read":"N"},"script":{"script_create":"N","script_read":"N","script_update":"N","script_delete":"N"},"inbound":{"inbound_create":"N","inbound_read":"N","inbound_update":"N","inbound_delete":"N"},"voicefiles":{"voicefile_upload":"N","voicefile_delete":"N"},"reportsanalytics":{"reportsanalytics_statistical_report":"N","reportsanalytics_agent_time_detail":"N","reportsanalytics_agent_performance_detail":"N","reportsanalytics_dial_status_summary":"N","reportsanalytics_sales_per_agent":"N","reportsanalytics_sales_tracker":"N","reportsanalytics_inbound_call_report":"N","reportsanalytics_export_call_report":"N","reportsanalytics_dashboard":"N","reportsanalytics_advance_script":"N"},"recording":{"recordings_display":"N"},"support":{"support_display":"N"}}', 1, '2013-06-05 15:49:21', NULL);
replace <GROUP> with the GROUP ID
or for all inexistent groups :
INSERT INTO `user_access_group` (`user_group`, `permissions`, `group_level`, `date_create`, `allowed_campaigns`)
select g.user_group, '{"dashboard":{"dashboard_todays_status":"N","dashboard_account_info":"N","dashboard_agent_lead_status":"N","dashboard_server_settings":"N","dashboard_go_analytics":"N","dashboard_system_service":"N"},"user":{"user_create":"N","user_read":"N","user_update":"N","user_delete":"N"},"campaign":{"campaign_create":"N","campaign_read":"N","campaign_update":"N","campaign_delete":"N"},"list":{"list_create":"N","list_read":"N","list_update":"N","list_delete":"N"},"customfields":{"customfields_create":"N","customfields_read":"N","customfields_update":"N","customfields_delete":"N"},"loadleads":{"loadleads_read":"N"},"script":{"script_create":"N","script_read":"N","script_update":"N","script_delete":"N"},"inbound":{"inbound_create":"N","inbound_read":"N","inbound_update":"N","inbound_delete":"N"},"voicefiles":{"voicefile_upload":"N","voicefile_delete":"N"},"reportsanalytics":{"reportsanalytics_statistical_report":"N","reportsanalytics_agent_time_detail":"N","reportsanalytics_agent_performance_detail":"N","reportsanalytics_dial_status_summary":"N","reportsanalytics_sales_per_agent":"N","reportsanalytics_sales_tracker":"N","reportsanalytics_inbound_call_report":"N","reportsanalytics_export_call_report":"N","reportsanalytics_dashboard":"N","reportsanalytics_advance_script":"N"},"recording":{"recordings_display":"N"},"support":{"support_display":"N"}}', 1, '2013-06-05 15:49:21', NULL
from asterisk.vicidial_user_groups g
where g.user_group in (select a.id from user_access_group a );
2. in applications\views\settings\go_usergroup_list.php (chrome complains about syntax error)
line 160, add ; to modify function
echo "<td style='border-top:#D0D0D0 dashed 1px;'> <a onclick=\"modify('{$list->user_group}');\">{$list->user_group}</a></td>";
echo "<td style='border-top:#D0D0D0 dashed 1px;'> <a onclick=\"modify('{$list->user_group}');\">{$list->group_name}</a></td>";
echo "<td style='border-top:#D0D0D0 dashed 1px;'> $forced_timeclock</td>";
echo "<td style='border-top:#D0D0D0 dashed 1px;' align='center'><span onclick=\"modify('{$list->user_group}');\" style='cursor:pointer;' class='toolTip' title='MODIFY USER GROUP<br />{$list->user_group}'><img src='{$base}img/edit.png' style='cursor:pointer;width:12px;' /></span></td><td align='center' style='border-top:#D0D0D0 dashed 1px;'><span onclick=\"delUserGroup('{$list->user_group}')\" style='cursor:pointer;' class='toolTip' title='DELETE USER GROUP<br />{$list->user_group}'><img src='{$base}img/delete.png' style='cursor:pointer;width:12px;' /></span></td><td align='center' style='border-top:#D0D0D0 dashed 1px;'><span><img src='{$base}img/status_display_i_grayed.png' style='width:12px;' /></span></td>\n";
Rgds
Updated by said said over 11 years ago
sorry , one small error in the SQL (i forgot the 'not' )
INSERT INTO `user_access_group` (`user_group`, `permissions`, `group_level`, `date_create`, `allowed_campaigns`)
select g.user_group, '{"dashboard":{"dashboard_todays_status":"N","dashboard_account_info":"N","dashboard_agent_lead_status":"N","dashboard_server_settings":"N","dashboard_go_analytics":"N","dashboard_system_service":"N"},"user":{"user_create":"N","user_read":"N","user_update":"N","user_delete":"N"},"campaign":{"campaign_create":"N","campaign_read":"N","campaign_update":"N","campaign_delete":"N"},"list":{"list_create":"N","list_read":"N","list_update":"N","list_delete":"N"},"customfields":{"customfields_create":"N","customfields_read":"N","customfields_update":"N","customfields_delete":"N"},"loadleads":{"loadleads_read":"N"},"script":{"script_create":"N","script_read":"N","script_update":"N","script_delete":"N"},"inbound":{"inbound_create":"N","inbound_read":"N","inbound_update":"N","inbound_delete":"N"},"voicefiles":{"voicefile_upload":"N","voicefile_delete":"N"},"reportsanalytics":{"reportsanalytics_statistical_report":"N","reportsanalytics_agent_time_detail":"N","reportsanalytics_agent_performance_detail":"N","reportsanalytics_dial_status_summary":"N","reportsanalytics_sales_per_agent":"N","reportsanalytics_sales_tracker":"N","reportsanalytics_inbound_call_report":"N","reportsanalytics_export_call_report":"N","reportsanalytics_dashboard":"N","reportsanalytics_advance_script":"N"},"recording":{"recordings_display":"N"},"support":{"support_display":"N"}}', 1, '2013-06-05 15:49:21', NULL
from asterisk.vicidial_user_groups g
where g.user_group not in (select a.id from user_access_group a )
VALUES ('AGENTS', '{"dashboard":{"dashboard_todays_status":"N","dashboard_account_info":"N","dashboard_agent_lead_status":"N","dashboard_server_settings":"N","dashboard_go_analytics":"N","dashboard_system_service":"N"},"user":{"user_create":"N","user_read":"N","user_update":"N","user_delete":"N"},"campaign":{"campaign_create":"N","campaign_read":"N","campaign_update":"N","campaign_delete":"N"},"list":{"list_create":"N","list_read":"N","list_update":"N","list_delete":"N"},"customfields":{"customfields_create":"N","customfields_read":"N","customfields_update":"N","customfields_delete":"N"},"loadleads":{"loadleads_read":"N"},"script":{"script_create":"N","script_read":"N","script_update":"N","script_delete":"N"},"inbound":{"inbound_create":"N","inbound_read":"N","inbound_update":"N","inbound_delete":"N"},"voicefiles":{"voicefile_upload":"N","voicefile_delete":"N"},"reportsanalytics":{"reportsanalytics_statistical_report":"N","reportsanalytics_agent_time_detail":"N","reportsanalytics_agent_performance_detail":"N","reportsanalytics_dial_status_summary":"N","reportsanalytics_sales_per_agent":"N","reportsanalytics_sales_tracker":"N","reportsanalytics_inbound_call_report":"N","reportsanalytics_export_call_report":"N","reportsanalytics_dashboard":"N","reportsanalytics_advance_script":"N"},"recording":{"recordings_display":"N"},"support":{"support_display":"N"}}', 1, '2013-06-05 15:49:21', NULL);
Updated by said said over 11 years ago
sorry , the good one :
INSERT INTO `user_access_group` (`user_group`, `permissions`, `group_level`, `date_create`, `allowed_campaigns`)
select g.user_group, '{"dashboard":{"dashboard_todays_status":"N","dashboard_account_info":"N","dashboard_agent_lead_status":"N","dashboard_server_settings":"N","dashboard_go_analytics":"N","dashboard_system_service":"N"},"user":{"user_create":"N","user_read":"N","user_update":"N","user_delete":"N"},"campaign":{"campaign_create":"N","campaign_read":"N","campaign_update":"N","campaign_delete":"N"},"list":{"list_create":"N","list_read":"N","list_update":"N","list_delete":"N"},"customfields":{"customfields_create":"N","customfields_read":"N","customfields_update":"N","customfields_delete":"N"},"loadleads":{"loadleads_read":"N"},"script":{"script_create":"N","script_read":"N","script_update":"N","script_delete":"N"},"inbound":{"inbound_create":"N","inbound_read":"N","inbound_update":"N","inbound_delete":"N"},"voicefiles":{"voicefile_upload":"N","voicefile_delete":"N"},"reportsanalytics":{"reportsanalytics_statistical_report":"N","reportsanalytics_agent_time_detail":"N","reportsanalytics_agent_performance_detail":"N","reportsanalytics_dial_status_summary":"N","reportsanalytics_sales_per_agent":"N","reportsanalytics_sales_tracker":"N","reportsanalytics_inbound_call_report":"N","reportsanalytics_export_call_report":"N","reportsanalytics_dashboard":"N","reportsanalytics_advance_script":"N"},"recording":{"recordings_display":"N"},"support":{"support_display":"N"}}', 1, '2013-06-05 15:49:21', NULL
from asterisk.vicidial_user_groups g
where g.user_group not in (select a.id from user_access_group a );
Updated by Chris Lomuntad over 11 years ago
- Assignee set to Franco Hora
Hi said,
Thanks for posting this bug. We're on the process of fixing this bug and we'll update our repository once we're done fixing it.
Cheers,
Chris
Updated by Tristan Kendrick Biscocho over 11 years ago
Hi,
Update addressing this bug will be released soon.
Updated by said said over 11 years ago
Hi,
i'm using : GoAdmin ® 3.0-1373947200
Rgds
Updated by Franco Hora over 11 years ago
- Status changed from New to Resolved
- % Done changed from 0 to 100
Hi said,
The user permission bug is now updated and ready on our repository just yum update your box for the update
Thanks
Updated by Demian Biscocho over 10 years ago
- Status changed from Resolved to Closed
- Assignee deleted (
Franco Hora)