25 require
'../main.inc.php';
26 require_once DOL_DOCUMENT_ROOT.
'/ticket/class/actions_ticket.class.php';
27 require_once DOL_DOCUMENT_ROOT.
'/ticket/class/ticketstats.class.php';
28 require_once DOL_DOCUMENT_ROOT.
'/core/class/dolgraph.class.php';
29 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
30 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formother.class.php';
35 $hookmanager->initHooks(array(
'ticketsindex'));
38 $langs->loadLangs(array(
'companies',
'other',
'ticket'));
45 $msg_id =
GETPOST(
'msg_id',
'int');
47 $action =
GETPOST(
'action',
'aZ09');
51 $socid = $user->socid;
56 $nowyear = $nowarray[
'year'];
57 $year =
GETPOST(
'year',
'int') > 0 ?
GETPOST(
'year',
'int') : $nowyear;
58 $startyear = $year - (empty($conf->global->MAIN_STATS_GRAPHS_SHOW_N_YEARS) ? 2 : max(1, min(10, $conf->global->MAIN_STATS_GRAPHS_SHOW_N_YEARS)));
65 if (empty($user->rights->ticket->read) && empty($user->rights->knowledgemanagement->knowledgerecord->read)) {
84 llxHeader(
'', $langs->trans(
'TicketsIndex'),
'');
87 print
load_fiche_titre($langs->trans(
'TicketsIndex'), $resultboxes[
'selectboxlist'],
'ticket');
91 $filenamenb = $dir.
"/".$prefix.
"ticketinyear-".$endyear.
".png";
92 $fileurlnb = DOL_URL_ROOT.
'/viewimage.php?modulepart=ticket&file=ticketinyear-'.$endyear.
'.png';
95 $param_year =
'DOLUSERCOOKIE_ticket_by_status_year';
96 $param_shownb =
'DOLUSERCOOKIE_ticket_by_status_shownb';
97 $param_showtot =
'DOLUSERCOOKIE_ticket_by_status_showtot';
98 $autosetarray = preg_split(
"/[,;:]+/",
GETPOST(
'DOL_AUTOSET_COOKIE'));
99 if (in_array(
'DOLUSERCOOKIE_ticket_by_status', $autosetarray)) {
100 $endyear =
GETPOST($param_year,
'int');
101 $shownb =
GETPOST($param_shownb,
'alpha');
102 $showtot =
GETPOST($param_showtot,
'alpha');
103 } elseif (!empty($_COOKIE[
'DOLUSERCOOKIE_ticket_by_status'])) {
104 $tmparray = json_decode($_COOKIE[
'DOLUSERCOOKIE_ticket_by_status'],
true);
105 $endyear = $tmparray[
'year'];
106 $shownb = $tmparray[
'shownb'];
107 $showtot = $tmparray[
'showtot'];
109 if (empty($shownb) && empty($showtot)) {
114 if (empty($endyear)) {
115 $endyear = $nowarray[
'year'];
118 $startyear = $endyear - 1;
121 $WIDTH = (($shownb && $showtot) || !empty($conf->dol_optimize_smallscreen)) ?
'100%' :
'80%';
122 if (empty($conf->dol_optimize_smallscreen)) {
128 print
'<div class="clearboth"></div>';
129 print
'<div class="fichecenter fichecenterbis">';
131 print
'<div class="twocolumns">';
133 print
'<div class="firstcolumn fichehalfleft boxhalfleft" id="boxhalfleft">';
151 $sql =
"SELECT t.fk_statut, COUNT(t.fk_statut) as nb";
152 $sql .=
" FROM ".MAIN_DB_PREFIX.
"ticket as t";
153 if (empty($user->rights->societe->client->voir) && !$socid) {
154 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
156 $sql .=
' WHERE t.entity IN ('.getEntity(
'ticket').
')';
159 if (empty($user->rights->societe->client->voir) && !$socid) {
160 $sql .=
" AND t.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
164 if ($user->socid > 0) {
165 $sql .=
" AND t.fk_soc= ".((int) $user->socid);
168 if (!empty($conf->global->TICKET_LIMIT_VIEW_ASSIGNED_ONLY) && !$user->rights->ticket->manage) {
169 $sql .=
" AND t.fk_user_assign = ".((int) $user->id);
172 $sql .=
" GROUP BY t.fk_statut";
174 $result = $db->query($sql);
176 while ($objp = $db->fetch_object($result)) {
179 $tick[
'unread'] = $objp->nb;
181 if ($objp->fk_statut == Ticket::STATUS_READ) {
182 $tick[
'read'] = $objp->nb;
184 if ($objp->fk_statut == Ticket::STATUS_NEED_MORE_INFO) {
185 $tick[
'needmoreinfo'] = $objp->nb;
187 if ($objp->fk_statut == Ticket::STATUS_ASSIGNED) {
188 $tick[
'assigned'] = $objp->nb;
190 if ($objp->fk_statut == Ticket::STATUS_IN_PROGRESS) {
191 $tick[
'inprogress'] = $objp->nb;
193 if ($objp->fk_statut == Ticket::STATUS_WAITING) {
194 $tick[
'waiting'] = $objp->nb;
196 if ($objp->fk_statut == Ticket::STATUS_CLOSED) {
197 $tick[
'closed'] = $objp->nb;
199 if ($objp->fk_statut == Ticket::STATUS_CANCELED) {
200 $tick[
'canceled'] = $objp->nb;
204 include DOL_DOCUMENT_ROOT.
'/theme/'.$conf->theme.
'/theme_vars.inc.php';
206 $dataseries = array();
207 $colorseries = array();
209 $dataseries[] = array(
'label' => $langs->transnoentitiesnoconv($object->statuts_short[
Ticket::STATUS_NOT_READ]),
'data' => round($tick[
'unread']));
211 $dataseries[] = array(
'label' => $langs->transnoentitiesnoconv($object->statuts_short[Ticket::STATUS_READ]),
'data' => round($tick[
'read']));
212 $colorseries[Ticket::STATUS_READ] = $badgeStatus1;
213 $dataseries[] = array(
'label' => $langs->transnoentitiesnoconv($object->statuts_short[Ticket::STATUS_ASSIGNED]),
'data' => round($tick[
'assigned']));
214 $colorseries[Ticket::STATUS_ASSIGNED] = $badgeStatus3;
215 $dataseries[] = array(
'label' => $langs->transnoentitiesnoconv($object->statuts_short[Ticket::STATUS_IN_PROGRESS]),
'data' => round($tick[
'inprogress']));
216 $colorseries[Ticket::STATUS_IN_PROGRESS] = $badgeStatus4;
217 $dataseries[] = array(
'label' => $langs->transnoentitiesnoconv($object->statuts_short[Ticket::STATUS_WAITING]),
'data' => round($tick[
'waiting']));
218 $colorseries[Ticket::STATUS_WAITING] =
'-'.$badgeStatus4;
219 $dataseries[] = array(
'label' => $langs->transnoentitiesnoconv($object->statuts_short[Ticket::STATUS_NEED_MORE_INFO]),
'data' => round($tick[
'needmoreinfo']));
220 $colorseries[Ticket::STATUS_NEED_MORE_INFO] =
'-'.$badgeStatus3;
221 $dataseries[] = array(
'label' => $langs->transnoentitiesnoconv($object->statuts_short[Ticket::STATUS_CANCELED]),
'data' => round($tick[
'canceled']));
222 $colorseries[Ticket::STATUS_CANCELED] = $badgeStatus9;
223 $dataseries[] = array(
'label' => $langs->transnoentitiesnoconv($object->statuts_short[Ticket::STATUS_CLOSED]),
'data' => round($tick[
'closed']));
224 $colorseries[Ticket::STATUS_CLOSED] = $badgeStatus6;
229 $stringtoshow =
'<script type="text/javascript">
230 jQuery(document).ready(function() {
231 jQuery("#idsubimgDOLUSERCOOKIE_ticket_by_status").click(function() {
232 jQuery("#idfilterDOLUSERCOOKIE_ticket_by_status").toggle();
236 $stringtoshow .=
'<div class="center hideobject" id="idfilterDOLUSERCOOKIE_ticket_by_status">';
237 $stringtoshow .=
'<form class="flat formboxfilter" method="POST" action="'.$_SERVER[
"PHP_SELF"].
'">';
238 $stringtoshow .=
'<input type="hidden" name="token" value="'.newToken().
'">';
239 $stringtoshow .=
'<input type="hidden" name="action" value="refresh">';
240 $stringtoshow .=
'<input type="hidden" name="DOL_AUTOSET_COOKIE" value="DOLUSERCOOKIE_ticket_by_status:year,shownb,showtot">';
241 $stringtoshow .= $langs->trans(
"Year").
' <input class="flat" size="4" type="text" name="'.$param_year.
'" value="'.$endyear.
'">';
242 $stringtoshow .=
'<input type="image" alt="'.$langs->trans(
"Refresh").
'" src="'.
img_picto($langs->trans(
"Refresh"),
'refresh.png',
'',
'', 1).
'">';
243 $stringtoshow .=
'</form>';
244 $stringtoshow .=
'</div>';
246 if (!empty($user->rights->ticket->read)) {
247 print
'<div class="div-table-responsive-no-min">';
248 print
'<table class="noborder centpercent">';
249 print
'<tr class="liste_titre"><th >'.$langs->trans(
"Statistics").
' '.$endyear.
' '.
img_picto(
'',
'filter.png',
'id="idsubimgDOLUSERCOOKIE_ticket_by_status" class="linkobject"').
'</th></tr>';
251 print
'<tr><td class="center">';
255 if (!empty($dataseries) && count($dataseries) > 1) {
257 foreach ($dataseries as $key => $value) {
258 $totalnb += $value[
'data'];
262 foreach ($dataseries as $key => $value) {
263 $data[] = array($value[
'label'], $value[
'data']);
266 $mesg = $px1->isGraphKo();
268 $px1->SetData($data);
269 $px1->SetDataColor(array_values($colorseries));
274 while ($i <= $endyear) {
278 $px1->setShowLegend(2);
279 $px1->SetType(array(
'pie'));
280 $px1->SetLegend($legend);
281 $px1->SetMaxValue($px1->GetCeilMaxValue());
283 $px1->SetHeight($HEIGHT);
284 $px1->SetYLabel($langs->trans(
"TicketStatByStatus"));
286 $px1->SetHorizTickIncrement(1);
287 $px1->SetCssPrefix(
"cssboxes");
288 $px1->mode =
'depth';
291 $px1->draw($filenamenb, $fileurlnb);
292 print $px1->show($totalnb ? 0 : 1);
301 if (!empty($user->rights->ticket->read)) {
303 $data = $stats->getNbByMonthWithPrevYear($endyear, $startyear);
308 print $resultboxes[
'boxlista'];
312 print
'<div class="secondcolumn fichehalfright boxhalfright" id="boxhalfright">';
314 if (!empty($user->rights->ticket->read)) {
321 $sql =
"SELECT t.rowid, t.ref, t.track_id, t.datec, t.subject, t.type_code, t.category_code, t.severity_code, t.fk_statut, t.progress,";
322 $sql .=
" type.code as type_code, type.label as type_label,";
323 $sql .=
" category.code as category_code, category.label as category_label,";
324 $sql .=
" severity.code as severity_code, severity.label as severity_label";
325 $sql .=
" FROM ".MAIN_DB_PREFIX.
"ticket as t";
326 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_ticket_type as type ON type.code=t.type_code";
327 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_ticket_category as category ON category.code=t.category_code";
328 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_ticket_severity as severity ON severity.code=t.severity_code";
329 if (empty($user->rights->societe->client->voir) && !$socid) {
330 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
333 $sql .=
' WHERE t.entity IN ('.getEntity(
'ticket').
')';
334 $sql .=
" AND t.fk_statut=0";
335 if (empty($user->rights->societe->client->voir) && !$socid) {
336 $sql .=
" AND t.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
339 if ($user->socid > 0) {
340 $sql .=
" AND t.fk_soc= ".((int) $user->socid);
343 if (!empty($conf->global->TICKET_LIMIT_VIEW_ASSIGNED_ONLY) && !$user->rights->ticket->manage) {
344 $sql .=
" AND t.fk_user_assign = ".((int) $user->id);
347 $sql .= $db->order(
"t.datec",
"DESC");
348 $sql .= $db->plimit($max, 0);
351 $result = $db->query($sql);
353 $num = $db->num_rows($result);
357 $transRecordedType = $langs->trans(
"LatestNewTickets", $max);
359 print
'<div class="div-table-responsive-no-min">';
360 print
'<table class="noborder centpercent">';
361 print
'<tr class="liste_titre"><th colspan="5">'.$transRecordedType.
'</th>';
362 print
'<th class="right" colspan="2"><a href="'.DOL_URL_ROOT.
'/ticket/list.php?search_fk_statut[]='.
Ticket::STATUS_NOT_READ.
'">'.$langs->trans(
"FullList").
'</th>';
366 $objp = $db->fetch_object($result);
368 $object->id = $objp->rowid;
369 $object->ref = $objp->ref;
370 $object->track_id = $objp->track_id;
371 $object->fk_statut = $objp->fk_statut;
372 $object->progress = $objp->progress;
373 $object->subject = $objp->subject;
375 print
'<tr class="oddeven">';
378 print
'<td class="nowraponall">';
379 print $object->getNomUrl(1);
383 print
'<td class="left">';
388 print
'<td class="nowrap">';
389 print
'<a href="card.php?track_id='.$objp->track_id.
'">'.
dol_trunc($objp->subject, 30).
'</a>';
393 print
'<td class="nowrap tdoverflowmax100">';
394 $s = $langs->getLabelFromKey($db,
'TicketTypeShort'.$objp->type_code,
'c_ticket_type',
'code',
'label', $objp->type_code);
395 print
'<span title="'.dol_escape_htmltag($s).
'">'.$s.
'</span>';
399 print
'<td class="nowrap">';
400 if (!empty($obp->category_code)) {
401 $s = $langs->getLabelFromKey($db,
'TicketCategoryShort'.$objp->category_code,
'c_ticket_category',
'code',
'label', $objp->category_code);
402 print
'<span title="'.dol_escape_htmltag($s).
'">'.$s.
'</span>';
408 print
'<td class="nowrap">';
409 $s = $langs->getLabelFromKey($db,
'TicketSeverityShort'.$objp->severity_code,
'c_ticket_severity',
'code',
'label', $objp->severity_code);
410 print
'<span title="'.dol_escape_htmltag($s).
'">'.$s.
'</span>';
414 print
'<td class="nowraponall right">';
415 print $object->getLibStatut(5);
424 print
'<tr><td colspan="6"><span class="opacitymedium">'.$langs->trans(
'NoUnreadTicketsFound').
'</span></td></tr>';
436 print $resultboxes[
'boxlistb'];
443 print
'<div style="clear:both"></div>';
445 $parameters = array(
'user' => $user);
446 $reshook = $hookmanager->executeHooks(
'dashboardTickets', $parameters, $object);