/** * 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; }