/** * @return array */ public function getRaidList() { /** * @var Raid */ $oRaid = new Raid(); /** * @var Attendance */ $oAttendance = new Attendance(); /** * @var Character */ $oCharacter = new Character(); /** * @var User */ $oMe = $this->oConfig->getMe(); /** * @var Db */ $oDb = Db::getInstance(); // @todo: only show raids >= today (maybe think about history support for checking attendance etc.) $aRaids = $oDb->getArray(Db::prepare("SELECT * FROM %s WHERE date(startDate) > date('now', '-1 day') ORDER BY startDate;", [$oRaid->getTableName()])); array_walk($aRaids, function (&$aRaid) use($oDb, $oAttendance, $oCharacter, $oMe) { $aAttendees = $oDb->getArray($oDb->prepare("SELECT ch.*, att.status FROM %s as att, %s as ch\n WHERE att.raidId = '%s' AND att.characterId LIKE ch.uuid AND att.status IN (2, 4, 5);", [$oAttendance->getTableName(), $oCharacter->getTableName(), $aRaid['uuid']])); $aRaid['attend'] = array_reduce($aAttendees, function ($bFound, $aAtt) use($oMe) { if ($bFound) { return $bFound; } return $aAtt['userId'] == $oMe['uuid'] ? $aAtt['status'] : false; }, false); $aRaid['state'] = 'open'; // @fix: remove declined from count $aRaid['attendeesCount'] = count($aAttendees); $aRaid['attendees'] = $aAttendees; }); return $aRaids; }