/**
* Prepare data for autocompletion
*
* @param mixed $data
* @param boolean $keepLayouts
* @return string
*/
public function prepareAutoCompletion($data, $keepLayouts = false)
{
if (!$data instanceof Zend_Dojo_Data) {
require_once 'Zend/Dojo/Data.php';
$items = array();
foreach ($data as $key => $value) {
$items[] = array('label' => $value, 'name' => $value);
}
$data = new Zend_Dojo_Data('name', $items);
}
if (!$keepLayouts) {
require_once 'Zend/Controller/Action/HelperBroker.php';
Zend_Controller_Action_HelperBroker::getStaticHelper('viewRenderer')->setNoRender(true);
require_once 'Zend/Layout.php';
$layout = Zend_Layout::getMvcInstance();
if ($layout instanceof Zend_Layout) {
$layout->disableLayout();
}
}
$response = Zend_Controller_Front::getInstance()->getResponse();
$response->setHeader('Content-Type', 'application/json');
return $data->toJson();
}
/**
*
* @param string $pID, $pData, $pLabel
* @return void
*/
public function _store($pID, $pData, $pLabel)
{
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$zd = new Zend_Dojo_Data($pID, $pData, $pLabel);
echo $zd->toJson();
}
public function getAction()
{
$this->rescanItems();
//@TODO: handle the query with $this->_getParam(...)
$data = new Zend_Dojo_Data('id', $this->_items, "name");
echo $data->toJson();
}
public function tracksAction()
{
$artistId = $this->_request->getParam('id');
$releaseTable = new App_Table_Release();
$releases = $releaseTable->findPublishedByArtist($artistId, false)->toArray(true);
$data = new Zend_Dojo_Data('id', $releases, 'releases');
echo $data->toJson();
}
/**
* List action
*
* @return void
*/
public function listAction()
{
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender();
$q = Doctrine_Query::create()->from('Worklog w');
$data = new Zend_Dojo_Data();
$data->setIdentifier('id')->addItems($q->execute(array(), Doctrine::HYDRATE_ARRAY));
echo $data->toJson();
}
public function getAction()
{
// Get the Parameters
$pId = $this->getRequest()->getParam("id");
// Get the DatabaseAdapter
$db = $this->_helper->database->getAdapter();
// see http://framework.zend.com/manual/en/zend.db.select.html
// you could also write the query as plain string lie SELECT * FROM user;
//
$select = $db->select()->from('user')->where('id = ?', $pId);
// sql-injection save quotation
$data = new Zend_Dojo_Data('id', $db->fetchAll($select), 'name');
echo $data->toJson();
}
