balance.inc.php File Reference

Show the balance and let you print it or export to PDF file included by user_impress. More...

Go to the source code of this file.

Variables
	$array =get_array_column($array_ledger,'jrn_def_id')
	$array_cat =Acc_Ledger::array_cat()
	$array_ledger =$g_user->get_ledger('ALL',3)
	$ck_lev1 =new ICheckBox('lvl1')
	$ck_lev2 =new ICheckBox('lvl2')
	$ck_lev3 =new ICheckBox('lvl3')
	$ex =new Exercice($cn)
	$exercice =$http->request("exercice","number",0)
	$filter =$http->get('p_filter',"string",0)
	$from =$http->get("from_periode", "number",0)
	$from_poste =new IPoste()
	$from_span =new ISpan("from_poste_label","")
global	$g_user
	$gDossier =dossier::id()
global	$http
	$input_from =new IPeriod("from_periode",$from,$exercice)
if( $to==0)	$input_to =new IPeriod("to_periode",$to,$exercice)
	$js =sprintf("updatePeriode(%d,'%s','%s','%s',1)",Dossier::id(),'exercice','from_periode','to_periode')
	$previous_exc =new ICheckBox('previous_exc')
	$rad =new IRadio()
	$select_cat =$http->get('r_cat','array',array())
	$selected =$http->get('r_jrn','array',array())
	$to =$http->get("to_periode", "number",0)
	$to_poste =new IPoste()
	$to_span =new ISpan("to_poste_label","")
	$unsold =new ICheckBox('unsold')
	$wex =$ex->select('exercice',$exercice,' onchange="'.$js.'"')
$input_from	cn =$cn
$input_from	filter_year =true
$input_from	id ="from_periode"
$from_poste	name ="from_poste"
$rad	selected =false
$input_from	show_end_date =false
$input_to	show_start_date =false
$input_from	type =ALL
$input_from	user =$g_user
$ck_lev1	value =1

Detailed Description

Show the balance and let you print it or export to PDF file included by user_impress.

some variable are already defined ($cn, $g_user ...)

Definition in file balance.inc.php.

Variable Documentation

$array

$array =get_array_column($array_ledger,'jrn_def_id')

Definition at line 99 of file balance.inc.php.

$array_cat

$array_cat =Acc_Ledger::array_cat()

Definition at line 103 of file balance.inc.php.

Referenced by HtmlInput\select_cat().

$array_ledger

$array_ledger =$g_user->get_ledger('ALL',3)

Definition at line 98 of file balance.inc.php.

$ck_lev1

$ck_lev1 =new ICheckBox('lvl1')

Definition at line 127 of file balance.inc.php.

$ck_lev2

$ck_lev2 =new ICheckBox('lvl2')

Definition at line 128 of file balance.inc.php.

$ck_lev3

$ck_lev3 =new ICheckBox('lvl3')

Definition at line 129 of file balance.inc.php.

$ex

$ex =new Exercice($cn)

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

Referenced by Manage_Table_SQL\ajax_delete(), Manage_Table_SQL\ajax_input(), Manage_Table_SQL\ajax_save(), Document_Export\check_file(), HttpInput\check_type(), Extension\check_xml(), Card_Attribut_MTable\delete(), DatabaseCore\get_value(), Acc_Ledger_Fin\insert(), Extension\read_definition(), Currency_MTable\save(), Anc_Group_Operation\save(), and Periode\verify_delete().

$exercice

$exercice =$http->request("exercice","number",0)

Definition at line 32 of file balance.inc.php.

$filter

$filter =$http->get('p_filter',"string",0)

Definition at line 105 of file balance.inc.php.

Referenced by Card_Multiple\build_sql(), Card_Multiple\count_sql(), Follow_Up\display(), Acc_Ledger\get_operation_date(), Acc_Account_Ledger\get_row_date(), Card_Property\input(), and Anc_Balance_Simple\load().

$from

$from =$http->get("from_periode", "number",0)

Definition at line 61 of file balance.inc.php.

Referenced by User\Check(), Periode\form_exercice_add(), Anc_Operation\html_table(), and Impress\parse_formula().

$from_poste

$from_poste =new IPoste()

Definition at line 158 of file balance.inc.php.

$from_span

$from_span =new ISpan("from_poste_label","")

Definition at line 165 of file balance.inc.php.

$g_user

global $g_user

Definition at line 27 of file balance.inc.php.

$gDossier

$gDossier =dossier::id()

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

$http

global $http

Definition at line 29 of file balance.inc.php.

$input_from

$input_from =new IPeriod("from_periode",$from,$exercice)

Definition at line 62 of file balance.inc.php.

$input_to

if ($to==0) $input_to =new IPeriod("to_periode",$to,$exercice)

Definition at line 80 of file balance.inc.php.

$js

$js =sprintf("updatePeriode(%d,'%s','%s','%s',1)",Dossier::id(),'exercice','from_periode','to_periode')

Definition at line 46 of file balance.inc.php.

$previous_exc

$previous_exc =new ICheckBox('previous_exc')

Definition at line 153 of file balance.inc.php.

$rad

$rad =new IRadio()

Definition at line 96 of file balance.inc.php.

Referenced by Securimage\distortedCopy().

$select_cat

$select_cat =$http->get('r_cat','array',array())

Definition at line 101 of file balance.inc.php.

Referenced by Fiche\test_me().

$selected

$selected =$http->get('r_jrn','array',array())

Definition at line 100 of file balance.inc.php.

Referenced by Exercice\select(), and Exercice\select_date().

$to

$to =$http->get("to_periode", "number",0)

Definition at line 72 of file balance.inc.php.

Referenced by Database\apply_patch(), and Anc_Operation\html_table().

$to_poste

$to_poste =new IPoste()

Definition at line 167 of file balance.inc.php.

Referenced by PDFBalance_simple\set_info().

$to_span

$to_span =new ISpan("to_poste_label","")

Definition at line 174 of file balance.inc.php.

$unsold

$unsold =new ICheckBox('unsold')

Definition at line 148 of file balance.inc.php.

$wex

$wex =$ex->select('exercice',$exercice,' onchange="'.$js.'"')

Definition at line 47 of file balance.inc.php.

cn

$input_to cn =$cn

Definition at line 66 of file balance.inc.php.

Referenced by Exercice\__construct(), Tag\__construct(), PDFLand\__construct(), Forecast\__construct(), Profile_Menu\__construct(), Document_modele\__construct(), Balance_Age\__construct(), PDF_Operation\__construct(), Acc_Currency\__construct(), Acc_Ledger_Info\__construct(), Fiche_Def\__construct(), PDF\__construct(), Periode_Ledger_Table\__construct(), Periode\__construct(), Acc_Tva\__construct(), Anticipation\__construct(), Fiche\__construct(), Dossier\__construct(), Card_Property\__construct(), Acc_Payment\__construct(), Acc_Ledger_Search\__construct(), Todo_List\__construct(), Data_SQL\__construct(), Anc_Acc_Link\__contruct(), Fiche_Def\Add(), ITva_Popup\add_label(), Profile_Menu\available_profile(), Profile_Menu\available_repository(), Fiche\belong_ledger(), Acc_Payment\blank(), Fiche\blank(), Acc_Ledger_Search\build_search_sql(), Fiche\build_sql(), Extension\can_request(), Periode\centralized(), Periode\close(), Exercice\count(), V_Currency_Last_Value_SQL\count(), Dossier\count(), Acc_Ledger_Info\count(), Table_Data_SQL\count(), Fiche\count_by_modele(), Fiche_Def\count_category(), Periode\count_operation(), Stock\create_query_histo(), V_Currency_Last_Value_SQL\delete(), Acc_Plan_SQL\delete(), Table_Data_SQL\delete(), Forecast\delete(), Acc_Tva\delete(), Document_modele\Delete(), Todo_List\delete(), Periode\delete(), Fiche\delete(), Fiche_Def\display(), Anticipation\display(), Fiche\Display(), Profile_Menu\display_module_menu(), Profile_Menu\display_profile_menu_detail(), Fiche\display_row(), Fiche_Def\DisplayAttribut(), Fiche\empty_attribute(), V_Currency_Last_Value_SQL\exist(), Acc_Plan_SQL\exist(), Table_Data_SQL\exist(), Print_Ledger_Detail\export(), Print_Ledger_Misc\export(), Print_Ledger_Detail_Item\export(), Print_Ledger_Financial\export(), Print_Ledger_Simple_Without_Vat\export(), Print_Ledger_Simple\export(), Balance_Age\export_csv(), PDF_Operation\export_pdf(), Periode\find_periode(), Acc_Payment\form(), Document_modele\form(), Fiche_Def\get(), Acc_Payment\get_all(), Fiche_Def\get_all(), Balance_Age\get_array_card(), Fiche_Def\get_attr_min(), Fiche\get_bank_ledger(), Fiche\get_bk_account(), Fiche\get_bk_balance(), Fiche\get_bk_balance_currency(), Customer\get_by_account(), Supplier\get_by_account(), Fiche_Def\get_by_category(), Fiche\get_by_category(), Acc_Currency\get_by_iso(), Fiche\get_by_qcode(), Fiche_Def\get_by_type(), Fiche\get_categorie(), Periode\get_date_limit(), Periode\get_exercice(), Fiche\get_fiche_def_ref_id(), Periode\get_limit(), Fiche\get_quick_code(), Acc_Currency\get_rate_date(), Periode_Ledger_Table\get_resource_periode_ledger(), Fiche\get_row(), Fiche\get_row_date(), Fiche\get_solde_detail(), PDF\get_tiers(), Dossier\get_user_folder(), Acc_Payment\get_valide(), Fiche_Def\getAttribut(), Fiche\getLabelCategory(), Fiche\getName(), Fiche_Def\HasAttribute(), Stock\history(), Fiche\HtmlTable(), Fiche\HtmlTableDetail(), Fiche_Def\input(), Stock_Goods\input(), IPeriod\input(), ITva_Popup\input(), Card_Property\input(), Acc_Ledger_Info\insert(), Forecast\insert(), Acc_Tva\insert(), Table_Data_SQL\insert(), Acc_Plan_SQL\insert(), Todo_List\insert(), Periode\insert(), Fiche\insert(), Periode\insert_exercice(), Extension\insert_plugin(), Fiche_Def\InsertAttribut(), Periode\is_centralized(), Periode\is_closed(), Periode\is_open(), Fiche\is_used(), Periode\limit_year(), Acc_Ledger_Search\list_operation(), Acc_Ledger_Search\list_operation_to_reconcile(), Periode_Ledger_Table\load(), Acc_Payment\load(), Acc_Ledger_Info\load(), V_Currency_Last_Value_SQL\load(), Forecast\load(), Acc_Plan_SQL\load(), Acc_Tva\load(), Table_Data_SQL\load(), Todo_List\load(), Dossier\load(), Periode\load(), Document_modele\load(), Acc_Ledger_Info\load_all(), Todo_List\load_all(), Fiche\move_to(), Document_modele\myList(), Fiche_Def\myList(), Data_SQL\next(), Forecast\object_clone(), Anticipation\object_clone(), Card_Property\print(), PDF_Operation\print_acc_writing(), PDF_Operation\print_anc_detail(), PDF_Operation\print_anc_writing(), PDF_Operation\print_info(), PDF_Operation\print_ledger_name(), PDF_Operation\print_operation_info(), PDF_Operation\print_operation_quant(), PDF_Operation\print_purchase(), PDF_Operation\print_reconcilied_operation(), PDF_Operation\print_sale(), Profile_Menu\printing(), Tag\query_active_tag(), Fiche\remove(), Fiche_Def\remove(), Extension\remove_plugin(), Todo_List\remove_shared_with(), Fiche_Def\RemoveAttribut(), Periode\reopen(), Document_modele\Save(), Fiche_Def\save_class_base(), Fiche_Def\save_description(), Acc_Ledger\save_followup(), Fiche_Def\save_order(), Todo_List\save_shared_with(), Fiche_Def\SaveLabel(), Stock\search_box(), Acc_Ledger_Search\search_form(), Acc_Ledger_Info\search_id_internal(), V_Currency_Last_Value_SQL\seek(), Acc_Plan_SQL\seek(), Fiche\seek(), Table_Data_SQL\seek(), Exercice\select(), Acc_Payment\select(), Acc_Currency\select_currency(), Exercice\select_date(), Fiche_Def\set_autocreate(), Data_SQL\set_cn(), Tag\show_list(), PDF_Operation\str_vat(), Profile_Menu\sub_menu(), Acc_Currency\sum_amount(), contact\Summary(), Fiche\Summary(), Fiche_Def\to_array(), Acc_Ledger_Info\update(), Forecast\update(), Acc_Tva\update(), Table_Data_SQL\update(), Todo_List\update(), Acc_Plan_SQL\update(), Dossier\update(), Document_modele\update(), Fiche\update(), Extension\update_plugin(), Customer\VatListing(), Menu_Ref\verify(), Periode\verify_delete(), Acc_Ledger_Purchase\verify_operation(), and Acc_Ledger_Sale\verify_operation().

filter_year

$input_to filter_year =true

Definition at line 67 of file balance.inc.php.

Referenced by IPeriod\input().

id

$num id ="from_periode"

Definition at line 63 of file balance.inc.php.

Referenced by Tag_Operation\button_search(), Acc_Ledger_Sale\confirm(), Acc_Ledger_Purchase\confirm(), ITva_Popup\dbutton(), HtmlInput\detail_action(), HtmlInput\detail_modele_document(), HtmlInput\detail_op(), Calendar\display(), Follow_Up\display_children(), Follow_Up\display_parent(), HtmlInput\display_periode(), Follow_Up_Other_Concerned\display_row(), display_security_fieldset(), Noalyss\Mobile\execute_menu(), HtmlInput\history_account(), HtmlInput\history_anc_account(), HtmlInput\history_card(), HtmlInput\history_card_button(), Anc_Operation\html_table(), Acc_Account_Ledger\HtmlTable(), Fiche\HtmlTable(), IRelated_Action\input(), IConcerned\input(), ITva_Popup\input(), Acc_Ledger\input(), Acc_Ledger_Purchase\input(), Acc_Ledger_Sale\input(), Acc_Ledger_Search\list_operation(), Acc_Ledger_Search\list_operation_to_reconcile(), Document_modele\myList(), HtmlInput\remove_stock(), Acc_Payment\select(), Profile_Menu\sub_menu(), Fiche\Summary(), Follow_Up\tag_cell(), Anc_Group_Operation\test_me(), and Calendar\zoom_calendar().

name

$waffect name ="from_poste"

Definition at line 159 of file balance.inc.php.

Referenced by Tag_SQL\__construct(), Document_State_SQL\__construct(), Default_Menu_SQL\__construct(), Form_Detail_SQL\__construct(), Jrn_def_SQL\__construct(), Payment_method_SQL\__construct(), Anc_Key_SQL\__construct(), Form_Definition_SQL\__construct(), Attr_Def_SQL\__construct(), Forecast_Item_SQL\__construct(), Fiche_def_ref_SQL\__construct(), Jrn_periode_SQL\__construct(), Parameter_Extra_SQL\__construct(), Stock_Sql\__construct(), IRelated_Action\__construct(), V_Tva_Rate_SQL\__construct(), Currency_SQL\__construct(), Currency_history_SQL\__construct(), Document_type_SQL\__construct(), Forecast_SQL\__construct(), Op_Predef_SQL\__construct(), Acc_Plan_SQL\__construct(), Poste_analytique_SQL\__construct(), Action_Gestion_Comment_SQL\__construct(), Stock_Goods_Sql\__construct(), Contact_option_ref_SQL\__construct(), Tva_rate_SQL\__construct(), User_filter_SQL\__construct(), Forecast_Category_SQL\__construct(), Menu_Ref_SQL\__construct(), Parm_periode_SQL\__construct(), Action_Gestion_SQL\__construct(), Tag_group_SQL\__construct(), Tmp_Pcmn_SQL\__construct(), Operation_currency_SQL\__construct(), Profile_Mobile_SQL\__construct(), Package_Noalyss\__construct(), V_Currency_Last_Value_SQL\__construct(), Anc_Plan\__construct(), Profile_Menu_sql\__construct(), Quant_Sold_SQL\__construct(), IPopup\__construct(), Profile_sql\__construct(), Quant_Purchase_SQL\__construct(), Quant_Fin_SQL\__construct(), Single_Record\__construct(), IPeriod\__construct(), Pre_operation\__construct(), IConcerned\__construct(), Inplace_Switch\__construct(), ITva_Popup\__construct(), Anc_Key_Ledger_SQL\__construct(), HtmlInput\__construct(), IPoste\__construct(), Data_SQL\__construct(), Stock_Change_Sql\__construct(), Anc_Key_Detail_SQL\__construct(), Anc_Key_Activity_SQL\__construct(), Anc_Plan\add(), Table_Data_SQL\build_query(), User\Check(), ITva_Popup\dbutton(), ITextarea\display(), INum\display(), ICheckBox\display(), IRelated_Action\display(), IConcerned\display(), IAncCard\display(), ITva_Popup\display(), IPoste\display(), ICard\display(), Anc_Balance_Double\display_pdf(), IPoste\dsp_button(), TTFontFile\extractInfo(), Anc_Plan\form(), Data_SQL\from_array(), Anc_Plan\get(), Customer\get_by_account(), Supplier\get_by_account(), Acc_Account_Ledger\get_name(), Pre_operation\get_post(), Data_SQL\getp(), header_txt(), Single_Record\hidden(), IAction_deprecated\input(), IRadio\input(), IHidden\input(), ITextarea\input(), IButton\input(), ISpan\input(), IRelated_Action\input(), IText\input(), ICheckBox\input(), ISelect\input(), IFile\input(), IConcerned\input(), Inplace_Switch\input(), IPeriod\input(), ITva_Popup\input(), IAncCard\input(), INum\input(), ISmallButton\input(), IPopup\input(), IDate\input(), IPoste\input(), ICard\input(), Table_Data_SQL\insert(), V_Currency_Last_Value_SQL\load(), User\load(), Pre_operation\save_insert(), Pre_operation\save_update(), IAncCard\search(), IPopup\set_height(), PDFBalance_simple\set_info(), Package_Noalyss\set_name(), Inplace_Switch\set_name(), Data_SQL\set_name(), Pre_operation\set_name(), IPopup\set_title(), IPopup\set_width(), IPopup\set_zindex(), Print_Ledger_Detail_Item\setDossierInfo(), Print_Ledger_Detail\setDossierInfo(), PDF\setDossierInfo(), Print_Ledger_Simple_Without_Vat\setDossierInfo(), Print_Ledger_Simple\setDossierInfo(), User\setName(), Data_SQL\setp(), Data_SQL\to_array(), Anc_Plan\update(), Table_Data_SQL\update(), and Data_SQL\verify().

selected

$rad selected =false

Definition at line 109 of file balance.inc.php.

show_end_date

$input_from show_end_date =false

Definition at line 64 of file balance.inc.php.

Referenced by IPeriod\__construct(), and IPeriod\input().

show_start_date

$input_to show_start_date =false

Definition at line 82 of file balance.inc.php.

Referenced by IPeriod\__construct(), and IPeriod\input().

type

$input_to type =ALL

Definition at line 65 of file balance.inc.php.

Referenced by Tag_SQL\__construct(), Document_State_SQL\__construct(), Default_Menu_SQL\__construct(), Payment_method_SQL\__construct(), Form_Detail_SQL\__construct(), Jrn_def_SQL\__construct(), Anc_Key_SQL\__construct(), Form_Definition_SQL\__construct(), Jrn_periode_SQL\__construct(), Parameter_Extra_SQL\__construct(), Attr_Def_SQL\__construct(), Forecast_Item_SQL\__construct(), Stock_Sql\__construct(), Fiche_def_ref_SQL\__construct(), Op_Predef_SQL\__construct(), Poste_analytique_SQL\__construct(), Currency_SQL\__construct(), Currency_history_SQL\__construct(), Stock_Goods_Sql\__construct(), Document_type_SQL\__construct(), Acc_Plan_SQL\__construct(), Action_Gestion_Comment_SQL\__construct(), V_Tva_Rate_SQL\__construct(), Forecast_SQL\__construct(), Menu_Ref_SQL\__construct(), Contact_option_ref_SQL\__construct(), Parm_periode_SQL\__construct(), Action_Gestion_SQL\__construct(), Tva_rate_SQL\__construct(), User_filter_SQL\__construct(), Forecast_Category_SQL\__construct(), Operation_currency_SQL\__construct(), Profile_Mobile_SQL\__construct(), Tag_group_SQL\__construct(), Tmp_Pcmn_SQL\__construct(), Profile_Menu_sql\__construct(), Quant_Sold_SQL\__construct(), V_Currency_Last_Value_SQL\__construct(), Profile_sql\__construct(), Quant_Purchase_SQL\__construct(), Quant_Fin_SQL\__construct(), Cellule\__construct(), Anc_Key_Ledger_SQL\__construct(), Data_SQL\__construct(), Stock_Change_Sql\__construct(), Anc_Key_Detail_SQL\__construct(), Anc_Key_Activity_SQL\__construct(), Table_Data_SQL\build_query(), Acc_Ledger_Search\build_search_filter(), Acc_Ledger_Search\build_search_sql(), PDF_Core\check_page_add(), Data_SQL\get(), FileToSend\guess_type(), Acc_Account_Ledger\HtmlTableHeader(), IPeriod\input(), Table_Data_SQL\insert(), Acc_Operation\insert_jrnx(), Anc_Key\key_add(), Acc_Ledger_Search\list_operation(), Acc_Ledger_Search\list_operation_to_reconcile(), V_Currency_Last_Value_SQL\load(), Acc_Ledger_Search\search_form(), Acc_Ledger_Search\select_ledger(), Data_SQL\set(), Acc_Ledger_Search\set_type(), Data_SQL\set_type(), ICard\test_me(), and Table_Data_SQL\update().

user

$input_to user =$g_user

Definition at line 68 of file balance.inc.php.

Referenced by Acc_Operation\__construct(), IPeriod\input(), and Acc_Operation\insert_jrnx().

value

$to_poste value =1

Definition at line 130 of file balance.inc.php.