Periode Class Reference

For the periode tables parm_periode and jrn_periode. More...

Collaboration diagram for Periode:

Public Member Functions
	__construct ($p_cn, $p_id=0)
	__toString ()
	centralized ()
	close ()
	Close a periode , if Periode::jrn_def_id is set to a different value than 0 , it close only for this ledger id ; otherwise close for all periode.
	count_operation ()
	count the number of operation of a Periode
	delete ()
	find_periode ($p_date)
	retrieve the periode thanks the date_end
	first_day ($p=0)
	return the first day of periode the this->p_id must be set
	get_date_limit ($p_periode=0)
	Give the start & end date of a periode.
	get_exercice ($p_id=0)
	get_first_date ()
	retrieve the first day of the first exercice
	get_first_periode ()
	retrieve the first periode of the folder or -1 if none
	get_limit ($p_exercice)
	return the max (to periode) and the min periode (from periode) of the exercice given in parameter
	insert ($p_date_start, $p_date_end, $p_exercice, $p_exercice_label)
	Add new periode.
	insert_exercice ($p_exercice, $p_year, $p_from_month, $p_month, $p_opening, $p_closing, $p_exercice_label)
	add a exercice starting in year p_year with p_month month, with a starting and a closing
	is_centralized ()
	Return 1 if periode is centralized.
	is_closed ()
	check if a periode is closed. If jrn_def_id is set to a no zero value then check only for this ledger
	is_open ()
	Return 1 if the periode is open otherwise 0.
	last_day ($p=0)
	return the last day of periode the this->p_id must be set
	limit_year ($p_exercice)
	return the p_id of the start and the end of the exercice into an array
	load ()
	load data from database
	reopen ()
	set_ledger ($p_jrn)
	set_periode ($pp_id)
	verify_delete ()
	Verify before delete that the month is not used.

Static Public Member Functions
static	display_periode_global ($p_js)
	Display a table with all the periode.
static	display_row_global (Parm_Periode_SQL $obj, $p_nb, $p_js)
	Display each row for the global.
static	filter_exercice ($p_sel)
static	form_exercice_add ()
	display a form (method POST) to input a new exercice variable in the FORM
static	form_exercice_label ()
	form to change the label of exercice
static	form_periode_add ($p_js_var)
	Display a form for the input of a new periode.

Data Fields
	$cn
	$jrn_def_id
	$p_central
	$p_closed
	$p_end
	$p_exercice
	$p_exercice_label
	$p_id
	$p_start
	$status

Detailed Description

For the periode tables parm_periode and jrn_periode.

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

Constructor & Destructor Documentation

__construct()

Periode::__construct	(		$p_cn,
			$p_id = 0 )

Definition at line 46 of file periode.class.php.

    {
        $this->p_id=$p_id;
        $this->cn=$p_cn;
        $this->jrn_def_id=0;
    }

References $p_id, cn, jrn_def_id, and p_id.

Member Function Documentation

__toString()

Periode::__toString

(

)

Definition at line 53 of file periode.class.php.

                                : string
    {
      $r=<<<EOF
Object Periode [
    \$jrn_def_id=>$this->jrn_def_id,
     \$p_id=>$this->p_id,
     \$status => $this->status,
     \$p_start => $this->p_start,
     \$p_end => $this->p_end,
] 
EOF;
      return $r;
 
    }

References $jrn_def_id, $p_end, $p_end, $p_id, $p_id, $p_start, $p_start, $r, $status, and $status.

centralized()

Periode::centralized

(

)

Deprecated

since version 5

Returns

type

Definition at line 227 of file periode.class.php.

    {
        if ($this->jrn_def_id==0)
        {
            $this->cn->exec_sql("update parm_periode set p_central=true");
            return;
        }
        else
        {
            $this->cn->exec_sql("update jrn_periode set status='CE' ".
                    " where ".
                    " p_id = $1", [$this->p_id]);
            return;
        }
    }

References cn, jrn_def_id, and p_id.

close()

Periode::close

(

)

Close a periode , if Periode::jrn_def_id is set to a different value than 0 , it close only for this ledger id ; otherwise close for all periode.

Definition at line 193 of file periode.class.php.

    {
        if ($this->jrn_def_id==0)
        {
            $this->cn->exec_sql("update parm_periode set p_closed=true where p_id=$1",
                    [$this->p_id]);
            $this->cn->exec_sql("update jrn_periode set status='CL' 
                                 where p_id = $1", [$this->p_id]);
 
            return;
        }
        else
        {
            $this->cn->exec_sql("update jrn_periode set status='CL' ".
                    " where jrn_def_id=$1  and 
                                 p_id = $2", [$this->jrn_def_id, $this->p_id]);
            /* if all ledgers have this periode closed then synchro with
              the table parm_periode
             */
            $nJrn=$this->cn->count_sql("select * from jrn_periode where ".
                    " p_id=$1", [$this->p_id]);
            $nJrnPeriode=$this->cn->count_sql("select * from jrn_periode where ".
                    " p_id=$1  and status='CL'", [$this->p_id]);
 
            if ($nJrnPeriode==$nJrn)
                $this->cn->exec_sql("update parm_periode set p_closed=true where p_id=$1",
                        [$this->p_id]);
            return;
        }
    }

References cn, jrn_def_id, and p_id.

count_operation()

Periode::count_operation

(

)

count the number of operation of a Periode

Returns

integer

Definition at line 573 of file periode.class.php.

    {
        $count=$this->cn->get_value("
                select count(*) 
                from 
                    jrn 
                where 
                    jr_tech_per = $1", [$this->p_id]);
        return $count;
    }

References $count, cn, and p_id.

delete()

Periode::delete

(

)

Definition at line 709 of file periode.class.php.

                      {
        $this->cn->exec_sql("delete from parm_periode where p_id=$1",[$this->p_id]);
    }

References cn, and p_id.

display_periode_global()

static Periode::display_periode_global ( $p_js )

static

Display a table with all the periode.

Parameters

$p_js

javascript variable

See also

noalyss_script.js

Definition at line 537 of file periode.class.php.

    {
        $cn=Dossier::connect();
        $periode=new Parm_Periode_SQL($cn);
        $ret=$periode->seek(" order by   p_start asc");
        $nb_periode=Database::num_row($ret);
 
        if ($nb_periode==0)
            return;
        echo '<table class="result" id="periode_tbl">';
        echo "<thead>";
        echo "<tr>";
        echo th("");
        echo th(_("Date Début"));
        echo th(_("Date Fin"));
        echo th(_("Exercice"));
        echo th(_("Libellé"),'class="visible_gt800"');
        echo th(_("nb opérations"));
        echo th(_("Status"));
        echo "</tr>";
        echo "</thead>";
        echo '<tbody>';
 
        for ($i=0; $i<$nb_periode; $i++)
        {
            $obj=$periode->next($ret, $i);
            Periode::display_row_global($obj, $i, $p_js);
        }
        echo '</tbody>';
        echo '</table>';
    }

References $cn, $i, $obj, $periode, $ret, _, display_row_global(), DatabaseCore\num_row(), and th().

Here is the call graph for this function:

display_row_global()

static Periode::display_row_global ( Parm_Periode_SQL $obj, $p_nb, $p_js )

static

Display each row for the global.

Parameters

$obj	Parm_Periode_SQL
$p_nb	not used so far
$p_js	javascript variable

Display a checkbox to select several month to close

Can close if open

Definition at line 590 of file periode.class.php.

    {
        $periode=new Periode($obj->cn, $obj->p_id);
        $class=($p_nb%2==0)?"even":"odd";
        printf('<tr id="row_per_%d" customkey="%s" per_exercice="%s" p_id="%s" class="%s"> ',
                $obj->getp("p_id"), 
                $obj->getp("p_start"),
                $obj->getp("p_exercice"),
                $obj->getp("p_id"), $class);
        /**
         * Display a checkbox to select several month to close
         */
        if ($obj->getp("p_closed")=="f")
        {
            $checkbox=new ICheckBox("sel_per_close[]");
            $checkbox->set_range("sel_per_close_ck");
            $checkbox->set_attribute("per_id", $obj->getp("p_id"));
            $checkbox->value=$obj->getp("p_id");
            echo "<td>".$checkbox->input()."</td>";
        }
        else
        {
            echo td("");
        }
        echo td(format_date($obj->getp("p_start"), "YYYY-MM-DD", "DD.MM.YYYY"));
        echo td(format_date($obj->getp("p_end"), "YYYY-MM-DD", "DD.MM.YYYY"));
        echo td($obj->getp("p_exercice"));
        echo td($obj->getp("p_exercice_label"),'class="visible_gt800"');
        $nb_operation=$periode->count_operation();
        echo td($nb_operation);
        $closed=$obj->getp('p_closed');
        $status=($closed=='t')?_("Fermée"):_("Ouvert");
        echo td($status);
 
        // if no operation then this periode can be removed or updated
        if ($nb_operation==0)
        {
            // Updatable 
            $js=sprintf("%s.box_display('%d')", $p_js, $obj->p_id);
            echo "<td>";
            echo Icon_Action::modify(uniqid(), $js);
            echo "</td>";
            //removable
            $js=sprintf("%s.remove('%d')", $p_js, $obj->p_id);
            echo "<td>";
            echo Icon_Action::trash(uniqid(), $js);
            echo "</td>";
        }
        else
        {
            echo td(""), td("");
        }
 
        /// Can close if open
        echo "<td>";
        if ($obj->getp("p_closed")=='f')
        {
            $javascript=sprintf('%s.close_periode(\'%d\')', $p_js, $obj->p_id);
            echo Icon_Action::iconon(uniqid(), $javascript);
        }
        else
        {
            $javascript=sprintf("%s.open_periode('%d')", $p_js, $obj->p_id);
            echo Icon_Action::iconoff(uniqid(),$javascript );
        }
        echo "</td>";
        echo "</tr>";
    }

References $checkbox, $class, $js, $nb_operation, $obj, $periode, $status, _, format_date(), Icon_Action\iconoff(), Icon_Action\iconon(), Icon_Action\modify(), td(), and Icon_Action\trash().

Referenced by display_periode_global().

Here is the call graph for this function:

filter_exercice()

static Periode::filter_exercice ( $p_sel )

static

Definition at line 762 of file periode.class.php.

    {
        $cn=Dossier::connect();
        $i_exercice=new ISelect("p_exercice_sel");
        $i_exercice->value=$cn->make_array("select distinct p_exercice,p_exercice_label from parm_periode order by 1 desc", 1);
        $i_exercice->javascript="onchange=\"Periode.filter_exercice('periode_tbl')\"";
        $i_exercice->selected=$p_sel;
        echo $i_exercice->input();
    }

References $cn.

find_periode()

Periode::find_periode

(

$p_date

)

retrieve the periode thanks the date_end

Parameters

$p_date

format DD.MM.YYYY

Returns

the periode id

Exceptions

if	not periode is found or if more than one periode is found

Definition at line 420 of file periode.class.php.

    {
        $sql="select p_id from parm_periode where p_start <= to_date($1,'DD.MM.YYYY') and p_end >= to_date($1,'DD.MM.YYYY') ";
        $ret=$this->cn->exec_sql($sql, array($p_date));
        $nb_periode=Database::num_row($ret);
        if ($nb_periode==0)
            throw (new Exception(_('Aucune période trouvée')." $p_date ", 101));
        if ($nb_periode>1)
            throw (new Exception(sprintf(_("Trop de périodes trouvées %s pour %s"),$nb_periode,$p_date),
            100));
        $per=Database::fetch_result($ret, 0);
        $this->p_id=$per;
        return $per;
    }

References $p_date, $per, $ret, $sql, _, cn, DatabaseCore\fetch_result(), DatabaseCore\num_row(), and p_id.

Here is the call graph for this function:

first_day()

Periode::first_day

(

$p = 0

)

return the first day of periode the this->p_id must be set

Returns

a string with the date (DD.MM.YYYY)

Definition at line 382 of file periode.class.php.

    {
        if ($p==0)
            $p=$this->p_id;
        list($p_start, $p_end)=$this->get_date_limit($p);
        return $p_start;
    }

References $p, $p_end, $p_id, $p_start, and get_date_limit().

Here is the call graph for this function:

form_exercice_add()

static Periode::form_exercice_add ( )

static

display a form (method POST) to input a new exercice variable in the FORM

• p_exercice
• p_year
• nb_month
• from_month
• day_opening
• day_closing
• p_exercice_label

Definition at line 670 of file periode.class.php.

    {
        $cn=Dossier::connect();
        $exercice=new INum('p_exercice');
        $exercice->prec=0;
        $exercice->value=$cn->get_value('select max(p_exercice::float)+1 from parm_periode');
        $year=new INum('p_year');
        $year->prec=0;
        $year->value=$exercice->value;
        $nb_month=new INum('nb_month');
        $nb_month->prec=0;
        $nb_month->value=12;
        $from=new ISelect('from_month');
        $amonth=array();
        $month=[_('Janvier'), _('Février'), _('Mars'), _('Avril'),
            _('Mai'), _('Juin'), _('Juillet'), _('Août'), _('Septembre'),
            _('Octobre'), _('Novembre'), _('Décembre')];
        for ($i=1; $i<13; $i++)
        {
            $strMonth=$month[($i-1)];
            $amonth[]=array("value"=>$i, "label"=>$strMonth);
        }
        $from->value=$amonth;
        $day_opening=new ICheckBox("day_opening");
        $day_closing=new ICheckBox("day_closing");
        $day_closing->value=1;
        $day_opening->value=1;
        $day_closing->set_check(1);
        $exercice_label=new IText("p_exercice_label");
        require_once NOALYSS_TEMPLATE.'/periode_add_exercice.php';
    }

References $cn, $exercice, $exercice_label, $from, $i, $year, and _.

form_exercice_label()

static Periode::form_exercice_label ( )

static

form to change the label of exercice

Definition at line 704 of file periode.class.php.

    {
        $cn=Dossier::connect();
        require_once NOALYSS_TEMPLATE."/periode-form_exercice_label.php";
    }

References $cn.

form_periode_add()

static Periode::form_periode_add ( $p_js_var )

static

Display a form for the input of a new periode.

Definition at line 728 of file periode.class.php.

    {
        $http=new \HttpInput();
        $cn=Dossier::connect();
        $p_exercice=new ISelect('p_exercice');
        $p_exercice->value=$cn->make_array("select distinct p_exercice,p_exercice_label from parm_periode order by 1 desc");
        $title=_('Ajout période');
        $title_par="<p>"._('On ne peut ajouter une période que sur un exercice qui existe déjà').
                "</p>";
 
        $p_start=new IDate('p_start');
        $p_end=new IDate('p_end');
 
        $html='';
        $html.=HtmlInput::title_box($title, 'periode_add','hide');
        $html.=$title_par;
        $html.='<form method="post" id="insert_periode_frm" onsubmit="'.$p_js_var.'.insert_periode();return false;">' ;
        $html.=HtmlInput::hidden("ac", $http->request('ac'));
        $html.=Dossier::hidden();
        $html.='<table>';
 
        $html.=tr(td(_(' Début période : ')).td($p_start->input()));
        $html.=tr(td(_(' Fin période : ')).td($p_end->input()));
        $html.=tr(td(_(' Exercice : ')).td($p_exercice->input()));
        $html.='</table>';
        $html.=HtmlInput::submit('add_per', _('sauver'));
        $html.=HtmlInput::button('close', _('fermer'),
                        'onclick="$(\'periode_add\').hide()"');
        $html.='</form>';
        echo $html;
    }

References $cn, $html, $http, $p_end, $p_exercice, $p_start, $title, _, td(), and tr().

Here is the call graph for this function:

get_date_limit()

Periode::get_date_limit

(

$p_periode = 0

)

Give the start & end date of a periode.

Parameters

$p_periode

is the periode id, if omitted the value is the current object

Returns

array containing the start date & the end date, index are p_start and p_end or NULL if nothing is found

$ret['p_start']=>'01.01.2009'
$ret['p_end']=>'31.01.2009'

Definition at line 363 of file periode.class.php.

    {
        if ($p_periode==0)
            $p_periode=$this->p_id;
        $sql="select to_char(p_start,'DD.MM.YYYY') as p_start,
             to_char(p_end,'DD.MM.YYYY')   as p_end
             from parm_periode
             where p_id=$1";
        $Res=$this->cn->exec_sql($sql, array($p_periode));
        if (Database::num_row($Res)==0)
            return null;
        return Database::fetch_array($Res, 0,PGSQL_BOTH);
    }

References $p_id, $Res, $sql, cn, DatabaseCore\fetch_array(), and DatabaseCore\num_row().

Referenced by first_day(), and last_day().

Here is the call graph for this function:

get_exercice()

Periode::get_exercice

(

$p_id = 0

)

Definition at line 403 of file periode.class.php.

    {
        if ($p_id==0)
            $p_id=$this->p_id;
        $sql="select p_exercice from parm_periode where p_id=$1";
        $Res=$this->cn->exec_sql($sql,[$p_id]);
        if (Database::num_row($Res)==0)
            return null;
        return Database::fetch_result($Res, 0, 0);
    }

References $p_id, $p_id, $Res, $sql, cn, DatabaseCore\fetch_result(), and DatabaseCore\num_row().

Here is the call graph for this function:

get_first_date()

Periode::get_first_date

(

)

retrieve the first day of the first exercice

Returns

: string date format "DD.MM.YYYYY"

Definition at line 776 of file periode.class.php.

                               :string
    {
        return $this->cn->get_value("select to_char(p_start,'DD.MM.YYYY') from parm_periode order by p_start limit 1");
    }

References cn.

get_first_periode()

Periode::get_first_periode

(

)

retrieve the first periode of the folder or -1 if none

Returns

int

Definition at line 786 of file periode.class.php.

                                :int
    {
        return $this->cn->get_value("select p_id from parm_periode order by p_start asc limit 1");
    }

References cn.

get_limit()

Periode::get_limit

(

$p_exercice

)

return the max (to periode) and the min periode (from periode) of the exercice given in parameter

Parameters

$p_exercice

is the exercice (parm_periode.p_exercice)

Returns

an array of Periode object

Definition at line 334 of file periode.class.php.

    {
 
        $from_periode_id=$this->cn->get_value("select p_id from parm_periode where p_exercice=$1 order by p_start asc limit 1",
                array($p_exercice));
        $to_periode_id=$this->cn->get_value("select p_id from parm_periode where p_exercice=$1 order by p_start desc limit 1",
                array($p_exercice));
        $periodeFrom=new Periode($this->cn);
        $periodeFrom->p_id=$from_periode_id;
        if ($periodeFrom->load() == -1)
            throw new Exception('Periode n\'existe pas');
        $periodeTo=new Periode($this->cn);
        $periodeTo->p_id=$to_periode_id;
        if ($periodeTo->load() == -1)
            throw new Exception('Periode n\'existe pas');
        return array($periodeFrom, $periodeTo);
    }

References $p_exercice, and cn.

insert()

Periode::insert	(		$p_date_start,
			$p_date_end,
			$p_exercice,
			$p_exercice_label )

Add new periode.

Parameters

date	$p_date_start
date	$p_date_end
int	$p_exercice

Returns

int p_id of the new periode

Exceptions

Exception

10 Invalide date or exercice, 20 overlapping periode

Definition at line 250 of file periode.class.php.

    {
        try
        {
 
            if (isDate($p_date_start)==null      ||
                    isDate($p_date_end)==null    ||
                    noalyss_strlentrim($p_exercice)==0 ||
                    isNumber($p_exercice) ==0    ||
                    $p_exercice<COMPTA_MIN_YEAR  ||
                    $p_exercice>COMPTA_MAX_YEAR)
            {
                throw new Exception(_("Paramètre invalide"),10);
            }
            $overlap_start=$this->cn->get_value("select count(*) from parm_periode 
                where
                    p_start <= to_date($1,'DD-MM-YYYY')
                    and p_end >= to_date($1,'DD-MM-YYYY')
                        
                ",[$p_date_start]);
            $overlap_end=$this->cn->get_value("select count(*) from parm_periode 
                where
                    p_start <= to_date($1,'DD-MM-YYYY')
                    and p_end >= to_date($1,'DD-MM-YYYY')
                        
                ",[$p_date_end]);
            if ( $overlap_start > 0 || $overlap_end > 0)
            {
                throw new Exception (_("Période chevauchant une autre"),20);
            }
            $p_id=$this->cn->get_next_seq('s_periode');
            $sql=" insert into parm_periode(p_id,p_start,p_end,p_closed,p_exercice,p_exercice_label)
                    values 
                        ($1,
                        to_date($2,'DD.MM.YYYY'),
                        to_date($3,'DD.MM.YYYY'),
                        'f',
                        $4,$5)";
            
            $this->cn->start();
            $Res=$this->cn->exec_sql($sql,[$p_id, $p_date_start, $p_date_end, $p_exercice,$p_exercice_label]);
            $Res=$this->cn->exec_sql("insert into jrn_periode (jrn_def_id,p_id,status) ".
                    "select jrn_def_id,$p_id,'OP' from jrn_def");
            $this->cn->commit();
            return $p_id;
        }
        catch (Exception $e)
        {
            record_log($e->getMessage()." - ".$e->getCode());
              record_log($e);
            $this->cn->rollback();
            throw $e;
        }
    }

References $e, $p_exercice, $p_exercice_label, $p_id, $Res, $sql, _, cn, COMPTA_MAX_YEAR, COMPTA_MIN_YEAR, isDate(), isNumber(), noalyss_strlentrim(), and record_log().

Referenced by insert_exercice().

Here is the call graph for this function:

insert_exercice()

Periode::insert_exercice	(		$p_exercice,
			$p_year,
			$p_from_month,
			$p_month,
			$p_opening,
			$p_closing,
			$p_exercice_label )

add a exercice starting in year p_year with p_month month, with a starting and a closing

Parameters

$p_exercice	the exercice
$p_year	the starting year
$p_from_month	starting month
$p_month	number of month of the exercice
$p_opening	1 if we create a one-day periode for opening writings
$p_closing	1 if we create a one-day periode for closing writings
$p_exercice_label	label of the exercice

Definition at line 446 of file periode.class.php.

    {
        try
        {
            if (isNumber($p_exercice)==0)
                throw new Exception(_("Exercice n'est pas un nombre"));
 
            if ($p_exercice>COMPTA_MAX_YEAR||$p_exercice<COMPTA_MIN_YEAR)
                throw new Exception(sprintf(_("Exercice doit être entre %s et %s "), COMPTA_MIN_YEAR,
                        COMPTA_MAX_YEAR));
            if (isNumber($p_year)==0)
                throw new Exception(_("Année n'est pas un nombre"));
 
            if ($p_year>COMPTA_MAX_YEAR||$p_year<COMPTA_MIN_YEAR)
                throw new Exception(sprintf(_("Année doit être entre %s et %s "), COMPTA_MIN_YEAR,
                        COMPTA_MAX_YEAR));
 
            if (isNumber($p_month)==0)
                throw new Exception(_("Nombre de mois n'est pas un nombre"));
            if ($p_month<1||$p_month>60)
                throw new Exception(_("Nombre de mois doit être compris entre 1 & 60 "));
            if (isNumber($p_month)==0)
                throw new Exception(_("Mois de début n'existe pas "));
            if ($p_from_month>13||$p_from_month<1)
                throw new Exception(_("Mois de début n'existe pas "));
            if ( empty($p_exercice_label)) {
                $p_exercice_label=$p_exercice;
            }
            $this->cn->start();
            $year=$p_year;
            $month=$p_from_month;
            for ($i=1; $i<=$p_month; $i++)
            {
 
                // create first a periode of day 
                if ($i==1&&$p_opening==1)
                {
                    $fdate_start=sprintf('01.%02d.%d', $month, $year);
                    $this->insert($fdate_start, $fdate_start, $p_exercice,$p_exercice_label);
 
                    $date_start=sprintf('02.%02d.%d', $month, $year);
                    $date_end=$this->cn->get_value("select to_char(to_date($1,'DD.MM.YYYY')+interval '1 month'-interval '1 day','DD.MM.YYYY')",
                            array($fdate_start));
 
                    $this->insert($date_start, $date_end, $p_exercice,$p_exercice_label);
                }
                // The last month, we create a one-day periode for closing
                elseif ($i==$p_month && $p_closing ==1 )
                {
                    $fdate_start=sprintf('01.%02d.%d', $month, $year);
                    $date_end=$this->cn->get_value("select to_char(to_date($1,'DD.MM.YYYY')+interval '1 month'-interval '2 day','DD.MM.YYYY')",
                            array($fdate_start));
                    $this->insert($fdate_start, $date_end, $p_exercice,$p_exercice_label);
 
                    $date_end=$this->cn->get_value("select to_char(to_date($1,'DD.MM.YYYY')+interval '1 month'-interval '1 day','DD.MM.YYYY')",
                            array($fdate_start));
 
                    $this->insert($date_end, $date_end, $p_exercice,$p_exercice_label);
                    
                }
                else
                {
                    $date_start=sprintf('01.%02d.%d', $month, $year);
                    $date_end=$this->cn->get_value("select to_char(to_date($1,'DD.MM.YYYY')+interval '1 month'-interval '1 day','DD.MM.YYYY')",
                            array($date_start));
                    $this->insert($date_start, $date_end, $p_exercice,$p_exercice_label);
                }
                $month++;
                if ($month == 13 )
                {
                        $year++;
                        $month=1;
                }
            }
        
        $this->cn->commit();
        }
        catch (Exception $e)
        {
              record_log($e);
            $this->cn->rollback();
            throw $e;
        }
    }

References $date_end, $date_start, $e, $i, $p_exercice, $p_exercice_label, $year, _, cn, COMPTA_MAX_YEAR, COMPTA_MIN_YEAR, elseif, insert(), isNumber(), and record_log().

Here is the call graph for this function:

is_centralized()

Periode::is_centralized

(

)

Return 1 if periode is centralized.

Deprecated

Note

deprecated , centralization not used anymore

Definition at line 150 of file periode.class.php.

    {
        if ($this->jrn_def_id!=0)
            $sql="select status from jrn_periode ".
                    " where jrn_def_id=".$this->jrn_def_id.
                    " and p_id =".$this->p_id;
        else
            $sql="select p_centralized as status from parm_periode ".
                    " where ".
                    " p_id =".$this->p_id;
        $res=$this->cn->exec_sql($sql);
        $status=Database::fetch_result($res, 0, 0);
        if ($status=='CE'||$status=='t')
            return 1;
        return 0;
    }

References $res, $sql, $status, cn, DatabaseCore\fetch_result(), and jrn_def_id.

Here is the call graph for this function:

is_closed()

Periode::is_closed

(

)

check if a periode is closed. If jrn_def_id is set to a no zero value then check only for this ledger

See also

Periode::set_ledger

Returns

1 is the periode is closed otherwise return 0

Definition at line 100 of file periode.class.php.

    {
        if ($this->jrn_def_id!=0)
        {
 
            $sql="select status from jrn_periode ".
                    " where jrn_def_id=$2 ".
                    " and p_id = $1";
            $status=$this->cn->get_value($sql,[$this->p_id,$this->jrn_def_id]);
        }
        else
        {
            $sql="select p_closed as status from parm_periode ".
                    " where ".
                    " p_id = $1";
            $status=$this->cn->get_value($sql,[$this->p_id]);
 
        }
        if ($status=='CL'||$status=='t'||$status=='CE')
            return 1;
        return 0;
    }

References $sql, $status, cn, jrn_def_id, and p_id.

is_open()

Periode::is_open

(

)

Return 1 if the periode is open otherwise 0.

Note

For only a ledger you must set Periode::jrn_def_id to the ledger id

See also

Periode::set_ledger

Definition at line 126 of file periode.class.php.

    {
        /* if jrn_Def_id == 0 then we check the global otherwise we check
          a ledger */
        if ($this->jrn_def_id!=0){
            $sql="select status from jrn_periode ".
                    " where jrn_def_id=$1 ".
                    " and p_id = $2";
            $status=$this->cn->get_value($sql,[$this->jrn_def_id,$this->p_id]);
        }
        else {
            $sql="select p_closed as status from parm_periode ".
                    " where ".
                    " p_id = $1 ";
            $status=$this->cn->get_value($sql,[$this->p_id]);
        }
            
        if ($status=='OP'||$status=='f')            return 1;
        return 0;
    }

References $sql, $status, cn, jrn_def_id, and p_id.

last_day()

Periode::last_day

(

$p = 0

)

return the last day of periode the this->p_id must be set

Returns

a string with the date (DD.MM.YYYY)

Definition at line 395 of file periode.class.php.

    {
        if ($p==0)
            $p=$this->p_id;
        list($p_start, $p_end)=$this->get_date_limit($p);
        return $p_end;
    }

References $p, $p_end, $p_id, $p_start, and get_date_limit().

Here is the call graph for this function:

limit_year()

Periode::limit_year

(

$p_exercice

)

return the p_id of the start and the end of the exercice into an array

Parameters

$p_exercice

Returns

array [start]=>,[end]=>

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

    {
        $sql_start="select p_id from parm_periode where p_exercice=$1 order by p_start  ASC limit 1";
        $start=$this->cn->get_value($sql_start, array($p_exercice));
        $sql_end="select p_id from parm_periode where p_exercice=$1 order by p_end  DESC limit 1";
        $end=$this->cn->get_value($sql_end, array($p_exercice));
        return array("start"=>$start, "end"=>$end);
    }

References $end, $p_exercice, $start, and cn.

load()

Periode::load

(

)

load data from database

Returns

0 on success and -1 on error

Definition at line 309 of file periode.class.php.

                   :int
    {
        if ($this->p_id=='')
            $this->p_id=-1;
        $row=$this->cn->get_array("select p_start,p_end,p_exercice,p_closed,p_central,p_exercice_label from parm_periode where p_id=$1",
                array($this->p_id));
        if ($row==null)
            return -1;
 
        $this->p_start=$row[0]['p_start'];
        $this->p_end=$row[0]['p_end'];
        $this->p_exercice=$row[0]['p_exercice'];
        $this->p_exercice_label=$row[0]['p_exercice_label'];
        $this->p_closed=$row[0]['p_closed'];
        $this->p_central=$row[0]['p_central'];
        return 0;
    }

References $row, cn, and p_id.

reopen()

Periode::reopen

(

)

Definition at line 167 of file periode.class.php.

    {
        if ($this->jrn_def_id==0)
        {
            $this->cn->exec_sql("update parm_periode set p_closed='f',p_central='f' where p_id=$1",
                    array($this->p_id));
 
            $this->cn->exec_sql("update jrn_periode set status='OP' ".
                    " where p_id = $1", [$this->p_id]);
 
            return;
        }
        else
        {
            $this->cn->exec_sql("update jrn_periode set status='OP'
                                 where jrn_def_id=$1 and 
                                 p_id = $2 ", [$this->jrn_def_id, $this->p_id]);
            /* if one ledger is open then the periode is open */
            $this->cn->exec_sql("update parm_periode set p_closed=false where p_id=".$this->p_id);
            return;
        }
    }

References cn, jrn_def_id, and p_id.

set_ledger()

Periode::set_ledger

(

$p_jrn

)

Definition at line 68 of file periode.class.php.

    {
        $this->jrn_def_id=$p_jrn;
    }

References $p_jrn, and jrn_def_id.

set_periode()

Periode::set_periode

(

$pp_id

)

Definition at line 73 of file periode.class.php.

    {
        $this->p_id=$pp_id;
    }

References p_id.

verify_delete()

Periode::verify_delete

(

)

Verify before delete that the month is not used.

Exceptions

Exception

code 1 if periode used

Definition at line 716 of file periode.class.php.

                             {
        try {
            if ( $this->cn->get_value("select count(*) from jrn where jr_tech_per =$1 ",[$this->p_id]) > 0) {
                throw new Exception(_("Effacement impossible"), 1);
            }
        } catch (Exception $ex) {
            throw $ex;
        }
    }

References $ex, _, and cn.

Field Documentation

$cn

Periode::$cn

database connection

Definition at line 35 of file periode.class.php.

Referenced by display_periode_global(), filter_exercice(), form_exercice_add(), form_exercice_label(), and form_periode_add().

$jrn_def_id

Periode::$jrn_def_id

the jr, 0 means all the ledger

Definition at line 36 of file periode.class.php.

Referenced by __toString().

$p_central

Periode::$p_central

NOT USED

Definition at line 44 of file periode.class.php.

$p_closed

Periode::$p_closed

if exercice is closed

Definition at line 43 of file periode.class.php.

$p_end

Periode::$p_end

end of the periode

Definition at line 41 of file periode.class.php.

Referenced by __toString(), first_day(), form_periode_add(), and last_day().

$p_exercice

Periode::$p_exercice

exercice

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

Referenced by form_periode_add(), get_limit(), insert(), insert_exercice(), and limit_year().

$p_exercice_label

Periode::$p_exercice_label

Label of the exercice

Definition at line 45 of file periode.class.php.

Referenced by insert(), and insert_exercice().

$p_id

Periode::$p_id

pk of parm_periode

Definition at line 37 of file periode.class.php.

Referenced by __construct(), __toString(), get_exercice(), and insert().

$p_start

Periode::$p_start

start of the periode

Definition at line 40 of file periode.class.php.

Referenced by __toString(), first_day(), form_periode_add(), and last_day().

$status

Periode::$status

status is CL for closed, OP for open and CE for centralized

Definition at line 38 of file periode.class.php.

Referenced by __toString(), display_row_global(), is_centralized(), is_closed(), and is_open().

---

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

• include/class/periode.class.php