PHP DatabaseOperation::convertSqlStatementWithoutKeyToArray方法代码示例

 /**
  * On obtient le tableau des id intranet action gestionnaire pour un espace de travail donné
  * @param int $paramWorkflow
  * @return array
  */
 public static function getArrayIdIntranetActionsByWorkflowAndGestionnaire($paramWorkflow)
 {
     $arrayIdIntranetActions = DatabaseOperation::convertSqlStatementWithoutKeyToArray('SELECT ' . self::TABLENAME . '.' . self::FIELDNAME_ID_INTRANET_ACTIONS . ' FROM ' . FtaRoleModel::TABLENAME . ', ' . self::TABLENAME . ' WHERE ' . self::TABLENAME . '.' . self::FIELDNAME_ID_FTA_WORKFLOW . '=' . $paramWorkflow . ' AND ' . FtaRoleModel::TABLENAME . '.' . FtaRoleModel::FIELDNAME_IS_GESTIONNAIRE . '=' . FtaRoleModel::IS_GESTIONNAIRE_TRUE . ' AND ' . self::TABLENAME . '.' . self::FIELDNAME_ID_FTA_ROLE . '=' . FtaRoleModel::TABLENAME . '.' . FtaRoleModel::KEYNAME);
     if ($arrayIdIntranetActions) {
         foreach ($arrayIdIntranetActions as $value) {
             $result[] = $value[self::FIELDNAME_ID_INTRANET_ACTIONS];
         }
         return $result;
     }
 }

 /**
  * On return le nom de la clé primaire d'une table donnée
  * @param string $paramTable
  * @return string
  */
 public static function getPrimaryFieldName($paramTable)
 {
     $arrayKeyField = DatabaseOperation::convertSqlStatementWithoutKeyToArray("DESC " . $paramTable);
     foreach ($arrayKeyField as $value) {
         if ($value[self::KEY] == self::PRIMARY_KEY) {
             $primaryFieldName = $value[self::FIELD];
         }
     }
     return $primaryFieldName;
 }

 /**
  * On obtient le tableau des id intranet action du site de rpooduction
  * pour un espace de travail donné
  * @param int $paramWorkflow
  * @param int $paramSiteDeProd
  * @return array
  */
 public static function getArrayIdIntranetActionsByWorkflowAndSiteDeProd($paramWorkflow, $paramSiteDeProd)
 {
     $arrayIdIntranetActions = DatabaseOperation::convertSqlStatementWithoutKeyToArray('SELECT ' . self::TABLENAME . '.' . self::FIELDNAME_ID_INTRANET_ACTIONS . ' FROM ' . self::TABLENAME . ' WHERE ' . self::TABLENAME . '.' . self::FIELDNAME_ID_FTA_WORKFLOW . '=' . $paramWorkflow . ' AND ' . self::TABLENAME . '.' . self::FIELDNAME_ID_SITE . '=' . $paramSiteDeProd);
     if ($arrayIdIntranetActions) {
         foreach ($arrayIdIntranetActions as $value) {
             $result[] = $value[self::FIELDNAME_ID_INTRANET_ACTIONS];
         }
         return $result;
     }
 }

 public static function checkActifWorkflow($paramIdFtaWorkflow)
 {
     $arrayActifWorkflow = DatabaseOperation::convertSqlStatementWithoutKeyToArray(" SELECT " . self::TABLENAME . "." . self::FIELDNAME_WORKFLOW_ACTIF . "," . self::FIELDNAME_DESCRIPTION_FTA_WORKFLOW . " FROM " . self::TABLENAME . " WHERE  " . self::KEYNAME . "=" . $paramIdFtaWorkflow);
     foreach ($arrayActifWorkflow as $rowsActifWorkflow) {
         $actif = $rowsActifWorkflow[self::FIELDNAME_WORKFLOW_ACTIF];
         $nom = $rowsActifWorkflow[self::FIELDNAME_DESCRIPTION_FTA_WORKFLOW];
         if (!$actif) {
             $titre = self::WORKFLOW_NON_ACTIF_TITLE;
             $message = self::WORKFLOW_NON_ACTIF_1 . $nom . self::WORKFLOW_NON_ACTIF_2;
             $redirection = "";
             Lib::showMessage($titre, $message, $redirection);
         }
     }
 }

 public static function isLieuGeoSiteDeProduction($paramLieuGeo)
 {
     $trueSiteDeProd = FALSE;
     $arrayNomSiteProduction = DatabaseOperation::convertSqlStatementWithoutKeyToArray('SELECT ' . GeoModel::FIELDNAME_ASSEMBLAGE . ' FROM ' . GeoModel::TABLENAME . ' WHERE ' . GeoModel::KEYNAME . '= \'' . $paramLieuGeo . '\'');
     if ($arrayNomSiteProduction) {
         foreach ($arrayNomSiteProduction as $rowsNomSiteProduction) {
             $siteDeProdValue = $rowsNomSiteProduction[GeoModel::FIELDNAME_ASSEMBLAGE];
             if ($siteDeProdValue) {
                 $trueSiteDeProd = TRUE;
             }
         }
     }
     return $trueSiteDeProd;
 }

 /**
  * On récupère IdAnnexeEmballage en fonction de l'emballage groupe
  * @param int $paramIdEmballageGroupe
  * @return array
  */
 public static function getArrayIdAnnexeEmballage($paramIdEmballageGroupe)
 {
     $req = 'SELECT DISTINCT ' . AnnexeEmballageModel::TABLENAME . '.' . AnnexeEmballageModel::KEYNAME . ' FROM ' . AnnexeEmballageGroupeModel::TABLENAME . ',' . AnnexeEmballageModel::TABLENAME . ' WHERE ( 0 ';
     $req .= AnnexeEmballageGroupeModel::AddIdAnnexeEmballageGroupe($paramIdEmballageGroupe);
     $req .= ') AND ' . AnnexeEmballageGroupeModel::TABLENAME . '.' . AnnexeEmballageGroupeModel::KEYNAME . '=' . AnnexeEmballageModel::TABLENAME . '.' . AnnexeEmballageModel::FIELDNAME_ID_ANNEXE_EMBALLAGE_GROUPE;
     $arrayIdAnnexeEmballage = DatabaseOperation::convertSqlStatementWithoutKeyToArray($req);
     if ($arrayIdAnnexeEmballage) {
         foreach ($arrayIdAnnexeEmballage as $rowsIdAnnexeEmballage) {
             $arrayidAnnexeEmballage[] = $rowsIdAnnexeEmballage[AnnexeEmballageModel::KEYNAME];
         }
     } else {
         $arrayidAnnexeEmballage = 0;
     }
     return $arrayidAnnexeEmballage;
 }

 /**
  * On retourne l'id annexe groupe emballage selon l'id annexe emballage et le type d'emballage
  * @param int $paramIdAnnexeEmballage
  * @param int $paramIdAnnexeAmballageGroupeType
  * @return string
  */
 public static function getIdAnnexeEmballageGroupeByIdAnnexeEmballageAndIdAnnexeGroupeType($paramIdAnnexeEmballage, $paramIdAnnexeAmballageGroupeType)
 {
     //Dans le cas d'emballage UVC, on peut avoir de l'emballage primaire
     if ($paramIdAnnexeAmballageGroupeType == 2) {
         $op = '<=';
     } else {
         $op = '=';
     }
     $arrayIdAnnexeEmballageGroupe = DatabaseOperation::convertSqlStatementWithoutKeyToArray("SELECT " . self::TABLENAME . "." . self::KEYNAME . " FROM " . self::TABLENAME . "," . AnnexeEmballageGroupeTypeModel::TABLENAME . "," . AnnexeEmballageModel::TABLENAME . " WHERE " . self::TABLENAME . "." . self::FIELDNAME_ID_ANNEXE_EMBALLAGE_GROUPE_CONFIGURATION . "=" . AnnexeEmballageGroupeTypeModel::TABLENAME . "." . AnnexeEmballageGroupeTypeModel::KEYNAME . " AND " . self::TABLENAME . "." . self::KEYNAME . "=" . AnnexeEmballageModel::TABLENAME . "." . AnnexeEmballageModel::FIELDNAME_ID_ANNEXE_EMBALLAGE_GROUPE . " AND " . self::TABLENAME . '.' . AnnexeEmballageGroupeModel::FIELDNAME_ID_ANNEXE_EMBALLAGE_GROUPE_CONFIGURATION . $op . $paramIdAnnexeAmballageGroupeType . " AND " . AnnexeEmballageModel::TABLENAME . '.' . AnnexeEmballageModel::KEYNAME . "=" . $paramIdAnnexeEmballage);
     //Récupération de l'id Groupe
     if ($arrayIdAnnexeEmballageGroupe) {
         foreach ($arrayIdAnnexeEmballageGroupe as $rowsIdAnnexeEmballageGroupe) {
             $IdAnnexeEmballageGroupe = $rowsIdAnnexeEmballageGroupe[self::KEYNAME];
         }
     }
     return $IdAnnexeEmballageGroupe;
 }

function tableau_planning_selectionne($semaine_en_cours, $annee_en_cours, $service, $site)
{
    //construction de la requête SQL
    $req1 = "SELECT DISTINCT id_salaries,id_planning_presence_semaine_visible, annee_planning_presence_semaine_visible, prenom, nom ";
    $req1 .= "FROM salaries, planning_presence_detail, annexe_jours_semaine, geo ";
    $req1 .= "WHERE (salaries.id_user=planning_presence_detail.id_salaries) ";
    $req1 .= "AND (geo.id_geo=salaries.lieu_geo) ";
    $req1 .= "AND (planning_presence_detail.id_annexe_jours_semaine=annexe_jours_semaine.id_annexe_jours_semaine) ";
    $req1 .= "AND (id_planning_presence_semaine_visible='{$semaine_en_cours}') ";
    $req1 .= "AND (annee_planning_presence_semaine_visible='{$annee_en_cours}') ";
    $req1 .= "AND (id_service='{$service}') ";
    $req1 .= "AND (geo.id_geo='{$site}') ";
    $req1 .= "ORDER BY nom,prenom ASC";
    //echo $req1;
    //Execution de la requête SQL
    $result1 = DatabaseOperation::convertSqlStatementWithoutKeyToArray($req1);
    return $result1;
}

 /**
  * On récupère les informations des Fta 
  * @param type $paramArrayIdFta
  * @param type $paramOrderBy
  * @return type
  */
 public static function getIdFtaByUserAndWorkflow($paramArrayIdFta, $paramOrderBy, $paramDebut, $paramFtaModificatin)
 {
     if ($paramFtaModificatin) {
         $nbMaxParPage = ModuleConfig::VALUE_MAX_PAR_PAGE;
     } else {
         $nbMaxParPage = ModuleConfig::VALUE_MAX_PAR_PAGE_CONSUL;
         $paramOrderBy = FtaModel::FIELDNAME_DATE_DERNIERE_MAJ_FTA . ' DESC ';
     }
     /**
      * Attention dans la condition where de la requette ne pas mettre des conditions non présente lors de la création de la fta
      * Exemple ClassificationRaccourcisModel::TABLENAME 
      */
     if ($paramArrayIdFta) {
         $array['1'] = DatabaseOperation::convertSqlStatementWithoutKeyToArray('SELECT DISTINCT ' . FtaModel::TABLENAME . '.' . FtaModel::KEYNAME . ', ' . FtaEtatModel::FIELDNAME_ABREVIATION . ', ' . FtaModel::FIELDNAME_LIBELLE . ', ' . FtaWorkflowModel::FIELDNAME_DESCRIPTION_FTA_WORKFLOW . ', ' . FtaWorkflowModel::FIELDNAME_NOM_FTA_WORKFLOW . ', ' . FtaModel::FIELDNAME_NOMBRE_UVC_PAR_CARTON . ', ' . FtaModel::FIELDNAME_POIDS_ELEMENTAIRE . ', ' . FtaModel::FIELDNAME_ID_CLASSIFICATION_RACCOURCIS . ', ' . FtaModel::FIELDNAME_DESIGNATION_COMMERCIALE . ', ' . FtaModel::FIELDNAME_DOSSIER_FTA . ', ' . FtaModel::FIELDNAME_VERSION_DOSSIER_FTA . ', ' . FtaModel::FIELDNAME_CODE_ARTICLE_LDC . ', ' . FtaModel::FIELDNAME_DATE_ECHEANCE_FTA . ', ' . FtaModel::FIELDNAME_CREATEUR . ', ' . FtaModel::FIELDNAME_ID_FTA_CLASSIFICATION2 . ', ' . FtaModel::FIELDNAME_POURCENTAGE_AVANCEMENT . ', ' . FtaModel::FIELDNAME_LISTE_ID_FTA_ROLE . ', ' . GeoModel::FIELDNAME_GEO . ', ' . FtaModel::TABLENAME . '. ' . FtaModel::FIELDNAME_WORKFLOW . ' FROM ' . FtaModel::TABLENAME . ',' . UserModel::TABLENAME . ', ' . FtaEtatModel::TABLENAME . ', ' . FtaWorkflowModel::TABLENAME . ', ' . GeoModel::TABLENAME . ' WHERE ( 0 ' . FtaModel::addIdFtaLabel($paramArrayIdFta) . ')' . ' AND ' . FtaModel::TABLENAME . '.' . FtaModel::FIELDNAME_CREATEUR . '=' . UserModel::TABLENAME . '.' . UserModel::KEYNAME . ' AND ' . FtaModel::TABLENAME . '.' . FtaModel::FIELDNAME_ID_FTA_ETAT . '=' . FtaEtatModel::TABLENAME . '.' . FtaEtatModel::KEYNAME . ' AND ' . FtaWorkflowModel::TABLENAME . '.' . FtaWorkflowModel::KEYNAME . '=' . FtaModel::TABLENAME . '.' . FtaModel::FIELDNAME_WORKFLOW . ' AND ' . FtaModel::TABLENAME . '.' . FtaModel::FIELDNAME_SITE_PRODUCTION . '=' . GeoModel::TABLENAME . '.' . GeoModel::KEYNAME . ' ORDER BY ' . $paramOrderBy . ',' . FtaModel::TABLENAME . '.' . FtaModel::FIELDNAME_WORKFLOW . ',' . UserModel::FIELDNAME_PRENOM . ' ASC' . ',' . UserModel::FIELDNAME_NOM . ' ASC' . ',' . FtaModel::FIELDNAME_DATE_ECHEANCE_FTA . ' LIMIT ' . $nbMaxParPage . ' OFFSET ' . $paramDebut);
         $array['2'] = DatabaseOperation::getRowsNumberOverLimitInSqlStatement('SELECT SQL_CALC_FOUND_ROWS ' . FtaModel::TABLENAME . '.' . FtaModel::KEYNAME . ', ' . FtaEtatModel::FIELDNAME_ABREVIATION . ', ' . FtaModel::FIELDNAME_LIBELLE . ', ' . FtaWorkflowModel::FIELDNAME_DESCRIPTION_FTA_WORKFLOW . ', ' . FtaWorkflowModel::FIELDNAME_NOM_FTA_WORKFLOW . ', ' . FtaModel::FIELDNAME_NOMBRE_UVC_PAR_CARTON . ', ' . FtaModel::FIELDNAME_POIDS_ELEMENTAIRE . ', ' . FtaModel::FIELDNAME_ID_CLASSIFICATION_RACCOURCIS . ', ' . FtaModel::FIELDNAME_DESIGNATION_COMMERCIALE . ', ' . FtaModel::FIELDNAME_DOSSIER_FTA . ', ' . FtaModel::FIELDNAME_VERSION_DOSSIER_FTA . ', ' . FtaModel::FIELDNAME_CODE_ARTICLE_LDC . ', ' . FtaModel::FIELDNAME_ID_FTA_CLASSIFICATION2 . ', ' . FtaModel::FIELDNAME_DATE_ECHEANCE_FTA . ', ' . FtaModel::FIELDNAME_CREATEUR . ', ' . FtaModel::FIELDNAME_POURCENTAGE_AVANCEMENT . ', ' . FtaModel::FIELDNAME_LISTE_ID_FTA_ROLE . ', ' . GeoModel::FIELDNAME_GEO . ', ' . FtaModel::TABLENAME . '. ' . FtaModel::FIELDNAME_WORKFLOW . ' FROM ' . FtaModel::TABLENAME . ',' . UserModel::TABLENAME . ', ' . FtaEtatModel::TABLENAME . ', ' . FtaWorkflowModel::TABLENAME . ', ' . GeoModel::TABLENAME . ' WHERE ( 0 ' . FtaModel::addIdFtaLabel($paramArrayIdFta) . ')' . ' AND ' . FtaModel::TABLENAME . '.' . FtaModel::FIELDNAME_CREATEUR . '=' . UserModel::TABLENAME . '.' . UserModel::KEYNAME . ' AND ' . FtaModel::TABLENAME . '.' . FtaModel::FIELDNAME_ID_FTA_ETAT . '=' . FtaEtatModel::TABLENAME . '.' . FtaEtatModel::KEYNAME . ' AND ' . FtaWorkflowModel::TABLENAME . '.' . FtaWorkflowModel::KEYNAME . '=' . FtaModel::TABLENAME . '.' . FtaModel::FIELDNAME_WORKFLOW . ' AND ' . FtaModel::TABLENAME . '.' . FtaModel::FIELDNAME_SITE_PRODUCTION . '=' . GeoModel::TABLENAME . '.' . GeoModel::KEYNAME . ' ORDER BY ' . $paramOrderBy . ',' . FtaModel::TABLENAME . '.' . FtaModel::FIELDNAME_WORKFLOW . ',' . UserModel::FIELDNAME_PRENOM . ' ASC' . ',' . FtaModel::FIELDNAME_DATE_ECHEANCE_FTA . ' LIMIT ' . $nbMaxParPage . ' OFFSET ' . $paramDebut);
         $array['3'] = DatabaseOperation::convertSqlStatementWithoutKeyToArray('SELECT DISTINCT ' . FtaWorkflowModel::TABLENAME . '.*' . ' FROM ' . FtaModel::TABLENAME . ',' . FtaWorkflowModel::TABLENAME . ' WHERE ( ' . '0' . ' ' . FtaModel::addIdFtaLabel($array['1']) . ')' . ' AND ' . FtaModel::TABLENAME . '.' . FtaModel::FIELDNAME_WORKFLOW . '=' . FtaWorkflowModel::TABLENAME . '.' . FtaWorkflowModel::KEYNAME);
         return $array;
     }
 }

 /**
  * Récupération de la description d'un champ
  * @param string $paramNameTable
  * @param string $paramNameVariable
  * @param string $paramLabel
  * @param boolean $paramIsEditable
  * @param object $paramHtmlObject
  * @return string
  */
 public static function getFieldDesc($paramNameTable, $paramNameVariable, $paramLabel, $paramIsEditable, $paramHtmlObject)
 {
     //Recherche des informations d'aide en ligne (format Pop-up)
     $req_explication = "SELECT " . self::FIELDNAME_TABLE_NAME_INTRANET_DESCRIPTION . "," . self::FIELDNAME_CHAMP_NAME_INTRANET_DESCRIPTION . "," . self::FIELDNAME_EXPLICATION_INTRANET_DESCRIPTION . "," . self::FIELDNAME_IS_ENABLED_INTRANET_DESCRIPTION . "," . self::KEYNAME . " FROM " . self::TABLENAME . " WHERE " . self::FIELDNAME_TABLE_NAME_INTRANET_DESCRIPTION . "='" . $paramNameTable . "' " . "AND " . self::FIELDNAME_CHAMP_NAME_INTRANET_DESCRIPTION . "='" . $paramNameVariable . "' ";
     $arrayIntranetDescription = DatabaseOperation::convertSqlStatementWithoutKeyToArray($req_explication);
     if ($arrayIntranetDescription) {
         foreach ($arrayIntranetDescription as $rowsIntranetDescription) {
             $id_intranet_description = $rowsIntranetDescription[self::KEYNAME];
             $explication_intranet_description = $rowsIntranetDescription[self::FIELDNAME_EXPLICATION_INTRANET_DESCRIPTION];
             $show_help = $rowsIntranetDescription[self::FIELDNAME_IS_ENABLED_INTRANET_DESCRIPTION];
         }
     } else {
         $id_intranet_description = self::insertIntranetDescription($paramNameTable, $paramNameVariable);
         $show_help = self::IS_ENABLED_TRUE;
     }
     $paramHtmlObject->setShowHelp($show_help);
     if ($show_help) {
         //Ajout des liens hypertextes
         $return .= "<a title=\"" . $explication_intranet_description . "\" " . "href=" . self::HREF_JAVASCRIPT_BEGIN . self::HREF_POPUP . "?id_intranet_description=" . $id_intranet_description . "&disable_full_page=1" . "&isEditable=" . $paramIsEditable . "&champ_intranet_description={$paramNameVariable}" . self::HREF_JAVASCRIPT_END . "  CLASS=link1 />" . $paramLabel . "</a>";
     }
     return $return;
 }

             }
             $_SESSION['identite'] = $login;
             $_SESSION['tentative'] = $tentative;
         } else {
             $_SESSION['tentative'] = "0";
             $titre = "Erreur d'identification ";
             $message = "L'identifiant {$login} n'existe pas dans la base de données.<br><br>";
             Lib::showMessage($titre, $message, $redirection);
         }
     }
     /* fin nouvelles fonctions tests tentatives */
     header('Location: ' . $page);
 } else {
     //Création des variables une fois l'authentification terminé
     if (!$id_user) {
         $arrayR1 = DatabaseOperation::convertSqlStatementWithoutKeyToArray('SELECT prenom' . ',id_catsopro' . ',id_user' . ',id_catsopro' . ',id_service' . ',id_type' . ',nom' . ',mail' . ',lieu_geo' . ',portail_wiki_salaries' . ' FROM salaries WHERE ( ' . '(login = \'' . $login . '\') AND ' . '(blocage=\'non\') AND ' . '(actif=\'oui\') ' . ')');
         if ($arrayR1) {
             foreach ($arrayR1 as $rows) {
                 $prenom = $rows['prenom'];
                 $id_user = $rows[UserModel::KEYNAME];
                 $id_catsopro = $rows['id_catsopro'];
                 $id_service = $rows['id_service'];
                 $nom_type = $rows['id_type'];
                 $nom_famille_ses = $rows['nom'];
                 $mail_user = $rows['mail'];
                 $lieu_geo = $rows['lieu_geo'];
                 $portail_wiki_salaries = $rows['portail_wiki_salaries'];
             }
             $_SESSION[UserModel::FIELDNAME_PASSWORD] = $pass;
             $_SESSION['nom_famille_ses'] = $nom_famille_ses;
             $_SESSION[UserModel::FIELDNAME_LOGIN] = $login;

 public static function getListeClassificationLabel($paramAscendent, $paramIdDefaut, $paramSelect, $paramOrig, $paramNomDefaut, $paramIsEditable, $paramMarque2 = NULL)
 {
     if ($paramAscendent != NULL) {
         $req = 'SELECT DISTINCT ' . $paramSelect . ' FROM  ' . ClassificationFta2Model::TABLENAME . ' WHERE  ' . $paramOrig . ' = ' . $paramAscendent;
         if (self::$idProprietaireGroupe) {
             $req .= ' AND ' . ClassificationFta2Model::FIELDNAME_ID_PROPRIETAIRE_GROUPE . ' = ' . self::$idProprietaireGroupe;
         }
         if (self::$idProprietaireEnseigne != NULL) {
             $req .= ' AND ' . ClassificationFta2Model::FIELDNAME_ID_PROPRIETAIRE_ENSEIGNE . ' = ' . self::$idProprietaireEnseigne;
         }
         if (self::$idMarque) {
             $req .= ' AND ' . ClassificationFta2Model::FIELDNAME_ID_MARQUE . ' = ' . self::$idMarque;
         }
         if (self::$idActivite) {
             $req .= ' AND ' . ClassificationFta2Model::FIELDNAME_ID_ACTIVITE . ' = ' . self::$idActivite;
         }
         if (self::$idRayon) {
             $req .= ' AND ' . ClassificationFta2Model::FIELDNAME_ID_RAYON . ' = ' . self::$idRayon;
         }
         if (self::$idEnvironnement) {
             $req .= ' AND ' . ClassificationFta2Model::FIELDNAME_ID_ENVIRONNEMENT . ' = ' . self::$idEnvironnement;
         }
         if (self::$idSaisonnalite) {
             $req .= ' AND ' . ClassificationFta2Model::FIELDNAME_ID_SAISONNALITE . ' = ' . self::$idSaisonnalite;
         }
         $array = DatabaseOperation::convertSqlStatementWithoutKeyToArray($req);
         foreach ($array as $value) {
             $return[] = $value[$paramSelect];
         }
     }
     //Traitement du Warning Update
     if (self::$paramWarningUpdate) {
         $image_modif = Html::DEFAULT_HTML_WARNING_UPDATE_IMAGE;
         $color_modif = Html::DEFAULT_HTML_WARNING_UPDATE_BGCOLOR;
     }
     $reqClassification = 'SELECT ' . ClassificationArborescenceArticleCategorieContenuModel::KEYNAME . ',' . ClassificationArborescenceArticleCategorieContenuModel::FIELDNAME_NOM_CLASSIFICATION_ARBORESCENCE_ARTICLE_CATEGORIE_CONTENU . ' FROM ' . ClassificationArborescenceArticleCategorieContenuModel::TABLENAME . ' WHERE ( 0 ' . ClassificationFta2Model::AddIdClassificationArborescenceArticleCategorieContenu($return) . ') ORDER BY ' . ClassificationArborescenceArticleCategorieContenuModel::FIELDNAME_NOM_CLASSIFICATION_ARBORESCENCE_ARTICLE_CATEGORIE_CONTENU;
     $listeClassification = '<tr><td class=contenu style=\'' . $color_modif . '\' >' . DatabaseDescription::getFieldDocLabel(ClassificationFta2Model::TABLENAME, $paramSelect) . '</td><td class=contenu width=75%  style=\'' . $color_modif . '\' >' . AccueilFta::afficherRequeteEnListeDeroulante($reqClassification, $paramIdDefaut, $paramNomDefaut, $paramIsEditable, TRUE) . ' ' . $image_modif . '</td></tr>';
     return $listeClassification;
 }

 /**
  * On obtient l' id Annexe Emballage groupe type de type UVC selon l'id fta et id fta conditionnement
  * @param type $paramIdFtaConditionnement
  * @param type $paramIdFta
  * @return int
  */
 public static function getIdAnnexeEmballageAndGroupeTypeAndGroupeAndIdFtaConditionnementFromFtaConditionnement($paramIdFtaConditionnement, $paramIdFta)
 {
     $req = 'SELECT DISTINCT ' . self::KEYNAME . ',' . self::FIELDNAME_ID_ANNEXE_EMBALLAGE . ',' . self::FIELDNAME_ID_ANNEXE_EMBALLAGE_GROUPE_TYPE . ' FROM ' . self::TABLENAME . ' WHERE ( 0 ' . self::addIdFtaConditionnement($paramIdFtaConditionnement) . ' ) AND ' . self::FIELDNAME_ID_FTA . '=' . $paramIdFta;
     $arrayIdAnnexeEmballageGroupe = DatabaseOperation::convertSqlStatementWithoutKeyToArray($req);
     return $arrayIdAnnexeEmballageGroupe;
 }

 /**
  * On vérifie selon le role de l'utilisateur connecté 
  * si il a accès aux bouton de transition, de duplication et retirer
  * @param int $paramIdRole
  * @return boolean
  */
 public static function isGestionnaire($paramIdRole)
 {
     $valueIsGestionnaire = 0;
     $return = FALSE;
     $arrayIsGestionnaire = DatabaseOperation::convertSqlStatementWithoutKeyToArray('SELECT ' . self::FIELDNAME_IS_GESTIONNAIRE . ' FROM ' . self::TABLENAME . ' WHERE ' . self::KEYNAME . '=' . $paramIdRole);
     foreach ($arrayIsGestionnaire as $rowsIsGestionnaire) {
         $valueIsGestionnaire = $rowsIsGestionnaire[self::FIELDNAME_IS_GESTIONNAIRE];
     }
     if ($valueIsGestionnaire != 0) {
         $return = TRUE;
     }
     return $return;
 }

 /**
  * Retour la liste des IdClassificationActiviteSousFamille pour une activite donnée
  * @param int $paramIdActivite
  * @return array
  */
 private static function getArrayIdClassificationActiviteSousFamilleArcadiaByIdActivite($paramIdActivite)
 {
     $array = DatabaseOperation::convertSqlStatementWithoutKeyToArray("SELECT " . self::KEYNAME . " FROM " . self::TABLENAME . " WHERE " . self::FIELDNAME_ID_ACTIVITE . "=" . $paramIdActivite);
     return $array;
 }