28include_once DOL_DOCUMENT_ROOT.
'/core/class/stats.class.php';
29include_once DOL_DOCUMENT_ROOT.
'/expedition/class/expedition.class.php';
30include_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
41 public $table_element;
88 $this->socid = ($socid > 0 ? $socid : 0);
89 $this->userid = $userid;
90 $this->cachefilesuffix = $mode;
93 $this->from = MAIN_DB_PREFIX.$object->table_element.
" as c";
95 $this->field =
'weight';
96 $this->where .=
" c.fk_statut > 0";
99 $this->where .=
" AND c.entity = ".$conf->entity;
100 if (!$user->hasRight(
'societe',
'client',
'voir')) {
101 $this->where .=
" AND c.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
104 $this->where .=
" AND c.fk_soc = ".((int) $this->socid);
106 if ($this->userid > 0) {
107 $this->where .=
' AND c.fk_user_author = '.((int) $this->userid);
122 $sql =
"SELECT date_format(c.date_valid,'%m') as dm, COUNT(*) as nb";
123 $sql .=
" FROM ".$this->from;
124 if (!$user->hasRight(
'societe',
'client',
'voir')) {
125 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
128 $sql .=
" AND ".$this->where;
129 $sql .=
" GROUP BY dm";
130 $sql .= $this->db->order(
'dm',
'DESC');
146 $sql =
"SELECT date_format(c.date_valid,'%Y') as dm, COUNT(*) as nb, SUM(c.".$this->field.
")";
147 $sql .=
" FROM ".$this->from;
148 if (!$user->hasRight(
'societe',
'client',
'voir')) {
149 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
151 $sql .=
" WHERE ".$this->where;
152 $sql .=
" GROUP BY dm";
153 $sql .= $this->db->order(
'dm',
'DESC');
169 $sql =
"SELECT date_format(c.date_valid,'%m') as dm, SUM(c.".$this->field.
")";
170 $sql .=
" FROM ".$this->from;
171 if (!$user->hasRight(
'societe',
'client',
'voir')) {
172 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
175 $sql .=
" WHERE ".$this->where;
176 $sql .=
" GROUP BY dm";
177 $sql .= $this->db->order(
'dm',
'DESC');
193 $sql =
"SELECT date_format(c.date_valid,'%m') as dm, AVG(c.".$this->field.
")";
194 $sql .=
" FROM ".$this->from;
195 if (!$user->hasRight(
'societe',
'client',
'voir')) {
196 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
199 $sql .=
" WHERE ".$this->where;
200 $sql .=
" GROUP BY dm";
201 $sql .= $this->db->order(
'dm',
'DESC');
215 $sql =
"SELECT date_format(c.date_valid,'%Y') as year, COUNT(*) as nb, SUM(c.".$this->field.
") as total, AVG(".$this->field.
") as avg";
216 $sql .=
" FROM ".$this->from;
217 if (!$user->hasRight(
'societe',
'client',
'voir')) {
218 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
220 $sql .=
" WHERE ".$this->where;
221 $sql .=
" GROUP BY year";
222 $sql .= $this->db->order(
'year',
'DESC');
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Class to manage shipment statistics.
getNbByMonth($year, $format=0)
Return shipment number by month for a year.
__construct($db, $socid, $mode, $userid=0)
Constructor.
getAverageByMonth($year)
Return the orders amount average by month for a year.
getAmountByMonth($year, $format=0)
Return the orders amount by month for a year.
getNbByYear()
Return shipments number per year.
getAllByYear()
Return nb, total and average.
Parent class of statistics class.
_getAverageByMonth($year, $sql, $format=0)
Return the amount average par month for a given year.
_getAmountByMonth($year, $sql, $format=0)
Return the amount per month for a given year.
_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 fo...
dol_get_first_day($year, $month=1, $gm=false)
Return GMT time for first day of a month or year.
dol_get_last_day($year, $month=12, $gm=false)
Return GMT time for last day of a month or year.
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...