Impacc_File Class Reference

Collaboration diagram for Impacc_File:

Public Member Functions
	save_file ()
	Save the uploaded file and CSV setting if it is CSV import. More...
	load ($p_import_id)
	record ()
	Load the file in a temporary table. More...
	input_file ()
	Display the parameters and the file to upload. More...
	check ()
	Check the rows of the imported file. More...
	result ()
	Display the rows of the imported file and a status for each row. More...
	transfer ()
	Transfer to accountancy. More...
	result_transfer ()
	Show the result of the file import. More...
	display_list ()
	delete ($id)
	Delete a row in impacc.import_file. More...

Data Fields
	$format
	$filename
	$import_file
	Impacc_Import_file_SQL $impid. More...

Static Public Attributes
static	$aformat =array(1=>"CSV")

Detailed Description

Definition at line 34 of file class_impacc_file.php.

Member Function Documentation

Impacc_File::check

(

)

Check the rows of the imported file.

Definition at line 133 of file class_impacc_file.php.

    {
        if ($this->import_file->i_type=='CSV')
        {
            $operation=new Impacc_Operation();
            $operation->check($this);
        }
    }

Impacc_File::delete

(

$id

)

Delete a row in impacc.import_file.

Definition at line 200 of file class_impacc_file.php.

References $cn, and $id.

    {
        $cn=Dossier::connect();
        $cn->exec_sql("delete from impacc.import_file where id=$1",array($id));
        
    }

Impacc_File::display_list

(

)

Definition at line 180 of file class_impacc_file.php.

References $array, and $cn.

    {
        $cn=Dossier::connect();
        $array=$cn->get_array(
                "
                 select   
                 id,
                 i_filename,
                 i_type,
                 to_char(i_date_transfer,'DD.MM.YY HH:MI') as stransfer,
                 to_char(i_date_import,'DD.MM.YY HH:MI') as simport,
                 to_char(i_date_transfer,'YYYYMMDDHHMI') as sorder_transfer
                 from 
                 impacc.import_file
                 order by i_date_transfer desc
                "
                );
        require_once DIR_IMPORT_ACCOUNT."/template/history_file.php";
    }

Impacc_File::input_file

(

)

Display the parameters and the file to upload.

Definition at line 118 of file class_impacc_file.php.

References $file, and $format.

    {

        $file=new IFile("file_operation");
        $format=new ISelect("format");
        $format->id="format_sel";
        $format->value=array(
            array("value"=>0, "label"=>"-"),
            array("value"=>1, "label"=>"CSV")
        );
        $format->javascript="onchange=\"ctl_display()\"";
        require_once DIR_IMPORT_ACCOUNT."/template/input_file.php";
    }

Impacc_File::load

(

$p_import_id

)

Definition at line 100 of file class_impacc_file.php.

References $cn.

    {
        $cn=Dossier::connect();
        $this->import_file=new Impacc_Import_file_SQL($cn,$p_import_id);
        
    }

Impacc_File::record

(

)

Load the file in a temporary table.

Definition at line 107 of file class_impacc_file.php.

References $cn.

    {
        $operation=new Impacc_Operation();
        $operation->record_file($this);
        $cn=Dossier::connect();
        $cn->exec_sql("update impacc.import_file set i_date_transfer=now() where id=$1",
                array($this->import_file->id));
    }

Impacc_File::result

(

)

Display the rows of the imported file and a status for each row.

Definition at line 143 of file class_impacc_file.php.

    {
        if ($this->import_file->i_type=='CSV')
        {
            $operation=new Impacc_CSV();
            $operation->result($this);
        }
    }

Impacc_File::result_transfer

(

)

Show the result of the file import.

Definition at line 163 of file class_impacc_file.php.

References $cn, and $ledger.

    {
        if ($this->import_file->i_type == 'CSV')
        {
            $cn=Dossier::connect();
            // Show first the successfully transfered record
            // Show the failed
            $operation=new Impacc_CSV();
            $operation->load_import($this->import_file->id);
            // Show the target ledger
            $ledger=new Acc_Ledger($cn,$operation->detail->jrn_def_id);
            echo "<h1>";
            printf(_("Importation dans le journal %s"),$ledger->get_name());
            echo "</h1>";
            $operation->result($this);
        }
    }

Impacc_File::save_file

(

)

Save the uploaded file and CSV setting if it is CSV import.

Definition at line 50 of file class_impacc_file.php.

References $cn, and $format.

    {
        if (trim($_FILES['file_operation']['name'])=='')
        {
            alert(_('Pas de fichier donné'));
            return -1;
        }
        $format=HtmlInput::default_value_post("format", -1);

        if (!isset(self::$aformat[$format]))
        {
            alert(_("Format inconnu"));
            return -1;
        }
        $this->format=self::$aformat[$format];
        $this->filename=tempnam($_ENV['TMP'], 'upload_');
        if (!move_uploaded_file($_FILES["file_operation"]["tmp_name"],
                        $this->filename))
        {
            throw new Exception(_("Fichier non sauvé"), 1);
        }
        $cn=Dossier::connect();
        $imp=new Impacc_Import_file_SQL($cn);
        $imp->setp('i_tmpname', $this->filename);
        $imp->setp('i_filename', $_FILES['file_operation']['name']);
        $imp->setp("i_type", self::$aformat[$format]);
        $imp->insert();
        $cn->exec_sql("update impacc.import_file set i_date_transfer=now() where id=$1",
                array($imp->id));
        $this->import_file=$imp;
        $this->impid=$imp->getp("id");

        // For CSV only
        if ($imp->i_type=="CSV")
        {
            try
            {
                $csv=new Impacc_CSV();
                $csv->set_import($this->impid);
                $csv->set_setting();
                $csv->check_setting();
                $csv->save_setting();
            }
            catch (Exception $ex)
            {
                error_log($ex->getTraceAsString());
                echo _("Format invalide")," : ",$ex->getMessage();
            }
        }
    }

Impacc_File::transfer

(

)

Transfer to accountancy.

Definition at line 152 of file class_impacc_file.php.

    {
        if ($this->import_file->i_type=='CSV')
        {
            $operation=new Impacc_CSV();
            $operation->load_import($this->impid);
            $operation->transfer();
        }
    }

Field Documentation

Impacc_File::$aformat =array(1=>"CSV")

static

Definition at line 43 of file class_impacc_file.php.

Impacc_File::$filename

Definition at line 45 of file class_impacc_file.php.

Impacc_File::$format

Definition at line 44 of file class_impacc_file.php.

Referenced by input_file(), and save_file().

Impacc_File::$import_file

Impacc_Import_file_SQL $impid.

Definition at line 46 of file class_impacc_file.php.

---

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

• import_account/include/class_impacc_file.php