Difference between revisions of "Module Products (developer)"
Jump to navigation
Jump to search
PolyglotBot (talk | contribs) m (Import interlang links (links to translated versions of this page in other languages) from Multi Language Manager table.) |
|||
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| + | <!-- BEGIN origin interlang links --> | ||
| + | <!-- You can edit this section but do NOT remove these comments | ||
| + | Links below will be automatically replicated on translated pages by PolyglotBot --> | ||
| + | [[fr:Module_Produits_(développeur)]] | ||
| + | [[es:Módulo_Productos_(desarrollador)]] | ||
| + | <!-- END interlang links --> | ||
| + | |||
[[Category:Product]] | [[Category:Product]] | ||
{{TemplateDocDevEn}} | {{TemplateDocDevEn}} | ||
| Line 24: | Line 31: | ||
= Tables SQL = | = Tables SQL = | ||
* [[Table llx_product|llx_product]] Contains products and services | * [[Table llx_product|llx_product]] Contains products and services | ||
| − | * [[Table | + | * [[Table llx_product_fournisseur_price|llx_product_fournisseur_price]] Contains prices proposed by suppliers for a product |
| − | + | * [[Table llx_product_fournisseur_price_log|llx_product_fournisseur_price_log]] Contains historic of change for supplierss prices | |
| − | * [[Table | + | * [[Table llx_product_price|llx_product_price]] Contains prices for different levels of customers. |
| − | * [[Table | + | * [[Table llx_product_stock|llx_product_stock]] Contains stocks of a product |
| − | * [[ | + | * [[Table llx_product_batch|llx_product_batch]] Contains details of stock per lot/batch number |
| + | * [[Table llx_product_lot|llx_product_lot]] Contains lots/batch and their properties. Lot/batch information in this table are never removed, even if stock become zero. | ||
Latest revision as of 13:21, 23 July 2019
| Products | |
|---|---|
| Numero/ID of module | 50 |
| User doc. of module | Module Products |
| Developer doc. of module | This page |
Feature
The Product module allows you to manage a catalog of predefined products.
Entity Product
The PHP class to use to manipulate such object is file htdocs/product/class/product.class.php.
It contains CRUD methods to create (C), read (R), update (U) and delete (D) this object.
Permissions
- ->produit->lire
- ->produit->creer
- ->produit->commander
- ->produit->supprimer
- ->produit->export
Tables SQL
- llx_product Contains products and services
- llx_product_fournisseur_price Contains prices proposed by suppliers for a product
- llx_product_fournisseur_price_log Contains historic of change for supplierss prices
- llx_product_price Contains prices for different levels of customers.
- llx_product_stock Contains stocks of a product
- llx_product_batch Contains details of stock per lot/batch number
- llx_product_lot Contains lots/batch and their properties. Lot/batch information in this table are never removed, even if stock become zero.