Subversion Repositories eFlore/Applications.coel

Rev

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

Rev 1754 Rev 1758
Line 470... Line 470...
470
				"cp_deces_lieu LIKE {$p['adresse']}"
470
				"cp_deces_lieu LIKE {$p['adresse']}"
471
			)) . ')';
471
			)) . ')';
472
		}
472
		}
473
		if (isset($p['date-vivant'])) {
473
		if (isset($p['date-vivant'])) {
474
			$where[] = "cp_naissance_date <= {$p['date-vivant']}";
474
			$where[] = "cp_naissance_date <= {$p['date-vivant']}";
-
 
475
			$where[] = "cp_deces_date >= {$p['date-vivant']}";
-
 
476
			$where[] = "cp_naissance_date IS NOT NULL";
-
 
477
			$where[] = "cp_deces_date IS NOT NULL";
475
			$where[] = "(cp_deces_date IS NULL OR cp_deces_date >= {$p['date-vivant']})";
478
			//$where[] = "(cp_deces_date IS NULL OR cp_deces_date >= {$p['date-vivant']})";
476
		}
479
		}
Line 477... Line 480...
477
 
480
 
478
		// pour inclure éventuellement les adresses de la structure
481
		// pour inclure éventuellement les adresses de la structure
479
		/*if (isset($p['adresse'])) {
482
		/*if (isset($p['adresse'])) {