Re: [Dolibarr-dev] Adding data to llx_product

[Florian HENRY]

Hello,

    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.

Regards

   

Florian Henry
+33 6 03 76 48 07
address@hidden
http://www.open-concept.pro
Twitter : @_Open_Concept_
Google+ : https://www.google.com/+Open-conceptPro

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

or

extend the existing llx_product in dolibarr and add fiew fields ?

Rgds

Saxa

_______________________________________________
Dolibarr-dev mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-dev