public function getServiceConfig() { return array('factories' => array('Application\\Model\\LoginTable' => function ($sm) { $loginGateway = $sm->get('LoginTableGateway'); $table = new LoginTable($loginGateway); return $table; }, 'LoginTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new Login()); return new TableGateway('login', $dbAdapter, null, $resultSetProtype); }, 'Application\\Model\\PortfolioTable' => function ($sm) { $portfolioGateway = $sm->get('PortfolioTableGateway'); $table = new PortfolioTable($portfolioGateway); return $table; }, 'PortfolioTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new Portfolio()); return new TableGateway('portfolio', $dbAdapter, null, $resultSetProtype); }, 'Application\\Model\\FotosTable' => function ($sm) { $fotosGateway = $sm->get('FotosTableGateway'); $table = new FotosTable($fotosGateway); return $table; }, 'FotosTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new Fotos()); return new TableGateway('fotos', $dbAdapter, null, $resultSetProtype); })); }
public function getServiceConfig() { return array('factories' => array('Application\\Model\\KategorieTable' => function ($sm) { $tableGateway = $sm->get('KategorieTableGateway'); $table = new KategorieTable($tableGateway); return $table; }, 'KategorieTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Kategorie()); return new TableGateway('kategorie', $dbAdapter, null, $resultSetPrototype); }, 'Application\\Model\\UserTable' => function ($sm) { $tableGateway = $sm->get('UserTableGateway'); $table = new UserTable($tableGateway); return $table; }, 'UserTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new User()); return new TableGateway('uzivatele', $dbAdapter, null, $resultSetPrototype); }, 'Application\\Model\\BannerTable' => function ($sm) { $tableGateway = $sm->get('BannerTableGateway'); $table = new BannerTable($tableGateway); return $table; }, 'BannerTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Banner()); return new TableGateway('banner', $dbAdapter, null, $resultSetPrototype); })); }
public function getServiceConfig() { return array('factories' => array('Application\\Model\\StateTable' => function ($sm) { $tableGateway = $sm->get('StateTableGateway'); $table = new StateTable($tableGateway); return $table; }, 'StateTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new State()); return new TableGateway(DB_PREFIX . 'state', $dbAdapter, null, $resultSetPrototype); }, 'Application\\Model\\CityTable' => function ($sm) { $tableGateway = $sm->get('CityTableGateway'); $table = new CityTable($tableGateway); return $table; }, 'CityTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new City()); return new TableGateway(DB_PREFIX . 'city', $dbAdapter, null, $resultSetPrototype); }, 'Application\\Model\\PostMerchandiseTable' => function ($sm) { $tableGateway = $sm->get('PostMerchandiseTableGateway'); $table = new PostMerchandiseTable($tableGateway); return $table; }, 'PostMerchandiseTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Post()); return new TableGateway(DB_PREFIX . 'post_merchandise', $dbAdapter, null, $resultSetPrototype); })); }
public function getServiceConfig() { return array('factories' => array('Usuario\\Model\\UsuarioTable' => function ($sm) { $tableGateway = $sm->get('UsuarioTableGateway'); $table = new UsuarioTable($tableGateway); return $table; }, 'UsuarioTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Usuario()); return new TableGateway('ta_usuario', $dbAdapter, null, $resultSetPrototype); }, 'Usuario\\Model\\Cliente' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $table = new Cliente($dbAdapter); return $table; }, 'Usuario\\Model\\ComentariosTable' => function ($sm) { $tableGateway = $sm->get('ComentariosTableGateway'); $table = new Model\ComentariosTable($tableGateway); return $table; }, 'ComentariosTableGateway' => function ($sm) { $dbAdapte = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Comentarios()); return new TableGateway('ta_comentario', $dbAdapte, null, $resultSetPrototype); }, 'Usuario\\Model\\ClientesTable' => function ($sm) { $tableGateway = $sm->get('ClientesTableGateway'); $table = new Model\ClientesTable($tableGateway); return $table; }, 'ClientesTableGateway' => function ($sm) { $dbAdapte = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Clientes()); return new TableGateway('ta_cliente', $dbAdapte, null, $resultSetPrototype); })); }
public function getServiceConfig() { return array('initializers' => array(function ($instance, $sm) { if ($instance instanceof \Zend\Db\Adapter\AdapterAwareInterface) { $instance->setDbAdapter($sm->get('Zend\\Db\\Adapter\\Adapter')); } }), 'factories' => array('InvoiceTable' => function ($sm) { $tableGateway = $sm->get('InvoiceTableGateway'); $table = new InvoiceTable($tableGateway); return $table; }, 'InvoiceTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Invoice()); return new TableGateway('invoice', $dbAdapter, null, $resultSetPrototype); }, 'Invoice\\Model\\OderTable' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $table = new OderTable($dbAdapter); return $table; }, 'Invoice\\Model\\OderdetailTable' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $table = new OderdetailTable($dbAdapter); return $table; })); }
public function getServiceConfig() { return array('factories' => array('Application\\Model\\PaymentTable' => function ($sm) { $tableGateway = $sm->get('PaymentTableGateway'); $table = new PaymentTable($tableGateway); return $table; }, 'PaymentTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Payment()); return new TableGateway('payments_history', $dbAdapter, null, $resultSetPrototype); }, 'Application\\Model\\HuntClubTable' => function ($sm) { $tableGateway = $sm->get('HuntClubTableGateway'); $table = new HuntClubTable($tableGateway); return $table; }, 'HuntClubTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new HuntClub()); return new TableGateway('hunt_clubs', $dbAdapter, null, $resultSetPrototype); }, 'Application\\Model\\HuntClubGameTable' => function ($sm) { $tableGateway = $sm->get('HuntClubGameTableGateway'); $table = new HuntClubGameTable($tableGateway); return $table; }, 'HuntClubGameTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new HuntClubGame()); return new TableGateway('hunt_club_game', $dbAdapter, null, $resultSetPrototype); })); }
public function getUsersAndAbove(bool $paginated, $name = '', $roles = []) { $select = new Select('account'); $where = new Where(); if ($roles) { $sub = $where->nest(); for ($i = 0; $i < count($roles); $i++) { $sub->equalTo('role', $roles[$i]); if ($i < count($roles) - 1) { $sub->or; } } $sub->unnest(); } else { $where->greaterThan('role', '0'); $where->lessThan('role', '32'); } if ($name) { $where->like('name', '%' . $name . '%'); } $select->where($where)->order('name ASC'); if ($paginated) { $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Account()); $paginatorAdapter = new DbSelect($select, $this->tableGateway->getAdapter(), $resultSetPrototype); return new Paginator($paginatorAdapter); } return $this->tableGateway->select($select); }
public function fetchAll($request, $paginated = false) { if ($paginated) { // create a new Select object for the table album $select = new Select('album'); $select->order($request['sort'] . " " . $request['order']); // Search if ($request['search']) { $x = $request['search'] . '%'; $where = new \Zend\Db\Sql\Where(); $where->like('title', $x); $where->or->like('artist', $x); $select->where($where); } // New result set based on the Album entity $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Album()); // New pagination adapter object $paginatorAdapter = new DbSelect($select, $this->tableGateway->getAdapter(), $resultSetPrototype); $paginator = new Paginator($paginatorAdapter); return $paginator; } $resultSet = $this->tableGateway->select(); return $resultSet; }
public function getServiceConfig() { return array('factories' => array('Forum\\Model\\ThreadList' => function ($sm) { $tableGateway = $sm->get('ThreadListGateway'); $table = new ThreadList($tableGateway); return $table; }, 'ThreadListGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Thread()); return new TableGateway('forum', $dbAdapter, null, $resultSetPrototype); }, 'Forum\\Model\\PostList' => function ($sm) { $tableGateway = $sm->get('PostListGateway'); $table = new PostList($tableGateway); return $table; }, 'PostListGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Post()); return new TableGateway('posts', $dbAdapter, null, $resultSetPrototype); }, 'Forum\\Model\\UserList' => function ($sm) { $tableGateway = $sm->get('UserListGateway'); $table = new UserList($tableGateway); return $table; }, 'UserListGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new User()); return new TableGateway('users', $dbAdapter, null, $resultSetPrototype); })); }
/** * @param string $name * @param DataModelInterface $model * * @return null|MongoGateway * @throws \Exception */ public function getGateway($name, DataModelInterface $model = null) { if ($model == null) { throw new \Exception(' Raw Gateway needs a DataModelInterface instance as the second parameter '); } $adapterConfig = $this->getConfig($model); $gwName = Arr::getDoubtField($adapterConfig, 'gateway', null); if ($gwName === null) { $gwName = Arr::getDoubtField($adapterConfig, 'driver', null); } if ($gwName === null) { throw new \Exception('Unknown gateway'); } // create resultSet prototype $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype($model); // create custom transport for the model $dbAdapter = $this->getServiceLocator()->get($model->_adapter); // use general gw class if ($gwName == 'Pdo') { throw new \Exception(' TODO: Needs to implement PDO Gateway create !! '); } $gw = Obj::create('\\ModelFramework\\GatewayService\\MongoGateway', ['table' => $model->getTableName(), 'adapter' => $dbAdapter, 'resultSetPrototype' => $resultSetPrototype]); return $gw; }
public function createService(ServiceLocatorInterface $serviceLocator) { $dbAdapter = $serviceLocator->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Product()); return new TableGateway('table_product', $dbAdapter, null, $resultSetPrototype); }
public function getServiceConfig() { return array('factories' => array('Admin\\Model\\AdminTable' => function ($sm) { $tableGateway = $sm->get('AdminTableGateway'); $table = new AdminTable($tableGateway); return $table; }, 'AdminTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Admin()); return new TableGateway('admin', $dbAdapter, null, $resultSetPrototype); }, 'Admin\\Model\\PlayerTable' => function ($sm) { $tableGateway = $sm->get('PlayerTableGateway'); $table = new PlayerTable($tableGateway); return $table; }, 'PlayerTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Player()); return new TableGateway('player', $dbAdapter, null, $resultSetPrototype); }, 'Admin\\Model\\MyAuthStorage' => function ($sm) { return new \Admin\Model\MyAuthStorage('adminstore'); }, 'AuthService' => function ($sm) { //My assumption, you've alredy set dbAdapter //and has users table with columns : user_name and pass_word //that password hashed with md5 $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $dbTableAuthAdapter = new DbTableAuthAdapter($dbAdapter, 'admin', 'email', 'password', 'MD5(?)'); $authService = new AuthenticationService(); $authService->setAdapter($dbTableAuthAdapter); $authService->setStorage($sm->get('Admin\\Model\\MyAuthStorage')); return $authService; })); }
public function __construct(DBEntity $object, AdapterInterface $adapter, $features = null) { $this->object = $object; $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype($object); parent::__construct($object->getTableName(), $adapter, $features, $resultSetPrototype); }
public function getServiceConfig() { return array('factories' => array('Pizza\\Model\\PizzaTable' => function ($sm) { $tableGateway = $sm->get('PizzaTableGateway'); $table = new PizzaTable($tableGateway); return $table; }, 'PizzaTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Pizza()); return new TableGateway('pizza', $dbAdapter, null, $resultSetPrototype); }, 'Pizza\\Model\\SandwichTable' => function ($sm) { $tableGateway = $sm->get('SandwichTableGateway'); $table = new SandwichTable($tableGateway); return $table; }, 'SandwichTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Sandwich()); return new TableGateway('sandwich', $dbAdapter, null, $resultSetPrototype); }, 'Pizza\\Model\\DrinkTable' => function ($sm) { $tableGateway = $sm->get('DrinkTableGateway'); $table = new DrinkTable($tableGateway); return $table; }, 'DrinkTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Drink()); return new TableGateway('drink', $dbAdapter, null, $resultSetPrototype); })); }
/** * Expected to return \Zend\ServiceManager\Config object or array to * seed such an object. * * @return array|\Zend\ServiceManager\Config */ public function getServiceConfig() { return ['factories' => ['ArticleTable' => function (ServiceLocatorInterface $sm) { $tableGateway = $sm->get('ArticleTableGateway'); $table = new ArticleTable($tableGateway); return $table; }, 'ArticleTableGateway' => function (ServiceLocatorInterface $sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Article()); return new TableGateway('tbl_article', $dbAdapter, null, $resultSetPrototype); }, 'UserTable' => function (ServiceLocatorInterface $sm) { $tableGateway = $sm->get('UserTableGateway'); $table = new UserTable($tableGateway); return $table; }, 'UserTableGateway' => function (ServiceLocatorInterface $sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new User()); return new TableGateway('tbl_user', $dbAdapter, null, $resultSetPrototype); }, 'Smarty' => function (ServiceLocatorInterface $sm) { $smarty = new MySmarty(); $smarty->debugging = false; $smarty->caching = false; $smarty->cache_lifetime = 120; $smarty->setTemplateDir(__DIR__ . '/view/smarty/templates'); $smarty->setConfigDir(__DIR__ . '/view/smarty/configs'); $smarty->setCompileDir(__DIR__ . '/view/smarty/templates_c'); $smarty->setCacheDir(__DIR__ . '/view/smarty/cache'); return $smarty; }]]; }
public function createService(ServiceLocatorInterface $sm) { $dbAdapter = $sm->get('db-adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Country()); return new TableGateway("pays", $dbAdapter, null, $resultSetPrototype); }
public function getServiceConfig() { return array('factories' => array('User\\Model\\UserTable' => function ($sm) { $tableGateway = $sm->get('UserTableGateway'); $table = new UserTable($tableGateway); return $table; }, 'UserTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new User()); return new TableGateway('user', $dbAdapter, null, $resultSetPrototype); }, 'User\\Model\\CityTable' => function ($sm) { $tableGateway = $sm->get('CityTableGateway'); $table = new CityTable($tableGateway); return $table; }, 'CityTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new City()); return new TableGateway('city', $dbAdapter, null, $resultSetPrototype); }, 'User\\Model\\EducationTable' => function ($sm) { $tableGateway = $sm->get('EducationTableGateway'); $table = new EducationTable($tableGateway); return $table; }, 'EducationTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Education()); return new TableGateway('educations', $dbAdapter, null, $resultSetPrototype); })); }
public function fetchAll($paginate = true, $Flag = false, $user_id = '') { if ($paginate) { $select = new Select('messages'); $select->columns(array('*', new Expression("from_user.user_name as from_user, to_user.user_name as to_user"))); $select->join(array('from_user' => 'users'), 'from_user.id = messages.from_user_id', array(), 'left'); $select->join(array('to_user' => 'users'), 'to_user.id = messages.to_user_id', array(), 'left'); if ($Flag == "trash") { $select->where(array('deleteFlag' => '1')); $select->order('created_date ASC'); } else { if ($Flag == "outbox") { $select->where(array('from_user_id' => $user_id, 'deleteFlag' => '0')); $select->order('created_date ASC'); } else { if ($Flag == "inbox") { $select->where('to_user_id = ' . $user_id . ' AND deleteFlag = 0'); $select->order('created_date ASC'); } } } $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Messages()); $paginatorAdapter = new DbSelect($select, $this->tableGateway->getAdapter(), $resultSetPrototype); $paginator = new Paginator($paginatorAdapter); return $paginator; } return $this->tableGateway->select(); }
public function getServiceConfig() { return array('factories' => array('Api\\Model\\GroupsTable' => function ($sm) { $tableGateway = $sm->get('GroupsTableGateway'); $table = new GroupsTable($tableGateway); return $table; }, 'GroupsTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Group()); return new TableGateway('groups', $dbAdapter, null, $resultSetPrototype); }, 'Api\\Model\\UsersTable' => function ($sm) { $tableGateway = $sm->get('UsersTableGateway'); $table = new UsersTable($tableGateway); return $table; }, 'UsersTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new User()); return new TableGateway('users', $dbAdapter, null, $resultSetPrototype); }, 'Api\\Model\\UsersToGroupsTable' => function ($sm) { $tableGateway = $sm->get('UsersToGroupsTableGateway'); $table = new UsersToGroupsTable($tableGateway); return $table; }, 'UsersToGroupsTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new UserToGroup()); return new TableGateway('users_to_groups', $dbAdapter, null, $resultSetPrototype); })); }
public function getServiceConfig() { return ['factories' => ['MailOptions' => 'Base\\Service\\Factory\\MailOptions', 'CommunityTable' => function (ServiceLocatorInterface $sm) { $tableGateway = $sm->get('CommunityTableGateway'); $table = new CommunityTable($tableGateway); return $table; }, 'CommunityTableGateway' => function (ServiceLocatorInterface $sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Community()); return new TableGateway('tbl_community', $dbAdapter, null, $resultSetPrototype); }, 'ReleaseOrderTable' => function (ServiceLocatorInterface $sm) { $tableGateway = $sm->get('ReleaseOrderTableGateway'); $table = new ReleaseOrderTable($tableGateway); return $table; }, 'ReleaseOrderTableGateway' => function (ServiceLocatorInterface $sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new ReleaseOrder()); return new TableGateway('tbl_release_order', $dbAdapter, null, $resultSetPrototype); }, 'YqClassTable' => function (ServiceLocatorInterface $sm) { $tableGateway = $sm->get('YqClassTableGateway'); $table = new YqClassTable($tableGateway); return $table; }, 'YqClassTableGateway' => function (ServiceLocatorInterface $sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new YqClass()); return new TableGateway('tbl_yq_class', $dbAdapter, null, $resultSetPrototype); }, 'redis-cli' => 'Base\\Service\\Factory\\RedisFactory'], 'invokables' => ['LongDai' => 'Base\\Service\\LongDaiService']]; }
public function getServiceConfig() { return array('initializers' => array(function ($instance, $sm) { if ($instance instanceof \Zend\Db\Adapter\AdapterAwareInterface) { $instance->setDbAdapter($sm->get('Zend\\Db\\Adapter\\Adapter')); } }), 'factories' => array('ProductTable' => function ($sm) { $tableGateway = $sm->get('ProductTableGateway'); $table = new ProductTable($tableGateway); return $table; }, 'ProductTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Product()); return new TableGateway('product', $dbAdapter, null, $resultSetPrototype); }, 'NameTable' => function ($sm) { $tableGateway = $sm->get('NameTableGateway'); $table = new NameTable($tableGateway); return $table; }, 'NameTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Name()); return new TableGateway('name', $dbAdapter, null, $resultSetPrototype); }, 'DeclarationTable' => function ($sm) { $tableGateway = $sm->get('DeclarationTableGateway'); $table = new DeclarationTable($tableGateway); return $table; }, 'DeclarationTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Declaration()); return new TableGateway('declaration', $dbAdapter, null, $resultSetPrototype); })); }
public function getServiceConfig() { return array('factories' => array('Myworkapp\\Model\\TaskTable' => function ($sm) { $tableGateway = $sm->get('TaskTableGateway'); $table = new TaskTable($tableGateway); return $table; }, 'TaskTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Task()); return new TableGateway('tasks', $dbAdapter, null, $resultSetPrototype); }, 'Myworkapp\\Model\\TaskTypeTable' => function ($sm) { $tableGateway = $sm->get('TaskTypeTableGateway'); $table = new TaskTypeTable($tableGateway); return $table; }, 'TaskTypeTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new TaskType()); return new TableGateway('task_types', $dbAdapter, null, $resultSetPrototype); }, 'Myworkapp\\Model\\EmployeeTable' => function ($sm) { $tableGateway = $sm->get('EmployeeTableGateway'); $table = new EmployeeTable($tableGateway); return $table; }, 'EmployeeTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Employee()); return new TableGateway('employers', $dbAdapter, null, $resultSetPrototype); })); }
public function getServiceConfig() { return array('factories' => array('Application\\Model\\CertificateTable' => function ($sm) { $tableGateway = $sm->get('CertificateTableGateway'); $table = new CertificateTable($tableGateway); return $table; }, 'CertificateTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); return new TableGateway('certificates', $dbAdapter); }, 'Application\\Model\\DocumentTable' => function ($sm) { $tableGateway = $sm->get('DocumentTableGateway'); $table = new DocumentTable($tableGateway); return $table; }, 'DocumentTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Document()); return new TableGateway('documents', $dbAdapter, null, $resultSetPrototype); }, 'Application\\Model\\PriceHistoryTable' => function ($sm) { $tableGateway = $sm->get('PriceHistoryTableGateway'); $table = new PriceHistoryTable($tableGateway); return $table; }, 'PriceHistoryTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new PriceHistory()); return new TableGateway('price_history', $dbAdapter, null, $resultSetPrototype); })); }
public function fetchAll($paginate = true, $filter = array(), $orderBy = array()) { if ($paginate) { $select = new Select('service_language'); $select->join('lookup_status', 'lookup_status.status_id = service_language.status_id', array('status'), 'left'); /* Data filter code start here*/ if (count($filter) > 0) { $filter['language_name'] != "" ? $select->where("service_language.language_name LIKE '%" . $filter['language_name'] . "%'") : ""; $filter['status_id'] != "" ? $select->where("service_language.status_id = " . $filter['status_id']) : ""; } /* Data filter code end here*/ /* Data sorting code starts here */ if (count($orderBy) > 0 && $orderBy['sort_field'] != '' && $orderBy['sort_order'] != '') { switch ($orderBy['sort_field']) { case 'language': $select->order('service_language.language_name ' . $orderBy['sort_order']); break; case 'status': $select->order('lookup_status.status ' . $orderBy['sort_order']); break; } } /* Data sorting code ends here */ $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new ServiceLanguages()); $paginatorAdapter = new DbSelect($select, $this->tableGateway->getAdapter(), $resultSetPrototype); $paginator = new Paginator($paginatorAdapter); return $paginator; } return $this->tableGateway->select(); }
protected function setUp() { $bootstrap = \Zend\Mvc\Application::init(include 'config/application.config.php'); $categoryData = array('id_category' => 1, 'name' => 'Project Manager'); $category = new Category(); $category->exchangeArray($categoryData); $resultSetCategory = new ResultSet(); $resultSetCategory->setArrayObjectPrototype(new Category()); $resultSetCategory->initialize(array($category)); $mockCategoryTableGateway = $this->getMock('Zend\\Db\\TableGateway\\TableGateway', array('select'), array(), '', false); $mockCategoryTableGateway->expects($this->any())->method('select')->with()->will($this->returnValue($resultSetCategory)); $categoryTable = new CategoryTable($mockCategoryTableGateway); $jobData = array('id_job' => 1, 'id_category' => 1, 'type' => 'typeTest', 'company' => 'companyTest', 'logo' => 'logoTest', 'url' => 'urlTest', 'position' => 'positionTest', 'location' => 'locaitonTest', 'description' => 'descriptionTest', 'how_to_play' => 'hotToPlayTest', 'is_public' => 1, 'is_activated' => 1, 'email' => 'emailTest', 'created_at' => '2012-01-01 00:00:00', 'updated_at' => '2012-01-01 00:00:00'); $job = new Job(); $job->exchangeArray($jobData); $resultSetJob = new ResultSet(); $resultSetJob->setArrayObjectPrototype(new Job()); $resultSetJob->initialize(array($job)); $mockJobTableGateway = $this->getMock('Zend\\Db\\TableGateway\\TableGateway', array('select'), array(), '', false); $mockJobTableGateway->expects($this->any())->method('select')->with(array('id_category' => 1))->will($this->returnValue($resultSetJob)); $jobTable = new JobTable($mockJobTableGateway); $this->controller = new IndexController($categoryTable, $jobTable); $this->request = new Request(); $this->routeMatch = new RouteMatch(array('controller' => 'index')); $this->event = $bootstrap->getMvcEvent(); $this->event->setRouteMatch($this->routeMatch); $this->controller->setEvent($this->event); $this->controller->setEventManager($bootstrap->getEventManager()); $this->controller->setServiceLocator($bootstrap->getServiceManager()); }
public function __construct($db) { $this->db = $db; $resultSet = new ResultSet(); $resultSet->setArrayObjectPrototype(new ClienteEntity()); $this->tableGateway = new TableGateway('Cliente', $db, null, $resultSet); }
public function createService(ServiceLocatorInterface $serviceLocator) { $subject = $serviceLocator->get('Category\\Model\\Category'); $resultSet = new ResultSet(); $resultSet->setArrayObjectPrototype($subject); return $resultSet; }
public function getServiceConfig() { return array('factories' => array('StitchPattern\\Model\\StitchPatternTable' => function ($sm) { $tableGateway = $sm->get('StitchPatternTableGateway'); $table = new StitchPatternTable($tableGateway); return $table; }, 'StitchPatternTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new StitchPattern()); return new TableGateway('stitchpattern', $dbAdapter, null, $resultSetPrototype); }, 'StitchPattern\\Model\\EmulatorBridge' => function ($sm) { $emulator = new EmulatorBridge(); return $emulator; }, 'StitchPattern\\Model\\USBCableTable' => function ($sm) { $tableGateway = $sm->get('USBCableTableGateway'); $table = new USBCableTable($tableGateway); return $table; }, 'USBCableTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new USBCable()); return new TableGateway('usbcable', $dbAdapter, null, $resultSetPrototype); })); }
public function getServiceConfig() { return array('factories' => array('Application\\Model\\BookTable' => function ($sm) { $tableGateway = $sm->get('BookTableGateway'); $table = new BookTable($tableGateway); return $table; }, 'BookTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Book()); return new TableGateway('books', $dbAdapter, null, $resultSetPrototype); }, 'Application\\Model\\GenreTable' => function ($sm) { $tableGateway = $sm->get('GenreTableGateway'); $table = new GenreTable($tableGateway); return $table; }, 'GenreTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Genre()); return new TableGateway('genres', $dbAdapter, null, $resultSetPrototype); }, 'Application\\Model\\AuthorTable' => function ($sm) { $tableGateway = $sm->get('AuthorTableGateway'); $table = new AuthorTable($tableGateway); return $table; }, 'AuthorTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Author()); return new TableGateway('authors', $dbAdapter, null, $resultSetPrototype); })); }
public function getServiceConfig() { return array('factories' => array('Application\\Model\\LoginTable' => function ($sm) { $tableGateway = $sm->get('LoginTableGateway'); $table = new LoginTable($tableGateway); return $table; }, 'LoginTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Login()); return new TableGateway('users', $dbAdapter, null, $resultSetPrototype); }, 'Application\\Model\\JobsTable' => function ($sm) { $tableGateway = $sm->get('JobsTableGateway'); $table = new JobsTable($tableGateway); return $table; }, 'JobsTableGateway' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Job()); return new TableGateway('jobs', $dbAdapter, null, $resultSetPrototype); }, 'LoginAuthAdapter' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); return new AuthAdapter($dbAdapter, 'users', 'username', 'password'); }, 'AuthStatus' => function ($sm) { $dbAdapter = $sm->get('Zend\\Db\\Adapter\\Adapter'); $authAdapter = new AuthAdapter($dbAdapter, 'users', 'username', 'password'); $authStatus = new AuthenticationService(); $authStatus->setAdapter($authAdapter); return $authStatus; })); }