function getAll($include_hidden = false) { $customers = array(); $pdo = PDOBuilder::getPDO(); $db = DB::get(); $sql = null; if ($include_hidden) { $sql = "SELECT * FROM CUSTOMERS"; } else { $sql = "SELECT * FROM CUSTOMERS WHERE (EXPIREDATE IS NULL OR EXPIREDATE > NOW()) AND VISIBLE = " . $db->true(); } $sql .= " ORDER BY NAME ASC"; foreach ($pdo->query($sql) as $dbCust) { $cust = CustomersService::build($dbCust); $customers[] = $cust; } return $customers; }