| 106,18 → 106,21 |
|---|
| } |
| } |
| |
| $requete = 'SELECT ci_id_image, ci_nom_original, ci_md5, ordre '. |
| 'FROM cel_images AS cim '. |
| ' LEFT JOIN cel_obs_images AS coi '. |
| ' ON (coi.coi_ce_image = cim.ci_id_image) '. |
| ' LEFT JOIN cel_inventory AS ci '. |
| ' ON (coi.coi_ce_observation = ci.ordre AND coi.coi_ce_utilisateur = ci.identifiant) '. |
| "WHERE cim.ci_ce_utilisateur = '$utilisateur' ". |
| ' AND cim.ci_id_image IN ('.implode(',', $images_doublons_id).')'; |
| $infos = $this->executerRequete($requete); |
| foreach ($infos as $info) { |
| if (isset($doublons[$info['ci_md5']][$info['ci_id_image']]) && ! $this->etreNull($info['ordre'])) { |
| $doublons[$info['ci_md5']][$info['ci_id_image']]['obs_ordre'][] = $info['ordre']; |
| if (count($images_doublons_id) > 0) { |
| $requete = 'SELECT ci_id_image, ci_nom_original, ci_md5, ordre '. |
| 'FROM cel_images AS cim '. |
| ' LEFT JOIN cel_obs_images AS coi '. |
| ' ON (coi.coi_ce_image = cim.ci_id_image) '. |
| ' LEFT JOIN cel_inventory AS ci '. |
| ' ON (coi.coi_ce_observation = ci.ordre AND coi.coi_ce_utilisateur = ci.identifiant) '. |
| "WHERE cim.ci_ce_utilisateur = '$utilisateur' ". |
| ' AND cim.ci_id_image IN ('.implode(',', $images_doublons_id).')'; |
| $infos = $this->executerRequete($requete); |
| |
| foreach ($infos as $info) { |
| if (isset($doublons[$info['ci_md5']][$info['ci_id_image']]) && ! $this->etreNull($info['ordre'])) { |
| $doublons[$info['ci_md5']][$info['ci_id_image']]['obs_ordre'][] = $info['ordre']; |
| } |
| } |
| } |
| } |