Hannes Pries - Web/Shopware/JavaScript-Developer Blog
Weil es immer eine simple Lösung gibt!

<footer style="text-align:center;">
<?php
$sm = $this->getHelperPluginManager()->getServiceLocator();
$router = $sm->get('router');
$request = $sm->get('request');
$routeMatch = $router->match($request);
$route = $routeMatch->getMatchedRouteName();
?>
<i>(Route: <?=$route?>)</i>
</footer>

if($test!=null && $test->getId()>0){
$rset = $this->select(
function (Select $select) use ($test) {
$select->where->equalTo('test_id',$category->getId());
$select->where->lessThan('test_date','CURRENT_DATETIME');
$select->order('test_date DESC')->limit(20,0);
}
);
}

<VirtualHost *:80>
DocumentRoot "C:/workspaces/php/projectXYZ"
ServerName xyz.localhost
ServerAlias www.xyz.localhost
<Directory "C:/workspaces/php/projectXYZ">
DirectoryIndex index.php
AllowOverride All
Require all granted
</Directory>
</VirtualHost>

class IndexController extends AbstractRestfulController{
private function _getResponseWithHeader(){
$response = $this->getResponse();
$response->getHeaders()
//make can accessed by *
->addHeaderLine('Access-Control-Allow-Origin','*')
//set allow methods
->addHeaderLine('Access-Control-Allow-Methods','POST PUT DELETE GET')
//change content-type
->addHeaderLine('Content-Type', 'application/json; charset=utf-8');

return $response;
}

private function _createJSONResponse($obj){
$json=new XWJSONConverter();
$response = $this->_getResponseWithHeader()->setContent($json->encode($obj));
return $response;
}

public function indexAction(){
$entity=$this->getServiceManager()->get("entityDAO")->load(1);
return $this->_createJSONResponse($entity);
}
}

/**
* @dbtable=xw_tests
*/
class XWTest{
/**
* @dbcolumn=test_id
*/
private $_id=0;
/**
* @dbcolumn=test_name
*/
private $_name="";
/**
* @dbcolumn=test_value
*/
private $_value="";

public function getId(){
return $this->_id;
}

public function setId($id){
$this->_id=$id;
}

public function getName(){
return $this->_name;
}

public function setName($name){
$this->_name=$name;
}

public function getValue(){
return $this->_value;
}

public function setValue($value){
$this->_value=$value;
}
}

'service_manager' => array(
'factories' => array(
'testDAO' => function($sm) {
return new XW\Model\DAO\XWTestDAO($sm);
}
)

$test=$this->getServiceManager()->get("testDAO")->loadTest($id);

class XWTestDAO extends TableGateway{
$this->_sm=null;

public function __construct($serviceManager){
$this->_sm=$serviceManager;
parent::__construct(
$this->_tableName,
$serviceManager->get('dbAdapter')
);
}

//eine einfache Methode zum Kopieren der Daten aus dem Array in das Objekts
private function _copyData($entity,$array){
$dbm=new XWDBMapper();
return $dbm->setValuesFromArray($entity,$array);
}

public function loadTest($id){
$entity=new XWTest();
if($id!=null && $id>0){
$rsetItem=$this->select(
array('test_id' => $id)
)->current();

if($rsetItem){
$this->_copyData($entity,$rsetItem->getArrayCopy());
}
}
return $entity;
}
}

class XWDBMapper{
public function getColumnNameFromDoc($doc){
$result=null;
if(preg_match("/@dbcolumn=[a-zA-Z0-9_]+/",$doc)){
$result=preg_replace("/^.+@dbcolumn=([a-zA-Z0-9_]+)\s.+$/Uis","$1",trim($doc));
}
return $result;
}

public function setValuesFromArray($obj,$array){
try{
$ref=new ReflectionClass(get_class($obj));
$props=$ref->getProperties();
$cnt=count($props);
for($i=0;$i<$cnt;$i++){
$prop=$props[$i];
$prop->setAccessible(true);
$column=$this->getColumnNameFromDoc($prop->getDocComment());
if($column!=null){
if(isset($array[$column])){
$prop->setValue($obj,$array[$column]);
}
}
}
}
catch(Exception $e){

}
return $obj;
}
}

public function createValueArray($obj){
$result=array();
try{
$ref=new ReflectionClass(get_class($obj));
$props=$ref->getProperties();
$cnt=count($props);
for($i=0;$i<$cnt;$i++){
$prop=$props[$i];
$prop->setAccessible(true);
$column=$this->getColumnNameFromDoc($prop->getDocComment());
if($column!=null){
$result[$column]=$prop->getValue($obj);
}
}
}
catch(Exception $e){
throw $e;
}
return $result;
}

'service_manager' => array(
'factories' => array(
/** Modelle laden */
'sModel' => function($sm) {
$model = new S\Model\S($sm);
return $model;
}
),

/**
* By default, the ServiceManager assumes all services are shared (= single instantiation),
* but you may specify a boolean false value here to indicate a new instance should be returned.
*/
'shared' => array(
'sModel' => false
)
)

'service_manager' => array(
'factories' => array(
'sDAO' => function($sm) {
return new S\Model\DAO\SDAO($sm);
}
),
)

class SDAO extends TableGateway{
private $_tableName="s";
private $_sm=null;

public function __construct($serviceManager){
$this->_sm=$serviceManager;

parent::__construct(
$this->_tableName,
$serviceManager->get('dbAdapter')
);
}

.........
}

echo "name: ".$this->getServiceLocator()->get('sDAO')->loadS($id)->getName();