/**
* Affiche le tableau de récapitulatif des droits d'accès sur le module Fta
* @return string
*/
public static function getHtmlArrayAccesRightUser()
{
/**
* Entête du tableau
*/
$bloc .= "<" . "table " . "border=1 " . "width=100% " . "class=contenu " . ">" . "<th>" . "Utilisateurs" . "</th><th>" . "Accès général" . "</th><th>" . "Diffusion" . "</th><th>" . "Impression" . "</th><th>" . "Espace de travail <br>(Mettre la souris sur un espace de travail pour voir le détail) " . "</th>";
//lister les utilisateurs concernés
$arrayUser = self::getArrayUserWithAccesRightsToFta();
foreach ($arrayUser as $rowsUser) {
$lienWorkflow = "";
$listeRole = "";
$virgule = "";
$virgule2 = "";
//Tableau des id intranet actions Fta
$arrayAction = self::getArrayIdIntranetActionWithAccesRightsToFtaByUser($rowsUser[UserModel::KEYNAME]);
$bloc .= "<tr class=contenu><td>" . $rowsUser[UserModel::FIELDNAME_PRENOM] . " " . $rowsUser[UserModel::FIELDNAME_NOM] . "</td>";
/**
* Vérification des droits d'accès généraux
*/
$checkModification = FtaController::isValueInArray(IntranetNiveauAccesModel::NIVEAU_FTA_MODIFICATION, $arrayAction);
$checkConsultation = FtaController::isValueInArray(IntranetNiveauAccesModel::NIVEAU_FTA_CONSULTATION, $arrayAction);
$checkDiffusion = FtaController::isValueInArray(IntranetNiveauAccesModel::NIVEAU_FTA_DIFFUSION, $arrayAction);
$checkImpression = FtaController::isValueInArray(IntranetNiveauAccesModel::NIVEAU_FTA_IMPRESSION, $arrayAction);
/**
* Si accès Fta Modif
*/
if ($checkModification) {
$accesGeneralValue = "Modification";
$diffusion = "Voir espaces de Travail";
/**
* Identification des Id intranet action workflow
*/
$arrayIdIntranetParents = DatabaseOperation::convertSqlStatementWithoutKeyToArrayComplete(" SELECT " . IntranetActionsModel::KEYNAME . " FROM " . IntranetActionsModel::TABLENAME . " WHERE " . IntranetActionsModel::FIELDNAME_TAG_INTRANET_ACTIONS . "='" . IntranetActionsModel::VALUE_WORKFLOW . "' ");
$arrayIdActionWorkflow = array_intersect($arrayIdIntranetParents, $arrayAction);
if ($arrayIdActionWorkflow) {
foreach ($arrayIdActionWorkflow as $rowsIdActionWorkflow) {
$listeRole = "";
$virgule2 = "";
/**
* Identification du workflow
*/
$arrayIdIntranetParents = DatabaseOperation::convertSqlStatementWithoutKeyToArrayComplete(" SELECT " . FtaWorkflowModel::FIELDNAME_DESCRIPTION_FTA_WORKFLOW . " FROM " . FtaWorkflowModel::TABLENAME . " WHERE " . FtaWorkflowModel::FIELDNAME_ID_INTRANET_ACTIONS . "=" . $rowsIdActionWorkflow);
/**
* Identification des Id intranet action role du workflow
*/
$arrayIdIntranetRole = DatabaseOperation::convertSqlStatementWithoutKeyToArrayComplete(" SELECT " . IntranetActionsModel::KEYNAME . " FROM " . IntranetActionsModel::TABLENAME . " WHERE " . IntranetActionsModel::FIELDNAME_TAG_INTRANET_ACTIONS . "='" . IntranetActionsModel::VALUE_ROLE . "' " . " AND " . IntranetActionsModel::FIELDNAME_PARENT_INTRANET_ACTIONS . "=" . $rowsIdActionWorkflow);
$arrayIdActionRole = array_intersect($arrayIdIntranetRole, $arrayAction);
if ($arrayIdActionRole) {
foreach ($arrayIdActionRole as $rowsIdActionRole) {
/**
* Liste des rôles attribué pour le workflow
*/
$arrayRole = DatabaseOperation::convertSqlStatementWithoutKeyToArrayComplete(" SELECT " . FtaRoleModel::FIELDNAME_DESCRIPTION_FTA_ROLE . " FROM " . FtaRoleModel::TABLENAME . "," . FtaActionRoleModel::TABLENAME . " WHERE " . FtaActionRoleModel::FIELDNAME_ID_INTRANET_ACTIONS . "=" . $rowsIdActionRole . " AND " . FtaRoleModel::TABLENAME . "." . FtaRoleModel::KEYNAME . "=" . FtaActionRoleModel::TABLENAME . "." . FtaActionRoleModel::FIELDNAME_ID_FTA_ROLE);
$listeRole .= $virgule2 . $arrayRole["0"];
$virgule2 = ", ";
}
}
$lienWorkflow .= $virgule . "<span title=\" " . $listeRole . " \" >" . $arrayIdIntranetParents["0"] . "</span>";
$virgule = ", ";
}
}
/**
* Si accès Fta Consultation
*/
} elseif ($checkConsultation) {
$accesGeneralValue = "Consultation";
/**
* Droits de difussion
*/
if ($checkDiffusion) {
$geoModel = new GeoModel($rowsUser[UserModel::FIELDNAME_LIEU_GEO]);
$diffusion = $geoModel->getDataField(GeoModel::FIELDNAME_GEO)->getFieldValue();
} else {
$diffusion = "Non";
}
/**
* Droits de difussion
*/
} else {
$accesGeneralValue = "Non";
if ($checkDiffusion) {
$geoModel = new GeoModel($rowsUser[UserModel::FIELDNAME_LIEU_GEO]);
$diffusion = $geoModel->getDataField(GeoModel::FIELDNAME_GEO)->getFieldValue();
} else {
$diffusion = "Non";
}
}
/**
* Droits d'impression
*/
if ($checkImpression) {
$impression = "Oui";
} else {
$impression = "Non";
}
$bloc .= "<td>" . $accesGeneralValue . "</td>" . "<td>" . $diffusion . "</td>" . "<td>" . $impression . "</td>" . "<td>" . $lienWorkflow . "</td></tr>";
}
return $bloc;
}
/**
* Construction du Menu
* @param array $paramArrayRoleWorkflow
* @param array $paramRowsFtaEtatAndFta
* @param string $paramHtmlTable
* @param string $paramRoleNavigation
* @param GeoModel $paramGeoModel
* @param string $paramCreateur
* @param FtaRoleModel $paramFtaRoleModel
* @return string
*/
private static function buildMenu($paramArrayRoleWorkflow, $paramRowsFtaEtatAndFta, $paramHtmlTable, $paramRoleNavigation, GeoModel $paramGeoModel, $paramCreateur, FtaRoleModel $paramFtaRoleModel = NULL)
{
if ($paramRowsFtaEtatAndFta[FtaModel::FIELDNAME_CODE_ARTICLE_LDC]) {
$identifiant = '<b><font size=\'2\' color=\'#0000FF\'>' . $paramRowsFtaEtatAndFta[FtaModel::FIELDNAME_CODE_ARTICLE_LDC] . '</font></b>';
} else {
$identifiant = '<b><font size=\'2\' color=\'' . self::FONT_COLOR_DOSSIER_FTA . '\'>' . $paramRowsFtaEtatAndFta[FtaModel::FIELDNAME_DOSSIER_FTA] . 'v' . $paramRowsFtaEtatAndFta[FtaModel::FIELDNAME_VERSION_DOSSIER_FTA] . '</font></b>';
}
if ($paramRowsFtaEtatAndFta[FtaModel::FIELDNAME_COMMENTAIRE]) {
$commentaire = '<br><b><font size=\'2\' color=\'' . self::FONT_COLOR_CHAPITRE_COMMENTAIRE . '\'>' . $paramRowsFtaEtatAndFta[FtaModel::FIELDNAME_COMMENTAIRE] . '</font></b>';
} else {
$commentaire = '';
}
if ($paramRowsFtaEtatAndFta[FtaModel::FIELDNAME_LIBELLE]) {
$nom = $paramRowsFtaEtatAndFta[FtaModel::FIELDNAME_LIBELLE];
} else {
$nom = $paramRowsFtaEtatAndFta[FtaModel::FIELDNAME_DESIGNATION_COMMERCIALE];
}
if (count($paramArrayRoleWorkflow) > "1") {
$menu_navigation = '<' . $paramHtmlTable . '><tr><td class=titre_principal> <div align=\'left\'>
' . $identifiant . ' - ' . $nom . ' <i>(gérée par ' . $paramCreateur . ')</i></div>' . '<div align=\'left\'>' . $commentaire . '</div></td>' . '<td width=25% class=titre_principal>';
if (self::$abreviation_etat == FtaEtatModel::ETAT_ABREVIATION_VALUE_MODIFICATION) {
$menu_navigation .= $paramRoleNavigation;
}
$menu_navigation .= '<br> Site de Production : ' . $paramGeoModel->getDataField(GeoModel::FIELDNAME_GEO)->getFieldValue() . '<br> Espace de Travail : ' . $paramRowsFtaEtatAndFta[FtaWorkflowModel::FIELDNAME_DESCRIPTION_FTA_WORKFLOW] . '</td></tr></table>
<' . $paramHtmlTable . '>
<tr class = titre>';
} else {
$menu_navigation = '<' . $paramHtmlTable . '><tr><td class=titre_principal> <div align=\'left\'>
' . $identifiant . '- ' . $nom . ' <i>(gérée par ' . $paramCreateur . ')</i></div>' . '<div>' . $commentaire . '</div></td>' . '<td width=25% class=titre_principal>';
if (self::$abreviation_etat == FtaEtatModel::ETAT_ABREVIATION_VALUE_MODIFICATION) {
$menu_navigation .= ' Rôle : ' . $paramFtaRoleModel->getDataField(FtaRoleModel::FIELDNAME_DESCRIPTION_FTA_ROLE)->getFieldValue();
}
$menu_navigation .= '<br> Site de Production : ' . $paramGeoModel->getDataField(GeoModel::FIELDNAME_GEO)->getFieldValue() . '<br> Espace de Travail : ' . $paramRowsFtaEtatAndFta[FtaWorkflowModel::FIELDNAME_DESCRIPTION_FTA_WORKFLOW] . '</td></tr></table>
<' . $paramHtmlTable . '>
<tr class = titre>';
}
return $menu_navigation;
}
function Footer()
{
$globalConfig = new GlobalConfig();
//Positionnement à 1.5cm du bas
$marge_pied_page = -15;
$this->SetY($marge_pied_page);
//Police Arial italique 6
$this->SetFont('Arial', 'I', 6);
//Commentaire de bas de page statique
//$commentaire = "AGIS-SA Siège social: BP 931 - 802, rue Sainte Geneviève - ZI de Courtine 84 091 AVIGNON CEDEX 09"
// . "\nTel: 04.90.80.99.99 - Fax: 04.90.80.99.80 - Fax Gestion des Ventes: 04.74.05.32.68"
// ;
//Commentaire de bas de page dynamique
$geoModel = new GeoModel(5);
$adresseGeo = $geoModel->getDataField(GeoModel::FIELDNAME_ADRESSE_GEO)->getFieldValue();
$telephoneGeo = $geoModel->getDataField(GeoModel::FIELDNAME_TELEPHONE_GEO)->getFieldValue();
$faxGeo = $geoModel->getDataField(GeoModel::FIELDNAME_FAX_GEO)->getFieldValue();
$faxCommercialeGeo = $geoModel->getDataField(GeoModel::FIELDNAME_FAX_COMMERCIAL_GEO)->getFieldValue();
$commentaire = $adresseGeo . "\nTel: " . $telephoneGeo . " - Fax : " . $faxGeo . " - Fax Gestion des Ventes : " . $faxCommercialeGeo . "\nInformations susceptibles d'être modifiées, seule l'étiquette fait foi" . " (Env: " . $globalConfig->getConf()->getExecEnvironment() . " v" . $globalConfig->getConf()->getApplicationVersion() . ") ";
//Numéro de page centré
//$this->MultiCell(200,3,$commentaire.'Page '.$this->PageNo(). ' sur {nb}',0,'C');
$this->MultiCell(200, 3, $commentaire, 0, 'L');
$this->SetY($marge_pied_page);
$this->SetX(180);
$this->MultiCell(0, 3, "\nPage " . $this->PageNo() . " sur {nb}", 0, 'C');
}
function setXMLRecordsetBaliseArtSiteUpdateTwo(GeoModel $paramGeoModelSiteExpe, GeoModel $paramGeoModelSiteProd)
{
$this->XMLrecordsetBaliseArtSiteUpdateTwo = self::TABULATION . self::TABULATION . self::TABULATION . self::TABULATION . "<Recordset id=\"1\" action=\"update\">" . self::SAUT_DE_LIGNE . $this->getXMLArcadiaNoArtKey() . self::TABULATION . self::TABULATION . self::TABULATION . self::TABULATION . self::TABULATION . "<COD_SITE_GRP key=\"TRUE\">" . $paramGeoModelSiteExpe->getDataField(GeoModel::FIELDNAME_ID_SITE_GROUPE)->getFieldValue() . "</COD_SITE_GRP><!--" . $paramGeoModelSiteExpe->getDataField(GeoModel::FIELDNAME_GEO)->getFieldValue() . " -->" . self::SAUT_DE_LIGNE . self::TABULATION . self::TABULATION . self::TABULATION . self::TABULATION . self::TABULATION . "<NIVEAU key=\"TRUE\">1</NIVEAU><!-- Primare -->" . self::SAUT_DE_LIGNE . self::TABULATION . self::TABULATION . self::TABULATION . self::TABULATION . self::TABULATION . "<DATE_FIN_EFFET>" . date("d/m/Y") . "</DATE_FIN_EFFET>" . self::SAUT_DE_LIGNE . self::RECORDSET_END . self::SAUT_DE_LIGNE . self::TABULATION . self::TABULATION . self::TABULATION . self::TABULATION . "<Recordset id=\"2\" action=\"update\">" . self::SAUT_DE_LIGNE . $this->getXMLArcadiaNoArtKey() . self::TABULATION . self::TABULATION . self::TABULATION . self::TABULATION . self::TABULATION . "<COD_SITE_GRP key=\"TRUE\">" . $paramGeoModelSiteProd->getDataField(GeoModel::FIELDNAME_ID_SITE_GROUPE)->getFieldValue() . "</COD_SITE_GRP><!--" . $paramGeoModelSiteProd->getDataField(GeoModel::FIELDNAME_GEO)->getFieldValue() . " -->" . self::SAUT_DE_LIGNE . self::TABULATION . self::TABULATION . self::TABULATION . self::TABULATION . self::TABULATION . "<NIVEAU key=\"TRUE\">2</NIVEAU><!-- Secondaire -->" . self::SAUT_DE_LIGNE . self::TABULATION . self::TABULATION . self::TABULATION . self::TABULATION . self::TABULATION . "<DATE_FIN_EFFET>" . date("d/m/Y") . "</DATE_FIN_EFFET>" . self::SAUT_DE_LIGNE . self::RECORDSET_END . self::SAUT_DE_LIGNE;
}
$description_origine_transformation_fta = $ftaModel->getDataField(FtaModel::FIELDNAME_PRODUIT_TRANSFORME)->getFieldValue();
$idFtaWorkflow = $ftaModel->getDataField(FtaModel::FIELDNAME_WORKFLOW)->getFieldValue();
switch ($description_origine_transformation_fta) {
case "0":
$description_origine_transformation_fta = "Non";
break;
case "1":
case "2":
$description_origine_transformation_fta = "Oui";
break;
}
$NOM_origine_transformation_fta = $ftaModel->getDataField(FtaModel::FIELDNAME_PRODUIT_TRANSFORME)->getFieldLabel();
$synoptique_valide_fta = $ftaModel->getDataField(FtaModel::FIELDNAME_DESCRIPTION_DU_PRODUIT)->getFieldValue();
$NOM_synoptique_valide_fta = $ftaModel->getDataField(FtaModel::FIELDNAME_DESCRIPTION_DU_PRODUIT)->getFieldLabel();
$geoModel = new GeoModel($siteDeProduction);
$site_agrement_ce = $geoModel->getDataField(GeoModel::FIELDNAME_SITE_AGREMENT_CE)->getFieldValue();
$NOM_site_agrement_ce = $geoModel->getDataField(GeoModel::FIELDNAME_SITE_AGREMENT_CE)->getFieldLabel();
//Récupération des information de classification.
//Rayon
$IdFtaClassification2 = $ftaModel->getDataField(FtaModel::FIELDNAME_ID_FTA_CLASSIFICATION2)->getFieldValue();
if ($IdFtaClassification2) {
$rayon = ClassificationArborescenceArticleCategorieContenuModel::getElementClassificationFta($IdFtaClassification2, ClassificationFta2Model::FIELDNAME_ID_RAYON);
//Activité
$activite = ClassificationArborescenceArticleCategorieContenuModel::getElementClassificationFta($IdFtaClassification2, ClassificationFta2Model::FIELDNAME_ID_ACTIVITE);
if ($activite) {
$activite = " / " . $activite;
}
//Marque
$marque = ClassificationArborescenceArticleCategorieContenuModel::getElementClassificationFta($IdFtaClassification2, ClassificationFta2Model::FIELDNAME_ID_MARQUE);
if ($marque) {
$marque = " / " . $marque;
