/**
* On insert les champs à verrouiller par défaut
* @param int $paramFtaDossierPrimaire
*/
public static function insertDefaultFieldToLock($paramFtaDossierPrimaire)
{
$arrayIntranetColumInfoLockField = IntranetColumnInfoModel::getArrayDefaultLockField();
if ($arrayIntranetColumInfoLockField) {
foreach ($arrayIntranetColumInfoLockField as $rowIntranetColumInfoLockField) {
$lockValueIntranet = $rowIntranetColumInfoLockField[IntranetColumnInfoModel::FIELDNAME_DEFAULT_FIELD_TO_LOCK_FOR_PRIMARY_FTA];
/**
* On vérifie si il s'agit un champ à verrouilé par défaut ou pas.
*/
switch ($lockValueIntranet) {
case IntranetColumnInfoModel::DEFAULT_FIELD_TO_LOCK_FOR_PRIMARY_FTA_VALUES:
$lockValue = self::FIELD_LOCK_TRUE;
break;
case IntranetColumnInfoModel::DEFAULT_FIELD_NOT_TO_LOCK_FOR_PRIMARY_FTA_VALUES:
$lockValue = self::FIELD_LOCK_FALSE;
break;
}
DatabaseOperation::execute("INSERT INTO " . self::TABLENAME . " ( " . self::FIELDNAME_TABLE_NAME . ", " . self::FIELDNAME_FIELD_NAME . ", " . self::FIELDNAME_DOSSIER_FTA_PRIMAIRE . ", " . self::FIELDNAME_FIELD_LOCK . ", " . self::FIELDNAME_FIELD_CHANGE_STATE . " ) VALUES ( \"" . $rowIntranetColumInfoLockField[IntranetColumnInfoModel::FIELDNAME_TABLE_NAME_INTRANET_COLUMN_INFO] . "\", \"" . $rowIntranetColumInfoLockField[IntranetColumnInfoModel::FIELDNAME_COLUMN_NAME_INTRANET_COLUMN_INFO] . "\", \"" . $paramFtaDossierPrimaire . "\", \"" . $lockValue . "\", \"" . self::CHANGE_STATE_TRUE_VALIDATION_FTA . "\" ) ");
}
} else {
$titre = UserInterfaceMessage::FR_WARNING_VERROUILLAGE_CHAMPS_TITLE;
$message = UserInterfaceMessage::FR_WARNING_VERROUILLAGE_CHAMPS;
Lib::showMessage($titre, $message);
}
}
break;
case FtaModel::FIELDNAME_CODE_ARTICLE_LDC:
/**
* On vérifie si le code Article Arcadia existe
*/
$arrayDossierFta = DatabaseOperation::convertSqlStatementWithoutKeyToArray("SELECT DISTINCT " . FtaModel::KEYNAME . "," . FtaModel::FIELDNAME_ID_FTA_ETAT . "," . FtaModel::FIELDNAME_DOSSIER_FTA . "," . FtaModel::FIELDNAME_VERSION_DOSSIER_FTA . "," . FtaModel::FIELDNAME_DESIGNATION_COMMERCIALE . "," . FtaModel::FIELDNAME_LIBELLE . "," . FtaModel::FIELDNAME_DESIGNATION_COMMERCIALE . "," . FtaModel::FIELDNAME_POIDS_ELEMENTAIRE . "," . FtaModel::FIELDNAME_NOMBRE_UVC_PAR_CARTON . "," . FtaModel::FIELDNAME_CODE_ARTICLE_LDC . " FROM " . FtaModel::TABLENAME . " WHERE " . FtaModel::FIELDNAME_CODE_ARTICLE_LDC . "=\"" . $codePrimaire . "\" ORDER BY " . FtaModel::FIELDNAME_ID_FTA_ETAT . "," . FtaModel::FIELDNAME_VERSION_DOSSIER_FTA . " DESC");
break;
/* * **********
Fin de switch
* ********** */
}
if ($arrayDossierFta) {
/**
* On récupère la liste des Champs verrouillables
*/
$arrayFtaLock = IntranetColumnInfoModel::getArrayDefaultLockField();
$separateur = "";
$htmlListTitre = UserInterfaceLabel::FR_VERROUILLABLE_TITRE;
foreach ($arrayFtaLock as $rowsFtaLock) {
$tableName = $rowsFtaLock[IntranetColumnInfoModel::FIELDNAME_TABLE_NAME_INTRANET_COLUMN_INFO];
$fieldName = $rowsFtaLock[IntranetColumnInfoModel::FIELDNAME_COLUMN_NAME_INTRANET_COLUMN_INFO];
$label = IntranetColumnInfoModel::getLabelByTableNameAndColummName($tableName, $fieldName);
$htmlList .= $separateur . $label;
$separateur = "<br>";
}
foreach ($arrayDossierFta as $rowsDossierFta) {
$idFta = $rowsDossierFta[FtaModel::KEYNAME];
/**
* Contrôle
*/
if ($idFta == $paramIdFta) {
