Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
class	[ DIR ]	drwxr-xr-x	2021-10-16 13:26
various_payment	[ DIR ]	drwxr-xr-x	2021-10-16 13:26
account_statement_document.php	6.95 KB	-rw-r--r--	2021-10-16 13:26
annuel.php	14.57 KB	-rw-r--r--	2021-10-16 13:26
bankentries_list.php	65.01 KB	-rw-r--r--	2021-10-16 13:26
bilan.php	2.64 KB	-rw-r--r--	2021-10-16 13:26
budget.php	3.24 KB	-rw-r--r--	2021-10-16 13:26
card.php	38.75 KB	-rw-r--r--	2021-10-16 13:26
categ.php	5.1 KB	-rw-r--r--	2021-10-16 13:26
document.php	4.42 KB	-rw-r--r--	2021-10-16 13:26
graph.php	26.13 KB	-rw-r--r--	2021-10-16 13:26
index.html	1 B	-rw-r--r--	2021-10-16 13:26
info.php	2.07 KB	-rw-r--r--	2021-10-16 13:26
line.php	22.42 KB	-rw-r--r--	2021-10-16 13:26
list.php	24.82 KB	-rw-r--r--	2021-10-16 13:26
releve.php	23.81 KB	-rw-r--r--	2021-10-16 13:26
transfer.php	9.38 KB	-rw-r--r--	2021-10-16 13:26
treso.php	11.55 KB	-rw-r--r--	2021-10-16 13:26

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();