Subversion Repositories eFlore/Applications.coel

Rev

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

Rev 1758 Rev 1759
Line 367... Line 367...
367 
		}
 367 
		}
368 
		if (isset($p['bot'])) {
 368 
		if (isset($p['bot'])) {
369 
			$where[] = "ccb_ce_truk_type IN ({$p['bot']})";
 369 
			$where[] = "ccb_ce_truk_type IN ({$p['bot']})";
370 
		}
 370 
		}
371 
		if (isset($p['lieu-stockage'])) {
 371 
		if (isset($p['lieu-stockage'])) {
- 
 
 372 
      $join[] = 'LEFT JOIN coel_meta_liste_valeur cmlv ON cmlv.cmlv_id_valeur = cs_ce_truk_pays';
- 
 
 373 
      $join[] = 'LEFT JOIN coel_meta_liste_valeur cmlv2 ON cmlv2.cmlv_id_valeur = cs_ce_truk_region';
372 
			$where[] = '(' . implode(' OR ', array(
 374 
			$where[] = '(' . implode(' OR ', array(
373 
				"cs_adresse_01 LIKE {$p['lieu-stockage']}",
 375 
				"cs_adresse_01 LIKE {$p['lieu-stockage']}",
374 
				"cs_adresse_02 LIKE {$p['lieu-stockage']}",
 376 
				"cs_adresse_02 LIKE {$p['lieu-stockage']}",
375 
				"cs_code_postal LIKE {$p['lieu-stockage']}",
 377 
				"cs_code_postal LIKE {$p['lieu-stockage']}",
376 
				"cs_ville LIKE {$p['lieu-stockage']}",
 378 
				"cs_ville LIKE {$p['lieu-stockage']}",
377 
				"cs_ce_truk_region LIKE {$p['lieu-stockage']}", // @TODO joindre la table meta
 379 
				"cs_ce_truk_region LIKE {$p['lieu-stockage']}",
378 
				"cs_ce_truk_pays LIKE {$p['lieu-stockage']}"
 380 
				"cs_ce_truk_pays LIKE {$p['lieu-stockage']}",
- 
 
 381 
				"cmlv.cmlv_nom LIKE {$p['lieu-stockage']}",
- 
 
 382 
				"cmlv2.cmlv_nom LIKE {$p['lieu-stockage']}"
379 
			)) . ')';
 383 
			)) . ')';
380 
		}
 384 
		}
381 
		if (isset($p['zg'])) {
 385 
		if (isset($p['zg'])) {
382 
			$where[] = "cc_truk_couverture_lieu LIKE {$p['zg']}";
 386 
			$where[] = "cc_truk_couverture_lieu LIKE {$p['zg']}";
383 
		}
 387 
		}