Impacc_Csv_Misc_Operation Class Reference

Collaboration diagram for Impacc_Csv_Misc_Operation:

Public Member Functions
	record (Impacc_Csv $p_csv, Impacc_File $p_file)
	insert file into the table import_detail More...
	check (Impacc_Import_detail_SQL $row)
	Check if Data are valid for one row. More...
	adapt ($p_row)
	Transform a group of rows to an array and set $jr_date_paid. More...
	insert ($a_group, Acc_Ledger $p_ledger)
	Transfer operation with the status correct to the accountancy . More...

Detailed Description

Definition at line 28 of file class_impacc_csv_misc_operation.php.

Member Function Documentation

Impacc_Csv_Misc_Operation::adapt

(

$p_row

)

Transform a group of rows to an array and set $jr_date_paid.

useable by Acc_Ledger_Sold::insert

Definition at line 76 of file class_impacc_csv_misc_operation.php.

References $array, $cn, $g_parameter, and $nb_row.

Referenced by insert().

    {
        bcscale(4);
        $cn=Dossier::connect();
        
        // Get the code_group
        $code_group=$p_row;
        
        // get all rows from this group
        $sql_row= "
            select id,
                id_amount_novat_conv, 
                id_date_conv,
                (select f_id from fiche_detail where ad_value=id_acc and ad_id=23) as f_id , 
                id_acc ,
                id_label,
                id_debit,
                id_acc,
                id_pj
            from 
                impacc.import_detail
            where
                import_id=$1 
                and id_code_group=$2";
        $all_row=$cn->get_array($sql_row,
                array($p_row['import_id'],$p_row['id_code_group']));
        // No block due to analytic
        global $g_parameter;
        $g_parameter->MY_ANALYTIC="N";
        
        // Initialise the array
        $array=array();
         // The first row gives all the information , the others of the group
        // add services
        $array['nb_item']=count($all_row);
        $array['e_comm']=$all_row[0]['id_label'];
        $array['desc']=$all_row[0]['id_label'];
        $array['jrn_concerned']="";
        // Must be transformed into DD.MM.YYYY
        $array['e_pj']=$all_row[0]['id_pj'];
        $array['e_date']=$all_row[0]['id_date_conv'];
        
        $array['mt']=microtime();
        $array['jrn_type']='ODS';
        $nb_row=count($all_row);
        for ( $i=0;$i<$nb_row;$i++)
        {
            $price=$all_row[$i]['id_amount_novat_conv'];
            if ( $all_row[$i]['id_debit'] == "D") {
                $array["ck".$i]="";
            }
            if ($all_row[$i]['f_id']=="")
            {
                $array["poste".$i]=$all_row[$i]["id_acc"];
            }else {
                $array["qc_".$i]=$all_row[$i]["id_acc"];
            }
            $array["amount".$i]=$price;
            $array["ld".$i]=$all_row[$i]["id_label"];
        }
        return $array;
    }

Impacc_Csv_Misc_Operation::check

(

Impacc_Import_detail_SQL

$row

)

Check if Data are valid for one row.

Parameters

$row	is an Impacc_Import_detail_SQL object

Definition at line 70 of file class_impacc_csv_misc_operation.php.

    {
        
    }

Impacc_Csv_Misc_Operation::insert	(		$a_group,
		Acc_Ledger	$p_ledger
	)

Transfer operation with the status correct to the accountancy .

Change the status of the row (id_status to 1) after because it can transferred several rows in one operation

Definition at line 141 of file class_impacc_csv_misc_operation.php.

References $array, $cn, and adapt().

    {
       $cn=Dossier::connect();
       $nb_group=count($a_group);
       for ( $i=0;$i< $nb_group;$i++)
       {
            $array=$this->adapt($a_group[$i]);
            
            //Complete the array
            $array["p_jrn"]=$p_ledger->id;
            
            //Receipt
            if (trim($array['e_pj'])=="") $array["e_pj"]=$p_ledger->guess_pj();
            $array['e_pj_suggest']=$p_ledger->guess_pj();
            
            // Insert
            $p_ledger->save($array);
            
           // Update this group , status = 2  , jr_id
           // and date_payment
            $cn->exec_sql("update impacc.import_detail set jr_id=$1 , id_status=2 where id_code_group=$2",
                    array($p_ledger->jr_id,$a_group[$i]['id_code_group']));
            
       }
       
    }

Impacc_Csv_Misc_Operation::record	(	Impacc_Csv	$p_csv,
		Impacc_File	$p_file
	)

insert file into the table import_detail

Parameters

Impacc_Csv	$p_csv	CSV setting
Impacc_File	$p_file	File information

Definition at line 35 of file class_impacc_csv_misc_operation.php.

References $aseparator, $cn, $error, $nb_row, $row, and while.

    {
         global $aseparator;
        // Open the CSV file
        $hFile=fopen($p_file->import_file->i_tmpname, "r");
        $error=0;
        $cn=Dossier::connect();
        $delimiter=$aseparator[$p_csv->detail->s_delimiter-1]['label'];
        $surround=($p_csv->detail->s_surround=="")?'"':$p_csv->detail->s_surround;
        //---- For each row ---
        while ($row=fgetcsv($hFile, 0, $delimiter, $surround))
        {
            $insert=new Impacc_Import_detail_SQL($cn);
            $insert->import_id=$p_file->import_file->id;
            $nb_row=count($row);
            if ($nb_row<6)
            {
                 $insert->id_status=-1;
                $insert->id_message=join($row,$delimiter);
            }
            else
            {
                $insert->id_date=$row[0];
                $insert->id_code_group=$row[1];
                $insert->id_acc=$row[2];
                $insert->id_pj=$row[3];
                $insert->id_label=$row[4];
                $insert->id_amount_novat=$row[5];
                $insert->id_debit=$row[6];
            }
            $insert->insert();
        }
    }

---

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

• import_account/include/class_impacc_csv_misc_operation.php