/**
* @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;
}
