public function getSessionVar()
{
$sessionVar = [];
$sql_select = "SELECT sessionName, varName, varValue, LastUpdate\n FROM sessionvar";
$stmt = $conn->query($sql_select);
$returnedList = $stmt->fetchAll();
if (count($returnedList) > 0) {
foreach ($returnedList as $group) {
$curGroup = new Group($group['group_name']);
$curGroup->setID($group['groupid']);
$curGroup->setType($group['group_type']);
$curGroup->setWeb($group['group_web']);
$listOfGroups[] = $curGroup;
}
}
return $listOfGroups;
}
public static function retrieveGroupList($conn)
{
$listOfGroups;
$sql_select = "SELECT groupid, group_name, group_type, group_web, marked_for_deletion\n FROM group_tbl\n ORDER BY group_type";
$stmt = $conn->query($sql_select);
$returnedList = $stmt->fetchAll();
if (count($returnedList) > 0) {
foreach ($returnedList as $group) {
if ($group['marked_for_deletion'] == true) {
continue;
}
$curGroup = new Group($group['group_name']);
$curGroup->setID($group['groupid']);
$curGroup->setType($group['group_type']);
$curGroup->setWeb($group['group_web']);
$listOfGroups[] = $curGroup;
}
}
return $listOfGroups;
}
