Anc_Group Class Reference

class for the group of the analytic account More...

Inheritance diagram for Anc_Group:

Collaboration diagram for Anc_Group:

Public Member Functions
	__construct ( $p_cn)
	display_html ()
	export_csv ()
	get_from_array ($p_array)
	fill the object thanks an array
	get_result ()
	insert ()
	insert into the database an object
	load ()
	load the todo_list row thanks it's ID
	myList ()
	remove ()
	remove from the database
	set_sql_filter ()
	Set the filter (account_date)
	show_button ($p_hidden="")
	display the button export CSV
Public Member Functions inherited from Anc_Print
	check ()
	display_form ($p_hidden="")
	Compute the form to display.
	get_request ()
	complete the object with the data in $_REQUEST

Static Public Member Functions
static	test_me ()

Data Fields
	$db
	$ga_description
	$ga_id
	$pa_id
	$pa_name
Data Fields inherited from Anc_Print
	$db
	$from
	$from_poste
	$has_data
	$pa_id
	$to
	$to_poste

Detailed Description

class for the group of the analytic account

Definition at line 31 of file anc_group.class.php.

Constructor & Destructor Documentation

__construct()

Anc_Group::__construct

(

$p_cn

)

Reimplemented from Anc_Print.

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

    {
        parent::__construct($p_cn);
        $this->db=$p_cn;
        $this->ga_id=null;
        $this->ga_description=null;
        $this->pa_id=null;
    }

References db, ga_id, and pa_id.

Member Function Documentation

display_html()

Anc_Group::display_html

(

)

Definition at line 189 of file anc_group.class.php.

    {
      if ( $this->check()  != 0)
        {
          alert('Désolé mais une des dates données n\'est pas valide');
          return;
        }
 
      $array=$this->get_result();
      if ( empty ($array) ) return "";
      require_once NOALYSS_TEMPLATE.'/anc_balance_group.php';
 
 
    }

References $array, alert(), Anc_Print\check(), and get_result().

Here is the call graph for this function:

export_csv()

Anc_Group::export_csv

(

)

Definition at line 224 of file anc_group.class.php.

  {
    $array=$this->get_result();
    $cvs=new Noalyss_Csv ('anc-balance-group-export');
    $cvs->send_header();
    $cvs->write_header(array("groupe","activité","description","débit","credit","solde"));
    bcscale(2);
    for ($i=0;$i<count($array);$i++)
      {
        $cvs->add($array[$i]['ga_id']);
        $cvs->add($array[$i]['po_name']);
        $cvs->add($array[$i]['po_description']);
        $cvs->add($array[$i]['sum_deb'],"number");
        $cvs->add($array[$i]['sum_cred'],"number");
        $cvs->add(bcsub($array[$i]['sum_cred'],$array[$i]['sum_deb']),"number");
        $cvs->write();
      }
  }

References $array, $i, and get_result().

Here is the call graph for this function:

get_from_array()

Anc_Group::get_from_array

(

$p_array

)

fill the object thanks an array

Parameters

array

Definition at line 107 of file anc_group.class.php.

    {
        $this->ga_id=$p_array['ga_id'];
        $this->pa_id=$p_array['pa_id'];
        $this->ga_description=$p_array['ga_description'];
    }

References $p_array, ga_id, and pa_id.

get_result()

Anc_Group::get_result

(

)

Definition at line 162 of file anc_group.class.php.

    {
      $filter_date=$this->set_sql_filter();
 
      $sql="with m as (select po_id,
        po_name,
        po_description,
        ga_id,
        case when  oa_debit = 't' then oa_amount
        else 0
        end  as amount_deb,
        case when oa_debit = 'f' then oa_amount
        else 0
        end as amount_cred,
        oa_date
        from operation_analytique
join poste_analytique using (po_id)
where pa_id=$1 $filter_date )
select sum(amount_cred) as sum_cred, sum(amount_deb)as sum_deb,po_name,ga_id,ga_description,po_description
from m left join groupe_analytique using (ga_id)
group by ga_id,po_name,ga_description,po_description
order by ga_description,po_name";
      $ret=$this->db->get_array($sql,array($this->pa_id));
 
      return $ret;
    }

References $ret, $sql, db, pa_id, and set_sql_filter().

Referenced by display_html(), and export_csv().

Here is the call graph for this function:

insert()

Anc_Group::insert

(

)

insert into the database an object

Returns

message with error otherwise an empty string

Definition at line 52 of file anc_group.class.php.

    {
        if (strlen ($this->ga_id) > 10 )            return '<span class="notice">'.
                _('Taille de la code trop long maximum 10 caractères').'</span>';
        $sql=" insert into groupe_analytique (ga_id,ga_description,pa_id) values ($1,$2,$3)";
        try
        {
            $this->db->exec_sql($sql,[$this->ga_id,
                                    $this->ga_description,
                                    $this->pa_id]);
            return true;
        }
        catch (Exception $a)
        {
            return '<span class="notice">Doublon !!</span>';
            return false;
        }
    }

References $a, $sql, _, db, ga_id, and pa_id.

load()

Anc_Group::load

(

)

load the todo_list row thanks it's ID

Returns

boolean true if found else false

Definition at line 87 of file anc_group.class.php.

                   :bool
    {
        $sql="select ga_id, ga_description,pa_id from groupe_analytique where".
             " ga_id = $1";
        $res=$this->db->exec_sql($sql,[$this->ga_id]);
        $array=Database::fetch_array($res);
        if ( ! empty($array) )
        {
            $this->ga_id=$array['ga_id'];
            $this->ga_description=$array['ga_description'];
            $this->pa_id=$array['pa_id'];
            return true;
        }
        return false;
    }

References $array, $res, $sql, db, DatabaseCore\fetch_array(), ga_id, and pa_id.

Here is the call graph for this function:

myList()

Anc_Group::myList

(

)

Definition at line 113 of file anc_group.class.php.

    {
        $sql=" select ga_id,groupe_analytique.pa_id,pa_name,ga_description ".
             " from groupe_analytique ".
             " join plan_analytique using (pa_id)";
        $r=$this->db->exec_sql($sql);
        $array=Database::fetch_all($r);
        $res=array();
        if ( ! empty($array))
        {
            foreach ($array as $m )
            {
                $obj= new Anc_Group($this->db);
                $obj->get_from_array($m);
                $obj->pa_name=$m['pa_name'];
                $res[]=clone $obj;
            }
        }
        return $res;
    }

References $array, $m, $obj, $r, $res, $sql, db, and DatabaseCore\fetch_all().

Here is the call graph for this function:

remove()

Anc_Group::remove

(

)

remove from the database

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

    {
        $this->ga_id=noalyss_str_replace(' ','',$this->ga_id);
        $this->ga_id=strtoupper($this->ga_id);
        $sql=" delete from groupe_analytique where ga_id=$1";
 
        $this->db->exec_sql($sql,array($this->ga_id));
    }

References $sql, db, ga_id, and noalyss_str_replace().

Here is the call graph for this function:

set_sql_filter()

Anc_Group::set_sql_filter

(

)

Set the filter (account_date)

Returns

return the string to add to load

Reimplemented from Anc_Print.

Definition at line 134 of file anc_group.class.php.

    {
        $sql="";
        $and="and ";
        if ( $this->from != "" )
        {
            $sql.=" $and  oa_date >= to_date('".$this->from."','DD.MM.YYYY')";
            $and=" and ";
        }
        if ( $this->to != "" )
        {
            $sql.=" $and oa_date <= to_date('".$this->to."','DD.MM.YYYY')";
            $and=" and ";
        }
        if ( $this->from_poste != "" )
        {
            $sql.=" $and upper(po_name)>= upper('".$this->from_poste."')";
            $and=" and ";
        }
        if ( $this->to_poste != "" )
        {
            $sql.=" $and upper(po_name)<= upper('".$this->to_poste."')";
            $and=" and ";
        }
        return $sql;
 
    }

References $sql, from, from_poste, to, and to_poste.

Referenced by get_result().

show_button()

Anc_Group::show_button

(

$p_hidden = ""

)

display the button export CSV

Parameters

$p_hidden

is a string containing hidden items

Returns

html string

Definition at line 208 of file anc_group.class.php.

  {
    $r="";
    $r.= '<form method="GET" action="export.php"  style="display:inline">';
    $r.= HtmlInput::hidden("act","CSV:AncBalGroup");
    $r.= HtmlInput::hidden("to",$this->to);
    $r.= HtmlInput::hidden("from",$this->from);
    $r.= HtmlInput::hidden("pa_id",$this->pa_id);
    $r.= HtmlInput::hidden("from_poste",$this->from_poste);
    $r.= HtmlInput::hidden("to_poste",$this->to_poste);
    $r.= $p_hidden;
    $r.= dossier::hidden();
    $r.=HtmlInput::submit('bt_csv',"Export en CSV");
    $r.= '</form>';
    return $r;
  }

References $r, from, from_poste, pa_id, to, and to_poste.

test_me()

static Anc_Group::test_me ( )

static

Definition at line 242 of file anc_group.class.php.

    {
 
        $cn=Dossier::connect();
        print_r($cn);
        $o=new Anc_Group($cn);
        $r=$o->myList();
        print_r($r);
        echo '<hr>';
        print_r($o);
        $o->ga_id="DD' dd dDD";
        $o->ga_description="Test 1";
        $o->remove();
        //    $o->insert();
        $o->ga_id="DD";
        $o->ga_description="Test 1";
        $o->remove();
 
        $r=$o->myList();
        print_r($r);
    }

References $cn, and $r.

Field Documentation

$db

Anc_Group::$db

$db (Database) Database connexion

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

$ga_description

Anc_Group::$ga_description

$ga_description (string) name of the group

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

$ga_id

Anc_Group::$ga_id

$ga_id (int) PK GROUPE_ANALYTIQUE.GA_ID

Definition at line 34 of file anc_group.class.php.

$pa_id

Anc_Group::$pa_id

$pa_id (int) id PLAN_ANALYTIC.PA_ID

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

$pa_name

Anc_Group::$pa_name

$pa_name (string) name of the Analytic Axis

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

---

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

• include/class/anc_group.class.php