FilterController Evaluate funktioniert

1 files changed, 125 insertions, 0 deletions

diff --git a/pbs-newdata.sql b/pbs-newdata.sql
new file mode 100644
index 0000000..48a1dc6
--- /dev/null
+++ b/pbs-newdata.sql
@@ -0,0 +1,125 @@
+USE pbs;
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+-- Adding person test//test
+INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`) VALUES
+(1, 'Herr', 'Test 1', 'Test 1', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a');
+-- Adding person test2//test
+INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`) VALUES
+(2, 'Herr', 'Test 2', 'Test 2', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test2', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a');
+
+-- Adding group
+INSERT INTO `pbs`.`pbs_group` (`groupID` ,`title` ,`description`)VALUES (1 , 'Group 1', NULL);
+
+-- Adding role
+INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (1, '1', 'Role 1', NULL);
+INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (2, '1', 'Role 2', NULL);
+
+-- Adding memberships
+INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`) VALUES (1, '1', '1', '1');
+INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`) VALUES (2, '1', '2', '2');
+
+-- Adding clients
+INSERT INTO `pbs_client` (`clientID`, `macadress`, `hardwarehash`) VALUES
+(1, '00:00:00:00:00:10', 'ea9b82d9de911bc2d3cd23f53a6cab48'),
+(2, '00:00:00:00:10:00', '1e2b1599710fbbef0dc789e8cfe12455'),
+(3, '00:00:00:10:10:00', '8f6209ca3d6b35e223a11c249d1b69fc'),
+(4, '00:00:10:00:00:00', 'e17ab09f3586464f19629e2e8b1e9a9d'),
+(5, '00:10:00:00:00:00', '9bf70279d283b85440c2031c19bb6812'),
+(6, '10:00:00:00:00:00', 'ad3bce4464a6267441ec144744439c7e'),
+(7, '00:55:00:55:00:55', 'e8d7e80d79f224771b7a3a0af4e02748'),
+(8, '66:00:66:00:66:00', 'ded66ce272f384e9e386c1b57ded3e4d'),
+(9, '00:ff:ff:ff:ff:ff', '695610ee509c060b1fca9c8011529af4'),
+(10, '00:22:00:22:00:22', 'a3562c8cad2a4fa4fc11656025dc911b');
+
+-- Adding config
+INSERT INTO `pbs_config` (`configID`, `title`, `groupID`, `membershipID`, `shellscript`, `created`) VALUES
+(1, 'Config 1', 1, 1, 'shellscript 1', '1299693677'),
+(2, 'Config 2', 1, 1, 'shellskript 2', '1299693690'),
+(3, 'Config 3', 1, 1, 'shellskript 3', '1299693690'),
+(4, 'Config 4', 1, 1, 'shellskript 4', '1299693690'),
+(5, 'Config 5', 1, 1, 'shellskript 5', '1299693690');
+
+-- Adding bootos
+INSERT INTO `pbs_bootos` (`bootosID`, `configID`, `groupID`, `membershipID`, `title`, `description`, `path_init`, `path_kernel`, `defaultkcl`, `created`, `expires`, `public`) VALUES
+(1, 1, 1, 1, 'BootOs 1', 'Description 1', 'initpath 1', 'kernelpath 1', 'default kcl 1', '1299693782', '2012-03-09', 0),
+(2, 1, 1, 1, 'BootOs 2', 'Description 2', 'initpath 2', 'kernelpath 2', 'default kcl 2', '1299693782', '2012-03-09', 0),
+(3, 1, 1, 1, 'BootOs 3', 'Description 3', 'initpath 3', 'kernelpath 3', 'default kcl 3', '1299693782', '2012-03-09', 0),
+(4, 1, 1, 1, 'BootOs 4', 'Description 4', 'initpath 4', 'kernelpath 4', 'default kcl 4', '1299693782', '2012-03-09', 0),
+(5, 1, 1, 1, 'BootOs 5', 'Description 5', 'initpath 5', 'kernelpath 5', 'default kcl 5', '1299693782', '2012-03-09', 0),
+(6, 1, 1, 1, 'BootOs 6', 'Description 6', 'initpath 6', 'kernelpath 6', 'default kcl 6', '1299693782', '2012-03-09', 0),
+(7, 1, 1, 1, 'BootOs 7', 'Description 7', 'initpath 7', 'kernelpath 7', 'default kcl 7', '1299693782', '2012-03-09', 0),
+(8, 1, 1, 1, 'BootOs 8', 'Description 8', 'initpath 8', 'kernelpath 8', 'default kcl 8', '1299693782', '2012-03-09', 0),
+(9, 1, 1, 1, 'BootOs 9', 'Description 9', 'initpath 9', 'kernelpath 9', 'default kcl 9', '1299693782', '2012-03-09', 0),
+(10, 1, 1, 1, 'BootOs 10', 'Description 10', 'initpath 10', 'kernelpath 10', 'default kcl 10', '1299693782', '2012-03-09', 0);
+
+-- Adding bootiso
+INSERT INTO `pbs_bootiso` (`bootisoID`, `title`, `membershipID`, `groupID`, `path`, `serialnumber`, `created`, `expires`, `public`) VALUES
+(1, 'BootIso 1', 1, 1, 'Path 1', 123456789, '1299693879', '2012-03-09', 0),
+(2, 'BootIso 2', 1, 1, 'Path 2', 2147483647, '1299693899', '2012-03-09', 0),
+(3, 'BootIso 3', 1, 1, 'Path 3', 2147483647, '1299693899', '2012-03-09', 0);
+
+-- Adding Pools
+INSERT INTO `pbs_pool` (`poolID`, `title`, `description`, `location`) VALUES
+(1, 'Pool 1', 'Description 1', 'Keller'),
+(2, 'Pool 2', 'Description 2', 'EG'),
+(3, 'Pool 3', 'Description 3', '1 OG'),
+(4, 'Pool 4', 'Description', '2 OG');
+
+-- Adding BootOs to BootMenus
+INSERT INTO `pbs_bootmenuentries` (`bootmenuentriesID`, `bootosID`, `bootmenuID`, `title`, `kcl`, `configID`, `order`) VALUES
+(1, 1, 1, 'Select BootOs 1', 'kcl 1', 1, 0),
+(2, 1, 1, 'Select BootOs 1', 'kcl 2', 2, 1),
+(3, 2, 1, 'Select BootOs 2', 'kcl 3', 2, 2),
+(4, 5, 2, 'Select BootOs 5', 'kcl 5', 2, 0),
+(5, 4, 2, 'Select BootOs 4', 'kcl 4', 2, 1),
+(6, 10, 3, 'Select BootOs 10', 'kcl 10', 3, 0),
+(7, 8, 3, 'Select BootOs 8', 'kcl 8', 4, 1),
+(8, 1, 2, 'Select BootOs 7', 'kcl 7', 5, 2),
+(9, 1, 5, 'Select BootOs 3', 'kcl 3', 4, 0),
+(10, 9, 4, 'Select BootOs 9', 'kcl 9', 3, 0),
+(11, 7, 4, 'Select BootOs 7', 'kcl 7', 5, 1);
+
+-- Adding client to pools (poolentries)
+INSERT INTO `pbs_poolentries` (`poolentriesID`, `poolID`, `clientID`) VALUES
+(1, 1, 1),
+(2, 1, 2),
+(3, 1, 3),
+(4, 1, 4),
+(5, 2, 5),
+(6, 2, 6),
+(7, 3, 7),
+(8, 3, 8),
+(9, 4, 9),
+(10, 4, 10);
+
+-- Adding Bootmenus
+INSERT INTO `pbs_bootmenu` (`bootmenuID`, `membershipID`, `groupID`, `title`, `created`) VALUES
+(1, 1, 1, 'Bootmenu 1', '1299694422'),
+(2, 1, 1, 'Bootmenu 2', '1299694433'),
+(3, 1, 1, 'Bootmenu 3', '1299694441'),
+(4, 1, 1, 'Bootmenu 4', '1299694454'),
+(5, 1, 1, 'Bootmenu 5', '1299694461');
+
+-- Adding Sessions
+INSERT INTO `pbs_session` (`sessionID`, `clientID`, `bootosID`, `bootisoID`, `time`, `ip`, `ip6`) VALUES
+(1, 1, NULL, 1, '1299684000', '132.230.5.6', ''),
+(2, 9, NULL, 2, '1299684000', '132.230.10.2', ''),
+(3, 10, NULL, 1, '1299648000', '132.20.20.2', ''),
+(4, 7, NULL, 3, '1299676800', '84.23.56.86', ''),
+(5, 4, NULL, 3, '1299674340', '70.81.94.222', ''),
+(6, 5, NULL, 3, '1299683100', '210.84.65.2', '');
+
+-- Adding Filter
+INSERT INTO `pbs_filter` (`filterID`, `membershipID`, `groupID`, `bootmenuID`, `title`, `description`, `created`, `priority`) VALUES
+(1, 1, 1, 1, 'Filter 1', 'Innerhalb der Uni', '1299697337', 10),
+(2, 1, 1, 5, 'Filter 2', 'Ausserhalb der Uni', '1299697073', 20),
+(3, 1, 1, 4, 'Filter 3', 'Desc3', '1299697277', 5);
+
+-- Adding Filterentries
+INSERT INTO `pbs_filterentries` (`filterentriesID`, `filterID`, `filtertypeID`, `filtervalue`, `filtervalue2`) VALUES
+(1, 1, 7, '08-00', '18-00'),
+(2, 2, 1, '001.001.001.001', '132.229.255.255'),
+(3, 2, 1, '132.231.001.001', '255.255.255.255'),
+(4, 1, 1, '132.230.001.001', '132.230.255.255'),
+(5, 3, 3, '1', '');