function editAction($bugs_id, $system_id)
{
$bugs = Bugs::findFirstById($bugs_id);
$system = Systems::findFirstById($system_id);
$form = new BugsForm($bugs);
$this->view->bugs = $bugs;
$this->view->system = $system;
$this->view->page = 'Bugs';
$this->view->form = $form;
$this->view->max_number = $this->new_number($system_id);
if ($this->request->isPost()) {
$bugs = new Bugs();
$bugs_id = $this->request->getPost('id');
$bugs = Bugs::find($activity_id);
if ($bugs->update($this->request->getPost()) == false) {
foreach ($bugs_id->getMessages() as $message) {
$this->flash->error((string) $message);
}
} else {
$this->flash->success('Edit Activity Success');
$this->response->redirect('bugs/system/' . $system_id);
}
}
}
function editAction($activity_id, $system_id)
{
$activity = Activities::findFirstById($activity_id);
$system = Systems::findFirstById($system_id);
$form = new ActivityForm($activity);
$bugs_id = new Select('bugs_id', Bugs::find(), array('useEmpty' => true));
$bugs_id->setLabel('Select Bugs');
$bugs_id->setDefault(array($activity->bugs_id));
$array = [];
foreach (Bugs::find(array('system_id = ' . $system_id)) as $bug) {
if ($bug->modules_id) {
$modules_name = '[' . $bug->modules->name . '] - ';
} else {
$modules_name = '';
}
$array[$bug->id] = $modules_name . ' ' . $bug->description;
}
$bugs_id->setOptions($array);
$form->add($bugs_id);
/*======= Modules =======*/
$modulesId = new Select('modules_id', Modules::find(array('system_id = ' . $system_id)), array('using' => array('id', 'name'), 'useEmpty' => true));
$modulesId->setLabel('Select Modules');
$modulesId->setDefault(array($activity->modules_id));
$form->add($modulesId);
$this->view->activity = $activity;
$this->view->system = $system;
$this->view->page = 'Modules';
$this->view->form = $form;
if ($this->request->isPost()) {
$activities = new Activities();
$activity_id = $this->request->getPost('id');
$activities = Activities::find($activity_id);
if ($activities->update($this->request->getPost()) == false) {
foreach ($activities->getMessages() as $message) {
$this->flash->error((string) $message);
}
} else {
$this->flash->success('Edit Activity Success');
$this->response->redirect('activity/system/' . $system_id);
}
}
}
<?php
require_once "Zend/Loader.php";
Zend_Loader::registerAutoload();
$db = Zend_Db::factory('pdo_mysql', array('username' => 'root', 'password' => 'tribal', 'host' => 'localhost', 'dbname' => 'zfunittests'));
$db->getProfiler()->setEnabled(true);
Zend_Db_Table_Abstract::setDefaultAdapter($db);
class Bugs extends Zend_Db_Table_Abstract
{
protected $_schema = "zfunittests";
protected $_name = 'bugs';
}
class Products extends Zend_Db_Table_Abstract
{
protected $_schema = "zfunittests";
protected $_name = "products";
}
class BugsProducts extends Zend_Db_Table_Abstract
{
protected $_schema = "zfunittests";
protected $_name = "bugs_products";
protected $_referenceMap = array('Bug' => array('columns' => 'bug_id', 'refTableClass' => 'Bugs', 'refColumns' => array('bug_id'), 'onDelete' => self::CASCADE, 'onUpdate' => self::CASCADE), 'Product' => array('columns' => array('product_id'), 'refTableClass' => 'Products', 'refColumns' => array('product_id'), 'onDelete' => self::CASCADE, 'onUpdate' => self::CASCADE));
}
$bugs = new Bugs();
$bug = $bugs->find(1)->current();
$products = $bug->findManyToManyRowset("Products", "BugsProducts");
var_dump($db->getProfiler()->getQueryProfiles());
