case 1:
//Création d'une FTA Vierge
// $idFta = null;
$arrayIdEtat = DatabaseOperation::convertSqlStatementWithoutKeyToArray('SELECT ' . FtaEtatModel::KEYNAME . ' FROM ' . FtaEtatModel::TABLENAME . ' WHERE ' . FtaEtatModel::FIELDNAME_ABREVIATION . '=\'' . $abreviationFtaEtat . '\' ');
foreach ($arrayIdEtat as $rowsIdEtat) {
$idFtaEtat = $rowsIdEtat[FtaEtatModel::KEYNAME];
}
/*
* Initialisation de l'enregistrement de la Table FTA
*/
$globalConfig = new GlobalConfig();
UserModel::checkUserSessionExpired($globalConfig);
$idUser = $globalConfig->getAuthenticatedUser()->getKeyValue();
$idFta = FtaModel::createFta($idUser, $idFtaEtat, $idFtaWorkflow, $designationCommercialeFta, date('Y-m-d'), $siteDeProduction);
DatabaseOperation::execute('UPDATE ' . FtaModel::TABLENAME . ' SET ' . FtaModel::FIELDNAME_DOSSIER_FTA . '=' . $idFta . ' WHERE ' . FtaModel::KEYNAME . '=' . $idFta);
FtaSuiviProjetModel::initFtaSuiviProjet($idFta);
//Cas d'une fiche Présentation
/**
* Ce cas n'est plus utiliser puisque l'espasce de travail Présentation,
* regroupe tous les chapitres nécéssaire
*/
if ($abreviationFtaEtat == 'P') {
//Condition where
$where = '';
//Récupération des chapitres concernés par ce cycle de vie
$arrayChapitreCycle = DatabaseOperation::convertSqlStatementWithoutKeyToArray('SELECT ' . FtaProcessusCycleModel::FIELDNAME_FTA_ETAT . ', ' . FtaProcessusCycleModel::FIELDNAME_PROCESSUS_INIT . ', ' . FtaProcessusCycleModel::FIELDNAME_PROCESSUS_NEXT . ' FROM ' . FtaProcessusCycleModel::TABLENAME . ' WHERE ' . FtaProcessusCycleModel::FIELDNAME_FTA_ETAT . ' = \'' . $abreviationFtaEtat . '\' AND ' . FtaProcessusCycleModel::FIELDNAME_PROCESSUS_NEXT . ' IS NOT NULL');
foreach ($arrayChapitreCycle as $rowsChapitreCycle) {
$where .= ' AND ' . FtaProcessusModel::TABLENAME . '.' . FtaProcessusModel::KEYNAME . ' <> ' . $rowsChapitreCycle[FtaProcessusCycleModel::FIELDNAME_PROCESSUS_NEXT];
}
//Récupération des chapitres à vérrouiller
$arrayChapitreVerrou = DatabaseOperation::convertSqlStatementWithoutKeyToArray('SELECT DISTINCT ' . FtaWorkflowStructureModel::FIELDNAME_ID_FTA_CHAPITRE . ' FROM ' . FtaProcessusModel::TABLENAME . ', ' . FtaWorkflowStructureModel::TABLENAME . ' WHERE ( ' . FtaProcessusModel::TABLENAME . '.' . FtaProcessusModel::KEYNAME . ' = ' . FtaWorkflowStructureModel::TABLENAME . '.' . FtaWorkflowStructureModel::FIELDNAME_ID_FTA_PROCESSUS . ' ) ' . ' AND ( ( ' . FtaProcessusModel::TABLENAME . '.' . FtaProcessusModel::KEYNAME . ' <>1 ' . $where . ' ) )');
break;
/* * **********
Fin de switch
* ********** */
}
//Traitement de la duplication
$option["abreviation_etat_destination"] = FtaEtatModel::ETAT_ABREVIATION_VALUE_MODIFICATION;
$option["designation_commerciale_fta"] = $new_designation_commerciale_fta;
$option["site_de_production"] = $siteDeProduction;
$action;
$id_fta_old = $id_fta;
/**
echo "
abreviation_etat_destination=$abreviation_etat_destination <br>
option[abreviation_etat_destination]=".$option["abreviation_etat_destination"]."<br>
option[designation_commerciale_fta]=".$option["designation_commerciale_fta"]."<br>
action=$action <br>
id_fta_old=$id_fta_old <br>
";
/* */
$id_fta_new = FtaModel::buildDuplicationFta($id_fta, $action, $option, $idFtaWorkflow);
FtaSuiviProjetModel::initFtaSuiviProjet($id_fta_new);
//echo $id_fta_new."<br>";
//Redirection
header("Location: duplicate.php?id_fta_original={$id_fta_old}&id_fta_new={$id_fta_new}&id_fta_role={$idFtaRole}");
}
//include ("./action_bs.php");
//include ("./action_sm.php");
?>
