dolibarr 20.0.0
|
Class to manage statistics on projects. More...
Public Member Functions | |
__construct ($db) | |
Constructor. | |
getAllProjectByStatus ($limit=5) | |
Return all leads grouped by opportunity status. | |
getAllByYear () | |
Return count, and sum of products. | |
buildWhere () | |
Build the where part. | |
getNbByMonth ($year, $format=0) | |
Return Project number by month for a year. | |
getAmountByMonth ($year, $format=0) | |
Return the Project amount by month for a year. | |
getWeightedAmountByMonthWithPrevYear ($endyear, $startyear, $cachedelay=0, $wonlostfilter=1) | |
Return amount of elements by month for several years. | |
getWeightedAmountByMonth ($year, $wonlostfilter=1) | |
Return the Project weighted opp amount by month for a year. | |
getTransformRateByMonthWithPrevYear ($endyear, $startyear, $cachedelay=0) | |
Return amount of elements by month for several years. | |
getTransformRateByMonth ($year, $format=0) | |
Return the Project transformation rate by month for a 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. | |
Protected Member Functions | |
getAverageByMonth ($year) | |
Return average of entity by month. | |
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. | |
Class to manage statistics on projects.
Definition at line 26 of file projectstats.class.php.
ProjectStats::__construct | ( | $db | ) |
Constructor.
Definition at line 45 of file projectstats.class.php.
ProjectStats::buildWhere | ( | ) |
Build the where part.
Definition at line 171 of file projectstats.class.php.
References $object, dol_get_first_day(), dol_get_last_day(), and status.
Referenced by getAllByYear(), getAllProjectByStatus(), getAmountByMonth(), getNbByMonth(), getTransformRateByMonth(), and getWeightedAmountByMonth().
ProjectStats::getAllByYear | ( | ) |
Return count, and sum of products.
Definition at line 140 of file projectstats.class.php.
References Stats\_getAllByYear(), and buildWhere().
ProjectStats::getAllProjectByStatus | ( | $limit = 5 | ) |
Return all leads grouped by opportunity status.
Warning: There is no filter on WON/LOST because we want this for statistics.
int | $limit | Limit results |
Exception |
Definition at line 76 of file projectstats.class.php.
References buildWhere(), dol_syslog(), price(), and price2num().
ProjectStats::getAmountByMonth | ( | $year, | |
$format = 0 ) |
Return the Project 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 267 of file projectstats.class.php.
References Stats\_getAmountByMonth(), and buildWhere().
|
protected |
Return average of entity by month.
int | $year | year number |
Reimplemented from Stats.
Definition at line 538 of file projectstats.class.php.
References Stats\_getAverageByMonth(), dol_get_first_day(), and dol_get_last_day().
ProjectStats::getNbByMonth | ( | $year, | |
$format = 0 ) |
Return Project 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 242 of file projectstats.class.php.
References Stats\_getNbByMonth(), and buildWhere().
ProjectStats::getTransformRateByMonth | ( | $year, | |
$format = 0 ) |
Return the Project transformation rate 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 |
Definition at line 489 of file projectstats.class.php.
References Stats\_getNbByMonth(), buildWhere(), and status.
Referenced by getTransformRateByMonthWithPrevYear().
ProjectStats::getTransformRateByMonthWithPrevYear | ( | $endyear, | |
$startyear, | |||
$cachedelay = 0 ) |
Return amount of elements by month for several years.
int | $endyear | End year |
int | $startyear | Start year |
int | $cachedelay | accept for cache file (0=No read, no save of cache, -1=No read but save) |
Definition at line 406 of file projectstats.class.php.
References dol_filemtime(), dol_is_dir(), dol_mkdir(), dol_now(), dol_syslog(), dolChmod(), and getTransformRateByMonth().
ProjectStats::getWeightedAmountByMonth | ( | $year, | |
$wonlostfilter = 1 ) |
Return the Project weighted opp amount by month for a year.
int | $year | Year to scan |
int | $wonlostfilter | Add a filter on status won/lost |
Definition at line 380 of file projectstats.class.php.
References Stats\_getAmountByMonth(), and buildWhere().
Referenced by getWeightedAmountByMonthWithPrevYear().
ProjectStats::getWeightedAmountByMonthWithPrevYear | ( | $endyear, | |
$startyear, | |||
$cachedelay = 0, | |||
$wonlostfilter = 1 ) |
Return amount of elements by month for several years.
int | $endyear | Start year |
int | $startyear | End year |
int | $cachedelay | Delay we accept for cache file (0=No read, no save of cache, -1=No read but save) |
int | $wonlostfilter | Add a filter on status won/lost |
Definition at line 295 of file projectstats.class.php.
References dol_filemtime(), dol_is_dir(), dol_mkdir(), dol_now(), dol_syslog(), dolChmod(), and getWeightedAmountByMonth().