25require
'../../main.inc.php';
26require_once DOL_DOCUMENT_ROOT.
'/ticket/class/actions_ticket.class.php';
27require_once DOL_DOCUMENT_ROOT.
'/ticket/class/ticketstats.class.php';
28require_once DOL_DOCUMENT_ROOT.
'/ticket/class/ticket.class.php';
29require_once DOL_DOCUMENT_ROOT.
'/core/class/dolgraph.class.php';
34$hookmanager->initHooks(array(
'ticketstats',
'globalcard'));
36if (!$user->hasRight(
'ticket',
'read')) {
40$object_status =
GETPOST(
'object_status',
'intcomma');
45if ($user->socid > 0) {
47 $socid = $user->socid;
51$reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
62$langs->loadLangs(array(
'orders',
'companies',
'other',
'tickets'));
72$title = $langs->trans(
"Statistics");
73$dir = $conf->ticket->dir_temp;
75llxHeader(
'', $title, $help_url,
'', 0, 0,
'',
'',
'',
'mod-ticket page-stats');
81$stats =
new TicketStats($db, $socid, ($userid > 0 ? $userid : 0));
82if ($object_status !=
'' && $object_status >= -1) {
83 $stats->where .=
' AND fk_statut IN ('.$db->sanitize($db->escape($object_status)).
')';
88$data = $stats->getNbByMonthWithPrevYear($endyear, $startyear);
94if (!$user->hasRight(
'societe',
'client',
'voir')) {
95 $filenamenb = $dir.
'/ticketsnbinyear-'.$user->id.
'-'.$year.
'.png';
96 $fileurlnb = DOL_URL_ROOT.
'/viewimage.php?modulepart=ticketstats&file=ticketsnbinyear-'.$user->id.
'-'.$year.
'.png';
98 $filenamenb = $dir.
'/ticketsnbinyear-'.$year.
'.png';
99 $fileurlnb = DOL_URL_ROOT.
'/viewimage.php?modulepart=ticketstats&file=ticketsnbinyear-'.$year.
'.png';
103$mesg = $px1->isGraphKo();
105 $px1->SetData($data);
108 while ($i <= $endyear) {
112 $px1->SetLegend($legend);
113 $px1->SetMaxValue($px1->GetCeilMaxValue());
114 $px1->SetMinValue(min(0, $px1->GetFloorMinValue()));
115 $px1->SetWidth($WIDTH);
116 $px1->SetHeight($HEIGHT);
117 $px1->SetYLabel($langs->trans(
"NbOfTicket"));
119 $px1->SetHorizTickIncrement(1);
120 $px1->mode =
'depth';
121 $px1->SetTitle($langs->trans(
"NumberOfTicketsByMonth"));
123 $px1->draw($filenamenb, $fileurlnb);
127$data = $stats->getAmountByMonthWithPrevYear($endyear, $startyear);
133$data = $stats->getAllByYear();
134$arrayyears = array();
135foreach ($data as $val) {
136 if (!empty($val[
'year'])) {
137 $arrayyears[$val[
'year']] = $val[
'year'];
140if (!count($arrayyears)) {
141 $arrayyears[$nowyear] = $nowyear;
146$head[$h][0] = DOL_URL_ROOT.
'/ticket/stats/index.php';
147$head[$h][1] = $langs->trans(
"ByMonthYear");
148$head[$h][2] =
'byyear';
151$type =
'ticket_stats';
158print
'<div class="fichecenter"><div class="fichethirdleft">';
162print
'<form name="stats" method="POST" action="'.$_SERVER[
"PHP_SELF"].
'">';
163print
'<input type="hidden" name="token" value="'.newToken().
'">';
165print
'<table class="noborder centpercent">';
166print
'<tr class="liste_titre"><td class="liste_titre" colspan="2">'.$langs->trans(
"Filter").
'</td></tr>';
168print
'<tr><td class="left">'.$langs->trans(
"ThirdParty").
'</td><td class="left">';
169print
img_picto(
'',
'company',
'class="pictofixedwidth"');
170print $form->select_company($socid,
'socid',
'', 1, 0, 0, array(), 0,
'widthcentpercentminusx maxwidth300',
'');
173print
'<tr><td class="left">'.$langs->trans(
"CreatedBy").
'</td><td class="left">';
174print
img_picto(
'',
'user',
'class="pictofixedwidth"');
175print $form->select_dolusers($userid,
'userid', 1,
'', 0,
'',
'', 0, 0, 0,
'', 0,
'',
'widthcentpercentminusx maxwidth300');
177print
'<tr><td class="left">'.$langs->trans(
"Status").
'</td><td class="left">';
178$liststatus =
$object->fields[
'fk_statut'][
'arrayofkeyval'];
179print $form->selectarray(
'object_status', $liststatus,
GETPOST(
'object_status',
'intcomma'), -4, 0, 0,
'', 1);
182print
'<tr><td class="left">'.$langs->trans(
"Year").
'</td><td class="left">';
183if (!in_array($year, $arrayyears)) {
184 $arrayyears[$year] = $year;
186if (!in_array($nowyear, $arrayyears)) {
187 $arrayyears[$nowyear] = $nowyear;
190print $form->selectarray(
'year', $arrayyears, $year, 0, 0, 0,
'', 0, 0, 0,
'',
'width75');
192print
'<tr><td class="center" colspan="2"><input type="submit" name="submit" class="button small" value="'.$langs->trans(
"Refresh").
'"></td></tr>';
198print
'<div class="div-table-responsive-no-min">';
199print
'<table class="noborder centpercent">';
200print
'<tr class="liste_titre" height="24">';
201print
'<td class="center">'.$langs->trans(
"Year").
'</td>';
202print
'<td class="right">'.$langs->trans(
"NbOfTickets").
'</td>';
203print
'<td class="right">%</td>';
211foreach ($data as $val) {
212 $year = $val[
'year'];
213 while (!empty($year) && $oldyear > $year + 1) {
216 print
'<tr class="oddeven" height="24">';
217 print
'<td class="center"><a href="'.$_SERVER[
"PHP_SELF"].
'?year='.$oldyear.($socid > 0 ?
'&socid='.$socid :
'').($userid > 0 ?
'&userid='.$userid :
'').
'">'.$oldyear.
'</a></td>';
218 print
'<td class="right">0</td>';
219 print
'<td class="right"></td>';
228 print
'<tr class="oddeven" height="24">';
229 print
'<td class="center"><a href="'.$_SERVER[
"PHP_SELF"].
'?year='.$year.($socid > 0 ?
'&socid='.$socid :
'').($userid > 0 ?
'&userid='.$userid :
'').
'">'.$year.
'</a></td>';
230 print
'<td class="right">'.$val[
'nb'].
'</td>';
231 print
'<td class="right" style="'.((isset($val[
'nb_diff']) && $val[
'nb_diff'] >= 0) ?
'color: green;' :
'color: red;').
'">'.round(isset($val[
'nb_diff']) ? $val[
'nb_diff'] : 0).
'</td>';
244print
'</div><div class="fichetwothirdright">';
248print
'<table class="border centpercent"><tr class="pair nohover"><td class="center">';
258print
'</td></tr></table>';
262print
'<div class="clearboth"></div>';
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
static getDefaultGraphSizeForStats($direction, $defaultsize='')
getDefaultGraphSizeForStats
Class to manage the ticket stats.
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0)
Show tabs of a record.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
complete_head_from_modules($conf, $langs, $object, &$head, &$h, $type, $mode='add', $filterorigmodule='')
Complete or removed entries into a head array (used to build tabs).
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
dol_mkdir($dir, $dataroot='', $newmask='')
Creation of a directory (this can create recursive subdir)
Class to generate the form for creating a new ticket.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.