GitLab

* Support larger impact graphs

* Handle mediumtext alteration during utf8mb4 migration

* Put back previous case to fix tests
Co-authored-by: Cédric Anne <cedric.anne@gmail.com>

* Fix document date in timeline

* Set default to null
Co-authored-by: Cédric Anne <cedric.anne@gmail.com>

* Reduce code
Co-authored-by: Johan Cwiklinski <trasher@x-tnd.be>

* Merge install files

* Remove empty lines

* Remove trailing comma in function call

* Use migrationOneTable

* Usee addPostQuery

* Remove unused code

* Remove new options, use new key in $options instead
Co-authored-by: Cédric Anne <cedric.anne@gmail.com>
Co-authored-by: Johan Cwiklinski <trasher@x-tnd.be>

* Anonymized helpdesk: add nicknames

* Lint

* Move code to avoid useless queries

* Fix typo

* Use is_private to check if we need to anonymize in notification body

* Improve code readability

* Check central profiles instead of is_private

* feat(auth): add option to define timeout

* refactor(code): fix CS

* refactor(code): increase default value to 3

* refactor(code): fix html

* fix(code): fix SO datatype

* refactor(code): increase default value to 10

* fix(code): fix SO datatype

* refactor(code): fix CS

* refactor(code): refactor code

* fix(tu): fix TU

* refactor(code): move new option to 'Advanced info'

* fix(code): fix CS

* refactor(code): remove useless default value

* feat(core): add default tab option for central page

* fix(code): fix CS

* fix(code): fix tinyint width

* Add camera component, improve phone inventory
* Handle sensors names
Co-authored-by: Johan Cwiklinski <johan@x-tnd.be>

* feat: support cert and key for LDAPS

* Use full path for files

* Add new fields in database

* Fix field name

* Defaults use_bind to 1

* Fix tests
Co-authored-by: Johan Cwiklinski <johan@x-tnd.be>

* Do no delete default profiles if no rules were applied

* Add new field to install

* Remove duplicated code during conflict resolution

* Move code

* Fix rights issues in tests

 - Detect missing keys corresponding to foreign keys
 - Detect missing keys on is_* fields
 - Detect missing keys on date fields
 - Detect misnamed keys (optionnal)
 - Detect useless keys that are included in a larger key (optionnal)
 - Add missing keys
 - Drop useless keys

Remove no longer relevant Plugin::haveImport checks
Inventory remote management
Use trait to call inventory info on inventoriable assets
ComonDBChild method to display plugin inventory info hook

- Reorder table properties;
- No space between table properties and their value;
- No space after coma located between key fields;
- Move UNIQUE KEY after PRIMARY KEY;
- Surround numeric default values by quotes;
- Uppercase AUTO_INCREMENT;
- Remove DEFAULT NULL on text fields;
- Add KEY automatically added by CONTRAINT declaration.

 - db:check: add success output on clean DB
 - glpi-empty.sql: remove extra space
 - glpi-empty.sql: lowercase all types
 - glpi-empty.sql: add default values for 'timestamp not null' fields
 - glpi-empty.sql: add missing default values for tinyint
 - glpi-empty.sql: add named constraint on foreign key
 - glpi-empty.sql: remove explicit NULL on nullable columns
 - validate db:check on installation test suite

 - on install script
 - on upgrade from 9.5
 - in Migration class

Schema doc: https://github.com/glpi-project/inventory_format
Can be overrided from a plugin to inventory its own types.

Based on inventory features provided from fusioninventoryplugin, and
compatible with

New uUpgraded equipement rules to handle several itemtypes, add reset capacity
Handle Phones inventories
Add entites rules

Locks management for fields and its tests:
- Fields that have been updated from GLPI must not be modified from
inventory, and inventory does not lock anything.
- An icon is displayed in main item form only, even if all item types
can be locked. Displaying on all forms would require to change each
form individually (very huge work to copy a few lines of code).
- All item types can be locked

Overridable USB and PCI vendors list

Network inventory

Support for network equipments, stacked, wireless, VLANS,
LLDP/CDP and MAC connections, hubs

Add some missing fields in network tables

Use withHistory and fix usages
Check request mime type lowerca...

 - Use utf8mb4 as default charset for fresh installation
 - utf8mb4 migration command
 - warn for collation mix on migration
 - Force ROW_FORMAT = Dynamic on fresh install
 - Add warning on central page if some tables are not migrated

* Check for missing/outdated headers in lint jobs

* Fix headers

* Add licence headers in compiled SCSS files

* Fix exclusion pattern
Co-authored-by: François Legastelois <flegastelois@users.noreply.github.com>
Co-authored-by: François Legastelois <flegastelois@users.noreply.github.com>

* Add UUID to OS-capable devices

Update changelog

* Add missing default schema changes

* Add missing keys

* Fix monitor tests

* Move migration to its own file
Co-authored-by: Johan Cwiklinski <jcwiklinski@teclib.com>

* Reccurent Changes

* Unit tests

* Fix some errors triggering MySQL Warnings
* Permit usage of entity id when calling DbTestCase::setEntity()
* Handle booleans values in DB request

Fix "BLOB, TEXT, GEOMETRY or JSON column 'positions' can't have a default value"
Fix "Incorrect integer value: '_test_root_entity' for column `glpi_profiles_users`.`entities_id` at row 1"
Fix "Truncated incorrect DOUBLE value: ''" when tinyint is set to `false` instead of `0`
Fix "Incorrect integer value: '' for column `xxx`.`users_id` at row 1" due to logout state in tests
Fix "Incorrect integer value: '' for column `glpi_knowbaseitems_revisions`.`id` at row 1" during new KB revision creation
Fix invalid entity selection in `tests\units\Appliance_Item_Relation::testCountForApplianceItem()`
Fix "Incorrect integer value: 'N/A' for column `glpi`.`glpi_items_deviceprocessors`.`states_id` at row 1" in `tests\units\Computer::testUpdate()`
Fix "Incorrect integer value: '' for column `glpi`.`glpi_logs`.`items_id` at row 1" in `tests\units\Computer::testClone()`
Fix "Incorrect integer value: '' for column `glpi`.`glpi_groups_users`.`users_id` at row 1" in `tests\units\Group_User::testIsUserInGroup()`
Fix "Column 'softwareversions_id_use' cannot be null"
Fix "Data truncated for column 'entities_id' at row 1" in Log tests
Fix "Field 'from', 'to', 'date' and 'messageid' doesn't have a default value"

* Add unicity to ReservationItem

* Use INSERT IGNORE

* Add line break at then end, die and comment

Signed-off-by: Thierry Bugier <tbugier@teclib.com>

Add basic appliance and item_appliance classes (from cluster and item_cluster)
Add new objects from clustertypes
Fixes, use modern methods for count, fix update
Add missing tab (present in define.php), fix tests
Work on form and search options
Missed front files, add front form items
Add notepad, add is_helpdesk_visible field
Clonable
Test clone
Copy search options from old code (they should not change at all)
Fix, add some missing fronts
Add massive action to link/unlink items
Fix display on item side; add MA on item side
Fix helpdesk visible for appliances
Apply 1 suggestion(s) to 1 file(s)
Apply 1 suggestion(s) to 1 file(s)
MR fixes
Soem more MR fixes
Apply 1 suggestion(s) to 1 file(s)
Add is_visible_appliance in state table
Disable MA
Missing conf
Fix associated items tab, add itemtype on associated items list
Simplier header
Fix redirection
Fix texts
Missing SO
Another missing SO
Fix rights; drop no longer used form
Quick and dirty fix for tests
Fix duplicate SO
Fix missing forbidden MA
Fix MA
Apply same take_entity configuration as in certificates
Missing comment field
Add relations to appliances
UI for relations
Migrate and drop old relationtype field
Use configuration, plugins can add their types if needed
Not removed from install file
Fix getetxt singular/plural

* feat(collector): improve collect process

* feat(test): update test

* feat(collector): add option to collect only unread mail

Remove useless others field on domains

* add templates for domains

move table definition

* Remove changes made in other PR; see #7777 and #7784

* Do not propose to choose domain when adding from template

Templates are not listed in the dropdown (even if that worked
when nothing was choosed).
Co-authored-by: Cédric Anne <cedric.anne@gmail.com>
Co-authored-by: Johan Cwiklinski <jcwiklinski@teclib.com>

* fix warnings/errors when linking simcards to itilobjects

* Update inc/dropdown.class.php
Co-authored-by: Cédric Anne <cedric.anne@gmail.com>

* Update inc/dropdown.class.php
Co-authored-by: Cédric Anne <cedric.anne@gmail.com>

* remove superflu is_helpdesk_visible fields, fix also #7428

* add users_id to glpi_items_devicesimcards to permits correct linking of tickets

* fix order on simcard

* fix global items link in tickets

* clean

* missing key

* lint

* add also groups_id

* missing field in form

* duplicate so

* missing key

* Update install/update_94_95.php
Co-authored-by: Cédric Anne <cedric.anne@gmail.com>

* update - drop is_helpdesk_visible
Co-authored-by: Cédric Anne <cedric.anne@gmail.com>