Anc_Listing Class Reference

manage the CA listing More...

Inheritance diagram for Anc_Listing:

Collaboration diagram for Anc_Listing:

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

Static Public Member Functions
static	test_me ()
	debugging and test function for dev. only

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

Detailed Description

manage the CA listing

Returns

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

Member Function Documentation

display_csv()

Anc_Listing::display_csv

(

)

Compute the csv export.

Returns

string with the csv

Definition at line 152 of file anc_listing.class.php.

    {
        $array=$this->load($this->from,$this->to,$this->from_poste,$this->to_poste);
        if ( empty($array) == true )
        {
            return $array;
 
        }
        $csv=new Noalyss_Csv("anc_listing");
        $csv->send_header();
        $csv->write_header(array("Date","Poste","QuickCode",
            "Activité","interne","pièce","description","montant","d/c"));
        foreach ( $array as $row)
        {
            // the name and po_id
            $csv->add($row['oa_date']);
            $csv->add($row['j_poste']);
            $csv->add($row['qcode']);
            $csv->add($row['po_name']);
            $csv->add($row['jr_internal']);
            $csv->add($row['jr_pj_number']);
            $csv->add($row['oa_description']);
            $csv->add($row['oa_amount'],"number");
            $csv->add(sprintf("'%s'",(($row['oa_debit']=='f')?'CREDIT':'DEBIT')));
            $csv->write();
        }
        return;
 
    }

References $array, $csv, $row, from, from_poste, load(), to, and to_poste.

Here is the call graph for this function:

display_form()

Anc_Listing::display_form

(

$p_hidden = ""

)

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 34 of file anc_listing.class.php.

    {
        echo '<form method="get">';
        $r=parent::display_form($p_string);
        $r.=HtmlInput::submit('result', _('Rechercher'));
        $r.= '</form>';
        return $r;
 
    }

References $r, and _.

display_html()

Anc_Listing::display_html

(

)

compute the html display

Returns

string

Definition at line 59 of file anc_listing.class.php.

    {
        $idx=0;
        $r="";
        //---Html
        $array=$this->load();
        if ( is_array($array) == false ||  empty($array) )
        {
            return 0;
        }
        $cred=0;$deb=0;
        bcscale(2);
        $r.='<div></div>';
        $r.=_('Cherche').HtmlInput::filter_table("tb_anchop",'0,1,2,3,4,5,6,7',1);
        $r.= '<table id="tb_anchop" class="sortable" >';
        $r.= '<tr>'.
             '<th class=" sorttable_sorted">'._('Date').'</th>'.
             '<th>'._('Poste').'</th>'.
             '<th>'._('Quick_code').'</th>'.
             '<th>'._('Analytique').'</th>'.
          th(_('Description')).
             '<th>'._('libelle').'</th>'.
             '<th>'._('Num.interne').'</th>'.
             '<th>'._('Montant').'</th>'.
             '<th>'._('D/C').'</th>'.
             '</tr>';
        foreach ( $array as $row )
        {
            $class=($idx%2==0)?'even':'odd';
            $idx++;
            $r.= '<tr class="'.$class.'">';
            $detail=($row['jr_id'] != null)?HtmlInput::detail_op($row['jr_id'],$row['jr_internal']):'';
            $post_detail=($row['j_poste'] != null)?HtmlInput::history_account($row['j_poste'],$row['j_poste']):'';
            $card_detail=($row['f_id'] != null)?HtmlInput::history_card($row['f_id'],$row['qcode']):'';
 
            $r.=
                '<td sorttable_customkey="'.$row['str_order_date'].'">'.$row['oa_date'].'</td>'.
              td($post_detail,'  sorttable_customkey="X'.$row['j_poste'].'"').
              td($card_detail).
              '<td>'.HtmlInput::history_anc_account($row['po_id'],h($row['po_name'])).'</td>'.
              '<td>'.h($row['oa_description']).'</td>'.
              td($row['jr_comment']).
              '<td>'.$detail.'</td>'.
              '<td class="num" sorttable_customkey="'.$row['oa_amount'].'">'.nbm($row['oa_amount']).'</td>'.
                '<td>'.(($row['oa_debit']=='f')?'C':'D').'</td>';
            $r.= '</tr>';
            if ( $row['oa_debit'] == 'f') {$cred=bcadd($cred,$row['oa_amount']);}
            if ( $row['oa_debit'] == 't') {$deb=bcadd($deb,$row['oa_amount']);}
        }
        
        $r.= '</table>';
        ob_start();
        echo _("Total");
        echo '<ol style="list-style:none">';
        echo '<li>'._('Total')." ".nbm($deb).' D '.'</li>';
        echo '<li>'._('Total')." ".nbm($cred).' C '.'</li>';
        echo '<li>';
        echo _('Solde');
        $solde=abs(bcsub($deb,$cred));
        echo $solde." ";
        echo findSide($deb-$cred);
        echo '<li>';
        echo '</ol>';
 
        $r_solde=ob_get_clean();
        
        return $r.$r_solde;
    }

References $array, $class, $cred, $deb, $detail, $idx, $r, $row, $solde, _, findSide(), h, load(), nbm(), td(), and th().

Here is the call graph for this function:

get_request()

Anc_Listing::get_request

(

)

complete the object with the data in $_REQUEST

Reimplemented from Anc_Print.

Definition at line 47 of file anc_listing.class.php.

    {
        parent::get_request();
        $this->pa_id=(isset($_REQUEST['pa_id']))?$_REQUEST['pa_id']:"";
    }

References $_REQUEST, and pa_id.

load()

Anc_Listing::load

(

)

load the data from the database

Returns

array

Definition at line 132 of file anc_listing.class.php.

    {
        $op=new Anc_Operation ($this->db);
        $op->pa_id=$this->pa_id;
        $array=$op->get_list($this->from,$this->to,$this->from_poste,$this->to_poste);
        if (! $array ) 
        {
            $this->has_data=0;
        }
        else 
        {
            $this->has_data=count($array);
        }
        return $array;
    }

References $array, $op, Anc_Print\$pa_id, db, from, from_poste, to, and to_poste.

Referenced by display_csv(), and display_html().

show_button()

Anc_Listing::show_button

(

$p_string = ''

)

show the export button to pdf and CSV

Parameters

$p_string	string containing some HTML tag as hidden field

param

Returns

string containing the html code

Definition at line 191 of file anc_listing.class.php.

    {
        $r="";
        $submit=HtmlInput::submit('','');
        $hidden=new IHidden();
        /* for the export in PDF
         * Not yet needed, the html print should be enough
        $r.= '<form method="GET" action="ca_list_pdf.php" style="display:inline">';
        $r.= $p_string;
        $r.= dossier::hidden();
        $r.= $hidden->input("to",$this->to);
        $r.= $hidden->input("from",$this->from);
        $r.= $hidden->input("pa_id",$this->pa_id);
        $r.= $hidden->input("from_poste",$this->from_poste);
        $r.= $hidden->input("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("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.=HtmlInput::hidden('act','CSV:AncList');
        $r.=HtmlInput::hidden('ac',$_REQUEST['ac']);
        $r.= $p_string;
        $r.= dossier::hidden();
        $r.=HtmlInput::submit('bt_csv',"Export en CSV");
        $r.= '</form>';
        return $r;
 
    }

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

test_me()

static Anc_Listing::test_me ( )

static

debugging and test function for dev. only

Parameters

param

Parameters

return

Definition at line 234 of file anc_listing.class.php.

    {
    }

---

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

• include/class/anc_listing.class.php