| 438,6 → 438,7 |
|---|
| } |
| |
| private function executerRequete($requete) { |
| $infos = null; |
| try { |
| $infos = $this->bdd->query($requete)->fetchAll(PDO::FETCH_ASSOC); |
| if ($infos === false) { |
| 486,7 → 487,7 |
|---|
| // Construction de la requête pour récupérer les second éléments |
| $elements_1er_cle_ligne = array(); |
| foreach ($infos_elements_1er as $info) { |
| $elements_1er_cle_ligne[] = $info['cmhl_cle_ligne']; |
| $elements_1er_cle_ligne[] = '"'.$info['cmhl_cle_ligne'].'"'; |
| } |
| $chaine_1er_elements = 'AND h1.cmhl_cle_ligne IN ('.str_replace(',,',',',implode(',', $elements_1er_cle_ligne)).') '; |
| $requete_elements_2nd = sprintf($requete, $chaine_1er_elements, '2'); |
| 609,7 → 610,7 |
|---|
| private function getXmlHisto($info) { |
| $xml = ''; |
| if ($info['cmhl_ce_etat'] == '3') { |
| $xml = $info['enrg_prec']; |
| $xml = @$info['enrg_prec']; |
| } else { |
| $xml = $info['cmhl_enregistrement']; |
| } |
| 625,7 → 626,7 |
|---|
| } |
| } else if ($info['cmhl_ce_etat'] == '2') { |
| $nouveau = $this->getTableauDepuisXmlHisto($info['cmhl_enregistrement']); |
| $ancien = $this->getTableauDepuisXmlHisto($info['enrg_prec']); |
| $ancien = @$this->getTableauDepuisXmlHisto($info['enrg_prec']); |
| foreach ($nouveau as $cle => $valeur) { |
| if (!isset($ancien[$cle])) { |
| $diff[$cle] = array('type' => 'A', 'type_txt' => 'Ajout', 'nouveau' => $valeur, 'ancien' => ' '); |
| 651,7 → 652,7 |
|---|
| $diff['etat'] = 'A'; |
| } else if ($info['cmhl_ce_etat'] == '2') { |
| $diff['date_nouvelle'] = strftime($format, strtotime($info['cmhl_date_modification'])); |
| $diff['date_ancienne'] = strftime($format, strtotime($info['date_prec'])); |
| $diff['date_ancienne'] = @strftime($format, strtotime($info['date_prec'])); |
| $diff['etat'] = 'M'; |
| } else if ($info['cmhl_ce_etat'] == '3') { |
| $diff['etat'] = 'S'; |