44 $count=$this->
cn->get_value(
'select count(distinct p_exercice) from parm_periode');
57 $iselect->value=$this->
cn->make_array(
'select distinct p_exercice,p_exercice_label from parm_periode order by 1 desc');
72 $iselect->value=$this->
cn->make_array(
"select distinct p_exercice,to_char (min(p_start),'DD.MM.YY')
74 ||to_char (max(p_end),'DD.MM.YY')
76 group by p_exercice order by 1");
87 $value = $this->
cn->get_value(
"select distinct p_exercice from parm_periode where p_exercice_label=$1",
89 if (
$value ==
"")
return -1;
about the accountancy period (usually 1 year starting in January until december) = exercice
select($name, $selected='', $js='')
Show a ISelect with the different exercices.
count()
return the number of different exercices into a folder
exercice_from_label($p_label)
retrieve the exercice from the exercice label
select_date($name, $selected='', $js='')
Show a ISelect with the different exercices, display start and end date.
Html Input , create a tag <SELECT> ... </SELECT> if readonly == true then display the label correspon...