noalyss Version-9
|
manage the list of operation when we need several ledger with a different type or from Misceleaneous ledger More...
Public Member Functions | |
__construct (Database $cn, $pa_ledger, $p_from, $p_to, $p_mode) | |
export_accounting_html () | |
display in html the accounting of the list of operations More... | |
export_csv () | |
export CSV More... | |
export_detail_html () | |
display in html the detail the list of operation More... | |
export_extended_html () | |
display in html with extended detail the list of operation More... | |
export_html () | |
depending on the mode will call the right function More... | |
export_oneline_html () | |
list operation on one line per operation More... | |
get_data () | |
To get data. More... | |
get_detail (&$p_array, $p_jrn_type, $trunc=0, $a_TVA=null, $a_ParmCode=null) | |
get_detail gives the detail of row this array must contains at least the field More... | |
get_row ($p_limit=-1, $p_offset=-1) | |
set $this->data with the array of rows More... | |
get_rowSimple ($trunc=0, $p_limit=-1, $p_offset=-1) | |
Get simplified row from ledger. More... | |
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 Attributes | |
$data | |
array of rows 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... | |
manage the list of operation when we need several ledger with a different type or from Misceleaneous ledger
Definition at line 33 of file acc_ledger_history_generic.class.php.
Acc_Ledger_History_Generic::__construct | ( | Database | $cn, |
$pa_ledger, | |||
$p_from, | |||
$p_to, | |||
$p_mode | |||
) |
Database | $cn | |
array | $pa_ledger | array of jrn_def.jrn_def_id |
integer | $p_from | periode |
integer | $p_to | |
char | $p_mode | E D L or A , for Extended ,Detail , Listing , Accounting |
Exception | if $pa_ledger is not an array |
Reimplemented from Acc_Ledger_History.
Definition at line 48 of file acc_ledger_history_generic.class.php.
References $cn.
Acc_Ledger_History_Generic::export_accounting_html | ( | ) |
display in html the accounting of the list of operations
Reimplemented from Acc_Ledger_History.
Definition at line 656 of file acc_ledger_history_generic.class.php.
References $class, $op, get_row(), and td().
Referenced by export_detail_html(), export_extended_html(), and export_html().
Acc_Ledger_History_Generic::export_csv | ( | ) |
export CSV
Definition at line 791 of file acc_ledger_history_generic.class.php.
References $desc, $export, $idx, $op, $title, exit, get_row(), and noalyss_str_replace().
Acc_Ledger_History_Generic::export_detail_html | ( | ) |
display in html the detail the list of operation
Reimplemented from Acc_Ledger_History.
Definition at line 640 of file acc_ledger_history_generic.class.php.
References export_accounting_html().
Acc_Ledger_History_Generic::export_extended_html | ( | ) |
display in html with extended detail the list of operation
Reimplemented from Acc_Ledger_History.
Definition at line 648 of file acc_ledger_history_generic.class.php.
References export_accounting_html().
Acc_Ledger_History_Generic::export_html | ( | ) |
depending on the mode will call the right function
Reimplemented from Acc_Ledger_History.
Definition at line 384 of file acc_ledger_history_generic.class.php.
References export_accounting_html(), and export_oneline_html().
Acc_Ledger_History_Generic::export_oneline_html | ( | ) |
list operation on one line per operation
Reimplemented from Acc_Ledger_History.
Definition at line 700 of file acc_ledger_history_generic.class.php.
References $class, $i, $line, $tiers, $tot_amount, db, get_rowSimple(), Acc_Ledger_History\get_tiers(), nbm(), td(), and th().
Referenced by export_html().
Acc_Ledger_History_Generic::get_data | ( | ) |
To get data.
Definition at line 783 of file acc_ledger_history_generic.class.php.
References $data.
Acc_Ledger_History_Generic::get_detail | ( | & | $p_array, |
$p_jrn_type, | |||
$trunc = 0 , |
|||
$a_TVA = null , |
|||
$a_ParmCode = null |
|||
) |
get_detail gives the detail of row this array must contains at least the field
the following field will be added
@paramp_array the structure is set in get_rowSimple, this array is modified,
jrn.jr_id as jr_id , jrn.jr_id as num , jrn.jr_def_id as jr_def_id, jrn.jr_montant as montant, substr(jrn.jr_comment,1,35) as comment, to_char(jrn.jr_date,'DD-MM-YYYY') as date, to_char(jrn.jr_date_paid,'DD-MM-YYYY') as date_paid, jr_pj_number, jr_internal, jrn.jr_grpt_id as grpt_id, jrn.jr_pj_name as pj, jrn_def_type, jrn.jr_tech_per
$trunc | if the data must be truncated, usefull for pdf export @paramp_jrn_type is the type of the ledger (ACH or VEN) |
$a_TVA | TVA Array (default null) |
$a_ParmCode | Array (default null) |
Definition at line 100 of file acc_ledger_history_generic.class.php.
References $a, $a_detail, $code, $fiche, $i, $nb_detail, $p_array, $poste, $r, $sql, $tmp, db, DatabaseCore\fetch_all(), FICHE_TYPE_ACH_MAR, FICHE_TYPE_ACH_MAT, FICHE_TYPE_ACH_SER, FICHE_TYPE_ADM_TAX, FICHE_TYPE_CLIENT, FICHE_TYPE_FOURNISSEUR, FICHE_TYPE_VENTE, and noalyss_strlentrim().
Acc_Ledger_History_Generic::get_row | ( | $p_limit = -1 , |
|
$p_offset = -1 |
|||
) |
set $this->data with the array of rows
p_limit | starting line |
p_offset | number of lines |
Reimplemented from Acc_Ledger_History.
Definition at line 504 of file acc_ledger_history_generic.class.php.
References $amount, $array, $fiche, $g_user, $i, $line, $Max, $periode, $Res, $row, $tot_cred, $tot_deb, ATTR_DEF_NAME, db, DatabaseCore\fetch_all(), h, noalyss_strlentrim(), DatabaseCore\num_row(), and sql_filter_per().
Referenced by export_accounting_html(), and export_csv().
Acc_Ledger_History_Generic::get_rowSimple | ( | $trunc = 0 , |
|
$p_limit = -1 , |
|||
$p_offset = -1 |
|||
) |
Get simplified row from ledger.
p_from | periode |
p_to | periode |
p_limit | starting line |
p_offset | number of lines |
trunc | if data must be truncated (pdf export) |
Definition at line 416 of file acc_ledger_history_generic.class.php.
References $array, $g_user, $jrn, $Max, $periode, $Res, $sql, db, DatabaseCore\fetch_all(), DatabaseCore\num_row(), and sql_filter_per().
Referenced by export_oneline_html().
|
private |
array of rows
Definition at line 36 of file acc_ledger_history_generic.class.php.
Referenced by get_data().