| public getFarmsList ( string $projectId ) : array | ||
| $projectId | string | The UUID of the project |
| return | array | Returns the array looks like [farm_id => name] |
public function getFarmsList($projectId)
{
$ret = [];
$res = $this->db->Execute("\n SELECT f.id, f.name FROM farms f\n JOIN farm_settings s ON s.farmid = f.id\n WHERE s.name = ? AND s.value = ?\n ", [Entity\FarmSetting::PROJECT_ID, $projectId]);
while ($rec = $res->FetchRow()) {
$ret[$rec['id']] = $rec['name'];
}
return $ret;
}