Nous recrutons
Face à un évènement grave, que faire ? Dispositif d'aide et de conseil aux entreprises
Dans la vie de l'entreprise des évènements graves de toute nature peuvent survenir (agression, accident, catastrophe naturelle, etc.) et engendrer des chocs psychologiques. Le traitement de telles situations est complexe et exige une forte réactivité.
Pour conseiller et accompagner au mieux les entreprises face à ces évènements et chocs psychologiques AST74 a travaillé sur un Projet test BTP en se dotant d'un dispositif d'aide et de conseil aux entreprises.
Deux outils ont ainsi été élaborés pour aider les entreprises à mieux réagir :
0.00038368299865723 DESC `actualites`
0.00039541400146484 DESC `actualites_themes`
0.00085663299560547 SELECT DISTINCT `actualites_themes`.* FROM `actualites` LEFT JOIN `actualites_themes` ON FIND_IN_SET(actualites_themes.id,actualites.theme) WHERE 1 AND `actualites_themes`.`id` IS NOT NULL AND (`actualites`.etat = "en-ligne") AND (`actualites_themes`.etat = "en-ligne") AND (alaune="oui" ) ORDER BY
0.00029299800109863 SELECT COUNT(*) FROM `actualites` WHERE 1 AND (alaune="oui" ) AND (`actualites`.etat = "en-ligne")
0.0011625559997559 SELECT DISTINCT `actualites`.* FROM `actualites` LEFT JOIN `actualites_themes` ON FIND_IN_SET(actualites_themes.id,actualites.theme) WHERE 1 AND (alaune="oui" ) AND (`actualites`.etat = "en-ligne") ORDER BY date ASC LIMIT ?,?
0.00035695899963379 DESC `agenda`
0.00031768800354004 DESC `agenda_themes`
0.00040239001464844 SELECT DISTINCT DATE_FORMAT(date, '%Y-%m-%d') FROM agenda WHERE 1 AND ( (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(date_fin)) AND (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(NOW())) AND (UNIX_TIMESTAMP(date_fin) >= UNIX_TIMESTAMP(NOW())) OR (UNIX_TIMESTAMP(date_fin) <= UNIX
0.00038445799255371 SELECT DISTINCT `agenda_themes`.* FROM `agenda` LEFT JOIN `agenda_themes` ON FIND_IN_SET(agenda_themes.id,agenda.theme) WHERE 1 AND ( (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(date_fin)) AND (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(NOW())) AND (UNIX_TIMESTAMP(date_fin) >= UNI
0.00019848899841309 SELECT COUNT(*) FROM `agenda` WHERE 1 AND ( (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(date_fin)) AND (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(NOW())) AND (UNIX_TIMESTAMP(date_fin) >= UNIX_TIMESTAMP(NOW())) OR (UNIX_TIMESTAMP(date_fin) <= UNIX_TIMESTAMP(date_debut)) )
0.00079567999267578 SELECT DISTINCT `agenda`.* FROM `agenda` LEFT JOIN `agenda_themes` ON FIND_IN_SET(agenda_themes.id,agenda.theme) WHERE 1 AND ( (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(date_fin)) AND (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(NOW())) AND (UNIX_TIMESTAMP(date_fin) >= UNIX_TIME
0.00027758999633789 DESC `temoignages`
0.00015855000305176 SELECT COUNT(*) FROM `temoignages` WHERE 1 AND (afficher_accueil="oui") AND (`temoignages`.etat = "en-ligne")
0.0010104579925537 SELECT * FROM `temoignages` WHERE 1 AND (afficher_accueil="oui") AND (`temoignages`.etat = "en-ligne") ORDER BY date ASC LIMIT ?,?
0.00070888200378418 SELECT * FROM `pages` WHERE (FIND_IN_SET(?, lang) OR lang = '') AND `etat` = 'en-ligne' AND url <> '' AND groupe <> 'invisible' ORDER BY ordre > 0 DESC, ordre ASC, url ASC
0.0077024279937744 Total: 15