/**
* @author KienNN
* @param \System\Model\Controller $controller
*/
public function get($controller)
{
$dbAdapter = $this->getDbAdapter();
if (!$controller->getId() && (!$controller->getModuleId() || !$controller->getName())) {
return null;
}
$dbAdapter = $this->getDbAdapter();
$select = $this->getDbSql()->select(self::TABLE_NAME);
if ($controller->getId()) {
$select->where(['id' => $controller->getId()]);
}
if ($controller->getModuleId() && $controller->getName()) {
$select->where(['moduleId' => $controller->getModuleId(), 'name' => $controller->getName()]);
}
$select->limit(1);
$query = $this->getDbSql()->buildSqlString($select);
$rows = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
if ($rows->count()) {
$controller->exchangeArray((array) $rows->current());
return $controller;
}
return null;
}
