* Copyright (C) 2004-2016 Laurent Destailleur * Copyright (C) 2005-2009 Regis Houssin * Copyright (C) 2024 MDW * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see . */ /** * \file htdocs/expedition/stats/index.php * \ingroup expedition * \brief Page with shipment statistics */ // Load Dolibarr environment require '../../main.inc.php'; require_once DOL_DOCUMENT_ROOT.'/expedition/class/expedition.class.php'; require_once DOL_DOCUMENT_ROOT.'/expedition/class/expeditionstats.class.php'; require_once DOL_DOCUMENT_ROOT.'/core/class/dolgraph.class.php'; $WIDTH = DolGraph::getDefaultGraphSizeForStats('width'); $HEIGHT = DolGraph::getDefaultGraphSizeForStats('height'); $userid = GETPOSTINT('userid'); $socid = GETPOSTINT('socid'); // Security check if ($user->socid > 0) { $action = ''; $socid = $user->socid; } $nowyear = (int) dol_print_date(dol_now(), "%Y"); $year = GETPOSTINT('year') > 0 ? GETPOSTINT('year') : $nowyear; $startyear = $year - (!getDolGlobalInt('MAIN_STATS_GRAPHS_SHOW_N_YEARS') ? 2 : max(1, min(10, getDolGlobalInt('MAIN_STATS_GRAPHS_SHOW_N_YEARS')))); $endyear = $year; // Load translation files required by the page $langs->loadLangs(array('sendings', 'other', 'companies')); // Security check if ($user->socid) { $socid = $user->socid; } restrictedArea($user, 'expedition'); /* * View */ $form = new Form($db); llxHeader('', '', '', '', 0, 0, '', '', '', 'mod-expedition page-stats_index'); print load_fiche_titre($langs->trans("StatisticsOfSendings"), '', 'dolly'); $dir = (!empty($conf->expedition->multidir_temp[$conf->entity]) ? $conf->expedition->multidir_temp[$conf->entity] : $conf->service->multidir_temp[$conf->entity]); dol_mkdir($dir); $stats = new ExpeditionStats($db, $socid, '', ($userid > 0 ? $userid : 0)); // Build graphic number of object $data = $stats->getNbByMonthWithPrevYear($endyear, $startyear); //var_dump($data);exit; // $data = array(array('Lib',val1,val2,val3),...) if (!$user->hasRight('societe', 'client', 'voir')) { $filenamenb = $dir.'/shipmentsnbinyear-'.$user->id.'-'.$year.'.png'; } else { $filenamenb = $dir.'/shipmentsnbinyear-'.$year.'.png'; } $px1 = new DolGraph(); $mesg = $px1->isGraphKo(); $fileurlnb = ''; if (!$mesg) { $px1->SetData($data); $i = $startyear; $legend = array(); while ($i <= $endyear) { $legend[] = $i; $i++; } $px1->SetLegend($legend); $px1->SetMaxValue($px1->GetCeilMaxValue()); $px1->SetMinValue(min(0, $px1->GetFloorMinValue())); $px1->SetWidth($WIDTH); $px1->SetHeight($HEIGHT); $px1->SetYLabel($langs->trans("NbOfSendings")); $px1->SetShading(3); $px1->SetHorizTickIncrement(1); $px1->mode = 'depth'; $px1->SetTitle($langs->trans("NumberOfShipmentsByMonth")); $px1->draw($filenamenb, $fileurlnb); } // Build graphic amount of object /* $data = $stats->getAmountByMonthWithPrevYear($endyear,$startyear); //var_dump($data); // $data = array(array('Lib',val1,val2,val3),...) if (empty($user->rights->societe->client->voir) || $user->socid) { $filenameamount = $dir.'/shipmentsamountinyear-'.$user->id.'-'.$year.'.png'; } else { $filenameamount = $dir.'/shipmentsamountinyear-'.$year.'.png'; } $px2 = new DolGraph(); $mesg = $px2->isGraphKo(); if (! $mesg) { $px2->SetData($data); $i=$startyear;$legend=array(); while ($i <= $endyear) { $legend[]=$i; $i++; } $px2->SetLegend($legend); $px2->SetMaxValue($px2->GetCeilMaxValue()); $px2->SetMinValue(min(0,$px2->GetFloorMinValue())); $px2->SetWidth($WIDTH); $px2->SetHeight($HEIGHT); $px2->SetYLabel($langs->trans("AmountOfShipments")); $px2->SetShading(3); $px2->SetHorizTickIncrement(1); $px2->mode='depth'; $px2->SetTitle($langs->trans("AmountOfShipmentsByMonthHT")); $px2->draw($filenameamount,$fileurlamount); } */ /* $data = $stats->getAverageByMonthWithPrevYear($endyear, $startyear); if (empty($user->rights->societe->client->voir) || $user->socid) { $filename_avg = $dir.'/shipmentsaverage-'.$user->id.'-'.$year.'.png'; } else { $filename_avg = $dir.'/shipmentsaverage-'.$year.'.png'; } $px3 = new DolGraph(); $mesg = $px3->isGraphKo(); if (! $mesg) { $px3->SetData($data); $i=$startyear;$legend=array(); while ($i <= $endyear) { $legend[]=$i; $i++; } $px3->SetLegend($legend); $px3->SetYLabel($langs->trans("AmountAverage")); $px3->SetMaxValue($px3->GetCeilMaxValue()); $px3->SetMinValue($px3->GetFloorMinValue()); $px3->SetWidth($WIDTH); $px3->SetHeight($HEIGHT); $px3->SetShading(3); $px3->SetHorizTickIncrement(1); $px3->mode='depth'; $px3->SetTitle($langs->trans("AmountAverage")); $px3->draw($filename_avg,$fileurl_avg); } */ // Show array $data = $stats->getAllByYear(); $arrayyears = array(); foreach ($data as $val) { if (!empty($val['year'])) { $arrayyears[$val['year']] = $val['year']; } } if (!count($arrayyears)) { $arrayyears[$nowyear] = $nowyear; } $h = 0; $head = array(); $head[$h][0] = DOL_URL_ROOT.'/expedition/stats/index.php'; $head[$h][1] = $langs->trans("ByMonthYear"); $head[$h][2] = 'byyear'; $h++; $type = 'shipment_stats'; complete_head_from_modules($conf, $langs, null, $head, $h, $type); print dol_get_fiche_head($head, 'byyear', '', -1); print '
'; // Show filter box print '
'; print ''; print ''; print ''; // Company print ''; // User print ''; // Year print ''; print ''; print '
'.$langs->trans("Filter").'
'.$langs->trans("ThirdParty").''; print img_picto('', 'company', 'class="pictofixedwidth"'); print $form->select_company($socid, 'socid', '', 1, 0, 0, array(), 0, 'widthcentpercentminusx maxwidth300', ''); print '
'.$langs->trans("CreatedBy").''; print img_picto('', 'user', 'class="pictofixedwidth"'); print $form->select_dolusers($userid, 'userid', 1, '', 0, '', '', 0, 0, 0, '', 0, '', 'widthcentpercentminusx maxwidth300'); print '
'.$langs->trans("Year").''; if (!in_array($year, $arrayyears)) { $arrayyears[$year] = $year; } if (!in_array($nowyear, $arrayyears)) { $arrayyears[$nowyear] = $nowyear; } arsort($arrayyears); print $form->selectarray('year', $arrayyears, $year, 0, 0, 0, '', 0, 0, 0, '', 'width75'); print '
'; print '
'; print '

'; print '
'; print ''; print ''; print ''; print ''; /*print ''; print '';*/ print ''; $oldyear = 0; foreach ($data as $val) { $year = $val['year']; while (!empty($year) && $oldyear > $year + 1) { // If we have empty year $oldyear--; print ''; print ''; print ''; /*print ''; print '';*/ print ''; } print ''; print ''; print ''; /*print ''; print '';*/ print ''; $oldyear = $year; } print '
'.$langs->trans("Year").''.$langs->trans("NbOfSendings").''.$langs->trans("AmountTotal").''.$langs->trans("AmountAverage").'
'.$oldyear.'000
'; if ($year) { print ''.$year.''; } else { // Technical error that should not happen print 'Error: validation date of shipment is not defined. This looks strange because shipment is validated. Try to run /install/repair.php?standard=confirmed'; } print ''.$val['nb'].''.price(price2num($val['total'],'MT'),1).''.price(price2num($val['avg'],'MT'),1).'
'; print '
'; print '
'; // Show graphs print '
'; if ($mesg) { print $mesg; } else { print $px1->show(); print "
\n"; /*print $px2->show(); print "
\n"; print $px3->show();*/ } print '
'; print '
'; print '
'; print dol_get_fiche_end(); // TODO USe code similar to commande/stats/index.php instead of this one. /* print ''; print ''; print ''; $sql = "SELECT count(*) as nb, date_format(date_expedition,'%Y') as dm"; $sql.= " FROM ".MAIN_DB_PREFIX."expedition"; $sql.= " WHERE fk_statut > 0"; $sql.= " AND entity = ".$conf->entity; $sql.= " GROUP BY dm DESC"; $resql=$db->query($sql); if ($resql) { $num = $db->num_rows($resql); $i = 0; while ($i < $num) { $row = $db->fetch_row($resql); $nbproduct = $row[0]; $year = $row[1]; print ""; print ''; $i++; } } $db->free($resql); print '
'.$langs->trans("Year").''.$langs->trans("NbOfSendings").'
'.$year.''.$nbproduct.'
'; */ print '
'; print ''.$langs->trans("StatsOnShipmentsOnlyValidated").''; // End of page llxFooter(); $db->close();