dolibarr 20.0.0
index.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2001-2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2003 Eric Seigne <erics@rycks.com>
4 * Copyright (C) 2004-2016 Laurent Destailleur <eldy@users.sourceforge.net>
5 * Copyright (C) 2005-2012 Regis Houssin <regis.houssin@inodbox.com>
6 *
7 * This program is free software; you can redistribute it and/or modify
8 * it under the terms of the GNU General Public License as published by
9 * the Free Software Foundation; either version 3 of the License, or
10 * (at your option) any later version.
11 *
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU General Public License for more details.
16 *
17 * You should have received a copy of the GNU General Public License
18 * along with this program. If not, see <https://www.gnu.org/licenses/>.
19 */
20
27// Load Dolibarr environment
28require '../../../main.inc.php';
29require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
30require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
31require_once DOL_DOCUMENT_ROOT.'/contact/class/contact.class.php';
32require_once DOL_DOCUMENT_ROOT.'/comm/action/class/actioncomm.class.php';
33
34// Load translation files required by the page
35$langs->loadLangs(array("agenda", "commercial"));
36
37$action = GETPOST('action', 'aZ09');
38$month = GETPOSTINT('month');
39$year = GETPOSTINT('year');
40
41$optioncss = GETPOST('optioncss', 'alpha');
42$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
43$sortfield = GETPOST('sortfield', 'aZ09comma');
44$sortorder = GETPOST('sortorder', 'aZ09comma');
45$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
46if (empty($page) || $page < 0 || GETPOST('button_search', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
47 // If $page is not defined, or '' or -1 or if we click on clear filters
48 $page = 0;
49}
50$offset = $limit * $page;
51if (!$sortorder) {
52 $sortorder = "DESC";
53}
54if (!$sortfield) {
55 $sortfield = "a.datep";
56}
57
58// Security check
59//$result = restrictedArea($user, 'agenda', 0, '', 'myactions');
60if (!$user->hasRight("agenda", "allactions", "read")) {
62}
63
64
65/*
66 * Actions
67 */
68
69if ($action == 'builddoc' && $user->hasRight("agenda", "allactions", "read")) {
70 require_once DOL_DOCUMENT_ROOT.'/core/modules/action/doc/pdf_standard_actions.class.php';
71
72 $cat = new pdf_standard_actions($db, $month, $year);
73 $result = $cat->write_file(0, $langs);
74 if ($result < 0) {
75 setEventMessages($cat->error, $cat->errors, 'errors');
76 }
77}
78
79
80/*
81 * View
82 */
83
84$formfile = new FormFile($db);
85
86llxHeader();
87
88$sql = "SELECT count(*) as cc,";
89$sql .= " date_format(a.datep, '%m/%Y') as df,";
90$sql .= " date_format(a.datep, '%m') as month,";
91$sql .= " date_format(a.datep, '%Y') as year";
92$sql .= " FROM ".MAIN_DB_PREFIX."actioncomm as a,";
93$sql .= " ".MAIN_DB_PREFIX."user as u";
94$sql .= " WHERE a.fk_user_author = u.rowid";
95$sql .= ' AND a.entity IN ('.getEntity('agenda').')';
96//$sql.= " AND percent = 100";
97$sql .= " GROUP BY year, month, df";
98$sql .= " ORDER BY year DESC, month DESC, df DESC";
99
100$nbtotalofrecords = '';
101if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
102 $result = $db->query($sql);
103 $nbtotalofrecords = $db->num_rows($result);
104 if (($page * $limit) > $nbtotalofrecords) { // if total resultset is smaller then paging size (filtering), goto and load page 0
105 $page = 0;
106 $offset = 0;
107 }
108}
109
110$sql .= $db->plimit($limit + 1, $offset);
111
112//print $sql;
113dol_syslog("select", LOG_DEBUG);
114$resql = $db->query($sql);
115if ($resql) {
116 $num = $db->num_rows($resql);
117
118 $param = '';
119 if ($limit > 0 && $limit != $conf->liste_limit) {
120 $param .= '&limit='.$limit;
121 }
122
123 print '<form method="POST" id="searchFormList" action="'.$_SERVER["PHP_SELF"].'">';
124 if ($optioncss != '') {
125 print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
126 }
127 print '<input type="hidden" name="token" value="'.newToken().'">';
128 print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
129 print '<input type="hidden" name="action" value="list">';
130 print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
131 print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
132
133 // @phan-suppress-next-line PhanPluginSuspiciousParamOrder
134 print_barre_liste($langs->trans("EventReports"), $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', $num, $nbtotalofrecords, 'title_agenda', 0, '', '', $limit, 0, 0, 1);
135
136 $moreforfilter = '';
137
138 $i = 0;
139 print '<div class="div-table-responsive">';
140 print '<table class="tagtable liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n";
141
142 print '<tr class="liste_titre">';
143 print '<td>'.$langs->trans("Period").'</td>';
144 print '<td class="center">'.$langs->trans("EventsNb").'</td>';
145 print '<td class="center">'.$langs->trans("Action").'</td>';
146 print '<td>'.$langs->trans("PDF").'</td>';
147 print '<td class="center">'.$langs->trans("Date").'</td>';
148 print '<td class="center">'.$langs->trans("Size").'</td>';
149 print "</tr>\n";
150
151 while ($i < min($num, $limit)) {
152 $obj = $db->fetch_object($resql);
153
154 if ($obj) {
155 print '<tr class="oddeven">';
156
157 // Date
158 print "<td>".$obj->df."</td>\n";
159
160 // Nb of events
161 print '<td class="center">'.$obj->cc.'</td>';
162
163 // Button to build doc
164 print '<td class="center">';
165 print '<a class="reposition" href="'.$_SERVER["PHP_SELF"].'?action=builddoc&token='.newToken().'&page='.((int) $page).'&month='.((int) $obj->month).'&year='.((int) $obj->year).'">'.img_picto($langs->trans('BuildDoc'), 'filenew').'</a>';
166 print '</td>';
167
168 $name = "actions-".$obj->month."-".$obj->year.".pdf";
169 $relativepath = $name;
170 $file = $conf->agenda->dir_temp."/".$name;
171 $modulepart = 'actionsreport';
172 $documenturl = DOL_URL_ROOT.'/document.php';
173 if (isset($conf->global->DOL_URL_ROOT_DOCUMENT_PHP)) {
174 $documenturl = getDolGlobalString('DOL_URL_ROOT_DOCUMENT_PHP'); // To use another wrapper
175 }
176
177 if (file_exists($file)) {
178 print '<td class="tdoverflowmax300">';
179 //print '<a data-ajax="false" href="'.DOL_URL_ROOT.'/document.php?page='.$page.'&amp;file='.urlencode($relativepath).'&amp;modulepart=actionsreport">'.img_pdf().'</a>';
180
181 $filearray = array('name' => basename($file), 'fullname' => $file, 'type' => 'file');
182 $out = '';
183
184 // Show file name with link to download
185 $out .= '<a href="'.$documenturl.'?modulepart='.$modulepart.'&amp;file='.urlencode($relativepath).($param ? '&'.$param : '').'"';
186 $mime = dol_mimetype($relativepath, '', 0);
187 $out .= ' target="_blank" rel="noopener noreferrer">';
188 $out .= img_mime($filearray["name"], $langs->trans("File").': '.$filearray["name"]);
189 $out .= $filearray["name"];
190 $out .= '</a>'."\n";
191 $out .= $formfile->showPreview($filearray, $modulepart, $relativepath, 0, $param);
192 print $out;
193
194 print '</td>';
195 print '<td class="center">'.dol_print_date(dol_filemtime($file), 'dayhour').'</td>';
196 print '<td class="center">'.dol_print_size(dol_filesize($file)).'</td>';
197 } else {
198 print '<td>&nbsp;</td>';
199 print '<td>&nbsp;</td>';
200 print '<td>&nbsp;</td>';
201 }
202
203 print "</tr>\n";
204 }
205 $i++;
206 }
207 print "</table>";
208 print '</div>';
209 print '</form>';
210
211 $db->free($resql);
212} else {
213 dol_print_error($db);
214}
215
216// End of page
217llxFooter();
218$db->close();
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader()
Empty header.
Definition wrapper.php:55
llxFooter()
Empty footer.
Definition wrapper.php:69
Class to offer components to list and upload files.
Class to generate event report.
dol_filemtime($pathoffile)
Return time of a file.
dol_filesize($pathoffile)
Return size of a file.
dol_mimetype($file, $default='application/octet-stream', $mode=0)
Return MIME type of a file from its name with extension.
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.
img_mime($file, $titlealt='', $morecss='')
Show MIME img of a file.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
newToken()
Return the value of token currently saved into session with name 'newtoken'.
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...
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.