45 lines
1.9 KiB
PHP
45 lines
1.9 KiB
PHP
<?php
|
|
namespace Module\ACM\Classe\GestionBD;
|
|
class GestionCouleur {
|
|
|
|
/**
|
|
* @return void fait l'insertion de toute les variables avec des couleurs par default
|
|
*/
|
|
public static function getListeCouleur() {
|
|
global $db;
|
|
$sqls = [
|
|
"INSERT INTO llx_acm_couleur (nom, codeHexa)
|
|
SELECT 'ACMTitreTableau', '#c43316'
|
|
WHERE NOT EXISTS ( SELECT 1 FROM llx_acm_couleur WHERE nom = 'ACMTitreTableau')",
|
|
|
|
"INSERT INTO llx_acm_couleur (nom, codeHexa)
|
|
SELECT 'ACMCorpsTableau', '#ffffff'
|
|
WHERE NOT EXISTS ( SELECT 1 FROM llx_acm_couleur WHERE nom = 'ACMCorpsTableau')",
|
|
|
|
"INSERT INTO llx_acm_couleur (nom, codeHexa)
|
|
SELECT 'ACMBordure', '#ac0c0c'
|
|
WHERE NOT EXISTS ( SELECT 1 FROM llx_acm_couleur WHERE nom = 'ACMBordure')",
|
|
|
|
"INSERT INTO llx_acm_couleur (nom, codeHexa)
|
|
SELECT 'ACMConge', '#ead815'
|
|
WHERE NOT EXISTS ( SELECT 1 FROM llx_acm_couleur WHERE nom = 'ACMConge')",
|
|
|
|
"INSERT INTO llx_acm_couleur (nom, codeHexa)
|
|
SELECT 'ACMMalade', '#f6b42b'
|
|
WHERE NOT EXISTS ( SELECT 1 FROM llx_acm_couleur WHERE nom = 'ACMMalade')",
|
|
|
|
"INSERT INTO llx_acm_couleur (nom, codeHexa)
|
|
SELECT 'ACMFontTitreTableau', '#ffffff'
|
|
WHERE NOT EXISTS ( SELECT 1 FROM llx_acm_couleur WHERE nom = 'ACMFontTitreTableau')",
|
|
|
|
"INSERT INTO llx_acm_couleur (nom, codeHexa)
|
|
SELECT 'ACMFontCorpsTableau', '#000000'
|
|
WHERE NOT EXISTS ( SELECT 1 FROM llx_acm_couleur WHERE nom = 'ACMFontCorpsTableau')",
|
|
|
|
"INSERT INTO llx_acm_couleur (nom, codeHexa)
|
|
SELECT 'ACMRecupe', '#cccccc'
|
|
WHERE NOT EXISTS ( SELECT 1 FROM llx_acm_couleur WHERE nom = 'ACMRecupe')"
|
|
];
|
|
foreach ($sqls as $query) $db->query($query);
|
|
}
|
|
} |