Subversion Repositories eFlore/Applications.cel

Rev

Rev 2116 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2116 Rev 2143
Line 52... Line 52...
52 
			"FROM {$this->table_mots_cles} ".
 52 
			"FROM {$this->table_mots_cles} ".
53 
			"WHERE chemin LIKE CONCAT(($sousRequete), '%') ".
 53 
			"WHERE chemin LIKE CONCAT(($sousRequete), '%') ".
54 
			"AND id_utilisateur = ".$idUtilisateurP." ".
 54 
			"AND id_utilisateur = ".$idUtilisateurP." ".
55 
			' -- '.__FILE__.':'.__LINE__;
 55 
			' -- '.__FILE__.':'.__LINE__;
Line 56... Line 56...
56 
 
 56 
 
Line 57... Line 57...
57 
		$ids_enfants = Cel::db()->executerRequete($requete);
 57 
		$ids_enfants = Cel::db()->requeter($requete);
58 
 
 58 
 
Line 59... Line 59...
59 
		return $ids_enfants;
 59 
		return $ids_enfants;
Line 68... Line 68...
68 
			"FROM {$this->table_mots_cles} ".
 68 
			"FROM {$this->table_mots_cles} ".
69 
			"WHERE chemin = $cheminMotCleP ".
 69 
			"WHERE chemin = $cheminMotCleP ".
70 
			"AND id_utilisateur = $idUtilisateurP ".
 70 
			"AND id_utilisateur = $idUtilisateurP ".
71 
			' -- '.__FILE__.':'.__LINE__;
 71 
			' -- '.__FILE__.':'.__LINE__;
Line 72... Line 72...
72 
 
 72 
 
Line 73... Line 73...
73 
		$infosMotCle = Cel::db()->executerRequete($requete);
 73 
		$infosMotCle = Cel::db()->requeter($requete);
74 
 
 74 
 
75 
		if (!empty($infosMotCle)) {
 75 
		if (!empty($infosMotCle)) {
76 
			$idMotCle = $infosMotCle[0]['id_mot_cle'];
 76 
			$idMotCle = $infosMotCle[0]['id_mot_cle'];
Line 195... Line 195...
195 
		$suppression = Cel::db()->executer($requete);
 195 
		$suppression = Cel::db()->executer($requete);
196 
		return $suppression;
 196 
		return $suppression;
197 
	}
 197 
	}
Line 198... Line 198...
198 
 
 198 
 
199 
	public function supprimerToutesLiaisonsPourIdsElementsLies($ids_elements_lies) {
 199 
	public function supprimerToutesLiaisonsPourIdsElementsLies($ids_elements_lies) {
200 
		$idsElementsLiesP = Cel::db()->protegerTableau($ids_elements_lies);
 200 
		$idsElementsLiesP = Cel::db()->proteger($ids_elements_lies);
Line 201... Line 201...
201 
		$listeIds = implode(',', $idsElementsLiesP);
 201 
		$listeIds = implode(',', $idsElementsLiesP);
202
202 
 
203 
		$requete = "DELETE FROM {$this->table_liaison} ".
 203 
		$requete = "DELETE FROM {$this->table_liaison} ".
Line 210... Line 210...
210 
	}
 210 
	}
Line 211... Line 211...
211 
 
 211 
 
212 
	public function supprimerToutesLiaisonsIdsMotsCles($ids_mots_cles, $id_utilisateur) {
 212 
	public function supprimerToutesLiaisonsIdsMotsCles($ids_mots_cles, $id_utilisateur) {
213 
		$suppression = true;
 213 
		$suppression = true;
214 
		if (!empty($ids_mots_cles)) {
 214 
		if (!empty($ids_mots_cles)) {
215 
			$idsMotsClesP = Cel::db()->protegerTableau($ids_mots_cles);
 215 
			$idsMotsClesP = Cel::db()->proteger($ids_mots_cles);
Line 216... Line 216...
216 
			$listeIds = implode(',', $idsMotsClesP);
 216 
			$listeIds = implode(',', $idsMotsClesP);
217
217 
 
218 
			$requete = "DELETE FROM {$this->table_liaison} ".
 218 
			$requete = "DELETE FROM {$this->table_liaison} ".
Line 219... Line 219...
219 
				"WHERE id_mot_cle IN ($listeIds) ".
 219 
				"WHERE id_mot_cle IN ($listeIds) ".
220 
				' -- '.__FILE__.':'.__LINE__;
 220 
				' -- '.__FILE__.':'.__LINE__;
221 
 
 221 
 
222 
			$suppression = Cel::db()->executerRequeteSimple($requete);
 222 
			$suppression = Cel::db()->executer($requete);
223 
			$suppression = ($suppression !== false) ? true : false;
 223 
			$suppression = ($suppression !== false) ? true : false;
Line 240... Line 240...
240 
		$requete = "DELETE FROM {$this->table_liaison} ".
 240 
		$requete = "DELETE FROM {$this->table_liaison} ".
241 
			"WHERE id_element_lie = $idElementLieP ".
 241 
			"WHERE id_element_lie = $idElementLieP ".
242 
			"AND id_mot_cle IN ($sousRequete) ".
 242 
			"AND id_mot_cle IN ($sousRequete) ".
243 
			' -- '.__FILE__.':'.__LINE__;
 243 
			' -- '.__FILE__.':'.__LINE__;
Line 244... Line 244...
244 
 
 244 
 
245 
		$suppression_liaison = Cel::db()->executerRequeteSimple($requete);
 245 
		$suppression_liaison = Cel::db()->executer($requete);
Line 246... Line 246...
246 
		$suppression_liaison = ($suppression_liaison !== false);
 246 
		$suppression_liaison = ($suppression_liaison !== false);
247 
 
 247 
 
Line 403... Line 403...
403 
		return ($suppression !== false);
 403 
		return ($suppression !== false);
Line 404... Line 404...
404 
 
 404 
 
Line 405... Line 405...
405 
	}
 405 
	}
406 
 
 406 
 
407 
	public function obtenirIdsMotClesPourMotsCles($mots_cles, $id_utilisateur) {
 407 
	public function obtenirIdsMotClesPourMotsCles($mots_cles, $id_utilisateur) {
408 
		$motsClesP = Cel::db()->protegerTableau($mots_cles);
 408 
		$motsClesP = Cel::db()->proteger($mots_cles);
Line 409... Line 409...
409 
		$listeMotsClesP = implode(',', $motsClesP);
 409 
		$listeMotsClesP = implode(',', $motsClesP);
410 
		$idUtilisateurP = Cel::db()->proteger($id_utilisateur);
 410 
		$idUtilisateurP = Cel::db()->proteger($id_utilisateur);
Line 441... Line 441...
441 
	}
 441 
	}
Line 442... Line 442...
442 
 
 442 
 
443 
	public function obtenirIdElementsLiesPourIds($ids_mots_cles) {
 443 
	public function obtenirIdElementsLiesPourIds($ids_mots_cles) {
444 
		$idsElementsLies = array();
 444 
		$idsElementsLies = array();
445 
		if (!empty($ids_mots_cles)) {
 445 
		if (!empty($ids_mots_cles)) {
446 
			$idsMotsClesP = Cel::db()->protegerTableau($ids_mots_cles);
 446 
			$idsMotsClesP = Cel::db()->proteger($ids_mots_cles);
Line 447... Line 447...
447 
			$listeIdsMotsCles = implode(',', $idsMotsClesP);
 447 
			$listeIdsMotsCles = implode(',', $idsMotsClesP);
448
448 
 
449 
			$requete = 'SELECT id_element_lie '.
 449 
			$requete = 'SELECT id_element_lie '.
450 
				"FROM {$this->table_liaison} ".
 450 
				"FROM {$this->table_liaison} ".
Line 451... Line 451...
451 
				"WHERE id_mot_cle IN ($listeIdsMotsCles) ".
 451 
				"WHERE id_mot_cle IN ($listeIdsMotsCles) ".
452 
				' -- '.__FILE__.':'.__LINE__;
 452 
				' -- '.__FILE__.':'.__LINE__;
453
453 
 
454 
 
 454 
 
Line 455... Line 455...
455 
			$idsElementsLies = Cel::db()->executerRequete($requete);
 455 
			$idsElementsLies = Cel::db()->requeter($requete);
Line 606... Line 606...
606
606 
 
607 
		$requete_migration_mc = "UPDATE {$table_mots_cles} ".
 607 
		$requete_migration_mc = "UPDATE {$table_mots_cles} ".
608 
			"SET id_utilisateur = $idUtilisateurP ".
 608 
			"SET id_utilisateur = $idUtilisateurP ".
Line 609... Line 609...
609 
			"WHERE id_utilisateur = $emailUtilisateurP ";
 609 
			"WHERE id_utilisateur = $emailUtilisateurP ";
610 
 
 610 
 
611 
		$migration = Cel::db()->executerRequeteSimple($requete_migration_mc);
 611 
		$migration = Cel::db()->executer($requete_migration_mc);
612 
		$migration = ($migration !== false) ? true : false;
 612 
		$migration = ($migration !== false) ? true : false;
613 
		return $migration;
 613 
		return $migration;
614 
	}
 614 
	}