dolibarr 18.0.6
|
Class to manage proposals statistics. More...
Public Member Functions | |
__construct ($db, $socid=0, $userid=0, $mode='customer', $typentid=0, $categid=0) | |
Constructor. | |
getNbByMonth ($year, $format=0) | |
Return propals number by month for a year. | |
getNbByYear () | |
Return propals number per year. | |
getAmountByMonth ($year, $format=0) | |
Return the propals amount by month for a year. | |
getAverageByMonth ($year) | |
Return the propals amount average by month for a year. | |
getAllByYear () | |
Return nb, total and average. | |
getAllByProduct ($year, $limit=10) | |
Return nb, amount of predefined product for year. | |
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 proposals statistics.
Definition at line 37 of file propalestats.class.php.
PropaleStats::__construct | ( | $db, | |
$socid = 0, | |||
$userid = 0, | |||
$mode = 'customer', | |||
$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. |
int | $userid | Id user for filter (creation user) |
string | $mode | Option ('customer', 'supplier') |
int | $typentid | Id typent of thirdpary for filter |
int | $categid | Id category of thirdpary for filter |
Definition at line 63 of file propalestats.class.php.
References getEntity().
PropaleStats::getAllByProduct | ( | $year, | |
$limit = 10 ) |
Return nb, amount of predefined product for year.
int | $year | Year to scan |
int | $limit | Limit |
Definition at line 244 of file propalestats.class.php.
References Stats\_getAllByProduct(), dol_get_first_day(), and dol_get_last_day().
PropaleStats::getAllByYear | ( | ) |
Return nb, total and average.
Definition at line 218 of file propalestats.class.php.
References Stats\_getAllByYear().
PropaleStats::getAmountByMonth | ( | $year, | |
$format = 0 ) |
Return the propals 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 170 of file propalestats.class.php.
References Stats\_getAmountByMonth(), dol_get_first_day(), and dol_get_last_day().
PropaleStats::getAverageByMonth | ( | $year | ) |
Return the propals amount average by month for a year.
int | $year | year for stats |
Reimplemented from Stats.
Definition at line 195 of file propalestats.class.php.
References Stats\_getAverageByMonth(), dol_get_first_day(), and dol_get_last_day().
PropaleStats::getNbByMonth | ( | $year, | |
$format = 0 ) |
Return propals 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 121 of file propalestats.class.php.
References Stats\_getNbByMonth(), dol_get_first_day(), and dol_get_last_day().
PropaleStats::getNbByYear | ( | ) |
Return propals number per year.
Definition at line 146 of file propalestats.class.php.
References Stats\_getNbByYear().