/**
* On récupère la date de validation pour une id fta et un chapitre donnée
* @param int $paramIdFta
* @param int $paramIdFtaChapitre
* @return string
*/
public static function getValidationDateByIdFtaChapitreAndIdFta($paramIdFta, $paramIdFtaChapitre)
{
$arrayDateDeValidation = DatabaseOperation::convertSqlStatementWithoutKeyToArrayComplete("SELECT " . self::FIELDNAME_DATE_VALIDATION_SUIVI_PROJET . " FROM " . self::TABLENAME . " WHERE " . self::FIELDNAME_ID_FTA_CHAPITRE . "=" . $paramIdFtaChapitre . " AND " . self::FIELDNAME_ID_FTA . "=" . $paramIdFta);
/**
* Changment de format de date
*/
$date = FtaController::changementDuFormatDeDateFR($arrayDateDeValidation["0"]);
return $date;
}
/**
* On récupère l'id du champs et du dossier primaire en cours
* @param int $paramIdFtaDossierPriamaire
* @param string $paramFieldName
* @return int
*/
public static function getIdFtaVerrouillageChamps($paramIdFtaDossierPriamaire, $paramFieldName)
{
$arrayId = DatabaseOperation::convertSqlStatementWithoutKeyToArrayComplete("SELECT " . self::KEYNAME . " FROM " . self::TABLENAME . " WHERE " . self::FIELDNAME_DOSSIER_FTA_PRIMAIRE . "=" . $paramIdFtaDossierPriamaire . " AND " . self::FIELDNAME_FIELD_NAME . "=\"" . $paramFieldName . "\"");
if ($arrayId) {
foreach ($arrayId as $rowsId) {
$keyValue = $rowsId;
}
} else {
$titre = UserInterfaceMessage::FR_WARNING_DATA_VERROUILLAGE_TITLE;
$message = UserInterfaceMessage::FR_WARNING_DATA_VERROUILLAGE;
Lib::showMessage($titre, $message, $redirection);
}
return $keyValue;
}
/**
* On récupère le tableau la liste des id intranet Action ayant accès aux module FTA par utilsateur
* @return array
*/
public static function getArrayIdIntranetActionWithAccesRightsToFtaByUser($paramIdUser)
{
$arrayAction = DatabaseOperation::convertSqlStatementWithoutKeyToArrayComplete("SELECT DISTINCT " . IntranetDroitsAccesModel::FIELDNAME_ID_INTRANET_ACTIONS . " FROM " . IntranetDroitsAccesModel::TABLENAME . " WHERE " . IntranetDroitsAccesModel::TABLENAME . "." . IntranetDroitsAccesModel::FIELDNAME_ID_USER . " = " . $paramIdUser . " AND " . IntranetDroitsAccesModel::TABLENAME . "." . IntranetDroitsAccesModel::FIELDNAME_ID_INTRANET_MODULES . " = '" . IntranetModulesModel::ID_MODULES_FTA . "' " . " AND " . IntranetDroitsAccesModel::TABLENAME . "." . IntranetDroitsAccesModel::FIELDNAME_NIVEAU_INTRANET_DROITS_ACCES . " <>'" . IntranetNiveauAccesModel::NIVEAU_GENERIC_FALSE . "'");
return $arrayAction;
}
public static function getIdFtaChapitreBetweenArrayByWorkflowAndArrayByColumn($paramIdFtaWorkflow, $paramArrayByColumn)
{
$arrayByWorkflow = DatabaseOperation::convertSqlStatementWithoutKeyToArrayComplete("SELECT " . self::FIELDNAME_ID_FTA_CHAPITRE . " FROM " . self::TABLENAME . " WHERE " . self::FIELDNAME_ID_FTA_WORKFLOW . "=" . $paramIdFtaWorkflow);
$value = FtaController::getFirstValueArrayInterset($paramArrayByColumn, $arrayByWorkflow);
return $value;
}
/**
* On désactive pour l'id Fta en cours son id Transaction
* @param int $paramIdFta
*/
public static function cancelIdArcadiaTransaction($paramIdFta)
{
$arrayCheck = DatabaseOperation::convertSqlStatementWithoutKeyToArrayComplete("SELECT " . self::KEYNAME . " FROM " . self::TABLENAME . " WHERE " . self::FIELDNAME_ID_FTA . "=" . $paramIdFta . " AND " . self::FIELDNAME_ACTIF . "=" . self::OUI . " ORDER BY " . self::KEYNAME . " DESC ");
if ($arrayCheck) {
$key = $arrayCheck["0"];
DatabaseOperation::execute("UPDATE " . self::TABLENAME . " SET " . self::FIELDNAME_ACTIF . "=" . self::NON . " WHERE " . self::KEYNAME . "=" . $key);
}
}
