34require_once NOALYSS_INCLUDE.
'/database/stock_sql.class.php';
48 "wamount_start",
"wamount_end",
"wcode_stock",
"wdirection"));
51 $tb->add(
"Date",
$p_url,
" order by real_date asc",
"order by real_date desc",
"da",
"dd");
52 $tb->add(
"Code Stock",
$p_url,
" order by sg_code asc",
"order by sg_code desc",
"sa",
"sd");
53 $tb->add(
"Dépôt",
$p_url,
" order by r_name asc",
"order by r_name desc",
"ra",
"rd");
54 $tb->add(
"Fiche",
$p_url,
" order by 2 asc",
"order by 2 desc",
"fa",
"fd");
55 $tb->add(
"Commentaire",
$p_url,
" order by coalesce(sg_comment,jr_comment) asc",
"order by coalesce(sg_comment,jr_comment) desc",
"ca",
"cd");
56 $tb->add(
"Montant",
$p_url,
" order by j_montant asc",
"order by j_montant desc",
"ja",
"jd");
57 $tb->add(
"Quantité",
$p_url,
" order by sg_quantity asc",
"order by sg_quantity desc",
"qa",
"qd");
58 $tb->add(
"IN/OUT",
$p_url,
" order by (case when sg_type='c' then 'OUT' when sg_type='c' then 'IN' end ) asc",
"order by (case when sg_type='c' then 'OUT' when sg_type='c' then 'IN' end ) desc",
"ta",
"td");
62 $step = $_SESSION[SESSION_KEY.
'g_pagesize'];
78 require_once NOALYSS_TEMPLATE.
'/stock_histo.php';
85 echo
'<form style="display:inline" method="GET" action="export.php">';
87 "wamount_start",
"wamount_end",
"wcode_stock",
"wdirection"));
94 echo
'<form style="display:inline" method="GET" action="export.php">';
103 $bt =
HtmlInput::button(
"Recherche",
"Recherche",
' onclick="$(\'histo_search_d\').show();"');
112 $wrepo->value[] = array(
'value' => -1,
'label' =>
'Tous les dépôts');
114 $wdate_start =
new IDate(
'wdate_start');
115 $wdate_end =
new IDate(
'wdate_end');
116 $wamount_start =
new INum(
'wamount_start');
117 $wamount_end =
new INum(
'wamount_end');
118 $wcard =
new ICard(
'wcard');
119 $wcode_stock =
new ICard(
'wcode_stock');
120 $wdirection =
new ISelect(
"wdirection");
137 $wcard->extra =
"all";
138 $wcard->set_attribute(
"typecard",
"all");
142 $wcode_stock->extra =
" [sql] fd_id=500000 ";
143 $wcode_stock->set_attribute(
"typecard",
"[sql] fd_id=500000");
150 $wdirection->value = array(
151 array(
'value' =>
"-1",
'label' =>
"Tout"),
152 array(
'value' =>
"c",
'label' =>
"OUT"),
153 array(
'value' =>
"d",
'label' =>
"IN")
157 require_once NOALYSS_TEMPLATE.
'/stock_histo_search.php';
167 (select ad_value from fiche_Detail as fd1 where ad_id=1 and fd1.f_id=jx.f_id) as fname,
168 (select ad_value from fiche_Detail as fd1 where ad_id=23 and fd1.f_id=jx.f_id) as qcode,
170 coalesce(sg_comment,jr_comment) as ccomment,
177 case when sg_type='c' then 'OUT' when sg_type='d' then 'IN' end as direction,
180 coalesce(sg_date,jr_date) as real_date,
181 to_char(coalesce(sg_date,jr_date),'DD.MM.YY') as cdate
182 from stock_goods as sg
183 join stock_repository as sr on (sg.r_id=sr.r_id)
184 left join jrnx as jx on (sg.j_id=jx.j_id)
185 left join jrn as j on (j.jr_grpt_id=jx.j_grpt)
187 sg.r_id in (select r_id from profile_sec_repository where p_id = $profile)";
192 $clause = $and.
" to_date('" .
sql_string(
$p_array[
'wdate_start']) .
"','DD.MM.YYYY')<=coalesce(sg_date,jr_date) ";
196 $clause.=$and .
" to_date('" .
sql_string(
$p_array[
'wdate_end']) .
"','DD.MM.YYYY')>=coalesce(sg_date,jr_date) ";
221 $clause.=$and .
" upper(sg_code) = upper('" .
sql_string(trim(
$p_array[
'wcode_stock'])) .
"')";
232 return $sql . $clause;
240 $a_repository =
$g_user->get_available_repository(
'R');
241 $a_code =
$cn->get_array(
"select distinct sg_code from tmp_stockgood_detail where s_id=$1", array(
$tmp_id));
252 require_once NOALYSS_TEMPLATE.
'/stock_summary_table.php';
256 require_once NOALYSS_TEMPLATE.
'/stock_summary_list.php';
266 if (isset (
$p_array[
'state_exercice']))
277 $tmp_id =
$cn->get_next_seq(
"public.tmp_stockgood_s_id_seq");
278 $cn->exec_sql(
"delete from tmp_stockgood where s_date < now() - interval '2 days' ");
279 $cn->exec_sql(
"insert into tmp_stockgood(s_id) values ($1)", array(
$tmp_id));
282 $a_repository =
$g_user->get_available_repository(
'R');
286 insert into tmp_stockgood_detail(s_id,sg_code,s_qin,r_id,f_id)
287 select $tmp_id,trim(sg_code), coalesce(sum(sg_quantity),0) as qin,r_id,f_id
292 and j_id in (select j_id from jrnx where j_tech_per in (select p_id from parm_periode where p_exercice=$2))
293 and r_id in (select r_id from profile_sec_repository where p_id=$1)
294 group by r_id,trim(sg_code),f_id
300 insert into tmp_stockgood_detail(s_id,sg_code,s_qout,r_id,f_id)
301 select $tmp_id,trim(sg_code) , coalesce(sum(sg_quantity),0) as qout,r_id,f_id
302 from stock_goods as sg
305 and sg.j_id is not null
306 and sg.j_id in (select j_id from jrnx where j_tech_per in (select p_id from parm_periode where p_exercice=$2))
307 and sg.r_id in (select r_id from profile_sec_repository where p_id=$1)
308 group by r_id,trim(sg_code),f_id
314 insert into tmp_stockgood_detail(s_id,sg_code,s_qin,r_id,f_id)
315 select $tmp_id,trim(sg_code) , coalesce(sum(sg_quantity),0) as qin,r_id,f_id
316 from stock_goods as sg
320 and sg_date >= ( select min(p_start) from parm_periode where p_exercice=$2)
321 and sg_date <= ( select max(p_end) from parm_periode where p_exercice=$2)
322 and sg.r_id in (select r_id from profile_sec_repository where p_id=$1)
323 group by r_id,trim(sg_code),f_id
328 insert into tmp_stockgood_detail(s_id,sg_code,s_qout,r_id,f_id)
329 select $tmp_id,trim(sg_code), coalesce(sum(sg_quantity),0) as qout,r_id,f_id
334 and r_id in (select r_id from profile_sec_repository where p_id=$1)
335 and sg_date >= ( select min(p_start) from parm_periode where p_exercice=$2)
336 and sg_date <= ( select max(p_end) from parm_periode where p_exercice=$2)
337 group by r_id,trim(sg_code),f_id
format_date($p_date, $p_from_format='YYYY-MM-DD', $p_to_format='DD.MM.YYYY')
format the date, when taken from the database the format is MM-DD-YYYY
sql_string($p_string)
Fix the problem with the quote char for the database.
global $g_user
if no group available , then stop
catch(Exception $e) $exercice
static num_row($ret)
wrapper for the function pg_num_rows
define Class fiche and fiche def, those class are using class attribut. When adding or modifing new c...
Input HTML for the card show buttons, in the file, you have to add card.js How to use :
Html Input : Input a date format dd.mm.yyyy The property title should be set to indicate what it is e...
This class handles only the numeric input, the input will call a javascript to change comma to period...
Html Input , create a tag <SELECT> ... </SELECT> if readonly == true then display the label correspon...
For the periode tables parm_periode and jrn_periode.
Description of class_syn_sort_table.
ORM abstract of the table public.stock_repository.
create_query_histo($p_array)
history($p_array)
show history of all the stock movement
export_stock_summary_list_form()
export_stock_histo_form()
build_tmp_table($p_array)
if($g_parameter->MY_STOCK=='N') if(isset( $_POST[ 'add_stock'])) if(isset($_POST['mod_stock'])) $tb
navigation_bar($p_offset, $p_line, $p_size=0, $p_page=1, $p_javascript="")
Create a navigation_bar (pagesize)