Array
(
    [sql] => 
    SELECT t1.*, 
    ROUND((val_presence*0.5) + (val_upfreq*0.25) + (val_machine_readable*0.25), 2) as c_index
    FROM (
        SELECT t0.main_category, t0.subcategory, t0.country, t0.country_name, t0.id_main_category, t0.sub_sort_ord,
                COALESCE(dr.n_indicators,0) n_indicators , 
                COALESCE(dr.presence, 0) presence,  
                COALESCE(dr.val_presence, 0) val_presence,
                COALESCE(dr.val_upfreq, 0) val_upfreq,
                COALESCE(dr.val_machine_readable, 0) val_machine_readable
            FROM (
                SELECT dgm.main_category, dgm.subcategory, dgm.country, cn.country_name, id_main_category,  dgm.sub_sort_ord
                FROM dgm
                INNER JOIN country cn ON cn.abbr = dgm.country
                WHERE dgm.rev_last = 1
                AND visible_subcategory = 1
                GROUP BY id_main_category, main_category, subcategory, country
                ORDER BY id_main_category, main_category, subcategory, country)
                t0 
            LEFT JOIN data_rank dr 
                ON dr.main_category = t0.main_category
                AND dr.subcategory = t0.subcategory
                AND dr.country = t0.country
                AND year=?
        ) t1 
    ORDER BY id_main_category, sub_sort_ord, main_category, subcategory, country_name
               
    [params] => Array
        (
            [0] => 2020
        )

    [errno] => SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dguptake.dgm.sub_sort_ord' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)
<br />
<b>Deprecated</b>:  Creation of dynamic property DataCountryTopic::$vmsql is deprecated in <b>/var/www/vhosts/dgmonitor/classes/src/DataCountryTopic.php</b> on line <b>35</b><br />
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => eid
            [1] => 1020
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => eid
            [1] => 1030
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => eid
            [1] => 1010
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => eid
            [1] => 1050
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /var/www/vhosts/dgmonitor/classes/src/DbException.php:28) in <b>/var/www/vhosts/dgmonitor/classes/src/Rpc.php</b> on line <b>18</b><br />
{"main_category":{"id_main_category":1000,"main_category":"eID","visible":1,"sort_order":1,"summary":"Indicators for this topic focus on mapping the use of the national system for electronic identification and authentication of citizens and businesses, in order to access public and private services and perform transactions. \n\neID is measured by assessing the yearly numbers of cumulative registered users, digital proxy activations, realised transactions, downloaded and installed mobile applications, cumulative adhered public and private organisations and services, and eID providers."},"country":{"abbr":"PT","country_name":"Portugal","summary":"<p><strong>eID<\/strong>.With its <a href=\"https:\/\/joinup.ec.europa.eu\/collection\/portuguese-egovernment-solutions\/news\/portugals-pioneering-eid-solutions\">Citizen Card<\/a>, Portugal started implementing its digital identity scheme in 2007, being one of the first countries to combine five different identification numbers in one card and introduce digital certificates. In 2014, the Digital Mobile Key was introduced. An eID user can obtain professional attributes (SCAP functionality) to act on behalf of a company. The eID system doesn&rsquo;t include a digital proxy service.<\/p>\n<p><strong>ePayment <\/strong>The <a href=\"https:\/\/www.iap.gov.pt\/web\/iap\/plataforma-de-pagamentos\">Payment Platform PPAP<\/a> is the system that allows multiple payment methods to be made available on government websites and digital services, ensuring the management, control and monitoring of receipts in an integrated manner.&nbsp;<\/p>\n<p><strong>Messaging <\/strong>The <a href=\"https:\/\/eportugal.gov.pt\/en\/notificacoes-eletronicas\/ajuda-notificacoes-eletronicas\">Public Service of Electronic Notifications<\/a> allows citizens and company representatives to receive online notifications sent by public entities, through the Electronic Notification Platform. This platform is available on the ePortugal portal and through a mobile application. The <a href=\"https:\/\/www.iap.gov.pt\/web\/iap\/plataforma-gateway-de-mensagens\">Messaging Platform GAP<\/a> enables the sending and receiving of SMS between citizens and public administrations.<\/p>\n<p><strong>Transparency <\/strong>The <a href=\"https:\/\/www.iap.gov.pt\/web\/iap\/inicio\">Interoperability Platform IAP<\/a> authentication provider allows users to authenticate with the Citizen Card, on websites or portals duly accredited and authorized for that purpose. Through this functionality it is possible for the citizen to <a href=\"https:\/\/www.iap.gov.pt\/web\/iap\/perguntas-frequentes\">authorize the online consultation of certain data<\/a> with perfect knowledge of the purpose of the consultation and the data consulted.<\/p>\n<p><strong>General Digital Services <\/strong>The <a href=\"https:\/\/eportugal.gov.pt\/en\/servicos\">ePortugal portal<\/a> lists several services that are digitally available. No systematic measurement of user satisfaction has been found.<\/p>\n<p><br \/>Currently, no public data is available on user satisfaction and digital form submission in Portugal. The <em>Digital Government MetaMonitor<\/em> records data in all other categories. Improvements can be made, especially with regards to machine readability and update frequency.<\/p>"},"subc":[{"id_subcategory":1020,"subcategory":"Overall uptake"},{"id_subcategory":1030,"subcategory":"Personal uptake"},{"id_subcategory":1010,"subcategory":"Business uptake"},{"id_subcategory":1050,"subcategory":"Public sector uptake"},{"id_subcategory":1040,"subcategory":"Private sector support"}],"timestamp":"2025-06-01T21:14:04+00:00"}