29require
'../main.inc.php';
30require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formfile.class.php';
31require_once DOL_DOCUMENT_ROOT.
'/core/class/notify.class.php';
32require_once DOL_DOCUMENT_ROOT.
'/fichinter/class/fichinter.class.php';
34if (!$user->hasRight(
'ficheinter',
'lire')) {
41$hookmanager->initHooks(array(
'interventionindex'));
44$langs->load(
"interventions");
48if ($user->socid > 0) {
50 $socid = $user->socid;
64$help_url =
"EN:ModuleFichinters|FR:Module_Fiche_Interventions|ES:Módulo_FichaInterventiones";
66llxHeader(
"", $langs->trans(
"Interventions"), $help_url);
68print
load_fiche_titre($langs->trans(
"InterventionsArea"),
'',
'intervention');
70print
'<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";
77if (!$user->hasRight(
'societe',
'client',
'voir')) {
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);
85if (!$user->hasRight(
'societe',
'client',
'voir')) {
86 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
88$sql .=
" GROUP BY f.fk_statut";
89$resql = $db->query($sql);
91 $num = $db->num_rows($resql);
95 $dataseries = array();
96 $colorseries = array();
101 while ($row = $db->fetch_row($resql)) {
102 if (!isset($vals[$row[1]])) {
105 $vals[$row[1]] += $row[0];
106 $totalinprocess += $row[0];
112 include DOL_DOCUMENT_ROOT.
'/theme/'.$conf->theme.
'/theme_vars.inc.php';
114 print
'<div class="div-table-responsive-no-min">';
115 print
'<table class="noborder nohover centpercent">';
116 print
'<tr class="liste_titre"><th colspan="2">'.$langs->trans(
"Statistics").
' - '.$langs->trans(
"Interventions").
'</th></tr>'.
"\n";
122 foreach ($listofstatus as $status) {
123 $dataseries[] = array($fichinterstatic->LibStatut($status, 1), (isset($vals[$status]) ? (
int) $vals[$status] : 0));
126 $colorseries[$status] =
'-'.$badgeStatus0;
129 $colorseries[$status] = $badgeStatus1;
132 $colorseries[$status] = $badgeStatus4;
136 if ($conf->use_javascript_ajax) {
137 print
'<tr class="impair"><td class="center" colspan="2">';
139 include_once DOL_DOCUMENT_ROOT.
'/core/class/dolgraph.class.php';
141 $dolgraph->SetData($dataseries);
142 $dolgraph->SetDataColor(array_values($colorseries));
143 $dolgraph->setShowLegend(2);
144 $dolgraph->setShowPercent(1);
145 $dolgraph->SetType(array(
'pie'));
146 $dolgraph->setHeight(
'200');
147 $dolgraph->draw(
'idgraphstatus');
148 print $dolgraph->show($total ? 0 : 1);
152 foreach ($listofstatus as $status) {
153 if (!$conf->use_javascript_ajax) {
154 print
'<tr class="oddeven">';
155 print
'<td>'.$fichinterstatic->LibStatut($status, 0).
'</td>';
156 print
'<td class="right"><a href="list.php?search_status='.$status.
'">'.(isset($vals[$status]) ? $vals[$status] : 0).
' ';
157 print $fichinterstatic->LibStatut($status, 3);
165 print
'<tr class="liste_total"><td>'.$langs->trans(
"Total").
'</td><td class="right">'.$total.
'</td></tr>';
166 print
"</table></div><br>";
175if (isModEnabled(
'intervention')) {
176 $sql =
"SELECT f.rowid, f.ref, s.nom as name, s.rowid as socid";
177 $sql .=
" FROM ".MAIN_DB_PREFIX.
"fichinter as f";
178 $sql .=
", ".MAIN_DB_PREFIX.
"societe as s";
179 if (!$user->hasRight(
'societe',
'client',
'voir')) {
180 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
182 $sql .=
" WHERE f.entity IN (".getEntity(
'intervention').
")";
183 $sql .=
" AND f.fk_soc = s.rowid";
184 $sql .=
" AND f.fk_statut = 0";
186 $sql .=
" AND f.fk_soc = ".((int) $socid);
188 if (!$user->hasRight(
'societe',
'client',
'voir')) {
189 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
192 $resql = $db->query($sql);
194 print
'<div class="div-table-responsive-no-min">';
195 print
'<table class="noborder centpercent">';
196 print
'<tr class="liste_titre">';
197 print
'<th colspan="2">'.$langs->trans(
"DraftFichinter").
'</th></tr>';
198 $langs->load(
"fichinter");
199 $num = $db->num_rows($resql);
203 $obj = $db->fetch_object($resql);
204 print
'<tr class="oddeven">';
205 print
'<td class="nowrap">';
206 print
"<a href=\"card.php?id=".$obj->rowid.
"\">".
img_object($langs->trans(
"ShowFichinter"),
"intervention").
' '.$obj->ref.
"</a></td>";
207 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>';
211 print
"</table></div><br>";
216print
'</div><div class="fichetwothirdright">';
223$sql =
"SELECT f.rowid, f.ref, f.fk_statut, f.date_valid as datec, f.tms as datem,";
224$sql .=
" s.nom as name, s.rowid as socid";
225$sql .=
" FROM ".MAIN_DB_PREFIX.
"fichinter as f,";
226$sql .=
" ".MAIN_DB_PREFIX.
"societe as s";
227if (!$user->hasRight(
'societe',
'client',
'voir')) {
228 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
230$sql .=
" WHERE f.entity IN (".getEntity(
'intervention').
")";
231$sql .=
" AND f.fk_soc = s.rowid";
234 $sql .=
" AND f.fk_soc = ".((int) $socid);
236if (!$user->hasRight(
'societe',
'client',
'voir')) {
237 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
239$sql .=
" ORDER BY f.tms DESC";
240$sql .= $db->plimit($max, 0);
242$resql = $db->query($sql);
244 print
'<div class="div-table-responsive-no-min">';
245 print
'<table class="noborder centpercent">';
246 print
'<tr class="liste_titre">';
247 print
'<th colspan="4">'.$langs->trans(
"LastModifiedInterventions", $max).
'</th></tr>';
249 $num = $db->num_rows($resql);
253 $obj = $db->fetch_object($resql);
255 print
'<tr class="oddeven">';
256 print
'<td width="20%" class="nowrap">';
258 $fichinterstatic->id = $obj->rowid;
259 $fichinterstatic->ref = $obj->ref;
261 print
'<table class="nobordernopadding"><tr class="nocellnopadd">';
262 print
'<td width="96" class="nobordernopadding nowrap">';
263 print $fichinterstatic->getNomUrl(1);
266 print
'<td width="16" class="nobordernopadding nowrap">';
270 print
'<td width="16" class="right nobordernopadding hideonsmartphone">';
273 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid;
274 print $formfile->getDocumentsLink($fichinterstatic->element, $filename, $filedir);
275 print
'</td></tr></table>';
279 print
'<td><a href="'.DOL_URL_ROOT.
'/comm/card.php?socid='.$obj->socid.
'">'.
img_object($langs->trans(
"ShowCompany"),
"company").
' '.$obj->name.
'</a></td>';
280 print
'<td>'.dol_print_date($db->jdate($obj->datem),
'day').
'</td>';
281 print
'<td class="right">'.$fichinterstatic->LibStatut($obj->fk_statut, 5).
'</td>';
286 print
"</table></div><br>";
296if (isModEnabled(
'intervention')) {
297 $sql =
"SELECT f.rowid, f.ref, f.fk_statut, s.nom as name, s.rowid as socid";
298 $sql .=
" FROM ".MAIN_DB_PREFIX.
"fichinter as f";
299 $sql .=
", ".MAIN_DB_PREFIX.
"societe as s";
300 if (!$user->hasRight(
'societe',
'client',
'voir')) {
301 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
303 $sql .=
" WHERE f.entity IN (".getEntity(
'intervention').
")";
304 $sql .=
" AND f.fk_soc = s.rowid";
305 $sql .=
" AND f.fk_statut = 1";
307 $sql .=
" AND f.fk_soc = ".((int) $socid);
309 if (!$user->hasRight(
'societe',
'client',
'voir')) {
310 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
312 $sql .=
" ORDER BY f.rowid DESC";
314 $resql = $db->query($sql);
316 $num = $db->num_rows($resql);
318 print
'<div class="div-table-responsive-no-min">';
319 print
'<table class="noborder centpercent">';
320 print
'<tr class="liste_titre">';
321 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>';
326 $obj = $db->fetch_object($resql);
327 print
'<tr class="oddeven">';
328 print
'<td class="nowrap" width="20%">';
330 $fichinterstatic->id = $obj->rowid;
331 $fichinterstatic->ref = $obj->ref;
333 print
'<table class="nobordernopadding"><tr class="nocellnopadd">';
334 print
'<td width="96" class="nobordernopadding nowrap">';
335 print $fichinterstatic->getNomUrl(1);
338 print
'<td width="16" class="nobordernopadding nowrap">';
342 print
'<td width="16" class="right nobordernopadding hideonsmartphone">';
345 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid;
346 print $formfile->getDocumentsLink($fichinterstatic->element, $filename, $filedir);
347 print
'</td></tr></table>';
351 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>';
353 print
'<td class="right">'.$fichinterstatic->LibStatut($obj->fk_statut, 5).
'</td>';
360 print
"</table></div><br>";
368$parameters = array(
'user' => $user);
369$reshook = $hookmanager->executeHooks(
'dashboardInterventions', $parameters, $object);
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader()
Empty header.
Class to manage interventions.
const STATUS_BILLED
Billed.
const STATUS_DRAFT
Draft status.
const STATUS_VALIDATED
Validated status.
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_trunc($string, $size=40, $trunc='right', $stringencoding='UTF-8', $nodot=0, $display=0)
Truncate a string to a particular length adding '…' if string larger than length.
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.