/**
* @name convertFromArray($pArray)
* @param array()
* @desc Convertit le array en objet AdherentVO
*/
public static function convertFromArray($pArray)
{
$lValid = isset($pArray['id']) && isset($pArray['numero']) && isset($pArray['idCompte']) && isset($pArray['nom']) && isset($pArray['prenom']) && isset($pArray['courrielPrincipal']) && isset($pArray['courrielSecondaire']) && isset($pArray['telephonePrincipal']) && isset($pArray['telephoneSecondaire']) && isset($pArray['adresse']) && isset($pArray['codePostal']) && isset($pArray['ville']) && isset($pArray['dateNaissance']) && isset($pArray['dateAdhesion']) && isset($pArray['commentaire']) && isset($pArray['modules']);
if ($lValid) {
$lVo = new AdherentVO();
$lVo->setId($pArray['id']);
$lVo->setNumero($pArray['numero']);
$lVo->setIdCompte($pArray['idCompte']);
$lVo->setNom($pArray['nom']);
$lVo->setPrenom($pArray['prenom']);
$lVo->setCourrielPrincipal($pArray['courrielPrincipal']);
$lVo->setCourrielSecondaire($pArray['courrielSecondaire']);
$lVo->setTelephonePrincipal($pArray['telephonePrincipal']);
$lVo->setTelephoneSecondaire($pArray['telephoneSecondaire']);
$lVo->setAdresse($pArray['adresse']);
$lVo->setCodePostal($pArray['codePostal']);
$lVo->setVille($pArray['ville']);
$lVo->setDateNaissance($pArray['dateNaissance']);
$lVo->setDateAdhesion($pArray['dateAdhesion']);
$lVo->setCommentaire($pArray['commentaire']);
$lVo->setListeModule($pArray['modules']);
return $lVo;
}
return NULL;
}
/**
* @name remplirAdherent($pId, $pNumero, $pIdCompte, $pNom, $pPrenom, $pCourrielPrincipal, $pCourrielSecondaire, $pTelephonePrincipal, $pTelephoneSecondaire, $pAdresse, $pCodePostal, $pVille, $pDateNaissance, $pDateAdhesion, $pDateMaj, $pCommentaire, $pEtat)
* @param int(11)
* @param varchar(5)
* @param int(11)
* @param varchar(50)
* @param varchar(50)
* @param varchar(100)
* @param varchar(100)
* @param varchar(20)
* @param varchar(20)
* @param varchar(300)
* @param varchar(10)
* @param varchar(100)
* @param date
* @param date
* @param datetime
* @param text
* @param tinyint(1)
* @return AdherentVO
* @desc Retourne une AdherentVO remplie
*/
private static function remplirAdherent($pId, $pNumero, $pIdCompte, $pNom, $pPrenom, $pCourrielPrincipal, $pCourrielSecondaire, $pTelephonePrincipal, $pTelephoneSecondaire, $pAdresse, $pCodePostal, $pVille, $pDateNaissance, $pDateAdhesion, $pDateMaj, $pCommentaire, $pEtat)
{
$lAdherent = new AdherentVO();
$lAdherent->setId($pId);
$lAdherent->setNumero($pNumero);
$lAdherent->setIdCompte($pIdCompte);
$lAdherent->setNom($pNom);
$lAdherent->setPrenom($pPrenom);
$lAdherent->setCourrielPrincipal($pCourrielPrincipal);
$lAdherent->setCourrielSecondaire($pCourrielSecondaire);
$lAdherent->setTelephonePrincipal($pTelephonePrincipal);
$lAdherent->setTelephoneSecondaire($pTelephoneSecondaire);
$lAdherent->setAdresse($pAdresse);
$lAdherent->setCodePostal($pCodePostal);
$lAdherent->setVille($pVille);
$lAdherent->setDateNaissance($pDateNaissance);
$lAdherent->setDateAdhesion($pDateAdhesion);
$lAdherent->setDateMaj($pDateMaj);
$lAdherent->setCommentaire($pCommentaire);
$lAdherent->setEtat($pEtat);
return $lAdherent;
}
$lOperation->setMontant($lSolde);
$lOperation->setLibelle("Création du compte");
$lOperation->setDate(StringUtils::dateAujourdhuiDb());
//$lOperation->setType(1);
$lOperation->setIdCommande(0);
$lOperation->setTypePaiement(-1);
OperationManager::insert($lOperation);
}
//L'adhérent
$lAdherent = new AdherentVO();
$lAdherent->setIdCompte($lIdCompte);
$lAdherent->setNumero($lNumero);
$lAdherent->setNom(StringUtils::formaterNom(trim($lNom)));
$lAdherent->setPrenom(StringUtils::formaterPrenom(trim($lPrenom)));
$lAdherent->setCourrielPrincipal(trim($lCourrielP));
$lAdherent->setCourrielSecondaire(trim($lCourrielS));
$lAdherent->setTelephonePrincipal(trim($lTelephoneP));
$lAdherent->setTelephoneSecondaire(trim($lTelephoneS));
$lAdherent->setAdresse(trim($lAdresse));
$lAdherent->setCodePostal(trim($lCodePostal));
$lAdherent->setVille(StringUtils::formaterVille(trim($lVille)));
$lAdherent->setDateNaissance($lDateNaissance);
$lAdherent->setDateAdhesion($lDateAdhesion);
$lAdherent->setDateMaj(StringUtils::dateTimeAujourdhuiDb());
$lAdherent->setCommentaire(trim($lCommentaire));
$lAdherent->setEtat(1);
// Protection des dates vides
if ($lAdherent->getDateNaissance() == '') {
$lAdherent->setDateNaissance(StringUtils::FORMAT_DATE_NULLE);
}
$lRequete = "INSERT INTO " . AdherentManager::TABLE_ADHERENT . "\n\t\t\t\t\t\t\t(" . AdherentManager::CHAMP_ADHERENT_ID . "\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_NUMERO . "\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_ID_COMPTE . "\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_NOM . "\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_PRENOM . "\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_COURRIEL_PRINCIPAL . "\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_COURRIEL_SECONDAIRE . "\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_TELEPHONE_PRINCIPAL . "\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_TELEPHONE_SECONDAIRE . "\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_ADRESSE . "\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_CODE_POSTAL . "\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_VILLE . "\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_DATE_NAISSANCE . "\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_DATE_ADHESION . "\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_DATE_MAJ . "\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_COMMENTAIRE . "\t\t\t\t\n\t\t\t\t\t\t\t," . AdherentManager::CHAMP_ADHERENT_ETAT . ")\n\t\t\t\t\t\t\tVALUES (NULL\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getNumero()) . "'\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getIdCompte()) . "'\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getNom()) . "'\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getPrenom()) . "'\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getCourrielPrincipal()) . "'\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getCourrielSecondaire()) . "'\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getTelephonePrincipal()) . "'\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getTelephoneSecondaire()) . "'\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getAdresse()) . "'\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getCodePostal()) . "'\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getVille()) . "'\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getDateNaissance()) . "'\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getDateAdhesion()) . "'\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getDateMaj()) . "'\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getCommentaire()) . "'\n\t\t\t\t\t\t\t\t,'" . StringUtils::securiser($lAdherent->getEtat()) . "')";
$lNbKO = 0;
$row = 1;
if (($handle = fopen("compte", "r")) !== FALSE) {
while (($data = fgetcsv($handle)) !== FALSE) {
// Création d'un nouveau compte
$lCompte = new CompteVO();
$lCompte->setLabel($data[11]);
$lCompte->setSolde(str_replace(",", ".", $data[13]));
$lIdCompte = CompteManager::insert($lCompte);
$lAdherent = new AdherentVO();
$lAdherent->setIdCompte($lIdCompte);
$lAdherent->setNumero($data[1]);
$lAdherent->setNom($data[2]);
$lAdherent->setPrenom($data[3]);
$lAdherent->setCourrielPrincipal($data[4]);
$lAdherent->setCourrielSecondaire($data[5]);
$lAdherent->setTelephonePrincipal($data[6]);
$lAdherent->setTelephoneSecondaire($data[7]);
$lAdherent->setAdresse($data[8]);
$lVille = explode(" ", $data[9]);
$lAdherent->setCodePostal($lVille[0]);
$lAdherent->setVille($lVille[1]);
$lAdherent->setDateNaissance(StringUtils::FORMAT_DATE_NULLE);
$lDateAdhesion = '20' . $data[10][0] . $data[10][1] . '-' . $data[10][2] . $data[10][3] . '-' . $data[10][4] . $data[10][5];
$lAdherent->setDateAdhesion($lDateAdhesion);
$lAdherent->setDateMaj(StringUtils::dateTimeAujourdhuiDb());
$lAdherent->setCommentaire($data[12]);
$lAdherent->setEtat(1);
// Enregistre l'adherent dans la BDD
//$lId = AdherentManager::insert( $lAdherent );
// Mise en forme des données
