Subversion Repositories eFlore/Applications.cel

Rev

Rev 416 | Rev 530 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 416 Rev 526
Line 80... Line 80...
80 
						"WHERE ci_ce_utilisateur = '$utilisateur' ";
 80 
						"WHERE ci_ce_utilisateur = '$utilisateur' ";
81 
			$images = $this->executerRequete($requete);
 81 
			$images = $this->executerRequete($requete);
Line 82... Line 82...
82 
 
 82 
 
83 
			// Traitement
 83 
			// Traitement
- 
 
 84 
			$doublons = array();
84 
			$doublons = array();
 85 
			$images_doublons_id = array();
85 
			$md5 = array();
 86 
			$md5 = array();
86 
			foreach ($images as $img) {
 87 
			foreach ($images as $img) {
- 
 
 88 
				if (!isset($md5[$img['ci_md5']])) {
87 
				if (!isset($md5[$img['ci_md5']])) {
 89 
					$md5[$img['ci_md5']] = array(
- 
 
 90 
						'url' => $this->getUrlImage($img['ci_id_image'], 'S'),
- 
 
 91 
						'obs_ordre' => array(),
- 
 
 92 
						'img_ordre' => $img['ci_ordre'],
88 
					$md5[$img['ci_md5']][] = array('url' => $this->creerUrlImage($img['ci_id_image']), 'num' => $img['ci_ordre']);
 93 
						'img_id' => $img['ci_id_image']);
89 
				} else {
 94 
				} else {
- 
 
 95 
					if (!isset($doublons[$img['ci_md5']])) {
90 
					if (!isset($doublons[$img['ci_md5']])) {
 96 
						$id_img = $md5[$img['ci_md5']]['img_id'];
- 
 
 97 
						$doublons[$img['ci_md5']][$id_img] = $md5[$img['ci_md5']];
91 
						$doublons[$img['ci_md5']] = $md5[$img['ci_md5']];
 98 
						$images_doublons_id[] = $this->bdd->quote($id_img);
- 
 
 99 
					}
- 
 
 100 
					$doublons[$img['ci_md5']][$img['ci_id_image']] = array(
- 
 
 101 
							'url' => $this->getUrlImage($img['ci_id_image'], 'S'),
- 
 
 102 
							'obs_ordre' => array(),
- 
 
 103 
							'img_ordre' => $img['ci_ordre'],
- 
 
 104 
							'img_id' => $img['ci_id_image']);
- 
 
 105 
					$images_doublons_id[] = $this->bdd->quote($img['ci_id_image']);
- 
 
 106 
				}
- 
 
 107 
			}
- 
 
 108
- 
 
 109 
			$requete = 	'SELECT ci_id_image, ci_nom_original, ci_md5, ordre '.
- 
 
 110 
						'FROM cel_images AS cim '.
- 
 
 111 
						'	LEFT JOIN cel_obs_images AS coi '.
- 
 
 112 
						'		ON (coi.coi_ce_image = cim.ci_id_image) '.
- 
 
 113 
						'	LEFT JOIN cel_inventory AS ci '.
- 
 
 114 
						'		ON (coi.coi_ce_observation = ci.ordre AND coi.coi_ce_utilisateur = ci.identifiant) '.
- 
 
 115 
						"WHERE cim.ci_ce_utilisateur = '$utilisateur' ".
- 
 
 116 
						'	AND cim.ci_id_image IN ('.implode(',', $images_doublons_id).')';
- 
 
 117 
			$infos = $this->executerRequete($requete);
- 
 
 118 
			foreach ($infos as $info) {
92 
					}
 119 
				if (isset($doublons[$info['ci_md5']][$info['ci_id_image']]) && ! $this->etreNull($info['ordre'])) {
93 
					$doublons[$img['ci_md5']][] = array('url' => $this->creerUrlImage($img['ci_id_image']), 'num' => $img['ci_ordre']);
 120 
					$doublons[$info['ci_md5']][$info['ci_id_image']]['obs_ordre'][] = $info['ordre'];
94 
				}
 121 
				}
95 
			}
 122 
			}
Line 96... Line 123...
96 
		}
 123 
		}
97 
 
 124 
 
98 
		//echo '<pre>'.print_r($doublons, true).'</pre>';
 125 
		//echo '<pre>'.print_r($doublons, true).'</pre>';
99 
		return $doublons;
 - 
 
100 
	}
 - 
 
101 
 
 - 
 
102 
	private function creerUrlImage($id_image, $taille = 'S') {
 - 
 
103 
        $chemin_sur_serveur = $this->config['cel_db']['url_images'];
 - 
 
104 
		$id_image = sprintf('%09s', $id_image);
 - 
 
105 
		$id_image = wordwrap($id_image, 3 , '_', true);
 - 
 
106 
 
 - 
 
107 
		$niveauDossier = split('_', $id_image);
 - 
 
108 
		$dossierNiveau1 = $niveauDossier[0];
 - 
 
109 
		$dossierNiveau2 = $niveauDossier[1];
 - 
 
110 
 
 - 
 
111 
		$chemin_sur_serveur_final = $chemin_sur_serveur.'/'.$dossierNiveau1.'/'.$dossierNiveau2;
 - 
 
112 
		$chemin_img = "$chemin_sur_serveur_final/$taille/{$id_image}_$taille.jpg";
 - 
 
113 
		return $chemin_img;
 126 
		return $doublons;
114 
	}
 127 
	}