26 require
'../../main.inc.php';
27 require_once DOL_DOCUMENT_ROOT.
'/compta/tva/class/tva.class.php';
28 require_once DOL_DOCUMENT_ROOT.
'/compta/deplacement/class/deplacement.class.php';
31 $langs->loadLangs(array(
'companies',
'users',
'trips'));
34 $socid =
GETPOST(
'socid',
'int');
36 $socid = $user->socid;
40 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
41 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
42 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
44 if (empty($page) || $page == -1) {
47 $offset = $limit * $page;
48 $pageprev = $page - 1;
49 $pagenext = $page + 1;
54 $sortfield =
"d.dated";
56 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
65 $childids = $user->getAllChildIds();
66 $childids[] = $user->id;
75 $sql =
"SELECT count(d.rowid) as nb, sum(d.km) as km, d.type";
76 $sql .=
" FROM ".MAIN_DB_PREFIX.
"deplacement as d";
77 $sql .=
" WHERE d.entity = ".$conf->entity;
78 if (empty($user->rights->deplacement->readall) && empty($user->rights->deplacement->lire_tous)) {
79 $sql .=
' AND d.fk_user IN ('.$db->sanitize(join(
',', $childids)).
')';
81 $sql .=
" GROUP BY d.type";
82 $sql .=
" ORDER BY d.type";
84 $result = $db->query($sql);
86 $num = $db->num_rows($result);
89 $objp = $db->fetch_object($result);
91 $somme[$objp->type] = $objp->km;
92 $nb[$objp->type] = $objp->nb;
93 $totalnb += $objp->nb;
105 print
'<div class="fichecenter"><div class="fichethirdleft">';
109 print
'<table class="noborder nohover centpercent">';
110 print
'<tr class="liste_titre">';
111 print
'<td colspan="4">'.$langs->trans(
"Statistics").
'</td>';
114 $listoftype = $tripandexpense_static->listOfTypes();
115 foreach ($listoftype as $code => $label) {
116 $dataseries[] = array($label, (isset($nb[$code]) ? (
int) $nb[$code] : 0));
119 if ($conf->use_javascript_ajax) {
120 print
'<tr><td align="center" colspan="4">';
122 include_once DOL_DOCUMENT_ROOT.
'/core/class/dolgraph.class.php';
124 $dolgraph->SetData($dataseries);
125 $dolgraph->setShowLegend(2);
126 $dolgraph->setShowPercent(1);
127 $dolgraph->SetType(array(
'pie'));
128 $dolgraph->setHeight(
'200');
129 $dolgraph->draw(
'idgraphstatus');
130 print $dolgraph->show($totalnb ? 0 : 1);
135 print
'<tr class="liste_total">';
136 print
'<td>'.$langs->trans(
"Total").
'</td>';
137 print
'<td class="right">'.$totalnb.
'</td>';
144 print
'</div><div class="fichetwothirdright">';
149 $langs->load(
"boxes");
151 $sql =
"SELECT u.rowid as uid, u.lastname, u.firstname, d.rowid, d.dated as date, d.tms as dm, d.km, d.fk_statut";
152 $sql .=
" FROM ".MAIN_DB_PREFIX.
"deplacement as d, ".MAIN_DB_PREFIX.
"user as u";
153 if (empty($user->rights->societe->client->voir) && !$user->socid) {
154 $sql .=
", ".MAIN_DB_PREFIX.
"societe as s, ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
156 $sql .=
" WHERE u.rowid = d.fk_user";
157 $sql .=
" AND d.entity = ".$conf->entity;
158 if (empty($user->rights->deplacement->readall) && empty($user->rights->deplacement->lire_tous)) {
159 $sql .=
' AND d.fk_user IN ('.$db->sanitize(join(
',', $childids)).
')';
161 if (empty($user->rights->societe->client->voir) && !$user->socid) {
162 $sql .=
" AND d.fk_soc = s. rowid AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
165 $sql .=
" AND d.fk_soc = ".((int) $socid);
167 $sql .= $db->order(
"d.tms",
"DESC");
168 $sql .= $db->plimit($max, 0);
170 $result = $db->query($sql);
173 $num = $db->num_rows($result);
177 print
'<table class="noborder centpercent">';
178 print
'<tr class="liste_titre">';
179 print
'<td colspan="2">'.$langs->trans(
"BoxTitleLastModifiedExpenses", min($max, $num)).
'</td>';
180 print
'<td class="right">'.$langs->trans(
"FeesKilometersOrAmout").
'</td>';
181 print
'<td class="right">'.$langs->trans(
"DateModificationShort").
'</td>';
182 print
'<td width="16"> </td>';
185 $total_ttc = $totalam = $total = 0;
188 $userstatic =
new User($db);
189 while ($i < $num && $i < $max) {
190 $obj = $db->fetch_object($result);
191 $deplacementstatic->ref = $obj->rowid;
192 $deplacementstatic->id = $obj->rowid;
193 $userstatic->id = $obj->uid;
194 $userstatic->lastname = $obj->lastname;
195 $userstatic->firstname = $obj->firstname;
196 print
'<tr class="oddeven">';
197 print
'<td>'.$deplacementstatic->getNomUrl(1).
'</td>';
198 print
'<td>'.$userstatic->getNomUrl(1).
'</td>';
199 print
'<td class="right">'.$obj->km.
'</td>';
200 print
'<td class="right">'.dol_print_date($db->jdate($obj->dm),
'day').
'</td>';
201 print
'<td>'.$deplacementstatic->LibStatut($obj->fk_statut, 3).
'</td>';
207 print
'<tr class="oddeven"><td colspan="2" class="opacitymedium">'.$langs->trans(
"None").
'</td></tr>';
209 print
'</table><br>';
215 print
'</div></div>';