noalyss Version-9
|
search in ledger More...
Public Member Functions | |
__construct ($p_type, $p_all=1, $p_div="") | |
return a HTML string with the form for the search More... | |
build_name_filter () | |
Build the button for saving the filter for search. More... | |
build_search_filter () | |
Build the button for managing the filter for search. More... | |
build_search_sql ($p_array, $p_order="", $p_where="") | |
this function will create a sql stmt to use to create the list for the ledger, More... | |
button_propose_filter () | |
build an HTML string with a button to show the list of saved search More... | |
display_list_filter () | |
display a list of saved search More... | |
display_search_form () | |
return a html string with the search_form More... | |
get_all () | |
get_div () | |
get_type () | |
list_operation ($sql, $offset, $p_paid=0) | |
Show all the operation. More... | |
list_operation_to_reconcile ($sql, $p_target) | |
Show all the operation. More... | |
search_form () | |
select_ledger ($p_selected, $p_div) | |
return the html code to create an hidden div and a button to show this DIV. More... | |
set_all ($all) | |
set_div ($div) | |
set_type ($type) | |
Static Public Member Functions | |
static | build_array (User_Filter_SQL $user_filter_sql) |
use a user_filter row and turns it into an array for javascript purpose More... | |
Data Fields | |
$id | |
prefix for id of DOM id id of the ledger More... | |
Protected Attributes | |
$cn | |
Database Connection. More... | |
Private Attributes | |
$all | |
Flag to indicate if all ledgers must searched (1 for yes) More... | |
$div | |
$type | |
type of ledger : FIN,ODS,VEN,ACH More... | |
search in ledger
Definition at line 33 of file acc_ledger_search.class.php.
Acc_Ledger_Search::__construct | ( | $p_type, | |
$p_all = 1 , |
|||
$p_div = "" |
|||
) |
return a HTML string with the form for the search
$p_type | if the type of ledger possible values=ALL,VEN,ACH,ODS,FIN: uppercase ! | |
$all_type_ledger | values :
| |
$div | is the div (for reconciliation) | |
type | $p_type | |
type | $p_all | |
type | $p_div |
Definition at line 57 of file acc_ledger_search.class.php.
References $p_type, cn, Dossier\connect(), and set_type().
|
static |
use a user_filter row and turns it into an array for javascript purpose
User_Filter_SQL | $user_filter_sql |
Definition at line 1324 of file acc_ledger_search.class.php.
Acc_Ledger_Search::build_name_filter | ( | ) |
Build the button for saving the filter for search.
Definition at line 281 of file acc_ledger_search.class.php.
References $name, $r, and Dossier\id().
Acc_Ledger_Search::build_search_filter | ( | ) |
Build the button for managing the filter for search.
type | $p_div | id prefix of the div, button, table .. |
$this->type | if the type of ledger possible values=ALL,VEN,ACH,ODS,FIN | |
$all_type_ledger | values :
|
Definition at line 269 of file acc_ledger_search.class.php.
References $r, Dossier\id(), noalyss_str_replace(), and type.
Referenced by display_search_form(), and search_form().
Acc_Ledger_Search::build_search_sql | ( | $p_array, | |
$p_order = "" , |
|||
$p_where = "" |
|||
) |
this function will create a sql stmt to use to create the list for the ledger,
$p_array | is usually the $_GET, |
$p_order | the order of the row --> not used |
$p_where | is the sql condition if not null then the $p_array will not be used |
( [gDossier] => 13 [p_jrn] => -1 [date_start] => [date_end] => [amount_min] => 0 [amount_max] => 0 [desc] => [search] => Rechercher [p_action] => ven [sa] => l )
Definition at line 319 of file acc_ledger_search.class.php.
References $a, $accounting, $aTag, $date_end, $date_start, $desc, $div, $g_user, $hide_operation, $i, $ledger_type, $op, $p_action, $p_array, $p_id, $periode, $qcode, $r_jrn, $sp, $sql, cn, if, isDate(), isNumber(), sql_string(), toNumber(), and type.
Acc_Ledger_Search::button_propose_filter | ( | ) |
build an HTML string with a button to show the list of saved search
Exception | if $_REQUEST['ac'] is not set |
Definition at line 1342 of file acc_ledger_search.class.php.
References $http, HtmlInput\button_action(), and Dossier\id().
Acc_Ledger_Search::display_list_filter | ( | ) |
display a list of saved search
Definition at line 1357 of file acc_ledger_search.class.php.
Acc_Ledger_Search::display_search_form | ( | ) |
return a html string with the search_form
Definition at line 718 of file acc_ledger_search.class.php.
References $_REQUEST, $button_search, $http, $r, build_search_filter(), HtmlInput\button_hide(), HtmlInput\hidden(), search_form(), HtmlInput\submit(), and HtmlInput\title_box().
Acc_Ledger_Search::get_all | ( | ) |
Definition at line 70 of file acc_ledger_search.class.php.
References $all.
Acc_Ledger_Search::get_div | ( | ) |
Definition at line 75 of file acc_ledger_search.class.php.
References $div.
Acc_Ledger_Search::get_type | ( | ) |
Definition at line 65 of file acc_ledger_search.class.php.
References $type.
Acc_Ledger_Search::list_operation | ( | $sql, | |
$offset, | |||
$p_paid = 0 |
|||
) |
Show all the operation.
$sql | is the sql stmt, normally created by build_search_sql |
$offset | the offset |
$p_paid | if we want to see info about payment // Example
// Build the sql
// Count nb of line
$step=$_SESSION[SESSION_KEY.'g_pagesize'];
// create the nav. bar
// show a part
echo $html;
// show nav bar
echo $bar;
foreach(array( 'l', 'gDossier') as $a) if(is_numeric($l)==false) $Ledger Definition: ajax_get_receipt.php:51 navigation_bar($p_offset, $p_line, $p_size=0, $p_page=1, $p_javascript="") Create a navigation_bar (pagesize) Definition: user_common.php:76 |
Definition at line 792 of file acc_ledger_search.class.php.
References $_GET, $a, $count, $g_parameter, $g_user, $gDossier, $i, $limit, $Max, $offset, $operation, $ord, $order, $other, $r, $Res, $row, $sql, $str_dossier, $table, $tot, $url, $w, HtmlInput\card_detail(), cn, DatabaseCore\fetch_array(), h, id, nbm(), DatabaseCore\num_row(), td(), th(), and type.
Acc_Ledger_Search::list_operation_to_reconcile | ( | $sql, | |
$p_target | |||
) |
Show all the operation.
$sql | is the sql stmt, normally created by build_search_sql |
$offset | the offset |
$p_paid | if we want to see info about payment |
Definition at line 1092 of file acc_ledger_search.class.php.
References $a, $count, $g_parameter, $g_user, $gDossier, $href, $i, $limit, $Max, $operation, $other, $r, $Res, $row, $sql, $str_dossier, $tot, cn, DatabaseCore\fetch_array(), h, HtmlInput\hidden(), id, Dossier\id(), nbm(), DatabaseCore\num_row(), td(), th(), and type.
Acc_Ledger_Search::search_form | ( | ) |
Definition at line 108 of file acc_ledger_search.class.php.
References $_REQUEST, $date_end, $date_end_hidden, $date_start, $exercice, $g_parameter, $g_user, $http, $i, $per, $r, build_search_filter(), cn, HtmlInput\hidden(), Dossier\id(), Icon_Action\infobulle(), noalyss_str_replace(), and type.
Referenced by display_search_form().
Acc_Ledger_Search::select_ledger | ( | $p_selected, | |
$p_div | |||
) |
return the html code to create an hidden div and a button to show this DIV.
This contains all the available ledgers for the user in READ or RW
$p_selected | is an array of checkbox |
$p_div | div suffix for the list of ledgers |
Definition at line 1246 of file acc_ledger_search.class.php.
References $class, $e, $g_user, $idx, $nb_array, $p_array, $r, $ret, $row, HtmlInput\anchor_action(), HtmlInput\button_close(), HtmlInput\hidden(), HtmlInput\submit(), th(), HtmlInput\title_box(), and type.
Acc_Ledger_Search::set_all | ( | $all | ) |
Definition at line 89 of file acc_ledger_search.class.php.
References $all.
Acc_Ledger_Search::set_div | ( | $div | ) |
Definition at line 94 of file acc_ledger_search.class.php.
References $div.
Acc_Ledger_Search::set_type | ( | $type | ) |
Definition at line 80 of file acc_ledger_search.class.php.
References $type, EXC_PARAM_VALUE, and type.
Referenced by __construct().
|
private |
Flag to indicate if all ledgers must searched (1 for yes)
Definition at line 38 of file acc_ledger_search.class.php.
|
protected |
Database Connection.
Definition at line 36 of file acc_ledger_search.class.php.
|
private |
Definition at line 39 of file acc_ledger_search.class.php.
Referenced by build_search_sql(), get_div(), and set_div().
Acc_Ledger_Search::$id |
prefix for id of DOM id id of the ledger
Definition at line 41 of file acc_ledger_search.class.php.
|
private |
type of ledger : FIN,ODS,VEN,ACH
Definition at line 37 of file acc_ledger_search.class.php.
Referenced by get_type(), and set_type().