|
From: | Sasa Ostrouska |
Subject: | Re: [Dolibarr-dev] Adding data to llx_product |
Date: | Mon, 26 Oct 2015 21:42:25 -0300 |
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-conceptProLe 26/10/2015 17:34, Sasa Ostrouska a écrit :
SaxaRgdsextend the existing llx_product in dolibarr and add fiew fields ?orlike llx_brasil_ncm_product_tax and then linking those values with each productHello, 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
_______________________________________________ Dolibarr-dev mailing list address@hidden https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
_______________________________________________
Dolibarr-dev mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
[Prev in Thread] | Current Thread | [Next in Thread] |