dolibarr  9.0.0
Public Member Functions | List of all members
TaskStats Class Reference

Class to manage statistics on project tasks. More...

+ Inheritance diagram for TaskStats:
+ Collaboration diagram for TaskStats:

Public Member Functions

 __construct ($db)
 Constructor of the class. More...
 
 getAllTaskByStatus ($limit=5)
 Return all tasks grouped by status. More...
 
 getAllByYear ()
 Return count, and sum of products. More...
 
 buildWhere ()
 Build the where part. More...
 
 getNbByMonth ($year, $format=0)
 Return Task number by month for a year. More...
 
- Public Member Functions inherited from Stats
 getNbByMonthWithPrevYear ($endyear, $startyear, $cachedelay=0, $format=0)
 Return nb of elements by month for several years. More...
 
 getAmountByMonthWithPrevYear ($endyear, $startyear, $cachedelay=0, $format=0)
 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)
 Return count, and sum of products. More...
 
 _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 proposition par mois pour une annee donnee. More...
 
 _getAmountByMonth ($year, $sql, $format=0)
 Renvoie le nombre d'element par mois pour une annee donnee. More...
 
 _getAverageByMonth ($year, $sql, $format=0)
 Renvoie le montant moyen par mois pour une annee donnee. More...
 
 _getAllByProduct ($sql, $limit=10)
 Return number or total of product refs. More...
 

Detailed Description

Class to manage statistics on project tasks.

Definition at line 25 of file taskstats.class.php.

Constructor & Destructor Documentation

◆ __construct()

TaskStats::__construct (   $db)

Constructor of the class.

Parameters
DoliDb$dbDatabase handler

Definition at line 37 of file taskstats.class.php.

Member Function Documentation

◆ buildWhere()

TaskStats::buildWhere ( )

Build the where part.

Returns
string

Definition at line 135 of file taskstats.class.php.

◆ getAllByYear()

TaskStats::getAllByYear ( )

Return count, and sum of products.

Returns
array of values

Definition at line 110 of file taskstats.class.php.

◆ getAllTaskByStatus()

TaskStats::getAllTaskByStatus (   $limit = 5)

Return all tasks grouped by status.

Parameters
int$limitLimit results
Returns
array|int Array with value or -1 if error
Exceptions
Exception

Definition at line 53 of file taskstats.class.php.

◆ getNbByMonth()

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

Return Task number by month for a year.

Parameters
int$yearYear to scan
int$format0=Label of absiss is a translated text, 1=Label of absiss is month number, 2=Label of absiss is first letter of month
Returns
array Array of values

Definition at line 169 of file taskstats.class.php.


The documentation for this class was generated from the following file: