/**
* Liste des étiqettes verso
* @param boolean $paramIsEditable
* @return string
*/
function getListeCodesoftEtiquettesVerso($paramIsEditable)
{
$HtmlList = new HtmlListSelect();
$arrayEtiquette = DatabaseOperation::convertSqlStatementWithKeyAndOneFieldToArray('SELECT DISTINCT ' . CodesoftEtiquettesModel::KEYNAME . ',' . CodesoftEtiquettesModel::FIELDNAME_DESIGNATION_CODESOFT_ETIQUETTES . ' FROM ' . CodesoftEtiquettesModel::TABLENAME . ' WHERE (' . CodesoftEtiquettesModel::FIELDNAME_K_SITE . '=' . $this->getModelFta()->getDataField(FtaModel::FIELDNAME_SITE_PRODUCTION)->getFieldValue() . ' OR ' . CodesoftEtiquettesModel::FIELDNAME_K_SITE . '=0)' . ' AND (' . CodesoftEtiquettesModel::FIELDNAME_K_TYPE_ETIQUETTE_CODESOFT_ETIQUETTES . '=3' . ' OR ' . CodesoftEtiquettesModel::FIELDNAME_K_TYPE_ETIQUETTE_CODESOFT_ETIQUETTES . '=0' . ')' . ' AND ' . CodesoftEtiquettesModel::FIELDNAME_IS_ENABLED_FTA . '=1' . ' ORDER BY ' . CodesoftEtiquettesModel::FIELDNAME_DESIGNATION_CODESOFT_ETIQUETTES);
/**
* Vérification de l'étiquette choisie par le chef de projet
*/
$idGestionEtiquetteVerso = $this->getModelFta()->getDataField(FtaModel::FIELDNAME_GESTION_ETIQUETTE_VERSO)->getFieldValue();
if ($idGestionEtiquetteVerso != AnnexeGestionEtiquetteRectoVersoModel::GESTION_PAR_LA_QUALITE_ID) {
$this->getDataField(self::FIELDNAME_K_ETIQUETTE_VERSO_FTA_COMPOSITION)->setFieldValue($idGestionEtiquetteVerso);
DatabaseOperation::execute("UPDATE " . self::TABLENAME . " SET " . self::FIELDNAME_K_ETIQUETTE_VERSO_FTA_COMPOSITION . "=" . $idGestionEtiquetteVerso . " WHERE " . self::KEYNAME . "=" . $this->getKeyValue());
$HtmlList->setDefaultValue($idGestionEtiquetteVerso);
$paramIsEditable = Chapitre::NOT_EDITABLE;
}
$HtmlList->setArrayListContent($arrayEtiquette);
$HtmlTableName = self::TABLENAME . '_' . self::FIELDNAME_K_ETIQUETTE_VERSO_FTA_COMPOSITION . '_' . $this->getKeyValue();
$etiquetteVerso = $this->getDataField(self::FIELDNAME_K_ETIQUETTE_VERSO_FTA_COMPOSITION);
$HtmlList->getAttributes()->getName()->setValue(self::FIELDNAME_K_ETIQUETTE_VERSO_FTA_COMPOSITION);
$HtmlList->setLabel(DatabaseDescription::getFieldDocLabel(self::TABLENAME, self::FIELDNAME_K_ETIQUETTE_VERSO_FTA_COMPOSITION));
$HtmlList->setIsEditable($paramIsEditable);
$HtmlList->initAbstractHtmlSelect($HtmlTableName, $HtmlList->getLabel(), $etiquetteVerso->getFieldValue(), $etiquetteVerso->isFieldDiff(), $HtmlList->getArrayListContent());
$HtmlList->getEventsForm()->setOnChangeWithAjaxAutoSave(self::TABLENAME, self::KEYNAME, $this->getKeyValue(), self::FIELDNAME_K_ETIQUETTE_VERSO_FTA_COMPOSITION);
/**
* Description d'un champ
*/
$HtmlList->setHelp(IntranetColumnInfoModel::getFieldDesc($etiquetteVerso->getTableName(), $etiquetteVerso->getFieldName(), $etiquetteVerso->getFieldLabel(), $HtmlList));
$listeCodesoftEtiquettes = $HtmlList->getHtmlResult();
return $listeCodesoftEtiquettes;
}
