GlpiHistory » History » Version 5

Version 4 (moyo, 05/01/2008 11:47 PM) → Version 5/26 (moyo, 05/01/2008 11:48 PM)

=== Etat Actuel ===

Table glpi_history

- Common fields
- FK_glpi_device : item ID
- device_type : device type ID
- user_name : name of the user who made the update
- date_mod : update date
- Specific fields
- device_internal_type : device type for device history
- id_search_option : ID in search option array
- old_value : old value
- new_value : new value
- linked_action : action type

||'''linked action''' || '''Desc''' ||'''device_internal_type'''||'''id_search_option'''||'''old_value''' ||'''new_value''' ||
|| || item field update || || id_searcj_option || old_value || new value ||
||HISTORY_ADD_DEVICE || Intern dev add || device type || || || new value ||
||HISTORY_UPDATE_DEVICE ||Inter dev update specif|| device type || || old value || new value ||
||HISTORY_DELETE_DEVICE ||Intern dev delete || device type || || old value || ||
||HISTORY_INSTALL_SOFTWARE ||Install software || || || || soft/comp name/vers ||
||HISTORY_UNINSTALL_SOFTWARE || Uninstall soft || || || soft/comp name/vers || ||
||HISTORY_DISCONNECT_DEVICE ||Direct/Port disconnect || || ||item name/serial || ||
||HISTORY_CONNECT_DEVICE ||Direct/Port connect || || || ||item name/serial ||
||HISTORY_DELETE_ITEM ||Item deleted || || || || ||
||HISTORY_RESTORE_ITEM ||Item restored || || || || ||
||'''No core use in future '''|| || || || || ||
||HISTORY_LOG_SIMPLE_MESSAGE ||Simple message || || || || Message ||
||HISTORY_OCS_IMPORT ||OCS import || || || || OCS ID ||
||HISTORY_OCS_DELETE ||OCS deletion || || || old OCS ID || ||
||HISTORY_OCS_IDCHANGED || OCS ID change || || || old OCS ID || OCS ID ||
||HISTORY_OCS_LINK || OCS link || || || || OCS ID ||

=== Conclusion séminaire ===

- Historique avec des onglets
- Une seule table : action / on / old / new
- Ajout du champ FK_entities pour accélerer les traitements
-
Merge device_internal_type et id_search_option -> on
- Clean historique par type d'action : no history / toujours / 1 / 2 / 3 mois...
- Moteur de recherche global avec choix type matériel / matériel / on + tests sur old_value / new_value (old < new)
- Plugins : Que utilisation de log simple message