|
dolibarr 18.0.8
|
Class to manage stats for invoices (customer and supplier) More...


Public Member Functions | |
| __construct (DoliDB $db, $socid, $mode, $userid=0, $typentid=0, $categid=0) | |
| Constructor. | |
| getNbByMonth ($year, $format=0) | |
| Return orders number by month for a year. | |
| getNbByYear () | |
| Return invoices number per year. | |
| getAmountByMonth ($year, $format=0) | |
| Return the invoices amount by month for a year. | |
| getAverageByMonth ($year) | |
| Return average amount. | |
| getAllByYear () | |
| Return nb, total and average. | |
| getAllByProduct ($year, $limit=10) | |
| Return nb, amount of predefined product for year. | |
| getAmountByYear ($numberYears, $format=0) | |
| Return the invoices amount by year for a number of past years. | |
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. | |
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) | |
| Renvoie le montant moyen par mois pour une annee donnee 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. | |
Class to manage stats for invoices (customer and supplier)
Definition at line 34 of file facturestats.class.php.
| FactureStats::__construct | ( | DoliDB | $db, |
| $socid, | |||
| $mode, | |||
| $userid = 0, | |||
| $typentid = 0, | |||
| $categid = 0 ) |
Constructor.
| 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 60 of file facturestats.class.php.
| FactureStats::getAllByProduct | ( | $year, | |
| $limit = 10 ) |
Return nb, amount of predefined product for year.
| int | $year | Year to scan |
| int | $limit | Limit |
Definition at line 257 of file facturestats.class.php.
References Stats\_getAllByProduct(), dol_get_first_day(), and dol_get_last_day().
| FactureStats::getAllByYear | ( | ) |
Return nb, total and average.
Definition at line 233 of file facturestats.class.php.
References Stats\_getAllByYear().
| FactureStats::getAmountByMonth | ( | $year, | |
| $format = 0 ) |
Return the invoices amount by month for a year.
| 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 184 of file facturestats.class.php.
References Stats\_getAmountByMonth(), dol_get_first_day(), and dol_get_last_day().
| FactureStats::getAmountByYear | ( | $numberYears, | |
| $format = 0 ) |
Return the invoices amount by year for a number of past years.
| int | $numberYears | Years to scan |
| int | $format | 0=Label of abscissa is a translated text, 1=Label of abscissa is year, 2=Label of abscissa is last number of year |
Definition at line 283 of file facturestats.class.php.
References Stats\_getAmountByYear(), dol_get_first_day(), and dol_get_last_day().
| FactureStats::getAverageByMonth | ( | $year | ) |
Return average amount.
| int | $year | Year to scan |
Reimplemented from Stats.
Definition at line 210 of file facturestats.class.php.
References Stats\_getAverageByMonth(), dol_get_first_day(), and dol_get_last_day().
| FactureStats::getNbByMonth | ( | $year, | |
| $format = 0 ) |
Return orders number by month for a year.
| 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 133 of file facturestats.class.php.
References Stats\_getNbByMonth(), dol_get_first_day(), and dol_get_last_day().
| FactureStats::getNbByYear | ( | ) |
Return invoices number per year.
Definition at line 159 of file facturestats.class.php.
References Stats\_getNbByYear().