From 2c55873b471450860f519f6382065eefb5faa854 Mon Sep 17 00:00:00 2001 From: CiviCRM Date: Thu, 12 Jun 2014 19:38:13 +0530 Subject: [PATCH] fullscreen_url updation --- CRM/Upgrade/Incremental/sql/4.5.alpha2.mysql.tpl | 15 +++++++++++++++ 1 file changed, 15 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.5.alpha2.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.5.alpha2.mysql.tpl index e69de29bb2..09c0ab67de 100644 --- a/CRM/Upgrade/Incremental/sql/4.5.alpha2.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.5.alpha2.mysql.tpl @@ -0,0 +1,15 @@ +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 + (6,1,'report/6','Donor Summary','civicrm/report/instance/6?reset=1§ion=1&snippet=5&charts=barChart','access CiviContribute','AND',0,0,'civicrm/report/instance/6?reset=1§ion=1&snippet=5&charts=barChart&context=dashletFullscreen',1,1,0,4), + (7,1,'report/13','Top Donors','civicrm/report/instance/13?reset=1§ion=2&snippet=5','access CiviContribute','AND',0,0,'civicrm/report/instance/13?reset=1§ion=2&snippet=5&context=dashletFullscreen',1,1,0,5), + (8,1,'report/25','Event Income Summary','civicrm/report/instance/25?reset=1§ion=1&snippet=5&charts=pieChart','access CiviEvent','AND',0,0,'civicrm/report/instance/25?reset=1§ion=1&snippet=5&charts=pieChart&context=dashletFullscreen',1,1,0,6), + (9,1,'report/20','Membership Summary','civicrm/report/instance/20?reset=1§ion=2&snippet=5','access CiviMember','AND',0,0,'civicrm/report/instance/20?reset=1§ion=2&snippet=5&context=dashletFullscreen',1,1,0,7); + +UPDATE civicrm_dashboard + SET civicrm_dashboard.url = CONCAT(SUBSTRING(url FROM 1 FOR LOCATE('&', url) - 1), '?', SUBSTRING(url FROM LOCATE('&', url) + 1)) + WHERE civicrm_dashboard.url LIKE "%&%" AND civicrm_dashboard.url NOT LIKE "%?%"; + +UPDATE civicrm_dashboard + SET civicrm_dashboard.fullscreen_url = CONCAT(SUBSTRING(fullscreen_url FROM 1 FOR LOCATE('&', fullscreen_url) - 1), '?', SUBSTRING(fullscreen_url FROM LOCATE('&', fullscreen_url) + 1)) + WHERE civicrm_dashboard.fullscreen_url LIKE "%&%" AND civicrm_dashboard.fullscreen_url NOT LIKE "%?%"; -- 2.25.1