| Line 366... |
Line 366... |
| 366 |
} catch (Exception $e) {
|
366 |
} catch (Exception $e) {
|
| 367 |
die($e->getMessage());
|
367 |
die($e->getMessage());
|
| 368 |
}
|
368 |
}
|
| Line 369... |
Line 369... |
| 369 |
|
369 |
|
| - |
|
370 |
// récupération des nn mis à jour
|
| 370 |
// récupération des nn mis à jour
|
371 |
$this->connecterPDO('agathis_');
|
| 371 |
$sql = 'SELECT DISTINCT nn FROM del_image_top WHERE date_vote > ' . $date . ';';
|
372 |
$sql = 'SELECT DISTINCT nn FROM del_image_top WHERE date_vote > ' . $date . ';';
|
| 372 |
$requete = $this->requete($sql);
|
373 |
$requete = $this->requete($sql);
|
| 373 |
$nns = $requete->fetchAll();
|
374 |
$nns = $requete->fetchAll();
|
| Line 384... |
Line 385... |
| 384 |
foreach($infosCel['resultat'] as $organe => $imageSrc) {
|
385 |
foreach($infosCel['resultat'] as $organe => $imageSrc) {
|
| 385 |
$donnees[$nn]['thumbnails']['cel'][$organe] = $imageSrc;
|
386 |
$donnees[$nn]['thumbnails']['cel'][$organe] = $imageSrc;
|
| 386 |
}
|
387 |
}
|
| 387 |
// var_dump($donnees); die();
|
388 |
// var_dump($donnees); die();
|
| Line 388... |
Line 389... |
| 388 |
|
389 |
|
| 389 |
$response = $index->getObjects([$nn], ['objectID', 'nomenclatural_number', 'thumbnails']);
|
390 |
$response = $this->indexAlgolia->getObjects([$nn], ['objectID', 'nomenclatural_number', 'thumbnails']);
|
| 390 |
$response = json_decode($response, true);
|
391 |
$response = json_decode($response, true);
|
| 391 |
// var_dump($response); die();
|
392 |
// var_dump($response); die();
|
| 392 |
if (isset($response['results'])) {
|
393 |
if (isset($response['results'])) {
|
| 393 |
$results = array_reduce($response['results'], function($carry, $item) use ($nn) {
|
394 |
$results = array_reduce($response['results'], function($carry, $item) use ($nn) {
|
| Line 399... |
Line 400... |
| 399 |
// var_dump($results); die();
|
400 |
// var_dump($results); die();
|
| Line 400... |
Line 401... |
| 400 |
|
401 |
|
| 401 |
if (count($results) == 1) {
|
402 |
if (count($results) == 1) {
|
| 402 |
unset($results['thumbnails']['cel']);
|
403 |
unset($results['thumbnails']['cel']);
|
| 403 |
$results = array_merge($results, $donnees[$nn]);
|
404 |
$results = array_merge($results, $donnees[$nn]);
|
| 404 |
$index->partialUpdateObject([
|
405 |
$this->indexAlgolia->partialUpdateObject([
|
| 405 |
'thumbnails' => $results['thumbnails'],
|
406 |
'thumbnails' => $results['thumbnails'],
|
| 406 |
'objectID' => $results['objectID']
|
407 |
'objectID' => $results['objectID']
|
| 407 |
]);
|
408 |
]);
|
| Line 431... |
Line 432... |
| 431 |
var_dump($index[$i]);
|
432 |
var_dump($index[$i]);
|
| 432 |
}
|
433 |
}
|
| 433 |
}
|
434 |
}
|
| 434 |
}
|
435 |
}
|
| Line 435... |
Line 436... |
| 435 |
|
436 |
|
| 436 |
protected function connecterPDO() {
|
437 |
protected function connecterPDO($base = '') {
|
| 437 |
Config::charger(dirname(__FILE__) . '/../../configurations/bdd.ini');
|
438 |
Config::charger(dirname(__FILE__) . '/../../configurations/bdd.ini');
|
| 438 |
try {
|
439 |
try {
|
| 439 |
$dsn = Config::get('bdd_type').':dbname='.Config::get('bdd_nom').';host='.
|
440 |
$dsn = Config::get($base . 'bdd_type').':dbname='.Config::get($base . 'bdd_nom').';host='.
|
| 440 |
Config::get('bdd_hote');
|
441 |
Config::get($base . 'bdd_hote');
|
| 441 |
$this->bdd = new PDO($dsn, Config::get('bdd_utilisateur'), Config::get('bdd_mot_de_passe'));
|
442 |
$this->bdd = new PDO($dsn, Config::get($base . 'bdd_utilisateur'), Config::get($base . 'bdd_mot_de_passe'));
|
| 442 |
// Passe en UTF-8 la connexion à la BDD
|
443 |
// Passe en UTF-8 la connexion à la BDD
|
| 443 |
$this->bdd->exec("SET NAMES 'utf8'");
|
444 |
$this->bdd->exec("SET NAMES 'utf8'");
|
| 444 |
// Affiche les erreurs détectées par PDO (sinon mode silencieux => aucune erreur affiché)
|
445 |
// Affiche les erreurs détectées par PDO (sinon mode silencieux => aucune erreur affiché)
|
| 445 |
$this->bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
446 |
$this->bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|