Anc_Balance_Simple Class Reference

manage the simple balance for CA, inherit from balance_ca More...

Inheritance diagram for Anc_Balance_Simple:

Collaboration diagram for Anc_Balance_Simple:

Public Member Functions
	display_csv ()
	Compute the csv export. More...
	display_form ($p_string="")
	Compute the form to display. More...
	display_html ()
	compute the html display More...
	display_pdf ()
	Display the result in pdf. More...
	load ()
	load the data from the database More...
	set_sql_filter ()
	Set the filter (account_date) More...
	show_button ($p_string="")
	Show the button to export in PDF or CSV. More...
Public Member Functions inherited from Anc_Print
	__construct ($p_cn)
	check ()
	display_form ($p_hidden="")
	Compute the form to display. More...
	get_request ()
	complete the object with the data in $_REQUEST More...
	set_sql_filter ()
	Set the filter (account_date) More...

Static Public Member Functions
static	test_me ()
	for testing and debuggind the class it must never be called from production system, it is intended only for developpers More...

Additional Inherited Members
Data Fields inherited from Anc_Print
	$db
	$from
	$from_poste
	$to
	$to_poste

Detailed Description

manage the simple balance for CA, inherit from balance_ca

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

Member Function Documentation

display_csv()

Anc_Balance_Simple::display_csv

(

)

Compute the csv export.

Returns

string with the csv

Definition at line 228 of file anc_balance_simple.class.php.

    {
        $array=$this->load();
        if ( is_array($array) == false )
        {
            return $array;
 
        }
        $csv=new Noalyss_Csv("ca_bal_simple");
        $csv->send_header();
        $r="";
        foreach ( $array as $row)
        {
            // the name and po_id
            $solde=($row['sum_cred']>$row['sum_deb'])?'C':'D';
            $solde=($row['sum_cred']==$row['sum_deb'])?'0':$solde;
            $csv->add($row['po_name']);
            $csv->add($row['ga_description']);
            $csv->add($row['sum_deb'],"number");
            $csv->add($row['sum_cred'],"number");
            $csv->add($row['solde'],"number");
            $csv->add($row['debit'],"text");
            
            $csv->write();
        }   
        return $r;
 
    }

References $array, $csv, $r, $row, $solde, and load().

Here is the call graph for this function:

display_form()

Anc_Balance_Simple::display_form

(

$p_string = ""

)

Compute the form to display.

Parameters

$p_hidden

hidden tag to be included (gDossier,...)

Returns

string containing the data

Reimplemented from Anc_Print.

Definition at line 185 of file anc_balance_simple.class.php.

    {
        $r=parent::display_form($p_string);
 
        $r.= HtmlInput::submit('Affiche', _('Rechercher'));
 
        return $r;
    }

References $r, and HtmlInput\submit().

Here is the call graph for this function:

display_html()

Anc_Balance_Simple::display_html

(

)

compute the html display

Returns

string

Definition at line 124 of file anc_balance_simple.class.php.

    {
        $r="<table class=\"result\">";
        $r.="<tr>";
        $r.="<th>Poste comptable Analytique</th>";
        $r.="<th>Groupe</th>";
        $r.="<th>D&eacute;bit</th>";
        $r.="<th>Cr&eacute;dit</th>";
        $r.="<th>Solde</th>";
        $r.="<th>D/C</th>";
        $r.="</tr>";
 
        $array=$this->load();
        $odd=0;
        if ( is_array($array) == false )
        {
            return $array;
 
        }
        bcscale(2);
        $deb_side=0;$cred_side=0;
        foreach ( $array as $row)
        {
            $odd++;
 
            $r.=($odd%2==0)?'<tr class="odd">':'<tr class="even">';
            // the name and po_id
            //    $r.=sprintf("<td>%s</td>",$row['po_id']);
            $r.=sprintf("<td align=\"left\">%s</td>",h($row['po_name']));
            $r.=sprintf("<td align=\"left\">%s</td>",h($row['ga_description']));
            $r.=td(nbm($row['sum_deb']),' class="num"');
            $r.=td(nbm($row['sum_cred']),' class="num"');
            $r.=td(nbm($row['solde']),' class="num"');
            $deb=($row['sum_deb'] > $row['sum_cred'])?"D":"C";
            $deb=($row['solde'] == 0 )?'':$deb;
            $r.=sprintf("<td>%s</td>",$deb);
            $r.="</tr>";
            $deb_side=bcadd($deb_side,$row['sum_deb']);
            $cred_side=bcadd($cred_side,$row['sum_cred']);
            
        }
        $r.='<tr class="highlight">';
        $r.=td(_("Total"));
        $r.=td(" ");
        $r.=td(nbm($deb_side),'class="num"');
        $r.=td(nbm($cred_side),'class="num"');
        $solde_side=abs(bcsub($deb_side,$cred_side));
        $r.=td(nbm($solde_side),'class="num"');
        if ( $deb_side == $cred_side ) $r.=td("=");
        else if ( $deb_side > $cred_side ) $r.=td("D");
        else $r.=td("C");
        $r.="</table>";
        return $r;
    }

References $array, $deb, $r, $row, h, load(), nbm(), and td().

Here is the call graph for this function:

display_pdf()

Anc_Balance_Simple::display_pdf

(

)

Display the result in pdf.

Returns

none

Definition at line 199 of file anc_balance_simple.class.php.

    {
        $array=$this->load();
        $pdf=new PDFBalance_Simple($this->db);
        $pdf->set_info($this->from_poste,$this->to_poste,$this->from,$this->to);
        $pdf->AliasNbPages();
        $pdf->AddPage();
        $pdf->setTitle("Balance analytique",true);
 
        $pdf->SetFont('DejaVu','',6);
        for ($i=0;$i<count($array);$i++)
        {
            $row=$array[$i];
            $pdf->write_cell(50,6,$row['po_name'],0,0,'L');
            $pdf->write_cell(50,6,$row['ga_description'],0,0,'L');
            $pdf->write_cell(20,6,sprintf('%s',nbm($row['sum_deb'])),0,0,'R');
            $pdf->write_cell(20,6,sprintf('%s',nbm($row['sum_cred'])),0,0,'R');
            $pdf->write_cell(20,6,sprintf('%s',nbm($row['solde'])),0,0,'R');
            $pdf->write_cell(20,6,$row['debit'],0,0,'R');
            $pdf->line_new();
        }
        $fDate=date('dmy-Hi');
        $pdf->output('simple-balance-'.$fDate.'.pdf','D');
 
    }

References $array, $fDate, $i, $pdf, $row, db, from, from_poste, load(), nbm(), to, and to_poste.

Here is the call graph for this function:

load()

Anc_Balance_Simple::load

(

)

load the data from the database

Returns

array or null

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

    {
        $filter=$this->set_sql_filter();
        // sum debit
 
        $sql="select m.po_id,sum(deb) as sum_deb,sum(cred) as sum_cred,";
        $sql.=" po_name||'  '||coalesce(po_description,'') as po_name";
        $sql.=",ga_description ";
        $sql.=" from ";
        $sql.=" (select po_id,case when oa_debit='t' then oa_amount else 0 end as deb,";
        $sql.="case when oa_debit='f' then oa_amount else 0 end as cred ";
        $sql.=" from operation_analytique join poste_analytique using(po_id)";
        $sql.=(empty($filter) == false)?" where ".$filter:"";
        $sql.=" ) as m join poste_analytique using (po_id)";
        $sql.=" left join groupe_analytique on ( poste_analytique.ga_id=groupe_analytique.ga_id)";
        $sql.=" where poste_analytique.pa_id=".$this->pa_id;
        $sql.=" group by po_id,po_name,po_description,ga_description";
        $sql.=" order by po_name";
 
        $res=$this->db->exec_sql($sql);
 
        if ( Database::num_row($res) == 0 ) {
            $this->has_data=0;
            return null;
        }
        $a=array();
        $count=0;
        $array=Database::fetch_all($res);
            foreach ($array as $row)
            {
                $a[$count]['po_id']=$row['po_id'];
                $a[$count]['sum_deb']=$row['sum_deb'];
                $a[$count]['sum_cred']=$row['sum_cred'];
                $a[$count]['po_name']=$row['po_name'];
                $a[$count]['ga_description']=$row['ga_description'];
                $a[$count]['solde']=abs($row['sum_deb']-$row['sum_cred']);
                $a[$count]['debit']=($row['sum_deb']>$row['sum_cred'])?"debit":"credit";
                $count++;
            }
            $this->has_data=$count;
        return $a;
 
 
    }

References $a, $array, $count, $filter, $res, $row, $sql, db, DatabaseCore\fetch_all(), DatabaseCore\num_row(), and set_sql_filter().

Referenced by display_csv(), display_html(), and display_pdf().

Here is the call graph for this function:

set_sql_filter()

Anc_Balance_Simple::set_sql_filter

(

)

Set the filter (account_date)

Returns

return the string to add to load

Reimplemented from Anc_Print.

Definition at line 91 of file anc_balance_simple.class.php.

    {
        $sql="";
        $and="";
        if ( $this->from != "" )
        {
            $sql.=" 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 load().

show_button()

Anc_Balance_Simple::show_button

(

$p_string = ""

)

Show the button to export in PDF or CSV.

Parameters

$url_csv	url of the csv
$url_pdf	url of the pdf
$p_string	hidden data to include in the form

Returns

string with the button

Definition at line 265 of file anc_balance_simple.class.php.

    {
        $r="";
        $r.= '<form method="GET" action="export.php" style="display:inline">';
        $r.= $p_string;
        $r.= dossier::hidden();
        $r.= HtmlInput::hidden("to",$this->to);
        $r.= HtmlInput::hidden("act","PDF:AncBalSimple");
 
        $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.=HtmlInput::submit('bt_pdf',"Export en PDF");
        $r.= '</form>';
 
        $r.= '<form method="GET" action="export.php"  style="display:inline">';
        $r.= HtmlInput::hidden("act","CSV:AncBalSimple");
        $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_string;
        $r.= dossier::hidden();
        $r.=HtmlInput::submit('bt_csv',"Export en CSV");
        $r.= '</form>';
        return $r;
    }

References $r, from, from_poste, HtmlInput\hidden(), pa_id, HtmlInput\submit(), to, and to_poste.

Here is the call graph for this function:

test_me()

static Anc_Balance_Simple::test_me ( )

static

for testing and debuggind the class it must never be called from production system, it is intended only for developpers

Parameters

param

Parameters

return none

Definition at line 306 of file anc_balance_simple.class.php.

    {
        // call the page with ?gDossier=14
        $a=Dossier::connect();
 
        $bal=new Anc_Balance_Simple($a);
        $bal->get_request();
 
        echo '<form method="GET">';
 
        echo $bal->display_form();
        echo '</form>';
        if ( isset($_GET['result']))
        {
            echo $bal->show_button("","");
            echo "<h1>HTML</h1>";
            echo $bal->display_html();
            echo "<h1>CSV</h1>";
            echo $bal->display_csv();
            /*  echo "<h1>pdf</h1>"; */
            /*  echo $bal->display_pdf(); */
 
        }
 
    }

References $_GET, $a, $bal, and Dossier\connect().

Here is the call graph for this function:

---

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

• include/class/anc_balance_simple.class.php