Class to manage the statistics of the expensereports and expense notes. More...

Inheritance diagram for ExpenseReportStats:

Collaboration diagram for ExpenseReportStats:

Public Member Functions
	__construct ($db, $socid=0, $userid=0)
	Constructor.

	getNbByYear ()
	Return nb of expense report per year.

	getNbByMonth ($year, $format=0)
	Return the quantity of invoices per month for a given year.

	getAmountByMonth ($year, $format=0)
	Renvoie le montant de facture par mois pour une annee donnee.

	getAverageByMonth ($year)
	Return average amount.

	getAllByYear ()
	Return nb, total and average.

Public Member Functions inherited from Stats
	getNbByMonthWithPrevYear ($endyear, $startyear, $cachedelay=0, $format=0, $startmonth=1)
	Return nb of elements by month for several years.

	getAmountByMonthWithPrevYear ($endyear, $startyear, $cachedelay=0, $format=0, $startmonth=1)
	Return amount of elements by month for several years.

	getAverageByMonthWithPrevYear ($endyear, $startyear)
	Return average of entity by month for several years.

	getAllByProductEntry ($year, $cachedelay=0, $limit=10)
	Return count, and sum of products.

	getAllByProduct ($year, $limit=0)
	Return nb, amount of predefined product for year.

Additional Inherited Members
Protected Member Functions inherited from Stats
	_getNbByYear ($sql)
	Return nb of elements by year.

	_getAllByYear ($sql)
	Return nb of elements, total amount and avg amount each year.

	_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.

	_getAmountByMonth ($year, $sql, $format=0)
	Return the amount per month for a given year.

	_getAverageByMonth ($year, $sql, $format=0)
	Return the amount average par month for a given year.

	_getAllByProduct ($sql, $limit=10)
	Return number or total of product refs.

	_getAmountByYear ($sql)
	Returns the summed amounts per year for a given number of past years ending now.

Detailed Description

Class to manage the statistics of the expensereports and expense notes.

Constructor & Destructor Documentation

ExpenseReportStats::__construct	(	$db,
		$socid = 0,
		$userid = 0 )

Constructor.

Parameters

References $conf, and $object.

ExpenseReportStats::getAllByYear ( )

Return nb, total and average.

Returns: array<array{year:string,nb:string,nb_diff:float,total?:float,avg?:float,weighted?:float,total_diff?:float,avg_diff?:float,avg_weighted?:float}> Array of values

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

Renvoie le montant de facture par mois pour une annee donnee.

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

Reimplemented from Stats.

ExpenseReportStats::getAverageByMonth ( $year )

Return average amount.

Parameters

int $year Year to scan

Returns: array<int<0,11>,array{0:int<1,12>,1:int|float}> Array with number by month

Reimplemented from Stats.

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

Return the quantity of invoices per month for a given 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