Wir haben die Wahl. Politische neutrale Plattform zur Förderung demokratischer Rechte

Wirbestimmen

Listet die aktuellen Volksinitiativen, Referenden und Petitionen. Ermöglicht es, die Unterschriftsbögen der Volksinitiativen runterzuladen und sich als Interessent einzuschreiben.
Image
Kunde
Freiheitliche Bewegung Schweiz
Datum
17. April 2022
Erbrachte Dienstleistungen
Einbau neuer Volksinitiativen
Automatisierung von repetitiven Aufgaben
Vereinfachung des Seitenaufbaus
Migration der Plattform auf neue Joomla-Version
Image
Image

Die Ziele

Erweiterung, Aktualisierung, Stabilisierung und Zukunftssicherung der demokratischen Plattform
Einwandfreies Funktionieren der angebotenen Dienste
Lorem ipsum dolor sit amet
Vereinfachen von zeitaufwändigen Arbeitsschritten
Abhändigkeit von bisherigen Mitarbeiter reduzieren

Die Herausforderung

Die vorgefundene Plattform hat eine grosse Menge von Formularen beheimatet, die für jede Volkinitiative und jede Sprache dupliziert und minimal angepasst wurde.  

Our Approach

Design und Programmierung
Durch die konsequente Ausnutzung von Internationalisierungs-Funktionen, Vereinheitlichungen und saubere Programmierung ist es uns gelungen, die Anzahl der Formularseiten auf ca. 10 zu reduzieren. Die Einführung von Metadaten erlaubte es, manche Seiten dynamisch aufzubereiten und den Pflegeaufwand der Plattform zu verringern.
Image
Image

Wollen Sie mit uns ihr Projekt besprechen

26.826MBMemory Usage341msRequest Duration
Joomla! Version4.4.9
PHP Version8.1.31
Identityguest
Response200
Templateshaper_helixultimate
Database
Server
mysql
Version
10.11.10-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:3 [ "id" => "7" "option" => "com_sppagebuilder" "view" => "page" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:45 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744047526 "last" => 1744047526...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.09MB) (32.43ms)
  • afterInitialise (7.56MB) (78.15ms)
  • afterRoute (1.79MB) (20.86ms)
  • beforeRenderComponent com_sppagebuilder (709.5KB) (9.48ms)
  • Before Access::preloadComponents (all components) (1.52MB) (10.22ms)
  • After Access::preloadComponents (all components) (97.91KB) (768μs)
  • Before Access::getAssetRules (id:91 name:com_sppagebuilder) (2.43KB) (31μs)
  • After Access::getAssetRules (id:91 name:com_sppagebuilder) (26.67KB) (406μs)
  • Before Access::preloadPermissions (com_sppagebuilder) (445.1KB) (8.07ms)
  • After Access::preloadPermissions (com_sppagebuilder) (17.19KB) (416μs)
  • afterRenderComponent com_sppagebuilder (6.22MB) (120ms)
  • afterDispatch (167.21KB) (1.73ms)
  • beforeRenderRawModule mod_menu (Main Menu) (2.37MB) (27.77ms)
  • afterRenderRawModule mod_menu (Main Menu) (243.67KB) (9.12ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (7μs)
  • Before Access::getAssetRules (id:1 name:root.1) (421.95KB) (5.93ms)
  • After Access::getAssetRules (id:1 name:root.1) (1.59KB) (14μs)
  • afterRenderModule mod_menu (Main Menu) (88.97KB) (981μs)
  • afterRender (544.66KB) (13.69ms)
  • 1 x afterRenderComponent com_sppagebuilder (6.22MB) (35.22%)
    120.07ms
    1 x afterInitialise (7.56MB) (22.92%)
    78.15ms
    1 x afterLoad (4.09MB) (9.51%)
    32.43ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (2.37MB) (8.14%)
    27.77ms
    1 x afterRoute (1.79MB) (6.12%)
    20.86ms
    1 x afterRender (544.66KB) (4.01%)
    13.69ms
    1 x Before Access::preloadComponents (all components) (1.52MB) (3%)
    10.22ms
    1 x beforeRenderComponent com_sppagebuilder (709.5KB) (2.78%)
    9.48ms
    1 x afterRenderRawModule mod_menu (Main Menu) (243.67KB) (2.68%)
    9.12ms
    1 x Before Access::preloadPermissions (com_sppagebuilder) (445.1KB) (2.37%)
    8.07ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (421.95KB) (1.74%)
    5.93ms
    1 x afterDispatch (167.21KB) (0.51%)
    1.73ms
    1 x afterRenderModule mod_menu (Main Menu) (88.97KB) (0.29%)
    981μs
    1 x After Access::preloadComponents (all components) (97.91KB) (0.23%)
    768μs
    1 x After Access::preloadPermissions (com_sppagebuilder) (17.19KB) (0.12%)
    416μs
    1 x After Access::getAssetRules (id:91 name:com_sppagebuilder) (26.67KB) (0.12%)
    406μs
    1 x Before Access::getAssetRules (id:91 name:com_sppagebuilder) (2.43KB) (0.01%)
    31μs
    1 x After Access::getAssetRules (id:1 name:root.1) (1.59KB) (0%)
    14μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    7μs
75 statements were executed, 51 of which were duplicates, 24 unique14.88ms1.65MB
  • SELECT @@SESSION.sql_mode;99μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `josfh_session` WHERE `session_id` = ?173μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `josfh_session` WHERE `session_id` = :session_id LIMIT 1109μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `josfh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)453μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `josfh_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1406μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `josfh_viewlevels`148μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `josfh_usergroups` AS `a` LEFT JOIN `josfh_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest196μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `josfh_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`690μs4.3KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `josfh_menu` AS `m` LEFT JOIN `josfh_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`511μs5.95KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'200μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_languages` WHERE `published` = 1 ORDER BY `ordering` ASC195μs2.22KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `josfh_template_styles` AS `s` LEFT JOIN `josfh_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1351μs33.14KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `josfh_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42)369μs7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SHOW FULL COLUMNS FROM `josfh_sppagebuilder`658μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `josfh_sppagebuilder` WHERE `id` = '7'427μs188.06KB/libraries/src/Table/Table.php:755Copy
  • UPDATE `josfh_sppagebuilder` SET `hits` = (`hits` + 1) WHERE `id` = '7'420μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT a.*,l.title AS language_title,ua.name AS author_name FROM josfh_sppagebuilder as a LEFT JOIN `josfh_languages` AS l ON l.lang_code = a.language LEFT JOIN josfh_users AS ua ON ua.id = a.created_by WHERE a.id = 7 AND a.published = 1328μs190.7KB/components/com_sppagebuilder/models/page.php:83Copy
  • SELECT `id` FROM `josfh_menu` WHERE `link` LIKE '%option=com_sppagebuilder&view=page&id=7%' AND `published` = '1'172μs856B/components/com_sppagebuilder/helpers/route.php:97Copy
  • SELECT `id` FROM `josfh_menu` WHERE `link` LIKE '%option=com_sppagebuilder&view=page&id=7%' AND `published` = '1'172μs856B/components/com_sppagebuilder/helpers/route.php:97Copy
  • SELECT `id` FROM `josfh_menu` WHERE `link` LIKE '%option=com_sppagebuilder&view=page&id=7%' AND `published` = '1'155μs856B/components/com_sppagebuilder/helpers/route.php:97Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `josfh_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0216μs1.86KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `josfh_assets`544μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `josfh_assets` WHERE `name` = 'com_sppagebuilder.page.7'124μs1.2KB/libraries/src/Table/Table.php:755Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `josfh_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'163μs912B/components/com_sppagebuilder/helpers/helper.php:1048Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `josfh_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'143μs912B/components/com_sppagebuilder/helpers/helper.php:1048Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `josfh_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'142μs912B/components/com_sppagebuilder/helpers/helper.php:1048Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `josfh_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'123μs912B/components/com_sppagebuilder/helpers/helper.php:1048Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `josfh_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'119μs912B/components/com_sppagebuilder/helpers/helper.php:1048Copy
  • SELECT `a`.`name`,`a`.`css_path` FROM `josfh_sppagebuilder_assets` AS `a` WHERE `a`.`published` = 1123μs896B/components/com_sppagebuilder/helpers/helper.php:1079Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `josfh_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'128μs912B/components/com_sppagebuilder/helpers/helper.php:1048Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `josfh_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'126μs912B/components/com_sppagebuilder/helpers/helper.php:1048Copy
  • SELECT `template` FROM `josfh_template_styles` WHERE `client_id` = 0 AND `home` = 1147μs856B/components/com_sppagebuilder/parser/addon-parser.php:1018Copy
  • SELECT `template` FROM `josfh_template_styles` WHERE `client_id` = 0 AND `home` = 1163μs11.84KB/components/com_sppagebuilder/builder/classes/base.php:83Copy
  • SELECT `template` FROM `josfh_template_styles` WHERE `client_id` = 0 AND `home` = 1149μs856B/components/com_sppagebuilder/builder/classes/base.php:83Copy
  • SELECT `template` FROM `josfh_template_styles` WHERE `client_id` = 0 AND `home` = 1140μs856B/components/com_sppagebuilder/builder/classes/base.php:83Copy
  • SELECT `template` FROM `josfh_template_styles` WHERE `client_id` = 0 AND `home` = 1140μs856B/components/com_sppagebuilder/builder/classes/base.php:83Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'164μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'132μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'131μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'149μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'131μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'130μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'129μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'127μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `josfh_modules` AS `m` LEFT JOIN `josfh_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `josfh_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`415μs2.13KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'150μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'140μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'146μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'128μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'125μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'131μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'162μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'141μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'141μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'132μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'135μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'127μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'133μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'134μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'135μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'140μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'129μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'132μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'129μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'133μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'128μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'135μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'128μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'141μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'129μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'136μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `josfh_scheduler_tasks` AS `a` WHERE `a`.`state` = 1188μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `josfh_template_styles` WHERE `client_id` = 0 AND `id` = '12'134μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `session_id` FROM `josfh_session` WHERE `session_id` = ?120μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `josfh_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?486μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy
  • warningassets - No asset found for com_sppagebuilder.page.7, falling back to com_sppagebuilder
  • warningassets - No asset found for com_sppagebuilder.page.7, falling back to com_sppagebuilder