Acc_Report Class Reference

Class rapport Create, view, modify and parse report. More...

Collaboration diagram for Acc_Report:

Public Member Functions
	__construct ($p_cn, $p_id=-1)
	Constructor. More...
	create ()
	display a form for creating a new report by importing it or set manually More...
	delete ()
	exist ($p_id=0)
	check if a report exist More...
	export_csv ($p_file)
	write to a file the definition of a report More...
	get_form_definition ()
	get_list ()
	get a list from form_definition of all defined form More...
	get_name ()
	Return the report's name. More...
	get_row ($p_start, $p_end, $p_type_date)
	return all the row and parse formula from a report More...
	input_name ($name)
	load ()
	the fr_id MUST be set before calling More...
	make_array ()
	To make a SELECT button with the needed value, it is used by the SELECT widget. More...
	save ()
	save into form and form_def More...
	set_form_definition ($form_definition)
	upload ()
	upload a definition of a report and insert it into the database More...

Data Fields
	$nb
	$row

Private Attributes
	$form_definition

Detailed Description

Class rapport Create, view, modify and parse report.

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

Constructor & Destructor Documentation

__construct()

Acc_Report::__construct	(		$p_cn,
			$p_id = -1
	)

Constructor.

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

    {
        $this->form_definition=new Form_Definition_SQL($p_cn,$p_id);
    }

References $p_id.

Member Function Documentation

create()

Acc_Report::create

(

)

display a form for creating a new report by importing it or set manually

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

    {
        require_once NOALYSS_INCLUDE."/template/acc_report-create.php";
    }

delete()

Acc_Report::delete

(

)

Definition at line 133 of file acc_report.class.php.

    {
       $this->form_definition->delete();
    }

exist()

Acc_Report::exist

(

$p_id = 0

)

check if a report exist

Parameters

$p_id,optional,if

given check the report with this fr_id

Returns

return true if the report exist otherwise false

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

    {
        $c=$this->form_definition->getp("fr_id");
        if ( $p_id != 0 ) $c=$p_id;
        $ret=$this->form_definition->cn->exec_sql("select fr_label from form_definition where fr_id=$1",array($c));
        if (Database::num_row($ret) == 0) return false;
        return true;
    }

References $p_id, $ret, and DatabaseCore\num_row().

Here is the call graph for this function:

export_csv()

Acc_Report::export_csv

(

$p_file

)

write to a file the definition of a report

Parameters

p_file

is the file name (default php://output)

Definition at line 173 of file acc_report.class.php.

    {
        $this->load();
        
        fputcsv($p_file,array($this->form_definition->getp("fr_label")));
        $array=$this->form_definition->get_cn()->get_array("select fo_label,fo_pos,fo_formula 
                        from form_detail
                        where fo_fr_id=$1
                        order by fo_pos"
                ,array($this->form_definition->getp("fr_id"))
                );
        
        foreach ($array as $row)
        {
            fputcsv($p_file,array($row["fo_label"],
                                  $row["fo_pos"],
                                  $row["fo_formula"])
                   );
        }
 
    }

References $array, $row, and load().

Here is the call graph for this function:

get_form_definition()

Acc_Report::get_form_definition

(

)

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

    {
        return $this->form_definition;
    }

References $form_definition.

get_list()

Acc_Report::get_list

(

)

get a list from form_definition of all defined form

Returns

array of object rapport

Definition at line 143 of file acc_report.class.php.

    {
        $sql="select fr_id,fr_label from form_definition order by fr_label";
        $ret=$this->form_definition->cn->exec_sql($sql);
        if ( Database::num_row($ret) == 0 ) return array();
        $array=Database::fetch_all($ret);
        $obj=array();
        foreach ($array as $row)
        {
            $tmp=new Acc_Report($this->form_definition->cn);
            $tmp->id=$row['fr_id'];
            $tmp->name=$row['fr_label'];
            $obj[]=clone $tmp;
        }
        return $obj;
    }

References $array, $obj, $ret, $row, $sql, $tmp, DatabaseCore\fetch_all(), and DatabaseCore\num_row().

Here is the call graph for this function:

get_name()

Acc_Report::get_name

(

)

Return the report's name.

Definition at line 57 of file acc_report.class.php.

    {
        return $this->form_definition->getp("fr_label");
    }

get_row()

Acc_Report::get_row	(		$p_start,
			$p_end,
			$p_type_date
	)

return all the row and parse formula from a report

Parameters

$p_start	start periode
$p_end	end periode
$p_type_date	type of the date : periode (or 0) or calendar (or 1)

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

    {
        if (DEBUGNOALYSS > 1) {
            tracedebug("impress.debug.log",__FILE__."71.get_row({$p_start},{$p_end},{$p_type_date})");
        }
        $Res=$this->form_definition->cn->exec_sql("select fo_id ,
                                 fo_fr_id,
                                 fo_pos,
                                 fo_label,
                                 fo_formula,
                                 fr_label from form_detail
                                 inner join form_definition on fr_id=fo_fr_id
                                 where fr_id =$1
                                 order by fo_pos",array($this->form_definition->getp("fr_id")));
        $Max=Database::num_row($Res);
        if ($Max==0)
        {
            $this->row=0;
            return null;
        }
        $col=array();
        
        if ( $p_type_date == '0' || $p_type_date=="periode") {
            $type_date=0;
        } elseif ($p_type_date == '1' || $p_type_date=="calendar") {
            $type_date=1;
        } else {
            throw new Exception("ACR93:invalid type_date [ {$p_type_date} ] ");
        }
 
 
        for ($i=0;$i<$Max;$i++)
        {
            $l_line=Database::fetch_array($Res,$i);
            
            $col[]=Impress::parse_formula($this->form_definition->cn,
                                $l_line['fo_label'],
                                $l_line['fo_formula'],
                                $p_start,
                                $p_end,
                                true,
                                $type_date
                               );
 
        } //for ($i
        $this->row=$col;
        return $col;
    }

References $i, $Max, $p_end, $p_start, $Res, elseif, DatabaseCore\fetch_array(), DatabaseCore\num_row(), and Impress\parse_formula().

Here is the call graph for this function:

input_name()

Acc_Report::input_name

(

$name

)

Parameters

IText

$name

Definition at line 250 of file acc_report.class.php.

    {
        $name=new IText("fr_name",$name);
        $name->id="fr_name_inplace";
        
        $iName=new Inplace_Edit($name);
        $iName->set_callback("ajax_misc.php");
        $iName->add_json_param("op", "report_definition");
        $iName->add_json_param("sa", "change_name");
        $iName->add_json_param("gDossier", Dossier::id());
        $iName->add_json_param("p_id", $this->form_definition->getp("fr_id"));
        return $iName;
    }

References $name, and Dossier\id().

Here is the call graph for this function:

load()

Acc_Report::load

(

)

the fr_id MUST be set before calling

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

                   :void
    {
       $this->form_definition->load();
 
    }

Referenced by export_csv().

make_array()

Acc_Report::make_array

(

)

To make a SELECT button with the needed value, it is used by the SELECT widget.

Returns

string with html code

Definition at line 163 of file acc_report.class.php.

    {
        $sql=$this->form_definition->cn->make_array("select fr_id,fr_label from form_definition order by fr_label");
        return $sql;
    }

References $sql.

save()

Acc_Report::save

(

)

save into form and form_def

Definition at line 120 of file acc_report.class.php.

    {
        $this->form_definition->save();
    }

set_form_definition()

Acc_Report::set_form_definition

(

$form_definition

)

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

                                                         : void
    {
        $this->form_definition=$form_definition;
    }

References $form_definition.

upload()

Acc_Report::upload

(

)

upload a definition of a report and insert it into the database

Definition at line 197 of file acc_report.class.php.

    {
        if ( empty ($_FILES) ) return;
        if ( noalyss_strlentrim($_FILES['report']['tmp_name'])== 0 )
        {
            alert("Nom de fichier est vide");
            return;
        }
        $file_report=tempnam('tmp','file_report');
        if (  move_uploaded_file($_FILES['report']['tmp_name'],$file_report))
        {
            // File is uploaded now we can try to parse it
            $file=fopen($file_report,'r');
            $data=fgetcsv($file);
            if ( empty($data) ) return;
            $array=array();
            $cn=$this->form_definition->cn;
            $id=$this->form_definition->getp("fr_id");
            while($data=fgetcsv($file))
            {
                $obj=new Form_Detail_SQL($cn);
                $obj->setp("fo_label",$data[0]);
                $obj->setp("fo_pos",$data[1]);
                $obj->set("fo_formula",$data[2]);
                $obj->setp("fo_fr_id",$id);
                $obj->insert();
            }
        }
    }

References $array, $cn, $data, $file, $id, $obj, alert(), and noalyss_strlentrim().

Here is the call graph for this function:

Field Documentation

$form_definition

Acc_Report::$form_definition

private

form_definition_sql

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

Referenced by get_form_definition(), and set_form_definition().

$nb

Acc_Report::$nb

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

$row

Acc_Report::$row

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

Referenced by export_csv(), and get_list().

---

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

• include/class/acc_report.class.php