clients editierbar

1 files changed, 17 insertions, 0 deletions

diff --git a/application/controllers/FilterController.php b/application/controllers/FilterController.php
index 3f9a49d..df8db07 100644
--- a/application/controllers/FilterController.php
+++ b/application/controllers/FilterController.php
@@ -265,6 +265,7 @@ class FilterController extends Zend_Controller_Action
 			#########################################################
 			// IP Adress
 			$filtertypID = 1;
+			// get it from session_table with session_id from the session
 			$ipAdress = "111.10.10.10";
 			$ipAdress = str_replace(".","",$this->fillIP($ipAdress));
 			$select = $db->select()
@@ -285,6 +286,7 @@ class FilterController extends Zend_Controller_Action
 			#########################################################
 			// Mac range
 			$filtertypID = 2;
+			// get it from session_table with session_id from the session
 			$macAdress = "00:1e:0b:27:f4:99";
 			$macAdress = str_replace(":","",$this->fillMac($ipAdress));			
 			$stmt = $db->query("SELECT * FROM pbs_filterentries WHERE 
@@ -300,30 +302,45 @@ class FilterController extends Zend_Controller_Action
 			#########################################################
 			// PoolID
 			$filtertypID = 3;
+				// get PoolID from client_ID from session_id from the session
+			$poolid = 1;
+			$stmt = $db->query("SELECT * FROM pbs_filterentries WHERE 
+							filtertypeID  = ".$filtertypID." AND
+							filtervalue = '.$poolid.' ");
+			$result = $stmt->fetchAll();
+			foreach($result as $r){
+				$set[$filtertypID][] = $r['filterID'];	
+			}
+			if($showPartResults)
+				print_a('poolID',$result,$set[$filtertypID]);
 			/*
 				If client comes from a specific pool
 			*/
 			#########################################################
 			// ClientID
 			$filtertypID = 8;
+				// get client_ID from session_id from the session
 			/*
 				If client is a specific client
 			*/
 			#########################################################
 			// BootIsoID
 			$filtertypID = 4;
+				// get BootIsoID from client_ID from session_id from the session
 			/*
 				WHERE bootiso = bootiso
 			*/
 			#########################################################
 			// MembershipID
 			$filtertypID = 5;
+				// get membership from the session
 			/*
 				user is in a defined membership
 			*/
 			#########################################################
 			// GroupID
 			$filtertypID = 6;
+				// get membership from the session
 			/*
 				user is in a defined groupID
 			*/