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"); ?>