Subversion Repositories eFlore/Applications.coel

Rev

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

Rev 1759 Rev 1760
Line 462... Line 462...
462 
 
 462 
 
463 
		if (isset($p['nom-famille'])) {
 463 
		if (isset($p['nom-famille'])) {
464 
			$where[] = "cp_nom LIKE {$p['nom-famille']}";
 464 
			$where[] = "cp_nom LIKE {$p['nom-famille']}";
465 
		}
 465 
		}
- 
 
 466 
		if (isset($p['adresse'])) {
- 
 
 467 
      $join[] = 'LEFT JOIN coel_meta_liste_valeur cmlv ON cmlv.cmlv_id_valeur = cp_ce_truk_pays';
466 
		if (isset($p['adresse'])) {
 468 
      $join[] = 'LEFT JOIN coel_meta_liste_valeur cmlv2 ON cmlv2.cmlv_id_valeur = cp_ce_truk_region';
467 
			$where[] = '(' . implode(' OR ', array(
 469 
			$where[] = '(' . implode(' OR ', array(
468 
				"cp_adresse_01 LIKE {$p['adresse']}",
 470 
				"cp_adresse_01 LIKE {$p['adresse']}",
469 
				"cp_adresse_02 LIKE {$p['adresse']}",
 471 
				"cp_adresse_02 LIKE {$p['adresse']}",
470 
				"cp_code_postal LIKE {$p['adresse']}",
 472 
				"cp_code_postal LIKE {$p['adresse']}",
471 
				"cp_ville LIKE {$p['adresse']}",
 473 
				"cp_ville LIKE {$p['adresse']}",
- 
 
 474 
				"cp_ce_truk_pays LIKE {$p['adresse']}",
472 
				"cp_ce_truk_pays LIKE {$p['adresse']}",
 475 
				"cp_ce_truk_region LIKE {$p['adresse']}",
473 
				"cp_naissance_lieu LIKE {$p['adresse']}",
 476 
				"cp_naissance_lieu LIKE {$p['adresse']}",
- 
 
 477 
				"cp_deces_lieu LIKE {$p['adresse']}",
- 
 
 478 
				"cmlv.cmlv_nom LIKE {$p['adresse']}",
474 
				"cp_deces_lieu LIKE {$p['adresse']}"
 479 
				"cmlv2.cmlv_nom LIKE {$p['adresse']}"
475 
			)) . ')';
 480 
			)) . ')';
476 
		}
 481 
		}
477 
		if (isset($p['date-vivant'])) {
 482 
		if (isset($p['date-vivant'])) {
478 
			$where[] = "cp_naissance_date <= {$p['date-vivant']}";
 483 
			$where[] = "cp_naissance_date <= {$p['date-vivant']}";