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';
34global $conf, $db, $langs;
36$langs->loadLangs(array(
'banks',
'companies',
'other'));
40$action =
GETPOST(
'action',
'aZ09');
41$confirm =
GETPOST(
'confirm',
'alpha');
47 $socid = $user->socid;
50 $socid = $user->socid;
55$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
56$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
58if (empty($page) || $page == -1) {
61$offset = $limit * $page;
72if ($id > 0 || !empty($ref)) {
73 $result =
$object->fetch($id, $ref);
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";
89 dol_syslog(
"htdocs/compta/bank/releve.php", LOG_DEBUG);
90 $resql = $db->query($sql);
92 $numrows = $db->num_rows($resql);
94 $obj = $db->fetch_object($resql);
99} elseif (
GETPOST(
"rel") ==
'next') {
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";
107 dol_syslog(
"htdocs/compta/bank/releve.php", LOG_DEBUG);
108 $resql = $db->query($sql);
110 $numrows = $db->num_rows($resql);
112 $obj = $db->fetch_object($resql);
122$permissiontoadd = $user->hasRight(
'banque',
'modifier');
129if (!empty($numref)) {
133$backtopage = $_SERVER[
'PHP_SELF'].
"?account=".urlencode((
string) ($id)).
"&num=".urlencode((
string) ($numref));
134include DOL_DOCUMENT_ROOT.
'/core/actions_linkedfiles.inc.php';
141$form =
new Form($db);
143$title = $langs->trans(
"FinancialAccount").
' - '.$langs->trans(
"Documents");
147if ($id > 0 || !empty($ref)) {
148 if (
$object->fetch($id, $ref)) {
153 print
dol_get_fiche_head($head,
'document', $langs->trans(
"AccountStatement"), -1,
'account');
157 $filearray =
dol_dir_list($upload_dir,
"files", 0,
'',
'\.meta$', $sortfield, (strtolower($sortorder) ==
'desc' ? SORT_DESC : SORT_ASC), 1);
159 foreach ($filearray as $key => $file) {
160 $totalsize += $file[
'size'];
164 $morehtmlright .=
'<div class="pagination"><ul>';
165 $morehtmlright .=
'<li class="pagination"><a class="paginationnext" href="'.$_SERVER[
"PHP_SELF"].
'?rel=prev&num='.$numref.
'&ve='.$ve.
'&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&num='.$numref.
'&ve='.$ve.
'&account='.
$object->id.
'"><i class="fa fa-chevron-right" title="'.
dol_escape_htmltag($langs->trans(
"Next")).
'"></i></a></li>';
168 $morehtmlright .=
'</ul></div>';
170 $title = $langs->trans(
"AccountStatement").
' '.$numref.
' - '.$langs->trans(
"BankAccount").
' '.
$object->getNomUrl(1,
'receipts');
173 print
'<div class="fichecenter">';
174 print
'<div class="underbanner clearboth"></div>';
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>';
186 $modulepart =
'bank';
187 $permissiontoadd = $user->hasRight(
'banque',
'modifier');
188 $permtoedit = $user->hasRight(
'banque',
'modifier');
189 $param =
'&id='.$object->id.
'&num='.urlencode($numref);
190 $moreparam =
'&num='.urlencode($numref);
192 include DOL_DOCUMENT_ROOT.
'/core/tpl/document_actions_post_headers.tpl.php';
197 header(
'Location: index.php');
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.
account_statement_prepare_head($object, $num)
Prepare array with list of tabs.
Class to manage bank accounts.
dol_dir_list($utf8_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.
dol_print_size($size, $shortvalue=0, $shortunit=0)
Return string with formatted size.
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
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.
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_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
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.