[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Dolibarr-dev] Adding data to llx_product

From: Florian HENRY
Subject: Re: [Dolibarr-dev] Adding data to llx_product
Date: Mon, 26 Oct 2015 20:00:45 +0100
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.3.0


    IMHO create a new table with fk_product column. Core dolibarr tables should be modified by modules, it is the base of core application. If core tables modification is needed, it should be submitted into core dev, for fixing bugs, or adding new core feature but not by externals modules.
    As well, in the module you should deal with triggers PRODUCT_DELETE to delete line into this table in the same times product are deleted from dolibarr (can also be done by foreign key ON DELETE contraint but may not work on all database engine) to avoid orphan lines.
    Another option is also to play with extrafields (llx_product_extrafields) feature by declaring them by code into module initialisation. It can depends how complex will be the functionnal rules on this fields.


Florian Henry
+33 6 03 76 48 07
Twitter : @_Open_Concept_
Google+ :
Le 26/10/2015 17:34, Sasa Ostrouska a écrit :
Hello, I have finally start to develop a specific module for the taxes we have in Brasil. So as a first step I need to add few fields to the products table as I want to have the possibility to show the various taxes and its amount when you will click on a tab showed in the product file.

So the question goes, what is better to do , adding an additional mysql table
like llx_brasil_ncm_product_tax and then linking those values with each product


extend the existing llx_product in dolibarr and add fiew fields ?


Dolibarr-dev mailing list

reply via email to

[Prev in Thread] Current Thread [Next in Thread]