/**
* Affiche la liste déroulante des elements d'arborescence d'une classification
* @param type $paramIdClaasifElement
* @param type $paramIsEditable
* @return string
*/
public static function getListeDeroulanteClassifElement($paramIdClaasifElement, $paramIsEditable)
{
//Contenu
$nom_liste = self::KEYNAME;
$reqListeActivite = "SELECT " . self::KEYNAME . ", " . self::FIELDNAME_NOM_CLASSIFICATION_ARBORESCENCE_ARTICLE_CATEGORIE . " FROM " . self::TABLENAME . " ORDER BY " . self::KEYNAME;
$id_defaut = $paramIdClaasifElement;
$listeDesClassifElement = AccueilFta::afficherRequeteEnListeDeroulante($reqListeActivite, $id_defaut, $nom_liste, $paramIsEditable);
return $listeDesClassifElement;
}
$message = UserInterfaceMessage::FR_WARNING_ACCES_RIGHTS;
$redirection = "index.php";
Lib::showMessage($titre, $message, $redirection, TRUE);
}
$bloc .= "<" . $html_table . "><tr class=titre>" . "<td>Espace de travail</td>" . "<td width=10% >Dossier FTA</td>" . "<td>Code Article</td>" . "<td>Désignation Commerciale</td>" . "<td>Classification actuelle</td>" . "<td>Modifier une classification</td>" . "</tr>";
/**
* On récupère le tableau complet des dossier Fta n'ayant pas de classification
*/
$arrayDossierComplet = DatabaseOperation::convertSqlStatementWithoutKeyToArray("SELECT DISTINCT " . FtaModel::FIELDNAME_DOSSIER_FTA . " FROM " . FtaModel::TABLENAME . " , " . FtaActionSiteModel::TABLENAME . " , " . FtaWorkflowModel::TABLENAME . " , " . IntranetDroitsAccesModel::TABLENAME . " , " . IntranetActionsModel::TABLENAME . " , " . ClassificationFta2Model::TABLENAME . " WHERE " . FtaModel::TABLENAME . "." . FtaModel::FIELDNAME_WORKFLOW . " = " . FtaWorkflowModel::TABLENAME . "." . FtaWorkflowModel::KEYNAME . " AND " . FtaModel::TABLENAME . "." . FtaModel::FIELDNAME_ID_FTA_CLASSIFICATION2 . "=" . ClassificationFta2Model::TABLENAME . "." . ClassificationFta2Model::KEYNAME . " AND " . FtaWorkflowModel::TABLENAME . "." . FtaWorkflowModel::FIELDNAME_ID_INTRANET_ACTIONS . "=" . IntranetActionsModel::TABLENAME . "." . IntranetActionsModel::FIELDNAME_PARENT_INTRANET_ACTIONS . " AND " . IntranetDroitsAccesModel::TABLENAME . "." . IntranetDroitsAccesModel::FIELDNAME_ID_INTRANET_ACTIONS . "=" . IntranetActionsModel::TABLENAME . "." . IntranetActionsModel::KEYNAME . " AND " . FtaActionSiteModel::TABLENAME . "." . FtaActionSiteModel::FIELDNAME_ID_INTRANET_ACTIONS . " IN (" . IntranetActionsModel::TABLENAME . "." . IntranetActionsModel::KEYNAME . ")" . ' AND ( 0 ' . IntranetActionsModel::addIdIntranetAction($_SESSION[Acl::ACL_INTRANET_ACTIONS_VALIDE]) . ")" . " AND " . IntranetDroitsAccesModel::FIELDNAME_NIVEAU_INTRANET_DROITS_ACCES . "=" . IntranetNiveauAccesModel::NIVEAU_GENERIC_TRUE . " AND " . IntranetDroitsAccesModel::FIELDNAME_ID_USER . "=" . $idUser . " GROUP BY " . FtaModel::FIELDNAME_DOSSIER_FTA);
$nbDeResulta = count($arrayDossierComplet);
$nbMaxParPage = "200";
/**
* Calcul des enregistrements à afficher
*/
$debut = ($numeroDePageCourante - '1') * $nbMaxParPage;
$pagination = AccueilFta::paginerClassification($nbMaxParPage, $numeroDePageCourante, '4', '4', '1', '1', $nbDeResulta);
/**
* On récupère le tableau limité des dossier Fta n'ayant pas de classification
*/
$arrayDossier = DatabaseOperation::convertSqlStatementWithoutKeyToArray("SELECT DISTINCT " . FtaModel::FIELDNAME_DOSSIER_FTA . " FROM " . FtaModel::TABLENAME . " , " . FtaActionSiteModel::TABLENAME . " , " . FtaWorkflowModel::TABLENAME . " , " . IntranetDroitsAccesModel::TABLENAME . " , " . IntranetActionsModel::TABLENAME . " , " . ClassificationFta2Model::TABLENAME . " WHERE " . FtaModel::TABLENAME . "." . FtaModel::FIELDNAME_WORKFLOW . " = " . FtaWorkflowModel::TABLENAME . "." . FtaWorkflowModel::KEYNAME . " AND " . FtaModel::TABLENAME . "." . FtaModel::FIELDNAME_ID_FTA_CLASSIFICATION2 . "=" . ClassificationFta2Model::TABLENAME . "." . ClassificationFta2Model::KEYNAME . " AND " . FtaWorkflowModel::TABLENAME . "." . FtaWorkflowModel::FIELDNAME_ID_INTRANET_ACTIONS . "=" . IntranetActionsModel::TABLENAME . "." . IntranetActionsModel::FIELDNAME_PARENT_INTRANET_ACTIONS . " AND " . IntranetDroitsAccesModel::TABLENAME . "." . IntranetDroitsAccesModel::FIELDNAME_ID_INTRANET_ACTIONS . "=" . IntranetActionsModel::TABLENAME . "." . IntranetActionsModel::KEYNAME . " AND " . FtaActionSiteModel::TABLENAME . "." . FtaActionSiteModel::FIELDNAME_ID_INTRANET_ACTIONS . " IN (" . IntranetActionsModel::TABLENAME . "." . IntranetActionsModel::KEYNAME . ")" . ' AND ( 0 ' . IntranetActionsModel::addIdIntranetAction($_SESSION[Acl::ACL_INTRANET_ACTIONS_VALIDE]) . ")" . " AND " . IntranetDroitsAccesModel::FIELDNAME_NIVEAU_INTRANET_DROITS_ACCES . "=" . IntranetNiveauAccesModel::NIVEAU_GENERIC_TRUE . " AND " . IntranetDroitsAccesModel::FIELDNAME_ID_USER . "=" . $idUser . " GROUP BY " . FtaModel::FIELDNAME_DOSSIER_FTA . " ORDER BY " . FtaWorkflowModel::TABLENAME . "." . FtaWorkflowModel::KEYNAME . "," . ClassificationFta2Model::TABLENAME . "." . ClassificationFta2Model::KEYNAME . "," . FtaModel::FIELDNAME_ID_FTA_ETAT . "," . FtaModel::FIELDNAME_CODE_ARTICLE_LDC . "," . FtaModel::FIELDNAME_DESIGNATION_COMMERCIALE . " LIMIT " . $nbMaxParPage . " OFFSET " . $debut);
/**
* on récupère la dernière version
*/
foreach ($arrayDossier as $rowsDossier) {
$idDossierFta = $rowsDossier[FtaModel::FIELDNAME_DOSSIER_FTA];
$arrayContenu = DatabaseOperation::convertSqlStatementWithoutKeyToArray("SELECT " . FtaWorkflowModel::FIELDNAME_DESCRIPTION_FTA_WORKFLOW . "," . FtaModel::FIELDNAME_DOSSIER_FTA . "," . FtaModel::TABLENAME . "." . FtaModel::FIELDNAME_ID_FTA_CLASSIFICATION2 . "," . FtaModel::FIELDNAME_CODE_ARTICLE_LDC . "," . FtaModel::FIELDNAME_DESIGNATION_COMMERCIALE . " FROM " . FtaModel::TABLENAME . " , " . FtaActionSiteModel::TABLENAME . " , " . FtaWorkflowModel::TABLENAME . " , " . IntranetDroitsAccesModel::TABLENAME . " , " . IntranetActionsModel::TABLENAME . " , " . ClassificationFta2Model::TABLENAME . " WHERE " . FtaModel::FIELDNAME_DOSSIER_FTA . "=" . $idDossierFta . " AND " . FtaModel::TABLENAME . "." . FtaModel::FIELDNAME_WORKFLOW . " = " . FtaWorkflowModel::TABLENAME . "." . FtaWorkflowModel::KEYNAME . " AND " . FtaModel::TABLENAME . "." . FtaModel::FIELDNAME_ID_FTA_CLASSIFICATION2 . "=" . ClassificationFta2Model::TABLENAME . "." . ClassificationFta2Model::KEYNAME . " AND " . FtaWorkflowModel::TABLENAME . "." . FtaWorkflowModel::FIELDNAME_ID_INTRANET_ACTIONS . "=" . IntranetActionsModel::TABLENAME . "." . IntranetActionsModel::FIELDNAME_PARENT_INTRANET_ACTIONS . " AND " . IntranetDroitsAccesModel::TABLENAME . "." . IntranetDroitsAccesModel::FIELDNAME_ID_INTRANET_ACTIONS . "=" . IntranetActionsModel::TABLENAME . "." . IntranetActionsModel::KEYNAME . " AND " . FtaActionSiteModel::TABLENAME . "." . FtaActionSiteModel::FIELDNAME_ID_INTRANET_ACTIONS . " IN (" . IntranetActionsModel::TABLENAME . "." . IntranetActionsModel::KEYNAME . ")" . ' AND ( 0 ' . IntranetActionsModel::addIdIntranetAction($_SESSION[Acl::ACL_INTRANET_ACTIONS_VALIDE]) . ")" . " AND " . IntranetDroitsAccesModel::FIELDNAME_NIVEAU_INTRANET_DROITS_ACCES . "=" . IntranetNiveauAccesModel::NIVEAU_GENERIC_TRUE . " AND " . IntranetDroitsAccesModel::FIELDNAME_ID_USER . "=" . $idUser);
if ($arrayContenu) {
foreach ($arrayContenu as $rowsContenu) {
$descriptionFtaWorkflow = $rowsContenu[FtaWorkflowModel::FIELDNAME_DESCRIPTION_FTA_WORKFLOW];
$idDossier = $rowsContenu[FtaModel::FIELDNAME_DOSSIER_FTA];
$codeArticleLdc = $rowsContenu[FtaModel::FIELDNAME_CODE_ARTICLE_LDC];
$title = 'Liste des toutes les Fiches Techniques Emballages (FTE)';
$req_liste_emballage = $common_select . $common_from . $common_where . $common_order;
$checked = 'checked';
$page_reload = 0;
break;
case 0:
default:
$title = 'Liste des Fiches Techniques Emballages (FTE) déjà utilisées dans des Fiches Techniques Articles validées pour le site';
$req_liste_emballage = $common_select . $common_from . ',' . FtaConditionnementModel::TABLENAME . ', ' . FtaModel::TABLENAME . $common_where . ' AND ' . AnnexeEmballageModel::TABLENAME . '.' . AnnexeEmballageModel::KEYNAME . '=' . FtaConditionnementModel::TABLENAME . '.' . FtaConditionnementModel::FIELDNAME_ID_ANNEXE_EMBALLAGE . ' AND ' . FtaModel::TABLENAME . '.' . FtaModel::KEYNAME . '=' . FtaConditionnementModel::TABLENAME . '.' . FtaConditionnementModel::FIELDNAME_ID_FTA . $common_order;
$checked = '';
$page_reload = 1;
}
$nom_liste = AnnexeEmballageModel::KEYNAME;
$id_defaut = $nom_liste;
$req_liste_emballage;
$bloc .= $title . ': <br><br>' . AccueilFta::afficherRequeteEnListeDeroulante($req_liste_emballage, $id_defaut, $nom_liste, TRUE);
$bloc .= '</td><tr>';
$bloc .= '<tr><td>' . '<input type = \'checkbox\' onClick=\'js_page_reload()\' value=\'1\' ' . $checked . ' /> Voir toutes les Fiches Techniques Emballages (FTE)?' . '<input type=hidden name=page_reload value=' . $page_reload . '>' . '</td></tr>';
break;
case 'etape3':
//Personnalisation de la FTE
$is_editable = true;
$annexeEmballageModel->setIsEditable($is_editable);
//Longueur de l'emballage
$bloc .= $annexeEmballageModel->getHtmlDataField(AnnexeEmballageModel::FIELDNAME_LONGUEUR_ANNEXE_EMBALLAGE);
//Largeur de l'emballage
$bloc .= $annexeEmballageModel->getHtmlDataField(AnnexeEmballageModel::FIELDNAME_LARGEUR_ANNEXE_EMBALLAGE);
//Hauteur de l'emballage
$bloc .= $annexeEmballageModel->getHtmlDataField(AnnexeEmballageModel::FIELDNAME_HAUTEUR_ANNEXE_EMBALLAGE);
//Poids de l'emballage
$bloc .= $annexeEmballageModel->getHtmlDataField(AnnexeEmballageModel::FIELDNAME_POIDS_ANNEXE_EMBALLAGE);
public static function getListeClassificationLabel($paramAscendent, $paramIdDefaut, $paramSelect, $paramOrig, $paramNomDefaut, $paramIsEditable, $paramMarque2 = NULL)
{
if ($paramAscendent != NULL) {
$req = 'SELECT DISTINCT ' . $paramSelect . ' FROM ' . ClassificationFta2Model::TABLENAME . ' WHERE ' . $paramOrig . ' = ' . $paramAscendent;
if (self::$idProprietaireGroupe) {
$req .= ' AND ' . ClassificationFta2Model::FIELDNAME_ID_PROPRIETAIRE_GROUPE . ' = ' . self::$idProprietaireGroupe;
}
if (self::$idProprietaireEnseigne != NULL) {
$req .= ' AND ' . ClassificationFta2Model::FIELDNAME_ID_PROPRIETAIRE_ENSEIGNE . ' = ' . self::$idProprietaireEnseigne;
}
if (self::$idMarque) {
$req .= ' AND ' . ClassificationFta2Model::FIELDNAME_ID_MARQUE . ' = ' . self::$idMarque;
}
if (self::$idActivite) {
$req .= ' AND ' . ClassificationFta2Model::FIELDNAME_ID_ACTIVITE . ' = ' . self::$idActivite;
}
if (self::$idRayon) {
$req .= ' AND ' . ClassificationFta2Model::FIELDNAME_ID_RAYON . ' = ' . self::$idRayon;
}
if (self::$idEnvironnement) {
$req .= ' AND ' . ClassificationFta2Model::FIELDNAME_ID_ENVIRONNEMENT . ' = ' . self::$idEnvironnement;
}
if (self::$idSaisonnalite) {
$req .= ' AND ' . ClassificationFta2Model::FIELDNAME_ID_SAISONNALITE . ' = ' . self::$idSaisonnalite;
}
$array = DatabaseOperation::convertSqlStatementWithoutKeyToArray($req);
foreach ($array as $value) {
$return[] = $value[$paramSelect];
}
}
//Traitement du Warning Update
if (self::$paramWarningUpdate) {
$image_modif = Html::DEFAULT_HTML_WARNING_UPDATE_IMAGE;
$color_modif = Html::DEFAULT_HTML_WARNING_UPDATE_BGCOLOR;
}
$reqClassification = 'SELECT ' . ClassificationArborescenceArticleCategorieContenuModel::KEYNAME . ',' . ClassificationArborescenceArticleCategorieContenuModel::FIELDNAME_NOM_CLASSIFICATION_ARBORESCENCE_ARTICLE_CATEGORIE_CONTENU . ' FROM ' . ClassificationArborescenceArticleCategorieContenuModel::TABLENAME . ' WHERE ( 0 ' . ClassificationFta2Model::AddIdClassificationArborescenceArticleCategorieContenu($return) . ') ORDER BY ' . ClassificationArborescenceArticleCategorieContenuModel::FIELDNAME_NOM_CLASSIFICATION_ARBORESCENCE_ARTICLE_CATEGORIE_CONTENU;
$listeClassification = '<tr><td class=contenu style=\'' . $color_modif . '\' >' . DatabaseDescription::getFieldDocLabel(ClassificationFta2Model::TABLENAME, $paramSelect) . '</td><td class=contenu width=75% style=\'' . $color_modif . '\' >' . AccueilFta::afficherRequeteEnListeDeroulante($reqClassification, $paramIdDefaut, $paramNomDefaut, $paramIsEditable, TRUE) . ' ' . $image_modif . '</td></tr>';
return $listeClassification;
}
$page_action = "derogation_duree_vie_produit.php";
$page_pdf = $page_default . "_pdf.php";
$action = 'etape1';
//Action proposée à la page _post.php
$method = 'POST';
//Pour une url > 2000 caractères, ne pas utiliser utiliser GET
$html_table = "table " . "border=1 " . "width=100% " . "class=contenu ";
/*
Dérogationc Colis
*/
$type_derogation = "<select name=\"type_derogation\" size=\"1\">\n <option value=1>Réduire</option>\n <option value=2>Augmenter</option>\n </select>\n ";
//Listes déroulantes
//Selection de l'Article Validés et Actifs
$req_liste_agrologic = "SELECT id_access_arti2" . ", CONCAT_WS(' - ', CODE_ARTICLE, LIBELLE) " . "FROM access_arti2 " . "WHERE CODE_ARTICLE IS NOT NULL AND actif=-1 " . "ORDER BY CODE_ARTICLE ";
$id_defaut = $id_access_arti2;
$liste_article = AccueilFta::afficherRequeteEnListeDeroulante($req_liste_agrologic, $id_defaut, "id_access_arti2", TRUE);
$liste_id_agrologic = $liste_article . $liste_produit;
//Liste des dérogations
$bloc = "<{$html_table}>" . "<tr class=titre_principal><td>" . DatabaseDescription::getFieldDocLabel("fta_derogation_duree_vie", "date_fta_derogation_duree_vie") . "</td><td>" . DatabaseDescription::getFieldDocLabel("fta_derogation_duree_vie", "createur_fta_derogation_duree_vie") . "</td><td>" . DatabaseDescription::getFieldDocLabel("fta_derogation_duree_vie", "id_agrologic_fta_derogation_duree_vie") . "</td><td>" . DatabaseDescription::getFieldDocLabel("fta_derogation_duree_vie", "lot_fta_derogation_duree_vie") . "</td><td>" . DatabaseDescription::getFieldDocLabel("fta_derogation_duree_vie", "duree_vie_production_fta_derogation_duree_vie") . "</td><td>" . DatabaseDescription::getFieldDocLabel("fta_derogation_duree_vie", "utilise_fta_derogation_duree_vie") . "</td></tr>" . "<tr class=contenu><td>" . date("Y-m-d") . "<input type=\"hidden\" name=\"date_fta_derogation_duree_vie\" value=\"" . date("Y-m-d") . "\" />" . "</td><td>" . $prenom . " " . $nom_famille_ses . "<input type=hidden name=createur_fta_derogation_duree_vie value={$id_user}>" . "</td><td>" . $liste_id_agrologic . "</td><td>" . $type_derogation . "</td><td>" . "<input type=submit value='Ajouter'>" . "</td><td>" . "</td><td>" . "</td></tr>";
$message = "?";
$url = "index.php";
$req = "SELECT * " . "FROM fta_derogation_duree_vie " . "ORDER BY type_fta_derogation_duree_vie ASC, date_fta_derogation_duree_vie DESC ";
$result = DatabaseOperation::queryPDO($req);
$bloc .= "<tr class=titre_principal><td colspan=7>" . "Dérogations Colis" . "</td></tr>";
$passage_produit = 0;
foreach ($result as $rows) {
//Mise en forme du tableau
//Ajout du Titre des dérogations Produits
if ($passage_produit == 0 and $rows["type_fta_derogation_duree_vie"] == 1) {
$bloc .= "<tr class=titre_principal><td colspan=7>" . "Dérogations Sachets" . "</td></tr>";
$passage_produit = 1;
*/
AccueilFta::initAccueil($id_user, $id_fta_etat, $nomFtaEtat, $synthese_action, $idFtaRoleEncours, $order_common, $debut, $numeroDePageCourante, $lieuGeo);
/*
* Génération de la barre de navigation de la page d'accueil
*/
$tableau_synthese .= AccueilFta::getTableauSythese();
$choix = 1;
if ($synthese_action) {
//echo $id_fta_etat;
//$tableau_fiche = AccueilFta::getTableauFiche($id_fta_etat, $choix, $isLimit, $order_common);
/**
* traitement long
*/
$tableau_fiche = AccueilFta::getHtmlTableauFiche();
// $fileAriane = AccueilFta::getFileAriane();
$pagination = AccueilFta::paginer(ModuleConfig::VALUE_MAX_PAR_PAGE, $numeroDePageCourante, '4', '4', '1', '1');
}
/* * ************
Début Code HTML
* ************ */
//Construction de la page <td> </td>
echo '
<form name=\'modification_fiche\' method=post action=' . $page_action . ' id=\'idOfForm\' >
<input type=hidden name=id_fta_etat value=' . $id_fta_etat_encours . '>
<input type=hidden name=nom_fta_etat value=' . $nom_fta_etat_encours . '>
<input type=hidden name=\'id_fta_role\' value=' . $idFtaRoleEncours . ' >
<input type=hidden name=\'id_fta\' id=id_fta >
<input type=hidden name=\'id_fta_etat\' value=' . $id_fta_etat . '>
<input type=\'hidden\' name=\'synthese_action\' value=' . $synthese_action . ' />
<input type=hidden name=\'abreviation_fta_etat\' value=' . $abreviationFtaEtat . ' >
<input type=\'hidden\' name=\'comeback\' value=1 />
$nom_liste = "id_annexe_emballage_groupe";
if ($proprietaire) {
$req = "SELECT id_annexe_emballage_groupe, nom_annexe_emballage_groupe FROM annexe_emballage_groupe " . "ORDER BY nom_annexe_emballage_groupe";
$value = AccueilFta::afficherRequeteEnListeDeroulante($req, $id_defaut, $champ, TRUE);
} else {
$value = $annexeEmballageGroupeModel->getDataField($champ)->getFieldValue();
}
$bloc .= "<tr class=contenu><td>" . mysql_field_desc("annexe_emballage_groupe", $champ) . "</td><td>" . $value . "</td></tr>";
//Fournisseur
$nom_table = "fte_fournisseur";
$champ = "nom_fte_fournisseur";
$id_defaut = $id_fte_fournisseur;
$nom_liste = "id_fte_fournisseur";
if ($proprietaire) {
$req = "SELECT id_fte_fournisseur, nom_fte_fournisseur FROM fte_fournisseur " . "ORDER BY nom_fte_fournisseur";
$value = AccueilFta::afficherRequeteEnListeDeroulante($req, $id_defaut, $champ, TRUE);
} else {
$value = $fteFournisseurModel->getDataField($champ)->getFieldValue();
}
$bloc .= "<tr class=contenu><td>" . mysql_field_desc($nom_table, $champ) . "</td><td>" . $value . "</td></tr>";
//Référence Interne
$champ = "reference_fournisseur_annexe_emballage";
$bloc .= "<tr class=contenu><td>" . mysql_field_desc("annexe_emballage", $champ) . "</td><td>";
if ($id_annexe_emballage) {
$reference_fournisseur_annexe_emballage = $annexeEmballageModel->getDataField($champ)->getFieldValue();
}
if ($proprietaire) {
$value = "<input type=text name=" . $champ . " value='" . $reference_fournisseur_annexe_emballage . "' size=50/>";
} else {
$value = $reference_fournisseur_annexe_emballage;
}
$page_action = $page_default . ".php";
//On force à revenir sur cette page pour passer à l'étape 2
break;
case 2:
//Etape 2
$titre = "Ajout d'un nouvel élément de Classification";
$submit_label = "Ajouter";
$id_classification_arborescence_article_categorie = $add_id_classification_arborescence_article_categorie;
$classificationArborescenceArticleCategorieModel = new ClassificationArborescenceArticleCategorieModel($id_classification_arborescence_article_categorie);
$nom_classification_arborescence_article_categorie = $classificationArborescenceArticleCategorieModel->getDataField(ClassificationArborescenceArticleCategorieModel::FIELDNAME_NOM_CLASSIFICATION_ARBORESCENCE_ARTICLE_CATEGORIE)->getFieldValue();
//Contenu
$nom_liste = "id_classification_arborescence_article_categorie_contenu";
$bloc .= "<tr><td>{$nom_classification_arborescence_article_categorie}:</td><td>";
$req_liste_site_assemblage = "SELECT id_classification_arborescence_article_categorie_contenu, nom_classification_arborescence_article_categorie_contenu " . "FROM classification_arborescence_article_categorie_contenu " . "WHERE id_classification_arborescence_article_categorie={$id_classification_arborescence_article_categorie} " . "ORDER BY nom_classification_arborescence_article_categorie_contenu ";
$id_defaut = $id_classification_arborescence_article_categorie_contenu;
$bloc .= AccueilFta::afficherRequeteEnListeDeroulante($req_liste_site_assemblage, $id_defaut, $nom_liste, TRUE);
$bloc .= "</td></tr>";
//Classification Controle de Gestion
if (!$suivant_classification_arborescence_article_categorie) {
$bloc .= "<{$html_table}>\n <tr class=titre><td>Code de regroupement controle de gestion\n </td></tr>\n <tr><td>\n <{$html_table}>\n <tr><td>\n " . mysql_field_desc("classification_arborescence_article", "FAMILLE_ARTICLE") . "\n </td><td>\n <input type=\"text\" name=\"FAMILLE_ARTICLE\" size=\"20\" />\n <a href=l:rp_data.mdb target=_blank>\n <img src=../lib/images/bouton_aide_point_interrogation.gif width=25 height=26 border=0 /> </a>\n </td></tr>\n <tr><td>\n " . mysql_field_desc("classification_arborescence_article", "FAMILLE_MKTG") . "\n </td><td>\n <input type=\"text\" name=\"FAMILLE_MKTG\" size=\"20\" />\n <a href=l:rp_data.mdb target=_blank>\n <img src=../lib/images/bouton_aide_point_interrogation.gif width=25 height=26 border=0 /> </a>\n </td></tr>\n </table>\n </td></tr>\n ";
}
$action = "valider";
$page_action = $page_default . "_post.php";
break;
case "modifier":
$titre = "Modification de l'élément";
$submit_label = "Modifier";
//Classification Controle de Gestion
$classificationArborescenceArticleModel = new ClassificationArborescenceArticleModel($id_classification_arborescence_article);
$id_classification_arborescence_article_categorie_contenu = $classificationArborescenceArticleModel->getDataField(ClassificationArborescenceArticleModel::FIELDNAME_ID_CLASSIFICATION_ARBORESCENCE_ARTICLE_CATEGORIE_CONTENU)->getFieldValue();
$classificationArborescenceArticleCategorieContenuModel = new ClassificationArborescenceArticleCategorieContenuModel($id_classification_arborescence_article_categorie_contenu);
/**
* Ajoute de la fonction de traitement de masse
* @param type $paramAbreviationFtaEtat
* @return string
*/
public static function getListeFtaGrouper($paramAbreviationFtaEtat)
{
$requete = 'SELECT ' . FtaTransitionModel::FIELDNAME_ABREVIATION_FTA_TRANSITION . ',' . FtaEtatModel::FIELDNAME_NOM_FTA_ETAT . ' FROM ' . FtaTransitionModel::TABLENAME . ',' . FtaEtatModel::TABLENAME . ' WHERE ' . FtaTransitionModel::TABLENAME . '.' . FtaTransitionModel::FIELDNAME_ABREVIATION_FTA_ETAT . '=\'' . $paramAbreviationFtaEtat . '\' ' . ' AND ' . FtaEtatModel::TABLENAME . '.' . FtaEtatModel::FIELDNAME_ABREVIATION . '=' . FtaTransitionModel::TABLENAME . '.' . FtaTransitionModel::FIELDNAME_ABREVIATION_FTA_TRANSITION;
$nom_defaut = FtaTransitionModel::FIELDNAME_ABREVIATION_FTA_TRANSITION;
$id_defaut = FtaEtatModel::ETAT_ABREVIATION_VALUE_VALIDE;
return $liste_action_groupe = AccueilFta::afficherRequeteEnListeDeroulante($requete, $id_defaut, $nom_defaut, TRUE);
}
