verif_bilan.inc.php File Reference

Verify the saldo of ledger: independant file. More...

Go to the source code of this file.

Variables
	$bilan =new Acc_Bilan($cn)
	$cn =new Database(dossier::id())
	$cred =$cn->get_value("select sum (j_montant) from jrnx where j_debit='f' $sql_year ")
	$deb =$cn->get_value("select sum (j_montant) from jrnx where j_debit='t' $sql_year ")
	$exercice =$g_user->get_exercice()
	$jrn =Database::fetch_all($res)
	$periode =new Periode($cn)
	$res =$cn->exec_sql($sql)
	$sql ="select jrn_def_id,jrn_def_name from jrn_def"
	$sql_year =" and j_tech_per in (select p_id from parm_periode where p_exercice='".$g_user->get_exercice()."')"
if($cred==$deb)	else
	foreach ($jrn as $l)
$bilan	from =$start_periode->p_id
$bilan	to =$end_periode->p_id

Detailed Description

Verify the saldo of ledger: independant file.

Definition in file verif_bilan.inc.php.

Variable Documentation

$bilan =new Acc_Bilan($cn)

Definition at line 114 of file verif_bilan.inc.php.

$cn =new Database(dossier::id())

Definition at line 30 of file verif_bilan.inc.php.

$cred =$cn->get_value("select sum (j_montant) from jrnx where j_debit='f' $sql_year ")

Definition at line 38 of file verif_bilan.inc.php.

Referenced by Acc_Operation\get_data(), Acc_Tva\get_side(), Acc_Ledger\get_solde(), Anc_Operation\html_table(), and Fiche\Summary().

$deb =$cn->get_value("select sum (j_montant) from jrnx where j_debit='t' $sql_year ")

Definition at line 37 of file verif_bilan.inc.php.

Referenced by Anc_Balance_Simple\display_html(), Anticipation\form_item(), Acc_Operation\get_data(), Acc_Tva\get_side(), Acc_Ledger\get_solde(), Acc_Ledger\input(), Lettering\save(), and Fiche\Summary().

$exercice =$g_user->get_exercice()

Definition at line 31 of file verif_bilan.inc.php.

$jrn =Database::fetch_all($res)

Definition at line 53 of file verif_bilan.inc.php.

Referenced by Fiche\build_sql(), Acc_Ledger\get_operation(), Acc_Ledger\get_rowSimple(), and Acc_Ledger\search_form().

$periode =new Periode($cn)

Definition at line 115 of file verif_bilan.inc.php.

$res =$cn->exec_sql($sql)

Definition at line 52 of file verif_bilan.inc.php.

$sql ="select jrn_def_id,jrn_def_name from jrn_def"

Definition at line 51 of file verif_bilan.inc.php.

$sql_year =" and j_tech_per in (select p_id from parm_periode where p_exercice='".$g_user->get_exercice()."')"

Definition at line 34 of file verif_bilan.inc.php.

if ($cred==$deb) else

Initial value:

{
    $result ='<span style="color:red;font-size:120%;font-weight:bold;"> NON OK </span>'

Definition at line 45 of file verif_bilan.inc.php.

foreach($jrn as $l)

Definition at line 54 of file verif_bilan.inc.php.

$bilan from =$start_periode->p_id

Definition at line 117 of file verif_bilan.inc.php.

Referenced by Anc_Print\Anc_Print(), Anc_Print\check(), Acc_Bilan\compute_formula(), Anc_Listing\display_csv(), Anc_Balance_Double\display_pdf(), Anc_Balance_Simple\display_pdf(), Anc_Print\get_request(), Acc_Bilan\get_request_get(), PDFBalance_simple\Header(), Anc_Listing\load(), Anc_Table\load_poste(), PDFBalance_simple\set_info(), Anc_GrandLivre\set_sql_filter(), Anc_Acc_Link\set_sql_filter(), Anc_Balance_Simple\set_sql_filter(), Anc_Group\set_sql_filter(), Anc_Print\set_sql_filter(), Anc_Listing\show_button(), Anc_Acc_List\show_button(), Anc_Group\show_button(), Anc_GrandLivre\show_button(), Anc_Balance_Simple\show_button(), Anc_Balance_Double\show_button(), Acc_Bilan\verify(), and Acc_Bilan\warning().

$bilan to =$end_periode->p_id

Definition at line 118 of file verif_bilan.inc.php.

Referenced by Anc_Print\Anc_Print(), Anc_Print\check(), Acc_Bilan\compute_formula(), Anc_Listing\display_csv(), Anc_Balance_Double\display_pdf(), Anc_Balance_Simple\display_pdf(), Anc_Print\get_request(), Acc_Bilan\get_request_get(), PDFBalance_simple\Header(), Anc_Listing\load(), PDFBalance_simple\set_info(), Anc_GrandLivre\set_sql_filter(), Anc_Acc_Link\set_sql_filter(), Anc_Balance_Simple\set_sql_filter(), Anc_Group\set_sql_filter(), Anc_Print\set_sql_filter(), Anc_Listing\show_button(), Anc_Acc_List\show_button(), Anc_Group\show_button(), Anc_GrandLivre\show_button(), Anc_Balance_Simple\show_button(), Anc_Balance_Double\show_button(), Acc_Bilan\verify(), and Acc_Bilan\warning().