CommandeStats Class Reference

Class to manage order statistics (customer and supplier) More...

Inheritance diagram for CommandeStats:

Collaboration diagram for CommandeStats:

Public Member Functions
	__construct ($db, $socid, $mode, $userid=0, $typentid=0, $categid=0)
	Constructor. More...
	getNbByMonth ($year, $format=0)
	Return orders number by month for a year. More...
	getNbByYear ()
	Return orders number per year. More...
	getAmountByMonth ($year, $format=0)
	Return the orders amount by month for a year. More...
	getAverageByMonth ($year)
	Return the orders amount average by month for a year. More...
	getAllByYear ()
	Return nb, total and average. More...
	getAllByProduct ($year, $limit=10)
	Return nb, amount of predefined product for year. More...
Public Member Functions inherited from Stats
	getNbByMonthWithPrevYear ($endyear, $startyear, $cachedelay=0, $format=0, $startmonth=1)
	Return nb of elements by month for several years. More...
	getAmountByMonthWithPrevYear ($endyear, $startyear, $cachedelay=0, $format=0, $startmonth=1)
	Return amount of elements by month for several years. More...
	getAverageByMonthWithPrevYear ($endyear, $startyear)
	Return average of entity by month for several years. More...
	getAllByProductEntry ($year, $cachedelay=0, $limit=10)
	Return count, and sum of products. More...

Additional Inherited Members
Protected Member Functions inherited from Stats
	_getNbByYear ($sql)
	Return nb of elements by year. More...
	_getAllByYear ($sql)
	Return nb of elements, total amount and avg amount each year. More...
	_getNbByMonth ($year, $sql, $format=0)
	Renvoie le nombre de documents par mois pour une annee donnee Return number of documents per month for a given year. More...
	_getAmountByMonth ($year, $sql, $format=0)
	Return the amount per month for a given year. More...
	_getAverageByMonth ($year, $sql, $format=0)
	Renvoie le montant moyen par mois pour une annee donnee Return the amount average par month for a given year. More...
	_getAllByProduct ($sql, $limit=10)
	Return number or total of product refs. More...
	_getAmountByYear ($sql)
	Returns the summed amounts per year for a given number of past years ending now. More...

Detailed Description

Class to manage order statistics (customer and supplier)

Definition at line 36 of file commandestats.class.php.

Constructor & Destructor Documentation

__construct()

CommandeStats::__construct	(		$db,
			$socid,
			$mode,
			$userid = 0,
			$typentid = 0,
			$categid = 0
	)

Constructor.

Parameters

DoliDB	$db	Database handler
int	$socid	Id third party for filter. This value must be forced during the new to external user company if user is an external user.
string	$mode	Option ('customer', 'supplier')
int	$userid	Id user for filter (creation user)
int	$typentid	Id typent of thirdpary for filter
int	$categid	Id category of thirdpary for filter

Definition at line 65 of file commandestats.class.php.

Member Function Documentation

getAllByProduct()

CommandeStats::getAllByProduct	(		$year,
			$limit = 10
	)

Return nb, amount of predefined product for year.

Parameters

int	$year	Year to scan
int	$limit	Limit

Returns

array Array of values

Definition at line 241 of file commandestats.class.php.

getAllByYear()

CommandeStats::getAllByYear

(

)

Return nb, total and average.

Returns

array Array of values

Definition at line 217 of file commandestats.class.php.

getAmountByMonth()

CommandeStats::getAmountByMonth	(		$year,
			$format = 0
	)

Return the orders amount by month for a year.

Parameters

int	$year	Year to scan
int	$format	0=Label of abscissa is a translated text, 1=Label of abscissa is month number, 2=Label of abscissa is first letter of month

Returns

array Array with amount by month

Reimplemented from Stats.

Definition at line 169 of file commandestats.class.php.

getAverageByMonth()

CommandeStats::getAverageByMonth

(

$year

)

Return the orders amount average by month for a year.

Parameters

int

$year

year for stats

Returns

array array with number by month

Reimplemented from Stats.

Definition at line 194 of file commandestats.class.php.

getNbByMonth()

CommandeStats::getNbByMonth	(		$year,
			$format = 0
	)

Return orders number by month for a year.

Parameters

int	$year	Year to scan
int	$format	0=Label of abscissa is a translated text, 1=Label of abscissa is month number, 2=Label of abscissa is first letter of month

Returns

array Array with number by month

Reimplemented from Stats.

Definition at line 120 of file commandestats.class.php.

getNbByYear()

CommandeStats::getNbByYear

(

)

Return orders number per year.

Returns

array Array with number by year

Definition at line 145 of file commandestats.class.php.

---

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

• htdocs/commande/class/commandestats.class.php