public function TodayYMD()
{
return $this->JDtoYMD(WT_Date_Gregorian::YMDtoJD(date('Y'), date('n'), date('j')));
}
private static function search_indis_year_range($startyear, $endyear)
{
// TODO: We should use Julian-days, rather than gregorian years,
// to allow the lifespan chart, etc., to use other calendars.
$startjd = WT_Date_Gregorian::YMDtoJD($startyear, 1, 1);
$endjd = WT_Date_Gregorian::YMDtoJD($endyear + 1, 1, 1) - 1;
$sql = "SELECT DISTINCT i_id AS xref, i_file AS gedcom_id, i_gedcom AS gedcom" . " FROM `##individuals`" . " JOIN `##dates` ON i_id=d_gid AND i_file=d_file" . " WHERE i_file=? AND d_julianday1 BETWEEN ? AND ?";
$rows = WT_DB::prepare($sql)->execute(array(WT_GED_ID, $startjd, $endjd))->fetchAll();
$list = array();
foreach ($rows as $row) {
$list[] = WT_Individual::getInstance($row->xref, $row->gedcom_id, $row->gedcom);
}
return $list;
}
