Class to manage categories. More...

Inheritance diagram for Categorie:

Collaboration diagram for Categorie:

[legend]

Public Member Functions
	__construct ($db)
	Constructor. More...

	getMapList ()
	Get map list. More...

	fetch ($id, $label='', $type=null, $ref_ext='')
	Load category into memory from database. More...

	create ($user)
	Add category into database. More...

	update (User $user)
	Update category. More...

	delete ($user, $notrigger=0)
	Delete a category from database. More...

	add_type ($obj, $type='')
	Link an object to the category. More...

	del_type ($obj, $type)
	Delete object from category. More...

	getObjectsInCateg ($type, $onlyids=0, $limit=0, $offset=0, $sortfield='', $sortorder='ASC')
	Return list of fetched instance of elements having this category. More...

	containsObject ($type, $object_id)
	Check for the presence of an object in a category. More...

	getListForItem ($id, $type='customer', $sortfield="s.rowid", $sortorder='ASC', $limit=0, $page=0)
	List categories of an element id. More...

	get_filles ()
	Return direct childs id of a category into an array. More...

	get_full_arbo ($type, $markafterid=0, $include=0)
	Rebuilding the category tree as an array Return an array of table('id','id_mere',...) trie selon arbre et avec: id = id de la categorie id_mere = id de la categorie mere id_children = tableau des id enfant label = nom de la categorie fulllabel = nom avec chemin complet de la categorie fullpath = chemin complet compose des id. More...

	debug_cats ()
	Display content of $this->cats. More...

	get_all_categories ($type=null, $parent=false)
	Returns all categories. More...

	get_main_categories ($type=null)
	Returns the top level categories (which are not child) More...

	already_exists ()
	Check if no category with same label already exists for this cat's parent or root and for this cat's type. More...

	print_all_ways ($sep='>>', $url='', $nocolor=0, $addpicto=0)
	Returns the path of the category, with the names of the categories separated by $sep (" >> " by default) More...

	get_meres ()
	Returns an array containing the list of parent categories. More...

	get_all_ways ()
	Returns in a table all possible paths to get to the category starting with the major categories represented by Tables of categories. More...

	containing ($id, $type, $mode='object')
	Return list of categories (object instances or labels) linked to element of id $id and type $type Should be named getListOfCategForObject. More...

	rechercher ($id, $nom, $type, $exact=false, $case=false)
	Returns categories whose id or name match add wildcards in the name unless $exact = true. More...

	getNomUrl ($withpicto=0, $option='', $maxlength=0, $moreparam='')
	Return name and link of category (with picto) Use ->id, ->ref, ->label, ->color. More...

	add_photo ($sdir, $file)
	Deplace fichier uploade sous le nom $file dans le repertoire sdir. More...

	liste_photos ($dir, $nbmax=0)
	Return tableau de toutes les photos de la categorie. More...

	delete_photo ($file)
	Efface la photo de la categorie et sa vignette. More...

	get_image_size ($file)
	Load size of image file. More...

	setMultiLangs ($user)
	Update ou cree les traductions des infos produits. More...

	getMultiLangs ()
	Load array this->multilangs. More...

	getLibStatut ($mode)
	Return label of contact status. More...

	initAsSpecimen ()
	Initialise an instance with random values. More...

	countNbOfCategories ()
	Count all categories. More...

Public Member Functions inherited from CommonObject
	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...

	getFullName ($langs, $option=0, $nameorder=-1, $maxlen=0)
	Return full name (civility+' '+name+' '+lastname) More...

	setUpperOrLowerCase ()
	Set to upper or ucwords/lower if needed. More...

	getKanbanView ($option='')
	Return clicable link of object (with eventually picto) More...

	getFullAddress ($withcountry=0, $sep="\n", $withregion=0, $extralangcode='')
	Return full address of contact. More...

	getBannerAddress ($htmlkey, $object)
	Return full address for banner. 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...

	setMulticurrencyRate ($rate, $mode=1)
	Change the multicurrency rate. 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=false, $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=false, $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='')
	Update note of element. More...

	update_note_public ($note)
	Update public note (kept for backward compatibility) More...

	update_price ($exclspec=0, $roundingadjust='none', $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...

	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='', $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. 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...

	getDefaultCreateValueFor ($fieldname, $alternatevalue=null)
	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 ($val, $fieldKey, $fieldValue)
	Return validation test result for a field. More...

	showOptionals ($extrafields, $mode='view', $params=null, $keysuffix='', $keyprefix='', $onetrtd=0, $display_type='card')
	Function to show lines of extrafields with output datas. More...

	getJSListDependancies ($type='_extra')

	getRights ()
	Returns the rights used for this class. More...

	defineBuyPrice ($unitPrice=0.0, $discountPercent=0.0, $fk_product=0)
	Get buy price to use for margin calculation. More...

	show_photos ($modulepart, $sdir, $size=0, $nbmax=0, $nbbyrow=5, $showfilename=0, $showaction=0, $maxHeight=120, $maxWidth=160, $nolink=0, $notitle=0, $usesharelink=0)
	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...

	getFieldList ($alias='')
	Function to concat keys of fields. More...

	createCommon (User $user, $notrigger=false)
	Create object into database. More...

	fetchCommon ($id, $ref=null, $morewhere='')
	Load object in memory from the database. More...

	fetchLinesCommon ($morewhere='')
	Load object in memory from the database. More...

	updateCommon (User $user, $notrigger=false)
	Update object into database. More...

	deleteCommon (User $user, $notrigger=false, $forcechilddeletion=0)
	Delete object in database. More...

	deleteByParentField ($parentId=0, $parentField='', $filter=array(), $filtermode="AND")
	Delete all child object from a parent ID. More...

	deleteLineCommon (User $user, $idline, $notrigger=false)
	Delete a line of object in database. More...

	setStatusCommon ($user, $status, $notrigger=0, $triggercode='')
	Set to a 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	replaceThirdparty (DoliDB $db, $origin_id, $dest_id)
	Function used to replace a thirdparty id with another one. More...

static	getFilterJoinQuery ($type, $rowIdName)
	Return the addtional SQL JOIN query for filtering a list by a category. More...

static	getFilterSelectQuery ($type, $rowIdName, $searchList)
	Return the addtional SQL SELECT query for filtering a list by a category. More...

Static Public Member Functions inherited from CommonObject
static	isExistingObject ($element, $id, $ref='', $ref_ext='')
	Check an object id/ref exists If you don't need/want to instantiate object and just need to know if 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	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 $db, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
	Function used to replace a thirdparty id with another one. More...

static	commonReplaceProduct (DoliDB $db, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
	Function used to replace a product id with another one. More...

Protected Member Functions
	load_motherof ()
	Load the array this->motherof that is array(id_son=>id_parent, ...) More...

Protected Member Functions inherited from CommonObject
	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...

Private Member Functions
	buildPathFromId ($id_categ, $protection=1000)
	For category id_categ and its childs available in this->cats, define property fullpath and fulllabel. More...

Additional Inherited Members
Public Attributes inherited from CommonObject
	$projet

	$fk_projet

	$note

Detailed Description

Class to manage categories.

Definition at line 47 of file categorie.class.php.

Constructor & Destructor Documentation

◆ __construct()

Categorie::__construct ( $db )

Constructor.

Parameters

DoliDB $db Database handler

Definition at line 273 of file categorie.class.php.

Member Function Documentation

◆ add_photo()

Categorie::add_photo	(	$sdir,
		$file
	)

Deplace fichier uploade sous le nom $file dans le repertoire sdir.

Parameters

string	$sdir	Final destination directory
array	$file	Uploaded file name

Returns: void

Definition at line 1690 of file categorie.class.php.

◆ add_type()

Categorie::add_type	(	$obj,
		$type = `''`
	)

Link an object to the category.

Parameters

CommonObject	$obj	Object to link to category
string	$type	Type of category ('product', ...). Use '' to take $obj->element.

Returns: int 1 : OK, -1 : erreur SQL, -2 : id not defined, -3 : Already linked

See also: del_type()

Definition at line 700 of file categorie.class.php.

◆ already_exists()

Categorie::already_exists ( )

Check if no category with same label already exists for this cat's parent or root and for this cat's type.

Returns: integer 1 if already exist, 0 otherwise, -1 if error

Definition at line 1330 of file categorie.class.php.

◆ buildPathFromId()

Categorie::buildPathFromId	(	$id_categ,
		$protection = `1000`
	)

private

For category id_categ and its childs available in this->cats, define property fullpath and fulllabel.

It is called by get_full_arbo() This function is a memory scan only from $this->cats and $this->motherof, no database access must be done here.

Parameters

int	$id_categ	id_categ entry to update
int	$protection	Deep counter to avoid infinite loop

Returns: void

See also: get_full_arbo()

Definition at line 1213 of file categorie.class.php.

References dol_syslog().

◆ containing()

Categorie::containing	(	$id,
		$type,
		$mode = `'object'`
	)

Return list of categories (object instances or labels) linked to element of id $id and type $type Should be named getListOfCategForObject.

Parameters

int	$id	Id of element
string \| int	$type	Type of category ('customer', 'supplier', 'contact', 'product', 'member') or (0, 1, 2, ...)
string	$mode	'id'=Get array of category ids, 'object'=Get array of fetched category instances, 'label'=Get array of category labels, 'id'= Get array of category IDs

Returns: Categorie[]|int Array of category objects or < 0 if KO

Definition at line 1503 of file categorie.class.php.

◆ containsObject()

Categorie::containsObject	(	$type,
		$object_id
	)

Check for the presence of an object in a category.

Parameters

string	$type	Type of category ('customer', 'supplier', 'contact', 'product', 'member')
int	$object_id	Id of the object to search

Returns: int Number of occurrences

See also: getObjectsInCateg()

Definition at line 910 of file categorie.class.php.

◆ countNbOfCategories()

Categorie::countNbOfCategories ( )

Count all categories.

Returns: int Number of categories, -1 on error

Definition at line 2048 of file categorie.class.php.

References dol_syslog().

◆ create()

Categorie::create ( $user )

Add category into database.

Parameters

User $user Object user

Returns: int -1 : SQL error -2 : new ID unknown -3 : Invalid category -4 : category already exists

Definition at line 414 of file categorie.class.php.

◆ debug_cats()

Categorie::debug_cats ( )

Display content of $this->cats.

Returns: void

Definition at line 1256 of file categorie.class.php.

◆ del_type()

Categorie::del_type	(	$obj,
		$type
	)

Delete object from category.

Parameters

CommonObject	$obj	Object
string	$type	Type of category ('customer', 'supplier', 'contact', 'product', 'member')

Returns: int 1 if OK, -1 if KO

See also: add_type()

Definition at line 793 of file categorie.class.php.

◆ delete()

Categorie::delete	(	$user,
		$notrigger = `0`
	)

Delete a category from database.

Parameters

User	$user	Object user that ask to delete
int	$notrigger	1=Does not execute triggers, 0= execute triggers

Returns: int <0 KO >0 OK

Definition at line 605 of file categorie.class.php.

◆ delete_photo()

Categorie::delete_photo ( $file )

Efface la photo de la categorie et sa vignette.

Parameters

string $file Path to file

Returns: void

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

◆ fetch()

Categorie::fetch	(	$id,
		$label = `''`,
		$type = `null`,
		$ref_ext = `''`
	)

Load category into memory from database.

Parameters

int	$id	Id of category
string	$label	Label of category
string	$type	Type of category ('product', '...') or (0, 1, ...)
string	$ref_ext	External reference of object

Returns: int <0 if KO, >0 if OK

Definition at line 330 of file categorie.class.php.

◆ get_all_categories()

Categorie::get_all_categories	(	$type = `null`,
		$parent = `false`
	)

Returns all categories.

Parameters

int	$type	Type of category (0, 1, ...)
boolean	$parent	Just parent categories if true

Returns: array|int Table of Object Category, -1 on error

Definition at line 1280 of file categorie.class.php.

Referenced by get_main_categories().

◆ get_all_ways()

Categorie::get_all_ways ( )

Returns in a table all possible paths to get to the category starting with the major categories represented by Tables of categories.

Returns: array

Definition at line 1469 of file categorie.class.php.

◆ get_filles()

Categorie::get_filles ( )

Return direct childs id of a category into an array.

Returns: array|int <0 KO, array ok

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

◆ get_full_arbo()

Categorie::get_full_arbo	(	$type,
		$markafterid = `0`,
		$include = `0`
	)

Rebuilding the category tree as an array Return an array of table('id','id_mere',...) trie selon arbre et avec: id = id de la categorie id_mere = id de la categorie mere id_children = tableau des id enfant label = nom de la categorie fulllabel = nom avec chemin complet de la categorie fullpath = chemin complet compose des id.

Parameters

string	$type	Type of categories ('customer', 'supplier', 'contact', 'product', 'member', ...)
int \| string \| array	$markafterid	Keep only or removed all categories including the leaf $markafterid in category tree (exclude) or Keep only of category is inside the leaf starting with this id. $markafterid can be an : int (id of category) string (categories ids separated by comma) array (list of categories ids)
int	$include	[=0] Removed or 1=Keep only

Returns: array|int Array of categories. this->cats and this->motherof are set, -1 on error

Definition at line 1105 of file categorie.class.php.

◆ get_image_size()

Categorie::get_image_size ( $file )

Load size of image file.

Parameters

string $file Path to file

Returns: void

Definition at line 1822 of file categorie.class.php.

◆ get_main_categories()

Categorie::get_main_categories ( $type = null )

Returns the top level categories (which are not child)

Parameters

int $type Type of category (0, 1, ...)

Returns: array

Definition at line 1318 of file categorie.class.php.

References get_all_categories().

◆ get_meres()

Categorie::get_meres ( )

Returns an array containing the list of parent categories.

Returns: int|array <0 KO, array OK

Definition at line 1437 of file categorie.class.php.

◆ getFilterJoinQuery()

static Categorie::getFilterJoinQuery	(	$type,
		$rowIdName
	)

static

Return the addtional SQL JOIN query for filtering a list by a category.

Parameters

string	$type	The category type (e.g Categorie::TYPE_WAREHOUSE)
string	$rowIdName	The name of the row id inside the whole sql query (e.g. "e.rowid")

Returns: string A additional SQL JOIN query

Deprecated:: search on some categories must be done using a WHERE EXISTS or NOT EXISTS and not a LEFT JOIN. @TODO Replace with getWhereQuery($type, $searchCategoryList)

Definition at line 1993 of file categorie.class.php.

◆ getFilterSelectQuery()

static Categorie::getFilterSelectQuery	(	$type,
		$rowIdName,
		$searchList
	)

static

Return the addtional SQL SELECT query for filtering a list by a category.

Parameters

string	$type	The category type (e.g Categorie::TYPE_WAREHOUSE)
string	$rowIdName	The name of the row id inside the whole sql query (e.g. "e.rowid")
Array	$searchList	A list with the selected categories

Returns: string A additional SQL SELECT query

Deprecated:: search on some categories must be done using a WHERE EXISTS or NOT EXISTS and not a LEFT JOIN

Definition at line 2011 of file categorie.class.php.

◆ getLibStatut()

Categorie::getLibStatut ( $mode )

Return label of contact status.

Parameters

int $mode 0=Long label, 1=Short label, 2=Picto + Short label, 3=Picto, 4=Picto + Long label, 5=Short label + Picto, 6=Long label + Picto

Returns: string Label of contact status

Definition at line 1941 of file categorie.class.php.

◆ getListForItem()

Categorie::getListForItem	(	$id,
		$type = `'customer'`,
		$sortfield = `"s.rowid"`,
		$sortorder = `'ASC'`,
		$limit = `0`,
		$page = `0`
	)

List categories of an element id.

Parameters

int	$id	Id of element
string	$type	Type of category ('member', 'customer', 'supplier', 'product', 'contact')
string	$sortfield	Sort field
string	$sortorder	Sort order
int	$limit	Limit for list
int	$page	Page number

Returns: array|int Array of categories, 0 if no cat, -1 on error

Definition at line 935 of file categorie.class.php.

◆ getMapList()

Categorie::getMapList ( )

Get map list.

Returns: array

Definition at line 303 of file categorie.class.php.

◆ getMultiLangs()

Categorie::getMultiLangs ( )

Load array this->multilangs.

Returns: int <0 if KO, >0 if OK

Definition at line 1907 of file categorie.class.php.

◆ getNomUrl()

Categorie::getNomUrl	(	$withpicto = `0`,
		$option = `''`,
		$maxlength = `0`,
		$moreparam = `''`
	)

Return name and link of category (with picto) Use ->id, ->ref, ->label, ->color.

Parameters

int	$withpicto	0=No picto, 1=Include picto into link, 2=Only picto
string	$option	Sur quoi pointe le lien ('', 'xyz')
int	$maxlength	Max length of text
string	$moreparam	More param on URL link

Returns: string Chaine avec URL

Definition at line 1639 of file categorie.class.php.

◆ getObjectsInCateg()

Categorie::getObjectsInCateg	(	$type,
		$onlyids = `0`,
		$limit = `0`,
		$offset = `0`,
		$sortfield = `''`,
		$sortorder = `'ASC'`
	)

Return list of fetched instance of elements having this category.

Parameters

string	$type	Type of category ('customer', 'supplier', 'contact', 'product', 'member', 'knowledge_management', ...)
int	$onlyids	Return only ids of objects (consume less memory)
int	$limit	Limit
int	$offset	Offset
string	$sortfield	Sort fields
string	$sortorder	Sort order ('ASC' or 'DESC');

Returns: array|int -1 if KO, array of instance of object if OK

See also: containsObject()

Definition at line 851 of file categorie.class.php.

◆ initAsSpecimen()

Categorie::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: void

Definition at line 1954 of file categorie.class.php.

References dol_syslog().

◆ liste_photos()

Categorie::liste_photos	(	$dir,
		$nbmax = `0`
	)

Return tableau de toutes les photos de la categorie.

Parameters

string	$dir	Repertoire a scanner
int	$nbmax	Nombre maximum de photos (0=pas de max)

Returns: array Tableau de photos

Definition at line 1738 of file categorie.class.php.

◆ load_motherof()

Categorie::load_motherof ( )

protected

Load the array this->motherof that is array(id_son=>id_parent, ...)

Returns: int <0 if KO, >0 if OK

Definition at line 1061 of file categorie.class.php.

◆ print_all_ways()

Categorie::print_all_ways	(	$sep = `'>>'`,
		$url = `''`,
		$nocolor = `0`,
		$addpicto = `0`
	)

Returns the path of the category, with the names of the categories separated by $sep (" >> " by default)

Parameters

string	$sep	Separator
string	$url	Url ('', 'none' or 'urltouse')
int	$nocolor	0
string	$addpicto	Add picto into link

Returns: array

Definition at line 1384 of file categorie.class.php.

◆ rechercher()

Categorie::rechercher	(	$id,
		$nom,
		$type,
		$exact = `false`,
		$case = `false`
	)

Returns categories whose id or name match add wildcards in the name unless $exact = true.

Parameters

int	$id	Id
string	$nom	Name
string	$type	Type of category ('member', 'customer', 'supplier', 'product', 'contact'). Old mode (0, 1, 2, ...) is deprecated.
boolean	$exact	Exact string search (true/false)
boolean	$case	Case sensitive (true/false)

Returns: Categorie[]|int Array of Categorie, -1 if error

Definition at line 1579 of file categorie.class.php.

◆ replaceThirdparty()

static Categorie::replaceThirdparty	(	DoliDB	$db,
			$origin_id,
			$dest_id
	)

static

Function used to replace a thirdparty id with another one.

Parameters

DoliDB	$db	Database handler
int	$origin_id	Old thirdparty id
int	$dest_id	New thirdparty id

Returns: bool

Definition at line 1976 of file categorie.class.php.

References CommonObject\commonReplaceThirdparty().

◆ setMultiLangs()

Categorie::setMultiLangs ( $user )

Update ou cree les traductions des infos produits.

Parameters

User $user Object user

Returns: int <0 if KO, >0 if OK

Definition at line 1837 of file categorie.class.php.

◆ update()

Categorie::update ( User $user )

Update category.

Parameters

User $user Object user

Returns: int 1 : OK -1 : SQL error -2 : invalid category

Definition at line 533 of file categorie.class.php.

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

dolibarr_17.0/htdocs/categories/class/categorie.class.php

Public Member Functions

Static Public Member Functions

Protected Member Functions

Private Member Functions

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ add_photo()

◆ add_type()

◆ already_exists()

◆ buildPathFromId()

◆ containing()

◆ containsObject()

◆ countNbOfCategories()

◆ create()

◆ debug_cats()

◆ del_type()

◆ delete()

◆ delete_photo()

◆ fetch()

◆ get_all_categories()

◆ get_all_ways()

◆ get_filles()

◆ get_full_arbo()

◆ get_image_size()

◆ get_main_categories()

◆ get_meres()

◆ getFilterJoinQuery()

◆ getFilterSelectQuery()

◆ getLibStatut()

◆ getListForItem()

◆ getMapList()

◆ getMultiLangs()

◆ getNomUrl()

◆ getObjectsInCateg()

◆ initAsSpecimen()

◆ liste_photos()

◆ load_motherof()

◆ print_all_ways()

◆ rechercher()

◆ replaceThirdparty()

◆ setMultiLangs()

◆ update()