Difference between revisions of "Module Products (developer)"
Jump to navigation
Jump to search
m (→Feature) |
m |
||
Line 16: | Line 16: | ||
= Permissions = | = Permissions = | ||
− | + | *->produit->lire | |
+ | *->produit->creer | ||
+ | *->produit->commander | ||
+ | *->produit->supprimer | ||
+ | *->produit->export | ||
= Tables SQL = | = Tables SQL = | ||
+ | * [[Table llx_product|llx_product]] Contains products and services | ||
+ | * [[Table llx product fournisseur|llx product fournisseur]] Contains links between products and suppliers | ||
+ | * [[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 llx product price|llx product price]] Contains prices for different levels of customers. | ||
+ | * [[Table_llx_product_stock|llx_product_stock]] Contains stocks of a product |
Revision as of 10:09, 5 August 2009
Products | |
---|---|
Numero/ID of module | {{{num}}} |
User doc. of module | Products |
Developer doc. of module | This page |
Feature
The Product module allows you to manage a catalog of predefined products.
Number : 50
Entity Product
The PHP class to use to manipulate such object is file htdocs/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 Contains links between products and suppliers
- 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