Fiche Class Reference

define Class fiche and fiche def, those class are using class attribut. When adding or modifing new card in a IPOPUP the ipopup for the accounting item is ipop_account More...

Inheritance diagram for Fiche:

Collaboration diagram for Fiche:

Public Member Functions
	__construct ($p_cn, $p_id=0)
	!< this variable is a mistake, it shouldn't exist, need code rewrite
	__toString ()
	belong_ledger ($jrn_def_id, $side="")
	Check if a card can be used and then belong tp a specific ledger, it the card.
	blank ($p_fiche_def)
	insert a new record show a blank card to be filled
	build_sql ($array)
	create the sql statement for retrieving all the card
	button_csv ($p_from, $p_to)
	Return a string with the HTML code to display a button to export the history in CSV.
	button_pdf ($p_from, $p_to)
	Return a string with the HTML code to display a button to export the history in PDF.
	count_by_modele ($p_frd_id, $p_search="", $p_sql="")
	Count the nb of card with the reference card id frd_id.
	delete ()
	Display ($p_readonly, $p_in="")
	Display object instance, getAttribute sort the attribute and add missing ones.
	display_row ()
	display card as a table row , the tag TR must be added
	empty_attribute ($p_attr)
	check if an attribute is empty
	filter_history ($p_table_id)
	Filter in javascript the table with the history.
	Get ()
	Synonum of fiche::load_attribute.
	get_all_account ()
	get_amount_side ($p_amount)
	return the letter C if amount is > 0, D if < 0 or =
	get_attribute ($p_ad_id, $p_return=1)
	return the string of the given attribute (attr_def.ad_id)
	get_bank_ledger ()
	Returns the Acc_Ledger_Fin ledger for which the card is the default bank account or null if no ledger is found.
	get_bk_account ()
	get the available bank_account filtered by the security
	get_bk_balance ($p_cond="")
	get the bank balance with receipt or not in Euro
	get_bk_balance_currency ($p_cond="")
	Get the sum in Currency.
	get_by_category ($p_offset=-1, $p_search="", $p_order='')
	get all the card thanks the fiche_def_ref
	get_by_qcode ($p_qcode=null, $p_all=true)
	Retrieve a card thx his quick_code complete the object,, set the id member of the object or set it to 0 if no card is found.
	get_categorie ()
	get the fd_id of the card : fd_id, it set the attribute fd_id
	get_f_enable ()
	get_fiche_def_ref ()
	get_fiche_def_ref_id ()
	retrieve the frd_id of the fiche it is the type of the card (bank, purchase...) (fiche_def_ref primary key)
	get_gestion_title ()
	get_id ()
	get_quick_code ()
	return the quick_code of a card
	get_row ($p_from, $p_to)
	Get data for poste.
	get_row_date ($p_from, $p_to, $op_let=0)
	Get data for poste.
	get_solde_detail ($p_cond="")
	give the balance of an card
	getAttribut ()
	replace by load_attribute
	GetByDef ($p_frd_id, $p_offset=-1, $p_search="", $p_order='')
	Return array of card from the frd family deprecated , use insert get_by_category_id.
	getDisplayMode ()
	getLabelCategory ()
	getName ()
	return the name of a card
	HtmlTable ($p_array=null, $op_let=0, $from_div=1)
	HtmlTable, display a HTML of a card for the asked period.
	HtmlTableDetail ($p_array=null, $op_let=0)
	HtmlTable, display a HTML of a card for the asked period.
	HtmlTableHeader ($p_array=null)
	Display HTML Table Header (button)
	insert ($p_fiche_def, $p_array=null, $transaction=true)
	insert a new record thanks an array , either as parameter or $_POST
	is_used ()
	check if a card is used
	load ()
	Synonum of fiche::load_attribute.
	load_attribute ()
	get all the attribute of a card, add missing ones and sort the array ($this->attribut) by ad_id
	move_to ($p_fdid)
	move a card to another cat.
	remove ($silent=false)
	remove a card, check if not used first, must be synchro with is_used
	save ($p_fiche_def=0)
	Save a card, call insert or update.
	seek ($p_attribut, $p_value)
	find the card with the p_attribut equal to p_value, it is not case sensitive
	set_attribute ($p_ad_id, $p_value)
	set an attribute by a value, if the attribut array is empty a call to load_attribute is performed
	set_f_enable ($f_enable)
	set_fiche_def ($p_fiche_def)
	set_fiche_def_ref ($fiche_def_ref)
	set_id ($id)
	setAttribut ($p_ad_id, $p_value)
	replace by set_attribute
	setDisplayMode ($p_mode)
	how the card is display : either in a window or a greated container
	ShowTable ()
	strAttribut ($p_ad_id, $p_return=1)
	use get_attribute instead
	Summary ($p_search="", $p_action="", $p_sql="", $p_amount=false)
	show the default screen
	to_array ()
	turn a card into an array , then it can be saved thanks update or insert
	update ($p_array=null)
	update a card with an array

Static Public Member Functions
static	cmp_name (Fiche $o1, Fiche $o2)
	used with a usort function, to sort an array of Fiche on the name
static	from_qcode (Database $cn, string $p_qcode)
	create a card from a qcode and returns a card
static	get_fiche_def ($p_cn, $card_category_id, $p_order='', $inactive=1)
	get all the card from a categorie
static	test_me ()

Data Fields
	$attribut
	$cn
	$fiche_def
	$fiche_def_ref
	$id
	$ledger_description
	!< this variable is a mistake, it shouldn't exist, need code rewrite
	$ledger_name
	$quick_code
	$row
	$tot_cred
	$tot_deb

Private Member Functions
	get_row_result_deprecated ($res)
	fetch and return and array

Private Attributes
	$display_mode
	$f_enable

Detailed Description

define Class fiche and fiche def, those class are using class attribut. When adding or modifing new card in a IPOPUP the ipopup for the accounting item is ipop_account

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

Constructor & Destructor Documentation

__construct()

Fiche::__construct	(		$p_cn,
			$p_id = 0 )

!< this variable is a mistake, it shouldn't exist, need code rewrite

Reimplemented in Admin, Bank, contact, Customer, Manager, and Supplier.

Definition at line 53 of file fiche.class.php.

    {
        $this->cn=$p_cn;
        // in PHP7 , a null string == 0 
        // in PHP8 , a null string == a null string and is not equal to 0
        // to fix this, we set the fix here 
        if ( isNumber($p_id) == 1 ) {
            $this->id=$p_id;
        } else {
            $this->id=0;
        }
        $this->quick_code='';
        $this->attribut=array();
        $this->f_enable='1';
        if ($p_id != 0 ) { $this->load();} else {
            $this->fiche_def=0;
        }
        
       $this->display_mode="window";
    }

References $p_id, cn, isNumber(), and load().

Here is the call graph for this function:

Member Function Documentation

__toString()

Fiche::__toString

(

)

Definition at line 396 of file fiche.class.php.

                                : string
    {
        return print_r($this,true);
    }

belong_ledger()

Fiche::belong_ledger	(		$jrn_def_id,
			$side = "" )

Check if a card can be used and then belong tp a specific ledger, it the card.

return 1 if the fiche is in the range otherwise 0, the quick_code or the id must be set

Parameters

$jrn_def_id	journal_id (JRN.JRN_DEF_ID)
$side	: deb or cred , default empty = both

Returns

1 if the card belongs to the ledger, 0 the card doesn't belong, -1 the card doesn't exist, -2 the ledger has no card to check, -3 there is no category of card for this ledger

Definition at line 1545 of file fiche.class.php.

    {
        // check if we have a quick_code or a f_id
        if (($this->quick_code==null || $this->quick_code == "" )
                && $this->id == 0 )
        {
            throw  new Exception( 'erreur ni quick_code ni f_id ne sont donnes');
        }
 
        //retrieve the quick_code
        if ($this->quick_code == "") {
            $this->quick_code = $this->get_quick_code();
        }
 
 
        if ($this->quick_code == null) {
            return -1;
        }
 
        if ($this->id == 0 && $this->get_by_qcode(null, false) == 1) {
            return -1;
        }
 
        if ( $side == 'deb' )
        {
            $Res=$this->cn->exec_sql("select jrn_def_fiche_deb as fiche from jrn_def where jrn_def_id=$1",[$jrn_def_id]);
        }elseif ( $side == 'cred' )
        {
            $Res=$this->cn->exec_sql("select jrn_def_fiche_cred as fiche from jrn_def where jrn_def_id=$1",[$jrn_def_id]);
        }
        else
        {
            // Get all the fiche type (deb and cred)
            $Res=$this->cn->exec_sql(" select jrn_def_fiche_cred as fiche
                                     from jrn_def where jrn_def_id=$1
                                     union
                                     select jrn_def_fiche_deb
                                     from jrn_def where jrn_def_id=$1",
                                          [$jrn_def_id]
                                    );
        }
        if ( Database::num_row($Res)==0)
        {
            return -2;
        }
        /* convert the array to a string */
        $list=Database::fetch_all($Res);
        $str_list="";
        $comma='';
        foreach ($list as $row)
        {
            if ( $row['fiche'] != '' )
            {
                $str_list.=$comma.$row['fiche'];
                $comma=',';
            }
        }
        // Normally Max must be == 1
 
        if ( $str_list=="")
        {
            return -3;
        }
 
        $sql="select *
             from fiche
             where
             fd_id in (".$str_list.") and f_id= ".$this->id;
 
        $Res=$this->cn->exec_sql($sql);
        if (Database::num_row($Res) == 0) {
            return 0;
        }
        return 1;
        
    }

References $id, $list, $Res, $row, $side, $sql, cn, elseif, DatabaseCore\fetch_all(), get_by_qcode(), get_quick_code(), and DatabaseCore\num_row().

Here is the call graph for this function:

blank()

Fiche::blank

(

$p_fiche_def

)

insert a new record show a blank card to be filled

Parameters

$p_fiche_def

is the fiche_def.fd_id

Returns

HTML Code

Definition at line 377 of file fiche.class.php.

    {
        // array = array of attribute object sorted on ad_id
        $fiche_def=new Fiche_Def($this->cn,$p_fiche_def);
        $fiche_def->get();
        $array=$fiche_def->load_attribute();
        $r="";
        $r.='<table style="width:98%;margin:1%">';
        foreach ($array as $attr)
        {
            $table=0;
            $msg="";$bulle='';
            $r.=$attr->input($fiche_def);
           
        }
        $r.= '</table>';
        return $r;
    }

References $array, $attr, $fiche_def, $msg, $r, $table, and cn.

build_sql()

Fiche::build_sql

(

$array

)

create the sql statement for retrieving all the card

Returns

string with sql statement

Parameters

$array

contains the condition [jrn] => 2 [typecard] => cred / deb / filter or list [query] => string

Note

the typecard cred, deb or filter must be used with jrn, the value of list means a list of fd_id

See also

ajax_card.php cards.js

Reimplemented in contact.

Definition at line 1717 of file fiche.class.php.

    {
        if (!empty($array))
            extract($array, EXTR_SKIP);
        $and='';
        $filter_fd_id='true';
        $filter_query='';
        if (isset($typecard))
        {
            if (strpos($typecard, "sql")==false)
            {
                switch ($typecard)
                {
                    case 'cred':
                        if (!isset($jrn))
                            throw Exception('Erreur pas de valeur pour jrn');
                        $filter_jrn=$this->cn->make_list("select jrn_def_fiche_cred from jrn_Def where jrn_def_id=$1",
                                array($jrn));
                        $filter_fd_id=(empty($filter_jrn))?" fd_id in (-1)  ":" fd_id in (".$filter_jrn.")";
                        $and=" and ";
                        break;
                    case 'deb':
                        if (!isset($jrn))
                            throw Exception('Erreur pas de valeur pour jrn');
                        $filter_jrn=$this->cn->make_list("select jrn_def_fiche_deb from jrn_Def where jrn_def_id=$1",
                                array($jrn));
                        $filter_fd_id=(empty($filter_jrn))?"fd_id in (-1) ":" fd_id in (".$filter_jrn.")";
                        $and=" and ";
                        break;
                    case 'filter':
                        if (!isset($jrn))
                            throw Exception('Erreur pas de valeur pour jrn');
                        $filter_jrn=$this->cn->make_list("select jrn_def_fiche_deb from jrn_Def where jrn_def_id=$1",
                                array($jrn));
 
                        if (noalyss_trim($filter_jrn)!='')
                            $fp1=" fd_id in (".$filter_jrn.")";
                        else
                            $fp1="fd_id < 0";
 
                        $filter_jrn=$this->cn->make_list("select jrn_def_fiche_cred from jrn_Def where jrn_def_id=$1",
                                array($jrn));
 
                        if (noalyss_trim($filter_jrn)!='')
                            $fp2=" fd_id in (".$filter_jrn.")";
                        else
                            $fp2="fd_id < 0";
 
                        $filter_fd_id='('.$fp1.' or '.$fp2.')';
 
                        $and=" and ";
                        break;
                    case 'all':
                        $filter_fd_id=' true';
                        break;
                    default:
                        if (noalyss_trim($typecard)!='')
                            $filter_fd_id=' fd_id in ('.$typecard.')';
                        else
                            $filter_fd_id=' fd_id < 0';
                }
            }
            else
            {
                $filter_fd_id=noalyss_str_replace('[sql]', '', $typecard);
            }
        }
 
        $and=" and ";
        if (isset($query))
        {
            $query=sql_string($query);
 
            if (noalyss_strlentrim($query)>0)
            {
                $query=noalyss_str_replace(" ", "%", $query);
                $filter_query=$and."(vw_name ilike '%$query%' or quick_code ilike ('%$query%') "
                        ." or vw_description ilike '%$query%' or tva_num ilike '%$query%' or accounting like upper('$query%'))";
            }
            else
            {
                $filter_query='';
            }
        }
        $sql="select * from vw_fiche_attr where ".$filter_fd_id.$filter_query;
        return $sql;
    }

References $array, $jrn, $query, $sql, $typecard, cn, noalyss_str_replace(), noalyss_strlentrim(), noalyss_trim(), and sql_string().

Here is the call graph for this function:

button_csv()

Fiche::button_csv	(		$p_from,
			$p_to )

Return a string with the HTML code to display a button to export the history in CSV.

Parameters

type	$p_from	from date (DD.MM.YYYY)
type	$p_to	to date (DD.MM.YYYY)

Returns

HTML string

Definition at line 1896 of file fiche.class.php.

                                       {
        $href="export.php?".http_build_query(
                array(
                    "gDossier"=>Dossier::id(),
                    "f_id"=>$this->id,
                    "ople"=>0,
                    "type"=>"poste",
                    "from_periode"=>$p_from,
                    "to_periode"=>$p_to,
                    "act"=>"CSV:fichedetail"
                    )
                );
        return '<a class="smallbutton" style="display:inline-block" href="'.$href.'">'._("Export CSV").'</a>';
 
    }

References $href, and _.

button_pdf()

Fiche::button_pdf	(		$p_from,
			$p_to )

Return a string with the HTML code to display a button to export the history in PDF.

Parameters

type	$p_from	from date (DD.MM.YYYY)
type	$p_to	to date (DD.MM.YYYY)

Returns

HTML string

Definition at line 1918 of file fiche.class.php.

                                       {
        $href="export.php?".http_build_query(
                array(
                    "gDossier"=>Dossier::id(),
                    "f_id"=>$this->id,
                    "ople"=>0,
                    "type"=>"poste",
                    "from_periode"=>$p_from,
                    "to_periode"=>$p_to,
                    "act"=>"PDF:fichedetail"
                    )
                );
        return '<a class="smallbutton" style="display:inline-block" href="'.$href.'">'._("Export PDF").'</a>';
        
    }

References $href, and _.

cmp_name()

static Fiche::cmp_name ( Fiche $o1, Fiche $o2 )

static

used with a usort function, to sort an array of Fiche on the name

Definition at line 137 of file fiche.class.php.

    {
        return strcmp($o1->get_attribute(ATTR_DEF_NAME),$o2->get_attribute(ATTR_DEF_NAME));
    }

References ATTR_DEF_NAME, and get_attribute().

Here is the call graph for this function:

count_by_modele()

Fiche::count_by_modele	(		$p_frd_id,
			$p_search = "",
			$p_sql = "" )

Count the nb of card with the reference card id frd_id.

Parameters

$p_frd_id	the fiche_def_ref.frd_id
$p_search	p_search is a filter on the name
$p_sql	extra sql condition

Returns

nb of item found

Definition at line 266 of file fiche.class.php.

    {
        // Scan for SQL inject
        $this->cn->search_sql_inject($p_sql);
 
        if ( $p_search != "" )
        {
            $result = $this->cn->get_value("select count(*) from 
                        vw_fiche_attr 
                        where 
                        frd_id=$1 
                        and vw_name ilike '%'||$2||'%'",
                    [$p_frd_id,$p_search]);
            return $result;
        } else {
            $result = $this->cn->get_value("select count(*)
                                 from
                                 fiche join fiche_Def using (fd_id)
                                 where frd_id=$1 ".$p_sql
                ,[$p_frd_id]);
            return $result;
        }
 
 
    }

References $result, and cn.

Referenced by Summary().

delete()

Fiche::delete

(

)

Definition at line 1689 of file fiche.class.php.

    {
        $this->cn->start();
 
        // Remove from attr_value
        $Res=$this->cn->exec_sql("delete from fiche_detail
                                 where
                                   f_id= $1",[ $this->id] );
 
        // Remove from fiche
        $Res=$this->cn->exec_sql("delete from fiche where f_id=$1",[$this->id]);
        
        $this->cn->commit();
 
 
    }

References $Res, and cn.

Display()

Fiche::Display	(		$p_readonly,
			$p_in = "" )

Display object instance, getAttribute sort the attribute and add missing ones.

Parameters

	$p_readonly	true= if can not modify, otherwise false
string	$p_in	if called from an ajax it is the id of the html elt containing

Returns

string to display or FNT string for fiche non trouvé

Definition at line 422 of file fiche.class.php.

    {
        $this->load_attribute();
        $attr=$this->attribut;
        $ret="";
        $ret.='<span style="margin-right:5px;float:right;font-size:80%">'.
                _('id').':'.$this->id."</span>";
        $ret.="<table style=\"width:98%;margin:1%\">";
        if (empty($attr))
        {
            return 'FNT';
        }
        
        $fiche_def=new Fiche_Def($this->cn,$this->fiche_def);
        /* for each attribute */
        foreach ($attr as $r)
        {
            $msg="";
            $bulle="";
            $r->setDisplayMode($this->display_mode);
            if ($p_readonly)
            {
                $ret .= $r->print();
            }
            if ($p_readonly==false)
            {
                $ret .= $r->input($fiche_def);
               
            }
         }
        // Display if the card is enable or not
        $enable_is=new InputSwitch("f_enable");
        $enable_is->value=$this->f_enable;
        $enable_is->readOnly=$p_readonly;
                
        $ret.=tr( 
                td(_("Actif"),'class="input_text"').td($enable_is->input(),'class="input_text"')
                );
        
        
        $ret.="</table>";
 
        return $ret;
    }

References $attr, $attribut, $f_enable, $fiche_def, $msg, $p_readonly, $r, $ret, _, cn, load_attribute(), td(), and tr().

Here is the call graph for this function:

display_row()

Fiche::display_row

(

)

display card as a table row , the tag TR must be added

Returns

HTML string starting

Definition at line 1966 of file fiche.class.php.

    {
        $this->load_attribute();
        foreach($this->attribut as $attr) {
            $sort="";
 
            if ($attr->ad_type!='select') 
            {
 
                if ($attr->ad_type=="date") {
                // format YYYYMMDD
                $sort='sorttable_customkey="'.format_date($attr->av_text, "DD.MM.YYYY", "YYYYMMDD").'"';
                }
                elseif ($attr->ad_type=="poste"){
                $sort='sorttable_customkey="TEXT'.$attr->av_text.'"';
                }
                echo td($attr->av_text, 'style="padding: 0 10 1 10;white-space:nowrap;" '.$sort);
             }
             else {
                $value=$this->cn->make_array($attr->ad_extra);
                $row_content="";
                for ($e=0; $e<count($value); $e++) {
                    if ( $value[$e]['value']==$attr->av_text) {
                        $row_content=h($value[$e]['label']);
                        break;
                    }
                }
                echo td($row_content, 'style="padding: 0 10 1 10;white-space:nowrap;"');
 
            }
        }
 
    }

References $attr, $e, $sort, $value, cn, elseif, h, load_attribute(), and td().

Here is the call graph for this function:

empty_attribute()

Fiche::empty_attribute

(

$p_attr

)

check if an attribute is empty

Parameters

$p_attr

the id of the attribut to check (ad_id)

Returns

return true is the attribute is empty or missing

Definition at line 1342 of file fiche.class.php.

    {
        $sql="select ad_value
             from fiche_detail
             natural join fiche
             left join attr_def using (ad_id) where f_id=$1 ".
             " and ad_id = $2 ".
             " order by ad_id";
        $res=$this->cn->exec_sql($sql,[$this->id,$p_attr]);
        if ( Database::num_row($res) == 0 ) return true;
        $text=Database::fetch_result($res,0,0);
        return (strlen(noalyss_trim($text)) > 0)?false:true;
 
 
    }

References $res, $sql, $text, cn, DatabaseCore\fetch_result(), noalyss_trim(), and DatabaseCore\num_row().

Referenced by Acc_Ledger_Purchase\compute_no_deductible(), and Acc_Ledger_Purchase\insert_no_deductible().

Here is the call graph for this function:

filter_history()

Fiche::filter_history

(

$p_table_id

)

Filter in javascript the table with the history.

Parameters

type

$p_table_id

id of the table containting the data to filter

Returns

html string

Definition at line 1939 of file fiche.class.php.

                                         {
        return _('Cherche').' '.HtmlInput::filter_table($p_table_id, '0,1,2,3,4,5,6,7,8,9,10', 1);
    }

References _.

from_qcode()

static Fiche::from_qcode ( Database $cn, string $p_qcode )

static

create a card from a qcode and returns a card

Parameters

$cn	Database cnx
$p_qcode	(string) qcode of the card

Definition at line 2004 of file fiche.class.php.

    {
        $card=new Fiche($cn);
        $card->get_by_qcode($p_qcode);
        return $card;
    }

References $card, and $cn.

Referenced by Noalyss\XMLDocument\XMLInvoice\fill_operation_from_array().

Get()

Fiche::Get

(

)

Synonum of fiche::load_attribute.

Definition at line 678 of file fiche.class.php.

    {
        $this->load_attribute();
    }

References load_attribute().

Here is the call graph for this function:

get_all_account()

Fiche::get_all_account

(

)

Definition at line 1885 of file fiche.class.php.

        {
 
        }

get_amount_side()

Fiche::get_amount_side

(

$p_amount

)

return the letter C if amount is > 0, D if < 0 or =

Parameters

type

$p_amount

Returns

string

Definition at line 1825 of file fiche.class.php.

    {
            if ($p_amount == 0)
                    return "";
            if ($p_amount < 0)
                    return "C";
            if ($p_amount > 0)
                    return "D";
    }

get_attribute()

Fiche::get_attribute	(		$p_ad_id,
			$p_return = 1 )

return the string of the given attribute (attr_def.ad_id)

Parameters

int	$p_ad_id	AD_ID from attr_def.ad_id
int	$p_return	1 return NOTFOUND otherwise an empty string

See also

constant.php

Returns

string

Note

reread data from database and so it reset previous unsaved change

Definition at line 335 of file fiche.class.php.

    {
        $return=($p_return==1)?NOTFOUND:"";
        if ( empty ($this->attribut)  )
        {
 
          $this->load_attribute();
        }
 
        foreach ($this->attribut as $e)
        {
            if ( $e->ad_id == $p_ad_id )
                return noalyss_trim($e->av_text);
        }
        return $return;
    }

References $e, load_attribute(), noalyss_trim(), and NOTFOUND.

Referenced by cmp_name(), Acc_Ledger_Purchase\compute_no_deductible(), get_bk_balance(), get_gestion_title(), get_row(), get_row_date(), get_solde_detail(), HtmlTable(), HtmlTableDetail(), Acc_Ledger_Purchase\insert_no_deductible(), is_used(), strAttribut(), Card_Property\update(), and update().

Here is the call graph for this function:

get_bank_ledger()

Fiche::get_bank_ledger

(

)

Returns the Acc_Ledger_Fin ledger for which the card is the default bank account or null if no ledger is found.

Definition at line 1945 of file fiche.class.php.

    {
        try {
            $id=$this->cn->get_value("select jrn_def_id from jrn_def where jrn_def_bank = $1 ",[$this->id]);
            if ($id == "") { return NULL;}
            $ledger=new Acc_Ledger_Fin($this->cn,$id);
            $ledger->load();
            return $ledger;
        }        
        catch (Exception $e) {
            record_log(__FILE__.":".__LINE__);
            record_log($e->getMessage());
            throw $e;
        }
    }

References $e, $id, $ledger, cn, and record_log().

Here is the call graph for this function:

get_bk_account()

Fiche::get_bk_account

(

)

get the available bank_account filtered by the security

Returns

array of card

Definition at line 146 of file fiche.class.php.

    {
        global $g_user;
      $sql_ledger=$g_user->get_ledger_sql('FIN',3);
      $avail=$this->cn->get_array("select jrn_def_id,jrn_def_name,"
              . "jrn_def_bank,jrn_def_description,currency_id from jrn_def where jrn_def_type='FIN' and $sql_ledger
                            order by jrn_def_name");
 
      if ( count($avail) == 0 )
            return null;
 
      for ($i=0;$i<count($avail);$i++)
        {
            $t=new Fiche($this->cn,$avail[$i]['jrn_def_bank']);
            $t->ledger_name=$avail[$i]['jrn_def_name'];
            $t->ledger_description=$avail[$i]['jrn_def_description'];
            $t->load_attribute();
            $all[$i]=$t;
 
        }
        return $all;
    }

References $all, $avail, $g_user, $i, $t, and cn.

get_bk_balance()

Fiche::get_bk_balance

(

$p_cond = ""

)

get the bank balance with receipt or not in Euro

Definition at line 1311 of file fiche.class.php.

    {
        if ( $this->id == 0 ) throw  new Exception('fiche->id est nul');
        $qcode=$this->get_attribute(ATTR_DEF_QUICKCODE);
 
        if ( $p_cond != "") $p_cond=" and ".$p_cond;
        $sql="select sum(deb) as sum_deb, sum(cred) as sum_cred from
                                 ( select j_poste,
                                 case when j_debit='t' then j_montant else 0 end as deb,
                                 case when j_debit='f' then j_montant else 0 end as cred
                                 from jrnx
                                 join jrn on (jr_grpt_id=j_grpt)
                                 where
                                 j_qcode = ('$qcode'::text)
                                 $p_cond
                                 ) as m  ";
 
        $Res=$this->cn->exec_sql($sql);
        $Max=Database::num_row($Res);
        if ($Max==0) return 0;
        $r=Database::fetch_array($Res,0);
 
        return array('debit'=>$r['sum_deb'],
                     'credit'=>$r['sum_cred'],
                     'solde'=>abs($r['sum_deb']-$r['sum_cred']));
 
    }

References $Max, $qcode, $r, $Res, $sql, ATTR_DEF_QUICKCODE, cn, DatabaseCore\fetch_array(), get_attribute(), and DatabaseCore\num_row().

Here is the call graph for this function:

get_bk_balance_currency()

Fiche::get_bk_balance_currency

(

$p_cond = ""

)

Get the sum in Currency.

Parameters

string

$p_cond

Returns

type

Exceptions

Exception

Definition at line 1289 of file fiche.class.php.

    {
        if ( $this->id == 0 ) throw  new Exception('fiche->id est nul');
 
        if ( $p_cond != "") $p_cond=" and ".$p_cond;
        
        $sql = "
              select sum(sum_oc_amount)
              from 
              v_all_card_currency
              where 
              f_id=$1
                $p_cond";
        $val=$this->cn->get_value($sql,[$this->id]);
        
        return $val;
                
    }

References $sql, and cn.

get_by_category()

Fiche::get_by_category	(		$p_offset = -1,
			$p_search = "",
			$p_order = '' )

get all the card thanks the fiche_def_ref

Parameters

$p_offset	(default =-1)
$p_search	sql condition

Returns

array of fiche object

Definition at line 694 of file fiche.class.php.

    {
       switch($p_order)
        {
        case 'name' :
                $order=' order by name';
            break;
        case 'f_id':
            $order='order by f_id';
            break;
        default:
            $order='';
        }
        if ( $p_offset == -1 )
        {
            $sql="select *
                 from
                 fiche join fiche_Def using (fd_id) join vw_fiche_name using(f_id)
                 where frd_id=".$this->fiche_def_ref." $p_search ".$order;
        }
        else
        {
            $limit=($_SESSION[SESSION_KEY.'g_pagesize']!=-1)?"limit ".$_SESSION[SESSION_KEY.'g_pagesize']:"";
            $sql="select *
                 from
                 fiche join fiche_Def using (fd_id) join vw_fiche_name using(f_id)
                 where frd_id=".$this->fiche_def_ref." $p_search $order  "
                 .$limit." offset ".$p_offset;
 
        }
 
        $Ret=$this->cn->exec_sql($sql);
        if ( ($Max=Database::num_row($Ret)) == 0 )
            return [];
        $all[0]=new Fiche($this->cn);
 
        for ($i=0;$i<$Max;$i++)
        {
            $row=Database::fetch_array($Ret,$i);
            $t=new Fiche($this->cn,$row['f_id']);
            $t->load_attribute();
            $all[$i]=clone $t;
 
        }
        return $all;
    }

References $all, $i, $limit, $Max, $order, $p_order, $row, $sql, $t, cn, DatabaseCore\fetch_array(), and DatabaseCore\num_row().

Referenced by GetByDef(), and Summary().

Here is the call graph for this function:

get_by_qcode()

Fiche::get_by_qcode	(		$p_qcode = null,
			$p_all = true )

Retrieve a card thx his quick_code complete the object,, set the id member of the object or set it to 0 if no card is found.

get_by_qcode($p_qcode)

Parameters

$p_qcode	quick_code (ad_id=23)
$p_all	retrieve all the attribut of the card, possible value are true or false. false retrieves only the f_id. By default true

Returns

0 success , card found / 1 error card not found

Definition at line 179 of file fiche.class.php.

    {
        if ( $p_qcode == null )
            $p_qcode=$this->quick_code;
        $p_qcode=trim($p_qcode);
        $sql="select f_id from fiche_detail
             where ad_id=23 and ad_value=upper($1)";
        $this->id=$this->cn->get_value($sql,array($p_qcode));
        if ( $this->cn->count()==0)
        {
            $this->id=0;
            return 1;
        }
 
 
        if ( $p_all )
            $this->load_attribute();
        return 0;
    }

References $quick_code, $sql, cn, and load_attribute().

Referenced by belong_ledger().

Here is the call graph for this function:

get_categorie()

Fiche::get_categorie

(

)

get the fd_id of the card : fd_id, it set the attribute fd_id

Definition at line 1517 of file fiche.class.php.

    {
        if ( $this->id == 0 ) throw  new Exception('class_fiche : f_id = 0 ');
        $sql='select fd_id from fiche where f_id=$1';
        $R=$this->cn->get_value($sql, array($this->id));
        if ( $R == "" )
            $this->fiche_def=0;
        else
            $this->fiche_def=$R;
        return $this->fiche_def;
    }

References $fiche_def, $sql, and cn.

get_f_enable()

Fiche::get_f_enable

(

)

Definition at line 111 of file fiche.class.php.

    {
        return $this->f_enable;
    }

References $f_enable.

Referenced by to_array(), and Card_Property\update().

get_fiche_def()

static Fiche::get_fiche_def ( $p_cn, $card_category_id, $p_order = '', $inactive = 1 )

static

get all the card from a categorie

Parameters

$p_cn	database connx
$card_category_id	is the category id
$p_order	for the sort, possible values is name_asc,name_desc or nothing
$inactive	int possible values : 1 = inactive included, 0 = only active ones (default 1)

Returns

an array of card, but only the fiche->id is set

Definition at line 1629 of file fiche.class.php.

    {
        // var $cond_active string SQL cond for filtering active or not
        $cond_active=($inactive == 1)?"":" and f_enable='1' ";
 
        switch ($p_order)
        {
        case 'name_asc':
            $sql="select f_id,ad_value from fiche join fiche_detail using (f_id) 
                     where 
                         ad_id=1
                       and fd_id=$1 
                       $cond_active
                     order by 2 asc";
            break;
        case 'name_desc':
            $sql="select f_id,ad_value from fiche join fiche_detail using (f_id) 
                     where ad_id=1 
                       and fd_id=$1
                     $cond_active 
                     order by 2 desc";
            break;
        default:
            $sql="select f_id from fiche  where fd_id=$1 $cond_active ";
        }
        $array=$p_cn->get_array($sql,array($card_category_id));
 
        return $array;
    }

References $array, $inactive, $p_order, and $sql.

get_fiche_def_ref()

Fiche::get_fiche_def_ref

(

)

Definition at line 106 of file fiche.class.php.

    {
        return $this->fiche_def_ref;
    }

References $fiche_def_ref.

get_fiche_def_ref_id()

Fiche::get_fiche_def_ref_id

(

)

retrieve the frd_id of the fiche it is the type of the card (bank, purchase...) (fiche_def_ref primary key)

Definition at line 744 of file fiche.class.php.

    {
      $result=$this->cn->get_array("select frd_id from fiche join fiche_Def using (fd_id) where f_id=$1",[$this->id]);
        if ( $result == null )
            return null;
 
        return $result[0]['frd_id'];
    }

References $result, and cn.

get_gestion_title()

Fiche::get_gestion_title

(

)

Definition at line 1880 of file fiche.class.php.

        {
                $r = "<h2 id=\"gestion_title\">" . h($this->getName()) . " " . h($this->get_attribute(ATTR_DEF_FIRST_NAME,0)) . '[' . $this->get_quick_code() . ']</h2>';
                return $r;
        }

References $r, ATTR_DEF_FIRST_NAME, get_attribute(), get_quick_code(), getName(), and h.

Here is the call graph for this function:

get_id()

Fiche::get_id

(

)

Definition at line 101 of file fiche.class.php.

    {
        return $this->id;
    }

References $id.

get_quick_code()

Fiche::get_quick_code

(

)

return the quick_code of a card

Returns

null if not quick_code is found

Definition at line 666 of file fiche.class.php.

    {
        $sql="select ad_value from fiche_detail where ad_id=23 and f_id=$1";
        $Res=$this->cn->exec_sql($sql,array($this->id));
        $r=Database::fetch_all($Res);
        if ( $r == FALSE || sizeof($r) == 0 )
            return null;
        return $r[0]['ad_value'];
    }

References $r, $Res, $sql, cn, and DatabaseCore\fetch_all().

Referenced by belong_ledger(), and get_gestion_title().

Here is the call graph for this function:

get_row()

Fiche::get_row	(		$p_from,
			$p_to )

Get data for poste.

Parameters

$p_from	periode periode.p_id
$p_to	end periode periode.p_id

Returns

double array (j_date,deb_montant,cred_montant,description,jrn_name,j_debit,jr_internal) (tot_deb,tot_credit

Definition at line 886 of file fiche.class.php.

    {
        if ( $this->id == 0 )
        {
            echo_error("class_fiche",__LINE__,"id is 0");
            return;
        }
        $qcode=$this->get_attribute(ATTR_DEF_QUICKCODE);
        $periode=sql_filter_per($this->cn,$p_from,$p_to,'p_id','jr_tech_per');
 
        $this->row=$this->cn->get_array("select j_date,
                            to_char(j_date,'DD.MM.YYYY') as j_date_fmt,
                            j_qcode,
                            case when j_debit='t' then j_montant else 0 end as deb_montant,
                            case when j_debit='f' then j_montant else 0 end as cred_montant,
                            jr_comment as description,
                            jrn_def_name as jrn_name,
                            j_debit, 
                            jr_internal,
                            jr_id 
                            from jrnx 
                            left join jrn_def on jrn_def_id=j_jrn_def 
                            left join jrn on jr_grpt_id=j_grpt
                            where 
                            j_qcode=$1  and {$periode}
                            order by j_date::date",array(
                               $qcode
                                 ));
         $res_saldo = $this->cn->exec_sql("select  sum(deb_montant),sum(cred_montant) from 
                    (select case when j_debit='t' then j_montant else 0 end as deb_montant,
                    case when j_debit='f' then j_montant else 0 end as cred_montant
                                  from jrnx 
                                    left join jrn_def on jrn_def_id=j_jrn_def 
                                    left join jrn on jr_grpt_id=j_grpt
                                    where 
                                    j_qcode=$1  and {$periode} ) as m",
                 array($this->id));
        $this->tot_deb=$this->tot_cred=0;
        
        if ( Database::num_row($res_saldo) > 0 ) {
            $this->tot_deb=Database::fetch_result($res_saldo, 0, 0);
            $this->tot_cred=Database::fetch_result($res_saldo, 0, 1);
        }
        return array($this->row,$this->tot_deb,$this->tot_cred);
 
    }

References $periode, $qcode, ATTR_DEF_QUICKCODE, cn, echo_error(), DatabaseCore\fetch_result(), get_attribute(), DatabaseCore\num_row(), and sql_filter_per().

Here is the call graph for this function:

get_row_date()

Fiche::get_row_date	(		$p_from,
			$p_to,
			$op_let = 0 )

Get data for poste.

Parameters

$p_from	periode from
$p_to	end periode
$op_let	0 all operation, 1 only lettered one, 2 only unlettered one

Returns

double array (j_date,deb_montant,cred_montant,description,jrn_name,j_debit,jr_internal) (tot_deb,tot_credit

Definition at line 792 of file fiche.class.php.

    {
        global $g_user;
        if ( $this->id == 0 )
        {
            echo_error("class_fiche",__LINE__,"id is 0");
            return;
        }
        $filter_sql=$g_user->get_ledger_sql('ALL',3);
        $sql_let='';
        switch ($op_let)
        {
        case 0:
            break;
        case 1:
            $sql_let=' and j1.j_id in (select j_id from letter_cred union select j_id from letter_deb)';
            break;
        case '2':
            $sql_let=' and j1.j_id not in (select j_id from letter_cred union select j_id from letter_deb) ';
            break;
        }
 
        $qcode=$this->get_attribute(ATTR_DEF_QUICKCODE);
        $this->row=$this->cn->get_array("
            with sqlletter as 
            (select j_id,jl_id from letter_cred union all select j_id , jl_id from   letter_deb )
            select distinct substring(jr_pj_number,'[0-9]+$'),j1.j_id,j_date,to_char(j_date,'DD.MM.YYYY') as j_date_fmt,j_qcode,".
                                 "case when j_debit='t' then j_montant else 0 end as deb_montant,".
                                 "case when j_debit='f' then j_montant else 0 end as cred_montant,".
                                 " jr_comment as description,jrn_def_name as jrn_name,j_poste,".
                                 " jr_pj_number,".
                                 "j_debit, jr_internal,jr_id,(select distinct jl_id from sqlletter  where sqlletter.j_id=j1.j_id ) as letter , ".
                                "jr_optype , ".
                                 " jr_tech_per,p_exercice,jrn_def_name,
                                     (with cred as (select jl_id, sum(j_montant) as amount_cred from letter_cred lc1 left join jrnx as j3 on (j3.j_id=lc1.j_id)  group by jl_id ),
                                    deb as (select jl_id, sum(j_montant) as amount_deb from letter_deb ld1 left join jrnx as j2 on (j2.j_id = ld1.j_id)   group by jl_id )
                                    select amount_deb-amount_cred
                                    from 
                                    cred 
                                    full  join deb using (jl_id) where jl_id=(select distinct jl_id from sqlletter  where sqlletter.j_id=j1.j_id  )) as delta_letter,
                                                                  jrn_def_code,
                                  jrn.currency_rate,
                                 jrn.currency_rate_ref,
                                    jrn.currency_id,
                                    (select cr_code_iso from currency where id=jrn.currency_id) as cr_code_iso,
                                    j_montant,
                                    sum_oc_amount as oc_amount,
                                    sum_oc_vat_amount as oc_vat_amount ,
        case when exists(select 1 from operation_analytique oa where j1.j_id=oa.j_id) then 1 else 0 end as op_analytic
                                  from jrnx as j1 left join jrn_def on jrn_def_id=j_jrn_def 
                                  left join (select j_id,
                                                coalesce(oc_amount,0) as sum_oc_amount ,
                                                coalesce(oc_vat_amount,0) as sum_oc_vat_amount  
                                                from jrnx left join operation_currency using (j_id)
                                             )  as v1 on (v1.j_id=j1.j_id ) 
                                  left join jrn on jr_grpt_id=j_grpt".
                                 " left join parm_periode on (p_id=jr_tech_per) ".
                                 " where j_qcode=$1 and ".
                                 " ( to_date($2,'DD.MM.YYYY') <= j_date and ".
                                 "   to_date($3,'DD.MM.YYYY') >= j_date )".
                                 " and $filter_sql $sql_let ".
                                 " order by j_date,substring(jr_pj_number,'[0-9]+$')",array($qcode,$p_from,$p_to));
        
        $res_saldo = $this->cn->exec_sql("select  sum(deb_montant),sum(cred_montant) from 
                    (select case when j_debit='t' then j_montant else 0 end as deb_montant,
                    case when j_debit='f' then j_montant else 0 end as cred_montant
                                  from jrnx j1
                                  join jrn_def on (jrn_def_id=j_jrn_def )
                                   join jrn on (jr_grpt_id=j_grpt)
                                   join tmp_pcmn on (j_poste=pcm_val)
                                   join parm_periode on (p_id=jr_tech_per) 
                                  where f_id=$1 and 
                                  ( to_date($2,'DD.MM.YYYY') <= j_date and 
                                    to_date($3,'DD.MM.YYYY') >= j_date ) 
                                  and $filter_sql  $sql_let ) as m",array($this->id,$p_from,$p_to));
        $this->tot_deb=$this->tot_cred=0;
        
        if ( Database::num_row($res_saldo) > 0 ) {
            $this->tot_deb=Database::fetch_result($res_saldo, 0, 0);
            $this->tot_cred=Database::fetch_result($res_saldo, 0, 1);
        }
        
        return [$this->row,$this->tot_deb,$this->tot_cred];
    }

References $g_user, $qcode, $row, $tot_cred, $tot_deb, ATTR_DEF_QUICKCODE, cn, echo_error(), DatabaseCore\fetch_result(), get_attribute(), and DatabaseCore\num_row().

Referenced by HtmlTable(), and HtmlTableDetail().

Here is the call graph for this function:

get_row_result_deprecated()

Fiche::get_row_result_deprecated ( $res )

private

fetch and return and array

See also

get_row get_row_date

Deprecated

since version 6920

Definition at line 757 of file fiche.class.php.

    {
        $array=array();
        $tot_cred=0.0;
        $tot_deb=0.0;
        $Max=Database::num_row($res);
        if ( $Max == 0 ) return null;
        bcscale(2);
        for ($i=0;$i<$Max;$i++)
        {
            $array[]=Database::fetch_array($res,$i);
            if ($array[$i]['j_debit']=='t')
            {
                $tot_deb=bcadd($tot_deb, $array[$i]['deb_montant'] );
            }
            else
            {
                $tot_cred=bcadd($tot_cred,$array[$i]['cred_montant'] );
            }
        }
        $this->row=$array;
         $this->tot_deb=$tot_deb;
        $this->tot_cred=$tot_cred;
        return array($array,$tot_deb,$tot_cred);
    }

References $array, $i, $Max, $res, $tot_cred, $tot_deb, DatabaseCore\fetch_array(), and DatabaseCore\num_row().

Here is the call graph for this function:

get_solde_detail()

Fiche::get_solde_detail

(

$p_cond = ""

)

give the balance of an card

Returns

balance of the card

Definition at line 1259 of file fiche.class.php.

    {
        if ( $this->id == 0 ) return array('credit'=>0,'debit'=>0,'solde'=>0);
        $qcode=$this->get_attribute(ATTR_DEF_QUICKCODE);
 
        if ( $p_cond != "") $p_cond=" and ".$p_cond;
        $Res=$this->cn->exec_sql("select coalesce(sum(deb),0) as sum_deb,
                                    coalesce(sum(cred),0) as sum_cred from
                                 ( select j_poste,
                                 case when j_debit='t' then j_montant else 0 end as deb,
                                 case when j_debit='f' then j_montant else 0 end as cred
                                 from jrnx
                                 where
                                 j_qcode = ('$qcode'::text)
                                 $p_cond
                                 ) as m  ");
        $Max=Database::num_row($Res);
        if ($Max==0) return 0;
        $r=Database::fetch_array($Res,0);
 
        return array('debit'=>$r['sum_deb'],
                     'credit'=>$r['sum_cred'],
                     'solde'=>abs($r['sum_deb']-$r['sum_cred']));
    }

References $Max, $qcode, $r, $Res, ATTR_DEF_QUICKCODE, cn, DatabaseCore\fetch_array(), get_attribute(), and DatabaseCore\num_row().

Here is the call graph for this function:

getAttribut()

Fiche::getAttribut

(

)

replace by load_attribute

Deprecated

since version 9.3.0.12

Returns

type

Definition at line 231 of file fiche.class.php.

                           {
        return  Card_Property::load($this);
    }

References Card_Property\load().

Here is the call graph for this function:

GetByDef()

Fiche::GetByDef	(		$p_frd_id,
			$p_offset = -1,
			$p_search = "",
			$p_order = '' )

Return array of card from the frd family deprecated , use insert get_by_category_id.

Deprecated

See also

Fiche\get_by_category

Parameters

$p_frd_id	the fiche_def_ref.frd_id NOT USED , $this->fiche_def_ref will be used instead
$p_offset
$p_search	is an optional filter
$p_order	: possible values are name, f_id

Returns

array of fiche object

Definition at line 303 of file fiche.class.php.

    {
           return $this->get_by_category($p_offset,$p_search,$p_order);
    }

References $p_order, and get_by_category().

Here is the call graph for this function:

getDisplayMode()

Fiche::getDisplayMode

(

)

Returns

string

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

                                    : string
    {
        return $this->display_mode;
    }

References $display_mode.

getLabelCategory()

Fiche::getLabelCategory

(

)

Returns

string with the category

Definition at line 405 of file fiche.class.php.

    {
        $type_card=$this->cn->get_value('select fd_label '
            . ' from fiche_def join fiche using (fd_id) where f_id=$1',
            array($this->id));
        return $type_card;
    }

References cn.

getName()

Fiche::getName

(

)

return the name of a card

Definition at line 652 of file fiche.class.php.

    {
        $sql="select ad_value from fiche_detail
             where ad_id=1 and f_id=$1";
        $Res=$this->cn->exec_sql($sql,array($this->id));
        $r=Database::fetch_all($Res);
        if ( empty($r) )
            throw new Exception (_("Fiche n'existe pas"), 1000);
        return $r[0]['ad_value'];
    }

References $r, $Res, $sql, _, cn, and DatabaseCore\fetch_all().

Referenced by get_gestion_title(), and HtmlTableDetail().

Here is the call graph for this function:

HtmlTable()

Fiche::HtmlTable	(		$p_array = null,
			$op_let = 0,
			$from_div = 1 )

HtmlTable, display a HTML of a card for the asked period.

Parameters

$p_array	default = null keys = from_periode, to_periode
$op_let	0 all operation, 1 only lettered one, 2 only unlettered one

Returns

-1 if nothing is found otherwise 0

See also

get_row_date

If the currency is not the default one , then show the amount

Definition at line 1005 of file fiche.class.php.

    {
        if ( $p_array == null)
            $p_array=$_REQUEST;
        global $g_parameter;
        $progress=0;
        // if from_periode is greater than to periode then swap the values
        if (cmpDate($p_array['from_periode'],$p_array['to_periode']) > 0)
        {
                $tmp=$p_array['from_periode'];
                $p_array['from_periode']=$p_array['to_periode'];
                $p_array['to_periode']=$tmp;
 
        }
        list($array, $tot_deb, $tot_cred) = $this->get_row_date($p_array['from_periode'], $p_array['to_periode'], $op_let);
 
        if ( count($this->row ) == 0 )
            return -1;
        
        $acc_account_ledger=new Acc_Account_Ledger($this->cn,$this->get_attribute(ATTR_DEF_ACCOUNT));
        $type=$acc_account_ledger->get_type();
        // label  warning if the saldo is incorrect
        $label="";
        if (in_array($type,array('CHA','ACT','PASINV','PROINV')) && $tot_deb<$tot_cred)
        {
 
            $label.=_("Solde créditeur au lieu de débiteur").'<span class="icon">&#xe80e;</span>';
        }
        if (in_array($type,array('PRO','PAS','ACTINV','CHAINV')) && $tot_deb>$tot_cred)
        {
 
            $label.=_("Solde débiteur au lieu de créditeur")." ".'<span class="icon">&#xe80e;</span>';
        }
        if ( $label !="" ) 
                echo '<span class="notice" >'.$label.'</span>';
        $rep="";
        if ( $from_div==1)
          {
            echo "<TABLE id=\"tbpopup\" class=\"resultfooter\" style=\"margin:1%;width:98%;;border-collapse:collapse;border-spacing:0px 5px\">";
          }
        else
          {
            echo "<TABLE id=\"tb" . $from_div . "\"class=\"result\" style=\"margin:1%;width:98%;border-collapse:collapse;border-spacing:0px 2px\">";
                }
        echo '<tbody>';
        echo "<TR>".
        "<TH style=\"text-align:left\">"._('Date')."</TH>".
        "<TH style=\"text-align:left\">"._('Pièce')." </TH>".
        "<TH style=\"text-align:left\">"._('Poste')." </TH>".
        "<TH style=\"text-align:left\">"._('Interne')." </TH>".
        "<TH style=\"text-align:left\">"._('Tiers')." </TH>".
        "<TH class=\"visible_gt800\" style=\"text-align:left\">"._('Description')." </TH>".
        "<TH class=\"visible_gt800\"  style=\"text-align:left\">"._('Type')."</TH>".
        "<TH class=\"visible_gt800\"  style=\"text-align:left\">"._('ISO')."</TH>".
        "<TH class=\"visible_gt800\"  style=\"text-align:right\">"._('Dev.')."</TH>".
        "<TH style=\"text-align:right\">"._('Débit')."  </TH>".
        "<TH style=\"text-align:right\">"._('Crédit')." </TH>".
        th('Prog.','style="text-align:right"').
        th('Let.','class="visible_gt800"  style="text-align:right"');
        "</TR>"
        ;
        $old_exercice="";$sum_deb=0;$sum_cred=0;
        bcscale(2);
        $idx=0;
        $operation=new Acc_Operation($this->cn);
        foreach ( $this->row as $op )
        {
            $vw_operation = sprintf('<A class="detail" style="text-decoration:underline;color:red" HREF="javascript:modifyOperation(\'%s\',\'%s\')" >%s</A>', $op['jr_id'], dossier::id(), $op['jr_internal']);
            $let = '';
            $html_let = "";
            if ($op['letter'] != "")
            {
                    $let = strtoupper(base_convert($op['letter'], 10, 36));
                    $html_let = HtmlInput::show_reconcile($from_div, $let);
                     if ( $op['delta_letter'] != 0) $html_let='<img src="image/warning.png" onmouseover="displayBulle(\'delta = '.$op['delta_letter'].'\')" onmouseleave="hideBulle()" style="height:12px"/>'.$html_let;
            }
            $tmp_diff=bcsub($op['deb_montant'],$op['cred_montant']);
 
            /*
             * reset prog. balance to zero if we change of exercice
             */
            if ( $old_exercice != $op['p_exercice'])
              {
                if ($old_exercice != '' )
                  {
                    $progress=bcsub($sum_deb,$sum_cred);
                        $side="&nbsp;".$this->get_amount_side($progress);
                    echo "<TR class=\"highlight\">".
                            td($op['p_exercice']).
                            td("",' class="visible_gt800" ').
                            td("",' class="visible_gt800" ').
                            td("",' class="visible_gt800" ').
                            td().
                            td(_('Totaux')).
                            td("",' class="visible_gt800" ').
                            td("",' class="" ').
                            "<TD></TD>".
                            "<TD  style=\"text-align:right\">".nbm($sum_deb)."</TD>".
                            "<TD  style=\"text-align:right\">".nbm($sum_cred)."</TD>".
                            td(nbm(abs($progress)).$side,'style="text-align:right"').
                           td("",' class="visible_gt800" ').
                            "</TR>";
                    $sum_cred=0;
                    $sum_deb=0;
                    $progress=0;
                  }
              }
            $progress=bcadd($progress,$tmp_diff);
            $side="&nbsp;".$this->get_amount_side($progress);
            $sum_cred=bcadd($sum_cred,$op['cred_montant']);
            $sum_deb=bcadd($sum_deb,$op['deb_montant']);
            if ($idx%2 == 0) $class='class="odd"'; else $class=' class="even"';
            $idx++;
            
            $tiers=$operation->find_tiers($op['jr_id'], $op['j_id'], $op['j_qcode']);
            $op_analytic=($op['op_analytic']==1)?'<span style="float:right;background:black;color:white;">&ni;</span>':'';
            echo "<TR $class name=\"tr_" . $let . "_" . $from_div . "\">" .
                        "<TD>".smaller_date(format_date($op['j_date_fmt']))."</TD>".
              td(h($op['jr_pj_number'])).
               td($op['j_poste']).
            "<TD>".$vw_operation."</TD>".
            td($tiers, ' class="visible_gt800" ').
            "<TD  class=\"visible_gt800\" >".h($op['description']).$op_analytic."</TD>".
                    td($op['jr_optype']);
            
            /// If the currency is not the default one , then show the amount
            if ( $op['currency_id'] > 0 && $op['oc_amount'] != 0)
            {
             echo   td($op['cr_code_iso'], ' class="visible_gt800" ').
                    td(nbm($op['oc_amount'],4),' class="visible_gt800"  style="text-align:right;padding-left:10px;"');
            } else {
                echo td("",' class="visible_gt800" ').td("",' class="visible_gt800" ');
            }
            
            echo "<TD style=\"text-align:right\">".nbm($op['deb_montant'])."</TD>".
              "<TD style=\"text-align:right\">".nbm($op['cred_montant'])."</TD>".
              td(nbm(abs($progress)).$side,'style="text-align:right"').
            td($html_let, ' style="text-align:right"  class="visible_gt800" ') .
                        "</TR>";
            $old_exercice=$op['p_exercice'];
 
        }
        $solde_type=($sum_deb>$sum_cred)?_("solde débiteur"):_("solde créditeur");
        $solde_side=($sum_deb>$sum_cred)?"D":"C";
        $diff=abs(bcsub($sum_deb,$sum_cred));
        echo '<tfoot>';
       echo "<TR class=\"highlight\">".
               td($op['p_exercice']).
                td("",' class="visible_gt800" ').
                td("",' class="visible_gt800" ').
                td("",' class="visible_gt800" ').
               td().
        td(_('Totaux')).
                td("",' class="visible_gt800" ').
                td("",' class="" ').
        "<TD></TD>".
         "<TD  style=\"text-align:right\">".nbm($sum_deb)."</TD>".
         "<TD  style=\"text-align:right\">".nbm($sum_cred)."</TD>".
          "<TD style=\"text-align:right\">".nbm($diff).$solde_side."</TD>".
            td("",' class="visible_gt800" ').
        "</TR>";
        echo "<TR style=\"font-weight:bold\">".
        "<TD>$solde_type</TD>".
          "<TD style=\"text-align:right\">".nbm($diff)."</TD>".
        "<TD></TD>".
        "</TR>";
        // take saldo from 1st day until last
        if ($g_parameter->MY_REPORT=='N') {
            $solde_until_now=$this->get_solde_detail("  j_date <= to_date('{$p_array['to_periode']}','DD.MM.YYYY')  ");
            echo '<tr style="font-weight:bold;color:orangered">';
            echo td(_("Solde global"));
            echo td("D : ".nbm($solde_until_now['debit']),'class="num"');
            echo td("C : ".nbm($solde_until_now['credit']),'class="num"');
            echo td("Delta : ".nbm($solde_until_now['solde'])." ".$this->get_amount_side($solde_until_now['debit']-$solde_until_now['credit']),'class="num"');
            echo '</tr>';
 
        }
        echo '</tfoot>';
        echo '</tbody>';
 
        echo "</table>";
 
        return 0;
    }

References $_REQUEST, $acc_account_ledger, $array, $class, $from_div, $g_parameter, $idx, $label, $let, $op, $operation, $p_array, $progress, $rep, $side, $tiers, $tmp, $tot_cred, $tot_deb, $type, _, ATTR_DEF_ACCOUNT, cmpDate(), cn, format_date(), get_attribute(), get_row_date(), h, nbm(), td(), and th().

Here is the call graph for this function:

HtmlTableDetail()

Fiche::HtmlTableDetail	(		$p_array = null,
			$op_let = 0 )

HtmlTable, display a HTML of a card for the asked period.

Parameters

$op_let

0 all operation, 1 only lettered one, 2 only unlettered one

Returns

none

Definition at line 937 of file fiche.class.php.

    {
        if ( $p_array == null)
            $p_array=$_REQUEST;
 
        $name=$this->getName();
 
        list($array,$tot_deb,$tot_cred)=$this->get_row_date( $p_array['from_periode'],
                                        $p_array['to_periode'],
                                        $op_let
                                                           );
 
        if ( count($this->row ) == 0 )
            return;
        $qcode=$this->get_attribute(ATTR_DEF_QUICKCODE);
 
        $rep="";
        $already_seen=array();
        echo '<h2 class="info">'.$this->id." ".$name.'</h2>';
        echo "<TABLE class=\"result\" style=\"width:100%;border-collapse:separate;border-spacing:5px\">";
        echo "<TR>".
        "<TH>"._("n° de pièce / Code interne")." </TH>".
        "<TH>"._("Date")."</TH>".
        "<TH>"._("Description")." </TH>".
        "<TH>"._('Montant')."  </TH>".
        "<TH> "._('Débit/Crédit')." </TH>".
        "</TR>";
 
        foreach ( $this->row as $op )
        {
            if ( in_array($op['jr_internal'],$already_seen) )
                continue;
            else
                $already_seen[]=$op['jr_internal'];
            echo "<TR  style=\"text-align:center;background-color:lightgrey\">".
            "<td>".$op['jr_pj_number']." / ".$op['jr_internal']."</td>".
            "<td>".$op['j_date']."</td>".
            "<td>".h($op['description'])."</td>".
            "<td>"."</td>".
            "<td>"."</td>".
            "</TR>";
            $ac=new Acc_Operation($this->cn);
            $ac->jr_id=$op['jr_id'];
            $ac->qcode=$qcode;
            echo $ac->display_jrnx_detail(1);
 
        }
        $solde_type=($tot_deb>$tot_cred)?_("solde débiteur"):_("solde créditeur");
        $diff=round(abs($tot_deb-$tot_cred),2);
        echo "<TR>".
        "<TD>$solde_type".
        "<TD>$diff</TD>".
        "<TD></TD>".
        "<TD>$tot_deb</TD>".
        "<TD>$tot_cred</TD>".
        "</TR>";
 
        echo "</table>";
 
        return;
    }

References $_REQUEST, $ac, $array, $diff, $name, $op, $p_array, $qcode, $rep, $solde_type, $tot_cred, $tot_deb, _, ATTR_DEF_QUICKCODE, cn, get_attribute(), get_row_date(), and getName().

Here is the call graph for this function:

HtmlTableHeader()

Fiche::HtmlTableHeader

(

$p_array = null

)

Display HTML Table Header (button)

Returns

none

Definition at line 1194 of file fiche.class.php.

    {
        if ( $p_array == null)
            $p_array=$_REQUEST;
 
        $hid=new IHidden();
        echo '<div class="noprint">';
        echo "<table >";
        echo '<TR>';
 
        echo '<TD><form method="GET" ACTION="">'.
            HtmlInput::submit('bt_other',_("Autre poste")).
            HtmlInput::array_to_hidden(array('gDossier','ac'), $_REQUEST).
            dossier::hidden().
            $hid->input("type","poste").$hid->input('p_action','impress')."</form></TD>";
        $str_ople=(isset($_REQUEST['ople']))?HtmlInput::hidden('ople',$_REQUEST['ople']):'';
 
        echo '<TD><form method="GET" ACTION="export.php" ';
        $id=uniqid("export_");
        printf( 'id="%s"  onsubmit="download_document_form(\'%s\')">',$id,$id);
        echo 
            HtmlInput::submit('bt_pdf',_("Export PDF")).
            dossier::hidden().$str_ople.
              HtmlInput::hidden('act','PDF:fichedetail').
            $hid->input("type","poste").
            $hid->input('p_action','impress').
            $hid->input("f_id",$this->id).
            dossier::hidden().
            $hid->input("from_periode",$p_array['from_periode']).
            $hid->input("to_periode",$p_array['to_periode']);
        if (isset($p_array['oper_detail']))
            echo $hid->input('oper_detail','on');
 
        echo "</form></TD>";
 
        echo '<TD><form method="GET" ACTION="export.php" ';
        $id=uniqid("export_");
        printf( 'id="%s"  onsubmit="download_document_form(\'%s\')">',$id,$id);
 
        echo HtmlInput::submit('bt_csv',_("Export CSV")).
          HtmlInput::hidden('act','CSV:fichedetail').
        dossier::hidden().$str_ople.
        $hid->input("type","poste").
        $hid->input('p_action','impress').
        $hid->input("f_id",$this->id).
        $hid->input("from_periode",$p_array['from_periode']).
        $hid->input("to_periode",$p_array['to_periode']);
        if (isset($p_array['oper_detail']))
            echo $hid->input('oper_detail','on');
 
        echo "</form></TD>";
                echo "</form></TD>";
                echo '<td style="vertical-align:top">';
                echo HtmlInput::print_window();
                echo '</td>';
        echo "</table>";
        echo '</div>';
 
    }

References $_REQUEST, $hid, $id, $p_array, and _.

insert()

Fiche::insert	(		$p_fiche_def,
			$p_array = null,
			$transaction = true )

insert a new record thanks an array , either as parameter or $_POST

Parameters

$p_fiche_def	fiche_def.fd_id
$p_array	(double array) array containing arrays of key (av_textX where X is AD_ID ), value of the property
$transation	DEPRECATED : if we are in a transaction, we don't commit here , else if not, the then a transaction is started and committed

av_textX where X is the ad_id

example
av_text1=>'name'

Definition at line 495 of file fiche.class.php.

    {
        if ($p_array==null)
            $p_array=$_POST;
 
        $fiche_id=$this->cn->get_next_seq('s_fiche');
        $this->id=$fiche_id;
        $this->fiche_def=$p_fiche_def;
        try
        {
 
            // by default the card is available
            if (!isset($p_array['f_enable']))
            {
                $p_array['f_enable']=1;
            }
            $Ret=$this->cn->exec_sql("insert into fiche(f_id,f_enable,fd_id) values ($1,$2,$3)",
                    array($fiche_id, $p_array['f_enable'], $p_fiche_def));
            // first we need to save the name , to compute properly the quickcode
            if ( empty ($p_array['av_text'.ATTR_DEF_NAME])) {
 
                $p_array['av_text'.ATTR_DEF_NAME]=_("Nom vide");
            }
            // the name must be saved first
            $this->cn->exec_sql("insert into fiche_detail (f_id,ad_id,ad_value) values ($1,$2,$3)",
                array($fiche_id,1,$p_array['av_text'.ATTR_DEF_NAME]));
 
            // compute a quick_code
            if (!isset($p_array["av_text".ATTR_DEF_QUICKCODE]))
            {
                $p_array["av_text".ATTR_DEF_QUICKCODE]="";
            }
            // by default the quick_code is the base account of the class + first letters of the name
            if ( $p_array["av_text".ATTR_DEF_QUICKCODE] =="")
            {
                if ( ! empty( $p_array['av_text'. ATTR_DEF_ACCOUNT])) {
                    $base_acc=substr($p_array['av_text'. ATTR_DEF_ACCOUNT]??"",0, 3);
                }else {
                    $base_acc=$this->cn->get_value("select substr(fd_class_base,1,2) from fiche_def where fd_id = $1",
                        [$p_fiche_def]);
                }
                $p_array["av_text".ATTR_DEF_QUICKCODE]=sprintf("%s%s"
                            , $base_acc
                            , substr($p_array["av_text".ATTR_DEF_NAME], 0, 4)
                        );
            }
            $sql=sprintf("select insert_quick_code(%d,'%s')", $fiche_id,
                    sql_string($p_array['av_text'.ATTR_DEF_QUICKCODE]));
            $this->cn->exec_sql($sql);
            // get the card properties for this card category
            $fiche_def=new Fiche_Def($this->cn, $p_fiche_def);
            
            $this->attribut=$fiche_def->load_attribute();
 
            if (empty($this->attribut))
            {
                throw new Exception("FICHE.UPDATE02"._("Aucun attribut ")."($p_fiche_def)", EXC_INVALID);
            }
            // for each property set the attribut on the card
            foreach ($this->attribut as $property)
            {
                $key='av_text'.$property->ad_id;
                if (isset($p_array[$key]))
                {
                    $this->set_attribute($property->ad_id, $p_array[$key]);
                }
            }
            // For accounting 
            
            Card_Property::update($this);
            // reread from database
            $this->load_attribute();
        }
        catch (Exception $e)
        {
            record_log($e);
            $this->cn->rollback();
            throw (new \Exception ("F561 ". __CLASS__.".".__FUNCTION__,561,$e));
            return;
        }
        return;
    }

References $_POST, $e, $fiche_def, $fiche_id, $p_array, $sql, _, ATTR_DEF_ACCOUNT, ATTR_DEF_NAME, ATTR_DEF_QUICKCODE, cn, EXC_INVALID, load_attribute(), record_log(), set_attribute(), sql_string(), and Card_Property\update().

Referenced by save().

Here is the call graph for this function:

is_used()

Fiche::is_used

(

)

check if a card is used

Returns

return true is a card is used otherwise false

Definition at line 1661 of file fiche.class.php.

    {
        /* retrieve first the quickcode */
        $qcode=$this->get_attribute(ATTR_DEF_QUICKCODE);
        $sql='select count(*) as c from jrnx where j_qcode=$1';
        $count=$this->cn->get_value($sql,array($qcode));
                if ( $count > 0 ) return TRUE;
        $count=$this->cn->get_value("select count(*) from action_gestion where f_id_dest=$1 or ag_contact=$1 ",
                [$this->id]);
        if ( $count > 0 ) return TRUE;
        $count=$this->cn->get_value("select count(*) from action_person where f_id=$1 ",
                [$this->id]);
        if ( $count > 0 ) return TRUE;
        
        $count=$this->cn->get_value("
                                select count(*) 
                from attr_def
                join fiche_detail using (ad_id)
                where ad_type='card'
                and ad_value=$1"
                ,[$qcode]);
        
        if ( $count > 0 ) return TRUE;
        
        return FALSE;
 
    }

References $count, $qcode, $sql, ATTR_DEF_QUICKCODE, cn, and get_attribute().

Referenced by remove().

Here is the call graph for this function:

load()

Fiche::load

(

)

Synonum of fiche::load_attribute.

Definition at line 684 of file fiche.class.php.

                    :void
    {
        $this->load_attribute();
    }

References load_attribute().

Referenced by __construct().

Here is the call graph for this function:

load_attribute()

Fiche::load_attribute

(

)

get all the attribute of a card, add missing ones and sort the array ($this->attribut) by ad_id

Definition at line 238 of file fiche.class.php.

    {
        Card_Property::load($this);
    }

References Card_Property\load().

Referenced by Display(), display_row(), Get(), get_attribute(), get_by_qcode(), insert(), load(), set_attribute(), to_array(), and update().

Here is the call graph for this function:

move_to()

Fiche::move_to

(

$p_fdid

)

move a card to another cat.

The properties will changed and be removed

Parameters

$p_fdid

the fd_id of destination

Definition at line 1810 of file fiche.class.php.

    {
        $this->cn->start();
        $this->cn->exec_sql('update fiche set fd_id=$1 where f_id=$2',array($p_fdid,$this->id));
        // add missing
        $this->cn->exec_sql('select fiche_attribut_synchro($1)',array($p_fdid));
        // add to the destination missing fields
        $this->cn->exec_sql("insert into jnt_fic_attr (fd_id,ad_id,jnt_order) select $1,ad_id,100 from fiche_detail where f_id=$2 and ad_id not in (select ad_id from jnt_fic_attr where fd_id=$3)",array($p_fdid,$this->id,$p_fdid));
        $this->cn->commit();
    }

References cn.

remove()

Fiche::remove

(

$silent = false

)

remove a card, check if not used first, must be synchro with is_used

Definition at line 631 of file fiche.class.php.

    {
        if ( $this->id==0 ) return;
        // verify if that card has not been used is a ledger nor in the followup
        // if the card has its own account in PCMN
        // Get the fiche_def.fd_id from fiche.f_id
        if ( $this->is_used() == FALSE) {
            $this->delete();
            return 0;
        }
        
        if ( ! $silent ) {
            alert(_('Impossible cette fiche est utilisée dans un journal'));
        }
        return 1;
    }

References _, alert(), and is_used().

Here is the call graph for this function:

save()

Fiche::save

(

$p_fiche_def = 0

)

Save a card, call insert or update.

See also

Fiche\insert , Fiche\update

Parameters

p_fiche_def

(default 0)

Definition at line 473 of file fiche.class.php.

    {
        // new card or only a update ?
        if ( $this->id == 0 )
            $this->insert($p_fiche_def);
        else
            $this->update();
    }

References insert(), and update().

Here is the call graph for this function:

seek()

Fiche::seek	(		$p_attribut,
			$p_value )

find the card with the p_attribut equal to p_value, it is not case sensitive

Parameters

int	$p_attribut	attribute to find see table attr_def
string	$p_value	value in attr_value.av_text

Returns

array returns ARRAY OF jft_id,f_id,fd_id,ad_id,av_text

Definition at line 248 of file fiche.class.php.

    {
        $sql="select jft_id,f_id,fd_id,ad_id,ad_value from fiche join fiche_detail using (f_id)
             where ad_id=$1 and upper(ad_value)=upper($2)";
        $res=$this->cn->get_array($sql,array($p_attribut,$p_value));
        return $res;
    }

References $res, $sql, and cn.

set_attribute()

Fiche::set_attribute	(		$p_ad_id,
			$p_value )

set an attribute by a value, if the attribut array is empty a call to load_attribute is performed

Parameters

int	AD_ID attr_def.ad_id
int	value value of this attribute

See also

constant.php table: attr_def

Definition at line 212 of file fiche.class.php.

    {
        if ( $this->fiche_def == 0) throw new Exception ("FICHE.179 Invalid category",EXC_INVALID);
        if ( sizeof($this->attribut)==0 ) $this->load_attribute();
        
        for ($e=0;$e <sizeof($this->attribut);$e++)
        {
            if ( $this->attribut[$e]->ad_id == $p_ad_id )
            {
                $this->attribut[$e]->av_text=$p_value;
                break;
            }
        }
    }

References $attribut, $e, EXC_INVALID, and load_attribute().

Referenced by insert(), setAttribut(), and update().

Here is the call graph for this function:

set_f_enable()

Fiche::set_f_enable

(

$f_enable

)

Definition at line 128 of file fiche.class.php.

    {
        $this->f_enable=$f_enable;
        return $this;
    }

References $f_enable.

Referenced by update().

set_fiche_def()

Fiche::set_fiche_def

(

$p_fiche_def

)

Definition at line 95 of file fiche.class.php.

    {
        $this->fiche_def=$p_fiche_def;
        return $this;
    }

set_fiche_def_ref()

Fiche::set_fiche_def_ref

(

$fiche_def_ref

)

Definition at line 122 of file fiche.class.php.

    {
        $this->fiche_def_ref=$fiche_def_ref;
        return $this;
    }

References $fiche_def_ref.

set_id()

Fiche::set_id

(

$id

)

Definition at line 116 of file fiche.class.php.

    {
        $this->id=$id;
        return $this;
    }

References $id.

setAttribut()

Fiche::setAttribut	(		$p_ad_id,
			$p_value )

replace by set_attribute

Deprecated

since version 9.3.0.12

Definition at line 202 of file fiche.class.php.

                                            {
        $this->set_attribute($p_ad_id, $p_value);
    }

References set_attribute().

Here is the call graph for this function:

setDisplayMode()

Fiche::setDisplayMode

(

$p_mode

)

how the card is display : either in a window or a greated container

Parameters

string

$p_mode

can be large or window

Returns

Fiche

Exceptions

Exception

Definition at line 80 of file fiche.class.php.

                                     {
        if ( ! in_array($p_mode,array("window","large"))) {
            throw new Exception("FIC70 invalide display mode");
        }
        $this->display_mode=$p_mode;
        return $this;
    }

ShowTable()

Fiche::ShowTable

(

)

Definition at line 307 of file fiche.class.php.

    {
        echo "<TR><TD> ".
        $this->id."</TD>".
        "<TR> <TD>".
        $this->attribut_value."</TD>".
        "<TR> <TD>".
        $this->attribut_def."</TD></TR>";
    }

strAttribut()

Fiche::strAttribut	(		$p_ad_id,
			$p_return = 1 )

use get_attribute instead

Deprecated

since version 9.3.12

Parameters

int	$p_ad_id	AD_ID from attr_def.ad_id
int	$p_return	1 return NOTFOUND otherwise an empty string

Definition at line 322 of file fiche.class.php.

    {
        return $this->get_attribute($p_ad_id,$p_return);
    }

References get_attribute().

Here is the call graph for this function:

Summary()

Fiche::Summary	(		$p_search = "",
			$p_action = "",
			$p_sql = "",
			$p_amount = false )

show the default screen

Parameters

$p_search	(filter)
$p_action	used for specific action bank, red if credit < debit
$p_sql	SQL to filter the number of card must start with AND
$p_amount	true : only cards with at least one operation default : false

Returns

: string to display

the accounting is a financial account

Reimplemented in contact.

Definition at line 1366 of file fiche.class.php.

    {
        global $g_user;
        global $g_parameter;
        $http=new HttpInput();
        $bank=new Acc_Parm_Code($this->cn,'BANQUE');
        $cash=new Acc_Parm_Code($this->cn,'CAISSE');
        $cc=new Acc_Parm_Code($this->cn,'COMPTE_COURANT');
 
        bcscale(4);
        $gDossier=dossier::id();
        $p_search=sql_string($p_search);
        $script=$_SERVER['PHP_SELF']??"";
        // Creation of the nav bar
        // Get the max numberRow
        $filter_amount='';
 
        $filter_year="  j_tech_per in (select p_id from parm_periode ".
                     "where p_exercice='".$g_user->get_exercice()."')";
 
        if ($p_amount) {
            $filter_amount = ' and f_id in (select f_id from jrnx where  ' . $filter_year . ')';
        }
 
        $all_tiers=$this->count_by_modele($this->fiche_def_ref,"",$p_sql.$filter_amount);
        // Get offset and page variable
        $offset=$http->request("offset","number",0);
        $page=$http->request("page","number",1);
        $bar=navigation_bar($offset,$all_tiers,$_SESSION[SESSION_KEY.'g_pagesize'],$page);
 
        // set a filter ?
        $search=$p_sql;
 
        if ( noalyss_trim($p_search) != "" )
        {
            $search.=" and f_id in
                     (select distinct f_id from fiche_detail
                     where
                     ad_id in (1,32,30,23,18,13) and ad_value ilike '%$p_search%')";
        }
        // Get The result Array
        $step_tiers=$this->get_by_category($offset,$search.$filter_amount,'name');
 
        if ( $all_tiers == 0 || empty($step_tiers ) ) { return ""; }
        $r="";
        $r.=$bar;
 
        $r.='<table  id="tiers_tb" class="sortable"  style="">
            <TR >
            <TH>'._('Quick Code').Icon_Action::infobulle(17).'</TH>'.
            '<th>'._('Poste comptable').'</th>'.
            '<th  class="sorttable_sorted">'._('Nom').'</span>'.'</th>'.
            '<th>'._('Compte en banque').'</th>'.
            '<th>'._('Adresse').'</th>'.
            '<th>'._('site web').'</th>'.
            '<th style="text-align:right">'._('Total débit').'</th>
            <th style="text-align:right">'._('Total crédit').'</th>
            <th style="text-align:right">'._('Solde').'</th>';
        $r.='</TR>';
        if ( sizeof ($step_tiers ) == 0 )
            return $r;
 
        $i=0;
                $deb=0;$cred=0;
        foreach ($step_tiers as $tiers )
        {
            $i++;
 
             /* Filter on the default year */
            if ( $g_parameter->MY_REPORT == 'N') {
                list($l_from,$l_to)=(new Periode($this->cn))->get_limit($g_user->get_exercice());
                $condition = sprintf ("  j_date <= to_date('%s','DD.MM.YYYY')  ",                                $l_to->last_day());
                $amount = $tiers->get_solde_detail($condition);
            } else {
                $amount=$tiers->get_solde_detail($filter_year);
            }
 
            /* skip the tiers without operation */
            if ( $p_amount && $amount['debit']==0 && $amount['credit'] == 0 && $amount['solde'] == 0 ) continue;
 
            $odd="";
             $odd  = ($i % 2 == 0 ) ? ' odd ': ' even ';
             $accounting=$tiers->get_attribute(ATTR_DEF_ACCOUNT,0);
             if ( ! empty($accounting) && $p_action == 'bank'
                     && $amount['debit'] <  $amount['credit']
                     &&
                     ( /** the accounting is a financial account *****/
                         (!empty ($bank->value) && strpos($accounting,$bank->p_value)===0 )
                      || (!empty ($cash->value) && strpos($accounting,$cash->p_value)===0 )
                      || ( !empty ($cc->value) && strpos($accounting,$cc->p_value)===0)
                    )
                )
                {
                 //put in red if c>d
                 $odd.=" notice ";
                 }
 
             $odd=' class="'.$odd.'"';
 
            $r.="<TR $odd>";
            $url_detail=$script.'?'.http_build_query(array('sb'=>'detail','sc'=>'sv','ac'=>$_REQUEST['ac'],'f_id'=>$tiers->id,'gDossier'=>$gDossier));
            $e=sprintf('<A HREF="%s" title="Détail" class="line"> ',
                       $url_detail);
 
            $r.="<TD> $e".$tiers->get_attribute(ATTR_DEF_QUICKCODE)."</A></TD>";
            $r.="<TD sorttable_customkey=\"text{$accounting}\"> $e".$accounting."</TD>";
            $r.="<TD>".h($tiers->get_attribute(ATTR_DEF_NAME))."</TD>";
            $r.=td($tiers->get_attribute(ATTR_DEF_BQ_NO,0));
            $r.="<TD>".h($tiers->get_attribute(ATTR_DEF_ADRESS,0).
                         " ".$tiers->get_attribute(ATTR_DEF_POSTCODE,0).
                         " ".$tiers->get_attribute(ATTR_DEF_COUNTRY,0)).
                "</TD>";
            $r.='<td>'.linkTo($tiers->get_attribute(ATTR_DEF_WEBSITE,0)).'</td>';
            $str_deb=(($amount['debit']==0)?0:nbm($amount['debit']));
            $str_cred=(($amount['credit']==0)?0:nbm($amount['credit']));
            $str_solde=nbm($amount['solde']);
            $r.='<TD sorttable_customkey="'.$amount['debit'].'" align="right"> '.$str_deb.'</TD>';
            $r.='<TD sorttable_customkey="'.$amount['credit'].'" align="right"> '.$str_cred.'</TD>';
            $side=($amount['debit'] >  $amount['credit'])?'D':'C';
            $side=($amount['debit'] ==  $amount['credit'])?'=':$side;
            $red="";
            if ( $p_action == 'customer' && $amount['debit'] <  $amount['credit']  ){
                 //put in red if d>c
                 $red=" notice ";
             }
             if ( $p_action == 'supplier' && $amount['debit'] >  $amount['credit']  ){
                 //put in red if c>d
                 $red=" notice ";
             }
            $r.='<TD class="'.$red.'" sorttable_customkey="'.$amount['solde'].'" align="right"> '.$str_solde."$side </TD>";
            $deb=bcadd($deb,$amount['debit']);
            $cred=bcadd($cred,$amount['credit']);
 
            $r.="</TR>";
 
        }
                $r.="<tfoot >";
                $solde=abs(bcsub($deb,$cred));
                $side=($deb > $cred)?'Débit':'Crédit';
                $r.='<tr class="highlight">';
                $r.=td("").td("").td("").td("").td("Totaux").td(nbm($deb),'class="num"').td(nbm($cred),'class="num"').td(" $side ".nbm($solde),'class="num"');
                $r.='</tr>';
                $r.="</tfoot>";
        $r.="</TABLE>";
        $r.=$bar;
        
        return $r;
    }

References $_REQUEST, $accounting, $amount, $bar, $cred, $deb, $e, $filter_year, $g_parameter, $g_user, $gDossier, $http, $i, $offset, $p_action, $r, $script, $search, $side, $solde, $tiers, _, ATTR_DEF_ACCOUNT, ATTR_DEF_ADRESS, ATTR_DEF_BQ_NO, ATTR_DEF_COUNTRY, ATTR_DEF_NAME, ATTR_DEF_POSTCODE, ATTR_DEF_QUICKCODE, ATTR_DEF_WEBSITE, cn, count_by_modele(), get_by_category(), navigation_bar(), nbm(), noalyss_trim(), sql_string(), and td().

Here is the call graph for this function:

test_me()

static Fiche::test_me ( )

static

Definition at line 1834 of file fiche.class.php.

    {
        $cn=Dossier::connect();
        $http=new HttpInput();
        echo h1('Test select category');
        $a=new Fiche($cn);
        $select_cat=new ISelect('fd_id');
        $select_cat->value=$cn->make_array('select fd_id,fd_label from fiche_def where frd_id='.
                                           FICHE_TYPE_CLIENT);
        echo '<FORM METHOD="GET"> ';
        echo dossier::hidden();
        echo HtmlInput::hidden('test_select',$http->get('test_select',"string",1));
        echo 'Choix de la catégorie';
        echo $select_cat->input();
        echo HtmlInput::submit('go_card','Afficher');
        echo '</form>';
        if ( isset ($_GET['go_card']))
        {
            $empty=$a->to_array($_GET['fd_id']);
            print_r($empty);
        }
        // testing insert
        echo h1("Insert new card");
        $name="test ".microtime();
        $fiche=new Fiche($cn);
        $fiche_def=new Fiche_Def($cn,1);
        $fiche_def->get();
 
        $fiche->set_fiche_def($fiche_def->id);
 
        $fiche->set_attribute(ATTR_DEF_NAME,$name);
        $fiche->set_attribute(ATTR_DEF_ACCOUNT,$fiche_def->class_base.$name);
 
        echo p(print_r($fiche->to_array(),false));
        $fiche->insert(1,$fiche->to_array());
        assert($name == $fiche->get_attribute(ATTR_DEF_NAME));
 
        echo p("fiche ATTR_DEF_ACCOUNT after insert ",$fiche->get_attribute(ATTR_DEF_ACCOUNT));
        $accounting=$fiche->get_attribute(ATTR_DEF_ACCOUNT);
        $acc_accounting=new Acc_Account($cn,$accounting);
 
        echo p("accounting id",$acc_accounting->get_parameter("id"));
        assert($acc_accounting->get_lib("pcm_lib") == $name,"Cannot create a new accouting with 
        the right label");
    }

References $_GET, $a, $accounting, $cn, $fiche, $fiche_def, $http, $name, $select_cat, ATTR_DEF_ACCOUNT, ATTR_DEF_NAME, FICHE_TYPE_CLIENT, h1(), and p().

Here is the call graph for this function:

to_array()

Fiche::to_array

(

)

turn a card into an array , then it can be saved thanks update or insert

See also

Fiche\insert , Fiche\update

Definition at line 356 of file fiche.class.php.

    {
        $a_return=[];
        if ( empty ($this->attribut)) {
            $this->load_attribute();
        }
        foreach ($this->attribut as $attr)
        {
            $a_return['av_text'.$attr->ad_id]=$attr->av_text;
        }
        $a_return['f_enable']=$this->get_f_enable();
        return $a_return;
    }

References $attr, get_f_enable(), and load_attribute().

Here is the call graph for this function:

update()

Fiche::update

(

$p_array = null

)

update a card with an array

Parameters

$p_array	(optional) is the array containing the data , if NULL then $_POST will be uses
$transation	if we want to manage the transaction in this function true for small insert and false for a larger loading, the BEGIN / COMMIT sql must be done into the caller av_textX where X is the ad_id \verb example av_text1=>'name' \endverb

Definition at line 590 of file fiche.class.php.

    {
        if ($p_array==null)
        {
            $p_array=$_POST;
        }
        $this->fiche_def = $this->cn->get_value("select fd_id from fiche where f_id=$1",[$this->id]);
        // unexistant category of cardf
        if ( empty($this->fiche_def)) {
            throw new Exception('FICHE.UPDATE524 category not found',EXC_INVALID);
        }
        if ( $this->cn->size()==0) {
            throw new Exception("FICHE.UPDATE01"._("Fiche n'existe pas"),EXC_INVALID);
        }
        
        
        // get the card properties for this card category
        $this->load_attribute();
        
        if ( empty ($this->attribut) ) {
            throw new Exception("FICHE.UPDATE02"._("Aucun attribut ")."($this->fiche_def)",EXC_INVALID);
        }
        // for each property set the attribut on the card
        foreach($this->attribut as $property) {
            $key='av_text'.$property->ad_id;
            if ( isset($p_array[$key])) {
                $this->set_attribute($property->ad_id, $p_array[$key]);
            }
        }
        if ( isset($p_array['f_enable'])) {
            $this->set_f_enable($p_array["f_enable"]);
        }else {
            $this->set_f_enable(1);
        }
        // save all
        Card_Property::update($this);
        $this->quick_code=$this->get_attribute(ATTR_DEF_QUICKCODE);
    }

References $_POST, $p_array, _, ATTR_DEF_QUICKCODE, cn, EXC_INVALID, get_attribute(), load_attribute(), set_attribute(), set_f_enable(), and Card_Property\update().

Referenced by save().

Here is the call graph for this function:

Field Documentation

$attribut

Fiche::$attribut

< $fiche_def fd_id

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

Referenced by Display(), and set_attribute().

$cn

Fiche::$cn

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

Referenced by from_qcode(), and test_me().

$display_mode

Fiche::$display_mode

private

how the card is displaid

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

Referenced by getDisplayMode().

$f_enable

Fiche::$f_enable

private

if card is enable (fiche.f_enable)

Definition at line 46 of file fiche.class.php.

Referenced by Display(), get_f_enable(), and set_f_enable().

$fiche_def

Fiche::$fiche_def

< $id fiche.f_id

Definition at line 41 of file fiche.class.php.

Referenced by blank(), Display(), insert(), and test_me().

$fiche_def_ref

Fiche::$fiche_def_ref

< $attribut array of Card_Property objects $fiche_def_ref Type

Definition at line 43 of file fiche.class.php.

Referenced by get_fiche_def_ref(), and set_fiche_def_ref().

$id

Fiche::$id

< $cn database connection

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

Referenced by get_bank_ledger(), get_id(), HtmlTableHeader(), and set_id().

$ledger_description

Fiche::$ledger_description

!< this variable is a mistake, it shouldn't exist, need code rewrite

Definition at line 51 of file fiche.class.php.

$ledger_name

Fiche::$ledger_name

Definition at line 50 of file fiche.class.php.

$quick_code

Fiche::$quick_code

< All the row from the ledgers quick_code of the card

Definition at line 45 of file fiche.class.php.

Referenced by get_by_qcode().

$row

Fiche::$row

Definition at line 44 of file fiche.class.php.

Referenced by belong_ledger(), Customer\get_by_account(), Supplier\get_by_account(), get_by_category(), and get_row_date().

$tot_cred

Fiche::$tot_cred

Definition at line 48 of file fiche.class.php.

Referenced by get_row_date(), get_row_result_deprecated(), HtmlTable(), and HtmlTableDetail().

$tot_deb

Fiche::$tot_deb

Definition at line 49 of file fiche.class.php.

Referenced by get_row_date(), get_row_result_deprecated(), HtmlTable(), and HtmlTableDetail().

---

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

• include/class/fiche.class.php