<?php

require_once("../../inc/confNetisse.php");

function object2array($object) {
    return json_decode(json_encode($object), TRUE);
}

$stringXML = file_get_contents("http://ifp10-iucrprdapa.ca-technologies.fr:81/CRIF/auth_service/public/ws/getprofilapplication/application_id/BORNE_AA/profil/PRO");
$xmlObject = simplexml_load_string($stringXML);
$xmlArray = object2array($xmlObject);
$matricules = $xmlArray['matricule'];
$matriculeList = "";
for ($i = 0; $i < count($matricules); $i++) {
    $matriculeList .= "'" . $matricules[$i]['libelle'] . "'";
    if ($i < count($matricules) - 1)
        $matriculeList .= ",";
}

$query = "SELECT matricule FROM ca_remote_conseillers WHERE matricule IN (" . $matriculeList . ")";
$result = excuteQuery($query);
if(!$result['status'])
      var_dump($result['stmt']->errorInfo());
$n = $result['stmt']->rowCount();
$existingMatriculeList = array();
while ($row = $result['stmt']->fetchObject()) {
    $existingMatriculeList[] = $row->matricule;
}

for ($i = 0; $i < count($matricules); $i++) {
    if (!in_array($matricules[$i]['libelle'], $existingMatriculeList)) {
        $query = "INSERT INTO ca_remote_conseillers (matricule,nom) values (?,?)";
       $stmt = excuteQuery($query);
        if(!$stmt['status'])
              var_dump($stmt['stmt']->errorInfo());
    }
}
?>