Fix(security): Sanitized queries in the list of services by host group

hyahiaoui-ext commented 1 year ago

Description

Sanitizing and binding + refactoring services by hostgroup list.

Fixes # MON-15367

Type of change

[ ] Patch fixing an issue (non-breaking change)
[ ] New functionality (non-breaking change)
[X] Breaking change (patch or feature) that might cause side effects breaking part of the Software

Target serie

[ ] 21.04.x
[x] 21.10.x
[x] 22.04.x
[X] 22.10.x (master)

Checklist

Community contributors & Centreon team

[x] I have followed the coding style guidelines provided by Centreon
[ ] I have commented my code, especially new classes, functions or any legacy code modified. (docblock)
[ ] I have commented my code, especially hard-to-understand areas of the PR.
[x] I have rebased my development branch on the base branch (master, maintenance).

hyahiaoui-ext commented 1 year ago

@callapa i've checked with @emabassi-ext and effectively i had to add the str_replace for another case that i didn't consider (it had to do with Host groups that already existed) i fixed it + a little refactoring the code.