dolibarr
x.y.z
|
Classe permettant la gestion des stats des expensereports et notes de frais. More...
Public Member Functions | |
__construct ($db, $socid=0, $userid=0) | |
Constructor. More... | |
getNbByYear () | |
Return nb of expense report per year. More... | |
getNbByMonth ($year, $format=0) | |
Renvoie le nombre de facture par mois pour une annee donnee. More... | |
getAmountByMonth ($year, $format=0) | |
Renvoie le montant de facture par mois pour une annee donnee. More... | |
getAverageByMonth ($year) | |
Return average amount. More... | |
getAllByYear () | |
Return nb, total and average. 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... | |
Classe permettant la gestion des stats des expensereports et notes de frais.
Definition at line 31 of file expensereportstats.class.php.
ExpenseReportStats::__construct | ( | $db, | |
$socid = 0 , |
|||
$userid = 0 |
|||
) |
ExpenseReportStats::getAllByYear | ( | ) |
Return nb, total and average.
Definition at line 172 of file expensereportstats.class.php.
ExpenseReportStats::getAmountByMonth | ( | $year, | |
$format = 0 |
|||
) |
Renvoie le montant de facture par mois pour une annee donnee.
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.
Definition at line 135 of file expensereportstats.class.php.
ExpenseReportStats::getAverageByMonth | ( | $year | ) |
Return average amount.
int | $year | Year to scan |
Reimplemented from Stats.
Definition at line 155 of file expensereportstats.class.php.
ExpenseReportStats::getNbByMonth | ( | $year, | |
$format = 0 |
|||
) |
Renvoie le nombre de facture par mois pour une annee donnee.
string | $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.
Definition at line 113 of file expensereportstats.class.php.
ExpenseReportStats::getNbByYear | ( | ) |
Return nb of expense report per year.
Definition at line 95 of file expensereportstats.class.php.