Periode_Ledger_Table Class Reference

Display the periode per ledger: close : reopen ... the close , open must be done thanks Periode. More...

Collaboration diagram for Periode_Ledger_Table:

Public Member Functions
	__construct ($p_id)
	display_row ($pa_row, $p_num, $p_js)
	Display one row from jrn_periode with supplemental info. More...
	display_table ($p_resource_psql, $p_js)
	Display all the periode for a specific ledger the ledger is in m_jrn_periode_sql. More...
	get_a_member ()
	get_resource_periode_ledger ($p_ledger_id)
	load ()
	Load a row and return it as an array. More...
	set_id ($p_id)

Private Attributes
	$a_member
	$cn
	$sql

Detailed Description

Display the periode per ledger: close : reopen ... the close , open must be done thanks Periode.

See also

Periode

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

Constructor & Destructor Documentation

__construct()

Periode_Ledger_Table::__construct

(

$p_id

)

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

    {
        $this->a_member["id"]=$p_id;
        $this->sql="select id,p_id,status,p_id,p_start,p_end,p_closed,p_exercice,jrn_def_id
                from 
                 jrn_periode 
                 join parm_periode using (p_id)";
        $this->cn=Dossier::connect();
        $this->a_member=$this->cn->get_row($this->sql." where id = $1",
                [$this->a_member["id"]]);
        
    }

References $p_id, cn, and Dossier\connect().

Here is the call graph for this function:

Member Function Documentation

display_row()

Periode_Ledger_Table::display_row	(		$pa_row,
			$p_num,
			$p_js
	)

Display one row from jrn_periode with supplemental info.

Parameters

type	$pa_row	is an array corresponding to a_member
type	$p_num	number of rows , for color
type	$p_js	name of the js variable passed to ajax

Display a checkbox to select several month to close

Can close if open

Definition at line 121 of file periode_ledger_table.class.php.

    {
        $class=($p_num%2==0)?"even":"odd";
        printf('<tr id="row_per_%d" per_ledger="%s" per_exercice="%s" jrn_ledger_id="%s" class="%s"> ',
                $pa_row["id"], $pa_row["jrn_def_id"], $pa_row["p_exercice"],
                $pa_row["id"], $class
        );
        /**
         * Display a checkbox to select several month to close
         */
        if ($pa_row["status"] == "OP") {
            $checkbox=new ICheckBox("sel_per_close[]");
            $checkbox->set_attribute("per_id", $pa_row['id']);
            $checkbox->set_range("sel_per_close_ck");
            $checkbox->value=$pa_row['id'];
            echo "<td>".$checkbox->input()."</td>";
        }else {
            echo td("");
        }
        echo td(format_date($pa_row["p_start"], "YYYY-MM-DD", "DD.MM.YYYY"));
        echo td(format_date($pa_row["p_end"], "YYYY-MM-DD", "DD.MM.YYYY"));
        echo td($pa_row["p_exercice"]);
        $status=($pa_row['p_closed']=='t')?_("Fermée"):_("Ouvert");
        echo "<td>";
        if ($pa_row["status"] == "OP") { echo _("Ouvert"); }
        if ($pa_row["status"] == "CL") { echo _("Fermé"); }
        echo "</td>";
        /// Can close if open
        echo "<td>";
        if ($pa_row['status']=='OP')
        {
            $javascript=sprintf("%s.close_periode('%d')", $p_js, $pa_row['id']);
            echo Icon_Action::iconon(uniqid(), $javascript);
        }
        elseif ($pa_row['status']=='CL')
        {
            $javascript=sprintf("%s.open_periode('%d')", $p_js, $pa_row['id']);
            echo Icon_Action::iconoff(uniqid(), $javascript);
        }
        echo "</td>";
        echo "</tr>";
    }

References $checkbox, $class, $status, elseif, format_date(), Icon_Action\iconoff(), Icon_Action\iconon(), and td().

Referenced by display_table().

Here is the call graph for this function:

display_table()

Periode_Ledger_Table::display_table	(		$p_resource_psql,
			$p_js
	)

Display all the periode for a specific ledger the ledger is in m_jrn_periode_sql.

Parameters

type	$p_resource_psql	resource SQL
type	$p_js

Returns

type

See also

Periode_Ledger_Table::get_resource_periode_ledger

Definition at line 88 of file periode_ledger_table.class.php.

    {
        $nb_periode=Database::num_row($p_resource_psql);
 
        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("");
        echo "</tr>";
        echo "</thead>";
        echo '<tbody>';
 
        for ($i=0; $i<$nb_periode; $i++)
        {
            $obj=Database::fetch_array($p_resource_psql, $i);
            $this->display_row($obj, $i, $p_js);
        }
        echo '</tbody>';
        echo '</table>';
    }

References $i, $obj, display_row(), DatabaseCore\fetch_array(), DatabaseCore\num_row(), and th().

Here is the call graph for this function:

get_a_member()

Periode_Ledger_Table::get_a_member

(

)

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

    {
        return $this->a_member;
    }

References $a_member.

get_resource_periode_ledger()

Periode_Ledger_Table::get_resource_periode_ledger

(

$p_ledger_id

)

Definition at line 74 of file periode_ledger_table.class.php.

    {
        $ret=$this->cn->exec_sql($this->sql." where jrn_def_id = $1 order by p_start asc",[$p_ledger_id]);
        return  $ret;
    }

References $p_ledger_id, $ret, and cn.

load()

Periode_Ledger_Table::load

(

)

Load a row and return it as an array.

Returns

type

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

    {
        $this->a_member=$this->cn->get_row($this->sql." where id = $1",
                [$this->a_member["id"]]);
        return $this->a_member;
    }

References $a_member, and cn.

set_id()

Periode_Ledger_Table::set_id

(

$p_id

)

Definition at line 60 of file periode_ledger_table.class.php.

    {
        $a_member['id']=$p_id;
    }

References $a_member, and $p_id.

Field Documentation

$a_member

Periode_Ledger_Table::$a_member

private

Definition at line 39 of file periode_ledger_table.class.php.

Referenced by get_a_member(), load(), and set_id().

$cn

Periode_Ledger_Table::$cn

private

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

$sql

Periode_Ledger_Table::$sql

private

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

---

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

• include/class/periode_ledger_table.class.php