noalyss Version-9
|
Acc_Ledger_History : Manage the list (history) of operations for display. More...
Public Member Functions | |
__construct (\Database $cn, $pa_ledger, $p_from, $p_to, $p_mode) | |
export_accounting_html () | |
display the accounting More... | |
export_csv () | |
export in csv with detail VAT More... | |
export_detail_html () | |
Display the operation of sales with detailled VAT. More... | |
export_extended_html () | |
display the operation with detailled vat per item More... | |
export_html () | |
display in HTML following the mode More... | |
export_oneline_html () | |
display in HTML one operation by line More... | |
get_data () | |
To get data. More... | |
get_row ($p_limit=-1, $p_offset="") | |
Get the rows from jrnx and quant* tables. More... | |
set_data ($p_data) | |
Public Member Functions inherited from Acc_Ledger_History | |
__construct (Database $cn, $pa_ledger, $p_from, $p_to, $p_mode) | |
export_accounting_html () | |
display accounting of operations m_mode=A More... | |
export_detail_html () | |
display detail of operations m_mode=D More... | |
export_extended_html () | |
display extended details of operation m_mode=E More... | |
export_html () | |
call the right function , depending of m_mode More... | |
export_oneline_html () | |
display operation on one line m_mode=L More... | |
get_filter_operation () | |
Filter operation. More... | |
get_from () | |
setter / getter More... | |
get_ledger () | |
setter / getter More... | |
get_ledger_type () | |
get_mode () | |
setter / getter More... | |
get_row ($p_limit, $p_offset) | |
get_tiers ($p_jrn_type, $jr_id) | |
Retrieve the third : supplier for purchase, customer for sale, bank for fin,. More... | |
get_tiers_id ($p_jrn_type, $jr_id) | |
Return the f_id of the tiers , called by get_tiers. More... | |
get_to () | |
setter / getter More... | |
has_other_tax () | |
count the number of addition tax for the ledger More... | |
set_a_ledger ($ma_ledger) | |
setter ma_ledger (array of jrn_def_id) More... | |
set_filter_operation ($filter_operation) | |
Filter operation ,. More... | |
set_from ($m_from) | |
setter m_from (periode id) More... | |
set_ledger_type ($ledger_type) | |
set_m_mode ($m_mode) | |
Setter. More... | |
set_to ($m_to) | |
setter m_to (periode id) More... | |
Private Member Functions | |
add_vat_info () | |
preprare the query for fetching the detailed VAT of an operation @staticvar int $prepare More... | |
prepare_detail () | |
Prepare the query for fetching detail of an operation. More... | |
Private Attributes | |
$data | |
Contains rows from SQL. More... | |
Additional Inherited Members | |
Static Public Member Functions inherited from Acc_Ledger_History | |
static | factory (Database $cn, $pa_ledger, $p_from, $p_to, $p_mode, $p_paid) |
Build the right object. More... | |
Data Fields inherited from Acc_Ledger_History | |
$db | |
database connx More... | |
Protected Member Functions inherited from Acc_Ledger_History | |
add_additional_tax_info () | |
add additional info about additional tax. More... | |
build_filter_operation () | |
Build a SQL clause to filter operation depending if they are paid, unpaid or no filter. More... | |
prepare_reconcile_date () | |
Prepare the query for fetching the linked operation @staticvar int $prepare. More... | |
Protected Attributes inherited from Acc_Ledger_History | |
$filter_operation | |
type of ledger VEN , ACH , ODS, FIN More... | |
$ledger_type | |
$m_from | |
Starting Periode : periode.p_id. More... | |
$m_mode | |
mode of export L : one line, E accounting writing , D : Detail More... | |
$m_to | |
Ending Periode : periode.p_id. More... | |
$ma_ledger | |
Array of ledger id : jrn_def.jrn_def_id. More... | |
Acc_Ledger_History : Manage the list (history) of operations for display.
Definition at line 31 of file acc_ledger_history_sale.class.php.
Acc_Ledger_History_Sale::__construct | ( | \Database | $cn, |
$pa_ledger, | |||
$p_from, | |||
$p_to, | |||
$p_mode | |||
) |
Definition at line 37 of file acc_ledger_history_sale.class.php.
References $cn.
|
private |
preprare the query for fetching the detailed VAT of an operation @staticvar int $prepare
Definition at line 198 of file acc_ledger_history_sale.class.php.
References $array, $i, $nb_row, $ret, db, and DatabaseCore\fetch_all().
Referenced by export_csv(), export_detail_html(), and export_extended_html().
Acc_Ledger_History_Sale::export_accounting_html | ( | ) |
display the accounting
Reimplemented from Acc_Ledger_History.
Definition at line 59 of file acc_ledger_history_sale.class.php.
References db.
Referenced by export_html().
Acc_Ledger_History_Sale::export_csv | ( | ) |
export in csv with detail VAT
Add currency info
Retrieve payment if any
Definition at line 274 of file acc_ledger_history_sale.class.php.
References $a, $e, $export, $l, $line, $max, $own, $ret_reconcile, $row, $title, add_vat_info(), db, DatabaseCore\fetch_array(), get_row(), Acc_Ledger_History\has_other_tax(), DatabaseCore\num_row(), and Acc_Ledger_History\prepare_reconcile_date().
Acc_Ledger_History_Sale::export_detail_html | ( | ) |
Display the operation of sales with detailled VAT.
Reimplemented from Acc_Ledger_History.
Definition at line 47 of file acc_ledger_history_sale.class.php.
References $own, add_vat_info(), db, get_row(), and Acc_Ledger_History\prepare_reconcile_date().
Referenced by export_html().
Acc_Ledger_History_Sale::export_extended_html | ( | ) |
display the operation with detailled vat per item
Reimplemented from Acc_Ledger_History.
Definition at line 68 of file acc_ledger_history_sale.class.php.
References Acc_Ledger_History\add_additional_tax_info(), add_vat_info(), get_row(), prepare_detail(), and Acc_Ledger_History\prepare_reconcile_date().
Referenced by export_html().
Acc_Ledger_History_Sale::export_html | ( | ) |
display in HTML following the mode
Reimplemented from Acc_Ledger_History.
Definition at line 226 of file acc_ledger_history_sale.class.php.
References export_accounting_html(), export_detail_html(), export_extended_html(), and export_oneline_html().
Acc_Ledger_History_Sale::export_oneline_html | ( | ) |
display in HTML one operation by line
Reimplemented from Acc_Ledger_History.
Definition at line 250 of file acc_ledger_history_sale.class.php.
References get_row(), Acc_Ledger_History\has_other_tax(), and Acc_Ledger_History\prepare_reconcile_date().
Referenced by export_html().
Acc_Ledger_History_Sale::get_data | ( | ) |
To get data.
Definition at line 262 of file acc_ledger_history_sale.class.php.
References $data.
Acc_Ledger_History_Sale::get_row | ( | $p_limit = -1 , |
|
$p_offset = "" |
|||
) |
Get the rows from jrnx and quant* tables.
int | $p_limit | max of rows to returns |
int | $p_offset | the number of rows to skip |
Reimplemented from Acc_Ledger_History.
Definition at line 115 of file acc_ledger_history_sale.class.php.
References $periode, $sql, $sql_filter, db, and sql_filter_per().
Referenced by export_csv(), export_detail_html(), export_extended_html(), and export_oneline_html().
|
private |
Prepare the query for fetching detail of an operation.
Definition at line 80 of file acc_ledger_history_sale.class.php.
References db.
Referenced by export_extended_html().
Acc_Ledger_History_Sale::set_data | ( | $p_data | ) |
Definition at line 266 of file acc_ledger_history_sale.class.php.
|
private |
Contains rows from SQL.
Definition at line 34 of file acc_ledger_history_sale.class.php.
Referenced by get_data().