Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 1199 → Rev 1200

/trunk/jrest/scripts/MigrationObs.php
136,8 → 136,9
echo "-------------------------------------------------------------------\n\n";
echo " ETAPE 2. Migration des utilisateurs ... \n\n";
echo "-------------------------------------------------------------------\n\n";
$this->migrerUtilisateurs();
$this->migrerUtilisateurs();
 
 
echo "-------------------------------------------------------------------\n\n";
echo " ETAPE 3. Migration des zone géographiques ... \n\n";
echo "-------------------------------------------------------------------\n\n";
147,7 → 148,8
echo " ETAPE 4. Migration des observations ... \n\n";
echo "-------------------------------------------------------------------\n\n";
$this->migrerObs();
$this->ordonnerObs();
$this->mettreANullPrenomNomVide();
$this->ordonnerObs();
echo "\n"."\n"."\n";
}
 
631,5 → 633,18
public function mailValide($mail) {
// vérification bidon mais ça suffit pour ici
return !(strpos('@', $mail) === false);
}
 
private function mettreANullPrenomNomVide() {
$bdd = self::$bdd_cel_migration;
$requete = "UPDATE $bdd.cel_obs ".
'SET prenom_utilisateur = NULL '.
"WHERE prenom_utilisateur = '' ";
$this->executer($requete);
 
$requete = "UPDATE $bdd.cel_obs ".
'SET nom_utilisateur = NULL '.
"WHERE nom_utilisateur = '' ";
$this->executer($requete);
}
}
/trunk/jrest/scripts/MigrationImages.php
685,6 → 685,7
echo " ETAPE 2. Migration des images ... \n\n";
echo "-------------------------------------------------------------------\n\n";
$this->migrerImages();
$this->mettreANullPrenomNomVide();
$this->ordonnerImages();
echo "\n"."\n"."\n";
 
1054,4 → 1055,17
echo "\n";
echo "\n---------------------------------------------------------------- OK\n\n";
}
 
private function mettreANullPrenomNomVide() {
$bdd = self::$bdd_cel_migration;
$requete = "UPDATE $bdd.cel_images ".
'SET prenom_utilisateur = NULL '.
"WHERE prenom_utilisateur = '' ";
$this->executer($requete);
 
$requete = "UPDATE $bdd.cel_images ".
'SET nom_utilisateur = NULL '.
"WHERE nom_utilisateur = '' ";
$this->executer($requete);
}
}
/trunk/jrest/scripts/MigrationMotsCles.php
79,6 → 79,7
echo "-------------------------------------------------------------------\n";
$this->genererIndexTexteMotsClesObs();
$this->genererIndexTexteMotsClesImages();
$this->mettreANullMotsClesTxtVide();
echo "\n"."\n"."\n";
}
 
402,4 → 403,16
 
return $this->executer($requete);
}
 
private function mettreANullMotsClesTxtVide() {
$bdd = self::$bdd_cel_migration;
$tables = array('cel_obs', 'cel_images');
 
foreach ($tables as $table) {
$requete = "UPDATE $bdd.$table ".
'SET mots_cles_texte = NULL '.
"WHERE mots_cles_texte = '' ";
$this->executer($requete);
}
}
}