Impacc_Csv_Sale Class Reference

For Ledger of style SALE. More...

Inheritance diagram for Impacc_Csv_Sale:

Collaboration diagram for Impacc_Csv_Sale:

Public Member Functions
	adapt ($p_row)
	Transform a group of rows to an array and set $jr_date_paid useable by Acc_Ledger_Sold::insert. More...
	insert ($a_group, Acc_Ledger_Sold $p_ledger)
	Transfer operation with the status correct to the accountancy . More...
	transform ($ledger_id, $import_id)
	Works by id_group_code : all the rows with the same id_code_group belong to the same operation The operation will be written in the right ledger Only operation with a id_status = 0 can be transferred , -1 is in error and 1 means that it has already been transferred. More...
	check_nb_column ()
	record (Impacc_Csv $p_csv, Impacc_File $p_file)
	insert file into the table import_detail More...

Static Public Member Functions
static	check (Impacc_Import_detail_SQL $row, $p_format_date, $p_thousand, $p_decimal)
	Check if Data are valid for one row. More...

Private Attributes
	$jr_date_paid
	< date_paid will introduced after insert More...
	$suggest_pj

Detailed Description

For Ledger of style SALE.

Definition at line 22 of file class_impacc_csv_sale.php.

Member Function Documentation

Impacc_Csv_Sale::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 29 of file class_impacc_csv_sale.php.

References $array, $cn, $g_parameter, $nb_row, and Impacc_Tool\convert_tva().

Referenced by insert().

    {
        bcscale(4);
        $cn=Dossier::connect();
        
        // Get the code_group
        $code_group=$p_row;
        
        // get all rows from this group
        $t=new Impacc_Import_detail_SQL($cn);
        $all_row=$t->collect_objects("where import_id=$1 and id_code_group=$2",
                array($p_row['import_id'],$p_row['id_code_group']));
        
        // No block due to analytic
        global $g_parameter;
        $g_parameter->MY_ANALYTIC="N";
        // Save the date of payment
        $this->jr_date_paid=$all_row[0]->id_date_payment_conv;
        
        // Initialise the array
        $array=array();
        // Suppress payment
        $array['e_mp']=0;
         // The first row gives all the information , the others of the group
        // add services
        $array['e_client']=$all_row[0]->id_acc;
        $array['nb_item']=count($all_row);
        $array['e_comm']=$all_row[0]->id_label;
        // Must be transformed into DD.MM.YYYY
        $array['e_date']=$all_row[0]->id_date_conv; 
        $array['e_ech']=$all_row[0]->id_date_limit_conv; 
        $array['e_pj']=$all_row[0]->id_pj;
        
        $array['mt']=microtime();
        $array['jrn_type']='VEN';
        $nb_row=count($all_row);
        for ( $i=0;$i<$nb_row;$i++)
        {
            $array["e_march".$i]=$all_row[$i]->id_acc_second;
            $price=$all_row[$i]->id_amount_novat_conv;
            $quant=($all_row[$i]->id_quant_conv<>0)?$all_row[$i]->id_quant_conv:1;
            $pricetax=$all_row[$i]->id_amount_vat_conv;
            $price_unit=bcdiv($price,$quant);
            $array["e_march".$i."_price"]=$price_unit;
            $array["e_march".$i."_label"]=$all_row[$i]->id_label;
            $array["e_march".$i."_tva_id"]=Impacc_Tool::convert_tva($all_row[$i]->tva_code); // Find code
            $array["e_march".$i."_tva_amount"]=bcsub($pricetax,$price);
            $array["e_quant".$i]=$quant;
        }
        return $array;
    }

static Impacc_Csv_Sale_Purchase::check ( Impacc_Import_detail_SQL  $row,   $p_format_date,   $p_thousand,   $p_decimal  )

staticinherited

Check if Data are valid for one row.

Parameters

$row	is an Impacc_Import_detail_SQL object
$p_format_date	check for date_limit and date_payment
$p_thousand	separator for thousands
$p_decimal	separator for decimal

• Check VAT CODE
• Check Date payment
• Check Date limit
• Check Amount VAT
• Check Quantity

Definition at line 50 of file class_impacc_csv_sale_purchase.php.

References $date, Impacc_Verify\check_date(), Impacc_Verify\check_tva(), and Impacc_Tool\convert_amount().

Referenced by Impacc_CSV\check().

    {
        $and=($row->id_message=="")?"":",";
        //-----------------
        ///- Check VAT CODE
        //-----------------
        if (Impacc_Verify::check_tva($row->tva_code)==false)
        {
            $row->id_message=$and."CK_TVA_INVALID";
            $and=",";
        }
        //-----------------
        ///- Check Date payment
        //-----------------
        if ($row->id_date_payment!="")
        {
            $date=Impacc_Verify::check_date($row->id_date_payment,$p_format_date);
            if ($date==false)
            {
                $row->id_message=$and."CK_FORMAT_DATE";
                $and=",";
            } else {
                $row->id_date_payment_conv=$date;
            }
        }
        //-----------------
        ///- Check Date limit
        //-----------------
        if ($row->id_date_limit!="")
        {
            $date=Impacc_Verify::check_date($row->id_date_limit,$p_format_date);
            if ($date==false)
            {
                $row->id_message=$and."CK_FORMAT_DATE";
                $and=",";
            } else {
                $row->id_date_limit_conv=$date;
            }
        }

        //-----------------
        ///- Check Amount VAT
        //-----------------
        $row->id_amount_vat_conv=Impacc_Tool::convert_amount($row->id_amount_vat,
                        $p_thousand, $p_decimal);
        if (isNumber($row->id_amount_vat_conv)==0)
        {
            $and=($row->id_message=="")?"":",";
            $row->id_message.=$and."CK_INVALID_AMOUNT";
        }
        //-----------------
        ///- Check Quantity
        //-----------------
        $row->id_quant_conv=Impacc_Tool::convert_amount($row->id_quant,
                        $p_thousand, $p_decimal);
        if (isNumber($row->id_quant_conv)==0)
        {
            $row->id_message.=$and."CK_INVALID_AMOUNT";
            $and=",";
        }
    }

Impacc_Csv_Sale_Purchase::check_nb_column ( )

inherited

Definition at line 113 of file class_impacc_csv_sale_purchase.php.

    {
        throw new Exception("Not Yet Implemented");
    }

Impacc_Csv_Sale::insert	(		$a_group,
		Acc_Ledger_Sold	$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 83 of file class_impacc_csv_sale.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->insert($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']));
            $cn->exec_sql(" update public.jrn set jr_date_paid=to_date($1,'DD.MM.YYYY') where jr_id=$2",
                    array($this->jr_date_paid,$p_ledger->jr_id));
            
       }
       
    }

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

inherited

insert file into the table import_detail

Definition at line 121 of file class_impacc_csv_sale_purchase.php.

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

    {
        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'];
        if ($p_csv->detail->s_surround==""){
            $p_csv->detail->s_surround='"';
        }
        //---- For each row ---
        while ($row=fgetcsv($hFile, 0, $delimiter, $p_csv->detail->s_surround))
        {
            $nb_row=count($row);
            $insert=new Impacc_Import_detail_SQL($cn);
            $insert->import_id=$p_file->import_file->id;
            if ($nb_row<9)
            {
                $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_acc_second=$row[5];
                $insert->id_quant=$row[6];
                $insert->id_amount_novat=$row[7];
                $insert->tva_code=$row[8];
                $insert->id_amount_vat=$row[9];
                $date_limit=(isset($row[10]))?$row[10]:"";
                $insert->id_date_limit=$date_limit;
                $date_payment=(isset($row[11]))?$row[11]:"";
                $insert->id_date_payment=$date_payment;
                $insert->id_nb_row=0;
            }
            // insert row into table with status
            $insert->insert();
        }
    }

Impacc_Csv_Sale_Purchase::transform (   $ledger_id,   $import_id  )

inherited

Works by id_group_code : all the rows with the same id_code_group belong to the same operation The operation will be written in the right ledger Only operation with a id_status = 0 can be transferred , -1 is in error and 1 means that it has already been transferred.

Definition at line 38 of file class_impacc_csv_sale_purchase.php.

    {
        throw new Exception("Not Yet Implemented");
    }

Field Documentation

Impacc_Csv_Sale::$jr_date_paid

private

< date_paid will introduced after insert

Definition at line 25 of file class_impacc_csv_sale.php.

Impacc_Csv_Sale::$suggest_pj

private

Definition at line 26 of file class_impacc_csv_sale.php.

---

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

• import_account/include/class_impacc_csv_sale.php