34if (!defined(
'USE_CUSTOM_REPORT_AS_INCLUDE')) {
35 require
'../main.inc.php';
38 $action =
GETPOST(
'action',
'aZ09') ?
GETPOST(
'action',
'aZ09') :
'view';
39 $massaction =
GETPOST(
'massaction',
'alpha');
41 $mode =
GETPOST(
'mode',
'alpha');
42 $objecttype =
GETPOST(
'objecttype',
'aZ09arobase');
43 $tabfamily =
GETPOST(
'tabfamily',
'aZ09');
45 $search_measures =
GETPOST(
'search_measures',
'array');
48 if (
GETPOST(
'search_xaxis',
'alpha') &&
GETPOST(
'search_xaxis',
'alpha') !=
'-1') {
49 $search_xaxis = array(
GETPOST(
'search_xaxis',
'alpha'));
51 $search_xaxis = array();
54 if (
GETPOST(
'search_groupby',
'alpha') &&
GETPOST(
'search_groupby',
'alpha') !=
'-1') {
55 $search_groupby = array(
GETPOST(
'search_groupby',
'alpha'));
57 $search_groupby = array();
60 $search_yaxis =
GETPOST(
'search_yaxis',
'array');
61 $search_graph =
GETPOST(
'search_graph',
'restricthtml');
65 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
66 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
68 if (empty($page) || $page == -1 ||
GETPOST(
'button_search',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha') || (empty($toselect) && $massaction ===
'0')) {
71 $offset = $limit * $page;
72 $pageprev = $page - 1;
73 $pagenext = $page + 1;
75 $diroutputmassaction = $conf->user->dir_temp.
'/'.$user->id.
'/customreport';
82 if (empty($user) || empty($user->id)) {
83 print
'Page is called as an include but $user and its permission loaded with getrights() are not defined. We stop here.';
87 print
'Page is called as an include but $object is not defined. We stop here.';
95if (!isset($search_measures)) {
96 $search_measures = array(0 =>
't.count');
99 $objecttype =
$object->element.($object->module ?
'@'.$object->module :
'');
101if (empty($objecttype)) {
102 $objecttype =
'thirdparty';
105require_once DOL_DOCUMENT_ROOT.
"/core/class/extrafields.class.php";
106require_once DOL_DOCUMENT_ROOT.
"/core/class/html.form.class.php";
107require_once DOL_DOCUMENT_ROOT.
"/core/lib/admin.lib.php";
108require_once DOL_DOCUMENT_ROOT.
"/core/lib/company.lib.php";
109require_once DOL_DOCUMENT_ROOT.
"/core/lib/date.lib.php";
110require_once DOL_DOCUMENT_ROOT.
"/core/lib/customreports.lib.php";
111require_once DOL_DOCUMENT_ROOT.
"/core/class/dolgraph.class.php";
112require_once DOL_DOCUMENT_ROOT.
"/core/class/doleditor.class.php";
113require_once DOL_DOCUMENT_ROOT.
"/core/class/html.formother.class.php";
116$langs->loadLangs(array(
"companies",
"other",
"exports",
"sendings"));
120$hookmanager->initHooks(array(
'customreport'));
125$ObjectClassName =
'';
128 'thirdparty' => array(
'langs' =>
'companies',
'label' =>
'ThirdParties',
'picto' =>
'company',
'ObjectClassName' =>
'Societe',
'enabled' => isModEnabled(
'societe'),
'ClassPath' =>
"/societe/class/societe.class.php"),
129 'contact' => array(
'label' =>
'Contacts',
'picto' =>
'contact',
'ObjectClassName' =>
'Contact',
'enabled' => isModEnabled(
'societe'),
'ClassPath' =>
"/contact/class/contact.class.php"),
130 'proposal' => array(
'label' =>
'Proposals',
'picto' =>
'proposal',
'ObjectClassName' =>
'Propal',
'enabled' => isModEnabled(
'propal'),
'ClassPath' =>
"/comm/propal/class/propal.class.php"),
131 'order' => array(
'label' =>
'Orders',
'picto' =>
'order',
'ObjectClassName' =>
'Commande',
'enabled' => isModEnabled(
'order'),
'ClassPath' =>
"/commande/class/commande.class.php"),
132 'invoice' => array(
'langs' =>
'facture',
'label' =>
'Invoices',
'picto' =>
'bill',
'ObjectClassName' =>
'Facture',
'enabled' => isModEnabled(
'invoice'),
'ClassPath' =>
"/compta/facture/class/facture.class.php"),
133 'invoice_template' => array(
'label' =>
'PredefinedInvoices',
'picto' =>
'bill',
'ObjectClassName' =>
'FactureRec',
'enabled' => isModEnabled(
'invoice'),
'ClassPath' =>
"/compta/class/facturerec.class.php",
'langs' =>
'bills'),
134 'contract' => array(
'label' =>
'Contracts',
'picto' =>
'contract',
'ObjectClassName' =>
'Contrat',
'enabled' => isModEnabled(
'contract'),
'ClassPath' =>
"/contrat/class/contrat.class.php",
'langs' =>
'contracts'),
135 'contractdet' => array(
'label' =>
'ContractLines',
'picto' =>
'contract',
'ObjectClassName' =>
'ContratLigne',
'enabled' => isModEnabled(
'contract'),
'ClassPath' =>
"/contrat/class/contrat.class.php",
'langs' =>
'contracts'),
136 'bom' => array(
'label' =>
'BOM',
'picto' =>
'bom',
'ObjectClassName' =>
'Bom',
'enabled' => isModEnabled(
'bom')),
137 'mrp' => array(
'label' =>
'MO',
'picto' =>
'mrp',
'ObjectClassName' =>
'Mo',
'enabled' => isModEnabled(
'mrp'),
'ClassPath' =>
"/mrp/class/mo.class.php"),
138 'ticket' => array(
'label' =>
'Ticket',
'picto' =>
'ticket',
'ObjectClassName' =>
'Ticket',
'enabled' => isModEnabled(
'ticket')),
139 'member' => array(
'label' =>
'Adherent',
'picto' =>
'member',
'ObjectClassName' =>
'Adherent',
'enabled' => isModEnabled(
'member'),
'ClassPath' =>
"/adherents/class/adherent.class.php",
'langs' =>
'members'),
140 'cotisation' => array(
'label' =>
'Subscriptions',
'picto' =>
'member',
'ObjectClassName' =>
'Subscription',
'enabled' => isModEnabled(
'member'),
'ClassPath' =>
"/adherents/class/subscription.class.php",
'langs' =>
'members'),
145$parameters = array(
'objecttype' => $objecttype,
'tabfamily' => $tabfamily);
146$reshook = $hookmanager->executeHooks(
'loadDataForCustomReports', $parameters,
$object, $action);
149} elseif (is_array($hookmanager->resArray)) {
150 if (!empty($hookmanager->resArray[
'title'])) {
151 $title = $hookmanager->resArray[
'title'];
153 if (!empty($hookmanager->resArray[
'picto'])) {
154 $picto = $hookmanager->resArray[
'picto'];
156 if (!empty($hookmanager->resArray[
'head'])) {
157 $head = array_merge($head, $hookmanager->resArray[
'head']);
159 if (!empty($hookmanager->resArray[
'arrayoftype'])) {
160 foreach ($hookmanager->resArray[
'arrayoftype'] as $key => $val) {
161 $arrayoftype[$key] = $val;
169 if (!empty($arrayoftype[$objecttype][
'ClassPath'])) {
170 $fileforclass = $arrayoftype[$objecttype][
'ClassPath'];
172 $fileforclass =
"/".$objecttype.
"/class/".$objecttype.
".class.php";
176 $ObjectClassName = $arrayoftype[$objecttype][
'ObjectClassName'];
177 if (!empty($ObjectClassName)) {
178 if (class_exists($ObjectClassName)) {
179 $object =
new $ObjectClassName($db);
181 print
'Failed to load class for type '.$objecttype.
'. Class file found but Class object named '.$ObjectClassName.
' not found.';
184 print
'Failed to load class for type '.$objecttype.
'. Class file name is unknown.';
187 print
'Failed to load class for type '.$objecttype.
'. Class path not found.';
191'@phan-var-force CommonObject $object';
195if ($user->socid > 0) {
201$extrafields->fetch_name_optionals_label(
'all');
204$search_array_options = $extrafields->getOptionalsFromPost(
$object->table_element,
'',
'search_');
206$search_component_params = array(
'');
207$search_component_params_hidden = trim(
GETPOST(
'search_component_params_hidden',
'alphanohtml'));
208$search_component_params_input = trim(
GETPOST(
'search_component_params_input',
'alphanohtml'));
217 $value = $search_component_params_input;
219 $value = preg_replace(
'/([a-z\.]+)\s*([!<>=]+|in|notin|like|notlike)\s*/',
'\1:\2:', $value);
220 $value = preg_replace(
'/\s*\|\s*/',
'|', $value);
223 $crits = explode(
' ', trim($value));
227 foreach ($crits as $crit) {
232 $tmpcrits = explode(
'|', $crit);
234 foreach ($tmpcrits as $tmpcrit) {
235 if ($tmpcrit !==
'0' && empty($tmpcrit)) {
238 $tmpcrit = trim($tmpcrit);
242 $parenthesislevel = 0;
243 $rescheckfilter =
dolCheckFilters($tmpcrit, $errorstr, $parenthesislevel);
244 if ($rescheckfilter) {
245 while ($parenthesislevel > 0) {
246 $tmpcrit = preg_replace(
'/^\(/',
'', preg_replace(
'/\)$/',
'', $tmpcrit));
251 $field = preg_replace(
'/(:[!<>=\s]+:|:in:|:notin:|:like:|:notlike:).*$/',
'', $tmpcrit);
252 $tmpcrit = preg_replace(
'/^.*(:[!<>=\s]+:|:in:|:notin:|:like:|:notlike:)/',
'\1', $tmpcrit);
255 $newres .= (($i2 > 0 || $i3 > 0) ?
' OR ' :
'');
258 $newcrit = preg_replace(
'/(:[!<>=\s]+:|:in:|:notin:|:like:|:notlike:)/',
'', $tmpcrit);
262 preg_match(
'/:([!<>=\s]+|in|notin|like|notlike):/', $tmpcrit, $reg);
263 if (!empty($reg[1])) {
266 if ($newcrit !=
'') {
267 if (!preg_match(
'/^\'[^\']*\'$/', $newcrit)) {
269 $newres .=
'('.$field.
':'.$operator.
':'.((float) $numnewcrit).
')';
271 $newres .=
'('.$field.
':'.$operator.
":".((string) $newcrit).
')';
279 $res = $res.($res ?
' AND ' :
'').($i2 > 1 ?
'(' :
'').$newres.($i2 > 1 ?
')' :
'');
286 $search_component_params_input = $res;
292$search_component_params_hidden = implode(
' AND ', array_merge($arrayofandtagshidden, $arrayofandtagsinput));
295$MAXUNIQUEVALFORGROUP = 20;
296$MAXMEASURESINBARGRAPH = 20;
297$SHOWLEGEND = (isset($SHOWLEGEND) ? $SHOWLEGEND : 1);
299$YYYY = substr($langs->trans(
"Year"), 0, 1).substr($langs->trans(
"Year"), 0, 1).substr($langs->trans(
"Year"), 0, 1).substr($langs->trans(
"Year"), 0, 1);
300$MM = substr($langs->trans(
"Month"), 0, 1).substr($langs->trans(
"Month"), 0, 1);
301$DD = substr($langs->trans(
"Day"), 0, 1).substr($langs->trans(
"Day"), 0, 1);
302$HH = substr($langs->trans(
"Hour"), 0, 1).substr($langs->trans(
"Hour"), 0, 1);
303$MI = substr($langs->trans(
"Minute"), 0, 1).substr($langs->trans(
"Minute"), 0, 1);
304$SS = substr($langs->trans(
"Second"), 0, 1).substr($langs->trans(
"Second"), 0, 1);
306$arrayofmesures = array();
307$arrayofxaxis = array();
308$arrayofgroupby = array();
309$arrayofyaxis = array();
310$arrayofvaluesforgroupby = array();
313if (!empty(
$object->element_for_permission)) {
314 $features =
$object->element_for_permission;
316 $features = $features.(empty(
$object->module) ?
'' :
'@'.$object->module);
336$form =
new Form($db);
339if (!defined(
'USE_CUSTOM_REPORT_AS_INCLUDE')) {
340 llxHeader(
'', $langs->transnoentitiesnoconv(
'CustomReports'),
'');
349$newarrayoftype = array();
350foreach ($arrayoftype as $key => $val) {
351 if (
dol_eval($val[
'enabled'], 1, 1,
'1')) {
352 $newarrayoftype[$key] = $arrayoftype[$key];
354 if (!empty($val[
'langs'])) {
355 $langs->load($val[
'langs']);
360$arrayofmesures =
fillArrayOfMeasures(
$object,
't', $langs->trans($newarrayoftype[$objecttype][
'label']), $arrayofmesures, 0, $count);
361$arrayofmesures =
dol_sort_array($arrayofmesures,
'position',
'asc', 0, 0, 1);
364$arrayofxaxis =
fillArrayOfXAxis(
$object,
't', $langs->trans($newarrayoftype[$objecttype][
'label']), $arrayofxaxis, 0, $count);
365$arrayofxaxis =
dol_sort_array($arrayofxaxis,
'position',
'asc', 0, 0, 1);
368$arrayofgroupby =
fillArrayOfGroupBy(
$object,
't', $langs->trans($newarrayoftype[$objecttype][
'label']), $arrayofgroupby, 0, $count);
369$arrayofgroupby =
dol_sort_array($arrayofgroupby,
'position',
'asc', 0, 0, 1);
373if ($action ==
'viewgraph') {
374 if (!count($search_measures)) {
375 setEventMessages($langs->trans(
"AtLeastOneMeasureIsRequired"),
null,
'warnings');
376 } elseif ($mode ==
'graph' && count($search_xaxis) > 1) {
377 setEventMessages($langs->trans(
"OnlyOneFieldForXAxisIsPossible"),
null,
'warnings');
378 $search_xaxis = array(0 => $search_xaxis[0]);
380 if (count($search_groupby) >= 2) {
381 setEventMessages($langs->trans(
"ErrorOnlyOneFieldForGroupByIsPossible"),
null,
'warnings');
382 $search_groupby = array(0 => $search_groupby[0]);
384 if (!count($search_xaxis)) {
385 setEventMessages($langs->trans(
"AtLeastOneXAxisIsRequired"),
null,
'warnings');
386 } elseif ($mode ==
'graph' && $search_graph ==
'bars' && count($search_measures) > $MAXMEASURESINBARGRAPH) {
387 $langs->load(
"errors");
388 setEventMessages($langs->trans(
"GraphInBarsAreLimitedToNMeasures", $MAXMEASURESINBARGRAPH),
null,
'warnings');
389 $search_graph =
'lines';
395if (is_array($search_groupby) && count($search_groupby)) {
397 foreach ($search_groupby as $gkey => $gval) {
398 $gvalwithoutprefix = preg_replace(
'/^[a-z]+\./',
'', $gval);
400 if (preg_match(
'/\-year$/', $search_groupby[$gkey])) {
401 $tmpval = preg_replace(
'/\-year$/',
'', $search_groupby[$gkey]);
402 $fieldtocount .=
'DATE_FORMAT('.$tmpval.
", '%Y')";
403 } elseif (preg_match(
'/\-month$/', $search_groupby[$gkey])) {
404 $tmpval = preg_replace(
'/\-month$/',
'', $search_groupby[$gkey]);
405 $fieldtocount .=
'DATE_FORMAT('.$tmpval.
", '%Y-%m')";
406 } elseif (preg_match(
'/\-day$/', $search_groupby[$gkey])) {
407 $tmpval = preg_replace(
'/\-day$/',
'', $search_groupby[$gkey]);
408 $fieldtocount .=
'DATE_FORMAT('.$tmpval.
", '%Y-%m-%d')";
410 $fieldtocount = $search_groupby[$gkey];
413 $sql =
"SELECT DISTINCT ".$fieldtocount.
" as val";
415 if (strpos($fieldtocount,
'te') === 0) {
416 $tabletouse =
$object->table_element;
417 $tablealiastouse =
'te';
418 if (!empty($arrayofgroupby[$gval])) {
419 $tmpval = explode(
'.', $gval);
420 $tabletouse = $arrayofgroupby[$gval][
'table'];
421 $tablealiastouse = $tmpval[0];
426 $sql .=
" FROM ".MAIN_DB_PREFIX.$tabletouse.
"_extrafields as ".$tablealiastouse;
428 $tabletouse =
$object->table_element;
429 $tablealiastouse =
't';
430 if (!empty($arrayofgroupby[$gval])) {
431 $tmpval = explode(
'.', $gval);
432 $tabletouse = $arrayofgroupby[$gval][
'table'];
433 $tablealiastouse = $tmpval[0];
435 $sql .=
" FROM ".MAIN_DB_PREFIX.$tabletouse.
" as ".$tablealiastouse;
446 $sql .=
" LIMIT ".((int) ($MAXUNIQUEVALFORGROUP + 1));
449 $resql = $db->query($sql);
454 while ($obj = $db->fetch_object($resql)) {
455 if (is_null($obj->val)) {
456 $keytouse =
'__NULL__';
457 $valuetranslated = $langs->transnoentitiesnoconv(
"NotDefined");
458 } elseif ($obj->val ===
'') {
460 $valuetranslated = $langs->transnoentitiesnoconv(
"Empty");
462 $keytouse = (string) $obj->val;
463 $valuetranslated = $obj->val;
467 if (!empty(
$object->fields[$gvalwithoutprefix][
'arrayofkeyval'])) {
468 $valuetranslated =
$object->fields[$gvalwithoutprefix][
'arrayofkeyval'][$obj->val];
469 if (is_null($valuetranslated)) {
470 $valuetranslated = $langs->transnoentitiesnoconv(
"UndefinedKey");
472 $valuetranslated = $langs->trans($valuetranslated);
473 } elseif (preg_match(
'/integer:([^:]+):([^:]+)$/',
$object->fields[$gvalwithoutprefix][
'type'], $regs)) {
474 $classname = $regs[1];
475 $classpath = $regs[2];
477 if (class_exists($classname)) {
478 $tmpobject =
new $classname($db);
479 $tmpobject->fetch($obj->val);
480 foreach ($tmpobject->fields as $fieldkey => $field) {
481 if ($field[
'showoncombobox']) {
482 $valuetranslated = $tmpobject->$fieldkey;
491 $arrayofvaluesforgroupby[
'g_'.$gkey][$keytouse] = $valuetranslated;
494 $tmpfield = explode(
'.', $gval);
495 if ($tmpfield[0] !=
't' || (is_array(
$object->fields[$tmpfield[1]]) && empty(
$object->fields[$tmpfield[1]][
'notnull']))) {
496 dol_syslog(
"The group by field ".$gval.
" may be null (because field is null or it is a left join), so we add __NULL__ entry in list of possible values");
498 $arrayofvaluesforgroupby[
'g_'.$gkey][
'__NULL__'] = $langs->transnoentitiesnoconv(
"NotDefined");
501 if (is_array($arrayofvaluesforgroupby[
'g_'.$gkey])) {
502 asort($arrayofvaluesforgroupby[
'g_'.$gkey]);
506 if (is_array($arrayofvaluesforgroupby[
'g_'.$gkey]) && count($arrayofvaluesforgroupby[
'g_'.$gkey]) > $MAXUNIQUEVALFORGROUP) {
507 $langs->load(
"errors");
509 if (strpos($fieldtocount,
'te') === 0) {
513 $keyforlabeloffield = $extrafields->attributes[
$object->table_element][
'label'][$gvalwithoutprefix];
514 $labeloffield = $langs->transnoentitiesnoconv($keyforlabeloffield);
515 } elseif (strpos($fieldtocount,
't__') === 0) {
517 if (preg_match(
'/^(.*)\.(.*)/', $gvalwithoutprefix, $reg)) {
524 $labeloffield = $arrayofgroupby[$fieldtocount][
'labelnohtml'];
526 $labeloffield = $langs->transnoentitiesnoconv($keyforlabeloffield);
530 if (preg_match(
'/^(.*)\-(year|month|day)/', $gvalwithoutprefix, $reg)) {
531 $gvalwithoutprefix = preg_replace(
'/\-(year|month|day)/',
'', $gvalwithoutprefix);
532 $keyforlabeloffield =
$object->fields[$gvalwithoutprefix][
'label'];
533 $labeloffield = $langs->transnoentitiesnoconv($keyforlabeloffield).
'-'.$reg[2];
535 $keyforlabeloffield =
$object->fields[$gvalwithoutprefix][
'label'];
536 $labeloffield = $langs->transnoentitiesnoconv($keyforlabeloffield);
540 setEventMessages($langs->trans(
"ErrorTooManyDifferentValueForSelectedGroupBy", $MAXUNIQUEVALFORGROUP, $labeloffield),
null,
'warnings');
541 $search_groupby = array();
551$endyear = $tmparray[
'year'];
552$endmonth = $tmparray[
'mon'];
554$startyear = $endyear - 2;
559if (!defined(
'MAIN_CUSTOM_REPORT_KEEP_GRAPH_ONLY')) {
560 print
'<form method="post" action="'.$_SERVER[
'PHP_SELF'].
'" autocomplete="off">';
561 print
'<input type="hidden" name="token" value="'.newToken().
'">';
562 print
'<input type="hidden" name="action" value="viewgraph">';
563 print
'<input type="hidden" name="tabfamily" value="'.$tabfamily.
'">';
567 $viewmode .=
'<div class="divadvancedsearchfield">';
568 $arrayofgraphs = array(
'bars' =>
'Bars',
'lines' =>
'Lines');
569 $viewmode .=
'<div class="inline-block opacitymedium"><span class="fas fa-chart-area paddingright" title="'.$langs->trans(
"Graph").
'"></span>'.$langs->trans(
"Graph").
'</div> ';
570 $viewmode .= $form->selectarray(
'search_graph', $arrayofgraphs, $search_graph, 0, 0, 0,
'', 1, 0, 0,
'',
'graphtype width100');
571 $viewmode .=
'</div>';
574 $massactionbutton =
'';
579 print_barre_liste(
'', $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, -1,
'object_action', 0, $nav.
'<span class="marginleftonly"></span>'.$newcardbutton,
'', $limit, 1, 0, 1, $viewmode);
582 foreach ($newarrayoftype as $tmpkey => $tmpval) {
583 $newarrayoftype[$tmpkey][
'label'] =
img_picto(
'', $tmpval[
'picto'],
'class="pictofixedwidth"').$langs->trans($tmpval[
'label']);
586 print
'<div class="liste_titre liste_titre_bydiv liste_titre_bydiv_inlineblock centpercent">';
589 print
'<div class="divadvancedsearchfield center floatnone">';
590 print
'<div class="inline-block"><span class="opacitymedium">'.$langs->trans(
"StatisticsOn").
'</span></div> ';
591 print $form->selectarray(
'objecttype', $newarrayoftype, $objecttype, 0, 0, 0,
'', 1, 0, 0,
'',
'minwidth200', 1,
'', 0, 1);
592 if (empty($conf->use_javascript_ajax)) {
593 print
'<input type="submit" class="button buttongen button-save nomargintop" name="changeobjecttype" value="'.$langs->trans(
"Refresh").
'">';
595 print
'<!-- js code to reload page with good object type -->
596 <script nonce="'.getNonce().
'" type="text/javascript">
597 jQuery(document).ready(function() {
598 jQuery("#objecttype").change(function() {
599 console.log("Reload for "+jQuery("#objecttype").val());
600 location.href = "'.$_SERVER[
"PHP_SELF"].
'?objecttype="+jQuery("#objecttype").val()+"'.($tabfamily ?
'&tabfamily='.urlencode($tabfamily) :
'').(
GETPOSTINT(
'show_search_component_params_hidden') ?
'&show_search_component_params_hidden='.((int)
GETPOSTINT(
'show_search_component_params_hidden')) :
'').
'";
605 print
'</div><div class="clearboth"></div>';
609 print
'<div class="divadvancedsearchfield">';
610 print $form->searchComponent(array(
$object->element =>
$object->fields), $search_component_params, array(), $search_component_params_hidden);
617 print
'<div class="divadvancedsearchfield clearboth">';
618 print
'<div class="inline-block"><span class="fas fa-ruler-combined paddingright pictofixedwidth" title="'.dol_escape_htmltag($langs->trans(
"Measures")).
'"></span><span class="fas fa-caret-left caretleftaxis" title="'.
dol_escape_htmltag($langs->trans(
"Measures")).
'"></span></div>';
619 $simplearrayofmesures = array();
620 foreach ($arrayofmesures as $key => $val) {
621 $simplearrayofmesures[$key] = $arrayofmesures[$key][
'label'];
623 print $form->multiselectarray(
'search_measures', $simplearrayofmesures, $search_measures, 0, 0,
'minwidth300', 1, 0,
'',
'', $langs->trans(
"Measures"));
628 print
'<div class="divadvancedsearchfield">';
629 print
'<div class="inline-block"><span class="fas fa-ruler-combined paddingright pictofixedwidth" title="'.dol_escape_htmltag($langs->trans(
"XAxis")).
'"></span><span class="fas fa-caret-down caretdownaxis" title="'.
dol_escape_htmltag($langs->trans(
"XAxis")).
'"></span></div>';
631 print $formother->selectXAxisField(
$object, $search_xaxis, $arrayofxaxis, $langs->trans(
"XAxis"),
'minwidth300 maxwidth400');
636 print
'<div class="divadvancedsearchfield">';
637 print
'<div class="inline-block opacitymedium"><span class="fas fa-ruler-horizontal paddingright pictofixedwidth" title="'.dol_escape_htmltag($langs->trans(
"GroupBy")).
'"></span></div>';
638 print $formother->selectGroupByField(
$object, $search_groupby, $arrayofgroupby,
'minwidth250 maxwidth300', $langs->trans(
"GroupBy"));
642 if ($mode ==
'grid') {
644 print
'<div class="divadvancedsearchfield">';
645 foreach (
$object->fields as $key => $val) {
646 if (empty($val[
'measure']) && (!isset($val[
'enabled']) ||
dol_eval($val[
'enabled'], 1, 1,
'1'))) {
647 if (in_array($key, array(
'id',
'rowid',
'entity',
'last_main_doc',
'extraparams'))) {
650 if (preg_match(
'/^fk_/', $key)) {
653 if (in_array($val[
'type'], array(
'html',
'text'))) {
656 if (in_array($val[
'type'], array(
'timestamp',
'date',
'datetime'))) {
657 $arrayofyaxis[
't.'.$key.
'-year'] = array(
658 'label' => $langs->trans($val[
'label']).
' ('.$YYYY.
')',
659 'position' => $val[
'position'],
660 'table' =>
$object->table_element
662 $arrayofyaxis[
't.'.$key.
'-month'] = array(
663 'label' => $langs->trans($val[
'label']).
' ('.$YYYY.
'-'.$MM.
')',
664 'position' => $val[
'position'],
665 'table' =>
$object->table_element
667 $arrayofyaxis[
't.'.$key.
'-day'] = array(
668 'label' => $langs->trans($val[
'label']).
' ('.$YYYY.
'-'.$MM.
'-'.$DD.
')',
669 'position' => $val[
'position'],
670 'table' =>
$object->table_element
673 $arrayofyaxis[
't.'.$key] = array(
674 'label' => $val[
'label'],
675 'position' => (
int) $val[
'position'],
676 'table' =>
$object->table_element
682 if (
$object->isextrafieldmanaged) {
683 foreach ($extrafields->attributes[
$object->table_element][
'label'] as $key => $val) {
684 if (!empty($extrafields->attributes[
$object->table_element][
'totalizable'][$key]) && (!isset($extrafields->attributes[
$object->table_element][
'enabled'][$key]) ||
dol_eval($extrafields->attributes[
$object->table_element][
'enabled'][$key], 1, 1,
'1'))) {
685 $arrayofyaxis[
'te.'.$key] = array(
686 'label' => $extrafields->attributes[
$object->table_element][
'label'][$key],
687 'position' => (
int) $extrafields->attributes[
$object->table_element][
'pos'][$key],
688 'table' =>
$object->table_element
694 $arrayofyaxislabel = array();
695 foreach ($arrayofyaxis as $key => $val) {
696 $arrayofyaxislabel[$key] = $val[
'label'];
698 print
'<div class="inline-block opacitymedium"><span class="fas fa-ruler-vertical paddingright" title="'.$langs->trans(
"YAxis").
'"></span>'.$langs->trans(
"YAxis").
'</div> ';
699 print $form->multiselectarray(
'search_yaxis', $arrayofyaxislabel, $search_yaxis, 0, 0,
'minwidth100', 1);
703 if ($mode ==
'graph') {
707 print
'<div class="divadvancedsearchfield">';
708 print
'<input type="submit" class="button buttongen button-save nomargintop" value="'.$langs->trans(
"Refresh").
'">';
716if (!empty($search_measures) && !empty($search_xaxis)) {
722 foreach ($search_xaxis as $key => $val) {
723 if (preg_match(
'/\-year$/', $val)) {
724 $tmpval = preg_replace(
'/\-year$/',
'', $val);
725 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y') as x_".$key.
', ';
726 } elseif (preg_match(
'/\-month$/', $val)) {
727 $tmpval = preg_replace(
'/\-month$/',
'', $val);
728 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y-%m') as x_".$key.
', ';
729 } elseif (preg_match(
'/\-day$/', $val)) {
730 $tmpval = preg_replace(
'/\-day$/',
'', $val);
731 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y-%m-%d') as x_".$key.
', ';
733 $sql .= $val.
" as x_".$key.
", ";
736 if (!empty($search_groupby)) {
737 foreach ($search_groupby as $key => $val) {
738 if (preg_match(
'/\-year$/', $val)) {
739 $tmpval = preg_replace(
'/\-year$/',
'', $val);
740 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y') as g_".$key.
', ';
741 } elseif (preg_match(
'/\-month$/', $val)) {
742 $tmpval = preg_replace(
'/\-month$/',
'', $val);
743 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y-%m') as g_".$key.
', ';
744 } elseif (preg_match(
'/\-day$/', $val)) {
745 $tmpval = preg_replace(
'/\-day$/',
'', $val);
746 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y-%m-%d') as g_".$key.
', ';
748 $sql .= $val.
" as g_".$key.
", ";
752 foreach ($search_measures as $key => $val) {
753 if ($val ==
't.count') {
754 $sql .=
"COUNT(t.".$fieldid.
") as y_".$key.
', ';
755 } elseif (preg_match(
'/\-sum$/', $val)) {
756 $tmpval = preg_replace(
'/\-sum$/',
'', $val);
757 $sql .=
"SUM(".$db->ifsql($tmpval.
' IS NULL',
'0', $tmpval).
") as y_".$key.
", ";
758 } elseif (preg_match(
'/\-average$/', $val)) {
759 $tmpval = preg_replace(
'/\-average$/',
'', $val);
760 $sql .=
"AVG(".$db->ifsql($tmpval.
' IS NULL',
'0', $tmpval).
") as y_".$key.
", ";
761 } elseif (preg_match(
'/\-min$/', $val)) {
762 $tmpval = preg_replace(
'/\-min$/',
'', $val);
763 $sql .=
"MIN(".$db->ifsql($tmpval.
' IS NULL',
'0', $tmpval).
") as y_".$key.
", ";
764 } elseif (preg_match(
'/\-max$/', $val)) {
765 $tmpval = preg_replace(
'/\-max$/',
'', $val);
766 $sql .=
"MAX(".$db->ifsql($tmpval.
' IS NULL',
'0', $tmpval).
") as y_".$key.
", ";
769 $sql = preg_replace(
'/,\s*$/',
'', $sql);
770 $sql .=
" FROM ".MAIN_DB_PREFIX.$object->table_element.
" as t";
772 if (
$object->isextrafieldmanaged) {
773 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.$object->table_element.
"_extrafields as te ON te.fk_object = t.".$fieldid;
776 if (
$object->ismultientitymanaged) {
777 if (
$object->ismultientitymanaged == 1) {
780 $tmparray = explode(
'@',
$object->ismultientitymanaged);
781 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.$tmparray[1].
" as parenttableforentity ON t.".$tmparray[0].
" = parenttableforentity.rowid";
782 $sql .=
" AND parenttableforentity.entity IN (".getEntity($tmparray[1]).
")";
787 $listoftablesalreadyadded = array(
$object->table_element =>
$object->table_element);
791 foreach ($search_xaxis as $key => $val) {
792 if (!empty($arrayofxaxis[$val])) {
793 $tmpval = explode(
'.', $val);
796 foreach ($tmpforloop as $tmptable => $tmptablealias) {
797 if (! in_array($tmptable, $listoftablesalreadyadded)) {
798 $tmpforexplode = explode(
'__', $tmptablealias);
799 $endpart = end($tmpforexplode);
800 $parenttableandfield = preg_replace(
'/__'.$endpart.
'$/',
'', $tmptablealias).
'.'.$endpart;
802 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.$tmptable.
" as ".$db->sanitize($tmptablealias).
" ON ".$db->sanitize($parenttableandfield).
" = ".$db->sanitize($tmptablealias).
".rowid";
803 $listoftablesalreadyadded[$tmptable] = $tmptable;
805 if (preg_match(
'/^te/', $tmpval[0]) && preg_replace(
'/^t_/',
'te_', $tmptablealias) == $tmpval[0]) {
806 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.$tmptable.
"_extrafields as ".$db->sanitize($tmpval[0]).
" ON ".$db->sanitize($tmpval[0]).
".fk_object = ".$db->sanitize($tmptablealias).
".rowid";
807 $listoftablesalreadyadded[$tmptable] = $tmptable;
812 $errormessage =
'Found a key into search_xaxis not found into arrayofxaxis';
818 foreach ($search_groupby as $key => $val) {
819 if (!empty($arrayofgroupby[$val])) {
820 $tmpval = explode(
'.', $val);
823 foreach ($tmpforloop as $tmptable => $tmptablealias) {
824 if (! in_array($tmptable, $listoftablesalreadyadded)) {
825 $tmpforexplode = explode(
'__', $tmptablealias);
826 $endpart = end($tmpforexplode);
827 $parenttableandfield = preg_replace(
'/__'.$endpart.
'$/',
'', $tmptablealias).
'.'.$endpart;
829 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.$tmptable.
" as ".$db->sanitize($tmptablealias).
" ON ".$db->sanitize($parenttableandfield).
" = ".$db->sanitize($tmptablealias).
".rowid";
830 $listoftablesalreadyadded[$tmptable] = $tmptable;
832 if (preg_match(
'/^te/', $tmpval[0]) && preg_replace(
'/^t_/',
'te_', $tmptablealias) == $tmpval[0]) {
833 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.$tmptable.
"_extrafields as ".$db->sanitize($tmpval[0]).
" ON ".$db->sanitize($tmpval[0]).
".fk_object = ".$db->sanitize($tmptablealias).
".rowid";
834 $listoftablesalreadyadded[$tmptable] = $tmptable;
839 $errormessage =
'Found a key into search_groupby not found into arrayofgroupby';
845 foreach ($search_measures as $key => $val) {
846 if (!empty($arrayofmesures[$val])) {
847 $tmpval = explode(
'.', $val);
850 foreach ($tmpforloop as $tmptable => $tmptablealias) {
851 if (! in_array($tmptable, $listoftablesalreadyadded)) {
852 $tmpforexplode = explode(
'__', $tmptablealias);
853 $endpart = end($tmpforexplode);
854 $parenttableandfield = preg_replace(
'/__'.$endpart.
'$/',
'', $tmptablealias).
'.'.$endpart;
856 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.$tmptable.
" as ".$db->sanitize($tmptablealias).
" ON ".$db->sanitize($parenttableandfield).
" = ".$db->sanitize($tmptablealias).
".rowid";
857 $listoftablesalreadyadded[$tmptable] = $tmptable;
859 if (preg_match(
'/^te/', $tmpval[0]) && preg_replace(
'/^t_/',
'te_', $tmptablealias) == $tmpval[0]) {
860 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.$tmptable.
"_extrafields as ".$db->sanitize($tmpval[0]).
" ON ".$db->sanitize($tmpval[0]).
".fk_object = ".$db->sanitize($tmptablealias).
".rowid";
861 $listoftablesalreadyadded[$tmptable] = $tmptable;
866 $errormessage =
'Found a key into search_measures not found into arrayofmesures';
870 $sql .=
" WHERE 1 = 1";
871 if (
$object->ismultientitymanaged == 1) {
872 $sql .=
" AND t.entity IN (".getEntity(
$object->element).
")";
875 $sqlfilters = $search_component_params_hidden;
879 $sql .=
" GROUP BY ";
880 foreach ($search_xaxis as $key => $val) {
881 if (preg_match(
'/\-year$/', $val)) {
882 $tmpval = preg_replace(
'/\-year$/',
'', $val);
883 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y'), ";
884 } elseif (preg_match(
'/\-month$/', $val)) {
885 $tmpval = preg_replace(
'/\-month$/',
'', $val);
886 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y-%m'), ";
887 } elseif (preg_match(
'/\-day$/', $val)) {
888 $tmpval = preg_replace(
'/\-day$/',
'', $val);
889 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y-%m-%d'), ";
894 if (!empty($search_groupby)) {
895 foreach ($search_groupby as $key => $val) {
896 if (preg_match(
'/\-year$/', $val)) {
897 $tmpval = preg_replace(
'/\-year$/',
'', $val);
898 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y'), ";
899 } elseif (preg_match(
'/\-month$/', $val)) {
900 $tmpval = preg_replace(
'/\-month$/',
'', $val);
901 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y-%m'), ";
902 } elseif (preg_match(
'/\-day$/', $val)) {
903 $tmpval = preg_replace(
'/\-day$/',
'', $val);
904 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y-%m-%d'), ";
910 $sql = preg_replace(
'/,\s*$/',
'', $sql);
911 $sql .=
' ORDER BY ';
912 foreach ($search_xaxis as $key => $val) {
913 if (preg_match(
'/\-year$/', $val)) {
914 $tmpval = preg_replace(
'/\-year$/',
'', $val);
915 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y'), ";
916 } elseif (preg_match(
'/\-month$/', $val)) {
917 $tmpval = preg_replace(
'/\-month$/',
'', $val);
918 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y-%m'), ";
919 } elseif (preg_match(
'/\-day$/', $val)) {
920 $tmpval = preg_replace(
'/\-day$/',
'', $val);
921 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y-%m-%d'), ";
926 if (!empty($search_groupby)) {
927 foreach ($search_groupby as $key => $val) {
928 if (preg_match(
'/\-year$/', $val)) {
929 $tmpval = preg_replace(
'/\-year$/',
'', $val);
930 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y'), ";
931 } elseif (preg_match(
'/\-month$/', $val)) {
932 $tmpval = preg_replace(
'/\-month$/',
'', $val);
933 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y-%m'), ";
934 } elseif (preg_match(
'/\-day$/', $val)) {
935 $tmpval = preg_replace(
'/\-day$/',
'', $val);
936 $sql .=
"DATE_FORMAT(".$tmpval.
", '%Y-%m-%d'), ";
942 $sql = preg_replace(
'/,\s*$/',
'', $sql);
945 if (!empty($customsql)) {
952 print
'<div class="warning">';
960foreach ($search_measures as $key => $val) {
961 $legend[] = $langs->trans($arrayofmesures[$val][
'label']);
964$useagroupby = (is_array($search_groupby) && count($search_groupby));
972 $resql = $db->query($sql);
974 print
'<div class="warning">';
982 while ($obj = $db->fetch_object($resql)) {
985 $xval = $search_xaxis[0];
986 $fieldforxkey =
'x_0';
987 $xlabel = $obj->$fieldforxkey;
988 $xvalwithoutprefix = preg_replace(
'/^[a-z]+\./',
'', $xval);
991 if (!empty(
$object->fields[$xvalwithoutprefix][
'arrayofkeyval'])) {
992 $xlabel =
$object->fields[$xvalwithoutprefix][
'arrayofkeyval'][$obj->$fieldforxkey];
994 $labeltouse = (($xlabel || $xlabel ==
'0') ?
dol_trunc($xlabel, 20,
'middle') : ($xlabel ===
'' ? $langs->transnoentitiesnoconv(
"Empty") : $langs->transnoentitiesnoconv(
"NotDefined")));
996 if ($oldlabeltouse !==
'' && ($labeltouse != $oldlabeltouse)) {
1000 $oldlabeltouse = $labeltouse;
1013 foreach ($search_measures as $key => $val) {
1015 foreach ($search_groupby as $gkey) {
1018 foreach ($arrayofvaluesforgroupby[
'g_'.$gi] as $gvaluepossiblekey => $gvaluepossiblelabel) {
1019 $ykeysuffix = $gvaluepossiblelabel;
1020 $gvalwithoutprefix = preg_replace(
'/^[a-z]+\./',
'', $gval);
1022 $fieldfory =
'y_'.$key;
1023 $fieldforg =
'g_'.$gi;
1024 $fieldforybis =
'y_'.$key.
'_'.$ykeysuffix;
1028 if (!is_array($data[$xi])) {
1029 $data[$xi] = array();
1032 if (!array_key_exists(
'label', $data[$xi])) {
1033 $data[$xi] = array();
1034 $data[$xi][
'label'] = $labeltouse;
1037 $objfieldforg = $obj->$fieldforg;
1038 if (is_null($objfieldforg)) {
1039 $objfieldforg =
'__NULL__';
1042 if ($gvaluepossiblekey ==
'0') {
1044 if ($objfieldforg ==
'0') {
1046 $data[$xi][$fieldforybis] = $obj->$fieldfory;
1047 } elseif (!isset($data[$xi][$fieldforybis])) {
1049 $data[$xi][$fieldforybis] =
'0';
1053 if ((
string) $objfieldforg === (
string) $gvaluepossiblekey) {
1055 $data[$xi][$fieldforybis] = $obj->$fieldfory;
1056 } elseif (!isset($data[$xi][$fieldforybis])) {
1058 $data[$xi][$fieldforybis] =
'0';
1067 $xval = $search_xaxis[0];
1068 $fieldforxkey =
'x_0';
1069 $xlabel = $obj->$fieldforxkey;
1070 $xvalwithoutprefix = preg_replace(
'/^[a-z]+\./',
'', $xval);
1073 if (!empty(
$object->fields[$xvalwithoutprefix][
'arrayofkeyval'])) {
1074 $xlabel =
$object->fields[$xvalwithoutprefix][
'arrayofkeyval'][$obj->$fieldforxkey];
1077 $labeltouse = (($xlabel || $xlabel ==
'0') ?
dol_trunc($xlabel, 20,
'middle') : ($xlabel ===
'' ? $langs->transnoentitiesnoconv(
"Empty") : $langs->transnoentitiesnoconv(
"NotDefined")));
1078 $xarrayforallseries = array(
'label' => $labeltouse);
1079 foreach ($search_measures as $key => $val) {
1080 $fieldfory =
'y_'.$key;
1081 $xarrayforallseries[$fieldfory] = $obj->$fieldfory;
1083 $data[$xi] = $xarrayforallseries;
1088 $totalnbofrecord = count($data);
1093print
'<!-- Section to show the result -->'.
"\n";
1094print
'<div class="customreportsoutput'.($totalnbofrecord ?
'' :
' customreportsoutputnotdata').
'">';
1097if ($mode ==
'grid') {
1101if ($mode ==
'graph') {
1103 $HEIGHT = (empty($_SESSION[
'dol_screenheight']) ? 400 : $_SESSION[
'dol_screenheight'] - 500);
1107 $mesg = $px1->isGraphKo();
1111 $px1->SetData($data);
1114 $arrayoftypes = array();
1115 foreach ($search_measures as $key => $val) {
1116 $arrayoftypes[] = $search_graph;
1119 $px1->SetLegend($legend);
1120 $px1->setShowLegend($SHOWLEGEND);
1121 $px1->SetMinValue($px1->GetFloorMinValue());
1122 $px1->SetMaxValue($px1->GetCeilMaxValue());
1123 $px1->SetWidth($WIDTH);
1124 $px1->SetHeight($HEIGHT);
1125 $px1->SetYLabel($langs->trans(
"Y"));
1126 $px1->SetShading(3);
1127 $px1->SetHorizTickIncrement(1);
1128 $px1->SetCssPrefix(
"cssboxes");
1129 $px1->SetType($arrayoftypes);
1130 $px1->mode =
'depth';
1133 $dir = $conf->user->dir_temp;
1136 $filenamekey = $dir.
'/customreport_'.
$object->element.(empty($customreportkey) ?
'' : $customreportkey).
'.png';
1137 $fileurlkey = DOL_URL_ROOT.
'/viewimage.php?modulepart=user&file=customreport_'.
$object->element.(empty($customreportkey) ?
'' : $customreportkey).
'.png';
1139 $px1->draw($filenamekey, $fileurlkey);
1141 $texttoshow = $langs->trans(
"NoRecordFound");
1142 if (!GETPOSTISSET(
'search_measures') || !GETPOSTISSET(
'search_xaxis')) {
1143 $texttoshow = $langs->trans(
"SelectYourGraphOptionsFirst");
1146 print $px1->show($totalnbofrecord ? 0 : $texttoshow);
1150if ($sql && !defined(
'MAIN_CUSTOM_REPORT_KEEP_GRAPH_ONLY')) {
1152 print
'<br>'.info_admin($langs->trans(
"SQLUsedForExport").
':<br> '.$sql, 0, 0, 1,
'',
'TechnicalInformation');
1157if (!defined(
'USE_CUSTOM_REPORT_AS_INCLUDE')) {
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()
Empty header.
fillArrayOfGroupBy($object, $tablealias, $labelofobject, &$arrayofgroupby, $level=0, &$count=0, &$tablepath='')
Fill arrayofgrupby for an object.
fillArrayOfMeasures($object, $tablealias, $labelofobject, &$arrayofmesures, $level=0, &$count=0, &$tablepath='')
Fill arrayofmesures for an object.
fillArrayOfXAxis($object, $tablealias, $labelofobject, &$arrayofxaxis, $level=0, &$count=0, &$tablepath='')
Fill arrayofmesures for an object.
dol_get_last_day($year, $month=12, $gm=false)
Return GMT time for last day of a month or year.
dolCheckFilters($sqlfilters, &$error='', &$parenthesislevel=0)
Return if a $sqlfilters parameter has a valid balance of parenthesis.
dolForgeExplodeAnd($sqlfilters)
Explode an universal search string with AND parts.
dolExplodeIntoArray($string, $delimiter=';', $kv='=')
Split a string with 2 keys into key array.
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.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
dol_eval($s, $returnvalue=1, $hideerrors=1, $onlysimplestring='1')
Replace eval function to add more security.
forgeSQLFromUniversalSearchCriteria($filter, &$errorstr='', $noand=0, $nopar=0, $noerror=0)
forgeSQLFromUniversalSearchCriteria
dol_now($mode='auto')
Return date for now.
dol_sort_array(&$array, $index, $order='asc', $natsort=0, $case_sensitive=0, $keepindex=0)
Advanced sort array by the value of a given key, which produces ascending (default) or descending out...
if(!function_exists( 'dol_getprefix')) dol_include_once($relpath, $classname='')
Make an include_once using default root and alternate root if it fails.
print_barre_liste($title, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $hideselectlimit=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0)
Set event messages in dol_events session object.
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.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_getdate($timestamp, $fast=false, $forcetimezone='')
Return an array with locale date info.
dol_mkdir($dir, $dataroot='', $newmask='')
Creation of a directory (this can create recursive subdir)
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $mode=0)
Check permissions of a user to show a page and an object.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.