Collaboration diagram for Import_Card:

Public Member Functions
	__construct ($p_file_id=-1, $p_format_id=-1)

	create_format_temp ($p_fiche_card)
	fill the CSV format object Importcard_Format_SQL with default values More...

	hidden ()
	for the form we have here all the hidden variables More...

	propose_format ()
	propose different possibilities to use your files More...

	new_import ()
	show the first screen, More...

	save_file ()
	Upload the file and record the default format and the file type $cn. More...

	get_post_format ()
	fill object Importcard_Format_SQL with the data send by post More...

	test_import ()
	Test the CSV file, show the choosed delimiter, the CSV parsed, and replace column header by attribute. More...

	record_import ()
	record all rows More...

	propose_save_template ()

	show_template ()

Static Public Member Functions
static	hidden ()
	for the form we have here all the hidden variables More...

static	new_import ()
	show the first screen, you must here enter the date format the file, the card category, More...

static	test_import ()
	Test the CSV file, show the choosed delimiter, the CSV parsed, and replace column header by attribute. More...

static	record_import ()
	record all rows More...

Private Attributes
	$record

	$format

Detailed Description

Definition at line 26 of file class_import_card.php.

Constructor & Destructor Documentation

Import_Card::__construct	(	$p_file_id = `-1`,
		$p_format_id = `-1`
	)

Definition at line 30 of file class_import_card.php.

References $cn.

     {
         global $cn;
         $this->record=new Impcard_File_Csv_SQL($cn, $p_file_id);
         $this->format=new Importcard_Format_SQL($cn, $p_format_id);
       
     }

Member Function Documentation

Import_Card::create_format_temp ( $p_fiche_card )

fill the CSV format object Importcard_Format_SQL with default values

Parameters

int $p_fiche_card if 0 then f_position is empty otherwise , f_position contains the attribute of this card category

Definition at line 43 of file class_import_card.php.

References $cn.

Referenced by save_file().

     {
         global $cn;
         $this->format->f_name='TEMP';
         $this->format->f_unicode_encoding='Y';
         $this->format->f_card_category=$p_fiche_card;
         $this->format->f_skiprow=0;
         $this->format->f_surround='"';
         $this->format->f_delimiter=";";
         $this->format->f_saved=0;
         if ($p_fiche_card == 0 ){
             $this->format->f_position="-1";
         } else {
              $a_attribute=$cn->make_list(
                 "select ad_id from jnt_fic_attr join attr_def using(ad_id) where fd_id=$1 
                     order by jnt_order ",
                     array($p_fiche_card));
                     $this->format->f_position=$a_attribute;
         }
     }

Import_Card::get_post_format ( )

fill object Importcard_Format_SQL with the data send by post

Definition at line 144 of file class_import_card.php.

References $_REQUEST, and $cn.

         {
             global $cn;
             $this->format->f_card_category= HtmlInput::default_value_request('rfichedef',0);
            
             $this->format->f_skiprow=HtmlInput::default_value_request("skip_row",  0);
             $this->format->f_delimiter = HtmlInput::default_value_request("rdelimiter", $this->format->f_delimiter );
             $this->format->f_surround = HtmlInput::default_value_request("rsurround",  $this->format->f_surround);
             /* If not set , give the default of card category */
             $head_col = HtmlInput::default_value_request("head_col", $this->format->f_position);
             
             // If there is no column head set , then load the default order of the card attribute
             if ( is_array($head_col) ) {
                 $this->format->f_position = join($head_col,",");
             } else {
                 $a_attribute=$cn->make_list(
                 "select ad_id from jnt_fic_attr join attr_def using(ad_id) where fd_id=$1 
                     order by jnt_order ",
                     array($this->format->f_card_category));
                     $this->format->f_position=$a_attribute;
             }
             $this->format->f_unicode_encoding= (isset($_REQUEST['encodage'])) ? 'Y' : 'N';
             $this->format->save();
         }

static Import_Card::hidden ( )

static

for the form we have here all the hidden variables

Returns: html string with the hidden dossier, plugin_code,action(sb)

Definition at line 34 of file class_import_card.php.

References $r.

     {
         $r = HtmlInput::extension() . Dossier::hidden();
         return $r;
     }

Import_Card::hidden ( )

for the form we have here all the hidden variables

Returns: html string with the hidden dossier, plugin_code,action(sa)

Definition at line 67 of file class_import_card.php.

References $r.

Referenced by new_import(), propose_format(), and save_file().

     {
         $r = HtmlInput::extension() . Dossier::hidden();
                 $r.= HtmlInput::hidden("record", $this->record->id);
                 $r.= HtmlInput::hidden("format", $this->format->id);
         return $r;
     }

static Import_Card::new_import ( )

static

show the first screen, you must here enter the date format the file, the card category,

Returns: html string

Definition at line 45 of file class_import_card.php.

References $cn, $file, $hidden, and $r.

     {
         global $cn;
         ob_start();
         $hidden = self::hidden() . HtmlInput::hidden('sb', 'test');
         $delimiter = new IText('rdelimiter');
         $delimiter->size = 1;
         $delimiter->value = ',';
 
         $fd = new ISelect('rfichedef');
         $fd->value = $cn->make_array('select fd_id,fd_label from fiche_def order by 2');
         $file = new IFile('csv_file');
         $encodage = new ICheckBox('encodage');
         $encodage->selected = true;
         require_once('template/input_file.php');
         $r = ob_get_contents();
         ob_end_clean();
         echo $r;
     }

Import_Card::new_import ( )

show the first screen,

Returns: html string

Definition at line 103 of file class_import_card.php.

References $cn, $file, $hidden, $r, and hidden().

     {
         global $cn;
         ob_start();
         $hidden = $this->hidden() . HtmlInput::hidden('sa', 'import');
         $fd = new ISelect('rfichedef');
                  $fd->value = $cn->make_array('select fd_id,fd_label from fiche_def order by 2');
         $file = new IFile('csv_file');
         
         require_once('template/input_file.php');
         $r = ob_get_contents();
         ob_end_clean();
         echo $r;
     }

Import_Card::propose_format ( )

propose different possibilities to use your files

Definition at line 77 of file class_import_card.php.

References $cn, $hidden, $r, $skip_row, and hidden().

         {
             global $cn;
             ob_start();
             $hidden = $this->hidden() . HtmlInput::hidden('sa', 'test');
             $delimiter = new IText('rdelimiter');
             $delimiter->size = 1;
             $delimiter->value = $this->format->f_delimiter;
             $fd = new ISelect('rfichedef');
             $fd->value = $cn->make_array('select fd_id,fd_label from fiche_def order by 2');
             $fd->selected=$this->format->f_card_category;
             $encodage = new ICheckBox('encodage');
             $encodage->selected = ($this->format->f_unicode_encoding=="Y")?TRUE:FALSE;
             $skip_row=new INum('skip_row');
             $skip_row->value=$this->format->f_skiprow;
             $select_template = new ISelect("select_template");
             $select_template->value=$cn->make_array("select id,f_name from importcard.format order by 2");
             require_once('template/input_format.php');
             $r = ob_get_contents();
             ob_end_clean();
             echo $r;
         }

Import_Card::propose_save_template ( )

Definition at line 373 of file class_import_card.php.

         {
             require_once __DIR__."/template/template_save.php";
         }

static Import_Card::record_import ( )

static

record all rows

array
'plugin_code' => string 'IMPCARD' (length=7)
'gDossier' => string '30' (length=2)
'sb' => string 'record' (length=6)
'rfichedef' => string '17' (length=2)
'rdelimiter' => string ',' (length=1)
'encodage' => string '' (length=0)
'record_import' => string 'Valider' (length=7)
'head_col' =>
array
0 => string '15' (length=2)
1 => string '14' (length=2)
2 => string '-1' (length=2)
3 => string '-1' (length=2)
4 => string '-1' (length=2)
5 => string '-1' (length=2)

Definition at line 112 of file class_import_card.php.

References $array, $cn, $fiche, $g_failed, $g_succeed, $header, $name, $row, and $row_count.

     {
 
         global $cn, $g_failed, $g_succeed;
         extract($_POST);
         $fd = fopen($filename, 'r');
         /*
          * Check the column
          */
         $valid_col = 0;
         $valid_name = 0;
         $duplicate = 0;
         $valid_qcode = 0;
         $valid_accounting = 0;
         for ($i = 0; $i < count($head_col); $i++)
         {
             if ($head_col[$i] != -1)
                 $valid_col++;
             if ($head_col[$i] == 1)
                 $valid_name = 1;
             if ($head_col[$i] == ATTR_DEF_QUICKCODE)
                 $valid_qcode = 1;
             if ($head_col[$i] == ATTR_DEF_ACCOUNT)
                 $valid_accounting = 1;
 
             for ($e = $i + 1; $e < count($head_col); $e++)
                 if ($head_col[$i] == $head_col[$e] && $head_col[$e] != -1)
                     $duplicate++;
         }
 
         if ($valid_col == 0)
         {
             alert("Aucune colonne n'est définie");
             return -1;
         }
         if ($valid_name == 0)
         {
             alert("Les fiches doivent avoir au minimum un nom");
             return -1;
         }
         if ($duplicate != 0)
         {
             alert('Vous avez défini plusieurs fois la même colonne');
             return -1;
         }
         if ($valid_qcode == 0)
         {
             alert("Vous devez donner la colonne quick_code");
             return 1;
         }
         /*
          * read the file and record card
          */
 
         $row_count = 0;
 
         echo '<table>';
 
         ob_start();
         while (($row = fgetcsv($fd, 0, $_POST['rdelimiter'], $_POST['rsurround'])) !== false)
         {
             $fiche = new Fiche($cn);
             $array = array();
             $row_count++;
             echo '<tr style="border:solid 1px black">';
             echo td($row_count);
             $count_col = count($row);
             $col_count = 0;
             for ($i = 0; $i < $count_col; $i++)
             {
                 if ($head_col[$i] == -1)
                     continue;
 
                 $header[$col_count] = $head_col[$i];
                 $col_count++;
 
                 echo td($row[$i]);
                 $attr = sprintf('av_text%d', $head_col[$i]);
                 $array[$attr] = $row[$i];
             }
 
             try
             {
                 // If quick_code already exists then update otherwise insert
                 $quick_code= sprintf('av_text%d',ATTR_DEF_QUICKCODE);
                 if ( $fiche->get_by_qcode($array[$quick_code],false)==0 )
                 {
                                     // accounting cannot change
                                         $attr = sprintf('av_text%d', ATTR_DEF_ACCOUNT);
                                         $array[$attr] = $fiche->strAttribut(ATTR_DEF_ACCOUNT);
                     $fiche->update($array);
                 }
                 else
                 {
                                    /*
                                     * Force the creating of an accounting
                                     */
                                     if ($valid_accounting == 0)
                                     {
                                             $attr = sprintf('av_text%d', ATTR_DEF_ACCOUNT);
                                             $array[$attr] = '';
                                     }
                     $fiche->insert($rfichedef, $array);
                 }
                 echo td($g_succeed);
             }
             catch (Exception $e)
             {
                 echo td($g_failed);
                 echo td($e->getMessage());
             }
             echo '</tr>';
         }
         $table_content = ob_get_contents();
         ob_end_clean();
         echo '<tr>';
         echo th('');
         for ($e = 0; $e < count($header); $e++)
         {
             $name = $cn->get_value('select ad_text from attr_def where ad_id=$1', array($header[$e]));
             echo th($name);
         }
         echo '</tr>';
         echo $table_content;
 
         echo '</table>';
         $name = $cn->get_value('select fd_label from fiche_def where fd_id=$1', array($rfichedef));
         $cn->get_value('select comptaproc.fiche_attribut_synchro($1)', array($rfichedef));
         echo '<span class="notice">';
         echo $row_count . ' fiches sont insérées dans la catégorie ' . $name;
         echo '</span>';
         return 0;
     }

Import_Card::record_import ( )

record all rows

Parameters

@return

Note

See Also: array

'plugin_code' => string 'IMPCARD' (length=7)

'gDossier' => string '30' (length=2)

'sa' => string 'record' (length=6)

'rfichedef' => string '17' (length=2)

'rdelimiter' => string ',' (length=1)

'encodage' => string '' (length=0)

'record_import' => string 'Valider' (length=7)

'head_col' =>

array

0 => string '15' (length=2)

1 => string '14' (length=2)

2 => string '-1' (length=2)

3 => string '-1' (length=2)

4 => string '-1' (length=2)

5 => string '-1' (length=2)

if qcode already exists then update otherwise insert

Definition at line 225 of file class_import_card.php.

References $array, $cn, $fiche, $g_failed, $g_succeed, $header, $msg, $name, $row, $row_count, and $skip_row.

     {
         global $cn, $g_failed, $g_succeed;
         $fd = fopen($this->record->file_name, 'r');
                 if ($fd == FALSE) 
                 {
                     throw new Exception(sprintf(_("Ne peut ouvrir le fichier %s"),
                             $this->record->file_name));
                 }
         /*
          * Check the column
          */
         $valid_col = 0;
         $valid_name = 0;
         $duplicate = 0;
         $valid_qcode = 0;
         $valid_accounting = 0;
                 // Data from DB
                 $head_col = explode(",",$this->format->f_position);
                 
                 
         for ($i = 0; $i < count($head_col); $i++)
         {
             if ($head_col[$i] != -1)
                 $valid_col++;
             if ($head_col[$i] == 1)
                 $valid_name = 1;
             if ($head_col[$i] == ATTR_DEF_QUICKCODE)
                 $valid_qcode = 1;
             if ($head_col[$i] == ATTR_DEF_ACCOUNT)
                 $valid_accounting = 1;
             for ($e = $i + 1; $e < count($head_col); $e++)
                 if ($head_col[$i] == $head_col[$e] && $head_col[$e] != -1)
                     $duplicate++;
         }
         if ($valid_col == 0)
         {
             alert(_("Aucune colonne n'est définie"));
             return -1;
         }
         if ($valid_name == 0)
         {
             alert(_("Les fiches doivent avoir au minimum un nom"));
             return -1;
         }
         if ($duplicate != 0)
         {
             alert(_('Vous avez défini plusieurs fois la même colonne'));
             return -1;
         }
         /*
          * read the file and record card
          */
         $row_count = 0;
                 $skip_row=$this->format->f_skiprow;
 
         echo '<table>';
         ob_start();
         while (($row = fgetcsv($fd, 0, $this->format->f_delimiter, $this->format->f_surround)) !== false)
         {
                    
             $row_count++;
                         if ( $skip_row >= $row_count ) continue;
                         $qcode="";
             $fiche = new Fiche($cn);
             $array = array();
             echo '<tr style="border:solid 1px black">';
             echo td($row_count);
             $count_col = count($row);
             $col_count = 0;
             for ($i = 0; $i < $count_col; $i++)
             {
                 if ($head_col[$i] == -1)
                     continue;
                 $header[$col_count] = $head_col[$i];
                 $col_count++;
                 echo td($row[$i]);
                 $attr = sprintf('av_text%d', $head_col[$i]);
                 $array[$attr] = $row[$i];
                                 if ( $head_col [$i] == ATTR_DEF_QUICKCODE) {
                                     $qcode=$row[$i];
                                 }
             }
             /*
              * If no quick code is given we compute it ourself
              */
             if ($valid_qcode == 0)
             {
                 $attr = sprintf('av_text%d', ATTR_DEF_QUICKCODE);
                 $array[$attr] = '';
                                 
             }
             /*
              * Force the creating of an accounting
              */
             if ($valid_accounting == 0)
             {
                 $attr = sprintf('av_text%d', ATTR_DEF_ACCOUNT);
                 $array[$attr] = '';
             }
             try
             {
                             /**
                              * if qcode already exists then update otherwise insert
                              */
                             $msg=(_('Ajout'));
                             if ($valid_qcode == 0 || trim($qcode) == "")
                             {
                 $fiche->insert($this->format->f_card_category, $array);
                             } else {
                                 // Retrieve the card with the qcode
                                 $fiche->get_by_qcode($qcode,false);
                                 // if qcode is found update otherwise insert
                                 if ( $fiche->id !=0) {
                                     $fiche->update($array);
                                     $msg=(_('Mise à jour'));
                                 } else {
                                     $fiche->insert($this->format->f_card_category,$array);
                                 }
                             }   
                 echo td($g_succeed." ".$msg);
             }
             catch (Exception $e)
             {
                 echo td($g_failed);
                 echo td($e->getMessage());
             }
             echo '</tr>';
         }
         $table_content = ob_get_contents();
         ob_end_clean();
         echo '<tr>';
         echo th('');
         for ($e = 0; $e < count($header); $e++)
         {
             $name = $cn->get_value('select ad_text from attr_def where ad_id=$1', array($header[$e]));
             echo th($name);
         }
         echo '</tr>';
         echo $table_content;
         echo '</table>';
         $name = $cn->get_value('select fd_label from fiche_def where fd_id=$1', array($this->format->f_card_category));
         $cn->get_value('select comptaproc.fiche_attribut_synchro($1)', array($this->format->f_card_category));
         echo '<span class="notice">';
         printf (_('%d fiches sont insérées dans la catégorie %s') ,$row_count , $name);
         echo '</span>';
         return 0;
     }

Import_Card::save_file ( )

Upload the file and record the default format and the file type $cn.

Returns: type

Definition at line 122 of file class_import_card.php.

References $cn, $hidden, create_format_temp(), and hidden().

         {
             global $cn;
             if (trim($_FILES['csv_file']['name']) == '')
             {
                     alert('Pas de fichier donné');
                     return -1;
             }
             $this->record->file_name = tempnam($_ENV['TMP'], 'upload_');
             move_uploaded_file($_FILES["csv_file"]["tmp_name"], $this->record->file_name );
             $this->record->save();
             $file_def=HtmlInput::default_value_request('rfichedef', 0);
             $this->create_format_temp($file_def);
             $this->format->f_card_category=$file_def;
             $this->format->save();
             $hidden = $this->hidden() . HtmlInput::hidden('sa', 'record');
 
             
         }

Import_Card::show_template ( )

Definition at line 377 of file class_import_card.php.

References $cn.

         {
             global $cn;
             $select_template=new ISelect("template_id");
             $select_template->value=$cn->make_array("select id,f_name from importcard.format where f_saved=1 order by f_name");
             require_once __DIR__."/template/template_show.php";
             
         }

static Import_Card::test_import ( )

static

Test the CSV file, show the choosed delimiter, the CSV parsed, and replace column header by attribute.

Returns: 0 ok, -1 error

Definition at line 70 of file class_import_card.php.

References $_REQUEST, $cn, $hidden, and $skip_row.

     {
         global $cn;
         $hidden = self::hidden() . HtmlInput::hidden('sb', 'record');
 
         if (trim($_FILES['csv_file']['name']) == '')
         {
             alert('Pas de fichier donné');
             return -1;
         }
         $filename = tempnam($_ENV['TMP'], 'upload_');
         move_uploaded_file($_FILES["csv_file"]["tmp_name"], $filename);
 
         $file_cat = $cn->get_value('select fd_label from fiche_def where fd_id=$1', array($_POST['rfichedef']));
         $encoding = (isset($_REQUEST['encodage'])) ? 'Unicode' : 'latin1';
                 $skip_row=HtmlInput::default_value_request("skip_row", 0);
         require_once('template/test_file.php');
         return 0;
     }

Import_Card::test_import ( )

Test the CSV file, show the choosed delimiter, the CSV parsed, and replace column header by attribute.

Returns: 0 ok, -1 error

Definition at line 174 of file class_import_card.php.

References $cn, $header, $skip_row, and $sql.

     {
             global $cn;
             $filename=$this->record->file_name;
             $delimiter=$this->format->f_delimiter;
             $surround=$this->format->f_surround;
             $skip_row=$this->format->f_skiprow;
             $fiche_def=$this->format->f_card_category;
             // Column Header are a select
             $a_header=explode(",", $this->format->f_position);
             $sql=sprintf('select ad_id,ad_text from jnt_fic_attr join attr_def using(ad_id) where fd_id=%d order by ad_text ',$fiche_def);
             $header=new ISelect('head_col[]');
             $header->value=$cn->make_array($sql);
             $header->value[]=array('value'=>-1,'label'=>'-- Non Utilisé --');
             $header->selected=-1;
             
             
             $a_attribute=$cn->get_array(
                 "select ad_id,ad_text from jnt_fic_attr join attr_def using(ad_id) where fd_id=$1 order by jnt_order ",
                 array($fiche_def)
                 );
             $t1_valid_header=$cn->make_list("select ad_id from jnt_fic_attr join attr_def using(ad_id) where fd_id=$1 ",array($fiche_def));
             $a_valid_header=explode(",", $t1_valid_header);
             require_once('template/test_file.php');
             return 0;
     }

Field Documentation

Import_Card::$format

private

Definition at line 29 of file class_import_card.php.

Import_Card::$record

private

Definition at line 28 of file class_import_card.php.

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

import_card/include/class_import_card.php

Public Member Functions

Static Public Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Field Documentation