diff options
-rw-r--r-- | .zfproject.xml | 12 | ||||
-rw-r--r-- | application/controllers/PoolController.php | 22 | ||||
-rw-r--r-- | application/models/PoolMapper.php | 15 | ||||
-rw-r--r-- | application/views/scripts/pool/createpool.phtml | 1 | ||||
-rw-r--r-- | application/views/scripts/pool/deletepool.phtml | 1 | ||||
-rw-r--r-- | application/views/scripts/pool/editpool.phtml | 1 | ||||
-rw-r--r-- | application/views/scripts/pool/index.phtml | 37 | ||||
-rw-r--r-- | pbs-data.sql | 4 |
8 files changed, 86 insertions, 7 deletions
diff --git a/.zfproject.xml b/.zfproject.xml index adfe5d7..ea102b1 100644 --- a/.zfproject.xml +++ b/.zfproject.xml @@ -61,6 +61,9 @@ </controllerFile> <controllerFile controllerName="Pool"> <actionMethod actionName="index"/> + <actionMethod actionName="createpool"/> + <actionMethod actionName="deletepool"/> + <actionMethod actionName="editpool"/> </controllerFile> </controllersDirectory> <formsDirectory> @@ -242,6 +245,15 @@ <viewControllerScriptsDirectory forControllerName="Client"> <viewScriptFile forActionName="removeclient"/> </viewControllerScriptsDirectory> + <viewControllerScriptsDirectory forControllerName="Pool"> + <viewScriptFile forActionName="createpool"/> + </viewControllerScriptsDirectory> + <viewControllerScriptsDirectory forControllerName="Pool"> + <viewScriptFile forActionName="deletepool"/> + </viewControllerScriptsDirectory> + <viewControllerScriptsDirectory forControllerName="Pool"> + <viewScriptFile forActionName="editpool"/> + </viewControllerScriptsDirectory> </viewScriptsDirectory> <viewHelpersDirectory/> <viewFiltersDirectory enabled="false"/> diff --git a/application/controllers/PoolController.php b/application/controllers/PoolController.php index 795fe3a..f9e54be 100644 --- a/application/controllers/PoolController.php +++ b/application/controllers/PoolController.php @@ -10,9 +10,31 @@ class PoolController extends Zend_Controller_Action public function indexAction() { + $poolMapper = new Application_Model_PoolMapper(); + $this->view->pools = $poolMapper->fetchAll(); + } + + public function createpoolAction() + { + // action body + } + + public function deletepoolAction() + { + // action body + } + + public function editpoolAction() + { // action body } } + + + + + + diff --git a/application/models/PoolMapper.php b/application/models/PoolMapper.php index f9be34f..e2d351a 100644 --- a/application/models/PoolMapper.php +++ b/application/models/PoolMapper.php @@ -32,13 +32,16 @@ class Application_Model_PoolMapper public function save(Application_Model_Pool $pol) { - $data = array('poolID'=> $pol->getPoolID() ,'title'=> $pol->getTitle() ,'description'=> $pol->getDescription() ,'location'=> $pol->getLocation() ); + $data = array('poolID'=> $pol->getID() , + 'title'=> $pol->getTitle() , + 'description'=> $pol->getDescription() , + 'location'=> $pol->getLocation() ); if (null === ($id = $pol->getID()) ) { - unset($data['polID']); + unset($data['poolID']); $this->getDbTable()->insert($data); } else { - $this->getDbTable()->update($data, array('polID = ?' => $id)); + $this->getDbTable()->update($data, array('poolID = ?' => $id)); } } @@ -47,7 +50,7 @@ class Application_Model_PoolMapper if (null === ($id = $pol->getID()) ) { return; } else { - $this->getDbTable()->delete(array('polID = ?' => $id)); + $this->getDbTable()->delete(array('poolID = ?' => $id)); } } @@ -60,7 +63,7 @@ class Application_Model_PoolMapper $row = $result->current(); - $pol->setPoolID($row->poolID)->setTitle($row->title)->setDescription($row->description)->setLocation($row->location); + $pol->setID($row->poolID)->setTitle($row->title)->setDescription($row->description)->setLocation($row->location); } public function fetchAll() @@ -70,7 +73,7 @@ class Application_Model_PoolMapper foreach ($resultSet as $row) { $entry = new Application_Model_Pool(); - $entry->setPoolID($row->poolID)->setTitle($row->title)->setDescription($row->description)->setLocation($row->location); + $entry->setID($row->poolID)->setTitle($row->title)->setDescription($row->description)->setLocation($row->location); $entries[] = $entry; } diff --git a/application/views/scripts/pool/createpool.phtml b/application/views/scripts/pool/createpool.phtml new file mode 100644 index 0000000..3d7f8ca --- /dev/null +++ b/application/views/scripts/pool/createpool.phtml @@ -0,0 +1 @@ +<br /><br /><center>View script for controller <b>Pool</b> and script/action name <b>createpool</b></center>
\ No newline at end of file diff --git a/application/views/scripts/pool/deletepool.phtml b/application/views/scripts/pool/deletepool.phtml new file mode 100644 index 0000000..622e663 --- /dev/null +++ b/application/views/scripts/pool/deletepool.phtml @@ -0,0 +1 @@ +<br /><br /><center>View script for controller <b>Pool</b> and script/action name <b>deletepool</b></center>
\ No newline at end of file diff --git a/application/views/scripts/pool/editpool.phtml b/application/views/scripts/pool/editpool.phtml new file mode 100644 index 0000000..c70464e --- /dev/null +++ b/application/views/scripts/pool/editpool.phtml @@ -0,0 +1 @@ +<br /><br /><center>View script for controller <b>Pool</b> and script/action name <b>editpool</b></center>
\ No newline at end of file diff --git a/application/views/scripts/pool/index.phtml b/application/views/scripts/pool/index.phtml index 5266a4e..989cf41 100644 --- a/application/views/scripts/pool/index.phtml +++ b/application/views/scripts/pool/index.phtml @@ -1 +1,36 @@ -<br /><br /><center>View script for controller <b>Pool</b> and script/action name <b>index</b></center>
\ No newline at end of file +<h1>Pools</h1> + +<?php if ($this->pools): ?> + + <!-- A table of filters. --> + <table border=1> + <tr> + <th>poolID</th> + <th>Title</th> + <th>Description</th> + <th>Location</th> + </tr> + <?php foreach ($this->pools as $pool): ?> + <tr class='pool'> + <td><?php echo $this->escape($pool->getID()) ?></td> + <td><?php echo $this->escape($pool->getTitle()) ?></td> + <td><?php echo $this->escape($pool->getDescription()) ?></td> + <td><?php echo $this->escape($pool->getLocation()) ?></td> + <td><a href="<?php echo $this->url( + array( + 'controller' => 'pool', + 'action' => 'removepool', + 'poolID' => $pool->getID() + ), + 'default', + true) ?>">remove pool</a></td> + </tr> + <?php endforeach ?> + </table> + +<?php else: ?> + + + <p>There are no pools to display.</p> + +<?php endif;?> diff --git a/pbs-data.sql b/pbs-data.sql index e3cef5f..1aec562 100644 --- a/pbs-data.sql +++ b/pbs-data.sql @@ -44,3 +44,7 @@ INSERT INTO `pbs_client` (`clientID`, `macadress`, `hardwarehash`) VALUES (9, '24:64:26:9a:92:90', '695610ee509c060b1fca9c8011529af4'), (10, '84:34:26:9a:92:90', 'a3562c8cad2a4fa4fc11656025dc911b'); +INSERT INTO `pbs`.`pbs_pool` (`poolID`, `title`, `description`, `location`) VALUES +(NULL, 'Pool 1', 'Description 1', 'Keller'), +(NULL, 'Pool 2', 'Description 2', 'Keller'); + |