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']; |
} |
} |
} |
} |