dolibarr 19.0.3
account_statement_document.php
1<?php
2/* Copyright (C) 2003-2007 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2004-2008 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2005 Marc Barilley / Ocebo <marc@ocebo.com>
5 * Copyright (C) 2005-2017 Regis Houssin <regis.houssin@inodbox.com>
6 * Copyright (C) 2019 Nicolas ZABOURI <info@inovea-conseil.com>
7 *
8 * This program is free software; you can redistribute it and/or modify
9 * it under the terms of the GNU General Public License as published by
10 * the Free Software Foundation; either version 3 of the License, or
11 * (at your option) any later version.
12 *
13 * This program is distributed in the hope that it will be useful,
14 * but WITHOUT ANY WARRANTY; without even the implied warranty of
15 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 * GNU General Public License for more details.
17 *
18 * You should have received a copy of the GNU General Public License
19 * along with this program. If not, see <https://www.gnu.org/licenses/>.
20 */
21
27require '../../main.inc.php';
28require_once DOL_DOCUMENT_ROOT."/core/lib/bank.lib.php";
29require_once DOL_DOCUMENT_ROOT."/core/lib/files.lib.php";
30require_once DOL_DOCUMENT_ROOT."/core/lib/images.lib.php";
31require_once DOL_DOCUMENT_ROOT."/core/class/html.formfile.class.php";
32require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php';
33
34global $conf, $db, $langs;
35// Load translation files required by the page
36$langs->loadLangs(array('banks', 'companies', 'other'));
37
38$id = (GETPOST('id', 'int') ? GETPOST('id', 'int') : GETPOST('account', 'int'));
39$ref = GETPOST('ref', 'alpha');
40$action = GETPOST('action', 'aZ09');
41$confirm = GETPOST('confirm', 'alpha');
42$numref = (GETPOST('num', 'alpha') ? GETPOST('num', 'alpha') : GETPOST('sectionid', 'alpha'));
43
44// Security check
45if ($user->socid) {
46 $action = '';
47 $socid = $user->socid;
48}
49if ($user->socid) {
50 $socid = $user->socid;
51}
52
53// Get parameters
54$limit = GETPOST('limit', 'int') ? GETPOST('limit', 'int') : $conf->liste_limit;
55$sortfield = GETPOST('sortfield', 'aZ09comma');
56$sortorder = GETPOST('sortorder', 'aZ09comma');
57$page = GETPOSTISSET('pageplusone') ? (GETPOST('pageplusone') - 1) : GETPOST("page", 'int');
58if (empty($page) || $page == -1) {
59 $page = 0;
60}
61$offset = $limit * $page;
62$pageprev = $page - 1;
63$pagenext = $page + 1;
64if (!$sortorder) {
65 $sortorder = "ASC";
66}
67if (!$sortfield) {
68 $sortfield = "name";
69}
70
71$object = new Account($db);
72if ($id > 0 || !empty($ref)) {
73 $result = $object->fetch($id, $ref);
74 $account = $object->id; // Force the search field on id of account
75}
76
77$result = restrictedArea($user, 'banque', $object->id, 'bank_account', '', '');
78
79// Define number of receipt to show (current, previous or next one ?)
80$found = false;
81if (GETPOST("rel") == 'prev') {
82 // Recherche valeur pour num = numero releve precedent
83 $sql = "SELECT DISTINCT(b.num_releve) as num";
84 $sql .= " FROM ".MAIN_DB_PREFIX."bank as b";
85 $sql .= " WHERE b.num_releve < '".$db->escape($numref)."'";
86 $sql .= " AND b.fk_account = ".((int) $id);
87 $sql .= " ORDER BY b.num_releve DESC";
88
89 dol_syslog("htdocs/compta/bank/releve.php", LOG_DEBUG);
90 $resql = $db->query($sql);
91 if ($resql) {
92 $numrows = $db->num_rows($resql);
93 if ($numrows > 0) {
94 $obj = $db->fetch_object($resql);
95 $numref = $obj->num;
96 $found = true;
97 }
98 }
99} elseif (GETPOST("rel") == 'next') {
100 // Recherche valeur pour num = numero releve precedent
101 $sql = "SELECT DISTINCT(b.num_releve) as num";
102 $sql .= " FROM ".MAIN_DB_PREFIX."bank as b";
103 $sql .= " WHERE b.num_releve > '".$db->escape($numref)."'";
104 $sql .= " AND b.fk_account = ".((int) $id);
105 $sql .= " ORDER BY b.num_releve ASC";
106
107 dol_syslog("htdocs/compta/bank/releve.php", LOG_DEBUG);
108 $resql = $db->query($sql);
109 if ($resql) {
110 $numrows = $db->num_rows($resql);
111 if ($numrows > 0) {
112 $obj = $db->fetch_object($resql);
113 $numref = $obj->num;
114 $found = true;
115 }
116 }
117} else {
118 // On veut le releve num
119 $found = true;
120}
121
122$permissiontoadd = $user->rights->banque->modifier; // Used by the include of actions_dellink.inc.php
123
124
125/*
126 * Actions
127 */
128
129if (!empty($numref)) {
130 $object->fetch_thirdparty();
131 $upload_dir = $conf->bank->dir_output."/".$id."/statement/".dol_sanitizeFileName($numref);
132}
133$backtopage = $_SERVER['PHP_SELF']."?account=".urlencode($id)."&num=".urlencode($numref);
134include DOL_DOCUMENT_ROOT.'/core/actions_linkedfiles.inc.php';
135
136
137/*
138 * View
139 */
140
141$form = new Form($db);
142
143$title = $langs->trans("FinancialAccount").' - '.$langs->trans("Documents");
144$helpurl = "";
145llxHeader('', $title, $helpurl);
146
147if ($id > 0 || !empty($ref)) {
148 if ($object->fetch($id, $ref)) {
149 $upload_dir = $conf->bank->dir_output."/".$id."/statement/".dol_sanitizeFileName($numref);
150
151 // Onglets
152 $head = account_statement_prepare_head($object, $numref);
153 print dol_get_fiche_head($head, 'document', $langs->trans("AccountStatement"), -1, 'account');
154
155
156 // Build file list
157 $filearray = dol_dir_list($upload_dir, "files", 0, '', '\.meta$', $sortfield, (strtolower($sortorder) == 'desc' ? SORT_DESC : SORT_ASC), 1);
158 $totalsize = 0;
159 foreach ($filearray as $key => $file) {
160 $totalsize += $file['size'];
161 }
162
163 $morehtmlright = '';
164 $morehtmlright .= '<div class="pagination"><ul>';
165 $morehtmlright .= '<li class="pagination"><a class="paginationnext" href="'.$_SERVER["PHP_SELF"].'?rel=prev&amp;num='.$numref.'&amp;ve='.$ve.'&amp;account='.$object->id.'"><i class="fa fa-chevron-left" title="'.dol_escape_htmltag($langs->trans("Previous")).'"></i></a></li>';
166 $morehtmlright .= '<li class="pagination"><span class="active">'.$langs->trans("AccountStatement")." ".$numref.'</span></li>';
167 $morehtmlright .= '<li class="pagination"><a class="paginationnext" href="'.$_SERVER["PHP_SELF"].'?rel=next&amp;num='.$numref.'&amp;ve='.$ve.'&amp;account='.$object->id.'"><i class="fa fa-chevron-right" title="'.dol_escape_htmltag($langs->trans("Next")).'"></i></a></li>';
168 $morehtmlright .= '</ul></div>';
169
170 $title = $langs->trans("AccountStatement").' '.$numref.' - '.$langs->trans("BankAccount").' '.$object->getNomUrl(1, 'receipts');
171 print load_fiche_titre($title, $morehtmlright, '');
172
173 print '<div class="fichecenter">';
174 print '<div class="underbanner clearboth"></div>';
175
176 print '<table class="border tableforfield centpercent">';
177 print '<tr><td class="titlefield">'.$langs->trans("NbOfAttachedFiles").'</td><td colspan="3">'.count($filearray).'</td></tr>';
178 print '<tr><td>'.$langs->trans("TotalSizeOfAttachedFiles").'</td><td colspan="3">'.dol_print_size($totalsize, 1, 1).'</td></tr>';
179 print "</table>\n";
180
181 print '</div>';
182
183 print dol_get_fiche_end();
184
185
186 $modulepart = 'bank';
187 $permissiontoadd = $user->rights->banque->modifier;
188 $permtoedit = $user->rights->banque->modifier;
189 $param = '&id='.$object->id.'&num='.urlencode($numref);
190 $moreparam = '&num='.urlencode($numref);
191 $relativepathwithnofile = $id."/statement/".dol_sanitizeFileName($numref)."/";
192 include DOL_DOCUMENT_ROOT.'/core/tpl/document_actions_post_headers.tpl.php';
193 } else {
194 dol_print_error($db);
195 }
196} else {
197 header('Location: index.php');
198 exit;
199}
200
201// End of page
202llxFooter();
203$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
account_statement_prepare_head($object, $num)
Prepare array with list of tabs.
Definition bank.lib.php:194
Class to manage bank accounts.
Class to manage generation of HTML components Only common components must be here.
dol_dir_list($path, $types="all", $recursive=0, $filter="", $excludefilter=null, $sortcriteria="name", $sortorder=SORT_ASC, $mode=0, $nohook=0, $relativename="", $donotfollowsymlinks=0, $nbsecondsold=0)
Scan a directory and return a list of files/directories.
Definition files.lib.php:62
dol_print_size($size, $shortvalue=0, $shortunit=0)
Return string with formated size.
load_fiche_titre($titre, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
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_print_error($db='', $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_get_fiche_end($notab=0)
Return tab footer of a card.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
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.