Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
class	[ DIR ]	drwxr-xr-x	2025-11-08 11:17
various_payment	[ DIR ]	drwxr-xr-x	2025-11-08 11:17
account_statement_document.php	4.91 KB	-rw-r--r--	2020-10-12 13:36
annuel.php	14.6 KB	-rw-r--r--	2020-10-12 13:36
bankentries_list.php	70.08 KB	-rw-r--r--	2020-10-12 13:36
bilan.php	2.64 KB	-rw-r--r--	2020-10-12 13:36
budget.php	3.24 KB	-rw-r--r--	2020-10-12 13:36
card.php	38.5 KB	-rw-r--r--	2020-10-12 13:36
categ.php	4.93 KB	-rw-r--r--	2020-10-12 13:36
document.php	4.73 KB	-rw-r--r--	2020-10-12 13:36
graph.php	25.72 KB	-rw-r--r--	2020-10-12 13:36
index.html	1 B	-rw-r--r--	2020-10-12 13:36
info.php	2.05 KB	-rw-r--r--	2020-10-12 13:36
line.php	25.87 KB	-rw-r--r--	2020-10-12 13:36
list.php	25.74 KB	-rw-r--r--	2020-10-12 13:36
releve.php	24.03 KB	-rw-r--r--	2020-10-12 13:36
transfer.php	8.98 KB	-rw-r--r--	2020-10-12 13:36
treso.php	11.59 KB	-rw-r--r--	2020-10-12 13:36

Rename

<?php
/* Copyright (C) 2001-2003 Rodolphe Quiedeville <rodolphe@quiedeville.org>
 * Copyright (C) 2004      Laurent Destailleur  <eldy@users.sourceforge.net>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <https://www.gnu.org/licenses/>.
 */

/**
 *	    \file       htdocs/compta/bank/bilan.php
 *      \ingroup    banque
 *		\brief      Page de bilan
 */

require '../../main.inc.php';
require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php';

// Load translation files required by the page
$langs->loadLangs(array('banks', 'categories'));

if (!$user->rights->banque->lire)
  accessforbidden();

/**
 * 	Get result of sql for field amount
 *
 * 	@param	string	$sql	SQL string
 * 	@return	int				Amount
 */
function valeur($sql)
{
	global $db;

$valeur = 0;

$resql = $db->query($sql);
	if ($resql)
	{
		$obj = $db->fetch_object($resql);
		$valeur = $obj->amount;
		$db->free($resql);
	}
	return $valeur;
}

/*
 *	View
 */

llxHeader();

print load_fiche_titre("Bilan");
print '<br>';

print '<table class="noborder" width="100%" cellspacing="0" cellpadding="2">';
print "<tr class=\"liste_titre\">";
echo '<td colspan="2">'.$langs->trans("Summary").'</td>';
print "</tr>\n";

$sql = "SELECT sum(amount) as amount FROM ".MAIN_DB_PREFIX."paiement";
$paiem = valeur($sql);
print "<tr class=\"oddeven\"><td>Somme des paiements (associes a une facture)</td><td align=\"right\">".price($paiem)."</td></tr>";

$sql = "SELECT sum(amount) as amount FROM ".MAIN_DB_PREFIX."bank WHERE amount > 0";
$credits = valeur($sql);
print "<tr class=\"oddeven\"><td>Somme des credits</td><td align=\"right\">".price($credits)."</td></tr>";

$sql = "SELECT sum(amount) as amount FROM ".MAIN_DB_PREFIX."bank WHERE amount < 0";
$debits = valeur($sql);
print "<tr class=\"oddeven\"><td>Somme des debits</td><td align=\"right\">".price($debits)."</td></tr>";

$sql = "SELECT sum(amount) as amount FROM ".MAIN_DB_PREFIX."bank ";
$solde = valeur($sql);
print "<tr class=\"oddeven\"><td>".$langs->trans("BankBalance")."</td><td align=\"right\">".price($solde)."</td></tr>";

print "</table>";

// End of page
llxFooter();
$db->close();