public static function fetchByGroup(Connection $conn, $id, Group $group)
{
$data = $conn->fetchAssoc('SELECT a.*, ' . 't.`id` AS `territory_id`, t.`name` AS `territory_name`, t.`areaNum` AS `territory_areaNum`, t.`requestNum` as `territory_requestNum`, ' . self::createEntityFieldList() . 'FROM `' . CoreTables::AREA_TBL . '` a ' . self::createEntityJoin('a') . 'INNER JOIN `' . CoreTables::TERRITORY_TBL . '` t ON t.`id` = a.`territoryId` ' . 'WHERE a.`id` = :id AND a.`groupId` = :groupId', [':id' => $id, ':groupId' => $group->getId()]);
if (false === $data) {
return false;
}
$item = Area::fromArray($data);
$item->group = $group;
$item->project = Project::fetchActive($conn, $data['projectId']);
if (false == $item->project) {
return false;
}
$item->status = $item->oldStatus = AreaStatus::fetchByProject($conn, $data['statusId'], $item->project);
$item->setTerritory($item->oldTerritory = Territory::fromArray($data, 'territory'));
$item->entity = Entity::fromArray($data, 'entity');
return $item;
}
