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. More...

	count_operation ()
	count the number of operation of a Periode More...

	delete ()

	find_periode ($p_date)
	retrieve the periode thanks the date_end More...

	first_day ($p=0)
	return the first day of periode the this->p_id must be set More...

	get_date_limit ($p_periode=0)
	Give the start & end date of a periode. More...

	get_exercice ($p_id=0)

	get_first_date ()
	retrieve the first day of the first exercice More...

	get_first_periode ()
	retrieve the first periode of the folder or -1 if none More...

	get_limit ($p_exercice)
	return the max and the min periode of the exercice given in parameter More...

	insert ($p_date_start, $p_date_end, $p_exercice, $p_exercice_label)
	Add new periode. More...

	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 More...

	is_centralized ()
	Return 1 if periode is centralized. More...

	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 More...

	is_open ()
	Return 1 if the periode is open otherwise 0. More...

	last_day ($p=0)
	return the last day of periode the this->p_id must be set More...

	limit_year ($p_exercice)
	return the p_id of the start and the end of the exercice into an array More...

	load ()
	load data from database More...

	reopen ()

	set_ledger ($p_jrn)

	set_periode ($pp_id)

	verify_delete ()
	Verify before delete that the month is not used. More...

Static Public Member Functions
static	display_periode_global ($p_js)
	Display a table with all the periode. More...

static	display_row_global (Parm_Periode_SQL $obj, $p_nb, $p_js)
	Display each row for the global. More...

static	filter_exercice ($p_sel)

static	form_exercice_add ()
	display a form (method POST) to input a new exercice variable in the FORM More...

static	form_exercice_label ()
	form to change the label of exercice More...

static	form_periode_add ($p_js_var)
	Display a form for the input of a new periode. More...

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_id, $p_start, $r, and $status.

◆ centralized()

Periode::centralized ( )

Deprecated:: since version 5

Returns: type

Definition at line 221 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 187 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 566 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 702 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 530 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, Dossier\connect(), 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 583 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 755 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, and Dossier\connect().

Here is the call graph for this function:

◆ 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 413 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 375 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 663 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 Dossier\connect().

Here is the call graph for this function:

◆ form_exercice_label()

static Periode::form_exercice_label ( )

static

form to change the label of exercice

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

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

References $cn, and Dossier\connect().

Here is the call graph for this function:

◆ 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 721 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, HtmlInput\button(), Dossier\connect(), HtmlInput\hidden(), Dossier\hidden(), HtmlInput\submit(), td(), HtmlInput\title_box(), 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 356 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 396 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, $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 769 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 779 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 and the min periode of the exercice given in parameter

Parameters

$p_exercice is the exercice

Returns: an array of Periode object

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

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

References $max, $min, $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 244 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 439 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 144 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=".$this->jrn_def_id.
                    " and p_id =".$this->p_id;
        else
            $sql="select p_closed 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=='CL'||$status=='t'||$status=='CE')
            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_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 120 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 388 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 303 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 161 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 709 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(), first_day(), get_date_limit(), get_exercice(), insert(), and last_day().

◆ $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

Public Member Functions

Static Public Member Functions

Data Fields

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ __toString()

◆ centralized()

◆ close()

◆ count_operation()

◆ delete()

◆ display_periode_global()

◆ display_row_global()

◆ filter_exercice()

◆ find_periode()

◆ first_day()

◆ form_exercice_add()

◆ form_exercice_label()

◆ form_periode_add()

◆ get_date_limit()

◆ get_exercice()

◆ get_first_date()

◆ get_first_periode()

◆ get_limit()

◆ insert()

◆ insert_exercice()

◆ is_centralized()

◆ is_closed()

◆ is_open()

◆ last_day()

◆ limit_year()

◆ load()

◆ reopen()

◆ set_ledger()

◆ set_periode()

◆ verify_delete()

Field Documentation

◆ $cn

◆ $jrn_def_id

◆ $p_central

◆ $p_closed

◆ $p_end

◆ $p_exercice

◆ $p_exercice_label

◆ $p_id

◆ $p_start

◆ $status