/**
* @covers Zend\Db\ResultSet\HydratingResultSet::toArray
* @todo Implement testToArray().
*/
public function testToArray()
{
$hydratingRs = new HydratingResultSet();
$hydratingRs->initialize(array(array('id' => 1, 'name' => 'one')));
$obj = $hydratingRs->toArray();
$this->assertInternalType('array', $obj);
}
public function getPagesList()
{
$stmt = $this->_dbAdapter->createStatement();
$stmt->prepare('CALL `pages/get_slist`()');
$result = $stmt->execute();
$resultSet = new HydratingResultSet(new Reflection(), new Page());
$resultSet->initialize($result);
return $resultSet;
}
public function __construct($table, Adapter $db, $strategies = array())
{
$hydrator = new ArraySerializable();
foreach ($strategies as $field => $strategy) {
$hydrator->addStrategy($field, $strategy);
}
$resultSet = new HydratingResultSet();
$resultSet->setHydrator($hydrator);
parent::__construct($table, $db, null, $resultSet);
}
/**
* gets the resultSet
*
* @return HydratingResultSet
*/
protected function getResultSet()
{
if (!$this->resultSetPrototype instanceof HydratingResultSet) {
$resultSetPrototype = new HydratingResultSet();
$resultSetPrototype->setHydrator($this->getHydrator());
$resultSetPrototype->setObjectPrototype($this->getModel());
$this->resultSetPrototype = $resultSetPrototype;
}
return clone $this->resultSetPrototype;
}
public function createService(ServiceLocatorInterface $serviceLocator)
{
$db = $serviceLocator->get('Zend\\Db\\Adapter\\Adapter');
$resultSetPrototype = new HydratingResultSet();
$resultSetPrototype->setHydrator(new ObjectProperty());
$resultSetPrototype->setObjectPrototype(new ForgotPassword());
$tableGateway = new TableGateway('vc_forget_tokens', $db, array(), $resultSetPrototype);
$table = new ForgotPasswordTable($tableGateway);
return $table;
}
public function createService(ServiceLocatorInterface $serviceLocator)
{
$db = $serviceLocator->get('Zend\\Db\\Adapter\\Adapter');
$resultSetPrototype = new HydratingResultSet();
$resultSetPrototype->setHydrator(new ObjectProperty());
$resultSetPrototype->setObjectPrototype(new Resource());
$tableGateway = new TableGateway('resource', $db, null, $resultSetPrototype);
$table = new ResourceTable($tableGateway);
return $table;
}
public function createService(ServiceLocatorInterface $serviceLocator)
{
$db = $serviceLocator->get('Zend\\Db\\Adapter\\Adapter');
$resultSetPrototype = new HydratingResultSet();
$resultSetPrototype->setHydrator(new ObjectProperty());
$resultSetPrototype->setObjectPrototype(new ViewProfileCount());
$tableGateway = new TableGateway('vc_view_profiles_count', $db, array(), $resultSetPrototype);
$table = new ViewProfileCountTable($tableGateway);
return $table;
}
public function createService(ServiceLocatorInterface $serviceLocator)
{
$db = $serviceLocator->get('Zend\\Db\\Adapter\\Adapter');
$resultSetPrototype = new HydratingResultSet();
$resultSetPrototype->setHydrator(new ObjectProperty());
$resultSetPrototype->setObjectPrototype(new SearchCategoriesList());
$tableGateway = new TableGateway('search_categories_list', $db, array(), $resultSetPrototype);
$table = new SearchCategoriesListTable($tableGateway);
return $table;
}
public function createService(ServiceLocatorInterface $serviceLocator)
{
$db = $serviceLocator->get('Zend\\Db\\Adapter\\Adapter');
$resultSetPrototype = new HydratingResultSet();
$resultSetPrototype->setHydrator(new ObjectProperty());
$resultSetPrototype->setObjectPrototype(new SettingFlexibleType());
$tableGateway = new TableGateway('setting_flexible_type', $db, array(), $resultSetPrototype);
$table = new SettingFlexibleTypeTable($tableGateway);
return $table;
}
public function createService(ServiceLocatorInterface $serviceLocator)
{
$db = $serviceLocator->get('Zend\\Db\\Adapter\\Adapter');
$resultSetPrototype = new HydratingResultSet();
$resultSetPrototype->setHydrator(new ObjectProperty());
$resultSetPrototype->setObjectPrototype(new LoginLinkExpired());
$tableGateway = new TableGateway('login_link_expired', $db, array(), $resultSetPrototype);
$table = new LoginLinkExpiredTable($tableGateway);
return $table;
}
public function createService(ServiceLocatorInterface $serviceLocator)
{
$db = $serviceLocator->get('Zend\\Db\\Adapter\\Adapter');
$resultSetPrototype = new HydratingResultSet();
$resultSetPrototype->setHydrator(new ObjectProperty());
$resultSetPrototype->setObjectPrototype(new JsPlumbGrid());
$tableGateway = new TableGateway('js_plumb_grid', $db, array(), $resultSetPrototype);
$table = new JsPlumbGridTable($tableGateway);
return $table;
}
public function createService(ServiceLocatorInterface $serviceLocator)
{
$db = $serviceLocator->get('Zend\\Db\\Adapter\\Adapter');
$resultSetPrototype = new HydratingResultSet();
$resultSetPrototype->setHydrator(new ObjectProperty());
$resultSetPrototype->setObjectPrototype(new UserSkills());
$tableGateway = new TableGateway('vc_user_skills', $db, array(), $resultSetPrototype);
$table = new UserSkillsTable($tableGateway);
return $table;
}
/**
* @return Route[]
*/
public function findActive()
{
$sql = new Sql($this->dbAdapter);
$select = $sql->select($this->table)->where('active = 1');
$result = $sql->prepareStatementForSqlObject($select)->execute();
if ($result->isQueryResult() && $result->getAffectedRows()) {
$resultSet = new HydratingResultSet($this->hydrator, $this->model);
return $resultSet->initialize($result);
}
return [];
}
/**
* @return JsonModel
*/
public function contohGetList()
{
$sm = $this->getServiceLocator();
$table = $sm->get('Organisasi\\DbTable\\StrukturOrganisasi');
// defined in module.php
$result = $table->select()->toArray();
$resultSet = new HydratingResultSet(new ReflectionHydrator(), new StrukturOrganisasi());
$resultSet->initialize($result);
$a = array('data' => $result);
return new JsonModel($a);
}
public function fetchAll()
{
$select = $this->sql->select();
$stmt = $this->sql->prepareStatementForSqlObject($select);
$results = $stmt->execute();
$entity = new ImpostoEntity();
$classMethods = new ClassMethods();
$resultset = new HydratingResultSet($classMethods, $entity);
$resultset->initialize($results);
return $resultset;
}
public function createService(ServiceLocatorInterface $serviceLocator)
{
$db = $serviceLocator->get('Zend\\Db\\Adapter');
$entity = new User();
$set = new HydratingResultSet();
$set->setObjectPrototype($entity);
$set->setHydrator(new ClassMethods());
$tableGateway = new TableGateway('User', $db, null, $set);
$mapper = new UserMapper($tableGateway);
return $mapper;
}
public function fetchAll($filter)
{
$select = new Select('album');
if (isset($filter['title'])) {
$select->where(array('title LIKE ?' => '%' . $filter['title'] . '%'));
}
$resultset = new HydratingResultSet();
$resultset->setObjectPrototype(new AlbumEntity());
$paginatorAdapter = new DbSelect($select, $this->adapterSlave, $resultset);
$collection = new AlbumCollection($paginatorAdapter);
return $collection;
}
/**
* {@inheritDoc}
*/
public function findAll()
{
$sql = new Sql($this->dbAdapter);
$select = $sql->select('posts');
$stmt = $sql->prepareStatementForSqlObject($select);
$result = $stmt->execute();
if ($result instanceof ResultInterface && $result->isQueryResult()) {
$resultSet = new HydratingResultSet($this->hydrator, $this->postPrototype);
return $resultSet->initialize($result);
}
return array();
}
public function fetchAll()
{
$select = $this->sql->select();
$select->order(array('user ASC', 'name ASC'));
$statement = $this->sql->prepareStatementForSqlObject($select);
$results = $statement->execute();
$entityPrototype = new BuildingEntity();
$hydrator = new ClassMethods();
$resultset = new HydratingResultSet($hydrator, $entityPrototype);
$resultset->initialize($results);
return $resultset;
}
public function getUsersList()
{
$sql = new Sql($this->getAdaptor());
$select = $sql->select('user');
$statement = $sql->prepareStatementForSqlObject($select);
$result = $statement->execute();
if ($result instanceof ResultInterface && $result->isQueryResult()) {
$resultSet = new HydratingResultSet($this->getHydrator(), $this->getProtoType());
return $resultSet->initialize($result);
}
return array();
}
/**
* {@inheritdoc}
*/
public function findAll()
{
$sql = new Sql($this->dbAdapter);
$select = $sql->select('posts');
$stmt = $sql->prepareStatementForSqlObject($select);
$result = $stmt->execute();
if ($result instanceof ResultInterface && $result->isQueryResult()) {
$resultSet = new HydratingResultSet(new ClassMethods(), new Post());
return $resultSet->initialize($result);
}
return [];
}
/**
* Fetches rooms.
* @return Zend\Db\ResultSet\HydratingResultSet collection of Room obj's
*/
public function fetch()
{
$adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter');
$sql = new Sql($adapter);
$select = $sql->select('room')->offset($this->offset)->limit($this->limit);
$statement = $sql->prepareStatementForSqlObject($select);
$res = $statement->execute();
$resultSet = new HydratingResultSet(new hydrator(), new Room());
if ($res instanceof ResultInterface && $res->isQueryResult()) {
$resultSet->initialize($res);
}
return $resultSet;
}
public function fetchAll($limit = 3)
{
$select = $this->sql->select();
$select->order("date DESC");
$select->limit($limit);
$statement = $this->sql->prepareStatementForSqlObject($select);
$results = $statement->execute();
$entityPrototype = new TumblrEntity();
$hydrator = new ClassMethods();
$resultset = new HydratingResultSet($hydrator, $entityPrototype);
$resultset->initialize($results);
return $resultset;
}
public function fetchAll($blvdId)
{
$select = $this->sql->select();
$select->where(array("blvd_id" => $blvdId));
$statement = $this->sql->prepareStatementForSqlObject($select);
$results = $statement->execute();
$entityPrototype = new BlvdCategoryEntity();
$hydrator = new ClassMethods();
$resultset = new HydratingResultSet($hydrator, $entityPrototype);
$resultset->initialize($results);
$resultset->buffer();
return $resultset;
}
/**
* @param $postId int
*
* @return Post|null
*/
public function findById($postId)
{
$sql = new \Zend\Db\Sql\Sql($this->adapter);
$select = $sql->select();
$select->columns(array('id', 'title', 'slug', 'content', 'created'))->from(array('p' => 'news'))->join(array('c' => 'category'), 'c.id = p.category_id', array('category_id' => 'id', 'name', 'category_slug' => 'slug'), $select::JOIN_INNER)->where(array('p.id' => $postId));
$statement = $sql->prepareStatementForSqlObject($select);
$results = $statement->execute();
$hydrator = new AggregateHydrator();
$hydrator->add(new PostHydrator());
$hydrator->add(new CategoryHydrator());
$resultSet = new HydratingResultSet($hydrator, new Post());
$resultSet->initialize($results);
return $resultSet->count() > 0 ? $resultSet->current() : null;
}
public function getAttributes($id)
{
$select = $this->sql->select();
$select->join('lead_attributes', 'lead_attribute_values.attribute_id = lead_attributes.id', array('attribute_name'));
$select->where(array('entity_id' => $id));
$select->order(array("id ASC"));
$entityPrototype = new AttributeEntity();
$hydrator = new ClassMethods();
$resultset = new HydratingResultSet($hydrator, $entityPrototype);
$statement = $this->sql->prepareStatementForSqlObject($select);
$results = $statement->execute();
$resultset->initialize($results);
return $resultset;
}
public function getPostList($page, $limit)
{
$sql = new Sql($this->getAdaptor());
$select = $sql->select(array('p' => 'posts'));
$select->join(array('u' => 'user'), 'p.author_id=u.user_id', array('author' => 'display_name'));
$select->limit(intval($limit));
$select->offset(intval($limit) * (intval($page) - 1));
$statement = $sql->prepareStatementForSqlObject($select);
$result = $statement->execute();
if ($result instanceof ResultInterface && $result->isQueryResult()) {
$resultSet = new HydratingResultSet($this->getHydrator(), $this->getProtoType());
return $resultSet->initialize($result);
}
return array();
}
/**
* @return array|PostInterface[]
*/
public function findAll()
{
$sql = new Sql($this->dbAdapter);
$select = $sql->select('posts');
$stmt = $sql->prepareStatementForSqlObject($select);
$result = $stmt->execute();
if ($result instanceof ResultInterface && $result->isQueryResult()) {
//$resultSet = new ResultSet();
//$resultSet = new HydratingResultSet(new \Zend\Stdlib\Hydrator\ClassMethods(), new \Blog\Model\Post());
$resultSet = new HydratingResultSet($this->hydrator, $this->postPrototype);
// \Zend\Debug\Debug::dump($resultSet->initialize($result));die();
return $resultSet->initialize($result);
}
return array();
}
/**
* Fetches equipments of the room.
* @see init()
* @return \Zend\Db\ResultSet\HydratingResultSet of Equipment objects
*/
public function fetch()
{
if (!$this->is_init()) {
throw new \Exception("Equipments collection uninitiated.");
}
$adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter');
$sql = new Sql($adapter);
$select = $sql->select('equipment')->where(array('cid' => $this->room->id))->offset($this->offset)->limit($this->limit);
$statement = $sql->prepareStatementForSqlObject($select);
$res = $statement->execute();
$hydratedRes = new HydratingResultSet(new Hydrator(), new Equipment());
if ($res instanceof ResultInterface && $res->isQueryResult()) {
$hydratedRes->initialize($res);
}
return $hydratedRes;
}
public function fetchAll($paging = false, $sort = "timecreated", $order = "DESC", $filters = array())
{
$select = $this->sql->select();
$select->order(array("{$sort} {$order}"));
$where = array();
if ($filters) {
foreach ($filters as $filter => $condition) {
if (strlen($condition)) {
switch ($filter) {
case 'timecreated':
case 'daterange':
list($from, $to) = array_map(function ($d, $i) {
$t = $i == 'from' ? '00:00:00' : '23:59:59';
return date('Y-m-d ' . $t, strtotime($d));
}, explode("-", $condition), ['from', 'to']);
$where[] = "lead.timecreated between '{$from}' and '{$to}'";
break;
case 'status':
$where[] = "lead.submitted = {$condition}";
break;
case 'sites':
$where[] = "lead.formid = {$condition}";
break;
default:
break;
}
}
}
if ($where) {
$select->where($where);
}
}
$entityPrototype = new LeadEntity();
$hydrator = new ClassMethods();
if ($paging) {
// create a new result set based on the Lead entity
$resultSet = new HydratingResultSet($hydrator, $entityPrototype);
$paginatorAdapter = new DbSelect($select, $this->dbAdapter, $resultSet);
$paginator = new Paginator($paginatorAdapter);
return $paginator;
}
$resultset = new HydratingResultSet($hydrator, $entityPrototype);
$statement = $this->sql->prepareStatementForSqlObject($select);
$results = $statement->execute();
$resultset->initialize($results);
return $resultset;
}
