dolibarr  20.0.0-beta
Public Member Functions | Static Public Member Functions | Public Attributes | Protected Attributes | Private Member Functions | List of all members
Product Class Reference

Class to manage products or services. More...

Inheritance diagram for Product:
Inheritance graph
[legend]
Collaboration diagram for Product:
Collaboration graph
[legend]

Public Member Functions

 __construct ($db)
 Constructor. More...
 
 check ()
 Check that ref and label are ok. More...
 
 create ($user, $notrigger=0)
 Insert product into database. More...
 
 verify ()
 Check properties of product are ok (like name, barcode, ...). More...
 
 check_barcode ($valuetotest, $typefortest)
 Check barcode. More...
 
 update ($id, $user, $notrigger=0, $action='update', $updatetype=false)
 Update a record into database. More...
 
 delete (User $user, $notrigger=0)
 Delete a product from database (if not used) More...
 
 getSellOrEatByMandatoryLabel ()
 Get sell or eat by mandatory label. More...
 
 setMultiLangs ($user)
 Update or add a translation for a product. More...
 
 delMultiLangs ($langtodelete, $user)
 Delete a language for this product. More...
 
 setAccountancyCode ($type, $value)
 Sets an accountancy code for a product. More...
 
 getMultiLangs ()
 Load array this->multilangs. More...
 
 log_price_delete ($user, $rowid)
 Delete a price line. More...
 
 getSellPrice ($thirdparty_seller, $thirdparty_buyer, $pqp=0)
 Return price of sell of a product for a seller/buyer/product. More...
 
 get_buyprice ($prodfournprice, $qty, $product_id=0, $fourn_ref='', $fk_soc=0)
 Read price used by a provider. More...
 
 updatePrice ($newprice, $newpricebase, $user, $newvat=null, $newminprice=0, $level=0, $newnpr=0, $newpbq=0, $ignore_autogen=0, $localtaxes_array=array(), $newdefaultvatcode='', $price_label='', $notrigger=0)
 Modify customer price of a product/Service for a given level. More...
 
 setPriceExpression ($expression_id)
 Sets the supplier price expression. More...
 
 fetch ($id=0, $ref='', $ref_ext='', $barcode='', $ignore_expression=0, $ignore_price_load=0, $ignore_lang_load=0)
 Load a product in memory from database. More...
 
 load_stats_mo ($socid=0)
 Charge tableau des stats OF pour le produit/service. More...
 
 load_stats_bom ($socid=0)
 Charge tableau des stats OF pour le produit/service. More...
 
 load_stats_propale ($socid=0)
 Charge tableau des stats propale pour le produit/service. More...
 
 load_stats_proposal_supplier ($socid=0)
 Charge tableau des stats propale pour le produit/service. More...
 
 load_stats_commande ($socid=0, $filtrestatut='', $forVirtualStock=0)
 Charge tableau des stats commande client pour le produit/service. More...
 
 load_stats_commande_fournisseur ($socid=0, $filtrestatut='', $forVirtualStock=0, $dateofvirtualstock=null)
 Charge tableau des stats commande fournisseur pour le produit/service. More...
 
 load_stats_sending ($socid=0, $filtrestatut='', $forVirtualStock=0, $filterShipmentStatus='')
 Charge tableau des stats expedition client pour le produit/service. More...
 
 load_stats_reception ($socid=0, $filtrestatut='', $forVirtualStock=0, $dateofvirtualstock=null)
 Charge tableau des stats réception fournisseur pour le produit/service. More...
 
 load_stats_inproduction ($socid=0, $filtrestatut='', $forVirtualStock=0, $dateofvirtualstock=null, $warehouseid=0)
 Charge tableau des stats production pour le produit/service. More...
 
 load_stats_contrat ($socid=0)
 Charge tableau des stats contrat pour le produit/service. More...
 
 load_stats_facture ($socid=0)
 Charge tableau des stats facture pour le produit/service. More...
 
 load_stats_facturerec ($socid=0)
 Charge tableau des stats facture recurrentes pour le produit/service. More...
 
 load_stats_facture_fournisseur ($socid=0)
 Charge tableau des stats facture pour le produit/service. More...
 
 get_nb_vente ($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
 Return nb of units or customers invoices in which product is included. More...
 
 get_nb_achat ($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
 Return nb of units or supplier invoices in which product is included. More...
 
 get_nb_propal ($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
 Return nb of units in proposals in which product is included. More...
 
 get_nb_propalsupplier ($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
 Return nb of units in proposals in which product is included. More...
 
 get_nb_order ($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
 Return nb of units in orders in which product is included. More...
 
 get_nb_ordersupplier ($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
 Return nb of units in orders in which product is included. More...
 
 get_nb_contract ($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
 Return nb of units in orders in which product is included. More...
 
 get_nb_mos ($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
 Return nb of units in orders in which product is included. More...
 
 add_sousproduit ($id_pere, $id_fils, $qty, $incdec=1, $notrigger=0)
 Link a product/service to a parent product/service. More...
 
 update_sousproduit ($id_pere, $id_fils, $qty, $incdec=1, $notrigger=0)
 Modify composed product. More...
 
 del_sousproduit ($fk_parent, $fk_child, $notrigger=0)
 Remove a link between a subproduct and a parent product/service. More...
 
 is_sousproduit ($fk_parent, $fk_child)
 Check if it is a sub-product into a kit. More...
 
 add_fournisseur ($user, $id_fourn, $ref_fourn, $quantity)
 Add a supplier price for the product. More...
 
 list_suppliers ()
 Return list of suppliers providing the product or service. More...
 
 clone_price ($fromId, $toId)
 Recopie les prix d'un produit/service sur un autre. More...
 
 clone_associations ($fromId, $toId)
 Clone links between products. More...
 
 clone_fournisseurs ($fromId, $toId)
 Recopie les fournisseurs et prix fournisseurs d'un produit/service sur un autre. More...
 
 fetch_prod_arbo ($prod, $compl_path='', $multiply=1, $level=1, $id_parent=0, $ignore_stock_load=0)
 Function recursive, used only by get_arbo_each_prod(), to build tree of subproducts into ->res Define value of this->res. More...
 
 get_arbo_each_prod ($multiply=1, $ignore_stock_load=0)
 Build the tree of subproducts and return it. More...
 
 hasFatherOrChild ($mode=0)
 Count all parent and children products for current product (first level only) More...
 
 hasVariants ()
 Return if a product has variants or not. More...
 
 isVariant ()
 Return if loaded product is a variant. More...
 
 getFather ()
 Return all parent products for current product (first level only) More...
 
 getChildsArbo ($id, $firstlevelonly=0, $level=1, $parents=array())
 Return children of product $id. More...
 
 get_sousproduits_arbo ()
 
 getTooltipContentArray ($params)
 getTooltipContentArray More...
 
 getNomUrl ($withpicto=0, $option='', $maxlength=0, $save_lastsearch_value=-1, $notooltip=0, $morecss='', $add_label=0, $sep=' - ')
 Return clickable link of object (with eventually picto) More...
 
 generateDocument ($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0)
 Create a document onto disk according to template module. More...
 
 getLibStatut ($mode=0, $type=0)
 Return label of status of object. More...
 
 LibStatut ($status, $mode=0, $type=0)
 Return label of a given status. More...
 
 getLibFinished ()
 Retour label of nature of product. More...
 
 correct_stock ($user, $id_entrepot, $nbpiece, $movement, $label='', $price=0, $inventorycode='', $origin_element='', $origin_id=null, $disablestockchangeforsubproduct=0, $extrafields=null)
 Adjust stock in a warehouse for product. More...
 
 correct_stock_batch ($user, $id_entrepot, $nbpiece, $movement, $label='', $price=0, $dlc='', $dluo='', $lot='', $inventorycode='', $origin_element='', $origin_id=null, $disablestockchangeforsubproduct=0, $extrafields=null, $force_update_batch=false)
 Adjust stock in a warehouse for product with batch number. More...
 
 load_stock ($option='', $includedraftpoforvirtual=null, $dateofvirtualstock=null)
 Load information about stock of a product into ->stock_reel, ->stock_warehouse[] (including stock_warehouse[idwarehouse]->detail_batch for batch products) This function need a lot of load. More...
 
 load_virtual_stock ($includedraftpoforvirtual=null, $dateofvirtualstock=null)
 Load value ->stock_theorique of a product. More...
 
 loadBatchInfo ($batch)
 Load existing information about a serial. More...
 
 add_photo ($sdir, $file)
 Move an uploaded file described into $file array into target directory $sdir. More...
 
 is_photo_available ($sdir)
 Return if at least one photo is available. More...
 
 liste_photos ($dir, $nbmax=0)
 Return an array with all photos of product found on disk. More...
 
 delete_photo ($file)
 Delete a photo and its thumbs. More...
 
 get_image_size ($file)
 Load size of image file. More...
 
 loadStateBoard ()
 Load indicators this->nb for the dashboard. More...
 
 isProduct ()
 Return if object is a product. More...
 
 isService ()
 Return if object is a product. More...
 
 isStockManaged ()
 Return if object need to have its stock managed. More...
 
 isMandatoryPeriod ()
 Return if object have a constraint on mandatory_period. More...
 
 hasbatch ()
 Return if object has a sell-by date or eat-by date. More...
 
 get_barcode ($object, $type='')
 Get a barcode from the module to generate barcode values. More...
 
 initAsSpecimen ()
 Initialise an instance with random values. More...
 
 getLabelOfUnit ($type='long')
 Returns the text label from units dictionary. More...
 
 min_recommended_price ()
 Return minimum product recommended price. More...
 
 setCategories ($categories)
 Sets object to supplied categories. More...
 
 generateMultiprices (User $user, $baseprice, $price_type, $price_vat, $npr, $psq)
 Generates prices for a product based on product multiprice generation rules. More...
 
 getRights ()
 Returns the rights used for this class. More...
 
 info ($id)
 Load information for tab info. More...
 
 getProductDurationHours ()
 Return the duration of a service in hours (for a service based on duration fields) More...
 
 getKanbanView ($option='', $arraydata=null)
 Return clicable link of object (with eventually picto) More...
 
- Public Member Functions inherited from CommonObject
 setErrorsFromObject ($object)
 setErrorsFromObject More...
 
 getTooltipContent ($params)
 getTooltipContent More...
 
 errorsToString ()
 Method to output saved errors. More...
 
 getFormatedCustomerRef ($objref)
 Return customer ref for screen output. More...
 
 getFormatedSupplierRef ($objref)
 Return supplier ref for screen output. More...
 
 getFullAddress ($withcountry=0, $sep="\n", $withregion=0, $extralangcode='')
 Return full address of contact. More...
 
 getLastMainDocLink ($modulepart, $initsharekey=0, $relativelink=0)
 Return the link of last main doc file for direct public download. More...
 
 add_contact ($fk_socpeople, $type_contact, $source='external', $notrigger=0)
 Add a link between element $this->element and a contact. More...
 
 copy_linked_contact ($objFrom, $source='internal')
 Copy contact from one element to current. More...
 
 update_contact ($rowid, $statut, $type_contact_id=0, $fk_socpeople=0)
 Update a link to contact line. More...
 
 delete_contact ($rowid, $notrigger=0)
 Delete a link to contact line. More...
 
 delete_linked_contact ($source='', $code='')
 Delete all links between an object $this and all its contacts in llx_element_contact. More...
 
 liste_contact ($statusoflink=-1, $source='external', $list=0, $code='', $status=-1, $arrayoftcids=array())
 Get array of all contacts for an object. More...
 
 swapContactStatus ($rowid)
 Update status of a contact linked to object. More...
 
 liste_type_contact ($source='internal', $order='position', $option=0, $activeonly=0, $code='')
 Return array with list of possible values for type of contacts. More...
 
 listeTypeContacts ($source='internal', $option=0, $activeonly=0, $code='', $element='', $excludeelement='')
 Return array with list of possible values for type of contacts. More...
 
 getIdContact ($source, $code, $status=0)
 Return id of contacts for a source and a contact code. More...
 
 fetch_contact ($contactid=null)
 Load object contact with id=$this->contact_id into $this->contact. More...
 
 fetch_thirdparty ($force_thirdparty_id=0)
 Load the third party of object, from id $this->socid or $this->fk_soc, into this->thirdparty. More...
 
 fetchOneLike ($ref)
 Looks for an object with ref matching the wildcard provided It does only work when $this->table_ref_field is set. More...
 
 fetch_barcode ()
 Load data for barcode into properties ->barcode_type* Properties ->barcode_type that is id of barcode. More...
 
 fetch_project ()
 Load the project with id $this->fk_project into this->project. More...
 
 fetch_projet ()
 Load the project with id $this->fk_project into this->project. More...
 
 fetch_product ()
 Load the product with id $this->fk_product into this->product. More...
 
 fetch_user ($userid)
 Load the user with id $userid into this->user. More...
 
 fetch_origin ()
 Read linked origin object. More...
 
 fetchObjectFrom ($table, $field, $key, $element=null)
 Load object from specific field. More...
 
 getValueFrom ($table, $id, $field)
 Getter generic. More...
 
 setValueFrom ($field, $value, $table='', $id=null, $format='', $id_field='', $fuser=null, $trigkey='', $fk_user_field='fk_user_modif')
 Setter generic. More...
 
 load_previous_next_ref ($filter, $fieldid, $nodbprefix=0)
 Load properties id_previous and id_next by comparing $fieldid with $this->ref. More...
 
 getListContactId ($source='external')
 Return list of id of contacts of object. More...
 
 setProject ($projectid, $notrigger=0)
 Link element with a project. More...
 
 setPaymentMethods ($id)
 Change the payments methods. More...
 
 setMulticurrencyCode ($code)
 Change the multicurrency code. More...
 
 setPaymentTerms ($id, $deposit_percent=null)
 Change the payments terms. More...
 
 setTransportMode ($id)
 Change the transport mode methods. More...
 
 setRetainedWarrantyPaymentTerms ($id)
 Change the retained warranty payments terms. More...
 
 setDeliveryAddress ($id)
 Define delivery address. More...
 
 setShippingMethod ($shipping_method_id, $notrigger=0, $userused=null)
 Change the shipping method. More...
 
 setWarehouse ($warehouse_id)
 Change the warehouse. More...
 
 setDocModel ($user, $modelpdf)
 Set last model used by doc generator. More...
 
 setBankAccount ($fk_account, $notrigger=0, $userused=null)
 Change the bank account. More...
 
 line_order ($renum=false, $rowidorder='ASC', $fk_parent_line=true)
 Save a new position (field rang) for details lines. More...
 
 getChildrenOfLine ($id, $includealltree=0)
 Get children of line. More...
 
 line_up ($rowid, $fk_parent_line=true)
 Update a line to have a lower rank. More...
 
 line_down ($rowid, $fk_parent_line=true)
 Update a line to have a higher rank. More...
 
 updateRangOfLine ($rowid, $rang)
 Update position of line (rang) More...
 
 line_ajaxorder ($rows)
 Update position of line with ajax (rang) More...
 
 updateLineUp ($rowid, $rang)
 Update position of line up (rang) More...
 
 updateLineDown ($rowid, $rang, $max)
 Update position of line down (rang) More...
 
 getRangOfLine ($rowid)
 Get position of line (rang) More...
 
 getIdOfLine ($rang)
 Get rowid of the line relative to its position. More...
 
 line_max ($fk_parent_line=0)
 Get max value used for position of line (rang) More...
 
 update_ref_ext ($ref_ext)
 Update external ref of element. More...
 
 update_note ($note, $suffix='', $notrigger=0)
 Update note of element. More...
 
 update_note_public ($note)
 Update public note (kept for backward compatibility) More...
 
 update_price ($exclspec=0, $roundingadjust='auto', $nodatabaseupdate=0, $seller=null)
 Update total_ht, total_ttc, total_vat, total_localtax1, total_localtax2 for an object (sum of lines). More...
 
 add_object_linked ($origin=null, $origin_id=null, $f_user=null, $notrigger=0)
 Add an object link into llx_element_element. More...
 
 getElementType ()
 Return an element type string formatted like element_element target_type and source_type. More...
 
 fetchObjectLinked ($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $clause='OR', $alsosametype=1, $orderby='sourcetype', $loadalsoobjects=1)
 Fetch array of objects linked to current object (object of enabled modules only). More...
 
 clearObjectLinkedCache ()
 Clear the cache saying that all linked object were already loaded. More...
 
 updateObjectLinked ($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $f_user=null, $notrigger=0)
 Update object linked of a current object. More...
 
 deleteObjectLinked ($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $rowid=0, $f_user=null, $notrigger=0)
 Delete all links between an object $this. More...
 
 setStatut ($status, $elementId=null, $elementType='', $trigkey='', $fieldstatus='fk_statut')
 Set status of an object. More...
 
 getCanvas ($id=0, $ref='')
 Load type of canvas of an object if it exists. More...
 
 getSpecialCode ($lineid)
 Get special code of a line. More...
 
 isObjectUsed ($id=0, $entity=0)
 Function to check if an object is used by others (by children). More...
 
 hasProductsOrServices ($predefined=-1)
 Function to say how many lines object contains. More...
 
 getTotalDiscount ()
 Function that returns the total amount HT of discounts applied for all lines. More...
 
 getTotalWeightVolume ()
 Return into unit=0, the calculated total of weight and volume of all lines * qty Calculate by adding weight and volume of each product line, so properties ->volume/volume_units/weight/weight_units must be loaded on line. More...
 
 setExtraParameters ()
 Set extra parameters. More...
 
 formAddObjectLine ($dateSelector, $seller, $buyer, $defaulttpldir='/core/tpl')
 Show add free and predefined products/services form. More...
 
 printObjectLines ($action, $seller, $buyer, $selected=0, $dateSelector=0, $defaulttpldir='/core/tpl')
 Return HTML table for object lines TODO Move this into an output class file (htmlline.class.php) If lines are into a template, title must also be into a template But for the moment we don't know if it's possible as we keep a method available on overloaded objects. More...
 
 printObjectLine ($action, $line, $var, $num, $i, $dateSelector, $seller, $buyer, $selected=0, $extrafields=null, $defaulttpldir='/core/tpl')
 Return HTML content of a detail line TODO Move this into an output class file (htmlline.class.php) More...
 
 printOriginLinesList ($restrictlist='', $selectedLines=array())
 Return HTML table table of source object lines TODO Move this and previous function into output html class file (htmlline.class.php). More...
 
 printOriginLine ($line, $var, $restrictlist='', $defaulttpldir='/core/tpl', $selectedLines=array())
 Return HTML with a line of table array of source object lines TODO Move this and previous function into output html class file (htmlline.class.php). More...
 
 add_element_resource ($resource_id, $resource_type, $busy=0, $mandatory=0)
 Add resources to the current object : add entry into llx_element_resources Need $this->element & $this->id. More...
 
 delete_resource ($rowid, $element, $notrigger=0)
 Delete a link to resource line. More...
 
 __clone ()
 Overwrite magic function to solve problem of cloning object that are kept as references. More...
 
 indexFile ($destfull, $update_main_doc_field)
 Index a file into the ECM database. More...
 
 addThumbs ($file)
 Build thumb. More...
 
 delThumbs ($file)
 Delete thumbs. More...
 
 getDefaultCreateValueFor ($fieldname, $alternatevalue=null, $type='alphanohtml')
 Return the default value to use for a field when showing the create form of object. More...
 
 call_trigger ($triggerName, $user)
 Call trigger based on this instance. More...
 
 fetchValuesForExtraLanguages ()
 Function to get alternative languages of a data into $this->array_languages This method is NOT called by method fetch of objects but must be called separately. More...
 
 setValuesForExtraLanguages ($onlykey='')
 Fill array_options property of object by extrafields value (using for data sent by forms) More...
 
 fetchNoCompute ($id)
 Function to make a fetch but set environment to avoid to load computed values before. More...
 
 fetch_optionals ($rowid=null, $optionsArray=null)
 Function to get extra fields of an object into $this->array_options This method is in most cases called by method fetch of objects but you can call it separately. More...
 
 deleteExtraFields ()
 Delete all extra fields values for the current object. More...
 
 insertExtraFields ($trigger='', $userused=null)
 Add/Update all extra fields values for the current object. More...
 
 insertExtraLanguages ($trigger='', $userused=null)
 Add/Update all extra fields values for the current object. More...
 
 updateExtraField ($key, $trigger=null, $userused=null)
 Update 1 extra field value for the current object. More...
 
 updateExtraLanguages ($key, $trigger=null, $userused=null)
 Update an extra language value for the current object. More...
 
 showInputField ($val, $key, $value, $moreparam='', $keysuffix='', $keyprefix='', $morecss=0, $nonewbutton=0)
 Return HTML string to put an input field into a page Code very similar with showInputField of extra fields. More...
 
 clearFieldError ($fieldKey)
 clear validation message result for a field More...
 
 setFieldError ($fieldKey, $msg='')
 set validation error message a field More...
 
 getFieldError ($fieldKey)
 get field error message More...
 
 validateField ($fields, $fieldKey, $fieldValue)
 Return validation test result for a field. More...
 
 showOptionals ($extrafields, $mode='view', $params=null, $keysuffix='', $keyprefix='', $onetrtd='', $display_type='card')
 Function to show lines of extrafields with output data. More...
 
 getJSListDependancies ($type='_extra')
 
 defineBuyPrice ($unitPrice=0.0, $discountPercent=0.0, $fk_product=0)
 Get buy price to use for margin calculation. More...
 
 getDataToShowPhoto ($modulepart, $imagesize)
 getDataToShowPhoto More...
 
 show_photos ($modulepart, $sdir, $size=0, $nbmax=0, $nbbyrow=5, $showfilename=0, $showaction=0, $maxHeight=120, $maxWidth=160, $nolink=0, $overwritetitle=0, $usesharelink=0, $cache='', $addphotorefcss='photoref')
 Show photos of an object (nbmax maximum), into several columns. More...
 
 isDate ($info)
 Function test if type is date. More...
 
 isDuration ($info)
 Function test if type is duration. More...
 
 isInt ($info)
 Function test if type is integer. More...
 
 isFloat ($info)
 Function test if type is float. More...
 
 isText ($info)
 Function test if type is text. More...
 
 setVarsFromFetchObj (&$obj)
 Function to load data from a SQL pointer into properties of current object $this. More...
 
 emtpyObjectVars ()
 Sets all object fields to null. More...
 
 getFieldList ($alias='', $excludefields=array())
 Function to concat keys of fields. More...
 
 createCommon (User $user, $notrigger=0)
 Create object in the database. More...
 
 fetchCommon ($id, $ref=null, $morewhere='', $noextrafields=0)
 Load object in memory from the database. More...
 
 fetchLinesCommon ($morewhere='', $noextrafields=0)
 Load object in memory from the database. More...
 
 updateCommon (User $user, $notrigger=0)
 Update object into database. More...
 
 deleteCommon (User $user, $notrigger=0, $forcechilddeletion=0)
 Delete object in database. More...
 
 deleteByParentField ($parentId=0, $parentField='', $filter='', $filtermode="AND")
 Delete all child object from a parent ID. More...
 
 deleteLineCommon (User $user, $idline, $notrigger=0)
 Delete a line of object in database. More...
 
 setStatusCommon ($user, $status, $notrigger=0, $triggercode='')
 Set to a status. More...
 
 setSignedStatusCommon ($user, $status, $notrigger=0, $triggercode='')
 Set to a signed status. More...
 
 initAsSpecimenCommon ()
 Initialise object with example values Id must be 0 if object instance is a specimen. More...
 
 fetchComments ()
 Load comments linked with current task. More...
 
 getNbComments ()
 Return nb comments already posted. More...
 
 trimParameters ($parameters)
 Trim object parameters. More...
 
 getCategoriesCommon ($type_categ)
 Sets object to given categories. More...
 
 setCategoriesCommon ($categories, $type_categ='', $remove_existing=true)
 Sets object to given categories. More...
 
 cloneCategories ($fromId, $toId, $type='')
 Copy related categories to another object. More...
 
 deleteEcmFiles ($mode=0)
 Delete related files of object in database. More...
 

Static Public Member Functions

static getSellOrEatByMandatoryList ()
 Get sell or eat by mandatory list. More...
 
static replaceThirdparty (DoliDB $dbs, $origin_id, $dest_id)
 Function used to replace a thirdparty id with another one. More...
 
- Static Public Member Functions inherited from CommonObject
static isExistingObject ($element, $id, $ref='', $ref_ext='')
 Check if an object id or ref exists If you don't need or want to instantiate the object and just need to know if the object exists, use this method instead of fetch. More...
 
static getAllItemsLinkedByObjectID ($fk_object_where, $field_select, $field_where, $table_element)
 Function used to get an array with all items linked to an object id in association table. More...
 
static getCountOfItemsLinkedByObjectID ($fk_object_where, $field_where, $table_element)
 Count items linked to an object id in association table. More...
 
static deleteAllItemsLinkedByObjectID ($fk_object_where, $field_where, $table_element)
 Function used to remove all items linked to an object id in association table. More...
 
static commonReplaceThirdparty (DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
 Function used to replace a thirdparty id with another one. More...
 
static commonReplaceProduct (DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
 Function used to replace a product id with another one. More...
 

Public Attributes

const SELL_OR_EAT_BY_MANDATORY_ID_NONE = 0
 Const sell or eat by mandatory id.
 
 $libelle
 
 $multiprices = array()
 Arrays for multiprices.
 
 $price_by_qty
 Price by quantity arrays.
 
 $multilangs = array()
 Array for multilangs.
 
 $default_vat_code
 Default VAT code for product (link to code into llx_c_tva but without foreign keys)
 
 $tva_tx
 Default VAT rate of product.
 
 $tva_npr = 0
 int French VAT NPR is used (0 or 1)
 
 $remise_percent
 Default discount percent.
 
 $localtax1_tx
 Other local taxes.
 
 $pmp
 Average price value for product entry into stock (PMP)
 
 $desiredstock = 0
 Ask for replenishment when $desiredstock < $stock_reel.
 
 $duration_value
 Service expiration.
 
 $duration_unit
 Service expiration unit.
 
 $duration
 Service expiration label (value + unit)
 
 $weight
 Metric of products.
 
 $imgWidth
 Size of image.
 
 $product_fourn_id
 Id du fournisseur.
 
 $product_id_already_linked
 Product ID already linked to a reference supplier.
 
 $stock_warehouse = array()
 Contains detail of stock of product into each warehouse.
 
 $ref_fourn
 
const TYPE_PRODUCT = 0
 Regular product.
 
const TYPE_SERVICE = 1
 Service.
 
- Public Attributes inherited from CommonObject
 $origin_object
 

Protected Attributes

 $table_ref_field = 'ref'
 {}
 

Private Member Functions

 getArrayForPriceCompare ($level=0)
 used to check if price have really change to avoid log pollution More...
 
 _log_price ($user, $level=0)
 Insert a track that we changed a customer price. More...
 
 _get_stats ($sql, $mode, $year=0)
 Return an array formatted for showing graphs. More...
 

Additional Inherited Members

- Protected Member Functions inherited from CommonObject
 deprecatedProperties ()
 Provide list of deprecated properties and replacements. More...
 
 commonGenerateDocument ($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
 Common function for all objects extending CommonObject for generating documents. More...
 
 isArray ($info)
 Function test if type is array. More...
 
 canBeNull ($info)
 Function test if field can be null. More...
 
 isForcedToNullIfZero ($info)
 Function test if field is forced to null if zero or empty. More...
 
 isIndex ($info)
 Function test if is indexed. More...
 
 setSaveQuery ()
 Function to return the array of data key-value from the ->fields and all the ->properties of an object. More...
 
 quote ($value, $fieldsentry)
 Add quote to field value if necessary. More...
 

Detailed Description

Class to manage products or services.

Definition at line 49 of file product.class.php.

Constructor & Destructor Documentation

◆ __construct()

Product::__construct (   $db)

Constructor.

Parameters
DoliDB$dbDatabase handler

Reimplemented in ProductFournisseur.

Definition at line 617 of file product.class.php.

Member Function Documentation

◆ _get_stats()

Product::_get_stats (   $sql,
  $mode,
  $year = 0 
)
private

Return an array formatted for showing graphs.

Parameters
string$sqlRequest to execute
string$mode'byunit'=number of unit, 'bynumber'=nb of entities
int$yearYear (0=current year, -1=all years)
Returns
array|int Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11

Definition at line 3958 of file product.class.php.

◆ _log_price()

Product::_log_price (   $user,
  $level = 0 
)
private

Insert a track that we changed a customer price.

Parameters
User$userUser making change
int$levelprice level to change
Returns
int Return integer <0 if KO, >0 if OK

Definition at line 1959 of file product.class.php.

◆ add_fournisseur()

Product::add_fournisseur (   $user,
  $id_fourn,
  $ref_fourn,
  $quantity 
)

Add a supplier price for the product.

Note: Duplicate ref is accepted for different quantity only, or for different companies.

Parameters
User$userUser that make link
int$id_fournSupplier id
string$ref_fournSupplier ref
float$quantityQuantity minimum for price
Returns
int Return integer < 0 if KO, 0 if link already exists for this product, > 0 if OK

Definition at line 4689 of file product.class.php.

◆ add_photo()

Product::add_photo (   $sdir,
  $file 
)

Move an uploaded file described into $file array into target directory $sdir.

Parameters
string$sdirTarget directory
string$fileArray of file info of file to upload: array('name'=>..., 'tmp_name'=>...)
Returns
int Return integer <0 if KO, >0 if OK

Definition at line 6059 of file product.class.php.

◆ add_sousproduit()

Product::add_sousproduit (   $id_pere,
  $id_fils,
  $qty,
  $incdec = 1,
  $notrigger = 0 
)

Link a product/service to a parent product/service.

Parameters
int$id_pereId of parent product/service
int$id_filsId of child product/service
float$qtyQuantity
int$incdec1=Increase/decrease stock of child when parent stock increase/decrease
int$notriggerDisable triggers
Returns
int Return integer < 0 if KO, > 0 if OK

Definition at line 4461 of file product.class.php.

◆ check()

Product::check ( )

Check that ref and label are ok.

Returns
int >1 if OK, <=0 if KO

Definition at line 632 of file product.class.php.

References dol_sanitizeFileName(), getDolGlobalInt(), and ref.

◆ check_barcode()

Product::check_barcode (   $valuetotest,
  $typefortest 
)

Check barcode.

Parameters
string$valuetotestValue to test
string$typefortestType of barcode (ISBN, EAN, ...)
Returns
int 0 if OK -1 ErrorBadBarCodeSyntax -2 ErrorBarCodeRequired -3 ErrorBarCodeAlreadyUsed

Definition at line 1033 of file product.class.php.

◆ clone_associations()

Product::clone_associations (   $fromId,
  $toId 
)

Clone links between products.

Parameters
int$fromIdProduct id
int$toIdProduct id
Returns
int Return integer <0 if KO, >0 if OK

Definition at line 4907 of file product.class.php.

References $sql, and dol_syslog().

◆ clone_fournisseurs()

Product::clone_fournisseurs (   $fromId,
  $toId 
)

Recopie les fournisseurs et prix fournisseurs d'un produit/service sur un autre.

Parameters
int$fromIdId produit source
int$toIdId produit cible
Returns
int Return integer < 0 si erreur, > 0 si ok

Definition at line 4934 of file product.class.php.

◆ clone_price()

Product::clone_price (   $fromId,
  $toId 
)

Recopie les prix d'un produit/service sur un autre.

Parameters
int$fromIdId product source
int$toIdId product target
Returns
int Return integer < 0 if KO, > 0 if OK

Definition at line 4819 of file product.class.php.

◆ correct_stock()

Product::correct_stock (   $user,
  $id_entrepot,
  $nbpiece,
  $movement,
  $label = '',
  $price = 0,
  $inventorycode = '',
  $origin_element = '',
  $origin_id = null,
  $disablestockchangeforsubproduct = 0,
  $extrafields = null 
)

Adjust stock in a warehouse for product.

Parameters
User$useruser asking change
int$id_entrepotid of warehouse
double$nbpiecenb of units (should be always positive, use $movement to decide if we add or remove)
int$movement0 = add, 1 = remove
string$labelLabel of stock movement
double$priceUnit price HT of product, used to calculate average weighted price (PMP in french). If 0, average weighted price is not changed.
string$inventorycodeInventory code
string$origin_elementOrigin element type
int$origin_idOrigin id of element
int$disablestockchangeforsubproductDisable stock change for sub-products of kit (useful only if product is a subproduct)
Extrafields$extrafieldsArray of extrafields
Returns
int Return integer <0 if KO, >0 if OK

Definition at line 5693 of file product.class.php.

◆ correct_stock_batch()

Product::correct_stock_batch (   $user,
  $id_entrepot,
  $nbpiece,
  $movement,
  $label = '',
  $price = 0,
  $dlc = '',
  $dluo = '',
  $lot = '',
  $inventorycode = '',
  $origin_element = '',
  $origin_id = null,
  $disablestockchangeforsubproduct = 0,
  $extrafields = null,
  $force_update_batch = false 
)

Adjust stock in a warehouse for product with batch number.

Parameters
User$useruser asking change
int$id_entrepotid of warehouse
double$nbpiecenb of units (should be always positive, use $movement to decide if we add or remove)
int$movement0 = add, 1 = remove
string$labelLabel of stock movement
double$pricePrice to use for stock eval
int | string$dlceat-by date
int | string$dluosell-by date
string$lotLot number
string$inventorycodeInventory code
string$origin_elementOrigin element type
int$origin_idOrigin id of element
int$disablestockchangeforsubproductDisable stock change for sub-products of kit (useful only if product is a subproduct)
Extrafields$extrafieldsArray of extrafields
boolean$force_update_batchForce update batch
Returns
int Return integer <0 if KO, >0 if OK

Definition at line 5756 of file product.class.php.

◆ create()

Product::create (   $user,
  $notrigger = 0 
)

Insert product into database.

Parameters
User$userUser making insert
int$notriggerDisable triggers
Returns
int Id of product/service if OK, < 0 if KO

Definition at line 663 of file product.class.php.

◆ del_sousproduit()

Product::del_sousproduit (   $fk_parent,
  $fk_child,
  $notrigger = 0 
)

Remove a link between a subproduct and a parent product/service.

Parameters
int$fk_parentId of parent product (child will no more be linked to it)
int$fk_childId of child product
int$notriggerDisable triggers
Returns
int Return integer < 0 if KO, > 0 if OK

Definition at line 4586 of file product.class.php.

◆ delete()

Product::delete ( User  $user,
  $notrigger = 0 
)

Delete a product from database (if not used)

Parameters
User$userUser (object) deleting product
int$notriggerDo not execute trigger
Returns
int Return integer < 0 if KO, 0 = Not possible, > 0 if OK

Definition at line 1488 of file product.class.php.

◆ delete_photo()

Product::delete_photo (   $file)

Delete a photo and its thumbs.

Parameters
string$filePath to image file
Returns
void

Definition at line 6207 of file product.class.php.

◆ delMultiLangs()

Product::delMultiLangs (   $langtodelete,
  $user 
)

Delete a language for this product.

Parameters
string$langtodeleteLanguage code to delete
User$userObject user making delete
Returns
int Return integer <0 if KO, >0 if OK

Definition at line 1794 of file product.class.php.

References $sql, and dol_syslog().

◆ fetch()

Product::fetch (   $id = 0,
  $ref = '',
  $ref_ext = '',
  $barcode = '',
  $ignore_expression = 0,
  $ignore_price_load = 0,
  $ignore_lang_load = 0 
)

Load a product in memory from database.

Parameters
int$idId of product/service to load
string$refRef of product/service to load
string$ref_extRef ext of product/service to load
string$barcodeBarcode of product/service to load
int$ignore_expressionWhen module dynamicprices is on, ignores the math expression for calculating price and uses the db value instead
int$ignore_price_loadLoad product without loading $this->multiprices... array (when we are sure we don't need them)
int$ignore_lang_loadLoad product without loading $this->multilangs language arrays (when we are sure we don't need them)
Returns
int Return integer <0 if KO, 0 if not found, >0 if OK

French VAT NPR

Local taxes

Definition at line 2540 of file product.class.php.

◆ fetch_prod_arbo()

Product::fetch_prod_arbo (   $prod,
  $compl_path = '',
  $multiply = 1,
  $level = 1,
  $id_parent = 0,
  $ignore_stock_load = 0 
)

Function recursive, used only by get_arbo_each_prod(), to build tree of subproducts into ->res Define value of this->res.

Parameters
array$prodProducts array
string$compl_pathDirectory path of parents to add before
int$multiplyBecause each sublevel must be multiplicated by parent nb
int$levelInit level
int$id_parentId parent
int$ignore_stock_loadIgnore stock load
Returns
void

Definition at line 4985 of file product.class.php.

◆ generateDocument()

Product::generateDocument (   $modele,
  $outputlangs,
  $hidedetails = 0,
  $hidedesc = 0,
  $hideref = 0 
)

Create a document onto disk according to template module.

Parameters
string$modeleForce model to use ('' to not force)
Translate$outputlangsObject langs to use for output
int$hidedetailsHide details of lines
int$hidedescHide description
int$hiderefHide ref
Returns
int 0 if KO, 1 if OK

Definition at line 5528 of file product.class.php.

◆ generateMultiprices()

Product::generateMultiprices ( User  $user,
  $baseprice,
  $price_type,
  $price_vat,
  $npr,
  $psq 
)

Generates prices for a product based on product multiprice generation rules.

Parameters
User$userUser that updates the prices
float$basepriceBase price
string$price_typeBase price type
float$price_vatVAT % tax
int$nprNPR
string$psq¿?
Returns
int -1 KO, 1 OK

Definition at line 6537 of file product.class.php.

◆ get_arbo_each_prod()

array Path of subproducts Build from sousprods with Product::get_arbo_each_prod (   $multiply = 1,
  $ignore_stock_load = 0 
)

Build the tree of subproducts and return it.

this->sousprods must have been loaded by this->get_sousproduits_arbo()

Parameters
int$multiplyBecause each sublevel must be multiplicated by parent nb
int$ignore_stock_loadIgnore stock load
Returns
array Array with tree

Definition at line 5049 of file product.class.php.

◆ get_barcode()

Product::get_barcode (   $object,
  $type = '' 
)

Get a barcode from the module to generate barcode values.

Return value is stored into this->barcode

Parameters
Product$objectObject product or service
string$typeBarcode type (ean, isbn, ...)
Returns
string

Definition at line 6350 of file product.class.php.

◆ get_buyprice()

Product::get_buyprice (   $prodfournprice,
  $qty,
  $product_id = 0,
  $fourn_ref = '',
  $fk_soc = 0 
)

Read price used by a provider.

We enter as input couple prodfournprice/qty or triplet qty/product_id/fourn_ref. This also set some properties on product like ->buyprice, ->fourn_pu, ...

Parameters
int$prodfournpriceId du tarif = rowid table product_fournisseur_price
double$qtyQuantity asked or -1 to get first entry found
int$product_idFilter on a particular product id
string$fourn_refFilter on a supplier price ref. 'none' to exclude ref in search.
int$fk_socIf of supplier
Returns
int|string Return integer <-1 if KO, -1 if qty not enough, 0 if OK but nothing found, id_product if OK and found. May also initialize some properties like (->ref_supplier, buyprice, fourn_pu, vatrate_supplier...), or printable result of hook
See also
getSellPrice(), find_min_price_product_fournisseur()

Definition at line 2149 of file product.class.php.

◆ get_image_size()

Product::get_image_size (   $file)

Load size of image file.

Parameters
string$filePath to file
Returns
void

Definition at line 6241 of file product.class.php.

◆ get_nb_achat()

Product::get_nb_achat (   $socid,
  $mode,
  $filteronproducttype = -1,
  $year = 0,
  $morefilter = '' 
)

Return nb of units or supplier invoices in which product is included.

Parameters
int$socidLimit count on a particular third party id
string$mode'byunit'=number of unit, 'bynumber'=nb of entities
int$filteronproducttype0=To filter on product only, 1=To filter on services only
int$yearYear (0=last 12 month, -1=all years)
string$morefilterMore sql filters
Returns
array Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11

Definition at line 4092 of file product.class.php.

◆ get_nb_contract()

Product::get_nb_contract (   $socid,
  $mode,
  $filteronproducttype = -1,
  $year = 0,
  $morefilter = '' 
)

Return nb of units in orders in which product is included.

Parameters
int$socidLimit count on a particular third party id
string$mode'byunit'=number of unit, 'bynumber'=nb of entities
int$filteronproducttype0=To filter on product only, 1=To filter on services only
int$yearYear (0=last 12 month, -1=all years)
string$morefilterMore sql filters
Returns
array Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11

Definition at line 4354 of file product.class.php.

◆ get_nb_mos()

Product::get_nb_mos (   $socid,
  $mode,
  $filteronproducttype = -1,
  $year = 0,
  $morefilter = '' 
)

Return nb of units in orders in which product is included.

Parameters
int$socidLimit count on a particular third party id
string$mode'byunit'=number of unit, 'bynumber'=nb of entities
int$filteronproducttype0=To filter on product only, 1=To filter on services only
int$yearYear (0=last 12 month, -1=all years)
string$morefilterMore sql filters
Returns
array Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11

Definition at line 4408 of file product.class.php.

◆ get_nb_order()

Product::get_nb_order (   $socid,
  $mode,
  $filteronproducttype = -1,
  $year = 0,
  $morefilter = '' 
)

Return nb of units in orders in which product is included.

Parameters
int$socidLimit count on a particular third party id
string$mode'byunit'=number of unit, 'bynumber'=nb of entities
int$filteronproducttype0=To filter on product only, 1=To filter on services only
int$yearYear (0=last 12 month, -1=all years)
string$morefilterMore sql filters
Returns
array Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11

Definition at line 4250 of file product.class.php.

◆ get_nb_ordersupplier()

Product::get_nb_ordersupplier (   $socid,
  $mode,
  $filteronproducttype = -1,
  $year = 0,
  $morefilter = '' 
)

Return nb of units in orders in which product is included.

Parameters
int$socidLimit count on a particular third party id
string$mode'byunit'=number of unit, 'bynumber'=nb of entities
int$filteronproducttype0=To filter on product only, 1=To filter on services only
int$yearYear (0=last 12 month, -1=all years)
string$morefilterMore sql filters
Returns
array Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11

Definition at line 4302 of file product.class.php.

◆ get_nb_propal()

Product::get_nb_propal (   $socid,
  $mode,
  $filteronproducttype = -1,
  $year = 0,
  $morefilter = '' 
)

Return nb of units in proposals in which product is included.

Parameters
int$socidLimit count on a particular third party id
string$mode'byunit'=number of unit, 'bynumber'=nb of entities, 'byamount'=amount
int$filteronproducttype0=To filter on product only, 1=To filter on services only
int$yearYear (0=last 12 month, -1=all years)
string$morefilterMore sql filters
Returns
array Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11

Definition at line 4145 of file product.class.php.

◆ get_nb_propalsupplier()

Product::get_nb_propalsupplier (   $socid,
  $mode,
  $filteronproducttype = -1,
  $year = 0,
  $morefilter = '' 
)

Return nb of units in proposals in which product is included.

Parameters
int$socidLimit count on a particular third party id
string$mode'byunit'=number of unit, 'bynumber'=nb of entities
int$filteronproducttype0=To filter on product only, 1=To filter on services only
int$yearYear (0=last 12 month, -1=all years)
string$morefilterMore sql filters
Returns
array Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11

Definition at line 4197 of file product.class.php.

◆ get_nb_vente()

Product::get_nb_vente (   $socid,
  $mode,
  $filteronproducttype = -1,
  $year = 0,
  $morefilter = '' 
)

Return nb of units or customers invoices in which product is included.

Parameters
int$socidLimit count on a particular third party id
string$mode'byunit'=number of unit, 'bynumber'=nb of entities
int$filteronproducttype0=To filter on product only, 1=To filter on services only
int$yearYear (0=last 12 month, -1=all years)
string$morefilterMore sql filters
Returns
array Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11

Definition at line 4038 of file product.class.php.

◆ get_sousproduits_arbo()

Product::get_sousproduits_arbo ( )
Return tree of all subproducts for product. Tree contains array of array(0=prodid, 1=>qty, 2=>product type, 3=>label, 4=>incdec, 5=>product ref)
Set this->sousprods
Returns
void

Definition at line 5269 of file product.class.php.

◆ getArrayForPriceCompare()

Product::getArrayForPriceCompare (   $level = 0)
private

used to check if price have really change to avoid log pollution

Parameters
int$levelprice level to change
Returns
array

Definition at line 1922 of file product.class.php.

◆ getChildsArbo()

Product::getChildsArbo (   $id,
  $firstlevelonly = 0,
  $level = 1,
  $parents = array() 
)

Return children of product $id.

Parameters
int$idId of product to search children of
int$firstlevelonlyReturn only direct child
int$levelLevel of recursing call (start to 1)
array$parentsArray of all parents of $id
Returns
array|int Return array(prodid=>array(0=prodid, 1=>qty, 2=>product type, 3=>label, 4=>incdec, 5=>product ref)

Definition at line 5195 of file product.class.php.

References $sql, dol_print_error(), and dol_syslog().

◆ getFather()

Product::getFather ( )

Return all parent products for current product (first level only)

Returns
array|int Array of product
See also
hasFatherOrChild()

Definition at line 5154 of file product.class.php.

References $sql, and dol_print_error().

◆ getKanbanView()

Product::getKanbanView (   $option = '',
  $arraydata = null 
)

Return clicable link of object (with eventually picto)

Parameters
string$optionWhere point the link (0=> main card, 1,2 => shipment, 'nolink'=>No link)
array$arraydataArray of data
Returns
string HTML Code for Kanban thumb.

Definition at line 6685 of file product.class.php.

◆ getLabelOfUnit()

Product::getLabelOfUnit (   $type = 'long')

Returns the text label from units dictionary.

Parameters
string$typeLabel type (long or short)
Returns
string|int Return integer <0 if ko, label if ok

Definition at line 6429 of file product.class.php.

◆ getLibFinished()

Product::getLibFinished ( )

Retour label of nature of product.

Returns
string|int Return label or ''. -1 if error

Definition at line 5653 of file product.class.php.

◆ getLibStatut()

Product::getLibStatut (   $mode = 0,
  $type = 0 
)

Return label of status of object.

Parameters
int$mode0=long label, 1=short label, 2=Picto + short label, 3=Picto, 4=Picto + long label, 5=Short label + Picto
int$type0=Sell, 1=Buy, 2=Batch Number management
Returns
string Label of status

Reimplemented in ProductFournisseur.

Definition at line 5552 of file product.class.php.

◆ getMultiLangs()

Product::getMultiLangs ( )

Load array this->multilangs.

Returns
int Return integer <0 if KO, >0 if OK

Definition at line 1886 of file product.class.php.

◆ getNomUrl()

Product::getNomUrl (   $withpicto = 0,
  $option = '',
  $maxlength = 0,
  $save_lastsearch_value = -1,
  $notooltip = 0,
  $morecss = '',
  $add_label = 0,
  $sep = ' - ' 
)

Return clickable link of object (with eventually picto)

Parameters
int$withpictoAdd picto into link
string$optionWhere point the link ('stock', 'composition', 'category', 'supplier', '')
int$maxlengthMaxlength of ref
int$save_lastsearch_value-1=Auto, 0=No save of lastsearch_values when clicking, 1=Save lastsearch_values when clicking
int$notooltipNo tooltip
string$morecss''=Add more css on link
int$add_label0=Default, 1=Add label into string, >1=Add first chars into string
string$sep' - '=Separator between ref and label if option 'add_label' is set
Returns
string String with URL

Reimplemented in ProductFournisseur.

Definition at line 5425 of file product.class.php.

◆ getProductDurationHours()

Product::getProductDurationHours ( )

Return the duration of a service in hours (for a service based on duration fields)

Returns
float|-1 Duration in hours if OK, -1 if KO

Definition at line 6645 of file product.class.php.

◆ getRights()

Product::getRights ( )

Returns the rights used for this class.

Returns
Object

Reimplemented from CommonObject.

Definition at line 6594 of file product.class.php.

References isProduct().

◆ getSellOrEatByMandatoryLabel()

Product::getSellOrEatByMandatoryLabel ( )

Get sell or eat by mandatory label.

Returns
string Sell or eat by mandatory label

Definition at line 1666 of file product.class.php.

◆ getSellOrEatByMandatoryList()

static Product::getSellOrEatByMandatoryList ( )
static

Get sell or eat by mandatory list.

Returns
array Sell or eat by mandatory list

Definition at line 1647 of file product.class.php.

◆ getSellPrice()

Product::getSellPrice (   $thirdparty_seller,
  $thirdparty_buyer,
  $pqp = 0 
)

Return price of sell of a product for a seller/buyer/product.

Parameters
Societe$thirdparty_sellerSeller
Societe$thirdparty_buyerBuyer
int$pqpId of product price per quantity if a selection was done of such a price
Returns
array Array of price information array('pu_ht'=> , 'pu_ttc'=> , 'tva_tx'=>'X.Y (code)', ...), 'tva_npr'=>0, ...)
See also
get_buyprice(), find_min_price_product_fournisseur()

Definition at line 2026 of file product.class.php.

◆ getTooltipContentArray()

Product::getTooltipContentArray (   $params)

getTooltipContentArray

Parameters
array$paramsparams to construct tooltip data
Since
v18
Returns
array

Reimplemented from CommonObject.

Definition at line 5288 of file product.class.php.

◆ hasbatch()

Product::hasbatch ( )

Return if object has a sell-by date or eat-by date.

Returns
boolean True if it's has

Definition at line 6335 of file product.class.php.

◆ hasFatherOrChild()

Product::hasFatherOrChild (   $mode = 0)

Count all parent and children products for current product (first level only)

Parameters
int$mode0=Both parent and child, -1=Parents only, 1=Children only
Returns
int Nb of father + child
See also
getFather(), get_sousproduits_arbo()

Definition at line 5071 of file product.class.php.

◆ hasVariants()

Product::hasVariants ( )

Return if a product has variants or not.

Returns
int Number of variants

Definition at line 5103 of file product.class.php.

References $sql.

◆ info()

Product::info (   $id)

Load information for tab info.

Parameters
int$idId of thirdparty to load
Returns
void

Definition at line 6611 of file product.class.php.

References $sql.

◆ initAsSpecimen()

Product::initAsSpecimen ( )

Initialise an instance with random values.

Used to build previews or test instances. id must be 0 if object instance is a specimen.

Returns
int

Definition at line 6382 of file product.class.php.

◆ is_photo_available()

Product::is_photo_available (   $sdir)

Return if at least one photo is available.

Parameters
string$sdirDirectory to scan
Returns
boolean True if at least one photo is available, False if not

Definition at line 6105 of file product.class.php.

◆ is_sousproduit()

Product::is_sousproduit (   $fk_parent,
  $fk_child 
)

Check if it is a sub-product into a kit.

Parameters
int$fk_parentId of parent kit product
int$fk_childId of child product
Returns
int Return 1 or 0; -1 if error

Definition at line 4649 of file product.class.php.

References $sql.

◆ isMandatoryPeriod()

Product::isMandatoryPeriod ( )

Return if object have a constraint on mandatory_period.

Returns
boolean True if mandatory_period set to 1

Definition at line 6325 of file product.class.php.

◆ isProduct()

Product::isProduct ( )

Return if object is a product.

Returns
boolean True if it's a product

Definition at line 6295 of file product.class.php.

References type, and TYPE_PRODUCT.

Referenced by getRights(), and isStockManaged().

◆ isService()

Product::isService ( )

Return if object is a product.

Returns
boolean True if it's a service

Definition at line 6305 of file product.class.php.

References type, and TYPE_SERVICE.

◆ isStockManaged()

Product::isStockManaged ( )

Return if object need to have its stock managed.

Returns
boolean True if it's a service

Definition at line 6315 of file product.class.php.

References getDolGlobalString(), and isProduct().

◆ isVariant()

Product::isVariant ( )

Return if loaded product is a variant.

Returns
bool|int Return true if the product is a variant, false if not, -1 if error

Definition at line 5126 of file product.class.php.

◆ LibStatut()

Product::LibStatut (   $status,
  $mode = 0,
  $type = 0 
)

Return label of a given status.

Parameters
int$statusStatut
int$mode0=long label, 1=short label, 2=Picto + short label, 3=Picto, 4=Picto + long label, 5=Short label + Picto, 6=Long label + Picto
int$type0=Status "to sell", 1=Status "to buy", 2=Status "to Batch"
Returns
string Label of status

Reimplemented in ProductFournisseur.

Definition at line 5576 of file product.class.php.

◆ list_suppliers()

Product::list_suppliers ( )

Return list of suppliers providing the product or service.

Returns
array Array of vendor ids

Definition at line 4785 of file product.class.php.

◆ liste_photos()

Product::liste_photos (   $dir,
  $nbmax = 0 
)

Return an array with all photos of product found on disk.

There is no sorting criteria.

Parameters
string$dirDirectory to scan
int$nbmaxNumber maximum of photos (0=no maximum)
Returns
array Array of photos

Definition at line 6147 of file product.class.php.

◆ load_stats_bom()

Product::load_stats_bom (   $socid = 0)

Charge tableau des stats OF pour le produit/service.

Parameters
int$socidId societe
Returns
int Array of stats in $this->stats_bom, <0 if ko or >0 if ok

Definition at line 3020 of file product.class.php.

◆ load_stats_commande()

Product::load_stats_commande (   $socid = 0,
  $filtrestatut = '',
  $forVirtualStock = 0 
)

Charge tableau des stats commande client pour le produit/service.

Parameters
int$socidId thirdparty to filter on a thirdparty
string$filtrestatutId status to filter on a status
int$forVirtualStockIgnore rights filter for virtual stock calculation. Set when load_stats_commande is used for virtual stock calculation.
Returns
integer Array of stats in $this->stats_commande (nb=nb of order, qty=qty ordered), <0 if ko or >0 if ok

Definition at line 3220 of file product.class.php.

◆ load_stats_commande_fournisseur()

Product::load_stats_commande_fournisseur (   $socid = 0,
  $filtrestatut = '',
  $forVirtualStock = 0,
  $dateofvirtualstock = null 
)

Charge tableau des stats commande fournisseur pour le produit/service.

Parameters
int$socidId thirdparty to filter on a thirdparty
string$filtrestatutId of status to filter on status
int$forVirtualStockIgnore rights filter for virtual stock calculation.
int$dateofvirtualstockDate of virtual stock
Returns
int Array of stats in $this->stats_commande_fournisseur, <0 if ko or >0 if ok

Definition at line 3348 of file product.class.php.

◆ load_stats_contrat()

Product::load_stats_contrat (   $socid = 0)

Charge tableau des stats contrat pour le produit/service.

Parameters
int$socidId societe
Returns
int Array of stats in $this->stats_contrat, <0 if ko or >0 if ok

Definition at line 3680 of file product.class.php.

◆ load_stats_facture()

Product::load_stats_facture (   $socid = 0)

Charge tableau des stats facture pour le produit/service.

Parameters
int$socidId societe
Returns
int Array of stats in $this->stats_facture, <0 if ko or >0 if ok

Definition at line 3754 of file product.class.php.

◆ load_stats_facture_fournisseur()

Product::load_stats_facture_fournisseur (   $socid = 0)

Charge tableau des stats facture pour le produit/service.

Parameters
int$socidId societe
Returns
int Array of stats in $this->stats_facture_fournisseur, <0 if ko or >0 if ok

Definition at line 3903 of file product.class.php.

◆ load_stats_facturerec()

Product::load_stats_facturerec (   $socid = 0)

Charge tableau des stats facture recurrentes pour le produit/service.

Parameters
int$socidId societe
Returns
int Array of stats in $this->stats_facture, <0 if ko or >0 if ok

Definition at line 3829 of file product.class.php.

◆ load_stats_inproduction()

Product::load_stats_inproduction (   $socid = 0,
  $filtrestatut = '',
  $forVirtualStock = 0,
  $dateofvirtualstock = null,
  $warehouseid = 0 
)

Charge tableau des stats production pour le produit/service.

Parameters
int$socidId thirdparty to filter on a thirdparty
string$filtrestatutId status to filter on a status
int$forVirtualStockIgnore rights filter for virtual stock calculation.
int$dateofvirtualstockDate of virtual stock
int$warehouseidFilter by a warehouse. Warning: When a filter on a warehouse is set, it is not possible to calculate an accurate virtual stock because we can't know in which warehouse will be done virtual stock changes.
Returns
integer Array of stats in $this->stats_mrptoproduce (nb=nb of order, qty=qty ordered), <0 if ko or >0 if ok

Definition at line 3557 of file product.class.php.

◆ load_stats_mo()

Product::load_stats_mo (   $socid = 0)

Charge tableau des stats OF pour le produit/service.

Parameters
int$socidId societe
Returns
int Array of stats in $this->stats_mo, <0 if ko or >0 if ok

Definition at line 2960 of file product.class.php.

◆ load_stats_propale()

Product::load_stats_propale (   $socid = 0)

Charge tableau des stats propale pour le produit/service.

Parameters
int$socidId societe
Returns
int Array of stats in $this->stats_propale, <0 if ko or >0 if ok

Definition at line 3089 of file product.class.php.

◆ load_stats_proposal_supplier()

Product::load_stats_proposal_supplier (   $socid = 0)

Charge tableau des stats propale pour le produit/service.

Parameters
int$socidId thirdparty
Returns
int Array of stats in $this->stats_proposal_supplier, <0 if ko or >0 if ok

Definition at line 3164 of file product.class.php.

◆ load_stats_reception()

Product::load_stats_reception (   $socid = 0,
  $filtrestatut = '',
  $forVirtualStock = 0,
  $dateofvirtualstock = null 
)

Charge tableau des stats réception fournisseur pour le produit/service.

Parameters
int$socidId thirdparty to filter on a thirdparty
string$filtrestatutId status to filter on a status
int$forVirtualStockIgnore rights filter for virtual stock calculation.
int$dateofvirtualstockDate of virtual stock
Returns
int Array of stats in $this->stats_reception, <0 if ko or >0 if ok

Definition at line 3495 of file product.class.php.

◆ load_stats_sending()

Product::load_stats_sending (   $socid = 0,
  $filtrestatut = '',
  $forVirtualStock = 0,
  $filterShipmentStatus = '' 
)

Charge tableau des stats expedition client pour le produit/service.

Parameters
int$socidId thirdparty to filter on a thirdparty
string$filtrestatut[=''] Ids order status separated by comma
int$forVirtualStockIgnore rights filter for virtual stock calculation.
string$filterShipmentStatus[=''] Ids shipment status separated by comma
Returns
int Array of stats in $this->stats_expedition, <0 if ko or >0 if ok

Definition at line 3409 of file product.class.php.

◆ load_stock()

Product::load_stock (   $option = '',
  $includedraftpoforvirtual = null,
  $dateofvirtualstock = null 
)

Load information about stock of a product into ->stock_reel, ->stock_warehouse[] (including stock_warehouse[idwarehouse]->detail_batch for batch products) This function need a lot of load.

If you use it on list, use a cache to execute it once for each product id. If ENTREPOT_EXTRA_STATUS is set, filtering on warehouse status is possible.

Parameters
string$option'' = Load all stock info, also from closed and internal warehouses, 'nobatch' = do not load batch detail, 'novirtual' = do no load virtual detail You can also filter on 'warehouseclosed', 'warehouseopen', 'warehouseinternal'
int$includedraftpoforvirtualInclude draft status of PO for virtual stock calculation
int$dateofvirtualstockDate of virtual stock
Returns
int Return integer < 0 if KO, > 0 if OK
See also
load_virtual_stock(), loadBatchInfo()

Definition at line 5811 of file product.class.php.

◆ load_virtual_stock()

Product::load_virtual_stock (   $includedraftpoforvirtual = null,
  $dateofvirtualstock = null 
)

Load value ->stock_theorique of a product.

Property this->id must be defined. This function need a lot of load. If you use it on list, use a cache to execute it one for each product id.

Parameters
int$includedraftpoforvirtualInclude draft status and not yet approved Purchase Orders for virtual stock calculation
int$dateofvirtualstockDate of virtual stock
Returns
int Return integer < 0 if KO, > 0 if OK
See also
load_stock(), loadBatchInfo()

Definition at line 5890 of file product.class.php.

◆ loadBatchInfo()

Product::loadBatchInfo (   $batch)

Load existing information about a serial.

Parameters
string$batchLot/serial number
Returns
array Array with record into product_batch
See also
load_stock(), load_virtual_stock()

Definition at line 6026 of file product.class.php.

◆ loadStateBoard()

Product::loadStateBoard ( )

Load indicators this->nb for the dashboard.

Returns
int Return integer <0 if KO, >0 if OK

Definition at line 6255 of file product.class.php.

◆ log_price_delete()

Product::log_price_delete (   $user,
  $rowid 
)

Delete a price line.

Parameters
User$userObject user
int$rowidLine id to delete
Returns
int Return integer <0 if KO, >0 if OK

Definition at line 1998 of file product.class.php.

◆ min_recommended_price()

Product::min_recommended_price ( )

Return minimum product recommended price.

Returns
int Minimum recommended price that is higher price among all suppliers * PRODUCT_MINIMUM_RECOMMENDED_PRICE

Definition at line 6465 of file product.class.php.

◆ replaceThirdparty()

static Product::replaceThirdparty ( DoliDB  $dbs,
  $origin_id,
  $dest_id 
)
static

Function used to replace a thirdparty id with another one.

Parameters
DoliDB$dbsDatabase handler
int$origin_idOld thirdparty id
int$dest_idNew thirdparty id
Returns
bool

Reimplemented in ProductFournisseur.

Definition at line 6516 of file product.class.php.

References CommonObject\commonReplaceThirdparty().

◆ setAccountancyCode()

Product::setAccountancyCode (   $type,
  $value 
)

Sets an accountancy code for a product.

Also calls PRODUCT_MODIFY trigger when modified

Parameters
string$typeIt can be 'buy', 'buy_intra', 'buy_export', 'sell', 'sell_intra' or 'sell_export'
string$valueAccountancy code
Returns
int Return integer <0 KO >0 OK

Definition at line 1826 of file product.class.php.

◆ setCategories()

Product::setCategories (   $categories)

Sets object to supplied categories.

Deletes object from existing categories not supplied. Adds it to non existing supplied categories. Existing categories are left untouch.

Parameters
int[] | int$categoriesCategory or categories IDs
Returns
int Return integer <0 if KO, >0 if OK

Definition at line 6502 of file product.class.php.

◆ setMultiLangs()

Product::setMultiLangs (   $user)

Update or add a translation for a product.

Parameters
User$userObject user making update
Returns
int Return integer <0 if KO, >0 if OK

Definition at line 1684 of file product.class.php.

◆ setPriceExpression()

Product::setPriceExpression (   $expression_id)

Sets the supplier price expression.

Parameters
int$expression_idExpression
Returns
int Return integer <0 if KO, >0 if OK
Deprecated:
Use Product::update instead

Definition at line 2519 of file product.class.php.

References update().

◆ update()

Product::update (   $id,
  $user,
  $notrigger = 0,
  $action = 'update',
  $updatetype = false 
)

Update a record into database.

If batch flag is set to on, we create records into llx_product_batch

Parameters
int$idId of product
User$userObject user making update
int$notriggerDisable triggers
string$actionCurrent action for hookmanager ('add' or 'update')
boolean$updatetypeUpdate product type
Returns
int 1 if OK, -1 if ref already exists, -2 if other error

Definition at line 1070 of file product.class.php.

Referenced by setPriceExpression().

◆ update_sousproduit()

Product::update_sousproduit (   $id_pere,
  $id_fils,
  $qty,
  $incdec = 1,
  $notrigger = 0 
)

Modify composed product.

Parameters
int$id_pereId of parent product/service
int$id_filsId of child product/service
float$qtyQuantity
int$incdec1=Increase/decrease stock of child when parent stock increase/decrease
int$notriggerDisable triggers
Returns
int Return integer < 0 if KO, > 0 if OK

Definition at line 4534 of file product.class.php.

◆ updatePrice()

Product::updatePrice (   $newprice,
  $newpricebase,
  $user,
  $newvat = null,
  $newminprice = 0,
  $level = 0,
  $newnpr = 0,
  $newpbq = 0,
  $ignore_autogen = 0,
  $localtaxes_array = array(),
  $newdefaultvatcode = '',
  $price_label = '',
  $notrigger = 0 
)

Modify customer price of a product/Service for a given level.

Parameters
double$newpriceNew price
string$newpricebaseHT or TTC
User$userObject user that make change
?double$newvat New VAT Rate (For example 8.5. Should not be a string)
double$newminpriceNew price min
int$level0=standard, >0 = level if multilevel prices
int$newnpr0=Standard vat rate, 1=Special vat rate for French NPR VAT
int$newpbq1 if it has price by quantity
int$ignore_autogenUsed to avoid infinite loops
array$localtaxes_arrayArray with localtaxes info array('0'=>type1,'1'=>rate1,'2'=>type2,'3'=>rate2) (loaded by getLocalTaxesFromRate(vatrate, 0, ...) function).
string$newdefaultvatcodeDefault vat code
string$price_labelPrice Label
int$notriggerDisable triggers
Returns
int Return integer <0 if KO, >0 if OK

Definition at line 2323 of file product.class.php.

◆ verify()

Product::verify ( )

Check properties of product are ok (like name, barcode, ...).

All properties must be already loaded on object (this->barcode, this->barcode_type_code, ...).

Returns
int 0 if OK, <0 if KO

Definition at line 981 of file product.class.php.

Member Data Documentation

◆ $libelle

Product::$libelle
Deprecated:
Use $label instead
See also
$label

Definition at line 108 of file product.class.php.

◆ $ref_fourn

Product::$ref_fourn
Deprecated:
See also
$ref_supplier

Definition at line 495 of file product.class.php.


The documentation for this class was generated from the following file: