28 require
'../main.inc.php';
29 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formfile.class.php';
30 require_once DOL_DOCUMENT_ROOT.
'/core/class/notify.class.php';
31 require_once DOL_DOCUMENT_ROOT.
'/fichinter/class/fichinter.class.php';
33 if (!$user->rights->ficheinter->lire) {
40 $hookmanager->initHooks(array(
'interventionindex'));
43 $langs->load(
"interventions");
46 $socid =
GETPOST(
'socid',
'int');
47 if ($user->socid > 0) {
49 $socid = $user->socid;
62 $help_url =
"EN:ModuleFichinters|FR:Module_Fiche_Interventions|ES:Módulo_FichaInterventiones";
66 print
load_fiche_titre($langs->trans(
"InterventionsArea"),
'',
'intervention');
68 print
'<div class="fichecenter"><div class="fichethirdleft">';
74 $sql =
"SELECT count(f.rowid), f.fk_statut";
75 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s";
76 $sql .=
", ".MAIN_DB_PREFIX.
"fichinter as f";
77 if (empty($user->rights->societe->client->voir) && !$socid) {
78 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
80 $sql .=
" WHERE f.entity IN (".getEntity(
'intervention').
")";
81 $sql .=
" AND f.fk_soc = s.rowid";
83 $sql .=
' AND f.fk_soc = '.((int) $user->socid);
85 if (empty($user->rights->societe->client->voir) && !$socid) {
86 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
88 $sql .=
" GROUP BY f.fk_statut";
91 $num = $db->num_rows(
$resql);
95 $dataseries = array();
100 while ($row = $db->fetch_row(
$resql)) {
101 if (!isset($vals[$row[1]])) {
104 $vals[$row[1]] += $row[0];
105 $totalinprocess += $row[0];
111 include DOL_DOCUMENT_ROOT.
'/theme/'.$conf->theme.
'/theme_vars.inc.php';
113 print
'<div class="div-table-responsive-no-min">';
114 print
'<table class="noborder nohover centpercent">';
115 print
'<tr class="liste_titre"><th colspan="2">'.$langs->trans(
"Statistics").
' - '.$langs->trans(
"Interventions").
'</th></tr>'.
"\n";
119 foreach ($listofstatus as $status) {
120 $dataseries[] = array($fichinterstatic->LibStatut($status, 1), (isset($vals[$status]) ? (
int) $vals[$status] : 0));
123 $colorseries[$status] =
'-'.$badgeStatus0;
126 $colorseries[$status] = $badgeStatus1;
129 $colorseries[$status] = $badgeStatus4;
133 if ($conf->use_javascript_ajax) {
134 print
'<tr class="impair"><td class="center" colspan="2">';
136 include_once DOL_DOCUMENT_ROOT.
'/core/class/dolgraph.class.php';
138 $dolgraph->SetData($dataseries);
139 $dolgraph->SetDataColor(array_values($colorseries));
140 $dolgraph->setShowLegend(2);
141 $dolgraph->setShowPercent(1);
142 $dolgraph->SetType(array(
'pie'));
143 $dolgraph->setHeight(
'200');
144 $dolgraph->draw(
'idgraphstatus');
145 print $dolgraph->show($total ? 0 : 1);
149 foreach ($listofstatus as $status) {
150 if (!$conf->use_javascript_ajax) {
151 print
'<tr class="oddeven">';
152 print
'<td>'.$fichinterstatic->LibStatut($status, 0).
'</td>';
153 print
'<td class="right"><a href="list.php?search_status='.$status.
'">'.(isset($vals[$status]) ? $vals[$status] : 0).
' ';
154 print $fichinterstatic->LibStatut($status, 3);
162 print
'<tr class="liste_total"><td>'.$langs->trans(
"Total").
'</td><td class="right">'.$total.
'</td></tr>';
163 print
"</table></div><br>";
172 if (!empty($conf->ficheinter->enabled)) {
173 $sql =
"SELECT f.rowid, f.ref, s.nom as name, s.rowid as socid";
174 $sql .=
" FROM ".MAIN_DB_PREFIX.
"fichinter as f";
175 $sql .=
", ".MAIN_DB_PREFIX.
"societe as s";
176 if (empty($user->rights->societe->client->voir) && !$socid) {
177 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
179 $sql .=
" WHERE f.entity IN (".getEntity(
'intervention').
")";
180 $sql .=
" AND f.fk_soc = s.rowid";
181 $sql .=
" AND f.fk_statut = 0";
183 $sql .=
" AND f.fk_soc = ".((int) $socid);
185 if (empty($user->rights->societe->client->voir) && !$socid) {
186 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
189 $resql = $db->query($sql);
191 print
'<div class="div-table-responsive-no-min">';
192 print
'<table class="noborder centpercent">';
193 print
'<tr class="liste_titre">';
194 print
'<th colspan="2">'.$langs->trans(
"DraftFichinter").
'</th></tr>';
195 $langs->load(
"fichinter");
196 $num = $db->num_rows(
$resql);
200 $obj = $db->fetch_object(
$resql);
201 print
'<tr class="oddeven">';
202 print
'<td class="nowrap">';
203 print
"<a href=\"card.php?id=".$obj->rowid.
"\">".
img_object($langs->trans(
"ShowFichinter"),
"intervention").
' '.$obj->ref.
"</a></td>";
204 print
'<td><a href="'.DOL_URL_ROOT.
'/comm/card.php?socid='.$obj->socid.
'">'.
img_object($langs->trans(
"ShowCompany"),
"company").
' '.
dol_trunc($obj->name, 24).
'</a></td></tr>';
208 print
"</table></div><br>";
213 print
'</div><div class="fichetwothirdright">';
222 $sql =
"SELECT f.rowid, f.ref, f.fk_statut, f.date_valid as datec, f.tms as datem,";
223 $sql .=
" s.nom as name, s.rowid as socid";
224 $sql .=
" FROM ".MAIN_DB_PREFIX.
"fichinter as f,";
225 $sql .=
" ".MAIN_DB_PREFIX.
"societe as s";
226 if (empty($user->rights->societe->client->voir) && !$socid) {
227 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
229 $sql .=
" WHERE f.entity IN (".getEntity(
'intervention').
")";
230 $sql .=
" AND f.fk_soc = s.rowid";
233 $sql .=
" AND f.fk_soc = ".((int) $socid);
235 if (empty($user->rights->societe->client->voir) && !$socid) {
236 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
238 $sql .=
" ORDER BY f.tms DESC";
239 $sql .= $db->plimit($max, 0);
241 $resql = $db->query($sql);
243 print
'<div class="div-table-responsive-no-min">';
244 print
'<table class="noborder centpercent">';
245 print
'<tr class="liste_titre">';
246 print
'<th colspan="4">'.$langs->trans(
"LastModifiedInterventions", $max).
'</th></tr>';
248 $num = $db->num_rows(
$resql);
252 $obj = $db->fetch_object(
$resql);
254 print
'<tr class="oddeven">';
255 print
'<td width="20%" class="nowrap">';
257 $fichinterstatic->id = $obj->rowid;
258 $fichinterstatic->ref = $obj->ref;
260 print
'<table class="nobordernopadding"><tr class="nocellnopadd">';
261 print
'<td width="96" class="nobordernopadding nowrap">';
262 print $fichinterstatic->getNomUrl(1);
265 print
'<td width="16" class="nobordernopadding nowrap">';
269 print
'<td width="16" class="right nobordernopadding hideonsmartphone">';
272 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid;
273 print $formfile->getDocumentsLink($fichinterstatic->element, $filename, $filedir);
274 print
'</td></tr></table>';
278 print
'<td><a href="'.DOL_URL_ROOT.
'/comm/card.php?socid='.$obj->socid.
'">'.
img_object($langs->trans(
"ShowCompany"),
"company").
' '.$obj->name.
'</a></td>';
279 print
'<td>'.dol_print_date($db->jdate($obj->datem),
'day').
'</td>';
280 print
'<td class="right">'.$fichinterstatic->LibStatut($obj->fk_statut, 5).
'</td>';
285 print
"</table></div><br>";
295 if (!empty($conf->ficheinter->enabled)) {
296 $sql =
"SELECT f.rowid, f.ref, f.fk_statut, s.nom as name, s.rowid as socid";
297 $sql .=
" FROM ".MAIN_DB_PREFIX.
"fichinter as f";
298 $sql .=
", ".MAIN_DB_PREFIX.
"societe as s";
299 if (empty($user->rights->societe->client->voir) && !$socid) {
300 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
302 $sql .=
" WHERE f.entity IN (".getEntity(
'intervention').
")";
303 $sql .=
" AND f.fk_soc = s.rowid";
304 $sql .=
" AND f.fk_statut = 1";
306 $sql .=
" AND f.fk_soc = ".((int) $socid);
308 if (empty($user->rights->societe->client->voir) && !$socid) {
309 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
311 $sql .=
" ORDER BY f.rowid DESC";
313 $resql = $db->query($sql);
315 $num = $db->num_rows(
$resql);
317 print
'<div class="div-table-responsive-no-min">';
318 print
'<table class="noborder centpercent">';
319 print
'<tr class="liste_titre">';
320 print
'<th colspan="3">'.$langs->trans(
"FichinterToProcess").
' <a href="'.DOL_URL_ROOT.
'/fichinter/list.php?search_status=1"><span class="badge">'.$num.
'</span></a></th></tr>';
325 $obj = $db->fetch_object(
$resql);
326 print
'<tr class="oddeven">';
327 print
'<td class="nowrap" width="20%">';
329 $fichinterstatic->id = $obj->rowid;
330 $fichinterstatic->ref = $obj->ref;
332 print
'<table class="nobordernopadding"><tr class="nocellnopadd">';
333 print
'<td width="96" class="nobordernopadding nowrap">';
334 print $fichinterstatic->getNomUrl(1);
337 print
'<td width="16" class="nobordernopadding nowrap">';
341 print
'<td width="16" class="right nobordernopadding hideonsmartphone">';
344 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid;
345 print $formfile->getDocumentsLink($fichinterstatic->element, $filename, $filedir);
346 print
'</td></tr></table>';
350 print
'<td><a href="'.DOL_URL_ROOT.
'/comm/card.php?socid='.$obj->socid.
'">'.
img_object($langs->trans(
"ShowCompany"),
"company").
' '.
dol_trunc($obj->name, 24).
'</a></td>';
352 print
'<td class="right">'.$fichinterstatic->LibStatut($obj->fk_statut, 5).
'</td>';
359 print
"</table></div><br>";
365 print
'</div></div>';
367 $parameters = array(
'user' => $user);
368 $reshook = $hookmanager->executeHooks(
'dashboardInterventions', $parameters, $object);