1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125
| <?php
// parcourir tous les enregistrements de la table prospects
require_once ('_conn-intranet.php');
$telephone='';
$cpostal='';
$reponse = $bdd->query('SELECT idprospects, telephone, cpostal FROM prospects');
while ($data = $reponse->fetch()) {
if(strlen($data['telephone'])==9) { // Si telephone a 9 chiffres, on ajoute 0 devant
$telephone = '0'.$data['telephone'];
}
if(strlen($data['cpostal'])==4) { // Si code postal a 4 chiffres, on ajoute 0 devant
$cpostal = '0'.$data['cpostal'];
}
// Màj de l'enregistrement
$req=$bdd->prepare('UPDATE prospects SET (telephone=:telephone , cpostal=:cpostal) WHERE idprospects=\''.$data['idprospects'].'\'');
$req->execute(array(':telephone' => $telephone, ':cpostal' => $cpostal ));
} // end while
echo 'Téléphone et code postal modifiés<br />';
/* Création de la référence */
$reference ='';
$cabinet='';
$consultant='';
$dossier='';
$reponse = $bdd->query('SELECT idprospects, cpostal FROM prospects');
while ($data = $reponse->fetch()) {
$departement = substr($data['cpostal'], 0, 2);
switch ($departement){
case 24: // Aquitaine, Dordogne
$cabinet='24'; // Périgueux
$consultant='TRI'; //
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 33: // Aquitaine, Gironde
$cabinet='33'; // Bordeaux
$consultant='TRI'; //
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 40: // Aquitaine, Landes
$cabinet='40'; // Mont de marsan
$consultant='TRI'; //
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 47: // Aquitaine, Lot et garonne
$cabinet='47'; // Agen
$consultant='TRI'; //
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 64: // Aquitaine, Pyrennees atlantique
$cabinet='64'; // Pau
$consultant='TRI'; //
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 09: // Midi Pyrennees, Ariège
$cabinet='09'; // Foix
$consultant='TRI'; //
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 12: // Midi Pyrennees, Aveyron
$cabinet='12'; // Rodez
$consultant='TRI'; //
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 31: // Midi Pyrennees, Haute garonne
$cabinet='31'; // Toulouse
$consultant='TRI'; // Triviaux
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 32: // Midi Pyrennees, Gers
$cabinet='32'; // Auch
$consultant='TRI'; //
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 46: // Midi Pyrennees, Lot
$cabinet='46'; // Cahors
$consultant='TRI'; // Triviaux
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 65: // Midi Pyrennees, Hautes Pyrennees
$cabinet='65'; // Tarbes
$consultant='TRI'; //
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 81: // Midi Pyrennees, Tarn
$cabinet='81'; // Albi
$consultant='TRI'; //
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 82: // Midi Pyrennees, Tarn et garonne
$cabinet='82'; // Montauban
$consultant='TRI'; // Triviaux
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 11: // Languedoc Roussillon, Aude
$cabinet='11'; // Carcassonne
$consultant='TRI'; //
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 30: // Languedoc Roussillon, Gard
$cabinet='30'; // Nimes
$consultant='TRI'; //
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 34: // Languedoc Roussillon, Hérault
$cabinet='34'; // Montpellier
$consultant='TRI'; //
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
case 48: // Languedoc Roussillon, Lozère
$cabinet='48'; // Mende
$consultant='TRI'; //
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
break;
default: // Languedoc Roussillon, Pyrennees orientales
$cabinet='66'; // Perpignan
$consultant='TRI'; //
$dossier=str_pad($data['idprospects'], 6, "0", STR_PAD_LEFT);
} // End switch
$reference = $cabinet.$consultant.$dossier;
//echo $reference.'<br />';
$req=$bdd->prepare('UPDATE prospects SET (reference=:reference) WHERE idprospects=\''.$_data['idprospects'].'\'');
$req->execute(array(':reference' => $reference));
} // end while
echo 'Référence ajoutée<br />Traitement terminé.';
?> |
Partager