From 09651d28c0c41a272f294383795ff01f0f8e9c7c Mon Sep 17 00:00:00 2001 From: yashodha Date: Thu, 15 Oct 2015 14:50:30 +0530 Subject: [PATCH] CRM-17392: Charts do not appear on dashboard ---------------------------------------- * CRM-17392: Charts do not appear on dashboard https://issues.civicrm.org/jira/browse/CRM-17392 --- sql/civicrm_generated.mysql | 2 +- xml/templates/civicrm_sample.tpl | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/sql/civicrm_generated.mysql b/sql/civicrm_generated.mysql index 6a4534230a..11643247bb 100644 --- a/sql/civicrm_generated.mysql +++ b/sql/civicrm_generated.mysql @@ -342,7 +342,7 @@ UNLOCK TABLES; LOCK TABLES `civicrm_dashboard` WRITE; /*!40000 ALTER TABLE `civicrm_dashboard` DISABLE KEYS */; -INSERT INTO `civicrm_dashboard` (`id`, `domain_id`, `name`, `label`, `url`, `permission`, `permission_operator`, `column_no`, `is_minimized`, `fullscreen_url`, `is_fullscreen`, `is_active`, `is_reserved`, `weight`) VALUES (1,1,'blog','CiviCRM News','civicrm/dashlet/blog?reset=1&snippet=5','access CiviCRM',NULL,0,0,'civicrm/dashlet/blog?reset=1&snippet=5&context=dashletFullscreen',1,1,1,0),(2,1,'getting-started','Getting Started','civicrm/dashlet/getting-started?reset=1&snippet=5','access CiviCRM',NULL,0,0,'civicrm/dashlet/getting-started?reset=1&snippet=5&context=dashletFullscreen',1,1,1,0),(3,1,'activity','Activities','civicrm/dashlet/activity?reset=1&snippet=5','access CiviCRM',NULL,0,0,'civicrm/dashlet/activity?reset=1&snippet=5&context=dashletFullscreen',1,1,1,1),(4,1,'myCases','My Cases','civicrm/dashlet/myCases?reset=1&snippet=5','access my cases and activities',NULL,0,0,'civicrm/dashlet/myCases?reset=1&snippet=5&context=dashletFullscreen',1,1,1,2),(5,1,'allCases','All Cases','civicrm/dashlet/allCases?reset=1&snippet=5','access all cases and activities',NULL,0,0,'civicrm/dashlet/allCases?reset=1&snippet=5&context=dashletFullscreen',1,1,1,3),(6,1,'casedashboard','Case Dashboard Dashlet','civicrm/dashlet/casedashboard?reset=1&snippet=5','access my cases and activities,access all cases and activities','OR',0,0,'civicrm/dashlet/casedashboard?reset=1&snippet=5&context=dashletFullscreen',1,1,1,4),(7,1,'report/7','Donor Summary','civicrm/report/instance/7?reset=1§ion=2&snippet=5&charts=barChart','access CiviContribute','AND',0,0,'civicrm/report/instance/7?reset=1§ion=2&snippet=5&charts=barChart&context=dashletFullscreen',1,1,0,4),(8,1,'report/14','Top Donors','civicrm/report/instance/14?reset=1§ion=2&snippet=5','access CiviContribute','AND',0,0,'civicrm/report/instance/14?reset=1§ion=2&snippet=5&context=dashletFullscreen',1,1,0,5),(9,1,'report/27','Event Income Summary','civicrm/report/instance/27?reset=1§ion=2&snippet=5&charts=pieChart','access CiviEvent','AND',0,0,'civicrm/report/instance/27?reset=1§ion=2&snippet=5&charts=pieChart&context=dashletFullscreen',1,1,0,6),(10,1,'report/22','Membership Summary','civicrm/report/instance/22?reset=1§ion=2&snippet=5','access CiviMember','AND',0,0,'civicrm/report/instance/22?reset=1§ion=2&snippet=5&context=dashletFullscreen',1,1,0,7); +INSERT INTO `civicrm_dashboard` (`id`, `domain_id`, `name`, `label`, `url`, `permission`, `permission_operator`, `column_no`, `is_minimized`, `fullscreen_url`, `is_fullscreen`, `is_active`, `is_reserved`, `weight`) VALUES (1,1,'blog','CiviCRM News','civicrm/dashlet/blog?reset=1&snippet=5','access CiviCRM',NULL,0,0,'civicrm/dashlet/blog?reset=1&snippet=5&context=dashletFullscreen',1,1,1,0),(2,1,'getting-started','Getting Started','civicrm/dashlet/getting-started?reset=1&snippet=5','access CiviCRM',NULL,0,0,'civicrm/dashlet/getting-started?reset=1&snippet=5&context=dashletFullscreen',1,1,1,0),(3,1,'activity','Activities','civicrm/dashlet/activity?reset=1&snippet=5','access CiviCRM',NULL,0,0,'civicrm/dashlet/activity?reset=1&snippet=5&context=dashletFullscreen',1,1,1,1),(4,1,'myCases','My Cases','civicrm/dashlet/myCases?reset=1&snippet=5','access my cases and activities',NULL,0,0,'civicrm/dashlet/myCases?reset=1&snippet=5&context=dashletFullscreen',1,1,1,2),(5,1,'allCases','All Cases','civicrm/dashlet/allCases?reset=1&snippet=5','access all cases and activities',NULL,0,0,'civicrm/dashlet/allCases?reset=1&snippet=5&context=dashletFullscreen',1,1,1,3),(6,1,'casedashboard','Case Dashboard Dashlet','civicrm/dashlet/casedashboard?reset=1&snippet=5','access my cases and activities,access all cases and activities','OR',0,0,'civicrm/dashlet/casedashboard?reset=1&snippet=5&context=dashletFullscreen',1,1,1,4),(7,1,'report/7','Donor Summary','civicrm/report/instance/7?reset=1§ion=1&snippet=5&charts=barChart','access CiviContribute','AND',0,0,'civicrm/report/instance/7?reset=1§ion=1&snippet=5&charts=barChart&context=dashletFullscreen',1,1,0,4),(8,1,'report/14','Top Donors','civicrm/report/instance/14?reset=1§ion=2&snippet=5','access CiviContribute','AND',0,0,'civicrm/report/instance/14?reset=1§ion=2&snippet=5&context=dashletFullscreen',1,1,0,5),(9,1,'report/27','Event Income Summary','civicrm/report/instance/27?reset=1§ion=1&snippet=5&charts=pieChart','access CiviEvent','AND',0,0,'civicrm/report/instance/27?reset=1§ion=1&snippet=5&charts=pieChart&context=dashletFullscreen',1,1,0,6),(10,1,'report/22','Membership Summary','civicrm/report/instance/22?reset=1§ion=2&snippet=5','access CiviMember','AND',0,0,'civicrm/report/instance/22?reset=1§ion=2&snippet=5&context=dashletFullscreen',1,1,0,7); /*!40000 ALTER TABLE `civicrm_dashboard` ENABLE KEYS */; UNLOCK TABLES; diff --git a/xml/templates/civicrm_sample.tpl b/xml/templates/civicrm_sample.tpl index b791cdfba3..e0cdf57849 100644 --- a/xml/templates/civicrm_sample.tpl +++ b/xml/templates/civicrm_sample.tpl @@ -137,9 +137,9 @@ INSERT INTO `civicrm_contact_type` INSERT INTO `civicrm_dashboard` ( `domain_id`, `name`, `label`, `url`, `permission`, `permission_operator`, `column_no`, `is_minimized`, `is_active`, `weight`, `is_fullscreen`, `fullscreen_url`) VALUES - ( @domain_id, 'report/7', '{ts escape="sql"}Donor Summary{/ts}' , 'civicrm/report/instance/7?reset=1§ion=2&snippet=5&charts=barChart', 'access CiviContribute', 'AND', 0, 0,'1', 4, '1', 'civicrm/report/instance/7?reset=1§ion=2&snippet=5&charts=barChart&context=dashletFullscreen'), + ( @domain_id, 'report/7', '{ts escape="sql"}Donor Summary{/ts}' , 'civicrm/report/instance/7?reset=1§ion=1&snippet=5&charts=barChart', 'access CiviContribute', 'AND', 0, 0,'1', 4, '1', 'civicrm/report/instance/7?reset=1§ion=1&snippet=5&charts=barChart&context=dashletFullscreen'), ( @domain_id, 'report/14', '{ts escape="sql"}Top Donors{/ts}' , 'civicrm/report/instance/14?reset=1§ion=2&snippet=5', 'access CiviContribute', 'AND', 0, 0,'1', 5, '1', 'civicrm/report/instance/14?reset=1§ion=2&snippet=5&context=dashletFullscreen'), - ( @domain_id, 'report/27', '{ts escape="sql"}Event Income Summary{/ts}', 'civicrm/report/instance/27?reset=1§ion=2&snippet=5&charts=pieChart', 'access CiviEvent' , 'AND', 0, 0,'1', 6, '1', 'civicrm/report/instance/27?reset=1§ion=2&snippet=5&charts=pieChart&context=dashletFullscreen'), + ( @domain_id, 'report/27', '{ts escape="sql"}Event Income Summary{/ts}', 'civicrm/report/instance/27?reset=1§ion=1&snippet=5&charts=pieChart', 'access CiviEvent' , 'AND', 0, 0,'1', 6, '1', 'civicrm/report/instance/27?reset=1§ion=1&snippet=5&charts=pieChart&context=dashletFullscreen'), ( @domain_id, 'report/22', '{ts escape="sql"}Membership Summary{/ts}' , 'civicrm/report/instance/22?reset=1§ion=2&snippet=5', 'access CiviMember' , 'AND', 0, 0,'1', 7, '1', 'civicrm/report/instance/22?reset=1§ion=2&snippet=5&context=dashletFullscreen'); -- INSERT sample data for membership -- 2.25.1