/**
* Créé un sous-formulaire HTML à partir d'un DataField
* @param DatabaseDataField $paramDataField
*/
public function __construct(DatabaseDataField $paramDataField)
{
$paramArrayContent = DatabaseOperation::getArrayFieldsNameFromForeignKeyRelationNtoOne($paramDataField->getReferencedTableName(), $paramDataField->getTableName(), $paramDataField->getFieldValue(), explode(',', $paramDataField->getFieldsToDisplay()), explode(',', $paramDataField->getFieldsToOrder()), $paramDataField->getConditionSql());
parent::__construct($paramArrayContent, ModelTableAssociation::getModelName($paramDataField->getReferencedTableName()), $paramDataField->getFieldLabel());
$this->setContentLocked(explode(',', $paramDataField->getFieldsToLock()));
$this->setIsRightToAdd($paramDataField->getRightToAdd());
}
/**
* Créé un sous-formulaire HTML à partir d'un DataField
* @param DatabaseDataField $paramDataField
* @param $paramSecondaryTableNamesAndIdKeyValue
*/
public function __construct(DatabaseDataField $paramDataField, $paramSecondaryTableNamesAndIdKeyValue, $keyValue)
{
$paramArrayContent = DatabaseOperation::getArrayFieldsNameFromForeignKeyRelationNtoN($paramDataField->getTableName(), $paramSecondaryTableNamesAndIdKeyValue, $paramDataField->getFieldsToDisplay(), explode(',', $paramDataField->getFieldsToOrder()), $keyValue, $paramDataField->getConditionSql());
parent::__construct($paramArrayContent, ModelTableAssociation::getModelName($paramDataField->getTableName()), $paramDataField->getFieldLabel(), $paramSecondaryTableNamesAndIdKeyValue);
$this->setIsRightToAdd($paramDataField->getRightToAdd());
}
/**
* Actualise l'état d'un champ verrouillé si le champ à était mise à jour.
* @param string $paramTableName
* @param string $paramKeyValue
* @param string $paramFieldName
*/
public static function doUpdateLockField($paramTableName, $paramKeyValue, $paramFieldName)
{
$mondelName = ModelTableAssociation::getModelName($paramTableName);
$model = new $mondelName($paramKeyValue);
$idFta = $model->getDataField(FtaModel::KEYNAME)->getFieldValue();
if ($idFta) {
$modelFta = new FtaModel($idFta);
$idFtaDossier = $modelFta->getDossierFta();
}
$arrayFieldToLockChap = DatabaseOperation::convertSqlStatementWithoutKeyToArray("SELECT " . self::KEYNAME . " FROM " . self::TABLENAME . " WHERE " . self::FIELDNAME_TABLE_NAME . "=\"" . $paramTableName . "\" AND " . self::FIELDNAME_FIELD_NAME . "=\"" . $paramFieldName . "\" AND " . self::FIELDNAME_DOSSIER_FTA_PRIMAIRE . "=\"" . $idFtaDossier . "\" AND " . self::FIELDNAME_FIELD_LOCK . "=" . self::FIELD_LOCK_TRUE);
if ($arrayFieldToLockChap) {
DatabaseOperation::execute("UPDATE " . self::TABLENAME . " SET " . self::FIELDNAME_FIELD_CHANGE_STATE . "=" . self::CHANGE_STATE_FALSE . " WHERE " . self::FIELDNAME_TABLE_NAME . "=\"" . $paramTableName . "\" AND " . self::FIELDNAME_FIELD_NAME . "=\"" . $paramFieldName . "\" AND " . self::FIELDNAME_DOSSIER_FTA_PRIMAIRE . "=\"" . $idFtaDossier . "\"");
}
}
private static function setArrayTableNameToModelName($arrayTableNameToModelName)
{
self::$arrayTableNameToModelName = $arrayTableNameToModelName;
}
