Exercice Class Reference

about the accountancy period (usually 1 year starting in January until december) = exercice More...

Collaboration diagram for Exercice:

Public Member Functions
	__construct ($cn)
	count ()
	return the number of different exercices into a folder More...
	exercice_from_label ($p_label)
	retrieve the exercice from the exercice label More...
	select ($name, $selected='', $js='')
	Show a ISelect with the different exercices. More...
	select_date ($name, $selected='', $js='')
	Show a ISelect with the different exercices, display start and end date. More...

Data Fields
	$cn

Detailed Description

about the accountancy period (usually 1 year starting in January until december) = exercice

Definition at line 30 of file exercice.class.php.

Constructor & Destructor Documentation

__construct()

Exercice::__construct

(

$cn

)

Definition at line 33 of file exercice.class.php.

  {
    $this->cn=$cn;
  }

References $cn, and cn.

Member Function Documentation

count()

Exercice::count

(

)

return the number of different exercices into a folder

Parameters

$cn	is the database connexion object database

Returns

the count of exercice

Definition at line 42 of file exercice.class.php.

  {
    $count=$this->cn->get_value('select count(distinct p_exercice) from parm_periode');
    return $count;
  }

References $count, and cn.

exercice_from_label()

Exercice::exercice_from_label

(

$p_label

)

retrieve the exercice from the exercice label

Parameters

string

$p_label

Definition at line 85 of file exercice.class.php.

   {
       $value  = $this->cn->get_value("select distinct p_exercice from parm_periode where p_exercice_label=$1",
               [$p_label]);
       if ($value == "") return -1;
       return $value;
   }

References $value, and cn.

select()

Exercice::select	(		$name,
			$selected = '',
			$js = ''
	)

Show a ISelect with the different exercices.

Parameters

$name	of the iselect
$selected	the selected year (default = '')
$js	javascript (default = '')

Returns

ISelect object

Definition at line 54 of file exercice.class.php.

   {
     $iselect=new ISelect($name);
     $iselect->value=$this->cn->make_array('select distinct p_exercice,p_exercice_label from parm_periode order by 1 desc');
     $iselect->selected=$selected;
     $iselect->javascript=$js;
     return $iselect;
   }

References $iselect, $js, $name, $selected, and cn.

select_date()

Exercice::select_date	(		$name,
			$selected = '',
			$js = ''
	)

Show a ISelect with the different exercices, display start and end date.

Parameters

$name	of the iselect
$selected	the selected year (default = '')
$js	javascript (default = '')

Returns

ISelect object

Definition at line 69 of file exercice.class.php.

   {
     $iselect=new ISelect($name);
     $iselect->value=$this->cn->make_array("select distinct p_exercice,to_char (min(p_start),'DD.MM.YY')
                                                                                                                                         ||' - '
                                                                                                                                         ||to_char (max(p_end),'DD.MM.YY')
                                                                                        from parm_periode
                                                                                        group by p_exercice order by 1");
     $iselect->selected=$selected;
     $iselect->javascript=$js;
     return $iselect;
   }

References $iselect, $js, $name, $selected, and cn.

Field Documentation

$cn

Exercice::$cn

Definition at line 32 of file exercice.class.php.

Referenced by __construct().

---

The documentation for this class was generated from the following file:

• include/class/exercice.class.php