RenameFicher et insert ds tbleVariable

gistfile1.txt

<?php
$path=$modx->getOption('base_path').'assets/templates/fichiers_agdl/artistes';

$Discopraphie=array();
$NomArtistePourPagetitle=array();
$idpagecreate=array(); 
$Photo=array();
  $dir=array();
$filesTT = scandir($path);

  foreach($filesTT as $fileee) {
global $NomArtistePourPagetitle,$idpagecreate; 
  if(is_dir("$path/$fileee") && $fileee !="." && $fileee !=".." ) {
      
                $memofile=str_replace("_"," ",$fileee); 
                $memofile=str_replace("-"," ",$memofile);
    $memofile=trim(ucwords($memofile));
      $NomArtistePourPagetitle[]=$memofile;
        $dirs[] = $fileee;

    $doc = $modx->newObject('modResource');
    $creationaliaspage=$doc->cleanAlias($memofile);
    $doc->set('createdby', $modx->user->get('id'));
    $doc->set('published', '1');
    $doc->set('pagetitle',$memofile);
    $doc->set('parent', '2');
    $doc->set('template', '2');
    $doc->set('alias',$creationaliaspage);
    $doc->save();
          $idNewInsert=$modx->lastInsertId();
    $idpagecreate[]=$idNewInsert;
    //    echo $idNewInsert;
    }
}
  //  return "ok";
  $nombreDossierTotal=$dirs;
$nbrFichier2=array();
  foreach($nombreDossierTotal as $i => $nomDossier) {
    global $Discopraphie,$Photo;    
    $ignore = array('cgi-bin', '.', '..','.DS_Store');
    $path2=$modx->getOption('base_path').'assets/templates/fichiers_agdl/artistes/'.$nomDossier.'';
      $filesTTT = scandir($path2);
      foreach($filesTTT as $fileee) {
        if  (!in_array( $fileee, $ignore ) ) {
         $ext = strrchr($fileee,'.');
          $igonreExtension=array('.xlsx','.xls','.doc','.docx');
            if (!in_array($ext,$igonreExtension)) {
                $memofile=$fileee;   
                $path_parts = pathinfo($memofile);
                $memofile = $path_parts['filename'];
                        $memofile=strtr($memofile,"ÀÁÂÃÄÅàáâãäåÒÓÔÕÖØòóôõöøÈÉÊËèéêëÇçÌÍÎÏìíîïÙÚÛÜùúûüÿÑñ","aaaaaaaaaaaaooooooooooooeeeeeeeecciiiiiiiiuuuuuuuuynn");  
                $memofile=str_replace(" ","_",$memofile); 
                $memofile=str_replace("Œ","OE",$memofile);
                $memofile=str_replace("œ","oe",$memofile);
                $memofile=str_replace("ç“","c",$memofile);
                $memofile=str_replace("'","-",$memofile);
                $memofile=str_replace("&","-",$memofile);
                $memofile=str_replace("+","",$memofile);
                if (substr($memofile, 0, 12) == "Discographie") {
                  $annee = substr($memofile, -4, 4);
                  $titreDisco=explode('Discographie_',$memofile);
                  $titreDisco=str_replace("_"," ",$titreDisco[1]);
                  $titreDisco=trim(substr($titreDisco,0,-4));
                  $Discopraphie[]=array(
                    'Album'=>$annee,
                    'photo'=>"artistes/".$nomDossier."/".$memofile.$ext,
                  );
                }
                if (substr($memofile, 0, 5) == "Photo") {
                  $titrePhoto=explode('Photo_',$memofile);
                  $titrePhoto=trim(str_replace("_"," ",$titrePhoto[1]));
                  
                  $Photo[]=array(
                    'titre'=>$titrePhoto,
                    'Album'=>'',
                    'photo'=>"artistes/".$nomDossier."/".$memofile.$ext,
                  );
                }
            rename($path2."/".$fileee, $path2."/".$memofile.$ext);
            }
        }
    }
    //              echo "Tableau Disco pour page => ".$NomArtistePourPagetitle[$i]."<br />";
                        $valeurDisco=json_encode($Discopraphie);
                    $valeurDisco= str_replace("\/","/",$valeurDisco);
    
                  $table = $modx->getFullTableName('site_tmplvar_contentvalues');
                $fields = array('tmplvarid' => '7', 'contentid' => $idpagecreate[$i], 'value' => $valeurDisco);
                $modx->db->insert( $fields, $table);

    

    
    // echo $valeurDisco;
                      $Discopraphie=array();
                      
    //          echo "<br />Tableau Photo<br />";
                        $valeurPhoto=json_encode($Photo);
                        $valeurPhoto= str_replace("\/","/",$valeurPhoto);
 $table = $modx->getFullTableName('site_tmplvar_contentvalues');
                $fields = array('tmplvarid' => '6', 'contentid' => $idpagecreate[$i], 'value' => $valeurPhoto);
                $modx->db->insert( $fields, $table);
    //                 echo $valeurPhoto;
                      $Photo=array();
  }​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​