/**
* @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)
{
$subject = $serviceLocator->get('Category\\Model\\Category');
$resultSet = new ResultSet();
$resultSet->setArrayObjectPrototype($subject);
return $resultSet;
}
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('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;
}));
}
/**
* Get time zones
*
* @return array
*/
public function getTimeZones()
{
// check data in a memory
if (null !== self::$timeZones) {
return self::$timeZones;
}
// generate a cache name
$cacheName = CacheUtility::getCacheName(self::CACHE_TIME_ZONES);
// check data in cache
if (null === ($timeZones = $this->staticCacheInstance->getItem($cacheName))) {
$select = $this->select();
$select->from('application_time_zone')->columns(['id', 'name'])->order('name');
$statement = $this->prepareStatementForSqlObject($select);
$resultSet = new ResultSet();
$resultSet->initialize($statement->execute());
foreach ($resultSet as $timeZone) {
$timeZones[$timeZone->id] = $timeZone->name;
}
// save data in cache
$this->staticCacheInstance->setItem($cacheName, $timeZones);
$this->staticCacheInstance->setTags($cacheName, [self::CACHE_TIME_ZONES_DATA_TAG]);
}
self::$timeZones = $timeZones;
return $timeZones;
}
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);
}));
}
/**
* Get menu
*
* @return array
*/
public function getMenu()
{
// generate cache name
$cacheName = CacheUtility::getCacheName(self::CACHE_ADMIN_MENU);
// check data in cache
if (null === ($menu = $this->staticCacheInstance->getItem($cacheName))) {
$select = $this->select();
$select->from(['a' => 'application_admin_menu'])->columns(['name', 'controller', 'action'])->join(['b' => 'application_admin_menu_category'], 'a.category = b.id', ['category' => 'name', 'category_icon' => 'icon'])->join(['c' => 'application_admin_menu_part'], 'a.part = c.id', ['part' => 'name', 'part_icon' => 'icon'])->join(['d' => 'application_module'], new Expression('c.module = d.id and d.status = ?', [self::MODULE_STATUS_ACTIVE]), ['part_module' => 'name'])->join(['i' => 'application_module'], new Expression('b.module = i.id and i.status = ?', [self::MODULE_STATUS_ACTIVE]), ['category_module' => 'name'])->order('order');
$statement = $this->prepareStatementForSqlObject($select);
$resultSet = new ResultSet();
$resultSet->initialize($statement->execute());
// process admin menu
foreach ($resultSet as $menuItem) {
if (!isset($menu[$menuItem['part']])) {
$menu[$menuItem['part']] = ['part' => $menuItem['part'], 'icon' => $menuItem['part_icon'], 'module' => $menuItem['part_module'], 'items' => [0 => ['name' => $menuItem['name'], 'controller' => $menuItem['controller'], 'action' => $menuItem['action'], 'category' => $menuItem['category'], 'category_icon' => $menuItem['category_icon'], 'category_module' => $menuItem['category_module']]]];
} else {
$menu[$menuItem['part']]['items'][] = ['name' => $menuItem['name'], 'controller' => $menuItem['controller'], 'action' => $menuItem['action'], 'category' => $menuItem['category'], 'category_icon' => $menuItem['category_icon'], 'category_module' => $menuItem['category_module']];
}
}
// save data in cache
$this->staticCacheInstance->setItem($cacheName, $menu);
$this->staticCacheInstance->setTags($cacheName, [self::CACHE_ADMIN_MENU_DATA_TAG]);
}
return $menu;
}
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('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 createService(ServiceLocatorInterface $sm)
{
$dbAdapter = $sm->get('db-adapter');
$resultSetPrototype = new ResultSet();
$resultSetPrototype->setArrayObjectPrototype(new Country());
return new TableGateway("pays", $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('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);
}));
}
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 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('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 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();
}
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 indexAction()
{
$session = new Container('admin');
if ($session->offsetExists('email')) {
//Prepare statistique information pour la vue Index ->des statistiques
$adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter');
$sql1 = "select * from pro_product_bdma";
$statement1 = $adapter->query($sql1);
$results1 = $statement1->execute();
$row1 = $results1->current();
//tester si les variables rouX ont bien remplis
if (!$row1) {
//redirection vers l'index avec un message GET var
$this->redirect()->toRoute('product', array('action' => 'index'), array('query' => array('status' => 'erreur_fetching_view_data')));
} else {
// 2 preparation des donnees result sett , retourne un mass d'information
if ($results1 instanceof ResultInterface && $results1->isQueryResult()) {
//instanciation de la class result set pour l'enregistrement des information fournis par la BD
$resultSet = new ResultSet();
$resultSet->initialize($results1);
// redirection vers la vue index avec les information des statistiques
return new ViewModel(array('data' => $resultSet));
}
}
} else {
$this->redirect()->toRoute('admin', array('action' => 'login'), array('query' => array('status' => 'u_login')));
}
}
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 __construct($db)
{
$this->db = $db;
$resultSet = new ResultSet();
$resultSet->setArrayObjectPrototype(new ClienteEntity());
$this->tableGateway = new TableGateway('Cliente', $db, null, $resultSet);
}
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 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);
}));
}
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());
}
/**
* 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 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('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 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('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 indexAction()
{
// instansiation d'une session d'admin (duré = 30 Jrs)
$session = new Container('useradmin');
// tester si une session 'email existe '
if ($session->offsetExists('uid') && $session->offsetExists('ucomp') && $session->offsetGet('user') == 'user') {
//Prepare statistique information pour la vue Index ->des statistiques
$adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter');
$cmpny = $session->offsetGet('ucomp');
$sql1 = "select `id`, `gender`,`company`, `name`, `firstname`, `email`, `lang`, `phone`, `gsm` from pro_user where company='" . $cmpny . "' and active=1";
$statement1 = $adapter->query($sql1);
$results1 = $statement1->execute();
$row1 = $results1->current();
//tester si les variables rouX ont bien remplis
if (!$row1) {
//redirection vers l'index avec un message GET var
$this->redirect()->toRoute('useradmin', array('action' => 'index'), array('query' => array('status' => 'erreur_fetching_view_data')));
} else {
// 2 preparation des donnees result sett , retourne un mass d'information
if ($results1 instanceof ResultInterface && $results1->isQueryResult()) {
//instanciation de la class result set pour l'enregistrement des information fournis par la BD
$resultSet = new ResultSet();
$resultSet->initialize($results1);
// redirection vers la vue index avec les information des statistiques
return new ViewModel(array('data' => $resultSet));
}
}
} else {
//si la session n'existe pas ,, donc la redirection vers login page pour l'authentification avec un petit message
$this->redirect()->toRoute('useradmin', array('action' => 'loginuser'), array('query' => array('status' => 'u_login')));
}
}
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;
}));
}
