|
|
| (18 versions intermédiaires par le même utilisateur non affichées) |
| Ligne 12 : |
Ligne 12 : |
| |} | | |} |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| |
| <youtube>9NqynenRUv4</youtube> | | <youtube>9NqynenRUv4</youtube> |
| ==Page principale== | | ==Main page== |
| A partir du menu principal des outils patas-monkey, le menu gauche extralist présente la liste des listes personnalisables de l'outil
| | From the main menu of the patas-monkey tools, the left menu extralist presents the list of customizable lists of the tool |
| {| class="wikitable" | | {| class="wikitable" |
| |- style="vertical-align:top;" | | |- style="vertical-align:top;" |
| | [[File:extralist_index.png|600px]] | | | [[File:extralist_index_en.png|600px]] |
| | Chaque bloc représente une liste personnalisable contenant : | | | Each block represents a customizable list containing: |
| * La gestion des d'attributs supplémentaires disponible | | * The management of additional attributes available |
| * La gestion des champs supplémentaires déjà ajouté à la liste | | * The management of additional fields already added to the list |
| * La gestion des critères de surlignage de la liste | | * The management of the criteria for highlighting the list |
| Le nombre en bout de ligne indique si il y a déjà un paramétrage réalisé
| | The number at the end of the line indicates if there is already a setting made |
| |} | | |} |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| | == Custom Attribute Management== |
| == Gestion des attributs personnalisés==
| | After pressing the additional attribute selection icon, a screen displays the available fields |
| Après avoir appuyé sur l'icone de sélection des attributs supplémentaires, un écran présente les champs disponibles
| | {| class="wikitable" |
| {| class="wikitable" | | |- style="vertical-align:top;" |
| |- style="vertical-align:top;" | | | [[File:extralist_extrafieldsfields_en.png|600px]] |
| | [[File:extralist_extrafieldsfields.png|600px]] | | | Pressing the first orange icon allows you to select the attributes available for the list you want to display |
| | L'appuie sur le premier icone orange permet de sélectionner les attributs disponible pour la liste que l'on souhaite afficher | | Just click on the selector at the end of the line to activate or not the field in the list |
| Il suffit de cliquer sur le sélecteur en bout de ligne pour activer ou non le champs dans la liste
| |
| |} | | |} |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| | == Managing additional fields == |
| == Gestion des champs supplémentaires==
| | After pressing the additional attribute selection icon, a screen displays the fields already configured and allows you to add new ones. |
| Après avoir appuyé sur l'icone de sélection des attributs supplémentaires, un écran présente les champs déjà paramétrés et permet d'en ajouter de nouveau.
| | {| class="wikitable" |
| {| class="wikitable" | | |- style="vertical-align:top;" |
| |- style="vertical-align:top;" | | | [[File:extralist_extralistfields_en.png|600px]] |
| | [[File:extralist_extralistfields.png|600px]] | | | Pressing the second gray icon allows you to access the list of additional fields that have already been defined |
| | L'appuie sur le second icone gris permet d'accéder à la liste des champs supplémentaires que l'on a déjà défini | | From the list, it is possible to modify an existing field (icon at the beginning of the line) or to delete it (icon at the end of the line) |
| A partir de la liste, il est possible de modifier un champ déjà existant (icone en début de ligne) ou de le supprimer (icone en bout de ligne)
| |
| |} | | |} |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| | === Adding a new field === |
| === Ajout d'un nouveau champs === | | {| class="wikitable" |
| {| class="wikitable" | | |- style="vertical-align:top;" |
| |- style="vertical-align:top;" | | | [[File:extralist_extralistfieldsadd_en.png|600px]] |
| | [[File:extralist_extralistfieldsadd.png|600px]] | | | Pressing the (+) icon at the end of the title allows you to create a new custom field, it will then be possible to enter |
| | L'appuie sur l'icone (+) au bout du titre permet de créer un nouveau champ personnalisé, il sera possible de saisir alors | | * The label of the field you want to add |
| * Le libellé du champ que l'on souhaite ajouter | | * The name of the field in the database with its prefix (such as s. for company, p. for project, ...), it is possible to use an alias (if you use a calculated field parameter). |
| * Le nom du champ dans la base de donnée avec son préfix (comme par exemple s. pour société, p. pour projet, ...), il est possible d'employer un alias (si on utilise paramètre un champ calculé). | | * The type of fields in order to better manage the presentation format on the list |
| * Le type de champs afin de mieux en gérer le format de présentation sur la liste | |
| |} | | |} |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| | === Editing an existing field === |
| === Edition d'un champ existant === | | {| class="wikitable" |
| {| class="wikitable" | | |- style="vertical-align:top;" |
| |- style="vertical-align:top;" | | | [[File:extralist_extralistfieldsedit_en.png|600px]] |
| | [[File:extralist_extralistfieldsedit.png|600px]] | | | Pressing the style icon at the beginning of the line allows you to display the custom field settings. |
| | L'appuie sur l'icone en forme de style en début de ligne permet de afficher le paramétrage du champ personnalisé. | |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| |
| |} | | |} |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| | === Table join management === |
| === Gestion de la jointure de table ===
| | It is possible to add a SQL join to one or more tables if the field is not present in the tables used by the list. |
| Il est possible de rajouter une jointure SQL vers une ou plusieurs tables si le champ n'est pas présent dans les tables utilisés par la liste.
| |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| | Please note that this functionality requires knowledge of both SQL and the structuring of Dolibarr tables. |
| Attention cette fonctionnalité demande de connaitre à la fois le SQL et la structuration des tables de Dolibarr.
| |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| | We offer paid support on our site https://www.patas-monkey.com/boutique to assist you with this functionality |
| Nous proposons en support payant sur notre site https://www.patas-monkey.com/boutique de vous accompagner sur cette fonctionnalité
| |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| | === How the new fields work === |
| === Fonctionnement des nouveaux champs === | | Once the configuration is done, it is possible to access the new fields from the native field selector of the list. |
| Une fois le paramétrage réalisé, il est possible d'accéder aux nouveaux champs à partir du sélecteur de champs natif de la liste.
| | {| class="wikitable" |
| {| class="wikitable" | | |- style="vertical-align:top;" |
| |- style="vertical-align:top;" | | | [[File:extralist_selected_en.png|400px]] |
| | [[File:extralist_selected.png|400px]] | | | If there are fields added by ExtraList in the list, the field selection icon changes color |
| | Si il y a des champs ajoutés par ExtraList dans la liste, l'icone de sélection des champs change de couleur | | * Fields from additional attributes show the element from which they come |
| * Les champs issus d'attributs supplémentaires présente l'élément dont ils proviennent | | * Added fields are prefixed with "EL" |
| * Les champs ajoutés sont préfixé avec "EL" | |
| |} | | |} |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| | == Management of highlighted lines == |
| == Gestion des lignes surlignées == | | {| class="wikitable" |
| {| class="wikitable" | | |- style="vertical-align:top;" |
| |- style="vertical-align:top;" | | | [[File:extralist_extralistsellignelist_en.png|600px]] |
| | [[File:extralist_extralistsellignelist.png|600px]] | | | Pressing the (+) icon at the end of the title allows you to create a new highlight selection |
| | L'appuie sur l'icone (+) au bout du titre permet de créer une nouvelle sélection de surlignage | | * selection of fields that can be used for filtering |
| * sélection des champs qui peuvent être utilisé pour le filtrage | | * the color used for highlighting |
| * la couleur utilisée pour le surlignage | | * the type of filtering (equal, different, less than, ...) |
| * le type de filtrage (égale, différent, inférieur, ...) | | * the value associated with the filtering |
| * la valeur associé au filtrage | |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| | It is possible for the filter value to use predefined values like #NOW# for today's date or #USERID# for the current user |
| Il est possible pour la valeur de filtrage d'utiliser des valeurs prédéfinies comme #NOW# pour la date du jour ou #USERID# pour l'utilisateur en cours
| |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| | It is also possible to have several filters for the same list |
| Il est aussi possible d'avoir plusieurs filtrage pour une même liste
| |
| |} | | |} |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| | {| class="wikitable" |
| {| class="wikitable" | | |- style="vertical-align:top;" |
| |- style="vertical-align:top;" | | | Pressing the pen icon changes the highlighting |
| | L'appuie sur l'icone en forme de stylo permet de modifier le surlignage | | [[File:extralist_extralistselligneedit_en.png|600px]] |
| [[File:extralist_extralistselligneedit.png|600px]]
| | | [[File:extralist_extralistselligneresult_en.png|600px]] |
| | [[File:extralist_extralistselligneresult.png|600px]] | |
| |} | | |} |
| == Gestion de l'affichage des catégories == | | == Managing the display of categories == |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| | {| class="wikitable" |
| {| class="wikitable" | | |- style="vertical-align:top;" |
| |- style="vertical-align:top;" | | |It is possible to display the categories of the elements on the list by activating the check mark at the element setting level on the module index page. |
| |Il est possible d'afficher sur la liste les catégories des éléments en activant la coche au niveau du paramétrage de l'élément sur la page d'index du module. | |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr"> | | [[File:extralist_selectcategory_en.png|300px]] |
| [[File:extralist_selectcategory.png|300px]] | | | A column displaying the category(ies) (in a tooltip then) associated with the item is selectable. |
| | Une colonne affichant la ou les catégories (dans un tooltip alors) associé à l'élément est sélectionnable. | |
| </div>
| |
|
| |
|
| <div lang="fr" dir="ltr" class="mw-content-ltr">
| | [[File:extralist_displaycategorylist_en.png|800px]] |
| [[File:extralist_displaycategorylist.png|800px]] | |
| |} | | |} |
| </div>
| |
|
The ExtraList module allows you to add fields to the native lists of dolibarr, from custom attributes or other fields not initially provided for in the list:
- selection of additional attributes available for the list
- addition of additional fields available in the native tables of the list or added in a joined table for the field
- highlighting of lines according to a selection criterion
- Displaying the categories associated with an element
The fields thus added are then displayed in the field selector of the list and can be used like any other native field
|
Main page
From the main menu of the patas-monkey tools, the left menu extralist presents the list of customizable lists of the tool
|
Each block represents a customizable list containing:
- The management of additional attributes available
- The management of additional fields already added to the list
- The management of the criteria for highlighting the list
The number at the end of the line indicates if there is already a setting made
|
Custom Attribute Management
After pressing the additional attribute selection icon, a screen displays the available fields
|
Pressing the first orange icon allows you to select the attributes available for the list you want to display
Just click on the selector at the end of the line to activate or not the field in the list
|
Managing additional fields
After pressing the additional attribute selection icon, a screen displays the fields already configured and allows you to add new ones.
|
Pressing the second gray icon allows you to access the list of additional fields that have already been defined
From the list, it is possible to modify an existing field (icon at the beginning of the line) or to delete it (icon at the end of the line)
|
Adding a new field
|
Pressing the (+) icon at the end of the title allows you to create a new custom field, it will then be possible to enter
- The label of the field you want to add
- The name of the field in the database with its prefix (such as s. for company, p. for project, ...), it is possible to use an alias (if you use a calculated field parameter).
- The type of fields in order to better manage the presentation format on the list
|
Editing an existing field
|
Pressing the style icon at the beginning of the line allows you to display the custom field settings.
|
Table join management
It is possible to add a SQL join to one or more tables if the field is not present in the tables used by the list.
Please note that this functionality requires knowledge of both SQL and the structuring of Dolibarr tables.
We offer paid support on our site https://www.patas-monkey.com/boutique to assist you with this functionality
How the new fields work
Once the configuration is done, it is possible to access the new fields from the native field selector of the list.
|
If there are fields added by ExtraList in the list, the field selection icon changes color
- Fields from additional attributes show the element from which they come
- Added fields are prefixed with "EL"
|
Management of highlighted lines
|
Pressing the (+) icon at the end of the title allows you to create a new highlight selection
- selection of fields that can be used for filtering
- the color used for highlighting
- the type of filtering (equal, different, less than, ...)
- the value associated with the filtering
It is possible for the filter value to use predefined values like #NOW# for today's date or #USERID# for the current user
It is also possible to have several filters for the same list
|
| Pressing the pen icon changes the highlighting
|
|
Managing the display of categories
It is possible to display the categories of the elements on the list by activating the check mark at the element setting level on the module index page.
|
A column displaying the category(ies) (in a tooltip then) associated with the item is selectable.
|