Complementary attributes: Difference between revisions

Jump to navigation Jump to search
m
mNo edit summary
Tag: 2017 source edit
Tag: 2017 source edit
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{TemplateDocUser}}
{{TemplateDocUser}}
=Introduction=
=Introduction=
Most of the Dolibarr modules have the possibilities to enhance the standard fields by new users fields. These fields are called "Complementary attributes" can be defined for objects or object lines.
Most of the Dolibarr modules have the possibilities to enhance the standard fields by new custom fields.  
These fields are called "Complementary attributes" can be defined for objects or object lines.


=How to use=
=How to use=
Line 15: Line 16:


==Label or translation key==
==Label or translation key==
* '''Mandatory field'''
 
* Label of the new field. This can be a translation key (new or existing), then you also need to set the 'language file' field.
*'''Mandatory field'''
*Label of the new field. This can be a translation key (new or existing), then you also need to set the 'language file' field.


==Attribute code==
==Attribute code==
* '''Mandatory field'''
 
* Code of the new field. Can only contain alphanumerical and lower case characters without space
*'''Mandatory field'''
*Code of the new field. Can only contain alphanumerical and lower case characters without space


==Type==
==Type==
* '''String (1 line)''' : Text on one line.
 
* '''Long text (n lines)''' : Text on several lines.
*'''String (1 line)''' : Text on one line.
* '''Html text''' : Text with HTML tags.
*'''Long text (n lines)''' : Text on several lines.
* '''Integer''' :  
*'''Html text''' : Text with HTML tags.
* '''Float''' :  
*'''Integer''' :
* '''Date''' :  
*'''Float''' :
* '''Date and hour''' :  
*'''Date''' :
* '''Boolean (one checkbox)''' :  
*'''Date and hour''' :
* '''Price''' :  
*'''Boolean (one checkbox)''' :
* '''Phone''' :  
*'''Price''' :
* '''Email''' :  
*'''Phone''' :
* '''Url''' :  
*'''Email''' :
* '''Password''' :  
*'''Url''' :
* '''Select list''' :  
*'''Password''' :
* '''Select from table''' :  
*'''Select list''' :
* '''Radio buttons (one choice only)''' :  
*'''Select from table''' :
* '''Checkboxes''' :  
*'''Radio buttons (one choice only)''' :
* '''Checkboxes from table''' :  
*'''Checkboxes''' :
* '''Link to an object''' :  
*'''Checkboxes from table''' :
* '''Separator (not a field)''' :
*'''Link to an object''' :
*'''Separator (not a field)''' :


==Size==
==Size==
Line 63: Line 67:


==Visibility==
==Visibility==
Define when a complementary attributes will be visible.


==Display on PDF==
==Display on PDF==
Do we have to show the value into the generated PDF ?


==Totalizable==
==Totalizable==
Define is this new attribute can be summed and if the application must show the value of the sum on the line "Total" at the bottom of lists.


==Help text to show on tooltip==
==Help text to show on tooltip==


= Tips=
=Tips=


==Select from table==
==Select from table==


===List of suppliers in a Category ===
===List of suppliers in a Category===
<code>categorie_fournisseur:fk_soc:fk_soc::fk_categorie=10</code>


== Computed Fields==
*On phpmyadmin use the following code <code>SELECT cs.fk_soc, cs.fk_categorie, soc.nom FROM llx_categorie_societe cs inner join llx_societe soc WHERE cs.fk_soc=soc.rowid</code> to create a new "view" that you can name <code>llx_mylistcategorie</code>
*Then on the complementary attribute, use <code>mylistcategorie:nom:fk_soc::fk_categorie=10</code>
 
==Computed Fields==
You can enter here a formula using other properties of object or any PHP coding to get a dynamic computed value. You can use any PHP compatible formulas including the "?" condition operator, and following global object: '''$db, $conf, $langs, $mysoc, $user, $object'''.
You can enter here a formula using other properties of object or any PHP coding to get a dynamic computed value. You can use any PHP compatible formulas including the "?" condition operator, and following global object: '''$db, $conf, $langs, $mysoc, $user, $object'''.


Line 99: Line 109:
<code>(($reloadedobj = new Task($db)) && ($reloadedobj->fetchNoCompute($object->id) > 0) && ($secondloadedobj = new Project($db)) && ($secondloadedobj->fetchNoCompute($reloadedobj->fk_project) > 0)) ? $secondloadedobj->ref: 'Parent project not found'</code>
<code>(($reloadedobj = new Task($db)) && ($reloadedobj->fetchNoCompute($object->id) > 0) && ($secondloadedobj = new Project($db)) && ($secondloadedobj->fetchNoCompute($reloadedobj->fk_project) > 0)) ? $secondloadedobj->ref: 'Parent project not found'</code>


== Visibility==
===Example to have the third party balance===
<code>(($c = new Categorie($db)) && ($cats = $c->containing($object->id, Categorie::TYPE_PRODUCT))&& (in_array('mycategory',$cats ))) ? 1 : 0</code>
<code>(($reloadedobj = new Societe($db)) && ($reloadedobj->fetchNoCompute($obj->rowid)) && ( $ret=$reloadedobj->getOutStandingBills())
) ? $ret['opened']: 666</code>
 
===Example to have the third party open invoices===
<code>(($reloadedobj = new Societe($db)) && ($reloadedobj->fetchNoCompute($obj->rowid)) && ( $ret=$reloadedobj->getOutStandingBills())
) ? sizeof($ret['refsopened']): 666</code>
 
==Visibility==
To display one attribute only if the object belongs to a certain category, you can use the following code  :
<code>(($c = new Categorie($db)) && ($cats = $c->containing($object->id, Categorie::TYPE_PRODUCT))&& (in_array('mycategory_id',$cats ))) ? 1 : 0</code>
 
To display one attribute only if the object is a product :
<code>((preg_match('/type=product',$_SERVER['QUERY_STRING']) || preg_match('/type=0',$_SERVER['QUERY_STRING']))? 1 : 0</code>

Navigation menu