* fix(conf/broker) bind sql values for inputs/outputs insert requests

* fix code for centreon-bot

* remove try catch

* apply kduret suggestion

Refs: MON-10926

Refs: MON-10926

* edited makeXMLForDowntime.php

* add sql update script

* Revert "add sql update script"

This reverts commit a37a0779687018d9f4ec9f777b4216af0eaf4752.

* git rm composer.lock

* restored composer.lock and rebased from develop

* fix(unattended): fix redirect of initial timezone to php ini file

* Update unattended.sh

Co-authored-by: Adrien Morais-Mestre <31647811+adr-mo@users.noreply.github.com>

Co-authored-by: sc979 <34628915+sc979@users.noreply.github.com>
Co-authored-by: Adrien Morais-Mestre <31647811+adr-mo@users.noreply.github.com>

* fix(menu): remove orphan menus from API listing
* fix(test): Fix Menu test
* enh(test): add orphan lvl3 menu
* fix(code): fix psr-12
* fix(code): correct phpstan

Co-authored-by: Kevin Duret <kduret@centreon.com>

Refs: MON-11382

Refs: MON-10926

* enh(resource-status): escape "_" character to use indexed search

* enh(resources): use EXISTS statement instead of INNER JOIN

* fix(customViews): list ldap groups when concerned by shared views

* enhance phpdoc block and typehinting

* kduret feedbacks: return type re-added

* Update www/class/centreonACL.class.php

Co-authored-by: Kevin Duret <kduret@centreon.com>

Co-authored-by: Kevin Duret <kduret@centreon.com>

* enh(monitoring): avoid double inner join to handle ACLs

* phpstan: patch errors given by max level

* Update src/Centreon/Domain/Monitoring/Interfaces/MonitoringRepositoryInterface.php

Co-authored-by: Kevin Duret <kduret@centreon.com>

* Update src/Centreon/Domain/Monitoring/Interfaces/MonitoringRepositoryInterface.php

Co-authored-by: Kevin Duret <kduret@centreon.com>

* Update src/Centreon/Domain/Monitoring/Interfaces/MonitoringRepositoryInterface.php

Co-authored-by: Kevin Duret <kduret@centreon.com>

* Update src/Centreon/Domain/Monitoring/Interfaces/MonitoringRepositoryInterface.php

Co-authored-by: Kevin Duret <kduret@centreon.com>

* Update src/Centreon/Domain/Monitoring/Interfaces/MonitoringRepositoryInterface.php

Co-authored-by: Kevin Duret <kduret@centreon.com>

* Update src/Centreon/Domain/Monitoring/Interfaces/MonitoringRepositoryInterface.php

Co-authored-by: Kevin Duret <kduret@centreon.com>

* Update src/Centreon/Domain/Monitoring/Interfaces/MonitoringRepositoryInterface.php

Co-authored-by: Kevin Duret <kduret@centreon.com>

* Update src/Centreon/Domain/Monitoring/Interfaces/MonitoringRepositoryInterface.php

Co-authored-by: Kevin Duret <kduret@centreon.com>

* Update src/Centreon/Domain/Monitoring/Interfaces/MonitoringRepositoryInterface.php

Co-authored-by: Kevin Duret <kduret@centreon.com>

* Update src/Centreon/Infrastructure/Monitoring/MonitoringRepositoryRDB.php

* phpstan: fix errors

* typehinting fix

* typehinting final fix

Co-authored-by: Kevin Duret <kduret@centreon.com>

* fix(sql) move sql update to new file for 21.04.7

* fix(sql) update version in sql install file

* ehn(conf) add tls_hostname to brocker input/output IPV4 (install)

* enh(conf) add help translation

* ehn(conf) add tls_hostname to brocker input/output IPV4 (update 21.04)

* fix(conf/broker) remove empty parameters afor lua output when saving brocker conf

* Apply suggestions from code review

Co-authored-by: Kevin Duret <kduret@centreon.com>

* fix(conf/broker) details on function docblock

* fix(conf/broker) fix typo

Co-authored-by: Kevin Duret <kduret@centreon.com>

* Add variables for substitutions on openid_connect_redirect_url

* Use a default redirect_url if empty

* remove tabs, again

* Split string into two lines to match centreon coding style

* use configured Centreon path as default

* reduce line lenght to match Centreon style guides

* Improve closing DB cursor

* Replace SQL query for oreon_web_path with ssoOptions

* split line to comply with style guide

* enh(openid): Allow to do not defined redirect URL

* Update www/class/centreonAuth.SSO.class.php

Co-authored-by: Laurent Calvet <lcalvet@centreon.com>

* Update www/class/centreonAuth.SSO.class.php

Co-authored-by: Laurent Calvet <lcalvet@centreon.com>

* Update www/include/Administration/parameters/general/help.php

Co-authored-by: Laurent Calvet <lcalvet@centreon.com>

Co-authored-by: Stefan Mayr <stefan@mayr-stefan.de>
Co-authored-by: Laurent Calvet <lcalvet@centreon.com>

* enh(openid): Allow to use URLs for OpenId endpoints

* fix(psr12): correct line exceeds 120 characters

* Implement client_secret_basic as token_endpoint_auth_method

* Fix style errors and some line length warnings

* Fix client_secret_post that broke with refactoring for the last merge

* Fix alternating row style that broke when merged with master

* Reapply logic from initial patch: remove client_id and client_secret from post data is basic auth is used

* Replaced tabs with spaces

* Fix Authentication headers for centreonRestHttp

* Replace some tabs, again

* add clientBasicAuth to function documentation and realign description column

Co-authored-by: Laurent Pinsivy <lpinsivy@centreon.com>

* fix(conf) fix side effect on config list pages

* fix(conf) fix side effect on monitoring and admin list pages

* fix(conf) fix fatal error when duplicating commands

* Update www/include/common/common-Func.php

Co-authored-by: Adrien Morais <31647811+adr-mo@users.noreply.github.com>

Refs: MON-10989

* fix(secu) add fcts relative to csrf token validation

* fix(secu) check csrf token validity when performing action in list pages
(contact, contactTemplate, contactGroup, timeperiod)

* fix(secu) check csrf token validity when performing action in list pages
(host, hostGroup, hostTemplate, hostCategories)

* fix(secu) check csrf token validity when performing action in list pages
(serviceByHost, serviceByHostGroup, serviceTemplate, serviceGroup, serviceCategories, metaservice)

* fix(secu) check csrf token validity when performing action in list pages
(command, connector)

* fix(secu) check csrf token validity when performing action in list pages
(escalation, hostDependency, hostGroupDependency, serviceDependency,
serviceGroupDependency, metaserviceDependency)

* fix(secu) check csrf token validity when performing action in list pages
(snmp traps, groups, manufacturer)

* fix(secu) check csrf token validity when performing action in list pages
(conf/pollers > centreonBroker, nagios, reources, servers)

* fix(secu) check csrf token validity when performing action in list pages
(monitoring/performances > componentTemplates, graphTemplates,
virtualMetrics)

* fix(secu) check csrf token validity when performing action in list pages
(monitoring/dowtimes > comments/commentHost, dowtime, recurrentDowtime)

* fix(secu) check csrf token validity when performing action in list pages
(admin/parameters > ldap, images)

* fix(secu) check csrf token validity when performing action in list pages
(admin/acl > actionAccess, groupAccess, menuAccess, resourcesAccess)

* fix(secu) add token to individual enable/disable action icon

* fix(secu) corrections following review comments

* fix(secu) corrections following review comments

* Update www/lib/HTML/QuickForm/HTML_QuickFormCustom.php

* fix(secu) modify token verification and deletion following code review

Co-authored-by: Kevin Duret <kduret@centreon.com>

* enh(feature-switch): fully manage feature switch

* centreon-bot: remove coding style issues

* use correct entry name in documentation

* enh(resource): add new function to build meta service uri