28 require
'../../main.inc.php';
29 require_once DOL_DOCUMENT_ROOT.
"/core/lib/bank.lib.php";
30 require_once DOL_DOCUMENT_ROOT.
"/core/lib/files.lib.php";
31 require_once DOL_DOCUMENT_ROOT.
"/core/lib/images.lib.php";
32 require_once DOL_DOCUMENT_ROOT.
"/core/class/html.formfile.class.php";
33 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
35 global $conf, $db, $langs;
37 $langs->loadLangs(array(
'banks',
'companies',
'other'));
41 $action =
GETPOST(
'action',
'aZ09');
42 $confirm =
GETPOST(
'confirm',
'alpha');
48 $socid = $user->socid;
51 $socid = $user->socid;
55 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
56 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
57 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
59 if (empty($page) || $page == -1) {
62 $offset = $limit * $page;
63 $pageprev = $page - 1;
64 $pagenext = $page + 1;
73 if ($id > 0 || !empty($ref)) {
74 $result = $object->fetch($id, $ref);
75 $account = $object->id;
78 $result =
restrictedArea($user,
'banque', $object->id,
'bank_account',
'',
'');
84 $sql =
"SELECT DISTINCT(b.num_releve) as num";
85 $sql .=
" FROM ".MAIN_DB_PREFIX.
"bank as b";
86 $sql .=
" WHERE b.num_releve < '".$db->escape($numref).
"'";
87 $sql .=
" AND b.fk_account = ".((int) $id);
88 $sql .=
" ORDER BY b.num_releve DESC";
90 dol_syslog(
"htdocs/compta/bank/releve.php", LOG_DEBUG);
93 $numrows = $db->num_rows(
$resql);
95 $obj = $db->fetch_object(
$resql);
100 } elseif (
GETPOST(
"rel") ==
'next') {
102 $sql =
"SELECT DISTINCT(b.num_releve) as num";
103 $sql .=
" FROM ".MAIN_DB_PREFIX.
"bank as b";
104 $sql .=
" WHERE b.num_releve > '".$db->escape($numref).
"'";
105 $sql .=
" AND b.fk_account = ".((int) $id);
106 $sql .=
" ORDER BY b.num_releve ASC";
108 dol_syslog(
"htdocs/compta/bank/releve.php", LOG_DEBUG);
109 $resql = $db->query($sql);
111 $numrows = $db->num_rows(
$resql);
113 $obj = $db->fetch_object(
$resql);
123 $permissiontoadd = $user->rights->banque->modifier;
130 if (!empty($numref)) {
131 $object->fetch_thirdparty();
134 $backtopage = $_SERVER[
'PHP_SELF'].
"?account=".urlencode($id).
"&num=".urlencode($numref);
135 include DOL_DOCUMENT_ROOT.
'/core/actions_linkedfiles.inc.php';
144 $title = $langs->trans(
"FinancialAccount").
' - '.$langs->trans(
"Documents");
148 if ($id > 0 || !empty($ref)) {
149 if ($object->fetch($id, $ref)) {
154 print
dol_get_fiche_head($head,
'document', $langs->trans(
"AccountStatement"), -1,
'account');
158 $filearray =
dol_dir_list($upload_dir,
"files", 0,
'',
'\.meta$', $sortfield, (strtolower($sortorder) ==
'desc' ? SORT_DESC : SORT_ASC), 1);
160 foreach ($filearray as $key => $file) {
161 $totalsize += $file[
'size'];
165 $morehtmlright .=
'<div class="pagination"><ul>';
166 $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>';
167 $morehtmlright .=
'<li class="pagination"><span class="active">'.$langs->trans(
"AccountStatement").
" ".$numref.
'</span></li>';
168 $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>';
169 $morehtmlright .=
'</ul></div>';
171 $title = $langs->trans(
"AccountStatement").
' '.$numref.
' - '.$langs->trans(
"BankAccount").
' '.$object->getNomUrl(1,
'receipts');
174 print
'<div class="fichecenter">';
175 print
'<div class="underbanner clearboth"></div>';
177 print
'<table class="border tableforfield centpercent">';
178 print
'<tr><td class="titlefield">'.$langs->trans(
"NbOfAttachedFiles").
'</td><td colspan="3">'.count($filearray).
'</td></tr>';
179 print
'<tr><td>'.$langs->trans(
"TotalSizeOfAttachedFiles").
'</td><td colspan="3">'.
dol_print_size($totalsize, 1, 1).
'</td></tr>';
187 $modulepart =
'bank';
188 $permissiontoadd = $user->rights->banque->modifier;
189 $permtoedit = $user->rights->banque->modifier;
190 $param =
'&id='.$object->id.
'&num='.urlencode($numref);
191 $moreparam =
'&num='.urlencode($numref);
193 include DOL_DOCUMENT_ROOT.
'/core/tpl/document_actions_post_headers.tpl.php';
198 header(
'Location: index.php');
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0)
Returns text escaped for inclusion in HTML alt or title tags, or into values of HTML input fields.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
restrictedArea($user, $features, $objectid=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.
load_fiche_titre($titre, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_print_error($db='', $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
if($cancel &&! $id) if($action=='add' &&! $cancel) if($action=='delete') if($id) $form
Actions.
dol_dir_list($path, $types="all", $recursive=0, $filter="", $excludefilter=null, $sortcriteria="name", $sortorder=SORT_ASC, $mode=0, $nohook=0, $relativename="", $donotfollowsymlinks=0)
Scan a directory and return a list of files/directories.
account_statement_prepare_head($object, $num)
Prepare array with list of tabs.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_print_size($size, $shortvalue=0, $shortunit=0)
Return string with formated size.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='')
Show tabs of a record.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
if(isModEnabled('facture') &&!empty($user->rights->facture->lire)) if((isModEnabled('fournisseur') &&empty($conf->global->MAIN_USE_NEW_SUPPLIERMOD) && $user->rights->fournisseur->facture->lire)||(isModEnabled('supplier_invoice') && $user->rights->supplier_invoice->lire)) if(isModEnabled('don') &&!empty($user->rights->don->lire)) if(isModEnabled('tax') &&!empty($user->rights->tax->charges->lire)) if(isModEnabled('facture') &&isModEnabled('commande') && $user->rights->commande->lire &&empty($conf->global->WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER)) $resql
Social contributions to pay.
if(!defined('NOREQUIRESOC')) if(!defined('NOREQUIRETRAN')) if(!defined('NOCSRFCHECK')) if(!defined('NOTOKENRENEWAL')) if(!defined('NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined('NOREQUIREAJAX')) llxHeader()
Empty header.
Class to manage bank accounts.