/** * Affiche la liste des site de production pour lesquel l'utilisateur connecté à les droits d'accès * @param int $paramIdUser * @param HtmlListSelectTagName $paramObjet * @param boolean $paramIsEditable * @param int $paramIdDefault * @return string */ public static function showListeDeroulanteSiteProdByAcces($paramIdUser, HtmlListSelectTagName $paramObjet, $paramIsEditable, $paramIdDefault) { $arraySite = DatabaseOperation::convertSqlStatementWithKeyAndOneFieldToArray('SELECT DISTINCT ' . GeoModel::KEYNAME . ',' . GeoModel::FIELDNAME_GEO . ' FROM ' . GeoModel::TABLENAME . ', ' . FtaActionSiteModel::TABLENAME . ', ' . IntranetActionsModel::TABLENAME . ', ' . IntranetDroitsAccesModel::TABLENAME . ' WHERE ' . GeoModel::FIELDNAME_GEO . '<>\'\'' . ' AND ' . FtaActionSiteModel::TABLENAME . '.' . FtaActionSiteModel::FIELDNAME_ID_SITE . '=' . GeoModel::KEYNAME . ' AND ' . IntranetActionsModel::TABLENAME . '.' . IntranetActionsModel::KEYNAME . ' AND ' . FtaActionSiteModel::TABLENAME . '.' . FtaActionSiteModel::FIELDNAME_ID_INTRANET_ACTIONS . '=' . IntranetActionsModel::TABLENAME . '.' . IntranetActionsModel::KEYNAME . ' AND ' . IntranetActionsModel::TABLENAME . '.' . IntranetActionsModel::KEYNAME . '=' . IntranetDroitsAccesModel::TABLENAME . '.' . IntranetDroitsAccesModel::FIELDNAME_ID_INTRANET_ACTIONS . ' AND ' . IntranetDroitsAccesModel::FIELDNAME_ID_USER . '=' . $paramIdUser . ' AND ' . IntranetDroitsAccesModel::TABLENAME . '.' . IntranetDroitsAccesModel::FIELDNAME_NIVEAU_INTRANET_DROITS_ACCES . '=' . IntranetNiveauAccesModel::NIVEAU_GENERIC_TRUE . ' ORDER BY ' . GeoModel::FIELDNAME_GEO); $paramObjet->setArrayListContent($arraySite); $paramObjet->getAttributes()->getName()->setValue(GeoModel::KEYNAME); $paramObjet->setLabel(DatabaseDescription::getFieldDocLabel(GeoModel::TABLENAME, GeoModel::FIELDNAME_GEO)); $paramObjet->setIsEditable($paramIsEditable); $paramObjet->setSelectedValue($paramIdDefault); $listeSiteProduction = $paramObjet->getHtmlResult(); return $listeSiteProduction; }
/** * Affiche la liste des espaces de travail pour lesquel l'utilisateur connecté à les droits d'accès * @param int $paramIdUser * @param HtmlListSelectTagName $paramObjetList * @param boolean $paramIsEditable * @param int $paramIdDefault * @return string */ public static function showListeDeroulanteNomWorkflowByAcces($paramIdUser, HtmlListSelectTagName $paramObjetList, $paramIsEditable, $paramIdRole, $paramIdDefault = NULL) { $arrayWorkflow = DatabaseOperation::convertSqlStatementWithKeyAndOneFieldToArray('SELECT DISTINCT ' . self::TABLENAME . '.' . self::KEYNAME . ',' . self::FIELDNAME_DESCRIPTION_FTA_WORKFLOW . ' FROM ' . self::TABLENAME . ', ' . IntranetDroitsAccesModel::TABLENAME . ', ' . FtaWorkflowStructureModel::TABLENAME . ' WHERE ' . self::FIELDNAME_DESCRIPTION_FTA_WORKFLOW . '<>\'\'' . ' AND ' . self::TABLENAME . '.' . self::FIELDNAME_ID_INTRANET_ACTIONS . '=' . IntranetDroitsAccesModel::TABLENAME . '.' . IntranetDroitsAccesModel::FIELDNAME_ID_INTRANET_ACTIONS . ' AND ' . FtaWorkflowStructureModel::TABLENAME . '.' . FtaWorkflowStructureModel::FIELDNAME_ID_FTA_ROLE . '=' . $paramIdRole . ' AND ' . self::TABLENAME . '.' . self::KEYNAME . '=' . FtaWorkflowStructureModel::TABLENAME . '.' . FtaWorkflowStructureModel::FIELDNAME_ID_FTA_WORKFLOW . ' AND ' . IntranetDroitsAccesModel::FIELDNAME_ID_USER . '=' . $paramIdUser . ' AND ' . IntranetDroitsAccesModel::TABLENAME . '.' . IntranetDroitsAccesModel::FIELDNAME_NIVEAU_INTRANET_DROITS_ACCES . '=' . IntranetNiveauAccesModel::NIVEAU_GENERIC_TRUE . ' ORDER BY ' . self::FIELDNAME_DESCRIPTION_FTA_WORKFLOW); $paramObjetList->setArrayListContent($arrayWorkflow); $paramObjetList->getAttributes()->getName()->setValue(self::KEYNAME); $paramObjetList->setLabel(DatabaseDescription::getFieldDocLabel(self::TABLENAME, self::FIELDNAME_DESCRIPTION_FTA_WORKFLOW)); $paramObjetList->setIsEditable($paramIsEditable); $paramObjetList->setSelectedValue($paramIdDefault); $listeSiteWorkflow = $paramObjetList->getHtmlResult(); return $listeSiteWorkflow; }