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