-- Add sample dashlets
INSERT INTO `civicrm_dashboard`
- ( `domain_id`, `label`, `url`, `permission`, `permission_operator`, `column_no`, `is_minimized`, `is_active`, `weight`, `is_fullscreen`, `fullscreen_url`)
+ ( `domain_id`, `name`, `label`, `url`, `permission`, `permission_operator`, `column_no`, `is_minimized`, `is_active`, `weight`, `is_fullscreen`, `fullscreen_url`)
VALUES
- ( @domain_id, '{ts escape="sql"}Donor Summary{/ts}' , 'civicrm/report/instance/6&reset=1§ion=1&snippet=5&charts=barChart', 'access CiviContribute', 'AND', 0, 0,'1', 4, '1', 'civicrm/report/instance/6&reset=1§ion=1&snippet=5&charts=barChart&context=dashletFullscreen'),
- ( @domain_id, '{ts escape="sql"}Top Donors{/ts}' , 'civicrm/report/instance/13&reset=1§ion=2&snippet=5', 'access CiviContribute', 'AND', 0, 0,'1', 5, '1', 'civicrm/report/instance/13&reset=1§ion=2&snippet=5&context=dashletFullscreen'),
- ( @domain_id, '{ts escape="sql"}Event Income Summary{/ts}', 'civicrm/report/instance/25&reset=1§ion=1&snippet=5&charts=pieChart', 'access CiviEvent' , 'AND', 0, 0,'1', 6, '1', 'civicrm/report/instance/25&reset=1§ion=1&snippet=5&charts=pieChart&context=dashletFullscreen'),
- ( @domain_id, '{ts escape="sql"}Membership Summary{/ts}' , 'civicrm/report/instance/20&reset=1§ion=2&snippet=5', 'access CiviMember' , 'AND', 0, 0,'1', 7, '1', 'civicrm/report/instance/20&reset=1§ion=2&snippet=5&context=dashletFullscreen');
+ ( @domain_id, 'report/6', '{ts escape="sql"}Donor Summary{/ts}' , 'civicrm/report/instance/6&reset=1§ion=1&snippet=5&charts=barChart', 'access CiviContribute', 'AND', 0, 0,'1', 4, '1', 'civicrm/report/instance/6&reset=1§ion=1&snippet=5&charts=barChart&context=dashletFullscreen'),
+ ( @domain_id, 'report/13', '{ts escape="sql"}Top Donors{/ts}' , 'civicrm/report/instance/13&reset=1§ion=2&snippet=5', 'access CiviContribute', 'AND', 0, 0,'1', 5, '1', 'civicrm/report/instance/13&reset=1§ion=2&snippet=5&context=dashletFullscreen'),
+ ( @domain_id, 'report/25', '{ts escape="sql"}Event Income Summary{/ts}', 'civicrm/report/instance/25&reset=1§ion=1&snippet=5&charts=pieChart', 'access CiviEvent' , 'AND', 0, 0,'1', 6, '1', 'civicrm/report/instance/25&reset=1§ion=1&snippet=5&charts=pieChart&context=dashletFullscreen'),
+ ( @domain_id, 'report/20', '{ts escape="sql"}Membership Summary{/ts}' , 'civicrm/report/instance/20&reset=1§ion=2&snippet=5', 'access CiviMember' , 'AND', 0, 0,'1', 7, '1', 'civicrm/report/instance/20&reset=1§ion=2&snippet=5&context=dashletFullscreen');
-- INSERT sample data for membership
(@priceFieldID,'tenor','Tenor','40',2,1,0,2),
(@priceFieldID,'soprano','Soprano','50',3,1,0,2);
-INSERT INTO civicrm_print_label (title, name, description, label_format_name, label_type_id, is_default, is_reserved, is_active, data)
-VALUES
- ('Annual Conference Hanging Badge (Avery 5395)', 'Annual_Conference_Hanging_Badge', 'For our annual conference', 'Avery 5395', 1, 1, 1, 1, '{literal}{"title":"Annual Conference Hanging Badge (Avery 5395)","label_format_name":"Avery 5395","description":"For our annual conference","token":{"1":"{event.title}","2":"{contact.display_name}","3":"{contact.current_employer}","4":"{event.start_date}"},"font_name":{"1":"dejavusans","2":"dejavusans","3":"dejavusans","4":"dejavusans"},"font_size":{"1":"9","2":"20","3":"15","4":"9"},"text_alignment":{"1":"L","2":"C","3":"C","4":"R"},"barcode_alignment":"R","image_1":"","image_2":"","is_default":"1","is_active":"1","is_reserved":"1"}{/literal}' );
-