Cronaca
Valutazione attuale: / 0
- Dettagli
-
08
Ott
2019
Valutazione attuale: / 0
-
Ultima modifica il Martedì, 08 Ottobre 2019 14:13
-
Pubblicato Martedì, 08 Ottobre 2019 14:13
-
Scritto da LA REDAZIONE
-
Visite: 411
I sindacati e la Rsu aziendale esprimono soddisfazione
L’assessore Calculli: «Passaggio essenziale per garantire serenità ed efficienza»
Siglato il contratto collettivo integrativo dei dipendenti comunali.
La firma è arrivata in coda ai lavori della delegazione trattante, presieduta dal segretario generale comunale, Teresa Gentile. Il nuovo strumento, con le sue previsioni, sarà applicato a tutto il personale del Comune gravinese ed era da tempo atteso. L’impulso decisivo è arrivato nelle ultime settimane, nel confronto con i segretari territoriali di Cgil, Cisl e Uil e dei rappresentanti dei lavoratori eletti nella Rsu aziendale, che congiuntamente hanno predisposto la bozza di discussione ed infine raggiunto l’accordo definitivo. Attraverso il contratto collettivo integrativo, in particolare, sarà possibile procedere all’attribuzione economica degli istituti di cui al fondo risorse decentrate in favore dei dipendenti che hanno già svolto la propria attività lavorativa anche in condizioni di emergenza, a causa delle carenze di organico.
Un giudizio positivo, per il risultato raggiunto, è stato espresso dalle parti sindacali, dettesi soddisfatte «per il raggiungimento dell’obiettivo, nell’interesse generale dei dipendenti comunali, e per la disponibilità della parte datoriale e la celerità dei risultati ottenuti». Di analogo tenore il commento dell’amministrazione, che ringraziando «il nuovo segretario generale per l’impegno profuso e le rappresentanze dei lavoratori per la disponibilità al dialogo mostrata», per mezzo dell’assessore al personale Paolo Calculli manifesta anche il proprio favore «per un accordo che tutela i lavoratori, conferma la solidità delle relazioni esistenti in ambito sindacale tra parte datoriale e rappresentanze dei lavoratori e si pone, inoltre, quale ulteriore tassello nel mosaico della ricostruzione della fisionomia della macchina burocratica municipale, che presto sarà irrobustita con l’indizione di concorsi e conseguenti nuove assunzioni».
Gravina in Puglia, 8 Ottobre 2019
Ufficio Stampa
Comune di Gravina in Puglia
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 ⇒ 16604252ccfb734c13223fb5abdf732d
7.96 MB (8,343,184 Bytes)
43 query eseguite
SELECT `data`
FROM `koul8_session`
WHERE `session_id` = '45e14182adfa9fa9f9d410aad69b4b92'
SELECT `session_id`
FROM `koul8_session`
WHERE `session_id` = '45e14182adfa9fa9f9d410aad69b4b92'
LIMIT 0, 1
INSERT INTO `koul8_session`
(`session_id`, `client_id`, `time`)
VALUES
('45e14182adfa9fa9f9d410aad69b4b92', 0, '1711657110')
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 = 12583
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-28 20:18:30')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 20:18:30')
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=73
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=12583)
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 = 12583
SELECT (catid) As Expr1
FROM koul8_content
WHERE (id=12583)
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=12583
AND c.state = 1
UPDATE koul8_content
SET hits = hits + 1
WHERE id = 12583
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` = '12583'
UPDATE `koul8_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1711657110;s:18:\"session.timer.last\";i:1711657110;s:17:\"session.timer.now\";i:1711657110;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:\"16604252ccfb734c13223fb5abdf732d\";}'
, `time` = '1711657110'
WHERE `session_id` = '45e14182adfa9fa9f9d410aad69b4b92'
33 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:1711657110;s:18:\"session.timer.last\";i:1711657110;s:17:\"session.timer.now\";i:1711657110;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:\"16604252ccfb734c13223fb5abdf732d\";}' , `time` = '1711657110'
1 × UPDATE koul8_content
SET hits = hits + 1
1 × SHOW FULL COLUMNS
FROM `koul8_users
1 × SHOW FULL COLUMNS
FROM `koul8_assets
1 × SHOW FULL COLUMNS
FROM `koul8_content
1 × INSERT INTO `koul8_session` (`session_id`, `client_id`, `time`)
VALUES ('45e14182adfa9fa9f9d410aad69b4b92', 0, '1711657110'