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; }