Politica
Valutazione attuale: / 0
- Dettagli
-
31
Ago
2016
Valutazione attuale: / 0
-
Ultima modifica il Giovedì, 01 Settembre 2016 05:46
-
Pubblicato Giovedì, 01 Settembre 2016 05:46
-
Scritto da la redazione
-
Visite: 853
Trasformare i buoni cartacei che la Regione Puglia riconosce ai circa 11.000 cittadini celiaci pugliesi in tessere elettroniche consentendo un risparmio stimato in circa 400.000€, assicurando strumenti più efficaci di gestione, libertà negli acquisiti, verifica e monitoraggio delle prestazioni erogate, e liberando risorse umane ed economiche che potrebbero essere destinate ad interventi a favore del miglioramento dei servizi per il paziente celiaco. Questo l’obiettivo di una mozione presentata dal consigliere regionale M5S Mario Conca, mozione che chiede altresì che la Giunta regionale porti all’attenzione della Conferenza delle Regioni e delle Province autonome sia la questione relativa all’allineamento tra i sessi del valore dei buoni per l’acquisto di prodotti per celiaci, sia la necessità di dotare il soggetto affetto da celiachia di un codice personale valido su tutto il territorio nazionale da inserire elettronicamente nella tessera sanitaria o altro sistema informatico.
"In Puglia, infatti, l'attribuzione dei buoni mensili ai pazienti aventi diritto è ancora subordinata alla documentazione cartacea – dichiara Mario Conca (M5S) - con conseguente spreco di risorse e disagi per chi beneficia del servizio. È quindi necessario procedere, entro gennaio 2017, alla dematerializzazione dei buoni cartacei mediante utilizzo di strumenti elettronici onde evitare i problemi derivanti da stampa, distribuzione, rendicontazione manuale, custodia, inquinamento ambientale, etc. Tale procedura è già in atto in altre regioni italiane, tra cui le vicine Basilicata e Umbria, e garantisce la sostenibilità dell'assistenza alla terapia dei celiaci con indubbi vantaggi per tutti gli attori coinvolti nel processo.”
I circa 11 mila pugliesi affetti da celiachia percepiscono buoni per un ammontare complessivo di 15 milioni di euro l'anno, una cifra importante che oggi non consente ai pazienti di essere liberi nello spenderli. Ogni cittadino celiaco pugliese riceve mensilmente un buono cartaceo di importo pari ad euro 140,00 euro per gli uomini (dai 10 anni in su) ed euro 110,00 per le donne (dai 10 anni in su), divisi rispettivamente in 4 parti di 35 euro per gli uomini e in 3 parti da 27,00 euro + 1 parte da 29,00 per le donne. Il valore di ogni singola parte del buono non è ulteriormente frazionabile, per cui l’avente diritto è costretto a spendere la cifra indicata (35 o 27 o 29 euro) in un’unica soluzione presso lo stesso punto vendita o farmacia.
“Attraverso un software collegato al sistema sanitario regionale – prosegue Conca - in Puglia il sistema EDOTTO è già predisposto per la gestione di tale processo, che metta in rete la struttura sanitaria con i punti vendita convenzionati e i pazienti, si consentirebbe all’utente di accedere direttamente ai propri buoni, visualizzare il credito disponibile sulla propria tessera sanitaria o altra carta magnetica e utilizzarlo immediatamente per i relativi acquisti di prodotti alimentari presso i punti vendita convenzionati (farmacia, negozi, G.d.O.). In tal modo il credito verrebbe scalato ad ogni spesa, sì che non dovrà essere rispettata la spesa minima e gli acquisti potranno essere effettuati su tutto il territorio regionale. La tecnologia – conclude - è utile se viene utilizzata, non perdiamo altro tempo.”
Console Debug Joomla!
password_clear ⇒
groups ⇒
limittype ⇒ 0
leadingMax ⇒ 750
introMax ⇒ 500
Ignore_Existing_Read_More ⇒ 0
Strip_Formatting ⇒ 0
wrap_output ⇒ 0
wrap_output_template ⇒ %OUTPUT%
Enabled_Front_Page ⇒ 1
add_trimming_dots ⇒ 0
trimming_dots ⇒ ...
categories_switch ⇒ 0
categories ⇒
articles_switch ⇒ 0
debug ⇒ 0
Thumbnails ⇒ 0
Thumbnails_Class ⇒
Strip_Image_Formatting ⇒ 0
Force_Image_Handle ⇒ 0
csscode ⇒ .margin-h-8 {margin:8px;}
session.token ⇒ 8e8172aef11dd797f89a442fc9fb30d5
7.98 MB (8,371,584 Bytes)
44 query eseguite
SELECT `data`
FROM `koul8_session`
WHERE `session_id` = '57d28885d43ffc1f9ad142c35f4b25b4'
DELETE
FROM `koul8_session`
WHERE `time` < '1714323499'
SELECT `session_id`
FROM `koul8_session`
WHERE `session_id` = '57d28885d43ffc1f9ad142c35f4b25b4'
LIMIT 0, 1
INSERT INTO `koul8_session`
(`session_id`, `client_id`, `time`)
VALUES
('57d28885d43ffc1f9ad142c35f4b25b4', 0, '1714330699')
SELECT extension_id AS id, element AS "option", params, enabled
FROM koul8_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM koul8_usergroups AS a
LEFT JOIN koul8_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `koul8_viewlevels`
SELECT folder AS type, element AS name, params
FROM koul8_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM koul8_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT extension_id AS id, element AS "option", params, enabled
FROM koul8_extensions
WHERE `type` = 'component'
AND `element` = 'com_autotweet'
SELECT `custom_data`
FROM `koul8_extensions`
WHERE `type` = 'component'
AND `element` = 'com_sef'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component
FROM koul8_menu AS m
LEFT JOIN koul8_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT a.rules
FROM koul8_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM koul8_assets AS a
LEFT JOIN koul8_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT id, home, template, s.params
FROM koul8_template_styles as s
LEFT JOIN koul8_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 = 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM koul8_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT *
FROM koul8_languages
WHERE published=1
ORDER BY ordering ASC
SELECT b.rules
FROM koul8_assets AS a
LEFT JOIN koul8_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
SELECT MAX(contact.id) AS id
FROM koul8_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM koul8_content AS a
LEFT JOIN koul8_categories AS c
on c.id = a.catid
LEFT JOIN koul8_users AS u
on u.id = a.created_by
LEFT JOIN koul8_categories as parent
ON parent.id = c.parent_id
LEFT JOIN koul8_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM koul8_categories AS cat JOIN koul8_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 8387
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-28 18:58:19')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-28 18:58:19')
AND (a.state = 1 OR a.state =2)
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM koul8_categories as c
LEFT JOIN koul8_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM koul8_categories AS cat JOIN koul8_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=67
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT `id`
FROM `koul8_users`
WHERE `username` = 'guest'
LIMIT 0, 1
SELECT b.rules
FROM koul8_assets AS a
LEFT JOIN koul8_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.category.34')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SHOW FULL COLUMNS
FROM `koul8_assets`
SELECT id
FROM koul8_assets
WHERE parent_id = 0
SELECT rules
FROM koul8_assets
WHERE id = '1'
SHOW FULL COLUMNS
FROM `koul8_content`
SELECT (catid) As Expr1
FROM koul8_content
WHERE (id=8387)
SHOW FULL COLUMNS
FROM `koul8_users`
SELECT *
FROM `koul8_users`
WHERE `id` = 43
SELECT `g`.`id`,`g`.`title`
FROM `koul8_usergroups` AS g
INNER JOIN `koul8_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 43
SELECT b.id
FROM koul8_user_usergroup_map AS map
LEFT JOIN koul8_usergroups AS a
ON a.id = map.group_id
LEFT JOIN koul8_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE map.user_id = 43
SELECT a.rules
FROM koul8_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT a.*,c.access AS category_access
FROM koul8_content AS a
LEFT JOIN koul8_categories AS c
on c.id = a.catid
WHERE a.id = 8387
SELECT (catid) As Expr1
FROM koul8_content
WHERE (id=8387)
SELECT Count(*) As Expr1
FROM ((koul8_content AS c
LEFT JOIN koul8_users AS u
ON u.id=c.created_by)
LEFT JOIN koul8_content AS ar
ON c.parentid=ar.id)
LEFT JOIN koul8_users AS aru
ON aru.id=ar.created_by
WHERE (c.catid=34)
AND (c.access IN (1,1))
AND (ar.access IN (1,1))
AND c.parentid=8387
AND c.state = 1
UPDATE koul8_content
SET hits = hits + 1
WHERE id = 8387
SHOW TABLES
SHOW FULL COLUMNS
FROM `koul8_autotweet_automator`
SELECT koul8_autotweet_automator.*
FROM koul8_autotweet_automator
WHERE `koul8_autotweet_automator`.`plugin` = 'automator'
SELECT koul8_autotweet_automator.*
FROM koul8_autotweet_automator
WHERE `koul8_autotweet_automator`.`id` = '1'
SELECT koul8_autotweet_automator.*
FROM koul8_autotweet_automator
WHERE `koul8_autotweet_automator`.`plugin` = 'content'
SELECT koul8_autotweet_automator.*
FROM koul8_autotweet_automator
WHERE `koul8_autotweet_automator`.`id` = '2'
SELECT images
FROM `koul8_content`
WHERE `id` = '8387'
UPDATE `koul8_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714330699;s:18:\"session.timer.last\";i:1714330699;s:17:\"session.timer.now\";i:1714330699;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:25:\"autoreadmoreDefaultParams\";a:19:{s:9:\"limittype\";s:1:\"0\";s:10:\"leadingMax\";s:3:\"750\";s:8:\"introMax\";s:3:\"500\";s:25:\"Ignore_Existing_Read_More\";s:1:\"0\";s:16:\"Strip_Formatting\";s:1:\"0\";s:11:\"wrap_output\";s:1:\"0\";s:20:\"wrap_output_template\";s:40:\"<div class=\"autoreadmore\">%OUTPUT%</div>\";s:18:\"Enabled_Front_Page\";s:1:\"1\";s:17:\"add_trimming_dots\";s:1:\"0\";s:13:\"trimming_dots\";s:3:\"...\";s:17:\"categories_switch\";s:1:\"0\";s:10:\"categories\";s:0:\"\";s:15:\"articles_switch\";s:1:\"0\";s:5:\"debug\";s:1:\"0\";s:10:\"Thumbnails\";s:1:\"0\";s:16:\"Thumbnails_Class\";s:0:\"\";s:22:\"Strip_Image_Formatting\";s:1:\"0\";s:18:\"Force_Image_Handle\";s:1:\"0\";s:7:\"csscode\";s:25:\".margin-h-8 {margin:8px;}\";}s:13:\"session.token\";s:32:\"8e8172aef11dd797f89a442fc9fb30d5\";}'
, `time` = '1714330700'
WHERE `session_id` = '57d28885d43ffc1f9ad142c35f4b25b4'
34 tipi di query eseguite, ordinate per Occurrences
Tabelle SELECT:
4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM koul8_extensions
4 × SELECT koul8_autotweet_automator.*
FROM koul8_autotweet_automator
3 × SELECT b.rules
FROM koul8_assets AS a
LEFT JOIN koul8_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
2 × SELECT (catid) As Expr1
FROM koul8_content
2 × SELECT a.rules
FROM koul8_assets AS a
1 × SELECT *
FROM `koul8_users`
1 × SELECT rules
FROM koul8_assets
1 × SELECT id
FROM koul8_assets
1 × SELECT b.id
FROM koul8_user_usergroup_map AS map
LEFT JOIN koul8_usergroups AS a
ON a.id = map.group_id
LEFT JOIN koul8_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT images
FROM `koul8_content`
1 × SELECT Count(*) As Expr1
FROM ((koul8_content AS c
LEFT JOIN koul8_users AS u
ON u.id=c.created_by)
LEFT JOIN koul8_content AS ar
ON c.parentid=ar.id)
LEFT JOIN koul8_users AS aru
ON aru.id=ar.created_by
1 × SELECT a.*,c.access AS category_access
FROM koul8_content AS a
LEFT JOIN koul8_categories AS c
on c.id = a.catid
1 × SELECT `id`
FROM `koul8_users`
1 × SELECT `g`.`id`,`g`.`title`
FROM `koul8_usergroups` AS g
INNER JOIN `koul8_user_usergroup_map` AS m
ON m.group_id = g.id
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
FROM koul8_contact_details AS contact
1 × SELECT folder AS type, element AS name, params
FROM koul8_extensions
1 × SELECT id, rules
FROM `koul8_viewlevels
1 × SELECT b.id
FROM koul8_usergroups AS a
LEFT JOIN koul8_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `koul8_session`
1 × SELECT `custom_data`
FROM `koul8_extensions`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component
FROM koul8_menu AS m
LEFT JOIN koul8_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `data`
FROM `koul8_session`
1 × SELECT *
FROM koul8_languages
1 × SELECT id, home, template, s.params
FROM koul8_template_styles as s
LEFT JOIN koul8_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM koul8_categories as c
LEFT JOIN koul8_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM koul8_categories AS cat JOIN koul8_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
ALTRE tabelle:
1 × SHOW TABLE
1 × SHOW FULL COLUMNS
FROM `koul8_autotweet_automator
1 × UPDATE `koul8_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714330699;s:18:\"session.timer.last\";i:1714330699;s:17:\"session.timer.now\";i:1714330699;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:25:\"autoreadmoreDefaultParams\";a:19:{s:9:\"limittype\";s:1:\"0\";s:10:\"leadingMax\";s:3:\"750\";s:8:\"introMax\";s:3:\"500\";s:25:\"Ignore_Existing_Read_More\";s:1:\"0\";s:16:\"Strip_Formatting\";s:1:\"0\";s:11:\"wrap_output\";s:1:\"0\";s:20:\"wrap_output_template\";s:40:\"<div class=\"autoreadmore\">%OUTPUT%</div>\";s:18:\"Enabled_Front_Page\";s:1:\"1\";s:17:\"add_trimming_dots\";s:1:\"0\";s:13:\"trimming_dots\";s:3:\"...\";s:17:\"categories_switch\";s:1:\"0\";s:10:\"categories\";s:0:\"\";s:15:\"articles_switch\";s:1:\"0\";s:5:\"debug\";s:1:\"0\";s:10:\"Thumbnails\";s:1:\"0\";s:16:\"Thumbnails_Class\";s:0:\"\";s:22:\"Strip_Image_Formatting\";s:1:\"0\";s:18:\"Force_Image_Handle\";s:1:\"0\";s:7:\"csscode\";s:25:\".margin-h-8 {margin:8px;}\";}s:13:\"session.token\";s:32:\"8e8172aef11dd797f89a442fc9fb30d5\";}' , `time` = '1714330700'
1 × UPDATE koul8_content
SET hits = hits + 1
1 × SHOW FULL COLUMNS
FROM `koul8_users
1 × INSERT INTO `koul8_session` (`session_id`, `client_id`, `time`)
VALUES ('57d28885d43ffc1f9ad142c35f4b25b4', 0, '1714330699'
1 × SHOW FULL COLUMNS
FROM `koul8_assets
1 × SHOW FULL COLUMNS
FROM `koul8_content
1 × DELETE
FROM `koul8_session`