27require
'../../main.inc.php';
28require_once DOL_DOCUMENT_ROOT.
'/ticket/class/actions_ticket.class.php';
29require_once DOL_DOCUMENT_ROOT.
'/ticket/class/ticketstats.class.php';
30require_once DOL_DOCUMENT_ROOT.
'/ticket/class/ticket.class.php';
31require_once DOL_DOCUMENT_ROOT.
'/core/class/dolgraph.class.php';
43$hookmanager->initHooks(array(
'ticketstats',
'globalcard'));
45if (!$user->hasRight(
'ticket',
'read')) {
49$object_status =
GETPOST(
'object_status',
'intcomma');
54if ($user->socid > 0) {
56 $socid = $user->socid;
60$reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
71$langs->loadLangs(array(
'orders',
'companies',
'other',
'tickets'));
81$title = $langs->trans(
"Statistics");
82$dir =
$conf->ticket->dir_temp;
84llxHeader(
'', $title, $help_url,
'', 0, 0,
'',
'',
'',
'mod-ticket page-stats');
90$stats =
new TicketStats($db, $socid, ($userid > 0 ? $userid : 0));
91if ($object_status !=
'' && $object_status >= -1) {
92 $stats->where .=
' AND fk_statut IN ('.$db->sanitize($db->escape($object_status)).
')';
97$data = $stats->getNbByMonthWithPrevYear($endyear, $startyear);
103if (!$user->hasRight(
'societe',
'client',
'voir')) {
104 $filenamenb = $dir.
'/ticketsnbinyear-'.$user->id.
'-'.$year.
'.png';
105 $fileurlnb = DOL_URL_ROOT.
'/viewimage.php?modulepart=ticketstats&file=ticketsnbinyear-'.$user->id.
'-'.$year.
'.png';
107 $filenamenb = $dir.
'/ticketsnbinyear-'.$year.
'.png';
108 $fileurlnb = DOL_URL_ROOT.
'/viewimage.php?modulepart=ticketstats&file=ticketsnbinyear-'.$year.
'.png';
112$mesg = $px1->isGraphKo();
114 $px1->SetData($data);
117 while ($i <= $endyear) {
121 $px1->SetLegend($legend);
122 $px1->SetMaxValue($px1->GetCeilMaxValue());
123 $px1->SetMinValue(min(0, $px1->GetFloorMinValue()));
124 $px1->SetWidth($WIDTH);
125 $px1->SetHeight($HEIGHT);
126 $px1->SetYLabel($langs->trans(
"NbOfTicket"));
128 $px1->SetHorizTickIncrement(1);
129 $px1->mode =
'depth';
130 $px1->SetTitle($langs->trans(
"NumberOfTicketsByMonth"));
132 $px1->draw($filenamenb, $fileurlnb);
136$data = $stats->getAmountByMonthWithPrevYear($endyear, $startyear);
142$data = $stats->getAllByYear();
143$arrayyears = array();
144foreach ($data as $val) {
145 if (!empty($val[
'year'])) {
146 $arrayyears[$val[
'year']] = $val[
'year'];
149if (!count($arrayyears)) {
150 $arrayyears[$nowyear] = $nowyear;
155$head[$h][0] = DOL_URL_ROOT.
'/ticket/stats/index.php';
156$head[$h][1] = $langs->trans(
"ByMonthYear");
157$head[$h][2] =
'byyear';
160$type =
'ticket_stats';
167print
'<div class="fichecenter"><div class="fichethirdleft">';
171print
'<form name="stats" method="POST" action="'.$_SERVER[
"PHP_SELF"].
'">';
172print
'<input type="hidden" name="token" value="'.newToken().
'">';
174print
'<table class="noborder centpercent">';
175print
'<tr class="liste_titre"><td class="liste_titre" colspan="2">'.$langs->trans(
"Filter").
'</td></tr>';
177print
'<tr><td class="left">'.$langs->trans(
"ThirdParty").
'</td><td class="left">';
178print
img_picto(
'',
'company',
'class="pictofixedwidth"');
179print $form->select_company($socid,
'socid',
'', 1, 0, 0, array(), 0,
'widthcentpercentminusx maxwidth300',
'');
182print
'<tr><td class="left">'.$langs->trans(
"CreatedBy").
'</td><td class="left">';
183print
img_picto(
'',
'user',
'class="pictofixedwidth"');
184print $form->select_dolusers($userid,
'userid', 1,
'', 0,
'',
'', 0, 0, 0,
'', 0,
'',
'widthcentpercentminusx maxwidth300');
186print
'<tr><td class="left">'.$langs->trans(
"Status").
'</td><td class="left">';
187$liststatus =
$object->fields[
'fk_statut'][
'arrayofkeyval'];
188print $form->selectarray(
'object_status', $liststatus,
GETPOST(
'object_status',
'intcomma'), -4, 0, 0,
'', 1);
191print
'<tr><td class="left">'.$langs->trans(
"Year").
'</td><td class="left">';
192if (!in_array($year, $arrayyears)) {
193 $arrayyears[$year] = $year;
195if (!in_array($nowyear, $arrayyears)) {
196 $arrayyears[$nowyear] = $nowyear;
199print $form->selectarray(
'year', $arrayyears, $year, 0, 0, 0,
'', 0, 0, 0,
'',
'width75');
201print
'<tr><td class="center" colspan="2"><input type="submit" name="submit" class="button small" value="'.$langs->trans(
"Refresh").
'"></td></tr>';
207print
'<div class="div-table-responsive-no-min">';
208print
'<table class="noborder centpercent">';
209print
'<tr class="liste_titre" height="24">';
210print
'<td class="center">'.$langs->trans(
"Year").
'</td>';
211print
'<td class="right">'.$langs->trans(
"NbOfTickets").
'</td>';
212print
'<td class="right">%</td>';
220foreach ($data as $val) {
221 $year = $val[
'year'];
222 while (!empty($year) && $oldyear > (
int) $year + 1) {
225 print
'<tr class="oddeven" height="24">';
226 print
'<td class="center"><a href="'.$_SERVER[
"PHP_SELF"].
'?year='.$oldyear.($socid > 0 ?
'&socid='.$socid :
'').($userid > 0 ?
'&userid='.$userid :
'').
'">'.$oldyear.
'</a></td>';
227 print
'<td class="right">0</td>';
228 print
'<td class="right"></td>';
237 print
'<tr class="oddeven" height="24">';
238 print
'<td class="center"><a href="'.$_SERVER[
"PHP_SELF"].
'?year='.$year.($socid > 0 ?
'&socid='.$socid :
'').($userid > 0 ?
'&userid='.$userid :
'').
'">'.$year.
'</a></td>';
239 print
'<td class="right">'.$val[
'nb'].
'</td>';
240 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>';
253print
'</div><div class="fichetwothirdright">';
257print
'<table class="border centpercent"><tr class="pair nohover"><td class="center">';
267print
'</td></tr></table>';
271print
'<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)
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...
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.