Difference between revisions of "Module Products (developer)"
Jump to navigation
Jump to search
(→Tables SQL: Add underscore in table name and add table llx_product_batch) |
|||
| Line 24: | Line 24: | ||
= 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 eat-by date / sell-by date / batch number for produtc |
Revision as of 18:18, 6 March 2014
| 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 eat-by date / sell-by date / batch number for produtc