noalyss Version-9
|
manage the stocks More...
Public Member Functions | |
build_tmp_table ($p_array) | |
create_query_histo ($p_array) | |
export_stock_histo_form () | |
export_stock_summary_list_form () | |
history ($p_array) | |
show history of all the stock movement More... | |
search_box ($p_array) | |
search_box_button () | |
summary ($p_array) | |
Public Member Functions inherited from Stock_Sql | |
__construct ($cn, $p_id=-1) | |
Public Member Functions inherited from Table_Data_SQL | |
__construct ($p_cn, $p_id=-1) | |
build_query () | |
Build the SQL select statement for querying the object and returns it. More... | |
column_update ($column_expr, $value) | |
update the value of a column with an expression for $value for the current record More... | |
count ($p_where="", $p_array=null) | |
return the number of count in the table corresponding to the where condition More... | |
delete () | |
exist () | |
Count the number of record with the id ,. More... | |
get_all_to_array ($p_key_col, $p_cond="", $p_array=NULL) | |
Get all the row and use the p_key_code are the key value of array. More... | |
insert () | |
load () | |
Load the current row return false if not found. More... | |
seek ($cond='', $p_array=null) | |
retrieve array of object thanks a condition More... | |
update () | |
Public Member Functions inherited from Data_SQL | |
__construct (DatabaseCore $p_cn, $p_id=-1) | |
__toString () | |
collect_objects ($cond='', $p_array=null) | |
return an array of objects. More... | |
count ($p_where="", $p_array=null) | |
delete () | |
exist () | |
Count the number of record with the id ,. More... | |
from_array ($p_array) | |
Transform an array into object. More... | |
get ($p_string) | |
get the value thanks the colum name and not the alias (name). More... | |
get_cn () | |
get_info () | |
get_name () | |
get_object ($p_ret, $idx) | |
get_pk_value () | |
get_primary_key () | |
get_type () | |
getp ($p_string) | |
set the value thanks the alias name instead of the colum name More... | |
insert () | |
load () | |
Load the current row return false if not found. More... | |
next ($ret, $i) | |
get_seek return the next object, the return of the query must have all the column of the object More... | |
save () | |
Insert or update : if the row already exists, update otherwise insert. More... | |
seek ($cond='', $p_array=null) | |
retrieve array of object thanks a condition More... | |
set ($p_string, $p_value) | |
set the value thanks the colum name and not the alias (name) More... | |
set_cn ($cn) | |
set_name ($name) | |
set_pk_value ($p_value) | |
set_primary_key ($primary_key) | |
set_type ($type) | |
setp ($p_string, $p_value) | |
set the value thanks the alias name instead of the colum name More... | |
to_array ($prefix="") | |
Turn an object (row) into an array, and the key could be prefixed with $prefix. More... | |
to_row ($p_array) | |
turns a row fetched from the DB into a SQL object in updating all his attribute More... | |
update () | |
verify () | |
Additional Inherited Members | |
Data Fields inherited from Data_SQL | |
$cn | |
$date_format | |
Type of the data. More... | |
$default | |
defaullt date format More... | |
$name | |
Database connection. More... | |
$primary_key | |
Array of logical and real name. More... | |
$table | |
$type | |
Column name of the primary key. More... | |
manage the stocks
Definition at line 36 of file stock.class.php.
Stock::build_tmp_table | ( | $p_array | ) |
Definition at line 262 of file stock.class.php.
References Data_SQL\$cn, $date, $g_user, $p_array, $periode, $periode_id, $tmp_id, and format_date().
Referenced by summary().
Stock::create_query_histo | ( | $p_array | ) |
Definition at line 160 of file stock.class.php.
References Data_SQL\$cn, $f, $g_user, $p_array, $profile, $sql, cn, isNumber(), and sql_string().
Referenced by history().
Stock::export_stock_histo_form | ( | ) |
Definition at line 83 of file stock.class.php.
References HtmlInput\get_to_hidden(), HtmlInput\hidden(), and HtmlInput\submit().
Referenced by history().
Stock::export_stock_summary_list_form | ( | ) |
Definition at line 92 of file stock.class.php.
References HtmlInput\get_to_hidden(), HtmlInput\hidden(), and HtmlInput\submit().
Referenced by summary().
Stock::history | ( | $p_array | ) |
show history of all the stock movement
$p_array | usually contains $_GET |
Definition at line 43 of file stock.class.php.
References $_GET, $max_row, $offset, $order, $p_array, $p_url, $page, $res, $sql, $step, $tb, cn, create_query_histo(), export_stock_histo_form(), HtmlInput\get_to_string(), navigation_bar(), DatabaseCore\num_row(), HtmlInput\print_window(), search_box(), and search_box_button().
Stock::search_box | ( | $p_array | ) |
Definition at line 107 of file stock.class.php.
References $exercice, $g_user, $p_array, $periode, $periode_end, $periode_start, cn, HtmlInput\default_value(), and HtmlInput\select_stock().
Referenced by history().
Stock::search_box_button | ( | ) |
Definition at line 101 of file stock.class.php.
References HtmlInput\button().
Referenced by history().
Stock::summary | ( | $p_array | ) |
Definition at line 235 of file stock.class.php.
References Data_SQL\$cn, $g_user, $p_array, $tmp_id, build_tmp_table(), export_stock_summary_list_form(), and HtmlInput\print_window().